Gsmarket/Sources/GS-MarketMG-2018/SysDataLibs/TableClass/Sys_Users_info.cs

using System; 
using System.Collections.Generic; 
using System.Text; 
using System.Data; 
using SysBaseLibs; 
using System.Web.Script.Serialization;
using System.Web.UI.WebControls;
namespace SysDataLibs.TableClass
{
    #region      Sys_Users
    public class Sys_Users_info : ITableInfo
    {
        #region      Sys_Users表 字段信息
        /// <summary> 
        /// 为关键字段： N ;
        /// 自动增长： N;
        /// 数据类型： varchar;
        /// 数据长度： 80;
        /// 是否允许为空： Y;
        /// 默认值： ;
        /// 描述： 地址;
        /// </summary>
        public const string cAddress = "Address";

        /// <summary> 
        /// 为关键字段： N ;
        /// 自动增长： N;
        /// 数据类型： varchar;
        /// 数据长度： 10;
        /// 是否允许为空： Y;
        /// 默认值： ;
        /// 描述： 年龄;
        /// </summary>
        public const string cAge = "Age";

        /// <summary> 
        /// 为关键字段： N ;
        /// 自动增长： N;
        /// 数据类型： smalldatetime;
        /// 数据长度： 4;
        /// 是否允许为空： Y;
        /// 默认值： ;
        /// 描述： 创建日期;
        /// </summary>
        public const string cCreateDate = "CreateDate";

        /// <summary> 
        /// 为关键字段： N ;
        /// 自动增长： N;
        /// 数据类型： varchar;
        /// 数据长度： 20;
        /// 是否允许为空： Y;
        /// 默认值： ;
        /// 描述： 创建用户;
        /// </summary>
        public const string cCreateUser = "CreateUser";

        /// <summary> 
        /// 为关键字段： N ;
        /// 自动增长： N;
        /// 数据类型： int;
        /// 数据长度： 4;
        /// 是否允许为空： Y;
        /// 默认值： ;
        /// 描述： 所属部门;
        /// </summary>
        public const string cDepartmentID = "DepartmentID";

        /// <summary> 
        /// 为关键字段： N ;
        /// 自动增长： N;
        /// 数据类型： int;
        /// 数据长度： 4;
        /// 是否允许为空： Y;
        /// 默认值： ;
        /// 描述： 职务编号;
        /// </summary>
        public const string cDutyID = "DutyID";

        /// <summary> 
        /// 为关键字段： N ;
        /// 自动增长： N;
        /// 数据类型： varchar;
        /// 数据长度： 50;
        /// 是否允许为空： Y;
        /// 默认值： ;
        /// 描述： 电子邮箱;
        /// </summary>
        public const string cEmail = "Email";

        /// <summary> 
        /// 为关键字段： N ;
        /// 自动增长： N;
        /// 数据类型： varchar;
        /// 数据长度： 10;
        /// 是否允许为空： Y;
        /// 默认值： ;
        /// 描述： 所属单位;
        /// </summary>
        public const string cFarmID = "FarmID";

        /// <summary> 
        /// 为关键字段： N ;
        /// 自动增长： N;
        /// 数据类型： varchar;
        /// 数据长度： 200;
        /// 是否允许为空： Y;
        /// 默认值： ;
        /// 描述： 信息;
        /// </summary>
        public const string cInfo = "Info";

        /// <summary> 
        /// 为关键字段： N ;
        /// 自动增长： N;
        /// 数据类型： nchar;
        /// 数据长度： 2;
        /// 是否允许为空： N;
        /// 默认值： ((0));
        /// 描述： 是否高级;
        /// </summary>
        public const string cIsAdvance = "IsAdvance";

        /// <summary> 
        /// 为关键字段： N ;
        /// 自动增长： N;
        /// 数据类型： nchar;
        /// 数据长度： 2;
        /// 是否允许为空： N;
        /// 默认值： (N'Y');
        /// 描述： IsAudit;
        /// </summary>
        public const string cIsAudit = "IsAudit";

        /// <summary> 
        /// 为关键字段： N ;
        /// 自动增长： N;
        /// 数据类型： nchar;
        /// 数据长度： 2;
        /// 是否允许为空： Y;
        /// 默认值： ((0));
        /// 描述： 是否锁定;
        /// </summary>
        public const string cIsLock = "IsLock";

        /// <summary> 
        /// 为关键字段： N ;
        /// 自动增长： N;
        /// 数据类型： nchar;
        /// 数据长度： 2;
        /// 是否允许为空： Y;
        /// 默认值： ((0));
        /// 描述： 是否系统;
        /// </summary>
        public const string cIsSystem = "IsSystem";

        /// <summary> 
        /// 为关键字段： N ;
        /// 自动增长： N;
        /// 数据类型： varchar;
        /// 数据长度： 20;
        /// 是否允许为空： Y;
        /// 默认值： ;
        /// 描述： 姓名;
        /// </summary>
        public const string cNames = "Names";

        /// <summary> 
        /// 为关键字段： N ;
        /// 自动增长： N;
        /// 数据类型： varchar;
        /// 数据长度： 60;
        /// 是否允许为空： Y;
        /// 默认值： ;
        /// 描述： 用户密码;
        /// </summary>
        public const string cPassword = "Password";

        /// <summary> 
        /// 为关键字段： N ;
        /// 自动增长： N;
        /// 数据类型： char;
        /// 数据长度： 10;
        /// 是否允许为空： Y;
        /// 默认值： ;
        /// 描述： 所属区域;
        /// </summary>
        public const string cRegionID = "RegionID";

        /// <summary> 
        /// 为关键字段： N ;
        /// 自动增长： N;
        /// 数据类型： varchar;
        /// 数据长度： 2;
        /// 是否允许为空： Y;
        /// 默认值： ;
        /// 描述： 性别;
        /// </summary>
        public const string cSex = "Sex";

        /// <summary> 
        /// 为关键字段： N ;
        /// 自动增长： N;
        /// 数据类型： nchar;
        /// 数据长度： 20;
        /// 是否允许为空： N;
        /// 默认值： (N'GSSys');
        /// 描述： 所属系统;
        /// </summary>
        public const string cSystemID = "SystemID";

        /// <summary> 
        /// 为关键字段： N ;
        /// 自动增长： N;
        /// 数据类型： varchar;
        /// 数据长度： 20;
        /// 是否允许为空： Y;
        /// 默认值： ;
        /// 描述： 电话;
        /// </summary>
        public const string cTelephone = "Telephone";

        /// <summary> 
        /// 为关键字段： N ;
        /// 自动增长： N;
        /// 数据类型： varchar;
        /// 数据长度： 10;
        /// 是否允许为空： N;
        /// 默认值： ;
        /// 描述： 登陆用户名;
        /// </summary>
        public const string cUserCode = "UserCode";

        /// <summary> 
        /// 为关键字段： Y --- PrimaryKey;
        /// 自动增长： N;
        /// 数据类型： varchar;
        /// 数据长度： 30;
        /// 是否允许为空： N;
        /// 默认值： ;
        /// 描述： 编号;
        /// </summary>
        public const string cUserID = "UserID";

        /// <summary> 
        /// 为关键字段： N ;
        /// 自动增长： N;
        /// 数据类型： varchar;
        /// 数据长度： 20;
        /// 是否允许为空： Y;
        /// 默认值： ;
        /// 描述： 邮政编码;
        /// </summary>
        public const string cZIP = "ZIP";

        #endregion
        public Sys_Users_info() { }

        public Sys_Users_info(DataRow poRow)
        {
            CreateTableInfo(poRow);
        }

        public void CreateTableInfo(DataRow poRow)
        {
            _Address = UtilStr.StrFromObj(poRow[cAddress]);
            _Age = UtilStr.StrFromObj(poRow[cAge]);
            _CreateDate = UtilStr.StrFromObj(poRow[cCreateDate]);
            _CreateUser = UtilStr.StrFromObj(poRow[cCreateUser]);
            _DepartmentID = UtilStr.StrFromObj(poRow[cDepartmentID]);
            _DutyID = UtilStr.StrFromObj(poRow[cDutyID]);
            _Email = UtilStr.StrFromObj(poRow[cEmail]);
            _FarmID = UtilStr.StrFromObj(poRow[cFarmID]);
            _Info = UtilStr.StrFromObj(poRow[cInfo]);
            _IsAdvance = UtilStr.StrFromObj(poRow[cIsAdvance]);
            _IsAudit = UtilStr.StrFromObj(poRow[cIsAudit]);
            _IsLock = UtilStr.StrFromObj(poRow[cIsLock]);
            _IsSystem = UtilStr.StrFromObj(poRow[cIsSystem]);
            _Names = UtilStr.StrFromObj(poRow[cNames]);
            _Password = UtilStr.StrFromObj(poRow[cPassword]);
            _RegionID = UtilStr.StrFromObj(poRow[cRegionID]);
            _Sex = UtilStr.StrFromObj(poRow[cSex]);
            _SystemID = UtilStr.StrFromObj(poRow[cSystemID]);
            _Telephone = UtilStr.StrFromObj(poRow[cTelephone]);
            _UserCode = UtilStr.StrFromObj(poRow[cUserCode]);
            _UserID = UtilStr.StrFromObj(poRow[cUserID]);
            _ZIP = UtilStr.StrFromObj(poRow[cZIP]);
        }

        public Sys_Users_info(string pcUserID, DBConnSql poDBConn)
        {
            if (pcUserID.Trim().Length > 0 && poDBConn != null)
            {
                string lcSql = "select * from " + Tn.Sys_Users + " where UserID='" + pcUserID + "'";
                rsQuery loQuery = poDBConn.OpenQuery(lcSql);
                if (loQuery != null && loQuery.IsOpened && loQuery.RecCount == 1)
                {
                    loQuery.MoveFirst();
                    CreateTableInfo(loQuery.CurrentRow);
                }
            }
        }


        public static Sys_Users_info GetUserInfoByUserCode(string pcUserCode)
        {
            Sys_Users_info loRetVal = null;
            if (pcUserCode.Trim().Length > 0)
            {
                UserSession loSession = WebLibs.CheckLogin();
                string lcSql = "select * from " + Tn.Sys_Users + " where " + Sys_Users_info.cUserCode + " = '" + pcUserCode + "'";
                rsQuery loQuery = loSession.DBConn.OpenQuery(lcSql);
                if (loQuery != null && loQuery.IsOpened && loQuery.RecCount == 1)
                {
                    loRetVal = new Sys_Users_info(loQuery.CurrentRow);
                }
            }
            return loRetVal;
        }
        private string _Address = "";
        public string Address
        {
            get { return _Address; }
            set { _Address = value; }
        }

        private string _Age = "";
        public string Age
        {
            get { return _Age; }
            set { _Age = value; }
        }

        private string _CreateDate = "";
        public string CreateDate
        {
            get { return _CreateDate; }
            set { _CreateDate = value; }
        }

        private string _CreateUser = "";
        public string CreateUser
        {
            get { return _CreateUser; }
            set { _CreateUser = value; }
        }

        private string _DepartmentID = "";
        public string DepartmentID
        {
            get { return _DepartmentID; }
            set { _DepartmentID = value; }
        }

        private string _DutyID = "";
        public string DutyID
        {
            get { return _DutyID; }
            set { _DutyID = value; }
        }

        private string _Email = "";
        public string Email
        {
            get { return _Email; }
            set { _Email = value; }
        }

        private string _FarmID = "";
        public string FarmID
        {
            get { return _FarmID; }
            set { _FarmID = value; }
        }

        private string _Info = "";
        public string Info
        {
            get { return _Info; }
            set { _Info = value; }
        }

        private string _IsAdvance = "";
        public string IsAdvance
        {
            get { return _IsAdvance; }
            set { _IsAdvance = value; }
        }

        private string _IsAudit = "";
        public string IsAudit
        {
            get { return _IsAudit; }
            set { _IsAudit = value; }
        }

        private string _IsLock = "";
        public string IsLock
        {
            get { return _IsLock; }
            set { _IsLock = value; }
        }

        private string _IsSystem = "";
        public string IsSystem
        {
            get { return _IsSystem; }
            set { _IsSystem = value; }
        }

        private string _Names = "";
        public string Names
        {
            get { return _Names; }
            set { _Names = value; }
        }

        private string _Password = "";
        public string Password
        {
            get
            {
                string lcRetVal = "";
                try
                {
                    lcRetVal = SysSecLibs.SysSecurity.Decrypt(_Password);
                }
                catch (Exception e)
                {
                    ThreadLog.LogException(e);
                }
                return lcRetVal;
            }
            set
            {
                try
                {
                    _Password = SysSecLibs.SysSecurity.Encrypt(value);
                }
                catch (Exception e)
                {
                    ThreadLog.LogException(e);
                }
            }
        }

        private string _RegionID = "";
        public string RegionID
        {
            get { return _RegionID; }
            set { _RegionID = value; }
        }

        private string _Sex = "";
        public string Sex
        {
            get { return _Sex; }
            set { _Sex = value; }
        }

        private string _SystemID = "";
        public string SystemID
        {
            get { return _SystemID; }
            set { _SystemID = value; }
        }

        GSSystem_info _GSSystem = null;
        public GSSystem_info GSSystem
        {
            get
            {
                if (_GSSystem == null)
                {
                    DBConnSql loDBConn = new DBConnSql();

                    try
                    {
                        loDBConn.Open();
                        _GSSystem = new GSSystem_info(this.SystemID, loDBConn);
                    }
                    catch (Exception err)
                    {
                        ThreadLog.LogException(err);
                    }
                    finally
                    {
                        if (loDBConn != null && loDBConn.IsOpened)
                        {
                            loDBConn.Close();
                            loDBConn = null;
                        }
                    }
                }
                return _GSSystem;
            }
        }

        private string _Telephone = "";
        public string Telephone
        {
            get { return _Telephone; }
            set { _Telephone = value; }
        }

        private string _UserCode = "";
        public string UserCode
        {
            get { return _UserCode; }
            set { _UserCode = value; }
        }

        private string _UserID = "";
        public string UserID
        {
            get { return _UserID; }
            set { _UserID = value; }
        }

        private string _ZIP = "";
        public string ZIP
        {
            get { return _ZIP; }
            set { _ZIP = value; }
        }

        public bool IsSys
        {
            get { return UtilStr.StrToBool(_IsSystem); }
        }
        public bool IsAdv
        {
            get { return UtilStr.StrToBool(_IsAdvance); }
        }

        public bool IsMarketSys
        {
            get
            {
                return GSSystem.SystemType == "N";
            }
        }

        [ScriptIgnore]
        public rsXmlNode DataXMLNode
        {
            get
            {
                rsXmlNode loMainNode = new rsXmlNode("Sys_UsersRecord", "");
                rsXmlNode loNode = null;
                loNode = new rsXmlNode(cAddress, Address);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cAge, Age);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cCreateDate, CreateDate);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cCreateUser, CreateUser);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cDepartmentID, DepartmentID);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cDutyID, DutyID);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cEmail, Email);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cFarmID, FarmID);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cInfo, Info);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cIsAdvance, IsAdvance);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cIsAudit, IsAudit);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cIsLock, IsLock);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cIsSystem, IsSystem);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cNames, Names);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cPassword, Password);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cRegionID, RegionID);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cSex, Sex);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cSystemID, SystemID);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cTelephone, Telephone);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cUserCode, UserCode);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cUserID, UserID);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cZIP, ZIP);
                loMainNode.AddChild(loNode);
                return loMainNode;
            }
        }
        public string InsertSql()
        {
            return " insert into " + Tn.Sys_Users + " " +
                        " (" + cAddress + "," + cAge + "," + cCreateDate + "," + cCreateUser + "," + cDepartmentID + "," + cDutyID + "," + cEmail + "," + cFarmID + "," + cInfo + "," + cIsAdvance + "," + cIsAudit + "," + cIsLock + "," + cIsSystem + "," + cNames + "," + cPassword + "," + cRegionID + "," + cSex + "," + cSystemID + "," + cTelephone + "," + cUserCode + "," + cUserID + "," + cZIP + ") " +
                        " values ('" + _Address + "','" + _Age + "','" + _CreateDate + "','" + _CreateUser + "'," + _DepartmentID + "," + _DutyID + ",'" + _Email + "','" + _FarmID + "','" + _Info + "','" + _IsAdvance + "','" + _IsAudit + "','" + _IsLock + "','" + _IsSystem + "','" + _Names + "','" + _Password + "','" + _RegionID + "','" + _Sex + "','" + _SystemID + "','" + _Telephone + "','" + _UserCode + "','" + _UserID + "','" + _ZIP + "') ";
        }

        public string UpdateSql()
        {
            return " update " + Tn.Sys_Users + " " +
                        " set " + cAddress + "='" + _Address + "'," + cAge + "='" + _Age + "'," + cCreateDate + "='" + _CreateDate + "'," + cCreateUser + "='" + _CreateUser + "'," + cDepartmentID + "=" + _DepartmentID + "," + cDutyID + "=" + _DutyID + "," + cEmail + "='" + _Email + "'," + cFarmID + "='" + _FarmID + "'," + cInfo + "='" + _Info + "'," + cIsAdvance + "='" + _IsAdvance + "'," + cIsAudit + "='" + _IsAudit + "'," + cIsLock + "='" + _IsLock + "'," + cIsSystem + "='" + _IsSystem + "'," + cNames + "='" + _Names + "'," + cPassword + "='" + _Password + "'," + cRegionID + "='" + _RegionID + "'," + cSex + "='" + _Sex + "'," + cSystemID + "='" + _SystemID + "'," + cTelephone + "='" + _Telephone + "'," + cUserCode + "='" + _UserCode + "'," + cZIP + "='" + _ZIP + "' " +
                        " where  " + cUserID + "='" + _UserID + "'";
        }

        public string DeleteSql()
        {
            return "Delete " + Tn.Sys_Users + " where " + cUserID + "='" + _UserID + "'";
        }

        public bool ChangePassword(DBConnSql poConn)
        {
            string lcSql = "update " + Tn.Sys_Users + "  set " + Sys_Users_info.cPassword + "='" + _Password + "' where " + Sys_Users_info.cUserID + "='" + _UserID + "'";
            return poConn.ExcuteSqlTran(lcSql);
        }

        public bool InsertRecord(UserSession poSession, ref string pcError)
        {
            bool lbRetVal = false;
            string lcSql = "select " + Sys_Users_info.cUserCode + " from " + Tn.Sys_Users + " where  " + Sys_Users_info.cUserCode + "='" + this.UserCode + "'";
            rsQuery loQuery = poSession.DBConn.OpenQuery(lcSql);
            if (loQuery != null && loQuery.IsOpened && loQuery.RecCount == 0)
            {
                this.UserID = this.GSSystem.SystemID.Trim() + "_" + this.UserCode.Trim();
                this.CreateDate = DateTime.Now.ToShortDateString() + " " + DateTime.Now.ToShortTimeString();
                this._CreateUser = poSession.UserInfo.UserCode;

                lbRetVal = poSession.DBConn.ExcuteSqlTran(this.InsertSql());
                if (lbRetVal)
                {
                    //如果是市场帐号的用户添加的USER 则 在userhasmarket的表中添加 跟该帐号同样的市场
                    if (poSession.IsMarketSysAccount)
                    {
                        lbRetVal = UserHasMarket_info.UpdateMarketsOfUser(this.UserID, poSession.MarketId, poSession.DBConn);
                        if (!lbRetVal)
                        {
                            pcError = "数据出错:" + poSession.DBConn.ErrorMsg;
                        }
                    }

                }
            }
            else
            {
                pcError = "数据出错,可能该用户编号已经存在";
            }
            if (!lbRetVal)
            {
                pcError = poSession.DBConn.ErrorMsg;
            }
            return lbRetVal;
        }

        public bool UpdateRecord(UserSession poSession)
        {
            bool lbRetVal = false;
            lbRetVal = poSession.DBConn.ExcuteSqlTran(UpdateSql());
            return lbRetVal;
        }

        public static rsQuery GetAllUsers(string pcLock, DBConnSql poConn)
        {
            string lcSql = "select " + Sys_Users_info.cUserID + "," + Sys_Users_info.cNames + "  from " + Tn.Sys_Users + "  where  " + Sys_Users_info.cIsLock + "='" + pcLock + "'  order by " + Sys_Users_info.cUserID + " desc ";
            return poConn.OpenQuery(lcSql);
        }


        public static void SetUsersToList(ListControl poControl, rsQuery poQuery)
        {
            if (poQuery != null && poQuery.IsOpened && poQuery.RecCount > 0 && poControl != null)
            {
                poControl.Items.Clear();
                poQuery.MoveFirst();
                for (int i = 0; i < poQuery.RecCount; i++)
                {
                    string lcId = poQuery.GetString(Sys_Users_info.cUserID);
                    string lcName = poQuery.GetString(Sys_Users_info.cNames);
                    // string lcType = poQuery.GetString(Sys_Users_info.cAccountType);
                    // lcType = (lcType == "0" ? "市场系统" : "工商系统");
                    poControl.Items.Add(new ListItem(lcName, lcId));
                    poQuery.MoveNext();
                }
            }
        }

        public static string GetUserListSql(UserSession poSession)
        {
            string lcRetVal = "select * from " + Tn.v_viewUsers + " where 1=1 ";

            switch (poSession.AT)
            {
                case AcountType.Advance: // 高级帐号 获取所在区域里用户帐号 如一分局帐号只能管理 一分局的相关用户
                    string lcRegoins = Regions_info.GetAllRegion(poSession.DBConn, poSession.UserInfo.RegionID);
                    if (lcRetVal.Trim().Length > 0)
                    {
                        lcRetVal += " and " + v_viewUsers_info.cRegionID + " in ( " + lcRegoins + " ) ";
                    }
                    else
                    {
                        lcRetVal += " and  1=2 ";
                    }
                    break;
                case AcountType.AdvanceMarket: // 高级 市场用户
                    string pcUserIds = "";
                    string pcUserList = UserHasMarket_info.GetUserListByMarketId(poSession.MarketId, poSession.DBConn);
                    if (pcUserList.Trim().Length > 0)
                    {
                        string lcSql = "select * from " + Tn.Sys_Users + " where " + Sys_Users_info.cUserID + " in ( " + pcUserList + " )";
                        lcSql = " select " + v_viewUsers_info.cSystemType +","+v_viewUsers_info.cUserID +" from  " + Tn.v_viewUsers + " where " + v_viewUsers_info.cUserID + " in ( " + pcUserList + " )";
                        rsQuery loQuery = poSession.DBConn.OpenQuery(lcSql);
                        if (loQuery != null && loQuery.IsOpened && loQuery.RecCount > 0)
                        {
                            loQuery.MoveFirst();
                            for (int i = 0; i < loQuery.RecCount; i++)
                            {
                                if (!loQuery.GetBool(v_viewUsers_info.cSystemType))
                                {
                                    pcUserIds += (pcUserIds == "" ? "" : ",") + "'" + loQuery.GetString(v_viewUsers_info.cUserID) + "'";
                                }
                                loQuery.MoveNext();
                            }
                        }
                    }
                    if (pcUserIds.Trim().Length > 0)
                    {
                        lcRetVal += " and " + v_viewUsers_info.cUserID + " in ( " + pcUserIds + " ) ";
                    }
                    else
                    {
                        lcRetVal += " and  1=2 ";
                    }
                    break;
                case AcountType.Common:
                case AcountType.CommonMarket:
                    lcRetVal += " and  1=2 ";
                    break;
            }
            return lcRetVal;
        }
    }
    #endregion

    #region

    public class Sys_Users_Qry : rsQuery
    {
        public String Address
        {
            get { return GetString(Sys_Users_info.cAddress); }
            //    set { SetField(Sys_Users_info.cAddress, value); } 
        }

        public String Age
        {
            get { return GetString(Sys_Users_info.cAge); }
            //    set { SetField(Sys_Users_info.cAge, value); } 
        }

        public DateTime CreateDate
        {
            get { return GetDateTime(Sys_Users_info.cCreateDate); }
            //    set { SetField(Sys_Users_info.cCreateDate, value); } 
        }

        public String CreateUser
        {
            get { return GetString(Sys_Users_info.cCreateUser); }
            //    set { SetField(Sys_Users_info.cCreateUser, value); } 
        }

        public Int64 DepartmentID
        {
            get { return GetInt(Sys_Users_info.cDepartmentID); }
            //    set { SetField(Sys_Users_info.cDepartmentID, value); } 
        }

        public Int64 DutyID
        {
            get { return GetInt(Sys_Users_info.cDutyID); }
            //    set { SetField(Sys_Users_info.cDutyID, value); } 
        }

        public String Email
        {
            get { return GetString(Sys_Users_info.cEmail); }
            //    set { SetField(Sys_Users_info.cEmail, value); } 
        }

        public String FarmID
        {
            get { return GetString(Sys_Users_info.cFarmID); }
            //    set { SetField(Sys_Users_info.cFarmID, value); } 
        }

        public String Info
        {
            get { return GetString(Sys_Users_info.cInfo); }
            //    set { SetField(Sys_Users_info.cInfo, value); } 
        }

        public Boolean IsAdvance
        {
            get { return GetBool(Sys_Users_info.cIsAdvance); }
            //    set { SetField(Sys_Users_info.cIsAdvance, value); } 
        }

        public Boolean IsAudit
        {
            get { return GetBool(Sys_Users_info.cIsAudit); }
            //    set { SetField(Sys_Users_info.cIsAudit, value); } 
        }

        public Boolean IsLock
        {
            get { return GetBool(Sys_Users_info.cIsLock); }
            //    set { SetField(Sys_Users_info.cIsLock, value); } 
        }

        public Boolean IsSystem
        {
            get { return GetBool(Sys_Users_info.cIsSystem); }
            //    set { SetField(Sys_Users_info.cIsSystem, value); } 
        }

        public String Names
        {
            get { return GetString(Sys_Users_info.cNames); }
            //    set { SetField(Sys_Users_info.cNames, value); } 
        }

        public String Password
        {
            get { return GetString(Sys_Users_info.cPassword); }
            //    set { SetField(Sys_Users_info.cPassword, value); } 
        }

        public String RegionID
        {
            get { return GetString(Sys_Users_info.cRegionID); }
            //    set { SetField(Sys_Users_info.cRegionID, value); } 
        }

        public String Sex
        {
            get { return GetString(Sys_Users_info.cSex); }
            //    set { SetField(Sys_Users_info.cSex, value); } 
        }

        public String SystemID
        {
            get { return GetString(Sys_Users_info.cSystemID); }
            //    set { SetField(Sys_Users_info.cSystemID, value); } 
        }

        public String Telephone
        {
            get { return GetString(Sys_Users_info.cTelephone); }
            //    set { SetField(Sys_Users_info.cTelephone, value); } 
        }

        public String UserCode
        {
            get { return GetString(Sys_Users_info.cUserCode); }
            //    set { SetField(Sys_Users_info.cUserCode, value); } 
        }

        public String UserID
        {
            get { return GetString(Sys_Users_info.cUserID); }
            //    set { SetField(Sys_Users_info.cUserID, value); } 
        }

        public String ZIP
        {
            get { return GetString(Sys_Users_info.cZIP); }
            //    set { SetField(Sys_Users_info.cZIP, value); } 
        }

    }
    #endregion

}