📄 material_misview.cpp
字号:
str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
m_ListCtrl.InsertItem(i, str);
Holder = theApp.m_pADOSet->GetCollect("Version");
str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
m_ListCtrl.SetItemText(i, 1, str);
Holder = theApp.m_pADOSet->GetCollect("ProductName");
str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
m_ListCtrl.SetItemText(i, 2, str);
Holder = theApp.m_pADOSet->GetCollect("Amount");
str.Format("%.2f", Holder.vt==VT_NULL?0:Holder.dblVal);
m_ListCtrl.SetItemText(i, 3, str);
Holder = theApp.m_pADOSet->GetCollect("Unit");
str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
m_ListCtrl.SetItemText(i, 4, str);
Holder = theApp.m_pADOSet->GetCollect("CDate");
str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
m_ListCtrl.SetItemText(i, 5, str);
Holder = theApp.m_pADOSet->GetCollect("Creater");
str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
m_ListCtrl.SetItemText(i, 6, str);
Holder = theApp.m_pADOSet->GetCollect("Remark");
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::RefreshIn(_variant_t strQuery)
{
if (m_ListCtrl) m_ListCtrl.DestroyWindow();
CreateIn( strQuery );
if(theApp.inorout=="in") m_sCurrentList = _T("产品入库列表");
else m_sCurrentList = _T("产品出库列表");
m_StaticCtrl.SetWindowText(m_sCurrentList);
}
void CMaterial_MISView::RefreshIn()
{
if (m_ListCtrl) m_ListCtrl.DestroyWindow();
_variant_t strQuery;
strQuery="select * from ProductStock where State='"+theApp.inorout+"'";
CreateIn(strQuery);
if(theApp.inorout=="in") m_sCurrentList = _T("产品入库列表");
else 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);
_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("MapID");
str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
m_ListCtrl.InsertItem(i, str);
Holder = theApp.m_pADOSet->GetCollect("Version");
str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
m_ListCtrl.SetItemText(i, 1, str);
Holder = theApp.m_pADOSet->GetCollect("ProductName");
str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
m_ListCtrl.SetItemText(i, 2, str);
Holder = theApp.m_pADOSet->GetCollect("StockNum");
str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
m_ListCtrl.SetItemText(i, 3, str);
Holder = theApp.m_pADOSet->GetCollect("Unit");
str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
m_ListCtrl.SetItemText(i, 4, str);
theApp.m_pADOSet->MoveNext();
}
strQuery = "select * from ProductPrice";
theApp.ADOExecute(theApp.m_pADOSet, strQuery);
for(i=0; i<iCount; i++)
{
Holder = theApp.m_pADOSet->GetCollect("Price");
str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
m_ListCtrl.SetItemText(i, 5, str);
float fprice=atof(str);
str = m_ListCtrl.GetItemText(i,3);
float famount=atof(str);
float fsum = fprice*famount;
char *buffer;
int decimal, sign, precision = 3;
buffer = _fcvt( fsum, precision, &decimal, &sign );
str = _T(buffer);
int k=str.GetLength();
CString str2,str3=_T(".");
for(int j=0;j<k;j++)
{
str = _T(buffer[j]);
if(j==(k-3)) str2 = str2+str3;
str2 = str2 +str;
}
m_ListCtrl.SetItemText(i, 6, str2);
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
m_ListCtrl.DestroyWindow();
CreateMaterialInfo();
return;
}
void CMaterial_MISView::OnMenuListininfo()
{
// TODO: Add your command handler code here
_variant_t strQuery;
m_ListCtrl.DestroyWindow();
theApp.inorout = _T("in");
strQuery = "select * from ProductStock where State='"+theApp.inorout+"'";
CreateIn(strQuery);
m_sCurrentList = _T("产品入库列表");
m_StaticCtrl.SetWindowText(m_sCurrentList);
return;
}
void CMaterial_MISView::OnMenuListoutinfo()
{
// TODO: Add your command handler code here
_variant_t strQuery;
m_ListCtrl.DestroyWindow();
theApp.inorout = _T("out");
strQuery = "select * from ProductStock where State='"+theApp.inorout+"'";
CreateIn(strQuery);
m_sCurrentList =_T("产品出库列表");
m_StaticCtrl.SetWindowText(m_sCurrentList);
}
void CMaterial_MISView::OnMainmenuChangepwd()
{
// TODO: Add your command handler code here
CChangePswd m_changepswd;
m_changepswd.DoModal();
}
void CMaterial_MISView::OnMainmenuAppendaccount()
{
// TODO: Add your command handler code here
CString str;
str = theApp.m_sCurrentUser;
if(str.CompareNoCase("administrator")!=0)
{
AfxMessageBox("只有Administrator才拥有此项权限！",MB_ICONEXCLAMATION);
return;
}
CAddNewUsr m_addnewusr;
m_addnewusr.DoModal();
}
void CMaterial_MISView::OnMainmenuAddread()
{
CString str;
str = theApp.m_sCurrentUser;
if(str.CompareNoCase("administrator")!=0 && str.CompareNoCase("吕蓉")!=0)
{
AfxMessageBox("只有Administrator和吕蓉才拥有此项权限！",MB_ICONEXCLAMATION);
return;
}
CAddRead m_addread;
m_addread.DoModal();
}
void CMaterial_MISView::OnMenuSearchprice()
{
_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 ProductPrice";
CreatePriceInfo(strQuery);
m_sCurrentList = _T("产品余额列表");
m_StaticCtrl.SetWindowText(m_sCurrentList);
CSearchPriceInfo dlg;
dlg.DoModal();
return;
}
}
void CMaterial_MISView::CreatePriceInfo(_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);
_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("MapID");
str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
m_ListCtrl.InsertItem(i, str);
Holder = theApp.m_pADOSet->GetCollect("Version");
str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
m_ListCtrl.SetItemText(i, 1, str);
Holder = theApp.m_pADOSet->GetCollect("ProductName");
str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
m_ListCtrl.SetItemText(i, 2, str);
Holder = theApp.m_pADOSet->GetCollect("Price");
str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
m_ListCtrl.SetItemText(i, 3, str);
Holder = theApp.m_pADOSet->GetCollect("Creater");
str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
m_ListCtrl.SetItemText(i, 4, str);
theApp.m_pADOSet->MoveNext();
}
}
void CMaterial_MISView::RefreshPrice(_variant_t strQuery)
{
if (m_ListCtrl) m_ListCtrl.DestroyWindow();
CreatePriceInfo( strQuery );
m_sCurrentList = _T("产品余额列表");
m_StaticCtrl.SetWindowText(m_sCurrentList);
}
void CMaterial_MISView::OnMenuEditprice()
{
// 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
{
strQuery = "select * from ProductPrice";
if ( m_ListCtrl && m_sCurrentList!="产品余额列表" )
{
m_ListCtrl.DestroyWindow();
CreatePriceInfo(strQuery);
m_sCurrentList = _T("产品余额列表");
m_StaticCtrl.SetWindowText(m_sCurrentList);
return;
}
if ( !m_ListCtrl )
{
CreatePriceInfo(strQuery);
m_sCurrentList = _T("产品余额列表");
m_StaticCtrl.SetWindowText(m_sCurrentList);
return;
}
//弹出警告对话框
POSITION pos = m_ListCtrl.GetFirstSelectedItemPosition();
if (pos == NULL) AfxMessageBox(_T("没有选中记录！"), MB_ICONEXCLAMATION);
else
{
EditPrice dlg;
CString str;
int iItem = m_ListCtrl.GetNextSelectedItem(pos);
dlg.m_mapid = m_ListCtrl.GetItemText(iItem, 0);
dlg.m_version = m_ListCtrl.GetItemText(iItem, 1);
dlg.m_productname = m_ListCtrl.GetItemText(iItem, 2);
dlg.m_price = m_ListCtrl.GetItemText(iItem, 3);
dlg.m_creater = m_ListCtrl.GetItemText(iItem, 4);
dlg.DoModal();
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -