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 string DBPostJournal()
{
string result = "Ok";
List <clsJournal> ljournal = GetGLJournal(enumJournalViewMode.Post);
if (ljournal.Count > 0)
{
using (Database db = new Database())
{
db.BeginTransaction();
foreach (clsJournal j in ljournal)
{
if (result == "Ok")
{
if (j.DBPostJournal(db))
{
if (j.PerusahaanRowID == _perusahaanDariRowID)
{
result = AutoJournal.UpdateJournalRowID(db, "usp_HubunganIstimewa_UPDATE_JournalRowID", _rowID, j.RowID);
}
//if (result != 0) SetError(result, "Update Journal ID di DKN : " + result);
foreach (clsDKN d in DKNChilds)
{
if (d.PerusahaanDariRowID == j.PerusahaanRowID)
{
result = AutoJournal.UpdateJournalRowID(db,
"usp_HubunganIstimewa_UPDATE_JournalRowID", d.RowID, j.RowID);
if (result != "Ok")
{
SetError(3, "Update Journal ID di DKN : \n" + result);
break;
}
}
}
}
else
{
result = "Gagal Posting";
SetError(1, "Gagal Posting");
break;
}
}
}
if (result == "Ok")
{
db.CommitTransaction();
}
else
{
db.RollbackTransaction();
}
}
}
return(result);
}
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();
}
}
private void SetNoPerkiraan04()
{
_noPerkiraan04 = "";
if ((_perusahaanKeRowID != null) && (_perusahaanKeRowID != Guid.Empty) && (_perusahaanDariRowID != _perusahaanKeRowID))
{
if (!GlobalVar.IsNewDNKN)
{
// antar PT
_noPerkiraan04 = AutoJournal.GetPerkiraanDKNPT(_perusahaanKeRowID, _perusahaanDariRowID);
}
else
{
_noPerkiraan04 = _jnsTransaksi.Equals(GlobalVar.GetTransaksi.HLL) ? AutoJournal.GetPerkiraanDKNPT_HLL(_perusahaanDariRowID) :
AutoJournal.GetPerkiraanNewDKNPT(_perusahaanKeRowID, _perusahaanDariRowID);
}
}
}
private void SetNoPerkiraan02()
{
switch (_jnsPengeluaran)
{
case "K":
{
_noPerkiraan02 = AutoJournal.GetPerkiraanKas(_kasRowID);
} break;
case "B":
{
_noPerkiraan02 = AutoJournal.GetPerkiraanRekening(_rekeningRowID);
} break;
case "G":
goto case "B";
//{
// //_noPerkiraan02 = AutoJournal.GetPerkiraanKoneksiDetail("HUTBG");
//} break;
}
}
private void SetNoPerkiraan01()
{
switch (_pengeluaranKe)
{
case 0:
_noPerkiraan01 = AutoJournal.GetPerkiraanDKNCabang(_cabangKeID);
break;
case 1: break;
case 2:
if (_perusahaanDariRowID != _perusahaanKeRowID)
{
if (!GlobalVar.IsNewDNKN)
{
_noPerkiraan01 = AutoJournal.GetPerkiraanDKNPT(_perusahaanDariRowID, _perusahaanKeRowID);
}
else
{
if (_jnsTransaksi == GlobalVar.GetTransaksi.HLL)
{
_noPerkiraan01 = AutoJournal.GetPerkiraanDKNPT_HLL(_perusahaanKeRowID);
}
else if (_jnsTransaksi == GlobalVar.GetTransaksi.PLL)
{
_noPerkiraan01 = AutoJournal.GetPerkiraanDKNPT_PLL(_perusahaanKeRowID);
}
else
{
_noPerkiraan01 = AutoJournal.GetPerkiraanNewDKNPT(_perusahaanDariRowID, _perusahaanKeRowID);
}
}
}
break;
default: break;
}
}
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);
}
public List <clsJournal> GetGLJournal(enumJournalViewMode mode)
{
List <clsJournal> _j = new List <clsJournal>();
clsJournal jh;
clsJournalDetail jd;
_isPosted = false;
if (JournalValidating(mode))
{
string l_cabangHO = clsPerusahaan.DBGetInitCabang(_perusahaanDariRowID);
string l_noperk1, l_noperk2, l_uraian, l_dk1, l_dk2;
double l_nominalRp, l_nominalOri;
//double l_totalRp = 0;
//double l_totalOri = 0;
Guid l_mataUangRowID;
clsPerusahaan _hts = new clsPerusahaan("HTS");
#region Journal #1
// Insert Header#1 :
jh = new clsJournal(_perusahaanDariRowID, _tanggal, _noBukti, "Journal DKN ", "DKN", _gudangID);
// Insert Detail#1 di Header#1 :
// Case : 1. CabangDari = CabangHO --> getPerkiraanDetal
// 2. getPerkiraanDKNCabangDari
if (CompanyTo == Guid.Empty)
{
l_noperk1 = AutoJournal.GetPerkiraanDKNCabang(_cabangDariID);
l_noperk2 = (_perusahaanDariRowID == _perusahaanKeRowID) ?
AutoJournal.GetPerkiraanDKNCabang(_cabangKeID) :
((_perusahaanDariRowID == _hts.RowID) ? AutoJournal.GetPerkiraanDKNHTS(_perusahaanKeRowID)
: AutoJournal.GetPerkiraanDKNPT(_perusahaanKeRowID));
l_dk1 = (_tipeNota == 0) ? "K" : "D";
l_dk2 = (_tipeNota == 0) ? "D" : "K";
foreach (DataRow dr in _dtDetail.Rows)
{
if (_cabangDariID == l_cabangHO)
{
l_noperk1 = dr["NoPerkiraan"].ToString();
}
l_uraian = dr["Uraian"].ToString();
l_nominalRp = double.Parse(Tools.isNull(dr["Nominal"], "0").ToString());
l_nominalOri = double.Parse(Tools.isNull(dr["NominalRp"], "0").ToString());
if (l_nominalRp == 0)
{
l_nominalRp = l_nominalOri;
}
l_mataUangRowID = (Guid)Tools.isNull(dr["MataUangRowID"], Guid.Empty);
//--> case 1 : jika cabangdari = cabangHO, bikin detilnya di sini
// if (_cabangDariID == l_cabangHO)
// {
jd = new clsJournalDetail(jh.RowID, l_noperk1, l_uraian, l_dk1, l_nominalRp,
l_mataUangRowID, l_nominalOri, _noBukti);
jh.AddDetail(jd);
// }
jd = new clsJournalDetail(jh.RowID, l_noperk2, l_uraian, l_dk2, l_nominalRp,
l_mataUangRowID, l_nominalOri, _noBukti);
jh.AddDetail(jd);
//l_totalRp = l_totalRp + l_nominalRp;
//l_totalOri = l_totalOri + l_nominalOri;
}
}
else
{
//1
if (_tipeNota != 0)
{
l_dk1 = (_tipeNota == 0) ? "K" : "D"; //D
l_dk2 = (_tipeNota == 0) ? "D" : "K"; //K
//D
l_noperk1 = AutoJournal.GetPerkiraanDKNPT_PLL(CompanyTo);
//K
l_noperk2 = AutoJournal.GetPerkiraanDKNCabang(_cabangKeID);
}
else//0
{
l_dk2 = (_tipeNota == 0) ? "K" : "D"; //K
l_dk1 = (_tipeNota == 0) ? "D" : "K"; //D
l_noperk1 = AutoJournal.GetPerkiraanDKNCabang(_cabangKeID);
l_noperk2 = AutoJournal.GetPerkiraanDKNPT_HLL(CompanyTo);
}
foreach (DataRow dr in _dtDetail.Rows)
{
// if (_cabangDariID == l_cabangHO) l_noperk1 = dr["NoPerkiraan"].ToString();
l_uraian = dr["Uraian"].ToString();
l_nominalRp = double.Parse(Tools.isNull(dr["Nominal"], "0").ToString());
l_nominalOri = double.Parse(Tools.isNull(dr["NominalRp"], "0").ToString());
if (l_nominalRp == 0)
{
l_nominalRp = l_nominalOri;
}
l_mataUangRowID = (Guid)Tools.isNull(dr["MataUangRowID"], Guid.Empty);
//--> case 1 : jika cabangdari = cabangHO, bikin detilnya di sini
// if (_cabangDariID == l_cabangHO)
// {
jd = new clsJournalDetail(jh.RowID, l_noperk1, l_uraian, l_dk1, l_nominalRp,
l_mataUangRowID, l_nominalOri, _noBukti);
jh.AddDetail(jd);
// }
jd = new clsJournalDetail(jh.RowID, l_noperk2, l_uraian, l_dk2, l_nominalRp,
l_mataUangRowID, l_nominalOri, _noBukti);
jh.AddDetail(jd);
//l_totalRp = l_totalRp + l_nominalRp;
//l_totalOri = l_totalOri + l_nominalOri;
}
}
/*
* // --> lha klu yang ini case 2 : klu cabangdari gak sama cabangHO, nambah detilnya di sini
* // \m/ --> klu di YM, nongol smiley-icon metalll !!!!!
* if (_cabangDariID != l_cabangHO)
* {
* l_noperk = AutoJournal.GetPerkiraanDKNCabang(_cabangDariID);
* jd = new clsJournalDetail(jh.RowID, l_noperk, "HI Cabang " + _cabangDariID, l_dk, l_totalRp, _mataUangRowID, l_totalOri, _noBukti);
* jh.AddDetail(jd);
* }
*
* // Insert Detail#2 di Header#1 :
* // Case : 1. PerusahaanDari = PerusahaanKe --> getPerkiraanDKNPTKe
* // 2. getPerkiraanCabangKe
* l_dk = (_tipeNota == 0) ? "D" : "K";
* l_noperk = (_perusahaanDariRowID == _perusahaanKeRowID) ? AutoJournal.GetPerkiraanDKNCabang(_cabangKeID) : AutoJournal.GetPerkiraanDKNPT(_perusahaanKeRowID);
* jd = new clsJournalDetail(jh.RowID, l_noperk, "Journal DKN", l_dk, l_totalRp, _mataUangRowID, l_totalOri, _noBukti);
* jh.AddDetail(jd);
*/
_j.Add(jh);
#endregion
#region Journal #2
// Insert Header#2 (Jika Beda PT) :
if ((_perusahaanDariRowID != _perusahaanKeRowID))
{
if (CompanyTo == Guid.Empty)
{
jh = new clsJournal(_perusahaanKeRowID, _tanggal, _noBukti, "Journal DKN", "DKN",
clsPerusahaan.DBGetInitGudang(_perusahaanKeRowID));
l_dk1 = (_tipeNota == 0) ? "K" : "D";
l_dk2 = (_tipeNota == 0) ? "D" : "K";
l_noperk1 = (_perusahaanKeRowID == _hts.RowID) ? AutoJournal.GetPerkiraanDKNHTS(_perusahaanDariRowID) : AutoJournal.GetPerkiraanDKNPT(_perusahaanDariRowID);
l_noperk2 = AutoJournal.GetPerkiraanDKNCabang(_cabangKeID);
l_cabangHO = clsPerusahaan.DBGetInitCabang(_perusahaanKeRowID);
// Insert Detail#1 di Header#2 : getPerkiraanDKNPTDari
//jd = new clsJournalDetail(jh.RowID, AutoJournal.GetPerkiraanDKNPT(_perusahaanDariRowID),
// "Journal DKN", ((_tipeNota == 0) ? "K" : "D"), l_totalRp, _mataUangRowID,
// l_totalOri, _noBukti);
//jh.AddDetail(jd);
// Insert Detail#2 di Header#2 :
// case 1. cabangKe = cabangHOKe -> getPerkiraanDetail
// 2. getPerkiraanDKNCabangKe
// if (_cabangKeID == clsPerusahaan.DBGetInitCabang(_perusahaanKeRowID))
foreach (DataRow dr in _dtDetail.Rows)
{
if (_cabangKeID == l_cabangHO)
{
l_noperk2 = dr["NoPerkiraan"].ToString();
}
l_uraian = dr["Uraian"].ToString();
l_nominalRp = double.Parse(Tools.isNull(dr["Nominal"], "0").ToString());
l_nominalOri = double.Parse(Tools.isNull(dr["NominalRp"], "0").ToString());
if (l_nominalRp == 0)
{
l_nominalRp = l_nominalOri;
}
l_mataUangRowID = (Guid)Tools.isNull(dr["MataUangRowID"], Guid.Empty);
jd = new clsJournalDetail(jh.RowID, l_noperk1, l_uraian, l_dk1, l_nominalRp,
l_mataUangRowID, l_nominalOri, _noBukti);
jh.AddDetail(jd);
jd = new clsJournalDetail(jh.RowID, l_noperk2, l_uraian, l_dk2, l_nominalRp,
l_mataUangRowID, l_nominalOri, _noBukti);
jh.AddDetail(jd);
}
/*
* else
* {
* jd = new clsJournalDetail(jh.RowID, AutoJournal.GetPerkiraanDKNCabang(_cabangKeID),
* "Journal DKN", ((_tipeNota == 0) ? "D" : "K"), l_totalRp, _mataUangRowID,
* l_totalOri, _noBukti);
* jh.AddDetail(jd);
* }
*/
_j.Add(jh);
}
else
{
/*
* else
* {
* jd = new clsJournalDetail(jh.RowID, AutoJournal.GetPerkiraanDKNCabang(_cabangKeID),
* "Journal DKN", ((_tipeNota == 0) ? "D" : "K"), l_totalRp, _mataUangRowID,
* l_totalOri, _noBukti);
* jh.AddDetail(jd);
* }
*/
_j.Add(jh);
}
}
#endregion
}
else
{
if (_errorNo == 5)
{
_isPosted = true;
if (DKNChilds.Count > 0)
{
foreach (clsDKN d in DKNChilds)
{
jh = new clsJournal(d._journalRowID);
SetError(jh.ErrNo, jh.ErrMsg);
if (jh.ErrNo == 0)
{
if (_j.Find(delegate(clsJournal j) { return(j.RowID == jh.RowID); }) == null)
{
_j.Add(jh);
}
else
{
break;
}
}
}
}
else
{
if ((Guid)Tools.isNull(_journalRowID, Guid.Empty) != Guid.Empty)
{
jh = new clsJournal(_journalRowID);
SetError(jh.ErrNo, jh.ErrMsg);
if (jh.ErrNo == 0)
{
_j.Add(jh);
}
}
}
}
}
return(_j);
}
private void SetNoPerkiraan03()
{
_noPerkiraan03 = "";
if (!string.IsNullOrEmpty(_cabangOriID) && (_cabangOriID != _cabangKeID))
{
// beda cabang lintas pt
_noPerkiraan03 = AutoJournal.GetPerkiraanDKNCabang(_cabangOriID);
}
else if ((_perusahaanKeRowID != null) && (_perusahaanKeRowID != Guid.Empty) && (_perusahaanDariRowID != _perusahaanKeRowID))
{
// antar PT
// klu trx pengeluaran cuma 1 record, musti dicari cabang HO penerima
if (!GlobalVar.IsNewDNKN)//
{
if (string.IsNullOrEmpty(_cabangOriID) || (_cabangKeID == _cabangOriID))
{
// klu trx pengeluaran cuma 1 record, gak perlu nyari trx penerimaan-nya ...
List <Parameter> prm = new List <Parameter>();
prm.Add(new Parameter("@GroupRowID", SqlDbType.UniqueIdentifier, _rowID));
DataTable dt = Tools.DBGetDataTable("usp_PenerimaanUang_LIST_FILTER_Group", prm);
if (dt.Rows.Count > 0)
{
string _jnsPenerimaan = Tools.isNull(dt.Rows[0]["JnsPenerimaan"], "").ToString();
switch (_jnsPenerimaan)
{
case "K":
{
Guid _kasTrmRowID = (Guid)Tools.isNull(dt.Rows[0]["KasRowID"], Guid.Empty);
_noPerkiraan03 = AutoJournal.GetPerkiraanKas(_kasTrmRowID);
} break;
case "B":
{
Guid _rekRowID = (Guid)Tools.isNull(dt.Rows[0]["RekeningRowID"], Guid.Empty);
_noPerkiraan03 = AutoJournal.GetPerkiraanRekening(_rekRowID);
} break;
default: break;
}
}
}
else
{
_noPerkiraan03 = AutoJournal.GetPerkiraanDKNPT(_perusahaanKeRowID, _perusahaanDariRowID);
}
}
else // DKN baru
{
if (string.IsNullOrEmpty(_cabangOriID) || (_cabangKeID == _cabangOriID))
{
// klu trx pengeluaran cuma 1 record, gak perlu nyari trx penerimaan-nya ...
List <Parameter> prm = new List <Parameter>();
prm.Add(new Parameter("@GroupRowID", SqlDbType.UniqueIdentifier, _rowID));
DataTable dt = Tools.DBGetDataTable("usp_PenerimaanUang_LIST_FILTER_Group", prm);
if (dt.Rows.Count > 0)
{
string _jnsPenerimaan = Tools.isNull(dt.Rows[0]["JnsPenerimaan"], "").ToString();
switch (_jnsPenerimaan)
{
case "K":
{
Guid _kasTrmRowID = (Guid)Tools.isNull(dt.Rows[0]["KasRowID"], Guid.Empty);
_noPerkiraan03 = AutoJournal.GetPerkiraanKas(_kasTrmRowID);
} break;
case "B":
{
Guid _rekRowID = (Guid)Tools.isNull(dt.Rows[0]["RekeningRowID"], Guid.Empty);
_noPerkiraan03 = AutoJournal.GetPerkiraanRekening(_rekRowID);
} break;
default: break;
}
}
}
else
{
_noPerkiraan03 =
_jnsTransaksi.Equals(GlobalVar.GetTransaksi.HLL) ? AutoJournal.GetPerkiraanDKNPT_HLL(_perusahaanDariRowID) :
AutoJournal.GetPerkiraanNewDKNPT(_perusahaanKeRowID, _perusahaanDariRowID);
}
}
}
}
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);
}
