📄 reborrowbooks.cs
字号:
listView1.Items.Clear();
listView2.Items.Clear();
ListViewItem item = null;
string str = "";
str = "select * from V_借书证 where 借书证号='" + textBox1.Text + "'";
cmd.CommandText = str;
try
{
dr = cmd.ExecuteReader();
dr.Read();
if(dr.HasRows)
{
textBox2.Text = dr.GetString(1);
textBox3.Text = dr.GetString(2);
textBox4.Text = dr.GetString(3);
CanBDays = dr.GetInt32(4);
textBox5.Text = dr.GetInt32(5).ToString();
pay = Convert.ToDouble(dr.GetDecimal(6));
rc = dr.GetInt32(5);
}
else
{
if(dr!=null)dr.Close();
MessageBox.Show("此借书证号不存在！请重新输入","错误",MessageBoxButtons.OK,MessageBoxIcon.Error);
textBox1.Text = "";
textBox1.Focus();
return;
}
if(dr!=null)dr.Close();
}
catch(Exception ex)
{
if(dr!=null)dr.Close();
MessageBox.Show(ex.ToString(),"错误",MessageBoxButtons.OK,MessageBoxIcon.Error);
return;
}
str = "select * from 读者借书 where 借书证号='" + textBox1.Text + "' and 归还标志=1";
cmd.CommandText = str;
try
{
dr = cmd.ExecuteReader();
while(dr.Read())
{
i++;
item = new ListViewItem(dr.GetString(0));
item.SubItems.Add(dr.GetString(2));
item.SubItems.Add(dr.GetString(3));
item.SubItems.Add(dr.GetString(5));
if(dr.GetDateTime(8)<DateTime.Now)
{
item.SubItems.Add("是");
}
else
{
item.SubItems.Add("否");
}
item.SubItems.Add(dr.GetDateTime(7).ToShortDateString());
item.SubItems.Add(dr.GetDateTime(8).ToShortDateString());
listView1.Items.Add(item);
}
if(i<=rc)
{
textBox6.Text = (rc-i).ToString();
}
else
{
textBox6.Text = "0";
}
dr.Close();
}
catch(Exception ex)
{
if(dr != null)dr.Close();
MessageBox.Show(ex.ToString(),"错误");
return;
}
string strFK = @"select 图书条码号,借书日期,还书日期,"
+ dtNow
+ "-还书日期 as 超期天数 from 流通 where 还书日期<'"
+ dtNow
+ "' and 归还标志=1 and 借书证号='"
+ textBox1.Text + "'";
cmd.CommandText = strFK;
try
{
dr = cmd.ExecuteReader();
while(dr.Read())
{
count++;
item = new ListViewItem(dr.GetString(0));
item.SubItems.Add(dr.GetDateTime(1).ToShortDateString());
item.SubItems.Add(dr.GetDateTime(2).ToShortDateString());
string cd = Convert.ToString(DateTime.Now.Date-dr.GetDateTime(2).Date).Remove(Convert.ToString(DateTime.Now.Date-dr.GetDateTime(2).Date).IndexOf("."),9);
item.SubItems.Add(cd);
days+=Convert.ToInt32(cd);
listView2.Items.Add(item);
}
if(dr!=null)dr.Close();
}
catch(Exception ex)
{
if(dr!=null)dr.Close();
MessageBox.Show("发生如下错误:\n\t"+ex.ToString(),"错误",MessageBoxButtons.OK,MessageBoxIcon.Error);
return;
}
label19.Text = count.ToString();
label20.Text = days.ToString();
label21.Text = (days*pay).ToString();
}
/// <summary>
/// 关闭
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button2_Click(object sender, System.EventArgs e)
{
Global.ReborrowBooks = false;
Global.sbpGlobal.Text = "就绪";
this.Close();
}
/// <summary>
/// 窗口加载代码
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void ReborrowBooks_Load(object sender, System.EventArgs e)
{
cmd = Global.conn.CreateCommand();
initializeScreen();
}
/// <summary>
/// 验证借书证
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void textBox1_KeyDown(object sender, System.Windows.Forms.KeyEventArgs e)
{
if(e.KeyData == Keys.Enter)
{
i = 0;
rc = 0;
int count = 0;
double pay = 0;
int days = 0;
listView1.Items.Clear();
listView2.Items.Clear();
ListViewItem item = null;
string str = "";
str = "select * from V_借书证 where 借书证号='" + textBox1.Text + "'";
cmd.CommandText = str;
try
{
dr = cmd.ExecuteReader();
dr.Read();
if(dr.HasRows)
{
textBox2.Text = dr.GetString(1);
textBox3.Text = dr.GetString(2);
textBox4.Text = dr.GetString(3);
CanBDays = dr.GetInt32(4);
textBox5.Text = dr.GetInt32(5).ToString();
pay = Convert.ToDouble(dr.GetDecimal(6));
rc = dr.GetInt32(5);
}
else
{
if(dr!=null)dr.Close();
MessageBox.Show("此借书证号不存在！请重新输入","错误",MessageBoxButtons.OK,MessageBoxIcon.Error);
textBox1.Text = "";
textBox1.Focus();
return;
}
if(dr!=null)dr.Close();
}
catch(Exception ex)
{
if(dr!=null)dr.Close();
MessageBox.Show(ex.ToString(),"错误",MessageBoxButtons.OK,MessageBoxIcon.Error);
return;
}
str = "select * from 读者借书 where 借书证号='" + textBox1.Text + "' and 归还标志=1";
cmd.CommandText = str;
try
{
dr = cmd.ExecuteReader();
while(dr.Read())
{
i++;
item = new ListViewItem(dr.GetString(0));
item.SubItems.Add(dr.GetString(2));
item.SubItems.Add(dr.GetString(3));
item.SubItems.Add(dr.GetString(5));
if(dr.GetDateTime(8)<DateTime.Now)
{
item.SubItems.Add("是");
}
else
{
item.SubItems.Add("否");
}
item.SubItems.Add(dr.GetDateTime(7).ToShortDateString());
item.SubItems.Add(dr.GetDateTime(8).ToShortDateString());
listView1.Items.Add(item);
}
if(i<=rc)
{
textBox6.Text = (rc-i).ToString();
}
else
{
textBox6.Text = "0";
}
dr.Close();
}
catch(Exception ex)
{
if(dr != null)dr.Close();
MessageBox.Show(ex.ToString(),"错误");
return;
}
string strFK = @"select 图书条码号,借书日期,还书日期,"
+ dtNow
+ "-还书日期 as 超期天数 from 流通 where 还书日期<'"
+ dtNow
+ "' and 归还标志=1 and 借书证号='"
+ textBox1.Text + "'";
cmd.CommandText = strFK;
try
{
dr = cmd.ExecuteReader();
while(dr.Read())
{
count++;
item = new ListViewItem(dr.GetString(0));
item.SubItems.Add(dr.GetDateTime(1).ToShortDateString());
item.SubItems.Add(dr.GetDateTime(2).ToShortDateString());
string cd = Convert.ToString(DateTime.Now.Date-dr.GetDateTime(2).Date).Remove(Convert.ToString(DateTime.Now.Date-dr.GetDateTime(2).Date).IndexOf("."),9);
item.SubItems.Add(cd);
days+=Convert.ToInt32(cd);
listView2.Items.Add(item);
}
if(dr!=null)dr.Close();
}
catch(Exception ex)
{
if(dr!=null)dr.Close();
MessageBox.Show("发生如下错误:\n\t"+ex.ToString(),"错误",MessageBoxButtons.OK,MessageBoxIcon.Error);
return;
}
label19.Text = count.ToString();
label20.Text = days.ToString();
label21.Text = (days*pay).ToString();
}
}
/// <summary>
/// 记录项单击
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void listView1_Click(object sender, System.EventArgs e)
{
if(listView1.SelectedItems[0].SubItems[0].Text != "")
{
button1.Enabled = true;
strReturnDate = listView1.SelectedItems[0].SubItems[6].Text;
}
else
{
button1.Enabled = false;
strReturnDate = "";
}
}
/// <summary>
/// 缴纳罚款
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button4_Click(object sender, System.EventArgs e)
{
Library.PayFine dialog = new PayFine(textBox1.Text,listView2.SelectedItems[0].SubItems[0].Text,Convert.ToDouble(label21.Text),"图书超期");
dialog.ShowDialog();
initializeReader();
}
private void button3_Click(object sender, System.EventArgs e)
{
initializeScreen();
}
private void listView2_Click(object sender, System.EventArgs e)
{
if(listView2.SelectedItems[0].SubItems[0].Text!="")
{
button4.Enabled = true;
}
else
{
button4.Enabled = false;
}
}
/// <summary>
/// 续借图书
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button1_Click(object sender, System.EventArgs e)
{
if(listView1.SelectedItems[0].SubItems[4].Text=="是")
{
MessageBox.Show("此图书已经超期，不能进行续借！","警告",MessageBoxButtons.OK,MessageBoxIcon.Warning);
return;
}
else
{
string str = "update 流通 set 续借标志=0,还书日期='"
+ Convert.ToDateTime(strReturnDate).Date.AddDays(CanBDays).ToShortDateString()
+ "' where 借书证号='" + textBox1.Text
+ "' and 图书条码号='" + listView1.SelectedItems[0].SubItems[1].Text + "'";
cmd.CommandText = str;
try
{
cmd.ExecuteNonQuery();
MessageBox.Show("成功续借图书！","提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
initializeReader();
}
catch(Exception ex)
{
MessageBox.Show("发生如下错误：\n\n" + ex.ToString(),"错误",MessageBoxButtons.OK,MessageBoxIcon.Error);
return;
}
}
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -