ShowMemberBlue.cpp 12 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498
  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. // 没有权限查看号码,就没有权限发短信;
  275. if (!IsHasRights2new(31))
  276. return;
  277. POSITION pos;
  278. pos=m_List1.GetFirstSelectedItemPosition();
  279. if(pos==NULL)
  280. {
  281. AfxMessageBox("请先选中您要发送短信的会员!", MB_ICONINFORMATION);
  282. return;
  283. }
  284. int iItem;
  285. CStringArray array;
  286. while (pos)
  287. {
  288. iItem = m_List1.GetNextSelectedItem(pos);
  289. if(!m_List1.GetItemText (iItem, 4).IsEmpty ())
  290. array.Add (m_List1.GetItemText (iItem, 4));
  291. }
  292. SendMsgDlg dlg;
  293. dlg.m_mode=1;
  294. dlg.m_pArray=&array;
  295. dlg.DoModal ();
  296. }
  297. void ShowMemberBlue::OnButton4()
  298. {
  299. // TODO: Add your control notification handler code here
  300. POSITION pos;
  301. pos=m_List1.GetFirstSelectedItemPosition();
  302. if(pos==NULL)
  303. {
  304. AfxMessageBox("请先选中要取现的会员!");
  305. return;
  306. }
  307. int iItem=m_List1.GetNextSelectedItem(pos);
  308. CString m_memberno=m_List1.GetItemText (iItem, 1);
  309. CString m_name=m_List1.GetItemText (iItem, 2);
  310. UsePointBlue dlg;
  311. dlg.m_memberno=m_memberno;
  312. dlg.m_name=m_name;
  313. dlg.m_point =m_List1.GetItemText (iItem,12);
  314. if(dlg.DoModal ()!=IDOK)return;
  315. g_sendhead.bsql=0;
  316. g_sendhead.code[0]=130;
  317. g_sendhead.tabcount=1;
  318. g_pMainWnd->ProcessChatMessageRequest2(1);if(g_bSendOK==0)return;
  319. DataToArray(&m_List1array);HidePrice();
  320. FillGrid();
  321. }
  322. void ShowMemberBlue::OnButton5() // 删除会员 按钮;
  323. {
  324. if(IsHasRights2new(49)==0)return;
  325. // TODO: Add your control notification handler code here
  326. POSITION pos;
  327. pos=m_List1.GetFirstSelectedItemPosition();
  328. if(pos==NULL)
  329. {
  330. AfxMessageBox("请先选中您要删除的会员!");
  331. return;
  332. }
  333. if(AfxMessageBox("删除后将不可恢复, 确认吗?", MB_YESNO|MB_ICONINFORMATION)!=IDYES)return;
  334. int iItem=m_List1.GetNextSelectedItem(pos);
  335. CString id=m_List1.GetItemText (iItem, 0);
  336. CString sql;
  337. sql.Format ("delete from [membermanageblue] where [autoid]=%s", id);
  338. g_sendhead.bsql=1;
  339. g_pMainWnd->ProcessChatMessageRequest2(sql);if(g_bSendOK==0)return;
  340. g_sendhead.bsql=0;
  341. g_sendhead.code[0]=130;
  342. g_sendhead.tabcount=1;
  343. g_pMainWnd->ProcessChatMessageRequest2(1);if(g_bSendOK==0)return;
  344. DataToArray(&m_List1array);HidePrice();
  345. FillGrid();
  346. }
  347. void ShowMemberBlue::OnButton6()
  348. {
  349. // TODO: Add your control notification handler code handler
  350. if(IsHasRights2new(18)==0)return;
  351. // TODO: Add your control notification code
  352. POSITION pos;
  353. pos=m_List1.GetFirstSelectedItemPosition();
  354. if(pos==NULL)
  355. {
  356. AfxMessageBox("请先选中您要返现的会员!");
  357. return;
  358. }
  359. int iItem=m_List1.GetNextSelectedItem(pos);
  360. CString m_memberno=m_List1.GetItemText (iItem, 1);
  361. CString m_name=m_List1.GetItemText (iItem, 2);
  362. CString m_sex=m_List1.GetItemText (iItem, 3);
  363. CString m_phone=m_List1.GetItemText (iItem, 4);
  364. CString m_jiage=m_List1.GetItemText (iItem, 9);
  365. InputCard2PointBlue dlg;
  366. dlg.m_memberno=m_memberno;
  367. dlg.m_name=m_name;
  368. dlg.m_sex=m_sex;
  369. dlg.m_phone=m_phone;
  370. dlg.m_jiage=m_jiage;
  371. if(dlg.DoModal ()!=IDOK)return;
  372. g_sendhead.bsql=0;
  373. g_sendhead.code[0]=130;
  374. g_sendhead.tabcount=1;
  375. g_pMainWnd->ProcessChatMessageRequest2(1);if(g_bSendOK==0)return;
  376. DataToArray(&m_List1array);HidePrice();
  377. FillGrid();
  378. }
  379. void ShowMemberBlue::OnButton10() // 发放副卡 按钮;
  380. {
  381. if(IsHasRights2new(18)==0)return;
  382. POSITION pos;
  383. pos=m_List1.GetFirstSelectedItemPosition();
  384. if(pos==NULL)
  385. {
  386. AfxMessageBox("请先选中主卡!");
  387. return;
  388. }
  389. int iItem=m_List1.GetNextSelectedItem(pos);
  390. CString name=m_List1.GetItemText (iItem, 2);
  391. CString no=m_List1.GetItemText (iItem, 1);
  392. CString sql="select count(*) as cot from membercard2blue where [memberno]='"+no+"'";
  393. g_sendhead.bsql=1;
  394. g_pMainWnd->ProcessChatMessageRequest2(sql);
  395. if (g_bSendOK == 0)return;
  396. if(g_ncount==0)
  397. {
  398. InputCard2Dlg dlg;
  399. dlg.m_mode=1;
  400. dlg.m_name =name;
  401. dlg.m_no =no;
  402. dlg.DoModal ();
  403. }
  404. else
  405. {
  406. int cardnum=atoi(g_cominfoarray.ElementAt (0).ElementAt (118));
  407. if(cardnum==0)cardnum=5;
  408. if(g_ncount>=cardnum)
  409. {
  410. AfxMessageBox("副卡已经发出,不能再次发放!", MB_ICONINFORMATION);return;
  411. }
  412. InputCard2Dlg dlg;
  413. dlg.m_bAddOne =1;
  414. dlg.m_mode=1;
  415. dlg.m_name =name;
  416. dlg.m_no =no;
  417. dlg.DoModal ();
  418. }
  419. }
  420. void ShowMemberBlue::OnButton11()
  421. {
  422. // TODO: Add your control notification handler code here
  423. if(IsHasRights2new(18)==0)return;
  424. // TODO: Add your control notification handler code here
  425. POSITION pos;
  426. pos=m_List1.GetFirstSelectedItemPosition();
  427. if(pos==NULL)
  428. {
  429. AfxMessageBox("请先选中主卡!");
  430. return;
  431. }
  432. int iItem=m_List1.GetNextSelectedItem(pos);
  433. CString no=m_List1.GetItemText (iItem, 1);
  434. CString filter="[memberno]='"+no+"'";
  435. g_sendhead.bsql=0;
  436. g_sendhead.code[0]=131;
  437. g_sendhead.tabcount=1;
  438. g_pMainWnd->ProcessChatMessageRequest2(filter);if(g_bSendOK==0)return;
  439. DataToArray(&g_List1array);
  440. if(g_List1array.GetSize ()==0)
  441. {
  442. AfxMessageBox("此主卡未发放副卡!");
  443. }
  444. else
  445. {
  446. ShowCard2Reg dlg;
  447. dlg.m_memberno=no;
  448. dlg.m_name =m_List1.GetItemText (iItem, 2);
  449. dlg.m_mode=1;
  450. dlg.DoModal ();
  451. }
  452. }
  453. void ShowMemberBlue::HidePrice()
  454. {
  455. }
  456. void ShowMemberBlue::OnButton9() // 导出xls;
  457. {
  458. ListToXLS(&m_List1, _T("C:\\蓝钻会员.xls"), 0, 0);
  459. }