oooview.cpp

体育信息管理系统

// oooView.cpp : implementation of the COooView class
//

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

#include "oooDoc.h"
#include "oooView.h"

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

/////////////////////////////////////////////////////////////////////////////
// COooView

IMPLEMENT_DYNCREATE(COooView, CListView)

BEGIN_MESSAGE_MAP(COooView, CListView)
	//{{AFX_MSG_MAP(COooView)
	ON_COMMAND(ID_MENUITEM32771, OnMenuitem32771)
	ON_COMMAND(ID_MENUITEM32772, OnMenuitem32772)
	ON_COMMAND(ID_MENUITEM32773, OnMenuitem32773)
	ON_COMMAND(ID_MENUITEM32785, OnMenuitem32785)
	//}}AFX_MSG_MAP
	// Standard printing commands
	ON_COMMAND(ID_FILE_PRINT, CListView::OnFilePrint)
	ON_COMMAND(ID_FILE_PRINT_DIRECT, CListView::OnFilePrint)
	ON_COMMAND(ID_FILE_PRINT_PREVIEW, CListView::OnFilePrintPreview)
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// COooView construction/destruction

COooView::COooView()
{gread=0;high1=64;high2=30;row=22;
sex1=sex2=0;t=0;
}

COooView::~COooView()
{COooApp*pp=(COooApp*)::AfxGetApp();
pp->f=0;
}

BOOL COooView::PreCreateWindow(CREATESTRUCT& cs)
{
	return CListView::PreCreateWindow(cs);
}

/////////////////////////////////////////////////////////////////////////////
// COooView drawing

void COooView::OnDraw(CDC* pDC)
{
	COooDoc* pDoc = GetDocument();
	ASSERT_VALID(pDoc);
}

void COooView::OnInitialUpdate()
{
	CListView::OnInitialUpdate();
	COooDoc* pDoc = GetDocument();
	CListCtrl&m_list=GetListCtrl();
	COooApp*pp=(COooApp*)AfxGetApp();
pp->f=1;
CString ss;
ss=pp->str;
gread=pp->gread;
if(pp->gread==1||pp->gread==2){
	m_list.InsertColumn(0,"姓名",LVCFMT_LEFT,100);
	m_list.InsertColumn(1,"性别",LVCFMT_LEFT,100);
	m_list.InsertColumn(2,"跳绳",LVCFMT_LEFT,100);
	m_list.InsertColumn(3,"跳绳成绩",LVCFMT_LEFT,100);
	m_list.InsertColumn(4,"跳远",LVCFMT_LEFT,100);
	m_list.InsertColumn(5,"跳远成绩",LVCFMT_LEFT,100);
	m_list.InsertColumn(6,"30米",LVCFMT_LEFT,100);
	m_list.InsertColumn(7,"30米成绩",LVCFMT_LEFT,100);
	m_list.InsertColumn(8,"垒球",LVCFMT_LEFT,100);
	m_list.InsertColumn(9,"垒球成绩",LVCFMT_LEFT,100);
	m_list.InsertColumn(10,"技巧一",LVCFMT_LEFT,100);
	m_list.InsertColumn(11,"技巧二",LVCFMT_LEFT,100);
	m_list.InsertColumn(12,"广播体操",LVCFMT_LEFT,100);
}
else
{	
	m_list.InsertColumn(0,"姓名",LVCFMT_LEFT,100);
	m_list.InsertColumn(1,"性别",LVCFMT_LEFT,100);
	m_list.InsertColumn(2,"跳绳",LVCFMT_LEFT,100);
	m_list.InsertColumn(3,"跳绳成绩",LVCFMT_LEFT,100);
	m_list.InsertColumn(4,"跳远",LVCFMT_LEFT,100);
	m_list.InsertColumn(5,"跳远成绩",LVCFMT_LEFT,100);
	m_list.InsertColumn(6,"50米",LVCFMT_LEFT,100);
	m_list.InsertColumn(7,"50米成绩",LVCFMT_LEFT,100);
	m_list.InsertColumn(8,"垒球",LVCFMT_LEFT,100);
	m_list.InsertColumn(9,"垒球成绩",LVCFMT_LEFT,100);
	m_list.InsertColumn(10,"仰卧起坐",LVCFMT_LEFT,100);
	m_list.InsertColumn(11,"仰卧起坐成绩",LVCFMT_LEFT,100);
	m_list.InsertColumn(12,"单杠",LVCFMT_LEFT,100);
	m_list.InsertColumn(13,"山羊",LVCFMT_LEFT,100);
	m_list.InsertColumn(14,"技巧",LVCFMT_LEFT,100);
	m_list.InsertColumn(15,"理论成绩",LVCFMT_LEFT,100);}

	m_list.SetTextBkColor(RGB(250,100,250));
	m_list.ModifyStyle(LVS_TYPEMASK,LVS_REPORT);
	m_list.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES);		//  its list control through a call to GetListCtrl().
	pDoc->ab();
//MessageBox(ss);
SetDatabasePath(ss);
pDoc->OnOpenDocument(ss);
	if(pDoc->isopen)
	{
	list();
	}

}

/////////////////////////////////////////////////////////////////////////////
// COooView printing

BOOL COooView::OnPreparePrinting(CPrintInfo* pInfo)
{
	// default preparation
	return DoPreparePrinting(pInfo);
}

void COooView::OnBeginPrinting(CDC* /*pDC*/, CPrintInfo* /*pInfo*/)
{
}

void COooView::OnEndPrinting(CDC* /*pDC*/, CPrintInfo* /*pInfo*/)
{
}

/////////////////////////////////////////////////////////////////////////////
// COooView diagnostics

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

void COooView::Dump(CDumpContext& dc) const
{
	CListView::Dump(dc);
}

COooDoc* COooView::GetDocument() // non-debug version is inline
{
	ASSERT(m_pDocument->IsKindOf(RUNTIME_CLASS(COooDoc)));
	return (COooDoc*)m_pDocument;
}
#endif //_DEBUG

/////////////////////////////////////////////////////////////////////////////
// COooView message handlers

void COooView::OnMenuitem32771() 
{	COooDoc* pDoc = GetDocument();
	ASSERT_VALID(pDoc);
COooApp*pp=(COooApp*)AfxGetApp();
	if(pp->c==0&&pp->d==0&&pp->e==0){
	CA *prs;
	prs=new CA(pDoc->m_pDB);
	prs->Open(dbOpenDynaset,prs->GetDefaultSQL(),0);
	CListCtrl&m_list=GetListCtrl();
	if(gread==3||gread==4||gread==5){
	ADD m_add;
	if(m_add.DoModal()==IDOK){t=1;
		prs->AddNew();
	if(m_add.m_name.IsEmpty()){AfxMessageBox("请输入姓名！");return;}
	if(m_add.sex==0){AfxMessageBox("请输入正确的性别！");return;}
		prs->m_name=m_add.m_name;
	if(m_add.sex==1){prs->m_sex="男";}
	if(m_add.sex==2){prs->m_sex="女";}
	prs->m_jumpline=m_add.m_jumpline;
	prs->m_jump=m_add.m_jump;
	prs->m_run=m_add.m_run;
	prs->m_ball=m_add.m_ball;
	prs->m_down=m_add.m_down;
	prs->m_gang=m_add.m_gang;
	prs->m_yang=m_add.m_yang;
	prs->m_jiqiao=m_add.m_jiqiao;
	prs->m_text=m_add.m_text;
	prs->m_inhouse1=10;
	prs->m_inhouse2=10;

}
	}
else{
ADD1 m_add1;
	if(m_add1.DoModal()==IDOK){t=1;
		prs->AddNew();
	if(m_add1.m_name.IsEmpty()){AfxMessageBox("请输入姓名！");return;}
	prs->m_name=m_add1.m_name;
	if(m_add1.sex==0){AfxMessageBox("请选择性别！");return;}
	if(m_add1.sex==1){prs->m_sex="男";}
	if(m_add1.sex==2){prs->m_sex="女";}
	prs->m_jumpline=m_add1.m_jumpline;
	prs->m_jump=m_add1.m_jump;
	prs->m_run=m_add1.m_run;
	prs->m_ball=m_add1.m_ball;
	prs->m_gang=m_add1.m_gang;
	prs->m_yang=m_add1.m_yang;
	prs->m_jiqiao=m_add1.m_jiqiao;
	prs->m_inhouse1=10;
	prs->m_inhouse2=10;
}}
if(gread==3&&prs->m_sex=="男")
	{
	if(prs->m_jumpline>=158)
	{prs->m_j2=100;}
	if(prs->m_jumpline>=151&&prs->m_jumpline<158)
	{prs->m_j2=95;}
	if(prs->m_jumpline>=144&&prs->m_jumpline<151)
	{prs->m_j2=90;}
	if(prs->m_jumpline>=136&&prs->m_jumpline<144)
	{prs->m_j2=85;}
	if(prs->m_jumpline>=129&&prs->m_jumpline<136)
	{prs->m_j2=80;}
	if(prs->m_jumpline>=122&&prs->m_jumpline<129)
	{prs->m_j2=75;}
	if(prs->m_jumpline>=115&&prs->m_jumpline<122)
	{prs->m_j2=70;}
	if(prs->m_jumpline>=103&&prs->m_jumpline<115)
	{prs->m_j2=65;}
	if(prs->m_jumpline>=100&&prs->m_jumpline<103)
	{prs->m_j2=60;}
	if(prs->m_jumpline>=93&&prs->m_jumpline<100)
	{prs->m_j2=55;}
	if(prs->m_jumpline>=86&&prs->m_jumpline<93)
	{prs->m_j2=50;}
	if(prs->m_jumpline>=79&&prs->m_jumpline<86)
	{prs->m_j2=45;}
	if(prs->m_jumpline>=72&&prs->m_jumpline<79)
	{prs->m_j2=40;}
	if(prs->m_jumpline>=65&&prs->m_jumpline<72)
	{prs->m_j2=35;}
	if(prs->m_jumpline>=58&&prs->m_jumpline<65)
	{prs->m_j2=30;}
	if(prs->m_jumpline>=52&&prs->m_jumpline<58)
	{prs->m_j2=25;}
	if(prs->m_jumpline>=45&&prs->m_jumpline<52)
	{prs->m_j2=20;}
	if(prs->m_jumpline>=38&&prs->m_jumpline<45)
	{prs->m_j2=15;}
	if(prs->m_jumpline>=31&&prs->m_jumpline<38)
	{prs->m_j2=10;}
	if(prs->m_jumpline>=24&&prs->m_jumpline<31)
	{prs->m_j2=5;}
	if(prs->m_jumpline<24)
	{prs->m_j2=0;}

if(prs->m_jump>=1.74)
	{prs->m_jump2=100;}
	if(prs->m_jump>=1.71&&prs->m_jump<1.74)
	{prs->m_jump2=95;}
	if(prs->m_jump>=1.67&&prs->m_jump<1.71)
	{prs->m_jump2=90;}
	if(prs->m_jump>=1.64&&prs->m_jump<1.67)
	{prs->m_jump2=85;}
	if(prs->m_jump>=1.60&&prs->m_jump<164)
	{prs->m_jump2=80;}
	if(prs->m_jump>=1.57&&prs->m_jump<1.60)
	{prs->m_jump2=75;}
	if(prs->m_jump>=1.54&&prs->m_jump<1.57)
	{prs->m_jump2=70;}
	if(prs->m_jump>=1.50&&prs->m_jump<1.54)
	{prs->m_jump2=65;}
	if(prs->m_jump>=1.47&&prs->m_jump<1.50)
	{prs->m_jump2=60;}
	if(prs->m_jump>=1.43&&prs->m_jump<1.47)
	{prs->m_jump2=55;}
	if(prs->m_jump>=1.40&&prs->m_jump<1.43)
	{prs->m_jump2=50;}
	if(prs->m_jump>=1.36&&prs->m_jump<1.40)
	{prs->m_jump2=45;}
	if(prs->m_jump>=1.33&&prs->m_jump<1.36)
	{prs->m_jump2=40;}
	if(prs->m_jump>=1.29&&prs->m_jump<1.33)
	{prs->m_jump2=35;}
	if(prs->m_jump>=1.25&&prs->m_jump<1.29)
	{prs->m_jump2=30;}
	if(prs->m_jump>=1.22&&prs->m_jump<1.25)
	{prs->m_jump2=25;}
	if(prs->m_jump>=1.18&&prs->m_jump<1.22)
	{prs->m_jump2=20;}
	if(prs->m_jump>=1.14&&prs->m_jump<1.18)
	{prs->m_jump2=15;}
	if(prs->m_jump>=1.10&&prs->m_jump<1.14)
	{prs->m_jump2=10;}
	if(prs->m_jump>=1.07&&prs->m_jump<1.10)
	{prs->m_jump2=5;}
	if(prs->m_jump<1.07)
	{prs->m_jump2=0;}
if(prs->m_run<=8.4&&prs->m_run>0)
	{prs->m_run2=100;}
	if(prs->m_run>8.4&&prs->m_run<=8.5)
	{prs->m_run2=95;}
	if(prs->m_run>8.5&&prs->m_run<=8.7)
	{prs->m_run2=90;}
	if(prs->m_run>8.7&&prs->m_run<=8.8)
	{prs->m_run2=85;}
	if(prs->m_run>8.8&&prs->m_run<=9)
	{prs->m_run2=80;}
	if(prs->m_run>9&&prs->m_run<=9.1)
	{prs->m_run2=75;}
	if(prs->m_run>9.1&&prs->m_run<=9.2)
	{prs->m_run2=70;}
	if(prs->m_run>9.2&&prs->m_run<=9.4)
	{prs->m_run2=65;}
	if(prs->m_run>9.4&&prs->m_run<=9.5)
	{prs->m_run2=60;}
	if(prs->m_run>9.5&&prs->m_run<=9.7)
	{prs->m_run2=55;}
	if(prs->m_run>9.7&&prs->m_run<=9.8)
	{prs->m_run2=50;}
	if(prs->m_run>9.8&&prs->m_run<=10)
	{prs->m_run2=45;}
	if(prs->m_run>10&&prs->m_run<=10.1)
	{prs->m_run2=40;}
	if(prs->m_run>10.1&&prs->m_run<=10.3)
	{prs->m_run2=35;}
	if(prs->m_run>10.3&&prs->m_run<=10.5)
	{prs->m_run2=30;}
	if(prs->m_run>10.5&&prs->m_run<=10.7)
	{prs->m_run2=25;}
	if(prs->m_run>10.7&&prs->m_run<=10.8)
	{prs->m_run2=20;}
	if(prs->m_run>10.8&&prs->m_run<=11)
	{prs->m_run2=15;}
	if(prs->m_run>11&&prs->m_run<=11.2)
	{prs->m_run2=10;}
	if(prs->m_run>11.2&&prs->m_run<=11.3)
	{prs->m_run2=5;}
	if(prs->m_run>11.3||prs->m_run==0)
	{prs->m_run2=0;}	

if(prs->m_ball>=29.4)
	{prs->m_ball2=100;}
	if(prs->m_ball>=28.3&&prs->m_ball<29.4)
	{prs->m_ball2=95;}
	if(prs->m_ball>=27.1&&prs->m_ball<28.3)
	{prs->m_ball2=90;}
	if(prs->m_ball>=26&&prs->m_ball<27.1)
	{prs->m_ball2=85;}
	if(prs->m_ball>=24.9&&prs->m_ball<26)
	{prs->m_ball2=80;}
	if(prs->m_ball>=23.7&&prs->m_ball<24.9)
	{prs->m_ball2=75;}
	if(prs->m_ball>=22.6&&prs->m_ball<23.7)
	{prs->m_ball2=70;}
	if(prs->m_ball>=21.6&&prs->m_ball<22.6)
	{prs->m_ball2=65;}
	if(prs->m_ball>=20.4&&prs->m_ball<21.6)
	{prs->m_ball2=60;}
	if(prs->m_ball>=19.4&&prs->m_ball<20.4)
	{prs->m_ball2=55;}
	if(prs->m_ball>=18.3&&prs->m_ball<19.4)
	{prs->m_ball2=50;}
	if(prs->m_ball>=17.3&&prs->m_ball<18.3)
	{prs->m_ball2=45;}
	if(prs->m_ball>=16.3&&prs->m_ball<17.3)
	{prs->m_ball2=40;}
	if(prs->m_ball>=15.2&&prs->m_ball<16.3)
	{prs->m_ball2=35;}
	if(prs->m_ball>=14.2&&prs->m_ball<15.2)
	{prs->m_ball2=30;}
	if(prs->m_ball>=13.2&&prs->m_ball<14.2)
	{prs->m_ball2=25;}
	if(prs->m_ball>=12.1&&prs->m_ball<13.2)
	{prs->m_ball2=20;}
	if(prs->m_ball>=11.1&&prs->m_ball<12.1)
	{prs->m_ball2=15;}
	if(prs->m_ball>=10.1&&prs->m_ball<11.1)
	{prs->m_ball2=10;}
	if(prs->m_ball>=9.1&&prs->m_ball<10.1)
	{prs->m_ball2=5;}
	if(prs->m_ball<9.1)
	{prs->m_ball2=0;}
if(prs->m_down>=39)
	{prs->m_down2=100;}
	if(prs->m_down>=37&&prs->m_down<39)
	{prs->m_down2=95;}
	if(prs->m_down>=35&&prs->m_down<37)
	{prs->m_down2=90;}
	if(prs->m_down>=33&&prs->m_down<35)
	{prs->m_down2=85;}
	if(prs->m_down>=31&&prs->m_down<33)
	{prs->m_down2=80;}
	if(prs->m_down>=29&&prs->m_down<31)
	{prs->m_down2=75;}
	if(prs->m_down>=27&&prs->m_down<29)
	{prs->m_down2=70;}
	if(prs->m_down>=25&&prs->m_down<27)
	{prs->m_down2=65;}
	if(prs->m_down>=23&&prs->m_down<25)
	{prs->m_down2=60;}
	if(prs->m_down>=21&&prs->m_down<23)
	{prs->m_down2=55;}
	if(prs->m_down>=19&&prs->m_down<21)
	{prs->m_down2=50;}
	if(prs->m_down>=17&&prs->m_down<19)
	{prs->m_down2=45;}
	if(prs->m_down>=15&&prs->m_down<17)
	{prs->m_down2=40;}
	if(prs->m_down>=13&&prs->m_down<15)
	{prs->m_down2=35;}
	if(prs->m_down>=11&&prs->m_down<13)
	{prs->m_down2=30;}
	if(prs->m_down>=9&&prs->m_down<11)
	{prs->m_down2=25;}
	if(prs->m_down>=7&&prs->m_down<9)
	{prs->m_down2=20;}
	if(prs->m_down>=5&&prs->m_down<7)
	{prs->m_down2=15;}
	if(prs->m_down>=4&&prs->m_down<5)
	{prs->m_down2=10;}
	if(prs->m_down>=3&&prs->m_down<4)
	{prs->m_down2=5;}
	if(prs->m_down<3)
	{prs->m_down2=0;}

	}

if(gread==3&&prs->m_sex=="女")
	{
	if(prs->m_jumpline>=169)
	{prs->m_j2=100;}
	if(prs->m_jumpline>=163&&prs->m_jumpline<169)
	{prs->m_j2=95;}
	if(prs->m_jumpline>=156&&prs->m_jumpline<163)
	{prs->m_j2=90;}
	if(prs->m_jumpline>=150&&prs->m_jumpline<156)
	{prs->m_j2=85;}
	if(prs->m_jumpline>=144&&prs->m_jumpline<150)
	{prs->m_j2=80;}
	if(prs->m_jumpline>=138&&prs->m_jumpline<144)
	{prs->m_j2=75;}
	if(prs->m_jumpline>=131&&prs->m_jumpline<138)
	{prs->m_j2=70;}
	if(prs->m_jumpline>=125&&prs->m_jumpline<131)
	{prs->m_j2=65;}
	if(prs->m_jumpline>=119&&prs->m_jumpline<125)
	{prs->m_j2=60;}
	if(prs->m_jumpline>=112&&prs->m_jumpline<119)
	{prs->m_j2=55;}