修改合同上传

username@email.com

2025-01-17 db32c8221ae179f6b20cc62467200c0681d10f61

 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
            {