public LayuiPaginationOut GetList(LayuiPaginationIn p) { sql.SelectAll(); var tableSql = sql.Join <MenuTable>((c, t) => c.TABLEID == t.ID, aliasName: "b"); tableSql.Select(m => m.TABLENAME); sql.Where(m => m.ENABLED == true); //var model = p.json.ToObject<MenuColumn>(); //if (model != null) //{ // if (model.TABLEID > 0) sql.And(m => m.TABLEID == model.TABLEID); // if (!model.NAME.IsEmpty()) // { // sql.And().Begin(); // sql.Or(m => m.NAME.Contains(model.NAME)); // tableSql.Or(m => m.TABLENAME.Contains(model.NAME)); // sql.End(); // } //} Dictionary <string, object> dic; string condition = ToSql(p.json, out dic); sql.And(condition).AddParameters(dic); sql.OrderBy(m => m.TABLEID, m => m.TYPE, m => m.SORTID); var list = base.GetDynamicPageList(p, sql); return(new LayuiPaginationOut(p, list)); }
public LayuiPaginationOut GetList(LayuiPaginationIn p) { var list = GetList(basePath); string json = p.json; int total = 0; IEnumerable <DevelopLog> logs = list; if (!string.IsNullOrEmpty(json)) { DateTime begin = json.ToDateTime(DateTime.MinValue); if (begin > DateTime.MinValue) { DateTime end = begin.AddDays(1); logs = logs.Where(m => m.LastUpdteTime >= begin && m.LastUpdteTime < end); } } if (logs != null) { total = logs.Count(); } int skip = (p.page - 1) * p.limit; logs = logs.Skip(skip).Take(p.limit); if (logs != null) { logs = logs.OrderByDescending(m => m.LastUpdteTime); } return(new LayuiPaginationOut(total, logs)); }
public LayuiPaginationOut GetList(LayuiPaginationIn p) { sql.SelectAll(); sql.Where(m => m.ENABLED == true); //var menuSql = sql.Join<Menu>((t, s) => t.MENUID == s.ID, aliasName: "b"); //menuSql.Select(m => m.NAME); MenuTable table = p.json.ToObject <MenuTable>(); if (table != null) { //if (table.MENUID > 0) sql.And(m => m.MENUID == table.MENUID); if (!table.TABLENAME.IsEmpty()) { sql.And(m => m.TABLENAME.Contains(table.TABLENAME)); } } sql.OrderBy(m => m.SORTID, m => m.ID); var list = base.GetPageList(p); return(new LayuiPaginationOut(p, list)); }
public LayuiPaginationOut GetList(LayuiPaginationIn p) { sql.SelectAll(); var tableSql = sql.Join <MenuTable>((c, t) => c.TABLEID == t.ID, aliasName: "b"); tableSql.Select(m => m.TABLENAME); sql.Where(m => m.ENABLED == true); var model = p.json.ToObject <MenuColumn>(); if (model != null) { if (model.TABLEID > 0) { sql.And(m => m.TABLEID == model.TABLEID); } if (!model.NAME.IsEmpty()) { sql.And().Begin(); sql.Or(m => m.NAME.Contains(model.NAME)); tableSql.Or(m => m.TABLENAME.Contains(model.NAME)); sql.End(); } } sql.OrderBy(m => m.TABLEID, m => m.TYPE, m => m.SORTID); var list = base.GetDynamicPageList(p, sql); return(new LayuiPaginationOut(p, list)); }
public LayuiPaginationOut GetList(LayuiPaginationIn p) { sql.SelectAll(); sql.Where(m => m.ENABLED == true); ////var menuSql = sql.Join<Menu>((t, s) => t.MENUID == s.ID, aliasName: "b"); ////menuSql.Select(m => m.NAME); //MenuTable table = p.json.ToObject<MenuTable>(); //if (table != null) //{ // //if (table.MENUID > 0) sql.And(m => m.MENUID == table.MENUID); // if (!table.TABLENAME.IsEmpty()) // { // sql.And(m => m.TABLENAME.Contains(table.TABLENAME)); // } //} Dictionary <string, object> dic; string condition = ToSql(p.json, out dic); sql.And(condition).AddParameters(dic); sql.OrderBy(m => m.SORTID, m => m.ID); var list = base.GetPageList(p); return(new LayuiPaginationOut(p, list)); }
public IEnumerable <TReturn> GetPageList <TReturn>(LayuiPaginationIn p) { int totalCount = 0; sql.QueryPage(p.page, p.limit); var reader = client.GetReader(sql.GetSql(), sql.GetParameters()); var list = reader.Read <TReturn>(); totalCount = reader.Read <int>().FirstOrDefault(); p.total = totalCount; return(list); }
public LayuiPaginationOut GetList(LayuiPaginationIn p) { var sqlCategory = sql.Join <Category>((s, c) => s.CATEGORYID == c.ID, aliasName: "b"); sqlCategory.Select(m => new { CategoryName = m.NAME }); sql.SelectAll(); sql.Where(m => m.ENABLED == true); var model = p.json.ToObject <Article>(); if (model != null) { if (model.CATEGORYID > 0) { sql.And(m => m.CATEGORYID == model.CATEGORYID); } if (!model.CODE.IsEmpty()) { sql.And(m => m.CODE == model.CODE); } if (model.STATUS > 0) { sql.And(m => m.STATUS == model.STATUS); } if (model.ISHOT) { sql.And(m => m.ISHOT == model.ISHOT); } if (model.ISRED) { sql.And(m => m.ISRED == model.ISRED); } if (model.ISTOP) { sql.And(m => m.ISTOP == model.ISTOP); } if (!model.TITLE.IsEmpty()) { sql.And().Begin(); sql.Or(m => m.TITLE.Contains(model.TITLE)); sql.Or(m => m.SUBTITLE.Contains(model.TITLE)); sql.Or(m => m.SUMMARY.Contains(model.TITLE)); sql.Or(m => m.CONTENTS.Contains(model.TITLE)); sql.End(); } } sql.OrderBy(m => m.CATEGORYID, m => m.SORTID); var list = base.GetDynamicPageList(p, sql); return(new LayuiPaginationOut(p, list)); }
public LayuiPaginationOut GetList(LayuiPaginationIn p) { string key = p.json; sql.SelectAll(); sql.Where(m => m.ENABLED == true); if (!key.IsEmpty()) { sql.And().Begin(); sql.Or(m => m.TITLE.Contains(key)); sql.Or(m => m.SUMMARY.Contains(key)); sql.End(); } sql.OrderBy(m => m.ID); var list = base.GetPageList(p); return(new LayuiPaginationOut(p, list)); }
public LayuiPaginationOut GetList(LayuiPaginationIn p) { SqlTextEntity entity = new SqlTextEntity(); entity.PageNumber = p.page; entity.PageSize = p.limit; entity.Selection = "a.*,b.[TEXT] AS PTEXT"; entity.From = "[SYS_DICTIONARY] AS a LEFT JOIN [SYS_DICTIONARY] AS b ON a.[TYPE] = b.[VALUE]"; entity.OrderBy = "ORDER BY a.[SORTID] ASC"; entity.Conditions = " WHERE a.[ENABLED] = 1 AND b.[ENABLED] = 1 "; Dictionary <string, object> dic = new Dictionary <string, object>(); Dictionary model = p.json.ToObject <Dictionary>(); if (!model.CODE.IsEmpty()) { entity.Conditions += " AND a.CODE LIKE '%'+@CODE+'%' "; dic.Add("@CODE", model.CODE); } if (!model.TYPE.IsEmpty()) { entity.Conditions += " AND a.TYPE=@TYPE "; dic.Add("@TYPE", model.TYPE); } if (!model.VALUE.IsEmpty()) { entity.Conditions += " AND (a.VALUE LIKE '%'+@VALUE+'%' OR a.TEXT LIKE '%'+@VALUE+'%')"; dic.Add("@VALUE", model.VALUE); } IEnumerable <dynamic> list = null; var reader = base.GetReader(sql.GetSql(SqlTextType.QueryPage, entity), dic); if (reader != null) { list = reader.Read(); p.total = reader.Read <int>().FirstOrDefault(); } return(new LayuiPaginationOut(p, list)); }
public LayuiPaginationOut GetList(LayuiPaginationIn p) { sql.SelectAll(); sql.And(m => m.ENABLED == true); //string key = p.json; //if (!key.IsEmpty()) //{ // sql.And().Begin(); // sql.Or(m => m.NAME.Contains(key)); // sql.Or(m => m.REMARK.Contains(key)); // sql.End(); //} Dictionary <string, object> dic; string sqlText = ToSql(p.json, out dic); sql.And(sqlText).AddParameters(dic); sql.OrderBy(m => m.SORTID, m => m.ID); var list = base.GetPageList(p); return(new LayuiPaginationOut(p, list)); }
public LayuiPaginationOut GetList(LayuiPaginationIn p) { sql.SelectAll(); var log = JsonHelper.ToObject <Log>(p.json); sql.And(m => m.ENABLED == true); sql.And(m => m.LOGTYPE == log.LOGTYPE); if (log.ACTIONTYPE > 0) { sql.And(m => m.ACTIONTYPE == log.ACTIONTYPE); } if (log.CREATEDATE > DateTime.MinValue) { DateTime begin = log.CREATEDATE; DateTime end = begin.AddDays(1); sql.And(m => m.CREATEDATE >= begin && m.CREATEDATE <= end); } sql.OrderByDescending(m => m.ID); var list = base.GetPageList(p); return(new LayuiPaginationOut(p, list)); }
public LayuiPaginationOut GetList(LayuiPaginationIn p) { sql.SelectAll(); sql.And(m => m.STATUS == 1); //string key = p.json; //if (!key.IsEmpty()) //{ // sql.And().Begin(); // sql.Or(m => m.CNNAME.Contains(key)); // sql.Or(m => m.ACCOUNT.Contains(key)); // sql.Or(m => m.ENNAME.Contains(key)); // sql.End(); //} Dictionary <string, object> dic; string condition = ToSql(p.json, out dic); sql.And(condition); sql.AddParameters(dic); sql.OrderBy(m => m.ID); var list = base.GetPageList(p); return(new LayuiPaginationOut(p, list)); }
public ActionResult GetList(LayuiPaginationIn p) { var result = roleService.GetList(p); return(Json(result)); }
public LayuiPaginationOut GetList(LayuiPaginationIn p) { return(columnRep.GetList(p)); }
public ActionResult GetList(LayuiPaginationIn p) { var list = userService.GetList(p); return(Json(list)); }
public LayuiPaginationOut GetList(LayuiPaginationIn p) { return(articleRep.GetList(p)); }
public IEnumerable <T> GetPageList(LayuiPaginationIn p) { return(this.GetPageList <T>(p)); }
public LayuiPaginationOut GetList(LayuiPaginationIn p) { return(buttonRep.GetList(p)); }
public ActionResult GetList(LayuiPaginationIn p) { var result = column.GetList(p); return(Json(result)); }
public ActionResult GetDevelopList(LayuiPaginationIn p) { var result = devService.GetList(p); return(Json(result)); }
public ActionResult GetList(LayuiPaginationIn p) { var getlist = dicService.GetList(p); return(Json(getlist)); }
public LayuiPaginationOut GetList(LayuiPaginationIn p) { return(imageRep.GetList(p)); }