public List <DdtEkg> GetByQuery(string sql) { List <DdtEkg> list = new List <DdtEkg>(); using (dynamic connection = connectionFactory.GetConnection()) { Logger.Debug(CultureInfo.CurrentCulture, "SQL: {0}", sql); Npgsql.NpgsqlCommand command = new Npgsql.NpgsqlCommand(sql, connection); using (DbDataReader reader = command.ExecuteReader()) { while (reader.Read()) { DdtEkg obj = new DdtEkg(); obj.HospitalitySession = reader.IsDBNull(0) ? null : reader.GetString(0); obj.ObjectId = reader.IsDBNull(1) ? null : reader.GetString(1); obj.AnalysisDate = reader.IsDBNull(2) ? DateTime.MinValue : reader.GetDateTime(2); obj.ModifyDate = reader.IsDBNull(3) ? DateTime.MinValue : reader.GetDateTime(3); obj.ParentType = reader.IsDBNull(4) ? null : reader.GetString(4); obj.CreationDate = reader.IsDBNull(5) ? DateTime.MinValue : reader.GetDateTime(5); obj.Parent = reader.IsDBNull(6) ? null : reader.GetString(6); obj.AdmissionAnalysis = reader.GetBoolean(7); obj.Ekg = reader.IsDBNull(8) ? null : reader.GetString(8); obj.Doctor = reader.IsDBNull(9) ? null : reader.GetString(9); obj.Patient = reader.IsDBNull(10) ? null : reader.GetString(10); list.Add(obj); } } } return(list); }
public DdtEkg GetByHospitalSessionAndAdmission(string hospitalSession) { using (dynamic connection = connectionFactory.GetConnection()) { String sql = String.Format(CultureInfo.CurrentCulture, "SELECT dsid_hospitality_session, r_object_id, dsdt_analysis_date, r_modify_date, dss_parent_type, r_creation_date, dsid_parent, dsb_admission_analysis, dss_ekg, dsid_doctor, dsid_patient " + "FROM ddt_ekg WHERE dsid_hospitality_session = '{0}'", hospitalSession); Logger.Debug(CultureInfo.CurrentCulture, "SQL: {0}", sql); Npgsql.NpgsqlCommand command = new Npgsql.NpgsqlCommand(sql, connection); using (DbDataReader reader = command.ExecuteReader()) { if (reader.Read()) { DdtEkg obj = new DdtEkg(); obj.HospitalitySession = reader.IsDBNull(0) ? null : reader.GetString(0); obj.ObjectId = reader.IsDBNull(1) ? null : reader.GetString(1); obj.AnalysisDate = reader.IsDBNull(2) ? DateTime.MinValue : reader.GetDateTime(2); obj.ModifyDate = reader.IsDBNull(3) ? DateTime.MinValue : reader.GetDateTime(3); obj.ParentType = reader.IsDBNull(4) ? null : reader.GetString(4); obj.CreationDate = reader.IsDBNull(5) ? DateTime.MinValue : reader.GetDateTime(5); obj.Parent = reader.IsDBNull(6) ? null : reader.GetString(6); obj.AdmissionAnalysis = reader.GetBoolean(7); obj.Ekg = reader.IsDBNull(8) ? null : reader.GetString(8); obj.Doctor = reader.IsDBNull(9) ? null : reader.GetString(9); obj.Patient = reader.IsDBNull(10) ? null : reader.GetString(10); return(obj); } } } return(null); }
public string Save(DdtEkg obj) { using (dynamic connection = connectionFactory.GetConnection()) { if (GetById(obj.ObjectId) != null) { string sql = "UPDATE ddt_ekg SET " + "dsid_hospitality_session = @HospitalitySession, " + "dsid_patient = @Patient, " + "dsid_doctor = @Doctor, " + "dss_ekg = @Ekg, " + "dsb_admission_analysis = @AdmissionAnalysis, " + "dsid_parent = @Parent, " + "dsdt_analysis_date = @AnalysisDate, " + "dss_parent_type = @ParentType " + "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("@Ekg", obj.Ekg == null ? "" : obj.Ekg); cmd.Parameters.AddWithValue("@AdmissionAnalysis", obj.AdmissionAnalysis); cmd.Parameters.AddWithValue("@Parent", obj.Parent == null ? "0000000000000000" : obj.Parent); cmd.Parameters.AddWithValue("@AnalysisDate", obj.AnalysisDate); cmd.Parameters.AddWithValue("@ParentType", obj.ParentType == null ? "" : obj.ParentType); cmd.Parameters.AddWithValue("@ObjectId", obj.ObjectId); cmd.ExecuteNonQuery(); } return(obj.ObjectId); } else { string sql = "INSERT INTO ddt_ekg(dsid_hospitality_session,dsid_patient,dsid_doctor,dss_ekg,dsb_admission_analysis,dsid_parent,dsdt_analysis_date,dss_parent_type) " + "VALUES(@HospitalitySession,@Patient,@Doctor,@Ekg,@AdmissionAnalysis,@Parent,@AnalysisDate,@ParentType) 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("@Ekg", obj.Ekg == null ? "" : obj.Ekg); cmd.Parameters.AddWithValue("@AdmissionAnalysis", obj.AdmissionAnalysis); cmd.Parameters.AddWithValue("@Parent", obj.Parent == null ? "0000000000000000" : obj.Parent); cmd.Parameters.AddWithValue("@AnalysisDate", obj.AnalysisDate); cmd.Parameters.AddWithValue("@ParentType", obj.ParentType == null ? "" : obj.ParentType); return((string)cmd.ExecuteScalar()); } } } }
public object getObject() { DdtEkg ekg = DbDataService.GetInstance().GetDdtEkgService().GetById(objectId); if (ekg == null) { ekg = new DdtEkg(); } ekg.AnalysisDate = analysisDate.Value; ekg.Ekg = regularEkgTxt.Text; return(ekg); }
private void initControls() { DdtEkg ekg = DbDataService.GetInstance().GetDdtEkgService().GetById(objectId); refreshObject(ekg); regularEkgTxt.Enabled = isEditable; readonlyEkgTxt.Enabled = isEditable; analysisDate.Enabled = isEditable; editablePnl.Visible = isEditable; readonlyEkgBox.Visible = !isEditable; editablePnl.Size = isEditable ? FULL_SIZE : READONLY_SIZE; }
public void refreshObject(object obj) { if (obj != null && obj is DdtEkg) { DdtEkg ekg = (DdtEkg)obj; readonlyEkgTxt.Text = ekg.Ekg; regularEkgTxt.Text = ekg.Ekg; analysisDate.Value = ekg.AnalysisDate; readonlyEkgBox.Text = "ЭКГ за " + ekg.AnalysisDate.ToShortDateString(); objectId = ekg.ObjectId; isNew = string.IsNullOrEmpty(objectId); hasChanges = false; } }
public void saveObject(DdtHospital hospitalitySession, string parentId, string parentType) { if (isEditable && (isNew && !string.IsNullOrEmpty(regularEkgTxt.Text) || isDirty())) { DdtEkg ekg = (DdtEkg)getObject(); ekg.HospitalitySession = hospitalitySession.ObjectId; ekg.Doctor = hospitalitySession.CuringDoctor; ekg.Patient = hospitalitySession.Patient; if (parentId != null) { ekg.Parent = parentId; } if (parentType != null) { ekg.ParentType = parentType; } objectId = DbDataService.GetInstance().GetDdtEkgService().Save(ekg); isNew = false; hasChanges = false; } }
public IList <DdtEkg> GetByParentId(string parentId) { IList <DdtEkg> list = new List <DdtEkg>(); if (parentId == null) { return(list); } using (dynamic connection = connectionFactory.GetConnection()) { String sql = String.Format(CultureInfo.CurrentCulture, "SELECT dsid_hospitality_session, ek.r_object_id, dsdt_analysis_date, " + "r_modify_date, ek.dss_parent_type, r_creation_date, rel.dsid_parent, dsb_admission_analysis, dss_ekg, " + "dsid_doctor, dsid_patient FROM ddt_ekg ek, ddt_relation rel WHERE rel.dsid_parent = '{0}' AND rel.dsid_child=ek.r_object_id", parentId); Logger.Debug(CultureInfo.CurrentCulture, "SQL: {0}", sql); Npgsql.NpgsqlCommand command = new Npgsql.NpgsqlCommand(sql, connection); using (DbDataReader reader = command.ExecuteReader()) { while (reader.Read()) { DdtEkg obj = new DdtEkg(); obj.HospitalitySession = reader.IsDBNull(0) ? null : reader.GetString(0); obj.ObjectId = reader.IsDBNull(1) ? null : reader.GetString(1); obj.AnalysisDate = reader.IsDBNull(2) ? DateTime.MinValue : reader.GetDateTime(2); obj.ModifyDate = reader.IsDBNull(3) ? DateTime.MinValue : reader.GetDateTime(3); obj.ParentType = reader.IsDBNull(4) ? null : reader.GetString(4); obj.CreationDate = reader.IsDBNull(5) ? DateTime.MinValue : reader.GetDateTime(5); obj.Parent = reader.IsDBNull(6) ? null : reader.GetString(6); obj.AdmissionAnalysis = reader.GetBoolean(7); obj.Ekg = reader.IsDBNull(8) ? null : reader.GetString(8); obj.Doctor = reader.IsDBNull(9) ? null : reader.GetString(9); obj.Patient = reader.IsDBNull(10) ? null : reader.GetString(10); list.Add(obj); } } } return(list); }