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

namespace CY.SQLDAL
{
    /// <summary>
    /// 纸张相关操作--SQL数据库操作
    /// </summary>
    public class PaperInfoDAL : IPaperInfoDAL
    {
        private Database _dataBase = null;
        public PaperInfoDAL()
        {
            _dataBase = new Database();
        }

        public PaperInfoDAL(Database dataBase)
        {
            _dataBase = dataBase;
        }

        /// <summary>
        /// 新增一条纸张记录
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public bool InserModel(Infrastructure.Domain.IAggregateRoot model)
        {
            Model.SysInquiry_PaperInfo trueModel = model as Model.SysInquiry_PaperInfo;
            if (trueModel == null)
            {
                return false;
            }
            SqlParameter[] parameters = {
					new SqlParameter("@PapeId", SqlDbType.Int,4),
					new SqlParameter("@PaperName", SqlDbType.VarChar,50),
					new SqlParameter("@GramWeight", SqlDbType.Int,4),
                    new SqlParameter("@DefaultBrandId",SqlDbType.Int,4),
					new SqlParameter("@Status", SqlDbType.Bit,1),
					new SqlParameter("@Operater", SqlDbType.VarChar,20),
					new SqlParameter("@OperateTime", SqlDbType.DateTime),
					new SqlParameter("@LastUpdateTime", SqlDbType.DateTime),
                    new SqlParameter("@OrderNum", SqlDbType.Int,4),
                    new SqlParameter("@PaperTypeId", SqlDbType.Int,4)
            };
            parameters[0].Value = trueModel.PapeId;
            parameters[1].Value = trueModel.PaperName;
            parameters[2].Value = trueModel.GramWeight;
            parameters[3].Value = DBNull.Value;
            parameters[4].Value = trueModel.Status;
            parameters[5].Value = trueModel.Operater;
            parameters[6].Value = trueModel.OperateTime;
            parameters[7].Value = trueModel.LastUpdateTime;
            parameters[8].Value = trueModel.OrderNum;
            parameters[9].Value = trueModel.PaperTypeId;
            try
            {
                _dataBase.Query("SysInquiry_PaperInfo_ADD", CommandType.StoredProcedure, parameters);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return true;
        }

        ///// <summary>
        ///// 保存纸张的品牌列表
        ///// </summary>
        //public bool SaveBrandListByPaper(SysInquiry_BrandListByPaper brandPaperModel,SysInquiry_PaperInfo paperModel)
        //{
        //    bool isSuccess = true;
        //    isSuccess = DeleteBrandListByPaper(brandPaperModel);
        //    isSuccess = InsertBrandByPaper(brandPaperModel);
        //    if (isSuccess)
        //    {
        //        if (paperModel != null)
        //        {
        //            isSuccess = UpdateDefaultBrand(paperModel);
        //        }
        //    }         
        //    return isSuccess;
        //}
        /// <summary>
        /// 新增纸张的品牌
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public bool InsertBrandByPaper(SysInquiry_BrandListByPaper model, SysInquiry_PaperInfo paperModel)
        {
            bool isSuccess = true;
            if (model == null)
            {
                isSuccess = false;
            }
            else
            {
                SqlParameter[] parameters = {
					new SqlParameter("@PaperId", SqlDbType.Int,4),
					new SqlParameter("@BrandId", SqlDbType.Int,4)};
                parameters[0].Value = model.PaperId;
                parameters[1].Value = model.BrandId;
                try
                {
                    _dataBase.Query("SysInquiry_BrandListByPaper_ADD", CommandType.StoredProcedure, parameters);
                }
                catch (Exception ex)
                {
                    throw ex;
                }
            }
            if (isSuccess)
            {
                if (paperModel != null)
                {
                    isSuccess = UpdateDefaultBrand(paperModel);
                }
            }
            return true;
        }

        /// <summary>
        /// 修改纸张的品牌
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public bool UpdateBrandByPaper(SysInquiry_BrandListByPaper model, SysInquiry_PaperInfo paperModel,SysInquiry_PaperInfo orPaperModel)
        {
            bool isSuccess = true;
            if (model == null)
            {
                isSuccess = false;
            }
            else
            {
                SqlParameter[] parameters = {
					new SqlParameter("@PaperId", SqlDbType.Int,4),
					new SqlParameter("@BrandId", SqlDbType.Int,4)};
                parameters[0].Value = model.PaperId;
                parameters[1].Value = model.BrandId;
                try
                {
                    _dataBase.Query("SysInquiry_BrandListByPaper_Update", CommandType.StoredProcedure, parameters);
                }
                catch (Exception ex)
                {
                    throw ex;
                }
            }
            if (isSuccess)
            {
                if (paperModel != null)
                {
                    isSuccess = UpdateDefaultBrand(paperModel);
                }
                if (orPaperModel != null)
                {
                    isSuccess = UpdateDefaultBrand(orPaperModel);
                }
            }
            return true;
        }


        /// <summary>
        /// 判断是否存在
        /// </summary>
        /// <param name="model"></param>
        public bool isExists(SysInquiry_BrandListByPaper model)
        {
            string condition = string.Empty;
            condition = " PaperId=" + model.PaperId + " and  BrandId=" + model.BrandId + " ";
            IList<SysInquiry_BrandListByPaper> result = _dataBase.SelectModel<SysInquiry_BrandListByPaper>("*", "SysInquiry_BrandListByPaper", condition);
            if (result != null && result.Count > 0)
                return true;
            else
                return false;
        }

        /// <summary>
        /// 删除纸张的品牌
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public bool DeleteBrandListByPaper(SysInquiry_BrandListByPaper model)
        {
            SqlParameter[] parameters = {
					new SqlParameter("@PaperId", SqlDbType.Int,4),
					new SqlParameter("@BrandId", SqlDbType.Int,4)};
            parameters[0].Value = model.PaperId;
            parameters[1].Value = model.BrandId;
            try
            {
                _dataBase.Query("SysInquiry_BrandListByPaper_Delete", CommandType.StoredProcedure, parameters);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return true;
        }

        /// <summary>
        /// 修改一条纸张信息
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public bool UpdateModel(Infrastructure.Domain.IAggregateRoot model)
        {
            Model.SysInquiry_PaperInfo trueModel = model as Model.SysInquiry_PaperInfo;
            if (trueModel == null)
            {
                return false;
            }
            SqlParameter[] parameters = {
					new SqlParameter("@PapeId", SqlDbType.Int,4),
					new SqlParameter("@PaperName", SqlDbType.VarChar,50),
                    new SqlParameter("@GramWeight", SqlDbType.Int,4),
                    new SqlParameter("@DefaultBrandId",SqlDbType.Int,4),
					new SqlParameter("@Status", SqlDbType.Bit,1),
					new SqlParameter("@Operater", SqlDbType.VarChar,20),
					new SqlParameter("@OperateTime", SqlDbType.DateTime),
					new SqlParameter("@LastUpdateTime", SqlDbType.DateTime),
                    new SqlParameter("@OrderNum", SqlDbType.Int,4),
                    new SqlParameter("@PaperTypeId", SqlDbType.Int,4)
            };
            parameters[0].Value = trueModel.PapeId;
            parameters[1].Value = trueModel.PaperName;
            parameters[2].Value = trueModel.GramWeight;
            parameters[3].Value = DBNull.Value;
            parameters[4].Value = trueModel.Status;
            parameters[5].Value = trueModel.Operater;
            parameters[6].Value = trueModel.OperateTime;
            parameters[7].Value = trueModel.LastUpdateTime;
            parameters[8].Value = trueModel.OrderNum;
            parameters[9].Value = trueModel.PaperTypeId;
            try
            {
                _dataBase.Query("SysInquiry_PaperInfo_Update", CommandType.StoredProcedure, parameters);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return true;
        }

        /// <summary>
        /// 修改纸张状态
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public bool UpdatePaperStatus(SysInquiry_PaperInfo model)
        {

            if (model == null)
            {
                return true;
            }
            SqlParameter[] parameters = {
					new SqlParameter("@Status", SqlDbType.Bit,1),
                    new SqlParameter("@PaperTypeId", SqlDbType.Int,4)
            };
            parameters[0].Value = model.Status;
            parameters[1].Value = model.PaperTypeId;
            try
            {
                _dataBase.Query("SysInquiry_PaperInfo_Update2", CommandType.StoredProcedure, parameters);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return true;
        }

        /// <summary>
        /// 修改纸张的默认品牌
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public bool UpdateDefaultBrand(SysInquiry_PaperInfo model)
        {
            if (model == null)
                return true;
            SqlParameter dfaultBrandIdPar = null;
            if (model.DefaultBrandId == null)
            {
                dfaultBrandIdPar = new SqlParameter("@DefaultBrandId", DBNull.Value);
            }
            else
            {
                dfaultBrandIdPar = new SqlParameter("@DefaultBrandId", model.DefaultBrandId.Value);
            }
            SqlParameter[] parameters = {
					new SqlParameter("@PapeId", SqlDbType.Int,4),
                    dfaultBrandIdPar
            };
            parameters[0].Value = model.PapeId;
            try
            {
                _dataBase.Query("SysInquiry_PaperInfo_Update1", CommandType.StoredProcedure, parameters);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return true;
        }

        /// <summary>
        /// 删除一条纸张信息
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public bool DeleteModel(Infrastructure.Domain.IAggregateRoot model)
        {
            Model.SysInquiry_PaperInfo trueModel = model as Model.SysInquiry_PaperInfo;
            if (trueModel == null)
            {
                return false;
            }
            SqlParameter[] parameters = {
					new SqlParameter("@KeyId", SqlDbType.Int,4)
                                        };
            parameters[0].Value = trueModel.KeyId;
            try
            {
                _dataBase.Query("SysInquiry_PaperInfo_Delete", CommandType.StoredProcedure, parameters);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return true;
        }

        /// <summary>
        /// 分页获取纸张列表
        /// </summary>
        /// <param name="paperName">品牌名称</param>
        /// <param name="pa">分页参数</param>
        /// <returns></returns>
        public IEnumerable<Model.SysInquiry_PaperInfo> GetPaperListByPaging(string paperName,int paperTypeId,string stauts,Infrastructure.Query.Pagination pa)
        {
            string selectTarget = " t.PapeId,t.PaperTypeOrderNum,t.OrderNum ";
            string fromSouce = string.Empty;
            fromSouce = "( SELECT DISTINCT a.PapeId,b.OrderNum AS PaperTypeOrderNum,a.OrderNum FROM SysInquiry_PaperInfo a INNER JOIN dbo.SysInquiry_PaperType b ON a.PaperTypeId=b.KeyId where a.PapeId!=0 ";
            if (!string.IsNullOrEmpty(paperName))
            {
                fromSouce += " and  a.PaperName LIKE '%" + paperName + "%' ";
            }
            if (paperTypeId != -1)
            {
                fromSouce += " and  a.PaperTypeId=" + paperTypeId;
            }
            if (!string.IsNullOrEmpty(stauts))
            {
                fromSouce += " and a.Status='" + stauts + "'";
            }
            fromSouce += " ) AS t ";
            return _dataBase.SelectModelPage<Model.SysInquiry_PaperInfo>(pa, selectTarget, fromSouce, "t.PaperTypeOrderNum,t.OrderNum", "PaperTypeOrderNum,OrderNum",string.Empty);
        }

        /// <summary>
        /// 根据paperId获取纸张信息
        /// </summary>
        /// <param name="paperId"></param>
        /// <returns></returns>
        public IEnumerable<Model.SysInquiry_PaperInfo> GetPaperList(int paperId)
        {
            string selectTarget = " a.KeyId,a.PapeId,a.DefaultBrandId,b.BrandName AS DefaultBrandName,a.GramWeight,a.PaperName,a.Status,a.PaperTypeId,a.OrderNum,c.PaperTypeName";
            string fromSouce = " SysInquiry_PaperInfo a left JOIN dbo.SysInquiry_BrandInfo b ON a.DefaultBrandId=b.KeyId left join SysInquiry_PaperType c on a.PaperTypeId=c.KeyId ";
            string condition = string.Empty;
            condition = " PapeId=" + paperId;
            IList<Model.SysInquiry_PaperInfo> result = _dataBase.SelectModel<Model.SysInquiry_PaperInfo>(selectTarget, fromSouce , condition);
            return result;
        }

        /// <summary>
        /// 根据paperId获取其对应的品牌列表
        /// </summary>
        /// <param name="paperId"></param>
        /// <returns></returns>
        public IEnumerable<SysInquiry_BrandInfo> GetBrandInfoListByPaper(int paperId)
        {
            string selectTarget = "b.*";
            string fromSouce = "dbo.SysInquiry_BrandListByPaper a INNER JOIN dbo.SysInquiry_BrandInfo b ON a.BrandId=b.KeyId ";
            string condition = string.Empty;
            condition = " a.PaperId=" + paperId + " ORDER BY b.OrderNum";
            IList<Model.SysInquiry_BrandInfo> result = _dataBase.SelectModel<Model.SysInquiry_BrandInfo>(selectTarget, fromSouce, condition);
            return result;
        }

        /// <summary>
        /// 判断是否有相同的纸扎名称
        /// </summary>
        /// <param name="peperName"></param>
        /// <returns></returns>
        public bool IsExistspeperName(string peperName)
        {
            string condition = string.Empty;
            condition = " PaperName='" + peperName + "'";
            IList<SysInquiry_PaperInfo> result = _dataBase.SelectModel<SysInquiry_PaperInfo>("*", "SysInquiry_PaperInfo", condition);
            if (result != null && result.Count != 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }

        /// <summary>
        /// 获取最新的纸张编号
        /// </summary>
        /// <returns></returns>
        public int GetNewPaperId()
        {
            string selColumns = " MAX(PapeId) as papeNum ";
            string tableSql = " SysInquiry_PaperInfo";
            DataTable result = _dataBase.SelectModel(selColumns, tableSql, string.Empty);
            int newPaperId = 0;
            if (result != null && result.Rows.Count > 0)
            {
                string resultStr = result.Rows[0][0].ToString();
                if (string.IsNullOrEmpty(resultStr))
                {
                    newPaperId = 1;
                }
                else
                {
                    newPaperId = Convert.ToInt32(resultStr) + 1;
                }
            }
            else
            {
                newPaperId = 1;
            }
            return newPaperId;
        }

        /// <summary>
        /// 新增纸张
        /// </summary>
        /// <param name="modelList"></param>
        /// <returns></returns>
        public bool InsertPaper(IList<SysInquiry_PaperInfo> modelList, IList<SysInquiry_BrandListByPaper> brandList)
        {
            bool isSuccess = true;
            using (TransactionScope scope = new TransactionScope())
            {
                foreach (SysInquiry_PaperInfo model in modelList)
                {

                    isSuccess = InserModel(model);
                    if (!isSuccess)
                        break;
                }
                //isSuccess = SaveBrandListByPaper(brandList);
                if (isSuccess)
                    scope.Complete();
            }
            return isSuccess;
        }

        /// <summary>
        /// 修改纸张
        /// </summary>
        /// <param name="modelList"></param>
        /// <returns></returns>
        public bool UpdatePaper(IList<SysInquiry_PaperInfo> modelList, IList<SysInquiry_BrandListByPaper> brandList)
        {
            if (modelList == null || modelList.Count == 0)
                return false;
            int paperId = modelList[0].PapeId;
            List<SysInquiry_PaperInfo> allPaperList = GetPaperList(paperId).ToList<SysInquiry_PaperInfo>();
            List<SysInquiry_PaperInfo> insertPaperList = new List<SysInquiry_PaperInfo>();
            List<SysInquiry_PaperInfo> updatePaperList = new List<SysInquiry_PaperInfo>();
            List<SysInquiry_PaperInfo> deletePaperList = new List<SysInquiry_PaperInfo>();

            foreach (SysInquiry_PaperInfo obj in modelList)
            {
                if (!isExists(allPaperList, obj.GramWeight))
                    insertPaperList.Add(obj);
                else
                    updatePaperList.Add(obj);
            }

            foreach (SysInquiry_PaperInfo obj in allPaperList)
            {
                if (!isExists(modelList.ToList<SysInquiry_PaperInfo>(), obj.GramWeight))
                    deletePaperList.Add(obj);
            }

            bool isSuccess = true;
            using (TransactionScope scope = new TransactionScope())
            {
                foreach (SysInquiry_PaperInfo model in insertPaperList)
                {
                    isSuccess = InserModel(model);
                    if (!isSuccess)
                        break;
                }
                if (isSuccess)
                {
                    foreach (SysInquiry_PaperInfo model in updatePaperList)
                    {
                        isSuccess = UpdateModel(model);
                        if (!isSuccess)
                            break;
                    }
                }
                if (isSuccess)
                {
                    foreach (SysInquiry_PaperInfo model in deletePaperList)
                    {
                        isSuccess = DeleteModel(model);
                        if (!isSuccess)
                            break;
                    }
                }
                //if (isSuccess)
                //{
                //    isSuccess = SaveBrandListByPaper(brandList);
                //}
                if (isSuccess)
                    scope.Complete();
            }
            return isSuccess;
        }

        /// <summary>
        /// 判断是否存在
        /// </summary>
        /// <returns></returns>
        private bool isExists(List<SysInquiry_PaperInfo> paperList, int gramWeight)
        {
            foreach (SysInquiry_PaperInfo model in paperList)
            {
                if (model.GramWeight == gramWeight)
                    return true;
            }
            return false;
        }

        /// <summary>
        /// 获取有效的纸张列表(不包括自带纸)
        /// </summary>
        /// <returns></returns>
        public IEnumerable<SysInquiry_PaperInfo> GetPaperList()
        {
            string selectTarget = " a.*,b.PaperTypeName ";
            string fromSouce = " SysInquiry_PaperInfo a INNER JOIN SysInquiry_PaperType b ON a.PaperTypeId=b.KeyId  ";
            string condition = "  a.Status='true' and a.papeId<>0 ORDER BY b.OrderNum,a.OrderNum ";
            IList<Model.SysInquiry_PaperInfo> result = _dataBase.SelectModel<Model.SysInquiry_PaperInfo>(selectTarget, fromSouce, condition);
            return result;
        }

        /// <summary>
        /// 获取纸张类型下的所有有效纸张
        /// </summary>
        /// <param name="paperTypeId"></param>
        /// <returns></returns>
        public IEnumerable<SysInquiry_PaperInfo> GetPaperListByPaperType(int paperTypeId)
        {
            string condition = string.Empty;
            condition = " PaperTypeId=" + paperTypeId + " and  Status='true' and papeId<>0  order by OrderNum";
            IList<Model.SysInquiry_PaperInfo> result = _dataBase.SelectModel<Model.SysInquiry_PaperInfo>(" DISTINCT PapeId,PaperName,OrderNum ", "SysInquiry_PaperInfo", condition);
            return result;
        }

        /// <summary>
        /// 获取有效的纸张列表(包括自带纸)
        /// </summary>
        /// <returns></returns>
        public IEnumerable<SysInquiry_PaperInfo> GetAllPaperList()
        {
            string condition = string.Empty;
            condition = " Status='true' order by OrderNum ";
            IList<Model.SysInquiry_PaperInfo> result = _dataBase.SelectModel<Model.SysInquiry_PaperInfo>("*", "SysInquiry_PaperInfo", condition);
            return result;
        }

        /// <summary>
        /// 根据纸张Id和品牌Id获取纸价列表
        /// </summary>
        /// <param name="paperId"></param>
        /// <param name="firmId"></param>
        /// <param name="customerId"></param>
        /// <returns></returns>
        public IEnumerable<Inquiry_PaperPriceInfo> GetAllPaperPriceList(int paperId, int brandId, Guid inquiryId)
        {
            string selectTarget = " a.GramWeight,ISNULL(PaperPrice,0) AS PaperPrice ";
            string fromSouce = " dbo.SysInquiry_PaperInfo a LEFT JOIN dbo.Inquiry_PaperPriceInfo b ON a.PapeId=b.PaperId and a.gramweight=b.gramweight AND b.BrandId=" + brandId + " and FirmId='" + inquiryId.ToString() + "'";
            string condition = "  a.PapeId=" + paperId+" order by a.GramWeight";
            IList<Model.Inquiry_PaperPriceInfo> result = _dataBase.SelectModel<Model.Inquiry_PaperPriceInfo>(selectTarget, fromSouce, condition);
            return result;
        }

        /// <summary>
        /// 根据纸张Id和品牌Id获取系统设置的纸价列表
        /// </summary>
        /// <param name="paperId"></param>
        /// <param name="brandId"></param>
        /// <returns></returns>
        private IEnumerable<Inquiry_PaperPriceInfo> GetAllPaperPriceListByAdmin(int paperId, int brandId)
        {
            string selectTarget = " a.GramWeight,ISNULL(PaperPrice,0) AS PaperPrice ";
            string fromSouce = " dbo.SysInquiry_PaperInfo a LEFT JOIN dbo.Inquiry_PaperPriceInfo b ON a.PapeId=b.PaperId and a.gramweight=b.gramweight AND b.BrandId=" + brandId + " and FirmId='" + UtilConst.AdminFirmId + "'";
            string condition = "  a.PapeId=" + paperId;
            IList<Model.Inquiry_PaperPriceInfo> result = _dataBase.SelectModel<Model.Inquiry_PaperPriceInfo>(selectTarget, fromSouce, condition);
            return result;
        }

        /// <summary>
        /// 根据纸张Id和品牌Id获取厂商设置的纸价列表
        /// </summary>
        /// <param name="paperId"></param>
        /// <param name="brandId"></param>
        /// <returns></returns>
        private IEnumerable<Inquiry_PaperPriceInfo> GetAllPaperPriceListByFirm(int paperId, int brandId, string firmId)
        {
            string selectTarget = " a.GramWeight,ISNULL(PaperPrice,0) AS PaperPrice ";
            string fromSouce = "  dbo.SysInquiry_PaperInfo a LEFT JOIN dbo.Inquiry_PaperPriceInfo b ON a.PapeId=b.PaperId and a.gramweight=b.gramweight AND b.BrandId=" + brandId;
            string condition = "  a.PapeId=" + paperId + " and b.FirmId='" + firmId + "' and b.CustomerId is null ";
            IList<Model.Inquiry_PaperPriceInfo> result = _dataBase.SelectModel<Model.Inquiry_PaperPriceInfo>(selectTarget, fromSouce, condition);
            return result;
        }

        /// <summary>
        /// 根据纸张Id和品牌Id获取厂商的客户设置的纸价列表
        /// </summary>
        /// <param name="paperId"></param>
        /// <param name="brandId"></param>
        /// <returns></returns>
        private IEnumerable<Inquiry_PaperPriceInfo> GetAllPaperPriceListByCustomer(int paperId, int brandId, string firmId, string customerId)
        {
            string selectTarget = " a.GramWeight,ISNULL(PaperPrice,0) AS PaperPrice ";
            string fromSouce = "  dbo.SysInquiry_PaperInfo a LEFT JOIN dbo.Inquiry_PaperPriceInfo b ON a.PapeId=b.PaperId and a.gramweight=b.gramweight AND b.BrandId=" + brandId;
            string condition = "  a.PapeId=" + paperId + " and b.FirmId='" + firmId + "' and b.CustomerId='" + customerId + "'";
            IList<Model.Inquiry_PaperPriceInfo> result = _dataBase.SelectModel<Model.Inquiry_PaperPriceInfo>(selectTarget, fromSouce, condition);
            return result;
        }


        /// <summary>
        /// 根据纸张Id和品牌ID保存纸价
        /// </summary>
        /// <param name="modelList"></param>
        /// <returns></returns>
        public bool SavePaperPrice(List<Inquiry_PaperPriceInfo> modelList, InquiryCondition inquiryCondition)
        {
            bool isSuccess = true;
            using (TransactionScope scope = new TransactionScope())
            {
                if (inquiryCondition.ActualFirmId != Guid.Parse(UtilConst.AdminFirmId))
                {
                    //执行复制全部询价参数数据
                    if (inquiryCondition.IsFirstSave())
                    {
                        new CommonInquiryHelper(_dataBase).CopyALLInquiryParameter(inquiryCondition);
                    }

                    foreach (Inquiry_PaperPriceInfo model in modelList)
                    {
                        isSuccess = UpdatePaperPriceModel(model);
                        if (!isSuccess)
                            break;
                    }
                }
                else
                {
                    foreach (Inquiry_PaperPriceInfo model in modelList)
                    {
                        isSuccess = SavePaperPriceByGramWeightValue(model);
                        if (!isSuccess)
                            break;
                    }
                }
                if (isSuccess)
                    scope.Complete();
            }
            return isSuccess;
        }

        /// <summary>
        /// 根据纸张Id和品牌ID,克重值保存纸价
        /// </summary>
        /// <param name="paperId"></param>
        /// <param name="brandId"></param>
        /// <param name="gramWeightValue"></param>
        /// <param name="paperPrice"></param>
        /// <param name="firmId"></param>
        /// <param name="customerId"></param>
        /// <returns></returns>
        private bool SavePaperPriceByGramWeightValue(Inquiry_PaperPriceInfo model)
        {
            bool isExits = IsExitsPaperPriceByGramWeightValue(model.PaperId, model.BrandId, model.GramWeight, model.PaperPrice, model.FirmId);
            if (isExits)
            {

                return UpdatePaperPriceModel(model);
            }
            else
            {
                return InsertPaperPriceModel(model);
            }
            return true;
        }

        /// <summary>
        /// 判断价格是否已存在
        /// </summary>
        /// <param name="paperId"></param>
        /// <param name="brandId"></param>
        /// <param name="gramWeightValue"></param>
        /// <param name="paperPrice"></param>
        /// <param name="firmId"></param>
        /// <param name="customerId"></param>
        /// <returns></returns>
        private bool IsExitsPaperPriceByGramWeightValue(int paperId, int brandId, int gramWeightValue, decimal paperPrice, Guid firmId)
        {
            string selectTarget = " KeyId ";
            string fromSouce = " Inquiry_PaperPriceInfo ";
            string condition = string.Empty;
            condition = " PaperId=" + paperId + " AND BrandId=" + brandId + " AND GramWeight=" + gramWeightValue + " AND FirmId='" + firmId + "'";
            IList<Model.Inquiry_PaperPriceInfo> result = _dataBase.SelectModel<Model.Inquiry_PaperPriceInfo>(selectTarget, fromSouce, condition);
            if (result == null || result.Count == 0)
                return false;
            else
                return true;
        }

        /// <summary>
        /// 新增纸价信息
        /// </summary>
        private bool InsertPaperPriceModel(Inquiry_PaperPriceInfo model)
        {
            Model.Inquiry_PaperPriceInfo trueModel = model as Model.Inquiry_PaperPriceInfo;
            if (trueModel == null)
            {
                return false;
            }
            SqlParameter[] parameters = {
                    new SqlParameter("@FirmId", SqlDbType.UniqueIdentifier,16),
                    new SqlParameter("@PaperId", SqlDbType.Int,4),
                    new SqlParameter("@GramWeight", SqlDbType.Int,4),
                    new SqlParameter("@BrandId", SqlDbType.Int,4),
                    new SqlParameter("@PaperPrice", SqlDbType.Money,8),
                    new SqlParameter("@Unit", SqlDbType.VarChar,10),
                    new SqlParameter("@Status", SqlDbType.Bit,1),
                    new SqlParameter("@Operater", SqlDbType.VarChar,20),
                    new SqlParameter("@OperateTime", SqlDbType.DateTime),
                    new SqlParameter("@LastUpdateTime", SqlDbType.DateTime)
            };
            parameters[0].Value = trueModel.FirmId;
            parameters[1].Value = trueModel.PaperId;
            parameters[2].Value = trueModel.GramWeight;
            parameters[3].Value = trueModel.BrandId;
            parameters[4].Value = trueModel.PaperPrice;
            parameters[5].Value = trueModel.Unit;
            parameters[6].Value = trueModel.Status;
            parameters[7].Value = trueModel.Operater;
            parameters[8].Value = trueModel.OperateTime;
            parameters[9].Value = trueModel.LastUpdateTime;
            try
            {
                _dataBase.Query("Inquiry_PaperPriceInfo_ADD", CommandType.StoredProcedure, parameters);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return true;
        }

        /// <summary>
        /// 修改纸张价格
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        private bool UpdatePaperPriceModel(Inquiry_PaperPriceInfo model)
        {
            Model.Inquiry_PaperPriceInfo trueModel = model as Model.Inquiry_PaperPriceInfo;
            if (trueModel == null)
            {
                return false;
            }
            SqlParameter[] parameters = {
					new SqlParameter("@FirmId", SqlDbType.UniqueIdentifier,16),
					new SqlParameter("@PaperId", SqlDbType.Int,4),
					new SqlParameter("@GramWeight", SqlDbType.Int,4),
					new SqlParameter("@BrandId", SqlDbType.Int,4),
					new SqlParameter("@PaperPrice", SqlDbType.Money,8),
					new SqlParameter("@Operater", SqlDbType.VarChar,20),
					new SqlParameter("@LastUpdateTime", SqlDbType.DateTime)
            };
            parameters[0].Value = trueModel.FirmId;
            parameters[1].Value = trueModel.PaperId;
            parameters[2].Value = trueModel.GramWeight;
            parameters[3].Value = trueModel.BrandId;
            parameters[4].Value = trueModel.PaperPrice;
            parameters[5].Value = trueModel.Operater;
            parameters[6].Value = trueModel.LastUpdateTime;
            try
            {
                _dataBase.Query("Inquiry_PaperPriceInfo_Update", CommandType.StoredProcedure, parameters);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return true;
        }

        public decimal GetTonsOfPrice(int paperId, int gramWeight, int brandId, Guid inquiryId)
        {
            decimal tonsOfPrice = 0;
            string selectTarget = " PaperPrice ";
            string fromSouce = " Inquiry_PaperPriceInfo ";
            string condition = string.Empty;
            condition = " PaperId=" + paperId + " AND BrandId=" + brandId + " AND GramWeight=" + gramWeight + " AND FirmId='" + inquiryId.ToString() + "'";
            IList<Model.Inquiry_PaperPriceInfo> result = _dataBase.SelectModel<Model.Inquiry_PaperPriceInfo>(selectTarget, fromSouce, condition);
            if (result != null && result.Count > 0)
            {
                tonsOfPrice = result[0].PaperPrice;
            }
            return tonsOfPrice;
        }


        /// <summary>
        /// 获取纸张的品牌列表，第一个是默认品牌
        /// </summary>
        /// <param name="paperId"></param>
        /// <returns></returns>
        public IList<SysInquiry_BrandInfo> GetBrandInfoByPaper(int paperId)
        {
            IList<SysInquiry_BrandInfo> resultList = new List<SysInquiry_BrandInfo>();
            IList<Model.SysInquiry_PaperInfo> paperList = GetPaperList(paperId).ToList<SysInquiry_PaperInfo>();
            int defaultBrandId = -1;
            if (paperList != null && paperList.Count()>0)
            {
                if (paperList[0].DefaultBrandId.HasValue)
                {
                    defaultBrandId = paperList[0].DefaultBrandId.Value;
                    BrandInfoDAL _brandInfoDAL = new BrandInfoDAL(_dataBase);
                    SysInquiry_BrandInfo defaultModel = _brandInfoDAL.SelectModelByKey(defaultBrandId);
                    if (defaultModel!=null)
                    resultList.Add(defaultModel);
                }
            }
            string selectTarget = " b.* ";
            string fromSouce = " dbo.SysInquiry_BrandListByPaper a INNER JOIN dbo.SysInquiry_BrandInfo b ON a.BrandId=b.KeyId ";
            string condition = " a.PaperId=" + paperId + " and a.BrandId<>" + defaultBrandId + " and b.Status='1' ORDER BY b.OrderNum ";
            IList<SysInquiry_BrandInfo> brandInfoList = _dataBase.SelectModel<Model.SysInquiry_BrandInfo>(selectTarget, fromSouce, condition);
            if (brandInfoList != null && brandInfoList.Count > 0)
            {
                foreach (SysInquiry_BrandInfo brand in brandInfoList)
                {
                    resultList.Add(brand);
                }
            }
            return resultList;
        }

        /// <summary>
        /// 获取最新排序顺序
        /// </summary>
        /// <returns></returns>
        public int GetOrderNumByMax(int paperTypeId)
        {
            int orderNum = 1;
            IList<SysInquiry_PaperInfo> result = _dataBase.SelectModel<SysInquiry_PaperInfo>(" MAX(OrderNum)+1 AS OrderNum ", "SysInquiry_PaperInfo", " PaperTypeId=" + paperTypeId);
            if (result != null && result.Count > 0)
            {
                orderNum = result[0].OrderNum.Value;
            }
            return orderNum;
        }
    }
}