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