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