📄 material_misview.cpp

📁 支持ACCESS数据库的数据的查询、打印、统计等
💻 CPP
📖 第 1 页 / 共 5 页
字号:
上一页 1 2 3 45
 	 try
	 {
   		theApp.ADOConn.CreateInstance(__uuidof(Connection));
 			theApp.ADOConn->Open("DSN=user;","","", 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));
	


	// 获得所有记录
	_variant_t Holder, strQuery;

 
    strQuery = "select * from out2 where t1<>all(select t1 from pbs) ";
	theApp.ADOExecute(theApp.m_pADOSet, strQuery);

    int iCount = theApp.m_pADOSet->GetRecordCount();
    CString zs;
	zs.Format("Pout - PBS Detail 结果: %d条 时间段为 %d-%d-%d %d:%d:%d --- %d-%d-%d %d:%d:%d",
		iCount,m_t1.GetYear(),m_t1.GetMonth(),m_t1.GetDay(),m_t1.GetHour(),m_t1.GetMinute(),
		m_t1.GetSecond(),m_t2.GetYear(),m_t2.GetMonth(),m_t2.GetDay(),m_t2.GetHour(),m_t2.GetMinute(),
		m_t2.GetSecond());
	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("Mi"), 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("t1");
	    str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
	   // m_ListCtrl.InsertItem(i,1, str);
		m_ListCtrl.SetItemText(i,1, str);
		chex[i]=str;
	    
        Holder = theApp.m_pADOSet->GetCollect("t2");
	    str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
	    m_ListCtrl.SetItemText(i, 2, str);
		wo[i]=str;
		
        Holder = theApp.m_pADOSet->GetCollect("t3");
		str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
	    m_ListCtrl.SetItemText(i, 3, str);
		mi[i]=str;
		
        Holder = theApp.m_pADOSet->GetCollect("t4");
	    str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
	    m_ListCtrl.SetItemText(i, 4, str);
		neis[i]=str;
		
        Holder = theApp.m_pADOSet->GetCollect("t5");
	    str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
	    m_ListCtrl.SetItemText(i, 5, str);	
		wais[i]=str;
		
        Holder = theApp.m_pADOSet->GetCollect("t6");
	    str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
	    m_ListCtrl.SetItemText(i, 6, str);		
		dd[i]=str;
	
		theApp.m_pADOSet->MoveNext();

	}
    flag=5;



	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();
}
//PAINT OUT TABLE X11
void CMaterial_MISView::por1()
{
	 // 创建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));

	// 获得所有记录
	_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());
    tt=0;
    strQuery = "select * from x11 where Pipo='PO' and 记录时间> 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();
	if ( 0==iCount ) return;
	//	return;	

    tt=iCount;
/*	seq=new CString[iCount];
    chex=new CString[iCount];
	wo=new CString[iCount];
	mi=new CString[iCount];
	neis=new CString[iCount];
	wais=new CString[iCount];
	dd=new CString[iCount];*/
    CString str;
	theApp.m_pADOSet->MoveFirst();
	for(int i=0; i<iCount; i++)
	{
	
		
        Holder = theApp.m_pADOSet->GetCollect("车型车身号");
	    str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
	    chex[i]=str;

		
        Holder = theApp.m_pADOSet->GetCollect("W_order");
	    str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
	    wo[i]=str;

        Holder = theApp.m_pADOSet->GetCollect("Mi");
	    str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
	    mi[i]=str;	
		
        Holder = theApp.m_pADOSet->GetCollect("内色");
	    str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
	    neis[i]=str;

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

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

		theApp.m_pADOSet->MoveNext();

	}
	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();

}

void CMaterial_MISView::pow1()
{
	 // 创建ADO连接对象
 	 if( FAILED(::CoInitialize(NULL)) ) 
	 {
 	     AfxMessageBox("ADO Init failed");
    		return;
	 }
 	 try
	 {
   		theApp.ADOConn.CreateInstance(__uuidof(Connection));
 			theApp.ADOConn->Open("DSN=user;","","", 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));
//写记录
	_variant_t  strQuery;
    strQuery = "delete * from out2";
	theApp.ADOExecute(theApp.m_pADOSet, strQuery);


	_variant_t strQuery2;


	for(int i=0; i<tt; i++)
	{
			strQuery2 = "insert into out2(t1,t2, t3, t4, t5, t6) values ('" +chex[i]+"','"+wo[i]+"','"+mi[i]+"','"\
					+neis[i]+"','"+wais[i]+"','"+dd[i]+"')";
				theApp.ADOExecute(theApp.m_pADOSet,strQuery2);
	}
//	delete []chex;
//	delete []seq;
//	delete []mi;
	//delete []wo;
//	delete []neis;
	//delete []wais;
	//delete []dd;

	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();
}

void CMaterial_MISView::pbr()
{
	 // 创建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));

	// 获得所有记录
	_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();
    tt=iCount;
	if ( 0==iCount ) return;
	//	return;	


	
   // chex1=new CString[iCount];
	
    CString str;
	theApp.m_pADOSet->MoveFirst();
	for(int i=0; i<iCount; i++)
	{
	
	
		
        Holder = theApp.m_pADOSet->GetCollect("车型车身号");
	    str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
	    str.TrimLeft(" ");
		str.TrimRight(" ");
		chex1[i]=str.Right(10);

		theApp.m_pADOSet->MoveNext();

	}
	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();
}

void CMaterial_MISView::pbw()
{
	 // 创建ADO连接对象
 	 if( FAILED(::CoInitialize(NULL)) ) 
	 {
 	     AfxMessageBox("ADO Init failed");
    		return;
	 }
 	 try
	 {
   		theApp.ADOConn.CreateInstance(__uuidof(Connection));
 			theApp.ADOConn->Open("DSN=user;","","", 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));
//写记录

	_variant_t  strQuery;
    strQuery = "delete * from pbs";
	theApp.ADOExecute(theApp.m_pADOSet, strQuery);


	_variant_t strQuery2;


	for(int i=0; i<tt; i++)
	{
			strQuery2 = "insert into pbs (t1) values ('"+chex1[i]+"')";
				theApp.ADOExecute(theApp.m_pADOSet,strQuery2);
	}
	//delete []chex;
	
	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();
}
void CMaterial_MISView::Dpi()
{
	flag=6;
	CString zs;
	zs.Format("Pin Summary 结果 时间段为 %d-%d-%d %d:%d:%d --- %d-%d-%d %d:%d:%d",
		m_t1.GetYear(),m_t1.GetMonth(),m_t1.GetDay(),m_t1.GetHour(),m_t1.GetMinute(),
		m_t1.GetSecond(),m_t2.GetYear(),m_t2.GetMonth(),m_t2.GetDay(),m_t2.GetHour(),m_t2.GetMinute(),
		m_t2.GetSecond());
	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, 50);
	m_ListCtrl.InsertColumn(2,_T("数量"), LVCFMT_LEFT, 60);
    m_ListCtrl.InsertColumn(3,_T("描述"), LVCFMT_LEFT, 60);
	m_ListCtrl.InsertColumn(4,_T("Spec_order"), LVCFMT_LEFT, 120);


	// 获得所有记录
	_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());
	num1=0;
    for (int i=0;i<num;i++)
	{
        strQuery = "select * from x13 where Pipo='PI' and 记录时间> ctot('"+stm+"'+'/'+'"+std+"'+'/'+'"+sty+"'+' "+sth+"'+':'+'"+stmm+"'+':'+
上一页 1 2 3 45
💿 文件大小 517 K
👤 上传用户 lilacky
📂 所属分类企业管理
🏷️ 相关标签

#ACCESS #数据库 #数据 #打印
⌨️ 快捷键说明

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