Пример #1
0
        public Phong(int maphong)
        {
            MaPhong = maphong;
            if (maphong == 0)
            {
                TenPhong  = ViTri = "";
                GiaPhong  = 0;
                TrangThai = 1;
                return;
            }
            DataTable dt = PhongControl.layDuLieu(maphong);

            TenPhong  = dt.Rows[0]["TenPhong"].ToString();
            ViTri     = dt.Rows[0]["ViTri"].ToString();
            GiaPhong  = double.Parse(dt.Rows[0]["GiaPhong"].ToString());
            TrangThai = Convert.ToInt16(dt.Rows[0]["TrangThai"]);
        }
Пример #2
0
        public frmSuaPhong(int id)
        {
            InitializeComponent();
            maphong = id;
            DataTable dt = PhongControl.layThongTin(id);

            txtTenCu.Text   = dt.Rows[0]["TenPhong"].ToString();
            txtViTriCu.Text = dt.Rows[0]["ViTri"].ToString();
            txtGiaCu.Text   = dt.Rows[0]["GiaPhong"].ToString();
            string trangthai = "";

            if (Convert.ToInt32(dt.Rows[0]["TrangThai"].ToString()) == 1)
            {
                trangthai = "Chưa Sử Dụng";
            }
            else
            {
                trangthai = "Đang Sử Dụng";
            }
            txtTrangThai.Text = trangthai;
        }
Пример #3
0
        private void loadDuLieu()
        {
            dgvDanhSach.Rows.Clear();
            DataTable dt = PhongControl.layDanhSach();

            lblPhong.Text = lblPhong.Text + dt.Rows.Count.ToString();

            for (int i = 0; i < dt.Rows.Count; ++i)
            {
                string trangthai = "";
                if (Convert.ToInt32(dt.Rows[i]["TrangThai"].ToString()) == 1)
                {
                    trangthai = "Trống";
                }
                else
                {
                    trangthai = "Đang Sử Dụng";
                }
                dgvDanhSach.Rows.Add(dt.Rows[i]["MaPhong"], dt.Rows[i]["TenPhong"], dt.Rows[i]["ViTri"], dt.Rows[i]["GiaPhong"], trangthai);
            }
        }