Exemple #1
0
        public PQ_CreateForm()
        {
            InitializeComponent();
            sql = new MySQLDatabaseDriver();

            itemList = new ArrayList();
            sql.SelectAllItems(itemList);
            for (int i = 0; i < itemList.Count; i++)
            {
                Item itemToAdd = (Item)itemList[i];
                dgvItemSelection.Rows.Add(itemToAdd.PartNumber,
                                          itemToAdd.ItemName,
                                          itemToAdd.ItemDescription,
                                          itemToAdd.Uom,
                                          itemToAdd.ReicUnitPrice.ToString("0.00"));
            }

            cbbBillTo.SelectedIndex        = 0;
            cbbShipTo.SelectedIndex        = 0;
            cbbInFavorOf.SelectedIndex     = 0;
            cbbPaymentTerms.SelectedIndex  = 0;
            cbbDeliveryTerms.SelectedIndex = 0;
            customerList = new ArrayList();
            //sql.SelectAllSuppliers(customerList);

            //customerDropdownList = new ArrayList();
            //sql.SelectAllCustomerNames(customerDropdownList);
            //customerDropdownList.Sort();
            //customerDropdownList.Insert(0, "Select Customer");
            //cbbCustomerName.DataSource = customerDropdownList;
            pqOrderLineList = new ArrayList();
        }
Exemple #2
0
 public Item_MainScreen()
 {
     InitializeComponent();
     sql          = new MySQLDatabaseDriver();
     itemList     = new ArrayList();
     supplierList = new ArrayList();
     sql.SelectAllItemsDGV(dgvItems);
     sql.SelectAllItems(itemList);
 }
Exemple #3
0
        public PO_CreateForm()
        {
            InitializeComponent();
            sql = new MySQLDatabaseDriver();


            itemList        = new ArrayList();
            poList          = new ArrayList();
            pqOrderLineList = new ArrayList();
            sql.SelectAllItems(itemList);
            for (int i = 0; i < itemList.Count; i++)
            {
                Item itemToAdd = (Item)itemList[i];
                dgvItemSelection.Rows.Add(itemToAdd.PartNumber,
                                          itemToAdd.ItemName,
                                          itemToAdd.ItemDescription,
                                          itemToAdd.Uom,
                                          itemToAdd.ReicUnitPrice.ToString("0.00"));
            }
            //  cbbInFavorOf.SelectedIndex = 0;
            //  cbbPaymentTerms.SelectedIndex = 0;
            //   cbbDeliveryTerms.SelectedIndex = 0;
        }