⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 tv2.cpp

📁 体育信息管理系统
💻 CPP
📖 第 1 页 / 共 3 页
字号:
🔍
123 
// TV2.cpp : implementation file
//

#include "stdafx.h"
#include "ooo.h"
#include "TV2.h"

#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// CTV2

IMPLEMENT_DYNCREATE(CTV2, CListView)

CTV2::CTV2()
{a=b=c=d=0;page=0;aa=0;
high1=110;high2=30;row=22;
}

CTV2::~CTV2()
{COooApp*pp=(COooApp*)::AfxGetApp();
pp->e=0;

}


BEGIN_MESSAGE_MAP(CTV2, CListView)
	//{{AFX_MSG_MAP(CTV2)
	ON_COMMAND(ID_MENUITEM32792, OnMenuitem32792)
	ON_COMMAND(ID_FILE_BBB, CListView::OnFilePrint)
	ON_COMMAND(ID_FILE_AAA, CListView::OnFilePrintPreview)

	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CTV2 drawing

void CTV2::OnDraw(CDC* pDC)
{
	CDocument* pDoc = GetDocument();
	// TODO: add draw code here
}

/////////////////////////////////////////////////////////////////////////////
// CTV2 diagnostics

#ifdef _DEBUG
void CTV2::AssertValid() const
{
	CListView::AssertValid();
}

void CTV2::Dump(CDumpContext& dc) const
{
	CListView::Dump(dc);
}
#endif //_DEBUG

/////////////////////////////////////////////////////////////////////////////
// CTV2 message handlers

COooDoc* CTV2::GetDocument()
{ASSERT(m_pDocument->IsKindOf(RUNTIME_CLASS(COooDoc)));
	return (COooDoc*)m_pDocument;


}

void CTV2::OnInitialUpdate() 
{
	CListView::OnInitialUpdate();
	
CListCtrl&m_list=GetListCtrl();
COooApp*pp=(COooApp*)::AfxGetApp();
pp->e=1;
if(pp->gread==3||pp->gread==4||pp->gread==5){
	m_list.InsertColumn(0,"姓名",LVCFMT_LEFT,100);
	m_list.InsertColumn(1,"体育课成绩",LVCFMT_LEFT,120);
	m_list.InsertColumn(2,"计入总分(60%)",LVCFMT_LEFT,100);
	m_list.InsertColumn(3,"国家体育锻炼等级",LVCFMT_LEFT,120);
	m_list.InsertColumn(4,"记入总分(30%)",LVCFMT_LEFT,100);
	m_list.InsertColumn(5,"缺勤次数",LVCFMT_LEFT,120);
	m_list.InsertColumn(6,"记入总分(10%)",LVCFMT_LEFT,100);
	m_list.InsertColumn(7,"总分",LVCFMT_LEFT,100);
	m_list.InsertColumn(8,"等级",LVCFMT_LEFT,100);}
else{	m_list.InsertColumn(0,"姓名",LVCFMT_LEFT,100);
	m_list.InsertColumn(1,"体育课成绩",LVCFMT_LEFT,120);
	m_list.InsertColumn(2,"计入总分(60%)",LVCFMT_LEFT,100);
	m_list.InsertColumn(3,"缺勤次数",LVCFMT_LEFT,120);
	m_list.InsertColumn(4,"记入总分(10%)",LVCFMT_LEFT,100);
	m_list.InsertColumn(5,"总分",LVCFMT_LEFT,100);
	m_list.InsertColumn(6,"等级",LVCFMT_LEFT,100);
}
	m_list.SetBkColor(RGB(22,200,125));
	m_list.SetTextBkColor(RGB(0,200,0));
	m_list.ModifyStyle(LVS_TYPEMASK,LVS_REPORT);
	m_list.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES);			
list();	
}



void CTV2::list()
{COooDoc* pDoc = GetDocument();
	ASSERT_VALID(pDoc);
COooApp*pp=(COooApp*)::AfxGetApp();
	CListCtrl&m_list=GetListCtrl();
CA *prs;
prs=new CA(pDoc->m_pDB);
prs->Open(dbOpenDynaset,prs->GetDefaultSQL(),0);
m_list.DeleteAllItems();
CString str;
int i=0;
if(prs->IsBOF()&&prs->IsEOF()){MessageBox("主表无内容"); return;}
//绝妙代码，天助我也
CB*m_cb;
m_cb=new CB(pDoc->m_pDB);	
m_cb->Open(dbOpenDynaset,m_cb->GetDefaultSQL(),0);
if(!(m_cb->IsBOF()&&m_cb->IsEOF())){
m_cb->MoveFirst();
while(!m_cb->IsEOF()){
	str=m_cb->m_column1;
	prs->MoveFirst();
	while(!prs->IsEOF()){
		if(prs->m_name==str)	{
			if(m_cb->m_column2==1||m_cb->m_column2==2){prs->Edit();prs->m_inhouse1=prs->m_inhouse1-0.5;	prs->Update();}
			if(m_cb->m_column2==3){prs->Edit();prs->m_inhouse1=prs->m_inhouse1-1;prs->Update();}
		}
		prs->MoveNext();}
	m_cb->MoveNext();}
}

CC *m_cc;
m_cc=new CC(pDoc->m_pDB);
m_cc->Open(dbOpenDynaset,m_cc->GetDefaultSQL(),0);
if(!(m_cc->IsBOF()&&m_cc->IsEOF())){
	m_cc->MoveFirst();
while(!m_cc->IsEOF()){
	str=m_cc->m_column1;
	prs->MoveFirst();
	while(!prs->IsEOF()){
		if(prs->m_name==str)	{
			prs->Edit();prs->m_inhouse2=prs->m_inhouse2-(0.5*(m_cc->m_column2+m_cc->m_column3+m_cc->m_column4));	prs->Update();
		}
		prs->MoveNext();}
m_cc->MoveNext();}
}
if(pp->gread==3||pp->gread==4||pp->gread==5){
prs->MoveFirst();
while(!prs->IsEOF()){
	m_list.InsertItem(i,prs->m_name);
	str.Format("%5.2f",prs->m_text*0.2+prs->m_j2*0.08+prs->m_jump2*0.08+prs->m_run2*0.08+prs->m_ball2*0.08+prs->m_down2*0.08+prs->m_jiqiao*0.1+prs->m_yang*0.1+prs->m_gang*0.1+prs->m_inhouse1);
	m_list.SetItemText(i,1,str);
	str.Format("%5.2f",(prs->m_text*0.2+prs->m_j2*0.08+prs->m_jump2*0.08+prs->m_run2*0.08+prs->m_ball2*0.08+prs->m_down2*0.08+prs->m_jiqiao*0.1+prs->m_yang*0.1+prs->m_gang*0.1+prs->m_inhouse1)*0.6);	
	m_list.SetItemText(i,2,str);
	str.Format("%5.2f",(prs->m_j2+prs->m_jump2+prs->m_run2+prs->m_ball2+prs->m_down2)/5);
	m_list.SetItemText(i,3,str);
	str.Format("%5.2f",(prs->m_j2+prs->m_jump2+prs->m_run2+prs->m_ball2+prs->m_down2)/5*0.3);
	m_list.SetItemText(i,4,str);
	str.Format("%2.0f",(10-prs->m_inhouse2)/0.5);
	m_list.SetItemText(i,5,str);
	str.Format("%5.2f",prs->m_inhouse2);
	m_list.SetItemText(i,6,str);
	str.Format("%5.2f",((prs->m_text*0.2+prs->m_j2*0.08+prs->m_jump2*0.08+prs->m_run2*0.08+prs->m_ball2*0.08+prs->m_down2*0.08+prs->m_jiqiao*0.1+prs->m_yang*0.1+prs->m_gang*0.1+prs->m_inhouse1)*0.6+(prs->m_j2+prs->m_jump2+prs->m_run2+prs->m_ball2+prs->m_down2)/5*0.3+prs->m_inhouse2));
	m_list.SetItemText(i,7,str);
if(((prs->m_text*0.2+prs->m_j2*0.08+prs->m_jump2*0.08+prs->m_run2*0.08+prs->m_ball2*0.08+prs->m_down2*0.08+prs->m_jiqiao*0.1+prs->m_yang*0.1+prs->m_gang*0.1+prs->m_inhouse1)*0.6+(prs->m_j2+prs->m_jump2+prs->m_run2+prs->m_ball2+prs->m_down2)/5*0.3+prs->m_inhouse2)<60)
{str.Format("不及格");d++;
m_list.SetItemText(i,8,str);}
if(((prs->m_text*0.2+prs->m_j2*0.08+prs->m_jump2*0.08+prs->m_run2*0.08+prs->m_ball2*0.08+prs->m_down2*0.08+prs->m_jiqiao*0.1+prs->m_yang*0.1+prs->m_gang*0.1+prs->m_inhouse1)*0.6+(prs->m_j2+prs->m_jump2+prs->m_run2+prs->m_ball2+prs->m_down2)/5*0.3+prs->m_inhouse2)>=60&&((prs->m_text*0.2+prs->m_j2*0.08+prs->m_jump2*0.08+prs->m_run2*0.08+prs->m_ball2*0.08+prs->m_down2*0.08+prs->m_jiqiao*0.1+prs->m_yang*0.1+prs->m_gang*0.1+prs->m_inhouse1)*0.6+(prs->m_j2+prs->m_jump2+prs->m_run2+prs->m_ball2+prs->m_down2)/5*0.3+prs->m_inhouse2)<75)
{str.Format("及格");c++;
m_list.SetItemText(i,8,str);}
if(((prs->m_text*0.2+prs->m_j2*0.08+prs->m_jump2*0.08+prs->m_run2*0.08+prs->m_ball2*0.08+prs->m_down2*0.08+prs->m_jiqiao*0.1+prs->m_yang*0.1+prs->m_gang*0.1+prs->m_inhouse1)*0.6+(prs->m_j2+prs->m_jump2+prs->m_run2+prs->m_ball2+prs->m_down2)/5*0.3+prs->m_inhouse2)>=75&&((prs->m_text*0.2+prs->m_j2*0.08+prs->m_jump2*0.08+prs->m_run2*0.08+prs->m_ball2*0.08+prs->m_down2*0.08+prs->m_jiqiao*0.1+prs->m_yang*0.1+prs->m_gang*0.1+prs->m_inhouse1)*0.6+(prs->m_j2+prs->m_jump2+prs->m_run2+prs->m_ball2+prs->m_down2)/5*0.3+prs->m_inhouse2)<90)
{str.Format("良好");b++;
m_list.SetItemText(i,8,str);}
if(((prs->m_text*0.2+prs->m_j2*0.08+prs->m_jump2*0.08+prs->m_run2*0.08+prs->m_ball2*0.08+prs->m_down2*0.08+prs->m_jiqiao*0.1+prs->m_yang*0.1+prs->m_gang*0.1+prs->m_inhouse1)*0.6+(prs->m_j2+prs->m_jump2+prs->m_run2+prs->m_ball2+prs->m_down2)/5*0.3+prs->m_inhouse2)>=90&&((prs->m_text*0.2+prs->m_j2*0.08+prs->m_jump2*0.08+prs->m_run2*0.08+prs->m_ball2*0.08+prs->m_down2*0.08+prs->m_jiqiao*0.1+prs->m_yang*0.1+prs->m_gang*0.1+prs->m_inhouse1)*0.6+(prs->m_j2+prs->m_jump2+prs->m_run2+prs->m_ball2+prs->m_down2)/5*0.3+prs->m_inhouse2)<=100)
{str.Format("优秀");a++;
m_list.SetItemText(i,8,str);}

i++;
prs->MoveNext();}}
else{//以下添加一、二年级的内容
prs->MoveFirst();
while(!prs->IsEOF()){
	m_list.InsertItem(i,prs->m_name);
	str.Format("%5.2f",prs->m_j2*0.1+prs->m_jump2*0.1+prs->m_run2*0.1+prs->m_ball2*0.1+prs->m_jiqiao*0.166+prs->m_yang*0.167+prs->m_gang*0.167+prs->m_inhouse1);
	m_list.SetItemText(i,1,str);
	str.Format("%5.2f",(prs->m_j2*0.1+prs->m_jump2*0.1+prs->m_run2*0.1+prs->m_ball2*0.1+prs->m_jiqiao*0.166+prs->m_yang*0.167+prs->m_gang*0.167+prs->m_inhouse1)*0.9);	
	m_list.SetItemText(i,2,str);

	str.Format("%2.0f",(10-prs->m_inhouse2)/0.5);
	m_list.SetItemText(i,3,str);
	str.Format("%5.2f",prs->m_inhouse2);
	m_list.SetItemText(i,4,str);
//以下内容尚待修改
	str.Format("%5.2f",(((prs->m_j2*0.1+prs->m_jump2*0.1+prs->m_run2*0.1+prs->m_ball2*0.1+prs->m_jiqiao*0.166+prs->m_yang*0.167+prs->m_gang*0.167+prs->m_inhouse1)*0.9)+prs->m_inhouse2));
	m_list.SetItemText(i,5,str);
if((((prs->m_j2*0.1+prs->m_jump2*0.1+prs->m_run2*0.1+prs->m_ball2*0.1+prs->m_jiqiao*0.166+prs->m_yang*0.167+prs->m_gang*0.167+prs->m_inhouse1)*0.9)+prs->m_inhouse2)<60)
{str.Format("不及格");d++;
m_list.SetItemText(i,6,str);}
if((((prs->m_j2*0.1+prs->m_jump2*0.1+prs->m_run2*0.1+prs->m_ball2*0.1+prs->m_jiqiao*0.166+prs->m_yang*0.167+prs->m_gang*0.167+prs->m_inhouse1)*0.9)+prs->m_inhouse2)>=60&&(((prs->m_j2*0.1+prs->m_jump2*0.1+prs->m_run2*0.1+prs->m_ball2*0.1+prs->m_jiqiao*0.166+prs->m_yang*0.167+prs->m_gang*0.167+prs->m_inhouse1)*0.9)+prs->m_inhouse2)<75)
{str.Format("及格");c++;
m_list.SetItemText(i,6,str);}
if((((prs->m_j2*0.1+prs->m_jump2*0.1+prs->m_run2*0.1+prs->m_ball2*0.1+prs->m_jiqiao*0.166+prs->m_yang*0.167+prs->m_gang*0.167+prs->m_inhouse1)*0.9)+prs->m_inhouse2)>=75&&(((prs->m_j2*0.1+prs->m_jump2*0.1+prs->m_run2*0.1+prs->m_ball2*0.1+prs->m_jiqiao*0.166+prs->m_yang*0.167+prs->m_gang*0.167+prs->m_inhouse1)*0.9)+prs->m_inhouse2)<90)
123

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -