예제 #1
0
        private void LL()
        {
            string    sql;
            DataTable dt;

            //PPT
            sql = "select top 5 NewsSN,Title,PicS,PicB,UrlType,Url  from news_Info where Item&2=2 order by EditDate desc";
            dt  = cac.GetDataTable("news_ppt", sql);
            Bind.BGRepeater(dt, rpPPTImg);
            Bind.BGRepeater(dt, rpPPTList);

            //健康热点  NO.1
            sql = "select top 1 NewsSN,PicS,Title,Title1,Detail,UrlType,Url from news_Info where Item&1=1 order by EditDate desc";
            dt  = cac.GetDataTable("news_item_1", sql);
            Bind.BGRepeater(dt, rpHotNO1);


            //健康热点 其他
            sql = "select top 5 NewsSN,Title,Title1,UrlType,Url from news_Info where Item&4=4 order by EditDate desc";
            dt  = cac.GetDataTable("news_item_4", sql);
            Bind.BGRepeater(dt, rpHotList);

            //列表
            sql                   = "select top 10 NewsSN,Source,Title,EditDate,Detail,UrlType,Url from news_Info  where FK_News_Class=" + id + " order by EditDate desc";
            dt                    = cac.GetDataTable("news_class_" + id, sql);
            this.rpList.dt        = dt;
            this.rpList.listEvent = new CycleEventText(NewsList);

            //独家
            sql                 = "select top 10 ProSN,ProName,PicS,Price from vgPro_Info where Item&1024=1024 order by EditDate desc";
            dt                  = cac.GetDataTable("news_Item_1024", sql);
            this.rpDJ.dt        = dt;
            this.rpDJ.listEvent = new CycleEvent(ProLay.d_list4);
        }
예제 #2
0
        private void List()
        {
            string sqlSelect, sqlFrom, sqlWhere, sqlOrder, pkName;

            sqlSelect = "select ge.ExSN,gi.PicS,gi.GiftName,ge.AddDate,ge.ExIntegral,ge.Num";
            sqlFrom   = " from Gift_ExchangeLog as ge left join Gift_Info as gi on ge.FK_Gift=gi.GiftSN";
            sqlWhere  = " where ge.FK_User="******" order by ge.AddDate desc";
            pkName    = "ExSN";

            PagingVar pv = new PagingVar();

            pv.SQLCount = "select count(0)" + sqlFrom + sqlWhere;
            pv.SQLRead  = "select " + pkName + sqlFrom + sqlWhere + sqlOrder;
            pv.SQL      = sqlSelect + sqlFrom + " where " + pkName + " in({0})" + sqlOrder;
            Paging pg = new Paging(pv, new PagingUrlVar(12));//页记录 12

            pg.load();

            Bind.BGRepeater(pg.GetDataTable(), this.rpList);
            this.ucPS1.f  = pg;
            this.ucPS1.cs = "?p={0}";

            countN.Text = pg.um.records_count.ToString();//总数
        }
예제 #3
0
        private void LL()
        {
            string sql = "select ProName from vgTaoCan_Info where ProSN=" + id;

            d = new SqlDataSelect(sql);
            if (d.Count < 1)
            {
                return;
            }

            string sqlSelect, sqlFrom, sqlWhere, sqlOrder, pkName;

            sqlSelect = "select ev.Fraction,ev.FK_User,ev.Detail,ev.ReDetail,ev.AddDate,ui.UserName";
            sqlFrom   = " from TaoCan_Evaluate ev left join User_Info ui on ev.FK_User=ui.UserSN";
            sqlWhere  = " where Purview=1 and FK_Pro=" + id;
            sqlOrder  = " order by ev.AddDate desc";
            pkName    = "EvalSN";

            PagingVar pv = new PagingVar();

            pv.SQLCount = "select count(0)" + sqlFrom + sqlWhere;
            pv.SQLRead  = "select " + pkName + sqlFrom + sqlWhere + sqlOrder;
            pv.SQL      = sqlSelect + sqlFrom + " where " + pkName + " in({0})" + sqlOrder;

            Paging pg = new Paging(pv, new PagingUrlVar(30));

            pg.load();

            DataTable dt = pg.GetDataTable();

            cou = dt.Rows.Count.ToString();
            Bind.BGRepeater(dt, this.rpList);
            this.ucPS1.f = pg;
        }
예제 #4
0
        private void GetClass()
        {
            string    sql = "select ClassSN,ClassName from vgPro_Class where PClassSN=0 order by Taxis asc";
            DataTable dt  = cac.GetDataTable("publist_PClassSN=0", sql);

            Bind.BGRepeater(dt, this.rpClass);
        }
예제 #5
0
        private void GetPro()
        {
            string sqlSelect, sqlFrom, sqlWhere = string.Empty, sqlOrder, pkName;

            sqlSelect = "select ProSN,ProName,PicS,Price2,Unit,UnitNum";
            sqlFrom   = " from vgPro_Info";
            if (classID > 0)
            {
                sqlFrom = " from vgPro_Info a inner join T_Pro_Class_GetChildAndSelf(" + classID + ") b on a.FK_Pro_Class=b.id";
            }
            sqlWhere = " where Item&2048=2048";
            sqlOrder = " order by EditDate desc";
            pkName   = "ProSN";

            PagingVar pv = new PagingVar();

            pv.SQLCount = "select count(0)" + sqlFrom + sqlWhere;
            pv.SQLRead  = "select " + pkName + sqlFrom + sqlWhere + sqlOrder;
            pv.SQL      = sqlSelect + sqlFrom + " where " + pkName + " in({0})" + sqlOrder;

            Paging pg = new Paging(pv, new PagingUrlVar(16));

            pg.load();
            Bind.BGRepeater(pg.GetDataTable(), this.rpPro);

            this.ucPS1.f = pg;
        }
예제 #6
0
        private void LL()
        {
            string    sql;
            DataTable dt;

            sql = "select Title,Detail,Source,EditDate,Vote from News_Info where NewsSN=" + id;
            d   = new SqlDataSelect(sql);

            //导航栏
            curPath.Text += d.Eval("Title");

            //投票
            sql = "select ClassName,Str,PicS from Vote_Class where PClassSN=(select ClassSN from Vote_Class where Str='news') order by Taxis asc";
            dt  = DbHelp.GetDataTable(sql);
            Bind.BGRepeater(dt, rpVoteList, false);

            //hit  +1
            sql = "update News_Info set Hit=Hit+1 where NewsSN=" + id;
            DbHelp.Update(sql);

            //健康食品推荐
            sql                   = "select top 10 ProSN,ProName,PicS,Price from vgPro_Info where JoinType=0 and Item&128=128 and Item&2=2 order by EditDate desc";
            dt                    = DbHelp.GetDataTable(sql);
            this.rpList.dt        = dt;
            this.rpList.listEvent = new CycleEvent(ProLay.d_list3);

            List();
        }
예제 #7
0
        private void GetHtml()
        {
            string    sSql = "select top 5 ev.Detail,ev.ReDetail,ev.AddDate,ui.UserName from TaoCan_Msg ev left join User_Info ui on ev.FK_User=ui.UserSN where Purview=1 and FK_Pro=" + id + " order by ev.AddDate desc";
            DataTable dt   = DbHelp.GetDataTable(sSql);

            Bind.BGRepeater(dt, this.rpMsg);
        }
예제 #8
0
        private void caipuPicList()
        {
            string    sSql  = "select PicS,PicB from CaiPu_Pic where FK_Pro=" + id;
            DataTable dtPic = DbHelp.GetDataTable(sSql);

            Bind.BGRepeater(dtPic, this.rpPic);
        }
예제 #9
0
        private void LL()
        {
            string    sql;
            DataTable dt;

            //分类下 文章
            sql = "select HelpSN,FK_Help_Class,Taxis,Title from Help_Info";
            dtL = DbHelp.GetDataTable(sql);

            //内容
            if (id == 0)
            {
                sql = "select top 1 HelpSN,Title,Detail from Help_Info order by Taxis asc";
            }
            else
            {
                sql = "select HelpSN,Title,Detail from Help_Info where HelpSN=" + id;
            }
            d = new SqlDataSelect(sql);


            //分类
            dt = PubData.GetDataTable("help_class");
            Bind.BGRepeater(dt, rpClass, false);
        }
예제 #10
0
        private void LL()
        {
            string sqlSelect, sqlFrom, sqlWhere, sqlOrder, pkName;

            sqlSelect = "select ev.Detail,ev.ReDetail,ev.AddDate,ev.Purview,ui.UserName,pi.ProSN,pi.ProName,pi.PicS";
            sqlFrom   = " from Pro_Msg ev left join User_Info ui on ev.FK_User=ui.UserSN left join vgPro_Info pi on ev.FK_Pro=pi.ProSN";
            sqlWhere  = " where ev.FK_User="******" order by ev.purview asc,ev.AddDate desc";
            pkName    = "MsgSN";

            PagingVar pv = new PagingVar();

            pv.SQLCount = "select count(0)" + sqlFrom + sqlWhere;
            pv.SQLRead  = "select " + pkName + sqlFrom + sqlWhere + sqlOrder;
            pv.SQL      = sqlSelect + sqlFrom + " where " + pkName + " in({0})" + sqlOrder;

            Paging pg = new Paging(pv, new PagingUrlVar(10));

            pg.load();

            DataTable dt = pg.GetDataTable();

            Bind.BGRepeater(dt, this.rpList);
            this.ucPS1.f = pg;
        }
예제 #11
0
        private void LL()
        {
            string sSQL = "select * from Links where LinksType=" + LinksType + " and ShowLocal=" + ShowLocal + " and ShowType=" + ShowType + " order by Taxis desc,LinksSN desc";



            //string sSQL = string.Format("select * from Links where LinksType={0} and Item={1}{2} order by Taxis asc", LinksType, Item, "{0}");
            //if (IsPic)
            //{
            //    sSQL = string.Format(sSQL, " and len(LinksImg)>0");
            //}
            //else
            //{
            //    sSQL = string.Format(sSQL, " and len(LinksImg)=0");
            //}

            DataTable dt = dbCac.GetDataTable(LinksType.ToString() + ShowLocal.ToString() + ShowType.ToString(), sSQL);

            if (ShowType == 1)
            {
                Bind.BGRepeater(dt, this.rpPic, false);
                this.rpText.Visible = false;
            }
            else
            {
                Bind.BGRepeater(dt, this.rpText, false);
                this.rpPic.Visible = false;
            }
        }
예제 #12
0
        private void BGList()
        {
            string    sql = "select ConSN,Name,Address,Tel,FixTel,FK_Area from User_Contact where FK_User=" + UserID;
            DataTable dt  = DbHelp.GetDataTable(sql);

            Bind.BGRepeater(dt, this.rpList);
        }
예제 #13
0
        private void LL()
        {
            string    sql;
            DataTable dt;

            //一级分类
            dtC = PubData.GetDataTable("TaoCan_Class");
            DataRow[] dr = dtC.Select("ClassLevel=1", "Taxis asc");
            dt = dtC.Clone();
            Fn.DrwToDt(dr, dt);
            Bind.BGRepeater(dt, rpClass1);

            //推荐1
            sql = "select top 2 ProSN,ProName,PicS from vgTaoCan_Info where Item&2=2 order by EditDate desc";
            dt  = DbHelp.GetDataTable(sql);
            Bind.BGRepeater(dt, rpTJ1);

            //推荐2
            sql = "select top 4 ProSN,ProName,PicS from vgTaoCan_Info where Item&4=4 order by EditDate desc";
            dt  = DbHelp.GetDataTable(sql);
            Bind.BGRepeater(dt, rpTJ2);

            //精品
            sql = "select top 12 ProSN,ProName,PicS from vgTaoCan_Info where Item&1=1 order by EditDate desc";
            dt  = DbHelp.GetDataTable(sql);
            Bind.BGRepeater(dt, rpJP);
        }
예제 #14
0
        private void LL()
        {
            Paging pg = Coupons_Info.List(GetSess.UserID, type);

            Bind.BGRepeater(pg.GetRead(), this.rpList);
            this.ucPS1.f = pg;
        }
예제 #15
0
        private void MsgList()
        {
            int cur_pageIndex = Fn.IsInt(Req.GetForm("ajax_page"), 1);

            string sqlSelect, sqlFrom, sqlWhere, sqlOrder, pkName;

            sqlSelect = "select Detail,N.AddDate as AddDate,UserName";
            sqlFrom   = " from Questionnaire_Msg as N left join User_Info as U on N.FK_User=U.UserSN";
            sqlWhere  = " where Purview=1 and FK_Questionnaire=" + QuSN;
            sqlOrder  = " order by N.AddDate desc";
            pkName    = "MsgSN";

            PagingVar pv = new PagingVar();

            pv.SQLCount = "select count(0)" + sqlFrom + sqlWhere;
            pv.SQLRead  = "select " + pkName + sqlFrom + sqlWhere + sqlOrder;
            pv.SQL      = sqlSelect + sqlFrom + " where " + pkName + " in({0})" + sqlOrder;
            Paging pg = new Paging(pv, new PagingUrlVar(30, cur_pageIndex));//页记录 30

            pg.load();

            Bind.BGRepeater(pg.GetDataTable(), this.rpList);

            this.ucPS1.f  = pg;
            this.ucPS1.cs = "javascript:ajaxPage('ajax_page_msg',{0});";

            lNum = pg.um.records_count.ToString();
        }
예제 #16
0
        private void EvaluateList()
        {
            string sSql = "select top 10 ev.Fraction,ev.Detail,ev.ReDetail,ev.AddDate,ui.UserName from Pro_Evaluate ev left join User_Info ui on ev.FK_User=ui.UserSN where Purview=1 and FK_Pro=" + id + " order by ev.AddDate desc";

            DataTable dt = DbHelp.GetDataTable(sSql);

            Bind.BGRepeater(dt, this.rpEvaluate);
        }
예제 #17
0
        //订单商品列表
        private void BGOrdPro()
        {
            DataTable dtPro = Ord_Pro.List(id);

            pageTotalPrice1 = PriceHandler.GetTotalPrice(dtPro, "op_UserTotalPrice");

            Bind.BGRepeater(dtPro, this.rpListProUp);
        }
예제 #18
0
        private void ListTaoCan(string cacheName, int topN, PubEnum.TaoCanItem type, Repeater rep)
        {
            int    iItem = (int)type;
            string sSQL  = string.Format("select top " + topN + " ProSN,ProName,PicS,Detail3,Item from vgTaoCan_Info where Item&{0}={0} order by EditDate desc", iItem);

            DataTable dt = cac.GetDataTable(cacheName, sSQL);

            Bind.BGRepeater(dt, rep, false);
        }
예제 #19
0
        //本类推荐
        private void ListTJ()
        {
            int    iItem = (int)PubEnum.TaoCanItem.推荐;
            string sSQL  = string.Format("select top 6 ProSN,ProName,PicS,Item from vgTaoCan_Info a,T_TaoCan_Class_GetChildAndSelf({0}) b where a.FK_Pro_Class=b.id and Item&{1}={1} order by EditDate desc", id, iItem);

            DataTable dt = cac.GetDataTable("taoCan_classTJ" + id, sSQL);

            Bind.BGRepeater(dt, this.rpTJ, false);
        }
예제 #20
0
        private void PicList()
        {
            string    sSql  = "select PicS,PicB from CaiPu_Pic where FK_Pro=" + id;
            DataTable dtPic = DbHelp.GetDataTable(sSql);

            if (dtPic.Rows.Count > 1)
            {
                Bind.BGRepeater(dtPic, this.rpPic);
            }
        }
예제 #21
0
        private void LL()
        {
            HistoryData hd = new HistoryData("taoCanHistory", Max);

            string sID = hd.Add(ProID);

            if (sID.Length > 0)
            {
                DataTable dtHistory = DbHelp.GetDataTable("select ProSN,ProName,PicS from vgTaoCan_Info where ProSN in(" + sID + ")  order by EditDate desc");
                Bind.BGRepeater(dtHistory, this.rpHistory);
            }
        }
예제 #22
0
        //分类列表
        private void List()
        {
            if (keyword.Length > 0)
            {
                this.curPath.Text += "  <span class=\"search-color\">" + keyword + "</span>";
            }

            string sqlSelect, sqlFrom, sqlWhere = string.Empty, sqlOrder, pkName;

            sqlSelect = "select NewsSN,Source,Title,EditDate,Detail,UrlType,Url";
            sqlFrom   = " from News_Info";

            if (id > 0)
            {
                sqlWhere = " where FK_News_Class" + id;
            }

            if (item > 0)
            {
                string aw = sqlWhere.Length > 0 ? " and " : " where ";
                sqlWhere += aw + "Item&" + item + "=" + item;
            }

            if (keyword.Length > 0)
            {
                string aw = sqlWhere.Length > 0 ? " and " : " where ";
                sqlWhere += aw + " Title like '%'+@Title+'%'";
            }

            sqlOrder = " order by EditDate desc";
            pkName   = "NewsSN";

            PagingVar pv = new PagingVar();

            pv.SQLCount = "select count(0)" + sqlFrom + sqlWhere;
            pv.SQLRead  = "select " + pkName + sqlFrom + sqlWhere + sqlOrder;
            pv.SQL      = sqlSelect + sqlFrom + " where " + pkName + " in({0})" + sqlOrder;

            IDataParameter[] dp =
            {
                DbHelp.Def.AddParam("@Title", keyword)
            };

            pv.DataParm = dp;
            Paging pg = new Paging(pv, new PagingUrlVar(8, pageIndex));//页记录

            pg.load();
            Bind.BGRepeater(pg.GetDataTable(), this.rpNewsList);

            this.ucPS1.f  = pg;
            this.ucPS1.cs = Request.Url.AbsolutePath + "?s=" + id + "-{0}----" + keywordEncode;
        }
예제 #23
0
        //产品列表
        private void List()
        {
            PagingList pl = new PagingList("vgPro_Info", "ProSN", new PagingUrlVar(16, pageIndex));

            if (t == 1)
            {
                pl.SqlSelect = "select ProSN,ProName,PicS,Price1,PriceMarket,Item,Number,UnitNum,StockN,Unit";
            }
            else
            {
                pl.SqlSelect = "select ProSN,ProName,PicS,Price1,PriceMarket,Item";
            }

            //pl.SqlFrom = "from vgPro_Info a , T_Pro_Class_GetChildAndSelf(" + id + ") b";
            //pl.SqlWhere = "where a.FK_Pro_Class=b.id";

            pl.SqlFrom  = "from vgPro_Info";
            pl.SqlWhere = "where Item&16=16 and MS_StartTime<=getdate() and MS_EndTime>=getdate()";

            switch (ord)
            {
            case 1:
                pl.SqlOrder = "order by Price1 asc";
                break;

            case 2:
                pl.SqlOrder = "order by Price1 desc";
                break;

            default:
                pl.SqlOrder = "order by EditDate desc";
                break;
            }

            Paging pg = pl.List(true);

            if (t == 1)
            {
                stypeModel           = "2";
                this.showPic.Visible = false;
                Bind.BGRepeater(pg.GetDataTable(), this.rpList);
            }
            else
            {
                this.showList.Visible = false;
                rpPic.dt             = pg.GetDataTable();
                this.rpPic.listEvent = new CycleEvent(ProLay.listCuXiao2);
            }

            this.ucPS1.f  = pg;
            this.ucPS1.cs = Request.Url.AbsolutePath + "?s=" + id + "-{0}-" + t;
        }
예제 #24
0
        private void List()
        {
            //评论数
            string sql = "select count(0) from News_Msg where Purview=1 and FK_News=" + id;

            lNum = DbHelp.Scalar(sql).ToString();

            //最新评论
            sql = "select top 5 N.FK_User,Detail,N.AddDate as AddDate,UserName from News_Msg as N left join User_Info as U on N.FK_User=U.UserSN where Purview=1 and FK_News=" + id + " order by N.AddDate desc";
            DataTable dt = DbHelp.GetDataTable(sql);

            Bind.BGRepeater(dt, this.rpMsgList);
        }
예제 #25
0
        protected DataTable dtHotSell2; //本月热卖
        private void LL()
        {
            string sSQL;

            //推荐
            sSQL = string.Format("select top 4 ProSN,ProName,PicS,Price,Item from vgPro_Info where Item&{0}={0} order by EditDate desc", (int)PubEnum.ProItem.新品);
            this.rpRecommend.dt = dbCac.GetDataTable("Pro_rpRecommend", ref sSQL);

            //热门
            sSQL          = string.Format("select top 5 ProSN,ProName,PicS,Price,Item from vgPro_Info where Item&{0}={0} order by EditDate desc", (int)PubEnum.ProItem.热销);
            this.rpHot.dt = dbCac.GetDataTable("Pro_rpHot", ref sSQL);

            //网站公告
            sSQL = "select top 5 BulletinSN,Title from Bulletin where BulletinType=0 order by EditDate desc";
            Bind.BGRepeater(dbCac.GetDataTable("Bulletin_rpWebNotice", ref sSQL), this.rpWebNotice, false);

            //活运通知
            sSQL = "select top 5 BulletinSN,Title from Bulletin where BulletinType=1 order by EditDate desc";
            Bind.BGRepeater(dbCac.GetDataTable("Bulletin_rpWebActive", ref sSQL), this.rpWebActive, false);

            //幻灯片
            sSQL = "select AdvName,AdvImg,AdvURL from Adv_Info where Keyword='default_ppt' order by Taxis asc";
            Bind.BGRepeater(dbCac.GetDataTable("Adv_rpPPT", ref sSQL), this.rpPPT, false);

            #region 热卖
            //本周热卖
            Pro_Info_HotSell pihHotSell1 = new Pro_Info_HotSell("Pro_pihHotSell1", DateTime.Now.Add(new TimeSpan(-7, 0, 0, 0)));
            dtHotSell1 = dbCac.GetDataTable(pihHotSell1);

            //本月热卖
            Pro_Info_HotSell pihHotSell2 = new Pro_Info_HotSell("Pro_pihHotSell2", Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd")));
            dtHotSell2 = dbCac.GetDataTable(pihHotSell2);
            #endregion

            //分类商品
            this.rpClassPro1.dt = dbCac.GetDataTable("Pro_Class_rpClassPro1", GetClassSQL(2));
            this.rpClassPro2.dt = dbCac.GetDataTable("Pro_Class_rpClassPro2", GetClassSQL(1));
            this.rpClassPro3.dt = dbCac.GetDataTable("Pro_Class_rpClassPro3", GetClassSQL(19));

            //子级分类列表
            DataTable classPro1 = dtProClass.Clone();
            DataTable classPro2 = dtProClass.Clone();
            DataTable classPro3 = dtProClass.Clone();
            Fn.DrwToDt(dtProClass.Select("PClassSN=" + 2, "Taxis asc"), classPro1);
            Fn.DrwToDt(dtProClass.Select("PClassSN=" + 1, "Taxis asc"), classPro2);
            Fn.DrwToDt(dtProClass.Select("PClassSN=" + 19, "Taxis asc"), classPro3);
            Bind.BGRepeater(classPro1, this.rpClass1, false);
            Bind.BGRepeater(classPro2, this.rpClass2, false);
            Bind.BGRepeater(classPro3, this.rpClass3, false);
        }
예제 #26
0
        //产品列表
        private void List()
        {
            PagingList pl = new PagingList("vgTaoCan_Info", "ProSN", new PagingUrlVar(16, pageIndex));

            if (t == 1)
            {
                pl.SqlSelect = "select ProSN,ProName,PicS,Item,Number,UnitNum,StockN,Unit";
            }
            else
            {
                pl.SqlSelect = "select ProSN,ProName,PicS,Item";
            }

            pl.SqlFrom  = "from vgTaoCan_Info a , T_TaoCan_Class_GetChildAndSelf(" + id + ") b";
            pl.SqlWhere = "where a.FK_Pro_Class=b.id";
            switch (ord)
            {
            case 1:
                pl.SqlOrder = "order by Hit asc";
                break;

            case 2:
                pl.SqlOrder = "order by Hit desc";
                break;

            default:
                pl.SqlOrder = "order by EditDate desc";
                break;
            }

            Paging pg = pl.List(true);

            if (t == 1)
            {
                stypeModel = "2";

                this.showPic.Visible = false;
                Bind.BGRepeater(pg.GetDataTable(), this.rpList);
            }
            else
            {
                this.showList.Visible = false;
                this.rpPic.dt         = pg.GetDataTable();
                this.rpPic.listEvent  = new CycleEvent(TaoCanLay.list1);
            }

            this.ucPS1.f  = pg;
            this.ucPS1.cs = GetURL.TaoCan.Class(id + "-{0}-" + t);
        }
예제 #27
0
        private void ProList(string pIds)
        {
            int userLevel = LoginInfo.UserLevel;

            string sql = "select ProSN," + num + " as Num,ProName,Number,Price,Price1,Price2,MS_StartTime,MS_EndTime,PicS,LevelPrice,Item,ProIsHas,StockN,pi.Unit,pi.UnitNum from "
                         + "vgPro_Info pi left join (select LevelPrice,Fk_Pro from Pro_LevelPrice where FK_User_Level=" + userLevel + ") lp on lp.Fk_Pro=pi.ProSN "
                         + "where ProSN in(" + pIds + ")";

            DataTable    dt = DbHelp.GetDataTable(sql);
            PriceHandler ph = new PriceHandler(dt, userLevel, userIdentifier);

            Dictionary <int, DataTable> dirc = ph.Change();

            Bind.BGRepeater(dirc[10], this.rpList);
        }
예제 #28
0
        private void GetChild()
        {
            //string sSql="select pi.ProSN,pi.ProName,pi.Price,pi.PicS from "
            //    + "vgPro_Info pi left join CaiPu_Pro caip on pi.ProSN=caip.FK_Pro "
            //    + "left join TaoCan_Pro taoc on caip.FK_CaiPu=taoc.FK_CaiPu"
            //    + " where taoc.FK_TaoCan=" + id;

            string sql;

            sql = "select ci.ProSN,ci.ProName,ci.PicS from TaoCan_CaiPu tc left join vgCaiPu_Info ci on tc.FK_CaiPu=ci.ProSN where tc.FK_TaoCan=" + id;
            Bind.BGRepeater(sql, this.rpChild);

            sql = "select pi.ProSN,pi.ProName,pi.Price,pi.PicS from TaoCan_Pro tc left join vgPro_Info pi on tc.FK_CaiPu=pi.ProSN where tc.FK_TaoCan=" + id;
            Bind.BGRepeater(sql, this.rpChild1);
        }
예제 #29
0
        //评论列表
        private void List()
        {
            PagingList pl = new PagingList("Gift_Info", "GiftSN", new PagingUrlVar(12, pageIndex));

            pl.SqlSelect = "select GiftSN,GiftName,Integral,PicS";
            pl.SqlFrom   = "from Gift_Info";
            pl.SqlWhere  = id == 0 ? "" : "where FK_Gift_Class=" + id;
            pl.SqlOrder  = "order by ExchangeN desc";

            Paging pg = pl.List(true);

            Bind.BGRepeater(pg.GetDataTable(), this.rpList);

            this.ucPS1.f  = pg;
            this.ucPS1.cs = "?s=" + id + "-{0}#locate";
        }
예제 #30
0
        //分类列表
        private void List()
        {
            PagingList pl = new PagingList("News_Info", "NewsSN", new PagingUrlVar(8, pageIndex));

            pl.SqlSelect = "select NewsSN,Source,Title,EditDate,Detail,UrlType,Url";
            pl.SqlFrom   = "from news_Info";
            pl.SqlWhere  = "where FK_News_Class=" + id;
            pl.SqlOrder  = "order by EditDate desc";

            Paging pg = pl.List(true);

            Bind.BGRepeater(pg.GetDataTable(), this.rpNewsList);

            this.ucPS1.f  = pg;
            this.ucPS1.cs = GetURL.News.Class(id.ToString() + "-{0}");
        }