コード例 #1
0
        private void vehiclesToolStripMenuItem_Click(object sender, EventArgs e)
        {
            AddVehicle adv = new AddVehicle();

            adv.m = this;
            adv.Show();
            this.Hide();
        }
        private void button4_Click(object sender, EventArgs e)
        {
            AddVehicle adv = new AddVehicle();

            adv.Show();
            adv.Cust = this;
            this.Hide();
            adv.caller = "AddCustomer";
        }
コード例 #3
0
        private void addVehicleToolStripMenuItem_Click_1(object sender, EventArgs e)
        {
            AddVehicle adv = new AddVehicle();

            adv.Show();
            adv.caller = "Emp";
            adv.emp    = this;
            this.Hide();
        }
        private void button4_Click(object sender, EventArgs e)
        {
            this.Hide();
            AddVehicle adv = new AddVehicle();

            adv.caller = "Items";
            adv.adi    = this;
            adv.Show();
            adv.m = m;
        }
        private void button4_Click(object sender, EventArgs e)
        {
            this.Hide();
            AddVehicle adv = new AddVehicle();

            adv.Show();
            adv.caller = "Cust";
            adv.edc    = this;
            adv.emp    = emp;
        }
コード例 #6
0
        private void button1_Click(object sender, EventArgs e)
        {
            this.Hide();
            AddVehicle adv = new AddVehicle();

            adv.Show();
            adv.caller = "UPDE";
            adv.ud     = this;
            adv.m      = m;
        }
 public void view(String cmd, AddSupplier ads = null, AddVehicle adv = null, AddOrder ado = null, View v = null, UpDe ud = null, Manage adm = null, EditCust edc = null, CustOrder C_Order = null)
 {
     using (Conn = new SqlConnection())
     {
         try
         {
             Conn.ConnectionString = "Server = (local);Database = Spare_parts;Trusted_Connection = true";
             SqlCommand Cmd = new SqlCommand(cmd, Conn);
             Conn.Open();
             SqlDataReader reader = Cmd.ExecuteReader();
             if (ads != null)
             {
                 while (reader.Read())
                 {
                     ads.Add(reader[0].ToString(), reader[1].ToString(), reader[2].ToString(), reader[3].ToString());
                 }
             }
             else if (adv != null)
             {
                 while (reader.Read())
                 {
                     adv.Add(reader[0].ToString(), reader[1].ToString(), reader[2].ToString(), reader[3].ToString());
                 }
             }
             else if (ado != null)
             {
                 while (reader.Read())
                 {
                     ado.Add(reader[0].ToString(), reader[1].ToString(), reader[2].ToString(), reader[3].ToString(), reader[4].ToString(), reader[5].ToString());
                 }
             }
             else if (v != null)
             {
                 while (reader.Read())
                 {
                     v.parts(reader[0].ToString(), reader[1].ToString(), reader[2].ToString(), reader[3].ToString(), reader[4].ToString(), reader[5].ToString(), reader[6].ToString(), reader[7].ToString(), reader[8].ToString());
                 }
             }
             else if (ud != null)
             {
                 while (reader.Read())
                 {
                     ud.Add(reader[0].ToString(), reader[1].ToString(), reader[2].ToString(), reader[3].ToString(), reader[4].ToString(), reader[5].ToString(), reader[6].ToString(), reader[7].ToString(), reader[8].ToString());
                 }
             }
             else if (edc != null)
             {
                 while (reader.Read())
                 {
                     edc.Add(reader[0].ToString(), reader[1].ToString(), reader[2].ToString(), reader[3].ToString(), reader[4].ToString(), reader[5].ToString(), reader[6].ToString(), reader[7].ToString());
                 }
             }
             else if (adm != null)
             {
                 while (reader.Read())
                 {
                     adm.Add(reader[0].ToString(), reader[1].ToString(), reader[2].ToString(), reader[3].ToString(), reader[4].ToString(), reader[5].ToString(), reader[6].ToString(), reader[7].ToString(), reader[8].ToString(), reader[9].ToString());
                 }
             }
             else
             {
                 while (reader.Read())
                 {
                     C_Order.Add(reader[0].ToString(), reader[1].ToString(), reader[2].ToString(), reader[3].ToString(), reader[4].ToString(), reader[5].ToString(), reader[6].ToString());
                 }
             }
         }
         catch (SqlException)
         {
             MessageBox.Show("An error occured", "Error");
         }
     }
     Conn.Close();
 }