From 90c30b1cee537ffe0ce22b421cea93538c29a2c6 Mon Sep 17 00:00:00 2001
From: duhe <226547893@qq.com>
Date: 星期五, 10 一月 2025 16:37:54 +0800
Subject: [PATCH] 1
---
DAL/计划管理/ClsGy_RoutingBill.cs | 8 +++++---
1 files changed, 5 insertions(+), 3 deletions(-)
diff --git "a/DAL/\350\256\241\345\210\222\347\256\241\347\220\206/ClsGy_RoutingBill.cs" "b/DAL/\350\256\241\345\210\222\347\256\241\347\220\206/ClsGy_RoutingBill.cs"
index 79a54e7..4a5baff 100644
--- "a/DAL/\350\256\241\345\210\222\347\256\241\347\220\206/ClsGy_RoutingBill.cs"
+++ "b/DAL/\350\256\241\345\210\222\347\256\241\347\220\206/ClsGy_RoutingBill.cs"
@@ -108,7 +108,7 @@
") ");
}
//
- oCn.RunProc("exec h_p_Gy_RoutingBillCheck " + omodel.HInterID.ToString()); //璁剧疆榛樿宸ヨ壓璺嚎
+ oCn.RunProc("exec h_p_Gy_RoutingBillCheck " + omodel.HInterID.ToString() + ",'" + DBUtility.ClsPub.CurUserName + "'"); //璁剧疆榛樿宸ヨ壓璺嚎
//oCn.RunProc("exec h_p_Sc_ProcessExchangeBillSetUpdate " + omodel.HInterID.ToString()); //璁剧疆棣栭亾鏈亾 娴佽浆鏍囪 绛� 瀛楁銆�
//
//鍒ゆ柇鏄惁閲嶅宸ュ簭鍙�
@@ -242,7 +242,7 @@
") ");
}
//
- oCn.RunProc("exec h_p_Gy_RoutingBillCheck " + omodel.HInterID.ToString()); //璁剧疆榛樿宸ヨ壓璺嚎
+ oCn.RunProc("exec h_p_Gy_RoutingBillCheck " + omodel.HInterID.ToString() + ",'" + DBUtility.ClsPub.CurUserName + "'"); //璁剧疆榛樿宸ヨ壓璺嚎
//oCn.RunProc("exec h_p_Sc_ProcessExchangeBillSetUpdate " + omodel.HInterID.ToString()); //璁剧疆棣栭亾鏈亾 娴佽浆鏍囪 绛� 瀛楁銆�
//
//鍒ゆ柇鏄惁閲嶅宸ュ簭鍙�
@@ -280,7 +280,7 @@
{
//鏌ヨ涓昏〃
DataSet Ds ;
- Ds = oCn.RunProcReturn("Select * from Gy_RoutingBillMain Where HInterID=" + lngBillKey.ToString()+" and HPRDORGID='"+DBUtility.ClsPub.HOrgID.ToString()+"'", "Gy_RoutingBillMain");
+ Ds = oCn.RunProcReturn("Select * from Gy_RoutingBillMain Where HInterID=" + lngBillKey.ToString(), "Gy_RoutingBillMain");
if(Ds.Tables[0].Rows.Count==0)
{
sReturn = "鍗曟嵁鏈壘鍒帮紒";
@@ -288,6 +288,8 @@
}
//璧嬪��
omodel.HInterID =DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HInterID"].ToString());
+ omodel.HBillStatus = DBUtility.ClsPub.isInt(Ds.Tables[0].Rows[0]["HBillStatus"].ToString());
+
omodel.HBillNo = Ds.Tables[0].Rows[0]["HBillNo"].ToString().Trim();
omodel.HName = Ds.Tables[0].Rows[0]["HName"].ToString().Trim();
omodel.HDate = Convert.ToDateTime(Ds.Tables[0].Rows[0]["HDate"].ToString().Trim());
--
Gitblit v1.9.1