//获取上一封或下一封的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");
}
}
//获取上一封或下一封的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 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 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 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;
}
}
//发送消息
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");
}
}
