private void pbPrint_Click(object sender, EventArgs e)
{
if (dataGridView1.RowCount <= 1)
{
return;
}
string reportFileName = "SmartMES_SinMyung.Reports.P1C04_MATERIAL_USE.rdlc";
string reportParm1 = "생산기간 : ";
string reportParm2 = "자재창고 : ";
string reportParm3 = "자재분류 : ";
reportParm1 = reportParm1 + dtpFromDate.Value.ToString("yyyy-MM-dd") + " ~ " + dtpToDate.Value.ToString("yyyy-MM-dd");
reportParm2 = reportParm2 + cbDepot.Text;
reportParm3 = reportParm3 + cbKind.Text;
ViewReport_V viewReport = new ViewReport_V();
viewReport.reportViewer1.ProcessingMode = ProcessingMode.Local;
viewReport.reportViewer1.LocalReport.ReportEmbeddedResource = reportFileName;
ReportParameter rp1 = new ReportParameter("ReportParameter1", reportParm1);
ReportParameter rp2 = new ReportParameter("ReportParameter2", reportParm2);
ReportParameter rp3 = new ReportParameter("ReportParameter3", reportParm3);
viewReport.reportViewer1.LocalReport.SetParameters(new ReportParameter[] { rp1, rp2, rp3 });
ReportDataSource rds = new ReportDataSource("DataSet1", sPMaterialUseQueryBindingSource);
viewReport.reportViewer1.LocalReport.DataSources.Add(rds);
viewReport.reportViewer1.LocalReport.Refresh();
viewReport.ShowDialog();
}
private void pbPrint_Click(object sender, EventArgs e)
{
string reportFileName = "SmartMES_SinMyung.Reports.P1A01_CUSTOMER.rdlc";
string reportParm1 = "매입/매출 구분 : ";
string reportParm2 = "거래처명/대표자/주소 : ";
string reportParm3 = "";
reportParm1 = reportParm1 + cbFlag.Text;
reportParm2 = reportParm2 + tbSearch.Text.Trim();
reportParm3 = reportParm3 + "";
ViewReport_V viewReport = new ViewReport_V();
viewReport.reportViewer1.ProcessingMode = ProcessingMode.Local;
viewReport.reportViewer1.LocalReport.ReportEmbeddedResource = reportFileName;
ReportParameter rp1 = new ReportParameter("ReportParameter1", reportParm1);
ReportParameter rp2 = new ReportParameter("ReportParameter2", reportParm2);
ReportParameter rp3 = new ReportParameter("ReportParameter3", reportParm3);
viewReport.reportViewer1.LocalReport.SetParameters(new ReportParameter[] { rp1, rp2, rp3 });
ReportDataSource rds = new ReportDataSource("DataSet1", sPCustomerQueryBindingSource);
viewReport.reportViewer1.LocalReport.DataSources.Add(rds);
viewReport.reportViewer1.LocalReport.Refresh();
viewReport.ShowDialog();
}
private void pbPrint_Click(object sender, EventArgs e)
{
int id = Int32.Parse(lblID.Text.Substring(6, lblID.Text.Length - 6));
if (id < 1)
{
lblMsg.Text = "출력할 설비 카드를 먼저 선택해 주세요.";
return;
}
sP_MachineCard_SelectTableAdapter.Fill(dataSetP1D.SP_MachineCard_Select, id);
string reportFileName = "SmartMES_SinMyung.Reports.P1D01_MACHINECARD.rdlc";
ViewReport_V viewReport = new ViewReport_V();
viewReport.reportViewer1.ProcessingMode = ProcessingMode.Local;
viewReport.reportViewer1.LocalReport.ReportEmbeddedResource = reportFileName;
ReportDataSource rds = new ReportDataSource("DataSet1", sPMachineCardSelectBindingSource);
viewReport.reportViewer1.LocalReport.DataSources.Add(rds);
viewReport.reportViewer1.LocalReport.Refresh();
viewReport.ShowDialog();
}
private void pbPrint_Click(object sender, EventArgs e)
{
lblMsg.Text = "";
if (dataGridView1.RowCount <= 0)
{
lblMsg.Text = "성적서 발행건이 선택되지 않았습니다.";
return;
}
if (dataGridView1[8, 0].Value == null ||
string.IsNullOrEmpty(dataGridView1[8, 0].Value.ToString()))
{
lblMsg.Text = "저장된 검사건만 성적서 출력이 가능합니다.";
return;
}
string rorderID = dataGridView1[8, 0].Value.ToString();
sP_QcFinal_PrintTableAdapter.Fill(dataSetP1E.SP_QcFinal_Print, rorderID);
string reportFileName = "SmartMES_SinMyung.Reports.P1ED01_QC_FINAL.rdlc";
ViewReport_V viewReport = new ViewReport_V();
viewReport.reportViewer1.ProcessingMode = ProcessingMode.Local;
viewReport.reportViewer1.LocalReport.ReportEmbeddedResource = reportFileName;
ReportDataSource rds = new ReportDataSource("DataSet1", sPQcFinalPrintBindingSource);
viewReport.reportViewer1.LocalReport.DataSources.Add(rds);
viewReport.reportViewer1.LocalReport.Refresh();
viewReport.ShowDialog();
}
private void pbPrint_Click(object sender, EventArgs e)
{
if (dataGridView1.RowCount <= 1)
{
return;
}
string reportFileName = "SmartMES_SinMyung.Reports.P1B12_BUY_ITEM.rdlc";
string reportParm1 = "매입기간 : ";
string reportParm2 = "품목명/규격 : ";
string reportParm3 = "매입처 : ";
reportParm1 = reportParm1 + dtpFromDate.Value.ToString("yyyy-MM-dd") + " ~ " + dtpToDate.Value.ToString("yyyy-MM-dd");
if (string.IsNullOrEmpty(tbSearch.Text.Trim()))
{
reportParm2 = reportParm2 + "전체";
}
else
{
reportParm2 = reportParm2 + tbSearch.Text.Trim();
}
if (string.IsNullOrEmpty(tbCust.Text))
{
reportParm2 = reportParm2 + "전체";
}
else
{
reportParm3 = reportParm3 + tbSearch.Text;
}
ViewReport_V viewReport = new ViewReport_V();
viewReport.reportViewer1.ProcessingMode = ProcessingMode.Local;
viewReport.reportViewer1.LocalReport.ReportEmbeddedResource = reportFileName;
ReportParameter rp1 = new ReportParameter("ReportParameter1", reportParm1);
ReportParameter rp2 = new ReportParameter("ReportParameter2", reportParm2);
ReportParameter rp3 = new ReportParameter("ReportParameter3", reportParm3);
viewReport.reportViewer1.LocalReport.SetParameters(new ReportParameter[] { rp1, rp2, rp3 });
ReportDataSource rds = new ReportDataSource("DataSet1", sPBuyItemQueryBindingSource);
viewReport.reportViewer1.LocalReport.DataSources.Add(rds);
viewReport.reportViewer1.LocalReport.Refresh();
viewReport.ShowDialog();
}
private void pbPrint_Click(object sender, EventArgs e)
{
if (dataGridView1.RowCount <= 1)
{
return;
}
string reportFileName = "SmartMES_SinMyung.Reports.P1B07_DELI_REPORT.rdlc";
string reportParm1 = "출하일자 : ";
string reportParm2 = "전표번호/거래처/영업담당/현장/품목명 : ";
string reportParm3 = "";
reportParm1 = reportParm1 + dtpDate.Value.ToString("yyyy-MM-dd");
if (string.IsNullOrEmpty(tbSearch.Text.Trim()))
{
reportParm2 = reportParm2 + "전체";
}
else
{
reportParm2 = reportParm2 + tbSearch.Text.Trim();
}
reportParm3 = reportParm3 + "";
ViewReport_V viewReport = new ViewReport_V();
viewReport.reportViewer1.ProcessingMode = ProcessingMode.Local;
viewReport.reportViewer1.LocalReport.ReportEmbeddedResource = reportFileName;
ReportParameter rp1 = new ReportParameter("ReportParameter1", reportParm1);
ReportParameter rp2 = new ReportParameter("ReportParameter2", reportParm2);
ReportParameter rp3 = new ReportParameter("ReportParameter3", reportParm3);
viewReport.reportViewer1.LocalReport.SetParameters(new ReportParameter[] { rp1, rp2, rp3 });
ReportDataSource rds = new ReportDataSource("DataSet1", sPDeliReportQueryBindingSource);
viewReport.reportViewer1.LocalReport.DataSources.Add(rds);
viewReport.reportViewer1.LocalReport.Refresh();
viewReport.ShowDialog();
}
private void pbPrint_Click(object sender, EventArgs e)
{
lblMsg.Text = "";
string sNo = tbNo.Text;
if (string.IsNullOrEmpty(sNo))
{
lblMsg.Text = "저장된 출하건만 명세서 출력이 가능합니다.";
return;
}
sP_Delivery_PrintTableAdapter.Fill(dataSetP1B.SP_Delivery_Print, sNo);
string sql = @"select sum(amount+vat) from tb_delivery_sub where deli_id = '" + sNo + "'";
MariaCRUD m = new MariaCRUD();
string msg = string.Empty;
long lTotAmount = long.Parse(m.dbRonlyOne(sql, ref msg).ToString());
//
string reportFileName = "SmartMES_SinMyung.Reports.P1B05_DELIVERY.rdlc";
string reportParm1 = "합계금액 : ";
reportParm1 = reportParm1 + new MyClass().Number2Hangle(lTotAmount) + " 원정";
ViewReport_V viewReport = new ViewReport_V();
viewReport.reportViewer1.ProcessingMode = ProcessingMode.Local;
viewReport.reportViewer1.LocalReport.ReportEmbeddedResource = reportFileName;
ReportParameter rp1 = new ReportParameter("ReportParameter1", reportParm1);
viewReport.reportViewer1.LocalReport.SetParameters(new ReportParameter[] { rp1 });
ReportDataSource rds = new ReportDataSource("DataSet1", sPDeliveryPrintBindingSource);
viewReport.reportViewer1.LocalReport.DataSources.Add(rds);
viewReport.reportViewer1.LocalReport.Refresh();
viewReport.ShowDialog();
}
private void pbPrint_Click(object sender, EventArgs e)
{
if (dataGridView1.RowCount <= 1)
{
return;
}
string reportFileName = "SmartMES_SinMyung.Reports.P1D04_MACHINE_TIME.rdlc";
string reportParm1 = "가동기간 : ";
string reportParm2 = "설비그룹 : ";
string reportParm3 = "";
string reportParmH = "";
reportParm1 = reportParm1 + dtpFromDate.Value.ToString("yyyy-MM-dd") + " ~ " + dtpToDate.Value.ToString("yyyy-MM-dd");
reportParm2 = reportParm2 + cbGrp.Text;
TimeSpan ts = dtpToDate.Value - dtpFromDate.Value;
reportParmH = ((ts.Days + 1) * 8).ToString();
ViewReport_V viewReport = new ViewReport_V();
viewReport.reportViewer1.ProcessingMode = ProcessingMode.Local;
viewReport.reportViewer1.LocalReport.ReportEmbeddedResource = reportFileName;
ReportParameter rp1 = new ReportParameter("ReportParameter1", reportParm1);
ReportParameter rp2 = new ReportParameter("ReportParameter2", reportParm2);
ReportParameter rp3 = new ReportParameter("ReportParameter3", reportParm3);
ReportParameter rpH = new ReportParameter("ReportParameterH", reportParmH);
viewReport.reportViewer1.LocalReport.SetParameters(new ReportParameter[] { rp1, rp2, rp3, rpH });
ReportDataSource rds = new ReportDataSource("DataSet1", sPMachineTimeQueryBindingSource);
viewReport.reportViewer1.LocalReport.DataSources.Add(rds);
viewReport.reportViewer1.LocalReport.Refresh();
viewReport.ShowDialog();
}
private void pbPrint_Click(object sender, EventArgs e)
{
lblMsg.Text = "";
string sDate = dtpDate.Value.ToString("yyyy-MM-dd");
sP_ProdOrder_PrintTableAdapter.Fill(dataSetP1C.SP_ProdOrder_Print, DateTime.Parse(sDate));
string reportFileName = "SmartMES_SinMyung.Reports.P1C01_PROD_ORDER.rdlc";
string reportParm1 = "생산일자 : ";
string reportParm2 = "";
string reportParm3 = "";
reportParm1 = reportParm1 + dtpDate.Value.ToString("yyyy-MM-dd");
ViewReport_V viewReport = new ViewReport_V();
viewReport.reportViewer1.ProcessingMode = ProcessingMode.Local;
viewReport.reportViewer1.LocalReport.ReportEmbeddedResource = reportFileName;
ReportParameter rp1 = new ReportParameter("ReportParameter1", reportParm1);
ReportParameter rp2 = new ReportParameter("ReportParameter2", reportParm2);
ReportParameter rp3 = new ReportParameter("ReportParameter3", reportParm3);
viewReport.reportViewer1.LocalReport.SetParameters(new ReportParameter[] { rp1, rp2, rp3 });
ReportDataSource rds = new ReportDataSource("DataSet1", sPProdOrderPrintBindingSource);
viewReport.reportViewer1.LocalReport.DataSources.Add(rds);
viewReport.reportViewer1.LocalReport.Refresh();
viewReport.ShowDialog();
}
