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