/// <summary>
/// 分页的数据
/// </summary>
/// <returns></returns>
public JsonResult GetData(GridSettings setting)
{
string requestStringPar = Request["customPar"];
string page = Request["page"]; //当前页
string rows = Request["rows"]; //每页显示
int pageIndex = Convert.ToInt32(page); //当前页
int rowsint = Convert.ToInt32(rows);
//过滤参数
List <CommonSearchModel> parasD = null;
if (!string.IsNullOrEmpty(requestStringPar))
{
parasD = JsonConvert.DeserializeObject <List <CommonSearchModel> >(requestStringPar);;
}
int records = SysDataHelper <sys_action> .ResultDataCount_New(parasD);
int total = (int)Math.Ceiling((float)records / (float)rowsint);
var dataList = SysDataHelper <sys_action> .FindDataByPageFilter(parasD,
string.IsNullOrEmpty(setting.sortColumn)? "createtime" : setting.sortColumn + " " + setting.sortOrder, pageIndex, rowsint).ToList();
var jsonData = new
{
total = total,
page = pageIndex,
records = records,
rows = dataList
};
return(Json(jsonData, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 分页的数据
/// </summary>
/// <returns></returns>
public JsonResult GetData()
{
string requestStringPar = Request["customPar"];
string page = Request["page"]; //当前页
string rows = Request["rows"]; //每页显示
int pageIndex = Convert.ToInt32(page); //当前页
int rowsint = Convert.ToInt32(rows);
//过滤参数
List <CommonSearchModel> parasli = null;
if (!string.IsNullOrEmpty(requestStringPar))
{
parasli = JsonConvert.DeserializeObject <List <CommonSearchModel> >(requestStringPar);
}
int records = SysDataHelper <T_Sys_DEPARTMENTINFO> .ResultDataCount_New(parasli);
int total = (int)Math.Ceiling((float)records / (float)rowsint);
var dataList = SysDataHelper <T_Sys_DEPARTMENTINFO> .FindDataByPageFilter(parasli, "DEPTID", pageIndex, rowsint).ToList();
var jsonData = new
{
total = total,
page = pageIndex,
records = records,
rows = dataList
};
return(Json(jsonData));
}
/// <summary>
/// 分页的数据
/// </summary>
/// <returns></returns>
public JsonResult GetData(GridSettings setting)
{
string requestStringPar = Request["customPar"];
string page = Request["page"]; //当前页
string rows = Request["rows"]; //每页显示
int pageIndex = Convert.ToInt32(page); //当前页
int rowsint = Convert.ToInt32(rows);
//过滤参数
List <CommonSearchModel> parasD = null;
if (!string.IsNullOrEmpty(requestStringPar))
{
parasD = JsonConvert.DeserializeObject <List <CommonSearchModel> >(requestStringPar);;
}
int records = SysDataHelper <T_Sys_Users> .ResultDataCount_New(parasD);
int total = (int)Math.Ceiling((float)records / (float)rowsint);
List <T_Sys_Users> usersList = null;
try
{
usersList = SysDataHelper <T_Sys_Users> .FindDataByPageFilter(parasD,
string.IsNullOrEmpty(setting.sortColumn)? "UserId" : setting.sortColumn + " " + setting.sortOrder, pageIndex, rowsint).ToList();
}
catch (Exception ex)
{
throw;
}
var jsonData = new
{
total = total,
page = pageIndex,
records = records,
rows = (
from sta in usersList
select new
{
i = sta.UserId,
cell = new object[]
{
sta.UserId,
sta.UserName,
sta.RealName,
sta.Email,
sta.Sex == 0?"男":"女",
sta.Tel,
DateTime.Parse(sta.CreateDate.ToString()).ToString("yyyy-MM-dd")
}
}
).ToArray()
};
return(Json(jsonData, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 获得subgrid的数据
/// </summary>
/// <param name="setting"></param>
/// <param name="id"></param>
/// <returns></returns>
public JsonResult GetData(GridSettings setting, int?id = 0)
{
string requestStringPar = Request["customPar"];
string page = Request["page"]; //当前页
string rows = Request["rows"]; //每页显示
int pageIndex = Convert.ToInt32(page); //当前页
int rowsint = Convert.ToInt32(rows);
//过滤参数
List <CommonSearchModel> parasD = null;
if (!string.IsNullOrEmpty(requestStringPar))
{
parasD = JsonConvert.DeserializeObject <List <CommonSearchModel> >(requestStringPar);;
}
int records = SysDataHelper <T_Bas_Module> .ResultDataCount_New(parasD,
M => M.ParentID == id && M.ApplicationID == 1);
int total = (int)Math.Ceiling((float)records / (float)rowsint);
var dataList = SysDataHelper <T_Bas_Module> .FindDataByPageFilter(parasD,
string.IsNullOrEmpty(setting.sortColumn)? "MouduleID" : setting.sortColumn + " " + setting.sortOrder, pageIndex, rowsint,
M => M.ParentID == id && M.ApplicationID == 1).ToList();
var jsonData = new
{
total = total,
page = pageIndex,
records = records,
rows = (
from sta in dataList
select new
{
i = sta.MouduleID,
cell = new object[]
{
sta.MouduleID,
sta.MouduleName,
sta.IsUse == 0?"是":"否",
"<img src='../Content/ModulesImages/" + sta.IcoPath + "' width='20' height='20' alt='' />",
sta.MenuUrl,
sta.IsFuntion == 0?"有":"无",
sta.CreateDate.Value.ToString("yyyy-MM-dd")
}
}
).ToArray()
};
return(Json(jsonData, JsonRequestBehavior.AllowGet));
}
