当前文件路径：JohnTree/JohnTree.Library/DAL/MJ_Class.CS

		            
  1Description 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