拍卖参与者query
Наследование: QueryModel
Пример #1
0
 public BasePageList<AuctionCarParticipantViewModel> GetAuctionParticipantList(AuctionCarParticipantQueryModel query)
 {
     return _auctionservice.GetAuctionParticipantList(query);
 }
Пример #2
0
        /// <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;
        }
Пример #3
0
 public JResult GetAllAuctionParticipantList(AuctionCarParticipantQueryModel query)
 {
     return _auctionservice.GetAllAuctionParticipantList(query);
 }
Пример #4
0
        /// <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;
            }
        }