private void RefreshData()
{
switch (formMode)
{
case enumFormMode.New:
dtTanggal.DateValue = GlobalVar.GetServerDate;
break;
case enumFormMode.Update:
try
{
DataTable dt = new DataTable();
using (Database db = new Database())
{
db.Commands.Add(db.CreateCommand("usp_HubunganIstimewa_LIST"));
db.Commands[0].Parameters.Add(new Parameter("@RowID", SqlDbType.UniqueIdentifier, _rowID));
dt = db.Commands[0].ExecuteDataTable();
}
if (dt.Rows.Count > 0)
{
_tipeNota = (enumTipeNota)int.Parse(dt.Rows[0]["TipeNota"].ToString());
txtNoBukti.Text = Tools.isNull(dt.Rows[0]["NoBukti"], "").ToString();
dtTanggal.DateValue = (DateTime)dt.Rows[0]["Tanggal"];
cboCabangDari.SelectedValue = Tools.isNull(dt.Rows[0]["CabangDariID"], "").ToString();
cboCabangKe.SelectedValue = Tools.isNull(dt.Rows[0]["CabangKeID"], "").ToString();
cboKelompokTransaksi.SelectedValue = (Guid)Tools.isNull(dt.Rows[0]["KelompokTransaksiRowID"], Guid.Empty);
}
}
catch (Exception ex)
{
Error.LogError(ex);
}
break;
}
}
private void toggleCabangEnabled(enumTipeNota tipe)
{
if (_canSave)
//switch (tipe)
{
_tipeNota = tipe;
// case enumTipeNota.DebitNote:
cboPTDari.SelectedValue = GlobalVar.PerusahaanRowID;
cboCabangDari.SelectedValue = GlobalVar.CabangID;
cboPTDari.Enabled = false;
cboPTKe.Enabled = true;
//cboCabangDari.Enabled = false;
//cboCabangKe.Enabled = true;
// break;
// case enumTipeNota.CreditNote:
// cboPTKe.SelectedValue = GlobalVar.PerusahaanRowID;
// cboCabangKe.SelectedValue = GlobalVar.CabangID;
// cboPTDari.Enabled = true;
// cboPTKe.Enabled = false;
// //cboCabangDari.Enabled = true;
// //cboCabangKe.Enabled = false;
// break;
}
else
{
cboPTDari.Enabled = false;
cboPTKe.Enabled = false;
cboCabangDari.Enabled = false;
cboCabangKe.Enabled = false;
}
}
private void toggleCabangEnabled(enumTipeNota tipe)
{
switch (tipe)
{
case enumTipeNota.DebitNote:
cboCabangDari.SelectedValue = GlobalVar.CabangID;
cboCabangDari.Enabled = false;
cboCabangKe.Enabled = true;
break;
case enumTipeNota.CreditNote:
cboCabangKe.SelectedValue = GlobalVar.CabangID;
cboCabangKe.Enabled = false;
cboCabangDari.Enabled = true;
break;
}
}
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 void RefreshData()
{
switch (formMode)
{
case enumFormMode.New:
cboPTDari.SelectedValue = GlobalVar.PerusahaanRowID;
cboCabangDari.SelectedValue = GlobalVar.CabangID;
dtTanggal.DateValue = GlobalVar.GetServerDate;
cboCabangDari.Enabled = false;
break;
case enumFormMode.Update:
try
{
grpTipeNote.Enabled = false;
DataTable dt = Class.clsDKN.DBGetDKN(_rowID); //new DataTable();
//Class.clsDKN _dkn = new ISA.Showroom.Finance.Class.clsDKN(_rowID);
//using (Database db = new Database())
//{
//db.Commands.Add(db.CreateCommand("usp_HubunganIstimewa_LIST"));
//db.Commands[0].Parameters.Add(new Parameter("@RowID", SqlDbType.UniqueIdentifier, _rowID));
//dt = db.Commands[0].ExecuteDataTable();
if (dt.Rows.Count > 0)
{
//db.Commands.Clear();
//db.Commands.Add(db.CreateCommand("usp_HubunganIstimewa_LIST_FILTER_Group"));
//db.Commands[0].Parameters.Add(new Parameter("@GroupRowID", SqlDbType.UniqueIdentifier, _rowID));
// db.Commands[1].Parameters.Add(new Parameter("@PerusahaanRowID", SqlDbType.UniqueIdentifier, GlobalVar.PerusahaanRowID));
DataTable dt2 = Class.clsDKN.DBGetByGroupRowID(_rowID); //db.Commands[0].ExecuteDataTable();
if (dt2.Rows.Count > 0)
{
//{
dataGridView1.DataSource = dt2;
}
//dt2.Columns["TipeNota"].DataType = typeof(enumTipeNota);
//_canSave = false;
//}
else
{
dataGridView1.DataSource = dt;
}
}
//}
if (dt.Rows.Count > 0)
{
_tipeNota = (enumTipeNota)int.Parse(dt.Rows[0]["TipeNota"].ToString());
txtNoBukti.Text = Tools.isNull(dt.Rows[0]["NoBukti"], "").ToString();
dtTanggal.DateValue = (DateTime)dt.Rows[0]["Tanggal"];
cboPTDari.SelectedValue = Tools.isNull(dt.Rows[0]["PerusahaanDariRowID"], Guid.Empty);
cboPTKe.SelectedValue = Tools.isNull(dt.Rows[0]["PerusahaanKeRowID"], Guid.Empty);
cboCabangDari.SelectedValue = Tools.isNull(dt.Rows[0]["CabangDariID"], "").ToString();
cboCabangKe.SelectedValue = Tools.isNull(dt.Rows[0]["CabangKeID"], "").ToString();
cboKelompokTransaksi.SelectedValue = (Guid)Tools.isNull(dt.Rows[0]["KelompokTransaksiRowID"], Guid.Empty);
_syncFlag = (bool)Tools.isNull(dt.Rows[0]["SyncFlag"], false);
_canSave = (_canSave && !_syncFlag && (Tools.isNull(dt.Rows[0]["Src"], "").ToString() == "INP") &&
(Tools.isNull(dt.Rows[0]["NoRequest"], "").ToString() == ""));
}
}
catch (Exception ex)
{
Error.LogError(ex);
}
break;
}
//dtTanggal.Enabled = false;
rdoNoteCredit.Checked = (_tipeNota == enumTipeNota.CreditNote);
rdoNoteDebet.Checked = (_tipeNota == enumTipeNota.DebitNote);
cmdSAVE.Visible = _canSave;
}
