// Booking2.cpp : implementation file // #include "stdafx.h" #include "ylgl.h" #include "Booking2.h" //#include "InputMemberno.h" #include "SelMemberType.h" #include "AddMember.h" #include "InputCard2Dlg.h" #include "Login2.h" #ifdef _DEBUG #define new DEBUG_NEW #undef THIS_FILE static char THIS_FILE[] = __FILE__; #endif ///////////////////////////////////////////////////////////////////////////// // Booking2 dialog time1 Booking2::Booking2(CWnd* pParent /*=NULL*/) : CDialog(Booking2::IDD, pParent) { m_bModify = 0; m_bSave = 0; //}}AFX_DATA_INIT } void Booking2::DoDataExchange(CDataExchange* pDX) { CDialog::DoDataExchange(pDX); //{{AFX_DATA_MAP(Booking2) // NOTE: the ClassWizard will add DDX and DDV calls here //}}AFX_DATA_MAP } BEGIN_MESSAGE_MAP(Booking2, CDialog) ON_BN_CLICKED(IDC_BUTinfo1, OnBUTinfo1) ON_BN_CLICKED(IDC_BUTinfo2, OnBUTinfo2) ON_BN_CLICKED(IDC_BUTinfo3, OnBUTinfo3) ON_BN_CLICKED(IDC_BUTclose, OnBUTclose) ON_WM_CTLCOLOR() ON_BN_CLICKED(IDC_BUTinfo4, OnBUTinfo4) ON_BN_CLICKED(IDC_BUTsave, OnBUTsave) ON_BN_CLICKED(IDC_BUTnew, OnBUTnew) ON_BN_CLICKED(IDC_BUTprint, OnBUTprint) ON_BN_CLICKED(IDC_BUTimport, OnBUTimport) //}}AFX_MSG_MAP END_MESSAGE_MAP() ///////////////////////////////////////////////////////////////////////////// // Booking2 message handlers void Booking2::OnBUTclose() { // TODO: Add your control notification handler code here if (m_bSave) CDialog::OnOK(); else CDialog::OnCancel(); } void Booking2::OnOK() { } void Booking2::OnCancel() { CDialog::OnCancel(); } HBRUSH Booking2::OnCtlColor(CDC* pDC, CWnd* pWnd, UINT nCtlColor) { HBRUSH hbr = CDialog::OnCtlColor(pDC, pWnd, nCtlColor); // TODO: Change any attributes of the DC here if (nCtlColor == CTLCOLOR_STATIC && pWnd->GetDlgCtrlID() == IDC_STATIC2) { pDC->SetBkMode(TRANSPARENT); //设置字体背景为透明 return (HBRUSH)::GetStockObject(WHITE_BRUSH); // 设置背景色 } // TODO: Return a different brush if the default is not desired return hbr; } extern BOOL CALLBACK EnumChildProc2(HWND hwnd, LPARAM lParam); BOOL Booking2::OnInitDialog() { CDialog::OnInitDialog(); // TODO: Add extra initialization here if ( m_bModify == 0 ) { // Jeff 2015-05-19 开单时隐藏按钮; GetDlgItem(IDC_BUTinfo4)->ShowWindow(SW_HIDE); } if (m_bModify == 1) { SetWindowText("预约单-修改"); GetDlgItem(IDC_BUTnew)->ShowWindow(0); GetDlgItem(IDC_BUTimport)->ShowWindow(0); GetDlgItem(IDC_BUTprint)->EnableWindow(1); #if JEFF_DELETE_ON // 2015.03.24 使用店长密码,不需要这块禁用按钮; GetDlgItem(IDC_BUTsave)->EnableWindow(IsHasRights2new(1)); #endif // 如果拍照状态OK,禁用拍照时间edit和拍照状态commbox. } else if (m_bModify == 2) { SetWindowText("历史预约单"); GetDlgItem(IDC_BUTnew)->ShowWindow(0); GetDlgItem(IDC_BUTimport)->ShowWindow(0); GetDlgItem(IDC_BUTprint)->EnableWindow(1); GetDlgItem(IDC_BUTsave)->EnableWindow(0); } CRect rc2; GetWindowRect(rc2); int dty = g_screenhei - 768; if (0)//dty>0) { g_rc.bottom -= dty; MoveWindow(g_rc); g_WidthScale2 = (float)g_rc.Width() / (float)rc2.Width(); // new/Old g_HeightScale2 = (float)g_rc.Height() / (float)rc2.Height(); EnumChildWindows(m_hWnd, (WNDENUMPROC)EnumChildProc2, 0); g_rc.bottom += dty; MoveWindow(g_rc); } else { MoveWindow(g_rc); g_WidthScale2 = (float)g_rc.Width() / (float)rc2.Width(); // new/Old g_HeightScale2 = (float)g_rc.Height() / (float)rc2.Height(); EnumChildWindows(m_hWnd, (WNDENUMPROC)EnumChildProc2, 0); } CRect rc; GetDlgItem(IDC_STATIC1)->GetWindowRect(rc); ScreenToClient(rc); GetDlgItem(IDC_STATIC2)->GetWindowRect(rc2); ScreenToClient(rc2); rc2.left = 0; rc2.top = 0; rc2.bottom = rc.top - 2; GetDlgItem(IDC_STATIC2)->MoveWindow(rc2); GetDlgItem(IDC_STATIC3)->MoveWindow(rc2); rc = rc2; rc.top = rc.bottom; rc.bottom += 1; GetDlgItem(IDC_STATIC4)->MoveWindow(rc); GetDlgItem(IDC_STATIC1)->GetWindowRect(rc2); ScreenToClient(rc2); rc.top = rc2.bottom; rc.bottom = rc.top + 1; GetDlgItem(IDC_STATIC5)->MoveWindow(rc); OnBUTinfo1(); return TRUE; // return TRUE unless you set the focus to a control // EXCEPTION: OCX Property Pages should return FALSE } // Jeff 按钮:订单资料(第一个选项页,读取所有数据) void Booking2::OnBUTinfo1()//订单资料按钮; { // TODO: Add your control notification handler code here if (m_page1.GetSafeHwnd())m_page1.ShowWindow(SW_HIDE); if (m_page2.GetSafeHwnd())m_page2.ShowWindow(SW_HIDE); if (m_page3.GetSafeHwnd())m_page3.ShowWindow(SW_HIDE); if (m_page4.GetSafeHwnd())m_page4.ShowWindow(SW_HIDE); if (m_page1.GetSafeHwnd() == NULL) { CRect rc; GetDlgItem(IDC_STATIC1)->GetWindowRect(rc); ScreenToClient(rc); m_page1.m_rc = m_page2.m_rc = m_page3.m_rc = m_page4.m_rc = rc; g_sendhead.bsql = 0; g_sendhead.code[0] = 6; // 套系表taoxi; g_sendhead.code[1] = 7; // 套系商品1taoxishangpin1; g_sendhead.code[2] = 10; // 套系商品2taoxishangpin2; g_sendhead.code[3] = 4; // 商品shangpin; g_sendhead.code[4] = 82; // 冲印面积area; g_sendhead.code[5] = 68; // 人员管理membermanage; g_sendhead.code[6] = 127; // membercard2; g_sendhead.code[7] = 130; // membermanageblue; g_sendhead.code[8] = 131; // membercard2blue; g_sendhead.code[9] = 77; // taoxifg; g_sendhead.tabcount = 10; // 总共10个表; g_pMainWnd->ProcessChatMessageRequest2("show<>'隐藏'"); DataToArray( &m_page1.m_List1array, \ &m_page1.m_List2array, \ &m_page1.m_List3array, \ &m_page1.m_sparray, \ &m_page2.m_areaarray, \ &m_page3.m_List1array, \ &m_page3.m_List2array, \ &m_page3.m_List3array, \ &m_page3.m_List4array, \ &m_page3.m_List5array); if (m_bModify) // 预约单 - 修改; { CString id = m_id; g_sendhead.bsql = 0; CString filter = "id='" + id + "';id='" + id + "' and kind<>'5';id='" + id + "';id='" + id + "'"; g_sendhead.code[0] = 11; // dindan; g_sendhead.code[1] = 56; // dindansp; g_sendhead.code[2] = 150; // dindanjd; #ifdef CHILD_VERSION g_sendhead.code[3] = 94; // client; #else g_sendhead.code[3]=52; // client; #endif g_sendhead.tabcount = 4; // 共4张表; g_bNoConnDlg = 1; // 设置连接服务器状态为:需要 g_pMainWnd->ProcessChatMessageRequest2(filter); g_bNoConnDlg = 0; if (g_bSendOK == 0) { CDialog::OnCancel(); return; } CArrayClientArray; DataToArray(&g_List1array, &m_page1.m_Bakarray, &m_page1.m_List1arrayM, &ClientArray); m_page2.m_name1 = g_List1array.ElementAt(0).ElementAt(4); m_page2.m_name2 = g_List1array.ElementAt(0).ElementAt(5); m_page1.m_id = m_id; m_page1.m_taoxiid = g_List1array.ElementAt(0).ElementAt(6); m_page1.m_taoxiname = g_List1array.ElementAt(0).ElementAt(7); m_page1.m_taoxijiage = g_List1array.ElementAt(0).ElementAt(8); // m_page1.m_zs = g_List1array.ElementAt (0).ElementAt (9); CString zs = g_List1array.ElementAt(0).ElementAt(9); int pos = zs.Find("\\"); if (pos != -1) { m_page1.m_zs = zs.Left(pos); m_page1.m_zs2 = zs.Right(zs.GetLength() - pos - 1); } else { m_page1.m_zs = zs; m_page1.m_zs2 = ""; } m_page1.m_growthtxselname = g_List1array.ElementAt(0).ElementAt(54); m_page4.m_time1 = g_List1array.ElementAt(0).ElementAt(10); m_page4.m_time2 = g_List1array.ElementAt(0).ElementAt(11); #if JEFF_TEST_ON // 将结婚日期换到m_page2中显示; #ifndef CHILD_VERSION m_page2.m_time3 = g_List1array.ElementAt(0).ElementAt(12); #endif #else m_page4.m_time3 = g_List1array.ElementAt(0).ElementAt(12); #endif m_page4.m_time4 = g_List1array.ElementAt(0).ElementAt(21); m_page4.m_time5 = g_List1array.ElementAt(0).ElementAt(22); m_page4.m_time6 = g_List1array.ElementAt(0).ElementAt(48); m_page4.m_time8 = g_List1array.ElementAt(0).ElementAt(72); m_page4.m_time9 = g_List1array.ElementAt(0).ElementAt(73); m_page4.m_time10 = g_List1array.ElementAt(0).ElementAt(74); m_page3.m_bm = g_List1array.ElementAt(0).ElementAt(13); m_page3.m_ren = g_List1array.ElementAt(0).ElementAt(14); m_page1.m_payed1 = g_List1array.ElementAt(0).ElementAt(16); m_page4.m_status1 = g_List1array.ElementAt(0).ElementAt(25); m_page3.m_clothescount = g_List1array.ElementAt(0).ElementAt(26); m_page3.m_clothescount2 = g_List1array.ElementAt(0).ElementAt(27); m_page3.m_outside = g_List1array.ElementAt(0).ElementAt(28); m_page3.m_outside2 = g_List1array.ElementAt(0).ElementAt(29); m_page3.m_style = g_List1array.ElementAt(0).ElementAt(30); m_page3.m_memberno = g_List1array.ElementAt(0).ElementAt(47); m_page4.m_status2 = g_List1array.ElementAt(0).ElementAt(32); m_page4.m_status3 = g_List1array.ElementAt(0).ElementAt(33); m_page4.m_waiter1 = g_List1array.ElementAt(0).ElementAt(34); m_page4.m_waiter2 = g_List1array.ElementAt(0).ElementAt(35); m_page4.m_waiter3 = g_List1array.ElementAt(0).ElementAt(36); m_page4.m_waiter4 = g_List1array.ElementAt(0).ElementAt(37); m_page1.m_bz = g_List1array.ElementAt(0).ElementAt(38); m_page4.m_waiter5 = g_List1array.ElementAt(0).ElementAt(42); m_page4.m_waiter7 = g_List1array.ElementAt(0).ElementAt(43); m_page4.m_waiter8 = g_List1array.ElementAt(0).ElementAt(76); // Jeff 看版人 m_page4.m_status4 = g_List1array.ElementAt(0).ElementAt(44); m_page4.m_status5 = g_List1array.ElementAt(0).ElementAt(45); m_page4.m_status6 = g_List1array.ElementAt(0).ElementAt(46); m_page4.m_status8 = g_List1array.ElementAt(0).ElementAt(55); // Jeff 看版状态 m_page1.m_txtype = g_List1array.ElementAt(0).ElementAt(52); #ifdef LKAY_VERSION m_page1.m_dindantype = g_List1array.ElementAt (0).ElementAt (63); m_page1.m_contractno = g_List1array.ElementAt (0).ElementAt (64); m_page1.m_contractno2 = g_List1array.ElementAt (0).ElementAt (65); m_page3.m_cfno = g_List1array.ElementAt (0).ElementAt (66); m_page3.m_from = g_List1array.ElementAt (0).ElementAt (67); m_page3.m_reason = g_List1array.ElementAt (0).ElementAt (68); m_page4.m_time7 = g_List1array.ElementAt (0).ElementAt (69); m_page4.m_waiter12 = g_List1array.ElementAt (0).ElementAt (50); m_page4.m_waiter13 = g_List1array.ElementAt (0).ElementAt (70); m_page4.m_waiter14 = g_List1array.ElementAt (0).ElementAt (71); #else m_page1.m_from = g_List1array.ElementAt(0).ElementAt(67); #endif ///////////////////////////////// #ifdef CHILD_VERSION m_page2.m_name1 = ClientArray.ElementAt(0).ElementAt(1); m_page2.m_name2 = ClientArray.ElementAt(0).ElementAt(2); m_page2.m_phone1 = ClientArray.ElementAt(0).ElementAt(3); m_page2.m_phone2 = ClientArray.ElementAt(0).ElementAt(4); m_page2.m_qq1 = ClientArray.ElementAt(0).ElementAt(5); m_page2.m_addr1 = ClientArray.ElementAt(0).ElementAt(6); m_page2.m_birthday1 = ClientArray.ElementAt(0).ElementAt(7); m_page2.m_area = ClientArray.ElementAt(0).ElementAt(8); m_page2.m_sex = ClientArray.ElementAt(0).ElementAt(9); m_page2.m_zodiac = ClientArray.ElementAt(0).ElementAt(10); m_page2.m_check1 = atoi(ClientArray.ElementAt(0).ElementAt(11)); #ifdef LKAY_VERSION if(IsHasRights2new(1)==0) { m_page2.m_addr1="***"; m_page2.m_phone1="***"; m_page2.m_phone2="***"; m_page2.m_qq1="***"; } #else #if JEFF_TEST_OFF // 当修改预约单时,没有权限的用户登陆会显示成*号; if(IsHasRights2new(1)==0 && IsHasRights2new(31)==0) { m_page2.m_addr1="***"; m_page2.m_phone1="***"; m_page2.m_phone2="***"; m_page2.m_qq1="***"; } #endif #endif /////////////////////////////////// #else m_page2.m_name1=ClientArray.ElementAt (0).ElementAt (1); m_page2.m_name2=ClientArray.ElementAt (0).ElementAt (2); m_page2.m_phone1=ClientArray.ElementAt (0).ElementAt (3); m_page2.m_phone2=ClientArray.ElementAt (0).ElementAt (4); m_page2.m_qq1=ClientArray.ElementAt (0).ElementAt (5); m_page2.m_qq2=ClientArray.ElementAt (0).ElementAt (6); m_page2.m_addr1=ClientArray.ElementAt (0).ElementAt (7); m_page2.m_addr2=ClientArray.ElementAt (0).ElementAt (8); m_page2.m_occupation1=ClientArray.ElementAt (0).ElementAt (9); m_page2.m_occupation2=ClientArray.ElementAt (0).ElementAt (10); m_page2.m_birthday1=ClientArray.ElementAt (0).ElementAt (11); m_page2.m_birthday2=ClientArray.ElementAt (0).ElementAt (12); m_page2.m_area=ClientArray.ElementAt (0).ElementAt (13); m_page2.m_area2=ClientArray.ElementAt (0).ElementAt (14); m_page2.m_check1=atoi(ClientArray.ElementAt (0).ElementAt (15)); m_page2.m_check2=atoi(ClientArray.ElementAt (0).ElementAt (16)); #if JEFF_TEST_ON // 将m_page4的结婚日期复选框改由m_page2显示; m_page2.m_check3=atoi(ClientArray.ElementAt (0).ElementAt (17)); #else m_page4.m_check3=atoi(ClientArray.ElementAt (0).ElementAt (17)); #endif #if JEFF_TEST_OFF // 当修改预约单时,没有权限的用户登陆会显示成*号; if(IsHasRights2new(1)==0 && IsHasRights2new(31)==0) { m_page2.m_addr1="***"; m_page2.m_phone1="***"; m_page2.m_phone2="***"; m_page2.m_qq1="***"; } #endif #endif } m_page1.Create(BookingPage1::IDD, this); #ifdef CHILD_VERSION m_page2.Create(IDD_DLGBookingPage22, this); #else m_page2.Create (IDD_DLGBookingPage2, this); #endif m_page3.Create(IDD_DLGBookingPage3, this); m_page4.Create(IDD_DLGBookingPage4, this); } #if JEFF_TEST_ON // 当修改预约单时,没有权限的用户登陆会显示成*号; if (m_bModify) // 预约单 - 修改; { if (IsHasRights2new(1) == 0 && IsHasRights2new(31) == 0) m_page2.SetPasswordChar(); } #endif m_page1.ShowWindow(SW_SHOW); CString str; #ifdef CHILD_VERSION str = "\r\n\r\n 1. 预约单录入-订单资料\r\n 2. 请在下方录入订单资料后点客人资料进一步录入,打*号的内容是必填项目\r\n 3. 宝宝成长套系录入:可在套系类别中添加一个'成长套系', 然后选择套系类别为成长套系"; #else str="\r\n\r\n 1. 预约单录入-订单资料\r\n 2. 请在下方录入订单资料后点客人资料进一步录入,打*号的内容是必填项目\r\n "; #endif GetDlgItem(IDC_STATIC2)->SetWindowText(str); } // Jeff 按钮:客人资料 void Booking2::OnBUTinfo2() //客人资料按钮; { // TODO: Add your control notification handler code here if (m_page1.GetSafeHwnd())m_page1.ShowWindow(SW_HIDE); if (m_page2.GetSafeHwnd())m_page2.ShowWindow(SW_HIDE); if (m_page3.GetSafeHwnd())m_page3.ShowWindow(SW_HIDE); if (m_page4.GetSafeHwnd())m_page4.ShowWindow(SW_HIDE); m_page2.ShowWindow(SW_SHOW); CString str; str = "\r\n\r\n 1. 预约单录入-客人资料\r\n 2. 请在下方录入客人资料后点其它资料进一步录入,打*号的内容是必填项目"; GetDlgItem(IDC_STATIC2)->SetWindowText(str); } // Jeff 按钮:其它资料; void Booking2::OnBUTinfo3() //其他资料按钮; { // TODO: Add your control notification handler code here if (m_page1.GetSafeHwnd())m_page1.ShowWindow(SW_HIDE); if (m_page2.GetSafeHwnd())m_page2.ShowWindow(SW_HIDE); if (m_page3.GetSafeHwnd())m_page3.ShowWindow(SW_HIDE); if (m_page4.GetSafeHwnd())m_page4.ShowWindow(SW_HIDE); #if JEFF_TEST_ON // 传参:顾客姓名,顾客手机号,顾客订单号,顾客订单套系价格; // 不区分儿童和婚纱版本,统一使用顾客1的姓名和手机号; m_page3.m_strCustomer = m_page2.m_name1; m_page3.m_strPhone = m_page2.m_phone1; m_page3.m_strOrderNum = m_page1.m_id; m_page3.m_strTaoxiJiaoge = m_page1.m_taoxijiage; #endif m_page3.ShowWindow(SW_SHOW); CString str; str = "\r\n\r\n 1. 预约单录入-其它资料\r\n 2. 请在下方录入其它资料后点日期安排进一步录入,打*号的内容是必填项目"; GetDlgItem(IDC_STATIC2)->SetWindowText(str); if (m_bModify == 0) m_page3.ShowMemberDlg(); } // Jeff 按钮:时间安排; void Booking2::OnBUTinfo4() //时间安排按钮; { // Jeff.add; if (m_bModify == 1) { SetDlgItemText(IDC_BUTinfo4, "流程查看"); } // TODO: Add your control notification handler code here if (m_page1.GetSafeHwnd())m_page1.ShowWindow(SW_HIDE); if (m_page2.GetSafeHwnd())m_page2.ShowWindow(SW_HIDE); if (m_page3.GetSafeHwnd())m_page3.ShowWindow(SW_HIDE); if (m_page4.GetSafeHwnd())m_page4.ShowWindow(SW_HIDE); m_page4.ShowWindow(SW_SHOW); CString str; str = "\r\n\r\n 1. 预约单录入-日期安排\r\n 2. 请在下方录入客人拍照日期,选片日期,选片人等信息后点保存订单"; GetDlgItem(IDC_STATIC2)->SetWindowText(str); } extern BOOL CovertDate(CString &date, CString &date2); // Jeff 按钮:保存订单; void Booking2::OnBUTsave() //保存订单 { m_bSave = 1; if (this->m_bModify) { OnBUTsave2(); return; } // TODO: Add your control notification handler code here if (!m_page1.CheckOK()) { AfxMessageBox("资料不全,打*号的项目必须填写!", MB_ICONINFORMATION); OnBUTinfo1(); return; } if (!m_page2.CheckOK()) { AfxMessageBox("资料不全,打*号的项目必须填写!", MB_ICONINFORMATION); OnBUTinfo2(); return; } if (!m_page3.CheckOK()) { AfxMessageBox("资料不全,打*号的项目必须填写!", MB_ICONINFORMATION); OnBUTinfo3(); return; } if (!m_page4.CheckOK()) { AfxMessageBox("资料不全,打*号的项目必须填写!", MB_ICONINFORMATION); OnBUTinfo4(); return; } CString id = m_page1.m_id; CString sql; if (atoi(g_cominfoarray.ElementAt(0).ElementAt(121))) { g_bNoConnDlg = 1; CString date = g_date; sql = "select count(*) as cot from dindan where id='" + id + "' "; g_sendhead.bsql = 1; g_pMainWnd->ProcessChatMessageRequest2(sql); g_bNoConnDlg = 0; if (g_bSendOK == 0)return; if (g_ncount) { AfxMessageBox("已有此单号的订单,请重新编写单号!", MB_ICONINFORMATION); OnBUTinfo1(); return; } } else { g_bNoConnDlg = 1; CString date = g_date; sql = "select count(*) as cot from dindan where id='" + id + "' "; g_sendhead.bsql = 1; g_pMainWnd->ProcessChatMessageRequest2(sql); g_bNoConnDlg = 0; if (g_bSendOK == 0)return; if (g_ncount) // Jeff 查询dindan表时返回的记录数:g_ncount; { g_bNoConnDlg = 1; CString date = g_date; date.Replace("-", ""); sql = "select max(id) as cot from dindan where id like '" + date + "%' "; g_sendhead.bsql = 1; g_pMainWnd->ProcessChatMessageRequest2(sql); g_bNoConnDlg = 0; if (g_bSendOK == 0)return; date.Replace("-", ""); id.Format("%s-%03d", date, g_ncount + 1); } } if (IsHasRights2(0) == 0) return; // TODO: Add your control notification handler code here CString m_taoxiid = m_page1.m_taoxiid; CString taoxiname = m_page1.m_taoxiname; CString m_growthtxselname = m_page1.m_growthtxselname; CString m_taoxijiage = m_page1.m_taoxijiage; CString m_payed1 = m_page1.m_payed1; // CString m_zs=m_page1.m_zs; CString m_zs = m_page1.m_zs + "\\" + m_page1.m_zs2; CString txtype = m_page1.m_txtype; CString m_bz = m_page1.m_bz; CString m_authorize = m_page1.m_authorize; BOOL m_bGrowthTX = m_page1.m_bGrowthTX; #ifdef LKAY_VERSION CString m_dindantype=m_page1.m_dindantype; CString m_contractno=m_page1.m_contractno; CString m_contractno2=m_page1.m_contractno2; CString m_cfno=m_page3.m_cfno; CString m_from=m_page3.m_from; CString m_reason=m_page3.m_reason; CString m_time7=m_page4.m_time7; CString m_waiter12=m_page4.m_waiter12; CString m_waiter13=m_page4.m_waiter13; CString m_waiter14=m_page4.m_waiter14; #else CString m_from = m_page1.m_from; #endif CString bm = m_page3.m_bm; CString ren = m_page3.m_ren; CString m_clothescount = m_page3.m_clothescount; CString m_clothescount2 = m_page3.m_clothescount2; CString m_outside = m_page3.m_outside; CString m_outside2 = m_page3.m_outside2; CString m_style = m_page3.m_style; CString strmoney = "0"; CString m_discount; if (atof(m_taoxijiage) > 0 && (m_page1.m_saleprice1 + m_page1.m_saleprice2) > 0) m_discount.Format("%0.2f", min(10.0, (atof(m_taoxijiage) * 10) / (m_page1.m_saleprice1 + m_page1.m_saleprice2))); else m_discount = "0"; #ifdef CHILD_VERSION CString m_name1 = m_page2.m_name1; CString m_name2 = m_page2.m_name2; CString m_phone1 = m_page2.m_phone1; CString m_phone2 = m_page2.m_phone2; CString m_qq1 = m_page2.m_qq1; CString m_addr1 = m_page2.m_addr1; CString m_birthday1 = m_page2.m_birthday1; CString m_area = m_page2.m_area; BOOL m_check1 = m_page2.m_check1; CString m_zodiac = m_page2.m_zodiac; CString m_sex = m_page2.m_sex; CString m_birthday2, m_qq2, m_addr2; #else CString m_name1=m_page2.m_name1; CString m_name2=m_page2.m_name2; CString m_phone1=m_page2.m_phone1; CString m_phone2=m_page2.m_phone2; CString m_qq1=m_page2.m_qq1; CString m_qq2=m_page2.m_qq2; CString m_addr1=m_page2.m_addr1; CString m_addr2=m_page2.m_addr2; CString m_occupation1=m_page2.m_occupation1; CString m_occupation2=m_page2.m_occupation2; CString m_birthday1=m_page2.m_birthday1; CString m_birthday2=m_page2.m_birthday2; CString m_area=m_page2.m_area; CString m_area2=m_page2.m_area2; BOOL m_check1=m_page2.m_check1; BOOL m_check2=m_page2.m_check2; #endif CString m_time1 = m_page4.m_time1; CString m_time2 = m_page4.m_time2; #if JEFF_TEST_ON // 结婚日期; #ifndef CHILD_VERSION CString m_time3 = m_page2.m_time3; #else CString m_time3 = _T(""); #endif #else CString m_time3 = m_page4.m_time3; #endif CString m_time4 = m_page4.m_time4; CString m_time5 = m_page4.m_time5; CString m_time6 = m_page4.m_time6; CString m_time8 = m_page4.m_time8; CString m_time9 = m_page4.m_time9; CString m_time10 = m_page4.m_time10; CString m_waiter1 = m_page4.m_waiter1; CString m_waiter2 = m_page4.m_waiter2; CString m_waiter3 = m_page4.m_waiter3; CString m_waiter4 = m_page4.m_waiter4; CString m_waiter5 = m_page4.m_waiter5; CString m_waiter7 = m_page4.m_waiter7; CString m_waiter8 = m_page4.m_waiter8; // Jeff 看版人waiter8 CString m_status1 = m_page4.m_status1; CString m_status2 = m_page4.m_status2; CString m_status3 = m_page4.m_status3; CString m_status4 = m_page4.m_status4; CString m_status5 = m_page4.m_status5; CString m_status6 = m_page4.m_status6; //CString m_status8=m_page4.m_status8; // Jeff 看版状态status8 #if JEFF_TEST_ON #ifndef CHILD_VERSION BOOL m_check3 = m_page2.m_check3; #else BOOL m_check3 = FALSE; #endif #else BOOL m_check3 = m_page4.m_check3; #endif CString str, str2; CString strRes1, strRes2; ChinesePinYin::GetFirstLetter(m_name1, strRes1); ChinesePinYin::GetFirstLetter(m_name2, strRes2); CString m_memberno = m_page3.m_memberno; CString m_membernotemp = m_memberno; if (m_page3.m_type)m_memberno.Empty(); if (txtype == "成长套系" && m_growthtxselname.IsEmpty() == 0) { taoxiname += "cztx"; } // Jeff add; CString strInputTime; strInputTime = CTime::GetCurrentTime().Format("%Y-%m-%d %H:%M:%S"); // end; #if 0 // Jeff 原版 sql.Format("insert into [dindan]([id],[growthtxselname],[money1],[name1],[name2],[taoxiid],[taoxiname],[taoxijiage],[taoxizs],[time1],[time2],[time3],[time4],[time5],[time6],[time8],[time9],[time10],[bm],[ren],[discount],[payed1],[status],[status2],[status3],[status4],[status5],[status6],[status7],[status8],[urgent],[bz],[pinyin1],[pinyin2],[clothescount],[clothescount2],[outside],[outside2],[style],[waiter1],[waiter2],[waiter3],[waiter4],[waiter5],[waiter6],[waiter7],[memberno],[txtype],[tichenren1],[tichenren2],[tichenren3],[tichenren4],[tichenren5],[phone1],[phone2],[authorize],[from]) values('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','未刻','未看','否','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','','','','','','%s','%s','%s','%s')", id,m_growthtxselname,strmoney,m_name1,m_name2,m_taoxiid,taoxiname,m_taoxijiage,m_zs,m_time1,m_time2,m_time3,m_time4,m_time5,m_time6,m_time8,m_time9,m_time10,bm,ren,m_discount,m_payed1,m_status1,m_status2,m_status3,m_status4,m_status5,m_status6,FilterBZ(m_bz),strRes1,strRes2, m_clothescount,m_clothescount2,m_outside,m_outside2,m_style,m_waiter1,m_waiter2,m_waiter3,m_waiter4,m_waiter5,g_user.name,m_waiter7,m_memberno,txtype,m_phone1,m_phone2,m_authorize,m_from ); #else// Jeff添加看设计人和看设计状态; #if 0// Jeff:原没有选片录入和录入时间; sql.Format("insert into [dindan]([id],[growthtxselname],[money1],[name1],[name2],[taoxiid],[taoxiname],[taoxijiage],[taoxizs],[time1],[time2],[time3],[time4],[time5],[time6],[time8],[time9],[time10],[bm],[ren],[discount],[payed1],[status],[status2],[status3],[status4],[status5],[status6],[status7],[status8],[urgent],[bz],[pinyin1],[pinyin2],[clothescount],[clothescount2],[outside],[outside2],[style],[waiter1],[waiter2],[waiter3],[waiter4],[waiter5],[waiter6],[waiter7],[waiter8],[memberno],[txtype],[tichenren1],[tichenren2],[tichenren3],[tichenren4],[tichenren5],[phone1],[phone2],[authorize],[from])values('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','未刻','未看','否','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','','','','','','%s','%s','%s','%s')", id,m_growthtxselname,strmoney,m_name1,m_name2,m_taoxiid,taoxiname, m_taoxijiage,m_zs,m_time1,m_time2,m_time3,m_time4,m_time5,m_time6,m_time8,m_time9,m_time10,bm,ren,m_discount,m_payed1,m_status1,m_status2,m_status3,m_status4,m_status5,m_status6,FilterBZ(m_bz),strRes1,strRes2, m_clothescount,m_clothescount2,m_outside,m_outside2,m_style,m_waiter1,m_waiter2,m_waiter3,m_waiter4,m_waiter5,g_user.name,m_waiter7,m_waiter8, m_memberno,txtype,m_phone1,m_phone2,m_authorize,m_from); #else sql.Format("insert into [dindan]([id],[growthtxselname],[money1],[name1],[name2],[taoxiid],[taoxiname],[taoxijiage],[taoxizs],[time1],[time2],[time3],[time4],[time5],[time6],[time8],[time9],[time10],[bm],[ren],[discount],[payed1],[status],[status2],[status3],[status4],[status5],[status6],[status7],[status8],[urgent],[bz],[pinyin1],[pinyin2],[clothescount],[clothescount2],[outside],[outside2],[style],[waiter1],[waiter2],[waiter3],[waiter4],[waiter5],[waiter6],[waiter7],[waiter8],[memberno],[txtype],[tichenren1],[tichenren2],[tichenren3],[tichenren4],[tichenren5],[phone1],[phone2],[authorize],[from],[xplrr],[xplrtime])values('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','未刻','未看','否','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','','','','','','%s','%s','%s','%s','%s','%s')", id, m_growthtxselname, strmoney, m_name1, m_name2, m_taoxiid, taoxiname, m_taoxijiage, m_zs, m_time1, m_time2, m_time3, m_time4, m_time5, m_time6, m_time8, m_time9, m_time10, bm, ren, m_discount, m_payed1, m_status1, m_status2, m_status3, m_status4, m_status5, m_status6, FilterBZ(m_bz), strRes1, strRes2, m_clothescount, m_clothescount2, m_outside, m_outside2, m_style, m_waiter1, m_waiter2, m_waiter3, m_waiter4, m_waiter5, g_user.name, m_waiter7, m_waiter8, m_memberno, txtype, m_phone1, m_phone2, m_authorize, m_from, g_user.name, CTime::GetCurrentTime().Format("%Y-%m-%d %H:%M:%S")); #endif #endif #ifdef LKAY_VERSION #if 0 // Jeff 原版 sql.Format ("insert into [dindan]([id],[growthtxselname],[money1],[name1],[name2],[taoxiid],[taoxiname],[taoxijiage],[taoxizs],[time1],[time2],[time3],[time4],[time5],[time6],[time8],[time9],[time10],[bm],[ren],[discount],[payed1],[status],[status2],[status3],[status4],[status5],[status6],[status7],[status8],[urgent],[bz],[pinyin1],[pinyin2],[clothescount],[clothescount2],[outside],[outside2],[style],[waiter1],[waiter2],[waiter3],[waiter4],[waiter5],[waiter6],[waiter7],[memberno],[txtype],[tichenren1],[tichenren2],[tichenren3],[tichenren4],[tichenren5],[phone1],[phone2],[dindantype],[contractno1],[contractno2],[cfno],[from],[reason],[time7],[waiter12],[waiter13],[waiter14],[authorize])values('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','未刻','未看','否','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','','','','','','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s')", id,m_growthtxselname,strmoney,m_name1,m_name2,m_taoxiid,taoxiname,m_taoxijiage,m_zs,m_time1, m_time2,m_time3,m_time4,m_time5,m_time6,m_time8,m_time9,m_time10,bm,ren,m_discount,m_payed1, m_status1,m_status2,m_status3,m_status4,m_status5,m_status6,FilterBZ(m_bz),strRes1,strRes2, m_clothescount,m_clothescount2,m_outside,m_outside2,m_style,m_waiter1,m_waiter2,m_waiter3,m_waiter4,m_waiter5, g_user.name,m_waiter7,m_memberno,txtype,m_phone1,m_phone2,m_dindantype,m_contractno,m_contractno2,m_cfno,m_from,m_reason,m_time7,m_waiter12,m_waiter13,m_waiter14,m_authorize); #else // Jeff添加看设计人和看设计状态; sql.Format ("insert into [dindan]([id],[growthtxselname],[money1],[name1],[name2],[taoxiid],[taoxiname],[taoxijiage],[taoxizs],[time1],[time2],[time3],[time4],[time5],[time6],[time8],[time9],[time10],[bm],[ren],[discount],[payed1],[status],[status2],[status3],[status4],[status5],[status6],[status7],[status8],[urgent],[bz],[pinyin1],[pinyin2],[clothescount],[clothescount2],[outside],[outside2],[style],[waiter1],[waiter2],[waiter3],[waiter4],[waiter5],[waiter6],[waiter7],[waiter8],[memberno],[txtype],[tichenren1],[tichenren2],[tichenren3],[tichenren4],[tichenren5],[phone1],[phone2],[dindantype],[contractno1],[contractno2],[cfno],[from],[reason],[time7],[waiter12],[waiter13],[waiter14],[authorize],[xplrr],[xplrtime]) values('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','未刻','未看','否','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','','','','','','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s')", id,m_growthtxselname,strmoney,m_name1,m_name2,m_taoxiid,taoxiname,m_taoxijiage,m_zs,m_time1,m_time2,m_time3,m_time4,m_time5,m_time6,m_time8,m_time9,m_time10,bm,ren,m_discount,m_payed1, m_status1,m_status2,m_status3,m_status4,m_status5,m_status6,FilterBZ(m_bz),strRes1,strRes2,m_clothescount,m_clothescount2,m_outside,m_outside2,m_style,m_waiter1,m_waiter2,m_waiter3,m_waiter4,m_waiter5,g_user.name,m_waiter7,m_waiter8, m_memberno,txtype,m_phone1,m_phone2,m_dindantype,m_contractno,m_contractno2,m_cfno,m_from,m_reason,m_time7,m_waiter12,m_waiter13,m_waiter14,m_authorize,g_user.name,CTime::GetCurrentTime().Format("%Y-%m-%d %H:%M:%S")); #endif #endif CString sql2; CStringArray idarray; idarray.Add(id); #ifdef CHILD_VERSION sql2.Format("###insert into [client]([name1],[name2],[phone1],[phone2],[qq1],[addr1],[birthday1],[id],[area],[sex],[zodiac],[check1])values('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%d')", m_name1, m_name2, m_phone1, m_phone2, m_qq1, m_addr1, m_birthday1, id, m_area, m_sex, m_zodiac, m_check1); sql += sql2; if (txtype == "成长套系" && m_growthtxselname.IsEmpty() == 0) { CString sqltemp = sql; CString taoxinametemp = taoxiname.Left(taoxiname.GetLength() - 4); CString m_selname = m_growthtxselname; int pos = m_selname.Find(","); CStringArray selnamearray; while (pos != -1) { selnamearray.Add(m_selname.Left(pos)); m_selname = m_selname.Right(m_selname.GetLength() - pos - 1); pos = m_selname.Find(","); } selnamearray.Add(m_selname); int idpos = atoi(id.Right(3)); CString newid, temp; for (int ii = 0; ii < selnamearray.GetSize(); ii++) { taoxinametemp = taoxiname; taoxinametemp += selnamearray.ElementAt(ii); if (ii == 0) { sql.Replace(taoxiname, taoxinametemp); continue; } newid.Format("%s%03d", id.Left(id.GetLength() - 3), ++idpos); idarray.Add(newid); temp = sqltemp; temp.Replace(id, newid); temp.Replace(taoxiname, taoxinametemp); sql += "###" + temp; } } if (atoi(g_cominfoarray.ElementAt(0).ElementAt(39))) { CString m_content3 = g_cominfoarray.ElementAt(0).ElementAt(40); CString str, timestamp; timestamp = "msgtimestamp"; { CString name; if (!m_name1.IsEmpty()) name = m_name1 + ","; name += m_name2; name.TrimRight(","); if (name.IsEmpty() == 0 && CheckPhoneType(m_phone1) != -1 && CheckBadWords(name, 0)) { str = name + m_content3; str.Replace("xxx小朋友", ""); int count = GetLengthEx(str) / MSG_LENGTH; if (GetLengthEx(str) % MSG_LENGTH) count++; CString scount; scount.Format("%d", count); #if JEFF_TEST_ON sql2.Format(INSERT_SENDREG, _T("3"), m_phone1, str, timestamp, scount, _T("0"), _T("0"), _T("0"), _T("系统自动发送")); sql += _T("###") + sql2; #else sql2="###insert into [sendreg]([phones],[content],[timestamp],[msgcount],[status],[issended],[isautosend],[ren]) values('"+m_phone1+"','"+str+"','"+timestamp+"','"+scount+"','0','0','0','系统自动发送')"; sql+=sql2; #endif } } } #else sql2.Format ("###insert into [client]([name1],[name2],[phone1],[phone2],[qq1],[qq2],[addr1],[addr2],[occupation1],[occupation2],[birthday1],[birthday2],[id],[area],[area2],[check1],[check2],[check3])values('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%d','%d','%d')",m_name1,m_name2,m_phone1,m_phone2,m_qq1,m_qq2,m_addr1,m_addr2,m_occupation1,m_occupation2,m_birthday1,m_birthday2,id,m_area,m_area2,m_check1,m_check2,m_check3); sql+=sql2; if(txtype=="成长套系" && m_growthtxselname.IsEmpty ()==0) { CString sqltemp=sql; CString taoxinametemp=taoxiname.Left(taoxiname.GetLength()-4); CString m_selname=m_growthtxselname; int pos=m_selname.Find (","); CStringArray selnamearray; while(pos!=-1) { selnamearray.Add (m_selname.Left (pos)); m_selname=m_selname.Right (m_selname.GetLength ()-pos-1); pos=m_selname.Find (","); } selnamearray.Add (m_selname); int idpos=atoi(id.Right (3)); CString newid,temp; for(int ii=0; iiProcessChatMessageRequest2(sql); if (g_bSendOK == 0)return; // printf("Jeff:Booking2发送订单SQL成功,等待接收....\n\n"); CArraysparray; if (m_bGrowthTX) sparray.SetSize(m_page1.m_List1arraygrowthbak.GetSize() + m_page1.m_List3.GetItemCount() + m_page1.m_listbox1.GetCount(), 1); else sparray.SetSize(m_page1.m_List1.GetItemCount() + m_page1.m_List3.GetItemCount() + m_page1.m_listbox1.GetCount(), 1); int realcount = 0; int i; if (m_bGrowthTX) { for (i = 0; i < m_page1.m_List1arraygrowthbak.GetSize(); i++) { int arraygrowthbaksize = m_page1.m_List1arraygrowthbak.ElementAt(i).GetSize(); str = m_page1.m_List1arraygrowthbak.ElementAt(i).ElementAt(1); str.TrimLeft(); str.TrimRight(); if (str.IsEmpty()) continue; sparray.ElementAt(realcount).Add(id); sparray.ElementAt(realcount).Add(m_page1.m_List1arraygrowthbak.ElementAt(i).ElementAt(0)); sparray.ElementAt(realcount).Add(m_page1.m_List1arraygrowthbak.ElementAt(i).ElementAt(2)); sparray.ElementAt(realcount).Add(m_page1.m_List1arraygrowthbak.ElementAt(i).ElementAt(3)); sparray.ElementAt(realcount).Add("1"); sparray.ElementAt(realcount).Add(m_page1.m_List1arraygrowthbak.ElementAt(i).ElementAt(1)); sparray.ElementAt(realcount).Add(m_page1.m_List1arraygrowthbak.ElementAt(i).ElementAt(4)); sparray.ElementAt(realcount).Add(m_page1.m_List1arraygrowthbak.ElementAt(i).ElementAt(5)); sparray.ElementAt(realcount).Add(m_page1.m_List1arraygrowthbak.ElementAt(i).ElementAt(arraygrowthbaksize - 1)); realcount++; } } else { for (i = 0; i < m_page1.m_List1.GetItemCount(); i++) { str = m_page1.m_List1.GetItemText(i, 1); str.TrimLeft(); str.TrimRight(); if (str.IsEmpty()) continue; sparray.ElementAt(realcount).Add(id); sparray.ElementAt(realcount).Add(m_page1.m_List1.GetItemText(i, 0)); sparray.ElementAt(realcount).Add(m_page1.m_List1.GetItemText(i, 2)); sparray.ElementAt(realcount).Add(m_page1.m_List1.GetItemText(i, 3)); sparray.ElementAt(realcount).Add("1"); sparray.ElementAt(realcount).Add(m_page1.m_List1.GetItemText(i, 1)); sparray.ElementAt(realcount).Add(m_page1.m_List1.GetItemText(i, 4)); sparray.ElementAt(realcount).Add(m_page1.m_List1.GetItemText(i, 5)); realcount++; } } for (i = 0; i < m_page1.m_List3.GetItemCount(); i++) { str = m_page1.m_List3.GetItemText(i, 1); str.TrimLeft(); str.TrimRight(); if (str.IsEmpty())continue; sparray.ElementAt(realcount).Add(id); sparray.ElementAt(realcount).Add(m_page1.m_List3.GetItemText(i, 0)); sparray.ElementAt(realcount).Add(m_page1.m_List3.GetItemText(i, 2)); sparray.ElementAt(realcount).Add(m_page1.m_List3.GetItemText(i, 3)); sparray.ElementAt(realcount).Add("2"); sparray.ElementAt(realcount).Add(m_page1.m_List3.GetItemText(i, 1)); sparray.ElementAt(realcount).Add(""); sparray.ElementAt(realcount).Add(""); realcount++; } for (i = 0; i < m_page1.m_listbox1.GetCount(); i++) { m_page1.m_listbox1.GetText(i, str); sparray.ElementAt(realcount).Add(id); sparray.ElementAt(realcount).Add(str); realcount++; } if (realcount == 0) { sparray.SetSize(1, 1); sparray.ElementAt(0).Add(id); } else if (idarray.GetSize() > 1) { sparray.SetSize(realcount + 1, 1); sparray.ElementAt(realcount).Add("成长套系"); for (int a = 0; a < idarray.GetSize(); a++) { sparray.ElementAt(realcount).Add(idarray.ElementAt(a)); } } else sparray.SetSize(realcount, 1); realcount = sparray.GetSize(); sparray.SetSize(realcount + 1, 1); sparray.ElementAt(realcount).Add(g_user.name); CMemFile memfile; CArchive ar(&memfile, CArchive::store); for (int ii = 0; ii < sparray.GetSize(); ii++) { sparray.ElementAt(ii).Serialize(ar); } ar.Close(); int length = memfile.GetLength(); BYTE *pData = memfile.Detach(); int size = sparray.GetSize(); BYTE *pData2 = new BYTE[length + sizeof(int)]; memcpy(pData2, pData, length); memcpy(pData2 + length, &size, sizeof(int)); delete[]pData; length += sizeof(int); g_nSendCode = 3; g_pMainWnd->ProcessChatMessageRequest2(pData2, length); g_nSendCode = 0; delete[]pData2; if (g_bSendOK == 0) return; #ifndef CHILD_VERSION if(m_time3.IsEmpty ()==0) { CString date=m_time3; CString date2; if(m_check3) CovertDate(date, date2); sql.Format ("update dindansp set hqdate='%s' where id='%s'", date, id); if(atoi(g_cominfoarray.ElementAt(0).ElementAt(117)))//新摄控本 { CString timestamp; CTime tm=CTime::GetCurrentTime (); CTimeSpan dt(0,0,0,10); tm+=dt; timestamp=tm.Format ("%Y%m%d%H%M%S"); CString phone,clothescount,content; for( i=0; iProcessChatMessageRequest2(sql);if(g_bSendOK==0)return; } #endif AfxMessageBox("保存成功!", MB_ICONINFORMATION); CString m_type = _T(""); m_type.Format(_T("%d"),m_page3.m_type); if (m_type == _T("1") || m_type == _T("3")) { if (m_type == _T("1")) { CString m_point; m_point.Format("%d", atol(m_taoxijiage)); CString m_card2no = m_page3.m_memberno2; CString date2 = m_page3.m_memberno2date; CString m_name = m_page3.m_membernoname; CString m_sex = m_page3.m_membernosex; CString m_phone = m_page3.m_membernophone; CString sql; sql = "delete from membercard2 where [card2no]='" + m_card2no + "'"; sql += "@@@insert into memberreg([memberno],[dindanid],[money],[date],[card2no],[type],[taoxi],[date2])values('" + m_memberno + "','" + id + "','" + m_point + "','" + g_date + "','" + m_card2no + "','转介绍','" + taoxiname + "','" + date2 + "')"; sql += "@@@"; m_point.Format("%d", (int)(atof(m_taoxijiage)*GetPointScale())); if (atoi(g_cominfoarray.ElementAt(0).ElementAt(51))) { CString m_content5 = g_cominfoarray.ElementAt(0).ElementAt(52); CString content, timestamp; CString name; if (!m_name1.IsEmpty()) name = m_name1 + ","; name += m_name2; name.TrimRight(","); CString name2 = m_name; #ifndef CHILD_VERSION if(m_sex=="男") name2+="先生"; else if(m_sex=="女") name2+="女士"; #endif content.Format("%s您好,您的朋友%s为您积分%s分.", name2, name, m_point); content += m_content5; timestamp = "msgtimestamp"; if (CheckPhoneType(m_phone) != -1 && CheckBadWords(content, 0)) { int count = GetLengthEx(content) / MSG_LENGTH; if (GetLengthEx(content) % MSG_LENGTH) count++; CString scount; scount.Format("%d", count); #if JEFF_TEST_ON CString sql2 = _T(""); sql2.Format(INSERT_SENDREG, _T("5"), m_phone, content, timestamp, scount, _T("0"), _T("0"), _T("0"), _T("系统自动发送")); sql += sql2; #else CString sql2="insert into sendreg([phones],[content],[timestamp],[msgcount],[status],[issended],[isautosend],[ren]) values('"+m_phone+"','"+content+"','"+timestamp+"','"+scount+"','0','0','0','系统自动发送')"; sql+=sql2; #endif sql += "@@@"; } } sql += m_memberno; g_sendhead.bsql = 1; g_pMainWnd->ProcessChatMessageRequest2(sql); if (g_bSendOK == 0)return; } else if (m_type == _T("3")) { CString m_rate; CString filter = "[memberno]='" + m_memberno + "'"; g_sendhead.bsql = 0; g_sendhead.code[0] = 132; g_sendhead.tabcount = 1; g_pMainWnd->ProcessChatMessageRequest2(filter); if (g_bSendOK == 0)return; DataToArray(&g_List1array); CString m_bluescale1; CString m_bluescale2; CString m_bluescale3; CString m_bluescale4; CString m_bluescale5; CString m_bluescale6; CString m_bluescale7; CString m_bluescale8; CString m_bluescale9; CString m_bluescale10; CString str = (g_cominfoarray.ElementAt(0).ElementAt(119)); if (str == "") str = "5,10,15,20,50,0,0,0,0,0"; int pos = str.Find(","); m_bluescale1 = str.Left(pos); str = str.Right(str.GetLength() - pos - 1); pos = str.Find(","); m_bluescale2 = str.Left(pos); str = str.Right(str.GetLength() - pos - 1); pos = str.Find(","); m_bluescale3 = str.Left(pos); str = str.Right(str.GetLength() - pos - 1); pos = str.Find(","); m_bluescale4 = str.Left(pos); str = str.Right(str.GetLength() - pos - 1); pos = str.Find(","); m_bluescale5 = str.Left(pos); str = str.Right(str.GetLength() - pos - 1); pos = str.Find(","); m_bluescale6 = str.Left(pos); str = str.Right(str.GetLength() - pos - 1); pos = str.Find(","); m_bluescale7 = str.Left(pos); str = str.Right(str.GetLength() - pos - 1); pos = str.Find(","); m_bluescale8 = str.Left(pos); str = str.Right(str.GetLength() - pos - 1); pos = str.Find(","); m_bluescale9 = str.Left(pos); str = str.Right(str.GetLength() - pos - 1); m_bluescale10 = str.Left(pos); if (g_List1array.GetSize() % 10 == 0) m_rate = m_bluescale1 + "%"; else if (g_List1array.GetSize() % 10 == 1) m_rate = m_bluescale2 + "%"; else if (g_List1array.GetSize() % 10 == 2) m_rate = m_bluescale3 + "%"; else if (g_List1array.GetSize() % 10 == 3) m_rate = m_bluescale4 + "%"; else if (g_List1array.GetSize() % 10 == 4) m_rate = m_bluescale5 + "%"; else if (g_List1array.GetSize() % 10 == 5) m_rate = m_bluescale6 + "%"; else if (g_List1array.GetSize() % 10 == 6) m_rate = m_bluescale7 + "%"; else if (g_List1array.GetSize() % 10 == 7) m_rate = m_bluescale8 + "%"; else if (g_List1array.GetSize() % 10 == 8) m_rate = m_bluescale9 + "%"; else if (g_List1array.GetSize() % 10 == 9) m_rate = m_bluescale10 + "%"; else m_rate = "0%"; float frate = atof(m_rate) / 100.0; CString m_point; m_point.Format("%d", (int)(min(atof(m_taoxijiage), atof(m_page3.m_membernojiage))*frate)); BOOL bCheck = 1; if (atof(m_taoxijiage) < atof(m_page3.m_membernojiage)) { AfxMessageBox("此套系金额小于主套系,无法返现!"); bCheck = 0; } if (bCheck) { CString m_card2no = m_page3.m_memberno2; CString date2 = m_page3.m_memberno2date; CString m_name = m_page3.m_membernoname; CString m_sex = m_page3.m_membernosex; CString m_phone = m_page3.m_membernophone; CString sql; sql = "delete from membercard2blue where [card2no]='" + m_card2no + "'"; sql += "~~~insert into memberregblue([memberno],[dindanid],[money],[date],[card2no],[type],[taoxi],[date2])values('" + m_memberno + "','" + id + "','" + m_point + "','" + g_date + "','" + m_card2no + "','转介绍','" + taoxiname + "','" + date2 + "')"; sql += "~~~"; if (atoi(g_cominfoarray.ElementAt(0).ElementAt(51))) { CString m_content5 = g_cominfoarray.ElementAt(0).ElementAt(52); CString content, timestamp; CString name; if (!m_name1.IsEmpty()) name = m_name1 + ","; name += m_name2; name.TrimRight(","); CString name2 = m_name; #ifndef CHILD_VERSION if(m_sex=="男") name2+="先生"; else if(m_sex=="女") name2+="女士"; #endif content.Format("%s您好,您的朋友%s为您返现金%s元.", name2, name, m_point); content += m_content5; timestamp = "msgtimestamp"; if (CheckPhoneType(m_phone) != -1 && CheckBadWords(content, 0)) { int count = GetLengthEx(content) / MSG_LENGTH; if (GetLengthEx(content) % MSG_LENGTH) count++; CString scount; scount.Format("%d", count); #if JEFF_TEST_ON CString sql2 = _T(""); sql2.Format(INSERT_SENDREG, _T("5"), m_phone, content, timestamp, scount, _T("0"), _T("0"), _T("0"), _T("系统自动发送")); sql += sql2; #else CString sql2="insert into sendreg([phones],[content],[timestamp],[msgcount],[status],[issended],[isautosend],[ren]) values('"+m_phone+"','"+content+"','"+timestamp+"','"+scount+"','0','0','0','系统自动发送')"; sql+=sql2; #endif sql += "~~~"; } } sql += m_memberno; g_sendhead.bsql = 1; g_pMainWnd->ProcessChatMessageRequest2(sql); if (g_bSendOK == 0)return; } } } CString phone; BOOL bNeedCard = 0; if (m_type == _T("1") || m_type == _T("2") || m_type == _T("3")) bNeedCard = 1; if (m_memberno.IsEmpty()) bNeedCard = 1; if (bNeedCard) { SelMemberType dlg; if (dlg.DoModal() == IDOK) { if (dlg.m_type == 0) { AddMember dlg; if (m_name2 != "") dlg.m_name = m_name2; else dlg.m_name = m_name1; if (m_phone2 != "") dlg.m_phone = m_phone2; else dlg.m_phone = m_phone1; if (m_birthday2 != "") dlg.m_birthday = m_birthday2; else dlg.m_birthday = m_birthday1; if (m_qq2 != "") dlg.m_qq = m_qq2; else dlg.m_qq = m_qq1; if (m_addr2 != "") dlg.m_addr = m_addr2; else dlg.m_addr = m_addr1; if (dlg.DoModal() == IDOK) { if (AfxMessageBox("会员添加成功,是否发放副卡?", MB_YESNO | MB_ICONINFORMATION) == IDYES) { InputCard2Dlg dlg2; dlg2.m_name = dlg.m_name; dlg2.m_no = dlg.m_memberno; dlg2.DoModal(); } sql = "update dindan set [memberno]='" + dlg.m_memberno + "' where [id]='" + id + "'"; g_sendhead.bsql = 1; g_pMainWnd->ProcessChatMessageRequest2(sql); if (g_bSendOK == 0)return; } } else { AddMember dlg; dlg.m_mode = 1; if (m_name2 != "") dlg.m_name = m_name2; else dlg.m_name = m_name1; if (m_phone2 != "") dlg.m_phone = m_phone2; else dlg.m_phone = m_phone1; if (m_birthday2 != "") dlg.m_birthday = m_birthday2; else dlg.m_birthday = m_birthday1; if (m_qq2 != "") dlg.m_qq = m_qq2; else dlg.m_qq = m_qq1; if (m_addr2 != "") dlg.m_addr = m_addr2; else dlg.m_addr = m_addr1; dlg.m_jiage = m_taoxijiage; if (dlg.DoModal() == IDOK) { if (AfxMessageBox("会员添加成功,是否发放副卡?", MB_YESNO | MB_ICONINFORMATION) == IDYES) { InputCard2Dlg dlg2; dlg2.m_mode = 1; dlg2.m_name = dlg.m_name; dlg2.m_no = dlg.m_memberno; dlg2.DoModal(); } sql = "update dindan set [memberno]='" + dlg.m_memberno + "' where [id]='" + id + "'"; g_sendhead.bsql = 1; g_pMainWnd->ProcessChatMessageRequest2(sql); if (g_bSendOK == 0)return; } } } } GetDlgItem(IDC_BUTprint)->EnableWindow(1); if (!m_bModify) GetDlgItem(IDC_BUTsave)->EnableWindow(0); } // Jeff 保存"预约单-修改"的数据; void Booking2::OnBUTsave2()//保存修改; { // TODO: Add your control notification handler code here if (!m_page1.CheckOK()) { AfxMessageBox("资料不全,打*号的项目必须填写!", MB_ICONINFORMATION); OnBUTinfo1(); return; } if (!m_page2.CheckOK()) { AfxMessageBox("资料不全,打*号的项目必须填写!", MB_ICONINFORMATION); OnBUTinfo2(); return; } if (!m_page3.CheckOK()) { AfxMessageBox("资料不全,打*号的项目必须填写!", MB_ICONINFORMATION); OnBUTinfo3(); return; } if (!m_page4.CheckOK()) { AfxMessageBox("资料不全,打*号的项目必须填写!", MB_ICONINFORMATION); OnBUTinfo4(); return; } // 修改预约单的权限索引 == 1 ? #if JEFF_TEST_ON // [3/24/2015 Jeff] if ( m_page4.m_bModify ) { Login2 dlg; dlg.m_mode = 4; if (dlg.DoModal() != IDOK)return; if (IsHasRightsnew2(1, dlg.m_rights) == 0)return; } else { if(IsHasRightsnew(1)==0) return; } #else // 不使用权限,使用实时密码; if(IsHasRights2(1)==0) return; #endif // TODO: Add your control notification handler code here CString id = m_id; CString m_taoxiid = m_page1.m_taoxiid; CString taoxiname = m_page1.m_taoxiname; CString m_growthtxselname = m_page1.m_growthtxselname; CString m_taoxijiage = m_page1.m_taoxijiage; CString m_payed1 = m_page1.m_payed1; // CString m_zs=m_page1.m_zs; CString m_zs = m_page1.m_zs + "\\" + m_page1.m_zs2; CString txtype = m_page1.m_txtype; CString m_bz = m_page1.m_bz; CString bm = m_page3.m_bm; CString ren = m_page3.m_ren; CString m_clothescount = m_page3.m_clothescount; CString m_clothescount2 = m_page3.m_clothescount2; CString m_outside = m_page3.m_outside; CString m_outside2 = m_page3.m_outside2; CString m_style = m_page3.m_style; CString strmoney = "0"; BOOL m_bGrowthTX = m_page1.m_bGrowthTX; #ifdef LKAY_VERSION CString m_dindantype=m_page1.m_dindantype; CString m_contractno=m_page1.m_contractno; CString m_contractno2=m_page1.m_contractno2; CString m_cfno=m_page3.m_cfno; CString m_from=m_page3.m_from; CString m_reason=m_page3.m_reason; CString m_time7=m_page4.m_time7; CString m_waiter12=m_page4.m_waiter12; CString m_waiter13=m_page4.m_waiter13; CString m_waiter14=m_page4.m_waiter14; #else CString m_from = m_page1.m_from; #endif #ifdef CHILD_VERSION CString m_name1 = m_page2.m_name1; CString m_name2 = m_page2.m_name2; CString m_phone1 = m_page2.m_phone1; CString m_phone2 = m_page2.m_phone2; CString m_qq1 = m_page2.m_qq1; CString m_addr1 = m_page2.m_addr1; CString m_birthday1 = m_page2.m_birthday1; CString m_area = m_page2.m_area; BOOL m_check1 = m_page2.m_check1; CString m_zodiac = m_page2.m_zodiac; CString m_sex = m_page2.m_sex; CString m_time3 = m_page4.m_time3; #else CString m_name1=m_page2.m_name1; CString m_name2=m_page2.m_name2; CString m_phone1=m_page2.m_phone1; CString m_phone2=m_page2.m_phone2; CString m_qq1=m_page2.m_qq1; CString m_qq2=m_page2.m_qq2; CString m_addr1=m_page2.m_addr1; CString m_addr2=m_page2.m_addr2; CString m_occupation1=m_page2.m_occupation1; CString m_occupation2=m_page2.m_occupation2; CString m_birthday1=m_page2.m_birthday1; CString m_birthday2=m_page2.m_birthday2; CString m_area=m_page2.m_area; CString m_area2=m_page2.m_area2; BOOL m_check1=m_page2.m_check1; BOOL m_check2=m_page2.m_check2; CString m_time3 = m_page2.m_time3; #endif CString m_time1 = m_page4.m_time1; CString m_time2 = m_page4.m_time2; CString m_time4 = m_page4.m_time4; CString m_time5 = m_page4.m_time5; CString m_time6 = m_page4.m_time6; CString m_time8 = m_page4.m_time8; CString m_time9 = m_page4.m_time9; CString m_time10 = m_page4.m_time10; CString m_time2old = m_page4.m_time2old; CString m_time4old = m_page4.m_time4old; CString m_time5old = m_page4.m_time5old; CString m_time6old = m_page4.m_time6old; CString m_waiter1 = m_page4.m_waiter1; CString m_waiter2 = m_page4.m_waiter2; CString m_waiter3 = m_page4.m_waiter3; CString m_waiter4 = m_page4.m_waiter4; CString m_waiter5 = m_page4.m_waiter5; CString m_waiter7 = m_page4.m_waiter7; CString m_waiter8 = m_page4.m_waiter8; //Jeff 看版人 waiter8 CString m_status1 = m_page4.m_status1; CString m_status2 = m_page4.m_status2; CString m_status3 = m_page4.m_status3; CString m_status4 = m_page4.m_status4; CString m_status5 = m_page4.m_status5; CString m_status6 = m_page4.m_status6; CString m_status8 = m_page4.m_status8; // Jeff 看版状态 status8 BOOL m_check3 = m_page4.m_check3; CString waiter3_old = m_page4.m_waiter3_old;// Jeff add; CString sql, str, str2; CString strRes1, strRes2; ChinesePinYin::GetFirstLetter(m_name1, strRes1); ChinesePinYin::GetFirstLetter(m_name2, strRes2); CString m_memberno = m_page3.m_memberno; if (m_page3.m_type == 1 || m_page3.m_type == 3)//副卡 m_memberno = m_page3.m_memberno2; CString m_membernotemp = m_memberno; if (m_page3.m_type)m_memberno.Empty(); #if 0 // Jeff Old Edition sql.Format ("update dindan set name1='%s',name2='%s',taoxiid='%s',taoxiname='%s',taoxizs='%s',time2='%s',time3='%s',time4='%s',time5='%s',time6='%s',time8='%s',time9='%s',time10='%s',waiter1='%s',waiter2='%s',waiter3='%s',waiter4='%s',waiter5='%s',waiter6='%s',waiter7='%s',status='%s',status2='%s',status3='%s',status4='%s',status5='%s',status6='%s',bm='%s',ren='%s',bz='%s',pinyin1='%s',pinyin2='%s',clothescount='%s',clothescount2='%s',outside='%s',outside2='%s',style='%s',taoxijiage='%s',txtype='%s',growthtxselname='%s',[phone1]='%s',[phone2]='%s',[memberno]='%s',[from]='%s' where id='%s' ", m_name1,m_name2,m_taoxiid,taoxiname,m_zs,m_time2,m_time3,m_time4,m_time5,m_time6,m_time8,m_time9,m_time10, m_waiter1,m_waiter2,m_waiter3,m_waiter4,m_waiter5,g_user.name,m_waiter7,m_status1,m_status2,m_status3,m_status4,m_status5,m_status6, bm,ren,FilterBZ(m_bz),strRes1,strRes2,m_clothescount,m_clothescount2,m_outside,m_outside2,m_style,m_taoxijiage,txtype,m_growthtxselname,m_phone1,m_phone2,m_memberno,m_from,id); #else // Jeff update; if (waiter3_old == m_waiter3)// 选片人未更改; { sql.Format("update dindan set name1='%s',name2='%s',taoxiid='%s',taoxiname='%s', taoxizs='%s',time2='%s',time3='%s',time4='%s',time5='%s',time6='%s',time8='%s',time9='%s',time10='%s',waiter1='%s',waiter2='%s',waiter3='%s',waiter4='%s',waiter5='%s',waiter6='%s',waiter7='%s',waiter8='%s',status='%s',status2='%s',status3='%s',status4='%s',status5='%s',status6='%s',status8='%s',bm='%s',ren='%s',bz='%s',pinyin1='%s',pinyin2='%s',clothescount='%s',clothescount2='%s',outside='%s',outside2='%s',style='%s',taoxijiage='%s',txtype='%s',growthtxselname='%s',[phone1]='%s',[phone2]='%s',[memberno]='%s',[from]='%s' where id='%s' ", m_name1, m_name2, m_taoxiid, taoxiname, m_zs, m_time2, m_time3, m_time4, m_time5, m_time6, m_time8, m_time9, m_time10, m_waiter1, m_waiter2, m_waiter3, m_waiter4, m_waiter5, g_user.name, m_waiter7, m_waiter8, m_status1, m_status2, m_status3, m_status4, m_status5, m_status6, m_status8, bm, ren, FilterBZ(m_bz), strRes1, strRes2, m_clothescount, m_clothescount2, m_outside, m_outside2, m_style, m_taoxijiage, txtype, m_growthtxselname, m_phone1, m_phone2, m_memberno, m_from, id); } else { sql.Format("update dindan set name1='%s',name2='%s',taoxiid='%s',taoxiname='%s', taoxizs='%s',time2='%s',time3='%s',time4='%s',time5='%s',time6='%s',time8='%s',time9='%s',time10='%s',waiter1='%s',waiter2='%s',waiter3='%s',waiter4='%s',waiter5='%s',waiter6='%s',waiter7='%s',waiter8='%s',status='%s',status2='%s',status3='%s',status4='%s',status5='%s',status6='%s',status8='%s',bm='%s',ren='%s',bz='%s',pinyin1='%s',pinyin2='%s',clothescount='%s',clothescount2='%s',outside='%s',outside2='%s',style='%s',taoxijiage='%s',txtype='%s',growthtxselname='%s',[phone1]='%s',[phone2]='%s',[memberno]='%s',[from]='%s',[xplrr]='%s',[xplrtime]='msgtimestamp2' where id='%s' ", m_name1, m_name2, m_taoxiid, taoxiname, m_zs, m_time2, m_time3, m_time4, m_time5, m_time6, m_time8, m_time9, m_time10, m_waiter1, m_waiter2, m_waiter3, m_waiter4, m_waiter5, g_user.name, m_waiter7, m_waiter8, m_status1, m_status2, m_status3, m_status4, m_status5, m_status6, m_status8, bm, ren, FilterBZ(m_bz), strRes1, strRes2, m_clothescount, m_clothescount2, m_outside, m_outside2, m_style, m_taoxijiage, txtype, m_growthtxselname, m_phone1, m_phone2, m_memberno, m_from, g_user.name, id ); } // Jeff.add 2014.08.30; CString strSQL; if (m_status1 == "OK") // 若整体的订单拍照状态为OK,则设置订单下所有景点的拍照状态都为OK; { strSQL.Format("***update dindanjd set status='OK' where id='%s'", id); sql += strSQL; } #endif #ifdef LKAY_VERSION #if 0// Jeff Old Edition sql.Format ("update dindan set name1='%s',name2='%s',taoxiid='%s',taoxiname='%s',taoxizs='%s',time2='%s',time3='%s',time4='%s',time5='%s',time6='%s',time8='%s',time9='%s',time10='%s',waiter1='%s',waiter2='%s',waiter3='%s',waiter4='%s',waiter5='%s',waiter6='%s',waiter7='%s',status='%s',status2='%s',status3='%s',status4='%s',status5='%s',status6='%s',bm='%s',ren='%s',bz='%s',pinyin1='%s',pinyin2='%s',clothescount='%s',clothescount2='%s',outside='%s',outside2='%s',style='%s',taoxijiage='%s',txtype='%s',growthtxselname='%s',[phone1]='%s',[phone2]='%s',[memberno]='%s',[dindantype]='%s',[contractno1]='%s',[contractno2]='%s',[cfno]='%s',[from]='%s',[reason]='%s',[time7]='%s',[waiter12]='%s',[waiter13]='%s',[waiter14]='%s' where id='%s' ", m_name1,m_name2,m_taoxiid,taoxiname,m_zs,m_time2,m_time3,m_time4,m_time5,m_time6,m_time8,m_time9,m_time10, m_waiter1,m_waiter2,m_waiter3,m_waiter4,m_waiter5,g_user.name,m_waiter7,m_status1,m_status2,m_status3,m_status4,m_status5,m_status6, bm,ren,FilterBZ(m_bz),strRes1,strRes2,m_clothescount,m_clothescount2,m_outside,m_outside2,m_style,m_taoxijiage,txtype,m_growthtxselname,m_phone1,m_phone2,m_memberno, m_dindantype,m_contractno,m_contractno2,m_cfno,m_from,m_reason,m_time7,m_waiter12,m_waiter13,m_waiter14,id); #else // Jeff update if(waiter3_old == m_waiter3) { sql.Format ("update dindan set name1='%s',name2='%s',taoxiid='%s',taoxiname='%s',taoxizs='%s',time2='%s',time3='%s',time4='%s',time5='%s',time6='%s',time8='%s',time9='%s',time10='%s',waiter1='%s',waiter2='%s',waiter3='%s',waiter4='%s',waiter5='%s',waiter6='%s',waiter7='%s',waiter8='%s',status='%s',status2='%s',status3='%s',status4='%s',status5='%s',status6='%s',status8='%s',bm='%s',ren='%s',bz='%s',pinyin1='%s',pinyin2='%s',clothescount='%s',clothescount2='%s',outside='%s',outside2='%s',style='%s',taoxijiage='%s',txtype='%s',growthtxselname='%s',[phone1]='%s',[phone2]='%s',[memberno]='%s',[dindantype]='%s',[contractno1]='%s',[contractno2]='%s',[cfno]='%s',[from]='%s',[reason]='%s',[time7]='%s',[waiter12]='%s',[waiter13]='%s',[waiter14]='%s' where id='%s' ", m_name1,m_name2,m_taoxiid,taoxiname,m_zs,m_time2,m_time3,m_time4,m_time5,m_time6,m_time8,m_time9,m_time10, m_waiter1,m_waiter2,m_waiter3,m_waiter4,m_waiter5,g_user.name,m_waiter7,m_waiter8,m_status1,m_status2,m_status3,m_status4,m_status5,m_status6,m_status8, bm,ren,FilterBZ(m_bz),strRes1,strRes2,m_clothescount,m_clothescount2,m_outside,m_outside2,m_style,m_taoxijiage,txtype,m_growthtxselname, m_phone1,m_phone2,m_memberno,m_dindantype,m_contractno,m_contractno2,m_cfno,m_from,m_reason,m_time7,m_waiter12,m_waiter13,m_waiter14,id); } else { sql.Format ("update dindan set name1='%s',name2='%s',taoxiid='%s',taoxiname='%s',taoxizs='%s',time2='%s',time3='%s',time4='%s',time5='%s',time6='%s',time8='%s',time9='%s',time10='%s',waiter1='%s',waiter2='%s',waiter3='%s',waiter4='%s',waiter5='%s',waiter6='%s',waiter7='%s',waiter8='%s',status='%s',status2='%s',status3='%s',status4='%s',status5='%s',status6='%s',status8='%s',bm='%s',ren='%s',bz='%s',pinyin1='%s',pinyin2='%s',clothescount='%s',clothescount2='%s',outside='%s',outside2='%s',style='%s',taoxijiage='%s',txtype='%s',growthtxselname='%s',[phone1]='%s',[phone2]='%s',[memberno]='%s',[dindantype]='%s',[contractno1]='%s',[contractno2]='%s',[cfno]='%s',[from]='%s',[reason]='%s',[time7]='%s',[waiter12]='%s',[waiter13]='%s',[waiter14]='%s',[xplrr]='%s',[xplrtime]='msgtimestamp2' where id='%s' ", m_name1,m_name2,m_taoxiid,taoxiname,m_zs,m_time2,m_time3,m_time4,m_time5,m_time6,m_time8,m_time9,m_time10, m_waiter1,m_waiter2,m_waiter3,m_waiter4,m_waiter5,g_user.name,m_waiter7,m_waiter8, m_status1,m_status2,m_status3,m_status4,m_status5,m_status6,m_status8, bm,ren,FilterBZ(m_bz),strRes1,strRes2,m_clothescount,m_clothescount2, m_outside,m_outside2,m_style,m_taoxijiage,txtype,m_growthtxselname,m_phone1,m_phone2,m_memberno, m_dindantype,m_contractno,m_contractno2,m_cfno,m_from,m_reason,m_time7,m_waiter12,m_waiter13,m_waiter14,g_user.name,id); } #endif #endif #if JEFF_TEST_ON // 2015-05-30 若取件状态OK,写日志; if ( m_status3 == _T("OK") ) { CString strLog; strLog.Format(_T(" 订单:%s 在预约修改中被设置为取件OK"),id); WriteLog(_T("取件"), strLog); } #endif CString sql2; #ifdef CHILD_VERSION sql2.Format("***update [client] set [name1]='%s',[name2]='%s',[phone1]='%s',[phone2]='%s',[qq1]='%s',[addr1]='%s',[birthday1]='%s',[area]='%s',[sex]='%s',[zodiac]='%s',[check1]='%d' where [id]='%s' ", m_name1, m_name2, m_phone1, m_phone2, m_qq1, m_addr1, m_birthday1, m_area, m_sex, m_zodiac, m_check1, id); #else sql2.Format ("***update [client] set [name1]='%s',[name2]='%s',[phone1]='%s',[phone2]='%s',[qq1]='%s',[qq2]='%s',[addr1]='%s',[addr2]='%s',[occupation1]='%s',[occupation2]='%s',[birthday1]='%s',[birthday2]='%s',[area]='%s',[area2]='%s',[check1]='%d',[check2]='%d',[check3]='%d' where [id]='%s' ", m_name1,m_name2,m_phone1,m_phone2,m_qq1,m_qq2,m_addr1,m_addr2,m_occupation1,m_occupation2,m_birthday1,m_birthday2,m_area,m_area2,m_check1,m_check2,m_check3,id); #endif sql += sql2; //////////////////////// if (atoi(g_cominfoarray.ElementAt(0).ElementAt(117)))//新摄控本 { CString timestamp; CTime tm = CTime::GetCurrentTime(); CTimeSpan dt(0, 0, 0, 1); timestamp = tm.Format("%Y%m%d%H%M%S"); CString phone, clothescount; if (m_time2 != "" && m_time2old != m_time2) { phone = m_phone1 + " " + m_phone2; phone.TrimLeft(); if (m_clothescount != "") clothescount = "服装:" + m_clothescount; if (m_time2old == "") sql2.Format("***insert into [todaytake]([name],[phone],[time],[type],[price],[waiter1],[waiter2],[receptionist],[arrearage],[remark],[clerk],[timestamp],[date],[mode],[arrive],[id])values('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%d','%s','%s')", m_name1 + m_name2, phone, "", taoxiname, m_taoxijiage, m_waiter1, m_waiter2, ren, m_taoxijiage, clothescount, g_user.name, timestamp, m_time2, 0, "未到", id); else sql2.Format("***update [todaytake] set [date]='%s' where [id]='%s' and [mode]='%d'", m_time2, id, 0); sql += sql2; // AfxMessageBox(sql2); } if (m_time4 != "" && m_time4old != m_time4) { tm += dt; timestamp = tm.Format("%Y%m%d%H%M%S"); phone = m_phone1 + " " + m_phone2; phone.TrimLeft(); if (m_clothescount != "") clothescount = "服装:" + m_clothescount; if (m_time4old == "") sql2.Format("***insert into [todaytake]([name],[phone],[time],[type],[price],[waiter1],[waiter2],[receptionist],[arrearage],[remark],[clerk],[timestamp],[date],[mode],[arrive],[id])values('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%d','%s','%s')", m_name1 + m_name2, phone, "", taoxiname, m_taoxijiage, m_waiter1, m_waiter2, ren, m_taoxijiage, clothescount, g_user.name, timestamp, m_time4, 1, "未到", id); else sql2.Format("***update [todaytake] set [date]='%s' where [id]='%s' and [mode]='%d'", m_time4, id, 1); sql += sql2; } if (m_time6 != "" && m_time6old != m_time6) { tm += dt; timestamp = tm.Format("%Y%m%d%H%M%S"); phone = m_phone1 + " " + m_phone2; phone.TrimLeft(); if (m_clothescount != "") clothescount = "服装:" + m_clothescount; if (m_time6old == "") sql2.Format("***insert into [todaytake]([name],[phone],[time],[type],[price],[waiter1],[waiter2],[receptionist],[arrearage],[remark],[clerk],[timestamp],[date],[mode],[arrive],[id])values('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%d','%s','%s')", m_name1 + m_name2, phone, "", taoxiname, m_taoxijiage, m_waiter1, m_waiter2, ren, m_taoxijiage, clothescount, g_user.name, timestamp, m_time6, 2, "未到", id); else sql2.Format("***update [todaytake] set [date]='%s' where [id]='%s' and [mode]='%d'", m_time6, id, 2); sql += sql2; } if (m_time5 != "" && m_time5old != m_time5) { tm += dt; timestamp = tm.Format("%Y%m%d%H%M%S"); phone = m_phone1 + " " + m_phone2; phone.TrimLeft(); if (m_clothescount != "") clothescount = "服装:" + m_clothescount; if (m_time5old == "") sql2.Format("***insert into [todaytake]([name],[phone],[time],[type],[price],[waiter1],[waiter2],[receptionist],[arrearage],[remark],[clerk],[timestamp],[date],[mode],[arrive],[id])values('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%d','%s','%s')", m_name1 + m_name2, phone, "", taoxiname, m_taoxijiage, m_waiter1, m_waiter2, ren, m_taoxijiage, clothescount, g_user.name, timestamp, m_time5, 3, "未到", id); else sql2.Format("***update [todaytake] set [date]='%s' where [id]='%s' and [mode]='%d'", m_time5, id, 3); sql += sql2; } } //////////////////////////// #ifndef CHILD_VERSION if(m_time3.IsEmpty ()==0) { CString date=m_time3; CString date2; if(m_check3) CovertDate(date, date2); sql2.Format ("***update dindansp set hqdate='%s' where id='%s' and hqdate is null", date, id); sql+=sql2; if(0)//atoi(g_cominfoarray.ElementAt(0).ElementAt(117)))//新摄控本 { CString timestamp; CTime tm=CTime::GetCurrentTime (); CTimeSpan dt(0,0,0,10); tm+=dt; timestamp=tm.Format ("%Y%m%d%H%M%S"); CString phone,clothescount,content; for(int i=0; iProcessChatMessageRequest2(sql); if (g_bSendOK == 0)return; CArraysparray; if (m_bGrowthTX) sparray.SetSize(m_page1.m_List1arraygrowthbak.GetSize() + m_page1.m_List3.GetItemCount() + m_page1.m_listbox1.GetCount(), 1); else sparray.SetSize(m_page1.m_List1.GetItemCount() + m_page1.m_List3.GetItemCount() + m_page1.m_listbox1.GetCount(), 1); int realcount = 0; int i; if (m_bGrowthTX) { for (i = 0; i < m_page1.m_List1arraygrowthbak.GetSize(); i++) { int arraygrowthbaksize = m_page1.m_List1arraygrowthbak.ElementAt(i).GetSize(); str = m_page1.m_List1arraygrowthbak.ElementAt(i).ElementAt(2); str.TrimLeft(); str.TrimRight(); if (str.IsEmpty()) continue; sparray.ElementAt(realcount).Add(id); sparray.ElementAt(realcount).Add(m_page1.m_List1arraygrowthbak.ElementAt(i).ElementAt(0)); sparray.ElementAt(realcount).Add(m_page1.m_List1arraygrowthbak.ElementAt(i).ElementAt(1)); sparray.ElementAt(realcount).Add(m_page1.m_List1arraygrowthbak.ElementAt(i).ElementAt(2)); sparray.ElementAt(realcount).Add(m_page1.m_List1arraygrowthbak.ElementAt(i).ElementAt(3)); sparray.ElementAt(realcount).Add(m_page1.m_List1arraygrowthbak.ElementAt(i).ElementAt(4)); sparray.ElementAt(realcount).Add("1"); sparray.ElementAt(realcount).Add(m_page1.m_List1arraygrowthbak.ElementAt(i).ElementAt(5)); sparray.ElementAt(realcount).Add(m_page1.m_List1arraygrowthbak.ElementAt(i).ElementAt(6)); sparray.ElementAt(realcount).Add(m_page1.m_List1arraygrowthbak.ElementAt(i).ElementAt(arraygrowthbaksize - 1)); realcount++; } } else { for (i = 0; i < m_page1.m_List1.GetItemCount(); i++) { str = m_page1.m_List1.GetItemText(i, 2); str.TrimLeft(); str.TrimRight(); if (str.IsEmpty()) continue; sparray.ElementAt(realcount).Add(id); sparray.ElementAt(realcount).Add(m_page1.m_List1.GetItemText(i, 0)); sparray.ElementAt(realcount).Add(m_page1.m_List1.GetItemText(i, 1)); sparray.ElementAt(realcount).Add(m_page1.m_List1.GetItemText(i, 2)); sparray.ElementAt(realcount).Add(m_page1.m_List1.GetItemText(i, 3)); sparray.ElementAt(realcount).Add(m_page1.m_List1.GetItemText(i, 4)); sparray.ElementAt(realcount).Add("1"); sparray.ElementAt(realcount).Add(m_page1.m_List1.GetItemText(i, 5)); sparray.ElementAt(realcount).Add(m_page1.m_List1.GetItemText(i, 6)); realcount++; } } for (i = 0; i < m_page1.m_List3.GetItemCount(); i++) { str = m_page1.m_List3.GetItemText(i, 2); str.TrimLeft(); str.TrimRight(); if (str.IsEmpty())continue; sparray.ElementAt(realcount).Add(id); sparray.ElementAt(realcount).Add(m_page1.m_List3.GetItemText(i, 0)); sparray.ElementAt(realcount).Add(m_page1.m_List3.GetItemText(i, 1)); sparray.ElementAt(realcount).Add(m_page1.m_List3.GetItemText(i, 2)); sparray.ElementAt(realcount).Add(m_page1.m_List3.GetItemText(i, 3)); sparray.ElementAt(realcount).Add(m_page1.m_List3.GetItemText(i, 4)); sparray.ElementAt(realcount).Add("2"); sparray.ElementAt(realcount).Add(""); sparray.ElementAt(realcount).Add(""); realcount++; } for (i = 0; i < m_page1.m_listbox1.GetCount(); i++) { m_page1.m_listbox1.GetText(i, str); sparray.ElementAt(realcount).Add(id); sparray.ElementAt(realcount).Add(str); realcount++; } sparray.SetSize(realcount, 1); if (realcount == 0) { sparray.SetSize(1, 1); sparray.ElementAt(0).Add(id); realcount++; } sparray.SetSize(realcount + 1, 1); sparray.ElementAt(realcount).Add(g_user.name); CMemFile memfile; CArchive ar(&memfile, CArchive::store); for (int ii = 0; ii < sparray.GetSize(); ii++) { sparray.ElementAt(ii).Serialize(ar); } ar.Close(); int length = memfile.GetLength(); BYTE *pData = memfile.Detach(); int size = sparray.GetSize(); BYTE *pData2 = new BYTE[length + sizeof(int)]; memcpy(pData2, pData, length); memcpy(pData2 + length, &size, sizeof(int)); delete[]pData; length += sizeof(int); g_nSendCode = 8; g_pMainWnd->ProcessChatMessageRequest2(pData2, length); g_nSendCode = 0; delete[]pData2; if (g_bSendOK == 0)return; #ifdef CHILD_VERSION if (m_time3.IsEmpty() == 0) { sql.Format("update dindansp set hqdate='%s' where id='%s'", m_time3, id); g_sendhead.bsql = 1; g_pMainWnd->ProcessChatMessageRequest2(sql); if (g_bSendOK == 0)return; } #endif AfxMessageBox("保存成功!", MB_ICONINFORMATION); } void Booking2::OnBUTnew() { // TODO: Add your control notification handler code here m_page1.NewDan(); m_page2.NewDan(); m_page3.NewDan(); m_page4.NewDan(); OnBUTinfo1(); GetDlgItem(IDC_BUTprint)->EnableWindow(0); GetDlgItem(IDC_BUTsave)->EnableWindow(1); } void Booking2::OnBUTprint() { // TODO: Add your control notification handler code here g_pMainWnd->PrintDinDan(m_page1.m_id); } void Booking2::OnBUTimport() { if (AfxMessageBox("是否导入订单?", MB_YESNO | MB_ICONINFORMATION) != IDYES) return; CFileDialog fdlg(true, NULL, "", OFN_HIDEREADONLY, "影楼订单文件(*.*)|*.dan||"); if (fdlg.DoModal() != IDOK) return; CString path = fdlg.GetFileName(); CArrayg_Sel1array[20];//精英团队 CArrayg_Sel2array[20];//景点介绍 CArrayg_Sel3array[20];//套系内容 CArrayg_Sel4array[20];//产品展示 CArrayg_Sel5array[20];//礼服介绍 CString g_name1; CString g_name2; CString g_phone1; CString g_phone2; CString g_price1; CString g_price2; CString m_taoxiname; { CString str = path; int pos = str.Find("."); if (pos == -1)return; str = str.Left(pos); pos = str.Find(" "); if (pos == -1)return; g_name1 = str.Left(pos); str = str.Right(str.GetLength() - pos - 1); pos = str.Find(" "); if (pos == -1)return; g_name2 = str.Left(pos); str = str.Right(str.GetLength() - pos - 1); pos = str.Find(" "); if (pos == -1)return; g_phone1 = str.Left(pos); str = str.Right(str.GetLength() - pos - 1); pos = str.Find(" "); if (pos == -1)return; g_phone2 = str.Left(pos); str = str.Right(str.GetLength() - pos - 1); } int length[100]; CFile fp; fp.Open(path, CFile::modeRead); int fileleng = fp.GetLength(); int memlength = fileleng - sizeof(int) * 100; int i = 0; for ( i = 0; i < 100; i++) fp.Read(length + i, sizeof(int)); for (i = 0; i < 20; i++) g_Sel1array[i].SetSize(length[i]); for (i = 0; i < 20; i++) g_Sel2array[i].SetSize(length[20 + i]); for (i = 0; i < 20; i++) g_Sel3array[i].SetSize(length[40 + i]); for (i = 0; i < 20; i++) g_Sel4array[i].SetSize(length[60 + i]); for (i = 0; i < 20; i++) g_Sel5array[i].SetSize(length[80 + i]); BYTE *pData = new BYTE[memlength]; fp.Read(pData, memlength); fp.Close(); CMemFile memfile; memfile.Attach(pData, memlength); CArchive ar(&memfile, CArchive::load); for (i = 0; i < 20; i++) { for (int j = 0; j < length[i]; j++) g_Sel1array[i].ElementAt(j).Serialize(ar); } for (i = 0; i < 20; i++) { for (int j = 0; j < g_Sel2array[i].GetSize(); j++) g_Sel2array[i].ElementAt(j).Serialize(ar); } for (i = 0; i < 20; i++) { for (int j = 0; j < g_Sel3array[i].GetSize(); j++) g_Sel3array[i].ElementAt(j).Serialize(ar); } for (i = 0; i < 20; i++) { for (int j = 0; j < g_Sel4array[i].GetSize(); j++) g_Sel4array[i].ElementAt(j).Serialize(ar); } for (i = 0; i < 20; i++) { for (int j = 0; j < g_Sel5array[i].GetSize(); j++) g_Sel5array[i].ElementAt(j).Serialize(ar); } ar.Close(); memfile.Detach(); delete[]pData; if (g_Sel5array[19].GetSize()) { g_price1 = g_Sel5array[19].ElementAt(0).ElementAt(0); g_price2 = g_Sel5array[19].ElementAt(0).ElementAt(1); } else { g_price1 = g_price2 = ""; } CStringArray array; for (i = 0; i < 19; i++) { for (int j = 0; j < g_Sel3array[i].GetSize(); j++) { if (g_Sel3array[i].ElementAt(j).GetSize() < 2)continue; int count = g_Sel3array[i].ElementAt(j).GetSize(); for (int a = 1; a < count; a++) { if (a == 1) { m_taoxiname = g_Sel3array[i].ElementAt(j).ElementAt(a); // m_combotaoxiname.InsertString (0, taoxiname); // m_combotaoxiname.SetCurSel (0); } else { CString str = g_Sel3array[i].ElementAt(j).ElementAt(a); CString dir, name; int pos = str.ReverseFind('\\'); dir = str.Left(pos); name = str.Right(str.GetLength() - pos - 1); array.Add(name); } } } } for (i = 0; i < 19; i++) { for (int j = 0; j < g_Sel4array[i].GetSize(); j++) { int count = g_Sel4array[i].ElementAt(j).GetSize(); for (int a = 1; a < count; a++) { array.Add(g_Sel4array[i].ElementAt(j).ElementAt(a)); } } } for (i = 0; i < array.GetSize(); i++) { int pos = m_page1.m_List1.GetItemCount(); CString str; if (pos) { if (m_page1.m_List1.GetItemText(pos - 1, 0).IsEmpty() && m_page1.m_List1.GetItemText(pos - 1, 1).IsEmpty()) { pos--; m_page1.m_List1.SetItemText(pos, 0, ""); m_page1.m_List1.SetItemText(pos, 1, array.ElementAt(i)); m_page1.m_List1.SetItemText(pos, 2, ""); m_page1.m_List1.SetItemText(pos, 3, "1"); } else { m_page1.m_List1.InsertItem(pos, ""); m_page1.m_List1.SetItemText(pos, 1, array.ElementAt(i)); m_page1.m_List1.SetItemText(pos, 2, ""); m_page1.m_List1.SetItemText(pos, 3, "1"); } } else { m_page1.m_List1.InsertItem(pos, ""); m_page1.m_List1.SetItemText(pos, 1, array.ElementAt(i)); m_page1.m_List1.SetItemText(pos, 2, ""); m_page1.m_List1.SetItemText(pos, 3, "1"); } } if (g_Sel5array[19].GetSize()) { g_price1 = g_Sel5array[19].ElementAt(0).ElementAt(0); g_price2 = g_Sel5array[19].ElementAt(0).ElementAt(1); } else { g_price1 = g_price2 = ""; } OnBUTnew(); m_page1.m_taoxiname = m_taoxiname; m_page1.m_taoxijiage = g_price1; m_page1.m_payed1 = g_price2; m_page1.UpdateData(0); m_page2.m_name1 = g_name1; m_page2.m_name2 = g_name2; m_page2.m_phone1 = g_phone1; m_page2.m_phone2 = g_phone2; m_page2.UpdateData(0); } BOOL Booking2::PreTranslateMessage(MSG* pMsg) { // TODO: Add your specialized code here and/or call the base class try { if (pMsg->message == WM_KEYDOWN) { switch (pMsg->wParam) { case VK_ESCAPE: if (m_bModify)CDialog::OnCancel(); return 1; } } return CDialog::PreTranslateMessage(pMsg); } catch (...) { } return true; }