private void DisplayReport(DataSet ds)
{
try
{
ISA.Controls.MonthYearBox m = new ISA.Controls.MonthYearBox();
m.Year = Setorans.Year;
m.Month = Setorans.Month;
string periode = string.Empty;
periode = String.Format("{0} s/d {1}", rangeDateBox1.FromDate.Value.ToString("dd-MMM-yyyy"), rangeDateBox1.ToDate.Value.ToString("dd-MMM-yyyy"));
List <ReportParameter> rptParams = new List <ReportParameter>();
rptParams.Add(new ReportParameter("Periode", periode));
rptParams.Add(new ReportParameter("Title", "NOTA - NOTA YANG JATUH TEMPO BULAN DEPAN"));
//call report viewer
frmReportViewer ifrmReport = new frmReportViewer("Setoran.Report.rpt10PenjualanJTBulanDepan.rdlc", rptParams, ds.Tables[0], "dsSetoran_Data");
ifrmReport.Text = "Lap Bayar 3 Bulan";
ifrmReport.Show();
}
catch (System.Exception ex)
{
Error.LogError(ex);
}
finally
{
this.Cursor = Cursors.Default;
}
}
private void DisplayReport(DataSet ds)
{
try
{
ISA.Controls.MonthYearBox m = new ISA.Controls.MonthYearBox();
m.Year = Setorans.Year;
m.Month = Setorans.Month;
string periode = string.Empty;
periode = String.Format("{0} s/d {1}", ds.Tables[0].Rows[0][0].ToString(), ds.Tables[0].Rows[0][1].ToString());
List <ReportParameter> rptParams = new List <ReportParameter>();
rptParams.Add(new ReportParameter("Periode", periode));
rptParams.Add(new ReportParameter("Title", "Pemabayaran 3 Bulan Terakhir"));
//call report viewer
frmReportViewer ifrmReport = new frmReportViewer("Setoran.Report.rpt11Pembayaran3Bulan.rdlc", rptParams, ds.Tables[1], "dsSetoran_Data");
ifrmReport.Text = "Lap Bayar 3 Bulan";
ifrmReport.Show();
}
catch (System.Exception ex)
{
Error.LogError(ex);
}
finally
{
this.Cursor = Cursors.Default;
}
}
private void DisplayReport(DataSet ds)
{
try
{
ISA.Controls.MonthYearBox m = new ISA.Controls.MonthYearBox();
m.Year = Setorans.Year;
m.Month = Setorans.Month;
string periode = string.Empty;
periode = String.Format("{0} ", m.LastDateOfMonth.ToString("dd-MMM-yyyy"));
List <ReportParameter> rptParams = new List <ReportParameter>();
rptParams.Add(new ReportParameter("Periode", periode));
rptParams.Add(new ReportParameter("Title", "Nota jatuh Sesuai Rencana"));
//call report viewer
frmReportViewer ifrmReport = new frmReportViewer("Setoran.Report.rpt12NotaJtRencana.rdlc", rptParams, ds.Tables[0], "dsSetoran_Data");
ifrmReport.Text = "Lap Rencana JT Nota";
ifrmReport.Show();
}
catch (System.Exception ex)
{
Error.LogError(ex);
}
finally
{
this.Cursor = Cursors.Default;
}
}
private void frmRpt10PenjualanJTBulanDepan_Load(object sender, EventArgs e)
{
ISA.Controls.MonthYearBox m = new ISA.Controls.MonthYearBox();
m.Year = Setorans.Year;
m.Month = Setorans.Month;
rangeDateBox1.FromDate = m.FirstDateOfMonth;
rangeDateBox1.ToDate = m.LastDateOfMonth;
}
private void frmRpt09CPiutang_Load(object sender, EventArgs e)
{
ISA.Controls.MonthYearBox m = new ISA.Controls.MonthYearBox();
m.Year = Setorans.Year;
m.Month = Setorans.Month;
rangeDateBox1.FromDate = m.FirstDateOfMonth;
rangeDateBox1.ToDate = m.LastDateOfMonth;
}
private void DisplayReport(DataSet ds)
{
try
{
ISA.Controls.MonthYearBox m = new ISA.Controls.MonthYearBox();
m.Year = Setorans.Year;
m.Month = Setorans.Month;
string periode = string.Empty;
periode = String.Format("{0} s/d {1}", rangeDateBox1.FromDate.Value.ToString("dd-MMM-yyyy"), rangeDateBox1.ToDate.Value.ToString("dd-MMM-yyyy"));
List <ReportParameter> rptParams = new List <ReportParameter>();
rptParams.Add(new ReportParameter("Periode", periode));
rptParams.Add(new ReportParameter("Title", "Laporan Rencana dan Realisasi Piutang"));
//call report viewer
if (rdbGloabal.Checked)
{
frmReportViewer ifrmReport = new frmReportViewer("Setoran.Report.rpt09CPiutang1.rdlc", rptParams, ds.Tables[0], "dsSetoran_Data");
ifrmReport.Text = "Global";
ifrmReport.Show();
}
else
{
rptParams.RemoveAt(1);
rptParams.Add(new ReportParameter("Title", "Laporan Rencana dan Realisasi Piutang"));
frmReportViewer ifrmReport = new frmReportViewer("Setoran.Report.rpt09CPiutang2.rdlc", rptParams, ds.Tables[0], "dsSetoran_Data");
ifrmReport.Text = "Sesuai Rencana";
ifrmReport.Show();
rptParams.RemoveAt(1);
rptParams.Add(new ReportParameter("Title", "Laporan Realisasi Piutang di luar rencana"));
frmReportViewer ifrmReport2 = new frmReportViewer("Setoran.Report.rpt09CPiutang3.rdlc", rptParams, ds.Tables[1], "dsSetoran_Data");
ifrmReport2.Text = "Diluar Rencana";
ifrmReport2.Show();
}
}
catch (System.Exception ex)
{
Error.LogError(ex);
}
finally
{
this.Cursor = Cursors.Default;
}
}
private void DisplayReport(DataSet ds)
{
try
{
ISA.Controls.MonthYearBox m = new ISA.Controls.MonthYearBox();
m.Year = Setorans.Year;
m.Month = Setorans.Month;
string periode = string.Empty;
periode = String.Format("{0} ", m.LastDateOfMonth.ToString("MMMM-yyyy"));
List <ReportParameter> rptParams = new List <ReportParameter>();
rptParams.Add(new ReportParameter("Periode", periode));
rptParams.Add(new ReportParameter("Title", "REALISASI SETORAN " + GlobalVar.Gudang));
rptParams.Add(new ReportParameter("Title2", "CABANG: PT. SURYA ANUGRAH SETIAABADI "));
rptParams.Add(new ReportParameter("FirstDate", m.FirstDateOfMonth.ToString("yyyy/MM/dd")));
rptParams.Add(new ReportParameter("LastDate", m.LastDateOfMonth.Day.ToString()));
//call report viewer
List <DataTable> pTable = new List <DataTable>();
pTable.Add(ds.Tables[0]);
// pTable.Add(ds.Tables[1]);
List <string> pDatasetName = new List <string>();
pDatasetName.Add("dsSetoran_data2");
// pDatasetName.Add("dsSetoran_Data1");
frmReportViewer ifrmReport = new frmReportViewer("Setoran.Report.rpt05RSetoran.rdlc", rptParams, pTable, pDatasetName);
ifrmReport.Text = "Global";
ifrmReport.Show();
}
catch (System.Exception ex)
{
Error.LogError(ex);
}
finally
{
this.Cursor = Cursors.Default;
}
}
private void commandButton1_Click(object sender, EventArgs e)
{
ISA.Controls.MonthYearBox m = new ISA.Controls.MonthYearBox();
m.Year = Setorans.Year;
m.Month = Setorans.Month;
try
{
this.Cursor = Cursors.WaitCursor;
DataSet ds = new DataSet();
using (Database db = new Database(GlobalVar.DBName))
{
db.Commands.Add(db.CreateCommand("rsp_Setoran_04_PiutangGiro"));
db.Commands[0].Parameters.Add(new Parameter("@tglSetoran", SqlDbType.DateTime, m.LastDateOfMonth));
db.Commands[0].Parameters.Add(new Parameter("@RpMin", SqlDbType.Money, Setorans.Min));
db.Commands[0].Parameters.Add(new Parameter("@LMin", SqlDbType.Bit, Setorans.LMin ? 1 :0));
ds = db.Commands[0].ExecuteDataSet();
}
if (ds.Tables[0].Rows.Count == 0)
{
MessageBox.Show("No Data");
return;
}
// dt.DefaultView.Sort = cboSort.SelectedValue.ToString();
DisplayReport(ds);
}
catch (System.Exception ex)
{
Error.LogError(ex);
}
finally
{
this.Cursor = Cursors.Default;
}
}
private void DisplayReport(DataSet ds)
{
try
{
ISA.Controls.MonthYearBox m = new ISA.Controls.MonthYearBox();
m.Year = Setorans.Year;
m.Month = Setorans.Month;
string periode = string.Empty;
periode = String.Format("{0} s/d {1}", rangeDateBox1.FromDate.Value.ToString("dd-MMM-yyyy"), rangeDateBox1.ToDate.Value.ToString("dd-MMM-yyyy"));
List <ReportParameter> rptParams = new List <ReportParameter>();
rptParams.Add(new ReportParameter("Periode", periode));
rptParams.Add(new ReportParameter("Title", "LAPORAN TITIPAN PELUNASAN PIUTANG"));
//call report viewer
List <DataTable> pTable = new List <DataTable>();
pTable.Add(ds.Tables[0]);
pTable.Add(ds.Tables[1]);
List <string> pDatasetName = new List <string>();
pDatasetName.Add("dsSetoran_Data");
pDatasetName.Add("dsSetoran_Data1");
frmReportViewer ifrmReport = new frmReportViewer("Setoran.Report.rpt08TitipPiutang.rdlc", rptParams, pTable, pDatasetName);
ifrmReport.Text = "Global";
ifrmReport.Show();
}
catch (System.Exception ex)
{
Error.LogError(ex);
}
finally
{
this.Cursor = Cursors.Default;
}
}
