Merge branch 'master' of http://101.37.171.70:10101/r/MESWMS-LayUI
| | |
| | | //var WEBURL = "http://192.168.1.253:8080/API/"; //å¯è´å¥ç¹å®¢æ·æå¡å¨å
ç½ |
| | | //var WEBURL = "http://220.189.218.154:8092/API/"; //丸äºåç»´å°æå¡å¨ |
| | | //var WEBURL = "http://192.168.0.214/API/"; //çä¸ç¥ºæå¡å¨ |
| | | //var WEBURL = "http://192.168.10.66/API/"; //森楷æå¡å¨ |
| | | //var WEBURL = "http://localhost/API/"; |
| | | return WEBURL |
| | | } |
| | |
| | | } |
| | | 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.HRemark ç®±å·,fo.F_ZZZZ_WBBZ å¤å
夿³¨ " + |
| | | "from Gy_BarCodeBill a " + |
| | | " 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_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 + ")"); |
| | | string sql = string.Format(@"select fo.FBILLNO éå®è®¢åå·,fo.F_ZZZZ_TEXT7 è系人,fo.FRECEIVEADDRESS æ¶è´§æ¹å°å, |
| | | fmn.FNAME éå®ç©æåç§°,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.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_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_L fmn on fo1.FSUBMATERIALNUMBER=fmn.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+") order by a.HRemark"); |
| | | SqlXMLReportData.GenOneRecordset(this, sql); |
| | | } |
| | | } |
| | | </script> |
| | |
| | | cols_arr[0][0] = { checkbox: true, fixed: true, totalRowText: 'å计' }; |
| | | for (var i = 0; i < data.length; i++) { |
| | | if (data[i].name == 'HItemID') { |
| | | cols_arr[0][i + 1] = { field: data[i].id, title: data[i].name, align: 'center', hide: true }; //éèidå |
| | | cols_arr[0][i + 1] = { field: data[i].id, title: data[i].name, align: 'center', hide: true, width: 200 }; //éèidå |
| | | } |
| | | else { |
| | | switch (data[i].Type) { |
| | | //int |
| | | case 'Int32': |
| | | cols_arr[0][i + 1] = { field: data[i].id, title: data[i].name, align: 'center', totalRow: true, sort: true }; |
| | | cols_arr[0][i + 1] = { field: data[i].id, title: data[i].name, align: 'center', totalRow: true, sort: true, width: 200 }; |
| | | break; |
| | | //Decimal |
| | | case 'Decimal': |
| | | cols_arr[0][i + 1] = { field: data[i].id, title: data[i].name, align: 'center', totalRow: true, sort: true }; |
| | | cols_arr[0][i + 1] = { field: data[i].id, title: data[i].name, align: 'center', totalRow: true, sort: true, width: 200}; |
| | | break; |
| | | default: |
| | | cols_arr[0][i + 1] = { field: data[i].id, title: data[i].name, align: 'center', sort: true }; |
| | | cols_arr[0][i + 1] = { field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 200}; |
| | | } |
| | | } |
| | | } |
| | |
| | | cols_arr1[0][0] = { checkbox: true, fixed: true, totalRowText: 'å计' }; |
| | | for (var i = 0; i < data.length; i++) { |
| | | if (data[i].name == 'HItemID') { |
| | | cols_arr1[0][i + 1] = { field: data[i].id, title: data[i].name, align: 'center', hide: true }; //éèidå |
| | | cols_arr1[0][i + 1] = { field: data[i].id, title: data[i].name, align: 'center', hide: true, width: 200 }; //éèidå |
| | | } |
| | | else { |
| | | switch (data[i].Type) { |
| | | //int |
| | | case 'Int32': |
| | | cols_arr1[0][i + 1] = { field: data[i].id, title: data[i].name, align: 'center', totalRow: true, sort: true }; |
| | | cols_arr1[0][i + 1] = { field: data[i].id, title: data[i].name, align: 'center', totalRow: true, sort: true, width: 200}; |
| | | break; |
| | | //Decimal |
| | | case 'Decimal': |
| | | cols_arr1[0][i + 1] = { field: data[i].id, title: data[i].name, align: 'center', totalRow: true, sort: true }; |
| | | cols_arr1[0][i + 1] = { field: data[i].id, title: data[i].name, align: 'center', totalRow: true, sort: true, width: 200 }; |
| | | break; |
| | | default: |
| | | cols_arr1[0][i + 1] = { field: data[i].id, title: data[i].name, align: 'center', sort: true }; |
| | | cols_arr1[0][i + 1] = { field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 200}; |
| | | } |
| | | } |
| | | } |
| | |
| | | var checkStatus = table.checkStatus('mainTable') |
| | | , data = checkStatus.data; |
| | | var cache=table.cache['mainTable1'] |
| | | if (checkStatus.data.length === 0) { |
| | | if (checkStatus.data.length === 1) { |
| | | var HInterID = data[0].hmainid.toString(); |
| | | //if (cache.length!=0) { |
| | | // flag = 1; |
| | |
| | | switch (field) { |
| | | case "HMinQty": //æå°å
è£
æ° |
| | | value = parseInt(isNaN(value) ? 0 : value); |
| | | var HSPlanQty = parseInt(isNaN(data.HSPlanQty) ? 0 : data.HSPlanQty); |
| | | var HPlanQty = parseInt(isNaN(data.HPlanQty) ? 0 : data.HPlanQty); |
| | | //åæ¥æ´æ°è¡¨æ ¼åç¼å对åºçå¼ |
| | | obj.update({ |
| | | HMinQty: value, //æå°å
è£
æ° |
| | | HTotalQty: Math.floor(HPlanQty / value), //çæå
è£
æ°=æ°é/æå°å
è£
æ° |
| | | HSpsQty: HPlanQty % value //å©ä½æ°é=æ°é%æå°å
è£
æ° |
| | | HTotalQty: Math.floor(HSPlanQty / value), //çæå
è£
æ°=æ°é/æå°å
è£
æ° |
| | | HSpsQty: HPlanQty-(HSPlanQty - HSPlanQty % value) //å©ä½æ°é=æ°é%æå°å
è£
æ° |
| | | }); |
| | | break; |
| | | default: |
| | |
| | | , { field: 'HUnitName', title: '计éåä½', edit: 'false', width: 100 } |
| | | |
| | | , { field: 'HPlanQty', title: 'æ°é', edit: 'false', width: 100 } |
| | | , { field: 'HSPlanQty', title: 'å¤çæ°é', edit: 'text', width: 100 } |
| | | , { field: 'HMinQty', title: 'æå°å
è£
æ°', edit: 'text', event: 'HMinQty', width: 100 } |
| | | , { field: 'HTotalQty', title: 'çææ¡æ°', edit: 'false', width: 100 } |
| | | , { field: 'HSpsQty', title: 'å©ä½æ°é', edit: 'false', width: 100 } |