OfficeRkIndex.cshtml 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231
  1. @{;
  2. ViewBag.Title = "列表页面";
  3. Layout = "~/Views/Shared/_Index.cshtml";
  4. }
  5. <script>
  6. ;
  7. $(function () {
  8. InitialPage();
  9. GetGrid();
  10. });
  11. //初始化页面
  12. function InitialPage() {
  13. //resize重设布局;
  14. $(window).resize(function (e) {
  15. window.setTimeout(function () {
  16. $('#gridTable').setGridWidth(($('.gridPanel').width()));
  17. $('#gridTable').setGridHeight($(window).height() - 136.5);
  18. }, 200);
  19. e.stopPropagation();
  20. });
  21. }
  22. //加载表格
  23. function GetGrid() {
  24. var selectedRowIndex = 0;
  25. var $gridTable = $('#gridTable');
  26. $gridTable.jqGrid({
  27. autowidth: true,
  28. height: $(window).height() - 136.5,
  29. url: "../../DemoManage/OfficeRk/GetPageListJson",
  30. datatype: "json",
  31. colModel: [
  32. { label: '订单主键', name: 'OrderId', index: 'OrderId', width: 80, align: '', sortable: true, hidden: true },
  33. { label: '客户id', name: 'GysId', index: 'GysId', width: 100, align: '', sortable: true },
  34. { label: '客户名称', name: 'GysName', index: 'GysName', width: 120, align: '', sortable: true },
  35. { label: '销售人员Id', name: 'SellerId', index: 'SellerId', width: 120, align: '', sortable: true },
  36. { label: '销售人员', name: 'SellerName', index: 'SellerName', width: 80, align: '', sortable: true },
  37. {
  38. label: '单据日期', name: 'RkDate', index: 'RkDate', width: 90, align: '', sortable: true,
  39. formatter: "date", formatoptions: { newformat: 'Y-m-d' }
  40. },
  41. { label: '单据编号', name: 'RkCode', index: 'RkCode', width: 90, align: '', sortable: true },
  42. { label: '应收金额', name: 'Accounts', index: 'Accounts', width: 90, align: '', sortable: true },
  43. { label: '摘要信息', name: 'AbstractInfo', index: 'AbstractInfo', width: 90, align: '', sortable: true },
  44. { label: '删除标记', name: 'DeleteMark', index: 'DeleteMark', width: 90, align: '', sortable: true, hidden: true },
  45. { label: '有效标志', name: 'EnabledMark', index: 'EnabledMark', width: 90, align: '', sortable: true, hidden: true },
  46. {
  47. label: '创建日期', name: 'CreateDate', index: 'CreateDate', width: 90, align: '', sortable: true,
  48. formatter: "date", formatoptions: { newformat: 'Y-m-d' }
  49. },
  50. { label: '创建用户主键', name: 'CreateUserId', index: 'CreateUserId', width: 90, align: '', sortable: true, hidden: true },
  51. { label: '创建用户', name: 'CreateUserName', index: 'CreateUserName', width: 90, align: '', sortable: true },
  52. {
  53. label: '修改日期', name: 'ModifyDate', index: 'ModifyDate', width: 90, align: '', sortable: true,
  54. formatter: "date", formatoptions: { newformat: 'Y-m-d' }
  55. },
  56. { label: '修改用户主键', name: 'ModifyUserId', index: 'ModifyUserId', width: 90, align: '', sortable: true, hidden: true },
  57. { label: '修改用户', name: 'ModifyUserName', index: 'ModifyUserName', width: 90, align: '', sortable: true },
  58. { label: '备注', name: 'Description', index: 'Description', width: 90, align: '', sortable: true }
  59. ],
  60. viewrecords: true,
  61. rowNum: 30,
  62. rowList: [30, 50, 100],
  63. pager: "#gridPager",
  64. sortname: 'OrderId',
  65. sortorder: 'desc',
  66. rownumbers: true,
  67. shrinkToFit: false,
  68. gridview: true,
  69. onSelectRow: function () {
  70. selectedRowIndex = $('#' + this.id).getGridParam('selrow');
  71. },
  72. gridComplete: function () {
  73. $('#' + this.id).setSelection(selectedRowIndex, false);
  74. },
  75. subGrid: true,
  76. subGridRowExpanded: function (subgrid_id, row_id) {
  77. var keyValue = $gridTable.jqGrid('getRowData', row_id)['OrderId'];
  78. var subgrid_table_id = subgrid_id + "_t";
  79. $("#" + subgrid_id).html("<table id='" + subgrid_table_id + "'></table>");
  80. $("#" + subgrid_table_id).jqGrid({
  81. url: "../../DemoManage/OfficeRk/GetDetailsJson",
  82. postData: { keyValue: keyValue },
  83. datatype: "json",
  84. height: "100%",
  85. colModel: [
  86. { label: '订单明细主键', name: 'RkEntryId', index: 'RkEntryId', width: 80, align: '', sortable: true, hidden: true },
  87. { label: '订单主键', name: 'OrderId', index: 'OrderId', width: 80, align: '', sortable: true, hidden: true },
  88. { label: '商品Id', name: 'ProductId', index: 'ProductId', width: 80, align: '', sortable: true },
  89. { label: '商品编号', name: 'ProductCode', index: 'ProductCode', width: 80, align: '', sortable: true },
  90. { label: '商品名称', name: 'ProductName', index: 'ProductName', width: 80, align: '', sortable: true },
  91. { label: '单位', name: 'UnitId', index: 'UnitId', width: 80, align: '', sortable: true },
  92. { label: '数量', name: 'Qty', index: 'Qty', width: 80, align: '', sortable: true },
  93. { label: '单价', name: 'Price', index: 'Price', width: 80, align: '', sortable: true },
  94. { label: '金额', name: 'Amount', index: 'Amount', width: 80, align: '', sortable: true },
  95. { label: '排序码', name: 'SortCode', index: 'SortCode', width: 80, align: '', sortable: true, hidden: true },
  96. { label: '删除标记', name: 'DeleteMark', index: 'DeleteMark', width: 80, align: '', sortable: true, hidden: true },
  97. { label: '有效标志', name: 'EnabledMark', index: 'EnabledMark', width: 80, align: '', sortable: true, hidden: true },
  98. { label: '备注', name: 'Description', index: 'Description', width: 80, align: '', sortable: true },
  99. ],
  100. caption: "明细",
  101. rowNum: "1000",
  102. rownumbers: true,
  103. shrinkToFit: false,
  104. gridview: true,
  105. hidegrid: false
  106. });
  107. }
  108. });
  109. //查询条件
  110. $("#queryCondition .dropdown-menu li").click(function () {
  111. var text = $(this).find('a').html();
  112. var value = $(this).find('a').attr('data-value');
  113. $("#queryCondition .dropdown-text").html(text).attr('data-value', value)
  114. });
  115. //查询事件
  116. $("#btn_Search").click(function () {
  117. var queryJson = {
  118. condition: $("#queryCondition").find('.dropdown-text').attr('data-value'),
  119. keyword: $("#txt_Keyword").val()
  120. }
  121. $gridTable.jqGrid('setGridParam', {
  122. postData: { queryJson: JSON.stringify(queryJson) },
  123. page: 1
  124. }).trigger('reloadGrid');
  125. });
  126. //查询回车
  127. $('#txt_Keyword').bind('keypress', function (event) {
  128. if (event.keyCode == "13") {
  129. $('#btn_Search').trigger("click");
  130. }
  131. });
  132. }
  133. //新增
  134. function btn_add() {
  135. dialogOpen({
  136. id: 'Form',
  137. title: '添加订单',
  138. url: '/DemoManage/OfficeRk/OfficeRkForm',
  139. width: '1000px',
  140. height: '750px',
  141. callBack: function (iframeId) {
  142. top.frames[iframeId].AcceptClick();
  143. }
  144. });
  145. }
  146. //编辑
  147. function btn_edit() {
  148. var keyValue = $('#gridTable').jqGridRowValue('OrderId');
  149. if (checkedRow(keyValue)) {
  150. dialogOpen({
  151. id: 'Form',
  152. title: '编辑订单',
  153. url: '/DemoManage/OfficeRk/OfficeRkForm?keyValue=' + keyValue,
  154. width: '1000px',
  155. height: '750px',
  156. callBack: function (iframeId) {
  157. top.frames[iframeId].AcceptClick();
  158. }
  159. })
  160. }
  161. }
  162. //删除
  163. function btn_delete() {
  164. var keyValue = $('#gridTable').jqGridRowValue('OrderId');
  165. if (keyValue) {
  166. $.RemoveForm({
  167. url: '../../DemoManage/OfficeRk/RemoveForm',
  168. param: { keyValue: keyValue },
  169. success: function (data) {
  170. $('#gridTable').trigger('reloadGrid');
  171. }
  172. })
  173. } else {
  174. dialogMsg('请选择需要删除的OfficeRk!', 0);
  175. }
  176. }
  177. //详细
  178. function btn_details() {
  179. var keyValue = $('#gridTable').jqGridRowValue('OrderId');
  180. if (checkedRow(keyValue)) {
  181. dialogOpen({
  182. id: 'Form',
  183. title: '详细OfficeRk',
  184. url: '/DemoManage/OfficeRk/OfficeRkForm?keyValue=' + keyValue + '&isDeltail=true',
  185. width: '1000px',
  186. height: '750px',
  187. btn: null,
  188. callBack: function (iframeId) {
  189. top.frames[iframeId].AcceptClick();
  190. }
  191. })
  192. }
  193. }
  194. </script>
  195. <div class="titlePanel">
  196. <div class="title-search">
  197. <table>
  198. <tr>
  199. <td>
  200. <div id="queryCondition" class="btn-group">
  201. <a class="btn btn-default dropdown-text" data-toggle="dropdown">选择条件</a>
  202. <a class="btn btn-default dropdown-toggle" data-toggle="dropdown"><span class="caret"></span></a>
  203. <ul class="dropdown-menu">
  204. <li><a data-value="GysName">供应商名称</a></li>
  205. <li><a data-value="SellerName">销售人员</a></li>
  206. </ul>
  207. </div>
  208. </td>
  209. <td>
  210. <input id="txt_Keyword" type="text" class="form-control" placeholder="请输入要查询关键字" style="width: 200px;" />
  211. </td>
  212. <td style="padding-left: 5px;">
  213. <a id="btn_Search" class="btn btn-primary"><i class="fa fa-search"></i> 查询</a>
  214. </td>
  215. </tr>
  216. </table>
  217. </div>
  218. <div class="toolbar">
  219. <div class="btn-group">
  220. <a id="lr-replace" class="btn btn-default" onclick="reload()"><i class="fa fa-refresh"></i>刷新</a>
  221. <a id="lr-add" class="btn btn-default" onclick="btn_add()"><i class="fa fa-plus"></i>新增</a>
  222. <a id="lr-edit" class="btn btn-default" onclick="btn_edit()"><i class="fa fa-pencil-square-o"></i>编辑</a>
  223. <a id="lr-delete" class="btn btn-default" onclick="btn_delete()"><i class="fa fa-trash-o"></i>删除</a>
  224. <a id="lr-details" class="btn btn-default" onclick="btn_details()"><i class="fa fa-list-alt"></i>详细</a>
  225. </div>
  226. </div>
  227. </div>
  228. <div class="gridPanel">
  229. <table id="gridTable"></table>
  230. <div id="gridPager"></div>
  231. </div>