合并

yusijie

6 天以前 6866dbd4b0b8703811872669179a68841eea803d

 DAL/销售管理/ClsXs_SeOrderBill.cs

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

@@ -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" +
                    ",HInterID,HBillNo,HDate,HInnerBillNo,HAddress,HDeptID,HCusID,HEmpID,HCurID,HExRate,HEarnestRate,HManagerID,HSellSID,HSSID,HSSDate,HPayCusID,HRemark,HOrgID,HMaker,HMakeDate,HLinkMan,HLinkPhone,HSellDate" +
                    ",HERPInterID,HERPBillType,HSALEORGID,HSALEGROUPID,HRECEIVEID,HSETTLEID,HCHARGEID,HHEADLOCID,HRECCONTACTID,HCORRESPONDORGID,HBUSINESSTYPE,HProjectID,HWHID,HProductType) " +
                    "values(" +
                    "" + omodel.HYear +
@@ -316,7 +317,7 @@

                    ",'" + omodel.HLinkMan +
                    "','" + omodel.HLinkPhone +

                    "','" + omodel.HSellDate +
                    "'," + omodel.HERPInterID +
                    ",'" + omodel.HERPBillType +
                    "'," + omodel.HSALEORGID +
@@ -498,6 +499,7 @@

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