gradeshow.cpp

分管理员和学生界面

		list.SetItemText(nIndex,4,"" );
		list.SetItemText(nIndex,5,"");
		list.SetItemText(nIndex,6,"");
		list.SetItemText(nIndex,7,"");   

 }

}

if(select==2)//按教师号
{i=1;

sql.Format("select 课程号 from 教学 where 职工号='%s'group by 课程号",gap);
 connection.Connect(sql);
  if(connection.m_pRecordset->adoEOF)
{AfxMessageBox("没有该职工号");
 connection.Unitialize();return;}
 connection.m_pRecordset->MoveFirst();
while(!connection.m_pRecordset->adoEOF)
{       _variant_t TheValue; 
	    TheValue = connection.m_pRecordset->Fields->GetItem("课程号")->Value;
		n[i]=TheValue.bstrVal;
		i++; 
		connection.m_pRecordset->MoveNext();
		
}
connection.Unitialize();

for(int j=1;j<i;j++)
 {
 connection.Initialize(); 
 sql.Format("select * from 课程 where 课程号='%s' ",n[j]);
 connection.Connect(sql);
 connection.m_pRecordset->MoveFirst();
while(!connection.m_pRecordset->adoEOF)
{      _variant_t TheValue; 
	    TheValue = connection.m_pRecordset->Fields->GetItem("课程名称")->Value;
		f=TheValue.bstrVal;
	
		float credit = connection.m_pRecordset->Fields->GetItem("学分")->Value;
		g.Format("%g",credit);

	    TheValue = connection.m_pRecordset->Fields->GetItem("学时")->Value;
		h=TheValue.bstrVal;

		 connection.m_pRecordset->MoveNext();
}

 connection.Unitialize();

 connection.Initialize();
 sql.Format("select * from 成绩 where 课程号='%s' order by 总评成绩",n[j]);
 connection.Connect(sql);
 connection.m_pRecordset->MoveFirst();
while(!connection.m_pRecordset->adoEOF)
{      _variant_t TheValue; 
	    TheValue = connection.m_pRecordset->Fields->GetItem("课程号")->Value;
		a=TheValue.bstrVal;
	
		TheValue = connection.m_pRecordset->Fields->GetItem("学号")->Value;
		b=TheValue.bstrVal;

	    TheValue = connection.m_pRecordset->Fields->GetItem("平时成绩")->Value;
		c=TheValue.bstrVal;

		TheValue = connection.m_pRecordset->Fields->GetItem("考试成绩")->Value;
		d=TheValue.bstrVal;

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


        int nIndex= list.InsertItem(0,a);
		list.SetItemText(nIndex,1,f);
        list.SetItemText(nIndex,2,b );
		list.SetItemText(nIndex,3,g );
		list.SetItemText(nIndex,4,h );
		list.SetItemText(nIndex,5,c);
		list.SetItemText(nIndex,6,d);
		list.SetItemText(nIndex,7,e);
        
		 connection.m_pRecordset->MoveNext();
	}    connection.Unitialize();
        int nIndex= list.InsertItem(0,"");
		list.SetItemText(nIndex,1,"");
        list.SetItemText(nIndex,2,"");
		list.SetItemText(nIndex,3,"" );
		list.SetItemText(nIndex,4,"" );
		list.SetItemText(nIndex,5,"");
		list.SetItemText(nIndex,6,"");
		list.SetItemText(nIndex,7,"");   
 }
}


if(select==4)
{ CString course[20];
 int m=1;int tag=0;
 connection.Initialize(); 
 sql.Format("select 课程号 from 选修 where 学号='%s'order by 课程号 desc",gap);
 connection.Connect(sql);

 if(connection.m_pRecordset->adoEOF)
{connection.Unitialize();AfxMessageBox("该学生没有课程成绩");return;}

 connection.m_pRecordset->MoveFirst();
while(!connection.m_pRecordset->adoEOF)
{       _variant_t TheValue; 
	    TheValue = connection.m_pRecordset->Fields->GetItem("课程号")->Value;
		course[m]=TheValue.bstrVal;
		m++; 
		connection.m_pRecordset->MoveNext();
		
}
connection.Unitialize();


 for(int p=1;p<m;p++)
 {connection.Initialize(); 
 sql.Format("select * from 课程 where 课程号='%s' ",course[p]);
 connection.Connect(sql);
 connection.m_pRecordset->MoveFirst();
while(!connection.m_pRecordset->adoEOF)
{      _variant_t TheValue; 
	    TheValue = connection.m_pRecordset->Fields->GetItem("课程名称")->Value;
		f=TheValue.bstrVal;
	
		float credit = connection.m_pRecordset->Fields->GetItem("学分")->Value;
		g.Format("%g",credit);

	    TheValue = connection.m_pRecordset->Fields->GetItem("学时")->Value;
		h=TheValue.bstrVal;

		connection.m_pRecordset->MoveNext();
}

 connection.Unitialize();

 connection.Initialize();
 sql.Format("select * from 成绩 where 课程号='%s' and 学号='%s'order by 总评成绩",course[p],gap);
 connection.Connect(sql);
 connection.m_pRecordset->MoveFirst();
while(!connection.m_pRecordset->adoEOF)
{      _variant_t TheValue; 
	    TheValue = connection.m_pRecordset->Fields->GetItem("课程号")->Value;
		a=TheValue.bstrVal;
	
		TheValue = connection.m_pRecordset->Fields->GetItem("学号")->Value;
		b=TheValue.bstrVal;

	    TheValue = connection.m_pRecordset->Fields->GetItem("平时成绩")->Value;
		c=TheValue.bstrVal;

		TheValue = connection.m_pRecordset->Fields->GetItem("考试成绩")->Value;
		d=TheValue.bstrVal;

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


        int nIndex= list.InsertItem(0,a);
		list.SetItemText(nIndex,1,f);
        list.SetItemText(nIndex,2,gap);
		list.SetItemText(nIndex,3,g );
		list.SetItemText(nIndex,4,h );
		list.SetItemText(nIndex,5,c);
		list.SetItemText(nIndex,6,d);
		list.SetItemText(nIndex,7,e);
        
		 connection.m_pRecordset->MoveNext();
	}    connection.Unitialize(); 
 }
}

if(select==5)
{CString number;
 sql.Format("select 学号 from 学生 where 姓名='%s'",gap);
 connection.Connect(sql);
  if(connection.m_pRecordset->adoEOF)
{AfxMessageBox("没有该姓名的学生");
 connection.Unitialize();return;}

 connection.m_pRecordset->MoveFirst();
while(!connection.m_pRecordset->adoEOF)
{       _variant_t TheValue; 
	    TheValue = connection.m_pRecordset->Fields->GetItem("学号")->Value;
		number=TheValue.bstrVal;
		connection.m_pRecordset->MoveNext();
}
connection.Unitialize();


CString course[20];
 int m=1;int tag=0;
 connection.Initialize(); 
 sql.Format("select 课程号 from 选修 where 学号='%s'order by 课程号 desc",number);
 connection.Connect(sql);

 if(connection.m_pRecordset->adoEOF)
{connection.Unitialize();AfxMessageBox("该学生没有课程成绩");return;}

 connection.m_pRecordset->MoveFirst();
while(!connection.m_pRecordset->adoEOF)
{       _variant_t TheValue; 
	    TheValue = connection.m_pRecordset->Fields->GetItem("课程号")->Value;
		course[m]=TheValue.bstrVal;
		m++; 
		connection.m_pRecordset->MoveNext();
		
}
connection.Unitialize();


 for(int p=1;p<m;p++)
 {connection.Initialize(); 
 sql.Format("select * from 课程 where 课程号='%s' ",course[p]);
 connection.Connect(sql);
 connection.m_pRecordset->MoveFirst();
while(!connection.m_pRecordset->adoEOF)
{      _variant_t TheValue; 
	    TheValue = connection.m_pRecordset->Fields->GetItem("课程名称")->Value;
		f=TheValue.bstrVal;
	
		float credit = connection.m_pRecordset->Fields->GetItem("学分")->Value;
		g.Format("%g",credit);

	    TheValue = connection.m_pRecordset->Fields->GetItem("学时")->Value;
		h=TheValue.bstrVal;

		connection.m_pRecordset->MoveNext();
}

 connection.Unitialize();

 connection.Initialize();
 sql.Format("select * from 成绩 where 课程号='%s' and 学号='%s' order by 总评成绩",course[p],gap);
 connection.Connect(sql);
 connection.m_pRecordset->MoveFirst();
while(!connection.m_pRecordset->adoEOF)
{      _variant_t TheValue; 
	    TheValue = connection.m_pRecordset->Fields->GetItem("课程号")->Value;
		a=TheValue.bstrVal;
	
		TheValue = connection.m_pRecordset->Fields->GetItem("学号")->Value;
		b=TheValue.bstrVal;

	    TheValue = connection.m_pRecordset->Fields->GetItem("平时成绩")->Value;
		c=TheValue.bstrVal;

		TheValue = connection.m_pRecordset->Fields->GetItem("考试成绩")->Value;
		d=TheValue.bstrVal;

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


        int nIndex= list.InsertItem(0,a);
		list.SetItemText(nIndex,1,f);
        list.SetItemText(nIndex,2,number);
		list.SetItemText(nIndex,3,g );
		list.SetItemText(nIndex,4,h );
		list.SetItemText(nIndex,5,c);
		list.SetItemText(nIndex,6,d);
		list.SetItemText(nIndex,7,e);
        
		 connection.m_pRecordset->MoveNext();
	}    connection.Unitialize();
 }
}
}