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;
}
}
