shop.DAL/OrderDAO.cs

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

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using shop.Model;
using Microsoft.Practices.EnterpriseLibrary.Data;
using System.Data.Common;
using System.Data;

namespace shop.DAL
{
    public class OrderDAO
    {
        public bool Add(Order order)
        {
            Database database = DatabaseFactory.CreateDatabase();
            string sql = "insert into [order] (Id,member_id,total_money,discount_money,shipping_method_id,payment_method_id,shipping_date_id,remark,create_date,order_status_id,invoice_head,receiver,address,tel,modify_money,modify_season) values (@Id,@member_id,@total_money,@discount_money,@shipping_method_id,@payment_method_id,@shipping_date_id,@remark,default,@order_status_id,@invoice_head,@receiver,@address,@tel,@modify_money,@modify_season)";
            DbCommand cmd = database.GetSqlStringCommand(sql);
            database.AddInParameter(cmd, "@Id", DbType.String, order.Id);
            database.AddInParameter(cmd,"@member_id",DbType.Int32,order.MemberId);
            database.AddInParameter(cmd, "@total_money", DbType.Decimal, order.TotalMoney);
            database.AddInParameter(cmd, "@discount_money", DbType.Decimal, order.DiscountMoney);
            database.AddInParameter(cmd, "@shipping_method_id", DbType.Int32, order.ShippingDateId);
            database.AddInParameter(cmd, "@payment_method_id", DbType.Int32, order.PaymentMethodId);
            database.AddInParameter(cmd, "@shipping_date_id", DbType.Int32, order.ShippingDateId);
            database.AddInParameter(cmd, "@order_status_id", DbType.Int32, order.OrderStatusId);
            database.AddInParameter(cmd, "@remark", DbType.String, order.Remark);
            database.AddInParameter(cmd, "@invoice_head", DbType.String, order.InvoiceHead);
            database.AddInParameter(cmd, "@receiver", DbType.String, order.Receiver);
            database.AddInParameter(cmd, "@address", DbType.String, order.Address);
            database.AddInParameter(cmd, "@tel", DbType.String, order.Tel);
            database.AddInParameter(cmd,"@modify_money",DbType.Decimal,order.ModifyMoney);
            database.AddInParameter(cmd,"@modify_season",DbType.String,order.ModifySeason);
            int row = database.ExecuteNonQuery(cmd);
            return row > 0;
        }

        public bool Delete(string Id)
        {
            Database database = DatabaseFactory.CreateDatabase();
            string sql = "delete from [order] where Id=@Id";
            DbCommand cmd = database.GetSqlStringCommand(sql);
            database.AddInParameter(cmd, "@Id", DbType.String, Id);
            int row = database.ExecuteNonQuery(cmd);
            return row > 0;
        }

        public bool Update(Order order)
        {
            Database database = DatabaseFactory.CreateDatabase();
            string sql = "update [order] set total_money=@total_money,discount_money=@discount_money,shipping_method_id=@shipping_method_id,payment_method_id=@payment_method_id,shipping_date_id=@shipping_date_id,remark=@remark,order_status_id=@order_status_id,invoice_head=@invoice_head,receiver=@receiver,address=@address,tel=@tel,modify_money=@modify_money,modify_season=@modify_season where Id=@Id";
            DbCommand cmd = database.GetSqlStringCommand(sql);
            database.AddInParameter(cmd, "@Id", DbType.String, order.Id);
            database.AddInParameter(cmd, "@total_money", DbType.Decimal, order.TotalMoney);
            database.AddInParameter(cmd, "@discount_money", DbType.Decimal, order.DiscountMoney);
            database.AddInParameter(cmd, "@shipping_method_id", DbType.Int32, order.ShippingDateId);
            database.AddInParameter(cmd, "@payment_method_id", DbType.Int32, order.PaymentMethodId);
            database.AddInParameter(cmd, "@shipping_date_id", DbType.Int32, order.ShippingDateId);
            database.AddInParameter(cmd, "@order_status_id", DbType.Int32, order.OrderStatusId);
            database.AddInParameter(cmd, "@remark", DbType.String, order.Remark);