MemberCardFunc2.cpp 26 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898
  1. // MemberCardFunc2.cpp : implementation file
  2. //
  3. #include "stdafx.h"
  4. #include "ylgl.h"
  5. #include "MemberCardFunc2.h"
  6. #include "AddMember.h"
  7. #include "ShowMemberReg.h"
  8. #include "InputCard2Dlg.h"
  9. #include "ShowCard2Reg.h"
  10. #include "InputCard2Point.h"
  11. #include "UsePoint.h"
  12. #include "InputCard3Dlg.h"
  13. #include "ReCharge.h"
  14. #include "ReChargeReg.h"
  15. #include "InputPsw2.h"
  16. #ifdef _DEBUG
  17. #define new DEBUG_NEW
  18. #undef THIS_FILE
  19. static char THIS_FILE[] = __FILE__;
  20. #endif
  21. /////////////////////////////////////////////////////////////////////////////
  22. // MemberCardFunc2 dialog IDC_EDIT4
  23. MemberCardFunc2::MemberCardFunc2(CWnd* pParent /*=NULL*/)
  24. : CDialog(MemberCardFunc2::IDD, pParent)
  25. {
  26. m_memberno = _T("");
  27. m_point = _T("");
  28. m_balance = _T("");
  29. m_name = _T("");
  30. m_phone = _T("");
  31. //}}AFX_DATA_INIT
  32. }
  33. void MemberCardFunc2::DoDataExchange(CDataExchange* pDX)
  34. {
  35. CDialog::DoDataExchange(pDX);
  36. DDX_Text(pDX, IDC_EDIT1, m_memberno);
  37. DDX_Text(pDX, IDC_EDIT2, m_point);
  38. DDX_Text(pDX, IDC_EDIT3, m_balance);
  39. DDX_Text(pDX, IDC_EDIT4, m_name);
  40. DDX_Text(pDX, IDC_EDIT5, m_phone);
  41. //}}AFX_DATA_MAP
  42. }
  43. BEGIN_MESSAGE_MAP(MemberCardFunc2, CDialog)
  44. ON_BN_CLICKED(IDC_BUTTON15, OnButton15)
  45. ON_BN_CLICKED(IDC_BUTTON16, OnButton16)
  46. ON_BN_CLICKED(IDC_BUTTON22, OnButton22)
  47. ON_BN_CLICKED(IDC_BUTTON17, OnButton17)
  48. ON_BN_CLICKED(IDC_BUTTON23, OnButton23)
  49. ON_BN_CLICKED(IDC_BUTTON3, OnButton3)
  50. ON_BN_CLICKED(IDC_BUTTON10, OnButton10)
  51. ON_BN_CLICKED(IDC_BUTTON7, OnButton7)
  52. ON_BN_CLICKED(IDC_BUTTON19, OnButton19)
  53. ON_BN_CLICKED(IDC_BUTTON18, OnButton18)
  54. ON_BN_CLICKED(IDC_BUTTON20, OnButton20)
  55. ON_BN_CLICKED(IDC_BUTTON21, OnButton21)
  56. ON_BN_CLICKED(IDC_BUTTON24, OnButton24)
  57. ON_BN_CLICKED(IDC_BUTTON25, OnButton25)
  58. ON_BN_CLICKED(IDC_BUTTON27, OnButton27)
  59. ON_BN_CLICKED(IDC_BUTTON28, OnButton28)
  60. ON_BN_CLICKED(IDC_BUTTON26, OnButton26)
  61. ON_BN_CLICKED(IDC_BUTTON29, OnButton29)
  62. ON_BN_CLICKED(IDC_BUTTON30, OnButton30)
  63. ON_BN_CLICKED(IDC_BUTTON31, OnButton31)
  64. ON_BN_CLICKED(IDC_BUTTON33, OnButton33)
  65. ON_WM_DESTROY()
  66. //}}AFX_MSG_MAP
  67. END_MESSAGE_MAP()
  68. /////////////////////////////////////////////////////////////////////////////
  69. // MemberCardFunc2 message handlers
  70. BOOL MemberCardFunc2::OnInitDialog()
  71. {
  72. CDialog::OnInitDialog();
  73. if(g_bAllBranch)
  74. {
  75. g_pMainWnd->OnDisconnect();
  76. g_branchip=GetIP(m_branch);
  77. g_pMainWnd->OnDisconnect();
  78. g_branchname=m_branch;
  79. g_bBranchModify=1;
  80. }
  81. // TODO: Add extra initialization here
  82. CArray<CStringArray, CStringArray>m_List1array;
  83. CArray<CStringArray, CStringArray>m_List2array;
  84. if(!m_card2no.IsEmpty ())
  85. {
  86. GetDlgItem(IDC_BUTTON20)->EnableWindow(0);
  87. GetDlgItem(IDC_BUTTON30)->EnableWindow(0);
  88. GetDlgItem(IDC_BUTTON21)->EnableWindow(0);
  89. GetDlgItem(IDC_BUTTON24)->EnableWindow(0);
  90. GetDlgItem(IDC_BUTTON25)->EnableWindow(0);
  91. SetWindowText("子卡管理-当前子卡:"+m_card2no);
  92. CString filter="[memberno]='"+m_memberno+"';[memberno]='"+m_memberno+"' and [card2no]='"+m_card2no+"'";
  93. g_sendhead.bsql=0;
  94. g_sendhead.code[0]=68;
  95. g_sendhead.code[1]=164;
  96. g_sendhead.tabcount=2;
  97. g_pMainWnd->ProcessChatMessageRequest2(filter);
  98. if(g_bSendOK==0)
  99. {
  100. CDialog::OnCancel ();
  101. return 0;
  102. }
  103. DataToArray(&m_List1array, &m_List2array);
  104. m_psw = m_List2array.ElementAt (0).ElementAt (4);
  105. }
  106. else
  107. {
  108. GetDlgItem(IDC_BUTTON26)->EnableWindow(0);
  109. GetDlgItem(IDC_BUTTON29)->EnableWindow(0);
  110. GetDlgItem(IDC_BUTTON27)->EnableWindow(0);
  111. GetDlgItem(IDC_BUTTON31)->EnableWindow(0);
  112. GetDlgItem(IDC_BUTTON28)->EnableWindow(0);
  113. CString filter="[memberno]='"+m_memberno+"'";
  114. g_sendhead.bsql=0;
  115. g_sendhead.code[0]=68;
  116. g_sendhead.tabcount=1;
  117. g_pMainWnd->ProcessChatMessageRequest2(filter);
  118. if(g_bSendOK==0)
  119. {
  120. CDialog::OnCancel ();
  121. return 0;
  122. }
  123. DataToArray(&m_List1array);
  124. m_psw = m_List1array.ElementAt (0).ElementAt (15);
  125. }
  126. CenterWindow();
  127. if(m_List1array.GetSize ()==0)
  128. {
  129. AfxMessageBox("没有找到此卡 "+m_memberno+" 的记录");
  130. GetDlgItem(IDC_BUTTON20)->EnableWindow(0);
  131. GetDlgItem(IDC_BUTTON30)->EnableWindow(0);
  132. GetDlgItem(IDC_BUTTON21)->EnableWindow(0);
  133. GetDlgItem(IDC_BUTTON24)->EnableWindow(0);
  134. GetDlgItem(IDC_BUTTON25)->EnableWindow(0);
  135. GetDlgItem(IDC_BUTTON29)->EnableWindow(0);
  136. GetDlgItem(IDC_BUTTON26)->EnableWindow(0);
  137. GetDlgItem(IDC_BUTTON27)->EnableWindow(0);
  138. GetDlgItem(IDC_BUTTON31)->EnableWindow(0);
  139. GetDlgItem(IDC_BUTTON28)->EnableWindow(0);
  140. return 0;
  141. }
  142. m_memberno = m_List1array.ElementAt (0).ElementAt (1);
  143. m_point = m_List1array.ElementAt (0).ElementAt (9);
  144. m_balance = m_List1array.ElementAt (0).ElementAt (12);
  145. m_name = m_List1array.ElementAt (0).ElementAt (2);
  146. m_phone = m_List1array.ElementAt (0).ElementAt (4);
  147. UpdateData(0);
  148. return TRUE; // return TRUE unless you set the focus to a control
  149. // EXCEPTION: OCX Property Pages should return FALSE
  150. }
  151. void MemberCardFunc2::OnButton15()
  152. {
  153. // TODO: Add your control notification handler code here
  154. if(IsHasRights2new(18)==0)return;
  155. // TODO: Add your control notification handler code here
  156. InputCard2Dlg dlg;
  157. dlg.m_name =m_name;
  158. dlg.m_no =m_memberno;
  159. dlg.DoModal ();
  160. }
  161. void MemberCardFunc2::OnButton16()
  162. {
  163. // TODO: Add your control notification handler code here
  164. if(IsHasRights2new(18)==0)return;
  165. // TODO: Add your control notification handler code here
  166. CString filter="[memberno]='"+m_memberno+"'";
  167. g_sendhead.bsql=0;
  168. g_sendhead.code[0]=127;
  169. g_sendhead.tabcount=1;
  170. g_pMainWnd->ProcessChatMessageRequest2(filter);if(g_bSendOK==0)return;
  171. DataToArray(&g_List1array);
  172. if(g_List1array.GetSize ()==0)
  173. {
  174. AfxMessageBox("此主卡未发放副卡!");
  175. }
  176. else
  177. {
  178. ShowCard2Reg dlg;
  179. dlg.DoModal ();
  180. }
  181. }
  182. void MemberCardFunc2::OnButton22()
  183. {
  184. // TODO: Add your control notification handler code here
  185. if(IsHasRights2new(18)==0)return;
  186. // TODO: Add your control notification code
  187. InputCard2Point dlg;
  188. dlg.m_memberno=m_memberno;
  189. dlg.m_name=m_name;
  190. dlg.m_phone=m_phone;
  191. if(dlg.DoModal ()!=IDOK)return;
  192. }
  193. void MemberCardFunc2::OnButton17()
  194. {
  195. // TODO: Add your control notification handler code here
  196. UsePoint dlg;
  197. dlg.m_mode=1;
  198. dlg.m_memberno=m_memberno;
  199. dlg.m_name=m_name;
  200. dlg.m_phone=m_phone;
  201. dlg.m_point =m_point;
  202. if(dlg.DoModal ()!=IDOK)return;
  203. }
  204. void MemberCardFunc2::OnButton23()
  205. {
  206. // TODO: Add your control notification handler code here
  207. UsePoint dlg;
  208. dlg.m_memberno=m_memberno;
  209. dlg.m_name=m_name;
  210. dlg.m_phone=m_phone;
  211. dlg.m_point =m_point;
  212. if(dlg.DoModal ()!=IDOK)return;
  213. }
  214. void MemberCardFunc2::OnButton3()
  215. {
  216. // TODO: Add your control notification handler code here
  217. ShowMemberReg dlg;
  218. dlg.m_memberno=m_memberno;
  219. dlg.DoModal ();
  220. }
  221. void MemberCardFunc2::OnButton10()
  222. {
  223. // TODO: Add your control notification handler code here
  224. ShowMemberReg dlg;
  225. dlg.m_mode=1;
  226. dlg.m_memberno=m_memberno;
  227. dlg.DoModal ();
  228. }
  229. void MemberCardFunc2::OnButton7()
  230. {
  231. // TODO: Add your control notification handler code here
  232. if(IsHasRights2new(49)==0)return;
  233. // TODO: Add your control notification handler code here
  234. if(AfxMessageBox("删除后将不可恢复, 确认吗?", MB_YESNO|MB_ICONINFORMATION)!=IDYES)return;
  235. CString sql;
  236. sql="delete from membermanage where [memberno]='"+m_memberno+"'";
  237. sql+="***delete from memberreg where [memberno]='"+m_memberno+"'";
  238. sql+="***delete from memberreg2 where [memberno]='"+m_memberno+"'";
  239. sql+="***delete from memberreg3 where [memberno]='"+m_memberno+"'";
  240. sql+="***delete from memberreg4 where [memberno]='"+m_memberno+"'";
  241. sql+="***delete from membercard3usereg where [memberno]='"+m_memberno+"'";
  242. sql+="***delete from membercard2 where [memberno]='"+m_memberno+"'";
  243. sql+="***delete from membercard3 where [memberno]='"+m_memberno+"'";
  244. g_sendhead.bsql=1;
  245. g_pMainWnd->ProcessChatMessageRequest2(sql);if(g_bSendOK==0)return;
  246. AfxMessageBox("删除成功!"); CDialog::OnCancel ();
  247. }
  248. void MemberCardFunc2::OnButton19()
  249. {
  250. // TODO: Add your control notification handler code here
  251. UsePoint dlg;
  252. dlg.m_mode=2;
  253. dlg.m_memberno=m_memberno;
  254. dlg.m_name=m_name;
  255. dlg.m_phone=m_phone;
  256. dlg.m_point =m_point;
  257. if(dlg.DoModal ()!=IDOK)return;
  258. AfxMessageBox("更新卡号成功!");
  259. CDialog::OnCancel ();
  260. }
  261. void MemberCardFunc2::OnButton18()
  262. {
  263. // TODO: Add your control notification handler code here
  264. AddMember dlg;
  265. dlg.m_memberno =m_memberno;
  266. dlg.m_bAdd=0;
  267. dlg.DoModal (); CDialog::OnCancel ();
  268. }
  269. //****************************************************************//
  270. // 提现按钮 - 重新实现,将提现当作支出的一种,要记录到财务报表中;
  271. // case 13
  272. //****************************************************************//
  273. void MemberCardFunc2::OnButton30() // 提现按钮;
  274. {
  275. if(m_psw!="")
  276. {
  277. AfxMessageBox("此卡已设置密码,请输入密码?", MB_ICONINFORMATION);
  278. InputPsw2 dlg;
  279. if(dlg.DoModal ()!=IDOK)return;
  280. if(m_psw!=dlg.m_psw)
  281. {
  282. AfxMessageBox("密码错误! ", MB_ICONINFORMATION);
  283. return;
  284. }
  285. }
  286. UpdateData();
  287. ReCharge dlg;
  288. dlg.m_name =m_name; // *用户名;
  289. dlg.m_no =m_memberno; // 卡号;
  290. dlg.m_balance =m_balance; // 余额;
  291. dlg.m_bout =1; // 提现;
  292. if(dlg.DoModal ()!=IDOK)
  293. return;
  294. CString sql;
  295. sql="insert into [memberreg3]([memberno],[money],[date],[clerk])values('" + m_memberno + "','-" + dlg.m_money + "','" + g_date + "','" + g_user.name + "')";
  296. // sql这句没有执行,直接被下面的membercard3usereg覆盖;
  297. // AfxMessageBox(sql);//Jeff Box;
  298. #if 1
  299. CString strDescription = "提现(" + g_user.name+ ")" ;
  300. sql="insert into [membercard3usereg]([memberno],[dindanid],[money],[date])values('"+m_memberno+"','"+strDescription+"','"+dlg.m_money+"','"+g_date+"')";
  301. sql+="***refresh balance memberreg3"+m_memberno;
  302. #else // Jeff.添加新字段;
  303. CString strDescription = "提现(" + g_user.name+ ")" ;
  304. sql="insert into [membercard3usereg]([memberno],[dindanid],[money],[date],[ModeOfPayment],[Cashier])values('"+m_memberno+"','"+strDescription+"','"+dlg.m_money+"','"+g_date+ "','"+ "现金" + "','" + g_user.name + "')";
  305. sql+="***refresh balance memberreg3"+m_memberno;
  306. #endif
  307. //printf("Jeff:sql=%s\n\n",sql);//JeffDebug
  308. g_sendhead.bsql=1;
  309. g_pMainWnd->ProcessChatMessageRequest2(sql);
  310. if(g_bSendOK==0)
  311. return;
  312. AfxMessageBox("提现成功!");
  313. CString filter="[memberno]='"+m_memberno+"'";
  314. g_sendhead.bsql=0;
  315. g_sendhead.code[0]=68;
  316. g_sendhead.tabcount=1;
  317. g_pMainWnd->ProcessChatMessageRequest2(filter);
  318. if(g_bSendOK==0)
  319. {
  320. CDialog::OnCancel ();
  321. return;
  322. }
  323. CArray<CStringArray, CStringArray>m_List1array;
  324. DataToArray(&m_List1array);
  325. CenterWindow();
  326. if(m_List1array.GetSize ()==0)
  327. {
  328. AfxMessageBox("没有找到此卡 "+m_memberno+" 的记录");
  329. GetDlgItem(IDC_BUTTON20)->EnableWindow(0);
  330. GetDlgItem(IDC_BUTTON30)->EnableWindow(0);
  331. GetDlgItem(IDC_BUTTON21)->EnableWindow(0);
  332. GetDlgItem(IDC_BUTTON24)->EnableWindow(0);
  333. GetDlgItem(IDC_BUTTON25)->EnableWindow(0);
  334. GetDlgItem(IDC_BUTTON26)->EnableWindow(0);
  335. GetDlgItem(IDC_BUTTON29)->EnableWindow(0);
  336. GetDlgItem(IDC_BUTTON27)->EnableWindow(0);
  337. GetDlgItem(IDC_BUTTON31)->EnableWindow(0);
  338. GetDlgItem(IDC_BUTTON28)->EnableWindow(0);
  339. return;
  340. }
  341. m_memberno = m_List1array.ElementAt (0).ElementAt (1);
  342. m_point = m_List1array.ElementAt (0).ElementAt (9);
  343. m_balance = m_List1array.ElementAt (0).ElementAt (12);
  344. m_name = m_List1array.ElementAt (0).ElementAt (2);
  345. m_phone = m_List1array.ElementAt (0).ElementAt (4);
  346. UpdateData(0);
  347. if(atoi(g_cominfoarray.ElementAt(0).ElementAt(122)))
  348. {
  349. CString sql,str,timestamp;
  350. timestamp="msgtimestamp";
  351. {
  352. if(m_name.IsEmpty()==0 && CheckPhoneType(m_phone)!=-1 )
  353. {
  354. str.Format ("%s您好,您本次提现%d元,现余额:%d元。感谢您的支持!", m_name, atoi(dlg.m_money), atoi(m_balance));
  355. int count=GetLengthEx(str)/MSG_LENGTH;
  356. if(GetLengthEx(str)%MSG_LENGTH)
  357. count++;
  358. CString scount;
  359. scount.Format ("%d", count);
  360. sql="insert into sendreg([phones],[content],[timestamp],[msgcount],[status],[issended],[isautosend],[ren]) values('"+m_phone+"','"+str+"','"+timestamp+"','"+scount+"','0','0','0','系统自动发送')";
  361. }
  362. }
  363. g_sendhead.bsql=1;
  364. g_pMainWnd->ProcessChatMessageRequest2(sql);
  365. }
  366. }
  367. void MemberCardFunc2::OnButton20() // 充值按钮;
  368. {
  369. // TODO: Add your control notification handler code here
  370. UpdateData();
  371. ReCharge dlg;
  372. dlg.m_name =m_name; // 会员;
  373. dlg.m_no =m_memberno; // 卡号;
  374. dlg.m_balance =m_balance; // 充值金额;
  375. if(dlg.DoModal ()!=IDOK)return;
  376. CString sql;
  377. // sql="insert into [memberreg3]([memberno],[money],[money2],[date],[clerk],[moneytype])values('"+m_memberno+"','"+dlg.m_money+"','"+dlg.m_money2+"','"+g_date+"','"+g_user.name+"','"+dlg.paytype+"')";
  378. sql="insert into [memberreg3]([memberno],[money],[money2],[date],[time],[clerk],[moneytype])values('"+m_memberno+"','"+dlg.m_money+"','"+dlg.m_money2+"','"+g_date+"','curtimereplace','"+g_user.name+"','"+dlg.paytype+"')";
  379. sql+="***refresh balance memberreg3"+m_memberno;
  380. g_sendhead.bsql=1;
  381. g_pMainWnd->ProcessChatMessageRequest2(sql);if(g_bSendOK==0)return;
  382. AfxMessageBox("充值成功!");
  383. CString filter="[memberno]='"+m_memberno+"'";
  384. g_sendhead.bsql=0;
  385. g_sendhead.code[0]=68;
  386. g_sendhead.tabcount=1;
  387. g_pMainWnd->ProcessChatMessageRequest2(filter);
  388. if(g_bSendOK==0)
  389. {
  390. CDialog::OnCancel ();
  391. return;
  392. }
  393. CArray<CStringArray, CStringArray>m_List1array;
  394. DataToArray(&m_List1array);
  395. CenterWindow();
  396. if(m_List1array.GetSize ()==0)
  397. {
  398. AfxMessageBox("没有找到此卡 "+m_memberno+" 的记录");
  399. GetDlgItem(IDC_BUTTON20)->EnableWindow(0);
  400. GetDlgItem(IDC_BUTTON30)->EnableWindow(0);
  401. GetDlgItem(IDC_BUTTON21)->EnableWindow(0);
  402. GetDlgItem(IDC_BUTTON24)->EnableWindow(0);
  403. GetDlgItem(IDC_BUTTON25)->EnableWindow(0);
  404. GetDlgItem(IDC_BUTTON26)->EnableWindow(0);
  405. GetDlgItem(IDC_BUTTON29)->EnableWindow(0);
  406. GetDlgItem(IDC_BUTTON27)->EnableWindow(0);
  407. GetDlgItem(IDC_BUTTON31)->EnableWindow(0);
  408. GetDlgItem(IDC_BUTTON28)->EnableWindow(0);
  409. return;
  410. }
  411. m_memberno = m_List1array.ElementAt (0).ElementAt (1);
  412. m_point = m_List1array.ElementAt (0).ElementAt (9);
  413. m_balance = m_List1array.ElementAt (0).ElementAt (12);
  414. m_name = m_List1array.ElementAt (0).ElementAt (2);
  415. m_phone = m_List1array.ElementAt (0).ElementAt (4);
  416. UpdateData(0);
  417. if(atoi(g_cominfoarray.ElementAt(0).ElementAt(122)))
  418. {
  419. CString sql,str,timestamp;
  420. timestamp="msgtimestamp";
  421. {
  422. if(m_name.IsEmpty ()==0 && CheckPhoneType(m_phone)!=-1 )
  423. {
  424. str.Format ("%s您好,您成功充值%d元,现余额:%d元。感谢您的支持!", m_name, atoi(dlg.m_money)+atoi(dlg.m_money2), atoi(m_balance));
  425. int count=GetLengthEx(str)/MSG_LENGTH;
  426. if(GetLengthEx(str)%MSG_LENGTH)
  427. count++;
  428. CString scount;
  429. scount.Format ("%d", count);
  430. sql="insert into sendreg([phones],[content],[timestamp],[msgcount],[status],[issended],[isautosend],[ren]) values('"+m_phone+"','"+str+"','"+timestamp+"','"+scount+"','0','0','0','系统自动发送')";
  431. }
  432. }
  433. g_sendhead.bsql=1;
  434. g_pMainWnd->ProcessChatMessageRequest2(sql);
  435. }
  436. }
  437. void MemberCardFunc2::OnButton21() // 充值记录;
  438. {
  439. // TODO: Add your control notification handler code here
  440. ReChargeReg dlg;
  441. dlg.m_mode=0;
  442. dlg.m_name=m_name;
  443. dlg.m_phone=m_phone;
  444. dlg.m_no=m_memberno;
  445. dlg.m_memberno=m_memberno;
  446. dlg.DoModal ();
  447. CString filter="[memberno]='"+m_memberno+"'";
  448. g_sendhead.bsql=0;
  449. g_sendhead.code[0]=68;
  450. g_sendhead.tabcount=1;
  451. g_pMainWnd->ProcessChatMessageRequest2(filter);
  452. if(g_bSendOK==0)
  453. {
  454. CDialog::OnCancel ();
  455. return;
  456. }
  457. CArray<CStringArray, CStringArray>m_List1array;
  458. DataToArray(&m_List1array);
  459. CenterWindow();
  460. if(m_List1array.GetSize ()==0)
  461. {
  462. AfxMessageBox("没有找到此卡 "+m_memberno+" 的记录");
  463. GetDlgItem(IDC_BUTTON20)->EnableWindow(0);
  464. GetDlgItem(IDC_BUTTON30)->EnableWindow(0);
  465. GetDlgItem(IDC_BUTTON21)->EnableWindow(0);
  466. GetDlgItem(IDC_BUTTON24)->EnableWindow(0);
  467. GetDlgItem(IDC_BUTTON25)->EnableWindow(0);
  468. GetDlgItem(IDC_BUTTON26)->EnableWindow(0);
  469. GetDlgItem(IDC_BUTTON27)->EnableWindow(0);
  470. GetDlgItem(IDC_BUTTON31)->EnableWindow(0);
  471. GetDlgItem(IDC_BUTTON28)->EnableWindow(0);
  472. return;
  473. }
  474. m_memberno = m_List1array.ElementAt (0).ElementAt (1);
  475. m_point = m_List1array.ElementAt (0).ElementAt (9);
  476. m_balance = m_List1array.ElementAt (0).ElementAt (12);
  477. m_name = m_List1array.ElementAt (0).ElementAt (2);
  478. m_phone = m_List1array.ElementAt (0).ElementAt (4);
  479. UpdateData(0);
  480. }
  481. void MemberCardFunc2::OnButton24() // 使用记录;
  482. {
  483. // TODO: Add your control notification handler code here
  484. ReChargeReg dlg;
  485. dlg.m_mode=2;
  486. dlg.m_memberno=m_memberno;
  487. dlg.DoModal ();
  488. CString filter="[memberno]='"+m_memberno+"'";
  489. g_sendhead.bsql=0;
  490. g_sendhead.code[0]=68;
  491. g_sendhead.tabcount=1;
  492. g_pMainWnd->ProcessChatMessageRequest2(filter);
  493. if(g_bSendOK==0)
  494. {
  495. CDialog::OnCancel ();
  496. return;
  497. }
  498. CArray<CStringArray, CStringArray>m_List1array;
  499. DataToArray(&m_List1array);
  500. CenterWindow();
  501. if(m_List1array.GetSize ()==0)
  502. {
  503. AfxMessageBox("没有找到此卡 "+m_memberno+" 的记录");
  504. GetDlgItem(IDC_BUTTON20)->EnableWindow(0);
  505. GetDlgItem(IDC_BUTTON30)->EnableWindow(0);
  506. GetDlgItem(IDC_BUTTON21)->EnableWindow(0);
  507. GetDlgItem(IDC_BUTTON24)->EnableWindow(0);
  508. GetDlgItem(IDC_BUTTON25)->EnableWindow(0);
  509. GetDlgItem(IDC_BUTTON26)->EnableWindow(0);
  510. GetDlgItem(IDC_BUTTON27)->EnableWindow(0);
  511. GetDlgItem(IDC_BUTTON31)->EnableWindow(0);
  512. GetDlgItem(IDC_BUTTON28)->EnableWindow(0);
  513. return;
  514. }
  515. m_memberno = m_List1array.ElementAt (0).ElementAt (1);
  516. m_point = m_List1array.ElementAt (0).ElementAt (9);
  517. m_balance = m_List1array.ElementAt (0).ElementAt (12);
  518. m_name = m_List1array.ElementAt (0).ElementAt (2);
  519. m_phone = m_List1array.ElementAt (0).ElementAt (4);
  520. UpdateData(0);
  521. }
  522. void MemberCardFunc2::OnButton25() // 发放现金子卡;
  523. {
  524. // TODO: Add your control notification handler code here
  525. if(IsHasRights2new(18)==0)return;
  526. // TODO: Add your control notification handler code here
  527. InputCard3Dlg dlg;
  528. dlg.m_name =m_name;
  529. dlg.m_no =m_memberno;
  530. dlg.DoModal ();
  531. }
  532. void MemberCardFunc2::OnButton27() // 为子卡充值;
  533. {
  534. // TODO: Add your control notification handler code here
  535. ReCharge dlg;
  536. dlg.m_mode=1;
  537. dlg.m_name =m_name;
  538. dlg.m_balance =m_balance;
  539. dlg.m_no =m_memberno;
  540. dlg.m_card2no =m_card2no;
  541. if(dlg.DoModal ()!=IDOK)return;
  542. CString sql;
  543. sql="insert into [memberreg4]([memberno],[card2no],[money],[date],[clerk])values('"+m_memberno+"','"+m_card2no+"','"+dlg.m_money+"','"+g_date+"','"+g_user.name+"')";
  544. sql+="***refresh balance memberreg4"+m_memberno+";"+m_card2no;
  545. g_sendhead.bsql=1;
  546. g_pMainWnd->ProcessChatMessageRequest2(sql);
  547. if(g_bSendOK==0)
  548. return;
  549. CString filter="[memberno]='"+m_memberno+"'";
  550. g_sendhead.bsql=0;
  551. g_sendhead.code[0]=68;
  552. g_sendhead.tabcount=1;
  553. g_pMainWnd->ProcessChatMessageRequest2(filter);
  554. if(g_bSendOK==0)
  555. {
  556. CDialog::OnCancel ();
  557. return;
  558. }
  559. CArray<CStringArray, CStringArray>m_List1array;
  560. DataToArray(&m_List1array);
  561. CenterWindow();
  562. if(m_List1array.GetSize ()==0)
  563. {
  564. AfxMessageBox("没有找到此卡 "+m_memberno+" 的记录");
  565. GetDlgItem(IDC_BUTTON20)->EnableWindow(0);
  566. GetDlgItem(IDC_BUTTON30)->EnableWindow(0);
  567. GetDlgItem(IDC_BUTTON21)->EnableWindow(0);
  568. GetDlgItem(IDC_BUTTON24)->EnableWindow(0);
  569. GetDlgItem(IDC_BUTTON25)->EnableWindow(0);
  570. GetDlgItem(IDC_BUTTON26)->EnableWindow(0);
  571. GetDlgItem(IDC_BUTTON27)->EnableWindow(0);
  572. GetDlgItem(IDC_BUTTON31)->EnableWindow(0);
  573. GetDlgItem(IDC_BUTTON28)->EnableWindow(0);
  574. return;
  575. }
  576. m_memberno = m_List1array.ElementAt (0).ElementAt (1);
  577. m_point = m_List1array.ElementAt (0).ElementAt (9);
  578. m_balance = m_List1array.ElementAt (0).ElementAt (12);
  579. m_name = m_List1array.ElementAt (0).ElementAt (2);
  580. m_phone = m_List1array.ElementAt (0).ElementAt (4);
  581. UpdateData(0);
  582. if(atoi(g_cominfoarray.ElementAt(0).ElementAt(122)))
  583. {
  584. CString sql,str,timestamp;
  585. timestamp="msgtimestamp";
  586. {
  587. if(m_name.IsEmpty ()==0 && CheckPhoneType(m_phone)!=-1 )
  588. {
  589. str.Format ("%s您好,您为卡号为%s的子卡充值%d元,现余额:%d元。感谢您的支持!", m_name, m_card2no, atoi(dlg.m_money), atoi(m_balance));
  590. int count=GetLengthEx(str)/MSG_LENGTH;
  591. if(GetLengthEx(str)%MSG_LENGTH)
  592. count++;
  593. CString scount;
  594. scount.Format ("%d", count);
  595. sql="insert into sendreg([phones],[content],[timestamp],[msgcount],[status],[issended],[isautosend],[ren]) values('"+m_phone+"','"+str+"','"+timestamp+"','"+scount+"','0','0','0','系统自动发送')";
  596. }
  597. }
  598. g_sendhead.bsql=1;
  599. g_pMainWnd->ProcessChatMessageRequest2(sql);
  600. }
  601. }
  602. void MemberCardFunc2::OnButton28() // 子卡充值记录;
  603. {
  604. // TODO: Add your control notification handler code here
  605. ReChargeReg dlg;
  606. dlg.m_mode=1;
  607. dlg.m_memberno=m_memberno;
  608. dlg.m_card2no =m_card2no;
  609. dlg.DoModal ();
  610. if(dlg.m_bNeedRefsh==0)return;
  611. CString filter="[memberno]='"+m_memberno+"'";
  612. g_sendhead.bsql=0;
  613. g_sendhead.code[0]=68;
  614. g_sendhead.tabcount=1;
  615. g_pMainWnd->ProcessChatMessageRequest2(filter);
  616. if(g_bSendOK==0)
  617. {
  618. CDialog::OnCancel ();
  619. return;
  620. }
  621. CArray<CStringArray, CStringArray>m_List1array;
  622. DataToArray(&m_List1array);
  623. CenterWindow();
  624. if(m_List1array.GetSize ()==0)
  625. {
  626. AfxMessageBox("没有找到此卡 "+m_memberno+" 的记录");
  627. GetDlgItem(IDC_BUTTON20)->EnableWindow(0);
  628. GetDlgItem(IDC_BUTTON30)->EnableWindow(0);
  629. GetDlgItem(IDC_BUTTON21)->EnableWindow(0);
  630. GetDlgItem(IDC_BUTTON24)->EnableWindow(0);
  631. GetDlgItem(IDC_BUTTON25)->EnableWindow(0);
  632. GetDlgItem(IDC_BUTTON26)->EnableWindow(0);
  633. GetDlgItem(IDC_BUTTON27)->EnableWindow(0);
  634. GetDlgItem(IDC_BUTTON31)->EnableWindow(0);
  635. GetDlgItem(IDC_BUTTON28)->EnableWindow(0);
  636. return;
  637. }
  638. m_memberno = m_List1array.ElementAt (0).ElementAt (1);
  639. m_point = m_List1array.ElementAt (0).ElementAt (9);
  640. m_balance = m_List1array.ElementAt (0).ElementAt (12);
  641. m_name = m_List1array.ElementAt (0).ElementAt (2);
  642. m_phone = m_List1array.ElementAt (0).ElementAt (4);
  643. UpdateData(0);
  644. }
  645. void MemberCardFunc2::OnButton26()
  646. {
  647. // TODO: Add your control notification handler code here
  648. ReChargeReg dlg;
  649. dlg.m_mode=3;
  650. dlg.m_memberno=m_memberno;
  651. dlg.m_card2no =m_card2no;
  652. dlg.DoModal ();
  653. }
  654. void MemberCardFunc2::OnButton29()
  655. {
  656. // TODO: Add your control notification handler code here
  657. if(IsHasRights2new(49)==0)return;
  658. // TODO: Add your control notification handler code here
  659. if(AfxMessageBox("注销后将不可恢复, 确认吗?", MB_YESNO|MB_ICONINFORMATION)!=IDYES)return;
  660. CString filter;
  661. g_sendhead.bsql=0;
  662. filter="[memberno]='"+m_card2no+"'";
  663. g_sendhead.code[0]=166;
  664. g_sendhead.tabcount=1;
  665. g_pMainWnd->ProcessChatMessageRequest2(filter);if(g_bSendOK==0)return;
  666. DataToArray(&g_List1array);
  667. int usedmoney=0;
  668. for(int i=0; i<g_List1array.GetSize (); i++)
  669. {
  670. usedmoney+=atoi(g_List1array.ElementAt (i).ElementAt (3));
  671. }
  672. CString sql;
  673. sql="delete from membercard3 where [memberno]='"+m_memberno+"' and [card2no]='"+m_card2no+"'";
  674. sql+="***delete from memberreg4 where [memberno]='"+m_memberno+"' and [card2no]='"+m_card2no+"'";
  675. sql+="***delete from membercard3childusereg where [memberno]='"+m_card2no+"'";
  676. if(usedmoney)
  677. {
  678. CString remark,money;
  679. money.Format ("%d", usedmoney);
  680. remark.Format ("注销子卡%s扣费", m_card2no);
  681. sql+="***insert into [membercard3usereg]([memberno],[dindanid],[money],[date])values('"+m_memberno+"','"+remark+"','"+money+"','"+g_date+"')";
  682. sql+="***refresh balance memberreg3";sql+=m_memberno;
  683. }
  684. g_sendhead.bsql=1;
  685. g_pMainWnd->ProcessChatMessageRequest2(sql);if(g_bSendOK==0)return;
  686. AfxMessageBox("注销成功!"); CDialog::OnCancel ();
  687. }
  688. void MemberCardFunc2::OnButton31() // 为子卡提现;
  689. {
  690. // TODO: Add your control notification handler code here
  691. if(m_psw!="")
  692. {
  693. AfxMessageBox("此卡已设置密码,请输入密码?", MB_ICONINFORMATION);
  694. InputPsw2 dlg;
  695. if(dlg.DoModal ()!=IDOK)return;
  696. if(m_psw!=dlg.m_psw)
  697. {
  698. AfxMessageBox("密码错误! ", MB_ICONINFORMATION);
  699. return;
  700. }
  701. }
  702. ReCharge dlg;
  703. dlg.m_mode=1;
  704. dlg.m_bout=1;
  705. dlg.m_name =m_name;
  706. dlg.m_balance =m_card2balance;
  707. dlg.m_no =m_memberno;
  708. dlg.m_card2no =m_card2no;
  709. if(dlg.DoModal ()!=IDOK)return;
  710. CString sql;
  711. CString m_id="提现("+g_user.name+")";
  712. sql="insert into [membercard3childusereg]([memberno],[dindanid],[money],[date])values('"+m_card2no+"','"+m_id+"','"+dlg.m_money+"','"+g_date+"')";
  713. sql+="***refresh balance memberreg4"+m_memberno+";"+m_card2no;
  714. g_sendhead.bsql=1;
  715. g_pMainWnd->ProcessChatMessageRequest2(sql);
  716. if(g_bSendOK==0)
  717. return;
  718. sql.Format ("%d", atoi(m_card2balance)-atoi(dlg.m_money));
  719. m_card2balance=sql;
  720. CString filter="[memberno]='"+m_memberno+"'";
  721. g_sendhead.bsql=0;
  722. g_sendhead.code[0]=68;
  723. g_sendhead.tabcount=1;
  724. g_pMainWnd->ProcessChatMessageRequest2(filter);
  725. if(g_bSendOK==0)
  726. {
  727. CDialog::OnCancel ();
  728. return;
  729. }
  730. CArray<CStringArray, CStringArray>m_List1array;
  731. DataToArray(&m_List1array);
  732. CenterWindow();
  733. if(m_List1array.GetSize ()==0)
  734. {
  735. AfxMessageBox("没有找到此卡 "+m_memberno+" 的记录");
  736. GetDlgItem(IDC_BUTTON20)->EnableWindow(0);
  737. GetDlgItem(IDC_BUTTON30)->EnableWindow(0);
  738. GetDlgItem(IDC_BUTTON21)->EnableWindow(0);
  739. GetDlgItem(IDC_BUTTON24)->EnableWindow(0);
  740. GetDlgItem(IDC_BUTTON25)->EnableWindow(0);
  741. GetDlgItem(IDC_BUTTON26)->EnableWindow(0);
  742. GetDlgItem(IDC_BUTTON27)->EnableWindow(0);
  743. GetDlgItem(IDC_BUTTON31)->EnableWindow(0);
  744. GetDlgItem(IDC_BUTTON28)->EnableWindow(0);
  745. return;
  746. }
  747. m_memberno = m_List1array.ElementAt (0).ElementAt (1);
  748. m_point = m_List1array.ElementAt (0).ElementAt (9);
  749. m_balance = m_List1array.ElementAt (0).ElementAt (12);
  750. m_name = m_List1array.ElementAt (0).ElementAt (2);
  751. m_phone = m_List1array.ElementAt (0).ElementAt (4);
  752. UpdateData(0);
  753. }
  754. void MemberCardFunc2::OnButton33()
  755. {
  756. // TODO: Add your control notification handler code here
  757. if(m_psw!="")
  758. {
  759. if(AfxMessageBox("此卡已设置密码,是否修改密码?", MB_ICONINFORMATION|MB_YESNO)!=IDYES)return;
  760. InputPsw2 dlg;
  761. dlg.m_mode=1;
  762. if(dlg.DoModal ()!=IDOK)return;
  763. if(m_psw!=dlg.m_psw)
  764. {
  765. if(IsHasRights2new(49))
  766. {
  767. if(AfxMessageBox("密码错误! 是否重置密码?", MB_ICONINFORMATION|MB_YESNO)!=IDYES)return;
  768. }
  769. else
  770. {
  771. AfxMessageBox("密码错误! 请重新输入或通知管理员重置密码。");
  772. return;
  773. }
  774. }
  775. }
  776. ll: InputPsw2 dlg;
  777. if(dlg.DoModal ()!=IDOK)return;
  778. CString psw1=dlg.m_psw ;
  779. dlg.m_psw="";
  780. if(dlg.DoModal ()!=IDOK)return;
  781. if(dlg.m_psw !=psw1)
  782. {
  783. AfxMessageBox("前后密码不一致,请重新输入!");
  784. goto ll;
  785. }
  786. CString sql;
  787. if(!m_card2no.IsEmpty ())//子卡
  788. {
  789. sql="update membercard3 set psw='"+psw1+"' where [memberno]='"+m_memberno+"' and [card2no]='"+m_card2no+"'";
  790. }
  791. else
  792. {
  793. sql="update membermanage set psw='"+psw1+"' where [memberno]='"+m_memberno+"' ";
  794. }
  795. g_sendhead.bsql=1;
  796. g_pMainWnd->ProcessChatMessageRequest2(sql);if(g_bSendOK==0)return;
  797. AfxMessageBox("设置密码成功!");
  798. m_psw=psw1;
  799. }
  800. void MemberCardFunc2::OnDestroy()
  801. {
  802. CDialog::OnDestroy();
  803. // TODO: Add your message handler code here
  804. if(g_bAllBranch)
  805. {
  806. g_pMainWnd->OnDisconnect();g_bBranchModify=0;g_branchip=g_branchname="";
  807. }
  808. }