Ejemplo n.º 1
0
        public Respbase <List <AuctionDetailsDto> > GetAuctionDetails(ReqAuctionDetails req)
        {
            var data = facade.GetAuctionDetails(req);

            if (data == null)
            {
                return(new Respbase <List <AuctionDetailsDto> > {
                    Result = 0, Message = facade.PromptInfo.Message
                });
            }
            return(new Respbase <List <AuctionDetailsDto> > {
                Result = 1, Data = data
            });
        }
Ejemplo n.º 2
0
        /// <summary>
        /// 获取竞拍详情
        /// </summary>
        /// <param name="req"></param>
        /// <returns></returns>
        public List <AuctionDetailsDto> GetAuctionDetails(ReqAuctionDetails req)
        {
            DateTime beginDate = DateTime.MinValue, endDate = DateTime.MinValue;
            var      now = DateTime.Now;

            switch (req.QueryTimeType)
            {
            case 1:
                if (now.Day > 7)
                {
                    beginDate = now.AddDays(-6).Date;
                }
                else
                {
                    beginDate = now.AddDays(1 - now.Day).Date;
                }
                endDate = now.AddDays(1).Date.AddSeconds(-1);
                break;

            case 2:
                if (now.Day <= 7)
                {
                    Alert("没有7天前的数据");
                    return(null);
                }
                beginDate = now.AddDays(1 - now.Day).Date;
                endDate   = now.AddDays(-6).Date.AddSeconds(-1);
                break;

            case 3:
                beginDate = now.AddDays(1 - now.Day).Date;
                endDate   = now.AddDays(1 - now.Day).Date.AddMonths(1).AddSeconds(-1);
                break;

            default:
                Alert("参数错误");
                return(null);
            }
            string sql = $@"select TO_CHAR(createtime,'MM-dd')as createdate,PRICE,sum(num)as num from tpxin_pai_his
                            WHERE  createtime>= TO_DATE('{beginDate}', 'yyyy-MM-dd HH24:mi:ss') and createtime<= TO_DATE('{endDate}', 'yyyy-MM-dd HH24:mi:ss')
                            GROUP BY PRICE,TO_CHAR(createtime, 'MM-dd') ORDER BY TO_CHAR(createtime, 'MM-dd') ";

            return(db.Database.SqlQuery <AuctionDetailsDto>(sql).ToList());
        }