1

yusijie

2023-11-27 50cb13278527eb3c84516e82d7b0cbfed627a877

 DAL/销售管理/ClsXs_ExceptiveCheckRequestBill.cs

@@ -64,6 +64,7 @@
                ",HOrgID=" + omodel.HOrgID +
                ",HSendQty=" + omodel.HSendQty +
                ",HLastSendDate='" + omodel.HLastSendDate + "'" +
                ",HPlanPayDate='" + omodel.HPlanPayDate + "'" +
                ",HCreditRating_Q=" + omodel.HCreditRating_Q +
                ",HMaxCreditRating_Q=" + omodel.HMaxCreditRating_Q +
                " where HInterID=" + lngBillKey.ToString();
@@ -120,7 +121,7 @@
                "(" +
                "HBillType,HBillSubType,HInterID,HBillNo,HDate,HYear,HPeriod,HRemark,HMaker,HMakeDate" +
                ",HMainSourceInterID,HMainSourceEntryID,HMainSourceBillNo,HMainSourceBillType" +
                ",HDeptID,HEmpID,HCurID,HExRate,HCusID,HManagerID,HReason,HSendMoney,HLeftMoney,HOrgID,HSendQty,HLastSendDate,HCreditRating_Q,HMaxCreditRating_Q" +
                ",HDeptID,HEmpID,HCurID,HExRate,HCusID,HManagerID,HReason,HSendMoney,HLeftMoney,HOrgID,HSendQty,HLastSendDate,HPlanPayDate,HCreditRating_Q,HMaxCreditRating_Q" +
                ") " +
                " values('" +
                this.BillType + 
@@ -149,6 +150,7 @@
                "," + omodel.HOrgID +
                "," + omodel.HSendQty +
                ",'" + omodel.HLastSendDate + "'" +
                ",'" + omodel.HPlanPayDate + "'" +
                "," + omodel.HCreditRating_Q +
                "," + omodel.HMaxCreditRating_Q +
                ")";
@@ -237,6 +239,8 @@
                omodel.HSendQty = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HSendQty"]);
                omodel.HLastSendDate = DBUtility.ClsPub.isDate(Ds.Tables[0].Rows[0]["HLastSendDate"]);

                omodel.HPlanPayDate = DBUtility.ClsPub.isDate(Ds.Tables[0].Rows[0]["HPlanPayDate"]);

                omodel.HCreditRating_Q = DBUtility.ClsPub.isDoule(Ds.Tables[0].Rows[0]["HCreditRating_Q"]);
                omodel.HMaxCreditRating_Q = DBUtility.ClsPub.isDoule(Ds.Tables[0].Rows[0]["HMaxCreditRating_Q"]);
                //