示例#1
0
        //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);
            }
        }
示例#2
0
        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();
        }