devicemanagermentdlg.cpp

本程序使用Visual C++6.0编写

//	m_subbtn.SetColor(CButtonST::BTNST_COLOR_BK_IN, RGB(100,155,100));
	m_subbtn.SetColor(CButtonST::BTNST_COLOR_BK_OUT, RGB(162,189,252));
//	m_subbtn.SetColor(CButtonST::BTNST_COLOR_BK_FOCUS, RGB(0,155,155));
//	m_subbtn.DrawBorder(TRUE);
m_subbtn.SetIcon(IDI_COMPANY);
//	m_servicembtn.SetColor(CButtonST::BTNST_COLOR_BK_IN, RGB(100,155,100));
	m_servicembtn.SetColor(CButtonST::BTNST_COLOR_BK_OUT, RGB(162,189,252));
//	m_servicembtn.SetColor(CButtonST::BTNST_COLOR_BK_FOCUS, RGB(0,155,155));
//	m_servicembtn.DrawBorder(TRUE);
m_servicembtn.SetIcon(IDI_MAINFRAME0);
//m_bk.SetBitmap( ::LoadBitmap(NULL, MAKEINTRESOURCE(IDB_BKBITMAP)) );

	m_addbtn.SetShade(CShadeButtonST::SHS_HARDBUMP);
	m_updatebtn.SetShade(CShadeButtonST::SHS_HARDBUMP);
	m_deletebtn.SetShade(CShadeButtonST::SHS_HARDBUMP);

	RECT rect;
	m_list.GetWindowRect(&rect);
	width=rect.right-rect.left;
	m_list.SetExtendedStyle(WS_CHILD|WS_CLIPSIBLINGS|WS_EX_TOOLWINDOW|WS_BORDER|LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES);

	m_list.InsertColumn(0,"起始IP",LVCFMT_LEFT,width/4);
	m_list.InsertColumn(1,"结束IP",LVCFMT_LEFT,width/4);
	m_list.InsertColumn(2,"子网掩码",LVCFMT_LEFT,width/4);
	m_list.InsertColumn(3,"子网描述",LVCFMT_LEFT,width/4);

	m_pRecordset.CreateInstance(__uuidof(Recordset));
    try
	{
		CString SQLStr="SELECT * FROM Subnet";
    	m_pRecordset->Open((LPTSTR)SQLStr.GetBuffer(130),
				((CSjsysApp*)AfxGetApp())->pConnection.GetInterfacePtr(),
				adOpenDynamic,adLockPessimistic,adCmdText);//打开查询结果记录集

		int i=0;
		int nItem=0;
		while(!(m_pRecordset->adoEOF))
			{				
				nItem=m_list.InsertItem(i,((CSjsysApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("Startip")));//产品编号
				m_list.SetItemText(nItem,1,((CSjsysApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("Endip")));	//产品名称			
				m_list.SetItemText(nItem,2,((CSjsysApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("Ipamsk"))); //规格
				m_list.SetItemText(nItem,3,((CSjsysApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("Descr"))); //型号
				
				m_pRecordset->MoveNext();
				i++;
			}
		m_pRecordset->Close();		
	}

	catch(_com_error e)///捕捉异常
	{
		CString errormessage;
		MessageBox("创建记录集失败!","错误");
	}

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

void CDeviceManagermentDlg::RefreshData1()
{
    while(m_list.DeleteColumn(0));
	m_list.InsertColumn(0,"起始IP",LVCFMT_LEFT,width/4);
	m_list.InsertColumn(1,"结束IP",LVCFMT_LEFT,width/4);
	m_list.InsertColumn(2,"子网掩码",LVCFMT_LEFT,width/4);
	m_list.InsertColumn(3,"子网描述",LVCFMT_LEFT,width/4);

	m_list.DeleteAllItems();
	m_list.SetRedraw(FALSE);
	m_pRecordset.CreateInstance(__uuidof(Recordset));
    try
	{
		CString SQLStr="SELECT * FROM Subnet";
    	m_pRecordset->Open((LPTSTR)SQLStr.GetBuffer(130),
				((CSjsysApp*)AfxGetApp())->pConnection.GetInterfacePtr(),
				adOpenDynamic,adLockPessimistic,adCmdText);//打开查询结果记录集
		int i=0;
		int nItem=0;
		while(!(m_pRecordset->adoEOF))
			{				
				nItem=m_list.InsertItem(i,((CSjsysApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("Startip")));//产品编号
				m_list.SetItemText(nItem,1,((CSjsysApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("Endip")));	//产品名称			
				m_list.SetItemText(nItem,2,((CSjsysApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("Ipamsk"))); //规格
				m_list.SetItemText(nItem,3,((CSjsysApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("Descr"))); //型号
				
				m_pRecordset->MoveNext();
				i++;
			}
		m_pRecordset->Close();		
	}

	catch(_com_error e)///捕捉异常
	{
		CString errormessage;
		MessageBox("创建记录集失败!","错误");
	}

    m_list.SetRedraw(TRUE);
}

void CDeviceManagermentDlg::RefreshData2()
{
	while(m_list.DeleteColumn(0));
	m_list.InsertColumn(0,"类型名",LVCFMT_LEFT,width/4);
	m_list.InsertColumn(1,"开始端口号",LVCFMT_LEFT,width/4);
	m_list.InsertColumn(2,"结束端口号",LVCFMT_LEFT,width/4);
	m_list.InsertColumn(3,"IP地址",LVCFMT_LEFT,width/4);
	m_list.DeleteAllItems();
	m_list.SetRedraw(FALSE);
    
	m_pRecordset.CreateInstance(__uuidof(Recordset));
    try
	{
		CString SQLStr="SELECT * FROM Servtypeconf";
    	m_pRecordset->Open((LPTSTR)SQLStr.GetBuffer(130),
				((CSjsysApp*)AfxGetApp())->pConnection.GetInterfacePtr(),
				adOpenDynamic,adLockPessimistic,adCmdText);//打开查询结果记录集
	
		int i=0;
		while(!(m_pRecordset->adoEOF))
			{				
				m_list.InsertItem(i,((CSjsysApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("Name")));//产品编号
				m_list.SetItemText(i,1,((CSjsysApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("Startport")));	//产品名称			
				m_list.SetItemText(i,2,((CSjsysApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("Endport"))); //规格
				m_list.SetItemText(i,3,((CSjsysApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("Ipaddr"))); //型号
				
				m_pRecordset->MoveNext();
				i++;
			}
		m_pRecordset->Close();		
	}

	catch(_com_error e)///捕捉异常
	{
		CString errormessage;
		MessageBox("创建记录集失败!","错误");
	}

    m_list.SetRedraw(TRUE);
}

void CDeviceManagermentDlg::RefreshData3()
{
    while(m_list.DeleteColumn(0));
	m_list.InsertColumn(0,"名称",LVCFMT_LEFT,width/2);
    m_list.InsertColumn(1,"端口",LVCFMT_LEFT,width/2);
	m_list.DeleteAllItems();
    m_list.SetRedraw(FALSE);
    
	m_pRecordset.CreateInstance(__uuidof(Recordset));
    try
	{
		CString SQLStr="SELECT * FROM Servtype";
    	m_pRecordset->Open((LPTSTR)SQLStr.GetBuffer(130),
				((CSjsysApp*)AfxGetApp())->pConnection.GetInterfacePtr(),
				adOpenDynamic,adLockPessimistic,adCmdText);//打开查询结果记录集

		int i=0;
		while(!(m_pRecordset->adoEOF))
			{				
				m_list.InsertItem(i,((CSjsysApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("Name")));//产品编号
				m_list.SetItemText(i,1,((CSjsysApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("Port")));	//产品名称			
			
				m_pRecordset->MoveNext();
				i++;
			}
		m_pRecordset->Close();		
	}

	catch(_com_error e)///捕捉异常
	{
		CString errormessage;
		MessageBox("创建记录集失败!","错误");
	}

    m_list.SetRedraw(TRUE);
}

void CDeviceManagermentDlg::RefreshData4()
{
	while(m_list.DeleteColumn(0));
 	m_list.InsertColumn(0,"起始IP",LVCFMT_LEFT,width/3);
 	m_list.InsertColumn(1,"结束IP",LVCFMT_LEFT,width/3);
 	m_list.InsertColumn(2,"描述",LVCFMT_LEFT,width/3);
	m_list.DeleteAllItems();
	m_list.SetRedraw(FALSE);
    
	m_pRecordset.CreateInstance(__uuidof(Recordset));
    try
	{
		CString SQLStr="SELECT * FROM Reserveip";
    	m_pRecordset->Open((LPTSTR)SQLStr.GetBuffer(130),
				((CSjsysApp*)AfxGetApp())->pConnection.GetInterfacePtr(),
				adOpenDynamic,adLockPessimistic,adCmdText);//打开查询结果记录集
		
		int i=0;
		int nItem=0;
		while(!(m_pRecordset->adoEOF))
			{				
				nItem=m_list.InsertItem(i,((CSjsysApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("startip")));//产品编号
				m_list.SetItemText(nItem,1,((CSjsysApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("endip")));	//产品名称			
				m_list.SetItemText(nItem,2,((CSjsysApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("descr"))); //型号
				
				m_pRecordset->MoveNext();
				i++;
			}
		m_pRecordset->Close();		
	}

	catch(_com_error e)///捕捉异常
	{
		CString errormessage;
		MessageBox("创建记录集失败!","错误");
	}

    m_list.SetRedraw(TRUE);
}




void CDeviceManagermentDlg::OnDblclkList1(NMHDR* pNMHDR, LRESULT* pResult) 
{
	// TODO: Add your control notification handler code here
	POSITION pos = m_list.GetFirstSelectedItemPosition();
	int m_nIndex = m_list.GetNextSelectedItem(pos);  // 得到项目索引
	if(m_nIndex==-1)
	{
		MessageBox("请选择一项在修改!","提示",MB_ICONINFORMATION);
		return;
	}
    m_flag=2;
	if(m_btnflag==1)
	{
		dlg1.m_edit1  = m_list.GetItemText( m_nIndex,0);
		dlg1.m_edit2 = m_list.GetItemText(m_nIndex,1);
		dlg1.m_edit3 = m_list.GetItemText( m_nIndex,2);
		dlg1.m_edit4 = m_list.GetItemText( m_nIndex,3);
		dlg1.m_flag=m_flag;
		//dlg1.DoModal();
		if(IDCANCEL==dlg1.DoModal())
			return;
	     RefreshData1();
	}
	else if(m_btnflag==2)
	{
		dlg2.m_Name  = m_list.GetItemText( m_nIndex,0);
		dlg2.m_StartPort = m_list.GetItemText(m_nIndex,1);
		dlg2.m_EndPort = m_list.GetItemText( m_nIndex,2);
		dlg2.m_IpAddress = m_list.GetItemText( m_nIndex,3);
		dlg2.m_flag=m_flag;
		if(IDCANCEL==dlg2.DoModal())
			return;
	     RefreshData2();
	}
	else if(m_btnflag==3)
	{
		dlg3.m_Name  = m_list.GetItemText( m_nIndex,0);
		dlg3.m_Port = m_list.GetItemText(m_nIndex,1);
		dlg3.m_flag=m_flag;
        if(IDCANCEL==dlg3.DoModal())
			return;
	     RefreshData3();
	}
	else if(m_btnflag==4)
	{
		dlg4.m_StartIp  = m_list.GetItemText( m_nIndex,0);
		dlg4.m_Endip = m_list.GetItemText(m_nIndex,1);
		dlg4.m_Describe = m_list.GetItemText( m_nIndex,2);
		dlg4.m_flag=m_flag;
		if(IDCANCEL==dlg4.DoModal())
			return;
	     RefreshData4();
	}

	*pResult = 0;
}