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

namespace CY.SQLDAL
{
    public class Info_CompanyAdDAL : IInfo_CompanyAdDAL
    {

        private Database _dataBase = null;

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

        /// <summary>
        /// 新增
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public bool InserModel(Infrastructure.Domain.IAggregateRoot model)
        {
            Model.Info_CompanyAd trueModel = model as Model.Info_CompanyAd;
            if (trueModel == null)
            {
                return false;
            }
            IList<SqlParameter> sqlParms = new List<SqlParameter>()
                {
                    new SqlParameter("@CreateTime",trueModel.CreateTime),
					new SqlParameter("@FirmId",trueModel.FirmId),
                    new SqlParameter("@LinkUrl",trueModel.LinkUrl),
                    new SqlParameter("@Operator",trueModel.Operator),
                    new SqlParameter("@PicUrl",trueModel.PicUrl),
                    new SqlParameter("@Tittle",trueModel.Tittle),
                    new SqlParameter("@Type",trueModel.Type)
                };
            try
            {
                _dataBase.Query("sp_Info_CompanyAd_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.Info_CompanyAd trueModel = model as Model.Info_CompanyAd;
            if (trueModel == null)
            {
                return false;
            }
            IList<SqlParameter> sqlParms = new List<SqlParameter>()
                {
					new SqlParameter("@CreateTime",trueModel.CreateTime),
					new SqlParameter("@FirmId",trueModel.FirmId),
                    new SqlParameter("@LinkUrl",trueModel.LinkUrl),
                    new SqlParameter("@Operator",trueModel.Operator),
                    new SqlParameter("@PicUrl",trueModel.PicUrl),
                    new SqlParameter("@Tittle",trueModel.Tittle),
                    new SqlParameter("@Type",trueModel.Type),
                    new SqlParameter("@KeyId",trueModel.KeyId)
                };
            try
            {
                _dataBase.Query("sp_Info_CompanyAd_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.Info_CompanyAd trueModel = model as Model.Info_CompanyAd;
            if (trueModel == null)
            {
                return false;
            }
            IList<SqlParameter> sqlParms = new List<SqlParameter>()
                {
                    new SqlParameter("@Keyid",trueModel.KeyId)
                };
            try
            {
                _dataBase.Query("sp_Info_CompanyAd_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.Info_CompanyAd> SelectModelPage(Infrastructure.Query.Query query, Infrastructure.Query.Pagination pagination)
        {
            throw new NotImplementedException();
        }

        /// <summary>
        /// 获取公司广告信息列表
        /// </summary>
        /// <param name="pa"></param>
        /// <param name="FirmId"></param>
        /// <param name="PicType"></param>
        /// <param name="Tittle"></param>
        /// <returns></returns>
        public IEnumerable<Model.Info_CompanyAd> SelectModelList(Infrastructure.Query.Pagination pa, Guid FirmId, string PicType, string Tittle)
        {
            string Condition = " where FirmId='" + FirmId + "'";
            if (!string.IsNullOrEmpty(PicType))
            {
                Condition += "  and Type=" + PicType;
            }
            if (!string.IsNullOrEmpty(Tittle))
            {
                Condition += "  and Tittle like  '" + Tittle + "%'";
            }

            return _dataBase.SelectModelPage<Model.Info_CompanyAd>(pa, " a.*,b.Name AS TypeName ", " ( SELECT * FROM dbo.Info_CompanyAd " + Condition + "  ) AS a LEFT JOIN dbo.Sys_Dictionary AS b ON  a.type=b.Keyid ", "Type DESC,createTime DESC");
        }

        /// <summary>
        /// 根据类型返回图片列表
        /// </summary>
        /// <param name="pa"></param>
        /// <param name="type"></param>
        /// <param name="FirmId"></param>
        /// <returns></returns>
        public IEnumerable<Model.Info_CompanyAd> SelectModelListByType(Infrastructure.Query.Pagination pa, string type, Guid FirmId)
        {

            string fromSource = "dbo.Info_CompanyAd  AS a  WHERE  a.FirmId='" + FirmId + "' AND a.type = ( SELECT Keyid FROM dbo.Sys_Dictionary WHERE Name='" + type + "') ";
            return _dataBase.SelectModelPage<Model.Info_CompanyAd>(pa, " *  ", fromSource, "createTime DESC");
        }

        /// <summary>
        /// 单个查询
        /// </summary>
        /// <param name="query"></param>
        /// <returns></returns>
        public IEnumerable<Model.Info_CompanyAd> SelectAllModel(Infrastructure.Query.Query query)
        {

            throw new NotImplementedException();
        }

        /// <summary>
        /// 获取单个公司广告信息
        /// </summary>
        /// <param name="KeyId"></param>
        /// <returns></returns>
        public Model.Info_CompanyAd SelectSingleModel(string KeyId)
        {
            try
            {
                string selTarget = " * ";
                string fromSource = " Info_CompanyAd  where KeyId='" + KeyId + "' ";
                Model.Info_CompanyAd model = _dataBase.SelectModel<Model.Info_CompanyAd>(selTarget, fromSource)[0];
                return model;
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

    }
}