11

pzy

2024-08-26 dbbcd506929afda0a85ae23bcb5f88c1dccef387

 DAL/销售管理/ClsXs_SeOutStockBackBillForLayUI.cs

@@ -89,6 +89,7 @@
                ",HAddress='" + omodel.HAddress + "'" +
                ",HExplanation='" + omodel.HExplanation + "'" +
                ",HInnerBillNo='" + omodel.HInnerBillNo + "'" +
                ",HProjectID='" + omodel.HProjectID + "'" +
                " where HInterID=" + lngBillKey.ToString());
                //鍒犻櫎鍏宠仈
                //DeleteRelation(ref sReturn, lngBillKey);
@@ -164,12 +165,12 @@
                "(HBillType,HBillSubType,HInterID,HBillNo,HDate" +
                ",HYear,HPeriod,HRemark,HMaker,HMakeDate" +
                ",HAddress,HSSID,HCusID,HWHID,HCurID,HExRate" +
                ",HEmpID,HManagerID,HDeptID,HExplanation,HInnerBillNo" +
                ",HEmpID,HManagerID,HDeptID,HExplanation,HInnerBillNo,HProjectID" +
                ") " +
                " values('" + this.BillType + "','"  + this.HBillSubType + "'," +omodel.HInterID.ToString() + ",'" + omodel.HBillNo + "','" + omodel.HDate + "'" +
                ", " + omodel.HYear.ToString() + "," + omodel.HPeriod.ToString() + ",'" + omodel.HRemark + "','" + omodel.HMaker + "',getdate()" +
                ",'" + omodel.HAddress + "'," + omodel.HSSID.ToString() + "," + omodel.HCusID.ToString() + "," + omodel.HWHID.ToString() + "," + omodel.HCurID.ToString() + "," + omodel.HExRate.ToString() +
                ", " + omodel.HEmpID.ToString() + "," + omodel.HManagerID.ToString() + "," + omodel.HDeptID.ToString() + ",'" + omodel.HExplanation + "','" + omodel.HInnerBillNo + "'"+
                ", " + omodel.HEmpID.ToString() + "," + omodel.HManagerID.ToString() + "," + omodel.HDeptID.ToString() + ",'" + omodel.HExplanation + "','" + omodel.HInnerBillNo + "','"+omodel.HProjectID.ToString()+"'"+
                ") ");
                //鎻掑叆瀛愯〃
                foreach (Model.ClsXs_SeOutStockBackBillSub oSub in DetailColl)