public void HeaderRowRefresh(Guid RowID)
{
DataTable dtRefresh = new DataTable();
dtRefresh = VoucherJournal.ListRowHeader(RowID);
gridHeader.RefreshDataRow(dtRefresh.Rows[0], "RowID", RowID.ToString());
}
public void HeaderRefresh()
{
try
{
this.Cursor = Cursors.WaitCursor;
dtHeader = new DataTable();
using (Database db = new Database(GlobalVar.DBFinance))
{
dtHeader = VoucherJournal.ListHeader(db, (DateTime)tbTanggal.FromDate, (DateTime)tbTanggal.ToDate, "TT");
}
dtHeader.DefaultView.Sort = "TglVoucher";
gridHeader.DataSource = dtHeader.DefaultView;
gridHeader.Focus();
}
catch (Exception ex)
{
Error.LogError(ex);
}
finally
{
this.Cursor = Cursors.Default;
}
}
private void HeaderRefresh()
{
try
{
dtHeader = new DataTable();
DataTable dtPG = new DataTable();
DataTable dtCC = new DataTable();
DataTable dtDB = new DataTable();
using (Database db = new Database(GlobalVar.DBName))
{
dtPG = VoucherJournal.ListHeader(db, (DateTime)tbTanggal.FromDate, (DateTime)tbTanggal.ToDate, "PG");
dtCC = VoucherJournal.ListHeader(db, (DateTime)tbTanggal.FromDate, (DateTime)tbTanggal.ToDate, "CC");
dtDB = VoucherJournal.ListHeader(db, (DateTime)tbTanggal.FromDate, (DateTime)tbTanggal.ToDate, "DB");
}
dtHeader = dtPG;
dtHeader.Merge(dtCC);
dtHeader.Merge(dtDB);
if (dtHeader.Rows.Count > 0)
{
dtHeader.DefaultView.Sort = "TglVoucher";
gridHeader.DataSource = dtHeader.DefaultView.ToTable();
DetailRefresh();
gridHeader.Focus();
}
}
catch (Exception ex)
{
Error.LogError(ex);
}
}
public void RefreshHeader()
{
string tipe = "";
DataTable dt1 = new DataTable(), dt2 = new DataTable(), dt3 = new DataTable();
if (dataLoaded)
{
if (cboTipe.Text == "ALL")
{
tipe = "";
}
else if (cboTipe.Text == "Penerimaan Giro")
{
tipe = "PG";
}
else if (cboTipe.Text == "Titipan Giro")
{
tipe = "TT";
}
else if (cboTipe.Text == "Uang Muka Sementara")
{
tipe = "UM";
}
try
{
this.Cursor = Cursors.WaitCursor;
using (Database db = new Database(GlobalVar.DBName))
{
if (tipe == "PG")
{
dt1 = VoucherJournal.ListHeader(db, (DateTime)rangeDateBox1.FromDate, (DateTime)rangeDateBox1.ToDate, "PG");
dt2 = VoucherJournal.ListHeader(db, (DateTime)rangeDateBox1.FromDate, (DateTime)rangeDateBox1.ToDate, "CC");
dt3 = VoucherJournal.ListHeader(db, (DateTime)rangeDateBox1.FromDate, (DateTime)rangeDateBox1.ToDate, "DB");
dtHeader = dt1;
dtHeader.Merge(dt2);
dtHeader.Merge(dt3);
}
else
{
dtHeader = VoucherJournal.ListHeader(db, (DateTime)rangeDateBox1.FromDate, (DateTime)rangeDateBox1.ToDate, tipe);
}
}
gridHeader.DataSource = dtHeader.DefaultView;
}
catch (Exception ex)
{
Error.LogError(ex);
}
finally
{
this.Cursor = Cursors.Default;
}
}
}
public void cetakLaporan()
{
int nprint = int.Parse(gridHeader.SelectedCells[0].OwningRow.Cells["hdrNPrint"].Value.ToString());
if ((nprint > 0) && (!SecurityManager.IsManager()))
{
if (!SecurityManager.AskPasswordManager())
{
return;
}
}
double total = 0, jumlah;
string _Kepada, _NoBukti, _Tanggal, _Kasir;
Guid _rowID = (Guid)gridHeader.SelectedCells[0].OwningRow.Cells["hdrRowID"].Value;
string _uraian = gridHeader.SelectedCells[0].OwningRow.Cells["hdrUraian"].Value.ToString().Trim();
string _dari = gridHeader.SelectedCells[0].OwningRow.Cells["hdrUraian2"].Value.ToString().Split('|').GetValue(0).ToString().Trim();
_Kepada = gridHeader.SelectedCells[0].OwningRow.Cells["KetBon"].Value.ToString().Trim();
_Kasir = gridHeader.SelectedCells[0].OwningRow.Cells["hdrDibuat"].Value.ToString();
_NoBukti = gridHeader.SelectedCells[0].OwningRow.Cells["hdrNoVoucher"].Value.ToString();
_Tanggal = Convert.ToDateTime(gridHeader.SelectedCells[0].OwningRow.Cells["hdrTglVoucher"].Value).ToString("dd/MM/yyyy");
int rowNo = 0;
int no = 0;
int ttlData = dtDetail.Rows.Count;
int hal = 1;
int ttlHal = 0;
int prevHal = hal;
if (ttlData % 10 > 0)
{
ttlHal = (ttlData / 10) + 1;
}
else
{
ttlHal = ttlData / 10;
}
try
{
BuildString lap = new BuildString();
//lap.Initialize();
//lap.PageLLine(33);
//lap.LeftMargin(3);
//lap.FontCPI(10);
//lap.DoubleWidth(true);
//lap.PROW(true, 1, "[BUKTI KAS KELUAR]");
//lap.DoubleWidth(false);
//lap.FontCondensed(true);
//lap.PROW(true, 1, lap.PrintTopLeftCorner() + lap.PrintHorizontalLine(63) + lap.PrintTTOp()
// + lap.PrintHorizontalLine(64) + lap.PrintTopRightCorner());
//lap.PROW(true, 1, lap.PrintVerticalLine() + "Kepada : ".PadRight(63) +
// lap.PrintVerticalLine() + "Nomor : " + _NoBukti.PadRight(54) + lap.PrintVerticalLine());
//lap.PROW(true, 1, lap.PrintVerticalLine() + _Kepada.PadRight(63) + lap.PrintVerticalLine() + "Tanggal : " +
// _Tanggal.PadRight(30) + "Hal : " + hal.ToString() + "/" + ttlHal.ToString().PadRight(12) + lap.PrintVerticalLine());
//lap.PROW(true, 1, lap.PrintTLeft() + lap.PrintHorizontalLine(63) + lap.PrintTBottom()
// + lap.PrintHorizontalLine(64) + lap.PrintTRight());
//lap.PROW(true, 1, lap.PrintVerticalLine() + "No. Prk".PadRight(15) + lap.PadCenter(98, "URAIAN") + lap.SPACE(15) + lap.PrintVerticalLine());
//lap.PROW(true, 1, lap.PrintTLeft() + lap.PrintHorizontalLine(128) + lap.PrintTRight());
bool cetak = true;
foreach (DataRow dr in dtDetail.Rows)
{
#region header
if (cetak)
{
lap.Initialize();
lap.PageLLine(33);
lap.LeftMargin(1);
lap.FontCPI(12);
lap.LineSpacing("1/6");
lap.DoubleWidth(true);
lap.PROW(true, 1, "[BUKTI KAS KELUAR]");
lap.DoubleWidth(false);
//lap.FontCondensed(true);
lap.PROW(true, 1, lap.PrintTopLeftCorner() + lap.PrintHorizontalLine(41) + lap.PrintTTOp()
+ lap.PrintHorizontalLine(41) + lap.PrintTopRightCorner());
lap.PROW(true, 1, lap.PrintVerticalLine() + ("Kepada : " + _dari.Trim()).PadRight(41) +
lap.PrintVerticalLine() + ("Nomor : " + _NoBukti).PadRight(41) + lap.PrintVerticalLine());
lap.PROW(true, 1, lap.PrintVerticalLine() + _Kepada.PadRight(41) + lap.PrintVerticalLine() + ("Tanggal : " +
_Tanggal).PadRight(30) + ("Hal : " + hal.ToString() + "/" + ttlHal.ToString()).PadRight(11) + lap.PrintVerticalLine());
lap.PROW(true, 1, lap.PrintTLeft() + lap.PrintHorizontalLine(41) + lap.PrintTBottom()
+ lap.PrintHorizontalLine(41) + lap.PrintTRight());
lap.PROW(true, 1, lap.PrintVerticalLine() + "No. Prk".PadRight(10) + lap.PadCenter(58, "URAIAN") + lap.SPACE(15) + lap.PrintVerticalLine());
lap.PROW(true, 1, lap.PrintTLeft() + lap.PrintHorizontalLine(83) + lap.PrintTRight());
}
#endregion
jumlah = Convert.ToDouble(dr["Debet"].ToString());
lap.PROW(true, 1, lap.PrintVerticalLine() + "".PadRight(10) + dr["Keterangan"].ToString().ToUpper().PadRight(58).Substring(0, 58) + jumlah.ToString("#,###").PadLeft(15) + lap.PrintVerticalLine());
total += Convert.ToDouble(dr["Debet"].ToString());
no++;
rowNo++;
cetak = false;
if (hal == ttlHal && 10 - no > 0 && rowNo == ttlData)
{
for (int j = 0; j < 10 - no; j++)
{
lap.PROW(true, 1, lap.PrintVerticalLine() + lap.SPACE(83) + lap.PrintVerticalLine());
}
}
#region footer
if (ttlData == rowNo || no == 10)
{
prevHal = hal;
hal++;
no = 0;
cetak = true;
lap.PROW(true, 1, lap.PrintTLeft() + lap.PrintHorizontalLine(83) + lap.PrintTRight());
lap.PROW(true, 1, lap.PrintVerticalLine() + "Terbilang".PadRight(58) + "Jumlah Rp.".PadRight(10) +
total.ToString("#,###").PadLeft(15) + lap.PrintVerticalLine());
lap.PROW(true, 1, lap.PrintTLeft() + lap.PrintHorizontalLine(83) + lap.PrintTRight());
lap.PROW(true, 1, lap.PrintVerticalLine() + Tools.Terbilang(total).PadRight(83) + lap.PrintVerticalLine());
lap.PROW(true, 1, lap.PrintTLeft() + lap.PrintHorizontalLine(20) + lap.PrintTTOp() + lap.PrintHorizontalLine(20) + lap.PrintTTOp()
+ lap.PrintHorizontalLine(20) + lap.PrintTTOp() + lap.PrintHorizontalLine(20) + lap.PrintTRight());
lap.PROW(true, 1, lap.PrintVerticalLine() + lap.PadCenter(20, "Pembukuan") + lap.PrintVerticalLine() + lap.PadCenter(20, "Mengetahui")
+ lap.PrintVerticalLine() + lap.PadCenter(20, "Kasir") + lap.PrintVerticalLine() + lap.PadCenter(20, "Penerima") + lap.PrintVerticalLine());
lap.PROW(true, 1, lap.PrintVerticalLine() + lap.PadCenter(20, "") + lap.PrintVerticalLine() + lap.PadCenter(20, "")
+ lap.PrintVerticalLine() + lap.PadCenter(20, "") + lap.PrintVerticalLine() + lap.PadCenter(20, "") + lap.PrintVerticalLine());
lap.PROW(true, 1, lap.PrintVerticalLine() + lap.PadCenter(20, "") + lap.PrintVerticalLine() + lap.PadCenter(20, "")
+ lap.PrintVerticalLine() + lap.PadCenter(20, "") + lap.PrintVerticalLine() + lap.PadCenter(20, "") + lap.PrintVerticalLine());
lap.PROW(true, 1, lap.PrintVerticalLine() + lap.PadCenter(20, "") + lap.PrintVerticalLine() + lap.PadCenter(20, "")
+ lap.PrintVerticalLine() + lap.PadCenter(20, "") + lap.PrintVerticalLine() + lap.PadCenter(20, "") + lap.PrintVerticalLine());
lap.PROW(true, 1, lap.PrintVerticalLine() + "(" + lap.PadCenter(18, "") + ")" + lap.PrintVerticalLine() + "(" + lap.PadCenter(18, "")
+ ")" + lap.PrintVerticalLine() + "(" + lap.PadCenter(18, _Kasir.Trim()) + ")" + lap.PrintVerticalLine() + "(" + lap.PadCenter(18, "") + ")" +
lap.PrintVerticalLine());
lap.PROW(true, 1, lap.PrintBottomLeftCorner() + lap.PrintHorizontalLine(20) + lap.PrintTBottom() + lap.PrintHorizontalLine(20) + lap.PrintTBottom()
+ lap.PrintHorizontalLine(20) + lap.PrintTBottom() + lap.PrintHorizontalLine(20) + lap.PrintBottomRightCorner());
lap.PROW(true, 1, String.Format("{0:yyyyMMddhhmmss}", DateTime.Now) + " " + SecurityManager.UserName);
lap.Eject();
}
#endregion
}
//UPDATE NPRINT
using (Database db = new Database(GlobalVar.DBName))
{
VoucherJournal.UpdateNPrint(db, _rowID, nprint + 1);
}
//REFRESH ROW HEADER
RefreshRowHeader(_rowID);
lap.SendToPrinter("laporanPS.txt");
//lap.SendToFile("laporanPS.txt");
}
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 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);
}
}
}
private void cmdDelete_Click(object sender, EventArgs e)
{
if (selectMode == enumSelectMode.Header)
{
if (gridHeader.SelectedCells.Count > 0)
{
DateTime _Tanggal = (DateTime)gridHeader.SelectedCells[0].OwningRow.Cells["hdrTglVoucher"].Value;
if (_Tanggal.Date != GlobalVar.DateOfServer.Date)
{
KotakPesan.Warning("Tanggal server tidak sama dengan tanggal transaksi. \n Tidak bisa hapus transaksi");
return;
}
if (PeriodeClosing.IsKasirClosed(_Tanggal))
{
MessageBox.Show("Sudah Closing!");
return;
}
Guid rowID = (Guid)gridHeader.SelectedCells[0].OwningRow.Cells["hdrRowID"].Value;
if ((int)dtDetail.Compute("count(Nomor)", "") > 0)
{
KotakPesan.Warning("Sudah ada record di detail, tidak bisa hapus record. \n Silahkan hapus record detail terlebih dahulu.");
return;
}
if (MessageBox.Show("Data Ini Akan Dihapus?", "", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
if (!SecurityManager.AskPasswordManager())
{
return;
}
else
{
try
{
using (Database db = new Database(GlobalVar.DBFinance))
{
VoucherJournal.DeleteVoucherJournal(db, rowID);
}
#region "Tambahan"
int i = 0;
int n = 0;
i = gridHeader.SelectedCells[0].RowIndex;
n = gridHeader.SelectedCells[0].ColumnIndex;
DataRowView dv = (DataRowView)gridHeader.SelectedCells[0].OwningRow.DataBoundItem;
DataRow dr = dv.Row;
dr.Delete();
dtHeader.AcceptChanges();
gridHeader.Focus();
gridHeader.RefreshEdit();
if (gridHeader.RowCount > 0)
{
if (i == 0)
{
gridHeader.CurrentCell = gridHeader.Rows[0].Cells[n];
gridHeader.RefreshEdit();
}
else
{
gridHeader.CurrentCell = gridHeader.Rows[i - 1].Cells[n];
gridHeader.RefreshEdit();
}
}
#endregion
}
catch (Exception ex)
{
Error.LogError(ex);
}
}
}
}
}
else
{
if (gridDetail.SelectedCells.Count > 0)
{
DateTime _Tanggal = (DateTime)gridHeader.SelectedCells[0].OwningRow.Cells["hdrTglVoucher"].Value;
if (PeriodeClosing.IsKasirClosed(_Tanggal))
{
MessageBox.Show("Sudah Closing!");
return;
}
if (MessageBox.Show("Apakah giro ini tidak jadi dititipkan?", "", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
Guid _GiroID = (Guid)gridDetail.SelectedCells[0].OwningRow.Cells["GiroID"].Value;
Guid _RowID = (Guid)gridHeader.SelectedCells[0].OwningRow.Cells["hdrRowID"].Value;
try
{
using (Database db = new Database(GlobalVar.DBFinance))
{
db.Commands.Add(db.CreateCommand("usp_Giro_BatalTitip"));
db.Commands[0].Parameters.Add(new Parameter("@GiroID", SqlDbType.UniqueIdentifier, _GiroID));
db.Commands[0].Parameters.Add(new Parameter("@LastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID));
db.Commands[0].ExecuteNonQuery();
}
HeaderRowRefresh(_RowID);
#region "Tambahan"
int i = 0;
int n = 0;
i = gridDetail.SelectedCells[0].RowIndex;
n = gridDetail.SelectedCells[0].ColumnIndex;
DataRowView dv = (DataRowView)gridDetail.SelectedCells[0].OwningRow.DataBoundItem;
DataRow dr = dv.Row;
dr.Delete();
dtDetail.AcceptChanges();
gridDetail.Focus();
gridDetail.RefreshEdit();
if (gridDetail.RowCount > 0)
{
if (i == 0)
{
gridDetail.CurrentCell = gridDetail.Rows[0].Cells[n];
gridDetail.RefreshEdit();
}
else
{
gridDetail.CurrentCell = gridDetail.Rows[i - 1].Cells[n];
gridDetail.RefreshEdit();
}
}
#endregion
}
catch (Exception ex)
{
Error.LogError(ex);
}
}
}
}
}
private void cmdSave_Click(object sender, EventArgs e)
{
try
{
if (lookupBank1.BankID == "" || lookupBank1.BankID == "[CODE]")
{
MessageBox.Show(Messages.Error.InputRequired);
lookupBank1.Focus();
return;
}
if (formMode == enumFormMode.New)
{
DateTime _Tanggal = tbTanggal.DateValue.Value;
if (PeriodeClosing.IsKasirClosed(_Tanggal))
{
MessageBox.Show("Sudah Closing!");
return;
}
RowID = Guid.NewGuid();
string RecordID = Tools.CreateFingerPrint(GlobalVar.PerusahaanID, SecurityManager.UserInitial);
using (Database db = new Database(GlobalVar.DBName))
{
VoucherJournal.AddHeader(db, RowID, Guid.Empty, RecordID, "TT", (DateTime)tbTanggal.DateValue, Numerator.BookNumerator("VTG"), tbUraian1.Text, tbUraian2.Text, tbUraian3.Text, tbDibuat.Text, tbDibukukan.Text, tbMengetahui.Text, lookupBank1.BankID, lookupBank1.NamaBank, 0, true);
}
}
else
{
using (Database db = new Database(GlobalVar.DBName))
{
db.Commands.Add(db.CreateCommand("usp_VoucherJournal_UPDATE"));
db.Commands[0].Parameters.Add(new Parameter("@RowID", SqlDbType.UniqueIdentifier, RowID));
db.Commands[0].Parameters.Add(new Parameter("@BankID", SqlDbType.VarChar, lookupBank1.BankID));
db.Commands[0].Parameters.Add(new Parameter("@NamaBank", SqlDbType.VarChar, lookupBank1.NamaBank));
db.Commands[0].Parameters.Add(new Parameter("@Uraian1", SqlDbType.VarChar, tbUraian1.Text));
db.Commands[0].Parameters.Add(new Parameter("@Uraian2", SqlDbType.VarChar, tbUraian2.Text));
db.Commands[0].Parameters.Add(new Parameter("@Uraian3", SqlDbType.VarChar, tbUraian3.Text));
db.Commands[0].Parameters.Add(new Parameter("@Dibukukan", SqlDbType.VarChar, tbDibukukan.Text));
db.Commands[0].Parameters.Add(new Parameter("@Mengetahui", SqlDbType.VarChar, tbMengetahui.Text));
db.Commands[0].Parameters.Add(new Parameter("@LastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID));
db.Commands.Add(db.CreateCommand("usp_GIRO_Titip_UPDATE"));
db.Commands[1].Parameters.Add(new Parameter("@TitipID", SqlDbType.UniqueIdentifier, RowID));
db.Commands[1].Parameters.Add(new Parameter("@BankID", SqlDbType.VarChar, lookupBank1.BankID));
db.Commands[1].Parameters.Add(new Parameter("@NamaBanki", SqlDbType.VarChar, lookupBank1.NamaBank));
db.Commands[1].Parameters.Add(new Parameter("@LastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID));
db.BeginTransaction();
db.Commands[0].ExecuteNonQuery();
db.Commands[1].ExecuteNonQuery();
db.CommitTransaction();
}
}
frmVoucherGiroTitipanBrowse frm = new frmVoucherGiroTitipanBrowse();
frm = (frmVoucherGiroTitipanBrowse)Caller;
frm.HeaderRowRefresh(RowID);
frm.HeaderFindRow("hdrRowID", RowID.ToString());
this.Close();
}
catch (Exception ex)
{
Error.LogError(ex);
}
}
