From 259584df9c06ade70f1f351affb35d4922e1263d Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期五, 07 十一月 2025 16:23:13 +0800
Subject: [PATCH] 这个打印送货单，你们给我做两种，做一张打印没得数量的，做一张打印有数量的。送货单格式就是32开，就哎就是A4排一半。你们打了测试，注意，美观。 把那个把它做出来，下一批就用这个自动打。 不是不是打印的要数量都是有数量，要没得数量都没得数量。就是点打印的时候就两个按钮嘛，一个是有数量打印，或者或者或者空白送货单打印。 现在这个现在的送货单都是没有数量噻。现在那个要的，比如你那里再打你那个打印关闭的按钮，要把搞成两个打印嘛，就是打印空白送货单和打印送货单。 好点打印空白送货单的，就是现在这样子。点打印送货单，打印的就是那个跟有有就是有数据的送货单。作业本送货统计查询，状态查询需要修改逻辑
---
CY_ECommercePlatform/CY.WebForm/Pages/business/CorporateClientsUpLoadContract.aspx.cs | 16 ++++++++--------
1 files changed, 8 insertions(+), 8 deletions(-)
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
{
--
Gitblit v1.9.1