lyfz_repos/经典版源码/lyfzddfClient/trunk/625/SPLBDlg.cpp

// SPLBDlg.cpp : implementation file
//

#include "stdafx.h"
#include "ylgl.h"
#include "SPLBDlg.h"

#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// SPLBDlg dialog 


SPLBDlg::SPLBDlg(CWnd* pParent /*=NULL*/)
	: CDialog(SPLBDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(SPLBDlg)
	m_edit1 = _T("");
	m_mode=0;
	//}}AFX_DATA_INIT
}

void SPLBDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(SPLBDlg)
	DDX_Control(pDX, IDC_LIST1, m_List1);
	DDX_Text(pDX, IDC_EDIT1, m_edit1);
	//}}AFX_DATA_MAP
}

BEGIN_MESSAGE_MAP(SPLBDlg, CDialog)
	//{{AFX_MSG_MAP(SPLBDlg)
	ON_BN_CLICKED(IDC_BUTadd, OnBUTadd)
	ON_BN_CLICKED(IDC_BUTdel, OnBUTdel)
	ON_BN_CLICKED(IDC_BUTTON5, OnButton5)
	ON_NOTIFY(NM_DBLCLK, IDC_LIST1, OnDblclkList1)
	ON_BN_CLICKED(IDC_BUTadd3, OnBUTadd3)
	ON_NOTIFY(NM_CLICK, IDC_LIST1, OnClickList1)
	ON_BN_CLICKED(IDC_BUTadd4, OnBUTadd4)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// SPLBDlg message handlers

BOOL SPLBDlg::OnInitDialog() 
{
	CDialog::OnInitDialog(); 
	
	// TODO: Add extra initialization here
	CRect rc;
	m_List1.GetClientRect (rc);
	CString strHeadings;

	if(m_mode==2 || m_mode==19)
	{
		GetDlgItem(IDOK)->ShowWindow(SW_SHOW);
		GetDlgItem(IDC_BUTTON5)->ShowWindow(SW_SHOW);
		GetDlgItem(IDC_STATIC1)->ShowWindow(SW_HIDE);
		GetDlgItem(IDC_STATIC2)->ShowWindow(SW_HIDE);
		CRect rc3,rc2;
		GetWindowRect(rc3);
		GetDlgItem(IDC_BUTadd)->GetWindowRect(rc2);
		rc3.right =rc2.left ;
		MoveWindow(rc3);
	}
	else
	{	
		GetDlgItem(IDOK)->ShowWindow(SW_HIDE);
		GetDlgItem(IDC_BUTTON5)->ShowWindow(SW_HIDE);
	}
	if(m_mode==19)GetDlgItem(IDC_BUTadd4)->ShowWindow(SW_SHOW);



	if(m_mode==1 || m_mode==2)
	{	
		GetDlgItem(IDC_BUTadd3)->ShowWindow(SW_HIDE);
		strHeadings.Format ("景点名称,%d", rc.Width()-18);
		GetDlgItem(IDC_STATIC1)->SetWindowText("景点");
		GetDlgItem(IDC_STATIC2)->SetWindowText("景点名称:");
		GetDlgItem(IDC_BUTadd)->SetWindowText("添加景点");
		GetDlgItem(IDC_BUTdel)->SetWindowText("删除景点");SetWindowText("景点设置");
	}
	else if(m_mode==3)
	{	
		GetDlgItem(IDC_BUTadd3)->ShowWindow(SW_HIDE);
		strHeadings.Format ("套系类别名称,%d", rc.Width()-18);
		GetDlgItem(IDC_STATIC1)->SetWindowText("套系类别");
		GetDlgItem(IDC_STATIC2)->SetWindowText("套系类别名称:");
		GetDlgItem(IDC_BUTadd)->SetWindowText("添加套系类别");
		GetDlgItem(IDC_BUTdel)->SetWindowText("删除套系类别");SetWindowText("套系类别设置");
	}
	else if(m_mode==4)
	{	
		GetDlgItem(IDC_BUTadd3)->ShowWindow(SW_HIDE);
		strHeadings.Format ("拍摄名称,%d", rc.Width()-18);
		GetDlgItem(IDC_STATIC1)->SetWindowText("拍摄名称");
		GetDlgItem(IDC_STATIC2)->SetWindowText("拍摄名称:");
		GetDlgItem(IDC_BUTadd)->SetWindowText("添加拍摄名称");
		GetDlgItem(IDC_BUTdel)->SetWindowText("删除拍摄名称");SetWindowText("拍摄名称设置");
	}
	else if(m_mode==5)
	{	
		GetDlgItem(IDC_BUTadd3)->ShowWindow(SW_HIDE);
		strHeadings.Format ("工作内容,%d", rc.Width()-18);
		GetDlgItem(IDC_STATIC1)->SetWindowText("工作内容");
		GetDlgItem(IDC_STATIC2)->SetWindowText("工作内容:");
		GetDlgItem(IDC_BUTadd)->SetWindowText("添加工作内容");
		GetDlgItem(IDC_BUTdel)->SetWindowText("删除工作内容");SetWindowText("工作内容设置");
	}
	else if(m_mode==6)
	{	
		GetDlgItem(IDC_BUTadd3)->ShowWindow(SW_HIDE);
		strHeadings.Format ("二销类别,%d", rc.Width()-18);
		GetDlgItem(IDC_STATIC1)->SetWindowText("二销类别");
		GetDlgItem(IDC_STATIC2)->SetWindowText("二销类别:");
		GetDlgItem(IDC_BUTadd)->SetWindowText("添加二销类别");
		GetDlgItem(IDC_BUTdel)->SetWindowText("删除二销类别");SetWindowText("二销类别设置");
	}
	else if(m_mode==7)
	{	
		GetDlgItem(IDC_BUTadd3)->ShowWindow(SW_HIDE);
		strHeadings.Format ("前期类别,%d", rc.Width()-18);
		GetDlgItem(IDC_STATIC1)->SetWindowText("前期类别");
		GetDlgItem(IDC_STATIC2)->SetWindowText("前期类别:");
		GetDlgItem(IDC_BUTadd)->SetWindowText("添加前期类别");
		GetDlgItem(IDC_BUTdel)->SetWindowText("删除前期类别");SetWindowText("前期类别设置");
	}
	else if(m_mode==8)
	{	
		GetDlgItem(IDC_BUTadd3)->ShowWindow(SW_HIDE);
		strHeadings.Format ("客户来源名称,%d", rc.Width()-18);
		GetDlgItem(IDC_STATIC1)->SetWindowText("客户来源");
		GetDlgItem(IDC_STATIC2)->SetWindowText("客户来源名称:");
		GetDlgItem(IDC_BUTadd)->SetWindowText("添加客户来源");
		GetDlgItem(IDC_BUTdel)->SetWindowText("删除客户来源");SetWindowText("客户来源设置");
	}
	else if(m_mode==9)
	{	
		GetDlgItem(IDC_BUTadd3)->ShowWindow(SW_HIDE);
		strHeadings.Format ("流失原因名称,%d", rc.Width()-18);
		GetDlgItem(IDC_STATIC1)->SetWindowText("流失原因");
		GetDlgItem(IDC_STATIC2)->SetWindowText("流失原因名称:");
		GetDlgItem(IDC_BUTadd)->SetWindowText("添加流失原因");
		GetDlgItem(IDC_BUTdel)->SetWindowText("删除流失原因");SetWindowText("流失原因设置");
	}
	else if(m_mode==10)
	{	
		GetDlgItem(IDC_BUTadd3)->ShowWindow(SW_HIDE);
		strHeadings.Format ("接单点名称,%d", rc.Width()-18);
		GetDlgItem(IDC_STATIC1)->SetWindowText("接单点");
		GetDlgItem(IDC_STATIC2)->SetWindowText("接单点名称:");
		GetDlgItem(IDC_BUTadd)->SetWindowText("添加接单点");
		GetDlgItem(IDC_BUTdel)->SetWindowText("删除接单点");SetWindowText("接单点设置");
	}
	else if(m_mode==11)
	{	
		GetDlgItem(IDC_BUTadd3)->ShowWindow(SW_HIDE);
		strHeadings.Format ("摆放区域名称,%d", rc.Width()-18);
		GetDlgItem(IDC_STATIC1)->SetWindowText("摆放区域");
		GetDlgItem(IDC_STATIC2)->SetWindowText("摆放区域名称:");
		GetDlgItem(IDC_BUTadd)->SetWindowText("添加摆放区域");
		GetDlgItem(IDC_BUTdel)->SetWindowText("删除摆放区域");SetWindowText("摆放区域设置");
	}
	else if(m_mode==12)
	{	
		GetDlgItem(IDC_BUTadd3)->ShowWindow(SW_HIDE);
		strHeadings.Format ("套系大类名称,%d", rc.Width()-18);
		GetDlgItem(IDC_STATIC1)->SetWindowText("套系大类");
		GetDlgItem(IDC_STATIC2)->SetWindowText("套系大类名称:");
		GetDlgItem(IDC_BUTadd)->SetWindowText("添加套系大类");
		GetDlgItem(IDC_BUTdel)->SetWindowText("删除套系大类");SetWindowText("套系大类设置");
	}
	else if(m_mode==13)
	{	
		GetDlgItem(IDC_BUTadd3)->ShowWindow(SW_HIDE);
		strHeadings.Format ("二销项目名称,%d", rc.Width()-18);
		GetDlgItem(IDC_STATIC1)->SetWindowText("二销项目");
		GetDlgItem(IDC_STATIC2)->SetWindowText("二销项目名称:");
		GetDlgItem(IDC_BUTadd)->SetWindowText("添加二销项目");
		GetDlgItem(IDC_BUTdel)->SetWindowText("删除二销项目");SetWindowText("二销项目设置");
	}
	else if(m_mode==14)
	{	
		GetDlgItem(IDC_BUTadd3)->ShowWindow(SW_HIDE);
		strHeadings.Format ("业务种类名称,%d", rc.Width()-18);
		GetDlgItem(IDC_STATIC1)->SetWindowText("业务种类");
		GetDlgItem(IDC_STATIC2)->SetWindowText("业务种类名称:");
		GetDlgItem(IDC_BUTadd)->SetWindowText("添加业务种类");
		GetDlgItem(IDC_BUTdel)->SetWindowText("删除业务种类");SetWindowText("业务种类设置");
	}
	else if(m_mode==15)
	{	
		GetDlgItem(IDC_BUTadd3)->ShowWindow(SW_HIDE);
		strHeadings.Format ("业务意向名称,%d", rc.Width()-18);
		GetDlgItem(IDC_STATIC1)->SetWindowText("业务意向");
		GetDlgItem(IDC_STATIC2)->SetWindowText("业务意向名称:");
		GetDlgItem(IDC_BUTadd)->SetWindowText("添加业务意向");
		GetDlgItem(IDC_BUTdel)->SetWindowText("删除业务意向");SetWindowText("业务意向设置");
	}
	else if(m_mode==16)
	{	
		GetDlgItem(IDC_BUTadd3)->ShowWindow(SW_HIDE);
		strHeadings.Format ("客户类别名称,%d", rc.Width()-18);
		GetDlgItem(IDC_STATIC1)->SetWindowText("客户类别");
		GetDlgItem(IDC_STATIC2)->SetWindowText("客户类别名称:");
		GetDlgItem(IDC_BUTadd)->SetWindowText("添加客户类别");
		GetDlgItem(IDC_BUTdel)->SetWindowText("删除客户类别");SetWindowText("客户类别设置");
	}
	else if(m_mode==17)
	{	
		GetDlgItem(IDC_BUTadd3)->ShowWindow(SW_HIDE);
		strHeadings.Format ("来单医院名称,%d", rc.Width()-18);
		GetDlgItem(IDC_STATIC1)->SetWindowText("来单医院");
		GetDlgItem(IDC_STATIC2)->SetWindowText("来单医院名称:");
		GetDlgItem(IDC_BUTadd)->SetWindowText("添加来单医院");
		GetDlgItem(IDC_BUTdel)->SetWindowText("删除来单医院");SetWindowText("来单医院设置");
	}
	else if(m_mode==18 || m_mode==19)
	{	
		GetDlgItem(IDC_BUTadd3)->ShowWindow(SW_HIDE);
		strHeadings.Format ("客人要求,%d", rc.Width()-18);
		GetDlgItem(IDC_STATIC1)->SetWindowText("客人要求");
		GetDlgItem(IDC_STATIC2)->SetWindowText("客人要求:");
		GetDlgItem(IDC_BUTadd)->SetWindowText("添加客人要求");
		GetDlgItem(IDC_BUTdel)->SetWindowText("删除客人要求");SetWindowText("客人要求设置");
	}
	else
	    strHeadings.Format ("商品类别名称,%d", rc.Width()-18);
	m_List1.SetHeadings( strHeadings  );
 
	FillGrid();
    CenterWindow ();
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void SPLBDlg::FillGrid()
{
	g_sendhead.bsql=0;
	if(m_mode==1 || m_mode==2)
		g_sendhead.code[0]=149;
	else if(m_mode==3)
		g_sendhead.code[0]=157;
	else if(m_mode==4)
		g_sendhead.code[0]=158;
	else if(m_mode==5)
		g_sendhead.code[0]=159;
	else if(m_mode==6)
		g_sendhead.code[0]=160;
	else if(m_mode==7)
		g_sendhead.code[0]=169;
	else if(m_mode==8)
		g_sendhead.code[0]=186;
	else if(m_mode==9)
		g_sendhead.code[0]=187;
	else if(m_mode==10)
		g_sendhead.code[0]=188;
	else if(m_mode==11)
		g_sendhead.code[0]=190;
	else if(m_mode==12)
		g_sendhead.code[0]=194;
	else if(m_mode==13)
		g_sendhead.code[0]=195;
	else if(m_mode==14)
		g_sendhead.code[0]=200;
	else if(m_mode==15)
		g_sendhead.code[0]=201;
	else if(m_mode==16)
		g_sendhead.code[0]=202;
	else if(m_mode==17)
		g_sendhead.code[0]=203;
	else if(m_mode==18||m_mode==19)
		g_sendhead.code[0]=215;
	else
		g_sendhead.code[0]=2;
	g_sendhead.tabcount=1;
	g_pMainWnd->ProcessChatMessageRequest2(2);if(g_bSendOK==0)return;
	DataToArray(&g_List1array);

	m_List1.DeleteAllItems2 ();
	int ii=0;
	{
		m_List1.m_arLabels.SetSize( g_List1array.GetSize (), 1 );
		for(ii=0; ii<m_List1.m_arLabels.GetSize (); ii++)
			m_List1.m_arLabels.ElementAt (ii).Copy (g_List1array.ElementAt (ii));
	}
	m_List1.m_LabelCount=ii;
	m_List1.SetItemCountEx (ii);

	if(m_mode==0)
	{
#ifndef CHILD_VERSION
	BOOL bFind=0;
	for(ii=0; ii<g_List1array.GetSize (); ii++)
	{
		if(g_List1array.ElementAt (ii).ElementAt (0)=="婚庆服务")
		{
			bFind=1;
			break;
		}
	}
	if(bFind==0)
	{
	CString sql;
	sql.Format ("insert into shangpinlb (name)values('%s')", "婚庆服务");
	g_sendhead.bsql=1;
	g_pMainWnd->ProcessChatMessageRequest2(sql);if(g_bSendOK==0)return;
	FillGrid();
	}
#endif
	}
}

void SPLBDlg::OnBUTadd() 
{
	// TODO: Add your control notification  handler code here
	UpdateData();
	m_edit1.TrimLeft ();
	m_edit1.TrimRight ();
	if(m_edit1.IsEmpty ())
	{
		if(m_mode==1 || m_mode==2)
			AfxMessageBox("景点名称不能为空!", MB_ICONINFORMATION);
		else if(m_mode==3)
			AfxMessageBox("套系类别名称不能为空!", MB_ICONINFORMATION);
		else if(m_mode==4)
			AfxMessageBox("拍摄名称不能为空!", MB_ICONINFORMATION);
		else if(m_mode==5)
			AfxMessageBox("工作内容不能为空!", MB_ICONINFORMATION);
		else if(m_mode==6)
			AfxMessageBox("二销类别不能为空!", MB_ICONINFORMATION);
		else if(m_mode==7)
			AfxMessageBox("前期类别不能为空!", MB_ICONINFORMATION);
		else if(m_mode==8)
			AfxMessageBox("客户来源不能为空!", MB_ICONINFORMATION);
		else if(m_mode==9)
			AfxMessageBox("流失原因不能为空!", MB_ICONINFORMATION);
		else if(m_mode==10)
			AfxMessageBox("接单点不能为空!", MB_ICONINFORMATION);
		else if(m_mode==11)
			AfxMessageBox("摆放区域不能为空!", MB_ICONINFORMATION);
		else if(m_mode==12)
			AfxMessageBox("套系大类不能为空!", MB_ICONINFORMATION);
		else if(m_mode==13)
			AfxMessageBox("二销项目不能为空!", MB_ICONINFORMATION);
		else if(m_mode==14)
			AfxMessageBox("业务种类不能为空!", MB_ICONINFORMATION);
		else if(m_mode==15)
			AfxMessageBox("业务意向不能为空!", MB_ICONINFORMATION);
		else if(m_mode==16)
			AfxMessageBox("客户类别不能为空!", MB_ICONINFORMATION);
		else if(m_mode==17)
			AfxMessageBox("来单医院不能为空!", MB_ICONINFORMATION);
		else if(m_mode==18)
			AfxMessageBox("客人要求不能为空!", MB_ICONINFORMATION);
		else
			AfxMessageBox("商品类别不能为空!", MB_ICONINFORMATION);
		this->GetDlgItem (IDC_EDIT1)->SetFocus();
		return;
	}
    if(m_mode==4)
	{
		m_edit1.Replace (",", "");	UpdateData(0);
	}
	for(int i=0; i<m_List1.GetItemCount (); i++)
	{
		if(m_List1.GetItemText (i, 0)==m_edit1)
		{	
			if(m_mode==1 || m_mode==2)
				AfxMessageBox("已有此景点!", MB_ICONINFORMATION);
		    else if(m_mode==3)
				AfxMessageBox("已有此套系类别!", MB_ICONINFORMATION);
		    else if(m_mode==4)
				AfxMessageBox("已有此拍摄名称!", MB_ICONINFORMATION);
		    else if(m_mode==5)
				AfxMessageBox("已有此工作内容!", MB_ICONINFORMATION);
		    else if(m_mode==6)
				AfxMessageBox("已有此二销类别!", MB_ICONINFORMATION);
		    else if(m_mode==7)
				AfxMessageBox("已有此前期类别!", MB_ICONINFORMATION);
		    else if(m_mode==8)
				AfxMessageBox("已有此客户来源!", MB_ICONINFORMATION);
		    else if(m_mode==9)
				AfxMessageBox("已有此流失原因!", MB_ICONINFORMATION);
		    else if(m_mode==10)
				AfxMessageBox("已有此接单点!", MB_ICONINFORMATION);
		    else if(m_mode==11)
				AfxMessageBox("已有此摆放区域!", MB_ICONINFORMATION);
		    else if(m_mode==12)
				AfxMessageBox("已有此套系大类!", MB_ICONINFORMATION);
		    else if(m_mode==13)
				AfxMessageBox("已有此二销项目!", MB_ICONINFORMATION);
		    else if(m_mode==14)
				AfxMessageBox("已有此业务种类!", MB_ICONINFORMATION);
		    else if(m_mode==15)
				AfxMessageBox("已有此业务意向!", MB_ICONINFORMATION);
		    else if(m_mode==16)
				AfxMessageBox("已有此客户类别!", MB_ICONINFORMATION);
		    else if(m_mode==17)
				AfxMessageBox("已有此来单医院!", MB_ICONINFORMATION);
		    else if(m_mode==18)
				AfxMessageBox("已有此客人要求!", MB_ICONINFORMATION);
			else
				AfxMessageBox("已有此类别!", MB_ICONINFORMATION);
			this->GetDlgItem (IDC_EDIT1)->SetFocus();
			return;
		}
	}



	CString sql;
	if(m_mode==1 || m_mode==2)
		sql.Format ("insert into jd (name)values('%s')", m_edit1);
	else if(m_mode==3)
		sql.Format ("insert into txlb (name)values('%s')", m_edit1);
	else if(m_mode==4)
		sql.Format ("insert into growthtx (name)values('%s')", m_edit1);
	else if(m_mode==5)
		sql.Format ("insert into worktype (name)values('%s')", m_edit1);
	else if(m_mode==6)
		sql.Format ("insert into expendtype (name)values('%s')", m_edit1);
	else if(m_mode==7)
		sql.Format ("insert into baseexpendtype (name)values('%s')", m_edit1);
	else if(m_mode==8)
		sql.Format ("insert into clientfrom (name)values('%s')", m_edit1);
	else if(m_mode==9)
		sql.Format ("insert into clientreason (name)values('%s')", m_edit1);
	else if(m_mode==10)
		sql.Format ("insert into jdd (name)values('%s')", m_edit1);
	else if(m_mode==11)
		sql.Format ("insert into dressarea (name)values('%s')", m_edit1);
	else if(m_mode==12)
		sql.Format ("insert into [txlb2] (name)values('%s')", m_edit1);
	else if(m_mode==13)
		sql.Format ("insert into [sale2type] (name)values('%s')", m_edit1);
	else if(m_mode==14)
		sql.Format ("insert into [businesstype] (name)values('%s')", m_edit1);
	else if(m_mode==15)
		sql.Format ("insert into [businessintention] (name)values('%s')", m_edit1);
	else if(m_mode==16)
		sql.Format ("insert into [clienttype] (name)values('%s')", m_edit1);
	else if(m_mode==17)
		sql.Format ("insert into [hospital] (name)values('%s')", m_edit1);
	else if(m_mode==18)
		sql.Format ("insert into [clientqequirement] (name)values('%s')", m_edit1);
	else
		sql.Format ("insert into shangpinlb (name)values('%s')", m_edit1);
	g_sendhead.bsql=1;
	g_pMainWnd->ProcessChatMessageRequest2(sql);if(g_bSendOK==0)return;
	FillGrid();
}

void SPLBDlg::OnBUTdel() 
{
	// TODO: Add your control notification handler code here
	POSITION pos;		
	pos=m_List1.GetFirstSelectedItemPosition();	
	if(pos==NULL)
	{
		if(m_mode==1 || m_mode==2)
			AfxMessageBox("请选中您要删除的景点!", MB_ICONINFORMATION);
		else if(m_mode==3)
			AfxMessageBox("请选中您要删除的套系类别!", MB_ICONINFORMATION);
		else if(m_mode==4)
			AfxMessageBox("请选中您要删除的拍摄名称!", MB_ICONINFORMATION);
		else if(m_mode==5)
			AfxMessageBox("请选中您要删除的工作内容!", MB_ICONINFORMATION);
		else if(m_mode==6)
			AfxMessageBox("请选中您要删除的二销类别!", MB_ICONINFORMATION);
		else if(m_mode==7)
			AfxMessageBox("请选中您要删除的前期类别!", MB_ICONINFORMATION);
		else if(m_mode==8)
			AfxMessageBox("请选中您要删除的客户来源!", MB_ICONINFORMATION);
		else if(m_mode==9)
			AfxMessageBox("请选中您要删除的流失原因!", MB_ICONINFORMATION);
		else if(m_mode==10)
			AfxMessageBox("请选中您要删除的接单点!", MB_ICONINFORMATION);
		else if(m_mode==11)
			AfxMessageBox("请选中您要删除的摆放区域!", MB_ICONINFORMATION);
		else if(m_mode==12)
			AfxMessageBox("请选中您要删除的套系大类!", MB_ICONINFORMATION);
		else if(m_mode==13)
			AfxMessageBox("请选中您要删除的二销项目!", MB_ICONINFORMATION);
		else if(m_mode==14)
			AfxMessageBox("请选中您要删除的业务种类!", MB_ICONINFORMATION);
		else if(m_mode==15)
			AfxMessageBox("请选中您要删除的业务意向!", MB_ICONINFORMATION);
		else if(m_mode==16)
			AfxMessageBox("请选中您要删除的客户类别!", MB_ICONINFORMATION);
		else if(m_mode==17)
			AfxMessageBox("请选中您要删除的来单医院!", MB_ICONINFORMATION);
		else if(m_mode==18)
			AfxMessageBox("请选中您要删除的客人要求!", MB_ICONINFORMATION);
		else
			AfxMessageBox("请选中您要删除的类别!", MB_ICONINFORMATION);
		return;	
	}
	if(AfxMessageBox("确认删除吗?", MB_YESNO|MB_ICONINFORMATION)!=IDYES)return;
	int iItem=m_List1.GetNextSelectedItem(pos);
	CString name=m_List1.GetItemText (iItem, 0);		
 
	CString sql;
	if(m_mode==1 || m_mode==2)
		sql.Format ("delete from jd where name='%s'", name);
	else if(m_mode==3)
		sql.Format ("delete from txlb where name='%s'", name); 
	else if(m_mode==4)
		sql.Format ("delete from growthtx where name='%s'", name); 
	else if(m_mode==5)
		sql.Format ("delete from worktype where name='%s'", name); 
	else if(m_mode==6)
		sql.Format ("delete from expendtype where name='%s'", name); 
	else if(m_mode==7)
		sql.Format ("delete from baseexpendtype where name='%s'", name); 
	else if(m_mode==8)
		sql.Format ("delete from clientfrom where name='%s'", name); 
	else if(m_mode==9)
		sql.Format ("delete from clientreason where name='%s'", name); 
	else if(m_mode==10)
		sql.Format ("delete from jdd where name='%s'", name); 
	else if(m_mode==11)
		sql.Format ("delete from dressarea where name='%s'", name); 
	else if(m_mode==12)
		sql.Format ("delete from [txlb2] where name='%s'", name); 
	else if(m_mode==13)
		sql.Format ("delete from [sale2type] where name='%s'", name); 
	else if(m_mode==14)
		sql.Format ("delete from businesstype where name='%s'", name); 
	else if(m_mode==15)
		sql.Format ("delete from businessintention where name='%s'", name); 
	else if(m_mode==16)
		sql.Format ("delete from [clienttype] where name='%s'", name); 
	else if(m_mode==17)
		sql.Format ("delete from [hospital] where name='%s'", name); 
	else if(m_mode==18)
		sql.Format ("delete from [clientqequirement] where name='%s'", name); 
	else
		sql.Format ("delete from shangpinlb where name='%s'***delete from shangpin where splb='%s'", name, name);
	g_sendhead.bsql=1;
	g_pMainWnd->ProcessChatMessageRequest2(sql);if(g_bSendOK==0)return;
	FillGrid();	
}

void SPLBDlg::OnOK() 
{
	// TODO: Add extra validation here
	if(m_mode==19)
	{	POSITION pos;		
	pos=m_List1.GetFirstSelectedItemPosition();	
	if(pos==NULL)
	{
		return;	
	}
	int iItem=m_List1.GetNextSelectedItem(pos);
	m_edit1=m_List1.GetItemText (iItem, 0);CDialog::OnOK();
		return;
	}
	if(m_mode!=2)
	{
		CDialog::OnCancel ();
		return;
	}
 
    POSITION pos;
	pos=m_List1.GetFirstSelectedItemPosition();	
	if(pos==NULL)
	{
		AfxMessageBox("请先选中景点!", MB_ICONINFORMATION);
		return;
	}
	int iItem;	
	m_array.RemoveAll ();
	while (pos)
    {
        iItem = m_List1.GetNextSelectedItem(pos);
	    m_array.Add (m_List1.GetItemText (iItem,  0));
    }
	CDialog::OnOK();
}

void SPLBDlg::OnButton5() 
{
	// TODO: Add your control notification handler code here
	CDialog::OnCancel ();
}

void SPLBDlg::OnDblclkList1(NMHDR* pNMHDR, LRESULT* pResult) 
{
	// TODO: Add your control notification handler code here
	OnOK();
	*pResult = 0;
}

void SPLBDlg::OnBUTadd3() 
{
	// TODO: Add your control notification handler code here
	POSITION pos;		
	pos=m_List1.GetFirstSelectedItemPosition();	
	if(pos==NULL)
	{
		AfxMessageBox("请选中您要修改的类别!", MB_ICONINFORMATION);
		return;	
	}
	int iItem=m_List1.GetNextSelectedItem(pos);
	CString name=m_List1.GetItemText (iItem, 0);

	UpdateData();
	m_edit1.TrimLeft ();
	m_edit1.TrimRight ();
	if(m_edit1.IsEmpty ())
	{
		AfxMessageBox("商品类别不能为空!", MB_ICONINFORMATION);
		this->GetDlgItem (IDC_EDIT1)->SetFocus();
		return;
	}
	if(m_edit1==name)return;


	if(AfxMessageBox("确认修改吗?", MB_YESNO|MB_ICONINFORMATION)!=IDYES)return;

	CString sql,sql2;
	sql.Format ("update shangpinlb set name='%s' where name='%s'", m_edit1, name);
	sql2.Format ("update shangpin set splb='%s' where splb='%s'", m_edit1, name);
	sql+="***"+sql2;

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

void SPLBDlg::OnClickList1(NMHDR* pNMHDR, LRESULT* pResult) 
{
	// TODO: Add your control notification handler code here
	POSITION pos;		
	pos=m_List1.GetFirstSelectedItemPosition();	
	if(pos==NULL)
	{
		return;	
	}
	int iItem=m_List1.GetNextSelectedItem(pos);
	m_edit1=m_List1.GetItemText (iItem, 0);
	UpdateData(0);
	*pResult = 0;
}

void SPLBDlg::OnBUTadd4() 
{
	// TODO: Add your control notification handler code here
	SPLBDlg dlg;
	dlg.m_mode=18;
	dlg.DoModal ();	
	FillGrid();
}