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); }
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); }
public static Database GetDatabase() { return(LogicContext.GetDatabase(AppConfig.DefaultDbId)); }