statics.cpp

分管理员和学生界面

connection1.m_pRecordset->MoveNext();
}   
connection1.Unitialize();
}


if(chose==3)//按教师姓名输出
{UpdateData(true);
list.DeleteAllItems();int flag=0;int nIndex;
CString course="",a="",b="",c="",d="",e="",f="",g="",h="",sSql="",sql="",number="",name="",sex="";
CString teachernum="";

connection1.Initialize();
sSql.Format("select * from 教职工 where 姓名='%s'",data);
connection1.Connect(sSql);
 if((connection1.m_pRecordset->adoEOF))
  {AfxMessageBox("没有教师记录");
   connection1.Unitialize();	
   return ;}
   connection1.m_pRecordset->MoveFirst();
while(!connection1.m_pRecordset->adoEOF)
{  _variant_t TheValue; 
	    TheValue = connection1.m_pRecordset->Fields->GetItem("职工号")->Value;
		teachernum=TheValue.bstrVal;

connection1.m_pRecordset->MoveNext();
}
connection1.Unitialize(); 

flag=0;
 connection5.Initialize();
 sql.Format("select * from 教学 where 职工号='%s'",teachernum);
 connection5.Connect(sql);
if(connection5.m_pRecordset->adoEOF)
{connection5.Unitialize(); flag=1;}
if(flag==0)
{
connection5.m_pRecordset->MoveFirst();
while(!connection5.m_pRecordset->adoEOF)
{      _variant_t TheValue; 
	    TheValue = connection5.m_pRecordset->Fields->GetItem("职工号")->Value;
		e=TheValue.bstrVal;
	
		TheValue = connection5.m_pRecordset->Fields->GetItem("上课时间")->Value;
		f=TheValue.bstrVal;

	    TheValue = connection5.m_pRecordset->Fields->GetItem("上课地点")->Value;
		g=TheValue.bstrVal;

		TheValue = connection5.m_pRecordset->Fields->GetItem("考试时间")->Value;
		h=TheValue.bstrVal;
		connection5.m_pRecordset->MoveNext();
}  
connection5.Unitialize(); 
}



flag=0;
connection1.Initialize();
sSql.Format("select * from 教学 where 职工号='%s'order by 课程号 desc",teachernum);
connection1.Connect(sSql);
 if((connection1.m_pRecordset->adoEOF))
 {
   connection1.Unitialize();	
   flag=1;}
if(flag==0)
{connection1.m_pRecordset->MoveFirst();
while(!connection1.m_pRecordset->adoEOF)
{  _variant_t TheValue; 
   TheValue = connection1.m_pRecordset->Fields->GetItem("课程号")->Value;
   course=TheValue.bstrVal;//得该教师教的每个课程号
p9=0;p8=0;p7=0;p6=0;pf=0;  
nIndex= list.InsertItem(0,"");
list.SetItemText(nIndex,1,"");
list.SetItemText(nIndex,2,"");
list.SetItemText(nIndex,3,"");
list.SetItemText(nIndex,4,"");
list.SetItemText(nIndex,5,"");

nIndex= list.InsertItem(0,"");
list.SetItemText(nIndex,1,"");
list.SetItemText(nIndex,2,"");
list.SetItemText(nIndex,3,"");
list.SetItemText(nIndex,4,"");
list.SetItemText(nIndex,5,"");

 connection2.Initialize(); 
 sql.Format("select * from 课程 where 课程号='%s' ",course);
 connection2.Connect(sql);
 connection2.m_pRecordset->MoveFirst();
while(!connection2.m_pRecordset->adoEOF)
{  _variant_t TheValue; 

	    TheValue = connection2.m_pRecordset->Fields->GetItem("课程号")->Value;
		a=TheValue.bstrVal;

	    TheValue = connection2.m_pRecordset->Fields->GetItem("课程名称")->Value;
		b=TheValue.bstrVal;
	
		float credit = connection2.m_pRecordset->Fields->GetItem("学分")->Value;
		c.Format("%g",credit);

	    TheValue = connection2.m_pRecordset->Fields->GetItem("学时")->Value;
		d=TheValue.bstrVal;
connection2.m_pRecordset->MoveNext();
}
connection2.Unitialize(); 
//得每个课程号的属性


flag=0;
connection3.Initialize();
sql.Format("select * from 选修 where 课程号='%s'and 教师号='%s'order by 学号 desc",course,teachernum);
 connection3.Connect(sql);
if(connection3.m_pRecordset->adoEOF)
{connection3.Unitialize(); flag=1;}
if(flag==0)
{connection3.m_pRecordset->MoveFirst();
while(!connection3.m_pRecordset->adoEOF)
{     _variant_t TheValue; 
        TheValue = connection3.m_pRecordset->Fields->GetItem("学号")->Value;
		number=TheValue.bstrVal;//得到一个课程的每一个学生的学号
		
flag=0;		
connection4.Initialize();
sql.Format("select * from 学生 where 学号='%s' ",number);
connection4.Connect(sql);
if(connection4.m_pRecordset->adoEOF)
{connection4.Unitialize(); flag=1;}
if(flag==0)
{connection4.m_pRecordset->MoveFirst();
while(!connection4.m_pRecordset->adoEOF)
{      _variant_t TheValue; 
		
		TheValue = connection4.m_pRecordset->Fields->GetItem("姓名")->Value;
		name=TheValue.bstrVal;
		
		TheValue = connection4.m_pRecordset->Fields->GetItem("性别")->Value;
		sex=TheValue.bstrVal;
		//得到一个学生的资料
        nIndex= list.InsertItem(0,number);
		list.SetItemText(nIndex,1,name);
        list.SetItemText(nIndex,2,sex);
		list.SetItemText(nIndex,3,"");
		list.SetItemText(nIndex,4,"" );
		

connection4.m_pRecordset->MoveNext();
}
connection4.Unitialize(); //得学号
}
connection4.Initialize();
sql.Format("select * from 成绩 where 学号='%s'and 课程号='%s' ",number,course);
connection4.Connect(sql);
connection4.m_pRecordset->MoveFirst();
while(!connection4.m_pRecordset->adoEOF)
{   _variant_t TheValue; ///////////////////////
       CString usual,text,final;
        TheValue = connection4.m_pRecordset->Fields->GetItem("平时成绩")->Value;
		usual=TheValue.bstrVal;
		
		TheValue = connection4.m_pRecordset->Fields->GetItem("考试成绩")->Value;
		text=TheValue.bstrVal;

		TheValue = connection4.m_pRecordset->Fields->GetItem("总评成绩")->Value;
		final=TheValue.bstrVal;

				float Final=atof(final);
        if(Final>=90)p9++;
		if(Final>=80&&Final<90)p8++;
		if(Final>=70&&Final<80)p7++;
		if(Final>=60&&Final<70)p6++;
		if(Final<60)pf++;
        
		list.SetItemText(nIndex,3,usual);
		list.SetItemText(nIndex,4,text );
		list.SetItemText(nIndex,5,final );
		

		list.SetItemText(nIndex,3,usual);
		list.SetItemText(nIndex,4,text );
		list.SetItemText(nIndex,5,final );
		connection4.m_pRecordset->MoveNext();
}
connection4.Unitialize(); 
connection3.m_pRecordset->MoveNext();
}
connection3.Unitialize(); 
}


CString s9,s8,s7,s6,sf;
s9.Format("%0.0f",p9);
s8.Format("%0.0f",p8);
s7.Format("%0.0f",p7);
s6.Format("%0.0f",p6);
sf.Format("%0.0f",pf);

float r9=0,r8=0,r7=0,r6=0,rf=0;
float sum=0;
sum=p9+p8+p7+p6+pf;
if(sum!=0)
{
r9=(p9/sum)*100;
r8=(p8/sum)*100;
r7=(p7/sum)*100;
r6=(p6/sum)*100;
rf=(pf/sum)*100;}

CString t9,t8,t7,t6,tf;
t9.Format("%0.2f",r9);
t8.Format("%0.2f",r8);
t7.Format("%0.2f",r7);
t6.Format("%0.2f",r6);
tf.Format("%0.2f",rf);

nIndex= list.InsertItem(0,"学号");
 list.SetItemText(nIndex,1,"姓名");
 list.SetItemText(nIndex,2,"性别");
 list.SetItemText(nIndex,3,"平时成绩");
 list.SetItemText(nIndex,4,"考试成绩"); 
 list.SetItemText(nIndex,5,"总评成绩");	

nIndex= list.InsertItem(0,"比例："+t9+"% ");
 list.SetItemText(nIndex,1,"比例 ："+t8+"% ");
 list.SetItemText(nIndex,2,"比例 ："+t7+"% ");
 list.SetItemText(nIndex,3,"比例 ："+t6+"% ");
 list.SetItemText(nIndex,4,"比例："+tf+"% "); 

nIndex= list.InsertItem (0,"90-100：  "+s9+"人 ");
 list.SetItemText(nIndex,1,"80-90 ：  "+s8+"人 ");
 list.SetItemText(nIndex,2,"70-80 ：  "+s7+"人 ");
 list.SetItemText(nIndex,3,"60-70 ：  "+s6+"人 ");
 list.SetItemText(nIndex,4,"不及格：  "+sf+"人 "); 

 nIndex= list.InsertItem(0,"职工号：");
list.SetItemText(nIndex,1,e);
list.SetItemText(nIndex,2,"上课时间：");
list.SetItemText(nIndex,3,f);
list.SetItemText(nIndex,4,"上课地点：");
list.SetItemText(nIndex,5,g);
list.SetItemText(nIndex,6,"考试时间：");
list.SetItemText(nIndex,7,h);

nIndex= list.InsertItem(0,"课程号：");
list.SetItemText(nIndex,1,a);
list.SetItemText(nIndex,2,"课程名称：");
list.SetItemText(nIndex,3,b);
list.SetItemText(nIndex,4,"学分：");
list.SetItemText(nIndex,5,c);
list.SetItemText(nIndex,6,"学时：");
list.SetItemText(nIndex,7,d);
connection1.m_pRecordset->MoveNext();
}//con1
connection1.Unitialize(); 
}//if



}//chose3
//////////////////////////////////////////////////////////////////////////////////////////////////
if(chose==4)
{UpdateData(true);
list.DeleteAllItems();int flag=0;int nIndex;
CString course="",a="",b="",c="",d="",e="",f="",g="",h="",sSql="",sql="",number="",name="",sex="";
CString teachernum="";

connection1.Initialize();
sSql.Format("select * from 系 where 系号='%s'",data);
connection1.Connect(sSql);
 if((connection1.m_pRecordset->adoEOF))
  {AfxMessageBox("没有该系记录");
   connection1.Unitialize();	
   return ;}
connection1.Unitialize();
flag=0;
connection1.Initialize();
sSql.Format("select * from 教职工 where 所在系号='%s'",data);
connection1.Connect(sSql);
if(connection1.m_pRecordset->adoEOF)
{connection1.Unitialize(); flag=1;}
if(flag==0)
{
connection1.m_pRecordset->MoveFirst();
while(!connection1.m_pRecordset->adoEOF)
{ _variant_t TheValue;
	    TheValue = connection1.m_pRecordset->Fields->GetItem("职工号")->Value;
		teachernum=TheValue.bstrVal;



flag=0;
p9=0;p8=0;p7=0;p6=0;pf=0;  
 connection5.Initialize();
 sql.Format("select * from 教学 where 职工号='%s'",teachernum);
 connection5.Connect(sql);
if(connection5.m_pRecordset->adoEOF)
{connection5.Unitialize(); flag=1;}
if(flag==0)
{
connection5.m_pRecordset->MoveFirst();
while(!connection5.m_pRecordset->adoEOF)
{      _variant_t TheValue; 
	    TheValue = connection5.m_pRecordset->Fields->GetItem("职工号")->Value;
		e=TheValue.bstrVal;
	
		TheValue = connection5.m_pRecordset->Fields->GetItem("上课时间")->Value;
		f=TheValue.bstrVal;

	    TheValue = connection5.m_pRecordset->Fields->GetItem("上课地点")->Value;
		g=TheValue.bstrVal;

		TheValue = connection5.m_pRecordset->Fields->GetItem("考试时间")->Value;
		h=TheValue.bstrVal;
		connection5.m_pRecordset->MoveNext();
}  
connection5.Unitialize(); 
}



flag=0;
connection6.Initialize();
sSql.Format("select * from 教学 where 职工号='%s'order by 课程号 desc",teachernum);
connection6.Connect(sSql);
 if((connection6.m_pRecordset->adoEOF))
 {
   connection6.Unitialize();	
   flag=1;}
if(flag==0)
{connection6.m_pRecordset->MoveFirst();
while(!connection6.m_pRecordset->adoEOF)
{  _variant_t TheValue; 
   TheValue = connection6.m_pRecordset->Fields->GetItem("课程号")->Value;
   course=TheValue.bstrVal;//得该教师教的每个课程号
p9=0;p8=0;p7=0;p6=0;pf=0;  
nIndex= list.InsertItem(0,"");
list.SetItemText(nIndex,1,"");
list.SetItemText(nIndex,2,"");
list.SetItemText(nIndex,3,"");
list.SetItemText(nIndex,4,"");
list.SetItemText(nIndex,5,"");

nIndex= list.InsertItem(0,"");
list.SetItemText(nIndex,1,"");
list.SetItemText(nIndex,2,"");
list.SetItemText(nIndex,3,"");
list.SetItemText(nIndex,4,"");
list.SetItemText(nIndex,5,"");

 connection2.Initialize(); 
 sql.Format("select * from 课程 where 课程号='%s' ",course);
 connection2.Connect(sql);
 connection2.m_pRecordset->MoveFirst();
while(!connection2.m_pRecordset->adoEOF)
{  _variant_t TheValue; 

	    TheValue = connection2.m_pRecordset->Fields->GetItem("课程号")->Value;
		a=TheValue.bstrVal;

	    TheValue = connection2.m_pRecordset->Fields->GetItem("课程名称")->Value;
		b=TheValue.bstrVal;
	
		float credit = connection2.m_pRecordset->Fields->GetItem("学分")->Value;
		c.Format("%g",credit);

	    TheValue = connection2.m_pRecordset->Fields->GetItem("学时")->Value;
		d=TheValue.bstrVal;
connection2.m_pRecordset->MoveNext();
}
connection2.Unitialize(); 
//得每个课程号的属性


flag=0;
connection3.Initialize();
sql.Format("select * from 选修 where 课程号='%s'and 教师号='%s'order by 学号 desc",course,teachernum);
 connection3.Connect(sql);
if(connection3.m_pRecordset->adoEOF)
{connection3.Unitialize(); flag=1;}
if(flag==0)
{connection3.m_pRecordset->MoveFirst();
while(!connection3.m_pRecordset->adoEOF)
{     _variant_t TheValue; 
        TheValue = connection3.m_pRecordset->Fields->GetItem("学号")->Value;
		number=TheValue.bstrVal;//得到一个课程的每一个学生的学号
		
flag=0;		
connection4.Initialize();
sql.Format("select * from 学生 where 学号='%s' ",number);
connection4.Connect(sql);
if(connection4.m_pRecordset->adoEOF)
{connection4.Unitialize(); flag=1;}
if(flag==0)
{connection4.m_pRecordset->MoveFirst();
while(!connection4.m_pRecordset->adoEOF)
{      _variant_t TheValue; 
		
		TheValue = connection4.m_pRecordset->Fields->GetItem("姓名")->Value;
		name=TheValue.bstrVal;
		
		TheValue = connection4.m_pRecordset->Fields->GetItem("性别")->Value;
		sex=TheValue.bstrVal;
		//得到一个学生的资料
        nIndex= list.InsertItem(0,number);
		list.SetItemText(nIndex,1,name);
        list.SetItemText(nIndex,2,sex);
		//list.SetItemText(nIndex,3,"");
		//list.SetItemText(nIndex,4,"" );
		

connection4.m_pRecordset->MoveNext();
}
connection4.Unitialize(); //得学号
}
connection4.Initialize();
sql.Format("select * from 成绩 where 学号='%s'and 课程号='%s' ",number,course);
connection4.Connect(sql);
connection4.m_pRecordset->MoveFirst();
while(!connection4.m_pRecordset->adoEOF)
{   _variant_t TheValue; ///////////////////////
       CString usual,text,final;
        TheValue = connection4.m_pRecordset->Fields->GetItem("平时成绩")->Value;
		usual=TheValue.bstrVal;