repair.cpp

直接打开

// Repair.cpp: implementation of the CRepair class.
//
//////////////////////////////////////////////////////////////////////

#include "stdafx.h"
#include "AssetsMan.h"
#include "Repair.h"
#include "ADOConn.h"

#ifdef _DEBUG
#undef THIS_FILE
static char THIS_FILE[]=__FILE__;
#define new DEBUG_NEW
#endif

//////////////////////////////////////////////////////////////////////
// Construction/Destruction
//////////////////////////////////////////////////////////////////////

CRepair::CRepair()
{

}

CRepair::~CRepair()
{

}

// *********************属性设置***************************//
void CRepair::SetId(int iId)
{
	Id = iId;
}
int CRepair::GetId()
{
	return Id;
}
void CRepair::SetAid(CString cAid)
{
	Aid = cAid;
}
CString CRepair::GetAid()
{
	return Aid;
}
void CRepair::SetUnit(CString cUnit)
{
	Unit = cUnit;
}
CString CRepair::GetUnit()
{
	return Unit;
}
void CRepair::SetRepairDate(CString cRepairDate)
{
	RepairDate = cRepairDate;
}
CString CRepair::GetRepairDate()
{
	return RepairDate;
}
void CRepair::SetReason(CString cReason)
{
	Reason = cReason;
}
CString CRepair::GetReason()
{
	return Reason;
}
void CRepair::SetStatus(int iStatus)
{
	Status = iStatus;
}
int CRepair::GetStatus()
{
	return Status;
}
void CRepair::SetTotal(float fTotal)
{
	Total = fTotal;
}
float CRepair::GetTotal()
{
	return Total;
}
void CRepair::SetResult(CString cResult)
{
	Result = cResult;
}
CString CRepair::GetResult()
{
	return Result;
}
void CRepair::SetPostDate(CString cPostDate)
{
	PostDate = cPostDate;
}
CString CRepair::GetPostDate()
{
	return PostDate;
}

//*******************数据库操作方法***********************//
// ******插入维修记录*******//
void CRepair::sql_Insert()
{
	try
	{
		//连接数据库
		ADOConn m_AdoConn;
		_bstr_t bSQL;
		CString sTot;
		sTot.Format("%f",Total);
		bSQL = "Insert Into Repair(Aid,RepairDate,Unit,Reason,Status,Total,Result,PostDate) Values('"
			+Aid+"','"+RepairDate+"','"+Unit+"','"+Reason+"',0,"+sTot+",'"+Result+"','"+PostDate+"')";
//		AfxMessageBox(bSQL);
		m_AdoConn.ExecuteSQL(bSQL);
		//断开与数据库的连接
		m_AdoConn.ExitConnect();
	}
	// 捕捉异常
	catch(_com_error e)
	{
		// 显示错误信息
		AfxMessageBox(e.Description());
	}
}
// ******更新维修记录*******//
void CRepair::sql_Update(CString cId)
{
	try
	{
		//连接数据库
		ADOConn m_AdoConn;
		_bstr_t bSQL;
		CString sTot;
		sTot.Format("%f",Total);
		bSQL = "Update Repair Set Aid='"+Aid+"',RepairDate='"+RepairDate+"',"
			+"Reason = '"+Reason+"',"
			+"Unit='"+Unit+"',Total="+sTot+",Result='"+Result+"' Where Id="+cId;
		m_AdoConn.ExecuteSQL(bSQL);
		//断开与数据库的连接
		m_AdoConn.ExitConnect();
	}
	// 捕捉异常
	catch(_com_error e)
	{
		// 显示错误信息
		AfxMessageBox(e.Description());
	}
}
// ******删除维修记录*******//
void CRepair::sql_Delete(CString cId)
{
	try
	{
		//连接数据库
		ADOConn m_AdoConn;
		_bstr_t bSQL;
		bSQL = "Delete From Repair Where Id="+cId;
		m_AdoConn.ExecuteSQL(bSQL);
		//断开与数据库的连接
		m_AdoConn.ExitConnect();
	}
	// 捕捉异常
	catch(_com_error e)
	{
		// 显示错误信息
		AfxMessageBox(e.Description());
	}
}
//**更改状态值从0-1表示资产维修完毕**//
void CRepair::UpdateStatus(CString cId)
{
	try
	{
		//连接数据库
		ADOConn m_AdoConn;
		_bstr_t bSQL;
		bSQL = "Update Repair Set Status=1 Where Id="+cId;
		m_AdoConn.ExecuteSQL(bSQL);
		//断开与数据库的连接
		m_AdoConn.ExitConnect();
	}
	// 捕捉异常
	catch(_com_error e)
	{
		// 显示错误信息
		AfxMessageBox(e.Description());
	}
}