/** * 还书 */ private void btnGiveBack_Click(object sender, EventArgs e) { string book_id = ""; string id = ""; try { id = gridBook.SelectedRows[0].Cells[0].Value.ToString(); string give_time = gridBook.SelectedRows[0].Cells[4].Value.ToString(); Console.WriteLine(give_time); if (give_time.Length != 0) { DialogResult box = MessageBox.Show("本书已还,不可重复还~", "Tip", MessageBoxButtons.OK); return; } //book_id = gridBook.SelectedRows[0].Cells[1].Value.ToString(); }catch (Exception ex) { DialogResult box = MessageBox.Show("没有选中任何书籍!", "Tip", MessageBoxButtons.OK); return; } DialogResult dr = MessageBox.Show("确定要归还<<" + gridBook.SelectedRows[0].Cells[1].Value.ToString() + ">>这本书?", "Tip", MessageBoxButtons.YesNo); if (dr == DialogResult.Yes) { string updateUserCmd = "update user set num=num+1 where id=" + user_id; string searchBook = "select book_id from user_book where id=" + id; MySqlDataReader reader = MysqlUtil.search(searchBook); if (reader.Read()) { book_id = reader[0].ToString(); } else { DialogResult d = MessageBox.Show("发生未知错误", "Tip", MessageBoxButtons.OK); return; } string updateBookCmd = "update book set ramined=ramined+1 where id=" + book_id; string updateUserBookCmd = "update user_book set give_time = '{0}' where id=" + id; DateTime give_time = DateTime.Now; updateUserBookCmd = string.Format(updateUserBookCmd, give_time); Console.WriteLine(updateBookCmd); Console.WriteLine(updateUserCmd); Console.WriteLine(updateUserBookCmd); //修改数据库 if (MysqlUtil.operation(updateUserCmd) != -1 && MysqlUtil.operation(updateBookCmd) != -1 && MysqlUtil.operation(updateUserBookCmd) != -1) { MessageBox.Show("还书成功", "Tip", MessageBoxButtons.OK); this.Reload(); } } }
/* * 登录时检测用户合法性 */ private void btnLogin(object sender, EventArgs e) { string id = txtUserId.Text; string password = txtPassword.Text; int identity = radioAdmin.Checked ? 0 : 1; Console.WriteLine(id + " " + password + "" + identity); string sqlcmd = "select * from user where id=" + id + " and password="******" and super=" + identity; Console.WriteLine(sqlcmd); MySqlDataReader dr = MysqlUtil.search(sqlcmd); //用户合法时的事件 if (dr.Read()) { //Console.WriteLine("success"); //Console.WriteLine(String.Format("{0}{1}", dr[0],dr[1])); var frm = new IndexForm(String.Format("{0}", dr[0]), String.Format("{0}", dr[1]), this, identity); this.Hide(); frm.Show(); /* if(identity == 1) * { * //将id和姓名传递给下一个窗口 * var frm = new IndexForm(String.Format("{0}", dr[0]),String.Format("{0}", dr[1]), this); * this.Hide(); * frm.Show(); * } * else * { * //将id和姓名传递给下一个窗口 * var frm = new AdminForm(String.Format("{0}", dr[0]), String.Format("{0}", dr[1]), this); * this.Hide(); * frm.Show(); * }*/ } else { MessageBox.Show("用户名或密码错误,请重新输入!", "Tip", MessageBoxButtons.OK); } }
private void FillList() { gridBook.ColumnCount = 6; gridBook.Columns[0].Name = "id"; gridBook.Columns[1].Name = "借书人"; gridBook.Columns[2].Name = "书名"; gridBook.Columns[3].Name = "借书日期"; gridBook.Columns[4].Name = "应还日期"; gridBook.Columns[5].Name = "还书日期"; gridBook.ReadOnly = true; //不允许添加行 gridBook.AllowUserToAddRows = false; //背景为白色 gridBook.BackgroundColor = Color.White; //只允许选中单行 gridBook.MultiSelect = false; //整行选中 gridBook.SelectionMode = DataGridViewSelectionMode.FullRowSelect; MySqlConnection conn = MysqlUtil.createConn(); try { //加载图书数据 string sqlcmd = "select * from user_book"; Console.WriteLine(sqlcmd); conn.Open(); MySqlDataAdapter adapter = new MySqlDataAdapter(sqlcmd, conn); DataSet dataset = new DataSet("User_Book"); //使用SqlDataAdapter对象adapter将查新结果填充到DataSet对象ds中 adapter.Fill(dataset); conn.Close(); Console.WriteLine(dataset.Tables[0].Rows.Count); // 填充表格 foreach (DataRow row in dataset.Tables[0].Rows) { string id = row["id"].ToString(); string bookId = row["book_id"].ToString(); string sqlcmd2 = "select title from book where id=" + bookId; string sqlname = "select name from user where id=" + row["user_id"].ToString(); string book_name = ""; string user_name = ""; MySqlDataReader dr = MysqlUtil.search(sqlcmd2); Console.WriteLine(row["book_id"].ToString()); if (!dr.Read()) { MessageBox.Show("未知错误", "error", MessageBoxButtons.OK); this.Close(); return; } else { book_name = dr[0].ToString(); Console.WriteLine(book_name); } MySqlDataReader namereader = MysqlUtil.search(sqlname); if (!namereader.Read()) { MessageBox.Show("未知错误", "error", MessageBoxButtons.OK); this.Close(); return; } else { user_name = namereader[0].ToString(); } string[] item = { id, user_name, book_name, row["borrow_time"].ToString(), row["revert_time"].ToString(), row["give_time"].ToString() }; gridBook.Rows.Add(item); } } catch (Exception ex) { MessageBox.Show("查询错误", "Tip", MessageBoxButtons.OK); Console.WriteLine(ex); } finally { conn.Close(); } }