//finally //{ // if (this.Caller.Name=="frmBKMBrowse") // { // frmBKMBrowse frm = new frmBKMBrowse(); // frm = (frmBKMBrowse)this.Caller; // frm.DetailRefresh(); // frm.FindRowDetail("rowIDD", refRowIDDetail.ToString()); // } // else if (this.Caller.Name == "frmBKKBrowse") // { // frmBKKBrowse frm = new frmBKKBrowse(); // frm = (frmBKKBrowse)this.Caller; // // } // else if (this.Caller.Name == "frmVoucherJournalBrowse") // { // frmVoucherJournalBrowse frm = new frmVoucherJournalBrowse(); // frm = (frmVoucherJournalBrowse)this.Caller; // frm.RefreshDetail(); // frm.FindRowDetail("dtlRowID", refRowIDDetail.ToString()); // } // this.Close(); //} private void frmBuktiHILink_Load(object sender, EventArgs e) { try { DataTable dtCabang = new DataTable(); using (Database db = new Database(GlobalVar.DBFinance)) { db.Commands.Add(db.CreateCommand("usp_DKNCabang_List")); dtCabang = db.Commands[0].ExecuteDataTable(); } dtCabang.DefaultView.Sort = "KodeCabang"; CabangDKN.DataSource = dtCabang.DefaultView.ToTable(); CabangDKN.DisplayMember = "KodeCabang"; tbRpIdentifikasi.Text = jumlah.ToString(); CabangDKN.Focus(); } catch (Exception ex) { Error.LogError(ex); } }
private void cmdOK_Click(object sender, EventArgs e) { if (CabangDKN.Text == "") { MessageBox.Show("Cabang belum diisi."); CabangDKN.Focus(); return; } if (tbRpIdentifikasi.GetDoubleValue == 0) { MessageBox.Show("Rp Identifikasi Tidak Boleh 0."); tbRpIdentifikasi.Focus(); return; } if (tbRpIdentifikasi.GetDoubleValue > jumlah) { MessageBox.Show("Rp Identifikasi Tidak Boleh lebih dari " + jumlah.ToString("#,###")); tbRpIdentifikasi.Focus(); return; } cabang = CabangDKN.Text; double rpIdentifikasi = tbRpIdentifikasi.GetDoubleValue; DataTable dtCek = new DataTable(); dtCek = DKN.CekLinkDKN(refRowIDHeader, cabang); Guid _rowID = new Guid(); String _recordID = ""; using (Database db = new Database(GlobalVar.DBFinance)) { db.BeginTransaction(); if (dtCek.Rows.Count == 0) { _rowID = Guid.NewGuid(); _recordID = refRecordIDHeader.Trim() + cabang.Substring(0, 2); DKN.DKNInsert(db, _rowID, _recordID, DK, refTipe, CD, src, DateTime.Today, cabang, refNoBukti, refRowIDHeader); } else { DataTable dtCekDet = new DataTable(); dtCekDet = dtCek.Copy(); dtCekDet.DefaultView.RowFilter = "RefRowID='" + refRowIDDetail.ToString() + "'"; if (dtCekDet.DefaultView.Count > 0) { MessageBox.Show("Sudah Pernah Link ke Cabang " + cabang + "."); return; } _rowID = (Guid)dtCek.Rows[0][0]; _recordID = dtCek.Rows[0][1].ToString(); } DKN.DKNDetailInsert(db, _rowID, _recordID, noPerkiraan, uraian, rpIdentifikasi, refRowIDDetail, refRecordIDDetail.Trim() + cabang.Substring(0, 2)); DKN.UpdateKodeLink(db, refRowIDDetail, "#", namaSP, ""); db.CommitTransaction(); } this.Close(); }