public void retrieveHistory(trn_RefreshLabHistory trl) { try { using (Service.WS_CheckupCls ws = new Service.WS_CheckupCls()) { ws.RetrieveImaging((int)trl.tpr_id, "JobImage"); } //using (InhCheckupDataContext cdc = new InhCheckupDataContext()) //{ // System.Threading.Thread.CurrentThread.CurrentCulture = System.Globalization.CultureInfo.CreateSpecificCulture("en-US"); // var patient = cdc.trn_patient_regis // .Where(x => x.tpr_id == trl.tpr_id) // .Select(x => new // { // hn = x.trn_patient.tpt_hn_no, // en = x.tpr_en_no, // arrived = x.trn_patient_regis_detail == null ? x.tpr_arrive_date.Value.Date : x.trn_patient_regis_detail.tpr_real_arrived_date.Value.Date // }).FirstOrDefault(); // using (Service.WS_CheckupCls ws = new Service.WS_CheckupCls()) // { // ws.InsertDBEmrCheckupResultXray(patient.hn, patient.en, patient.arrived.AddYears(-5), patient.arrived, false); // } //} } catch (Exception ex) { Program.MessageError("GetResultTextFileCls", "retrieveHistory", ex, false); } }
public string Send(int tpr_id, string mrt_code, string mhs_code, string username) { try { using (Service.WS_CheckupCls ws = new Service.WS_CheckupCls()) { return(ws.SendToDocScan(tpr_id, mrt_code, mhs_code, username)); } } catch (Exception ex) { return(ex.Message); } }
public void RetrieveVistalSignBackground(int tpr_id) { try { using (Service.WS_CheckupCls ws = new Service.WS_CheckupCls()) { ws.retrieveVitalSignBackground(tpr_id); } } catch (Exception ex) { Program.MessageError("ClsBasicMeasurement", "ws.retrieveVitalSignBackground", ex, false); } }
private void btnPatho_Click(object sender, EventArgs e) { using (Service.WS_CheckupCls ws = new Service.WS_CheckupCls()) { ws.InsertDBEmrCheckupResultXray(_PatientRegis.trn_patient.tpt_hn_no, _PatientRegis.tpr_en_no, DateTime.Now.AddYears(-5), DateTime.Now, false); } using (InhCheckupDataContext contxt = new InhCheckupDataContext()) { string pathPatho = contxt.trn_patient_history_pathos.Where(x => x.tpt_id == _PatientRegis.tpt_id && x.tphp_en_no == _PatientRegis.tpr_en_no).Select(x => x.tphp_link).FirstOrDefault(); if (string.IsNullOrEmpty(pathPatho)) { MessageBox.Show("Pathology's result is not found.", "Pathology."); } else { System.Diagnostics.Process.Start("IExplore.exe", pathPatho); } } }
public StatusTransaction importPatient(int tpr_id, List <int> mvt_id) { try { using (InhCheckupDataContext contxt = new InhCheckupDataContext()) { DateTime dateNow = Program.GetServerDateTime(); List <trn_RefreshLabHistory> his = contxt.trn_RefreshLabHistories.Where(x => x.tpr_id == tpr_id).ToList(); his.ForEach(x => x.status = true); contxt.SubmitChanges(); trn_patient_regi patient_regis = contxt.trn_patient_regis.Where(x => x.tpr_id == tpr_id).FirstOrDefault(); using (Service.WS_CheckupCls wsCheckup = new Service.WS_CheckupCls()) { wsCheckup.InsertDBEmrCheckupResultXray(patient_regis.trn_patient.tpt_hn_no, patient_regis.tpr_en_no, dateNow.AddYears(-5), dateNow, true); } } using (InhCheckupDataContext cdc = new InhCheckupDataContext()) { try { string username = Program.CurrentUser == null ? "" : Program.CurrentUser.mut_username; DateTime dateNow = Program.GetServerDateTime(); cdc.Connection.Open(); DbTransaction trans = cdc.Connection.BeginTransaction(); cdc.Transaction = trans; trn_patient_regi patient_regis = cdc.trn_patient_regis.Where(x => x.tpr_id == tpr_id).FirstOrDefault(); patient_regis.trn_patient_queues.ToList().ForEach(x => { x.tps_status = "ED"; x.tps_ns_status = null; x.tps_update_by = username; x.tps_update_date = dateNow; }); int enRowID = Convert.ToInt32(patient_regis.tpr_en_rowid); EmrClass.GetPTPackageCls PackageCls = new EmrClass.GetPTPackageCls(); EnumerableRowCollection <DataRow> getPTPackage = PackageCls.GetPTPackage(enRowID); PackageCls.AddPatientOrderItem(ref patient_regis, username, dateNow, getPTPackage); PackageCls.AddPatientOrderSet(ref patient_regis, username, dateNow, getPTPackage); List <MapOrderEvent> mapOrder = PackageCls.MapEvent(getPTPackage); PackageCls.AddPatientEvent(ref patient_regis, username, dateNow, mapOrder); PackageCls.AddPatientPlan(ref patient_regis, username, dateNow, mapOrder); PackageCls.skipReqDoctorOutDepartment(ref patient_regis); PackageCls.CompleteEcho(ref patient_regis); PackageCls.skipChangeEstToEcho(ref patient_regis, patient_regis.mhs_id); PackageCls.checkOrderPMR(ref patient_regis, patient_regis.mhs_id); patient_regis.tpr_status = "WB"; patient_regis.tpr_pe_status = "RS"; try { cdc.SubmitChanges(); } catch (System.Data.Linq.ChangeConflictException) { foreach (System.Data.Linq.ObjectChangeConflict occ in cdc.ChangeConflicts) { cdc.Refresh(System.Data.Linq.RefreshMode.KeepChanges, occ.Object); } cdc.SubmitChanges(); } PackageCls.setRelationOrderSet(ref patient_regis); cdc.SubmitChanges(); cdc.Transaction.Commit(); using (Service.WS_CheckupCls ws = new Service.WS_CheckupCls()) { ws.retrieveVitalSign(tpr_id, username); ws.getCheckUpLabResult(patient_regis.trn_patient.tpt_hn_no, tpr_id); } return(StatusTransaction.True); } catch (Exception ex) { cdc.Transaction.Rollback(); Program.MessageError("ImportPatientToBookCls", "importPatient", ex, false); return(StatusTransaction.Error); } finally { cdc.Connection.Close(); } } } catch (Exception ex) { Program.MessageError("ImportPatientToBookCls", "importPatient", ex, false); return(StatusTransaction.Error); } }