/// <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)); }