void CBook::OnBnClickedBookBook() { // TODO: 在此添加控件通知处理程序代码 char in[10000]; CString note, num; string which; if (info.user == 'c') GetDlgItemText(IDC_BOOK_NUM, num); else num = "1"; if (num == "") { MessageBox(L"还未填写需要机票数", L"ERROR!", MB_OK | MB_ICONWARNING); return; } if (num > m_list.GetItemText(row, tickets - 1)) { MessageBox(L"超出能预定的张数", L"ERROR!", MB_OK | MB_ICONWARNING); return; } if (tickets == 4) which = "Business"; else which = "Normal"; GetDlgItemText(IDC_BOOK_SHOW, note); if (MessageBox(L"即将预定 " + num + L"枚 " + note, L"Option", MB_OKCANCEL | MB_ICONWARNING) == IDCANCEL) return; ClientSocket *client = new ClientSocket; Deal *deal = new Deal; string str; CTime now = CTime::GetCurrentTime(); DWORD dwNum = WideCharToMultiByte(CP_OEMCP, NULL, note, -1, NULL, NULL, 0, NULL); char *infor = new char[dwNum]; WideCharToMultiByte(CP_OEMCP, NULL, note, -1, infor, dwNum, 0, NULL); dwNum = WideCharToMultiByte(CP_OEMCP, NULL, num, -1, NULL, NULL, 0, NULL); char *n = new char[dwNum]; WideCharToMultiByte(CP_OEMCP, NULL, num, -1, n, dwNum, 0, NULL); dwNum = WideCharToMultiByte(CP_OEMCP, NULL, m_list.GetItemText(row, 1), -1, NULL, NULL, 0, NULL); char *tm = new char[dwNum]; WideCharToMultiByte(CP_OEMCP, NULL, m_list.GetItemText(row, 1), -1, tm, dwNum, 0, NULL); str = tm; //int year, mon, day, hour, min, sec; //year = strtol(str.substr(0, 4).c_str(), NULL, 10); CTime setoff(strtol(str.substr(0, 4).c_str(), NULL, 10), strtol(str.substr(5, 2).c_str(), NULL, 10) + 1, strtol(str.substr(8, 2).c_str(), NULL, 10), 0, 0, 0); CTimeSpan span = setoff - now; str = infor; if (info.user != 'c') sprintf(in, "1;s;select Pos from GiveUp where Num = '%s';", str.substr(0, 3).c_str()); else sprintf(in, "2;c;%s;u;update RealNum set %s = %s - %d where Num = '%s';", str.substr(0, 3).c_str(), which.c_str(), which.c_str(), atoi(n), str.substr(0, 3).c_str()); str = in; try { client->init(); client->Connect(); client->Send(deal->RepaceSpace(str)); str = client->Recv(); client->closeclient(); } catch (SocketFail e) { delete deal; delete client; MessageBox(L"网络连接错误,预定失败", L"ERROR!", MB_OK | MB_ICONWARNING); return; } if (str == "Fail") { delete deal; delete client; MessageBox(L"预定失败", L"ERROR!", MB_OK | MB_ICONWARNING); return; } span.GetDays(); if (str != "") {//表明有,已被退回的位置 int pos; if ((pos = str.find("|")) == str.npos) pos = str.find(";"); string Num(infor, 3); sprintf(in, "2;d;delete from GiveUp where Num = '%s' and Pos = '%s';u;update RealNum set %s = %s + 1 where Num = '%s';", Num.c_str(), str.substr(0, pos).c_str(), which.c_str(), which.c_str(), Num.c_str()); str = in; } else { str = infor; sprintf(in, "3;b;%s|%.2d;i;insert into Tickets values('&r', '%s', 0, %s);u;update RealNum set %s = %s + 1 where Num = '%s';", str.substr(0, 3).c_str(), (int)span.GetDays(), info.id.c_str(), str.substr(str.find("¥") + 2).c_str(), which.c_str(), which.c_str(), str.substr(0, 3).c_str()); str = in; } try { client->init(); client->Connect(); client->Send(deal->RepaceSpace(str)); str = client->Recv(); client->closeclient(); } catch (SocketFail e) { delete deal; delete client; MessageBox(L"网络连接错误,预定失败", L"ERROR!", MB_OK | MB_ICONWARNING); return; } if (str.substr(str.find("|") + 1, 2) == "OK") { CString t; t = str.substr(0, 18).c_str(); MessageBox(L"票号为 " + t, L"预定成功\n票号已复制到剪贴板", MB_OK | MB_ICONASTERISK); if (OpenClipboard()) { HGLOBAL clipbuffer; char *buffer; EmptyClipboard(); clipbuffer = GlobalAlloc(GMEM_DDESHARE, str.substr(0, 18).size() + 1); buffer = (char*)GlobalLock(clipbuffer); strcpy(buffer, LPCSTR(str.substr(0, 18).c_str())); GlobalUnlock(clipbuffer); SetClipboardData(CF_TEXT, clipbuffer); CloseClipboard(); } } else MessageBox(L"预定失败", L"ERROR!", MB_OK | MB_ICONWARNING); delete deal; delete client; }
BOOL CBook::OnInitDialog() { CDialogEx::OnInitDialog(); // TODO: 在此添加额外的初始化 CRect rc; m_list.GetClientRect(&rc); m_list.SetExtendedStyle(m_list.GetExtendedStyle() | LVS_EX_FULLROWSELECT | LVS_EX_GRIDLINES); m_list.InsertColumn(0, _T("航班号"), LVCFMT_CENTER, 150); m_list.InsertColumn(1, _T("出发时间"), LVCFMT_CENTER, 240); m_list.InsertColumn(2, _T("预计到达时间"), LVCFMT_CENTER, 240); m_list.InsertColumn(3, _T("商务票"), LVCFMT_CENTER, 120); m_list.InsertColumn(4, _T("价格"), LVCFMT_CENTER, 100); m_list.InsertColumn(5, _T("经济票"), LVCFMT_CENTER, 120); m_list.InsertColumn(6, _T("价格"), LVCFMT_CENTER, 110); CRect rect; GetWindowRect(&rect); listRect.AddTail(rect); //对话框的区域 CWnd* pWnd = GetWindow(GW_CHILD); //获取子窗体 while (pWnd) { pWnd->GetWindowRect(rect); //子窗体的区域 listRect.AddTail(rect); //CList<CRect,CRect> m_listRect成员变量 pWnd = pWnd->GetNextWindow(); //取下一个子窗体 } SYSTEMTIME st; CString str; GetLocalTime(&st); str.Format(L"%4d", st.wYear); m_year.AddString(str); m_year.SetCurSel(0); if (st.wMonth > 10) { str.Format(L"%4d", st.wYear + 1); m_year.AddString(str); } m_mon.SetCurSel(st.wMonth - 1); m_day.SetCurSel(st.wDay - 1); string area("1;s;select AreaName from Area;"); int npos; ClientSocket *client = new ClientSocket; Deal *deal = new Deal; try { client->init(); client->Connect(); client->Send(deal->RepaceSpace(area)); area = client->Recv(); client->closeclient(); while ((npos = area.find(":")) != area.npos) { str = area.substr(0, area.find(";") + 1).c_str(); area.erase(0, area.find(";") + 1); m_setoff.AddString(str); m_arrive.AddString(str); } } catch (SocketFail e) { //MessageBoxA(m_hWnd, "网络连接错误", "Error!", MB_OK | MB_ICONWARNING); } if (info.user == 'c') { GetDlgItem(IDC_BOOK_STA)->ShowWindow(SW_SHOW); GetDlgItem(IDC_BOOK_NUM)->ShowWindow(SW_SHOW); } return TRUE; // return TRUE unless you set the focus to a control // 异常: OCX 属性页应返回 FALSE }
void CBook::OnBnClickedBookFind() { // TODO: 在此添加控件通知处理程序代码 m_list.SetRedraw(FALSE); m_list.DeleteAllItems(); ClientSocket *client = new ClientSocket; Deal *deal = new Deal; int pos, npos, i = 0, line = 0; CString cstr, time, year, mon, day; string str("1;s;select Num, SetOff, Arrive, Business, BusPrice, Normal, Price from Flight_view where Cancel = false and SetOff > "); GetDlgItemText(IDC_BOOK_SET, m_set); DWORD dwNum = WideCharToMultiByte(CP_OEMCP, NULL, m_set, -1, NULL, NULL, 0, NULL); char *set = new char[dwNum]; WideCharToMultiByte(CP_OEMCP, NULL, m_set, -1, set, dwNum, 0, NULL); GetDlgItemText(IDC_BOOK_OFF, m_off); dwNum = WideCharToMultiByte(CP_OEMCP, NULL, m_off, -1, NULL, NULL, 0, NULL); char *off = new char[dwNum]; WideCharToMultiByte(CP_OEMCP, NULL, m_off, -1, off, dwNum, 0, NULL); GetDlgItemText(IDC_BOOK_YEAR, year); GetDlgItemText(IDC_BOOK_MON, mon); GetDlgItemText(IDC_BOOK_DAY, day); time = year + L"-" + mon + L"-" + day; dwNum = WideCharToMultiByte(CP_OEMCP, NULL, time, -1, NULL, NULL, 0, NULL); char *setoff = new char[dwNum]; WideCharToMultiByte(CP_OEMCP, NULL, time, -1, setoff, dwNum, 0, NULL); str += setoff; str += " and AreaName = '"; str += set; str += "' and Expr1 = '"; str += off; str += "';"; try { client->init(); client->Connect(); client->Send(deal->RepaceSpace(str)); str = client->Recv(); client->closeclient(); if (!str.compare("Fail") || str == "") MessageBoxA(m_hWnd, "没有任何记录", "Option", MB_OK | MB_ICONWARNING); while ((npos = str.find(";")) != str.npos) { i = 1; cstr = str.substr(0, str.find("|")).c_str(); str.erase(0, str.find("|") + 1); m_list.InsertItem(line, cstr); while ((pos = str.find("|")) < npos && pos != str.npos) { cstr = str.substr(0, str.find("|")).c_str(); str.erase(0, str.find("|") + 1); m_list.SetItemText(line, i, cstr); i++; npos = str.find(";"); } cstr = str.substr(0, str.find(";")).c_str(); str.erase(0, str.find(";") + 1); m_list.SetItemText(line, i, cstr); line++; } } catch (SocketFail e) { MessageBoxA(m_hWnd, "网络连接错误", "Error!", MB_OK | MB_ICONWARNING); } m_list.SetRedraw(TRUE); delete off; delete set; delete deal; delete client; }