oooview.cpp

体育信息管理系统

	if(prs->m_jump>=2.72&&prs->m_jump<2.88)
	{prs->m_jump2=65;}
	if(prs->m_jump>=2.72&&prs->m_jump<2.80)
	{prs->m_jump2=60;}
	if(prs->m_jump>=2.64&&prs->m_jump<2.72)
	{prs->m_jump2=55;}
	if(prs->m_jump>=2.56&&prs->m_jump<2.64)
	{prs->m_jump2=50;}
	if(prs->m_jump>=2.47&&prs->m_jump<2.56)
	{prs->m_jump2=45;}
	if(prs->m_jump>=2.37&&prs->m_jump<2.47)
	{prs->m_jump2=40;}
	if(prs->m_jump>=2.28&&prs->m_jump<2.37)
	{prs->m_jump2=35;}
	if(prs->m_jump>=2.19&&prs->m_jump<2.28)
	{prs->m_jump2=30;}
	if(prs->m_jump>=2.1&&prs->m_jump<2.19)
	{prs->m_jump2=25;}
	if(prs->m_jump>=2.01&&prs->m_jump<2.1)
	{prs->m_jump2=20;}
	if(prs->m_jump>=1.91&&prs->m_jump<2.01)
	{prs->m_jump2=15;}
	if(prs->m_jump>=1.82&&prs->m_jump<1.91)
	{prs->m_jump2=10;}
	if(prs->m_jump>=1.73&&prs->m_jump<1.82)
	{prs->m_jump2=5;}
	if(prs->m_jump<1.73)
	{prs->m_jump2=0;}
if(prs->m_run<=8.3&&prs->m_run>0)
	{prs->m_run2=100;}
	if(prs->m_run>8.3&&prs->m_run<=8.4)
	{prs->m_run2=95;}
	if(prs->m_run>8.4&&prs->m_run<=8.6)
	{prs->m_run2=90;}
	if(prs->m_run>8.6&&prs->m_run<=8.7)
	{prs->m_run2=85;}
	if(prs->m_run>8.7&&prs->m_run<=8.8)
	{prs->m_run2=80;}
	if(prs->m_run>8.8&&prs->m_run<=9.0)
	{prs->m_run2=75;}
	if(prs->m_run>9.0&&prs->m_run<=9.1)
	{prs->m_run2=70;}
	if(prs->m_run>9.1&&prs->m_run<=9.2)
	{prs->m_run2=65;}
	if(prs->m_run>9.2&&prs->m_run<=9.3)
	{prs->m_run2=60;}
	if(prs->m_run>9.3&&prs->m_run<=9.5)
	{prs->m_run2=55;}
	if(prs->m_run>9.5&&prs->m_run<=9.6)
	{prs->m_run2=50;}
	if(prs->m_run>9.6&&prs->m_run<=9.8)
	{prs->m_run2=45;}
	if(prs->m_run>9.8&&prs->m_run<=10.0)
	{prs->m_run2=40;}
	if(prs->m_run>10.0&&prs->m_run<=10.2)
	{prs->m_run2=35;}
	if(prs->m_run>10.2&&prs->m_run<=10.4)
	{prs->m_run2=30;}
	if(prs->m_run>10.4&&prs->m_run<=10.5)
	{prs->m_run2=25;}
	if(prs->m_run>10.5&&prs->m_run<=10.7)
	{prs->m_run2=20;}
	if(prs->m_run>10.7&&prs->m_run<=10.9)
	{prs->m_run2=15;}
	if(prs->m_run>10.9&&prs->m_run<=11.1)
	{prs->m_run2=10;}
	if(prs->m_run>11.1&&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>=23.8)
	{prs->m_ball2=100;}
	if(prs->m_ball>=22.8&&prs->m_ball<23.8)
	{prs->m_ball2=95;}
	if(prs->m_ball>=21.8&&prs->m_ball<22.8)
	{prs->m_ball2=90;}
	if(prs->m_ball>=20.9&&prs->m_ball<21.8)
	{prs->m_ball2=85;}
	if(prs->m_ball>=19.9&&prs->m_ball<20.9)
	{prs->m_ball2=80;}
	if(prs->m_ball>=18.9&&prs->m_ball<19.9)
	{prs->m_ball2=75;}
	if(prs->m_ball>=17.9&&prs->m_ball<18.9)
	{prs->m_ball2=70;}
	if(prs->m_ball>=16.9&&prs->m_ball<17.9)
	{prs->m_ball2=65;}
	if(prs->m_ball>=16&&prs->m_ball<16.9)
	{prs->m_ball2=60;}
	if(prs->m_ball>=15.2&&prs->m_ball<16)
	{prs->m_ball2=55;}
	if(prs->m_ball>=14.3&&prs->m_ball<15.2)
	{prs->m_ball2=50;}
	if(prs->m_ball>=13.5&&prs->m_ball<14.3)
	{prs->m_ball2=45;}
	if(prs->m_ball>=12.7&&prs->m_ball<13.5)
	{prs->m_ball2=40;}
	if(prs->m_ball>=11.9&&prs->m_ball<12.7)
	{prs->m_ball2=35;}
	if(prs->m_ball>=11.1&&prs->m_ball<11.9)
	{prs->m_ball2=30;}
	if(prs->m_ball>=10.3&&prs->m_ball<11.1)
	{prs->m_ball2=25;}
	if(prs->m_ball>=9.4&&prs->m_ball<10.3)
	{prs->m_ball2=20;}
	if(prs->m_ball>=8.6&&prs->m_ball<9.4)
	{prs->m_ball2=15;}
	if(prs->m_ball>=7.8&&prs->m_ball<8.6)
	{prs->m_ball2=10;}
	if(prs->m_ball>=7&&prs->m_ball<7.8)
	{prs->m_ball2=5;}
	if(prs->m_ball<7)
	{prs->m_ball2=0;}
if(prs->m_down>=36)
	{prs->m_down2=100;}
	if(prs->m_down>=34&&prs->m_down<36)
	{prs->m_down2=95;}
	if(prs->m_down>=32&&prs->m_down<34)
	{prs->m_down2=90;}
	if(prs->m_down>=30&&prs->m_down<32)
	{prs->m_down2=85;}
	if(prs->m_down>=28&&prs->m_down<30)
	{prs->m_down2=80;}
	if(prs->m_down>=26&&prs->m_down<28)
	{prs->m_down2=75;}
	if(prs->m_down>=24&&prs->m_down<26)
	{prs->m_down2=70;}
	if(prs->m_down>=22&&prs->m_down<24)
	{prs->m_down2=65;}
	if(prs->m_down>=20&&prs->m_down<22)
	{prs->m_down2=60;}
	if(prs->m_down>=18&&prs->m_down<20)
	{prs->m_down2=55;}
	if(prs->m_down>=16&&prs->m_down<18)
	{prs->m_down2=50;}
	if(prs->m_down>=14&&prs->m_down<16)
	{prs->m_down2=45;}
	if(prs->m_down>=12&&prs->m_down<14)
	{prs->m_down2=40;}
	if(prs->m_down>=10&&prs->m_down<12)
	{prs->m_down2=35;}
	if(prs->m_down>=8&&prs->m_down<10)
	{prs->m_down2=30;}
	if(prs->m_down>=6&&prs->m_down<8)
	{prs->m_down2=25;}
	if(prs->m_down>=4&&prs->m_down<6)
	{prs->m_down2=20;}
	if(prs->m_down>=2&&prs->m_down<4)
	{prs->m_down2=15;}
	if(prs->m_down<2)
	{prs->m_down2=0;
	}}//这句一定要放在双括号内，否则会提示错误的更新记录集
	if(t==1){t=0;prs->Update();}
m_list.DeleteAllItems();
list();		}
else
AfxMessageBox("请关闭报表窗口，再试一次.");
}

void COooView::OnMenuitem32772() 
{COooDoc* pDoc = GetDocument();
	ASSERT_VALID(pDoc);
	CListCtrl&m_list=GetListCtrl();
COooApp*pp=(COooApp*)::AfxGetApp();
if(pp->a==0&&pp->b==0&&pp->c==0&&pp->d==0&&pp->e==0){

CA *prs;
prs=new CA(pDoc->m_pDB);
prs->Open(dbOpenDynaset,prs->GetDefaultSQL(),0);
int in=m_list.GetNextItem(-1,LVNI_SELECTED);
if(in==-1){AfxMessageBox("请选择要更改的记录");return;}
CString str;
str=m_list.GetItemText(in,0);	
CString ss("name=");
	ss+="'";
	ss+=str;
	ss+="'";
	prs->m_strFilter=ss;
	prs->Requery();

if(gread==3||gread==4||gread==5){
ADD m_cb;
m_cb.m_name=prs->m_name;
/*
if(prs->m_sex=="男")
{((CButton*)m_cb.GetDlgItem(IDC_RADIO1))->SetCheck(true);}
else
{((CButton*)m_cb.GetDlgItem(IDC_RADIO2))->SetCheck(true);}
*/
m_cb.m_jumpline=prs->m_jumpline;
m_cb.m_jump=prs->m_jump;
m_cb.m_run=prs->m_run;
m_cb.m_ball=prs->m_ball;
m_cb.m_down=prs->m_down;
m_cb.m_gang=prs->m_gang;
m_cb.m_yang=prs->m_yang;
m_cb.m_jiqiao=prs->m_jiqiao;
m_cb.m_text=prs->m_text;
if(m_cb.DoModal()==IDOK){t=1;
if(m_cb.m_name.IsEmpty()){AfxMessageBox("请输入姓名！");return;}
if(m_cb.sex==0){AfxMessageBox("请输入正确的性别！");return;}
prs->Edit();
prs->m_name=m_cb.m_name;

if(prs->m_name!=str){
	CB *prs1;
prs1=new CB(pDoc->m_pDB);
prs1->Open(dbOpenDynaset,prs1->GetDefaultSQL(),0);
if(prs1->GetRecordCount()){
prs1->MoveFirst();
while(!prs1->IsEOF()){
	if(prs1->m_column1==str){prs1->Edit();prs1->m_column1=prs->m_name;prs1->Update();}
	prs1->MoveNext();}}

CC *prs2;
prs2=new CC(pDoc->m_pDB);
prs2->Open(dbOpenDynaset,prs2->GetDefaultSQL(),0);
if(prs2->GetRecordCount()){
prs2->MoveFirst();
while(!prs2->IsEOF()){
	if(prs2->m_column1==str){		prs2->Edit();prs2->m_column1=prs->m_name;prs2->Update();}
	prs2->MoveNext();}}
}


if(m_cb.sex==1){prs->m_sex="男";}
if(m_cb.sex==2){prs->m_sex="女";}
prs->m_jumpline=m_cb.m_jumpline;
prs->m_jump=m_cb.m_jump;
prs->m_run=m_cb.m_run;
prs->m_ball=m_cb.m_ball;
prs->m_down=m_cb.m_down;
prs->m_gang=m_cb.m_gang;
prs->m_yang=m_cb.m_yang;
prs->m_jiqiao=m_cb.m_jiqiao;
prs->m_text=m_cb.m_text;
}
}
	else{ADD1 m_cb;
m_cb.m_name=prs->m_name;
m_cb.m_jumpline=prs->m_jumpline;
m_cb.m_jump=prs->m_jump;
m_cb.m_run=prs->m_run;
m_cb.m_ball=prs->m_ball;
m_cb.m_gang=prs->m_gang;
m_cb.m_yang=prs->m_yang;
m_cb.m_jiqiao=prs->m_jiqiao;
if(m_cb.DoModal()==IDOK){t=1;
if(m_cb.m_name.IsEmpty()){AfxMessageBox("请输入姓名！");return;}
if(m_cb.sex==0){AfxMessageBox("请输入正确的性别！");return;}
prs->Edit();
prs->m_name=m_cb.m_name;

if(prs->m_name!=str){
	CB *prs1;
prs1=new CB(pDoc->m_pDB);
prs1->Open(dbOpenDynaset,prs1->GetDefaultSQL(),0);
if(prs1->GetRecordCount()){
prs1->MoveFirst();
while(!prs1->IsEOF()){
	if(prs1->m_column1==str){		prs1->Edit();prs1->m_column1=prs->m_name;prs1->Update();}
	prs1->MoveNext();}}

CC *prs2;
prs2=new CC(pDoc->m_pDB);
prs2->Open(dbOpenDynaset,prs2->GetDefaultSQL(),0);
if(prs2->GetRecordCount()){
prs2->MoveFirst();
while(!prs2->IsEOF()){
	if(prs2->m_column1==str){		prs2->Edit();prs2->m_column1=prs->m_name;prs2->Update();}
	prs2->MoveNext();}}}

if(m_cb.sex==1){prs->m_sex="男";}
if(m_cb.sex==2){prs->m_sex="女";}
prs->m_jumpline=m_cb.m_jumpline;
prs->m_jump=m_cb.m_jump;
prs->m_run=m_cb.m_run;
prs->m_ball=m_cb.m_ball;
prs->m_gang=m_cb.m_gang;
prs->m_yang=m_cb.m_yang;
prs->m_jiqiao=m_cb.m_jiqiao;
}	
	}

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<1.64)
	{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;}