public void FillDatasetByIdQuyetDinh(DS_GD_QUYET_DINH_PHAP_NHAN op_ds, decimal ip_dc_id_phap_nhan) { CStoredProc v_sp = new CStoredProc("pr_GD_QUYET_DINH_PHAP_NHAN_Select_by_ID_QUYET_DINH"); v_sp.addDecimalInputParam("@ID_QUYET_DINH", ip_dc_id_phap_nhan); v_sp.fillDataSetByCommand(this, op_ds); }
public US_GD_QUYET_DINH_PHAP_NHAN(decimal i_dbID) { pm_objDS = new DS_GD_QUYET_DINH_PHAP_NHAN(); pm_strTableName = c_TableName; IMakeSelectCmd v_objMkCmd = new CMakeAndSelectCmd(pm_objDS, c_TableName); v_objMkCmd.AddCondition("ID", i_dbID, eKieuDuLieu.KieuNumber, eKieuSoSanh.Bang); SqlCommand v_cmdSQL; v_cmdSQL = v_objMkCmd.getSelectCmd(); this.FillDatasetByCommand(pm_objDS, v_cmdSQL); pm_objDR = getRowClone(pm_objDS.Tables[pm_strTableName].Rows[0]); }
private void delete_v_gd_quyet_dinh() { if (!CGridUtils.IsThere_Any_NonFixed_Row(m_fg)) { return; } if (!CGridUtils.isValid_NonFixed_RowIndex(m_fg, m_fg.Row)) { return; } if (BaseMessages.askUser_DataCouldBeDeleted(8) != BaseMessages.IsDataCouldBeDeleted.CouldBeDeleted) { return; } US_V_GD_QUYET_DINH v_us = new US_V_GD_QUYET_DINH(); US_GD_QUYET_DINH_PHAP_NHAN v_us_qd_pn = new US_GD_QUYET_DINH_PHAP_NHAN(); DS_GD_QUYET_DINH_PHAP_NHAN v_ds_qd_pn = new DS_GD_QUYET_DINH_PHAP_NHAN(); grid2us_object(v_us, m_fg.Row); try { v_us.BeginTransaction(); // Xoá Quyết định - Pháp nhân v_us_qd_pn.FillDatasetByIdQuyetDinh(v_ds_qd_pn, v_us.dcID); v_us_qd_pn.DeleteByID(v_us.dcID); // Xoá Pháp nhân v_us.delete_by_id(v_us.dcID); v_us.CommitTransaction(); m_fg.Rows.Remove(m_fg.Row); } catch (Exception v_e) { v_us.Rollback(); CDBExceptionHandler v_objErrHandler = new CDBExceptionHandler(v_e, new CDBClientDBExceptionInterpret()); v_objErrHandler.showErrorMessage(); } }
public US_GD_QUYET_DINH_PHAP_NHAN() { pm_objDS = new DS_GD_QUYET_DINH_PHAP_NHAN(); pm_strTableName = c_TableName; pm_objDR = pm_objDS.Tables[pm_strTableName].NewRow(); }