Click here to Skip to main content
Click here to Skip to main content
Add your own
alternative version
Go to top

Internal Supply Chain, Visibility via 200 plus 3D Chart Reports - Part II

, 8 Oct 2009
This article focuses on internal supply chain management systems visibility via chart reports, and provides assessment apparatus to manage and monitor activities spawned during business processes, hence paves the way for timely and precise business decisions.
InventorySys.zip
InventorySys
ISCMS.csproj.user
Warehouse
Control
RawMaterial
Properties
Settings.settings
Procurement
Control
Plant
Control
Order
Control
MasterFiles
Transporter
Control
Supplier
Control
Order
Control
List
Invoice
obj
Release
build.force
InventorySys.Control.ScheduleItem.resources
InventorySys.csproj.GenerateResource.Cache
InventorySys.Form1.resources
ISCMS.Control.About.resources
ISCMS.Control.ActivityBalloon.resources
ISCMS.Control.BarItem.resources
ISCMS.Control.GoodsBalloon.resources
ISCMS.Control.JobBalloon.resources
ISCMS.Control.JobStatusBalloon.resources
ISCMS.Control.RMInTransitBalloon.resources
ISCMS.Control.VacantBalloon.resources
ISCMS.csproj.GenerateResource.Cache
ISCMS.Dialog.Job.resources
ISCMS.Dialog.Rates.resources
ISCMS.Dialog.Transaction.resources
ISCMS.exe
ISCMS.MainForm.resources
ISCMS.pdb
ISCMS.Properties.Resources.resources
ResolveAssemblyReference.cache
TempPE
Properties.Resources.Designer.cs.dll
Refactor
Debug
InventorySys.Control.ScheduleItem.resources
InventorySys.csproj.GenerateResource.Cache
InventorySys.Form1.resources
ISCMS.Control.About.resources
ISCMS.Control.ActivityBalloon.resources
ISCMS.Control.BarItem.resources
ISCMS.Control.GoodsBalloon.resources
ISCMS.Control.JobBalloon.resources
ISCMS.Control.JobStatusBalloon.resources
ISCMS.Control.RMInTransitBalloon.resources
ISCMS.Control.VacantBalloon.resources
ISCMS.csproj.GenerateResource.Cache
ISCMS.Dialog.Job.resources
ISCMS.Dialog.Rates.resources
ISCMS.Dialog.Transaction.resources
ISCMS.exe
ISCMS.Invoice.PurchaseInvoice.resources
ISCMS.Invoice.SalesInvoiceList.resources
ISCMS.Main.BaseVisibility.resources
ISCMS.Main.Login.resources
ISCMS.Main.NonListBase.resources
ISCMS.MainForm.resources
ISCMS.MainForm2.resources
ISCMS.Manufacturing.EventList.resources
ISCMS.Manufacturing.JobList.resources
ISCMS.Manufacturing.Material.resources
ISCMS.MasterFiles.Base.resources
ISCMS.MasterFiles.Carrier.resources
ISCMS.MasterFiles.Client.resources
ISCMS.MasterFiles.Goods.resources
ISCMS.MasterFiles.Invoice.resources
ISCMS.MasterFiles.Order.resources
ISCMS.MasterFiles.Supplier.resources
ISCMS.MasterFiles.Transporter.resources
ISCMS.Order.PurchaseOrderList.resources
ISCMS.Order.SalesOrderList.resources
ISCMS.pdb
ISCMS.Plant.Event.resources
ISCMS.Plant.Panoramic.resources
ISCMS.Plant.PurchaseOrderConversion.resources
ISCMS.Plant.SalesOrderConversion.resources
ISCMS.Procurement.EventList.resources
ISCMS.Properties.Resources.resources
ISCMS.Warehouse.EventList.resources
ResolveAssemblyReference.cache
TempPE
Main.DataSet.nodeDataset.designer.cs.dll
Main.DataSet.TreeNodeDS.designer.cs.dll
Main.DataSetNS.nodeDataset.designer.cs.dll
Main.DataSetNS.TreeNodeDS.designer.cs.dll
Properties.Resources.Designer.cs.dll
Refactor
Control
Goods
Control
Employee
Control
Client
Control
Carrier
Control
Manufacturing
Control
Main
DataSetNS
nodeDataset.xsc
nodeDataset.xss
nodeDataset.xsx
TreeNodeDS.xsc
TreeNodeDS.xss
TreeNodeDS.xsx
ChartDialog
Jobs
Invoice
Control
Dialog
DataAccess
Order
Invoice
Control
bin
Debug
Hasan.dll
Inv.mdb
System.Windows.Forms.DataVisualization.Design.dll
System.Windows.Forms.DataVisualization.dll
ISCMS.vshost.exe
Utilities
ActivityLegend
ChartDataTableHelper
DigitalFilter
HistogramChartHelper
PieCollectedDataHelper
RangeSpliceChartHelper
SampleMain
SixSigma
SpikeRemoval
ISCMS.suo
Release.zip
Release
Inv.mdb
System.Web.DataVisualization.Design.dll
System.Windows.Forms.DataVisualization.Design.dll
System.Windows.Forms.DataVisualization.dll
ISCMS.exe
ISCMS.pdb
Hasan.dll
Hasan.pdb
using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.OleDb;

namespace ISCMS.DataAccess
{
    class Supplier : ISCMS.DataAccess.Access
    {
        public System.Data.DataSet GetList()
        {
            System.Data.DataSet data = new DataSet();
            con = new OleDbConnection(connection);
            dsCommand = new OleDbCommand();
            dsCommand.Connection = con;

            try
            {
                con.Open();
                dsCommand.CommandText = "select * from Supplier";
                IDataReader dr = dsCommand.ExecuteReader();
                data.Tables.Add("List");
                data.Load(dr, LoadOption.OverwriteChanges, "List");
                dr.Close();
            }
            catch
            {
                throw new ApplicationException("Data error.");
            }
            finally
            {
                con.Close();
            }
            return data;
        }
    }
}

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Share

About the Author

Hasan Hyder
Software Developer
Pakistan Pakistan
No Biography provided
Group type: Organisation

29 members

Follow on   Google+

| Advertise | Privacy | Mobile
Web04 | 2.8.140905.1 | Last Updated 8 Oct 2009
Article Copyright 2009 by Hasan Hyder
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid