vfp做的企業(yè)人事管理系統(tǒng)方案-文庫吧在線文庫
【正文】 息表 where 職工號(hào)=gettid and 姓名=getname into cursor aa=aaendifif flag1=0 and flag2=1 and flag3=1select * from 職工信息表 where 姓名=getname and 所屬部門=getdepart into cursor aa=aaendifif flag1=1 and flag2=0 and flag3=1select * from 職工信息表 where 職工號(hào)=getid and 所屬部門=getdepart into cursor aa=aaendifif flag1=1 and flag2=1 and flag3=1select * from 職工信息表 where 職工號(hào)=getid and 姓名=getname and 所屬部門=getdepart into cursor aa=aaendif“清除”代碼如下：=0=0=0====“統(tǒng)計(jì)”代碼如下：do case case =1 select 性別,count(*) as 人數(shù) from 職工信息表 group by 性別 into cursor xx =xx case =2 select 所屬部門,count(*) as 人數(shù) from 職工信息表 group by 所屬部門 into cursor yy =yy case =3 select 學(xué)歷,count(*) as 人數(shù) from 職工信息表 group by 學(xué)歷 into cursor zz =zz case =4 select 政治面貌,count(*) as 人數(shù) from 職工信息表 gro
公司管理相關(guān)推薦
鄂ICP備17016276號(hào)-1