public int GetReadOrNoReadCount(long id, string type) { MessageDetial md = (from a in context.MessageDetial where a.Id == id select a).FirstOrDefault <MessageDetial>(); List <MessageRevice> mrList = (from a in context.MessageRevice where a.MsgId == md.Id select a).ToList <MessageRevice>(); int Read = 0; int Noread = 0; foreach (MessageRevice item in mrList) { if (item.ReadFlag == 0) { Noread++; } else { Read++; } } if (type == "read") { return(Read); } else { return(Noread); } }
/// <summary> /// 发送订单支付消息 /// </summary> /// <param name="UserId"></param> /// <param name="OrderNo"></param> /// <param name="SendUserName"></param> /// <param name="OrderMoney"></param> /// <returns></returns> public bool SendOrderPayMessage(long UserId, string OrderNo, decimal OrderMoney) { string MessageContent = ""; int Languagetype = int.Parse(System.Configuration.ConfigurationManager.AppSettings["Language"].ToString()); MessageSetting message = context.MessageSetting.FirstOrDefault((MessageSetting m) => (int)m.MessageNameId == 2 && m.Languagetype == Languagetype && m.ActiveStatus == 1); if (message != null) { MessageContent = message.MessageContent; UserMemberInfo UserInfo = context.UserMemberInfo.FirstOrDefault((UserMemberInfo m) => m.Id == UserId && m.UserType == 3); string str = MessageContent.Replace("#userName", UserInfo.UserName).Replace("#OrderNo", OrderNo).Replace("#OrdePayTime", DateTime.Now.ToString()).Replace("#OrderMoney", OrderMoney.ToString()); MessageDetial md = new MessageDetial() { ManagerId = 2, MessageTitleId = 2, MessageTitle = MessageSetting.MessageModuleStatus.OrderPay.ToDescription(), MessageContent = str, LanguageType = int.Parse(System.Configuration.ConfigurationManager.AppSettings["Language"].ToString()), MsgType = 2, SendTime = DateTime.Now, SendObj = 2 }; SendMessage(md, UserId, null); } return(true); }
/// 限额审核 /// </summary> /// <param name="UserId"></param> /// <param name="SendUserName"></param> /// <returns></returns> public bool SendLimitedAmountMessage(long UserId) { string MessageContent = ""; int Languagetype = int.Parse(System.Configuration.ConfigurationManager.AppSettings["Language"].ToString()); MessageSetting message = context.MessageSetting.FirstOrDefault((MessageSetting m) => (int)m.MessageNameId == 21 && m.Languagetype == Languagetype && m.ActiveStatus == 1); if (message != null) { MessageContent = message.MessageContent; UserMemberInfo UserInfo = context.UserMemberInfo.FirstOrDefault((UserMemberInfo m) => m.Id == UserId && m.UserType == 3); string str = MessageContent.Replace("#userName", UserInfo.UserName); MessageDetial md = new MessageDetial() { ManagerId = 2, MessageTitleId = 21, MessageTitle = MessageSetting.MessageModuleStatus.LimitedAount.ToDescription(), MessageContent = str, LanguageType = int.Parse(System.Configuration.ConfigurationManager.AppSettings["Language"].ToString()), MsgType = 2, SendTime = DateTime.Now, //采购商是3 SendObj = 3 }; SendMessage(md, UserId, null); } return(true); }
public JsonResult SendMail(string username, string email) { bool falg = false; UserMemberInfo _userinfo = ServiceHelper.Create <IMemberService>().GetMemberByName(username); if (_userinfo != null) { string password = _userinfo.Password; int usertype = _userinfo.UserType; string mailsubject = "ChemCloud,Welcome To Join ChemCloud"; string mailcontent = "Welcome To ChemCloud!"; MessageSetting model = ServiceHelper.Create <IMessageSettingService>().GetSettingByMessageNameId(ChemCloud.Model.MessageSetting.MessageModuleStatus.RegisterMailContent); if (usertype == 2) { model = ServiceHelper.Create <IMessageSettingService>().GetSettingByMessageNameId(ChemCloud.Model.MessageSetting.MessageModuleStatus.RegisterMailContent_GYS); } if (model != null) { mailcontent = model.MessageContent == null ? mailcontent : model.MessageContent; } string str = mailcontent.Replace("@account", username).Replace("@username", username).Replace("@password", password); string currentrooturl = ChemCloud.Core.Common.GetRootUrl(""); str = str.Replace("@httpurl", currentrooturl); falg = ChemCloud.Service.SendMail.SendEmail(email, mailsubject, str); /*供应商 账号注册成功后,提醒平台审核*/ if (usertype == 2) { MessageDetial md = new MessageDetial() { ManagerId = _userinfo.Id, MessageTitleId = 17, MessageTitle = "供应商注册待审核", MessageContent = "供应商" + _userinfo.UserName + "注册成功待审核!", LanguageType = 1, MsgType = 2, SendTime = DateTime.Now, SendObj = 1 }; ServiceHelper.Create <ISiteMessagesService>().SendMessage(md, 2, null); } } Result result = new Result(); result.msg = falg.ToString(); result.success = falg; return(Json(result)); }
public PageModel <MessageRevice> GetMessageDetialByUserId(MessageReviceQuery mrq) { int pageNum = 0; IQueryable <MessageRevice> mr = from item in base.context.MessageRevice where item.UserId == mrq.UserId && item.MessageDetial.LanguageType == mrq.Languagetype select item; foreach (MessageRevice mrs in mr.ToList()) { MessageDetial md = (from item in base.context.MessageDetial where item.Id == mrs.MsgId select item).FirstOrDefault(); mrs.MessageDetial.LanguageType = int.Parse(System.Configuration.ConfigurationManager.AppSettings["Language"].ToString()); mrs.MessageDetial.ManagerId = 2; mrs.MessageDetial.MessageContent = md.MessageContent; mrs.MessageDetial.MessageTitleId = md.MessageTitleId; if (md.MessageTitleId != 20) { mrs.MessageDetial.MessageTitle = ((MessageSetting.MessageModuleStatus)md.MessageTitleId).ToDescription(); } mrs.MessageDetial.MessageTitle = md.MessageTitle; mrs.MessageDetial.MsgType = md.MsgType; mrs.MessageDetial.SendObj = md.SendObj; } if (mrq.ReadFlag != 0) { mr = (from a in mr where a.ReadFlag == mrq.ReadFlag select a); } string begin = mrq.BeginTime.ToString("yyyy/MM/dd", System.Globalization.DateTimeFormatInfo.InvariantInfo); string end = mrq.EndTime.ToString("yyyy/MM/dd", System.Globalization.DateTimeFormatInfo.InvariantInfo); if (!string.IsNullOrWhiteSpace(begin) && !begin.Equals("0001/01/01") && !string.IsNullOrWhiteSpace(end) && !end.Equals("0001/01/01")) { mr = (from a in mr where a.SendTime >= mrq.BeginTime && a.SendTime <= mrq.EndTime select a); } //mr = (from a in mr where a.IsShow == 0 select a); foreach (MessageRevice mrs in mr.ToList()) { ManagerInfo manaInfo = context.ManagerInfo.FirstOrDefault((ManagerInfo m) => m.Id == mrs.MessageDetial.ManagerId); mrs.MessageDetial.SendName = (manaInfo == null ? "" : manaInfo.UserName); UserMemberInfo userInfo = context.UserMemberInfo.FirstOrDefault((UserMemberInfo m) => m.Id == mrs.UserId); mrs.UserName = userInfo.UserName; //mrs.MessageDetial.MessageTitle = ((MessageSetting.MessageModuleStatus)mrs.MessageDetial.MessageTitleId).ToDescription(); } mr = mr.GetPage(out pageNum, mrq.PageNo, mrq.PageSize, (IQueryable <MessageRevice> d) => from o in d orderby o.SendTime descending select o); return(new PageModel <MessageRevice> { Models = mr, Total = pageNum }); }
public void AddMessageDetial(MessageDetial md, string[] ids, string[] urls) { try { context.MessageDetial.Add(md); context.SaveChanges(); } catch (DbEntityValidationException ex) { } string[] idArray = ids; List <MessageRevice> mrList = new List <MessageRevice>(); foreach (string item in idArray) { MessageRevice mr = new MessageRevice(); mr.UserId = Convert.ToInt64(item); mr.ReadFlag = 1; mr.VisiableFlag = 0; mr.MsgId = md.Id; mr.SendTime = md.SendTime; mr.IsShow = 0; mrList.Add(mr); } List <MessageEnclosure> meList = new List <MessageEnclosure>(); if (urls != null) { foreach (string item in urls) { MessageEnclosure me = new MessageEnclosure(); me.MsgId = md.Id; me.Url = item; meList.Add(me); } context.MessageEnclosure.AddRange(meList); } context.MessageRevice.AddRange(mrList); try { context.SaveChanges(); } catch (System.Data.Entity.Validation.DbEntityValidationException ex) { } }
public JsonResult ModuleSendMessage(SiteMessageAddQuery SiteMessageInfo) { MessageDetial md = new MessageDetial(); md.ManagerId = base.CurrentManager.Id; md.MessageTitleId = SiteMessageInfo.MessageTitleId; md.MessageContent = SiteMessageInfo.MessageContent; md.LanguageType = SiteMessageInfo.LanguageType; md.MsgType = 2; md.SendTime = DateTime.Now; md.SendObj = SiteMessageInfo.ReceType; ServiceHelper.Create <IMessageDetialService>().AddMessageDetial(md, SiteMessageInfo.Ids, null); Result res = new Result(); res.success = true; return(Json(res)); }
//receType: value, messageContent: $("#MessageContent").html(), ids: IdArray int receType, int messageTitleId,string messageTitle, string MessageContent,int LanguageType, string[] ids public JsonResult SendMessage(MessageDetialAddQuery model) { MessageDetial md = new MessageDetial(); md.ManagerId = base.CurrentManager.Id; md.MessageTitleId = model.MessageTitleId; md.MessageTitle = model.MessageTitle; md.MessageContent = model.MessageContent; md.LanguageType = model.LanguageType; md.MsgType = 1; md.SendTime = DateTime.Now; md.SendObj = model.ReceType; ServiceHelper.Create <IMessageDetialService>().AddMessageDetial(md, model.Ids, null); Result res = new Result(); res.success = true; return(Json(res)); }
public MessageRevice GetMessageById(long Id) { MessageRevice mr = context.MessageRevice.FirstOrDefault((MessageRevice m) => m.Id == Id); MessageDetial md = context.MessageDetial.FirstOrDefault((MessageDetial m) => m.Id == mr.MsgId); mr.MessageDetial.LanguageType = md.LanguageType; mr.MessageDetial.ManagerId = md.ManagerId; mr.MessageDetial.MessageContent = md.MessageContent; mr.MessageDetial.MessageTitleId = md.MessageTitleId; mr.MessageDetial.MessageTitle = ((MessageSetting.MessageModuleStatus)md.MessageTitleId).ToDescription(); mr.MessageDetial.MsgType = md.MsgType; mr.MessageDetial.SendObj = md.SendObj; ManagerInfo manaInfo = context.ManagerInfo.FirstOrDefault((ManagerInfo m) => m.Id == mr.MessageDetial.ManagerId); mr.MessageDetial.SendName = (manaInfo == null ? "" : manaInfo.UserName); UserMemberInfo userInfo = context.UserMemberInfo.FirstOrDefault((UserMemberInfo m) => m.Id == mr.UserId); mr.UserName = userInfo.UserName; return(mr); }
public object GetReadState(long id) { MessageDetial md = (from a in context.MessageDetial where a.Id == id select a).FirstOrDefault <MessageDetial>(); List <MessageRevice> mrList = (from a in context.MessageRevice where a.MsgId == md.Id select a).ToList <MessageRevice>(); int Read = 0; int Noread = 0; foreach (MessageRevice item in mrList) { if (item.ReadFlag == 0) { Noread++; } else { Read++; } } return(new { Read = Read, Noread = Noread }); }
public bool DeleteMessageDetial(long id) { MessageDetial md = (from a in context.MessageDetial where a.Id == id select a).FirstOrDefault <MessageDetial>(); context.MessageDetial.Remove(md); List <MessageRevice> list = (from a in context.MessageRevice where a.MsgId == md.Id select a).ToList <MessageRevice>(); context.MessageRevice.RemoveRange(list); List <MessageEnclosure> meList = (from a in context.MessageEnclosure where a.MsgId == md.Id select a).ToList <MessageEnclosure>(); context.MessageEnclosure.RemoveRange(meList); int i = context.SaveChanges(); if (i > 0) { return(true); } else { return(false); } }
public void SendMessage(MessageDetial md, long userId, string[] urls) { context.MessageDetial.Add(md); context.SaveChanges(); List <MessageRevice> mrList = new List <MessageRevice>(); MessageRevice mr = new MessageRevice(); mr.UserId = userId; mr.ReadFlag = 1; mr.VisiableFlag = 0; mr.MsgId = md.Id; mr.SendTime = md.SendTime; mr.IsShow = 0; mrList.Add(mr); List <MessageEnclosure> meList = new List <MessageEnclosure>(); if (urls != null) { foreach (string item in urls) { MessageEnclosure me = new MessageEnclosure(); me.MsgId = md.Id; me.Url = item; meList.Add(me); } context.MessageEnclosure.AddRange(meList); } context.MessageRevice.AddRange(mrList); try { context.SaveChanges(); } catch (System.Data.Entity.Validation.DbEntityValidationException ex) { throw; } }