internal LMSwbImporter(LISpMiner lispMiner, ODBC.ConnectionString connectionString, string lmPrivatePath)
: base()
{
this.LISpMiner = lispMiner;
this.LMExecutablesPath = this.LISpMiner.LMExecutablesPath;
this.LMPrivatePath = lmPrivatePath;
this.OdbcConnectionString = connectionString.Value;
this.ApplicationName = "LMSwbImporter.exe";
this.AppLog = String.Format("{0}-{1}.dat", "_AppLog_importer", Guid.NewGuid());
}
internal LMProcPooler(LISpMiner lispMiner, ODBC.ConnectionString connectionString, string lmPrivatePath)
: base()
{
this.LISpMiner = lispMiner;
this.LMExecutablesPath = this.LISpMiner.LMExecutablesPath;
this.LMPrivatePath = lmPrivatePath;
this.OdbcConnectionString = connectionString.Value;
this.ApplicationName = "LMProcPooler.exe";
this.AppLog = String.Format("{0}-{1}.dat", "_AppLog_LMProcPooler", Guid.NewGuid());
this.CancelAll = false;
// this.TimeOut = 10;
}
internal LMSwbExporter(LISpMiner lispMiner, ODBC.ConnectionString connectionString, string lmPrivatePath)
: base()
{
this.LISpMiner = lispMiner;
this.LMExecutablesPath = this.LISpMiner.LMExecutablesPath;
this.LMPrivatePath = lmPrivatePath;
this.OdbcConnectionString = connectionString.Value;
this.ApplicationName = "LMSwbExporter.exe";
this.AppLog = String.Format("{0}-{1}.dat", "_AppLog_exporter", Guid.NewGuid());
this.NoAttributeDisctinctValues = false;
this.NoEscapeSeqUnicode = false;
}
internal LMGridPooler(LISpMiner lispMiner, ODBC.ConnectionString connectionString, string lmPrivatePath, PCGridSettings gridSettings)
: base()
{
this.LISpMiner = lispMiner;
this.LMExecutablesPath = this.LISpMiner.LMExecutablesPath;
this.LMPrivatePath = lmPrivatePath;
this.OdbcConnectionString = connectionString.Value;
this.GridSettings = gridSettings;
this.GridDataPath = Path.GetFullPath(string.Format(@"{0}\PCGrid", this.LMPrivatePath));
this.ApplicationName = "LMGridPooler.exe";
this.AppLog = String.Format("{0}-{1}.dat", "_AppLog_LMGridPooler", Guid.NewGuid());
this.CancelAll = false;
// this.TimeOut = 10;
InitializePCGrid();
}
public string getAllUsers(int intUserID)
{
ODBC obj = new ODBC();
DataSet ds = new DataSet();
string strChild = "";
string strQuery = "SELECT a.child_id FROM mlm_level_log a WHERE a.userid=" + intUserID + " ";
ds = objdb.getDataSet(strQuery);
if (ds.Tables[0].Rows.Count != 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
if (i == 0)
{
strChild = strChild + ds.Tables[0].Rows[i][0].ToString();
}
else
{
strChild = strChild + "," + ds.Tables[0].Rows[i][0].ToString();
}
}
}
return(strChild);
}
public SQLHelper()
{
odbc = new ODBC();
}
public ConfigurationConnexion(ODBC ODBC_, SQL SQL_)
{
this.ODBC = ODBC_;
this.SQL = SQL_;
}