You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

252 lines
9.8 KiB

1 month ago
  1. 
  2. @{
  3. ViewBag.Title = "Index";
  4. Layout = "~/Views/Shared/_Index.cshtml";
  5. }
  6. <script>
  7. var _Clos = new Array();
  8. var STNO = $.request("STNO");
  9. var Vendor = $.request("VenCode");
  10. var WorkPoints = $.request("WorkPoint");
  11. $(function () {
  12. SetCols();
  13. gridList();
  14. })
  15. function SetCols() {
  16. debugger;
  17. $.ajax({
  18. url: "/SRM/PORelease/SelectColumnName?" + Math.random(),
  19. dataType: "json",
  20. async: false,
  21. success: function (data) {
  22. var cols = new Array();
  23. var collast = { label: "主键", name: "ID", hidden: true, key: true };
  24. cols.push(collast);
  25. var collast = { label: '采购订单号', name: 'POCode', width: 120, align: 'left' };
  26. cols.push(collast);
  27. var collast = { label: '行号', name: 'Sequence', width: 120, align: 'left' };
  28. cols.push(collast);
  29. var collast = { label: '物料编码', name: 'InvCode', width: 120, align: 'left' };
  30. cols.push(collast);
  31. var collast = { label: '物料名称', name: 'InvName', width: 120, align: 'left' };
  32. cols.push(collast);
  33. var collast = { label: '规格型号', name: 'InvStd', width: 120, align: 'left' };
  34. cols.push(collast);
  35. var collast = { label: '数量', name: 'Quantity', width: 120, align: 'left' };
  36. cols.push(collast);
  37. $.ajax({
  38. url: "/SRM/PORelease/SelectTableColumnName?" + Math.random(),
  39. dataType: "json",
  40. async: false,
  41. success: function (data) {
  42. if (data != null && data.length > 0) {
  43. DateList = data;
  44. for (var i = 0; i < data.length; i++) {
  45. var TableCode = data[i].TableCode;
  46. if (TableCode == "ICSPurchaseOrder") {
  47. var Code = data[i].Code;
  48. var Name = data[i].Name;
  49. var obj = new Array();
  50. obj = {
  51. label: Name,
  52. name: Code,
  53. width: 200,
  54. align: "left"
  55. }
  56. cols.push(obj);
  57. }
  58. }
  59. }
  60. _Closs = cols;
  61. //_Clos1 = cols1;
  62. }
  63. });
  64. if (data != null && data.length > 0) {
  65. DateList = data;
  66. for (var i = 0; i < data.length; i++) {
  67. var ColName = data[i].ColName;
  68. var ColCode = data[i].ColCode;
  69. var obj = new Array();
  70. obj = {
  71. label: ColName,
  72. name: ColCode,
  73. width: 80,
  74. align: "left"
  75. }
  76. cols.push(obj);
  77. }
  78. }
  79. _Clos = cols;
  80. }
  81. });
  82. }
  83. function gridList() {
  84. var $gridList = $("#gridList");
  85. var queryJson = {
  86. InvCode: $("#txt_InvCode").val(),
  87. InvName: $("#txt_InvName").val(),
  88. OrderNo: $("#txt_OrderNo").val(),
  89. TransNo: $("#txt_TransNo").val(),
  90. TransLine: $("#txt_TransLine").val(),
  91. WorkPoint: WorkPoints,
  92. VenCode: Vendor
  93. }
  94. $gridList.dataGrid({
  95. url: "/PNSRM/ASNManage/GetInfoBySelectItemCode" + "?" + Math.random(),
  96. postData: { queryJson: JSON.stringify(queryJson) },
  97. height: $(window).height() - 180,
  98. width: $(window).width() - 180,
  99. colModel: _Clos,
  100. sortname: 'POCode, cast(Sequence as int)',
  101. shrinkToFit: false,//宽度自适应
  102. pager: "#gridPager",
  103. //sortname: 'ID',
  104. viewrecords: true,
  105. multiselect: true,
  106. });
  107. $("#btn_search").click(function () {
  108. var queryJson = {
  109. InvCode: $("#txt_InvCode").val(),
  110. InvName: $("#txt_InvName").val(),
  111. OrderNo: $("#txt_OrderNo").val(),
  112. TransNo: $("#txt_TransNo").val(),
  113. TransLine: $("#txt_TransLine").val(),
  114. WorkPoint: WorkPoints,
  115. VenCode: Vendor
  116. }
  117. $gridList.jqGrid('setGridParam', {
  118. postData: { queryJson: JSON.stringify(queryJson) },
  119. page: 1
  120. }).trigger('reloadGrid');
  121. });
  122. }
  123. //提交
  124. function submitForm() {
  125. var rows = $("#gridList").jqGrid('getGridParam', 'selarrrow');
  126. if (rows.length < 1) {
  127. $.modalAlertNew("WMS00079");
  128. return;
  129. }
  130. var objs = [];
  131. for (var i = 0; i < rows.length; i++) {
  132. var obj = {
  133. ID: guid(),
  134. Code: $("#gridList").jqGrid('getRowData', rows[i]).POCode,
  135. Sequence: $("#gridList").jqGrid('getRowData', rows[i]).Sequence,
  136. InvCode: $("#gridList").jqGrid('getRowData', rows[i]).InvCode,
  137. InvName: $("#gridList").jqGrid('getRowData', rows[i]).InvName,
  138. InvStd: $("#gridList").jqGrid('getRowData', rows[i]).InvStd,
  139. Quantity: $("#gridList").jqGrid('getRowData', rows[i]).Quantity,
  140. ProjectCode: $("#gridList").jqGrid('getRowData', rows[i]).ProjectCode,
  141. BatchCode: $("#gridList").jqGrid('getRowData', rows[i]).BatchCode,
  142. Version: $("#gridList").jqGrid('getRowData', rows[i]).Version,
  143. Brand: $("#gridList").jqGrid('getRowData', rows[i]).Brand,
  144. cFree1: $("#gridList").jqGrid('getRowData', rows[i]).cFree1,
  145. cFree2: $("#gridList").jqGrid('getRowData', rows[i]).cFree2,
  146. cFree3: $("#gridList").jqGrid('getRowData', rows[i]).cFree3,
  147. cFree4: $("#gridList").jqGrid('getRowData', rows[i]).cFree4,
  148. cFree5: $("#gridList").jqGrid('getRowData', rows[i]).cFree5,
  149. cFree6: $("#gridList").jqGrid('getRowData', rows[i]).cFree6,
  150. cFree7: $("#gridList").jqGrid('getRowData', rows[i]).cFree7,
  151. cFree8: $("#gridList").jqGrid('getRowData', rows[i]).cFree8,
  152. cFree9: $("#gridList").jqGrid('getRowData', rows[i]).cFree9,
  153. cFree10: $("#gridList").jqGrid('getRowData', rows[i]).cFree10
  154. }
  155. objs.push(obj);
  156. }
  157. return objs;
  158. }
  159. function Close() {
  160. $.modalClose();
  161. }
  162. function reloadData() {
  163. }
  164. function guid() {
  165. return 'xxxxxxxx-xxxx-4xxx-yxxx-xxxxxxxxxxxx'.replace(/[xy]/g, function (c) {
  166. var r = Math.random() * 16 | 0, v = c == 'x' ? r : (r & 0x3 | 0x8);
  167. return v.toString(16);
  168. });
  169. }
  170. </script>
  171. <form id="form1">
  172. <div class="topPanel" style="height:100px">
  173. <div class="search">
  174. <table>
  175. <tr>
  176. <td>
  177. <label>物料编码:</label>
  178. </td>
  179. <td>
  180. <div class="input-group">
  181. <input id="txt_InvCode" type="text" class="form-control" placeholder="物料编码" style="width: 100px;">
  182. </div>
  183. </td>
  184. <td>
  185. <label>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;物料名称:</label>
  186. </td>
  187. <td>
  188. <div class="input-group">
  189. <input id="txt_InvName" type="text" class="form-control" placeholder="物料名称" style="width: 100px;">
  190. </div>
  191. </td>
  192. <td>
  193. <label>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;项目号:</label>
  194. </td>
  195. <td>
  196. <div class="input-group">
  197. <input id="txt_OrderNo" type="text" class="form-control" placeholder="项目号" style="width: 100px;">
  198. </div>
  199. </td>
  200. </tr>
  201. <tr>
  202. <td>
  203. <label>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;采购订单号:</label>
  204. </td>
  205. <td>
  206. <div class="input-group">
  207. <input id="txt_TransNo" type="text" class="form-control" placeholder="采购订单号" style="width: 100px;">
  208. </div>
  209. </td>
  210. <td>
  211. <label>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;采购单行:</label>
  212. </td>
  213. <td>
  214. <div class="input-group">
  215. <input id="txt_TransLine" type="text" class="form-control" placeholder="采购单行" style="width: 100px;">
  216. </div>
  217. </td>
  218. <td>
  219. <span class="input-group-btn">
  220. <button id="btn_search" type="button" class="btn btn-primary"><i class="fa fa-search"></i></button>
  221. </span>
  222. </td>
  223. </tr>
  224. </table>
  225. </div>
  226. </div>
  227. <div class="gridPanel">
  228. <table id="gridList"></table>
  229. <div id="gridPager"></div>
  230. </div>
  231. </form>