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