| | |
| | | Pub_Class.ClsXt_SystemParameter oSystemParameter = new Pub_Class.ClsXt_SystemParameter(); |
| | | string sErrMsg = ""; |
| | | oSystemParameter.ShowBill(ref sErrMsg); |
| | | if (oSystemParameter.omodel.WMS_CampanyName == "") //乔一客户 |
| | | if (oSystemParameter.omodel.WMS_CampanyName == "乔一") //乔一客户 |
| | | { |
| | | mainSql = "UpDate Kf_ICStockBillMain set " + |
| | | " HBillNo='" + omodel.HBillNo + |
| | |
| | | "," + oSub.HSeOrderInterID.ToString() + "," + oSub.HSeOrderEntryID.ToString() + ",'" + oSub.HSeOrderBillNo + "'" + |
| | | ") "; |
| | | |
| | | if (oSystemParameter.omodel.WMS_CampanyName == "") //乔一客户 |
| | | if (oSystemParameter.omodel.WMS_CampanyName == "乔一") //乔一客户 |
| | | { |
| | | subSql = "Insert into Kf_ICStockBillSub" + |
| | | "(HInterID,HEntryID,HCloseMan,HEntryCloseDate,HCloseType,HRemark,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney,HMaterID,HPropertyID,HSecUnitID,HSecUnitRate,HUnitID,HQtyMust" + |
| | |
| | | Pub_Class.ClsXt_SystemParameter oSystemParameter = new Pub_Class.ClsXt_SystemParameter(); |
| | | string sErrMsg = ""; |
| | | oSystemParameter.ShowBill(ref sErrMsg); |
| | | if (oSystemParameter.omodel.WMS_CampanyName == "") //乔一客户 |
| | | if (oSystemParameter.omodel.WMS_CampanyName == "乔一") //乔一客户 |
| | | { |
| | | mainSql = "Insert Into Kf_ICStockBillMain" + |
| | | "(HBillType,HBillSubType,HInterID,HBillNo,HDate,HYear,HPeriod,HRemark,HMainSourceInterID,HMainSourceBillNo,HMainSourceBillType,HMaker,HMakeDate,HSupID,HWHID,HSCWHID,HEmpID,HManagerID,HSecManagerID,HKeeperID,HDeptID,HExplanation,HInnerBillNo,HRedBlueFlag" + |
| | |
| | | "," + oSub.HSeOrderInterID.ToString() + "," + oSub.HSeOrderEntryID.ToString() + ",'" + oSub.HSeOrderBillNo + "'" + |
| | | ") "; |
| | | |
| | | if (oSystemParameter.omodel.WMS_CampanyName == "") //乔一客户 |
| | | if (oSystemParameter.omodel.WMS_CampanyName == "乔一") //乔一客户 |
| | | { |
| | | subSql = "Insert into Kf_ICStockBillSub" + |
| | | "(HInterID,HEntryID,HCloseMan,HEntryCloseDate,HCloseType,HRemark,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney,HMaterID,HPropertyID,HSecUnitID,HSecUnitRate,HUnitID,HQtyMust" + |
| | |
| | | Pub_Class.ClsXt_SystemParameter oSystemParameter = new Pub_Class.ClsXt_SystemParameter(); |
| | | string sErrMsg = ""; |
| | | oSystemParameter.ShowBill(ref sErrMsg); |
| | | if (oSystemParameter.omodel.WMS_CampanyName == "") //乔一客户 |
| | | if (oSystemParameter.omodel.WMS_CampanyName == "乔一") //乔一客户 |
| | | { |
| | | omodel.HICMOInterID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HICMOInterID"]); |
| | | omodel.HICMOEntryID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HICMOEntryID"]); |
| | |
| | | oSub.HSeOrderEntryID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HSeOrderEntryID"]); |
| | | oSub.HSeOrderBillNo = DBUtility.ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HSeOrderBillNo"]); |
| | | |
| | | if (oSystemParameter.omodel.WMS_CampanyName == "") //乔一客户 |
| | | if (oSystemParameter.omodel.WMS_CampanyName == "乔一") //乔一客户 |
| | | { |
| | | oSub.HRate = DBUtility.ClsPub.isDoule(DsSub.Tables[0].Rows[0]["HRate"]); |
| | | } |