| | |
| | | |
| | | //OledbXMLReportData.GenOneRecordset(this, "select * from Customers order by CustomerID"); |
| | | //SqlXMLReportData.GenOneRecordset(this, "select * from h_v_Kf_POStockInBillList_K3 where hmainid=1781"); |
| | | SqlXMLReportData.GenOneRecordset(this, "select * from h_v_Gy_MouldFileList where hmainid=" + Request.Params["linterid"]); |
| | | SqlXMLReportData.GenEntireData(this, "select * from h_v_Gy_MouldFileList where hmainid=" + Request.Params["linterid"], "select 1"); |
| | | } |
| | | </script> |
| | | </head> |
| | |
| | | , shade: 0.6 //é®ç½©éæåº¦ |
| | | , maxmin: false //å
许å
¨å±æå°å |
| | | , anim: 0 //0-6çå¨ç»å½¢å¼ï¼-1ä¸å¼å¯ |
| | | , content: ['../../BaseSet/SRM_OpenTmpList.html?linterid=' + data[0].hmainid.toString() + '&MyMsg=' + data[0].hmainid.toString() + '&Type=HEquipFileMainBill', 'yes'] |
| | | , content: ['../../BaseSet/SRM_OpenTmpList.html?linterid=' + data[0].hmainid.toString() + '&MyMsg=' + data[0].hmainid.toString() + '&Type=HMouldFileMainBill', 'yes'] |
| | | , resize: false |
| | | }) |
| | | } |
| | |
| | | function get_PrintReport() { |
| | | var checkStatus = table.checkStatus('mainTable') |
| | | , data = checkStatus.data; |
| | | if (checkStatus.data.length === 1) { |
| | | if (checkStatus.data.length >= 1) { |
| | | var rows = []; |
| | | for (var i = 0; i < data.length; i++) { |
| | | rows.push(data[i].hmainid.toString()); |
| | | } |
| | | |
| | | layer.open({ |
| | | type: 2 |
| | | , area: ['50%', '50%'] |
| | |
| | | , shade: 0.6 //é®ç½©éæåº¦ |
| | | , maxmin: false //å
许å
¨å±æå°å |
| | | , anim: 0 //0-6çå¨ç»å½¢å¼ï¼-1ä¸å¼å¯ |
| | | , content: ['../../BaseSet/SRM_OpenTmpList.html?linterid=' + data[0].hmainid.toString() + '&MyMsg=' + data[0].hmainid.toString() + '&Type=HEquipFileMainBill', 'yes'] |
| | | , content: ['../../BaseSet/SRM_OpenTmpList.html?linterid=' + rows.toString() + '&MyMsg=' + rows.toString() + '&Type=HMouldFileMainBill', 'yes'] |
| | | , resize: false |
| | | }) |
| | | } |
| | |
| | | <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnUnlockOrder" id="btnUnlockOrder">è§£éå·¥å</button> |
| | | <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnGetCompletionDate" id="btnGetCompletionDate">è·åå®å·¥æ¥æ</button> |
| | | <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnGetEarlyDate" id="btnGetEarlyDate">è·åææ©å¼å·¥æ¥æ</button> |
| | | <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnPublishDate" id="btnPublishDate">交æåå¸</button> |
| | | </div> |
| | | <div class="layui-collapse resizable-container"> |
| | | <div class="layui-colla-item"> |
| | |
| | | form.on('submit(btnGetEarlyDate)', function (data) { |
| | | get_btnGetEarlyDate(); |
| | | }) |
| | | |
| | | //交æåå¸ |
| | | form.on('submit(btnPublishDate)', function (data) { |
| | | get_btnPublishDate(); |
| | | }) |
| | | //#endregion |
| | | |
| | | //#endregion |
| | |
| | | }); |
| | | |
| | | //æ ¹æ®è½¦é´å 餿²¡æéå®çæ°æ® |
| | | var sql = "delete from Sc_WorkBillSortBillSub where HMasterDate>=convert(varchar(10) ,DATEADD(DAY," + HPlanDay + ",GETDATE()),20) and HInterID in(select HInterID from Sc_WorkBillSortBillMain where HWorkShopID=" + HWorkShopID + " and HLockOrder != 1 )"; |
| | | var sql = "delete from Sc_WorkBillSortBillSub where HLockedSub != 1 and HInterID in (select HInterID from Sc_WorkBillSortBillMain where HWorkShopID=" + HWorkShopID + " and HLockOrder != 1 )"; |
| | | $.ajax({ |
| | | url: GetWEBURL() + '/Gy_SOPBillList/UpDelSQL', |
| | | type: "GET", |
| | |
| | | } |
| | | //#endregion |
| | | |
| | | //交æåå¸ |
| | | //#region |
| | | function get_btnPublishDate() { |
| | | var HDeptID = $("#HWorkShopID").val() == "" ? 0 : $("#HWorkShopID").val(); |
| | | |
| | | $.ajax({ |
| | | url: GetWEBURL() + '/JIT_DayPlanPlatFormBill/PublishDate', |
| | | type: "GET", |
| | | data: { "HDeptID": HDeptID }, |
| | | success: function (data1) { |
| | | if (data1.count == 1) { |
| | | layer.alert("æ¨éæå", { icon: 5 }); |
| | | } else { |
| | | layer.alert(data1.Message, { icon: 5 }); |
| | | } |
| | | }, error: function () { |
| | | layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 }); |
| | | } |
| | | }); |
| | | } |
| | | //#endregion |
| | | |
| | | //#region æ¥çå·¥èºè·¯çº¿ï¼è®¾ç½®å·¥åæ¥åï¼å¯¼åºï¼åè®¾ç½®æ¹æ³ |
| | | |
| | | //æ¥çå·¥èºè·¯çº¿ |