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); }