From 92a92c2fc694810fdba050f1034ef107ad5c858f Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期五, 07 十一月 2025 09:05:16 +0800
Subject: [PATCH] 那个作业本送货，查看明细或查看送货情况。这个列表中，比如说某个品种，它本来就没得的， 、那个格子里头不显零，格子里头就不要任何数据。不然，我们要要混乱好写了0的 ，我们才晓得这是有好已经送了的，就这样子修改，就某个品种，它本来就没得的格子头就是空白， 不不要写的，你这样子修改一下。
---
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