Exemple #1
0
        public static List <QueryAllDataModel> QueryAll(int page, int rows, string queryjson, out int totalrows, out int totalpage, int periodsNumber)
        {
            List <QueryAllDataModel> rtdata              = new List <QueryAllDataModel>();
            Tk_GalleryBLL            tk_GalleryBLL       = new Tk_GalleryBLL();
            Tk_GalleryDetailBLL      tk_GalleryDetailBLL = new Tk_GalleryDetailBLL();

            Pagination pageparam = new Pagination()
            {
                page = page,
                rows = rows,
                sidx = "GalleryNumber",
                sord = "asc"
            };
            List <Tk_Gallery>       list        = tk_GalleryBLL.GetPageList(pageparam, queryjson).ToList();
            List <string>           gallid      = list.Select(s => s.ID).ToList();
            List <Tk_GalleryDetail> qDetailList = new List <Tk_GalleryDetail>();

            if (periodsNumber == 0)
            {
                periodsNumber = getNewperoidNumber();
            }
            if (gallid.Count > 0)
            {
                qDetailList = tk_GalleryDetailBLL.QueryDetailByGalleryId(gallid, periodsNumber);
            }
            totalrows = pageparam.records;
            totalpage = pageparam.total;
            string[] aryname = new string[] { "A", "B", "C" };
            for (int i = 0; i < aryname.Length; i++)
            {
                List <ImageMenuInfoModel> tlist = new List <ImageMenuInfoModel>();
                IEnumerator <Tk_Gallery>  tmp   = list.Where(t => t.AreaCode == aryname[i]).GetEnumerator();
                while (tmp.MoveNext())
                {
                    ImageMenuInfoModel tmpImg = new ImageMenuInfoModel()
                    {
                        GalleryNumStr = tmp.Current.AreaCode + GetGallerNum(tmp.Current.GalleryNumber.Value),
                        AreaCode      = tmp.Current.AreaCode,
                        CreateTime    = tmp.Current.CreateTime.Value.ToString(),
                        GalleryName   = tmp.Current.GalleryName,
                        GalleryNumber = tmp.Current.GalleryNumber.Value,
                        HotNumber     = tmp.Current.HotNumber.Value,
                        ID            = tmp.Current.ID,
                        Reamrk        = tmp.Current.Reamrk,
                        HasImage      = 0
                    };
                    List <Tk_GalleryDetail> qtmp = qDetailList.Where(w => w.GalleryId == tmpImg.ID && w.PeriodsNumber == periodsNumber.ToString()).ToList();
                    if (qtmp.Count > 0)
                    {
                        tmpImg.ImageUrl = qtmp[0].ImageUrl;
                        tmpImg.HasImage = 1;
                    }
                    tlist.Add(tmpImg);
                }
                tlist = tlist.OrderBy(s => s.GalleryNumber).ToList();//升序排序
                rtdata.Add(new QueryAllDataModel()
                {
                    AreaName = aryname[i], list = tlist, PeriodsNumber = periodsNumber
                });
            }
            return(rtdata);
        }
Exemple #2
0
        /// <summary>
        /// 查询最新的
        /// </summary>
        /// <returns></returns>
        public static List <ImageMenuInfoModel> QueryNew(int page, int rows, out int totalrows, out int totalpage, int periodsNumber)
        {
            Tk_GalleryDetailBLL tk_GalleryDetailBLL = new Tk_GalleryDetailBLL();
            Tk_GalleryBLL       tk_GalleryBLL       = new Tk_GalleryBLL();
            Pagination          pageparam           = new Pagination()
            {
                page = page,
                sidx = "GalleryNumber",
                rows = rows,
                sord = "asc"
            };

            List <Tk_Gallery>        list       = tk_GalleryBLL.GetPageList(pageparam, "").ToList();
            IEnumerator <Tk_Gallery> enumerator = list.GetEnumerator();

            totalrows = pageparam.records;
            totalpage = pageparam.total;
            List <string>           gallid      = list.Select(s => s.ID).ToList();
            List <Tk_GalleryDetail> qDetailList = new List <Tk_GalleryDetail>();

            if (periodsNumber == 0)
            {
                periodsNumber = tk_GalleryDetailBLL.NewPeriodsNumber();
            }
            if (gallid.Count > 0)
            {
                qDetailList = tk_GalleryDetailBLL.QueryDetailByGalleryId(gallid, periodsNumber);
            }
            List <ImageMenuInfoModel> rtdata = new List <ImageMenuInfoModel>();
            List <ImageMenuInfoModel> tplist = new List <ImageMenuInfoModel>();

            while (enumerator.MoveNext())
            {
                ImageMenuInfoModel tmp = new ImageMenuInfoModel()
                {
                    GalleryNumStr = enumerator.Current.AreaCode + GetGallerNum(enumerator.Current.GalleryNumber.Value),
                    GalleryName   = enumerator.Current.GalleryName,
                    AreaCode      = enumerator.Current.AreaCode,
                    CreateTime    = enumerator.Current.CreateTime.ToString(),
                    GalleryNumber = enumerator.Current.GalleryNumber.Value,
                    HotNumber     = enumerator.Current.HotNumber.Value,
                    ID            = enumerator.Current.ID,
                    Reamrk        = enumerator.Current.Reamrk
                };
                List <Tk_GalleryDetail> qtmp = qDetailList.Where(w => w.GalleryId == tmp.ID && w.PeriodsNumber == periodsNumber.ToString()).ToList();
                if (qtmp.Count > 0)
                {
                    tmp.ImageUrl = qtmp[0].ImageUrl;
                    tmp.HasImage = 1;
                }
                tplist.Add(tmp);
            }
            List <ImageMenuInfoModel> alist = tplist.Where(w => w.AreaCode == "A").OrderBy(o => o.GalleryNumber).ToList();
            List <ImageMenuInfoModel> blist = tplist.Where(w => w.AreaCode == "B").OrderBy(o => o.GalleryNumber).ToList();
            List <ImageMenuInfoModel> clist = tplist.Where(w => w.AreaCode == "C").OrderBy(o => o.GalleryNumber).ToList();

            rtdata.AddRange(alist);
            rtdata.AddRange(blist);
            rtdata.AddRange(clist);
            return(rtdata);
            // rtdata = rtdata.OrderBy(s => s.GalleryNumber).ToList();//升序排序
        }