sysadmtask.h

一个图书馆信息查询系统。是根据学校图书馆的实际情况调查后开发

#include <windows.h>
#include "datas.h"
#include "AdoConnect.h"
#include "resource.h"

void SysAdmTask(HWND);	//管理员图书管理
LRESULT CALLBACK dpSysAdmTask(HWND, UINT, WPARAM, LPARAM);

void SysAdmTask(HWND hWnd)
{
 	DialogBox((HINSTANCE)GetWindowLong(hWnd, GWL_HINSTANCE), 
		(LPCTSTR)IDD_SYS_TASK, hWnd, (DLGPROC)dpSysAdmTask);
}

LRESULT CALLBACK dpSysAdmTask(HWND hDlg, UINT message, WPARAM wParam, LPARAM lParam)
{
	AdoConnect ado;
	TCHAR comadm[MAX_STRING];
	TCHAR lisence[MAX_STRING];
	TCHAR str1[MAX_STRING];
 	_bstr_t bstr;
	_RecordsetPtr pr;
	
	switch (message)
	{
		case WM_INITDIALOG:
 			SendMessage(GetDlgItem(hDlg, IDC_CHECK_WITH_NAME), BM_SETCHECK, 0, 0);
 			return TRUE;

		case WM_COMMAND:
			if (LOWORD(wParam) == IDACF) //查找普管
			{
				BOOL bcomadm	= SendMessage(GetDlgItem(hDlg, IDC_CHECK_WITH_NAME), BM_GETCHECK, 0, 0);
				BOOL blisence	= SendMessage(GetDlgItem(hDlg, IDC_CHECK_WITH_LISENCE), BM_GETCHECK, 0, 0);
				if(!bcomadm && !blisence)
					return TRUE;
 				
				SendMessage(GetDlgItem(hDlg, IDC_ARF_NAME), WM_GETTEXT, MAX_STRING-1, (LPARAM)comadm);
				SendMessage(GetDlgItem(hDlg, IDC_ARF_LISENCE), WM_GETTEXT, MAX_STRING-1, (LPARAM)lisence);

				if(bcomadm && !blisence)
				{
					if(0 == lstrcmp(comadm, ""))
					{
						MessageBox(hDlg, "查找的馆员名字不能为空!", "Fail!", MB_ICONSTOP);
						return TRUE;
					}
					UniteBSTR(bstr, var "select * from comadm where name='", var comadm, var "';");
				}
				
				if(!bcomadm && blisence)
				{
					if(0 == lstrcmp(lisence, ""))
					{
						MessageBox(hDlg, "查找的馆员证号不能为空!", "Fail!", MB_ICONSTOP);
						return TRUE;
					}
					UniteBSTR(bstr, var "select * from comadm where lisence='", var lisence, var "';");
				}

				if(bcomadm && blisence)
				{			
					if(0 == lstrcmp(comadm, "") || 0 == lstrcmp(lisence, ""))
					{
						MessageBox(hDlg, "查找的馆员证号与名字不能为空!", "Fail!", MB_ICONSTOP);
						return TRUE;
					}
					UniteBSTR(bstr, var "select * from comadm where name='", var comadm, var "' and lisence='", var lisence, var "';");
				}

				ado.OnInitDBConnect();
				pr = ado.GetRecordset(bstr);
				 
				while(!pr->adoBOF && !pr->adoEOF)
				{
					wsprintf(str1, "%d ", atoi(lpstr pr->GetCollect("id")));
					UniteBSTR(bstr, var "查找的馆员: Id=", var str1, var ", 证号=", var pr->GetCollect("lisence"), var ", ", var "名字=", var pr->GetCollect("name"), var ";");
					SendMessage(GetDlgItem(hDlg, IDC_AC_LIST), LB_INSERTSTRING, 0, (LPARAM)lpstr bstr);
					pr->MoveNext();
				}

 				ado.ExitConnect();
 				return TRUE;
			}

			if (LOWORD(wParam) == IDACN) //新增馆员
			{
				SendMessage(GetDlgItem(hDlg, IDC_ACN_NAME), WM_GETTEXT, MAX_STRING-1, (LPARAM)comadm);
				SendMessage(GetDlgItem(hDlg, IDC_ACN_LISENCE), WM_GETTEXT, MAX_STRING-1, (LPARAM)lisence);
				if(0 == lstrcmp(comadm, "") || 0 == lstrcmp(lisence, ""))
				{
					MessageBox(hDlg, "新增馆员的证号与名字不能为空!", "Fail!", MB_ICONSTOP);
					return TRUE;
				}

				UniteBSTR(bstr, var "insert into comadm(name, lisence) values('", var comadm, var "', '", var lisence, var "');");
				ado.OnInitDBConnect();
				ado.ExecuteSQL(bstr);
				ado.ExitConnect();

				UniteBSTR(bstr, var "新增的馆员证号=", var lisence, var ", 名字=", var comadm, var ";");
				SendMessage(GetDlgItem(hDlg, IDC_AC_LIST), LB_INSERTSTRING, 0, (LPARAM)lpstr bstr);
				return TRUE;
			}

			if(LOWORD(wParam) == IDCANCEL) 
			{
				EndDialog(hDlg, LOWORD(wParam));
				return TRUE;
			}

			return TRUE;//WM_COMMAND end

		default:
			return FALSE;
	}
}