private void button_Search_Click(object sender, EventArgs e)
{
if (comboBox_Search.Text == " ")
{
MessageBox.Show("请先选择要查找的类型!");
}
if (comboBox_Search.Text == "账号")
{
string sql = "select * from Login_ID where 账号 ='" + textBox_Search.Text.ToString() + "' ";
DataTable dt = new DataTable();
dt = DataBaseApplication.GetDataTableValue(sql);//执行sql语句
dataGridView1.DataSource = dt;
}
if (comboBox_Search.Text == "手机号码")
{
string sql = "select * from Login_ID where 电话号码 ='" + textBox_Search.Text.ToString() + "' ";
DataTable dt = new DataTable();
dt = DataBaseApplication.GetDataTableValue(sql);//执行sql语句
dataGridView1.DataSource = dt;
}
if (comboBox_Search.Text == "邮箱")
{
string sql = "select * from Login_ID where 邮箱 ='" + textBox_Search.Text.ToString() + "' ";
DataTable dt = new DataTable();
dt = DataBaseApplication.GetDataTableValue(sql);//执行sql语句
dataGridView1.DataSource = dt;
}
if (comboBox_Search.Text == "姓名")
{
string sql = "select * from Login_ID where 姓名 ='" + textBox_Search.Text.ToString() + "' ";
DataTable dt = new DataTable();
dt = DataBaseApplication.GetDataTableValue(sql);//执行sql语句
dataGridView1.DataSource = dt;
}
}
private void ReturnBook_Load(object sender, EventArgs e)
{
//发邮件控件是否可见
if (PublicPassBy.level != "管理员")
{
send_email.Visible = false;
btn_all.Visible = false;
}
//时间显示
timer1.Interval = 1000;
timer1.Start();
//底部状态栏数据
LoginForm lg = new LoginForm();
level1 = PublicPassBy.level;
if (level1 == "用户")
{
tSSL2.Text = "权限级别：普通用户";
}
else
{
tSSL2.Text = "权限级别：管理员";
}
tSSL5.Text = " " + PublicPassBy._name;
//
if (PublicPassBy.level == "用户")
{
string sql = "select * from Borrow_List where 借阅人账号='" + PublicPassBy.id + "'";
DataTable dt = new DataTable();
dt = DataBaseApplication.GetDataTableValue(sql);//执行sql语句
dataGridView1.DataSource = dt;
}
}
private void OK_Click(object sender, EventArgs e)
{
string sql = "insert into Book_Recommend(书名,排行) values('" + textBox_top1.Text + "','1'),('" + textBox_top2.Text + "','2'),('" + textBox_top3.Text + "','3'),('" + textBox_top4.Text + "','4'),('" + textBox_top5.Text + "','5')";
DataBaseApplication.ExecuteNonQuery(sql);
this.Close();
}
private void toolStripButton2_Click(object sender, EventArgs e)
{
if (dataGridView1.DataSource != null)
{
DialogResult result = MessageBox.Show("确认归还？", "温馨提示", MessageBoxButtons.OKCancel);
if (result == DialogResult.OK)
{
//执行删除语句
MessageBox.Show("还书成功！");
}
select_ID = (string)dataGridView1.CurrentCell.Value;
//从在借单中删除
string sql = "delete from Borrow_List where 书籍序列号='" + select_ID + "'";
DataBaseApplication.ExecuteNonQuery(sql);
//获取书名
bookname = (string)dataGridView1.CurrentRow.Cells[3].Value.ToString();
PublicPassBy.IMDB_Bookname = bookname;
PublicPassBy.IMDB_Bookid = select_ID;
//添加进还书单
string sql1 = "insert into Return_List values('" + select_ID + "','" + dataGridView1.CurrentRow.Cells[1].Value.ToString() + "','" + DateTime.Now.ToLongDateString().ToString() + "','" + dataGridView1.CurrentRow.Cells[3].Value.ToString() + "','" + PublicPassBy._name + "','" + PublicPassBy.email + "')";
DataBaseApplication.ExecuteNonQuery(sql1);
//加库存
string sql2 = "update Books_Info set 库存数=库存数+1 where 书籍序列号='" + select_ID + "'";
DataBaseApplication.ExecuteNonQuery(sql2);
//询问是否写书评
IMDB write = new IMDB();
write.ShowDialog();
this.Close();
}
}
private void button1_Click(object sender, EventArgs e)
{
string sql = "insert into Book_Recommend_Reader (书名,作者,出版社)values('" + textBox_BookName + "','" + textBox_Author + "','" + textBox_Press + "')";
DataBaseApplication.ExecuteNonQuery(sql);
MessageBox.Show("感谢您的推荐！");
this.Close();
}
private void toolStripLabel3_Click(object sender, EventArgs e)
{
string sql = "select * from Books_Info ";
DataTable dt = new DataTable();
dt = DataBaseApplication.GetDataTableValue(sql);//执行sql语句
dataGridView1.DataSource = dt;
}
private void button1_Click(object sender, EventArgs e)
{
string sql = "select * from Login_ID";
DataBaseApplication.ExecuteNonQuery(sql);
DataTable dt = new DataTable();
dt = DataBaseApplication.GetDataTableValue(sql);//执行sql语句
dataGridView1.DataSource = dt;
}
private void btn_all_Click(object sender, EventArgs e)
{
string sql = "select * from Borrow_List";
DataBaseApplication.ExecuteNonQuery(sql);
DataTable dt = new DataTable();
dt = DataBaseApplication.GetDataTableValue(sql);
dataGridView1.DataSource = dt;
}
private void BorrowBook_Load(object sender, EventArgs e)
{
string sql = "select * from Books_Info where 书籍序列号='" + select_ID.ToString() + "'";
DataTable dt = new DataTable();
dt = DataBaseApplication.GetDataTableValue(sql);
textBox_No.Text = dt.Rows[0][0].ToString();
textBox_Name.Text = dt.Rows[0][1].ToString();
textBox_Author.Text = dt.Rows[0][2].ToString();
textBox_Press.Text = dt.Rows[0][3].ToString();
textBox_ID.Text = PublicPassBy.id;
textBox_Who.Text = PublicPassBy._name;
}
private void button1_Click(object sender, EventArgs e)
{
DialogResult result = MessageBox.Show("确认删除？", "温馨提示", MessageBoxButtons.OKCancel);
if (result == DialogResult.OK)
{
//执行删除语句
MessageBox.Show("删除成功！");
}
string sql = "TRUNCATE TABLE Book_Recommend ";
//string sql = "delete * from Book_Recommend";
DataBaseApplication.ExecuteNonQuery(sql);
}
private void button_OK_Click(object sender, EventArgs e)
{
string sql = "insert into Borrow_List values('" + textBox_No.Text.ToString() + "','" + textBox_ID.Text.ToString() + "','" + DateTime.Now.ToLongDateString().ToString() + "','" + textBox_Name.Text.ToString() + "','" + PublicPassBy._name + "', '" + DateTime.Now.AddDays(30).ToString() + "','" + PublicPassBy.email + "')";
DataBaseApplication.ExecuteNonQuery(sql);
string sql1 = "update Books_Info set 库存数=库存数-1 where 书籍序列号='" + textBox_No.Text.ToString() + "' ";
DataBaseApplication.ExecuteNonQuery(sql1);
MessageBox.Show("借阅成功！");
//积分更新
string sqln = "update Login_ID set 积分=积分+1 where 账号='" + textBox_ID.Text.ToString() + "' ";
DataBaseApplication.ExecuteNonQuery(sqln);
this.Close();
}
private void Add_Book_Load(object sender, EventArgs e)
{
if (type == "2")
{
string sql = "select * from Books_Info where 书籍序列号='" + select_ID.ToString() + "'";
DataTable dt = new DataTable();
dt = DataBaseApplication.GetDataTableValue(sql);
textBox_No.Text = dt.Rows[0][0].ToString();
textBox_BookName.Text = dt.Rows[0][1].ToString();
textBox_Author.Text = dt.Rows[0][2].ToString();
textBox_Press.Text = dt.Rows[0][3].ToString();
textBox_Price.Text = dt.Rows[0][4].ToString();
textBox_Storage.Text = dt.Rows[0][5].ToString();
button3.Visible = false;
}
}
private void submit_Click(object sender, EventArgs e)
{
if (richTextBox1 != null && textBox_Rate != null)
{
string sql = "insert into IMDB values('" + richTextBox1.Text.ToString() + "','" + PublicPassBy.IMDB_Bookname + "','" + PublicPassBy.IMDB_Bookid + "','" + PublicPassBy.id + "','" + textBox_Rate.Text + "')";
DataBaseApplication.ExecuteNonQuery(sql);
DialogResult result = MessageBox.Show("确认提交？", "温馨提示", MessageBoxButtons.OKCancel);
if (result == DialogResult.OK)
{
//执行删除语句
MessageBox.Show("提交成功！");
}
}
else
{
MessageBox.Show("请先填写完整！");
}
this.Close();
}
private void MainForm_Load(object sender, EventArgs e)
{
//时间显示
timer1.Interval = 1000;
timer1.Start();
//底部状态栏数据
LoginForm lg = new LoginForm();
level1 = PublicPassBy.level;
if (level1 == "用户")
{
tSSL2.Text = "权限级别：普通用户";
}
else
{
tSSL2.Text = "权限级别：管理员";
}
tSSL5.Text = " " + PublicPassBy._name;
//权限设置
if (level1 == "用户")
{
Add_User.Visible = false;
新用户注册ToolStripMenuItem.Visible = false;
Add_Books.Visible = false;
热门推荐ToolStripMenuItem.Visible = false;
新书入库ToolStripMenuItem.Visible = false;
}
//热门推荐
string sql = "select 书名,排行 from Book_Recommend";
DataTable dt = new DataTable();
DataBaseApplication.ExecuteNonQuery(sql);
dt = DataBaseApplication.GetDataTableValue(sql);
label1_1.Text = dt.Rows[0][0].ToString();
label2_2.Text = dt.Rows[1][0].ToString();
label3_3.Text = dt.Rows[2][0].ToString();
label4_4.Text = dt.Rows[3][0].ToString();
label5_5.Text = dt.Rows[4][0].ToString();
}
private void toolStripButton1_Click(object sender, EventArgs e)
{
if (toolStripComboBox1.Text == "")
{
MessageBox.Show("请添加完整!");
}
if (toolStripComboBox1.Text == "书名")
{
string sql = "select distinct 书名,作者,出版社 from Books_Info where 书名 like '%" + toolStripTextBox1.Text.ToString() + "%' ";
DataTable dt = new DataTable();
dt = DataBaseApplication.GetDataTableValue(sql);//执行sql语句
dataGridView1.DataSource = dt;
}
if (toolStripComboBox1.Text == "作者")
{
string sql = "select * from Books_Info where 作者 like '%" + toolStripTextBox1.Text.ToString() + "%' ";
DataTable dt = new DataTable();
dt = DataBaseApplication.GetDataTableValue(sql);//执行sql语句
dataGridView1.DataSource = dt;
}
}
private void BorrowBook1_Load(object sender, EventArgs e)
{
string sql = "select * from Books_Info where 书名='" + Select_ID + "'and 库存数!=0";
DataBaseApplication.ExecuteNonQuery(sql);
DataTable dt = new DataTable();
dt = DataBaseApplication.GetDataTableValue(sql);//执行sql语句
dataGridView1.DataSource = dt;
//书评展示
string sql1 = "select 书评,评分 from IMDB where 书名='" + Select_ID + "'";
DataBaseApplication.ExecuteNonQuery(sql1);
DataTable dt1 = new DataTable();
dt1 = DataBaseApplication.GetDataTableValue(sql1);
dataGridView2.DataSource = dt1;
//平均分
string sql2 = "select avg(评分) from IMDB where 书名='" + Select_ID + "'";
DataBaseApplication.ExecuteNonQuery(sql2);
DataTable dt2 = new DataTable();
dt2 = DataBaseApplication.GetDataTableValue(sql2);
avgRate.Text = dt2.Rows[0][0].ToString();
//--------------------------------控件大小随窗体大小变化
/* this.Resize += new EventHandler(BorrowBook1_Resize);
*
* X = this.Width;
* Y = this.Height;
*
* setTag(this);
* BorrowBook1_Resize(new object(), new EventArgs());*/
//---------------------------------控件大小随窗体大小变化
}
private void btn_login_Click(object sender, EventArgs e)
{
//#1判断非空 trim用于删除空格
if (this.textBox_id.Text.ToString().Trim() == "" || this.textBox_password.Text.ToString().Trim() == "")
{
MessageBox.Show("请补全用户名密码");
return;
}
//要求选择权限类型
if (radioButton_admin.Checked == false && radioButton_user.Checked == false)
{
MessageBox.Show("请选择您的用户身份！");
}
//判断权限类型
if (radioButton_admin.Checked == true)
{
level = "管理员";
PublicPassBy.level = level;
}
if (radioButton_user.Checked == true)
{
level = "用户";
PublicPassBy.level = level;
}
//判断用户是否存在
DataTable dt = new DataTable();
string user_name = "";
string pass_word = "";
//读取界面值
user_name = this.textBox_id.Text.ToString().Trim();
pass_word = this.textBox_password.Text.ToString().Trim();
//sql
string sql = "select * from Login_ID where 账号='" + user_name + "'";
dt = DataBaseApplication.GetDataTableValue(sql);
//读取账号所有人的名字
PublicPassBy._name = dt.Rows[0]["姓名"].ToString();
//读取账号
PublicPassBy.id = dt.Rows[0]["账号"].ToString();
//读取邮箱
PublicPassBy.email = dt.Rows[0]["邮箱"].ToString();
//判断用户是否存在
if (dt.Rows.Count == 0)
{
MessageBox.Show("该用户不存在");
return;
}
//判断密码和权限
if (dt.Rows[0]["密码"].ToString() == pass_word)
{
if (dt.Rows[0]["身份"].ToString() == level)
{
SystemLog.loginState = "OK";
SystemLog.user_name = user_name;
SystemLog.user_key = dt.Rows[0]["密码"].ToString();
this.Close();
}
}
if (dt.Rows[0]["密码"].ToString() != pass_word)
{
MessageBox.Show("用户名和密码不匹配");
}
if (dt.Rows[0]["身份"].ToString() != level)
{
MessageBox.Show("您无此权限！");
}
}
private void button_OK_Click(object sender, EventArgs e)
{
//防错
q = textBox_Password.Text.Length;//q和p在上面定义
p = textBox_phonenum.Text.Length;
k = textBox_ID.Text.Length;
if (k != 11)
{
MessageBox.Show("请输入账号（11位）！");
m = 2;
}
if (k == 11)
{
if (q < 9 | q > 11)
{
MessageBox.Show("请输入9-11位的密码！");
m = 2;
}
if (p != 11)
{
MessageBox.Show("温馨提示：请检查您输入的号码是否正确（11位）！");
m = 2;
}
}
if (p == 11)
{
if (textBox_Name.Text == "")
{
MessageBox.Show("您的姓名未填写，请输入姓名！");
}
m = 2;
if (textBox_phonenum.Text == "")
{
MessageBox.Show("您的号码未填写，请输入11位号码！");
}
m = 2;
if (q > 8 && q < 12)
{
if (textBox_Password.Text == "")
{
MessageBox.Show("您的密码未填写，请输入密码！");
m = 2;
}
else
{
MessageBox.Show(textBox_Password.Text, "请您确认密码：");
m = 0;
}
}
if (textBox_email.Text == "")
{
MessageBox.Show("您的邮箱未填写，请输入邮箱号！");
m = 2;
}
else
{
MessageBox.Show(textBox_email.Text, "请您确认邮箱地址：");
m = m + 1;
}
}
if (m == 1)
{
//防错
if (type == "1")
{
if (PublicPassBy.level != "管理员")
{
textBox_Title.Text = "用户";
textBox_Title.ReadOnly = true;
}
string sql = "insert into Login_ID(账号,密码,身份,电话号码,邮箱,姓名,积分)values('" + textBox_ID.Text.ToString() + "','" + textBox_Password.Text.ToString() + "','" + textBox_Title.Text.ToString() + "','" + textBox_phonenum.Text.ToString() + "','" + textBox_email.Text.ToString() + "','" + textBox_Name.Text.ToString() + "',0)";
DataBaseApplication.ExecuteNonQuery(sql);
MessageBox.Show("添加成功");
this.Close();
}
if (type == "2")
{
string sql = "update Login_ID set 密码='" + textBox_Password.Text.ToString() + "',身份='" + textBox_Title.Text.ToString() + "',电话号码='" + textBox_phonenum.Text.ToString() + "',邮箱='" + textBox_email.Text.ToString() + "',姓名='" + textBox_Name.Text.ToString() + "' where 账号='" + textBox_ID.Text.ToString() + "'";
DataBaseApplication.ExecuteNonQuery(sql);
MessageBox.Show("修改成功");
this.Close();
}
}
}
private void Add_User_Load(object sender, EventArgs e)
{
//注册界面
if (type == "0")//首页注册
{
textBox_Title.Text = "用户";
textBox_Title.ReadOnly = true;
}
if (type == "1")
{
if (PublicPassBy.level == "用户")
{
textBox_Title.Text = "用户";
textBox_Title.ReadOnly = true;
}
}
if (type == "2")
{
string sql = "select * from Login_ID where 账号='" + select_ID.ToString() + "'";
DataTable dt = new DataTable();
dt = DataBaseApplication.GetDataTableValue(sql);
textBox_ID.Text = dt.Rows[0][0].ToString();
textBox_Password.Text = dt.Rows[0][1].ToString();
textBox_Title.Text = dt.Rows[0][2].ToString();
textBox_phonenum.Text = dt.Rows[0][3].ToString();
textBox_email.Text = dt.Rows[0][4].ToString();
textBox_Name.Text = dt.Rows[0][5].ToString();
textBox_Point.Text = dt.Rows[0][6].ToString();
//积分不可修改
textBox_Point.ReadOnly = true;
}
if (type == "3")
{
string sql = "select * from Login_ID where 姓名='" + PublicPassBy._name + "'";
DataTable dt = new DataTable();
dt = DataBaseApplication.GetDataTableValue(sql);
textBox_ID.Text = dt.Rows[0][0].ToString();
textBox_Password.Text = dt.Rows[0][1].ToString();
textBox_Title.Text = dt.Rows[0][2].ToString();
textBox_phonenum.Text = dt.Rows[0][3].ToString();
textBox_email.Text = dt.Rows[0][4].ToString();
textBox_Name.Text = dt.Rows[0][5].ToString();
textBox_Point.Text = dt.Rows[0][6].ToString();
//积分不可修改
textBox_Point.ReadOnly = true;
//用户属性不可改
textBox_Title.ReadOnly = true;
}
if (type == "4")//用户自己查询
{
string sql = "select * from Login_ID where 姓名='" + PublicPassBy._name + "'";
DataTable dt = new DataTable();
dt = DataBaseApplication.GetDataTableValue(sql);
textBox_ID.Text = dt.Rows[0][0].ToString();
textBox_Password.Text = dt.Rows[0][1].ToString();
textBox_Title.Text = dt.Rows[0][2].ToString();
textBox_phonenum.Text = dt.Rows[0][3].ToString();
textBox_email.Text = dt.Rows[0][4].ToString();
textBox_Name.Text = dt.Rows[0][5].ToString();
textBox_Point.Text = dt.Rows[0][6].ToString();
//查询时只读
textBox_ID.ReadOnly = true;
textBox_Password.ReadOnly = true;
textBox_Title.ReadOnly = true;
textBox_phonenum.ReadOnly = true;
textBox_email.ReadOnly = true;
textBox_Name.ReadOnly = true;
textBox_Point.ReadOnly = true;
}
}
private void button1_Click(object sender, EventArgs e)
{
//防错
#region
//书籍添加防错
if (textBox_No.Text == "")
{
MessageBox.Show("请添加书籍序列号！");
}
if (textBox_BookName.Text == "")
{
MessageBox.Show("请输入书名！");
}
if (textBox_Author.Text == "")
{
MessageBox.Show("请输入作者！");
}
if (textBox_Press.Text == "")
{
MessageBox.Show("请输入出版社！");
}
if (textBox_Price.Text == "")
{
MessageBox.Show("请输入价格！");
}
if (textBox_Storage.Text == "")
{
MessageBox.Show("请输入库存数！");
}
if (textBox_No.Text != "")
{
if (textBox_BookName.Text != "")
{
if (textBox_Author.Text != "")
{
if (textBox_Press.Text != "")
{
if (textBox_Price.Text != "")
{
if (textBox_Storage.Text != "")
{
t = 1;
}
}
}
}
}
}//书籍添加防错
#endregion
if (t == 1)
{
if (type == "1")
{
if (textBox_No.Text == "")
{
MessageBox.Show("请输入记录ID");
return;
}
string sql = "insert into Books_Info(书籍序列号,书名,作者,出版社,价格,库存数)values('" + textBox_No.Text.ToString() + "','" + textBox_BookName.Text.ToString() + "','" + textBox_Author.Text.ToString() + "','" + textBox_Press.Text.ToString() + "','" + textBox_Price.Text.ToString() + "','" + textBox_Storage.Text.ToString() + "')";
DataBaseApplication.ExecuteNonQuery(sql);
MessageBox.Show("添加成功");
this.Close();
}
}
}