/// <summary> /// 绑定列表 /// </summary> /// <returns></returns> public string ListBind() { int count = 0; DataTable dt = GetList(ref count); if (dt != null && dt.Rows.Count > 0) { string type = Request["type"]; if (type == "Graph") { //数据日志 OperateLog.AddLog(OperateLog.LogType.单位卷宗统计Web, "单位卷宗制作情况统计图形获取成功", UserInfo, UserRole, this.Request); return(StatisticsDataHelper.GetGraph(dt, new String[] { "AJNUM", "YZZNUM", "WZZNUM", "JNUM", "MLNUM", "WJNUM", "WJYNUM" }, "DWMC")); } else { //数据日志 OperateLog.AddLog(OperateLog.LogType.单位卷宗统计Web, "单位卷宗制作情况统计数据获取成功", UserInfo, UserRole, this.Request); return("{\"Total\":" + count + ",\"Rows\":" + JsonHelper.JsonString(dt) + "}"); } } //数据日志 OperateLog.AddLog(OperateLog.LogType.单位卷宗统计Web, "未找到单位卷宗制作情况统计信息", UserInfo, UserRole, this.Request); return(ReturnString.JsonToString(Prompt.error, "未找到单位卷宗制作情况统计信息", null)); }
/// <summary> /// 绑定列表 /// </summary> /// <returns></returns> public string ListBind() { string type = Request["type"]; string page = Request["page"]; string rows = Request["pagesize"]; string key = Request["key"]; string casename = Request["casename"]; string dutyman = Request["dutyman"]; string dwbm = Request["dwbm"]; string timebegin = Request["timebegin"]; string timeend = Request["timeend"]; int pageNumber = int.Parse(page); int pageSize = int.Parse(rows); string where = string.Empty; object[] values = new object[0]; if (!string.IsNullOrEmpty(key)) { where += " and a.BMSAH like '%" + StringPlus.ReplaceSingle(key) + "%'"; } if (!string.IsNullOrEmpty(casename)) { where += " and a.JZMC like '%" + StringPlus.ReplaceSingle(casename) + "%'"; } if (!string.IsNullOrEmpty(dwbm)) { where += " and c.DWMC like '%" + StringPlus.ReplaceSingle(dwbm) + "%'"; } if (!string.IsNullOrEmpty(dutyman)) { where += " and a.JZSCRXM like '%" + StringPlus.ReplaceSingle(dutyman) + "%'"; } if (!string.IsNullOrEmpty(timebegin)) { where += " and a.CJSJ >= to_date('" + StringPlus.ReplaceSingle(timebegin) + "','yyyy-mm-dd')"; } if (!string.IsNullOrEmpty(timeend)) { where += " and a.CJSJ <= to_date('" + Convert.ToDateTime(StringPlus.ReplaceSingle(timeend)).AddDays(1).ToString("yyyy-MM-dd") + "','yyyy-mm-dd')"; } EDRS.BLL.DataStatistics bll = new EDRS.BLL.DataStatistics(this.Request); Decimal count; DataSet ds = bll.GetJZNumberByReport(where, UserInfo.DWBM, UserInfo.GH, "1", (int)EnumConfig.文件存储空间大小分配, out count, values); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { DataTable dt = ds.Tables[0]; if (type == "Graph") { //数据日志 OperateLog.AddLog(OperateLog.LogType.卷宗数量统计Web, "卷宗数量统计图形获取成功", UserInfo, UserRole, this.Request); return(StatisticsDataHelper.GetGraph(dt, new String[] { "WJDX" }, "WJDX") + "," + (count * 1024 * 1024 * 1024)); } else { //数据日志 OperateLog.AddLog(OperateLog.LogType.卷宗数量统计Web, "卷宗数量统计列表获取成功", UserInfo, UserRole, this.Request); return("{\"Total\":" + 1 + ",\"Rows\":" + JsonHelper.JsonString(dt) + "}"); } } //数据日志 OperateLog.AddLog(OperateLog.LogType.卷宗数量统计Web, "未找到卷宗统计信息", UserInfo, UserRole, this.Request); return(ReturnString.JsonToString(Prompt.error, "未找到卷宗统计信息", null)); }