Hidistro.SqlDal/Orders/OrderSplitDao.cs

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

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

namespace Hidistro.SqlDal.Orders
{
    using Hidistro.Core;
    using Hidistro.Entities;
    using Hidistro.Entities.Orders;
    using Microsoft.Practices.EnterpriseLibrary.Data;
    using System;
    using System.Collections.Generic;
    using System.Data;
    using System.Data.Common;
    using System.Runtime.InteropServices;
    using System.Text;

    public class OrderSplitDao
    {
        private Database database = DatabaseFactory.CreateDatabase();

        public bool DelOrderSplitByOrderID(string oldorderid, DbTransaction dbTran = null)
        {
            string query = "delete from vshop_OrderSplit where OldOrderID=@OldOrderID";
            DbCommand sqlStringCommand = this.database.GetSqlStringCommand(query);
            this.database.AddInParameter(sqlStringCommand, "OldOrderID", DbType.String, oldorderid);
            if (dbTran == null)
            {
                return (this.database.ExecuteNonQuery(sqlStringCommand) > 0);
            }
            return (this.database.ExecuteNonQuery(sqlStringCommand, dbTran) > 0);
        }

        public bool DelOrderSplitInfo(int id)
        {
            string query = "delete  from vshop_OrderSplit where ID=" + id;
            DbCommand sqlStringCommand = this.database.GetSqlStringCommand(query);
            return (this.database.ExecuteNonQuery(sqlStringCommand) > 0);
        }

        public int GetMaxOrderIDNum(string orderid)
        {
            StringBuilder builder = new StringBuilder();
            builder.Append("select isnull(Max(OrderIDNum),0) from vshop_OrderSplit ");
            builder.Append(" where OldOrderID=@OldOrderID ");
            DbCommand sqlStringCommand = this.database.GetSqlStringCommand(builder.ToString());
            this.database.AddInParameter(sqlStringCommand, "OldOrderID", DbType.String, orderid);
            return Globals.ToNum(this.database.ExecuteScalar(sqlStringCommand));
        }

        public OrderSplitInfo GetOrderSplitInfo(int id)
        {
            string query = "select * from vshop_OrderSplit where ID=" + id;
            DbCommand sqlStringCommand = this.database.GetSqlStringCommand(query);
            using (IDataReader reader = this.database.ExecuteReader(sqlStringCommand))
            {
                return ReaderConvert.ReaderToModel<OrderSplitInfo>(reader);
            }
        }

        public OrderSplitInfo GetOrderSplitInfoByOrderIDAndNum(int orderidnum, string oldorderid)
        {
            string query = "select * from vshop_OrderSplit where OldOrderID=@OldOrderID and OrderIDNum=@OrderIDNum";
            DbCommand sqlStringCommand = this.database.GetSqlStringCommand(query);