From 908a189a83797f2e2037aa55f1841d2496137672 Mon Sep 17 00:00:00 2001
From: zrg <z18737863051@163.com>
Date: 星期二, 16 七月 2024 09:24:01 +0800
Subject: [PATCH] 增加休息日后端保存和批量保存
---
DAL/销售管理/ClsXs_ExceptiveCheckRequestBill.cs | 16 +++++++++++++++-
1 files changed, 15 insertions(+), 1 deletions(-)
diff --git "a/DAL/\351\224\200\345\224\256\347\256\241\347\220\206/ClsXs_ExceptiveCheckRequestBill.cs" "b/DAL/\351\224\200\345\224\256\347\256\241\347\220\206/ClsXs_ExceptiveCheckRequestBill.cs"
index 2dae0d1..0c9bcd1 100644
--- "a/DAL/\351\224\200\345\224\256\347\256\241\347\220\206/ClsXs_ExceptiveCheckRequestBill.cs"
+++ "b/DAL/\351\224\200\345\224\256\347\256\241\347\220\206/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();
@@ -119,7 +120,8 @@
string mainSql = "Insert Into Xs_ExceptiveCheckRequestBillMain " +
"(" +
"HBillType,HBillSubType,HInterID,HBillNo,HDate,HYear,HPeriod,HRemark,HMaker,HMakeDate" +
- ",HDeptID,HEmpID,HCurID,HExRate,HCusID,HManagerID,HReason,HSendMoney,HLeftMoney,HOrgID,HSendQty,HLastSendDate,HCreditRating_Q,HMaxCreditRating_Q" +
+ ",HMainSourceInterID,HMainSourceEntryID,HMainSourceBillNo,HMainSourceBillType" +
+ ",HDeptID,HEmpID,HCurID,HExRate,HCusID,HManagerID,HReason,HSendMoney,HLeftMoney,HOrgID,HSendQty,HLastSendDate,HPlanPayDate,HCreditRating_Q,HMaxCreditRating_Q" +
") " +
" values('" +
this.BillType +
@@ -132,6 +134,10 @@
",'" + omodel.HRemark + "'" +
",'" + DBUtility.ClsPub.CurUserName + "'" +
",getdate()" +
+ "," + omodel.HMainSourceInterID +
+ "," + omodel.HMainSourceEntryID +
+ ",'" + omodel.HMainSourceBillNo + "'" +
+ ",'" + omodel.HMainSourceBillType + "'" +
"," + omodel.HDeptID +
"," + omodel.HEmpID +
"," + omodel.HCurID +
@@ -144,6 +150,7 @@
"," + omodel.HOrgID +
"," + omodel.HSendQty +
",'" + omodel.HLastSendDate + "'" +
+ ",'" + omodel.HPlanPayDate + "'" +
"," + omodel.HCreditRating_Q +
"," + omodel.HMaxCreditRating_Q +
")";
@@ -213,6 +220,11 @@
omodel.HCloseType = DBUtility.ClsPub.isBool(Ds.Tables[0].Rows[0]["HCloseType"]);
omodel.HDeleteDate = Ds.Tables[0].Rows[0]["HDeleteDate"].ToString().Trim();
omodel.HDeleteMan = Ds.Tables[0].Rows[0]["HDeleteMan"].ToString().Trim();
+
+ omodel.HMainSourceInterID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HMainSourceInterID"]);
+ omodel.HMainSourceEntryID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HMainSourceEntryID"]);
+ omodel.HMainSourceBillNo = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HMainSourceBillNo"]);
+ omodel.HMainSourceBillType = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HMainSourceBillType"]);
//========================================================
omodel.HDeptID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HDeptID"]);
omodel.HEmpID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HEmpID"]);
@@ -227,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"]);
//
--
Gitblit v1.9.1