1.jsp页面
//确认
function confirm(){
var wfarr = new Array();
var xml = AF.func("itemlist.GetChangedXML", "level=2; CompKeySep=;isValidateKey=false;");//获取选择行的xml
if(xml==""){
AF.func("MessageBoxFloat", "请选择一条数据!\r\n title=Prompt; icon=Information; hold=0");
return;
}
rows = AF.func("itemlist.FindAll", "chk==1").split(",");
var param = '{}';
AF.func("SetDialogFreeform", basepath+"/sz/xml/workflow/card_confirm.xml"); //指定要打开对话框的freeform
AF.func("SetDialogPara", "Title=意见填写;ExtWidth=4;IdOk=ok");
var ret = AF.func("OpenDialog", param);
if (ret == "confirm") { //如果点击的是"确认"按钮
var remark = AF.func("GetDialogValues", "");
if (rows != "") {
for ( var i = 0; i < rows.length; i++) {
wfarr[i] = {};
wfarr[i].applay_summary = remark;
wfarr[i].CARD_ID = AF.func("itemlist.GetCellData", rows[i]+"\r\n CARD_ID");
}
}
var url = pubAct;
pdata = {
busId:"zf_cardconfirm",
method:"cardConfirm", //修改成自己的功能码
confirmdata:$.toJSON(wfarr)
}
$.post(url,pdata,function(data){
if(data&&data.msg){
refreshData();
AF.func("MessageBoxFloat", data.msg+"\r\n title=Prompt; icon=Information; hold=3");
}else{
showMsgDialog(basepath,AF,data.msg,'info');
}
},"json");
}else if(ret=="back"){ //如果点击的是"退回"按钮
var remark = AF.func("GetDialogValues", "");
if (rows != "") {
for ( var i = 0; i < rows.length; i++) {
wfarr[i] = {};
wfarr[i].applay_summary = remark;
wfarr[i].CARD_ID = AF.func("itemlist.GetCellData", rows[i]+"\r\n CARD_ID");
}
}
var url = pubAct;
pdata = {
busId:"zf_cardconfirm",
method:"cardBack", //修改成自己的功能码
confirmdata:$.toJSON(wfarr)
}
$.post(url,pdata,function(data){
if(data&&data.msg){
refreshData();
AF.func("MessageBoxFloat", data.msg+"\r\n title=Prompt; icon=Information; hold=3");
}else{
showMsgDialog(basepath,AF,data.msg,'info');
}
},"json");
}else if(ret=="cancel"){ //如果点击的是"取消操作"按钮
callbackAdd();
}
}
2.dao
public Map<String, Object> auditConfirm(Map cp, Map param) throws Exception {
Map<String, Object> ret = new HashMap<String, Object>();
String msg="";
String alldata = PubTool.getMapValue(param, "alldata", "");//获取前台传过来的字符串(包含了所有的参数)
JSONArray jsons = JSONArray.fromObject(alldata);//将alldata转化成json格式的数组
for(Object o : jsons){
Map<String,Object> json2String_map = new HashMap<String,Object>();//此map集合用于保存将json格式的数据转化成字符串之后的数据
JSONObject jsonNode = JSONObject.fromObject(o);//获取每个json对象
json2String_map = PubTool.parseJSON2Map(jsonNode.toString());//parseJSON2Map是将每个json对象转化成字符串对象,并保存到了map结合中,因此要用map集合接受返回值
String str= PubTool.getMapValue(json2String_map, "ids", "");//获取map集合中的值(也就是自己xml里面的字段,这里取到的是主键PAYOFFDETAIL_ID)
String[] ids=str.split(",");
String option= PubTool.getMapValue(json2String_map, "applay_summary", ""); //获取map集合中的值(表示审核意见)
Map xmlFMap = XmlTools.readFreeFromXML(option);//解析freeForm提交的行数据xml到Map集合中(其实就是将.xml里面的“意见”转化成.java中的map集合)
option = (String) xmlFMap.get("auditopinion");//在解析之后的map集合中得到(get方法)数据(也就是将map集合转化成字符串),auditopinion表示是公共xml中的意见
/*if(option.equals("")){//如果没有填写审核意见,告诉操作人没有填写....
msg="请填写审核意见!";
ret.put("msg",msg);
return ret;
}*/
//List<Object> params = new ArrayList<Object>();
StringBuffer sql = new StringBuffer();
sql.append(" update TB_CARD_PAYOFFDETAIL set FLOW_STATUS=2 where PAYOFFDETAIL_ID in(");//Integer.parseInt()
for(int x=0;x<ids.length;x++){
sql.append(Integer.parseInt(ids[x])+",");
}
sql=sql.deleteCharAt(sql.length()-1);
sql=sql.append(")");
DBHelper.update(sql.toString());
msg="确认成功!";
ret.put("msg",msg);
}
return ret;
}