public ActionResult GetPageDetailList(string keyword = null, string Depart = null, int page = 1, string sidx = "", string sord = "asc")
{
//取得按钮权限
List <string> BtnList = FlowHelper.GetBtnAuthorityForPage("明细权限");
ViewBag.BtnList = BtnList;
#region 通过存储过程获得数据
PageInfo pager = new PageInfo();
pager.PageSize = 50;
pager.CurrentPageIndex = Math.Max(1, page);
StringBuilder strSql = new StringBuilder(" 1=1");
if (!string.IsNullOrWhiteSpace(keyword))
{
strSql.Append(" and (ModelName like '%" + keyword + "%' or PageName like '%" + keyword + "%')");
}
string tableName = "tblPageDetail";
string orderBy = "ModelName,PageName,DetailName";
if (!string.IsNullOrWhiteSpace(sidx))
{
orderBy = sidx + " " + sord;
}
int totalCount = 0;
string queryFields = "TblRcdId, ModelName,PageName,DetailName,Remark";
string where = strSql.ToString();
DataTable ds = DBContext.DataDecision.QueryPageByProc(tableName, orderBy, out totalCount, queryFields, where, pager.CurrentPageIndex, pager.PageSize);
List <tblPageDetail> result = new List <tblPageDetail>();
result = ds.ToList <tblPageDetail>();
//添加序号
CommExtension.AddXuHao(result, pager.PageSize, pager.CurrentPageIndex);
#endregion
jqGridData RM = new jqGridData();
RM.page = pager.CurrentPageIndex;
RM.rows = result;
RM.total = (totalCount % pager.PageSize == 0 ? totalCount / pager.PageSize : totalCount / pager.PageSize + 1);
RM.records = totalCount;
return(Json(RM, JsonRequestBehavior.AllowGet));
}
public ActionResult GetButtonNameDataList(int page = 1, int rows = 20, string keyword = null, string sidx = "ButtonName", string sord = "asc")
{
PageInfo pager = new PageInfo();
pager.PageSize = rows;
pager.CurrentPageIndex = (page != 0 ? (int)page : 1);
#region 通过存储过程获得数据
string strSql = "1=1";
if (!string.IsNullOrWhiteSpace(keyword))
{
strSql += " and ButtonName like '%" + keyword + "%'";
}
string tableName = "tblButtonName";
string orderBy = "ButtonName";
if (!string.IsNullOrWhiteSpace(sidx))
{
orderBy = sidx + " " + sord;
}
int totalCount = 0;
string queryFields = "*";
string where = strSql.ToString();
whe = where;
DataTable ds = DBContext.DataDecision.QueryPageByProc(tableName, orderBy, out totalCount, queryFields, where, pager.CurrentPageIndex, pager.PageSize);
List <tblButtonName> result = new List <tblButtonName>();
result = ds.ToList <tblButtonName>();
//添加序号
CommExtension.AddXuHao(result, pager.PageSize, pager.CurrentPageIndex);
#endregion
jqGridData RM = new jqGridData();
RM.page = pager.CurrentPageIndex;
RM.rows = result;
RM.total = (totalCount % pager.PageSize == 0 ? totalCount / pager.PageSize : totalCount / pager.PageSize + 1);
RM.records = totalCount;
return(Json(RM, JsonRequestBehavior.AllowGet));
}
