private static bool FindLasestVersionForTable(string sPartNumber, string sTableName, ref string sVersion)
{
string sConn = @"Data Source=\\BOA\Production\Prodman.vfp\DATABASE\" + sTableName + ".dbf;" + @"Provider=VFPOLEDB.1;";
string sFormattedPartNum = AmcDataConnection.QUOTE + sPartNumber + AmcDataConnection.QUOTE;
AmcDataConnection vfpTempConn = new AmcDataConnection()
{
DataBaseType = (int)dbType.vfp,
TableName = sTableName,
ConnectionString = sConn
};
if (vfpTempConn.ConnectToDatabase())
{
string sSelectSql = "select top 1 partnumber, version from " + vfpTempConn.TableName + " where Partnumber" + " = " + sFormattedPartNum + " ORDER BY version descending";
OleDbCommand cmdSelect = new OleDbCommand(sSelectSql, vfpTempConn.GetOleConn());
OleDbDataReader rdr = cmdSelect.ExecuteReader();
if (rdr.HasRows)
{
rdr.Read();
sVersion = rdr["version"].ToString();
return(true);
}
}
return(false);
}
public static string GetPartNumberTable(string sPartNumber, string sVersion)
{
AmcDataConnection vfpTempConn = new AmcDataConnection(dbType.vfp);
string sFormattedPartNum = AmcDataConnection.QUOTE + sPartNumber + AmcDataConnection.QUOTE;
string sFormattedVersion = AmcDataConnection.QUOTE + sVersion + AmcDataConnection.QUOTE;
string sWhere = "Partnumber" + " = " + sFormattedPartNum + "and Version = " + sFormattedVersion;
string sdbName = "beta.dbf";
bool bFound = false;
int i;
for (i = 0; i < 4; i++)
{
if (i == 0)
{
sdbName = "beta.dbf";
}
else if (i == 1)
{
sdbName = "current.dbf";
}
else if (i == 2)
{
sdbName = "proto.dbf";
}
else if (i == 3)
{
sdbName = "history.dbf";
}
vfpTempConn.connect(sdbName);
string sSelectSql = "select partnumber from ";
sSelectSql += sdbName + " where " + sWhere;
OleDbCommand cmdSelect = new OleDbCommand(sSelectSql, vfpTempConn.GetConn());
OleDbDataReader rdr = cmdSelect.ExecuteReader();
rdr.Read();
if (rdr.HasRows)
{
bFound = true;
break;
}
} // ja - end loop
if (!bFound)
{
sdbName = "";
}
return(sdbName);
}
public bool InitializeDatabase()
{
if (String.IsNullOrWhiteSpace(KeyIdentifier))
{
return(false);
}
_dbConn = new AmcDataConnection()
{
ConnectionString = ConnectionString,
TableName = TableName,
DataBaseType = DataBaseType,
KeyIdentifier = KeyIdentifier,
KeyValue = KeyValue,
WhereClause = GetWhereSQL()
};
//_dbConn.WhereClause = GetWhereSQL() + AddVersionToWhere();
// ja - connect to a table
if (!_dbConn.ConnectToDatabase())
{
return(false);
}
AddColumns();
if (_ColumnNames.Count > 0)
{
Found = _dbConn.FillTable(_ColumnNames);
}
else
{
Found = _dbConn.FillTable();
}
return(true);
}
public bool InitializeDatabase()
{
// ja - use reflection to get values from the base class
//DataBaseType = Convert.ToInt32(this.GetType().GetField("nDATABASE_TYPE", BindingFlags.Public | BindingFlags.Instance).GetValue(this).ToString());
//ConnectionString = this.GetType().GetField("CONNECTION_STRING", BindingFlags.Public | BindingFlags.Instance).GetValue(this).ToString();
// ja - init the connection object
//_dbConn = new AmcDataConnection((dbType)DataBaseType);
_dbConn = new AmcDataConnection()
{
ConnectionString = ConnectionString,
TableName = TableName,
DataBaseType = DataBaseType
};
// ja - connect to a table
if (!_dbConn.__ConnectToDB())
{
return(false);
}
// ja - call local function to populate the data in the string global array
// TODO: ja - Move to object
_sdbValues = ReadData();
if (String.IsNullOrEmpty(_sdbValues[0]))
{
return(false);
}
_bIsFound = true;
return(true);
}
public UpdateTables(AmcDataConnection dbConn, Dictionary <string, string> setParams)
{
_dbConn = dbConn;
SetPairs = setParams;
}