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