Пример #1
0
    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);
    }
Пример #2
0
    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);
    }
Пример #3
0
        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);
            }
        }