修改合同上传

username@email.com

2025-01-17 db32c8221ae179f6b20cc62467200c0681d10f61

修改合同上传

 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
                    {

 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);

 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
            {

 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>

 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
            {

 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
                        {

 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;" />

 CY_ECommercePlatform/CY.WebForm/Pages/business/OrderList.aspx

@@ -384,7 +384,7 @@
                            印件名称
                        </th>
                         <th style="width:100px;">
                            对应合同编号
                             合同序号
                        </th>
                        <th width="36">
                            数量