📄 material_misview.cpp
字号:
_variant_t strQuery, Holder;
strQuery = "select ProductName from ProductInfo";
theApp.ADOExecute(theApp.m_pADOSet, strQuery);
int iCount = theApp.m_pADOSet->GetRecordCount();
if ( 0==iCount )
{
AfxMessageBox(_T("目前没有记录！"), MB_ICONEXCLAMATION);
return;
}
CCheckBasicInfoDLG dlg;
dlg.DoModal();
}
void CMaterial_MISView::OnMenuSearchininfo()
{
// TODO: Add your command handler code here
CSearch dlg;
dlg.m_sType=true;
_variant_t strQuery;
strQuery="select * from ProductStock";
theApp.ADOExecute(theApp.m_pADOSet,strQuery);
int icount=theApp.m_pADOSet->GetRecordCount();
if(0==icount)
{
AfxMessageBox(_T("目前没有入库信息！"), MB_ICONEXCLAMATION);
return;
}
dlg.DoModal();
}
void CMaterial_MISView::OnMenuSearchoutinfo()
{
// TODO: Add your command handler code here
CSearch dlg;
dlg.m_sType=false;
_variant_t strQuery;
theApp.inorout=_T("out");
strQuery="select * from ProductStock";
theApp.ADOExecute(theApp.m_pADOSet,strQuery);
int icount=theApp.m_pADOSet->GetRecordCount();
if(0==icount)
{
AfxMessageBox(_T("目前没有出库信息！"), MB_ICONEXCLAMATION);
return;
}
dlg.DoModal();
}
void CMaterial_MISView::OnMenuSearchsurplus()
{
// TODO: Add your command handler code here
_variant_t strQuery,strQueryTemp,Holder;
strQueryTemp = "select * from UserInfo where UserID='"+theApp.m_sCurrentUser+"'";
theApp.ADOExecute(theApp.m_pADOSet, strQueryTemp);
Holder = theApp.m_pADOSet->GetCollect("ReadRight");
CString m_oo = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
if(m_oo==_T("off")) {
AfxMessageBox("对不起,您没有权限查看库存信息！",MB_ICONEXCLAMATION);
return;
}
else
{
m_ListCtrl.DestroyWindow();
strQuery = "select * from ProductRemain";
CreateSurplusInfo(strQuery);
m_sCurrentList = _T("产品余额列表");
m_StaticCtrl.SetWindowText(m_sCurrentList);
CSearchplusInfo dlg;
dlg.DoModal();
return;
}
}
void CMaterial_MISView::RefreshMaterial()
{
if (m_ListCtrl) m_ListCtrl.DestroyWindow();
CreateMaterialInfo();
m_sCurrentList = _T("产品列表");
m_StaticCtrl.SetWindowText(m_sCurrentList);
}
void CMaterial_MISView::CreateMaterialInfo()
{
m_sCurrentList = _T("产品列表");
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("图纸编号"), LVCFMT_LEFT, 100);
m_ListCtrl.InsertColumn(1,_T("版本号 "), LVCFMT_LEFT, 100);
m_ListCtrl.InsertColumn(2,_T("产品名称"), LVCFMT_LEFT, 100);
m_ListCtrl.InsertColumn(3,_T("材料代号"), LVCFMT_LEFT, 100);
m_ListCtrl.InsertColumn(4,_T("安全库存"), LVCFMT_LEFT, 100);
m_ListCtrl.InsertColumn(5,_T("计量单位"), LVCFMT_LEFT, 100);
m_ListCtrl.InsertColumn(6,_T("创建时间"), LVCFMT_LEFT, 100);
m_ListCtrl.InsertColumn(7,_T("创建者 "), LVCFMT_LEFT, 100);
m_ListCtrl.InsertColumn(8,_T("序列号 "), LVCFMT_LEFT, 100);
// 获得所有记录
_variant_t Holder, strQuery;
strQuery = "select * from ProductInfo order by MapID";
theApp.ADOExecute(theApp.m_pADOSet, strQuery);
int iCount = theApp.m_pADOSet->GetRecordCount();
if ( 0==iCount ) return;
CString str;
theApp.m_pADOSet->MoveFirst();
for(int i=0; i<iCount; i++)
{
// 获得MapID
Holder = theApp.m_pADOSet->GetCollect("MapID");
str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
m_ListCtrl.InsertItem(i, str);
// 获得Version
Holder = theApp.m_pADOSet->GetCollect("Version");
str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
m_ListCtrl.SetItemText(i, 1, str);
// 获得ProductName
Holder = theApp.m_pADOSet->GetCollect("ProductName");
str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
m_ListCtrl.SetItemText(i, 2, str);
// 获得MaterialID
Holder = theApp.m_pADOSet->GetCollect("MaterialID");
str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
m_ListCtrl.SetItemText(i, 3, str);
// 获得SafeStockNum
Holder = theApp.m_pADOSet->GetCollect("SafeStockNum");
str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
m_ListCtrl.SetItemText(i, 4, str);
//获得Unit
Holder = theApp.m_pADOSet->GetCollect("Unit");
str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
m_ListCtrl.SetItemText(i, 5, str);
// 获得CDate
Holder = theApp.m_pADOSet->GetCollect("CDate");
str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
m_ListCtrl.SetItemText(i, 6, str);
// 获得Creater
Holder = theApp.m_pADOSet->GetCollect("Creater");
str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
m_ListCtrl.SetItemText(i, 7, str);
Holder = theApp.m_pADOSet->GetCollect("SN");
str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
m_ListCtrl.SetItemText(i, 8, str);
theApp.m_pADOSet->MoveNext();
}
}
void CMaterial_MISView::LoadListCtrl()
{
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));
m_ListCtrl.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES|LVS_EX_HEADERDRAGDROP);
m_ListCtrl.InsertColumn(0,"Node ID", LVCFMT_LEFT, 250);
m_ListCtrl.InsertColumn(1,"2 ID", LVCFMT_LEFT, 250);
CString str;
for (int i=0; i<100; i++)
{
str.Format("%d", i);
m_ListCtrl.InsertItem(i, str);
}
}
void CMaterial_MISView::UnLoadListCtrl()
{
m_ListCtrl.DestroyWindow();
}
void CMaterial_MISView::OnContextMenu(CWnd* pWnd, CPoint point)
{
// TODO: Add your message handler code here
if ( ""==m_sCurrentList ) return;
CMenu menu;
if ( _T("产品列表")==m_sCurrentList ) menu.LoadMenu(IDR_MENU_BASICINFO);
else if ( _T("产品入库列表")==m_sCurrentList ) menu.LoadMenu(IDR_MENU_IN);
else if ( _T("产品出库列表")==m_sCurrentList ) menu.LoadMenu(IDR_MENU_OUT);
// ... Add by jackie ...
else
return;
CMenu* pMenu=menu.GetSubMenu(0);
pMenu->TrackPopupMenu(TPM_LEFTALIGN|TPM_LEFTBUTTON|TPM_RIGHTBUTTON,point.x,point.y,this);
return;
}
void CMaterial_MISView::OnInitialUpdate()
{
CView::OnInitialUpdate();
// TODO: Add your specialized code here and/or call the base class
// ... Modified by jackie ...
CRect rect;
GetClientRect(&rect);
m_StaticCtrl.Create(m_sCurrentList, WS_VISIBLE|SS_CENTER, rect, this, 1);
// Initializes a CFont object with the specified characteristics.
VERIFY(font.CreateFont(
15, // nHeight
8, // nWidth
0, // nEscapement
0, // nOrientation
FW_NORMAL, // nWeight
FALSE, // bItalic
FALSE, // bUnderline
0, // cStrikeOut
ANSI_CHARSET, // nCharSet
OUT_DEFAULT_PRECIS, // nOutPrecision
CLIP_DEFAULT_PRECIS, // nClipPrecision
DEFAULT_QUALITY, // nQuality
DEFAULT_PITCH | FF_SWISS, // nPitchAndFamily
"宋体")); // lpszFacename
}
void CMaterial_MISView::RefreshMaterialWindow(_variant_t strQuery)
{
if (m_ListCtrl) m_ListCtrl.DestroyWindow();
CreateMaterialWindow( strQuery );
m_sCurrentList = _T("产品列表");
m_StaticCtrl.SetWindowText(m_sCurrentList);
}
void CMaterial_MISView::CreateMaterialWindow(_variant_t strQuery)
{
m_sCurrentList = _T("产品列表");
m_StaticCtrl.SetWindowText(m_sCurrentList);
// Get Client Rect
CRect rect;
GetClientRect(rect);
rect.top += 30;
// Create
m_ListCtrl.Create(WS_CHILD|WS_VISIBLE|WS_BORDER|LVS_REPORT, rect, this, 1);
// Set Color
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);
// Create Header
m_ListCtrl.InsertColumn(0,_T("图纸编号"), LVCFMT_LEFT, 100);
m_ListCtrl.InsertColumn(1,_T("版本号"), LVCFMT_LEFT, 100);
m_ListCtrl.InsertColumn(2,_T("产品名称"), LVCFMT_LEFT, 100);
m_ListCtrl.InsertColumn(3,_T("材料代号"), LVCFMT_LEFT, 100);
m_ListCtrl.InsertColumn(4,_T("安全库存"), LVCFMT_LEFT, 100);
m_ListCtrl.InsertColumn(5,_T("计量单位"), LVCFMT_LEFT, 100);
m_ListCtrl.InsertColumn(6,_T("创建时间"), LVCFMT_LEFT, 100);
m_ListCtrl.InsertColumn(7,_T("创建者"), LVCFMT_LEFT, 100);
// 获得记录集
_variant_t Holder;
theApp.ADOExecute(theApp.m_pADOSet, strQuery);
int iCount = theApp.m_pADOSet->GetRecordCount();
if ( 0==iCount ) return;
CString str;
theApp.m_pADOSet->MoveFirst();
for(int i=0; i<iCount; i++)
{
// 获得MapID
Holder = theApp.m_pADOSet->GetCollect("MapID");
str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
m_ListCtrl.InsertItem(i, str);
// 获得Version
Holder = theApp.m_pADOSet->GetCollect("Version");
str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
m_ListCtrl.SetItemText(i, 1, str);
// 获得ProductName
Holder = theApp.m_pADOSet->GetCollect("ProductName");
str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
m_ListCtrl.SetItemText(i, 2, str);
// 获得MaterialID
Holder = theApp.m_pADOSet->GetCollect("MaterialID");
str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
m_ListCtrl.SetItemText(i, 3, str);
// 获得SafeStockNum
Holder = theApp.m_pADOSet->GetCollect("SafeStockNum");
str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
m_ListCtrl.SetItemText(i, 4, str);
//获得Unit
Holder = theApp.m_pADOSet->GetCollect("Unit");
str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
m_ListCtrl.SetItemText(i, 5, str);
// 获得CDate
Holder = theApp.m_pADOSet->GetCollect("CDate");
str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
m_ListCtrl.SetItemText(i, 6, str);
// 获得Creater
Holder = theApp.m_pADOSet->GetCollect("Creater");
str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
m_ListCtrl.SetItemText(i, 7, str);
theApp.m_pADOSet->MoveNext();
}
}
void CMaterial_MISView::CreateIn(_variant_t strQuery)
{
// Get Client Rect
CRect rect;
GetClientRect(rect);
rect.top += 30;
// Create
m_ListCtrl.Create(WS_CHILD|WS_VISIBLE|WS_BORDER|LVS_REPORT, rect, this, 1);
// Set Color
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);
// Create Header
m_ListCtrl.InsertColumn(0,_T("图纸编号"), LVCFMT_LEFT,100);
m_ListCtrl.InsertColumn(1,_T("版本号 "), LVCFMT_LEFT, 100);
m_ListCtrl.InsertColumn(2,_T("产品名称"), LVCFMT_LEFT, 100);
m_ListCtrl.InsertColumn(3,_T("入库数量"), LVCFMT_LEFT, 100);
m_ListCtrl.InsertColumn(4,_T("计量单位"), LVCFMT_LEFT, 100);
m_ListCtrl.InsertColumn(5,_T("入库时间"), LVCFMT_LEFT, 100);
m_ListCtrl.InsertColumn(6,_T("经办人 "), LVCFMT_LEFT, 100);
m_ListCtrl.InsertColumn(7,_T("备 注"), LVCFMT_LEFT, 100);
m_ListCtrl.InsertColumn(8,_T("记录号 "), LVCFMT_LEFT, 100);
// Get all records
_variant_t Holder;
theApp.ADOExecute(theApp.m_pADOSet, strQuery);
int iCount = theApp.m_pADOSet->GetRecordCount();
if ( 0==iCount ) return;
CString str;
COleDateTime time;
theApp.m_pADOSet->MoveFirst();
for(int i=0; i<iCount; i++)
{
Holder = theApp.m_pADOSet->GetCollect("MapID");
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -