/// <summary> /// 添加一条记录 /// </summary> public int Add(QiangGou entity, IDbTransaction tran) { string sql = @"insert into [QiangGou] ([objectid], [addTime], [lastModifyer], [qgPrice], [adId], [orderId], [endTime]) values (@objectid, @addTime, @lastModifyer, @qgPrice, @adId, @orderId, @endTime)"; object param = new { objectid = entity.Objectid, addTime = entity.AddTime, lastModifyer = entity.LastModifyer, qgPrice = entity.QgPrice, adId = entity.AdId, orderId = entity.OrderId, endTime = entity.EndTime }; int count = tran.Connection.Execute(sql, param, tran); return count; }
/// <summary> /// 添加一条记录 /// </summary> public ResultSet Add(QiangGou entity) { Func<QiangGou, ResultStatus> validate = (_entity) => { return new ResultStatus(); }; Func<QiangGou, ResultStatus> op = (_entity) => { int ret = new QiangGouDal().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); }
/// <summary> /// 添加一条记录 /// </summary> public int Add(QiangGou entity) { string sql = @"insert into [QiangGou] ([objectid], [addTime], [lastModifyer], [qgPrice], [adId], [orderId], [endTime]) values (@objectid, @addTime, @lastModifyer, @qgPrice, @adId, @orderId, @endTime)"; object param = new { objectid = entity.Objectid, addTime = entity.AddTime, lastModifyer = entity.LastModifyer, qgPrice = entity.QgPrice, adId = entity.AdId, orderId = entity.OrderId, endTime = entity.EndTime }; using (IDbConnection conn = OpenConnection()) { int count = conn.Execute(sql, param); return count; } }
public int Update(QiangGou entity) { //GetUpdateSql2 string sql = @"update [QiangGou] set objectid=@objectid, addTime=@addTime, lastModifyer=@lastModifyer, qgPrice=@qgPrice, adId=@adId, orderId=@orderId, endTime=@endTime where id=@id "; object param = new { id = entity.Id, objectid = entity.Objectid, addTime = entity.AddTime, lastModifyer = entity.LastModifyer, qgPrice = entity.QgPrice, adId = entity.AdId, orderId = entity.OrderId, endTime = entity.EndTime }; using (IDbConnection conn = OpenConnection()) { int count = conn.Execute(sql, param); return count; } }