1、1.登陆界面主要代码：public partial class LoginForm : Formpublic static string uacc;public static string upsw;public static string uname;public static string usex;public static string upart;public static string uright;public LoginForm()InitializeComponent();private void loginbtn_Click(object sender, EventArgs
2、 e)if (this.useracctxt.Text.Trim() = “ return;trystring sql;sql = “select * from tb_user where uacc=“ + this.useracctxt.Text + “ and upsw=“ + this.pswtxt.Text + “;OleDbDataReader dr = DBHelp.OleReader(sql);dr.Read();if (dr.HasRows)uacc = this.useracctxt.Text;upsw = this.pswtxt.Text;uname = dr“uname“
3、.ToString();usex = dr“usex“.ToString();upart = dr“upart“.ToString();uright = dr“uright“.ToString();MainForm af = new MainForm(this);this.Hide();this.useracctxt.Clear();this.pswtxt.Clear();af.Show();elseMessageBox.Show(“账号或密码错误！“, “提示！“);this.useracctxt.Clear();this.pswtxt.Clear();this.useracctxt.Foc
4、us(); catch (Exception)MessageBox.Show(“数据库无法连接！“, “警告！“);private void cancelbtn_Click(object sender, EventArgs e)Application.Exit();private void LoginForm_Closing(object sender, FormClosingEventArgs e)Application.Exit(); 2.主界面（图较小，自己可以拉大点）主要代码就不写了，很简单。3.权限设置主要代码：public partial class RightSet : Form
5、public RightSet()InitializeComponent();private void RightSet_Load(object sender, EventArgs e)this.rightbox.SelectedIndex = 0;/this.treeright.ExpandAll();Fill();private void okbtn_Click(object sender, EventArgs e)if (this.txtnum.Text = string.Empty)MessageBox.Show(“请输入最大借阅图书数量！“, “提示！“);return;if (th
6、is.txtday.Text = string.Empty)MessageBox.Show(“请输入最大借阅图书时间！“, “提示！“);return;if (this.txtcost.Text = string.Empty)MessageBox.Show(“请输入借书押金金额！“, “提示！“);return;if (this.txtfine.Text = string.Empty)MessageBox.Show(“请输入超期罚款金额！“, “提示！“);return;if (this.txttim.Text = string.Empty)MessageBox.Show(“请输入图书遗失罚款
7、倍数！“, “提示！“);return;ArrayList arr = new ArrayList();foreach (TreeNode nodes in this.treeright.Nodes)if (nodes.Checked)arr.Add(“1“);elsearr.Add(“0“);foreach(TreeNode node in nodes.Nodes)if (node.Checked)arr.Add(“1“);elsearr.Add(“0“);string a=new string11;for (int i = 0; i 已还 and borstate 已还“;sql3 +=
8、“ and bordate 已还“;OleDbDataReader dr = DBHelp.OleReader(sql);dr.Read();if (dr.HasRows)MessageBox.Show(“该用户尚有图书未还，无法删除！“, “提示！“);elseif (this.txtuacc.Text = LoginForm.uacc)MessageBox.Show(“对不起，自己无法删除自己！“, “提示！“);elsestring sql2 = string.Empty;sql2 += “select uright from tb_user“;sql2 += “ where uacc=
9、“ + this.txtuacc.Text + “;DataTable dt2 = DBHelp.ExeOleCommand(sql2);string xxx = dt2.Rows00.ToString();if (xxx = “超级管理员“)MessageBox.Show(“该用户为超级管理员，无法删除！“, “提示！“);elsestring str = string.Empty;str += “delete from tb_user where uacc=“ + this.txtuacc.Text + “;DataTable dt = DBHelp.ExeOleCommand(str);
10、MessageBox.Show(“该用户已删除！“, “提示！“);Fill();9.图书挂失主要代码：public partial class BookLost : Formpublic BookLost()InitializeComponent();private void FillBook()string s = string.Empty;s += “select * from tb_book“;s += “ where bno=“ + this.notxt.Text + “;OleDbDataReader dr = DBHelp.OleReader(s);dr.Read();if (d
11、r.HasRows)this.nametxt.Text = dr“bname“.ToString().Trim();this.classtxt.Text = dr“bclass“.ToString().Trim();this.isbntxt.Text = dr“bisbn“.ToString().Trim();this.costtxt.Text = dr“bcost“.ToString().Trim();this.writertxt.Text = dr“bauthor“.ToString().Trim();this.pubtxt.Text = dr“bpub“.ToString().Trim();this.addertxt.Text = dr“adder“.ToString().Trim();this.adddatetxt.Text = dr“adddate“.ToString().Trim();this.bstatetxt.Text = dr“bstate“.ToString().Trim();this.notetxt.Text = dr“bnote“.ToString().Trim();
