public List <DdtUzi> GetByQuery(string sql)
{
List <DdtUzi> list = new List <DdtUzi>();
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())
{
DdtUzi obj = new DdtUzi();
obj.ObjectId = reader.IsDBNull(0) ? null : reader.GetString(0);
obj.AnalysisDate = reader.IsDBNull(1) ? DateTime.MinValue : reader.GetDateTime(1);
obj.EhoKg = reader.IsDBNull(2) ? null : reader.GetString(2);
obj.CreationDate = reader.IsDBNull(3) ? DateTime.MinValue : reader.GetDateTime(3);
obj.PleursUzi = reader.IsDBNull(4) ? null : reader.GetString(4);
obj.Parent = reader.IsDBNull(5) ? null : reader.GetString(5);
obj.Doctor = reader.IsDBNull(6) ? null : reader.GetString(6);
obj.Patient = reader.IsDBNull(7) ? null : reader.GetString(7);
obj.HospitalitySession = reader.IsDBNull(8) ? null : reader.GetString(8);
obj.UzdBca = reader.IsDBNull(9) ? null : reader.GetString(9);
obj.ModifyDate = reader.IsDBNull(10) ? DateTime.MinValue : reader.GetDateTime(10);
obj.ParentType = reader.IsDBNull(11) ? null : reader.GetString(11);
obj.Cds = reader.IsDBNull(12) ? null : reader.GetString(12);
obj.UziObp = reader.IsDBNull(13) ? null : reader.GetString(13);
list.Add(obj);
}
}
}
return(list);
}
public DdtUzi GetById(string id)
{
using (dynamic connection = connectionFactory.GetConnection())
{
String sql = String.Format("SELECT r_object_id, dsdt_analysis_date, dss_eho_kg, r_creation_date, dss_pleurs_uzi, dsid_parent, dsid_doctor, " +
"dsid_patient, dsid_hospitality_session, dss_uzd_bca, r_modify_date, dss_parent_type, dss_cds, dss_uzi_obp FROM ddt_uzi " +
"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())
{
DdtUzi obj = new DdtUzi();
obj.ObjectId = reader.IsDBNull(0) ? null : reader.GetString(0);
obj.AnalysisDate = reader.IsDBNull(1) ? DateTime.MinValue : reader.GetDateTime(1);
obj.EhoKg = reader.IsDBNull(2) ? null : reader.GetString(2);
obj.CreationDate = reader.IsDBNull(3) ? DateTime.MinValue : reader.GetDateTime(3);
obj.PleursUzi = reader.IsDBNull(4) ? null : reader.GetString(4);
obj.Parent = reader.IsDBNull(5) ? null : reader.GetString(5);
obj.Doctor = reader.IsDBNull(6) ? null : reader.GetString(6);
obj.Patient = reader.IsDBNull(7) ? null : reader.GetString(7);
obj.HospitalitySession = reader.IsDBNull(8) ? null : reader.GetString(8);
obj.UzdBca = reader.IsDBNull(9) ? null : reader.GetString(9);
obj.ModifyDate = reader.IsDBNull(10) ? DateTime.MinValue : reader.GetDateTime(10);
obj.ParentType = reader.IsDBNull(11) ? null : reader.GetString(11);
obj.Cds = reader.IsDBNull(12) ? null : reader.GetString(12);
obj.UziObp = reader.IsDBNull(13) ? null : reader.GetString(13);
return(obj);
}
}
}
return(null);
}
private void initControls()
{
DdtUzi uzi = DbDataService.GetInstance().GetDdtUziService().GetById(objectId);
refreshObject(uzi);
ehoKgTxt.Enabled = isEditable;
uzdTxt.Enabled = isEditable;
cdsTxt.Enabled = isEditable;
uziObpTxt.Enabled = isEditable;
pleursUziTxt.Enabled = isEditable;
analysisDate.Enabled = isEditable;
}
public object getObject()
{
DdtUzi uziObj = DbDataService.GetInstance().GetDdtUziService().GetById(objectId);
if (uziObj == null)
{
uziObj = new DdtUzi();
}
uziObj.AnalysisDate = analysisDate.Value;
uziObj.EhoKg = ehoKgTxt.Text;
uziObj.UzdBca = uzdTxt.Text;
uziObj.Cds = cdsTxt.Text;
uziObj.UziObp = uziObpTxt.Text;
uziObj.PleursUzi = pleursUziTxt.Text;
return(uziObj);
}
public void refreshObject(object obj)
{
if (obj != null && obj is DdtUzi)
{
DdtUzi uzi = (DdtUzi)obj;
ehoKgTxt.Text = uzi.EhoKg;
uzdTxt.Text = uzi.UzdBca;
cdsTxt.Text = uzi.Cds;
uziObpTxt.Text = uzi.UziObp;
pleursUziTxt.Text = uzi.PleursUzi;
title.Text = "УЗИ за " + uzi.AnalysisDate.ToShortDateString();
analysisDate.Value = uzi.AnalysisDate;
objectId = uzi.ObjectId;
isNew = string.IsNullOrEmpty(objectId);
hasChanges = false;
}
}
public IList <DdtUzi> GetByParentId(string parentId)
{
IList <DdtUzi> list = new List <DdtUzi>();
if (parentId == null)
{
return(list);
}
using (dynamic connection = connectionFactory.GetConnection())
{
String sql = String.Format("SELECT uz.r_object_id, dsdt_analysis_date, dss_eho_kg, r_creation_date, " +
"dss_pleurs_uzi, rel.dsid_parent, dsid_doctor, dsid_patient, dsid_hospitality_session, dss_uzd_bca, " +
"r_modify_date, uz.dss_parent_type, dss_cds, dss_uzi_obp FROM ddt_uzi uz, ddt_relation rel " +
"WHERE rel.dsid_parent = '{0}' AND rel.dsid_child=uz.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())
{
DdtUzi obj = new DdtUzi();
obj.ObjectId = reader.IsDBNull(0) ? null : reader.GetString(0);
obj.AnalysisDate = reader.IsDBNull(1) ? DateTime.MinValue : reader.GetDateTime(1);
obj.EhoKg = reader.IsDBNull(2) ? null : reader.GetString(2);
obj.CreationDate = reader.IsDBNull(3) ? DateTime.MinValue : reader.GetDateTime(3);
obj.PleursUzi = reader.IsDBNull(4) ? null : reader.GetString(4);
obj.Parent = reader.IsDBNull(5) ? null : reader.GetString(5);
obj.Doctor = reader.IsDBNull(6) ? null : reader.GetString(6);
obj.Patient = reader.IsDBNull(7) ? null : reader.GetString(7);
obj.HospitalitySession = reader.IsDBNull(8) ? null : reader.GetString(8);
obj.UzdBca = reader.IsDBNull(9) ? null : reader.GetString(9);
obj.ModifyDate = reader.IsDBNull(10) ? DateTime.MinValue : reader.GetDateTime(10);
obj.ParentType = reader.IsDBNull(11) ? null : reader.GetString(11);
obj.Cds = reader.IsDBNull(12) ? null : reader.GetString(12);
obj.UziObp = reader.IsDBNull(13) ? null : reader.GetString(13);
list.Add(obj);
}
}
}
return(list);
}
private void saveUziTab(DataService service)
{
if (isNeedSaveTab(3))
{
if (uziObj == null)
{
uziObj = new DdtUzi();
uziObj.DsidHospitalitySession = hospitalitySession.ObjectId;
uziObj.DsidDoctor = hospitalitySession.DsidCuringDoctor;
uziObj.DsidPatient = hospitalitySession.DsidPatient;
}
uziObj.DssCds = cdsTxt.Text;
uziObj.DssEhoKg = ehoKgTxt.Text;
uziObj.DssPleursUzi = pleursUziTxt.Text;
uziObj.DssUzdBca = uzdTxt.Text;
uziObj.DssUziObp = uziObpTxt.Text;
string id = updateObject <DdtUzi>(service, uziObj, DdtUzi.TABLE_NAME, uziObj.ObjectId);
patientAnalysis.DsisUzi = id;
}
}
public void saveObject(DdtHospital hospitalitySession, string parentId, string parentType)
{
if (isEditable && (isNew && getIsValid() || isDirty()))
{
DdtUzi uziObj = (DdtUzi)getObject();
uziObj.HospitalitySession = hospitalitySession.ObjectId;
uziObj.Doctor = hospitalitySession.CuringDoctor;
uziObj.Patient = hospitalitySession.Patient;
if (parentId != null)
{
uziObj.Parent = parentId;
}
if (parentType != null)
{
uziObj.ParentType = parentType;
}
objectId = DbDataService.GetInstance().GetDdtUziService().Save(uziObj);
isNew = false;
hasChanges = 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();
}
}
public string Save(DdtUzi obj)
{
using (dynamic connection = connectionFactory.GetConnection())
{
if (GetById(obj.ObjectId) != null)
{
string sql = "UPDATE ddt_uzi SET " +
"dsid_hospitality_session = @HospitalitySession, " +
"dsid_patient = @Patient, " +
"dsid_doctor = @Doctor, " +
"dsdt_analysis_date = @AnalysisDate, " +
"dss_eho_kg = @EhoKg, " +
"dss_uzd_bca = @UzdBca, " +
"dss_cds = @Cds, " +
"dss_uzi_obp = @UziObp, " +
"dss_pleurs_uzi = @PleursUzi, " +
"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("@EhoKg", obj.EhoKg == null ? "" : obj.EhoKg);
cmd.Parameters.AddWithValue("@UzdBca", obj.UzdBca == null ? "" : obj.UzdBca);
cmd.Parameters.AddWithValue("@Cds", obj.Cds == null ? "" : obj.Cds);
cmd.Parameters.AddWithValue("@UziObp", obj.UziObp == null ? "" : obj.UziObp);
cmd.Parameters.AddWithValue("@PleursUzi", obj.PleursUzi == null ? "" : obj.PleursUzi);
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_uzi(dsid_hospitality_session,dsid_patient,dsid_doctor,dsdt_analysis_date,dss_eho_kg,dss_uzd_bca,dss_cds,dss_uzi_obp,dss_pleurs_uzi,dsid_parent,dss_parent_type) " +
"VALUES(@HospitalitySession,@Patient,@Doctor,@AnalysisDate,@EhoKg,@UzdBca,@Cds,@UziObp,@PleursUzi,@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("@EhoKg", obj.EhoKg == null ? "" : obj.EhoKg);
cmd.Parameters.AddWithValue("@UzdBca", obj.UzdBca == null ? "" : obj.UzdBca);
cmd.Parameters.AddWithValue("@Cds", obj.Cds == null ? "" : obj.Cds);
cmd.Parameters.AddWithValue("@UziObp", obj.UziObp == null ? "" : obj.UziObp);
cmd.Parameters.AddWithValue("@PleursUzi", obj.PleursUzi == null ? "" : obj.PleursUzi);
cmd.Parameters.AddWithValue("@Parent", obj.Parent == null ? "0000000000000000" : obj.Parent);
cmd.Parameters.AddWithValue("@ParentType", obj.ParentType == null ? "" : obj.ParentType);
return((string)cmd.ExecuteScalar());
}
}
}
}
