public void NewBind() { WebSite.BLL.Bll_BaseType BBaseType = new WebSite.BLL.Bll_BaseType(); String strWhere = String.Empty; DataTable dt = new DataTable(); strWhere = " State=1 AND ParentID =" + ParentId + " AND WebSiteID=" + PageCommon.LanguageID; List <WebSite.Model.Mod_BaseType> MBaseType = new List <WebSite.Model.Mod_BaseType>(); dt = BBaseType.GetList(strWhere + " ORDER BY OrderBy DESC,ID asc").Tables[0]; stylehtml = dt.Rows.Count.ToString(); for (int i = 0; i < dt.Rows.Count; i++) { if (dt.Rows[i]["Link"].ToString() != "") { LeftHtml += GetHref(dt.Rows[i]["Link"].ToString(), dt.Rows[i]["Title"].ToString(), dt.Rows[i]["ID"].ToString()); } else { switch (dt.Rows[i]["Model"].ToString()) { case "DTSQ": LeftHtml += "<li " + GetClass(dt.Rows[i]["ID"].ToString()) + " hsm=\"fadel\"><a href=\"NewsList.aspx?TypeId=" + dt.Rows[i]["ID"].ToString() + "\" " + GetClass(dt.Rows[i]["ID"].ToString()) + ">" + dt.Rows[i]["Title"].ToString() + "</a></li>"; break; case "CPXX": LeftHtml += "<li " + GetClass(dt.Rows[i]["ID"].ToString()) + " hsm=\"fadel\"><a href=\"ProductList.aspx?TypeId=" + dt.Rows[i]["ID"].ToString() + "\" " + GetClass(dt.Rows[i]["ID"].ToString()) + ">" + dt.Rows[i]["Title"].ToString() + "</a></li>"; break; default: LeftHtml += "<li " + GetClass(dt.Rows[i]["ID"].ToString()) + " hsm=\"fadel\"><a href=\"about.aspx?TypeId=" + dt.Rows[i]["ID"].ToString() + "\" >" + dt.Rows[i]["Title"].ToString() + "</a></li>"; break; } } } }
public void NewBind() { WebSite.BLL.Bll_BaseType BBaseType = new WebSite.BLL.Bll_BaseType(); String strWhere = String.Empty; DataTable dt = new DataTable(); //strWhere = " State=1 AND WebSiteID=10001 AND ParentID=0 and Model ='" + Model + "'"; strWhere = " State=1 AND ParentID =" + ParentId; List <WebSite.Model.Mod_BaseType> MBaseType = new List <WebSite.Model.Mod_BaseType>(); dt = BBaseType.GetList(0, strWhere, "OrderBy asc,id asc").Tables[0]; for (int i = 0; i < dt.Rows.Count; i++) { if (dt.Rows[i]["Link"].ToString() != "") { LeftHtml += GetHref(dt.Rows[i]["Link"].ToString(), dt.Rows[i]["Title"].ToString(), dt.Rows[i]["ID"].ToString()); } else { switch (dt.Rows[i]["Model"].ToString()) { case "News": LeftHtml += "<a href=\"News.aspx?TypeId=" + dt.Rows[i]["ID"].ToString() + "\" " + GetClass(dt.Rows[i]["ID"].ToString()) + ">" + dt.Rows[i]["Title"].ToString() + "</a>"; break; case "Product": LeftHtml += "<a href=\"ProductList.aspx?TypeId=" + dt.Rows[i]["ID"].ToString() + "\" " + GetClass(dt.Rows[i]["ID"].ToString()) + " >" + dt.Rows[i]["Title"].ToString() + "</a>"; break; default: LeftHtml += "<a href=\"about.aspx?TypeId=" + dt.Rows[i]["ID"].ToString() + "\" " + GetClass(dt.Rows[i]["ID"].ToString()) + ">" + dt.Rows[i]["Title"].ToString() + "</a>"; break; } } } }
public string NewBind(string ParentId) { string LeftHtml = string.Empty; WebSite.BLL.Bll_BaseType BBaseType = new WebSite.BLL.Bll_BaseType(); String strWhere = String.Empty; DataTable dt = new DataTable(); strWhere = " ID!=10147 AND State=1 AND ParentID =" + ParentId + " AND WebSiteID=" + PageCommon.LanguageID; WebSite.Model.Mod_BaseType MBaseType = PageCommon.GetModelType(ParentId); if (MBaseType == null) { return(""); } dt = BBaseType.GetList(strWhere + " order by OrderBy desc,ID asc ").Tables[0]; LeftHtml = "<li><a href=\"" + MBaseType.Link + "\" " + GetClass(MBaseType.ID.ToString()) + ">" + MBaseType.Title + "</a>"; if (dt.Rows.Count > 1) { LeftHtml += "<div class=\"sub-nav abs\">"; for (int i = 0; i < dt.Rows.Count; i++) { if (dt.Rows[i]["Link"].ToString() != "") { LeftHtml += "<a href=\"" + dt.Rows[i]["Link"].ToString() + "\" class=\"db\">" + dt.Rows[i]["Title"].ToString() + "</a>"; } else { switch (dt.Rows[i]["Model"].ToString()) { case "DTSQ": LeftHtml += "<a href=\"NewsList.aspx?TypeId=" + dt.Rows[i]["ID"].ToString() + "\" class=\"db\">" + dt.Rows[i]["Title"].ToString() + "</a>"; break; case "CPXX": LeftHtml += "<a href=\"ProductList.aspx?TypeId=" + dt.Rows[i]["ID"].ToString() + "\" class=\"db\" >" + dt.Rows[i]["Title"].ToString() + "</a>"; break; default: LeftHtml += "<a href=\"about.aspx?TypeId=" + dt.Rows[i]["ID"].ToString() + "\" class=\"db\" >" + dt.Rows[i]["Title"].ToString() + "</a>"; break; } } } LeftHtml += "</div>"; } LeftHtml += "</li>"; return(LeftHtml); }
public string NewBind(string ParentId) { string LeftHtml = string.Empty; WebSite.BLL.Bll_BaseType BBaseType = new WebSite.BLL.Bll_BaseType(); String strWhere = String.Empty; DataTable dt = new DataTable(); strWhere = " ID!=10147 AND State=1 AND ParentID =" + ParentId + " AND WebSiteID=" + PageCommon.LanguageID; WebSite.Model.Mod_BaseType MBaseType = PageCommon.GetModelType(ParentId); if (MBaseType == null) { return(""); } dt = BBaseType.GetList(strWhere + " order by OrderBy desc,ID asc ").Tables[0]; LeftHtml = "<dl class=\"fl\"><dt><a href=\"" + MBaseType.Link + "\">" + MBaseType.Title + "</a></dt>"; if (dt.Rows.Count > 1) { LeftHtml += "<div class=\"gdlt\">"; for (int i = 0; i < dt.Rows.Count; i++) { if (dt.Rows[i]["Link"].ToString() != "") { LeftHtml += "<dd><a href=\"" + dt.Rows[i]["Link"].ToString() + "\">" + dt.Rows[i]["Title"].ToString() + "</a></dt>"; } else { switch (dt.Rows[i]["Model"].ToString()) { case "CPHZZ": LeftHtml += "<dd><a href=\"ProductList.aspx?TypeId=" + dt.Rows[i]["ID"].ToString() + "\" >" + dt.Rows[i]["Title"].ToString() + "</a></dt>"; break; case "XTHJJFA": LeftHtml += "<dd><a href=\"Solution.aspx?TypeId=" + dt.Rows[i]["ID"].ToString() + "\" >" + dt.Rows[i]["Title"].ToString() + "</a></dt>"; break; case "KJDZ": LeftHtml += "<dd><a href=\"Custom.aspx#" + dt.Rows[i]["ID"].ToString() + "\" >" + dt.Rows[i]["Title"].ToString() + "</a></dt>"; break; default: LeftHtml += "<dd><a href=\"about.aspx?TypeId=" + dt.Rows[i]["ID"].ToString() + "\" >" + dt.Rows[i]["Title"].ToString() + "</a></dt>"; break; } } } } LeftHtml += "</dl>"; return(LeftHtml); }
private void DdlstTypeNameBind() { WebSite.BLL.Bll_BaseType BBaseType = new WebSite.BLL.Bll_BaseType(); string strWhere = " WebSiteID=" + AdminManage.WebSiteID + " "; ddlstTypeName.Items.Clear(); ListItem li = new ListItem("一级栏目", "0"); ddlstTypeName.Items.Add(li); DataSet ds = BBaseType.GetList(strWhere); if (ds != null && ds.Tables.Count > 0) { DataTable dt = ds.Tables[0]; GetTree(ddlstTypeName, dt, 0, 0); } }