private void FrmBaoCaoTonKho_Load(object sender, EventArgs e) { LayThongTinBaoCao(); DataTable dsmh = new DataTable(); DataTable ds = new DataTable(); dsmh = bus_baocaotonkho.LayDanhSachMatHang(dto_baocaotonkho); ds = bus_baocaotonkho.LayDanhSachMatHang(dto_baocaotonkho); ds.Columns.Add("SLBan"); ds.Columns.Add("SLNhap"); ds.Columns.Add("SLTon"); ds.Columns.Add("SLThuc"); for (int i = 0; i < ds.Rows.Count; i++) { ds.Rows[i]["SLBan"] = bus_baocaotonkho.LaySLBan(dto_baocaotonkho, ds.Rows[i]["MaMH"].ToString()).Rows[0][1].ToString(); ds.Rows[i]["SLNhap"] = bus_baocaotonkho.LaySLNhap(dto_baocaotonkho, ds.Rows[i]["MaMH"].ToString()).Rows[0][1].ToString(); double SLTon = Double.Parse(ds.Rows[i]["SLNhap"].ToString()) - Double.Parse(ds.Rows[i]["SLBan"].ToString());//bus_baocaotonkho.TongGiaTriBan(dto_baocaotonkho, ds.Rows[i]["MaMH"].ToString()); ds.Rows[i]["SLTon"] = SLTon.ToString(); double SLThuc = 0;//bus_baocaotonkho.TongGiaTriNhap(dto_baocaotonkho, ds.Rows[i]["MaMH"].ToString()); ds.Rows[i]["SLThuc"] = SLThuc.ToString(); } ds.Columns.Remove("MaMH"); reportViewer1.Reset(); reportViewer1.LocalReport.ReportEmbeddedResource = "GUI_QLVLXD.BaoCaoTonKho.rdlc"; reportViewer1.LocalReport.DataSources.Clear(); Microsoft.Reporting.WinForms.ReportDataSource newDataSource = new Microsoft.Reporting.WinForms.ReportDataSource("BaocaoTonKho", ds); newDataSource.Name = "DataSet1"; reportViewer1.LocalReport.DataSources.Add(newDataSource); List<Microsoft.Reporting.WinForms.ReportParameter> Parameters = new List<Microsoft.Reporting.WinForms.ReportParameter>(); Microsoft.Reporting.WinForms.ReportParameter param = default(Microsoft.Reporting.WinForms.ReportParameter); param = new Microsoft.Reporting.WinForms.ReportParameter("TuNgay", dto_baocaotonkho.TuNgay); Parameters.Add(param); param = new Microsoft.Reporting.WinForms.ReportParameter("DenNgay", dto_baocaotonkho.DenNgay); Parameters.Add(param); reportViewer1.LocalReport.SetParameters(Parameters); this.reportViewer1.RefreshReport(); }
private void frHoaDonIn_Load(object sender, EventArgs e) { string mahd = HoaDonDAO.Instance.getMaxMaHD(); HoaDon hd = HoaDonDAO.Instance.getHoaDon(mahd); KhachHang kh = KhachHangDAO.Instance.getKHbyMaHD(mahd); this.getCTPYCTableAdapter.Fill(this.QUANLYNHAHANGDataSet.getCTPYC, Data.MaPYC); Microsoft.Reporting.WinForms.ReportParameter[] p = new Microsoft.Reporting.WinForms.ReportParameter[] { new Microsoft.Reporting.WinForms.ReportParameter("mahd", mahd), new Microsoft.Reporting.WinForms.ReportParameter("maban", Data.Maban), new Microsoft.Reporting.WinForms.ReportParameter("ngaylap", hd.Ngaylap.ToString()), new Microsoft.Reporting.WinForms.ReportParameter("makh", kh.Makh), new Microsoft.Reporting.WinForms.ReportParameter("tenkh", kh.Tenkh), new Microsoft.Reporting.WinForms.ReportParameter("sdt", kh.Sdt), new Microsoft.Reporting.WinForms.ReportParameter("chietkhau", Data.ChietkhauHD), new Microsoft.Reporting.WinForms.ReportParameter("tongtien", Data.TongtienHD), new Microsoft.Reporting.WinForms.ReportParameter("tongcong", Data.TongcongHD), }; this.reportViewer1.LocalReport.SetParameters(p); this.reportViewer1.RefreshReport(); }
private void btnBugRating_Click(object sender, EventArgs e) { reportViewer1.Hide(); reportViewer3.Hide(); reportViewer4.Hide(); using (Assignment2Entities5 db = new Assignment2Entities5()) { GetBugRating_ResultBindingSource.DataSource = db.GetBugRating(cmbFrom.SelectedItem.ToString(), cmbTo.SelectedItem.ToString(), this.projectIDRP); Microsoft.Reporting.WinForms.ReportParameter[] rPara = new Microsoft.Reporting.WinForms.ReportParameter[] { new Microsoft.Reporting.WinForms.ReportParameter("FromDate", cmbFrom.SelectedItem.ToString()), new Microsoft.Reporting.WinForms.ReportParameter("ToDate", cmbTo.SelectedItem.ToString()), new Microsoft.Reporting.WinForms.ReportParameter("ProjectID", this.projectIDRP) }; reportViewer2.LocalReport.SetParameters(rPara); reportViewer2.RefreshReport(); reportViewer2.Show(); reportViewer2.Dock = DockStyle.None; reportViewer2.BorderStyle = BorderStyle.None; } }
public void GenerateReport() { // this.reportViewer1.LocalReport.ReportEmbeddedResource = "Taxi_AppMain.ReportDesigns." + this.TemplateValue; this.stp_AppUsersResultBindingSource.DataSource = _DataSource; Microsoft.Reporting.WinForms.ReportParameter[] param = new Microsoft.Reporting.WinForms.ReportParameter[3]; string address = AppVars.objSubCompany.Address; string telNo = "Tel No. " + AppVars.objSubCompany.TelephoneNo; string heading = this.ReportHeading; param[0] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_CompanyHeading", AppVars.objSubCompany.CompanyName); param[1] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_Address", AppVars.objSubCompany.Address); param[2] = new Microsoft.Reporting.WinForms.ReportParameter("ReportParameterPeriod", heading); reportViewer1.LocalReport.SetParameters(param); this.reportViewer1.ZoomPercent = 100; this.reportViewer1.ZoomMode = Microsoft.Reporting.WinForms.ZoomMode.Percent; this.reportViewer1.RefreshReport(); IsReportLoaded = true; }
private void frmInBaoCaoDoanhThuBanHang_Load(object sender, EventArgs e) { Microsoft.Reporting.WinForms.ReportParameter[] pra = new Microsoft.Reporting.WinForms.ReportParameter[] { new Microsoft.Reporting.WinForms.ReportParameter("tungay", tungay), new Microsoft.Reporting.WinForms.ReportParameter("denngay", denngay), new Microsoft.Reporting.WinForms.ReportParameter("tongtien", tongtien), new Microsoft.Reporting.WinForms.ReportParameter("tongsl", sl), new Microsoft.Reporting.WinForms.ReportParameter("ngay1", ngay1), new Microsoft.Reporting.WinForms.ReportParameter("thang1", thang1), new Microsoft.Reporting.WinForms.ReportParameter("nam1", nam1), new Microsoft.Reporting.WinForms.ReportParameter("ngay2", ngay2), new Microsoft.Reporting.WinForms.ReportParameter("thang2", thang2), new Microsoft.Reporting.WinForms.ReportParameter("nam2", nam2), }; this.reportViewerBaoCaoDoanhThuBanHang.LocalReport.SetParameters(pra); this.HOADONBANHANGTableAdapter.Fill(this.QuanLiBanHang_DotNetDataSet3.HOADONBANHANG, Convert.ToInt32(ngay1), Convert.ToInt32(ngay2), Convert.ToInt32(thang1), Convert.ToInt32(thang2), Convert.ToInt32(nam1), Convert.ToInt32(nam2) ); this.reportViewerBaoCaoDoanhThuBanHang.RefreshReport(); }
public OrderPaymentPrint(List <OrderReceipt> dataSource, Dictionary <string, string> item_list) { InitializeComponent(); DateTime dateTime = DateTime.UtcNow.Date; reportViewer.LocalReport.DataSources.Clear(); Microsoft.Reporting.WinForms.ReportParameter[] parameters = new Microsoft.Reporting.WinForms.ReportParameter[] { new Microsoft.Reporting.WinForms.ReportParameter("pTotal", item_list["total"]), new Microsoft.Reporting.WinForms.ReportParameter("pDiscount", item_list["discount"]), new Microsoft.Reporting.WinForms.ReportParameter("pOrderNo", item_list["order_id"]), new Microsoft.Reporting.WinForms.ReportParameter("pOrderType", item_list["order_type"]), new Microsoft.Reporting.WinForms.ReportParameter("pBarCode", item_list["barcode_image"]), new Microsoft.Reporting.WinForms.ReportParameter("pPaymentReceived", item_list["payment_received"]), new Microsoft.Reporting.WinForms.ReportParameter("pCashBack", item_list["cash_back"]), new Microsoft.Reporting.WinForms.ReportParameter("pSumQty", item_list["sum_qty"]), new Microsoft.Reporting.WinForms.ReportParameter("pDate", dateTime.ToString("f")) }; reportViewer.LocalReport.DataSources.Add(new Microsoft.Reporting.WinForms.ReportDataSource("ds", OrderPaymentPrint.ToDataTable(dataSource))); this.reportViewer.LocalReport.SetParameters(parameters); this.reportViewer.RefreshReport(); }
private void R_CuentasProveedores_Load(object sender, EventArgs e) { Microsoft.Reporting.WinForms.ReportParameter Personas; if (tagIndicador == 1) { Personas = new Microsoft.Reporting.WinForms.ReportParameter("Personas", "clientes"); CuentasCorrientesBindingSource.DataSource = Cdatos_reportes.CuentasClientes(Alta); } else if (tagIndicador == 2) { Personas = new Microsoft.Reporting.WinForms.ReportParameter("Personas", "proveedores"); CuentasCorrientesBindingSource.DataSource = Cdatos_reportes.CuentasProveedores(Alta); } else { Personas = new Microsoft.Reporting.WinForms.ReportParameter("Personas", "Usuarios"); CuentasCorrientesBindingSource.DataSource = Cdatos_reportes.CuentasUsuarios(Alta); } reportViewer1.LocalReport.SetParameters(Personas); System.Drawing.Printing.PageSettings page = new System.Drawing.Printing.PageSettings(); page.Margins = new System.Drawing.Printing.Margins(50, 50, 50, 50); reportViewer1.SetPageSettings(page); this.reportViewer1.RefreshReport(); }
private void frmContezinoContrato_Load(object sender, EventArgs e) { reportViewer1.LocalReport.DataSources.Clear(); reportViewer1.LocalReport.ReportEmbeddedResource = "ContezaAdmin.RPT.RPT0001.rdlc"; Microsoft.Reporting.WinForms.ReportParameter[] p = new Microsoft.Reporting.WinForms.ReportParameter[8]; p[0] = new Microsoft.Reporting.WinForms.ReportParameter("PrNomeContezino", vNomeCompleto); p[1] = new Microsoft.Reporting.WinForms.ReportParameter("PrCPF", vCPF); p[2] = new Microsoft.Reporting.WinForms.ReportParameter("PrRG", vRG); p[3] = new Microsoft.Reporting.WinForms.ReportParameter("PrOrgaoEmissor", vOrgaoEmissor); p[4] = new Microsoft.Reporting.WinForms.ReportParameter("PrCidade", vCidade); p[5] = new Microsoft.Reporting.WinForms.ReportParameter("PrDia", vDia); p[6] = new Microsoft.Reporting.WinForms.ReportParameter("PrMes", vMes); p[7] = new Microsoft.Reporting.WinForms.ReportParameter("PrAno", vAno); reportViewer1.LocalReport.SetParameters(p); reportViewer1.LocalReport.Refresh(); reportViewer1.RefreshReport(); //this.reportViewer1.RefreshReport(); }
private void frmInHoaDon_Load(object sender, EventArgs e) { InHoaDon_ResultBindingSource.DataSource = HoaDonBUS.InHD(IDHD, IDCH); HoaDon hd = HoaDonBUS.Get1HD(IDHD, IDCH); KhachHang kh = KHBUS.GetKHByMAKH(hd.MaKH); CuaHang ch = CuaHangBUS.GetThongTinCuaHang(hd.MaCuaHang); Microsoft.Reporting.WinForms.ReportParameter[] rParams = new Microsoft.Reporting.WinForms.ReportParameter[] { new Microsoft.Reporting.WinForms.ReportParameter("DateNhap", hd.NgayLapHD.ToShortDateString().ToString()), new Microsoft.Reporting.WinForms.ReportParameter("TongTien", ChiTietHoaDonBUS.TinhTien_ByMaHD(IDHD, IDCH).ToString()), new Microsoft.Reporting.WinForms.ReportParameter("TenCH", ch.TenCuaHang), new Microsoft.Reporting.WinForms.ReportParameter("DiaChi", ch.DiaChi), new Microsoft.Reporting.WinForms.ReportParameter("TenNguoiMua", kh.TenKH), new Microsoft.Reporting.WinForms.ReportParameter("DiaChiNguoiMua", kh.DiaChi), new Microsoft.Reporting.WinForms.ReportParameter("SDT", kh.SDT), new Microsoft.Reporting.WinForms.ReportParameter("HtGiaoHang", hd.HTGiaoHang), new Microsoft.Reporting.WinForms.ReportParameter("MaHD", IDHD) }; reportInHD.LocalReport.SetParameters(rParams); this.reportInHD.RefreshReport(); }
public Relatorio(string Qmin, string Qmax, string Barometro, string SensorTemp, string client, string Endereco, string DataCalibracao , string DataEmissao, string Tipo, string Diametro, string AnoFabricacao, string Instrucao, string Designacao, string Descricao, string Fluido , string TemperaturaAmbiente, string PrecaoBarometrica, string UmidadeRelativa, string MedidorM, string ModeloM, string FabricanteM, string NserieM, string MedidorT, string ModeloT, string FabricanteT, string NserieT, string Operador, string FatorKM , string tx1, string tx2, string tx3, string tx4, string tx5, string tx6, string tx7, string tx8, string tx9, string tx10, string tx11, string tx12, string tx13, string tx14 , string tx15, string tx16, string tx17, string tx18, string tx19, string tx20, string tx21, string tx22, string tx23, string tx24, string tx25, string tx26 , string tx27, string tx28, string tx29, string tx30, string tx31, string tx32, string tx33, string tx34, string tx35, string tx36 /*, string tx37, string tx38 * , string tx39, string tx40*/) { InitializeComponent(); Microsoft.Reporting.WinForms.ReportParameter[] p = new Microsoft.Reporting.WinForms.ReportParameter[64]; p[0] = new Microsoft.Reporting.WinForms.ReportParameter("Qmin", Qmin); p[1] = new Microsoft.Reporting.WinForms.ReportParameter("Qmax", Qmax); p[2] = new Microsoft.Reporting.WinForms.ReportParameter("Barometro", Barometro); p[3] = new Microsoft.Reporting.WinForms.ReportParameter("SensorTemp", SensorTemp); p[4] = new Microsoft.Reporting.WinForms.ReportParameter("client", client); p[5] = new Microsoft.Reporting.WinForms.ReportParameter("Endereco", Endereco); p[6] = new Microsoft.Reporting.WinForms.ReportParameter("DataCalibracao", DataCalibracao); p[7] = new Microsoft.Reporting.WinForms.ReportParameter("DataEmissao", DataEmissao); p[8] = new Microsoft.Reporting.WinForms.ReportParameter("Tipo", Tipo); p[9] = new Microsoft.Reporting.WinForms.ReportParameter("Diametro", Diametro); p[10] = new Microsoft.Reporting.WinForms.ReportParameter("AnoFabricacao", AnoFabricacao); p[11] = new Microsoft.Reporting.WinForms.ReportParameter("Instrucao", Instrucao); p[12] = new Microsoft.Reporting.WinForms.ReportParameter("Designacao", Designacao); p[13] = new Microsoft.Reporting.WinForms.ReportParameter("Descricao", Descricao); p[14] = new Microsoft.Reporting.WinForms.ReportParameter("Fluido", Fluido); p[15] = new Microsoft.Reporting.WinForms.ReportParameter("TemperaturaAmbiente", TemperaturaAmbiente); p[16] = new Microsoft.Reporting.WinForms.ReportParameter("PrecaoBarometrica", PrecaoBarometrica); p[17] = new Microsoft.Reporting.WinForms.ReportParameter("UmidadeRelativa", UmidadeRelativa); p[18] = new Microsoft.Reporting.WinForms.ReportParameter("MedidorM", MedidorM); p[19] = new Microsoft.Reporting.WinForms.ReportParameter("ModeloM", ModeloM); p[20] = new Microsoft.Reporting.WinForms.ReportParameter("FabricanteM", FabricanteM); p[21] = new Microsoft.Reporting.WinForms.ReportParameter("NserieM", NserieM); p[22] = new Microsoft.Reporting.WinForms.ReportParameter("MedidorT", MedidorT); p[23] = new Microsoft.Reporting.WinForms.ReportParameter("ModeloT", ModeloT); p[24] = new Microsoft.Reporting.WinForms.ReportParameter("FabricanteT", FabricanteT); p[25] = new Microsoft.Reporting.WinForms.ReportParameter("NserieT", NserieT); p[26] = new Microsoft.Reporting.WinForms.ReportParameter("Operador", Operador); p[27] = new Microsoft.Reporting.WinForms.ReportParameter("FatorKM", FatorKM); p[28] = new Microsoft.Reporting.WinForms.ReportParameter("tx1", tx1); p[29] = new Microsoft.Reporting.WinForms.ReportParameter("tx2", tx2); p[30] = new Microsoft.Reporting.WinForms.ReportParameter("tx3", tx3); p[31] = new Microsoft.Reporting.WinForms.ReportParameter("tx4", tx4); p[32] = new Microsoft.Reporting.WinForms.ReportParameter("tx5", tx5); p[33] = new Microsoft.Reporting.WinForms.ReportParameter("tx6", tx6); p[34] = new Microsoft.Reporting.WinForms.ReportParameter("tx7", tx7); p[35] = new Microsoft.Reporting.WinForms.ReportParameter("tx8", tx8); p[36] = new Microsoft.Reporting.WinForms.ReportParameter("tx9", tx9); p[37] = new Microsoft.Reporting.WinForms.ReportParameter("tx10", tx10); p[38] = new Microsoft.Reporting.WinForms.ReportParameter("tx11", tx11); p[39] = new Microsoft.Reporting.WinForms.ReportParameter("tx12", tx12); p[40] = new Microsoft.Reporting.WinForms.ReportParameter("tx13", tx13); p[41] = new Microsoft.Reporting.WinForms.ReportParameter("tx14", tx14); p[42] = new Microsoft.Reporting.WinForms.ReportParameter("tx15", tx15); p[43] = new Microsoft.Reporting.WinForms.ReportParameter("tx16", tx16); p[44] = new Microsoft.Reporting.WinForms.ReportParameter("tx17", tx17); p[45] = new Microsoft.Reporting.WinForms.ReportParameter("tx18", tx18); p[46] = new Microsoft.Reporting.WinForms.ReportParameter("tx19", tx19); p[47] = new Microsoft.Reporting.WinForms.ReportParameter("tx20", tx20); p[48] = new Microsoft.Reporting.WinForms.ReportParameter("tx21", tx21); p[49] = new Microsoft.Reporting.WinForms.ReportParameter("tx22", tx22); p[50] = new Microsoft.Reporting.WinForms.ReportParameter("tx23", tx23); p[51] = new Microsoft.Reporting.WinForms.ReportParameter("tx24", tx24); p[52] = new Microsoft.Reporting.WinForms.ReportParameter("tx25", tx25); p[53] = new Microsoft.Reporting.WinForms.ReportParameter("tx26", tx26); p[54] = new Microsoft.Reporting.WinForms.ReportParameter("tx27", tx27); p[55] = new Microsoft.Reporting.WinForms.ReportParameter("tx28", tx28); p[56] = new Microsoft.Reporting.WinForms.ReportParameter("tx29", tx29); p[57] = new Microsoft.Reporting.WinForms.ReportParameter("tx30", tx30); p[58] = new Microsoft.Reporting.WinForms.ReportParameter("tx31", tx31); p[59] = new Microsoft.Reporting.WinForms.ReportParameter("tx32", tx32); p[60] = new Microsoft.Reporting.WinForms.ReportParameter("tx33", tx33); p[61] = new Microsoft.Reporting.WinForms.ReportParameter("tx34", tx34); p[62] = new Microsoft.Reporting.WinForms.ReportParameter("tx35", tx35); p[63] = new Microsoft.Reporting.WinForms.ReportParameter("tx36", tx36);/* * p[63] = new Microsoft.Reporting.WinForms.ReportParameter("tx37", tx37); * p[64] = new Microsoft.Reporting.WinForms.ReportParameter("tx38", tx38); * p[65] = new Microsoft.Reporting.WinForms.ReportParameter("tx39", tx39); * p[66] = new Microsoft.Reporting.WinForms.ReportParameter("tx40", tx40); */ // p[1] = new Microsoft.Reporting.WinForms.ReportParameter("Email", Email); // p[2] = new Microsoft.Reporting.WinForms.ReportParameter("Cpf", Cpf); reportViewer1.LocalReport.SetParameters(p); reportViewer1.LocalReport.Refresh(); reportViewer1.RefreshReport(); }
private void FrmBaoCaoDoanhThu_Load(object sender, EventArgs e) { double TongNhap = 0; double TongXuat = 0; double TongDoanhThu = 0; LayThongTinBaoCao(); DataTable dsmh = new DataTable(); DataTable ds = new DataTable(); dsmh = bus_baocaodoanhthu.LayDanhSachMatHang(dto_baocaodoanhthu); ds = bus_baocaodoanhthu.LayDanhSachMatHang(dto_baocaodoanhthu); ds.Columns.Add("SLBan"); ds.Columns.Add("SLNhap"); ds.Columns.Add("GiaTriBan"); ds.Columns.Add("GiaTriNhap"); ds.Columns.Add("DoanhThu"); ds.Columns.Add("TiLe"); for (int i = 0; i < ds.Rows.Count; i++) { ds.Rows[i]["SLBan"] = bus_baocaodoanhthu.LaySLBan(dto_baocaodoanhthu, ds.Rows[i]["MaMH"].ToString()).Rows[0][1].ToString(); ds.Rows[i]["SLNhap"] = bus_baocaodoanhthu.LaySLNhap(dto_baocaodoanhthu, ds.Rows[i]["MaMH"].ToString()).Rows[0][1].ToString(); double GiaTriBan = bus_baocaodoanhthu.TongGiaTriBan(dto_baocaodoanhthu, ds.Rows[i]["MaMH"].ToString()); ds.Rows[i]["GiaTriBan"] = GiaTriBan; double GiaTriNhap = bus_baocaodoanhthu.TongGiaTriNhap(dto_baocaodoanhthu, ds.Rows[i]["MaMH"].ToString()); ds.Rows[i]["GiaTriNhap"] = GiaTriNhap; double DoanhThu = GiaTriNhap - GiaTriBan; ds.Rows[i]["DoanhThu"] = DoanhThu; TongNhap += GiaTriNhap; TongXuat += GiaTriBan; TongDoanhThu += DoanhThu; } for (int i = 0; i < ds.Rows.Count; i++) { ds.Rows[i]["TiLe"] = (Double.Parse(ds.Rows[i]["DoanhThu"].ToString()) * 100 / TongDoanhThu); } ds.Columns.Remove("MaMH"); reportViewer1.Reset(); reportViewer1.LocalReport.ReportEmbeddedResource = "GUI_QLVLXD.BaoCaoDoanhThu.rdlc"; reportViewer1.LocalReport.DataSources.Clear(); Microsoft.Reporting.WinForms.ReportDataSource newDataSource = new Microsoft.Reporting.WinForms.ReportDataSource("BaocaoDoanhThu",ds); newDataSource.Name = "DataSet1"; reportViewer1.LocalReport.DataSources.Add(newDataSource); List<Microsoft.Reporting.WinForms.ReportParameter> Parameters = new List<Microsoft.Reporting.WinForms.ReportParameter>(); Microsoft.Reporting.WinForms.ReportParameter param = default(Microsoft.Reporting.WinForms.ReportParameter); param = new Microsoft.Reporting.WinForms.ReportParameter("TuNgay", dto_baocaodoanhthu.Thang +"/"+ dto_baocaodoanhthu.Nam); Parameters.Add(param); param = new Microsoft.Reporting.WinForms.ReportParameter("TongNhap", TongNhap+""); Parameters.Add(param); param = new Microsoft.Reporting.WinForms.ReportParameter("TongBan", TongXuat+""); Parameters.Add(param); param = new Microsoft.Reporting.WinForms.ReportParameter("TongDoanhThu", TongDoanhThu+""); Parameters.Add(param); reportViewer1.LocalReport.SetParameters(Parameters); this.reportViewer1.RefreshReport(); }
private void buttonPay_Click(object sender, EventArgs e) { if (Warranties != null) { if (this.ValidateForPrint()) { ConfirmPayment ConfirmPayment = new ConfirmPayment(); var temp = this.Warranties; DialogResult Result = ConfirmPayment.ShowDialog(this, ref temp); this.Warranties = temp; if (Result == DialogResult.OK && ConfirmPayment.IsValid == true) { this.IsBusy = true; this.Warranties.CustomerName = this.textBoxCustomerName.Text; this.Warranties.Email = this.textBoxEmail.Text; this.Warranties.Phone = this.textBoxPhoneNumber.Text; this.Warranties.Country = this.comboBoxCountry.Text; this.Warranties.Address = this.textBoxAddress.Text; bool succesCommit = false; try { this.Warranties.Commit(); succesCommit = true; } catch (Exception ex) { this.Warranties.RollBack(); MessageBox.Show("Error Occurred While Committing Warranty. " + Environment.NewLine + "Please Check the Error Message." + Environment.NewLine + "Please take a screen shot and send to System Administrator" + Environment.NewLine + Environment.NewLine + ex.Message, "Error Occurred."); succesCommit = false; } if (succesCommit) { const string ReportPath = @"LSExtendedWarrenty.WarrentySlip.rdlc"; const string DataSourceName = @"WarrentyItem"; String PrinterName = SettingsProvider.GetDefaultPrinter(); Microsoft.Reporting.WinForms.ReportParameter[] ReportParameter = new Microsoft.Reporting.WinForms.ReportParameter[] { new Microsoft.Reporting.WinForms.ReportParameter(@"PrintDateTime", DateTime.Now.ToString()), new Microsoft.Reporting.WinForms.ReportParameter(@"IssueDateTime", DateTime.Now.ToString()), new Microsoft.Reporting.WinForms.ReportParameter(@"CashMemo", Warranties.Reciept.RecieptID), new Microsoft.Reporting.WinForms.ReportParameter(@"CashMemoDate", Warranties.Reciept.TransactionDate.ToString()), new Microsoft.Reporting.WinForms.ReportParameter(@"CustomerName", Warranties.CustomerName), new Microsoft.Reporting.WinForms.ReportParameter(@"CustomerPhone", Warranties.Phone), new Microsoft.Reporting.WinForms.ReportParameter(@"CustomerEmail", Warranties.Email), new Microsoft.Reporting.WinForms.ReportParameter(@"StaffCode", Warranties.Reciept.Staff), new Microsoft.Reporting.WinForms.ReportParameter(@"StaffName", Warranties.Reciept.StaffName) }; Warranty TempWarrenties = (Warranty)Warranties.Clone(); try { foreach (var warranty in Warranties) { TempWarrenties.Clear(); TempWarrenties.Add(warranty); Microsoft.Reporting.WinForms.ReportDataSource DataSource = new Microsoft.Reporting.WinForms.ReportDataSource (DataSourceName, TempWarrenties); using (ReportPriner Printer = new ReportPriner(ReportPath, DataSource, ReportParameter)) { Printer.Run(PrinterName); Printer.Run(PrinterName); } } this.Warranties = null; this.Reciept = null; } catch (Exception ex) { MessageBox.Show("Problem Printing Warranty Certificate.\nPlease Try again." + Environment.NewLine + "Please Check the Error Message." + Environment.NewLine + "Please take a screen shot and send to System Administrator" + Environment.NewLine + Environment.NewLine + ex.Message , "Cannot Print."); this.Warranties.RollBack(); } } else { MessageBox.Show(this, "Problem saving Warranty.", "Cannot Save.", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { if (ConfirmPayment.IsValid) { MessageBox.Show(this, "Invalid Payment", "Invalid", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } else { MessageBox.Show(this, "Please Enter All the user Fields.", "Complete the form.", MessageBoxButtons.OK, MessageBoxIcon.Information); } this.IsBusy = false; } }
private void GenerateReport() { try { int SubCompanyId = ddSubCompany.SelectedValue.ToInt(); if (chkAllSubCompany.Checked == false && SubCompanyId == 0) { ENUtils.ShowMessage("Required : Sub Company"); return; } if (dtpFromDate.Value != null && dtpFromDate.Value.Value.Year == 1753) { dtpFromDate.Value = null; } if (dtpTillDate.Value != null && dtpTillDate.Value.Value.Year == 1753) { dtpTillDate.Value = null; } DateTime?fromDate = dtpFromDate.Value.ToDateorNull(); DateTime?tillDate = dtpTillDate.Value.ToDateorNull(); if (tillDate != null) { tillDate = tillDate + TimeSpan.Parse("23:59:59"); } bool ShowDetail = chkDetailReport.Checked.ToBool(); using (TaxiDataContext db = new TaxiDataContext()) { var list = db.stp_GetBookingByCallHistory(fromDate, tillDate, SubCompanyId, ShowDetail).ToList();; this.stp_GetBookingByCallHistoryResultBindingSource.DataSource = list; } if (ShowDetail) { this.reportViewer1.LocalReport.ReportEmbeddedResource = "Taxi_AppMain.ReportDesigns.rptCallHistoryBookingDetail.rdlc"; } else { this.reportViewer1.LocalReport.ReportEmbeddedResource = "Taxi_AppMain.ReportDesigns.rptCallHistoryBookingCount.rdlc"; } Microsoft.Reporting.WinForms.ReportParameter[] param = new Microsoft.Reporting.WinForms.ReportParameter[4]; string address = AppVars.objSubCompany.Address; string telNo = "Tel No. " + AppVars.objSubCompany.TelephoneNo; param[0] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_Header", AppVars.objSubCompany.CompanyName.ToStr()); param[1] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_Address", address); param[2] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_Telephone", telNo); ////Report_Parameter_AverageJobsPerDay string heading = string.Empty; if (fromDate != null && tillDate != null) { heading = string.Format("{0:dd/MM/yyyy}", fromDate) + " to " + string.Format("{0:dd/MM/yyyy}", tillDate); } param[3] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_Criteria", heading); reportViewer1.LocalReport.SetParameters(param); this.reportViewer1.ZoomPercent = 100; this.reportViewer1.ZoomMode = Microsoft.Reporting.WinForms.ZoomMode.Percent; this.reportViewer1.RefreshReport(); } catch (Exception ex) { ENUtils.ShowMessage(ex.Message); } }
private void configureParameters() { String filter = this.bindingSource.Filter; if(filter!=null) if(filter.Equals("")) filter=null; if (this.reportViewer1.LocalReport.GetParameters().Count != 0) { Microsoft.Reporting.WinForms.ReportParameter p = new Microsoft.Reporting.WinForms.ReportParameter("filtro", filter); this.reportViewer1.LocalReport.SetParameters(p); find.Visible = true; } else find.Visible = false; this.reportViewer1.RefreshReport(); }
public void CargarReporte(Nullable <DateTime> Desde, Nullable <DateTime> Hasta, Boolean PorEjecutivo, Entities.Entidad Ejecutivo) { try { if (Desde.HasValue) { if (Hasta.HasValue) { System.Data.DataTable DTKPIs = null; if (PorEjecutivo) { if (Ejecutivo != null) { DTKPIs = Client.GetGestionVentasKPIContactados(Entorno.ItemEmpresa.EMPR_Codigo, Entorno.ItemSucursal.SUCR_Codigo, Desde.Value, Hasta.Value, PorEjecutivo, Ejecutivo.ENTC_Codigo); } else { Infrastructure.WinForms.Controls.Dialogos.MostrarMensajeInformacion(Title, "Debe seleccionar un Ejecutivo."); } } else { DTKPIs = Client.GetGestionVentasKPIContactados(Entorno.ItemEmpresa.EMPR_Codigo, Entorno.ItemSucursal.SUCR_Codigo, Desde.Value, Hasta.Value, PorEjecutivo, null); } if (DTKPIs != null && DTKPIs.Rows.Count > 0) { if (!PorEjecutivo) { ReportPath = System.Windows.Forms.Application.StartupPath + @"\Reportes\rptKPI001Contactados.rdlc"; RepDataSource = new Microsoft.Reporting.WinForms.ReportDataSource(); RepDataSource.Name = "DTKPIs"; RepDataSource.Value = DTKPIs; String MIN = DTKPIs.Rows[0]["KPIMIN"].ToString(); String MAX = DTKPIs.Rows[0]["KPIMAX"].ToString(); this.Parameters = new Microsoft.Reporting.WinForms.ReportParameter[2]; Parameters[0] = new Microsoft.Reporting.WinForms.ReportParameter("parMIN", MIN); Parameters[1] = new Microsoft.Reporting.WinForms.ReportParameter("parMAX", MAX); } else { ReportPath = System.Windows.Forms.Application.StartupPath + @"\Reportes\rptKPI001ContactadosEjecutivo.rdlc"; RepDataSource = new Microsoft.Reporting.WinForms.ReportDataSource(); RepDataSource.Name = "DTKPIs"; RepDataSource.Value = DTKPIs; String MIN = DTKPIs.Rows[0]["KPIMIN"].ToString(); String MAX = DTKPIs.Rows[0]["KPIMAX"].ToString(); this.Parameters = new Microsoft.Reporting.WinForms.ReportParameter[3]; Parameters[0] = new Microsoft.Reporting.WinForms.ReportParameter("parMIN", MIN); Parameters[1] = new Microsoft.Reporting.WinForms.ReportParameter("parMAX", MAX); Parameters[2] = new Microsoft.Reporting.WinForms.ReportParameter("parEJECUTIVO", Ejecutivo.ENTC_NomCompleto); } LView.ShowItems(); } else { Infrastructure.WinForms.Controls.Dialogos.MostrarMensajeInformacion(Title, "No se encontraron resultados."); } } else { Infrastructure.WinForms.Controls.Dialogos.MostrarMensajeInformacion(Title, "Debe seleccionar la fecha Hasta."); } } else { Infrastructure.WinForms.Controls.Dialogos.MostrarMensajeInformacion(Title, "Debe seleccionar la fecha Desde."); } } catch (Exception ex) { Infrastructure.WinForms.Controls.Dialogos.MostrarMensajeError(Title, "Ha ocurrido un error cargando el reporte.", ex); } }
public void CargarReporteCotizacion() { try { RView = new COM007RView(); RView.Presenter = this; ((COM007RView)RView).Show(); Item = Client.GetOneCab_Cotizacion_OV(Delfin.Controls.Entorno.ItemEmpresa.EMPR_Codigo, Delfin.Controls.Entorno.ItemSucursal.SUCR_Codigo, ItemLView.CCOT_Numero, ItemLView.CCOT_Tipo); System.Data.DataTable DTCotizacionFlete = new System.Data.DataTable("DTCotizacionFlete"); DTCotizacionFlete.Columns.Add("Desc", Type.GetType("System.String")); DTCotizacionFlete.Columns.Add("Moneda", Type.GetType("System.String")); DTCotizacionFlete.Columns.Add("Precio", Type.GetType("System.Decimal")); foreach (Entities.Det_Cotizacion_OV_Flete _flete in Item.ItemsFlete) { System.Data.DataRow _newRow = DTCotizacionFlete.NewRow(); _newRow["Desc"] = _flete.PACK_Desc; _newRow["Moneda"] = Item.TIPO_DescCMND; _newRow["Precio"] = _flete.DCOT_PrecioUniVenta; DTCotizacionFlete.Rows.Add(_newRow); } System.Data.DataTable DTCotizacionServicio = new System.Data.DataTable("DTCotizacionServicio"); DTCotizacionServicio.Columns.Add("Tipo", Type.GetType("System.String")); DTCotizacionServicio.Columns.Add("Desc", Type.GetType("System.String")); DTCotizacionServicio.Columns.Add("Moneda", Type.GetType("System.String")); DTCotizacionServicio.Columns.Add("Cantidad", Type.GetType("System.Decimal")); DTCotizacionServicio.Columns.Add("Precio", Type.GetType("System.Decimal")); DTCotizacionServicio.Columns.Add("Valor", Type.GetType("System.Decimal")); foreach (Entities.Det_Cotizacion_OV_Servicio _servicio in Item.ItemsServicio) { if (!_servicio.SCOT_Exonerado) { System.Data.DataRow _newRow = DTCotizacionServicio.NewRow(); _newRow["Tipo"] = _servicio.SCOT_Origen; _newRow["Desc"] = _servicio.SERV_Nombre; _newRow["Moneda"] = _servicio.TIPO_DescCMnd; _newRow["Cantidad"] = _servicio.SCOT_Cantidad; _newRow["Precio"] = _servicio.SCOT_PrecioUni; if (_servicio.CCOT_IngresoGasto == "I") { _newRow["Valor"] = _servicio.SCOT_Importe_Ingreso; } else { _newRow["Valor"] = _servicio.SCOT_Importe_Egreso; } DTCotizacionServicio.Rows.Add(_newRow); } } ReportPath = System.Windows.Forms.Application.StartupPath + @"\Reportes\rptCOM007Cotizacion.rdlc"; RepDataSourceFlete = new Microsoft.Reporting.WinForms.ReportDataSource(); RepDataSourceFlete.Name = "DTCotizacionFlete"; RepDataSourceFlete.Value = DTCotizacionFlete; RepDataSourceService = new Microsoft.Reporting.WinForms.ReportDataSource(); RepDataSourceService.Name = "DTCotizacionServicio"; RepDataSourceService.Value = DTCotizacionServicio; this.Parameters = new Microsoft.Reporting.WinForms.ReportParameter[19]; Parameters[0] = new Microsoft.Reporting.WinForms.ReportParameter("CONS_DescVIA", Item.CONS_DescVia); Parameters[1] = new Microsoft.Reporting.WinForms.ReportParameter("CONS_DescRGM", Item.CONS_DescRGM); Parameters[2] = new Microsoft.Reporting.WinForms.ReportParameter("CCOT_NumDoc", Item.CCOT_NumDoc); Parameters[3] = new Microsoft.Reporting.WinForms.ReportParameter("CCOT_Version", Item.CCOT_Version.ToString()); Parameters[4] = new Microsoft.Reporting.WinForms.ReportParameter("ENTC_NomCliente", Item.ENTC_NomCliente); Parameters[5] = new Microsoft.Reporting.WinForms.ReportParameter("ENTC_NomContacto", Item.ENTC_NomContacto); Parameters[6] = new Microsoft.Reporting.WinForms.ReportParameter("CCOT_FecEmi", Item.CCOT_FecEmi.Value.ToString("dd/MM/yyyy")); Parameters[7] = new Microsoft.Reporting.WinForms.ReportParameter("CCOT_FecVcto", Item.CCOT_FecVcto.Value.ToString("dd/MM/yyyy")); Parameters[8] = new Microsoft.Reporting.WinForms.ReportParameter("CCOT_FecOferta", Item.CCOT_FecEmi.Value.AddDays(Item.CCOT_ValidezOferta).ToString("dd/MM/yyyy")); Parameters[9] = new Microsoft.Reporting.WinForms.ReportParameter("ENTC_EmailContacto", Item.ENTC_EmailContacto); Parameters[10] = new Microsoft.Reporting.WinForms.ReportParameter("PUER_NombreOrigen", Item.PUER_NombreOrigen); Parameters[11] = new Microsoft.Reporting.WinForms.ReportParameter("PUER_NombreDestino", Item.PUER_NombreDestino); Parameters[12] = new Microsoft.Reporting.WinForms.ReportParameter("Usuario", Session.UserNombreCompleto); Parameters[13] = new Microsoft.Reporting.WinForms.ReportParameter("ENTC_NomAgente", Item.ENTC_NomAgente); Parameters[14] = new Microsoft.Reporting.WinForms.ReportParameter("ENTC_EmailAgente", Item.ENTC_EmailAgente); Parameters[15] = new Microsoft.Reporting.WinForms.ReportParameter("CCOT_Almacenaje", Item.CCOT_Almacenaje.ToString()); Parameters[16] = new Microsoft.Reporting.WinForms.ReportParameter("CCOT_Sobreestadia", Item.CCOT_SobreEstadia.ToString()); Parameters[17] = new Microsoft.Reporting.WinForms.ReportParameter("CCOT_TiempoViaje", Item.CCOT_TiempoViaje.ToString()); Parameters[18] = new Microsoft.Reporting.WinForms.ReportParameter("CCOT_Observacion", Item.CCOT_Observaciones); RView.ShowItems(); } catch (Exception ex) { Infrastructure.WinForms.Controls.Dialogos.MostrarMensajeError(Title, "Ha ocurrido un error cargando el reporte.", ex); } }
public void CargarReporteOrdenVentaImpo() { try { RView = new COM007RView(); RView.Presenter = this; ((COM007RView)RView).Show(); Item = Client.GetOneCab_Cotizacion_OV(Delfin.Controls.Entorno.ItemEmpresa.EMPR_Codigo, Delfin.Controls.Entorno.ItemSucursal.SUCR_Codigo, ItemLView.CCOT_Numero, ItemLView.CCOT_Tipo); ReportPath = System.Windows.Forms.Application.StartupPath + @"\Reportes\rptCOM007OrdenVentaImpo.rdlc"; //RepDataSourceFlete = new Microsoft.Reporting.WinForms.ReportDataSource(); //RepDataSourceFlete.Name = "DTOrdenVentaImpoFlete"; //RepDataSourceFlete.Value = DTOrdenVentaImpoFlete; String _TypeQuantity = ""; foreach (var _flete in Item.ItemsFlete) { _TypeQuantity += (String.IsNullOrEmpty(_TypeQuantity) ? "" : ", ") + String.Format("{0}X{1}", _flete.DCOT_Cantidad.ToString("#0"), _flete.PACK_DescC); } Decimal _Weight = Item.ItemsFlete.Sum(flet => flet.DCOT_Peso.HasValue ? flet.DCOT_Peso.Value : (Decimal)0.00); Decimal _Volume = Item.ItemsFlete.Sum(flet => flet.DCOT_Volumen.HasValue ? flet.DCOT_Volumen.Value : (Decimal)0.00); Decimal _Pieces = Item.ItemsFlete.Sum(flet => flet.DCOT_Cantidad); this.Parameters = new Microsoft.Reporting.WinForms.ReportParameter[38]; CultureInfo _culture = new CultureInfo("en-US"); Parameters[0] = new Microsoft.Reporting.WinForms.ReportParameter("CCOT_FecEmi", Item.CCOT_FecEmi.Value.ToString("D", _culture)); Parameters[1] = new Microsoft.Reporting.WinForms.ReportParameter("CCOT_NumDoc", String.IsNullOrEmpty(Item.CCOT_NumDoc) ? "" : Item.CCOT_NumDoc); Parameters[2] = new Microsoft.Reporting.WinForms.ReportParameter("ENTC_NomAgente", String.IsNullOrEmpty(Item.ENTC_NomAgente) ? "" : Item.ENTC_NomAgente); Parameters[3] = new Microsoft.Reporting.WinForms.ReportParameter("DOOV_CodReferencia", String.IsNullOrEmpty(Item.DOOV_CodReferencia) ? "" : Item.DOOV_CodReferencia); Parameters[4] = new Microsoft.Reporting.WinForms.ReportParameter("ENTC_NomShipper", String.IsNullOrEmpty(Item.ENTC_NomShipper) ? "" : Item.ENTC_NomShipper); Parameters[5] = new Microsoft.Reporting.WinForms.ReportParameter("ENTC_DirShipper", String.IsNullOrEmpty(Item.ENTC_DirShipper) ? "" : Item.ENTC_DirShipper); Parameters[6] = new Microsoft.Reporting.WinForms.ReportParameter("ENTC_EmailShipper", String.IsNullOrEmpty(Item.ENTC_EmailShipper) ? "" : Item.ENTC_EmailShipper); Parameters[7] = new Microsoft.Reporting.WinForms.ReportParameter("ENTC_Tel1Shipper", String.IsNullOrEmpty(Item.ENTC_Tel1Shipper) ? "" : Item.ENTC_Tel1Shipper); Parameters[8] = new Microsoft.Reporting.WinForms.ReportParameter("ENTC_Tel2Shipper", String.IsNullOrEmpty(Item.ENTC_Tel2Shipper) ? "" : Item.ENTC_Tel2Shipper); Parameters[9] = new Microsoft.Reporting.WinForms.ReportParameter("ENTC_ContactShipper", String.IsNullOrEmpty(Item.ENTC_ContactShipper) ? "" : Item.ENTC_ContactShipper); Parameters[10] = new Microsoft.Reporting.WinForms.ReportParameter("ENTC_NomConsignee", String.IsNullOrEmpty(Item.ENTC_NomConsignee) ? "" : Item.ENTC_NomConsignee); Parameters[11] = new Microsoft.Reporting.WinForms.ReportParameter("ENTC_DirConsignee", String.IsNullOrEmpty(Item.ENTC_DirConsignee) ? "" : Item.ENTC_DirConsignee); Parameters[12] = new Microsoft.Reporting.WinForms.ReportParameter("ENTC_EmailConsignee", String.IsNullOrEmpty(Item.ENTC_EmailConsignee) ? "" : Item.ENTC_EmailConsignee); Parameters[13] = new Microsoft.Reporting.WinForms.ReportParameter("ENTC_Tel1Consignee", String.IsNullOrEmpty(Item.ENTC_Tel1Consignee) ? "" : Item.ENTC_Tel1Consignee); Parameters[14] = new Microsoft.Reporting.WinForms.ReportParameter("ENTC_Tel2Consignee", String.IsNullOrEmpty(Item.ENTC_Tel2Consignee) ? "" : Item.ENTC_Tel2Consignee); Parameters[15] = new Microsoft.Reporting.WinForms.ReportParameter("ENTC_ContactConsignee", String.IsNullOrEmpty(Item.ENTC_ContactConsignee) ? "" : Item.ENTC_ContactConsignee); Parameters[16] = new Microsoft.Reporting.WinForms.ReportParameter("ENTC_NomAgente2", String.IsNullOrEmpty(Item.ENTC_NomAgente) ? "" : Item.ENTC_NomAgente); Parameters[17] = new Microsoft.Reporting.WinForms.ReportParameter("ENTC_DirAgente", String.IsNullOrEmpty(Item.ENTC_DirAgente) ? "" : Item.ENTC_DirAgente); Parameters[18] = new Microsoft.Reporting.WinForms.ReportParameter("ENTC_EmailAgente", String.IsNullOrEmpty(Item.ENTC_EmailAgente) ? "" : Item.ENTC_EmailAgente); Parameters[19] = new Microsoft.Reporting.WinForms.ReportParameter("ENTC_Tel1Agente", String.IsNullOrEmpty(Item.ENTC_Tel1Agente) ? "" : Item.ENTC_Tel1Agente); Parameters[20] = new Microsoft.Reporting.WinForms.ReportParameter("ENTC_Tel2Agente", String.IsNullOrEmpty(Item.ENTC_Tel2Agente) ? "" : Item.ENTC_Tel2Agente); Parameters[21] = new Microsoft.Reporting.WinForms.ReportParameter("ENTC_ContactAgente", String.IsNullOrEmpty(Item.ENTC_ContactAgente) ? "" : Item.ENTC_ContactAgente); Parameters[22] = new Microsoft.Reporting.WinForms.ReportParameter("ENTC_NomTransportista", String.IsNullOrEmpty(Item.ENTC_NomTransportista) ? "" : Item.ENTC_NomTransportista); Parameters[23] = new Microsoft.Reporting.WinForms.ReportParameter("CONT_Numero", String.IsNullOrEmpty(Item.CONT_Numero) ? "" : Item.CONT_Numero); Parameters[24] = new Microsoft.Reporting.WinForms.ReportParameter("TIPO_DescMND", String.IsNullOrEmpty(Item.TIPO_DescCMND) ? "" : Item.TIPO_DescCMND); Parameters[25] = new Microsoft.Reporting.WinForms.ReportParameter("PACK_DescC", String.IsNullOrEmpty(Item.PACK_DescC) ? "" : Item.PACK_DescC); Parameters[26] = new Microsoft.Reporting.WinForms.ReportParameter("DCOT_Cantidad", Item.DCOT_Cantidad.HasValue ? Convert.ToInt32(Item.DCOT_Cantidad.Value).ToString() : ""); Parameters[27] = new Microsoft.Reporting.WinForms.ReportParameter("CCOT_PagoMBL", String.IsNullOrEmpty(Item.CCOT_PagoMBL) ? "" : Item.CCOT_PagoMBL == "C" ? "COLLECT" : "PREPAID"); Parameters[28] = new Microsoft.Reporting.WinForms.ReportParameter("PUER_NombreOrigen", String.IsNullOrEmpty(Item.PUER_NombreOrigen) ? "" : Item.PUER_NombreOrigen); Parameters[29] = new Microsoft.Reporting.WinForms.ReportParameter("PUER_NombreDestino", String.IsNullOrEmpty(Item.PUER_NombreDestino) ? "" : Item.PUER_NombreDestino); Parameters[30] = new Microsoft.Reporting.WinForms.ReportParameter("TIPO_DescCDT", String.IsNullOrEmpty(Item.TIPO_DescCDT) ? "" : Item.TIPO_DescCDT); Parameters[31] = new Microsoft.Reporting.WinForms.ReportParameter("DCOT_Peso", _Weight.ToString("0,0.00") + " TN"); Parameters[32] = new Microsoft.Reporting.WinForms.ReportParameter("DCOT_Volumen", _Volume.ToString("0,0.00") + " M3"); Parameters[33] = new Microsoft.Reporting.WinForms.ReportParameter("DCOT_Bultos", _Pieces.ToString("0,0.00")); Parameters[34] = new Microsoft.Reporting.WinForms.ReportParameter("CCOT_Observaciones", String.IsNullOrEmpty(Item.CCOT_Observaciones) ? "" : Item.CCOT_Observaciones); Parameters[35] = new Microsoft.Reporting.WinForms.ReportParameter("ENTC_NomEjecutivo", String.IsNullOrEmpty(Item.ENTC_NomEjecutivo) ? "" : Item.ENTC_NomEjecutivo); Parameters[36] = new Microsoft.Reporting.WinForms.ReportParameter("ENTC_NomCustomer", String.IsNullOrEmpty(Item.ENTC_NomCustomer) ? "" : Item.ENTC_NomCustomer); Parameters[37] = new Microsoft.Reporting.WinForms.ReportParameter("DOCT_TypeQuantity", _TypeQuantity); RView.ShowItems(); } catch (Exception ex) { Infrastructure.WinForms.Controls.Dialogos.MostrarMensajeError(Title, "Ha ocurrido un error cargando el reporte.", ex); } }
void btnExportExcel_Click(object sender, EventArgs e) { if (grdLister.Rows.Count == 0) { return; } try { saveFileDialog1.Filter = "Excel File (*.xls)|*.xls|AdvExcel File (*.xlsx)|*.xlsx"; saveFileDialog1.Title = "Save File"; saveFileDialog1.FileName = "Driver Collection History"; if (saveFileDialog1.ShowDialog() == DialogResult.OK) { grdLister.Columns["IsPaid"].IsVisible = false; grdLister.Columns["Paid"].IsVisible = true; //grdLister.Columns["btnUpdate"].IsVisible = false; grdLister.Columns[COLS.Active].HeaderText = "Active"; grdLister.Columns[COLS.Active].Width = 30; grdLister.Columns[COLS.Rent].Width = 60; grdLister.Columns[COLS.DriverNo].Width = 35; grdLister.Columns[COLS.PreviousBalance].Width = 85; grdLister.Columns[COLS.Adjustment].Width = 60; grdLister.Columns[COLS.Collection].Width = 50; grdLister.Columns[COLS.OldCollection].Width = 70; grdLister.Columns[COLS.AgentCommission].Width = 60; grdLister.Columns[COLS.OldAgentBalance].Width = 90; grdLister.Columns[COLS.Total].Width = 45; grdLister.Columns[COLS.Paid].Width = 35; var row = grdLister.Rows.OrderByDescending(c => c.Cells["ToDate"].Value.ToDate()).FirstOrDefault(); DateTime?dtCurrent = row.Cells["FromDate"].Value.ToDate(); DateTime dtEnd = row.Cells["ToDate"].Value.ToDate(); Microsoft.Reporting.WinForms.ReportParameter[] param = new Microsoft.Reporting.WinForms.ReportParameter[1]; string heading = string.Empty; heading = "Driver Collection History - " + string.Format("from {0:dd/MM/yyyy}", dtCurrent) + " until " + string.Format("{0:dd/MM/yyyy}", dtEnd); ClsExportGridView obj = new ClsExportGridView(grdLister, saveFileDialog1.FileName); obj.ApplyCellFormatting = true; obj.ConditionalFormattingObject = new StyleDataRowConditionalFormattingObject(); obj.ConditionalFormattingObject.ConditionFormattingColumnName = "Paid"; obj.ConditionalFormattingObject.RowBackColor = Color.LightGreen; obj.ConditionalFormattingObject.RowForeColor = Color.Black; obj.ConditionalFormattingObject.TValue = "Paid"; obj.Heading = heading; if (obj.ExportExcel()) { RadDesktopAlert alert = new RadDesktopAlert(); alert.CaptionText = "Export"; alert.ContentText = "<html> <b><span style=font-size:medium><color=Blue>Export Successfully</span></b></html>"; alert.Show(); } //grdLister.Columns["IsPaid"].IsVisible = true; //grdLister.Columns["Paid"].IsVisible = false; grdLister.Columns["IsPaid"].IsVisible = false; grdLister.Columns["Paid"].IsVisible = true; } } catch (Exception ex) { ENUtils.ShowMessage(ex.Message); } finally { SetDefaultColumnSettings(); } //rptfrmDriverPaymentCollection frm = new rptfrmDriverPaymentCollection(); //frm.LoadReport(); //frm.ExportReportToExcel("excel"); }
void loadParam() { string text = ""; Sales_BM sale = new Sales_BM(); sale.sales_id = sales_id; sale = sale.getSalesByID(connString2); if (sale.credit > 0) { text = "Credit"; } else { text = "Balance"; } Microsoft.Reporting.WinForms.ReportParameter[] param = new Microsoft.Reporting.WinForms.ReportParameter[] { new Microsoft.Reporting.WinForms.ReportParameter("ReportParamSales", sales_id.ToString()), new Microsoft.Reporting.WinForms.ReportParameter("paramCustName", name.ToString()), new Microsoft.Reporting.WinForms.ReportParameter("paramAddress", addrs.ToString()), new Microsoft.Reporting.WinForms.ReportParameter("paramTotal", sale.total.ToString()), new Microsoft.Reporting.WinForms.ReportParameter("paramPayment", sale.paid.ToString()), new Microsoft.Reporting.WinForms.ReportParameter("ReportParamBalance", sale.credit.ToString()), new Microsoft.Reporting.WinForms.ReportParameter("paramBC", text), new Microsoft.Reporting.WinForms.ReportParameter("paramDate", sale.date_time.ToString("dd-MMM-yyyy")) }; reportViewer1.LocalReport.SetParameters(param); BusinessObjects.Print print = new Print(); // string connString2 = @"Data Source=SURESH\SQLEXPRESS;Initial Catalog=FutureSoft;Integrated Security=True"; print = print.GetP(connString2); PrintDialog printDialog = new PrintDialog(); PrintDocument printDocument = new PrintDocument(); printDialog.Document = printDocument; //printDocument.PrintPage +=new PrintPageEventHandler(printDocument_PrintPage); printDocument.PrinterSettings.PrinterName = print.PrinterName; printDocument.DefaultPageSettings.PaperSize = printDocument.PrinterSettings.PaperSizes[print.PaperSize]; printDocument.DefaultPageSettings.PaperSource = printDocument.PrinterSettings.PaperSources[print.Source]; printDocument.DefaultPageSettings.PrinterResolution = printDocument.PrinterSettings.PrinterResolutions[print.Resolution]; printDocument.DefaultPageSettings.Margins.Left = 4; printDocument.DefaultPageSettings.Margins.Right = 4; printDocument.DefaultPageSettings.Margins.Top = 5; printDocument.DefaultPageSettings.Margins.Bottom = 8; printDocument.DocumentName = "Vista_Receipt"; printDocument.DefaultPageSettings.PrinterSettings.MaximumPage = 1; printDocument.DefaultPageSettings.PrinterSettings.Duplex = Duplex.Vertical; reportViewer1.SetPageSettings(printDocument.DefaultPageSettings); // printDocument.PrintPage += printDocument_PrintPage2; //printDocument.Print(); }
private void Form9_Load(object sender, EventArgs e) { try { string serv = "localhost", database = "namefield", uid = "root", pasw = "121417181"; string constring; constring = "SERVER=" + serv + ";" + "DATABASE=" + database + ";" + "UID=" + uid + ";" + "PASSWORD="******";"; MySqlConnection connection = new MySqlConnection(constring); connection.Open(); string query = "select usrid from vehdet where vhno='" + vhno + "';"; MySqlCommand cmd = new MySqlCommand(query, connection); //Execute a SQL command to read ,which uses class "MySqlDataReader" as a command for ExecuteReader using cmd MySqlDataReader read = cmd.ExecuteReader(); if (!read.HasRows) { MessageBox.Show("vehicle not found"); } else { while (read.Read()) {//while the data doesnt become empty usid = read.GetInt32("usrid"); } read.Close(); cmd.CommandText = "select count(usrid) as cnt from bill where usrid=" + usid + ";"; read = cmd.ExecuteReader(); while (read.Read())//while the data doesnt become empty { if (read.GetInt32("cnt") == 1) { fbil = 0; } else { fbil = 1; } } read.Close(); cmd.CommandText = "select * from owndet,fines,bill where owndet.usrid=" + usid + " order by billno desc limit 1;"; read = cmd.ExecuteReader(); if (!read.HasRows) { MessageBox.Show("details not found"); } while (read.Read()) //while the data doesnt become empty { //Bill date,no,name etc inga label la setting pandrom name = read.GetString("name"); billno = read.GetInt32("billno").ToString(); date = read.GetDateTime("date").ToString(); total = read.GetInt32("total").ToString(); paid = read.GetInt32("paid").ToString(); balance = (read.GetInt32("total") - read.GetInt32("paid")).ToString(); Microsoft.Reporting.WinForms.ReportParameter[] para = new Microsoft.Reporting.WinForms.ReportParameter[] { new Microsoft.Reporting.WinForms.ReportParameter("Name", name), new Microsoft.Reporting.WinForms.ReportParameter("Date", date), new Microsoft.Reporting.WinForms.ReportParameter("Billno", billno), new Microsoft.Reporting.WinForms.ReportParameter("vehino", vhno), new Microsoft.Reporting.WinForms.ReportParameter("Total", total), new Microsoft.Reporting.WinForms.ReportParameter("Paid", paid), new Microsoft.Reporting.WinForms.ReportParameter("Balance", balance), }; reportViewer1.LocalReport.SetParameters(para); if (fbil == 1) { if ((read.GetInt32("total") - read.GetInt32("paid")) != 0) { list.Add(new Fine() { Slno = slno, Offense = "Arrears", TotalAmt = (read.GetInt32("total") - read.GetInt32("paid")).ToString() }); slno++; } } else { if (read.GetInt32("ot") > 0)//Overtake paniruntha,ithu run aagum { list.Add(new Fine() { Slno = slno, Offense = "OverTake", Times = read.GetInt32("ot"), FineAmt = 300, TotalAmt = (read.GetInt32("ot") * 300).ToString() }); slno++; } if (read.GetInt32("dd") > 0)//Drink and drive paniruntha { list.Add(new Fine() { Slno = slno, Offense = "Drink and Drive", Times = read.GetInt32("dd"), FineAmt = 500, TotalAmt = (read.GetInt32("dd") * 500).ToString() }); slno++; } if (read.GetInt32("ht") > 0) { list.Add(new Fine() { Slno = slno, Offense = "Helmet", Times = read.GetInt32("ht"), FineAmt = 100, TotalAmt = (read.GetInt32("ht") * 100).ToString() }); slno++; } if (read.GetInt32("ow") > 0) { list.Add(new Fine() { Slno = slno, Offense = "One Way", Times = read.GetInt32("ow"), FineAmt = 200, TotalAmt = (read.GetInt32("ow") * 200).ToString() }); slno++; } } } } FineBindingSource.DataSource = list; this.reportViewer1.RefreshReport(); } catch (MySqlException ex) { MessageBox.Show("The error occured is" + ex); this.Close(); } }
private void SwitchIndex() { switch (index) { case 1: this.reportViewer1.LocalReport.ReportPath = "C:\\Users\\Hadenos_EZ\\source\\repos\\ProjetHameau\\ProjetHameau\\Vue\\LISTE_EMARGEMENT1.rdlc"; Microsoft.Reporting.WinForms.ReportParameter[] p1 = new Microsoft.Reporting.WinForms.ReportParameter[] { new Microsoft.Reporting.WinForms.ReportParameter("Nom0", LP[0].NOM_PRO), new Microsoft.Reporting.WinForms.ReportParameter("Nom1", LP[1].NOM_PRO), new Microsoft.Reporting.WinForms.ReportParameter("Nom2", LP[2].NOM_PRO), new Microsoft.Reporting.WinForms.ReportParameter("Nom3", LP[3].NOM_PRO), new Microsoft.Reporting.WinForms.ReportParameter("Nom4", LP[4].NOM_PRO), new Microsoft.Reporting.WinForms.ReportParameter("Nom5", LP[5].NOM_PRO), new Microsoft.Reporting.WinForms.ReportParameter("Nom6", LP[6].NOM_PRO), new Microsoft.Reporting.WinForms.ReportParameter("Nom7", LP[7].NOM_PRO), new Microsoft.Reporting.WinForms.ReportParameter("Nom8", LP[8].NOM_PRO), new Microsoft.Reporting.WinForms.ReportParameter("Nom9", LP[9].NOM_PRO), new Microsoft.Reporting.WinForms.ReportParameter("Nom10", LP[10].NOM_PRO), new Microsoft.Reporting.WinForms.ReportParameter("Nom11", LP[11].NOM_PRO), new Microsoft.Reporting.WinForms.ReportParameter("Nom12", LP[12].NOM_PRO), new Microsoft.Reporting.WinForms.ReportParameter("Nom13", LP[13].NOM_PRO), new Microsoft.Reporting.WinForms.ReportParameter("Nom14", LP[14].NOM_PRO), new Microsoft.Reporting.WinForms.ReportParameter("Nom15", LP[15].NOM_PRO), new Microsoft.Reporting.WinForms.ReportParameter("Nom16", LP[16].NOM_PRO), new Microsoft.Reporting.WinForms.ReportParameter("Nom17", LP[17].NOM_PRO), new Microsoft.Reporting.WinForms.ReportParameter("Nom18", LP[18].NOM_PRO), new Microsoft.Reporting.WinForms.ReportParameter("Nom19", LP[19].NOM_PRO), new Microsoft.Reporting.WinForms.ReportParameter("Nom20", LP[20].NOM_PRO), new Microsoft.Reporting.WinForms.ReportParameter("Nom21", LP[21].NOM_PRO), new Microsoft.Reporting.WinForms.ReportParameter("Nom22", LP[22].NOM_PRO), new Microsoft.Reporting.WinForms.ReportParameter("Nom23", LP[23].NOM_PRO), new Microsoft.Reporting.WinForms.ReportParameter("Nom24", LP[24].NOM_PRO), new Microsoft.Reporting.WinForms.ReportParameter("Nom25", LP[25].NOM_PRO), new Microsoft.Reporting.WinForms.ReportParameter("Nom26", LP[26].NOM_PRO), new Microsoft.Reporting.WinForms.ReportParameter("Nom27", LP[27].NOM_PRO), }; this.reportViewer1.LocalReport.SetParameters(p1); this.reportViewer1.RefreshReport(); break; case 2: this.reportViewer1.LocalReport.ReportPath = "C:\\Users\\Hadenos_EZ\\source\\repos\\ProjetHameau\\ProjetHameau\\Vue\\LISTE_EMARGEMENT2.rdlc"; Microsoft.Reporting.WinForms.ReportParameter[] p2 = new Microsoft.Reporting.WinForms.ReportParameter[] { new Microsoft.Reporting.WinForms.ReportParameter("Nom28", LP[28].NOM_PRO), new Microsoft.Reporting.WinForms.ReportParameter("Nom29", LP[29].NOM_PRO), new Microsoft.Reporting.WinForms.ReportParameter("Nom30", LP[30].NOM_PRO), new Microsoft.Reporting.WinForms.ReportParameter("Nom31", LP[31].NOM_PRO), new Microsoft.Reporting.WinForms.ReportParameter("Nom32", LP[32].NOM_PRO), new Microsoft.Reporting.WinForms.ReportParameter("Nom33", LP[33].NOM_PRO), new Microsoft.Reporting.WinForms.ReportParameter("Nom34", LP[34].NOM_PRO), new Microsoft.Reporting.WinForms.ReportParameter("Nom35", LP[35].NOM_PRO), new Microsoft.Reporting.WinForms.ReportParameter("Nom36", LP[36].NOM_PRO), new Microsoft.Reporting.WinForms.ReportParameter("Nom37", LP[37].NOM_PRO), new Microsoft.Reporting.WinForms.ReportParameter("Nom38", LP[38].NOM_PRO), new Microsoft.Reporting.WinForms.ReportParameter("Nom39", LP[39].NOM_PRO), new Microsoft.Reporting.WinForms.ReportParameter("Nom40", LP[40].NOM_PRO), new Microsoft.Reporting.WinForms.ReportParameter("Nom41", LP[41].NOM_PRO), new Microsoft.Reporting.WinForms.ReportParameter("Nom42", LP[42].NOM_PRO), new Microsoft.Reporting.WinForms.ReportParameter("Nom43", LP[43].NOM_PRO), new Microsoft.Reporting.WinForms.ReportParameter("Nom44", LP[44].NOM_PRO), new Microsoft.Reporting.WinForms.ReportParameter("Nom45", LP[45].NOM_PRO), new Microsoft.Reporting.WinForms.ReportParameter("Nom46", LP[46].NOM_PRO), new Microsoft.Reporting.WinForms.ReportParameter("Nom47", LP[47].NOM_PRO), new Microsoft.Reporting.WinForms.ReportParameter("Nom48", LP[48].NOM_PRO), new Microsoft.Reporting.WinForms.ReportParameter("Nom49", LP[49].NOM_PRO), new Microsoft.Reporting.WinForms.ReportParameter("Nom50", LP[50].NOM_PRO), new Microsoft.Reporting.WinForms.ReportParameter("Nom51", LP[51].NOM_PRO), new Microsoft.Reporting.WinForms.ReportParameter("Nom52", LP[52].NOM_PRO), new Microsoft.Reporting.WinForms.ReportParameter("Nom53", LP[53].NOM_PRO), new Microsoft.Reporting.WinForms.ReportParameter("Nom54", LP[54].NOM_PRO), new Microsoft.Reporting.WinForms.ReportParameter("Nom55", LP[55].NOM_PRO), }; this.reportViewer1.LocalReport.SetParameters(p2); this.reportViewer1.RefreshReport(); break; case 3: this.reportViewer1.LocalReport.ReportPath = "C:\\Users\\Hadenos_EZ\\source\\repos\\ProjetHameau\\ProjetHameau\\Vue\\LISTE_EMARGEMENT3.rdlc"; Microsoft.Reporting.WinForms.ReportParameter[] p3 = new Microsoft.Reporting.WinForms.ReportParameter[] { new Microsoft.Reporting.WinForms.ReportParameter("Nom56", LP[56].NOM_PRO), new Microsoft.Reporting.WinForms.ReportParameter("Nom57", LP[57].NOM_PRO), new Microsoft.Reporting.WinForms.ReportParameter("Nom58", LP[58].NOM_PRO), new Microsoft.Reporting.WinForms.ReportParameter("Nom59", LP[59].NOM_PRO), new Microsoft.Reporting.WinForms.ReportParameter("Nom60", LP[60].NOM_PRO), new Microsoft.Reporting.WinForms.ReportParameter("Nom61", LP[61].NOM_PRO), new Microsoft.Reporting.WinForms.ReportParameter("Nom62", LP[62].NOM_PRO), new Microsoft.Reporting.WinForms.ReportParameter("Nom63", LP[63].NOM_PRO), new Microsoft.Reporting.WinForms.ReportParameter("Nom64", LP[64].NOM_PRO), new Microsoft.Reporting.WinForms.ReportParameter("Nom65", LP[65].NOM_PRO), new Microsoft.Reporting.WinForms.ReportParameter("Nom66", LP[66].NOM_PRO), new Microsoft.Reporting.WinForms.ReportParameter("Nom67", LP[67].NOM_PRO), new Microsoft.Reporting.WinForms.ReportParameter("Nom68", LP[68].NOM_PRO), new Microsoft.Reporting.WinForms.ReportParameter("Nom69", LP[69].NOM_PRO), new Microsoft.Reporting.WinForms.ReportParameter("Nom70", LP[70].NOM_PRO), new Microsoft.Reporting.WinForms.ReportParameter("Nom71", LP[71].NOM_PRO), new Microsoft.Reporting.WinForms.ReportParameter("Nom72", LP[72].NOM_PRO), new Microsoft.Reporting.WinForms.ReportParameter("Nom73", LP[73].NOM_PRO), new Microsoft.Reporting.WinForms.ReportParameter("Nom74", LP[74].NOM_PRO), new Microsoft.Reporting.WinForms.ReportParameter("Nom75", LP[75].NOM_PRO), new Microsoft.Reporting.WinForms.ReportParameter("Nom76", LP[76].NOM_PRO), new Microsoft.Reporting.WinForms.ReportParameter("Nom77", LP[77].NOM_PRO), new Microsoft.Reporting.WinForms.ReportParameter("Nom78", LP[78].NOM_PRO), new Microsoft.Reporting.WinForms.ReportParameter("Nom79", LP[79].NOM_PRO), new Microsoft.Reporting.WinForms.ReportParameter("Nom80", LP[80].NOM_PRO), new Microsoft.Reporting.WinForms.ReportParameter("Nom81", LP[81].NOM_PRO), new Microsoft.Reporting.WinForms.ReportParameter("Nom82", LP[82].NOM_PRO), new Microsoft.Reporting.WinForms.ReportParameter("Nom83", LP[83].NOM_PRO), }; this.reportViewer1.LocalReport.SetParameters(p3); this.reportViewer1.RefreshReport(); break; } }
private void GenerateReportLoad() { try { var today = DateTime.Today; var month = new DateTime(today.Year, today.Month, 1); var first = month.AddMonths(-2); var last = month.AddDays(-2); if (dtpFromDate.Value != null && dtpFromDate.Value.Value.Year == 1753) { dtpFromDate.Value = null; } if (dtpTillDate.Value != null && dtpTillDate.Value.Value.Year == 1753) { dtpTillDate.Value = null; } DateTime?fromDate = dtpFromDate.Value.ToDateorNull(); DateTime?tillDate = dtpTillDate.Value.ToDateorNull(); var list = General.GetQueryable <Fleet_Driver>(c => c.Id == DriverId).ToList(); string Driver = list.FirstOrDefault().DriverNo + " - " + list.FirstOrDefault().DriverName; using (TaxiDataContext db = new TaxiDataContext()) { this.stp_DriverRatingResultBindingSource.DataSource = db.stp_DriverRating(first.ToDateTime(), DateTime.Today, DriverId).ToList().OrderByDescending(c => c.UpdatedOn); } Microsoft.Reporting.WinForms.ReportParameter[] param = new Microsoft.Reporting.WinForms.ReportParameter[5]; string address = AppVars.objSubCompany.Address; string telNo = "Tel No. " + AppVars.objSubCompany.TelephoneNo; param[0] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_Header", AppVars.objSubCompany.CompanyName.ToStr()); param[1] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_Address", address); param[2] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_Telephone", telNo); string heading = string.Empty; if (fromDate != null && tillDate != null) { heading = string.Format("{0:dd/MM/yyyy}", fromDate) + " to " + string.Format("{0:dd/MM/yyyy}", tillDate); } param[3] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_Criteria", heading); param[4] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_Driver", Driver); reportViewer1.LocalReport.SetParameters(param); this.reportViewer1.ZoomPercent = 100; this.reportViewer1.ZoomMode = Microsoft.Reporting.WinForms.ZoomMode.Percent; this.reportViewer1.RefreshReport(); } catch (Exception ex) { } }
private void GenerateReport() { try { bool isMissed = optMissedCalls.Checked; if (dtpFromDate.Value != null && dtpFromDate.Value.Value.Year == 1753) { dtpFromDate.Value = null; } if (dtpTillDate.Value != null && dtpTillDate.Value.Value.Year == 1753) { dtpTillDate.Value = null; } DateTime?fromDate = dtpFromDate.Value.ToDateorNull(); DateTime?tillDate = dtpTillDate.Value.ToDateorNull(); string phone = txtPhone.Text.Trim(); string name = txtName.Text.Trim().ToLower(); string Line = txtLine.Text.ToStr(); string Stn = txtStn.Text.ToStr(); var list = (from a in GeneralBLL.GetQueryable <CallHistory>(null) where (fromDate == null || a.CallDateTime.Value.Date >= fromDate) && (tillDate == null || a.CallDateTime.Value.Date <= tillDate) && (name == string.Empty || a.Name.Trim().ToLower().StartsWith(name)) && (phone == string.Empty || a.PhoneNumber.Trim() == phone) && (Line == string.Empty || a.Line == Line) && (Stn == string.Empty || a.STN == Stn) && (isMissed == false || (a.IsAccepted != null && a.IsAccepted == true)) orderby a.CallDateTime descending select new { Name = a.Name, PhoneNumber = a.PhoneNumber, CallDateTime = a.CallDateTime, Line = a.Line, STN = a.STN }).ToList(); CallHistoryBindingSource.DataSource = list; Microsoft.Reporting.WinForms.ReportParameter[] param = new Microsoft.Reporting.WinForms.ReportParameter[6]; string address = AppVars.objSubCompany.Address; string telNo = "Tel No. " + AppVars.objSubCompany.TelephoneNo; param[0] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_Header", AppVars.objSubCompany.CompanyName.ToStr()); param[1] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_Address", address); param[2] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_Telephone", telNo); string heading = string.Empty; if (fromDate != null && tillDate != null) { heading = string.Format("{0:dd/MM/yyyy}", fromDate) + " to " + string.Format("{0:dd/MM/yyyy}", tillDate); } param[3] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_Criteria", heading); param[4] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_TotalCalls", list.Count.ToStr()); CallerIdType_Configuration obj = General.GetObject <CallerIdType_Configuration>(c => c.Id != null); string DigitalCLIType = obj.DigitalCLIType.ToStr(); param[5] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_DigitalCLIType", DigitalCLIType == "" ? "0" : DigitalCLIType); reportViewer1.LocalReport.SetParameters(param); this.reportViewer1.ZoomPercent = 100; this.reportViewer1.ZoomMode = Microsoft.Reporting.WinForms.ZoomMode.Percent; this.reportViewer1.RefreshReport(); } catch (Exception ex) { ENUtils.ShowMessage(ex.Message); } }
public void LoadReport() { try { this.reportViewer1.LocalReport.EnableExternalImages = true; TimeSpan tillTime = TimeSpan.Zero; TimeSpan.TryParse("23:59:59", out tillTime); DateTime?dtFromDate = dtpFromDate.Value.ToDate(); DateTime?dtTillDate = dtpTillDate.Value.ToDate() + tillTime; if (dtFromDate > dtTillDate) { ENUtils.ShowMessage("From Date can't greater then Till Date"); return; } this.stp_OperatorPerformanceResultBindingSource.DataSource = GetData(dtFromDate, dtTillDate).ToList(); //select new stp_OperatorPerformanceResult //{ // Id = a.Id, // CLICalls = a.CLICalls, // CLICleared = a.CLICleared, // JobsBooked = a.JobsBooked, // JobsCancelled = a.JobsCancelled, // JobsCompletetd = a.JobsCompletetd, // LateDespatch = a.LateDespatch, // LoggedIn = a.LoggedIn, // MailSent = a.MailSent, // UserName = a.UserName //}).ToList(); Microsoft.Reporting.WinForms.ReportParameter[] param = new Microsoft.Reporting.WinForms.ReportParameter[2]; // string address = AppVars.objSubCompany.Address; // string telNo = "Tel No. " + AppVars.objSubCompany.TelephoneNo; string heading = string.Empty; //if (dtFrom != null && dtTill != null) //{ heading = "Operator Performance for period " + string.Format("{0:dd/MM/yy}", dtpFromDate.Value) + " to " + string.Format("{0:dd/MM/yy}", dtpTillDate.Value); // } string PrintedOn = string.Empty; PrintedOn = "Printed on " + string.Format("{0:dd/MM/yy}", DateTime.Now) + " at " + string.Format("{0:HH:mm}", DateTime.Now); //Printed on 22/04/2016 at 16:40 param[0] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_Period", heading); param[1] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_PrintedOn", PrintedOn); //List<ClsLogo> objLogo = new List<ClsLogo>(); //objLogo.Add(new ClsLogo { ImageInBytes = AppVars.objSubCompany.CompanyLogo != null ? AppVars.objSubCompany.CompanyLogo.ToArray() : null }); //ReportDataSource imageDataSource = new ReportDataSource("Taxi_AppMain_Classes_ClsLogo", objLogo); //this.reportViewer1.LocalReport.DataSources.Add(imageDataSource); reportViewer1.LocalReport.SetParameters(param); this.reportViewer1.ZoomPercent = 100; this.reportViewer1.ZoomMode = Microsoft.Reporting.WinForms.ZoomMode.Percent; this.reportViewer1.RefreshReport(); IsReportLoaded = true; } catch (Exception ex) { ENUtils.ShowMessage(ex.Message); } }
private void buttonPrint_Click(object sender, EventArgs e) { int Selection = this.dataGridViewJournel.CurrentCell.RowIndex; Warranties = DataProvider.GetWarrenties(0, 10, null, this.dataGridViewJournel.CurrentRow.Cells["WarrentyNumber"].Value.ToString(), null, null, null); Warranty TempWarrenties = (Warranty)Warranties.Clone(); var errorMessage = this.dataGridViewJournel.CurrentRow.Cells["ErrorMessage"].Value.ToString(); if (errorMessage.Length > 0) { DialogResult result = MessageBox.Show(this, "Warranty Slip Has Errors." + Environment.NewLine + errorMessage + Environment.NewLine + "Still Need the Warranty Slip.", "Cannot Generate", MessageBoxButtons.YesNoCancel); if (result == DialogResult.Yes) { result = new Authorize().ShowDialog(this); } if (result != DialogResult.Yes) { return; } } #region PrintExtended TempWarrenties.Clear(); TempWarrenties.Add(Warranties[0]); TempWarrenties.Reciept = Warranties[0].Reciept; const string ReportPath = @"LSExtendedWarrenty.WarrentySlip.rdlc"; const string DataSourceName = @"WarrentyItem"; String PrinterName = SettingsProvider.GetDefaultPrinter(); try { Microsoft.Reporting.WinForms.ReportParameter[] ReportParameter = new Microsoft.Reporting.WinForms.ReportParameter[] { new Microsoft.Reporting.WinForms.ReportParameter(@"PrintDateTime", DateTime.Now.ToString()), new Microsoft.Reporting.WinForms.ReportParameter(@"IssueDateTime", TempWarrenties[0].IssuedDate.ToString()), new Microsoft.Reporting.WinForms.ReportParameter(@"CashMemo", TempWarrenties[0].Reciept.RecieptID), new Microsoft.Reporting.WinForms.ReportParameter(@"CashMemoDate", TempWarrenties[0].Reciept.TransactionDate.ToString()), new Microsoft.Reporting.WinForms.ReportParameter(@"CustomerName", TempWarrenties[0].CustomerName), new Microsoft.Reporting.WinForms.ReportParameter(@"CustomerPhone", TempWarrenties[0].Phone), new Microsoft.Reporting.WinForms.ReportParameter(@"CustomerEmail", TempWarrenties[0].Email), new Microsoft.Reporting.WinForms.ReportParameter(@"StaffCode", TempWarrenties[0].Reciept.Staff), new Microsoft.Reporting.WinForms.ReportParameter(@"StaffName", TempWarrenties[0].Reciept.StaffName) }; Microsoft.Reporting.WinForms.ReportDataSource DataSource = new Microsoft.Reporting.WinForms.ReportDataSource (DataSourceName, TempWarrenties); using (ReportPriner Printer = new ReportPriner(ReportPath, DataSource, ReportParameter)) { this.Hide(); this.Cursor = Cursors.WaitCursor; FormReciept window = new FormReciept(); window.Report = Printer.LocalReport; window.ReportParameter = ReportParameter; window.DataSource = DataSource; this.Cursor = Cursors.Default; window.ShowDialog(this); this.Close(); } } catch (Exception ex) { MessageBox.Show(this, "Error Processing the Warranty Slip. " + Environment.NewLine + "Please Check the Error Message." + Environment.NewLine + "Please take a screen shot and send to System Administrator" + Environment.NewLine + Environment.NewLine + ex.Message, "Error Occurred"); } #endregion }
private void InitReportByUrl(string strRpUrl) { if (strRpUrl == string.Empty) { return; } int intS = strRpUrl.IndexOf("?/") + 2; int intE = strRpUrl.IndexOf("&"); if (intS == 1) { intS = strRpUrl.ToUpper().IndexOf("ReportServer".ToUpper()) + 12; } if (intS == 11) { intS = 0; } if (intE == -1) { intE = strRpUrl.Length; } string strRpPath = strRpUrl.Substring(intS, intE - intS); _strReportPath = strRpPath.StartsWith("/") ? strRpPath : "/" + strRpPath; reportViewer1.ProcessingMode = Microsoft.Reporting.WinForms.ProcessingMode.Remote; this.reportViewer1.ServerReport.DisplayName = _strWinTitle; this.reportViewer1.ServerReport.ReportServerUrl = new Uri(this.frmReportServicesPath); // (System.Configuration.ConfigurationManager.AppSettings["ReportServices"]);//"http://172.20.28.17/ReportServer" this.reportViewer1.ServerReport.ReportPath = _strReportPath; // "/fdcf/fVslApTruckChargeSheet"; //string strUser = ConfigurationManager.AppSettings["MyReportViewerUser"]; //string strPsw = ConfigurationManager.AppSettings["MyReportViewerPassword"]; //string domain = ConfigurationManager.AppSettings["MyReportViewerDomain"]; //reportViewer1.ServerReport.ReportServerCredentials.SetFormsCredentials(null, strUser, strPsw, domain); Microsoft.Reporting.WinForms.ReportParameterInfoCollection RParameter = this.reportViewer1.ServerReport.GetParameters(); for (int r = 0; r < RParameter.Count; r++) { try { if (RParameter[r].Name == "strUser") { this.AddRpParameterItem(RParameter[r].Name, CApplication.App.CurrentSession.UserId.ToString()); } else if (RParameter[r].Name == "strDept") { this.AddRpParameterItem(RParameter[r].Name, CApplication.App.CurrentSession.DeptId.ToString()); } else if (RParameter[r].Name == "strFy") { this.AddRpParameterItem(RParameter[r].Name, CApplication.App.CurrentSession.FyId.ToString()); } else { string PRtemValue = StaticFunctions.GetFrmParamValue(strRpUrl, RParameter[r].Name, new char[] { '&' }); if (PRtemValue != string.Empty) { this.AddRpParameterItem(RParameter[r].Name, PRtemValue); } } } catch { } } if (dtRpara != null && dtRpara.Rows.Count > 0) { RParameters = new Microsoft.Reporting.WinForms.ReportParameter[dtRpara.Rows.Count]; for (int i = 0; i < dtRpara.Rows.Count; i++) { RParameters[i] = new Microsoft.Reporting.WinForms.ReportParameter(); Microsoft.Reporting.WinForms.ReportParameter RParameterItem = new Microsoft.Reporting.WinForms.ReportParameter(); RParameterItem.Name = dtRpara.Rows[i]["RP_KEY"].ToString(); RParameterItem.Values.Add(dtRpara.Rows[i]["RP_VAL"].ToString()); RParameters[i] = RParameterItem; } this.reportViewer1.ServerReport.SetParameters(RParameters); } this.reportViewer1.ShowParameterPrompts = true; this.reportViewer1.RefreshReport(); }
private void frmPrint_Load(object sender, EventArgs e) { if (_bit == 1) { // ManageReceipt MR = new ManageReceipt(); DataTable ManageReceipt = new DataTable(); ReceiptBindingSource.DataSource = _list; foreach (var ReceiptRecord in _list) { var Quantity = ReceiptRecord.QTY; var ProductID = ReceiptRecord.BARCODE_ID; int Quantities = Quantity; string id = ProductID; string TOTAL = Convert.ToString(ReceiptRecord.TOTAL); string UNIT_TOTAL = Convert.ToString(ReceiptRecord.UNIT_PRICE); SaveInvoiceData(id, Quantities, TOTAL, _billNo, _date, _time, UNIT_TOTAL, ReceiptRecord.PRODUCT_NAME, _cash, _change, _operator); UpdateStockQuantityProducts(id, Quantities); } Microsoft.Reporting.WinForms.ReportParameter[] para = new Microsoft.Reporting.WinForms.ReportParameter[] { new Microsoft.Reporting.WinForms.ReportParameter("pTotal", _total), new Microsoft.Reporting.WinForms.ReportParameter("pCash", _cash), new Microsoft.Reporting.WinForms.ReportParameter("pChange", _change), new Microsoft.Reporting.WinForms.ReportParameter("pDate", _date), new Microsoft.Reporting.WinForms.ReportParameter("pBill", Convert.ToString(_billNo)), new Microsoft.Reporting.WinForms.ReportParameter("pOperator", _operator), new Microsoft.Reporting.WinForms.ReportParameter("pTime", _time), }; this.reportViewer1.LocalReport.SetParameters(para); this.reportViewer1.RefreshReport(); string savePath = @"D:\Invoice Generate\" + _billNo + ".PDF"; byte[] Bytes = reportViewer1.LocalReport.Render(format: "PDF", deviceInfo: ""); using (FileStream stream = new FileStream(savePath, FileMode.Create)) { stream.Write(Bytes, 0, Bytes.Length); } } else { DataTable ManageReceipt = new DataTable(); ReceiptBindingSource.DataSource = _list; foreach (var ReceiptRecord in _list) { var Quantity = ReceiptRecord.QTY; var ProductID = ReceiptRecord.BARCODE_ID; int Quantities = Quantity; string id = ProductID; string TOTAL = Convert.ToString(ReceiptRecord.TOTAL); string UNIT_TOTAL = Convert.ToString(ReceiptRecord.UNIT_PRICE); Microsoft.Reporting.WinForms.ReportParameter[] para = new Microsoft.Reporting.WinForms.ReportParameter[] { new Microsoft.Reporting.WinForms.ReportParameter("pTotal", _total), new Microsoft.Reporting.WinForms.ReportParameter("pCash", _cash), new Microsoft.Reporting.WinForms.ReportParameter("pChange", _change), new Microsoft.Reporting.WinForms.ReportParameter("pDate", _date), new Microsoft.Reporting.WinForms.ReportParameter("pBill", Convert.ToString(_billNo)), new Microsoft.Reporting.WinForms.ReportParameter("pOperator", _operator), new Microsoft.Reporting.WinForms.ReportParameter("pTime", _time), }; this.reportViewer1.LocalReport.SetParameters(para); this.reportViewer1.RefreshReport(); string savePath = @"D:\Invoice Returns\" + _billNo + ".PDF"; byte[] Bytes = reportViewer1.LocalReport.Render(format: "PDF", deviceInfo: ""); //string savePath = @"D:\Invoice Returns\" + _billNo + ".Image"; //byte[] Bytes = reportViewer1.LocalReport.Render(format: "Image", deviceInfo: ""); using (FileStream stream = new FileStream(savePath, FileMode.Create)) { stream.Write(Bytes, 0, Bytes.Length); } } } }
//ReportGeneralPrint_Load private void ReportGeneralPrint_Load(object sender, EventArgs e) { try { //set location for form this.Location = new Point(point_x, point_y); DataTable dt_tb_order = new DataTable(); dt_tb_order = bus_tb_order.GetOrderPrint(StaticClass.GeneralClass.condition_report_order); DataTable dt_tb_cloned = dt_tb_order.Clone(); dt_tb_cloned.Columns["DiscountType"].DataType = typeof(string); dt_tb_cloned.Columns["Discount"].DataType = typeof(string); dt_tb_cloned.Columns["TotalDiscount"].DataType = typeof(string); dt_tb_cloned.Columns["TotalTax"].DataType = typeof(string); dt_tb_cloned.Columns["TotalAmount"].DataType = typeof(string); foreach (DataRow row in dt_tb_order.Rows) { dt_tb_cloned.ImportRow(row); } foreach (DataRow row in dt_tb_cloned.Rows) { _orderDate = string.Format(@"{0:" + StaticClass.GeneralClass.dateFromatSettings[StaticClass.GeneralClass.app_settings["dateFormat"]].ToString() + _orderTime + "}", Convert.ToDateTime(row["OrderDate"].ToString())); if (row["DiscountType"].ToString() == "1") { row["DiscountType"] = "%"; } else { row["DiscountType"] = StaticClass.GeneralClass.currency_setting_general; } row["Discount"] = StaticClass.GeneralClass.GetNumFormatDisplay(Convert.ToDecimal(row["Discount"].ToString())); row["TotalDiscount"] = StaticClass.GeneralClass.currency_setting_general + StaticClass.GeneralClass.GetNumFormatDisplay(Convert.ToDecimal(string.IsNullOrEmpty(row["TotalDiscount"].ToString()) ? "0" : row["TotalDiscount"].ToString())); row["TotalTax"] = StaticClass.GeneralClass.currency_setting_general + StaticClass.GeneralClass.GetNumFormatDisplay(Convert.ToDecimal(row["TotalTax"].ToString())); row["TotalAmount"] = StaticClass.GeneralClass.currency_setting_general + StaticClass.GeneralClass.GetNumFormatDisplay(Convert.ToDecimal(row["TotalAmount"].ToString())); row["OrderDate"] = _orderDate; } this.rptOrders.RefreshReport(); this.rptOrders.LocalReport.ReportEmbeddedResource = "CashierRegister.Pages.Report.rpt_Orders.rdlc"; this.rptOrders.LocalReport.DataSources.Clear(); Microsoft.Reporting.WinForms.ReportDataSource report_datasource = new Microsoft.Reporting.WinForms.ReportDataSource("DS_rpt_Order", dt_tb_cloned); this.rptOrders.LocalReport.DataSources.Add(report_datasource); Microsoft.Reporting.WinForms.ReportParameter[] rpt_parameter = new Microsoft.Reporting.WinForms.ReportParameter[] { new Microsoft.Reporting.WinForms.ReportParameter("titleParameter", titleParameter), new Microsoft.Reporting.WinForms.ReportParameter("idParameter", idParameter), new Microsoft.Reporting.WinForms.ReportParameter("customerNameParameter", customerNameParameter), new Microsoft.Reporting.WinForms.ReportParameter("quantityParameter", quantityParameter), new Microsoft.Reporting.WinForms.ReportParameter("orderDateParameter", orderDateParameter), new Microsoft.Reporting.WinForms.ReportParameter("salespersonNameParameter", salespersonNameParameter), new Microsoft.Reporting.WinForms.ReportParameter("paymentParameter", paymentParameter), new Microsoft.Reporting.WinForms.ReportParameter("discountTypeParameter", discountTypeParameter), new Microsoft.Reporting.WinForms.ReportParameter("discountParameter", discountParameter), new Microsoft.Reporting.WinForms.ReportParameter("totalDiscountParameter", totalDiscountParameter), new Microsoft.Reporting.WinForms.ReportParameter("totalTaxParameter", totalTaxParameter), new Microsoft.Reporting.WinForms.ReportParameter("totalAmountParameter", totalAmountParameter), }; this.rptOrders.LocalReport.SetParameters(rpt_parameter); this.rptOrders.RefreshReport(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public void LoadReport() { try { DateTime?dtFrom = dtpFromDate.Value.ToDateorNull(); DateTime?dtTill = dtpToDate.Value.ToDateorNull(); if (dtFrom != null && dtpFromTime.Value != null && dtpFromTime.Value.Value != null) { dtFrom = (dtFrom.Value.ToDate() + dtpFromTime.Value.Value.TimeOfDay).ToDateTime(); } int driverId = ddlAllDriver.SelectedValue.ToInt(); int SubCompanyId = ddlSubCompany.SelectedValue.ToInt(); int Rating; if (ddlRating.Text == "") { Rating = 0; } else { Rating = ddlRating.Text.ToInt(); } if (dtTill != null && dtptilltime.Value != null && dtptilltime.Value.Value != null) { dtTill = (dtTill.Value.ToDate() + dtptilltime.Value.Value.TimeOfDay).ToDateTime(); } string Error = string.Empty; if (dtFrom == null) { Error = "Required: From Date"; } if (dtTill == null) { if (string.IsNullOrEmpty(Error)) { Error = "Required: To Date"; } else { Error += Environment.NewLine + "Required: To Date"; } } if (!string.IsNullOrEmpty(Error)) { ENUtils.ShowMessage(Error); return; } this.reportViewer1.LocalReport.EnableExternalImages = true; using (TaxiDataContext db = new TaxiDataContext()) { var list2 = db.stp_CustomerFeedback(dtFrom, dtTill, SubCompanyId, driverId, Rating).ToList();; this.stp_CustomerFeedbackResultBindingSource.DataSource = list2; } Microsoft.Reporting.WinForms.ReportParameter[] param = new Microsoft.Reporting.WinForms.ReportParameter[3]; string heading = string.Empty; heading = "Date Range: " + string.Format("{0:yyyy-MM-dd HH:mm}", dtFrom) + " to " + string.Format("{0:yyyy-MM-dd HH:mm}", dtTill); //heading = "From: "+string.Format("{0:dd/MM/yyyy}", dtFrom) + " To: " + string.Format("{0:dd/MM/yyyy}", dtTill); // string EndDate = string.Format("{0:dd/MM/yyyy}", DateTime.Now); //string To = string.Format("{0:dd/MM/yyyy}", dtTill); // string Earning = "Driver Earnings - "+list.Count().ToStr()+" found"; param[0] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_CompanyHeading", AppVars.objSubCompany.CompanyName); param[1] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_Address", AppVars.objSubCompany.Address); param[2] = new Microsoft.Reporting.WinForms.ReportParameter("ReportParameterPeriod", heading); //List<ClsLogo> objLogo = new List<ClsLogo>(); //objLogo.Add(new ClsLogo { ImageInBytes = AppVars.objSubCompany.CompanyLogo != null ? AppVars.objSubCompany.CompanyLogo.ToArray() : null }); //ReportDataSource imageDataSource = new ReportDataSource("Taxi_AppMain_Classes_ClsLogo", objLogo); //this.reportViewer1.LocalReport.DataSources.Add(imageDataSource); reportViewer1.LocalReport.SetParameters(param); this.reportViewer1.ZoomPercent = 100; this.reportViewer1.ZoomMode = Microsoft.Reporting.WinForms.ZoomMode.Percent; this.reportViewer1.RefreshReport(); IsReportLoaded = true; } catch (Exception ex) { ENUtils.ShowMessage(ex.Message); } }
private void LaskuPohja_Load(object sender, EventArgs e) { using (SqlConnection connection = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;" + @"AttachDbFilename=|DataDirectory|\mokkivaraus.mdf; Integrated Security=True")) { try { // Määritellään SQL-tietokannasta tehtävä haku. string query = "SELECT Lasku.lasku_id, Lasku.nimi, Lasku.lahiosoite, Lasku.postitoimipaikka, Lasku.email, Lasku.summa, Lasku.alv, Lasku.paivays, Varaus.varaus_id " + "FROM Lasku " + "INNER JOIN Varaus ON Varaus.varaus_id = Lasku.varaus_id " + "WHERE Varaus.varaus_id = @varaus_id"; SqlCommand command = new SqlCommand(query, connection); // Suorita haku tietokannasta ja vie hakutulokset //DataGridView-näkymään tarkasteltavaksi. command.Parameters.Add("@varaus_id", SqlDbType.Int).Value = Convert.ToInt32(Laskutus.Varaus_id); SqlDataAdapter dataAdapter = new SqlDataAdapter(command); DataSet ds = new DataSet(); dataAdapter.Fill(ds); nimi = ds.Tables[0].Rows[0]["nimi"].ToString(); lahiosoite = ds.Tables[0].Rows[0]["lahiosoite"].ToString(); postitoimipaikka = ds.Tables[0].Rows[0]["postitoimipaikka"].ToString(); email = ds.Tables[0].Rows[0]["email"].ToString(); lasku_id = ds.Tables[0].Rows[0]["lasku_id"].ToString(); paivays = DateTime.Parse(ds.Tables[0].Rows[0]["paivays"].ToString()); erapaiva = DateTime.Parse(ds.Tables[0].Rows[0]["paivays"].ToString()).AddDays(14); varaus_id = ds.Tables[0].Rows[0]["varaus_id"].ToString(); summa = ds.Tables[0].Rows[0]["summa"].ToString(); viite = DateTime.Parse(ds.Tables[0].Rows[0]["paivays"].ToString()).Year + ds.Tables[0].Rows[0]["varaus_id"].ToString(); } catch (Exception ex) { // Tulosta virheilmoitus. MessageBox.Show("Tapahtui virhe: " + ex.Message, "Virhe", MessageBoxButtons.OK, MessageBoxIcon.Error); } try { // Määritellään raportin parametrit. Microsoft.Reporting.WinForms.ReportParameter[] parameters = new Microsoft.Reporting.WinForms.ReportParameter[] { new Microsoft.Reporting.WinForms.ReportParameter("LaskuNimi", LaskuPohja.Nimi), new Microsoft.Reporting.WinForms.ReportParameter("LaskuLahiosoite", LaskuPohja.Lahiosoite), new Microsoft.Reporting.WinForms.ReportParameter("LaskuPostitoimipaikka", LaskuPohja.Postitoimipaikka), new Microsoft.Reporting.WinForms.ReportParameter("LaskuEmail", LaskuPohja.Email), new Microsoft.Reporting.WinForms.ReportParameter("LaskuId", LaskuPohja.Lasku_id), new Microsoft.Reporting.WinForms.ReportParameter("LaskuViite", LaskuPohja.Viite.ToString()), new Microsoft.Reporting.WinForms.ReportParameter("LaskuPaivays", LaskuPohja.Paivays.ToShortDateString()), new Microsoft.Reporting.WinForms.ReportParameter("LaskuErapaiva", LaskuPohja.Erapaiva.ToShortDateString()), new Microsoft.Reporting.WinForms.ReportParameter("LaskuVarausId", LaskuPohja.Varaus_Id), new Microsoft.Reporting.WinForms.ReportParameter("LaskuSumma", LaskuPohja.Summa), }; // Vie edellä määritellyt parametrit ReportViewer-ikkunaan. this.reportViewer_LaskuPohja.LocalReport.SetParameters(parameters); this.reportViewer_LaskuPohja.RefreshReport(); } catch (Exception ex) { // Tulosta virheilmoitus. MessageBox.Show("Tapahtui virhe: " + ex.Message, "Virhe", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }
//ReportDetailPrint_Load private void ReportDetailPrint_Load(object sender, EventArgs e) { try { //set location for form this.Location = new Point(point_x, point_y); DataTable dt_tb_orderdetail = new DataTable(); dt_tb_orderdetail = bus_tb_orderdetail.GetOrderDetail("Where [OrderID]=" + StaticClass.GeneralClass.orderdetailid_general); DataTable dt_tb_cloned = dt_tb_orderdetail.Clone(); dt_tb_cloned.Columns["Price"].DataType = typeof(string); dt_tb_cloned.Columns["Tax"].DataType = typeof(string); dt_tb_cloned.Columns["DiscountType"].DataType = typeof(string); dt_tb_cloned.Columns["Discount"].DataType = typeof(string); dt_tb_cloned.Columns["Total"].DataType = typeof(string); foreach (DataRow row in dt_tb_orderdetail.Rows) { dt_tb_cloned.ImportRow(row); } foreach (DataRow row in dt_tb_cloned.Rows) { row["Price"] = StaticClass.GeneralClass.currency_setting_general + StaticClass.GeneralClass.GetNumFormatDisplay(Convert.ToDecimal(row["Price"].ToString())); row["Tax"] = StaticClass.GeneralClass.currency_setting_general + StaticClass.GeneralClass.GetNumFormatDisplay(Convert.ToDecimal(row["Tax"].ToString())); if (row["DiscountType"].ToString() == "1") { row["DiscountType"] = "%"; } else { row["DiscountType"] = StaticClass.GeneralClass.currency_setting_general; } row["Discount"] = StaticClass.GeneralClass.GetNumFormatDisplay(Convert.ToDecimal(row["Discount"].ToString())); row["Total"] = StaticClass.GeneralClass.currency_setting_general + StaticClass.GeneralClass.GetNumFormatDisplay(Convert.ToDecimal(row["Total"].ToString())); } this.rpvOrderDetail.RefreshReport(); rpvOrderDetail.LocalReport.ReportEmbeddedResource = "CashierRegister.Pages.Report.rpt_OrderDetails.rdlc"; rpvOrderDetail.LocalReport.DataSources.Clear(); Microsoft.Reporting.WinForms.ReportDataSource reportdatasource = new Microsoft.Reporting.WinForms.ReportDataSource("DS_rpt_OrderDetail", dt_tb_cloned); rpvOrderDetail.LocalReport.DataSources.Add(reportdatasource); Microsoft.Reporting.WinForms.ReportParameter[] rpt_parameter = new Microsoft.Reporting.WinForms.ReportParameter[] { new Microsoft.Reporting.WinForms.ReportParameter("titleParameter", titleParameter), new Microsoft.Reporting.WinForms.ReportParameter("idParameter", idParameter), new Microsoft.Reporting.WinForms.ReportParameter("categoryNameParameter", categoryNameParameter), new Microsoft.Reporting.WinForms.ReportParameter("productIDParameter", productIDParameter), new Microsoft.Reporting.WinForms.ReportParameter("productNameParameter", productNameParameter), new Microsoft.Reporting.WinForms.ReportParameter("priceParameter", priceParameter), new Microsoft.Reporting.WinForms.ReportParameter("qtyParameter", qtyParameter), new Microsoft.Reporting.WinForms.ReportParameter("taxParameter", taxParameter), new Microsoft.Reporting.WinForms.ReportParameter("discountTypeParameter", discountTypeParameter), new Microsoft.Reporting.WinForms.ReportParameter("discountParameter", discountParameter), new Microsoft.Reporting.WinForms.ReportParameter("totalParameter", totalParameter), }; this.rpvOrderDetail.LocalReport.SetParameters(rpt_parameter); rpvOrderDetail.RefreshReport(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public void LoadReport() { try { DateTime?dtFrom = dtpFromDate.Value.ToDateorNull(); DateTime?dtTill = dtpToDate.Value.ToDateorNull(); if (dtFrom != null && dtpFromTime.Value != null && dtpFromTime.Value.Value != null) { dtFrom = (dtFrom.Value.ToDate() + dtpFromTime.Value.Value.TimeOfDay).ToDateTime(); } if (dtTill != null && dtptilltime.Value != null && dtptilltime.Value.Value != null) { dtTill = (dtTill.Value.ToDate() + dtptilltime.Value.Value.TimeOfDay).ToDateTime(); } string Error = string.Empty; if (dtFrom == null) { Error = "Required: From Date"; } if (dtTill == null) { if (string.IsNullOrEmpty(Error)) { Error = "Required: To Date"; } else { Error += Environment.NewLine + "Required: To Date"; } } if (!string.IsNullOrEmpty(Error)) { ENUtils.ShowMessage(Error); return; } this.reportViewer1.LocalReport.EnableExternalImages = true; if (templateName == null) { templateName = General.GetObject <UM_Form_Template>(c => c.UM_Form.FormName == this.Name && c.IsDefault == true).DefaultIfEmpty().TemplateName.ToStr(); } int cnt = 0; if (templateName.ToStr().ToLower().Trim() == "template2") { this.reportViewer1.LocalReport.ReportEmbeddedResource = "Taxi_AppMain.ReportDesigns.template2_rptDriverEarning.rdlc"; var list = (from a in new Taxi_Model.TaxiDataContext().stp_GetDriverEarning(dtFrom, dtTill, ddlAllDriver.SelectedValue.ToInt(), Enums.BOOKINGSTATUS.DISPATCHED, 0) select new { DriverId = a.DriverId, DriverNo = a.DriverNo, Name = a.Name, LoginHour = a.LoginHour, TotalDays = a.TotalDays, TotalHrs = a.TotalHrs, BreakTime = a.Break, Total = a.Total, Noshow = a.Noshow, JobsDone = a.JobsDone, Decline = a.Decline, //Earning = (a.TotalDays==2?(a.Total-a.Commission):a.Total).ToDecimal(), Earning = (a.Account - a.Commission).ToDecimal(), Account = a.Account, Cash = a.Cash, Commission = a.Commission, AvgJob = a.PDARent, Avghour = a.Parking + a.ExtraDropCharges, Avgday = ((a.Account - a.Commission).ToDecimal() + (a.Parking + a.ExtraDropCharges)) - a.PDARent, LoginDateTime = a.LoginDateTime, a.PDARent, a.Parking, a.Waiting, a.ExtraDropCharges, a.DriverCommissionPerBooking }).ToList(); var list2 = (list.AsEnumerable().OrderBy(item => item.DriverNo, new NaturalSortComparer <string>())).ToList(); this.stp_GetDriverCommissionEarningResultBindingSource.DataSource = list2; cnt = list.Count; } else { var list = (from a in new Taxi_Model.TaxiDataContext().stp_GetDriverEarning(dtFrom, dtTill, ddlAllDriver.SelectedValue.ToInt(), Enums.BOOKINGSTATUS.DISPATCHED, 0) select new { //DriverId = a.DriverId, //DriverNo = a.DriverNo, //Name = a.Name, //LoginHour = a.LoginHour, //TotalDays = a.TotalDays, //TotalHrs = a.TotalHrs, //Total = a.Total, //Noshow = a.Noshow, //JobsDone = a.JobsDone, //Decline = a.Decline, //Earning = (a.Total-a.Commission), //Account = a.Account, //Cash = a.Cash, //Commission = a.Commission, //AvgJob = AvgJob(a.Total.ToDecimal(),a.Commission.ToDecimal(),a.JobsDone.ToInt()),//(((a.Total - a.Commission) / (a.JobsDone))).ToDecimal(), //Avghour = ((a.Total/(a.LoginHour.ToInt()==0?1:a.LoginHour))).ToDecimal(), //Avgday = ((a.Total /( a.LoginDateTime.ToInt()==0?1:a.LoginDateTime))).ToDecimal(), //LoginDateTime = a.LoginDateTime, DriverId = a.DriverId, DriverNo = a.DriverNo, Name = a.Name, LoginHour = a.LoginHour, TotalDays = a.TotalDays, TotalHrs = a.TotalHrs, BreakTime = a.Break, Total = a.Total, Noshow = a.Noshow, JobsDone = a.JobsDone, Decline = a.Decline, //Earning = (a.TotalDays==2?(a.Total-a.Commission):a.Total).ToDecimal(), Earning = (a.TotalDays == 2 ? (a.Total - a.Commission) : a.Total).ToDecimal(), Account = a.Account, Cash = a.Cash, Commission = a.Commission, AvgJob = AvgJob(a.Total.ToDecimal(), a.TotalDays == 2 ? a.Commission.ToDecimal() : 0, a.JobsDone.ToInt()), //(((a.Total - a.Commission) / (a.JobsDone))).ToDecimal(), Avghour = ((a.Total / (a.LoginHour.ToInt() == 0 ? 1 : a.LoginHour))).ToDecimal(), Avgday = ((a.Total / (a.LoginDateTime.ToInt() == 0 ? 1 : a.LoginDateTime))).ToDecimal(), LoginDateTime = a.LoginDateTime, a.PDARent, a.Parking, a.Waiting, a.ExtraDropCharges, a.DriverCommissionPerBooking }).ToList(); var list2 = (list.AsEnumerable().OrderBy(item => item.DriverNo, new NaturalSortComparer <string>())).ToList(); this.stp_GetDriverCommissionEarningResultBindingSource.DataSource = list2; cnt = list.Count; } Microsoft.Reporting.WinForms.ReportParameter[] param = new Microsoft.Reporting.WinForms.ReportParameter[2]; string heading = string.Empty; heading = "Date Range: " + string.Format("{0:yyyy-MM-dd HH:mm}", dtFrom) + " to " + string.Format("{0:yyyy-MM-dd HH:mm}", dtTill); string Earning = "Driver Earnings - " + cnt.ToStr() + " found"; param[0] = new Microsoft.Reporting.WinForms.ReportParameter("ReportParameterPeriod", heading); param[1] = new Microsoft.Reporting.WinForms.ReportParameter("ReportParameterTotalDrivers", Earning); reportViewer1.LocalReport.SetParameters(param); this.reportViewer1.ZoomPercent = 100; this.reportViewer1.ZoomMode = Microsoft.Reporting.WinForms.ZoomMode.Percent; this.reportViewer1.RefreshReport(); IsReportLoaded = true; } catch (Exception ex) { ENUtils.ShowMessage(ex.Message); } }
private void FormRelatorio_Load(object sender, EventArgs e) { if (connectBanco()) { try { reportDataSource1.Name = "DataSet1"; switch (Op) { case 1: reportDataSource1.Value = this.getdataprazoBindingSource; this.reportViewer1.LocalReport.ReportEmbeddedResource = "Report.Relatorio.NBaixa.rdlc"; var dataprazo = new Microsoft.Reporting.WinForms.ReportParameter("Data", Aux); this.reportViewer1.LocalReport.SetParameters(dataprazo); this.getdataprazoTableAdapter.Fill(this.dBars.Getdataprazo, Aux); break; case 2: reportDataSource1.Value = this.getnomebaixaBindingSource; reportDataSource2.Value = this.quantidadeBaixaBindingSource; this.reportViewer1.LocalReport.ReportEmbeddedResource = "Report.Relatorio.BaixaHoje.rdlc"; var baixa = new Microsoft.Reporting.WinForms.ReportParameter("Data", Aux); var nome = new Microsoft.Reporting.WinForms.ReportParameter(nameof(Nome), Nome); this.reportViewer1.LocalReport.SetParameters(new Microsoft.Reporting.WinForms.ReportParameter[] { baixa, nome }); this.getnomebaixaTableAdapter.Fill(this.dBars.Getnomebaixa, Aux, Nome); this.quantidadeBaixaTableAdapter.Fill(this.dBars.QuantidadeBaixa, Aux); break; case 3: reportDataSource1.Value = this.getDataBindingSource; reportDataSource2.Value = this.quantidadeBaixaBindingSource; this.reportViewer1.LocalReport.ReportEmbeddedResource = "Report.Relatorio.BaixasPar.rdlc"; var qnt = new Microsoft.Reporting.WinForms.ReportParameter("Quantidade", Aux); var get = new Microsoft.Reporting.WinForms.ReportParameter("Data", Aux); this.reportViewer1.LocalReport.SetParameters(new Microsoft.Reporting.WinForms.ReportParameter[] { qnt, get }); this.getDataTableAdapter.Fill(this.dBars.GetData, Aux); this.quantidadeBaixaTableAdapter.Fill(this.dBars.QuantidadeBaixa, Aux); break; case 4: reportDataSource1.Value = this.getImportaBindingSource; this.reportViewer1.LocalReport.ReportEmbeddedResource = "Report.Relatorio.TitBaixaHoje.rdlc"; var Data = new Microsoft.Reporting.WinForms.ReportParameter("Data", data.ToShortDateString()); this.reportViewer1.LocalReport.SetParameters(Data); this.getImportaTableAdapter.Fill(this.dBars.GetImporta, data); break; default: this.Dispose(); this.Close(); break; } this.reportViewer1.LocalReport.DataSources.Add(reportDataSource1); this.reportViewer1.LocalReport.DataSources.Add(reportDataSource2); } catch (Exception ex) { MessageBox.Show(ex.Message, "Relatório", MessageBoxButtons.OK, MessageBoxIcon.Error); this.Close(); } var pg = new System.Drawing.Printing.PageSettings { Margins = new System.Drawing.Printing.Margins(36, 2, 10, 2), Landscape = true }; this.reportViewer1.SetPageSettings(pg); this.reportViewer1.SetDisplayMode(Microsoft.Reporting.WinForms.DisplayMode.PrintLayout); this.reportViewer1.RefreshReport(); } }