public void TestMethod1() { ///////////////////////////////////////////////////////// //测试嵌入 --------------------------- // --------------------------- //小马 大马 老马 --------------------------- //老马 讲讲 html --------------------------- // --------------------------- //------------------------------------------------- //我那个去。。。。。。。。。。。。。。!!!!!!!!/// //我那个去。。。。。。。。。。。。。。!!!!!!!!/// //我那个去。。。。。。。。。。。。。。!!!!!!!!/// //我那个去。。。。。。。。。。。。。。!!!!!!!!/// //我那个去。。。。。。。。。。。。。。!!!!!!!!/// //我那个去。。。。。。。。。。。。。。!!!!!!!!/// //我那个去。。。。。。。。。。。。。。!!!!!!!!/// //我那个去。。。。。。。。。。。。。。!!!!!!!!/// //我那个去。。。。。。。。。。。。。。!!!!!!!!/// //我那个去。。。。。。。。。。。。。。!!!!!!!!/// //我那个去。。。。。。。。。。。。。。!!!!!!!!/// UserInfoDal dal = new UserInfoDal(); Console.WriteLine(dal.GetEntities(u => true)); Console.ReadLine(); }
public List <UFSM_UserInfo> GetUserList(out string returnMessage) { UserInfoDal userInfoDal = new UserInfoDal(); List <UFSM_UserInfo> userList = userInfoDal.GetUserList(out returnMessage); return(userList); }
/// <summary> /// 购物车商品条目数 /// </summary> /// <param name="entId">企业</param> /// <param name="userId">用户</param> /// <param name="ywyId">业务员</param> /// <returns></returns> public ActionResult NumberOfItems(string entId, string userId, string ywyId = "") { try { if (string.IsNullOrEmpty(userId)) { return(Json(new { success = false, message = "用户未登录,请先登录" })); } ///获取用户信息 UserInfoDal dal = new UserInfoDal(); List <UserInfo> user = dal.GetUserInfo(userId, entId); if (user.Count <= 0) { return(Json(new { success = false, message = "用户未登录,请重新登录" })); } ///获取购物车信息 CartDal cdal = new CartDal(); int num = cdal.GetCartCount(entId, userId, ywyId); return(Json(new { success = true, message = "购物车商品条目数获取成功", num })); } catch (Exception ex) { LogQueue.Write(LogType.Error, "Cart/NumberOfItems", ex.Message.ToString()); return(Json(new { success = false, message = ex.Message.ToString() })); } }
/// <summary> /// 向数据库注册UserInfo,返回一个bool。 /// </summary> /// <param name="user">注册的UserInfo对象</param> /// <param name="returnMessage">返回注册信息字符串:如注册成功、失败</param> /// <returns></returns> public bool AddUserInfo(UserInfo user, out string returnMessage) { foreach (UserInfo u in userList) { if (user.Account == u.Account) { returnMessage = "对不起,该账号名已被占用!"; return(false); } } UserInfoDal uid = new UserInfoDal(); int influenceRow = uid.AddUserInfo(user); if (influenceRow > 0) { userList = new UserInfoDal().GetUserInfoList(); returnMessage = "注册成功,请返回登录"; return(true); } else { returnMessage = "数据库异常,注册失败,请稍后重试"; return(false); } }
/// <summary> /// 获取购物车金额 /// </summary> /// <param name="entId">企业Id</param> /// <param name="userId">用户id</param> /// <param name="goodsList">选中的商品id</param> /// <returns></returns> public JsonResult CartAmount(string entId, string userId, string goodsList, string ywyId = "") { try { if (string.IsNullOrEmpty(userId)) { return(Json(new { success = false, message = "用户未登录,请先登录" })); } ///获取用户信息 UserInfoDal dal = new UserInfoDal(); List <UserInfo> user = dal.GetUserInfo(userId, entId); if (user.Count <= 0) { return(Json(new { success = false, message = "E002" })); } ///获取购物车信息 CartDal cdal = new CartDal(); List <CartList> list = cdal.GetCartAmount(user[0].EntId, userId, goodsList, user[0].Pricelevel, user[0].KhType, ywyId); return(Json(new { success = true, list = list })); } catch (Exception ex) { LogQueue.Write(LogType.Error, "Cart/CartAmount", ex.Message.ToString()); return(Json(new { success = false, message = ex.Message.ToString() })); } }
public JsonResult GetBrandList(string userId, string faType, string billno, string entId, int pageIndex = 1, int pageSize = 3) { try { if (string.IsNullOrEmpty(entId)) { entId = BaseConfiguration.EntId; } ///获取用户信息 UserInfoDal dal = new UserInfoDal(); List <UserInfo> user = dal.GetUserInfo(userId, entId); bool landing = false; bool staleDated = false; string Pricelevel = ""; string KhType = ""; if (user.Count > 0) { entId = user[0].EntId; Pricelevel = user[0].Pricelevel; KhType = user[0].KhType; landing = true; staleDated = user[0].StaleDated; } BrandDal bdal = new BrandDal(); List <BrandList> list = bdal.GetBrandList(entId, userId, Pricelevel, KhType, landing, staleDated, faType, billno, pageIndex, pageSize, out int recordCount, out int pageCount); return(Json(new { success = true, list = list, recordCount = recordCount, pageCount = pageCount })); } catch (Exception ex) { LogQueue.Write(LogType.Error, "Brand/GetBrandList", ex.Message); return(Json(new { success = false, message = ex.Message })); } }
public void TestGetUsers() { //单元测试是没用的,浪费开发时间而已? //1、节省的改bug的时间。 //2、对项目非常有自信。 //3、单元测试也是一种设计(写单元测试的时候促进对方法进行再思考) //4、它也是一种 项目管理的手段。TDD:测试驱动开发。 //测试 获取数据的方法。 UserInfoDal dal = new UserInfoDal(); //单元测y试必须自己处理数据,不能依赖第三方数据。如果依赖数据那么先自己创建数据,然后用完之后再清除数据。 //创建测试的数据 for (var i = 0; i < 10; i++) { dal.Add(new UserInfo() { UName = i + "ssss" }); } IQueryable <UserInfo> temp = dal.GetEntities(u => u.DelFlag == DeleteFlag.DelflagNormal && u.UName.Contains("ss")); //断言 Assert.AreEqual(true, temp.Count() >= 10); ///////////////////葛洋洋 ////喜洋洋,慢洋洋! }
public void Remove() { IUserInfoDal userInfoDal = new UserInfoDal(new SqlConnection("server=.;uid=sa;pwd=123456;database=MultilayerFrameworkSampleDb")); var result = userInfoDal.Remove("53cd0b6a63336783"); result.Should().BeTrue(); }
static void GenerateUserInfo(int num) { UserInfoDal dal = new UserInfoDal(); DbSession dbSession = new DbSession(); for (int i = 0; i < num; i++) { UserInfo user = new UserInfo(); user.UserInfoLoginId = Guid.NewGuid().ToString().Substring(0, 10); user.UserInfoShowName = (Faker.Name.First() + Faker.Name.First()).Substring(3); user.UserInfoPwd = MD5Helper.Get_MD5(Faker.Name.First()).Substring(3); user.UserInfoStuId = Faker.Phone.Extension() + Faker.Phone.Extension(); user.MajorID = new Random().Next(1, 5); user.UserInfoEmail = Faker.Internet.FreeEmail().Substring(0, 10); user.OrganizeInfoID = new Random().Next(3, 10); user.PoliticalID = new Random().Next(1, 12); user.DepartmentID = new Random().Next(2, 7); user.UserInfoTalkCount = new Random().Next(100); user.UserInfoIcon = "/Content/Upload/images/1.jpg"; user.UserInfoLastTime = Convert.ToDateTime(Faker.Business.CreditCardExpiryDate()); user.CreateTime = user.UserInfoLastTime.AddMonths(-10); user.ModfiedOn = user.UserInfoLastTime.AddMonths(-4); user.Status = (short)((new Random().Next(9)) % 3); dal.Add(user); } dbSession.SaveChanges(); }
public void GetUsersTest() { IUserInfoDal dal = new UserInfoDal(); // Insert test data for (var i = 0; i < 10; i++) { dal.Add(new UserInfo() { UserName = "******" + i, FirstName = "firstName" + i, LastName = "lastName" + i, Password = "******" + i }); } IQueryable <UserInfo> temp = dal.GetEntities(u => true); Assert.AreEqual(true, temp.Count() >= 10); //Assert.Fail(); }
/// <summary> /// 再次购买 /// </summary> /// <param name="userId">用户Id</param> /// <param name="entId">机构Id</param> /// <param name="billNo">订单序号</param> /// <returns></returns> public JsonResult OnceAgain(string userId, string entId, int billNo, string cartType, string bs = "XQ", string loginId = "") { try { if (string.IsNullOrEmpty(userId)) { LogQueue.Write(LogType.Error, "Cart/OnceAgain", $"userId:{userId},entId:{entId},billNo:{billNo}"); return(Json(new{ success = false, message = "用户未登录,请先登录!" })); } ///获取用户信息 UserInfoDal udal = new UserInfoDal(); List <UserInfo> user = udal.GetUserInfo(userId, entId); string jgjb = "", khType = ""; if (user.Count > 0) { jgjb = user[0].Pricelevel; khType = user[0].KhType; } CartDal dal = new CartDal(); string result = dal.OnceAgain(userId, entId, billNo, loginId, out bool flag, jgjb, khType, cartType, bs); return(Json(new { success = flag, message = result })); } catch (Exception ex) { LogQueue.Write(LogType.Error, "Cart/OnceAgain", ex.Message.ToString()); return(Json(new { success = false, message = ex.Message })); } }
/// <summary> /// 结算可用优惠券 /// </summary> /// <param name="userId"></param> /// <param name="entId"></param> /// <param name="goodsList"></param> /// <returns></returns> public JsonResult UsableCoupon(string userId, string entId, string goodsList, int pageIndex, int pageSize, string channelName, string ywyId = "") { try { if (string.IsNullOrEmpty(userId)) { return(Json(new { success = false, message = "用户未登录,请先登录" })); } ///获取用户信息 UserInfoDal udal = new UserInfoDal(); List <UserInfo> user = udal.GetUserInfo(userId, entId); if (user.Count <= 0) { return(Json(new { success = false, message = "E002" })); } ///获取金额信息 OrderInfoDal cdal = new OrderInfoDal(); OrderAmount Amount = cdal.OrderOriginalAmount(user[0].EntId, userId, goodsList, user[0].Pricelevel, user[0].KhType, "", "", ywyId)[0]; decimal OrdersAmount = Amount.OrdersAmount; decimal RealAmount = Amount.RealAmount; decimal DiscountAmount = Amount.DiscountAmount; decimal PtAmount = Amount.PtAmount; var dal = new CouponDal(); List <UserCoupon> list = dal.UsableCoupon(userId, entId, goodsList, pageIndex, pageSize, ywyId, out int pageCount, out int recordCount, channelName, user[0].Pricelevel, user[0].KhType, OrdersAmount, RealAmount, DiscountAmount, PtAmount);
public void GetAllUserInfoTest() { UserInfoDal dal = new UserInfoDal(); var userList = dal.GetAllEntities(); Console.WriteLine(userList.Count()); Assert.AreEqual(true, 15 > userList.Count()); }
public void Add() { IUserInfoDal userInfoDal = new UserInfoDal(new SqlConnection("server=.;uid=sa;pwd=123456;database=MultilayerFrameworkSampleDb")); var result = userInfoDal.RegisterAccount(new MultilayerFrameworkSample.Dto.RegisterDto { EMail = "*****@*****.**", Password = "******" }); result.Should().BeTrue(); }
public void Update() { IUserInfoDal userInfoDal = new UserInfoDal(new SqlConnection("server=.;uid=sa;pwd=123456;database=MultilayerFrameworkSampleDb")); var result = userInfoDal.Modify(new UserInfo { Id = "53cd0b6a63336783", EMail = "*****@*****.**", Password = "******" }); result.Should().BeTrue(); }
public ActionResult Delete(int id) { UserInfoDal ud = new UserInfoDal(); UserInfoService us = new UserInfoService(); //BaseDal<UserInfo>.GetEntities(u => u.UserId ==id); // ViewData.Model = ud.GetUserInfoById(id); ViewData.Model = UserInfoService.Get(id); return(View()); }
/// <summary> /// 查询所有用户的信息 /// </summary> /// <returns></returns> public static List <UserInfo> SelectAllUser() { List <UserInfo> list = UserInfoDal.SelectAllUser(); if (list != null && list.Count() > 0) { return(list); } return(null); }
public ActionResult SearchFastGoods(string entid, string userId, string searchValue) { try { if (string.IsNullOrEmpty(entid) || string.IsNullOrEmpty(userId)) { return(Json(new { flag = 0, message = "请先登录!" })); } //获取用户信息 UserInfoDal dal = new UserInfoDal(); List <UserInfo> user = new List <UserInfo>(); if (!string.IsNullOrEmpty(userId)) { user = dal.GetUserInfo(userId, entid); } string jgjb = "", clientlimit = "", KhType = ""; bool landing = false; bool staleDated = false; if (user.Count > 0) { entid = user[0].EntId; jgjb = user[0].Pricelevel; clientlimit = user[0].ClientLimit; KhType = user[0].KhType; staleDated = user[0].StaleDated; landing = true; } GoodsInfoDal infoDal = new GoodsInfoDal(); if (searchValue.Trim().Contains(" ")) { int length = searchValue.Length; int index = searchValue.IndexOf(" "); string goodsValue, factoryValue; goodsValue = searchValue.Substring(0, index).Trim(); factoryValue = searchValue.Substring(index, length - index).ToString().Trim(); searchValue = goodsValue + ',' + factoryValue; } List <GoodsList> lists = new List <GoodsList>(); lists = infoDal.SearchFastGoods(entid, searchValue, jgjb, KhType, landing, staleDated); if (lists == null) { return(Json(new { flag = 2, message = "无符合商品!" })); } else { return(Json(new { flag = 2, message = "商品查询成功!", lists })); } } catch (Exception ex) { LogQueue.Write(LogType.Error, "Search/SearchFastGoods", ex.Message.ToString()); return(Json(new { flag = 99, message = "商品获取失败!" })); } }
static void Main(string[] args) { UserInfoDal dal = new UserInfoDal(); var userInfo = dal.GetEntities(u => true).FirstOrDefault(); //var userInfo = // UserInfoService.GetEntities(u => u.UName == name && u.Pwd == pwd && u.DelFlag == delNormal) // .FirstOrDefault(); Console.WriteLine("ok"); Console.ReadLine(); }
/// <summary> /// 查询指定账号 /// </summary> /// <param name="useraccount">账号</param> /// <returns></returns> public static bool SelectUserAccount(string useraccount) { if (UserInfoDal.SelectUserAccount(useraccount) == null) { return(true); } else { return(false); } }
public void AddTest() { UserInfoDal dal = new UserInfoDal(); UserInfo user = new UserInfo(); user.UName = "曹操1103"; user.Pwd = "123456"; user.ShowName = "曹阿瞒"; bool sum = dal.Add(user); Assert.AreEqual(true, sum); }
/// <summary> /// 注册账户 /// </summary> /// <param name="userinfo">注册账户实体</param> /// <returns>是否注册成功</returns> public bool AddUserInfo(UserInfo userinfo) { try { UserInfoDal userinfoDal = new UserInfoDal(); return(userinfoDal.AddUser(userinfo)); } catch (System.Exception ex) { throw new Exception.BllException(ex.Message); } }
public UserInfo GetUserInfo(string username, string password) { try { UserInfoDal dal = new UserInfoDal(); return(dal.GetUser(username, password)); } catch (System.Exception ex) { throw new Exception.BllException(ex.Message); } }
public bool CheckUserInfo(string account, string pwd, out string returnMessage) { UserInfoDal userInfoDal = new UserInfoDal(); UFSM_UserInfo user = userInfoDal.CheckUserInfo(account, pwd, out returnMessage); if (user != null) { StaticObject.user = user; return(true); } else { return(false); } }
static void DeleteUser() { int id = 3; UserInfoDal userInfoDal = new UserInfoDal(); var d = userInfoDal.Delete(id); if (d) { Console.WriteLine("成功"); } else { Console.WriteLine("失败"); } }
public JsonResult OftenBuy(string userId, string entId, string searchValue, int pageIndex = 1, int pageSize = 15) { try { if (string.IsNullOrEmpty(entId) || string.IsNullOrEmpty(userId)) { return(Json(new { success = false, message = "请先登录" })); } //获取用户信息 UserInfoDal dal = new UserInfoDal(); List <UserInfo> user = new List <UserInfo>(); if (!string.IsNullOrEmpty(userId)) { user = dal.GetUserInfo(userId, entId); } string jgjb = "", clientlimit = "", KhType = ""; bool landing = false; bool staleDated = false; if (user.Count > 0) { entId = user[0].EntId; jgjb = user[0].Pricelevel; clientlimit = user[0].ClientLimit; KhType = user[0].KhType; staleDated = user[0].StaleDated; landing = true; } GoodsInfoDal infoDal = new GoodsInfoDal(); if (searchValue.Trim().Contains(" ")) { int length = searchValue.Length; int index = searchValue.IndexOf(" "); string goodsValue, factoryValue; goodsValue = searchValue.Substring(0, index).Trim(); factoryValue = searchValue.Substring(index, length - index).ToString().Trim(); searchValue = goodsValue + ',' + factoryValue; } List <GoodsList> lists = new List <GoodsList>(); lists = infoDal.OftenBuy(userId, entId, searchValue, jgjb, KhType, landing, staleDated, pageIndex, pageSize, out int pageCount, out int recordCount); return(Json(new { success = true, message = "常购商品获取成功", lists, pageCount, recordCount })); } catch (Exception ex) { LogQueue.Write(LogType.Error, "Search/OftenBuy", $"{ex.Message}"); return(Json(new { success = false, message = "常购商品获取失败!" })); } }
public bool ChangeUserInfo(UserInfo user, out string returnMessage) { UserInfoDal userInfoDal = new UserInfoDal(); if (userInfoDal.ChangeUserInfo(user) > 0) { userList = new UserInfoDal().GetUserInfoList(); returnMessage = "修改成功"; return(true); } else { returnMessage = "数据库异常,修改失败,请稍后重试"; return(false); } }
/// <summary> /// 判断员工的登录时间是否修改成功 /// </summary> /// <param name="name"></param> /// <returns>返回值位ture成功否知失败</returns> public static bool UpdateUser(string name) { int a = UserInfoDal.UpdateUser(name); if (a == 0) { return(false); } else if (a > 0) { return(true); } else { return(false); } }
/// <summary> /// 判断是否注册成功 /// </summary> /// <param name="name">注册账号</param> /// <param name="pwd">注册密码</param> /// <returns>返回ture成功返回false失败</returns> public static bool AddUser(string name, string pwd) { int a = UserInfoDal.AddUser(name, pwd); if (a == 0) { return(false); } else if (a > 0) { return(true); } else { return(false); } }
/// <summary> /// 同类商品推荐 /// </summary> /// <param name="entId">企业</param> /// <param name="userId">用户</param> /// <param name="articleId">商品ID</param> /// <param name="num">条目数</param> /// <returns></returns> public ActionResult Commendation(string entId, string userId, string articleId, int num) { try { if (string.IsNullOrEmpty(entId)) { entId = BaseConfiguration.EntId; } if (string.IsNullOrEmpty(articleId)) { return(Json(new { success = false, message = "参数异常" })); } ///获取用户信息 UserInfoDal dal = new UserInfoDal(); List <UserInfo> user = new List <UserInfo>(); if (!string.IsNullOrEmpty(userId)) { user = dal.GetUserInfo(userId, entId); } string jgjb = "", clientlimit = "", KhType = ""; bool landing = false; bool staleDated = false; //获取客户价格级别 if (user.Count > 0) { entId = user[0].EntId; jgjb = user[0].Pricelevel; clientlimit = user[0].ClientLimit; KhType = user[0].KhType; staleDated = user[0].StaleDated; landing = true; } GoodsInfoDal infoDal = new GoodsInfoDal(); ///商品详情 List <GoodsList> list = infoDal.GetGoodDetail(userId, articleId, entId); var category = list[0].GoodsInfo[0].Category; //同类商品推荐 List <Models.GoodsInfo> klist = infoDal.Commendation(entId, category, num, jgjb, KhType, landing, staleDated); return(Json(new { success = true, message = "商品推荐获取成功", klist })); } catch (Exception ex) { LogQueue.Write(LogType.Error, "Goods/Commendation", ex.Message.ToString()); return(Json(new { success = false, message = "商品推荐加载失败!" })); } }
/// <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="context"></param> public void PublishInfoToPerson(HttpContext context) { var hashtable = new Hashtable(); var infoReleaseDal = new PowerCutDal(); var userInfoDal = new UserInfoDal(); var id = context.Request.Params["id"]; try { infoReleaseDal.Modify(new PowerCut() { Id = id, FlagRelease = "2" }); 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 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 SendTxtMessage(HttpContext context) { var hashTable = new Hashtable(); var accessToken = new AccessToken(); var sendDataToUser = new SendDataToWeChat(); var userInfoDal = new UserInfoDal(); try { 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"] = "text"; hashTable["text"] = new { content = "你好张威,这是你的测试内容" }; 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); } }
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); } } }