?? 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 + -