workparttimedlg.cpp

这是一个学生信息管理系统

// WorkParttimeDlg.cpp : 实现文件
//

#include "stdafx.h"
#include "SMS.h"
#include "WorkParttimeDlg.h"


// CWorkParttimeDlg 对话框

IMPLEMENT_DYNAMIC(CWorkParttimeDlg, CDialog)

CWorkParttimeDlg::CWorkParttimeDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CWorkParttimeDlg::IDD, pParent)
	, m_iParttimeAmount(0)
	, m_pSet(&theApp.m_db )
{
	//显示窗口颜色
	m_backcolor=m_RGB_BkColor;
	m_brush.CreateSolidBrush(m_backcolor);
	m_bItemClick=false;
}

CWorkParttimeDlg::~CWorkParttimeDlg()
{
}

void CWorkParttimeDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	DDX_Control(pDX, IDC_WORK_PARTTIME_LIST, m_cParttimeListCtrl);
	DDX_Text(pDX, IDC_PARTTIME_AMOUNT_STATIC, m_iParttimeAmount);
	DDX_Control(pDX, IDC_WORK_PARTTIME_DELETE_BT, m_cDeleteBt);
	DDX_Control(pDX, IDC_WORK_PARTTIME_UPDATE_BT, m_cUpdateBt);
	DDX_Control(pDX, IDC_WORK_PARTTIME_PRINT_BT, m_cPrintBt);
}


BEGIN_MESSAGE_MAP(CWorkParttimeDlg, CDialog)
	ON_BN_CLICKED(IDC_WORK_PARTTIME_ALL_BT, &CWorkParttimeDlg::OnBnClickedWorkParttimeAllBt)
	ON_BN_CLICKED(IDC_WORK_PARTTIME_ADD_BT, &CWorkParttimeDlg::OnBnClickedWorkParttimeAddBt)
	ON_BN_CLICKED(IDC_WORK_PARTTIME_UPDATE_BT, &CWorkParttimeDlg::OnBnClickedWorkParttimeUpdateBt)
	ON_BN_CLICKED(IDC_WORK_PARTTIME_DELETE_BT, &CWorkParttimeDlg::OnBnClickedWorkParttimeDeleteBt)
	ON_BN_CLICKED(IDC_WORK_PARTTIME_SEARCH_BT, &CWorkParttimeDlg::OnBnClickedWorkParttimeSearchBt)
	ON_WM_QUERYDRAGICON()//打印
	ON_BN_CLICKED(IDC_WORK_PARTTIME_PRINT_BT, &CWorkParttimeDlg::OnBnClickedWorkParttimePrintBt)
	ON_WM_CTLCOLOR()
	ON_NOTIFY(HDN_ITEMCLICK, 0, &CWorkParttimeDlg::OnHdnItemclickWorkParttimeList)
	ON_WM_CLOSE()
	ON_WM_CONTEXTMENU()
	ON_WM_TIMER()
	ON_COMMAND(ID_PARTTIME_ALL, &CWorkParttimeDlg::OnParttimeAll)
	ON_COMMAND(ID_PARTTIME_ADD, &CWorkParttimeDlg::OnParttimeAdd)
	ON_COMMAND(ID_PARTTIME_UPDATE, &CWorkParttimeDlg::OnParttimeUpdate)
	ON_COMMAND(ID_PARTTIME_DELETE, &CWorkParttimeDlg::OnParttimeDelete)
	ON_COMMAND(ID_PARTTIME_SEARCH, &CWorkParttimeDlg::OnParttimeSearch)
	ON_COMMAND(ID_PARTTIME_PRINT, &CWorkParttimeDlg::OnParttimePrint)
    ON_UPDATE_COMMAND_UI(ID_PARTTIME_UPDATE, &CWorkParttimeDlg::OnUpdateParttimeUpdate )
	ON_UPDATE_COMMAND_UI(ID_PARTTIME_DELETE, &CWorkParttimeDlg::OnUpdateParttimeDelete )
	ON_UPDATE_COMMAND_UI(ID_PARTTIME_PRINT, &CWorkParttimeDlg::OnUpdateParttimePrint )
    ON_WM_INITMENUPOPUP()
END_MESSAGE_MAP()


// CWorkParttimeDlg 消息处理程序

void CWorkParttimeDlg::OnBnClickedWorkParttimeAllBt()
{
	// TODO: 在此添加控件通知处理程序代码
	ViewAll();
}

void CWorkParttimeDlg::Add()
{
	CString s;
	int Length;
	CWorkParttimeAddDlg dlg;
	if(dlg.DoModal ()==IDOK)
	{
		if(!theApp.m_db.CanTransact ())
		{
			//虽然不支持事务处理的数据库很少，但是我强硬地不允许这种情况出现
			MessageBox(L"\n系统不支持事务处理，添加不成功！\n",L"错误", MB_ICONSTOP);
			return ;                                    
		}
		theApp.m_db.BeginTrans ();//开始事务处理
		TRY
		{
	        m_pSet.Open (AFX_DB_USE_DEFAULT_TYPE,L"Select * from Parttime order by pStartDate");
		    m_pSet.m_strFilter.Empty ();
			m_pSet.AddNew ();
			m_pSet.m_pName =dlg.m_sName ;
			m_pSet.m_pPlace =dlg.m_sPlace ;
			m_pSet.m_pStartDate =dlg.m_tStartDate ;
			m_pSet.m_pEndDate =dlg.m_tEndDate ;
			m_pSet.m_pLinkMan =dlg.m_sLinkMan ;
			m_pSet.m_pTotalWage =dlg.m_dTotalWage ;
			m_pSet.m_pWagePayed =dlg.m_dWagePayed ;
			m_pSet.m_pRemark =dlg.m_sRemark ;
			m_pSet.Update ();
			m_pSet.MoveLast ();
		    m_pSet.Close ();
            theApp.m_db.CommitTrans ();//添加成功了
		}
		CATCH_ALL(e)
		{
			theApp.m_db.Rollback ();
		    MessageBox(L"\n事务处理出错，添加失败！\n",L"错误", MB_ICONSTOP);
			return;
	    }
	    END_CATCH_ALL
		//添加成功了，就要在列表中显示出来
	    m_cParttimeListCtrl.InsertItem(0,dlg.m_sName ,0);
		m_cParttimeListCtrl.SetItemText (0,1,dlg.m_sPlace );
        m_cParttimeListCtrl.SetItemText (0,2,FormatDate(dlg.m_tStartDate ) );
	    m_cParttimeListCtrl.SetItemText (0,3,FormatDate(dlg.m_tEndDate ) );
		m_cParttimeListCtrl.SetItemText (0,4,dlg.m_sLinkMan );
		s.Format (L"%f",dlg.m_dTotalWage );
		Length=s.GetLength ();
		s.Delete (Length-4,4);
		m_cParttimeListCtrl.SetItemText (0,5,s );
		s.Format (L"%f",dlg.m_dWagePayed );
		Length=s.GetLength ();
		s.Delete (Length-4,4);
		m_cParttimeListCtrl.SetItemText (0,6,s );
	    m_cParttimeListCtrl.SetItemText (0,7,dlg.m_sRemark );
        s.Format (L"%d",m_pSet.m_pId );
		m_cParttimeListCtrl.SetItemText (0,8,s);
		//然后再在个数中加一,显示给用户
		m_iParttimeAmount++;
		s.Format (L"%d",m_iParttimeAmount);
		SetDlgItemText(IDC_PARTTIME_AMOUNT_STATIC,s);//显示
	}
}
void CWorkParttimeDlg::OnBnClickedWorkParttimeAddBt()
{
	// TODO: 在此添加控件通知处理程序代码
    Add();
}

void CWorkParttimeDlg::Update()
{
	CString s;
	int Length;
	POSITION pos = m_cParttimeListCtrl.GetFirstSelectedItemPosition();
    if (pos == NULL)
	{
		MessageBox(L"你没有选择要修改的兼职\n请在列表中选择要修改的兼职！",L"提示",MB_ICONEXCLAMATION);
		return ;//没有选择表项则不用做下面的事情
	}
    else
    {
		if(!theApp.m_db.CanTransact ())
		{
			//虽然不支持事务处理的数据库很少，但是我强硬地不允许这种情况出现
			MessageBox(L"\n系统不支持事务处理，修改不成功！\n",L"错误", MB_ICONSTOP);
			return ;                                    
		}
	    int nItem = m_cParttimeListCtrl.GetNextSelectedItem(pos);//列表中的项目序号也即数据库中的编号
		//下面获取该表项的数据，用于在修改对话框中显示
		int Id=_ttol(m_cParttimeListCtrl.GetItemText (nItem,8));
		if(m_pSet.IsOpen ())
			m_pSet.Close ();
		m_pSet.Open ();
		m_pSet.m_strFilter .Empty ();
		m_pSet.MoveFirst ();
		while(!m_pSet.IsEOF ())
		{
			if(m_pSet.m_pId ==Id)//说明找到了相应的那个字段
			{
				m_sWorkParttime_Name=m_pSet.m_pName ;
			    m_sWorkParttime_Place=m_pSet.m_pPlace ;
				m_tWorkParttime_StartDate=m_pSet.m_pStartDate ;
				m_tWorkParttime_EndDate=m_pSet.m_pEndDate ;
				m_sWorkParttime_LinkMan=m_pSet.m_pLinkMan ;
				m_dWorkParttime_TotalWage=m_pSet.m_pTotalWage ;
				m_dWorkParttime_WagePayed=m_pSet.m_pWagePayed ;
				m_sWorkParttime_Remark=m_pSet.m_pRemark ;
				m_iWorkParttime_Id=m_pSet.m_pId ;
				break;
			}
			m_pSet.MoveNext ();
		}
		m_pSet.Close ();
		//下面弹出修改对话框，初始化数据由上面部分提供
		CWorkParttimeUpdateDlg dlg;
		if(dlg.DoModal ()!=IDOK)
		{
			return ;//万一用户没有输入正确信息，则退出，不给修改
		}
		theApp.m_db.BeginTrans ();//开始事务处理
		TRY
		{
	        m_pSet.Open (AFX_DB_USE_DEFAULT_TYPE,L"Select * from Parttime order by pStartDate");
		    m_pSet.m_strFilter.Empty ();
			m_pSet.MoveFirst ();//刚开始移动到第一个位置
			while(!m_pSet.IsEOF ())
			{
				if(m_pSet.m_pId ==m_iWorkParttime_Id)
				{
					m_pSet.Edit ();
			        m_pSet.m_pName =dlg.m_sName ;
					m_pSet.m_pPlace =dlg.m_sPlace ;
		          	m_pSet.m_pStartDate =dlg.m_tStartDate ;
		        	m_pSet.m_pEndDate =dlg.m_tEndDate ;
		        	m_pSet.m_pLinkMan =dlg.m_sLinkMan ;
		        	m_pSet.m_pTotalWage =dlg.m_dTotalWage ;
		        	m_pSet.m_pWagePayed =dlg.m_dWagePayed ;
        			m_pSet.m_pRemark =dlg.m_sRemark ;
  			        m_pSet.Update ();
			        m_pSet.Requery ();
					m_pSet.MoveNext ();
					break;
				}
				m_pSet.MoveNext ();
			}
        m_pSet.Close ();
        theApp.m_db.CommitTrans ();//修改成功了
		}
		CATCH_ALL(e)
		{
			theApp.m_db.Rollback ();
		    MessageBox(L"\n事务处理出错，修改失败！\n",L"错误", MB_ICONSTOP);
			return;
	    }
	    END_CATCH_ALL
		//修改成功了，就要把新的在列表中显示出来，同时去掉旧的
		//先去掉旧的
		m_cParttimeListCtrl.DeleteItem (nItem);
		//再添加新的
	    m_cParttimeListCtrl.InsertItem(nItem,dlg.m_sName ,0);
		m_cParttimeListCtrl.SetItemText (nItem,1,dlg.m_sPlace );
        m_cParttimeListCtrl.SetItemText (nItem,2,FormatDate(dlg.m_tStartDate ) );
	    m_cParttimeListCtrl.SetItemText (nItem,3,FormatDate(dlg.m_tEndDate ) );
		m_cParttimeListCtrl.SetItemText (nItem,4,dlg.m_sLinkMan );
		s.Format (L"%d",dlg.m_dTotalWage );
        Length=s.GetLength ();
		s.Delete (Length-4,4);
		m_cParttimeListCtrl.SetItemText (nItem,5,s);
		s.Format (L"%d",dlg.m_dWagePayed );
		Length=s.GetLength ();
		s.Delete (Length-4,4);
		m_cParttimeListCtrl.SetItemText (nItem,6,s);
	    m_cParttimeListCtrl.SetItemText (nItem,7,dlg.m_sRemark );
        s.Format (L"%d",m_iWorkParttime_Id );
		m_cParttimeListCtrl.SetItemText (nItem,8,s);
	}
}
void CWorkParttimeDlg::OnBnClickedWorkParttimeUpdateBt()
{
	// TODO: 在此添加控件通知处理程序代码
    Update();
}

void CWorkParttimeDlg::Delete()
{
	POSITION pos = m_cParttimeListCtrl.GetFirstSelectedItemPosition();
    if (pos == NULL)
	{
		MessageBox(L"\n你没有选中任何一个兼职，不可以删除！\n",L"提示",MB_ICONEXCLAMATION);
	}
    else
   {
	   if(MessageBox(L"\n此操作将永久删除该项，确定吗？\n",L"删除提醒",MB_OKCANCEL|MB_ICONQUESTION|MB_DEFBUTTON2)==IDCANCEL)
		   return ;
	   while (pos)
      {
		  int nItem = m_cParttimeListCtrl.GetNextSelectedItem(pos);
		  CString str;
		  str="Select * from Parttime order by pStartDate";
	      m_pSet.Open (AFX_DB_USE_DEFAULT_TYPE,str);
		  //获取该单词
		  int m_iId;
		  m_iId=_ttol(m_cParttimeListCtrl.GetItemText (nItem,8));
		  m_pSet.m_strFilter.Empty ();
		  m_pSet.MoveFirst ();//刚开始移动到第一个位置
		  while(!m_pSet.IsEOF ())
		  {
			  if(m_iId ==m_pSet.m_pId )
			  {
				  m_pSet.Delete ();
				  break;
			  }
			  m_pSet.MoveNext ();
		  }		 
		  if(!m_pSet.IsDeleted ())
		  {
			  MessageBox(L"\n删除失败！\n",L"错误", MB_ICONSTOP);
			  return ;
		  }
		  m_pSet.MoveNext ();
		  //数据库删除成功后就删除列表了
		  m_cParttimeListCtrl.DeleteItem (nItem);
		  m_pSet.Close ();
		  //现在在右边显示个数
	      m_iParttimeAmount--;
	      CString s;
	      s.Format (L"%d",m_iParttimeAmount);
	      SetDlgItemText(IDC_PARTTIME_AMOUNT_STATIC,s);//显示
      }
   }
}
void CWorkParttimeDlg::OnBnClickedWorkParttimeDeleteBt()
{
	// TODO: 在此添加控件通知处理程序代码
    Delete();
}

void CWorkParttimeDlg::Search()
{
    CString s;
	int Length;
	CString SearchTime;
	CString StartTime;
	CString EndTime;
	CWorkParttimeSearchDlg dlg;
	if(dlg.DoModal ()==IDOK)
	{
		BeginWaitCursor();
		if(m_pSet.IsOpen ())
			m_pSet.Close ();
		m_pSet.Open ();
		m_pSet.m_strFilter .Empty ();
		m_pSet.Requery ();
		m_cParttimeListCtrl.DeleteAllItems ();
	    int i=0;
	    if(m_pSet.GetRecordCount ()==0)
		{
			m_iParttimeAmount=i;
			CString s;
			s.Format (L"%d",m_iParttimeAmount);
			SetDlgItemText(IDC_PARTTIME_AMOUNT_STATIC,s);//显示
			MessageBox(L"\n不存在这样的记录！\n",L"提示",MB_ICONEXCLAMATION);
			m_pSet.Close ();
			EndWaitCursor();
			return ;
		}
		m_pSet.MoveFirst ();
		SearchTime=DateToString(dlg.m_tDate );
	    while (!m_pSet.IsEOF ())
	    { 
			//在这里来判断可以轻松地跳过CTime与CString的差别
		    StartTime=DateToString(m_pSet.m_pStartDate );
			EndTime=DateToString(m_pSet.m_pEndDate );
			if(StartTime<=SearchTime &&EndTime >=SearchTime )
			{
				m_cParttimeListCtrl.InsertItem(i,(CString)m_pSet.m_pName ,0);
				m_cParttimeListCtrl.SetItemText (i,1,(CString)m_pSet.m_pPlace );
                m_cParttimeListCtrl.SetItemText (i,2,FormatDate(m_pSet.m_pStartDate) );
		        m_cParttimeListCtrl.SetItemText (i,3,FormatDate(m_pSet.m_pEndDate) );
		        m_cParttimeListCtrl.SetItemText (i,4,(CString)m_pSet.m_pLinkMan );
				s.Format (L"%f",m_pSet.m_pTotalWage );
		        Length=s.GetLength ();
		        s.Delete (Length-4,4);
		        m_cParttimeListCtrl.SetItemText (i,5,s);
				s.Format (L"%f",m_pSet.m_pWagePayed );
				Length=s.GetLength ();
				s.Delete (Length-4,4);
		        m_cParttimeListCtrl.SetItemText (i,6,s);
		        m_cParttimeListCtrl.SetItemText (i,7,(CString)m_pSet.m_pRemark );
                s.Format (L"%d",m_pSet.m_pId );
		        m_cParttimeListCtrl.SetItemText (i,8,s);
                i++;
			}
			m_pSet.MoveNext ();
		}
	    m_pSet.Close ();
	    //现在在右边显示个数
		if(i==0)
		{
			 m_iParttimeAmount=i;
			CString s;
			s.Format (L"%d",m_iParttimeAmount);
			 SetDlgItemText(IDC_PARTTIME_AMOUNT_STATIC,s);//显示
			MessageBox(L"\n不存在这样的记录！\n",L"提示",MB_ICONEXCLAMATION);
			EndWaitCursor();
			return ;
		}
	    m_iParttimeAmount=i;
	    CString s;
	    s.Format (L"%d",m_iParttimeAmount);
	    SetDlgItemText(IDC_PARTTIME_AMOUNT_STATIC,s);//显示
		EndWaitCursor();
	}