Session版购物车+MVC局部刷新
2018-06-22 06:11:38来源：未知 阅读 ()
效果图：
大致代码：
1 <script type="text/javascript"> 2 $(function () { 3 LoadOrderDetailList(); 4 }); 5 function AddToOrderDetailInfo() { 6 $("#AddToOrderDetail").attr("disabled", true); 7 var form = $("#form_Create").serialize(); 8 $.post("/Sample/AddToOrderDetail", form, function (msg, status) { 9 if (msg.Result == "OK") { 10 $("#hShipDate").val($("#ShipDate").val()); 11 $("#ShipDate").attr("disabled", true); 12 $("#hReceiptDate").val($("#ReceiptDate").val()); 13 $("#ReceiptDate").attr("disabled", true); 14 $("#TrackingNumber").attr("readonly", true); 15 $("#Note").attr("readonly", true); 16 $("#ProductName").val(""); 17 $("#Qty").val(""); 18 $("#dNote").val(""); 19 AlertMsg("AddToOrderDetail", "success", msg.Message); 20 } else { 21 AlertMsg("AddToOrderDetail", "Failure", msg.Message); 22 } 23 $("#AddToOrderDetail").attr("disabled", false); 24 LoadOrderDetailList(); 25 }); 26 } 27 function LoadOrderDetailList() { 28 $("#tbOrderDetailsList tbody").load("/Sample/LoadOrderDetailList"); 29 } 30 function RemoveOrderDetail(id) { 31 $.post("/Sample/RemoveOrderDetail", { id: id }, function (data) { 32 if (data == "empty") { 33 $("#ShipDate").attr("disabled", false); 34 $("#ReceiptDate").attr("disabled", false); 35 $("#TrackingNumber").attr("readonly", false); 36 $("#Note").attr("readonly", false); 37 } 38 LoadOrderDetailList(); 39 }); 40 } 41 function SaveAll() { 42 $("#SaveAll").attr("disabled", true); 43 var form = $("#form_Create").serialize(); 44 $.post("/Sample/CreateSampleOrder", form, 45 function (msg) { 46 if (msg.Result == "OK") { 47 $("#ShipDate").attr("disabled", false); 48 $("#ReceiptDate").attr("disabled", false); 49 $("#TrackingNumber").attr("readonly", false); 50 $("#Note").attr("readonly", false); 51 $("#hShipDate").val(""); 52 $("#ShipDate").val(""); 53 $("#hReceiptDate").val(""); 54 $("#ReceiptDate").val(""); 55 $("#TrackingNumber").val(""); 56 $("#Note").val(""); 57 58 AlertMsg("SaveAll", "success", msg.Message); 59 } else{ 60 AlertMsg("SaveAll", "Failure", msg.Message); 61 } 62 $("#SaveAll").attr("disabled", false); 63 LoadOrderDetailList(); 64 }); 65 } 66 </script>
1 @using System.Data; 2 @model DataTable 3 @if (Model != null) 4 { 5 if (Model.Rows.Count > 0) 6 { 7 foreach (DataRow item in Model.Rows) 8 { 9 <tr> 10 <td> 11 <a style="cursor:pointer" onclick="GetSampleOrderDetail('@item["ID"]')">Select</a> 12 </td> 13 <td> 14 @item["OrderNumber"] 15 </td> 16 <td> 17 @item["ProductName"] 18 </td> 19 <td> 20 @item["Qty"] 21 </td> 22 <td> 23 @item["Note"] 24 </td> 25 <td> 26 <a style="cursor:pointer" onclick="DelSampleOrderDetail('@item["ID"]','@item["OrderNumber"]')">Delete</a> 27 </td> 28 </tr> 29 } 30 } 31 }
1 <form method="post" id="form_Create"> 2 <div class="panel-body"> 3 <div class="" id="order_Detail"> 4 <div class="row"> 5 <div class="row no-gutter mt5"> 6 <div class="col-lg-4"> 7 <span class="inline-any mt5">Issued By:</span></div> 8 <div class="col-lg-8"> 9 <input type="text" class="form-control w200 mr10" value="@Session["Account"]" name="Issued" id="Issued" 10 readonly="readonly"></div> 11 </div> 12 <div class="row no-gutter mt5"> 13 <div class="col-lg-4"> 14 <span class="inline-any mt5">Ship Date:</span></div> 15 <div class="col-lg-8"> 16 <input type="hidden" name="hShipDate" value="" id="hShipDate"> 17 <input type="text" class="form-control w200" onfocus="WdatePicker({lang:'en',dateFmt:'yyyy-MM-dd',maxDate:'#F{$dp.$D(\'ReceiptDate\')}'})" 18 value="" id="ShipDate" name="ShipDate" realvalue=""> 19 </div> 20 </div> 21 <div class="row no-gutter mt5"> 22 <div class="col-lg-4"> 23 <span class="inline-any mt5">Receipt Date:</span></div> 24 <div class="col-lg-8"> 25 <input type="hidden" name="hReceiptDate" value="" id="hReceiptDate"> 26 <input type="text" class="form-control w200" onfocus="WdatePicker({lang:'en',dateFmt:'yyyy-MM-dd',minDate:'#F{$dp.$D(\'ShipDate\')}'})" 27 value="" id="ReceiptDate" name="ReceiptDate" realvalue=""></div> 28 </div> 29 <div class="row no-gutter mt5"> 30 <div class="col-lg-4"> 31 <span class="inline-any mt5">Tracking Number:</span></div> 32 <div class="col-lg-8"> 33 <input type="text" class="form-control w200 mr10" value="" name="TrackingNumber" 34 id="TrackingNumber"> 35 </div> 36 </div> 37 <div class="row no-gutter mt5"> 38 <div class="col-lg-4"> 39 <span class="inline-any mt5">Sampl Order Note:</span></div> 40 <div class="col-lg-8"> 41 <textarea class="w100p h100" id="Note" name="Note"></textarea> 42 </div> 43 </div> 44 <hr /> 45 <div class="row no-gutter mt5"> 46 <div class="col-lg-4"> 47 <span class="inline-any mt5">Product Name:</span></div> 48 <div class="col-lg-8"> 49 <input type="text" class="form-control w200 mr10" value="" name="ProductName" id="ProductName"> 50 </div> 51 </div> 52 <div class="row no-gutter mt5"> 53 <div class="col-lg-4"> 54 <span class="inline-any mt5">Product Qty:</span></div> 55 <div class="col-lg-8"> 56 <input type="text" class="form-control w200 mr10" value="" name="Qty" id="Qty"> 57 </div> 58 </div> 59 <div class="row no-gutter mt5"> 60 <div class="col-lg-4"> 61 <span class="inline-any mt5">Sampl Order Detail Note:</span></div> 62 <div class="col-lg-8"> 63 <textarea class="w100p h100" id="dNote" name="dNote"></textarea> 64 </div> 65 </div> 66 <div class="row no-gutter mt10"> 67 </div> 68 <div class="row no-gutter mt20"> 69 <div class="col-lg-4"> 70 </div> 71 <div class="col-lg-8"> 72 <input type="button" value="Add to" id="AddToOrderDetail" class="btn btn-primary" 73 onclick="AddToOrderDetailInfo();" /> 74 </div> 75 </div> 76 </div> 77 </div> 78 </div> 79 </form> 80 81 <table class="table table-bordered table-striped table-condensed table-hover fixheader" 82 id="tbOrderDetailsList" style="width: auto"> 83 <thead> 84 <tr> 85 <th width="60"> 86 Operate 87 </th> 88 <th width="50"> 89 number 90 </th> 91 <th width="150"> 92 Product Name 93 </th> 94 <th width="70"> 95 Qty 96 </th> 97 <th width="300"> 98 Note 99 </th> 100 </tr> 101 </thead> 102 <tbody> 103 </tbody> 104 </table>
1 public ActionResult CreateSampleOrder(FormCollection form) 2 { 3 try 4 { 5 if (Session["OrderDetailList"] == null) 6 { 7 return Json(new { Result = "Error", Message = "No data!" }); 8 } 9 string createby = form["Issued"] != null ? form["Issued"].ToString() : string.Empty; 10 if (createby.Trim() == string.Empty) 11 { 12 return Json(new { Result = "Error", Message = "Please login again!" }); 13 } 14 string shipdate = form["ShipDate"] != null ? form["ShipDate"].ToString() : string.Empty; 15 string hshipdate = form["hShipDate"] != null ? form["hShipDate"].ToString() : string.Empty; 16 //if (shipdate.Trim() == string.Empty && hshipdate.Trim() == string.Empty) 17 //{ 18 // return Json(new { Result = "Error", Message = "Ship date cannot be empty" }); 19 //} 20 string receiptdate = form["ReceiptDate"] != null ? form["ReceiptDate"].ToString() : string.Empty; 21 string hreceiptdate = form["hReceiptDate"] != null ? form["hReceiptDate"].ToString() : string.Empty; 22 //if (receiptdate.Trim() == string.Empty && hreceiptdate.Trim() == string.Empty) 23 //{ 24 // return Json(new { Result = "Error", Message = "Receipt date cannot be empty" }); 25 //} 26 string trackingnumber = form["TrackingNumber"] != null ? form["TrackingNumber"].ToString() : string.Empty; 27 //if (trackingnumber.Trim() == string.Empty) 28 //{ 29 // return Json(new { Result = "Error", Message = "Tracking number cannot be empty" }); 30 //} 31 string note = form["Note"] != null ? form["Note"].ToString() : string.Empty; 32 string sql = ""; 33 sql += @"INSERT INTO Sample_Order(ShipDate, ReceiptDate, TrackingNumber, Note, CreateDate, CreateBy)VALUES(@ShipDate, @ReceiptDate, @TrackingNumber, @Note, GETDATE(), @CreateBy);"; 34 sql += @"UPDATE Sample_Order SET OrderNumber=@@IDENTITY WHERE ID=@@IDENTITY;"; 35 sql += @"SELECT @@IDENTITY;"; 36 SqlParameter[] pars = new SqlParameter[] 37 { 38 new SqlParameter("@ShipDate",IsEmptyToDBNull(hshipdate)), 39 new SqlParameter("@ReceiptDate",IsEmptyToDBNull(hreceiptdate)), 40 new SqlParameter("@TrackingNumber",trackingnumber), 41 new SqlParameter("@Note",note), 42 new SqlParameter("@CreateBy",createby) 43 }; 44 int ordernumber = SQLHelper.ExecuteScalar(sql, pars); 45 List<OrderDetail> list = new List<OrderDetail>(); 46 list = Session["OrderDetailList"] as List<OrderDetail>; 47 if (ordernumber > 0) 48 { 49 sql = ""; 50 foreach (OrderDetail item in list) 51 { 52 sql += @"INSERT INTO Sample_OrderDetail(OrderNumber, ProductName, Qty, Note)VALUES("; 53 sql += "N'" + ordernumber + "',"; 54 sql += "N'" + item.ProductName + "',"; 55 sql += "N'" + item.Qty + "',"; 56 sql += "N'" + item.Note + "'"; 57 sql += @") 58 "; 59 } 60 if (SQLHelper.ExecuteNonQuery(sql) > 0) 61 { 62 Session["OrderDetailList"] = null; 63 return Json(new { Result = "OK", Message = "Save all success!" }); 64 } 65 else 66 { 67 return Json(new { Result = "Error", Message = "Save all failed" }); 68 } 69 } 70 else 71 { 72 return Json(new { Result = "Error", Message = "Save all failed" }); 73 } 74 } 75 catch (Exception ex) 76 { 77 return Json(new { Result = "Error", Message = ex.Message }); 78 } 79 } 80 public ActionResult LoadOrderDetailList() 81 { 82 return PartialView("_SampleOrderDetailList"); 83 } 84 public ActionResult AddToOrderDetail(FormCollection form) 85 { 86 try 87 { 88 string createby = form["Issued"] != null ? form["Issued"].ToString() : string.Empty; 89 if (createby.Trim() == string.Empty) 90 { 91 return Json(new { Result = "Error", Message = "Please login again!" }); 92 } 93 string shipdate = form["ShipDate"] != null ? form["ShipDate"].ToString() : string.Empty; 94 string hshipdate = form["hShipDate"] != null ? form["hShipDate"].ToString() : string.Empty; 95 //if (shipdate.Trim() == string.Empty && hshipdate.Trim() == string.Empty) 96 //{ 97 // return Json(new { Result = "Error", Message = "Ship date cannot be empty" }); 98 //} 99 string receiptdate = form["ReceiptDate"] != null ? form["ReceiptDate"].ToString() : string.Empty; 100 string hreceiptdate = form["hReceiptDate"] != null ? form["hReceiptDate"].ToString() : string.Empty; 101 //if (receiptdate.Trim() == string.Empty && hreceiptdate.Trim() == string.Empty) 102 //{ 103 // return Json(new { Result = "Error", Message = "Receipt date cannot be empty" }); 104 //} 105 string trackingnumber = form["TrackingNumber"] != null ? form["TrackingNumber"].ToString() : string.Empty; 106 //if (trackingnumber.Trim() == string.Empty) 107 //{ 108 // return Json(new { Result = "Error", Message = "Tracking number cannot be empty" }); 109 //} 110 string note = form["Note"] != null ? form["Note"].ToString() : string.Empty; 111 string productname = form["ProductName"] != null ? form["ProductName"].ToString() : string.Empty; 112 if (productname.Trim() == string.Empty) 113 { 114 return Json(new { Result = "Error", Message = "Product name cannot be empty" }); 115 } 116 string qty = form["Qty"] != null ? form["Qty"].ToString() : string.Empty; 117 if (qty.Trim() == string.Empty) 118 { 119 return Json(new { Result = "Error", Message = "Qty cannot be empty" }); 120 } 121 string dnote = form["dNote"] != null ? form["dNote"].ToString() : string.Empty; 122 try 123 { 124 List<OrderDetail> list = new List<OrderDetail>(); 125 if (Session["OrderDetailList"] != null) 126 { 127 list = Session["OrderDetailList"] as List<OrderDetail>; 128 } 129 OrderDetail entity = new OrderDetail(); 130 entity.ProductName = productname; 131 entity.Qty = Convert.ToInt32(qty); 132 entity.Note = dnote; 133 list.Add(entity); 134 for (int i = 0; i < list.Count; i++) 135 { 136 list[i].ID = i + 1; 137 } 138 Session["OrderDetailList"] = list; 139 return Json(new { Result = "OK", Message = "OK" }); 140 } 141 catch (Exception ex) 142 { 143 return Json(new { Result = "Error", Message = ex.Message }); 144 } 145 } 146 catch (Exception ex) 147 { 148 return Json(new { Result = "Error", Message = ex.Message }); 149 } 150 } 151 public string RemoveOrderDetail(int id) 152 { 153 if (id != 0) 154 { 155 List<OrderDetail> list = new List<OrderDetail>(); 156 if (Session["OrderDetailList"] != null) 157 { 158 list = Session["OrderDetailList"] as List<OrderDetail>; 159 var item = list.Where(w => w.ID == id).FirstOrDefault(); 160 if (item != null) 161 { 162 list.Remove(item); 163 if (list.Count > 0) 164 { 165 for (int i = 0; i < list.Count; i++) 166 { 167 list[i].ID = i + 1; 168 } 169 Session["OrderDetailList"] = list; 170 } 171 else 172 { 173 Session["OrderDetailList"] = null; 174 } 175 } 176 } 177 } 178 else 179 { 180 Session["OrderDetailList"] = null; 181 } 182 return Session["OrderDetailList"] == null ? "empty" : "have"; 183 }
作者：长毛象
微博：http://weibo.com/5567742196/info
博客：http://www.cnblogs.com/xiangyisheng/
本文版权归作者和博客园共有，个人学习成果，请多多指教，欢迎转载，请保留原文链接
标签：
版权申明：本站文章部分自网络，如有侵权，请联系：west999com@outlook.com
特别注意：本站所有转载文章言论不代表本站观点，本站所提供的摄影照片，插画，设计作品，如需使用，请与原作者联系，版权归原作者所有
上一篇：使用NPOI上传excel
下一篇：H5网站接入Paypal支付接口
相关文章
- PHP session实现购物车功能 2020-03-23
- 用继承方法实现页面判断session的方法 2020-03-10
- 详解.net mvc session失效问题 2020-02-21
- 详解ABP框架中Session功能的使用方法 2020-01-18
- asp.net session丢失的解决方法小结 2019-09-08
IDC资讯： 主机资讯 注册资讯 托管资讯 vps资讯 网站建设
网站运营： 建站经验 策划盈利 搜索优化 网站推广 免费资源
网络编程： Asp.Net编程 Asp编程 Php编程 Xml编程 Access Mssql Mysql 其它
服务器技术： Web服务器 Ftp服务器 Mail服务器 Dns服务器 安全防护
软件技巧： 其它软件 Word Excel Powerpoint Ghost Vista QQ空间 QQ FlashGet 迅雷
网页制作： FrontPages Dreamweaver Javascript css photoshop fireworks Flash
热门词条
最新资讯
热门关注
热门标签