using System;
using System.Collections.Generic;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

namespace Mtxfw.shop
{
    public partial class shop_products : System.Web.UI.Page
    {
        public Mtxfw.DAL.P_Category daoCategory = new Mtxfw.DAL.P_Category();
        public Mtxfw.DAL.P_Product daoProduct = new Mtxfw.DAL.P_Product();
        public Mtxfw.DAL.Ads daoAds = new Mtxfw.DAL.Ads();
        public Mtxfw.Utility.Config config = new Mtxfw.Utility.Config();
        public Mtxfw.DAL.user_info daoUser = new Mtxfw.DAL.user_info();
        public String TitName = "", strNextPage = "", strcategories = "", rurl = "", strposition = "", strcatetitle="您还没有登录，请先&nbsp;<a href=\"login.aspx\">登录</a>";
        public string strprovince = "", strprovincename = "";
        protected string AdsName01, AdsName02;
        protected string indexTP01, indexTP02;
        protected string indexTPLink01, indexTPLink02;
        protected int MemberIFStores = 0;
        protected void Page_Load(object sender, EventArgs e)
        {
           
            if (Session["MemberId"] != null)
            {
                int MemberId=Convert.ToInt32(Session["MemberId"].ToString());
                Mtxfw.Model.user_info model = daoUser.GetModel(MemberId);
                if (model != null)
                {
                    strcatetitle = "我当前的积分余额：" + model.umoney0.ToString() + "&nbsp;积分";
                }
                
                if (Session["MemberIFStores"] != null)
                {
                    MemberIFStores = int.Parse(Session["MemberIFStores"].ToString());
                }
            }
            System.Data.DataSet Ds_Ads = daoAds.GetCacheList("top 50", "utype=N'首页广告' Order By AdsSort asc", "shop_Ads");
            System.Data.DataTable Dt_Ads = Ds_Ads != null && Ds_Ads.Tables[0] != null ? Ds_Ads.Tables[0] : null;
            int i = 1;
            foreach (System.Data.DataRow Dr in Dt_Ads.Rows)
            {
                if (i == Dt_Ads.Rows.Count)
                {
                    indexTP01 = Dr["AdsPic"].ToString();
                    indexTPLink01 = Dr["AdsUrl"].ToString();
                    AdsName01 = Dr["AdsName"].ToString();
                }
                
                i += 1;
            }
            if (!IsPostBack)
            {
                Data_Bind();
            }
        }
        protected void Data_Bind()
        {
                String PageSize = Mtxfw.Utility.Tools.SafeSQL(Request.QueryString["PageSize"]);
                String iPage = Mtxfw.Utility.Tools.SafeSQL(Request.QueryString["Page"]);
                String Order = Mtxfw.Utility.Tools.SafeSQL(Request.QueryString["Order"]);
                Page.Title = "成为VIP会员必选商品-" + strprovincename + "-" + config.webName;
                strposition = "成为VIP会员必选商品";
               
                string strOrder = "P_ID desc";
                if (!String.IsNullOrEmpty(Order))
                {
                    if (Order=="0")
                    {
                        strOrder = "P_Orders desc";
                    }
                    if (Order == "1")
                    {
                        strOrder = "P_VIP_P desc";
                    }
                    if (Order == "2")
                    {
                        strOrder = "P_PJOrders desc";
                    }
                    if (Order == "2")
                    {
                        strOrder = "P_ADDATE desc";
                    }
                }

                MyPager.PageSize = 32;
                if (!String.IsNullOrEmpty(PageSize) && PageSize != "")
                {
                    PageSize = int.Parse(PageSize).ToString();
                    MyPager.PageSize = int.Parse(PageSize);
                }
                if (!String.IsNullOrEmpty(iPage) && iPage != "-1")
                {
                    MyPager.CurrentPageIndex = int.Parse(iPage);
                }
                MyPager.RecordCount = daoProduct.GetCount("utype='0' and P_State='已处理' And P_jpproduct=1");
                Mtxfw.Utility.Tools.ToBind(Repeater_shop, daoProduct.GetPager(MyPager, "", "utype='0' and P_State='已处理' And P_jpproduct=1 Order by " + strOrder));
           
        }
       

       
        
    }
}