admingldialog.cpp

一个小型的图书管理系统,用到了access数据库,其中有三种权限的用户登陆这个系统,每种用户将拥有不同的权限,用户密码和帐户打开程序中的access便可知道.

void CAdminGLDialog::OnButtonzhadd()//添加登录帐户 
{
	// TODO: Add your control notification handler code here
	UpdateData(TRUE);
	int quanxian;
	if(m_zhname=="")
	{
		AfxMessageBox("帐户名不能为空!");
		return;
	}
	if(!ZhNameUsed())
	{
		AfxMessageBox("该帐户名已经存在!");
		return;
	}
	if(m_zhquanxian=="")
	{
		AfxMessageBox("权限不能为空!");
		return;
	}
	if(m_zhmima=="")
	{
		AfxMessageBox("密码不能为空!");
		return;
	}
	if(m_zhmmqr=="")
	{
		AfxMessageBox("密码确认不能为空!");
		return;
	}
	if(m_zhmima!=m_zhmmqr)
	{
		AfxMessageBox("密码不正确!");
		return;
	}
	if(m_zhquanxian=="普通用户")
	{
		quanxian=3;
	}
	else if(m_zhquanxian=="受限用户")
	{
		quanxian=2;
	}
	else
	{
		AfxMessageBox("没有此种权限!");
		return;
	}
	dlsource->Open();
	dlsource->AddNew();
	UpdateData(TRUE);
	dlsource->m_column1=m_zhname;
	dlsource->m_column2=m_zhmima;
	dlsource->m_column3=quanxian;
	dlsource->Update();
	dlsource->Requery();
	dlsource->Close();
	AfxMessageBox("添加登录帐户成功!");
	UpdateData(FALSE);
}

void CAdminGLDialog::OnButtonzhchg()//修改登录帐户 
{
	// TODO: Add your control notification handler code here
	UpdateData(TRUE);
	if(m_zhxname=="")
	{
		AfxMessageBox("帐户名不能为空!");
		return;
	}
	if(m_zhxmima=="")
	{
		AfxMessageBox("密码不能为空!");
		return;
	}
	if(m_zhxnewname=="")
	{
		AfxMessageBox("新密码不能为空!");
		return;
	}
	if(m_zhxnewmmqr!=m_zhxnewname)
	{
		AfxMessageBox("新密码不正确!");
		return;
	}
	BOOL flag=true;
	CString temp;
	int qx;
	dlsource->Open();
	if(AfxMessageBox("确实要修改此数据吗?", MB_YESNO)==IDYES)
	{	
		for(int i=0;i<dlsource->GetRecordCount();i++)
		{
			if(dlsource->m_column1==m_zhxname && dlsource->m_column2==m_zhxmima)
			{
				if(m_zhxqx=="普通用户")
					qx=3;
				else if(m_zhxqx=="受限用户")
					qx=2;
				else
					qx=dlsource->m_column3;
				if(dlsource->m_column3==1 && qx!=1){
					AfxMessageBox("不能修改管理员的权限!");
					dlsource->Close();
					return;
				}
				dlsource->Edit();
				dlsource->m_column2=m_zhxnewname;
				dlsource->m_column3=qx;
				dlsource->Update();
				flag=false;
			}
			if(!dlsource->IsEOF())
				dlsource->MoveNext();
		}
		if(flag)
		{
			AfxMessageBox("帐号或密码错误不能修改!");
		}
		else
			AfxMessageBox("帐户密码修改成功!");
	}
	dlsource->Close();
	UpdateData(FALSE);
}

void CAdminGLDialog::OnButtonzhdel()//删除登录帐户
{
	// TODO: Add your control notification handler code here
	UpdateData(TRUE);
	BOOL flag=true;
	CString temp;
	dlsource->Open();
	if(AfxMessageBox("确实要删除此数据吗?", MB_YESNO)==IDYES)
	{	
		for(int i=0;i<dlsource->GetRecordCount();i++)
		{
			if(dlsource->m_column1==m_zhxname && dlsource->m_column2==m_zhxmima)
			{
				if(dlsource->m_column3==1)
				{
					AfxMessageBox("管理员密码不能删除!");
					dlsource->Close();
					return;
				}
				dlsource->Delete();
				dlsource->Requery();
				flag=false;
			}
			if(!dlsource->IsEOF())
				dlsource->MoveNext();
		}
		if(flag)
		{
			AfxMessageBox("帐号或密码错误不能删除!");
		}
		else
			AfxMessageBox("帐户删除成功!");
	}
	dlsource->Close();
	UpdateData(FALSE);
}



BOOL CAdminGLDialog::AddBooks()//向数据库中添加书籍函数
{
	booksource->Open();
	booksource->AddNew();
	booksource->m_column1=m_bookno;
	booksource->m_column2=m_bookname;
	booksource->m_column3=m_bookclass;
	booksource->m_column4=m_bookpublish;
	booksource->m_column5=m_bookauthor;
	booksource->m_column6=m_publishdate;
	booksource->m_column7=m_bookvalue;
	booksource->m_column8=m_booknumber;
	booksource->m_column9=m_bookborrow;
	booksource->Update();
	booksource->Requery();
	booksource->Close();
	return true;
}

BOOL CAdminGLDialog::BookNoUsed(int bookno)//判断是否加入的学号重复
{
	booksource->Open();
	while(!booksource->IsEOF())//判断图书表是否为空
	{
		if(booksource->m_column1==bookno)//如果输入的书号与图书表中的书号相同
		{
			booksource->Close();
			return false;
		}
		booksource->MoveNext();
	}
	booksource->Close();
	return true;
}



void CAdminGLDialog::ShowList(int i)
{
	if(i==1)
	{
		m_booklist.DeleteAllItems();
		CString str;
		int j=0;
		booksource->Open();
		if(booksource->IsEOF())
			AfxMessageBox("数据库中没有数据!");
		while(!booksource->IsEOF())
		{
			str.Format("%d",booksource->m_column1);
			m_booklist.InsertItem(j,str,0);
			
			m_booklist.SetItemText(j,1,booksource->m_column2);
			m_booklist.SetItemText(j,2,booksource->m_column3);
			m_booklist.SetItemText(j,3,booksource->m_column4);
			m_booklist.SetItemText(j,4,booksource->m_column5);
			m_booklist.SetItemText(j,5,booksource->m_column6.Format("%Y-%m-%d"));
			
			str.Format("%6.2f",booksource->m_column7);
			m_booklist.SetItemText(j,8,str);
			str.Format("%d",booksource->m_column8);
			m_booklist.SetItemText(j,6,str);
			str.Format("%d",booksource->m_column9);
			m_booklist.SetItemText(j,7,str);
			j++;
			booksource->MoveNext();
		}
		booksource->Close();
	}
	else if(i==2)
	{
		m_studentlist.DeleteAllItems();
		CString str;
		int j=0;
		BOOL flag=true;//判断显示数据是否重复的标志位
		studentsource->Open();
		if(studentsource->IsEOF())
			AfxMessageBox("数据库中没有数据!");
		while(!studentsource->IsEOF())
		{
			for(int v=0;v<m_studentlist.GetItemCount();v++)//防止列表控件中显示相同的数据
			{
				if(atoi(m_studentlist.GetItemText(v,0))==studentsource->m_column1)
					flag=false;
			}
			if(flag)
			{
				str.Format("%d",studentsource->m_column1);
				m_studentlist.InsertItem(j,str,0);

				m_studentlist.SetItemText(j,1,studentsource->m_column2);
				m_studentlist.SetItemText(j,2,studentsource->m_column3);
				j++;
			}
			studentsource->MoveNext();
			flag=true;
		}
		studentsource->Close();
	}
}

BOOL CAdminGLDialog::StudentNoUsed(int stuno)//判断学号是否已经存在
{
	studentsource->Open();
	while(!studentsource->IsEOF())
	{
		if(studentsource->m_column1==stuno)
		{
			studentsource->Close();
			return false;
		}
		studentsource->MoveNext();
	}
	studentsource->Close();
	return true;

}

void CAdminGLDialog::AddStudent()//添加用户函数
{
	studentsource->Open();
	studentsource->AddNew();
	studentsource->m_column1=m_stuno;
	studentsource->m_column2=m_stuname;
	studentsource->m_column3=m_stuclass;
	studentsource->m_column4=0;//没有借书时书号为零
	studentsource->m_column5="";
	studentsource->m_column6=NULL;
	studentsource->m_column7=0;
	studentsource->Update();
	studentsource->Requery();
	studentsource->Close();
}

BOOL CAdminGLDialog::ZhNameUsed()//判断帐户号是否已经存在
{
	dlsource->Open();
	while(!dlsource->IsEOF())
	{
		if(dlsource->m_column1==m_zhname)
		{
			dlsource->Close();
			return false;
		}
		dlsource->MoveNext();
	}
	dlsource->Close();
	return true;
}

void CAdminGLDialog::OnButtonzhempty()//添加登录帐户的清空按钮
{
	// TODO: Add your control notification handler code here
	m_zhmima.Empty();
	m_zhname.Empty();
	m_zhmmqr.Empty();
	m_zhquanxian.Empty();
	UpdateData(FALSE);
}

void CAdminGLDialog::OnButtonzhxemp()//修改登录帐户的清空按钮 
{
	// TODO: Add your control notification handler code here
	m_zhxname.Empty();
	m_zhxmima.Empty();
	m_zhxqx.Empty();
	m_zhxnewname.Empty();
	m_zhxnewmmqr.Empty();
	UpdateData(FALSE);
}