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