修改 生产领料单 递入 HMainSourceBillType 为 HBillSubType

chenhaozhe

8 天以前 b9ac90e91d4de079acf33f379674e4e448e6baf3

 WebAPI/DLL/ClsKf_MateOutBill.cs

@@ -67,7 +67,7 @@
                Pub_Class.ClsXt_SystemParameter oSystemParameter = new Pub_Class.ClsXt_SystemParameter();
                string sErrMsg = "";
                oSystemParameter.ShowBill(ref sErrMsg);
                if (oSystemParameter.omodel.WMS_CampanyName == "乔一")          //乔一客户
                if (true )          //乔一客户
                { 
                    mainSql = "UpDate Kf_ICStockBillMain set " +
                        " HBillNo='" + omodel.HBillNo + 
@@ -144,7 +144,7 @@
                      "," + oSub.HSeOrderInterID.ToString() + "," + oSub.HSeOrderEntryID.ToString() + ",'" + oSub.HSeOrderBillNo + "'" +
                      ") ";

                    if (oSystemParameter.omodel.WMS_CampanyName == "乔一")          //乔一客户
                    if (true)          //乔一客户
                    {
                        subSql = "Insert into Kf_ICStockBillSub" +
                            "(HInterID,HEntryID,HCloseMan,HEntryCloseDate,HCloseType,HRemark,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney,HMaterID,HPropertyID,HSecUnitID,HSecUnitRate,HUnitID,HQtyMust" +
@@ -238,7 +238,7 @@
                ",HSupID,HWHID,HSCWHID,HEmpID,HManagerID,HSecManagerID" +
                ",HKeeperID,HDeptID,HExplanation,HInnerBillNo,HRedBlueFlag" +
                ") " +
                " values('" + this.BillType + "','" + this.HBillSubType + "'," + omodel.HInterID.ToString() + ",'" + omodel.HBillNo + "','" + omodel.HDate + "'" +
                " values('" + this.BillType + "','" + omodel.HBillSubType + "'," + omodel.HInterID.ToString() + ",'" + omodel.HBillNo + "','" + omodel.HDate + "'" +
                ", " + omodel.HYear.ToString() + "," + omodel.HPeriod.ToString() + ",'" + omodel.HRemark + "','" + DBUtility.ClsPub.CurUserName + "',getdate()" +
                ", " + omodel.HSupID.ToString() + "," + omodel.HWHID.ToString() + "," + omodel.HSCWHID.ToString() + "," + omodel.HEmpID.ToString() + "," + omodel.HManagerID.ToString() + "," + omodel.HSecManagerID.ToString() +
                ", " + omodel.HKeeperID.ToString() + "," + omodel.HDeptID.ToString() + ",'" + omodel.HExplanation + "','" + omodel.HInnerBillNo + "'," + DBUtility.ClsPub.BoolToString(omodel.HRedBlueFlag) +
@@ -249,7 +249,7 @@
                Pub_Class.ClsXt_SystemParameter oSystemParameter = new Pub_Class.ClsXt_SystemParameter();
                string sErrMsg = "";
                oSystemParameter.ShowBill(ref sErrMsg);
                if (oSystemParameter.omodel.WMS_CampanyName == "乔一")          //乔一客户
                if (true)          //乔一客户
                {
                    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" +
@@ -257,7 +257,7 @@
                        ",HMachineSpeed,HWaterRush,HWaterQty,HWaterRate) " +
                        " values(" +
                        "'" + this.BillType +
                        "','" + this.HBillSubType +
                        "','" + omodel.HBillSubType +
                        "'," + omodel.HInterID.ToString() +
                        ",'" + omodel.HBillNo +
                        "','" + omodel.HDate +
@@ -266,7 +266,7 @@
                        ",'" + omodel.HRemark +
                        "'," + omodel.HProcExchInterID +
                        ",'" + omodel.HProcExchBillNo +
                        "','" + "3772" +
                        "','" + (string.IsNullOrEmpty(omodel.HMainSourceBillType) == true ?  "3772" : omodel.HMainSourceBillType) +
                        "','" + DBUtility.ClsPub.CurUserName +
                        "',getdate()" +
                        "," + omodel.HSupID.ToString() +
@@ -326,7 +326,7 @@
                      "," + oSub.HSeOrderInterID.ToString() + "," + oSub.HSeOrderEntryID.ToString() + ",'" + oSub.HSeOrderBillNo + "'" +
                      ") ";

                    if (oSystemParameter.omodel.WMS_CampanyName == "乔一")              //乔一客户
                    if (true)              //乔一客户
                    {
                        subSql = "Insert into Kf_ICStockBillSub" +
                            "(HInterID,HEntryID,HCloseMan,HEntryCloseDate,HCloseType,HRemark,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney,HMaterID,HPropertyID,HSecUnitID,HSecUnitRate,HUnitID,HQtyMust" +
@@ -451,7 +451,7 @@
                Pub_Class.ClsXt_SystemParameter oSystemParameter = new Pub_Class.ClsXt_SystemParameter();
                string sErrMsg = "";
                oSystemParameter.ShowBill(ref sErrMsg);
                if (oSystemParameter.omodel.WMS_CampanyName == "乔一")              //乔一客户
                if (true)              //乔一客户
                {
                    omodel.HICMOInterID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HICMOInterID"]);
                    omodel.HICMOEntryID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HICMOEntryID"]);
@@ -523,7 +523,7 @@
                    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 (true)              //乔一客户
                    {
                        oSub.HRate = DBUtility.ClsPub.isDoule(DsSub.Tables[0].Rows[0]["HRate"]);
                    }