📄 material_misview.cpp
字号:
Holder = theApp.m_pADOSet->GetCollect("Spec_order");
str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
m_ListCtrl.SetItemText(i, 3, str);
mi[i]=str;
Holder = theApp.m_pADOSet->GetCollect("内色");
str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
m_ListCtrl.SetItemText(i, 4, str);
neis[i]=str;
Holder = theApp.m_pADOSet->GetCollect("外色");
str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
m_ListCtrl.SetItemText(i, 5, str);
wais[i]=str;
Holder = theApp.m_pADOSet->GetCollect("记录时间");
str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
m_ListCtrl.SetItemText(i, 6, str);
dd[i]=str;
theApp.m_pADOSet->MoveNext();
}
flag=3;
}
void CMaterial_MISView::pir()
{
// 创建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));
// 获得所有记录
_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 x13 where Pipo='PI' 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();
tt=iCount;
if ( 0==iCount ) return;
// return;
/* 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("Seq");
str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
seq[i]=str;
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::por()
{
// 创建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;
// 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;
chex1[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::pow()
{
// 创建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 out1";
theApp.ADOExecute(theApp.m_pADOSet, strQuery);
_variant_t strQuery2;
for(int i=0; i<tt; i++)
{
strQuery2 = "insert into out1 (t2) 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::piw()
{
// 创建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 in1";
theApp.ADOExecute(theApp.m_pADOSet, strQuery);
_variant_t strQuery2;
for(int i=0; i<tt; i++)
{
strQuery2 = "insert into in1(t1,t2, t3, t4, t5, t6,t7) values ('"+seq[i]+"','" +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::tj()
{
// 创建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 Holder, strQuery;
strQuery = "select * from in1 where t2<>all(select t2 from out1) ";
theApp.ADOExecute(theApp.m_pADOSet, strQuery);
int iCount = theApp.m_pADOSet->GetRecordCount();
CString zs;
zs.Format("Pin - Pout 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("SEQ"), LVCFMT_LEFT, 50);
m_ListCtrl.InsertColumn(2,_T("车型车身号"), LVCFMT_LEFT, 100);
m_ListCtrl.InsertColumn(3,_T("W_order"), LVCFMT_LEFT, 120);
m_ListCtrl.InsertColumn(4,_T("Mi"), LVCFMT_LEFT, 120);
m_ListCtrl.InsertColumn(5,_T("内色"), LVCFMT_LEFT, 80);
m_ListCtrl.InsertColumn(6,_T("外色"), LVCFMT_LEFT, 80);
m_ListCtrl.InsertColumn(7,_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);
seq[i]=str;
Holder = theApp.m_pADOSet->GetCollect("t2");
str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
m_ListCtrl.SetItemText(i, 2, str);
chex[i]=str;
Holder = theApp.m_pADOSet->GetCollect("t3");
str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
m_ListCtrl.SetItemText(i, 3, str);
wo[i]=str;
Holder = theApp.m_pADOSet->GetCollect("t4");
str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
m_ListCtrl.SetItemText(i, 4, str);
mi[i]=str;
Holder = theApp.m_pADOSet->GetCollect("t5");
str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
m_ListCtrl.SetItemText(i, 5, str);
neis[i]=str;
Holder = theApp.m_pADOSet->GetCollect("t6");
str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
m_ListCtrl.SetItemText(i, 6, str);
wais[i]=str;
Holder = theApp.m_pADOSet->GetCollect("t7");
str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
m_ListCtrl.SetItemText(i, 7, str);
dd[i]=str;
theApp.m_pADOSet->MoveNext();
}
flag=4;
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::tj1()
{
if( FAILED(::CoInitialize(NULL)) )
{
AfxMessageBox("ADO Init failed");
return;
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -