private void initUrineAnalysis()
{
if (CommonUtils.isNotBlank(patientAnalysis.DsisUrineAnalysis))
{
colorTxt.Text = urineAnalysis.DssColor;
acidityTxt.Text = urineAnalysis.DssAcidity;
erythrocytesTxt.Text = urineAnalysis.DssErythrocytes;
glucoseTxt.Text = urineAnalysis.DssGlucose;
ketonesTxt.Text = urineAnalysis.DssKetones;
leukocytesTxt.Text = urineAnalysis.DssLeukocytes;
proteinTxt.Text = urineAnalysis.DssProtein;
specGravityTxt.Text = urineAnalysis.DssSpecificGravity;
}
DataService servise = new DataService();
DdtUrineAnalysis firstAnalysis = servise.queryObject <DdtUrineAnalysis>(@"select * from ddt_urine_analysis where dsb_admission_analysis=true
and dsid_hospitality_session='" + hospitalitySession.ObjectId + "'");
if (firstAnalysis != null)
{
firstColorTxt.Text = firstAnalysis.DssColor;
firstAcidityTxt.Text = firstAnalysis.DssAcidity;
firstErythrocytesTxt.Text = firstAnalysis.DssErythrocytes;
firstGlucoseTxt.Text = firstAnalysis.DssGlucose;
firstKetonesTxt.Text = firstAnalysis.DssKetones;
firstLeucocytesTxt.Text = firstAnalysis.DssLeukocytes;
firstProteinTxt.Text = firstAnalysis.DssProtein;
firstSpecGravityTxt.Text = firstAnalysis.DssSpecificGravity;
}
}
private void initControls()
{
DdtUrineAnalysis urineAnalysis = DbDataService.GetInstance().GetDdtUrineAnalysisService().GetById(objectId);
refreshObject(urineAnalysis);
dateUrineAnalysis.Enabled = isEditable;
colorTxt.ReadOnly = !isEditable;
erythrocytesTxt.ReadOnly = !isEditable;
leukocytesTxt.ReadOnly = !isEditable;
proteinTxt.ReadOnly = !isEditable;
}
public object getObject()
{
DdtUrineAnalysis urine = DbDataService.GetInstance().GetDdtUrineAnalysisService().GetById(objectId);
if (urine == null)
{
urine = new DdtUrineAnalysis();
}
urine.AnalysisDate = dateUrineAnalysis.Value;
urine.Color = colorTxt.Text;
urine.Leukocytes = leukocytesTxt.Text;
urine.Erythrocytes = erythrocytesTxt.Text;
urine.Protein = proteinTxt.Text;
return(urine);
}
public void refreshObject(object obj)
{
if (obj != null && obj is DdtUrineAnalysis)
{
DdtUrineAnalysis urineAnalysis = (DdtUrineAnalysis)obj;
dateUrineAnalysis.Value = urineAnalysis.AnalysisDate;
colorTxt.Text = urineAnalysis.Color;
erythrocytesTxt.Text = urineAnalysis.Erythrocytes;
leukocytesTxt.Text = urineAnalysis.Leukocytes;
proteinTxt.Text = urineAnalysis.Protein;
regularAnalysisBox.Text = "Анализы за " + urineAnalysis.AnalysisDate.ToShortDateString();
objectId = urineAnalysis.ObjectId;
isNew = string.IsNullOrEmpty(urineAnalysis.ObjectId);
hasChanges = false;
}
}
public IList <DdtUrineAnalysis> GetByParentId(string parentId)
{
IList <DdtUrineAnalysis> list = new List <DdtUrineAnalysis>();
if (parentId == null)
{
return(list);
}
using (dynamic connection = connectionFactory.GetConnection())
{
String sql = String.Format("SELECT dss_ketones, ur.r_object_id, dsdt_analysis_date, dss_specific_gravity, dss_erythrocytes, r_creation_date, rel.dsid_parent, dsid_doctor, " +
"dsid_patient, dsid_hospitality_session, dss_acidity, r_modify_date, ur.dss_parent_type, dss_leukocytes, dsb_admission_analysis, dss_color, dsb_discharge_analysis, " +
"dss_protein, dss_glucose FROM ddt_urine_analysis ur, ddt_relation rel WHERE rel.dsid_parent = '{0}' AND rel.dsid_child=ur.r_object_id", parentId);
Logger.Debug(CultureInfo.CurrentCulture, "SQL: {0}", sql);
Npgsql.NpgsqlCommand command = new Npgsql.NpgsqlCommand(sql, connection);
using (DbDataReader reader = command.ExecuteReader())
{
if (reader.Read())
{
DdtUrineAnalysis obj = new DdtUrineAnalysis();
obj.Ketones = 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.SpecificGravity = reader.IsDBNull(3) ? null : reader.GetString(3);
obj.Erythrocytes = 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.Doctor = reader.IsDBNull(7) ? null : reader.GetString(7);
obj.Patient = reader.IsDBNull(8) ? null : reader.GetString(8);
obj.HospitalitySession = reader.IsDBNull(9) ? null : reader.GetString(9);
obj.Acidity = reader.IsDBNull(10) ? null : reader.GetString(10);
obj.ModifyDate = reader.IsDBNull(11) ? DateTime.MinValue : reader.GetDateTime(11);
obj.ParentType = reader.IsDBNull(12) ? null : reader.GetString(12);
obj.Leukocytes = reader.IsDBNull(13) ? null : reader.GetString(13);
obj.AdmissionAnalysis = reader.GetBoolean(14);
obj.Color = reader.IsDBNull(15) ? null : reader.GetString(15);
obj.DischargeAnalysis = reader.GetBoolean(16);
obj.Protein = reader.IsDBNull(17) ? null : reader.GetString(17);
obj.Glucose = reader.IsDBNull(18) ? null : reader.GetString(18);
list.Add(obj);
}
}
}
return(list);
}
public void saveObject(DdtHospital hospitalitySession, string parentId, string parentType)
{
if (isEditable && (isNew && getIsValid() || isDirty()))
{
DdtUrineAnalysis urine = (DdtUrineAnalysis)getObject();
urine.HospitalitySession = hospitalitySession.ObjectId;
urine.Doctor = hospitalitySession.CuringDoctor;
urine.Patient = hospitalitySession.Patient;
if (parentId != null)
{
urine.Parent = parentId;
}
if (parentType != null)
{
urine.ParentType = parentType;
}
objectId = DbDataService.GetInstance().GetDdtUrineAnalysisService().Save(urine);
hasChanges = false;
isNew = false;
}
}
public Analizi(DdtHospital hospitalitySession, DdtPatientAnalysis analysis)
{
this.hospitalitySession = hospitalitySession;
this.patientAnalysis = analysis;
InitializeComponent();
if (patientAnalysis != null)
{
DataService service = new DataService();
uziObj = service.queryObject <DdtUzi>(@"select * from " + DdtUzi.TABLE_NAME + " WHERE r_object_id ='" + patientAnalysis.DsisUzi + "'");
specialistConclusion = service.queryObject <DdtSpecialistConclusion>(@"select * from " + DdtSpecialistConclusion.TABLE_NAME + " WHERE r_object_id ='" + patientAnalysis.DsidSpecialistConclusion + "'");
holter = service.queryObject <DdtHolter>(@"select * from " + DdtHolter.TABLE_NAME + " WHERE r_object_id ='" + patientAnalysis.DsidHolter + "'");
xRay = service.queryObject <DdtXRay>(@"select * from " + DdtXRay.TABLE_NAME + " WHERE r_object_id ='" + patientAnalysis.DsidXray + "'");
urineAnalysis = service.queryObject <DdtUrineAnalysis>(@"select * from " + DdtUrineAnalysis.TABLE_NAME + " WHERE r_object_id ='" + patientAnalysis.DsisUrineAnalysis + "'");
initUziTab();
intSpecialistConslusionTab();
initHolterTab();
initXRay();
initUrineAnalysis();
}
}
private void saveUrineAnalysisTab(DataService service)
{
if (isNeedSaveTab(2))
{
if (urineAnalysis == null)
{
urineAnalysis = new DdtUrineAnalysis();
urineAnalysis.DsidHospitalitySession = hospitalitySession.ObjectId;
urineAnalysis.DsidDoctor = hospitalitySession.DsidCuringDoctor;
urineAnalysis.DsidPatient = hospitalitySession.DsidPatient;
}
urineAnalysis.DssAcidity = acidityTxt.Text;
urineAnalysis.DssColor = colorTxt.Text;
urineAnalysis.DssErythrocytes = erythrocytesTxt.Text;
urineAnalysis.DssGlucose = glucoseTxt.Text;
urineAnalysis.DssKetones = ketonesTxt.Text;
urineAnalysis.DssLeukocytes = leukocytesTxt.Text;
urineAnalysis.DssProtein = proteinTxt.Text;
urineAnalysis.DssSpecificGravity = specGravityTxt.Text;
string id = updateObject <DdtUrineAnalysis>(service, urineAnalysis, DdtUrineAnalysis.TABLE_NAME, urineAnalysis.ObjectId);
patientAnalysis.DsisUrineAnalysis = id;
}
}
public string Save(DdtUrineAnalysis obj)
{
using (dynamic connection = connectionFactory.GetConnection())
{
if (GetById(obj.ObjectId) != null)
{
string sql = "UPDATE ddt_urine_analysis SET " +
"dsid_hospitality_session = @HospitalitySession, " +
"dsid_patient = @Patient, " +
"dsid_doctor = @Doctor, " +
"dsdt_analysis_date = @AnalysisDate, " +
"dss_color = @Color, " +
"dss_acidity = @Acidity, " +
"dss_specific_gravity = @SpecificGravity, " +
"dss_leukocytes = @Leukocytes, " +
"dss_erythrocytes = @Erythrocytes, " +
"dss_glucose = @Glucose, " +
"dss_protein = @Protein, " +
"dss_ketones = @Ketones, " +
"dsb_admission_analysis = @AdmissionAnalysis, " +
"dsb_discharge_analysis = @DischargeAnalysis, " +
"dsid_parent = @Parent, " +
"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("@AnalysisDate", obj.AnalysisDate);
cmd.Parameters.AddWithValue("@Color", obj.Color == null ? "" : obj.Color);
cmd.Parameters.AddWithValue("@Acidity", obj.Acidity == null ? "" : obj.Acidity);
cmd.Parameters.AddWithValue("@SpecificGravity", obj.SpecificGravity == null ? "" : obj.SpecificGravity);
cmd.Parameters.AddWithValue("@Leukocytes", obj.Leukocytes == null ? "" : obj.Leukocytes);
cmd.Parameters.AddWithValue("@Erythrocytes", obj.Erythrocytes == null ? "" : obj.Erythrocytes);
cmd.Parameters.AddWithValue("@Glucose", obj.Glucose == null ? "" : obj.Glucose);
cmd.Parameters.AddWithValue("@Protein", obj.Protein == null ? "" : obj.Protein);
cmd.Parameters.AddWithValue("@Ketones", obj.Ketones == null ? "" : obj.Ketones);
cmd.Parameters.AddWithValue("@AdmissionAnalysis", obj.AdmissionAnalysis);
cmd.Parameters.AddWithValue("@DischargeAnalysis", obj.DischargeAnalysis);
cmd.Parameters.AddWithValue("@Parent", obj.Parent == null ? "0000000000000000" : obj.Parent);
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_urine_analysis(dsid_hospitality_session,dsid_patient,dsid_doctor,dsdt_analysis_date,dss_color,dss_acidity,dss_specific_gravity,dss_leukocytes,dss_erythrocytes,dss_glucose,dss_protein,dss_ketones,dsb_admission_analysis,dsb_discharge_analysis,dsid_parent,dss_parent_type) " +
"VALUES(@HospitalitySession,@Patient,@Doctor,@AnalysisDate,@Color,@Acidity,@SpecificGravity,@Leukocytes,@Erythrocytes,@Glucose,@Protein,@Ketones,@AdmissionAnalysis,@DischargeAnalysis,@Parent,@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("@AnalysisDate", obj.AnalysisDate);
cmd.Parameters.AddWithValue("@Color", obj.Color == null ? "" : obj.Color);
cmd.Parameters.AddWithValue("@Acidity", obj.Acidity == null ? "" : obj.Acidity);
cmd.Parameters.AddWithValue("@SpecificGravity", obj.SpecificGravity == null ? "" : obj.SpecificGravity);
cmd.Parameters.AddWithValue("@Leukocytes", obj.Leukocytes == null ? "" : obj.Leukocytes);
cmd.Parameters.AddWithValue("@Erythrocytes", obj.Erythrocytes == null ? "" : obj.Erythrocytes);
cmd.Parameters.AddWithValue("@Glucose", obj.Glucose == null ? "" : obj.Glucose);
cmd.Parameters.AddWithValue("@Protein", obj.Protein == null ? "" : obj.Protein);
cmd.Parameters.AddWithValue("@Ketones", obj.Ketones == null ? "" : obj.Ketones);
cmd.Parameters.AddWithValue("@AdmissionAnalysis", obj.AdmissionAnalysis);
cmd.Parameters.AddWithValue("@DischargeAnalysis", obj.DischargeAnalysis);
cmd.Parameters.AddWithValue("@Parent", obj.Parent == null ? "0000000000000000" : obj.Parent);
cmd.Parameters.AddWithValue("@ParentType", obj.ParentType == null ? "" : obj.ParentType);
return((string)cmd.ExecuteScalar());
}
}
}
}
