public void showTables() {
if (this.tab_PosList.getSelectedRow() == 0) {
this.btn_PosDel.setEnabled(false);
this.btn_PosUpdate.setEnabled(false);
this.btn_StaffPosUpdata.setEnabled(true);
} else {
this.btn_PosDel.setEnabled(true);
this.btn_PosUpdate.setEnabled(true);
this.btn_StaffPosUpdata.setEnabled(true);
}
// String tabSelect = tab_PosList.getValueAt(this.tab_PosList.getSelectedRow(),
// 0).toString();
String sql = "";
ResultSet rs_Pos = null;
try {
if (tab_PosList.getSelectedRow() == 0) {
sql =
" SELECT staff_info.s_no AS NO, "
+ "concat(staff_info.firstname, staff_info.lastName) AS Name, "
+ "staff_info.nia_no AS ID_NO, "
+ "staff_info.s_id AS Account "
+ " FROM staff_info "
+ " WHERE staff_info.posi_guid IS null"
+ " AND staff_info.exist = 1";
} else if (tab_PosList.getSelectedRow() != 0 && tab_PosList.getSelectedRow() != -1) {
sql =
" SELECT staff_info.s_no AS NO, "
+ "concat(staff_info.firstname, staff_info.lastName) AS Name, "
+ "staff_info.nia_no AS ID_NO, "
+ "staff_info.s_id AS Account "
+ " FROM staff_info,position "
+ " WHERE staff_info.posi_guid = position.guid "
+ " AND position.name = '"
+ tab_PosList.getValueAt(this.tab_PosList.getSelectedRow(), 0).toString()
+ "' "
+ " AND staff_info.exist = 1 ORDER BY s_id";
}
rs_Pos = DBC.executeQuery(sql);
if (rs_Pos.next()) {
tab_PosDetail.setModel(HISModel.getModel(rs_Pos, null));
} else {
tab_PosDetail.setModel(
getModle(
new String[] {"Message"},
new String[][] {{paragraph.getLanguage(line, "NOFORMATION")}})); // 將表格清空
}
} catch (SQLException e) {
ErrorMessage.setData(
"Staff",
"Frm_ Position",
"showTables()",
e.toString().substring(e.toString().lastIndexOf(".") + 1, e.toString().length()));
System.out.println(e);
}
}
public void initTables() {
ResultSet rs = null;
try {
rs = DBC.executeQuery("SELECT name FROM position");
this.tab_PosList.setModel(
new TableModels(rs, new String[] {paragraph.getLanguage(line, "POSITIONNAME")}));
} catch (SQLException e) {
ErrorMessage.setData(
"Staff",
"Frm_ Position",
"initTables()",
e.toString().substring(e.toString().lastIndexOf(".") + 1, e.toString().length()));
System.out.println(e);
}
tab_PosDetail.setModel(
getModle(
new String[] {paragraph.getLanguage(line, "MESSAGE")},
new String[][] {{paragraph.getLanguage(line, "NOINFORMATION")}}));
}
