Example #1
0
 private void btn_stueckAktualisieren_Click(object sender, EventArgs e)
 {
     //foreach (DataGridViewRow row in dgv_stueckliste.Rows)
     for (int i = 0; i < dgv_stueckliste.RowCount - 1; i++)
     {
         var row = dgv_stueckliste.Rows[i];
         double.TryParse(row.Cells[2].Value.ToString(), out double menge);
         if (row.Cells[2].Value != null)
         {
             Stueckliste stueckliste = new Stueckliste(
                 Convert.ToInt32(tbx_fertigArtNr.Text),
                 tbx_fertigBezeichnung.Text,
                 Convert.ToInt32(row.Cells[0].Value),
                 row.Cells[1].Value.ToString(),
                 menge,
                 row.Cells[3].Value.ToString()
                 );
             //foreach (DataGridViewCell cell in row.Cells)
             //    Console.WriteLine(cell.ValueType);
             db.UpdateStueckliste(stueckliste);
         }
     }
     GetLists();
     PopulateDgvStueckliste();
 }
Example #2
0
 public void UpdateStueckliste(Stueckliste stueckliste)
 {
     try
     {
         OpenDB();
         com = con.CreateCommand();
         if (stueckliste.Menge > 0)
         {
             com.CommandText = String.Format("INSERT INTO tbl_stueckliste VALUES ({0}, {1}, {2}) ON DUPLICATE KEY UPDATE stueckliste_menge = {2};", stueckliste.FertigId.ToString(), stueckliste.RohId.ToString(), stueckliste.Menge.ToString().Replace(',', '.'));
         }
         else
         {
             com.CommandText = String.Format("DELETE FROM tbl_stueckliste WHERE fk_fertig_id = {0} AND fk_roh_id = {1}", stueckliste.FertigId.ToString(), stueckliste.RohId.ToString());
         }
         //com.CommandText = String.Format("UPDATE tbl_stueckliste SET fk_fertig_id = {0}, fk_roh_id = {1}, stueckliste_menge = {2} WHERE fk_fertig_id = {0} AND fk_roh_id = {1};", stueckliste.FertigId.ToString(), stueckliste.RohId.ToString(), stueckliste.Menge.ToString().Replace(',', '.'));
         com.ExecuteNonQuery();
     }
     catch (Exception ex)
     {
         MessageBox.Show("UR: " + ex.Message);
     }
     finally
     {
         CloseDB();
     }
 }
Example #3
0
        public List <Stueckliste> GetStuecklisten()
        {
            var stuecklistenList = new List <Stueckliste>();

            try
            {
                OpenDB();
                com             = con.CreateCommand();
                com.CommandText = "SELECT * FROM v_stueckliste;";

                var reader = com.ExecuteReader();

                while (reader.Read())
                {
                    var stueckliste = new Stueckliste(
                        !reader.IsDBNull(0) ? reader.GetInt32(0) : -1,      // fk_fertig_id
                        !reader.IsDBNull(1) ? reader.GetString(1) : "",     // fertig_bezeichnung
                        !reader.IsDBNull(2) ? reader.GetInt32(2) : -1,      // fk_roh_id
                        !reader.IsDBNull(3) ? reader.GetString(3) : "",     // roh_bezeichnung
                        !reader.IsDBNull(4) ? reader.GetDouble(4) : 0.0,    // Menge
                        !reader.IsDBNull(5) ? reader.GetString(5) : ""      // Einheit
                        );
                    stuecklistenList.Add(stueckliste);
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show("GS: " + ex.Message);
            }
            finally
            {
                CloseDB();
            }
            return(stuecklistenList);
        }
Example #4
0
        public void AddStueckliste(Stueckliste stueckliste)
        {
            try
            {
                OpenDB();
                com = con.CreateCommand();

                com.CommandText = String.Format("INSERT INTO tbl_stueckliste VALUES ({0}, {1}, {2});", stueckliste.FertigId.ToString(), stueckliste.RohId.ToString(), stueckliste.Menge.ToString().Replace(',', '.'));
                com.ExecuteNonQuery();
            }
            catch (Exception ex)
            {
                MessageBox.Show("AS: " + ex.Message);
            }
            finally
            {
                CloseDB();
            }
        }