| | |
| | | double HMoney = list[0].HMoney;//金额 |
| | | string HRemark = list[0].HRemark;//备注 |
| | | double HTaxRate = list[0].HTaxRate;//税率 |
| | | long HProcNo = list[0].HProcNo;//流水号 |
| | | string HProcNo = list[0].HProcNo;//流水号 |
| | | string HOrderProcNO = list[0].HOrderProcNO;//订单跟踪号 |
| | | int HWWWorkOrderInterID = 0;//委外工单号子内码 |
| | | int HWWWorkOrderEntryID = 0;//委外工单号主内吗 |
| | |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | if (HProcNo <= 0) |
| | | if (HProcNo == "") |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | |
| | | ",HICMOInterID,HICMOBillNo,HProcPlanInterID,HProcPlanEntryID,HProcPlanBillNo,HProcExchInterID,HProcExchEntryID" + |
| | | ",HProcExchBillNo,HMaterID,HProcID,HICMOQty,HPlanQty,HStationOutTime,HSourceID" + |
| | | ",HGroupID,HDeptID,HEmpID,HBarCode,HAddr,HBarCodeMaker,HBarCodeMakeDate" + |
| | | ",HSupID,HTaxRate,HQty,HPrice,HMoney,HPrice_BHS,HMoney_BHS,HBadCount" + |
| | | ",HMainSourceInterID,HMainSourceBillNo,HMainSourceBillType,HProcNo,HOrderProcNO,HLastSubProc,HWWWorkOrderBillNo,HWWWorkOrderInterID,HWWWorkOrderEntryID,HMainInterID,HPRDOrgID" + |
| | | ",HSupID,HTaxRate,HQty,HPrice,HMoney,HPrice_BHS,HMoney_BHS,HBadCount" + ",HMainSourceInterID,HMainSourceBillNo,HMainSourceBillType,HProcNo,HOrderProcNO,HLastSubProc,HWWWorkOrderBillNo,HWWWorkOrderInterID,HWWWorkOrderEntryID,HMainInterID,HPRDOrgID" + |
| | | ") " + |
| | | " values('" + BillType + "','" + BillType + "'," + HInterID + ",'" + HBillNo + "'," + HBillStatus + ",getdate(),'" + HMaker + "',getdate()" + |
| | | "," + HYear + "," + HPeriod + ",'" + HRemark + "','" + HInnerBillNo + "','" + HSourceName + "'," + HPieceQty + "," + HWasterQty + "," + HPlanPieceQty + "," + HBadPNL + |
| | |
| | | ",HUpDater='" + HMaker + "'" + |
| | | ",HUpDateDate=getdate()" + |
| | | ",HInnerBillNo='" + HInnerBillNo + "'" + |
| | | ",HWWWorkOrderBillNo='" + HWWWorkOrderBillNo + "'" + |
| | | ",HSupID=" + HSupID + |
| | | ",HEmpID=" + HEmpID + |
| | | ",HQty=" + HQty + |
| | | ",HPieceQty=" + HPieceQty + |
| | | ",HPrice=" + HPrice + |