申請(qǐng)免費(fèi)試用、咨詢電話：400-8352-114
算法：根據(jù)班級(jí)狀態(tài)（開(kāi)課中，尚未開(kāi)課），搜集班級(jí)下面的學(xué)員，并且課時(shí)未上完，選班狀態(tài)正常。注意：一名學(xué)員報(bào)多門課程，會(huì)被重復(fù)統(tǒng)計(jì)。
（此查詢針對(duì)access版本，SQL版只要將其中的Now()函數(shù)替換為GetDate()即可）主查詢：Select count(*)
as 人數(shù),
Now()
as ShowKey from StuClass,Class where StuClass.ClassID =
Class.ClassID
and StuClass.Lessons >
StuClass.CourseProgress
and StuClass.ScStateID
in (1,2)
and Class.SchoolID
in (
{@SchoolID:校區(qū)} )
and ((
Class.EndDate > Now()
and Class.StartDate < Now())
or Class.StartDate > Now())
子查詢：Select StuClass.StudentID
as 學(xué)員編號(hào),
StuClass.StudentName
as 學(xué)員姓名,
StuClass.ClassID
as 班級(jí)編號(hào),
StuClass.ClassName
as 班級(jí)名稱,
StuClass.Lessons
as 已購(gòu)總課時(shí),
StuClass.CourseProgress
as 課程進(jìn)度 from StuClass,Class where StuClass.ClassID =
Class.ClassID
and StuClass.Lessons >
StuClass.CourseProgress
and StuClass.ScStateID
in (1,2)
and Class.SchoolID
in (
{@SchoolID} )
and ((
Class.EndDate >
{@ShowKey} and Class.StartDate <
{@ShowKey} )
or Class.StartDate >
{@ShowKey} )
(把以上代碼粘貼到《泛普培訓(xùn)學(xué)校管理軟件》查詢管理里，可直接使用)
