/// <summary>
/// 添加一条记录
/// </summary>
public int Add(AdLocation entity, IDbTransaction tran)
{
string sql = @"insert into [AdLocation]
([locationName], [description])
values
(@locationName, @description)";
object param = new
{
locationName = entity.LocationName,
description = entity.Description
};
int count = tran.Connection.Execute(sql, param, tran);
return count;
}
/// <summary>
/// 添加一条记录
/// </summary>
public int Add(AdLocation entity)
{
string sql = @"insert into [AdLocation]
([locationName], [description])
values
(@locationName, @description)";
object param = new
{
locationName = entity.LocationName,
description = entity.Description
};
using (IDbConnection conn = OpenConnection())
{
int count = conn.Execute(sql, param);
return count;
}
}
/// <summary>
/// 添加一条记录
/// </summary>
public ResultSet Add(AdLocation entity)
{
Func<AdLocation, ResultStatus> validate = (_entity) =>
{
return new ResultStatus();
};
Func<AdLocation, ResultStatus> op = (_entity) =>
{
int ret = new AdLocationDal().Add(entity);
if (ret > 0)
return new ResultStatus();
else
return new ResultStatus()
{
Success = false,
Code = StatusCollection.AddFailed.Code,
Description = StatusCollection.AddFailed.Description
};
};
return HandleBusiness(entity, op, validate);
}
public int Update(AdLocation entity)
{
//GetUpdateSql2
string sql = @"update [AdLocation] set locationName=@locationName, description=@description where id=@id ";
object param = new
{
id = entity.Id,
locationName = entity.LocationName,
description = entity.Description
};
using (IDbConnection conn = OpenConnection())
{
int count = conn.Execute(sql, param);
return count;
}
}
