public BasePageList<AuctionCarParticipantViewModel> GetAuctionParticipantList(AuctionCarParticipantQueryModel query)
{
return _auctionservice.GetAuctionParticipantList(query);
}
/// <summary>
/// 获取竞拍人列表
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public BasePageList<AuctionCarParticipantViewModel> GetAuctionParticipantList(AuctionCarParticipantQueryModel query)
{
const string spName = "sp_common_pager";
const string tableName = @"auction_participant as a
left join auction_carinfo as b on b.innerid=a.auctionid
left join car_info as c on c.innerid=b.carid
left join base_carmodel as c1 on c.model_id=c1.innerid
left join sys_user as su on su.innerid=b.operatedid
left join base_city as ct on c.cityid=ct.innerid
left join base_province as pr on c.provid=pr.innerid
left join (select count(1) as pricecount,auctionid from auction_participant group by auctionid) as e on e.auctionid=a.auctionid";
const string fields = @"a.innerid,a.auctionid,a.mobile,a.amount,a.status,a.createrid,a.createdtime,a.username,
a.orderno,b.no as auctionno,b.lowestprice,b.validtime,b.status as auditstatus, now() as currenttime,c.register_date,c.mileage,c.pic_url,
c1.modelprice as price,c1.modelname as model_name,
ct.cityname,pr.provname,e.pricecount";
var oldField = string.IsNullOrWhiteSpace(query.Order) ? " a.createdtime asc " : query.Order;
var sqlWhere = new StringBuilder("1=1");
//拍卖ID
if (!string.IsNullOrWhiteSpace(query.Auctionid))
{
sqlWhere.Append($" and a.auctionid='{query.Auctionid}'");
}
//手机号
if (!string.IsNullOrWhiteSpace(query.Mobile))
{
sqlWhere.Append($" and a.mobile='{query.Mobile}'");
}
//用户ID
if (!string.IsNullOrWhiteSpace(query.userid))
{
sqlWhere.Append($" and a.userid='{query.userid}'");
}
//员工编号
if (!string.IsNullOrWhiteSpace(query.userno))
{
sqlWhere.Append($" and su.no='{query.userno}'");
}
//拍卖编号
if (!string.IsNullOrWhiteSpace(query.auctionno))
{
sqlWhere.Append($" and b.no='{query.auctionno}'");
}
//状态
if (query.status.HasValue)
{
sqlWhere.Append($" and a.status={query.status}");
}
//业务员
if (!string.IsNullOrWhiteSpace(query.operatedid))
{
sqlWhere.Append($" and b.operatedid='{query.operatedid}'");
}
//里程数
if (query.minmileage.HasValue)
{
sqlWhere.Append($" and c.mileage>={query.minmileage}");
}
//里程数
if (query.maxmileage.HasValue)
{
sqlWhere.Append($" and c.mileage<{query.maxmileage}");
}
//上牌时间
if (query.register_date.HasValue)
{
sqlWhere.Append($" and YEAR(c.register_date)=YEAR('{query.register_date}')");
}
//城市
if (query.cityid != null)
{
sqlWhere.Append($" and c.cityid={query.cityid}");
}
var model = new PagingModel(spName, tableName, fields, oldField, sqlWhere.ToString(), query.PageSize, query.PageIndex);
var list = Helper.ExecutePaging<AuctionCarParticipantViewModel>(model, query.Echo);
return list;
}
public JResult GetAllAuctionParticipantList(AuctionCarParticipantQueryModel query)
{
return _auctionservice.GetAllAuctionParticipantList(query);
}
/// <summary>
/// 获取所有竞拍记录
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public IEnumerable<AuctionCarParticipantViewModel> GetAllAuctionParticipantList(AuctionCarParticipantQueryModel query)
{
var sql = new StringBuilder("select * from auction_participant as a ");
var sqlWhere = new StringBuilder(" where 1=1");
if (query != null)
{
if (!string.IsNullOrWhiteSpace(query.Auctionid))
{
sqlWhere.Append($" and a.auctionid='{query.Auctionid}'");
}
if (!string.IsNullOrWhiteSpace(query.Mobile))
{
sqlWhere.Append($" and a.mobile='{query.Mobile}'");
}
}
sql.Append(sqlWhere.ToString());
sql.Append(" order by createdtime desc; ");
try
{
var list = Helper.Query<AuctionCarParticipantViewModel>(sql.ToString());
return list;
}
catch (Exception ex)
{
LoggerFactories.CreateLogger().Write("获取竞拍记录：", TraceEventType.Information, ex);
return null;
}
}