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;

namespace CY.SQLDAL
{
    public class EC_FirmInfoDAL : IEC_FirmInfoDAL
    {

        private Database _dataBase = null;

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

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

        /// <summary>
        /// 新增
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public bool InserModel(Infrastructure.Domain.IAggregateRoot model)
        {
            Model.EC_FirmInfo trueModel = model as Model.EC_FirmInfo;
            if (trueModel == null)
            {
                return false;
            }
            IList<SqlParameter> sqlParms = new List<SqlParameter>()
            {
                    new SqlParameter("@BusinessLicense",trueModel.BusinessLicense),
					new SqlParameter("@LegalRepresentative",trueModel.LegalRepresentative),
					new SqlParameter("@BusinessLicensePic",trueModel.BusinessLicensePic),
					new SqlParameter("@OrganizationCodeCertificate",trueModel.OrganizationCodeCertificate),
					new SqlParameter("@TaxRegistrationCertificate",trueModel.TaxRegistrationCertificate),
					new SqlParameter("@Contacts",trueModel.Contacts),
					new SqlParameter("@FileSize",trueModel.FileSize),
					new SqlParameter("@ShorMessageNum",trueModel.ShorMessageNum),
					new SqlParameter("@FirmType",trueModel.FirmType),
					new SqlParameter("@MachineType",trueModel.MachineType),
					new SqlParameter("@SupplyInfo",trueModel.SupplyInfo),
					new SqlParameter("@FirmDescribe",trueModel.FirmDescribe),
					new SqlParameter("@FileId",trueModel.FileId),
					new SqlParameter("@MemberId",trueModel.MemberId),
					new SqlParameter("@LastUpdateTime",trueModel.LastUpdateTime),
					new SqlParameter("@Operator",trueModel.Operator),
					new SqlParameter("@FirmStencilId",trueModel.FirmStencilId ?? 0) ,
                    new SqlParameter("@DomainName",trueModel.DomainName ?? "") ,
                    new SqlParameter("@Remark",trueModel.Remark) ,
                    new SqlParameter("@PrintLicenseImg",trueModel.PrintLicenseImg ?? "") 
            };
            try
            {
                _dataBase.Query("sp_EC_FirmInfo_Insert", CommandType.StoredProcedure, sqlParms.ToArray<SqlParameter>());
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return true;
        }

        /// <summary>
        /// 修改
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public bool UpdateModel(Infrastructure.Domain.IAggregateRoot model)
        {
            Model.EC_FirmInfo trueModel = model as Model.EC_FirmInfo;
            if (trueModel == null)
            {
                return false;
            }
            IList<SqlParameter> sqlParms = new List<SqlParameter>()
            {
                    new SqlParameter("@Keyid",trueModel.Keyid),
					new SqlParameter("@BusinessLicense",trueModel.BusinessLicense),
					new SqlParameter("@LegalRepresentative",trueModel.LegalRepresentative),
					new SqlParameter("@BusinessLicensePic",trueModel.BusinessLicensePic),
					new SqlParameter("@OrganizationCodeCertificate",trueModel.OrganizationCodeCertificate),
					new SqlParameter("@TaxRegistrationCertificate",trueModel.TaxRegistrationCertificate),
					new SqlParameter("@Contacts",trueModel.Contacts),
					new SqlParameter("@FileSize",trueModel.FileSize),
					new SqlParameter("@ShorMessageNum",trueModel.ShorMessageNum),
					new SqlParameter("@FirmType",trueModel.FirmType),
					new SqlParameter("@MachineType",trueModel.MachineType),
					new SqlParameter("@SupplyInfo",trueModel.SupplyInfo),
					new SqlParameter("@FirmDescribe",trueModel.FirmDescribe),
					new SqlParameter("@FileId",trueModel.FileId),
					new SqlParameter("@MemberId",trueModel.MemberId),
					new SqlParameter("@LastUpdateTime",trueModel.LastUpdateTime),
					new SqlParameter("@Operator",trueModel.Operator),
					new SqlParameter("@Remark",trueModel.Remark) ,
					new SqlParameter("@FirmStencilId",trueModel.FirmStencilId ?? 0) ,
                    new SqlParameter("@DomainName",trueModel.DomainName ?? "") ,
					new SqlParameter("@PrintLicenseImg",trueModel.PrintLicenseImg ?? "")
            };
            try
            {
                _dataBase.Query("sp_EC_FirmInfo_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_FirmInfo trueModel = model as Model.EC_FirmInfo;
            if (trueModel == null)
            {
                return false;
            }
            IList<SqlParameter> sqlParms = new List<SqlParameter>()
            {
                new SqlParameter("@Keyid",trueModel.Keyid)
            };
            try
            {
                _dataBase.Query("sp_EC_FirmInfo_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_FirmInfo> SelectModelPage(Infrastructure.Query.Query query, Infrastructure.Query.Pagination pagination)
        {
            throw new NotImplementedException();
        }

        /// <summary>
        /// 分页查询
        /// </summary>
        /// <param name="pagination"></param>
        /// <param name="Province"></param>
        /// <param name="City"></param>
        /// <param name="County"></param>
        /// <param name="FirmDescribe"></param>
        /// <param name="MachineType"></param>
        /// <returns></returns>
        public IEnumerable<Model.EC_FirmInfo> SelectModelPage(Infrastructure.Query.Pagination pagination, string Province, string City, string County, string FirmDescribe, string MachineType)
        {
            try
            {
                string condtion = " b.MemberType='印刷厂商' and b.UseState ='3' ";
                if (!string.IsNullOrEmpty(Province))
                    condtion += " and b.Province ='" + Province + "'";
                if (!string.IsNullOrEmpty(City))
                    condtion += " and b.City ='" + City + "'";
                if (!string.IsNullOrEmpty(County))
                    condtion += " and b.County ='" + County + "'";
                if (!string.IsNullOrEmpty(FirmDescribe))
                    condtion += " and a.FirmDescribe like '%" + FirmDescribe + "%'";
                else if (!string.IsNullOrEmpty(MachineType))
                    condtion += " and a.MachineType like '%" + MachineType + "%'";

                IList<EC_FirmInfo> result = _dataBase.SelectModelPage<Model.EC_FirmInfo>(pagination, " a.*,d.Stencil_Url,b.Name as CompanyName,b.Province as Province,b.City as City,c.QQ as QQ,b.bid as bid,b.bdomainname as bdomainname,b.bstenciid as bstenciid", " EC_FirmInfo a  join EC_MemberBasic b on a.MemberId = b.MemberId join EC_MemberExtend c on a.MemberId = c.Keyid LEFT JOIN dbo.Sys_FirmStencil AS d ON a.FirmStencilId = d.Keyid ", " a.LastUpdateTime DESC", " LastUpdateTime DESC", condtion) as IList<EC_FirmInfo>;//执行查询
                return null == result ? null : result;//返回结果
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

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

        /// <summary>
        /// 根据会员编号获得厂商信息
        /// </summary>
        /// <param name="MemberId">会员编号</param>
        /// <returns></returns>
        public EC_FirmInfo GetModelByMemberId(Guid MemberId)
        {
            if (MemberId == null)
                return null;//错误数据返会空 

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

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

        /// <summary>
        /// 检测域名是否重复
        /// </summary>
        /// <param name="DomainName"></param>
        /// <param name="MemberId"></param>
        /// <returns></returns>
        public int IsExitsDomain(string DomainName, Guid MemberId)
        {
            try
            {
                IList<EC_MemberBasic> result = _dataBase.SelectModel<EC_MemberBasic>("*", "EC_MemberBasic", " bdomainname = '" + DomainName + "'") as IList<EC_MemberBasic>;//执行查询
                if (null == result || result.Count == 0)
                {
                    return 0;
                }
                else
                {
                    if (result[0].MemberId == MemberId)
                        return 0;
                    else
                        return 1;
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }


        /// <summary>
        /// 根据会员的域名获取代表值，如果没找到返回-1
        /// </summary>
        /// <param name="domainName"></param>
        /// <returns></returns>
        public int GetBid(string domainName)
        {
            int bid = -1;
            IList<EC_MemberBasic> result = _dataBase.SelectModel<EC_MemberBasic>("*", "EC_MemberBasic", " bdomainname = '" + domainName + "'") as IList<EC_MemberBasic>;
            if (result != null && result.Count > 0)
            {
                if (result[0].bid.HasValue)
                bid = result[0].bid.Value;
            }
            return bid;
        }
    }
}