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