/// <summary> /// 添加押金 /// </summary> /// <param name="model"></param> /// <returns></returns> public int AddDeposit(AuctionDepositModel model) { const string sql = @"INSERT INTO `auction_deposit` (innerid, auctionid, type, payer, mobile, contacts, dpsamount, dpsserialnum, dpsaccount, pictures, remark, createrid, createdtime, modifierid, modifiedtime) VALUES (@innerid, @auctionid, @type, @payer, @mobile, @contacts, @dpsamount, @dpsserialnum, @dpsaccount, @pictures, @remark, @createrid, @createdtime, @modifierid, @modifiedtime);"; using (var conn = Helper.GetConnection()) { int result; try { result = conn.Execute(sql, model); } catch (Exception ex) { LoggerFactories.CreateLogger().Write("添加押金异常:", TraceEventType.Information, ex); result = 0; } return result; } }
/// <summary> /// 修改押金 /// </summary> /// <param name="model"></param> /// <returns></returns> public int UpdateDeposit(AuctionDepositModel model) { var sql = new StringBuilder("update `auction_deposit` set "); sql.Append(Helper.CreateField(model).Trim().TrimEnd(',')); sql.Append(" where innerid = @innerid"); int result; try { result = Helper.Execute(sql.ToString(), model); } catch (Exception ex) { result = 0; LoggerFactories.CreateLogger().Write("修改押金异常:", TraceEventType.Information, ex); } return result; }