You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
73 lines
2.2 KiB
73 lines
2.2 KiB
using System;
|
|
using System.Collections.Generic;
|
|
using System.Text;
|
|
using System.Data.SqlClient;
|
|
|
|
namespace DBUtility
|
|
{
|
|
public enum EffentNextType
|
|
{
|
|
/// <summary>
|
|
/// 對其他語句无任何影響
|
|
/// </summary>
|
|
None,
|
|
/// <summary>
|
|
/// 當前語句必須为"select count(1) from .."格式，如果存在則繼續執行，不存在回滾事務
|
|
/// </summary>
|
|
WhenHaveContine,
|
|
/// <summary>
|
|
/// 當前語句必須为"select count(1) from .."格式，如果不存在則繼續執行，存在回滾事務
|
|
/// </summary>
|
|
WhenNoHaveContine,
|
|
/// <summary>
|
|
/// 當前語句影響到的行數必須大于0，否則回滾事務
|
|
/// </summary>
|
|
ExcuteEffectRows,
|
|
/// <summary>
|
|
/// 引發事件-當前語句必須为"select count(1) from .."格式，如果不存在則繼續執行，存在回滾事務
|
|
/// </summary>
|
|
SolicitationEvent
|
|
}
|
|
public class CommandInfo
|
|
{
|
|
public object ShareObject = null;
|
|
public object OriginalData = null;
|
|
event EventHandler _solicitationEvent;
|
|
public event EventHandler SolicitationEvent
|
|
{
|
|
add
|
|
{
|
|
_solicitationEvent += value;
|
|
}
|
|
remove
|
|
{
|
|
_solicitationEvent -= value;
|
|
}
|
|
}
|
|
public void OnSolicitationEvent()
|
|
{
|
|
if (_solicitationEvent != null)
|
|
{
|
|
_solicitationEvent(this, new EventArgs());
|
|
}
|
|
}
|
|
public string CommandText;
|
|
public System.Data.Common.DbParameter[] Parameters;
|
|
public EffentNextType EffentNextType = EffentNextType.None;
|
|
public CommandInfo()
|
|
{
|
|
|
|
}
|
|
public CommandInfo(string sqlText, SqlParameter[] para)
|
|
{
|
|
this.CommandText = sqlText;
|
|
this.Parameters = para;
|
|
}
|
|
public CommandInfo(string sqlText, SqlParameter[] para, EffentNextType type)
|
|
{
|
|
this.CommandText = sqlText;
|
|
this.Parameters = para;
|
|
this.EffentNextType = type;
|
|
}
|
|
}
|
|
}
|