DAL/销售管理/ClsXs_OutDoorBill.cs
@@ -69,6 +69,7 @@
                ",HCarNumber='" + omodel.HCarNumber + "'" +
                ",HPhone='" + omodel.HPhone + "'" +
                ",HOutReason='" + omodel.HOutReason + "'" +
                ",HOutAddress='" + omodel.HOutAddress + "'" +
                ",HMaterName='" + omodel.HMaterName + "'" +
                " where HInterID=" + lngBillKey.ToString();
@@ -171,7 +172,7 @@
                //鎻掑叆涓昏〃
                string mainSql = "Insert Into Xs_OutDoorBillMain" +
                    "(HYear,HPeriod,HBillType,HBillSubType,HInterID,HBillNo,HDate,HBillStatus,HMaker,HMakeDate,HRemark,HStockOrgID" +
                    ",HCusID,HEmpID,HShipper,HCarNumber,HPhone,HOutReason,HMaterName) " +
                    ",HCusID,HEmpID,HShipper,HCarNumber,HPhone,HOutReason,HOutAddress,HMaterName) " +
                    "values(" +
                    "" + omodel.HDate.Year + "" +
                    "," + omodel.HDate.Month + "" +
@@ -192,6 +193,7 @@
                    ",'" + omodel.HCarNumber + "'" +
                    ",'" + omodel.HPhone + "'" +
                    ",'" + omodel.HOutReason + "'" +
                    ",'" + omodel.HOutAddress + "'" +
                    ",'" + omodel.HMaterName + "'" +
                    ")";
@@ -300,6 +302,7 @@
                omodel.HCarNumber = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HCarNumber"]);
                omodel.HPhone = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HPhone"]);
                omodel.HOutReason = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HOutReason"]);
                omodel.HOutAddress = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HOutAddress"]);
                omodel.HMaterName = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HMaterName"]);
                omodel.HOutCheckMan = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HOutCheckMan"]);
                omodel.HOutCheckDate = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HOutCheckDate"]);