liinfodlg.cpp

订单管理系统

// liInfoDlg.cpp : implementation file
//

#include "stdafx.h"
#include "ordermanagement.h"
#include "liInfoDlg.h"

#include "ADOConn.h"

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

/////////////////////////////////////////////////////////////////////////////
// CliInfoDlg dialog


CliInfoDlg::CliInfoDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CliInfoDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CliInfoDlg)
	m_strID = _T("");
	m_strCom = _T("");
	m_strRemark = _T("");
	m_strPwd = _T("");
	m_strPost = _T("");
	m_currTime = _T("");
	m_strMan = _T("");
	m_strSite = _T("");
	m_strEmail = _T("");
	m_strTel = _T("");
	m_strAddr = _T("");
	m_baobao = _T("");
	m_shp = _T("");
	//}}AFX_DATA_INIT
cliID ="";
m_hIcon = AfxGetApp()->LoadIcon(IDR_MAINFRAME);
}


void CliInfoDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CliInfoDlg)
	DDX_Control(pDX, IDC_EDIT12, m_sp);
	DDX_Control(pDX, IDC_EDIT2, m_EditStrPwd);
	DDX_Control(pDX, IDC_EDIT1, m_EditStrID);
	DDX_Text(pDX, IDC_EDIT1, m_strID);
	DDX_Text(pDX, IDC_EDIT10, m_strCom);
	DDX_Text(pDX, IDC_EDIT11, m_strRemark);
	DDX_Text(pDX, IDC_EDIT2, m_strPwd);
	DDX_Text(pDX, IDC_EDIT3, m_strPost);
	DDX_Text(pDX, IDC_EDIT4_DATE, m_currTime);
	DDX_Text(pDX, IDC_EDIT5, m_strMan);
	DDX_Text(pDX, IDC_EDIT6, m_strSite);
	DDX_Text(pDX, IDC_EDIT7, m_strEmail);
	DDX_Text(pDX, IDC_EDIT8, m_strTel);
	DDX_Text(pDX, IDC_EDIT9, m_strAddr);
	DDX_Text(pDX, IDC_EDIT4, m_baobao);
DDX_Control(pDX, IDOK, m_ButLogin);
DDX_Control(pDX, IDCANCEL, m_Butcancel);
	DDX_Text(pDX, IDC_EDIT12, m_shp);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CliInfoDlg, CDialog)
	//{{AFX_MSG_MAP(CliInfoDlg)
	ON_WM_CTLCOLOR()
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CliInfoDlg message handlers
ADOConn cConn;//建立一个客户对象
_bstr_t ssSQL;

void CliInfoDlg::OnOK() 
{
	if(CliTest())
	{
		if(modfy == 1)
		{
	if(MessageBox("是否确定更新信息？","请确认",MB_YESNO) == IDYES)
	{
			modfy = 0;
			if(ReMod())
				AfxMessageBox("信息更改成功!");
				CDialog::OnCancel();
				}
		}
		else 
		if(MessageBox("是否确定注册？","请确认",MB_YESNO) == IDYES)
	{

	if(AddClient())
			{
				AfxMessageBox("注册成功,请登录进入系统!");
				CDialog::OnCancel();
			}
		}
		
	}	
	else 
	{
		if(modfy == 1) m_EditStrID.SetReadOnly(true);
		else m_strID   = "";
		m_strPwd  = "";
		m_baobao = "";
		UpdateData(false);
	
	}

}

BOOL CliInfoDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	SetIcon(m_hIcon, TRUE);			// Set big icon
	SetIcon(m_hIcon, FALSE);		// Set small icon

	//修改信息
	if(modfy)
	{
		_RecordsetPtr m_pCRecordset;
		
		ssSQL ="select * from ClientMessage where currState=1";
		m_pCRecordset = cConn.GetRecordSet(ssSQL);
	m_EditStrID.SetReadOnly(true);
		cConn.vCID = m_pCRecordset->GetCollect("clientID");
	//	cConn.vCPwd = m_pCRecordset->GetCollect("userpwd");
		cConn.vCN  = m_pCRecordset->GetCollect("company");
		cConn.vClP = m_pCRecordset->GetCollect("contactPerson");
		cConn.vCAdd = m_pCRecordset->GetCollect("address");
		cConn.vCPo = m_pCRecordset->GetCollect("postCode");
		cConn.vCTel = m_pCRecordset->GetCollect("telephone");
		cConn.vVWeb  = m_pCRecordset->GetCollect("website");
		cConn.vEmail  = m_pCRecordset->GetCollect("email");
		cConn.vCBDate = m_pCRecordset->GetCollect("bookingDate");
		cConn.vRemark = m_pCRecordset->GetCollect("remark");

		m_strID = (char *)(_bstr_t)cConn.vCID;
		m_strPwd  = (char *)(_bstr_t)cConn.vCPwd;
		m_strCom  = (char *)(_bstr_t)cConn.vCN;
		m_strMan  = (char *)(_bstr_t)cConn.vClP;
		m_strAddr = (char *)(_bstr_t)cConn.vCAdd;
		m_strPost = (char *)(_bstr_t)cConn.vCPo;
		m_strTel  = (char *)(_bstr_t)cConn.vCTel;
		m_strSite = (char *)(_bstr_t)cConn.vVWeb;
		m_strEmail  = (char *)(_bstr_t)cConn.vEmail;
		m_currTime  = (char *)(_bstr_t)cConn.vCBDate;
		m_strRemark = (char *)(_bstr_t)cConn.vRemark;
		m_shp = _T("是");
		cliID = m_strID;
	}
/*  获取当前时间
	CTime time=CTime::GetCurrentTime();
	CString sTime=time.Format("%I:%M %p");
	m_currTime = sTime;
*/
	//新客户注册
	else {	
		//获取当前日期
		COleDateTime dtNow = COleDateTime::GetCurrentTime();
		CString strNow;
		strNow.Format("%d-%d-%d" , dtNow.GetYear(), dtNow.GetMonth(), dtNow.GetDay());
		m_currTime = strNow;
m_shp = _T("否");
m_sp.EnableWindow(FALSE);
	}
	UpdateData(false);
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

bool CliInfoDlg::CliTest()
{
	UpdateData(true);					  //更新空件值变量您可以使用此帐号密码
	if(!_ROW())
	{
		AfxMessageBox("所有信息必须都填写,请重新输入!");
		m_EditStrID.SetFocus();			  //焦点返回用户名输入框
	}
	else 
	{
		int len = m_EditStrPwd.LineLength(); //取得密码长度
		if(len <= 6)
		{
			AfxMessageBox("密码不少于七位,请重新输入!");
			m_EditStrPwd.SetFocus();		  //焦点返回用户名输入框	

		}
		else								  // 核对用户名和密码是否合法
		{
			if(modfy==0)
			{
			try{
				//如果Concection对象为空,则重新连接
				if(cConn.m_pConn == NULL)
					cConn.OnInitADOConn();
			
				//编辑SQ语句,判断输入的数据是否重名
				ssSQL = "SELECT * FROM ClientMessage WHERE clientID='"+m_strID+"' ";
				//执行SQL语句
				cConn.m_pRs = cConn.GetRecordSet(ssSQL);
				if(!cConn.m_pRs->adoBOF)
				{
					AfxMessageBox("用户名已经存在,请重新输入!");

					return false;
				}
				else {
					if(m_baobao!=m_strPwd)
					{
						AfxMessageBox("前后两次密码不相同，请重新输入!");

						return false;
					}
					else{
						return true;
					}//输入的数据合法
				}
			}
			catch(_com_error e)
			{
				AfxMessageBox(e.Description());
				return false;
			}
			}
				if(m_baobao!=m_strPwd)
					{
						AfxMessageBox("前后两次密码不相同，请重新输入!");

						return false;
					}
					else{
						return true;
					}//输入的数据合法
		}
	}			
	return false;
}

bool CliInfoDlg::AddClient()
{
	try{
		cConn.m_pRs->AddNew();
		cConn.vCID   = m_strID;
		cConn.vCPwd  = m_strPwd;
		cConn.vCN    = m_strCom;
		cConn.vClP   = m_strMan;
		cConn.vCAdd  = m_strAddr;
		cConn.vCPo   = m_strPost;
		cConn.vCTel  = m_strTel;
		cConn.vVWeb  = m_strSite;
		cConn.vEmail = m_strEmail;
		cConn.vCBDate = m_currTime;
		cConn.vRemark = m_strRemark;

		cConn.m_pRs->PutCollect("clientID",cConn.vCID);
		cConn.m_pRs->PutCollect("userpwd",cConn.vCPwd);
		cConn.m_pRs->PutCollect("company",cConn.vCN);
		cConn.m_pRs->PutCollect("contactPerson",cConn.vClP);
		cConn.m_pRs->PutCollect("address",cConn.vCAdd);
		cConn.m_pRs->PutCollect("postCode",cConn.vCPo);
		cConn.m_pRs->PutCollect("telephone",cConn.vCTel);
		cConn.m_pRs->PutCollect("website",cConn.vVWeb);
		cConn.m_pRs->PutCollect("email",cConn.vEmail);
		cConn.m_pRs->PutCollect("bookingDate",cConn.vCBDate);
		cConn.m_pRs->PutCollect("remark",cConn.vRemark);

		cConn.m_pRs->Update();//更新数据

//		oconn.ExitConnect();//关闭连接
	}
	catch(_com_error e)
	{
		AfxMessageBox(e.Description());		
	}
	return true;
}




bool CliInfoDlg::ReMod()
{
	try{
		UpdateData(true);
		//执行SQL语句
		cConn.m_pRs = cConn.GetRecordSet(ssSQL);
		ssSQL = "UPDATE ClientMessage SET clientID='"+m_strID+"',userpwd='"+m_strPwd+
			"',company='"+m_strCom+"',contactPerson='"+m_strMan+"',address='"+m_strAddr+
			"',postCode='"+m_strPost+"',telephone='"+m_strTel+"',website='"+m_strSite+
			"',email='"+m_strEmail+"',bookingDate='"+m_currTime+"',remark='"+m_strRemark+
			"' WHERE clientID ='"+cliID+"'";
		if(cConn.ExecuteSQL(ssSQL))
		{
			cConn.m_pRs->Update();
			return true;
		}	
	}
	catch(_com_error e)
	{
		AfxMessageBox(e.Description());
	}
	return false;
}

bool CliInfoDlg::_ROW()
{
	if(m_strID.IsEmpty() || m_strAddr.IsEmpty() || m_strCom.IsEmpty() || m_strEmail.IsEmpty()
		|| m_strMan.IsEmpty() || m_strPost.IsEmpty() || m_strRemark.IsEmpty() 
		|| m_strSite.IsEmpty() || m_strTel.IsEmpty())
		return false;
	else
		return true;
}

void CliInfoDlg::OnCancel() 
{
	// TODO: Add extra cleanup here
	
	CDialog::OnCancel();
m_EditStrID.SetReadOnly(false);
}

HBRUSH CliInfoDlg::OnCtlColor(CDC* pDC, CWnd* pWnd, UINT nCtlColor) 
{
	//HBRUSH hbr = CDialog::OnCtlColor(pDC, pWnd, nCtlColor);
	
COLORREF backColor = RGB(231, 231, 231); //office 2003背景色 
pDC->SetBkMode(TRANSPARENT);                //设置控件背景透明 
return CreateSolidBrush(backColor);            //创建背景刷子 	
	// TODO: Return a different brush if the default is not desired
	//return hbr;

	//HBRUSH hbr = CDialog::OnCtlColor(pDC,pWnd,nCtlColor); 
//pDC->SetBkMode(TRANSPARENT);   
//return    (HBRUSH)GetStockObject(NULL_BRUSH);  
}