/** *@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="<img class='op-enable' src='"+appPath+"/js/lib/jquery-easyui/themes/icons/pencil.png' onClick='showWinMsGoods("+rowData.id+")' title='编辑'/>";
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);
}<resultMap id="AppActivityDetailsMap" class="AppActivityDetails"> <result column="DETAILS_IMG" property="detailsImg" /> <result column="STANDBY2" property="standby2" /> <result column="STANDBY1" property="standby1" /> <result column="ADD_USER_ID" property="addUserId" /> <result column="EDIT_TIME" property="editTime" /> <result column="IS_DELETE" property="isDelete" /> <result column="BACKGROUND_COLOR" property="backgroundColor" /> <result column="GOODS_NO" property="goodsNo" /> <result column="ADD_TIME" property="addTime" /> <result column="PUBLISH_ID" property="publishId" /> <result column="EDIT_USER_ID" property="editUserId" /> <result column="BEGIN_TIME" property="beginTime" /> <result column="LINK" property="link" /> <result column="ID" property="id" /> <result column="END_TIME" property="endTime" /> <result column="APP_ACTIVITY_LIST_ID" property="appActivityListId" /> <result column="TITLE" property="title" /> </resultMap> <select id="getAppActivityDetails" parameterClass="AppActivityDetails" resultMap="AppActivityDetailsMap"> 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# </select>
//另一种方法
formatter : function(value, rowData, rowIndex) { var html = ''; html += "<img class='op-enable' src='"+ appPath+ "/js/lib/jquery-easyui/themes/icons/pencil.png' onClick='showWin(" + rowData.pharmacistCommentId+ ")' title='编辑'/> "; } 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); }
<resultMap id="PharmacistCommentMapEdit" class="PharmacistComment"> <result column="IS_ONLINE" property="isOnline" /> <result column="PHARMACIST_COMMENT_MESSAGE" property="pharmacistCommentMessage" /> <result column="GOODS_NO" property="goodsNo" /> <result column="EDIT_USER_NAME" property="editUserName" /> <result column="PHARMACIST_COMMENT_ID" property="pharmacistCommentId" /> <result column="GOODS_NAME" property="goodsName" /> <result column="PRO_IMAGE_URL" property="imgUrl" /> </resultMap> <select id="getpharmacistCommentPageByPageId" resultMap="PharmacistCommentMapEdit" parameterClass="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# </select>