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