Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package commonPanels.StrategyDao;
- import solution.common.query.Query;
- import solution.common.query.QueryData;
- import solution.commondb.Global;
- import solution.commondb.ambdoctor.db.dao.AbstractDao;
- import solution.commondb.dao.exception.ProcErrorException;
- import solution.commondb.select.SelectDlg;
- import solution.commondb.tables.SOLUTION_FORM.FILTER_ITEM;
- import javax.swing.*;
- public class FilterReferenceWithParam extends AbstractDao implements IReferenceWithParams {
- private FILTER_ITEM item = null;
- /* SQLs*/
- public static final String SQL_SELECT_REFERENCE_PARAMS = "SELECT_REF_PARAMS";
- public static final String SQL_SELECT_FILTER_ITEMS = "SELECT_FILTER_ITEM_EXT";
- public static final String SQL_SELECT_FILTER_LIST = "SELECT_FILTER_LISTS";
- public static final String SQL_INSERT_PARAM = "INSERT_PASS_ITEM";
- public static final String SQL_UPDATE_PARAM = "UPDATE_PASS_ITEM";
- public static final String SQL_UPDATE_STATUS = "UPDATE_CHECK_STATUS";
- public static final String SQL_DELETE_PARAM = "DELETE_CONNECT_PARAMS";
- /*Fields*/
- public static final String ID = "CONNECT_ID";
- public static final String PARAM = "PARAM_ID";
- public FilterReferenceWithParam(FILTER_ITEM item) {
- this.item = item;
- }
- @Override
- public Query getTableQuery() {
- return getPreparedQuery(Global.getSQL(SQL_SELECT_REFERENCE_PARAMS), new QueryData().put("FILTER_ITEM_ID", item.getId()));
- }
- @Override
- public SelectDlg getParamSelectDlg() {
- SelectDlg dlg = new SelectDlg(getConnection(), "addCurrentItem", ListSelectionModel.SINGLE_SELECTION);
- dlg.addColumn("ID", "", false);
- dlg.addColumn("STATUS", "", true);
- dlg.setColumnFixed("STATUS", true, 20);
- dlg.addColumn("CODE", "Код", true);
- dlg.addColumn("TEXT", "Название", true);
- dlg.setActiveCheckBoxVisible(true);
- dlg.setTitle("Выбор параметра");
- Query query = getPreparedQuery(Global.getSQL(SQL_SELECT_FILTER_ITEMS).replaceAll(":SELECT", Global.getSQL(SQL_SELECT_FILTER_LIST))
- , new QueryData().put("FILTER_ID", item.getFilterId()));
- dlg.setQuery(query);
- dlg.enableFilter(true);
- return dlg;
- }
- @Override
- public void saveParam(Object idConnect, Object idRefParamId, Object idParam) throws ProcErrorException {
- if (isUpdateParam(idConnect)){
- update(idConnect, idParam);
- } else {
- insert(idRefParamId, idParam);
- }
- }
- private void insert(Object idRefParam, Object idParam) throws ProcErrorException {
- executeOneRowQuery(Global.getSQL(SQL_INSERT_PARAM), getInsertQueryData(idRefParam, idParam));
- }
- private void update(Object idConnect, Object idParam){
- executeUpdate(Global.getSQL(SQL_UPDATE_PARAM), getUpdateQueryData(idConnect, idParam));
- }
- private boolean isUpdateParam(Object id){
- return id != null;
- }
- private QueryData getInsertQueryData(Object idRefParam, Object idParam) {
- return new QueryData()
- .put("CURR_ITEM_ID", item.getId())
- .put("REF_ITEM_ID", idRefParam)
- .put(PARAM, idParam);
- }
- private QueryData getUpdateQueryData(Object idConnect, Object idParam) {
- return new QueryData()
- .put(ID, idConnect)
- .put(PARAM, idParam);
- }
- private QueryData getUpdateStatusQueryData(Object idConnect, int status) {
- return new QueryData()
- .put(ID, idConnect)
- .put("CHECK_STATUS", status);
- }
- @Override
- public void saveStatusCheck(Object idConnect, int statusParam) {
- executeUpdate(Global.getSQL(SQL_UPDATE_STATUS), getUpdateStatusQueryData(idConnect, statusParam));
- }
- @Override
- public void deleteParam(Object idConnect) throws ProcErrorException {
- executeOneRowQuery(Global.getSQL(SQL_DELETE_PARAM), new QueryData().put(ID, idConnect));
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement