private void ReportViewer1OnLoad(object sender, EventArgs eventArgs)
{
var ds = new DataSetLog();
var reportDataSource = new ReportDataSource();
ds.BeginInit();
reportDataSource.Name = "DataSetLog";
reportDataSource.Value = ds.LogExport;
ReportViewer1.LocalReport.DataSources.Add(reportDataSource);
ReportViewer1.LocalReport.ReportEmbeddedResource = "TemperatureRecorder.Report2.rdlc";
ReportViewer1.LocalReport.EnableExternalImages = true;
ds.EndInit();
ds.LogExport.Clear();
ds.LogExport.AddLogExportRow(Export.ItemName, Export.StartDate, Export.EndDate, Export.Graph, Export.HashValue, Export.Min, Export.Max);
var pageSettings = new PageSettings();
pageSettings.Margins.Top = 0;
pageSettings.Margins.Bottom = 0;
pageSettings.Margins.Left = 0;
pageSettings.Margins.Right = 0;
var pageSize = new PaperSize();
pageSize.RawKind = (int)PaperKind.A4;
pageSettings.PaperSize = pageSize;
pageSettings.Landscape = true;
ReportViewer1.SetPageSettings(pageSettings);
ReportViewer1.RefreshReport();
}
private void GenerateReport()
{
//dataTable
ReportViewer1.Reset();
DataTable dt = GetData();
ReportDataSource dataSource = new ReportDataSource("DataSet1", dt);
ReportViewer1.LocalReport.DataSources.Add(dataSource);
ReportViewer1.LocalReport.ReportPath = "Laporan/InvRusak.rdlc";
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
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
string idPengajuan = Request.QueryString["IdPembelian"];
ReportViewer1.Reset();
ReportViewer1.LocalReport.ReportPath = "Laporan/PembelianDetail.rdlc";
PembelianDomain peDomain = GeneratePembelian(idPengajuan);
ReportParameter[] parameters = new ReportParameter[6];
parameters[0] = new ReportParameter("NoPembelian", peDomain.IDPembelian);
parameters[1] = new ReportParameter("TglBeli", peDomain.Tgl);
// parameters[2] = new ReportParameter("Judul", peDomain.Hal);
parameters[2] = new ReportParameter("Keterangan", peDomain.Keterangan);
parameters[3] = new ReportParameter("RefPengajuan", peDomain.RefPengajuan);
parameters[4] = new ReportParameter("HargaTotal", peDomain.HargaTotal);
parameters[5] = new ReportParameter("Status", peDomain.status);
ReportViewer1.LocalReport.SetParameters(parameters);
DataTable dt = GetData(peDomain.RefPengajuan);
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/ServiceKeluarDetail.rdlc";
ServiceKeluar peDomain = GenerateService(TbIDNoPengajuan.Text);
ReportParameter[] parameters = new ReportParameter[6];
parameters[0] = new ReportParameter("IDService", peDomain.id);
parameters[1] = new ReportParameter("JudulService", peDomain.Judul);
parameters[2] = new ReportParameter("Status", peDomain.Status);
parameters[3] = new ReportParameter("TglService", peDomain.TglService);
parameters[4] = new ReportParameter("RefService", peDomain.RefService);
parameters[5] = new ReportParameter("Keterangan", peDomain.Keterangan);
ReportViewer1.LocalReport.SetParameters(parameters);
DataTable dt = GetData(peDomain.RefService);
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 void GenerateReport()
{
//dataTable
ReportViewer1.Reset();
DataTable dt = GetData();
ReportDataSource dataSource = new ReportDataSource("DSet_V_Pengajuan_Report", dt);
ReportViewer1.LocalReport.DataSources.Add(dataSource);
ReportViewer1.LocalReport.ReportPath = "Laporan/PengajuanInv.rdlc";
ReportViewer1.ShowPrintButton = true;
ReportParameter[] parameters = new ReportParameter[2];
parameters[0] = new ReportParameter("TglDari", TbTanggalDari.Text);
parameters[1] = new ReportParameter("TglKe", TbTanggalKe.Text);
ReportViewer1.LocalReport.SetParameters(parameters);
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()
{
string id = Request.QueryString["IdPenugasan"];
//dataTable
ReportViewer1.Reset();
DataTable dt = GetData(id);
DataTable dt2 = GetDetail(id);
DataTable dt3 = GetDetailLain(id);
ReportDataSource dataSource = new ReportDataSource("DSPenugasan", dt);
ReportDataSource dataSource2 = new ReportDataSource("DSPerbaikanDetail", dt2);
ReportDataSource dataSource3 = new ReportDataSource("DSPenugasanLain", dt3);
ReportViewer1.LocalReport.DataSources.Add(dataSource);
ReportViewer1.LocalReport.DataSources.Add(dataSource2);
ReportViewer1.LocalReport.DataSources.Add(dataSource3);
ReportViewer1.LocalReport.ReportPath = "Laporan/PerbaikanBarang.rdlc";
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/PenerimaanDetail.rdlc";
PenerimaanDomain peDomain = GeneratePenerimaan(TbID.Text);
ReportParameter[] parameters = new ReportParameter[5];
parameters[0] = new ReportParameter("NoPenerimaan", peDomain.No);
parameters[1] = new ReportParameter("TglPenerimaan", peDomain.TglPenerimaan);
parameters[2] = new ReportParameter("Hal", peDomain.Hal);
parameters[3] = new ReportParameter("Keterangan", peDomain.Keterangan);
/*
* if (peDomain.Tipe.Equals("1"))
* {
* parameters[4] = new ReportParameter("Tipe", "Dengan Pengajuan Barang");
*
* }
* else if (peDomain.Tipe.Equals("2"))
* {
* parameters[4] = new ReportParameter("Tipe", "Dengan Pengajuan Service");
*
* }
* else
* {
* parameters[5] = new ReportParameter("Tipe", "Tanpa Pengajuan");
* }
*
* SqlConnection conn = Common.getConnection();
* string query = "";
* SqlCommand cmd = new SqlCommand();
* cmd.Connection = conn;
* cmd.CommandType = System.Data.CommandType.Text;
*
*
* if (peDomain.Tipe.Equals("1"))
* {
* query = "select no_pengajuan from t_pengajuan_inventaris where id = " + peDomain.id + "";
*
* }
* else if (peDomain.Tipe.Equals("2"))
* {
* query = "select no_pengajuan from t_pengajuan_service where id = " + peDomain.id + "";
*
* }
* cmd.CommandText = query;
*
* conn.Open();
* try
* {
* SqlDataReader reader = cmd.ExecuteReader();
* reader.Read();
* string pengajuan = reader["no_pengajuan"].ToString().Trim();
* parameters[5] = new ReportParameter("RefPengajuan", pengajuan);
*
* }
* catch
* {
* }
*
* conn.Close();
*/
parameters[4] = new ReportParameter("RefPengajuan", peDomain.RefPengajuan);
ReportViewer1.LocalReport.SetParameters(parameters);
DataTable dt = GetData(peDomain);
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);
System.Diagnostics.Debug.WriteLine("RPT " + ReportViewer1.Width);
ReportViewer1.LocalReport.Refresh();
}
/// <summary>
/// 打印
/// </summary>
/// <param name="startIndex"></param>
/// <returns></returns>
private void Print()
{
try
{
var item = PrintData.Data[Index];
m_currentPageIndex = 0;
m_streams = null;
PageSettings ps = Config.GetPageSettings();
ReportViewer1.SetPageSettings(ps);
ReportViewer1.LocalReport.ReportPath = Config.TemplateLocation(PrintData.PrintTemplate.FileName);
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource(PrintData.PrintTemplate.DataSetName, item.ToDataTable()));
var printParams = PrintData.PrintTemplate.PrintParams;
if (printParams.Count > 0)
{
int j = 0;
foreach (var parameter in ReportViewer1.LocalReport.GetParameters())
{
var db_param = PrintData.PrintTemplate.PrintParams.Find(p => p.PrintParamName == parameter.Name);
string fileName = $"{PrintData.PrintTemplate.PrintTemplateID}_{db_param.Value}{Index}{j++}";
switch (db_param.ParamType)
{
case ParamType.BarCode:
//创建条形码文件
fileName += "1D";
string value = CanCreateCode(db_param, item, out bool isCreate);
if (isCreate == false)
{
Message = $"值({value})不能生成条形码";
return;
}
PrintReport.CreateBarCode(value, fileName, Config.TempleAddress);
break;
case ParamType.QRCode:
//创建二维码
fileName += "2D";
value = CanCreateCode(db_param, item, out isCreate);
if (isCreate == false)
{
Message = $"值({value})不能生成条形码";
}
PrintReport.CreateQRCode(value, fileName, Config.TempleAddress);
break;
case ParamType.Other:
ReportViewer1.LocalReport.SetParameters(new ReportParameter
(parameter.Name, Convert.ToString(item[db_param.Value])));
continue;
case ParamType.SQL:
value = "0";
if (item.ContainsKey(db_param.Value))
{
value = Convert.ToString(item[db_param.Value]);
}
ReportViewer1.LocalReport.SetParameters(new ReportParameter
(parameter.Name, value));
continue;
}
var file = Path.Combine(Config.TempleAddress, fileName + ".bmp");
ReportViewer1.LocalReport.SetParameters(new ReportParameter(parameter.Name, "file://" + file));
}
ReportViewer1.SetDisplayMode(DisplayMode.PrintLayout);
ReportViewer1.ZoomMode = ZoomMode.Percent;
ReportViewer1.ZoomPercent = 100;
}
}
catch (Exception ex)
{
Message = ex.Message;
}
}
