C# Data.StateChangeEventArgs类代码示例

 void Con_StateChange(object sender, StateChangeEventArgs e)
 {
     string Mes;
     Mes = string.Format("원래 상태 : {0}, 현재 상태 {1}",
         e.OriginalState, e.CurrentState);
     listBox1.Items.Add(Mes);
 }

 private void SetState(ConnectionState state)
 {
     var originalState = this.state;
     this.state = state;
     var e = new StateChangeEventArgs(originalState, state);
     OnStateChange(e);
 }

        /// <summary>
        /// Catches the ConnectionOnStateChange event in order to detect when the connection is open in order to execute the federation statement.
        /// </summary>
        protected virtual void ConnectionOnStateChange(object sender, StateChangeEventArgs stateChangeEventArgs)
        {
            if (stateChangeEventArgs.CurrentState != ConnectionState.Open)
                return;

            ExecuteStatement();
        }

 protected virtual void OnStateChange(StateChangeEventArgs stateChange)
 {
     StateChangeEventHandler handler = this._stateChangeEventHandler;
     if (handler != null)
     {
         handler(this, stateChange);
     }
 }

        private static void OnStateChange(object sender, StateChangeEventArgs args)
        {
            // If the connection is closed, wake-up the main thread
            PolyConnection connection = (PolyConnection)sender;

            if (connection.State == ConnectionState.Closed)
            {
                WaitHandle.Set();
            }
        }

		private void DBContextChange(object sender, StateChangeEventArgs e) {
			if (e.OriginalState == ConnectionState.Closed && e.CurrentState == ConnectionState.Open) {
				Debug.WriteLine(iDBCounter + " ================ " + DateTime.UtcNow.ToString() + " ================");
				Debug.WriteLine(iDBCounter + " ~~~~~~~~~~~~~~~~ OPEN ~~~~~~~~~~~~~~~~~~");
				ThisWatch.Reset();
				ThisWatch.Start();
			} else if (e.OriginalState == ConnectionState.Open && e.CurrentState == ConnectionState.Closed) {
				ThisWatch.Stop();
				Debug.WriteLine(String.Format("\t SQL took {0}ms   \r\n", ThisWatch.ElapsedMilliseconds));
				Debug.WriteLine(iDBCounter + " ~~~~~~~~~~~~~~~~ CLOSE ~~~~~~~~~~~~~~~~~~");
			}
		}

 private static void Connection_StateChange(object sender, StateChangeEventArgs e)
 {
     if ((e.OriginalState == ConnectionState.Broken || e.OriginalState == ConnectionState.Closed || e.OriginalState == ConnectionState.Connecting) &&
         e.CurrentState == ConnectionState.Open)
     {
         DbConnection connection = (DbConnection)sender;
         using (DbCommand command = connection.CreateCommand())
         {
             // Activated foreign keys if supported by SQLite.  Unknown pragmas are ignored.
             command.CommandText = "PRAGMA foreign_keys = ON";
             command.ExecuteNonQuery();
         }
     }
 }

 public static void OnStateChange(Object o, StateChangeEventArgs stateChanged)
 {
     // linq seems to switch between open and close only
     if (stateChanged.OriginalState == ConnectionState.Open && stateChanged.CurrentState == ConnectionState.Closed)
     {
         // write the time between open => close
         var timeSpan = DateTime.Now.Subtract(tsStart);
         if (timeSpan.TotalSeconds > 0)
             LogItemHandler.ConnectionClosed(timeSpan);
     }
     else if (stateChanged.OriginalState == ConnectionState.Closed && stateChanged.CurrentState == ConnectionState.Open)
     {
         tsStart = DateTime.Now;
     }
 }

 private void OnStateChange(object sender, StateChangeEventArgs args)
 {
     if (args.OriginalState == ConnectionState.Closed && args.CurrentState == ConnectionState.Open)
     {
         countCloseOpen++;
     }
     else if (args.OriginalState == ConnectionState.Open && args.CurrentState == ConnectionState.Closed)
     {
         countOpenClose++;
     }
     else
     {
         countOtherConnectionStates++;
     }
 }

 /// <summary>
 /// Constructs the object.
 /// </summary>
 /// <param name="eventType">The type of event being raised.</param>
 /// <param name="eventArgs">The base <see cref="EventArgs" /> associated
 /// with this event, if any.</param>
 /// <param name="transaction">The transaction associated with this event, if any.</param>
 /// <param name="command">The command associated with this event, if any.</param>
 /// <param name="text">The command or message text, if any.</param>
 /// <param name="data">The extra data, if any.</param>
 internal ConnectionEventArgs(
     SQLiteConnectionEventType eventType,
     StateChangeEventArgs eventArgs,
     IDbTransaction transaction,
     IDbCommand command,
     string text,
     object data
     )
 {
     EventType = eventType;
     EventArgs = eventArgs;
     Transaction = transaction;
     Command = command;
     Text = text;
     Data = data;
 }

 void myconn_StateChange(object sender, StateChangeEventArgs e)
 {
     if (myconn.State == ConnectionState.Open)
     {
         //
     }
     if (myconn.State == ConnectionState.Closed)
     {
         //
     }
     if (myconn.State == ConnectionState.Connecting)
     {
         //
     }
     Application.DoEvents();
 }

 void connection_StateChange(object sender, StateChangeEventArgs e)
 {
     if (e.CurrentState == ConnectionState.Closed)
     {
         connection.StateChange -= connection_StateChange;
         connection = null;
     }
 }

 protected virtual void OnStateChange(StateChangeEventArgs stateChange)
 {
     StateChangeEventHandler handler = _stateChangeEventHandler;
     if (null != handler)
     {
         handler(this, stateChange);
     }
 }

        public void mainConnection_StateChange(object sender, StateChangeEventArgs e)
        {
            //显示数据库当前状态
            string strCurrentStatus;
            if (e.CurrentState.ToString().Equals("Open"))
                strCurrentStatus = "已连接";
            else if (e.CurrentState.ToString().Equals("Closed"))
                strCurrentStatus = "已关闭";
            else if (e.CurrentState.ToString().Equals("Connecting"))
                strCurrentStatus = "正在连接";
            else if (e.CurrentState.ToString().Equals("Executing"))
                strCurrentStatus = "正在执行";
            else if (e.CurrentState.ToString().Equals("Fetching"))
                strCurrentStatus = "正在检索";
            else if (e.CurrentState.ToString().Equals("Broken"))
                strCurrentStatus = "连接中断";
            else
                strCurrentStatus = "未知";

            statusBarPanel2.Text = strCurrentStatus;
        }

 void c_StateChange(object sender, StateChangeEventArgs e)
 {
     stateChangeCount++;
 }