models.smark.cs

smark.data是基于C#开发的轻量级数据访问组件。 提供以下功能封： 1）提供了跨数据库类型操作能力 2）基于程线存储的数据访问上下文对象

//------------------------------------------------------------------------------
// <auto-generated>
//     此代码由工具生成。
//     运行库版本:2.0.50727.1433
//
//     对此文件的更改可能会导致不正确的行为，并且如果
//     重新生成代码，这些更改将会丢失。
// </auto-generated>
//------------------------------------------------------------------------------

namespace Smark.Users {
    using System;
    using System.Data;
    using Smark.Data;
    
    
    /// <summary>
    /// Smark.Data.VSGenerator Copyright 泥水佬
    /// Email:[e-mail]
    /// MappingTable:[User]
    /// 用户信息表
    /// </summary>
    [Serializable()]
    public partial class User : EntityBase {
        
        private string mUserName;
        
        public static FieldInfo userName = new FieldInfo("[User]", "UserName");
        
        private string mUserPWD;
        
        public static FieldInfo userPWD = new FieldInfo("[User]", "UserPWD");
        
        private string mSex;
        
        public static FieldInfo sex = new FieldInfo("[User]", "Sex");
        
        private System.DateTime mBirthDate;
        
        public static FieldInfo birthDate = new FieldInfo("[User]", "BirthDate");
        
        private string mEMail;
        
        public static FieldInfo eMail = new FieldInfo("[User]", "EMail");
        
        private bool mEnabled;
        
        public static FieldInfo enabled = new FieldInfo("[User]", "Enabled");
        
        private string mFullName;
        
        public static FieldInfo fullName = new FieldInfo("[User]", "FullName");
        
        private string mCountry;
        
        public static FieldInfo country = new FieldInfo("[User]", "Country");
        
        private string mRegion;
        
        public static FieldInfo region = new FieldInfo("[User]", "Region");
        
        private string mCity;
        
        public static FieldInfo city = new FieldInfo("[User]", "City");
        
        private string mAddress;
        
        public static FieldInfo address = new FieldInfo("[User]", "Address");
        
        private string mZipCode;
        
        public static FieldInfo zipCode = new FieldInfo("[User]", "ZipCode");
        
        private string mPhone;
        
        public static FieldInfo phone = new FieldInfo("[User]", "Phone");
        
        private int mUserType;
        
        public static FieldInfo userType = new FieldInfo("[User]", "UserType");
        
        private System.DateTime mCreateDate;
        
        public static FieldInfo createDate = new FieldInfo("[User]", "CreateDate");
        
        static string mSelectString = @"Select (UserName) as _UserName,(UserPWD) as _UserPWD,(Sex) as _Sex,(BirthDate) as _BirthDate,(EMail) as _EMail,(Enabled) as _Enabled,(FullName) as _FullName,(Country) as _Country,(Region) as _Region,(City) as _City,(Address) as _Address,(ZipCode) as _ZipCode,(Phone) as _Phone,(UserType) as _UserType,(CreateDate) as _CreateDate from [User]";
        
        static string mGroupString = null;
        
        /// <summary>
        /// 用户名
        /// </summary>
        public virtual string UserName {
            get {
                return this.mUserName;
            }
            set {
                this.mUserName = value;
                this.EntityState.FieldChange("UserName");
            }
        }
        
        /// <summary>
        /// 用户密码
        /// </summary>
        public virtual string UserPWD {
            get {
                return this.mUserPWD;
            }
            set {
                this.mUserPWD = value;
                this.EntityState.FieldChange("UserPWD");
            }
        }
        
        /// <summary>
        /// 性别
        /// </summary>
        public virtual string Sex {
            get {
                return this.mSex;
            }
            set {
                this.mSex = value;
                this.EntityState.FieldChange("Sex");
            }
        }
        
        /// <summary>
        /// 出生日期
        /// </summary>
        public virtual System.DateTime BirthDate {
            get {
                return this.mBirthDate;
            }
            set {
                this.mBirthDate = value;
                this.EntityState.FieldChange("BirthDate");
            }
        }
        
        /// <summary>
        /// 邮件地址
        /// </summary>
        public virtual string EMail {
            get {
                return this.mEMail;
            }
            set {
                this.mEMail = value;
                this.EntityState.FieldChange("EMail");
            }
        }
        
        /// <summary>
        /// 是否有效
        /// </summary>
        public virtual bool Enabled {
            get {
                return this.mEnabled;
            }
            set {
                this.mEnabled = value;
                this.EntityState.FieldChange("Enabled");
            }
        }
        
        /// <summary>
        /// 用户姓名
        /// </summary>
        public virtual string FullName {
            get {
                return this.mFullName;
            }
            set {
                this.mFullName = value;
                this.EntityState.FieldChange("FullName");
            }
        }
        
        /// <summary>
        /// 所在国家
        /// </summary>
        public virtual string Country {
            get {
                return this.mCountry;
            }
            set {
                this.mCountry = value;
                this.EntityState.FieldChange("Country");
            }
        }
        
        /// <summary>
        /// 所在地区
        /// </summary>
        public virtual string Region {
            get {
                return this.mRegion;
            }
            set {
                this.mRegion = value;
                this.EntityState.FieldChange("Region");
            }
        }
        
        /// <summary>
        /// 所在城市
        /// </summary>
        public virtual string City {
            get {
                return this.mCity;
            }
            set {
                this.mCity = value;
                this.EntityState.FieldChange("City");
            }
        }
        
        /// <summary>
        /// 联系地址
        /// </summary>
        public virtual string Address {
            get {
                return this.mAddress;
            }
            set {
                this.mAddress = value;
                this.EntityState.FieldChange("Address");
            }
        }
        
        /// <summary>
        /// 邮政编码
        /// </summary>
        public virtual string ZipCode {
            get {
                return this.mZipCode;
            }
            set {
                this.mZipCode = value;
                this.EntityState.FieldChange("ZipCode");
            }
        }
        
        /// <summary>
        /// 联系电话
        /// </summary>
        public virtual string Phone {
            get {
                return this.mPhone;
            }
            set {
                this.mPhone = value;
                this.EntityState.FieldChange("Phone");
            }
        }
        
        /// <summary>
        /// 用户类型
        /// </summary>
        public virtual int UserType {
            get {
                return this.mUserType;
            }
            set {
                this.mUserType = value;
                this.EntityState.FieldChange("UserType");
            }
        }
        
        /// <summary>
        /// 注册时间
        /// </summary>
        public virtual System.DateTime CreateDate {
            get {
                return this.mCreateDate;
            }
            set {
                this.mCreateDate = value;
                this.EntityState.FieldChange("CreateDate");
            }
        }
        
        public static string Table {
            get {
                return " [User] ";
            }
        }
        
        public static System.Collections.Generic.IList<User> List(IConnectinContext context, Expression expression, Region region, string OrderBy) {
            return EntityBase.OnList<User>(context, User.mSelectString, expression, region, OrderBy, User.mGroupString);
        }
        
        public static System.Collections.Generic.IList<User> List(IConnectinContext context, Expression expression) {
            return User.List(context, expression, null, null);
        }
        
        public static System.Collections.Generic.IList<User> List(Expression expression, Region region, string OrderBy) {
            IConnectinContext _context;
            _context = DBContext.Context;
            try {
                return User.List(_context, expression, region, OrderBy);
            }
            catch (System.Exception e_) {
                throw e_;
            }
            finally {
                _context.Dispose();
            }
        }
        
        public static System.Collections.Generic.IList<User> List(Expression expression) {
            IConnectinContext _context;
            _context = DBContext.Context;
            try {
                return User.List(_context, expression, null, null);
            }
            catch (System.Exception e_) {
                throw e_;
            }
            finally {
                _context.Dispose();
            }
        }
        
        public static User ListFirst(IConnectinContext context, Expression expression, string OrderBy) {
            return EntityBase.OnListFirst<User>(context, User.mSelectString, expression, OrderBy, User.mGroupString);
        }
        
        public static User ListFirst(IConnectinContext context, Expression expression) {
            return User.ListFirst(context, expression);
        }
        
        public static User ListFirst(Expression expression, string OrderBy) {
            IConnectinContext _context;
            _context = DBContext.Context;
            try {
                return User.ListFirst(_context, expression, OrderBy);
            }
            catch (System.Exception e_) {
                throw e_;
            }
            finally {
                _context.Dispose();
            }
        }
        
        public static User ListFirst(Expression expression) {
            IConnectinContext _context;
            _context = DBContext.Context;
            try {
                return User.ListFirst(_context, expression, null);
            }
            catch (System.Exception e_) {
                throw e_;
            }
            finally {
                _context.Dispose();
            }
        }
        
        public static int Count(IConnectinContext context, Expression expression) {
            return EntityBase.OnCount(context, "[User]", expression, User.mGroupString);
        }
        
        public static int Count(Expression expression) {
            IConnectinContext _context;
            _context = DBContext.Context;
            try {
                return User.Count(_context, expression);
            }
            catch (System.Exception e_) {
                throw e_;
            }
            finally {
                _context.Dispose();
            }
        }
        
        public static object AVG(IConnectinContext context, string field, bool DISTINCT, Expression expression) {
            return EntityBase.OnAggregation(context, "[User]", "AVG", field, DISTINCT, expression, User.mGroupString);
        }
        
        public static object AVG(IConnectinContext context, string field, Expression expression) {
            return User.AVG(context, field, false, expression);
        }
        
        public static object AVG(IConnectinContext context, string field) {
            return User.AVG(context, field, false, null);
        }