lyfz_repos/经典版源码/lyfzInternalClient/branches/716/Booking2.cpp

// Booking2.cpp : implementation file
//

#include "stdafx.h"
#include "ylgl.h"
#include "Booking2.h"
#include "InputMemberno.h"
#include "SelMemberType.h"
#include "AddMember.h"
#include "InputCard2Dlg.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif
/////////////////////////////////////////////////////////////////////////////
// Booking2 dialog time1
Booking2::Booking2(CWnd* pParent /*=NULL*/)
: CDialog(Booking2::IDD, pParent)
{
	m_bModify=0;
	m_bSave=0;
	//}}AFX_DATA_INIT
}

void Booking2::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(Booking2)
	// NOTE: the ClassWizard will add DDX and DDV calls here
	//}}AFX_DATA_MAP
}

BEGIN_MESSAGE_MAP(Booking2, CDialog)

	ON_BN_CLICKED(IDC_BUTinfo1, OnBUTinfo1)
	ON_BN_CLICKED(IDC_BUTinfo2, OnBUTinfo2)
	ON_BN_CLICKED(IDC_BUTinfo3, OnBUTinfo3)
	ON_BN_CLICKED(IDC_BUTclose, OnBUTclose)
	ON_WM_CTLCOLOR()
	ON_BN_CLICKED(IDC_BUTinfo4, OnBUTinfo4)
	ON_BN_CLICKED(IDC_BUTsave, OnBUTsave)
	ON_BN_CLICKED(IDC_BUTnew, OnBUTnew)
	ON_BN_CLICKED(IDC_BUTprint, OnBUTprint)
	ON_BN_CLICKED(IDC_BUTimport, OnBUTimport)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// Booking2 message handlers

void Booking2::OnBUTclose() 
{
	// TODO: Add your control notification handler code here
	if(m_bSave)
		CDialog::OnOK ();
	else
		CDialog::OnCancel ();
}

void Booking2::OnOK() 
{
}

void Booking2::OnCancel() 
{
	CDialog::OnCancel ();
}

HBRUSH Booking2::OnCtlColor(CDC* pDC, CWnd* pWnd, UINT nCtlColor) 
{
	HBRUSH hbr = CDialog::OnCtlColor(pDC, pWnd, nCtlColor);

	// TODO: Change any attributes of the DC here
	if (nCtlColor==CTLCOLOR_STATIC && pWnd->GetDlgCtrlID ()==IDC_STATIC2)
	{
		pDC-> SetBkMode(TRANSPARENT); //设置字体背景为透明
		return (HBRUSH)::GetStockObject(WHITE_BRUSH); // 设置背景色
	} 
	// TODO: Return a different brush if the default is not desired
	return hbr;
}

extern BOOL CALLBACK EnumChildProc2(HWND hwnd,LPARAM lParam);

BOOL Booking2::OnInitDialog() 
{
	CDialog::OnInitDialog();

	// TODO: Add extra initialization here
	if(m_bModify==1)
	{
		SetWindowText("预约单-修改");
		GetDlgItem(IDC_BUTnew)->ShowWindow(0);
		GetDlgItem(IDC_BUTimport)->ShowWindow(0);
		GetDlgItem(IDC_BUTprint)->EnableWindow(1);

		GetDlgItem(IDC_BUTsave)->EnableWindow(IsHasRights2new(1));

		// 如果拍照状态OK,禁用拍照时间edit和拍照状态commbox.
	}
	else if(m_bModify==2)
	{
		SetWindowText("历史预约单");
		GetDlgItem(IDC_BUTnew)->ShowWindow(0);
		GetDlgItem(IDC_BUTimport)->ShowWindow(0);
		GetDlgItem(IDC_BUTprint)->EnableWindow(1);
		GetDlgItem(IDC_BUTsave)->EnableWindow(0);	 
	}

	CRect rc2;
	GetWindowRect(rc2);
	int dty=g_screenhei-768;
	if(0)//dty>0)
	{
		g_rc.bottom -=dty;
		MoveWindow(g_rc);
		g_WidthScale2 = (float)g_rc.Width()/(float)rc2.Width(); // new/Old
		g_HeightScale2 = (float)g_rc.Height()/(float)rc2.Height();
		EnumChildWindows(m_hWnd,(WNDENUMPROC)EnumChildProc2,0);
		g_rc.bottom +=dty;
		MoveWindow(g_rc);
	}
	else
	{
		MoveWindow(g_rc);
		g_WidthScale2 = (float)g_rc.Width()/(float)rc2.Width(); // new/Old
		g_HeightScale2 = (float)g_rc.Height()/(float)rc2.Height();
		EnumChildWindows(m_hWnd,(WNDENUMPROC)EnumChildProc2,0);
	}

	CRect rc;
	GetDlgItem(IDC_STATIC1)->GetWindowRect(rc);
	ScreenToClient(rc);
	GetDlgItem(IDC_STATIC2)->GetWindowRect(rc2);
	ScreenToClient(rc2);
	rc2.left =0;
	rc2.top =0;
	rc2.bottom =rc.top-2 ;
	GetDlgItem(IDC_STATIC2)->MoveWindow(rc2);
	GetDlgItem(IDC_STATIC3)->MoveWindow(rc2);

	rc=rc2;
	rc.top =rc.bottom;
	rc.bottom +=1;
	GetDlgItem(IDC_STATIC4)->MoveWindow(rc);	
	GetDlgItem(IDC_STATIC1)->GetWindowRect(rc2);
	ScreenToClient(rc2);
	rc.top =rc2.bottom;
	rc.bottom =rc.top+1;
	GetDlgItem(IDC_STATIC5)->MoveWindow(rc);	

	OnBUTinfo1();
	return TRUE;  // return TRUE unless you set the focus to a control
	// EXCEPTION: OCX Property Pages should return FALSE
}

// Jeff 按钮：订单资料（第一个选项页,读取所有数据）
void Booking2::OnBUTinfo1()//订单资料按钮; 
{
	// TODO: Add your control notification handler code here
	if(m_page1.GetSafeHwnd ())m_page1.ShowWindow (SW_HIDE);
	if(m_page2.GetSafeHwnd ())m_page2.ShowWindow (SW_HIDE);
	if(m_page3.GetSafeHwnd ())m_page3.ShowWindow (SW_HIDE);
	if(m_page4.GetSafeHwnd ())m_page4.ShowWindow (SW_HIDE);

	if(m_page1.GetSafeHwnd ()==NULL)
	{
		CRect rc;
		GetDlgItem(IDC_STATIC1)->GetWindowRect(rc);
		ScreenToClient(rc);
		m_page1.m_rc=m_page2.m_rc=m_page3.m_rc=m_page4.m_rc=rc;

		g_sendhead.bsql=0;
		g_sendhead.code[0]=6;			// 套系表taoxi;
		g_sendhead.code[1]=7;			// 套系商品1taoxishangpin1;
		g_sendhead.code[2]=10;			// 套系商品2taoxishangpin2;
		g_sendhead.code[3]=4;			// 商品shangpin;
		g_sendhead.code[4]=82;			// 冲印面积area;
		g_sendhead.code[5]=68;			// 人员管理membermanage;
		g_sendhead.code[6]=127;			// membercard2;
		g_sendhead.code[7]=130;			// membermanageblue;
		g_sendhead.code[8]=131;			// membercard2blue;
		g_sendhead.code[9]=77;			// taoxifg;
		g_sendhead.tabcount=10;			// 总共10个表;	

		g_pMainWnd->ProcessChatMessageRequest2("show<>'隐藏'");

		DataToArray(
			&m_page1.m_List1array, \
			&m_page1.m_List2array, \
			&m_page1.m_List3array, \
			&m_page1.m_sparray, \
			&m_page2.m_areaarray, \
			&m_page3.m_List1array,\
			&m_page3.m_List2array,\
			&m_page3.m_List3array,\
			&m_page3.m_List4array,\
			&m_page3.m_List5array);

		if(m_bModify)	// 预约单 - 修改;
		{
			//AfxMessageBox("+++++++++++++++++");
			CString id=m_id;
			g_sendhead.bsql=0;
			CString filter="id='"+id+"';id='"+id+"' and kind<>'5';id='"+id+"';id='"+id+"'";

			g_sendhead.code[0]=11;			// dindan;
			g_sendhead.code[1]=56;			// dindansp;
			g_sendhead.code[2]=150;			// dindanjd;
#ifdef CHILD_VERSION
			g_sendhead.code[3]=94;			// client;
#else
			g_sendhead.code[3]=52;			// client;
#endif
			g_sendhead.tabcount=4;			// 共4张表;

			g_bNoConnDlg=1;		// 设置连接服务器状态为：需要
			g_pMainWnd->ProcessChatMessageRequest2(filter);	
			g_bNoConnDlg=0;		

			if(g_bSendOK==0)
			{
				CDialog::OnCancel();
				return;
			}
			CArray<CStringArray, CStringArray>ClientArray;

			DataToArray(&g_List1array, &m_page1.m_Bakarray, &m_page1.m_List1arrayM, &ClientArray);

			m_page2.m_name1 =  g_List1array.ElementAt (0).ElementAt (4);
			m_page2.m_name2 =  g_List1array.ElementAt (0).ElementAt (5);
			m_page1.m_id= m_id;
			m_page1.m_taoxiid= g_List1array.ElementAt (0).ElementAt (6);
			m_page1.m_taoxiname= g_List1array.ElementAt (0).ElementAt (7);
			m_page1.m_taoxijiage = g_List1array.ElementAt (0).ElementAt (8);
			//	m_page1.m_zs =     g_List1array.ElementAt (0).ElementAt (9);

			CString zs = g_List1array.ElementAt (0).ElementAt (9);
			int pos=zs.Find ("\\");
			if(pos!=-1)
			{
				m_page1.m_zs=zs.Left (pos);
				m_page1.m_zs2=zs.Right (zs.GetLength ()-pos-1);
			}
			else
			{
				m_page1.m_zs=zs;
				m_page1.m_zs2="";
			}

			m_page1.m_growthtxselname =     g_List1array.ElementAt (0).ElementAt (54);

			m_page4.m_time1 =  g_List1array.ElementAt (0).ElementAt (10);
			m_page4.m_time2 =  g_List1array.ElementAt (0).ElementAt (11);
			m_page4.m_time3 =  g_List1array.ElementAt (0).ElementAt (12);
			m_page4.m_time4 = g_List1array.ElementAt (0).ElementAt (21);
			m_page4.m_time5 = g_List1array.ElementAt (0).ElementAt (22);
			m_page4.m_time6 = g_List1array.ElementAt (0).ElementAt (48);
			m_page4.m_time8 = g_List1array.ElementAt (0).ElementAt (72);
			m_page4.m_time9 = g_List1array.ElementAt (0).ElementAt (73);
			m_page4.m_time10 = g_List1array.ElementAt (0).ElementAt (74);

			m_page3.m_bm =       g_List1array.ElementAt (0).ElementAt (13);
			m_page3.m_ren =      g_List1array.ElementAt (0).ElementAt (14);
			m_page1.m_payed1 = g_List1array.ElementAt (0).ElementAt (16);
			m_page4.m_status1 = g_List1array.ElementAt (0).ElementAt (25);
			m_page3.m_clothescount = g_List1array.ElementAt (0).ElementAt (26);
			m_page3.m_clothescount2 = g_List1array.ElementAt (0).ElementAt (27);
			m_page3.m_outside = g_List1array.ElementAt (0).ElementAt (28);
			m_page3.m_outside2 = g_List1array.ElementAt (0).ElementAt (29);
			m_page3.m_style = g_List1array.ElementAt (0).ElementAt (30);
			m_page3.m_memberno = g_List1array.ElementAt (0).ElementAt (47);

			m_page4.m_status2 = g_List1array.ElementAt (0).ElementAt (32);
			m_page4.m_status3 = g_List1array.ElementAt (0).ElementAt (33);
			m_page4.m_waiter1 = g_List1array.ElementAt (0).ElementAt (34);
			m_page4.m_waiter2 = g_List1array.ElementAt (0).ElementAt (35);
			m_page4.m_waiter3 = g_List1array.ElementAt (0).ElementAt (36);
			m_page4.m_waiter4 = g_List1array.ElementAt (0).ElementAt (37);
			m_page1.m_bz = g_List1array.ElementAt (0).ElementAt (38);
			m_page4.m_waiter5 = g_List1array.ElementAt (0).ElementAt (42);
			m_page4.m_waiter7 = g_List1array.ElementAt (0).ElementAt (43);
			m_page4.m_waiter8 = g_List1array.ElementAt (0).ElementAt (76);	// Jeff 看版人
			m_page4.m_status4 = g_List1array.ElementAt (0).ElementAt (44);
			m_page4.m_status5 = g_List1array.ElementAt (0).ElementAt (45);
			m_page4.m_status6 = g_List1array.ElementAt (0).ElementAt (46);
			m_page4.m_status8 = g_List1array.ElementAt (0).ElementAt (55);	// Jeff 看版状态
			m_page1.m_txtype = g_List1array.ElementAt (0).ElementAt (52); 

#ifdef LKAY_VERSION
			m_page1.m_dindantype = g_List1array.ElementAt (0).ElementAt (63); 
			m_page1.m_contractno = g_List1array.ElementAt (0).ElementAt (64); 
			m_page1.m_contractno2 = g_List1array.ElementAt (0).ElementAt (65); 
			m_page3.m_cfno = g_List1array.ElementAt (0).ElementAt (66); 
			m_page3.m_from = g_List1array.ElementAt (0).ElementAt (67); 
			m_page3.m_reason = g_List1array.ElementAt (0).ElementAt (68); 
			m_page4.m_time7 = g_List1array.ElementAt (0).ElementAt (69); 
			m_page4.m_waiter12 = g_List1array.ElementAt (0).ElementAt (50); 
			m_page4.m_waiter13 = g_List1array.ElementAt (0).ElementAt (70); 
			m_page4.m_waiter14 = g_List1array.ElementAt (0).ElementAt (71); 
#else
			m_page1.m_from = g_List1array.ElementAt (0).ElementAt (67); 
#endif
			/////////////////////////////////
#ifdef CHILD_VERSION
			m_page2.m_name1=ClientArray.ElementAt (0).ElementAt (1);
			m_page2.m_name2=ClientArray.ElementAt (0).ElementAt (2);
			m_page2.m_phone1=ClientArray.ElementAt (0).ElementAt (3);
			m_page2.m_phone2=ClientArray.ElementAt (0).ElementAt (4);
			m_page2.m_qq1=ClientArray.ElementAt (0).ElementAt (5);
			m_page2.m_addr1=ClientArray.ElementAt (0).ElementAt (6);
			m_page2.m_birthday1=ClientArray.ElementAt (0).ElementAt (7);
			m_page2.m_area=ClientArray.ElementAt (0).ElementAt (8);
			m_page2.m_sex=ClientArray.ElementAt (0).ElementAt (9);
			m_page2.m_zodiac=ClientArray.ElementAt (0).ElementAt (10);
			m_page2.m_check1=atoi(ClientArray.ElementAt (0).ElementAt (11));
#ifdef LKAY_VERSION
			if(IsHasRights2new(1)==0)
			{
				m_page2.m_addr1="***";
				m_page2.m_phone1="***";
				m_page2.m_phone2="***";
				m_page2.m_qq1="***";
			}
#else
			if(IsHasRights2new(1)==0 && IsHasRights2new(31)==0)
			{
				m_page2.m_addr1="***";
				m_page2.m_phone1="***";
				m_page2.m_phone2="***";
				m_page2.m_qq1="***";
			}
#endif
			///////////////////////////////////
#else
			m_page2.m_name1=ClientArray.ElementAt (0).ElementAt (1);
			m_page2.m_name2=ClientArray.ElementAt (0).ElementAt (2);
			m_page2.m_phone1=ClientArray.ElementAt (0).ElementAt (3);
			m_page2.m_phone2=ClientArray.ElementAt (0).ElementAt (4);
			m_page2.m_qq1=ClientArray.ElementAt (0).ElementAt (5);
			m_page2.m_qq2=ClientArray.ElementAt (0).ElementAt (6);
			m_page2.m_addr1=ClientArray.ElementAt (0).ElementAt (7);
			m_page2.m_addr2=ClientArray.ElementAt (0).ElementAt (8);
			m_page2.m_occupation1=ClientArray.ElementAt (0).ElementAt (9);
			m_page2.m_occupation2=ClientArray.ElementAt (0).ElementAt (10);
			m_page2.m_birthday1=ClientArray.ElementAt (0).ElementAt (11);
			m_page2.m_birthday2=ClientArray.ElementAt (0).ElementAt (12);
			m_page2.m_area=ClientArray.ElementAt (0).ElementAt (13);
			m_page2.m_area2=ClientArray.ElementAt (0).ElementAt (14);
			m_page2.m_check1=atoi(ClientArray.ElementAt (0).ElementAt (15));
			m_page2.m_check2=atoi(ClientArray.ElementAt (0).ElementAt (16));
			m_page4.m_check3=atoi(ClientArray.ElementAt (0).ElementAt (17));
		
			if(IsHasRights2new(1)==0 && IsHasRights2new(31)==0)
			{
				m_page2.m_addr1="***";
				m_page2.m_phone1="***";
				m_page2.m_phone2="***";
				m_page2.m_qq1="***";
			}
#endif
		}
		m_page1.Create (BookingPage1::IDD, this);
#ifdef CHILD_VERSION
		m_page2.Create (IDD_DLGBookingPage22, this);
#else
		m_page2.Create (IDD_DLGBookingPage2, this);
#endif
		m_page3.Create (IDD_DLGBookingPage3, this);
		m_page4.Create (IDD_DLGBookingPage4, this); 
	}
	m_page1.ShowWindow (SW_SHOW);
	CString str;

#ifdef CHILD_VERSION
	str="\r\n\r\n   1. 预约单录入-订单资料\r\n   2. 请在下方录入订单资料后点客人资料进一步录入,打*号的内容是必填项目\r\n   3. 宝宝成长套系录入:可在套系类别中添加一个'成长套系', 然后选择套系类别为成长套系";
#else
	str="\r\n\r\n   1. 预约单录入-订单资料\r\n   2. 请在下方录入订单资料后点客人资料进一步录入,打*号的内容是必填项目\r\n   ";
#endif

	GetDlgItem(IDC_STATIC2)->SetWindowText(str);
}

// Jeff 按钮：客人资料
void Booking2::OnBUTinfo2() //客人资料按钮;
{
	// TODO: Add your control notification handler code here
	if(m_page1.GetSafeHwnd ())m_page1.ShowWindow (SW_HIDE);
	if(m_page2.GetSafeHwnd ())m_page2.ShowWindow (SW_HIDE);
	if(m_page3.GetSafeHwnd ())m_page3.ShowWindow (SW_HIDE);
	if(m_page4.GetSafeHwnd ())m_page4.ShowWindow (SW_HIDE);
	m_page2.ShowWindow (SW_SHOW);
	CString str;
	str="\r\n\r\n   1. 预约单录入-客人资料\r\n   2. 请在下方录入客人资料后点其它资料进一步录入,打*号的内容是必填项目";
	GetDlgItem(IDC_STATIC2)->SetWindowText(str);	
}

// Jeff 按钮：其它资料;
void Booking2::OnBUTinfo3() //其他资料按钮;
{
	// TODO: Add your control notification handler code here
	if(m_page1.GetSafeHwnd ())m_page1.ShowWindow (SW_HIDE);
	if(m_page2.GetSafeHwnd ())m_page2.ShowWindow (SW_HIDE);
	if(m_page3.GetSafeHwnd ())m_page3.ShowWindow (SW_HIDE);
	if(m_page4.GetSafeHwnd ())m_page4.ShowWindow (SW_HIDE);
	m_page3.ShowWindow (SW_SHOW);
	CString str;
	str="\r\n\r\n   1. 预约单录入-其它资料\r\n   2. 请在下方录入其它资料后点日期安排进一步录入,打*号的内容是必填项目";
	GetDlgItem(IDC_STATIC2)->SetWindowText(str);

	if(m_bModify==0) m_page3.ShowMemberDlg();
}

// Jeff 按钮：时间安排;
void Booking2::OnBUTinfo4() //时间安排按钮;
{
	// Jeff.add;
	if ( m_bModify == 1)
	{
		SetDlgItemText(IDC_BUTinfo4,"流程查看");
	}

	// TODO: Add your control notification handler code here
	if(m_page1.GetSafeHwnd ())m_page1.ShowWindow (SW_HIDE);
	if(m_page2.GetSafeHwnd ())m_page2.ShowWindow (SW_HIDE);
	if(m_page3.GetSafeHwnd ())m_page3.ShowWindow (SW_HIDE);
	if(m_page4.GetSafeHwnd ())m_page4.ShowWindow (SW_HIDE);
	m_page4.ShowWindow(SW_SHOW);
	CString str;
	str="\r\n\r\n   1. 预约单录入-日期安排\r\n   2. 请在下方录入客人拍照日期，选片日期，选片人等信息后点保存订单";
	GetDlgItem(IDC_STATIC2)->SetWindowText(str);	
}


extern BOOL CovertDate(CString &date, CString &date2);

// Jeff 按钮：保存订单;
void Booking2::OnBUTsave() //保存订单
{
	m_bSave=1;
	if(this->m_bModify)
	{
		OnBUTsave2();
		return;
	}
	// TODO: Add your control notification handler code here
	if(!m_page1.CheckOK ())
	{
		AfxMessageBox("资料不全,打*号的项目必须填写!", MB_ICONINFORMATION);
		OnBUTinfo1();return;
	}
	if(!m_page2.CheckOK ())
	{
		AfxMessageBox("资料不全,打*号的项目必须填写!", MB_ICONINFORMATION);
		OnBUTinfo2();return;
	}
	if(!m_page3.CheckOK ())
	{
		AfxMessageBox("资料不全,打*号的项目必须填写!", MB_ICONINFORMATION);
		OnBUTinfo3();return;
	}
	if(!m_page4.CheckOK ())
	{
		AfxMessageBox("资料不全,打*号的项目必须填写!", MB_ICONINFORMATION);
		OnBUTinfo4();return;
	}

	CString id=m_page1.m_id;
	CString sql;
	if(atoi(g_cominfoarray.ElementAt(0).ElementAt(121)))
	{
		g_bNoConnDlg=1;
		CString date=g_date;

		sql="select count(*) as cot from dindan where id='"+id+"' ";
		g_sendhead.bsql=1;
		g_pMainWnd->ProcessChatMessageRequest2(sql);
		g_bNoConnDlg=0;
		if(g_bSendOK==0)return;
		if(g_ncount)
		{
			AfxMessageBox("已有此单号的订单，请重新编写单号!", MB_ICONINFORMATION);
			OnBUTinfo1();
			return;
		}
	}
	else
	{
		g_bNoConnDlg=1;
		CString date=g_date;

		sql="select count(*) as cot from dindan where id='"+id+"' ";
		g_sendhead.bsql=1;
		g_pMainWnd->ProcessChatMessageRequest2(sql);
		g_bNoConnDlg=0;
		if(g_bSendOK==0)return;
	
		if(g_ncount) // Jeff 查询dindan表时返回的记录数：g_ncount;
		{
			g_bNoConnDlg=1;
			CString date=g_date;date.Replace("-", "");

			sql="select max(id) as cot from dindan where id like '"+date+"%' ";
			g_sendhead.bsql=1;
			g_pMainWnd->ProcessChatMessageRequest2(sql);
			g_bNoConnDlg=0;
			if(g_bSendOK==0)return;
			date.Replace ("-", "");
			id.Format ("%s-%03d", date, g_ncount+1);
		}
	}

	if(IsHasRights2(0)==0)
		return;
	// TODO: Add your control notification handler code here

	CString m_taoxiid=m_page1.m_taoxiid;
	CString taoxiname=m_page1.m_taoxiname;
	CString m_growthtxselname=m_page1.m_growthtxselname;
	CString m_taoxijiage=m_page1.m_taoxijiage;
	CString m_payed1=m_page1.m_payed1;
	//	CString m_zs=m_page1.m_zs;  
	CString m_zs=m_page1.m_zs+"\\"+m_page1.m_zs2;
	CString txtype=m_page1.m_txtype;
	CString m_bz=m_page1.m_bz;
	CString m_authorize=m_page1.m_authorize;
	BOOL m_bGrowthTX=m_page1.m_bGrowthTX;
#ifdef LKAY_VERSION
	CString m_dindantype=m_page1.m_dindantype;
	CString m_contractno=m_page1.m_contractno;
	CString m_contractno2=m_page1.m_contractno2;

	CString m_cfno=m_page3.m_cfno;
	CString m_from=m_page3.m_from;
	CString m_reason=m_page3.m_reason;

	CString m_time7=m_page4.m_time7;
	CString m_waiter12=m_page4.m_waiter12;
	CString m_waiter13=m_page4.m_waiter13;
	CString m_waiter14=m_page4.m_waiter14;
#else
	CString m_from = (m_page2.m_nIntentionPos == -1) ? m_page1.m_from : _T("系统意向");
#endif

	CString bm = m_page3.m_bm;
	CString ren =m_page3.m_ren;
	CString m_clothescount=m_page3.m_clothescount;
	CString m_clothescount2=m_page3.m_clothescount2;
	CString m_outside=m_page3.m_outside;
	CString m_outside2=m_page3.m_outside2;
	CString m_style=m_page3.m_style;
	CString strmoney="0";
	CString m_discount;
	if(atof(m_taoxijiage)>0 && (m_page1.m_saleprice1+m_page1.m_saleprice2)>0)
		m_discount.Format ("%0.2f", min(10.0, (atof(m_taoxijiage)*10)/(m_page1.m_saleprice1+m_page1.m_saleprice2)) );
	else
		m_discount="0";

#ifdef CHILD_VERSION
	CString m_name1=m_page2.m_name1;
	CString m_name2=m_page2.m_name2;
	CString m_phone1=m_page2.m_phone1;
	CString m_phone2=m_page2.m_phone2;
	CString m_qq1=m_page2.m_qq1;
	CString m_addr1=m_page2.m_addr1;
	CString m_birthday1=m_page2.m_birthday1;
	CString m_area=m_page2.m_area;
	BOOL m_check1=m_page2.m_check1;
	CString m_zodiac=m_page2.m_zodiac;
	CString m_sex=m_page2.m_sex;
	CString m_birthday2,m_qq2,m_addr2;
#else
	CString m_name1=m_page2.m_name1;
	CString m_name2=m_page2.m_name2;
	CString m_phone1=m_page2.m_phone1;
	CString m_phone2=m_page2.m_phone2;
	CString m_qq1=m_page2.m_qq1;
	CString m_qq2=m_page2.m_qq2;
	CString m_addr1=m_page2.m_addr1;
	CString m_addr2=m_page2.m_addr2;
	CString m_occupation1=m_page2.m_occupation1;	
	CString m_occupation2=m_page2.m_occupation2;
	CString m_birthday1=m_page2.m_birthday1;
	CString m_birthday2=m_page2.m_birthday2;
	CString m_area=m_page2.m_area;
	CString m_area2=m_page2.m_area2;
	BOOL m_check1=m_page2.m_check1;
	BOOL m_check2=m_page2.m_check2;
#endif
	CString m_time1=m_page4.m_time1;
	CString m_time2=m_page4.m_time2;
	CString m_time3=m_page4.m_time3;
	CString m_time4=m_page4.m_time4;
	CString m_time5=m_page4.m_time5;
	CString m_time6=m_page4.m_time6;
	CString m_time8=m_page4.m_time8;
	CString m_time9=m_page4.m_time9;
	CString m_time10=m_page4.m_time10;

	CString m_waiter1=m_page4.m_waiter1;
	CString m_waiter2=m_page4.m_waiter2;
	CString m_waiter3=m_page4.m_waiter3;
	CString m_waiter4=m_page4.m_waiter4;
	CString m_waiter5=m_page4.m_waiter5;
	CString m_waiter7=m_page4.m_waiter7;
	CString m_waiter8=m_page4.m_waiter8;	// Jeff 看版人waiter8
	CString m_status1=m_page4.m_status1;
	CString m_status2=m_page4.m_status2;
	CString m_status3=m_page4.m_status3;
	CString m_status4=m_page4.m_status4;
	CString m_status5=m_page4.m_status5;
	CString m_status6=m_page4.m_status6;
	//CString m_status8=m_page4.m_status8;	// Jeff 看版状态status8
	BOOL m_check3=m_page4.m_check3;

	CString str,str2;
	CString strRes1,strRes2;
	GetFirstLetter(m_name1, strRes1);
	GetFirstLetter(m_name2, strRes2);
	CString m_memberno=m_page3.m_memberno;

	CString m_membernotemp=m_memberno;
	if(m_page3.m_type)m_memberno.Empty ();

	if(txtype=="成长套系" && m_growthtxselname.IsEmpty ()==0)
	{
		taoxiname+="cztx";
	}

	// Jeff add;
	CString strInputTime;
	strInputTime = CTime::GetCurrentTime().Format("%Y-%m-%d %H:%M:%S");
	// end;

#if 0 // Jeff 原版
	sql.Format("insert into [dindan]([id],[growthtxselname],[money1],[name1],[name2],[taoxiid],[taoxiname],[taoxijiage],[taoxizs],[time1],[time2],[time3],[time4],[time5],[time6],[time8],[time9],[time10],[bm],[ren],[discount],[payed1],[status],[status2],[status3],[status4],[status5],[status6],[status7],[status8],[urgent],[bz],[pinyin1],[pinyin2],[clothescount],[clothescount2],[outside],[outside2],[style],[waiter1],[waiter2],[waiter3],[waiter4],[waiter5],[waiter6],[waiter7],[memberno],[txtype],[tichenren1],[tichenren2],[tichenren3],[tichenren4],[tichenren5],[phone1],[phone2],[authorize],[from])	values('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','未刻','未看','否','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','','','','','','%s','%s','%s','%s')",
			id,m_growthtxselname,strmoney,m_name1,m_name2,m_taoxiid,taoxiname,m_taoxijiage,m_zs,m_time1,m_time2,m_time3,m_time4,m_time5,m_time6,m_time8,m_time9,m_time10,bm,ren,m_discount,m_payed1,m_status1,m_status2,m_status3,m_status4,m_status5,m_status6,FilterBZ(m_bz),strRes1,strRes2,
			m_clothescount,m_clothescount2,m_outside,m_outside2,m_style,m_waiter1,m_waiter2,m_waiter3,m_waiter4,m_waiter5,g_user.name,m_waiter7,m_memberno,txtype,m_phone1,m_phone2,m_authorize,m_from
			);
#else// Jeff添加看设计人和看设计状态;
#if 0// Jeff:原没有选片录入和录入时间;
	sql.Format("insert into [dindan]([id],[growthtxselname],[money1],[name1],[name2],[taoxiid],[taoxiname],[taoxijiage],[taoxizs],[time1],[time2],[time3],[time4],[time5],[time6],[time8],[time9],[time10],[bm],[ren],[discount],[payed1],[status],[status2],[status3],[status4],[status5],[status6],[status7],[status8],[urgent],[bz],[pinyin1],[pinyin2],[clothescount],[clothescount2],[outside],[outside2],[style],[waiter1],[waiter2],[waiter3],[waiter4],[waiter5],[waiter6],[waiter7],[waiter8],[memberno],[txtype],[tichenren1],[tichenren2],[tichenren3],[tichenren4],[tichenren5],[phone1],[phone2],[authorize],[from])values('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','未刻','未看','否','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','','','','','','%s','%s','%s','%s')",
		id,m_growthtxselname,strmoney,m_name1,m_name2,m_taoxiid,taoxiname, m_taoxijiage,m_zs,m_time1,m_time2,m_time3,m_time4,m_time5,m_time6,m_time8,m_time9,m_time10,bm,ren,m_discount,m_payed1,m_status1,m_status2,m_status3,m_status4,m_status5,m_status6,FilterBZ(m_bz),strRes1,strRes2, 
		m_clothescount,m_clothescount2,m_outside,m_outside2,m_style,m_waiter1,m_waiter2,m_waiter3,m_waiter4,m_waiter5,g_user.name,m_waiter7,m_waiter8,
		m_memberno,txtype,m_phone1,m_phone2,m_authorize,m_from);
#else
	
	sql.Format("insert into [dindan]([id],[growthtxselname],[money1],[name1],[name2],[taoxiid],[taoxiname],[taoxijiage],[taoxizs],[time1],[time2],[time3],[time4],[time5],[time6],[time8],[time9],[time10],[bm],[ren],[discount],[payed1],[status],[status2],[status3],[status4],[status5],[status6],[status7],[status8],[urgent],[bz],[pinyin1],[pinyin2],[clothescount],[clothescount2],[outside],[outside2],[style],[waiter1],[waiter2],[waiter3],[waiter4],[waiter5],[waiter6],[waiter7],[waiter8],[memberno],[txtype],[tichenren1],[tichenren2],[tichenren3],[tichenren4],[tichenren5],[phone1],[phone2],[authorize],[from],[xplrr],[xplrtime])values('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','未刻','未看','否','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','','','','','','%s','%s','%s','%s','%s','%s')",
			   id,m_growthtxselname,strmoney,m_name1,m_name2,m_taoxiid,taoxiname, m_taoxijiage,m_zs,
			   m_time1,m_time2,m_time3,m_time4,m_time5,m_time6,m_time8,m_time9,m_time10,bm,ren,m_discount,m_payed1,
			   m_status1,m_status2,m_status3,m_status4,m_status5,m_status6,FilterBZ(m_bz),strRes1,strRes2,
			   m_clothescount,m_clothescount2,m_outside,m_outside2,m_style,m_waiter1,m_waiter2,m_waiter3,m_waiter4,m_waiter5,g_user.name,m_waiter7,m_waiter8,
			   m_memberno,txtype,m_phone1,m_phone2,m_authorize,m_from,g_user.name,CTime::GetCurrentTime().Format("%Y-%m-%d %H:%M:%S"));
#endif
#endif

#ifdef LKAY_VERSION
#if 0 // Jeff 原版
		sql.Format ("insert into [dindan]([id],[growthtxselname],[money1],[name1],[name2],[taoxiid],[taoxiname],[taoxijiage],[taoxizs],[time1],[time2],[time3],[time4],[time5],[time6],[time8],[time9],[time10],[bm],[ren],[discount],[payed1],[status],[status2],[status3],[status4],[status5],[status6],[status7],[status8],[urgent],[bz],[pinyin1],[pinyin2],[clothescount],[clothescount2],[outside],[outside2],[style],[waiter1],[waiter2],[waiter3],[waiter4],[waiter5],[waiter6],[waiter7],[memberno],[txtype],[tichenren1],[tichenren2],[tichenren3],[tichenren4],[tichenren5],[phone1],[phone2],[dindantype],[contractno1],[contractno2],[cfno],[from],[reason],[time7],[waiter12],[waiter13],[waiter14],[authorize])values('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','未刻','未看','否','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','','','','','','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s')",
			id,m_growthtxselname,strmoney,m_name1,m_name2,m_taoxiid,taoxiname,m_taoxijiage,m_zs,m_time1,
			m_time2,m_time3,m_time4,m_time5,m_time6,m_time8,m_time9,m_time10,bm,ren,m_discount,m_payed1,
			m_status1,m_status2,m_status3,m_status4,m_status5,m_status6,FilterBZ(m_bz),strRes1,strRes2,
			m_clothescount,m_clothescount2,m_outside,m_outside2,m_style,m_waiter1,m_waiter2,m_waiter3,m_waiter4,m_waiter5,
			g_user.name,m_waiter7,m_memberno,txtype,m_phone1,m_phone2,m_dindantype,m_contractno,m_contractno2,m_cfno,m_from,m_reason,m_time7,m_waiter12,m_waiter13,m_waiter14,m_authorize);

#else	// Jeff添加看设计人和看设计状态;
	sql.Format ("insert into [dindan]([id],[growthtxselname],[money1],[name1],[name2],[taoxiid],[taoxiname],[taoxijiage],[taoxizs],[time1],[time2],[time3],[time4],[time5],[time6],[time8],[time9],[time10],[bm],[ren],[discount],[payed1],[status],[status2],[status3],[status4],[status5],[status6],[status7],[status8],[urgent],[bz],[pinyin1],[pinyin2],[clothescount],[clothescount2],[outside],[outside2],[style],[waiter1],[waiter2],[waiter3],[waiter4],[waiter5],[waiter6],[waiter7],[waiter8],[memberno],[txtype],[tichenren1],[tichenren2],[tichenren3],[tichenren4],[tichenren5],[phone1],[phone2],[dindantype],[contractno1],[contractno2],[cfno],[from],[reason],[time7],[waiter12],[waiter13],[waiter14],[authorize],[xplrr],[xplrtime])	values('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','未刻','未看','否','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','','','','','','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s')",
		id,m_growthtxselname,strmoney,m_name1,m_name2,m_taoxiid,taoxiname,m_taoxijiage,m_zs,m_time1,m_time2,m_time3,m_time4,m_time5,m_time6,m_time8,m_time9,m_time10,bm,ren,m_discount,m_payed1,
		m_status1,m_status2,m_status3,m_status4,m_status5,m_status6,FilterBZ(m_bz),strRes1,strRes2,m_clothescount,m_clothescount2,m_outside,m_outside2,m_style,m_waiter1,m_waiter2,m_waiter3,m_waiter4,m_waiter5,g_user.name,m_waiter7,m_waiter8,
		m_memberno,txtype,m_phone1,m_phone2,m_dindantype,m_contractno,m_contractno2,m_cfno,m_from,m_reason,m_time7,m_waiter12,m_waiter13,m_waiter14,m_authorize,g_user.name,CTime::GetCurrentTime().Format("%Y-%m-%d %H:%M:%S"));
#endif
#endif

	CString sql2;
	CStringArray idarray;
	idarray.Add(id);
#ifdef CHILD_VERSION
	sql2.Format ("###insert into [client]([name1],[name2],[phone1],[phone2],[qq1],[addr1],[birthday1],[id],[area],[sex],[zodiac],[check1])values('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%d')",m_name1,m_name2,m_phone1,m_phone2,m_qq1,m_addr1,m_birthday1,id,m_area,m_sex,m_zodiac,m_check1);
	sql+=sql2;
	if(txtype=="成长套系" && m_growthtxselname.IsEmpty ()==0)
	{
		CString sqltemp=sql;
		CString taoxinametemp=taoxiname.Left(taoxiname.GetLength()-4);
		CString m_selname=m_growthtxselname;
		int pos=m_selname.Find (",");
		CStringArray selnamearray;
		while(pos!=-1)
		{
			selnamearray.Add (m_selname.Left (pos));
			m_selname=m_selname.Right (m_selname.GetLength ()-pos-1);
			pos=m_selname.Find (",");
		}
		selnamearray.Add (m_selname);
		int idpos=atoi(id.Right (3));
		CString newid,temp;
		for(int ii=0; ii<selnamearray.GetSize (); ii++)
		{
			taoxinametemp=taoxiname;taoxinametemp+=selnamearray.ElementAt (ii);
			if(ii==0)
			{
				sql.Replace (taoxiname, taoxinametemp);
				continue;
			}
			newid.Format ("%s%03d", id.Left (id.GetLength ()-3), ++idpos);idarray.Add(newid);
			temp=sqltemp;
			temp.Replace (id, newid);
			temp.Replace (taoxiname, taoxinametemp);
			sql+="###"+temp;
		}
	}

	if(atoi(g_cominfoarray.ElementAt(0).ElementAt(39)) )
	{
		CString m_content3 = g_cominfoarray.ElementAt(0).ElementAt(40);
		CString str,timestamp;
		timestamp="msgtimestamp";
		{  
			CString name;
			if(!m_name1.IsEmpty ())
				name=m_name1+",";
			name+=m_name2;
			name.TrimRight (",");
			if(name.IsEmpty ()==0 && CheckPhoneType(m_phone1)!=-1 && CheckBadWords(name,0)  )
			{

				str=name+m_content3;
				str.Replace ("xxx小朋友", "");

				int count=GetLengthEx(str)/MSG_LENGTH;
				if(GetLengthEx(str)%MSG_LENGTH)
					count++;
				CString scount;
				scount.Format ("%d", count);
#if JEFF_TEST_ON
				sql2.Format(INSERT_SENDREG, _T("3"), m_phone1, str, timestamp, scount, _T("0"), _T("0"), _T("0"), _T("系统自动发送"));
				sql += _T("###") + sql2;
#else
				sql2="###insert into [sendreg]([phones],[content],[timestamp],[msgcount],[status],[issended],[isautosend],[ren]) values('"+m_phone1+"','"+str+"','"+timestamp+"','"+scount+"','0','0','0','系统自动发送')";
				sql+=sql2;
#endif
			}
		}
	}
#else
	sql2.Format ("###insert into [client]([name1],[name2],[phone1],[phone2],[qq1],[qq2],[addr1],[addr2],[occupation1],[occupation2],[birthday1],[birthday2],[id],[area],[area2],[check1],[check2],[check3])values('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%d','%d','%d')",m_name1,m_name2,m_phone1,m_phone2,m_qq1,m_qq2,m_addr1,m_addr2,m_occupation1,m_occupation2,m_birthday1,m_birthday2,id,m_area,m_area2,m_check1,m_check2,m_check3);
	sql+=sql2;

	if(txtype=="成长套系" && m_growthtxselname.IsEmpty ()==0)
	{
		CString sqltemp=sql;
		CString taoxinametemp=taoxiname.Left(taoxiname.GetLength()-4);
		CString m_selname=m_growthtxselname;
		int pos=m_selname.Find (",");
		CStringArray selnamearray;
		while(pos!=-1)
		{
			selnamearray.Add (m_selname.Left (pos));
			m_selname=m_selname.Right (m_selname.GetLength ()-pos-1);
			pos=m_selname.Find (",");
		}
		selnamearray.Add (m_selname);
		int idpos=atoi(id.Right (3));
		CString newid,temp;
		for(int ii=0; ii<selnamearray.GetSize (); ii++)
		{
			taoxinametemp=taoxiname;taoxinametemp+=selnamearray.ElementAt (ii);
			if(ii==0)
			{
				sql.Replace (taoxiname, taoxinametemp);
				continue;
			}
			newid.Format ("%s%03d", id.Left (id.GetLength ()-3), ++idpos);idarray.Add(newid);
			temp=sqltemp;
			temp.Replace (id, newid);
			temp.Replace (taoxiname, taoxinametemp);
			sql+="###"+temp;
		}
	}

	if(atoi(g_cominfoarray.ElementAt(0).ElementAt(39)))
	{
		CString m_content3 = g_cominfoarray.ElementAt(0).ElementAt(40);
		CString str,timestamp;
		timestamp="msgtimestamp";
		int pos=m_content3.Find("xxx先生/女士");	
		if(pos!=-1)
		{
			if(m_name1.IsEmpty ()==0 && CheckPhoneType(m_phone1)!=-1 && CheckBadWords(m_name1,0))
			{
				str=m_content3;
#ifdef LYFZ_VERSION
				str.Replace ("xxx先生/女士", m_name1);
#else
				str.Replace ("xxx先生/女士", m_name1+"先生");
#endif

				int count=GetLengthEx(str)/MSG_LENGTH;
				if(GetLengthEx(str)%MSG_LENGTH)
					count++;
				CString scount;
				scount.Format ("%d", count);
#if JEFF_TEST_ON
				sql2.Format(INSERT_SENDREG, _T("3"), m_phone1, str, timestamp, scount, _T("0"), _T("0"), _T("0"), _T("系统自动发送"));
				sql += _T("###") + sql2;
#else
				sql2="###insert into [sendreg]([phones],[content],[timestamp],[msgcount],[status],[issended],[isautosend],[ren]) values('"+m_phone1+"','"+str+"','"+timestamp+"','"+scount+"','0','0','0','系统自动发送')";
				sql+=sql2;
#endif
			}

#ifndef LYFZ_VERSION
			if(m_name2.IsEmpty ()==0 && CheckPhoneType(m_phone2)!=-1 && CheckBadWords(m_name2,0) )
			{
				str=m_content3;
				str.Replace ("xxx先生/女士", m_name2+"女士");
				int count=GetLengthEx(str)/MSG_LENGTH;
				if(GetLengthEx(str)%MSG_LENGTH)
					count++;
				CString scount;
				scount.Format ("%d", count);
				CTime tm=CTime::GetCurrentTime ();
				tm+=CTimeSpan(0,0,0,3);
				timestamp=tm.Format ("%Y%m%d%H%M%S");
				timestamp="msgtimexxstamp";
#if JEFF_TEST_ON
				sql2.Format(INSERT_SENDREG, _T("3"), m_phone2, str, timestamp, scount, _T("0"), _T("0"), _T("0"), _T("系统自动发送"));
				sql += _T("###") + sql2;
#else
				sql2="###insert into [sendreg]([phones],[content],[timestamp],[msgcount],[status],[issended],[isautosend],[ren]) values('"+m_phone2+"','"+str+"','"+timestamp+"','"+scount+"','0','0','0','系统自动发送')";
				sql+=sql2;
#endif
			}
#endif
		}
	}
#endif
	////////////////////////
	if(atoi(g_cominfoarray.ElementAt(0).ElementAt(117)))//新摄控本
	{
		CString	timestamp;
		CTime tm=CTime::GetCurrentTime ();
		CTimeSpan dt(0,0,0,1);
		timestamp=tm.Format ("%Y%m%d%H%M%S");
		CString phone,clothescount;
		if(m_time2!="")
		{
			phone=m_phone1+" "+m_phone2;
			phone.TrimLeft ();
			if(m_clothescount!="")
				clothescount="服装:"+m_clothescount;
			sql2.Format ("###insert into [todaytake]([name],[phone],[time],[type],[price],[waiter1],[waiter2],[receptionist],[arrearage],[remark],[clerk],[timestamp],[date],[mode],[arrive],[id])values('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%d','%s','%s')",
				m_name1+m_name2,phone,"",taoxiname,m_taoxijiage,m_waiter1,m_waiter2,ren,m_taoxijiage,clothescount,g_user.name,timestamp,m_time2,0,"未到",id);
			sql+=sql2;
		}
		if(m_time4!="")
		{
			tm+=dt;
			timestamp=tm.Format ("%Y%m%d%H%M%S");
			phone=m_phone1+" "+m_phone2;
			phone.TrimLeft ();
			if(m_clothescount!="")
				clothescount="服装:"+m_clothescount;
			sql2.Format ("###insert into [todaytake]([name],[phone],[time],[type],[price],[waiter1],[waiter2],[receptionist],[arrearage],[remark],[clerk],[timestamp],[date],[mode],[arrive],[id])values('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%d','%s','%s')",
				m_name1+m_name2,phone,"",taoxiname,m_taoxijiage,m_waiter1,m_waiter2,ren,m_taoxijiage,clothescount,g_user.name,timestamp,m_time4,1,"未到",id);
			sql+=sql2;
		}
		if(m_time6!="")
		{	
			tm+=dt;
			timestamp=tm.Format ("%Y%m%d%H%M%S");
			phone=m_phone1+" "+m_phone2;
			phone.TrimLeft ();
			if(m_clothescount!="")
				clothescount="服装:"+m_clothescount;
			sql2.Format ("###insert into [todaytake]([name],[phone],[time],[type],[price],[waiter1],[waiter2],[receptionist],[arrearage],[remark],[clerk],[timestamp],[date],[mode],[arrive],[id])values('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%d','%s','%s')",
				m_name1+m_name2,phone,"",taoxiname,m_taoxijiage,m_waiter1,m_waiter2,ren,m_taoxijiage,clothescount,g_user.name,timestamp,m_time6,2,"未到",id);
			sql+=sql2;
		}
		if(m_time5!="")
		{	
			tm+=dt;
			timestamp=tm.Format ("%Y%m%d%H%M%S");
			phone=m_phone1+" "+m_phone2;
			phone.TrimLeft ();
			if(m_clothescount!="")
				clothescount="服装:"+m_clothescount;
			sql2.Format ("###insert into [todaytake]([name],[phone],[time],[type],[price],[waiter1],[waiter2],[receptionist],[arrearage],[remark],[clerk],[timestamp],[date],[mode],[arrive],[id])values('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%d','%s','%s')",
				m_name1+m_name2,phone,"",taoxiname,m_taoxijiage,m_waiter1,m_waiter2,ren,m_taoxijiage,clothescount,g_user.name,timestamp,m_time5,3,"未到",id);
			sql+=sql2;
		}
	}
	////////////////////////////
	sql2="###"+id+"$$$"+m_memberno;
	sql+=sql2;
	
	//AfxMessageBox(sql);	//Jeff输出SQL语句
//	LOG4C((LOG_NOTICE,"sql=%s",sql.GetBuffer(0)));sql.ReleaseBuffer();
	
//	printf("Jeff:%s\n\n", sql.GetBuffer(0));sql.ReleaseBuffer();	//控制台输出;
//	printf("Jeff:sql语句长度=%d\n\n",strlen(sql.GetBuffer(0))+1 );sql.ReleaseBuffer();

	//Sleep(2000);system("cls");

	m_memberno=m_membernotemp;
	g_sendhead.bsql=1;
	g_pMainWnd->ProcessChatMessageRequest2(sql);if(g_bSendOK==0)return;

//	printf("Jeff:Booking2发送订单SQL成功,等待接收....\n\n");

	CArray<CStringArray, CStringArray>sparray;

	if(m_bGrowthTX)
		sparray.SetSize(m_page1.m_List1arraygrowthbak.GetSize()+m_page1.m_List3.GetItemCount ()+m_page1.m_listbox1.GetCount(), 1);
	else
	{
		sparray.SetSize(m_page1.m_List1.GetItemCount() + m_page1.m_List3.GetItemCount() + m_page1.m_listbox1.GetCount() + (( m_page2.m_nIntentionPos == -1) ? 0 : 3) , 1);
	}


	int realcount=0;
	int i;
	if(m_bGrowthTX)
	{
		for( i=0; i<m_page1.m_List1arraygrowthbak.GetSize(); i++)
		{
			int arraygrowthbaksize=m_page1.m_List1arraygrowthbak.ElementAt (i).GetSize();
			str=m_page1.m_List1arraygrowthbak.ElementAt (i).ElementAt(1);

			str.TrimLeft ();		
			str.TrimRight ();
			if(str.IsEmpty ())
				continue;
			sparray.ElementAt (realcount).Add ( id );
			sparray.ElementAt (realcount).Add ( m_page1.m_List1arraygrowthbak.ElementAt (i).ElementAt(0) );
			sparray.ElementAt (realcount).Add ( m_page1.m_List1arraygrowthbak.ElementAt (i).ElementAt(2) );
			sparray.ElementAt (realcount).Add ( m_page1.m_List1arraygrowthbak.ElementAt (i).ElementAt(3) );
			sparray.ElementAt (realcount).Add ( "1" );
			sparray.ElementAt (realcount).Add ( m_page1.m_List1arraygrowthbak.ElementAt (i).ElementAt(1) );
			sparray.ElementAt (realcount).Add ( m_page1.m_List1arraygrowthbak.ElementAt (i).ElementAt(4) );
			sparray.ElementAt (realcount).Add ( m_page1.m_List1arraygrowthbak.ElementAt (i).ElementAt(5) );
			sparray.ElementAt (realcount).Add ( m_page1.m_List1arraygrowthbak.ElementAt (i).ElementAt(arraygrowthbaksize-1) );
			realcount++;
		}
	}
	else
	{
		for( i=0; i<m_page1.m_List1.GetItemCount (); i++)
		{
			str=m_page1.m_List1.GetItemText (i, 1);
			str.TrimLeft ();		
			str.TrimRight ();
			if(str.IsEmpty ())
				continue;
			sparray.ElementAt (realcount).Add ( id );										// 订单号;
			sparray.ElementAt (realcount).Add ( m_page1.m_List1.GetItemText (i, 0) );		// 商品ID;
			sparray.ElementAt (realcount).Add ( m_page1.m_List1.GetItemText (i, 2) );		// 商品价格;
			sparray.ElementAt (realcount).Add ( m_page1.m_List1.GetItemText (i, 3) );		// 商品数量;
			sparray.ElementAt (realcount).Add ( "1" );										// 商品类型;	
			sparray.ElementAt (realcount).Add ( m_page1.m_List1.GetItemText (i, 1) );		// 商品名称;
			sparray.ElementAt (realcount).Add ( m_page1.m_List1.GetItemText (i, 4) );		// 是否加急;
			sparray.ElementAt (realcount).Add ( m_page1.m_List1.GetItemText (i, 5) );		// 取件日期;
			realcount++;
		}

		if ( m_page2.m_nIntentionPos != -1 )
		{
			sparray.ElementAt(realcount).Add( id );										// 订单号;
			sparray.ElementAt(realcount).Add( _T("IC_YWY") );							// 商品ID;(意向顾客业务员)
			sparray.ElementAt(realcount).Add( _T("") );									// 商品价格;
			sparray.ElementAt(realcount).Add( _T("") );									// 商品数量;
			sparray.ElementAt(realcount).Add( "1" );									// 商品类型;	
			sparray.ElementAt(realcount).Add( _T("业务员：") + g_oldclientarray.ElementAt(m_page2.m_nIntentionPos).ElementAt(9) );		// 商品名称(意向顾客业务员);
			sparray.ElementAt(realcount).Add( _T("") );									// 是否加急;
			sparray.ElementAt(realcount).Add( _T("") );									// 取件日期;
			realcount++;

			sparray.ElementAt(realcount).Add( id );										// 订单号;
			sparray.ElementAt(realcount).Add( _T("IC_DT") );							// 商品ID;(意向日期)
			sparray.ElementAt(realcount).Add( _T("") );									// 商品价格;
			sparray.ElementAt(realcount).Add( _T("") );									// 商品数量;
			sparray.ElementAt(realcount).Add( "1" );									// 商品类型;	
			sparray.ElementAt(realcount).Add( _T("日期：") + g_oldclientarray.ElementAt(m_page2.m_nIntentionPos).ElementAt(10) );		// 商品名称(意向顾客业务员);
			sparray.ElementAt(realcount).Add( _T("") );									// 是否加急;
			sparray.ElementAt(realcount).Add( _T("") );									// 取件日期;
			realcount++;

			sparray.ElementAt(realcount).Add( id );										// 订单号;
			sparray.ElementAt(realcount).Add( _T("IC_NOTE") );							// 商品ID;(意向顾客备注)
			sparray.ElementAt(realcount).Add( _T("") );									// 商品价格;
			sparray.ElementAt(realcount).Add( _T("") );									// 商品数量;
			sparray.ElementAt(realcount).Add( "1" );									// 商品类型;	
			sparray.ElementAt(realcount).Add( _T("业务员：") + g_oldclientarray.ElementAt(m_page2.m_nIntentionPos).ElementAt(11) );		// 商品名称(意向顾客业务员);
			sparray.ElementAt(realcount).Add( _T("") );									// 是否加急;
			sparray.ElementAt(realcount).Add( _T("") );									// 取件日期;
			realcount++;
		}
	}

	for( i=0; i<m_page1.m_List3.GetItemCount (); i++)
	{
		str=m_page1.m_List3.GetItemText (i, 1);
		str.TrimLeft ();		
		str.TrimRight ();
		if(str.IsEmpty ())
			continue;
		sparray.ElementAt (realcount).Add ( id );											// 订单号;
		sparray.ElementAt (realcount).Add ( m_page1.m_List3.GetItemText (i, 0) );			// 商品ID;
		sparray.ElementAt (realcount).Add ( m_page1.m_List3.GetItemText (i, 2) );			// 商品价格;
		sparray.ElementAt (realcount).Add ( m_page1.m_List3.GetItemText (i, 3) );			// 商品数量;
		sparray.ElementAt (realcount).Add ( "2" );											// 商品类型;	
		sparray.ElementAt (realcount).Add ( m_page1.m_List3.GetItemText (i, 1) );			// 商品名称;
		sparray.ElementAt (realcount).Add ( "" );											// 是否加急;
		sparray.ElementAt (realcount).Add ( "" );											// 取件日期;
		realcount++;
	}

	for(i=0; i<m_page1.m_listbox1.GetCount (); i++)
	{// 景点;
		m_page1.m_listbox1.GetText (i, str);	
		sparray.ElementAt (realcount).Add ( id );
		sparray.ElementAt (realcount).Add ( str );
		realcount++;
	}

	if(realcount==0)
	{
		sparray.SetSize(1, 1);
		sparray.ElementAt (0).Add (id);
	}
	else if(idarray.GetSize()>1)
	{
		sparray.SetSize(realcount+1, 1);	
		sparray.ElementAt (realcount).Add("成长套系");
		for(int a=0; a<idarray.GetSize(); a++)
		{
			sparray.ElementAt (realcount).Add ( idarray.ElementAt(a) );
		}
	}
	else
		sparray.SetSize(realcount, 1);

	realcount=sparray.GetSize ();
	sparray.SetSize(realcount+1, 1);
	sparray.ElementAt (realcount).Add (g_user.name);

	CMemFile memfile;
	CArchive ar(&memfile, CArchive::store);
	for(int ii=0; ii<sparray.GetSize (); ii++)
	{
		sparray.ElementAt (ii).Serialize (ar);
	}
	ar.Close();
	int length=memfile.GetLength ();
	BYTE *pData = memfile.Detach();
	int size=sparray.GetSize ();
	BYTE *pData2=new BYTE[length+sizeof(int)];
	memcpy(pData2, pData, length);
	memcpy(pData2+length, &size, sizeof(int));
	delete []pData;
	length+=sizeof(int);
	g_nSendCode=3;
	g_pMainWnd->ProcessChatMessageRequest2(pData2, length);
	g_nSendCode=0;
	delete []pData2;
	if(g_bSendOK==0)
		return;

#ifndef CHILD_VERSION
	if(m_time3.IsEmpty ()==0)
	{
		CString date=m_time3;
		CString date2;
		if(m_check3)
			CovertDate(date, date2);        
		sql.Format ("update dindansp set hqdate='%s' where id='%s'", date, id);

		if(atoi(g_cominfoarray.ElementAt(0).ElementAt(117)))//新摄控本
		{
			CString	timestamp;
			CTime tm=CTime::GetCurrentTime ();
			CTimeSpan dt(0,0,0,10);
			tm+=dt;
			timestamp=tm.Format ("%Y%m%d%H%M%S");
			CString phone,clothescount,content;
			for( i=0; i<m_page1.m_List3.GetItemCount (); i++)
			{
				str=m_page1.m_List3.GetItemText (i, 1);
				str.TrimLeft ();		str.TrimRight ();
				if(str.IsEmpty ())continue;
				content+=str;
				content+=",";
			}
			content.TrimRight (",");
			if(content!="")
			{
				phone=m_phone1+" "+m_phone2;
				phone.TrimLeft ();
				if(m_clothescount!="")
					clothescount="服装:"+m_clothescount;
				sql2.Format ("***insert into [todaytake]([name],[phone],[time],[type],[price],[waiter1],[waiter2],[receptionist],[arrearage],[remark],[clerk],[timestamp],[date],[mode],[arrive],[content],[id])values('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%d','%s','%s','%s')",
					m_name1+m_name2,phone,"",taoxiname,m_taoxijiage,m_waiter1,m_waiter2,ren,m_taoxijiage,clothescount,g_user.name,timestamp,date,4,"未到",content,id);
				sql+=sql2;
			}
		}
		////////////////////////////

		g_sendhead.bsql=1;
		g_pMainWnd->ProcessChatMessageRequest2(sql);if(g_bSendOK==0)return;
	}
#endif
	AfxMessageBox("保存成功!", MB_ICONINFORMATION);

	// 保存成功后，删除意向信息;
	if ( m_page2.m_nIntentionPos != -1 )
	{
		// 保存成功后，删除意向信息;
		sql = "DELETE FROM client2 WHERE id='"+ g_oldclientarray.ElementAt(m_page2.m_nIntentionPos).ElementAt(0) +"' ";
		g_sendhead.bsql=1;
		g_pMainWnd->ProcessChatMessageRequest2(sql);
		g_bNoConnDlg=0;
		
		INT nTimes = 3;
		while ( !g_bSendOK && nTimes > 0 )
		{
			g_sendhead.bsql=1;
			g_pMainWnd->ProcessChatMessageRequest2(sql);
			g_bNoConnDlg=0;
			nTimes--;
		}
	}

	CString m_type = _T(""); 
	m_type.Format(_T("%d"),m_page3.m_type);
	if (m_type == _T("1") || m_type == _T("3"))
	{
		if (m_type == _T("1"))
		{
			CString m_point;
			m_point.Format ("%d", atol(m_taoxijiage));


			CString m_card2no=m_page3.m_memberno2;

			CString date2=m_page3.m_memberno2date;
			CString m_name=m_page3.m_membernoname ;
			CString m_sex=m_page3.m_membernosex ;
			CString m_phone=m_page3.m_membernophone ;
			CString sql;
			sql="delete from membercard2 where [card2no]='"+m_card2no+"'";
			sql+="@@@insert into memberreg([memberno],[dindanid],[money],[date],[card2no],[type],[taoxi],[date2])values('"+m_memberno+"','"+id+"','"+m_point+"','"+g_date+"','"+m_card2no+"','转介绍','"+taoxiname+"','"+date2+"')";
			sql+="@@@";

			m_point.Format ("%d", (int) (atof(m_taoxijiage)*GetPointScale()));
			if( atoi(g_cominfoarray.ElementAt(0).ElementAt(51)) )
			{
				CString m_content5 = g_cominfoarray.ElementAt(0).ElementAt(52);
				CString content,timestamp;

				CString name;
				if(!m_name1.IsEmpty ())
					name=m_name1+",";
				name+=m_name2;
				name.TrimRight (",");
				CString name2=m_name;
#ifndef CHILD_VERSION
				if(m_sex=="男")
					name2+="先生";
				else if(m_sex=="女")
					name2+="女士";
#endif
				content.Format ("%s您好,您的朋友%s为您积分%s分.", name2, name, m_point);
				content+=m_content5;

				timestamp="msgtimestamp";
				if( CheckPhoneType(m_phone)!=-1 && CheckBadWords(content,0)  )
				{
					int count=GetLengthEx(content)/MSG_LENGTH;
					if(GetLengthEx(content)%MSG_LENGTH)
						count++;
					CString scount;
					scount.Format ("%d", count);
#if JEFF_TEST_ON
					CString sql2 = _T("");
					sql2.Format(INSERT_SENDREG, _T("5"), m_phone, content, timestamp, scount, _T("0"), _T("0"), _T("0"), _T("系统自动发送"));
					sql += sql2;
#else
					CString sql2="insert into sendreg([phones],[content],[timestamp],[msgcount],[status],[issended],[isautosend],[ren]) values('"+m_phone+"','"+content+"','"+timestamp+"','"+scount+"','0','0','0','系统自动发送')";
					sql+=sql2;
#endif
					sql+="@@@";
				}
			}
			sql+=m_memberno;
			g_sendhead.bsql=1;
			g_pMainWnd->ProcessChatMessageRequest2(sql);if(g_bSendOK==0)return;
		}
		else if(m_type=="3")
		{
			CString m_rate;
			CString filter="[memberno]='"+m_memberno+"'";

			g_sendhead.bsql=0;
			g_sendhead.code[0]=132;
			g_sendhead.tabcount=1;
			g_pMainWnd->ProcessChatMessageRequest2(filter);if(g_bSendOK==0)return;
			DataToArray(&g_List1array);

			CString	m_bluescale1;
			CString	m_bluescale2;
			CString	m_bluescale3;
			CString	m_bluescale4;
			CString	m_bluescale5;
			CString	m_bluescale6;
			CString	m_bluescale7;
			CString	m_bluescale8;
			CString	m_bluescale9;
			CString	m_bluescale10;
			CString str=(g_cominfoarray.ElementAt (0).ElementAt (119));
			if(str=="")
				str="5,10,15,20,50,0,0,0,0,0";
			int pos=str.Find(",");
			m_bluescale1=str.Left(pos);
			str=str.Right(str.GetLength()-pos-1);
			pos=str.Find(",");
			m_bluescale2=str.Left(pos);
			str=str.Right(str.GetLength()-pos-1);
			pos=str.Find(",");
			m_bluescale3=str.Left(pos);
			str=str.Right(str.GetLength()-pos-1);
			pos=str.Find(",");
			m_bluescale4=str.Left(pos);
			str=str.Right(str.GetLength()-pos-1);
			pos=str.Find(",");
			m_bluescale5=str.Left(pos);
			str=str.Right(str.GetLength()-pos-1);
			pos=str.Find(",");
			m_bluescale6=str.Left(pos);
			str=str.Right(str.GetLength()-pos-1);
			pos=str.Find(",");
			m_bluescale7=str.Left(pos);
			str=str.Right(str.GetLength()-pos-1);
			pos=str.Find(",");
			m_bluescale8=str.Left(pos);
			str=str.Right(str.GetLength()-pos-1);
			pos=str.Find(",");
			m_bluescale9=str.Left(pos);
			str=str.Right(str.GetLength()-pos-1);
			m_bluescale10=str.Left(pos);
			if(g_List1array.GetSize ()%10==0)
				m_rate=m_bluescale1+"%";
			else if(g_List1array.GetSize ()%10==1)
				m_rate=m_bluescale2+"%";
			else if(g_List1array.GetSize ()%10==2)
				m_rate=m_bluescale3+"%";
			else if(g_List1array.GetSize ()%10==3)
				m_rate=m_bluescale4+"%";
			else if(g_List1array.GetSize ()%10==4)
				m_rate=m_bluescale5+"%";
			else if(g_List1array.GetSize ()%10==5)
				m_rate=m_bluescale6+"%";
			else if(g_List1array.GetSize ()%10==6)
				m_rate=m_bluescale7+"%";
			else if(g_List1array.GetSize ()%10==7)
				m_rate=m_bluescale8+"%";
			else if(g_List1array.GetSize ()%10==8)
				m_rate=m_bluescale9+"%";
			else if(g_List1array.GetSize ()%10==9)
				m_rate=m_bluescale10+"%";
			else
				m_rate="0%";

			float frate=atof(m_rate)/100.0;
			CString m_point;
			m_point.Format ("%d", (int)(min(atof(m_taoxijiage),atof(m_page3.m_membernojiage))*frate));

			BOOL bCheck=1;
			if(atof(m_taoxijiage)<atof(m_page3.m_membernojiage))
			{
				AfxMessageBox("此套系金额小于主套系，无法返现!");
				bCheck=0;
			}

			if(bCheck)
			{
				CString m_card2no=m_page3.m_memberno2;

				CString date2=m_page3.m_memberno2date;
				CString m_name=m_page3.m_membernoname ;
				CString m_sex=m_page3.m_membernosex ;
				CString m_phone=m_page3.m_membernophone ;

				CString sql;
				sql="delete from membercard2blue where [card2no]='"+m_card2no+"'";
				sql+="~~~insert into memberregblue([memberno],[dindanid],[money],[date],[card2no],[type],[taoxi],[date2])values('"+m_memberno+"','"+id+"','"+m_point+"','"+g_date+"','"+m_card2no+"','转介绍','"+taoxiname+"','"+date2+"')";
				sql+="~~~";

				if( atoi(g_cominfoarray.ElementAt(0).ElementAt(51)) )
				{
					CString m_content5 = g_cominfoarray.ElementAt(0).ElementAt(52);
					CString content,timestamp;

					CString name;
					if(!m_name1.IsEmpty ())
						name=m_name1+",";
					name+=m_name2;
					name.TrimRight (",");
					CString name2=m_name;
#ifndef CHILD_VERSION
					if(m_sex=="男")
						name2+="先生";
					else if(m_sex=="女")
						name2+="女士";
#endif
					content.Format ("%s您好,您的朋友%s为您返现金%s元.", name2, name, m_point);
					content+=m_content5;
					timestamp="msgtimestamp";


					if( CheckPhoneType(m_phone)!=-1 && CheckBadWords(content,0) )
					{	
						int count=GetLengthEx(content)/MSG_LENGTH;
						if(GetLengthEx(content)%MSG_LENGTH)
							count++;
						CString scount;
						scount.Format ("%d", count);
#if JEFF_TEST_ON
						CString sql2 = _T("");
						sql2.Format(INSERT_SENDREG, _T("5"), m_phone, content, timestamp, scount, _T("0"), _T("0"), _T("0"), _T("系统自动发送"));
						sql += sql2;
#else
						CString sql2="insert into sendreg([phones],[content],[timestamp],[msgcount],[status],[issended],[isautosend],[ren]) values('"+m_phone+"','"+content+"','"+timestamp+"','"+scount+"','0','0','0','系统自动发送')";
						sql+=sql2;
#endif
						sql+="~~~";
					}
				}
				sql+=m_memberno;
				g_sendhead.bsql=1;
				g_pMainWnd->ProcessChatMessageRequest2(sql);if(g_bSendOK==0)return;
			}
		}
	}
	CString phone;
	BOOL bNeedCard=0;
	if(m_type==1 || m_type==2 || m_type==3)
		bNeedCard=1;
	if(m_memberno.IsEmpty ())
		bNeedCard=1;
	if(bNeedCard)
	{
		SelMemberType dlg;
		if(dlg.DoModal ()==IDOK)
		{
			if(dlg.m_type==0)
			{
				AddMember dlg;

				if(m_name2!="")
					dlg.m_name = m_name2 ;
				else
					dlg.m_name = m_name1 ;

				if(m_phone2!="")
					dlg.m_phone=m_phone2;
				else
					dlg.m_phone=m_phone1;

				if(m_birthday2!="")
					dlg.m_birthday=m_birthday2;
				else
					dlg.m_birthday=m_birthday1;

				if(m_qq2!="")
					dlg.m_qq=m_qq2;
				else
					dlg.m_qq=m_qq1;

				if(m_addr2!="")
					dlg.m_addr=m_addr2;
				else
					dlg.m_addr=m_addr1;

				if(dlg.DoModal ()==IDOK)
				{
					if(AfxMessageBox("会员添加成功，是否发放副卡?", MB_YESNO|MB_ICONINFORMATION)==IDYES)
					{
						InputCard2Dlg dlg2;
						dlg2.m_name =dlg.m_name;
						dlg2.m_no =dlg.m_memberno ;
						dlg2.DoModal ();
					}
					sql="update  dindan set [memberno]='"+dlg.m_memberno+"' where [id]='"+id+"'";
					g_sendhead.bsql=1;
					g_pMainWnd->ProcessChatMessageRequest2(sql);if(g_bSendOK==0)return;
				}
			}
			else
			{
				AddMember dlg;
				dlg.m_mode=1;
				if(m_name2!="")
					dlg.m_name = m_name2 ;
				else
					dlg.m_name = m_name1 ;

				if(m_phone2!="")
					dlg.m_phone=m_phone2;
				else
					dlg.m_phone=m_phone1;

				if(m_birthday2!="")
					dlg.m_birthday=m_birthday2;
				else
					dlg.m_birthday=m_birthday1;

				if(m_qq2!="")
					dlg.m_qq=m_qq2;
				else
					dlg.m_qq=m_qq1;

				if(m_addr2!="")
					dlg.m_addr=m_addr2;
				else
					dlg.m_addr=m_addr1;
				dlg.m_jiage =m_taoxijiage;
				if(dlg.DoModal ()==IDOK)
				{
					if(AfxMessageBox("会员添加成功，是否发放副卡?", MB_YESNO|MB_ICONINFORMATION)==IDYES)
					{
						InputCard2Dlg dlg2;
						dlg2.m_mode=1;
						dlg2.m_name =dlg.m_name;
						dlg2.m_no =dlg.m_memberno ;
						dlg2.DoModal ();
					}
					sql="update  dindan set [memberno]='"+dlg.m_memberno+"' where [id]='"+id+"'";
					g_sendhead.bsql=1;
					g_pMainWnd->ProcessChatMessageRequest2(sql);if(g_bSendOK==0)return;
				}
			}
		}
	}
	GetDlgItem(IDC_BUTprint)->EnableWindow(1);
	if(!m_bModify)
		GetDlgItem(IDC_BUTsave)->EnableWindow(0);
}

// Jeff 保存"预约单-修改"的数据;
void Booking2::OnBUTsave2()//保存修改;
{
	// TODO: Add your control notification handler code here
	if(!m_page1.CheckOK ())
	{
		AfxMessageBox("资料不全,打*号的项目必须填写!", MB_ICONINFORMATION);
		OnBUTinfo1();return;
	}
	if(!m_page2.CheckOK ())
	{
		AfxMessageBox("资料不全,打*号的项目必须填写!", MB_ICONINFORMATION);
		OnBUTinfo2();return;
	}
	if(!m_page3.CheckOK ())
	{
		AfxMessageBox("资料不全,打*号的项目必须填写!", MB_ICONINFORMATION);
		OnBUTinfo3();return;
	}
	if(!m_page4.CheckOK ())
	{
		AfxMessageBox("资料不全,打*号的项目必须填写!", MB_ICONINFORMATION);
		OnBUTinfo4();return;
	}

	if(IsHasRights2(1)==0)
		return;
	// TODO: Add your control notification handler code here

	CString id=m_id;
	CString m_taoxiid=m_page1.m_taoxiid;
	CString taoxiname=m_page1.m_taoxiname;
	CString m_growthtxselname=m_page1.m_growthtxselname;
	CString m_taoxijiage=m_page1.m_taoxijiage;
	CString m_payed1=m_page1.m_payed1;
	//	CString m_zs=m_page1.m_zs;  
	CString m_zs=m_page1.m_zs+"\\"+m_page1.m_zs2;

	CString txtype=m_page1.m_txtype; 
	CString m_bz=m_page1.m_bz;
	CString bm=m_page3.m_bm;
	CString ren=m_page3.m_ren;
	CString m_clothescount=m_page3.m_clothescount;
	CString m_clothescount2=m_page3.m_clothescount2;
	CString m_outside=m_page3.m_outside;
	CString m_outside2=m_page3.m_outside2;
	CString m_style=m_page3.m_style;
	CString strmoney="0";
	BOOL m_bGrowthTX=m_page1.m_bGrowthTX;
#ifdef LKAY_VERSION
	CString m_dindantype=m_page1.m_dindantype;
	CString m_contractno=m_page1.m_contractno;
	CString m_contractno2=m_page1.m_contractno2;
	CString m_cfno=m_page3.m_cfno;
	CString m_from=m_page3.m_from;
	CString m_reason=m_page3.m_reason;
	CString m_time7=m_page4.m_time7;
	CString m_waiter12=m_page4.m_waiter12;
	CString m_waiter13=m_page4.m_waiter13;
	CString m_waiter14=m_page4.m_waiter14;
#else
	CString m_from=m_page1.m_from;
#endif

#ifdef CHILD_VERSION
	CString m_name1=m_page2.m_name1;
	CString m_name2=m_page2.m_name2;
	CString m_phone1=m_page2.m_phone1;
	CString m_phone2=m_page2.m_phone2;
	CString m_qq1=m_page2.m_qq1;
	CString m_addr1=m_page2.m_addr1;
	CString m_birthday1=m_page2.m_birthday1;
	CString m_area=m_page2.m_area;
	BOOL m_check1=m_page2.m_check1;
	CString m_zodiac=m_page2.m_zodiac;
	CString m_sex=m_page2.m_sex;
#else
	CString m_name1=m_page2.m_name1;
	CString m_name2=m_page2.m_name2;
	CString m_phone1=m_page2.m_phone1;
	CString m_phone2=m_page2.m_phone2;
	CString m_qq1=m_page2.m_qq1;
	CString m_qq2=m_page2.m_qq2;
	CString m_addr1=m_page2.m_addr1;
	CString m_addr2=m_page2.m_addr2;
	CString m_occupation1=m_page2.m_occupation1;	
	CString m_occupation2=m_page2.m_occupation2;
	CString m_birthday1=m_page2.m_birthday1;
	CString m_birthday2=m_page2.m_birthday2;
	CString m_area=m_page2.m_area;
	CString m_area2=m_page2.m_area2;
	BOOL m_check1=m_page2.m_check1;
	BOOL m_check2=m_page2.m_check2;
#endif

	CString m_time1=m_page4.m_time1;
	CString m_time2=m_page4.m_time2;
	CString m_time3=m_page4.m_time3;
	CString m_time4=m_page4.m_time4;
	CString m_time5=m_page4.m_time5;
	CString m_time6=m_page4.m_time6;
	CString m_time8=m_page4.m_time8;
	CString m_time9=m_page4.m_time9;
	CString m_time10=m_page4.m_time10;

	CString m_time2old=m_page4.m_time2old;
	CString m_time4old=m_page4.m_time4old;
	CString m_time5old=m_page4.m_time5old;
	CString m_time6old=m_page4.m_time6old;

	CString m_waiter1=m_page4.m_waiter1;
	CString m_waiter2=m_page4.m_waiter2;
	CString m_waiter3=m_page4.m_waiter3;
	CString m_waiter4=m_page4.m_waiter4;
	CString m_waiter5=m_page4.m_waiter5;
	CString m_waiter7=m_page4.m_waiter7;
	CString m_waiter8=m_page4.m_waiter8;  //Jeff 看版人 waiter8
	CString m_status1=m_page4.m_status1;
	CString m_status2=m_page4.m_status2;
	CString m_status3=m_page4.m_status3;
	CString m_status4=m_page4.m_status4;
	CString m_status5=m_page4.m_status5;
	CString m_status6=m_page4.m_status6;
	CString m_status8=m_page4.m_status8;	// Jeff 看版状态 status8
	BOOL m_check3=m_page4.m_check3;

	CString waiter3_old = m_page4.m_waiter3_old;// Jeff add;

	CString sql,str,str2;
	CString strRes1,strRes2;
	GetFirstLetter(m_name1, strRes1);
	GetFirstLetter(m_name2, strRes2);
	CString m_memberno=m_page3.m_memberno;

	if(m_page3.m_type==1 || m_page3.m_type==3)//副卡
		m_memberno=m_page3.m_memberno2;
	CString m_membernotemp=m_memberno;
	if(m_page3.m_type)m_memberno.Empty ();
#if 0 // Jeff Old Edition
	sql.Format ("update dindan set name1='%s',name2='%s',taoxiid='%s',taoxiname='%s',taoxizs='%s',time2='%s',time3='%s',time4='%s',time5='%s',time6='%s',time8='%s',time9='%s',time10='%s',waiter1='%s',waiter2='%s',waiter3='%s',waiter4='%s',waiter5='%s',waiter6='%s',waiter7='%s',status='%s',status2='%s',status3='%s',status4='%s',status5='%s',status6='%s',bm='%s',ren='%s',bz='%s',pinyin1='%s',pinyin2='%s',clothescount='%s',clothescount2='%s',outside='%s',outside2='%s',style='%s',taoxijiage='%s',txtype='%s',growthtxselname='%s',[phone1]='%s',[phone2]='%s',[memberno]='%s',[from]='%s' where id='%s' ",
				m_name1,m_name2,m_taoxiid,taoxiname,m_zs,m_time2,m_time3,m_time4,m_time5,m_time6,m_time8,m_time9,m_time10,
				m_waiter1,m_waiter2,m_waiter3,m_waiter4,m_waiter5,g_user.name,m_waiter7,m_status1,m_status2,m_status3,m_status4,m_status5,m_status6,
				bm,ren,FilterBZ(m_bz),strRes1,strRes2,m_clothescount,m_clothescount2,m_outside,m_outside2,m_style,m_taoxijiage,txtype,m_growthtxselname,m_phone1,m_phone2,m_memberno,m_from,id);
#else // Jeff update;
	if( waiter3_old == m_waiter3 )// 选片人未更改;
	{
		sql.Format ("update dindan set name1='%s',name2='%s',taoxiid='%s',taoxiname='%s', taoxizs='%s',time2='%s',time3='%s',time4='%s',time5='%s',time6='%s',time8='%s',time9='%s',time10='%s',waiter1='%s',waiter2='%s',waiter3='%s',waiter4='%s',waiter5='%s',waiter6='%s',waiter7='%s',waiter8='%s',status='%s',status2='%s',status3='%s',status4='%s',status5='%s',status6='%s',status8='%s',bm='%s',ren='%s',bz='%s',pinyin1='%s',pinyin2='%s',clothescount='%s',clothescount2='%s',outside='%s',outside2='%s',style='%s',taoxijiage='%s',txtype='%s',growthtxselname='%s',[phone1]='%s',[phone2]='%s',[memberno]='%s',[from]='%s' where id='%s' ",
					m_name1,m_name2,m_taoxiid,taoxiname,m_zs,m_time2,m_time3,m_time4,m_time5,m_time6,m_time8,m_time9,m_time10,
					m_waiter1,m_waiter2,m_waiter3,m_waiter4,m_waiter5,g_user.name,m_waiter7,m_waiter8,m_status1,m_status2,m_status3,m_status4,m_status5,m_status6,m_status8,
					bm,ren,FilterBZ(m_bz),strRes1,strRes2,m_clothescount,m_clothescount2,m_outside,m_outside2,m_style,m_taoxijiage,txtype,m_growthtxselname,m_phone1,m_phone2,m_memberno,m_from,id);
	}
	else
	{
		sql.Format ("update dindan set name1='%s',name2='%s',taoxiid='%s',taoxiname='%s', taoxizs='%s',time2='%s',time3='%s',time4='%s',time5='%s',time6='%s',time8='%s',time9='%s',time10='%s',waiter1='%s',waiter2='%s',waiter3='%s',waiter4='%s',waiter5='%s',waiter6='%s',waiter7='%s',waiter8='%s',status='%s',status2='%s',status3='%s',status4='%s',status5='%s',status6='%s',status8='%s',bm='%s',ren='%s',bz='%s',pinyin1='%s',pinyin2='%s',clothescount='%s',clothescount2='%s',outside='%s',outside2='%s',style='%s',taoxijiage='%s',txtype='%s',growthtxselname='%s',[phone1]='%s',[phone2]='%s',[memberno]='%s',[from]='%s',[xplrr]='%s',[xplrtime]='msgtimestamp2' where id='%s' ",
					m_name1,m_name2,m_taoxiid,taoxiname,m_zs,m_time2,m_time3,m_time4,m_time5,m_time6,m_time8,m_time9,m_time10,m_waiter1,m_waiter2,m_waiter3,m_waiter4,m_waiter5,g_user.name,m_waiter7,m_waiter8,
					m_status1,m_status2,m_status3,m_status4,m_status5,m_status6,m_status8,bm,ren,FilterBZ(m_bz),strRes1,strRes2,m_clothescount,m_clothescount2,m_outside,m_outside2,m_style,m_taoxijiage,txtype,m_growthtxselname,m_phone1,m_phone2,m_memberno,m_from,g_user.name,id
					);
	}

	// Jeff.add 2014.08.30;
	CString strSQL;
	if ( m_status1 == "OK" )	// 若整体的订单拍照状态为OK，则设置订单下所有景点的拍照状态都为OK;
	{
		strSQL.Format("***update dindanjd set status='OK' where id='%s'",id);
		sql += strSQL;
	}
#endif

#ifdef LKAY_VERSION
#if 0// Jeff Old Edition
	sql.Format ("update dindan set name1='%s',name2='%s',taoxiid='%s',taoxiname='%s',taoxizs='%s',time2='%s',time3='%s',time4='%s',time5='%s',time6='%s',time8='%s',time9='%s',time10='%s',waiter1='%s',waiter2='%s',waiter3='%s',waiter4='%s',waiter5='%s',waiter6='%s',waiter7='%s',status='%s',status2='%s',status3='%s',status4='%s',status5='%s',status6='%s',bm='%s',ren='%s',bz='%s',pinyin1='%s',pinyin2='%s',clothescount='%s',clothescount2='%s',outside='%s',outside2='%s',style='%s',taoxijiage='%s',txtype='%s',growthtxselname='%s',[phone1]='%s',[phone2]='%s',[memberno]='%s',[dindantype]='%s',[contractno1]='%s',[contractno2]='%s',[cfno]='%s',[from]='%s',[reason]='%s',[time7]='%s',[waiter12]='%s',[waiter13]='%s',[waiter14]='%s' where id='%s' ",
		m_name1,m_name2,m_taoxiid,taoxiname,m_zs,m_time2,m_time3,m_time4,m_time5,m_time6,m_time8,m_time9,m_time10,
				m_waiter1,m_waiter2,m_waiter3,m_waiter4,m_waiter5,g_user.name,m_waiter7,m_status1,m_status2,m_status3,m_status4,m_status5,m_status6,
				bm,ren,FilterBZ(m_bz),strRes1,strRes2,m_clothescount,m_clothescount2,m_outside,m_outside2,m_style,m_taoxijiage,txtype,m_growthtxselname,m_phone1,m_phone2,m_memberno,
				m_dindantype,m_contractno,m_contractno2,m_cfno,m_from,m_reason,m_time7,m_waiter12,m_waiter13,m_waiter14,id);
#else // Jeff update
	if(waiter3_old == m_waiter3)
	{
		sql.Format ("update dindan set name1='%s',name2='%s',taoxiid='%s',taoxiname='%s',taoxizs='%s',time2='%s',time3='%s',time4='%s',time5='%s',time6='%s',time8='%s',time9='%s',time10='%s',waiter1='%s',waiter2='%s',waiter3='%s',waiter4='%s',waiter5='%s',waiter6='%s',waiter7='%s',waiter8='%s',status='%s',status2='%s',status3='%s',status4='%s',status5='%s',status6='%s',status8='%s',bm='%s',ren='%s',bz='%s',pinyin1='%s',pinyin2='%s',clothescount='%s',clothescount2='%s',outside='%s',outside2='%s',style='%s',taoxijiage='%s',txtype='%s',growthtxselname='%s',[phone1]='%s',[phone2]='%s',[memberno]='%s',[dindantype]='%s',[contractno1]='%s',[contractno2]='%s',[cfno]='%s',[from]='%s',[reason]='%s',[time7]='%s',[waiter12]='%s',[waiter13]='%s',[waiter14]='%s' where id='%s' ",
			m_name1,m_name2,m_taoxiid,taoxiname,m_zs,m_time2,m_time3,m_time4,m_time5,m_time6,m_time8,m_time9,m_time10,
			m_waiter1,m_waiter2,m_waiter3,m_waiter4,m_waiter5,g_user.name,m_waiter7,m_waiter8,m_status1,m_status2,m_status3,m_status4,m_status5,m_status6,m_status8,
			bm,ren,FilterBZ(m_bz),strRes1,strRes2,m_clothescount,m_clothescount2,m_outside,m_outside2,m_style,m_taoxijiage,txtype,m_growthtxselname,
			m_phone1,m_phone2,m_memberno,m_dindantype,m_contractno,m_contractno2,m_cfno,m_from,m_reason,m_time7,m_waiter12,m_waiter13,m_waiter14,id);
	}
	else
	{
		sql.Format ("update dindan set name1='%s',name2='%s',taoxiid='%s',taoxiname='%s',taoxizs='%s',time2='%s',time3='%s',time4='%s',time5='%s',time6='%s',time8='%s',time9='%s',time10='%s',waiter1='%s',waiter2='%s',waiter3='%s',waiter4='%s',waiter5='%s',waiter6='%s',waiter7='%s',waiter8='%s',status='%s',status2='%s',status3='%s',status4='%s',status5='%s',status6='%s',status8='%s',bm='%s',ren='%s',bz='%s',pinyin1='%s',pinyin2='%s',clothescount='%s',clothescount2='%s',outside='%s',outside2='%s',style='%s',taoxijiage='%s',txtype='%s',growthtxselname='%s',[phone1]='%s',[phone2]='%s',[memberno]='%s',[dindantype]='%s',[contractno1]='%s',[contractno2]='%s',[cfno]='%s',[from]='%s',[reason]='%s',[time7]='%s',[waiter12]='%s',[waiter13]='%s',[waiter14]='%s',[xplrr]='%s',[xplrtime]='msgtimestamp2' where id='%s' ",
			m_name1,m_name2,m_taoxiid,taoxiname,m_zs,m_time2,m_time3,m_time4,m_time5,m_time6,m_time8,m_time9,m_time10,
					m_waiter1,m_waiter2,m_waiter3,m_waiter4,m_waiter5,g_user.name,m_waiter7,m_waiter8,
					m_status1,m_status2,m_status3,m_status4,m_status5,m_status6,m_status8,
					bm,ren,FilterBZ(m_bz),strRes1,strRes2,m_clothescount,m_clothescount2,
					m_outside,m_outside2,m_style,m_taoxijiage,txtype,m_growthtxselname,m_phone1,m_phone2,m_memberno,
					m_dindantype,m_contractno,m_contractno2,m_cfno,m_from,m_reason,m_time7,m_waiter12,m_waiter13,m_waiter14,g_user.name,id);
	}
#endif
#endif

	CString sql2;
#ifdef CHILD_VERSION
	sql2.Format ("***update [client] set [name1]='%s',[name2]='%s',[phone1]='%s',[phone2]='%s',[qq1]='%s',[addr1]='%s',[birthday1]='%s',[area]='%s',[sex]='%s',[zodiac]='%s',[check1]='%d' where [id]='%s' ", 
		m_name1,m_name2,m_phone1,m_phone2,m_qq1,m_addr1,m_birthday1,m_area,m_sex,m_zodiac,m_check1,id);
#else
	sql2.Format ("***update [client] set [name1]='%s',[name2]='%s',[phone1]='%s',[phone2]='%s',[qq1]='%s',[qq2]='%s',[addr1]='%s',[addr2]='%s',[occupation1]='%s',[occupation2]='%s',[birthday1]='%s',[birthday2]='%s',[area]='%s',[area2]='%s',[check1]='%d',[check2]='%d',[check3]='%d' where [id]='%s' ", 
		m_name1,m_name2,m_phone1,m_phone2,m_qq1,m_qq2,m_addr1,m_addr2,m_occupation1,m_occupation2,m_birthday1,m_birthday2,m_area,m_area2,m_check1,m_check2,m_check3,id);
#endif
	sql+=sql2;
	////////////////////////
	if(atoi(g_cominfoarray.ElementAt(0).ElementAt(117)))//新摄控本
	{
		CString	timestamp;
		CTime tm=CTime::GetCurrentTime ();
		CTimeSpan dt(0,0,0,1);
		timestamp=tm.Format ("%Y%m%d%H%M%S");
		CString phone,clothescount;


		if(m_time2!="" && m_time2old!=m_time2)
		{
			phone=m_phone1+" "+m_phone2;
			phone.TrimLeft ();
			if(m_clothescount!="")
				clothescount="服装:"+m_clothescount;
			if(m_time2old=="")
				sql2.Format ("***insert into [todaytake]([name],[phone],[time],[type],[price],[waiter1],[waiter2],[receptionist],[arrearage],[remark],[clerk],[timestamp],[date],[mode],[arrive],[id])values('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%d','%s','%s')",
				m_name1+m_name2,phone,"",taoxiname,m_taoxijiage,m_waiter1,m_waiter2,ren,m_taoxijiage,clothescount,g_user.name,timestamp,m_time2,0,"未到",id);
			else
				sql2.Format ("***update [todaytake] set [date]='%s' where [id]='%s' and [mode]='%d'", m_time2, id, 0);
			sql+=sql2;
			//	AfxMessageBox(sql2);

		}
		if(m_time4!="" && m_time4old!=m_time4)
		{
			tm+=dt;
			timestamp=tm.Format ("%Y%m%d%H%M%S");
			phone=m_phone1+" "+m_phone2;
			phone.TrimLeft ();
			if(m_clothescount!="")
				clothescount="服装:"+m_clothescount;
			if(m_time4old=="")
				sql2.Format ("***insert into [todaytake]([name],[phone],[time],[type],[price],[waiter1],[waiter2],[receptionist],[arrearage],[remark],[clerk],[timestamp],[date],[mode],[arrive],[id])values('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%d','%s','%s')",
				m_name1+m_name2,phone,"",taoxiname,m_taoxijiage,m_waiter1,m_waiter2,ren,m_taoxijiage,clothescount,g_user.name,timestamp,m_time4,1,"未到",id);
			else
				sql2.Format ("***update [todaytake] set [date]='%s' where [id]='%s' and [mode]='%d'", m_time4, id, 1);
			sql+=sql2;
		}
		if(m_time6!="" && m_time6old!=m_time6)
		{	
			tm+=dt;
			timestamp=tm.Format ("%Y%m%d%H%M%S");
			phone=m_phone1+" "+m_phone2;
			phone.TrimLeft ();
			if(m_clothescount!="")
				clothescount="服装:"+m_clothescount;
			if(m_time6old=="")
				sql2.Format ("***insert into [todaytake]([name],[phone],[time],[type],[price],[waiter1],[waiter2],[receptionist],[arrearage],[remark],[clerk],[timestamp],[date],[mode],[arrive],[id])values('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%d','%s','%s')",
				m_name1+m_name2,phone,"",taoxiname,m_taoxijiage,m_waiter1,m_waiter2,ren,m_taoxijiage,clothescount,g_user.name,timestamp,m_time6,2,"未到",id);
			else
				sql2.Format ("***update [todaytake] set [date]='%s' where [id]='%s' and [mode]='%d'", m_time6, id, 2);
			sql+=sql2;
		}
		if(m_time5!="" && m_time5old!=m_time5)
		{	
			tm+=dt;
			timestamp=tm.Format ("%Y%m%d%H%M%S");
			phone=m_phone1+" "+m_phone2;
			phone.TrimLeft ();
			if(m_clothescount!="")
				clothescount="服装:"+m_clothescount;
			if(m_time5old=="")
				sql2.Format ("***insert into [todaytake]([name],[phone],[time],[type],[price],[waiter1],[waiter2],[receptionist],[arrearage],[remark],[clerk],[timestamp],[date],[mode],[arrive],[id])values('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%d','%s','%s')",
				m_name1+m_name2,phone,"",taoxiname,m_taoxijiage,m_waiter1,m_waiter2,ren,m_taoxijiage,clothescount,g_user.name,timestamp,m_time5,3,"未到",id);
			else
				sql2.Format ("***update [todaytake] set [date]='%s' where [id]='%s' and [mode]='%d'", m_time5, id, 3);
			sql+=sql2;
		}
	}
	////////////////////////////

#ifndef CHILD_VERSION
	if(m_time3.IsEmpty ()==0)
	{
		CString date=m_time3;
		CString date2;
		if(m_check3)
			CovertDate(date, date2);
		sql2.Format ("***update dindansp set hqdate='%s' where id='%s' and hqdate is null", date, id);
		sql+=sql2;
		if(0)//atoi(g_cominfoarray.ElementAt(0).ElementAt(117)))//新摄控本
		{
			CString	timestamp;
			CTime tm=CTime::GetCurrentTime ();
			CTimeSpan dt(0,0,0,10);
			tm+=dt;
			timestamp=tm.Format ("%Y%m%d%H%M%S");
			CString phone,clothescount,content;
			for(int i=0; i<m_page1.m_List3.GetItemCount (); i++)
			{
				str=m_page1.m_List3.GetItemText (i, 2);
				str.TrimLeft ();		str.TrimRight ();
				if(str.IsEmpty ())continue;
				content+=str;
				content+=",";
			}
			content.TrimRight (",");
			if(content!="")
			{
				phone=m_phone1+" "+m_phone2;
				phone.TrimLeft ();
				if(m_clothescount!="")
					clothescount="服装:"+m_clothescount;
				sql2.Format ("***insert into [todaytake]([name],[phone],[time],[type],[price],[waiter1],[waiter2],[receptionist],[arrearage],[remark],[clerk],[timestamp],[date],[mode],[arrive],[content])values('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%d','%s','%s')",
					m_name1+m_name2,phone,"",taoxiname,m_taoxijiage,m_waiter1,m_waiter2,ren,m_taoxijiage,clothescount,g_user.name,timestamp,date,4,"未到",content);
				sql+=sql2;
			}
		}
		////////////////////////////
	}
#endif

	g_sendhead.bsql=1;
	g_pMainWnd->ProcessChatMessageRequest2(sql);if(g_bSendOK==0)return;

	CArray<CStringArray, CStringArray>sparray;

	if(m_bGrowthTX)
		sparray.SetSize(m_page1.m_List1arraygrowthbak.GetSize()+m_page1.m_List3.GetItemCount ()+m_page1.m_listbox1.GetCount(), 1);
	else
		sparray.SetSize(m_page1.m_List1.GetItemCount ()+m_page1.m_List3.GetItemCount ()+m_page1.m_listbox1.GetCount(), 1);

	int realcount=0;
	int i;
	if(m_bGrowthTX)
	{
		for( i=0; i<m_page1.m_List1arraygrowthbak.GetSize(); i++)
		{
			int arraygrowthbaksize=m_page1.m_List1arraygrowthbak.ElementAt (i).GetSize();
			str=m_page1.m_List1arraygrowthbak.ElementAt (i).ElementAt(2);

			str.TrimLeft ();		
			str.TrimRight ();
			if(str.IsEmpty ())
				continue;
			sparray.ElementAt (realcount).Add ( id );
			sparray.ElementAt (realcount).Add ( m_page1.m_List1arraygrowthbak.ElementAt (i).ElementAt(0) );
			sparray.ElementAt (realcount).Add ( m_page1.m_List1arraygrowthbak.ElementAt (i).ElementAt(1) );
			sparray.ElementAt (realcount).Add ( m_page1.m_List1arraygrowthbak.ElementAt (i).ElementAt(2) );
			sparray.ElementAt (realcount).Add ( m_page1.m_List1arraygrowthbak.ElementAt (i).ElementAt(3) );
			sparray.ElementAt (realcount).Add ( m_page1.m_List1arraygrowthbak.ElementAt (i).ElementAt(4) );
			sparray.ElementAt (realcount).Add ( "1" );
			sparray.ElementAt (realcount).Add ( m_page1.m_List1arraygrowthbak.ElementAt (i).ElementAt(5) );
			sparray.ElementAt (realcount).Add ( m_page1.m_List1arraygrowthbak.ElementAt (i).ElementAt(6) );
			sparray.ElementAt (realcount).Add ( m_page1.m_List1arraygrowthbak.ElementAt (i).ElementAt(arraygrowthbaksize-1) );
			realcount++;
		}
	}
	else
	{
		for( i=0; i<m_page1.m_List1.GetItemCount (); i++)
		{
			str=m_page1.m_List1.GetItemText (i, 2);
			str.TrimLeft ();		str.TrimRight ();
			if(str.IsEmpty ())
				continue;
			sparray.ElementAt (realcount).Add ( id );
			sparray.ElementAt (realcount).Add ( m_page1.m_List1.GetItemText (i, 0) );
			sparray.ElementAt (realcount).Add ( m_page1.m_List1.GetItemText (i, 1) );
			sparray.ElementAt (realcount).Add ( m_page1.m_List1.GetItemText (i, 2) );
			sparray.ElementAt (realcount).Add ( m_page1.m_List1.GetItemText (i, 3) );
			sparray.ElementAt (realcount).Add ( m_page1.m_List1.GetItemText (i, 4) );
			sparray.ElementAt (realcount).Add ( "1" );
			sparray.ElementAt (realcount).Add ( m_page1.m_List1.GetItemText (i, 5) );
			sparray.ElementAt (realcount).Add ( m_page1.m_List1.GetItemText (i, 6) );
			realcount++;
		}
	}

	for( i=0; i<m_page1.m_List3.GetItemCount (); i++)
	{
		str=m_page1.m_List3.GetItemText (i, 2);
		str.TrimLeft ();		str.TrimRight ();
		if(str.IsEmpty ())continue;
		sparray.ElementAt (realcount).Add ( id );
		sparray.ElementAt (realcount).Add ( m_page1.m_List3.GetItemText (i, 0) );
		sparray.ElementAt (realcount).Add ( m_page1.m_List3.GetItemText (i, 1) );
		sparray.ElementAt (realcount).Add ( m_page1.m_List3.GetItemText (i, 2) );
		sparray.ElementAt (realcount).Add ( m_page1.m_List3.GetItemText (i, 3) );
		sparray.ElementAt (realcount).Add ( m_page1.m_List3.GetItemText (i, 4) );
		sparray.ElementAt (realcount).Add ( "2" );
		sparray.ElementAt (realcount).Add ( "" );
		sparray.ElementAt (realcount).Add ( "" );
		realcount++;
	}

	for(i=0; i<m_page1.m_listbox1.GetCount (); i++)
	{
		m_page1.m_listbox1.GetText (i, str);	
		sparray.ElementAt (realcount).Add ( id );
		sparray.ElementAt (realcount).Add ( str );
		realcount++;
	}

	sparray.SetSize(realcount, 1);
	if(realcount==0)
	{
		sparray.SetSize(1, 1);
		sparray.ElementAt (0).Add (id);
		realcount++;
	}

	sparray.SetSize(realcount+1, 1);
	sparray.ElementAt (realcount).Add (g_user.name);


	CMemFile memfile;
	CArchive ar(&memfile, CArchive::store);
	for(int ii=0; ii<sparray.GetSize (); ii++)
	{
		sparray.ElementAt (ii).Serialize (ar);
	}
	ar.Close();
	int length=memfile.GetLength ();
	BYTE *pData = memfile.Detach();
	int size=sparray.GetSize ();
	BYTE *pData2=new BYTE[length+sizeof(int)];
	memcpy(pData2, pData, length);
	memcpy(pData2+length, &size, sizeof(int));
	delete []pData;
	length+=sizeof(int);
	g_nSendCode=8;
	g_pMainWnd->ProcessChatMessageRequest2(pData2, length);
	g_nSendCode=0;
	delete []pData2;
	if(g_bSendOK==0)return;
#ifdef CHILD_VERSION
	if(m_time3.IsEmpty ()==0)
	{
		sql.Format ("update dindansp set hqdate='%s' where id='%s'", m_time3, id);
		g_sendhead.bsql=1;
		g_pMainWnd->ProcessChatMessageRequest2(sql);if(g_bSendOK==0)return;
	}
#endif
	AfxMessageBox("保存成功!", MB_ICONINFORMATION);
}

void Booking2::OnBUTnew() 
{
	// TODO: Add your control notification handler code here
	m_page1.NewDan();
	m_page2.NewDan();
	m_page3.NewDan();
	m_page4.NewDan();
	OnBUTinfo1();
	GetDlgItem(IDC_BUTprint)->EnableWindow(0);	GetDlgItem(IDC_BUTsave)->EnableWindow(1);
}

void Booking2::OnBUTprint() 
{
	// TODO: Add your control notification handler code here
	g_pMainWnd->PrintDinDan(m_page1.m_id);	
}

void Booking2::OnBUTimport() 
{
	if(AfxMessageBox("是否导入订单?", MB_YESNO|MB_ICONINFORMATION)!=IDYES)
		return;
	CFileDialog fdlg(true, NULL,"", OFN_HIDEREADONLY,"影楼订单文件(*.*)|*.dan||");  

	if(fdlg.DoModal ()!=IDOK)
		return;

	CString path=fdlg.GetFileName ();

	CArray<CStringArray, CStringArray>g_Sel1array[20];//精英团队
	CArray<CStringArray, CStringArray>g_Sel2array[20];//景点介绍
	CArray<CStringArray, CStringArray>g_Sel3array[20];//套系内容
	CArray<CStringArray, CStringArray>g_Sel4array[20];//产品展示
	CArray<CStringArray, CStringArray>g_Sel5array[20];//礼服介绍
	CString g_name1;
	CString g_name2;
	CString g_phone1;
	CString g_phone2;
	CString g_price1;
	CString g_price2;
	CString m_taoxiname;
	{
		CString str=path;
		int pos=str.Find(".");
		if(pos==-1)return;
		str=str.Left(pos);

		pos=str.Find(" ");
		if(pos==-1)return;
		g_name1=str.Left(pos);str=str.Right(str.GetLength()-pos-1);

		pos=str.Find(" ");
		if(pos==-1)return;
		g_name2=str.Left(pos);str=str.Right(str.GetLength()-pos-1);

		pos=str.Find(" ");
		if(pos==-1)return;
		g_phone1=str.Left(pos);str=str.Right(str.GetLength()-pos-1);

		pos=str.Find(" ");
		if(pos==-1)return;
		g_phone2=str.Left(pos);str=str.Right(str.GetLength()-pos-1);
	}

	int length[100];
	CFile fp;
	fp.Open(path, CFile::modeRead);
	int fileleng=fp.GetLength ();
	int memlength=fileleng-sizeof(int)*100;

	int i = 0;
	for(i=0; i<100; i++)
		fp.Read(length+i, sizeof(int));

	for( i=0; i<20; i++)
		g_Sel1array[i].SetSize(length[i]);
	for( i=0; i<20; i++)
		g_Sel2array[i].SetSize(length[20+i]);
	for( i=0; i<20; i++)
		g_Sel3array[i].SetSize(length[40+i]);
	for( i=0; i<20; i++)
		g_Sel4array[i].SetSize(length[60+i]);
	for( i=0; i<20; i++)
		g_Sel5array[i].SetSize(length[80+i]);

	BYTE *pData=new BYTE[memlength];
	fp.Read(pData, memlength);
	fp.Close ();				

	CMemFile memfile;
	memfile.Attach (pData, memlength);
	CArchive ar(&memfile, CArchive::load);

	for( i=0; i<20; i++)
	{
		for(int j=0; j<length[i]; j++)
			g_Sel1array[i].ElementAt (j).Serialize (ar);
	}
	for( i=0; i<20; i++)
	{
		for(int j=0; j<g_Sel2array[i].GetSize(); j++)
			g_Sel2array[i].ElementAt (j).Serialize (ar);
	}
	for( i=0; i<20; i++)
	{
		for(int j=0; j<g_Sel3array[i].GetSize(); j++)
			g_Sel3array[i].ElementAt (j).Serialize (ar);
	}
	for( i=0; i<20; i++)
	{
		for(int j=0; j<g_Sel4array[i].GetSize(); j++)
			g_Sel4array[i].ElementAt (j).Serialize (ar);
	}
	for( i=0; i<20; i++)
	{
		for(int j=0; j<g_Sel5array[i].GetSize(); j++)
			g_Sel5array[i].ElementAt (j).Serialize (ar);
	}
	ar.Close();
	memfile.Detach ();
	delete []pData; 

	if(g_Sel5array[19].GetSize ())
	{
		g_price1=g_Sel5array[19].ElementAt (0).ElementAt (0);
		g_price2=g_Sel5array[19].ElementAt (0).ElementAt (1);
	}
	else
	{
		g_price1=g_price2="";
	}


	CStringArray array;
	for(  i=0; i<19; i++)
	{
		for(int j=0; j<g_Sel3array[i].GetSize(); j++)
		{
			if(g_Sel3array[i].ElementAt (j).GetSize ()<2)continue;
			int count=g_Sel3array[i].ElementAt (j).GetSize ();
			for(int a=1; a<count; a++)
			{
				if(a==1)
				{
					m_taoxiname=g_Sel3array[i].ElementAt (j).ElementAt (a) ;
					//	m_combotaoxiname.InsertString (0, taoxiname);
					//	m_combotaoxiname.SetCurSel (0);
				}
				else
				{
					CString str=g_Sel3array[i].ElementAt (j).ElementAt (a);
					CString dir,name;
					int pos=str.ReverseFind('\\');
					dir=str.Left(pos);
					name=str.Right(str.GetLength()-pos-1);
					array.Add (name);
				}
			}
		}
	}
	for( i=0; i<19; i++)
	{
		for(int j=0; j<g_Sel4array[i].GetSize(); j++)
		{
			int count=g_Sel4array[i].ElementAt (j).GetSize ();
			for(int a=1; a<count; a++)
			{
				array.Add (g_Sel4array[i].ElementAt (j).ElementAt (a));
			}
		}
	}


	for(i=0; i<array.GetSize () ; i++)
	{
		int pos=m_page1.m_List1.GetItemCount ();
		CString str;
		if(pos)
		{
			if(m_page1.m_List1.GetItemText (pos-1, 0).IsEmpty ()&&m_page1.m_List1.GetItemText (pos-1, 1).IsEmpty ())
			{
				pos--;
				m_page1.m_List1.SetItemText(pos,0, "");
				m_page1.m_List1.SetItemText(pos,1, array.ElementAt (i));
				m_page1.m_List1.SetItemText(pos,2, "");
				m_page1.m_List1.SetItemText(pos,3, "1");
			}
			else
			{
				m_page1.m_List1.InsertItem(pos, "");
				m_page1.m_List1.SetItemText(pos,1, array.ElementAt (i));
				m_page1.m_List1.SetItemText(pos,2, "");
				m_page1.m_List1.SetItemText(pos,3, "1");
			}
		}
		else
		{
			m_page1.m_List1.InsertItem(pos, "");
			m_page1.m_List1.SetItemText(pos,1, array.ElementAt (i));
			m_page1.m_List1.SetItemText(pos,2, "");
			m_page1.m_List1.SetItemText(pos,3, "1");
		}	
	}
	if(g_Sel5array[19].GetSize ())
	{
		g_price1=g_Sel5array[19].ElementAt (0).ElementAt (0);
		g_price2=g_Sel5array[19].ElementAt (0).ElementAt (1);
	}
	else
	{
		g_price1=g_price2="";
	}

	OnBUTnew();
	m_page1.m_taoxiname=m_taoxiname;
	m_page1.m_taoxijiage=g_price1;
	m_page1.m_payed1=g_price2;
	m_page1.UpdateData (0);

	m_page2.m_name1=g_name1;
	m_page2.m_name2=g_name2;
	m_page2.m_phone1=g_phone1;
	m_page2.m_phone2=g_phone2;	
	m_page2.UpdateData (0);
}

BOOL Booking2::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_ESCAPE:
				if(m_bModify)CDialog::OnCancel ();
				return 1;
			}
		}
		return CDialog::PreTranslateMessage(pMsg);
	}
	catch(...)
	{
	}
}