public bool Destroy(object Id) { return(KcbBenhAn.Destroy(Id) == 1); }
public void Insert(string SoBenhAn, string LoaiBa, long IdBnhan, string MaLuotkham, string NgaySinh, string ThangSinh, string DanToc, string NoiLamviec, string ThongtinLhe, string DthoaiLhe, string CdoanGioithieu, short?YTe, short?LdoVaovienMm, short?LdoVaovienGsc, short?LdoVaovienKndn, short?LdoVaovienGtl, short?LdoVaovienKhac, string HbNam, string HbNoiCdoan, short?HbDieuTri, short?HbTiemInsulin, string HbInsulin1, string HbInsulin2, string HbThuochaDuonghuyet, string HbHa, string HbRllp, string HbThuocChongdong, short?HtaiMm, short?HtaiGaysc, string HtaiKgDau, string HtaiKgSau, short?HtaiKhatnhieu, string HtaiUong, short?HtaiDainhieu, string HtaiDai, short?HtaiGiamtl, string HtaiKhac, short?TsbBtChuaphathien, short?TsbBtNhoimaucotim, string TsbBtNamNmct, short?TsbBtTbmn, string TsbBtNamTbmn, string TsbHaNam, string TsbHaMax, short?TsbBtCON4000, string TsbBtKhac, short?TsgdDtd, short?TsgdTanghuyetap, short?TsgdNhoimaucotim, string TsgdKhac, short?KcbMatnuoc, short?KcbXuathuyet, short?KcbPhu, string KcbToanthanKhac, string KcbNhiptim, short?KcbTthaiNhiptim, string KcbTiengtim, string KcbHohap, string KcbBung, short?KcbChanphai, string KcbChanphaiKhac, short?KcbChantrai, string KcbChantraiKhac, string KcbMatphai, string KcbMattrai, string KcbRanghammat, string KcbTkinhKhac, string KcbMach, string KcbNhietdo, string KcbHuyetap1, string KcbHuyetap2, string KcbNhiptho, string KcbCannang, string KcbChieucao, string KcbBmi, string KcbTomtatClsChinh, string KcbCdoanBdau, string KcbDaXly, string KcbCdoanRavien, DateTime?KcbDtriTungay, DateTime?KcbDtriDenngay, string TkbaQtrinhBenhlyDbienCls, string TkbaPphapDtri, short?TrangThai, short?NamSinh, string DiaChi, string DoiTuong, string SoBhyt, string IcdBenhChnh, string TenBenhChinh, string IcdBenhPhu, string TenBenhPhu, string TkbaTomtatKqCls, string TkbaTtRavien, string TkbaHuongTtTieptheo, short?TgLlvvMm, short?TgLdvvGsc, short?TgLdvvRct, short?TgLdvvCt, short?TgLdvvMl, short?TgLdvvKhac, string TgLdvvKHAC1, string TgHbQtblChandoan, string TgHbQtblNam, string TgHbQtblNoiChanDoan, short?TgHbQtblDieutriDeu, string TgHbQtblThuocDIEUTRI1, string TgHbQtblThuocDIEUTRI2, string TgHbQtblThuocDIEUTRI3, string TgHbQtblThuocDIEUTRI4, string TgHbQtblThuocDIEUTRI5, short?TgHbHtMm, short?TgHbHtGsc, string TgHbHtKgdau, string TgHbHtKgcuoi, short?TgHbHtRct, short?TgHbHtVtgt, short?TgHbHtMl, short?TgHbHtNnb, short?TgHbHtRlth, string TgHbHtTcp, string TgHbHtSldn, string TgHbHtKhac, short?TgHbTsbHpq, short?TgHbTsbBldd, short?TgHbTsbKn, string TgHbTsbKhac, short?TgHbTsbBasedow, short?TgHbTsbBc, string TgHbTsbKHAC1, short?TgKbKbDna, short?TgKbKbCmmv, short?TgKbKbTr, string TgKbKbNt, short?TgKbKbNtDeu, string TgKbKbTt, short?TgKbKbLa, short?TgKbKbLb, short?TgKbKbLl, short?TgKbKbLll, short?TgKbKbMdm, short?TgKbKbMdc, short?TgKbKbBlt, short?TgKbKbBntp, short?TgKbKbBntt, short?TgKbKbBN2T, short?TgKbKbTtttp, short?TgKbKbTtttt, short?TgKbKbTtltp, short?TgKbKbTtltt, string TgKbKbMp, string TgKbKbMt, string TgKbKbB, string TgKbKbTk, string TgKbKbHh, string TgKbKbTtkqcks, string TgKbKbCdbd, string TgKbKbDxl, string TgKbKbCdrv, DateTime?TgKbKbTungay, DateTime?TgKbKbDenngay, string TgKbKbMach, string TgKbKbNhietdo, string TgKbKbHuyetap, string TgKbKbNhiptho, string TgKbKbCannang, string TgKbKbChieucao, string TgKbKbBmi, short?InPhieuLog, DateTime?NgayIn, string NguoiIn, short?LoaiBenhAn, short?BaLog, DateTime?NgaySua, string NguoiSua, string BatLdvv, string BatBhQtbl, string BatHbBt, string BatHbGd, string BatKbTt, string BatKbCbp, string BatKbKqcls, string BatKbCdbd, string BatKbDxl, string BatKbCdrv, string NguoiTao, DateTime?NgayTao, DateTime?NgayKham, string LastActionName) { KcbBenhAn item = new KcbBenhAn(); item.SoBenhAn = SoBenhAn; item.LoaiBa = LoaiBa; item.IdBnhan = IdBnhan; item.MaLuotkham = MaLuotkham; item.NgaySinh = NgaySinh; item.ThangSinh = ThangSinh; item.DanToc = DanToc; item.NoiLamviec = NoiLamviec; item.ThongtinLhe = ThongtinLhe; item.DthoaiLhe = DthoaiLhe; item.CdoanGioithieu = CdoanGioithieu; item.YTe = YTe; item.LdoVaovienMm = LdoVaovienMm; item.LdoVaovienGsc = LdoVaovienGsc; item.LdoVaovienKndn = LdoVaovienKndn; item.LdoVaovienGtl = LdoVaovienGtl; item.LdoVaovienKhac = LdoVaovienKhac; item.HbNam = HbNam; item.HbNoiCdoan = HbNoiCdoan; item.HbDieuTri = HbDieuTri; item.HbTiemInsulin = HbTiemInsulin; item.HbInsulin1 = HbInsulin1; item.HbInsulin2 = HbInsulin2; item.HbThuochaDuonghuyet = HbThuochaDuonghuyet; item.HbHa = HbHa; item.HbRllp = HbRllp; item.HbThuocChongdong = HbThuocChongdong; item.HtaiMm = HtaiMm; item.HtaiGaysc = HtaiGaysc; item.HtaiKgDau = HtaiKgDau; item.HtaiKgSau = HtaiKgSau; item.HtaiKhatnhieu = HtaiKhatnhieu; item.HtaiUong = HtaiUong; item.HtaiDainhieu = HtaiDainhieu; item.HtaiDai = HtaiDai; item.HtaiGiamtl = HtaiGiamtl; item.HtaiKhac = HtaiKhac; item.TsbBtChuaphathien = TsbBtChuaphathien; item.TsbBtNhoimaucotim = TsbBtNhoimaucotim; item.TsbBtNamNmct = TsbBtNamNmct; item.TsbBtTbmn = TsbBtTbmn; item.TsbBtNamTbmn = TsbBtNamTbmn; item.TsbHaNam = TsbHaNam; item.TsbHaMax = TsbHaMax; item.TsbBtCON4000 = TsbBtCON4000; item.TsbBtKhac = TsbBtKhac; item.TsgdDtd = TsgdDtd; item.TsgdTanghuyetap = TsgdTanghuyetap; item.TsgdNhoimaucotim = TsgdNhoimaucotim; item.TsgdKhac = TsgdKhac; item.KcbMatnuoc = KcbMatnuoc; item.KcbXuathuyet = KcbXuathuyet; item.KcbPhu = KcbPhu; item.KcbToanthanKhac = KcbToanthanKhac; item.KcbNhiptim = KcbNhiptim; item.KcbTthaiNhiptim = KcbTthaiNhiptim; item.KcbTiengtim = KcbTiengtim; item.KcbHohap = KcbHohap; item.KcbBung = KcbBung; item.KcbChanphai = KcbChanphai; item.KcbChanphaiKhac = KcbChanphaiKhac; item.KcbChantrai = KcbChantrai; item.KcbChantraiKhac = KcbChantraiKhac; item.KcbMatphai = KcbMatphai; item.KcbMattrai = KcbMattrai; item.KcbRanghammat = KcbRanghammat; item.KcbTkinhKhac = KcbTkinhKhac; item.KcbMach = KcbMach; item.KcbNhietdo = KcbNhietdo; item.KcbHuyetap1 = KcbHuyetap1; item.KcbHuyetap2 = KcbHuyetap2; item.KcbNhiptho = KcbNhiptho; item.KcbCannang = KcbCannang; item.KcbChieucao = KcbChieucao; item.KcbBmi = KcbBmi; item.KcbTomtatClsChinh = KcbTomtatClsChinh; item.KcbCdoanBdau = KcbCdoanBdau; item.KcbDaXly = KcbDaXly; item.KcbCdoanRavien = KcbCdoanRavien; item.KcbDtriTungay = KcbDtriTungay; item.KcbDtriDenngay = KcbDtriDenngay; item.TkbaQtrinhBenhlyDbienCls = TkbaQtrinhBenhlyDbienCls; item.TkbaPphapDtri = TkbaPphapDtri; item.TrangThai = TrangThai; item.NamSinh = NamSinh; item.DiaChi = DiaChi; item.DoiTuong = DoiTuong; item.SoBhyt = SoBhyt; item.IcdBenhChnh = IcdBenhChnh; item.TenBenhChinh = TenBenhChinh; item.IcdBenhPhu = IcdBenhPhu; item.TenBenhPhu = TenBenhPhu; item.TkbaTomtatKqCls = TkbaTomtatKqCls; item.TkbaTtRavien = TkbaTtRavien; item.TkbaHuongTtTieptheo = TkbaHuongTtTieptheo; item.TgLlvvMm = TgLlvvMm; item.TgLdvvGsc = TgLdvvGsc; item.TgLdvvRct = TgLdvvRct; item.TgLdvvCt = TgLdvvCt; item.TgLdvvMl = TgLdvvMl; item.TgLdvvKhac = TgLdvvKhac; item.TgLdvvKHAC1 = TgLdvvKHAC1; item.TgHbQtblChandoan = TgHbQtblChandoan; item.TgHbQtblNam = TgHbQtblNam; item.TgHbQtblNoiChanDoan = TgHbQtblNoiChanDoan; item.TgHbQtblDieutriDeu = TgHbQtblDieutriDeu; item.TgHbQtblThuocDIEUTRI1 = TgHbQtblThuocDIEUTRI1; item.TgHbQtblThuocDIEUTRI2 = TgHbQtblThuocDIEUTRI2; item.TgHbQtblThuocDIEUTRI3 = TgHbQtblThuocDIEUTRI3; item.TgHbQtblThuocDIEUTRI4 = TgHbQtblThuocDIEUTRI4; item.TgHbQtblThuocDIEUTRI5 = TgHbQtblThuocDIEUTRI5; item.TgHbHtMm = TgHbHtMm; item.TgHbHtGsc = TgHbHtGsc; item.TgHbHtKgdau = TgHbHtKgdau; item.TgHbHtKgcuoi = TgHbHtKgcuoi; item.TgHbHtRct = TgHbHtRct; item.TgHbHtVtgt = TgHbHtVtgt; item.TgHbHtMl = TgHbHtMl; item.TgHbHtNnb = TgHbHtNnb; item.TgHbHtRlth = TgHbHtRlth; item.TgHbHtTcp = TgHbHtTcp; item.TgHbHtSldn = TgHbHtSldn; item.TgHbHtKhac = TgHbHtKhac; item.TgHbTsbHpq = TgHbTsbHpq; item.TgHbTsbBldd = TgHbTsbBldd; item.TgHbTsbKn = TgHbTsbKn; item.TgHbTsbKhac = TgHbTsbKhac; item.TgHbTsbBasedow = TgHbTsbBasedow; item.TgHbTsbBc = TgHbTsbBc; item.TgHbTsbKHAC1 = TgHbTsbKHAC1; item.TgKbKbDna = TgKbKbDna; item.TgKbKbCmmv = TgKbKbCmmv; item.TgKbKbTr = TgKbKbTr; item.TgKbKbNt = TgKbKbNt; item.TgKbKbNtDeu = TgKbKbNtDeu; item.TgKbKbTt = TgKbKbTt; item.TgKbKbLa = TgKbKbLa; item.TgKbKbLb = TgKbKbLb; item.TgKbKbLl = TgKbKbLl; item.TgKbKbLll = TgKbKbLll; item.TgKbKbMdm = TgKbKbMdm; item.TgKbKbMdc = TgKbKbMdc; item.TgKbKbBlt = TgKbKbBlt; item.TgKbKbBntp = TgKbKbBntp; item.TgKbKbBntt = TgKbKbBntt; item.TgKbKbBN2T = TgKbKbBN2T; item.TgKbKbTtttp = TgKbKbTtttp; item.TgKbKbTtttt = TgKbKbTtttt; item.TgKbKbTtltp = TgKbKbTtltp; item.TgKbKbTtltt = TgKbKbTtltt; item.TgKbKbMp = TgKbKbMp; item.TgKbKbMt = TgKbKbMt; item.TgKbKbB = TgKbKbB; item.TgKbKbTk = TgKbKbTk; item.TgKbKbHh = TgKbKbHh; item.TgKbKbTtkqcks = TgKbKbTtkqcks; item.TgKbKbCdbd = TgKbKbCdbd; item.TgKbKbDxl = TgKbKbDxl; item.TgKbKbCdrv = TgKbKbCdrv; item.TgKbKbTungay = TgKbKbTungay; item.TgKbKbDenngay = TgKbKbDenngay; item.TgKbKbMach = TgKbKbMach; item.TgKbKbNhietdo = TgKbKbNhietdo; item.TgKbKbHuyetap = TgKbKbHuyetap; item.TgKbKbNhiptho = TgKbKbNhiptho; item.TgKbKbCannang = TgKbKbCannang; item.TgKbKbChieucao = TgKbKbChieucao; item.TgKbKbBmi = TgKbKbBmi; item.InPhieuLog = InPhieuLog; item.NgayIn = NgayIn; item.NguoiIn = NguoiIn; item.LoaiBenhAn = LoaiBenhAn; item.BaLog = BaLog; item.NgaySua = NgaySua; item.NguoiSua = NguoiSua; item.BatLdvv = BatLdvv; item.BatBhQtbl = BatBhQtbl; item.BatHbBt = BatHbBt; item.BatHbGd = BatHbGd; item.BatKbTt = BatKbTt; item.BatKbCbp = BatKbCbp; item.BatKbKqcls = BatKbKqcls; item.BatKbCdbd = BatKbCdbd; item.BatKbDxl = BatKbDxl; item.BatKbCdrv = BatKbCdrv; item.NguoiTao = NguoiTao; item.NgayTao = NgayTao; item.NgayKham = NgayKham; item.LastActionName = LastActionName; item.Save(UserName); }
private KcbBenhAn CreateBenhAnNgoaiTru() { KcbBenhAn objBenhAnNgoaiTru = new KcbBenhAn(); try { if (em_Action == action.Update) { objBenhAnNgoaiTru.IsLoaded = true; objBenhAnNgoaiTru.MarkOld(); objBenhAnNgoaiTru.Id = Utility.Int32Dbnull(txtID_BA.Text, -1); objBenhAnNgoaiTru.NgaySua = globalVariables.SysDate; objBenhAnNgoaiTru.NguoiSua = globalVariables.UserName; } if (em_Action == action.Insert) { objBenhAnNgoaiTru.NguoiTao = globalVariables.UserName; objBenhAnNgoaiTru.NgayTao = globalVariables.SysDate; } objBenhAnNgoaiTru.SoBenhAn = Utility.sDbnull(txtMaBenhAn.Text, -1); objBenhAnNgoaiTru.IdBnhan = Utility.Int32Dbnull(txtMaBN.Text); objBenhAnNgoaiTru.NgaySinh = Utility.sDbnull(txtNgaySinh.Text); objBenhAnNgoaiTru.ThangSinh = Utility.sDbnull(txtThangSinh.Text); objBenhAnNgoaiTru.DanToc = Utility.sDbnull(txtDanToc.Text); objBenhAnNgoaiTru.NoiLamviec = Utility.sDbnull(txtNoiLamViec.Text); objBenhAnNgoaiTru.ThongtinLhe = Utility.sDbnull(txtThongTinLienHe.Text); objBenhAnNgoaiTru.DthoaiLhe = Utility.sDbnull(txtDienThoai.Text); objBenhAnNgoaiTru.CdoanGioithieu = Utility.sDbnull(txtChanDoanBanDau.Text); objBenhAnNgoaiTru.NgayKham = Convert.ToDateTime(dtThoiDiemDkKham.Value); if (chkYTe.Checked) objBenhAnNgoaiTru.YTe = 1; else if (chkTuDen.Checked) { objBenhAnNgoaiTru.YTe = 2; } else { objBenhAnNgoaiTru.YTe = 3; } objBenhAnNgoaiTru.TgLlvvMm = Utility.Int16Dbnull(TG_chkldvvMetMoi.Checked ? 1 : 0); objBenhAnNgoaiTru.TgLdvvGsc = Utility.Int16Dbnull(TG_chkldvvGay.Checked ? 1 : 0); objBenhAnNgoaiTru.TgLdvvRct = Utility.Int16Dbnull(TG_chkldvvRCT.Checked ? 1 : 0); objBenhAnNgoaiTru.TgLdvvCt = Utility.Int16Dbnull(TG_chkldvvCoTo.Checked ? 1 : 0); objBenhAnNgoaiTru.TgLdvvMl = Utility.Int16Dbnull(TG_ldvvMatLoi.Checked ? 1 : 0); objBenhAnNgoaiTru.TgLdvvKhac = Utility.Int16Dbnull(TG_chkldvvKhac.Checked ? 1 : 0); objBenhAnNgoaiTru.TgHbQtblNam = Utility.sDbnull(TG_txtNamChanDoanBasedow.Text); objBenhAnNgoaiTru.TgHbQtblNoiChanDoan = Utility.sDbnull(txtNoiChanDoanBasedow.Text); if (chkhbDeu.Checked) objBenhAnNgoaiTru.TgHbQtblDieutriDeu = 1; else if (chkhbKhongDeu.Checked) { objBenhAnNgoaiTru.TgHbQtblDieutriDeu = 2; } else { objBenhAnNgoaiTru.TgHbQtblDieutriDeu = 3; } objBenhAnNgoaiTru.TgHbQtblThuocDIEUTRI1 = Utility.sDbnull(txtThuocDieuTri1.Text); objBenhAnNgoaiTru.TgHbQtblThuocDIEUTRI2 = Utility.sDbnull(txtThuocDieuTri2.Text); objBenhAnNgoaiTru.TgHbQtblThuocDIEUTRI3 = Utility.sDbnull(txtThuocDieuTri3.Text); objBenhAnNgoaiTru.TgHbQtblThuocDIEUTRI4 = Utility.sDbnull(txtThuocDieuTri4.Text); objBenhAnNgoaiTru.TgHbQtblThuocDIEUTRI5 = Utility.sDbnull(txtThuocDieuTri5.Text); objBenhAnNgoaiTru.TgHbHtMm = Utility.Int16Dbnull(chkhbMetMoi.Checked ? 1 : 0); objBenhAnNgoaiTru.TgHbHtGsc = Utility.Int16Dbnull(chkhbGaySutCan.Checked ? 1 : 0); objBenhAnNgoaiTru.TgHbHtKgdau = Utility.sDbnull(txthbKgDau.Text); objBenhAnNgoaiTru.TgHbHtKgcuoi = Utility.sDbnull(txthbKgSau.Text); objBenhAnNgoaiTru.TgHbHtRct = Utility.Int16Dbnull(chkhbRunchantay.Checked ? 1 : 0); objBenhAnNgoaiTru.TgHbHtVtgt = Utility.Int16Dbnull(chkhbVungTGto.Checked ? 1 : 0); objBenhAnNgoaiTru.TgHbHtMl = Utility.Int16Dbnull(chkhbMatLoi.Checked ? 1 : 0); objBenhAnNgoaiTru.TgHbHtNnb = Utility.Int16Dbnull(chkNguoiNongBung.Checked ? 1 : 0); objBenhAnNgoaiTru.TgHbHtRlth = Utility.Int16Dbnull(chkRoiLoanTieuHoa.Checked ? 1 : 0); objBenhAnNgoaiTru.TgHbHtTcp = Utility.sDbnull(txtTinhChatPhan.Text); objBenhAnNgoaiTru.TgHbHtSldn = Utility.sDbnull(txtSoLanDiNgoai.Text); objBenhAnNgoaiTru.TgHbHtKhac = Utility.sDbnull(txthbKhac.Text); if (chktsbHenPheQuanCo.Checked) objBenhAnNgoaiTru.TgHbTsbHpq = 1; else if (chktsbHenPheQuanKhong.Checked) { objBenhAnNgoaiTru.TgHbTsbHpq = 2; } else { objBenhAnNgoaiTru.TgHbTsbHpq = 3; } if (chkBenhLyDaDayCo.Checked) objBenhAnNgoaiTru.TgHbTsbBldd = 1; else if (chkBenhLyDaDayKhong.Checked) { objBenhAnNgoaiTru.TgHbTsbBldd = 2; } else { objBenhAnNgoaiTru.TgHbTsbBldd = 3; } if (chkKinhNguyetDeu.Checked) objBenhAnNgoaiTru.TgHbTsbKn = 1; else if (chkKinhNguyetKhong.Checked) { objBenhAnNgoaiTru.TgHbTsbKn = 2; } else { objBenhAnNgoaiTru.TgHbTsbKn = 3; } objBenhAnNgoaiTru.TgHbTsbKhac = Utility.sDbnull(txttsbKhac.Text); objBenhAnNgoaiTru.TgHbTsbBasedow = Utility.Int16Dbnull(chktsgdBasedow.Checked ? 1 : 0); objBenhAnNgoaiTru.TgHbTsbBc = Utility.Int16Dbnull(chktsgdBuouCo.Checked ? 1 : 0); objBenhAnNgoaiTru.TgHbTsbKHAC1 = Utility.sDbnull(txttsgdKhac.Text); if (chkkbDaNongAmCo.Checked) objBenhAnNgoaiTru.TgKbKbDna = 1; else if (chkkbDaNongAmKhong.Checked) { objBenhAnNgoaiTru.TgKbKbDna = 2; } else { objBenhAnNgoaiTru.TgKbKbDna = 3; } if (chkkbCungMacMatVangCo.Checked) objBenhAnNgoaiTru.TgKbKbCmmv = 1; else if (chkkbCungMacMatVangKhong.Checked) { objBenhAnNgoaiTru.TgKbKbCmmv = 2; } else { objBenhAnNgoaiTru.TgKbKbCmmv = 3; } if (chkkbRunTayCo.Checked) objBenhAnNgoaiTru.TgKbKbTr = 1; else if (chkkbRunTayKhong.Checked) { objBenhAnNgoaiTru.TgKbKbTr = 2; } else { objBenhAnNgoaiTru.TgKbKbTr = 3; } objBenhAnNgoaiTru.TgKbKbNt = Utility.sDbnull(txtkbNhipTim.Text); if (chkkbNhipTimDeu.Checked) objBenhAnNgoaiTru.TgKbKbNtDeu = 1; else if (chkkbNhipTimKhong.Checked) { objBenhAnNgoaiTru.TgKbKbNtDeu = 2; } else { objBenhAnNgoaiTru.TgKbKbNtDeu = 3; } objBenhAnNgoaiTru.TgKbKbTt = Utility.sDbnull(txtkbTiengTim.Text); objBenhAnNgoaiTru.TgKbKbLa = Utility.Int16Dbnull(chkla.Checked ? 1 : 0); objBenhAnNgoaiTru.TgKbKbLb = Utility.Int16Dbnull(chklb.Checked ? 1 : 0); objBenhAnNgoaiTru.TgKbKbLl = Utility.Int16Dbnull(chkll.Checked ? 1 : 0); objBenhAnNgoaiTru.TgKbKbLll = Utility.Int16Dbnull(chklll.Checked ? 1 : 0); objBenhAnNgoaiTru.TgKbKbMdm = Utility.Int16Dbnull(chkMatDoMem.Checked ? 1 : 0); objBenhAnNgoaiTru.TgKbKbMdc = Utility.Int16Dbnull(chkMatDoChac.Checked ? 1 : 0); objBenhAnNgoaiTru.TgKbKbBlt = Utility.Int16Dbnull(chkkbBuouLanToa.Checked ? 1 : 0); objBenhAnNgoaiTru.TgKbKbBntp = Utility.Int16Dbnull(chkbhBuouNhanThuyP.Checked ? 1 : 0); objBenhAnNgoaiTru.TgKbKbBntt = Utility.Int16Dbnull(chkhbBuouNhanThuyT.Checked ? 1 : 0); objBenhAnNgoaiTru.TgKbKbBN2T = Utility.Int16Dbnull(chkhbBuouNhan2thuy.Checked ? 1 : 0); objBenhAnNgoaiTru.TgKbKbTtttp = Utility.Int16Dbnull(chkhbThuyP.Checked ? 1 : 0); objBenhAnNgoaiTru.TgKbKbTtttt = Utility.Int16Dbnull(chkThuyT.Checked ? 1 : 0); objBenhAnNgoaiTru.TgKbKbTtltp = Utility.Int16Dbnull(chkhbLTThuyP.Checked ? 1 : 0); objBenhAnNgoaiTru.TgKbKbTtltt = Utility.Int16Dbnull(chkbhLTThuyT.Checked ? 1 : 0); objBenhAnNgoaiTru.TgKbKbMp = Utility.sDbnull(txtkbMatPhai.Text); objBenhAnNgoaiTru.TgKbKbMt = Utility.sDbnull(txtkbMatTrai.Text); objBenhAnNgoaiTru.TgKbKbHh = Utility.sDbnull(txtkbHoHap.Text); objBenhAnNgoaiTru.TgKbKbB = Utility.sDbnull(txtkbBung.Text); objBenhAnNgoaiTru.TgKbKbTk = Utility.sDbnull(txtkbThanKinh.Text); objBenhAnNgoaiTru.TgKbKbMach = Utility.sDbnull(txtMach.Text); objBenhAnNgoaiTru.TgKbKbNhietdo = Utility.sDbnull(txtNhietDo.Text); objBenhAnNgoaiTru.TgKbKbHuyetap = Utility.sDbnull(txtHuyetApTu.Text); //objBenhAnNgoaiTru.KcbHuyetap2 = Utility.sDbnull(txtHuyetApDen.Text); objBenhAnNgoaiTru.TgKbKbNhiptho = Utility.sDbnull(txtNhipTho.Text); objBenhAnNgoaiTru.TgKbKbCannang = Utility.sDbnull(txtCanNang.Text); objBenhAnNgoaiTru.TgKbKbChieucao = Utility.sDbnull(txtChieuCao.Text); objBenhAnNgoaiTru.TgKbKbBmi = Utility.sDbnull(txtBMI.Text); objBenhAnNgoaiTru.TrangThai = Utility.Int16Dbnull(0); objBenhAnNgoaiTru.TgKbKbTtkqcks = Utility.sDbnull(txtkbTomTatKQCLSC.Text); objBenhAnNgoaiTru.TgKbKbCdbd = Utility.sDbnull(TXTKBChanDoanBD.Text); objBenhAnNgoaiTru.TgKbKbDxl = Utility.sDbnull(TXTKBDaXuLy.Text); objBenhAnNgoaiTru.TgKbKbCdrv = Utility.sDbnull(txtkbChanDoanRaVien.Text); objBenhAnNgoaiTru.KcbDtriTungay = Convert.ToDateTime(dtDieuTriNgoaiTruTu.Value); objBenhAnNgoaiTru.KcbDtriDenngay = Convert.ToDateTime(dtDieuTriNgoaiTruDen.Value); objBenhAnNgoaiTru.DoiTuong = Utility.sDbnull(txtDoiTuong.Text); objBenhAnNgoaiTru.SoBhyt = Utility.sDbnull(txtSoBaoHiemYte.Text); objBenhAnNgoaiTru.DiaChi = Utility.sDbnull(txtDiaChi.Text); objBenhAnNgoaiTru.NamSinh = Utility.Int16Dbnull(txtNamSinh.Text); objBenhAnNgoaiTru.InPhieuLog = Utility.Int16Dbnull(0); objBenhAnNgoaiTru.LoaiBenhAn = Utility.Int16Dbnull(2); return objBenhAnNgoaiTru; } catch (Exception ex) { Utility.ShowMsg(ex.ToString()); return objBenhAnNgoaiTru; //throw; } }
public bool Delete(object Id) { return(KcbBenhAn.Delete(Id) == 1); }
private void cmdInBenhAn_Click_1(object sender, EventArgs e) { // kiểm tra chưa khóa : in DataTable dsTable = SPs.KcbThamkhamLaythongtinBenhanNgoaitru(txtMaBN.Text).GetDataSet().Tables[0]; CrystalDecisions.CrystalReports.Engine.ReportDocument crpt; string tieude="", reportname = ""; crpt = Utility.GetReport("thamkham_BENH_AN_NGOAITRU_tuyengiap",ref tieude,ref reportname); if (crpt == null) return; frmPrintPreview objForm = new frmPrintPreview("bệnh án", crpt, true, true); crpt.SetDataSource(dsTable); objForm.crptViewer.ReportSource = crpt; objForm.ShowDialog(); KcbBenhAn objBenhAnNgoaiTru = new KcbBenhAn(); objBenhAnNgoaiTru.IsLoaded = true; objBenhAnNgoaiTru.MarkOld(); objBenhAnNgoaiTru.Id = Utility.Int32Dbnull(txtID_BA.Text, -1); // objBenhAnNgoaiTru.InPhieuLog = Utility.Int16Dbnull(1); objBenhAnNgoaiTru.NgayIn = globalVariables.SysDate; objBenhAnNgoaiTru.NguoiIn = globalVariables.UserName; objBenhAnNgoaiTru.Save(); }
public void Insert(string SoBenhAn,int IdBnhan,string MaLuotkham,string NgaySinh,string ThangSinh,string DanToc,string NoiLamviec,string ThongtinLhe,string DthoaiLhe,string CdoanGioithieu,short? YTe,short? LdoVaovienMm,short? LdoVaovienGsc,short? LdoVaovienKndn,short? LdoVaovienGtl,short? LdoVaovienKhac,string HbNam,string HbNoiCdoan,short? HbDieuTri,short? HbTiemInsulin,string HbInsulin1,string HbInsulin2,string HbThuochaDuonghuyet,string HbHa,string HbRllp,string HbThuocChongdong,short? HtaiMm,short? HtaiGaysc,string HtaiKgDau,string HtaiKgSau,short? HtaiKhatnhieu,string HtaiUong,short? HtaiDainhieu,string HtaiDai,short? HtaiGiamtl,string HtaiKhac,short? TsbBtChuaphathien,short? TsbBtNhoimaucotim,string TsbBtNamNmct,short? TsbBtTbmn,string TsbBtNamTbmn,string TsbHaNam,string TsbHaMax,short? TsbBtCON4000,string TsbBtKhac,short? TsgdDtd,short? TsgdTanghuyetap,short? TsgdNhoimaucotim,string TsgdKhac,short? KcbMatnuoc,short? KcbXuathuyet,short? KcbPhu,string KcbToanthanKhac,string KcbNhiptim,short? KcbTthaiNhiptim,string KcbTiengtim,string KcbHohap,string KcbBung,short? KcbChanphai,string KcbChanphaiKhac,short? KcbChantrai,string KcbChantraiKhac,string KcbMatphai,string KcbMattrai,string KcbRanghammat,string KcbTkinhKhac,string KcbMach,string KcbNhietdo,string KcbHuyetap1,string KcbHuyetap2,string KcbNhiptho,string KcbCannang,string KcbChieucao,string KcbBmi,string KcbTomtatClsChinh,string KcbCdoanBdau,string KcbDaXly,string KcbCdoanRavien,DateTime? KcbDtriTungay,DateTime? KcbDtriDenngay,string TkbaQtrinhBenhlyDbienCls,string TkbaPphapDtri,short? TrangThai,short? NamSinh,string DiaChi,string DoiTuong,string SoBhyt,string IcdBenhChnh,string TenBenhChinh,string IcdBenhPhu,string TenBenhPhu,string TkbaTomtatKqCls,string TkbaTtRavien,string TkbaHuongTtTieptheo,short? TgLlvvMm,short? TgLdvvGsc,short? TgLdvvRct,short? TgLdvvCt,short? TgLdvvMl,short? TgLdvvKhac,string TgLdvvKHAC1,string TgHbQtblChandoan,string TgHbQtblNam,string TgHbQtblNoiChanDoan,short? TgHbQtblDieutriDeu,string TgHbQtblThuocDIEUTRI1,string TgHbQtblThuocDIEUTRI2,string TgHbQtblThuocDIEUTRI3,string TgHbQtblThuocDIEUTRI4,string TgHbQtblThuocDIEUTRI5,short? TgHbHtMm,short? TgHbHtGsc,string TgHbHtKgdau,string TgHbHtKgcuoi,short? TgHbHtRct,short? TgHbHtVtgt,short? TgHbHtMl,short? TgHbHtNnb,short? TgHbHtRlth,string TgHbHtTcp,string TgHbHtSldn,string TgHbHtKhac,short? TgHbTsbHpq,short? TgHbTsbBldd,short? TgHbTsbKn,string TgHbTsbKhac,short? TgHbTsbBasedow,short? TgHbTsbBc,string TgHbTsbKHAC1,short? TgKbKbDna,short? TgKbKbCmmv,short? TgKbKbTr,string TgKbKbNt,short? TgKbKbNtDeu,string TgKbKbTt,short? TgKbKbLa,short? TgKbKbLb,short? TgKbKbLl,short? TgKbKbLll,short? TgKbKbMdm,short? TgKbKbMdc,short? TgKbKbBlt,short? TgKbKbBntp,short? TgKbKbBntt,short? TgKbKbBN2T,short? TgKbKbTtttp,short? TgKbKbTtttt,short? TgKbKbTtltp,short? TgKbKbTtltt,string TgKbKbMp,string TgKbKbMt,string TgKbKbB,string TgKbKbTk,string TgKbKbHh,string TgKbKbTtkqcks,string TgKbKbCdbd,string TgKbKbDxl,string TgKbKbCdrv,DateTime? TgKbKbTungay,DateTime? TgKbKbDenngay,string TgKbKbMach,string TgKbKbNhietdo,string TgKbKbHuyetap,string TgKbKbNhiptho,string TgKbKbCannang,string TgKbKbChieucao,string TgKbKbBmi,short? InPhieuLog,DateTime? NgayIn,string NguoiIn,short? LoaiBenhAn,short? BaLog,DateTime? NgaySua,string NguoiSua,string BatLdvv,string BatBhQtbl,string BatHbBt,string BatHbGd,string BatKbTt,string BatKbCbp,string BatKbKqcls,string BatKbCdbd,string BatKbDxl,string BatKbCdrv,string NguoiTao,DateTime? NgayTao,DateTime? NgayKham) { KcbBenhAn item = new KcbBenhAn(); item.SoBenhAn = SoBenhAn; item.IdBnhan = IdBnhan; item.MaLuotkham = MaLuotkham; item.NgaySinh = NgaySinh; item.ThangSinh = ThangSinh; item.DanToc = DanToc; item.NoiLamviec = NoiLamviec; item.ThongtinLhe = ThongtinLhe; item.DthoaiLhe = DthoaiLhe; item.CdoanGioithieu = CdoanGioithieu; item.YTe = YTe; item.LdoVaovienMm = LdoVaovienMm; item.LdoVaovienGsc = LdoVaovienGsc; item.LdoVaovienKndn = LdoVaovienKndn; item.LdoVaovienGtl = LdoVaovienGtl; item.LdoVaovienKhac = LdoVaovienKhac; item.HbNam = HbNam; item.HbNoiCdoan = HbNoiCdoan; item.HbDieuTri = HbDieuTri; item.HbTiemInsulin = HbTiemInsulin; item.HbInsulin1 = HbInsulin1; item.HbInsulin2 = HbInsulin2; item.HbThuochaDuonghuyet = HbThuochaDuonghuyet; item.HbHa = HbHa; item.HbRllp = HbRllp; item.HbThuocChongdong = HbThuocChongdong; item.HtaiMm = HtaiMm; item.HtaiGaysc = HtaiGaysc; item.HtaiKgDau = HtaiKgDau; item.HtaiKgSau = HtaiKgSau; item.HtaiKhatnhieu = HtaiKhatnhieu; item.HtaiUong = HtaiUong; item.HtaiDainhieu = HtaiDainhieu; item.HtaiDai = HtaiDai; item.HtaiGiamtl = HtaiGiamtl; item.HtaiKhac = HtaiKhac; item.TsbBtChuaphathien = TsbBtChuaphathien; item.TsbBtNhoimaucotim = TsbBtNhoimaucotim; item.TsbBtNamNmct = TsbBtNamNmct; item.TsbBtTbmn = TsbBtTbmn; item.TsbBtNamTbmn = TsbBtNamTbmn; item.TsbHaNam = TsbHaNam; item.TsbHaMax = TsbHaMax; item.TsbBtCON4000 = TsbBtCON4000; item.TsbBtKhac = TsbBtKhac; item.TsgdDtd = TsgdDtd; item.TsgdTanghuyetap = TsgdTanghuyetap; item.TsgdNhoimaucotim = TsgdNhoimaucotim; item.TsgdKhac = TsgdKhac; item.KcbMatnuoc = KcbMatnuoc; item.KcbXuathuyet = KcbXuathuyet; item.KcbPhu = KcbPhu; item.KcbToanthanKhac = KcbToanthanKhac; item.KcbNhiptim = KcbNhiptim; item.KcbTthaiNhiptim = KcbTthaiNhiptim; item.KcbTiengtim = KcbTiengtim; item.KcbHohap = KcbHohap; item.KcbBung = KcbBung; item.KcbChanphai = KcbChanphai; item.KcbChanphaiKhac = KcbChanphaiKhac; item.KcbChantrai = KcbChantrai; item.KcbChantraiKhac = KcbChantraiKhac; item.KcbMatphai = KcbMatphai; item.KcbMattrai = KcbMattrai; item.KcbRanghammat = KcbRanghammat; item.KcbTkinhKhac = KcbTkinhKhac; item.KcbMach = KcbMach; item.KcbNhietdo = KcbNhietdo; item.KcbHuyetap1 = KcbHuyetap1; item.KcbHuyetap2 = KcbHuyetap2; item.KcbNhiptho = KcbNhiptho; item.KcbCannang = KcbCannang; item.KcbChieucao = KcbChieucao; item.KcbBmi = KcbBmi; item.KcbTomtatClsChinh = KcbTomtatClsChinh; item.KcbCdoanBdau = KcbCdoanBdau; item.KcbDaXly = KcbDaXly; item.KcbCdoanRavien = KcbCdoanRavien; item.KcbDtriTungay = KcbDtriTungay; item.KcbDtriDenngay = KcbDtriDenngay; item.TkbaQtrinhBenhlyDbienCls = TkbaQtrinhBenhlyDbienCls; item.TkbaPphapDtri = TkbaPphapDtri; item.TrangThai = TrangThai; item.NamSinh = NamSinh; item.DiaChi = DiaChi; item.DoiTuong = DoiTuong; item.SoBhyt = SoBhyt; item.IcdBenhChnh = IcdBenhChnh; item.TenBenhChinh = TenBenhChinh; item.IcdBenhPhu = IcdBenhPhu; item.TenBenhPhu = TenBenhPhu; item.TkbaTomtatKqCls = TkbaTomtatKqCls; item.TkbaTtRavien = TkbaTtRavien; item.TkbaHuongTtTieptheo = TkbaHuongTtTieptheo; item.TgLlvvMm = TgLlvvMm; item.TgLdvvGsc = TgLdvvGsc; item.TgLdvvRct = TgLdvvRct; item.TgLdvvCt = TgLdvvCt; item.TgLdvvMl = TgLdvvMl; item.TgLdvvKhac = TgLdvvKhac; item.TgLdvvKHAC1 = TgLdvvKHAC1; item.TgHbQtblChandoan = TgHbQtblChandoan; item.TgHbQtblNam = TgHbQtblNam; item.TgHbQtblNoiChanDoan = TgHbQtblNoiChanDoan; item.TgHbQtblDieutriDeu = TgHbQtblDieutriDeu; item.TgHbQtblThuocDIEUTRI1 = TgHbQtblThuocDIEUTRI1; item.TgHbQtblThuocDIEUTRI2 = TgHbQtblThuocDIEUTRI2; item.TgHbQtblThuocDIEUTRI3 = TgHbQtblThuocDIEUTRI3; item.TgHbQtblThuocDIEUTRI4 = TgHbQtblThuocDIEUTRI4; item.TgHbQtblThuocDIEUTRI5 = TgHbQtblThuocDIEUTRI5; item.TgHbHtMm = TgHbHtMm; item.TgHbHtGsc = TgHbHtGsc; item.TgHbHtKgdau = TgHbHtKgdau; item.TgHbHtKgcuoi = TgHbHtKgcuoi; item.TgHbHtRct = TgHbHtRct; item.TgHbHtVtgt = TgHbHtVtgt; item.TgHbHtMl = TgHbHtMl; item.TgHbHtNnb = TgHbHtNnb; item.TgHbHtRlth = TgHbHtRlth; item.TgHbHtTcp = TgHbHtTcp; item.TgHbHtSldn = TgHbHtSldn; item.TgHbHtKhac = TgHbHtKhac; item.TgHbTsbHpq = TgHbTsbHpq; item.TgHbTsbBldd = TgHbTsbBldd; item.TgHbTsbKn = TgHbTsbKn; item.TgHbTsbKhac = TgHbTsbKhac; item.TgHbTsbBasedow = TgHbTsbBasedow; item.TgHbTsbBc = TgHbTsbBc; item.TgHbTsbKHAC1 = TgHbTsbKHAC1; item.TgKbKbDna = TgKbKbDna; item.TgKbKbCmmv = TgKbKbCmmv; item.TgKbKbTr = TgKbKbTr; item.TgKbKbNt = TgKbKbNt; item.TgKbKbNtDeu = TgKbKbNtDeu; item.TgKbKbTt = TgKbKbTt; item.TgKbKbLa = TgKbKbLa; item.TgKbKbLb = TgKbKbLb; item.TgKbKbLl = TgKbKbLl; item.TgKbKbLll = TgKbKbLll; item.TgKbKbMdm = TgKbKbMdm; item.TgKbKbMdc = TgKbKbMdc; item.TgKbKbBlt = TgKbKbBlt; item.TgKbKbBntp = TgKbKbBntp; item.TgKbKbBntt = TgKbKbBntt; item.TgKbKbBN2T = TgKbKbBN2T; item.TgKbKbTtttp = TgKbKbTtttp; item.TgKbKbTtttt = TgKbKbTtttt; item.TgKbKbTtltp = TgKbKbTtltp; item.TgKbKbTtltt = TgKbKbTtltt; item.TgKbKbMp = TgKbKbMp; item.TgKbKbMt = TgKbKbMt; item.TgKbKbB = TgKbKbB; item.TgKbKbTk = TgKbKbTk; item.TgKbKbHh = TgKbKbHh; item.TgKbKbTtkqcks = TgKbKbTtkqcks; item.TgKbKbCdbd = TgKbKbCdbd; item.TgKbKbDxl = TgKbKbDxl; item.TgKbKbCdrv = TgKbKbCdrv; item.TgKbKbTungay = TgKbKbTungay; item.TgKbKbDenngay = TgKbKbDenngay; item.TgKbKbMach = TgKbKbMach; item.TgKbKbNhietdo = TgKbKbNhietdo; item.TgKbKbHuyetap = TgKbKbHuyetap; item.TgKbKbNhiptho = TgKbKbNhiptho; item.TgKbKbCannang = TgKbKbCannang; item.TgKbKbChieucao = TgKbKbChieucao; item.TgKbKbBmi = TgKbKbBmi; item.InPhieuLog = InPhieuLog; item.NgayIn = NgayIn; item.NguoiIn = NguoiIn; item.LoaiBenhAn = LoaiBenhAn; item.BaLog = BaLog; item.NgaySua = NgaySua; item.NguoiSua = NguoiSua; item.BatLdvv = BatLdvv; item.BatBhQtbl = BatBhQtbl; item.BatHbBt = BatHbBt; item.BatHbGd = BatHbGd; item.BatKbTt = BatKbTt; item.BatKbCbp = BatKbCbp; item.BatKbKqcls = BatKbKqcls; item.BatKbCdbd = BatKbCdbd; item.BatKbDxl = BatKbDxl; item.BatKbCdrv = BatKbCdrv; item.NguoiTao = NguoiTao; item.NgayTao = NgayTao; item.NgayKham = NgayKham; item.Save(UserName); }
private KcbBenhAn CreateBenhAnNgoaiTru() { KcbBenhAn objBenhAnNgoaiTru = new KcbBenhAn(); try { if (em_Action == action.Update) { objBenhAnNgoaiTru.IsLoaded = true; objBenhAnNgoaiTru.MarkOld(); objBenhAnNgoaiTru.Id = Utility.Int32Dbnull(txtID_BA.Text, -1); objBenhAnNgoaiTru.NgaySua = globalVariables.SysDate; objBenhAnNgoaiTru.NguoiSua = globalVariables.UserName; } if (em_Action == action.Insert) { objBenhAnNgoaiTru.NguoiTao = globalVariables.UserName; objBenhAnNgoaiTru.NgayTao = globalVariables.SysDate; } objBenhAnNgoaiTru.SoBenhAn = Utility.sDbnull(txtMaBenhAn.Text, -1); objBenhAnNgoaiTru.IdBnhan = Utility.Int32Dbnull(txtMaBN.Text); objBenhAnNgoaiTru.NgaySinh = Utility.sDbnull(txtNgaySinh.Text); objBenhAnNgoaiTru.ThangSinh = Utility.sDbnull(txtThangSinh.Text); objBenhAnNgoaiTru.DanToc = Utility.sDbnull(txtDanToc.Text); objBenhAnNgoaiTru.NoiLamviec = Utility.sDbnull(txtNoiLamViec.Text); objBenhAnNgoaiTru.ThongtinLhe = Utility.sDbnull(txtThongTinLienHe.Text); objBenhAnNgoaiTru.DthoaiLhe = Utility.sDbnull(txtDienThoai.Text); objBenhAnNgoaiTru.CdoanGioithieu = Utility.sDbnull(txtChanDoanBanDau.Text); objBenhAnNgoaiTru.NgayKham = Convert.ToDateTime(dtThoiDiemDkKham.Value); if (chkYTe.Checked) objBenhAnNgoaiTru.YTe = 1; else if (chkTuDen.Checked) { objBenhAnNgoaiTru.YTe = 2; } else { objBenhAnNgoaiTru.YTe = 3; } objBenhAnNgoaiTru.BatLdvv = Utility.sDbnull(txtBAT_LDVV.Text); objBenhAnNgoaiTru.BatBhQtbl = Utility.sDbnull(txtBAT_QTBL.Text); objBenhAnNgoaiTru.BatHbBt = Utility.sDbnull(txtBAT_BT.Text); objBenhAnNgoaiTru.BatHbGd = Utility.sDbnull(txtBAT_GD.Text); objBenhAnNgoaiTru.BatKbTt = Utility.sDbnull(txtBAT_TT.Text); objBenhAnNgoaiTru.BatKbCbp = Utility.sDbnull(txtBAT_CBP.Text); objBenhAnNgoaiTru.BatKbKqcls = Utility.sDbnull(txtBAT_TTLQCLSC.Text); objBenhAnNgoaiTru.BatKbCdbd = Utility.sDbnull(TXTKBChanDoanBD.Text); objBenhAnNgoaiTru.BatKbDxl = Utility.sDbnull(TXTKBDaXuLy.Text); objBenhAnNgoaiTru.BatKbCdrv = Utility.sDbnull(txtkbChanDoanRaVien.Text); objBenhAnNgoaiTru.KcbMach = Utility.sDbnull(txtMach.Text); objBenhAnNgoaiTru.KcbNhietdo = Utility.sDbnull(txtNhietDo.Text); objBenhAnNgoaiTru.KcbHuyetap1 = Utility.sDbnull(txtHuyetApTu.Text); objBenhAnNgoaiTru.KcbHuyetap2 = Utility.sDbnull(txtHuyetApDen.Text); objBenhAnNgoaiTru.KcbNhiptho = Utility.sDbnull(txtNhipTho.Text); objBenhAnNgoaiTru.KcbCannang = Utility.sDbnull(txtCanNang.Text); objBenhAnNgoaiTru.KcbChieucao = Utility.sDbnull(txtChieuCao.Text); objBenhAnNgoaiTru.KcbBmi = Utility.sDbnull(txtBMI.Text); objBenhAnNgoaiTru.TrangThai = 0; objBenhAnNgoaiTru.KcbDtriTungay = Convert.ToDateTime(dtDieuTriNgoaiTruTu.Value); objBenhAnNgoaiTru.KcbDtriDenngay = Convert.ToDateTime(dtDieuTriNgoaiTruDen.Value); objBenhAnNgoaiTru.DoiTuong = Utility.sDbnull(txtDoiTuong.Text); objBenhAnNgoaiTru.SoBhyt = Utility.sDbnull(txtSoBaoHiemYte.Text); objBenhAnNgoaiTru.DiaChi = Utility.sDbnull(txtDiaChi.Text); objBenhAnNgoaiTru.NamSinh = Utility.Int16Dbnull(txtNamSinh.Text); objBenhAnNgoaiTru.InPhieuLog = Utility.Int16Dbnull(0); objBenhAnNgoaiTru.LoaiBenhAn = Utility.Int16Dbnull(3); return objBenhAnNgoaiTru; } catch (Exception ex) { Utility.ShowMsg(ex.ToString()); return objBenhAnNgoaiTru; } }
private KcbBenhAn CreateBenhAnNgoaiTru() { KcbBenhAn objBenhAnNgoaiTru = new KcbBenhAn(); try { if (em_Action == action.Update) { objBenhAnNgoaiTru.IsLoaded = true; objBenhAnNgoaiTru.MarkOld(); objBenhAnNgoaiTru.Id = Utility.Int32Dbnull(txtID_BA.Text, -1); objBenhAnNgoaiTru.NgaySua = globalVariables.SysDate; objBenhAnNgoaiTru.NguoiSua = globalVariables.UserName; } if (em_Action == action.Insert) { objBenhAnNgoaiTru.NguoiTao = globalVariables.UserName; objBenhAnNgoaiTru.NgayTao = globalVariables.SysDate; } objBenhAnNgoaiTru.SoBenhAn = Utility.sDbnull(txtMaBenhAn.Text, -1); objBenhAnNgoaiTru.IdBnhan = Utility.Int32Dbnull(txtMaBN.Text); objBenhAnNgoaiTru.NgaySinh = Utility.sDbnull(txtNgaySinh.Text); objBenhAnNgoaiTru.ThangSinh = Utility.sDbnull(txtThangSinh.Text); objBenhAnNgoaiTru.DanToc = Utility.sDbnull(txtDanToc.Text); objBenhAnNgoaiTru.NoiLamviec = Utility.sDbnull(txtNoiLamViec.Text); objBenhAnNgoaiTru.ThongtinLhe = Utility.sDbnull(txtThongTinLienHe.Text); objBenhAnNgoaiTru.DthoaiLhe = Utility.sDbnull(txtDienThoai.Text); objBenhAnNgoaiTru.CdoanGioithieu = Utility.sDbnull(txtChanDoanBanDau.Text); objBenhAnNgoaiTru.NgayKham = Convert.ToDateTime(dtThoiDiemDkKham.Value); if (chkYTe.Checked) objBenhAnNgoaiTru.YTe = 1; else if (chkTuDen.Checked) { objBenhAnNgoaiTru.YTe = 2; } else { objBenhAnNgoaiTru.YTe = 3; } objBenhAnNgoaiTru.LdoVaovienMm = Utility.Int16Dbnull(chkldvvMetMoi.Checked ? 1 : 0); objBenhAnNgoaiTru.LdoVaovienGsc = Utility.Int16Dbnull(chkldvvGay.Checked ? 1 : 0); objBenhAnNgoaiTru.LdoVaovienKndn = Utility.Int16Dbnull(chkldvvKhat.Checked ? 1 : 0); objBenhAnNgoaiTru.LdoVaovienGtl = Utility.Int16Dbnull(chkldvvGiamThiLuc.Checked ? 1 : 0); objBenhAnNgoaiTru.LdoVaovienKhac = Utility.Int16Dbnull(chkldvvKhac.Checked ? 1 : 0); objBenhAnNgoaiTru.HbNam = Utility.sDbnull(txtNamChanDoanDTD.Text); objBenhAnNgoaiTru.HbNoiCdoan = Utility.sDbnull(txtNoiChanDoanDTD.Text); if (chkhbDeu.Checked) objBenhAnNgoaiTru.HbDieuTri = 1; else if (chkhbKhongDeu.Checked) { objBenhAnNgoaiTru.HbDieuTri = 2; } else { objBenhAnNgoaiTru.HbDieuTri = 3; } objBenhAnNgoaiTru.HbTiemInsulin = Utility.Int16Dbnull(chkhbTiemInsulin.Checked ? 1 : 0); objBenhAnNgoaiTru.HbInsulin1 = Utility.sDbnull(txtLuongInsulin.Text); objBenhAnNgoaiTru.HbInsulin2 = Utility.sDbnull(txthbCachDungInsulin.Text); objBenhAnNgoaiTru.HbThuochaDuonghuyet = Utility.sDbnull(txthbThuocHaDuongHuyet.Text); objBenhAnNgoaiTru.HbHa = Utility.sDbnull(txthbThuocHaHA.Text); objBenhAnNgoaiTru.HbRllp = Utility.sDbnull(txthbThuocRLLP.Text); objBenhAnNgoaiTru.HbThuocChongdong = Utility.sDbnull(txthbThuocChongDong.Text); objBenhAnNgoaiTru.HtaiMm = Utility.Int16Dbnull(chkhbMetMoi.Checked ? 1 : 0); objBenhAnNgoaiTru.HtaiGaysc = Utility.Int16Dbnull(chkhbGaySutCan.Checked ? 1 : 0); objBenhAnNgoaiTru.HtaiKgDau = Utility.sDbnull(txthbKgDau.Text); objBenhAnNgoaiTru.HtaiKgSau = Utility.sDbnull(txthbKgSau.Text); objBenhAnNgoaiTru.HtaiKhatnhieu = Utility.Int16Dbnull(chkhbKhat.Checked ? 1 : 0); objBenhAnNgoaiTru.HtaiUong = Utility.sDbnull(txthbSoLanUongNuoc.Text); objBenhAnNgoaiTru.HtaiDainhieu = Utility.Int16Dbnull(chkhbDai.Checked ? 1 : 0); objBenhAnNgoaiTru.HtaiDai = Utility.sDbnull(txthbSoLanDai.Text); objBenhAnNgoaiTru.HtaiGiamtl = Utility.Int16Dbnull(chkhbGiamThiLuc.Checked ? 1 : 0); objBenhAnNgoaiTru.HtaiKhac = Utility.sDbnull(chkhbKhac.Checked ? 1 : 0); objBenhAnNgoaiTru.TsbBtChuaphathien = Utility.Int16Dbnull(chktsbChuaPhatHienBenh.Checked ? 1 : 0); objBenhAnNgoaiTru.TsbBtNhoimaucotim = Utility.Int16Dbnull(chktsbNhoiMauCoTim.Checked ? 1 : 0); objBenhAnNgoaiTru.TsbBtNamNmct = Utility.sDbnull(txttsbNamNhoiMauCoTim.Text); objBenhAnNgoaiTru.TsbBtTbmn = Utility.Int16Dbnull(chktsbTBMN.Checked ? 1 : 0); objBenhAnNgoaiTru.TsbBtNamTbmn = Utility.sDbnull(txttsbNamTBMN.Text); objBenhAnNgoaiTru.TsbHaNam = Utility.sDbnull(txttsbTangHuyetAp.Text); objBenhAnNgoaiTru.TsbHaMax = Utility.sDbnull(txttsbHAmax.Text); objBenhAnNgoaiTru.TsbBtCON4000 = Utility.Int16Dbnull(chktsbDeConLonHon4000.Checked ? 1 : 0); objBenhAnNgoaiTru.TsbBtKhac = Utility.sDbnull(txttsbKhac.Text); objBenhAnNgoaiTru.TsgdDtd = Utility.Int16Dbnull(chktsbDTD.Checked ? 1 : 0); objBenhAnNgoaiTru.TsgdTanghuyetap = Utility.Int16Dbnull(chktsbTangHuyetAp.Checked ? 1 : 0); objBenhAnNgoaiTru.TsbBtNhoimaucotim = Utility.Int16Dbnull(chktsgdNhoiMauCoTim.Checked ? 1 : 0); objBenhAnNgoaiTru.TsgdKhac = Utility.sDbnull(txttsgdKhac.Text); if (chkkbMatNuocCo.Checked) objBenhAnNgoaiTru.KcbMatnuoc = 1; else if (chkkbMatNuocKhong.Checked) { objBenhAnNgoaiTru.KcbMatnuoc = 2; } else { objBenhAnNgoaiTru.KcbMatnuoc = 3; } if (chkkbXuatHuetDuoiDaCo.Checked) objBenhAnNgoaiTru.KcbXuathuyet = 1; else if (chkkbXuatHuyetDuoiDaKhong.Checked) { objBenhAnNgoaiTru.KcbXuathuyet = 2; } else { objBenhAnNgoaiTru.KcbXuathuyet = 3; } if (chkkbPhuCo.Checked) objBenhAnNgoaiTru.KcbPhu = 1; else if (chkkbPhuKhong.Checked) { objBenhAnNgoaiTru.KcbPhu = 2; } else { objBenhAnNgoaiTru.KcbPhu = 3; } objBenhAnNgoaiTru.KcbToanthanKhac = Utility.sDbnull(txtkbKhac.Text); objBenhAnNgoaiTru.KcbNhiptim = Utility.sDbnull(txtkbNhipTim.Text); if (chkkbNhipTimDeu.Checked) objBenhAnNgoaiTru.KcbTthaiNhiptim = 1; else if (chkkbNhipTimKhong.Checked) { objBenhAnNgoaiTru.KcbTthaiNhiptim = 2; } else { objBenhAnNgoaiTru.KcbTthaiNhiptim = 3; } objBenhAnNgoaiTru.KcbTiengtim = Utility.sDbnull(txtkbTiengTim.Text); objBenhAnNgoaiTru.KcbHohap = Utility.sDbnull(txtkbHoHap.Text); objBenhAnNgoaiTru.KcbBung = Utility.sDbnull(txtkbBung.Text); if (chkkbChanPhaiPXGXGiam.Checked) objBenhAnNgoaiTru.KcbChanphai = 1; else if (chkkbChanPhaiBinhThuong.Checked) { objBenhAnNgoaiTru.KcbChanphai = 2; } else if (chkkbChanPhaiTang.Checked) { objBenhAnNgoaiTru.KcbChanphai = 3; } else { objBenhAnNgoaiTru.KcbChanphai = 0; } objBenhAnNgoaiTru.KcbChanphaiKhac = Utility.sDbnull(txtkbChanPhaiKhac.Text); if (chkkbChanTraiPXGXGiam.Checked) objBenhAnNgoaiTru.KcbChantrai = 1; else if (chkkbChanTraiBinhThuong.Checked) { objBenhAnNgoaiTru.KcbChantrai = 2; } else if (chkkbChanTraiTang.Checked) { objBenhAnNgoaiTru.KcbChantrai = 3; } else { objBenhAnNgoaiTru.KcbChantrai = 0; } objBenhAnNgoaiTru.KcbChantraiKhac = Utility.sDbnull(txtkbChanTraiKhac.Text); objBenhAnNgoaiTru.KcbMatphai = Utility.sDbnull(txtkbMatPhai.Text); objBenhAnNgoaiTru.KcbMattrai = Utility.sDbnull(txtkbMatTrai.Text); objBenhAnNgoaiTru.KcbRanghammat = Utility.sDbnull(txtkbRangHamMat.Text); objBenhAnNgoaiTru.KcbTkinhKhac = Utility.sDbnull(txtkbKhac1.Text); objBenhAnNgoaiTru.KcbMach = Utility.sDbnull(txtMach.Text); objBenhAnNgoaiTru.KcbNhietdo = Utility.sDbnull(txtNhietDo.Text); objBenhAnNgoaiTru.KcbHuyetap1 = Utility.sDbnull(txtHuyetApTu.Text); objBenhAnNgoaiTru.KcbHuyetap2 = Utility.sDbnull(txtHuyetApDen.Text); objBenhAnNgoaiTru.KcbNhiptho = Utility.sDbnull(txtNhipTho.Text); objBenhAnNgoaiTru.KcbCannang = Utility.sDbnull(txtCanNang.Text); objBenhAnNgoaiTru.KcbChieucao = Utility.sDbnull(txtChieuCao.Text); objBenhAnNgoaiTru.KcbBmi = Utility.sDbnull(txtBMI.Text); objBenhAnNgoaiTru.TrangThai = 0; objBenhAnNgoaiTru.KcbTomtatClsChinh = Utility.sDbnull(txtkbTomTatKQCLSC.Text); objBenhAnNgoaiTru.KcbCdoanBdau = Utility.sDbnull(TXTKBChanDoanBD.Text); objBenhAnNgoaiTru.KcbDaXly = Utility.sDbnull(TXTKBDaXuLy.Text); objBenhAnNgoaiTru.KcbCdoanRavien = Utility.sDbnull(txtkbChanDoanRaVien.Text); objBenhAnNgoaiTru.KcbDtriTungay = Convert.ToDateTime(dtDieuTriNgoaiTruTu.Value); objBenhAnNgoaiTru.KcbDtriDenngay = Convert.ToDateTime(dtDieuTriNgoaiTruDen.Value); objBenhAnNgoaiTru.TkbaQtrinhBenhlyDbienCls = Utility.sDbnull(txtQuaTrinhBenhLy.Text); objBenhAnNgoaiTru.TkbaPphapDtri = Utility.sDbnull(txtTomTatCLS.Text); objBenhAnNgoaiTru.TenBenhChinh = Utility.sDbnull(txtBenhChinh.Text); objBenhAnNgoaiTru.TenBenhPhu = Utility.sDbnull(txtBenhPhu.Text); objBenhAnNgoaiTru.TkbaPphapDtri = Utility.sDbnull(txtPPDT.Text); objBenhAnNgoaiTru.TkbaTtRavien = Utility.sDbnull(txtTrangThaiRaVien.Text); objBenhAnNgoaiTru.TkbaHuongTtTieptheo = Utility.sDbnull(txtHuongTiepTheo.Text); objBenhAnNgoaiTru.DoiTuong = Utility.sDbnull(txtDoiTuong.Text); objBenhAnNgoaiTru.SoBhyt = Utility.sDbnull(txtSoBaoHiemYte.Text); objBenhAnNgoaiTru.DiaChi = Utility.sDbnull(txtDiaChi.Text); objBenhAnNgoaiTru.NamSinh = Utility.Int16Dbnull(txtNamSinh.Text); objBenhAnNgoaiTru.InPhieuLog = Utility.Int16Dbnull(0); objBenhAnNgoaiTru.LoaiBenhAn = Utility.Int16Dbnull(1); return objBenhAnNgoaiTru; } catch (Exception ex) { Utility.ShowMsg(ex.ToString()); return objBenhAnNgoaiTru; //throw; } }
// LAY DU LIEU BENH AN private void LayDulieubenh_an(KcbBenhAn objBenhAnNgoaiTru) { try { if(objBenhAnNgoaiTru==null) objBenhAnNgoaiTru = new Select().From(KcbBenhAn.Schema).Where(KcbBenhAn.Columns.IdBnhan).IsEqualTo( Utility.Int32Dbnull(uc_bant_11.txtMaBN.Text.Trim())).ExecuteSingle<KcbBenhAn>(); if (objBenhAnNgoaiTru != null) { m_enAct = action.Update; uc_bant_11.txtID_BA.Text = Utility.sDbnull(objBenhAnNgoaiTru.Id, ""); uc_bant_11.txtMaBenhAn.Text = Utility.sDbnull(objBenhAnNgoaiTru.SoBenhAn, -1); uc_bant_11.txtMaBN.Text = Utility.sDbnull(objBenhAnNgoaiTru.IdBnhan, ""); uc_bant_11.txtNgaySinh.Text = Utility.sDbnull(objBenhAnNgoaiTru.NgaySinh, ""); uc_bant_11.txtThangSinh.Text = Utility.sDbnull(objBenhAnNgoaiTru.ThangSinh, ""); uc_bant_11.txtDanToc.Text = Utility.sDbnull(objBenhAnNgoaiTru.DanToc, ""); uc_bant_11.txtNoiLamViec.Text = Utility.sDbnull(objBenhAnNgoaiTru.NoiLamviec, ""); uc_bant_11.txtThongTinLienHe.Text = Utility.sDbnull(objBenhAnNgoaiTru.ThongtinLhe, ""); uc_bant_11.txtDienThoai.Text = Utility.sDbnull(objBenhAnNgoaiTru.DthoaiLhe, ""); uc_bant_11.txtChanDoanBanDau.Text = Utility.sDbnull(objBenhAnNgoaiTru.CdoanGioithieu, ""); uc_bant_11.chkYTe.Checked = Utility.Int16Dbnull(objBenhAnNgoaiTru.YTe) == 1; uc_bant_11.chkTuDen.Checked = Utility.Int16Dbnull(objBenhAnNgoaiTru.YTe) == 2; uc_bant_11.dtThoiDiemDkKham.Value = Convert.ToDateTime(objBenhAnNgoaiTru.NgayKham); uc_bant_21.chkldvvMetMoi.Checked = Utility.Int16Dbnull(objBenhAnNgoaiTru.LdoVaovienMm) == 1; uc_bant_21.chkldvvGay.Checked = Utility.Int16Dbnull(objBenhAnNgoaiTru.LdoVaovienGsc) == 1; uc_bant_21.chkldvvKhat.Checked = Utility.Int16Dbnull(objBenhAnNgoaiTru.LdoVaovienKndn) == 1; uc_bant_21.chkldvvGiamThiLuc.Checked = Utility.Int16Dbnull(objBenhAnNgoaiTru.LdoVaovienGtl) == 1; uc_bant_21.chkldvvKhac.Checked = Utility.Int16Dbnull(objBenhAnNgoaiTru.LdoVaovienKhac) == 1; uc_bant_31.txtNamChanDoanDTD.Text = Utility.sDbnull(objBenhAnNgoaiTru.HbNam, ""); uc_bant_31.txtNoiChanDoanDTD.Text = Utility.sDbnull(objBenhAnNgoaiTru.HbNoiCdoan, ""); uc_bant_31.chkhbDeu.Checked = Utility.Int16Dbnull(objBenhAnNgoaiTru.HbDieuTri) == 1; uc_bant_31.chkhbKhongDeu.Checked = Utility.Int16Dbnull(objBenhAnNgoaiTru.HbDieuTri) == 2; uc_bant_31.chkhbTiemInsulin.Checked = Utility.Int16Dbnull(objBenhAnNgoaiTru.HbTiemInsulin) == 1; uc_bant_31.txtLuongInsulin.Text = Utility.sDbnull(objBenhAnNgoaiTru.HbInsulin1, ""); uc_bant_31.txthbCachDungInsulin.Text = Utility.sDbnull(objBenhAnNgoaiTru.HbInsulin2, ""); uc_bant_31.txthbThuocHaDuongHuyet.Text = Utility.sDbnull(objBenhAnNgoaiTru.HbThuochaDuonghuyet, ""); uc_bant_31.txthbThuocHaHA.Text = Utility.sDbnull(objBenhAnNgoaiTru.HbHa, ""); uc_bant_31.txthbThuocRLLP.Text = Utility.sDbnull(objBenhAnNgoaiTru.HbRllp, ""); uc_bant_31.txthbThuocChongDong.Text = Utility.sDbnull(objBenhAnNgoaiTru.HbThuocChongdong, ""); uc_bant_31.chkhbMetMoi.Checked = Utility.Int16Dbnull(objBenhAnNgoaiTru.HtaiMm) == 1; uc_bant_31.chkhbGaySutCan.Checked = Utility.Int16Dbnull(objBenhAnNgoaiTru.HtaiGaysc) == 1; uc_bant_31.txthbKgDau.Text = Utility.sDbnull(objBenhAnNgoaiTru.HtaiKgDau, ""); uc_bant_31.txthbKgSau.Text = Utility.sDbnull(objBenhAnNgoaiTru.HtaiKgSau, ""); uc_bant_31.chkhbKhat.Checked = Utility.Int16Dbnull(objBenhAnNgoaiTru.HtaiKhatnhieu) == 1; uc_bant_31.txthbSoLanUongNuoc.Text = Utility.sDbnull(objBenhAnNgoaiTru.HtaiUong, ""); uc_bant_31.chkhbDai.Checked = Utility.Int16Dbnull(objBenhAnNgoaiTru.HtaiDainhieu) == 1; uc_bant_31.txthbSoLanDai.Text = Utility.sDbnull(objBenhAnNgoaiTru.HtaiDai, ""); uc_bant_31.chkhbGiamThiLuc.Checked = Utility.Int16Dbnull(objBenhAnNgoaiTru.HtaiGiamtl) == 1; uc_bant_31.chkhbKhac.Checked = Utility.Int16Dbnull(objBenhAnNgoaiTru.HtaiKhac) == 1; uc_bant_31.chktsbChuaPhatHienBenh.Checked = Utility.Int16Dbnull(objBenhAnNgoaiTru.TsbBtChuaphathien) == 1; uc_bant_31.chktsbNhoiMauCoTim.Checked = Utility.Int16Dbnull(objBenhAnNgoaiTru.TsbBtNhoimaucotim) == 1; uc_bant_31.txttsbNamNhoiMauCoTim.Text = Utility.sDbnull(objBenhAnNgoaiTru.TsbBtNamNmct, ""); uc_bant_31.chktsbTBMN.Checked = Utility.Int16Dbnull(objBenhAnNgoaiTru.TsbBtTbmn) == 1; uc_bant_31.txttsbNamTBMN.Text = Utility.sDbnull(objBenhAnNgoaiTru.TsbBtNamTbmn, ""); uc_bant_31.txttsbTangHuyetAp.Text = Utility.sDbnull(objBenhAnNgoaiTru.TsbHaNam, ""); uc_bant_31.txttsbHAmax.Text = Utility.sDbnull(objBenhAnNgoaiTru.TsbHaMax, ""); uc_bant_31.chktsbDeConLonHon4000.Checked = Utility.Int16Dbnull(objBenhAnNgoaiTru.TsbBtCON4000) == 1; uc_bant_31.txttsbKhac.Text = Utility.sDbnull(objBenhAnNgoaiTru.TsbBtKhac, ""); uc_bant_31.chktsbDTD.Checked = Utility.Int16Dbnull(objBenhAnNgoaiTru.TsgdDtd) == 1; uc_bant_31.chktsbTangHuyetAp.Checked = Utility.Int16Dbnull(objBenhAnNgoaiTru.TsgdTanghuyetap) == 1; uc_bant_31.chktsgdNhoiMauCoTim.Checked = Utility.Int16Dbnull(objBenhAnNgoaiTru.TsgdNhoimaucotim) == 1; uc_bant_31.txttsgdKhac.Text = Utility.sDbnull(objBenhAnNgoaiTru.TsgdKhac, ""); uc_bant_41.chkkbMatNuocCo.Checked = Utility.Int16Dbnull(objBenhAnNgoaiTru.KcbMatnuoc) == 1; uc_bant_41.chkkbMatNuocKhong.Checked = Utility.Int16Dbnull(objBenhAnNgoaiTru.KcbMatnuoc) == 2; uc_bant_41.chkkbXuatHuetDuoiDaCo.Checked = Utility.Int16Dbnull(objBenhAnNgoaiTru.KcbXuathuyet) == 1; uc_bant_41.chkkbXuatHuyetDuoiDaKhong.Checked = Utility.Int16Dbnull(objBenhAnNgoaiTru.KcbXuathuyet) == 2; uc_bant_41.chkkbPhuCo.Checked = Utility.Int16Dbnull(objBenhAnNgoaiTru.KcbPhu) == 1; uc_bant_41.chkkbPhuKhong.Checked = Utility.Int16Dbnull(objBenhAnNgoaiTru.KcbPhu) == 2; uc_bant_41.txtkbKhac.Text = Utility.sDbnull(objBenhAnNgoaiTru.KcbToanthanKhac); uc_bant_41.txtkbNhipTim.Text = Utility.sDbnull(objBenhAnNgoaiTru.KcbNhiptim); uc_bant_41.chkkbNhipTimDeu.Checked = Utility.Int16Dbnull(objBenhAnNgoaiTru.KcbTthaiNhiptim) == 1; uc_bant_41.chkkbNhipTimKhong.Checked = Utility.Int16Dbnull(objBenhAnNgoaiTru.KcbTthaiNhiptim) == 2; uc_bant_41.txtkbTiengTim.Text = Utility.sDbnull(objBenhAnNgoaiTru.KcbTiengtim); uc_bant_41.txtkbHoHap.Text = Utility.sDbnull(objBenhAnNgoaiTru.KcbHohap); uc_bant_41.txtkbBung.Text = Utility.sDbnull(objBenhAnNgoaiTru.KcbBung); uc_bant_41.chkkbChanPhaiPXGXGiam.Checked = Utility.Int16Dbnull(objBenhAnNgoaiTru.KcbChanphai) == 1; uc_bant_41.chkkbChanPhaiBinhThuong.Checked = Utility.Int16Dbnull(objBenhAnNgoaiTru.KcbChanphai) == 2; uc_bant_41.chkkbChanPhaiTang.Checked = Utility.Int16Dbnull(objBenhAnNgoaiTru.KcbChanphai) == 3; uc_bant_41.txtkbChanPhaiKhac.Text = Utility.sDbnull(objBenhAnNgoaiTru.KcbChanphaiKhac); uc_bant_41.chkkbChanTraiPXGXGiam.Checked = Utility.Int16Dbnull(objBenhAnNgoaiTru.KcbChantrai) == 1; uc_bant_41.chkkbChanTraiBinhThuong.Checked = Utility.Int16Dbnull(objBenhAnNgoaiTru.KcbChantrai) == 2; uc_bant_41.chkkbChanTraiTang.Checked = Utility.Int16Dbnull(objBenhAnNgoaiTru.KcbChantrai) == 3; uc_bant_41.txtkbChanTraiKhac.Text = Utility.sDbnull(objBenhAnNgoaiTru.KcbChantraiKhac); uc_bant_41.txtkbMatPhai.Text = Utility.sDbnull(objBenhAnNgoaiTru.KcbMatphai); uc_bant_41.txtkbMatTrai.Text = Utility.sDbnull(objBenhAnNgoaiTru.KcbMattrai); uc_bant_41.txtkbRangHamMat.Text = Utility.sDbnull(objBenhAnNgoaiTru.KcbRanghammat); uc_bant_41.txtkbKhac1.Text = Utility.sDbnull(objBenhAnNgoaiTru.KcbTkinhKhac); uc_bant_41.txtMach.Text = Utility.sDbnull(objBenhAnNgoaiTru.KcbMach, ""); uc_bant_41.txtNhietDo.Text = Utility.sDbnull(objBenhAnNgoaiTru.KcbNhietdo); uc_bant_41.txtHuyetApTu.Text = Utility.sDbnull(objBenhAnNgoaiTru.KcbHuyetap1); uc_bant_41.txtHuyetApDen.Text = Utility.sDbnull(objBenhAnNgoaiTru.KcbHuyetap2); uc_bant_41.txtNhipTho.Text = Utility.sDbnull(objBenhAnNgoaiTru.KcbNhiptho); uc_bant_41.txtCanNang.Text = Utility.sDbnull(objBenhAnNgoaiTru.KcbCannang); uc_bant_41.txtChieuCao.Text = Utility.sDbnull(objBenhAnNgoaiTru.KcbChieucao); uc_bant_41.txtBMI.Text = Utility.sDbnull(objBenhAnNgoaiTru.KcbBmi); uc_bant_41.txtkbTomTatKQCLSC.Text = Utility.sDbnull(objBenhAnNgoaiTru.KcbTomtatClsChinh); uc_bant_41.TXTKBChanDoanBD.Text = Utility.sDbnull(objBenhAnNgoaiTru.KcbCdoanBdau); uc_bant_41.TXTKBDaXuLy.Text = Utility.sDbnull(objBenhAnNgoaiTru.KcbDaXly); uc_bant_41.txtkbChanDoanRaVien.Text = Utility.sDbnull(objBenhAnNgoaiTru.KcbCdoanRavien); uc_bant_41.dtDieuTriNgoaiTruTu.Value = Convert.ToDateTime(objBenhAnNgoaiTru.KcbDtriTungay); uc_bant_41.dtDieuTriNgoaiTruDen.Value = Convert.ToDateTime(objBenhAnNgoaiTru.KcbDtriDenngay); uc_bant_41.txtQuaTrinhBenhLy.Text = Utility.sDbnull(objBenhAnNgoaiTru.TkbaQtrinhBenhlyDbienCls); uc_bant_41.txtTomTatCLS.Text = Utility.sDbnull(objBenhAnNgoaiTru.TkbaPphapDtri); uc_bant_41.txtBenhChinh.Text = Utility.sDbnull(objBenhAnNgoaiTru.TenBenhChinh); uc_bant_41.txtBenhPhu.Text = Utility.sDbnull(objBenhAnNgoaiTru.TenBenhPhu); uc_bant_41.txtPPDT.Text = Utility.sDbnull(objBenhAnNgoaiTru.TkbaPphapDtri); uc_bant_41.txtTrangThaiRaVien.Text = Utility.sDbnull(objBenhAnNgoaiTru.TkbaTtRavien); uc_bant_41.txtHuongTiepTheo.Text = Utility.sDbnull(objBenhAnNgoaiTru.TkbaHuongTtTieptheo); uc_bant_11.txtDoiTuong.Text = Utility.sDbnull(objBenhAnNgoaiTru.DoiTuong); uc_bant_11.txtSoBaoHiemYte.Text = Utility.sDbnull(objBenhAnNgoaiTru.SoBhyt); uc_bant_11.txtDiaChi.Text = Utility.sDbnull(objBenhAnNgoaiTru.DiaChi); if (Utility.sDbnull(objBenhAnNgoaiTru.NguoiTao, "") != "") { //LStaff objNguoiTao = // new Select("*").From(LStaff.Schema).Where(LStaff.Columns.Uid).IsEqualTo( // Utility.sDbnull(objBenhAnNgoaiTru.NguoiTao)).ExecuteSingle<LStaff>(); //label95.Text = Utility.sDbnull(objNguoiTao.StaffName); } this.Text = string.Format("Bạn đang thực hiện sửa Bệnh án Đái tháo đường cho Bệnh nhân Id={0} - Mã lượt khám={1} - Số BA={2} - Id BA={3}", uc_bant_11.txtMaBN.Text, uc_bant_11.txtMaLanKham.Text, uc_bant_11.txtMaBenhAn.Text, uc_bant_11.txtID_BA.Text); } else { m_enAct = action.Insert; this.Text = string.Format("Bạn đang thực hiện sửa Bệnh án Đái tháo đường cho Bệnh nhân Id={0} - Mã lượt khám={1} - Số BA={2} - Id BA={3}", uc_bant_11.txtMaBN.Text, uc_bant_11.txtMaLanKham.Text, uc_bant_11.txtMaBenhAn.Text, uc_bant_11.txtID_BA.Text); MessageBox.Show("Không lấy được thông tin bệnh án"); } } catch (Exception ex) { MessageBox.Show("Lỗi khi tìm kiếm thông tin BN:\n" + ex.Message); } }