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