public static void AddJournalRetur(DataRow dr)
{
using (Database db = new Database())
{
string Gudang = AutoJournal.GetGudangIDByPTRowID(GlobalVar.GetPT.SAP);
Guid RowID = Guid.NewGuid();
string RecordID = Tools.CreateFingerPrint();
string Uraian = string.Format("Journal Nota RJ - {0}", dr["Gudang"].ToString());
double RpNota = Convert.ToDouble(dr["RpNota"]);
db.BeginTransaction();
int result = Journal.AddHeader(db, GlobalVar.GetPT.SAP, RowID, RecordID, Convert.ToDateTime(dr["TglNota"]), dr["NoNota"].ToString(),
Uraian, "TRD", Gudang, false);
if (result != 0)
{
db.RollbackTransaction();
throw new Exception("Error ADD header");
}
Uraian = string.Format("Piutang {0} - Nota Retur Jual", dr["Gudang"].ToString());
result = Journal.AddDetail(db, Guid.NewGuid(), RowID, Tools.CreateFingerPrint(), RecordID, dr["NoPerkHI"].ToString(),
Uraian, 0, RpNota, "K", Guid.Empty, RpNota
);
if (result != 0)
{
db.RollbackTransaction();
throw new Exception("Error ADD Detail Kredit");
}
DataTable dtDetail = NoPerkRetur((Guid)dr["RowID"]);
string NoPerk = string.Empty;
foreach (DataRow drd in dtDetail.Rows)
{
Uraian = string.Format("Piutang {0} - Nota Retur Jual {1}", dr["Gudang"].ToString(), drd["KLP"].ToString());
NoPerk = Tools.isNull(drd["NoPerkiraan"], "").ToString();
RpNota = Convert.ToDouble(drd["RpNota"]);
if (NoPerk.Equals(""))
{
db.RollbackTransaction();
throw new Exception("Error ADD Detail Debet, Kelompok " + drd["KLP"].ToString() + " belum ada No Perkiraan");
}
result = Journal.AddDetail(db, Guid.NewGuid(), RowID, Tools.CreateFingerPrint(), RecordID, NoPerk,
Uraian, RpNota, 0, "D", Guid.Empty, RpNota
);
if (result != 0)
{
db.RollbackTransaction();
throw new Exception("Error ADD Detail Debet");
}
}
UpdateTrans(db, RowID, (Guid)dr["RowID"], "RET");
db.CommitTransaction();
}
}
public static void AddJournalIden(DataRow dr)
{
using (Database db = new Database())
{
string Gudang = AutoJournal.GetGudangIDByPTRowID(GlobalVar.GetPT.SAP);
Guid RowID = Guid.NewGuid();
string RecordID = Tools.CreateFingerPrint();
string Uraian = string.Format("Journal Identifikasi Piutang - {0}", dr["Gudang"].ToString());
double RpNota = Convert.ToDouble(dr["Nominal"]);
RpNota = Math.Abs(RpNota);
double RpKredit = RpNota;
double RpDebet = RpNota;
db.BeginTransaction();
int result = Journal.AddHeader(db, GlobalVar.GetPT.SAP, RowID, RecordID, Convert.ToDateTime(dr["TglTrans"]), dr["NoTrans"].ToString(),
Uraian, "TRD", Gudang, false);
if (result != 0)
{
db.RollbackTransaction();
throw new Exception("Error ADD header");
}
string NoPerkD = string.Empty;
string NoPerkK = string.Empty;
string UraianD = string.Empty;
string UraianK = string.Empty;
NoPerkD = dr["NoperkHI"].ToString();
NoPerkK = "1103.51.100";
UraianD = string.Format("{0} ", dr["Uraian"].ToString());
UraianK = string.Format("{0} ", dr["Uraian"].ToString());
result = Journal.AddDetail(db, Guid.NewGuid(), RowID, Tools.CreateFingerPrint(), RecordID, NoPerkD,
UraianD, RpDebet, 0, "D", Guid.Empty, RpNota
);
if (result != 0)
{
db.RollbackTransaction();
throw new Exception("Error ADD Detail Debet");
}
result = Journal.AddDetail(db, Guid.NewGuid(), RowID, Tools.CreateFingerPrint(), RecordID, NoPerkK,
UraianK, 0, RpKredit, "K", Guid.Empty, RpNota
);
if (result != 0)
{
db.RollbackTransaction();
throw new Exception("Error ADD Detail Kredit");
}
UpdateTrans(db, RowID, (Guid)dr["RowID"], "KAS");
db.CommitTransaction();
}
}
public static void AddJournalPSL(DataRow dr, bool isSimulate, ref DataTable dtHeader, ref DataTable dtDetail)
{
using (Database db = new Database())
{
//string Gudang = AutoJournal.GetGudangIDByPTRowID(GlobalVar.GetPT.SAP);
string Gudang = AutoJournal.GetGudangIDByPTRowID(GlobalVar.GetPT.OTO);
Guid RowID = Guid.NewGuid();
string RecordID = Tools.CreateFingerPrint();
string Uraian = string.Format("Journal Penyelesaian BS - {0}", dr["Uraian"].ToString());
double RpNota = Convert.ToDouble(dr["Debet"]) + Convert.ToDouble(dr["Kredit"]);
RpNota = Math.Abs(RpNota);
double RpKredit = RpNota;
double RpDebet = RpNota;
string Jenis = dr["No_bukti"].ToString().Substring(4, 3);
if (isSimulate == true)
{
dtHeader.Rows.Add();
dtHeader.Rows[dtHeader.Rows.Count - 1]["RowID"] = RowID;
dtHeader.Rows[dtHeader.Rows.Count - 1]["RecordID"] = RecordID;
dtHeader.Rows[dtHeader.Rows.Count - 1]["Tanggal"] = dr["Tanggal"];
dtHeader.Rows[dtHeader.Rows.Count - 1]["NoReff"] = dr["No_bukti"];
dtHeader.Rows[dtHeader.Rows.Count - 1]["Cbg"] = Gudang;
dtHeader.Rows[dtHeader.Rows.Count - 1]["Src"] = "BS";
dtHeader.Rows[dtHeader.Rows.Count - 1]["Uraian"] = Uraian;
dtHeader.Rows[dtHeader.Rows.Count - 1]["Debet"] = RpDebet;
dtHeader.Rows[dtHeader.Rows.Count - 1]["Kredit"] = RpKredit;
dtHeader.Rows[dtHeader.Rows.Count - 1]["Owner"] = "ALL";
db.Commands.Add(db.CreateCommand("usp_Perkiraan_LIST"));
db.Commands[0].Parameters.Add(new Parameter("@noPerkiraan", SqlDbType.VarChar, dr["NoPerkiraan"].ToString()));
DataTable dttemp = db.Commands[0].ExecuteDataTable();
db.Commands.Clear();
string NamaPerkiraan = "";
if (dttemp.Rows.Count > 0)
{
NamaPerkiraan = dttemp.Rows[0]["NamaPerkiraan"].ToString();
}
dtDetail.Rows.Add();
dtDetail.Rows[dtDetail.Rows.Count - 1]["RowID"] = Guid.NewGuid();
dtDetail.Rows[dtDetail.Rows.Count - 1]["HeaderID"] = RowID;
dtDetail.Rows[dtDetail.Rows.Count - 1]["RecordID"] = Tools.CreateFingerPrint();
dtDetail.Rows[dtDetail.Rows.Count - 1]["HRecordID"] = RecordID;
if (Jenis == "BKK")
{
dtDetail.Rows[dtDetail.Rows.Count - 1]["NoPerkiraan"] = "116099100";
dtDetail.Rows[dtDetail.Rows.Count - 1]["NamaPerkiraan"] = "UM Lainnya";
}
else
{
dtDetail.Rows[dtDetail.Rows.Count - 1]["NoPerkiraan"] = dr["NoPerkiraan"];
dtDetail.Rows[dtDetail.Rows.Count - 1]["NamaPerkiraan"] = NamaPerkiraan;
}
dtDetail.Rows[dtDetail.Rows.Count - 1]["Uraian"] = dr["Uraian"].ToString();
dtDetail.Rows[dtDetail.Rows.Count - 1]["DK"] = 'D';
dtDetail.Rows[dtDetail.Rows.Count - 1]["Debet"] = RpDebet;
dtDetail.Rows[dtDetail.Rows.Count - 1]["Kredit"] = 0;
dtDetail.Rows[dtDetail.Rows.Count - 1]["MataUang"] = null;
dtDetail.Rows[dtDetail.Rows.Count - 1]["NilaiOri"] = RpNota;
dtDetail.Rows.Add();
dtDetail.Rows[dtDetail.Rows.Count - 1]["RowID"] = Guid.NewGuid();
dtDetail.Rows[dtDetail.Rows.Count - 1]["HeaderID"] = RowID;
dtDetail.Rows[dtDetail.Rows.Count - 1]["RecordID"] = Tools.CreateFingerPrint();
dtDetail.Rows[dtDetail.Rows.Count - 1]["HRecordID"] = RecordID;
if (Jenis != "BKK")
{
dtDetail.Rows[dtDetail.Rows.Count - 1]["NoPerkiraan"] = "116099100";
dtDetail.Rows[dtDetail.Rows.Count - 1]["NamaPerkiraan"] = "UM Lainnya";
}
else
{
dtDetail.Rows[dtDetail.Rows.Count - 1]["NoPerkiraan"] = dr["NoPerkiraan"];
dtDetail.Rows[dtDetail.Rows.Count - 1]["NamaPerkiraan"] = NamaPerkiraan;
}
dtDetail.Rows[dtDetail.Rows.Count - 1]["Uraian"] = dr["Uraian"].ToString();
dtDetail.Rows[dtDetail.Rows.Count - 1]["DK"] = 'K';
dtDetail.Rows[dtDetail.Rows.Count - 1]["Debet"] = 0;
dtDetail.Rows[dtDetail.Rows.Count - 1]["Kredit"] = RpKredit;
dtDetail.Rows[dtDetail.Rows.Count - 1]["MataUang"] = null;
dtDetail.Rows[dtDetail.Rows.Count - 1]["NilaiOri"] = RpNota;
}
else
{
db.BeginTransaction();
int result = Journal.AddHeader(db, GlobalVar.GetPT.OTO, RowID, RecordID, Convert.ToDateTime(dr["Tanggal"]), dr["No_bukti"].ToString(),
Uraian, "BS", Gudang, false);
if (result != 0)
{
db.RollbackTransaction();
throw new Exception("Error ADD header");
}
string NoPerkD = dr["NoPerkiraan"].ToString();
string NoPerkK = "116099100"; // "1160.99.100";
string UraianD = dr["Uraian"].ToString();
string UraianK = dr["Uraian"].ToString();
//string UraianK = "UM Lainnya "; //sebelumnya
if (dr["DKR"].ToString() == "K")
{
NoPerkK = dr["NoPerkiraan"].ToString();
NoPerkD = "116099100"; // "1160.99.100";
UraianK = dr["Uraian"].ToString();
UraianD = dr["Uraian"].ToString();
// UraianD = "UM Lainnya "; //sebelumnya
}
result = Journal.AddDetail(db, Guid.NewGuid(), RowID, Tools.CreateFingerPrint(), RecordID, NoPerkD,
UraianD, RpDebet, 0, "D", Guid.Empty, RpNota
);
if (result != 0)
{
db.RollbackTransaction();
throw new Exception("Error ADD Detail Debet");
}
result = Journal.AddDetail(db, Guid.NewGuid(), RowID, Tools.CreateFingerPrint(), RecordID, NoPerkK,
UraianK, 0, RpKredit, "K", Guid.Empty, RpNota
);
if (result != 0)
{
db.RollbackTransaction();
throw new Exception("Error ADD Detail Kredit");
}
UpdateTrans(db, RowID, (Guid)dr["RowID"], "PSL");
db.CommitTransaction();
}
}
}
public static void AddJournalKRJ(DataRow dr)
{
using (Database db = new Database())
{
string Gudang = AutoJournal.GetGudangIDByPTRowID(GlobalVar.GetPT.SAP);
Guid RowID = Guid.NewGuid();
string RecordID = Tools.CreateFingerPrint();
string Uraian = string.Format("Journal Koreksi Retur Penjualan - {0}", dr["Gudang"].ToString());
double RpNota = Convert.ToDouble(dr["RpKoreksi"]);
RpNota = Math.Abs(RpNota);
double RpKredit = RpNota;
double RpDebet = RpNota;
db.BeginTransaction();
int result = Journal.AddHeader(db, GlobalVar.GetPT.SAP, RowID, RecordID, Convert.ToDateTime(dr["TglKoreksi"]), dr["NoKoreksi"].ToString(),
Uraian, "TRD", Gudang, false);
if (result != 0)
{
db.RollbackTransaction();
throw new Exception("Error ADD header");
}
string NoPerkD = string.Empty;
string NoPerkK = string.Empty;
string UraianD = string.Empty;
string UraianK = string.Empty;
if (dr["DKR"].ToString() == "D")
{
NoPerkD = dr["NoperkHI"].ToString();
NoPerkK = dr["NoPerkiraan"].ToString();
UraianD = string.Format("Piutang {0} - Koreksi Retur Penjualan ", dr["Gudang"].ToString());
UraianK = string.Format("Piutang {0} - Koreksi Retur Penjualan {1}", dr["Gudang"].ToString(), dr["KLP"].ToString());
}
else
{
NoPerkD = dr["NoPerkiraan"].ToString();
NoPerkK = dr["NoperkHI"].ToString();
UraianD = string.Format("Piutang {0} - Koreksi Retur Penjualan {1}", dr["Gudang"].ToString(), dr["KLP"].ToString());
UraianK = string.Format("Piutang {0} - Koreksi Retur Penjualan ", dr["Gudang"].ToString());
}
result = Journal.AddDetail(db, Guid.NewGuid(), RowID, Tools.CreateFingerPrint(), RecordID, NoPerkD,
UraianD, RpDebet, 0, "D", Guid.Empty, RpNota
);
if (result != 0)
{
db.RollbackTransaction();
throw new Exception("Error ADD Detail Debet");
}
result = Journal.AddDetail(db, Guid.NewGuid(), RowID, Tools.CreateFingerPrint(), RecordID, NoPerkK,
Uraian, 0, RpKredit, "K", Guid.Empty, RpNota
);
if (result != 0)
{
db.RollbackTransaction();
throw new Exception("Error ADD Detail Kredit");
}
UpdateTrans(db, RowID, (Guid)dr["RowID"], "KRJ");
db.CommitTransaction();
}
}
private int DBGetByRowID(Guid t_rowID)
{
SetError(0, "Ok");
if ((t_rowID == null) || (t_rowID == Guid.Empty))
{
SetError(1, "ID DKN kosong");
}
if (_errorNo == 0)
{
try
{
using (Database db = new Database())
{
db.Commands.Add(db.CreateCommand("usp_HubunganIstimewa_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];
RowID = (Guid)Tools.isNull(dr["RowID"], Guid.Empty);
if (RowID != Guid.Empty)
{
_noBukti = Tools.isNull(dr["NoBukti"], "").ToString();
_groupRowID = (Guid)Tools.isNull(dr["GroupRowID"], Guid.Empty);
_isGroup = (_groupRowID == Guid.Empty);
_tanggal = (DateTime)Tools.isNull(dr["Tanggal"], DateTime.MinValue);
_tipeNota = (enumTipeNota)int.Parse(Tools.isNull(dr["TipeNota"], "0").ToString());
_perusahaanDariRowID = (Guid)Tools.isNull(dr["PerusahaanDariRowID"], Guid.Empty);
_perusahaanKeRowID = (Guid)Tools.isNull(dr["PerusahaanKeRowID"], Guid.Empty);
_cabangDariID = Tools.isNull(dr["CabangDariID"], "").ToString();
_cabangKeID = Tools.isNull(dr["CabangKeID"], "").ToString();
_gudangID = AutoJournal.GetGudangIDByPTRowID(_perusahaanDariRowID);
_lingkupNota = (_perusahaanDariRowID == _perusahaanKeRowID) ? enumLingkupNota.AntarCabang : enumLingkupNota.AntarPT;
//_noPerkiraan = DBGetNoPerkiraan();
_isPosted = (bool)Tools.isNull(dr["IsPosted"], false);
_journalRowID = (Guid)Tools.isNull(dr["JournalRowID"], Guid.Empty);
if (_journalRowID != Guid.Empty)
{
_isPosted = true;
}
_mataUangRowID = (Guid)Tools.isNull(dr["MataUangRowID"], Guid.Empty);
//if (Kodomain)
//{
// _journalRowID2 = (Guid)Tools.isNull(dr["JournalRowID2"], Guid.Empty);
// _journalStatus = ((_journalRowID2 != Guid.Empty)) ? enumJournalStatus.SudahJournal : enumJournalStatus.BelumJournal;
//}
//else
//{
_journalStatus = ((_isPosted) || (_journalRowID != Guid.Empty)) ? enumJournalStatus.SudahJournal : enumJournalStatus.BelumJournal;
//}
_src = Tools.isNull(dr["Src"], "").ToString();
BranchTo = Tools.isNull(dr["BranchTo"], "").ToString();
CompanyTo = (Guid)Tools.isNull(dr["CompanyTo"], Guid.Empty);
}
}
if (_groupRowID == Guid.Empty)
{
db.Commands.Clear();
db.Commands.Add(db.CreateCommand("usp_HubunganIstimewa_LIST_FILTER_Group"));
db.Commands[0].Parameters.Add(new Parameter("@GroupRowID", SqlDbType.UniqueIdentifier, _rowID));
dt = db.Commands[0].ExecuteDataTable();
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
Guid drowID = (Guid)Tools.isNull(dr["RowID"], Guid.Empty);
if (drowID != Guid.Empty)
{
DKNChilds.Add(new clsDKN(drowID, _noBukti));
}
}
}
_isGroup = (DKNChilds.Count > 0);
}
}
}
catch (Exception ex)
{
string s = ex.Message;
SetError(2, "(DBGetByRowID) \n" + ex.Message);
}
}
return(_errorNo);
}
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);
}
