From a7e05ebe00fdcb649c012e5afc4a42a8d631e824 Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期三, 02 四月 2025 08:38:24 +0800
Subject: [PATCH] 删除客户管理查询条件中的“客户编号” 完成 新增订单---黑白印件 的后道工序最右边增加一个“口 竖式”，同前面套号、压痕一样，默认不勾选，是竖式的业务经理自己下单时勾选 完成提交外协付款申请时，增加上传审批证明的上传图片功能，可以添加多张图片；查询列表中增加“付款状态：全部、已付款、未付款”查询条件，默认全部；“完工状态”改为默认未完工 完成请示批复----付款申请 中也要向上面的需求一样，增加上传审批证明的上传图片功能，可以添加多张图片 完成在“请示批复”中进行“批复”操作的时候要能查看上传的审批图片 完成包装要求”要显示在打印的订单中 完成包装要求”要显示在打印的订单中 完成收据联单的新增订单中，纸张选无碳纸时，不显示“品牌”、“克重”，在联数的后面增加颜色选择：“颜色：上白下红”（匹配联数）订单管理中的“订单状态”删除，删除后新增两个状态：“完工状态：全部、未完工、已完工”和“送货状态：全部、已送货、未送货” 完成请示批复中默认“未批复” 完成请示批复中默认“未批复” 完成
---
CY_ECommercePlatform/CY.WebForm/Pages/business/CorporateClientsUpLoadContract.aspx.cs | 24 ++++++++++++------------
1 files changed, 12 insertions(+), 12 deletions(-)
diff --git a/CY_ECommercePlatform/CY.WebForm/Pages/business/CorporateClientsUpLoadContract.aspx.cs b/CY_ECommercePlatform/CY.WebForm/Pages/business/CorporateClientsUpLoadContract.aspx.cs
index 6f2c9e8..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
{
@@ -311,14 +311,14 @@
{
uploadContract.SavAndUpDataContractFile(item, CountractFileKeiId: g);
- JavaScript.MessageBox( "涓婁紶鏂囦欢鎴愬姛", this);
+ JavaScript.MessageBoxandhideLoadingIndicator( "涓婁紶鏂囦欢鎴愬姛", this);
//JavaScript.RefreshSelf(this);
//JavaScript.RefreshOpener(this);
}
catch (Exception)
{
- JavaScript.MessageBox("涓婁紶鏂囦欢澶辫触", this);
+ JavaScript.MessageBoxandhideLoadingIndicator("涓婁紶鏂囦欢澶辫触", this);
// JavaScript.RefreshSelf(this);
//JavaScript.RefreshOpener(this);
@@ -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();
@@ -468,14 +468,14 @@
{
uploadContract.SavAndUpDataContractFile(postedFile,CountractFileKeiId :g);
- JavaScript.MessageBox("涓婁紶鏂囦欢鎴愬姛", this);
+ JavaScript.MessageBoxandhideLoadingIndicator("涓婁紶鏂囦欢鎴愬姛", this);
//JavaScript.RefreshSelf(this);
//JavaScript.RefreshOpener(this);
BindList();
}
catch (Exception)
{
- JavaScript.MessageBox("涓婁紶鏂囦欢澶辫触", this);
+ JavaScript.MessageBoxandhideLoadingIndicator("涓婁紶鏂囦欢澶辫触", this);
// JavaScript.RefreshSelf(this);
//JavaScript.RefreshOpener(this);
BindList();
@@ -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
{
--
Gitblit v1.9.1