clerkdlg.cpp

学校图书馆信息化计划核心----图书管理系统vc版V2.0

// ClerkDlg.cpp : implementation file
//

#include "stdafx.h"
#include "library.h"
#include "ClerkDlg.h"
#include "ClerkSet.h"
#include "BookLibSet.h"
#include "BookInDlg.h"
#include "BookLoanSet.h"
#include "BookOp.h"
#include "OverDlg.h"
#include "BookInfDlg.h"
#include "BookingSet.h"
#include "InfoDlg.h"
#include "ReadSet.h"
#include "NEWLOGIN.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// CClerkDlg dialog
CBookLibSet m_bookset;
CClerkSet m_clerkset;
CBookLoanSet m_bookloanset;
CBookingSet m_bookingset;
CReadSet  readset1;
int     operatenumber=0;
CClerkDlg::CClerkDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CClerkDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CClerkDlg)
	m_message = _T("");
	m_pwd = _T("");
	m_pwdname = _T("");
	m_clerkid = _T("");
	m_id = _T("");
	m_name = _T("");
	//}}AFX_DATA_INIT
}


void CClerkDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CClerkDlg)
	DDX_Text(pDX, IDC_MESSAGE, m_message);
	DDX_Control(pDX, IDC_MSFLEXGRID, m_grid);
	DDX_Control(pDX, IDC_MSFLEXGRID1, m_grid1);
	DDX_Text(pDX, IDC_PWD, m_pwd);
	DDX_Text(pDX, IDC_PWDNAME, m_pwdname);
	DDX_Text(pDX, IDC_CLERKID, m_clerkid);
	DDX_Text(pDX, IDC_ID, m_id);
	DDX_Text(pDX, IDC_Name, m_name);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CClerkDlg, CDialog)
	//{{AFX_MSG_MAP(CClerkDlg)
	ON_BN_CLICKED(IDC_SUBMIT, OnSubmit)
	ON_BN_CLICKED(IDC_RESET, OnReset)
	ON_BN_CLICKED(IDC_BOOKIN, OnBookin)
	ON_BN_CLICKED(IDC_DELETE, OnDelete)
	ON_BN_CLICKED(IDC_BOOKINF, OnBookinf)
	ON_BN_CLICKED(IDC_BOOKLOAN, OnBookloan)
	ON_BN_CLICKED(IDC_BOOKBACK, OnBookback)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CClerkDlg message handlers

BOOL CClerkDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
    GetDlgItem(IDC_BOOKIN)->EnableWindow(false);
	GetDlgItem(IDC_BOOKINF)->EnableWindow(false);
	GetDlgItem(IDC_BOOKLOAN)->EnableWindow(false);
   	GetDlgItem(IDC_BOOKBACK)->EnableWindow(false);
    GetDlgItem(IDC_MSFLEXGRID1)->EnableWindow(false);
    GetDlgItem(IDC_MSFLEXGRID)->EnableWindow(false);
	GetDlgItem(IDC_DELETE)->EnableWindow(false);
	GetDlgItem(IDC_ID)->ShowWindow(SW_HIDE);
	GetDlgItem(IDC_Name)->ShowWindow(SW_HIDE);
	m_grid.SetRows(100);
	m_grid.SetCols(5);
	m_grid1.SetRows(2);
	m_grid1.SetCols(5);
	m_grid.SetRow(0);
	m_grid.SetCol(0);
	m_grid.SetText("操作编号");
	m_grid.SetCol(1);
	m_grid.SetText("操作");
	m_grid.SetCol(2);
	m_grid.SetText("书名");
	m_grid.SetCol(3);
	m_grid.SetText("操作时间");
	m_grid.SetCol(4);
	m_grid.SetText("执行者");

	m_grid1.SetRow(0);
	m_grid1.SetCol(0);
	m_grid1.SetText("操作编号");
	m_grid1.SetCol(1);
	m_grid1.SetText("操作");
	m_grid1.SetCol(2);
	m_grid1.SetText("书名");
	m_grid1.SetCol(3);
	m_grid1.SetText("操作时间");
	m_grid1.SetCol(4);
	m_grid1.SetText("执行者");
    m_message="尚未登陆!";
	m_pwdname="密码:";
	UpdateData(false);
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CClerkDlg::OnSubmit() 
{
	// TODO: Add your control notification handler code here
	if(m_clerkset.IsOpen())
		ASSERT(FALSE);
	try
	{
		m_clerkset.Open();
	}
	catch(CDBException *e)
	{
		AfxMessageBox(e->m_strError);
	}

   	UpdateData(true);
/*	m_clerkset.Close();
	m_clerkset.m_strFilter="clerkid='"+m_clerkid+"' AND "+"Clerkpassword='"+m_pwd+"'";
	m_clerkset.Open();
	int recCount=m_clerkset.GetRecordCount();	
	if(recCount==0)
	{
		MessageBox("登陆失败!");
		m_clerkid="";
		m_pwd="";
		UpdateData(false);
		m_clerkset.Close();
	}
	else
	{*/
		m_message="登陆成功";
		m_pwdname="用户名:";
		m_id=m_clerkid;
		m_name=m_clerkset.m_Clerkname;
		UpdateData(false);
		m_clerkset.Close();
   	    GetDlgItem(IDC_BOOKIN)->EnableWindow();
    	GetDlgItem(IDC_BOOKINF)->EnableWindow();
    	GetDlgItem(IDC_BOOKLOAN)->EnableWindow();
      	GetDlgItem(IDC_BOOKBACK)->EnableWindow();
        GetDlgItem(IDC_MSFLEXGRID1)->EnableWindow();
        GetDlgItem(IDC_MSFLEXGRID)->EnableWindow();
    	GetDlgItem(IDC_DELETE)->EnableWindow();

        GetDlgItem(IDC_CLERKID)->ShowWindow(SW_HIDE);
        GetDlgItem(IDC_PWD)->ShowWindow(SW_HIDE);
        GetDlgItem(IDC_SUBMIT)->ShowWindow(SW_HIDE);
        GetDlgItem(IDC_RESET)->ShowWindow(SW_HIDE);
        GetDlgItem(IDC_ID)->ShowWindow(SW_SHOW);
        GetDlgItem(IDC_Name)->ShowWindow(SW_SHOW);
		readset1.m_strFilter="lever=0";
		readset1.Open();
		if(!readset1.IsEOF())
		{
             CNEWLOGIN newlogin;
			 newlogin.DoModal();
		}
		readset1.Close();

//	}

}

void CClerkDlg::OnReset() 
{
	// TODO: Add your control notification handler code here
	m_clerkid="";
	m_pwd="";
	UpdateData(false);
}

void CClerkDlg::OnBookin() 
{
	// TODO: Add your control notification handler code here
	time_t now;	
	CString str;
    now = time(0);
    struct tm *pnow;
    pnow = localtime(&now);
	m_bookset.m_strFilter="";
	m_bookset.Open();
	long recordnum=0;
	m_bookset.Close();
	m_bookset.Open();

    recordnum=0;
	if(m_bookset.IsEOF())
	{
	}
	else
	{
     m_bookset.MoveFirst();
	 while(!m_bookset.IsEOF())
	 {
		recordnum++;
		m_bookset.MoveNext();
	 }
	}
	m_bookset.Close();
	recordnum+=100000000;
	str.Format("%d",recordnum+1);
	CBookInDlg a;
	a.m_bookid=str;
	CString Type;
	if(a.DoModal()==IDOK)
	{
		switch(a.type)
		{
		case 0:Type="TN";
			   break;
		case 1:Type="TQ";
			   break;
		case 2:Type="TP";
			break;
		case 3:Type="YU";
			break;
		case 4:Type="G";
			break;
		case 5:Type="F";
			break;
		case 6:Type="Q";
			break;
		case 7:Type="O";
			break;
		case 8:Type="HO";
			break;
		case 9:Type="D";
			break;
		}
		m_bookset.m_strFilter="Type='"+Type+"'";
		m_bookset.Open();
		long typenum=0;
		while(!m_bookset.IsEOF())
		{
			typenum++;
			m_bookset.MoveNext();
		}
		m_bookset.Close();
		typenum+=10000;
		m_bookset.m_strFilter="";
		m_bookset.Open();
        int i=a.m_booknum;typenum++;
		for(int j=0;j<i;j++)
		{
			recordnum++;
			
	        str.Format("%d",recordnum);
			m_bookset.AddNew();
			m_bookset.m_Bookid=str;
			m_bookset.m_Bookname=a.m_bookname;
			m_bookset.m_Bookauthor=a.m_bookauthor;
			m_bookset.m_Bookconcern=a.m_bookpub;
			m_bookset.m_Handler=m_name;
			m_bookset.m_numbers=a.m_booknum;
			m_bookset.m_Inputdate=now;
			str.Format("%d",typenum);
			m_bookset.m_Typeid=Type+str;
			m_bookset.m_Status=1;
			m_bookset.m_Type=Type;
			m_bookset.Update();
			m_bookset.Requery();
			UpdateData(false);
		    	
		}
		operatenumber++;
		m_grid.SetRow(operatenumber);
	    m_grid.SetCol(0);
		str.Format("%d",operatenumber);
		m_grid.SetText(str);
		m_grid.SetCol(1);
		m_grid.SetText("新书入库");
		m_grid.SetCol(2);
		m_grid.SetText(a.m_bookname);
		m_grid.SetCol(3);
		str.Format(_T("%02d:%02d:%02d"),pnow->tm_hour,pnow->tm_min,pnow->tm_sec);
		m_grid.SetText(str);
		m_grid.SetCol(4);
		m_grid.SetText(m_name);

		m_grid1.SetRow(1);
		m_grid1.SetCol(0);
		m_grid1.SetText("当前操作");
		m_grid1.SetCol(1);
		m_grid1.SetText("新书入库");
		m_grid1.SetCol(2);
		m_grid1.SetText(a.m_bookname);
		m_grid1.SetCol(3);
		m_grid1.SetText(str);
		m_grid1.SetCol(4);
		m_grid1.SetText(m_name);
	
	}
	m_bookset.Close();
}

void CClerkDlg::OnDelete() 
{
	// TODO: Add your control notification handler code here

		CString str;
	 	   	m_grid1.SetRow(1);
	    	m_grid1.SetCol(0);
			str=m_grid1.GetText();
			if(str=="该操作取消")
			{
				MessageBox("已经执行取消操作！");
			}
			else
			{


	         	m_grid1.SetCol(1);   
				str=m_grid1.GetText();
	        	if(str=="新书入库")
				{