//获取分类下拉列表 private void bindKnowledgeCategory() { try { int qCount; int parentParentId = -1; DataTable dtkc = new DataTable(); if (KLType == "0") { Entities.QueryKnowledgeLib queryM = new QueryKnowledgeLib(); queryM.KLID = int.Parse(KLID); dtkc = BLL.KnowledgeLib.Instance.GetKnowledgeLib(queryM, "", 1, 1, out qCount); } else if (KLType == "1") { Entities.QueryKLFAQ queryF = new QueryKLFAQ(); queryF.KLID = int.Parse(KLID); dtkc = BLL.KLFAQ.Instance.GetKLFAQ(queryF, "", 1, 1, out qCount); } if (dtkc != null && dtkc.Rows.Count > 0) { KnowledgeCategory categoryEntity = BLL.KnowledgeCategory.Instance.GetKnowledgeCategory(int.Parse(dtkc.Rows[0]["KCID"].ToString())); KCid = categoryEntity.KCID; KCPid = categoryEntity.Pid.Value; KLPLevel = categoryEntity.Level.Value; if (KCid != 0) { KnowledgeCategory categoryEntityPP = BLL.KnowledgeCategory.Instance.GetKnowledgeCategory(KCPid); parentParentId = categoryEntityPP.Pid.Value; } } Entities.QueryKnowledgeCategory query = new Entities.QueryKnowledgeCategory(); //query.Level = 1; if (parentParentId != -1) { query.Pid = parentParentId; } else { query.Pid = 0; } query.Regionid = RegionID; int count; DataTable dt = BLL.KnowledgeCategory.Instance.GetKnowledgeCategory(query, "", 1, 10000, out count); selKCID1.DataSource = dt; selKCID1.DataTextField = "Name"; selKCID1.DataValueField = "KCID"; selKCID1.DataBind(); selKCID1.Items.Insert(0, new ListItem() { Text = "请选择", Value = "-1" }); } catch (Exception ex) { BLL.Loger.Log4Net.Error("异常:" + ex.Message); } }
public DataTable BindChildrenCategoryInfo(Entities.QueryKnowledgeCategory query) { DataTable dt = new DataTable(); //同一个父节点下的孩子节点排序 string strSelect = "SELECT parentName = ISNULL((SELECT name FROM KnowledgeCategory WHERE KCID=aa.Pid),'') " + ",aa.Name,aa.Status,aa.KCID,Pid,ISNULL(aa.SortNum,-1) AS SortNum " + "FROM KnowledgeCategory aa " + "WHERE aa.Status<>-1 AND aa.pid='" + query.Pid + "' AND aa.Level='" + query.Level + "'"; if (!string.IsNullOrEmpty(query.Name)) { strSelect += " and aa.name like '%" + StringHelper.SqlFilter(query.Name) + "%'"; } strSelect += " ORDER BY ISNULL(aa.SortNum,99999),aa.KCID"; using (SqlConnection conn = new SqlConnection(CONNECTIONSTRINGS)) { conn.Open(); SqlDataAdapter adp = new SqlDataAdapter(strSelect, conn); adp.Fill(dt); } return(dt); }
/// <summary> /// 根据父分类id和级别,获取下级子分类下拉列表信息 /// </summary> /// <param name="RequestLevel">级别</param> /// <param name="RequestKCID">父类别Id</param> /// <param name="msg"></param> public void BindKnowledgeCategory(string RequestLevel, string RequestKCID, int Regionid, out string msg) { msg = string.Empty; int kcid; int level; if (int.TryParse(RequestKCID, out kcid) && int.TryParse(RequestLevel, out level)) { Entities.QueryKnowledgeCategory query = new Entities.QueryKnowledgeCategory(); query.Level = level; query.Pid = kcid; query.Regionid = Regionid; DataTable dt = new DataTable();; dt = Dal.KnowledgeCategory.Instance.BindKnowledgeCategory(query); if (dt.Rows.Count > 0) { msg += "{root:["; } for (int i = 0; i < dt.Rows.Count; i++) { msg += "{name:'" + dt.Rows[i]["Name"].ToString() + "',kcid:'" + dt.Rows[i]["KCID"].ToString() + "'},"; } if (dt.Rows.Count > 0) { msg = msg.TrimEnd(',') + "]}"; } } }
public DataTable BindKnowledgeCategory(Entities.QueryKnowledgeCategory query) { DataTable dt = new DataTable(); //同一个父节点下的孩子节点排序 string strSelect = "SELECT * FROM KnowledgeCategory WHERE Status<>-1 AND pid='" + query.Pid + "' AND Level='" + query.Level + "' " + "ORDER BY ISNULL(SortNum,99999),KCID"; using (SqlConnection conn = new SqlConnection(CONNECTIONSTRINGS)) { conn.Open(); SqlDataAdapter adp = new SqlDataAdapter(strSelect, conn); adp.Fill(dt); } return(dt); }
/// <summary> /// 根据父分类id和级别,获取子分类详细信息 /// </summary> /// <param name="msg"></param> public void BindChildrenCategoryInfo(string RequestKCID, string RequestLevel, string RequestName, int Regionid, out string msg) { msg = string.Empty; int kcid; int level; if (int.TryParse(RequestKCID, out kcid) && int.TryParse(RequestLevel, out level)) { Entities.QueryKnowledgeCategory query = new Entities.QueryKnowledgeCategory(); query.Level = level; query.Pid = kcid; query.Name = RequestName; query.Regionid = Regionid; DataTable dt = new DataTable();; dt = Dal.KnowledgeCategory.Instance.BindChildrenCategoryInfo(query); if (dt.Rows.Count > 0) { msg += "{root:["; } for (int i = 0; i < dt.Rows.Count; i++) { msg += "{name:'" + dt.Rows[i]["Name"].ToString() + "',kcid:'" + dt.Rows[i]["KCID"].ToString() + "',status:'" + dt.Rows[i]["Status"].ToString() + "',parentName:'" + dt.Rows[i]["parentName"].ToString() + "',sortnum:'" + dt.Rows[i]["SortNum"].ToString() + "'},"; } if (dt.Rows.Count > 0) { msg = msg.TrimEnd(',') + "]}"; } #region //if (string.IsNullOrEmpty(RequestName)) //{ // if (dt.Rows.Count <= 0) // { // #region 查询数据 // string strSelect2 = "SELECT parentName = ISNULL((SELECT name FROM KnowledgeCategory WHERE KCID=aa.Pid),'') " + // ",aa.Name,aa.Status,aa.KCID,Pid " + // "FROM KnowledgeCategory aa " + // "WHERE aa.Status<>-1 AND aa.kcid='" + kcid + "' AND aa.Level='" + (level - 1) + "' "; // using (SqlConnection conn2 = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionStrings_CC"].ToString())) // { // conn2.Open(); // SqlDataAdapter adp2 = new SqlDataAdapter(strSelect2, conn2); // adp2.Fill(dt); // } // #endregion // if (dt.Rows.Count > 0) // { // msg += "{root:["; // } // for (int i = 0; i < dt.Rows.Count; i++) // { // msg += "{name:'" + dt.Rows[i]["Name"].ToString() + "',kcid:'" + dt.Rows[i]["KCID"].ToString() + "',status:'" + dt.Rows[i]["Status"].ToString() + "',parentName:'" + dt.Rows[i]["parentName"].ToString() + "'},"; // } // if (dt.Rows.Count > 0) // { // msg = msg.TrimEnd(',') + "]}"; // } // } //} #endregion } }