📄 material_misview.cpp
字号:
// 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);
m_ListCtrl.InsertColumn(9,_T("入库时间"), LVCFMT_LEFT, 100);
m_ListCtrl.InsertColumn(10,_T("经办人"), LVCFMT_LEFT, 100);
m_ListCtrl.InsertColumn(11,_T("保管人"), LVCFMT_LEFT, 100);
m_ListCtrl.InsertColumn(12,_T("仓 库"), LVCFMT_LEFT, 100);
m_ListCtrl.InsertColumn(13,_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("fldRkno");
str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
m_ListCtrl.InsertItem(i, str);
Holder = theApp.m_pADOSet->GetCollect("fldRkid");
str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
m_ListCtrl.SetItemText(i, 1, str);
// Get customname
Holder = theApp.m_pADOSet->GetCollect("fldRkname");
str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
m_ListCtrl.SetItemText(i, 2, str);
// Get customID
Holder = theApp.m_pADOSet->GetCollect("fldRkspec");
str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
m_ListCtrl.SetItemText(i, 3, str);
// Get roomno
Holder = theApp.m_pADOSet->GetCollect("fldRkkind");
str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
m_ListCtrl.SetItemText(i, 4, str);
// Get indate
Holder = theApp.m_pADOSet->GetCollect("fldRkunit");
str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
m_ListCtrl.SetItemText(i, 5, str);
Holder = theApp.m_pADOSet->GetCollect("fldRkaccount");
str.Format("%.2f", Holder.vt==VT_NULL?0:Holder.dblVal);
//str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
m_ListCtrl.SetItemText(i, 6, str);
Holder = theApp.m_pADOSet->GetCollect("fldRkprice");
str.Format("%.2f", Holder.vt==VT_NULL?0:Holder.dblVal);
//str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
m_ListCtrl.SetItemText(i, 7, str);
Holder = theApp.m_pADOSet->GetCollect("fldRkvalue");
str.Format("%.2f", Holder.vt==VT_NULL?0:Holder.dblVal);
//str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
m_ListCtrl.SetItemText(i, 8, str);
Holder = theApp.m_pADOSet->GetCollect("fldRkdate");
time = Holder;
str = time.Format("%Y-%m-%d");
m_ListCtrl.SetItemText(i, 9, str);
Holder = theApp.m_pADOSet->GetCollect("fldRkdeal_person");
str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
m_ListCtrl.SetItemText(i, 10, str);
Holder = theApp.m_pADOSet->GetCollect("fldRksave_person");
str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
m_ListCtrl.SetItemText(i, 11, str);
// Get discount
Holder = theApp.m_pADOSet->GetCollect("fldRkbase");
str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
m_ListCtrl.SetItemText(i, 12, str);
Holder = theApp.m_pADOSet->GetCollect("fldRkmemo");
str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
m_ListCtrl.SetItemText(i, 13, str);
theApp.m_pADOSet->MoveNext();
}
}
void CMaterial_MISView::RefreshIn(_variant_t strQuery)
{
if (m_ListCtrl) m_ListCtrl.DestroyWindow();
CreateIn( strQuery );
m_sCurrentList = _T("物资入库列表");
m_StaticCtrl.SetWindowText(m_sCurrentList);
}
void CMaterial_MISView::RefreshIn()
{
if (m_ListCtrl) m_ListCtrl.DestroyWindow();
_variant_t strQuery;
strQuery="select * from tblMsave";
CreateIn(strQuery);
m_sCurrentList = _T("物资入库列表");
m_StaticCtrl.SetWindowText(m_sCurrentList);
}
void CMaterial_MISView::RefreshOut(_variant_t strQuery)
{
if (m_ListCtrl) m_ListCtrl.DestroyWindow();
CreateOut( strQuery );
m_sCurrentList = _T("物资出库列表");
m_StaticCtrl.SetWindowText(m_sCurrentList);
}
void CMaterial_MISView::CreateOut(_variant_t strQuery)
{
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);
m_ListCtrl.InsertColumn(9,_T("出库时间"), LVCFMT_LEFT, 100);
m_ListCtrl.InsertColumn(10,_T("领用人"), LVCFMT_LEFT, 100);
m_ListCtrl.InsertColumn(11,_T("经办人"), LVCFMT_LEFT, 100);
m_ListCtrl.InsertColumn(12,_T("仓 库"), LVCFMT_LEFT, 100);
m_ListCtrl.InsertColumn(13,_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("fldLyno");
str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
m_ListCtrl.InsertItem(i, str);
Holder = theApp.m_pADOSet->GetCollect("fldLyid");
str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
m_ListCtrl.SetItemText(i, 1, str);
// Get customname
Holder = theApp.m_pADOSet->GetCollect("fldLyname");
str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
m_ListCtrl.SetItemText(i, 2, str);
// Get customID
Holder = theApp.m_pADOSet->GetCollect("fldLyspec");
str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
m_ListCtrl.SetItemText(i, 3, str);
// Get roomno
Holder = theApp.m_pADOSet->GetCollect("fldLykind");
str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
m_ListCtrl.SetItemText(i, 4, str);
// Get indate
Holder = theApp.m_pADOSet->GetCollect("fldLyunit");
str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
m_ListCtrl.SetItemText(i, 5, str);
Holder = theApp.m_pADOSet->GetCollect("fldLyaccount");
str.Format("%.2f", Holder.vt==VT_NULL?0:Holder.dblVal);
//str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
m_ListCtrl.SetItemText(i, 6, str);
Holder = theApp.m_pADOSet->GetCollect("fldLyprice");
str.Format("%.2f", Holder.vt==VT_NULL?0:Holder.dblVal);
//str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
m_ListCtrl.SetItemText(i, 7, str);
Holder = theApp.m_pADOSet->GetCollect("fldLyvalue");
str.Format("%.2f", Holder.vt==VT_NULL?0:Holder.dblVal);
//str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
m_ListCtrl.SetItemText(i, 8, str);
Holder = theApp.m_pADOSet->GetCollect("fldLydate");
time = Holder;
str = time.Format("%Y-%m-%d");
m_ListCtrl.SetItemText(i, 9, str);
Holder = theApp.m_pADOSet->GetCollect("fldLyuse_person");
str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
m_ListCtrl.SetItemText(i, 10, str);
Holder = theApp.m_pADOSet->GetCollect("fldLydeal_person");
str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
m_ListCtrl.SetItemText(i, 11, str);
// Get discount
Holder = theApp.m_pADOSet->GetCollect("fldLybase");
str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
m_ListCtrl.SetItemText(i, 12, str);
Holder = theApp.m_pADOSet->GetCollect("fldLymemo");
str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
m_ListCtrl.SetItemText(i, 13, str);
theApp.m_pADOSet->MoveNext();
}
}
void CMaterial_MISView::RefreshOut()
{
if (m_ListCtrl) m_ListCtrl.DestroyWindow();
_variant_t strQuery;
strQuery="select * from tblMuse";
CreateIn(strQuery);
m_sCurrentList = _T("物资出库列表");
m_StaticCtrl.SetWindowText(m_sCurrentList);
}
void CMaterial_MISView::CreateSurplusInfo(_variant_t strQuery)
{
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);
_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("fldYeid");
str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
m_ListCtrl.InsertItem(i, str);
Holder = theApp.m_pADOSet->GetCollect("fldYename");
str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
m_ListCtrl.SetItemText(i, 1, str);
Holder = theApp.m_pADOSet->GetCollect("fldYespec");
str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
m_ListCtrl.SetItemText(i, 2, str);
Holder = theApp.m_pADOSet->GetCollect("fldYekind");
str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
m_ListCtrl.SetItemText(i, 3, str);
Holder = theApp.m_pADOSet->GetCollect("fldYeunit");
str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
m_ListCtrl.SetItemText(i, 4, str);
Holder = theApp.m_pADOSet->GetCollect("fldYeaccount");
str.Format("%.2f", Holder.vt==VT_NULL?0:Holder.dblVal);
m_ListCtrl.SetItemText(i, 5, str);
Holder = theApp.m_pADOSet->GetCollect("fldYevalue");
str.Format("%.2f", Holder.vt==VT_NULL?0:Holder.dblVal);
m_ListCtrl.SetItemText(i, 6, str);
Holder = theApp.m_pADOSet->GetCollect("fldYebase");
str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
m_ListCtrl.SetItemText(i, 7, str);
Holder = theApp.m_pADOSet->GetCollect("fldYememo");
str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
m_ListCtrl.SetItemText(i, 8, str);
theApp.m_pADOSet->MoveNext();
}
}
void CMaterial_MISView::RefreshSurplus(_variant_t strQuery)
{
if (m_ListCtrl) m_ListCtrl.DestroyWindow();
CreateSurplusInfo( strQuery );
m_sCurrentList = _T("物资余额列表");
m_StaticCtrl.SetWindowText(m_sCurrentList);
}
void CMaterial_MISView::OnMenuListbasicinfo()
{
// TODO: Add your command handler code here
// ... add by jackie ...
m_ListCtrl.DestroyWindow();
CreateMaterialInfo();
return;
}
void CMaterial_MISView::OnMenuListininfo()
{
// TODO: Add your command handler code here
// ... add by jackie ...
_variant_t strQuery;
m_ListCtrl.DestroyWindow();
strQuery = "select * from tblMsave";
CreateIn(strQuery);
m_sCurrentList = _T("物资入库列表");
m_StaticCtrl.SetWindowText(m_sCurrentList);
return;
}
void CMaterial_MISView::OnMenuListoutinfo()
{
// TODO: Add your command handler code here
// ... add by jackie ...
_variant_t strQuery;
m_ListCtrl.DestroyWindow();
strQuery = "select * from tblMuse";
CreateOut(strQuery);
m_sCurrentList =_T("物资出库列表");
m_StaticCtrl.SetWindowText(m_sCurrentList);
}
void CMaterial_MISView::OnMainmenuChangepwd()
{
// TODO: Add your command handler code here
// ... add by jackie ...
CChangePswd m_changepswd;
m_changepswd.DoModal();
}
void CMaterial_MISView::OnMainmenuAppendaccount()
{
// TODO: Add your command handler code here
// ... add by jackie ...
CString str;
str = theApp.m_sCurrentUser;
if(str.CompareNoCase("administrator")!=0)
{
AfxMessageBox("只有Administrator才拥有此项权限！",MB_ICONEXCLAMATION);
return;
}
CAddNewUsr m_addnewusr;
m_addnewusr.DoModal();
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -