public DdtInspection GetById(string id) { using (dynamic connection = connectionFactory.GetConnection()) { String sql = String.Format("SELECT dsid_hospitality_session, r_object_id, dsdt_inspection_date, r_modify_date, dss_diagnosis, dss_kateter_placement, r_creation_date, dss_complaints, dss_inspection, dsid_doctor, dss_inspection_result, dsid_patient FROM ddt_inspection WHERE r_object_id = '{0}'", id); Logger.Debug(CultureInfo.CurrentCulture, "SQL: {0}", sql); Npgsql.NpgsqlCommand command = new Npgsql.NpgsqlCommand(sql, connection); using (DbDataReader reader = command.ExecuteReader()) { if (reader.Read()) { DdtInspection obj = new DdtInspection(); obj.HospitalitySession = reader.IsDBNull(0) ? null : reader.GetString(0); obj.ObjectId = reader.IsDBNull(1) ? null : reader.GetString(1); obj.InspectionDate = reader.IsDBNull(2) ? DateTime.MinValue : reader.GetDateTime(2); obj.ModifyDate = reader.IsDBNull(3) ? DateTime.MinValue : reader.GetDateTime(3); obj.Diagnosis = reader.IsDBNull(4) ? null : reader.GetString(4); obj.KateterPlacement = reader.IsDBNull(5) ? null : reader.GetString(5); obj.CreationDate = reader.IsDBNull(6) ? DateTime.MinValue : reader.GetDateTime(6); obj.Complaints = reader.IsDBNull(7) ? null : reader.GetString(7); obj.Inspection = reader.IsDBNull(8) ? null : reader.GetString(8); obj.Doctor = reader.IsDBNull(9) ? null : reader.GetString(9); obj.InspectionResult = reader.IsDBNull(10) ? null : reader.GetString(10); obj.Patient = reader.IsDBNull(11) ? null : reader.GetString(11); return(obj); } } } return(null); }
public string Save(DdtInspection obj) { using (dynamic connection = connectionFactory.GetConnection()) { if (GetById(obj.ObjectId) != null) { string sql = "UPDATE ddt_inspection SET " + "dsid_hospitality_session = @HospitalitySession, " + "dsid_patient = @Patient, " + "dsid_doctor = @Doctor, " + "dsdt_inspection_date = @InspectionDate, " + "dss_diagnosis = @Diagnosis, " + "dss_complaints = @Complaints, " + "dss_inspection = @Inspection, " + "dss_kateter_placement = @KateterPlacement, " + "dss_inspection_result = @InspectionResult " + "WHERE r_object_id = @ObjectId"; Logger.Debug(CultureInfo.CurrentCulture, "SQL: {0}", sql); using (Npgsql.NpgsqlCommand cmd = new Npgsql.NpgsqlCommand(sql, connection)) { cmd.CommandType = CommandType.Text; cmd.Parameters.AddWithValue("@HospitalitySession", obj.HospitalitySession); cmd.Parameters.AddWithValue("@Patient", obj.Patient); cmd.Parameters.AddWithValue("@Doctor", obj.Doctor); cmd.Parameters.AddWithValue("@InspectionDate", obj.InspectionDate); cmd.Parameters.AddWithValue("@Diagnosis", obj.Diagnosis == null ? "" : obj.Diagnosis); cmd.Parameters.AddWithValue("@Complaints", obj.Complaints == null ? "" : obj.Complaints); cmd.Parameters.AddWithValue("@Inspection", obj.Inspection == null ? "" : obj.Inspection); cmd.Parameters.AddWithValue("@KateterPlacement", obj.KateterPlacement == null ? "" : obj.KateterPlacement); cmd.Parameters.AddWithValue("@InspectionResult", obj.InspectionResult == null ? "" : obj.InspectionResult); cmd.Parameters.AddWithValue("@ObjectId", obj.ObjectId); cmd.ExecuteNonQuery(); } return(obj.ObjectId); } else { string sql = "INSERT INTO ddt_inspection(dsid_hospitality_session,dsid_patient,dsid_doctor,dsdt_inspection_date,dss_diagnosis,dss_complaints,dss_inspection,dss_kateter_placement,dss_inspection_result) " + "VALUES(@HospitalitySession,@Patient,@Doctor,@InspectionDate,@Diagnosis,@Complaints,@Inspection,@KateterPlacement,@InspectionResult) RETURNING r_object_id"; Logger.Debug(CultureInfo.CurrentCulture, "SQL: {0}", sql); using (Npgsql.NpgsqlCommand cmd = new Npgsql.NpgsqlCommand(sql, connection)) { cmd.CommandType = CommandType.Text; cmd.Parameters.AddWithValue("@HospitalitySession", obj.HospitalitySession); cmd.Parameters.AddWithValue("@Patient", obj.Patient); cmd.Parameters.AddWithValue("@Doctor", obj.Doctor); cmd.Parameters.AddWithValue("@InspectionDate", obj.InspectionDate); cmd.Parameters.AddWithValue("@Diagnosis", obj.Diagnosis == null ? "" : obj.Diagnosis); cmd.Parameters.AddWithValue("@Complaints", obj.Complaints == null ? "" : obj.Complaints); cmd.Parameters.AddWithValue("@Inspection", obj.Inspection == null ? "" : obj.Inspection); cmd.Parameters.AddWithValue("@KateterPlacement", obj.KateterPlacement == null ? "" : obj.KateterPlacement); cmd.Parameters.AddWithValue("@InspectionResult", obj.InspectionResult == null ? "" : obj.InspectionResult); return((string)cmd.ExecuteScalar()); } } } }
public string processTemplate(IDbDataService service, string hospitalitySession, string objectId, Dictionary <string, string> aditionalValues) { Dictionary <string, string> values = null; if (aditionalValues != null) { values = new Dictionary <string, string>(aditionalValues); } else { values = new Dictionary <string, string>(); } DdtInspection obj = service.GetDdtInspectionService().GetById(objectId); values.Add("{date}", obj.InspectionDate.ToShortDateString()); values.Add("{time}", obj.InspectionDate.ToShortTimeString()); values.Add("{patient.diagnosis}", obj.Diagnosis); values.Add("{complaints}", obj.Complaints); values.Add("{inspection}", obj.Inspection); values.Add("{kateter}", obj.KateterPlacement); values.Add("{result}", obj.InspectionResult); DdvPatient patient = service.GetDdvPatientService().GetById(obj.Patient); values.Add("{patient.initials}", patient == null ? "" : patient.ShortName); values.Add("{patient.age}", patient == null ? "" : (DateTime.Now.Year - patient.Birthdate.Year) + ""); if (!values.ContainsKey("{doctor.who.short}")) { DdvDoctor doc = service.GetDdvDoctorService().GetById(obj.Doctor); values.Add("{doctor.who.short}", doc == null ? "" : doc.ShortName); } IList <DdvDoctor> heads = service.GetDdvDoctorService().GetByGroupName("cardioreanimation_department_head"); if (heads.Count != 0) { DdvDoctor head = heads[0]; values.Add("{doctor.head.short}", head.ShortName); } PutAnalysisData(values, service, obj.ObjectId); string resultFileName = TemplatesUtils.getTempFileName("Ежедневный осмотр", patient.FullName); return(TemplatesUtils.FillTemplate(Directory.GetCurrentDirectory() + "\\Templates\\" + TEMPLATE_FILE_NAME, values, resultFileName)); }
private void initControls(string inspectionObjId) { ControlUtils.InitDoctorsByGroupName(service.GetDdvDoctorService(), cardioDoctorBox, "cardioreanimation_department"); cardioDoctorBox.SelectedValue = hospitalitySession.CuringDoctor; kagContainer.Visible = false; DdvPatient patient = service.GetDdvPatientService().GetById(hospitalitySession.Patient); if (patient != null) { Text += " " + patient.ShortName; } inspectionObj = service.GetDdtInspectionService().GetById(inspectionObjId); DateTime startDate = inspectionObj == null ? DateTime.Now : inspectionObj.InspectionDate; DdtJournal kagJournal = CommonUtils.ResolveKagJournal(service, startDate, hospitalitySession.ObjectId); if (inspectionObj != null) { complaintsTxt.Text = inspectionObj.Complaints; diagnosisTxt.Text = inspectionObj.Diagnosis; inspectionTxt.Text = inspectionObj.Inspection; resultTxt.Text = inspectionObj.InspectionResult; kateterPlacementTxt.Text = inspectionObj.KateterPlacement; } else { if (kagJournal != null) { diagnosisTxt.Text = kagJournal.Diagnosis; DdtVariousSpecConcluson releaseConclusion = service.GetDdtVariousSpecConclusonService().GetByParentId(kagJournal.ObjectId); if (releaseConclusion != null) { inspectionTxt.Text = releaseConclusion.SpecialistConclusion; } } else { diagnosisTxt.Text = hospitalitySession.Diagnosis; } } initKag(service, kagJournal); }
private void saveInspectionObj(IDbDataService service) { if (inspectionObj == null) { inspectionObj = new DdtInspection(); inspectionObj.Doctor = hospitalitySession.CuringDoctor; inspectionObj.HospitalitySession = hospitalitySession.ObjectId; inspectionObj.Patient = hospitalitySession.Patient; } inspectionObj.Complaints = getSafeStringValue(complaintsTxt); inspectionObj.Diagnosis = getSafeStringValue(diagnosisTxt); inspectionObj.Inspection = getSafeStringValue(inspectionTxt); inspectionObj.InspectionResult = getSafeStringValue(resultTxt); inspectionObj.KateterPlacement = getSafeStringValue(kateterPlacementTxt); inspectionObj.InspectionDate = CommonUtils.ConstructDateWIthTime(inspectionDate.Value, inspectionTime.Value); string id = service.GetDdtInspectionService().Save(inspectionObj); inspectionObj.ObjectId = id; }