public Flexigride GetJson(JObject json)
{
SearchMod <SYS_Button> searchModel = new SearchMod <SYS_Button>();
searchModel.page = Convert.ToInt32(json["page"].ToString()); //当前页
searchModel.rp = Convert.ToInt32(json["rp"].ToString()); //页面大小
searchModel.sortorder = json["sortorder"].ToString(); //排序字段
searchModel.sortname = json["sortname"].ToString(); //排序方式
SYS_Button model = JsonToObject <SYS_Button>(json);
IQueryable <SYS_Button> query = DPBase.db.SYS_Button;
query = string.IsNullOrEmpty(searchModel.sortorder) ? query.OrderByDescending(c => searchModel.sortorder) : query.OrderBy(c => searchModel.sortorder);
if (!string.IsNullOrEmpty(model.BTN_Name))
{
query = query.Where(c => c.BTN_Name.Contains(model.BTN_Name));
}
if (!string.IsNullOrEmpty(model.BTN_Name_En))
{
query = query.Where(c => c.BTN_Name_En.Contains(model.BTN_Name_En));
}
searchModel.query = query;
Flexigride grid = new Flexigride();
grid.rows = DPBase.DPGetQueryLst(searchModel, out searchModel);
grid.page = searchModel.page;
grid.total = searchModel.total;
return(grid);
}
public Flexigride GetJson(JObject json)
{
SearchMod <SYS_Dics> searchModel = new SearchMod <SYS_Dics>();
searchModel.page = Convert.ToInt32(json["page"].ToString()); //当前页
searchModel.rp = Convert.ToInt32(json["rp"].ToString()); //页面大小
searchModel.sortorder = json["sortorder"].ToString(); //排序字段
searchModel.sortname = json["sortname"].ToString(); //排序方式
var model = JsonToObject <SYS_Dics>(json);
IQueryable <SYS_Dics> query = DPBase.db.SYS_Dics;
//query = string.IsNullOrEmpty(searchModel.sortorder) ? query.OrderByDescending(c => searchModel.sortorder) : query.OrderBy(c => searchModel.sortorder);
query = query.OrderBy(c => c.Sortnum);
if (model.CategoryId != 0)
{
query = query.Where(c => c.CategoryId == model.CategoryId);
}
searchModel.query = query;
Flexigride grid = new Flexigride();
grid.rows = DPBase.DPGetQueryLst(searchModel, out searchModel);
grid.page = searchModel.page;
grid.total = searchModel.total;
return(grid);
}
public Flexigride GetButtonGroup(JObject json)
{
SearchMod <SYS_ButtonGroup> searchModel = new SearchMod <SYS_ButtonGroup>();
searchModel.page = Convert.ToInt32(json["page"].ToString());
searchModel.rp = Convert.ToInt32(json["rp"].ToString());
SYS_ButtonGroup bGroup = (SYS_ButtonGroup)(JsonConvert.DeserializeObject(json.ToString(), typeof(SYS_ButtonGroup)));
IQueryable <SYS_ButtonGroup> query = DPBase.db.SYS_ButtonGroup;
query = string.IsNullOrEmpty(searchModel.sortorder) ? query.OrderByDescending(c => searchModel.sortname) : query.OrderBy(c => searchModel.sortname);
if (!string.IsNullOrEmpty(bGroup.BG_Name))
{
query = query.Where(c => c.BG_Name.Contains(bGroup.BG_Name));
}
if (!string.IsNullOrEmpty(bGroup.BG_Name_En))
{
query = query.Where(c => c.BG_Name_En.Contains(bGroup.BG_Name_En));
}
//aa.query = query.Select(c => new { BG_Name = c.BG_Name, BG_Name_En = c.BG_Name_En, BG_OrderIndex = c.BG_OrderIndex, BG_Desc = c.BG_Desc,BG_Id = c.BG_Id });
searchModel.query = query.OrderBy(c => c.BG_CreatedOn);
Flexigride grid = new Flexigride();
grid.rows = DPBase.DPGetQueryLst(searchModel, out searchModel);
grid.page = searchModel.page;
grid.total = searchModel.total;
return(grid);
}
/// <summary>
/// 通用查询,必须先设置好查询类
/// </summary>
/// <param name="SearchMod">查询类</param>
/// <returns></returns>
public static List <dynamic> DPGetQueryLst <T>(SearchMod <T> smod, out SearchMod <T> res) where T : class
{
int skipCount = ((smod.page - 1) * smod.rp);
IQueryable <dynamic> query = smod.query;
Type t = typeof(T);
//List<PropertyInfo> tempPro = t.GetProperties(System.Reflection.BindingFlags.Public | System.Reflection.BindingFlags.Instance).ToList();
smod.total = query.Count();
List <dynamic> ret = query.Skip(skipCount).Take(smod.rp).ToList();
res = smod;
return(ret);
}
