?? repaired.cpp
字號:
// Repaired.cpp : implementation file
//
#include "stdafx.h"
#include "FixedAssets.h"
#include "Repaired.h"
#include "CRACK.h"
#include "PromptDlg.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif
/////////////////////////////////////////////////////////////////////////////
// CRepaired dialog
CRepaired::CRepaired(CWnd* pParent /*=NULL*/)
: CDialog(CRepaired::IDD, pParent)
{
//{{AFX_DATA_INIT(CRepaired)
m_strAssetID = _T("");
m_strName = _T("");
m_strReason = _T("");
m_strRemark = _T("");
m_RepairDate = 0;
m_SendDate = 0;
m_strSender = _T("");
m_strStatus = _T("");
m_dSum = 0.0;
m_strPlace = _T("");
m_strFitting = _T("");
m_strRepairer = _T("");
//}}AFX_DATA_INIT
}
void CRepaired::DoDataExchange(CDataExchange* pDX)
{
CDialog::DoDataExchange(pDX);
//{{AFX_DATA_MAP(CRepaired)
DDX_Control(pDX, IDC_RD_REPAIRER, m_CtrlCBRepairer);
DDX_Control(pDX, IDC_RD_FITTING, m_CtrlCBFitting);
DDX_Control(pDX, IDC_RD_PLACE, m_CtrlCBPlace);
DDX_Control(pDX, IDC_RD_REASON, m_CtrlEditReason);
DDX_Control(pDX, IDC_RD_LIST, m_CtrlList);
DDX_Text(pDX, IDC_RD_ASSETID, m_strAssetID);
DDX_Text(pDX, IDC_RD_NAME, m_strName);
DDX_Text(pDX, IDC_RD_REASON, m_strReason);
DDX_Text(pDX, IDC_RD_REMARK, m_strRemark);
DDX_DateTimeCtrl(pDX, IDC_RD_REPAIRDATE, m_RepairDate);
DDX_DateTimeCtrl(pDX, IDC_RD_SENDDATE, m_SendDate);
DDX_Text(pDX, IDC_RD_SENDER, m_strSender);
DDX_Text(pDX, IDC_RD_STATUS, m_strStatus);
DDX_Text(pDX, IDC_RD_SUM, m_dSum);
DDV_MinMaxDouble(pDX, m_dSum, 0., 1.e+024);
DDX_CBString(pDX, IDC_RD_PLACE, m_strPlace);
DDX_CBString(pDX, IDC_RD_FITTING, m_strFitting);
DDX_CBString(pDX, IDC_RD_REPAIRER, m_strRepairer);
//}}AFX_DATA_MAP
}
BEGIN_MESSAGE_MAP(CRepaired, CDialog)
//{{AFX_MSG_MAP(CRepaired)
ON_NOTIFY(LVN_ITEMCHANGED, IDC_RD_LIST, OnItemchangedRdList)
ON_BN_CLICKED(ID_RD_REPAIRED, OnRdRepaired)
//}}AFX_MSG_MAP
END_MESSAGE_MAP()
/////////////////////////////////////////////////////////////////////////////
// CRepaired message handlers
BOOL CRepaired::OnInitDialog()
{
CDialog::OnInitDialog();
// TODO: Add extra initialization here
m_CtrlList.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES);
//連接數(shù)據(jù)庫
m_pDatabase=new CDaoDatabase;
try{
m_pDatabase->Open("FixedAssets");
m_pRecordset=new CDaoRecordset(m_pDatabase);
}
catch(CDaoException *e)
{
e->ReportError();
delete m_pDatabase;
m_pDatabase=NULL;
e->Delete();
}
if(!m_pDatabase->IsOpen()) return 0;
if(!m_pRecordset) return 0;
if(m_pRecordset->IsOpen()) m_pRecordset->Close();
CString strSelect;
m_strTableName = _T("維修資產(chǎn)");
strSelect = _T("Select DISTINCT 維修人 From [");
strSelect += m_strTableName;
strSelect += _T("]");
m_pRecordset->Open(dbOpenDynaset,strSelect);
while (!m_pRecordset->IsEOF())
{
COleVariant var;
var = m_pRecordset->GetFieldValue(0);
m_CtrlCBRepairer.AddString(CCrack::strVARIANT(var));
m_pRecordset->MoveNext();
}
// close recordset
m_pRecordset->Close();
strSelect = _T("Select DISTINCT 維修地點 From [");
strSelect += m_strTableName;
strSelect += _T("]");
m_pRecordset->Open(dbOpenDynaset,strSelect);
while (!m_pRecordset->IsEOF())
{
COleVariant var;
var = m_pRecordset->GetFieldValue(0);
m_CtrlCBPlace.AddString(CCrack::strVARIANT(var));
m_pRecordset->MoveNext();
}
// close recordset
m_pRecordset->Close();
strSelect = _T("Select DISTINCT 配件名稱 From [");
strSelect += m_strTableName;
strSelect += _T("]");
m_pRecordset->Open(dbOpenDynaset,strSelect);
while (!m_pRecordset->IsEOF())
{
COleVariant var;
var = m_pRecordset->GetFieldValue(0);
m_CtrlCBFitting.AddString(CCrack::strVARIANT(var));
m_pRecordset->MoveNext();
}
// close recordset
m_pRecordset->Close();
Refresh();
return TRUE; // return TRUE unless you set the focus to a control
// EXCEPTION: OCX Property Pages should return FALSE
}
int CRepaired::DoModal()
{
// TODO: Add your specialized code here and/or call the base class
return CDialog::DoModal();
}
void CRepaired::Refresh()//刷新
{
m_strTableName = _T("維修資產(chǎn)");
if(!m_pDatabase->IsOpen()) return;
if(!m_pRecordset) return;
if(m_pRecordset->IsOpen()) m_pRecordset->Close();
//清空list控件
m_CtrlList.DeleteAllItems();
while(m_CtrlList.DeleteColumn(0));
CDaoFieldInfo fieldInfo;
int nFields;
CDaoTableDef td(m_pDatabase);
try
{
td.Open(m_strTableName);
nFields = td.GetFieldCount();
int nWidth;
for (int j=0; j < nFields; j++)
{
td.GetFieldInfo(j,fieldInfo);
nWidth = m_CtrlList.GetStringWidth(fieldInfo.m_strName) + 15;
if(j>=2)
m_CtrlList.InsertColumn(j+2,fieldInfo.m_strName, LVCFMT_LEFT, nWidth);
else
m_CtrlList.InsertColumn(j,fieldInfo.m_strName, LVCFMT_LEFT, nWidth);
}
nWidth=100;
m_CtrlList.InsertColumn(2,"資產(chǎn)編號", LVCFMT_LEFT, nWidth);
m_CtrlList.InsertColumn(3,"資產(chǎn)名稱", LVCFMT_LEFT, nWidth);
}
catch (CDaoException* e)
{
e->ReportError();
e->Delete();
return;
}
td.Close();
int nItem = 0,i;
try
{
CString select,strSelect(_T("Select * From ["));
strSelect += m_strTableName;
strSelect += _T("]");
m_pRecordset->Open(dbOpenDynaset,strSelect);
while (!m_pRecordset->IsEOF())
{
COleVariant var;
var = m_pRecordset->GetFieldValue(12);
if(CCrack::strVARIANT(var)=="TRUE")
{
m_pRecordset->MoveNext();
continue;
}
var = m_pRecordset->GetFieldValue(0);
m_CtrlList.InsertItem(nItem,CCrack::strVARIANT(var));
for (i=0; i < nFields; i++)
{
var = m_pRecordset->GetFieldValue(i);
if(i>=2)
{
m_CtrlList.SetItemText( nItem,i+2,CCrack::strVARIANT(var));
}
if(i==1)
m_CtrlList.SetItemText( nItem,i,CCrack::strVARIANT(var));
}
CDaoRecordset *m_pSet;
m_pSet=new CDaoRecordset(m_pDatabase);
var = m_pRecordset->GetFieldValue(1);
select.Format("select 資產(chǎn)編號,資產(chǎn)名稱 from 資產(chǎn)信息 where 資產(chǎn)ID=%d",atoi(CCrack::strVARIANT(var)));
try{
m_pSet->Open(dbOpenDynaset,select);
var = m_pSet->GetFieldValue(0);
m_CtrlList.SetItemText( nItem,2,CCrack::strVARIANT(var));
var = m_pSet->GetFieldValue(1);
m_CtrlList.SetItemText( nItem,3,CCrack::strVARIANT(var));
m_pSet->Close();
}
catch(CDaoException* e){
m_CtrlList.SetItemText( nItem,2,"該項已刪除");
m_CtrlList.SetItemText( nItem,3,"該項已刪除");
e->Delete();}
m_pRecordset->MoveNext();
nItem++;
}
}
catch (CDaoException* e)
{
e->ReportError();
e->Delete();
return;
}
m_ID.Empty();
m_strName.Empty();
m_strAssetID.Empty();
m_strSender.Empty();
m_strRepairer.Empty();
m_strPlace.Empty();
m_strReason.Empty();
m_strStatus.Empty();
m_strFitting.Empty();
m_strRemark.Empty();
m_RepairDate=CTime::GetCurrentTime();
m_SendDate=CTime::GetCurrentTime();
UpdateData(0);
}
BOOL CRepaired::DestroyWindow()
{
// TODO: Add your specialized code here and/or call the base class
m_pDatabase->Close();
delete m_pDatabase;
m_pDatabase=NULL;
return CDialog::DestroyWindow();
}
void CRepaired::OnItemchangedRdList(NMHDR* pNMHDR, LRESULT* pResult)
{
NM_LISTVIEW* pNMListView = (NM_LISTVIEW*)pNMHDR;
UpdateData(1);
if(pNMListView->uNewState&LVIS_SELECTED)
{
char pContent[50] ;
int iCurrent = pNMListView->iItem;
m_CtrlList.GetItemText(iCurrent,1,pContent,50);
m_ID.Format("%s", pContent);
m_CtrlList.GetItemText(iCurrent,2,pContent,50);
m_strAssetID.Format("%s", pContent);
m_CtrlList.GetItemText(iCurrent,3,pContent,50);
m_strName.Format("%s", pContent);
m_CtrlList.GetItemText(iCurrent,4,pContent,50);
m_strSender.Format("%s", pContent);
m_CtrlList.GetItemText(iCurrent,8,pContent,50);
CString str,year,month,day;
str.Format("%s",pContent);
if(str.GetAt(6)=='0')
year.Format("20%c%c",str.GetAt(6),str.GetAt(7));
else
year.Format("19%c%c",str.GetAt(6),str.GetAt(7));
month.Format("%c%c",str.GetAt(0),str.GetAt(1));
day.Format("%c%c",str.GetAt(3),str.GetAt(4));
CTime time(atoi(year),atoi(month),atoi(day),0,0,0);
m_SendDate=time;
UpdateData(FALSE);
(CButton*)GetDlgItem(ID_RD_REPAIRED)->EnableWindow(1);
(CEdit*)GetDlgItem(IDC_RD_STATUS)->EnableWindow(1);
(CEdit*)GetDlgItem(IDC_RD_SUM)->EnableWindow(1);
(CEdit*)GetDlgItem(IDC_RD_REASON)->EnableWindow(1);
(CEdit*)GetDlgItem(IDC_RD_REMARK)->EnableWindow(1);
(CComboBox*)GetDlgItem(IDC_RD_PLACE)->EnableWindow(1);
(CComboBox*)GetDlgItem(IDC_RD_REPAIRER)->EnableWindow(1);
(CComboBox*)GetDlgItem(IDC_RD_FITTING)->EnableWindow(1);
(CDateTimeCtrl*)GetDlgItem(IDC_RD_REPAIRDATE)->EnableWindow(1);
}
else
{
if(m_CtrlList.GetSelectedCount()<=0)
{
(CButton*)GetDlgItem(ID_RD_REPAIRED)->EnableWindow(0);
(CEdit*)GetDlgItem(IDC_RD_STATUS)->EnableWindow(0);
(CEdit*)GetDlgItem(IDC_RD_SUM)->EnableWindow(0);
(CEdit*)GetDlgItem(IDC_RD_REASON)->EnableWindow(0);
(CEdit*)GetDlgItem(IDC_RD_REMARK)->EnableWindow(0);
(CComboBox*)GetDlgItem(IDC_RD_PLACE)->EnableWindow(0);
(CComboBox*)GetDlgItem(IDC_RD_REPAIRER)->EnableWindow(0);
(CComboBox*)GetDlgItem(IDC_RD_FITTING)->EnableWindow(0);
(CDateTimeCtrl*)GetDlgItem(IDC_RD_REPAIRDATE)->EnableWindow(0);
m_ID.Empty();
m_strName.Empty();
m_strAssetID.Empty();
m_strSender.Empty();
m_strRepairer.Empty();
m_strPlace.Empty();
m_strReason.Empty();
m_strStatus.Empty();
m_strFitting.Empty();
m_strRemark.Empty();
m_RepairDate=CTime::GetCurrentTime();
m_SendDate=CTime::GetCurrentTime();
UpdateData(0);
}
}
*pResult = 0;
}
void CRepaired::OnRdRepaired()
{
UpdateData(1);
if(!m_pDatabase->IsOpen()) return;
if(!m_pRecordset) return;
if(m_pRecordset->IsOpen()) m_pRecordset->Close();
CString strSql;
//檢查數(shù)據(jù)是否正確
if(m_strPlace.IsEmpty()) {AfxMessageBox("維修地點不能為空！");m_CtrlCBPlace.SetFocus();return;}
if(m_strReason.IsEmpty()) {AfxMessageBox("故障原因不能為空！");m_CtrlEditReason.SetFocus();return;}
CPromptDlg dlg;
dlg.m_Prompt="\n修回這些物品?";
if(dlg.DoModal()==IDCANCEL) return;
CString RepairDate,useinfo="在庫";
RepairDate.Format("%d %d %d",m_RepairDate.GetYear(),m_RepairDate.GetMonth(),m_RepairDate.GetDay());//歸還日期
UINT uSelectedCount = m_CtrlList.GetSelectedCount();
int nItemIndex = -1,rd=1;
CString RepairId;
// Update all of the selected items.
if (uSelectedCount > 0)
{
while((nItemIndex=m_CtrlList.GetNextItem(nItemIndex,LVNI_SELECTED ) ) != -1 )
{
RepairId=m_CtrlList.GetItemText ( nItemIndex, 0 );
m_ID=m_CtrlList.GetItemText ( nItemIndex, 1 );
try{
if(m_pDatabase->CanUpdate())
{
strSql.Format("Update 資產(chǎn)信息 set 使用情況='%s' where 資產(chǎn)ID=%d",useinfo,atoi(m_ID));
m_pDatabase->Execute(strSql, dbDenyWrite|dbConsistent);
strSql.Format("Update 維修資產(chǎn) set 維修人='%s',維修地點='%s',故障原因='%s',維修日期='%s',\
維修狀況='%s',配件名稱='%s',金額=%0.3f,備注='%s',是否修完=%d where 維修記錄ID=%d",m_strRepairer,\
m_strPlace,m_strReason,RepairDate,m_strStatus,m_strFitting,m_dSum,m_strRemark,rd,atoi(RepairId));
m_pDatabase->Execute(strSql, dbDenyWrite|dbFailOnError);
}
}
catch(CDaoException* e){
e->ReportError();
e->Delete();}
}
}
(CButton*)GetDlgItem(ID_RD_REPAIRED)->EnableWindow(0);
(CEdit*)GetDlgItem(IDC_RD_STATUS)->EnableWindow(0);
(CEdit*)GetDlgItem(IDC_RD_SUM)->EnableWindow(0);
(CEdit*)GetDlgItem(IDC_RD_REASON)->EnableWindow(0);
(CEdit*)GetDlgItem(IDC_RD_REMARK)->EnableWindow(0);
(CComboBox*)GetDlgItem(IDC_RD_PLACE)->EnableWindow(0);
(CComboBox*)GetDlgItem(IDC_RD_REPAIRER)->EnableWindow(0);
(CComboBox*)GetDlgItem(IDC_RD_FITTING)->EnableWindow(0);
(CDateTimeCtrl*)GetDlgItem(IDC_RD_REPAIRDATE)->EnableWindow(0);
Refresh();
}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -