CY_ECommercePlatform/CY.Model/CY.Model.csproj
@@ -202,6 +202,7 @@ <Compile Include="OA\CoreCmsPlanOrder.cs" /> <Compile Include="OA\CoreCmsPlanOrderItem.cs" /> <Compile Include="OA\CoreDeliverOrderItem.cs" /> <Compile Include="OA\EC_OrderLiuyang.cs" /> <Compile Include="OA\OA_Baozhengjin.cs" /> <Compile Include="OA\OA_Baozhengjincuishou.cs" /> <Compile Include="OA\OA_CarDictionary.cs" /> CY_ECommercePlatform/CY.Model/EC/EC_OrderBasic.cs
@@ -339,6 +339,12 @@ _outid = value; } } /// <summary> /// 是否留样 1是 其他否 /// </summary> public int? LiuyangStatus { get; set; } #endregion Model } } CY_ECommercePlatform/CY.Model/EC/EC_OrderBasicExtend.cs
@@ -957,6 +957,12 @@ this.Duiyinghetongbianhao = isChange ? MyConvert.ConvertToString(value) : this.Duiyinghetongbianhao; theValue = this.Duiyinghetongbianhao; } else if ("LiuyangStatus".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 101) { this.LiuyangStatus = isChange ? MyConvert.ConvertToInt32(value) : this.LiuyangStatus; theValue = this.LiuyangStatus; } #endregion
New file @@ -0,0 +1,51 @@ using System; using System.Collections.Generic; using System.Linq; using System.Text; namespace CY.Model.OA { /// <summary> /// OA_CorporateClientsContract 模型 对标数据库中的OA_CorporateClientsContract表 /// 用户合同附件子表，数据库中为做任何关联 /// </summary> public class EC_OrderLiuyang { /// <summary> /// 主键 /// </summary> public Guid Keyid { get; set; } /// <summary> /// 用户ID /// </summary> public int orderid { get; set; } /// <summary> /// 文件名 /// </summary> public string FileName { get; set; } /// <summary> /// 文件保存路径 /// </summary> public string FilePath { get; set; } /// <summary> /// 备注 /// </summary> public string Remark { get; set; } /// <summary> /// 创建者 /// </summary> public Guid? Creater { get; set; } /// <summary> /// 创建时间 /// </summary> public DateTime? CreateTime { get; set; } /// <summary> /// 修改者 /// </summary> public Guid? Updater { get; set; } /// <summary> /// 修改时间 /// </summary> public DateTime? LastUpdateTime { get; set; } } } CY_ECommercePlatform/CY.WebForm/CY.WebForm.csproj
@@ -1886,6 +1886,7 @@ <Content Include="Pages\business\Caigoufukuanshenqing.aspx" /> <Content Include="Pages\business\Baozhengjinfukuan.aspx" /> <Content Include="Pages\business\BaozhengjinCuishou.aspx" /> <Content Include="Pages\business\OrderUpLoadLiuyang.aspx" /> <Content Include="Pages\business\WaixieOrderPrint.aspx" /> <Content Include="Pages\business\Waixiefukuanweikaipiao.aspx" /> <Content Include="Pages\business\Waixiefukuanfukuan.aspx" /> @@ -2946,6 +2947,7 @@ <DependentUpon>Global.asax</DependentUpon> </Compile> <Compile Include="Helper\TimeTaskHelper.cs" /> <Compile Include="Helper\upLoadLiuyangFile.cs" /> <Compile Include="Helper\upLoadContractFile.cs" /> <Compile Include="Index.aspx.cs"> <DependentUpon>Index.aspx</DependentUpon> @@ -3338,6 +3340,13 @@ <Compile Include="Pages\business\BaozhengjinCuishou.aspx.designer.cs"> <DependentUpon>BaozhengjinCuishou.aspx</DependentUpon> </Compile> <Compile Include="Pages\business\OrderUpLoadLiuyang.aspx.cs"> <DependentUpon>OrderUpLoadLiuyang.aspx</DependentUpon> <SubType>ASPXCodeBehind</SubType> </Compile> <Compile Include="Pages\business\OrderUpLoadLiuyang.aspx.designer.cs"> <DependentUpon>OrderUpLoadLiuyang.aspx</DependentUpon> </Compile> <Compile Include="Pages\business\WaixieOrderPrint.aspx.cs"> <DependentUpon>WaixieOrderPrint.aspx</DependentUpon> <SubType>ASPXCodeBehind</SubType> CY_ECommercePlatform/CY.WebForm/Helper/upLoadLiuyangFile.cs
New file @@ -0,0 +1,232 @@ using CY.Infrastructure.Logging; using CY.Model.OA; using CY.SQLDAL; using System; using System.Collections.Generic; using System.Data.SqlClient; using System.IO; using System.Linq; using System.Web; namespace CY.WebForm.Helper { public class upLoadLiuyangFile { /// <summary> /// 上传一个文件页面，并保存，包括修修 /// </summary> /// <param name="filel">postFileUI对象</param> /// <param name="Contract">客户文件表关联 </param> /// <param name="CountractFileKeiId">合同文件ID</param> /// <remarks>先判决是否存在CountractFileKeiId 如果不存在，则根据CorporateClientKeyid 新建 这两个ID不能同时为null </remarks> public void SavAndUpDataContractFile(HttpPostedFile filel, EC_OrderLiuyang Contract = null, Guid? CountractFileKeiId = null) { if (Contract == null && CountractFileKeiId == null) { throw new Exception("订单ID和留样ID同时为空，不能修改或者更新留样"); } Database DC = new Database(); string FilePath = ""; try { String sqlStr = ""; if (CountractFileKeiId != null) { //修改文件 sqlStr = string.Format(@"SELECT [Keyid],[orderid],[FileName],[FilePath],[Remark],[Creater],[CreateTime],[Updater],[LastUpdateTime] FROM [ECTEST].[dbo].[EC_OrderLiuyang] where Keyid='{0}'", CountractFileKeiId.ToString()); //开始修改文件 SqlCommand myCmd = new SqlCommand(sqlStr, DC.Connection); var a = myCmd.ExecuteReader(); EC_OrderLiuyang Contract1 = new EC_OrderLiuyang(); while (a.Read()) { //注意如何将每次读取到的记录添加到listbox1中（因为第一次做时出错了，嘿嘿） Contract1.Keyid = a.GetGuid(0); Contract1.orderid = a.GetInt32(1); Contract1.FileName = a.GetString(2); Contract1.FilePath = a.GetString(3); Contract1.Remark = a.GetString(4); } a.Close(); //关闭sqldatareader UploadFileTIhuan(filel, Contract1.FilePath); //直接替换文件 } else { //不是修改，则增加 //修改文件 if(Contract.orderid==0) { throw new Exception("订单ID为空，不能留样"); } //开始上传合同 try { FilePath= UploadFile(filel, "LiuyangIMG", Contract.FileName); //上传文件 } catch (Exception e) { throw e; } //写入数据库 sqlStr = string.Format(@" INSERT INTO [dbo].[EC_OrderLiuyang] ( [Keyid],[orderid],[FileName],[FilePath],[Remark],[Creater],[CreateTime] ) VALUES('{0}' ,'{1}' ,'{2}' ,'{3}' ,'{4}' ,'{5}' ,'{6}' )", Guid.NewGuid().ToString(), Contract.orderid , Contract.FileName, FilePath, Contract.Remark, Contract.Creater,DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); try { SqlCommand myCmd = new SqlCommand(sqlStr, DC.Connection); var a = myCmd.ExecuteNonQuery(); if (a == 1) { sqlStr = string.Format(@" update [EC_OrderBasic] set [LiuyangStatus] = 1 where [Keyid]= {0} ", Contract.orderid); myCmd = new SqlCommand(sqlStr, DC.Connection); a = myCmd.ExecuteNonQuery(); return; } else { //删除文件？ } } catch (Exception e) { //删除文件？ throw e; } //开始修改文件 } } catch (Exception ee) { new Log4NetAdapter().Log("文件上传 错误：" + ee.Message); } finally { if (DC.Connection.State != System.Data.ConnectionState.Closed) DC.Connection.Close(); } } /// <summary> /// 直接替换文件 /// </summary> /// <param name="filel"> postFileUI对象</param> /// <param name="Filepath"> /UpFile+文件路径</param> /// <param name="fileName"> 文件名</param> /// <returns></returns> public string UploadFileTIhuan(HttpPostedFile filel, string fileName) { try { string DirPath = System.Web.HttpContext.Current.Request.MapPath(fileName); filel.SaveAs(DirPath ); return fileName; //返回相对路径 } catch (Exception e) { throw e; } } /// <summary> /// 上传文件 /// </summary> /// <param name="filel"> postFileUI对象</param> /// <param name="Filepath"> /UpFile+文件路径</param> /// <param name="fileName"> 文件名</param> /// <returns></returns> public string UploadFile(HttpPostedFile filel, string Filepath,string fileName) { try { string DirPath = System.Web.HttpContext.Current.Request.MapPath("/UpFile"); if (Directory.Exists(DirPath)) { //文件夹已经存在 } else { try { Directory.CreateDirectory(DirPath); //创建成功 } catch (Exception ex) { throw ex; } } //创建第二级 if (Directory.Exists(DirPath+"/"+ Filepath)) { //文件夹已经存在 } else { try { Directory.CreateDirectory(DirPath + "/" + Filepath); //创建成功 } catch (Exception ex) { throw ex; } } string File = Filepath + "/" + DateTime.Now.ToString("yyyy_MM_dd_hh_mm_ss") + fileName; filel.SaveAs(DirPath+ "/"+File); return "/UpFile/"+File; //返回相对路径 } catch (Exception e) { throw e; } } } } CY_ECommercePlatform/CY.WebForm/Pages/business/OrderList.aspx
@@ -27,6 +27,13 @@ top.Dialog.open({ URL: url, Title: "订单回访", Height: 400 }); } function Liuyang(orderId) { var url = "/Pages/business/OrderUpLoadLiuyang.aspx?Keyid=" + orderId; top.Dialog.open({ URL: url, Title: "留样", Height: 600, Width: 800 }); } function CompledWork(orderId) { var url = "/Pages/business/CompledWork.aspx?ids=" + orderId; top.Dialog.open({ URL: url, Title: "完工", Height: 300, Width: 680 }); @@ -440,6 +447,9 @@ <th width="26" menu_member_case_id="case_DeferPay" menu_member_case_name="延期"> 延期 </th> <th width="26" menu_member_case_id="case_Liuyang" menu_member_case_name="留样"> 留样 </th> <th width="26" menu_member_case_id="case_OpenVisit" menu_member_case_name="回访"> 回访 </th> @@ -573,6 +583,10 @@ <span style='display: ' class='hand_no' <%#true.Equals(Eval("IsDeferPay"))?"title='已延期'":"title=''"%>> <%#true.Equals(Eval("IsDeferPay")) ? "√" : ""%></span> </td> <td menu_member_case_id="case_Liuyang" menu_member_case_name="留样"> <span class="hand_yes" <%#1.Equals(Eval("LiuyangStatus"))?"title='已留样'":"title=''"%> onclick="Liuyang(<%#Eval("Keyid")%>);" > <%#1.Equals(Eval("LiuyangStatus")) ? "√" : "留样"%></span> </td> <td class="td_hide" menu_member_case_id="case_OpenVisit" menu_member_case_name="回访"> <%-- <span class="hand_yes" title="回访" onclick="dialog.open({URL: '/Pages/business/BackVisitNoteEdit.aspx?id=<%#Eval("Keyid") %>&orderId=<%#Eval("SellerOrderId") %>&buyerName=<%#Eval("BuyerName") %>' , Title: '订单回访',Height:400});">回访</span>--%> <span class="<%#IsCanOpearte(Eval("Keyid"),Eval("OrderState"),Eval("OutId"),"回访")?"hand_yes":"hand_no"%>" <%#true.Equals(Eval("IsVisit"))?"title='已回访'":"title='回访'"%> style='display: ' onclick='OpenVisit(<%#Eval("Keyid")%>,"<%#Eval("SellerOrderId")%>","<%#Eval("BuyerName")%>")'> CY_ECommercePlatform/CY.WebForm/Pages/business/OrderUpLoadLiuyang.aspx
New file @@ -0,0 +1,321 @@ <%@ Page Language="C#" AutoEventWireup="true" CodeBehind="OrderUpLoadLiuyang.aspx.cs" Inherits="CY.WebForm.Pages.business.OrderUpLoadLiuyang" %> <%-- 上传合同页面 廖 20210916增加--%> <!DOCTYPE html> <script src="./../../myPagination/js/share/js/jquery.min.js" type="text/javascript"></script> <%--<script src="./../../js/jquery.hammer.min.js" type="text/javascript"></script>--%> <html xmlns="http://www.w3.org/1999/xhtml"> <head id="Head1" runat="server"> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title></title> <uc:CMSHead ID="CMSHead1" runat="server" /> <style> .toast-message { position: absolute; width: 90px; /* 固定宽度 */ height: 60px; /* 固定高度 */ top: 50%; left: 50%; transform: translate(-50%, -50%); /* 调整位置使其居中 */ background-color: lightblue; font-size: 20px; /* 设置文字大小 */ text-align: center; /* 设置文字居中 */ } </style> </head> <body> <form id="form1" runat="server"> <%-- <div class="box1" paneltitle="功能面板" roller="false"> <table class="TableNewStyle"> <tr> <td style="width:200px">新增或者替换合同页面： </td> <td style="width:100px">第 <input type="text" runat="server" id="TextPage" style="width:40px" onkeyup="value=value.replace(/[^\d]/g,'')" /> 页 </td> <td class="ali03"></td> <td class="ali03"> <input type="file" id="filesel" name="__hetongFile" keepdefaultstyle="true" runat="server" text="请选择文件" /></td> <td> <asp:Button ID="UpdateFileNew" Text="上传" runat="server" OnClick="btn_Submit_Click" OnClientClick="return checkSelFile()" /> <div id="loading" class="toast-message" style="display: none;">上传中！</div> </td> </tr> </table> </div>--%> <div class="box1" paneltitle="功能面板" roller="false"> <table class="TableNewStyle"> <tr> <td class="ali06" style="width:200px"> 批量上传： </td> <td class="ali03" style="width:100px"> </td> <td class="ali03"></td> <td class="ali03"> <input type="file" id="file2" name="__hetongMutilfiles" keepdefaultstyle="true" multiple="multiple" runat="server" text="请选择文件"/></td> <td> <asp:Button ID="Button1" Text="批量上传" runat="server" OnClick="btn_Submit_Click_multi" OnClientClick="return checkSelMulitFile()" /></td> </tr> </table> </div> <div> <p style="text-align: center">已有页面</p> <asp:Repeater ID="RepClientList" runat="server"> <HeaderTemplate> <table class="tableStyle"> <tr> <%-- <th width="25"></th>--%> <th width="200" style="text-align: center">名称 </th> <th style="text-align: center">预览 </th> <th style="text-align: center">操作 </th> </tr> </HeaderTemplate> <ItemTemplate> <tr> <%-- <td> <input type="checkbox" class="SelectCheck" value_kid="<%#Eval("Keyid")%>" /> </td>--%> <td> <%#Eval("FileName")%> </td> <td> <a title="点击查看原图" href="<%#Eval("FilePath").ToString() %>" target="view_window"> <img src="<%#Eval("FilePath").ToString() %>" width="80" height="100" /> </a> </td> <td> <a onclick="delelid('<%#Eval("Keyid")%>','<%= Request["Keyid"]%>')">删除当前页面</a> </td> </tr> </ItemTemplate> <FooterTemplate> </table> </FooterTemplate> </asp:Repeater> <div id="page"> <uc:UCPager ID="UCPager1" runat="server" /> </div> </div> <%-- <button id="Buttonupload" onclick="onViewuplodshow('<%= Request["Keyid"]%>')">浏览全部</button>--%> <%-- <asp:Button ID="Button3" Text="删除所有留样" runat="server" OnClick="btn_Submit_Click_DELLALL" />--%> </form> </body> </html> <script type="text/javascript"> //查看 function checkSelMulitFile() { var oFile = document.getElementById('file2'); if (oFile.value == "") { alertMsg('没有选择文件'); return false; } //debugger; //replaceParamVal("deleteKeyIds", ""); showLoadingIndicator(); return true; } //查看 function checkSelFile() { if (document.getElementById("TextPage").value == "") { alertMsg("没有输入页数"); return false; } var oFile = document.getElementById('filesel'); if (oFile.value == "") { alertMsg('没有选择文件'); return false; } showLoadingIndicator(); //debugger; //replaceParamVal("deleteKeyIds", ""); return true; } function showLoadingIndicator() { document.getElementById('loading').style.display = 'block'; } function hideLoadingIndicator() { document.getElementById('loading').style.display = 'none'; } //改变参数 function changeURLArg(url, arg, arg_val) { var pattern = arg + '=([^&]*)'; var replaceText = arg + '=' + arg_val; if (url.match(pattern)) { var tmp = '/(' + arg + '=)([^&]*)/gi'; tmp = url.replace(eval(tmp), replaceText); return tmp; } else { if (url.match('[\?]')) { return url + '&' + replaceText; } else { return url + '?' + replaceText; } } } // 获取url里的参数 function getURLString(arg) { var reg = new RegExp("(^|&)" + arg + "=([^&]*)(&|$)", "i"); var r = window.location.search.substr(1).match(reg); if (r != null) return unescape(r[2]); return null; } //替换指定传入参数的值,paramName为参数,replaceWith为新值 function replaceParamVal(paramName, replaceWith) { var oUrl = this.location.href.toString(); var re = eval('/(' + paramName + '=)([^&]*)/gi'); var nUrl = oUrl.replace(re, paramName + '=' + replaceWith); this.location = nUrl; window.location.href = nUrl } //删除制定合同页面 function delelid(KeyID, pageID) { top.Dialog.confirm("是否要删除该留样页面？", function () { window.location = "/Pages/business/OrderUpLoadLiuyang.aspx?deleteKeyIds=" + KeyID + "&Keyid=" + pageID; } ); } //维护 function onViewuplodshow(keyid) { top.Dialog.open({ URL: "/Pages/business/CorporateClientsContractShow.aspx?Keyid=" + keyid, Title: "浏览合同", Width: 1024, Height: 750 }); } $(document).ready(function () { //$("#file2").change(function () { // var myfile = document.getElementById('file2'); // for (let i = 0; i < myfile.files.length; i++) //{ // var filepath = myfile.files[i].name; // var extStart = filepath.lastIndexOf("."); // var ext = filepath.substring(extStart, filepath.length).toUpperCase(); // if (ext != ".BMP" && ext != ".PNG" && ext != ".GIF" && ext != ".JPG" && ext != ".JPEG") { // alertMsg("图片限于bmp,png,gif,jpeg,jpg格式"); // return false; // } else { $("#fileType").text(ext) } // var ext = filepath.substring(0, extStart); // if (isNumber(ext)) { // } // else { // alertMsg(filepath + '文件名有误'); // return false; // } //} // //var file_size = 0; // //if ($.browser.msie) { // // var img = new Image(); // // img.src = filepath; // // while (true) { // // if (img.fileSize > 0) { // // if (img.fileSize > 3 * 1024 * 1024) { // // alert("图片不大于100MB。"); // // } else { // // var num03 = img.fileSize / 1024; // // num04 = num03.toFixed(2) // // $("#fileSize").text(num04 + "KB"); // // } // // break; // // } // // } // //} else { // // file_size = this.files[0].size; // // var size = file_size / 1024; // // if (size > 10240) { // // alert("上传的图片大小不能超过10M！"); // // } else { // // var num01 = file_size / 1024; // // num02 = num01.toFixed(2); // // $("#fileSize").text(num02 + " KB"); // // } // //} // return true; //}); }); function isNumber(val) { var regPos = /^\d+(\.\d+)?$/; //非负浮点数 var regNeg = /^(-(([0-9]+\.[0-9]*[1-9][0-9]*)|([0-9]*[1-9][0-9]*\.[0-9]+)|([0-9]*[1-9][0-9]*)))$/; //负浮点数 if (regPos.test(val) || regNeg.test(val)) { return true; } else { return false; } } </script> CY_ECommercePlatform/CY.WebForm/Pages/business/OrderUpLoadLiuyang.aspx.cs
New file @@ -0,0 +1,452 @@ using CY.Infrastructure.Common; using CY.Infrastructure.Logging; using CY.SQLDAL; using System; using System.Collections.Generic; using System.Data.SqlClient; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using static CY.WebForm.MainPage; using CY.Model.OA; using CY.WebForm.Helper; using CY.Infrastructure.Query; using System.IO; namespace CY.WebForm.Pages.business { public partial class OrderUpLoadLiuyang : BasePage { /// <summary> /// 选择文件 /// </summary> List<HttpFileCollection> SelFile { set; get; } /// <summary> /// 留样附件集合 /// </summary> List<EC_OrderLiuyang> fileDataList { set; get; } = new List<EC_OrderLiuyang>(); /// <summary> /// 附件个数 /// </summary> public int FileCount { get; set; } protected void Page_Load(object sender, EventArgs e) { UCPager1.AspNetPager.PageSize=5; UCPager1.AspNetPager.PageChanged += AspNetPager1_PageChanged; if (Request["deleteKeyIds"] != null&& Request["deleteKeyIds"]!="") { if (Request["deleteKeyIds"] == "all") { //删除说有页面 string keyid = Request["deleteKeyIds"].ToString(); string pageID = Request["Keyid"]; Database DC = new Database(); string sqlStr = string.Format(@" select [Keyid],[orderid],[FileName],[FilePath],[Remark],[Creater],[CreateTime],[Updater],[LastUpdateTime] FROM [ECTEST].[dbo].[EC_OrderLiuyang] where [orderid]={0} ORDER BY [CreateTime] ", pageID); try { SqlCommand myCmd = new SqlCommand(sqlStr, DC.Connection); //SqlDataAdapter myDa = new SqlDataAdapter(myCmd); var a = myCmd.ExecuteReader(); //myDa.Dispose(); fileDataList = new List<EC_OrderLiuyang>(); EC_OrderLiuyang Contract; while (a.Read()) { //注意如何将每次读取到的记录添加到listbox1中（因为第一次做时出错了，嘿嘿） Contract = new EC_OrderLiuyang(); Contract.Keyid = a.GetGuid(0); Contract.orderid = a.GetInt32(1); Contract.FileName = a.GetString(2); Contract.FilePath = a.GetString(3); Contract.Remark = a.GetString(4); fileDataList.Add(Contract); } a.Close(); //关闭sqldatareader if (fileDataList.Count > 0) { foreach (var item in fileDataList) { FileInfo file = new FileInfo(Server.MapPath(item.FilePath));//指定文件路径 if (file.Exists)//判断文件是否存在 { file.Attributes = FileAttributes.Normal;//将文件属性设置为普通,比方说只读文件设置为普通 file.Delete();//删除文件 } sqlStr = string.Format(@" DELETE FROM [dbo].[EC_OrderLiuyang] where Keyid='{0}'", item.Keyid); myCmd = new SqlCommand(sqlStr, DC.Connection); myCmd.ExecuteNonQuery(); myCmd.Dispose(); } } JavaScript.MessageBox("删除成功", this); // Response.Redirect("/Pages/business/OrderUpLoadLiuyang.aspx"); } catch (Exception ee) { new Log4NetAdapter().Log("查找留样出错：" + ee.Message); JavaScript.MessageBox("删除失败", this); } finally { if (DC.Connection.State != System.Data.ConnectionState.Closed) DC.Connection.Close(); } } else { //删除页面 string keyid = Request["deleteKeyIds"].ToString(); string orderid = Request["Keyid"].ToString(); Database DC = new Database(); string sqlStr = string.Format(@" select [Keyid],[orderid],[FileName],[FilePath],[Remark],[Creater],[CreateTime],[Updater],[LastUpdateTime] FROM [ECTEST].[dbo].[EC_OrderLiuyang] where Keyid='{0}'ORDER BY [CreateTime] ", keyid); try { SqlCommand myCmd = new SqlCommand(sqlStr, DC.Connection); //SqlDataAdapter myDa = new SqlDataAdapter(myCmd); var a = myCmd.ExecuteReader(); //myDa.Dispose(); fileDataList = new List<EC_OrderLiuyang>(); EC_OrderLiuyang Contract; while (a.Read()) { //注意如何将每次读取到的记录添加到listbox1中（因为第一次做时出错了，嘿嘿） Contract = new EC_OrderLiuyang(); Contract.Keyid = a.GetGuid(0); Contract.orderid = a.GetInt32(1); Contract.FileName = a.GetString(2); Contract.FilePath = a.GetString(3); Contract.Remark = a.GetString(4); fileDataList.Add(Contract); } a.Close(); //关闭sqldatareader if (fileDataList.Count > 0) { FileInfo file = new FileInfo(Server.MapPath(fileDataList[0].FilePath));//指定文件路径 if (file.Exists)//判断文件是否存在 { file.Attributes = FileAttributes.Normal;//将文件属性设置为普通,比方说只读文件设置为普通 file.Delete();//删除文件 } } sqlStr = string.Format(@" DELETE FROM [dbo].[EC_OrderLiuyang] where Keyid='{0}'", keyid); myCmd = new SqlCommand(sqlStr, DC.Connection); myCmd.ExecuteNonQuery(); //if (fileDataList.Count<=1) //{ // sqlStr = string.Format(@" update [EC_OrderBasic] set [LiuyangStatus] = 0 where [Keyid]= {0} ", orderid); // myCmd = new SqlCommand(sqlStr, DC.Connection); // myCmd.ExecuteNonQuery(); //} JavaScript.MessageBox("删除成功", this); // Response.Redirect("/Pages/business/OrderUpLoadLiuyang.aspx"); } catch (Exception ee) { new Log4NetAdapter().Log("查找留样出错：" + ee.Message); JavaScript.MessageBox("删除失败", this); } finally { if (DC.Connection.State != System.Data.ConnectionState.Closed) DC.Connection.Close(); } } Response.AppendHeader("deleteKeyIds", ""); } if (!IsPostBack) BindList(); } public Guid GetKeyid() { return Request["Keyid"].ToGuid2(); } //绑定列表 private void BindList() { Pagination pa = new Pagination(); pa.PageSize = UCPager1.AspNetPager.PageSize; pa.PageIndex = UCPager1.AspNetPager.CurrentPageIndex; int Keyid = Request["Keyid"].ToInt32().Value ; if(Keyid==0) { JavaScript.MessageBox("未找到该客户", this, false, false); return; } Database DC = new Database(); string sqlStr =string.Format(@" select * from (select ROW_NUMBER() OVER(Order by CreateTime ) AS RowNumber,* from [dbo].[EC_OrderLiuyang] where orderid='{0}' ) as b where b.RowNumber BETWEEN ({1}-1)*({2})+1 and {1}*{2} order by CreateTime ", Keyid,pa.PageIndex,pa.PageSize); int count = 0; try { SqlCommand myCmd = new SqlCommand(sqlStr, DC.Connection); //SqlDataAdapter myDa = new SqlDataAdapter(myCmd); var a = myCmd.ExecuteReader(); //myDa.Dispose(); fileDataList = new List <EC_OrderLiuyang>(); EC_OrderLiuyang Contract ; while (a.Read()) { //注意如何将每次读取到的记录添加到listbox1中（因为第一次做时出错了，嘿嘿） Contract = new EC_OrderLiuyang(); Contract.Keyid = a.GetGuid(1); Contract.orderid = a.GetInt32(2); Contract.FileName = a.GetString(3); Contract.FilePath = a.GetString(4); Contract.Remark = a.GetString(5); fileDataList.Add(Contract); } a.Close(); //关闭sqldatareader sqlStr = string.Format("select count(*) from [dbo].[EC_OrderLiuyang] where orderid='{0}'", Keyid); myCmd = new SqlCommand(sqlStr, DC.Connection); count = (int)myCmd.ExecuteScalar(); } catch (Exception ee) { new Log4NetAdapter().Log("查找留样出错：" + ee.Message); } finally { if (DC.Connection.State != System.Data.ConnectionState.Closed) DC.Connection.Close(); } FileCount = fileDataList.Count; this.RepClientList.DataSource = fileDataList;// fileDataList.AsEnumerable<EC_OrderLiuyang>(); this.RepClientList.DataBind(); UCPager1.AspNetPager.RecordCount = count; } //分页事件 protected void AspNetPager1_PageChanged(object src, EventArgs e) { BindList(); } protected void btn_Submit_Click_multi(object sender, EventArgs e) { var files = Request.Files; //if (files.Count <= 0) // return; HttpPostedFile postedFile; List<HttpPostedFile> fileList = new List<HttpPostedFile>(); for (int i=0;i< files.Count;i++) { if (files.Keys[i]=="file2") { postedFile = files[i]; if (postedFile.ContentLength == 0) continue; fileList.Add(postedFile); } } upLoadLiuyangFile uploadContract = new upLoadLiuyangFile(); EC_OrderLiuyang contract = null; //Guid? g = null; foreach (var item in fileList) { //int page = 0; //try //{ // page = pagecount(item); //} //catch (Exception) //{ // continue; //} //try //{ // g = GetContractFileID(page); //} //catch (Exception) //{ // continue; //} //uploadContract = new upLoadLiuyangFile(); //if (g != null) //{ // try // { // uploadContract.SavAndUpDataContractFile(item, CountractFileKeiId: g); // JavaScript.MessageBoxandhideLoadingIndicator( "上传文件成功", this); // //JavaScript.RefreshSelf(this); // //JavaScript.RefreshOpener(this); // } // catch (Exception) // { // JavaScript.MessageBoxandhideLoadingIndicator("上传文件失败", this); // // JavaScript.RefreshSelf(this); // //JavaScript.RefreshOpener(this); // } // continue; //} //新建走下面页面 contract = new EC_OrderLiuyang { orderid = Request["Keyid"].ToInt32().Value, FileName = System.IO.Path.GetFileName(item.FileName), Creater = CurrentUser.TrueMemberId, }; try { uploadContract.SavAndUpDataContractFile(item, contract); JavaScript.MessageBox("上传文件成功", this); } catch (Exception) { JavaScript.MessageBox( "上传文件失败", this); } } BindList(); } protected void btn_Submit_Click_DELLALL(object sender, EventArgs e) { string pageID = Request["Keyid"]; Database DC = new Database(); string sqlStr = string.Format(@" SELECT [Keyid],[orderid],[FileName],[FilePath],[Remark],[Creater],[CreateTime],[Updater],[LastUpdateTime] FROM [ECTEST].[dbo].[EC_OrderLiuyang] where orderid={0} ORDER BY CreateTime ", pageID); try { SqlCommand myCmd = new SqlCommand(sqlStr, DC.Connection); //SqlDataAdapter myDa = new SqlDataAdapter(myCmd); var a = myCmd.ExecuteReader(); //myDa.Dispose(); fileDataList = new List<EC_OrderLiuyang>(); EC_OrderLiuyang Contract; while (a.Read()) { //注意如何将每次读取到的记录添加到listbox1中（因为第一次做时出错了，嘿嘿） Contract = new EC_OrderLiuyang(); Contract.Keyid = a.GetGuid(0); Contract.orderid = a.GetInt32(1); Contract.FileName = a.GetString(2); Contract.FilePath = a.GetString(3); Contract.Remark = a.GetString(4); fileDataList.Add(Contract); } a.Close(); //关闭sqldatareader if (fileDataList.Count > 0) { foreach (var item in fileDataList) { FileInfo file = new FileInfo(Server.MapPath(item.FilePath));//指定文件路径 if (file.Exists)//判断文件是否存在 { file.Attributes = FileAttributes.Normal;//将文件属性设置为普通,比方说只读文件设置为普通 file.Delete();//删除文件 } sqlStr = string.Format(@" DELETE FROM [dbo].[EC_OrderLiuyang] where Keyid='{0}'", item.Keyid); myCmd = new SqlCommand(sqlStr, DC.Connection); myCmd.ExecuteNonQuery(); } sqlStr = string.Format(@" update [EC_OrderBasic] set [LiuyangStatus] = 0 where [Keyid]= {0} ", pageID); myCmd = new SqlCommand(sqlStr, DC.Connection); myCmd.ExecuteNonQuery(); myCmd.Dispose(); } JavaScript.MessageBox("删除成功", this); // Response.Redirect("/Pages/business/OrderUpLoadLiuyang.aspx"); } catch (Exception ee) { new Log4NetAdapter().Log("查找留样出错：" + ee.Message); JavaScript.MessageBox("删除失败", this); } finally { if (DC.Connection.State != System.Data.ConnectionState.Closed) DC.Connection.Close(); } BindList(); } public void test() { return; } } } CY_ECommercePlatform/CY.WebForm/Pages/business/OrderUpLoadLiuyang.aspx.designer.cs
New file @@ -0,0 +1,80 @@ //------------------------------------------------------------------------------ // <自动生成> // 此代码由工具生成。 // // 对此文件的更改可能导致不正确的行为，如果 // 重新生成代码，则所做更改将丢失。 // </自动生成> //------------------------------------------------------------------------------ namespace CY.WebForm.Pages.business { public partial class OrderUpLoadLiuyang { /// <summary> /// Head1 控件。 /// </summary> /// <remarks> /// 自动生成的字段。 /// 若要进行修改，请将字段声明从设计器文件移到代码隐藏文件。 /// </remarks> protected global::System.Web.UI.HtmlControls.HtmlHead Head1; /// <summary> /// CMSHead1 控件。 /// </summary> /// <remarks> /// 自动生成的字段。 /// 若要进行修改，请将字段声明从设计器文件移到代码隐藏文件。 /// </remarks> protected global::CY.WebForm.Pages.common.CMSHead CMSHead1; /// <summary> /// form1 控件。 /// </summary> /// <remarks> /// 自动生成的字段。 /// 若要进行修改，请将字段声明从设计器文件移到代码隐藏文件。 /// </remarks> protected global::System.Web.UI.HtmlControls.HtmlForm form1; /// <summary> /// file2 控件。 /// </summary> /// <remarks> /// 自动生成的字段。 /// 若要进行修改，请将字段声明从设计器文件移到代码隐藏文件。 /// </remarks> protected global::System.Web.UI.HtmlControls.HtmlInputFile file2; /// <summary> /// Button1 控件。 /// </summary> /// <remarks> /// 自动生成的字段。 /// 若要进行修改，请将字段声明从设计器文件移到代码隐藏文件。 /// </remarks> protected global::System.Web.UI.WebControls.Button Button1; /// <summary> /// RepClientList 控件。 /// </summary> /// <remarks> /// 自动生成的字段。 /// 若要进行修改，请将字段声明从设计器文件移到代码隐藏文件。 /// </remarks> protected global::System.Web.UI.WebControls.Repeater RepClientList; /// <summary> /// UCPager1 控件。 /// </summary> /// <remarks> /// 自动生成的字段。 /// 若要进行修改，请将字段声明从设计器文件移到代码隐藏文件。 /// </remarks> protected global::CY.WebForm.Pages.common.UCPager UCPager1; } } CY_ECommercePlatform/CY.WebForm/Pages/front/InquiryOnLine.aspx.cs
@@ -1900,12 +1900,13 @@ printDemand += "，每本" + model.PageNum + "份，"; } printDemand += model.RLNum + "，"; printDemand += model.PrintColor + "，"; printDemand += "封面要求："; printDemand += model.FrontType; printDemand += model.PrintColor + ""; if (model.FrontType != "无封面") { printDemand += "，封面要求："; printDemand += model.FrontType; printDemand += "，" + model.pDemand; }
