/// <summary> /// Checks the authentication. /// </summary> /// <param name="name">模块名称.</param> /// <returns><c>true</c> if XXXX, <c>false</c> otherwise.</returns> public static bool CheckAuth(string name) { try { if (ConstDef.curUser == null) { return(false); } Authority auth = Find(string.Format("name = '{0}'", name)); if (auth == null) { return(false); } if (ConstDef.curUser.RoleId > auth.Role.Id) { return(false); } else { return(true); } } catch (Exception ex) { LogMan.Log2File(null, ex); return(false); } }
/// <summary> /// 初始化数据库. /// </summary> public void InitDatabase() { try { SQLiteConnection.CreateFile(dbName); this.Open("Data Source=" + dbName + ";Version=3;"); this.InitTables(); this.InitRoleData(); this.InitUserData(); this.InitAuthData(); } catch (Exception ex) { LogMan.Log2File(null, ex); } }
/// <summary> /// 执行sql事务 /// </summary> /// <param name="sql">The SQL.</param> /// <returns><c>true</c> if XXXX, <c>false</c> otherwise.</returns> public bool ExecuteNonQuery(string sql) { SQLiteCommand sQLiteCommand = new SQLiteCommand(sql, this.connection); SQLiteTransaction sQLiteTransaction = this.connection.BeginTransaction(); try { sQLiteCommand.ExecuteNonQuery(); sQLiteTransaction.Commit(); return(true); } catch (Exception ex) { sQLiteTransaction.Rollback(); LogMan.Log2File(null, ex); return(false); } finally { this.Close(); } }