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