public IEnumerable<Core.Business.Sendsms> SelectAll()
{
IList<Core.Business.Sendsms> sendsmslist = new List<Core.Business.Sendsms>();
MySqlUtility sql = new MySqlUtility();
MySqlDataReader reader = sql.ExecuteSqlReader(SqlGetAllSendsms);
if (reader != null)
{
while (reader.Read())
{
Core.Business.Sendsms sendsms = new Core.Business.Sendsms();
if (!reader.IsDBNull(0)) sendsms.Id = reader.GetInt64(0);
if (!reader.IsDBNull(1)) sendsms.StatusTime = reader.GetDateTime(1);
if (!reader.IsDBNull(2)) sendsms.Content = reader.GetString(2);
if (!reader.IsDBNull(3)) sendsms.Phone = reader.GetString(3);
if (!reader.IsDBNull(4)) sendsms.ReturnFlag = reader.GetString(4);
sendsms.MarkOld();
sendsmslist.Add(sendsms);
}
reader.Close();
}
return sendsmslist;
}
public Core.Business.Sendsms Select(Int64 id)
{
MySqlUtility sql = new MySqlUtility();
sql.AddParameter("@Id", MySqlDbType.Int64, id);
MySqlDataReader reader = sql.ExecuteSqlReader(SqlSelectSendsms);
if (reader != null && !reader.IsClosed && reader.Read())
{
Core.Business.Sendsms sendsms = new Core.Business.Sendsms();
if (!reader.IsDBNull(0)) sendsms.Id = reader.GetInt64(0);
if (!reader.IsDBNull(1)) sendsms.StatusTime = reader.GetDateTime(1);
if (!reader.IsDBNull(2)) sendsms.Content = reader.GetString(2);
if (!reader.IsDBNull(3)) sendsms.Phone = reader.GetString(3);
if (!reader.IsDBNull(4)) sendsms.ReturnFlag = reader.GetString(4);
reader.Close();
return sendsms;
}
else
{
if (reader != null && !reader.IsClosed)
reader.Close();
return null;
}
}
