/// <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); } }
public void Send() { while (true) { try { Log.Debug("主网、配网、监控 推送。"); InfoReleaseDal dal = new InfoReleaseDal(); DataTable dt = dal.QueryByTypes(new string[] { "3080_youo_zwtz", "3081_youo_pwtz", "3082_youo_jkxx" }); UserGroupDal userGroupDal = new UserGroupDal(); DataTable dtUser = userGroupDal.QueryInternalUser(); //发送:主网、配网、监控 foreach (DataRow row in dt.Rows) { Success = false; var title = row["Title"].ToString(); var MessageDescription = row["MaterialContent"].ToString(); //var content = "标题:" + title + "\n内容:" + MessageDescription + "\n发布人:" + row["CreatePerson"].ToString(); var content = "标题:" + title + "\n内容:" + MessageDescription + "\n\r 国网铜陵供电公司"; foreach (DataRow row1 in dtUser.Rows) { var openId = row1["openid"].ToString(); SendMsg(openId, content); } if (Success) { dal.Modify(new InfoRelease() { Id = row["id"].ToString(), FlagRelease = "2", }); } } PowerCutDal powerCutDal = new PowerCutDal(); DataTable dtPowerCut = powerCutDal.Query(new PowerCut() { State = "1", //未送电 FlagRelease = "'2'", //已发布 DateBegin = DateTime.Now.Date, DateEnd = DateTime.MaxValue.AddDays(-2), BusinessType = "011_youo_tdtz2", }); //发送:故障停电 Log.Debug("故障停电"); foreach (DataRow row in dtPowerCut.Rows) { Success = false; var content = "尊敬的电力客户:\n\r 因突发电力故障,安排以下故障抢修工作安排。未经铜陵供电公司有关部门许可,严禁任何单位和个人在停电线路及设备上工作。为此造成的不便,敬请各客户给予谅解和支持。如有任何疑问,请致电供电公司24小时服务热线95598。\n\r 停电时间:" + row["PowerCutTime"].ToString().Split(' ')[0] + " " + row["TimeArea"].ToString() + "\n\r 停电设备:" + row["Device"].ToString() + "\n\r 停电区域:" + row["Area"].ToString() + "\n\r 国网铜陵供电公司"; foreach (DataRow row1 in dtUser.Rows) { var openId = row1["openid"].ToString(); SendMsg(openId, content); } if (Success) { powerCutDal.Modify(new PowerCut() { Id = row["id"].ToString(), FlagRelease = "3", }); Log.Debug("修改状态为已推送--" + row["id"].ToString()); } } #region 发送最新资讯091_youo_zxzx var sendMessage = new SendMessage(); var listnews = new List<Articles>(); var articles = new Articles(); InfoReleaseDal infoReleaseDal = new InfoReleaseDal(); DataTable yhcsDt = infoReleaseDal.Query(new InfoRelease() { FlagRelease = "1", BusinessType = "091_youo_zxzx", }); DataTable userDt = new UserInfoDal().Query(new UserInfo());//获取所有关注的微信用户 WebServ.WebService1 service1 = new WebService1(); var token = service1.GetToken(); foreach (DataRow row in yhcsDt.Rows) { var id = row["id"].ToString(); var discrip = row["MessageDescription"].ToString(); if (discrip.Length > 200) { discrip = discrip.Substring(0, 190) + "..."; } articles = new Articles() { title = row["title"].ToString(), description = discrip, picurl = "http://60.173.29.191/UploadImages/091_youo_zxzx.jpg", url = "http://60.173.29.191/views/messagelist/messagedetail.htm?id=" + id, }; listnews.Add(articles); foreach (DataRow uRow in userDt.Rows) { var openid = uRow["openid"].ToString(); sendMessage.SendNewsMessage(token, openid, listnews); } infoReleaseDal.Modify(new InfoRelease() { Id = id, FlagRelease = "2", }); Log.Debug("最新资讯-修改状态为已推送--" + row["id"].ToString()); } #endregion Thread.Sleep(10000); } catch (Exception ex) { Log.Debug("发送故障" + ex); Thread.Sleep(100000); } } }
/// <summary> /// 查询所有组数据 /// </summary> /// <param name="httpContext"></param> public void QueryAllGroup(HttpContext httpContext) { var hashtable = new Hashtable(); var userGroupDal = new UserGroupDal(); var infoReleaseDal = new InfoReleaseDal(); 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 groupData = infoReleaseDal.QuerySendGroup(id); if (groupData.Rows.Count > 0 && groupData.Rows[0]["SendGroup"] != null && !string.IsNullOrEmpty(groupData.Rows[0]["SendGroup"].ToString().Trim())) { var groupDataList = from groupDa in groupData.AsEnumerable() select new { sendGroup = groupDa.Field<string>("SendGroup") }; hashtable["sendGroup"] = groupDataList.ToList(); } hashtable["data"] = dataList.ToList(); hashtable["isSuccess"] = true; hashtable["jsMethod"] = "ajax_QueryAllGroup"; var json = _jss.Serialize(hashtable); httpContext.Response.Write(json); } catch (Exception e) { Log.Debug("出错信息:" + e.Message); } }