| New file |
| | |
| | | 2022/5/17 13:44:42 æå°sql:select fo.FBILLNO éå®è®¢åå·,fo.F_ZZZZ_TEXT7 è系人,fo.FRECEIVEADDRESS æ¶è´§æ¹å°å,fm1.FOLDNUMBER éå®ç©æåç§°,fo.F_ZZZZ_TEXT å
è£
æ¹å¼,fu.FDATAVALUE è±å,fu1.FDATAVALUE å¢åç¼,a.HQty æ°é,a.HBarCode ç®±å·,fo.F_ZZZZ_WBBZ å¤å
夿³¨ from Gy_BarCodeBill a left join Sc_ICMOBillSub b on a.HSourceInterID=b.HInterID left join AIS20200908101915zs..T_PRD_MOENTRY f1 on b.HERPEntryID=f1.FENTRYID left join AIS20200908101915zs..T_SAL_ORDER fo on f1.FSaleOrderId =fo.FID left join AIS20200908101915zs..T_SAL_ORDERENTRY fo1 on fo.FID=fo1.FID left join AIS20200908101915zs..T_BD_MATERIAL fm1 on fo1.FSUBMATERIALNUMBER=fm1.FMATERIALID LEFT JOIN AIS20200908101915zs..T_BAS_ASSISTANTDATAENTRY_L fu1 on fo1.F_ZZZZ_ASSISTANT1=fu1.FENTRYID LEFT JOIN AIS20200908101915zs..T_BAS_ASSISTANTDATAENTRY_L fu on fo1.F_ZZZZ_ASSISTANT2=fu.FENTRYID where a.HItemID in ('30983') |
| New file |
| | |
| | | 2022/5/18 10:46:56 æå°sql:select fo.FBILLNO éå®è®¢åå·,fo.F_ZZZZ_TEXT7 è系人,fo.FRECEIVEADDRESS æ¶è´§æ¹å°å,fm1.FOLDNUMBER éå®ç©æåç§°,fo.F_ZZZZ_TEXT å
è£
æ¹å¼,fu.FDATAVALUE è±å,fu1.FDATAVALUE å¢åç¼,a.HQty æ°é,a.HBarCode ç®±å·,fo.F_ZZZZ_WBBZ å¤å
夿³¨ from Gy_BarCodeBill a left join Sc_ICMOBillSub b on a.HSourceInterID=b.HInterID left join AIS20200908101915zs..T_PRD_MOENTRY f1 on b.HERPEntryID=f1.FENTRYID left join AIS20200908101915zs..T_SAL_ORDER fo on f1.FSaleOrderId =fo.FID left join AIS20200908101915zs..T_SAL_ORDERENTRY fo1 on fo.FID=fo1.FID left join AIS20200908101915zs..T_BD_MATERIAL fm1 on fo1.FSUBMATERIALNUMBER=fm1.FMATERIALID LEFT JOIN AIS20200908101915zs..T_BAS_ASSISTANTDATAENTRY_L fu1 on fo1.F_ZZZZ_ASSISTANT1=fu1.FENTRYID LEFT JOIN AIS20200908101915zs..T_BAS_ASSISTANTDATAENTRY_L fu on fo1.F_ZZZZ_ASSISTANT2=fu.FENTRYID where a.HItemID in ('6932','6932') |
| | |
| | | var Type = params[params[1]]; |
| | | var OpenTmp = params[params[2]]; |
| | | |
| | | if (OpenTmp =="å¢åæ¡ç ") { |
| | | Type += "1"; |
| | | } |
| | | |
| | | |
| | | switch (Type) { |
| | | |
| | | //case "HBarCodePrint"://ç©ææ¡ç æå° |
| | |
| | | |
| | | if (type.Trim()=="å¢åæ¡ç ") |
| | | { |
| | | SqlXMLReportData.GenOneRecordset(this, "select HSourceBillNo 订åå·,a.HMaterID,m.HName ç©æ,m.HModel åå·,a.HQty æ°é,a.HBatchNo æ¹å·,a.HBarCode ç®±å·,a.HRemark åºæ¯å· from Gy_BarCodeBill a left join Gy_Material m on a.HMaterID=m.HItemID where a.HItemID in (" + PrintIds + ")"); |
| | | SqlXMLReportData.GenOneRecordset(this, "select HSourceBillNo 订åå·,a.HMaterID,m.HName ç©æ,m.HModel åå·,a.HQty æ°é,a.HBatchNo æ¹å·,a.HRemark ç®±å·,a.HRemark åºæ¯å· from Gy_BarCodeBill a left join Gy_Material m on a.HMaterID=m.HItemID where a.HItemID in (" + PrintIds + ")"); |
| | | } |
| | | else |
| | | { |
| | | SqlXMLReportData.GenOneRecordset(this, "select fo.FBILLNO éå®è®¢åå·,fo.F_ZZZZ_TEXT7 è系人,fo.FRECEIVEADDRESS æ¶è´§æ¹å°å," + |
| | | "fm1.FOLDNUMBER éå®ç©æåç§°,fo.F_ZZZZ_TEXT å
è£
æ¹å¼,fu.FDATAVALUE è±å,fu1.FDATAVALUE å¢åç¼,a.HQty æ°é,a.HBarCode ç®±å·,fo.F_ZZZZ_WBBZ å¤å
夿³¨ " + |
| | | "fm1.FOLDNUMBER éå®ç©æåç§°,fo.F_ZZZZ_TEXT å
è£
æ¹å¼,fu.FDATAVALUE è±å,fu1.FDATAVALUE å¢åç¼,a.HQty æ°é,a.HRemark ç®±å·,fo.F_ZZZZ_WBBZ å¤å
夿³¨ " + |
| | | "from Gy_BarCodeBill a " + |
| | | "left join Sc_ICMOBillSub b on a.HSourceInterID=b.HInterID " + |
| | | " left join Sc_ICMOBillSub b on a.HSourceEntryID=b.HEntryID and a.HSourceInterID = b.HInterID " + |
| | | "left join AIS20200908101915zs..T_PRD_MOENTRY f1 on b.HERPEntryID=f1.FENTRYID " + |
| | | "left join AIS20200908101915zs..T_SAL_ORDER fo on f1.FSaleOrderId =fo.FID " + |
| | | "left join AIS20200908101915zs..T_SAL_ORDERENTRY fo1 on fo.FID=fo1.FID " + |
| | | "left join AIS20200908101915zs..T_BD_MATERIAL fm1 on fo1.FSUBMATERIALNUMBER=fm1.FMATERIALID " + |
| | | "left join AIS20200908101915zs..T_SAL_ORDERENTRY fo1 on f1.FSaleOrderEntryId=fo1.FENTRYID " + |
| | | "left join AIS20200908101915zs..T_SAL_ORDER fo on fo1.FID=fo.FID " + |
| | | "LEFT join AIS20200908101915zs..T_BD_MATERIAL fm1 on fo1.FSUBMATERIALNUMBER=fm1.FMATERIALID " + |
| | | "LEFT JOIN AIS20200908101915zs..T_BAS_ASSISTANTDATAENTRY_L fu1 on fo1.F_ZZZZ_ASSISTANT1=fu1.FENTRYID " + |
| | | "LEFT JOIN AIS20200908101915zs..T_BAS_ASSISTANTDATAENTRY_L fu on fo1.F_ZZZZ_ASSISTANT2=fu.FENTRYID "+ |
| | | "where a.HItemID in (" + PrintIds + ")"); |
| | |
| | | <div class="layui-input-inline"> |
| | | <input class="layui-input" name="HBillNo" lay-verify="HBillNo" id="HBillNo" disabled autocomplete="off"> |
| | | <input id="HInterID" name="HInterID" type="hidden" /> |
| | | |
| | | |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | |
| | | <input class="layui-input" name="HICMOBillNo" lay-verify="HICMOBillNo" id="HICMOBillNo" autocomplete="off"> |
| | | <input id="HICMOInterID" name="HICMOInterID" type="hidden" /> |
| | | <input id="HICMOEntryID" name="HICMOEntryID" type="hidden" /> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | <div class="layui-form-item"> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">éå®è®¢åå·:</label> |
| | | <div class="layui-input-inline"> |
| | | <input class="layui-input" name="F_YQN_XSDD" lay-verify="F_YQN_XSDD" id="F_YQN_XSDD" disabled autocomplete="off"> |
| | | |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">éå®ç©æåç§°:</label> |
| | | <div class="layui-input-inline"> |
| | | <input class="layui-input" name="F_zzzz_Text4" lay-verify="F_zzzz_Text4" id="F_zzzz_Text4" disabled autocomplete="off"> |
| | | |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">é宿°é:</label> |
| | | <div class="layui-input-inline"> |
| | | <input class="layui-input" name="FQTY" lay-verify="FQTY" id="FQTY" disabled autocomplete="off"> |
| | | </div> |
| | | </div> |
| | | </div> |
| | |
| | | $("#HMainSourceInterID").val(""); |
| | | $("#HMainSourceEntryID").val(""); |
| | | $("#HMainSourceBillNo").val(""); |
| | | $('#HMainSourceBillNo').attr("readonly", true); |
| | | $("#HMainSourceBillType").val(""); |
| | | $('#HMainSourceBillNo').attr("disabled", false); |
| | | $('#XDHList').addClass("layui-btn-disabled").attr("disabled", true); |
| | |
| | | , "HICMOInterID": "0" |
| | | , "HICMOEntryID": "0" |
| | | , "HICMOBillNo": "0" |
| | | , "F_YQN_XSDD": data.éå®è®¢åç¼å· |
| | | , "F_zzzz_Text4": data.éå®ç©æåç§° |
| | | , "FQTY": data.é宿°é |
| | | }); |
| | | $("#HMainSourceBillNo").css("box-shadow", "none"); |
| | | $("#HProcID").val(0); |
| | |
| | | return Result = false; |
| | | } |
| | | if ($("#HGroupID").val() == '' || $("#HGroupID").val() == null) { |
| | | $("#HGroupID").val(0); |
| | | layer.msg("çç»ä¸è½ä¸ºç©ºï¼", { icon: 5, btn: ['确认'], time: 2000, offset: 't', skin: 'layui-layer-lan', title: "温馨æç¤º" }); |
| | | return Result = false; |
| | | } |
| | |
| | | layer.msg('è¯·éæ©è³å°ä¸è¡æ°æ®æå°ï¼'); |
| | | } |
| | | } |
| | | |
| | | //æå° |
| | | function get_PrintReport() { |
| | | var checkStatus = table.checkStatus('mainTable') |
| | |
| | | var checkStatus = table.checkStatus('mainTable') |
| | | , data = checkStatus.data; |
| | | var cache=table.cache['mainTable1'] |
| | | if (checkStatus.data.length === 1) { |
| | | if (checkStatus.data.length === 0) { |
| | | var HInterID = data[0].hmainid.toString(); |
| | | if (cache.length!=0) { |
| | | flag = 1; |
| | | } |
| | | //if (cache.length!=0) { |
| | | // flag = 1; |
| | | //} |
| | | //é»è¾å 餿¹æ³ |
| | | layer.confirm("确认è¦å é¤åï¼å é¤åä¸è½æ¢å¤", { title: "å é¤ç¡®è®¤" }, function (index) { |
| | | $.ajax({ |
| | |
| | | }); |
| | | //æ´ç®±çæ |
| | | form.on('submit(btnPack)', function (data) { |
| | | var flag = "ZZ"; |
| | | var sSubStr = table.checkStatus('mainTable'); |
| | | if (sSubStr.data.length > 0) { |
| | | SavePack(flag, sSubStr); |
| | | SavePack(sSubStr); |
| | | } |
| | | else { |
| | | layer.msg('请æå°éæ©1è¡æ°æ®ï¼'); |
| | | return; |
| | | } |
| | | SavePack(flag, sSubStr); |
| | | }); |
| | | //æ¼ç®±çæ |
| | | form.on('submit(btnAssembly)', function (data) { |
| | |
| | | , { field: 'HMinQty', title: 'æå°å
è£
æ°', edit: 'text', event: 'HMinQty', width: 100 } |
| | | , { field: 'HTotalQty', title: 'çææ¡æ°', edit: 'false', width: 100 } |
| | | , { field: 'HSpsQty', title: 'å©ä½æ°é', edit: 'false', width: 100 } |
| | | , { field: 'HXH', title: 'ç®±å·', edit: 'false', width: 100 } |
| | | |
| | | , { field: 'FBillNo', title: 'éå®è®¢åå·', edit: 'false', width: 100 } |
| | | , { field: 'FLXName', title: 'è系人', edit: 'text', width: 100 } |
| | |
| | | table.render(option); |
| | | } |
| | | //çæ |
| | | function SavePack(flag, sSubStr) { |
| | | function SavePack(sSubStr) { |
| | | if (!AllowLoadData(sSubStr))//æ°æ®éªè¯ |
| | | { |
| | | return false; |
| | |
| | | type: "POST", |
| | | url: GetWEBURL() + "/Sc_ICMOBill/QK_PackingBillSavePack", //æ¹æ³æå¨é¡µé¢åæ¹æ³å |
| | | async: true, |
| | | data: { "msg": JSON.stringify(sSubStr.data) + ";" + sessionStorage["HUserName"] + ";" + flag + ";" + sessionStorage["OrganizationID"]}, |
| | | data: { "msg": JSON.stringify(sSubStr.data) + ";" + sessionStorage["HUserName"] + ";" + sessionStorage["OrganizationID"]}, |
| | | dataType: "json", |
| | | success: function (data) { |
| | | if (data.count == 1) { // 说æéªè¯æåäºï¼ |
| | |
| | | else { |
| | | OpenTmp = "å
è£
æ¹å¼æ¡ç "; |
| | | } |
| | | window.open("../åºç¡èµæ/å
¬ç¨åºç¡èµæ/HBarPlanPrint.html?linterid=" + PrintIds.toString() + "&Type=" + Type.toString() + "&OpenTmp=" + OpenTmp.toString()); |
| | | |
| | | window.open("../../åºç¡èµæ/å
¬ç¨åºç¡èµæ/HBarPlanPrint.html?linterid=" + PrintIds.toString() + "&Type=" + Type.toString() + "&OpenTmp=" + OpenTmp.toString()); |
| | | |
| | | } |
| | | else { |
| | | f_alert(data.Message); |
| | |
| | | layer.msg("æç»è®°å½ç¬¬" + (i + 1) + "è¡,æå°å
è£
æ°ä¸è½ä¸ºç©º!", { icon: 5, btn: ['确认'], time: 2000, offset: 't', skin: 'layui-layer-lan', title: "温馨æç¤º" }); |
| | | return Result = false; |
| | | } |
| | | if (sSubStr.data[i].HXH == "") { |
| | | layer.msg("æç»è®°å½ç¬¬" + (i + 1) + "è¡,ç®±å·ä¸è½ä¸ºç©º!", { icon: 5, btn: ['确认'], time: 2000, offset: 't', skin: 'layui-layer-lan', title: "温馨æç¤º" }); |
| | | return Result = false; |
| | | } |
| | | } |
| | | } |
| | | else { |