院校校运会管理系统课程设计报告 - 图文(5)

baoming1.Open();

m_list.InsertColumn(0,\学号\ m_list.InsertColumn(1,\姓名\ m_list.InsertColumn(2,\性别\ m_list.InsertColumn(3,\班级名称\ m_list.InsertColumn(4,\联系电话\ m_list.InsertColumn(5,\参赛项目\

RECT rect;

m_list.GetWindowRect(&rect); int wid=rect.right-rect.left; m_list.SetColumnWidth(0,wid/6); m_list.SetColumnWidth(1,wid/6); m_list.SetColumnWidth(2,wid/6); m_list.SetColumnWidth(3,wid/6); m_list.SetColumnWidth(4,wid/6); m_list.SetColumnWidth(5,wid/6); refresh();

// TODO: Add extra initialization here

return TRUE; // return TRUE unless you set the focus to a control // EXCEPTION: OCX Property Pages should return FALSE }

void Cbaoming::refresh() {

m_list.DeleteAllItems(); baoming1.MoveFirst(); int i=0;

while(!baoming1.IsEOF()) {

m_list.InsertItem(i,baoming1.m_Y_code); m_list.SetItemText(i,1,baoming1.m_Y_name); m_list.SetItemText(i,2,baoming1.m_sex);

m_list.SetItemText(i,3,baoming1.m_classname); m_list.SetItemText(i,4,baoming1.m_number); m_list.SetItemText(i,5,baoming1.m_item); baoming1.MoveNext(); i++; }

m_list.SetExtendedStyle(LVS_EX_FULLROWSELECT); baoming1.Close(); }

20

void Cbaoming::OnButton8() //清空信息 {

// TODO: Add your control notification handler code here m_list.DeleteAllItems(); jilu(\关闭所有参赛报名信息\}

void Cbaoming::OnButton2() //取消 {

// TODO: Add your control notification handler code here Cdeng deng;

jilu(\返回主菜单\

this->ShowWindow(SW_HIDE); deng.DoModal(); OnOK(); }

void Cbaoming::OnButton7() //显示信息 {

// TODO: Add your control notification handler code here baoming1.Open();

jilu(\查看所有参赛报名信息\ refresh(); }

void Cbaoming::OnButton3() //确认报名 {

// TODO: Add your control notification handler code here UpdateData(); baoming1.Open(); baoming1.AddNew();

baoming1.m_Y_code=m_code; baoming1.m_Y_name=m_name; baoming1.m_sex=m_sex;

baoming1.m_classname=m_classname; baoming1.m_number=m_number; baoming1.m_item=m_item;

baoming1.Update(); baoming1.Requery(); MessageBox(\报名成功！\m_code=\ m_name=\

21

m_sex=\

m_classname=\ m_number=\ m_item=\

jilu(\确认参赛报名\ refresh(); }

void Cbaoming::OnButton5() //修改信息 {

// TODO: Add your control notification handler code here UpdateData();

if(baoming1.Open()) baoming1.Close();

baoming1.m_strFilter.Format(\ baoming1.Open(); baoming1.Edit();

baoming1.m_Y_code=m_code; baoming1.m_Y_name=m_name; baoming1.m_sex=m_sex;

baoming1.m_classname=m_classname; baoming1.m_number=m_number; baoming1.m_item=m_item; baoming1.Update();

baoming1.m_strFilter=\ baoming1.Requery();

jilu(\修改参赛报名信息\ refresh(); } }

void Cbaoming::OnButton6() //删除信息 {

// TODO: Add your control notification handler code here UpdateData();

if(baoming1.Open()) baoming1.Close();

baoming1.m_strFilter.Format(\ baoming1.Open(); baoming1.Delete();

22

baoming1.m_Y_code=\ baoming1.m_Y_name=\ baoming1.m_sex=\

baoming1.m_classname=\ baoming1.m_number=\ baoming1.m_item=\

MessageBox(\已删除报名信息\ baoming1.m_strFilter=\ baoming1.Requery(); jilu(\删除报名信息\

refresh(); }

void Cbaoming::OnButton1() //确定 {

// TODO: Add your control notification handler code here UpdateData(); baoming1.Open(); baoming1.AddNew();

baoming1.m_Y_code=m_code; baoming1.m_Y_name=m_name; baoming1.m_sex=m_sex;

baoming1.m_classname=m_classname; baoming1.m_number=m_number; baoming1.m_item=m_item;

baoming1.Update(); baoming1.Requery(); m_code=\ m_name=\ m_sex=\

m_classname=\ m_number=\ m_item=\

jilu(\确定参赛报名\

refresh(); }

void Cbaoming::OnClickList2(NMHDR* pNMHDR, LRESULT* pResult) {

// TODO: Add your control notification handler code here int i=m_list.GetSelectionMark();//返回选中的行赋给i

23

//j=m_list.GetSelectionMark();

m_code=m_list.GetItemText(i,0);//获取第i行的0列的值赋给m_code m_name=m_list.GetItemText(i,1); m_sex=m_list.GetItemText(i,2); m_classname=m_list.GetItemText(i,3); m_number=m_list.GetItemText(i,4); m_item=m_list.GetItemText(i,5); UpdateData(FALSE); *pResult = 0;

报名信息界面： Cxinxi1 xinxi1;

BOOL Cxinxi::OnInitDialog() {

CDialog::OnInitDialog();

// TODO: Add extra initialization here

xinxi1.Open();

m_list.InsertColumn(0,\项目编号\ m_list.InsertColumn(1,\项目名称\ m_list.InsertColumn(2,\当前人数\ m_list.InsertColumn(3,\最大人数\ m_list.InsertColumn(4,\最小人数\

RECT rect;

m_list.GetWindowRect(&rect); int wid=rect.right-rect.left; m_list.SetColumnWidth(0,wid/5); m_list.SetColumnWidth(1,wid/5); m_list.SetColumnWidth(2,wid/5); m_list.SetColumnWidth(3,wid/5); m_list.SetColumnWidth(4,wid/5);

refresh();

return TRUE; // return TRUE unless you set the focus to a control // EXCEPTION: OCX Property Pages should return FALSE }

void Cxinxi::refresh()

24