public int Insert(Domain.VIPHarmony harmony)
{
string sql = "INSERT INTO [dbo].[T_VIPHarmony]([Id],[Area],[AirlineLimit],[CityLimit],[Account],[Remark],[AddTime]) VALUES(@Id,@Area,@AirlineLimit,@CityLimit,@Account,@Remark,@AddTime)";
using (var dbOperator = new DbOperator(Provider, ConnectionString)) {
dbOperator.AddParameter("Id", harmony.Id);
dbOperator.AddParameter("Area", harmony.Area);
dbOperator.AddParameter("AirlineLimit", harmony.AirlineLimit.Join("/"));
dbOperator.AddParameter("CityLimit", harmony.CityLimit.Join("/"));
dbOperator.AddParameter("Account", harmony.Account);
if (string.IsNullOrWhiteSpace(harmony.Remark))
{
dbOperator.AddParameter("Remark", DBNull.Value);
}
else
{
dbOperator.AddParameter("Remark", harmony.Remark);
}
dbOperator.AddParameter("AddTime", harmony.AddTime);
return(dbOperator.ExecuteNonQuery(sql));
}
}
public int Update(Domain.VIPHarmony harmony)
{
string sql = "UPDATE [dbo].[T_VIPHarmony] SET [Area]=@Area,[AirlineLimit]=@AirlineLimit,[CityLimit]=@CityLimit,[Remark]=@Remark," +
"[AddTime]=@AddTime,[Account]=@Account WHERE [Id]=@Id";
using (var dbOperator = new DbOperator(Provider, ConnectionString)) {
dbOperator.AddParameter("Id", harmony.Id);
dbOperator.AddParameter("Area", harmony.Area);
dbOperator.AddParameter("AirlineLimit", harmony.AirlineLimit.Join("/"));
dbOperator.AddParameter("CityLimit", harmony.CityLimit.Join("/"));
if (string.IsNullOrWhiteSpace(harmony.Remark))
{
dbOperator.AddParameter("Remark", DBNull.Value);
}
else
{
dbOperator.AddParameter("Remark", harmony.Remark);
}
dbOperator.AddParameter("AddTime", harmony.AddTime);
dbOperator.AddParameter("Account", harmony.Account);
return(dbOperator.ExecuteNonQuery(sql));
}
}
