/// <summary> /// 取cateto类别树 /// </summary> /// <returns>json</returns> private string getCateTo() { string treeStr = ""; string catelang = IRequest.GetQueryString("catelang"); int catefrom = IRequest.GetQueryInt("catefrom", 0); if (catelang == string.Empty) { catelang = "cn"; } using (ISession session = dbContext.Current().GetContext("SqlDb").GetSession()) { string fromSql = "select Cate_Module from [dcms_cate] where cate_id=" + catefrom; DataTable fromDt = session.GetTable(fromSql); string Sql = ""; if (fromDt.Rows.Count > 0) { Sql = "select Cate_Id,Cate_Title,Cate_Module,Cate_ManageUrl,Cate_ParentID,Cate_HasChild from [Dcms_Cate] where Cate_Lang='" + catelang + "' and cate_module='" + fromDt.Rows[0]["Cate_Module"].ToString() + "' order by [Cate_Order] asc"; } else { Sql = "select Cate_Id,Cate_Title,Cate_Module,Cate_ManageUrl,Cate_ParentID,Cate_HasChild from [Dcms_Cate] where Cate_Lang='" + catelang + "' order by [Cate_Order] asc"; } DataTable cateDt = session.GetTable(Sql); if (cateDt.Rows.Count > 0) { parentSelectTree pTree = new parentSelectTree(); treeStr = pTree.CreateTree(cateDt); } } return(treeStr); }
/// <summary> /// 取左栏类别树 /// </summary> /// <returns>json</returns> private string doSelect() { string treeStr = ""; string langFlag = Convert.ToString(Utils.GetCookie("LangFlag")); using (ISession session = dbContext.Current().GetContext("SqlDb").GetSession()) { string Sql = "select Cate_Id,Cate_Title,Cate_Module,Cate_ManageUrl,Cate_ParentID,Cate_HasChild from [Dcms_Cate] where Cate_Lang='" + langFlag + "' order by [Cate_Order] asc"; DataTable cateDt = session.GetTable(Sql); //if (cateDt.Rows.Count > 0) //{ cateMangeTree jTree = new cateMangeTree(); treeStr = jTree.CreateTree(cateDt); parentSelectTree pTree = new parentSelectTree(); treeStr = treeStr + "$|&|$" + pTree.CreateTree(cateDt); //} } return(treeStr); }
/// <summary> /// 取catefrom类别树 /// </summary> /// <returns>json</returns> private string getCateFrom() { string treeStr = ""; string catelang = IRequest.GetQueryString("catelang"); if (catelang == string.Empty) { catelang = "cn"; } using (ISession session = dbContext.Current().GetContext("SqlDb").GetSession()) { string Sql = "select Cate_Id,Cate_Title,Cate_Module,Cate_ManageUrl,Cate_ParentID,Cate_HasChild from [Dcms_Cate] where Cate_Lang='" + catelang + "' order by [Cate_Order] asc"; DataTable cateDt = session.GetTable(Sql); if (cateDt.Rows.Count > 0) { parentSelectTree pTree = new parentSelectTree(); treeStr = pTree.CreateTree(cateDt); } } return(treeStr); }
/// <summary> /// 取左栏类别树 /// </summary> /// <returns>json</returns> private string doSelect() { string treeStr = ""; string langFlag = Convert.ToString(Utils.GetCookie("LangFlag")); using (ISession session = dbContext.Current().GetContext("SqlDb").GetSession()) { string Sql = "select Cate_Id,Cate_Title,Cate_Module,Cate_ManageUrl,Cate_ParentID,Cate_HasChild from [Dcms_Cate] where Cate_Lang='" + langFlag + "' order by [Cate_Order] asc"; DataTable cateDt = session.GetTable(Sql); //if (cateDt.Rows.Count > 0) //{ cateMangeTree jTree = new cateMangeTree(); treeStr = jTree.CreateTree(cateDt); parentSelectTree pTree = new parentSelectTree(); treeStr = treeStr + "$|&|$" + pTree.CreateTree(cateDt); //} } return treeStr; }
/// <summary> /// 取cateto类别树 /// </summary> /// <returns>json</returns> private string getCateTo() { string treeStr = ""; string catelang = IRequest.GetQueryString("catelang"); int catefrom = IRequest.GetQueryInt("catefrom", 0); if (catelang == string.Empty) { catelang = "cn"; } using (ISession session = dbContext.Current().GetContext("SqlDb").GetSession()) { string fromSql = "select Cate_Module from [dcms_cate] where cate_id=" + catefrom; DataTable fromDt = session.GetTable(fromSql); string Sql = ""; if (fromDt.Rows.Count > 0) { Sql = "select Cate_Id,Cate_Title,Cate_Module,Cate_ManageUrl,Cate_ParentID,Cate_HasChild from [Dcms_Cate] where Cate_Lang='" + catelang + "' and cate_module='" + fromDt.Rows[0]["Cate_Module"].ToString() + "' order by [Cate_Order] asc"; } else { Sql = "select Cate_Id,Cate_Title,Cate_Module,Cate_ManageUrl,Cate_ParentID,Cate_HasChild from [Dcms_Cate] where Cate_Lang='" + catelang + "' order by [Cate_Order] asc"; } DataTable cateDt = session.GetTable(Sql); if (cateDt.Rows.Count > 0) { parentSelectTree pTree = new parentSelectTree(); treeStr = pTree.CreateTree(cateDt); } } return treeStr; }
/// <summary> /// 取catefrom类别树 /// </summary> /// <returns>json</returns> private string getCateFrom() { string treeStr = ""; string catelang = IRequest.GetQueryString("catelang"); if (catelang == string.Empty) { catelang = "cn"; } using (ISession session = dbContext.Current().GetContext("SqlDb").GetSession()) { string Sql = "select Cate_Id,Cate_Title,Cate_Module,Cate_ManageUrl,Cate_ParentID,Cate_HasChild from [Dcms_Cate] where Cate_Lang='"+catelang+"' order by [Cate_Order] asc"; DataTable cateDt = session.GetTable(Sql); if (cateDt.Rows.Count > 0) { parentSelectTree pTree = new parentSelectTree(); treeStr =pTree.CreateTree(cateDt); } } return treeStr; }