/// <summary> /// 获取单位权限 /// </summary> /// <param name="dwbm"></param> /// <param name="bmbm"></param> /// <param name="jsbm"></param> /// <returns></returns> private List<string> GetDwBm(string dwbm, string bmbm, string gh) { EDRS.BLL.XT_DM_QX bll = new EDRS.BLL.XT_DM_QX(Request); DataSet ds = bll.GetQxListByRole(dwbm, bmbm, gh, 0,""); List<string> list = new List<string>(); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { foreach (DataRow ro in ds.Tables[0].Rows) list.Add(ro["QXBM"].ToString()); } return list; }
/// <summary> /// 根据Web接口获取数据 /// </summary> /// <param name="Request"></param> /// <param name="dwbm"></param> /// <param name="gh"></param> /// <param name="jsbm"></param> /// <param name="bmbm"></param> /// <returns></returns> public string GetWebService(System.Web.HttpRequest Request, string dwbm, string gh, string jsbm, string bmbm) { string url = ConfigHelper.GetConfigString("AJXXDZ"); string key = "tyknntd-#4kji2%(+^"; if (string.IsNullOrEmpty(url)) { return(ReturnString.JsonToString(Prompt.error, "您已配置为外部连接方式,请先设置配置文件连接地址", null)); } Dictionary <String, String> dicList = new Dictionary <String, String>(); string page = Request["page"]; string rows = Request["pagesize"]; string bmsah = Request["key"]; string ajmc = Request["casename"]; string cbr = Request["dutyman"]; string timebegin = Request["timebegin"]; string timeend = Request["timeend"]; //单位编码和案件类别 string caseUnit = Request["caseUnit"]; string caseAjlb = Request["caseajlb"]; //排序 string sortname = Request["sortname"]; string sortorder = Request["sortorder"]; if (string.IsNullOrEmpty(sortname)) { sortname = "SLRQ DESC"; sortorder = ""; } if (sortname == "AJ_DWMC" || sortname == "CBDW_MC") { sortname = "CBDW_BM"; } sortname += " " + sortorder; List <object> values = new List <object>(); if (!string.IsNullOrEmpty(bmsah)) { bmsah = "Bmsah=\"" + bmsah + "\""; } if (!string.IsNullOrEmpty(ajmc)) { ajmc = "Ajmc=\"" + ajmc + "\""; } if (!string.IsNullOrEmpty(cbr)) { cbr = "Cbr=\"" + cbr + "\""; } if (!string.IsNullOrEmpty(timebegin)) { timebegin = "Timebegin=\"" + timebegin + "\""; } if (!string.IsNullOrEmpty(timeend)) { timeend = "Timeend =\"" + timeend + "\""; } if (!string.IsNullOrEmpty(caseUnit))//单位编码 { string[] dwbms = caseUnit.Split(new char[] { ';' }, StringSplitOptions.RemoveEmptyEntries); string dwbmParm = ""; for (int i = 0; i < dwbms.Length; i++) { dwbmParm += "{\"dwbm\":\"" + dwbms[i] + "\"}"; if (i < dwbms.Length - 1) { dwbmParm += ","; } } caseUnit = "[" + dwbmParm + "]"; } else { XT_DM_QX qx = new XT_DM_QX(Request); DataSet ds = qx.GetDwList(jsbm, dwbm, bmbm, ""); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { DataTable dt = ds.Tables[0].Copy(); dt.Columns["QXBM"].ColumnName = "dwbm"; dt.Columns.Remove("QXMC"); caseUnit = JsonHelper.JsonString(dt); } else { caseUnit = "[{\"dwbm\":\"" + dwbm + "\"}]"; } } if (!string.IsNullOrEmpty(caseAjlb))//案件类别 { string[] ajlb = caseAjlb.Split(new char[] { ';' }, StringSplitOptions.RemoveEmptyEntries); string ajlbParm = ""; for (int i = 0; i < ajlb.Length; i++) { ajlbParm += "{\"lb\":\"" + ajlb[i] + "\"}"; if (i < ajlb.Length - 1) { ajlbParm += ","; } } caseAjlb = "[" + ajlbParm + "]"; } else { XT_DM_QX qx = new XT_DM_QX(Request); DataSet ds = qx.GetLBList(jsbm, dwbm, bmbm, ""); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { DataTable dt = ds.Tables[0].Copy(); dt.Columns["QXBM"].ColumnName = "lb"; dt.Columns.Remove("QXMC"); caseAjlb = JsonHelper.JsonString(dt); } //else // caseAjlb = "[{\"ajlbbm\":\"" + dwbm + "\"}]"; } dicList.Add("PageIndex", page); dicList.Add("PageSize", rows); dicList.Add("Bmsah", bmsah); dicList.Add("MC", ajmc); //dicList.Add("Cbr", cbr); dicList.Add("Timebegin", timebegin); dicList.Add("Timeend", timeend); dicList.Add("DWBM", caseUnit.Replace("\r\n", "")); dicList.Add("LB", caseAjlb.Replace("\r\n", "")); //dicList.Add("Sort", sortname); //dicList.Add("PageIndex", (string.IsNullOrEmpty(page) ? page : EDRS.Common.DEncrypt.DEncrypt.Encrypt(page, key))); //dicList.Add("PageSize", (string.IsNullOrEmpty(rows) ? rows : EDRS.Common.DEncrypt.DEncrypt.Encrypt(rows, key))); //dicList.Add("Bmsah", (string.IsNullOrEmpty(bmsah) ? bmsah : EDRS.Common.DEncrypt.DEncrypt.Encrypt(bmsah, key))); //dicList.Add("Ajmc", (string.IsNullOrEmpty(ajmc) ? ajmc : EDRS.Common.DEncrypt.DEncrypt.Encrypt(ajmc, key))); //dicList.Add("Cbr", (string.IsNullOrEmpty(cbr) ? cbr : EDRS.Common.DEncrypt.DEncrypt.Encrypt(cbr, key))); //dicList.Add("Timebegin", (string.IsNullOrEmpty(timebegin) ? timebegin : EDRS.Common.DEncrypt.DEncrypt.Encrypt(timebegin, key))); //dicList.Add("Timeend", (string.IsNullOrEmpty(timeend) ? timeend : EDRS.Common.DEncrypt.DEncrypt.Encrypt(timeend, key))); //dicList.Add("Dwbm", (string.IsNullOrEmpty(caseUnit) ? caseUnit : EDRS.Common.DEncrypt.DEncrypt.Encrypt(caseUnit, key))); //dicList.Add("Ajlbbm", (string.IsNullOrEmpty(caseAjlb) ? caseAjlb : EDRS.Common.DEncrypt.DEncrypt.Encrypt(caseAjlb, key))); //dicList.Add("Sort", (string.IsNullOrEmpty(sortname) ? sortname : EDRS.Common.DEncrypt.DEncrypt.Encrypt(sortname, key))); WebClient wc = new WebClient(); string rt = wc.Post(url, dicList); if (!string.IsNullOrEmpty(rt)) { string stat = JsonHelper.DeserializeObjectKey("[" + rt + "]", "Stat"); if (stat == "0") { string data = JsonHelper.DeserializeObjectKey("[" + rt + "]", "Data"); DataTable dtData = JsonHelper.ToDataTable(data); if (dtData != null) { dtData.Columns["MC"].ColumnName = "AJMC"; dtData.Columns["BH"].ColumnName = "BMSAH"; dtData.Columns["LBMC"].ColumnName = "AJLB_MC"; dtData.Columns["LBBM"].ColumnName = "AJLB_BM"; dtData.Columns["DWMC"].ColumnName = "CBDW_MC"; dtData.Columns["DWBM"].ColumnName = "CBDW_BM"; if (dtData.Rows.Count > 0) { return("{\"Total\":" + dtData.Rows[0]["Total"].ToString() + ",\"Rows\":" + JsonHelper.JsonString(dtData) + "}"); } } //{ //Total:分页数据总数(int), //MC:名称(string), //BH:编号(string), //LBMC:类别名称(string), //LBBM:类别编码(string), //DWMC:单位名称(string), //DWBM:单位编码(string), //CBR:承办人(string), //SLRQ:受理日期(yyyy-MM-dd HH:mm:ss) //} // "{"Total":1,"Rows":[{"ISREGARD": 0, "AJMC": "ffffff", "BMSAH": "广元市公安局上会议题[2016]37000000001号", "AJLB_MC": "上会议题", "CBDW_MC": "广元市公安局", "CBBM_MC": null, "CBR": null, "DQJD": null, "SLRQ": "2016-04-05 11:15:36", "AJZT": "0", "DQRQ": "1900-01-01 00:00:00", "BJRQ": "1900-01-01 00:00:00", "WCRQ": "1900-01-01 00:00:00", "GDRQ": "1900-01-01 00:00:00", "AJLB_BM": "1101", "CBDW_BM": "370000", "XYR": "ff", "SFZH": "444444444444444444", "TARYXX": "asdfasdfasdfasd"}]}" } else if (stat == "1") { string msg = JsonHelper.DeserializeObjectKey("[" + rt + "]", "Msg"); return(ReturnString.JsonToString(Prompt.error, msg, null)); } } return(ReturnString.JsonToString(Prompt.error, "未找到信息", null)); }