yui表格背景变红
来源:互联网 发布:java虚拟器 编辑:程序博客网 时间:2024/04/29 13:28
<script language="javascript">pirl.subscribe("postRenderEvent",function(){ var allRows = this._elTbody.rows; for(var i=allRows.length-1; i>-1; i--) { //alert(allRows[i].id); var oRecord = this.getRecord(allRows[i].id); var isExpired=oRecord.getData('isExpired'); if(isExpired=='1'){ $("#" + allRows[i].id).css("backgroundColor","yellow"); }else if(isExpired=='2'){ $("#" + allRows[i].id).css("backgroundColor","#FC8383"); }else{ } }});</script>
sql
select TBASBASEINFO.BASEINFO_ID as baseInfoId, TBASBASEINFO.GENDER gender,TBASBASEINFO.BIRTHDAY birthday,TBASBASEINFO.NAME as name,TBASBASEINFO.ID_CARD as idCard,case when (TBAEXTINFO.ENGAGEMENT_DATE + 3 year - 6 month)>=current date then 0 when TBAEXTINFO.ENGAGEMENT_DATE+3 year <current date then 2 else 1 end isExpired, TBAEXTINFO.PERSON_NO as personNo, TBAEXTINFO.CATEGORY as category, TBAEXTINFO.TYPES as types, TBAEXTINFO.ENGAGEMENT_DATE as engagementDate, TBAEXTINFO.DISPOSE dispose, TBAEXTINFO.PROMOTION_DATE as promotionDate, TBAEXTINFO.CERTIFICATE_NO as certificateNo, TBASBASEINFO.AREA as area, TBAEXTINFO.EXTINFO_ID as extInfoId, TBASBASEINFO.ORGANIZATION as organization,TBAEXTINFO.CERTIFICATION as cretification,TBAEXTINFO.POWERSTAR as powerstar,TBAEXTINFO.FLAG_FOOD_ACC as flagFoodAcc,TBAEXTINFO.FLAG_PERSON as flagInner,TBAEXTINFO.FOCUS focus, V_YEARCOUNT.YEARCOUNT as yearCount,V_ALLCOUNT.ALLCOUNT as allCount, TBASBASEINFO.card ,TBASBASEINFO.USER_ID as userId,TBAEXTINFO.FLAG_AB flagAb FROM TBASBASEINFO, TBAEXTINFO LEFT JOIN V_YEARCOUNT ON TBAEXTINFO.EXTINFO_ID=V_YEARCOUNT.EXTINFOID LEFT JOIN V_ALLCOUNT ON TBAEXTINFO.EXTINFO_ID=V_ALLCOUNT.EXTINFOIDWHERE TBASBASEINFO.BASEINFO_ID = TBAEXTINFO.BASEINFO_ID
- yui表格背景变红
- Excel表格变红逻辑
- 移上去背景变红点击里文字变大
- 解决eclipse字体背景变红或者变绿的问题
- YUI
- yui
- YUI
- 表格背景的渐变
- 动态修改表格背景
- html表格背景颜色
- button 变红
- 表格背景渐变的实现
- JavaScript随机变换表格背景
- javascript定时更换表格背景
- 设置表格单元格交替背景
- swing jtable表格背景设置
- iphone 表格背景透明
- 鼠标经过背景变色,CSSJavascript实现表格背景变色
- 操作excel,错误 80040154
- Gotoblas 编译错误
- OpenWavePCMData
- PHP相关系列 - PHP异常详解
- VirtualLock
- yui表格背景变红
- 螺旋矩阵
- poi导出excel
- 一步一步写算法(之开篇)
- setTag()与getTag()
- Linux系统下的多线程编程入门二
- hdu1518
- 用ITaskbarList接口操纵Windows任务栏程序按钮的状态
- 一步一步写算法(之循环和递归)