public static string DescStatusApproval(GlobalVar.enumStatusApproval statusApproval) { string result = ""; switch (statusApproval) { case GlobalVar.enumStatusApproval.Open: result = "Belum Pengajuan"; break; case GlobalVar.enumStatusApproval.Waiting1: result = "Menunggu Acc #1"; break; case GlobalVar.enumStatusApproval.Waiting2: result = "Menunggu Acc #2"; break; case GlobalVar.enumStatusApproval.Rejected: result = "Ditolak"; break; case GlobalVar.enumStatusApproval.Approved: result = "Disetujui"; break; case GlobalVar.enumStatusApproval.Closed: result = "Selesai / Realisasi"; break; default: result = ""; break; } return(result); }
private int DBGetByRowID(Guid t_rowID) { int nresult = 0; if ((t_rowID == null) || (t_rowID == Guid.Empty)) { nresult = 1; } else { try { using (Database db = new Database()) { db.Commands.Add(db.CreateCommand("usp_PengeluaranUang_LIST")); db.Commands[0].Parameters.Add(new Parameter("@RowID", SqlDbType.UniqueIdentifier, t_rowID)); DataTable dt = db.Commands[0].ExecuteDataTable(); if (dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; _dr = dr; _rowID = t_rowID; _perusahaanDariRowID = (Guid)dr["PerusahaanDariRowID"]; _perusahaanKeRowID = (Convert.IsDBNull(dr["PerusahaanKeRowID"]) ? Guid.Empty : (Guid)dr["PerusahaanKeRowID"]); _noBukti = dr["NoBukti"].ToString(); _tanggal = (Convert.IsDBNull(dr["Tanggal"])) ? DateTime.MinValue : (DateTime)dr["Tanggal"]; _dueDateGiro = (Convert.IsDBNull(dr["DueDateGiro"])) ? DateTime.MinValue : (DateTime)dr["DueDateGiro"]; _cabangDariID = dr["CabangDariID"].ToString(); _cabangKeID = (Convert.IsDBNull(dr["CabangkeID"]) ? "" : dr["CabangKeID"].ToString()); _cabangOriID = (Convert.IsDBNull(dr["CabangIDOri"]) ? _cabangKeID : dr["CabangIDOri"].ToString()); _gudangID = AutoJournal.GetGudangIDByPTRowID(_perusahaanDariRowID); _uraian = (Convert.IsDBNull(dr["Uraian"]) ? "" : dr["Uraian"].ToString()); _jnsPengeluaran = dr["JnsPengeluaran"].ToString(); // _jnsTransaksiRowID = dr["JnsTransaksiRowID"]; _pengeluaranKe = Convert.IsDBNull(dr["PengeluaranKe"]) ? 0 : int.Parse(dr["PengeluaranKe"].ToString()); _noPerkiraan01 = dr["NoPerkiraan01"].ToString(); _nominal = (Convert.IsDBNull(dr["Nominal"])) ? 0 : double.Parse(dr["Nominal"].ToString()); _nominalRp = (Convert.IsDBNull(dr["NominalRp"])) ? _nominal : double.Parse(dr["NominalRp"].ToString()); if (_nominalRp == 0) { _nominalRp = _nominal; } _statusApproval = (GlobalVar.enumStatusApproval)dr.Field <byte>("StatusApproval"); _kasRowID = (Guid)Tools.isNull(dr["KasRowID"], Guid.Empty); _rekeningRowID = (Guid)Tools.isNull(dr["RekeningRowID"], Guid.Empty); _journalRowID = (Guid)Tools.isNull(dr["JournalRowID"], Guid.Empty); _mataUangRowID = (Guid)Tools.isNull(dr["MataUangRowID"], Guid.Empty); _jnsTransaksi = (Guid)Tools.isNull(dr["JnsTransaksiRowID"], Guid.Empty); _unitusaha = dr["UnitUsaha"].ToString(); if ((_perusahaanKeRowID == Guid.Empty) || (_cabangKeID != _cabangOriID)) { GetPerusahaanKeRowID(); } SetNoPerkiraan01(); SetNoPerkiraan02(); if ((_perusahaanKeRowID != null) && (_perusahaanKeRowID != Guid.Empty) && (_perusahaanKeRowID != _perusahaanDariRowID)) { SetNoPerkiraan03(); SetNoPerkiraan04(); if (!GlobalVar.IsNewDNKN && (_jnsTransaksi != GlobalVar.GetTransaksi.PLL || _jnsTransaksi != GlobalVar.GetTransaksi.HLL)) { _journal2 = true; } } else { _journal2 = false; } _state = enumState.Update; } else { nresult = 2; } } } catch (Exception ex) { nresult = 3; string s = ex.Message; } } if (nresult != 0) { Kosongkan(); } return(nresult); }
private void cmdYES_Click(object sender, EventArgs e) { if (!cekDataSTNK()) { return; } try { if (Convert.ToDouble(txt_BBN.Text) > 0) { if (rdoKas.Checked == true && (Guid)cboKas.SelectedValue == Guid.Empty) { MessageBox.Show("Kas belum dipilih, silahkan dipilih terlebih dahulu"); return; } else if (rdoBank.Checked == true && lkpRekening1.RekeningRowID == Guid.Empty) { MessageBox.Show("Bank belum dipilih, silahkan dipilih terlebih dahulu"); return; } //PIN if (Convert.ToDouble(txt_BBN.Text) > Convert.ToDouble(txt_SisaBBN.Text)) { DateTimeFormatInfo dfi = DateTimeFormatInfo.CurrentInfo; DateTime date = GlobalVar.GetServerDate; Calendar cal = dfi.Calendar; int mingguKe = cal.GetWeekOfYear(date, dfi.CalendarWeekRule, dfi.FirstDayOfWeek); Tools.pin(PinId.Periode.Hari, mingguKe, date, PinId.Bagian.Accounting, Convert.ToInt32(PinId.ModulId.PelunasanBBN), "Pembayaran BBN melebihi sisa BBN memerlukan PIN persetujuan bagian Keuangan."); if (GlobalVar.pinResult == false) { return; } } else if (Convert.ToDouble(txt_SisaBBN.Text) - Convert.ToDouble(txt_BBN.Text) > 0) { DialogResult dialogResult = MessageBox.Show("Pelunasan BBN hanya dapat dilakukan sekali \nTerdapat sisa BBN sebesar " + (Convert.ToDouble(txt_SisaBBN.Text) - Convert.ToDouble(txt_BBN.Text)).ToString() + ", Anda yakin ingin melanjutkan transaksi ?", "Save Pelunasan BBN", MessageBoxButtons.YesNo); if (dialogResult == DialogResult.No) { return; } } Guid _bankRowID = Guid.Empty; Guid _rekeningRowID = Guid.Empty; switch (_bentukPengeluaran) { case "K": _rekeningRowID = (Guid)cboKas.SelectedValue; break; case "B": { _rekeningRowID = (Guid)lkpRekening1.RekeningRowID; _bankRowID = (Guid)lkpRekening1.BankRowID; break; } default: _rekeningRowID = (Guid)Guid.Empty; _statusApproval = GlobalVar.enumStatusApproval.Approved; break; } DataTable dt1 = new DataTable(); Guid RowIDPU = Guid.NewGuid(); using (Database db = new Database()) { db.Commands.Add(db.CreateCommand("usp_PengeluaranUang_INSERT")); db.Commands[0].Parameters.Add(new Parameter("@RowID", SqlDbType.UniqueIdentifier, RowIDPU)); db.Commands[0].Parameters.Add(new Parameter("@TanggalRk", SqlDbType.Date, GlobalVar.GetServerDate.Date)); db.Commands[0].Parameters.Add(new Parameter("@Tanggal", SqlDbType.Date, GlobalVar.GetServerDate.Date)); db.Commands[0].Parameters.Add(new Parameter("@NoAcc", SqlDbType.VarChar, "")); db.Commands[0].Parameters.Add(new Parameter("@NoApproval", SqlDbType.VarChar, "")); db.Commands[0].Parameters.Add(new Parameter("@PerusahaanDariRowID", SqlDbType.UniqueIdentifier, new Guid("F0BFEC6B-E92C-44A3-9EEB-F41960503F15"))); db.Commands[0].Parameters.Add(new Parameter("@CabangDariID", SqlDbType.VarChar, GlobalVar.CabangID)); db.Commands[0].Parameters.Add(new Parameter("@PerusahaanKeRowID", SqlDbType.UniqueIdentifier, new Guid("F0BFEC6B-E92C-44A3-9EEB-F41960503F15"))); db.Commands[0].Parameters.Add(new Parameter("@MataUangRowID", SqlDbType.UniqueIdentifier, new Guid("BC17A644-5DBD-4955-A803-378F8C0A915C"))); db.Commands[0].Parameters.Add(new Parameter("@JnsTransaksiRowID", SqlDbType.UniqueIdentifier, new Guid("CE9075B2-1206-4D8E-9F22-0D12C6DE9939"))); db.Commands[0].Parameters.Add(new Parameter("@Nominal", SqlDbType.Money, double.Parse(txt_BBN.Text))); db.Commands[0].Parameters.Add(new Parameter("@NominalRp", SqlDbType.Money, double.Parse(txt_BBN.Text))); db.Commands[0].Parameters.Add(new Parameter("@Uraian", SqlDbType.VarChar, "Pembayaran BBN - " + txt_NoBukti.Text)); db.Commands[0].Parameters.Add(new Parameter("@JnsPengeluaran", SqlDbType.VarChar, _bentukPengeluaran)); db.Commands[0].Parameters.Add(new Parameter("@JnsPenerimaan", SqlDbType.VarChar, "")); db.Commands[0].Parameters.Add(new Parameter("@StatusApproval", SqlDbType.TinyInt, (_needApprove) ? 0 : 9)); db.Commands[0].Parameters.Add(new Parameter("@KasRowID", SqlDbType.UniqueIdentifier, (_bentukPengeluaran == "K") ? _rekeningRowID : Guid.Empty)); db.Commands[0].Parameters.Add(new Parameter("@BankID", SqlDbType.UniqueIdentifier, _bankRowID)); db.Commands[0].Parameters.Add(new Parameter("@RekeningRowID", SqlDbType.UniqueIdentifier, (_bentukPengeluaran == "K") ? Guid.Empty : _rekeningRowID)); db.Commands[0].Parameters.Add(new Parameter("@KeKasRowID", SqlDbType.UniqueIdentifier, Guid.Empty)); db.Commands[0].Parameters.Add(new Parameter("@KeRekeningRowID", SqlDbType.UniqueIdentifier, Guid.Empty)); //db.Commands[0].Parameters.Add(new Parameter("@DueDateGiro", SqlDbType.Date, default)); db.Commands[0].Parameters.Add(new Parameter("@NoCekGiro", SqlDbType.VarChar, "")); db.Commands[0].Parameters.Add(new Parameter("@PengeluaranKe", SqlDbType.Int, 2)); db.Commands[0].Parameters.Add(new Parameter("@PenjualanRowID", SqlDbType.UniqueIdentifier, PenjualanRowID)); db.Commands[0].Parameters.Add(new Parameter("@lastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID)); db.Commands[0].Parameters.Add(new Parameter("@IsPembayaran", SqlDbType.Bit, 0)); dt1 = db.Commands[0].ExecuteDataTable(); if (dt1.Rows.Count > 0) { try { if (dt1.Rows[0]["Result"].ToString() != "0") { MessageBox.Show("Error (" + dt1.Rows[0]["Result"].ToString() + ") : \n" + dt1.Rows[0]["Message"].ToString() + "\n"); return; } } catch { /*string s = "Unknown Error";*/ } } } using (Database db = new Database()) { db.Commands.Add(db.CreateCommand("usp_MasterSTNK_INSERT")); db.Commands[0].Parameters.Add(new Parameter("@PembelianRowID", SqlDbType.UniqueIdentifier, PembelianRowID)); db.Commands[0].Parameters.Add(new Parameter("@PenjualanRowID", SqlDbType.UniqueIdentifier, PenjualanRowID)); db.Commands[0].Parameters.Add(new Parameter("@CustomerRowID", SqlDbType.UniqueIdentifier, CustomerRowID)); db.Commands[0].Parameters.Add(new Parameter("@TglLunasBBN", SqlDbType.DateTime, GlobalVar.GetServerDate.Date)); db.Commands[0].Parameters.Add(new Parameter("@NoSTNK", SqlDbType.VarChar, txt_NoSTNK.Text)); db.Commands[0].Parameters.Add(new Parameter("@NoRegistrasi", SqlDbType.VarChar, txt_NoReg.Text)); db.Commands[0].Parameters.Add(new Parameter("@Nama", SqlDbType.VarChar, txt_NamaSTNK.Text)); db.Commands[0].Parameters.Add(new Parameter("@Alamat", SqlDbType.VarChar, txt_AlamatSTNK.Text)); db.Commands[0].Parameters.Add(new Parameter("@NoRangka", SqlDbType.VarChar, txt_NoRangka.Text)); db.Commands[0].Parameters.Add(new Parameter("@NoMesin", SqlDbType.VarChar, txt_NoMesin.Text)); db.Commands[0].Parameters.Add(new Parameter("@Warna", SqlDbType.VarChar, txt_Warna.Text)); db.Commands[0].Parameters.Add(new Parameter("@LastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID)); db.Commands[0].ExecuteNonQuery(); } MessageBox.Show(Messages.Confirm.SaveSuccess); if (this.Caller is frmIdenBBNBrowse) { frmIdenBBNBrowse frmCaller = (frmIdenBBNBrowse)this.Caller; frmCaller.RefreshHeader(PenjualanRowID); frmCaller.RefreshDetail(RowIDPU); } this.DialogResult = DialogResult.OK; this.Close(); } } catch (Exception ex) { Error.LogError(ex); } }