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