// 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()

/////////////////////////////////////////////////////////////////////////////
// MemberCardFunc2 message handlers

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;
	}
	// TODO: Add extra initialization here
	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;  // return TRUE unless you set the focus to a control
	// EXCEPTION: OCX Property Pages should return FALSE
}

void MemberCardFunc2::OnButton15() 
{
	// TODO: Add your control notification handler code here
	if(IsHasRights2new(18)==0)return;
	// TODO: Add your control notification handler code here
	InputCard2Dlg dlg;
	dlg.m_name =m_name;
	dlg.m_no =m_memberno;
	dlg.DoModal ();	 
}

void MemberCardFunc2::OnButton16() 
{
	// TODO: Add your control notification handler code here
	if(IsHasRights2new(18)==0)return;
	// TODO: Add your control notification handler code here
	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() 
{
	// TODO: Add your control notification handler code here
	if(IsHasRights2new(18)==0)return;
	// TODO: Add your control notification  code


	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() 
{
	// TODO: Add your control notification handler code here

	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() 
{
	// TODO: Add your control notification handler code here

	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() 
{
	// TODO: Add your control notification handler code here
	ShowMemberReg dlg;
	dlg.m_memberno=m_memberno;
	dlg.DoModal ();	
}

void MemberCardFunc2::OnButton10() 
{
	// TODO: Add your control notification handler code here

	ShowMemberReg dlg;
	dlg.m_mode=1;
	dlg.m_memberno=m_memberno;
	dlg.DoModal ();

}

void MemberCardFunc2::OnButton7() 
{
	// TODO: Add your control notification handler code here
	if(IsHasRights2new(49)==0)return;
	// TODO: Add your control notification handler code here
	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() 
{
	// TODO: Add your control notification handler code here
	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() 
{
	// TODO: Add your control notification handler code here
	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)))
	{
		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);
				sql="insert into sendreg([phones],[content],[timestamp],[msgcount],[status],[issended],[isautosend],[ren]) values('"+m_phone+"','"+str+"','"+timestamp+"','"+scount+"','0','0','0','系统自动发送')";
			}
		}
		g_sendhead.bsql=1;
		g_pMainWnd->ProcessChatMessageRequest2(sql);
	}
}

void MemberCardFunc2::OnButton20() // 充值按钮;
{
	// TODO: Add your control notification handler code here	
	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;
	//   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+"')";
	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+"')";

	sql+="***refresh balance memberreg3"+m_memberno;
	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)))
	{
		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(dlg.m_money2), atoi(m_balance));
				int count=GetLengthEx(str)/MSG_LENGTH;
				if(GetLengthEx(str)%MSG_LENGTH)
					count++;
				CString scount;
				scount.Format ("%d", count);
				sql="insert into sendreg([phones],[content],[timestamp],[msgcount],[status],[issended],[isautosend],[ren]) values('"+m_phone+"','"+str+"','"+timestamp+"','"+scount+"','0','0','0','系统自动发送')";
			}
		}
		g_sendhead.bsql=1;
		g_pMainWnd->ProcessChatMessageRequest2(sql);
	}
}

void MemberCardFunc2::OnButton21() // 充值记录;
{
	// TODO: Add your control notification handler code here
	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="[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::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() // 为子卡充值;
{
	// TODO: Add your control notification handler code here	
	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);
				sql="insert into sendreg([phones],[content],[timestamp],[msgcount],[status],[issended],[isautosend],[ren]) values('"+m_phone+"','"+str+"','"+timestamp+"','"+scount+"','0','0','0','系统自动发送')";
			}
		}
		g_sendhead.bsql=1;
		g_pMainWnd->ProcessChatMessageRequest2(sql);
	}


}

void MemberCardFunc2::OnButton28() // 子卡充值记录;
{
	// TODO: Add your control notification handler code here
	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() 
{
	// TODO: Add your control notification handler code here
	ReChargeReg dlg;
	dlg.m_mode=3;
	dlg.m_memberno=m_memberno;
	dlg.m_card2no =m_card2no;
	dlg.DoModal ();
}

void MemberCardFunc2::OnButton29() 
{
	// TODO: Add your control notification handler code here
	if(IsHasRights2new(49)==0)return;
	// TODO: Add your control notification handler code here
	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() // 为子卡提现;
{
	// TODO: Add your control notification handler code here
	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() 
{
	// TODO: Add your control notification handler code here
	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="";
	}
}