示例#1
0
        /// <summary>
        /// 根据ID查询消息
        /// </summary>
        /// <param name="message"></param>
        /// <returns></returns>
        public static Message GetMessageById(int messageId)
        {
            int    typeId = 0;
            string sql    = "select * from Message where MessageId=" + messageId;

            using (SqlDataReader reader = DBHelper.GetReader(sql))
            {
                if (reader.Read())
                {
                    Message message = new Message();
                    message.MessageId  = (int)reader["MessageId"];
                    message.Title      = (string)reader["Title"];
                    message.Content    = (string)reader["Content"];
                    typeId             = (int)reader["Type"]; //再找MessageTypeService的根据Id 找MessageType
                    message.BeginTime  = (DateTime)reader["BeginTime"];
                    message.EndTime    = (DateTime)reader["EndTime"];
                    message.RecordTime = (DateTime)reader["RecordTime"];
                    message.IfPublish  = (int)reader["IfPublish"];
                    message.IfDelete   = (int)reader["IfDelete"];
                    message.IfDeleteTo = (int)reader["IfDeleteTo"];
                    string userId = (string)reader["FromUserId"];
                    reader.Close();
                    message.FromUser = UserService.GetUserById(userId);
                    message.Type     = MessageTypeService.GetMessageTypeById(typeId);
                    return(message);
                }
                else
                {
                    reader.Close();
                    return(null);
                }
            }
        }
示例#2
0
        public static IList <Message> GetMessageBySql(string sql)
        {
            IList <Message> list = new List <Message>();

            try
            {
                using (DataTable dt = DBHelper.GetDataSet(sql))
                {
                    foreach (DataRow row in dt.Rows)
                    {
                        Message message = new Message();
                        message.MessageId  = (int)row["MessageId"];
                        message.Title      = (string)row["Title"];
                        message.Content    = (string)row["Content"];
                        message.Type       = MessageTypeService.GetMessageTypeById((int)row["Type"]);
                        message.BeginTime  = (DateTime)row["BeginTime"];
                        message.EndTime    = (DateTime)row["EndTime"];
                        message.RecordTime = (DateTime)row["RecordTime"];
                        message.IfPublish  = (int)row["IfPublish"];
                        message.IfDelete   = (int)row["IfDelete"];
                        message.IfDeleteTo = (int)row["IfDeleteTo"];
                        string userId = (string)row["FromUserId"];
                        message.FromUser = UserService.GetUserById(userId);
                        list.Add(message);
                    }
                    return(list);
                }
            }
            catch (Exception ex)
            {
                throw new ApplicationException(ex.Message);
            }
        }