From 847fb7063af8e80bd864709ba8e97f06dc87ac4f Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期三, 19 十一月 2025 10:02:48 +0800
Subject: [PATCH] 20251118 查看送货情况列表默认“未送货”和“配送中”的学校 完成
---
CY_ECommercePlatform/CY.WebForm/Helper/upLoadContractFile.cs | 4 ++--
1 files changed, 2 insertions(+), 2 deletions(-)
diff --git a/CY_ECommercePlatform/CY.WebForm/Helper/upLoadContractFile.cs b/CY_ECommercePlatform/CY.WebForm/Helper/upLoadContractFile.cs
index d9701e3..3c06ab6 100644
--- a/CY_ECommercePlatform/CY.WebForm/Helper/upLoadContractFile.cs
+++ b/CY_ECommercePlatform/CY.WebForm/Helper/upLoadContractFile.cs
@@ -38,7 +38,7 @@
if (CountractFileKeiId != null)
{
//淇敼鏂囦欢
- sqlStr = string.Format(@"SELECT [Keyid] ,[FileName] ,[PageCode] ,[FilePath] ,[Remark] FROM [ECTEST].[dbo].[OA_CorporateClientContract] where Keyid='{0}'", CountractFileKeiId.ToString());
+ sqlStr = string.Format(@"SELECT [Keyid] ,[FileName] ,[PageCode] ,[FilePath] ,[Remark] FROM [dbo].[OA_CorporateClientContract] where Keyid='{0}'", CountractFileKeiId.ToString());
//寮�濮嬩慨鏀规枃浠�
SqlCommand myCmd = new SqlCommand(sqlStr, DC.Connection);
@@ -84,7 +84,7 @@
throw e;
}
//鍐欏叆鏁版嵁搴�
- sqlStr = string.Format(@"USE [ECTEST] INSERT INTO [dbo].[OA_CorporateClientContract] ([Keyid] ,[CorporateClientsid] ,[CorporateClientsName] ,[FileName] ,[PageCode] ,[FilePath] ,[Remark] ,[Creater] ,[CreateTime] ) VALUES('{0}' ,'{1}' ,'{2}' ,'{3}' ,'{4}' ,'{5}' ,'{6}' ,'{7}' ,'{8}')",Guid.NewGuid().ToString(), Contract.CorporateClientsid.ToString(),"", Contract.FileName, Contract.PageCode, FilePath, Contract.Remark, Contract.Creater,DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
+ sqlStr = string.Format(@" INSERT INTO [dbo].[OA_CorporateClientContract] ([Keyid] ,[CorporateClientsid] ,[CorporateClientsName] ,[FileName] ,[PageCode] ,[FilePath] ,[Remark] ,[Creater] ,[CreateTime] ) VALUES('{0}' ,'{1}' ,'{2}' ,'{3}' ,'{4}' ,'{5}' ,'{6}' ,'{7}' ,'{8}')",Guid.NewGuid().ToString(), Contract.CorporateClientsid.ToString(),"", Contract.FileName, Contract.PageCode, FilePath, Contract.Remark, Contract.Creater,DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
try
{
SqlCommand myCmd = new SqlCommand(sqlStr, DC.Connection);
--
Gitblit v1.9.1