106 lines
4.3 KiB
C#
106 lines
4.3 KiB
C#
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="您还没有登录，请先 <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() + " 积分";
|
|
}
|
|
|
|
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));
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
}
|
|
} |