public clsDKN()
{
_journalStatus = enumJournalStatus.NonJournal;
_isGroup = false;
BranchTo = string.Empty;
CompanyTo = Guid.Empty;
Kodomain = false;
}
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);
}
