using System;
using System.Collections.Generic;
using System.Data;
using WIP_common;
using WIP_DAL;
using WIP_Models;

namespace WIP_BLL
{
    /// 

    /// $ChinaComment$ÒµÎñ´¦ÀíÀà
    /// 
    public class $FilePrefixName$BLL
    {
        private readonly $FilePrefixName$DAL $TableAlias$DAL = new $FilePrefixName$DAL();

        #region Add

		 /// 

        /// Ôö¼ÓÒ»Ìõ$ChinaComment$Êý¾Ý
        /// 
        /// ÒªÔö¼ÓµÄ$ChinaComment$²ÎÊýÀà
		/// ´´½¨ÈË
        /// ²åÈëµÄ×îÐÂÖ÷¼üÖµ
        public int Add($AddEntityParam$ param,string creator)
        {
			$EntityName$ model = null;
			model = WIPCommon.T1ToT2<$AddEntityParam$, $EntityName$>(param);
			model.creator = model.lastModifier = creator;
		    model.createTime = model.lastModifyTime = DateTime.Now;
			model.delFlag=false;
            return $TableAlias$DAL.Add(model);
        }

        #endregion

        #region Edit

        /// 

        /// ¸üÐÂÒ»Ìõ$ChinaComment$Êý¾Ý
        /// 
        /// Òª¸üеÄ$ChinaComment$ʵÌå
		/// ×îºóÐÞ¸ÄÈË
        /// ¸üÐÂÊÇ·ñ³É¹¦
        public bool Update($EntityName$ model,string lastModifier)
        {
			model.lastModifier = lastModifier;
		    model.lastModifyTime = DateTime.Now;
            return $TableAlias$DAL.Update(model);
        }

        #endregion

        #region Del

        /// 

        /// ɾ³ýÒ»Ìõ$ChinaComment$Êý¾Ý
        /// 
        /// $PrimaryKeyDesc$
        /// ÊÇ·ñɾ³ý³É¹¦
        public bool Delete(string $PrimaryKey$)
        {
            return $TableAlias$DAL.Delete($PrimaryKey$);
        }

        #endregion

		#region Enable

        /// 

        /// ½ûÆôÓÃ$ChinaComment$Êý¾Ý
        /// 
        /// $PrimaryKeyDesc$
		/// ½ûÓÃ1/ÆôÓÃ0
		/// ×îºóÐÞ¸ÄÈË
		/// ÊÂÎñÀà
        /// ÊÇ·ñ½ûÆôÓóɹ¦
        public bool Enable(string $PrimaryKey$, string delFlag, string lastModifier)
        {
            return $TableAlias$DAL.Enable($PrimaryKey$,delFlag,lastModifier);
        }

        #endregion

        #region QueryList(Page)

        /// 

        /// »ñµÃ$ChinaComment$Êý¾ÝÁбí(·ÖÒ³)
        /// 
        /// ²éѯ²ÎÊý
        /// $ChinaComment$·ÖÒ³Êý¾Ý
        public PageResultModel<$EntityName$> GetModelListForPage(Query$Modulelogo$Param pageParam)
        {
            DataSet ds = $TableAlias$DAL.GetModelListForPage(pageParam);
            List<$EntityName$> list = DataTableToList(ds.Tables[0]);
            int total = Convert.ToInt32(ds.Tables[1].Rows[0]["COUNT"]);
            PageResultModel<$EntityName$> result = new PageResultModel<$EntityName$>();
            result.total = total;
            result.rows = list;
            return result;
        }

        #endregion

		#region QueryList

        /// 

        /// »ñµÃ$ChinaComment$Êý¾ÝÁбí
        /// 
        /// ²éѯÌõ¼þ
        /// $ChinaComment$Êý¾Ý¼¯ºÏ
        public List<$EntityName$> GetModelList(string strWhere)
        {
            DataSet ds = $TableAlias$DAL.GetList(strWhere);
            return DataTableToList(ds.Tables[0]);
        }

        #endregion

        #region Query(Single)

        /// 

        /// µÃµ½Ò»¸ö$ChinaComment$ʵÌå
        /// 
        /// $PrimaryKeyDesc$
        /// $ChinaComment$ʵÌå
        public $EntityName$ GetModel(string $PrimaryKey$)
        {

            return $TableAlias$DAL.GetModel($PrimaryKey$);
        }

        #endregion

        #region Other

        /// 

        /// ÊÇ·ñ´æÔÚ¸Ã$ChinaComment$¼Ç¼
        /// 
        /// $PrimaryKeyDesc$
        /// 
        public bool Exists(string $PrimaryKey$, int? id = null)
        {
            return $TableAlias$DAL.Exists($PrimaryKey$,id);
        }

        #endregion

		#region Common

		/// 

        /// »ñµÃ$ChinaComment$Êý¾ÝÁбí
        /// 
        private List<$EntityName$> DataTableToList(DataTable dt)
        {
            List<$EntityName$> modelList = new List<$EntityName$>();
            int rowsCount = dt.Rows.Count;
            if (rowsCount > 0)
            {
                $EntityName$ model;
                for (int n = 0; n < rowsCount; n++)
                {
                    model = new $EntityName$();
                    var dataRow = dt.Rows[n];

                    $ToSingleModel$


                    modelList.Add(model);
                }
            }
            return modelList;
        }

		#endregion

    }
}