dwxxb.cpp

用于单位文档管理系统

// Dwxxb.cpp: implementation of the CDwxxb class.
//
//////////////////////////////////////////////////////////////////////

#include "stdafx.h"
#include "WordGLXT.h"
#include "Dwxxb.h"

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

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

CDwxxb::CDwxxb()
{

}

CDwxxb::~CDwxxb()
{

}

int CDwxxb::GetDWbh()
{
	return DWbh;
}

void CDwxxb::SetDWbh(int iDWbh)
{
	DWbh=iDWbh;
}

CString CDwxxb::GetDWmc()
{
	return DWmc;
}

void CDwxxb::SetDWmc(CString cDWmc)
{
	DWmc=cDWmc;
}

CString CDwxxb::GetLxr()
{
	return Lxr;
}

void CDwxxb::SetLxr(CString cLxr)
{
	Lxr=cLxr;
}

CString CDwxxb::GetLxdh()
{
	return Lxdh;
}

void CDwxxb::SetLxdh(CString cLxdh)
{
	Lxdh=cLxdh;
}

CString CDwxxb::GetLxdz()
{
	return Lxdz;
}

void CDwxxb::SetLxdz(CString cLxdz)
{
	Lxdz=cLxdz;
}

CString CDwxxb::GetMemo()
{
	return Memo;
}

void CDwxxb::SetMemo(CString cMemo)
{
	Memo=cMemo;
}

void CDwxxb::sql_insert()
{
    ADOConn m_AdoConn;
	CString strDWbh;
	strDWbh.Format("%d",DWbh);
	_bstr_t vSQL;
	vSQL="INSERT INTO Dwxxb(DWbh,DWmc,Lxr,Lxdh,Lxdz,Memo)VALUES("
		+strDWbh+",'"+DWmc+"','"+Lxr+"','"+Lxdh+"','"+Lxdz+"','"+Memo+"')";
    m_AdoConn.ExecuteSQL(vSQL);
    m_AdoConn.ExitConnect();
}

void CDwxxb::sql_update(int iDWbh)
{
    ADOConn m_AdoConn;
	CString strDWbh;
	strDWbh.Format("%d",iDWbh);
	_bstr_t vSQL;
	vSQL="UPDATE Dwxxb SET DWmc='"+DWmc+"',Lxr='"+Lxr+"',Lxdh='"
		+Lxdh+"',Lxdz='"+Lxdz+"',Memo='"+Memo+"' WHERE DWbh="+" "+strDWbh+"";
    m_AdoConn.ExecuteSQL(vSQL);
	m_AdoConn.ExitConnect();
}

void CDwxxb::sql_delete(int iDWbh)
{
    ADOConn m_AdoConn;
    m_AdoConn.OnInitADOConn();
	CString sql;
	sql.Format("delete from Dwxxb where DWbh='%i'",iDWbh);
	m_AdoConn.ExecuteSQL((_bstr_t)sql);
	m_AdoConn.ExitConnect();
}

void CDwxxb::Load_dep()
{
	//连接数据库
    ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
    //设置SQL语句
	_bstr_t vSQL;
	vSQL="SELECT*FROM Dwxxb ORDER BY DWbh";
    _RecordsetPtr m_pRecordset;
    m_pRecordset=m_AdoConn.GetRecordSet(vSQL);
	//初始化数组
	a_DWbh.RemoveAll();
	a_DWmc.RemoveAll();
	while(m_pRecordset->adoEOF==0)
	{
		a_DWbh.Add((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("DWbh"));
		a_DWmc.Add((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("DWmc"));
		m_pRecordset->MoveNext();
	}
	m_AdoConn.ExitConnect();
}

int CDwxxb::HaveId(int iDWbh)
{
	ADOConn m_AdoConn;
    m_AdoConn.OnInitADOConn();
	CString strDWbh;
	strDWbh.Format("%d",iDWbh);
	_bstr_t vSQL;
	vSQL="SELECT*FROM Dwxxb WHERE DWbh="+strDWbh;
	_RecordsetPtr m_pRecordset;
	m_pRecordset=m_AdoConn.GetRecordSet(vSQL);
	if(m_pRecordset->adoEOF)
		return -1;
	else 
		return 1;
	m_AdoConn.ExitConnect();
}