171206之在加载数据的时候加载操作

来源：互联网发布：杭州软件开发编辑：程序博客网时间：2024/06/04 18:54

在加载数据的时候加载操作(就是每一行都有个验证、删除、查看的操作)
这里写图片描述

        <powersi:datagrid id="dg_importFile_info" fromId="mainForm" height="200" delayLoad="true"  checkbox="false">            <powersi:datagrid-column display="操  作" frozen="true" render="renderOperateMedia"  width="120" minWidth="80" />            <powersi:datagrid-column name="bkc033"  display="导入文件名" width="100%" minWidth="200"/>            <powersi:datagrid-column name="num"  display="总条数" width="80" minWidth="50"/>            <powersi:datagrid-column name="bkc032"  display="导入时间" width="90" minWidth="60"   format="{0,date,yyyy-MM-dd}" />            <powersi:datagrid-column name="bkc030"  display="导入人"  width="100" minWidth="80" />            <powersi:datagrid-column name="bkc040n"  display="导入情况" width="100" minWidth="60"/>            <powersi:datagrid-column name="bkc252n"  display="验证情况" width="100" minWidth="60"/>            <powersi:datagrid-column name="bkc133"  hide="true" />        </powersi:datagrid>

在操作那行调用加载方法

function renderOperateMedia(row, index, value) {        var a = [];        a.push('<input type="button" value="验证" class="linkButton"');        a.push(' onclick="checkmediaInfo(');        a.push(index);        a.push(')"');        a.push(" />");        a.push("&nbsp&nbsp");        a.push('<input type="button" value="删除" class="linkButton"');        a.push(' onclick="delMediaInfo(');        a.push(index);        a.push(')"');        a.push(" />");        a.push("&nbsp&nbsp");        a.push('<input type="button" value="查看" class="linkButton"');        a.push(' onclick="showMediaInfo(');        a.push(index);        a.push(')"');        a.push(" />");        return a.join('');    }

//验证

    function checkmediaInfo(i){        var row = dg_importFile_info.getRow(i);        var bkc252 = row['bkc252n'];        if(!(bkc252=="未验证")){            alert("该记录已验证过，无需再验证，具体信息请查看验证信息！");            return;        }        var bkc133 = row['bkc133'];        $("#bkc133").val(bkc133);        $("#bkc040").val(row['bkc040n']);        postJSON("${rootPath}/medicare/NzSelectHospSettleAction!checkNzjsInfo.action",                {"bkc133":bkc133}, showCheckInfo);    }

/**
* 验证上传的结算数据
*/

    public String checkNzjsInfo() {        try {            String bkc133 = this.getParameter("bkc133");            List checkInfo = mhs.checkNzjsInfo(bkc133);            //更新导入文件信息            List importFile = mhs.queryImportFile(Long.valueOf(bkc133));            Map<String, Object> map = new HashMap<String, Object>();            map.put("importFile", importFile);            map.put("checkInfo", checkInfo);            setJSONReturn(map);        } catch (Exception e) {            this.saveJSONError("校检出错！" + e.getMessage());        }        return NONE;    }

//删除

    function delMediaInfo(i){        var row = dg_importFile_info.getRow(i);        var bkc133 = row['bkc133'];        postJSON("${rootPath}/medicare/NzSelectHospSettleAction!deleteFile.action",                {"bkc133":bkc133}, showMenuInfo2_deleitem);        dg_importFile_info.deleteRow(i);        $("#bkc133").val('');    }

/** * 删除年终结算导入数据 */

    public String deleteFile() {        try {            String bkc133 = this.getParameter("bkc133");            mhs.deleteMzFile(bkc133);            this.saveJSONMessage("删除成功！");        } catch (Exception e) {            this.saveJSONError("删除失败！" + e.getMessage());        }        return NONE;    }/**     * 删除年终结算导入数据     */    public void deleteMzFile(String bkc133){        dao.deleteMzFile(bkc133);    }    public void deleteMzFile(String bkc133){        StringBuffer lSQL1 = new StringBuffer();        StringBuffer lSQL2 = new StringBuffer();        lSQL1.append(" delete from kb77 where bkc133 = '" + bkc133 + "' ");        lSQL2.append(" delete from kad6 where bkc133 = '" + bkc133 + "' ");        DBHelper.executeUpdate(lSQL1.toString());        DBHelper.executeUpdate(lSQL2.toString());    }

//查看验证情况

    function showMediaInfo(i){        var row = dg_importFile_info.getRow(i);        var bkc133 = row['bkc133'];        $("#bkc133").val(bkc133);        $("#bkc252").val(row['bkc252n']);        $("#bkc040").val(row['bkc040n']);        postJSON("${rootPath}/medicare/NzSelectHospSettleAction!queryCheckKb77.action",                {"bkc133":bkc133}, showMenuInfo2_item);    }

/**
* 查看年终结算导入数据
*/

    public String queryCheckKb77() {        try {            String bkc133 = this.getParameter("bkc133");            String bkc252 = this.getParameter("bkc252") ==                    null ? "" : this.getParameter("bkc252").toString();            List list = mhs.queryCheckKB77(bkc133, bkc252);            setJSONReturn(list);        } catch (Exception e) {            this.saveJSONError("查询出错！" + e.getMessage());        }        return NONE;    }public List queryCheckKB77(String bkc133,String bkc252){        return  dao.queryCheckKB77(bkc133, bkc252);    }public List queryCheckKB77(String bkc133,String bkc252){        StringBuffer lSQL = new StringBuffer();        lSQL.append(" select t.kb77id, ");        lSQL.append("        t.akb020, ");        lSQL.append("        t.bkc133, ");        lSQL.append("        t.aaz218, ");        lSQL.append("        t.aac001, ");        lSQL.append("        t.aac002, ");        lSQL.append("        t.akc185, ");        lSQL.append("        t.akc196, ");        lSQL.append("        t.yzy207, ");        lSQL.append("        t.yzy208, ");        lSQL.append("        t.bkb135, ");        lSQL.append("        t.aae100, ");        lSQL.append("        t.bkc252, ");        lSQL.append("        t.bkc040, ");        lSQL.append("        t.aae111, ");        lSQL.append("        t.aae001, ");        lSQL.append("        t.bkb134, ");        lSQL.append("        decode(t.bkc040, '1', '已导入', '0', '未导入', t.bkc040) as bkc040n, ");        lSQL.append("        decode(t.bkc252, ");        lSQL.append("               '1', ");        lSQL.append("               '验证通过', ");        lSQL.append("               '0', ");        lSQL.append("               '未验证', ");        lSQL.append("               '-1', ");        lSQL.append("               '验证不通过', ");        lSQL.append("               '2', ");        lSQL.append("               '部分验证通过', ");        lSQL.append("               t.bkc252) as bkc252n ");        lSQL.append("   from KB77 t ");        lSQL.append("  where t.bkc133='"+bkc133+"' ");        if(StringUtils.isNotEmpty(bkc252)){            lSQL.append("    and t.bkc252='"+bkc252+"' ");        }        return DBHelper.executeList(lSQL.toString());//list带了列名，arraylist不带列名;    }

阅读全文

0 0