예제 #1
0
        private void cmdSave_Click(object sender, EventArgs e)
        {
            string nominal  = tbNominal.Text;
            Guid   RowID    = Guid.NewGuid();
            string RecordID = Tools.CreateFingerPrint(GlobalVar.PerusahaanID, SecurityManager.UserInitial);

            using (Database db = new Database(GlobalVar.DBFinance))
            {
                db.BeginTransaction();
                addIndenSuperDetail(db, RowID, RowIDISD, RowIDI, RowIDID, RecordID, RecordIDISD, Guid.Empty, "", Guid.Empty, "", "NP", tbTglInden.DateValue.Value, "", chbg, "", tbTglInden.DateValue.Value, (DateTime)SqlDateTime.Null, "", "", "?", nominal, "0", "0");
                db.CommitTransaction();
            }
            frmPenerimaanBelumTeridentifikasiBrowse frm = new frmPenerimaanBelumTeridentifikasiBrowse();

            frm = (frmPenerimaanBelumTeridentifikasiBrowse)Caller;
            frm.IndenRowRefresh(RowIDI);
            frm.IndenDetailRowRefresh(RowIDID);
            frm.IndenSubDetailRowRefresh(RowIDISD);
            frm.IndenSuperDetailRowRefresh(RowID);
            frm.IndenSuperDetailFindRow("RowIDISSD", RowID.ToString());
            this.Close();
        }
예제 #2
0
        private void cmdSave_Click(object sender, EventArgs e)
        {
            if (lookupNotaPiutang1.KPID == Guid.Empty)
            {
                MessageBox.Show("No Nota Belum Diisi");
                lookupNotaPiutang1.Focus();
                return;
            }
            if (tbRpTagih.GetDoubleValue < tbRpInden.GetDoubleValue)
            {
                MessageBox.Show("Jumlah Rp Inden Tidak Boleh Melebihi Tagihan(" + tbRpTagih.Text + ")");
                tbRpInden.Focus();
                return;
            }
            if (tbRpInden.GetDoubleValue > Convert.ToDouble(RpInden))
            {
                MessageBox.Show("Jumlah Rp Inden Tidak Boleh Melebihi Nilai Identifikasi (" + Convert.ToDouble(RpInden).ToString("#,###") + ")");
                tbRpInden.Focus();
                return;
            }

            if (tbRpInden.GetDoubleValue == 0)
            {
                MessageBox.Show("Jumlah Rp Inden Tidak Boleh 0");
                tbRpInden.Focus();
                return;
            }

            DateTime _Tanggal = (DateTime)tbTglInden.DateValue;

            if (PeriodeClosing.IsPJTClosed(_Tanggal))
            {
                MessageBox.Show("Sudah Closing!");
                return;
            }
            using (Database db = new Database())
            {
                db.Commands.Add(db.CreateCommand("usp_GetTokoIDWil"));
                db.Commands[0].Parameters.Add(new Parameter("@kodetoko", SqlDbType.VarChar, kodeToko));
                dtIDWil = db.Commands[0].ExecuteDataTable();
            }

            //string kodeTrn = "COL" + dtIDWil.Rows[0]["WilID"].ToString().Substring(0, 1);
            string kodeTrn      = "PJT";
            string dNoPerkiraan = Perkiraan.GetPerkiraanKoneksiDetail(kodeTrn).Rows[0]["NoPerkiraan"].ToString();

            RowIDISSD = Guid.NewGuid();
            RecordID  = Tools.CreateFingerPrint(GlobalVar.PerusahaanID, SecurityManager.UserInitial);
            try
            {
                using (Database db = new Database(GlobalVar.DBFinance))
                {
                    db.BeginTransaction();
                    //insert indensuperdetail

                    addIndenSuperDetail(db, RowIDISSD, RowIDISD, RowIDI, RowIDID, RecordID
                                        , HRecordID, lookupNotaPiutang1.TagihDetailID
                                        , lookupNotaPiutang1.TagihDetailRecID, lookupNotaPiutang1.KPID
                                        , lookupNotaPiutang1.KPrecID, lookupNotaPiutang1.Jenis, tglBPP, noReg
                                        , chbg, noBukti, (DateTime)tbTglInden.DateValue
                                        , (DateTime)tbTglJTempo.DateValue, "", "", dNoPerkiraan
                                        , tbRpInden.Text, tbRpNota.Text, tbRpTagih.Text);

                    if (lookupNotaPiutang1.Jenis == "KP")
                    {
                        insertKPiutangDetail(db);
                    }
                    else
                    {
                        insertGtolakDetail(db);
                    }

                    //if (GlobalVar.Gudang != "2803")
                    //{
                    //    updateTagihanDetail(db);
                    //    insertTagihanSubDetail(db);
                    //}
                    db.CommitTransaction();
                }

                //tutup sementara
                frmPenerimaanBelumTeridentifikasiBrowse frm = new frmPenerimaanBelumTeridentifikasiBrowse();
                frm = (frmPenerimaanBelumTeridentifikasiBrowse)Caller;
                frm.IndenRowRefresh(RowIDI);
                frm.IndenDetailRowRefresh(RowIDID);
                frm.IndenSubDetailRowRefresh(RowIDISD);
                frm.IndenSuperDetailRowRefresh(RowIDISSD);
                frm.IndenSuperDetailFindRow("RowIDISSD", RowIDISSD.ToString());
                this.Close();
            }
            catch (Exception ex)
            {
                Error.LogError(ex);
            }
        }