private void GetModel() { BLL.article_category bll = new BLL.article_category(); model = bll.GetModel(category_id); RepBindType.DataSource = bll.GetList(81, 11); RepBindType.DataBind(); RepBindType2.DataSource = bll.GetList(81, 11); RepBindType2.DataBind(); }
private void TreeBind(int _channel_id) { BLL.article_category bll = new BLL.article_category(); DataTable dt = bll.GetList(0, _channel_id); this.ddlCategoryId.Items.Clear(); this.ddlCategoryId.Items.Add(new ListItem("請選擇類別...", "")); foreach (DataRow dr in dt.Rows) { string Id = dr["id"].ToString(); int ClassLayer = int.Parse(dr["class_layer"].ToString()); string Title = dr["title"].ToString().Trim(); if (ClassLayer == 1) { this.ddlCategoryId.Items.Add(new ListItem(Title, Id)); } else { Title = "├ " + Title; Title = Utils.StringOfChar(ClassLayer - 1, " ") + Title; this.ddlCategoryId.Items.Add(new ListItem(Title, Id)); } } cbMore.DataSource = dt; cbMore.DataTextField = "title"; cbMore.DataValueField = "id"; cbMore.DataBind(); }
private void TreeBind(int _channel_id) { BLL.article_category bll = new BLL.article_category(); DataTable dt = bll.GetList(0, _channel_id); this.ddlParentId.Items.Clear(); this.ddlParentId.Items.Add(new ListItem("无父级分类", "0")); foreach (DataRow dr in dt.Rows) { string Id = dr["id"].ToString(); int ClassLayer = int.Parse(dr["class_layer"].ToString()); string Title = dr["title"].ToString().Trim(); if (ClassLayer == 1) { this.ddlParentId.Items.Add(new ListItem(Title, Id)); } else { Title = "├ " + Title; Title = Utils.StringOfChar(ClassLayer - 1, " ") + Title; this.ddlParentId.Items.Add(new ListItem(Title, Id)); } } }
private void TreeBind(int _channel_id) { BLL.article_category bll = new BLL.article_category(); DataTable dt = bll.GetList(0, _channel_id); this.ddlCategoryId.Items.Clear(); this.ddlCategoryId.Items.Add(new ListItem("所有类别", "")); this.ddlMoveId.Items.Clear(); this.ddlMoveId.Items.Add(new ListItem("批量移动...", "")); foreach (DataRow dr in dt.Rows) { string Id = dr["id"].ToString(); int ClassLayer = int.Parse(dr["class_layer"].ToString()); string Title = dr["title"].ToString().Trim(); if (ClassLayer == 1) { this.ddlCategoryId.Items.Add(new ListItem(Title, Id)); this.ddlMoveId.Items.Add(new ListItem(Title, Id)); } else { Title = "├ " + Title; Title = Utils.StringOfChar(ClassLayer - 1, " ") + Title; this.ddlCategoryId.Items.Add(new ListItem(Title, Id)); this.ddlMoveId.Items.Add(new ListItem(Title, Id)); } } }
//数据绑定 private void RptBind() { BLL.article_category bll = new BLL.article_category(); DataTable dt = bll.GetList(0, this.channel_id); this.rptList.DataSource = dt; this.rptList.DataBind(); }
private void TreeBind(int _channel_id) { //根据当前用户类别进行筛选 var manager = GetAdminInfo(); var strWhere = ""; BLL.article_category bll = new BLL.article_category(); DataTable dt = bll.GetList(0, _channel_id, strWhere); this.ddlCategoryId.Items.Clear(); this.ddlCategoryId.Items.Add(new ListItem("请选择类别...", "")); foreach (DataRow dr in dt.Rows) { string Id = dr["id"].ToString(); int ClassLayer = int.Parse(dr["class_layer"].ToString()); string Title = dr["title"].ToString().Trim(); if (ClassLayer == 1) { this.ddlCategoryId.Items.Add(new ListItem(Title, Id)); } else { Title = "├ " + Title; Title = Utils.StringOfChar(ClassLayer - 1, " ") + Title; this.ddlCategoryId.Items.Add(new ListItem(Title, Id)); } } }
protected void TreeBind() { BLL.article_category bll = new BLL.article_category(); DataTable dt = bll.GetList(0, 6); this.ddlCategoryId.Items.Clear(); this.ddlCategoryId.Items.Add(new ListItem("所有产品", "")); foreach (DataRow dr in dt.Rows) { string Id = dr["id"].ToString(); int ClassLayer = int.Parse(dr["class_layer"].ToString()); string Title = dr["title"].ToString().Trim(); if (ClassLayer == 1) { this.ddlCategoryId.Items.Add(new ListItem(Title, Id)); } else { Title = "├ " + Title; Title = Utils.StringOfChar(ClassLayer - 1, " ") + Title; this.ddlCategoryId.Items.Add(new ListItem(Title, Id)); } } }
//数据绑定 private void RptBind() { BLL.article_category bll = new BLL.article_category(); string strWhere = string.Empty; //获取管理员 Model.manager adminModel = GetAdminInfo(); if (adminModel.role_type != 1) { List <int> idlist = new List <int>(); //获取频道名称 string channel_name = new BLL.channel().GetChannelName(this.channel_id); //获取权限列表 string nav_name = "channel_" + channel_name + "_category_"; DataTable dt2 = new BLL.manager_role_value().GetList(0, string.Format("role_id={0} and action_type='Show' and nav_name like '{1}%'", adminModel.role_id, nav_name), "").Tables[0]; if (dt2.Rows.Count > 0) { foreach (DataRow dr in dt2.Rows) { idlist.Add(int.Parse(dr["nav_name"].ToString().Replace(nav_name, string.Empty))); } } else { idlist.Add(0); } strWhere = string.Format("id in ({0})", string.Join(",", idlist)); } DataTable dt = bll.GetList(0, this.channel_id, strWhere); this.rptList.DataSource = dt; this.rptList.DataBind(); }
private void TreeBind() { Model.wx_userweixin weixin = GetWeiXinCode(); BLL.article_category bll = new BLL.article_category(); DataTable dt = bll.GetList(" wid=" + weixin.id); //最新车讯 this.ddlZxcx.Items.Clear(); this.ddlZxcx.Items.Add(new ListItem("请选择最新车讯...", "")); foreach (DataRow dr in dt.Rows) { string Id = dr["id"].ToString(); string Title = dr["title"].ToString().Trim(); this.ddlZxcx.Items.Add(new ListItem(Title, Id)); } //最新优惠 this.ddlZxyh.Items.Clear(); this.ddlZxyh.Items.Add(new ListItem("请选择最新优惠...", "")); foreach (DataRow dr in dt.Rows) { string Id = dr["id"].ToString(); string Title = dr["title"].ToString().Trim(); this.ddlZxyh.Items.Add(new ListItem(Title, Id)); } //尊享二手车 this.ddlEsc.Items.Clear(); this.ddlEsc.Items.Add(new ListItem("请选择二手车...", "")); foreach (DataRow dr in dt.Rows) { string Id = dr["id"].ToString(); string Title = dr["title"].ToString().Trim(); this.ddlEsc.Items.Add(new ListItem(Title, Id)); } //品牌相册 BLL.wx_albums_info aiBll = new BLL.wx_albums_info(); DataTable aidt = aiBll.GetList(" wid=" + weixin.id).Tables[0]; this.ddlPpxc.Items.Clear(); this.ddlPpxc.Items.Add(new ListItem("请选择品牌相册...", "")); foreach (DataRow dr in aidt.Rows) { string Id = dr["id"].ToString(); string Title = dr["aname"].ToString().Trim(); this.ddlPpxc.Items.Add(new ListItem(Title, Id)); } //LBS BLL.wx_lbs_shopInfo lbsBll = new BLL.wx_lbs_shopInfo(); DataTable lbsdt = lbsBll.GetList(" wid=" + weixin.id).Tables[0]; this.ddlLbs.Items.Clear(); this.ddlLbs.Items.Add(new ListItem("请选择LBS...", "")); foreach (DataRow dr in lbsdt.Rows) { string Id = dr["id"].ToString(); string Title = dr["shopName"].ToString().Trim(); this.ddlLbs.Items.Add(new ListItem(Title, Id)); } }
private void PPTreeBind() { BLL.article_category bll = new BLL.article_category(); DataTable dt = bll.GetList(0, 6); this.ddlvote_id.Items.Clear(); this.ddlvote_id.Items.Add(new ListItem("请选择商品品牌..", "")); foreach (DataRow dr in dt.Rows) { string Id = dr["id"].ToString(); int ClassLayer = int.Parse(dr["class_layer"].ToString()); string Title = dr["title"].ToString().Trim(); if (ClassLayer == 1) { this.ddlvote_id.Items.Add(new ListItem(Title, Id)); } else { Title = "├ " + Title; Title = Utils.StringOfChar(ClassLayer - 1, " ") + Title; this.ddlvote_id.Items.Add(new ListItem(Title, Id)); } } div_sppp.Visible = true; }
private void get_prop_page(HttpContext context) { try { StringBuilder strhtml = new StringBuilder(); int category = DTRequest.GetFormInt("category", 0); int page = DTRequest.GetFormInt("page", 1); BLL.property pro = new BLL.property(); BLL.property_value pro_value = new BLL.property_value(); BLL.article_category catgory = new BLL.article_category(); string category_ids = ""; DataTable dt_pro = null; if (category == 0) { dt_pro = pro.GetList("").Tables[0]; } else { DataTable cat_dt = catgory.GetList(0, 2, category.ToString());//查找类别下的所有类别 if (cat_dt.Rows.Count > 0) { for (int i = 0; i < cat_dt.Rows.Count; i++) { category_ids += cat_dt.Rows[i][0].ToString() + ","; } category_ids = category_ids.Substring(0, category_ids.Length - 1); } dt_pro = pro.GetList("category_id in(" + category_ids + ")").Tables[0]; } if (dt_pro.Rows.Count > 0) { for (int i = 0; i < dt_pro.Rows.Count; i++) { strhtml.Append("<dl>"); strhtml.Append("<dt>" + dt_pro.Rows[i]["title"] + "</dt>"); DataTable dt_pro_value = pro_value.GetList("property_id='" + dt_pro.Rows[i][0] + "'").Tables[0]; if (dt_pro_value.Rows.Count > 0) { for (int j = 0; j < dt_pro_value.Rows.Count; j++) { strhtml.Append("<dd><a style=\"cursor:pointer;\" onclick='getpagedata(" + dt_pro_value.Rows[j][0] + "," + category + "," + page + ")'>" + dt_pro_value.Rows[j]["value"] + "</a><span></span></dd>"); } } strhtml.Append("</dl>"); } context.Response.Write("{ \"info\":\"获取数据成功!\", \"status\":\"1\" ,\"html\":\"" + myJson.String2Json(strhtml.ToString()) + "\",\"pagelist\":\"\"}"); return; } context.Response.Write("{ \"info\":\"该类别暂未添加属性!\", \"status\":\"0\" }"); } catch (Exception ex) { context.Response.Write("{ \"info\":\"该类别暂未添加属性!\", \"status\":\"0\" }"); return; } }
private void TreeBind(int _channel_id, out string return_term) { BLL.article_category bll = new BLL.article_category(); return_term = string.Empty; string strWhere = string.Empty; //获取管理员 Model.manager adminModel = GetAdminInfo(); if (adminModel.role_type != 1) { List <int> idlist = new List <int>(); //获取频道名称 string channel_name = new BLL.channel().GetChannelName(this.channel_id); //获取权限列表 string nav_name = "channel_" + channel_name + "_category_"; DataTable dt2 = new BLL.manager_role_value().GetList(0, string.Format("role_id={0} and action_type='Show' and nav_name like '{1}%'", adminModel.role_id, nav_name), "").Tables[0]; if (dt2.Rows.Count > 0) { foreach (DataRow dr in dt2.Rows) { idlist.Add(int.Parse(dr["nav_name"].ToString().Replace(nav_name, string.Empty))); } } else { idlist.Add(0); } return_term = string.Join(",", idlist); strWhere = string.Format("id in ({0})", return_term); } DataTable dt = bll.GetList(0, this.channel_id, strWhere); this.ddlCategoryId.Items.Clear(); this.ddlCategoryId.Items.Add(new ListItem("所有类别", "")); this.ddlMoveId.Items.Clear(); this.ddlMoveId.Items.Add(new ListItem("批量移动...", "")); foreach (DataRow dr in dt.Rows) { string Id = dr["id"].ToString(); int ClassLayer = int.Parse(dr["class_layer"].ToString()); string Title = dr["title"].ToString().Trim(); if (ClassLayer == 1) { this.ddlCategoryId.Items.Add(new ListItem(Title, Id)); this.ddlMoveId.Items.Add(new ListItem(Title, Id)); } else { Title = "├ " + Title; Title = Utils.StringOfChar(ClassLayer - 1, " ") + Title; this.ddlCategoryId.Items.Add(new ListItem(Title, Id)); this.ddlMoveId.Items.Add(new ListItem(Title, Id)); } } }
//数据绑定 private void RptBind() { var manager = GetAdminInfo(); var strWhere = ""; BLL.article_category bll = new BLL.article_category(); DataTable dt = bll.GetList(0, this.channel_id, strWhere); this.rptList.DataSource = dt; this.rptList.DataBind(); }
//#region 角色类型================================= //private void RoleBind(DropDownList ddl, int role_type) //{ // BLL.activity bll = new BLL.activity(); // DataTable dt = bll.GetList("").Tables[0]; // ddl.Items.Clear(); // ddl.Items.Add(new ListItem("请选择活动...", "")); // foreach (DataRow dr in dt.Rows) // { // if (ddl.Items.Contains(dr["type"] as ListItem)) // { // ddl.Items.Add(new ListItem(dr["remark"].ToString(), dr["type"].ToString())); // } // } // ddl.Items.Add(new ListItem("自定义活动", "0")); //} //#endregion //#region 绑定商品类别================================= private void WineryBind(CheckBoxList ckBox) { BLL.article_category bll = new BLL.article_category(); DataTable dt = bll.GetList(0, 2); ckBox.Items.Clear(); foreach (DataRow dr in dt.Rows) { ckBox.Items.Add(new ListItem(dr["title"].ToString(), dr["id"].ToString())); } }
public string getGoodsTypelist(int channel_id) { //select * from dbo.dt_article_category where channel_id = 2 BLL.article_category art = new BLL.article_category(); var info = art.GetList(0, channel_id); // Vincent._Json json = new _Json(); //return Convert.ToBase64String(Encoding.UTF8.GetBytes(CreateJsonParameters(info.Tables[0]))); return(CreateJsonParameters1(info)); }
//嵌套绑定 protected void rptList_ItemDataBound(object sender, RepeaterItemEventArgs e) { BLL.article_category bll = new BLL.article_category(); if (e.Item.ItemType == ListItemType.AlternatingItem || e.Item.ItemType == ListItemType.Item) { DropDownList dropDownList0 = (DropDownList)e.Item.FindControl("dropDownList0"); DropDownList dropDownList1 = (DropDownList)e.Item.FindControl("dropDownList1"); DropDownList dropDownList2 = (DropDownList)e.Item.FindControl("dropDownList2"); TextBox txtStart = (TextBox)e.Item.FindControl("txtStart"); TextBox txtEnd = (TextBox)e.Item.FindControl("txtEnd"); txtStart.Text = DateTime.Now.AddDays(-1).ToString("yyyy-MM-dd HH:mm:ss"); txtEnd.Text = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); //找到分类Repeater关联的数据项 DataRowView drv = (DataRowView)e.Item.DataItem; //提取站点ID int _channel_id = Convert.ToInt32(drv["id"]); //绑定分类 DataTable dt = bll.GetList(0, _channel_id); dropDownList0.Items.Clear(); dropDownList0.Items.Add(new ListItem("全部", "0")); dropDownList1.Items.Clear(); dropDownList1.Items.Add(new ListItem("全部", "0")); dropDownList2.Items.Clear(); dropDownList2.Items.Add(new ListItem("全部", "0")); foreach (DataRow dr in dt.Rows) { string Id = dr["id"].ToString(); int ClassLayer = int.Parse(dr["class_layer"].ToString()); string Title = dr["title"].ToString().Trim(); if (ClassLayer == 1) { dropDownList0.Items.Add(new ListItem(Title, Id)); dropDownList1.Items.Add(new ListItem(Title, Id)); dropDownList2.Items.Add(new ListItem(Title, Id)); } else { Title = "├ " + Title; Title = Utils.StringOfChar(ClassLayer - 1, " ") + Title; dropDownList0.Items.Add(new ListItem(Title, Id)); dropDownList1.Items.Add(new ListItem(Title, Id)); dropDownList2.Items.Add(new ListItem(Title, Id)); } } } }
/// <summary> /// 返回频道下所有的文章列表URL地址 /// </summary> /// <param name="lang">频道分类</param> /// <param name="channelname">频道Name</param> /// <returns>返回频道下所有的文章列表URL地址</returns> private string GetArticleUrlList(string lang, string channelname, string page, string pattern, string path, string querystring, int pagesize) { StringBuilder sburl = new StringBuilder(); DataTable dt = objarticle_category.GetList(0, channelname); if (dt != null && dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { int strLength = 0; if (!string.IsNullOrEmpty(querystring)) { strLength = querystring.Split('&').Length; } int totalCount = objarticle.GetCount(channelname, Convert.ToInt32(dt.Rows[i]["id"].ToString()), 0, ""); int pageindex = GetPageSize(totalCount, pagesize); if (strLength == 1) { pageindex = 1; } for (int q = 1; q <= pageindex; q++) { string querystr = Regex.Replace(string.Format(path, dt.Rows[i]["id"].ToString(), q), pattern, querystring, RegexOptions.None | RegexOptions.IgnoreCase); string linkurl = string.Format("{0}/{1}/{2}?{3}", PLKeys.DIRECTORY_REWRITE_ASPX, lang, page, querystr); string HTMLPattern = string.Format("{0}/{1}/{2}", PLKeys.DIRECTORY_REWRITE_HTML, lang, Utils.GetUrlExtension(string.Format(path, dt.Rows[i]["id"].ToString(), q), config.staticextension)); //替换扩展名 if (!string.IsNullOrEmpty(sburl.ToString())) { sburl.Append(","); } sburl.AppendFormat(urlstr, config.webpath, lang, linkurl.Replace("&", "^"), HTMLPattern); } } } return(sburl.ToString()); }
/// <summary> /// 取频道下的分类 /// </summary> public DataTable CategoryListByChannelName() { Tag tag = this.Document.CurrentRenderingTag; var attribute = tag.Attributes["channel_name"]; string channel_name = attribute.Text; //--=====begin: 将这个频道下的所有分类的基本信息 ====-- BLL.article_category cateDal = new BLL.article_category(); DataTable dt = cateDal.GetList(0, channel_name); return(dt); //--=====end: 将这个频道下的所有分类的基本信息 ====-- }
private void SetCategory() { if (!String.IsNullOrEmpty(this.navigation_name)) { BLL.article_category bll = new BLL.article_category(); DataTable dt = bll.GetList(0, this.channel_id); foreach (DataRow dr in dt.Rows) { if (this.navigation_name.Equals(dr["call_index"].ToString())) { this.category_id = Utils.StrToInt(dr["id"].ToString(), 0); break; } } } }
protected void Page_Load(object sender, EventArgs e) { wid = MXRequest.GetQueryInt("wid"); openid = MXRequest.GetQueryString("openid"); if (!IsPostBack) { BLL.wx_wq_wzlx wzBll = new BLL.wx_wq_wzlx(); Model.wx_wq_wzlx wzModel = wzBll.GetModelList("wid=" + wid)[0]; BLL.article_category acBll = new BLL.article_category(); DataTable ds = acBll.GetList(" wid=" + wid + " and id=" + wzModel.cxid); if (ds.Rows.Count > 0) { acModel = acBll.GetModel(MyCommFun.Obj2Int(wzModel.cxid)); } BLL.article aBll = new BLL.article(); this.rptList.DataSource = aBll.GetList(" category_id=" + acModel.id); this.rptList.DataBind(); } }
private void get_category_list(HttpContext context) { BLL.article_category bll = new BLL.article_category(); DataTable dt = bll.GetList(0, 2); string ret_str = "<option value=''>请选择类别...</option>"; if (dt != null && dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { string Id = dr["id"].ToString(); int ClassLayer = int.Parse(dr["class_layer"].ToString()); string Title = dr["title"].ToString().Trim(); if (ClassLayer == 1) { //this.ddlCategoryId.Items.Add(new ListItem(Title, Id)); ret_str += "<option value='" + Id + "'>" + Title + "</option>"; } else { Title = "├ " + Title; Title = Utils.StringOfChar(ClassLayer - 1, " ") + Title; //this.ddlCategoryId.Items.Add(new ListItem(Title, Id)); ret_str += "<option value='" + Id + "'>" + Title + "</option>"; } } } context.Response.Write(ret_str); return; }
/// <summary> /// 导航区域绑定 /// </summary> protected void BindNav() { StringBuilder strnav = new StringBuilder(); BLL.article_category bll = new BLL.article_category(); DataTable dtCategory = bll.GetList(0, 2); if (dtCategory != null && dtCategory.Rows.Count > 0) { //一级类目 DataRow[] drFirsts = dtCategory.Select(" parent_id=0 "); foreach (DataRow dr in drFirsts) { strnav.Append(@"<li class='mod_cate'>"); strnav.Append("<h2><a href='#'>" + dr["title"].ToString() + "</a></h2>"); DataRow[] drRems = dtCategory.Select(" class_list like '%," + dr["id"].ToString() + ",%' and IsRecommended='1' "); if (drRems != null && drRems.Length > 0) { strnav.Append("<p class='mod_cate_r'>"); foreach (DataRow drRem in drRems) { strnav.Append("<a href='#'>"+drRem["title"].ToString()+"</a>"); } strnav.Append("</p>"); } //推荐类目绑定 //<p class="mod_cate_r"><a href="#">计算器</a><a href="#">文件夹</a><a href="#">文件柜</a><a href="#">推荐类目</a></p> strnav.Append(@"<div class='mod_subcate'>"); strnav.Append(" <div class='mod_subcate_main'>"); strnav.Append(" <div class='inBox'>"); strnav.Append(" <div class='inHd'>"); strnav.Append(" <ul>"); //二级类目绑定 //二级类目查找 DataRow[] drSeconds = dtCategory.Select(" class_list like '%," + dr["id"].ToString() + ",%' and class_layer=2 "); if (drSeconds != null && drSeconds.Length > 0) { foreach (DataRow drSecond in drSeconds) { strnav.Append("<li>"); //<span class='s-m1'></span> strnav.Append(" <a href='#'><img src='" + drSecond["img_url"].ToString() + "' width='30px' height='30px' ></img>" + drSecond["title"].ToString() + "</a>"); strnav.Append(" </li>"); } strnav.Append("</ul>"); //活动内容待添加 strnav.Append(" </div>"); strnav.Append(" <div class='inBd'> "); strnav.Append(" <ul> "); int i = 0; foreach (DataRow drSecond in drSeconds) { DataRow[] drThirds = dtCategory.Select(" class_list like '%," + drSecond["id"].ToString() + ",%' and class_layer=3 "); if (drThirds != null && drThirds.Length > 0) { foreach (DataRow drThird in drThirds) { if (i < 24) { strnav.Append("<li>"); strnav.Append("<div class='pic'>"); strnav.Append(" <a href='#'>"); strnav.Append(" <img src='" + drThird["img_url"].ToString() + "' width='90px' height='90px'/></a>"); strnav.Append(" </div>"); strnav.Append(" <div class='title'><a href='#'>" + drThird["title"].ToString() + "</a></div>"); strnav.Append("</li>"); } i++; } } } strnav.Append("</ul>"); strnav.Append(" </div>"); strnav.Append(" </div>"); strnav.Append(" </div>"); strnav.Append(" </li>"); } } } ltNav.Text = strnav.ToString(); }
private void BindCaseType() { BLL.article_category bll = new BLL.article_category(); RepBindProType.DataSource = bll.GetList(0, 7); RepBindProType.DataBind(); }
/// <summary> /// 返回频道下所有的文章列表URL地址 /// </summary> /// <param name="lang">频道分类</param> /// <param name="channelname">频道Name</param> /// <returns>返回频道下所有的文章列表URL地址</returns> private string GetArticleUrlList(string lang, string channelname, string page, string pattern, string path, string querystring, int pagesize) { StringBuilder sburl = new StringBuilder(); int hanld = DTRequest.GetQueryInt("hanld"); int category_id = 0; if (hanld == 3) { category_id = DTRequest.GetQueryInt("lst"); } DataTable dt = objarticle_category.GetList(category_id, channelname); if (dt != null && dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { int strLength = 0; if (!string.IsNullOrEmpty(querystring)) { strLength = querystring.IndexOf("page"); } int totalCount = objarticle.ArticleCount(channelname, Convert.ToInt32(dt.Rows[i]["id"].ToString()), ""); int pageindex = GetPageSize(totalCount, pagesize); if (strLength < 0) { pageindex = 1; } bool status = false; if (querystring.IndexOf("call_index") > -1) { status = true; } for (int q = 1; q <= pageindex; q++) { string strvalue = dt.Rows[i]["call_index"].ToString(); if (status) { if (string.IsNullOrWhiteSpace(strvalue)) { continue; } } else if (!string.IsNullOrWhiteSpace(strvalue)) { continue; } else { strvalue = dt.Rows[i]["id"].ToString(); } string querystr = Regex.Replace(string.Format(path, strvalue, q), pattern, querystring, RegexOptions.None | RegexOptions.IgnoreCase); string linkurl = string.Format("{0}/{1}/{2}?{3}", DTKeys.DIRECTORY_REWRITE_MVC, lang, page, querystr); string HTMLPattern = string.Format("{0}/{1}/{2}", DTKeys.DIRECTORY_REWRITE_HTML, lang, Utils.GetUrlExtension(string.Format(path, strvalue, q), config.staticextension)); //替换扩展名 if (!string.IsNullOrEmpty(sburl.ToString())) { sburl.Append(","); } sburl.AppendFormat(urlstr, config.webpath, lang, linkurl.Replace("&", "^"), HTMLPattern); } } } return(sburl.ToString()); }
private void get_prop_page(HttpContext context) { try { StringBuilder strhtml = new StringBuilder(); int category = DTRequest.GetFormInt("category", 0); int page = DTRequest.GetFormInt("page", 1); BLL.property pro = new BLL.property(); BLL.property_value pro_value = new BLL.property_value(); BLL.article_category catgory = new BLL.article_category(); string category_ids = ""; DataTable dt_pro = null; if (category == 0) dt_pro = pro.GetList("").Tables[0]; else { DataTable cat_dt = catgory.GetList(0, 2, category.ToString());//查找类别下的所有类别 if (cat_dt.Rows.Count > 0) { for (int i = 0; i < cat_dt.Rows.Count; i++) { category_ids += cat_dt.Rows[i][0].ToString() + ","; } category_ids = category_ids.Substring(0, category_ids.Length - 1); } dt_pro = pro.GetList("category_id in(" + category_ids + ")").Tables[0]; } if (dt_pro.Rows.Count > 0) { for (int i = 0; i < dt_pro.Rows.Count; i++) { strhtml.Append("<dl>"); strhtml.Append("<dt>" + dt_pro.Rows[i]["title"] + "</dt>"); DataTable dt_pro_value = pro_value.GetList("property_id='" + dt_pro.Rows[i][0] + "'").Tables[0]; if (dt_pro_value.Rows.Count > 0) { for (int j = 0; j < dt_pro_value.Rows.Count; j++) { strhtml.Append("<dd><a style=\"cursor:pointer;\" onclick='getpagedata(" + dt_pro_value.Rows[j][0] + "," + category + "," + page + ")'>" + dt_pro_value.Rows[j]["value"] + "</a><span></span></dd>"); } } strhtml.Append("</dl>"); } context.Response.Write("{ \"info\":\"获取数据成功!\", \"status\":\"1\" ,\"html\":\"" + myJson.String2Json(strhtml.ToString()) + "\",\"pagelist\":\"\"}"); return; } context.Response.Write("{ \"info\":\"该类别暂未添加属性!\", \"status\":\"0\" }"); } catch (Exception ex) { context.Response.Write("{ \"info\":\"该类别暂未添加属性!\", \"status\":\"0\" }"); return; } }
private void get_category(HttpContext context) { int parent_category = DTRequest.GetQueryInt("category_id"); BLL.article_category bll = new BLL.article_category(); DataTable dt = bll.GetList(parent_category, "goods"); if (dt != null && dt.Rows.Count > 0) { context.Response.Write(myJson.getJson(dt)); return; } else { context.Response.Write("Null"); return; } }
private void BindMenu() { BLL.article_category bll = new BLL.article_category(); RepMenuList.DataSource = bll.GetList(0, 7); RepMenuList.DataBind(); }
/// <summary> /// 导航区域绑定 /// </summary> protected void BindNav() { StringBuilder strnav = new StringBuilder(); BLL.article_category bll = new BLL.article_category(); DataTable dtCategory = bll.GetList(0, 2); if (dtCategory != null && dtCategory.Rows.Count > 0) { //一级类目 DataRow[] drFirsts = dtCategory.Select(" parent_id=0 "); foreach (DataRow dr in drFirsts) { strnav.Append(@"<li class='mod_cate'>"); strnav.Append("<h2><a href='#'>" + dr["title"].ToString() + "</a></h2>"); DataRow[] drRems = dtCategory.Select(" class_list like '%," + dr["id"].ToString() + ",%' and IsRecommended='1' "); if (drRems != null && drRems.Length > 0) { strnav.Append("<p class='mod_cate_r'>"); foreach (DataRow drRem in drRems) { strnav.Append("<a href='#'>" + drRem["title"].ToString() + "</a>"); } strnav.Append("</p>"); } //推荐类目绑定 //<p class="mod_cate_r"><a href="#">计算器</a><a href="#">文件夹</a><a href="#">文件柜</a><a href="#">推荐类目</a></p> strnav.Append(@"<div class='mod_subcate'>"); strnav.Append(" <div class='mod_subcate_main'>"); strnav.Append(" <div class='inBox'>"); strnav.Append(" <div class='inHd'>"); strnav.Append(" <ul>"); //二级类目绑定 //二级类目查找 DataRow[] drSeconds = dtCategory.Select(" class_list like '%," + dr["id"].ToString() + ",%' and class_layer=2 "); if (drSeconds != null && drSeconds.Length > 0) { foreach (DataRow drSecond in drSeconds) { strnav.Append("<li>"); //<span class='s-m1'></span> strnav.Append(" <a href='#'><img src='" + drSecond["img_url"].ToString() + "' width='30px' height='30px' ></img>" + drSecond["title"].ToString() + "</a>"); strnav.Append(" </li>"); } strnav.Append("</ul>"); //活动内容待添加 strnav.Append(" </div>"); strnav.Append(" <div class='inBd'> "); strnav.Append(" <ul> "); int i = 0; foreach (DataRow drSecond in drSeconds) { DataRow[] drThirds = dtCategory.Select(" class_list like '%," + drSecond["id"].ToString() + ",%' and class_layer=3 "); if (drThirds != null && drThirds.Length > 0) { foreach (DataRow drThird in drThirds) { if (i < 24) { strnav.Append("<li>"); strnav.Append("<div class='pic'>"); strnav.Append(" <a href='#'>"); strnav.Append(" <img src='" + drThird["img_url"].ToString() + "' width='90px' height='90px'/></a>"); strnav.Append(" </div>"); strnav.Append(" <div class='title'><a href='#'>" + drThird["title"].ToString() + "</a></div>"); strnav.Append("</li>"); } i++; } } } strnav.Append("</ul>"); strnav.Append(" </div>"); strnav.Append(" </div>"); strnav.Append(" </div>"); strnav.Append(" </li>"); } } } ltNav.Text = strnav.ToString(); }
/// <summary> /// 取频道下的分类 /// </summary> public DataTable CategoryListByChannelName() { Tag tag = this.Document.CurrentRenderingTag; var attribute = tag.Attributes["channel_name"]; string channel_name = attribute.Text; //--=====begin: 将这个频道下的所有分类的基本信息 ====-- BLL.article_category cateDal = new BLL.article_category(); DataTable dt = cateDal.GetList(0, channel_name); return dt; //--=====end: 将这个频道下的所有分类的基本信息 ====-- }