Esempio n. 1
0
        private void OnEdit()
        {
            _isPrint      = false;
            _ketQuaSoiCTC = null;
            if (dgSoCTC.SelectedRows == null || dgSoCTC.SelectedRows.Count <= 0)
            {
                MsgBox.Show(Application.ProductName, "Vui lòng chọn 1 kết quả soi.", IconType.Information);
                return;
            }

            if (Global.AllowEditKhamCTC && Global.TVHomeConfig.SuDungSoiCTC && !File.Exists(Global.TVHomeConfig.Path))
            {
                MsgBox.Show(Application.ProductName, "Đường dẫn TVHome không tồn tại, vui lòng kiểm tra lại.", IconType.Information);
                return;
            }

            DataRow            drKetQuaSoiCTC = (dgSoCTC.SelectedRows[0].DataBoundItem as DataRowView).Row;
            bool               allowEdit      = _isChuyenBenhAn ? false : Global.AllowEditKhamCTC;
            dlgAddKetQuaSoiCTC dlg            = new dlgAddKetQuaSoiCTC(_patientGUID, drKetQuaSoiCTC, allowEdit);

            if (dlg.ShowDialog() == DialogResult.OK)
            {
                _isPrint      = dlg.IsPrint;
                _ketQuaSoiCTC = dlg.KetQuaSoiCTC;
                DisplayAsThread();
            }
        }
Esempio n. 2
0
        private void OnAdd()
        {
            _isPrint      = false;
            _ketQuaSoiCTC = null;

            if (Global.TVHomeConfig.SuDungSoiCTC && !File.Exists(Global.TVHomeConfig.Path))
            {
                MsgBox.Show(Application.ProductName, "Đường dẫn TVHome không tồn tại, vui lòng kiểm tra lại.", IconType.Information);
                return;
            }

            dlgAddKetQuaSoiCTC dlg = new dlgAddKetQuaSoiCTC(_patientGUID);

            if (dlg.ShowDialog() == DialogResult.OK)
            {
                _isPrint      = dlg.IsPrint;
                _ketQuaSoiCTC = dlg.KetQuaSoiCTC;
                DisplayAsThread();
            }
        }
Esempio n. 3
0
        public static Result ChuyenBenhAn(string patientGUID, List <DataRow> rows)
        {
            Result     result = new Result();
            MMOverride db     = null;

            try
            {
                db = new MMOverride();
                using (TransactionScope t = new TransactionScope(TransactionScopeOption.RequiresNew))
                {
                    foreach (DataRow row in rows)
                    {
                        string       ketQuaSoiCTCGUID = row["KetQuaSoiCTCGUID"].ToString();
                        KetQuaSoiCTC ketQuaSoiCTC     = (from s in db.KetQuaSoiCTCs
                                                         where s.KetQuaSoiCTCGUID.ToString() == ketQuaSoiCTCGUID
                                                         select s).FirstOrDefault();

                        if (ketQuaSoiCTC == null)
                        {
                            continue;
                        }

                        //Tracking
                        string desc = string.Format("- KetQuaSoiCTCGUID: '{0}': PatientGUID: '{1}' ==> '{2}' (KetQuaSoiCTC)",
                                                    ketQuaSoiCTCGUID, ketQuaSoiCTC.PatientGUID.ToString(), patientGUID);

                        ketQuaSoiCTC.PatientGUID = Guid.Parse(patientGUID);

                        Tracking tk = new Tracking();
                        tk.TrackingGUID = Guid.NewGuid();
                        tk.TrackingDate = DateTime.Now;
                        tk.DocStaffGUID = Guid.Parse(Global.UserGUID);
                        tk.ActionType   = (byte)ActionType.Edit;
                        tk.Action       = "Chuyển bệnh án";
                        tk.Description  = desc;
                        tk.TrackingType = (byte)TrackingType.None;
                        tk.ComputerName = Utility.GetDNSHostName();
                        db.Trackings.InsertOnSubmit(tk);
                    }

                    db.SubmitChanges();
                    t.Complete();
                }
            }
            catch (System.Data.SqlClient.SqlException se)
            {
                result.Error.Code        = (se.Message.IndexOf("Timeout expired") >= 0) ? ErrorCode.SQL_QUERY_TIMEOUT : ErrorCode.INVALID_SQL_STATEMENT;
                result.Error.Description = se.ToString();
            }
            catch (Exception e)
            {
                result.Error.Code        = ErrorCode.UNKNOWN_ERROR;
                result.Error.Description = e.ToString();
            }
            finally
            {
                if (db != null)
                {
                    db.Dispose();
                    db = null;
                }
            }

            return(result);
        }
Esempio n. 4
0
        public static Result DeleteKetQuaSoiCTC(List <String> ketQuaSoiCTCKeys)
        {
            Result     result = new Result();
            MMOverride db     = null;

            try
            {
                db = new MMOverride();
                using (TransactionScope t = new TransactionScope(TransactionScopeOption.RequiresNew))
                {
                    string desc = string.Empty;
                    foreach (string key in ketQuaSoiCTCKeys)
                    {
                        KetQuaSoiCTC kqsctc = db.KetQuaSoiCTCs.SingleOrDefault <KetQuaSoiCTC>(k => k.KetQuaSoiCTCGUID.ToString() == key);
                        if (kqsctc != null)
                        {
                            kqsctc.DeletedDate = DateTime.Now;
                            kqsctc.DeletedBy   = Guid.Parse(Global.UserGUID);
                            kqsctc.Status      = (byte)Status.Deactived;

                            desc += string.Format("- GUID: '{0}', Ngày khám: '{1}', Bệnh nhân: '{2}', Bác sĩ soi: '{3}', Kết luận: '{4}', Đề nghị: '{5}'\n",
                                                  kqsctc.KetQuaSoiCTCGUID.ToString(), kqsctc.NgayKham.ToString("dd/MM/yyyy HH:mm:ss"), kqsctc.Patient.Contact.FullName,
                                                  kqsctc.DocStaff.Contact.FullName, kqsctc.KetLuan, kqsctc.DeNghi);
                        }
                    }

                    //Tracking
                    desc = desc.Substring(0, desc.Length - 1);
                    Tracking tk = new Tracking();
                    tk.TrackingGUID = Guid.NewGuid();
                    tk.TrackingDate = DateTime.Now;
                    tk.DocStaffGUID = Guid.Parse(Global.UserGUID);
                    tk.ActionType   = (byte)ActionType.Delete;
                    tk.Action       = "Xóa thông tin khám CTC";
                    tk.Description  = desc;
                    tk.TrackingType = (byte)TrackingType.None;
                    tk.ComputerName = Utility.GetDNSHostName();
                    db.Trackings.InsertOnSubmit(tk);

                    db.SubmitChanges();
                    t.Complete();
                }
            }
            catch (System.Data.SqlClient.SqlException se)
            {
                result.Error.Code        = (se.Message.IndexOf("Timeout expired") >= 0) ? ErrorCode.SQL_QUERY_TIMEOUT : ErrorCode.INVALID_SQL_STATEMENT;
                result.Error.Description = se.ToString();
            }
            catch (Exception e)
            {
                result.Error.Code        = ErrorCode.UNKNOWN_ERROR;
                result.Error.Description = e.ToString();
            }
            finally
            {
                if (db != null)
                {
                    db.Dispose();
                    db = null;
                }
            }

            return(result);
        }
Esempio n. 5
0
        public static Result InsertKetQuaSoiCTC(KetQuaSoiCTC ketQuaSoiCTC)
        {
            Result     result = new Result();
            MMOverride db     = null;

            try
            {
                db = new MMOverride();
                string desc = string.Empty;
                using (TransactionScope t = new TransactionScope(TransactionScopeOption.RequiresNew))
                {
                    //Insert
                    if (ketQuaSoiCTC.KetQuaSoiCTCGUID == null || ketQuaSoiCTC.KetQuaSoiCTCGUID == Guid.Empty)
                    {
                        ketQuaSoiCTC.KetQuaSoiCTCGUID = Guid.NewGuid();
                        db.KetQuaSoiCTCs.InsertOnSubmit(ketQuaSoiCTC);
                        db.SubmitChanges();

                        //Tracking
                        desc += string.Format("- GUID: '{0}', Ngày khám: '{1}', Bệnh nhân: '{2}', Bác sĩ soi: '{3}', Kết luận: '{4}', Đề nghị: '{5}', Âm hộ: '{6}', Âm đạo: '{7}', CTC: '{8}', Biểu mô lát: '{9}', Mô đệm: '{10}', Ranh giới lát trụ: '{11}', Sau Acid Acetic: '{12}', Sau Lugol: '{13}'\n",
                                              ketQuaSoiCTC.KetQuaSoiCTCGUID.ToString(), ketQuaSoiCTC.NgayKham.ToString("dd/MM/yyyy HH:mm:ss"),
                                              ketQuaSoiCTC.Patient.Contact.FullName, ketQuaSoiCTC.DocStaff.Contact.FullName,
                                              ketQuaSoiCTC.KetLuan, ketQuaSoiCTC.DeNghi, ketQuaSoiCTC.AmHo, ketQuaSoiCTC.AmDao, ketQuaSoiCTC.CTC, ketQuaSoiCTC.BieuMoLat,
                                              ketQuaSoiCTC.MoDem, ketQuaSoiCTC.RanhGioiLatTru, ketQuaSoiCTC.SauAcidAcetic, ketQuaSoiCTC.SauLugol);

                        Tracking tk = new Tracking();
                        tk.TrackingGUID = Guid.NewGuid();
                        tk.TrackingDate = DateTime.Now;
                        tk.DocStaffGUID = Guid.Parse(Global.UserGUID);
                        tk.ActionType   = (byte)ActionType.Add;
                        tk.Action       = "Thêm thông tin khám CTC";
                        tk.Description  = desc;
                        tk.TrackingType = (byte)TrackingType.None;
                        tk.ComputerName = Utility.GetDNSHostName();
                        db.Trackings.InsertOnSubmit(tk);

                        db.SubmitChanges();
                    }
                    else //Update
                    {
                        KetQuaSoiCTC kqsctc = db.KetQuaSoiCTCs.SingleOrDefault <KetQuaSoiCTC>(k => k.KetQuaSoiCTCGUID == ketQuaSoiCTC.KetQuaSoiCTCGUID);
                        if (kqsctc != null)
                        {
                            kqsctc.NgayKham       = ketQuaSoiCTC.NgayKham;
                            kqsctc.PatientGUID    = ketQuaSoiCTC.PatientGUID;
                            kqsctc.BacSiSoi       = ketQuaSoiCTC.BacSiSoi;
                            kqsctc.KetLuan        = ketQuaSoiCTC.KetLuan;
                            kqsctc.DeNghi         = ketQuaSoiCTC.DeNghi;
                            kqsctc.Hinh1          = ketQuaSoiCTC.Hinh1;
                            kqsctc.Hinh2          = ketQuaSoiCTC.Hinh2;
                            kqsctc.AmHo           = ketQuaSoiCTC.AmHo;
                            kqsctc.AmDao          = ketQuaSoiCTC.AmDao;
                            kqsctc.CTC            = ketQuaSoiCTC.CTC;
                            kqsctc.BieuMoLat      = ketQuaSoiCTC.BieuMoLat;
                            kqsctc.MoDem          = ketQuaSoiCTC.MoDem;
                            kqsctc.RanhGioiLatTru = ketQuaSoiCTC.RanhGioiLatTru;
                            kqsctc.SauAcidAcetic  = ketQuaSoiCTC.SauAcidAcetic;
                            kqsctc.SauLugol       = ketQuaSoiCTC.SauLugol;
                            kqsctc.CreatedBy      = ketQuaSoiCTC.CreatedBy;
                            kqsctc.CreatedDate    = ketQuaSoiCTC.CreatedDate;
                            kqsctc.DeletedBy      = ketQuaSoiCTC.DeletedBy;
                            kqsctc.DeletedDate    = ketQuaSoiCTC.DeletedDate;
                            kqsctc.UpdatedBy      = ketQuaSoiCTC.UpdatedBy;
                            kqsctc.UpdatedDate    = ketQuaSoiCTC.UpdatedDate;
                            kqsctc.Status         = ketQuaSoiCTC.Status;
                            db.SubmitChanges();

                            //Tracking
                            desc += string.Format("- GUID: '{0}', Ngày khám: '{1}', Bệnh nhân: '{2}', Bác sĩ soi: '{3}', Kết luận: '{4}', Đề nghị: '{5}', Âm hộ: '{6}', Âm đạo: '{7}', CTC: '{8}', Biểu mô lát: '{9}', Mô đệm: '{10}', Ranh giới lát trụ: '{11}', Sau Acid Acetic: '{12}', Sau Lugol: '{13}'\n",
                                                  kqsctc.KetQuaSoiCTCGUID.ToString(), kqsctc.NgayKham.ToString("dd/MM/yyyy HH:mm:ss"),
                                                  kqsctc.Patient.Contact.FullName, kqsctc.DocStaff.Contact.FullName,
                                                  kqsctc.KetLuan, kqsctc.DeNghi, kqsctc.AmHo, kqsctc.AmDao, kqsctc.CTC, kqsctc.BieuMoLat,
                                                  kqsctc.MoDem, kqsctc.RanhGioiLatTru, kqsctc.SauAcidAcetic, kqsctc.SauLugol);

                            Tracking tk = new Tracking();
                            tk.TrackingGUID = Guid.NewGuid();
                            tk.TrackingDate = DateTime.Now;
                            tk.DocStaffGUID = Guid.Parse(Global.UserGUID);
                            tk.ActionType   = (byte)ActionType.Edit;
                            tk.Action       = "Sửa thông tin khám CTC";
                            tk.Description  = desc;
                            tk.TrackingType = (byte)TrackingType.None;
                            tk.ComputerName = Utility.GetDNSHostName();
                            db.Trackings.InsertOnSubmit(tk);

                            db.SubmitChanges();
                        }
                    }

                    t.Complete();
                }
            }
            catch (System.Data.SqlClient.SqlException se)
            {
                result.Error.Code        = (se.Message.IndexOf("Timeout expired") >= 0) ? ErrorCode.SQL_QUERY_TIMEOUT : ErrorCode.INVALID_SQL_STATEMENT;
                result.Error.Description = se.ToString();
            }
            catch (Exception e)
            {
                result.Error.Code        = ErrorCode.UNKNOWN_ERROR;
                result.Error.Description = e.ToString();
            }
            finally
            {
                if (db != null)
                {
                    db.Dispose();
                    db = null;
                }
            }

            return(result);
        }