public int ExecuteNonQuery(IConnectionCustom Connection, ICommandCustom Command) { if (Connection == null) { Connection = _dbConnection; } Command.IDbCommand.CommandTimeout = 600; PrepareCommand(Command.IDbCommand, Connection.iDbConnection, (SqlTransaction)null); int retval = -1; try { retval = Command.IDbCommand.ExecuteNonQuery(); } catch (Exception ex) { throw ex; } Command.IDbCommand.Parameters.Clear(); if (Connection.iDbConnection.State != ConnectionState.Closed) { Connection.iDbConnection.Close(); } return(retval); }
public bool ExecuteNonQuery(IConnectionCustom Connection, List <ICommandCustom> CommandList) { if (Connection == null) { Connection = _dbConnection; } if (Connection == null) { throw new Exception("数据库连接SqlConnection对象不存在"); } if (CommandList == null) { throw new Exception("SqlBaseCommand不存在"); } if (CommandList.Count == 0) { throw new Exception("SqlBaseCommand只有O条"); } if (CommandList.Count == 1) { return(((CommandCustom)CommandList[0]).comparison(ExecuteNonQuery(Connection, CommandList[0]))); } else { SqlTransactionCustom Transaction = new SqlTransactionCustom(Connection.iDbConnection); Transaction.BeginTransaction(); try { CommandCustom Command; for (int i = 0; i < CommandList.Count; i++) { Command = ((CommandCustom)CommandList[i]); Command.ComparisonTypeCustom = ComparisonTypeCustom.ThanEqual; if (!Command.comparison(ExecuteNonQuery(Transaction, Command))) { Transaction.Rollback(); return(false); } } Transaction.Commit(); return(true); } catch (Exception ex) { Transaction.Rollback(); throw ex; } } }
public ConnectionCustom(string connectionString) { _connectionString = connectionString; switch (DatabaseTypeCustom) { case DatabaseTypeCustom.Sql: _ConnectionCustom = new SqlConnectionCustom(connectionString); break; //case DatabaseTypeCustom.Oracle: // _ConnectionCustom = new FWMySqlConnection(connectionString); // break; //case DatabaseTypeCustom.Odbc: // _ConnectionCustom = new FWOdbcConnection(connectionString); // break; //case DatabaseTypeCustom.OleDb: // _ConnectionCustom = new FWOleDbConnection(connectionString); // break; //case DatabaseTypeCustom.MySql: // _ConnectionCustom = new FWMySqlConnection(connectionString); // break; } }
public int ExecuteNonQuery(IConnectionCustom Connection, ICommandCustom Command) { return(_iFWCommandHelper.ExecuteNonQuery(Connection, Command)); }
public static List <T> queryList <T>(IConnectionCustom connection, ICommandCustom command) { SqlEntityToCommandCustom sqlEntityToCommandCustom = new SqlEntityToCommandCustom(); return(sqlEntityToCommandCustom.queryList <T>(connection, command)); }
public static List <T> queryList <T>(IConnectionCustom connection, ICommandCustom command) { EntityToCommandCustom fwEntityToFWCommand = new EntityToCommandCustom(command.DatabaseTypeCustom); return(fwEntityToFWCommand.queryList <T>(connection, command)); }
public CommandCustom(IConnectionCustom connectionCustom) : this(connectionCustom != null ? connectionCustom.DatabaseTypeCustom : (new ConnectionCustom()).DatabaseTypeCustom) { }
public EntityToCommandCustom(IConnectionCustom fwConnection) : this(fwConnection != null ? fwConnection.DatabaseTypeCustom : (new ConnectionCustom()).DatabaseTypeCustom) { }
public T query <T>(IConnectionCustom connection, string afterWhereSql, List <IParameterCustom> afterWhereSqlParams) { return(entityToCommandCustom.query <T>(connection, afterWhereSql, afterWhereSqlParams)); }
public CommandCustomHelper(IConnectionCustom iConnectionCustom) : this(iConnectionCustom.DatabaseTypeCustom) { _connectionString = iConnectionCustom.connectionString; }
public DataTable ExecuteDataTable(IConnectionCustom Connection, ICommandCustom Command) { return(ExecuteDataSet(Connection, Command).Tables[0]); }
public DataSet ExecuteDataSet(IConnectionCustom Connection, ICommandCustom Command) { return(ExecuteDataSet(Connection.iDbConnection, Command.IDbCommand)); }
public static List <IDbResultCustom> insertOrUpdate <T>(IConnectionCustom connection, List <T> entityList, List <string> idPropertyNameList) { SqlEntityToCommandCustom sqlEntityToCommandCustom = new SqlEntityToCommandCustom(); return(sqlEntityToCommandCustom.insertOrUpdate <T>(connection, entityList, idPropertyNameList)); }
public DataTable ExecuteDataTable(IConnectionCustom Connection, ICommandCustom Command) { return(_iFWCommandHelper.ExecuteDataTable(Connection, Command)); }
public static int ExecuteNonQuery(IConnectionCustom Connection, ICommandCustom Command) { CommandCustomHelper fwCommandHelper = new CommandCustomHelper(Connection); return(fwCommandHelper.ExecuteNonQuery(Connection, Command)); }
public bool ExecuteNonQuery(IConnectionCustom Connection, List <ICommandCustom> CommandList) { return(_iFWCommandHelper.ExecuteNonQuery(Connection, CommandList)); }
public static DataTable ExecuteDataTable(IConnectionCustom Connection, ICommandCustom Command) { CommandCustomHelper fwCommandHelper = new CommandCustomHelper(Connection); return(fwCommandHelper.ExecuteDataTable(Connection, Command)); }
public List <IDbResultCustom> insertOrUpdate <T>(IConnectionCustom connection, List <T> entityList, List <string> idPropertyNameList, List <string> uniquePropertyNameList) { return(entityToCommandCustom.insertOrUpdate(connection, entityList, idPropertyNameList, uniquePropertyNameList)); }
public static DataTable ExecuteDataTable(IConnectionCustom Connection, ICommandCustom Command) { SqlCommandHelper commandHelper = new SqlCommandHelper(); return(commandHelper.ExecuteDataTable(Connection, Command)); }
public List <T> queryList <T>(IConnectionCustom connection, ICommandCustom fwcmd) { return(entityToCommandCustom.queryList <T>(connection, fwcmd)); }
public static bool ExecuteNonQuery(IConnectionCustom Connection, List <ICommandCustom> CommandList) { SqlCommandHelper commandHelper = new SqlCommandHelper(); return(commandHelper.ExecuteNonQuery(Connection, CommandList)); }
public IDbResultCustom insertOrUpdate <T>(IConnectionCustom connection, T entity, List <string> idPropertyNameList) { return(entityToCommandCustom.insertOrUpdate(connection, entity, idPropertyNameList)); }
public static int ExecuteNonQuery(IConnectionCustom Connection, ICommandCustom Command) { SqlCommandHelper commandHelper = new SqlCommandHelper(); return(commandHelper.ExecuteNonQuery(Connection, Command)); }
public static T query <T>(IConnectionCustom connection, string afterWhereSql, List <IParameterCustom> afterWhereSqlParams) { EntityToCommandCustom fwEntityToFWCommand = new EntityToCommandCustom(connection); return(fwEntityToFWCommand.query <T>(connection, afterWhereSql, afterWhereSqlParams)); }
public int ExecuteScalar(IConnectionCustom Connection, ICommandCustom Command) { return(_iFWCommandHelper.ExecuteScalar(Connection, Command)); }
public static List <IDbResultCustom> insertOrUpdate <T>(IConnectionCustom connection, List <T> entityList, List <string> idPropertyNameList) { EntityToCommandCustom fwEntityToFWCommand = new EntityToCommandCustom(connection); return(fwEntityToFWCommand.insertOrUpdate <T>(connection, entityList, idPropertyNameList)); }
public static T query <T>(IConnectionCustom connection, string afterWhereSql, List <IParameterCustom> afterWhereSqlParams) { SqlEntityToCommandCustom sqlEntityToCommandCustom = new SqlEntityToCommandCustom(); return(sqlEntityToCommandCustom.query <T>(connection, afterWhereSql, afterWhereSqlParams)); }