jsp部分:
<label class="control-label col-sm-1" for="letterCd">信函模板代码</label>
<div class='controls col-sm-2'>
<select class="form-control " id="letterCd"
name="letterCd"></select>
</div>
</div>
js部分:
$(document).ready(function() {
initDatatableList();
getSmsModelName();
});
//加载信函模板代码【因为其他页面也用了这个JS,所以需要点击时加载】
function getSmsModelName() {
var html;
$.ajax({
url : ctx + "/pls/letterWork/getLetterTemplateCode.in",
type : 'post',
dataType : 'json',
success : function(data) {
html += "<option value = ''> - - 请选择 - - </option>";
for (var i = 0; i < data.length; i++) {
html += "<option value=" + data[i].letterCd+ ">"
+ data[i].letterCd + "</option>";
}
$("#letterCd").html(html);
}
});
}
java部分:
@RequestMapping(value = "getLetterTemplateCode.in")
@ResponseBody
public String getSmsModelName() {
try {
return JSON.toJSONStringWithDateFormat(plsLetterWorkSufaceApi.getLetterTemplateCode(),
DateFormatPatternConstants.DATETIME_DASH_COLON, SerializerFeature.WriteDateUseDateFormat);
} catch (Exception e) {
RespCode.E_001.exception(e.getMessage());
logger.error("查询短信模板失败"+e.getMessage());
return null;
}
}
// 信函代码查询
@Override
public List<TmPrmLetter> getLetterTemplateCode() {
return new JPAQueryFactory(em).select(qTmPrmLetter).from(qTmPrmLetter).where(qTmPrmLetter.letterType.eq("L")).fetch();
}