| | |
| | | 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" + |
| | |
| | | try |
| | | { |
| | | //得到mainid |
| | | omodel.HInterID = DBUtility.ClsPub.CreateBillID(BillType, ref DBUtility.ClsPub.sExeReturnInfo); |
| | | //omodel.HInterID = DBUtility.ClsPub.CreateBillID(BillType, ref DBUtility.ClsPub.sExeReturnInfo); |
| | | //omodel.HBillNo = DBUtility.ClsPub.CreateBillCode(BillType, ref DBUtility.ClsPub.sExeReturnInfo, true); |
| | | //若MAINDI重复则重新获取 |
| | | if (IsExistBillNo(ref DBUtility.ClsPub.sExeReturnInfo, omodel.HBillNo, Pub_Class.ClsPub.Enum_BillStatus.BillStatus_AddNew, omodel.HInterID)) |
| | |
| | | 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"]); |
| | | } |