private void getData() { TPhieuCapphatNoitru objPhieuCapphat = TPhieuCapphatNoitru.FetchByID(Utility.Int32Dbnull(txtID_CAPPHAT.Text)); if (objPhieuCapphat != null) { txtID_CAPPHAT.Text = Utility.sDbnull(objPhieuCapphat.IdCapphat); dtNgayCapPhat.Value = dtNgayCapPhat.Value; txtID_KHOA_LINH.Text = Utility.sDbnull(objPhieuCapphat.IdKhoaLinh); idKhoaLinh = Utility.Int32Dbnull(objPhieuCapphat.IdKhoaLinh); DmucKhoaphong objLDepartment = DmucKhoaphong.FetchByID(objPhieuCapphat.IdKhoaLinh); if (objLDepartment != null) { txtTen_KHOA_LINH.Text = Utility.sDbnull(objLDepartment.TenKhoaphong); } //chkIsBoSung.Checked = Convert.ToBoolean(objPhieuCapphat.LinhBSung); IsPhieuBoSung = Utility.Byte2Bool(objPhieuCapphat.LoaiPhieu); radLinhBoSung.Checked = IsPhieuBoSung; loaiphieu = Utility.sDbnull(objPhieuCapphat.LoaiPhieu); radThuoc.Checked = loaiphieu == "THUOC"; radLinhVTYT.Checked = loaiphieu == "VT"; txtID_NVIEN.Text = Utility.sDbnull(objPhieuCapphat.IdNhanviencapphat); DmucNhanvien objStaff = DmucNhanvien.FetchByID(objPhieuCapphat.IdNhanviencapphat); if (objStaff != null) { txtTen_NVIEN.Text = Utility.sDbnull(objStaff.TenNhanvien); } txtId_KhoXuat.Text = Utility.sDbnull(objPhieuCapphat.IdKhoXuat); id_khoXuat = Utility.Int32Dbnull(objPhieuCapphat.IdKhoXuat); DKho objKho = DKho.FetchByID(objPhieuCapphat.IdKhoXuat); if (objKho != null) { txtTenKho.Text = Utility.sDbnull(objKho.TenKho); } madoituong = Utility.sDbnull(objPhieuCapphat.MaDoiTuong); txtMaDoiTuong.Text = Utility.sDbnull(madoituong); SqlQuery sqlQuery = new Select().From <LObjectType>().Where(LObjectType.Columns.ObjectTypeCode).IsEqualTo(madoituong); LObjectType objectType = sqlQuery.ExecuteSingle <LObjectType>(); if (objectType != null) { txtObjectType_Name.Text = Utility.sDbnull(objectType.ObjectTypeName); } txtMOTA_THEM.Text = Utility.sDbnull(objPhieuCapphat.MotaThem); } else { dtNgayCapPhat.Value = BusinessHelper.GetSysDateTime(); txtID_KHOA_LINH.Text = Utility.sDbnull(idKhoaLinh); LDepartment objLDepartment = LDepartment.FetchByID(idKhoaLinh); if (objLDepartment != null) { txtTen_KHOA_LINH.Text = Utility.sDbnull(objLDepartment.DepartmentName); } txtID_NVIEN.Text = Utility.sDbnull(globalVariables.gv_StaffID); LStaff objStaff = LStaff.FetchByID(globalVariables.gv_StaffID); if (objStaff != null) { txtTen_NVIEN.Text = Utility.sDbnull(objStaff.StaffName); } txtId_KhoXuat.Text = Utility.sDbnull(id_khoXuat); DKho objKho = DKho.FetchByID(id_khoXuat); if (objKho != null) { txtTenKho.Text = Utility.sDbnull(objKho.TenKho); } //loaiphieu = Utility.sDbnull(objPhieuCapphat.LoaiPhieu); radThuoc.Checked = loaiphieu == "THUOC"; radLinhVTYT.Checked = loaiphieu == "VT"; radLinhBoSung.Checked = IsPhieuBoSung; // IsPhieuBoSung = Convert.ToBoolean(objPhieuCapphat.LinhBSung); txtMaDoiTuong.Text = Utility.sDbnull(madoituong); SqlQuery sqlQuery = new Select().From <LObjectType>().Where(LObjectType.Columns.ObjectTypeCode).IsEqualTo(madoituong); LObjectType objectType = sqlQuery.ExecuteSingle <LObjectType>(); if (objectType != null) { txtObjectType_Name.Text = Utility.sDbnull(objectType.ObjectTypeName); } } LoadPhieuDonThuoc(); }
private void getData() { TPhieuCapphatNoitru objPhieuCapphat = TPhieuCapphatNoitru.FetchByID(Utility.Int32Dbnull(txtID_CAPPHAT.Text)); if (objPhieuCapphat != null) { txtID_CAPPHAT.Text = Utility.sDbnull(objPhieuCapphat.IdCapphat); if (!string.IsNullOrEmpty(Utility.sDbnull(objPhieuCapphat.NgayNhap))) { dtNgayCapPhat.Value = Convert.ToDateTime(objPhieuCapphat.NgayNhap); } else { dtNgayCapPhat.Value = DateTime.Now; } txtID_KHOA_LINH.Text = Utility.sDbnull(objPhieuCapphat.IdKhoaLinh); idKhoaLinh = Utility.Int32Dbnull(objPhieuCapphat.IdKhoaLinh); DmucKhoaphong objLDepartment = DmucKhoaphong.FetchByID(objPhieuCapphat.IdKhoaLinh); if (objLDepartment != null) { txtTen_KHOA_LINH.Text = Utility.sDbnull(objLDepartment.DepartmentName); } //chkIsBoSung.Checked = Convert.ToBoolean(objPhieuCapphat.LinhBSung); IsPhieuBoSung = Convert.ToBoolean(objPhieuCapphat.loaiPhieu); radLinhBoSung.Checked = IsPhieuBoSung; loaiphieu = Utility.sDbnull(objPhieuCapphat.LoaiPhieu); radThuoc.Checked = loaiphieu == "THUOC"; radLinhVTYT.Checked = loaiphieu == "VT"; txtID_NVIEN.Text = Utility.sDbnull(objPhieuCapphat.idn); DmucNhanvien objStaff = DmucNhanvien.FetchByID(objPhieuCapphat.IdNvien); if (objStaff != null) { txtTen_NVIEN.Text = Utility.sDbnull(objStaff.StaffName); } txtId_KhoXuat.Text = Utility.sDbnull(objPhieuCapphat.IdKhoXuat); id_khoXuat = Utility.Int32Dbnull(objPhieuCapphat.IdKhoXuat); DKho objKho = DKho.FetchByID(objPhieuCapphat.IdKhoXuat); if (objKho != null) { txtTenKho.Text = Utility.sDbnull(objKho.TenKho); } madoituong = Utility.sDbnull(objPhieuCapphat.MaDoiTuong); txtMaDoiTuong.Text = Utility.sDbnull(madoituong); if (globalVariables.gv_TongHopDonThuocMaDoiTuong) { SqlQuery sqlQuery = new Select().From <LObjectType>().Where(LObjectType.Columns.ObjectTypeCode).IsEqualTo(madoituong); var objectType = sqlQuery.ExecuteSingle <LObjectType>(); if (objectType != null) { txtObjectType_Name.Text = Utility.sDbnull(objectType.ObjectTypeName); } } else { txtObjectType_Name.Text = "Tất cả"; } txtMOTA_THEM.Text = Utility.sDbnull(objPhieuCapphat.MotaThem); me_Action = action.Update; } else { dtNgayCapPhat.Value = globalVariables.SysDate; txtID_KHOA_LINH.Text = Utility.sDbnull(idKhoaLinh); LDepartment objLDepartment = LDepartment.FetchByID(idKhoaLinh); if (objLDepartment != null) { txtTen_KHOA_LINH.Text = Utility.sDbnull(objLDepartment.DepartmentName); } txtID_NVIEN.Text = Utility.sDbnull(globalVariables.gv_StaffID); LStaff objStaff = LStaff.FetchByID(globalVariables.gv_StaffID); if (objStaff != null) { txtTen_NVIEN.Text = Utility.sDbnull(objStaff.StaffName); } txtId_KhoXuat.Text = Utility.sDbnull(id_khoXuat); DKho objKho = DKho.FetchByID(id_khoXuat); if (objKho != null) { txtTenKho.Text = Utility.sDbnull(objKho.TenKho); } //loaiphieu = Utility.sDbnull(objPhieuCapphat.LoaiPhieu); radThuoc.Checked = loaiphieu == "THUOC"; radLinhVTYT.Checked = loaiphieu == "VT"; radLinhBoSung.Checked = IsPhieuBoSung; // IsPhieuBoSung = Convert.ToBoolean(objPhieuCapphat.LinhBSung); txtMaDoiTuong.Text = Utility.sDbnull(madoituong); if (globalVariables.gv_TongHopDonThuocMaDoiTuong) { SqlQuery sqlQuery = new Select().From <LObjectType>().Where(LObjectType.Columns.ObjectTypeCode).IsEqualTo(madoituong); var objectType = sqlQuery.ExecuteSingle <LObjectType>(); if (objectType != null) { txtObjectType_Name.Text = Utility.sDbnull(objectType.ObjectTypeName); } } else { txtObjectType_Name.Text = "Tất cả"; } } LoadDonThuoc(); }