public SoundBlog_NEW.Model.SB_Text GetByID(Int32 ID) { String SQLCmd = "select * from Text where " + "Text_ID = @Text_ID"; MySqlParameter[] parameters = new MySqlParameter[]{ new MySqlParameter("@Text_ID",MySqlDbType.Int32) }; parameters[0].Value = ID; MySqlDataReader reader = MySqlHelper.ExecuteSQLDataReader(SQLCmd, parameters); SoundBlog_NEW.Model.SB_Text model = new SoundBlog_NEW.Model.SB_Text(); ; while (reader.Read()) { model.Text_ID = (Int32)reader["Text_ID"]; model.Text_Title = (String)reader["Text_Title"]; model.Text_Content = (String)reader["Text_Content"]; model.Text_Datetime = (DateTime)reader["Text_Datetime"]; model.Text_Keyword = (String)reader["Text_Keyword"]; model.Text_CommentCount = (Int32)reader["Text_CommentCount"]; model.Text_ReadCount = (Int32)reader["Text_ReadCount"]; model.Text_Category = (Int32)reader["Text_Category"]; model.Text_UserID = (Int32)reader["Text_UserID"]; } return model; }
private IList<SoundBlog_NEW.Model.SB_Text> _GetListHelper(String SQLCmd, MySqlParameter[] parameters) { MySqlDataReader reader = MySqlHelper.ExecuteSQLDataReader(SQLCmd, parameters); IList<SoundBlog_NEW.Model.SB_Text> models = new List<SoundBlog_NEW.Model.SB_Text>(); while (reader.Read()) { SoundBlog_NEW.Model.SB_Text text = new SoundBlog_NEW.Model.SB_Text(); ; text.Text_ID = (Int32)reader["Text_ID"]; text.Text_Title = (String)reader["Text_Title"]; text.Text_Content = (String)reader["Text_Content"]; text.Text_Datetime = (DateTime)reader["Text_Datetime"]; text.Text_Keyword = (String)reader["Text_Keyword"]; text.Text_CommentCount = (Int32)reader["Text_CommentCount"]; text.Text_ReadCount = (Int32)reader["Text_ReadCount"]; text.Text_Category = (Int32)reader["Text_Category"]; text.Text_UserID = (Int32)reader["Text_UserID"]; models.Add(text); } return models; }