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