/// <summary>
/// AddParameter
/// </summary>
/// <param name="value">参数值</param>
/// <returns>参数名称</returns>
public string AddParameter(object value)
{
if (value is Enum)
{
value = Convert.ToInt32(value);
}
var name = string.Format("p_{0}", _parameters.Count + 1);
_parameters.Add(name, SqlServerDataBase.CreateParameter(name, value));
return(name);
}
/// <summary>
/// 构造
/// </summary>
/// <param name="dataBase"></param>
protected SqlServerDataBaseScope(SqlServerDataBase dataBase)
{
//Trace.WriteLine("Create SqlServerDataBaseScope", "SqlServerDataBase");
_dataBase = dataBase;
if (dataBase.Open())
{
_isHereOpen = true;
}
dataBase.QuoteCount += 1;
}
/// <summary>
/// 构造
/// </summary>
/// <param name="dataBase">数据库对象</param>
private TransactionScope(SqlServerDataBase dataBase)
{
//_preScope = CurrentScope;
//CurrentScope = this;
//_dataBase = dataBase;
//dataBase.Open();
//if (dataBase.Transaction != null)
//{
// return;
//}
//_beginType = 1;
//dataBase.Transaction = dataBase.Connection.BeginTransaction();
}
/// <summary>
/// 构造
/// </summary>
/// <param name="dataBase">数据库对象</param>
private TransactionScope(SqlServerDataBase dataBase)
{
_preScope = CurrentScope;
CurrentScope = this;
_dataBase = dataBase;
dataBase.Open();
if (dataBase.Transaction != null)
{
return;
}
_beginType = 1;
dataBase.Transaction = dataBase.Connection.BeginTransaction();
}
/// <summary>
/// AddParameter
/// </summary>
/// <param name="name">参数名(无名称使用序号)</param>
/// <param name="value">参数值</param>
/// <returns>True表示设置到旧参数，False表示增加了一个参数</returns>
public bool SetParameterValue(string name, object value)
{
if (name == null)
{
name = string.Format("p_{0}", _parameters.Count + 1);
_parameters.Add(name, SqlServerDataBase.CreateParameter(name, value));
return(false);
}
SqlParameter parameter;
if (_parameters.TryGetValue(name, out parameter))
{
parameter.Value = value;
return(true);
}
_parameters.Add(name, SqlServerDataBase.CreateParameter(name, value));
return(false);
}
/// <summary>
/// 构造
/// </summary>
/// <param name="dataBase">数据库对象</param>
public static TransactionScope CreateScope(SqlServerDataBase dataBase)
{
return(new TransactionScope(dataBase));
}
/// <summary>
/// 生成一个范围
/// </summary>
/// <param name="dataBase">数据库对象</param>
/// <returns>范围</returns>
public static SqlServerDataBaseScope CreateScope(SqlServerDataBase dataBase)
{
return(new SqlServerDataBaseScope(dataBase));
}
