public void Delete(Core.Business.Sendsms sendsms)
{
MySqlUtility sql = new MySqlUtility();
sql.AddParameter("@Id", MySqlDbType.Int64, sendsms.Id);
sql.ExecuteSql(SqlDeleteSendsms);
}
public void Insert(Core.Business.Sendsms sendsms)
{
MySqlUtility sql = new MySqlUtility();
string strSQL = "INSERT INTO Sendsms(Content,Phone) values('" + sendsms.Content + "', '"+sendsms.Phone+"');";
sql.ExecuteSql(strSQL);
}
public void Update(Core.Business.Sendsms sendsms)
{
MySqlUtility sql = new MySqlUtility();
sql.AddParameter("@StatusTime", MySqlDbType.DateTime, sendsms.StatusTime);
sql.AddParameter("@Content", MySqlDbType.VarChar, sendsms.Content);
sql.AddParameter("@Phone", MySqlDbType.VarChar, sendsms.Phone);
sql.AddParameter("@ReturnFlag", MySqlDbType.VarChar, sendsms.ReturnFlag);
sql.AddParameter("@Id", MySqlDbType.Int64, sendsms.Id);
sql.ExecuteSql(SqlUpdateSendsms);
}