123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889 |
- // MemberCardFunc2.cpp : implementation file
- //
- #include "stdafx.h"
- #include "ylgl.h"
- #include "MemberCardFunc2.h"
- #include "AddMember.h"
- #include "ShowMemberReg.h"
- #include "InputCard2Dlg.h"
- #include "ShowCard2Reg.h"
- #include "InputCard2Point.h"
- #include "UsePoint.h"
- #include "InputCard3Dlg.h"
- #include "ReCharge.h"
- #include "ReChargeReg.h"
- #include "InputPsw2.h"
- #ifdef _DEBUG
- #define new DEBUG_NEW
- #undef THIS_FILE
- static char THIS_FILE[] = __FILE__;
- #endif
- /////////////////////////////////////////////////////////////////////////////
- // MemberCardFunc2 dialog IDC_EDIT4
- MemberCardFunc2::MemberCardFunc2(CWnd* pParent /*=NULL*/)
- : CDialog(MemberCardFunc2::IDD, pParent)
- {
- m_memberno = _T("");
- m_point = _T("");
- m_balance = _T("");
- m_name = _T("");
- m_phone = _T("");
- //}}AFX_DATA_INIT
- }
- void MemberCardFunc2::DoDataExchange(CDataExchange* pDX)
- {
- CDialog::DoDataExchange(pDX);
- DDX_Text(pDX, IDC_EDIT1, m_memberno);
- DDX_Text(pDX, IDC_EDIT2, m_point);
- DDX_Text(pDX, IDC_EDIT3, m_balance);
- DDX_Text(pDX, IDC_EDIT4, m_name);
- DDX_Text(pDX, IDC_EDIT5, m_phone);
- //}}AFX_DATA_MAP
- }
- BEGIN_MESSAGE_MAP(MemberCardFunc2, CDialog)
- ON_BN_CLICKED(IDC_BUTTON15, OnButton15)
- ON_BN_CLICKED(IDC_BUTTON16, OnButton16)
- ON_BN_CLICKED(IDC_BUTTON22, OnButton22)
- ON_BN_CLICKED(IDC_BUTTON17, OnButton17)
- ON_BN_CLICKED(IDC_BUTTON23, OnButton23)
- ON_BN_CLICKED(IDC_BUTTON3, OnButton3)
- ON_BN_CLICKED(IDC_BUTTON10, OnButton10)
- ON_BN_CLICKED(IDC_BUTTON7, OnButton7)
- ON_BN_CLICKED(IDC_BUTTON19, OnButton19)
- ON_BN_CLICKED(IDC_BUTTON18, OnButton18)
- ON_BN_CLICKED(IDC_BUTTON20, OnButton20)
- ON_BN_CLICKED(IDC_BUTTON21, OnButton21)
- ON_BN_CLICKED(IDC_BUTTON24, OnButton24)
- ON_BN_CLICKED(IDC_BUTTON25, OnButton25)
- ON_BN_CLICKED(IDC_BUTTON27, OnButton27)
- ON_BN_CLICKED(IDC_BUTTON28, OnButton28)
- ON_BN_CLICKED(IDC_BUTTON26, OnButton26)
- ON_BN_CLICKED(IDC_BUTTON29, OnButton29)
- ON_BN_CLICKED(IDC_BUTTON30, OnButton30)
- ON_BN_CLICKED(IDC_BUTTON31, OnButton31)
- ON_BN_CLICKED(IDC_BUTTON33, OnButton33)
- ON_WM_DESTROY()
- //}}AFX_MSG_MAP
- END_MESSAGE_MAP()
- BOOL MemberCardFunc2::OnInitDialog()
- {
- CDialog::OnInitDialog();
- if (g_bAllBranch)
- {
- g_pMainWnd->OnDisconnect();
- g_branchip = GetIP(m_branch);
- g_pMainWnd->OnDisconnect();
- g_branchname = m_branch;
- g_bBranchModify = 1;
- }
- CArray<CStringArray, CStringArray>m_List1array;
- CArray<CStringArray, CStringArray>m_List2array;
- if (!m_card2no.IsEmpty())
- {
- GetDlgItem(IDC_BUTTON20)->EnableWindow(0);
- GetDlgItem(IDC_BUTTON30)->EnableWindow(0);
- GetDlgItem(IDC_BUTTON21)->EnableWindow(0);
- GetDlgItem(IDC_BUTTON24)->EnableWindow(0);
- GetDlgItem(IDC_BUTTON25)->EnableWindow(0);
- SetWindowText("子卡管理-当前子卡:" + m_card2no);
- CString filter = "[memberno]='" + m_memberno + "';[memberno]='" + m_memberno + "' and [card2no]='" + m_card2no + "'";
- g_sendhead.bsql = 0;
- g_sendhead.code[0] = 68;
- g_sendhead.code[1] = 164;
- g_sendhead.tabcount = 2;
- g_pMainWnd->ProcessChatMessageRequest2(filter);
- if (g_bSendOK == 0)
- {
- CDialog::OnCancel();
- return 0;
- }
- DataToArray(&m_List1array, &m_List2array);
- m_psw = m_List2array.ElementAt(0).ElementAt(4);
- }
- else
- {
- GetDlgItem(IDC_BUTTON26)->EnableWindow(0);
- GetDlgItem(IDC_BUTTON29)->EnableWindow(0);
- GetDlgItem(IDC_BUTTON27)->EnableWindow(0);
- GetDlgItem(IDC_BUTTON31)->EnableWindow(0);
- GetDlgItem(IDC_BUTTON28)->EnableWindow(0);
- CString filter = "[memberno]='" + m_memberno + "'";
- g_sendhead.bsql = 0;
- g_sendhead.code[0] = 68;
- g_sendhead.tabcount = 1;
- g_pMainWnd->ProcessChatMessageRequest2(filter);
- if (g_bSendOK == 0)
- {
- CDialog::OnCancel();
- return 0;
- }
- DataToArray(&m_List1array);
- m_psw = m_List1array.ElementAt(0).ElementAt(15);
- }
- CenterWindow();
- if (m_List1array.GetSize() == 0)
- {
- AfxMessageBox("没有找到此卡 " + m_memberno + " 的记录");
- GetDlgItem(IDC_BUTTON20)->EnableWindow(0);
- GetDlgItem(IDC_BUTTON30)->EnableWindow(0);
- GetDlgItem(IDC_BUTTON21)->EnableWindow(0);
- GetDlgItem(IDC_BUTTON24)->EnableWindow(0);
- GetDlgItem(IDC_BUTTON25)->EnableWindow(0);
- GetDlgItem(IDC_BUTTON29)->EnableWindow(0);
- GetDlgItem(IDC_BUTTON26)->EnableWindow(0);
- GetDlgItem(IDC_BUTTON27)->EnableWindow(0);
- GetDlgItem(IDC_BUTTON31)->EnableWindow(0);
- GetDlgItem(IDC_BUTTON28)->EnableWindow(0);
- return 0;
- }
- m_memberno = m_List1array.ElementAt(0).ElementAt(1);
- m_point = m_List1array.ElementAt(0).ElementAt(9);
- m_balance = m_List1array.ElementAt(0).ElementAt(12);
- m_name = m_List1array.ElementAt(0).ElementAt(2);
- m_phone = m_List1array.ElementAt(0).ElementAt(4);
- UpdateData(0);
- return TRUE;
- }
- void MemberCardFunc2::OnButton15()
- {
- if (IsHasRights2new(18) == 0)return;
- InputCard2Dlg dlg;
- dlg.m_name = m_name;
- dlg.m_no = m_memberno;
- dlg.DoModal();
- }
- void MemberCardFunc2::OnButton16()
- {
- if (IsHasRights2new(18) == 0)return;
- CString filter = "[memberno]='" + m_memberno + "'";
- g_sendhead.bsql = 0;
- g_sendhead.code[0] = 127;
- g_sendhead.tabcount = 1;
- g_pMainWnd->ProcessChatMessageRequest2(filter); if (g_bSendOK == 0)return;
- DataToArray(&g_List1array);
- if (g_List1array.GetSize() == 0)
- {
- AfxMessageBox("此主卡未发放副卡!");
- }
- else
- {
- ShowCard2Reg dlg;
- dlg.DoModal();
- }
- }
- void MemberCardFunc2::OnButton22()
- {
- if (IsHasRights2new(18) == 0)return;
- InputCard2Point dlg;
- dlg.m_memberno = m_memberno;
- dlg.m_name = m_name;
- dlg.m_phone = m_phone;
- if (dlg.DoModal() != IDOK)return;
- }
- void MemberCardFunc2::OnButton17()
- {
- UsePoint dlg;
- dlg.m_mode = 1;
- dlg.m_memberno = m_memberno;
- dlg.m_name = m_name;
- dlg.m_phone = m_phone;
- dlg.m_point = m_point;
- if (dlg.DoModal() != IDOK)return;
- }
- void MemberCardFunc2::OnButton23()
- {
- UsePoint dlg;
- dlg.m_memberno = m_memberno;
- dlg.m_name = m_name;
- dlg.m_phone = m_phone;
- dlg.m_point = m_point;
- if (dlg.DoModal() != IDOK)return;
- }
- void MemberCardFunc2::OnButton3()
- {
- ShowMemberReg dlg;
- dlg.m_memberno = m_memberno;
- dlg.DoModal();
- }
- void MemberCardFunc2::OnButton10()
- {
- ShowMemberReg dlg;
- dlg.m_mode = 1;
- dlg.m_memberno = m_memberno;
- dlg.DoModal();
- }
- void MemberCardFunc2::OnButton7()
- {
- if (IsHasRights2new(49) == 0)return;
- if (AfxMessageBox("删除后将不可恢复, 确认吗?", MB_YESNO | MB_ICONINFORMATION) != IDYES)return;
- CString sql;
- sql = "delete from membermanage where [memberno]='" + m_memberno + "'";
- sql += "***delete from memberreg where [memberno]='" + m_memberno + "'";
- sql += "***delete from memberreg2 where [memberno]='" + m_memberno + "'";
- sql += "***delete from memberreg3 where [memberno]='" + m_memberno + "'";
- sql += "***delete from memberreg4 where [memberno]='" + m_memberno + "'";
- sql += "***delete from membercard3usereg where [memberno]='" + m_memberno + "'";
- sql += "***delete from membercard2 where [memberno]='" + m_memberno + "'";
- sql += "***delete from membercard3 where [memberno]='" + m_memberno + "'";
- g_sendhead.bsql = 1;
- g_pMainWnd->ProcessChatMessageRequest2(sql); if (g_bSendOK == 0)return;
- AfxMessageBox("删除成功!"); CDialog::OnCancel();
- }
- void MemberCardFunc2::OnButton19()
- {
- UsePoint dlg;
- dlg.m_mode = 2;
- dlg.m_memberno = m_memberno;
- dlg.m_name = m_name;
- dlg.m_phone = m_phone;
- dlg.m_point = m_point;
- if (dlg.DoModal() != IDOK)return;
- AfxMessageBox("更新卡号成功!");
- CDialog::OnCancel();
- }
- void MemberCardFunc2::OnButton18()
- {
- AddMember dlg;
- dlg.m_memberno = m_memberno;
- dlg.m_bAdd = 0;
- dlg.DoModal(); CDialog::OnCancel();
- }
- //****************************************************************//
- // 提现按钮 - 重新实现,将提现当作支出的一种,要记录到财务报表中;
- // case 13
- //****************************************************************//
- void MemberCardFunc2::OnButton30() // 提现按钮;
- {
- if (m_psw != "")
- {
- AfxMessageBox("此卡已设置密码,请输入密码?", MB_ICONINFORMATION);
- InputPsw2 dlg;
- if (dlg.DoModal() != IDOK)return;
- if (m_psw != dlg.m_psw)
- {
- AfxMessageBox("密码错误! ", MB_ICONINFORMATION);
- return;
- }
- }
- UpdateData();
- ReCharge dlg;
- dlg.m_name = m_name; // *用户名;
- dlg.m_no = m_memberno; // 卡号;
- dlg.m_balance = m_balance; // 余额;
- dlg.m_bout = 1; // 提现;
- if (dlg.DoModal() != IDOK)
- return;
- CString sql;
- sql = "insert into [memberreg3]([memberno],[money],[date],[clerk])values('" + m_memberno + "','-" + dlg.m_money + "','" + g_date + "','" + g_user.name + "')";
- // sql这句没有执行,直接被下面的membercard3usereg覆盖;
- // AfxMessageBox(sql);//Jeff Box;
- #if 1
- CString strDescription = "提现(" + g_user.name + ")";
- sql = "insert into [membercard3usereg]([memberno],[dindanid],[money],[date])values('" + m_memberno + "','" + strDescription + "','" + dlg.m_money + "','" + g_date + "')";
- sql += "***refresh balance memberreg3" + m_memberno;
- #else // Jeff.添加新字段;
- CString strDescription = "提现(" + g_user.name+ ")" ;
- sql="insert into [membercard3usereg]([memberno],[dindanid],[money],[date],[ModeOfPayment],[Cashier])values('"+m_memberno+"','"+strDescription+"','"+dlg.m_money+"','"+g_date+ "','"+ "现金" + "','" + g_user.name + "')";
- sql+="***refresh balance memberreg3"+m_memberno;
- #endif
- //printf("Jeff:sql=%s\n\n",sql);//JeffDebug
- g_sendhead.bsql = 1;
- g_pMainWnd->ProcessChatMessageRequest2(sql);
- if (g_bSendOK == 0)
- return;
- AfxMessageBox("提现成功!");
- CString filter = "[memberno]='" + m_memberno + "'";
- g_sendhead.bsql = 0;
- g_sendhead.code[0] = 68;
- g_sendhead.tabcount = 1;
- g_pMainWnd->ProcessChatMessageRequest2(filter);
- if (g_bSendOK == 0)
- {
- CDialog::OnCancel();
- return;
- }
- CArray<CStringArray, CStringArray>m_List1array;
- DataToArray(&m_List1array);
- CenterWindow();
- if (m_List1array.GetSize() == 0)
- {
- AfxMessageBox("没有找到此卡 " + m_memberno + " 的记录");
- GetDlgItem(IDC_BUTTON20)->EnableWindow(0);
- GetDlgItem(IDC_BUTTON30)->EnableWindow(0);
- GetDlgItem(IDC_BUTTON21)->EnableWindow(0);
- GetDlgItem(IDC_BUTTON24)->EnableWindow(0);
- GetDlgItem(IDC_BUTTON25)->EnableWindow(0);
- GetDlgItem(IDC_BUTTON26)->EnableWindow(0);
- GetDlgItem(IDC_BUTTON29)->EnableWindow(0);
- GetDlgItem(IDC_BUTTON27)->EnableWindow(0);
- GetDlgItem(IDC_BUTTON31)->EnableWindow(0);
- GetDlgItem(IDC_BUTTON28)->EnableWindow(0);
- return;
- }
- m_memberno = m_List1array.ElementAt(0).ElementAt(1);
- m_point = m_List1array.ElementAt(0).ElementAt(9);
- m_balance = m_List1array.ElementAt(0).ElementAt(12);
- m_name = m_List1array.ElementAt(0).ElementAt(2);
- m_phone = m_List1array.ElementAt(0).ElementAt(4);
- UpdateData(0);
- if (atoi(g_cominfoarray.ElementAt(0).ElementAt(122))) // msgcheck16
- {
- CString sql, str, timestamp;
- timestamp = "msgtimestamp";
- {
- if (m_name.IsEmpty() == 0 && CheckPhoneType(m_phone) != -1)
- {
- str.Format("%s您好,您本次提现%d元,现余额:%d元。感谢您的支持!", m_name, atoi(dlg.m_money), atoi(m_balance));
- int count = GetLengthEx(str) / MSG_LENGTH;
- if (GetLengthEx(str) % MSG_LENGTH)
- count++;
- CString scount;
- scount.Format("%d", count);
- #if JEFF_TEST_ON
- sql.Format(INSERT_SENDREG, _T("16"), m_phone, str, timestamp, scount, _T("0"), _T("0"), _T("0"), _T("系统自动发送"));
- #else
- sql = "insert into sendreg([phones],[content],[timestamp],[msgcount],[status],[issended],[isautosend],[ren]) values('" + m_phone + "','" + str + "','" + timestamp + "','" + scount + "','0','0','0','系统自动发送')";
- #endif
- }
- }
- g_sendhead.bsql = 1;
- g_pMainWnd->ProcessChatMessageRequest2(sql);
- }
- }
- void MemberCardFunc2::OnButton20() // 充值按钮;
- {
- UpdateData();
- ReCharge dlg;
- dlg.m_name = m_name; // 会员;
- dlg.m_no = m_memberno; // 卡号;
- dlg.m_balance = m_balance; // 充值金额;
- if (dlg.DoModal() != IDOK)return;
- CString sql;
- #if JEFF_TEST_ON
- CSQLStatementImpl::GetInstancePtr()->ReSetKind(_T("[memberreg3]"), NULL, KIND_INSERT, 10);
- CSQLStatementImpl::GetInstancePtr()->AddElement(_T("[memberno]"), m_memberno);
- CSQLStatementImpl::GetInstancePtr()->AddElement(_T("[money]"), dlg.m_money);
- CSQLStatementImpl::GetInstancePtr()->AddElement(_T("[money2]"), dlg.m_money2);
- CSQLStatementImpl::GetInstancePtr()->AddElement(_T("[date]"), g_date);
- CSQLStatementImpl::GetInstancePtr()->AddElement(_T("[time]"), _T("curtimereplace"));
- CSQLStatementImpl::GetInstancePtr()->AddElement(_T("[clerk]"), g_user.name);
- CSQLStatementImpl::GetInstancePtr()->AddElement(_T("[moneytype]"), dlg.paytype);
- CSQLStatementImpl::GetInstancePtr()->AddElement(_T("[bz]"), dlg.m_strRechargeRemark); // 充值备注;
- CSQLStatementImpl::GetInstancePtr()->ReturnSQL(sql);
- #else
- 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 + "')";
- #endif
- sql += _T("***refresh balance memberreg3") + m_memberno;
- g_sendhead.bsql = 1;
- g_pMainWnd->ProcessChatMessageRequest2(sql);
- if (g_bSendOK == 0)
- return;
- AfxMessageBox(_T("充值成功!"));
- CString filter = _T("[memberno]='") + m_memberno + _T("'");
- g_sendhead.bsql = 0;
- g_sendhead.code[0] = 68;
- g_sendhead.tabcount = 1;
- g_pMainWnd->ProcessChatMessageRequest2(filter);
- if (g_bSendOK == 0)
- {
- CDialog::OnCancel();
- return;
- }
- CArray<CStringArray, CStringArray>m_List1array;
- DataToArray(&m_List1array);
- CenterWindow();
- if (m_List1array.GetSize() == 0)
- {
- AfxMessageBox(_T("没有找到此卡 ") + m_memberno + _T(" 的记录"));
- GetDlgItem(IDC_BUTTON20)->EnableWindow(0);
- GetDlgItem(IDC_BUTTON30)->EnableWindow(0);
- GetDlgItem(IDC_BUTTON21)->EnableWindow(0);
- GetDlgItem(IDC_BUTTON24)->EnableWindow(0);
- GetDlgItem(IDC_BUTTON25)->EnableWindow(0);
- GetDlgItem(IDC_BUTTON26)->EnableWindow(0);
- GetDlgItem(IDC_BUTTON29)->EnableWindow(0);
- GetDlgItem(IDC_BUTTON27)->EnableWindow(0);
- GetDlgItem(IDC_BUTTON31)->EnableWindow(0);
- GetDlgItem(IDC_BUTTON28)->EnableWindow(0);
- return;
- }
- m_memberno = m_List1array.ElementAt(0).ElementAt(1);
- m_point = m_List1array.ElementAt(0).ElementAt(9);
- m_balance = m_List1array.ElementAt(0).ElementAt(12);
- m_name = m_List1array.ElementAt(0).ElementAt(2);
- m_phone = m_List1array.ElementAt(0).ElementAt(4);
- UpdateData(0);
- if (atoi(g_cominfoarray.ElementAt(0).ElementAt(122)))
- {
- CString sql, str, timestamp;
- timestamp = _T("msgtimestamp");
- {
- if (m_name.IsEmpty() == 0 && CheckPhoneType(m_phone) != -1)
- {
- str.Format(_T("%s您好,您成功充值%d元,现余额:%d元。感谢您的支持!"), m_name, atoi(dlg.m_money) + atoi(dlg.m_money2), atoi(m_balance));
- int count = GetLengthEx(str) / MSG_LENGTH;
- if (GetLengthEx(str) % MSG_LENGTH)
- count++;
- CString scount;
- scount.Format(_T("%d"), count);
- #if JEFF_TEST_ON
- sql.Format(INSERT_SENDREG, _T("16"), m_phone, str, timestamp, scount, _T("0"), _T("0"), _T("0"), _T("系统自动发送"));
- #else
- sql = "insert into sendreg([phones],[content],[timestamp],[msgcount],[status],[issended],[isautosend],[ren]) values('" + m_phone + "','" + str + "','" + timestamp + "','" + scount + "','0','0','0','系统自动发送')";
- #endif
- }
- }
- g_sendhead.bsql = 1;
- g_pMainWnd->ProcessChatMessageRequest2(sql);
- }
- }
- void MemberCardFunc2::OnButton21() // 充值记录;
- {
- ReChargeReg dlg;
- dlg.m_mode = 0;
- dlg.m_name = m_name;
- dlg.m_phone = m_phone;
- dlg.m_no = m_memberno;
- dlg.m_memberno = m_memberno;
- dlg.DoModal();
- CString filter = _T("[memberno]='") + m_memberno + _T("'");
- g_sendhead.bsql = 0;
- g_sendhead.code[0] = 68;
- g_sendhead.tabcount = 1;
- g_pMainWnd->ProcessChatMessageRequest2(filter);
- if (g_bSendOK == 0)
- {
- CDialog::OnCancel();
- return;
- }
- CArray<CStringArray, CStringArray>m_List1array;
- DataToArray(&m_List1array);
- CenterWindow();
- if (m_List1array.GetSize() == 0)
- {
- AfxMessageBox(_T("没有找到此卡 ") + m_memberno + _T(" 的记录"));
- GetDlgItem(IDC_BUTTON20)->EnableWindow(0);
- GetDlgItem(IDC_BUTTON30)->EnableWindow(0);
- GetDlgItem(IDC_BUTTON21)->EnableWindow(0);
- GetDlgItem(IDC_BUTTON24)->EnableWindow(0);
- GetDlgItem(IDC_BUTTON25)->EnableWindow(0);
- GetDlgItem(IDC_BUTTON26)->EnableWindow(0);
- GetDlgItem(IDC_BUTTON27)->EnableWindow(0);
- GetDlgItem(IDC_BUTTON31)->EnableWindow(0);
- GetDlgItem(IDC_BUTTON28)->EnableWindow(0);
- return;
- }
- m_memberno = m_List1array.ElementAt(0).ElementAt(1);
- m_point = m_List1array.ElementAt(0).ElementAt(9);
- m_balance = m_List1array.ElementAt(0).ElementAt(12);
- m_name = m_List1array.ElementAt(0).ElementAt(2);
- m_phone = m_List1array.ElementAt(0).ElementAt(4);
- UpdateData(0);
- }
- void MemberCardFunc2::OnButton24() // 使用记录;
- {
- // TODO: Add your control notification handler code here
- ReChargeReg dlg;
- dlg.m_mode = 2;
- dlg.m_memberno = m_memberno;
- dlg.DoModal();
- CString filter = "[memberno]='" + m_memberno + "'";
- g_sendhead.bsql = 0;
- g_sendhead.code[0] = 68;
- g_sendhead.tabcount = 1;
- g_pMainWnd->ProcessChatMessageRequest2(filter);
- if (g_bSendOK == 0)
- {
- CDialog::OnCancel();
- return;
- }
- CArray<CStringArray, CStringArray>m_List1array;
- DataToArray(&m_List1array);
- CenterWindow();
- if (m_List1array.GetSize() == 0)
- {
- AfxMessageBox("没有找到此卡 " + m_memberno + " 的记录");
- GetDlgItem(IDC_BUTTON20)->EnableWindow(0);
- GetDlgItem(IDC_BUTTON30)->EnableWindow(0);
- GetDlgItem(IDC_BUTTON21)->EnableWindow(0);
- GetDlgItem(IDC_BUTTON24)->EnableWindow(0);
- GetDlgItem(IDC_BUTTON25)->EnableWindow(0);
- GetDlgItem(IDC_BUTTON26)->EnableWindow(0);
- GetDlgItem(IDC_BUTTON27)->EnableWindow(0);
- GetDlgItem(IDC_BUTTON31)->EnableWindow(0);
- GetDlgItem(IDC_BUTTON28)->EnableWindow(0);
- return;
- }
- m_memberno = m_List1array.ElementAt(0).ElementAt(1);
- m_point = m_List1array.ElementAt(0).ElementAt(9);
- m_balance = m_List1array.ElementAt(0).ElementAt(12);
- m_name = m_List1array.ElementAt(0).ElementAt(2);
- m_phone = m_List1array.ElementAt(0).ElementAt(4);
- UpdateData(0);
- }
- void MemberCardFunc2::OnButton25() // 发放现金子卡;
- {
- // TODO: Add your control notification handler code here
- if (IsHasRights2new(18) == 0)return;
- // TODO: Add your control notification handler code here
- InputCard3Dlg dlg;
- dlg.m_name = m_name;
- dlg.m_no = m_memberno;
- dlg.DoModal();
- }
- void MemberCardFunc2::OnButton27() // 为子卡充值;
- {
- ReCharge dlg;
- dlg.m_mode = 1;
- dlg.m_name = m_name;
- dlg.m_balance = m_balance;
- dlg.m_no = m_memberno;
- dlg.m_card2no = m_card2no;
- if (dlg.DoModal() != IDOK)return;
- CString sql;
- sql = "insert into [memberreg4]([memberno],[card2no],[money],[date],[clerk])values('" + m_memberno + "','" + m_card2no + "','" + dlg.m_money + "','" + g_date + "','" + g_user.name + "')";
- sql += "***refresh balance memberreg4" + m_memberno + ";" + m_card2no;
- g_sendhead.bsql = 1;
- g_pMainWnd->ProcessChatMessageRequest2(sql);
- if (g_bSendOK == 0)
- return;
- CString filter = "[memberno]='" + m_memberno + "'";
- g_sendhead.bsql = 0;
- g_sendhead.code[0] = 68;
- g_sendhead.tabcount = 1;
- g_pMainWnd->ProcessChatMessageRequest2(filter);
- if (g_bSendOK == 0)
- {
- CDialog::OnCancel();
- return;
- }
- CArray<CStringArray, CStringArray>m_List1array;
- DataToArray(&m_List1array);
- CenterWindow();
- if (m_List1array.GetSize() == 0)
- {
- AfxMessageBox("没有找到此卡 " + m_memberno + " 的记录");
- GetDlgItem(IDC_BUTTON20)->EnableWindow(0);
- GetDlgItem(IDC_BUTTON30)->EnableWindow(0);
- GetDlgItem(IDC_BUTTON21)->EnableWindow(0);
- GetDlgItem(IDC_BUTTON24)->EnableWindow(0);
- GetDlgItem(IDC_BUTTON25)->EnableWindow(0);
- GetDlgItem(IDC_BUTTON26)->EnableWindow(0);
- GetDlgItem(IDC_BUTTON27)->EnableWindow(0);
- GetDlgItem(IDC_BUTTON31)->EnableWindow(0);
- GetDlgItem(IDC_BUTTON28)->EnableWindow(0);
- return;
- }
- m_memberno = m_List1array.ElementAt(0).ElementAt(1);
- m_point = m_List1array.ElementAt(0).ElementAt(9);
- m_balance = m_List1array.ElementAt(0).ElementAt(12);
- m_name = m_List1array.ElementAt(0).ElementAt(2);
- m_phone = m_List1array.ElementAt(0).ElementAt(4);
- UpdateData(0);
- if (atoi(g_cominfoarray.ElementAt(0).ElementAt(122)))
- {
- CString sql, str, timestamp;
- timestamp = "msgtimestamp";
- {
- if (m_name.IsEmpty() == 0 && CheckPhoneType(m_phone) != -1)
- {
- str.Format("%s您好,您为卡号为%s的子卡充值%d元,现余额:%d元。感谢您的支持!", m_name, m_card2no, atoi(dlg.m_money), atoi(m_balance));
- int count = GetLengthEx(str) / MSG_LENGTH;
- if (GetLengthEx(str) % MSG_LENGTH)
- count++;
- CString scount;
- scount.Format("%d", count);
- #if JEFF_TEST_ON
- sql.Format(INSERT_SENDREG, _T("16"), m_phone, str, timestamp, scount, _T("0"), _T("0"), _T("0"), _T("系统自动发送"));
- #else
- sql = "insert into sendreg([phones],[content],[timestamp],[msgcount],[status],[issended],[isautosend],[ren]) values('" + m_phone + "','" + str + "','" + timestamp + "','" + scount + "','0','0','0','系统自动发送')";
- #endif
- }
- }
- g_sendhead.bsql = 1;
- g_pMainWnd->ProcessChatMessageRequest2(sql);
- }
- }
- void MemberCardFunc2::OnButton28() // 子卡充值记录;
- {
- ReChargeReg dlg;
- dlg.m_mode = 1;
- dlg.m_memberno = m_memberno;
- dlg.m_card2no = m_card2no;
- dlg.DoModal();
- if (dlg.m_bNeedRefsh == 0)return;
- CString filter = "[memberno]='" + m_memberno + "'";
- g_sendhead.bsql = 0;
- g_sendhead.code[0] = 68;
- g_sendhead.tabcount = 1;
- g_pMainWnd->ProcessChatMessageRequest2(filter);
- if (g_bSendOK == 0)
- {
- CDialog::OnCancel();
- return;
- }
- CArray<CStringArray, CStringArray>m_List1array;
- DataToArray(&m_List1array);
- CenterWindow();
- if (m_List1array.GetSize() == 0)
- {
- AfxMessageBox("没有找到此卡 " + m_memberno + " 的记录");
- GetDlgItem(IDC_BUTTON20)->EnableWindow(0);
- GetDlgItem(IDC_BUTTON30)->EnableWindow(0);
- GetDlgItem(IDC_BUTTON21)->EnableWindow(0);
- GetDlgItem(IDC_BUTTON24)->EnableWindow(0);
- GetDlgItem(IDC_BUTTON25)->EnableWindow(0);
- GetDlgItem(IDC_BUTTON26)->EnableWindow(0);
- GetDlgItem(IDC_BUTTON27)->EnableWindow(0);
- GetDlgItem(IDC_BUTTON31)->EnableWindow(0);
- GetDlgItem(IDC_BUTTON28)->EnableWindow(0);
- return;
- }
- m_memberno = m_List1array.ElementAt(0).ElementAt(1);
- m_point = m_List1array.ElementAt(0).ElementAt(9);
- m_balance = m_List1array.ElementAt(0).ElementAt(12);
- m_name = m_List1array.ElementAt(0).ElementAt(2);
- m_phone = m_List1array.ElementAt(0).ElementAt(4);
- UpdateData(0);
- }
- void MemberCardFunc2::OnButton26() // 子卡使用记录;
- {
- ReChargeReg dlg;
- dlg.m_mode = 3;
- dlg.m_memberno = m_memberno;
- dlg.m_card2no = m_card2no;
- dlg.DoModal();
- }
- void MemberCardFunc2::OnButton29() // 注销此卡;
- {
- if (IsHasRights2new(49) == 0)return;
- if (AfxMessageBox("注销后将不可恢复, 确认吗?", MB_YESNO | MB_ICONINFORMATION) != IDYES)return;
- CString filter;
- g_sendhead.bsql = 0;
- filter = "[memberno]='" + m_card2no + "'";
- g_sendhead.code[0] = 166;
- g_sendhead.tabcount = 1;
- g_pMainWnd->ProcessChatMessageRequest2(filter); if (g_bSendOK == 0)return;
- DataToArray(&g_List1array);
- int usedmoney = 0;
- for (int i = 0; i < g_List1array.GetSize(); i++)
- {
- usedmoney += atoi(g_List1array.ElementAt(i).ElementAt(3));
- }
- CString sql;
- sql = "delete from membercard3 where [memberno]='" + m_memberno + "' and [card2no]='" + m_card2no + "'";
- sql += "***delete from memberreg4 where [memberno]='" + m_memberno + "' and [card2no]='" + m_card2no + "'";
- sql += "***delete from membercard3childusereg where [memberno]='" + m_card2no + "'";
- if (usedmoney)
- {
- CString remark, money;
- money.Format("%d", usedmoney);
- remark.Format("注销子卡%s扣费", m_card2no);
- sql += "***insert into [membercard3usereg]([memberno],[dindanid],[money],[date])values('" + m_memberno + "','" + remark + "','" + money + "','" + g_date + "')";
- sql += "***refresh balance memberreg3"; sql += m_memberno;
- }
- g_sendhead.bsql = 1;
- g_pMainWnd->ProcessChatMessageRequest2(sql); if (g_bSendOK == 0)return;
- AfxMessageBox("注销成功!"); CDialog::OnCancel();
- }
- void MemberCardFunc2::OnButton31() // 为子卡提现;
- {
- if (m_psw != "")
- {
- AfxMessageBox("此卡已设置密码,请输入密码?", MB_ICONINFORMATION);
- InputPsw2 dlg;
- if (dlg.DoModal() != IDOK)return;
- if (m_psw != dlg.m_psw)
- {
- AfxMessageBox("密码错误! ", MB_ICONINFORMATION);
- return;
- }
- }
- ReCharge dlg;
- dlg.m_mode = 1;
- dlg.m_bout = 1;
- dlg.m_name = m_name;
- dlg.m_balance = m_card2balance;
- dlg.m_no = m_memberno;
- dlg.m_card2no = m_card2no;
- if (dlg.DoModal() != IDOK)return;
- CString sql;
- CString m_id = "提现(" + g_user.name + ")";
- sql = "insert into [membercard3childusereg]([memberno],[dindanid],[money],[date])values('" + m_card2no + "','" + m_id + "','" + dlg.m_money + "','" + g_date + "')";
- sql += "***refresh balance memberreg4" + m_memberno + ";" + m_card2no;
- g_sendhead.bsql = 1;
- g_pMainWnd->ProcessChatMessageRequest2(sql);
- if (g_bSendOK == 0)
- return;
- sql.Format("%d", atoi(m_card2balance) - atoi(dlg.m_money));
- m_card2balance = sql;
- CString filter = "[memberno]='" + m_memberno + "'";
- g_sendhead.bsql = 0;
- g_sendhead.code[0] = 68;
- g_sendhead.tabcount = 1;
- g_pMainWnd->ProcessChatMessageRequest2(filter);
- if (g_bSendOK == 0)
- {
- CDialog::OnCancel();
- return;
- }
- CArray<CStringArray, CStringArray>m_List1array;
- DataToArray(&m_List1array);
- CenterWindow();
- if (m_List1array.GetSize() == 0)
- {
- AfxMessageBox("没有找到此卡 " + m_memberno + " 的记录");
- GetDlgItem(IDC_BUTTON20)->EnableWindow(0);
- GetDlgItem(IDC_BUTTON30)->EnableWindow(0);
- GetDlgItem(IDC_BUTTON21)->EnableWindow(0);
- GetDlgItem(IDC_BUTTON24)->EnableWindow(0);
- GetDlgItem(IDC_BUTTON25)->EnableWindow(0);
- GetDlgItem(IDC_BUTTON26)->EnableWindow(0);
- GetDlgItem(IDC_BUTTON27)->EnableWindow(0);
- GetDlgItem(IDC_BUTTON31)->EnableWindow(0);
- GetDlgItem(IDC_BUTTON28)->EnableWindow(0);
- return;
- }
- m_memberno = m_List1array.ElementAt(0).ElementAt(1);
- m_point = m_List1array.ElementAt(0).ElementAt(9);
- m_balance = m_List1array.ElementAt(0).ElementAt(12);
- m_name = m_List1array.ElementAt(0).ElementAt(2);
- m_phone = m_List1array.ElementAt(0).ElementAt(4);
- UpdateData(0);
- }
- void MemberCardFunc2::OnButton33() // 消费密码;
- {
- if (m_psw != "")
- {
- if (AfxMessageBox("此卡已设置密码,是否修改密码?", MB_ICONINFORMATION | MB_YESNO) != IDYES)return;
- InputPsw2 dlg;
- dlg.m_mode = 1;
- if (dlg.DoModal() != IDOK)return;
- if (m_psw != dlg.m_psw)
- {
- if (IsHasRights2new(49))
- {
- if (AfxMessageBox("密码错误! 是否重置密码?", MB_ICONINFORMATION | MB_YESNO) != IDYES)return;
- }
- else
- {
- AfxMessageBox("密码错误! 请重新输入或通知管理员重置密码。");
- return;
- }
- }
- }
- ll: InputPsw2 dlg;
- if (dlg.DoModal() != IDOK)return;
- CString psw1 = dlg.m_psw;
- dlg.m_psw = "";
- if (dlg.DoModal() != IDOK)return;
- if (dlg.m_psw != psw1)
- {
- AfxMessageBox("前后密码不一致,请重新输入!");
- goto ll;
- }
- CString sql;
- if (!m_card2no.IsEmpty())//子卡
- {
- sql = "update membercard3 set psw='" + psw1 + "' where [memberno]='" + m_memberno + "' and [card2no]='" + m_card2no + "'";
- }
- else
- {
- sql = "update membermanage set psw='" + psw1 + "' where [memberno]='" + m_memberno + "' ";
- }
- g_sendhead.bsql = 1;
- g_pMainWnd->ProcessChatMessageRequest2(sql); if (g_bSendOK == 0)return;
- AfxMessageBox("设置密码成功!");
- m_psw = psw1;
- }
- void MemberCardFunc2::OnDestroy()
- {
- CDialog::OnDestroy();
- // TODO: Add your message handler code here
- if (g_bAllBranch)
- {
- g_pMainWnd->OnDisconnect(); g_bBranchModify = 0; g_branchip = g_branchname = "";
- }
- }
|