private void DisplayReport2()
{
DataSet ds = new dsNotaPembelian();
DataTable dt = ds.Tables[0];
string idtr = "";
string TglSj = string.Empty;
string KodeBarang;
string NamaStok = "";
int HrgJual = 0;
int _No = 0;
int hrgBeli = 0;
foreach (DataRow dr in tblHeader.Rows)
{
_No = _No + 1;
idtr = Tools.isNull(dr["idtr"], "").ToString().Trim();
TglSj = Tools.isNull(dr["Tgl_sj"], "").ToString();
DataRow[] Details = tblDetail.Select("Idtr='" + idtr + "'");
foreach (DataRow drd in Details)
{
NamaStok = Tools.isNull(drd["Nama_stok"], "").ToString().Trim();
HrgJual = Convert.ToInt32(Tools.isNull(drd["H_jual"], "0").ToString().Trim());
KodeBarang = Tools.isNull(drd["Kode_brg"], "").ToString().Trim();
TglSj = Tools.isNull(dr["Tgl_sj"], "").ToString();
hrgBeli = GetHargaBeli(KodeBarang, (DateTime)dr["Tgl_sj"]);
DataRow drw = dt.NewRow();
drw["Nilai"] = _No;
drw["NamaBarang"] = NamaStok;
drw["HrgJual"] = HrgJual;
drw["HrgBeli"] = hrgBeli;
if (hrgBeli != HrgJual)
{
dt.Rows.Add(drw);
}
}
}
if (dt.Rows.Count > 0)
{
string periode;
periode = String.Format("Tanggal :{0}", ((DateTime)DateTime.Now).ToString("dd/MM/yyyy"));
//construct parameter
List <ReportParameter> rptParams = new List <ReportParameter>();
rptParams.Add(new ReportParameter("UserID", SecurityManager.UserID));
rptParams.Add(new ReportParameter("Periode", periode));
//call report viewer
frmReportViewer ifrmReport = new frmReportViewer("Communicator.rptNotaPembelianDownloadBedaHarga.rdlc", rptParams, dt, "dsNotaPembelian_Data");
ifrmReport.Show();
}
}
private void DisplayReport3()
{
DataSet ds = new dsNotaPembelian();
DataTable dt = ds.Tables[0];
string idtr = "";
string KodeBarang;
string NamaStok = "";
int HrgJual = 0;
string Satuan = "";
foreach (DataRow dr in tblHeader.Rows)
{
idtr = Tools.isNull(dr["idtr"], "").ToString().Trim();
DataRow[] Details = tblDetail.Select("Idtr='" + idtr + "'");
foreach (DataRow drd in Details)
{
NamaStok = Tools.isNull(drd["Nama_stok"], "").ToString().Trim();
HrgJual = Convert.ToInt32(Tools.isNull(drd["H_jual"], "0").ToString().Trim());
KodeBarang = Tools.isNull(drd["Kode_brg"], "").ToString().Trim();
Satuan = Tools.isNull(drd["Satuan"], "").ToString().Trim();
DataRow drw = dt.NewRow();
drw["NamaBarang"] = NamaStok;
drw["HrgJual"] = HrgJual;
drw["BarangID"] = KodeBarang;
drw["Satuan"] = Satuan;
if (ChekBarang(KodeBarang))
{
dt.Rows.Add(drw);
}
}
}
if (dt.Rows.Count > 0)
{
string periode;
periode = String.Format("Tanggal :{0}", ((DateTime)DateTime.Now).ToString("dd/MM/yyyy"));
//construct parameter
List <ReportParameter> rptParams = new List <ReportParameter>();
rptParams.Add(new ReportParameter("UserID", SecurityManager.UserID));
rptParams.Add(new ReportParameter("Periode", periode));
//call report viewer
frmReportViewer ifrmReport = new frmReportViewer("Communicator.rptNotaPembelianDownloadStokBaru.rdlc", rptParams, dt, "dsNotaPembelian_Data");
ifrmReport.Show();
}
}
private void DisplayReport1()
{
DataSet ds = new dsNotaPembelian();
DataTable dt = ds.Tables[0];
string idtr = "";
string NoRq = "";
string TglRq = string.Empty;
string NoDO = "";
string TglDO = string.Empty;
string NoNota = "";
string TglNota = string.Empty;
string NamaStok = "";
int HrgJual = 0;
int QtySJ = 0;
int _No = 0;
foreach (DataRow dr in tblHeader.Rows)
{
idtr = Tools.isNull(dr["idtr"], "").ToString().Trim();
NoRq = Tools.isNull(dr["no_rq"], "").ToString().Trim();
TglRq = Tools.isNull(dr["tgl_rq"], "").ToString();
NoDO = Tools.isNull(dr["No_do"], "").ToString().Trim();
TglDO = Tools.isNull(dr["Tgl_do"], "").ToString();
DateTime result;
if (DateTime.TryParse(dr["Tgl_nota"].ToString(), out result))
{
TglNota = result.ToString("dd/MM/yyyy");
}
else
{
TglNota = "1900/1/1";
}
NoNota = Tools.isNull(dr["No_nota"], "").ToString().Trim();
_No = _No + 1;
DataRow[] Details = tblDetail.Select("Idtr='" + idtr + "'");
foreach (DataRow drd in Details)
{
NamaStok = Tools.isNull(drd["Nama_stok"], "").ToString().Trim();
HrgJual = Convert.ToInt32(Tools.isNull(drd["H_jual"], "0").ToString().Trim());
QtySJ = Convert.ToInt32(Tools.isNull(drd["J_sj"], "0").ToString().Trim());
DataRow drw = dt.NewRow();
drw["NoRequest"] = NoRq;
drw["TglRequest"] = TglRq;
drw["NoNota"] = NoNota;
drw["TglNota"] = TglNota;
drw["NamaBarang"] = NamaStok;
drw["QtySuratJalan"] = QtySJ;
drw["HrgBeli"] = HrgJual;
drw["TglDO"] = TglDO;
drw["NoDO"] = NoDO;
drw["Nilai"] = _No;
dt.Rows.Add(drw);
}
}
if (dt.Rows.Count > 0)
{
string periode;
periode = String.Format("Tanggal :{0}", ((DateTime)DateTime.Now).ToString("dd/MM/yyyy"));
//construct parameter
List <ReportParameter> rptParams = new List <ReportParameter>();
rptParams.Add(new ReportParameter("UserID", SecurityManager.UserID));
rptParams.Add(new ReportParameter("Periode", periode));
rptParams.Add(new ReportParameter("Gudang", GlobalVar.Gudang));
//call report viewer
frmReportViewer ifrmReport = new frmReportViewer("Communicator.rptNotaPembelianDownload.rdlc", rptParams, dt, "dsNotaPembelian_Data");
ifrmReport.Show();
}
}
