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