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