private void NapolniListView() { var connectionString = ConfigurationManager.ConnectionStrings["myDatabaseConnection"].ConnectionString; using (MySqlConnection connection = new MySqlConnection(connectionString)) { var query = "select b.opis, b.kolicina from blago b " + "join dobavnice dn on dn.blago_id = b.st_dokumenta " + "where dn.id = " + id_dobavnice + ";"; connection.Open(); using (MySqlCommand command = new MySqlCommand(query, connection)) using (MySqlDataReader reader = command.ExecuteReader()) { while (reader.Read()) { LVI list_items = new LVI(); if (reader["opis"] != DBNull.Value) { list_items.Opis = (Convert.ToString(reader["opis"])); } if (reader["kolicina"] != DBNull.Value) { list_items.Kol = (Convert.ToInt32(reader["kolicina"])); } lvi_list_dobavnice.Add(list_items); } connection.Close(); } } }
private void NapolniListView() { var connectionString = ConfigurationManager.ConnectionStrings["myDatabaseConnection"].ConnectionString; using (MySqlConnection connection = new MySqlConnection(connectionString)) { var query = "select b.opis, b.cena_brez_ddv, b.cena_z_ddv, b.kolicina, b.vrednost, b.ddv from blago b " + "join racuni dn on dn.blago_id = b.st_dokumenta " + "where dn.id = " + id_racuna + ";"; connection.Open(); using (MySqlCommand command = new MySqlCommand(query, connection)) using (MySqlDataReader reader = command.ExecuteReader()) { while (reader.Read()) { LVI list_items = new LVI(); if (reader["opis"] != DBNull.Value) { list_items.Opis = (Convert.ToString(reader["opis"])); } if (reader["cena_brez_ddv"] != DBNull.Value) { list_items.Cena_brez_ddv = (Convert.ToDecimal(reader["cena_brez_ddv"])).ToString("#,###.00"); list_items._Cena_brez_ddv = (Convert.ToDecimal(reader["cena_brez_ddv"])); } if (reader["cena_z_ddv"] != DBNull.Value) { list_items.Cena_z_ddv = (Convert.ToDecimal(reader["cena_z_ddv"])).ToString("#,###.00"); list_items._Cena_z_ddv = (Convert.ToDecimal(reader["cena_z_ddv"])); } if (reader["kolicina"] != DBNull.Value) { list_items.Kol = (Convert.ToInt32(reader["kolicina"])); } if (reader["vrednost"] != DBNull.Value) { list_items.Vrednost = (Convert.ToDecimal(reader["vrednost"])).ToString("#,###.00"); list_items._Vrednost = (Convert.ToDecimal(reader["vrednost"])); } if (reader["ddv"] != DBNull.Value) { list_items.Ddv = (Convert.ToDecimal(reader["ddv"])).ToString("#,###.00"); list_items._Ddv = (Convert.ToDecimal(reader["ddv"])); } lvi_list.Add(list_items); } connection.Close(); } } }
private void buttonDelete_Click(object sender, EventArgs e) { if (listViewMain.SelectedItems.Count == 1) { if (MessageBox.Show("정말로 삭제하시겠습니까?", "질문", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { ManageItems manageItems = new ManageItems(this); foreach (ListViewItem LVI in listViewMain.SelectedItems) { manageItems.Delete(LVI.Index); LVI.Remove(); } manageItems.SaveFile(); } } else { MessageBox.Show("삭제하실 항목을 선택해 주세요.", "오류", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } }