using System; using System.IO; using System.Collections.Generic; using System.Text; using System.Data.SqlClient; using System.Web; namespace LYFZ.Helper { 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 string CommandText; public System.Data.SqlClient.SqlParameter[] 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; } } }