private void gridVoucher_DoubleClick(object sender, EventArgs e) { //if (gridVoucher.SelectedCells[0].OwningRow.Cells["InfoToko"].Value.ToString() == "") //{ // MessageBox.Show("Belum iden ke Toko"); // return; //} if (gridVoucher.SelectedCells.Count > 0) { DataTable dtcg = new DataTable(GlobalVar.DBName); _GiroID = new Guid(gridVoucher.SelectedCells[0].OwningRow.Cells["GiroID"].Value.ToString()); /*tambahan cek pin giro*/ try { this.Cursor = Cursors.WaitCursor; using (Database db = new Database(GlobalVar.DBName)) { db.Commands.Add(db.CreateCommand("usp_PinGiro_CEK")); db.Commands[0].Parameters.Add(new Parameter("@GiroID", SqlDbType.UniqueIdentifier, _GiroID)); dtcg = db.Commands[0].ExecuteDataTable(); } } catch (System.Exception ex) { Error.LogError(ex); } finally { this.Cursor = Cursors.Default; } if (dtcg.Rows.Count > 0) { MessageBox.Show("Untuk Pencairan Giro harus minta Pin ke HO."); string _pinKey = GetKey(_GiroID.ToString(), GlobalVar.Gudang, 31); PengajuanPinGiro(dtcg, _pinKey); pin.frmPinMd5 ifrmpin = new pin.frmPinMd5(this, _GiroID, GlobalVar.Gudang, 31, "Untuk Pencairan Giro harus minta Pin ke HO."); ifrmpin.ShowDialog(); if (ifrmpin.DialogResult == DialogResult.OK) { try { this.Cursor = Cursors.WaitCursor; using (Database db = new Database(GlobalVar.DBName)) { db.Commands.Add(db.CreateCommand("usp_PinGiro_UPDATE")); db.Commands[0].Parameters.Add(new Parameter("@GiroID", SqlDbType.UniqueIdentifier, _GiroID)); db.Commands[0].ExecuteNonQuery(); } this.Close(); } catch (System.Exception ex) { Error.LogError(ex); } finally { this.Cursor = Cursors.Default; this.Close(); } } else { this.DialogResult = DialogResult.No; this.Close(); return; } } /*end tambahan*/ //if (gridVoucher.SelectedCells[0].OwningRow.Cells["InfoToko"].Value.ToString() == "") //{ // MessageBox.Show("Belum iden ke Toko"); // return; //} string _BankID = "", _BankIDBBM = ""; _BankID = gridVoucher.SelectedCells[0].OwningRow.Cells["BankID"].Value.ToString(); _BankIDBBM = gridVoucher.SelectedCells[0].OwningRow.Cells["BankIDBBM"].Value.ToString(); //if (_BankID != _BankIDBBM) //{ // MessageBox.Show("BankID Giro Tidak Sama Dengan BankID BBM"); // gridVoucher.Focus(); // return; //} DateTime _tglJT = (DateTime)gridVoucher.SelectedCells[0].OwningRow.Cells["TglJTempo"].Value; this.Close(); Kasir.frmTransaksiPencairanGiro ifrmChild = new Kasir.frmTransaksiPencairanGiro(this.Caller, _GiroID, _rowIDBBM, _tglJT); Program.MainForm.RegisterChild(ifrmChild); ifrmChild.ShowDialog(); } }
private void cboTrans_SelectedValueChanged(object sender, EventArgs e) { string val_ = Tools.isNull(cboTrans.SelectedValue, "").ToString(); switch (val_) { case "": { ResetData(); } break; case "RET": { GetRetur(_KodeToko); } break; case "KPJ": { GetKoreksi(_KodeToko, "KPJ"); } break; case "KRJ": { GetKoreksi(_KodeToko, "KRJ"); } break; case "MUT": { GetNota(_KodeToko); } break; case "PLL": { GetPLL(); } break; case "POT": { GetPOT(); } break; case "ADJ": { txtDebet.Text = "0"; txtKredit.Text = "0"; txtDebet.ReadOnly = false; txtKredit.ReadOnly = false; txtNoACC.ReadOnly = false; txtNoACC.TabStop = true; txtUraian.Clear(); if (GlobalVar.Gudang != "2803" && GlobalVar.Gudang != "2808") { string _pinKey = GetKey(_HeaderID.ToString(), GlobalVar.Gudang, 29); MessageBox.Show("Input Transaksi ADJ harus menggunakan Pin." + "\n" + "Silahkan Pengajuan PIN ke HO."); PengajuanPinAdj(_HeaderID, _pinKey); pin.frmPinMd5 ifrmpin = new pin.frmPinMd5(this, _HeaderID, GlobalVar.Gudang, 29, "ADJ Piutang."); ifrmpin.ShowDialog(); if (ifrmpin.DialogResult != DialogResult.OK) { this.DialogResult = DialogResult.No; this.Close(); return; } } } break; case "DIL": { //GetDIL(_KodeToko,_NoTransaksi); Guid RowIDNota; Guid RowIDPotongan; double Saldo; Piutang.frmPotonganPenjualanBelumIden ifrmChild = new Piutang.frmPotonganPenjualanBelumIden(_KodeToko); ifrmChild.WindowState = FormWindowState.Normal; ifrmChild.ShowDialog(); if (ifrmChild.DialogResult == DialogResult.OK) { RowIDNota = ifrmChild.RowIDNota; RowIDPotongan = ifrmChild.RowIDPotongan; Saldo = ifrmChild.Saldo; Piutang.frmpotonganpenjualanidentifikasi frm = new Piutang.frmpotonganpenjualanidentifikasi(RowIDPotongan, Saldo); frm.WindowState = FormWindowState.Normal; frm.ShowDialog(); if (frm.DialogResult == DialogResult.OK) { try { DataTable dtLinkPot = new DataTable(); using (Database db = new Database()) { db.Commands.Add(db.CreateCommand("[psp_Potongan_LinkToPiutang_ISA]")); db.Commands[0].Parameters.Add(new Parameter("@potID", SqlDbType.UniqueIdentifier, RowIDPotongan)); db.Commands[0].Parameters.Add(new Parameter("@notaJualID", SqlDbType.UniqueIdentifier, _HeaderID)); db.Commands[0].Parameters.Add(new Parameter("@lastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID)); db.Commands[0].Parameters.Add(new Parameter("@NominalIden", SqlDbType.Money, frm.NomIden)); dtLinkPot = db.Commands[0].ExecuteDataTable(); } if (dtLinkPot.Rows[0]["cekNota"].ToString() == "0") { MessageBox.Show("Nota tidak ada", "Perhatian"); } else { MessageBox.Show("Potongan Berhasil Teridentifikasi", "Sukses"); } } catch (Exception ex) { Error.LogError(ex); } finally { if (this.Caller is Piutang.frmKartuPiutangBrowse) { Piutang.frmKartuPiutangBrowse frmkp = new Piutang.frmKartuPiutangBrowse(); frmkp = (Piutang.frmKartuPiutangBrowse) this.Caller; frmkp.RefreshKPiutangDetail("", _HeaderID); } //Piutang.frmKartuPiutangBrowse frmkp = new Piutang.frmKartuPiutangBrowse(); //frmkp.search_kp(_HeaderID.ToString(),_KodeToko); this.Close(); } } } } break; } }
private void cmdSAVE_Click(object sender, EventArgs e) { double nRpBayar = 0; if (txtBayar.Text.ToString().Trim() != "" && txtBayar.Text.ToString().Trim() != "0") { nRpBayar = Convert.ToDouble(txtBayar.Text.ToString()); } if (nRpNota != nRpBayar) { string _pinKey = GetKey(_rowID.ToString(), GlobalVar.Gudang, 26); MessageBox.Show("Nominal Nota beda dengan nominal Pembayaran kasir." + "\n" + "Silahkan Pengajuan PIN ke HO."); PengajuanPinPenjualanTunai(_rowID, nRpBayar, _pinKey); pin.frmPinMd5 ifrmpin = new pin.frmPinMd5(this, _rowID, GlobalVar.Gudang, 26, "Rp Nota beda dengan Rp Bayar"); ifrmpin.ShowDialog(); if (ifrmpin.DialogResult != DialogResult.OK) { this.DialogResult = DialogResult.No; this.Close(); return; } } string rpNet3 = dt.Rows[0]["RpNet3"].ToString(); double n = double.Parse(rpNet3) - double.Parse(txtBayar.Text); txtPLL.Text = (0).ToString(); txtPot.Text = (0).ToString(); if (n > 0 && n <= 1000) { txtPot.Text = n.ToString(); } if (n < 0 && n >= -1000) { txtPLL.Text = Math.Abs(n).ToString(); } try { this.Cursor = Cursors.WaitCursor; using (Database db = new Database()) { db.Commands.Add(db.CreateCommand("psp_PJT_LinkToKasir_ISA")); db.Commands[0].Parameters.Add(new Parameter("@nilaiBayar", SqlDbType.Money, double.Parse(txtBayar.Text))); db.Commands[0].Parameters.Add(new Parameter("@notaID", SqlDbType.UniqueIdentifier, _rowID)); db.Commands[0].Parameters.Add(new Parameter("@noPerkiraan", SqlDbType.VarChar, txtNoPerkiraan.Text)); db.Commands[0].Parameters.Add(new Parameter("@uraian", SqlDbType.VarChar, txtUraian.Text)); db.Commands[0].Parameters.Add(new Parameter("@nilaiPOT", SqlDbType.Money, double.Parse(txtPot.Text))); db.Commands[0].Parameters.Add(new Parameter("@nilaiPLL", SqlDbType.Money, double.Parse(txtPLL.Text))); db.Commands[0].Parameters.Add(new Parameter("@lastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID)); db.Commands[0].ExecuteNonQuery(); } MessageBox.Show("Data telah disimpan"); this.DialogResult = DialogResult.OK; this.Close(); } catch (Exception ex) { Error.LogError(ex); } finally { this.Cursor = Cursors.Default; } }