//public void RefreshRowData()
//{
// double Total = 0;
// try
// {
// DataTable dtHeader = new DataTable();
// this.Cursor = Cursors.WaitCursor;
// using (Database db = new Database(GlobalVar.DBName))
// {
// //db.Commands.Add(db.CreateCommand("usp_BuktiTransferDetail_AfterFillDetail"));
// db.Commands.Add(db.CreateCommand("usp_TransferBankDetail_LIST"));
// db.Commands[0].Parameters.Add(new Parameter("@NoBBK", SqlDbType.VarChar, lblNoBkk.Text));
// dtHeader = db.Commands[0].ExecuteDataTable();
// gridTransfer.DataSource = dtHeader;
// Total = Convert.ToDouble(dtHeader.Compute("SUM(Nominal)", string.Empty));
// }
// numericTextBox1.Text = Total.ToString();
// }
// catch (System.Exception ex)
// {
// Error.LogError(ex);
// }
// finally
// {
// this.Cursor = Cursors.Default;
// }
//}
public void RefreshRowData(Guid rowIDDetail)
{
DataTable dtRefresh = new DataTable();
dtRefresh = TransferBank.ListDetailRow(rowIDDetail);
gridTransfer.RefreshDataRow(dtRefresh.Rows[0], "RowIDDetail", rowIDDetail.ToString());
}
public void RefreshRowBuktiTransferDetail(Guid rowID)
{
DataTable dtRefresh = new DataTable();
dtRefresh = TransferBank.ListDetailRow(rowID);
gridDetail.RefreshDataRow(dtRefresh.Rows[0], "RowIDDetail", rowID.ToString());
}
public void RefreshRowBuktiTransfer(Guid rowID)
{
DataTable dtRefresh = new DataTable();
dtRefresh = TransferBank.ListHeaderRow(rowID, "K");
gridUtm.RefreshDataRow(dtRefresh.Rows[0], "RowID", rowID.ToString());
}
private void cmdPrint_Click(object sender, EventArgs e)
{
if (selectedGrid == enumSelectedGrid.DetailSelected)
{
Guid _RowID = (Guid)gridPiutang.SelectedCells[0].OwningRow.Cells["RowID"].Value;
string _reff = gridPiutang.SelectedCells[0].OwningRow.Cells["Reff"].Value.ToString();
string MK = "";
DataTable dt = new DataTable();
try
{
using (Database db = new Database(GlobalVar.DBFinance))
{
db.Commands.Add(db.CreateCommand("rsp_CetakPiutangKaryawan"));
db.Commands[0].Parameters.Add(new Parameter("@RowID", SqlDbType.UniqueIdentifier, _RowID));
db.Commands[0].Parameters.Add(new Parameter("@Ref", SqlDbType.VarChar, _reff));
dt = db.Commands[0].ExecuteDataTable();
}
if (_reff == "BKK" || _reff == "BKM")
{
if (_reff == "BKK")
{
MK = "K";
}
else
{
MK = "M";
}
if ((int)dt.Rows[0]["NPrint"] > 0 && (!SecurityManager.IsManager() && SecurityManager.AskPasswordManager() == false))
{
return;
}
BKM.cetakBukti(dt, MK);
}
else if (_reff == "TRK" || _reff == "TRM" || _reff == "TRN")
{
if (_reff == "TRK")
{
MK = "K";
}
else
{
MK = "M";
}
if ((int)dt.Rows[0]["NPrint"] > 0 && (!SecurityManager.IsManager() && SecurityManager.AskPasswordManager() == false))
{
return;
}
TransferBank.cetakTransfer(dt, MK);
}
}
catch (Exception ex)
{
Error.LogError(ex);
}
}
}
private void addIndenDetail(
Database db
)
{
DataTable dtCekRelasi = new DataTable();
db.Commands.Clear();
db.Commands.Add(db.CreateCommand("usp_IndenDetail_INSERT"));
db.Commands[0].Parameters.Add(new Parameter("@RowID", SqlDbType.UniqueIdentifier, RowID));
db.Commands[0].Parameters.Add(new Parameter("@HeaderID", SqlDbType.UniqueIdentifier, HeaderID));
db.Commands[0].Parameters.Add(new Parameter("@RecordID", SqlDbType.VarChar, RecordID));
db.Commands[0].Parameters.Add(new Parameter("@HRecordID", SqlDbType.VarChar, HRecordID));
db.Commands[0].Parameters.Add(new Parameter("@TglTrf", SqlDbType.DateTime, tglRK));
db.Commands[0].Parameters.Add(new Parameter("@BankID", SqlDbType.VarChar, bankID));
db.Commands[0].Parameters.Add(new Parameter("@NamaBank", SqlDbType.VarChar, NamaBank));
db.Commands[0].Parameters.Add(new Parameter("@Lokasi", SqlDbType.VarChar, Lokasi));
db.Commands[0].Parameters.Add(new Parameter("@CHBG", SqlDbType.VarChar, cara));
db.Commands[0].Parameters.Add(new Parameter("@Nomor", SqlDbType.VarChar, noBGC));
db.Commands[0].Parameters.Add(new Parameter("@TglGiro", SqlDbType.DateTime, tglGiro));
db.Commands[0].Parameters.Add(new Parameter("@TglJt", SqlDbType.DateTime, tglJTempo));
db.Commands[0].Parameters.Add(new Parameter("@Ket", SqlDbType.VarChar, ket));
db.Commands[0].Parameters.Add(new Parameter("@NoAcc", SqlDbType.VarChar, noAcc));
db.Commands[0].Parameters.Add(new Parameter("@RpCash", SqlDbType.Money, RpCash));
db.Commands[0].Parameters.Add(new Parameter("@RpGiro", SqlDbType.Money, RpGiro));
db.Commands[0].Parameters.Add(new Parameter("@RpTrf", SqlDbType.Money, RpTrn));
db.Commands[0].Parameters.Add(new Parameter("@RpCrd", SqlDbType.Money, RpCrd));
db.Commands[0].Parameters.Add(new Parameter("@RpDbt", SqlDbType.Money, RpDbt));
db.Commands[0].Parameters.Add(new Parameter("@LastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID));
if (RowIDOrderPenjualan != Guid.Empty)
{
db.Commands[0].Parameters.Add(new Parameter("@RowIDOrderPenjualan", SqlDbType.UniqueIdentifier, RowIDOrderPenjualan));
}
db.Commands[0].ExecuteNonQuery();
if (cara == "")
{
string _noPerk;
_noPerk = Perkiraan.GetPerkiraanKoneksiDetail("IND").Rows[0]["NoPerkiraan"].ToString();
dtCekRelasi = Inden.CekRelasiInden("Bukti", "SrcID", HeaderID.ToString(), "", "").Copy();
Guid _RowID = new Guid();
if (dtCekRelasi.Rows.Count == 0)
{
_RowID = HeaderID;
string noBKM = Numerator.BookNumerator("BKM");
BKM.AddHeader(db, _RowID, HeaderID, BKM.GetRecordIDBukti(HRecordID, "IND"), noBKM, "K", "IND", tglInden, namaCollector, "", noAcc, SecurityManager.UserName, "");
}
else
{
_RowID = (Guid)dtCekRelasi.Rows[0][0];
}
BKM.AddDetail(db, RowID, _RowID, RecordID, BKM.GetRecordIDBukti(HRecordID, "IND"), "", "", "", noAcc, _noPerk, "PENERIMAAN BELUM IDENTIFIKASI (" + noBukti + ")", RpCash);
}
else if (cara == "T")
{
string recordIDTB = HRecordID + "I";
string noBBK = "";
string _noPerk = Perkiraan.GetPerkiraanKoneksiDetail("IND").Rows[0]["NoPerkiraan"].ToString();
Guid _RowID = new Guid();
dtCekRelasi = Inden.CekRelasiInden("TransferBank", "SrcID", HeaderID.ToString(), "", "").Copy();
if (dtCekRelasi.Rows.Count == 0)
{
_RowID = HeaderID;
noBBK = Numerator.BookNumerator("BBM");
TransferBank.addHeader(db, _RowID, HeaderID, recordIDTB, tglInden, noBBK, "M", "", "IND. No " + noBukti, "", "", SecurityManager.UserName, "");
}
else
{
_RowID = (Guid)dtCekRelasi.Rows[0][0];
noBBK = dtCekRelasi.Rows[0][1].ToString();
}
TransferBank.addDetail(db, RowID, _RowID, RecordID, recordIDTB, collectorID, namaCollector, NamaBank, Lokasi, noAcc, (DateTime)tglRK, RpTrn, "", "", "", "", bankID, _noPerk, "");
Bank.AddBankDetail(db, RowID, Guid.Empty, noBBK, noAcc, rowIDBankTujuan, "", tglInden, "BBM", "TRANSFER DARI : " + namaCollector + " (BANK TRANSFER)", "IDR", RpTrn, "0", DateTime.Today, (DateTime)tglRK, "", "", "", "", _noPerk, bankID, RecordID);
}
else if (cara == "G" || cara == "C" || cara == "S")
{
string recordIDVJ = "";
Guid _VJRowID = new Guid();
string noVoucher = Numerator.BookNumerator("VPG");
string _noPerk = Perkiraan.GetPerkiraanKoneksiDetail("IND").Rows[0]["NoPerkiraan"].ToString();
dtCekRelasi = new DataTable();
dtCekRelasi = Inden.CekRelasiInden("VoucherJournal", "RefRowID", HeaderID.ToString(), "PG", "").Copy();
if (dtCekRelasi.Rows.Count == 0)
{
recordIDVJ = HRecordID + "I";
_VJRowID = Guid.NewGuid();
VoucherJournal.AddHeader(db, _VJRowID, HeaderID, recordIDVJ, "PG", tglInden, noVoucher,
"PENERIMAAN GIRO IND. NO " + noBukti, "", "", "", "", "", "", "", 0, true);
}
else
{
recordIDVJ = dtCekRelasi.Rows[0][1].ToString();
_VJRowID = (Guid)dtCekRelasi.Rows[0][0];
}
//VoucherJournal.AddDetail(db, RowID, _VJRowID, RecordID, recordIDVJ, "", "", "", noBGC, _noPerk, namaCollector,
// Convert.ToDouble(RpGiro), 0, true);
Giro.Add(db, RowID, _VJRowID, Guid.Empty, Guid.Empty, recordIDVJ, "", "", RecordID, "", NamaBank, Lokasi,
cara, noBGC, (DateTime)tglGiro, (DateTime)tglJTempo, Convert.ToDouble(RpGiro), "", SqlDateTime.Null,
"", "", "", "", "", "", _noPerk, SqlDateTime.Null, true, noAcc, "");
}
else if (cara == "R")
{
string recordIDVPG = "", noVoucherPG = "", noVoucherTT = "";
string recordIDVTT = "";
Guid _VJRowIDPG = new Guid();
Guid _VJRowIDTT = new Guid();
string _noPerk = Perkiraan.GetPerkiraanKoneksiDetail("IND").Rows[0]["NoPerkiraan"].ToString();
//VOUCHER PENERIMAAN CRD
dtCekRelasi = Inden.CekRelasiInden("VoucherJournal", "RefRowID", HeaderID.ToString(), "CRD", "").Copy();
if (dtCekRelasi.Rows.Count == 0)
{
recordIDVPG = HRecordID + "R";
_VJRowIDPG = Guid.NewGuid();
noVoucherPG = Numerator.BookNumerator("VPG");
VoucherJournal.AddHeader(db, _VJRowIDPG, HeaderID, recordIDVPG, "CC", tglInden, noVoucherPG,
"PENERIMAAN CREDIT CARD IND. NO " + noBukti, "", "", "", "", "", "", "", 0, true);
}
else
{
recordIDVPG = dtCekRelasi.Rows[0][1].ToString();
_VJRowIDPG = (Guid)dtCekRelasi.Rows[0][0];
}
//VoucherJournal.AddDetail(db, RowID, _VJRowID, RecordID, recordIDVJ, "", "", "", noBGC, _noPerk, namaCollector,
// Convert.ToDouble(RpGiro), 0, true);
//VOUCHER TITIP CRD
dtCekRelasi = new DataTable();
dtCekRelasi = Inden.CekRelasiInden("VoucherJournal", "RefRowID", HeaderID.ToString(), "TT", bankID).Copy();
if (dtCekRelasi.Rows.Count == 0)
{
recordIDVTT = Tools.CreateFingerPrint(GlobalVar.PerusahaanID, SecurityManager.UserInitial).TrimEnd() + "R";
_VJRowIDTT = Guid.NewGuid();
noVoucherTT = Numerator.BookNumerator("VTG");
VoucherJournal.AddHeader(db, _VJRowIDTT, HeaderID, recordIDVTT, "TT", tglInden, noVoucherTT,
"OTOMATIS TITIP DR CRD", "", "", "", "", "", bankID, namaBanki, 0, true);
}
else
{
recordIDVTT = dtCekRelasi.Rows[0][1].ToString();
_VJRowIDTT = (Guid)dtCekRelasi.Rows[0][0];
}
//INSERT TABLE GIRO
Giro.Add(db, RowID, _VJRowIDPG, Guid.Empty, _VJRowIDTT, recordIDVPG, "", recordIDVTT, RecordID, "", NamaBank, Lokasi,
cara, noBGC, (DateTime)tglGiro, (DateTime)tglJTempo, Convert.ToDouble(RpCrd), "", (DateTime)SqlDateTime.Null,
"", "", "", "", bankID, namaBanki, _noPerk, tglInden, true, noAcc, "");
}
else if (cara == "D")
{
string recordIDVPG = "", noVoucherPG = "", noVoucherTT = "";
string recordIDVTT = "";
Guid _VJRowIDPG = new Guid();
Guid _VJRowIDTT = new Guid();
string _noPerk = Perkiraan.GetPerkiraanKoneksiDetail("IND").Rows[0]["NoPerkiraan"].ToString();
//VOUCHER PENERIMAAN CRD
dtCekRelasi = Inden.CekRelasiInden("VoucherJournal", "RefRowID", HeaderID.ToString(), "DBT", "").Copy();
if (dtCekRelasi.Rows.Count == 0)
{
recordIDVPG = HRecordID + "D";
_VJRowIDPG = Guid.NewGuid();
noVoucherPG = Numerator.BookNumerator("VPG");
VoucherJournal.AddHeader(db, _VJRowIDPG, HeaderID, recordIDVPG, "DB", tglInden, noVoucherPG,
"PENERIMAAN DEBIT CARD IND. NO " + noBukti, "", "", "", "", "", "", "", 0, true);
}
else
{
recordIDVPG = dtCekRelasi.Rows[0][1].ToString();
_VJRowIDPG = (Guid)dtCekRelasi.Rows[0][0];
}
//VoucherJournal.AddDetail(db, RowID, _VJRowID, RecordID, recordIDVJ, "", "", "", noBGC, _noPerk, namaCollector,
// Convert.ToDouble(RpGiro), 0, true);
//VOUCHER TITIP CRD
dtCekRelasi = new DataTable();
dtCekRelasi = Inden.CekRelasiInden("VoucherJournal", "RefRowID", HeaderID.ToString(), "TT", bankID).Copy();
if (dtCekRelasi.Rows.Count == 0)
{
recordIDVTT = Tools.CreateFingerPrint(GlobalVar.PerusahaanID, SecurityManager.UserInitial).TrimEnd() + "D";
_VJRowIDTT = Guid.NewGuid();
noVoucherTT = Numerator.BookNumerator("VTG");
VoucherJournal.AddHeader(db, _VJRowIDTT, HeaderID, recordIDVTT, "TT", tglInden, noVoucherTT,
"OTOMATIS TITIP DR DBT", "", "", "", "", "", bankID, namaBanki, 0, true);
}
else
{
recordIDVTT = dtCekRelasi.Rows[0][1].ToString();
_VJRowIDTT = (Guid)dtCekRelasi.Rows[0][0];
}
//INSERT TABLE GIRO
Giro.Add(db, RowID, _VJRowIDPG, Guid.Empty, _VJRowIDTT, recordIDVPG, "", recordIDVTT, RecordID, "", NamaBank, Lokasi,
cara, noBGC, (DateTime)tglGiro, (DateTime)tglJTempo, Convert.ToDouble(RpDbt), "", (DateTime)SqlDateTime.Null,
"", "", "", "", bankID, namaBanki, _noPerk, tglInden, true, noAcc, "");
}
}
private void frmBuktiTransferKeluarUpdate_Load(object sender, EventArgs e)
{
double Total = 0;
if (formMode == enumFormMode.Update)
{
dt = new DataTable();
dtH = new DataTable();
using (Database db = new Database(GlobalVar.DBName))
{
//db.Commands.Add(db.CreateCommand("usp_BuktiTransferKeluarShowForUpdateHeader"));
dtH = TransferBank.ListHeaderRow(_rowIDTransferBank, "K");
dt = TransferBank.ListDetail(db, _rowIDTransferBank);
gridTransfer.DataSource = dt.DefaultView;
if (_isFromPiutang == false)
{
Total = Convert.ToDouble(ISA.Common.Tools.isNullOrEmpty(dt.Compute("SUM(Nominal)", string.Empty).ToString(), "0"));
_BankID = dtH.Rows[0]["BankID"].ToString();
_recordIDTransferBank = dtH.Rows[0]["RecordID"].ToString();
_rowIDBank = (Guid)dtH.Rows[0]["RowIDBank"];
lookupBank1.NamaBank = dtH.Rows[0]["NamaBank"].ToString();
lookupBank1.BankID = _BankID;
txtKepada.Text = dtH.Rows[0]["Penyetor"].ToString().Trim();
lblNoBkk.Text = dtH.Rows[0]["NoBBM"].ToString();
lblTanggal.Text = ((DateTime)dtH.Rows[0]["TglBBM"]).ToString("dd-MM-yyyy");
lblNoBkk.Visible = false;
}
else
{
Total = Convert.ToDouble(ISA.Common.Tools.isNullOrEmpty(dt.Compute("SUM(Nominal)", string.Empty).ToString(), "0"));
txtKepada.Text = dtH.Rows[0]["Penyetor"].ToString().Trim();
lookupBank1.NamaBank = dtH.Rows[0]["NamaBank"].ToString();
lookupBank1.BankID = _BankID;
_BankID = dtH.Rows[0]["BankID"].ToString();
_recordIDTransferBank = dtH.Rows[0]["RecordID"].ToString();
_recordIDTransferBank2 = _recordIDTransferBank.Substring(0, 22) + _jp;
lblNoBkk.Text = dtH.Rows[0]["NoBBM"].ToString();
_rowIDBank = (Guid)dtH.Rows[0]["RowIDBank"];
txtKepada.Enabled = false;
lookupBank1.Enabled = false;
lblNoBkk.Visible = true;
lblTanggal.Text = ((DateTime)dtH.Rows[0]["TglBBM"]).ToString("dd-MM-yyyy");
}
}
}
else
{
if (_isFromPiutang == true)
{
txtKepada.Text = _name.Trim();
}
lblNoBkk.Visible = false;
lblTanggal.Text = DateTime.Now.Date.ToString("dd-MM-yyyy");
}
numericTextBox1.Text = Total.ToString("#,##0");
}
private void cmdSave_Click(object sender, EventArgs e)
{
//if (lookupPerkiraanKoneksi1.NoPerkiraan == "" || lookupPerkiraanKoneksi1.NoPerkiraan == "[CODE]")
//{
// MessageBox.Show("No Perkiraan masih kosong.");
// return;
//}
bool isPrinted = LookupInfoValue.CekPrintBs();
if (formMode == enumformMode.New)
{
if (txtAcc.Text == "")
{
MessageBox.Show("Masih ada Kasbon yang belum diselesaikan, dan belum ada PIN dari HO.");
lookupPegawai1.Focus();
return;
}
if (!validate())
{
return;
}
DateTime _Tanggal = (DateTime)tbTanggal.DateValue;
if (PeriodeClosing.IsKasirClosed(_Tanggal))
{
MessageBox.Show("Sudah Closing!");
return;
}
_RowID = Guid.NewGuid();
string _RecordID = ISA.Common.Tools.CreateShortFingerPrint(GlobalVar.PerusahaanID, SecurityManager.UserInitial, 1);
string _RecordIDBKKDetail = ISA.Common.Tools.CreateShortFingerPrint(GlobalVar.PerusahaanID, SecurityManager.UserInitial, 2);
string _NoBKK = Numerator.BookNumerator("BKK", tbTanggal.DateValue);
string _NoBukti = Numerator.BookNumerator("BON", tbTanggal.DateValue);
try
{
using (Database db = new Database(GlobalVar.DBName))
{
db.Commands.Add(db.CreateCommand("usp_Kasbon_INSERT"));
db.Commands[0].Parameters.Add(new Parameter("@RowID", SqlDbType.UniqueIdentifier, _RowID));
db.Commands[0].Parameters.Add(new Parameter("@RecordID", SqlDbType.VarChar, _RecordID));
db.Commands[0].Parameters.Add(new Parameter("@NIP", SqlDbType.VarChar, lookupPegawai1.Nip));
db.Commands[0].Parameters.Add(new Parameter("@Nama", SqlDbType.VarChar, lookupPegawai1.Nama));
db.Commands[0].Parameters.Add(new Parameter("@UnitKerja", SqlDbType.VarChar, lookupPegawai1.Unitkerja));
db.Commands[0].Parameters.Add(new Parameter("@NoBukti", SqlDbType.VarChar, _NoBukti));
db.Commands[0].Parameters.Add(new Parameter("@Tgl", SqlDbType.DateTime, tbTanggal.DateValue));
db.Commands[0].Parameters.Add(new Parameter("@Keperluan", SqlDbType.VarChar, tbKeperluan.Text.Trim()));
db.Commands[0].Parameters.Add(new Parameter("@BKKNo1", SqlDbType.VarChar, _NoBKK));
db.Commands[0].Parameters.Add(new Parameter("@BKKRp1", SqlDbType.Money, tbNominal.Text));
db.Commands[0].Parameters.Add(new Parameter("@Total1", SqlDbType.Money, tbNominal.Text));
db.Commands[0].Parameters.Add(new Parameter("@Kode", SqlDbType.VarChar, ""));
db.Commands[0].Parameters.Add(new Parameter("@Sub", SqlDbType.VarChar, ""));
db.Commands[0].Parameters.Add(new Parameter("@Hari", SqlDbType.VarChar, tbHari.Text));
db.Commands[0].Parameters.Add(new Parameter("@NoPerkiraan", SqlDbType.VarChar, lookupPerkiraanKoneksi1.NoPerkiraan));
db.Commands[0].Parameters.Add(new Parameter("@LastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID));
db.BeginTransaction();
db.Commands[0].ExecuteNonQuery();
BKK.AddHeader(db, _RowID, _RowID, BKK.GetRecordIDBukti(_RecordID, "BSA"), _NoBKK, "", "BSA", (DateTime)tbTanggal.DateValue, lookupPegawai1.Nama, "", "", SecurityManager.UserName, "", "TT");
BKK.AddDetail(db, Guid.NewGuid(), _RowID, _RecordIDBKKDetail, BKK.GetRecordIDBukti(_RecordID, "BSA"), "", "", "", "", lookupPerkiraanKoneksi1.NoPerkiraan, tbKeperluan.Text.Trim() + " (" + _NoBukti + ")", tbNominal.Text);
db.CommitTransaction();
}
string nominal = tbNominal.GetDoubleValue.ToString("#,###");
if (isPrinted)
{
cetakLaporan(_NoBKK, tbKeperluan.Text.Trim() + " (" + _NoBukti + ")", nominal, tbTanggal.DateValue.Value.ToString("dd/MM/yyyy"), "K");
}
frmKasbonBrowse frm = new frmKasbonBrowse();
frm = (frmKasbonBrowse)Caller;
//frm.KasbonRefresh(_RowID);
frm.KasbonRefresh();
frm.KasbonFindRow("RowID", _RowID.ToString());
this.Close();
}
catch (Exception ex)
{
Error.LogError(ex);
}
}
else
{
if (tbSisa.Text != "0")
{
MessageBox.Show("Masih ada sisa BS, tidak boleh di update.");
return;
}
if (tbRpTrm.Text != "0" && bankID == "")
{
MessageBox.Show("Detail transfer belum diisi.");
return;
}
string noVJU = "", noBKK3 = "", noBKM3 = "", noTRM3 = "";
double rpVJU = 0, rpBKK3 = 0, rpBKM3 = 0, rpTRM3 = 0, rpTotle = 0, rpTotku = 0;
if (dtVoucher.Rows.Count > 0)
{
noVJU = Numerator.BookNumerator("VJU", tbTanggal.DateValue);
rpVJU = Convert.ToDouble(tbTotal.Text);
}
if (selisih < 0)
{
rpTotku = selisih * -1;
rpBKK3 = Convert.ToDouble(tbBKK.Text);
noBKK3 = Numerator.BookNumerator("BKK", tbTanggal.DateValue);
}
else
{
rpTotle = Convert.ToDouble(tbBKM.Text) + Convert.ToDouble(tbRpTrm.Text);
if (cbBkm.Checked == true)
{
rpBKM3 = Convert.ToDouble(tbBKM.Text);
noBKM3 = Numerator.BookNumerator("BKM", tbTanggal.DateValue);
}
if (cbTrm.Checked == true)
{
rpTRM3 = Convert.ToDouble(tbRpTrm.Text);
noTRM3 = Numerator.BookNumerator("BBM", tbTanggal.DateValue);
}
}
try
{
using (Database db = new Database(GlobalVar.DBName))
{
db.BeginTransaction();
db.Commands.Add(db.CreateCommand("usp_Kasbon_UPDATE"));
db.Commands[0].Parameters.Add(new Parameter("@RowID", SqlDbType.UniqueIdentifier, _RowID));
db.Commands[0].Parameters.Add(new Parameter("@JVNo1", SqlDbType.VarChar, noVJU));
db.Commands[0].Parameters.Add(new Parameter("@BKKNo3", SqlDbType.VarChar, noBKK3));
db.Commands[0].Parameters.Add(new Parameter("@BKMNo3", SqlDbType.VarChar, noBKM3));
db.Commands[0].Parameters.Add(new Parameter("@TRNNo3", SqlDbType.VarChar, noTRM3));
db.Commands[0].Parameters.Add(new Parameter("@JVRp1", SqlDbType.Money, rpVJU));
db.Commands[0].Parameters.Add(new Parameter("@Total2", SqlDbType.Money, Convert.ToDouble(tbTotal.Text)));
db.Commands[0].Parameters.Add(new Parameter("@BKKRp3", SqlDbType.Money, rpBKK3));
db.Commands[0].Parameters.Add(new Parameter("@BKMRp3", SqlDbType.Money, rpBKM3));
db.Commands[0].Parameters.Add(new Parameter("@TRNRp3", SqlDbType.Money, rpTRM3));
db.Commands[0].Parameters.Add(new Parameter("@Totle3", SqlDbType.Money, rpTotle));
db.Commands[0].Parameters.Add(new Parameter("@Totku3", SqlDbType.Money, rpTotku));
db.Commands[0].Parameters.Add(new Parameter("@LastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID));
if (_biayaOperasionalRowId != Guid.Empty)
{
db.Commands[0].Parameters.Add(new Parameter("@BiayaOperasionalRowID", SqlDbType.UniqueIdentifier, _biayaOperasionalRowId));
}
db.Commands[0].ExecuteNonQuery();
if (dtVoucher.Rows.Count > 0)
{
string vjRecID = _RecordID + "X";
VoucherJournal.AddHeader(db, _RowID, _RowID, vjRecID, "UM", DateTime.Today, noVJU, tbKeperluan.Text.Trim() + " (" + TBNoKasbon.Text + ")", "", "", SecurityManager.UserName, "", "", "", "", 0, true);
foreach (DataRow dr in dtVoucher.Rows)
{
VoucherJournal.AddDetail(db, (Guid)dr["RowID"], _RowID, dr["RecordID"].ToString(), vjRecID, "", "", dr["NoAcc"].ToString(), "", dr["NoPerkiraan"].ToString(), dr["Keterangan"].ToString() + " (" + TBNoKasbon.Text + ")", (Double)dr["Debet"], 0, true);
}
if (isPrinted)
{
cetakLaporanVju(noVJU, String.Format("{0:dd/MM/yyyy}", DateTime.Today));
}
}
if (cbBkm.Checked == true)
{
Guid rowID = Guid.NewGuid();
string recIDD = Tools.CreateShortFingerPrint(GlobalVar.PerusahaanID, SecurityManager.UserInitial, 2);
string uraian = "KELEBIHAN BS " + tbKeperluan.Text.Trim() + " (" + TBNoKasbon.Text + ")";
BKM.AddHeader(db, rowID, _RowID, BKM.GetRecordIDBukti(_RecordID, "BSL"), noBKM3, "", "BSL", DateTime.Today, lookupPegawai1.Nama, "", "", SecurityManager.UserName, "");
BKM.AddDetail(db, Guid.NewGuid(), rowID, recIDD, BKM.GetRecordIDBukti(_RecordID, "BSL"), "", "", "", "", "", uraian, rpBKM3.ToString());
if (isPrinted)
{
cetakLaporan(noBKM3, uraian, rpBKM3.ToString("#,###"), String.Format("{0:dd/MM/yyyy}", DateTime.Today), "M");
}
}
if (cbBkk.Checked == true)
{
Guid rowID = Guid.NewGuid();
string recIDD = Tools.CreateShortFingerPrint(GlobalVar.PerusahaanID, SecurityManager.UserInitial, 2);
string uraian = "KEKURANGAN BS " + tbKeperluan.Text.Trim() + " (" + TBNoKasbon.Text + ")";
BKK.AddHeader(db, rowID, _RowID, BKK.GetRecordIDBukti(_RecordID, "BSK"), noBKK3, "", "BSK", DateTime.Today, lookupPegawai1.Nama, "", "", SecurityManager.UserName, "", "");
BKK.AddDetail(db, Guid.NewGuid(), rowID, recIDD, BKK.GetRecordIDBukti(_RecordID, "BSK"), "", "", "", "", "", uraian, rpBKK3.ToString());
if (isPrinted)
{
cetakLaporan(noBKK3, uraian, rpBKK3.ToString("#,###"), String.Format("{0:dd/MM/yyyy}", DateTime.Today), "K");
}
}
if (cbTrm.Checked == true)
{
Guid rowID = _RowID;
string uraian = "KELEBIHAN BS " + tbKeperluan.Text.Trim() + " (" + TBNoKasbon.Text + ")";
TransferBank.addHeader(db, rowID, _RowID, _RecordID.TrimEnd() + "8", DateTime.Today, noTRM3, "M", bankID, bankAsal, "", "", SecurityManager.UserName, lookupPegawai1.Nama);
TransferBank.addDetail(db, rowID, rowID, _RecordID.TrimEnd() + "8", _RecordID.TrimEnd() + "8", "", uraian, bankAsal, "", nomor, DateTime.Today, rpTRM3.ToString(), "", "", "", "", bankID, "", "");
Bank.AddBankDetail(db, rowID, Guid.Empty, noTRM3, "", Guid.Empty, "", DateTime.Today, "BBM", "TRANSFER DARI : " + uraian, "IDR", rpTRM3.ToString(), "0", DateTime.Today, DateTime.Today, "", "", "", "", "", bankID, _RecordID.TrimEnd() + "8");
}
db.CommitTransaction();
}
frmKasbonBrowse frm = new frmKasbonBrowse();
frm = (frmKasbonBrowse)Caller;
frm.KasbonRefresh(_RowID);
frm.KasbonFindRow("RowID", _RowID.ToString());
this.Close();
}
catch (Exception ex)
{
Error.LogError(ex);
}
}
}
