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 } }