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