lxrxx.cpp

客户管理系统 系统使用了全新的客户关系管理理念

	m_list.InsertColumn(1,"企业名称");
	m_list.InsertColumn(2,"联系人姓名");
	m_list.InsertColumn(3,"联系人性别");
	m_list.InsertColumn(4,"年龄");
	m_list.InsertColumn(5,"职位");
	m_list.InsertColumn(6,"办公电话");
	m_list.InsertColumn(7,"电子邮件");
	m_list.InsertColumn(8,"手机");
	m_list.SetColumnWidth(0,100);
m_list.SetColumnWidth(1,100);
m_list.SetColumnWidth(2,100);
m_list.SetColumnWidth(3,100);
m_list.SetColumnWidth(4,100);
m_list.SetColumnWidth(5,100);
m_list.SetColumnWidth(6,100);
m_list.SetColumnWidth(7,100);
m_list.SetColumnWidth(8,100);

m_tab.InsertItem(0,"联系人基本信息");
m_tab.InsertItem(1,"联系人列表");
this->load2();
this->loadf();
this->texttowin();
m_list.ShowWindow(SW_HIDE);
enableall(false);
this->m_edit3.LimitText(2);
	//statebar.EnableAutomation();
	
//if(!statebar.Create(WS_CHILD|WS_VISIBLE,CRect(0,0,0,0),this,ID_STATU))
//{
//	return false;
//}
	//statebar.SetParts(4,&weith[1]);
	//statebar.SetText("明日",0,0);
	//statebar.SetText("aa",0,3);
	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void lxrxx::OnPaint() 
{
	CPaintDC dc(this); // device context for painting
	if (IsIconic())
	{
		
		SendMessage(WM_ICONERASEBKGND, (WPARAM) dc.GetSafeHdc(), 0);

		// Center icon in client rectangle
		int cxIcon = GetSystemMetrics(SM_CXICON);
		int cyIcon = GetSystemMetrics(SM_CYICON);
		CRect rect;
		GetClientRect(&rect);
		int x = (rect.Width() - cxIcon + 1) / 2;
		int y = (rect.Height() - cyIcon + 1) / 2;
	//	dc.DrawIcon(x, y, m_hIcon);
	}
	else
	{
		CDialog::OnPaint();
	}
}

BOOL lxrxx::PreTranslateMessage(MSG* pMsg) 
{
	// TODO: Add your specialized code here and/or call the base class
	if(pMsg->message==WM_KEYDOWN && pMsg->wParam==13)
		pMsg->wParam=9;	
	return CDialog::PreTranslateMessage(pMsg);
}
//void lxrxx::show(bool enbale)
//{
	
//}

void lxrxx::OnSelchangeTab1(NMHDR* pNMHDR, LRESULT* pResult) 
{
	if(sel==1)
	{
	int i=m_tab.GetCurSel();
switch(i)

{
case 1:
	
this->listshow();
	break;
case 0:
	

this->textshow();
	break;
}	
	}
	*pResult = 0;
}
void lxrxx::enableall(bool b)
{
	m_edit1.EnableWindow(b);
	m_edit2.EnableWindow(b);
	m_edit3.EnableWindow(b);
	m_edit4.EnableWindow(b);
	m_edit5.EnableWindow(b);
	m_edit6.EnableWindow(b);
	m_edit7.EnableWindow(b);
	m_edit8.EnableWindow(b);
	m_edit9.EnableWindow(b);
	m_com1.EnableWindow(b);
	m_com2.EnableWindow(b);
	m_com3.EnableWindow(b);
	m_date1.EnableWindow(b);
	m_date2.EnableWindow(b);
}
void lxrxx::wintotext()
{
	this->m_edit1.GetWindowText(edit1);
	this->m_edit2.GetWindowText(edit2);
	this->m_edit3.GetWindowText(edit3);
	this->m_edit4.GetWindowText(edit4);
	this->m_edit5.GetWindowText(edit5);
	this->m_edit6.GetWindowText(edit6);
	this->m_edit7.GetWindowText(edit7);
	this->m_edit8.GetWindowText(edit8);
	this->m_edit9.GetWindowText(edit9);
	this->m_com1.GetWindowText(com1);
	this->m_com2.GetWindowText(com2);
	this->m_com3.GetWindowText(com3);
	this->m_date1.GetWindowText(date1);
	this->m_date2.GetWindowText(date2);
}
void lxrxx::texttowin()
{
	this->m_edit1.SetWindowText(edit1);
	this->m_edit2.SetWindowText(edit2);
	this->m_edit3.SetWindowText(edit3);
	this->m_edit4.SetWindowText(edit4);
	this->m_edit5.SetWindowText(edit5);
	this->m_edit6.SetWindowText(edit6);
	this->m_edit7.SetWindowText(edit7);
	this->m_edit8.SetWindowText(edit8);
	this->m_edit9.SetWindowText(edit9);
	this->m_com1.SetWindowText(com1);
	this->m_com2.SetWindowText(com2);
	this->m_com3.SetWindowText(com3);
	this->m_date1.SetWindowText(date1);
	this->m_date2.SetWindowText(date2);
}
void lxrxx::clearall()
{
	this->m_edit1.SetWindowText("");
	this->m_edit2.SetWindowText("");
	this->m_edit3.SetWindowText("");
	this->m_edit4.SetWindowText("");
	this->m_edit5.SetWindowText("");
	this->m_edit6.SetWindowText("");
	this->m_edit7.SetWindowText("");
	this->m_edit8.SetWindowText("");
	this->m_edit9.SetWindowText("");
	this->m_com1.SetWindowText("");
	this->m_com2.SetWindowText("");
	this->m_com3.SetWindowText("");
	this->m_date1.SetWindowText("");
	this->m_date2.SetWindowText("");
}
void lxrxx::datatotext()
{
	edit1=rst2.GetFieldValue("lxrxx_id");
com1=rst2.GetFieldValue("lxrxx_qymc");
edit2=rst2.GetFieldValue("lxrxx_xm");
com2=rst2.GetFieldValue("lxrxx_xb");
edit3=rst2.GetFieldValue("lxrxx_nl");
com3=rst2.GetFieldValue("lxrxx_zw");
edit4=rst2.GetFieldValue("lxrxx_bgdh");
edit5=rst2.GetFieldValue("lxrxx_Email");
date1=rst2.GetFieldValue("lxrxx_csny");
edit6=rst2.GetFieldValue("lxrxx_sj");
edit7=rst2.GetFieldValue("lxrxx_grjj");
date2=rst2.GetFieldValue("lxrxx_djrq");
edit8=rst2.GetFieldValue("lxrxx_xxdjr");
edit9=rst2.GetFieldValue("lxrxx_bz");
}
void lxrxx::listshow()
{
	m_list.ShowWindow(SW_SHOW);
m_edit1.ShowWindow(SW_HIDE);
m_edit2.ShowWindow(SW_HIDE);
m_edit3.ShowWindow(SW_HIDE);
m_edit4.ShowWindow(SW_HIDE);
m_edit5.ShowWindow(SW_HIDE);
m_edit6.ShowWindow(SW_HIDE);
m_edit7.ShowWindow(SW_HIDE);
m_edit8.ShowWindow(SW_HIDE);
m_edit9.ShowWindow(SW_HIDE);
m_com1.ShowWindow(SW_HIDE);
m_com2.ShowWindow(SW_HIDE);
m_com3.ShowWindow(SW_HIDE);
m_date1.ShowWindow(SW_HIDE);
m_date2.ShowWindow(SW_HIDE);
}
void lxrxx::textshow()
{
	m_list.ShowWindow(SW_HIDE);
m_edit1.ShowWindow(SW_SHOW);
m_edit2.ShowWindow(SW_SHOW);
m_edit3.ShowWindow(SW_SHOW);
m_edit4.ShowWindow(SW_SHOW);
m_edit5.ShowWindow(SW_SHOW);
m_edit6.ShowWindow(SW_SHOW);
m_edit7.ShowWindow(SW_SHOW);
m_edit8.ShowWindow(SW_SHOW);
m_edit9.ShowWindow(SW_SHOW);
m_com1.ShowWindow(SW_SHOW);
m_com2.ShowWindow(SW_SHOW);
m_com3.ShowWindow(SW_SHOW);
m_date1.ShowWindow(SW_SHOW);
m_date2.ShowWindow(SW_SHOW);
}
void lxrxx::numauto()
{
	
		ado rst3;
		rst3.rstOpen("select * from tb_Client_lxrxx");
		if(rst3.GetRecordCount()==0)
		{
this->m_edit1.SetWindowText("LXR001");
this->m_edit1.EnableWindow(false);
return;
		}
		
	rst3.rstOpen("select * from tb_Client_lxrxx");
	rst3.MoveLast();
	CString mm=rst3.GetFieldValue("lxrxx_id");
	int xuhao=atoi(mm.Right(3));
	xuhao+=1;
	mm.Format("LXR%03d",xuhao);
	this->m_edit1.EnableWindow(false);
	
	this->m_edit1.SetWindowText(mm);
	rst3.close();
}
void lxrxx::enbutton(bool butn)
{
	toolbar.EnableButton(ID_ADD,butn);
	toolbar.EnableButton(ID_UPDATE,butn);
	toolbar.EnableButton(ID_DELETE,butn);
	toolbar.EnableButton(ID_UP,butn);
	toolbar.EnableButton(ID_NEXT,butn);
	toolbar.EnableButton(ID_FIRST,butn);
	toolbar.EnableButton(ID_LAST,butn);
	toolbar.EnableButton(ID_SAVE,!butn);
	toolbar.EnableButton(ID_CANCEL,!butn);

}
void lxrxx::loadf()
{/*
	if(chuan.IsEmpty())

	{rst2.rstOpen("select * from tb_Client_lxrxx");}
	else
		MessageBox(chuan);
		chuanSQL.Format("select * from tb_Client_lxrxx where lxrxx_id='%s'",chuan);
	{rst2.Open(chuanSQL,adCmdText);}
	*/
rst2.rstOpen("select * from tb_Client_lxrxx");
num2=rst2.GetRecordCount();
//rst.MoveFirst();
edit1=rst2.GetFieldValue("lxrxx_id");
com1=rst2.GetFieldValue("lxrxx_qymc");
edit2=rst2.GetFieldValue("lxrxx_xm");
com2=rst2.GetFieldValue("lxrxx_xb");
edit3=rst2.GetFieldValue("lxrxx_nl");
com3=rst2.GetFieldValue("lxrxx_zw");
edit4=rst2.GetFieldValue("lxrxx_bgdh");
edit5=rst2.GetFieldValue("lxrxx_Email");
date1=rst2.GetFieldValue("lxrxx_csny");
edit6=rst2.GetFieldValue("lxrxx_sj");
edit7=rst2.GetFieldValue("lxrxx_grjj");
date2=rst2.GetFieldValue("lxrxx_djrq");
edit8=rst2.GetFieldValue("lxrxx_xxdjr");
edit9=rst2.GetFieldValue("lxrxx_bz");
}
void lxrxx::load2()
{
	ado rst;
rst.Open("select * from tb_Client_lxrxx",adCmdText);
int recordcount=rst.GetRecordCount();
int ii;
for(ii=1;ii<=recordcount;ii++)
{
m_list.InsertItem(ii-1,"");
m_list.SetItemText(ii-1,0,rst.GetFieldValue("lxrxx_id"));
m_list.SetItemText(ii-1,1,rst.GetFieldValue("lxrxx_qymc"));
m_list.SetItemText(ii-1,2,rst.GetFieldValue("lxrxx_xm"));
m_list.SetItemText(ii-1,3,rst.GetFieldValue("lxrxx_xb"));
m_list.SetItemText(ii-1,4,rst.GetFieldValue("lxrxx_nl"));
m_list.SetItemText(ii-1,5,rst.GetFieldValue("lxrxx_zw"));
m_list.SetItemText(ii-1,6,rst.GetFieldValue("lxrxx_bgdh"));
m_list.SetItemText(ii-1,7,rst.GetFieldValue("lxrxx_Email"));
m_list.SetItemText(ii-1,8,rst.GetFieldValue("lxrxx_sj"));
rst.Move(ii);
}
rst.close();
}