/// <summary>
/// 中标拍卖竞拍人员
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int BidParticipant(AuctionCarParticipantModel model)
{
const string sql = @"update auction_participant set isbid=@isbid,modifierid=@modifierid,modifiedtime=@modifiedtime where innerid=@innerid;";
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 UpdateParticipant(AuctionCarParticipantModel model)
{
var sql = new StringBuilder("update `auction_participant` 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;
}
/// <summary>
/// 添加拍卖竞拍人员
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int AddParticipant(AuctionCarParticipantModel model)
{
const string sql = @"INSERT INTO `auction_participant`
(innerid, auctionid, mobile, amount,username,userid, status, remark, createrid, createdtime, modifierid, modifiedtime,orderno)
VALUES
(uuid(), @auctionid, @mobile, @amount,@username,@userid, @status, @remark, @createrid, @createdtime, @modifierid, @modifiedtime,@orderno);";
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 UpdateOtherParticipant(AuctionCarParticipantModel model)
{
//更新竞价列表
var sql = new StringBuilder("update `auction_participant` set status=7 ");
sql.Append(" where auctionid=@auctionid and innerid != @innerid");
var carmodel = GetAuctionViewById(model.Auctionid);
var carid = string.Empty;
if (carmodel != null)
{
carid = carmodel.carid;
}
//更新车辆信息
var sqlcar = new StringBuilder("update car_info set `status`=2,`dealprice`=@dealprice,dealdesc='拍卖成交' where innerid=@carid;");
int result;
using (var conn = Helper.GetConnection())
{
var tran = conn.BeginTransaction();
try
{
conn.Execute(sql.ToString(), model, tran);
conn.Execute(sqlcar.ToString(), new { carid, dealprice = model.Amount }, tran);
tran.Commit();
return 1;
}
catch (Exception ex)
{
tran.Rollback();
result = 0;
LoggerFactories.CreateLogger().Write("更新其他竞价信息异常：", TraceEventType.Information, ex);
}
}
return result;
}