/// <summary>
/// 导出Excel
/// </summary>
/// <returns></returns>
private string DeriveData()
{
int count;
DataTable ds = GetListBind(out count);
if (ds != null && ds.Rows.Count > 0)
{
string ExcelFolder = "ExcelFolder";// Assistant.GetConfigString("ExcelFolder");
//利用excel对象
string filename = DateTime.Now.ToString("yyyyMMddHHmmssff") + ".xls";
string msg = string.Empty;
if (ds.Rows.Count > 0)
{
ds.Columns.Remove("RO");
ds.Columns.Remove("CBDW_BM");
ds.Columns.Remove("JZSCRGH");
ds.Columns["CBDW_MC"].ColumnName = "承办单位";
ds.Columns["JZSCRXM"].ColumnName = "制作人员";
ds.Columns["AJCOUNT"].ColumnName = ((VersionName)0).ToString() + "数量";
ds.Columns["JCOUNT"].ColumnName = "卷数";
ds.Columns["MLCOUNT"].ColumnName = "目录数";
ds.Columns["WJCOUNT"].ColumnName = "文件页数";
msg = DataToExcel_Ex.Export(ds, "卷宗制作工作量统计", 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>
/// 导出Excel
/// </summary>
/// <returns></returns>
private string DeriveData()
{
int count = 0;
DataTable dt = GetList(ref count);
if (dt != null && dt.Rows.Count > 0)
{
string ExcelFolder = "ExcelFolder";// Assistant.GetConfigString("ExcelFolder");
string filename = DateTime.Now.ToString("yyyyMMddHHmmssff") + ".xls";
string msg = string.Empty;
if (dt != null && dt.Rows.Count > 0)
{
dt.Columns.Remove("Ro");
dt.Columns.Remove("CBDW_BM");
dt.Columns["CBDW_MC"].ColumnName = "承办单位";
dt.Columns["AJNUM"].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(dt, "卷宗制作量统计", 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>
/// 导出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>
/// 导出Excel
/// </summary>
/// <returns></returns>
private string DeriveData()
{
EDRS.BLL.TYYW_GG_AJJBXX bll = new EDRS.BLL.TYYW_GG_AJJBXX(Request);
DataTable dt = bll.ListBinTable(Request, UserInfo.DWBM, UserInfo.GH);
if (dt != null && dt.Rows.Count > 0)
{
string ExcelFolder = "ExcelFolder";// Assistant.GetConfigString("ExcelFolder");
string filename = DateTime.Now.ToString("yyyyMMddHHmmssff") + ".xls";
string msg = string.Empty;
if (dt.Rows.Count > 0)
{
dt.Columns["ZZZT"].ColumnName = "制作状态";
dt.Columns["BMSAH"].ColumnName = "案号名称";
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["SARQ"].ColumnName = "收案日期";
dt.Columns["JARQ"].ColumnName = "结案日期";
dt.Columns["GDRQ"].ColumnName = "归档日期";
if (dt.Columns.Contains("CBDW_MC"))
{
dt.Columns["CBDW_MC"].ColumnName = "单位";
}
if (dt.Columns.Contains("AJ_DWMC"))
{
dt.Columns["AJ_DWMC"].ColumnName = "单位";
}
dt.Columns["CBR"].ColumnName = "承办人";
DataTable dtCopy = dt.Copy();
for (int i = 0; i < dt.Columns.Count; i++)
{
if (!Regex.IsMatch(dt.Columns[i].ColumnName.ToString(), @"[\u4e00-\u9fbb]+"))
{
dtCopy.Columns.Remove(dt.Columns[i].ColumnName.ToString());
}
}
object zzzt;
object[] desc;
for (int i = 0; i < dtCopy.Rows.Count; i++)
{
zzzt = Enum.Parse(typeof(EnumZzzt), dtCopy.Rows[i]["制作状态"].ToString(), true);
desc = zzzt.GetType().GetField(zzzt.ToString()).GetCustomAttributes(typeof(DescriptionAttribute), true);
if (desc != null && desc.Length > 0)
{
dtCopy.Rows[i]["制作状态"] = (desc[0] as DescriptionAttribute).Description;
}
}
msg = DataToExcel_Ex.Export(dtCopy, "案件基本情况", Server.MapPath("/" + ExcelFolder + "/" + filename));
// filename = dte.DataExcel(dt, ((VersionName)0).ToString()+"基本情况", FilePath, nameList, valueList);
}
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>
/// 导出Excel
/// </summary>
/// <returns></returns>
private string DeriveData()
{
string where = "";
List <object> values = new List <object>();
string unit = Request.Form["unit"]; //承办单位
string timebegin = Request.Form["timebegin"]; //开始日期
string timeend = Request.Form["timeend"];
//排序
string sortname = Request.Form["sortname"];
string sortorder = Request.Form["sortorder"];
if (string.IsNullOrEmpty(sortname) || sortname.ToLower() == "mm")
{
sortname = "mm";
}
sortname += " " + sortorder;
if (!string.IsNullOrEmpty(unit))
{
where += " and CBDW_BM IN( ";
where += "" + unit.Replace(";", ",") + ")";
}
else
{
where += " 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 + ") )";
}
if (!string.IsNullOrEmpty(timebegin))
{
where += " and aj.cjsj >= to_date('" + Convert.ToDateTime(timebegin).ToShortDateString() + "','yyyy-mm-dd')";
}
if (!string.IsNullOrEmpty(timeend))
{
where += " and aj.cjsj < to_date('" + Convert.ToDateTime(timeend).AddDays(1).ToShortDateString() + "','yyyy-mm-dd')";
}
where += " and trim(aj.ajlb_bm) in (select distinct QXBM FROM XT_DM_QX where 1=1 AND JSBM IN (" + base.Jsbms + ") AND QXLX=1 AND trim(DWBM) = '" + base.UserInfo.DWBM + "' AND BMBM in (" + base.Bmbms + ") )";
EDRS.BLL.EDRS_Report bll = new EDRS.BLL.EDRS_Report(Request);
string qxWhere = "";
DataSet ds = bll.GetCaseGroupMouth(where, qxWhere, sortname, values.ToArray());
if (ds != null && ds.Tables.Count > 0)
{
string ExcelFolder = "ExcelFolder";// Assistant.GetConfigString("ExcelFolder");
//利用excel对象
string filename = DateTime.Now.ToString("yyyyMMddHHmmssff") + ".xls";
string msg = string.Empty;
if (ds.Tables[0].Rows.Count > 0)
{
ds.Tables[0].Columns["MM"].ColumnName = "月份";
ds.Tables[0].Columns["AJCOUNT"].ColumnName = ((VersionName)0).ToString() + "数量";
ds.Tables[0].Columns["ZZCOUNT"].ColumnName = "案件制作数";
ds.Tables[0].Columns["JCOUNT"].ColumnName = "卷数";
ds.Tables[0].Columns["WCOUNT"].ColumnName = "文件数";
ds.Tables[0].Columns["PAGECOUNT"].ColumnName = "文件页数";
msg = DataToExcel_Ex.Export(ds.Tables[0], "卷宗月度统计表", Server.MapPath("/" + ExcelFolder + "/" + filename));
// filename = dte.DataExcel(ds.Tables[0], "卷宗月度统计表", FilePath, nameList, valueList);
}
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>
/// 导出Excel
/// </summary>
/// <returns></returns>
private string DeriveData()
{
//权限状态
EDRS.BLL.TYYW_GG_AJJBXX bll = new EDRS.BLL.TYYW_GG_AJJBXX(Request);
DataTable dt = bll.ListBinTable(Request, UserInfo.DWBM, UserInfo.GH, base.GetJsQxzt(), base.GetBmBm());
if (dt != null && dt.Rows.Count > 0)
{
string ExcelFolder = "ExcelFolder";// Assistant.GetConfigString("ExcelFolder");
string filename = DateTime.Now.ToString("yyyyMMddHHmmssff") + ".xls";
string msg = string.Empty;
if (dt.Rows.Count > 0)
{
if (dt.Columns.Contains("ISREGARD"))
{
dt.Columns.Remove("ISREGARD");
}
if (dt.Columns.Contains("SFZZ"))
{
dt.Columns.Remove("SFZZ");
}
dt.Columns.Remove("RO");
dt.Columns.Remove("JZSCRXM");
dt.Columns.Remove("CJSJ");
dt.Columns.Remove("GGCJSJ");
dt.Columns.Remove("BMSAH");
dt.Columns.Remove("CBBM_MC");
dt.Columns.Remove("DQJD");
dt.Columns.Remove("AJZT");
dt.Columns.Remove("DQRQ");
dt.Columns.Remove("BJRQ");
dt.Columns.Remove("WCRQ");
dt.Columns.Remove("GDRQ");
dt.Columns.Remove("AJLB_BM");
dt.Columns.Remove("CBDW_BM");
dt.Columns.Remove("SFZH");
dt.Columns.Remove("TARYXX");
dt.Columns.Remove("SHR");
dt.Columns.Remove("ZJS");
dt.Columns.Remove("DJJ");
dt.Columns.Remove("ZYS");
dt.Columns.Remove("JZPZ");
dt.Columns.Remove("JZSHRBH");
dt.Columns.Remove("JZSHR");
dt.Columns.Remove("JZSHSJ");
dt.Columns.Remove("JZBH");
dt.Columns["ZZZT"].ColumnName = "制作状态";
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 = "立案时间";
if (dt.Columns.Contains("CBDW_MC"))
{
dt.Columns["CBDW_MC"].ColumnName = "立卷单位";
}
if (dt.Columns.Contains("AJ_DWMC"))
{
dt.Columns["AJ_DWMC"].ColumnName = "立卷单位";
}
dt.Columns["CBR"].ColumnName = "立卷人";
object zzzt;
object[] desc;
for (int i = 0; i < dt.Rows.Count; i++)
{
zzzt = Enum.Parse(typeof(EnumZzzt), dt.Rows[i]["制作状态"].ToString(), true);
desc = zzzt.GetType().GetField(zzzt.ToString()).GetCustomAttributes(typeof(DescriptionAttribute), true);
if (desc != null && desc.Length > 0)
{
dt.Rows[i]["制作状态"] = (desc[0] as DescriptionAttribute).Description;
}
}
msg = DataToExcel_Ex.Export(dt, "案件基本情况", Server.MapPath("/" + ExcelFolder + "/" + filename));
// filename = dte.DataExcel(dt, ((VersionName)0).ToString()+"基本情况", FilePath, nameList, valueList);
}
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>
/// 导出Excel
/// </summary>
/// <returns></returns>
private string DeriveData()
{
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() == "cbdw_mc")
{
sortname = "CBDW_BM";
}
sortname += " " + sortorder;
string where = "";
List <object> values = new List <object>();
if (!string.IsNullOrEmpty(b_date))
{
//JZ.Cjsj（创建时间） / JZ.JZSCSJ（上传时间）
where += " and t1.Cjsj >= to_date('" + Convert.ToDateTime(b_date).ToShortDateString() + "','yyyy-mm-dd')";
}
if (!string.IsNullOrEmpty(e_date))
{
where += " and t1.Cjsj <= to_date('" + Convert.ToDateTime(e_date).AddDays(1).ToShortDateString() + "','yyyy-mm-dd')";
}
if (!string.IsNullOrEmpty(username))
{
where += " and JZ.JZSCRXM LIKE ";
where += "'%" + username + "%'";
}
if (!string.IsNullOrEmpty(unit))
{
string dwbms = unit.Replace(";", ",");
where += " and CBDW_BM in (" + StringPlus.ReplaceSingle(dwbms) + ")";
}
else
{
where += " 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 + ") )";
}
string qxWhere = " AND trim(DWBM) = '" + UserInfo.DWBM + "' AND JSBM in (" + Jsbms + ") AND BMBM in (" + Bmbms + ") AND QXLX = 0";
EDRS.BLL.EDRS_Report bll = new EDRS.BLL.EDRS_Report(Request);
int count;
DataSet ds = bll.GetCaseByPerson(where, qxWhere, Convert.ToInt32(pageSize), Convert.ToInt32(pageIndex), sortname, out count, values.ToArray());
if (ds != null && ds.Tables.Count > 0)
{
string ExcelFolder = "ExcelFolder";// Assistant.GetConfigString("ExcelFolder");
//利用excel对象
string filename = DateTime.Now.ToString("yyyyMMddHHmmssff") + ".xls";
string msg = string.Empty;
if (ds.Tables[0].Rows.Count > 0)
{
ds.Tables[0].Columns.Remove("RO");
ds.Tables[0].Columns.Remove("CBDW_BM");
ds.Tables[0].Columns.Remove("MCOUNT");
ds.Tables[0].Columns["CBDW_MC"].ColumnName = "承办单位";
ds.Tables[0].Columns["JZSCRXM"].ColumnName = "制作人员";
ds.Tables[0].Columns["AJCOUNT"].ColumnName = ((VersionName)0).ToString() + "数量";
ds.Tables[0].Columns["JCOUNT"].ColumnName = "卷数";
ds.Tables[0].Columns["WCOUNT"].ColumnName = "文件数";
ds.Tables[0].Columns["PAGECOUNT"].ColumnName = "文件页数";
msg = DataToExcel_Ex.Export(ds.Tables[0], "卷宗制作工作量统计", 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>
/// 导出Excel
/// </summary>
/// <returns></returns>
private string DeriveData()
{
string strWhere = "";
List <object> values = new List <object>();
int pageIndex = Convert.ToInt32(Request["page"]);
int pageSize = Convert.ToInt32(Request["pagesize"]);
string key = Request["key"]; //部门受案号
string timebegin = Request["timebegin"]; //开始日期
string timeend = Request["timeend"]; //结束日期
string unit = Request["unit"]; //承办单位
string ywbm = Request["ywbm"];
string caseajlb = Request["caseajlb"];
//排序
string sortname = Request["sortname"];
string sortorder = Request["sortorder"];
if (string.IsNullOrEmpty(sortname) || sortname.ToLower() == "cbdw_mc")
{
sortname = "CBDW_BM";
}
sortname += " " + sortorder;
// string qxWhere = "";
// qxWhere = " AND DWBM = '" + UserInfo.DWBM + "' AND JSBM in (" + Jsbms + ") AND BMBM in (" + Bmbms + ") AND QXLX = 0";
//选中时，筛选单位，否则查询所有有权限数据
EDRS.BLL.XT_DM_QX bllQx = new EDRS.BLL.XT_DM_QX(Request);
if (!string.IsNullOrEmpty(unit))
{
string dwbms = unit.Replace(";", ",");
strWhere += " and CBDW_BM in (" + StringPlus.ReplaceSingle(dwbms) + ")";
}
else if (string.IsNullOrEmpty(unit))
{
strWhere += " and AJ.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 + ") )";
}
//案件类别
if (!string.IsNullOrEmpty(caseajlb))
{
string caseajlbs = caseajlb.Replace(";", ",");
strWhere += " and trim(AJ.AJLB_BM) in (" + caseajlbs + ")";
}
else if (string.IsNullOrEmpty(caseajlb))
{
strWhere += " and trim(aj.ajlb_bm) in (select distinct QXBM FROM XT_DM_QX where 1=1 AND JSBM IN (" + base.Jsbms + ") AND QXLX=1 AND trim(DWBM) = '" + base.UserInfo.DWBM + "' AND BMBM in (" + base.Bmbms + ") )";
}
//业务
if (!string.IsNullOrEmpty(ywbm))
{
strWhere += " and LB.YWBM='" + StringPlus.ReplaceSingle(ywbm) + "'";
}
//strWhere += " and (select count(1) from yx_dzjz_jzml y where y.Bmsah=T1.Bmsah) > 0";//已关联
if (!string.IsNullOrEmpty(timebegin))
{
strWhere += " and aj.cjsj >= to_date('" + Convert.ToDateTime(timebegin).ToShortDateString() + "','yyyy-mm-dd')";
}
if (!string.IsNullOrEmpty(timeend))
{
strWhere += " and aj.cjsj <= to_date('" + Convert.ToDateTime(timeend).AddDays(1).ToShortDateString() + "','yyyy-mm-dd')";
}
EDRS.BLL.EDRS_Report bll = new EDRS.BLL.EDRS_Report(Request);
int count = 0;
//1-8 修改存储过程
DataSet ds = bll.GetCaseGroupByUnit(strWhere, UserInfo.DWBM, UserInfo.GH, (pageSize * pageIndex), (pageSize * pageIndex) - pageSize + 1, sortname, out count, values.ToArray());
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
DataTable dt = ds.Tables[0].Copy();
//读取配置文件中的配置
int?isLocalAjxx = EDRS.Common.ConfigHelper.GetConfigInt("IsLocalAjxx");
if (isLocalAjxx == 1)
{
string msg = "";
DateTime?b_date = null;
if (!string.IsNullOrEmpty(timebegin))
{
b_date = Convert.ToDateTime(timebegin);
}
DateTime?e_date = null;
if (!string.IsNullOrEmpty(timeend))
{
e_date = Convert.ToDateTime(timeend);
}
EDRS.Common.IceServicePrx iceprx = new IceServicePrx();
EDRS.BLL.TYYW_GG_AJJBXX ajbll = new EDRS.BLL.TYYW_GG_AJJBXX(Request);
msg = ajbll.GetConfiguration(UserInfo.DWBM, UserInfo.GH, iceprx);
if (!string.IsNullOrEmpty(msg))
{
ReturnString.JsonToString(Prompt.error, msg, null);
}
foreach (DataRow dr in dt.Rows)
{
dr["AJNUM"] = iceprx.GetAjjbxxCount(null, dr["CBDW_BM"].ToString(), b_date, e_date, true, out msg);
dr["WZNUM"] = int.Parse(dr["AJNUM"].ToString()) - int.Parse(dr["ZZNUM"].ToString());
dr["ZZLNUM"] = Math.Round((decimal.Parse(dr["ZZNUM"].ToString()) / decimal.Parse(dr["AJNUM"].ToString())) * 100, 2);
}
}
string ExcelFolder = "ExcelFolder";// Assistant.GetConfigString("ExcelFolder");
//生成列的中文对应表
//Dictionary<string, string> nameList = new Dictionary<string, string>();
//nameList.Add("CBDW_MC", "承办单位");
//nameList.Add("AJNUM", ((VersionName)0).ToString()+ "受理数");
//nameList.Add("ZZNUM", "已制作数");
//nameList.Add("WZNUM", "未制作数");
//nameList.Add("ZZLNUM", "制作率");
//Dictionary<string, object> valueList = new Dictionary<string, object>();
//valueList.Add("ZZLNUM", "%");
//利用excel对象
string filename = DateTime.Now.ToString("yyyyMMddHHmmssff") + ".xls";
string msgs = string.Empty;
if (dt.Rows.Count > 0)
{
dt.Columns.Remove("Ro");
dt.Columns.Remove("CBDW_BM");
dt.Columns["CBDW_MC"].ColumnName = "承办单位";
dt.Columns["AJNUM"].ColumnName = ((VersionName)0).ToString() + "受理数";
dt.Columns["ZZNUM"].ColumnName = "已制作数";
dt.Columns["WZNUM"].ColumnName = "未制作数";
dt.Columns["ZZLNUM"].ColumnName = "制作率";
msgs = DataToExcel_Ex.Export(dt, "卷宗制作率统计", Server.MapPath("/" + ExcelFolder + "/" + filename));
//filename = dte.DataExcel(dt, "卷宗制作率统计", FilePath, nameList, valueList);
}
if (string.IsNullOrEmpty(msgs))
{
return(ReturnString.JsonToString(Prompt.win, "/" + ExcelFolder + "/" + filename, null));
}
else
{
return(ReturnString.JsonToString(Prompt.error, StringPlus.String2Json(msgs), null));
}
}
return(ReturnString.JsonToString(Prompt.error, "导出失败", null));
}
