基于C++和Mysql+MFC的宠物管理系统源码+详细注释(课程设计).zip

// CW.cpp: 实现文件 // #include "pch.h" #include "YunTing_宠物店管理系统.h" #include "CW.h" #include "afxdialogex.h" #include"C_InfoFile.h" #include"JiLu.h" #include"boardingAlightingPossibility.h" #include"PetGrooming.h" #include"PetMedicalRecordRegistration.h" #include"PetRegistration.h" #include"PetSalesRegistration.h" // CW 对话框 IMPLEMENT_DYNAMIC(CW, CDialogEx) CW::CW(CWnd* pParent /*=nullptr*/) : CDialogEx(IDD_CW, pParent) { } CW::~CW() { } void CW::DoDataExchange(CDataExchange* pDX) { CDialogEx::DoDataExchange(pDX); DDX_Control(pDX, IDC_EDIT10, B_id); DDX_Control(pDX, IDC_LIST4, m_List); DDX_Control(pDX, IDC_EDIT9, P_id); DDX_Control(pDX, IDC_EDIT8, zhongko); DDX_Control(pDX, IDC_EDIT16, M_id); DDX_Control(pDX, IDC_EDIT10, B_id); DDX_Control(pDX, IDC_EDIT12, G_id); DDX_Control(pDX, IDC_EDIT14, MR_id); DDX_Control(pDX, IDC_EDIT18, S_id); } BEGIN_MESSAGE_MAP(CW, CDialogEx) ON_BN_CLICKED(IDOK26, &CW::OnBnClickedOk26) ON_BN_CLICKED(IDOK29, &CW::OnBnClickedOk29) ON_BN_CLICKED(IDOK27, &CW::OnBnClickedOk27) ON_BN_CLICKED(IDOK28, &CW::OnBnClickedOk28) ON_BN_CLICKED(IDOK30, &CW::OnBnClickedOk30) ON_BN_CLICKED(IDOK31, &CW::OnBnClickedOk31) ON_BN_CLICKED(IDOK5, &CW::OnBnClickedOk5) ON_BN_CLICKED(IDOK3, &CW::OnBnClickedOk3) ON_BN_CLICKED(IDOK2, &CW::OnBnClickedOk2) ON_BN_CLICKED(IDOK6, &CW::OnBnClickedOk6) ON_BN_CLICKED(IDOK10, &CW::OnBnClickedOk10) ON_BN_CLICKED(IDOK14, &CW::OnBnClickedOk14) ON_BN_CLICKED(IDOK18, &CW::OnBnClickedOk18) ON_BN_CLICKED(IDOK22, &CW::OnBnClickedOk22) ON_BN_CLICKED(IDOK7, &CW::OnBnClickedOk7) ON_BN_CLICKED(IDOK11, &CW::OnBnClickedOk11) ON_BN_CLICKED(IDOK15, &CW::OnBnClickedOk15) ON_BN_CLICKED(IDOK19, &CW::OnBnClickedOk19) ON_BN_CLICKED(IDOK23, &CW::OnBnClickedOk23) ON_BN_CLICKED(IDOK8, &CW::OnBnClickedOk8) ON_BN_CLICKED(IDOK12, &CW::OnBnClickedOk12) ON_BN_CLICKED(IDOK16, &CW::OnBnClickedOk16) ON_BN_CLICKED(IDOK20, &CW::OnBnClickedOk20) ON_BN_CLICKED(IDOK24, &CW::OnBnClickedOk24) ON_BN_CLICKED(IDOK4, &CW::OnBnClickedOk4) ON_BN_CLICKED(IDOK9, &CW::OnBnClickedOk9) ON_BN_CLICKED(IDOK13, &CW::OnBnClickedOk13) ON_BN_CLICKED(IDOK17, &CW::OnBnClickedOk17) ON_BN_CLICKED(IDOK21, &CW::OnBnClickedOk21) ON_BN_CLICKED(IDOK25, &CW::OnBnClickedOk25) ON_BN_CLICKED(IDOK32, &CW::OnBnClickedOk32) END_MESSAGE_MAP() // CW 消息处理程序 //查询所有宠物信息 void CW::OnBnClickedOk26() { // TODO: 在此添加控件通知处理程序代码 if (connect_db()) { //MessageBox(_T("数据库连接连接成功")); C_InfoFile file; file.GitPet(); // Delete all rows m_List.DeleteAllItems(); // Delete all columns while (m_List.DeleteColumn(0)); // Reset extended style to default //m_List.SetExtendedStyle(LVS_EX_FULLROWSELECT | LVS_EX_HEADERDRAGDROP); // Reset foreground color, background color and font //m_List.SetTextColor(CLR_DEFAULT); //m_List.SetBkColor(CLR_DEFAULT); //m_List.SetFont(nullptr); m_List.SetExtendedStyle(LVS_EX_FULLROWSELECT); m_List.InsertColumn(0, _T("宠物编号"), 0, 80); m_List.InsertColumn(1, _T("宠物姓名"), 0, 70); m_List.InsertColumn(2, _T("种类"), 0, 80); m_List.InsertColumn(3, _T("性别"), 0, 50); m_List.InsertColumn(4, _T("年龄"), 0, 80); int i = 0; for (vector<Pet>::iterator it = file.lies2.begin(); it != file.lies2.end(); it++) //将文件数据写入列表 { m_List.InsertItem(i, (CString)to_string(it->pet_id).c_str()); m_List.SetItemText(i, 1, (CString)it->pet_name.c_str()); m_List.SetItemText(i, 2, (CString)it->breed.c_str()); m_List.SetItemText(i, 3, (CString)it->gender.c_str()); m_List.SetItemText(i,4, (CString)to_string(it->age).c_str()); i++; } } else { MessageBox(_T("数据库连接失败，请重新操作"), _T("提示")); } } //查询会员信息 void CW::OnBnClickedOk29() { // TODO: 在此添加控件通知处理程序代码 if (connect_db()) { //MessageBox(_T("数据库连接连接成功")); C_InfoFile file; file.GitMember(); // Delete all rows m_List.DeleteAllItems(); // Delete all columns while (m_List.DeleteColumn(0)); // Reset extended style to default //m_List.SetExtendedStyle(LVS_EX_FULLROWSELECT | LVS_EX_HEADERDRAGDROP); // Reset foreground color, background color and font //m_List.SetTextColor(CLR_DEFAULT); //m_List.SetBkColor(CLR_DEFAULT); //m_List.SetFont(nullptr); m_List.SetExtendedStyle(LVS_EX_FULLROWSELECT); m_List.InsertColumn(0, _T("会员编号"), 0, 80); m_List.InsertColumn(1, _T("姓名"), 0, 70); m_List.InsertColumn(2, _T("手机号码"), 0, 80); m_List.InsertColumn(3, _T("地址"), 0, 100); int i = 0; for (vector<Member>::iterator it = file.lies1.begin(); it != file.lies1.end(); it++) //将文件数据写入列表 { m_List.InsertItem(i, (CString)to_string(it->member_id).c_str()); m_List.SetItemText(i, 1, (CString)it->name.c_str()); m_List.SetItemText(i, 2, (CString)it->phone_num.c_str()); m_List.SetItemText(i, 3, (CString)it->address.c_str()); i++; } } else { MessageBox(_T("数据库连接失败，请重新操作"), _T("提示")); } } //宠物寄养查询 void CW::OnBnClickedOk27() { // TODO: 在此添加控件通知处理程序代码 if (connect_db()) { //MessageBox(_T("数据库连接连接成功")); C_InfoFile file; file.GitBoarding(); // Delete all rows m_List.DeleteAllItems(); // Delete all columns while (m_List.DeleteColumn(0)); // Reset extended style to default //m_List.SetExtendedStyle(LVS_EX_FULLROWSELECT | LVS_EX_HEADERDRAGDROP); // Reset foreground color, background color and font //m_List.SetTextColor(CLR_DEFAULT); //m_List.SetBkColor(CLR_DEFAULT); //m_List.SetFont(nullptr); m_List.SetExtendedStyle(LVS_EX_FULLROWSELECT); m_List.InsertColumn(0, _T("寄养登记编号"), 0, 80); m_List.InsertColumn(1, _T("宠物编号"), 0, 70); m_List.InsertColumn(2, _T("寄养起始日期"), 0, 150); m_List.InsertColumn(3, _T("寄养结束日期"), 0, 150); m_List.InsertColumn(4, _T("寄养费用"), 0, 100); int i = 0; for (vector<Boarding>::iterator it = file.lies5.begin(); it != file.lies5.end(); it++) //将文件数据写入列表 { m_List.InsertItem(i, (CString)to_string(it->register_id).c_str()); m_List.SetItemText(i, 1, (CString)to_string(it->pet_id).c_str()); m_List.SetItemText(i, 2, (CString)it->boarding_start_date.c_str()); m_List.SetItemText(i, 3, (CString)it->boarding_end_date.c_str()); m_List.SetItemText(i, 4, (CString)it->boarding_expense.c_str()); i++; } } else { MessageBox(_T("数据库连接失败，请重新操作"), _T("提示")); } } //宠物美容查询 void CW::OnBnClickedOk28() { // TODO: 在此添加控件通知处理程序代码 // TODO: 在此添加控件通知处理程序代码 if (connect_db()) { //MessageBox(_T("数据库连接连接成功")); C_InfoFile file; file.GitGrooming(); // Delete all rows m_List.DeleteAllItems(); // Delete all columns while (m_List.DeleteColumn(0)); // Reset extended style to default //m_List.SetExtendedStyle(LVS_EX_FULLROWSELECT | LVS_EX_HEADERDRAGDROP); // Reset foreground color, background color and font //m_List.SetTextColor(CLR_DEFAULT); //m_List.SetBkColor(CLR_DEFAULT); //m_List.SetFont(nullptr); m_List.SetExtendedStyle(LVS_EX_FULLROWSELECT); m_List.InsertColumn(0, _T("美容编号"), 0, 80); m_List.InsertColumn(1, _T("宠物编号"), 0, 70); m_List.InsertColumn(2, _T("美容时间"), 0, 150); m_List.InsertColumn(3, _T("美容费用"), 0, 70); int i = 0; for (vector<Grooming>::iterator it = file.lies4.begin(); it != file.lies4.end(); it++) //将文件数据写入列表 { m_List.InsertItem(i, (CString)to_string(it->register_id).c_str()); m_List.SetItemText(i, 1, (CString)to_string(it->pet_id).c_str()); m_List.SetItemText(i, 2, (CString)it->grooming_date.c_str()); m_List.SetItemText(i, 3, (CString)it->grooming_expense.c_str()); i++; } } else {