private SqlCommand GetSQLComand(string SQL, string DB, int Timeout, List<SqlParameter> Parms) { AppSQLCommand oCommand; oCommand = new AppSQLCommand(new ConnectionInfo(this.oConnInfo.ConnectionString, DB), SQL, Timeout, Parms); return oCommand.CommandRef; }
private SqlCommand GetSQLComand(string SQL, string DB, int Timeout, SqlParameter SingleParm) { AppSQLCommand oCommand; var Parms = new List<SqlParameter>(); if (SingleParm != null) { Parms.Add(SingleParm); } oCommand = new AppSQLCommand(new ConnectionInfo(this.oConnInfo.ConnectionString, DB), SQL, Timeout, Parms); return oCommand.CommandRef; }
private int GetRunCommand(string SQL, string DB, int Timeout, List<SqlParameter> Parms) { int iReturnVal = 0; AppSQLCommand oCommand; oCommand = new AppSQLCommand(new ConnectionInfo(this.oConnInfo.ConnectionString, DB), SQL, Timeout, Parms); oCommand.Open(); iReturnVal = oCommand.CommandRef.ExecuteNonQuery(); oCommand.Close(); return iReturnVal; }