1
Description AutoGenerated By 张广坡代码生成器。#region Description AutoGenerated By 张广坡代码生成器。
2
//------------------------------------------------------------------------------
3// <Autogenerated>
4// This code was generated by the GenerateCodeTools designed by ZhangGuangPo.
5// Microsoft .Net Framework Runtime Version: 2.0.50727.42
6//
7// Changes to this file may cause incorrect behavior and will be lost if
8// the code is regenerated.
9// </Autogenerated>
10// <Author> MAJUN\Administrator </Author>
11// <GenerateDate> 2008-5-9 20:43:12 </GenerateDate>
12//------------------------------------------------------------------------------
13
#endregion
14
15using System.Data;
16using System;
17using System.Text;
18using System.Collections.Generic;
19
20namespace DAL
21...{
22
/**//// <summary>
23 /// MJ_Class 的摘要说明。
24
/// </summary>
25 public partial class MJ_Class
26 ...{
27
28 MJ_Class 枚举。#region MJ_Class 枚举。
29 /**//// <summary>
30 /// 数据库表 MJ_Class 字段枚举。
31 /// </summary>
32 public enum ColMJ_Class
33 ...{
34 Id,
35 ClassId,
36 ClassName,
37 ClassList,
38 ClassPre,
39 ClassTj,
40 ClassOrder,
41 ClassKind,
42 }
43 #endregion
44
45 可继承私有变量。#region 可继承私有变量。
46 protected int m_Id = 0;
47 protected string m_ClassId = string.Empty;
48 protected string m_ClassName = string.Empty;
49 protected string m_ClassList = string.Empty;
50 protected string m_ClassPre = string.Empty;
51 protected int m_ClassTj = 0;
52 protected int m_ClassOrder = 0;
53 protected int m_ClassKind = 0;
54 #endregion
55
56 共有属性。#region 共有属性。
57 public virtual int Id
58 ...{
59 get
60 ...{
61 return this.m_Id;
62 }
63 set
64 ...{
65 this.m_Id = value;
66 }
67 }
68 public virtual string ClassId
69 ...{
70 get
71 ...{
72 return this.m_ClassId;
73 }
74 set
75 ...{
76 this.m_ClassId = value;
77 }
78 }
79 public virtual string ClassName
80 ...{
81 get
82 ...{
83 return this.m_ClassName;
84 }
85 set
86 ...{
87 this.m_ClassName = value;
88 }
89 }
90 public virtual string ClassList
91 ...{
92 get
93 ...{
94 return this.m_ClassList;
95 }
96 set
97 ...{
98 this.m_ClassList = value;
99 }
100 }
101 public virtual string ClassPre
102 ...{
103 get
104 ...{
105 return this.m_ClassPre;
106 }
107 set
108 ...{
109 this.m_ClassPre = value;
110 }
111 }
112 public virtual int ClassTj
113 ...{
114 get
115 ...{
116 return this.m_ClassTj;
117 }
118 set
119 ...{
120 this.m_ClassTj = value;
121 }
122 }
123 public virtual int ClassOrder
124 ...{
125 get
126 ...{
127 return this.m_ClassOrder;
128 }
129 set
130 ...{
131 this.m_ClassOrder = value;
132 }
133 }
134 public virtual int ClassKind
135 ...{
136 get
137 ...{
138 return this.m_ClassKind;
139 }
140 set
141 ...{
142 this.m_ClassKind = value;
143 }
144 }
145 #endregion
146
147 公有方法。#region 公有方法。
148 /**//// <summary>
149 /// 选择列表方法。
150 /// </summary>
151 public virtual System.Data.DataTable Select()
152 ...{
153 string strSelectSql = "select '' as EDITFLAG, ";
154 strSelectSql += "Id, ";
155 strSelectSql += "ClassId, ";
156 strSelectSql += "ClassName, ";
157 strSelectSql += "ClassList, ";
158 strSelectSql += "ClassPre, ";
159 strSelectSql += "ClassTj, ";
160 strSelectSql += "ClassOrder, ";
161 strSelectSql += "ClassKind ";
162 strSelectSql += "from MJ_Class";
163
164 如果字段不等于默认值。开始拼装Where语句。#region 如果字段不等于默认值。开始拼装Where语句。
165 string strWhere = string.Empty;
166 if(this.m_Id != 0)
167 strWhere += string.Format(" and Id = {0}", this.m_Id);
168 if(this.m_ClassId != string.Empty)
169 strWhere += string.Format(" and ClassId = '{0}'", this.m_ClassId);
170 if(this.m_ClassName != string.Empty)
171 strWhere += string.Format(" and ClassName = '{0}'", this.m_ClassName);
172 if(this.m_ClassList != string.Empty)
173 strWhere += string.Format(" and ClassList = '{0}'", this.m_ClassList);
174 if(this.m_ClassPre != string.Empty)
175 strWhere += string.Format(" and ClassPre = '{0}'", this.m_ClassPre);
176 if(this.m_ClassTj != 0)
177 strWhere += string.Format(" and ClassTj = {0}", this.m_ClassTj);
178 if(this.m_ClassOrder != 0)
179 strWhere += string.Format(" and ClassOrder = {0}", this.m_ClassOrder);
180 if(this.m_ClassKind != 0)
181 strWhere += string.Format(" and ClassKind = {0}", this.m_ClassKind);
182
183 if(strWhere != string.Empty)
184 ...{
185 strSelectSql = string.Format("{0} where 1=1{1}", strSelectSql, strWhere);
186 strSelectSql = strSelectSql.Replace("where 1=1 and ", "where ");
187 }
188 #endregion
189
190 return Longbow.Data.DBAccess.CreateDB().ExecuteQuery(strSelectSql);
191 }
192 /**//// <summary>
193 /// 插入数据方法。
194 /// </summary>
195 public virtual bool Insert()
196 ...{
197 string strInsertSql = "insert into MJ_Class (";
198 strInsertSql += "Id, ";
199 strInsertSql += "ClassId, ";
200 strInsertSql += "ClassName, ";
201 strInsertSql += "ClassList, ";
202 strInsertSql += "ClassPre, ";
203 strInsertSql += "ClassTj, ";
204 strInsertSql += "ClassOrder, ";
205 strInsertSql += "ClassKind";
206 strInsertSql += ") values (";
207 strInsertSql += string.Format("{0}", this.m_Id==int.MinValue?"null":this.m_Id.ToString()) + ", ";
208 strInsertSql += string.Format("'{0}'", this.m_ClassId) + ", ";
209 strInsertSql += string.Format("'{0}'", this.m_ClassName) + ", ";
210 strInsertSql += string.Format("'{0}'", this.m_ClassList) + ", ";
211 strInsertSql += string.Format("'{0}'", this.m_ClassPre) + ", ";
212 strInsertSql += string.Format("{0}", this.m_ClassTj==int.MinValue?"null":this.m_ClassTj.ToString()) + ", ";
213 strInsertSql += string.Format("{0}", this.m_ClassOrder==int.MinValue?"null":this.m_ClassOrder.ToString()) + ", ";
214 strInsertSql += string.Format("{0}", this.m_ClassKind==int.MinValue?"null":this.m_ClassKind.ToString()) + ")";
215 return Longbow.Data.DBAccess.CreateDB().ExecuteNonQuery(strInsertSql) == 1;
216 }
217 #endregion
218
219 静态方法#region 静态方法
220 /**//// <summary>
221 /// 带条件的查询数据静态方法。
222 /// </summary>
223 public static DataTable GetList(string strWhere, string strOrderBy)
224 ...{
225 string strSql = "select * from MJ_Class";
226 if (!string.IsNullOrEmpty(strWhere))
227 ...{
228 strWhere = strWhere.Trim().ToLower().Replace("where ", string.Empty);
229 strSql = string.Format("{0} where {1}", strSql, strWhere);
230 }
231 if (!string.IsNullOrEmpty(strOrderBy))
232 ...{
233 strOrderBy = strOrderBy.Trim().ToLower().Replace("order by ", string.Empty);
234 strSql = string.Format("{0} order by {1}", strSql, strOrderBy);
235 }
236 return Longbow.Data.DBAccess.CreateDB().ExecuteQuery(strSql);
237 }
238 #endregion
239 }
240}
241
JohnTree/JohnTree.Library/DAL/MJ_Class.CS[7K，2009-6-12 11:45:43]，打开代码结构图
打包下载该项目完整源码：漂亮无限级分类源代码（三层实现）