public static void ExecuteSqlTran(Hashtable SQLStringList) { Database db = DatabaseFactory.CreateDatabase(); using (DbConnection dbconn = db.CreateConnection()) { dbconn.Open(); DbTransaction dbtran = dbconn.BeginTransaction(); try { foreach (object obj in SQLStringList) { DictionaryEntry myDE = (DictionaryEntry)obj; string strsql = myDE.Key.ToString(); SqlParameter[] cmdParms = (SqlParameter[])myDE.Value; if (strsql.Trim().Length > 1) { DbCommand dbCommand = db.GetSqlStringCommand(strsql); DbHelperSQL2.BuildDBParameter(db, dbCommand, cmdParms); db.ExecuteNonQuery(dbCommand); } } dbtran.Commit(); } catch { dbtran.Rollback(); } finally { dbconn.Close(); } } }
public static DataSet Query(string strSql, params SqlParameter[] cmdParms) { Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(strSql); DbHelperSQL2.BuildDBParameter(db, dbCommand, cmdParms); return(db.ExecuteDataSet(dbCommand)); }
public static object RunProcedure(string storedProcName, IDataParameter[] InParameters, SqlParameter OutParameter, int rowsAffected) { Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetStoredProcCommand(storedProcName); DbHelperSQL2.BuildDBParameter(db, dbCommand, (SqlParameter[])InParameters); db.AddOutParameter(dbCommand, OutParameter.ParameterName, OutParameter.DbType, OutParameter.Size); rowsAffected = db.ExecuteNonQuery(dbCommand); return(db.GetParameterValue(dbCommand, "@" + OutParameter.ParameterName)); }
public static bool Exists(string strSql, params SqlParameter[] cmdParms) { Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(strSql); DbHelperSQL2.BuildDBParameter(db, dbCommand, cmdParms); object obj = db.ExecuteScalar(dbCommand); int cmdresult; if (object.Equals(obj, null) || object.Equals(obj, DBNull.Value)) { cmdresult = 0; } else { cmdresult = int.Parse(obj.ToString()); } return(cmdresult != 0); }
public static object GetSingle(string strSql, params SqlParameter[] cmdParms) { Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(strSql); DbHelperSQL2.BuildDBParameter(db, dbCommand, cmdParms); object obj = db.ExecuteScalar(dbCommand); object result; if (object.Equals(obj, null) || object.Equals(obj, DBNull.Value)) { result = null; } else { result = obj; } return(result); }