Exemple #1
0
 /// <summary>
 /// 根据关键字段的值获取记录
 /// </summary>
 /// <param name="Id">关键字段的值</param>
 /// <returns>符合查询条件的记录</returns>
 public SysDepartment GetSysDepartmentById(string Id)
 {
     using (ISysDepartmentBLL SysDepartmentBLL = BLLContainer.Resolve <ISysDepartmentBLL>())
     {
         SysDepartment model = SysDepartmentBLL.GetFirstOrDefault(Id);
         return(model);
     }
 }
Exemple #2
0
        /// <summary>
        /// 返回记录总数 配合分页查询用
        /// </summary>
        /// <param name="sWhere">查询条件;多条件是目前只支持 and;表达式 System.Linq.Dynamic的形式</param>
        /// <returns>符合查询条件的记录数</returns>
        public int GetSysDepartmentCount(string sWhere)
        {
            Expression <Func <SysDepartment, bool> > whereLamda = SerializerHelper.ConvertParamWhereToLinq <SysDepartment>(sWhere);

            using (ISysDepartmentBLL SysDepartmentBLL = BLLContainer.Resolve <ISysDepartmentBLL>())
            {
                return(SysDepartmentBLL.GetCount(whereLamda));
            }
        }
Exemple #3
0
        /// <summary>
        /// 根据查询条件获取记录
        /// </summary>
        /// <param name="sWhere">查询条件;多条件是目前只支持 and;表达式 System.Linq.Dynamic的形式</param>
        /// <returns>符合查询条件的List</returns>
        public List <SysDepartment> GetSysDepartments(string sWhere)
        {
            Expression <Func <SysDepartment, bool> > whereLamda = SerializerHelper.ConvertParamWhereToLinq <SysDepartment>(sWhere);

            using (ISysDepartmentBLL SysDepartmentBLL = BLLContainer.Resolve <ISysDepartmentBLL>())
            {
                List <SysDepartment> models = SysDepartmentBLL.GetModels(whereLamda);
                return(models);
            }
        }
Exemple #4
0
 /// <summary>
 /// 修改
 /// </summary>
 /// <param name="mSysDepartment">模型</param>
 /// <returns>是否成功</returns>
 public bool UpdateSysDepartment(SysDepartment mSysDepartment)
 {
     if (mSysDepartment == null)
     {
         return(false);
     }
     using (ISysDepartmentBLL SysDepartmentBLL = BLLContainer.Resolve <ISysDepartmentBLL>())
     {
         return(SysDepartmentBLL.Update(mSysDepartment));
     }
 }
Exemple #5
0
 /// <summary>
 /// 按照关键字段删除
 /// </summary>
 /// <param name="Id">关键字段</param>
 /// <returns>是否成功</returns>
 public bool DelSysDepartment(string Id)
 {
     using (ISysDepartmentBLL SysDepartmentBLL = BLLContainer.Resolve <ISysDepartmentBLL>())
     {
         try
         {
             SysDepartment item = SysDepartmentBLL.GetFirstOrDefault(Id);
             return(SysDepartmentBLL.Delete(item));
         }
         catch { return(false); }
     }
 }
Exemple #6
0
 /// <summary>
 /// 按照关键字段删除
 /// </summary>
 /// <param name="Ids">关键字段数组</param>
 /// <returns>是否成功</returns>
 public bool DelSysDepartments(string[] Ids)
 {
     using (ISysDepartmentBLL SysDepartmentBLL = BLLContainer.Resolve <ISysDepartmentBLL>())
     {
         try
         {
             List <SysDepartment> entitys = new List <SysDepartment>();
             foreach (string id in Ids)
             {
                 SysDepartment item = SysDepartmentBLL.GetFirstOrDefault(id);
                 entitys.Add(item);
             }
             return(SysDepartmentBLL.Delete(entitys));
         }
         catch { return(false); }
     }
 }
Exemple #7
0
        /// <summary>
        /// 分页查询
        /// </summary>
        /// <param name="pageSize">单页的记录数</param>
        /// <param name="pageIndex">页码</param>
        /// <param name="isAsc">是否正序排序</param>
        /// <param name="orderField">排序字段 为空时默认为 CREATION_DATE </param>
        /// <param name="sWhere">查询条件;多条件是目前只支持 and;表达式 System.Linq.Dynamic的形式</param>
        /// <returns>符合查询条件的List结果</returns>
        public List <SysDepartment> GetSysDepartmentByPage(int pageSize, int pageIndex, bool isAsc, string orderField, string sWhere)
        {
            string orderStr = "";

            if (string.IsNullOrEmpty(orderField))
            {
                orderStr = "CREATION_DATE";
            }
            else
            {
                orderStr = orderField;
            }
            Expression <Func <SysDepartment, bool> > whereLamda = SerializerHelper.ConvertParamWhereToLinq <SysDepartment>(sWhere);

            using (ISysDepartmentBLL SysDepartmentBLL = BLLContainer.Resolve <ISysDepartmentBLL>())
            {
                List <SysDepartment> models = SysDepartmentBLL.GetModelsByPage(pageSize, pageIndex, isAsc, orderStr, whereLamda);
                return(models);
            }
        }