📄 material_misview.cpp
字号:
CString sAccount;
CString sValue;
CString sBase;
while (pos)
{
iItem = m_ListCtrl.GetNextSelectedItem(pos);
sNO = m_ListCtrl.GetItemText(iItem, 0);
sID = m_ListCtrl.GetItemText(iItem, 1);
sAccount = m_ListCtrl.GetItemText(iItem, 6);
//double sfAccount=atof(sAccount);
sValue = m_ListCtrl.GetItemText(iItem,8);
//double sfValue=atof(sValue);
sBase = m_ListCtrl.GetItemText(iItem,12);
strQuery = "delete from tblMsave where fldRkno='"+sNO+"'";
theApp.ADOExecute(theApp.m_pADOSet, strQuery);
strQuery="update tblMsurplus set fldYeaccount=fldYeaccount-"+sAccount+",fldYevalue=fldYevalue-"\
+sValue+" where fldYeid='"+sID+"'and fldYebase='"+sBase+"'";
theApp.ADOExecute(theApp.m_pADOSet,strQuery);
strQuery="delete from tblMsurplus where fldYeaccount=0";
theApp.ADOExecute(theApp.m_pADOSet,strQuery);
}
}
//刷新列表
RefreshIn();
}
void CMaterial_MISView::OnMenuDeloutinfo()
{
// TODO: Add your command handler code here
_variant_t Holder, strQuery;
if ( m_ListCtrl && m_sCurrentList!="物资出库列表" )
{
m_ListCtrl.DestroyWindow();
strQuery = "select * from tblMuse";
CreateOut(strQuery);
m_sCurrentList = _T("物资出库列表");
m_StaticCtrl.SetWindowText(m_sCurrentList);
return;
}
if ( !m_ListCtrl )
{
strQuery = "select * from tblMuse";
CreateOut(strQuery);
m_sCurrentList = _T("物资出库列表");
m_StaticCtrl.SetWindowText(m_sCurrentList);
return;
}
//删除记录
POSITION pos = m_ListCtrl.GetFirstSelectedItemPosition();
if ( pos == NULL )
{
AfxMessageBox(_T("没有选中记录！"), MB_ICONEXCLAMATION);
return;
}
else
{
// ... Add by jackie ...
CDelConfirm m_delconf;
m_delconf.DoModal();
if(!del_confirm)
return;
int iItem;
CString sNO;
CString sID;
CString sAccount;
CString sValue;
CString sBase;
while (pos)
{
iItem = m_ListCtrl.GetNextSelectedItem(pos);
sNO = m_ListCtrl.GetItemText(iItem, 0);
sID = m_ListCtrl.GetItemText(iItem, 1);
sAccount = m_ListCtrl.GetItemText(iItem, 6);
sValue = m_ListCtrl.GetItemText(iItem,8);
sBase = m_ListCtrl.GetItemText(iItem,12);
strQuery = "delete from tblMuse where fldLyno='"+sNO+"'";
theApp.ADOExecute(theApp.m_pADOSet, strQuery);
strQuery="update tblMsurplus set fldYeaccount=fldYeaccount+"+sAccount+",fldYevalue=fldYevalue+"\
+sValue+" where fldYeid='"+sID+"'and fldYebase='"+sBase+"'";
theApp.ADOExecute(theApp.m_pADOSet,strQuery);
strQuery="delete from tblMsurplus where fldYeaccount=0";
theApp.ADOExecute(theApp.m_pADOSet,strQuery);
}
}
//刷新列表
RefreshOut();
}
void CMaterial_MISView::OnMenuSearchbasicinfo()
{
// TODO: Add your command handler code here
_variant_t strQuery, Holder;
strQuery = "select fldWzname from tblMaterial";
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 tblMsave";
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;
strQuery="select * from tblMuse";
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;
m_ListCtrl.DestroyWindow();
strQuery = "select * from tblMsurplus";
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);
// 获得所有记录
_variant_t Holder, strQuery;
strQuery = "select * from tblMaterial order by fldWzid";
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++)
{
// 获得物资ID
Holder = theApp.m_pADOSet->GetCollect("fldWzid");
str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
m_ListCtrl.InsertItem(i, str);
// 获得物资名称
Holder = theApp.m_pADOSet->GetCollect("fldWzname");
str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
m_ListCtrl.SetItemText(i, 1, str);
// 获得物资规格型号
Holder = theApp.m_pADOSet->GetCollect("fldWzspec");
str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
m_ListCtrl.SetItemText(i, 2, str);
// 获得物资类别
Holder = theApp.m_pADOSet->GetCollect("fldWzkind");
str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
m_ListCtrl.SetItemText(i, 3, str);
// 获得物资计量单位
Holder = theApp.m_pADOSet->GetCollect("fldWzunit");
str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
m_ListCtrl.SetItemText(i, 4, 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);
// 获得记录集
_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++)
{
Holder = theApp.m_pADOSet->GetCollect("fldWzid");
str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
m_ListCtrl.InsertItem(i, str);
Holder = theApp.m_pADOSet->GetCollect("fldWzname");
str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
m_ListCtrl.SetItemText(i, 1, str);
Holder = theApp.m_pADOSet->GetCollect("fldWzspec");
str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
m_ListCtrl.SetItemText(i, 2, str);
Holder = theApp.m_pADOSet->GetCollect("fldWzkind");
str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
m_ListCtrl.SetItemText(i, 3, str);
Holder = theApp.m_pADOSet->GetCollect("fldWzunit");
str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
m_ListCtrl.SetItemText(i, 4, 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);
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -