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); }