MyBookShop/DAL/DALOrders.cs

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

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

using Core;
using Core.SqlHelper;
using Model;
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace DAL
{
    /*
        * 类名：DALOrders
        * 创建时间：2016/10/11 10:46:59
        * 创建人：XX人员
        * 基本功能：
        * 版本：
        *        version 1.0
        * **/
   public  class DALOrders
    {
        /// <summary>
        /// 实例化SqlHelper对象
        /// </summary>
        SqlHelper helper = new SqlHelper();
        DALUserInfo daluser = new DALUserInfo();
        /// <summary>
        /// 获取所有订单信息
        /// </summary>
        /// <param name="state">为1返回已完成订单信息</param>
        /// <returns></returns>
        public List<Orders> GetList(int? state, string search=null)
        {
            string sql = "select * from Orders where 1=1 ";
            switch (state)
            {
                case 0: sql += " and OrderState=0 "; break;
                case 1: sql += " and OrderState=1 "; break;
            }
            if (!string.IsNullOrEmpty(search))
            { sql += " and Id like '%" + search + "%'"; }
            DataSet ds = helper.ExcuteSelect(sql);
            List<Orders> list = DataTransfer<Orders>.GetList(ds);
            if (list != null)
            {
                list.ForEach((item) =>
                {
                    item.User = daluser.GetEntity(item.UserId);
                });
            }
            return list;
        }
        /// <summary>
        /// 获取一条订单信息
        /// </summary>
        /// <returns></returns>
        public Orders GetEntity(int id)
        {