写一个动态生成编码(SM+yyMMDD+xxxx)

 

slSrvMoldOrder.,jsp

<span style="float: right"><a href="slSrvMoldOrderEdit.do?action=add"><img src='<%=ctxPath%>/image/admin/btn_add.gif'/>增加</a> </span>

slSrvMoldOrderEdit.js

function addForm(){   
var billNo = dbwtool.callDWRBusiness('SlSrvMoldOrderDWR.getNextBillNo');
  $('#billNo').val(billNo);
  $('#customerName').val('');
  $('#customerId').val('');
  $('#salesManId').val('');
  $('#salesManName').val('');
  $('#orderDate').val(fomateDate(new Date()));
   loadProcessLog(null);
   var tmpl=$("#tbody_tmpl").html();
   tmpl = tmpl.substring(tmpl.indexOf("<!--")+5,tmpl.indexOf("-->"));
   $("#tb_details").append(tmpl);
   $('#tb_details').grider({countRow:true,countRowAdd:true});
    $(document.getElementById("det[0][t1Test]")).datepicker({});
   action = 'add';
   clearValidate(".BaseInfo");  
}

 */ dbwtool.js

this.callDWRBusiness = function (target, params) {
if(!target) return null;


try {
DWREngine.setAsync(false);


var returnData = null;
var code = target + "(";
if(params && params.length) {
for(var i = 0; i < params.length; i++) {
code += "params[" + i + "], ";
}
}


code += "{"
+ " callback: function(retData){"
+ " returnData = retData;"
+ " },"
+ " errorHandler:function(errMsg, dwrException) {"
/*+ " if(typeof uumError == 'function') {"*/
+ " returnData = dwrException;"
/*+ " }"*/
+ " }"
+ "})";


eval(code);


return returnData;
} catch (e) {
alert("data.callDWRBusiness: " + e.message);
return null;
}
};

SlSrvMoldOrderDWR,java

public String getNextBillNo() throws Exception {
log.debug("getNextBillNoat dwr level");
try {
return slSrvMoldOrderService.getNextBillNo();
} catch (ServiceException e) {
log.error(e);
return null;
}

slSrvMoldOrderServiceImpl.java

public String getNextBillNo() throws ServiceException {
String prefix=dictionaryDAO.getDictionaryName(Constants.PREFIX_BILLTYPE, Integer.parseInt(Constants.PREFIX_SRV_MOLDORDER)); //得到SM 
DateFormat date=new SimpleDateFormat("yyyyMMdd");
String str=date.format(new Date());//得到SM+时间
prefix=prefix.concat(str);
return slSrvMoldOrderDAO.getNextBillNo(prefix);
}

slSrvMoldOrderDAOImpl

public String getNextBillNo(String prefix) throws DataAccessException {
Session session = this.getSession();
String sql = " select isnull(max(substring(bill_no,11,4)),0) + 1 from sl_srv_moldorder ";
Query q = session.createSQLQuery(sql);
String max = Constants.getFullCode(q.uniqueResult().toString());//得到0033四位数
return prefix.concat(max);返回SM201208150033
}