ShowMemberBlue.cpp 12 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501
  1. // ShowMemberBlue.cpp : implementation file
  2. //
  3. #include "stdafx.h"
  4. #include "ylgl.h"
  5. #include "ShowMemberBlue.h"
  6. #include "MyMdi.H"
  7. #include "AddMember.h"
  8. #include "ShowMemberReg.h"
  9. #include "InputCard2Dlg.h"
  10. #include "ShowCard2Reg.h"
  11. #include "InputCard2PointBlue.h"
  12. #include "UsePointBlue.h"
  13. #include "SendMsgDlg.h"
  14. #ifdef _DEBUG
  15. #define new DEBUG_NEW
  16. #undef THIS_FILE
  17. static char THIS_FILE[] = __FILE__;
  18. #endif
  19. #pragma comment(lib, "Shlwapi.lib")
  20. /////////////////////////////////////////////////////////////////////////////
  21. // ShowMemberBlue
  22. IMPLEMENT_DYNCREATE(ShowMemberBlue, MyFormView)
  23. ShowMemberBlue::ShowMemberBlue() : MyFormView(ShowMemberBlue::IDD)
  24. {
  25. m_filter = _T("");
  26. }
  27. ShowMemberBlue::~ShowMemberBlue()
  28. {
  29. }
  30. void ShowMemberBlue::DoDataExchange(CDataExchange* pDX)
  31. {
  32. MyFormView::DoDataExchange(pDX);
  33. //{{AFX_DATA_MAP(ShowMemberBlue)
  34. DDX_Control(pDX, IDC_LIST2, m_List1);
  35. DDX_Control(pDX, IDC_STATIC1, m_static1);
  36. DDX_Text(pDX, IDC_EDIT4, m_filter);
  37. //}}AFX_DATA_MAP
  38. }
  39. BEGIN_MESSAGE_MAP(ShowMemberBlue, MyFormView)
  40. //{{AFX_MSG_MAP(ShowMemberBlue)
  41. ON_BN_CLICKED(IDC_BUTclose, OnBUTclose)
  42. ON_BN_CLICKED(IDC_BUTTON1, OnButton1)
  43. ON_WM_TIMER()
  44. ON_BN_CLICKED(IDC_BUTTON2, OnButton2)
  45. ON_NOTIFY(NM_DBLCLK, IDC_LIST2, OnDblclkList2)
  46. ON_BN_CLICKED(IDC_BUTTON3, OnButton3)
  47. ON_BN_CLICKED(IDC_BUTTON4, OnButton4)
  48. ON_BN_CLICKED(IDC_BUTTON5, OnButton5)
  49. ON_BN_CLICKED(IDC_BUTTON6, OnButton6)
  50. ON_BN_CLICKED(IDC_BUTTON10, OnButton10)
  51. ON_BN_CLICKED(IDC_BUTTON11, OnButton11)
  52. ON_BN_CLICKED(IDC_BUTTON9, OnButton9)
  53. //}}AFX_MSG_MAP
  54. END_MESSAGE_MAP()
  55. /////////////////////////////////////////////////////////////////////////////
  56. // ShowMemberBlue diagnostics
  57. #ifdef _DEBUG
  58. void ShowMemberBlue::AssertValid() const
  59. {
  60. MyFormView::AssertValid();
  61. }
  62. void ShowMemberBlue::Dump(CDumpContext& dc) const
  63. {
  64. MyFormView::Dump(dc);
  65. }
  66. #endif
  67. void ShowMemberBlue::OnInitialUpdate()
  68. {
  69. MyFormView::OnInitialUpdate();
  70. CMyMdi Mdi;
  71. Mdi.SetSubView((CWnd*)GetParent(), (CWnd*)this);
  72. GetDlgItem(IDC_BUTTON5)->EnableWindow(IsHasRights2new(49));
  73. CRect rc2;
  74. GetWindowRect(rc2);
  75. ::MoveWindow(m_hWnd,g_rc.left,g_rc.top,g_rc.Width(),g_rc.Height(),TRUE);
  76. EnumChildWindows(m_hWnd,(WNDENUMPROC)EnumChildProc,0);
  77. int idarray[]={IDC_BUTTON2,IDC_BUTTON5,IDC_BUTTON10,IDC_BUTTON11,IDC_BUTTON6,IDC_BUTTON4,IDC_BUTTON3,IDC_BUTclose};
  78. int idcount=8;
  79. int btnwid;
  80. CRect prerc;
  81. for(int a=idcount-2; a>=0; a--)
  82. {
  83. GetDlgItem(idarray[a+1])->GetWindowRect (prerc);
  84. ScreenToClient(prerc);
  85. GetDlgItem(idarray[a])->GetWindowRect (rc2);
  86. ScreenToClient(rc2);
  87. btnwid=rc2.Width ();
  88. rc2.right =prerc.left ;
  89. rc2.left =rc2.right -btnwid;
  90. GetDlgItem(idarray[a])->MoveWindow (rc2);
  91. }
  92. m_static1.SetFont (&g_titlefont);
  93. m_List1.SetHeadings("id,0;会员卡卡号,100;姓名,100;性别,100;电话,100;QQ,100;地址,100;职业,100;生日,100;套系金额,100;可返金额,100;已返现金,100;余额,100;办卡日期,100" );
  94. m_List1.LoadColumnInfo (168);
  95. g_sendhead.bsql=0;
  96. g_sendhead.code[0]=130;
  97. g_sendhead.tabcount=1;
  98. g_pMainWnd->ProcessChatMessageRequest2(1);if(g_bSendOK==0)return;
  99. DataToArray(&m_List1array);
  100. HidePrice();
  101. FillGrid();
  102. }
  103. void ShowMemberBlue::FillGrid()
  104. {
  105. m_List1.DeleteAllItems2 ();
  106. int ii=0;
  107. m_List1.m_arLabels.SetSize( m_List1array.GetSize (), 1 );
  108. int count=0;
  109. if(m_filter.IsEmpty ())
  110. {
  111. for(ii=0; ii<m_List1.m_arLabels.GetSize (); ii++)
  112. {
  113. m_List1.m_arLabels.ElementAt (count++).Copy (m_List1array.ElementAt (ii));
  114. }
  115. }
  116. else
  117. {
  118. int type=GetType(m_filter);
  119. if(type==2)//拼音
  120. {
  121. m_filter.MakeUpper ();
  122. for(ii=0; ii<m_List1.m_arLabels.GetSize (); ii++)
  123. {
  124. if(m_List1array.ElementAt (ii).ElementAt (14).Find (m_filter)!=-1)
  125. {
  126. m_List1.m_arLabels.ElementAt (count++).Copy (m_List1array.ElementAt (ii));
  127. }
  128. }
  129. }
  130. else
  131. {
  132. for(ii=0; ii<m_List1.m_arLabels.GetSize (); ii++)
  133. {
  134. if(m_List1array.ElementAt (ii).ElementAt (1).Find (m_filter)!=-1 ||\
  135. m_List1array.ElementAt (ii).ElementAt (2).Find (m_filter)!=-1 || \
  136. m_List1array.ElementAt (ii).ElementAt (3).Find (m_filter)!=-1 || \
  137. m_List1array.ElementAt (ii).ElementAt (4).Find (m_filter)!=-1|| \
  138. m_List1array.ElementAt (ii).ElementAt (5).Find (m_filter)!=-1 || \
  139. m_List1array.ElementAt (ii).ElementAt (6).Find (m_filter)!=-1 || \
  140. m_List1array.ElementAt (ii).ElementAt (7).Find (m_filter)!=-1 || \
  141. m_List1array.ElementAt (ii).ElementAt (8).Find (m_filter)!=-1 || \
  142. m_List1array.ElementAt (ii).ElementAt (9).Find (m_filter)!=-1 || \
  143. m_List1array.ElementAt (ii).ElementAt (10).Find (m_filter)!=-1 )
  144. {
  145. m_List1.m_arLabels.ElementAt (count++).Copy (m_List1array.ElementAt (ii));
  146. }
  147. }
  148. }
  149. }
  150. m_List1.m_arLabels.SetSize(count, 1);
  151. ii=count;
  152. m_List1.m_LabelCount=ii;
  153. m_List1.SetItemCountEx (ii);
  154. CString str;
  155. str.Format ("客人:%d", ii);
  156. SetDlgItemText(IDC_STATIC2, str);
  157. CRect rc;
  158. GetDlgItem(IDC_STATIC2)->GetWindowRect (rc);
  159. ScreenToClient(rc);
  160. InvalidateRect(rc);
  161. }
  162. void ShowMemberBlue::OnBUTclose()
  163. {
  164. // TODO: Add your control notification handler code here
  165. GetParent()->SendMessage(WM_CLOSE);
  166. }
  167. void ShowMemberBlue::OnTimer(UINT nIDEvent)
  168. {
  169. // TODO: Add your message handler code here and/or call default
  170. KillTimer(nIDEvent);
  171. OnButton1();
  172. }
  173. BOOL ShowMemberBlue::PreTranslateMessage(MSG* pMsg)
  174. {
  175. // TODO: Add your specialized code here and/or call the base class
  176. try
  177. {
  178. if(pMsg->message==WM_KEYDOWN)
  179. {
  180. switch (pMsg->wParam)
  181. {
  182. case VK_RETURN:
  183. OnButton1();
  184. return 1;
  185. case 0x43: // copy
  186. if ( ( GetKeyState( VK_CONTROL ) & 0x80 ) )
  187. {
  188. GetFocus()->SendMessage(WM_COPY);
  189. return TRUE;
  190. }
  191. break;
  192. case 0x56: //Ctrl + V:
  193. if ( ( GetKeyState( VK_CONTROL ) & 0x80 ) )
  194. {
  195. GetFocus()->SendMessage(WM_PASTE);
  196. return TRUE;
  197. }
  198. break;
  199. case 0x58: // cut
  200. if ( ( GetKeyState( VK_CONTROL ) & 0x80 ) )
  201. {
  202. GetFocus()->SendMessage(WM_CUT);
  203. return TRUE;
  204. }
  205. break;
  206. case 0x5A: //undo
  207. case 0x59: //redo
  208. if ( ( GetKeyState( VK_CONTROL ) & 0x80 ) )
  209. {
  210. GetFocus()->SendMessage(WM_UNDO);
  211. return TRUE;
  212. }
  213. break;
  214. }
  215. }
  216. return MyFormView::PreTranslateMessage(pMsg);
  217. }
  218. catch(...)
  219. {
  220. }
  221. return true;
  222. }
  223. void ShowMemberBlue::OnButton1()
  224. {
  225. // TODO: Add your control notification handler code here
  226. UpdateData();
  227. m_filter.TrimLeft ();
  228. m_filter.TrimRight ();
  229. FillGrid();
  230. }
  231. void ShowMemberBlue::OnButton2() // 新增会员 按钮;
  232. {
  233. // TODO: Add your control notification handler code here
  234. AddMember dlg;
  235. dlg.m_mode=1;
  236. if(dlg.DoModal ()==IDOK)
  237. {
  238. g_sendhead.bsql=0;
  239. g_sendhead.code[0]=130;
  240. g_sendhead.tabcount=1;
  241. g_pMainWnd->ProcessChatMessageRequest2(1);if(g_bSendOK==0)return;
  242. DataToArray(&m_List1array);HidePrice();
  243. OnButton1();
  244. }
  245. }
  246. void ShowMemberBlue::OnDblclkList2(NMHDR* pNMHDR, LRESULT* pResult)
  247. {
  248. // TODO: Add your control notification handler code here
  249. POSITION pos;
  250. pos=m_List1.GetFirstSelectedItemPosition();
  251. if(pos==NULL)
  252. {
  253. return;
  254. }
  255. int iItem=m_List1.GetNextSelectedItem(pos);
  256. CString memberno=m_List1.GetItemText (iItem, 1);
  257. AddMember dlg;
  258. dlg.m_memberno =memberno;
  259. dlg.m_bAdd=0;
  260. dlg.m_mode=1;
  261. if(dlg.DoModal ()==IDOK)
  262. {
  263. g_sendhead.bsql=0;
  264. g_sendhead.code[0]=130;
  265. g_sendhead.tabcount=1;
  266. g_pMainWnd->ProcessChatMessageRequest2(1);if(g_bSendOK==0)return;
  267. DataToArray(&m_List1array);HidePrice();
  268. OnButton1();
  269. }
  270. *pResult = 0;
  271. }
  272. void ShowMemberBlue::OnButton3()
  273. {
  274. // TODO: Add your control notification handler code here
  275. POSITION pos;
  276. pos=m_List1.GetFirstSelectedItemPosition();
  277. if(pos==NULL)
  278. {
  279. AfxMessageBox("请先选中您要发送短信的会员!", MB_ICONINFORMATION);
  280. return;
  281. }
  282. int iItem;
  283. CStringArray array;
  284. while (pos)
  285. {
  286. iItem = m_List1.GetNextSelectedItem(pos);
  287. if(!m_List1.GetItemText (iItem, 4).IsEmpty ())
  288. array.Add (m_List1.GetItemText (iItem, 4));
  289. }
  290. SendMsgDlg dlg;
  291. dlg.m_mode=1;
  292. dlg.m_pArray=&array;
  293. dlg.DoModal ();
  294. }
  295. void ShowMemberBlue::OnButton4()
  296. {
  297. // TODO: Add your control notification handler code here
  298. POSITION pos;
  299. pos=m_List1.GetFirstSelectedItemPosition();
  300. if(pos==NULL)
  301. {
  302. AfxMessageBox("请先选中要取现的会员!");
  303. return;
  304. }
  305. int iItem=m_List1.GetNextSelectedItem(pos);
  306. CString m_memberno=m_List1.GetItemText (iItem, 1);
  307. CString m_name=m_List1.GetItemText (iItem, 2);
  308. UsePointBlue dlg;
  309. dlg.m_memberno=m_memberno;
  310. dlg.m_name=m_name;
  311. dlg.m_point =m_List1.GetItemText (iItem,12);
  312. if(dlg.DoModal ()!=IDOK)return;
  313. g_sendhead.bsql=0;
  314. g_sendhead.code[0]=130;
  315. g_sendhead.tabcount=1;
  316. g_pMainWnd->ProcessChatMessageRequest2(1);if(g_bSendOK==0)return;
  317. DataToArray(&m_List1array);HidePrice();
  318. FillGrid();
  319. }
  320. void ShowMemberBlue::OnButton5() // 删除会员 按钮;
  321. {
  322. if(IsHasRights2new(49)==0)return;
  323. // TODO: Add your control notification handler code here
  324. POSITION pos;
  325. pos=m_List1.GetFirstSelectedItemPosition();
  326. if(pos==NULL)
  327. {
  328. AfxMessageBox("请先选中您要删除的会员!");
  329. return;
  330. }
  331. if(AfxMessageBox("删除后将不可恢复, 确认吗?", MB_YESNO|MB_ICONINFORMATION)!=IDYES)return;
  332. int iItem=m_List1.GetNextSelectedItem(pos);
  333. CString id=m_List1.GetItemText (iItem, 0);
  334. CString sql;
  335. sql.Format ("delete from [membermanageblue] where [autoid]=%s", id);
  336. g_sendhead.bsql=1;
  337. g_pMainWnd->ProcessChatMessageRequest2(sql);if(g_bSendOK==0)return;
  338. g_sendhead.bsql=0;
  339. g_sendhead.code[0]=130;
  340. g_sendhead.tabcount=1;
  341. g_pMainWnd->ProcessChatMessageRequest2(1);if(g_bSendOK==0)return;
  342. DataToArray(&m_List1array);HidePrice();
  343. FillGrid();
  344. }
  345. void ShowMemberBlue::OnButton6()
  346. {
  347. // TODO: Add your control notification handler code handler
  348. if(IsHasRights2new(18)==0)return;
  349. // TODO: Add your control notification code
  350. POSITION pos;
  351. pos=m_List1.GetFirstSelectedItemPosition();
  352. if(pos==NULL)
  353. {
  354. AfxMessageBox("请先选中您要返现的会员!");
  355. return;
  356. }
  357. int iItem=m_List1.GetNextSelectedItem(pos);
  358. CString m_memberno=m_List1.GetItemText (iItem, 1);
  359. CString m_name=m_List1.GetItemText (iItem, 2);
  360. CString m_sex=m_List1.GetItemText (iItem, 3);
  361. CString m_phone=m_List1.GetItemText (iItem, 4);
  362. CString m_jiage=m_List1.GetItemText (iItem, 9);
  363. InputCard2PointBlue dlg;
  364. dlg.m_memberno=m_memberno;
  365. dlg.m_name=m_name;
  366. dlg.m_sex=m_sex;
  367. dlg.m_phone=m_phone;
  368. dlg.m_jiage=m_jiage;
  369. if(dlg.DoModal ()!=IDOK)return;
  370. g_sendhead.bsql=0;
  371. g_sendhead.code[0]=130;
  372. g_sendhead.tabcount=1;
  373. g_pMainWnd->ProcessChatMessageRequest2(1);if(g_bSendOK==0)return;
  374. DataToArray(&m_List1array);HidePrice();
  375. FillGrid();
  376. }
  377. void ShowMemberBlue::OnButton10() // 发放副卡 按钮;
  378. {
  379. if(IsHasRights2new(18)==0)return;
  380. POSITION pos;
  381. pos=m_List1.GetFirstSelectedItemPosition();
  382. if(pos==NULL)
  383. {
  384. AfxMessageBox("请先选中主卡!");
  385. return;
  386. }
  387. int iItem=m_List1.GetNextSelectedItem(pos);
  388. CString name=m_List1.GetItemText (iItem, 2);
  389. CString no=m_List1.GetItemText (iItem, 1);
  390. CString sql="select count(*) as cot from membercard2blue where [memberno]='"+no+"'";
  391. g_sendhead.bsql=1;
  392. g_pMainWnd->ProcessChatMessageRequest2(sql);
  393. if (g_bSendOK == 0)return;
  394. if(g_ncount==0)
  395. {
  396. InputCard2Dlg dlg;
  397. dlg.m_mode=1;
  398. dlg.m_name =name;
  399. dlg.m_no =no;
  400. dlg.DoModal ();
  401. }
  402. else
  403. {
  404. int cardnum=atoi(g_cominfoarray.ElementAt (0).ElementAt (118));
  405. if(cardnum==0)cardnum=5;
  406. if(g_ncount>=cardnum)
  407. {
  408. AfxMessageBox("副卡已经发出,不能再次发放!", MB_ICONINFORMATION);return;
  409. }
  410. InputCard2Dlg dlg;
  411. dlg.m_bAddOne =1;
  412. dlg.m_mode=1;
  413. dlg.m_name =name;
  414. dlg.m_no =no;
  415. dlg.DoModal ();
  416. }
  417. }
  418. void ShowMemberBlue::OnButton11()
  419. {
  420. // TODO: Add your control notification handler code here
  421. if(IsHasRights2new(18)==0)return;
  422. // TODO: Add your control notification handler code here
  423. POSITION pos;
  424. pos=m_List1.GetFirstSelectedItemPosition();
  425. if(pos==NULL)
  426. {
  427. AfxMessageBox("请先选中主卡!");
  428. return;
  429. }
  430. int iItem=m_List1.GetNextSelectedItem(pos);
  431. CString no=m_List1.GetItemText (iItem, 1);
  432. CString filter="[memberno]='"+no+"'";
  433. g_sendhead.bsql=0;
  434. g_sendhead.code[0]=131;
  435. g_sendhead.tabcount=1;
  436. g_pMainWnd->ProcessChatMessageRequest2(filter);if(g_bSendOK==0)return;
  437. DataToArray(&g_List1array);
  438. if(g_List1array.GetSize ()==0)
  439. {
  440. AfxMessageBox("此主卡未发放副卡!");
  441. }
  442. else
  443. {
  444. ShowCard2Reg dlg;
  445. dlg.m_memberno=no;
  446. dlg.m_name =m_List1.GetItemText (iItem, 2);
  447. dlg.m_mode=1;
  448. dlg.DoModal ();
  449. }
  450. }
  451. void ShowMemberBlue::HidePrice()
  452. {
  453. #ifdef LKAY_VERSION
  454. if(IsHasRights2new(31))return;
  455. for(int i=0; i< m_List1array.GetSize (); i++)
  456. {
  457. m_List1array.ElementAt (i).SetAt (4, "***");
  458. }
  459. #endif
  460. }
  461. void ShowMemberBlue::OnButton9() // 导出xls;
  462. {
  463. ListToXLS(&m_List1, _T("C:\\蓝钻会员.xls"), 0, 0);
  464. }