models.smark.cs

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

        public static object AVG(IConnectinContext context, string field, bool DISTINCT) {
            return User.AVG(context, field, DISTINCT, null);
        }
        
        public static object AVG(string field, bool DISTINCT, Expression expression) {
            IConnectinContext _context;
            _context = DBContext.Context;
            try {
                return User.AVG(_context, field, DISTINCT, expression);
            }
            catch (System.Exception e_) {
                throw e_;
            }
            finally {
                _context.Dispose();
            }
        }
        
        public static object AVG(string field, Expression expression) {
            IConnectinContext _context;
            _context = DBContext.Context;
            try {
                return User.AVG(_context, field, false, expression);
            }
            catch (System.Exception e_) {
                throw e_;
            }
            finally {
                _context.Dispose();
            }
        }
        
        public static object AVG(string field) {
            IConnectinContext _context;
            _context = DBContext.Context;
            try {
                return User.AVG(_context, field, false, null);
            }
            catch (System.Exception e_) {
                throw e_;
            }
            finally {
                _context.Dispose();
            }
        }
        
        public static object AVG(string field, bool DISTINCT) {
            IConnectinContext _context;
            _context = DBContext.Context;
            try {
                return User.AVG(_context, field, DISTINCT, null);
            }
            catch (System.Exception e_) {
                throw e_;
            }
            finally {
                _context.Dispose();
            }
        }
        
        public static object SUM(IConnectinContext context, string field, bool DISTINCT, Expression expression) {
            return EntityBase.OnAggregation(context, "[User]", "SUM", field, DISTINCT, expression, User.mGroupString);
        }
        
        public static object SUM(IConnectinContext context, string field, Expression expression) {
            return User.SUM(context, field, false, expression);
        }
        
        public static object SUM(IConnectinContext context, string field) {
            return User.SUM(context, field, false, null);
        }
        
        public static object SUM(IConnectinContext context, string field, bool DISTINCT) {
            return User.SUM(context, field, DISTINCT, null);
        }
        
        public static object SUM(string field, bool DISTINCT, Expression expression) {
            IConnectinContext _context;
            _context = DBContext.Context;
            try {
                return User.SUM(_context, field, DISTINCT, expression);
            }
            catch (System.Exception e_) {
                throw e_;
            }
            finally {
                _context.Dispose();
            }
        }
        
        public static object SUM(string field, Expression expression) {
            IConnectinContext _context;
            _context = DBContext.Context;
            try {
                return User.SUM(_context, field, false, expression);
            }
            catch (System.Exception e_) {
                throw e_;
            }
            finally {
                _context.Dispose();
            }
        }
        
        public static object SUM(string field) {
            IConnectinContext _context;
            _context = DBContext.Context;
            try {
                return User.SUM(_context, field, false, null);
            }
            catch (System.Exception e_) {
                throw e_;
            }
            finally {
                _context.Dispose();
            }
        }
        
        public static object SUM(string field, bool DISTINCT) {
            IConnectinContext _context;
            _context = DBContext.Context;
            try {
                return User.SUM(_context, field, DISTINCT, null);
            }
            catch (System.Exception e_) {
                throw e_;
            }
            finally {
                _context.Dispose();
            }
        }
        
        public static object MAX(IConnectinContext context, string field, Expression expression) {
            return EntityBase.OnAggregation(context, "[User]", "MAX", field, false, expression, User.mGroupString);
        }
        
        public static object MAX(IConnectinContext context, string field) {
            return User.MAX(context, field, null);
        }
        
        public static object MAX(string field, Expression expression) {
            IConnectinContext _context;
            _context = DBContext.Context;
            try {
                return User.MAX(_context, field, expression);
            }
            catch (System.Exception e_) {
                throw e_;
            }
            finally {
                _context.Dispose();
            }
        }
        
        public static object MAX(string field) {
            IConnectinContext _context;
            _context = DBContext.Context;
            try {
                return User.MAX(_context, field, null);
            }
            catch (System.Exception e_) {
                throw e_;
            }
            finally {
                _context.Dispose();
            }
        }
        
        public static object MIN(IConnectinContext context, string field, Expression expression) {
            return EntityBase.OnAggregation(context, "[User]", "MIN", field, false, expression, User.mGroupString);
        }
        
        public static object MIN(IConnectinContext context, string field) {
            return User.MIN(context, field, null);
        }
        
        public static object MIN(string field, Expression expression) {
            IConnectinContext _context;
            _context = DBContext.Context;
            try {
                return User.MIN(_context, field, expression);
            }
            catch (System.Exception e_) {
                throw e_;
            }
            finally {
                _context.Dispose();
            }
        }
        
        public static object MIN(string field) {
            IConnectinContext _context;
            _context = DBContext.Context;
            try {
                return User.MIN(_context, field, null);
            }
            catch (System.Exception e_) {
                throw e_;
            }
            finally {
                _context.Dispose();
            }
        }
        
        protected override void OnLoadData(System.Data.IDataReader reader) {
            if ((reader["_UserName"] != System.DBNull.Value)) {
                this.UserName = ((string)(this.Convert(typeof(string), reader["_UserName"])));
            }
            if ((reader["_UserPWD"] != System.DBNull.Value)) {
                this.UserPWD = ((string)(this.Convert(typeof(string), reader["_UserPWD"])));
            }
            if ((reader["_Sex"] != System.DBNull.Value)) {
                this.Sex = ((string)(this.Convert(typeof(string), reader["_Sex"])));
            }
            if ((reader["_BirthDate"] != System.DBNull.Value)) {
                this.BirthDate = ((System.DateTime)(this.Convert(typeof(System.DateTime), reader["_BirthDate"])));
            }
            if ((reader["_EMail"] != System.DBNull.Value)) {
                this.EMail = ((string)(this.Convert(typeof(string), reader["_EMail"])));
            }
            if ((reader["_Enabled"] != System.DBNull.Value)) {
                this.Enabled = ((bool)(this.Convert(typeof(bool), reader["_Enabled"])));
            }
            if ((reader["_FullName"] != System.DBNull.Value)) {
                this.FullName = ((string)(this.Convert(typeof(string), reader["_FullName"])));
            }
            if ((reader["_Country"] != System.DBNull.Value)) {
                this.Country = ((string)(this.Convert(typeof(string), reader["_Country"])));
            }
            if ((reader["_Region"] != System.DBNull.Value)) {
                this.Region = ((string)(this.Convert(typeof(string), reader["_Region"])));
            }
            if ((reader["_City"] != System.DBNull.Value)) {
                this.City = ((string)(this.Convert(typeof(string), reader["_City"])));
            }
            if ((reader["_Address"] != System.DBNull.Value)) {
                this.Address = ((string)(this.Convert(typeof(string), reader["_Address"])));
            }
            if ((reader["_ZipCode"] != System.DBNull.Value)) {
                this.ZipCode = ((string)(this.Convert(typeof(string), reader["_ZipCode"])));
            }
            if ((reader["_Phone"] != System.DBNull.Value)) {
                this.Phone = ((string)(this.Convert(typeof(string), reader["_Phone"])));
            }
            if ((reader["_UserType"] != System.DBNull.Value)) {
                this.UserType = ((int)(this.Convert(typeof(int), reader["_UserType"])));
            }
            if ((reader["_CreateDate"] != System.DBNull.Value)) {
                this.CreateDate = ((System.DateTime)(this.Convert(typeof(System.DateTime), reader["_CreateDate"])));
            }
        }
        
        public static void Delete(IConnectinContext context, Expression expression) {
            EntityBase.OnDelete(context, "[User]", expression);
        }
        
        public static void Delete(Expression expression) {
            IConnectinContext _context;
            _context = DBContext.Context;
            try {
                User.Delete(_context, expression);
            }
            catch (System.Exception e_) {
                throw e_;
            }
            finally {
                _context.Dispose();
            }
        }
        
        public static User Load(IConnectinContext context, string id) {
            return EntityBase.OnLoad<User>(context, User.mSelectString, "UserName", id);
        }
        
        public static User Load(string id) {
            IConnectinContext _context;
            _context = DBContext.Context;
            try {
                return User.Load(_context, id);
            }
            catch (System.Exception e_) {
                throw e_;
            }
            finally {
                _context.Dispose();
            }
        }
        
        public virtual void Save(IConnectinContext context) {
            System.Collections.Generic.IList<Field> _fields;
            Field _id;
            Field item;
            _fields = new System.Collections.Generic.List<Field>();
            _id = new Field();
            _id.Name = "UserName";
            _id.Value = this.UserName;
            _id.GetValueBy = "";
            _id.GetValueAfterInsert = false;
            item = new Field();
            item.Name = "UserPWD";
            item.Value = this.UserPWD;
            _fields.Add(item);
            item = new Field();
            item.Name = "Sex";
            item.Value = this.Sex;
            _fields.Add(item);
            item = new Field();
            item.Name = "BirthDate";
            item.Value = this.BirthDate;
            _fields.Add(item);
            item = new Field();
            item.Name = "EMail";
            item.Value = this.EMail;
            _fields.Add(item);
            item = new Field();
            item.Name = "Enabled";
            item.Value = this.Enabled;
            _fields.Add(item);
            item = new Field();
            item.Name = "FullName";
            item.Value = this.FullName;
            _fields.Add(item);
            item = new Field();
            item.Name = "Country";
            item.Value = this.Country;
            _fields.Add(item);
            item = new Field();
            item.Name = "Region";
            item.Value = this.Region;
            _fields.Add(item);
            item = new Field();
            item.Name = "City";
            item.Value = this.City;
            _fields.Add(item);
            item = new Field();
            item.Name = "Address";
            item.Value = this.Address;
            _fields.Add(item);
            item = new Field();
            item.Name = "ZipCode";
            item.Value = this.ZipCode;
            _fields.Add(item);
            item = new Field();
            item.Name = "Phone";
            item.Value = this.Phone;
            _fields.Add(item);
            item = new Field();
            item.Name = "UserType";
            item.Value = this.UserType;
            _fields.Add(item);
            item = new Field();
            item.Name = "CreateDate";
            item.Value = this.CreateDate;
            _fields.Add(item);
            this.OnSave(context, "[User]", _fields, _id);
            this.UserName = ((string)(this.Convert(typeof(string), _id.Value)));
        }
        
        public virtual void Save() {
            IConnectinContext _context;
            _context = DBContext.Context;
            try {
                this.Save(_context);
            }
            catch (System.Exception e_) {
                throw e_;
            }
            finally {
                _context.Dispose();
            }
        }
        
        public virtual void Delete(IConnectinContext context) {
            this.OnDeleteObject(context, "[User]", "UserName", this.UserName);
        }
        
        public virtual void Delete() {
            IConnectinContext _context;
            _context = DBContext.Context;
            try {
                this.Delete(_context);
            }
            catch (System.Exception e_) {
                throw e_;
            }
            finally {
                _context.Dispose();
            }
        }
    }
}