public ActionResult DiaryData(DiaryData_Filter filter, Rest.Core.Paging Page) { var PermissionCheck = CheckPermission("最新消息管理"); if (PermissionCheck != null) { return(PermissionCheck); } if (!string.IsNullOrEmpty(filter.Subject) && filter.Subject.StartsWith("請輸入")) { filter.Subject = null; } if (!string.IsNullOrEmpty(filter.DiaryType) && filter.DiaryType.StartsWith("全部顯示")) { filter.DiaryType = null; } ViewData["Filter"] = filter; Rest.Core.Paging page = new Rest.Core.Paging() { }; if (Page.CurrentPage > 0) { page.CurrentPage = Page.CurrentPage; } List <DiaryData_Info> data = DiaryMan.GetByParameter(filter, page, null, "DiaryType, PublishDate desc"); ViewData["Model"] = data; ViewData["Page"] = page; return(View()); }
public List <DiaryData_Info> GetByParam(DiaryData_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 <DiaryData_Info>(Page.CurrentPage, Page.ItemsPerPage, SQLStr); Page.Convert <DiaryData_Info>(result); return(result.Items); } }
public List <DiaryData_Info> GetByParam(DiaryData_Filter Filter, string[] fieldNames, string _orderby, Paging Page) { return(GetByParam(Filter, Page, fieldNames, _orderby)); }
public List <DiaryData_Info> GetByParam(DiaryData_Filter Filter, string _orderby, Paging Page) { return(GetByParam(Filter, Page, null, _orderby)); }
public List <DiaryData_Info> GetByParam(DiaryData_Filter Filter, Paging Page) { return(GetByParam(Filter, Page, null, "")); }
public List <DiaryData_Info> GetByParam(DiaryData_Filter Filter) { return(GetByParam(Filter, null, null, "")); }
private Rest.Core.PetaPoco.Sql ConstructSQL(DiaryData_Filter filter, string[] fieldNames, string _orderby) { var SQLStr = Rest.Core.PetaPoco.Sql.Builder .Append("SELECT " + FieldNameArrayToFieldNameString(fieldNames) + " FROM db_DiaryData") .Append("WHERE 1=1 "); if (filter != null) { if (filter.DiaryDataID.HasValue) { SQLStr.Append(" AND DiaryDataID=@0", filter.DiaryDataID.Value); } if (filter.PublishDate.HasValue) { SQLStr.Append(" AND PublishDate=@0", filter.PublishDate.Value); } if (!string.IsNullOrEmpty(filter.Subject)) { SQLStr.Append(" AND Subject like @0", "%" + filter.Subject + "%"); } if (!string.IsNullOrEmpty(filter.ContentBody)) { SQLStr.Append(" AND ContentBody=@0", filter.ContentBody); } if (!string.IsNullOrEmpty(filter.Image1)) { SQLStr.Append(" AND Image1=@0", filter.Image1); } if (!string.IsNullOrEmpty(filter.Image2)) { SQLStr.Append(" AND Image2=@0", filter.Image2); } if (!string.IsNullOrEmpty(filter.Image3)) { SQLStr.Append(" AND Image3=@0", filter.Image3); } if (!string.IsNullOrEmpty(filter.Image4)) { SQLStr.Append(" AND Image4=@0", filter.Image4); } if (!string.IsNullOrEmpty(filter.FileDocument)) { SQLStr.Append(" AND FileDocument=@0", filter.FileDocument); } if (!string.IsNullOrEmpty(filter.YoutubeLink)) { SQLStr.Append(" AND YoutubeLink=@0", filter.YoutubeLink); } if (filter.IsShowInHeader.HasValue) { SQLStr.Append(" AND IsShowInHeader=@0", filter.IsShowInHeader.Value); } if (filter.Hit.HasValue) { SQLStr.Append(" AND Hit=@0", filter.Hit.Value); } if (!string.IsNullOrEmpty(filter.DiaryType)) { SQLStr.Append(" AND DiaryType=@0", filter.DiaryType); } if (!string.IsNullOrEmpty(filter.DiaryTypeCode)) { SQLStr.Append(" AND DiaryTypeCode=@0", filter.DiaryTypeCode); } if (!string.IsNullOrEmpty(filter.TopThreeColumn)) { SQLStr.Append(" AND TopThreeColumn=@0", filter.TopThreeColumn); } 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); }
private Rest.Core.PetaPoco.Sql ConstructSQL(DiaryData_Filter filter) { return(ConstructSQL(filter, new string[] { "*" }, "")); }
public List <DiaryData_Info> GetByParameter(DiaryData_Filter Filter, string[] fieldNames, string _orderby, Rest.Core.Paging Page) { return(new DiaryData_Repo().GetByParam(Filter, fieldNames, _orderby, Page)); }
public List <DiaryData_Info> GetByParameter(DiaryData_Filter Filter, string _orderby) { return(new DiaryData_Repo().GetByParam(Filter, _orderby)); }
public List <DiaryData_Info> GetByParameter(DiaryData_Filter Filter, Rest.Core.Paging Page) { return(new DiaryData_Repo().GetByParam(Filter, Page)); }
public List <DiaryData_Info> GetByParameter(DiaryData_Filter Filter) { return(new DiaryData_Repo().GetByParam(Filter)); }