/// <summary> /// In báo cáo /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void ptbPrintImport_Click(object sender, EventArgs e) { DateTime TuNgay = dtpkTuNgayThu.Value; DateTime denNgay = dtpkDenNgayThu.Value; CrystalReportBaoCaoThu cr = new CrystalReportBaoCaoThu(); cr.SetDataSource(HoaDonDAO.Instance.getHoaDonbyThoiGian(TuNgay, denNgay)); ParameterFieldDefinitions crParameterFieldDefinitions = cr.DataDefinition.ParameterFields; ParameterFieldDefinition crParameterFieldDefinition = crParameterFieldDefinitions["TuNgay"]; ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue(); crParameterDiscreteValue.Value = TuNgay; ParameterValues crParameterValues = new ParameterValues(); //reset lại value crParameterValues = crParameterFieldDefinition.CurrentValues; crParameterValues.Add(crParameterDiscreteValue); crParameterFieldDefinition.ApplyCurrentValues(crParameterValues); ParameterFieldDefinition crParameterFieldDefinitionDenNgay = crParameterFieldDefinitions["DenNgay"]; ParameterDiscreteValue crParameterDiscreteValueDenNgay = new ParameterDiscreteValue(); crParameterDiscreteValueDenNgay.Value = denNgay; ParameterValues crParameterValuesDenNgay = new ParameterValues(); //reset lại value crParameterValuesDenNgay = crParameterFieldDefinitionDenNgay.CurrentValues; crParameterValuesDenNgay.Add(crParameterDiscreteValueDenNgay); crParameterFieldDefinitionDenNgay.ApplyCurrentValues(crParameterValuesDenNgay); fReport f = new fReport(cr); f.ShowDialog(); }
/// <summary> /// thực hiện thao tác in hóa đơn /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void ptbPrint_Click(object sender, EventArgs e) { //CrystalReport1 cr = new CrystalReport1(); //cr.SetDataSource(DataProvider.Instance.ExecuteQuery("SELECT *FROM dbo.BANAN")); //fReport f = new fReport(cr); //f.ShowDialog(); if (dtgvBills.Tag == null) { fMessageBoxOK.Show("Vui lòng chọn bàn ăn!"); return; } BanAn table = (BanAn)dtgvBills.Tag; totalMonney = 0; foreach (ThongTinHoaDonDTO item in cthdDAO.Instance.getListItemNonCheckByMABA(table.MABA)) { totalMonney += item.SoLuongMA * item.GIA; } preMoney = 0; foreach (string item in HoaDonDAO.Instance.GETHOADONNonCheckByMABA(table.MABA)) { preMoney += cthdDAO.Instance.getTienDaThanhToanByHoaDon(item); } if (dtgvBills.Rows.Count <= 0) { return; } string mahd = (string)dtgvBills.Rows[0].Cells["MAHD"].Value; DataTable data = cthdDAO.Instance.getListPrintBillsbyMAHD(mahd); fReport f = new fReport(data, totalMonney - preMoney); f.ShowDialog(); }
/// <summary> /// Thuc hiện tạo hóa đơn nhập và in hóa đơn /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void ptbPrint_Click(object sender, EventArgs e) { if (listCTHDN.Count <= 0) { return; } if (fMessageBox.Show("Tạo hóa đơn nhập thực phẩm?") == DialogResult.Cancel) { return; } NhaCungCapDTO nhacc = ((NhaCungCapDTO)cbSuplier.SelectedItem); string MAHD = StaticClass.Random(10); if (!HoaDonNhapDAO.Instance.insertHoaDonNhap(MAHD, DateTime.Now, 0, 0)) { fMessageBoxOK.Show("Vui long thuc hien lai!"); return; } foreach (CTHDNdto item in listCTHDN) { CTHDNdao.Instance.insertCTHDN(MAHD, item.MATP, item.SoLuongThucPham); CTTPdao.Instance.insertCTTP(item.MATP, nhacc.MANCC); } fReport f = new fReport(MAHD, nhacc.MANCC); f.ShowDialog(); listCTHDN.Clear(); listCTHDN = new List <CTHDNdto>(); dtgvCTHDN.DataSource = listCTHDN; ptbSearch_Click(this, new EventArgs()); }
/// <summary> /// in hóa đơn đặt bàn trước! /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void ptbPrint_Click(object sender, EventArgs e) { if (cbTenKhachHang.SelectedItem == null) { return; } KhachHangHoaDonDTO kh = (KhachHangHoaDonDTO)cbTenKhachHang.SelectedItem; DataTable data = cthdDAO.Instance.getListPrintBillsbyMAHD(kh.MAHD); fReport f = new fReport(data, PrePrice); f.ShowDialog(); }
/// <summary> /// In báo cáo chi. 0 hóa đơn nhâp. 1 tiền lương nhân viên /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void ptbPrintExport_Click(object sender, EventArgs e) { switch (((BaoCaoChi)cbChi.SelectedItem).BaoCao) { case 0: DateTime TuNgay = dtpkTuNgayChi.Value; DateTime denNgay = dtpkDenNgayChi.Value; CrystalReportBaoCaoChiNhapThucPham cr = new CrystalReportBaoCaoChiNhapThucPham(); cr.SetDataSource(HoaDonNhapDAO.Instance.getListHoaDonNhapTuNgayDenNgay(TuNgay, denNgay)); ParameterFieldDefinitions crParameterFieldDefinitions = cr.DataDefinition.ParameterFields; ParameterFieldDefinition crParameterFieldDefinition = crParameterFieldDefinitions["TuNgay"]; ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue(); crParameterDiscreteValue.Value = TuNgay; ParameterValues crParameterValues = new ParameterValues(); //reset lại value crParameterValues = crParameterFieldDefinition.CurrentValues; crParameterValues.Add(crParameterDiscreteValue); crParameterFieldDefinition.ApplyCurrentValues(crParameterValues); ParameterFieldDefinition crParameterFieldDefinitionDenNgay = crParameterFieldDefinitions["DenNgay"]; ParameterDiscreteValue crParameterDiscreteValueDenNgay = new ParameterDiscreteValue(); crParameterDiscreteValueDenNgay.Value = denNgay; ParameterValues crParameterValuesDenNgay = new ParameterValues(); //reset lại value crParameterValuesDenNgay = crParameterFieldDefinitionDenNgay.CurrentValues; crParameterValuesDenNgay.Add(crParameterDiscreteValueDenNgay); crParameterFieldDefinitionDenNgay.ApplyCurrentValues(crParameterValuesDenNgay); fReport f = new fReport(cr); f.ShowDialog(); break; case 1: DateTime TuNgaya = dtpkTuNgayChi.Value; DateTime denNgaya = dtpkDenNgayChi.Value; CrystalReportBaoCaoChiLuongNhanVien cr1 = new CrystalReportBaoCaoChiLuongNhanVien(); cr1.SetDataSource(BangLuongNhanVienDAO.Instance.getListBangLuongTuNgayDenNgay(TuNgaya, denNgaya)); ParameterFieldDefinitions crParameterFieldDefinitions1 = cr1.DataDefinition.ParameterFields; ParameterFieldDefinition crParameterFieldDefinition1 = crParameterFieldDefinitions1["TuNgay"]; ParameterDiscreteValue crParameterDiscreteValue1 = new ParameterDiscreteValue(); crParameterDiscreteValue1.Value = TuNgaya; ParameterValues crParameterValues1 = new ParameterValues(); //reset lại value crParameterValues1 = crParameterFieldDefinition1.CurrentValues; crParameterValues1.Add(crParameterDiscreteValue1); crParameterFieldDefinition1.ApplyCurrentValues(crParameterValues1); ParameterFieldDefinition crParameterFieldDefinitionDenNgay1 = crParameterFieldDefinitions1["DenNgay"]; ParameterDiscreteValue crParameterDiscreteValueDenNgay1 = new ParameterDiscreteValue(); crParameterDiscreteValueDenNgay1.Value = denNgaya; ParameterValues crParameterValuesDenNgay1 = new ParameterValues(); //reset lại value crParameterValuesDenNgay1 = crParameterFieldDefinitionDenNgay1.CurrentValues; crParameterValuesDenNgay1.Add(crParameterDiscreteValueDenNgay1); crParameterFieldDefinitionDenNgay1.ApplyCurrentValues(crParameterValuesDenNgay1); fReport f1 = new fReport(cr1); f1.ShowDialog(); break; } }
/// <summary> /// Xem chi tiết báo cáo /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnChiTiet_Click(object sender, EventArgs e) { switch (((PhuongThuctimKiem)cbThongKe.SelectedItem).Loai) { case 0: string tenma = StaticClass.xoakhoangtrang(txbSearchFood.Text); DateTime tuNgay = dtpkTuNgay.Value; DateTime denNgay = dtpkDenNgay.Value; CrystalReportThongKeTenMonAn cr = new CrystalReportThongKeTenMonAn(); cr.SetDataSource(HoaDonDAO.Instance.USP_getThongKeTheoTenchiTiet(tenma, tuNgay, denNgay)); ParameterFieldDefinitions crParameterFieldDefinitions = cr.DataDefinition.ParameterFields; ParameterFieldDefinition crParameterFieldDefinition = crParameterFieldDefinitions["TuNgay"]; ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue(); crParameterDiscreteValue.Value = tuNgay; ParameterValues crParameterValues = new ParameterValues(); //reset lại value crParameterValues = crParameterFieldDefinition.CurrentValues; crParameterValues.Add(crParameterDiscreteValue); crParameterFieldDefinition.ApplyCurrentValues(crParameterValues); ParameterFieldDefinition crParameterFieldDefinitionDenNgay = crParameterFieldDefinitions["DenNgay"]; ParameterDiscreteValue crParameterDiscreteValueDenNgay = new ParameterDiscreteValue(); crParameterDiscreteValueDenNgay.Value = denNgay; ParameterValues crParameterValuesDenNgay = new ParameterValues(); //reset lại value crParameterValuesDenNgay = crParameterFieldDefinitionDenNgay.CurrentValues; crParameterValuesDenNgay.Add(crParameterDiscreteValueDenNgay); crParameterFieldDefinitionDenNgay.ApplyCurrentValues(crParameterValuesDenNgay); fReport f = new fReport(cr); f.ShowDialog(); break; case 1: string tenLoai = StaticClass.xoakhoangtrang(txbSearchFood.Text); DateTime tuNgayLoai = dtpkTuNgay.Value; DateTime denNgayLoai = dtpkDenNgay.Value; CrystalReportThongKeLoaiMonAn crLoai = new CrystalReportThongKeLoaiMonAn(); crLoai.SetDataSource(HoaDonDAO.Instance.USP_getThongKeTheoLoaichiTiet(tenLoai, tuNgayLoai, denNgayLoai)); ParameterFieldDefinitions crParameterFieldDefinitionsLoai = crLoai.DataDefinition.ParameterFields; ParameterFieldDefinition crParameterFieldDefinitionLoai = crParameterFieldDefinitionsLoai["TuNgay"]; ParameterDiscreteValue crParameterDiscreteValueLoai = new ParameterDiscreteValue(); crParameterDiscreteValueLoai.Value = tuNgayLoai; ParameterValues crParameterValuesLoai = new ParameterValues(); //reset lại value crParameterValues = crParameterFieldDefinitionLoai.CurrentValues; crParameterValues.Add(crParameterDiscreteValueLoai); crParameterFieldDefinitionLoai.ApplyCurrentValues(crParameterValues); ParameterFieldDefinition crParameterFieldDefinitionDenNgayLoai = crParameterFieldDefinitionsLoai["DenNgay"]; ParameterDiscreteValue crParameterDiscreteValueDenNgayLoai = new ParameterDiscreteValue(); crParameterDiscreteValueDenNgayLoai.Value = denNgayLoai; ParameterValues crParameterValuesDenNgayLoai = new ParameterValues(); //reset lại value crParameterValuesDenNgayLoai = crParameterFieldDefinitionDenNgayLoai.CurrentValues; crParameterValuesDenNgayLoai.Add(crParameterDiscreteValueDenNgayLoai); crParameterFieldDefinitionDenNgayLoai.ApplyCurrentValues(crParameterValuesDenNgayLoai); fReport fLoai = new fReport(crLoai); fLoai.ShowDialog(); break; } }