ReChargeReg.cpp 7.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285
  1. // ReChargeReg.cpp : implementation file
  2. #include "stdafx.h"
  3. #include "ylgl.h"
  4. #include "ReChargeReg.h"
  5. #ifdef _DEBUG
  6. #define new DEBUG_NEW
  7. #undef THIS_FILE
  8. static char THIS_FILE[] = __FILE__;
  9. #endif
  10. //extern void WriteTextLog(CString str); // Jeff client log;
  11. /////////////////////////////////////////////////////////////////////////////
  12. // ReChargeReg dialog
  13. ReChargeReg::ReChargeReg(CWnd* pParent /*=NULL*/)
  14. : CDialog(ReChargeReg::IDD, pParent)
  15. {
  16. //{{AFX_DATA_INIT(ReChargeReg)
  17. //}}AFX_DATA_INIT
  18. m_mode=0;
  19. m_bNeedRefsh=0;
  20. }
  21. void ReChargeReg::DoDataExchange(CDataExchange* pDX)
  22. {
  23. CDialog::DoDataExchange(pDX);
  24. //{{AFX_DATA_MAP(ReChargeReg)
  25. DDX_Control(pDX, IDC_LIST1, m_List1);
  26. //}}AFX_DATA_MAP
  27. }
  28. BEGIN_MESSAGE_MAP(ReChargeReg, CDialog)
  29. //{{AFX_MSG_MAP(ReChargeReg)
  30. ON_BN_CLICKED(IDC_BUTTON1, OnButton1)
  31. ON_BN_CLICKED(IDC_BUTdel, OnBUTdel)
  32. ON_BN_CLICKED(IDC_BUTTON2, OnButton2)
  33. //}}AFX_MSG_MAP
  34. END_MESSAGE_MAP()
  35. /////////////////////////////////////////////////////////////////////////////
  36. // ReChargeReg message handlers
  37. BOOL ReChargeReg::OnInitDialog()
  38. {
  39. CDialog::OnInitDialog();
  40. // TODO: Add extra initialization here
  41. if(IsHasRights2new(49)==0) GetDlgItem(IDC_BUTdel)->EnableWindow(0);
  42. if(m_mode==0)
  43. {// 充值记录;
  44. m_List1.SetHeadings(_T("id,0;卡号,100;充值金额,100;赠金,100;日期,100;经手人,100;充值备注,150" ));
  45. GetDlgItem(IDC_BUTTON2)->ShowWindow(1);
  46. }
  47. else if(m_mode==1)
  48. {
  49. m_List1.SetHeadings(_T("id,0;卡号,100;子卡号,100;充值金额,100;日期,100;经手人,100" ));
  50. SetWindowText(_T("子卡充值记录"));
  51. }
  52. else if(m_mode==2)
  53. {
  54. m_List1.SetHeadings(_T("id,0;卡号,120;订单号,120;消费金额,120;日期,120" ));
  55. SetWindowText(_T("使用记录"));
  56. }
  57. else if(m_mode==3)
  58. {
  59. m_List1.SetHeadings(_T("id,0;子卡号,120;订单号,120;消费金额,120;日期,120" ));
  60. SetWindowText(_T("子卡使用记录"));
  61. }
  62. else if(m_mode==4)
  63. {
  64. m_List1.SetHeadings(_T("id,0;姓名,120;日期,120;类别,120;签单人,120" ));
  65. SetWindowText(_T("考勤签单记录"));
  66. }
  67. m_List1.LoadColumnInfo (187);
  68. GetData();
  69. CenterWindow();
  70. return TRUE; // return TRUE unless you set the focus to a control
  71. // EXCEPTION: OCX Property Pages should return FALSE
  72. }
  73. void ReChargeReg::OnButton1()
  74. {
  75. // TODO: Add your control notification handler code here
  76. CDialog::OnCancel ();
  77. }
  78. void ReChargeReg::OnBUTdel()
  79. {
  80. if(IsHasRights2new(49)==0)
  81. return;
  82. POSITION pos;
  83. pos=m_List1.GetFirstSelectedItemPosition();
  84. if(pos==NULL)
  85. {
  86. AfxMessageBox("请先选中要查看的会员!");
  87. return;
  88. }
  89. if(AfxMessageBox("删除后将不可恢复, 确认吗?", MB_YESNO|MB_ICONINFORMATION)!=IDYES)return;
  90. int iItem=m_List1.GetNextSelectedItem(pos);
  91. CString id=m_List1.GetItemText (iItem, 0);
  92. CString sql;
  93. if(m_mode==1)
  94. {
  95. sql.Format("delete from [memberreg4] where [id]=%d", atoi(id));
  96. sql+="***refresh balance memberreg4"+m_memberno+";"+m_card2no;
  97. }
  98. else if(m_mode==0)
  99. {
  100. sql.Format("delete from [memberreg3] where [id]=%d", atoi(id));
  101. sql+="***refresh balance memberreg3"+m_memberno;
  102. }
  103. else if(m_mode==2)
  104. {
  105. sql.Format("delete from [membercard3usereg] where [id]=%d", atoi(id));
  106. sql+="***refresh balance memberreg3"+m_memberno;
  107. }
  108. else if(m_mode==3)
  109. {
  110. sql.Format("delete from [membercard3childusereg] where [id]=%d", atoi(id));
  111. sql+="***refresh balance memberreg4"+m_memberno+";"+m_card2no;
  112. }
  113. else if(m_mode==4)
  114. {
  115. sql.Format("delete from [loginsign] where [id]=%d", atoi(id));
  116. }
  117. g_sendhead.bsql=1;
  118. g_pMainWnd->ProcessChatMessageRequest2(sql);
  119. if(g_bSendOK==0)return;
  120. GetData();
  121. m_bNeedRefsh=1;
  122. }
  123. void ReChargeReg::GetData()//connect with service;
  124. {
  125. CString filter="[memberno]='"+m_memberno+"'";
  126. g_sendhead.bsql=0;
  127. if(m_mode==1)
  128. {
  129. filter="[memberno]='"+m_memberno+"' and [card2no]='"+m_card2no+"'";
  130. g_sendhead.code[0]=163;
  131. }
  132. else if(m_mode==0)
  133. {// 充值记录表:memberreg3;
  134. g_sendhead.code[0]=162;//memberreg3表;
  135. }
  136. else if(m_mode==2)
  137. {
  138. filter="[memberno]='"+m_memberno+"'";
  139. g_sendhead.code[0]=165;
  140. }
  141. else if(m_mode==3)
  142. {
  143. filter="[memberno]='"+m_card2no+"'";
  144. g_sendhead.code[0]=166;
  145. }
  146. else if(m_mode==4)
  147. {
  148. filter="[date]>='"+m_scurdate+"' and [date]<='"+m_scurdate2+"'";
  149. g_sendhead.code[0]=168;
  150. }
  151. g_sendhead.tabcount=1;
  152. g_pMainWnd->ProcessChatMessageRequest2(filter);
  153. if(g_bSendOK==0)
  154. return;
  155. DataToArray(&m_List1array);
  156. m_List1.DeleteAllItems2 ();
  157. int ii=0;
  158. m_List1.m_arLabels.SetSize( m_List1array.GetSize (), 1 );
  159. int count=0;
  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. m_List1.m_arLabels.SetSize(count, 1);
  165. ii=count;
  166. m_List1.m_LabelCount=ii;
  167. m_List1.SetItemCountEx (ii);
  168. }
  169. void ReChargeReg::OnButton2() // 打印充值记录;
  170. {
  171. POSITION pos;
  172. pos=m_List1.GetFirstSelectedItemPosition();
  173. if(pos==NULL)
  174. {
  175. AfxMessageBox(_T("请先选中您要打单的项目!"), MB_ICONINFORMATION);
  176. return;
  177. }
  178. int iItem = m_List1.GetNextSelectedItem(pos);
  179. CStringArray array;
  180. // 1.空;
  181. array.Add ("");
  182. // 2.表头;
  183. array.Add (g_cominfoarray.ElementAt (0).ElementAt (48));
  184. // 3.订单序列号;
  185. array.Add ("NO."+m_no);
  186. CString str="地址:"+g_cominfoarray.ElementAt (0).ElementAt (12);
  187. str+=" 电话:"+g_cominfoarray.ElementAt (0).ElementAt (11);
  188. // 4.影楼地址+电话;
  189. array.Add (str);
  190. // 获取日期不对!
  191. //CString paydate=m_List1.GetItemText(iItem, 3);
  192. CString paydate=m_List1.GetItemText(iItem, 4);
  193. // 5.
  194. array.Add(_T("客户姓名:") + m_name);
  195. // 6.
  196. array.Add(_T("联系电话:") + m_phone);
  197. CString date;
  198. date.Format(_T("日期:%s年%s月%s日"), paydate.Mid (0,4), paydate.Mid (5,2), paydate.Mid (8,2));
  199. //WriteTextLog(date);// Jeff log
  200. // 7.
  201. array.Add (date);
  202. // 8.
  203. array.Add (" 收 款 项 目 ");
  204. // 9.
  205. array.Add (" 金 额 ");
  206. // 10.
  207. array.Add (" 经手人 ");
  208. int count=0;
  209. float money=0;
  210. // 11. 收款项目字段内容:金卡预存款;
  211. array.Add ("金卡预存款");
  212. // 12. 金额字段内容:
  213. array.Add (m_List1.GetItemText (iItem, 2));
  214. money+=atof(m_List1.GetItemText (iItem, 2));
  215. // 13. 经手人字段内容:
  216. //array.Add (m_List1.GetItemText (iItem, 4));//经手人不对;
  217. array.Add (m_List1.GetItemText (iItem,5));
  218. // 14.充值备注;
  219. array.Add(_T("备注:") + m_List1.GetItemText(iItem,6));
  220. // 15~21都是空数据;
  221. while(array.GetSize() < 22)
  222. array.Add ("");
  223. CString smoney;
  224. smoney.Format ("%0.1f", money);
  225. if(atoi(g_cominfoarray.ElementAt(0).ElementAt(87)))// 小单
  226. {
  227. str="付款情况 应付:"+smoney;
  228. str+=" 实付:"+smoney;
  229. str+=" 欠款:0";
  230. }
  231. else
  232. {
  233. str="付款情况 应付:"+smoney;
  234. str+=" 实付:"+smoney;
  235. str+=" 欠款:0";
  236. }
  237. // 23.
  238. array.Add (str);
  239. if(atoi(g_cominfoarray.ElementAt(0).ElementAt(87)))//小单
  240. {
  241. str.Format("合计人民币(大写): %s 萬 %s 仟 %s 佰 %s 拾 %s 元",\
  242. GetHMoney(GetW(smoney)),GetHMoney(GetK(smoney)),GetHMoney(GetB(smoney)),GetHMoney(GetS(smoney)),GetHMoney(GetG(smoney)));
  243. }
  244. else
  245. {
  246. str.Format("合计人民币(大写): %s 萬 %s 仟 %s 佰 %s 拾 %s 元",\
  247. GetHMoney(GetW(smoney)),GetHMoney(GetK(smoney)),GetHMoney(GetB(smoney)),GetHMoney(GetS(smoney)),GetHMoney(GetG(smoney)));
  248. }
  249. // 24.
  250. array.Add (str);
  251. // 25.
  252. array.Add (g_cominfoarray.ElementAt (0).ElementAt (120));
  253. // 26.
  254. array.Add (" 收银:"+g_user.name);
  255. // 27.
  256. array.Add ("顾客签名:");
  257. // 28.
  258. array.Add ("");//第\r\n一\r\n联\r\n存\r\n根\r\n∧\r\n白\r\n∨\r\n第\r\n二\r\n联\r\n财\r\n务\r\n∧\r\n黄\r\n∨\r\n第\r\n三\r\n联\r\n客\r\n户\r\n∧\r\n红\r\n∨");
  259. g_pMainWnd->PrintReceipt(&array); // 充值记录打印 不使用PrintReceipt_01,不需要显示支付方式 Jeff
  260. }