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); }
protected void Page_Load(object sender, EventArgs e) { ModelInfo = PageCommon.GetModelInformation(id); ModelBaseType = PageCommon.GetModelType(ModelInfo.TypeID); string ObjIDPath = ModelBaseType.IDPath; TopNavigation1.ObjIDPath = ObjIDPath; ucLeft1.TypeId = ObjIDPath.Split(',')[1].ToString(); ucLeft1.ParentId = ObjIDPath.Split(',')[0].ToString(); MBaseType = PageCommon.GetModelType(int.Parse(ObjIDPath.Split(',')[0].ToString())); //if (ModelBaseType.Image != "") //{ // MBaseType.Image = ModelBaseType.Image; //} _ucheader1.ParentID = ObjIDPath.Split(',')[0].ToString(); _ucheader1.TypeId = ModelBaseType.ID.ToString(); //统计浏览量 OperateHelper.SetInformationClick(ModelInfo.ID); Bll_PicList BPicList = new Bll_PicList(); //绑定图片集 PicList = BPicList.GetModelList("Model='XWXC' and ProductID=" + id + " and State=1 AND WebSiteID=" + PageCommon.LanguageID + " ORDER BY OrderBy asc,ID asc "); //上一页下一页 Mod_Information dto2 = GetInfo.GetLastInfo(ModelInfo, "OrderBy desc,AddDate DESC", string.Format("TypeID={0} And Model='{1}' and WebSiteID={2}", ModelInfo.TypeID, ModelInfo.Model, PageCommon.LanguageID)); if (dto2 != null) { LastInfo = "<div><strong>上一篇:</strong><a href=\"NewsInfo.aspx?id=" + dto2.ID + "\" class=\"els\">" + dto2.Title + "</a></div>"; } else { LastInfo = "<div><strong>上一篇:</strong><a class=\"els\">没有了</a></div>"; } Mod_Information dto3 = GetInfo.GetNextInfo(ModelInfo, "OrderBy desc,AddDate DESC", string.Format("TypeID={0} And Model='{1}' and WebSiteID={2}", ModelInfo.TypeID, ModelInfo.Model, PageCommon.LanguageID)); if (dto3 != null) { NextInfo = "<div><strong>下一篇:</strong><a href=\"NewsInfo.aspx?id=" + dto3.ID + "\" class=\"els\">" + dto3.Title + "</a></div>"; } else { NextInfo = "<div><strong>下一篇:</strong><a class=\"els\">没有了</a></div>"; } LinkBind(); }
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); }
protected void Page_Load(object sender, EventArgs e) { modWebSite = OperateHelper.GetWebSite(int.Parse(PageCommon.LanguageID)); TypeId = DNTRequest.GetQueryInt("TypeId", 10147); ModelBaseType = PageCommon.GetModelType(TypeId); string ObjIDPath = ModelBaseType.IDPath; TopNavigation1.ObjIDPath = ObjIDPath; MBaseType = PageCommon.GetModelType(int.Parse(ObjIDPath.Split(',')[0].ToString())); ucLeft1.TypeId = ObjIDPath.Split(',')[1].ToString(); ucLeft1.ParentId = ObjIDPath.Split(',')[0].ToString(); _ucheader1.ParentID = ObjIDPath.Split(',')[0].ToString(); string strWhere = "WebSiteID=" + PageCommon.LanguageID + " and State='1' and IDPath like '%" + TypeId + "%'"; ModelList = BInformation.GetModelList(int.MaxValue, strWhere + " ORDER BY OrderBy desc,AddDate desc"); foreach (var item in ModelList) { trackPoints += "new google.maps.LatLng(" + item.Author + ")"; trackAddress += "\"" + item.Title + "\""; if ((ModelList.IndexOf(item) + 1) != ModelList.Count) { trackAddress += ","; trackPoints += ","; } if (ModelList.IndexOf(item) == 0) { myOptions = item.Author; } } Bll_Link BLink = new Bll_Link(); strWhere = string.Format(" Model='{0}' and State=1 and WebSiteID={1} ", "QTLJ", PageCommon.LanguageID); string txtOrder = " IsTop Desc, OrderBy Desc, AddDate ASC "; AdbannerList = BLink.GetModelList(int.MaxValue, strWhere, txtOrder); }
public static int GetParentId(int TypeId) { string strPath = string.Empty; WebSite.BLL.Bll_BaseType GetInfo = new WebSite.BLL.Bll_BaseType(); WebSite.Model.Mod_BaseType modBaseType = PageCommon.GetModelType(TypeId); if (modBaseType == null) { return(0); } string ObjIDPath = modBaseType.IDPath; string[] arrIDPath = ObjIDPath.ToString().Split(','); return(StringHelper.StrToInt(arrIDPath[0], 0)); }
public static string GetTypePath(int TypeId) { string strPath = string.Empty; WebSite.BLL.Bll_BaseType GetInfo = new WebSite.BLL.Bll_BaseType(); WebSite.Model.Mod_BaseType modBaseType = PageCommon.GetModelType(TypeId); if (modBaseType == null) { return("<span>></span><p>Product</p>"); } string ObjIDPath = modBaseType.IDPath; string[] arrIDPath = ObjIDPath.ToString().Split(','); WebSite.Model.Mod_BaseType ModelInfo = new WebSite.Model.Mod_BaseType(); for (int i = 0; i < arrIDPath.Length; i++) { ModelInfo = PageCommon.GetModelType(arrIDPath[i]); string strLink = string.Empty; if ((i + 1) == arrIDPath.Length) { strPath += " <span>></span><p>" + ModelInfo.Title + "</p>"; } else { if (i == 0) { strPath += " <span>></span><p ><a href=\"/ProductIndex.aspx?TypeId=" + ModelInfo.ID + "\" style=\"color:#000\">" + ModelInfo.Title + "</a></p>"; } else { strPath += " <span>></span><p ><a href=\"/ProductList.aspx?TypeId=" + ModelInfo.ID + "\" style=\"color:#000\">" + ModelInfo.Title + "</a></p>"; } } } return(strPath); }
protected void btnEdit_Click(object sender, EventArgs e) { if (txtTitle.Text.Trim() == "") { MessageBox.Show(this, "请填写完整信息再提交保存"); return; } Mod_AdminMenu dto = new Mod_AdminMenu(); string ParentIDStr = string.Empty; string IDPathStr = string.Empty; string strtype = string.Empty; if (id != 0) { dto = BAdmin_Menu.GetModel(id); strtype = dto.TypeName; ParentIDStr = dto.ParentID.ToString(); IDPathStr = dto.IDPath; } dto.Title = txtTitle.Text.Trim(); dto.ParentID = int.Parse(ddlMenu.SelectedValue); dto.State = int.Parse(rblState.SelectedValue); dto.IsCopy = int.Parse(rblIsCopy.SelectedValue); dto.Url = txtUrl.Text.Trim(); dto.OrderBy = int.Parse(txtOrderBy.Text.Trim()); dto.WebSiteID = int.Parse(ddlWebSite.SelectedValue); dto.FunctionModel = FunctionModel.Text; dto.TypeName = ddlstTypeName.SelectedValue; dto.WebSiteManage = ddlWebSiteManage.SelectedValue; dto.Attributes = GetChecked(this.cblShow, ","); string parameter = string.Empty; for (int i = 0; i < cblShow.Items.Count; i++) { if (cblShow.Items[i].Selected) { parameter += "&" + cblShow.Items[i].Value + "=1"; } } if (id != 0) { string strHref = string.Empty; switch (ddlWebSiteManage.SelectedValue) { case "Type": //分类管理 strHref = "Column/BaseType/List.aspx?Model={0}&IsAdd=1" + parameter; dto.Url = string.Format(strHref, FunctionModel.Text); break; case "About": //单篇文章 if (strtype != dto.TypeName) { strHref = "Column/About/Edit.aspx?ID={1}" + parameter; WebSite.BLL.Bll_BaseType BBaseType = new WebSite.BLL.Bll_BaseType(); WebSite.BLL.Bll_Information BInformation = new WebSite.BLL.Bll_Information(); WebSite.Model.Mod_Information MInformation = new WebSite.Model.Mod_Information(); WebSite.Model.Mod_BaseType MBaseType = new WebSite.Model.Mod_BaseType(); MBaseType = BBaseType.GetModel(string.Format("ID={0} AND WebSiteID={1}", this.ddlstTypeName.SelectedValue, AdminManage.WebSiteID)); MInformation.Title = MBaseType.Title; MInformation.TypeID = int.Parse(ddlstTypeName.SelectedItem.Value); MInformation.State = 1; MInformation.Content1 = MBaseType.Title; MInformation.Model = MBaseType.Model.ToString(); MInformation.WebSiteID = AdminManage.WebSiteID; MInformation.AddDate = DateTime.Now; int flag = BInformation.Add(MInformation); MInformation.ID = flag; BInformation.Update(MInformation); dto.Url = string.Format(strHref, MInformation.Model, flag); } else { dto.Url = dto.Url.Split('&')[0] + parameter; } break; case "News": //文字新闻 strHref = "Column/Information/List.aspx?Model={0}&managetype={1}" + parameter; dto.Url = string.Format(strHref, FunctionModel.Text, ddlstTypeName.SelectedValue); break; case "Link": //友情链接 strHref = "Column/Link/List.aspx?Model={0}" + parameter; dto.Url = string.Format(strHref, FunctionModel.Text); break; } BAdmin_Menu.Update(dto, true); } else { string strHref = string.Empty; switch (ddlWebSiteManage.SelectedValue) { case "Type": //分类管理 strHref = "Column/BaseType/List.aspx?Model={0}&IsAdd=1" + parameter; dto.Url = string.Format(strHref, FunctionModel.Text); break; case "About": //单篇文章 strHref = "Column/About/Edit.aspx?ID={1}" + parameter; WebSite.BLL.Bll_BaseType BBaseType = new WebSite.BLL.Bll_BaseType(); WebSite.BLL.Bll_Information BInformation = new WebSite.BLL.Bll_Information(); WebSite.Model.Mod_Information MInformation = new WebSite.Model.Mod_Information(); WebSite.Model.Mod_BaseType MBaseType = new WebSite.Model.Mod_BaseType(); MBaseType = BBaseType.GetModel(string.Format("ID={0} AND WebSiteID={1}", this.ddlstTypeName.SelectedValue, AdminManage.WebSiteID)); MInformation.Title = MBaseType.Title; MInformation.TypeID = int.Parse(ddlstTypeName.SelectedItem.Value); MInformation.State = 1; MInformation.Content1 = MBaseType.Title; MInformation.Model = MBaseType.Model.ToString(); MInformation.WebSiteID = AdminManage.WebSiteID; MInformation.AddDate = DateTime.Now; int flag = BInformation.Add(MInformation); MInformation.ID = flag; BInformation.Update(MInformation); dto.Url = string.Format(strHref, MInformation.Model, flag); break; case "News": //文字新闻 strHref = "Column/Information/List.aspx?Model={0}&managetype={1}" + parameter; dto.Url = string.Format(strHref, FunctionModel.Text, ddlstTypeName.SelectedValue); break; case "Link": //友情链接 strHref = "Column/Link/List.aspx?Model={0}" + parameter; dto.Url = string.Format(strHref, FunctionModel.Text); break; } BAdmin_Menu.Add(dto, true); } MessageBox.ShowRedirect(this, "信息(" + txtTitle.Text.Trim() + ")保存成功!", "Column/Admin_Menu/List.aspx?" + StringHelper.DelUrlParameter("ID")); }
protected void btnEdit_Click(object sender, EventArgs e) { if (txtTitle.Text.Trim() == "") { MessageBox.Show(this, "带*的是必须项或是必选项,请填写完整再提交保存!"); return; } if (id != 0) { WebSite.Model.Mod_BaseType dto = new WebSite.Model.Mod_BaseType(); dto = BBaseType.GetModel(string.Format("ID={0} AND WebSiteID={1}", id, AdminManage.WebSiteID)); dto.ParentID = int.Parse(ddlBaseType.SelectedValue); dto.Model = txtModel.Text.Trim(); dto.Title = txtTitle.Text.Trim(); dto.Image = txtImage.Text.Trim(); dto.FileURl = txtFileURl.Text.Trim(); dto.OrderBy = int.Parse(txtOrderBy.Text.Trim()); dto.State = int.Parse(rblState.SelectedValue); dto.IsAdmin = int.Parse(rblIsAdmin.SelectedValue); dto.DisplayMode = int.Parse(rblDisplayMode.SelectedValue); dto.IsRecommend = int.Parse(rblIsRecommend.SelectedValue); dto.IsUser = int.Parse(rblIsUser.SelectedValue); dto.IsUser = int.Parse(rblIsUser.SelectedValue); dto.IncludeType = txtIncludeType.Text.Trim(); dto.Link = txtLink.Text.Trim(); dto.Info = txtInfo.Text.Trim(); dto.Content = txtContent.Text.Trim(); dto.WebSiteID = AdminManage.WebSiteID; BBaseType.Update(dto, true); if (dto.ParentID == 0) { dto.IDPath = dto.ID.ToString(); } else { dto.IDPath = BBaseType.GetModel(string.Format("ID={0} AND WebSiteID={1}", dto.ParentID, AdminManage.WebSiteID)).IDPath + "," + dto.ID; } BBaseType.Update(dto, true); //操作图片集 Dal_PicList DPicList = new Dal_PicList(); DPicList.OperateList(SetPicList(), dto.ID, AdminManage.WebSiteID, false); } else { WebSite.Model.Mod_BaseType dto = new WebSite.Model.Mod_BaseType(); dto.Title = txtTitle.Text.Trim(); dto.Image = txtImage.Text.Trim(); dto.FileURl = txtFileURl.Text.Trim(); //添加新数据 string[] titleArr = dto.Title.Split("|".ToCharArray(), StringSplitOptions.RemoveEmptyEntries); for (int i = 0; i < titleArr.Length; i++) { if (titleArr[i] == "") { continue; } dto.Title = titleArr[i]; dto.IncludeType = txtIncludeType.Text.Trim(); dto.Link = txtLink.Text.Trim(); dto.Info = txtInfo.Text.Trim(); dto.ParentID = int.Parse(ddlBaseType.SelectedValue); dto.State = int.Parse(rblState.SelectedValue); dto.IsAdmin = int.Parse(rblIsAdmin.SelectedValue); dto.DisplayMode = int.Parse(rblDisplayMode.SelectedValue); dto.IsRecommend = int.Parse(rblIsRecommend.SelectedValue); dto.IsUser = int.Parse(rblIsUser.SelectedValue); dto.Content = txtContent.Text.Trim(); dto.OrderBy = int.Parse(txtOrderBy.Text.Trim()); dto.WebSiteID = AdminManage.WebSiteID; dto.Model = txtModel.Text.Trim(); dto.AddDate = DateTime.Now; dto.UID = BBaseType.Add(dto, true); dto.ID = dto.UID; if (dto.ParentID == 0) { dto.IDPath = dto.ID.ToString(); } else { dto.IDPath = BBaseType.GetModel(string.Format("ID={0} AND WebSiteID={1}", dto.ParentID, AdminManage.WebSiteID)).IDPath + "," + dto.ID; } BBaseType.Update(dto, true); //操作图片集 Dal_PicList DPicList = new Dal_PicList(); DPicList.OperateList(SetPicList(), dto.ID, AdminManage.WebSiteID, false); } } MessageBox.ShowRedirect(this, "信息(" + txtTitle.Text.Trim() + ")保存成功!", "Column/BaseType/List.aspx?" + StringHelper.DelUrlParameter("ID")); }