コード例 #1
0
        void InitNewsListForPage()
        {
            string tblName = "ViewPoint";
            string fldName = "*";
            string fldSort = "ID";
            bool   sort    = true;

            StringBuilder _str = new StringBuilder();

            _str.Append(" ");

            //判断分类
            if (!string.IsNullOrEmpty(ViewState["type"].ToString()))
            {
                _str.Append(" and TpId = " + jsOnClient.ReplaceBadChar(ViewState["type"].ToString()) + " ");
                pointT = ptManager.GetPointType(Convert.ToInt32(ViewState["type"]));
            }


            int pageCount;
            int counts;

            this.rpt_news_list_for_page.DataSource = vpManager.GetViewPointList(tblName, fldName, pageSize, currentPageIndex, fldSort, sort, _str.ToString(), out pageCount, out counts);
            this.rpt_news_list_for_page.DataBind();

            //string url = "?type=" + jsOnClient.ReplaceBadChar(ViewState["Type"].ToString()) + "&page={0}";
            string url = "http://www.rontpump.com/news-" + jsOnClient.ReplaceBadChar(ViewState["type"].ToString()) + "-{0}.html";

            //string url = "?page={0}";
            div_showpage.InnerHtml = PageControl.DisplayPagers(currentPageIndex, counts, pageSize, "", url, "");
        }
コード例 #2
0
        void InitProducts()
        {
            StringBuilder tblName  = new StringBuilder();
            StringBuilder fldName  = new StringBuilder();
            StringBuilder strWhere = new StringBuilder();
            StringBuilder fldSort  = new StringBuilder();

            fldSort.Append("ID");
            bool sort = false;

            tblName.Append("Cases");
            fldName.Append("*");
            strWhere.Append(" ");

            if (ViewState["CTID"].ToString() != "0")
            {
                strWhere.Append(" and CTID = '" + jsOnClient.ReplaceBadChar(ViewState["CTID"].ToString()) + "' or CTID like '%," + jsOnClient.ReplaceBadChar(ViewState["CTID"].ToString()) + "' or CTID like '" + jsOnClient.ReplaceBadChar(ViewState["CTID"].ToString()) + ",%' or CTID like '%," + jsOnClient.ReplaceBadChar(ViewState["CTID"].ToString()) + ",%'");
                caseT = ctManager.GetCaseTypeByID(Convert.ToInt32(ViewState["CTID"]));
            }

            if (!string.IsNullOrEmpty(ViewState["SKey"].ToString()))
            {
                strWhere.Append(" and CName like '%" + jsOnClient.ReplaceBadChar(ViewState["SKey"].ToString()) + "%' ");
            }


            int pageCount;
            int counts;

            this.rpt_product_list.DataSource = caseManager.GetPagedProducts(tblName.ToString(), fldName.ToString(), pageSize, currentPageIndex, fldSort.ToString(), sort, strWhere.ToString(), out pageCount, out counts);
            this.rpt_product_list.DataBind();

            //string url = "?ctid=" + ViewState["CTID"].ToString() + "&page={0}";
            string url = "http://www.rontpump.com/products-" + ViewState["CTID"].ToString() + "-{0}.html";

            div_showpage.InnerHtml = PageControl.DisplayPagers(currentPageIndex, counts, pageSize, "", url, "");
        }