private void btnIn_Click(object sender, EventArgs e)
{
ExcelExport ex = new ExcelExport();
if (dgvNCC.Rows.Count == 0)
{
MessageBox.Show("Khong co du lieu de Xuat");
return;
}
List <INDSNCC> plistdiem = new List <INDSNCC>();
int Stt = 1;
string path = "";
foreach (DataGridViewRow item in dgvNCC.Rows)
{
INDSNCC d = new INDSNCC();
d.MaNCC = item.Cells[0].Value.ToString();
d.TenNCC = item.Cells[1].Value.ToString();
d.DiaChi = item.Cells[2].Value.ToString();
d.DienThoai = item.Cells[3].Value.ToString();
d.STT = Stt.ToString();
Stt++;
plistdiem.Add(d);
path = string.Empty;
ex.ExportDSNCC(plistdiem, ref path, false);
}
ex.OpenFile(path);
}
private void btnIN_Click(object sender, EventArgs e)
{
ExcelExport ex = new ExcelExport();
if (dgvCTPN.Rows.Count == 0)
{
MessageBox.Show("Khong co du lieu de Xuat");
return;
}
List <INPHIEUNHAP> plistdiem = new List <INPHIEUNHAP>();
int Stt = 1;
string path = "";
for (int i = 0; i < dgvCTPN.Rows.Count - 1; i++)
{
INPHIEUNHAP d = new INPHIEUNHAP();
d.TENHANG = dgvCTPN.Rows[i].Cells[1].Value.ToString();
d.SOLUONG = int.Parse(dgvCTPN.Rows[i].Cells[2].Value.ToString());
d.DONGIA = float.Parse(dgvCTPN.Rows[i].Cells[3].Value.ToString());
d.THANHTIEN = int.Parse(dgvCTPN.Rows[i].Cells[2].Value.ToString()) * float.Parse(dgvCTPN.Rows[i].Cells[3].Value.ToString());
d.STT = Stt.ToString();
Stt++;
plistdiem.Add(d);
path = string.Empty;
ex.ExportPhieuNhap(plistdiem, ref path, false, txtMaPN.Text, txtNgayHD.Text, cboNV.Text);
}
ex.OpenFile(path);
}
public void InHD()
{
ExcelExport ex = new ExcelExport();
if (dgvCTHD.Rows.Count == 0)
{
MessageBox.Show("Khong co du lieu de Xuat");
return;
}
List <INHOADON> plistdiem = new List <INHOADON>();
int Stt = 1;
string path = "";
for (int i = 0; i < dgvCTHD.Rows.Count - 1; i++)
{
INHOADON d = new INHOADON();
d.TENHANG = dgvCTHD.Rows[i].Cells[1].Value.ToString();
d.SOLUONG = int.Parse(dgvCTHD.Rows[i].Cells[2].Value.ToString());
d.DONGIA = float.Parse(dgvCTHD.Rows[i].Cells[3].Value.ToString());
d.THANHTIEN = float.Parse(dgvCTHD.Rows[i].Cells[4].Value.ToString());
d.STT = Stt.ToString();
Stt++;
plistdiem.Add(d);
path = string.Empty;
ex.ExportHOADON(plistdiem, ref path, false, txtMaHD.Text, txtNgayHD.Text, cboNV.Text, cboKH.Text);
}
ex.OpenFile(path);
}
public void InDS()
{
ExcelExport ex = new ExcelExport();
if (dgvHangHoa.Rows.Count == 0)
{
MessageBox.Show("Khong co du lieu de Xuat");
return;
}
List <INDSHANG> plistdiem = new List <INDSHANG>();
int Stt = 1;
string path = "";
foreach (DataGridViewRow item in dgvHangHoa.Rows)
{
INDSHANG d = new INDSHANG();
d.MaHH = item.Cells[0].Value.ToString();
d.TenHH = item.Cells[1].Value.ToString();
d.DonGia = float.Parse(item.Cells[2].Value.ToString());
d.SoLuongTon = int.Parse(item.Cells[3].Value.ToString());
d.Loai = item.Cells[5].Value.ToString();
d.NCC = item.Cells[7].Value.ToString();
d.STT = Stt.ToString();
Stt++;
plistdiem.Add(d);
path = string.Empty;
ex.ExportDSHang(plistdiem, ref path, false);
}
ex.OpenFile(path);
}
private void xuatFileExcel()
{
ExcelExport ex = new ExcelExport();
List <QL_ChiTietHoaDon> dsKhoa = lstChiTiet;
if (dsKhoa.Count == 0)
{
MessageBox.Show("Không có dữ liệu");
}
QL_HoaDon_BanHang hdbh = hd_bll.layHD(maHD);
List <QL_ChiTietHoaDon> pListSP = new List <QL_ChiTietHoaDon>();
if (checkDungDiem.Checked)
{
hdbh.DiemDung = diemDung;
}
hdbh.TongTienThat = Convert.ToInt32(lbTongTien.Text);
// Đỗ dữ liệu vào danh sách
int Stt = 1;
foreach (QL_ChiTietHoaDon item in dsKhoa)
{
QL_ChiTietHoaDon chitiet = new QL_ChiTietHoaDon();
QL_SanPham sphientai = sp_bll.laySP(item.MaSP);
chitiet.TenSanPham = sphientai.TenSanPham;
chitiet.DonGia = item.DonGia;
chitiet.Soluong = item.Soluong;
chitiet.STT = Stt.ToString();
Stt++;
pListSP.Add(chitiet);
}
string path = string.Empty;
ex.ExportKhoa(hdbh, pListSP, ref path, false);
if (!string.IsNullOrEmpty(path) && MessageBox.Show("Bạn có muốn mở file", "Xác Nhận", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
System.Diagnostics.Process.Start(path);
}
}
private void btn_bc_Click(object sender, EventArgs e)
{
ExcelExport excel = new ExcelExport();
List <Ve> listVe = new List <Ve>();
for (int i = 0; i < gridView1.DataRowCount; i++)
{
Ve v = new Ve();
v.STT = i;
v.KHACH_HANG = gridView1.GetRowCellValue(i, "KHACH_HANG.TEN").ToString();
v.LICH = gridView1.GetRowCellValue(i, "LICH_KHOI_HANH.TEN_LICH").ToString();
if (gridView1.GetRowCellValue(i, "LOAI_THANH_TOAN.TEN_LOAI_TT") != null)
{
v.LOAI_TT = gridView1.GetRowCellValue(i, "LOAI_THANH_TOAN.TEN_LOAI_TT").ToString();
}
v.NGAY_DAT = gridView1.GetRowCellValue(i, "NGAY_DAT").ToString();
v.TONG_TIEN = double.Parse(gridView1.GetRowCellValue(i, "TONG_TIEN").ToString());
v.DIEM_DON = gridView1.GetRowCellValue(i, "DIEM_DON").ToString();
listVe.Add(v);
}
if (listVe.Count <= 0)
{
MessageBox.Show("Không có dữ liệu để xuất");
return;
}
string path = string.Empty;
excel.ExportExcelVe(listVe, ref path, false);
// Confirm for open file was exported
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);
}
else
{
MessageBox.Show("Khổng thể xuất file!", "Thông báo");
}
}
private void btn_In_Dong_Click(object sender, EventArgs e)
{
try
{
double d = double.Parse(txt_TienTraLai.Text);
if (d < 0)
{
MessageBox.Show("Mời nhập tiền");
return;
}
}
catch (Exception ee)
{
MessageBox.Show("Mời nhập tiền");
return;
}
try
{
//th1: khach mua mang di
if (ca.getFlag() == 0)
{
DateTime dt = DateTime.Now;
int maB = ca.getMaBan();
int maNV = ca.getMaNV();
String PT = "Cash";
double tong = ca.tinhTong();
String TT = "Roi";
int x = hd.LuuHoaDon2(dt, maB, maNV, PT, tong, TT);
List <Item> lstCart = ca.getCart();
foreach (Item i in lstCart)
{
int maHD = x;
int maMon = i.maMon;
int sl = i.sl;
double tong2 = i.tongTien;
ct.LuuChiTietHD(maHD, maMon, sl, tong2);
}
//thong bao xong
ca.clearCard2();
ca.clearCard();
this.Dispose();
if (Program.frmCNC.Visible == false)
{
Program.frmCNC = new Form_ChucNangChinh();
}
Program.frmCNC.Show();
MessageBox.Show("Thanh Toán Thành Công");
//goi hd ra
tblHoaDon hoaDon = hd.getMaHDTheoMaHD(x);
//xuat file excel
ExcelExport ex = new ExcelExport();
List <tblChiTietHD> lstCTExcel = ct.getCTByMaHD(x).ToList();
string path = string.Empty;
DateTime?dtVao = hoaDon.TGVao;
DateTime?dtRa = hoaDon.TGRa;
double tien1 = 0;
double tien2 = 0;
try
{
tien1 = double.Parse(txt_TienKhachDua.Text);
tien2 = double.Parse(txt_TienTraLai.Text);
}
catch (Exception ee)
{
tien1 = 0;
tien2 = 0;
}
ex.ExportKhoa(lstCTExcel, ref path, false, dtVao.Value, dtRa.Value, (double)hoaDon.TongTienTT, lstCTExcel.Count, tien1, tien2, x, hoaDon.MaBan, hoaDon.MaNV);
if (!string.IsNullOrEmpty(path) && MessageBox.Show("Bạn muốn mở file", "Thông tin", MessageBoxButtons.YesNo, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1) == DialogResult.Yes)
{
System.Diagnostics.Process.Start(path);
}
}
if (ca.getFlag() == 1)
{
//khach tinh tien sau khi ngoi tai quan
int maHDExcel = 0;
if (ca.getCart2().Count == 0)
{
tblHoaDon h = hd.getMaHDTheoBan(ca.getMaBan());
maHDExcel = h.MaHD;
//DateTime dt = DateTime.Today;
DateTime dt = DateTime.Now;
hd.suaHoaDon(h.MaHD, dt, "Roi");
ca.clearCard2();
ca.clearCard();
this.Dispose();
if (Program.frmCNC.Visible == false)
{
Program.frmCNC = new Form_ChucNangChinh();
}
Program.frmCNC.Show();
}
//khach ngoi tai quan nhung order them roi tinh tien luon
else if (ca.getCart2().Count > 0)
{
tblHoaDon h = hd.getMaHDTheoBan(ca.getMaBan());
maHDExcel = h.MaHD;
List <tblChiTietHD> lstCT = ct.getCTByMaHD(h.MaHD).ToList <tblChiTietHD>();
List <Item> lstCart = ca.getCart2();
double tong1 = ca.tinhTong2();
//update lai chi tiet
for (int i = 0; i < lstCT.Count; i++)
{
for (int j = 0; j < lstCart.Count; j++)
{
if (lstCT[i].MaMon == lstCart[j].maMon)
{
ct.suaChiTietHD(lstCT[i].MaHD, lstCT[i].MaMon, (lstCart[j].sl + lstCT[i].SoLuong), (lstCart[j].tongTien + (double)lstCT[i].TongTien));
lstCart.Remove(lstCart[j]);
j--;
}
}
}
//them cac chi tiet moi
foreach (Item i in lstCart)
{
int maHD = h.MaHD;
int maMon = i.maMon;
int sl = i.sl;
double tong = i.tongTien;
ct.LuuChiTietHD(maHD, maMon, sl, tong);
}
//update lai tong tien cho hoa don
hd.suaHoaDon(h.MaHD, (tong1 + (double)h.TongTienTT));
//update lai trang thai
DateTime dt = DateTime.Now;
hd.suaHoaDon(h.MaHD, dt, "Roi");
//thong bao xong
ca.clearCard2();
ca.clearCard();
this.Dispose();
if (Program.frmCNC.Visible == false)
{
Program.frmCNC = new Form_ChucNangChinh();
}
Program.frmCNC.Show();
}
MessageBox.Show("Thanh Toán Thành Công");
//goi hoa don ra
tblHoaDon hoaDon = hd.getMaHDTheoMaHD(maHDExcel);
//xuat file excel
ExcelExport ex = new ExcelExport();
List <tblChiTietHD> lstCTExcel = ct.getCTByMaHD(maHDExcel).ToList();
string path = string.Empty;
DateTime?dtVao = hoaDon.TGVao;
DateTime?dtRa = hoaDon.TGRa;
double tien1 = 0;
double tien2 = 0;
try
{
tien1 = double.Parse(txt_TienKhachDua.Text);
tien2 = double.Parse(txt_TienTraLai.Text);
}
catch (Exception ee)
{
tien1 = 0;
tien2 = 0;
}
ex.ExportKhoa(lstCTExcel, ref path, false, dtVao.Value, dtRa.Value, (double)hoaDon.TongTienTT, lstCTExcel.Count, tien1, tien2, maHDExcel, hoaDon.MaBan, hoaDon.MaNV);
if (!string.IsNullOrEmpty(path) && MessageBox.Show("Bạn muốn mở file", "Thông tin", MessageBoxButtons.YesNo, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1) == DialogResult.Yes)
{
System.Diagnostics.Process.Start(path);
}
}
}
catch (Exception ee)
{ }
}
