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