protected void Page_Load(object sender, EventArgs e) { DataService._ConnectionString = ConfigurationManager.ConnectionStrings["QLConnectionString"].ConnectionString; if ((int)Session["Login"] == 0) { Response.Redirect("~/DangNhap.aspx"); } if ((string)Session["LoaiNguoiDung"] == "Bac si") { Response.Redirect("~/KhongCoChucNang.aspx"); } ThamSoControl tsctr = new ThamSoControl(); ThamSoInfo tsinfo = new ThamSoInfo(); tsinfo = tsctr.spLayThongTinBangThamSoCoMa(1);// so nguoi dang ky toi da lbSLNguoi.Text = tsinfo.GiaTri.ToString(); PhieuDangKyControl pdkctr = new PhieuDangKyControl(); //if (!IsPostBack) DateTime ngaytam = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day); { int sl = pdkctr.DemSLBenhNhanDKTrongNgay(ngaytam); lbSoNguoi.Text = sl.ToString(); } }
// create proc sp_LayThongTinBangThamSoCoMa @MaTS int public ThamSoInfo spLayThongTinBangThamSoCoMa(int MaTS) { ThamSoInfo info = new ThamSoInfo(); dataService.Conect(); dataService.Cmd = new SqlCommand("sp_LayThongTinBangThamSoCoMa", dataService.Cnn); dataService.Cmd.CommandType = CommandType.StoredProcedure; dataService.Cmd.Parameters.Add("@MaTS", SqlDbType.Int); dataService.Cmd.Parameters["@MaTS"].Value = MaTS; SqlDataReader r = dataService.Cmd.ExecuteReader(); while (r.Read()) { info.GiaTri = int.Parse(r.GetValue(2).ToString()); } dataService.DisConect(); return(info); }
protected void btDangKy_Click(object sender, EventArgs e) { // kiem tra so luong nguoi da dang ky trong ngay PhieuDangKyControl pdkctr = new PhieuDangKyControl(); int SluongDK = pdkctr.DemSLBenhNhanDKTrongNgay(UCNgayThangNam2.NgayThang); ThamSoControl tsctr = new ThamSoControl(); ThamSoInfo tsinfo = new ThamSoInfo(); tsinfo = tsctr.spLayThongTinBangThamSoCoMa(1); int SLDKToiDa = tsinfo.GiaTri; if (SluongDK > SLDKToiDa) { // khong cho dang ky Label1.Text = "So Luong DK Vuot Muc cho Phep,Chon Ngay Khac Di"; return; } Label1.Text = ""; int MaNguoiLon; int MaTK = (int)Session["MaTK"]; NguoiLonControl nglonctr = new NguoiLonControl(); MaNguoiLon = nglonctr.MaBenhNhanKhiBietMaTK(MaTK); //dang ky cho tre em // lay ma nguoi lon dang online= ma nguoi lon // int MaBenhNhan = 3; BenhNhanControl ctrBN = new BenhNhanControl(); BenhNhanInfo infoBN = new BenhNhanInfo(); infoBN.Ten = txtHotenTre.Text; infoBN.NgaySinh = UCNgayThangNam1.NgayThang; infoBN.DiaChi = txtDiachi.Text; if (ckNam.Checked == true) { infoBN.Phai = "Nam"; } else { infoBN.Phai = "Nu"; } ctrBN.ThemThongTinBenhNhan(infoBN); //nhap cac thong tin //luu xuong bang benh nhan //lay ma tre em vua moi luu= ma benh nhan //lay ma nguoi lon= ma nguoi lon dang Online TreEmControl ctrTE = new TreEmControl(); TreEmInfo infoTE = new TreEmInfo(); //int MaNguoiLon = 3; infoBN = ctrBN.ThongTinBenhNhanVuaThem(); infoTE.MaBenhNhan = infoBN.Ma; infoTE.MaNguoiLon = MaNguoiLon; ctrTE.ThemTreEm(infoTE); // lb.Text = "Them Thanh Cong Benh Nhan Tre Em"; // luu xuong bang tre em //luu xuong bang Dang ky PhieuDangKyControl ctrpdk = new PhieuDangKyControl(); PhieuDangKyInfo infopdk = new PhieuDangKyInfo(); infopdk.MaBenhNhan = MaNguoiLon; infopdk.Ngay = UCNgayThangNam2.NgayThang; infopdk.TrieuChung = txtTCtreem.Text; ctrpdk.sp_ThemPhieuDangKy(infopdk); int soluong = ctrpdk.DemSLBenhNhanDKTrongNgay(infopdk.Ngay); lbsoluong.Text = soluong.ToString(); Label2.Text = "Them Thanh Cong Dang ky "; }