/// <summary>
/// 添加组到信息发布表
/// </summary>
/// <param name="context"></param>
public void AddGroupToInfoRelease(HttpContext context)
{
var hashTable = new Hashtable();
var infoReleaseDal = new InfoReleaseDal();
var id = context.Request.Params["id"];
var groupsId = context.Request.Params["groupsId"];
try
{
infoReleaseDal.Modify(new InfoRelease()
{
Id = id,
FlagRelease = "1",
SendGroup = groupsId
});
hashTable["isSuccess"] = true;
hashTable["jsMethod"] = "ajax_AddGroupToInfoRelease";
var json = _jss.Serialize(hashTable);
context.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);
}
}
}
private void Release(HttpContext context)
{
var hash = new Hashtable();
try
{
var id = HttpContext.Current.Request["id"] ?? "";
InfoReleaseDal infoReleaseDal = new InfoReleaseDal();
infoReleaseDal.Modify(new InfoRelease()
{
Id = id,
FlagRelease = "1",
});
hash["error"] = false;
hash["msg"] = "";
var json = _jss.Serialize(hash);
context.Response.Write(json);
}
catch (Exception ex)
{
hash["error"] = true;
hash["msg"] = ex.Message;
var json = _jss.Serialize(hash);
context.Response.Write(json);
Log.Debug(ex);
}
}
private void Edit(HttpContext context)
{
Hashtable hash;
try
{
string fileUrl = "";
HttpPostedFile file = HttpContext.Current.Request.Files["Exclefile"];
if (file != null && file.ContentLength != 0)
{
string dirPath = HttpContext.Current.Server.MapPath(savePath);
if (!Directory.Exists(dirPath))
{
hash = new Hashtable();
hash["error"] = true;
hash["msg"] = "上传目录不存在";
var data = _jss.Serialize(hash);
context.Response.Write(data);
return;
}
string fileName = file.FileName;
string fileExt = Path.GetExtension(fileName).ToLower();
ArrayList fileTypeList = ArrayList.Adapter(fileTypes.Split(','));
if (file.InputStream == null || file.InputStream.Length > maxSize)
{
hash = new Hashtable();
hash["error"] = 1;
hash["msg"] = "上传文件大小超过限制";
var data = _jss.Serialize(hash);
context.Response.Write(data);
return;
}
if (string.IsNullOrEmpty(fileExt) || Array.IndexOf(fileTypes.Split(','), fileExt.Substring(1).ToLower()) == -1)
{
hash = new Hashtable();
hash["error"] = 1;
hash["msg"] = "上传文件扩展名是不允许的扩展名";
var data = _jss.Serialize(hash);
context.Response.Write(data);
return;
}
string newFileName = DateTime.Now.ToString("yyyyMMddHHmmss_ffff") + fileExt;
string filePath = dirPath + newFileName;
file.SaveAs(filePath);
fileUrl = saveUrl + newFileName;
}
hash = new Hashtable();
hash["error"] = false;
hash["url"] = fileUrl;
var title = HttpContext.Current.Request["title"] ?? "";
var id = HttpContext.Current.Request["id"] ?? "";
var month = context.Request["month"] ?? DateTime.Now.ToString("yyyy-MM");
InfoReleaseDal infoReleaseDal = new InfoReleaseDal();
infoReleaseDal.Modify(new InfoRelease()
{
Id = id,
Title = title,
MaterialContent = fileUrl,
Bak1 = month,
});
var json = _jss.Serialize(hash);
context.Response.Write(json);
}
catch (Exception ex)
{
context.Response.Write("{\"error\":true,\"msg\":\"" + ex.Message + "\"}");
Log.Error(ex);
}
}
/// <summary>
/// 保存信息
/// </summary>
/// <param name="context"></param>
public void EditPublishInfo(HttpContext context)
{
var hashtable = new Hashtable();
var infoReleaseDal = new InfoReleaseDal();
var id = context.Request.Params["id"];
var key = context.Request.Params["key"];
var type = context.Request.Params["type"];
var messageDescription = context.Request.Params["messageDescription"];
var title = context.Request.Params["title"];
var content = context.Request.Params["contents"];
var infoRelease = new InfoRelease();
infoRelease.Id = id;
infoRelease.BusinessType = key;
infoRelease.CreateDt = DateTime.Now;
infoRelease.CreatePerson = "";
//infoRelease.FlagRelease = "0";
infoRelease.MaterialContent = content;
infoRelease.MaterialType = type;
infoRelease.MessageDescription = messageDescription;
infoRelease.SendGroup = "";
infoRelease.SendPerson = "";
infoRelease.Title = title;
try
{
infoReleaseDal.Modify(infoRelease);
hashtable["isSuccess"] = true;
var json = _jss.Serialize(hashtable);
context.Response.Write(json);
}
catch (Exception e)
{
Log.Debug("方法名:SavePowerInfo,描述:保存停电信息方法出错,错误原因:" + e.Message);
}
}
/// <summary>
/// 发布信息到人(实际上只是修改了下发布状态，仅此而已)
/// </summary>
/// <param name="context"></param>
public void PublishInfoToPerson(HttpContext context)
{
var hashtable = new Hashtable();
var infoReleaseDal = new InfoReleaseDal();
var userInfoDal = new UserInfoDal();
var id = context.Request.Params["id"];
try
{
//var data = userInfoDal.QueryAll();
//var tmp = string.Join(",",
// (
// from DataRow da in data.Rows
// select da["openid"].ToString()
// ).ToArray());
infoReleaseDal.Modify(new InfoRelease()
{
Id = id,
FlagRelease = "1"
});
hashtable["isSuccess"] = true;
hashtable["jsMethod"] = "ajax_PublishInfoToPerson";
var json = _jss.Serialize(hashtable);
context.Response.Write(json);
}
catch (Exception e)
{
Log.Debug("方法名:PublishInfoToPerson,,错误原因:" + e.Message);
}
}
/// <summary>
/// 添加用户到信息发布表
/// </summary>
/// <param name="context"></param>
public void AddPersonToInfoRelease(HttpContext context)
{
var hashTable = new Hashtable();
var weChatData = new Hashtable();
var infoReleaseDal = new InfoReleaseDal();
var infoReleaseDetailsDal = new InfoReleaseDetailsDal();
var accessToken = new AccessToken();
var sendDataToUser = new SendDataToWeChat();
var id = context.Request.Params["id"];
var ppid = context.Request.Params["ppid"];
var key = context.Request.Params["key"];
var title = context.Request.Params["title"];
var ms = context.Request.Params["ms"];
try
{
infoReleaseDal.Modify(new InfoRelease()
{
Id = id,
FlagRelease = "1",
SendPerson = ppid
});
var tmp = JsonConvert.DeserializeObject<List<Tmp>>(ppid);
if (tmp.Count > 0)
{
infoReleaseDetailsDal.Del(new InfoReleaseDetailsModel() { InfoReleaseId = id });
foreach (var t in tmp)
{
var weChatDataList = new List<object>();
weChatDataList.Add(new
{
title,
description = ms,
url = "http://218.22.27.236/views/messagelist/messagedetail_fxgz.htm?id=" + id + "&wxid=" + t.wxid,
picurl = "http://218.22.27.236/tl/UploadImages/" + key + ".jpg"
});
weChatData["touser"] = t.wxid;
weChatData["msgtype"] = "news";
weChatData["news"] = new
{
articles = weChatDataList
};
var json = _jss.Serialize(weChatData);
json = json.Replace("\\u0026", "&");
var token = accessToken.GetExistAccessToken();
var back = sendDataToUser.GetPage("https://api.weixin.qq.com/cgi-bin/message/custom/send?access_token=" + token, json);
var backData = JsonConvert.DeserializeObject<WeChatBackData>(back);
var infoReleaseDetailsModel = new InfoReleaseDetailsModel();
if (backData.errcode == 0 && backData.errmsg == "ok")
{
infoReleaseDetailsModel.State = "2";//待确认
}
else
{
infoReleaseDetailsModel.State = "1";//待推送
}
infoReleaseDetailsModel.Id = Guid.NewGuid().ToString();
infoReleaseDetailsModel.OpenId = t.wxid;
infoReleaseDetailsModel.NickName = t.nickname;
infoReleaseDetailsModel.RNumber = t.ywh;
infoReleaseDetailsModel.InfoReleaseId = id;
infoReleaseDetailsDal.Add(infoReleaseDetailsModel);
}
}
hashTable["isSuccess"] = true;
hashTable["jsMethod"] = "ajax_AddPersonToInfoRelease";
var json2 = _jss.Serialize(hashTable);
context.Response.Write(json2);
}
catch (Exception e)
{
Log.Debug("出错信息：" + e.Message);
}
}
