Esempio n. 1
0
        internal bool RewriteAuthSession()
        {
            DateTime dateTime = AppRuntime.ServerDateTime;
            bool     flag     = dateTime <= this.UpdateTime;

            if (flag)
            {
                dateTime = this.UpdateTime.AddSeconds(1.0);
            }
            bool flag2 = !(this.RewriteAuthTime < dateTime);
            bool result;

            if (flag2)
            {
                result = false;
            }
            else
            {
                Database database = LogicContext.GetDatabase();
                HSQL     sql      = new HSQL(database);
                sql.Raw = true;
                sql.Clear();
                sql.Add("update AUTH set ");
                sql.Add("   AUTH_USERID = :AUTH_USERID,");
                sql.Add("   AUTH_LOGINTIME = :AUTH_LOGINTIME,");
                sql.Add("   AUTH_LOGINTYPE = :AUTH_LOGINTYPE,");
                sql.Add("   AUTH_CLIENTIP = :AUTH_CLIENTIP,");
                sql.Add("   AUTH_CLIENTNAME = :AUTH_CLIENTNAME,");
                sql.Add("   AUTH_DBID = :AUTH_DBID,");
                sql.Add("   AUTH_LASTREFRESH = :AUTH_LASTREFRESH,");
                sql.Add("   AUTH_LASTREQUEST = :AUTH_LASTREQUEST,");
                sql.Add("   AUTH_UPDATETIME = :AUTH_UPDATETIME,");
                sql.Add("   AUTH_EXINFO = :AUTH_EXINFO");
                sql.Add("where AUTH_SESSIONID = :AUTH_SESSIONID");
                sql.ParamByName("AUTH_USERID").Value      = this.UserId;
                sql.ParamByName("AUTH_LOGINTIME").Value   = this.LoginTime;
                sql.ParamByName("AUTH_LOGINTYPE").Value   = this.LoginType.ToString();
                sql.ParamByName("AUTH_CLIENTIP").Value    = this.ClientIp;
                sql.ParamByName("AUTH_CLIENTNAME").Value  = this.ClientName;
                sql.ParamByName("AUTH_DBID").Value        = this.DbId;
                sql.ParamByName("AUTH_LASTREFRESH").Value = this.LastRefreshTime;
                sql.ParamByName("AUTH_LASTREQUEST").Value = this.LastRequestTime;
                sql.ParamByName("AUTH_UPDATETIME").Value  = this.UpdateTime;
                sql.ParamByName("AUTH_EXINFO").Value      = this.ExInfo;
                sql.ParamByName("AUTH_SESSIONID").Value   = this.SessionId;
                database.ExecSQL(sql);
                this.UpdateTime      = dateTime;
                this.RewriteAuthTime = AppRuntime.ServerDateTime.AddMinutes(5.0);
                result = true;
            }
            return(result);
        }
Esempio n. 2
0
        internal static DateTime GetDbServerDateTime()
        {
            DateTime dateTime = DateTime.Now;

            try
            {
                Database database = LogicContext.GetDatabase(new DbConfig("DBCFG", AppConfig.DefaultDbDesc, AppConfig.DbMS, AppConfig.DbServer));
                HSQL     sql      = new HSQL(database);
                sql.Clear();
                sql.Raw = true;
                bool flag = database.Driver == DbProviderType.MSSQL;
                if (flag)
                {
                    sql.Add("select getdate()");
                }
                else
                {
                    bool flag2 = database.Driver == DbProviderType.ORACLE;
                    if (flag2)
                    {
                        sql.Add("select sysdate from dual");
                    }
                }
                object obj   = database.ExecScalar(sql);
                bool   flag3 = obj != null;
                if (flag3)
                {
                    dateTime = (DateTime)obj;
                }
            }
            catch
            {
                dateTime = DateTime.Now;
            }
            return(dateTime);
        }
Esempio n. 3
0
 public static Database GetDatabase()
 {
     return(LogicContext.GetDatabase(AppConfig.DefaultDbId));
 }