/// <summary> /// 初次使用创建数据库 /// </summary> public static void CreateDataBase() { try { bool isExist = File.Exists(DataPath); if (!isExist) { SQLiteConnection.CreateFile(DataPath); } conn = new SQLiteConnection(ConnStr); conn.Open(); comm = conn.CreateCommand(); if (!isExist) { String sql = "Create table ReceiveData(DeviceNum INTEGER , Temperature INTEGER , Humidity INTEGER , Tyrere INTEGER , MotorState INTEGER , ErrorNum INTEGER , CreateDate DateTime);"; comm.CommandText = sql; comm.CommandType = CommandType.Text; comm.ExecuteNonQuery(); } } catch (Exception e) { } }
public void duiQuery(string QueryString) { using (_curConnection = _curDataObjFactory.CreateConnection()) { try { _curConnection.ConnectionString = _connectionString; _curConnection.Open(); using (DbCommand curCommand = _curDataObjFactory.CreateCommand()) { curCommand.Connection = _curConnection; curCommand.CommandText = QueryString; curCommand.ExecuteNonQuery(); } } catch (Exception) { throw; } finally { _curConnection.Close(); } } }
public override void Connect_To_Database(StorageConfig config) { myConfig = config as SQLiteConfig; if (myConfig == null) throw new Exception("Database Config is NULL"); if (!FileNameLockObjects.ContainsKey(myConfig.DatabaseFile)) FileNameLockObjects.Add(myConfig.DatabaseFile,new object()); try { myDBConn = new SQLiteConnection(ConnectionString); myDBConn.Open(); if (myDBConn.State != System.Data.ConnectionState.Open) throw new Exception("Unable to Open Database. Storage:" + config.Name); } catch (SQLiteException ex) { throw ex; } catch (Exception ex) { throw ex; } }
public Manager(String fileName) { localization = new System.ComponentModel.ComponentResourceManager(typeof(WorkerTimeStrings)); this.fileName = fileName; if (File.Exists(fileName)) { this.sqlConnection = new SQLiteConnection("Data Source=" + fileName ); this.sqlCommand = this.sqlConnection.CreateCommand(); sqlConnection.Open(); } else { this.sqlConnection = new SQLiteConnection("Data Source=" + fileName); this.sqlCommand = this.sqlConnection.CreateCommand(); sqlConnection.Open(); ExecuteNonQuery("CREATE TABLE Tracks ([ID] INTEGER PRIMARY KEY AUTOINCREMENT, [ProjectID] INTEGER, [ActivityID] INTEGER, [Start] DATETIME, [End] DATETIME, [Duration] INTEGER)"); ExecuteNonQuery("CREATE TABLE Projects ([ID] INTEGER PRIMARY KEY AUTOINCREMENT, [Name] TEXT)"); ExecuteNonQuery("CREATE TABLE Activity ([ID] INTEGER PRIMARY KEY AUTOINCREMENT, [Name] TEXT, [ProjectID] INTEGER)"); if (MessageBox.Show(localization.GetString("String10"), localization.GetString("String3"), MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes ) { ExecuteNonQuery("INSERT INTO Projects (Name) VALUES ('" + localization.GetString("String12") + " 1')"); ExecuteNonQuery("INSERT INTO Projects (Name) VALUES ('" + localization.GetString("String12") + " 2')"); ExecuteNonQuery("INSERT INTO Projects (Name) VALUES ('" + localization.GetString("String12") + " 3')"); ExecuteNonQuery("INSERT INTO Activity (Name,ProjectID) VALUES ('" + localization.GetString("String13") + " 1',1)"); ExecuteNonQuery("INSERT INTO Activity (Name,ProjectID) VALUES ('" + localization.GetString("String13") + " 2',1)"); ExecuteNonQuery("INSERT INTO Activity (Name,ProjectID) VALUES ('" + localization.GetString("String13") + " 3',1)"); ExecuteNonQuery("INSERT INTO Activity (Name,ProjectID) VALUES ('" + localization.GetString("String13") + " 1',2)"); ExecuteNonQuery("INSERT INTO Activity (Name,ProjectID) VALUES ('" + localization.GetString("String13") + " 2',2)"); ExecuteNonQuery("INSERT INTO Activity (Name,ProjectID) VALUES ('" + localization.GetString("String13") + " 3',2)"); } } Update1(); }
public SqlFuConnection(DbConnection cnx,DbEngine engine) { cnx.MustNotBeNull(); _conex = cnx; _provider = ProviderFactory.GetProvider(engine); _conex.Open(); }
public MachineParamsManager(Guid plowmachineId, Metadata.MetadataManager manager) { _plowMachineId = plowmachineId; _manager = manager; _connection = DBConnectionProvider.GetConnection(); _connection.Open(); }
/// <summary> /// Resolve at run time the appropriate set of DbParameters for a stored procedure /// </summary> /// <param name="transaction">A valid SqlTransaction object</param> /// <param name="connection">A valid SqlConnection object</param> /// <param name="storedProcedureName">The name of the stored procedure</param> /// <param name="includeReturnValueParameter">Whether or not to include their return value parameter</param> /// <returns>The parameter array discovered.</returns> private static IList<SqlParameter> DiscoverSpParameterSet(DbTransaction transaction, DbConnection connection, string storedProcedureName, bool includeReturnValueParameter) { using (SqlCommand cmd = new SqlCommand(storedProcedureName, connection as SqlConnection)) { if (connection.State != ConnectionState.Open) { connection.Open(); } cmd.CommandType = CommandType.StoredProcedure; if (transaction != null) { cmd.Transaction = transaction as SqlTransaction; } SqlCommandBuilder.DeriveParameters(cmd); if (!includeReturnValueParameter) { cmd.Parameters.RemoveAt(0); } SqlParameter[] discoveredParameters = new SqlParameter[cmd.Parameters.Count]; cmd.Parameters.CopyTo(discoveredParameters, 0); return discoveredParameters; } }
public void Setup() { var factory = new DatabaseProviderFactory(TestConfigurationSource.CreateConfigurationSource()); var db = factory.CreateDefault(); connection = db.CreateConnection(); connection.Open(); }
}//Execute(string sql) /// <summary> /// 执行Sql语句 /// </summary> /// <param name="sql">Sql语句</param> /// <param name="Conn">数据库连接对象</param> /// <param name="param">参数</param> /// <returns>返回受影响行数</returns> static public int Execute(string sql, System.Data.Common.DbConnection Conn, System.Data.Common.DbParameter[] param) { if (Conn == null) { DBClassHelper.ErrLog("DBClassHelper.Execute(string sql, System.Data.Common.DbConnection Conn, System.Data.Common.DbParameter[] param):连接对象为空!"); return(0); } if (Conn.State == System.Data.ConnectionState.Closed) { Conn.Open(); } System.Data.IDbCommand cmd = Conn.CreateCommand(); cmd.CommandTimeout = 180; cmd.CommandText = sql; for (int i = 0; i < param.Length; i++) { cmd.Parameters.Add(param[i]); } try { return(cmd.ExecuteNonQuery()); } catch (Exception ex) { DBClassHelper.ErrLog("DBClassHelper.Execute(string sql, System.Data.Common.DbConnection Conn, System.Data.Common.DbParameter[] param):" + ex.Message + "/nsql=" + sql); return(0); } }//Execute(string sql,System.Data.IDataParameter[] param)
public bool DeleteProduct(int exchangeId, int productId) { bool result = false; using (System.Data.Common.DbConnection dbConnection = this.database.CreateConnection()) { dbConnection.Open(); System.Data.Common.DbTransaction dbTransaction = dbConnection.BeginTransaction(); System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand("delete from Hishop_PointExChange_Products where [exChangeId]= @exChangeId and [ProductId] = @ProductId "); this.database.AddInParameter(sqlStringCommand, "exChangeId", System.Data.DbType.Int32, exchangeId); this.database.AddInParameter(sqlStringCommand, "ProductId", System.Data.DbType.Int32, productId); System.Data.Common.DbCommand sqlStringCommand2 = this.database.GetSqlStringCommand("update Hishop_PointExChange_PointExChanges set ProductNumber=ProductNumber-1 where Id=@Id"); this.database.AddInParameter(sqlStringCommand2, "Id", System.Data.DbType.Int32, exchangeId); try { this.database.ExecuteNonQuery(sqlStringCommand, dbTransaction); this.database.ExecuteNonQuery(sqlStringCommand2, dbTransaction); dbTransaction.Commit(); result = true; } catch { dbTransaction.Rollback(); result = false; } finally { if (dbTransaction.Connection != null) { dbConnection.Close(); } } } return(result); }
/// <summary> /// Ham nay de mo ket noi den database /// </summary> /// <param name="ServerName"></param> /// <param name="DatabaseName"></param> /// <param name="UserId"></param> /// <param name="Password"></param> /// <returns></returns> public static bool DB_OpenConnection(string ServerName, string DatabaseName, string UserId, string Password) { DbProviderFactory = System.Data.SqlClient.SqlClientFactory.Instance; DbConnectionStringBuilder DbConnectionStringBuilder = DbProviderFactory.CreateConnectionStringBuilder(); DbConnectionStringBuilder.Add("Data Source", ServerName); DbConnectionStringBuilder.Add("User ID", UserId); DbConnectionStringBuilder.Add("Password", Password); DbConnectionStringBuilder.Add("Initial Catalog", DatabaseName); bool IsConnected; try { if (DbConnection == null) { DbConnection = DbProviderFactory.CreateConnection(); } if (DbConnection.State != ConnectionState.Open) { DbConnection.ConnectionString = DbConnectionStringBuilder.ConnectionString; DbConnection.Open(); } IsConnected = true; } catch { IsConnected = false; } return(IsConnected); }
public void select(DbConnection conn) { if (conn.State != ConnectionState.Open) conn.Open(); DataTable tb = new DataTable(); DbCommand dbCommand = conn.CreateCommand(); string selectQuery = DISCOUNTCURVESETTING_Table_DAO.SelectQuery_; selectQuery = selectQuery.Replace("@KeyColumnValue@", this.KeyColumn_); dbCommand.CommandText = selectQuery; //DbDataAdapter dataAdapter = new DbDataAdapter(dbCommand, conn); DbDataAdapter dataAdapter = DataBaseConnectManager.CreateDataAdapter(dbCommand, conn); dataAdapter.Fill(tb); DataRow[] dr = tb.Select(); int rowCount = dr.Length; if (!(rowCount == 0 || rowCount == 1)) { throw new Exception(); } foreach (DataRow item in dr) { this.CURRENCY_ = item[0].ToString(); this.CURVECODE_ = item[1].ToString(); this.PROVIDER_ = item[2].ToString(); } }
public void OpenConnection(DbConnection dbc) { if (dbc.State == ConnectionState.Closed) { dbc.Open(); } }
public DatabaseAccessTests() { _conn = SQLitePortability.CreateConnection(); _conn.Open(); _db = new DatabaseAccess(_conn, new SQLiteDetails()); }
public bool Fun_OpenDataBase() { String sConnect = ""; try { if (this.DBConn != null) { if (this.DBConn.State == System.Data.ConnectionState.Open) { this.DBConn.Close(); } } //sConnect = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + DBPath; sConnect = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + DBPath; DBConn = new OleDbConnection(); DBCommand = new OleDbCommand(); DBConn.ConnectionString = sConnect; DBConn.Open(); return(true); } catch (Exception) { return(false); } }
public void Open(string aConnectionString, ServerType serverType) { dbCache.ConnectionString = aConnectionString; dbCache.ServerType = serverType; switch (serverType) { case ServerType.Firebird: connection = new FbConnection {ConnectionString = aConnectionString}; break; case ServerType.MsSql: connection = new SqlConnection { ConnectionString = aConnectionString }; break; } connection.Open(); if (serverType==ServerType.Firebird) using (var transaction = connection.BeginTransaction()) { DbData.GetFieldValue(connection, transaction, "select rdb$set_context('USER_SESSION','RPL_SERVICE','1') from rdb$database;"); transaction.Commit(); } var t = new Thread(LoadData); t.Start(); }
protected internal virtual IDbCommandWrap GetCommandWrap(IStatementSetting statement) { DbConnection connection; var closeConnectionOnCommandDisposed = true; if (this.IsInTransaction) { if (this.transaction == null) { lock (this.lockTransaction) { if (this.transaction == null) { connection = this.GetConnection(statement); connection.Open(); if(this.DataService.Debug) { LogService.WriteLog(this, LogLevel.DEBUG, "Connection open with transaction:" + connection.GetHashCode()); } this.transaction = connection.BeginTransaction(); } } } connection = this.Transaction.Connection; closeConnectionOnCommandDisposed = false; } else { connection = this.GetConnection(statement); connection.Open(); if(this.DataService.Debug) { LogService.WriteLog(this, LogLevel.DEBUG, "Connection open without transaction:" + connection.GetHashCode()); } } var command = connection.CreateCommand(); command.Transaction = this.Transaction; return new DbCommandWrap(command, closeConnectionOnCommandDisposed); }
public int ExecuteSqlNonQuery(StringBuilder sbSql, string providerName, string connectionString, out string strError) { int intEffected = -1; // return number rows effected strError = ""; try { conn = CreateDbConnection(providerName, connectionString, out strError); conn.Open(); } catch (Exception ex) { strError = ex.Message; return(-1); } try { DbCommand cmd = conn.CreateCommand(); cmd.CommandText = sbSql.ToString(); cmd.CommandType = CommandType.Text; cmd.Connection = conn; intEffected = cmd.ExecuteNonQuery(); } catch (Exception ex) { strError = ex.Message; return(-1); } return(intEffected); }
public bool DeleteProducts(int actId, string ProductIds) { bool result = false; using (System.Data.Common.DbConnection dbConnection = this.database.CreateConnection()) { dbConnection.Open(); System.Data.Common.DbTransaction dbTransaction = dbConnection.BeginTransaction(); System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand(string.Format("Delete from Hishop_PointExChange_Products WHERE exChangeId ={0} and ProductId in ( {1} )", actId, ProductIds.ReplaceSingleQuoteMark())); System.Data.Common.DbCommand sqlStringCommand2 = this.database.GetSqlStringCommand("update Hishop_PointExChange_PointExChanges set ProductNumber=ProductNumber-1 where Id=@Id"); this.database.AddInParameter(sqlStringCommand2, "Id", System.Data.DbType.Int32, actId); try { this.database.ExecuteNonQuery(sqlStringCommand, dbTransaction); this.database.ExecuteNonQuery(sqlStringCommand2, dbTransaction); dbTransaction.Commit(); result = true; } catch { dbTransaction.Rollback(); result = false; } finally { if (dbTransaction.Connection != null) { dbConnection.Close(); } } } return(result); }
}//ExecuteQueryToDataTable(string sql) /// <summary> /// 执行查询返回DataReader /// </summary> /// <param name="sql">Sql语句</param> /// <param name="Conn">连接对象</param> /// <returns>成功时返回Reader对象,失败时返回null</returns> static public System.Data.IDataReader ExecuteQuery(string sql, System.Data.Common.DbConnection Conn) { System.Data.IDataReader reader = null; if (Conn == null) { return(null); } try { if (Conn.State == System.Data.ConnectionState.Closed) { Conn.Open(); } System.Data.IDbCommand cmd = Conn.CreateCommand(); cmd.CommandText = sql; cmd.CommandTimeout = 180; reader = cmd.ExecuteReader(); return(reader); } catch (Exception ex) { if (ex.Message.Contains("死锁")) { WriteLog(ex.Message + " 再做列锁循环!ExecuteQuery"); System.Threading.Thread.Sleep(200); return(ExecuteQuery(sql, Conn)); } else { DBClassHelper.ErrLog("DBClassHelper.ExecuteQuery(string sql, System.Data.Common.DbConnection Conn):" + ex.Message + "; \n sql =" + sql); } return(null); } }//ExecuteQuery(string sql)
protected override void PreStart() { base.PreStart(); _connection = CreateDbConnection(); _connection.Open(); }
public void BeginTransaction() { _db = new SqlDatabase(_strConnection); _dbConn = _db.CreateConnection(); _dbConn.Open(); _dbTrans = _dbConn.BeginTransaction(); }
public static bool UpdateVote(VoteInfo vote) { Database database = DatabaseFactory.CreateDatabase(); bool result; using (System.Data.Common.DbConnection dbConnection = database.CreateConnection()) { VoteDao voteDao = new VoteDao(); dbConnection.Open(); System.Data.Common.DbTransaction dbTransaction = dbConnection.BeginTransaction(); try { if (!voteDao.UpdateVote(vote, dbTransaction)) { dbTransaction.Rollback(); result = false; } else { if (!voteDao.DeleteVoteItem(vote.VoteId, dbTransaction)) { dbTransaction.Rollback(); result = false; } else { int num = 0; if (vote.VoteItems != null) { foreach (VoteItemInfo current in vote.VoteItems) { current.VoteId = vote.VoteId; current.ItemCount = 0; num += voteDao.CreateVoteItem(current, dbTransaction); } if (num < vote.VoteItems.Count) { dbTransaction.Rollback(); result = false; return(result); } } dbTransaction.Commit(); result = true; } } } catch { dbTransaction.Rollback(); result = false; } finally { dbConnection.Close(); } } return(result); }
internal AmnesiaDbConnection(System.Transactions.Transaction distributedTransaction, DbConnection real) { this.real = real; // join the transaction real.Open(); real.EnlistTransaction(distributedTransaction); }
/// <summary> /// Abertura de conexao, se fechada, e retorno o estado original da conexao para controle posterior /// se fecha ou nao ao conexao, ao fim da operacao /// </summary> /// <param name="connection">Conexao que vai estar aberta ao fim do metodo</param> /// <param name="estadoOriginal">Obtem o estado original da conexao, para controle se deve ou nao fechar a conexao</param> internal static void AbrirConexao(DbConnection connection, out ConnectionState estadoOriginal) { estadoOriginal = connection.State; if (connection.State == ConnectionState.Closed) { connection.Open(); } }
public static string ExecuteQueryToDisplayString(string query, DbConnection conn) { if (conn.State == ConnectionState.Closed) { conn.Open(); } return ExecuteQueryToDisplayString(query, null, conn.CreateCommand); }
public DbTransaction BeginTransaction() { _db = DatabaseFactory.CreateDatabase(); _connection = _db.CreateConnection(); _connection.Open(); _transaction = _connection.BeginTransaction(); return _transaction; }
public DbHelper() { connection = ConnectProvider.CreateConnection(); cmd = ConnectProvider.CreateCommand(); connection.Open(); cmd.Connection = connection; }
//private static private DataBaseHelper() { DbProviderFactory factory = DbProviderFactories.GetFactory(ConfigurationManager.ConnectionStrings["ConnectionString"].ProviderName); connection = factory.CreateConnection(); connection.ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; connection.Open(); factory.CreateDataAdapter(); }
public OpenConnectionGuard(DbConnection connection, bool isExternalConnection) { _isExternalConnection = isExternalConnection; _connection = connection; _connectionWasOpen = _connection.State == System.Data.ConnectionState.Open; if (!_connectionWasOpen) _connection.Open(); }
public SqlServerProcessor(DbConnection connection, IMigrationGenerator generator, IAnnouncer announcer, IMigrationProcessorOptions options, IDbFactory factory) : base(generator, announcer, options) { this.factory = factory; Connection = connection; connection.Open(); BeginTransaction(); }
public static string UpdateAdjustCommssions(string orderId, string itemid, decimal commssionmoney, decimal adjustcommssion) { string text = string.Empty; Database database = DatabaseFactory.CreateDatabase(); string result; using (System.Data.Common.DbConnection dbConnection = database.CreateConnection()) { dbConnection.Open(); System.Data.Common.DbTransaction dbTransaction = dbConnection.BeginTransaction(); try { OrderInfo orderInfo = ShoppingProcessor.GetOrderInfo(orderId); if (orderId == null) { result = "订单编号不合法"; return(result); } int userId = DistributorsBrower.GetCurrentDistributors(true).UserId; if (orderInfo.ReferralUserId != userId || orderInfo.OrderStatus != OrderStatus.WaitBuyerPay) { result = "不是您的订单"; return(result); } LineItemInfo lineItemInfo = orderInfo.LineItems[itemid]; if (lineItemInfo == null || lineItemInfo.ItemsCommission < adjustcommssion) { result = "修改金额过大"; return(result); } lineItemInfo.ItemAdjustedCommssion = adjustcommssion; lineItemInfo.IsAdminModify = false; if (!new LineItemDao().UpdateLineItem(orderId, lineItemInfo, dbTransaction)) { dbTransaction.Rollback(); } if (!new OrderDao().UpdateOrder(orderInfo, dbTransaction)) { dbTransaction.Rollback(); result = "更新订单信息失败"; return(result); } dbTransaction.Commit(); text = "1"; } catch (Exception ex) { text = ex.ToString(); dbTransaction.Rollback(); } finally { dbConnection.Close(); } result = text; } return(result); }
//connects to SQL Server here public DAL() { conn = DbProviderFactories.GetFactory(ConfigurationManager.ConnectionStrings["SqlServerConnectionString"].ProviderName).CreateConnection(); conn.ConnectionString = ConfigurationManager.ConnectionStrings["SqlServerConnectionString"].ConnectionString; cmd = conn.CreateCommand(); cmd.Connection = conn; conn.Open(); cmd.CommandType = CommandType.Text; }
//методы открытия соединения - видимо нахер не нужны. подключени создаются внутри нижеследующих методов public void OpenConnection() { using (_curConnection = _curDataObjFactory.CreateConnection()) { _curConnection.ConnectionString = _connectionString; _curConnection.Open(); } }
public DbConnection getConn() { if (conn == null) { conn = new SqlConnection(connectionString); conn.Open(); } return conn; }
public void Setup() { Connection = new SQLiteConnection(IntegrationTestOptions.SqlLite.ConnectionString); Processor = new SqliteProcessor(Connection, new SqliteGenerator(), new TextWriterAnnouncer(System.Console.Out), new ProcessorOptions(), new SqliteDbFactory()); SchemaDumper = new SqliteSchemaDumper(Processor, new TextWriterAnnouncer(System.Console.Out)); Connection.Open(); }
public DatabaseInserter(DbConnection connection, string insertSql) { Connection = connection; _command = Connection.CreateCommand(); _command.Connection = Connection; _command.CommandText = insertSql; Connection.Open(); _sqLiteTransaction = Connection.BeginTransaction(); }
public void select(DbConnection conn) { if (conn.State != ConnectionState.Open) conn.Open(); try { DataTable tb = new DataTable(); this.DAOList_ = new List<MARKETDATA_SYMBOL_INFO_Table_DAO>(); DbCommand dbCommand = conn.CreateCommand(); string selectQuery = MARKETDATA_SYMBOL_INFO_Table_DAOManager.SelectQuery_; selectQuery = selectQuery.Replace("@SYMBOL_TYPEKeyColumnValue@", this.KeyColumn_SYMBOL_TYPE_); dbCommand.CommandText = selectQuery; //DbDataAdapter dataAdapter = new DbDataAdapter(dbCommand, conn); DbDataAdapter dataAdapter = DataBaseConnectManager.CreateDataAdapter(dbCommand, conn); dataAdapter.Fill(tb); DataRow[] dr = tb.Select(); int rowCount = dr.Length; foreach (DataRow item in dr) { MARKETDATA_SYMBOL_INFO_Table_DAO dao = new MARKETDATA_SYMBOL_INFO_Table_DAO(); dao.SYMBOL_ = item[0].ToString(); dao.NAME_ENG_ = item[1].ToString(); dao.NAME_KOR_ = item[2].ToString(); dao.SYMBOL_TYPE_ = item[3].ToString(); dao.PROVIDER_ = item[4].ToString(); dao.DESCRIPTION_ = item[5].ToString(); dao.TENOR_ = item[6].ToString(); dao.SUB_TYPE_ = item[7].ToString(); dao.LINKEDCURVE_ = item[8].ToString(); dao.RATE_TYPE_ = item[9].ToString(); dao.LEG_TENOR_ = item[10].ToString(); dao.CURRENCY_ = item[11].ToString(); this.DAOList_.Add(dao); } conn.Close(); } catch (Exception) { conn.Close(); } }
public void select(DbConnection conn) { if (conn.State != ConnectionState.Open) conn.Open(); DataTable tb = new DataTable(); this.DAOList_ = new List<MATSER_INFO_Table_DAO>(); DbCommand dbCommand = conn.CreateCommand(); string selectQuery = MATSER_INFO_Table_DAOManager.SelectQuery_; //selectQuery = selectQuery.Replace("@KeyColumnValue@", this.KeyColumn_); dbCommand.CommandText = selectQuery; //DbDataAdapter dataAdapter = new DbDataAdapter(dbCommand, conn); DbDataAdapter dataAdapter = DataBaseConnectManager.CreateDataAdapter(dbCommand, conn); dataAdapter.Fill(tb); DataRow[] dr = tb.Select(); int rowCount = dr.Length; foreach (DataRow item in dr) { MATSER_INFO_Table_DAO dao = new MATSER_INFO_Table_DAO(); dao.ITEM_CODE_ = item[0].ToString(); dao.ITEM_NAME_ = item[1].ToString(); dao.NOTIONAL_ = item[2].ToString(); dao.REMAIN_NOTIONAL_ = item[3].ToString(); dao.CURRENCY_ = item[4].ToString(); dao.TRADE_DATE_ = item[5].ToString(); dao.MATURITY_DATE_ = item[6].ToString(); dao.COUNTERPARTY_ = item[7].ToString(); dao.EXPORT_ITEMCODE_ = item[8].ToString(); dao.TRADE_ID_ = item[9].ToString(); dao.TRADE_STATUS_ = item[10].ToString(); dao.INSTRUMENT_TYPE_ = item[11].ToString(); dao.UNDERLYING_TYPE_ = item[12].ToString(); dao.UNDERLYING_DETAIL_TYPE_ = item[13].ToString(); dao.CONTRACT_TYPE_ = item[14].ToString(); dao.CONTRACT_SUBTYPE_ = item[15].ToString(); dao.CONTRACT_DETAIL_TYPE_ = item[16].ToString(); dao.BOOKING_TYPE_ = item[17].ToString(); this.DAOList_.Add(dao); } }
public bool CreateReturn(ReturnsInfo returnInfo)//创建退回单 { bool result; if (returnInfo == null) { result = false; } else { Database database = DatabaseFactory.CreateDatabase(); using (System.Data.Common.DbConnection dbConnection = database.CreateConnection()) { dbConnection.Open(); System.Data.Common.DbTransaction dbTransaction = dbConnection.BeginTransaction(); try { if (!UpdateOrderStatusBeApplyForReturns(returnInfo.OrderId, dbTransaction)) { dbTransaction.Rollback(); result = false; return(result); } returnInfo.ReturnsId = AddReturnInfo(returnInfo, dbTransaction); if (returnInfo.ReturnsId <= 0) { dbTransaction.Rollback(); result = false; return(result); } if (returnInfo.ReturnsLineItem.Count > 0) { if (!AddReturnsItem(returnInfo, dbTransaction)) { dbTransaction.Rollback(); result = false; return(result); } } dbTransaction.Commit(); result = true; } catch { dbTransaction.Rollback(); result = false; } finally { dbConnection.Close(); } } } return(result); }
protected override void InitConnection(System.Data.Common.DbConnection conn) { if (conn.State != System.Data.ConnectionState.Open) { conn.Open(); } var connectionStringBuilder = new DbConnectionStringBuilder(); connectionStringBuilder.ConnectionString = conn.ConnectionString; dbName = GetDatabaseName(connectionStringBuilder); }
public static bool UpdateLineItem(string string_0, OrderInfo order, int quantity) { ManagerHelper.CheckPrivilege(Privilege.EditOrders); Database database = DatabaseFactory.CreateDatabase(); bool result; bool flag; using (System.Data.Common.DbConnection dbConnection = database.CreateConnection()) { dbConnection.Open(); System.Data.Common.DbTransaction dbTransaction = dbConnection.BeginTransaction(); try { SalesProvider salesProvider = SalesProvider.Instance(); order.LineItems[string_0].Quantity = quantity; order.LineItems[string_0].ShipmentQuantity = quantity; order.LineItems[string_0].ItemAdjustedPrice = order.LineItems[string_0].ItemListPrice; if (!salesProvider.UpdateLineItem(order.OrderId, order.LineItems[string_0], dbTransaction)) { dbTransaction.Rollback(); result = false; return(result); } if (!salesProvider.UpdateOrderAmount(order, dbTransaction)) { dbTransaction.Rollback(); result = false; return(result); } dbTransaction.Commit(); flag = true; } catch (Exception) { dbTransaction.Rollback(); flag = false; } finally { dbConnection.Close(); } } if (flag) { EventLogs.WriteOperationLog(Privilege.EditOrders, string.Format(CultureInfo.InvariantCulture, "修改了订单号为\"{0}\"的订单商品数量", new object[] { order.OrderId })); } result = flag; return(result); }
public static bool UpdateGroupBuy(GroupBuyInfo groupBuy) { Globals.EntityCoding(groupBuy, true); Database database = DatabaseFactory.CreateDatabase(); bool result; using (System.Data.Common.DbConnection dbConnection = database.CreateConnection()) { dbConnection.Open(); System.Data.Common.DbTransaction dbTransaction = dbConnection.BeginTransaction(); try { GroupBuyDao groupBuyDao = new GroupBuyDao(); if (!groupBuyDao.UpdateGroupBuy(groupBuy, dbTransaction)) { dbTransaction.Rollback(); result = false; } else { if (!groupBuyDao.DeleteGroupBuyCondition(groupBuy.GroupBuyId, dbTransaction)) { dbTransaction.Rollback(); result = false; } else { if (!groupBuyDao.AddGroupBuyCondition(groupBuy.GroupBuyId, groupBuy.GroupBuyConditions, dbTransaction)) { dbTransaction.Rollback(); result = false; } else { dbTransaction.Commit(); result = true; } } } } catch (Exception var_4_99) { dbTransaction.Rollback(); result = false; } finally { dbConnection.Close(); } } return(result); }
public static bool UpdateBundlingProduct(BundlingInfo bundlingInfo) { Database database = DatabaseFactory.CreateDatabase(); bool result; using (System.Data.Common.DbConnection dbConnection = database.CreateConnection()) { dbConnection.Open(); System.Data.Common.DbTransaction dbTransaction = dbConnection.BeginTransaction(); try { BundlingDao bundlingDao = new BundlingDao(); if (!bundlingDao.UpdateBundlingProduct(bundlingInfo, dbTransaction)) { dbTransaction.Rollback(); result = false; } else { if (!bundlingDao.DeleteBundlingByID(bundlingInfo.BundlingID, dbTransaction)) { dbTransaction.Rollback(); result = false; } else { if (!bundlingDao.AddBundlingProductItems(bundlingInfo.BundlingID, bundlingInfo.BundlingItemInfos, dbTransaction)) { dbTransaction.Rollback(); result = false; } else { dbTransaction.Commit(); result = true; } } } } catch (Exception var_4_91) { dbTransaction.Rollback(); result = false; } finally { dbConnection.Close(); } } return(result); }
public static bool AddSiteSettings(SiteSettings siteSettings, int requestId, int siteQty) { Database database = DatabaseFactory.CreateDatabase(); bool result; using (System.Data.Common.DbConnection dbConnection = database.CreateConnection()) { dbConnection.Open(); System.Data.Common.DbTransaction dbTransaction = dbConnection.BeginTransaction(); try { DistributorProvider distributorProvider = DistributorProvider.Instance(); if (!distributorProvider.AcceptSiteRequest(siteQty, requestId, dbTransaction)) { dbTransaction.Rollback(); result = false; } else { if (!distributorProvider.AddSiteSettings(siteSettings, requestId, dbTransaction)) { dbTransaction.Rollback(); result = false; } else { if (!DistributorProvider.Instance().AddInitData(siteSettings.UserId.Value, dbTransaction)) { dbTransaction.Rollback(); result = false; } else { dbTransaction.Commit(); result = true; } } } } catch { dbTransaction.Rollback(); result = false; } finally { dbConnection.Close(); } } return(result); }
public static bool DeleteOrderGift(OrderInfo order, int giftId) { ManagerHelper.CheckPrivilege(Privilege.EditOrders); Database database = DatabaseFactory.CreateDatabase(); bool result; using (System.Data.Common.DbConnection dbConnection = database.CreateConnection()) { dbConnection.Open(); System.Data.Common.DbTransaction dbTransaction = dbConnection.BeginTransaction(); try { SalesProvider salesProvider = SalesProvider.Instance(); OrderGiftInfo orderGift = salesProvider.GetOrderGift(giftId, order.OrderId); order.Gifts.Remove(orderGift); if (!salesProvider.DeleteOrderGift(order.OrderId, orderGift.GiftId, dbTransaction)) { dbTransaction.Rollback(); result = false; } else { if (!salesProvider.UpdateOrderAmount(order, dbTransaction)) { dbTransaction.Rollback(); result = false; } else { dbTransaction.Commit(); EventLogs.WriteOperationLog(Privilege.EditOrders, string.Format(CultureInfo.InvariantCulture, "删除了订单号为\"{0}\"的订单礼品", new object[] { order.OrderId })); result = true; } } } catch { dbTransaction.Rollback(); result = false; } finally { dbConnection.Close(); } } return(result); }
public static bool ClearOrderGifts(OrderInfo order) { ManagerHelper.CheckPrivilege(Privilege.EditOrders); Database database = DatabaseFactory.CreateDatabase(); bool result; bool flag; using (System.Data.Common.DbConnection dbConnection = database.CreateConnection()) { dbConnection.Open(); System.Data.Common.DbTransaction dbTransaction = dbConnection.BeginTransaction(); try { SalesProvider salesProvider = SalesProvider.Instance(); order.Gifts.Clear(); if (!salesProvider.ClearOrderGifts(order.OrderId, dbTransaction)) { dbTransaction.Rollback(); result = false; return(result); } if (!salesProvider.UpdateOrderAmount(order, dbTransaction)) { dbTransaction.Rollback(); result = false; return(result); } dbTransaction.Commit(); flag = true; } catch { dbTransaction.Rollback(); flag = false; } finally { dbConnection.Close(); } } if (flag) { EventLogs.WriteOperationLog(Privilege.EditOrders, string.Format(CultureInfo.InvariantCulture, "清空了订单号为\"{0}\"的订单礼品", new object[] { order.OrderId })); } result = flag; return(result); }
public static bool UpdateGroupBuy(GroupBuyInfo groupBuy) { Database database = DatabaseFactory.CreateDatabase(); bool result; using (System.Data.Common.DbConnection dbConnection = database.CreateConnection()) { dbConnection.Open(); System.Data.Common.DbTransaction dbTransaction = dbConnection.BeginTransaction(); try { if (!SubsitePromotionsProvider.Instance().UpdateGroupBuy(groupBuy, dbTransaction)) { dbTransaction.Rollback(); result = false; } else { if (!SubsitePromotionsProvider.Instance().DeleteGroupBuyCondition(groupBuy.GroupBuyId, dbTransaction)) { dbTransaction.Rollback(); result = false; } else { if (!SubsitePromotionsProvider.Instance().AddGroupBuyCondition(groupBuy.GroupBuyId, groupBuy.GroupBuyConditions, dbTransaction)) { dbTransaction.Rollback(); result = false; } else { dbTransaction.Commit(); result = true; } } } } catch (Exception) { dbTransaction.Rollback(); result = false; } finally { dbConnection.Close(); } } return(result); }
public static SDC.DbDataReader ReadData(string sproc, List <ParamStruct> paramList) { SDC.DbProviderFactory factory = SDC.DbProviderFactories.GetFactory(Properties.Settings.Default.provider); SDC.DbCommand comm = factory.CreateCommand(); comm = BuildCommand(sproc, paramList); SDC.DbConnection conn = Connection(factory); comm.Connection = conn; conn.Open(); SDC.DbDataReader dr = comm.ExecuteReader(System.Data.CommandBehavior.CloseConnection); return(dr); }
public bool TestConnection(string providerName, string connectionString, out string strError) { strError = ""; try { conn = CreateDbConnection(providerName, connectionString, out strError); conn.Open(); conn.Close(); return(true); } catch (Exception ex) { strError = ex.Message; return(false); } }
/// <summary> /// /// </summary> /// <param name="cmd"></param> /// <param name="comType"></param> /// <param name="parameters"></param> /// <param name="strError"></param> /// <param name="intEffected"></param> /// <returns></returns> public DataSet GetDataSet(DbCommand cmd, CommandType comType, Dictionary <string, object> parameters, out string strError, out int intEffected) { intEffected = -1; strError = ""; try { conn = cmd.Connection; conn.Open(); } catch (Exception ex) { strError = ex.Message; return(null); } DataSet dataSet = new DataSet(); DbProviderFactory factory = DbProviderFactories.GetFactory(providerName); try { //System.Data.Common.DbCommand DbDataAdapter dbAdapter = factory.CreateDataAdapter(); cmd.CommandType = comType; if ((parameters != null)) { cmd.Parameters.Clear(); if (parameters.Count > 0) { SetCmd(ref cmd, parameters); } } dbAdapter.SelectCommand = cmd; dbAdapter.FillLoadOption = LoadOption.PreserveChanges; intEffected = dbAdapter.Fill(dataSet); conn.Close(); } catch (Exception ex) { strError = ex.Message; conn.Close(); } return(dataSet); }
public bool TestConnection(out string strError) { strError = ""; try { // conn = CreateDbConnection(out strError); Connection has been created if you run public DbCommand commandDB(out String strError, String connectionName = "") conn.Open(); conn.Close(); return(true); } catch (Exception ex) { strError = ex.Message; return(false); } }
}//Execute(string sql,System.Data.IDataParameter[] param) /// <summary> /// 执行一个事务 /// </summary> /// <param name="sqls">Sql语句组</param> /// <returns>成功时返回true</returns> static public bool ExecuteTrans(string[] sqls, System.Data.Common.DbConnection Conn) { System.Data.IDbTransaction myTrans; if (Conn == null) { DBClassHelper.ErrLog("DBClassHelper.ExecuteTrans(string[] sqls):连接对象为空!"); return(false); } if (Conn.State == System.Data.ConnectionState.Closed) { Conn.Open(); } System.Data.IDbCommand cmd = Conn.CreateCommand(); cmd.CommandTimeout = 180; myTrans = Conn.BeginTransaction(); cmd.Transaction = myTrans; int i = 0; var wrongsql = string.Empty; try { foreach (string sql in sqls) { if (sql != null) { wrongsql = sql; cmd.CommandText = sql; cmd.ExecuteNonQuery(); } } myTrans.Commit(); } catch (Exception ex) { myTrans.Rollback(); DBClassHelper.ErrLog("错误位置:" + i + "。错误sql:" + wrongsql + "。DBClassHelper.ExecuteTrans(string[] sqls):" + ex.Message); return(false); } finally { Conn.Close(); } return(true); }//Execute(string sql)
public static bool UpdateAdjustCommssions(string orderId, string itemid, decimal adjustcommssion) { bool flag = false; Database database = DatabaseFactory.CreateDatabase(); bool result; using (System.Data.Common.DbConnection dbConnection = database.CreateConnection()) { dbConnection.Open(); System.Data.Common.DbTransaction dbTransaction = dbConnection.BeginTransaction(); try { OrderInfo orderInfo = OrderHelper.GetOrderInfo(orderId); if (orderInfo == null) { result = false; return(result); } LineItemInfo lineItemInfo = orderInfo.LineItems[itemid]; lineItemInfo.ItemAdjustedCommssion = adjustcommssion; if (!new LineItemDao().UpdateLineItem(orderId, lineItemInfo, dbTransaction)) { dbTransaction.Rollback(); } if (!new OrderDao().UpdateOrder(orderInfo, dbTransaction)) { dbTransaction.Rollback(); result = false; return(result); } dbTransaction.Commit(); flag = true; } catch (Exception var_6_9F) { dbTransaction.Rollback(); } finally { dbConnection.Close(); } result = flag; } return(result); }
public bool UpdateDiscountStatus(int Id, DiscountStatus status) { bool result = false; using (System.Data.Common.DbConnection dbConnection = this.database.CreateConnection()) { dbConnection.Open(); System.Data.Common.DbTransaction dbTransaction = dbConnection.BeginTransaction(); System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand("update Hishop_LimitedTimeDiscount set Status=@Status WHERE LimitedTimeDiscountId = @Id"); this.database.AddInParameter(sqlStringCommand, "Id", System.Data.DbType.Int32, Id); this.database.AddInParameter(sqlStringCommand, "Status", System.Data.DbType.Int32, (int)status); System.Data.Common.DbCommand sqlStringCommand2; if (DiscountStatus.Delete == status) { sqlStringCommand2 = this.database.GetSqlStringCommand("delete Hishop_LimitedTimeDiscountProduct WHERE LimitedTimeDiscountId = @Id"); this.database.AddInParameter(sqlStringCommand2, "Id", System.Data.DbType.Int32, Id); } else { sqlStringCommand2 = this.database.GetSqlStringCommand("update Hishop_LimitedTimeDiscountProduct set Status=@Status WHERE LimitedTimeDiscountId = @Id"); this.database.AddInParameter(sqlStringCommand2, "Id", System.Data.DbType.Int32, Id); this.database.AddInParameter(sqlStringCommand2, "Status", System.Data.DbType.Int32, (int)status); } try { this.database.ExecuteNonQuery(sqlStringCommand, dbTransaction); this.database.ExecuteNonQuery(sqlStringCommand2, dbTransaction); dbTransaction.Commit(); result = true; } catch { dbTransaction.Rollback(); result = false; } finally { if (dbTransaction.Connection != null) { dbConnection.Close(); } } } return(result); }
/// <summary> /// /// </summary> /// <param name="cmd"></param> /// <param name="comType"></param> /// <param name="parameters"></param> /// <param name="strError"></param> /// <returns></returns> public int ExecuteSqlNonQuery(DbCommand cmd, CommandType comType, Dictionary <string, object> parameters, out string strError) { int intEffected = -1; strError = ""; try { conn = cmd.Connection; conn.Open(); } catch (Exception ex) { strError = ex.Message; return(intEffected); } try { cmd.CommandType = comType; if ((parameters != null)) { cmd.Parameters.Clear(); if (parameters.Count > 0) { SetCmd(ref cmd, parameters); } } intEffected = cmd.ExecuteNonQuery(); conn.Close(); } catch (Exception ex) { strError = ex.Message; intEffected = -1; } finally { conn.Close(); } return(intEffected); }
public static int AddPromotion(PromotionInfo promotion) { Database database = DatabaseFactory.CreateDatabase(); int result; using (System.Data.Common.DbConnection dbConnection = database.CreateConnection()) { dbConnection.Open(); System.Data.Common.DbTransaction dbTransaction = dbConnection.BeginTransaction(); try { PromotionDao promotionDao = new PromotionDao(); int num = promotionDao.AddPromotion(promotion, dbTransaction); if (num <= 0) { dbTransaction.Rollback(); result = -1; } else { if (!promotionDao.AddPromotionMemberGrades(num, promotion.MemberGradeIds, dbTransaction)) { dbTransaction.Rollback(); result = -2; } else { dbTransaction.Commit(); result = num; } } } catch (Exception var_5_76) { dbTransaction.Rollback(); result = 0; } finally { dbConnection.Close(); } } return(result); }
public static bool AddGroupBuy(GroupBuyInfo groupBuy) { Globals.EntityCoding(groupBuy, true); Database database = DatabaseFactory.CreateDatabase(); bool result; using (System.Data.Common.DbConnection dbConnection = database.CreateConnection()) { dbConnection.Open(); System.Data.Common.DbTransaction dbTransaction = dbConnection.BeginTransaction(); try { int num = PromotionsProvider.Instance().AddGroupBuy(groupBuy, dbTransaction); if (num <= 0) { dbTransaction.Rollback(); result = false; } else { if (!PromotionsProvider.Instance().AddGroupBuyCondition(num, groupBuy.GroupBuyConditions, dbTransaction)) { dbTransaction.Rollback(); result = false; } else { dbTransaction.Commit(); result = true; } } } catch (Exception) { dbTransaction.Rollback(); result = false; } finally { dbConnection.Close(); } } return(result); }
private bool CreateAnonymous(out string errorMsg) { System.Data.Common.DbConnection dbConnection = null; bool result; try { System.Data.Common.DbConnection dbConnection2; dbConnection = (dbConnection2 = new System.Data.SqlClient.SqlConnection(this.GetConnectionString())); try { System.Data.Common.DbCommand dbCommand = new System.Data.SqlClient.SqlCommand(); dbCommand.Connection = dbConnection; dbCommand.CommandType = System.Data.CommandType.Text; dbCommand.CommandText = "INSERT INTO aspnet_Users (UserName, LoweredUserName, IsAnonymous, UserRole, LastActivityDate, Password, PasswordFormat, PasswordSalt, IsApproved, IsLockedOut, CreateDate, LastLoginDate, LastPasswordChangedDate, LastLockoutDate, FailedPasswordAttemptCount, FailedPasswordAttemptWindowStart, FailedPasswordAnswerAttemptCount, FailedPasswordAnswerAttemptWindowStart) VALUES ('Anonymous', LOWER('Anonymous'), 1, @UserRole, @CreateDate, 'DVZTktxeMzDtXR7eik7Cdw==', 0, '', 1, 0, @CreateDate, @CreateDate, @CreateDate, CONVERT( datetime, '17540101', 112 ), 0, CONVERT( datetime, '17540101', 112 ), 0, CONVERT( datetime, '17540101', 112 ))"; dbCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@UserRole", UserRole.Anonymous)); dbCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@CreateDate", System.DateTime.Now)); dbConnection.Open(); dbCommand.ExecuteNonQuery(); dbConnection.Close(); } finally { if (dbConnection2 != null) { ((System.IDisposable)dbConnection2).Dispose(); } } errorMsg = null; result = true; } catch (System.Data.SqlClient.SqlException ex) { errorMsg = ex.Message; if (dbConnection != null && dbConnection.State != System.Data.ConnectionState.Closed) { dbConnection.Close(); dbConnection.Dispose(); } result = false; } return(result); }
public static bool AddBundlingProduct(BundlingInfo bundlingInfo) { Database database = DatabaseFactory.CreateDatabase(); bool result; using (System.Data.Common.DbConnection dbConnection = database.CreateConnection()) { dbConnection.Open(); System.Data.Common.DbTransaction dbTransaction = dbConnection.BeginTransaction(); try { int num = PromotionsProvider.Instance().AddBundlingProduct(bundlingInfo, dbTransaction); if (num <= 0) { dbTransaction.Rollback(); result = false; } else { if (!PromotionsProvider.Instance().AddBundlingProductItems(num, bundlingInfo.BundlingItemInfos, dbTransaction)) { dbTransaction.Rollback(); result = false; } else { dbTransaction.Commit(); result = true; } } } catch (Exception) { dbTransaction.Rollback(); result = false; } finally { dbConnection.Close(); } } return(result); }