public static List <TblReturn> QueryByMid(TblMessage message)
{
return(DBHelper.QueryRows(new TblReturn(),
@"select r.rid,r.mid,r.content,r.created,u.username,u.nickname
from TblReturn r inner join TblUser u on r.uid=u.uid
where r.mid=@p0", message.Mid));
}
public MessageModel()
{
PageInfo = new Page();
Info = new TblMessage();
ReturnInfo = new TblReturn();
MessageList = new List <TblMessage>();
}
public static TblMessage QueryByKey(TblMessage message)
{
return(DBHelper.QueryOneRow(message,
@"select m.mid,m.title,m.content,m.created
,u.username,u.nickname
from TblMessage m
inner join TblUser u on m.uid=u.uid
where m.deleted='n' and m.mid=@p0", message.Mid));
}
public static int Delete(TblMessage message)
{
return(DBHelper.Update(
@"update TblMessage set deleted='y' where mid=@p0 and uid=@p1"
, message.Mid, message.Uid));
}
public static int Add(TblMessage message)
{
return(DBHelper.Update(
@"insert into TblMessage(uid,title,content) values(@p0,@p1,@p2)"
, message.Uid, message.Title, message.Content));
}
