⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 material_misview.cpp

📁 支持ACCESS数据库的数据的查询、打印、统计等
💻 CPP
📖 第 1 页 / 共 5 页
字号:
🔍
12345 
	    m_ListCtrl.SetItemText(i, 5, str);	
		mi[i]=str;
		
        Holder = theApp.m_pADOSet->GetCollect("内色");
	    str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
	    m_ListCtrl.SetItemText(i, 6, str);		
		neis[i]=str;
		

        Holder = theApp.m_pADOSet->GetCollect("外色");
	    str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
	    m_ListCtrl.SetItemText(i, 7, str);	
		wais[i]=str;
		

        Holder = theApp.m_pADOSet->GetCollect("记录时间");
	    str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
	    m_ListCtrl.SetItemText(i, 8, str);		
		dd[i]=str;
		theApp.m_pADOSet->MoveNext();

	}
	flag=1;
}


//summary pi
void CMaterial_MISView::OnMenuitemPi() 
{
	// TODO: Add your command handler code here
	// TODO: Add your command handler code here

   // Drcx();	
	
	Cdate my;
	//COleDateTime tt1;
    

	int result=my.DoModal();
	if(result==IDOK)
	{
	 m_t1=my.m_text1;
     m_t2=my.m_text2;
	 // 创建ADO连接对象
 	 if( FAILED(::CoInitialize(NULL)) ) 
	 {
 	     AfxMessageBox("ADO Init failed");
    		return;
	 }
 	 try
	 {
   		theApp.ADOConn.CreateInstance(__uuidof(Connection));
 			theApp.ADOConn->Open("DSN=in;","","", adConnectUnspecified);
	 }
 	 // 捕捉例外
 	 catch(_com_error &e)
	 {
 		CString err;
 		err.Format("%s", (char*)(e.Description()) );
		AfxMessageBox(err);
	 }
 	 catch(...)
	 {
 		AfxMessageBox("Unknown Error...");
	 }
 	
 	 // 初始化ADO记录集
 	 theApp.m_pADOSet.CreateInstance(__uuidof(Recordset));

 
     m_ListCtrl.DestroyWindow();

	 Dpi();
	 
	 if( adStateOpen == theApp.ADOConn->State )	theApp.ADOConn->Close();
	  theApp.ADOConn.Release();
    
	 // 释放ADO记录集
	 if(adStateOpen==theApp.m_pADOSet->State)	theApp.m_pADOSet->Close();
    	theApp.m_pADOSet.Release();
	 return;
	}
	else 
		return;		
}

void CMaterial_MISView::OnMENUITEMpipo() 
{
	// TODO: Add your command handler code here
	// TODO: Add your command handler code here
	Cdate my;
	//COleDateTime tt1;
    

	int result=my.DoModal();
	if(result==IDOK)
	{
	 m_t1=my.m_text1;
     m_t2=my.m_text2;
	 //PAINT IN table X13
	 // 创建ADO连接对象
 	 

 
     m_ListCtrl.DestroyWindow();

	 pir();
     piw();

	 //PAINT OUT TABLE X11

     
	 por();
	 pow();
	 Dpipo();
	 
	 	 return;
	}
	else 
		return;		
}

void CMaterial_MISView::OnMenuitemPo() 
{
	// TODO: Add your command handler code here
  //  Drcx();	
	
	Cdate my;
	//COleDateTime tt1;
    

	int result=my.DoModal();
	if(result==IDOK)
	{
	 m_t1=my.m_text1;
     m_t2=my.m_text2;
	 // 创建ADO连接对象
 	 if( FAILED(::CoInitialize(NULL)) ) 
	 {
 	     AfxMessageBox("ADO Init failed");
    		return;
	 }
 	 try
	 {
   		theApp.ADOConn.CreateInstance(__uuidof(Connection));
 			theApp.ADOConn->Open("DSN=out;","","", adConnectUnspecified);
	 }
 	 // 捕捉例外
 	 catch(_com_error &e)
	 {
 		CString err;
 		err.Format("%s", (char*)(e.Description()) );
		AfxMessageBox(err);
	 }
 	 catch(...)
	 {
 		AfxMessageBox("Unknown Error...");
	 }
 	
 	 // 初始化ADO记录集
 	 theApp.m_pADOSet.CreateInstance(__uuidof(Recordset));

 
     m_ListCtrl.DestroyWindow();

	 Dpo();
	 
	 if( adStateOpen == theApp.ADOConn->State )	theApp.ADOConn->Close();
	  theApp.ADOConn.Release();
    
	 // 释放ADO记录集
	 if(adStateOpen==theApp.m_pADOSet->State)	theApp.m_pADOSet->Close();
    	theApp.m_pADOSet.Release();
	 return;
	}
	else 
		return;		
}

void CMaterial_MISView::OnMenuitemPopbs() 
{
	// TODO: Add your command handler code here
	Cdate my;
	//COleDateTime tt1;
    

	int result=my.DoModal();
	if(result==IDOK)
	{
	 m_t1=my.m_text1;
     m_t2=my.m_text2;
	 //PAINT IN table X13
	 // 创建ADO连接对象
 	 

 
     m_ListCtrl.DestroyWindow();

	 por1();
     pow1();

	 //PAINT OUT TABLE X11

     
	 pbr();
	 pbw();
	 Dpopb();
	 
	 	 return;
	}
	else 
		return;			
}

void CMaterial_MISView::OnMenuitemPbs() 
{
	// TODO: Add your command handler code here
	Cdate my;
	//COleDateTime tt1;
    

	int result=my.DoModal();
	if(result==IDOK)
	{
	 m_t1=my.m_text1;
     m_t2=my.m_text2;
	 // 创建ADO连接对象
 	 if( FAILED(::CoInitialize(NULL)) ) 
	 {
 	     AfxMessageBox("ADO Init failed");
    		return;
	 }
 	 try
	 {
   		theApp.ADOConn.CreateInstance(__uuidof(Connection));
 			theApp.ADOConn->Open("DSN=pbs;","","", adConnectUnspecified);
	 }
 	 // 捕捉例外
 	 catch(_com_error &e)
	 {
 		CString err;
 		err.Format("%s", (char*)(e.Description()) );
		AfxMessageBox(err);
	 }
 	 catch(...)
	 {
 		AfxMessageBox("Unknown Error...");
	 }
 	
 	 // 初始化ADO记录集
 	 theApp.m_pADOSet.CreateInstance(__uuidof(Recordset));

 
     m_ListCtrl.DestroyWindow();

	 Dpbs();
	 
	 if( adStateOpen == theApp.ADOConn->State )	theApp.ADOConn->Close();
	  theApp.ADOConn.Release();
    
	 // 释放ADO记录集
	 if(adStateOpen==theApp.m_pADOSet->State)	theApp.m_pADOSet->Close();
    	theApp.m_pADOSet.Release();
	 return;
	}
	else 
		return;		
}
//PBS table x12
void CMaterial_MISView::OnMenuPbs() 
{
	// TODO: Add your command handler code here
	//add ado 20050623
	Cdate my;
	//COleDateTime tt1;
    

	int result=my.DoModal();
	if(result==IDOK)
	{
	 m_t1=my.m_text1;
     m_t2=my.m_text2;
	 // 创建ADO连接对象
 	 if( FAILED(::CoInitialize(NULL)) ) 
	 {
 	     AfxMessageBox("ADO Init failed");
    		return;
	 }
 	 try
	 {
   		theApp.ADOConn.CreateInstance(__uuidof(Connection));
 			theApp.ADOConn->Open("DSN=pbs;","","", adConnectUnspecified);
	 }
 	 // 捕捉例外
 	 catch(_com_error &e)
	 {
 		CString err;
 		err.Format("%s", (char*)(e.Description()) );
		AfxMessageBox(err);
	 }
 	 catch(...)
	 {
 		AfxMessageBox("Unknown Error...");
	 }
 	
 	 // 初始化ADO记录集
 	 theApp.m_pADOSet.CreateInstance(__uuidof(Recordset));

 
     m_ListCtrl.DestroyWindow();

	 CreateMaterialInfodpbs();
	 
	 if( adStateOpen == theApp.ADOConn->State )	theApp.ADOConn->Close();
	  theApp.ADOConn.Release();
    
	 // 释放ADO记录集
	 if(adStateOpen==theApp.m_pADOSet->State)	theApp.m_pADOSet->Close();
    	theApp.m_pADOSet.Release();
	 return;
	}
	else 
		return;	
}

void CMaterial_MISView::OnMENUpio() 
{
	// TODO: Add your command handler code here
	Cdate my;
	//COleDateTime tt1;
    

	int result=my.DoModal();
	if(result==IDOK)
	{
	 m_t1=my.m_text1;
     m_t2=my.m_text2;
	 //PAINT IN table X13
	 // 创建ADO连接对象
 	 

 
     m_ListCtrl.DestroyWindow();

	 pir();
     piw();

	 //PAINT OUT TABLE X11

     
	 por();
	 pow();
	 tj();
	 
	 	 return;
	}
	else 
		return;	
}

void CMaterial_MISView::OnMENUpopbs() 
{
	// TODO: Add your command handler code here
	Cdate my;
	//COleDateTime tt1;
    

	int result=my.DoModal();
	if(result==IDOK)
	{
	 m_t1=my.m_text1;
     m_t2=my.m_text2;
	 //PAINT IN table X13
	 // 创建ADO连接对象
 	 

 
     m_ListCtrl.DestroyWindow();

	 por1();
     pow1();

	 //PAINT OUT TABLE X11

     
	 pbr();
	 pbw();
	 tj1();
	 
	 	 return;
	}
	else 
		return;		
}

void CMaterial_MISView::CreateMaterialInfodpbs()
{


	// 获得所有记录
	_variant_t Holder, strQuery;
    CString sty,stm,std,sth,stmm,sts,ety,etm,etd,eth,etmm,ets,t3;
	sty.Format("%2d",m_t1.GetYear());
	stm.Format("%d",m_t1.GetMonth());
	std.Format("%d",m_t1.GetDay());

	sth.Format("%d",m_t1.GetHour());
	stmm.Format("%d",m_t1.GetMinute());
	sts.Format("%d",m_t1.GetSecond());
	
	ety.Format("%d",m_t2.GetYear());
	etm.Format("%d",m_t2.GetMonth());
	etd.Format("%d",m_t2.GetDay());
	eth.Format("%d",m_t2.GetHour());
	etmm.Format("%d",m_t2.GetMinute());
	ets.Format("%d",m_t2.GetSecond());
 
    strQuery = "select * from x12 where 记录时间> ctot('"+stm+"'+'/'+'"+std+"'+'/'+'"+sty+"'+' "+sth+"'+':'+'"+stmm+"'+':'+'"+sts+"')	and 记录时间 <= ctot('"+etm+"'+'/'+'"+etd+"'+'/'+'"+ety+"'+' "+eth+"'+':'+'"+etmm+"'+':'+'"+ets+"') order by 记录时间 desc";
	theApp.ADOExecute(theApp.m_pADOSet, strQuery);

    int iCount = theApp.m_pADOSet->GetRecordCount();
	CString zs;
	zs.Format("PBS Detail结果: %d条 时间段为 %s-%s-%s %s:%s:%s --- %s-%s-%s %s:%s:%s",iCount,
		sty,stm,std,sth,stmm,sts,ety,etm,etd,eth,etmm,ets);
	m_sCurrentList = _T(zs);
    m_StaticCtrl.SetWindowText(m_sCurrentList);
	
	CRect rect;
	GetClientRect(rect);
	rect.top += 30;

	m_ListCtrl.Create(WS_CHILD|WS_VISIBLE|WS_BORDER|LVS_REPORT, rect, this, 1);

	m_ListCtrl.SetBkColor(RGB(177, 151, 240));
	m_ListCtrl.SetTextColor(RGB(0,0,0));
	m_ListCtrl.SetTextBkColor(RGB(177, 151, 240));
	
	// Set EX-Style
	m_ListCtrl.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES|LVS_EX_HEADERDRAGDROP);

	// 创建标题
	m_ListCtrl.InsertColumn(0,_T("No."), LVCFMT_LEFT, 50);
	m_ListCtrl.InsertColumn(1,_T("车型车身号"), LVCFMT_LEFT, 100);
	m_ListCtrl.InsertColumn(2,_T("W_order"), LVCFMT_LEFT, 120);
	m_ListCtrl.InsertColumn(3,_T("Spec_order"), LVCFMT_LEFT, 120);
	m_ListCtrl.InsertColumn(4,_T("内色"), LVCFMT_LEFT, 80);
	m_ListCtrl.InsertColumn(5,_T("外色"), LVCFMT_LEFT, 80);
	m_ListCtrl.InsertColumn(6,_T("时间"), LVCFMT_LEFT, 120);
    tt=iCount ;
	if ( 0==iCount ) return;
	//	return;	

    CString str;
	theApp.m_pADOSet->MoveFirst();
	for(int i=0; i<iCount; i++)
	{
		str.Format("%d",i+1);
		m_ListCtrl.InsertItem(i, str);
		
	    
        Holder = theApp.m_pADOSet->GetCollect("车型车身号");
	    str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
	    m_ListCtrl.SetItemText(i, 1, str);
		chex[i]=str;
	 
        Holder = theApp.m_pADOSet->GetCollect("W_order");
	    str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
	    m_ListCtrl.SetItemText(i, 2, str);
		
		wo[i]=str;
12345

⌨️ 快捷键说明

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