/// <summary>
/// 绑定数据列表
/// </summary>
/// <returns></returns>
private string ListBindGn()
{
string page = Request["page"];
string rows = Request["pagesize"];
string key = Request["key"];
string gn = Request["gn"];
int pageNumber = int.Parse(page);
int pageSize = int.Parse(rows);
string where = string.Empty;
object[] values = new object[7];
where += " and T.SFSC=:SFSC";
values[0] = "N";
where += " and b.DWBM=:DWBM";
values[1] = UserInfo.DWBM;
if (!string.IsNullOrEmpty(key))
{
where += " and( T.MC like :MC or T.GH like :GH or T.DLBM like :DLBM or T.GZZH like :GZZH)";
values[2] = "%" + key + "%";
values[3] = "%" + key + "%";
values[4] = "%" + key + "%";
values[5] = "%" + key + "%";
}
if (!string.IsNullOrEmpty(gn))
{
where += " and b.GNBM=:GNBM";
values[6] = gn;
}
EDRS.BLL.XT_ZZJG_RYBM bll = new EDRS.BLL.XT_ZZJG_RYBM(this.Request);
DataSet ds = bll.GetListByPageAndGn(where, "", (pageSize * pageNumber) - pageSize + 1, (pageSize * pageNumber), values);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
//数据日志
OperateLog.AddLog(OperateLog.LogType.功能权限管理Web, "获取人员功能权限成功", UserInfo, UserRole, this.Request);
int count = bll.GetRecordCountAndGn(where, values);
return("{\"Total\":" + count + ",\"Rows\":" + JsonHelper.JsonString(ds.Tables[0]) + "}");
}
//数据日志
OperateLog.AddLog(OperateLog.LogType.功能权限管理Web, "获取人员功能权限未找到数据", UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.error, "", null));
}
/// <summary>
/// 绑定人员
/// </summary>
/// <returns></returns>
private string GetPeople()
{
string page = Request["page"];
string rows = Request["pagesize"];
string key = Request["condition"];
int pageNumber = int.Parse(page);
int pageSize = int.Parse(rows);
string where = string.Empty;
object[] values = new object[6];
where += " and SFSC=:SFSC";
values[0] = "N";
where += " and DWBM=:DWBM";
values[1] = UserInfo.DWBM;
if (!string.IsNullOrEmpty(key))
{
string value = JsonHelper.DeserializeObjectKey(key, "value");
if (!string.IsNullOrEmpty(value))
{
where += " and( MC like :MC or GH like :GH or DLBM like :DLBM or GZZH like :GZZH)";
values[2] = "%" + value + "%";
values[3] = "%" + value + "%";
values[4] = "%" + value + "%";
values[5] = "%" + value + "%";
}
}
EDRS.BLL.XT_ZZJG_RYBM bll = new EDRS.BLL.XT_ZZJG_RYBM(this.Request);
DataSet ds = bll.GetListByPage(where, "", (pageSize * pageNumber) - pageSize + 1, (pageSize * pageNumber), values);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
//数据日志
OperateLog.AddLog(OperateLog.LogType.功能权限管理Web, "阅卷分配获取人员信息成功", UserInfo, UserRole, this.Request);
int count = bll.GetRecordCount(where, values);
return("{\"Total\":" + count + ",\"Rows\":" + JsonHelper.JsonString(ds.Tables[0]) + "}");
}
//数据日志
OperateLog.AddLog(OperateLog.LogType.功能权限管理Web, "阅卷分配未找到相关人员信息", UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.error, "未找到任何人员信息", null));
}
