public void QueryRiskNoticeSignerByID(string id) { RiskNoticeSignerDal _riskNoticeSignerDal = new RiskNoticeSignerDal(); try { var dt = _riskNoticeSignerDal.QueryRiskNoticeSignerByRnid(id); var list = from da in dt.AsEnumerable() select new { Img = da.Field<string>("t_img"), Type = da.Field<int?>("t_type") }; _hashtable["isSuccess"] = true; _hashtable["msg"] = "获取成功"; _hashtable["data"] = list.ToList(); //解决乱码代码: Context.Response.ContentType = "text/plain;charset=utf-8"; Context.Response.Write(_jss.Serialize(_hashtable)); } catch (Exception e) { Log.Debug("方法名:QueryRiskNotice,错误原因:" + e.Message); _hashtable["isSuccess"] = false; _hashtable["msg"] = "获取失败"; _hashtable["data"] = null; var json = _jss.Serialize(_hashtable); Context.Response.Write(json); } }
/// <summary> /// 查询所有选中人员数据 /// </summary> /// <param name="httpContext"></param> public void QuerySelectedNodes(HttpContext httpContext) { var hashtable = new Hashtable(); var riskNoticeSignerDal = new RiskNoticeSignerDal(); var riskNoticeRiDal = new RiskNoticeRIDal(); var userGroupDal = new UserGroupDal(); var id = httpContext.Request.Params["id"]; try { var data = userGroupDal.QueryAll(); var dataList = from da in data.AsEnumerable() select new { id = da.Field<string>("id"), name = da.Field<string>("name"), pid = da.Field<string>("pid") }; //这里要查询已经发送给的用户列表,显示在[发送面板]的[已选择用户]列表中。 //如果审核人或签发人改变,那么前台要提示用户审核人或签发人已经修改,要先删除通知单重新添加 var data3 = riskNoticeRiDal.QueryRiskNoticeRI(); var dataList3 = from da3 in data3.AsEnumerable() select new { openid = da3.Field<string>("t_weixin"), type = da3.Field<int?>("t_type") }; var data2 = riskNoticeSignerDal.QueryRiskNoticeSignerByRnid(id); if (data2.Rows.Count <= 0) { data2 = riskNoticeRiDal.QueryRiskNoticeRI(); var dataList2 = from da2 in data2.AsEnumerable() select new { openid = da2.Field<string>("t_weixin"), nickname = da2.Field<string>("t_name"), type = da2.Field<int?>("t_type"), sjh = da2.Field<string>("t_phonenum") }; hashtable["data3"] = true; hashtable["data2"] = dataList2.ToList(); } else { var dataList2 = from da2 in data2.AsEnumerable() select new { openid = da2.Field<string>("t_weixin"), nickname = da2.Field<string>("t_name"), type = da2.Field<int?>("t_type"), sjh = da2.Field<string>("t_phonenum") }; var tmp = dataList3.Any(s => (dataList2.Any(k => k.openid == s.openid && k.type == 1 && s.type == 1))); tmp &= dataList3.Any(s => (dataList2.Any(k => k.openid == s.openid && k.type == 2 && s.type == 2))); hashtable["data3"] = tmp; hashtable["data2"] = dataList2.ToList(); } hashtable["data"] = dataList.ToList(); hashtable["isSuccess"] = true; hashtable["jsMethod"] = "ajax_QuerySelectedNodes"; var json = _jss.Serialize(hashtable); httpContext.Response.Write(json); } catch (Exception e) { Log.Debug("出错信息:" + e.Message); } }