static public DataTable readAll()
{
if (alreadyRetrieved)
{
return(SIFRecordset);
}
DM = connectionManager.getDataManager();
string query = "SELECT [Inquiry Number], Status, Priority, Revision, [Sales Person], [Cost Model Location], Contact, " +
"[Business Class], Product, [Division/Location], Department, [Reason For Quote], [Application/Program], " +
"Specification, [Task Description], [Part Print (Rev)], Samples, [Tooling Target (Incl Prototypes)], [Primary Competitors], " +
"[Specific Response Requirements], [Technical/subsource Constraints], Customer, [Quote Due], SOP, " +
"[DWG Level], ID, [Year 1], [Year 2], [Year 3], [Year 4], [Year 5], [Year 6], [Year 7], [Projected Annual Volume Yr 1], " +
"[% of Volume per Award Yr 1], [Projected/Target Price Yr 1], [Annual Revenue Yr 1], [Projected annual Volume Yr 2], " +
"[% of Volume Yr 2], [Projected/Target Price Yr 2], [Annual Revenue Yr 2], [Projected Annual Volume Yr 3], " +
"[% of Volume per award Yr 3], [Projected/Target Price Yr 3], [Annual Revenue Yr 3], [Projected Annual Volume Yr 4], " +
"[% of Volume Yr 4], [Projected/Target Price Yr 4], [Annual Revenue Yr 4], [Projected Annual Volume Yr 5], [% of Volume per Award Yr 5], " +
"[Projected/Target Price Yr 5], [Annual Volume Yr 5], [Projected annual Volume Yr 6], [% Volume per Award Yr 6], " +
"[Projected/Target Price Yr 6], [Annual Revenue Yr 6], [Projected Annual Volume Yr 7], [% Volume per Award Yr 7], " +
"[Projected/Target Price Yr 7], [Annual Revenue Yr 7], [Market Sector] FROM [Sales Inquiry Form Table] " +
"ORDER BY [Inquiry Number], Revision;";
SIFRecordset = DM.Execute_Query(query);
alreadyRetrieved = true;
return(SIFRecordset);
}
static public DataTable readAll()
{
if (alreadyRetrieved)
{
return(BOMLineAccessData);
}
DM = connectionManager.getDataManager();
string query = "SELECT [Material Position], [Part Number/Code ID], " +
"[Material/Assembly Description], [Part Cost ($)], [No Required], UM, "
+ "[Assembly Description], Status, [Inquiry Number], Revision, "
+ "[Vendor Quote Est], Comments, [Cap Com Assm], [Lead Time PPAP], [Component Lead Time] " +
"FROM [Mat Assm Tool Descrip Table]";
BOMLineAccessData = DM.Execute_Query(query);
alreadyRetrieved = true;
return(BOMLineAccessData);
}
public Data_Base_MNG.Access getDataManager()
{
if (alreadyConnected)
{
return(DMG);
}
string sConn = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=\" + datasource + ";Jet OLEDB:Database";
try
{
DMG = new Data_Base_MNG.Access(datasource);
//DMG = new Data_Base_MNG.Access(@"\\cap-ah\Exchange\" + datasource);
alreadyConnected = true;
return(DMG);
}
catch (Exception e)
{ //TODO: log e in a future
return(null);
}
}