private void btbookin_Click(object sender, EventArgs e)
{
if (txtcaseID.Text.Trim() == "" || txtclass.Text.Trim() == "" || txtcname.Text.Trim() == "" ||
txtdpt.Text.Trim() == "" || txtfloor.Text.Trim() == "" || txtisbn.Text.Trim() == "" ||
txtpress.Text.Trim() == "" || txtpub.Text.Trim() == "" || txtrow.Text.Trim() == "" ||
txtshelf.Text.Trim() == "" || txtwriter.Text.Trim() == "")
{
MessageBox.Show("请填写所有信息");
return;
}
string sqlupcs = "update caseBook set caseName='" + txtcname.Text.Trim()
+ "',writer='" + txtwriter.Text.Trim()
+ "',department='" + txtdpt.Text.Trim()
+ "',floor='" + txtfloor.Text.Trim()
+ "',press='" + txtpress.Text.Trim()
+ "',pubdate='" + txtpub.Text.Trim()
+ "',row='" + txtrow.Text.Trim()
+ "',shelf='" + txtshelf.Text.Trim()
+ "',classID='" + txtclass.Text.Trim()
+ "' where caseID='" + txtcaseID.Text.Trim() + "'";
Cdatabase.UpdateDB(sqlupcs);
MessageBox.Show("修改成功");
this.Close();
this.refresh();
}
private void btlend_Click(object sender, EventArgs e)
{
if (txtlendcid.Text.Trim() == "" || txtlendrid.Text.Trim() == "")
{
MessageBox.Show("请填写完整信息");
return;
}
if (chkcid() && chkrid())
{
string sqllendbk = "insert into lend values('" + txtlendrid.Text.Trim()
+ "','" + txtlendcid.Text.Trim() + "','" + DateTime.Now.ToString("yyyy-MM-dd")
+ "','" + DateTime.Now.AddMonths(1).ToString("yyyy-MM-dd") + " ','false')";
string sqlcasest = "update caseBook set state='false' where caseID='" + txtlendcid.Text.Trim() + "'";
string showinfo = "读者编码：" + txtlendrid.Text.Trim() +
"\n图书编码：" + txtlendcid.Text.Trim() +
"\n借书日期：" + DateTime.Now.ToString("yyyy-MM-dd") +
"\n还书日期：" + DateTime.Now.AddMonths(1).ToString("yyyy-MM-dd");
if (MessageBox.Show(showinfo, "借书信息", MessageBoxButtons.OKCancel) == DialogResult.OK)
{
Cdatabase.UpdateDB(sqllendbk);
Cdatabase.UpdateDB(sqlcasest);
MessageBox.Show("ok");
txtlendcid.Text = "";
txtlendrid.Text = "";
}
}
}
private void btaddrd_Click(object sender, EventArgs e)
{
if (checkrd())
{
return;
}
if (txtrdid.Text.Trim() == "" || txtrdName.Text.Trim() == "" ||
txtYear.Text.Trim() == "" || txtMonth.Text.Trim() == "" || txtDay.Text.Trim() == "" ||
txtrddpt.Text.Trim() == "" || comboBox1.SelectedIndex == -1)
{
MessageBox.Show("请填写所有信息");
return;
}
string sqlupcase = "insert into reader values('" + txtrdid.Text.Trim() + "','"
+ txtrdName.Text.Trim() + "','"
+ txtYear.Text.Trim() + "." + txtMonth.Text.Trim() + "." + txtDay.Text.Trim() + "','"
+ comboBox1.Text.Trim() + "','"
+ txtrddpt.Text.Trim() +
"')";
Cdatabase.UpdateDB(sqlupcase);
MessageBox.Show("添加成功！");
txtrdName.Text = "";
txtYear.Text = "";
txtMonth.Text = "";
txtDay.Text = "";
txtrddpt.Text = "";
txtrdid.Text = "";
}
private void btbookin_Click(object sender, EventArgs e)
{
if (txtrdName.Text.Trim() == "" || txtYear.Text.Trim() == "" || txtMonth.Text.Trim() == "" || txtDay.Text.Trim() == "" || txtrdid.Text.Trim() == "" || txtrddpt.Text.Trim() == "")
{
MessageBox.Show("请填写所有信息");
return;
}
string sqlupcase = "insert into reader values('" + txtrdid.Text.Trim() + "','"
+ txtrdName.Text.Trim() + "','"
+ txtYear.Text.Trim() + "." + txtMonth.Text.Trim() + "." + txtDay.Text.Trim() + "','"
+ txtrddpt.Text.Trim() + "','"
+ comboBox1.Text.Trim() +
"')";
//insertvlm();
//MessageBox.Show(sqlupcase);
Cdatabase.UpdateDB(sqlupcase);
MessageBox.Show("录入成功！");
txtrdName.Text = "";
txtYear.Text = "";
txtMonth.Text = "";
txtDay.Text = "";
txtrddpt.Text = "";
txtrdid.Text = "";
}
private void btbookin_Click(object sender, EventArgs e)
{
if (txtcaseID.Text.Trim() == "" || txtclass.Text.Trim() == "" || txtcname.Text.Trim() == "" ||
txtdpt.Text.Trim() == "" || txtfloor.Text.Trim() == "" || txtisbn.Text.Trim() == "" ||
txtpress.Text.Trim() == "" || txtpub.Text.Trim() == "" || txtrow.Text.Trim() == "" ||
txtshelf.Text.Trim() == "" || txtwriter.Text.Trim() == "" || chkvin())
{
MessageBox.Show("请填写所有信息");
return;
}
for (int i = 0; i < vnumup.Value; i++)
{
string sqlSt = "select * from volume where vID='" + vindata.Rows[i].Cells[0].Value.ToString() + "'";
DataSet dsv = new DataSet();
Cdatabase.conn.ConnectionString = Cdatabase.connStr;
Cdatabase.conn.Open();
SqlDataAdapter adapte = new SqlDataAdapter(sqlSt, Cdatabase.conn);
adapte.Fill(dsv);
Cdatabase.conn.Close();
if (!(dsv.Tables[0].Rows.Count == 0))
{
MessageBox.Show("册号重复");
vindata.Rows[i].Cells[0].Value = "";
return;
}
}
string sqlupcase = "insert into caseBook(caseID,caseName,press,pubdate,vnum,isbn,department,classID,row,shelf,floor,writer,state) values('"
+ txtcaseID.Text.Trim() + "','"
+ txtcname.Text.Trim() + "','" + txtpress.Text.Trim() + "','"
+ txtpub.Text.Trim() + "','" + vnumup.Value.ToString() + "','"
+ txtisbn.Text.Trim() + "','" + txtdpt.Text.Trim() + "','"
+ txtclass.Text.Trim() + "','" + txtrow.Text.Trim() + "','"
+ txtshelf.Text.Trim() + "','" + txtfloor.Text.Trim() + "','"
+ txtwriter.Text.Trim() + "','True')";
//MessageBox.Show(sqlupcase);
Cdatabase.UpdateDB(sqlupcase);
insertvlm();
MessageBox.Show("录入成功！");
txtcaseID.Text = "";
txtcname.Text = "";
txtwriter.Text = "";
txtdpt.Text = "";
txtfloor.Text = "";
txtisbn.Text = "";
txtpress.Text = "";
txtpub.Text = "";
txtrow.Text = "";
txtshelf.Text = "";
txtclass.Text = "";
vnumup.Value = 1;
for (int j = 0; j < 4; j++)
{
vindata.Rows[0].Cells[j].Value = "";
}
}
private void btdelete_Click(object sender, EventArgs e)
{
string dltnm = dataGridView1.CurrentRow.Cells[1].Value.ToString();
string dltid = dataGridView1.CurrentRow.Cells[0].Value.ToString();
if (MessageBox.Show("确定删除\n读者号为" + dltid + "\n姓名为\t" + dltnm + "？", "提示", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
string sqldltv = "delete from reader where rdID ='" + dltid + "'";
string sqldltlend = "delete from lend where rdID='" + dltid + "'";
Cdatabase.UpdateDB(sqldltv);
MessageBox.Show("删除成功");
RefreshForm();
}
}
private void insertvlm()
{
for (int i = 0; i < vnumup.Value; i++)
{
string sqlinv = "insert into volume(vID,division,vwriter,topic,cID) values('";
for (int j = 0; j < 4; j++)
{
sqlinv += vindata.Rows[i].Cells[j].Value.ToString() + "','";
}
sqlinv += txtcaseID.Text.ToString() + "')";
Cdatabase.UpdateDB(sqlinv);
//MessageBox.Show(sqlinv);
}
}
private void btrtn_Click(object sender, EventArgs e)
{
if (txtrtn.Text.Trim() == "")
{
MessageBox.Show("请填写图书编码");
return;
}
//修改图书的状态、从lend表中删去此行、判断日期，如果日期在今天之后则提醒
string sql = "select * from lend where cID='" + txtrtn.Text.Trim() + "'";
DataSet dscase = new DataSet();
Cdatabase.conn.ConnectionString = Cdatabase.connStr;
Cdatabase.conn.Open();
SqlDataAdapter adapter = new SqlDataAdapter(sql, Cdatabase.conn);
adapter.Fill(dscase);
Cdatabase.conn.Close();
if (!(dscase.Tables[0].Rows.Count == 0))
{
string sqlupcase = "update caseBook set state='True' where caseID='" + txtrtn.Text.Trim() + "'";
string sqldelete = "delete from lend where cID='" + txtrtn.Text.Trim() + "'";
DateTime d = Convert.ToDateTime(dscase.Tables[0].Rows[0]["rtndate"].ToString());
if (DateTime.Now < d)
{
Cdatabase.UpdateDB(sqlupcase);
Cdatabase.UpdateDB(sqldelete);
MessageBox.Show("ok");
txtrtn.Text = "";
}
else
{
if (MessageBox.Show("超时" + (DateTime.Now - d).TotalDays.ToString() + "天", "提示", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
Cdatabase.UpdateDB(sqlupcase);
Cdatabase.UpdateDB(sqldelete);
}
}
}
else
{
MessageBox.Show("该图书未被借出");
}
}
private void btaddrd_Click(object sender, EventArgs e)
{
if (txtrdid.Text.Trim() == "" || txtrdName.Text.Trim() == "" ||
txtYear.Text.Trim() == "" || txtMonth.Text.Trim() == "" ||
txtDay.Text.Trim() == "" ||
txtrddpt.Text.Trim() == "" || comboBox1.SelectedIndex == -1)
{
MessageBox.Show("请填写所有信息");
return;
}
string sqlupcase = "update reader set rdname='" + txtrdName.Text.Trim()
+ "',rdbirth='" + txtYear.Text.Trim() + "." + txtMonth.Text.Trim() + "." + txtDay.Text.Trim()
+ "',rdsex='" + comboBox1.Text.Trim()
+ "',rddpt='" + txtrddpt.Text.Trim() + "' where rdID='" + txtrdid.Text.Trim() + "'";
Cdatabase.UpdateDB(sqlupcase);
MessageBox.Show("修改成功！");
this.Close();
this.refresh();
}
private void btedit_Click(object sender, EventArgs e)
{
if (txtvid.Text.Trim() == "" ||
txtdivision.Text.Trim() == "" ||
txtvwriter.Text.Trim() == "" ||
txttopic.Text.Trim() == "")
{
MessageBox.Show("请填写所有信息");
return;
}
string sqlupvlm = "update volume set division='" + txtdivision.Text.Trim()
+ "',vwriter='" + txtvwriter.Text.Trim()
+ "',topic='" + txttopic.Text.Trim()
+ "' where vid='" + txtvid.Text.Trim()
+ "'";
Cdatabase.UpdateDB(sqlupvlm);
MessageBox.Show("修改成功");
this.Close();
this.refresh();
}
private void chgname_Click(object sender, EventArgs e)
{
if (chgname.Text == "修改")
{
usernm.ReadOnly = false;
chgname.Text = "确定";
}
else if (chgname.Text == "确定")
{
if (usernm.Text.Trim() == "")
{
MessageBox.Show("不能为空！");
return;
}
string sqlupnm = "update admin set adminName='" + usernm.Text.Trim()
+ "' where adminID='" + UserPublic.userInfo[0] + "'";
Cdatabase.UpdateDB(sqlupnm);
usernm.ReadOnly = true;
chgname.Text = "修改";
}
}
private void chgpwd_Click(object sender, EventArgs e)
{
if (chgpwd.Text == "修改")
{
txtpwd.ReadOnly = false;
chgpwd.Text = "确定";
txtpwd.PasswordChar = new char();
}
else if (chgpwd.Text == "确定")
{
if (txtpwd.Text.Trim() == "")
{
MessageBox.Show("不能为空！");
return;
}
txtpwd.PasswordChar = '*';
string sqluppwd = "update admin set adminPwd='" + txtpwd.Text.Trim()
+ "' where adminID='" + UserPublic.userInfo[0] + "'";
Cdatabase.UpdateDB(sqluppwd);
txtpwd.ReadOnly = true;
chgpwd.Text = "修改";
}
}