nhibernate编程实例

thisform.grid1.recordsource='select *from base where alltrim(性别) symbol stray(1) and alltrim(部门名称) symbol stray(2) and alltrim(职称类别) symbol stray(3) and alltrim(从事专业) symbol stray(4) and alltrim(str(year(date())-year(工作时间))) symbol stray(7) and alltrim(str(year(date())-year(出生年月))) between stray(5) and stray(6) into cursor db2'