public List <Domain.CompanyDrawdition> QueryByOwerId(Guid owerId) { string sql = "SELECT Id,OwnerId,Title,Context,Type FROM T_CompanyDrawCondition WHERE OwnerId=@OwnerId "; using (var dbOperator = new DbOperator(Provider, ConnectionString)) { dbOperator.AddParameter("OwnerId", owerId); using (var reader = dbOperator.ExecuteReader(sql)) { List <Domain.CompanyDrawdition> list = new List <Domain.CompanyDrawdition>(); while (reader.Read()) { Domain.CompanyDrawdition dition = new Domain.CompanyDrawdition(); dition.Id = reader.GetGuid(0); dition.OwnerId = reader.GetGuid(1); dition.Title = reader.GetString(2); dition.Context = reader.GetString(3); dition.Type = reader.GetByte(4); list.Add(dition); } return(list); } } }
public void Update(Domain.CompanyDrawdition dition) { string sql = "UPDATE T_CompanyDrawCondition SET Title = @Title,Context = @Context,Type=@Type WHERE ID=@ID;"; using (var dbOperator = new DbOperator(Provider, ConnectionString)) { dbOperator.AddParameter("ID", dition.Id); dbOperator.AddParameter("Title", dition.Title); dbOperator.AddParameter("Type", dition.Type); dbOperator.AddParameter("Context", dition.Context); dbOperator.ExecuteNonQuery(sql); } }
public void Insert(Domain.CompanyDrawdition dition) { string sql = "INSERT INTO T_CompanyDrawCondition VALUES(@Id,@Type,@OwnerId,@Title,@Context);"; using (var dbOperator = new DbOperator(Provider, ConnectionString)) { dbOperator.AddParameter("Id", dition.Id); dbOperator.AddParameter("Type", dition.Type); dbOperator.AddParameter("OwnerId", dition.OwnerId); dbOperator.AddParameter("Title", dition.Title); dbOperator.AddParameter("Context", dition.Context); dbOperator.ExecuteNonQuery(sql); } }
public Domain.CompanyDrawdition QueryById(Guid id) { string sql = "SELECT Id,OwnerId,Title,Context,Type FROM T_CompanyDrawCondition WHERE ID=@ID;"; using (var dbOperator = new DbOperator(Provider, ConnectionString)) { dbOperator.AddParameter("ID", id); using (var reader = dbOperator.ExecuteReader(sql)) { Domain.CompanyDrawdition dition = null; if (reader.Read()) { dition = new Domain.CompanyDrawdition(); dition.Id = reader.GetGuid(0); dition.OwnerId = reader.GetGuid(1); dition.Title = reader.GetString(2); dition.Context = reader.GetString(3); dition.Type = reader.GetByte(4); } return(dition); } } }