当前文件路径：JohnTree/JohnTree.Library/DAL/ConClass.cs 
1
using System;
2using System.Collections.Generic;
3using System.Text;
4using System.Data;
5
6using JohnTree.Library.Model;
7
8namespace JohnTree.Library.DAL
9
...{
10
public class ConClass : DbHelpers
11
...{
12 /**//// <summary>
13 /// 获取ClassId的包含菜单列表
14 /// </summary>
15 /// <param name="ClassId"></param>
16
/// <returns></returns>
17 public DataSet GetClassListByClassId( string ClassId )
18 ...{
19 StringBuilder strSql = new StringBuilder();
20 strSql.Append("select ClassList,ClassTj from Content_Class");
21 strSql.Append(" where ClassID=" + ClassId + " ");
22 return GetDataset(CommandType.Text, strSql.ToString());
23 }
24
25 /**//// <summary>
26 /// 添加一个菜单项
27 /// </summary>
28 /// <param name="ClassId"></param>
29 /// <param name="ClassName"></param>
30 /// <param name="ClassList"></param>
31 /// <param name="ClassPre"></param>
32 /// <param name="ClassTj"></param>
33 /// <returns></returns>
34 public bool ClassAdd( ConClassInfo model )
35 ...{
36 StringBuilder strSql = new StringBuilder();
37 strSql.Append("insert into Content_Class(");
38 strSql.Append("ClassId,ClassName,ClassList,ClassPre,ClassTj,ClassKind");
39 strSql.Append(")");
40 strSql.Append(" values (");
41 strSql.Append("'" + model.ClassId + "',");
42 strSql.Append("'" + model.ClassName + "',");
43 strSql.Append("'" + model.ClassList + "',");
44 strSql.Append("'" + model.ClassPre + "',");
45 strSql.Append("" + model.ClassTj + ",");
46 strSql.Append("" + model.ClassKind + "");
47 strSql.Append(")");
48
49 return NonQueryBool(CommandType.Text, strSql.ToString());
50 }
51
52 /**//// <summary>
53 /// 编辑一个菜单项
54 /// </summary>
55 /// <param name="ClassId"></param>
56 /// <param name="ClassName"></param>
57 /// <param name="ClassList"></param>
58 /// <param name="ClassPre"></param>
59 /// <param name="ClassTj"></param>
60 /// <returns></returns>
61 public bool ClassSave( ConClassInfo model )
62 ...{
63 StringBuilder strSql = new StringBuilder();
64 strSql.Append("update Content_Class set ");
65 strSql.Append("ClassName='" + model.ClassName + "',");
66 strSql.Append("ClassList='" + model.ClassList + "',");
67 strSql.Append("ClassPre='" + model.ClassPre + "',");
68 strSql.Append("ClassTj=" + model.ClassTj + "");
69 strSql.Append(" where ClassId='" + model.ClassId + "' ");
70
71
72 //同步更新子菜单项
73 DataSet ds = this.GetSubClassList(model.ClassId);
74 if (ds.Tables[0].Rows.Count > 0)
75 ...{
76 foreach (DataRow dr in ds.Tables[0].Rows)
77 ...{
78 string SubClassList = model.ClassList + dr["ClassId"].ToString().Trim() + ",";
79
80 model.ClassId = dr["ClassId"].ToString().Trim();
81 model.ClassName = dr["ClassName"].ToString().Trim();
82 model.ClassList = SubClassList.ToString().Trim();
83 model.ClassPre = dr["ClassPre"].ToString().Trim();
84 model.ClassTj = model.ClassTj + 1;
85 ClassSave(model);
86 }
87 }
88
89 return NonQueryBool(CommandType.Text, strSql.ToString());
90 }
91
92 /**//// <summary>
93 /// 获取该菜单项的所有子菜单项
94 /// </summary>
95 /// <param name="ClassId"></param>
96 /// <returns></returns>
97 public DataSet GetSubClassList( string ClassId )
98 ...{
99 StringBuilder strSql = new StringBuilder();
100 strSql.Append("select * from Content_Class");
101 strSql.Append(" where ClassPre='" + ClassId + "' ");
102 return GetDataset(CommandType.Text, strSql.ToString());
103 }
104
105 /**//// <summary>
106 /// 获取菜单列表
107 /// </summary>
108 /// <returns></returns>
109 public DataSet GetClassList( int ClassKind )
110 ...{
111 StringBuilder strSql = new StringBuilder();
112 strSql.Append("select * from Content_Class");
113 strSql.Append(" where ClassKind=" + ClassKind + "");
114 strSql.Append(" Order By ClassList Asc,ClassOrder Asc");
115 return GetDataset(CommandType.Text, strSql.ToString());
116 }
117
118 public string GetPreClassId( string ClassId )
119 ...{
120 StringBuilder strSql = new StringBuilder();
121 strSql.Append("Select top 1 ClassPre From Content_Class");
122 strSql.Append(" Where ClassId='" + ClassId + "'");
123 return NonQueryScalar(CommandType.Text, strSql.ToString()).ToString();
124 }
125
126 /**//// <summary>
127 /// 删除一个菜单项
128 /// </summary>
129 /// <param name="ClassId"></param>
130 /// <returns></returns>
131 public bool DelByClassId( string ClassId )
132 ...{
133 StringBuilder strSql = new StringBuilder();
134 strSql.Append("Delete From Content_Class");
135 strSql.Append(" where ClassId='" + ClassId + "'");
136 return NonQueryBool(CommandType.Text, strSql.ToString());
137 }
138
139 /**//// <summary>
140 /// 更新排序
141 /// </summary>
142 /// <param name="ClassId"></param>
143 /// <param name="ClassOrder"></param>
144 /// <returns></returns>
145 public bool UpdateClassOrder( string ClassId, int ClassOrder )
146 ...{
147 StringBuilder strSql = new StringBuilder();
148 strSql.Append("Update Content_Class Set ");
149 strSql.Append("ClassOrder=" + ClassOrder + " ");
150 strSql.Append(" where ClassId='" + ClassId + "'");
151 return NonQueryBool(CommandType.Text, strSql.ToString());
152 }
153 }
154
}
155
打包下载该项目完整源码：漂亮无限级分类源代码（三层实现）
