| | |
| | | //public const string SqlConnStr = "Data Source=.;Initial Catalog=HX_LMESsys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022;"; |
| | | //public const string SqlConnStr = "Data Source=.;Initial Catalog=HX_LimsSys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022;";//chæµè¯ |
| | | //public const string SqlConnStr = "Data Source=47.96.97.237,15127;Initial Catalog=HX_LMESsys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022;";//YLæµè¯ |
| | | //public const string SqlConnStr = "Data Source=47.96.97.237,15127;Initial Catalog=HX_LMESsys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022;";//ä¸¸äº |
| | | public const string SqlConnStr = "Data Source=47.96.97.237,15127;Initial Catalog=HX_LMESsys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022;";//ä¸¸äº |
| | | //public const string SqlConnStr = "Data Source=192.168.0.200;Initial Catalog=HX_LimsSys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022;";//丸äºå°å |
| | | //public const string SqlConnStr = "Data Source=192.168.0.175;Initial Catalog=HX_LimsSys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022;";//é
çªè¯ºæµè¯ |
| | | public const string SqlConnStr = "Data Source=183.129.128.86:26589;Initial Catalog=HX_LimsSys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022;";//å¯è´å¥ç¹ |
| | | //public const string SqlConnStr = "Data Source=183.129.128.86:26589;Initial Catalog=HX_LimsSys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022;";//å¯è´å¥ç¹ |
| | | |
| | | //public string sServer; |
| | | //public string sDataBase; |
New file |
| | |
| | | 2022/7/31 14:16:08 select b.HInterID,b.HEntryID,a.HDate as æ¥æ,m.HNumber as ç©æä»£ç ,m.HName as ç©æåç§°,m.HModel as è§æ ¼åå·, |
| | | b.HPieceQty as ä»¶æ°,b.HQty as æ°é,a.HBillNo as 颿åå·,p.HBillNo as æºååå·,b.HMaker å¶å人,u.HName 计éåä½ |
| | | from Kf_ICStockBillMain a |
| | | left join KF_ICSTOCKBILLSUB_WMS b on b.HInterID=a.HInterID |
| | | left join Gy_Material m on b.HMaterID=m.HItemID |
| | | left join gy_unit u on m.HUnitID=u.HItemID |
| | | JOIN Sc_PPBomBillMain p ON b.HSourceEntryID = p.HICMOEntryID |
| | | where convert(varchar(50),b.HInterID)+'-'+convert(varchar(50),b.HEntryID) in ('123159-163') |
| | | |
| | | 2022/7/31 14:16:08 æå°sql:select b.HInterID,b.HEntryID,a.HDate as æ¥æ,m.HNumber as ç©æä»£ç ,m.HName as ç©æåç§°,m.HModel as è§æ ¼åå·, |
| | | b.HPieceQty as ä»¶æ°,b.HQty as æ°é,a.HBillNo as 颿åå·,p.HBillNo as æºååå·,b.HMaker å¶å人,u.HName 计éåä½ |
| | | from Kf_ICStockBillMain a |
| | | left join KF_ICSTOCKBILLSUB_WMS b on b.HInterID=a.HInterID |
| | | left join Gy_Material m on b.HMaterID=m.HItemID |
| | | left join gy_unit u on m.HUnitID=u.HItemID |
| | | JOIN Sc_PPBomBillMain p ON b.HSourceEntryID = p.HICMOEntryID |
| | | where convert(varchar(50),b.HInterID)+'-'+convert(varchar(50),b.HEntryID) in ('123159-163') |
| | | |
| | | 2022/7/31 14:18:53 select b.HInterID,b.HEntryID,a.HDate as æ¥æ,m.HNumber as ç©æä»£ç ,m.HName as ç©æåç§°,m.HModel as è§æ ¼åå·, |
| | | b.HPieceQty as ä»¶æ°,b.HQty as æ°é,a.HBillNo as 颿åå·,p.HBillNo as æºååå·,b.HMaker å¶å人,u.HName 计éåä½ |
| | | from Kf_ICStockBillMain a |
| | | left join KF_ICSTOCKBILLSUB_WMS b on b.HInterID=a.HInterID |
| | | left join Gy_Material m on b.HMaterID=m.HItemID |
| | | left join gy_unit u on m.HUnitID=u.HItemID |
| | | JOIN Sc_PPBomBillMain p ON b.HSourceEntryID = p.HICMOEntryID |
| | | where convert(varchar(50),b.HInterID)+'-'+convert(varchar(50),b.HEntryID) in ('123159-163') |
| | | |
| | | 2022/7/31 14:18:53 æå°sql:select b.HInterID,b.HEntryID,a.HDate as æ¥æ,m.HNumber as ç©æä»£ç ,m.HName as ç©æåç§°,m.HModel as è§æ ¼åå·, |
| | | b.HPieceQty as ä»¶æ°,b.HQty as æ°é,a.HBillNo as 颿åå·,p.HBillNo as æºååå·,b.HMaker å¶å人,u.HName 计éåä½ |
| | | from Kf_ICStockBillMain a |
| | | left join KF_ICSTOCKBILLSUB_WMS b on b.HInterID=a.HInterID |
| | | left join Gy_Material m on b.HMaterID=m.HItemID |
| | | left join gy_unit u on m.HUnitID=u.HItemID |
| | | JOIN Sc_PPBomBillMain p ON b.HSourceEntryID = p.HICMOEntryID |
| | | where convert(varchar(50),b.HInterID)+'-'+convert(varchar(50),b.HEntryID) in ('123159-163') |
| | | |
| | | 2022/7/31 14:18:53 SqlConnStr:Data Source=47.96.97.237,15127;Initial Catalog=HX_LMESsys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022; |
| | | |
| | | 2022/7/31 14:18:53 ReportDataSet:1 |
| | | |
| | | 2022/7/31 14:19:14 select b.HInterID,b.HEntryID,a.HDate as æ¥æ,m.HNumber as ç©æä»£ç ,m.HName as ç©æåç§°,m.HModel as è§æ ¼åå·, |
| | | b.HPieceQty as ä»¶æ°,b.HQty as æ°é,a.HBillNo as 颿åå·,p.HBillNo as æºååå·,b.HMaker å¶å人,u.HName 计éåä½ |
| | | from Kf_ICStockBillMain a |
| | | left join KF_ICSTOCKBILLSUB_WMS b on b.HInterID=a.HInterID |
| | | left join Gy_Material m on b.HMaterID=m.HItemID |
| | | left join gy_unit u on m.HUnitID=u.HItemID |
| | | JOIN Sc_PPBomBillMain p ON b.HSourceEntryID = p.HICMOEntryID |
| | | where convert(varchar(50),b.HInterID)+'-'+convert(varchar(50),b.HEntryID) in ('123159-163') |
| | | |
| | | 2022/7/31 14:19:14 æå°sql:select b.HInterID,b.HEntryID,a.HDate as æ¥æ,m.HNumber as ç©æä»£ç ,m.HName as ç©æåç§°,m.HModel as è§æ ¼åå·, |
| | | b.HPieceQty as ä»¶æ°,b.HQty as æ°é,a.HBillNo as 颿åå·,p.HBillNo as æºååå·,b.HMaker å¶å人,u.HName 计éåä½ |
| | | from Kf_ICStockBillMain a |
| | | left join KF_ICSTOCKBILLSUB_WMS b on b.HInterID=a.HInterID |
| | | left join Gy_Material m on b.HMaterID=m.HItemID |
| | | left join gy_unit u on m.HUnitID=u.HItemID |
| | | JOIN Sc_PPBomBillMain p ON b.HSourceEntryID = p.HICMOEntryID |
| | | where convert(varchar(50),b.HInterID)+'-'+convert(varchar(50),b.HEntryID) in ('123159-163') |
| | | |
| | | 2022/7/31 14:19:14 SqlConnStr:Data Source=47.96.97.237,15127;Initial Catalog=HX_LMESsys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022; |
| | | |
| | | 2022/7/31 14:19:14 ReportDataSet:1 |
| | |
| | | |
| | | |
| | | //表头åå§åèµå¼ï¼æ ¹æ®ç»å½ç¨æ·è·åå·¥åº çäº§èµæºãæä½åãç产çç»ï¼ new |
| | | //å·¥åº |
| | | |
| | | //å·¥åº |
| | | |
| | | $("#HProcID").val(sessionStorage["HProcID"]); |
| | | $("#HProc").val(sessionStorage["HProc"]); |
| | | //çäº§èµæº |
| | |
| | | } |
| | | }); |
| | | }) |
| | | |
| | | |
| | | //å é¤ |
| | | form.on('submit(cmdDelete)', function () { |
| | | var checkStatus = table.checkStatus('tm-table') |
| | |
| | | type: "Get", |
| | | url: GetWEBURL() + "/Sc_PckSplit/Delete_PHPCruxBillListByME", |
| | | async: true, |
| | | data: { "HInterID": sInterID, "HMaterID": sMaterID, "HBarCode": sBarCode}, |
| | | data: { "HInterID": sInterID, "HMaterID": sMaterID, "HBarCode": sBarCode }, |
| | | dataType: "json", |
| | | success: function (data) { |
| | | if (data.count == 1) { |
| | |
| | | var sSubStr = JSON.stringify(table.cache['pj-table']); |
| | | var sSubStr1 = JSON.stringify(table.cache['tm-table']); |
| | | var sMainSub = sMainStr + ';' + sSubStr + ';' + sSubStr1 + ';' + sessionStorage["HUserName"]; |
| | | $.ajax( |
| | | { |
| | | type: "POST", |
| | | url: GetWEBURL() + "/Sc_PckSplit/Add_PHPCruxBillList", |
| | | async: true, |
| | | data: { "msg": sMainSub }, |
| | | dataType: "json", |
| | | success: function (data) { |
| | | if (data.count == 1) { // 说æéªè¯æåäº |
| | | layer.msg("æäº¤æå" + data.Message + $("#HBillNo").val(), { time: 1 * 1000, icon: 1 }, function () { |
| | | location.reload(); |
| | | }); |
| | | //layer.msg("æäº¤æå" + data.Message + $("#HBillNo").val(), { icon: 1, btn: ['确认'], time: 100000, offset: 't', skin: 'layui-layer-lan', title: "温馨æç¤º" }); |
| | | //location.reload(); |
| | | } |
| | | else { |
| | | //layer.msg(data.Message, { icon: 5, btn: ['确认'], time: 100000, offset: 't' }); |
| | | layer.msg(data.Message, { icon: 5, btn: ['确认'], time: 100000, offset: 't', skin: 'layui-layer-lan', title: "温馨æç¤º" }); |
| | | } |
| | | layer.closeAll("loading"); |
| | | layui.form.render(); |
| | | }, |
| | | error: function (err) { |
| | | //layer.msg("é误:" + err, { icon: 5, btn: ['确认'], time: 100000, offset: 't' }); |
| | | layer.msg("é误:" + err, { icon: 5, btn: ['确认'], time: 100000, offset: 't', skin: 'layui-layer-lan', title: "温馨æç¤º" }); |
| | | $.ajax( |
| | | { |
| | | type: "POST", |
| | | url: GetWEBURL() + "/Sc_PckSplit/Add_PHPCruxBillList", |
| | | async: true, |
| | | data: { "msg": sMainSub }, |
| | | dataType: "json", |
| | | success: function (data) { |
| | | if (data.count == 1) { // 说æéªè¯æåäº |
| | | layer.msg("æäº¤æå" + data.Message + $("#HBillNo").val(), { time: 1 * 1000, icon: 1 }, function () { |
| | | location.reload(); |
| | | }); |
| | | //layer.msg("æäº¤æå" + data.Message + $("#HBillNo").val(), { icon: 1, btn: ['确认'], time: 100000, offset: 't', skin: 'layui-layer-lan', title: "温馨æç¤º" }); |
| | | //location.reload(); |
| | | } |
| | | }); |
| | | else { |
| | | //layer.msg(data.Message, { icon: 5, btn: ['确认'], time: 100000, offset: 't' }); |
| | | layer.msg(data.Message, { icon: 5, btn: ['确认'], time: 100000, offset: 't', skin: 'layui-layer-lan', title: "温馨æç¤º" }); |
| | | } |
| | | layer.closeAll("loading"); |
| | | layui.form.render(); |
| | | }, |
| | | error: function (err) { |
| | | //layer.msg("é误:" + err, { icon: 5, btn: ['确认'], time: 100000, offset: 't' }); |
| | | layer.msg("é误:" + err, { icon: 5, btn: ['确认'], time: 100000, offset: 't', skin: 'layui-layer-lan', title: "温馨æç¤º" }); |
| | | } |
| | | }); |
| | | }); |
| | | |
| | | //çå¬æäº¤ |
| | |
| | | url: GetWEBURL() + "/Sc_PckSplit/Get_PHPCruxSNBillList", |
| | | type: "GET", |
| | | async: false, |
| | | data: { "HinterID": sInterID, "HBarCode": sBarCode, "HProcID": sProcID, "HBillNo": sBillNo}, |
| | | data: { "HinterID": sInterID, "HBarCode": sBarCode, "HProcID": sProcID, "HBillNo": sBillNo }, |
| | | success: function (result) { |
| | | if (result.count == 1) { |
| | | option.data = result.data; |
| | |
| | | $("#HPCrux").focus(); |
| | | } |
| | | }); |
| | | //å
³é®ä»¶åè½¦æ¹æ³ |
| | | //å
³é®ä»¶åè½¦æ¹æ³ |
| | | $('#HPCrux').on('keydown', function (event) { |
| | | var sHPCrux = $('#HPCrux').val() |
| | | var sInterID = $('#HInterID').val() |
| | |
| | | url: GetWEBURL() + "/Sc_PckSplit/Get_PHPCruxBillList", |
| | | type: "GET", |
| | | async: false, |
| | | data: { "HinterID": sInterID, "HPCrux": sHPCrux, "HBillNo": sBillNo}, |
| | | data: { "HinterID": sInterID, "HPCrux": sHPCrux, "HBillNo": sBillNo }, |
| | | success: function (result) { |
| | | if (result.count == 1) { |
| | | option1.data = result.data; |
| | |
| | | option1.data = []; |
| | | table1.render(option1); |
| | | } |
| | | |
| | | |
| | | }); |
| | | |
| | | |
| | | |
| | | |
| | | </script> |
| | | </body> |
| | | </html> |
| | |
| | | <button type="button" class="layui-btn layui-btn-normal layui-btn-radius" lay-submit="" lay-filter="set_CheckBill" id="set_CheckBill">å®¡æ ¸</button> |
| | | <button type="button" class="layui-btn layui-btn-normal layui-btn-radius" lay-submit="" lay-filter="set_AbandonCheck" id="set_AbandonCheck">åå®¡æ ¸</button> |
| | | <button type="button" class="layui-btn layui-btn-normal layui-btn-radius" lay-submit="" lay-filter="Cancel" id="Cancel">éåº</button> |
| | | <button type="button" class="layui-btn layui-btn-normal layui-btn-radius" lay-event="btn-InStorage" lay-filter="btn-InStorage" id="btn-InStorage"></i>å
¥åº</button> |
| | | </div> |
| | | </div> |
| | | <div class="layui-form-item" style="padding-top: 10px;"> |
| | |
| | | , element = layui.element; |
| | | //è¿å
¥é¡µé¢é»è®¤å
æ 卿¡å½¢ç ä¸ |
| | | $("#HBarCode").focus(); |
| | | //è¿å
¥é¡µé¢å
¥åºæé®ç½®ç° |
| | | $('#btn-InStorage').addClass("layui-btn-disabled").attr("disabled", true); |
| | | |
| | | /*åºå®ä»£ç ï¼æ¯å¼ åæ®é½è¦begin*/ |
| | | /* 1.æ æºåæ°å¢ |
| | |
| | | } |
| | | |
| | | |
| | | |
| | | function RoadBillMain(linterid)//å 载表头 |
| | | //å 载表头 |
| | | function RoadBillMain(linterid) |
| | | { |
| | | var index = layer.load(); |
| | | $.ajax({ |
| | |
| | | if (data.count == 1) { |
| | | layer.close(index); |
| | | layer.msg("æäº¤æå"); |
| | | //å
¥åºæé®å¯ç¨ |
| | | $('#btn-InStorage').removeClass("layui-btn-disabled").attr("disabled", false); |
| | | if (result.Verify == "Y") { |
| | | location.replace('Cj_StationOutBill.html?OperationType=1&linterid=0&HSouceBillType=&HBillNo=&closeType=2'); |
| | | } else { |
| | | } |
| | | else { |
| | | //ä¿ååæµè§ |
| | | ReRoadBillMain(); |
| | | } |
| | |
| | | error: function (err) { |
| | | layer.close(index); |
| | | layer.msg("é误:" + err, { icon: 5, btn: ['确认'], time: 100000, offset: 't', skin: 'layui-layer-lan', title: "温馨æç¤º" }); |
| | | } |
| | | }); |
| | | }); |
| | | |
| | | //å
¥åº |
| | | form.on('submit(btn-InStorage)', function (data) { |
| | | var InterID = $("#HInterID").val(); |
| | | var BillNo = $("#HBillNo").val(); |
| | | $.ajax({ |
| | | type: "GET", |
| | | url: GetWEBURL() + "/Sc_ProcessMangement/SaveICMOReportBill", //æ¹æ³æå¨é¡µé¢åæ¹æ³å |
| | | async: true, |
| | | data: { "InterID": InterID, "user": sessionStorage["HUserName"], "BillNo": BillNo, "OrganizationID": sessionStorage["OrganizationID"] }, |
| | | dataType: "json", |
| | | success: function (data) { |
| | | if (data.count == 1) { // 说æéªè¯æåäºï¼ |
| | | layer.msg(data.Message, { time: 1 * 1000, icon: 1 }, function () { |
| | | var index = parent.layer.getFrameIndex(window.name); //å
å¾å°å½åiframeå±çç´¢å¼ |
| | | parent.layer.close(index); //åæ§è¡å
³é           |
| | | }); |
| | | } |
| | | else { |
| | | layer.alert(data.Message, { icon: 5 }); |
| | | } |
| | | }, |
| | | error: function (err) { |
| | | layer.alert(err.Message, { icon: 5 }); |
| | | } |
| | | }); |
| | | }); |
| | |
| | | , maxmin: true //å
许å
¨å±æå°å |
| | | , anim: 0 //0-6çå¨ç»å½¢å¼ï¼-1ä¸å¼å¯ |
| | | , content: ['../../Baseset/åºç¡èµæ/Gy_EmployeeList.html?Type=HWorker', 'yes'] |
| | | , resize: false |
| | | , cancel: function (index, layero) { |
| | | , btn: ['ç¡®å®', 'åæ¶'] |
| | | , btn1: function (index, layero) {//æé®ãæé®ä¸ãçåè° |
| | | var iframeWindow = window['layui-layer-iframe' + index] //è·åå¼¹æ¡é¡µé¢ |
| | | var checkStatus = iframeWindow.layui.table.checkStatus('mainTable');//è·åtableçelem:"#test" |
| | | if (checkStatus.data.length === 0) { |
| | | return layer.msg('è¯·éæ©æ°æ®'); |
| | | } |
| | | $("#HEmpName").val(checkStatus.data[0].HName); |
| | | $("#HEmpID").val(checkStatus.data[0].HItemID); |
| | | layer.close(index); //å®è·åçå§ç»æ¯ææ°å¼¹åºçæä¸ªå±ï¼å¼æ¯ç±layerå
é¨å¨æéå¢è®¡ç®ç |
| | | } |
| | | , btn2: function (index, layero) { } |
| | | }) |
| | | }); |
| | | //éæ©æä½å2 |
| | |
| | | //parent.location.href = "../../../views/index.html" |
| | | //window.close();//å
³éå½å页 |
| | | layer.confirm('æ¨ç¡®å®è¦éåºåï¼', { icon: 3, title: 'æç¤º' }, function (index) { |
| | | window.close(); |
| | | window.location.href = "http://localhost:8082/LuBaoUi/views/index_Mobile.html" |
| | | }); |
| | | }) |
| | | |
| | |
| | | //parent.location.href = "../../../views/index.html" |
| | | //window.close();//å
³éå½å页 |
| | | layer.confirm('æ¨ç¡®å®è¦éåºåï¼', { icon: 3, title: 'æç¤º' }, function (index) { |
| | | window.close(); |
| | | window.history.back(); |
| | | }); |
| | | }) |
| | | |