/// <summary>
/// 添加一条记录
/// </summary>
public int Add(PayMentType entity, IDbTransaction tran)
{
string sql = @"insert into [PayMentType]
([payMentName])
values
(@payMentName)";
object param = new
{
payMentName = entity.PayMentName
};
int count = tran.Connection.Execute(sql, param, tran);
return count;
}
/// <summary>
/// 添加一条记录
/// </summary>
public int Add(PayMentType entity)
{
string sql = @"insert into [PayMentType]
([payMentName])
values
(@payMentName)";
object param = new
{
payMentName = entity.PayMentName
};
using (IDbConnection conn = OpenConnection())
{
int count = conn.Execute(sql, param);
return count;
}
}
/// <summary>
/// 添加一条记录
/// </summary>
public ResultSet Add(PayMentType entity)
{
Func<PayMentType, ResultStatus> validate = (_entity) =>
{
return new ResultStatus();
};
Func<PayMentType, ResultStatus> op = (_entity) =>
{
int ret = new PayMentTypeDal().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(PayMentType entity)
{
//GetUpdateSql2
string sql = @"update [PayMentType] set payMentName=@payMentName where id=@id ";
object param = new
{
id = entity.Id,
payMentName = entity.PayMentName
};
using (IDbConnection conn = OpenConnection())
{
int count = conn.Execute(sql, param);
return count;
}
}
