//create proc sp_ThongTinKhoaCoMa @MaKhoa //lay thong tin 1 khoa public KhoaInfo sp_ThongTinKhoaCoMa(int MaKhoa) { KhoaInfo info = new KhoaInfo(); dataService.Conect(); dataService.Cmd = new SqlCommand("sp_ThongTinKhoaCoMa", dataService.Cnn); dataService.Cmd.CommandType = CommandType.StoredProcedure; dataService.Cmd.Parameters.Add("@MaKhoa", SqlDbType.Int); dataService.Cmd.Parameters["@MaKhoa"].Value = MaKhoa; info = (KhoaInfo)dataService.Cmd.ExecuteScalar(); dataService.DisConect(); return(info); }
//DS cac khoa trong benh vien //create proc sp_DanhSachKhoa public List <KhoaInfo> sp_DanhSachKhoa() { List <KhoaInfo> arr = new List <KhoaInfo>(); SqlDataReader r; dataService.Conect(); dataService.Cmd = new SqlCommand("sp_DanhSachKhoa", dataService.Cnn); dataService.Cmd.CommandType = CommandType.StoredProcedure; r = dataService.Cmd.ExecuteReader(); KhoaInfo info; while (r.Read()) { info = new KhoaInfo(); info.Ma = int.Parse(r.GetValue(0).ToString()); info.Ten = r.GetValue(1).ToString(); arr.Add(info); } dataService.DisConect(); return(arr); }