SearchTake5.cpp 14 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560
  1. // SearchTake5.cpp : implementation file
  2. //
  3. #include "stdafx.h"
  4. #include "ylgl.h"
  5. #include "SearchTake5.h"
  6. #include "TakeControlDlg9.h"
  7. #include "SearchFilter2.h"
  8. #include "InputDate.h"
  9. #ifdef _DEBUG
  10. #define new DEBUG_NEW
  11. #undef THIS_FILE
  12. static char THIS_FILE[] = __FILE__;
  13. #endif
  14. /////////////////////////////////////////////////////////////////////////////
  15. // SearchTake5 dialog
  16. SearchTake5::SearchTake5(CWnd* pParent /*=NULL*/)
  17. : CDialog(SearchTake5::IDD, pParent)
  18. {
  19. //{{AFX_DATA_INIT(SearchTake5)
  20. m_filter = _T("");
  21. m_radio1 = 1;
  22. //}}AFX_DATA_INIT
  23. }
  24. void SearchTake5::DoDataExchange(CDataExchange* pDX)
  25. {
  26. CDialog::DoDataExchange(pDX);
  27. //{{AFX_DATA_MAP(SearchTake5)
  28. DDX_Control(pDX, IDC_COMBO1, m_combo1);
  29. DDX_Control(pDX, IDC_LIST2, m_List1);
  30. DDX_CBString(pDX, IDC_COMBO1, m_filter);
  31. DDX_Radio(pDX, IDC_RADIO1, m_radio1);
  32. //}}AFX_DATA_MAP
  33. }
  34. BEGIN_MESSAGE_MAP(SearchTake5, CDialog)
  35. //{{AFX_MSG_MAP(SearchTake5)
  36. ON_BN_CLICKED(IDC_BUTTON1, OnButton1)
  37. ON_BN_CLICKED(IDC_RADIO1, OnRadio1)
  38. ON_BN_CLICKED(IDC_RADIO2, OnRadio2)
  39. ON_BN_CLICKED(IDC_RADIO9, OnRadio9)
  40. ON_CBN_CLOSEUP(IDC_COMBO1, OnCloseupCombo1)
  41. ON_CBN_SELCHANGE(IDC_COMBO1, OnSelchangeCombo1)
  42. ON_WM_TIMER()
  43. ON_BN_CLICKED(IDC_BUTTON2, OnButton2)
  44. ON_BN_CLICKED(IDC_BTNSEARCHFILTER, OnBtnsearchfilter)
  45. ON_BN_CLICKED(IDC_BUTTON3, OnButton3)
  46. //}}AFX_MSG_MAP
  47. END_MESSAGE_MAP()
  48. /////////////////////////////////////////////////////////////////////////////
  49. // SearchTake5 message handlers
  50. extern BOOL CALLBACK EnumChildProc2(HWND hwnd,LPARAM lParam);
  51. extern float m_WidthScale2;
  52. extern float m_HeightScale2;
  53. BOOL SearchTake5::OnInitDialog()
  54. {
  55. CDialog::OnInitDialog();
  56. // TODO: Add extra initialization here
  57. CRect rc2;
  58. GetWindowRect(rc2);
  59. ::MoveWindow(m_hWnd,g_rc.left,g_rc.top,g_rc.Width(),g_rc.Height(),TRUE);
  60. m_WidthScale2 = (float)g_rc.Width()/(float)rc2.Width(); // new/Old
  61. m_HeightScale2 = (float)g_rc.Height()/(float)rc2.Height();
  62. EnumChildWindows(m_hWnd,(WNDENUMPROC)EnumChildProc2,0);
  63. m_combo1.GetWindowRect (rc2);
  64. ScreenToClient(rc2);
  65. rc2.bottom +=200;
  66. m_combo1.MoveWindow (rc2);
  67. if(g_bAllBranch==0)
  68. {
  69. m_nAdd=0;
  70. m_List1.SetHeadings("订单号,100;男宾姓名,100;女宾姓名,100;男宾电话,100;女宾电话,100;婚庆内容,100;婚庆日期,100;时间,100;婚期,100;摄影师,100;化妆师,100;接单人,100;套系名称,100;套系价格,100" );
  71. m_List1.LoadColumnInfo (208);
  72. }
  73. else
  74. {
  75. m_nAdd=1;
  76. m_List1.SetHeadings("店名,100;订单号,100;男宾姓名,100;女宾姓名,100;男宾电话,100;女宾电话,100;婚庆内容,100;婚庆日期,100;时间,100;婚期,100;摄影师,100;化妆师,100;接单人,100;套系名称,100;套系价格,100" );
  77. m_List1.LoadColumnInfo (209);
  78. }
  79. GetData();
  80. for(int i=0; i<m_List1array.GetSize (); i++)
  81. {
  82. if(::FindArray (&jdarray, m_List1array.ElementAt (i).ElementAt (5+m_nAdd))==-1)
  83. jdarray.Add (m_List1array.ElementAt (i).ElementAt (5+m_nAdd));
  84. }
  85. m_combo1.AddString ("");
  86. for( i=0; i<jdarray.GetSize (); i++)
  87. {
  88. m_combo1.AddString (jdarray.ElementAt (i));
  89. }
  90. return TRUE; // return TRUE unless you set the focus to a control
  91. // EXCEPTION: OCX Property Pages should return FALSE
  92. }
  93. void SearchTake5::OnButton1()
  94. {
  95. // TODO: Add your control notification handler code here
  96. UpdateData();
  97. m_filter.TrimLeft ();
  98. m_filter.TrimRight ();
  99. FillGrid();
  100. }
  101. void SearchTake5::FillGrid()
  102. {
  103. UpdateData();
  104. if(g_bSearchFilter)
  105. {
  106. m_List1.DeleteAllItems2 ();
  107. int ii=0;
  108. m_List1.m_arLabels.SetSize( m_List1array.GetSize (), 1 );
  109. int count=0;
  110. {
  111. for(ii=0; ii<m_List1.m_arLabels.GetSize (); ii++)
  112. {
  113. if(g_filterdate1!="")
  114. {
  115. if(m_List1array.ElementAt (ii).ElementAt (5+m_nAdd)<g_filterdate1 || m_List1array.ElementAt (ii).ElementAt (5+m_nAdd)>g_filterdate2)
  116. continue;
  117. }
  118. if(g_filterdate3!="")
  119. {
  120. if(m_List1array.ElementAt (ii).ElementAt (6+m_nAdd)<g_filterdate3 || m_List1array.ElementAt (ii).ElementAt (6+m_nAdd)>g_filterdate4)
  121. continue;
  122. }
  123. if(g_filterdate5!="")
  124. {
  125. if(m_List1array.ElementAt (ii).ElementAt (7+m_nAdd)<g_filterdate5 || m_List1array.ElementAt (ii).ElementAt (7+m_nAdd)>g_filterdate6)
  126. continue;
  127. }
  128. if(g_waiter1!="")
  129. {
  130. if(m_List1array.ElementAt (ii).ElementAt (8+m_nAdd)!=g_waiter1)
  131. continue;
  132. }
  133. if(g_bAllBranch && g_filterbranch!="")
  134. {
  135. if(m_List1array.ElementAt (ii).ElementAt (0)!=g_filterbranch)
  136. continue;
  137. }
  138. if(1)
  139. {
  140. m_List1.m_arLabels.ElementAt (count++).Copy (m_List1array.ElementAt (ii));
  141. }
  142. }
  143. }
  144. m_List1.m_arLabels.SetSize(count, 1);
  145. ii=count;
  146. m_List1.m_LabelCount=ii;
  147. m_List1.SetItemCountEx (ii);
  148. CString str;
  149. str.Format ("单数:%d", ii);
  150. SetDlgItemText(IDC_STATIC2, str);
  151. }
  152. else
  153. {
  154. m_List1.DeleteAllItems2 ();
  155. int ii=0;
  156. m_List1.m_arLabels.SetSize( m_List1array.GetSize (), 1 );
  157. int count=0;
  158. if(m_filter.IsEmpty ())
  159. {
  160. for(ii=0; ii<m_List1.m_arLabels.GetSize (); ii++)
  161. {
  162. m_List1.m_arLabels.ElementAt (count++).Copy (m_List1array.ElementAt (ii));
  163. }
  164. }
  165. else
  166. {
  167. int type=GetType(m_filter);
  168. if(type==1)//电话
  169. {
  170. for(ii=0; ii<m_List1.m_arLabels.GetSize (); ii++)
  171. {
  172. if( (m_List1array.ElementAt (ii).ElementAt (3+m_nAdd).Find (m_filter)!=-1 || \
  173. m_List1array.ElementAt (ii).ElementAt (4+m_nAdd).Find (m_filter)!=-1) )
  174. {
  175. m_List1.m_arLabels.ElementAt (count++).Copy (m_List1array.ElementAt (ii));
  176. }
  177. }
  178. }
  179. else if(type==2)//拼音
  180. {
  181. m_filter.MakeUpper ();
  182. for(ii=0; ii<m_List1.m_arLabels.GetSize (); ii++)
  183. {
  184. if( (m_List1array.ElementAt (ii).ElementAt (14+m_nAdd).Find (m_filter)!=-1 || \
  185. m_List1array.ElementAt (ii).ElementAt (15+m_nAdd).Find (m_filter)!=-1) )
  186. {
  187. m_List1.m_arLabels.ElementAt (count++).Copy (m_List1array.ElementAt (ii));
  188. }
  189. }
  190. }
  191. else
  192. {
  193. for(ii=0; ii<m_List1.m_arLabels.GetSize (); ii++)
  194. {
  195. if((m_List1array.ElementAt (ii).ElementAt (0).Find (m_filter)!=-1 ||\
  196. m_List1array.ElementAt (ii).ElementAt (1).Find (m_filter)!=-1 || \
  197. m_List1array.ElementAt (ii).ElementAt (2).Find (m_filter)!=-1 || \
  198. m_List1array.ElementAt (ii).ElementAt (3).Find (m_filter)!=-1 || \
  199. m_List1array.ElementAt (ii).ElementAt (4).Find (m_filter)!=-1 || \
  200. m_List1array.ElementAt (ii).ElementAt (5).Find (m_filter)!=-1 || \
  201. m_List1array.ElementAt (ii).ElementAt (6).Find (m_filter)!=-1 || \
  202. m_List1array.ElementAt (ii).ElementAt (7).Find (m_filter)!=-1 || \
  203. m_List1array.ElementAt (ii).ElementAt (8).Find (m_filter)!=-1 || \
  204. m_List1array.ElementAt (ii).ElementAt (9).Find (m_filter)!=-1 || \
  205. m_List1array.ElementAt (ii).ElementAt (10).Find (m_filter)!=-1|| \
  206. m_List1array.ElementAt (ii).ElementAt (11).Find (m_filter)!=-1|| \
  207. m_List1array.ElementAt (ii).ElementAt (12).Find (m_filter)!=-1|| \
  208. m_List1array.ElementAt (ii).ElementAt (13+m_nAdd).Find (m_filter)!=-1|| \
  209. m_List1array.ElementAt (ii).ElementAt (13).Find (m_filter)!=-1) )
  210. {
  211. m_List1.m_arLabels.ElementAt (count++).Copy (m_List1array.ElementAt (ii));
  212. }
  213. }
  214. }
  215. }
  216. m_List1.m_arLabels.SetSize(count, 1);
  217. ii=count;
  218. m_List1.m_LabelCount=ii;
  219. m_List1.SetItemCountEx (ii);
  220. CString str;
  221. str.Format ("单数:%d", ii);
  222. SetDlgItemText(IDC_STATIC2, str);
  223. }
  224. }
  225. void SearchTake5::OnRadio1()
  226. {
  227. // TODO: Add your control notification handler code here
  228. FillGrid();
  229. }
  230. void SearchTake5::OnRadio2()
  231. {
  232. // TODO: Add your control notification handler code here
  233. FillGrid();
  234. }
  235. void SearchTake5::OnRadio9()
  236. {
  237. // TODO: Add your control notification handler code here
  238. FillGrid();
  239. }
  240. void SearchTake5::OnCloseupCombo1()
  241. {
  242. // TODO: Add your control notification handler code here
  243. SetTimer(1, 100, NULL);
  244. }
  245. void SearchTake5::OnSelchangeCombo1()
  246. {
  247. // TODO: Add your control notification handler code here
  248. SetTimer(1, 100, NULL);
  249. }
  250. void SearchTake5::OnTimer(UINT nIDEvent)
  251. {
  252. // TODO: Add your message handler code here and/or call default
  253. KillTimer(nIDEvent);
  254. OnButton1();
  255. }
  256. void SearchTake5::OnButton2()
  257. {
  258. // TODO: Add your control notification handler code here
  259. POSITION pos;
  260. pos=m_List1.GetFirstSelectedItemPosition();
  261. if(pos==NULL)
  262. {
  263. AfxMessageBox("请先选中您要安排的客人!", MB_ICONINFORMATION);
  264. return;
  265. }
  266. int iItem;
  267. CStringArray idarray;
  268. CStringArray brancharray;
  269. while (pos)
  270. {
  271. iItem = m_List1.GetNextSelectedItem(pos);
  272. idarray.Add (m_List1.GetItemText (iItem, 0+m_nAdd));
  273. if(g_bAllBranch)
  274. brancharray.Add (m_List1.GetItemText (iItem, 0));
  275. }
  276. if(idarray.GetSize ()==1)
  277. {
  278. CString id=idarray.ElementAt (0);
  279. TakeControlDlg9 dlg;
  280. if(g_bAllBranch)
  281. dlg.m_branch=brancharray.ElementAt (0);
  282. dlg.id=id;
  283. dlg.m_bModify=1;
  284. dlg.DoModal ();
  285. }
  286. else
  287. {
  288. TakeControlDlg9 dlg;
  289. dlg.m_pIdArray=&idarray;
  290. dlg.m_pBranchArray=&brancharray;
  291. dlg.m_bModify=1;
  292. dlg.DoModal ();
  293. }
  294. if(g_bAllBranch)
  295. {
  296. if(AfxMessageBox("是否实时更新数据?", MB_YESNO|MB_ICONINFORMATION)!=IDYES)return;
  297. }
  298. GetData();
  299. }
  300. void SearchTake5::OnOK()
  301. {
  302. // TODO: Add extra validation here
  303. }
  304. BOOL SearchTake5::PreTranslateMessage(MSG* pMsg)
  305. {
  306. // TODO: Add your specialized code here and/or call the base class
  307. if(pMsg->message==WM_KEYDOWN)
  308. {
  309. switch (pMsg->wParam)
  310. {
  311. case VK_RETURN:
  312. OnButton1();
  313. return 1;
  314. break;
  315. }
  316. }
  317. return CDialog::PreTranslateMessage(pMsg);
  318. }
  319. void SearchTake5::HidePrice()
  320. {
  321. if(IsHasRights2new(31))return;
  322. for(int i=0; i< m_List1array.GetSize (); i++)
  323. {
  324. m_List1array.ElementAt (i).SetAt (16+m_nAdd, "***");
  325. m_List1array.ElementAt (i).SetAt (17+m_nAdd, "***");
  326. }
  327. }
  328. void SearchTake5::OnBtnsearchfilter()
  329. {
  330. // TODO: Add your control notification handler code here
  331. SearchFilter2 dlg;
  332. dlg.m_pArray=&jdarray;
  333. if(dlg.DoModal ()==IDOK)
  334. {
  335. FillGrid();
  336. }
  337. g_bSearchFilter=0;
  338. }
  339. void SearchTake5::OnButton3()
  340. {
  341. // TODO: Add your control notification handler code here
  342. POSITION pos;
  343. pos=m_List1.GetFirstSelectedItemPosition();
  344. if(pos==NULL)
  345. {
  346. AfxMessageBox("请选中多对客人!", MB_ICONINFORMATION);
  347. return;
  348. }
  349. int iItem;
  350. if(g_bAllBranch)
  351. {
  352. CStringArray idarray[100];
  353. CStringArray jdarray[100];
  354. CStringArray brancharray;
  355. int idcount=0;
  356. int branchpos;
  357. CString branch;
  358. while (pos)
  359. {
  360. iItem = m_List1.GetNextSelectedItem(pos);
  361. branchpos=::FindArray(&brancharray, m_List1.GetItemText (iItem, 0) );if(branchpos>=100)continue;
  362. if(branchpos==-1)
  363. {
  364. branchpos=brancharray.GetSize();
  365. brancharray.Add(m_List1.GetItemText (iItem, 0));
  366. }
  367. idarray[branchpos].Add (m_List1.GetItemText (iItem, 0+m_nAdd));
  368. jdarray[branchpos].Add (m_List1.GetItemText (iItem, 5+m_nAdd));
  369. idcount++;
  370. }
  371. if(idcount==1)
  372. {
  373. AfxMessageBox("请选中多对客人,或者按预约按钮!", MB_ICONINFORMATION);
  374. return;
  375. }
  376. else
  377. {
  378. InputDate dlg;
  379. dlg.m_mode=1;
  380. if(dlg.DoModal ()!=IDOK)return;
  381. for(int aa=0; aa<brancharray.GetSize(); aa++)
  382. {
  383. branch=brancharray.ElementAt(aa);
  384. CString sql;
  385. sql.Format ("update dindansp set [hqdate]='%s',hqtime='' where ", dlg.m_date);
  386. CString filter,temp;
  387. for(int i=0; i<idarray[aa].GetSize (); i++)
  388. {
  389. if(i==0)
  390. temp="[id]='"+idarray[aa].ElementAt (i)+"' and [name]='"+jdarray[aa].ElementAt (i)+"'";
  391. else
  392. temp=" or [id]='"+idarray[aa].ElementAt (i)+"' and [name]='"+jdarray[aa].ElementAt (i)+"'";
  393. filter+=temp;
  394. }
  395. sql+=filter;
  396. g_sendhead.bsql=1;
  397. g_branchip=GetIP(branch);
  398. g_pMainWnd->OnDisconnect();
  399. g_branchname=branch;
  400. g_bBranchModify=1;
  401. g_pMainWnd->ProcessChatMessageRequest2(sql);
  402. g_pMainWnd->OnDisconnect();g_bBranchModify=0;g_branchip=g_branchname="";
  403. if(g_bSendOK==0)
  404. {
  405. sql.Format("保存分店: %s 失败!", branch);
  406. AfxMessageBox(sql, MB_ICONINFORMATION);
  407. continue;
  408. }
  409. }
  410. }
  411. if(AfxMessageBox("是否实时更新数据?", MB_YESNO|MB_ICONINFORMATION)==IDYES)GetData();
  412. }
  413. else
  414. {
  415. CStringArray idarray;
  416. CStringArray jdarray;
  417. while (pos)
  418. {
  419. iItem = m_List1.GetNextSelectedItem(pos);
  420. idarray.Add (m_List1.GetItemText (iItem, 0+m_nAdd));
  421. jdarray.Add (m_List1.GetItemText (iItem, 5+m_nAdd));
  422. }
  423. if(idarray.GetSize ()==1)
  424. {
  425. AfxMessageBox("请选中多对客人,或者按预约按钮!", MB_ICONINFORMATION);
  426. return;
  427. }
  428. else
  429. {
  430. InputDate dlg;
  431. dlg.m_mode=1;
  432. if(dlg.DoModal ()!=IDOK)return;
  433. CString sql;
  434. sql.Format ("update dindansp set [hqdate]='%s',hqtime='' where ", dlg.m_date);
  435. CString filter,temp;
  436. for(int i=0; i<idarray.GetSize (); i++)
  437. {
  438. if(i==0)
  439. temp="[id]='"+idarray.ElementAt (i)+"' and [name]='"+jdarray.ElementAt (i)+"'";
  440. else
  441. temp=" or [id]='"+idarray.ElementAt (i)+"' and [name]='"+jdarray.ElementAt (i)+"'";
  442. filter+=temp;
  443. }
  444. sql+=filter;
  445. g_sendhead.bsql=1;
  446. g_pMainWnd->ProcessChatMessageRequest2(sql);if(g_bSendOK==0)return;
  447. AfxMessageBox("保存成功!", MB_ICONINFORMATION);
  448. }
  449. GetData();
  450. }
  451. }
  452. void SearchTake5::GetData()
  453. {
  454. CString sql;
  455. sql.Format ("kind='2'");
  456. if(g_bAllBranch==0)
  457. {
  458. g_sendhead.code[0]=139;
  459. g_sendhead.tabcount=1;
  460. g_sendhead.bsql=0;
  461. g_pMainWnd->ProcessChatMessageRequest2(sql);if(g_bSendOK==0)return;
  462. DataToArray(&m_List1array);
  463. HidePrice();
  464. FillGrid();
  465. return;
  466. }
  467. //////////////数据汇总
  468. m_List1array.RemoveAll ();
  469. CStringArray failbrancharray;
  470. CString branch;
  471. for(int i=-1; i<g_brancharray.GetSize ()-1; i++)
  472. {
  473. if(i!=-1)
  474. {
  475. branch=g_brancharray.ElementAt (i).ElementAt (0);
  476. g_branchip=g_brancharray.ElementAt (i).ElementAt (1);
  477. g_pMainWnd->OnDisconnect();
  478. g_branchname=branch;
  479. g_bBranchModify=1;
  480. }
  481. else
  482. branch=g_brancharray.ElementAt (g_brancharray.GetSize ()-1).ElementAt (0);
  483. g_sendhead.bsql=0;
  484. g_sendhead.code[0]=139;
  485. g_sendhead.tabcount=1;
  486. g_pMainWnd->ProcessChatMessageRequest2(sql);
  487. if(g_bSendOK==0)
  488. {
  489. failbrancharray.Add (branch);
  490. continue;
  491. }
  492. CArray<CStringArray, CStringArray>List1array;
  493. DataToArray(&List1array);
  494. int size=m_List1array.GetSize ();
  495. for(int j=0; j<List1array.GetSize (); j++)
  496. {
  497. size++;
  498. m_List1array.SetSize(size , 1 );
  499. size--;
  500. m_List1array.ElementAt (size).Copy (List1array.ElementAt (j));
  501. m_List1array.ElementAt (size).InsertAt (0, branch);
  502. size++;
  503. }
  504. }
  505. for(i=0; i<failbrancharray.GetSize (); i++)
  506. {
  507. // AfxMessageBox("连接"+failbrancharray.ElementAt(i)+"服务器失败!", MB_ICONINFORMATION);
  508. }
  509. g_pMainWnd->OnDisconnect();
  510. g_bBranchModify=0;g_branchip=g_branchname="";
  511. HidePrice();
  512. FillGrid();
  513. }