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

在加载数据的时候加载操作(就是每一行都有个验证、删除、查看的操作)

        <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不带列名;
    }