/// <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); } }