首页上一页 1  下一页尾页 6 条记录 1/1页
        急等!!谢谢
                 	
                        发表在Java图书答疑
                        2010-06-03                                                
                    		
                                                                            	
                        
                        
                    
                    
                    	是否精华
                    	是
                    	否
                    
                    
                    
                            版块置顶:
                            是
                            否
                        
                    
                        设置时间:
                        非永久
                        永久            
                    
                    
                           起始时间:
                           结束时间:
                        
                    
                        是否扣分:
                        是
                        否
                    
                    
                    
                    
                
                                           《java项目开发全程实录》第3章企业人事管理系统里添加了考勤信息,在报表中却没有体现是什么问题        
                
        	
        
        
    精彩评论 6
                    2010-06-04
                   
                   
                   
                           
                           地板
                        
   
                   
                                                             where
this.tbAccountItem.name='迟到'
and (
(
startDate between to_date('2009-9-1','yyyy-mm-dd') and to_date('2009-9-1','yyyy-mm-dd')
or endDate between to_date('2009-9-1','yyyy-mm-dd') and to_date('2009-9-1','yyyy-mm-dd')
)
or (
to_date('2009-9-1','yyyy-mm-dd') between startDate and endDate
and to_date('2009-9-1','yyyy-mm-dd') between startDate and endDate
)
) */ select
tbtimecard0_.id as id10_,
tbtimecard0_.ratifier_dept_id as ratifier2_10_,
tbtimecard0_.record_id as record3_10_,
tbtimecard0_.ratifier_record_id as ratifier4_10_,
tbtimecard0_.account_item_id as account5_10_,
tbtimecard0_.explain as explain10_,
tbtimecard0_.start_date as start7_10_,
tbtimecard0_.end_date as end8_10_,
tbtimecard0_.ratifier_date as ratifier9_10_
from
tb_timecard tbtimecard0_,
tb_account_item tbaccounti1_
where
tbtimecard0_.record_id = ?
and tbtimecard0_.account_item_id=tbaccounti1_.id
and tbaccounti1_.name='迟到'
and (
tbtimecard0_.start_date between to_date('2009-9-1', 'yyyy-mm-dd') and to_date('2009-9-1', 'yyyy-mm-dd')
or tbtimecard0_.end_date between to_date('2009-9-1', 'yyyy-mm-dd') and to_date('2009-9-1', 'yyyy-mm-dd')
or (
to_date('2009-9-1', 'yyyy-mm-dd') between tbtimecard0_.start_date and tbtimecard0_.end_date
)
and (
to_date('2009-9-1', 'yyyy-mm-dd') between tbtimecard0_.start_date and tbtimecard0_.end_date
)
)
这是点击生成报表时控制台生成的一段代码,问题是不是出在tbtimecard0_.record_id = ? 上啊
                    
                
                
            this.tbAccountItem.name='迟到'
and (
(
startDate between to_date('2009-9-1','yyyy-mm-dd') and to_date('2009-9-1','yyyy-mm-dd')
or endDate between to_date('2009-9-1','yyyy-mm-dd') and to_date('2009-9-1','yyyy-mm-dd')
)
or (
to_date('2009-9-1','yyyy-mm-dd') between startDate and endDate
and to_date('2009-9-1','yyyy-mm-dd') between startDate and endDate
)
) */ select
tbtimecard0_.id as id10_,
tbtimecard0_.ratifier_dept_id as ratifier2_10_,
tbtimecard0_.record_id as record3_10_,
tbtimecard0_.ratifier_record_id as ratifier4_10_,
tbtimecard0_.account_item_id as account5_10_,
tbtimecard0_.explain as explain10_,
tbtimecard0_.start_date as start7_10_,
tbtimecard0_.end_date as end8_10_,
tbtimecard0_.ratifier_date as ratifier9_10_
from
tb_timecard tbtimecard0_,
tb_account_item tbaccounti1_
where
tbtimecard0_.record_id = ?
and tbtimecard0_.account_item_id=tbaccounti1_.id
and tbaccounti1_.name='迟到'
and (
tbtimecard0_.start_date between to_date('2009-9-1', 'yyyy-mm-dd') and to_date('2009-9-1', 'yyyy-mm-dd')
or tbtimecard0_.end_date between to_date('2009-9-1', 'yyyy-mm-dd') and to_date('2009-9-1', 'yyyy-mm-dd')
or (
to_date('2009-9-1', 'yyyy-mm-dd') between tbtimecard0_.start_date and tbtimecard0_.end_date
)
and (
to_date('2009-9-1', 'yyyy-mm-dd') between tbtimecard0_.start_date and tbtimecard0_.end_date
)
)
这是点击生成报表时控制台生成的一段代码,问题是不是出在tbtimecard0_.record_id = ? 上啊

 
	
                                                 VIP会员
VIP会员 购物车
购物车

 私信
                         私信 
                     发表新帖
发表新帖 立即签到
立即签到 
        		  
        		 
         		 关注
关注
                  回复
 回复 支持(
                	支持( 反对(
                    反对( 
               			  
                







 
                     
                     
					 
						 
						 
						 
						