Session版购物车+MVC局部刷新

最新推荐文章于 2021-08-05 13:29:10 发布
最新推荐文章于 2021-08-05 13:29:10 发布
阅读量119 收藏 1
点赞数
文章标签： java 测试 数据库
原文链接：http://www.cnblogs.com/xiangyisheng/p/6714213.html
版权

效果图：

加载购物车列表(局部视图) 

function LoadExpenseDetailsList() {
　　$("#tbExpenseDetailsList tbody").load("/Payment/LoadExpenseDetailsList");
}
<table class="table table-bordered table-striped table-condensed table-hover fixheader"
    id="tbExpenseDetailsList">
    <thead>
        <tr>
            <th>
                Operate
            </th>
            <th>
                number
            </th>
            <th>
                Expense Items
            </th>
            <th>
                Expense Items Detail
            </th>
            <th>
                Product Name
            </th>
            <th>
                Purchase Date
            </th>
            <th>
                Explain
            </th>
            <th>
                Purchaser
            </th>
            <th>
                Payment Date
            </th>
            <th>
                Amount
            </th>
            <th>
                Currency
            </th>
            <th>
                Note
            </th>
        </tr>
    </thead>
    <tbody>
    </tbody>
</table>
View Code 
@using Web.Models;
@using System.Data;
@{
    
    List<ExpenseDetails> list = new List<ExpenseDetails>();
    if (Session["ExpenseDetailsList"] != null)
    {
        list = Session["ExpenseDetailsList"] as List<ExpenseDetails>;
    }
    foreach (ExpenseDetails item in list)
    {
      
    <tr>
        <td>
            <a id="" onclick="RemoveExpenseDetailsList(@item.id)" style="cursor:pointer">Remove</a>
        </td>
        <td>
            @item.id
            <input type="hidden" name="id" value="@item.id" />
        </td>
        <td>
            @item.expenseItems
            <input type="hidden" name="ExpenseItems" value="@item.expenseItems" />
        </td>
        <td>
            @item.expenseItemsDetail
            <input type="hidden" name="ExpenseItemsDetail" value="@item.expenseItemsDetail" />
        </td>
        <td>
            @item.productName
            <input type="hidden" name="ProductName" value="@item.productName" />
        </td>
        <td>
            @if (string.IsNullOrEmpty(item.purchaseDate.ToString()))
            {
                @item.purchaseDate
            }
            else
            {
                @Convert.ToDateTime(item.purchaseDate).ToString("yyyy-MM-dd")
            }
            <input type="hidden" name="PurchaseDate" value="@item.purchaseDate" />
        </td>
        <td>
            @item.explain
            <input type="hidden" name="Explain" value="@item.explain" />
        </td>
        <td>
            @item.purchaser
            <input type="hidden" name="Purchaser" value="@item.purchaser" />
        </td>
        <td>
            @if (string.IsNullOrEmpty(item.paymentDate.ToString()))
            {
                @item.paymentDate
            }
            else
            {
                @Convert.ToDateTime(item.paymentDate).ToString("yyyy-MM-dd")
            }
            <input type="hidden" name="PaymentDate" value="@item.paymentDate" />
        </td>
        <td>
            @item.amount
            <input type="hidden" name="Amount" value="@item.amount" />
        </td>
        <td>
            @item.currency
            <input type="hidden" name="Currency" value="@item.currency" />
        </td>
        <td>
            @item.note
            <input type="hidden" name="Currency" value="@item.note" />
        </td>
    </tr>
    }
}
View Code 
/// <summary>
/// 加载购物车列表数据（显示Session数据）
/// </summary>
public PartialViewResult LoadExpenseDetailsList()
{
    return PartialView("_ExpenseDetailsList");
}
View Code

Add to(添加到购物车列表) 

    function AddToExpenseDetails() {
        var ExpenseItems = $("#ExpenseItems").find("option:selected").text();
        var ExpenseItemsDetail = $("#ExpenseItemsDetail").find("option:selected").text();
        var ProductName = $("#ProductName").val();
        var PurchaseDate = $("#PurchaseDate").val();
        var Explain = $("#Explain").val();
        var Purchaser = $("#Purchaser").find("option:selected").text();
        var PaymentDate = $("#PaymentDate").val();
        var Amount = $("#Amount").val();
        var Currency = $("#Currency").text();
        var Note = $("#Note").val();
        if (Currency == "") {
            AlertMsg("AddToExpenseDetails", "Failure", "Withdrawal account can not be empty!");
            return;
        }
        if (Purchaser == "") {
            AlertMsg("AddToExpenseDetails", "Failure", "Purchaser can not be empty!");
            return;
        }
        if (PaymentDate == "") {
            AlertMsg("AddToExpenseDetails", "Failure", "Payment Date can not be empty!");
            return;
        }
        if (PurchaseDate == "") {
            AlertMsg("AddToExpenseDetails", "Failure", "Purchase Date can not be empty!");
            return;
        }　　
        if (Explain == "") {
            AlertMsg("AddToExpenseDetails", "Failure", "Explain can not be empty!");
            return;
        }
        if (Amount == "") {
            AlertMsg("AddToExpenseDetails", "Failure", "Amount can not be empty!");
            return;
        }
        $.post("/Payment/AddExpenseDetailsInfo", {
            ExpenseItems: ExpenseItems,
            ExpenseItemsDetail: ExpenseItemsDetail,
            ProductName: ProductName,
            PurchaseDate: PurchaseDate,
            Explain: Explain,
            Purchaser: Purchaser,
            PaymentDate: PaymentDate,
            Amount: Amount,
            Currency: Currency,
            Note: Note
        }, function (data) {
            if (data == "Yes") {
                $("#ExpenditureAccount").attr("disabled", true);
                $("#ExpenseNote").attr("disabled", true);
                $("#Purchaser").attr("disabled", true);
                $("#PaymentDate").attr("disabled", true);
                $("#Explain").attr("disabled", true);
                $("#PurchaseDate").attr("disabled", true);
                $("#ProductName").val("");
                $("#Amount").val("");
                $("#Note").val("");
                LoadExpenseDetailsList();
            }
        });
    }
View Code 
　　　　　/// <summary>
        ///类似 添加购物车
        /// </summary>
        [HttpPost]
        public string AddExpenseDetailsInfo(string ExpenseItems, string ExpenseItemsDetail, string ProductName, DateTime PurchaseDate, string Explain, string Purchaser, DateTime PaymentDate, decimal Amount, string Currency, string Note)
        {
            try
            {
                List<ExpenseDetails> list = new List<ExpenseDetails>();
                if (Session["ExpenseDetailsList"] != null)
                {
                    list = Session["ExpenseDetailsList"] as List<ExpenseDetails>;
                }
                ExpenseDetails entity = new ExpenseDetails();
                entity.id = list.Count + 1;
                entity.expenseItems = ExpenseItems;
                entity.expenseItemsDetail = ExpenseItemsDetail;
                entity.productName = ProductName;
                entity.purchaseDate = PurchaseDate;
                entity.explain = Explain;
                entity.purchaser = Purchaser;
                entity.paymentDate = PaymentDate;
                entity.amount = Amount;
                entity.currency = Currency;
                entity.note = Note;
                list.Add(entity);

                //decimal total = 0;
                for (int i = 0; i < list.Count; i++)
                {
                    list[i].id = i + 1;
                    //total += list[i].amount;
                }
                //ViewData["Total"] = total;
                Session["ExpenseDetailsList"] = list;
                return "Yes";

            }
            catch (Exception ex)
            {
                return "No";
            }
        }
View Code

Remove(删除购物车数据) 

    function RemoveExpenseDetailsList(id) {
        $.post("/Payment/DelExpenseDetailsInfo", { id: id }, function (data) {
            if (data == "empty") {
                $("#ExpenditureAccount").attr("disabled", false);
                $("#ExpenseNote").attr("disabled", false);
                $("#Purchaser").attr("disabled", false);
                $("#PaymentDate").attr("disabled", false);
                $("#Explain").attr("disabled", false);
                $("#PurchaseDate").attr("disabled", false);
            }
            LoadExpenseDetailsList();
        });
    }
　　　　 /// <summary>
        /// 根据ID删除购物车列表数据（删除Session值）
        /// </summary>
        [HttpPost]
        public string DelExpenseDetailsInfo(int id)
        {
            if (id != 0)//id=0 清空购物车(Remove All)
            {
                List<ExpenseDetails> list = new List<ExpenseDetails>();
                if (Session["ExpenseDetailsList"] != null)
                {
                    list = Session["ExpenseDetailsList"] as List<ExpenseDetails>;
                    var item = list.Where(w => w.id == id).FirstOrDefault();
                    if (item != null)
                    {
                        list.Remove(item);
                        if (list.Count > 0)
                        {
                            for (int i = 0; i < list.Count; i++)
                            {
                                list[i].id = i + 1;
                            }
                            Session["ExpenseDetailsList"] = list;
                        }
                        else
                        {
                            Session["ExpenseDetailsList"] = null;
                        }
                    }
                }
            }
            else
            {
                Session["ExpenseDetailsList"] = null;
            }
            return Session["ExpenseDetailsList"] == null ? "empty" : "have";
        }
View Code

 Save All(保存所有数据到数据库)

    function SaveAll() {
        var Issued = $("#Issued").val();
        var ExpenditureAccountID = $("#ExpenditureAccount").children('option:selected').val();
        var ExpenditureAccountInfo = $("#ExpenditureAccount").find("option:selected").text();
        var Explain = $("#Explain").children('option:selected').val();
        var Purchaser = $("#Purchaser").children('option:selected').val();
        var PaymentDate = $("#PaymentDate").val();
        var Note = $("#ExpenseNote").val();
        if (ExpenditureAccountID == "") {
            AlertMsg("SaveAll", "Failure", "Withdrawal accounts can not be empty!");
            return;
        }
        if (Purchaser == "") {
            AlertMsg("SaveAll", "Failure", "Purchaser can not be empty!");
            return;
        }
        $("#SaveAll").attr("disabled", true);
        $.post("/Payment/SaveAllExpenseDetails", {
            Issued: Issued,
            PaymentType: "Expense",
            ExpenditureAccountID: ExpenditureAccountID,
            ExpenditureAccountInfo: ExpenditureAccountInfo,
            Purchaser: Purchaser,
            Explain: Explain,
            PaymentDate: PaymentDate,
            Note: Note
        },
        function (data) {
            if (data == "true") {
                AlertMsg("SaveAll", "Success", "Save all success!");
                $("#ExpenditureAccount").attr("disabled", false);
                $("#ExpenseNote").attr("disabled", false);
                $("#Purchaser").attr("disabled", false);
                $("#PaymentDate").attr("disabled", false);
                $("#Explain").attr("disabled", false);
                $("#PurchaseDate").attr("disabled", false);
                $("#Currency").text("");
                $("#Purchaser").val("");
                $("#Explain").val("");
                $("#PaymentDate").val("");
                $("#PurchaseDate").val("");
                $("#tbExpenseDetailsList tbody").html("");
                $("#ExpenseNote").val("");
                GetBankAccount("");
            } else if (data == "empty") {
                AlertMsg("SaveAll", "Failure", "No data!");
            }
            else if (data == "false") {
                AlertMsg("SaveAll", "Failure", "Save all failure!");
            } else {
                AlertMsg("SaveAll", "Failure", data);
            }
            $("#SaveAll").attr("disabled", false);
        });
    }
View Code 
        /// <summary>
        /// 保存购物车中所有数据到数据库（添加Session值到数据库）
        /// </summary>
        [HttpPost]
        public string SaveAllExpenseDetails(string Issued, string PaymentType, int? ExpenditureAccountID, string ExpenditureAccountInfo, string Purchaser, string PaymentDate, string Note, string Explain)
        {
            string CreateBy = Issued;
            DateTime CreateDate = DateTime.Now;
            string sql = "";
            int? AccountID = ExpenditureAccountID;
            string AccountName = "";
            string AccountNumber = "";
            string Currency = "";
            decimal Balance = 0;
            decimal ExpenditureAmount = 0;

            List<ExpenseDetails> list = new List<ExpenseDetails>();
            list = Session["ExpenseDetailsList"] as List<ExpenseDetails>;
            if (list != null && list.Count > 0)
            {
                foreach (ExpenseDetails item in list)
                {
                    ExpenditureAmount += item.amount;
                }
            }
            else
            {
                return "empty";
            }

            if (!string.IsNullOrEmpty(ExpenditureAccountInfo))
            {
                string[] strExpenditure = ExpenditureAccountInfo.Split('-');
                AccountName = strExpenditure[0];
                AccountNumber = strExpenditure[2];
                Balance = Convert.ToDecimal(strExpenditure[3]) - Convert.ToDecimal(ExpenditureAmount);
                Currency = strExpenditure[4];
            }

            if (Balance > 0)
            {
                sql += @"INSERT INTO dbo.Payments(PaymentType, AccountID, AccountName, AccountNumber, Expense, Income, Currency, Balance, Explain, Purchaser, PaymentDate, Note, CreateDate, CreateBy) VALUES(";
                sql += "N'" + PaymentType + "',";
                sql += "N'" + AccountID + "',";
                sql += "N'" + AccountName + "',";
                sql += "N'" + AccountNumber + "',";
                sql += "N'" + ExpenditureAmount + "',";
                sql += "N'" + 0 + "',";
                sql += "N'" + Currency + "',";
                sql += "N'" + Balance + "',";
                sql += "N'" + Explain + "',";
                sql += "N'" + Purchaser + "',";
                sql += "N'" + PaymentDate + "',";
                sql += "N'" + Note + "',";
                sql += "N'" + CreateDate + "',";
                sql += "N'" + CreateBy + "'";
                sql += @")
";
                sql += @"UPDATE dbo.BankAccount SET Balance=" + Balance + " WHERE ID=" + AccountID + @"
";
            }
            else
            {
                return "Sorry, your credit is running low";
            }

            try
            {
                if (SQLHelper.ExecuteNonQuery(sql) > 0)
                {
                    sql = "";
                    int PaymentID = SQLHelper.ExecuteScalar("SELECT TOP(1) PaymentID FROM dbo.Payments ORDER BY CreateDate DESC");
                    foreach (ExpenseDetails item in list)
                    {
                        sql += @"INSERT INTO dbo.ExpenseDetails(PaymentID, ExpenseItems, ExpenseItemsDetail, ProductName, PurchaseDate, Explain, Purchaser, PaymentDate, Amount, Currency, Note, CreateDate, CreateBy) VALUES(";
                        sql += "N'" + PaymentID + "',";
                        sql += "N'" + item.expenseItems + "',";
                        sql += "N'" + item.expenseItemsDetail + "',";
                        sql += "N'" + item.productName + "',";
                        sql += "N'" + item.purchaseDate + "',";
                        sql += "N'" + item.explain + "',";
                        sql += "N'" + item.purchaser + "',";
                        sql += "N'" + item.paymentDate + "',";
                        sql += "N'" + item.amount + "',";
                        sql += "N'" + item.currency + "',";
                        sql += "N'" + item.note + "',";
                        sql += "N'" + CreateDate + "',";
                        sql += "N'" + CreateBy + "'";
                        sql += @")
";
                    }
                    if (SQLHelper.ExecuteNonQuery(sql) > 0)
                    {
                        Session["ExpenseDetailsList"] = null;
                        return "true";
                    }
                    else
                    {
                        return "false";
                    }
                }
                else
                {
                    return "false";
                }
            }
            catch (Exception)
            {
                return "false";
            }
        }
View Code

 

作者： 长毛象
本文版权归作者和博客园共有，个人学习成果，请多多指教，欢迎转载，请保留 原文链接

转载于:https://www.cnblogs.com/xiangyisheng/p/6714213.html

p是马甲
关注
使用MVC架构和session做了个简单的添加购物车场景
小张的博客
06-27 564
一、MVC三层架构 （一）什么是MVC三层架构 MVC全称（Model-View-Controller）即模型层、视图层、控制层，是JavaWeb服务器比较主流的代码设计模式，宗旨高内聚、低耦合，也就是追求每层内部的元素尽量能独立完成某一功能，关联性强的情况下还不能有很高的依赖性，当一层代码进行改进后，其他层的尽可能不受其影响，这也对后期代码的维护、迭代更新更方便。 （二）MVC分层 Model层 即数据模型层，一般应用中包...
JavaWEB【MVC购物车】
m0_64522859的博客
04-26 433
1.引入 问题1：先有servlet还是先有jsp？ 先有servlet web发展史：HTML静态页面---serlvet----jsp 问题2：web开发模式发展：模型1 模型2 只有静态页面的时候： HTML+css 出现servlet之后：可以进行交互 模型1：第一代----把所有的代码（java+html）写一个jsp页面。 一层 模型1：第二代---javabean：将数据库交互的代码进行封装 src 二层 模型2：MVC 问题：三层架构---开发设计模式，将程序分为三层去管
抽离内嵌页使用ajax局部刷新页面信息更新购物车的选中状态
qq_25881443的博客
10-25 241
ajax局部刷新购物车数量,ajax局部刷新版实例 (三种方法推荐)
weixin_36103691的博客
08-05 186
ajax局部刷新版setInterval("refreshTime()",1000); //每格1秒刷新版一次funciton refreshTime(){var dateObj = new Date();time.innerHTML = dateObj.toLocaleDateString(); //刷新版div里面的内容}function doRef(){var url = "xxx.aspx...
购物车和AJAX局部刷新两个实例源码
12-30
购物车和AJAX局部刷新两个实例源码 代码写的比较简单，我没有分层写，我直接就在页面类中写操作代码，其实这两个实例主要是想让一些才接触编程的朋友们了解一下，购物车和AJAX局部刷新简单实现。。
ecshop购物车页面点击更新购物车按钮页面跳转
hxx123_的博客
01-13 1286
在ecshop购物车页面中，点击“更新购物车”按钮页面会跳转，并停留3秒后，再跳回过无车页面。 跳转： 去除页面跳转的解决办法： 在flow.php中找到：show_message($_LANG['update_cart_notice'], $_LANG['back_to_cart'], 'flow.php');（大概在1816行左右），将其更改为
基于MVC的购物车系统
12-19
此外，为了提升用户体验，可能会使用Ajax技术实现页面局部刷新，减少用户等待时间。 在【压缩包子文件的文件名称列表】中提到的"ShoppingBook10_1"，这可能是系统的一部分源代码或者相关的文档，包含了关于购物车...
JSP+MVC+DAO+Ajax设计的团购网站
07-08
本项目是一个基于JSP的团购网站，采用了MVC（Model-View-Controller）设计模式和DAO（Data Access Object）模式进行架构设计，同时充分利用了Ajax技术以实现无刷新交互，为用户提供流畅的浏览体验。下面将详细介绍...
ssh mvc ajax 购物车
09-11
5. **AJAX**: AJAX（异步JavaScript和XML）技术用于在不刷新整个页面的情况下与服务器交换数据并局部更新页面。在购物车中，当用户增加或减少商品数量时，可以通过AJAX发送请求，后台处理后返回结果，前端再动态更新...
使用session技术来实现网上商城购物车的功能【整理】
学习笔记
04-27 8181
首先、简单的了解session和cookie的区别： 一、session和cookie的区别： session是把用户的首写到用户独占的session中（服务器端） cookie是把用户的数据写给用户的浏览器。 session对象由服务器创建，开发人员可以调用request对象的getsession方法得到session对象。 转自（实现代码）：http://www.
DataTable 导出excel 更新列名或者删除部分列.pdf
08-21
DataView dataList = saBatteryHelper.GetSaBatteryList(condition, "PAGE", Int32.Parse(string.IsNullOrEmpty(Imagebutton2.ToolTip) ? "0" : Imagebutton2.ToolTip), this.dg_detail.PageSize, ref total_page, ref total_rec); if (dataList.Table.Columns.Contains("ROW_ID")) dataList.Table.Columns.Remove("ROW_ID"); if (dataList.Table.Columns.Contains("LAST_UPDATED_BY")) dataList.Table.Columns.Remove("LAST_UPDATED_BY"); if (dataList.Table.Columns.Contains("LAST_UPDATE_DATE")) dataList.Table.Columns.Remove("LAST_UPDATE_DATE"); if (dataList.Table.Columns.Contains("CREATED_BY")) dataList.Table.Columns.Remove("CREATED_BY"); if (dataList.Table.Columns.Contains("RELATIONSHIPID")) dataList.Table.Columns["RELATIONSHIPID"].ColumnName = "SA";
session + List<T> 实现购物车(asp.net mvc)
sheeran_x的博客
04-07 2096
毕业设计做电子商务网站，结果卡购物车德实现上卡了N久，以下是我的思路： 1.session 用于存储用户名和购物车 2.List 用于存储购物车对象 部分代码： 1. 购物车： public class Cart(){ public int cartId{get;set;} public int albumId{get;set;} public int quan
【SSH网上商城项目实战28】使用Ajax技术局部更新商品数量和总价
热门推荐
武哥聊编程
05-24 1万+
在没有Ajax之前，一般都是根据用户修改的值去找Action，然后返回新的jsp页面重新加载整个页面，完成数字的更新。但是有了Ajax技术后，我们可以利用Ajax技术局部刷新要改变的地方，而不是重新加载整个页面。
Ecshop ajax 局部刷新购物车功能
xllily11的袅袅
04-05 223
1、比如我们category.dwt 里有 &lt;a href='flow.php'&gt;&lt;SPAN id='cart_count_all'&gt;{insert name='cart_info'}&lt;/SPAN&gt;&lt;/A&gt; &lt;a onclick="javascript:addToCart_xaphp({$goods.goods_id});" ...
asp.net购物车实现-------结合session方式
我生活的点滴
03-08 4997
///     /// 购买    ///     ///     ///     protected void imgbtn_Buy_Click(object sender, ImageClickEventArgs e)    {        if (Session["CurrentUser"] != null)        {            if (Session["Cart"]
用Cookie和Session简单实现购物车
sinat_36700834的博客
11-30 6483
作为单身汪的小编,无法体会到被女神逼着清空购物车的那种”快感”!!,罢特!!我可以自己清空呀!! 傲娇脸~~冰箱, 手机, 电视, 手电筒 来一套!!(ps:手电筒是什么鬼!!)下面我用Cookie和Session来清空购物车里的这4样东东!! 感觉自己有点溜!!一.CookieCookie分为会话级别和持久化两种,这里将利用的是持久化的Cookie,以遍保存并显示浏览商品记录,和实现商品就算页面(
mvc模式网页购物车
weixin_43717772的博客
12-30 3782
本学期学习JSP和Servlet后，老师要求使用MVC模式下编写一个网页购物车，以下是一些主要代码及开发心得 这个是包的截图 先是注册页面，编写一个表单，表单方法调用另一个JSP页面（因为我这个页面是写的JSP页面链接数据库，你也可以直接使用DBDao连接数据库） &lt;form action="checkRegister.jsp" method="post" onsubmit="return...
Ajax实现局部刷新：商品数量与总价动态更新
本文将介绍如何使用Ajax...在购物车场景中，局部刷新商品数量和总价不仅减少了页面加载时间，也保持了用户对当前页面的连续性感知。同时，通过合理的前端和后端设计，可以有效地处理这些异步请求，实现高效的数据更新。
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值