/// <summary>
/// 绑定数据
/// </summary>
/// <param name="PageIndex">页码</param>
private void ListDataBind(int PageIndex)
{
int num = 15, i = 0, j = 0;
CMS.DAL.CMS_Product dal = new CMS.DAL.CMS_Product();
CMS.DAL.CMS_ProductClass dalClass = new CMS.DAL.CMS_ProductClass();
string strWhere = "";
if (!string.IsNullOrEmpty(Request.QueryString["class"]))
{
string strclassid = Request.QueryString["class"];
int classid = int.Parse(strclassid);
CMS.Model.CMS_ProductClass model = dalClass.GetModel(classid);
string classidlist = model.CMS_ClassIdList;//树结构列表
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT ID FROM CMS_ProductClass");
strSql.Append(" where CMS_ClassIdList like '" + classidlist + "%'");
strWhere = " CMS_ProductClassID in ("+strSql.ToString()+")";
}
DataTable dt = dal.GetPagesAll(strWhere, PageIndex, num, out i, out j);
this.PageNavigator1.PageCount = j;
this.PageNavigator1.PageIndex = PageIndex;
this.PageNavigator1.RecordCount = i;
this.Repeater1.DataSource = dt;
this.Repeater1.DataBind();
}
/// <summary>
///
/// </summary>
private void InitIndexProductClass()
{
CMS.DAL.CMS_ProductClass dal = new CMS.DAL.CMS_ProductClass();
DataTable dt = dal.GetList(" CMS_PID =0").Tables[0];
this.RepeaterProducts.DataSource = dt.DefaultView;
this.RepeaterProducts.DataBind();
}
/// <summary>
/// 根据类别ID得到产品类别名称
/// </summary>
/// <param name="ProductClassID"></param>
/// <returns></returns>
public string getProductClassName(int ProductClassID)
{
string strClassName = "";
CMS.DAL.CMS_ProductClass dal = new CMS.DAL.CMS_ProductClass();
CMS.Model.CMS_ProductClass model = dal.GetModel(ProductClassID);
strClassName = model.CMS_ClassName;
return strClassName;
}
/// <summary>
/// 初始化
/// </summary>
private void InitData()
{
CMS.DAL.CMS_ProductClass dal = new CMS.DAL.CMS_ProductClass();
DataTable dt = new DataTable();
if(!string.IsNullOrEmpty(Request.QueryString["classId"]))
{
string strid = Request.QueryString["classId"].ToString();
dt = dal.GetListFromPID(Int32.Parse(strid));
}
else
{
dt = dal.GetListFromPID(0);
}
this.rptClassList.DataSource = dt;
this.rptClassList.DataBind();
}
/// <summary>
/// 初始化下拉列表
/// </summary>
private void InitDropDownList()
{
CMS.DAL.CMS_ProductClass dal = new CMS.DAL.CMS_ProductClass();
DataSet ds = dal.GetList("");
this.ddlProductClass.Items.Add(new ListItem("<==请选择==>", "0"));
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
ListItem item = new ListItem();
int ClassLayer = int.Parse(ds.Tables[0].Rows[i]["CMS_ClassLayer"].ToString());
string strName = ds.Tables[0].Rows[i]["CMS_ClassName"].ToString();
string strValue = ds.Tables[0].Rows[i]["ID"].ToString();
if (ClassLayer > 1)
{
strName = Utils.StringOfChar(ClassLayer - 1, " |-") + strName;
}
item.Text = strName;
item.Value = strValue;
this.ddlProductClass.Items.Add(item);
}
}
