ustomerinfosetdlg.cpp

用于网络管理统计的

void CustomerInfoSetDlg::GetCustomerInfo()
{
	GetDlgItem(IDC_EDIT_NAME)->GetWindowText(m_CustomerInfo.Name);
	GetDlgItem(IDC_EDIT_SHORT)->GetWindowText(m_CustomerInfo.Short);
	GetDlgItem(IDC_EDIT_IP)->GetWindowText(m_CustomerInfo.IP);
	GetDlgItem(IDC_EDIT_MAC)->GetWindowText(m_CustomerInfo.MAC);
	GetDlgItem(IDC_EDIT_ADDRESS)->GetWindowText(m_CustomerInfo.Address);
	GetDlgItem(IDC_EDIT_PHONE)->GetWindowText(m_CustomerInfo.Phone);
	GetDlgItem(IDC_EDIT_REMARK)->GetWindowText(m_CustomerInfo.Remark);
//	GetDlgItem(IDC_EDIT_NO)->GetWindowText(m_CustomerInfo.sNO);
//	GetDlgItem(IDC_EDIT_GATEWAY)->GetWindowText(m_CustomerInfo.Gateway);
	GetDlgItem(IDC_COMBO_ADD_CUSTOMER_INFO_TYPE)->GetWindowText(m_CustomerInfo.Type);
	GetDlgItem(IDC_COMBO_ADD_CUSTOMER_INFO_TRACT)->GetWindowText(m_CustomerInfo.Tract);
	CDateTimeCtrl *pCtrl1 = (CDateTimeCtrl*)GetDlgItem(IDC_DATETIMEPICKER1);
	pCtrl1->GetTime(m_CustomerInfo.Jointime);
	CDateTimeCtrl *pCtrl2 = (CDateTimeCtrl*)GetDlgItem(IDC_DATETIMEPICKER2);
	pCtrl2->GetTime(m_CustomerInfo.Felltime);
	m_CustomerInfo.ID = ID;
}
void CustomerInfoSetDlg::SetCustomerInfo()
{
	GetDlgItem(IDC_EDIT_NAME)->SetWindowText(m_CustomerInfo.Name);
	GetDlgItem(IDC_EDIT_SHORT)->SetWindowText(m_CustomerInfo.Short);
	GetDlgItem(IDC_EDIT_IP)->SetWindowText(m_CustomerInfo.IP);
	GetDlgItem(IDC_EDIT_MAC)->SetWindowText(m_CustomerInfo.MAC);
	GetDlgItem(IDC_EDIT_ADDRESS)->SetWindowText(m_CustomerInfo.Address);
	GetDlgItem(IDC_EDIT_PHONE)->SetWindowText(m_CustomerInfo.Phone);
	GetDlgItem(IDC_EDIT_REMARK)->SetWindowText(m_CustomerInfo.Remark);
//	GetDlgItem(IDC_EDIT_NO)->SetWindowText(m_CustomerInfo.sNO);
//	GetDlgItem(IDC_EDIT_GATEWAY)->SetWindowText(m_CustomerInfo.Gateway);
	CDateTimeCtrl *pCtrl1 = (CDateTimeCtrl*)GetDlgItem(IDC_DATETIMEPICKER1);
	pCtrl1->SetTime(m_CustomerInfo.Jointime);
	CDateTimeCtrl *pCtrl2 = (CDateTimeCtrl*)GetDlgItem(IDC_DATETIMEPICKER2);
	pCtrl2->SetTime(m_CustomerInfo.Felltime);
}
void CustomerInfoSetDlg::OnClose() 
{
	// TODO: Add your message handler code here and/or call default
	if(m_pADOSet->State == adStateOpen)
	{
		m_pADOSet->Close();
	}
	m_pADOSet.Release();
	CDialog::OnClose();
}
void CustomerInfoSetDlg::SetCtrlBkColor()
{
	m_save.SetActiveBgColor (RGB(162,189,255));
	m_save.SetInactiveBgColor (RGB(162,189,255));
	m_ok.SetActiveBgColor (RGB(162,189,255));
	m_ok.SetInactiveBgColor (RGB(162,189,255));
	m_add.SetActiveBgColor (RGB(162,189,255));
	m_add.SetInactiveBgColor (RGB(162,189,255));
	m_cancel.SetActiveBgColor (RGB(162,189,255));
	m_cancel.SetInactiveBgColor (RGB(162,189,255));
	m_modify.SetActiveBgColor (RGB(162,189,255));
	m_modify.SetInactiveBgColor (RGB(162,189,255));
	m_up.SetActiveBgColor (RGB(162,189,255));
	m_up.SetInactiveBgColor (RGB(162,189,255));
	m_down.SetActiveBgColor (RGB(162,189,255));
	m_down.SetInactiveBgColor (RGB(162,189,255));
	m_search.SetActiveBgColor(RGB(162,189,255));
	m_search.SetInactiveBgColor(RGB(162,189,255));
}
void CustomerInfoSetDlg::ClearCustomer()
{
	m_CustomerInfo.Address = "";
	m_CustomerInfo.Felltime = COleDateTime::GetCurrentTime();
//	m_CustomerInfo.Gateway = "";
	m_CustomerInfo.IP = "";
	m_CustomerInfo.Jointime = COleDateTime::GetCurrentTime();
	m_CustomerInfo.MAC = "";
	m_CustomerInfo.Name = "";
	m_CustomerInfo.Phone = "";
	m_CustomerInfo.Remark = "";
	m_CustomerInfo.Short = "";
//	m_CustomerInfo.sNO = "";
	m_CustomerInfo.Tract = "";
	m_CustomerInfo.Type = "";
	m_CustomerInfo.ID = 0;
}
void CustomerInfoSetDlg::ClearCtrlData()
{
	GetDlgItem(IDC_EDIT_NAME)->SetWindowText("");
	GetDlgItem(IDC_EDIT_SHORT)->SetWindowText("");
	GetDlgItem(IDC_EDIT_IP)->SetWindowText("");
	GetDlgItem(IDC_EDIT_MAC)->SetWindowText("");
	GetDlgItem(IDC_EDIT_ADDRESS)->SetWindowText("");
	GetDlgItem(IDC_EDIT_PHONE)->SetWindowText("");
	GetDlgItem(IDC_EDIT_REMARK)->SetWindowText("");
//	GetDlgItem(IDC_EDIT_NO)->SetWindowText("");
//	GetDlgItem(IDC_EDIT_GATEWAY)->SetWindowText("");
}

void CustomerInfoSetDlg::OnButtonAddCustomerInfo() 
{
	// TODO: Add your control notification handler code here
	bIsAdd = true;
	bIsModify = false;
	m_save.EnableWindow(true);
	ClearCtrlData();
	ClearCustomer();
}

void CustomerInfoSetDlg::OnButtonModifyCusotmerInfo() 
{
	// TODO: Add your control notification handler code here
	CString sName;
	GetDlgItem(IDC_EDIT_NAME)->GetWindowText(sName);
	if(sName = "")
	{
		MessageBox("请你选择要修改的记录");
		return;
	}
	bIsModify = true;
	bIsAdd = false;
	m_save.EnableWindow(true);
	ClearCustomer();
}

void CustomerInfoSetDlg::OnButtonSaveCustomerInfo() 
{
	// TODO: Add your control notification handler code here
    GetCustomerInfo();
	if(m_CustomerInfo.Name == "")
	{
		MessageBox("请你填写姓名，姓名不能为空",MB_OK);
		return;
	}
	if(m_CustomerInfo.Address == "")
		m_CustomerInfo.Address = " ";
	if(m_CustomerInfo.MAC == "")
		m_CustomerInfo.MAC = " ";
	if(m_CustomerInfo.Phone == "")
		m_CustomerInfo.Phone = " ";
	if(m_CustomerInfo.Remark == "")
		m_CustomerInfo.Remark = " ";
	if(m_CustomerInfo.Short == "")
		m_CustomerInfo.Short = " ";
	if(m_CustomerInfo.IP == "")
		m_CustomerInfo.IP = " ";

	CString strSQL;
	int TypeID;
	int TractID;
	CString stime;
	CString etime;
	stime = m_CustomerInfo.Jointime.Format("%Y-%m-%d");
	etime = m_CustomerInfo.Felltime.Format("%Y-%m-%d");
	TypeID = GetTypeID(m_CustomerInfo.Type);
	TractID = GetTractID(m_CustomerInfo.Tract);
	if(bIsAdd)
	{
		bIsAdd = false;
		strSQL.Format("Insert into CustomerInfo(所属地域,姓名,简称,地址,电话,\
					   IP,MAC,入网时间,到期时间,客户类型,备注) Values \
					   (%d,'%s','%s','%s','%s','%s','%s',#%s#,#%s#,%d,'%s')",\
					   TractID,m_CustomerInfo.Name,m_CustomerInfo.Short,m_CustomerInfo.Address,\
					   m_CustomerInfo.Phone,m_CustomerInfo.IP\
					   ,m_CustomerInfo.MAC,stime,etime,TypeID,m_CustomerInfo.Remark);
	}
	if(bIsModify)
	{
		bIsModify = false;
		strSQL.Format("Update CustomerInfo Set 所属地域=%d,姓名='%s',简称='%s',地址='%s',\
				      电话='%s',IP='%s',MAC='%s',入网时间=#%s#,\
                      到期时间=#%s#,客户类型=%d,备注='%s' where ID=%d",TractID,m_CustomerInfo.Name\
					  ,m_CustomerInfo.Short,m_CustomerInfo.Address,m_CustomerInfo.Phone,\
					  m_CustomerInfo.IP,m_CustomerInfo.MAC,\
					  stime,etime,TypeID,m_CustomerInfo.Remark,m_CustomerInfo.ID);
	}
	try
	{
		theApp.ADOConn->Execute(strSQL.AllocSysString(),NULL,adCmdText);
	}
	catch(_com_error e)
	{
		MessageBox(e.Description(),MB_OK);
		return;
	}
	m_save.EnableWindow(false);
}
int CustomerInfoSetDlg::GetTypeID(CString sType)
{
	CString strSQL;
	int ID;
	_RecordsetPtr m_pADOSet;
	try
	{
		strSQL = "select ID from CustomerType where 客户类型='" + sType + "'";
		m_pADOSet.CreateInstance(__uuidof(Recordset));
		m_pADOSet = theApp.ADOConn->Execute(strSQL.AllocSysString(),NULL,adCmdText);
		if(!m_pADOSet->adoEOF)
		{
			ID = m_pADOSet->GetCollect("ID").iVal;
		}
		m_pADOSet->Close();
	}
	catch(_com_error e)
	{
		MessageBox(e.Description(),MB_OK);
		return 0;
	}
	return ID;
}
int CustomerInfoSetDlg::GetTractID(CString sTract)
{
	CString strSQL;
	int ID;
	_RecordsetPtr m_pADOSet;
	try
	{
		strSQL = "select ID from CustomerTract where 所属地域='" + sTract + "'";
		m_pADOSet.CreateInstance(__uuidof(Recordset));
		m_pADOSet = theApp.ADOConn->Execute(strSQL.AllocSysString(),NULL,adCmdText);
		if(!m_pADOSet->adoEOF)
		{
			ID = m_pADOSet->GetCollect("ID").iVal;
		}
		m_pADOSet->Close();
	}
	catch(_com_error e)
	{
		MessageBox(e.Description(),MB_OK);
		return 0;
	}
	return ID;
}
void CustomerInfoSetDlg::OnDeleteCustomerinfo() 
{
	// TODO: Add your control notification handler code here
	if(ID == 0)
	{
		MessageBox("请你选择要删除的记录",MB_OK);
		return;
	}
	if(MessageBox("你的确要删除吗?","提示",MB_YESNO|MB_ICONEXCLAMATION) == IDYES)
	{
		CString strSQL;
		strSQL.Format("Delete from CustomerInfo where ID=%d",ID);
		try
		{
		     theApp.ADOConn->Execute(strSQL.AllocSysString(),NULL,adCmdText);
		}
		catch(_com_error e)
		{
			MessageBox(e.Description(),MB_OK);
			return;
		}
		
		ClearCtrlData();
		CMainFrame *pFrame = (CMainFrame*)AfxGetApp()->m_pMainWnd;
		CCustomerManageView *pView = (CCustomerManageView*)pFrame->GetActiveView();
		CString sID;
		sID.Format("%d",ID);
		pView->DeleteListItem(sID);
		ID = 0;
		MessageBox("成功的被删除",MB_OK);
	}	
}