private void btnPrintUJ_Click(object sender, EventArgs e)
{
string iUJID = radGridView2.SelectedRows[0].Cells["UJID"].Value.ToString();
//Print
DialogResult res = RadMessageBox.Show("Siapkan kertas untuk print.", "SMS - Verification"
, MessageBoxButtons.OKCancel
, RadMessageIcon.Question
, MessageBoxDefaultButton.Button2);
if (res == System.Windows.Forms.DialogResult.OK)
{
PrinterSettings printerSettings;
ReportProcessor reportProcessor;
rptUJ rpt = new rptUJ();
rpt.ReportParameters["user"].Value = NBConfig.ValidUserName;
rpt.ReportParameters["UJid"].Value = iUJID;
IReportDocument iRpt = (IReportDocument)rpt;
iRpt.DocumentName = "UJ_" + radGridView2.SelectedRows[0].Cells["NOSJ"].Value.ToString() + " "
+ radGridView2.SelectedRows[0].Cells["SOPIRName"].Value.ToString();
//// PrinterSettings
printerSettings = new PrinterSettings();
try
{
InstanceReportSource reportSource = new InstanceReportSource();
reportSource.ReportDocument = iRpt;
reportProcessor = new ReportProcessor();
reportProcessor.PrintReport(reportSource, printerSettings);
using (sinarekDataSetTableAdapters.uangjalanTableAdapter tbl = new sinarekDataSetTableAdapters.uangjalanTableAdapter())
{
tbl.UpdatePrinted(1
, NBConfig.ValidUserName
, int.Parse(iUJID));
}
helper.PrintLog(this.GetType().Name, rpt.Name, "Print:" + iUJID);
this.vlappenTableAdapter.FillByTanggal(this.sinarekDataSet.vlappen, dtpTanggalLaporan.Value, "UJ");
}
catch (Exception ex)
{
helper.SysLog(this.GetType().Name, this.Text, ex.Message);
helper.ErrorMessage(ex.Message);
}
}
}
public frmInputUB(DataRow DataRow_, string lappenid, bool printed)
{
add_ = false;
edit_ = false;
delete_ = false;
InitializeComponent();
lappenid_ = lappenid;
printed_ = printed;
row_ = DataRow_;
using (sinarekDataSetTableAdapters.uangjalanTableAdapter tbl = new sinarekDataSetTableAdapters.uangjalanTableAdapter())
{
ujid_ = row_["LogID"].ToString();
//DataRow data = tbl.GetDataByUJID(int.Parse(ujid_)).Rows[0];
lblKernet.Text = "Keterangan : " + row_["KernetName"].ToString();
lblSopir.Text = "Nama : " + row_["SopirName"].ToString();
lblTujuan.Text = "Tujuan : " + row_["Tujuan"].ToString();
lblMobil.Text = "Kendaraan : " + row_["MobilName"].ToString();
lblNoSJ.Text = "No. SJ : " + row_["NoSJ"].ToString();
value_ = decimal.Parse(row_["jumlah"].ToString());
lblValue.Text = "Jumlah : " + value_.ToString("Rp #,###.00");
}
}
private void btnSimpan_Click(object sender, EventArgs e)
{
if (ValidateFields())
{
string UJID;
//Create UJ
using (sinarekDataSetTableAdapters.uangjalanTableAdapter tbl = new sinarekDataSetTableAdapters.uangjalanTableAdapter())
{
UJID = tbl.pInsertUangJalan(-2
, "DALAM KOTA"
, "KAS"
, rddNama.Text
, rddMobil.Text
, txtKeterangan.Text
, -1
, decimal.Parse(txtJumlah.Text)
, 0, NBConfig.ValidUserName).ToString();
}
//Print
DialogResult res = RadMessageBox.Show("Siapkan kertas untuk print.", "SMS - Verification"
, MessageBoxButtons.OKCancel
, RadMessageIcon.Question
, MessageBoxDefaultButton.Button2);
if (res == System.Windows.Forms.DialogResult.OK)
{
PrinterSettings printerSettings;
ReportProcessor reportProcessor;
rptUJ rpt = new rptUJ();
rpt.ReportParameters["user"].Value = NBConfig.ValidUserName;
rpt.ReportParameters["UJid"].Value = UJID;
IReportDocument iRpt = (IReportDocument)rpt;
iRpt.DocumentName = "UJ_" + rddNama.Text + "_"
+ rddMobil.Text;
//// PrinterSettings
printerSettings = new PrinterSettings();
try
{
InstanceReportSource reportSource = new InstanceReportSource();
reportSource.ReportDocument = iRpt;
reportProcessor = new ReportProcessor();
reportProcessor.PrintReport(reportSource, printerSettings);
using (sinarekDataSetTableAdapters.uangjalanTableAdapter tbl = new sinarekDataSetTableAdapters.uangjalanTableAdapter())
{
tbl.UpdatePrinted(1
, NBConfig.ValidUserName
, int.Parse(UJID));
}
helper.PrintLog(this.GetType().Name, rpt.Name, "Print:" + UJID);
}
catch (Exception ex)
{
helper.SysLog(this.GetType().Name, this.Text, ex.Message);
helper.ErrorMessage(ex.Message);
}
}
this.Close();
}
}
private void radGridView1_CommandCellClick(object sender, EventArgs e)
{
string UJID;
GridCommandCellElement cell = (GridCommandCellElement)sender;
if (cell.CommandButton.TextElement.Text == "Ambil")
{
if (bool.Parse(cell.RowInfo.Cells["printed"].Value.ToString()))
{
//Create UJ
using (sinarekDataSetTableAdapters.uangjalanTableAdapter tbl = new sinarekDataSetTableAdapters.uangjalanTableAdapter())
{
UJID = tbl.pInsertUangJalan(int.Parse(cell.RowInfo.Cells["LogID"].Value.ToString())
, cell.RowInfo.Cells["TUJUAN"].Value.ToString()
, cell.RowInfo.Cells["NOSJ"].Value.ToString()
, cell.RowInfo.Cells["SOPIRNAME"].Value.ToString()
, cell.RowInfo.Cells["MOBILNAME"].Value.ToString()
, cell.RowInfo.Cells["KERNETNAME"].Value.ToString()
, -1
, decimal.Parse(cell.RowInfo.Cells["UangJalan"].Value.ToString())
, 0, NBConfig.ValidUserName).ToString();
}
//Print Uang Jalan
//Print
DialogResult res = RadMessageBox.Show("Siapkan kertas untuk print.", "SMS - Verification"
, MessageBoxButtons.OKCancel
, RadMessageIcon.Question
, MessageBoxDefaultButton.Button2);
if (res == System.Windows.Forms.DialogResult.OK)
{
PrinterSettings printerSettings;
ReportProcessor reportProcessor;
rptUJ rpt = new rptUJ();
rpt.ReportParameters["user"].Value = NBConfig.ValidUserName;
rpt.ReportParameters["UJID"].Value = UJID;
IReportDocument iRpt = (IReportDocument)rpt;
iRpt.DocumentName = "UJ_" + cell.RowInfo.Cells["NOSJ"].Value.ToString() + " "
+ cell.RowInfo.Cells["SOPIRNAME"].Value.ToString();
//// PrinterSettings
printerSettings = new PrinterSettings();
try
{
InstanceReportSource reportSource = new InstanceReportSource();
reportSource.ReportDocument = iRpt;
reportProcessor = new ReportProcessor();
reportProcessor.PrintReport(reportSource, printerSettings);
using (sinarekDataSetTableAdapters.uangjalanTableAdapter tbl = new sinarekDataSetTableAdapters.uangjalanTableAdapter())
{
tbl.UpdatePrinted(1
, NBConfig.ValidUserName
, int.Parse(UJID));
}
helper.PrintLog(this.GetType().Name, rpt.Name, "Print:" + UJID);
this.vlappenTableAdapter.FillByTanggal(this.sinarekDataSet.vlappen, dtpTanggalLaporan.Value, "UJ");
}
catch (Exception ex)
{
helper.SysLog(this.GetType().Name, this.Text, ex.Message);
helper.ErrorMessage(ex.Message);
}
}
this.uangjalanTableAdapter.FillByNoLap(this.sinarekDataSet.uangjalan);
this.vujTableAdapter.FillByTanggal(this.sinarekDataSet.vuj, dtpAmbilTanggal.Value);
}
else
{
helper.NotifMessage("Surat Jalan Belum Di Print. Uang Jalan tidak dapat di ambil.");
}
}
}
