private void RefreshHeader() { if (Brow == enumBrow.Header && Modus == enumModus.New) { dateDKN.DateValue = DateTime.Today; cboCabang.Text = ""; } else { frmDebetKreditNotaBrowse frmCaller = (frmDebetKreditNotaBrowse)this.Caller; dateDKN.DateValue = Convert.ToDateTime(frmCaller.gridUtm.SelectedCells[0].OwningRow.Cells["Tanggal"].Value); txtNoDKN.Text = frmCaller.gridUtm.SelectedCells[0].OwningRow.Cells["No_dkn"].Value.ToString(); cboCabang.SelectedValue = frmCaller.gridUtm.SelectedCells[0].OwningRow.Cells["Cabang"].Value.ToString(); optDebet.Checked = frmCaller.gridUtm.SelectedCells[0].OwningRow.Cells["Dk"].Value.ToString() == "D"; optKredit.Checked = frmCaller.gridUtm.SelectedCells[0].OwningRow.Cells["Dk"].Value.ToString() == "K"; } dateDKN.Enabled = Brow == enumBrow.Header; txtNoDKN.Enabled = Brow == enumBrow.Header; cboCabang.Enabled = Brow == enumBrow.Header; optDebet.Enabled = Brow == enumBrow.Header; optKredit.Enabled = Brow == enumBrow.Header; txtPerkiraan.Enabled = Brow == enumBrow.Detail; txtUraian.Enabled = Brow == enumBrow.Detail; numJumlah.Enabled = Brow == enumBrow.Detail; txtCollector.Enabled = Brow == enumBrow.Detail; lookupBankAsal1.Enabled = Brow == enumBrow.Detail; lookupBankTujuan.Enabled = Brow == enumBrow.Detail; }
private void InsertDataDetail() { frmDebetKreditNotaBrowse frmCaller = (frmDebetKreditNotaBrowse)this.Caller; if (_IsiPin == "") { string NoPerkiraan = txtPerkiraan.NoPerkiraan; string Uraian = txtUraian.Text; Double Jumlah = Convert.ToDouble(numJumlah.Text); string KodeKolektor = txtCollectorID.Text; string Kolektor = txtCollector.Text; if (Modus == enumModus.New) { _DetailID = Guid.NewGuid(); _RecIDDetail = Tools.CreateShortFingerPrint(GlobalVar.PerusahaanID, SecurityManager.UserInitial, 1); } using (Database db = new Database(GlobalVar.DBName)) { DKN.DKNDetailInsert(db, _DetailID, _HeaderID, _RecID, NoPerkiraan, Uraian, Jumlah, _DetailID, _RecIDDetail, KodeKolektor, _BankIDtujuan, _BankTujuanRowID, _BankKotaRowID, _KodeToko); } frmCaller.RefreshDknDetail(); } }
private void InsertDataHeader() { frmDebetKreditNotaBrowse frmCaller = (frmDebetKreditNotaBrowse)this.Caller; if (Modus == enumModus.New) { _HeaderID = Guid.NewGuid(); _RecID = Tools.CreateShortFingerPrint(GlobalVar.PerusahaanID, SecurityManager.UserInitial, 1); } DateTime TglBukti = Convert.ToDateTime(dateDKN.DateValue); string Cabang = txtGudang.Text; string DK = ""; if (optDebet.Checked) { DK = "D"; } else { DK = "K"; } using (Database db = new Database(GlobalVar.DBName)) { //if (Modus == enumModus.Update) RowIDDKN = _HeaderID; DKN.DKNInsert(db, _HeaderID, _RecID, DK, "MAN", "B", "DKN", TglBukti, Cabang, "", _HeaderID); } frmCaller.RefreshDkn(); }
private void RefreshDetail() { frmDebetKreditNotaBrowse frmCaller = (frmDebetKreditNotaBrowse)this.Caller; if (Modus == enumModus.New) { txtPerkiraan.NoPerkiraan = ""; txtUraian.Text = ""; numJumlah.Text = Convert.ToString(0); } else { txtPerkiraan.NoPerkiraan = Tools.isNull(frmCaller.gridDetail.SelectedCells[0].OwningRow.Cells["No_perk"].Value, "").ToString(); txtUraian.Text = frmCaller.gridDetail.SelectedCells[0].OwningRow.Cells["Uraian"].Value.ToString(); numJumlah.Text = frmCaller.gridDetail.SelectedCells[0].OwningRow.Cells["Jumlah"].Value.ToString(); _RecIDDetail = frmCaller.gridDetail.SelectedCells[0].OwningRow.Cells["RecordIDD"].Value.ToString(); if (txtPerkiraan.NoPerkiraan != "" && txtPerkiraan.NoPerkiraan != "[CODE]") { dtPerkiraan = Class.Perkiraan.GetPerkiraan(txtPerkiraan.NoPerkiraan); DataRow dr = dtPerkiraan.Rows[0]; txtPerkiraan.NamaPerkiraan = dr["NamaPerkiraan"].ToString(); } else { txtPerkiraan.NamaPerkiraan = ""; } txtCollector.Text = frmCaller.gridDetail.SelectedCells[0].OwningRow.Cells["Nama"].Value.ToString(); txtCollectorID.Text = frmCaller.gridDetail.SelectedCells[0].OwningRow.Cells["KodeKolektor"].Value.ToString(); lookupBankTujuan.NamaBank = frmCaller.gridDetail.SelectedCells[0].OwningRow.Cells["NamaBankTujuan"].Value.ToString(); lookupBankTujuan.BankID = frmCaller.gridDetail.SelectedCells[0].OwningRow.Cells["BankIDTujuan"].Value.ToString(); lookupBankAsal1.NamaBank = frmCaller.gridDetail.SelectedCells[0].OwningRow.Cells["NamaBank"].Value.ToString(); lookupBankAsal1.Lokasi = frmCaller.gridDetail.SelectedCells[0].OwningRow.Cells["Lokasi"].Value.ToString(); lookupToko1.NamaToko = frmCaller.gridDetail.SelectedCells[0].OwningRow.Cells["NamaToko"].Value.ToString(); lookupToko1.KodeToko = frmCaller.gridDetail.SelectedCells[0].OwningRow.Cells["KodeToko"].Value.ToString(); _BankKotaRowID = new Guid(Tools.isNull(frmCaller.gridDetail.SelectedCells[0].OwningRow.Cells["BankKotaRowID"].Value, Guid.Empty).ToString()); lookupBankTujuan.RowID = new Guid(Tools.isNull(frmCaller.gridDetail.SelectedCells[0].OwningRow.Cells["BankTujuanRowID"].Value, Guid.Empty).ToString()); if (_IsiPin == "1") { dateDKN.ReadOnly = true; dateDKN.TabStop = false; txtNoDKN.Enabled = true; txtNoDKN.ReadOnly = false; txtNoDKN.TabStop = true; txtGudang.Enabled = false; txtGudang.TabStop = false; optDebet.Enabled = false; optDebet.TabStop = false; optKredit.Enabled = false; optKredit.TabStop = false; txtPerkiraan.Enabled = false; txtPerkiraan.TabStop = false; txtUraian.ReadOnly = true; txtUraian.TabStop = false; numJumlah.ReadOnly = true; numJumlah.TabStop = false; txtCollector.ReadOnly = true; txtCollector.TabStop = false; //lookupBankAsal.Enabled = false; lookupBankAsal.TabStop = false; } } }
private void UpdateDKN() { try { frmDebetKreditNotaBrowse frmCaller = (frmDebetKreditNotaBrowse)this.Caller; //string HRecordID = Tools.isNull(frmCaller.gridUtm.SelectedCells[0].OwningRow.Cells["RecordID"].Value, "").ToString(); string CollectorID = Tools.isNull(frmCaller.gridDetail.SelectedCells[0].OwningRow.Cells["KodeKolektor"].Value, "").ToString(); string NamaCollector = Tools.isNull(frmCaller.gridDetail.SelectedCells[0].OwningRow.Cells["Nama"].Value, "").ToString(); string noBuktiKasir = Numerator.BookNumerator("IND"); string NomorKN = Tools.isNull(frmCaller.gridUtm.SelectedCells[0].OwningRow.Cells["No_dkn"].Value, "").ToString(); string NoPerkiraan = Tools.isNull(frmCaller.gridDetail.SelectedCells[0].OwningRow.Cells["No_perk"].Value, "").ToString(); this.Cursor = Cursors.WaitCursor; using (Database db = new Database(GlobalVar.DBName)) { db.Commands.Add(db.CreateCommand("psp_DKN_LINK")); db.Commands[0].Parameters.Add(new Parameter("@NomorKN", SqlDbType.VarChar, txtNoDKN.Text)); db.Commands[0].Parameters.Add(new Parameter("@RowID", SqlDbType.UniqueIdentifier, _HeaderID)); db.Commands[0].Parameters.Add(new Parameter("@RecID", SqlDbType.VarChar, _RecID)); db.Commands[0].Parameters.Add(new Parameter("@RecIDDetail", SqlDbType.VarChar, _RecIDDetail)); db.Commands[0].Parameters.Add(new Parameter("@TglKasir", SqlDbType.DateTime, DateTime.Now)); db.Commands[0].Parameters.Add(new Parameter("@Kasir", SqlDbType.VarChar, SecurityManager.UserName)); db.Commands[0].Parameters.Add(new Parameter("@NoBukti", SqlDbType.VarChar, noBuktiKasir)); db.Commands[0].Parameters.Add(new Parameter("@NoPerkiraan", SqlDbType.VarChar, NoPerkiraan)); //db.Commands[0].Parameters.Add(new Parameter("@CollectorID", SqlDbType.VarChar, CollectorID)); //db.Commands[0].Parameters.Add(new Parameter("@NamaCollector", SqlDbType.VarChar, NamaCollector)); db.Commands[0].Parameters.Add(new Parameter("@Acc", SqlDbType.VarChar, NomorKN)); db.Commands[0].Parameters.Add(new Parameter("@SyncFlag", SqlDbType.Bit, 0)); db.Commands[0].Parameters.Add(new Parameter("@LastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserInitial)); db.Commands[0].ExecuteNonQuery(); } } catch (System.Exception ex) { Error.LogError(ex); } finally { this.Cursor = Cursors.Default; } }
private void RefreshHeader() { if (Modus == enumModus.New) { dateDKN.DateValue = DateTime.Today; txtGudang.Text = GlobalVar.Gudang; } else { frmDebetKreditNotaBrowse frmCaller = (frmDebetKreditNotaBrowse)this.Caller; dateDKN.DateValue = Convert.ToDateTime(frmCaller.gridUtm.SelectedCells[0].OwningRow.Cells["Tanggal"].Value); txtNoDKN.Text = frmCaller.gridUtm.SelectedCells[0].OwningRow.Cells["No_dkn"].Value.ToString(); txtGudang.Text = frmCaller.gridUtm.SelectedCells[0].OwningRow.Cells["Cabang"].Value.ToString(); optDebet.Checked = frmCaller.gridUtm.SelectedCells[0].OwningRow.Cells["Dk"].Value.ToString() == "D"; optKredit.Checked = frmCaller.gridUtm.SelectedCells[0].OwningRow.Cells["Dk"].Value.ToString() == "K"; _RecID = frmCaller.gridUtm.SelectedCells[0].OwningRow.Cells["RecordID"].Value.ToString(); if (Tools.isNull(_pinKey, "").ToString() != "") { txtNoDKN.Enabled = true; txtNoDKN.ReadOnly = false; } } }
private void cmdSAVE_Click(object sender, EventArgs e) { _BankTujuanRowID = lookupBankTujuan.RowID; _BankIDtujuan = lookupBankTujuan.BankID; string _KodeToko = lookupToko1.KodeToko; string lokasi = lookupBankAsal1.Lokasi; string bankID = lookupBankTujuan.BankID; try { this.Cursor = Cursors.WaitCursor; using (Database db = new Database(GlobalVar.DBName)) { DataTable dtBK = new DataTable(); db.Commands.Add(db.CreateCommand("usp_BankKota_LIST")); db.Commands[0].Parameters.Add(new Parameter("@NamaBank", SqlDbType.VarChar, lookupBankAsal1.NamaBank)); db.Commands[0].Parameters.Add(new Parameter("@Lokasi", SqlDbType.VarChar, lookupBankAsal1.Lokasi)); dtBK = db.Commands[0].ExecuteDataTable(); if (dtBK.Rows.Count > 0) { _BankKotaRowID = new Guid(dtBK.Rows[0]["RowID"].ToString()); } } } catch (System.Exception ex) { Error.LogError(ex); } finally { this.Cursor = Cursors.Default; } frmDebetKreditNotaBrowse frmCaller = (frmDebetKreditNotaBrowse)this.Caller; if (Brow == enumBrow.Header) { Guid RowID = Guid.NewGuid(); string RecordID = Tools.CreateShortFingerPrint(GlobalVar.PerusahaanID, SecurityManager.UserInitial, 1); DateTime TglBukti = Convert.ToDateTime(dateDKN.DateValue); string Cabang = cboCabang.SelectedValue.ToString(); string DK = ""; if (optDebet.Checked) { DK = "D"; } else { DK = "K"; } using (Database db = new Database(GlobalVar.DBName)) { if (Modus == enumModus.Update) { RowID = _HeaderID; } DKN.DKNInsert(db, RowID, RecordID, DK, "MAN", "B", "DKN", TglBukti, Cabang, "", RowID); } frmCaller.RefreshDkn(); } else { if (_IsiPin == "") { string NoPerkiraan = txtPerkiraan.NoPerkiraan; string Uraian = txtUraian.Text; string HRecordID = frmCaller.gridUtm.SelectedCells[0].OwningRow.Cells["RecordID"].Value.ToString(); string refRecordID = Tools.CreateShortFingerPrint(GlobalVar.PerusahaanID, SecurityManager.UserInitial, 1); Guid refRowID = Guid.NewGuid(); Double Jumlah = Convert.ToDouble(numJumlah.Text); string KodeKolektor = txtCollectorID.Text; string Kolektor = txtCollector.Text; Guid rowIDdetail; if (Modus == enumModus.New) { rowIDdetail = Guid.NewGuid(); } else { rowIDdetail = _DetailID; } using (Database db = new Database(GlobalVar.DBName)) { if (Modus == enumModus.Update) { refRowID = _DetailID; } DKN.DKNDetailInsert(db, rowIDdetail, _HeaderID, HRecordID, NoPerkiraan, Uraian, Jumlah, refRowID, refRecordID, KodeKolektor, bankID, _BankTujuanRowID, _BankKotaRowID, _KodeToko); } frmCaller.RefreshDknDetail(); } else { UpdateDKN(); } } this.Close(); }
public void Download() { int counter = 0; DataTable dtResult = new DataTable(); dtSdhDownload = dtDKN.Clone(); DataTable dt = new DataTable(); int result = 0; #region Cek IndenInput paycol try { this.Cursor = Cursors.WaitCursor; DataTable dta = new DataTable(); using (Database db = new Database()) { db.Commands.Add(db.CreateCommand("usp_AppSetting_LIST")); db.Commands[0].Parameters.Add(new Parameter("@key", SqlDbType.VarChar, "identifikasi_input")); dta = db.Commands[0].ExecuteDataTable(); if (dta.Rows.Count > 0) { IndenInput = Tools.isNull(dta.Rows[0]["value"], "true").ToString(); } } } catch (System.Exception ex) { Error.LogError(ex); } finally { this.Cursor = Cursors.Default; } #endregion #region GetBankAsal ///*Getdata bank asal*/ //string LokasiBank = lookupBankAsal1.Lokasi; //string NamaBankAsal = lookupBankAsal1.NamaBank; //try //{ // DataTable dtb = new DataTable(GlobalVar.DBName); // this.Cursor = Cursors.WaitCursor; // using (Database db = new Database(GlobalVar.DBName)) // { // db.Commands.Add(db.CreateCommand("usp_BankKota_LIST")); // db.Commands[0].Parameters.Add(new Parameter("@NamaBank", SqlDbType.VarChar, NamaBankAsal)); // db.Commands[0].Parameters.Add(new Parameter("@Lokasi", SqlDbType.VarChar, LokasiBank)); // dtb = db.Commands[0].ExecuteDataTable(); // if (dtb.Rows.Count > 0) // { // BankAsalRowID = new Guid(dtb.Rows[0]["RowID"].ToString()); // } // else // { // MessageBox.Show("Bank Kota tidak ada."); // return; // } // } //} //catch (System.Exception ex) //{ // Error.LogError(ex); //} //finally //{ // this.Cursor = Cursors.Default; //} #endregion #region insert dkn string prevIDhead = ""; Guid jHeader = Guid.NewGuid(); string jRecID = Tools.CreateFingerPrint(GlobalVar.PerusahaanID, SecurityManager.UserInitial); DataTable dtHI = Class.Perkiraan.GetPerkiraanKoneksiDetail("HI11"); double sumHI = 0; string uraian = ""; string InitGudang = GlobalVar.Gudang; progressBar1.Maximum = customGridView1.Rows.Count; foreach (DataGridViewRow row in customGridView1.Rows) { string GudangTujuan = Tools.isNull(row.Cells[Cabang.Name].Value, "").ToString(); if (GudangTujuan.ToString().Trim() == InitGudang.ToString().Trim()) { string curIDhead = row.Cells[Idhead.Name].Value.ToString(); using (Database db = new Database(GlobalVar.DBName)) { db.BeginTransaction(); db.Commands.Clear(); db.Commands.Add(db.CreateCommand("usp_DKN_Download")); db.Commands[0].Parameters.Clear(); db.Commands[0].Parameters.Add(new Parameter("@RowID", SqlDbType.UniqueIdentifier, new Guid(row.Cells[Hrowid.Name].Value.ToString()))); db.Commands[0].Parameters.Add(new Parameter("@RowIDDetail", SqlDbType.UniqueIdentifier, new Guid(row.Cells[Dtrowid.Name].Value.ToString()))); db.Commands[0].Parameters.Add(new Parameter("@HRecordID", SqlDbType.VarChar, Tools.isNull(row.Cells[Idhead.Name].Value, "").ToString())); db.Commands[0].Parameters.Add(new Parameter("@RecordID", SqlDbType.VarChar, Tools.isNull(row.Cells[Iddetail.Name].Value, "").ToString())); db.Commands[0].Parameters.Add(new Parameter("@Tanggal", SqlDbType.DateTime, GlobalVar.DateOfServer)); db.Commands[0].Parameters.Add(new Parameter("@NoDKN", SqlDbType.VarChar, Tools.isNull(row.Cells[No_Dkn.Name].Value, "").ToString())); db.Commands[0].Parameters.Add(new Parameter("@DK", SqlDbType.VarChar, Tools.isNull(row.Cells[DK.Name].Value, "").ToString())); db.Commands[0].Parameters.Add(new Parameter("@Cabang", SqlDbType.VarChar, Tools.isNull(row.Cells[Cabang.Name].Value, "").ToString())); db.Commands[0].Parameters.Add(new Parameter("@CD", SqlDbType.VarChar, Tools.isNull(row.Cells[Cd.Name].Value, "").ToString())); db.Commands[0].Parameters.Add(new Parameter("@Src", SqlDbType.VarChar, Tools.isNull(row.Cells[Src.Name].Value, "").ToString())); db.Commands[0].Parameters.Add(new Parameter("@RefTipe", SqlDbType.Int, Tools.isNull(row.Cells[Reftipe.Name].Value, "").ToString())); db.Commands[0].Parameters.Add(new Parameter("@RefNoBukti", SqlDbType.Char, Tools.isNull(row.Cells[Nobuktipu.Name].Value, "").ToString())); db.Commands[0].Parameters.Add(new Parameter("@RefRowID", SqlDbType.UniqueIdentifier, new Guid(row.Cells[Refrowid.Name].Value.ToString()))); db.Commands[0].Parameters.Add(new Parameter("@NoPerkiraan", SqlDbType.Char, Tools.isNull(row.Cells[No_perk.Name].Value, "").ToString())); db.Commands[0].Parameters.Add(new Parameter("@Uraian", SqlDbType.Char, Tools.isNull(row.Cells[Uraian.Name].Value, "").ToString())); db.Commands[0].Parameters.Add(new Parameter("@Jumlah", SqlDbType.Money, double.Parse(Tools.isNull(row.Cells[Jumlah.Name].Value, "").ToString()))); db.Commands[0].Parameters.Add(new Parameter("@Tolak", SqlDbType.Bit, 0)); db.Commands[0].Parameters.Add(new Parameter("@Alasan", SqlDbType.Char, Tools.isNull(row.Cells[Alasan.Name].Value, "").ToString())); db.Commands[0].Parameters.Add(new Parameter("@Dari", SqlDbType.Char, Tools.isNull(row.Cells[Dari.Name].Value, "").ToString())); db.Commands[0].Parameters.Add(new Parameter("@SyncFlag", SqlDbType.Bit, 1)); db.Commands[0].Parameters.Add(new Parameter("@Nprint", SqlDbType.Int, 0)); db.Commands[0].Parameters.Add(new Parameter("@LastUpdatedBy", SqlDbType.VarChar, Tools.isNull(row.Cells[Updateby.Name].Value, "").ToString())); db.Commands[0].Parameters.Add(new Parameter("@LastUpdatedTime", SqlDbType.Date, DateTime.Parse(Tools.isNull(row.Cells[Updatetime.Name].Value, "").ToString()))); db.Commands[0].ExecuteNonQuery(); #region jurnal ///*Hapus Data Lama GL dulu*/ //if (prevIDhead != curIDhead) //{ // db.Commands.Clear(); // db.Commands.Add(db.CreateCommand("psp_DKN_Download_DeleteJournal")); // db.Commands[0].Parameters.Clear(); // db.Commands[0].Parameters.Add(new Parameter("@RecordID", SqlDbType.VarChar, curIDhead.ToString())); // db.Commands[0].ExecuteNonQuery(); //} //bool tolak = Convert.ToBoolean(row.Cells[Ltolak.Name].Value); //if (!tolak) //{ // string cd = row.Cells[DK.Name].Value.ToString(); // string noDKNPerk = ""; //row.Cells[No_Dkn.Name].Value.ToString().Trim(); // string namaDKNPerk = ""; // if (noDKNPerk != "") // { // DataTable dtPerk = Class.Perkiraan.GetPerkiraan(noDKNPerk); // if (dtPerk.Rows.Count > 0) // { // namaDKNPerk = dtPerk.Rows[0]["NamaPerkiraan"].ToString(); // } // } // else // { // namaDKNPerk = ""; // } // /*Header*/ // if (prevIDhead != curIDhead) // { // /*create data baru*/ // sumHI = 0; // jHeader = Guid.NewGuid(); // jRecID = row.Cells[Idhead.Name].Value.ToString(); // DateTime tglJournal = Convert.ToDateTime(row.Cells[Tanggal.Name].Value.ToString()); // string noReff = Tools.isNull(row.Cells[No_Dkn.Name].Value, "").ToString(); // uraian = "LINK HUTANG HI " + noReff; // Class.Journal.AddHeader(db, jHeader, jRecID, tglJournal, noReff, uraian, "DKN", GlobalVar.Gudang, false); // prevIDhead = curIDhead; // } // /*Debet*/ // Guid jdRowID = Guid.NewGuid(); // string jdRecID = row.Cells[Iddetail.Name].Value.ToString(); // string noPerk = noDKNPerk; // string dk = ""; // string jdUraian1 = Tools.isNull(row.Cells[Uraian.Name].Value, "").ToString(); // double debet = 0; // double kredit = 0; // if (cd == "D") // { // dk = "D"; // debet = Convert.ToDouble(row.Cells[Jumlah.Name].Value); // sumHI -= Convert.ToDouble(row.Cells[Jumlah.Name].Value); ; // } // else // { // dk = "K"; // kredit = Convert.ToDouble(row.Cells[Jumlah.Name].Value); // sumHI += Convert.ToDouble(row.Cells[Jumlah.Name].Value); // } // Class.Journal.AddDetail(db, jdRowID, jHeader, jdRecID, jRecID, noPerk, jdUraian1, debet, kredit, dk); // /*INSERT LAWAN*/ // Guid jdRowIDL = Guid.NewGuid(); // string jdRecIDL = Tools.CreateFingerPrint(GlobalVar.PerusahaanID, SecurityManager.UserInitial); // string noPerkL = dtHI.Rows[0]["NoPerkiraan"].ToString(); // string dkL = ""; // string jdUraian1L = Tools.isNull(row.Cells[Uraian.Name].Value, "").ToString(); // double debetL = 0; // double kreditL = 0; // if (sumHI > 0) // { // dkL = "D"; // debetL = Convert.ToDouble(sumHI); // } // else // { // dkL = "K"; // kreditL = Math.Abs(sumHI); // } // Class.Journal.AddDetail(db, jdRowIDL, jHeader, jdRecIDL, jRecID, noPerkL, jdUraian1L, debetL, kreditL, dkL); // sumHI = 0; //} db.CommitTransaction(); #endregion } } #region GetBankTujuan /*Getdata bank tujuan*/ NamaBankTujuan = ""; BankIDTujuan = ""; noRekening = Tools.isNull(row.Cells[Norekeningd.Name].Value, "").ToString(); try { DataTable dtb = new DataTable(GlobalVar.DBName); this.Cursor = Cursors.WaitCursor; using (Database db = new Database(GlobalVar.DBName)) { db.Commands.Clear(); db.Commands.Add(db.CreateCommand("usp_NoRekeningBank_LIST")); db.Commands[0].Parameters.Add(new Parameter("@NoRekening", SqlDbType.VarChar, noRekening)); dtb = db.Commands[0].ExecuteDataTable(); if (dtb.Rows.Count > 0) { NamaBankTujuan = Tools.isNull(dtb.Rows[0]["NamaBank"], "").ToString(); BankIDTujuan = Tools.isNull(dtb.Rows[0]["BankID"], "").ToString(); BankTujuanRowID = new Guid(Tools.isNull(dtb.Rows[0]["RowID"], "").ToString()); } else { MessageBox.Show("Bank Tujuan tidak ada."); return; } } } catch (System.Exception ex) { Error.LogError(ex); } finally { this.Cursor = Cursors.Default; } #endregion #region link data KN ditutup jika Paycoll jalan if (IndenInput == "true") { try { frmDebetKreditNotaBrowse frmCaller = (frmDebetKreditNotaBrowse)this.Caller; Guid headerRowID = new Guid(Tools.isNull(row.Cells[Hrowid.Name].Value, Guid.Empty).ToString()); Guid detailRowID = new Guid(Tools.isNull(row.Cells[Dtrowid.Name].Value, Guid.Empty).ToString()); string noDKN = Tools.isNull(row.Cells[No_Dkn.Name].Value, "").ToString(); string recordID = Tools.isNull(row.Cells[Idhead.Name].Value, "").ToString(); string recordIDD = Tools.isNull(row.Cells[Iddetail.Name].Value, "").ToString(); string updateBy = Tools.isNull(row.Cells[Updateby.Name].Value, "").ToString(); string noBukti = Tools.isNull(row.Cells[Nobuktipu.Name].Value, "").ToString(); string noPerkiraan = Tools.isNull(row.Cells[No_perk.Name].Value, "").ToString(); string namaBankAsal = Tools.isNull(row.Cells[Bankasal.Name].Value, "").ToString(); string lokasiBankAsal = Tools.isNull(row.Cells[Lokasi.Name].Value, "").ToString(); double RpTrf = double.Parse(Tools.isNull(row.Cells[Jumlah.Name].Value, "0").ToString()); DateTime LastUpdatedTime = DateTime.Parse(Tools.isNull(row.Cells[Updatetime.Name].Value, DateTime.Now).ToString()); this.Cursor = Cursors.WaitCursor; using (Database db = new Database(GlobalVar.DBName)) { db.Commands.Add(db.CreateCommand("psp_DKN_LINK")); db.Commands[0].Parameters.Add(new Parameter("@NomorKN", SqlDbType.VarChar, noDKN)); db.Commands[0].Parameters.Add(new Parameter("@RowID", SqlDbType.UniqueIdentifier, headerRowID)); db.Commands[0].Parameters.Add(new Parameter("@detailRowID", SqlDbType.UniqueIdentifier, detailRowID)); db.Commands[0].Parameters.Add(new Parameter("@RecID", SqlDbType.VarChar, recordID)); db.Commands[0].Parameters.Add(new Parameter("@RecIDDetail", SqlDbType.VarChar, recordIDD)); db.Commands[0].Parameters.Add(new Parameter("@TglKasir", SqlDbType.DateTime, GlobalVar.DateOfServer)); db.Commands[0].Parameters.Add(new Parameter("@Kasir", SqlDbType.VarChar, updateBy)); db.Commands[0].Parameters.Add(new Parameter("@NoBukti", SqlDbType.VarChar, noBukti)); db.Commands[0].Parameters.Add(new Parameter("@NoPerkiraan", SqlDbType.VarChar, noPerkiraan)); db.Commands[0].Parameters.Add(new Parameter("@Acc", SqlDbType.VarChar, noDKN)); db.Commands[0].Parameters.Add(new Parameter("@NamaBankAsal", SqlDbType.VarChar, namaBankAsal)); db.Commands[0].Parameters.Add(new Parameter("@Lokasi", SqlDbType.VarChar, lokasiBankAsal)); db.Commands[0].Parameters.Add(new Parameter("@BankAsalRowID", SqlDbType.UniqueIdentifier, BankAsalRowID)); db.Commands[0].Parameters.Add(new Parameter("@NoRekenig", SqlDbType.VarChar, noRekening)); db.Commands[0].Parameters.Add(new Parameter("@NamaBankTujuan", SqlDbType.VarChar, NamaBankTujuan)); db.Commands[0].Parameters.Add(new Parameter("@BankIDTujuan", SqlDbType.VarChar, BankIDTujuan)); db.Commands[0].Parameters.Add(new Parameter("@BankTujuanRowID", SqlDbType.UniqueIdentifier, BankTujuanRowID)); db.Commands[0].Parameters.Add(new Parameter("@RpTrf", SqlDbType.Money, RpTrf)); db.Commands[0].Parameters.Add(new Parameter("@SyncFlag", SqlDbType.Bit, 0)); db.Commands[0].Parameters.Add(new Parameter("@LastUpdatedBy", SqlDbType.VarChar, updateBy)); db.Commands[0].Parameters.Add(new Parameter("@LastUpdatedTime", SqlDbType.DateTime, LastUpdatedTime)); db.Commands[0].ExecuteNonQuery(); } } catch (System.Exception ex) { Error.LogError(ex); } finally { this.Cursor = Cursors.Default; } /*endlink.........*/ } #endregion } /*Perkiraan HI Last Check*/ if (sumHI != 0) { using (Database db = new Database(GlobalVar.DBName)) { Guid jdRowID = Guid.NewGuid(); string jdRecID = Tools.CreateFingerPrint(GlobalVar.PerusahaanID, SecurityManager.UserInitial); string noPerk = dtHI.Rows[0]["NoPerkiraan"].ToString(); string dk = ""; string jdUraian1 = uraian;//dtHI.Rows[0]["Uraian"].ToString(); double debet = 0; double kredit = 0; if (sumHI > 0) { dk = "D"; debet = sumHI; } else { dk = "K"; kredit = Math.Abs(sumHI); } Class.Journal.AddDetail(db, jdRowID, jHeader, jdRecID, jRecID, noPerk, jdUraian1, debet, kredit, dk); sumHI = 0; } } MessageBox.Show(Messages.Confirm.ProcessFinished); #endregion }