81,092
社区成员
发帖
与我相关
我的任务
分享
StringBuffer q = new StringBuffer(); //バッファ
String pdtnm_tableName = CssDAO.getWithDBO(GmPdtnm.TABLE_NAME); //PDT名称テーブル名の保存
// PDT名称DBのフィールド名称配列
String [] pdtnm_fields = new String [] {
GmPdtnm.pdtkind, GmPdtnm.cd1, GmPdtnm.cd2, GmPdtnm.cd3,
GmPdtnm.snm1, GmPdtnm.snm2, GmPdtnm.nm, GmPdtnm.entdttm,
GmPdtnm.dttm, GmPdtnm.who,
};
// Select句の作成
q.append("SELECT ");
for(int i = 0; i < pdtnm_fields.length; i++){
q.append(pdtnm_fields[i]).append(", ");
}
q.append(" CASE WHEN ").append(GmPdtnm.pdtkind).append("=").append(GmPdtnm.PDTKIND7_PDT);
q.append(" THEN LPAD(TRIM(").append(GmPdtnm.cd1).append("),2,'0') ");
q.append(" ELSE ").append(GmPdtnm.cd1).append(" END AS cd1Sort,");
q.append(" LPAD(").append(GmPdtnm.pdtkind).append(",2,'8') AS SORTKEY ");
// From句の作成
q.append(" FROM ").append(pdtnm_tableName).append(" ");
// Where句の作成
q.append(" WHERE NOT ( ").append(GmPdtnm.pdtkind).append("=").append(GmPdtnm.PDTKIND7_PDT);
q.append(" AND ").append(GmPdtnm.cd1).append("=").append(GmPdtnm.PDTKIND7_PDT).append(") ");
if (searchCondition != null) {
String searchCondition_pdtkind = (String)searchCondition.get(PdtnmScreenParams.Pdtkind);
String searchCondition_snm1 = (String)searchCondition.get(PdtnmScreenParams.Snm1);
String searchCondition_snm2 = (String)searchCondition.get(PdtnmScreenParams.Snm2);
boolean b_where = false;
// PDT種別条件の付加
if ( searchCondition_pdtkind != null && searchCondition_pdtkind.length() > 0){
b_where = MasterCommon.EditWildCard(q, GmPdtnm.pdtkind, searchCondition_pdtkind, b_where);
}
if ( searchCondition_snm1 != null && searchCondition_snm1.length() > 0){
b_where = MasterCommon.EditWildCard(q, GmPdtnm.snm1, searchCondition_snm1, b_where);
}
if ( searchCondition_snm2 != null && searchCondition_snm2.length() > 0){
b_where = MasterCommon.EditWildCard(q, GmPdtnm.snm2, searchCondition_snm2, b_where);
}
}
// Order by句の作成
q.append("order by SORTKEY,cd1Sort");
q.append(", ").append(GmPdtnm.cd2);
q.append(", ").append(GmPdtnm.cd3);