public String loadDogovor(int dogov_id) {
String value = "";
long stime = System.currentTimeMillis();
try {
Connection conn = ds.getConnection();
Statement st = conn.createStatement();
// st.executeUpdate("alter session set NLS_NUMERIC_CHARACTERS = '.,'");
query =
"select id, nomer, ks_id, ks_name, obl_id, obl_name, to_char(dat_podpis,'dd-mm-yyyy') d_p, to_char(dat_start,'dd-mm-yyyy') d_s, to_char(dat_end,'dd-mm-yyyy') d_e, days "
+ "from o$dogovor "
+ "WHERE id="
+ dogov_id;
ResultSet rs = st.executeQuery(query);
Dogovors.clear();
while (rs.next()) {
dg.dogov_id = rs.getInt("id");
dg.nomer = rs.getString("nomer");
dg.ks_id = rs.getInt("ks_id");
dg.ks_name = rs.getString("ks_name");
dg.obl_id = rs.getInt("obl_id");
dg.obl_name = rs.getString("obl_name");
dg.dat_podpis = rs.getString("d_p");
dg.dat_start = rs.getString("d_s");
dg.dat_end = rs.getString("d_e");
dg.days = rs.getInt("days");
}
rs.close();
st.close();
conn.close();
} catch (SQLException e) {
Basic.Logerr("loadDogovor error: " + e.getLocalizedMessage());
value = "SQL Exception";
} catch (Exception e) {
Basic.Logerr("loadDogovor error: " + e.getLocalizedMessage());
value = "Exception";
}
processingtime =
String.valueOf(
Basic.formatNumber(
10, 1, 3, 3, ((double) (System.currentTimeMillis() - stime) / 1000)));
return value;
}
public String loadDogovorAll(String dogov_id) {
String value = "";
Dogovor tempDogovor;
DogovorLoss tempDogovorLoss;
long stime = System.currentTimeMillis();
try {
Connection conn = ds.getConnection();
Statement st = conn.createStatement();
// st.executeUpdate("alter session set NLS_NUMERIC_CHARACTERS = '.,'");
if (dogov_id.equals("all")) {
query =
"select id, nomer, ks_id, ks_name, obl_id, obl_name, "
+ " to_char(dat_podpis,'dd-mm-yyyy') d_p, to_char(dat_start,'dd-mm-yyyy') d_s, to_char(dat_end,'dd-mm-yyyy') d_e, days from o$dogovor";
} else {
query =
"select id, nomer, ks_id, ks_name, obl_id, obl_name, "
+ " to_char(dat_podpis,'dd-mm-yyyy'), to_char(dat_start,'dd-mm-yyyy'), to_char(dat_end,'dd-mm-yyyy'), days from o$dogovor "
+ "WHERE dogov_id="
+ dogov_id;
}
ResultSet rs = st.executeQuery(query);
Dogovors.clear();
while (rs.next()) {
tempDogovor = new Dogovor();
tempDogovor.dogov_id = rs.getInt("id");
tempDogovor.nomer = rs.getString("nomer");
tempDogovor.ks_id = rs.getInt("ks_id");
tempDogovor.ks_name = rs.getString("ks_name");
tempDogovor.obl_id = rs.getInt("obl_id");
tempDogovor.obl_name = rs.getString("obl_name");
tempDogovor.dat_podpis = rs.getString("d_p");
tempDogovor.dat_start = rs.getString("d_s");
tempDogovor.dat_end = rs.getString("d_e");
tempDogovor.days = rs.getInt("days");
Dogovors.add(tempDogovor);
}
tempDogovor = null;
query =
"select dogov_loss_id, dogov_id, dogovor_nomer, to_char(dogovor_dat_podpis,'dd.mm.yyyy') dd, "
+ "point_id, point_name, "
+ "loss_fixed_sa_1, loss_fixed_sa_2, loss_fixed_sa_3, "
+ "loss_fixed_sr_1, loss_fixed_sr_2, loss_fixed_sr_3, "
+ "loss_fixed_gr_1, loss_fixed_gr_2, loss_fixed_gr_3, "
+ "loss_float_sa_1, loss_float_sa_2, loss_float_sa_3, "
+ "loss_float_sr_1, loss_float_sr_2, loss_float_sr_3, "
+ "loss_float_gr_1, loss_float_gr_2, loss_float_gr_3 "
+ "from o$dogov_loss";
rs = st.executeQuery(query);
DogovorLosses.clear();
while (rs.next()) {
tempDogovorLoss = new DogovorLoss();
tempDogovorLoss.dogov_loss_id = rs.getInt("dogov_loss_id");
tempDogovorLoss.dogov_id = rs.getInt("dogov_id");
tempDogovorLoss.dogovor_nomer = rs.getString("dogovor_nomer");
tempDogovorLoss.dogovor_dat_podpis = rs.getString("dd");
tempDogovorLoss.point_id = rs.getInt("point_id");
tempDogovorLoss.point_name = rs.getString("point_name");
tempDogovorLoss.loss_fixed_sa_1 = rs.getDouble("loss_fixed_sa_1");
tempDogovorLoss.loss_fixed_sa_2 = rs.getDouble("loss_fixed_sa_2");
tempDogovorLoss.loss_fixed_sa_3 = rs.getDouble("loss_fixed_sa_3");
tempDogovorLoss.loss_fixed_sr_1 = rs.getDouble("loss_fixed_sr_1");
tempDogovorLoss.loss_fixed_sr_2 = rs.getDouble("loss_fixed_sr_2");
tempDogovorLoss.loss_fixed_sr_3 = rs.getDouble("loss_fixed_sr_3");
tempDogovorLoss.loss_fixed_gr_1 = rs.getDouble("loss_fixed_gr_1");
tempDogovorLoss.loss_fixed_gr_2 = rs.getDouble("loss_fixed_gr_2");
tempDogovorLoss.loss_fixed_gr_3 = rs.getDouble("loss_fixed_gr_3");
tempDogovorLoss.loss_float_sa_1 = rs.getDouble("loss_float_sa_1");
tempDogovorLoss.loss_float_sa_2 = rs.getDouble("loss_float_sa_2");
tempDogovorLoss.loss_float_sa_3 = rs.getDouble("loss_float_sa_3");
tempDogovorLoss.loss_float_sr_1 = rs.getDouble("loss_float_sr_1");
tempDogovorLoss.loss_float_sr_2 = rs.getDouble("loss_float_sr_2");
tempDogovorLoss.loss_float_sr_3 = rs.getDouble("loss_float_sr_3");
tempDogovorLoss.loss_float_gr_1 = rs.getDouble("loss_float_gr_1");
tempDogovorLoss.loss_float_gr_2 = rs.getDouble("loss_float_gr_2");
tempDogovorLoss.loss_float_gr_3 = rs.getDouble("loss_float_gr_3");
DogovorLosses.add(tempDogovorLoss);
}
tempDogovorLoss = null;
for (int i = 0; i < Dogovors.size(); i++) {
Dogovor d = (Dogovor) Dogovors.get(i);
for (int j = 0; j < DogovorLosses.size(); j++) {
DogovorLoss dl = (DogovorLoss) DogovorLosses.get(j);
if (d.dogov_id == dl.dogov_id) {
d.points.add(dl);
}
}
}
rs.close();
st.close();
conn.close();
} catch (SQLException e) {
Basic.Logerr("loadDogovorAll error: " + e.getLocalizedMessage());
value = "SQL Exception";
} catch (Exception e) {
Basic.Logerr("loadDogovorAll error: " + e.getLocalizedMessage());
value = "SQL Exception";
}
processingtime =
String.valueOf(
Basic.formatNumber(
10, 1, 3, 3, ((double) (System.currentTimeMillis() - stime) / 1000)));
return value;
}