public static VAITRO LAYVAITRO(int ID_VAITRO)
{
VAITRO vaitro = new VAITRO();
SqlConnection sc = connectme();
SqlCommand com = new SqlCommand("Select * from VAI_TRO where ID_VAITRO = @ID_VAITRO", sc);
com.Parameters.AddWithValue("@ID_VAITRO", ID_VAITRO);
SqlDataReader sdr = com.ExecuteReader();
sdr.Read();
if (sdr.HasRows == true)
{
vaitro.ID_VAITRO = Convert.ToInt32(sdr[0].ToString());
vaitro.TENVAITRO = sdr[1].ToString();
vaitro.QL_KHO = Convert.ToBoolean(sdr[2].ToString());
vaitro.QL_SANPHAM = Convert.ToBoolean(sdr[3].ToString());
vaitro.QL_NHANVIEN = Convert.ToBoolean(sdr[4].ToString());
vaitro.QL_NHAPP = Convert.ToBoolean(sdr[5].ToString());
vaitro.QL_HOADON = Convert.ToBoolean(sdr[6].ToString());
vaitro.QL_PHIEUHANG = Convert.ToBoolean(sdr[7].ToString());
}
sdr.Close();
sc.Close();
return(vaitro);
}
public static VAITRO LAYVAITRO(int ID_VAITRO)
{
VAITRO vaitro = ConnectDB.ConnectDB.LAYVAITRO(ID_VAITRO);
return(vaitro);
}
