public Boolean UpdateDatabase(DataTable dataTable) { if (DbType == DatabaseType.MSSqlServer) { return(SqlServerConnection.UpdateDatabase(dataTable)); } else if (DbType == DatabaseType.SqLite) { return(SqliteConnection.Instance.UpdateDatabase(dataTable)); } else { throw new ArgumentException(); } }
public void ExecuteQueryUsingCache(string selectCommandText) { if (DbType == DatabaseType.MSSqlServer) { SqlServerConnection.ExecuteQuery_delay(selectCommandText); } else if (DbType == DatabaseType.SqLite) { throw new NotImplementedException(); } else { throw new ArgumentException(); } }
public int ExecuteUpdate(string commandText) { if (DbType == DatabaseType.MSSqlServer) { return(SqlServerConnection.ExecuteUpdate(commandText)); } else if (DbType == DatabaseType.SqLite) { return(SqliteConnection.Instance.ExecuteUpdate(commandText)); } else { throw new ArgumentException(); } }
public DataTable ExecuteQuery(string selectCommandText) { if (DbType == DatabaseType.MSSqlServer) { return(SqlServerConnection.ExecuteQuery(selectCommandText)); } else if (DbType == DatabaseType.SqLite) { return(SqliteConnection.Instance.ExecuteQuery(selectCommandText)); } else { throw new ArgumentException(); } }
public Boolean ConnectionOpenned() { if (DbType == DatabaseType.MSSqlServer) { return(SqlServerConnection.ConnectionOpenned()); } else if (DbType == DatabaseType.SqLite) { return(SqliteConnection.Instance.ConnectionOpenned()); } else { throw new ArgumentException(); } }
public static void CloseConnection() { if (!ConnectionOpenned()) { return; } try { SqlServerConnection.GetConnection().Close(); } catch (Exception) { throw; } }
/// <summary> /// 清除所有缓存并提交到数据库,自定义Cache文件路径 /// </summary> /// <returns></returns> public static int CleanDbAndExecuteTasks(string cacheFilename) { int effectedRows = 0; string[] commands = GetAllLines(cacheFilename); if (commands == null) { return(-1); } foreach (string str in commands) { int tmp = SqlServerConnection.ExecuteUpdate(str); effectedRows += tmp > 0 ? tmp : 0; } File.Delete(cacheFilename); return(effectedRows); }
/// <summary> /// 清除所有缓存并提交到数据库,自定义Cache文件路径 /// </summary> /// <returns></returns> public static int CleanDbAndExecuteTasks(string cacheFilename) { int effectedRows = 0; string[] commands = GetAllLines(cacheFilename); if (commands == null) { return(-1); } try { effectedRows = SqlServerConnection.ExecuteSqlWithGoUseTran(commands); File.Delete(cacheFilename); return(effectedRows); } catch (Exception) { throw; } }
public static void OpenConnection() { if (ConnectionOpenned()) { return; } if (GetConnection().State == ConnectionState.Connecting) { throw new Exception("无法建立数据库连接,数据库状态为正在连接"); } try { TimeUtil.Tik(); SqlServerConnection.GetConnection().Open(); TimeUtil.Tok(); } catch (Exception) { throw; } }