/***@description 根据主键查询Bean*/@RequestMapping(value="/getBean/{getId}")public void getBean(HttpServletRequest request,HttpServletResponse response,@PathVariable Object getId){if(getId!=null && getId.toString().length()>0){AppActivityDetails appActivityDetails=new AppActivityDetails();appActivityDetails.setId(Long.parseLong(getId.toString()));appActivityDetails=appActivityDetailsService.getT(appActivityDetails);super.writeClient(response, super.ObjectChangJSONObject(appActivityDetails).toString(), "");}}

{field:"opt",title:"操作",width:60,align:"center",                formatter:function(value,rowData,rowIndex){                  var html="";                  return html;                }

toolbar:[          {              id:'btnadd',              text:'添加',              iconCls:'icon-add',              handler:function(){                     showWinDetails(null);              }              },"-",]

 

function showWinMsGoods(id){      $("#idHiddenMsImage").val("");      $("#addtitleMsImage").val("");      $("#uploadImg1").attr("src", appPath + "/images/common/emptyImg.jpg");      $("#adddetailsImgMsImage").val("");      $("#uploadImg2").attr("src", appPath + "/images/common/emptyImg.jpg");      $("#addlinkMsImage").val("");      $("#addbeginTimeMsImage").datebox("setValue","");      $("#addendTimeMsImage").datebox("setValue","");      $("#addgoodsNoMsImage").val("");      var iconStr="icon-add";      if(id!=null){         iconStr="icon-edit";         $.post(            appPath+"/page/appActivityDetailsAct/getBean/"+id,             {},             function(data){               $("#idHiddenMsImage").val(data.id);               $("#addtitleMsImage").val(data.title);                              $("#adddetailsImgMsImage").val(data.detailsImg);               $("#uploadImg1").attr("src",data.detailsImg);               $("#addlinkMsImage").val(data.link);               $("#uploadImg2").attr("src",data.link);               //               $('#colorSelector3').css("background-color", data.backgroundColor);               $("#addbeginTimeMsImage").datebox("setValue",data.beginTime);               $("#addendTimeMsImage").datebox("setValue",data.endTime);               $("#addgoodsNoMsImage").val(data.goodsNo);            },"json");      }      $('#opreateHtmlMsGoods').window({            title:'编辑',            iconCls:iconStr,            width:500,            height:420,            left:200,            modal: true,            shadow: true,            collapsible:false,            minimizable:false,            maximizable:false      });      $('#opreateHtmlMsGoods').window('move',{top:100});      $('#opreateHtmlMsGoods').window('open');    }

/**  *@description 根据主键查询Bean  */  @RequestMapping(value="/getBean/{getId}")  public void getBean(HttpServletRequest request,HttpServletResponse response,@PathVariable Object getId)  {    if(getId!=null && getId.toString().length()>0){    AppActivityDetails appActivityDetails=new AppActivityDetails();    appActivityDetails.setId(Long.parseLong(getId.toString()));    appActivityDetails=appActivityDetailsService.getT(appActivityDetails);    super.writeClient(response, super.ObjectChangJSONObject(appActivityDetails).toString(), "");}  }

@Override    public T getT(T t) {        return (T)commonDao.queryForObject(t.getClass().getSimpleName()+".get"+t.getClass().getSimpleName(), t);

// getAppActivityDetails(与sql中的id名称一致)      //return commonDao.queryForObject("PharmacistComment.getpharmacistCommentPageByPageId",pharmacistComment);

 

}

         
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
        
             select id,        app_activity_list_id,        title,        details_img,        link,        publish_id,        goods_no,        background_color,        begin_time,        end_time,        standby1,        standby2,        is_delete,        add_time,        add_user_id,        edit_time,        edit_user_id from app_activity_details where IS_DELETE='N'  and  id=#id#  

 

 

//另一种方法

formatter : function(value, rowData,                                            rowIndex) {                                        var html = '';                                        html += " ";                                                                                }                                        return html;                                    }

toolbar : [ {                            id : 'btnExcel',                            text : '导出文件',                            iconCls : 'icon-exportExcel',                            handler : function() {                                exportExcel();                            }                        }, "-", {                            id : 'btnPass',                            text : '批量删除',                            iconCls : 'icon-cancel',                            handler : function() {                                deletes('');                            }                        }, "-", {                            id : 'btnOpen',                            text : '批量启动',                            iconCls : 'icon-ok',                            handler : function() {                                isOpen('');                            }                        }, "-", {                            id : 'btnClose',                            text : '批量关闭',                            iconCls : 'icon-cancel',                            handler : function() {                                isClose('');                            }                        }, "-", {                            id : 'btnMessage',                            text : '药师点评设置',                            iconCls : 'icon-search',                            handler : function() {                                showWin(null);                            }                        } ]/** * 编辑 * @param id */function showWin(id) {    $("#idHidden").val("");    CKEDITOR.instances.addpharmacistCommentMessage.setData('');    $("#addgoodsNo").val("");    $("#addgoodsName").val("");    $("#uploadImg").attr("src", '');    var iconStr = "icon-add";    var title = "添加药师点评设置";    if (id != null) {        iconStr = "icon-edit";        title = "编辑药师点评设置";        $.post(appPath + "/page/pharmacistCommentAct/getBean/" + id, {},                function(data) {                    $("#idHidden").val(data.pharmacistCommentId);                    CKEDITOR.instances.addpharmacistCommentMessage                            .setData(data.pharmacistCommentMessage);                    $("#addgoodsNo").val(data.goodsNo);                    $("#addgoodsName").val(data.goodsName);                    $("#uploadImg").attr("src", data.imgUrl);                }, "json");        $('#queryGoods').css('display', 'none');    } else {        $('#queryGoods').css('display', 'block');    }    $('#opreateHtml').window({        title : title,        iconCls : iconStr,        width : 800,        height : 600,        left : 200,        modal : true,        shadow : true,        collapsible : false,        minimizable : false,        maximizable : false    });    $('#opreateHtml').window('move', {        top : 0    });    $('#opreateHtml').window('open');}

/**     * @author wangchuanfu     * @description 用ID查询对象     */    @RequestMapping(value = "/getBean/{getId}")    @ResponseBody    public PharmacistComment getBean(HttpServletRequest request,            HttpServletResponse response, @PathVariable Long getId) {        PharmacistComment pharmacistComment = new PharmacistComment();        pharmacistComment.setPharmacistCommentId(getId);        return pharmacistCommentService                .getpharmacistCommentPageByPageId(pharmacistComment);    }

@Override    public PharmacistComment getpharmacistCommentPageByPageId(            PharmacistComment pharmacistComment) {        return (PharmacistComment) commonDao.queryForObject(                "PharmacistComment.getpharmacistCommentPageByPageId",                pharmacistComment);    }

              
               
               
               
               
               
               
           
              select pi.pro_image_url,        pc.goods_no,        DECODE(pc.is_online, 'N', '关闭', 'Y', '开启') as is_online,        pc.PHARMACIST_COMMENT_MESSAGE,        pc.PHARMACIST_COMMENT_ID,        su.user_real_name as EDIT_USER_NAME,        g.goods_name        from PHARMACIST_COMMENT pc        inner join goods g        on pc.goods_no = g.goods_no        and g.is_delete = 'N'        left join fecerp.sys_user su        on pc.edit_user_id = su.user_id        and su.is_delete = 'N'        left join product_img pi        on pi.product_id = g.product_id        where pc.IS_DELETE = 'N'        and rownum = 1        and pc.PHARMACIST_COMMENT_ID=#pharmacistCommentId#