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