database.h

连接SQL数据库的系统源码,对于初学者十分有参考价值哦

// Database.h: interface for the CDatabase class.
//
//////////////////////////////////////////////////////////////////////

#if !defined(AFX_DATABASE_H__47884258_06F8_4552_8C2A_7CA998F60EFE__INCLUDED_)
#define AFX_DATABASE_H__47884258_06F8_4552_8C2A_7CA998F60EFE__INCLUDED_

#if _MSC_VER > 1000
#pragma once
#endif // _MSC_VER > 1000

class CDatabase  
{
public:
	void EditCancelinToCtrl(char *m_szCancelID, CEdit *m_hEditunitprice,CEdit *m_hEditSumTotal,CEdit *m_hEditRebate,CEdit *m_hEditProviderid,CEdit *m_hEditprincipal,CEdit *m_hEditPaymoney,CEdit *m_hEditOperator,CEdit *m_hEditmerchandiseID,CEdit *m_hEditFactmoney,CEdit *m_hEditCancelnum,CEdit *m_hEditCancelID);
	void UpdateCalcelinData(char *unitprice, char *SumTotal, char *Rebate, char *Providerid, char *principal, char *Paymoney, char *Operator,char *merchandiseID,char *Factmoney,char *Cancelnum,char *CancelID) ;
	void ListCancelinToCtrl(CListCtrl *m_hListCtrl);
	void EditIntostorageToCtrl(char *ID, CEdit *m_hEditID, CEdit *m_hEditOperatorID, CEdit *m_hEditOrderform);
	void UpdateIntostorageData(char *ID,char *OperatorID,char *Orderform);
	void ListIntostorageToCtrl(CListCtrl *m_hListCtrl);
	void EditStockApplyToCtrl(char *m_szAppid, CComboBox *m_hCmbDepartment,CEdit *m_hEditUnitprice,CEdit *m_hEditSum,CEdit *m_hEditStockname,CEdit *m_hEditRebate,CEdit *m_hEditPurpose,CEdit *m_hEditProviderid,CEdit *m_hEditProposer,CEdit *m_hEditPaymoney,CEdit *m_hEditOrderform,CEdit *m_hEditMerchandiseID,CEdit *m_hEditMemo,CEdit *m_hEditBillmaker,CEdit *m_hEditAppid);
	void UpdateStockApplyData(char *Department, char *unitprice,char *sum,char *StockName,char *Rebate,char *Purpose,char *providerid,char *orderform,char *proposer,char *Paymoney,char *merchandiseID,char *memo,char *Billmaker,char *Appid);
	void ListStockApplyToCtrl(CListCtrl *m_hListCtrl);
	void UpdateKcData(char *merchandiseID, char *storagename, char *Storagenum);
	void EditKcToCtrl(char *merchandiseID, CEdit *m_hEditSpbh, CEdit *m_hEditKcmc, CEdit *m_hEditKcsl);
	void ListKcglToCtrl(CListCtrl *m_hListCtrl);
	void UpdateSpxxData(char *m_szZjm, char *m_szName, char *m_szID, char *m_szGg, char *m_szMrjg, char *m_szCj, char *m_szBz);
	void EditSpxxToCtrl(char *ID, CEdit *m_hEditZjm, CEdit *m_hEditName,	CEdit *m_hEditMrjg, CEdit *m_hEditGg, CEdit *m_hEditCj,	CEdit *m_hEditBz, CEdit *m_hEditSpbh);
	void ListSpxxToCtrl(CListCtrl *m_hListCtrl);
	void EditOperatorToCtrl(char *m_szID, CEdit *m_hEditID,CEdit *m_hEditName,CEdit *m_hEditPassword,CComboBox* m_hCmbRole);
	void UpdateOperatorData(char *m_szID, char *m_szName, char *m_szPassword, char *m_szRole);
	void ListOperatorToCtrl(CListCtrl *m_hListCtrl);
	void InitOperatorData(CComboBox *m_hCmbRole);
	void UpdateRoleinfoData(char *m_szName);
	void ListRoleInfoToCtrl(CListCtrl *m_hListCtrl);
	void UpdateSysFunctionInfoData(char *m_szFuncInfo);
	void ListSysFunctionInfoToCtrl(CListCtrl *m_hListCtrl);
	void InitEmployeeData(CComboBox *m_hCmbEmployee);
	void EditEmployeeToCtrl(char *m_szEmployeeID,CEdit *m_hEditSex,CEdit *m_hEditPhone,CEdit *m_hEditNationality,CEdit *m_hEditName,CEdit *m_hEditKnowledge,CEdit *m_hEditEmployeeID,CComboBox *m_hCmbDepartment,CEdit *m_hEditAge,CEdit *m_hEditAddress,CEdit *m_hEditAcademy);
	void UpdateEmployeeData(char *EmployeeID, char *Name, char *Sex, char *Age, char *Knowledge, char *Nationality, char *Academy, char *Phone, char *Address, char *department);
	void ListEmployeeToCtrl(CListCtrl *m_hListCtrl);
	void UpdateDepartmentData(char *m_szName);
	void DeleteDataWhere(int m_nIndex, char *Fond);
	void ListDepartmentToCtrl(CListCtrl *m_hListCtrl);
	int InitData();
	CDatabase();
	virtual ~CDatabase();
private:
	void UpdateKczjData(char *storagename);
	_ConnectionPtr m_Connection ;//数据库链接句柄
};

#endif // !defined(AFX_DATABASE_H__47884258_06F8_4552_8C2A_7CA998F60EFE__INCLUDED_)