KTKP-077_ -|五内俱焚├双流县兴隆镇老年大学
淘宝减肥药排行榜十强
只推淘宝安全有效的减肥药

当前位置:KTKP-077 > 减肥产品

KTKP-077

时间:2020-08-04 19:01  编辑:米脂工商银行

KTKP-077

一、系统维护

1.

二、学生管理

1.学生注册

2.数据导入

3.学生收费、注册初始设置

4.学籍管理

信息维护:select*fromxsjbxxbawhere1=1andxzb='08旅1'andcc='本科'andxjzt='有'and1=1orderbydqszjdesc(基本信息)

select*fromxsjtbviewwhere1=1andxhin(selectxhfromxsjbxxbwherexzb='08旅1'andcc='本科'andxjzt='有')(家庭信息)

select*fromxsrxcjviewwhere1=1andxhin(selectxhfromxsjbxxbwherexzb='08旅1'andcc='本科'andxjzt='有')(入学成绩)

学籍异动:select*fromxjydbwherexn='2010-2011'andxq='2'and1=1

(点统计按钮)

selectcount(decode(ydlb,'跳级',xh,null))asx1,count(decode(ydlb,'保留学籍',xh,null))asx2,count(decode(ydlb,'取消入学资格',xh,null))asx3,count(decode(ydlb,'转学(转出)',xh,null))asx4,count(decode(ydlb,'转学(转入)',xh,null))asx5,count(decode(ydlb,'其他',xh,null))asx6,count(decode(ydlb,'毕业',xh,null))asx7,count(decode(ydlb,'开除学籍',xh,null))asx8,count(decode(ydlb,'延长学制',xh,null))asx9,count(decode(ydlb,'复学',xh,null))asx10,count(decode(ydlb,'转专业',xh,null))asx11,count(decode(ydlb,'调班',xh,null))asx12,count(decode(ydlb,'留级',xh,null))asx13,count(decode(ydlb,'退学',xh,null))asx14,count(decode(ydlb,'保留入学资格',xh,null))asx15,count(decode(ydlb,'休学',xh,null))asx16,count(decode(ydlb,'放弃入学资格',xh,null))asx17fromxjydbwhere1=1andczrq>='2011-04-01'andczrqbzbrsthenfloor((zrs-bzbrs)/10)/10+xselseto_number(xs)endzhxsfrom(selecta.*,b.bzbrs,c.xsfromjszgljsb1aleftjoin(Selecta.kcdm,b.bzbrsFromkcdlbzbmxbaLeftJoinkcdlbzbdmbbOna.dldm=b.dldm)bona.kcdm=b.kcdmleftjoin(Selecta.kcdm,b.xsFromkcdlxskcbaLeftJoinkcdlxsbbOna.dldm=b.dldm)cona.kcdm=c.kcdm))

9.按时间工作量计算

10.查询学年工作量

11.统计信息

教师职称统计表

select'2010-2011'学年度,bm部门,count(zgh)教师总数,count(decode(zc,'教授',zgh,null))as教授,trim(to_char(count(decode(zc,'教授',zgh,null))*100/count(zgh),'990.99'))as教授比例,count(decode(zc,'副教授',zgh,null))as副教授,trim(to_char(count(decode(zc,'副教授',zgh,null))*100/count(zgh),'990.99'))as副教授比例,count(decode(zc,'讲师',zgh,null))as讲师,trim(to_char(count(decode(zc,'讲师',zgh,null))*100/count(zgh),'990.99'))as讲师比例,count(decode(zc,'助教',zgh,null))as助教,trim(to_char(count(decode(zc,'助教',zgh,null))*100/count(zgh),'990.99'))as助教比例,count(decode(instr('教授副教授讲师助教',zc),0,zgh,null))as其他职称,trim(to_char(count(decode(instr('教授副教授讲师助教',zc),0,zgh,null))*100/count(zgh),'990.99'))as其他职称比例,count(decode(to_char(instr('教授副教授讲师助教',zc))||'Z','Z',zgh,null))as无职称,trim(to_char(count(decode(to_char(instr('教授副教授讲师助教',zc))||'Z','Z',zgh,null))*100/count(zgh),'990.99'))as无职称比例fromjsxxbgroupbybm,'2010-2011'unionallselect'总计','',count(zgh)教师总数,count(decode(zc,'教授',zgh,null))as教授,trim(to_char(count(decode(zc,'教授',zgh,null))*100/count(zgh),'990.99'))as教授比例,count(decode(zc,'副教授',zgh,null))as副教授,trim(to_char(count(decode(zc,'副教授',zgh,null))*100/count(zgh),'990.99'))as副教授比例,count(decode(zc,'讲师',zgh,null))as讲师,trim(to_char(count(decode(zc,'讲师',zgh,null))*100/count(zgh),'990.99'))as讲师比例,count(decode(zc,'助教',zgh,null))as助教,trim(to_char(count(decode(zc,'助教',zgh,null))*100/count(zgh),'990.99'))as助教比例,count(decode(instr('教授副教授讲师助教',zc),0,zgh,null))as其他职称,trim(to_char(count(decode(instr('教授副教授讲师助教',zc),0,zgh,null))*100/count(zgh),'990.99'))as其他职称比例,count(decode(to_char(instr('教授副教授讲师助教',zc))||'Z','Z',zgh,null))as无职称,trim(to_char(count(decode(to_char(instr('教授副教授讲师助教',zc))||'Z','Z',zgh,null))*100/count(zgh),'990.99'))as无职称比例fromjsxxbgroupby'总计',''

教师学历统计表

select'2010-2011'学年度,bm部门,count(zgh)教师总数,count(decode(xl,'博士',zgh,null))as博士,trim(to_char(count(decode(xl,'博士',zgh,null))*100/count(zgh),'990.99'))as博士比例,count(decode(xl,'硕士',zgh,null))as硕士,trim(to_char(count(decode(xl,'硕士',zgh,null))*100/count(zgh),'990.99'))as硕士比例,count(decode(xl,'研究生',zgh,null))as研究生,trim(to_char(count(decode(xl,'研究生',zgh,null))*100/count(zgh),'990.99'))as研究生比例,count(zgh)-count(decode(xl,'博士',zgh,null))-count(decode(xl,'硕士',zgh,null))-count(decode(xl,'研究生',zgh,null))本科及以下,trim(to_char((count(zgh)-count(decode(xl,'博士',zgh,null))-count(decode(xl,'硕士',zgh,null))-count(decode(xl,'研究生',zgh,null)))*100/count(zgh),'990.99'))本科及以下比例fromjsxxbgroupbybm,'2010-2011'unionallselect'总计','',count(zgh)教师总数,count(decode(xl,'博士',zgh,null))as博士,trim(to_char(count(decode(xl,'博士',zgh,null))*100/count(zgh),'990.99'))as博士比例,count(decode(xl,'硕士',zgh,null))as硕士,trim(to_char(count(decode(xl,'硕士',zgh,null))*100/count(zgh),'990.99'))as硕士比例,count(decode(xl,'研究生',zgh,null))as研究生,trim(to_char(count(decode(xl,'研究生',zgh,null))*100/count(zgh),'990.99'))as研究生比例,count(zgh)-count(decode(xl,'博士',zgh,null))-count(decode(xl,'硕士',zgh,null))-count(decode(xl,'研究生',zgh,null))本科及以下,trim(to_char((count(zgh)-count(decode(xl,'博士',zgh,null))-count(decode(xl,'硕士',zgh,null))-count(decode(xl,'研究生',zgh,null)))*100/count(zgh),'990.99'))本科及以下比例fromjsxxbgroupby'总计',''

教师年龄统计表

select'2010-2011'学年,bm部门,count(zgh)教师总数,count(decode(floor((2012-to_number(substr(csrq,1,4))+1)/35),0,zgh,null))x1,trim(to_char(count(decode(floor((2012-to_number(substr(csrq,1,4))+1)/35),0,zgh,null))*100/count(zgh),'990.99'))x11,count(decode(ceil(((2012-to_number(substr(csrq,1,4))+1)-35)/5),1,zgh,null))x2,trim(to_char(count(decode(ceil(((2012-to_number(substr(csrq,1,4))+1)-35)/5),1,zgh,null))*100/count(zgh),'990.99'))x21,count(decode(ceil(((2012-to_number(substr(csrq,1,4))+1)-40)/5),1,zgh,null))x3,trim(to_char(count(decode(ceil(((2012-to_number(substr(csrq,1,4))+1)-40)/5),1,zgh,null))*100/count(zgh),'990.99'))x31,count(decode(ceil(((2012-to_number(substr(csrq,1,4))+1)-45)/5),1,zgh,null))x4,trim(to_char(count(decode(ceil(((2012-to_number(substr(csrq,1,4))+1)-45)/10),1,zgh,null))*100/count(zgh),'990.99'))x41,count(decode(floor((2012-to_number(substr(csrq,1,4))+1)/56),0,null,zgh))x5,trim(to_char(count(decode(floor((2012-to_number(substr(csrq,1,4))+1)/56),0,null,zgh))*100/count(zgh),'990.99'))x51fromjsxxbgroupby'2010-2011',bmunionallselect'2010-2011'学年,''部门,count(zgh)教师总数,count(decode(floor((2012-to_number(substr(csrq,1,4))+1)/35),0,zgh,null))x1,trim(to_char(count(decode(floor((2012-to_number(substr(csrq,1,4))+1)/35),0,zgh,null))*100/count(zgh),'990.99'))x11,count(decode(ceil(((2012-to_number(substr(csrq,1,4))+1)-35)/5),1,zgh,null))x2,trim(to_char(count(decode(ceil(((2012-to_number(substr(csrq,1,4))+1)-35)/5),1,zgh,null))*100/count(zgh),'990.99'))x21,count(decode(ceil(((2012-to_number(substr(csrq,1,4))+1)-40)/5),1,zgh,null))x3,trim(to_char(count(decode(ceil(((2012-to_number(substr(csrq,1,4))+1)-40)/5),1,zgh,null))*100/count(zgh),'990.99'))x31,count(decode(ceil(((2012-to_number(substr(csrq,1,4))+1)-45)/5),1,zgh,null))x4,trim(to_char(count(decode(ceil(((2012-to_number(substr(csrq,1,4))+1)-45)/10),1,zgh,null))*100/count(zgh),'990.99'))x41,count(decode(floor((2012-to_number(substr(csrq,1,4))+1)/56),0,null,zgh))x5,trim(to_char(count(decode(floor((2012-to_number(substr(csrq,1,4))+1)/56),0,null,zgh))*100/count(zgh),'990.99'))x51fromjsxxbgroupby'2010-2011',''

教授、副教授上课情况

select'2010-2011'学年,bm部门,count(zgh)教师总数,count(decode(to_char(floor((2012-to_number(substr(csrq,1,4))+1)/56))||skqk,'01',zgh,null))x1,trim(to_char(count(decode(to_char(floor((2012-to_number(substr(csrq,1,4))+1)/56))||skqk,'01',zgh,null))*100/count(zgh),'990.99'))x11,count(decode(to_char(floor((2012-to_number(substr(csrq,1,4))+1)/56))||skqk||zc,'01教授',zgh,null))x2,trim(to_char(count(decode(to_char(floor((2012-to_number(substr(csrq,1,4))+1)/56))||skqk||zc,'01教授',zgh,null))*100/count(zgh),'990.99'))x21,count(decode(to_char(floor((2012-to_number(substr(csrq,1,4))+1)/56))||skqk||zc,'01副教授',zgh,null))x3,trim(to_char(count(decode(to_char(floor((2012-to_number(substr(csrq,1,4))+1)/56))||skqk||zc,'01副教授',zgh,null))*100/count(zgh),'990.99'))x31,count(decode(to_char(ceil((2012-to_number(substr(csrq,1,4))+1)/55))||skqk,'21',zgh,null))x4,trim(to_char(count(decode(to_char(ceil((2012-to_number(substr(csrq,1,4))+1)/55))||skqk,'21',zgh,null))*100/count(zgh),'990.99'))x41,count(decode(to_char(ceil((2012-to_number(substr(csrq,1,4))+1)/55))||skqk||zc,'21教授',zgh,null))x5,trim(to_char(count(decode(to_char(ceil((2012-to_number(substr(csrq,1,4))+1)/55))||skqk||zc,'21教授',zgh,null))*100/count(zgh),'990.99'))x51,count(decode(to_char(ceil((2012-to_number(substr(csrq,1,4))+1)/55))||skqk||zc,'21副教授',zgh,null))x6,trim(to_char(count(decode(to_char(ceil((2012-to_number(substr(csrq,1,4))+1)/55))||skqk||zc,'21副教授',zgh,null))*100/count(zgh),'990.99'))x61from(selectdistinctzgh,csrq,zc,skqk,bmfromjsxxbaleftjoin(selectdistinctjszgh,'1'skqkfromjxrwbviewwherexn='2010-2011'unionselectdistinctjszgh,'1'skqkfromdgjsskxxbwherexkkhlike'(2010-2011%')bona.zgh=b.jszgh)groupby'2010-2011',bmunionallselect'2010-2011'学年,''部门,count(zgh)教师总数,count(decode(to_char(floor((2012-to_number(substr(csrq,1,4))+1)/56))||skqk,'01',zgh,null))x1,trim(to_char(count(decode(to_char(floor((2012-to_number(substr(csrq,1,4))+1)/56))||skqk,'01',zgh,null))*100/count(zgh),'990.99'))x11,count(decode(to_char(floor((2012-to_number(substr(csrq,1,4))+1)/56))||skqk||zc,'01教授',zgh,null))x2,trim(to_char(count(decode(to_char(floor((2012-to_number(substr(csrq,1,4))+1)/56))||skqk||zc,'01教授',zgh,null))*100/count(zgh),'990.99'))x21,count(decode(to_char(floor((2012-to_number(substr(csrq,1,4))+1)/56))||skqk||zc,'01副教授',zgh,null))x3,trim(to_char(count(decode(to_char(floor((2012-to_number(substr(csrq,1,4))+1)/56))||skqk||zc,'01副教授',zgh,null))*100/count(zgh),'990.99'))x31,count(decode(to_char(ceil((2012-to_number(substr(csrq,1,4))+1)/55))||skqk,'21',zgh,null))x4,trim(to_char(count(decode(to_char(ceil((2012-to_number(substr(csrq,1,4))+1)/55))||skqk,'21',zgh,null))*100/count(zgh),'990.99'))x41,count(decode(to_char(ceil((2012-to_number(substr(csrq,1,4))+1)/55))||skqk||zc,'21教授',zgh,null))x5,trim(to_char(count(decode(to_char(ceil((2012-to_number(substr(csrq,1,4))+1)/55))||skqk||zc,'21教授',zgh,null))*100/count(zgh),'990.99'))x51,count(decode(to_char(ceil((2012-to_number(substr(csrq,1,4))+1)/55))||skqk||zc,'21副教授',zgh,null))x6,trim(to_char(count(decode(to_char(ceil((2012-to_number(substr(csrq,1,4))+1)/55))||skqk||zc,'21副教授',zgh,null))*100/count(zgh),'990.99'))x61from(selectdistinctzgh,csrq,zc,skqk,bmfromjsxxbaleftjoin(selectdistinctjszgh,'1'skqkfromjxrwbviewwherexn='2010-2011'unionselectdistinctjszgh,'1'skqkfromdgjsskxxbwherexkkhlike'(2010-2011%')bona.zgh=b.jszgh)groupby'2010-2011',''

四、教学计划管理

1.数据导入

2.课程库管理

3.专业计划管理

4.执行计划更改申请

5.校历管理

日期开始周设置

select*fromrqkszbwhere1=1andxn='2010-2011'andxq='2'orderbynyr

6.教学任务管理

校公选课申请处理

select*fromgxksqbwherexn='2009-2010'andxq='2'and1=1andkkxy='管理学院'

7.综合查询

8.报表打印

9.查询统计分析

五、智能排课

1.排课数据条件设置

2.教学场地

3.板块课程安排

4.排课数据初始化

5.系统智能排课

6.系统智能排课(正在修改。。)

7.人机交互式排课

8.人机交互式排课(正在修改。)

9.排课数据返回

10.换教师、起止周、周次

select*from(selectdistincta.kcdm,a.kcmc,a.jszgh,a.jsxm,a.sksj,a.skdd,a.xkkh,a.kkxy,a.qsjsz,a.zxs,a.xqyq,a.cdbs,a.yxrs,(selectmax(trim(rpad(f.bjhz,127,'')))fromjxbmc_xyviewfwheref.xkkh=a.xkkh)bjhzfrom(selecta.kcdm,a.kcmc,a.jszgh,a.jsxm,a.sksj,a.skdd,a.xkkh,a.kkxy,a.qsjsz,a.zxs,a.xqyq,a.cdbs,a.yxrsfromjxrwbviewawherea.xkkhlike'(2010-2011-1)-%'and(a.xkzt'4'ora.xkztisnull)anda.tab'jxrwb'andkkxy='应用文理学院'andsubstr(jxjhh,1,4)='2008'unionallselecta.kcdm,a.kcmc,trim(substr(a.jszgh,1,20))jszgh,trim(substr(a.jsxm,1,50))jsxm,a.sksj,a.skdd,a.xkkh,a.kkxy,a.qsjsz,a.zxs,a.xqyq,a.cdbs,a.yxrsfrom(selecta.kcdm,a.kcmc,substr(a.js,1,casewheninstr(a.js,'|',1,1)0theninstr(a.js,'|',1,1)elselength(a.js)+1end-(1))jszgh,substr(a.js,casewheninstr(a.js,'|',1,1)0theninstr(a.js,'|',1,1)elselength(a.js)+1end+1,casewheninstr(a.js,'|',1,2)0theninstr(a.js,'|',1,2)elselength(a.js)+1end-(casewheninstr(a.js,'|',1,1)0theninstr(a.js,'|',1,1)elselength(a.js)+1end+1))jsxm,a.sksj,a.skdd,a.xkkh,a.kkxy,a.qsjsz,a.zxs,a.xqyq,a.cdbs,a.yxrsfromjxrwb_xyview1awherea.xkkhlike'(2010-2011-1)-%'and(a.xkzt'4'ora.xkztisnull)andkkxy='应用文理学院'andsubstr(jxjhh,1,4)='2008')a)awherea.xkkhlike'(2010-2011-1)-%')orderbyxkkh

11.调、停(补)课申请及处理

12.其它课上课时间地点安排

13.查询打印

课程上课情况查询

select*from(selectdistincta.kcdm,a.kcmc,a.jszgh,a.jsxm,a.sksj,a.skdd,a.xkkh,a.kkxy,a.qsjsz,a.zxs,a.xqyq,a.cdbs,a.yxrs,(selectmax(trim(rpad(f.bjhz,127,'')))fromjxbmc_xyviewfwheref.xkkh=a.xkkh)bjhzfrom(selecta.kcdm,a.kcmc,a.jszgh,a.jsxm,a.sksj,a.skdd,a.xkkh,a.kkxy,a.qsjsz,a.zxs,a.xqyq,a.cdbs,a.yxrsfromjxrwbviewawherea.xkkhlike'(2010-2011-1)-%'and(a.xkzt'4'ora.xkztisnull)anda.tab'jxrwb'andkkxy='应用文理学院'andsubstr(jxjhh,1,4)='2008'unionallselecta.kcdm,a.kcmc,trim(substr(a.jszgh,1,20))jszgh,trim(substr(a.jsxm,1,50))jsxm,a.sksj,a.skdd,a.xkkh,a.kkxy,a.qsjsz,a.zxs,a.xqyq,a.cdbs,a.yxrsfrom(selecta.kcdm,a.kcmc,substr(a.js,1,casewheninstr(a.js,'|',1,1)0theninstr(a.js,'|',1,1)elselength(a.js)+1end-(1))jszgh,substr(a.js,casewheninstr(a.js,'|',1,1)0theninstr(a.js,'|',1,1)elselength(a.js)+1end+1,casewheninstr(a.js,'|',1,2)0theninstr(a.js,'|',1,2)elselength(a.js)+1end-(casewheninstr(a.js,'|',1,1)0theninstr(a.js,'|',1,1)elselength(a.js)+1end+1))jsxm,a.sksj,a.skdd,a.xkkh,a.kkxy,a.qsjsz,a.zxs,a.xqyq,a.cdbs,a.yxrsfromjxrwb_xyview1awherea.xkkhlike'(2010-2011-1)-%'and(a.xkzt'4'ora.xkztisnull)andkkxy='应用文理学院'andsubstr(jxjhh,1,4)='2008')a)awherea.xkkhlike'(2010-2011-1)-%')orderbyxkkh

学期课程查询

select*from(selectsubstr(a.jxjhh,1,4)nj,a.kcdm,a.kcmc,a.kcxz,a.xf,a.jszgh,a.jsxm,sum(a.rs)xss,(selectcount(f.xh)fromxsxkbfwheref.xkkh=a.xkkh)yxrs,a.sksj,a.skdd,a.kkxy,a.xkkh,a.xkzt,(selectmax(trim(rpad(b.bjhz,127,'')))fromjxbmcviewbwherea.xkkh=b.xkkh)bjhzfromjxrwbviewawherexkkhlike'(2011-2012-1)-%'andkcmc='演讲与口才'andsubstr(jxjhh,1,4)='2008'and1=1anda.tab='jxrwb'groupbysubstr(a.jxjhh,1,4),a.kcdm,a.kcmc,a.kcxz,a.xf,a.jszgh,a.jsxm,a.xkkh,a.sksj,a.skdd,a.kkxy,a.xkkh,a.xkzt)orderbykkxy,kcmc,jsxm

按课程查询(必修)

selectdistincta.xqj,a.qssjd,b.rs,substrb(e.BJHZ,1,255)zymc,c.jsmc,a.xkkh,a.dsz,d.jsxm,b.dzxx,d.kcmc,d.kkxy,d.qsz,d.jszfromgbfsjdapxxa,khxxdzbb,jxcdxxbc,(selectdistinctxkkh,jsxm,kcmc,kkxy,qsz,jszfrompkrwviewwherexkkhlike'(2010-2011-2)-0730110117-%'andzymcisnotnullandjxjhhlike'2008%'and1=1)d,Jxbmcviewewherea.xkkh=b.xkkhanda.xkkh=e.xkkhanda.xkkh=d.xkkhanda.jsbh=c.jsbh(+)orderbya.xqj,a.qssjd

学院所上课程查询

selecta.kcmc,a.zxs,a.xf,a.sksj,a.skdd,a.xn,a.xq,a.xkkh,a.kcdm,a.jszgh,a.kcxz,a.zhxs,a.syxs,a.sjxs,a.jkxs,a.kkxy,a.kclb,a.xqyq,a.khfs,a.ksfs,jsxm,a.rs,a.zc,a.yxrs,(selectmax(trim(rpad(b.bjhz,127,'')))fromjxbmc_xyview_dgbwherea.xkkh=b.xkkh)bjhzfrom(selecta.kcmc,a.zxs,a.xf,a.sksj,a.skdd,a.xn,a.xq,a.xkkh,a.kcdm,a.jszgh,a.kcxz,a.zhxs,a.syxs,a.sjxs,a.jkxs,a.kkxy,a.kclb,a.xqyq,a.khfs,a.ksfs,trim(rpad(a.jsxm,127,''))jsxm,sum(a.rs)rs,(selectf.zcfromjsxxbfwheref.zgh=a.jszgh)zc,(selectcount(f.xh)fromxsxkbfwheref.xkkh=a.xkkh)yxrsfromjxrwbview_xy2awherea.xkkhlike'(2010-2011-2)-%'and1=1anda.tab='jxrwb'anda.zydmin(selectzydmfromzydmbwheressxydm='0301')groupbya.kcmc,a.zxs,a.xf,a.sksj,a.skdd,a.xn,a.xq,a.xkkh,a.kcdm,a.jszgh,a.kcxz,a.zhxs,a.syxs,a.sjxs,a.jkxs,a.kkxy,a.kclb,a.xqyq,a.khfs,a.ksfs,a.jsxm)aunionallselecta.kcmc,a.zxs,a.xf,a.sksj,a.skdd,a.xn,a.xq,a.xkkh,a.kcdm,a.jszgh,a.kcxz,a.zhxs,a.syxs,a.sjxs,a.jkxs,a.kkxy,a.kclb,a.xqyq,a.khfs,a.ksfs,a.jsxm,a.rs,(selectf.zcfromjsxxbfwheref.zgh=a.jszgh)zc,count(b.xh)yxrs,''bjzhfromjxrwba,xsxkbbwherea.xkkh=b.xkkhanda.xkkhlike'(2010-2011-2)-%'anda.bkkcmcisnotnullandb.xhin(selectxhfromxsjbxxbwherezydmin(selectzydmfromzydmbwheressxydm='0301'))and1=1groupbya.kcmc,a.zxs,a.xf,a.sksj,a.skdd,a.xn,a.xq,a.xkkh,a.kcdm,a.jszgh,a.kcxz,a.zhxs,a.syxs,a.sjxs,a.jkxs,a.kkxy,a.kclb,a.xqyq,a.khfs,a.ksfs,a.jsxm,a.rs

开课学院任务情况:

selecta.kcmc,a.zxs,a.xf,a.sksj,a.skdd,a.xn,a.xq,a.xkkh,a.kcdm,a.jszgh,zc,a.kcxz,a.zhxs,a.syxs,a.sjxs,a.jkxs,a.kkxy,a.kclb,a.xqyq,a.khfs,a.ksfs,a.qsjsz,jsxm,a.rs,a.yxrs,(selectmax(trim(rpad(b.bjhz,127,'')))fromjxbmc_xyview_dgbwherea.xkkh=b.xkkh)bjhz,njfrom(selecta.kcmc,a.zxs,a.xf,a.sksj,a.skdd,a.xn,a.xq,a.xkkh,a.kcdm,a.jszgh,zc,a.kcxz,a.zhxs,a.syxs,a.sjxs,a.jkxs,a.kkxy,a.kclb,a.xqyq,a.khfs,a.ksfs,a.qsjsz,trim(rpad(a.jsxm,127,''))jsxm,sum(a.rs)rs,(selectcount(f.xh)fromxsxkbfwheref.xkkh=a.xkkh)yxrs,'略'njfromjxrwbview_xy2a,jsxxbbwherea.jszgh=b.zghanda.xkkhlike'(2010-2011-2)-%'and1=1anda.kkxy='师范学院'andb.zgh='19865004'groupbya.kcmc,a.zxs,a.xf,a.sksj,a.skdd,a.xn,a.xq,a.xkkh,a.kcdm,a.jszgh,zc,a.kcxz,a.zhxs,a.syxs,a.sjxs,a.jkxs,a.kkxy,a.kclb,a.xqyq,a.khfs,a.ksfs,a.qsjsz,a.jsxm,'略')a

教室课表:

selectjsbh,jsmcfromjxcdxxbwherekyf='T'andlh='教学楼③'andjsbhin(selectdistinctjsbhfromjxcdviewwherexn='2010-2011'andxq='2'unionselectdistinctb.jsbhfromjxrwba,jxcdxxbbwherea.xkkhlike'(2010-2011-2)-%'and';'||a.skdd||';'like'%;'||b.jsmc||';%'anda.zxslike'+%')andxqdm='M'and1=1orderbyjsbh

教师课表:

selectdistinctB.zgh,B.xmfromjsxxbB,(selectxn,xq,jszghfromjxrwbview_xywherejxjhhlike'2008%'and1=1unionselecta.xn,a.xq,b.jszghfromjxrwbview_xya,dgjsskxxbbwherea.xkkh=b.xkkhanda.jxjhhlike'2008%'and1=1)awhereB.zgh=A.jszghandA.xn='2010-2011'andA.xq='2'andB.bm='信息学院'andB.ks='通信工程系'orderbyB.xm

按条件查询上课情况:(可以查询各个时间段的空教室以及上课情况)

select'2-2'周次,'星期'||''星期几,'整天'节次,''上课内容,''教师姓名,jsmc上课教室,zws座位数,jslb教室类别,xqdm校区fromjxcdxxbwherejsbhin(selectjsbhfromjxcdxxbawherekyf='T'minusselectjsbhfromkb_jxcdview1awherexn='2011-2012'andxq='1'anda.qsz=2anda.dsz||'Z'(casewhenmod(2,2)=1then'双Z'else'单Z'end)anda.qssjdin(1,3,5,6,8,10,12,0,0))orderbyjsmc,zws

教室使用率统计:

select'2011-2012'学年,'1'学期,a.jsbh教室编号,a.jsmc教室名称,a.jslb教室类别,a.zws座位数,a.xqdm所属校区,skxs学时数,syljs基数,syl使用率from(select*fromjxcdxxbwherekyf='T'andzws>=0)a,(selectxn,xq,jsbh,jsmc,jslb,zws,xqdm,casewhensum(skcd)isnullthen0elsesum(skcd)endskxs,'5'syljs,to_char((casewhensum(skcd)isnullthen0elsesum(skcd)end)/5*100,'990.00')||'%'sylfrom(selectxn,xq,jsbh,jsmc,jslb,zws,xqdm,qsz,jsz,dsz,xqj,qssjd,skcd,(jsz-qsz+1)/(casewhentrim(dsz)isnullthen1else2end)skzsfromkb_jxcdview1wherexn='2011-2012'andxq='1'andqsz=2anddsz||'Z'(casewhenmod(2,2)=1then'双Z'else'单Z'end)andxqj='2'andqssjdin(1,3,5,6,8,10,12,0,0)andzws>=0)groupbyxn,xq,jsbh,jsmc,jslb,zws,xqdmorderbyjsbh)bwherea.jsbh=b.jsbh(+)orderbya.jsbh

六、考试管理

1.自动排考条件设置

2.场地考试信息设置

3.考试方式设定

4.集中考试排考

5.分散考试排考

6.补考排考

7.查询打印

七、选课管理

1.学生密码清零

2.不快速选课课程标记

3.生成教学班

4.单个学生课表维护

5.板块学生等级

6.选课规则调整

7.体育课预选课程处理

8.体育课课外预选课程处理

9.学生选课监控

10.学生选模块处理

11.选课课程调整

12.教学班补选申请处理

13.重修报名信息

14.学生网上报名

15.学生网上投票

16.查询打印

17.学生点名查询统计

18.选课打标记

19.数据导入

八、成绩管理

1.成绩导入

2.系统外成绩管理

3.教学班成绩比例设置

4.网上成绩录入设置

5.成绩录入

6.成绩单回收确认

7.成绩修改

8.成绩申请处理

9.等级考试成绩处理

10.补考成绩处理

11.重修成绩处理

12.学生免缓缺处理

13.多学期课程成绩处理

14.成绩加分处理

15.统计分析

16.学籍监控

17.考试成绩偏正太分布处理

18.核查学生成绩

19.成绩库数据处理

20.成绩试卷归档管理

21.查询、打印

九、辅修管理

1.学生注册处理

2.辅修任务

3.辅修选课

4.辅修成绩处理

5.辅修学生处理

6.毕业审核

7.辅修打标记

一十、教材管理

1.教材代码维护

2.基本信息

3.教材计划

4.教材征订

5.教材入库

6.退还供应商

7.教材出库

8.教材回库

9.教材报废

10.数据查询

11.数据导入

12.数据设置

13.教材开关设置表

14.教材盘库

15.数据统计打印

16.教材输出接口

一十一、实践管理

1.学科竞赛

2.学科竞赛统计及打印

3.科研训练计划(SRTP)

4.实践项目选课时间设定

5.实践代码维护

6.实践管理

7.统计、查询

8.报表统计及打印

9.毕业设计(论文)代码维护

10.毕业设计(论文)管理

11.毕业设计(论文)信息查询

12.毕业设计(论文)信息统计

13.输出/打印

一十二、收费管理

1.收费代码维护

2.收费项目设置

3.学生选课费

4.按专业初始

5.前台缴费处理

6.后台数据处理

7.银行数据导入

8.修改银行帐号

9.应收费用导入

10.缴费日志表

11.助学贷款、学校减免处理

12.查询打印

13.与其他系统接口

一十三、教学质量评价

1.课程库维护

2.评价参数设定

3.评价学期控制

4.评价监控

5.特殊处理

6.学生评价统计

7.评价内容统计

8.排名统计

9.评分查询

10.报表打印

11.年度统计

12.满意度调查参数设定

13.满意度调查控制

14.满意度调查统计

15.满意度调查查询及打印

16.教师评学参数设定

17.教师评学控制

18.教师评学统计

19.教师评学查询及打印

20.评班主任参数设定

21.评班主任控制

22.评班主任统计

23.评班主任查询及打印

24.教学信息员平台

25.毕业前全程教学评价

26.专家评价平台

一十四、毕业生管理

1.毕业生辅助信息

2.毕业审核信息表

3.毕业资格预审核

4.学位预审核

5.毕业生名单管理

6.毕业成绩总表

7.毕业生历史库

8.毕业生历史数据查询

9.返回毕业生历史库

10.查询统计

一十五、体育管理

1.体育课代码维护

2.学期执行任务管理

3.选课学生信息导出

4.选课学生成绩导入

5.体育课成绩单

6.体育课锻炼成绩表

7.处理体育课程

一十六、实验室管理

1.实验代码维护

2.实验选项目时间设定

3.场地管理

4.工作人员管理

5.仪器设备管理

6.材料管理

7.实验项目管理

8.实验室统计工作量

9.统计查询

10.报表打印

。

猜你喜欢

最安全有效的减肥药

最安全有效的减肥药

编辑:小徐

现在的减肥药真的是真假难分,在选择减肥药的同时也应该更加小心,减肥药多种多样,那么如何才能选择最安全有效的减肥药,也成了很多小仙女的内心疑问,下面就跟着KTKP-077小编一起看一下,如何选择最安全有效的减肥药。 最安全有效的减肥药选购方法 1、首先需要观察产品的外包装,在包装中可以看到其配方是不是含有激素,含有激素的减肥药对身体的内..

吃减肥药失眠

吃减肥药失眠

编辑:小徐

随着现在流行以瘦为美,很多人会不顾身体的健康选择减肥药,达到快速减肥瘦身的效果,但是很多减肥药都是有副作用的,副作用比较轻的就是失眠现象,那么吃减肥药出现失眠是怎么回事儿?如果出现失眠后,我们应该怎样缓解? 吃减肥药失眠是怎么回事 减肥药中富含安非他命,所以减肥药服用了太多会有失眠现象,服用减肥药期间,身体会逐渐出现抗药性,身..

最新文章