//获取分类下拉列表
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
}
}
