川印集团项目
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
username@email.com
2025-05-14 d15f9ddeef5168a71007b568d7349042931a92e3 
 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


            {