MyBookShop/DAL/DALOrderBook.cs

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

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
{
    /*
    * 类名：DALOrderBook
    * 创建时间：2016/10/11 13:20:04
    * 创建人：XX人员
    * 基本功能：
    * 版本：
    *        version 1.0
    * **/
    public class DALOrderBook
    {
        /// <summary>
        /// 实例化SqlHelper对象
        /// </summary>
        SqlHelper helper = new SqlHelper();
        /// <summary>
        /// 通过订单编号获取订单详情
        /// </summary>
        /// <param name="orderid"></param>
        /// <returns></returns>
        public List<OrderBook> GetList(int orderid)
        {
            string sql = "select * from OrderBook where OrderID=@OrderID";
            SqlParameter[] parameters = new SqlParameter[] { 
                   new SqlParameter("@OrderID",SqlDbType.Int){Value=orderid}
             };
            DataSet ds = helper.ExcuteSelect(parameters,sql);
            List<OrderBook> list = DataTransfer<OrderBook>.GetList(ds);
            return list;
        }
        /// <summary>
        /// 新增一条商品详情
        /// </summary>
        /// <param name="entity"></param>
        /// <returns></returns>
        public bool Add(OrderBook entity)
        {
            string sql = "insert into OrderBook values(@OrderID,@BookID,@Quantity)";
            SqlParameter[] parameters = new SqlParameter[] { 
                   new SqlParameter("@OrderID",SqlDbType.Int){Value=entity.OrderID},
                   new SqlParameter("@BookID",SqlDbType.Int){Value=entity.BookID},
                   new SqlParameter("@Quantity",SqlDbType.Decimal){Value=entity.Quantity}
             };
            return helper.ExcuteNonQuery(parameters, sql, CommandType.Text) > 0 ? true : false;
        }
    }
}