图书管理系统源码C版Word格式.docx
《图书管理系统源码C版Word格式.docx》由会员分享,可在线阅读,更多相关《图书管理系统源码C版Word格式.docx(48页珍藏版)》请在冰豆网上搜索。
{
publicstringpassword;
//用来存储密码
publiclogin()
InitializeComponent();
}
privatevoidbutton2_Click(objectsender,EventArgse)
Application.Exit();
privateboolyanzhengshuru()
password=textBox3.Text;
if(Typename.Text.Trim()=="
"
)
MessageBox.Show("
请选择登录类型"
"
登录提示"
MessageBoxButtons.OK,MessageBoxIcon.Information);
Typename.Focus();
returnfalse;
elseif(loginid.Text.Trim()=="
请输入用户名"
loginid.Focus();
elseif(password=="
请输入密码"
textBox3.Focus();
else
returntrue;
privatevoidbutton1_Click(objectsender,EventArgse)
userhelper.adminid=loginid.Text;
//用户账号
//用户密码
if(yanzhengshuru())
管理员"
stringsql=string.Format("
Selectcount(*)fromadminwhereadminId='
{0}'
andadminpass='
{1}'
loginid.Text,password);
try
SqlCommandcommand=newSqlCommand(sql,Dbhelper.connection);
Dbhelper.connection.Open();
intcount=(int)command.ExecuteScalar();
if(count<
1)
用户或密码不存在!
);
//result=false;
adminadmin=newadmin();
admin.Show();
catch(Exceptionex)
操作数据库出错!
Console.WriteLine(ex.Message);
finally
Dbhelper.connection.Close();
借阅者"
userhelper.readerid=Convert.ToString(loginid.Text);
Selectcount(*)fromreaderwherereaderId='
andreaderpass='
userhelper.readerid,textBox3.Text);
//创建Command对象
//打开数据库连接
Dbhelper.connection.Open();
//验证是否为合法用户
readerreader=newreader();
reader.Show();
//关闭数据库连接
privatevoidlogin_Load(objectsender,EventArgse)
}读者界面;
usingSystem.Data.Sql;
publicpartialclassreader:
publicreader()
privatevoidbutton3_Click(objectsender,EventArgse)
stringid=Convert.ToString(textBox1.Text);
if(id!
=userhelper.readerid)
输入账号与登陆账号不相同,请重新输入"
"
提示"
MessageBoxButtons.OK,MessageBoxIcon.Warning);
textBox1.Text="
;
textBox1.Focus();
else
try
updatereadersetislost='
wherereaderid='
'
是'
id);
SqlCommandcommand=newSqlCommand(sql,Dbhelper.connection);
intresult=command.ExecuteNonQuery();
if(result<
修改失败"
elseMessageBox.Show("
挂失成功"
catch
error"
{
privatevoidtoolStripButton3_Click(objectsender,EventArgse)
groupBox1.Visible=false;
groupBox2.Visible=true;
privatevoidtoolStripButton4_Click(objectsender,EventArgse)
groupBox1.Visible=true;
groupBox2.Visible=false;
privatevoidbutton5_Click(objectsender,EventArgse)
textBox2.Text="
textBox4.Text="
textBox5.Text="
privatevoidForm1_Load(objectsender,EventArgse)
toolStrip1.Text=string.Format("
学生:
{0}"
userhelper.readerid);
privatevoidbutton4_Click(objectsender,EventArgse)
stringid=Convert.ToString(textBox2.Text);
elseif(textBox4.Text!
=textBox5.Text)
MessageBox.Show("
两次密码输入不同"
elsetry
updatereadersetreaderpass='
wherereaderid='
textBox4.Text,id);
修改成功"
Db