public void DisplayReportMprb(DataTable dt) { try { //getdataheader(); object sumObject; sumObject = dt.Compute("Sum(JmlHrgRetur)", ""); Double Total = Convert.ToDouble(sumObject); List <ReportParameter> rptParams = new List <ReportParameter>(); rptParams.Add(new ReportParameter("NoMPRB_", dataGridHeader.SelectedCells[0].OwningRow.Cells[NoMPR.Name].Value.ToString())); rptParams.Add(new ReportParameter("TglKirim_", dataGridHeader.SelectedCells[0].OwningRow.Cells[TglKirim.Name].Value.ToString())); rptParams.Add(new ReportParameter("TglMPRB_", dataGridHeader.SelectedCells[0].OwningRow.Cells[TglKeluar.Name].Value.ToString())); rptParams.Add(new ReportParameter("Pemasok_", dataGridHeader.SelectedCells[0].OwningRow.Cells[Pemasok.Name].Value.ToString())); rptParams.Add(new ReportParameter("JumlahTotal", Total.ToString())); rptParams.Add(new ReportParameter("footer", string.Format("{0:dddd, dd MMM yyyy HH:mm:ss}", DateTime.Now) + ", " + SecurityManager.UserName)); frmReportViewer ifrmReport = new frmReportViewer("Pembelian.rptDOCetakMprbPembelian.rdlc", rptParams, dt, "dsReturPembelian_Data"); //ifrmReport.Show(); ifrmReport.Print(); frmReportViewer ifrmReportWatermark = new frmReportViewer("Pembelian.rptDOCetakMprbPembelianWatermark.rdlc", rptParams, dt, "dsReturPembelian_Data"); //ifrmReport.Show(); ifrmReportWatermark.Print(); } catch (Exception ex) { Error.LogError(ex); } }
public void DisplayReportPOSupplier(DataTable dt) { try { //getdataheader(); object sumObject; sumObject = dt.Compute("Sum(Total)", ""); Double Total = Convert.ToDouble(sumObject); List <ReportParameter> rptParams = new List <ReportParameter>(); rptParams.Add(new ReportParameter("NoRequest", dataGridHeader.SelectedCells[0].OwningRow.Cells[NoRequest.Name].Value.ToString())); rptParams.Add(new ReportParameter("Pemasok", dataGridHeader.SelectedCells[0].OwningRow.Cells[Supplier.Name].Value.ToString())); rptParams.Add(new ReportParameter("TglRequest", string.Format("{0:dd MMM yyyy}", (DateTime)dataGridHeader.SelectedCells[0].OwningRow.Cells[TglRequest.Name].Value))); rptParams.Add(new ReportParameter("Salesman", dataGridHeader.SelectedCells[0].OwningRow.Cells[NamaSales.Name].Value.ToString())); rptParams.Add(new ReportParameter("JumlahTotal", Total.ToString())); rptParams.Add(new ReportParameter("footer", string.Format("{0:dddd, MMMM d, yyyy HH:mm:ss}", DateTime.Now) + ", " + SecurityManager.UserName)); rptParams.Add(new ReportParameter("NamaPerusahaan", GlobalVar.PerusahaanName.ToString())); rptParams.Add(new ReportParameter("AlamatPerusahaan", GlobalVar.PerusahaanAddress.ToString())); rptParams.Add(new ReportParameter("KotaPerusahaan", GlobalVar.PerusahaanKota.ToString())); rptParams.Add(new ReportParameter("TelpPerusahaan", GlobalVar.PerusahaanTelp.ToString())); frmReportViewer ifrmReport = new frmReportViewer("Pembelian.rptDOCetakPOSupplier2.rdlc", rptParams, dt, "dsOrderPembelian_CetakPOSup"); //ifrmReport.Show(); ifrmReport.Print(); } catch (Exception ex) { Error.LogError(ex); } }
private void DisplayReport(DataTable dt) { string UserID = SecurityManager.UserName.ToString(); int i = 0; double total = 0, jumlah; string _Terima, _NoBukti, _Tanggal, _Lampiran, _Kasir, _Terbilang; Guid _rowID = (Guid)dgHeaderBKM.SelectedCells[0].OwningRow.Cells["RowID"].Value; _Terima = dgHeaderBKM.SelectedCells[0].OwningRow.Cells["dari"].Value.ToString(); _NoBukti = dgHeaderBKM.SelectedCells[0].OwningRow.Cells["noBukti"].Value.ToString(); _Lampiran = dgHeaderBKM.SelectedCells[0].OwningRow.Cells["Lampiran"].Value.ToString(); _Tanggal = String.Format("{0:dd-MMM-yyyy}", dgHeaderBKM.SelectedCells[0].OwningRow.Cells["tglBukti"].Value); _Kasir = dgHeaderBKM.SelectedCells[0].OwningRow.Cells["Kasir"].Value.ToString(); foreach (DataRow dr in dtBKMDetail.Rows) { total += Convert.ToDouble(dr["Jumlah"].ToString()); } _Terbilang = ISA.Common.Tools.Terbilang(total); List <ReportParameter> rptParams = new List <ReportParameter>(); rptParams.Add(new ReportParameter("UserID", UserID)); rptParams.Add(new ReportParameter("Terima", _Terima)); rptParams.Add(new ReportParameter("NoBukti", _NoBukti)); rptParams.Add(new ReportParameter("Tanggal", _Tanggal)); rptParams.Add(new ReportParameter("Terbilang", _Terbilang)); rptParams.Add(new ReportParameter("Total", total.ToString())); frmReportViewer ifrmReport = new frmReportViewer("Kasir.Report.rptCetakBKMbaru.rdlc", rptParams, dtBKMDetail, "dsBukti_Data"); ifrmReport.Print(); ////ifrmReport.Print(8.5, 6.4); ////ifrmReport.Show(); }
private void DisplayReport(DataTable dt, String Nama) { try { string UserID = SecurityManager.UserName.ToString(); double total = 0; string _Keterangan, _Mode; Guid _rowID = (Guid)dataGridView1.SelectedCells[0].OwningRow.Cells["RowID"].Value; _Keterangan = dataGridView1.SelectedCells[0].OwningRow.Cells["Keterangan"].Value.ToString(); _Mode = dataGridView1.SelectedCells[0].OwningRow.Cells["1"].Value.ToString(); string _Terbilang = Tools.Terbilang(total); List <ReportParameter> rptParams = new List <ReportParameter>(); rptParams.Add(new ReportParameter("UserID", UserID + ", " + String.Format("{0:dd/MM/yyyy hh:mm:ss}", DateTime.Now))); rptParams.Add(new ReportParameter("Keterangan", _Keterangan)); rptParams.Add(new ReportParameter("Mode", _Mode)); rptParams.Add(new ReportParameter("Total", total.ToString())); frmReportViewer ifrmReport = new frmReportViewer("Fixrute.Expedisi." + Nama + ".rdlc", rptParams, dt, "dsNotaPenjualan_Data"); ifrmReport.Print(); ////ifrmReport.Print(8.5, 6.4); ////ifrmReport.Show(); } catch (Exception ex) { MessageBox.Show(ex.ToString(), "error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public void DisplayReport(DataTable dt) { string ketCetak = ""; if (_nCetak == 1) { ketCetak = "(COPY)"; } if (_nCetak == 2) { ketCetak = "(REVISI)"; } string NoMPR = dt.Rows[0]["NoMPR"].ToString(); string NoRetur = dt.Rows[0]["NoNotaRetur"].ToString(); DateTime TglMPR = DateTime.Parse(dt.Rows[0]["TglMPR"].ToString()); string TglNota = (Tools.isNull(dt.Rows[0]["TglNotaRetur"], "").ToString() == "") ? string.Empty : Convert.ToDateTime(dt.Rows[0]["TglNotaRetur"].ToString()).ToString("dd-MMM-yyyy"); string NamaToko = dt.Rows[0]["NamaToko"].ToString().PadRight(31); string Alamat = dt.Rows[0]["Alamat"].ToString().PadRight(60); string Daerah = dt.Rows[0]["Daerah"].ToString().PadRight(25); string IdWil = dt.Rows[0]["WilID"].ToString(); string Kota = dt.Rows[0]["Kota"].ToString(); string Penerima = dt.Rows[0]["Penerima"].ToString(); string UserID = SecurityManager.UserName.ToString(); List <ReportParameter> rptParams = new List <ReportParameter>(); rptParams.Add(new ReportParameter("NoMpr", NoMPR)); rptParams.Add(new ReportParameter("TglMpr", TglMPR.ToString())); rptParams.Add(new ReportParameter("KetCetak", ketCetak)); rptParams.Add(new ReportParameter("NoNotaRetur", NoRetur)); rptParams.Add(new ReportParameter("TglNotaRetur", TglNota)); rptParams.Add(new ReportParameter("NamaToko", NamaToko)); rptParams.Add(new ReportParameter("Alamat", Alamat)); rptParams.Add(new ReportParameter("Daerah", Daerah)); rptParams.Add(new ReportParameter("Kota", Kota)); rptParams.Add(new ReportParameter("UserID", UserID)); frmReportViewer ifrmReport = new frmReportViewer("Penjualan.rptCetakNotaReturJualBaru.rdlc", rptParams, dt, "dsReturPenjualan_Data"); ifrmReport.Print(); //ifrmReport.Show(); if (PrnAktif == "2" || PrnAktif == "3") { ifrmReport = new frmReportViewer("Penjualan.rptCetakNotaReturJualBaru_copy1.rdlc", rptParams, dt, "dsReturPenjualan_Data"); ifrmReport.Print(); //ifrmReport.Show(); } if (PrnAktif == "3") { ifrmReport = new frmReportViewer("Penjualan.rptCetakNotaReturJualBaru_copy2.rdlc", rptParams, dt, "dsReturPenjualan_Data"); ifrmReport.Print(); //ifrmReport.Show(); } }
public void DisplayReport(DataTable dt, String ReportName) { //construct parameter List <ReportParameter> rptParams = new List <ReportParameter>(); //call report viewer frmReportViewer ifrmReport = new frmReportViewer("Penjualan." + ReportName + ".rdlc", rptParams, dt, "dsReturPenjualan_Data"); ifrmReport.Print(); //ifrmReport.Show(); }
private void DisplayReport(DataTable dtLaporan, string namerdlc, string judul) { int i = 0; double total = 0, jumlah; string _Terima, _NoBukti, _Tanggal, _Lampiran, _Kasir, _Terbilang; //Guid RowIDHeader = (Guid)gridHeader.SelectedCells[0].OwningRow.Cells["hdrRowID"].Value; //Guid _RowID = (Guid)dtLaporan.Rows[0]["RowID"]; //string typePrinter = lap.GetPrinterName(); string NamaBank = gridHeader.SelectedCells[0].OwningRow.Cells["hdrNamaBank"].Value.ToString(); string NoBBM = gridHeader.SelectedCells[0].OwningRow.Cells["hdrNoVoucher"].Value.ToString(); string TglBBM = ((DateTime)gridHeader.SelectedCells[0].OwningRow.Cells["hdrTglVoucher"].Value).ToString("dd-MMM-yyyy").Trim(); //string Pembukuan = Tools.isNull(dtLaporan.Rows[0]["Dibukukan"], "").ToString().Trim(); //string Mengetahui = Tools.isNull(dtLaporan.Rows[0]["Diketahui"], "").ToString().Trim(); //string Kasir = Tools.isNull(dtLaporan.Rows[0]["Kasir"], "").ToString().Trim(); //string Penyetor = Tools.isNull(dtLaporan.Rows[0]["Penyetor"], "").ToString().Trim(); string Nomor = string.Empty; string AsalTransfer = string.Empty; string Bank = string.Empty; string TglBank = string.Empty; string TglTransfer = string.Empty; double Jumlah = 0; double sumJumlah = 0; string tempJumlah = string.Empty; string UserID = SecurityManager.UserName.ToString(); foreach (DataRow dr in dtLaporan.Rows) { total += Convert.ToDouble(dr["Nominal"].ToString()); } _Terbilang = Tools.Terbilang(total); List <ReportParameter> rptParams = new List <ReportParameter>(); rptParams.Add(new ReportParameter("UserID", string.Format("{0}, {1:dd/MM/yyyy hh:mm:ss}", SecurityManager.UserName, DateTime.Now))); rptParams.Add(new ReportParameter("NamaBank", NamaBank)); rptParams.Add(new ReportParameter("NoBBM", NoBBM)); rptParams.Add(new ReportParameter("TglBBM", String.Format("{0:dd-MMM-yyyy}", TglBBM))); rptParams.Add(new ReportParameter("Total", total.ToString())); rptParams.Add(new ReportParameter("Terbilang", _Terbilang)); rptParams.Add(new ReportParameter("Judul", judul)); frmReportViewer ifrmReport = new frmReportViewer(namerdlc, rptParams, dtLaporan, "dsLapGiro_Data"); ifrmReport.Print(); ////ifrmReport.Print(8.5, 6.4); ////ifrmReport.Show(); }
private void DisplayReport(DataTable dtLaporan) { int i = 0; double total = 0, jumlah; string _Terima, _NoBukti, _Tanggal, _Lampiran, _Kasir, _Terbilang; Guid _RowID = (Guid)dtLaporan.Rows[0]["RowID"]; //string typePrinter = lap.GetPrinterName(); string NamaBank = Tools.isNull(dtLaporan.Rows[0]["NamaBank"], "").ToString().Trim(); string NoBBM = Tools.isNull(dtLaporan.Rows[0]["NoBBM"], "").ToString().Trim(); string TglBBM = ((DateTime)dtLaporan.Rows[0]["TglBBM"]).ToString("dd-MMM-yyyy").Trim(); string Pembukuan = Tools.isNull(dtLaporan.Rows[0]["Dibukukan"], "").ToString().Trim(); string Mengetahui = Tools.isNull(dtLaporan.Rows[0]["Diketahui"], "").ToString().Trim(); string Kasir = Tools.isNull(dtLaporan.Rows[0]["Kasir"], "").ToString().Trim(); string Penyetor = Tools.isNull(dtLaporan.Rows[0]["Penyetor"], "").ToString().Trim(); string Nomor = string.Empty; string AsalTransfer = string.Empty; string Bank = string.Empty; string TglBank = string.Empty; string TglTransfer = string.Empty; double Jumlah = 0; double sumJumlah = 0; string tempJumlah = string.Empty; string UserID = SecurityManager.UserName.ToString(); foreach (DataRow dr in dtLaporan.Rows) { total += Convert.ToDouble(dr["Nominal"].ToString()); } _Terbilang = ISA.Common.Tools.Terbilang(total); List <ReportParameter> rptParams = new List <ReportParameter>(); rptParams.Add(new ReportParameter("NamaBank", NamaBank)); rptParams.Add(new ReportParameter("NoBBM", NoBBM)); rptParams.Add(new ReportParameter("TglBBM", TglBBM)); rptParams.Add(new ReportParameter("UserID", UserID)); rptParams.Add(new ReportParameter("Total", total.ToString())); rptParams.Add(new ReportParameter("Terbilang", _Terbilang)); frmReportViewer ifrmReport = new frmReportViewer("Kasir.Report.rptCetakBBMbaru.rdlc", rptParams, dtLaporan, "dsBank_Data2"); ifrmReport.Print(); ////ifrmReport.Print(8.5, 6.4); ////ifrmReport.Show(); }
private void DisplayReportFtagih(DataTable dtCetak) { string NamaToko = dtCetak.Rows[0]["NamaToko"].ToString(); string Alamat = dtCetak.Rows[0]["AlamatKirim"].ToString(); string Kota = dtCetak.Rows[0]["Kota"].ToString(); string Daerah = dtCetak.Rows[0]["Daerah"].ToString(); string Propinsi = dtCetak.Rows[0]["Propinsi"].ToString(); string WilID = dtCetak.Rows[0]["WilID"].ToString(); string InfoTagih = dtCetak.Rows[0]["RefCollector"].ToString(); string Telp = dtCetak.Rows[0]["Telp"].ToString(); string UserID = SecurityManager.UserName.ToString(); Alamat += ", " + Kota; Daerah = (string.IsNullOrEmpty(Daerah) == true ? string.Empty : Daerah + ", ") + (string.IsNullOrEmpty(Propinsi) == true ? string.Empty : Propinsi + " ") + (string.IsNullOrEmpty(WilID) == true ? string.Empty : "(" + WilID + ")"); NamaToko += string.IsNullOrEmpty(Telp) == true ? string.Empty : " ==> TELPON : " + Telp; double Total = 0; foreach (DataRowView dr in dtCetak.DefaultView) { Total += double.Parse(Tools.isNull(dr["RpNet3"], "0").ToString()); } List <ReportParameter> rptParams = new List <ReportParameter>(); rptParams.Add(new ReportParameter("NamaToko", NamaToko)); rptParams.Add(new ReportParameter("Alamat", Alamat)); rptParams.Add(new ReportParameter("Daerah", Daerah)); rptParams.Add(new ReportParameter("Total", Total.ToString())); rptParams.Add(new ReportParameter("UserID", UserID)); frmReportViewer ifrmReport = new frmReportViewer("Penjualan.rptCetakFTagihbaru.rdlc", rptParams, dtCetak, "dsNotaPenjualan_Data"); ifrmReport.Print(); //ifrmReport.Show(); //if (PrnAktif == "2") //{ // ifrmReport = new frmReportViewer("Penjualan.rptCetakNotaReturJualBaru_copy1.rdlc", rptParams, dt, "dsReturPenjualan_Data"); // ifrmReport.Print(); // //ifrmReport.Show(); //} }
private void printSubsidi(List <ReportParameter> rptParamsSBD, DataTable dt_rsp) { rptParamsSBD.Add(new ReportParameter("Leasing", dt_rsp.Rows[0]["Leasing"].ToString())); rptParamsSBD.Add(new ReportParameter("Konsumen", dt_rsp.Rows[0]["Konsumen"].ToString())); rptParamsSBD.Add(new ReportParameter("NoKontrak", dt_rsp.Rows[0]["NoKontrak"].ToString())); rptParamsSBD.Add(new ReportParameter("Alamat", dt_rsp.Rows[0]["AlamatKonsumen"].ToString())); rptParamsSBD.Add(new ReportParameter("TahunWarna", dt_rsp.Rows[0]["TahunWarna"].ToString())); rptParamsSBD.Add(new ReportParameter("MerkType", dt_rsp.Rows[0]["MerkType"].ToString())); int nominal = ((int)Double.Parse(dt_rsp.Rows[0]["SaldoSBD"].ToString())); rptParamsSBD.Add(new ReportParameter("NominalSBD", "Rp " + Tools.Nominal(nominal))); rptParamsSBD.Add(new ReportParameter("Terbilang", Tools.Terbilang(nominal) + " RUPIAH")); rptParamsSBD.Add(new ReportParameter("UntukPembayaran", dt_rsp.Rows[0]["UntukPembayaran"].ToString())); rptParamsSBD.Add(new ReportParameter("KotaPerusahaan", dt_rsp.Rows[0]["KotaPerusahaan"].ToString())); rptParamsSBD.Add(new ReportParameter("Tanggal", dt_rsp.Rows[0]["Tanggal"].ToString())); frmReportViewer ifrmReport = new frmReportViewer("Kasir.rptSBD.rdlc", rptParamsSBD, dt_rsp, "dsSuratTahigan_Subsidi"); ifrmReport.Print(); }
private void cmdPRINTHD_Click(object sender, EventArgs e) { try { if (selectedGrid == enumSelectedGrid.GridPembelian) { if (dataGridView1.SelectedCells.Count > 0) { Guid rowID = (Guid)dataGridView1.SelectedCells[0].OwningRow.Cells["RowID"].Value; string _edp; using (Database db = new Database()) { DataTable dt = new DataTable(); db.Commands.Add(db.CreateCommand("rpt_Kartu_Hutang_Dagang")); db.Commands[0].Parameters.Add(new Parameter("@RowID", SqlDbType.UniqueIdentifier, rowID)); db.Commands[0].Parameters.Add(new Parameter("@CabangID", SqlDbType.VarChar, _cabangID)); dt = db.Commands[0].ExecuteDataTable(); List <ReportParameter> rptParams = new List <ReportParameter>(); _edp = String.Format("{0:d/MM/yyyy}", GlobalVar.GetServerDate); rptParams.Add(new ReportParameter("Judul", "KARTU HUTANG DAGANG".ToString())); rptParams.Add(new ReportParameter("EDP", _edp)); rptParams.Add(new ReportParameter("Pembuat", SecurityManager.UserID + " " + GlobalVar.GetServerDateTime_RealTime.ToString())); //GlobalVar.GetServerDateTime_RealTime.ToString() sebelumnya -> GlobalVar.GetServerDate.ToString() frmReportViewer ifrmReport = new frmReportViewer("Pembelian.rptHutangDagang.rdlc", rptParams, dt, "dsPembelian_Kartu_Hutang_Dagang"); ifrmReport.Print(); } } else { MessageBox.Show(Messages.Error.RowNotSelected); } } } catch (Exception ex) { MessageBox.Show("Gagal dicetak !\n" + ex.Message); } }
private void DisplayReport(DataTable dt, String Nama) { try { string UserID = SecurityManager.UserName.ToString(); int i = 0; double total = 0, jumlah; string _Terima, _NoBukti, _Tanggal, _Lampiran, _Kasir, _Terbilang; Guid _rowID = (Guid)dgHeaderBKM.SelectedCells[0].OwningRow.Cells["RowID"].Value; _Terima = dgHeaderBKM.SelectedCells[0].OwningRow.Cells["dari"].Value.ToString(); _NoBukti = dgHeaderBKM.SelectedCells[0].OwningRow.Cells["noBukti"].Value.ToString(); _Lampiran = dgHeaderBKM.SelectedCells[0].OwningRow.Cells["Lampiran"].Value.ToString(); _Tanggal = String.Format("{0:dd-MMM-yyyy}", dgHeaderBKM.SelectedCells[0].OwningRow.Cells["tglBukti"].Value); _Kasir = dgHeaderBKM.SelectedCells[0].OwningRow.Cells["Kasir"].Value.ToString(); foreach (DataRow dr in dtBKMDetail.Rows) { total += Convert.ToDouble(dr["Jumlah"].ToString()); } _Terbilang = Tools.Terbilang(total); List <ReportParameter> rptParams = new List <ReportParameter>(); rptParams.Add(new ReportParameter("UserID", UserID + ", " + String.Format("{0:dd/MM/yyyy hh:mm:ss}", DateTime.Now))); rptParams.Add(new ReportParameter("Terima", _Terima)); rptParams.Add(new ReportParameter("NoBukti", _NoBukti)); rptParams.Add(new ReportParameter("Tanggal", _Tanggal)); rptParams.Add(new ReportParameter("Terbilang", _Terbilang)); rptParams.Add(new ReportParameter("Total", total.ToString())); frmReportViewer ifrmReport = new frmReportViewer("Kasir.Report." + Nama + ".rdlc", rptParams, dtBKMDetail, "dsBukti_Data"); ifrmReport.Print(); ////ifrmReport.Print(8.5, 6.4); ////ifrmReport.Show(); } catch (Exception ex) { MessageBox.Show(ex.ToString(), "error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void printLeasingCopy1(List <ReportParameter> rptParamsLSG, DataTable dt_rsp) { rptParamsLSG.Add(new ReportParameter("NamaPerusahaan", dt_rsp.Rows[0]["NamaPerusahaan"].ToString())); rptParamsLSG.Add(new ReportParameter("Alamat", dt_rsp.Rows[0]["Alamat"].ToString())); rptParamsLSG.Add(new ReportParameter("Kontak", dt_rsp.Rows[0]["Kontak"].ToString())); rptParamsLSG.Add(new ReportParameter("NoTrans", dt_rsp.Rows[0]["NoTrans"].ToString())); rptParamsLSG.Add(new ReportParameter("TerimaDari", dt_rsp.Rows[0]["TerimaDari"].ToString() + ", " + dt_rsp.Rows[0]["AlamatKonsumen"].ToString())); int nominal = ((int)Double.Parse(dt_rsp.Rows[0]["SaldoLSG"].ToString())); rptParamsLSG.Add(new ReportParameter("Terbilang", Tools.Terbilang(nominal) + " RUPIAH")); rptParamsLSG.Add(new ReportParameter("NoKontrak", dt_rsp.Rows[0]["NoKontrak"].ToString())); rptParamsLSG.Add(new ReportParameter("TanggalJTTempo", dt_rsp.Rows[0]["TanggalJTTempo"].ToString())); rptParamsLSG.Add(new ReportParameter("TahunWarna", dt_rsp.Rows[0]["TahunWarna"].ToString())); rptParamsLSG.Add(new ReportParameter("MerkType", dt_rsp.Rows[0]["MerkType"].ToString())); rptParamsLSG.Add(new ReportParameter("NoRangka", dt_rsp.Rows[0]["NoRangka"].ToString())); rptParamsLSG.Add(new ReportParameter("NoMesin", dt_rsp.Rows[0]["NoMesin"].ToString())); rptParamsLSG.Add(new ReportParameter("NominalLSG", Tools.Nominal(nominal))); rptParamsLSG.Add(new ReportParameter("KotaPerusahaan", dt_rsp.Rows[0]["KotaPerusahaan"].ToString())); getLogo(rptParamsLSG, dt_rsp); frmReportViewer ifrmReport = new frmReportViewer("Kasir.rptLSGCopy1.rdlc", rptParamsLSG, dt_rsp, "dsSuratTahigan_LSGCopy1"); ifrmReport.Print(); }
private void cmdPrint_Click(object sender, EventArgs e) { DataTable dtPerusahaan = DataPerusahaan(GlobalVar.PerusahaanRowID); string NoTrans = dgvPembayaran.SelectedCells[0].OwningRow.Cells["NoTrans"].Value.ToString(); string Nama = dgvPembayaran.SelectedCells[0].OwningRow.Cells["Nama"].Value.ToString(); string Alamat = dgvPembayaran.SelectedCells[0].OwningRow.Cells["Alamat"].Value.ToString(); string Kabupaten = dgvPembayaran.SelectedCells[0].OwningRow.Cells["Kota"].Value.ToString(); double Nominal = Convert.ToDouble(dgvPembayaran.SelectedCells[0].OwningRow.Cells["Total"].Value); string Angsuran = dgvPembayaran.SelectedCells[0].OwningRow.Cells["Angsuran"].Value.ToString(); int Angsuran2 = Convert.ToInt32(dgvPembayaran.SelectedCells[0].OwningRow.Cells["Angsuran"].Value); int Jenis = Convert.ToInt32(dgvPembayaran.SelectedCells[0].OwningRow.Cells["JenisSP"].Value); String NoDok = Numerator.NextNumber("NST"); Guid _penjRowID = (Guid)dgvPembayaran.SelectedCells[0].OwningRow.Cells["PenjRowID"].Value; DateTime TglAngsuran = (DateTime)dgvPembayaran.SelectedCells[0].OwningRow.Cells["TglAngsuran"].Value; //Untuk Cek apakah surat peringatan sudah pernah dicetak, karena hanya bisa dicetak satu kali DataTable dtCek = new DataTable(); try { using (Database db = new Database()) { db.Commands.Add(db.CreateCommand("usp_CekSuratSomasi")); db.Commands[0].Parameters.Add(new Parameter("@PenjualanRowID", SqlDbType.UniqueIdentifier, _penjRowID)); db.Commands[0].Parameters.Add(new Parameter("@TglAngsuran", SqlDbType.Date, TglAngsuran)); db.Commands[0].Parameters.Add(new Parameter("@Jenis", SqlDbType.Int, Jenis)); dtCek = db.Commands[0].ExecuteDataTable(); } } catch (Exception ex) { Error.LogError(ex); } if (dtCek.Rows.Count > 0) { MessageBox.Show("Tidak bisa Cetak, Surat Peringatan sudah pernah dicetak."); return; } //Mengambil Lokasi Logo String KWKSNG = System.Reflection.Assembly.GetEntryAssembly().CodeBase.Substring(0, System.Reflection.Assembly.GetEntryAssembly().CodeBase.LastIndexOf("/") + 1); // Application.ExecutablePath.LastIndexOf("/") String FileNameKWKSNG = ""; using (Database dbLogo = new Database()) { DataTable dtLogo = new DataTable(); dbLogo.Commands.Add(dbLogo.CreateCommand("usp_AppSetting_LIST")); dbLogo.Commands[0].Parameters.Add(new Parameter("@key", SqlDbType.VarChar, "KWKSNG")); dtLogo = dbLogo.Commands[0].ExecuteDataTable(); FileNameKWKSNG = Tools.isNull(dtLogo.Rows[0]["Value"], 0).ToString().Trim(); } DataTable dt = new DataTable(); using (Database db = new Database()) { db.Commands.Add(db.CreateCommand("usp_Detail_TelatBayar")); db.Commands[0].Parameters.Add(new Parameter("@PenjualanRowID", SqlDbType.UniqueIdentifier, _penjRowID)); dt = db.Commands[0].ExecuteDataTable(); } double _totNominal = Convert.ToDouble(dt.Rows[0]["SaldoPiutang"]); string _stotNominal = _totNominal.ToString("N0"); KWKSNG = KWKSNG + FileNameKWKSNG; if (Jenis == 2) { Nominal = 2 * Nominal; Angsuran2 = Angsuran2 + 1; } string sNominal = Nominal.ToString("N0"); string sAngsuran = Angsuran2.ToString(); List <ReportParameter> rptparam = new List <ReportParameter>(); rptparam.Add(new ReportParameter("NoTrans", NoTrans)); rptparam.Add(new ReportParameter("Nama", Nama)); rptparam.Add(new ReportParameter("Alamat", Alamat)); rptparam.Add(new ReportParameter("Kabupaten", Kabupaten)); rptparam.Add(new ReportParameter("Perusahaan", GlobalVar.PerusahaanName)); rptparam.Add(new ReportParameter("Tanggal", GlobalVar.GetServerDate.ToString("dd MMM yyyy"))); rptparam.Add(new ReportParameter("User", SecurityManager.UserName)); rptparam.Add(new ReportParameter("NoDok", NoDok)); rptparam.Add(new ReportParameter("KWKSNG", KWKSNG)); string namafile = "Laporan.rptSuratSomasi" + Jenis + ".rdlc"; if (Jenis != 3) { rptparam.Add(new ReportParameter("Nominal", sNominal)); rptparam.Add(new ReportParameter("Angsuran", Angsuran)); rptparam.Add(new ReportParameter("NominalTotal", _stotNominal)); if (Jenis == 2) { rptparam.Add(new ReportParameter("Angsuran2", sAngsuran)); } frmReportViewer frm = new frmReportViewer(namafile, rptparam, dtPerusahaan, "dsPenjualan_PT"); frm.Print(); } else { //DataTable dt = new DataTable(); //try //{ // using (Database db = new Database()) // { // db.Commands.Add(db.CreateCommand("usp_Detail_TelatBayar")); // db.Commands[0].Parameters.Add(new Parameter("@PenjualanRowID", SqlDbType.UniqueIdentifier, _penjRowID)); // dt = db.Commands[0].ExecuteDataTable(); // } //} //catch (Exception ex) //{ // Error.LogError(ex); //} //Nominal = Convert.ToDouble(dt.Rows[0]["SaldoPiutang"]); //sNominal = Nominal.ToString("N0"); sNominal = _totNominal.ToString("N0"); rptparam.Add(new ReportParameter("Nominal", sNominal)); rptparam.Add(new ReportParameter("TglAmbil", GlobalVar.DateOfServer.AddDays(7).ToString("dd MMM yyyy"))); List <DataTable> pTable = new List <DataTable>(); pTable.Add(dtPerusahaan); pTable.Add(dt); List <string> pDatasetName = new List <string>(); pDatasetName.Add("dsPenjualan_PT"); pDatasetName.Add("dsPenjualan_TelatBayarDetail"); frmReportViewer frm = new frmReportViewer(namafile, rptparam, pTable, pDatasetName); frm.Print(); } //Untuk save data ke Database, agar surat Somasi hanya bisa dicetak satu kali. SaveData(_penjRowID, TglAngsuran, Jenis); }
private void cmdBA_Click(object sender, EventArgs e) { try { if (dataGridView1.SelectedCells.Count > 0) { Guid rowID = (Guid)dataGridView1.SelectedCells[0].OwningRow.Cells["RowID"].Value; string _edp; string _bulan; string _tanggal; string _tahun; string _hari; string _copy; DateTimeFormatInfo dfi = DateTimeFormatInfo.CurrentInfo; DateTime date = GlobalVar.GetServerDate; Calendar cal = dfi.Calendar; int mingguKe = cal.GetWeekOfYear(date, dfi.CalendarWeekRule, dfi.FirstDayOfWeek); frmPrint ifrmDialog = new frmPrint(this, 2); ifrmDialog.ShowDialog(); if (ifrmDialog.DialogResult == DialogResult.Yes) { _nprint = ifrmDialog.Result; } else { return; } using (Database db = new Database()) { DataTable dt = new DataTable(); db.Commands.Add(db.CreateCommand("rpt_Kelengkapan_BA_Pembelian")); db.Commands[0].Parameters.Add(new Parameter("@RowID", SqlDbType.UniqueIdentifier, rowID)); db.Commands[0].Parameters.Add(new Parameter("@CabangID", SqlDbType.VarChar, GlobalVar.CabangID)); dt = db.Commands[0].ExecuteDataTable(); db.Commands[0].Parameters.Clear(); List <ReportParameter> rptParams = new List <ReportParameter>(); int JamBebasPIN = 0; DataTable dummyPIN = new DataTable(); using (Database dbsubPIN = new Database()) { dbsubPIN.Commands.Add(dbsubPIN.CreateCommand("usp_AppSetting_LIST")); dbsubPIN.Commands[0].Parameters.Add(new Parameter("@key", SqlDbType.VarChar, "BEBASPIN")); dummyPIN = dbsubPIN.Commands[0].ExecuteDataTable(); JamBebasPIN = Convert.ToInt32(Tools.isNull(dummyPIN.Rows[0]["Value"], 0).ToString()); } DateTime LastPrintedOn; LastPrintedOn = (DateTime)Tools.isNull(dt.Rows[0]["LastPrintedOn2"], DateTime.MaxValue); if (LastPrintedOn < GlobalVar.GetServerDateTime_RealTime && GlobalVar.GetServerDateTime_RealTime < LastPrintedOn.AddHours(JamBebasPIN)) { } else { if (int.Parse(dt.Rows[0]["Cetak2"].ToString()) > 1) { // Keuangan Tools.pin(PinId.Periode.Hari, mingguKe, date, PinId.Bagian.Accounting, Convert.ToInt32(PinId.ModulId.BeritaAcaraPembelian), "Sudah dilakukan cetak Berita Acara Serah Terima Barang !"); if (GlobalVar.pinResult == false) { return; } } } _edp = String.Format("{0:d/MM/yyyy}", dt.Rows[0]["TglBeli"]); _tanggal = GlobalVar.GetServerDate.Day.ToString(); _bulan = Tools.BulanPanjang(GlobalVar.GetServerDate.Month); _tahun = GlobalVar.GetServerDate.Year.ToString(); _hari = Tools.HariPanjang(GlobalVar.GetServerDate); if (int.Parse(dt.Rows[0]["Cetak2"].ToString()) > 1) { _copy = "Copy ke-" + (int.Parse(dt.Rows[0]["Cetak2"].ToString()) - 1).ToString(); } else { _copy = ""; } String IMG_Path = System.Reflection.Assembly.GetEntryAssembly().CodeBase.Substring(0, System.Reflection.Assembly.GetEntryAssembly().CodeBase.LastIndexOf("/") + 1); // Application.ExecutablePath.LastIndexOf("/") String FileName = ""; using (Database dbLogo = new Database()) { DataTable dtLogo = new DataTable(); dbLogo.Commands.Add(dbLogo.CreateCommand("usp_AppSetting_LIST")); dbLogo.Commands[0].Parameters.Add(new Parameter("@key", SqlDbType.VarChar, "LOGOFILE")); dtLogo = dbLogo.Commands[0].ExecuteDataTable(); FileName = Tools.isNull(dtLogo.Rows[0]["Value"], 0).ToString().Trim(); } IMG_Path = IMG_Path + FileName; rptParams.Add(new ReportParameter("IMG_Path", IMG_Path)); String IMG_PathBW = System.Reflection.Assembly.GetEntryAssembly().CodeBase.Substring(0, System.Reflection.Assembly.GetEntryAssembly().CodeBase.LastIndexOf("/") + 1); // Application.ExecutablePath.LastIndexOf("/") String FileNameBW = ""; using (Database dbLogo = new Database()) { DataTable dtLogo = new DataTable(); dbLogo.Commands.Add(dbLogo.CreateCommand("usp_AppSetting_LIST")); dbLogo.Commands[0].Parameters.Add(new Parameter("@key", SqlDbType.VarChar, "LOGOFILEBW")); dtLogo = dbLogo.Commands[0].ExecuteDataTable(); FileNameBW = Tools.isNull(dtLogo.Rows[0]["Value"], 0).ToString().Trim(); } IMG_PathBW = IMG_PathBW + FileNameBW; rptParams.Add(new ReportParameter("IMG_PathBW", IMG_PathBW)); rptParams.Add(new ReportParameter("Judul", "BERITA ACARA SERAH TERIMA BARANG".ToString())); rptParams.Add(new ReportParameter("EDP", _edp)); rptParams.Add(new ReportParameter("Tanggal", _tanggal.ToUpper())); rptParams.Add(new ReportParameter("Bulan", _bulan.ToUpper())); rptParams.Add(new ReportParameter("Tahun", _tahun.ToString())); rptParams.Add(new ReportParameter("Hari", _hari.ToString())); rptParams.Add(new ReportParameter("PenanggungJawab", GlobalVar.PenanggungJawab)); rptParams.Add(new ReportParameter("Copy", _copy.ToString())); rptParams.Add(new ReportParameter("Pembuat", SecurityManager.UserID + " " + dt.Rows[0]["idrec"].ToString() + " " + GlobalVar.GetServerDateTime_RealTime.ToString())); //GlobalVar.GetServerDateTime_RealTime.ToString() sebelumnya -> GlobalVar.GetServerDate.ToString() if ((_nprint == 0) || (_nprint == 1)) { frmReportViewer ifrmReport1 = new frmReportViewer("Pembelian.rptBA1.rdlc", rptParams, dt, "dsPembelian_Faktur"); ifrmReport1.Print(); //frmReportViewer ifrmReport2 = new frmReportViewer("Pembelian.rptBA2.rdlc", rptParams, dt, "dsPembelian_Faktur"); //ifrmReport2.Print(); } if ((_nprint == 0) || (_nprint == 2)) { frmReportViewer ifrmReport3 = new frmReportViewer("Pembelian.rptBA1.rdlc", rptParams, dt, "dsPembelian_Faktur"); ifrmReport3.Print(); //frmReportViewer ifrmReport4 = new frmReportViewer("Pembelian.rptBA2.rdlc", rptParams, dt, "dsPembelian_Faktur"); //ifrmReport4.Print(); } db.Commands.Add(db.CreateCommand("usp_Pembelian_UpdateCounterBeritaAcara")); db.Commands[1].Parameters.Add(new Parameter("@RowID", SqlDbType.UniqueIdentifier, rowID)); db.Commands[1].ExecuteNonQuery(); } } else { MessageBox.Show(Messages.Error.RowNotSelected); } } catch (Exception ex) { MessageBox.Show("Gagal dicetak !\n" + ex.Message); } }
private void cmdPRINT_Click(object sender, EventArgs e) { try { if (dataGridView1.SelectedCells.Count > 0) { Guid rowID = (Guid)dataGridView1.SelectedCells[0].OwningRow.Cells["RowID"].Value; string _edp; string _terbilang; string _kotatgl; string _kota; string _copy; DateTimeFormatInfo dfi = DateTimeFormatInfo.CurrentInfo; DateTime date = GlobalVar.GetServerDate; Calendar cal = dfi.Calendar; int mingguKe = cal.GetWeekOfYear(date, dfi.CalendarWeekRule, dfi.FirstDayOfWeek); frmPrint ifrmDialog = new frmPrint(this, 3); ifrmDialog.ShowDialog(); if (ifrmDialog.DialogResult == DialogResult.Yes) { _nprint = ifrmDialog.Result; } else { return; } using (Database db = new Database()) { DataTable dt = new DataTable(); db.Commands.Add(db.CreateCommand("rpt_Faktur_Pembelian")); db.Commands[0].Parameters.Add(new Parameter("@RowID", SqlDbType.UniqueIdentifier, rowID)); db.Commands[0].Parameters.Add(new Parameter("@CabangID", SqlDbType.VarChar, GlobalVar.CabangID)); dt = db.Commands[0].ExecuteDataTable(); db.Commands[0].Parameters.Clear(); List <ReportParameter> rptParams = new List <ReportParameter>(); int JamBebasPIN = 0; DataTable dummyPIN = new DataTable(); using (Database dbsubPIN = new Database()) { dbsubPIN.Commands.Add(dbsubPIN.CreateCommand("usp_AppSetting_LIST")); dbsubPIN.Commands[0].Parameters.Add(new Parameter("@key", SqlDbType.VarChar, "BEBASPIN")); dummyPIN = dbsubPIN.Commands[0].ExecuteDataTable(); JamBebasPIN = Convert.ToInt32(Tools.isNull(dummyPIN.Rows[0]["Value"], 0)); } DateTime LastPrintedOn; LastPrintedOn = (DateTime)Tools.isNull(dt.Rows[0]["LastPrintedOn1"], DateTime.MaxValue); if (LastPrintedOn < GlobalVar.GetServerDateTime_RealTime && GlobalVar.GetServerDateTime_RealTime < LastPrintedOn.AddHours(JamBebasPIN)) { } else { if (int.Parse(dt.Rows[0]["Cetak1"].ToString()) > 1) { // Keuangan Tools.pin(PinId.Periode.Hari, mingguKe, date, PinId.Bagian.Accounting, Convert.ToInt32(PinId.ModulId.FakturPembelian), "Sudah dilakukan cetak Faktur Pembelian !"); if (GlobalVar.pinResult == false) { return; } } } _edp = String.Format("{0:d/MM/yyyy}", dt.Rows[0]["TglBeli"]); _terbilang = Tools.Terbilang(int.Parse(dt.Rows[0]["HargaJadi"].ToString(), NumberStyles.Currency)) + "RUPIAH"; _kota = Tools.isNull(dt.Rows[0]["Kota"], "").ToString(); _kota = _kota.Replace("Kota ", ""); _kota = _kota.Replace("Kabupaten ", ""); DateTime tglBayar; if (GlobalVar.CabangID.Contains("06")) { tglBayar = GlobalVar.GetServerDate;// Convert.ToDateTime(Tools.isNull(dt.Rows[0]["TglBeli"].ToString(), GlobalVar.GetServerDate).ToString()); } else { tglBayar = GlobalVar.GetServerDate; } // _kotatgl = _kota + ", " + GlobalVar.GetServerDate.Day.ToString() + " " + Tools.BulanPanjang(GlobalVar.GetServerDate.Month) + " " + GlobalVar.GetServerDate.Year.ToString(); _kotatgl = _kota + ", " + tglBayar.Day.ToString() + " " + Tools.BulanPanjang(tglBayar.Month) + " " + tglBayar.Year.ToString(); if (int.Parse(dt.Rows[0]["Cetak1"].ToString()) > 1) { _copy = "Copy ke-" + (int.Parse(dt.Rows[0]["Cetak1"].ToString()) - 1).ToString(); } else { _copy = ""; } String IMG_Path = System.Reflection.Assembly.GetEntryAssembly().CodeBase.Substring(0, System.Reflection.Assembly.GetEntryAssembly().CodeBase.LastIndexOf("/") + 1); // Application.ExecutablePath.LastIndexOf("/") String FileName = ""; using (Database dbLogo = new Database()) { DataTable dtLogo = new DataTable(); dbLogo.Commands.Add(dbLogo.CreateCommand("usp_AppSetting_LIST")); dbLogo.Commands[0].Parameters.Add(new Parameter("@key", SqlDbType.VarChar, "LOGOFILE")); dtLogo = dbLogo.Commands[0].ExecuteDataTable(); FileName = Tools.isNull(dtLogo.Rows[0]["Value"], 0).ToString().Trim(); } IMG_Path = IMG_Path + FileName; rptParams.Add(new ReportParameter("IMG_Path", IMG_Path)); String IMG_PathBW = System.Reflection.Assembly.GetEntryAssembly().CodeBase.Substring(0, System.Reflection.Assembly.GetEntryAssembly().CodeBase.LastIndexOf("/") + 1); // Application.ExecutablePath.LastIndexOf("/") String FileNameBW = ""; using (Database dbLogo = new Database()) { DataTable dtLogo = new DataTable(); dbLogo.Commands.Add(dbLogo.CreateCommand("usp_AppSetting_LIST")); dbLogo.Commands[0].Parameters.Add(new Parameter("@key", SqlDbType.VarChar, "LOGOFILEBW")); dtLogo = dbLogo.Commands[0].ExecuteDataTable(); FileNameBW = Tools.isNull(dtLogo.Rows[0]["Value"], 0).ToString().Trim(); } IMG_PathBW = IMG_PathBW + FileNameBW; if (GlobalVar.CabangID == "06A") { IMG_PathBW = ""; } rptParams.Add(new ReportParameter("IMG_PathBW", IMG_PathBW)); rptParams.Add(new ReportParameter("Judul", "FAKTUR PEMBELIAN".ToString())); rptParams.Add(new ReportParameter("EDP", _edp)); rptParams.Add(new ReportParameter("Terbilang", _terbilang.ToUpper())); rptParams.Add(new ReportParameter("KotaTgl", _kotatgl.ToUpper())); rptParams.Add(new ReportParameter("Copy", _copy.ToString())); rptParams.Add(new ReportParameter("Pembuat", SecurityManager.UserID + " " + dt.Rows[0]["idrec"].ToString() + " " + GlobalVar.GetServerDateTime_RealTime.ToString())); //GlobalVar.GetServerDateTime_RealTime.ToString() sebelumnya -> GlobalVar.GetServerDate.ToString() if ((_nprint == 0) || (_nprint == 1)) { frmReportViewer ifrmReport = new frmReportViewer("Pembelian.rptFaktur.rdlc", rptParams, dt, "dsPembelian_Faktur"); ifrmReport.Print(); } if ((_nprint == 0) || (_nprint == 2)) { frmReportViewer ifrmReport2 = new frmReportViewer("Pembelian.rptFakturCopy1.rdlc", rptParams, dt, "dsPembelian_Faktur"); ifrmReport2.Print(); } if ((_nprint == 0) || (_nprint == 3)) { frmReportViewer ifrmReport3 = new frmReportViewer("Pembelian.rptFakturCopy2.rdlc", rptParams, dt, "dsPembelian_Faktur"); ifrmReport3.Print(); } cmdEDIT.Enabled = false; cmdDELETE.Enabled = false; db.Commands.Add(db.CreateCommand("usp_Pembelian_UpdateCounterFaktur")); db.Commands[1].Parameters.Add(new Parameter("@RowID", SqlDbType.UniqueIdentifier, rowID)); db.Commands[1].ExecuteNonQuery(); } } else { MessageBox.Show(Messages.Error.RowNotSelected); } } catch (Exception ex) { MessageBox.Show("Gagal dicetak !\n" + ex.Message); } }
private void CetakFormOrder_Inkjet() { try { this.Cursor = Cursors.WaitCursor; dtForm = new DataTable(); using (Database db = new Database()) { db.Commands.Add(db.CreateCommand("usp_createFormData_LIST")); dtForm = db.Commands[0].ExecuteDataTable(); } } catch (Exception ex) { Error.LogError(ex); } finally { this.Cursor = Cursors.Default; } double Total = 0; double TotalDisc = 0; string _no = "", numeratorDoc = "NOMOR_ORDER_BKL", depan = "", belakang = ""; int iNomor = 0, lebar = 0; try { depan = "D" + GlobalVar.Gudang.Trim().Substring(2, 2); dtNum = Tools.GetGeneralNumerator(numeratorDoc, depan); if (dtNum.Rows.Count > 0) { lebar = int.Parse(dtNum.Rows[0]["Lebar"].ToString()); belakang = dtNum.Rows[0]["Belakang"].ToString(); iNomor = int.Parse(dtNum.Rows[0]["Nomor"].ToString()); iNomor++; _no = Tools.FormatNumerator(iNomor, lebar, depan, belakang); } else { lebar = 4; belakang = ""; iNomor = 0; iNomor++; _no = Tools.FormatNumerator(iNomor, lebar, depan, belakang); } } catch (Exception ex) { Error.LogError(ex); } finally { this.Cursor = Cursors.Default; } string Nomor = _no; string Tanggal = GlobalVar.DateOfServer.ToString("dd-MMM-yyyy"); string UserID = SecurityManager.UserName.ToString(); List <ReportParameter> rptParams = new List <ReportParameter>(); rptParams.Add(new ReportParameter("UserID", UserID)); rptParams.Add(new ReportParameter("Nomor", Nomor)); rptParams.Add(new ReportParameter("Tanggal", Tanggal)); int nPrint = 0; nPrint = int.Parse(Tools.isNull(PrnAktif, "0").ToString()); for (int i = 1; i <= nPrint; i++) { if (i == 1) { frmReportViewer ifrmReport = new frmReportViewer("Laporan.rptCetakFormOrder.rdlc", rptParams, dtForm, "dsCetakNotaBengkel_Data"); ifrmReport.Print(); //ifrmReport.Print(8.5, 6.4); //ifrmReport.Show(); } if (i == 2) { frmReportViewer ifrmReport = new frmReportViewer("Laporan.rptCetakFormOrder_copy1.rdlc", rptParams, dtForm, "dsCetakNotaBengkel_Data"); ifrmReport.Print(); //ifrmReport.Print(8.5, 6.4); //ifrmReport.Show(); } if (i > 2) { frmReportViewer ifrmReport = new frmReportViewer("Laporan.rptCetakFormOrder_copy2.rdlc", rptParams, dtForm, "dsCetakNotaBengkel_Data"); ifrmReport.Print(); //ifrmReport.Print(8.5, 6.4); //ifrmReport.Show(); } } if (dtNum.Rows.Count > 0) { try { this.Cursor = Cursors.WaitCursor; DataTable dt = new DataTable(); using (Database db = new Database()) { db.Commands.Add(db.CreateCommand("usp_Numerator_UPDATE")); db.Commands[0].Parameters.Add(new Parameter("@doc", SqlDbType.VarChar, numeratorDoc)); db.Commands[0].Parameters.Add(new Parameter("@depan", SqlDbType.VarChar, depan)); db.Commands[0].Parameters.Add(new Parameter("@belakang", SqlDbType.VarChar, belakang)); db.Commands[0].Parameters.Add(new Parameter("@nomor", SqlDbType.Int, iNomor)); db.Commands[0].Parameters.Add(new Parameter("@lebar", SqlDbType.VarChar, lebar)); db.Commands[0].Parameters.Add(new Parameter("@lastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID)); db.BeginTransaction(); db.Commands[0].ExecuteNonQuery(); db.CommitTransaction(); } } catch (Exception ex) { Error.LogError(ex); } finally { this.Cursor = Cursors.Default; } } else { try { this.Cursor = Cursors.WaitCursor; DataTable dt = new DataTable(); using (Database db = new Database()) { MessageBox.Show(numeratorDoc); db.Commands.Add(db.CreateCommand("usp_bkl_numerator_INSERT")); db.Commands[0].Parameters.Add(new Parameter("@doc", SqlDbType.VarChar, numeratorDoc)); db.Commands[0].Parameters.Add(new Parameter("@depan", SqlDbType.VarChar, depan)); db.Commands[0].Parameters.Add(new Parameter("@belakang", SqlDbType.VarChar, belakang)); db.Commands[0].Parameters.Add(new Parameter("@nomor", SqlDbType.Int, iNomor)); db.Commands[0].Parameters.Add(new Parameter("@lebar", SqlDbType.VarChar, lebar)); db.Commands[0].Parameters.Add(new Parameter("@lastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID)); db.BeginTransaction(); db.Commands[0].ExecuteNonQuery(); db.CommitTransaction(); } } catch (Exception ex) { Error.LogError(ex); } finally { this.Cursor = Cursors.Default; } } }
private void cmdPRINTKW_Click(object sender, EventArgs e) { try { if (gvDaftarTitipan.SelectedCells.Count > 0) { Guid rowID = (Guid)gvDaftarTitipan.SelectedCells[0].OwningRow.Cells["RowID"].Value; string _edp; string _terbilang; string _kotatgl; string _kota; string _copy; int _nprint; DateTimeFormatInfo dfi = DateTimeFormatInfo.CurrentInfo; DateTime date = GlobalVar.GetServerDate; Calendar cal = dfi.Calendar; int mingguKe = cal.GetWeekOfYear(date, dfi.CalendarWeekRule, dfi.FirstDayOfWeek); frmPrint ifrmDialog = new frmPrint(this, 3); ifrmDialog.ShowDialog(); if (ifrmDialog.DialogResult == DialogResult.Yes) { _nprint = ifrmDialog.Result; } else { return; } using (Database db = new Database()) { DataTable dt = new DataTable(); db.Commands.Add(db.CreateCommand("rpt_Kwitansi_PenerimaanTitipan")); db.Commands[0].Parameters.Add(new Parameter("@RowID", SqlDbType.UniqueIdentifier, rowID)); db.Commands[0].Parameters.Add(new Parameter("@CabangID", SqlDbType.VarChar, GlobalVar.CabangID)); dt = db.Commands[0].ExecuteDataTable(); List <ReportParameter> rptParams = new List <ReportParameter>(); int JamBebasPIN = 0; DataTable dummyPIN = new DataTable(); using (Database dbsubPIN = new Database()) { dbsubPIN.Commands.Add(dbsubPIN.CreateCommand("usp_AppSetting_LIST")); dbsubPIN.Commands[0].Parameters.Add(new Parameter("@key", SqlDbType.VarChar, "BEBASPIN")); dummyPIN = dbsubPIN.Commands[0].ExecuteDataTable(); JamBebasPIN = Convert.ToInt32(Tools.isNull(dummyPIN.Rows[0]["Value"], 0).ToString()); } DateTime LastPrintedOn; LastPrintedOn = (DateTime)Tools.isNull(dt.Rows[0]["LastPrintedOn"], DateTime.MaxValue); if (LastPrintedOn < GlobalVar.GetServerDateTime_RealTime && GlobalVar.GetServerDateTime_RealTime < LastPrintedOn.AddHours(JamBebasPIN)) { } else { if ((bool)dt.Rows[0]["Cetak"] == true) { // sebelumnya PinId.Bagian.Keuangan Tools.pin(PinId.Periode.Hari, mingguKe, date, PinId.Bagian.Piutang, Convert.ToInt32(PinId.ModulId.KwitansiPenjualan), "Sudah dilakukan cetak Kwitansi Penjualan !"); if (GlobalVar.pinResult == false) { return; } } } _edp = String.Format("{0:d/MM/yyyy}", dt.Rows[0]["Tanggal"]); _terbilang = Tools.Terbilang(int.Parse(dt.Rows[0]["Nominal"].ToString(), NumberStyles.Currency)) + "RUPIAH"; _kota = Tools.isNull(dt.Rows[0]["Kota"], "").ToString(); _kota = _kota.Replace("Kota ", ""); _kota = _kota.Replace("Kabupaten ", ""); DateTime tglBayar; tglBayar = Convert.ToDateTime(Tools.isNull(dt.Rows[0]["Tanggal"].ToString(), GlobalVar.GetServerDate).ToString()); // _kotatgl = _kota + ", " + GlobalVar.GetServerDate.Day.ToString() + " " + Tools.BulanPanjang(GlobalVar.GetServerDate.Month) + " " + GlobalVar.GetServerDate.Year.ToString(); _kotatgl = _kota + ", " + tglBayar.Day.ToString() + " " + Tools.BulanPanjang(tglBayar.Month) + " " + tglBayar.Year.ToString(); if ((bool)dt.Rows[0]["Cetak"] == true) { if (int.Parse(dt.Rows[0]["nPrint"].ToString()) > 0) { _copy = "Copy ke-" + dt.Rows[0]["nPrint"].ToString(); } else { _copy = ""; } } else { _copy = ""; } String IMG_Path = System.Reflection.Assembly.GetEntryAssembly().CodeBase.Substring(0, System.Reflection.Assembly.GetEntryAssembly().CodeBase.LastIndexOf("/") + 1); // Application.ExecutablePath.LastIndexOf("/") String FileName = ""; using (Database dbLogo = new Database()) { DataTable dtLogo = new DataTable(); dbLogo.Commands.Add(dbLogo.CreateCommand("usp_AppSetting_LIST")); dbLogo.Commands[0].Parameters.Add(new Parameter("@key", SqlDbType.VarChar, "LOGOFILE")); dtLogo = dbLogo.Commands[0].ExecuteDataTable(); FileName = Tools.isNull(dtLogo.Rows[0]["Value"], 0).ToString().Trim(); } IMG_Path = IMG_Path + FileName; rptParams.Add(new ReportParameter("IMG_Path", IMG_Path)); String IMG_PathBW = System.Reflection.Assembly.GetEntryAssembly().CodeBase.Substring(0, System.Reflection.Assembly.GetEntryAssembly().CodeBase.LastIndexOf("/") + 1); // Application.ExecutablePath.LastIndexOf("/") String FileNameBW = ""; using (Database dbLogo = new Database()) { DataTable dtLogo = new DataTable(); dbLogo.Commands.Add(dbLogo.CreateCommand("usp_AppSetting_LIST")); dbLogo.Commands[0].Parameters.Add(new Parameter("@key", SqlDbType.VarChar, "LOGOFILEBW")); dtLogo = dbLogo.Commands[0].ExecuteDataTable(); FileNameBW = Tools.isNull(dtLogo.Rows[0]["Value"], 0).ToString().Trim(); } IMG_PathBW = IMG_PathBW + FileNameBW; rptParams.Add(new ReportParameter("IMG_PathBW", IMG_PathBW)); // nominal di paling atas yg Administrasi rptParams.Add(new ReportParameter("NominalAtas", Convert.ToDouble(dt.Rows[0]["Nominal"]).ToString())); rptParams.Add(new ReportParameter("JnsKw", "Bukti Penitipan")); rptParams.Add(new ReportParameter("TipeKw", "KWITANSI")); rptParams.Add(new ReportParameter("EDP", "Tahun : " + dt.Rows[0]["Tahun"].ToString() + ", Warna : " + dt.Rows[0]["Warna"].ToString() + ", Nopol : " + dt.Rows[0]["Nopol"].ToString() + ", No. BPKB : " + dt.Rows[0]["NoBPKB"].ToString())); rptParams.Add(new ReportParameter("Terbilang", _terbilang.ToUpper())); rptParams.Add(new ReportParameter("KotaTgl", _kotatgl.ToUpper())); rptParams.Add(new ReportParameter("Copy", _copy.ToString())); rptParams.Add(new ReportParameter("Pembuat", SecurityManager.UserID + " " + dt.Rows[0]["idrec"].ToString() + " " + GlobalVar.GetServerDateTime_RealTime.ToString())); //GlobalVar.GetServerDateTime_RealTime.ToString() sebelumnya -> GlobalVar.GetServerDate.ToString() // tambahan untuk kwitansi rptParams.Add(new ReportParameter("Admin", SecurityManager.UserName.ToString())); rptParams.Add(new ReportParameter("CabangID", GlobalVar.CabangID.Substring(0, 2))); rptParams.Add(new ReportParameter("Tipe", "TTP")); if ((_nprint == 0) || (_nprint == 1)) { frmReportViewer ifrmReport = new frmReportViewer("Penjualan.rptKwitansi.rdlc", rptParams, dt, "dsPenjualan_Kwitansi"); ifrmReport.Print(); } if ((_nprint == 0) || (_nprint == 2)) { frmReportViewer ifrmReport = new frmReportViewer("Penjualan.rptKwitansiCopy1.rdlc", rptParams, dt, "dsPenjualan_Kwitansi"); ifrmReport.Print(); } if ((_nprint == 0) || (_nprint == 3)) { frmReportViewer ifrmReport = new frmReportViewer("Penjualan.rptKwitansiCopy2.rdlc", rptParams, dt, "dsPenjualan_Kwitansi"); ifrmReport.Print(); } //cmdEditTitipan.Enabled = false; //cmdDelete.Enabled = false; } } else { MessageBox.Show(Messages.Error.RowNotSelected); } } catch (Exception ex) { MessageBox.Show("Gagal dicetak !\n" + ex.Message); } }
private void CetakKwintasnsi(Guid RowiD_) { if (dataGridView1.SelectedCells.Count > 0 && dataGridView2.RowCount > 0) { // HeaderID itu RowID nya Penjualan Guid HeaderID_ = (Guid)dataGridView1.SelectedCells[0].OwningRow.Cells["RowID"].Value; Guid PenjHistRowID = (Guid) new Guid(Tools.isNull(dataGridView1.SelectedCells[0].OwningRow.Cells["PenjHistRowID"].Value, Guid.Empty).ToString()); // cek, kalau udah lunas, ngga usah print lagi... tapi mestinya klo ada overdue itu karena udah lunas kan...? using (Database db = new Database()) { DataTable dummysub = new DataTable(); db.Commands.Add(db.CreateCommand("usp_Penjualan_CHECK_Lunas")); db.Commands[0].Parameters.Add(new Parameter("@PenjRowID", SqlDbType.UniqueIdentifier, HeaderID_)); db.Commands[0].Parameters.Add(new Parameter("@PenjHistRowID", SqlDbType.UniqueIdentifier, PenjHistRowID)); dummysub = db.Commands[0].ExecuteDataTable(); if (dummysub.Rows.Count > 0) { string tempdata = dummysub.Rows[0]["StatusLunas"].ToString(); if (tempdata == "LUNAS") { MessageBox.Show("Data Penjualan ini sudah Lunas, tidak perlu surat tagihan lagi!"); return; } } } } try { Guid rowID = RowiD_; string _edp, _terbilang, _kotatgl, _kota, _copy, _uraian; int _nprint; DateTimeFormatInfo dfi = DateTimeFormatInfo.CurrentInfo; DateTime date = GlobalVar.GetServerDate; Calendar cal = dfi.Calendar; int mingguKe = cal.GetWeekOfYear(date, dfi.CalendarWeekRule, dfi.FirstDayOfWeek); String NoKwitansi = ""; using (Database db = new Database()) { DataTable dt = new DataTable(); if ((_kodeTransPJL == "TUN" || _kodeTransPJL == "CTP" || _kodeTransPJL == "FLT")) { db.Commands.Add(db.CreateCommand("[rpt_KwitansiKosong_Tagihan]")); } else { db.Commands.Add(db.CreateCommand("[rpt_Kwitansi_Kosong]")); } db.Commands[0].Parameters.Add(new Parameter("@PenjualanRowID", SqlDbType.UniqueIdentifier, rowID)); dt = db.Commands[0].ExecuteDataTable(); if (dt.Rows.Count > 0 && (_kodeTransPJL == "TUN" || _kodeTransPJL == "CTP" || _kodeTransPJL == "FLT")) { dt.Rows[0]["Nominal"] = Convert.ToInt32(Tools.isNull(txtNominal.GetDoubleValue, 0)); NoKwitansi = "K" + Numerator.NextNumber("NKJ"); dt.Rows[0]["NoTrans"] = NoKwitansi; Double Selisih = txtSisaUM.GetDoubleValue - txtNominal.GetDoubleValue; if (Selisih > 0) { dt.Rows[0]["Uraian3"] = "Sisa : " + Selisih.ToString("N0") + " - Ket.: " + txtUraian.Text.Trim(); } else { } } List <ReportParameter> rptParams = new List <ReportParameter>(); _edp = String.Format("{0:d/MM/yyyy}", dt.Rows[0]["Tanggal"]); if (dt.Rows.Count > 0 && (_kodeTransPJL == "TUN" || _kodeTransPJL == "CTP" || _kodeTransPJL == "FLT")) { rptParams.Add(new ReportParameter("NominalAtas", Convert.ToDouble(dt.Rows[0]["Nominal"]).ToString())); _terbilang = Tools.Terbilang(int.Parse(dt.Rows[0]["Nominal"].ToString(), NumberStyles.Currency)) + "RUPIAH"; } else { _terbilang = ""; } _kota = Tools.isNull(dt.Rows[0]["Kota"], "").ToString(); _kota = _kota.Replace("Kota ", ""); _kota = _kota.Replace("Kabupaten ", ""); DateTime tglBayar; tglBayar = Convert.ToDateTime(Tools.isNull(dt.Rows[0]["Tanggal"].ToString(), GlobalVar.GetServerDate).ToString()); // _kotatgl = _kota + ", " + GlobalVar.GetServerDate.Day.ToString() + " " + Tools.BulanPanjang(GlobalVar.GetServerDate.Month) + " " + GlobalVar.GetServerDate.Year.ToString(); // _kotatgl = _kota + ", " + tglBayar.Day.ToString() + " " + Tools.BulanPanjang(tglBayar.Month) + " " + tglBayar.Year.ToString(); _kotatgl = _kota + ", ............................"; _copy = ""; String IMG_Path = System.Reflection.Assembly.GetEntryAssembly().CodeBase.Substring(0, System.Reflection.Assembly.GetEntryAssembly().CodeBase.LastIndexOf("/") + 1); // Application.ExecutablePath.LastIndexOf("/") String FileName = ""; using (Database dbLogo = new Database()) { DataTable dtLogo = new DataTable(); dbLogo.Commands.Add(dbLogo.CreateCommand("usp_AppSetting_LIST")); dbLogo.Commands[0].Parameters.Add(new Parameter("@key", SqlDbType.VarChar, "LOGOFILE")); dtLogo = dbLogo.Commands[0].ExecuteDataTable(); FileName = Tools.isNull(dtLogo.Rows[0]["Value"], 0).ToString().Trim(); } IMG_Path = IMG_Path + FileName; rptParams.Add(new ReportParameter("IMG_Path", IMG_Path)); String IMG_PathBW = System.Reflection.Assembly.GetEntryAssembly().CodeBase.Substring(0, System.Reflection.Assembly.GetEntryAssembly().CodeBase.LastIndexOf("/") + 1); // Application.ExecutablePath.LastIndexOf("/") String FileNameBW = ""; using (Database dbLogo = new Database()) { DataTable dtLogo = new DataTable(); dbLogo.Commands.Add(dbLogo.CreateCommand("usp_AppSetting_LIST")); dbLogo.Commands[0].Parameters.Add(new Parameter("@key", SqlDbType.VarChar, "LOGOFILEBW")); dtLogo = dbLogo.Commands[0].ExecuteDataTable(); FileNameBW = Tools.isNull(dtLogo.Rows[0]["Value"], 0).ToString().Trim(); } IMG_PathBW = IMG_PathBW + FileNameBW; rptParams.Add(new ReportParameter("IMG_PathBW", IMG_PathBW)); if (dt.Rows.Count > 0 && (_kodeTransPJL == "TUN" || _kodeTransPJL == "CTP" || _kodeTransPJL == "FLT")) { rptParams.Add(new ReportParameter("JnsKw", "UANG MUKA" /*Tools.isNull(dt.Rows[0]["Uraian"], "").ToString()*/)); } else { rptParams.Add(new ReportParameter("JnsKw", "" /*Tools.isNull(dt.Rows[0]["Uraian"], "").ToString()*/)); } rptParams.Add(new ReportParameter("TipeKw", "KWITANSI")); rptParams.Add(new ReportParameter("EDP", "Tahun : " + dt.Rows[0]["Tahun"].ToString() + ", Warna : " + dt.Rows[0]["Warna"].ToString() + ", Nopol : " + dt.Rows[0]["Nopol"].ToString() + ", No. BPKB : " + dt.Rows[0]["NoBPKB"].ToString())); rptParams.Add(new ReportParameter("Terbilang", _terbilang.ToUpper())); rptParams.Add(new ReportParameter("KotaTgl", _kotatgl.ToUpper())); rptParams.Add(new ReportParameter("Copy", _copy.ToString())); rptParams.Add(new ReportParameter("Pembuat", SecurityManager.UserID + " " + dt.Rows[0]["idrec"].ToString() + " " + GlobalVar.GetServerDateTime_RealTime.ToString())); //GlobalVar.GetServerDateTime_RealTime.ToString() sebelumnya -> GlobalVar.GetServerDate.ToString() // tambahan untuk kwitansi rptParams.Add(new ReportParameter("Admin", SecurityManager.UserName.ToString())); rptParams.Add(new ReportParameter("CabangID", GlobalVar.CabangID.Substring(0, 2))); if (dt.Rows.Count > 0 && (_kodeTransPJL == "TUN" || _kodeTransPJL == "CTP" || _kodeTransPJL == "FLT")) { rptParams.Add(new ReportParameter("Tipe", "FIRST")); } else { rptParams.Add(new ReportParameter("Tipe", "KSG")); } frmPrint ifrmDialog = new frmPrint(this, 3); ifrmDialog.ShowDialog(); if (ifrmDialog.DialogResult == DialogResult.Yes) { _nprint = ifrmDialog.Result; } else { return; } if ((_nprint == 0) || (_nprint == 1)) { frmReportViewer ifrmReport = new frmReportViewer("Penjualan.rptKwitansi.rdlc", rptParams, dt, "dsPenjualan_Kwitansi"); ifrmReport.Print(); } if (_kodeTransPJL == "TUN" || _kodeTransPJL == "CTP" || _kodeTransPJL == "FLT") { if ((_nprint == 0) || (_nprint == 2)) { frmReportViewer ifrmReport = new frmReportViewer("Penjualan.rptKwitansiCopy1.rdlc", rptParams, dt, "dsPenjualan_Kwitansi"); ifrmReport.Print(); } if ((_nprint == 0) || (_nprint == 3)) { frmReportViewer ifrmReport = new frmReportViewer("Penjualan.rptKwitansiCopy2.rdlc", rptParams, dt, "dsPenjualan_Kwitansi"); ifrmReport.Print(); } } if (dt.Rows.Count > 0 && (_kodeTransPJL == "TUN" || _kodeTransPJL == "CTP" || _kodeTransPJL == "FLT")) { // masukkin detail kwitansi kosongnya ke database using (Database dbsub = new Database()) { dbsub.Commands.Add(dbsub.CreateCommand("usp_KwitansiKosong_INSERT")); dbsub.Commands[0].Parameters.Add(new Parameter("@NoKwitansi", SqlDbType.VarChar, NoKwitansi)); dbsub.Commands[0].Parameters.Add(new Parameter("@PenjRowID", SqlDbType.UniqueIdentifier, rowID)); dbsub.Commands[0].Parameters.Add(new Parameter("@Nominal", SqlDbType.Money, txtNominal.GetDoubleValue)); dbsub.Commands[0].Parameters.Add(new Parameter("@Uraian", SqlDbType.VarChar, txtUraian.Text.Trim())); dbsub.Commands[0].Parameters.Add(new Parameter("@Tanggal", SqlDbType.VarChar, GlobalVar.GetServerDate)); dbsub.Commands[0].Parameters.Add(new Parameter("@LastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID)); dbsub.Commands[0].ExecuteNonQuery(); } } } } catch (Exception ex) { MessageBox.Show("Gagal dicetak !\n" + ex.Message); } }
private void DisplayReport(DataSet ds, Guid RowiD_) { string periode; periode = String.Format("{0} ", GlobalVar.GetServerDate.ToString("dd-MM-yyyy")); string TglJual_; TglJual_ = String.Format("{0} ", Convert.ToDateTime(ds.Tables[1].Rows[0]["TglJual"]).ToString("dd-MMM-yyyy")); //construct parameter List <ReportParameter> rptParams = new List <ReportParameter>(); int _nprint; String IMG_Path = System.Reflection.Assembly.GetEntryAssembly().CodeBase.Substring(0, System.Reflection.Assembly.GetEntryAssembly().CodeBase.LastIndexOf("/") + 1); // Application.ExecutablePath.LastIndexOf("/") String FileName = ""; using (Database dbLogo = new Database()) { DataTable dtLogo = new DataTable(); dbLogo.Commands.Add(dbLogo.CreateCommand("usp_AppSetting_LIST")); dbLogo.Commands[0].Parameters.Add(new Parameter("@key", SqlDbType.VarChar, "WMF4ASLI")); dtLogo = dbLogo.Commands[0].ExecuteDataTable(); FileName = Tools.isNull(dtLogo.Rows[0]["Value"], 0).ToString().Trim(); } IMG_Path = IMG_Path + FileName; rptParams.Add(new ReportParameter("IMG_Path", IMG_Path)); String IMG_PathCOPY = System.Reflection.Assembly.GetEntryAssembly().CodeBase.Substring(0, System.Reflection.Assembly.GetEntryAssembly().CodeBase.LastIndexOf("/") + 1); // Application.ExecutablePath.LastIndexOf("/") String FileNameCOPY = ""; using (Database dbLogo = new Database()) { DataTable dtLogo = new DataTable(); dbLogo.Commands.Add(dbLogo.CreateCommand("usp_AppSetting_LIST")); dbLogo.Commands[0].Parameters.Add(new Parameter("@key", SqlDbType.VarChar, "WMF4COPY")); dtLogo = dbLogo.Commands[0].ExecuteDataTable(); FileNameCOPY = Tools.isNull(dtLogo.Rows[0]["Value"], 0).ToString().Trim(); } IMG_PathCOPY = IMG_PathCOPY + FileNameCOPY; rptParams.Add(new ReportParameter("IMG_PathCopy", IMG_PathCOPY)); String IMG_PathBW = System.Reflection.Assembly.GetEntryAssembly().CodeBase.Substring(0, System.Reflection.Assembly.GetEntryAssembly().CodeBase.LastIndexOf("/") + 1); // Application.ExecutablePath.LastIndexOf("/") String FileNameBW = ""; using (Database dbLogo = new Database()) { DataTable dtLogo = new DataTable(); dbLogo.Commands.Add(dbLogo.CreateCommand("usp_AppSetting_LIST")); dbLogo.Commands[0].Parameters.Add(new Parameter("@key", SqlDbType.VarChar, "LOGOFILEBW")); dtLogo = dbLogo.Commands[0].ExecuteDataTable(); FileNameBW = Tools.isNull(dtLogo.Rows[0]["Value"], 0).ToString().Trim(); } IMG_PathBW = IMG_PathBW + FileNameBW; string IPserver = ISA.DAL.Database.Host; if (IPserver == "172.16.61.253") { rptParams.Add(new ReportParameter("IMG_PathBW", IMG_PathBW)); } else { rptParams.Add(new ReportParameter("IMG_PathBW", "")); } String KWKSNG = System.Reflection.Assembly.GetEntryAssembly().CodeBase.Substring(0, System.Reflection.Assembly.GetEntryAssembly().CodeBase.LastIndexOf("/") + 1); // Application.ExecutablePath.LastIndexOf("/") String FileNameKWKSNG = ""; using (Database dbLogo = new Database()) { DataTable dtLogo = new DataTable(); dbLogo.Commands.Add(dbLogo.CreateCommand("usp_AppSetting_LIST")); dbLogo.Commands[0].Parameters.Add(new Parameter("@key", SqlDbType.VarChar, "KWKSNG")); dtLogo = dbLogo.Commands[0].ExecuteDataTable(); FileNameKWKSNG = Tools.isNull(dtLogo.Rows[0]["Value"], 0).ToString().Trim(); } KWKSNG = KWKSNG + FileNameKWKSNG; rptParams.Add(new ReportParameter("KWKSNG", KWKSNG)); rptParams.Add(new ReportParameter("Tgl", periode)); rptParams.Add(new ReportParameter("TglJual", TglJual_)); String NoDok = Numerator.NextNumber("NST"); rptParams.Add(new ReportParameter("NoDok", NoDok)); List <DataTable> pTable = new List <DataTable>(); pTable.Add(ds.Tables[0]); pTable.Add(ds.Tables[1]); pTable.Add(ds.Tables[2]); List <string> pDatasetName = new List <string>(); if (_JnsPenjualan.ToUpper().Contains("TUNAI")) { pDatasetName.Add("dsPenjualan_TagihanTunai"); } else { pDatasetName.Add("dsPenjualan_Tagihan"); } pDatasetName.Add("dsPenjualan_Faktur"); pDatasetName.Add("dsPenjualan_PT"); //call report viewer frmPrint ifrmDialog = new frmPrint(this, 2); ifrmDialog.ShowDialog(); if (ifrmDialog.DialogResult == DialogResult.Yes) { _nprint = ifrmDialog.Result; } else { return; } if (_JnsPenjualan.ToUpper().Contains("TUNAI")) { if ((_nprint == 0) || (_nprint == 1)) { frmReportViewer ifrmReport = new frmReportViewer("Laporan.rptTagihanTunai.rdlc", rptParams, pTable, pDatasetName); //ifrmReport.Text = "Penjualan Bruto"; ifrmReport.Print(); // ifrmReport.Show(); } if ((_nprint == 0) || (_nprint == 2)) { frmReportViewer ifrmReportCOPY = new frmReportViewer("Laporan.rptTagihanTunaiCopy1.rdlc", rptParams, pTable, pDatasetName); ifrmReportCOPY.Print(); } } else if (_JnsPenjualan.ToUpper().Contains("FLT"))// if(GlobalVar.CabangID.Contains("06A")) { rptParams.Add(new ReportParameter("TotAngsuran", TotAngsuran(pTable[0]).ToString())); rptParams.Add(new ReportParameter("TotDenda", TotDenda(pTable[0]).ToString())); if ((_nprint == 0) || (_nprint == 1)) { // RptTagihan , RptTagihanCopy1 frmReportViewer ifrmReport = new frmReportViewer("Laporan.RptTagihanTLA_FLT.rdlc", rptParams, pTable, pDatasetName); //ifrmReport.Text = "Penjualan Bruto"; ifrmReport.Print(); // ifrmReport.Show(); } if ((_nprint == 0) || (_nprint == 2)) { frmReportViewer ifrmReportCOPY = new frmReportViewer("Laporan.RptTagihanTLACopy1_FLT.rdlc", rptParams, pTable, pDatasetName); ifrmReportCOPY.Print(); } } else // if(GlobalVar.CabangID.Contains("06A")) { if ((_nprint == 0) || (_nprint == 1)) { // RptTagihan , RptTagihanCopy1 frmReportViewer ifrmReport = new frmReportViewer("Laporan.RptTagihanTLA.rdlc", rptParams, pTable, pDatasetName); //ifrmReport.Text = "Penjualan Bruto"; ifrmReport.Print(); // ifrmReport.Show(); } if ((_nprint == 0) || (_nprint == 2)) { frmReportViewer ifrmReportCOPY = new frmReportViewer("Laporan.RptTagihanTLACopy1.rdlc", rptParams, pTable, pDatasetName); ifrmReportCOPY.Print(); } }/* * else * { * if ((_nprint == 0) || (_nprint == 1)) * { * frmReportViewer ifrmReport = new frmReportViewer("Laporan.RptTagihan.rdlc", rptParams, pTable, pDatasetName); * //ifrmReport.Text = "Penjualan Bruto"; * ifrmReport.Print(); * // ifrmReport.Show(); * } * else if ((_nprint == 0) || (_nprint == 2)) * { * frmReportViewer ifrmReportCOPY = new frmReportViewer("Laporan.RptTagihanCopy1.rdlc", rptParams, pTable, pDatasetName); * ifrmReportCOPY.Print(); * } * }*/ /* * if (GlobalVar.CabangID.Contains("06")) * { * } * else * { * CetakKwintasnsi(RowiD_); * } */ using (Database dbST = new Database()) { dbST.Commands.Add(dbST.CreateCommand("usp_SuratTagihanLog_INSERT")); dbST.Commands[0].Parameters.Add(new Parameter("@RowID", SqlDbType.UniqueIdentifier, Guid.NewGuid())); dbST.Commands[0].Parameters.Add(new Parameter("@PenjualanRowID", SqlDbType.UniqueIdentifier, RowiD_)); dbST.Commands[0].Parameters.Add(new Parameter("@NoDok", SqlDbType.VarChar, NoDok)); dbST.Commands[0].Parameters.Add(new Parameter("@TglCetak", SqlDbType.Date, GlobalVar.GetServerDate.Date)); dbST.Commands[0].Parameters.Add(new Parameter("@NominalDenda", SqlDbType.Money, ds.Tables[0].Compute("SUM(SaldoDenda)", ""))); dbST.Commands[0].Parameters.Add(new Parameter("@isProcessed", SqlDbType.TinyInt, 0)); dbST.Commands[0].Parameters.Add(new Parameter("@SyncFlag", SqlDbType.Bit, false)); dbST.Commands[0].Parameters.Add(new Parameter("@CreatedBy", SqlDbType.VarChar, SecurityManager.UserID)); dbST.Commands[0].Parameters.Add(new Parameter("@LastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID)); dbST.Commands[0].ExecuteNonQuery(); } }
private void DisplayReport(DataTable dt) { string Nomor = TBNoKasbon.Text.ToString(); string Tanggal = String.Format("{0:dd-MMM-yyyy}", tbTanggal.DateValue); string Nama = tbNamaPegawai.Text.ToString(); string Divisi = tbDivisi.Text.ToString(); string Keperluan = tbKeperluan.Text.ToString(); string NoBkk = txtNoBkk.Text.ToString(); string RpBkk = txtRpBkk.Text.ToString().Trim(); string JmlBkk = txtRpTotal.Text.ToString().Trim(); string Jv = txtJv.Text.ToString(); string RpJv = txtRpJv.Text.ToString(); string LebihKurang = txtRpLbhKrng.Text.ToString(); string Kurang = txtBkk3.Text.ToString(); string RpKurang = txtRpBkk3.Text.ToString().Trim(); string Trk = txtTrk3.Text.ToString(); string RpTrk = txtRpTrk3.Text.ToString().Trim(); string JmlKrg = (Convert.ToDouble(txtRpTrk3.Text.ToString()) + Convert.ToDouble(txtRpBkk3.Text.ToString())).ToString(); string Lebih = txtBkm3.Text.ToString(); string RpLebih = txtRpBkm3.Text.ToString().Trim(); string Trm = txtTrm3.Text.ToString(); string RpTrm = txtRpTrm3.Text.ToString().Trim(); string JmlLbh = (Convert.ToDouble(txtRpTrm3.Text.ToString()) + Convert.ToDouble(txtRpBkm3.Text.ToString())).ToString(); string UserID = SecurityManager.UserName.ToString().Trim(); double Total = Convert.ToDouble(Tools.isNull(txtRpTotal.Text, "0").ToString()); string Terbilang = Tools.Terbilang(Total); List <ReportParameter> rptParams = new List <ReportParameter>(); //rptParams.Add(new ReportParameter("UserID", UserID)); rptParams.Add(new ReportParameter("Nomor", Nomor)); rptParams.Add(new ReportParameter("Tanggal", Tanggal)); rptParams.Add(new ReportParameter("Total", Total.ToString())); rptParams.Add(new ReportParameter("Terbilang", Terbilang)); rptParams.Add(new ReportParameter("Nama", Nama)); rptParams.Add(new ReportParameter("Divisi", Divisi)); rptParams.Add(new ReportParameter("Keperluan", Keperluan)); rptParams.Add(new ReportParameter("NoBkk", NoBkk)); rptParams.Add(new ReportParameter("RpBkk", RpBkk)); rptParams.Add(new ReportParameter("JmlBkk", JmlBkk)); rptParams.Add(new ReportParameter("Jv", Jv)); rptParams.Add(new ReportParameter("RpJv", RpJv)); rptParams.Add(new ReportParameter("LebihKurang", LebihKurang)); rptParams.Add(new ReportParameter("Kurang", Kurang)); rptParams.Add(new ReportParameter("RpKurang", RpKurang)); rptParams.Add(new ReportParameter("Trk", Trk)); rptParams.Add(new ReportParameter("RpTrk", RpTrk)); rptParams.Add(new ReportParameter("JmlKrg", JmlKrg)); rptParams.Add(new ReportParameter("Lebih", Lebih)); rptParams.Add(new ReportParameter("RpLebih", RpLebih)); rptParams.Add(new ReportParameter("Trm", Trm)); rptParams.Add(new ReportParameter("RpTrm", RpTrm)); rptParams.Add(new ReportParameter("JmlLbh", JmlLbh)); frmReportViewer ifrmReport = new frmReportViewer("Kasir.Report.rptCetakKasbonbaru.rdlc", rptParams, dt, "dsKasbon_Data"); ifrmReport.Print(); //////ifrmReport.Print(8.5, 6.4); //////ifrmReport.Show(); }