App_Code/User/Order.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Data;
using System.Configuration;

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;


namespace BLL
{
    /// <summary>
    ///Order 的摘要说明
    /// </summary>
    public class Order
    {
        public Order()
        {
            //
            //TODO: 在此处添加构造函数逻辑
            //
        }

        /// <summary>
        /// 按用户的ID及类型来获得会员的订单
        /// </summary>
        /// <param name="userId">用户的ID</param>
        ///  /// <param name="opr">操作符号</param>
        /// <param name="type">订单状态号</param>
        /// <returns></returns>
        public static DataTable getOrderByUserId(int userId,int isEnd)
        {
            string condition = "";
            if (isEnd == 1)
                condition = "bs_Orders.status = '0108'";
            else
                condition = "bs_Orders.status <> '0108'";
            string sql = string.Format("select bs_Orders.*,sy_code.code as statusCode,sy_code.Name as orderStatus,Sy_Deliver.url from bs_Orders " +
                " join sy_code on(bs_Orders.status = sy_code.code) "+
                " left join Sy_Deliver on (Sy_Deliver.code = bs_Orders.Sy_DeliverCode)" +
                " where bs_Orders.Bs_UserId={0} and {1} order by bs_Orders.status", userId, condition);
            return CSA.DAL.DBAccess.getRS(sql);
        }

        /// <summary>
        /// 按订单的ＩＤ来获得订单的商品
        /// </summary>
        /// <param name="orderId"></param>
        /// <returns></returns>
        public static DataTable GetOrderDetailByOrderId(int orderId)
        {
            string sql = string.Format(@"select bs_Products.name,bs_Products.Pic,bs_OrdersDtl.* from bs_Orders
                            join bs_OrdersDtl on (bs_Orders.Code = bs_OrdersDtl.bs_OrdersCode)
                            join bs_Products on(bs_Products.Code = bs_OrdersDtl.bs_ProductsCode)
                            where bs_Orders.Id = {0}",orderId);
            return CSA.DAL.DBAccess.getRS(sql);
        }