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
}
}
