updateequip.cpp

软件提供了完善的资产及设备档案管理,支持资产及设备的增加、删除、修改、清理等基本管理环节。软件同时提供了资产及设备的借出与归还管理,资产及设备转移管理,资产及设备维修管理

// UpdateEquip.cpp : implementation file
//

#include "stdafx.h"
#include "Equipment.h"
#include "UpdateEquip.h"
#include "NumberEdit.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif
extern CEquipmentApp theApp;
/////////////////////////////////////////////////////////////////////////////
// CUpdateEquip dialog


CUpdateEquip::CUpdateEquip(CWnd* pParent /*=NULL*/)
	: CDialog(CUpdateEquip::IDD, pParent)
{
	m_Hicon = AfxGetApp()->LoadIcon(IDR_MAINTITLE);
	//{{AFX_DATA_INIT(CUpdateEquip)
		// NOTE: the ClassWizard will add member initialization here
	//}}AFX_DATA_INIT
}


void CUpdateEquip::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CUpdateEquip)
	DDX_Control(pDX, IDC_EquipID, equipid);
	DDX_Control(pDX, IDC_USESTATE, usestate);
	DDX_Control(pDX, IDC_SPEC, spec);
	DDX_Control(pDX, IDC_SOURCEVALUE, sourcevalue);
	DDX_Control(pDX, IDC_REGDATE, regdate);
	DDX_Control(pDX, IDC_QUERYCONDITION, querycondition);
	DDX_Control(pDX, IDC_QUERY, query);
	DDX_Control(pDX, IDC_PUREVALUE, purevalue);
	DDX_Control(pDX, IDC_PREUSEMONTH, preusemonth);
	DDX_Control(pDX, IDC_PREPURSERATE, prepurerate);
	DDX_Control(pDX, IDC_PREPUREVALUE, prepurevalue);
	DDX_Control(pDX, IDC_MONTHDEPREVALUE, monthdeprevalue);
	DDX_Control(pDX, IDC_MONTHDEPRERATE, monthdeprerate);
	DDX_Control(pDX, IDC_LIST1, list);
	DDX_Control(pDX, IDC_EQUIPNAME, equipname);
	DDX_Control(pDX, IDC_EQUIPKINDS, equipkinds);
	DDX_Control(pDX, IDC_DEPREMONTH, depremonth);
	DDX_Control(pDX, IDC_DEPREMETHOD, depremethod);
	DDX_Control(pDX, IDC_ADDUPDEPRE, addupdepre);
	DDX_Control(pDX, IDC_ADDKINDS, addkinds);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CUpdateEquip, CDialog)
	//{{AFX_MSG_MAP(CUpdateEquip)
	ON_COMMAND(ID_BUTTONREFRESH, OnButtonrefresh)
	ON_BN_CLICKED(IDC_QUERY, OnQuery)
	ON_NOTIFY(NM_CLICK, IDC_LIST1, OnClickList1)
	ON_EN_CHANGE(IDC_SOURCEVALUE, OnChangeSourcevalue)
	ON_EN_CHANGE(IDC_ADDUPDEPRE, OnChangeAddupdepre)
	ON_EN_CHANGE(IDC_PUREVALUE, OnChangePurevalue)
	ON_EN_CHANGE(IDC_PREPURSERATE, OnChangePrepurserate)
	ON_EN_CHANGE(IDC_PREUSEMONTH, OnChangePreusemonth)
	ON_EN_CHANGE(IDC_DEPREMONTH, OnChangeDepremonth)
	ON_CBN_SELCHANGE(IDC_DEPREMETHOD, OnSelchangeDepremethod)
	ON_EN_CHANGE(IDC_MONTHDEPRERATE, OnChangeMonthdeprerate)
	ON_COMMAND(ID_BUTTONUPDATE, OnButtonupdate)
	ON_COMMAND(ID_BUTTONCLOSE, OnButtonclose)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CUpdateEquip message handlers

void CUpdateEquip::OnCancel() 
{
	// TODO: Add extra cleanup here
	
	CDialog::OnCancel();
}

void CUpdateEquip::OnOK() 
{

}

BOOL CUpdateEquip::OnInitDialog() 
{
	CDialog::OnInitDialog();
	SetIcon(m_Hicon,true);
	/**************************设计工具栏********************************/
	toolbar.Create(TBSTYLE_FLAT|CCS_TOP|WS_CHILD|WS_VISIBLE|WS_BORDER|CCS_ADJUSTABLE|TBSTYLE_WRAPABLE,CRect(0,0,0,0),this,IDR_TOOLBAR2);
	toolbar.SetBitmapSize(CSize(32,32));
	imagelist.Create(32,32,ILC_COLOR32|ILC_MASK,0,0);
	for (int n =0;n<5;n++)
	{
		imagelist.Add(theApp.LoadIcon(n+IDI_ICON1));
	}	
	toolbar.SetImageList(&imagelist);
	TBBUTTON  buttons[4];
	for (int i =0; i<4;i++)
	{
		CString str;
		int strlength;
		CCHAR *temp;
		if (i<1)
			buttons[i].fsStyle =TBSTYLE_SEP;
		else
		{
			buttons[i].fsStyle =TBSTYLE_BUTTON;
		}
		buttons[i].fsState =TBSTATE_ENABLED;
		buttons[i].dwData =0;
		if ((i ==2)|(i==3))
		{
			buttons[i].idCommand = ID_BUTTONADD+i+1;
			buttons[i].iBitmap = i+1;
			str.LoadString(ID_BUTTONADD+i+1);
		}

		else
		{
			buttons[i].idCommand = ID_BUTTONADD+i;
			buttons[i].iBitmap = i;
			str.LoadString(ID_BUTTONADD+i);
		}
		strlength = str.GetLength()+1;
		temp = str.GetBufferSetLength(strlength);
		temp[strlength]= '\0';
		temp[strlength-1]= '\0';
		buttons[i].iString = toolbar.AddStrings(temp);		
		str.ReleaseBuffer();
	}
	toolbar.AutoSize();
	toolbar.AddButtons(4,buttons);
	toolbar.ShowWindow(SW_SHOW);	
	/*****************************初始化列表****************************/
	list.SetExtendedStyle(LVS_REPORT|LVS_EX_FULLROWSELECT|LVS_OWNERDRAWFIXED |LVS_EX_FLATSB|LVS_SHOWSELALWAYS|LVS_EX_HEADERDRAGDROP);
	list.InsertColumn(100,"资产编号");
	list.InsertColumn(100,"资产名称");
	list.InsertColumn(100,"资产类别");
	list.InsertColumn(100,"增加方式");
	list.InsertColumn(100,"入账原值");
	list.InsertColumn(100,"累计折旧");
	list.InsertColumn(100,"净值");
	list.InsertColumn(100,"规格");
	list.InsertColumn(100,"使用状态");
	list.InsertColumn(100,"预计净残值率");
	list.InsertColumn(100,"预计净残值");
	list.InsertColumn(100,"入账日期");
	list.InsertColumn(100,"预计使用月份");
	list.InsertColumn(100,"已计提月份");
	list.InsertColumn(100,"折旧方法");
	list.InsertColumn(100,"月折旧率");
	list.InsertColumn(100,"月折旧额");
	for (i =0 ;i<17;i++)
		list.SetColumnWidth(i,100);
	OnButtonrefresh();
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CUpdateEquip::OnButtonrefresh() 
{
	AddEquipKinds();
	AddEquipMode();	
	AddUseState();
	AddQueryCondition();
	ClearText();
	list.DeleteAllItems();
}

void CUpdateEquip::ClearText()
{
	CWnd * temp;
	temp = this;
	for (int i= 0;i<16;i++)
	{
		temp = this->GetNextDlgTabItem(temp);
		temp->SetWindowText("");
	}
	//设置日期
	CTime t=CTime::GetCurrentTime();
	regdate.SetTime(&t);
	equipid.SetWindowText("");
}

void CUpdateEquip::AddEquipKinds()
{
	_RecordsetPtr temp;
	temp =theApp.datamanage->Record1; 
	temp->raw_Close();
	temp->Open("select kinds from tb_kinds",theApp.datamanage->GetConn().GetInterfacePtr(),adOpenKeyset,adLockPessimistic,adCmdText);
	if (temp->RecordCount>0) //如果有数据,利用循环向组合框中添加数据
	{
		equipkinds.ResetContent();
		while (!temp->ADOEOF)
		{
			CString str;
			str = temp->GetFields()->GetItem("kinds")->Value.bstrVal;
			equipkinds.AddString(str);
			temp->MoveNext();
		}
	}
}

void CUpdateEquip::AddEquipMode()
{
	_RecordsetPtr temp;
	temp =theApp.datamanage->Record1; 
	temp->raw_Close();
	temp->Open("select addkinds from tb_addkinds",theApp.datamanage->GetConn().GetInterfacePtr(),adOpenKeyset,adLockPessimistic,adCmdText);
	if (temp->RecordCount>0) //如果有数据,利用循环向组合框中添加数据
	{
		addkinds.ResetContent();
		while (!temp->ADOEOF)
		{
			CString str;
			str = temp->GetFields()->GetItem("addkinds")->Value.bstrVal;
			addkinds.AddString(str);
			temp->MoveNext();
		}
	}
}

void CUpdateEquip::AddUseState()
{
		_RecordsetPtr temp;
	temp =theApp.datamanage->Record1; 
	temp->raw_Close();
	temp->Open("select usestate from tb_usestate",theApp.datamanage->GetConn().GetInterfacePtr(),adOpenKeyset,adLockPessimistic,adCmdText);
	if (temp->RecordCount>0) //如果有数据,利用循环向组合框中添加数据
	{
		usestate.ResetContent();
		while (!temp->ADOEOF)
		{
			CString str;
			str = temp->GetFields()->GetItem("usestate")->Value.bstrVal;
			usestate.AddString(str);
			temp->MoveNext();
		}
	}
}

void CUpdateEquip::AddQueryCondition()
{
	_RecordsetPtr temp;
	temp =theApp.datamanage->Record1; 
	temp->raw_Close();
	temp->Open("select distinct name from tb_equipmentinfo",theApp.datamanage->GetConn().GetInterfacePtr(),adOpenKeyset,adLockPessimistic,adCmdText);
	querycondition.ResetContent();
	while (!temp->ADOEOF)
	{
		CString str;
		str = temp->GetFields()->GetItem("name")->Value.bstrVal;
		querycondition.AddString(str);
		temp->MoveNext();
	}
}

void CUpdateEquip::OnQuery() 
{
	CString str;
	querycondition.GetWindowText(str);
	if(!str.IsEmpty())
	{
		_RecordsetPtr temp;
		list.DeleteAllItems();
		temp =theApp.datamanage->Record1; 
		temp->raw_Close();
		CString sql;
		sql.Format("select * from tb_equipmentinfo where name like '%s%%'",str);
		temp->Open((_bstr_t)sql,theApp.datamanage->GetConn().GetInterfacePtr(),adOpenKeyset,adLockPessimistic,adCmdText);		
		if (temp->RecordCount>0)
		{
			int row = 0;
			while (!temp->ADOEOF)
			{
				list.InsertItem(row,"",0);
				for (int i= 0;i<temp->GetFields()->Count-1;i++)
				{
					CString str;
					_variant_t value;
					value = temp->GetFields()->GetItem((long)i)->Value;
					str = (TCHAR *)(_bstr_t)value;
					list.SetItemText(row,i,str);
				}
				row +=1;
				temp->MoveNext();
			}