[转]一步一步asp.net_购物车订单与支付宝

本文转自：http://www.cnblogs.com/mysweet/archive/2012/05/19/2508534.html

最近这几天很忙,一边忙着准备一堆课程设计(8门专业课.....伤不起...时间都是靠挤),一边还要党校培训....呃......顺便做了一下购物车,订单和支付宝简单的流程.

上次,曾经说到一个URL管理的问题,比如我们很多页面为了性能考虑生成静态页面,我们经常

性刚开始的时候用动态页面+ajax的方式加载,页面静态化的时候,如果是新闻内容页,我们可以

把静态页面的URL地址保存在数据库中,但是,单个页面,比如,首页,会员空间的各个页面,就不

适合放在数据库中,这时候更适合写一个通用模块类似MVC中的"控制器"来控制页面的静态化

和URL重写,这就省去了一个一个很繁琐的过程.

打个比方,我们可以写一个通用模块调用:

这种方式类似asp.net 中MVC的控制器,

函数大致的代码思路:

    /// <summary>
    /// 获得路径(暂时只做静态页面管理)(/*在这里可以扩展出URL重写*/)
    /// </summary>
    /// <param name="PageUrl">页面的URL(不包括扩展名)</param>
    /// <param name="QueryString">页面参数</param>
    /// <returns></returns>
    public static string GetURL(string PageUrl,string QueryString)
    {
        //页面路径
        string PagePath = "";

        //如果当前的参数不为空,则加上?
        if (QueryString != "")
            QueryString = "?" + QueryString;
        //如果是静态页面(从配置文件中读取静态页面状态(是否))
        if (ReadURLConfig(PageUrl) == true)
        {
            PagePath=PageUrl + ".htm" + QueryString;
        }
        //如果是动态页面
        else
            PagePath = PageUrl + ".aspx" + QueryString;
        //把相对路径转化为绝对路径
        return   System.Web.VirtualPathUtility.ToAbsolute(PagePath); ;
    }
    /// <summary>
    /// 从配置文件中读取是否生成静态页面
    /// </summary>
    /// <param name="PageName">页面的名称</param>
    /// <returns></returns>
    public static bool ReadURLConfig(string PageName)
    {
        //读取配置文件
        string path = HttpContext.Current.Server.MapPath(@"~/Admin/ConfigManage/URLConfig.xml");
        //XmlHelper.Read(path, "/Node/Element[@Attribute='Name']", "Attribute")
        //是否生成HTML
        string IsHtml="false";
        IsHtml=XMlHelper.Read(path, "/PageSettings/Page[@PageName='"+PageName+"']", "IsHtml");
        if (IsHtml.ToLower() == "true")
        {
            return true;
        }
        else return false;

    }

配置文件属性:(URL重写部分,还没有实现)

我们可以在后台设置那些页面要生成HTML和URL重写规则的定制.......

不过貌似还有好多没实现,正在思考中............

 

 

进入主题:

这次,主要是购物车的实现,购物车的实现,我是在数据库建立了一个购物车的临时表,本来打算用Cookies做,不过,先用数据库做,比较稳妥,Cookies涉及安全性处理需要做很多处理.呃....这个以后可能会深入实现.

首先是,当用户点击

呃.....就ajax加入购物车,然后弹出层,显示

主要是ajax,先加入购物车(加入购物车之前,要检查购物车是否存在此商品,如果存在,本来应该

把购物车中商品的数量+1,我这里是直接提示用户已加入购物车,这是个小BUG),然后回调计

算购物车中的宝贝数量和总金额.

代码不太重要,这里就不粘贴了.

主要是思路要清晰一些.接下来就是购物车结算.

这个用了一个框架(改改颜色就上了,不过感觉加载了好多js,呃,....不过总比asp.net服务端控

件实现要好得多).

 

这个也就是增删改查设计,不过值得一提的就是,我们尽量把大量的前台js代码单独放在一个文

件中,这样客户端的缓存起来第二次访问起来就只需要更少的请求.

前台代码非常简洁:

<%@ Page Language="C#" MasterPageFile="~/Member.master" AutoEventWireup="true" CodeFile="ShopingCart.aspx.cs"
    Inherits="Member_ShopingCart" Title="购物车" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="Server">
    <meta http-equiv="content-type" content="text/html; charset=UTF-8" />
    <link href="../css/buy.css" rel="stylesheet" type="text/css" />

    <script src="../Admin/scripts/jquery-1.6.2.min.js" type="text/javascript"></script>

    <script src="../Admin/scripts/miniui/miniui.js" type="text/javascript"></script>

    <link href="../Admin/scripts/miniui/themes/default/miniui2.css" rel="stylesheet"
        type="text/css" />
    <link href="../Admin/scripts/miniui/themes/icons.css" rel="stylesheet" type="text/css" />
       <script src="../js/AjaxJsDeal/ShoppingCart.js" type="text/javascript"></script>
    <style type="text/css">

        .New_Button, .Edit_Button, .Delete_Button, .Update_Button, .Cancel_Button
        {
            font-size:11px;color:#1B3F91;font-family:Verdana;
            margin-right:5px;
        }


    </style>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="Server">
    <div class="zz">
        <div class="gouwuche">
            <div class="flow-steps">
                <ul class="num5">
                    <li class="current"><span class="first">1. 查看购物车</span></li>
                    <li><span>2. 确认订单信息</span></li>
                    <li><span>3. 付款到支付宝</span></li>
                    <li><span>4. 确认收货</span></li>
                    <li class="last"><span>5. 评价</span></li>
                </ul>
            </div>
            <div class="pay_for">
                <div>
                    商品总价(不含运费)：<span>
                        <label id="lbCountNum1" text="" />
                    </span>元</div>
                <div>
                    <a href="MemberOrders.aspx">
                        <img src="../images/js_small_03.jpg" /></a><a href="MemberOrders.aspx"></a></div>
            </div>
            <div id="datagrid1" class="mini-datagrid" style="width: 700px; height: 250px;" allowresize="true" multiSelect="true"
                url="Data/GetMemberInfo.ashx?method=SearchShoppingCart" idfield="Id">
                <div property="columns" style="color: Black">

                    <div type="checkcolumn" width="30">
                    </div>
                    <div field="ProductId" width="60" headeralign="center" allowsort="true" renderer="onRenderProduct">
                        产品Id</div>
                    <div field="Picturepath" width="100" align="center" headeralign="center" renderer="onReaderPic">
                        图片</div>
                    <div field="ProductName" width="100" headeralign="center" allowsort="true" renderer="onRenderProductName">
                        产品名称</div>
                    <div field="SupperlierName" renderer="RendererSupperlierName" width="120">
                        供应商</div>
                    <div field="Price" width="80" allowsort="true">
                        商品售价</div>
                    <div field="Quantity" width="80" headeralign="center" >
                    <input property="editor" class="mini-spinner" minValue="1"  renderer="onRenderQuantity" maxValue="9999"  value="1" style="width:100%;"/>
                        购买数量</div>
                <div name="action" width="80" headerAlign="center" align="center" renderer="onActionRenderer" cellStyle="padding:0;">操作</div>
                </div>
            </div>
            <table width="700" class="order-table" cellpadding="0" cellspacing="0">
                <tfoot>
                    <tr>
                        <td colspan="4" class="point-info">
                        <%--    <input type="button" onclick="remove" value="批量删除" />--%> <a class="mini-button" iconCls="icon-remove" onclick="remove">批量删除</a>
                        </td>
                        <td colspan="4">
                            <div class="charge-info">
                                商品总价(不含运费):<span>
                                    <label id="lbCountNum">
                                    </label>
                                </span>元</div>
                        </td>
                    </tr>
                    <tr>
                        <td colspan="4">
                        </td>
                        <td colspan="4">
                            <div class="piliang">
                                <a href="MemberOrders.aspx">
                                    <img src="../images/js_big.jpg" /></a></div>
                        </td>
                    </tr>
                </tfoot>
            </table>
        </div>
    </div>

    <script type="text/javascript">
        mini.parse();

        var grid = mini.get("datagrid1");
        grid.load({
            key: "",
            pageIndex: 0,
            pageSize: 10,
            sortField: "Id",
            sortOrder: "asc"
            })
            //初始化
            $(function(){
            GetCartInfo();
            });

    </script>

</asp:Content>

关键性js文件:

   //购物车汇总信息
            function GetCartInfo(){
             $.ajax({
           url:"/Member/Data/GetMemberInfo.ashx?method=GetCartInfo",
           type:"post",
           success:function(text){
           var DataJson=$.parseJSON(text);
            if(DataJson.Status!='False')//执行成功!
            {
                //显示当前购物车总数量和总价
                $("#lbCountNum").text(DataJson.Data[0].CartSum);
                 $("#lbCountNum1").text(DataJson.Data[0].CartSum);
                 //$("#CartMsg").html('目前购物车中已有'+DataJson.Data[0].CartCount+'件宝贝，合计：<span>'+DataJson.Data[0].CartSum+'</span>元');
            }
            else
            alert("加载购物车汇总信息出错!");
           }
           });
            }
             //操作重绘
             function onActionRenderer(e) {
            var grid = e.sender;
            var record = e.record;
            var uid = record._uid;
            var rowIndex = e.rowIndex;

            var s = ''
                    + ' <a class="Edit_Button" href="javascript:editRow(\'' + uid + '\')">编辑</a>'
                    + ' <a class="Delete_Button" href="javascript:delRow(\'' + uid + '\')">删除</a>';

            if (grid.isEditingRow(record)) {
                s = '<a class="Update_Button" href="javascript:updateRow(\'' + uid + '\')">更新</a>'
                    + '<a class="Cancel_Button" href="javascript:cancelRow(\'' + uid + '\')">取消</a>'
            }
            return s;
        }


            //产品名称超链接重绘
            function onRenderProductName(e){
               var record = e.record;
            var uid = record._uid;
            var rowIndex = e.rowIndex;
             var row = grid.getRowByUID(uid);
             var href='<a href="/Product/Product.aspx?ProductId='+row.ProductId+'" >'+ row.ProductName+'</a>';
      return href;
            }
            //产品超链接重绘
            function onRenderProduct(e){
               var record = e.record;
            var uid = record._uid;
            var rowIndex = e.rowIndex;
             var row = grid.getRowByUID(uid);
             var href='<a href="/Product/Product.aspx?ProductId='+row.ProductId+'" >'+ row.ProductId+'</a>';
      return href;

            }
       //图片重绘
        function onReaderPic(e){
          var record = e.record;
            var uid = record._uid;
            var rowIndex = e.rowIndex;
             var row = grid.getRowByUID(uid);
              var src= '<img src="../Admin/FileManage/GetImg.ashx?method=GetMainProductPic&type=small&fileName='+e.value+'" style="width:60px;height:40px;"/>';
             var href='<a href="/Product/Product.aspx?ProductId='+row.ProductId+'" >'+ src+'</a>';
      return href;

        }
        //卖家网址重绘
          function RendererSupperlierName(e) {
            var record = e.record;
            var uid = record._uid;
            var rowIndex = e.rowIndex;
             var row = grid.getRowByUID(uid);
            var SupperlierName=row.SupperlierName;
            var SupperlierId=row.SupperlierId;
            var BelongType=row.BelongType;
            var BelongWebSize;
            if(BelongType==0)
            {
            BelongWebSize="/Master/MasterInfo.aspx?MasterId="+SupperlierId;
            }
            else
             BelongWebSize="/Company/CompanyInfo.aspx?CompanyId="+SupperlierId;
            var s = '<a href="'+BelongWebSize+'" >'+SupperlierName+'</a>';

            return s;
        }
           function editRow(row_uid) {
            var row = grid.getRowByUID(row_uid);
            if (row) {
                grid.cancelEdit();
                grid.beginEditRow(row);
            }
        }
        function cancelRow(row_uid) {
            grid.reload();
        }
        function delRow(row_uid) {
            var row = grid.getRowByUID(row_uid);
            if (row) {
                if (confirm("确定删除此记录？")) {
                    grid.loading("删除中，请稍后......");
                    $.ajax({
                        url: "Data/GetMemberInfo.ashx?method=RemoveShoppingCart&Id=" + row.Id,
                        success: function (text) {
                            grid.reload();
                            GetCartInfo();
                        },
                        error: function () {
                        }
                    });
                }
            }
        }

        function updateRow(row_uid) {
            var row = grid.getRowByUID(row_uid);

            var rowData = grid.getEditRowData(row);
         if(parseInt(row.Num-row.Soldnum)<parseInt(rowData.Quantity))
            {
            alert("当前库存不足!");
            rowData.Quantity=parseInt(row.Num-row.Soldnum);
            return;
            }
            grid.loading("保存中，请稍后......");
            var json = mini.encode([{Id: row.Id,Quantity:rowData.Quantity,ProductId:row.ProductId}]);
            $.ajax({
                url: "Data/GetMemberInfo.ashx?method=SaveShoppingCart",
                data: {ShoppingCart:json},
                success: function (text) {
                    grid.reload();
                     GetCartInfo();
                },
                error: function (jqXHR, textStatus, errorThrown) {
                    alert(jqXHR.responseText);
                }
            });

        }
        //批量删除
         function remove(e) {
            var rows = grid.getSelecteds();
            if (rows.length > 0) {
                if (confirm("确定删除选中商品？")) {
                    var ids = [];
                    for (var i = 0, l = rows.length; i < l; i++) {
                        var r = rows[i];
                        ids.push(r.Id);
                    }
                    var id = ids.join(',');
                    grid.loading("操作中，请稍后......");
                    $.ajax({
                         url: "Data/GetMemberInfo.ashx?method=RemoveShoppingCart&Id=" + id,
                        success: function (text) {
                            grid.reload();
                             GetCartInfo();
                        },
                        error: function () {
                        }
                    });
                }
            } else {
                alert("请选中一条记录");
            }
        }
   //操作重绘
             function onSumRenderer(e) {
            var grid = e.sender;
            var record = e.record;
            var uid = record._uid;
            var rowIndex = e.rowIndex;
             var row = grid.getRowByUID(uid);
            return row.Price*row.Quantity;
        }

不过注意的是,涉及到电子商务,客户端的数据都是不可靠的,所以我们的数据都是从数据库重

新读取.

后台c#处理代码:

  /// <summary>
    /// 购物车检索
    /// </summary>
    /// <param name="context"></param>
    public void SearchShoppingCart(HttpContext context)
    {
        //用户id
        string UserId = SessionHelper.GetSession("UserId").ToString();
       // string key = context.Request["key"];
        //分页
        int pageIndex = Convert.ToInt32(context.Request["pageIndex"]);
        int pageSize = Convert.ToInt32(context.Request["pageSize"]);
        //字段排序
        String sortField = context.Request["sortField"];
        String sortOrder = context.Request["sortOrder"];
        string strCondition = "";
        VCartProductInfoBLL bll = new VCartProductInfoBLL();
        if (Tools.IsNullOrEmpty(sortField))
            sortField = "Id";
        //查询条件
        strCondition = " MemberId=" + UserId;
        //分页数据读取
        IEnumerable<VCartProductInfo> list = bll.ListByPagination(sortField, pageSize, pageIndex + 1, sortOrder == "asc" ? "1" : "0", strCondition);

        //获取总页数
        int totalPage = bll.GetCount(strCondition);
        //JSON 序列化
        string json = Common.FormatToJson.MiniUiListToJson<VCartProductInfo>((IList<VCartProductInfo>)list, totalPage, "");
        context.Response.Write(json);
    }
    /// <summary>
    /// 保存到购物车
    /// </summary>
    /// <param name="context"></param>
    public void SaveShoppingCart(HttpContext context)
    {
        //数据读取
        String Cart = context.Request["ShoppingCart"];
        string info = Cart.TrimStart('[');
        info = info.TrimEnd(']');
        JObject o = JObject.Parse(info);
        Int64 Id = (Int64)o.SelectToken("Id");
        int Quantity = (int)o.SelectToken("Quantity");
        Int64 ProductId = (Int64)o.SelectToken("ProductId");
        //库存判断(从数据库读取库存检验)
        product CartInfo = new productBLL().Get(ProductId);
        if (Quantity > (int)(CartInfo.Num.Value - CartInfo.Soldnum.Value))
        {
            context.Response.Write(Tools.WriteJsonForReturn(false, "库存数量不足!"));
            return;
        }
        //更新购物车
        ShoppingCart Shop=new ShoppingCart ();
        Shop.Id=Id;
        Shop.Quantity=Quantity;
        bool Status=false;
       Status=new ShoppingCartBLL().UpdateShoppingCart(Shop);
       string Msg="";
       if (Status)
       {
           Msg = "";
       }
       else
           Msg = "库存不足!";
       context.Response.Write(Tools.WriteJsonForReturn(Status, Msg));

    }

    /// <summary>
    /// 获取购物车信息
    /// </summary>
    /// <param name="context"></param>
    public void GetCartInfo(HttpContext context)
    {
        string UserId = (string)context.Session["UserId"];

        context.Response.Write(new ShoppingCartBLL().GetCartInfo(UserId));
    }
    /// <summary>
    /// 删除购物车内容
    /// </summary>
    /// <param name="context"></param>
    public void RemoveShoppingCart(HttpContext context)
    {
        String idStr = context.Request["Id"];
        if (String.IsNullOrEmpty(idStr)) return;
        //检验客户端字符串
        if (Common.Tools.IsValidInput(ref idStr, true))
        {
            new ShoppingCartBLL().DeleteMoreID(idStr);
        }
    }

接下来就是订单结算,

呃...订单很丑...没做处理.....

 

其实,这里面大部分信息都是以前做会员信息管理的数据加载,只需要调用会员管理的js,根本业务逻辑都不用写....

相对来说难写一点的就是提交订单的处理,

首先我们要提交订单,我的数据库,设计了订单表和订单商品表,订单号是根据日期生成的,订单号的生成就是类似流水号生成,

这个很重要,因为大多数情况下,订单是日期生成,而且要保证唯一性,以前曾经总看到(数据库的id不设计成自增,然后varchar类型,程序生成id号),

这种设计方式就是严重没考虑并发处理的情况,如果同时n个人订单号根本就不能保证唯一性...

到网上搜索流水号生成,就能看到如何解决这个问题,其实就是建一张表,写存储过程的方式计算id,要保证id的唯一性.

我的这个是从博客园一个高手的日志上切下来的..

获取订单号的存储过程

USE [czcraft]
GO
/****** 对象:  StoredProcedure [dbo].[dpPMT_SGetMaintainSeq]    脚本日期: 05/19/2012 00:18:39 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE  PROC [dbo].[dpPMT_SGetMaintainSeq]
(
@MaintainCate VARCHAR(2)
)
 AS
--***********************累加编号*************************************************
declare @MaintainNo VARCHAR(12) IF NOT EXISTS(SELECT * FROM NumSeq WHERE Cate=@MaintainCate AND DATEDIFF(DAY,CrTime,GETDATE())=0) BEGIN
        INSERT INTO NumSeq(Cate,DateNo,Seq,CrTime) values(@MaintainCate,RIGHT(CONVERT(VARCHAR(4),YEAR(GETDATE())),2)+ REPLICATE('0',2-LEN(MONTH(GETDATE())))+CONVERT(VARCHAR(2),MONTH(GETDATE())),0,getdate()) END
ELSE
    BEGIN
        UPDATE NumSeq SET Seq=Seq+1 WHERE Cate=@MaintainCate AND DateNo=RIGHT(CONVERT(VARCHAR(4),YEAR(GETDATE())),2)+ REPLICATE('0',2-LEN(MONTH(GETDATE())))+CONVERT(VARCHAR(2),MONTH(GETDATE())) END
--************************组合编号***************************************************************
SELECT @MaintainNo=Cate+DateNo+REPLICATE('0',6-LEN(Seq))+CONVERT(VARCHAR(6),Seq) FROM NumSeq WHERE Cate=@MaintainCate AND DateNo=RIGHT(CONVERT(VARCHAR(4),YEAR(GETDATE())),2)+ REPLICATE('0',2-LEN(MONTH(GETDATE())))+CONVERT(VARCHAR(2),MONTH(GETDATE())) SELECT @MaintainNo

调用函数

这样,我们每次插入数据的时候,只要调用这个存储过程就能保证每次生成的订单号都不一样,

接下来就是订单处理了:

我们需要处理哪些呢?

首先是提交用户的收货信息,再次检验库存状态,然后插入订单信息表和订单产品表,并且将商品表的产品数量更新,并且给用户发送订单邮件(我copy的卓越网邮件的HTML布局,哈哈),

这里粘贴主要模块代码:

提交订单:

/// <summary>
   /// 订单提交
   /// </summary>
   /// <param name="context"></param>
   public void SubmitOrderData(HttpContext context)
   {
         string UserId = (string)context.Session["UserId"];
       if(Tools.IsNullOrEmpty(UserId))
       {
           return;
       }
       string Name = context.Request["Name"];
       string Email = context.Request["Email"];
       string Province = context.Request["Province"];
       string City = context.Request["City"];
       string Country = context.Request["Country"];
       string Address = context.Request["Address"];
       string ZipCode = context.Request["ZipCode"];
       string MobilePhone = context.Request["MobilePhone"];
       string TelPhone = context.Request["TelPhone"];
       //订单信息保存
       orders order = new orders();
       order.ConsigneeName = Name;
       order.ConsigneeRealName = Name;
       order.ConsigneeEmail = Email;
       order.ConsigneeProvince = Province;
       order.ConsigneeZip = ZipCode;
       order.UserId =Convert.ToInt32(UserId);
       order.ConsigneeAddress = City + Country + Address;
       order.OrderDate = DateTime.Now;
       order.ConsigneePhone = MobilePhone;
       order.ConsigneeTel = TelPhone;
       order.OrderId = ordersBLL.GetOrderId();
       ordersBLL bll = new ordersBLL();
       string ReturnProductName = "";
       //下单
       bool Status = bll.SaveOrder(ref order, out ReturnProductName);
       //去除最后的,
       ReturnProductName = ReturnProductName.Remove(ReturnProductName.Length - 1, 1);
       string Data = "";
       //支付跳转URL
       string TurnURL = "";
       if (Status)
       {
           Data = "恭喜您!下单成功!";
           //支付平台的跳转URL生成
           PayInfo info=new PayInfo ();
           info.SaleEmail="tianzhuanghu@qq.com";
           info.OrderId=order.OrderId;
           info.ProductName = ReturnProductName;

           info.Remark=order.ConsigneeName+"在"+order.ShopDate.Value.ToShortDateString()+"购买商品,共计:"+order.TotalPrice.Value.ToString ();
           info.TotalFre = order.FactPrice.Value.ToString ();
           Pay pay = new Pay();
          TurnURL=pay.BuildURL(info);
       }
       else
           Data = "对不起!下单失败!";
       //返回的json数据
       string ReturnJson = "{\"Status\":\"" + Status + "\",\"Data\":\"" + Data + "\",\"URL\":\""+TurnURL+"\"}"; ;
        context.Response.Write(ReturnJson);

   }

 

订单提交BLL:

#region 保存订单
       /// <summary>
       /// 保存订单
       /// </summary>
       /// <param name="order">订单</param>
       /// <param name="ReturnProductNames">返回产品名称列表</param>
       /// <returns></returns>
       public bool SaveOrder(ref orders order,out string ReturnProductNames)
       {
           ReturnProductNames = "";
           //查询条件(购物车视图中查询)
           string Condition = " MemberId=" + order.UserId;
           //(需要读取购物车,然后,插入订单商品表和订单表)
           //订单产品信息列表
           List<orderproduct> listOrder = new List<orderproduct>();
           IEnumerable<VCartProductInfo> CartProducts = new VCartProductInfoDAL().ListAll(Condition);
           order.TotalPrice = 0.0;
           order.FactPrice = 0.0;
           foreach (VCartProductInfo CartProduct in CartProducts)
           {
               orderproduct OrderProduct = new orderproduct();
               OrderProduct.AddTime = DateTime.Now;
               OrderProduct.OrderId = order.OrderId;
               OrderProduct.ProId = CartProduct.ProductId.Value.ToString();
               OrderProduct.ProImg = CartProduct.Picturepath;
               OrderProduct.ProName = CartProduct.ProductName;
               ReturnProductNames += OrderProduct.ProName + ",";
               OrderProduct.ProNum = CartProduct.Quantity;
               OrderProduct.ProPrice = CartProduct.Price;
               OrderProduct.ProOtherPara = "";
               OrderProduct.Remark = "";
               OrderProduct.Specification = "";
               //加入到产品订单信息列表中
               listOrder.Add(OrderProduct);
               //总价计算
               order.TotalPrice += OrderProduct.ProPrice.Value * OrderProduct.ProNum.Value;
               //实际总价
               order.FactPrice += OrderProduct.ProPrice.Value * OrderProduct.ProNum.Value;
           }
           //支付状态为等待付款
           order.PaymentStatus = orders.ePaymentStatus.WaitPay.GetHashCode().ToString();
           //订单状态为未支付
           order.OrderStatus = orders.eOrderStatus.NotPay.GetHashCode().ToString();

           //订单状态
           order.IsOrderNormal = 0;
           order.Remark = "";
           order.ShopDate = DateTime.Now;
           order.OrderDate = DateTime.Now;
           //返回订单执行状态
           bool Status = new ordersDAL().AddOrders(order, listOrder);
           if (Status)
           {
               //给客户发邮件
               SMTP smtp = new SMTP(order.ConsigneeEmail);
               smtp.SendMail("潮州工艺平台", SendToCustomContentHtml(order, listOrder));

           }
           return Status;

       }

发送邮件:

  #region 生成给客户发的HTML内容(亚马逊布局)
        /// <summary>
        /// 生成给客户发的HTML内容(亚马逊)
        /// </summary>
        /// <param name="order"></param>
        /// <param name="ProductsList"></param>
        /// <returns></returns>
        public string SendToCustomContentHtml(orders order, IEnumerable<orderproduct> ProductsList)
        {
            //获取当前http上下文
            System.Web.HttpContext context = System.Web.HttpContext.Current;
            //主页
            string Default = context.Request.Url.Scheme + "://" + context.Request.Url.Authority + System.Web.VirtualPathUtility.ToAbsolute("~/Default.aspx");
            //会员订单网址
            string webpath = context.Request.Url.Scheme + "://" + context.Request.Url.Authority + System.Web.VirtualPathUtility.ToAbsolute("~/Member/MemberOrders.aspx");
            //文件流读取
            StringBuilder sb=new StringBuilder ();
            sb.Append(File.ReadAllText (context.Server.MapPath("~/Other/SendToCustomContent.html"),Encoding.UTF8));
            sb.Replace("$ConsigneeRealName", order.ConsigneeRealName);
            sb.Replace("$ConsigneeEmail", order.ConsigneeEmail);
            sb.Replace("$ConsigneeRealName", order.ConsigneeRealName);
            sb.Replace("$ConsigneeAddress", order.ConsigneeAddress);
            sb.Replace("$ConsigneeProvince", order.ConsigneeProvince);
            sb.Replace("$ConsigneeZip", order.ConsigneeZip);
            sb.Replace("$TotalPrice", order.TotalPrice.Value.ToString ());
            sb.Replace("$webpath", webpath);
            sb.Replace("$OrderId", order.OrderId);
            sb.Replace("$TotalPrice", order.TotalPrice.Value.ToString ());
            sb.Replace("$Carriage", order.Carriage.ToString ());//
            sb.Replace("$TotalPrice", order.TotalPrice.Value.ToString ());
            sb.Replace("$FactPrice", order.FactPrice.Value.ToString ());
            sb.Replace("$DateTime", DateTime.Now.AddDays(3).ToShortDateString());

            //商品内容生成
            int num = 0;
            StringBuilder TempData = new StringBuilder();
            foreach (orderproduct Product in ProductsList)
            {
                string temp3 = @"<table><tbody>
<tr valign='top'><td></td><td><font size='-1' face='verdana,arial,helvetica'><b>" + (++num) + @"</b></font></td><td><font size='-1' face='verdana,arial,helvetica'><b>" + Product.ProName + @"</b><br>
<span class='price'>￥ " + Product.ProPrice + @"</span><br>现在有货<br>&nbsp; 卖家： <a href='" + Default + @"' target='_blank'>潮州工艺品集团</a> </font></td></tr></tbody></table>";
                TempData.Append(temp3);


            }
            //商品主体信息替换
            sb.Replace("$Body", TempData.ToString ());
            //sb.Replace("$Carriage", order.Carriage);



            return sb.ToString();

        }

DAL中保存订单处理:

#region 下单
       /// <summary>
       /// 下单
       /// </summary>
       /// <param name="Info">订单信息</param>
       /// <param name="OrderProductsList">订单产品信息</param>
       /// <returns></returns>
       public bool AddOrders(orders order, IEnumerable<orderproduct> OrderProductsList)
       {
           //执行事务状态
           bool Status = false;
           StringBuilder sb = new StringBuilder();
           SqlHelper.Open();
           //开始事务
           SqlHelper.BeginTrans();
           foreach (orderproduct product in OrderProductsList)
           {
               //插入订单产品表信息
               sb.AppendFormat("insert into orderproduct(OrderId,ProId,ProClass,ProName,ProImg,ProPrice,ProNum,AddTime,ProOtherPara,Specification,Remark) output inserted.Id values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}');", product.OrderId, product.ProId, product.ProClass, product.ProName, product.ProImg, product.ProPrice, product.ProNum, product.AddTime, product.ProOtherPara, product.Specification, product.Remark);
               //产品数量修改
               sb.AppendFormat("update product set Num=Num-{0},Soldnum=Soldnum+{0} where Id={1};", product.ProNum, product.ProId);
               //删除购物车中的产品
               sb.AppendFormat("delete from ShoppingCart where ProductId={0} and MemberId={1};", product.ProId, order.UserId);

           }
           //订单信息添加
           sb.AppendFormat("insert into orders(OrderId,UserId,ShopDate,OrderDate,ConsigneeRealName,ConsigneeName,ConsigneePhone,ConsigneeProvince,ConsigneeAddress,ConsigneeZip,ConsigneeTel,ConsigneeEmail,TotalPrice,FactPrice,Remark,OrderStatus,PaymentStatus,IsOrderNormal) values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}','{15}','{16}','{17}');", order.OrderId, order.UserId, order.ShopDate, order.OrderDate, order.ConsigneeRealName, order.ConsigneeName, order.ConsigneePhone, order.ConsigneeProvince, order.ConsigneeAddress, order.ConsigneeZip, order.ConsigneeTel, order.ConsigneeEmail, order.TotalPrice, order.FactPrice, order.Remark, order.OrderStatus, order.PaymentStatus, order.IsOrderNormal);
           Status = SqlHelper.ExecuteNonQuery(sb.ToString());
           if (Status)
           {
               SqlHelper.CommitTrans();
               return true;
           }
           else
           {
               SqlHelper.RollbackTrans();
               return false;
           }


       }

在这里,为了更节省性能,我用StringBuilder拼接字符串,也没有用参数化查询的方式.(注意这里采用事务处理)

然后就是支付平台的实现,其实支付平台说简单点是非常容易的,只需要按照支付的接口提供http请求参数,数字签名,等信息,交易成功然后按照请求读取参数检验数字签名是否正确.

这部分内容,我是准备集成多种支付平台设计,今天只展示支付宝部分.

在设计这部分,我们需要去查看支付宝接口模拟,一般申请支付宝都会提供一个接口测试程序,等等,

我们在做之前,为了考虑多种支付平台的配置,首先定义一些配置信息,

我是把支付宝接口配置成一个网站,然后,通过网关调用,进行模拟

   1:  using System;

   2:  using System.Data;

   3:  using System.Configuration;

   4:  using System.Linq;

   5:  using System.Web;

   6:  using System.Web.Security;

   7:  using System.Web.UI;

   8:  using System.Web.UI.HtmlControls;

   9:  using System.Web.UI.WebControls;

  10:  using System.Web.UI.WebControls.WebParts;

  11:  using System.Xml.Linq;

  12:   

  13:  /// <summary>

  14:  ///PayInfo 的摘要说明

  15:  /// </summary>

  16:  public class PayInfo

  17:  {

  18:      public PayInfo()

  19:      {

  20:          //

  21:          //TODO: 在此处添加构造函数逻辑

  22:          //

  23:      }

  24:      /// <summary>

  25:      /// 商户

  26:      /// </summary>

  27:      public string SaleManId { get; set; }

  28:      /// <summary>

  29:      /// 回调地址

  30:      /// </summary>

  31:      public string CallBackUrl { get; set; }

  32:      /// <summary>

  33:      /// 产品名称

  34:      /// </summary>

  35:      public string ProductName { get; set; }

  36:   

  37:      /// <summary>

  38:      /// 订单号

  39:      /// </summary>

  40:      public string OrderId { get; set; }

  41:      /// <summary>

  42:      /// 总金额

  43:      /// </summary>

  44:      public string TotalFre { get; set; }

  45:      /// <summary>

  46:      /// 卖家邮箱

  47:      /// </summary>

  48:      public string SaleEmail { get; set; }

  49:      /// <summary>

  50:      /// 数字签名

  51:      /// </summary>

  52:      public string Sign { get; set; }

  53:      /// <summary>

  54:      /// 备注信息

  55:      /// </summary>

  56:      public string Remark { get; set; }

  57:   

  58:  }

  59:  /// <summary>

  60:  /// 支付回调信息

  61:  /// </summary>

  62:  public class PayCallBackInfo

  63:  {

  64:      /// <summary>

  65:      /// 支付类型

  66:      /// </summary>

  67:      public Pay.PayType PayType { get; set; }

  68:      /// <summary>

  69:      /// 订单号

  70:      /// </summary>

  71:      public string OrderId { get; set; }

  72:      /// <summary>

  73:      /// 支付机构

  74:      /// </summary>

  75:      public string PayMode { get; set; }

  76:      /// <summary>

  77:      /// 支付金额

  78:      /// </summary>

  79:      public string PayFre { get; set; }

  80:      /// <summary>

  81:      /// 金额币种

  82:      /// </summary>

  83:      public string MoneyType { get; set; }

  84:      /// <summary>

  85:      /// 备注1

  86:      /// </summary>

  87:      public string Remark1 { get; set; }

  88:      /// <summary>

  89:      /// 备注2

  90:      /// </summary>

  91:      public string Remark2 { get; set; }

  92:      /// <summary>

  93:      /// 数字签名

  94:      /// </summary>

  95:      public string Sign { get; set; }

  96:      /// <summary>

  97:      /// 状态码

  98:      /// </summary>

  99:      public Pay.ReturnCode ReturnCode { get; set; }

 100:      /// <summary>

 101:      /// 回发的消息

 102:      /// </summary>

 103:      public string Msg { get; set; }

 104:  }

 105:  /// <summary>

 106:  /// 支付配置信息

 107:  /// </summary>

 108:  public class PayConfig

 109:  {

 110:      /// <summary>

 111:      /// 支付类型

 112:      /// </summary>

 113:      public Pay.PayType PayType { get; set; }

 114:      /// <summary>

 115:      /// 商户帐号

 116:      /// </summary>

 117:      public string v_mid { get; set; }

 118:      /// <summary>

 119:      /// 商户密码

 120:      /// </summary>

 121:      public string v_pwd { get; set; }

 122:      /// <summary>

 123:      /// 网关地址

 124:      /// </summary>

 125:      public string PayUrl { get; set; }

 126:  }

using System;
using System.Data;
using System.Configuration;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using Common;
using czcraft.BLL;

/// <summary>
///Pay 的摘要说明
/// </summary>
public class Pay
{
    //支付平台的配置信息
    public readonly  PayConfig config;
    public Pay()
    {
        //获取支付平台的配置信息
        config = GetPayConfig();
        //
        //TODO: 在此处添加构造函数逻辑
        //
    }
    /// <summary>
    /// 支付类型
    /// </summary>
    public enum PayType
    {
        /// <summary>
        /// 支付宝
        /// </summary>
        Alipay = 0,
        /// <summary>
        /// 网银在线
        /// </summary>
        ChinaBank = 1
    }
    /// <summary>
    /// 回调状态码(支付宝才有)
    /// </summary>
    public enum ReturnCode
    {
        /// <summary>
        /// 支付成功!
        /// </summary>
        ok = 0,
        /// <summary>
        /// 支付失败!
        /// </summary>
        error = 1
    }

    #region 构造支付的URL
    /// <summary>
    /// 构造支付的URL(从配置文件中读取出支付平台配置信息然后构造支付的网关信息(支付平台由配置文件决定)(初步只提供网银在线和支付宝两种模式中的一种)
    /// </summary>
    /// <param name="Info">支付信息(支付宝支付需要输入总金额,产品名称,订单号,卖家邮箱)</param>
    /// <returns></returns>
    public string BuildURL(PayInfo Info)
    {
        //获取支付平台的配置信息
        //PayConfig config = GetPayConfig();
        //支付的地址
        string PayUrl = "";
        switch (config.PayType)
        {
            //支付宝支付
            case PayType.Alipay:
                PayUrl = BuildAlipayURL(Info, config);
                break;
            //网银在线支付
            case PayType.ChinaBank:
                PayUrl = BuildChinaBackUrl(Info, config);
                break;
            default:
               PayUrl= "#";
               break;
        }
        return PayUrl;
    }
    #endregion

    #region 支付完成回调处理
    /// <summary>
    /// 支付完成回调处理
    /// </summary>
    /// <param name="Msg">回调信息</param>
    /// <returns></returns>
    public PayCallBackInfo CallBackPayInfo()
    {
       string Msg = "";
        PayCallBackInfo CallBackInfo = new PayCallBackInfo();
        switch (config.PayType)
        {
            //支付宝支付
            case PayType.Alipay:
                CallBackInfo = CallBackAlipayInfo();
                break;
            //网银在线支付
            case PayType.ChinaBank:
                CallBackInfo = CallBackChinaBankInfo();
                break;
            default:
                CallBackInfo = null;
                break;
        }
        return CallBackInfo;
    }
    #region 支付宝支付完成回调处理
    /// <summary>
    /// 支付宝支付完成回调处理
    /// </summary>
    /// <param name="Msg">回调信息</param>
    /// <returns></returns>
    private PayCallBackInfo CallBackAlipayInfo()
    {
        //回调信息
       string Msg = "";
        System.Web.HttpContext context = System.Web.HttpContext.Current;
        //订单号
        string OrderId = context.Request["out_trade_no"];
        //回调状态码
        string ReturnCode = context.Request["returncode"];
        //总金额
        string TotalFre = context.Request["total_fee"];
        //数字签名
        string Sign = context.Request["sign"];
        //数字签名(本地计算的)
        string Md5Sign = CommonHelper.GetMD5(OrderId + ReturnCode + TotalFre + config.v_pwd);
        //回调信息
        PayCallBackInfo CallBackInfo = new PayCallBackInfo();
        if (Md5Sign.Equals(Sign))
        {
            //支付成功!
            if (ReturnCode.Equals(Pay.ReturnCode.ok.ToString()))
            {
                Msg = "支付成功!";
                CallBackInfo.Msg = Msg;
                CallBackInfo.OrderId = OrderId;
                CallBackInfo.PayFre = TotalFre;
                CallBackInfo.ReturnCode = Pay.ReturnCode.ok;
            }
            else
            {
                Msg = "支付失败!";

                CallBackInfo.Msg = Msg;
                CallBackInfo.ReturnCode = Pay.ReturnCode.error;
            }

        }
        else
        {
            Msg = "数据被篡改!";
            CallBackInfo.Msg = Msg;
            CallBackInfo.ReturnCode = Pay.ReturnCode.error;
        }
        return CallBackInfo;
    }
    #endregion
    #region 网银在线支付完成回调处理
    /// <summary>
    /// 网银在线支付完成回调处理(未实现)
    /// </summary>
    /// <param name="Msg">回调信息</param>
    /// <returns></returns>
    private PayCallBackInfo CallBackChinaBankInfo()
    {
        //回调信息
      string  Msg = "";
        PayCallBackInfo CallBackInfo = new PayCallBackInfo();
        return CallBackInfo;
    }
    #endregion
    #endregion
    #region 支付宝平台的网关URL
    /// <summary>
    /// 支付宝平台的网关URL
    /// </summary>
    /// <param name="info">支付信息</param>
    /// <param name="config">系统支付配置</param>
    /// <returns></returns>
    private string BuildAlipayURL(PayInfo info, PayConfig config)
    {
        System.Web.HttpContext context = System.Web.HttpContext.Current;
        //为按顺序连接 总金额、 商户编号、订单号、商品名称、商户密钥的MD5值。
        //支付宝数字签名
        string SignMd5 = CommonHelper.GetMD5(info.TotalFre + config.v_mid + info.OrderId + info.ProductName + config.v_pwd);
        //回调网址
        string webpath = context.Server.UrlEncode(context.Request.Url.Scheme + "://" + context.Request.Url.Authority + System.Web.VirtualPathUtility.ToAbsolute("~/Member/Data/DealAlipayCallBack.ashx"));
        //商品名称
        string ProductName = System.Web.HttpContext.Current.Server.UrlEncode(info.ProductName);
        //备注
        string Remark = System.Web.HttpContext.Current.Server.UrlEncode(info.Remark);
        //支付的URL地址
        string PayURL = config.PayUrl + "?partner=" + config.v_mid + "&return_url=" + webpath + "&subject=" + ProductName + "&body=" + Remark + "&out_trade_no=" + info.OrderId + "&total_fee=" + info.TotalFre + "&seller_email=" + info.SaleEmail + "&sign=" + SignMd5;
        return PayURL;

    }
    #endregion

    #region 网银在线平台的网关URL
    /// <summary>
    /// 网银在线平台的网关URL(等待实现)
    /// </summary>
    /// <param name="info">支付信息</param>
    /// <param name="config">系统支付配置</param>
    /// <returns></returns>
    private string BuildChinaBackUrl(PayInfo info, PayConfig config)
    {
        return "";

    }
    #endregion

    #region 获取系统配置信息(支付相关)
    /// <summary>
    /// 获取系统配置信息(支付相关)
    /// </summary>
    /// <returns></returns>
    public PayConfig GetPayConfig()
    {
        PayConfig info = new PayConfig();
        //读取配置文件信息
        string path = System.Web.HttpContext.Current.Server.MapPath(@"~/Admin/ConfigManage/config.xml");
        //系统配置中的支付类型
        string ConfigPayType = XMlHelper.Read(path, "/Root/Pay", "PayType");
        //商户帐号
        string v_mid = XMlHelper.Read(path, "/Root/Pay/" + ConfigPayType, "v_mid");
        //商户密码
        string v_pwd = XMlHelper.Read(path, "/Root/Pay/" + ConfigPayType, "v_pwd");
        //支付网关
        string PayUrl = XMlHelper.Read(path, "/Root/Pay/" + ConfigPayType + "/PayUrl", "");


        info.PayType = ConfigPayType == PayType.Alipay.ToString() ? PayType.Alipay : PayType.ChinaBank;
        info.v_mid = v_mid;
        info.v_pwd = v_pwd;
        info.PayUrl = PayUrl;

        return info;

    }
    #endregion

}

然后支付回调处理:

<%@ WebHandler Language="C#" Class="DealAlipayCallBack" %>

using System;
using System.Web;
//处理关于支付宝回调
public class DealAlipayCallBack : IHttpHandler {

    public void ProcessRequest (HttpContext context) {
        //支付回调
        Pay pay = new Pay();
        PayCallBackInfo CallBackInfo = pay.CallBackPayInfo();
        if (CallBackInfo.ReturnCode == Pay.ReturnCode.ok)
        {
            CallBackInfo.Msg = "恭喜您,支付成功!我们会尽快发货!如果您收货就可以继续确认收货!";
        }
        else
            CallBackInfo.Msg = "对不起,支付失败!!失败信息 :" + CallBackInfo.Msg + "请联系支付宝有关人员!";
        //回调信息
        string Msg = System.Web.HttpContext.Current.Server.UrlEncode(CallBackInfo.Msg);
        Common.JScript.JavaScriptLocationHref("../PayCallBack.aspx?ReturnCode=" + CallBackInfo.ReturnCode.ToString() + "&Msg=" + Msg + "&OrderId=" + CallBackInfo.OrderId + "&PayFre=" + CallBackInfo.PayFre);
    }

    public bool IsReusable {
        get {
            return false;
        }
    }

}

回调前台页面:

<%@ Page Language="C#" MasterPageFile="~/Member.master" AutoEventWireup="true" CodeFile="PayCallBack.aspx.cs"
    Inherits="Member_PayCallBack" Title="支付回调" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="Server">
    <meta http-equiv="content-type" content="text/html; charset=UTF-8" />
    <link href="../css/buy.css" rel="stylesheet" type="text/css" />
      <link href="../css/AliPay.css" rel="stylesheet" type="text/css" />
       <script src="../js/queryUrlParams.js" type="text/javascript"></script>

<style type="text/css">
  .MoneyFont
  {
      font-family:Verdana, Geneva, sans-serif;
    font-size:18px;
    font-weight:bold;
    color:#F60;
  }

</style>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="Server">
   <div class="zz">
        <div class="gouwuche">
            <div class="flow-steps">
                <ul class="num5">
                    <li class="done"><span class="first">1. 查看购物车</span></li>
                    <li class="done current-prev"><span>2. 确认订单信息</span></li>
                    <li class="current"><span>3. 付款到支付宝</span></li>
                    <li><span>4. 确认收货</span></li>
                    <li class="last"><span>5. 评价</span></li>
                </ul>
            </div>
            <div id="main">
                <div id="head">
                    <div id="logo">
                    </div>
                    <dl class="alipay_link">
                        <a target="_blank" href="http://www.alipay.com/"><span>支付宝首页</span></a>| <a target="_blank"
                            href="https://b.alipay.com/home.htm"><span>商家服务</span></a>| <a target="_blank" href="http://help.alipay.com/support/index_sh.htm">
                                <span>帮助中心</span></a>
                    </dl>
                    <span class="title">支付宝纯担保交易付款快速通道</span>
                    <!--<div id="title" class="title">支付宝纯担保交易付款快速通道</div>-->
                </div>
                <div class="cashier-nav">
                    <ol>
                        <li>1、确认付款信息 →</li>
                        <li>2、付款 →</li>
                        <li class="last current">3、付款完成</li>
                    </ol>
                </div>
                <div id="body" style="clear: left">
                    <dl class="content1">
                        <dt>订单号：</dt>
                        <dd>

                            <span id="OrderId"></span>
                        </dd>
                        <dt>付款金额：</dt>
                        <dd>

                            ￥:<span  class="MoneyFont" id="PayFre"></span>
                        </dd>
                        <dt>支付状态：</dt>
                        <dd>

                  <span style="color:Red" id="Msg"></span>
                        </dd>
                        <dt></dt>
                        <dd>
                            <span class="new-btn-login-sp">
                                <input type="button" id="BtnAlipay" name="BtnAlipay" class="new-btn-login" value="确认收货"
                                    style="text-align: center" />
                            </span>
                        </dd>
                    </dl>
                </div>
                <div id="foot1">
                    <ul class="foot-ul">
                        <li>支付宝版权所有 2011-2015 ALIPAY.COM </li>
                    </ul>
                </div>
            </div>
        </div>
    </div>
    <script type="text/javascript">
         //获得回调过来的信息
         $(function(){
     var ReturnCode=$.query.get("ReturnCode");
     var Msg=$.query.get("Msg");
     var OrderId=$.query.get("OrderId");
     var PayFre=$.query.get("PayFre");
         if(ReturnCode=="ok")
         $("#Msg").text("恭喜您,支付成功!我们会尽快发货!如果您收货就可以继续确认收货!");
         else
         $("#Msg").text("对不起,支付失败!!失败信息 :"+Msg+"请联系支付宝有关人员!");
        $("#OrderId").text(OrderId);
         $("#PayFre").text(PayFre);
         });


    </script>
</asp:Content>

 

 

程序截图:

效果图就是这样子

我的google code开源网站首页:http://code.google.com/p/tzhsweetsourse/ 最近准备换份工作，希望大家帮忙推荐推荐！