private PengajuanDomain GeneratePengajuan(string noId) { SqlConnection conn = Common.getConnection(); string query = ""; SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandType = System.Data.CommandType.Text; PengajuanDomain pDomain = new PengajuanDomain(); query = "select * from v_pengajuan where id_pengajuan ='" + noId + "' "; cmd.CommandText = query; conn.Open(); SqlDataReader reader = cmd.ExecuteReader(); reader.Read(); pDomain.IDPengajuan = reader["id_pengajuan"].ToString(); pDomain.Judul = reader["judul_pengajuan"].ToString(); pDomain.Keterangan = reader["catatan_kabag"].ToString(); // pDomain.Keterangan = reader["memo_kabag"].ToString(); pDomain.Prioritas = reader["status_prioritas"].ToString(); // pDomain.HargaTotal = reader["harga_total"].ToString(); pDomain.Tgl = reader["created_date"].ToString(); // pDomain.status = reader["status"].ToString(); conn.Close(); return(pDomain); }
// Create a local report for Report.rdlc, load the data, // export the report to an .emf file, and print it. private void RunPrint() { LocalReport report = new LocalReport(); report.ReportPath = "Laporan/PengajuanInvDetail.rdlc"; PengajuanDomain peDomain = GeneratePengajuan(TbIDNoPengajuan.Text); ReportParameter[] parameters = new ReportParameter[6]; parameters[0] = new ReportParameter("No", peDomain.No); parameters[1] = new ReportParameter("TglPengajuan", peDomain.TglPengajuan); parameters[2] = new ReportParameter("Hal", peDomain.Hal); parameters[3] = new ReportParameter("Keterangan", peDomain.Keterangan); parameters[4] = new ReportParameter("Prioritas", peDomain.Prioritas); parameters[5] = new ReportParameter("Pengaju", peDomain.Pengaju); report.SetParameters(parameters); DataTable dt = GetData(peDomain.id); report.DataSources.Add(new ReportDataSource("DS_V_Pengajuan_report_detail", dt)); Export(report); Print(); }
private void GenerateReport() { //dataTable string idPengajuan = Request.QueryString["IdPengajuan"]; ReportViewer1.Reset(); ReportViewer1.LocalReport.ReportPath = "Laporan/PengajuanInvDetail.rdlc"; PengajuanDomain peDomain = GeneratePengajuan(idPengajuan); ReportParameter[] parameters = new ReportParameter[5]; parameters[0] = new ReportParameter("IDPengajuan", peDomain.IDPengajuan); parameters[1] = new ReportParameter("TglPengajuan", peDomain.Tgl); // parameters[2] = new ReportParameter("Judul", peDomain.Hal); parameters[2] = new ReportParameter("Judul", peDomain.Judul); parameters[3] = new ReportParameter("Keterangan", peDomain.Keterangan); if (peDomain.Prioritas.Equals("3")) { parameters[4] = new ReportParameter("Prioritas", "Normal"); } else if (peDomain.Prioritas.Equals("2")) { parameters[4] = new ReportParameter("Prioritas", "Penting"); } else if (peDomain.Prioritas.Equals("1")) { parameters[4] = new ReportParameter("Prioritas", "Urgen"); } ReportViewer1.LocalReport.SetParameters(parameters); DataTable dt = GetData(peDomain.IDPengajuan); ReportDataSource dataSource = new ReportDataSource("DataSet1", dt); ReportViewer1.LocalReport.DataSources.Add(dataSource); ReportViewer1.ShowPrintButton = true; PageSettings pg = new System.Drawing.Printing.PageSettings(); pg.Margins.Top = 0; pg.Margins.Bottom = 0; pg.Margins.Left = 0; pg.Margins.Right = 0; PrinterSettings ps = new System.Drawing.Printing.PrinterSettings(); ps.PrinterName = "Microsoft XPS Document Writer"; PaperSize size = new PaperSize(); size.RawKind = (int)PaperKind.A4; pg.PaperSize = size; pg.PrinterSettings = ps; ReportViewer1.SetPageSettings(pg); ReportViewer1.LocalReport.Refresh(); }
private void GenerateReport() { //dataTable ReportViewer1.Reset(); ReportViewer1.LocalReport.ReportPath = "Laporan/PengajuanInvDetail.rdlc"; PengajuanDomain peDomain = GeneratePengajuan(TbIDNoPengajuan.Text); ReportParameter[] parameters = new ReportParameter[6]; parameters[0] = new ReportParameter("No", peDomain.No); parameters[1] = new ReportParameter("TglPengajuan", peDomain.TglPengajuan); parameters[2] = new ReportParameter("Hal", peDomain.Hal); parameters[3] = new ReportParameter("Keterangan", peDomain.Keterangan); parameters[4] = new ReportParameter("Prioritas", peDomain.Prioritas); parameters[5] = new ReportParameter("Pengaju", peDomain.Pengaju); ReportViewer1.LocalReport.SetParameters(parameters); DataTable dt = GetData(peDomain.id); ReportDataSource dataSource = new ReportDataSource("DS_V_Pengajuan_report_detail", dt); ReportViewer1.LocalReport.DataSources.Add(dataSource); ReportViewer1.ShowPrintButton = true; PageSettings pg = new System.Drawing.Printing.PageSettings(); pg.Margins.Top = 0; pg.Margins.Bottom = 0; pg.Margins.Left = 0; pg.Margins.Right = 0; PrinterSettings ps = new System.Drawing.Printing.PrinterSettings(); ps.PrinterName = "Microsoft XPS Document Writer"; PaperSize size = new PaperSize(); size.RawKind = (int)PaperKind.A4; pg.PaperSize = size; pg.PrinterSettings = ps; ReportViewer1.SetPageSettings(pg); ReportViewer1.LocalReport.Refresh(); }
private PengajuanDomain GeneratePengajuan(string noId) { SqlConnection conn = Common.getConnection(); string query = ""; SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandType = System.Data.CommandType.Text; PengajuanDomain pDomain = new PengajuanDomain(); query = "select * from v_pengajuan where id_pengajuan ='" + noId + "' or no_pengajuan ='" + noId + "'"; cmd.CommandText = query; conn.Open(); SqlDataReader reader = cmd.ExecuteReader(); reader.Read(); pDomain.id = reader["id"].ToString(); pDomain.Hal = reader["judul_pengajuan"].ToString().Trim(); pDomain.Pengaju = reader["kabag"].ToString(); pDomain.Keterangan = reader["keterangan"].ToString(); pDomain.Keterangan = reader["memo_kabag"].ToString(); pDomain.No = reader["no_pengajuan"].ToString(); pDomain.TglPengajuan = reader["created_date"].ToString(); string prioritas = reader["status_prioritas"].ToString(); if (prioritas.Equals("1")) { pDomain.Prioritas = "URGENT"; } else if (prioritas.Equals("2")) { pDomain.Prioritas = "PENTING"; } else { pDomain.Prioritas = "NORMAL"; } conn.Close(); return(pDomain); }