public List <HirCategory_Info> GetByParam(HirCategory_Filter Filter, Paging Page, string[] fieldNames, string _orderby) { if (fieldNames == null) { fieldNames = new string[] { "*" }; } if (Page == null) { Page = new Paging(); } using (var db = new DBExecutor().GetDatabase()) { var SQLStr = ConstructSQL(Filter, fieldNames, _orderby); var result = db.Page <HirCategory_Info>(Page.CurrentPage, Page.ItemsPerPage, SQLStr); Page.Convert <HirCategory_Info>(result); return(result.Items); } }
public ActionResult HirCategory(HirCategory_Filter filter, Rest.Core.Paging Page) { var PermissionCheck = CheckPermission("人員募集管理"); if (PermissionCheck != null) { return(PermissionCheck); } //if (!string.IsNullOrEmpty(filter.op_title) && filter.op_title.StartsWith("請輸入")) filter.op_title = null; ViewData["Filter"] = filter; Page = new Rest.Core.Paging() { }; Page.ItemsPerPage = 9999;//不分頁 List <HirCategory_Info> data = CHMan.GetByParameter(filter, Page, null, "SortNum"); ViewData["Model"] = data; ViewData["Page"] = Page; return(View()); }
private Rest.Core.PetaPoco.Sql ConstructSQL(HirCategory_Filter filter, string[] fieldNames, string _orderby) { var SQLStr = Rest.Core.PetaPoco.Sql.Builder .Append("SELECT " + FieldNameArrayToFieldNameString(fieldNames) + " FROM db_HirCategory") .Append("WHERE 1=1 "); if (filter != null) { if (filter.HirCategoryId.HasValue) { SQLStr.Append(" AND HirCategoryId=@0", filter.HirCategoryId.Value); } if (filter.SortNum.HasValue) { SQLStr.Append(" AND SortNum=@0", filter.SortNum.Value); } if (!string.IsNullOrEmpty(filter.CategoryName)) { SQLStr.Append(" AND CategoryName=@0", filter.CategoryName); } if (filter.IsActive.HasValue) { SQLStr.Append(" AND IsActive=@0", filter.IsActive.Value); } if (filter.LastUpdate.HasValue) { SQLStr.Append(" AND LastUpdate=@0", filter.LastUpdate.Value); } if (!string.IsNullOrEmpty(filter.LastUpdator)) { SQLStr.Append(" AND LastUpdator=@0", filter.LastUpdator); } if (_orderby != "") { SQLStr.OrderBy(_orderby); } } return(SQLStr); }
public List <HirCategory_Info> GetByParameter(HirCategory_Filter Filter, string[] fieldNames, string _orderby, Rest.Core.Paging Page) { return(new HirCategory_Repo().GetByParam(Filter, fieldNames, _orderby, Page)); }
public List <HirCategory_Info> GetByParameter(HirCategory_Filter Filter, string _orderby) { return(new HirCategory_Repo().GetByParam(Filter, _orderby)); }
public List <HirCategory_Info> GetByParameter(HirCategory_Filter Filter, Rest.Core.Paging Page) { return(new HirCategory_Repo().GetByParam(Filter, Page)); }
public List <HirCategory_Info> GetByParameter(HirCategory_Filter Filter) { return(new HirCategory_Repo().GetByParam(Filter)); }
public List <HirCategory_Info> GetByParam(HirCategory_Filter Filter, string[] fieldNames, string _orderby, Paging Page) { return(GetByParam(Filter, Page, fieldNames, _orderby)); }
public List <HirCategory_Info> GetByParam(HirCategory_Filter Filter, string _orderby, Paging Page) { return(GetByParam(Filter, Page, null, _orderby)); }
public List <HirCategory_Info> GetByParam(HirCategory_Filter Filter, Paging Page) { return(GetByParam(Filter, Page, null, "")); }
private Rest.Core.PetaPoco.Sql ConstructSQL(HirCategory_Filter filter) { return(ConstructSQL(filter, new string[] { "*" }, "")); }