private void dataGridView1_CellMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e) { string mapn = dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString(); string malpx = dataGridView1.Rows[e.RowIndex].Cells[1].Value.ToString(); string manv = dataGridView1.Rows[e.RowIndex].Cells[2].Value.ToString(); string mattp = dataGridView1.Rows[e.RowIndex].Cells[3].Value.ToString(); string ngaylapphieu = dataGridView1.Rows[e.RowIndex].Cells[4].Value.ToString(); string ngaynhap = dataGridView1.Rows[e.RowIndex].Cells[5].Value.ToString(); string nd = dataGridView1.Rows[e.RowIndex].Cells[6].Value.ToString(); Form form = new ChiTietPhieuNhap(mapn, malpx, manv, mattp, ngaylapphieu, ngaynhap, nd); form.Show(); }
private ChiTietPhieuNhap GetDataChiTietPN() { if (txtSoLuong.Text == "") { txtSoLuong.Text = "0"; } ChiTietPhieuNhap chiTiet = new ChiTietPhieuNhap() { MaPN = txtMaPN.Text, MaHH = MaHH(), SoLuong = int.Parse(txtSoLuong.Text), ThanhTien = float.Parse(txtThanhTien.Text), GhiChu = rtxtGhiChu.Text }; return(chiTiet); }
private void btnSave_Click(object sender, EventArgs e) { ChiTietPhieuNhap chiTiet; if (importNew == true) { PhieuNhap phieuNhap = new PhieuNhap() { MaPN = txtMaPN.Text.ToUpper(), MaNV = Config.CURRENT_NHANVIEN, MaNCC = cbbTenNCC.SelectedValue.ToString(), NgayNhap = dtpNgayNhap.Value, ChietKhau = 0, ThanhTien = int.Parse(txtTongTien.Text), TongTien = int.Parse(txtTongTien.Text), GhiChu = rtxtGhiChu.Text }; int res = Bus.AddPhieuNhap(phieuNhap); int result; chiTiet = new ChiTietPhieuNhap(); foreach (DataRow dr in dataTableChiTiet.Rows) { chiTiet = new ChiTietPhieuNhap() { MaHH = dr["MaHH"].ToString(), MaPN = dr["MaPN"].ToString(), SoLuong = int.Parse(dr["SoLuong"].ToString()), GhiChu = dr["GhiChu"].ToString(), ThanhTien = int.Parse(dr["ThanhTien"].ToString()), DonGia = int.Parse(dr["DonGia"].ToString()) }; result = Bus.AddChiTietPhieuNhap(chiTiet); } // int res = Bus.AddPhieuNhap(phieuNhap); // int result = Bus.AddChiTietPhieuNhap(chiTiet); if (res > 0) { MessageBox.Show("Thêm hóa đơn thành công!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon .Information); } else { MessageBox.Show("Thêm hóa đơn thất bại!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon .Information); } } else { PhieuNhap phieuNhap = new PhieuNhap() { MaPN = txtMaPN.Text.ToUpper(), MaNV = Config.CURRENT_NHANVIEN, MaNCC = cbbTenNCC.SelectedValue.ToString(), NgayNhap = dtpNgayNhap.Value, ChietKhau = 0, ThanhTien = int.Parse(txtTongTien.Text), TongTien = int.Parse(txtTongTien.Text), GhiChu = rtxtGhiChu.Text }; int a = Bus.DeleteCTPN(MaPN); chiTiet = new ChiTietPhieuNhap(); foreach (DataRow dr in dataTableChiTiet.Rows) { chiTiet = new ChiTietPhieuNhap(); chiTiet.MaHH = dr["MaHH"].ToString(); chiTiet.MaPN = dr["MaPN"].ToString(); chiTiet.SoLuong = int.Parse(dr["SoLuong"].ToString()); chiTiet.GhiChu = dr["GhiChu"].ToString(); chiTiet.ThanhTien = int.Parse(dr["ThanhTien"].ToString()); chiTiet.DonGia = int.Parse(dr["DonGia"].ToString()); int result = Bus.UpdateChiTietPhieuNhap(chiTiet); } int res = Bus.UpdatePhieuNhap(phieuNhap); // int a = Bus.DeleteCTPN(MaPN); // int result = Bus.UpdateChiTietPhieuNhap(chiTiet); if (res > 0) { MessageBox.Show("Update thanh cong!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon .Information); } else { MessageBox.Show("Update that bai", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon .Information); } } // MessageBox.Show("Thêm Hóa Đơn thành công!", "Thông báo", MessageBoxButtons.OK); this.Close(); }
private void btnAdd_Click(object sender, EventArgs e) { tongTien = 0; if (txtDonGia.Text == "" || txtDonGia.Text == null) { MessageBox.Show("Nhap don gia"); } txtThanhTien.Text = (int.Parse(txtDonGia.Text) * int.Parse(txtSoLuong.Text)).ToString(); if (tongTien > 1700000000) { MessageBox.Show("Số tiền của bạn quá cao"); } else { if (action == 1) { foreach (DataRow dr in dataTableChiTiet.Rows) { if (dr["MaHH"].ToString() == cbbTenHH.SelectedValue.ToString()) { int quantity = int.Parse(txtSoLuong.Text); int b = int.Parse((int.Parse(txtDonGia.Text) * (quantity - int.Parse(dr["SoLuong"].ToString()))).ToString()); //if ((quantity - int.Parse(dr["SoLuong"].ToString())) > 0) //{ // tongTien = tongTien + b; //} //else //{ // tongTien = tongTien - (int.Parse(txtDonGia.Text) * (int.Parse(dr["SoLuong"].ToString()) - quantity)); //} dr["SoLuong"] = quantity; dr["ThanhTien"] = quantity * int.Parse(txtDonGia.Text); dr["DonGia"] = txtDonGia.Text; btnAdd.Text = "Thêm"; // tongTien = 0; } tongTien += int.Parse(dr["ThanhTien"].ToString()); } } else { int a = 0; foreach (DataRow dr in dataTableChiTiet.Rows) { if (dr["MaHH"].ToString() == cbbTenHH.SelectedValue.ToString()) { a = 1; int quantity = int.Parse(txtSoLuong.Text); dr["SoLuong"] = int.Parse(dr["SoLuong"].ToString()) + quantity; dr["ThanhTien"] = int.Parse(dr["SoLuong"].ToString()) * int.Parse(txtDonGia.Text); dr["DonGia"] = txtDonGia.Text; //tongTien = 0; tongTien += int.Parse(dr["ThanhTien"].ToString()); } } if (a != 1) { DataRow newChiTiet = dataTableChiTiet.NewRow(); ChiTietPhieuNhap chiTiet = GetDataChiTietPN(); newChiTiet["MaPN"] = chiTiet.MaPN; newChiTiet["MaHH"] = chiTiet.MaHH; newChiTiet["TenHang"] = cbbTenHH.Text; newChiTiet["SoLuong"] = chiTiet.SoLuong; newChiTiet["DonGia"] = txtDonGia.Text; newChiTiet["ThanhTien"] = chiTiet.SoLuong * int.Parse(txtDonGia.Text); newChiTiet["GhiChu"] = rtxtGhiChu.Text; dataTableChiTiet.Rows.Add(newChiTiet); dgvChiTietPhieuNhap.DataSource = dataTableChiTiet; foreach (DataRow dr in dataTableChiTiet.Rows) { // tongTien = 0; tongTien += int.Parse(dr["ThanhTien"].ToString()); } } dgvChiTietPhieuNhap.DataSource = dataTableChiTiet; // tongTien = tongTien + int.Parse(txtThanhTien.Text); } txtTongTien.Text = tongTien.ToString(); btnAddNewImport.Enabled = true; btnSave.Enabled = true; btnCancel.Enabled = false; btnEdit.Enabled = false; btnDelete.Enabled = false; btnAdd.Enabled = false; txtSoLuong.Enabled = false; cbbTenHH.Enabled = false; txtDonGia.Text = "0"; txtDonGia.Enabled = false; status = 0; action = 0; } }