陈镐哲 2025/4/22 提交

chenhaozhe

2 天以前 d7f3369550e06d123fc959f8da3549535c2a5afe

 DAL/销售管理/ClsXs_SeOrderBill.cs

@@ -106,6 +106,7 @@
                ",HWHID='" + omodel.HWHID + "'" +
                ",HProjectID='" + omodel.HProjectID + "'" +
                ",HLinkPhone='" + omodel.HLinkPhone + "'" +
                ",HProductType='" + omodel.HProductType + "'" +
                " where HInterID=" + lngBillKey.ToString();

                oCn.RunProc(mainSql);
@@ -283,7 +284,7 @@
                string mainSql = "Insert Into Xs_SeOrderBillMain" +
                    "(HYear,HPeriod,HBillType,HBillSubType,HBillStatus,HExplanation" +
                    ",HInterID,HBillNo,HDate,HInnerBillNo,HAddress,HDeptID,HCusID,HEmpID,HCurID,HExRate,HEarnestRate,HManagerID,HSellSID,HSSID,HSSDate,HPayCusID,HRemark,HOrgID,HMaker,HMakeDate,HLinkMan,HLinkPhone" +
                    ",HERPInterID,HERPBillType,HSALEORGID,HSALEGROUPID,HRECEIVEID,HSETTLEID,HCHARGEID,HHEADLOCID,HRECCONTACTID,HCORRESPONDORGID,HBUSINESSTYPE,HProjectID,HWHID) " +
                    ",HERPInterID,HERPBillType,HSALEORGID,HSALEGROUPID,HRECEIVEID,HSETTLEID,HCHARGEID,HHEADLOCID,HRECCONTACTID,HCORRESPONDORGID,HBUSINESSTYPE,HProjectID,HWHID,HProductType) " +
                    "values(" +
                    "" + omodel.HYear +
                    "," + omodel.HPeriod +
@@ -330,6 +331,7 @@

                    "','" + omodel.HProjectID +
                    "','" + omodel.HWHID +
                    "','" + omodel.HProductType +
                    "')";
                    
                oCn.RunProc(mainSql);
@@ -496,6 +498,7 @@

                omodel.HLinkMan = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HLinkMan"]);
                omodel.HLinkPhone = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HLinkPhone"]);
                omodel.HProductType = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HProductType"]);
                //

                //寰幆