/// <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);
}
}
/// <summary>
/// 删除停电信息
/// </summary>
/// <param name="context"></param>
public void DelPowerInfo(HttpContext context)
{
var hashtable = new Hashtable();
var infoReleaseDal = new InfoReleaseDal();
var id = context.Request.Params["id"];
try
{
infoReleaseDal.Del(new InfoRelease() { Id = id });
hashtable["isSuccess"] = true;
hashtable["jsMethod"] = "ajax_DelPowerInfo";
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 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 QueryDetailInfo(HttpContext context)
{
var hashtable = new Hashtable();
var infoReleaseDal = new InfoReleaseDal();
var infoReleaseDetailsDal = new InfoReleaseDetailsDal();
var id = context.Request.Params["id"];
var wxid = context.Request.Params["wxid"];
try
{
var data = infoReleaseDal.QueryDetailInfo(new InfoRelease()
{
Id = id
});
//查询状态
var stateDt = infoReleaseDetailsDal.QueryState(wxid, id);
var state = stateDt.Rows.Count > 0 ? stateDt.Rows[0]["state"].ToString() : "2";
var list = from da in data.AsEnumerable()
select new
{
Title = da.Field<string>("Title"),
MaterialContent = da.Field<string>("MaterialContent"),
CreateDt = da.Field<DateTime?>("CreateDt")
};
hashtable["data"] = list.ToList();
hashtable["state"] = state;
hashtable["isSuccess"] = true;
hashtable["jsMethod"] = "ajax_QueryDetailInfo";
var json = _jss.Serialize(hashtable);
context.Response.Write(json);
}
catch (Exception e)
{
Log.Debug("错误原因：" + e.Message);
}
}
/// <summary>
/// 上传文件
/// </summary>
/// <param name="context"></param>
public void Add(HttpContext context)
{
Hashtable hash;
try
{
HttpPostedFile file = HttpContext.Current.Request.Files["Exclefile"];
if (file == null)
{
hash = new Hashtable();
hash["error"] = true;
hash["msg"] = "请选择文件";
var data = _jss.Serialize(hash);
context.Response.Write(data);
return;
}
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"] = true;
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"] = true;
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);
string fileUrl = saveUrl + newFileName;
hash = new Hashtable();
hash["error"] = false;
hash["url"] = fileUrl;
var title = HttpContext.Current.Request["title"] ?? "";
var month = context.Request["month"] ?? DateTime.Now.ToString("yyyy-MM");
InfoReleaseDal infoReleaseDal = new InfoReleaseDal();
string user = (string)context.Session["user"];
infoReleaseDal.Add(new InfoRelease()
{
Title = title,
MaterialContent = fileUrl,
CreateDt = DateTime.Now,
BusinessType = context.Request["key"],
CreatePerson = user,
FlagRelease = "0",
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);
}
}
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);
}
}
/// <summary>
/// 发送图文信息
/// </summary>
/// <param name="context"></param>
public void SendNewsMessage(HttpContext context)
{
var hashTable = new Hashtable();
var key = context.Request.Params["key"];
var type = context.Request.Params["type"];
var count = context.Request.Params["count"];
var accessToken = new AccessToken();
var sendDataToUser = new SendDataToWeChat();
var userInfoDal = new UserInfoDal();
var infoReleaseDal = new InfoReleaseDal();
var listnews = new List<object>();
try
{
//获取发布信息数据
var dataDt = infoReleaseDal.QueryInfo(new InfoRelease()
{
BusinessType = key,
FlagRelease = type
}, "2");//todo:替换count
var listDt = from ldt in dataDt.AsEnumerable()
select new
{
Title = ldt.Field<string>("Title"),
MessageDescription = ldt.Field<string>("MessageDescription")
};
foreach (var ldt in listDt)
{
listnews.Add(new
{
title = ldt.Title,
description = ldt.MessageDescription,
url = "http://218.22.27.236/views/messagelist/messagelist.htm?key=" + key + "&name=停电信息列表",
picurl = "http://218.22.27.236/tl/UploadImages/topleft.jpg"
});
}
//获取用户数据
var data = userInfoDal.QueryAll();
var list = from da in data.AsEnumerable()
select new
{
openid = da.Field<string>("openid"),
};
foreach (var li in list)
{
hashTable["touser"] = li.openid;
hashTable["msgtype"] = "news";
hashTable["news"] = new
{
articles = listnews
};
var json = _jss.Serialize(hashTable);
var token = accessToken.GetExistAccessToken();
var back = sendDataToUser.GetPage("https://api.weixin.qq.com/cgi-bin/message/custom/send?access_token=" + token, json);
Log.Debug("调试信息:" + back);
}
}
catch (Exception ex)
{
Log.Debug("错误信息:" + ex.Message);
}
}
/// <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);
}
}
/// <summary>
/// 查询信息
/// </summary>
/// <param name="httpContext"></param>
public void QueryPublishInfo(HttpContext httpContext)
{
var hashtable = new Hashtable();
var infoReleaseDal = new InfoReleaseDal();
var businesstype = httpContext.Request.Params["businesstype"];
//获取分页数据
var total = 0;
var page = int.Parse(httpContext.Request["page"] ?? "1");
var rows = int.Parse(httpContext.Request["rows"] ?? "10");
try
{
var data = infoReleaseDal.QueryByPage(new InfoRelease()
{
BusinessType = businesstype
}, page, rows, ref total);
var list = from da in data.AsEnumerable()
select new
{
Id = da.Field<string>("Id"),
Title = da.Field<string>("Title"),
MaterialContent = da.Field<string>("MaterialContent"),
MaterialType = da.Field<string>("MaterialType"),
FlagRelease = da.Field<string>("FlagRelease"),
MessageDescription = da.Field<string>("MessageDescription"),
CreateDt = da.Field<DateTime?>("CreateDt"),
CreatePerson = da.Field<string>("CreatePerson"),
Bak1 = da.Field<string>("Bak1"),
Bak2 = da.Field<string>("Bak2"),
Bak3 = da.Field<string>("Bak3"),
Bak4 = da.Field<string>("Bak4"),
SendGroup = da.Field<string>("SendGroup")
};
hashtable["rows"] = list.ToList();
hashtable["total"] = total;
var json = _jss.Serialize(hashtable);
httpContext.Response.Write(json);
}
catch (Exception e)
{
Log.Debug("方法名:QueryPowerInfo,描述:查询停电信息方法出错,错误原因:" + e.Message);
hashtable["isSuccess"] = false;
var json = _jss.Serialize(hashtable);
httpContext.Response.Write(json);
}
}
/// <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);
}
}
private void Query(HttpContext context)
{
try
{
//先查询有没有注册。对于已注册的，查询欠费列表；对于没有注册的，返回{"error":true,"msg":"Unreg"},前台判断后跳转到注册界面
var phone = context.Request["phone"] ?? "";
UserRegDal userRegDal = new UserRegDal();
DataTable dtReg = userRegDal.Query(new UserReg() { PhoneNumber = phone });
if (dtReg != null && dtReg.Rows.Count > 0)//已注册
{
var yhid = "";
foreach (DataRow row in dtReg.Rows)
{
yhid += row["RNumber"].ToString() + ",";
}
yhid = yhid.Remove(yhid.Length - 1, 1);
InfoReleaseDal dal = new InfoReleaseDal();
var dt = dal.Query(new InfoRelease() { FlagRelease = "1", BusinessType = "011_youo_dfzd" });
string file = "";
string createDt = "";
if (dt != null && dt.Rows.Count > 0)
{
file = dt.Rows[0]["MaterialContent"].ToString();
createDt = dt.Rows[0]["CreateDt"].ToString();
context.Response.Write(string.IsNullOrEmpty(yhid) ? "{\"error\":true,\"msg\":\"用户号为空。\"}" : ReadExcel(yhid, file, createDt));
}
else
{
context.Response.Write("{\"error\":true,\"msg\":\"没有数据。\"}");
return;
}
}
else
{
context.Response.Write("{\"error\":true,\"msg\":\"unreg\"}");//未注册
return;
}
}
catch (Exception ex)
{
context.Response.Write("{\"error\":true,\"msg\":\"" + ex.Message + "\"}");//未注册
Log.Error(ex);
}
}
private void GetUserName(HttpContext context)
{
try
{
var yhid = context.Request["yhid"] ?? "";
InfoReleaseDal dal = new InfoReleaseDal();
var dt = dal.Query(new InfoRelease() { FlagRelease = "1", BusinessType = "011_youo_dfzd" });
string file = "";
if (dt != null && dt.Rows.Count > 0)
{
file = dt.Rows[0]["MaterialContent"].ToString();
}
string sheetName = GetExcelSheetNames(file)[0];
string strSql = "select * from [" + sheetName + "$] where 用户编号 =" + yhid + "";
DataSet ds = GetDataTable(file, strSql);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
context.Response.Write("{\"error\":false,\"name\":\"" + ds.Tables[0].Rows[0]["用户名称"].ToString() +
"\"}");
}
else
{
context.Response.Write("{\"error\":true,\"msg\":\"用户号输入错误。\"}");
}
}
catch (Exception ex)
{
Log.Error(ex);
context.Response.Write("{\"error\":true,\"msg\":\"" + ex.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);
}
}
/// <summary>
/// 发送图文信息
/// </summary>
/// <param name="userid">用户id</param>
/// <param name="key">菜单id</param>
/// <param name="name">菜单名称</param>
/// <param name="type">业务类型</param>
/// <param name="count">查询数据数量</param>
public void SendNewsMessage(string userid, string key, string name, string type, string count)
{
var hashTable = new Hashtable();
var accessToken = new AccessToken();
var sendDataToUser = new SendDataToWeChat();
var infoReleaseDal = new InfoReleaseDal();
var listnews = new List<object>();
try
{
//获取发布信息数据
var dataDt = infoReleaseDal.QueryInfo(new InfoRelease()
{
BusinessType = key,
FlagRelease = type
}, count);
var listDt = from ldt in dataDt.AsEnumerable()
select new
{
Id = ldt.Field<string>("Id"),
Title = ldt.Field<string>("Title"),
MessageDescription = ldt.Field<string>("MessageDescription")
};
if (dataDt.Rows.Count > 1)
{
var name2 = HttpContext.Current.Server.UrlEncode(name);
listnews.Add(new
{
title = name + "更多列表...",
description = "",
url = _ip1 + "/views/messagelist/messagelist.htm?key=" + key + "&name=" + name2 + "&flag=1",
picurl = _ip1 + "/UploadImages/" + key + ".jpg"
});
}
foreach (var ldt in listDt)
{
if (dataDt.Rows.Count > 1)
{
listnews.Add(new
{
title = ldt.Title,
description = ldt.MessageDescription,
url = _ip1 + "/views/messagelist/messagedetail.htm?id=" + ldt.Id
});
}
else
{
listnews.Add(new
{
title = ldt.Title,
description = ldt.MessageDescription,
url = _ip1 + "/views/messagelist/messagedetail.htm?id=" + ldt.Id,
picurl = _ip1 + "/UploadImages/" + key + ".jpg"
});
}
}
hashTable["touser"] = userid;
hashTable["msgtype"] = "news";
hashTable["news"] = new
{
articles = listnews
};
var json = _jss.Serialize(hashTable);
var token = accessToken.GetExistAccessToken();
var back = sendDataToUser.GetPage("https://api.weixin.qq.com/cgi-bin/message/custom/send?access_token=" + token, json);
Log.Debug("调试信息:" + back);
}
catch (Exception ex)
{
Log.Debug("错误信息:" + ex.Message);
}
}
/// <summary>
/// 保存信息
/// </summary>
/// <param name="context"></param>
public void SavePublishInfoPhone(HttpContext context)
{
var hashtable = new Hashtable();
var infoReleaseDal = new InfoReleaseDal();
var key = context.Request.Params["key"];
var people = context.Request.Params["people"];
var title = context.Request.Params["title"];
var content = context.Request.Params["contents"];
var infoRelease = new InfoRelease();
infoRelease.Id = Guid.NewGuid().ToString();
infoRelease.BusinessType = key;
infoRelease.CreateDt = DateTime.Now;
infoRelease.CreatePerson = people;
infoRelease.FlagRelease = "1";
infoRelease.MaterialContent = content;
infoRelease.MaterialType = "news";
infoRelease.Title = title;
try
{
infoReleaseDal.Add(infoRelease);
hashtable["isSuccess"] = true;
var json = _jss.Serialize(hashtable);
context.Response.Write(json);
}
catch (Exception e)
{
Log.Debug("方法名:SavePublishInfoPhone,描述:保存停电信息方法出错,错误原因:" + 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="context"></param>
public void QueryMessageList(HttpContext context)
{
var hashtable = new Hashtable();
var infoReleaseDal = new InfoReleaseDal();
var key = context.Request.Params["key"];
var flag = context.Request.Params["flag"];
var wxid = context.Request.Params["wxid"];
try
{
var data = new DataTable();
switch (flag)
{
case "0"://0表示风险告知数据
data = infoReleaseDal.QueryByWxid(wxid);
break;
case "1"://表示停电告知等数据
if (key == "013_youo_jdzs")//这里用电知识只显示前20条数据
{
data = infoReleaseDal.Query2(new InfoRelease()
{
BusinessType = key,
FlagRelease = "'1','2'"
});
break;
}
else
{
data = infoReleaseDal.Query(new InfoRelease()
{
BusinessType = key,
FlagRelease = "'1','2'"
});
break;
}
}
var list = from da in data.AsEnumerable()
select new
{
Id = da.Field<string>("Id"),
Title = da.Field<string>("Title"),
MessageDescription = da.Field<string>("MessageDescription")
};
hashtable["data"] = list.ToList();
hashtable["isSuccess"] = true;
hashtable["jsMethod"] = "ajax_QueryMessageList";
var json = _jss.Serialize(hashtable);
context.Response.Write(json);
}
catch (Exception e)
{
Log.Debug("错误原因：" + e.Message);
}
}
