private void LuuDuLieuTuImportExcel(DataTable dt) { List <CHI_TIET_PHIEU_NHAP> l = new List <CHI_TIET_PHIEU_NHAP>(); int idphieunhap = _nhapHangBLL.LayIDPhieuNhapTheoSoPhieuNhap(txt_SoPhieuNhap.Text); foreach (DataRow dr in dt.Rows) { int idNguyenLieu; if (_nguyenlieuBLL.KiemTraNguyenLieuTonTai(dr["Ma_Nguyen_Lieu"].ToString()) != true) { DataRow drt = dtChiTietPhieuNhap.NewRow(); NGUYEN_LIEU n = new NGUYEN_LIEU(); n.Ma_Nguyen_Lieu = dr["Ma_Nguyen_Lieu"].ToString(); n.Ten_Nguyen_Lieu = dr["Ten_Nguyen_Lieu"].ToString(); n.So_Luong_Ton = 0; idNguyenLieu = _nguyenlieuBLL.ThemNguyenLieuMoi(n); LoadNguyenLieu(); CHI_TIET_PHIEU_NHAP c = new CHI_TIET_PHIEU_NHAP(); c.ID_Nguyen_Lieu = idNguyenLieu; c.ID_Phieu_Nhap = idphieunhap; drt["So_Luong"] = c.So_Luong = int.Parse(dr["So_Luong"].ToString()); drt["Don_Gia"] = c.Don_Gia = int.Parse(dr["Don_Gia"].ToString()); drt["Thanh_Tien"] = c.Thanh_Tien = c.So_Luong * c.Don_Gia; drt["ID_Nguyen_Lieu"] = gridView2.GetRowCellValue(gridView2.RowCount - 1, "ID_Nguyen_Lieu"); l.Add(c); dtChiTietPhieuNhap.Rows.Add(drt); } } _nhapHangBLL.ThemChiTietPhieuNhap(l, idphieunhap); }
private void btnXuatPhieu_Click(object sender, EventArgs e) { ExcelExport excel = new ExcelExport(); SaveFileDialog saveFile = new SaveFileDialog(); if (dtgvChiTietPN.Rows.Count == 0) { MessageBox.Show("Không có dữ liệu để xuất", "ERROR"); return; } List <CHI_TIET_PHIEU_NHAP> pList = new List <CHI_TIET_PHIEU_NHAP>(); foreach (DataGridViewRow item in dtgvChiTietPN.Rows) { CHI_TIET_PHIEU_NHAP i = new CHI_TIET_PHIEU_NHAP(); i.MaSP = Convert.ToInt32(item.Cells[5].Value.ToString()); i.MaPN = item.Cells[4].Value.ToString(); i.SoLuong = Convert.ToInt32(item.Cells[8].Value.ToString()); i.GiaNhap = Convert.ToInt32(item.Cells[6].Value); i.DonViTinh = item.Cells[3].Value.ToString(); //i.DonViTinh = item.Cells[3].Value.ToString(); //i.GiaBan = Convert.ToInt32(item.Cells[5].Value); //i.GiaVon = Convert.ToInt32(item.Cells[6].Value); ; pList.Add(i); } string path = string.Empty; excel.ExportPhieuNhap(pList, ref path, false); if (!string.IsNullOrEmpty(path) && MessageBox.Show("Bạn có muốn mở file không?", "Thông tin", MessageBoxButtons.YesNo, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1) == System.Windows.Forms.DialogResult.Yes) { System.Diagnostics.Process.Start(path); } }
private void btn_Luu_Click(object sender, EventArgs e) { if (IsValidate()) { PHIEU_NHAP pn = new PHIEU_NHAP(); pn.ID_NCC = int.Parse(lkup_NhaCungCap.EditValue.ToString()); pn.So_Phieu_Nhap = txt_SoPhieuNhap.Text; pn.Ngay_Lap = dt_NgayLap.DateTime; pn.Tong_Tien = decimal.Parse(txt_ThanhTien.Text); pn.VAT = (double?)spin_VAT.Value; pn.Giam_Gia = (double?)spin_GiamGia.Value; // Thêm phiếu nhập int idPhieuNhap; if (IsUpdate == false) { idPhieuNhap = _nhapHangBLL.ThemPhieuNhapHang(pn); } else { pn.ID_Phieu_Nhap = _nhapHangBLL.LayIDPhieuNhapTheoSoPhieuNhap(pn.So_Phieu_Nhap); idPhieuNhap = pn.ID_Phieu_Nhap; _nhapHangBLL.CapNhatPhieuNhap(pn); } List <CHI_TIET_PHIEU_NHAP> dsChiTietPN = new List <CHI_TIET_PHIEU_NHAP>(); if (gridView_CTPN.RowCount > 0) { for (int i = 0; i < gridView_CTPN.RowCount; i++) { CHI_TIET_PHIEU_NHAP ct = new CHI_TIET_PHIEU_NHAP(); ct.ID_Phieu_Nhap = idPhieuNhap; ct.ID_Nguyen_Lieu = int.Parse(gridView_CTPN.GetRowCellValue(i, "ID_Nguyen_Lieu").ToString()); ct.So_Luong = int.Parse(gridView_CTPN.GetRowCellValue(i, "So_Luong").ToString()); ct.Don_Gia = int.Parse(gridView_CTPN.GetRowCellValue(i, "Don_Gia").ToString()); ct.Thanh_Tien = int.Parse(gridView_CTPN.GetRowCellValue(i, "Thanh_Tien").ToString()); dsChiTietPN.Add(ct); } } _nhapHangBLL.ThemChiTietPhieuNhap(dsChiTietPN, idPhieuNhap); Utils.Notification.Success("Thêm mới phiếu nhập hàng thành công!"); Frm_Nhap_Hang_Load(sender, e); // Load lại tất cả dư liệu thay đổi ClearAll(); // Refresh data control } }