示例#1
0
 public bool AddItem(string ShipName)
 {
     if (ShipperExist(ShipName))
     {
         return false;
     }
     else
     {
         Shippers s = new Shippers(ShipName);
         sList.Add(s);
         return true;
     }
 }
示例#2
0
        public static Shippers PopulateShippersFromSqlDataReader(SqlDataReader dr)
        {
            Shippers shippers = new Shippers();

            shippers.ID = Convert.ToInt32(dr["ID"]);
            shippers.Shipper = Convert.ToString(dr["Shipper"]);
            shippers.Phone = Convert.ToString(dr["Phone"]);
            shippers.Fax = Convert.ToString(dr["Fax"]);
            shippers.Comments = Convert.ToString(dr["Comments"]);
            shippers.Cell = Convert.ToString(dr["Cell"]);
            shippers.Other = Convert.ToString(dr["Other"]);

            return shippers;
        }
示例#3
0
        public void AddShippers(Shippers Shippers)
        {
            // Initialize SPROC

            SqlConnection conn = new SqlConnection(ConnectionString);
            SqlCommand cmd = new SqlCommand("SPShippersInsert", conn);
            cmd.CommandType = CommandType.StoredProcedure;

            // Add Parameters
            cmd.Parameters.AddWithValue("@ID", 0);
            cmd.Parameters.AddWithValue("@Shipper", Shippers.Shipper);
            cmd.Parameters.AddWithValue("@Phone", Shippers.Phone);
            cmd.Parameters.AddWithValue("@Fax", Shippers.Fax);
            cmd.Parameters.AddWithValue("@Comments", Shippers.Comments);
            cmd.Parameters.AddWithValue("@Cell", Shippers.Cell);
            cmd.Parameters.AddWithValue("@Other", Shippers.Other);

            conn.Open();
            cmd.ExecuteNonQuery();
            conn.Close();
            reload();
        }
示例#4
0
 private void Object2Form(Shippers s)
 {
     int Index = comboBox1.FindString(s.Shipper);
     comboBox1.SelectedIndex = Index;
     textBox1.Text = s.Comments;
     textBox2.Text = s.Phone;
     textBox3.Text = s.Fax;
     textBox4.Text = s.Cell;
     textBox5.Text = s.Other;
 }
示例#5
0
 private Shippers Form2Object()
 {
     Shippers tship = new Shippers(0, comboBox1.Text, textBox1.Text, textBox2.Text, textBox3.Text, textBox4.Text, textBox5.Text);
     return tship;
 }
示例#6
0
 public Shippers SearchShipper(string ShipperName)
 {
     foreach (Shippers Ship in sList)
     {
         if (Ship.Shipper == ShipperName)
         {
             return Ship;
         }
     }
     Shippers s = new Shippers(ShipperName);
     return (s);
 }
示例#7
0
        private void UpdatePOShip(int QTS,int ONH)
        {
            string DataGrid_PO = "";
            string DataGrid_POStat;
            int DataGrid_Inv = 0;
            int DataGrid_OnHand = 0;
            int DataGrid_ShipQuan = 0;
            int totalavqty = 0;
            int POID = 0;
            Shippers shipr = new Shippers();
            CustBillShip bill = new CustBillShip();
            CustBillShip ship = new CustBillShip();

            /* item.Cells[0].Value = po.PoNumber;
            item.Cells[1].Value = po.ReceiveDate;
            item.Cells[2].Value = po.InitialQty;
            item.Cells[3].Value = po.FabRejectQty;
            item.Cells[4].Value = po.PaintRejectQty;
            item.Cells[5].Value = po.InventoryQty;
            item.Cells[6].Value = po.ShippedQty;
            item.Cells[7].Value = po.Status;
            item.Cells[8].Value = po.Id;
            */

            int j = 0;
            while (j < InvPOGrid.RowCount)
            {
                if (QTS  != 0)
                {
                    POID = int.Parse(InvPOGrid.Rows[j].Cells[8].Value.ToString());
                    DataGrid_POStat = InvPOGrid.Rows[j].Cells[7].Value.ToString();
                    DataGrid_PO = InvPOGrid.Rows[j].Cells[0].Value.ToString();
                    DataGrid_Inv = int.Parse(InvPOGrid.Rows[j].Cells[5].Value.ToString());
                    DataGrid_OnHand = int.Parse(InvPOGrid.Rows[j].Cells[9].Value.ToString());
                    DataGrid_ShipQuan = int.Parse(InvPOGrid.Rows[j].Cells[6].Value.ToString());
                    if (DataGrid_Inv <= QTS)
                    {
                        DataGrid_ShipQuan = DataGrid_ShipQuan + DataGrid_Inv;
                        QTS = QTS - DataGrid_Inv;
                        DataGrid_Inv = 0;
                        DataGrid_OnHand = DataGrid_OnHand - DataGrid_ShipQuan;
                        if (DataGrid_POStat != "OPEN_INV")
                        {
                            DataGrid_POStat = "SHIPPED";
                        }
                    }
                    else
                    {
                        DataGrid_ShipQuan = DataGrid_ShipQuan + QTS;
                        DataGrid_Inv = DataGrid_Inv - QTS;
                        DataGrid_OnHand = DataGrid_OnHand - QTS;
                        QTS = 0;
                    }

                    int CustID;
                    Customer TCust = CustList.SearchCustomer(CustCombo.Text);
                    CustID = TCust.ID;
                    BillShipList BSList;
                    BSList = new BillShipList(TCust.ID);

                    InvPOGrid.Rows[j].Cells[6].Value = DataGrid_ShipQuan.ToString();
                    InvPOGrid.Rows[j].Cells[5].Value = DataGrid_Inv.ToString();
                    string RcvDate = InvPOGrid.Rows[j].Cells[1].Value.ToString();
                    shipr = Shippers.SearchShipper(ShipViaCombo.Text);
                    bill = BSList.SearchBillShip(BillToCombo.Text, "Billing");
                    ship = BSList.SearchBillShip(BillToCombo.Text, "Shipping");
                    if (bill.AddressName == "")
                    {
                        bill.ID = 0;
                    }
                    if (ship.AddressName == "")
                    {
                        ship.ID = 0;
                    }
                    if (bill.ID == 0)
                    {
                        bill.ID = ship.ID;
                    }
                    if (ship.ID == 0)
                    {
                        ship.ID = bill.ID;
                    }

                    shipList.ShipPO(DataGrid_PO, CustID, PartCombo.Text, RcvDate, TrackingTB.Text, shipComment, DataGrid_ShipQuan,
                                    ship.ID, DataGrid_Inv, DataGrid_OnHand, DataGrid_POStat,bill.ID);
                    shipList.CreateShipmentRecord(CustID, PartCombo.Text, DataGrid_ShipQuan, POID, TrackingTB.Text,
                                                  ship.ID, bill.ID, shipr.ID);
                    //Update Database
                }
                j++;

                totalavqty = totalavqty + DataGrid_Inv;
            }
        }