private void thôngTinChiTiếtToolStripMenuItem_Click(object sender, EventArgs e)
{
if (lvMuonTra.SelectedItems.Count > 0)
{
ListViewItem lvi = lvMuonTra.SelectedItems[0];
GiaoDienMuonTra s = lvi.Tag as GiaoDienMuonTra;
Form_ChiTietMuonTra temp = new Form_ChiTietMuonTra();
temp.MaMuonTra = s.MaMuonTra;
temp.Show();
}
}
public List <GiaoDienMuonTra> TimKiemMuonTra(string strthongtin)
{
List <GiaoDienMuonTra> LS = new List <GiaoDienMuonTra>();
OpenConnection();
SqlCommand command = new SqlCommand();
command.CommandType = CommandType.Text;
command.CommandText = "select * from dbo.TimKiemMuonTra(@strthongtin)";
command.Connection = conn;
command.Parameters.Add("@strthongtin", SqlDbType.NVarChar).Value = strthongtin;
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
GiaoDienMuonTra temp = new GiaoDienMuonTra();
temp.MaMuonTra = reader.GetInt32(0);
if (!reader.IsDBNull(1))
{
temp.MaSach = reader.GetString(1);
}
else
{
temp.MaSach = "Chưa có thông tin";
}
if (!reader.IsDBNull(2))
{
temp.MaDocGia = reader.GetInt32(2);
}
else
{
temp.MaDocGia = 0;
}
if (!reader.IsDBNull(3))
{
temp.TenDocGia = reader.GetString(3);
}
else
{
temp.TenDocGia = "Chưa có thông tin";
}
if (!reader.IsDBNull(4))
{
int datra = reader.GetInt32(4);
if (datra == 0)
{
temp.TinhTrang = "Chưa trả";
}
else
{
temp.TinhTrang = "Đã trả";
}
}
else
{
temp.TinhTrang = "Chưa có thông tin";
}
LS.Add(temp);
}
reader.Close();
return(LS);
}
