/// <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)); }