using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using CY.IDAL;
using System.Data.SqlClient;
using System.Data;
using CY.Model;
using System.Transactions;

namespace CY.SQLDAL
{
    public class EC_MergerSingleDAL : IEC_MergerSingleDAL
    {

        private Database _dataBase = null;

        public EC_MergerSingleDAL()
        {
            _dataBase = new Database();
        }

        public EC_MergerSingleDAL(Database database)
        {
            _dataBase = database;
        }

        /// <summary>
        /// 新增
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public bool InserModel(Infrastructure.Domain.IAggregateRoot model)
        {
            Model.EC_MergerSingle trueModel = model as Model.EC_MergerSingle;
            if (trueModel == null)
            {
                return false;
            }
            IList<SqlParameter> sqlParms = new List<SqlParameter>()
            {
                    new SqlParameter(){Direction=ParameterDirection.ReturnValue,SqlDbType = SqlDbType.Int},
                    new SqlParameter("@Member_id",trueModel.Member_id),
					new SqlParameter("@PO_OrderId",trueModel.PO_OrderId),
					new SqlParameter("@PO_OrderNum",trueModel.PO_OrderNum),
					new SqlParameter("@PMS_OrderNum",trueModel.PMS_OrderNum),
					new SqlParameter("@PMS_OrderPeople",trueModel.PMS_OrderPeople),
					new SqlParameter("@PMS_OrderTime",trueModel.PMS_OrderTime),
					new SqlParameter("@PMS_Emergency",trueModel.PMS_Emergency),
					new SqlParameter("@PMS_Printers",trueModel.PMS_Printers),
					new SqlParameter("@PMS_IsM",trueModel.PMS_IsM),
					new SqlParameter("@PMS_FactoryId",trueModel.PMS_FactoryId),
					new SqlParameter("@PMS_PaperName",trueModel.PMS_PaperName),
					new SqlParameter("@PMS_PaperSpecification",trueModel.PMS_PaperSpecification),
					new SqlParameter("@PMS_PaperCount",trueModel.PMS_PaperCount ?? 0),
					new SqlParameter("@PMS_PaperPositive",trueModel.PMS_PaperPositive ?? 0),
					new SqlParameter("@PMS_PaperConsume",trueModel.PMS_PaperConsume ?? 0),
					new SqlParameter("@PMS_Machine",trueModel.PMS_Machine),
					new SqlParameter("@PMS_Mode",trueModel.PMS_Mode),
					new SqlParameter("@PMS_IsRevisedEdition",trueModel.PMS_IsRevisedEdition),
					new SqlParameter("@PMS_IsColorSamples",trueModel.PMS_IsColorSamples),
					new SqlParameter("@PMS_CTP",trueModel.PMS_CTP),
					new SqlParameter("@PMS_Film",trueModel.PMS_Film),
					new SqlParameter("@PMS_PSBan",trueModel.PMS_PSBan),
					new SqlParameter("@PMS_ChromaticNumber",trueModel.PMS_ChromaticNumber),
					new SqlParameter("@PMS_CompletionTime",trueModel.PMS_CompletionTime),
					new SqlParameter("@PMS_TotalPrice",trueModel.PMS_TotalPrice ?? 0),
					new SqlParameter("@PMS_Collection",trueModel.PMS_Collection ?? 0),
					new SqlParameter("@PMS_AccountsReceivable",trueModel.PMS_AccountsReceivable ?? 0),
					new SqlParameter("@PMS_Remarks",trueModel.PMS_Remarks),
					new SqlParameter("@PMS_IsPrint",trueModel.PMS_IsPrint ?? 0),
					new SqlParameter("@PMS_CustomsName",trueModel.PMS_CustomsName),
					new SqlParameter("@PMS_Title",trueModel.PMS_Title),
					new SqlParameter("@LastUpdateTime",trueModel.LastUpdateTime),
					new SqlParameter("@Operator",trueModel.Operator) ,
                    new SqlParameter("@PMS_OldNum",trueModel.PMS_OldNum) ,
                    new SqlParameter("@PMS_OldId",trueModel.PMS_OldId) ,
                    new SqlParameter("@PMS_PaperSource",trueModel.PMS_PaperSource) ,
                    new SqlParameter("@PMS_PaperNameType",trueModel.PMS_PaperNameType ?? 0) ,
                    new SqlParameter("@PMS_PaperSpecType",trueModel.PMS_PaperSpecType ?? 0) ,
                    new SqlParameter("@PMS_PlateSource",trueModel.PMS_PlateSource ?? 0) ,
                    new SqlParameter("@PMS_CTPSpecType",trueModel.PMS_CTPSpecType ?? 0) ,
                    new SqlParameter("@PMS_FilmType",trueModel.PMS_FilmType ?? 0) ,
                    new SqlParameter("@PMS_CTPCount",trueModel.PMS_CTPCount ?? 0) ,
                    new SqlParameter("@PMS_PSCount",trueModel.PMS_PSCount ?? 0),
                    new SqlParameter("@PMS_PaperNameTypeName",trueModel.PMS_PaperNameTypeName??""),
                    new SqlParameter("@PMS_PaperSpecTypeName",trueModel.PMS_PaperSpecTypeName??""),
                    new SqlParameter("@PMS_PlateSourceName",trueModel.PMS_PlateSourceName??""),
                    new SqlParameter("@PMS_CTPSpecTypeName",trueModel.PMS_CTPSpecTypeName??""),
                    new SqlParameter("@PMS_FilmTypeName",trueModel.PMS_FilmTypeName??"")
            };
            try
            {
                _dataBase.Query("sp_EC_MergerSingle_Insert", CommandType.StoredProcedure, sqlParms.ToArray<SqlParameter>());
                trueModel.Keyid = (int)sqlParms[0].Value;
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return true;
        }

        /// <summary>
        /// 修改
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public bool UpdateModel(Infrastructure.Domain.IAggregateRoot model)
        {
            Model.EC_MergerSingle trueModel = model as Model.EC_MergerSingle;
            if (trueModel == null)
            {
                return false;
            }
            IList<SqlParameter> sqlParms = new List<SqlParameter>()
            {	    
                    new SqlParameter("@Keyid",trueModel.Keyid),
                    new SqlParameter("@Member_id",trueModel.Member_id),
					new SqlParameter("@PO_OrderId",trueModel.PO_OrderId),
					new SqlParameter("@PO_OrderNum",trueModel.PO_OrderNum),
					new SqlParameter("@PMS_OrderNum",trueModel.PMS_OrderNum),
					new SqlParameter("@PMS_OrderPeople",trueModel.PMS_OrderPeople),
					new SqlParameter("@PMS_OrderTime",trueModel.PMS_OrderTime),
					new SqlParameter("@PMS_Emergency",trueModel.PMS_Emergency),
					new SqlParameter("@PMS_Printers",trueModel.PMS_Printers),
					new SqlParameter("@PMS_IsM",trueModel.PMS_IsM),
					new SqlParameter("@PMS_FactoryId",trueModel.PMS_FactoryId),
					new SqlParameter("@PMS_PaperName",trueModel.PMS_PaperName),
					new SqlParameter("@PMS_PaperSpecification",trueModel.PMS_PaperSpecification),
					new SqlParameter("@PMS_PaperCount",trueModel.PMS_PaperCount),
					new SqlParameter("@PMS_PaperPositive",trueModel.PMS_PaperPositive),
					new SqlParameter("@PMS_PaperConsume",trueModel.PMS_PaperConsume),
					new SqlParameter("@PMS_Machine",trueModel.PMS_Machine),
					new SqlParameter("@PMS_Mode",trueModel.PMS_Mode),
					new SqlParameter("@PMS_IsRevisedEdition",trueModel.PMS_IsRevisedEdition),
					new SqlParameter("@PMS_IsColorSamples",trueModel.PMS_IsColorSamples),
					new SqlParameter("@PMS_CTP",trueModel.PMS_CTP),
					new SqlParameter("@PMS_Film",trueModel.PMS_Film),
					new SqlParameter("@PMS_PSBan",trueModel.PMS_PSBan),
					new SqlParameter("@PMS_ChromaticNumber",trueModel.PMS_ChromaticNumber),
					new SqlParameter("@PMS_CompletionTime",trueModel.PMS_CompletionTime),
					new SqlParameter("@PMS_TotalPrice",trueModel.PMS_TotalPrice),
					new SqlParameter("@PMS_Collection",trueModel.PMS_Collection),
					new SqlParameter("@PMS_AccountsReceivable",trueModel.PMS_AccountsReceivable),
					new SqlParameter("@PMS_Remarks",trueModel.PMS_Remarks),
					new SqlParameter("@PMS_IsPrint",trueModel.PMS_IsPrint),
					new SqlParameter("@PMS_CustomsName",trueModel.PMS_CustomsName),
					new SqlParameter("@PMS_Title",trueModel.PMS_Title),
					new SqlParameter("@LastUpdateTime",trueModel.LastUpdateTime),
					new SqlParameter("@Operator",trueModel.Operator) ,
                    new SqlParameter("@PMS_OldNum",trueModel.PMS_OldNum) ,
                    //new SqlParameter("@PMS_OldId",trueModel.PMS_OldId), 
                    new SqlParameter("@PMS_PaperSource",trueModel.PMS_PaperSource) ,
                    new SqlParameter("@PMS_PaperNameType",trueModel.PMS_PaperNameType) ,
                    new SqlParameter("@PMS_PaperSpecType",trueModel.PMS_PaperSpecType) ,
                    new SqlParameter("@PMS_PlateSource",trueModel.PMS_PlateSource) ,
                    new SqlParameter("@PMS_CTPSpecType",trueModel.PMS_CTPSpecType) ,
                    new SqlParameter("@PMS_FilmType",trueModel.PMS_FilmType) ,
                    new SqlParameter("@PMS_CTPCount",trueModel.PMS_CTPCount) ,
                    new SqlParameter("@PMS_PSCount",trueModel.PMS_PSCount),
                    new SqlParameter("@PMS_PaperNameTypeName",trueModel.PMS_PaperNameTypeName??""),
                    new SqlParameter("@PMS_PaperSpecTypeName",trueModel.PMS_PaperSpecTypeName??""),
                    new SqlParameter("@PMS_PlateSourceName",trueModel.PMS_PlateSourceName??""),
                    new SqlParameter("@PMS_CTPSpecTypeName",trueModel.PMS_CTPSpecTypeName??""),
                    new SqlParameter("@PMS_FilmTypeName",trueModel.PMS_FilmTypeName??"")
            };
            try
            {
                _dataBase.Query("sp_EC_MergerSingle_Update", CommandType.StoredProcedure, sqlParms.ToArray<SqlParameter>());
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return true;
        }

        /// <summary>
        /// 删除
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        public bool DeleteModel(Infrastructure.Domain.IAggregateRoot model)
        {
            Model.EC_MergerSingle trueModel = model as Model.EC_MergerSingle;
            if (trueModel == null)
            {
                return false;
            }
            IList<SqlParameter> sqlParms = new List<SqlParameter>()
            {
                	new SqlParameter("@Keyid",trueModel.Keyid)
            };
            try
            {
                _dataBase.Query("sp_EC_MergerSingle_DeleteRow", CommandType.StoredProcedure, sqlParms.ToArray<SqlParameter>());
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return true;
        }

        /// <summary>
        /// 分页查询
        /// </summary>
        /// <param name="query"></param>
        /// <param name="pagination"></param>
        /// <returns></returns>
        public IEnumerable<Model.EC_MergerSingle> SelectModelPage(Infrastructure.Query.Query query, Infrastructure.Query.Pagination pagination)
        {
            throw new NotImplementedException();
        }

        /// <summary>
        /// 单个查询
        /// </summary>
        /// <param name="query"></param>
        /// <returns></returns>
        public IEnumerable<Model.EC_MergerSingle> SelectAllModel(Infrastructure.Query.Query query)
        {
            throw new NotImplementedException();
        }

        /// <summary>
        /// 根据编号获得信息
        /// </summary>
        /// <param name="Keyid"></param>
        /// <returns></returns>
        public EC_MergerSingle GetModelByKeyid(int? Keyid)
        {
            if (Keyid == null)
                return null;//错误数据返会空 

            IList<EC_MergerSingle> result = _dataBase.SelectModel<EC_MergerSingle>("*", "EC_MergerSingle", string.Format(" Keyid='{0}'", Keyid)) as IList<EC_MergerSingle>;//执行查询

            return (null == result || result.Count == 0) ? null : result[0];//返回结果
        }

        /// <summary>
        /// 根据订单编号获得信息
        /// </summary>
        /// <param name="OrderId"></param>
        /// <returns></returns>
        public EC_MergerSingle GetModelByOrderId(int? OrderId)
        {
            if (OrderId == null)
                return null;//错误数据返会空 

            IList<EC_MergerSingle> result = _dataBase.SelectModel<EC_MergerSingle>("*", "EC_MergerSingle", string.Format(" PO_OrderId='{0}'", OrderId)) as IList<EC_MergerSingle>;//执行查询

            return (null == result || result.Count == 0) ? null : result[0];//返回结果
        }

        /// <summary>
        /// 根据编号获得子订单信息
        /// </summary>
        /// <param name="Keyid"></param>
        /// <returns></returns>
        public IEnumerable<Model.EC_MergerOrders> GetEC_MergerOrdersListByKeyid(int? Keyid)
        {
            try
            {
                if (Keyid == null)
                    return null;//错误数据返会空 

                IList<EC_MergerOrders> result = _dataBase.SelectModel<EC_MergerOrders>("*", "EC_MergerOrders", string.Format(" MergerId='{0}'", Keyid)) as IList<EC_MergerOrders>;//执行查询

                return result;//返回结果
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

        /// <summary>
        /// 根据会员编号获取最新合版施工单号
        /// </summary>
        /// <param name="Memberid">会员编号</param>
        /// <returns></returns>
        public string GetPMS_OrderNum(Guid Memberid)
        {
            if (Memberid == null)
                return null;//错误数据返会空 

            string NumberHead = DateTime.Now.ToString("yyyyMMdd");
            string NumberFoot = "001";
            try
            {
                IList<EC_MergerSingle> result = _dataBase.SelectModel<EC_MergerSingle>("*", "EC_MergerSingle", string.Format(" Member_Id='{0}' and PMS_OrderNum like '{1}%'", Memberid, NumberHead)) as IList<EC_MergerSingle>;//执行查询
                if (result != null && result.Count > 0)
                {
                    NumberFoot = (int.Parse(result.Max(x => x.PMS_OrderNum).Substring(8, 3)) + 1).ToString("000");
                }  
                else
                    NumberFoot = "001";
            }
            catch (Exception ex)
            {
                NumberFoot = "001";
            }
            return NumberHead + NumberFoot;
        }

        /// <summary>
        /// 新增合版施工单
        /// </summary>
        /// <param name="m_EC_OrderOperateList"></param>
        /// <param name="m_EC_MergerSingle"></param>
        /// <param name="m_EC_MergerOrdersList"></param>
        /// <param name="IsOut"></param>
        /// <param name="m_OA_OrderWorkListRelation_new"></param>
        /// <param name="orderBasic"></param>
        /// <param name="acceptWayByOrder"></param>
        /// <param name="orderPrintParameter"></param>
        /// <returns></returns>
        public bool AddSpecialForums(List<EC_OrderOperate> m_EC_OrderOperateList, EC_MergerSingle m_EC_MergerSingle, List<EC_MergerOrders> m_EC_MergerOrdersList, bool IsOut, OA_OrderWorkListRelation m_OA_OrderWorkListRelation_new, EC_OrderBasic orderBasic, EC_AcceptWayByOrder acceptWayByOrder, EC_OrderPrintParameter orderPrintParameter, List<OA_OutOfStorage> m_OA_OutOfStorageList, string[] orderId)
        {
            try
            {
                bool result = true;
                EC_OrderBasicDAL dal_EC_OrderBasicDAL = new EC_OrderBasicDAL(_dataBase);
                EC_OrderExtendDAL dal_EC_OrderExtendDAL = new EC_OrderExtendDAL(_dataBase);
                OA_OrderWorkListRelationDAL dal_OA_OrderWorkListRelationDAL = new OA_OrderWorkListRelationDAL(_dataBase);
                EC_MergerOrdersDAL dal_EC_MergerOrdersDAL = new EC_MergerOrdersDAL(_dataBase);

                EC_OrderPrintParameterDAL _eC_OrderPrintParameterDAL = new EC_OrderPrintParameterDAL(_dataBase);
                Pay_TradingSingleDAL _pay_TradingSingleDAL = new Pay_TradingSingleDAL(_dataBase);
                EC_AcceptWayByOrderDAL _eC_AcceptWayByOrderDAL = new EC_AcceptWayByOrderDAL(_dataBase);
                EC_OrderOperateDAL _eC_OrderOperateDAL = new EC_OrderOperateDAL(_dataBase);

                EC_OrderExtend orderExtend = orderBasic.OrderExtend;
                Pay_TradingSingle tradingSingle = orderBasic.TradingSingle;
                int? NewOrderId = 0;

                using (TransactionScope t_TransactionScope = new TransactionScope())
                {
                    //如果是外协
                    if (IsOut)
                    {
                        if (result)
                        {
                            orderBasic.OutId = 0;
                            result = dal_EC_OrderBasicDAL.InserModel(orderBasic);
                        }
                        else
                            return false;

                        if (result)
                        {
                            NewOrderId = acceptWayByOrder.TargetId = tradingSingle.OrderId = orderExtend.Keyid = orderBasic.Keyid;//获取返回的订单唯一编号
                            result = dal_EC_OrderExtendDAL.InserModel(orderExtend);
                        }
                        else
                            return false;

                        if (result)
                        {
                            result = _eC_AcceptWayByOrderDAL.InserModel(acceptWayByOrder);
                        }
                        else
                            return false;

                        if (result)
                        {
                            result = _pay_TradingSingleDAL.InserModel(tradingSingle);
                        }
                        else
                            return false;

                        if (result)
                        {
                            result = _eC_OrderOperateDAL.InserModel(new EC_OrderOperate()
                              {
                                  OperateType = 1,
                                  Operator = orderBasic.Operator,
                                  OrderId = orderBasic.Keyid,
                                  Remark = string.Empty
                              });
                        }
                        else
                            return false;

                        if (result)
                        {

                            orderPrintParameter.OrderId = orderBasic.Keyid.Value;
                            result = _eC_OrderPrintParameterDAL.InserModel(orderPrintParameter);
                        }
                        else
                            return false;

                        if (orderId != null && orderId.Length > 0)
                        {
                            foreach (var item in orderId)
                            {
                                EC_OrderBasic item_EC_OrderBasic = dal_EC_OrderBasicDAL.SelectModelById(int.Parse(item));
                                if (item_EC_OrderBasic != null)
                                {
                                    item_EC_OrderBasic.OutId = -3;
                                    result = dal_EC_OrderBasicDAL.UpdateModel(item_EC_OrderBasic);
                                    if (!result)
                                    {
                                        return false;
                                    }
                                    else
                                    {
                                        //无操作
                                    }
                                }
                            }
                        }

                    }

                    if (result)
                    {
                        m_EC_MergerSingle.PO_OrderId = orderBasic.Keyid ?? 0;
                        m_EC_MergerSingle.PO_OrderNum = orderBasic.SellerOrderId ?? "";
                        result = InserModel(m_EC_MergerSingle);
                        if (result)
                        {
                            for (int i = 0; i < m_EC_OrderOperateList.Count; i++)
                            {
                                if (result)
                                {
                                    result = dal_EC_OrderExtendDAL.UpSurplusPrintNum(m_EC_OrderOperateList[i].OrderId, m_EC_MergerOrdersList[i].PO_Count, m_EC_MergerSingle.Operator);
                                    if (result)
                                    {
                                        result = dal_EC_OrderBasicDAL.UpdateOrderStateUnit(m_EC_OrderOperateList[i]);
                                        if (result)
                                        {
                                            m_EC_MergerOrdersList[i].MergerId = m_EC_MergerSingle.Keyid;
                                            result = dal_EC_MergerOrdersDAL.InserModel(m_EC_MergerOrdersList[i]);
                                        }
                                        else
                                        {
                                            return false;
                                        }
                                    }
                                    else
                                    {
                                        return false;
                                    }
                                }
                                else
                                {
                                    return false;
                                }
                            }
                        }
                    }
                    else
                    {
                        return false;
                    }

                    if (IsOut)
                    {
                        if (result)
                        {
                            m_OA_OrderWorkListRelation_new.OrderId = orderBasic.Keyid;
                            m_OA_OrderWorkListRelation_new.RelationTargetId = m_EC_MergerSingle.Keyid;
                            result = dal_OA_OrderWorkListRelationDAL.InserModel(m_OA_OrderWorkListRelation_new);
                        }
                        else
                            return false;
                    }
                    OA_OutOfStorageDAL dal_OA_OutOfStorageDAL = new OA_OutOfStorageDAL();
                    if (result)
                    {
                        foreach (var m_OA_OutOfStorage in m_OA_OutOfStorageList)
                        {
                            m_OA_OutOfStorage.Remark = string.Format("<span class='a_under' title='点击查看施工单详情' onclick=\"ViewModel_Merger('" + m_EC_MergerSingle.Keyid + "')\">合版：" + m_EC_MergerSingle.PMS_OrderNum + "</span>");
                            dal_OA_OutOfStorageDAL.InserModel(m_OA_OutOfStorage);
                        }
                    }
                    if (result)
                    {
                        t_TransactionScope.Complete();
                    }
                    else
                        return false;
                }
                return result;
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

        /// <summary>
        /// 修改合版施工单
        /// </summary>
        /// <param name="m_EC_MergerSingle"></param>
        /// <param name="m_EC_MergerOrdersList"></param>
        /// <returns></returns>
        public bool UpdateSpecialForums(EC_MergerSingle m_EC_MergerSingle, List<EC_MergerOrders> m_EC_MergerOrdersList)
        {
            try
            {
                bool result = false;
                EC_MergerOrdersDAL dal_EC_MergerOrdersDAL = new EC_MergerOrdersDAL(_dataBase);

                List<EC_MergerOrders> m_EC_MergerOrdersList_Old = GetEC_MergerOrdersListByKeyid(m_EC_MergerSingle.Keyid) as List<EC_MergerOrders>;

                using (TransactionScope t_TransactionScope = new TransactionScope())
                {
                    result = UpdateModel(m_EC_MergerSingle);
                    if (result)
                    {
                        foreach (var m_EC_MergerOrders in m_EC_MergerOrdersList_Old)
                        {
                            if (result)
                            {
                                result = dal_EC_MergerOrdersDAL.DeleteModel(m_EC_MergerOrders);
                            }
                            else
                                return false;
                        }

                        foreach (var m_EC_MergerOrders in m_EC_MergerOrdersList)
                        {
                            if (result)
                            {
                                m_EC_MergerOrders.MergerId = m_EC_MergerSingle.Keyid;
                                result = dal_EC_MergerOrdersDAL.InserModel(m_EC_MergerOrders);
                            }
                            else
                                return false;
                        }
                        if (result)
                        {
                            t_TransactionScope.Complete();
                        }
                    }
                }
                return result;
            }
            catch (Exception ex)
            {
                throw ex;
            }

        }

        /// <summary>
        /// 分页查询
        /// </summary>
        /// <param name="pagination"></param>
        /// <param name="MemberId"></param>
        /// <returns></returns>
        public IEnumerable<Model.EC_MergerSingle> SelectModelPage(Infrastructure.Query.Pagination pagination, Guid MemberId, string PrintName, string CustomName, string PSO_OrderNum, DateTime? beginTime, DateTime? endTime, string PMS_Printers, string PO_OrderNum, string PayStates, string PrintStates)
        {
            try
            {

                string Condition = " 1=1 ";

                if (MemberId != Guid.Empty)
                {
                    Condition += " and Member_id = '" + MemberId + "'";
                }

                if (beginTime.HasValue)
                {
                    Condition += string.Format(" and CAST(PMS_OrderTime AS DATE) >='{0}'", beginTime);
                }

                if (endTime.HasValue)
                {
                    Condition += string.Format(" and CAST(PMS_OrderTime AS DATE) <='{0}'", endTime);
                }
                if (!string.IsNullOrEmpty(CustomName))
                {
                    Condition += string.Format(" and PMS_CustomsName like '%{0}%'", CustomName);
                }
                if (!string.IsNullOrEmpty(PrintName))
                {
                    Condition += string.Format(" and PMS_Title like '%{0}%'", PrintName);
                }
                if (!string.IsNullOrEmpty(PSO_OrderNum))
                {
                    Condition += string.Format(" and PMS_OrderNum like '%{0}%'", PSO_OrderNum);
                }
                if (!string.IsNullOrEmpty(PMS_Printers))
                {
                    Condition += string.Format(" and PMS_Printers = '{0}'", PMS_Printers);
                }
                if (!string.IsNullOrEmpty(PO_OrderNum))
                {
                    Condition += string.Format(" and PO_OrderNum like '%{0}%'", PO_OrderNum);
                }
                if (!string.IsNullOrEmpty(PayStates))
                {
                    Condition += string.Format(" and PMS_IsPay = {0}", Convert.ToInt32(PayStates));
                }
                if (!string.IsNullOrEmpty(PrintStates))
                {
                    Condition += string.Format(" and PMS_IsPrint = {0}", Convert.ToInt32(PrintStates));
                }
                return _dataBase.SelectModelPage<Model.EC_MergerSingle>(pagination, " *", " EC_MergerSingle", " PMS_OrderNum DESC ", " PMS_OrderNum DESC ", Condition);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

        /// <summary>
        /// 根据原订单号和类型获取订单和工单关系
        /// </summary>
        /// <param name="OrderId"></param>
        /// <param name="TypeId"></param>
        /// <returns></returns>
        public OA_OrderWorkListRelation GetOA_OrderWorkListRelationByOrderIdAndTypeId(int? OrderId, int? TypeId)
        {
            try
            {
                IList<OA_OrderWorkListRelation> result = _dataBase.SelectModel<OA_OrderWorkListRelation>(" * ", " OA_OrderWorkListRelation ", string.Format(" OrderId={0} and RelationTypeId={1} ", OrderId, TypeId)) as IList<OA_OrderWorkListRelation>;
                return null == result || result.Count < 1 ? null : result[0];
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
    }
}