public int UpdateArea(Domain.SellArea area) { string sql = "UPDATE [dbo].[T_SellArea] SET [Name]=@Name,[Remark]=@Remark WHERE [Id]=@Id"; using (var dbOperator = new DbOperator(Provider, ConnectionString)) { dbOperator.AddParameter("Id", area.Id); dbOperator.AddParameter("Name", area.Name); if (string.IsNullOrWhiteSpace(area.Remark)) { dbOperator.AddParameter("Remark", DBNull.Value); } else { dbOperator.AddParameter("Remark", area.Remark); } return(dbOperator.ExecuteNonQuery(sql)); } }
public int InsertArea(Domain.SellArea area) { string sql = "INSERT INTO [dbo].[T_SellArea]([Id],[Name],[Remark]) VALUES(@Id,@Name,@Remark)"; using (var dbOperator = new DbOperator(Provider, ConnectionString)) { dbOperator.AddParameter("Id", area.Id); dbOperator.AddParameter("Name", area.Name); if (string.IsNullOrWhiteSpace(area.Remark)) { dbOperator.AddParameter("Remark", DBNull.Value); } else { dbOperator.AddParameter("Remark", area.Remark); } return(dbOperator.ExecuteNonQuery(sql)); } }