mj_class.cs

不错的 漂亮分类源代码 很又用

#region Description AutoGenerated By 张广坡代码生成器。
//------------------------------------------------------------------------------
// <Autogenerated>
//     This code was generated by the GenerateCodeTools designed by ZhangGuangPo.
//     Microsoft .Net Framework Runtime Version: 2.0.50727.42
//
//     Changes to this file may cause incorrect behavior and will be lost if 
//     the code is regenerated.
// </Autogenerated>
// <Author> MAJUN\Administrator </Author>
// <GenerateDate> 2008-5-9 20:43:12 </GenerateDate>
//------------------------------------------------------------------------------
#endregion

using System.Data;
using System;
using System.Text;
using System.Collections.Generic;

namespace DAL
{
    /// <summary>
    /// MJ_Class 的摘要说明。
    /// </summary>
    public partial class MJ_Class
    {
        
        #region MJ_Class 枚举。
        /// <summary>
        /// 数据库表 MJ_Class 字段枚举。
        /// </summary>
        public enum ColMJ_Class
        {
            Id,
            ClassId,
            ClassName,
            ClassList,
            ClassPre,
            ClassTj,
            ClassOrder,
            ClassKind,
        }
        #endregion
        
        #region 可继承私有变量。
        protected int m_Id = 0;
        protected string m_ClassId = string.Empty;
        protected string m_ClassName = string.Empty;
        protected string m_ClassList = string.Empty;
        protected string m_ClassPre = string.Empty;
        protected int m_ClassTj = 0;
        protected int m_ClassOrder = 0;
        protected int m_ClassKind = 0;
        #endregion
        
        #region 共有属性。
        public virtual int Id
        {
            get
            {
                return this.m_Id;
            }
            set
            {
                this.m_Id = value;
            }
        }
        public virtual string ClassId
        {
            get
            {
                return this.m_ClassId;
            }
            set
            {
                this.m_ClassId = value;
            }
        }
        public virtual string ClassName
        {
            get
            {
                return this.m_ClassName;
            }
            set
            {
                this.m_ClassName = value;
            }
        }
        public virtual string ClassList
        {
            get
            {
                return this.m_ClassList;
            }
            set
            {
                this.m_ClassList = value;
            }
        }
        public virtual string ClassPre
        {
            get
            {
                return this.m_ClassPre;
            }
            set
            {
                this.m_ClassPre = value;
            }
        }
        public virtual int ClassTj
        {
            get
            {
                return this.m_ClassTj;
            }
            set
            {
                this.m_ClassTj = value;
            }
        }
        public virtual int ClassOrder
        {
            get
            {
                return this.m_ClassOrder;
            }
            set
            {
                this.m_ClassOrder = value;
            }
        }
        public virtual int ClassKind
        {
            get
            {
                return this.m_ClassKind;
            }
            set
            {
                this.m_ClassKind = value;
            }
        }
        #endregion
        
        #region 公有方法。
        /// <summary>
        /// 选择列表方法。
        /// </summary>
        public virtual System.Data.DataTable Select()
        {
            string strSelectSql = "select '' as EDITFLAG, ";
            strSelectSql += "Id, ";
            strSelectSql += "ClassId, ";
            strSelectSql += "ClassName, ";
            strSelectSql += "ClassList, ";
            strSelectSql += "ClassPre, ";
            strSelectSql += "ClassTj, ";
            strSelectSql += "ClassOrder, ";
            strSelectSql += "ClassKind ";
            strSelectSql += "from MJ_Class";
            
            #region 如果字段不等于默认值。开始拼装Where语句。
            string strWhere = string.Empty;
            if(this.m_Id != 0)
                strWhere += string.Format(" and Id = {0}", this.m_Id);
            if(this.m_ClassId != string.Empty)
                strWhere += string.Format(" and ClassId = '{0}'", this.m_ClassId);
            if(this.m_ClassName != string.Empty)
                strWhere += string.Format(" and ClassName = '{0}'", this.m_ClassName);
            if(this.m_ClassList != string.Empty)
                strWhere += string.Format(" and ClassList = '{0}'", this.m_ClassList);
            if(this.m_ClassPre != string.Empty)
                strWhere += string.Format(" and ClassPre = '{0}'", this.m_ClassPre);
            if(this.m_ClassTj != 0)
                strWhere += string.Format(" and ClassTj = {0}", this.m_ClassTj);
            if(this.m_ClassOrder != 0)
                strWhere += string.Format(" and ClassOrder = {0}", this.m_ClassOrder);
            if(this.m_ClassKind != 0)
                strWhere += string.Format(" and ClassKind = {0}", this.m_ClassKind);
            
            if(strWhere != string.Empty)
            {
                strSelectSql = string.Format("{0} where 1=1{1}", strSelectSql, strWhere);
                strSelectSql = strSelectSql.Replace("where 1=1 and ", "where ");
            }
            #endregion
            
            return Longbow.Data.DBAccess.CreateDB().ExecuteQuery(strSelectSql);
        }
        /// <summary>
        /// 插入数据方法。
        /// </summary>
        public virtual bool Insert()
        {
            string strInsertSql = "insert into MJ_Class (";
            strInsertSql += "Id, ";
            strInsertSql += "ClassId, ";
            strInsertSql += "ClassName, ";
            strInsertSql += "ClassList, ";
            strInsertSql += "ClassPre, ";
            strInsertSql += "ClassTj, ";
            strInsertSql += "ClassOrder, ";
            strInsertSql += "ClassKind";
            strInsertSql += ") values (";
            strInsertSql += string.Format("{0}", this.m_Id==int.MinValue?"null":this.m_Id.ToString()) + ", ";
            strInsertSql += string.Format("'{0}'", this.m_ClassId) + ", ";
            strInsertSql += string.Format("'{0}'", this.m_ClassName) + ", ";
            strInsertSql += string.Format("'{0}'", this.m_ClassList) + ", ";
            strInsertSql += string.Format("'{0}'", this.m_ClassPre) + ", ";
            strInsertSql += string.Format("{0}", this.m_ClassTj==int.MinValue?"null":this.m_ClassTj.ToString()) + ", ";
            strInsertSql += string.Format("{0}", this.m_ClassOrder==int.MinValue?"null":this.m_ClassOrder.ToString()) + ", ";
            strInsertSql += string.Format("{0}", this.m_ClassKind==int.MinValue?"null":this.m_ClassKind.ToString()) + ")";
            return Longbow.Data.DBAccess.CreateDB().ExecuteNonQuery(strInsertSql) == 1;
        }
        #endregion
        
        #region 静态方法
        /// <summary>
        /// 带条件的查询数据静态方法。
        /// </summary>
        public static DataTable GetList(string strWhere, string strOrderBy)
        {
            string strSql = "select * from MJ_Class";
            if (!string.IsNullOrEmpty(strWhere))
            {
                strWhere = strWhere.Trim().ToLower().Replace("where ", string.Empty);
                strSql = string.Format("{0} where {1}", strSql, strWhere);
            }
            if (!string.IsNullOrEmpty(strOrderBy))
            {
                strOrderBy = strOrderBy.Trim().ToLower().Replace("order by ", string.Empty);
                strSql = string.Format("{0} order by {1}", strSql, strOrderBy);
            }
            return Longbow.Data.DBAccess.CreateDB().ExecuteQuery(strSql);
        }
        #endregion
    }
}