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