/// <summary>
/// 绑定数据
/// </summary>
/// <param name="count"></param>
/// <returns></returns>
private DataTable GetListBind(out int count)
{
int pageIndex = Convert.ToInt32(Request.Form["page"]);
int pageSize = Convert.ToInt32(Request.Form["pagesize"]);
//where
string b_date = Request.Form["b_date"];
string e_date = Request.Form["e_date"];
string username = Request.Form["username"];
string unit = Request.Form["unit"];
//排序
string sortname = Request.Form["sortname"];
string sortorder = Request.Form["sortorder"];
if (string.IsNullOrEmpty(sortname) || sortname.ToLower() == "DWMC")
{
sortname = "cbdw_bm";
}
sortname += " " + sortorder;
string where = "";
string whereAj = "";
string whereRy = "";
List <object> values = new List <object>();
if (!string.IsNullOrEmpty(b_date))
{
//JZ.Cjsj（创建时间） / JZ.JZSCSJ（上传时间）
where += " and JZCZSJ >= to_date('" + Convert.ToDateTime(b_date).ToShortDateString() + "','yyyy-mm-dd')";
whereAj += " and JZSCSJ >= to_date('" + Convert.ToDateTime(b_date).ToShortDateString() + "','yyyy-mm-dd')";
}
if (!string.IsNullOrEmpty(e_date))
{
where += " and JZCZSJ <= to_date('" + Convert.ToDateTime(e_date).AddDays(1).ToShortDateString() + "','yyyy-mm-dd')";
whereAj += " and JZSCSJ <= to_date('" + Convert.ToDateTime(e_date).AddDays(1).ToShortDateString() + "','yyyy-mm-dd')";
}
if (!string.IsNullOrEmpty(username))
{
whereRy += " and MC LIKE '%" + username + "%'";
}
if (!string.IsNullOrEmpty(unit))
{
string dwbms = unit.Replace(";", ",");
where += " and a.DWBM in (" + StringPlus.ReplaceSingle(dwbms) + ")";
whereAj += " and cbdw_bm in (" + StringPlus.ReplaceSingle(dwbms) + ")";
whereRy += " and a.DWBM in (" + StringPlus.ReplaceSingle(dwbms) + ")";
}
else
{
where += " and a.DWBM in (select distinct QXBM FROM XT_DM_QX where 1=1 AND JSBM IN (" + base.Jsbms + ") AND QXLX=0 AND trim(DWBM) = '" + base.UserInfo.DWBM + "' AND BMBM in (" + base.Bmbms + ") )";
whereAj += " and cbdw_bm in (select distinct QXBM FROM XT_DM_QX where 1=1 AND JSBM IN (" + base.Jsbms + ") AND QXLX=0 AND trim(DWBM) = '" + base.UserInfo.DWBM + "' AND BMBM in (" + base.Bmbms + ") )";
whereRy += " and a.DWBM in (select distinct QXBM FROM XT_DM_QX where 1=1 AND JSBM IN (" + base.Jsbms + ") AND QXLX=0 AND trim(DWBM) = '" + base.UserInfo.DWBM + "' AND BMBM in (" + base.Bmbms + ") )";
}
EDRS.BLL.DataStatistics bll = new EDRS.BLL.DataStatistics(Request);
DataTable dt = bll.GetYJTJ(where, whereAj, whereRy, sortname, pageIndex, pageSize, out count, values.ToArray());
return(dt);
}
/// <summary>
/// 获取案件统计详细
/// </summary>
/// <returns></returns>
private string GetDwSum()
{
string page = Request["page"];
string rows = Request["pagesize"];
int pageNumber = int.Parse(page);
int pageSize = int.Parse(rows);
//排序
string sortname = Request["sortname"];
string sortorder = Request["sortorder"];
if (string.IsNullOrEmpty(sortname) || sortname == "DWMC")
{
sortname = "DWBM";
}
sortname += " " + sortorder;
string where = string.Empty;
object[] values = new object[0];
//EDRS.BLL.XT_DM_QX bllQx = new EDRS.BLL.XT_DM_QX(Request);
//DataSet dsDwQx = bllQx.GetDwList(StringPlus.ReplaceSingle(base.Jsbms), base.UserInfo.DWBM, StringPlus.ReplaceSingle(base.Bmbms), "");
//if (dsDwQx != null && dsDwQx.Tables.Count > 0 && dsDwQx.Tables[0].Rows.Count > 0)
//{
// string dwbms = "";
// foreach (DataRow dr in dsDwQx.Tables[0].Rows)
// {
// dwbms += dr["QXBM"] + ",";
// }
// where += " and b.DWBM in (" + StringPlus.ReplaceSingle(dwbms.Substring(0, dwbms.Length - 1)) + ")";
//}
//else
// where += " and b.DWBM =" + base.UserInfo.DWBM;
where += " and b.DWBM in (select distinct QXBM FROM XT_DM_QX where 1=1 AND JSBM IN (" + base.Jsbms + ") AND QXLX=0 AND trim(DWBM) = '" + base.UserInfo.DWBM + "' AND BMBM in (" + base.Bmbms + ") )";
EDRS.BLL.DataStatistics bll = new EDRS.BLL.DataStatistics(this.Request);
int count;
DataSet ds = bll.GetDwAjWjSum(where, UserInfo.DWBM, UserInfo.GH, sortname, (pageSize * pageNumber) - pageSize + 1, (pageSize * pageNumber), out count, values);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
DataTable dt = ds.Tables[0];
return("{\"Total\":" + count + ",\"Rows\":" + JsonHelper.JsonString(dt) + "}");
}
return(ReturnString.JsonToString(Prompt.error, "未找到统计信息", null));
}
/// <summary>
/// 数据绑定
/// </summary>
/// <param name="page"></param>
/// <param name="rows"></param>
/// <param name="key"></param>
/// <param name="casename"></param>
/// <param name="dutyman"></param>
/// <param name="ywbm"></param>
/// <param name="timebegin"></param>
/// <param name="timeend"></param>
/// <returns></returns>
//[WebMethod]
public string ListBind()
{
string page = Request["page"];
string rows = Request["pagesize"];
string key = Request["key"];
string casename = Request["casename"];
string dutyman = Request["dutyman"];
string timebegin = Request["timebegin"];
string timeend = Request["timeend"];
string ywbm = Request["ywbm"];
string dwbm = Request["dwbm"];
string caseajlb = Request["caseajlb"];
string sortName = Request["sortName"];
string sortOrder = Request["sortOrder"];
string orderBy = string.Empty;
//自定义排序
if (string.IsNullOrEmpty(sortName))
{
orderBy = "CBDW_BM ASC";
}
else
{
orderBy = sortName + " " + sortOrder;
}
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.AJBH like '%" + StringPlus.ReplaceSingle(key) + "%'";
}
if (!string.IsNullOrEmpty(casename))
{
where += " and AJMC like '%" + StringPlus.ReplaceSingle(casename) + "%'";
}
if (!string.IsNullOrEmpty(dutyman))
{
where += " and CBR like '%" + StringPlus.ReplaceSingle(dutyman) + "%'";
}
if (!string.IsNullOrEmpty(ywbm))
{
where += " and c.YWBM='" + StringPlus.ReplaceSingle(ywbm) + "'";
}
if (!string.IsNullOrEmpty(timebegin))
{
where += " and b.cjsj >= to_date('" + StringPlus.ReplaceSingle(timebegin) + "','yyyy-mm-dd')";
}
if (!string.IsNullOrEmpty(timeend))
{
where += " and b.cjsj <= to_date('" + Convert.ToDateTime(StringPlus.ReplaceSingle(timeend)).AddDays(1).ToString("yyyy-MM-dd") + "','yyyy-mm-dd')";
}
if (!string.IsNullOrEmpty(dwbm))
{
string dwbms = dwbm.Replace(";", ",");
where += " and trim(CBDW_BM) in (" + StringPlus.ReplaceSingle(dwbms) + ")";
}
if (!string.IsNullOrEmpty(caseajlb))
{
string caseajlbs = caseajlb.Replace(";", ",");
where += " and trim(b.AJLB_BM) in ('" + caseajlbs + "')";
}
EDRS.BLL.DataStatistics bll = new EDRS.BLL.DataStatistics(this.Request);
int count;
DataSet ds = bll.GetDwJzZzQuery(where, UserInfo.DWBM, UserInfo.GH, orderBy + ",T.jnum desc", (pageSize * pageNumber) - pageSize + 1, (pageSize * pageNumber), out count, values);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
//数据日志
OperateLog.AddLog(OperateLog.LogType.单位卷宗制作情况查询Web, "单位卷宗制作情况查询成功", UserInfo, UserRole, this.Request);
DataTable dt = ds.Tables[0];
return("{\"Total\":" + count + ",\"Rows\":" + JsonHelper.JsonString(dt) + "}");
}
//数据日志
OperateLog.AddLog(OperateLog.LogType.单位卷宗制作情况查询Web, "单位卷宗制作情况查询未找到信息", UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.error, "未找到" + ((VersionName)0).ToString() + "信息", null));
}
/// <summary>
/// 导出Excel
/// </summary>
/// <returns></returns>
private string DeriveData()
{
string page = Request["page"];
string rows = Request["pagesize"];
string key = Request["key"];
string casename = Request["casename"];
string dutyman = Request["dutyman"];
string timebegin = Request["timebegin"];
string timeend = Request["timeend"];
string ywbm = Request["ywbm"];
string dwbm = Request["dwbm"];
string caseajlb = Request["caseajlb"];
string sortName = Request["sortName"];
string sortOrder = Request["sortOrder"];
string orderBy = string.Empty;
//自定义排序
if (string.IsNullOrEmpty(sortName))
{
orderBy = "CBDW_BM ASC";
}
else
{
orderBy = sortName + " " + sortOrder;
}
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.AJBH like '%" + StringPlus.ReplaceSingle(key) + "%'";
}
if (!string.IsNullOrEmpty(casename))
{
where += " and AJMC like '%" + StringPlus.ReplaceSingle(casename) + "%'";
}
if (!string.IsNullOrEmpty(dutyman))
{
where += " and CBR like '%" + StringPlus.ReplaceSingle(dutyman) + "%'";
}
if (!string.IsNullOrEmpty(ywbm))
{
where += " and c.YWBM='" + StringPlus.ReplaceSingle(ywbm) + "'";
}
if (!string.IsNullOrEmpty(timebegin))
{
where += " and b.cjsj >= to_date('" + StringPlus.ReplaceSingle(timebegin) + "','yyyy-mm-dd')";
}
if (!string.IsNullOrEmpty(timeend))
{
where += " and b.cjsj <= to_date('" + Convert.ToDateTime(StringPlus.ReplaceSingle(timeend)).AddDays(1).ToString("yyyy-MM-dd") + "','yyyy-mm-dd')";
}
if (!string.IsNullOrEmpty(dwbm))
{
string dwbms = dwbm.Replace(";", ",");
where += " and trim(CBDW_BM) in (" + StringPlus.ReplaceSingle(dwbms) + ")";
}
if (!string.IsNullOrEmpty(caseajlb))
{
string caseajlbs = caseajlb.Replace(";", ",");
where += " and trim(b.AJLB_BM) in ('" + caseajlbs + "')";
}
EDRS.BLL.DataStatistics bll = new EDRS.BLL.DataStatistics(this.Request);
int count;
DataSet ds = bll.GetDwJzZzQuery(where, UserInfo.DWBM, UserInfo.GH, orderBy + ",T.jnum desc", (pageSize * pageNumber) - pageSize + 1, (pageSize * pageNumber), out count, values);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
string ExcelFolder = "ExcelFolder";// Assistant.GetConfigString("ExcelFolder");
string filename = DateTime.Now.ToString("yyyyMMddHHmmssff") + ".xls";
string msg = string.Empty;
if (ds.Tables[0].Rows.Count > 0)
{
DataTable dt = ds.Tables[0].Copy();
dt.Columns.Remove("RO");
dt.Columns.Remove("JZBH");
dt.Columns.Remove("BMSAH");
dt.Columns.Remove("AJLB_BM");
dt.Columns.Remove("CBDW_BM");
dt.Columns.Remove("CBBM_BM");
dt.Columns.Remove("CBBM_MC");
dt.Columns.Remove("CBRGH");
dt.Columns["AJMC"].ColumnName = "案件名称";
dt.Columns["AJBH"].ColumnName = "案件编号";
dt.Columns["WSBH"].ColumnName = "文书编号";
dt.Columns["WSMC"].ColumnName = "文书名称";
dt.Columns["AJLB_MC"].ColumnName = "案件类别";
dt.Columns["XYR"].ColumnName = "嫌疑人姓名";
dt.Columns["SLRQ"].ColumnName = "立案时间";
dt.Columns["CBDW_MC"].ColumnName = "立卷单位";
dt.Columns["CBR"].ColumnName = "立卷人";
dt.Columns["JNUM"].ColumnName = "卷数";
dt.Columns["WJNUM"].ColumnName = "文件数";
dt.Columns["WJYNUM"].ColumnName = "文件页数";
msg = DataToExcel_Ex.Export(dt, "卷宗制作情况", Server.MapPath("/" + ExcelFolder + "/" + filename));
//filename = dte.DataExcel(ds.Tables[0], "卷宗制作情况", FilePath, nameList, null);
}
if (string.IsNullOrEmpty(msg))
{
return(ReturnString.JsonToString(Prompt.win, "/" + ExcelFolder + "/" + filename, null));
}
else
{
return(ReturnString.JsonToString(Prompt.error, StringPlus.String2Json(msg), null));
}
}
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));
}
/// <summary>
/// 获取绑定列表
/// </summary>
/// <param name="count"></param>
/// <returns></returns>
private DataTable GetList(ref int count)
{
string page = Request["page"];
string rows = Request["pagesize"];
string key = Request["key"];
string casename = Request["casename"];
string dutyman = Request["dutyman"];
string timebegin = Request["timebegin"];
string timeend = Request["timeend"];
string dwbm = Request["dwbm"];
string sortname = Request["sortname"]; // CBDW_MC
string sortorder = Request["sortorder"]; //asc
if (string.IsNullOrEmpty(sortname) || sortname == "CBDW_MC")
{
sortname = "CBDW_BM";
}
sortname += " " + sortorder;
int pageNumber = int.Parse(page);
int pageSize = int.Parse(rows);
string where = string.Empty;
object[] values = new object[0];
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')";
}
//获取单位编码
string where_dw = "";
EDRS.BLL.XT_DM_QX bllQx = new EDRS.BLL.XT_DM_QX(this.Request);
if (!string.IsNullOrEmpty(dwbm))
{
string[] dwbms = dwbm.Split(new char[] { ';' }, StringSplitOptions.RemoveEmptyEntries);
if (dwbms.Length > 0)
{
where += " and a.CBDW_BM in (";
for (int i = 0; i < dwbms.Length; i++)
{
where += "'" + dwbms[i] + "'";
if (i < dwbms.Length - 1)
{
where += ",";
}
}
where += ")";
}
// where_dw = " and jz.dwbm in (" + dwbms + ")";
}
//else
//{
//where += " and jz.dwbm in (select distinct QXBM FROM XT_DM_QX where 1=1 AND JSBM IN (" + base.Jsbms + ") AND QXLX=0 AND trim(DWBM) = '" + base.UserDwbm.DWBM + "' AND BMBM in (" + base.Bmbms + ") )";
//where_dw = " and jz.dwbm in (select distinct QXBM FROM XT_DM_QX where 1=1 AND JSBM IN (" + base.Jsbms + ") AND QXLX=0 AND trim(DWBM) = '" + base.UserDwbm.DWBM + "' AND BMBM in (" + base.Bmbms + ") )";
//}
// where_dw = string.Format(" and JSBM IN ({0}) AND trim(DWBM) = '{1}' AND BMBM in ({2}) ", base.Jsbms, base.UserDwbm.DWBM, base.Bmbms);
//获取案件类别
EDRS.BLL.DataStatistics bll = new EDRS.BLL.DataStatistics(this.Request);
DataSet ds = bll.GetDwJzZzStatistics(where, where_dw, UserInfo.DWBM, UserInfo.GH, base.Jsbms, base.Bmbms, sortname, (pageSize * pageNumber) - pageSize + 1, (pageSize * pageNumber), out count, values);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
return(ds.Tables[0]);
}
return(null);
}
/// <summary>
/// 获取案件统计详细
/// </summary>
/// <returns></returns>
private string GetDetailByLb()
{
string dwbm = Request["dwbm"];
string timebegin = Request["timebegin"];
string timeend = Request["timeend"];
//排序
string sortname = Request["sortname"];
string sortorder = Request["sortorder"];
if (string.IsNullOrEmpty(sortname) || sortname == "YWMC")
{
sortname = "ajlb_bm";
}
sortname += " " + sortorder;
string where = string.Empty;
object[] values = new object[0];
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')";
}
string where_dw = "";
if (!string.IsNullOrEmpty(dwbm))
{
string[] dwbms = dwbm.Split(new char[] { ';' }, StringSplitOptions.RemoveEmptyEntries);
if (dwbms.Length > 0)
{
where += " and a.CBDW_BM in (";
for (int i = 0; i < dwbms.Length; i++)
{
where += "'" + dwbms[i] + "'";
if (i < dwbms.Length - 1)
{
where += ",";
}
}
where += ")";
}
}
EDRS.BLL.DataStatistics bll = new EDRS.BLL.DataStatistics(this.Request);
DataSet ds = bll.GetDwJzZzStatisticsByLb(where, where_dw, UserInfo.DWBM, UserInfo.GH, base.Jsbms, base.Bmbms, "ajlb_bm", values);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
DataView dv = ds.Tables[0].DefaultView;
dv.Sort = sortname;
return("{\"Total\":10,\"Rows\":" + JsonHelper.JsonString(dv.ToTable()) + "}");
}
return(ReturnString.JsonToString(Prompt.error, "未找到统计信息", null));
}
