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