/// <summary>
/// 获取ICE统一业务配置参数
/// </summary>
/// <param name="Request"></param>
/// <param name="dwbm"></param>
/// <param name="gh"></param>
/// <returns></returns>
public string GetConfiguration(string dwbm, string gh, IceServicePrx iceprx)
{
XY_DZJZ_XTPZ xtpzbll = new XY_DZJZ_XTPZ(null);
DataSet ds = xtpzbll.GetAllList(dwbm, gh);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
DataRow[] dr = ds.Tables[0].Select("CONFIGID=" + (int)EnumConfig.访问统一业务ICE地址);
if (dr.Length > 0 && dr[0]["CONFIGVALUE"] != null)
{
iceprx.DownPrx = dr[0]["CONFIGVALUE"].ToString();
}
else
{
return(ReturnString.JsonToString(Prompt.error, "请先在系统配置模块配置访问统一业务ICE地址", null));
}
dr = ds.Tables[0].Select("CONFIGID=" + (int)EnumConfig.ICE消息包大小);
if (dr.Length > 0 && dr[0]["CONFIGVALUE"] != null)
{
iceprx.SizeMax = Convert.ToDecimal(dr[0]["CONFIGVALUE"].ToString());
}
else
{
return(ReturnString.JsonToString(Prompt.error, "请先在系统配置模块配置ICE消息包大小", null));
}
}
else
{
return(ReturnString.JsonToString(Prompt.error, "请先在系统配置模块中进行配置", null));
}
return("");
}
/// <summary>
/// 获取案件文件
/// </summary>
/// <returns></returns>
private void GetFile()
{
string wjlj = HttpUtility.UrlDecode(HttpUtility.UrlDecode(Request["wjlj"].Trim()));
string wjmc = HttpUtility.UrlDecode(HttpUtility.UrlDecode(Request["wjmc"].Trim()));
if (string.IsNullOrEmpty(wjlj) || string.IsNullOrEmpty(wjmc))
{
Response.Write("访问参数错误");
}
else
{
EDRS.BLL.XY_DZJZ_XTPZ bll = new EDRS.BLL.XY_DZJZ_XTPZ(this.Request);
EDRS.Model.XY_DZJZ_XTPZ model = bll.GetModel((int)EnumConfig.卷宗文件下载地址);
if (model != null)
{
IceServicePrx isp = new IceServicePrx();
string msg = "";
byte[] bytes = new byte[] { };
if (isp.DownFile(model.CONFIGVALUE, wjlj, wjmc, "", ref bytes, ref msg))
{
string showType = ConfigHelper.GetConfigString("FileShowType");
if (showType == "1")
{
Response.Write("<img style=\"max-width:100%;\" alt=\"\" src=\"data:image/jpeg;base64," + Convert.ToBase64String(bytes) + "\" />");
}
else
{
byte[] info = DataEncryption.Decryption(bytes);
//MemoryStream ms = new MemoryStream(bytes); //把那个byte[]数组传进去,然后
//File.WriteAllBytes(Server.MapPath("/") + "ddd.pdf", bytes);
//FileStream fs = new FileStream(Server.MapPath("/")+"ccc.pdf",FileMode.Append, FileAccess.Write);
//ms.WriteTo(fs);
//ms.Close();
//fs.Close();
Response.ContentType = "application/pdf";
Response.AddHeader("content-disposition", "filename=pdf");
Response.AddHeader("content-length", info.Length.ToString());
Response.BinaryWrite(info);
}
}
else
{
Response.Write(msg);
}
}
else
{
Response.Write("请先配置" + EnumConfig.卷宗文件下载地址);
}
}
}
/// <summary>
/// 根据ICE获取案件基本信息列表
/// </summary>
/// <returns></returns>
private DataTable ListBindIce(System.Web.HttpRequest Request, string dwbm, string gh, ref int count, ref string msg)
{
string page = Request["page"];
string rows = Request["pagesize"];
string key = Request["key"];
string casename = Request["casename"];
string dutyman = Request["dutyman"];
string relevance = Request["relevance"];
if (relevance == "1")
{
relevance = "Y";
}
else if (relevance == "2")
{
relevance = "N";
}
else
{
relevance = "";
}
DateTime?timebegin = null;
if (Request["timebegin"] != null && !string.IsNullOrEmpty(Request["timebegin"]))
{
timebegin = Convert.ToDateTime(Request["timebegin"]);
}
DateTime?timeend = null;
if (Request["timeend"] != null && !string.IsNullOrEmpty(Request["timeend"]))
{
timeend = Convert.ToDateTime(Request["timeend"]);
}
//排序
string sortname = Request["sortname"];
string sortorder = Request["sortorder"];
//if (string.IsNullOrEmpty(sortname))
// sortname = "AJZT";
if (sortname == "ISREGARD")
{
sortname = "SFZZ";
}
sortname += " " + sortorder;
EDRS.Common.IceServicePrx iceprx = new IceServicePrx();
msg = GetConfiguration(dwbm, gh, iceprx);
if (!string.IsNullOrEmpty(msg))
{
return(null);
}
string caseUnit = Request["caseUnit"];
string caseAjlb = Request["caseajlb"];
List <string> ajlbList = new List <string>();
List <string> dwList = new List <string>();
if (string.IsNullOrEmpty(caseAjlb))
{
ajlbList = GetAjTypeBm(Request, dwbm, "", gh);
}
else
{
foreach (string _ajlb in caseAjlb.Split(';'))
{
ajlbList.Add(_ajlb);
}
}
if (string.IsNullOrEmpty(caseUnit))
{
dwList = GetDwBm(Request, dwbm, "", gh);
}
else
{
foreach (string _unit in caseUnit.Split(';'))
{
dwList.Add(_unit);
}
}
DataTable dt = iceprx.AJJBXXJson(key, ajlbList, null, dwList, casename, timebegin, timeend, dutyman, relevance, int.Parse(rows), int.Parse(page), out count, out msg);
if (count > 0)
{
DataView dv = dt.DefaultView;
if (!string.IsNullOrEmpty(sortname.Trim()))
{
dv.Sort = sortname;
}
return(dv.ToTable());
// 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);
if (string.IsNullOrEmpty(msg))
{
msg = "未找到信息";
}
//else
// return ReturnString.JsonToString(Prompt.error, msg, null);
return(null);
}
/// <summary>
/// 分页获取数据列表
/// </summary>
//public DataSet GetList(int PageSize,int PageIndex,string strWhere)
//{
//return dal.GetList(PageSize,PageIndex,strWhere);
//}
#endregion BasicMethod
#region ExtensionMethod
#endregion ExtensionMethod
#region 获取Ice对象转换本地对象
/// <summary>
/// 获取Ice对象转换本地对象
/// </summary>
/// <param name="bmsah"></param>
/// <returns></returns>
public EDRS.Model.TYYW_GG_AJJBXX GetIceByModel(string bmsah, List <string> ajlbbm, List <string> userRoleList, string dwbm, string gh)
{
int count;
string msg;
IceServicePrx icePrx = new IceServicePrx();
msg = GetConfiguration(dwbm, gh, icePrx);
if (!string.IsNullOrEmpty(msg))
{
return(null);
}
List <ZC57s.CaseInfoServ.DigitalDossier.ICInterface.ClsAJJBXX> ajjbxxList = icePrx.GetAjjbxx(bmsah, ajlbbm, userRoleList, dwbm, "", null, null, "", "", 1, 1, out count, out msg);
//List<ZC57s.CaseInfoServ.DigitalDossier.ICInterface.ClsAJJBXX> ajjbxxList = icePrx.GetAjjbxx(bmsah, ajlbbm, userRoleList, "", "", null, null, "", "", 1, 1, out count, out msg);
if (ajjbxxList != null && ajjbxxList.Count > 0)
{
ZC57s.CaseInfoServ.DigitalDossier.ICInterface.ClsAJJBXX clsajjbxx = ajjbxxList[0];
EDRS.Model.TYYW_GG_AJJBXX ajjbxx = new Model.TYYW_GG_AJJBXX();
ajjbxx.BMSAH = clsajjbxx.BMSAH;
ajjbxx.TYSAH = clsajjbxx.TYSAH;
ajjbxx.SFSC = clsajjbxx.SFSC;
ajjbxx.SFYGXTSJ = clsajjbxx.SFYGXTSJ;
ajjbxx.CBDW_BM = clsajjbxx.AJ_DWBM;
ajjbxx.CBDW_MC = clsajjbxx.AJ_DWMC;
ajjbxx.FQDWBM = clsajjbxx.FQDWBM;
ajjbxx.FQL = clsajjbxx.FQL;
ajjbxx.CJSJ = clsajjbxx.CJSJ;
ajjbxx.ZHXGSJ = clsajjbxx.ZHXGSJ;
ajjbxx.SLRQ = clsajjbxx.SLRQ;
ajjbxx.AJMC = clsajjbxx.AJMC;
ajjbxx.AJLB_BM = clsajjbxx.AJLB_BM;
ajjbxx.AJLB_MC = clsajjbxx.AJLB_MC;
ajjbxx.ZCJG_DWDM = clsajjbxx.ZCJG_DWDM;
ajjbxx.ZCJG_DWMC = clsajjbxx.ZCJG_DWMC;
ajjbxx.YSDW_DWDM = clsajjbxx.YSDW_DWDM;
ajjbxx.YSDW_DWMC = clsajjbxx.YSDW_DWMC;
ajjbxx.YSWSWH = clsajjbxx.YSWSWH;
ajjbxx.YSAY_AYDM = clsajjbxx.YSAY_AYDM;
ajjbxx.YSAY_AYMC = clsajjbxx.YSAY_AYMC;
ajjbxx.YSQTAY_AYDMS = clsajjbxx.YSQTAY_AYDMS;
ajjbxx.YSQTAY_AYMCS = clsajjbxx.YSQTAY_AYMCS;
ajjbxx.CBRGH = clsajjbxx.CBRGH;
ajjbxx.CBR = clsajjbxx.CBR;
ajjbxx.CBBM_BM = clsajjbxx.CBBM_BM;
ajjbxx.CBBM_MC = clsajjbxx.CBBM_MC;
ajjbxx.AJZT = clsajjbxx.AJZT;
ajjbxx.SFSWAJ = clsajjbxx.SFSWAJ;
ajjbxx.SFDBAJ = clsajjbxx.SFDBAJ;
ajjbxx.ZXHD_MC = clsajjbxx.ZXHD_MC;
ajjbxx.WCRQ = clsajjbxx.WCRQ;
ajjbxx.GDRQ = clsajjbxx.GDRQ;
ajjbxx.GDRGH = clsajjbxx.GDRGH;
ajjbxx.GDR = clsajjbxx.GDR;
ajjbxx.AQZY = clsajjbxx.AQZY;
ajjbxx.DQJD = clsajjbxx.DQJD;
ajjbxx.BLKSRQ = clsajjbxx.BLKSRQ;
ajjbxx.BLTS = clsajjbxx.BLTS;
ajjbxx.DQRQ = clsajjbxx.DQRQ;
ajjbxx.BJRQ = clsajjbxx.BJRQ;
ajjbxx.YJZT = clsajjbxx.YJZT;
ajjbxx.JYYJZT = clsajjbxx.JYYJZT;
ajjbxx.JYYJHCQXYRGS = clsajjbxx.JYYJHCQXYRGS;
ajjbxx.LCSLBH = clsajjbxx.LCSLBH;
ajjbxx.FXDJ = clsajjbxx.FXDJ;
ajjbxx.SFGZAJ = clsajjbxx.SFGZAJ;
ajjbxx.FZ = clsajjbxx.FZ;
ajjbxx.YSYJ_DM = clsajjbxx.YSYJ_DM;
ajjbxx.YSYJ_MC = clsajjbxx.YSYJ_MC;
ajjbxx.SFJBAJ = clsajjbxx.SFJBAJ;
ajjbxx.ZXHD_DM = clsajjbxx.ZXHD_DM;
ajjbxx.DQYJJD = clsajjbxx.DQYJJD;
ajjbxx.YASCSSJD_DM = clsajjbxx.YASCSSJD_DM;
ajjbxx.YASCSSJD_MC = clsajjbxx.YASCSSJD_MC;
ajjbxx.YSRJDH = clsajjbxx.YSRJDH;
return(ajjbxx);
}
return(null);
}
private void GetAJReportByUnit(HttpContext context)
{
string strWhere = "";
List <object> values = new List <object>();
int pageIndex = Convert.ToInt32(context.Request["page"]);
int pageSize = Convert.ToInt32(context.Request["pagesize"]);
string key = context.Request["key"]; //部门受案号
string timebegin = context.Request["timebegin"]; //开始日期
string timeend = context.Request["timeend"]; //结束日期
string unit = context.Request["unit"]; //承办单位
string ywbm = context.Request["ywbm"];
string caseajlb = context.Request["caseajlb"];
//排序
string sortname = context.Request["sortname"];
string sortorder = context.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(context.Request);
if (!string.IsNullOrEmpty(unit))
{
string dwbms = unit.Replace(";", ",");
strWhere += " and CBDW_BM in (" + StringPlus.ReplaceSingle(dwbms) + ")";
}
else if (string.IsNullOrEmpty(unit))
{
//DataSet dsDwQx = bllQx.GetDwList(base.Jsbms, base.UserInfo.DWBM, 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"] + ",";
// }
// strWhere += " and AJ.CBDW_BM in (" + StringPlus.ReplaceSingle(dwbms.Substring(0, dwbms.Length - 1)) + ")";
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 + ") )";
//// where_dw = " and jz.dwbm in (" + StringPlus.ReplaceSingle(dwbms.Substring(0, dwbms.Length - 1)) + ")";
//}
//else
// strWhere += " and AJ.CBDW_BM = " + base.UserInfo.DWBM;
}
//案件类别
if (!string.IsNullOrEmpty(caseajlb))
{
string caseajlbs = caseajlb.Replace(";", ",");
strWhere += " and trim(AJ.AJLB_BM) in (" + caseajlbs + ")";
}
else if (string.IsNullOrEmpty(caseajlb))
{
//DataSet dsLbQx = bllQx.GetLBList(base.Jsbms, base.UserInfo.DWBM, base.Bmbms, "");
//if (dsLbQx != null && dsLbQx.Tables.Count > 0 && dsLbQx.Tables[0].Rows.Count > 0)
//{
// string ajlbs = "";
// foreach (DataRow dr in dsLbQx.Tables[0].Rows)
// {
// ajlbs += dr["QXBM"] + ",";
// }
// strWhere += " and trim(aj.ajlb_bm) in (" + StringPlus.ReplaceSingle(ajlbs.Substring(0, ajlbs.Length - 1)) + ")";
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')";
}
//单位权限
//List<string> unitRoleList = GetDwBm(context,UserRole.DWBM, UserRole.BMBM, UserRole.JSBM);
EDRS.BLL.EDRS_Report bll = new EDRS.BLL.EDRS_Report(context.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(context.Request);
msg = ajbll.GetConfiguration(UserInfo.DWBM, UserInfo.GH, iceprx);
if (!string.IsNullOrEmpty(msg))
{
context.Response.Write(msg);
}
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);
}
}
//获取json数据
OperateLog.AddLog(OperateLog.LogType.卷宗业务情况Web, "查询单位卷宗统计列表数据成功！", UserInfo, UserRole, context.Request);
string json = "{\"Rows\":" + dt.ToDatagridJson() + ",\"Total\":" + count + "}";// EDRS.Common.JsonHelper.JsonString(ds.Tables[0]);
context.Response.Write(json);
}
else
{
OperateLog.AddLog(OperateLog.LogType.卷宗业务情况Web, "查询单位卷宗统计列表数据失败！", UserInfo, UserRole, context.Request);
//获取json数据
string json = "{\"Rows\":" + "[]" + ",\"Total\":" + count + "}";// EDRS.Common.JsonHelper.JsonString(ds.Tables[0]);
context.Response.Write(json);
}
}
/// <summary>
/// 获取案件文件
/// </summary>
/// <returns></returns>
private void GetFile()
{
string wjlj = "";
string wjmc = "";
// string dwbm = HttpUtility.UrlDecode(HttpUtility.UrlDecode(Request["DWBM"].Trim()));
//string bh = HttpUtility.UrlDecode(HttpUtility.UrlDecode(Request["BH"].Trim()));
string jzbh = HttpUtility.UrlDecode(HttpUtility.UrlDecode(Request["JZBH"].Trim()));
string jzwjybh = HttpUtility.UrlDecode(HttpUtility.UrlDecode(Request["JZWJYBH"].Trim()));
EDRS.BLL.YX_DZJZ_JZMLWJ bll = new EDRS.BLL.YX_DZJZ_JZMLWJ(HttpContext.Current.Request);
DataSet ds = bll.GetList(" and JZBH=:JZBH and WJXH=:WJXH", new object[] { jzbh, jzwjybh });
//判断是否查询出现异常
if (ds != null && ds.Tables.Count > 0)
{
//判断查询没有数据
if (ds.Tables[0].Rows.Count > 0)
{
wjlj = ds.Tables[0].Rows[0]["WJLJ"].ToString();
wjmc = ds.Tables[0].Rows[0]["WJMC"].ToString();
}
}
if (string.IsNullOrEmpty(wjlj) || string.IsNullOrEmpty(wjmc))
{
Response.Write("访问参数错误");
}
else
{
EDRS.BLL.XY_DZJZ_XTPZ bllto = new EDRS.BLL.XY_DZJZ_XTPZ(this.Request);
EDRS.Model.XY_DZJZ_XTPZ model = bllto.GetModel((int)EnumConfig.卷宗文件下载地址);
if (model != null)
{
IceServicePrx isp = new IceServicePrx();
string msg = "";
byte[] bytes = new byte[] { };
if (isp.DownFile(model.CONFIGVALUE, wjlj, wjmc, "", ref bytes, ref msg))
{
string showType = ConfigHelper.GetConfigString("FileShowType");
if (showType == "1")
{
Response.Write("<img style=\"max-width:100%;\" alt=\"\" src=\"data:image/jpeg;base64," + Convert.ToBase64String(bytes) + "\" />");
}
else
{
byte[] info = DataEncryption.Decryption(bytes);
Response.ContentType = "application/pdf";
Response.AddHeader("content-disposition", "filename=pdf");
Response.AddHeader("content-length", info.Length.ToString());
Response.BinaryWrite(info);
}
}
else
{
Response.Write(msg);
}
}
else
{
Response.Write("请先配置" + EnumConfig.卷宗文件下载地址);
}
}
}
/// <summary>
/// 获取案件文件
/// </summary>
/// <returns></returns>
private string GetFile()
{
string param = Request.Form["param"];
if (string.IsNullOrEmpty(param))
{
return(ReturnString.JsonToString(Prompt.error, "打印未获取到参数", null));
}
string[] paramArr = param.Split(new char[] { '|' }, StringSplitOptions.RemoveEmptyEntries);
if (paramArr.Length == 0)
{
return(ReturnString.JsonToString(Prompt.error, "访问参数错误", null));
}
else
{
EDRS.BLL.XY_DZJZ_XTPZ bll = new EDRS.BLL.XY_DZJZ_XTPZ(this.Request);
EDRS.Model.XY_DZJZ_XTPZ model = bll.GetModel((int)EnumConfig.卷宗文件下载地址);
if (model != null)
{
IceServicePrx isp = new IceServicePrx();
string msg = "";
byte[] bytes = new byte[] { };
List <byte[]> pdflist = new List <byte[]>();
byte[] info = null;
string[] paramIds = null;
for (int i = 0; i < paramArr.Length; i++)
{
paramIds = paramArr[i].Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
if (isp.DownFile(model.CONFIGVALUE, paramIds[0], paramIds[1], "", ref bytes, ref msg))
{
info = DataEncryption.Decryption(bytes);
pdflist.Add(info);
}
if (!string.IsNullOrEmpty(msg))
{
return(ReturnString.JsonToString(Prompt.error, StringPlus.String2Json(msg), null));
}
}
string fileName = DateTime.Now.ToString("yyyyMMddHHmmssfff");
string fileParnt = string.Format("/PrintPdfFiles/{0}.pdf", fileName);
byte[] d = MergePDFFiles(pdflist, fileParnt);
//Response.ContentType = "application/pdf";
//Response.AddHeader("content-disposition", "filename=pdf");
//Response.AddHeader("content-length", d.Length.ToString());
//Response.BinaryWrite(d);
return(ReturnString.JsonToString(Prompt.win, fileName, null));
}
else
{
return(ReturnString.JsonToString(Prompt.error, "请先配置" + EnumConfig.卷宗文件下载地址, 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));
}
