/**
* 还书
*/
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();
}
}
