gongyuguanlixitong.rar_VC++ SQL _sql server_sql 数据库_公寓系统_数据库后台

// HouseInReg.cpp : implementation file // #include "stdafx.h" #include "house.h" #include "HouseInReg.h" #include "ADOConn.h" #include "HouseInXGDlg.h" #include <math.h> #ifdef _DEBUG #define new DEBUG_NEW #undef THIS_FILE static char THIS_FILE[] = __FILE__; #endif ///////////////////////////////////////////////////////////////////////////// // CHouseInReg dialog CHouseInReg::CHouseInReg(CWnd* pParent /*=NULL*/) : CDialog(CHouseInReg::IDD, pParent) { //{{AFX_DATA_INIT(CHouseInReg) m_strBedNum = _T(""); m_strCnum = _T(""); m_strDH = _T(""); m_strFnum = _T(""); m_strPhoNnm = _T(""); m_strYJ = _T(""); m_strClass = _T(""); m_strCollege = _T(""); m_strDepart = _T(""); m_strGrade = _T(""); m_strFJ = _T(""); m_strName = _T(""); m_num = _T(""); m_strSex = _T(""); m_strSpecial = _T(""); m_time = 0; //}}AFX_DATA_INIT m_iCount=-1; } void CHouseInReg::DoDataExchange(CDataExchange* pDX) { CDialog::DoDataExchange(pDX); //{{AFX_DATA_MAP(CHouseInReg) DDX_Control(pDX, IDC_SPECIAL, m_cSpecial); DDX_Control(pDX, IDC_HOUSEIN_FNUM, m_cFnum); DDX_Control(pDX, IDC_HOUSEIN_DH, m_cDH); DDX_Control(pDX, IDC_HOUSEIN_CS, m_cCnum); DDX_Control(pDX, IDC_HOUSEIN_CHNUM, m_cBedNum); DDX_Control(pDX, IDC_LIST2, m_list); DDX_CBString(pDX, IDC_HOUSEIN_CHNUM, m_strBedNum); DDX_CBString(pDX, IDC_HOUSEIN_CS, m_strCnum); DDX_CBString(pDX, IDC_HOUSEIN_DH, m_strDH); DDX_CBString(pDX, IDC_HOUSEIN_FNUM, m_strFnum); DDX_CBString(pDX, IDC_SPECIAL, m_strSpecial); DDX_Text(pDX, IDC_HOUSEIN_PH, m_strPhoNnm); DDX_Text(pDX, IDC_HOUSEIN_YJ, m_strYJ); DDX_Text(pDX, IDE_CLASS, m_strClass); DDX_Text(pDX, IDE_COLLEGE, m_strCollege); DDX_Text(pDX, IDE_DEPART, m_strDepart); DDX_Text(pDX, IDE_GREAT, m_strGrade); DDX_Text(pDX, IDE_HOUSEIN_FJ, m_strFJ); DDX_Text(pDX, IDE_NAME, m_strName); DDX_Text(pDX, IDE_NUM, m_num); DDX_Text(pDX, IDE_SEX, m_strSex); DDX_DateTimeCtrl(pDX, IDC_DATETIMEPICKER1, m_time); //}}AFX_DATA_MAP } BEGIN_MESSAGE_MAP(CHouseInReg, CDialog) //{{AFX_MSG_MAP(CHouseInReg) ON_CBN_EDITUPDATE(IDC_HOUSEIN_DH, OnEditupdateHouseinDh) ON_CBN_SELENDCANCEL(IDC_HOUSEIN_DH, OnSelendcancelHouseinDh) ON_CBN_SELENDCANCEL(IDC_HOUSEIN_CS, OnSelendcancelHouseinCs) ON_CBN_SELENDCANCEL(IDC_HOUSEIN_FNUM, OnSelendcancelHouseinFnum) ON_CBN_SELENDCANCEL(IDC_HOUSEIN_CHNUM, OnSelendcancelHouseinChnum) ON_CBN_SELENDCANCEL(IDC_SPECIAL, OnSelendcancelSpecial) ON_EN_KILLFOCUS(IDE_NUM, OnKillfocusNum) ON_BN_CLICKED(IDB_HOUSEIN_ENTER, OnHouseinEnter) ON_BN_CLICKED(IDB_HOUSEIN_XG, OnHouseInXg) ON_BN_CLICKED(IDB_HOUSEIN_DEL, OnHouseinDel) ON_EN_UPDATE(IDE_NUM, OnUpdateNum) ON_BN_CLICKED(IDB_HOUSEIN_SELECT, OnHouseinSelect) ON_BN_CLICKED(IDB_HOUSEIN_REFRESH, OnHouseinRefresh) ON_NOTIFY(NM_KILLFOCUS, IDC_DATETIMEPICKER1, OnKillfocusDatetimepicker1) ON_CBN_SELENDOK(IDC_SPECIAL, OnSelendokSpecial) //}}AFX_MSG_MAP END_MESSAGE_MAP() ///////////////////////////////////////////////////////////////////////////// // CHouseInReg message handlers BOOL CHouseInReg::OnInitDialog() { CDialog::OnInitDialog(); // TODO: Add extra initialization here m_time=CTime::GetCurrentTime(); if(-1==m_iCount) { m_iCount+=1; // TODO: Add extra initialization here m_list.SetTextColor(RGB(0,0,0)); m_list.SetTextBkColor(RGB(245,240,205)); m_list.InsertColumn(0,"学号"); m_list.InsertColumn(1,"姓名"); m_list.InsertColumn(2,"性别"); m_list.InsertColumn(3,"学院"); m_list.InsertColumn(4,"系别"); m_list.InsertColumn(5,"专业"); m_list.InsertColumn(6,"年级"); m_list.InsertColumn(7,"班级"); m_list.InsertColumn(8,"栋号"); m_list.InsertColumn(9,"层数"); m_list.InsertColumn(10,"房号"); m_list.InsertColumn(11,"床号"); m_list.InsertColumn(12,"房价"); m_list.InsertColumn(13,"押金"); m_list.InsertColumn(14,"电话"); m_list.InsertColumn(15,"登记日期"); m_list.SetExtendedStyle(LVS_EX_FULLROWSELECT); RECT rect; m_list.GetWindowRect(&rect); int wid = rect.right - rect.left; m_list.SetColumnWidth(0,wid*2/16); m_list.SetColumnWidth(1,wid*2/16); m_list.SetColumnWidth(2,wid*1/16); m_list.SetColumnWidth(3,wid*2/16); m_list.SetColumnWidth(4,wid*2/16); m_list.SetColumnWidth(5,wid*2/16); m_list.SetColumnWidth(6,wid*1/16); m_list.SetColumnWidth(7,wid*2/16); m_list.SetColumnWidth(8,wid*1/16); m_list.SetColumnWidth(9,wid*1/16); m_list.SetColumnWidth(10,wid*1/16); m_list.SetColumnWidth(11,wid*1/16); m_list.SetColumnWidth(12,wid*1/16); m_list.SetColumnWidth(13,wid*1/16); m_list.SetColumnWidth(14,wid*1/6); m_list.SetColumnWidth(15,wid*2/16); } m_list.DeleteAllItems(); m_list.SetRedraw(FALSE); m_list.SetRedraw(TRUE); //连接数据库 CADOConn m_AdoConn; if(m_AdoConn.OnInitADOConn()); _bstr_t vSQL; vSQL = "SELECT * FROM 住宿表 "; _RecordsetPtr m_pRecordset; m_pRecordset = m_AdoConn.GetRecordSet(vSQL); while (!m_pRecordset->adoEOF) { m_list.InsertItem(0, (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("学号")); m_list.SetItemText(0, 1, (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("姓名")); m_list.SetItemText(0, 2, (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("性别")); m_list.SetItemText(0, 3, (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("学院")); m_list.SetItemText(0, 4, (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("系别")); m_list.SetItemText(0, 5, (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("专业")); m_list.SetItemText(0, 6, (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("年级")); m_list.SetItemText(0, 7, (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("班级")); m_list.SetItemText(0, 8, (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("栋号")); m_list.SetItemText(0, 9, (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("层数")); m_list.SetItemText(0, 10, (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("房号")); m_list.SetItemText(0, 11, (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("床号")); m_list.SetItemText(0, 12, (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("房价")); m_list.SetItemText(0, 13, (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("押金")); m_list.SetItemText(0, 14, (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("电话")); m_list.SetItemText(0, 15, (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("登记日期")); m_pRecordset->MoveNext(); } //////////////////////////////////////////////////////////////////////////// vSQL = "SELECT 专业 FROM 院系专表 "; m_pRecordset = m_AdoConn.GetRecordSet(vSQL); m_cSpecial.ResetContent( ); while (!m_pRecordset->adoEOF) { m_cSpecial.AddString((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("专业")); m_pRecordset->MoveNext(); } /////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////////// vSQL = "SELECT 栋号 FROM 公寓表 "; m_pRecordset = m_AdoConn.GetRecordSet(vSQL); m_cDH.ResetContent( ); while (!m_pRecordset->adoEOF) { m_cDH.AddString((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("栋号")); m_pRecordset->MoveNext(); } m_AdoConn.ExitConnect(); //////////////////////////////////////////////////////////////////////////////// UpdateData(FALSE); return TRUE; // return TRUE unless you set the focus to a control // EXCEPTION: OCX Property Pages should return FALSE } void CHouseInReg::OnEditupdateHouseinDh() { // TODO: Add your control notification handler code here m_cCnum.ResetContent( ); int index; CString str; index=m_cDH.GetCurSel(); if(-1!=index) { m_cDH.GetLBText(index,str); CADOConn m_AdoConn; if(m_AdoConn.OnInitADOConn()); //设置SELECT语句 _bstr_t vSQL; vSQL = "SELECT DISTINCT 层数 FROM 房间表 where 栋号 ='" + str + "' "; //执行SELETE语句 _RecordsetPtr m_pRecordset; m_pRecordset = m_AdoConn.GetRecordSet(vSQL); while (!m_pRecordset->adoEOF) { m_cCnum.AddString((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("�