public int Insert(Domain.VIPManagement managerment)
{
string sql = "INSERT INTO [T_VIPManagement]([Id],[Company],[IsVip]) VALUES (@Id,@Company,@IsVip)";
using (var dbOperator = new DbOperator(Provider, ConnectionString)) {
dbOperator.AddParameter("Id", managerment.Id);
dbOperator.AddParameter("Company", managerment.Company);
dbOperator.AddParameter("IsVip", managerment.IsVip);
return(dbOperator.ExecuteNonQuery(sql));
}
}
public Domain.VIPManagement Query(Guid id)
{
Domain.VIPManagement view = null;
string sql = "SELECT [Company],[IsVip] FROM [dbo].[T_VIPManagement] WHERE [Id]=@Id";
using (var dbOperator = new DbOperator(Provider, ConnectionString)) {
dbOperator.AddParameter("Id", id);
using (var reader = dbOperator.ExecuteReader(sql)) {
while (reader.Read())
{
view = new Domain.VIPManagement(id, reader.GetGuid(0));
view.IsVip = reader.GetBoolean(1);
}
}
}
return(view);
}
