예제 #1
0
        /// <summary>
        /// hàm thưucj hiện lấy thông tin của dữ liệu
        /// </summary>
        private void Getdata()
        {
            // objRoom = NoitruDmucBuong.FetchByID(Utility.Int32Dbnull(txtID.Text, -1));
            //if (objRoom != null)
            //{
            //    txt_Mo_Ta.Text = Utility.sDbnull(objRoom.MotaThem, "");
            //    txt_STT_HTHI.Text = Utility.sDbnull(objRoom.SttHthi, 1);
            //    txtTEN.Text = Utility.sDbnull(objRoom.Ten, "")b;
            //}
            if (m_enAct == action.Update)
            {
                chkcodefrom.Enabled = false;
                chkAutoupdate.Visible=lblSample.Visible = lblSuffix.Visible = false;

                if (objBed != null)
                {
                    txtID.Text = Utility.sDbnull(objBed.IdGiuong);
                    txtMa.Text = objBed.MaGiuong;
                    txtTen_BHYT.Text = Utility.sDbnull(objBed.TenBhyt);
                    txt_Mo_Ta.Text = Utility.sDbnull(objBed.MotaThem);
                    txt_STT_HTHI.Text = Utility.sDbnull(objBed.SttHthi);
                    txtTEN.Text = Utility.sDbnull(objBed.TenGiuong);
                    txtSuChua.Text = Utility.sDbnull(objBed.SonguoiToida);
                    txtDongia.Text = Utility.sDbnull(objBed.GiaDichvu);
                    txtGiaBHYT.Text = Utility.sDbnull(objBed.GiaBhyt);
                    txtGiakhac.Text = Utility.sDbnull(objBed.GiaKhac);
                    txtPTDT.Text = Utility.sDbnull(objBed.PhuthuDungtuyen);
                    txtPTTT.Text = Utility.sDbnull(objBed.PhuthuTraituyen);

                    chktutuc.Checked = Utility.Byte2Bool(objBed.TthaiTunguyen);
                    chkTrangThai.Checked = Utility.Int32Dbnull(objBed.TrangThai) == 1;
                    if (Utility.Int32Dbnull(objBed.IdKhoanoitru) > 0)
                        cboKhoaNoiTru.SelectedIndex = Utility.GetSelectedIndex(cboKhoaNoiTru, objBed.IdKhoanoitru.ToString());
                    txtBuong.SetId(Utility.Int32Dbnull(objBed.IdBuong,0));
                    txtDonvitinh.SetCode(objBed.MaDonvitinh);
                }
            }

            m_dtQuanHe = SPs.NoitruLaydulieuqheDoituongBuonggiuong(Utility.Int32Dbnull(txtID.Text)).GetDataSet().Tables[0];
            Utility.SetDataSourceForDataGridEx(grdQuanheGiuong, m_dtQuanHe, false, true, "1=1", "");
            NoitruQheDoituongBuonggiuongCollection roomBedObjectTypeCollection = new Select().From(NoitruQheDoituongBuonggiuong.Schema)
                .Where(NoitruQheDoituongBuonggiuong.Columns.IdGiuong).IsEqualTo(Utility.Int32Dbnull(objBed.IdGiuong)).ExecuteAsCollection
                <NoitruQheDoituongBuonggiuongCollection>();
            foreach (Janus.Windows.GridEX.GridEXRow gridExRow in grdQuanheGiuong.GetDataRows())
            {
                var query = from giuong in roomBedObjectTypeCollection.AsEnumerable()
                            where
                                Utility.sDbnull(giuong.MaDoituongKcb) ==
                                Utility.sDbnull(gridExRow.Cells[NoitruQheDoituongBuonggiuong.Columns.MaDoituongKcb].Value)
                            select giuong;
                if (query.Any())
                {
                    gridExRow.IsChecked = true;
                }
                else
                {
                    gridExRow.IsChecked = false;
                }
            }
            if (roomBedObjectTypeCollection.Count() <= 0) grdQuanheGiuong.GetCheckedRows();
            chkApDungGia.Checked = roomBedObjectTypeCollection.Count() > 0;
            //  Utility.TryToSetBindData(dtNgayLapPhieu, "Text", objTreatment,
        }