From db32c8221ae179f6b20cc62467200c0681d10f61 Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期五, 17 一月 2025 12:20:01 +0800
Subject: [PATCH] 修改合同上传
---
CY_ECommercePlatform/CY.WebForm/Global.asax.cs | 24 ++++++++++++------------
CY_ECommercePlatform/CY.WebForm/Pages/business/OrderEdit.aspx | 2 +-
CY_ECommercePlatform/CY.WebForm/Pages/business/OrderList.aspx | 2 +-
CY_ECommercePlatform/CY.WebForm/Pages/business/CorporateClientsContractShow.aspx.cs | 2 +-
CY_ECommercePlatform/CY.WebForm/Pages/business/CorporateClientsList.aspx | 6 ++++++
CY_ECommercePlatform/CY.WebForm/Pages/business/CorporateClientsUpLoadContract.aspx.cs | 16 ++++++++--------
CY_ECommercePlatform/CY.WebForm/Helper/upLoadContractFile.cs | 4 ++--
CY_ECommercePlatform/CY.WebForm/Pages/business/CorporateClientsVisit.aspx.cs | 4 ++--
8 files changed, 33 insertions(+), 27 deletions(-)
diff --git a/CY_ECommercePlatform/CY.WebForm/Global.asax.cs b/CY_ECommercePlatform/CY.WebForm/Global.asax.cs
index e9532fb..ffb0dd6 100644
--- a/CY_ECommercePlatform/CY.WebForm/Global.asax.cs
+++ b/CY_ECommercePlatform/CY.WebForm/Global.asax.cs
@@ -41,7 +41,7 @@
{
Database DC = new Database();
- string sqlStr = "USE [ECTEST] UPDATE[dbo].[OA_CorporateClients] SET [NeedWiHu] = 'true' WHERE[Shifouwanjie] = 2";
+ string sqlStr = " UPDATE[dbo].[OA_CorporateClients] SET [NeedWiHu] = 'true' WHERE[Shifouwanjie] = 2";
try
{
@@ -81,7 +81,7 @@
{
//1 銆�4銆�7銆�10鏈� 1鍙�1鐐癸紝鍒锋柊 宸插畬缁撹鍗曠殑缁存姢鎻愰啋
Database DC = new Database();
- string sqlStr = "USE [ECTEST] UPDATE[dbo].[OA_CorporateClients] SET [NeedWiHu] = 'true' WHERE[Shifouwanjie] = 1";
+ string sqlStr = " UPDATE[dbo].[OA_CorporateClients] SET [NeedWiHu] = 'true' WHERE[Shifouwanjie] = 1";
try
{
@@ -122,7 +122,7 @@
{
Database DC = new Database();
- string sqlStr = "USE [ECTEST] UPDATE[dbo].[OA_CorporateClients] SET [JieJiaRiWiHu] = 'true'";
+ string sqlStr = " UPDATE[dbo].[OA_CorporateClients] SET [JieJiaRiWiHu] = 'true'";
try
{
@@ -153,7 +153,7 @@
{
//涓鑺傛彁閱�
Database DC = new Database();
- string sqlStr = "USE [ECTEST] UPDATE[dbo].[OA_CorporateClients] SET [JieJiaRiWiHu] = 'true'";
+ string sqlStr = " UPDATE[dbo].[OA_CorporateClients] SET [JieJiaRiWiHu] = 'true'";
try
{
@@ -181,7 +181,7 @@
{
//绔崍鑺�
Database DC = new Database();
- string sqlStr = "USE [ECTEST] UPDATE[dbo].[OA_CorporateClients] SET [JieJiaRiWiHu] = 'true'";
+ string sqlStr = " UPDATE[dbo].[OA_CorporateClients] SET [JieJiaRiWiHu] = 'true'";
try
{
@@ -216,7 +216,7 @@
{
//涓鑺傛彁閱�
Database DC = new Database();
- string sqlStr = "USE [ECTEST] UPDATE[dbo].[OA_CorporateClients] SET [JieJiaRiWiHu] = 'true'";
+ string sqlStr = " UPDATE[dbo].[OA_CorporateClients] SET [JieJiaRiWiHu] = 'true'";
try
{
@@ -247,7 +247,7 @@
{
//绔崍鑺�
Database DC = new Database();
- string sqlStr = "USE [ECTEST] UPDATE[dbo].[OA_CorporateClients] SET [JieJiaRiWiHu] = 'true'";
+ string sqlStr = " UPDATE[dbo].[OA_CorporateClients] SET [JieJiaRiWiHu] = 'true'";
try
{
@@ -288,7 +288,7 @@
{
Database DC = new Database();
- string sqlStr = "USE [ECTEST] UPDATE[dbo].[OA_CorporateClients] SET [JieJiaRiWiHu] = 'false'";
+ string sqlStr = " UPDATE[dbo].[OA_CorporateClients] SET [JieJiaRiWiHu] = 'false'";
try
{
@@ -320,7 +320,7 @@
{
//涓鑺傛彁閱�
Database DC = new Database();
- string sqlStr = "USE [ECTEST] UPDATE[dbo].[OA_CorporateClients] SET [JieJiaRiWiHu] = 'false'";
+ string sqlStr = " UPDATE[dbo].[OA_CorporateClients] SET [JieJiaRiWiHu] = 'false'";
try
{
@@ -348,7 +348,7 @@
{
//绔崍鑺�
Database DC = new Database();
- string sqlStr = "USE [ECTEST] UPDATE[dbo].[OA_CorporateClients] SET [JieJiaRiWiHu] = 'false'";
+ string sqlStr = " UPDATE[dbo].[OA_CorporateClients] SET [JieJiaRiWiHu] = 'false'";
try
{
@@ -383,7 +383,7 @@
{
//涓鑺傛彁閱�
Database DC = new Database();
- string sqlStr = "USE [ECTEST] UPDATE[dbo].[OA_CorporateClients] SET [JieJiaRiWiHu] = 'false'";
+ string sqlStr = " UPDATE[dbo].[OA_CorporateClients] SET [JieJiaRiWiHu] = 'false'";
try
{
@@ -414,7 +414,7 @@
{
//绔崍鑺�
Database DC = new Database();
- string sqlStr = "USE [ECTEST] UPDATE[dbo].[OA_CorporateClients] SET [JieJiaRiWiHu] = 'false'";
+ string sqlStr = " UPDATE[dbo].[OA_CorporateClients] SET [JieJiaRiWiHu] = 'false'";
try
{
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);
diff --git a/CY_ECommercePlatform/CY.WebForm/Pages/business/CorporateClientsContractShow.aspx.cs b/CY_ECommercePlatform/CY.WebForm/Pages/business/CorporateClientsContractShow.aspx.cs
index 5c24e29..0f7e454 100644
--- a/CY_ECommercePlatform/CY.WebForm/Pages/business/CorporateClientsContractShow.aspx.cs
+++ b/CY_ECommercePlatform/CY.WebForm/Pages/business/CorporateClientsContractShow.aspx.cs
@@ -36,7 +36,7 @@
return;
}
Database DC = new Database();
- string sqlStr = string.Format(@"USE [ECTEST] select * from [dbo].[OA_CorporateClientContract] where CorporateClientsid='{0}' order by PageCode ", Keyid);
+ string sqlStr = string.Format(@" select * from [dbo].[OA_CorporateClientContract] where CorporateClientsid='{0}' order by PageCode ", Keyid);
int count = 0;
try
{
diff --git a/CY_ECommercePlatform/CY.WebForm/Pages/business/CorporateClientsList.aspx b/CY_ECommercePlatform/CY.WebForm/Pages/business/CorporateClientsList.aspx
index 239d891..70c5c3f 100644
--- a/CY_ECommercePlatform/CY.WebForm/Pages/business/CorporateClientsList.aspx
+++ b/CY_ECommercePlatform/CY.WebForm/Pages/business/CorporateClientsList.aspx
@@ -288,8 +288,11 @@
</th>
<th style="text-align: center;">鏈笅鍗曢噾棰�
</th>
+ <th style="text-align: center;">鍚堝悓
+ </th>
<th style="text-align: center;">瀹岀粨鐘舵��
</th>
+
<th>鎿嶄綔
</th>
</tr>
@@ -354,6 +357,9 @@
<td >
<%#Eval("Contractmoney","{0:F2}").ToString()=="0.00"||Eval("Contractmoney","{0:F2}").ToString()=="" ?"鏈缃悎鍚岄噾棰�" : Eval("LessOrderMoneyProperty","{0:F2}")%>
</td>
+ <td>
+ <%#Eval("ContractCount").ToString() == "0" ? "脳" : "鈭�" %>
+ </td>
<td>
<%#Eval("ShifouwanjieName")%>
</td>
diff --git a/CY_ECommercePlatform/CY.WebForm/Pages/business/CorporateClientsUpLoadContract.aspx.cs b/CY_ECommercePlatform/CY.WebForm/Pages/business/CorporateClientsUpLoadContract.aspx.cs
index ec15658..7a2755b 100644
--- a/CY_ECommercePlatform/CY.WebForm/Pages/business/CorporateClientsUpLoadContract.aspx.cs
+++ b/CY_ECommercePlatform/CY.WebForm/Pages/business/CorporateClientsUpLoadContract.aspx.cs
@@ -47,7 +47,7 @@
string keyid = Request["deleteKeyIds"].ToString();
string pageID = Request["Keyid"];
Database DC = new Database();
- string sqlStr = string.Format(@"USE [ECTEST] SELECT[Keyid] ,[CorporateClientsid] ,[CorporateClientsName] ,[FileName] ,[PageCode] ,[FilePath] ,[Remark] FROM[dbo].[OA_CorporateClientContract] where CorporateClientsid='{0}'ORDER BY PageCode ", pageID);
+ string sqlStr = string.Format(@" SELECT[Keyid] ,[CorporateClientsid] ,[CorporateClientsName] ,[FileName] ,[PageCode] ,[FilePath] ,[Remark] FROM[dbo].[OA_CorporateClientContract] where CorporateClientsid='{0}'ORDER BY PageCode ", pageID);
try
@@ -83,7 +83,7 @@
file.Attributes = FileAttributes.Normal;//灏嗘枃浠跺睘鎬ц缃负鏅��,姣旀柟璇村彧璇绘枃浠惰缃负鏅��
file.Delete();//鍒犻櫎鏂囦欢
}
- sqlStr = string.Format(@"USE [ECTEST]DELETE FROM [dbo].[OA_CorporateClientContract] where Keyid='{0}'", item.Keyid);
+ sqlStr = string.Format(@" DELETE FROM [dbo].[OA_CorporateClientContract] where Keyid='{0}'", item.Keyid);
myCmd = new SqlCommand(sqlStr, DC.Connection);
myCmd.ExecuteNonQuery();
myCmd.Dispose();
@@ -114,7 +114,7 @@
//鍒犻櫎椤甸潰
string keyid = Request["deleteKeyIds"].ToString();
Database DC = new Database();
- string sqlStr = string.Format(@"USE [ECTEST] SELECT[Keyid] ,[CorporateClientsid] ,[CorporateClientsName] ,[FileName] ,[PageCode] ,[FilePath] ,[Remark] FROM[dbo].[OA_CorporateClientContract] where Keyid='{0}'ORDER BY PageCode ", keyid);
+ string sqlStr = string.Format(@" SELECT[Keyid] ,[CorporateClientsid] ,[CorporateClientsName] ,[FileName] ,[PageCode] ,[FilePath] ,[Remark] FROM[dbo].[OA_CorporateClientContract] where Keyid='{0}'ORDER BY PageCode ", keyid);
try
@@ -149,7 +149,7 @@
file.Delete();//鍒犻櫎鏂囦欢
}
}
- sqlStr = string.Format(@"USE [ECTEST]DELETE FROM [dbo].[OA_CorporateClientContract] where Keyid='{0}'", keyid);
+ sqlStr = string.Format(@" DELETE FROM [dbo].[OA_CorporateClientContract] where Keyid='{0}'", keyid);
myCmd = new SqlCommand(sqlStr, DC.Connection);
myCmd.ExecuteNonQuery();
JavaScript.MessageBox("鍒犻櫎鎴愬姛", this);
@@ -196,7 +196,7 @@
return;
}
Database DC = new Database();
- string sqlStr =string.Format(@"USE [ECTEST] select * from (select ROW_NUMBER() OVER(Order by PageCode) AS RowNumber,* from [dbo].[OA_CorporateClientContract] where CorporateClientsid='{0}' ) as b where b.RowNumber BETWEEN ({1}-1)*({2})+1 and {1}*{2} order by PageCode ", Keyid,pa.PageIndex,pa.PageSize);
+ string sqlStr =string.Format(@" select * from (select ROW_NUMBER() OVER(Order by PageCode) AS RowNumber,* from [dbo].[OA_CorporateClientContract] where CorporateClientsid='{0}' ) as b where b.RowNumber BETWEEN ({1}-1)*({2})+1 and {1}*{2} order by PageCode ", Keyid,pa.PageIndex,pa.PageSize);
int count = 0;
try
{
@@ -370,7 +370,7 @@
string pageID = Request["Keyid"];
Database DC = new Database();
- string sqlStr = string.Format(@"USE [ECTEST] SELECT[Keyid] ,[CorporateClientsid] ,[CorporateClientsName] ,[FileName] ,[PageCode] ,[FilePath] ,[Remark] FROM[dbo].[OA_CorporateClientContract] where CorporateClientsid='{0}'ORDER BY PageCode ", pageID);
+ string sqlStr = string.Format(@" SELECT[Keyid] ,[CorporateClientsid] ,[CorporateClientsName] ,[FileName] ,[PageCode] ,[FilePath] ,[Remark] FROM[dbo].[OA_CorporateClientContract] where CorporateClientsid='{0}'ORDER BY PageCode ", pageID);
try
@@ -406,7 +406,7 @@
file.Attributes = FileAttributes.Normal;//灏嗘枃浠跺睘鎬ц缃负鏅��,姣旀柟璇村彧璇绘枃浠惰缃负鏅��
file.Delete();//鍒犻櫎鏂囦欢
}
- sqlStr = string.Format(@"USE [ECTEST]DELETE FROM [dbo].[OA_CorporateClientContract] where Keyid='{0}'", item.Keyid);
+ sqlStr = string.Format(@" DELETE FROM [dbo].[OA_CorporateClientContract] where Keyid='{0}'", item.Keyid);
myCmd = new SqlCommand(sqlStr, DC.Connection);
myCmd.ExecuteNonQuery();
myCmd.Dispose();
@@ -586,7 +586,7 @@
- string sqlStr = string.Format(@"USE [ECTEST] SELECT[Keyid] FROM[dbo].[OA_CorporateClientContract] where CorporateClientsid='{0}' and [PageCode]='{1}' ", Keyid, Pagecode);
+ string sqlStr = string.Format(@" SELECT[Keyid] FROM[dbo].[OA_CorporateClientContract] where CorporateClientsid='{0}' and [PageCode]='{1}' ", Keyid, Pagecode);
try
{
diff --git a/CY_ECommercePlatform/CY.WebForm/Pages/business/CorporateClientsVisit.aspx.cs b/CY_ECommercePlatform/CY.WebForm/Pages/business/CorporateClientsVisit.aspx.cs
index 152ed11..3c51962 100644
--- a/CY_ECommercePlatform/CY.WebForm/Pages/business/CorporateClientsVisit.aspx.cs
+++ b/CY_ECommercePlatform/CY.WebForm/Pages/business/CorporateClientsVisit.aspx.cs
@@ -152,7 +152,7 @@
{
Database DC = new Database();
- string sqlStr = string.Format("USE [ECTEST] UPDATE[dbo].[OA_CorporateClients] SET [NeedWiHu] = 'false' where Keyid='{0}'", Request["Keyid"]);
+ string sqlStr = string.Format(" UPDATE[dbo].[OA_CorporateClients] SET [NeedWiHu] = 'false' where Keyid='{0}'", Request["Keyid"]);
try
{
@@ -274,7 +274,7 @@
Database DC = new Database();
- string sqlStr = string.Format("USE [ECTEST] UPDATE[dbo].[OA_CorporateClients] SET [JieJiaRiWiHu] = 'false' where Keyid='{0}'", Request["Keyid"]);
+ string sqlStr = string.Format(" UPDATE[dbo].[OA_CorporateClients] SET [JieJiaRiWiHu] = 'false' where Keyid='{0}'", Request["Keyid"]);
try
{
diff --git a/CY_ECommercePlatform/CY.WebForm/Pages/business/OrderEdit.aspx b/CY_ECommercePlatform/CY.WebForm/Pages/business/OrderEdit.aspx
index 3b67f4e..d384711 100644
--- a/CY_ECommercePlatform/CY.WebForm/Pages/business/OrderEdit.aspx
+++ b/CY_ECommercePlatform/CY.WebForm/Pages/business/OrderEdit.aspx
@@ -346,7 +346,7 @@
<table class="table2 table2Left" align="left" style=" width:1000px;">
<tr style=" height:11px;">
<td style="width:100px;text-align:right;">
- 瀵瑰簲鍚堝悓缂栧彿锛�
+ 瀵瑰簲鍚堝悓搴忓彿锛�
</td>
<td style="text-align:left;" >
<input id='txtDuiyinghetongbianhao' runat="server" maxlength="100" style="width:300px;" />
diff --git a/CY_ECommercePlatform/CY.WebForm/Pages/business/OrderList.aspx b/CY_ECommercePlatform/CY.WebForm/Pages/business/OrderList.aspx
index 4934f37..12bc118 100644
--- a/CY_ECommercePlatform/CY.WebForm/Pages/business/OrderList.aspx
+++ b/CY_ECommercePlatform/CY.WebForm/Pages/business/OrderList.aspx
@@ -384,7 +384,7 @@
鍗颁欢鍚嶇О
</th>
<th style="width:100px;">
- 瀵瑰簲鍚堝悓缂栧彿
+ 鍚堝悓搴忓彿
</th>
<th width="36">
鏁伴噺
--
Gitblit v1.9.1