public JsonResult IndexList(JTableData adata) { PagingInfo pi = new PagingInfo() { BeginIndex = adata.iDisplayStart + 1, EndIndex = adata.iDisplayStart + adata.iDisplayLength, TableName = "t_d_redpack op", Fileds = "*", SortFields = "id desc" }; //if (!string.IsNullOrEmpty(adata.sSearch)) //{ // pi.Conditions = " op.username like '%'+@key+'%' "; // pi.Parameters.Add("key", adata.sSearch); //} RedPackService x_rpService = new RedPackService(); var list = x_rpService.GetPaging(pi); JTableResult <RedPack> ar = new JTableResult <RedPack>() { sEcho = adata.sEcho, iTotalRecords = pi.RecordCount, iTotalDisplayRecords = pi.RecordCount, aaData = list }; return(Json(ar, JsonRequestBehavior.AllowGet)); }
public JsonResult UserListData(JTableData adata) { PagingInfo pi = new PagingInfo() { BeginIndex = adata.iDisplayStart + 1, EndIndex = adata.iDisplayStart + adata.iDisplayLength, TableName = "t_d_redpack_list rpl inner join t_d_redpack rp on rp.ID = rpl.pack_id inner join t_d_user u on u.ID = rpl.user_id", Fileds = "u.nickname, u.openid, rp.rbname, rpl.*", SortFields = " rpl.id desc" }; if (!string.IsNullOrEmpty(adata.sSearch)) { pi.Conditions = " u.nickname like '%'+@key+'%' "; pi.Parameters.Add("key", adata.sSearch); } RedPackListService x_rpService = new RedPackListService(); var list = x_rpService.GetPaging(pi); JTableResult <RedPackListInfo> ar = new JTableResult <RedPackListInfo>() { sEcho = adata.sEcho, iTotalRecords = pi.RecordCount, iTotalDisplayRecords = pi.RecordCount, aaData = list }; return(Json(ar, JsonRequestBehavior.AllowGet)); }
public JsonResult RoleList(JTableData adata) { PagingInfo pi = new PagingInfo() { BeginIndex = adata.iDisplayStart + 1, EndIndex = adata.iDisplayStart + adata.iDisplayLength, TableName = "t_d_role op", Fileds = "*", SortFields = "id desc" }; if (!string.IsNullOrEmpty(adata.sSearch)) { pi.Conditions = " op.rolename like '%'+@key+'%' or op.rolecode like '%'+@key+'%'"; pi.Parameters.Add("key", adata.sSearch); } RoleService x_opService = new RoleService(); var list = x_opService.GetPaging(pi); JTableResult <RoleInfo> ar = new JTableResult <RoleInfo>() { sEcho = adata.sEcho, iTotalRecords = pi.RecordCount, iTotalDisplayRecords = pi.RecordCount, aaData = list }; return(Json(ar, JsonRequestBehavior.AllowGet)); }
public static JsonNetResult JsonOK() { var data = new JTableResult { Result = "OK" }; return(new JsonNetResult(data)); }
/// <summary> /// 分页查询页面 /// </summary> /// <param name="adata"></param> /// <returns></returns> public JsonResult PageList(JTableData adata) { string username = Request["username"]; int orgId = 0; if (!string.IsNullOrEmpty(Request["orgid"])) { orgId = Convert.ToInt32(Request["orgid"]); } PagingInfo pi = new PagingInfo() { BeginIndex = adata.iDisplayStart + 1, EndIndex = adata.iDisplayStart + adata.iDisplayLength, TableName = "t_d_operator op", Fileds = "*", SortFields = "id desc" }; if (!string.IsNullOrEmpty(adata.sSearch)) { pi.Conditions = " op.username like '%'+@key+'%' "; pi.Parameters.Add("key", adata.sSearch); } OperatorService x_opService = new OperatorService(); var list = x_opService.GetPaging(pi); JTableResult <OperatorInfo> ar = new JTableResult <OperatorInfo>() { sEcho = adata.sEcho, iTotalRecords = pi.RecordCount, iTotalDisplayRecords = pi.RecordCount, aaData = list }; return(Json(ar, JsonRequestBehavior.AllowGet)); }