public TSWDB_WordProcCommand(int _intURLsAtEveryStep, int _intMiliSecsToDelayAfterEveryStep) //constructor
{
intURLsAtEveryStep = _intURLsAtEveryStep;
intMiliSecsToDelayAfterEveryStep = _intMiliSecsToDelayAfterEveryStep;
processReport = null;
SQLConSW = TSWDB_Decl.GetSQLConSW();
}
public TSWDB_Search()
{
sqcm_FindWordAA = TSWDB_Decl.GetSQLConSW().CreateCommand();
sqcm_FindWordAA.CommandType = CommandType.StoredProcedure;
sqcm_FindWordAA.CommandText = "dbo.sp_SW_FindWordAA";
System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(sqcm_FindWordAA);
}
private void InitLocals()
{
sqcm_NewQuery = TEXCSDBUtil.DBCreateSimpleStoredProc(TSWDB_Decl.GetSQLConSW(), "dbo.sp_SW_NewQuery"); //xxxx
/*sp_SW_NewQuery ( @intSearchMethodType as tinyint, @strOriginalQyery as nvarchar(500) ,
* @strProcessedQuery as nvarchar(500) , @intUserAA as int, @intQueryAA as integer output) AS*/
dsQueryResult = CreateQueryResultsSchema();
}
public TSWDB_Authenticator()
{
sqcm_CheckUser = TEXCSDBUtil.DBCreateSimpleStoredProc(TSWDB_Decl.GetSQLConSW(), "dbo.sp_SW_CheckUser");
sqcm_NewUser = TEXCSDBUtil.DBCreateSimpleStoredProc(TSWDB_Decl.GetSQLConSW(), "dbo.sp_SW_NewUser");
}