📄 netstrategydlg.cpp

📁 本程序使用Visual C++6.0编写
💻 CPP
📖 第 1 页 / 共 5 页
字号:
上一页 1 2 3 45
						{
							CString errormessage;
							MessageBox("创建记录集失败!","错误");
						}
				m_pRecordset->Close();*/
		   }
	  }

	   if(m_radioflag2==2)
	   {
		   m_url[1].RemoveAll();
		   n=m_list22.GetItemCount();
		   if(n==0)
			   break;
		   for(i=0;i<n;i++)
		   {
             str=m_list22.GetItemText(i,0);
			 if(str=="")
				  continue;
			 m_url[1].Add(str);
             /* SQLStr="select * from Urlfilter";
		    	try
				 {
					HRESULT hTRes;
					hTRes = m_pRecordset.CreateInstance(_T("ADODB.Recordset"));
			    	if (SUCCEEDED(hTRes))
					{   
						hTRes = m_pRecordset->Open((LPTSTR)SQLStr.GetBuffer(130),
						             	((CSjsysApp*)AfxGetApp())->pConnection.GetInterfacePtr(),
				        				adOpenDynamic,adLockPessimistic,adCmdText);//打开查询结果记录集
						m_pRecordset->AddNew();//添加新的记录
						m_pRecordset->PutCollect("Deviceid",_variant_t(m_strdeviceid));
						m_pRecordset->PutCollect("Urlname",_variant_t(str));
  				        m_pRecordset->PutCollect("Action",_variant_t("0"));
				       	m_pRecordset->Update(); //更新数据库
						}
					}
					catch(_com_error e)///捕捉异常
						{
							CString errormessage;
							MessageBox("创建记录集失败!","错误");
						}
				m_pRecordset->Close();*/
		   }
	  }

	   break;
   case 2:
	   m_flagstate[3]=m_radioflag2;
	   if(m_radioflag2==1)
	   {
		   m_email[0].RemoveAll();
		   m_email[1].RemoveAll();
		   CString str2;
		   n=m_list11.GetItemCount();
		   if(n!=m_list22.GetItemCount() || n==0)
		   {
			   MessageBox("发件人与收件人不对应");
		        break;
		   }
		   for(i=0;i<n;i++)
		   {
              str=m_list11.GetItemText(i,0);
			  str2=m_list22.GetItemText(i,0);
			  if(str==""||str2=="")
				  continue;
			  m_email[0].Add(str);
			  m_email[1].Add(str2);
             /* SQLStr="select * from Emailfilter";
			  try
				 {
					HRESULT hTRes;
					hTRes = m_pRecordset.CreateInstance(_T("ADODB.Recordset"));
			    	if (SUCCEEDED(hTRes))
					{   
						hTRes = m_pRecordset->Open((LPTSTR)SQLStr.GetBuffer(130),
						             	((CSjsysApp*)AfxGetApp())->pConnection.GetInterfacePtr(),
										adOpenDynamic,adLockPessimistic,adCmdText);//打开查询结果记录集
						m_pRecordset->AddNew();//添加新的记录
						m_pRecordset->PutCollect("Deviceid",_variant_t(m_strdeviceid));
						m_pRecordset->PutCollect("Sendemail",_variant_t(str2));
						m_pRecordset->PutCollect("Recevmail",_variant_t(str));
				       	m_pRecordset->Update(); //更新数据库
					}
				}
				catch(_com_error e)///捕捉异常
					{
						CString errormessage;
						MessageBox("创建记录集失败!","错误");
					}
				m_pRecordset->Close();*/
		}
	 }
	   break;
   case 3:
	   m_flagstate[5]=m_radioflag2;
	   if(m_radioflag2==1)
	   {
		   //m_ftp[0].RemoveAll();
		   n=m_list11.GetItemCount();
		   if(n==0)
			   break;
		   for(i=0;i<n;i++)
		   {
			   if( m_list11.GetItemState(i, LVIS_SELECTED) == LVIS_SELECTED || m_list11.GetCheck(i)) 
				{ 
				   filestate[i]=1;
					//str=m_list11.GetItemText(i,0);
					//m_ftp[0].Add(str);
				} 
			  //str=m_list11.GetItemText(i,0);
			  //if(str=="")
			//	  break;
            // SQLStr="select * from Filetype";
			  //如果表中没有新添的类型，则新添一个
            /*   SQLStr.Format("select * from Filetype where Typename='%s'",str);
			try
				{
					HRESULT hTRes;
					hTRes = m_pRecordset.CreateInstance(_T("ADODB.Recordset"));
					if (SUCCEEDED(hTRes))
					{   
						hTRes = m_pRecordset->Open((LPTSTR)SQLStr.GetBuffer(130),
							((CSjsysApp*)AfxGetApp())->pConnection.GetInterfacePtr(),
							adOpenDynamic,adLockPessimistic,adCmdText);//打开查询结果记录集
						if(SUCCEEDED(hTRes))
						{
							TRACE(_T("连接成功!\n"));
							if (m_pRecordset->adoEOF) 	
							{  
							//	m_pRecordset->MovePrevious();
	            				m_pRecordset->AddNew();//添加新的记录
								m_pRecordset->PutCollect("Typename",_variant_t(str));
								m_pRecordset->PutCollect("Typedescr",_variant_t(str));
			       				m_pRecordset->Update(); //更新数据库
							}
						}
						m_pRecordset->Close();
					}
			}
			catch(_com_error e)///捕捉异常
				{
					CString errormessage;
					MessageBox("创建记录集失败!","错误");
				}
           //获得表中的类型的id
             try
				{
					HRESULT hTRes;
					hTRes = m_pRecordset.CreateInstance(_T("ADODB.Recordset"));
					if (SUCCEEDED(hTRes))
					{   
						hTRes = m_pRecordset->Open((LPTSTR)SQLStr.GetBuffer(130),
							((CSjsysApp*)AfxGetApp())->pConnection.GetInterfacePtr(),
							adOpenDynamic,adLockPessimistic,adCmdText);//打开查询结果记录集
						if(SUCCEEDED(hTRes))
						{
							TRACE(_T("连接成功!\n"));
							if (!m_pRecordset->adoEOF) 	
							{  
								typeindex=m_pRecordset->GetCollect("ID").lVal;
							}
						}
						m_pRecordset->Close();
					}
			}
			catch(_com_error e)///捕捉异常
				{
					CString errormessage;
					MessageBox("创建记录集失败!","错误");
				}


			  try
			  {
				HRESULT hTRes;
				hTRes = m_pRecordset.CreateInstance(_T("ADODB.Recordset"));
		    	if (SUCCEEDED(hTRes))
				{  
					SQLStr="select * from Ftpfilter";
					hTRes = m_pRecordset->Open((LPTSTR)SQLStr.GetBuffer(130),
						             	((CSjsysApp*)AfxGetApp())->pConnection.GetInterfacePtr(),
										adOpenDynamic,adLockPessimistic,adCmdText);//打开查询结果记录集
					m_pRecordset->AddNew();//添加新的记录
					m_pRecordset->PutCollect("Deviceid",_variant_t(m_strdeviceid));
					CString s;
					s.Format("%d",typeindex);
					m_pRecordset->PutCollect("Filetypeid",_variant_t(s));
  			        m_pRecordset->PutCollect("Action",_variant_t("1"));
			       	m_pRecordset->Update(); //更新数据库
					}
				}
				catch(_com_error e)///捕捉异常
				{
					CString errormessage;
					MessageBox("创建记录集失败!","错误");
					}
				m_pRecordset->Close();   */
		  }
	   }
	   if(m_radioflag2==2)
	   {
		  // m_ftp[1].RemoveAll();
		   n=m_list22.GetItemCount();
		   if(n==0)
			   break;
		   for(i=0;i<n;i++)
		   {
			  if( m_list22.GetItemState(i, LVIS_SELECTED) == LVIS_SELECTED || m_list22.GetCheck(i)) 
				{ 
				   filestate[i]=1;
					//str=m_list22.GetItemText(i,0);
					//m_ftp[1].Add(str);
				} 
		/*	  SQLStr.Format("select * from Filetype where Typename='%s'",str);
			try
				{
					HRESULT hTRes;
					hTRes = m_pRecordset.CreateInstance(_T("ADODB.Recordset"));
					if (SUCCEEDED(hTRes))
					{   
						hTRes = m_pRecordset->Open((LPTSTR)SQLStr.GetBuffer(130),
							((CSjsysApp*)AfxGetApp())->pConnection.GetInterfacePtr(),
							adOpenDynamic,adLockPessimistic,adCmdText);//打开查询结果记录集
						if(SUCCEEDED(hTRes))
						{
							TRACE(_T("连接成功!\n"));
							if (m_pRecordset->adoEOF) 	
							{  
							//	m_pRecordset->MoveLast();
	            				m_pRecordset->AddNew();//添加新的记录
								m_pRecordset->PutCollect("Typename",_variant_t(str));
								m_pRecordset->PutCollect("Typedescr",_variant_t(str));
			       				m_pRecordset->Update(); //更新数据库
							}
						}
						m_pRecordset->Close();
					}
			}
			catch(_com_error e)///捕捉异常
				{
					CString errormessage;
					MessageBox("创建记录集失败!","错误");
				}
           //获得表中的类型的id
             try
				{
					HRESULT hTRes;
					hTRes = m_pRecordset.CreateInstance(_T("ADODB.Recordset"));
					if (SUCCEEDED(hTRes))
					{   
						hTRes = m_pRecordset->Open((LPTSTR)SQLStr.GetBuffer(130),
							((CSjsysApp*)AfxGetApp())->pConnection.GetInterfacePtr(),
							adOpenDynamic,adLockPessimistic,adCmdText);//打开查询结果记录集
						if(SUCCEEDED(hTRes))
						{
							TRACE(_T("连接成功!\n"));
							if (!m_pRecordset->adoEOF) 	
							{  
								typeindex=m_pRecordset->GetCollect("ID").lVal;
							}
						}
						m_pRecordset->Close();
					}
			}
			catch(_com_error e)///捕捉异常
				{
					CString errormessage;
					MessageBox("创建记录集失败!","错误");
				}

              SQLStr="select * from Ftpfilter";
			  try
			  {
				HRESULT hTRes;
				hTRes = m_pRecordset.CreateInstance(_T("ADODB.Recordset"));
		    	if (SUCCEEDED(hTRes))
				{  
					hTRes = m_pRecordset->Open((LPTSTR)SQLStr.GetBuffer(130),
						             	((CSjsysApp*)AfxGetApp())->pConnection.GetInterfacePtr(),
										adOpenDynamic,adLockPessimistic,adCmdText);//打开查询结果记录集
					m_pRecordset->AddNew();//添加新的记录
					m_pRecordset->PutCollect("Deviceid",_variant_t(m_strdeviceid));
					CString s;
					s.Format("%d",typeindex);
					m_pRecordset->PutCollect("Filetypeid",_variant_t(s));
  			        m_pRecordset->PutCollect("Action",_variant_t("0"));
			       	m_pRecordset->Update(); //更新数据库
					}
				}
				catch(_com_error e)///捕捉异常
				{
					CString errormessage;
					MessageBox("创建记录集失败!","错误");
					}
				m_pRecordset->Close();  */ 
		  }
	   }
	   break;
   case 4:
	   m_flagstate[7]=m_radioflag2;
	   if(m_radioflag2==1)
	   {
		   m_port[0].RemoveAll();
		   m_port[1].RemoveAll();
		   CString str2;
		   n=m_list33.GetItemCount();
		   if(n==0)
			   break;
		   for(i=0;i<n;i++)
		   {
			  str=m_list33.GetItemText(i,0);
			  str2=m_list33.GetItemText(i,1);
			  if(str=="")
				  continue;
			  m_port[0].Add(str);
			  if(str2=="")
				  continue;
			  m_port[1].Add(str2);
            /*  SQLStr="select * from Portfilter";
			  try
			  {
				HRESULT hTRes;
				hTRes = m_pRecordset.CreateInstance(_T("ADODB.Recordset"));
		    	if (SUCCEEDED(hTRes))
				{  
					hTRes = m_pRecordset->Open((LPTSTR)SQLStr.GetBuffer(130),
						             	((CSjsysApp*)AfxGetApp())->pConnection.GetInterfacePtr(),
										adOpenDynamic,adLockPessimistic,adCmdText);//打开查询结果记录集
					m_pRecordset->AddNew();//添加新的记录
					m_pRecordset->PutCollect("Deviceid",_variant_t(m_strdeviceid));
				//	CString s;
				//	s.Format("%d",str);
					m_pRecordset->PutCollect("Startport",_variant_t(str));
					m_pRecordset->PutCollect("Endport",_variant_t(str));
  			        m_pRecordset->PutCollect("Action",_variant_t("1"));
			       	m_pRecordset->Update(); //更新数据库
					}
				}
				catch(_com_error e)///捕捉异常
				{
					CString errormessage;
					MessageBox("创建记录集失败!","错误");
					}
				m_pRecordset->Close();   */
		  }
	   }
	   if(m_radioflag2==2)
	   {
		   m_port[2].RemoveAll();
		   m_port[3].RemoveAll();
		   CString str2;
		   n=m_list44.GetItemCount();
		   if(n==0)
			   break;
		   for(i=0;i<n;i++)
		   {
			  str=m_list44.GetItemText(i,0);
			  str2=m_list44.GetItemText(i,1);
			  if(str=="")
				  continue;
			  m_port[2].Add(str);
			  if(str2=="")
				  continue;
			  m_port[3].Add(str2);
             /* SQLStr="select * from Portfilter";
			  try
			  {
				HRESULT hTRes;
				hTRes = m_pRecordset.CreateInstance(_T("ADODB.Recordset"));
		    	if (SUCCEEDED(hTRes))
				{  
					hTRes = m_pRecordset->Open((LPTSTR)SQLStr.GetBuffer(130),
						             	((CSjsysApp*)AfxGetApp())->pConnection.GetInterfacePtr(),
										adOpenDynamic,adLockPessimistic,adCmdText);//打开查询结果记录集
					m_pRecordset->AddNew();//添加新的记录
					m_pRecordset->PutCollect("Deviceid",_variant_t(m_strdeviceid));
					CString s;
					s.Format("%d",str);
					m_pRecordset->PutCollect("Startport",_variant_t(s));
					m_pRecordset->PutCollect("Endport",_variant_t(s));
  			        m_pRecordset->PutCollect("Action",_variant_t("0"));
			       	m_pRecordset->Update(); //更新数据库
					}
				}
				catch(_com_error e)///捕捉异常
				{
					CString errormessage;
					MessageBox("创建记录集失败!","错误");
					}
				m_pRecordset->Close();   */
		  }
	   }
	   break;
   case 5:
	   m_flagstate[9]=m_radioflag2;
	   if(m_radioflag2==1)
	   {
		  // m_service[0].RemoveAll();
		   n=m_list11.GetItemCount();
		   if(n==0)
			   break;
		   for(i=0;i<n;i++)
		   {
			  if( m_list11.GetItemState(i, LVIS_SELECTED) == LVIS_SELECTED || m_list11.GetCheck(i)) 
				{ 
				  servicestate[i]=1;
				//	str=m_list11.GetItemText(i,0);
				//	m_service[0].Add(str);
				} 
			/*   SQLStr.Format("select * from Servtype where Name='%s'",str);
			try
				{
					HRESULT hTRes;
					hTRes = m_pRecordset.CreateInstance(_T("ADODB.Recordset"));
					if (SUCCEEDED(hTRes))
					{   
						hTRes = m_pRecordset->Open((LPTSTR)SQLStr.GetBuffer(130),
							((CSjsysApp*)AfxGetApp())->pConnection.GetInterfacePtr(),
							adOpenDynamic,adLockPessimistic,adCmdText);//
上一页 1 2 3 45
💿 文件大小 820 K
👤 上传用户 fpeisheng
📂 所属分类数据库系统
🏷️ 相关标签

#Visual #6.0 #程序 #编写
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -