//获取上一封或下一封的ID public void GetMessageUN(HttpContext context) { int MessageID = Convert.ToInt32(context.Request["MessageID"]); int UserID = UserService.CurrentUser.UserID; int NextOrLast = Convert.ToInt32(context.Request["NextOrLast"]); int Type = Convert.ToInt32(context.Request["Type"]); IES.CC.Model.Test.Message message = new IES.CC.Model.Test.Message { MessageID = MessageID, UserID = UserID, NextOrLast = NextOrLast, Type = Type }; IES.G2S.CourseLive.BLL.Test.MessageBLL messagebll = new IES.G2S.CourseLive.BLL.Test.MessageBLL(); IES.CC.Model.Test.Message _mess = messagebll.Message_Get(message); if (_mess != null) { context.Response.Write(Newtonsoft.Json.JsonConvert.SerializeObject(_mess)); } else { context.Response.Write("False"); } }
//发送消息 public void MessageAdd(HttpContext context) { bool IsForMail; bool IsForSMS; int MessageID = 0; var Title = context.Request["Title"]; var Conten = context.Request["Conten"]; int SendUserID = UserService.CurrentUser.UserID; int True = Convert.ToInt32(context.Request["IsForMail"]); if (True == 1) { IsForMail = true; } else { IsForMail = false; } int False = Convert.ToInt32(context.Request["IsForSMS"]); if (False == 1) { IsForSMS = true; } else { IsForSMS = false; } var ReceiveUserIDs = context.Request["ReceiveUserIDs"]; IES.CC.Model.Test.Message message = new IES.CC.Model.Test.Message { MessageID = MessageID, Title = Title, Conten = Conten, SendUserID = SendUserID, IsForMail = IsForMail, IsForSMS = IsForSMS, ReceiveUserIDs = ReceiveUserIDs }; IES.G2S.CourseLive.BLL.Test.MessageBLL messagebll = new IES.G2S.CourseLive.BLL.Test.MessageBLL(); IES.CC.Model.Test.Message _message = messagebll.Message_Add(message); if (_message != null) { context.Response.Write("true"); } else { context.Response.Write("False"); } }
//根据信息ID获取姓名,ID public void User_NameID_List(HttpContext context) { int UserID = UserService.CurrentUser.UserID; int MessageID = Convert.ToInt32(context.Request["UserIDS"]); IES.CC.Model.Test.Message message = new IES.CC.Model.Test.Message { MessageID = MessageID, UserID = UserID }; IES.G2S.CourseLive.BLL.Test.MessageBLL messagebll = new IES.G2S.CourseLive.BLL.Test.MessageBLL(); List <IES.CC.Model.Test.Message> _mess = messagebll.Message_Gets(message); if (_mess != null) { context.Response.Write(Newtonsoft.Json.JsonConvert.SerializeObject(_mess)); } else { context.Response.Write("False"); } }
//删除信息 public void MessageDel(HttpContext context) { int UserID = UserService.CurrentUser.UserID; int Type = Convert.ToInt32(context.Request["Type"]); var IdS = context.Request["MessageIDs"]; IES.CC.Model.Test.Message message = new IES.CC.Model.Test.Message { UserID = UserID, Type = Type, MessageIDs = IdS }; IES.G2S.CourseLive.BLL.Test.MessageBLL messagebll = new IES.G2S.CourseLive.BLL.Test.MessageBLL(); bool Judge = messagebll.Message_Del(message); if (Judge == true) { context.Response.Write("true"); } else { context.Response.Write("False"); } }
//获取我的消息列表 public void GetMsgList(HttpContext context) { string Key = context.Request["Key"]; int UserID = UserService.CurrentUser.UserID; int Type = Convert.ToInt32(context.Request["Type"]); int PageIndex = Convert.ToInt32(context.Request["PageIndex"]); int PageSize = Convert.ToInt32(context.Request["PageSize"]); IES.CC.Model.Test.Message message = new IES.CC.Model.Test.Message { Key = Key, UserID = UserID, Type = Type }; IES.G2S.CourseLive.BLL.Test.MessageBLL messagebll = new IES.G2S.CourseLive.BLL.Test.MessageBLL(); List <IES.CC.Model.Test.Message> mess_ = messagebll.Message_List(message, PageIndex, PageSize); if (mess_ != null) { context.Response.Write(Newtonsoft.Json.JsonConvert.SerializeObject(mess_)); } else { context.Response.Write("False"); } }
public static bool Message_Del(Message message) { try { using (var conn = DbHelper.CCService()) { var p = new DynamicParameters(); p.Add("@UserID", message.UserID); p.Add("@Type", message.Type); p.Add("@MessageIDs", message.MessageIDs); conn.Execute("Message_Del", p, commandType: CommandType.StoredProcedure); return true; } } catch (Exception) { return false; } }
//获取我的消息列表 public void GetMsgList(HttpContext context) { string Key = context.Request["Key"]; int UserID = UserService.CurrentUser.UserID; int Type = Convert.ToInt32(context.Request["Type"]); int PageIndex = Convert.ToInt32(context.Request["PageIndex"]); int PageSize = Convert.ToInt32(context.Request["PageSize"]); IES.CC.Model.Test.Message message = new IES.CC.Model.Test.Message { Key = Key, UserID = UserID, Type = Type }; IES.G2S.CourseLive.BLL.Test.MessageBLL messagebll = new IES.G2S.CourseLive.BLL.Test.MessageBLL(); List<IES.CC.Model.Test.Message> mess_ = messagebll.Message_List(message, PageIndex, PageSize); if (mess_ != null) { context.Response.Write(Newtonsoft.Json.JsonConvert.SerializeObject(mess_)); } else { context.Response.Write("False"); } }
//根据信息ID获取姓名,ID public void User_NameID_List(HttpContext context) { int UserID = UserService.CurrentUser.UserID; int MessageID = Convert.ToInt32(context.Request["UserIDS"]); IES.CC.Model.Test.Message message = new IES.CC.Model.Test.Message { MessageID = MessageID, UserID = UserID }; IES.G2S.CourseLive.BLL.Test.MessageBLL messagebll = new IES.G2S.CourseLive.BLL.Test.MessageBLL(); List<IES.CC.Model.Test.Message> _mess = messagebll.Message_Gets(message); if (_mess != null) { context.Response.Write(Newtonsoft.Json.JsonConvert.SerializeObject(_mess)); } else { context.Response.Write("False"); } }
//获取消息列表 public static List<Message> Message_List(Message model, int PageIndex, int PageSize) { try { using (var conn = DbHelper.CCService()) { var p = new DynamicParameters(); p.Add("@Key", model.Key); p.Add("@UserID", model.UserID); p.Add("@Type", model.Type); p.Add("@PageIndex", PageIndex); p.Add("@PageSize", PageSize); return conn.Query<Message>("Message_List", p, commandType: CommandType.StoredProcedure).ToList(); } } catch (Exception) { return new List<Message>(); } }
public List<Message> Message_Gets(Message model) { return MessageDAL.Message_Gets(model); }
public Message Message_Get(Message model) { return MessageDAL.Message_Get(model); }
public bool Message_Del(Message message) { return MessageDAL.Message_Del(message); }
public Message Message_Add(Message message) { return MessageDAL.Message_Add(message); }
public static Message Message_Get(Message model) { try { using (var conn = DbHelper.CCService()) { var p = new DynamicParameters(); p.Add("@MessageID", model.MessageID); p.Add("@UserID", model.UserID); p.Add("@NextOrLast", model.NextOrLast); p.Add("@Type", model.Type); return conn.Query<Message>("Message_Get", p, commandType: CommandType.StoredProcedure).Single(); } } catch (Exception) { throw; } }
public static List<Message> Message_Gets(Message model) { try { using (var conn = DbHelper.CCService()) { var p = new DynamicParameters(); p.Add("@MessageID", model.MessageID); p.Add("@UserID", model.UserID); return conn.Query<Message>("Message_Get", p, commandType: CommandType.StoredProcedure).ToList(); } } catch (Exception) { throw; } }
public List<Message> Message_List(Message model, int PageIndex, int PageSize) { return MessageDAL.Message_List(model, PageIndex, PageSize); }
public static Message Message_Add(Message message) { try { using (var conn = DbHelper.CCService()) { var p = new DynamicParameters(); p.Add("@MessageID", dbType: DbType.Int32, direction: ParameterDirection.Output); p.Add("@Title", message.Title); p.Add("@Conten", message.Conten); p.Add("@SendUserID", message.SendUserID); p.Add("@IsForMail", message.IsForMail); p.Add("@IsForSMS", message.IsForSMS); p.Add("@ReceiveUserIDs", message.ReceiveUserIDs); conn.Execute("Message_Add", p, commandType: CommandType.StoredProcedure); message.MessageID = p.Get<int>("MessageID"); return message; } } catch (Exception e) { return null; } }