From 7bcbbbd0459f00ebc3aa7d4f249cb9231a6b5d40 Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期五, 31 十月 2025 12:25:17 +0800
Subject: [PATCH] 这个销售绩效查询这个列表中的，你把这个到期类型和到期时间合并，现在到期类型就不要了， 到期时间里面，日期的就显示。时间，他是和金额执行完毕的，就在到期时间里头， 就填上金额执行完毕那个合同金额也是就有金额的显示。金额没得金额的，就先据实结算。好，合同类型这个就不要了。
---
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