public Flexigride GetJson(JObject json)
{
SearchMod <SYS_SystemRole> searchModel = new SearchMod <SYS_SystemRole>();
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_SystemRole model = JsonToObject <SYS_SystemRole>(json);
IQueryable <SYS_SystemRole> query = DPBase.db.SYS_SystemRole;
query = string.IsNullOrEmpty(searchModel.sortorder) ? query.OrderByDescending(c => searchModel.sortorder) : query.OrderBy(c => searchModel.sortorder);
if (!string.IsNullOrEmpty(model.ROLE_Name))
{
query = query.Where(c => c.ROLE_Name.Contains(model.ROLE_Name));
}
if (!string.IsNullOrEmpty(model.ROLE_Level.ToString()))
{
query = query.Where(c => c.ROLE_Level == model.ROLE_Level);
}
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 int Add(JObject json)
{
SYS_SystemRole model = JsonToObject <SYS_SystemRole>(json);
model.ROLE_CreatedBy = UserSession.userid; //当前用户
model.ROLE_CreatedOn = DateTime.Now;
return(DPBase.Add(model));
}
public SYS_SystemRole Get(JObject json)
{
if (string.IsNullOrEmpty(json["ROLE_Level"].ToString()))
{
json["ROLE_Level"] = 0;
}
var model = JsonToObject <SYS_SystemRole>(json);
SYS_SystemRole _model = DPBase.Get <SYS_SystemRole>(model.ROLE_Id);
return(_model);
}
public string ValRolAttribute(JObject json)
{
if (string.IsNullOrEmpty(json["ROLE_Level"].ToString()) || string.IsNullOrEmpty(json["ROLE_OrderIndex"].ToString()))
{
json["ROLE_Level"] = 0;
json["ROLE_OrderIndex"] = 0;
}
SYS_SystemRole model = JsonToObject <SYS_SystemRole>(json);
using (NERPEntities context = new NERPEntities())
{
IQueryable <SYS_SystemRole> _role = context.SYS_SystemRole.Where(c => c.ROLE_Name == model.ROLE_Name);
if (_role.Count() > 0)
{
return("1");
}
return("0");
}
}
public string Edit(JObject json)
{
SYS_SystemRole model = JsonToObject <SYS_SystemRole>(json);
return(DPBase.Update(model) ? "新增成功！" : "新增失败");
}
