123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501 |
- // ShowMemberBlue.cpp : implementation file
- //
- #include "stdafx.h"
- #include "ylgl.h"
- #include "ShowMemberBlue.h"
- #include "MyMdi.H"
- #include "AddMember.h"
- #include "ShowMemberReg.h"
- #include "InputCard2Dlg.h"
- #include "ShowCard2Reg.h"
- #include "InputCard2PointBlue.h"
- #include "UsePointBlue.h"
- #include "SendMsgDlg.h"
- #ifdef _DEBUG
- #define new DEBUG_NEW
- #undef THIS_FILE
- static char THIS_FILE[] = __FILE__;
- #endif
- #pragma comment(lib, "Shlwapi.lib")
- /////////////////////////////////////////////////////////////////////////////
- // ShowMemberBlue
- IMPLEMENT_DYNCREATE(ShowMemberBlue, MyFormView)
- ShowMemberBlue::ShowMemberBlue() : MyFormView(ShowMemberBlue::IDD)
- {
- m_filter = _T("");
- }
- ShowMemberBlue::~ShowMemberBlue()
- {
- }
- void ShowMemberBlue::DoDataExchange(CDataExchange* pDX)
- {
- MyFormView::DoDataExchange(pDX);
- //{{AFX_DATA_MAP(ShowMemberBlue)
- DDX_Control(pDX, IDC_LIST2, m_List1);
- DDX_Control(pDX, IDC_STATIC1, m_static1);
- DDX_Text(pDX, IDC_EDIT4, m_filter);
- //}}AFX_DATA_MAP
- }
- BEGIN_MESSAGE_MAP(ShowMemberBlue, MyFormView)
- //{{AFX_MSG_MAP(ShowMemberBlue)
- ON_BN_CLICKED(IDC_BUTclose, OnBUTclose)
- ON_BN_CLICKED(IDC_BUTTON1, OnButton1)
- ON_WM_TIMER()
- ON_BN_CLICKED(IDC_BUTTON2, OnButton2)
- ON_NOTIFY(NM_DBLCLK, IDC_LIST2, OnDblclkList2)
- ON_BN_CLICKED(IDC_BUTTON3, OnButton3)
- ON_BN_CLICKED(IDC_BUTTON4, OnButton4)
- ON_BN_CLICKED(IDC_BUTTON5, OnButton5)
- ON_BN_CLICKED(IDC_BUTTON6, OnButton6)
- ON_BN_CLICKED(IDC_BUTTON10, OnButton10)
- ON_BN_CLICKED(IDC_BUTTON11, OnButton11)
- ON_BN_CLICKED(IDC_BUTTON9, OnButton9)
- //}}AFX_MSG_MAP
- END_MESSAGE_MAP()
- /////////////////////////////////////////////////////////////////////////////
- // ShowMemberBlue diagnostics
- #ifdef _DEBUG
- void ShowMemberBlue::AssertValid() const
- {
- MyFormView::AssertValid();
- }
- void ShowMemberBlue::Dump(CDumpContext& dc) const
- {
- MyFormView::Dump(dc);
- }
- #endif
- void ShowMemberBlue::OnInitialUpdate()
- {
- MyFormView::OnInitialUpdate();
- CMyMdi Mdi;
- Mdi.SetSubView((CWnd*)GetParent(), (CWnd*)this);
- GetDlgItem(IDC_BUTTON5)->EnableWindow(IsHasRights2new(49));
- CRect rc2;
- GetWindowRect(rc2);
- ::MoveWindow(m_hWnd,g_rc.left,g_rc.top,g_rc.Width(),g_rc.Height(),TRUE);
- EnumChildWindows(m_hWnd,(WNDENUMPROC)EnumChildProc,0);
- int idarray[]={IDC_BUTTON2,IDC_BUTTON5,IDC_BUTTON10,IDC_BUTTON11,IDC_BUTTON6,IDC_BUTTON4,IDC_BUTTON3,IDC_BUTclose};
- int idcount=8;
- int btnwid;
- CRect prerc;
- for(int a=idcount-2; a>=0; a--)
- {
- GetDlgItem(idarray[a+1])->GetWindowRect (prerc);
- ScreenToClient(prerc);
- GetDlgItem(idarray[a])->GetWindowRect (rc2);
- ScreenToClient(rc2);
- btnwid=rc2.Width ();
- rc2.right =prerc.left ;
- rc2.left =rc2.right -btnwid;
- GetDlgItem(idarray[a])->MoveWindow (rc2);
- }
- m_static1.SetFont (&g_titlefont);
- m_List1.SetHeadings("id,0;会员卡卡号,100;姓名,100;性别,100;电话,100;QQ,100;地址,100;职业,100;生日,100;套系金额,100;可返金额,100;已返现金,100;余额,100;办卡日期,100" );
- m_List1.LoadColumnInfo (168);
- g_sendhead.bsql=0;
- g_sendhead.code[0]=130;
- g_sendhead.tabcount=1;
- g_pMainWnd->ProcessChatMessageRequest2(1);if(g_bSendOK==0)return;
- DataToArray(&m_List1array);
- HidePrice();
- FillGrid();
- }
- void ShowMemberBlue::FillGrid()
- {
- m_List1.DeleteAllItems2 ();
- int ii=0;
- m_List1.m_arLabels.SetSize( m_List1array.GetSize (), 1 );
- int count=0;
- if(m_filter.IsEmpty ())
- {
- for(ii=0; ii<m_List1.m_arLabels.GetSize (); ii++)
- {
- m_List1.m_arLabels.ElementAt (count++).Copy (m_List1array.ElementAt (ii));
- }
- }
- else
- {
- int type=GetType(m_filter);
- if(type==2)//拼音
- {
- m_filter.MakeUpper ();
- for(ii=0; ii<m_List1.m_arLabels.GetSize (); ii++)
- {
- if(m_List1array.ElementAt (ii).ElementAt (14).Find (m_filter)!=-1)
- {
- m_List1.m_arLabels.ElementAt (count++).Copy (m_List1array.ElementAt (ii));
- }
- }
- }
- else
- {
- for(ii=0; ii<m_List1.m_arLabels.GetSize (); ii++)
- {
- if(m_List1array.ElementAt (ii).ElementAt (1).Find (m_filter)!=-1 ||\
- m_List1array.ElementAt (ii).ElementAt (2).Find (m_filter)!=-1 || \
- m_List1array.ElementAt (ii).ElementAt (3).Find (m_filter)!=-1 || \
- m_List1array.ElementAt (ii).ElementAt (4).Find (m_filter)!=-1|| \
- m_List1array.ElementAt (ii).ElementAt (5).Find (m_filter)!=-1 || \
- m_List1array.ElementAt (ii).ElementAt (6).Find (m_filter)!=-1 || \
- m_List1array.ElementAt (ii).ElementAt (7).Find (m_filter)!=-1 || \
- m_List1array.ElementAt (ii).ElementAt (8).Find (m_filter)!=-1 || \
- m_List1array.ElementAt (ii).ElementAt (9).Find (m_filter)!=-1 || \
- m_List1array.ElementAt (ii).ElementAt (10).Find (m_filter)!=-1 )
- {
- m_List1.m_arLabels.ElementAt (count++).Copy (m_List1array.ElementAt (ii));
- }
- }
- }
- }
- m_List1.m_arLabels.SetSize(count, 1);
- ii=count;
- m_List1.m_LabelCount=ii;
- m_List1.SetItemCountEx (ii);
- CString str;
- str.Format ("客人:%d", ii);
- SetDlgItemText(IDC_STATIC2, str);
- CRect rc;
- GetDlgItem(IDC_STATIC2)->GetWindowRect (rc);
- ScreenToClient(rc);
- InvalidateRect(rc);
- }
- void ShowMemberBlue::OnBUTclose()
- {
- // TODO: Add your control notification handler code here
- GetParent()->SendMessage(WM_CLOSE);
- }
- void ShowMemberBlue::OnTimer(UINT nIDEvent)
- {
- // TODO: Add your message handler code here and/or call default
- KillTimer(nIDEvent);
- OnButton1();
- }
- BOOL ShowMemberBlue::PreTranslateMessage(MSG* pMsg)
- {
- // TODO: Add your specialized code here and/or call the base class
- try
- {
- if(pMsg->message==WM_KEYDOWN)
- {
- switch (pMsg->wParam)
- {
- case VK_RETURN:
- OnButton1();
- return 1;
- case 0x43: // copy
- if ( ( GetKeyState( VK_CONTROL ) & 0x80 ) )
- {
- GetFocus()->SendMessage(WM_COPY);
- return TRUE;
- }
- break;
- case 0x56: //Ctrl + V:
- if ( ( GetKeyState( VK_CONTROL ) & 0x80 ) )
- {
- GetFocus()->SendMessage(WM_PASTE);
- return TRUE;
- }
- break;
- case 0x58: // cut
- if ( ( GetKeyState( VK_CONTROL ) & 0x80 ) )
- {
- GetFocus()->SendMessage(WM_CUT);
- return TRUE;
- }
- break;
- case 0x5A: //undo
- case 0x59: //redo
- if ( ( GetKeyState( VK_CONTROL ) & 0x80 ) )
- {
- GetFocus()->SendMessage(WM_UNDO);
- return TRUE;
- }
- break;
- }
- }
- return MyFormView::PreTranslateMessage(pMsg);
- }
- catch(...)
- {
- }
- return true;
- }
- void ShowMemberBlue::OnButton1()
- {
- // TODO: Add your control notification handler code here
- UpdateData();
- m_filter.TrimLeft ();
- m_filter.TrimRight ();
- FillGrid();
- }
- void ShowMemberBlue::OnButton2() // 新增会员 按钮;
- {
- // TODO: Add your control notification handler code here
- AddMember dlg;
- dlg.m_mode=1;
- if(dlg.DoModal ()==IDOK)
- {
- g_sendhead.bsql=0;
- g_sendhead.code[0]=130;
- g_sendhead.tabcount=1;
- g_pMainWnd->ProcessChatMessageRequest2(1);if(g_bSendOK==0)return;
- DataToArray(&m_List1array);HidePrice();
- OnButton1();
- }
- }
- void ShowMemberBlue::OnDblclkList2(NMHDR* pNMHDR, LRESULT* pResult)
- {
- // TODO: Add your control notification handler code here
- POSITION pos;
- pos=m_List1.GetFirstSelectedItemPosition();
- if(pos==NULL)
- {
- return;
- }
- int iItem=m_List1.GetNextSelectedItem(pos);
- CString memberno=m_List1.GetItemText (iItem, 1);
- AddMember dlg;
- dlg.m_memberno =memberno;
- dlg.m_bAdd=0;
- dlg.m_mode=1;
- if(dlg.DoModal ()==IDOK)
- {
- g_sendhead.bsql=0;
- g_sendhead.code[0]=130;
- g_sendhead.tabcount=1;
- g_pMainWnd->ProcessChatMessageRequest2(1);if(g_bSendOK==0)return;
- DataToArray(&m_List1array);HidePrice();
- OnButton1();
- }
- *pResult = 0;
- }
- void ShowMemberBlue::OnButton3()
- {
- // TODO: Add your control notification handler code here
- POSITION pos;
- pos=m_List1.GetFirstSelectedItemPosition();
- if(pos==NULL)
- {
- AfxMessageBox("请先选中您要发送短信的会员!", MB_ICONINFORMATION);
- return;
- }
- int iItem;
- CStringArray array;
- while (pos)
- {
- iItem = m_List1.GetNextSelectedItem(pos);
- if(!m_List1.GetItemText (iItem, 4).IsEmpty ())
- array.Add (m_List1.GetItemText (iItem, 4));
- }
- SendMsgDlg dlg;
- dlg.m_mode=1;
- dlg.m_pArray=&array;
- dlg.DoModal ();
- }
- void ShowMemberBlue::OnButton4()
- {
- // TODO: Add your control notification handler code here
- POSITION pos;
- pos=m_List1.GetFirstSelectedItemPosition();
- if(pos==NULL)
- {
- AfxMessageBox("请先选中要取现的会员!");
- return;
- }
- int iItem=m_List1.GetNextSelectedItem(pos);
- CString m_memberno=m_List1.GetItemText (iItem, 1);
- CString m_name=m_List1.GetItemText (iItem, 2);
- UsePointBlue dlg;
- dlg.m_memberno=m_memberno;
- dlg.m_name=m_name;
- dlg.m_point =m_List1.GetItemText (iItem,12);
- if(dlg.DoModal ()!=IDOK)return;
- g_sendhead.bsql=0;
- g_sendhead.code[0]=130;
- g_sendhead.tabcount=1;
- g_pMainWnd->ProcessChatMessageRequest2(1);if(g_bSendOK==0)return;
- DataToArray(&m_List1array);HidePrice();
- FillGrid();
- }
- void ShowMemberBlue::OnButton5() // 删除会员 按钮;
- {
- if(IsHasRights2new(49)==0)return;
- // TODO: Add your control notification handler code here
- POSITION pos;
- pos=m_List1.GetFirstSelectedItemPosition();
- if(pos==NULL)
- {
- AfxMessageBox("请先选中您要删除的会员!");
- return;
- }
- if(AfxMessageBox("删除后将不可恢复, 确认吗?", MB_YESNO|MB_ICONINFORMATION)!=IDYES)return;
- int iItem=m_List1.GetNextSelectedItem(pos);
- CString id=m_List1.GetItemText (iItem, 0);
- CString sql;
- sql.Format ("delete from [membermanageblue] where [autoid]=%s", id);
- g_sendhead.bsql=1;
- g_pMainWnd->ProcessChatMessageRequest2(sql);if(g_bSendOK==0)return;
- g_sendhead.bsql=0;
- g_sendhead.code[0]=130;
- g_sendhead.tabcount=1;
- g_pMainWnd->ProcessChatMessageRequest2(1);if(g_bSendOK==0)return;
- DataToArray(&m_List1array);HidePrice();
- FillGrid();
- }
- void ShowMemberBlue::OnButton6()
- {
- // TODO: Add your control notification handler code handler
- if(IsHasRights2new(18)==0)return;
- // TODO: Add your control notification code
- POSITION pos;
- pos=m_List1.GetFirstSelectedItemPosition();
- if(pos==NULL)
- {
- AfxMessageBox("请先选中您要返现的会员!");
- return;
- }
- int iItem=m_List1.GetNextSelectedItem(pos);
- CString m_memberno=m_List1.GetItemText (iItem, 1);
- CString m_name=m_List1.GetItemText (iItem, 2);
- CString m_sex=m_List1.GetItemText (iItem, 3);
- CString m_phone=m_List1.GetItemText (iItem, 4);
- CString m_jiage=m_List1.GetItemText (iItem, 9);
- InputCard2PointBlue dlg;
- dlg.m_memberno=m_memberno;
- dlg.m_name=m_name;
- dlg.m_sex=m_sex;
- dlg.m_phone=m_phone;
- dlg.m_jiage=m_jiage;
- if(dlg.DoModal ()!=IDOK)return;
- g_sendhead.bsql=0;
- g_sendhead.code[0]=130;
- g_sendhead.tabcount=1;
- g_pMainWnd->ProcessChatMessageRequest2(1);if(g_bSendOK==0)return;
- DataToArray(&m_List1array);HidePrice();
- FillGrid();
- }
- void ShowMemberBlue::OnButton10() // 发放副卡 按钮;
- {
- if(IsHasRights2new(18)==0)return;
- POSITION pos;
- pos=m_List1.GetFirstSelectedItemPosition();
- if(pos==NULL)
- {
- AfxMessageBox("请先选中主卡!");
- return;
- }
- int iItem=m_List1.GetNextSelectedItem(pos);
- CString name=m_List1.GetItemText (iItem, 2);
- CString no=m_List1.GetItemText (iItem, 1);
- CString sql="select count(*) as cot from membercard2blue where [memberno]='"+no+"'";
- g_sendhead.bsql=1;
- g_pMainWnd->ProcessChatMessageRequest2(sql);
- if (g_bSendOK == 0)return;
- if(g_ncount==0)
- {
- InputCard2Dlg dlg;
- dlg.m_mode=1;
- dlg.m_name =name;
- dlg.m_no =no;
- dlg.DoModal ();
- }
- else
- {
- int cardnum=atoi(g_cominfoarray.ElementAt (0).ElementAt (118));
- if(cardnum==0)cardnum=5;
- if(g_ncount>=cardnum)
- {
- AfxMessageBox("副卡已经发出,不能再次发放!", MB_ICONINFORMATION);return;
- }
- InputCard2Dlg dlg;
- dlg.m_bAddOne =1;
- dlg.m_mode=1;
- dlg.m_name =name;
- dlg.m_no =no;
- dlg.DoModal ();
- }
- }
- void ShowMemberBlue::OnButton11()
- {
- // TODO: Add your control notification handler code here
- if(IsHasRights2new(18)==0)return;
- // TODO: Add your control notification handler code here
- POSITION pos;
- pos=m_List1.GetFirstSelectedItemPosition();
- if(pos==NULL)
- {
- AfxMessageBox("请先选中主卡!");
- return;
- }
- int iItem=m_List1.GetNextSelectedItem(pos);
- CString no=m_List1.GetItemText (iItem, 1);
- CString filter="[memberno]='"+no+"'";
- g_sendhead.bsql=0;
- g_sendhead.code[0]=131;
- 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.m_memberno=no;
- dlg.m_name =m_List1.GetItemText (iItem, 2);
- dlg.m_mode=1;
- dlg.DoModal ();
- }
- }
- void ShowMemberBlue::HidePrice()
- {
- #ifdef LKAY_VERSION
- if(IsHasRights2new(31))return;
- for(int i=0; i< m_List1array.GetSize (); i++)
- {
- m_List1array.ElementAt (i).SetAt (4, "***");
- }
- #endif
- }
- void ShowMemberBlue::OnButton9() // 导出xls;
- {
- ListToXLS(&m_List1, _T("C:\\蓝钻会员.xls"), 0, 0);
- }
|