public IList <DdtConsilium> GetAll()
{
IList <DdtConsilium> list = new List <DdtConsilium>();
using (dynamic connection = connectionFactory.GetConnection())
{
String sql = "SELECT dsid_hospitality_session, r_object_id, dss_goal, dss_dynamics, r_modify_date, dss_duty_admin_name, dss_diagnosis, r_creation_date, dsdt_consilium_date, dss_decision, dsid_doctor, dsid_patient FROM ddt_consilium";
Logger.Debug(CultureInfo.CurrentCulture, "SQL: {0}", sql);
Npgsql.NpgsqlCommand command = new Npgsql.NpgsqlCommand(sql, connection);
using (DbDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
DdtConsilium obj = new DdtConsilium();
obj.HospitalitySession = reader.IsDBNull(0) ? null : reader.GetString(0);
obj.ObjectId = reader.IsDBNull(1) ? null : reader.GetString(1);
obj.Goal = reader.IsDBNull(2) ? null : reader.GetString(2);
obj.Dynamics = reader.IsDBNull(3) ? null : reader.GetString(3);
obj.ModifyDate = reader.IsDBNull(4) ? DateTime.MinValue : reader.GetDateTime(4);
obj.DutyAdminName = reader.IsDBNull(5) ? null : reader.GetString(5);
obj.Diagnosis = reader.IsDBNull(6) ? null : reader.GetString(6);
obj.CreationDate = reader.IsDBNull(7) ? DateTime.MinValue : reader.GetDateTime(7);
obj.ConsiliumDate = reader.IsDBNull(8) ? DateTime.MinValue : reader.GetDateTime(8);
obj.Decision = reader.IsDBNull(9) ? null : reader.GetString(9);
obj.Doctor = reader.IsDBNull(10) ? null : reader.GetString(10);
obj.Patient = reader.IsDBNull(11) ? null : reader.GetString(11);
list.Add(obj);
}
}
}
return(list);
}
public string Save(DdtConsilium obj)
{
using (dynamic connection = connectionFactory.GetConnection())
{
if (GetById(obj.ObjectId) != null)
{
string sql = "UPDATE ddt_consilium SET " +
"dsid_hospitality_session = @HospitalitySession, " +
"dsid_patient = @Patient, " +
"dsid_doctor = @Doctor, " +
"dsdt_consilium_date = @ConsiliumDate, " +
"dss_goal = @Goal, " +
"dss_dynamics = @Dynamics, " +
"dss_diagnosis = @Diagnosis, " +
"dss_decision = @Decision, " +
"dss_duty_admin_name = @DutyAdminName " +
"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("@ConsiliumDate", obj.ConsiliumDate);
cmd.Parameters.AddWithValue("@Goal", obj.Goal == null ? "" : obj.Goal);
cmd.Parameters.AddWithValue("@Dynamics", obj.Dynamics == null ? "" : obj.Dynamics);
cmd.Parameters.AddWithValue("@Diagnosis", obj.Diagnosis == null ? "" : obj.Diagnosis);
cmd.Parameters.AddWithValue("@Decision", obj.Decision == null ? "" : obj.Decision);
cmd.Parameters.AddWithValue("@DutyAdminName", obj.DutyAdminName == null ? "" : obj.DutyAdminName);
cmd.Parameters.AddWithValue("@ObjectId", obj.ObjectId);
cmd.ExecuteNonQuery();
}
return(obj.ObjectId);
}
else
{
string sql = "INSERT INTO ddt_consilium(dsid_hospitality_session,dsid_patient,dsid_doctor,dsdt_consilium_date,dss_goal,dss_dynamics,dss_diagnosis,dss_decision,dss_duty_admin_name) " +
"VALUES(@HospitalitySession,@Patient,@Doctor,@ConsiliumDate,@Goal,@Dynamics,@Diagnosis,@Decision,@DutyAdminName) 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("@ConsiliumDate", obj.ConsiliumDate);
cmd.Parameters.AddWithValue("@Goal", obj.Goal == null ? "" : obj.Goal);
cmd.Parameters.AddWithValue("@Dynamics", obj.Dynamics == null ? "" : obj.Dynamics);
cmd.Parameters.AddWithValue("@Diagnosis", obj.Diagnosis == null ? "" : obj.Diagnosis);
cmd.Parameters.AddWithValue("@Decision", obj.Decision == null ? "" : obj.Decision);
cmd.Parameters.AddWithValue("@DutyAdminName", obj.DutyAdminName == null ? "" : obj.DutyAdminName);
return((string)cmd.ExecuteScalar());
}
}
}
}
public DdtConsilium GetById(string id)
{
using (dynamic connection = connectionFactory.GetConnection())
{
String sql = String.Format("SELECT " +
"dsid_hospitality_session, " +
"r_object_id, " +
"dss_goal, " +
"dss_dynamics, " +
"r_modify_date, " +
"dss_duty_admin_name, " +
"dss_diagnosis, " +
"r_creation_date, " +
"dsdt_consilium_date, " +
"dss_decision, " +
"dsid_doctor, " +
"dsid_patient " +
"FROM ddt_consilium 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())
{
DdtConsilium obj = new DdtConsilium();
obj.HospitalitySession = reader.IsDBNull(0) ? null : reader.GetString(0);
obj.ObjectId = reader.IsDBNull(1) ? null : reader.GetString(1);
obj.Goal = reader.IsDBNull(2) ? null : reader.GetString(2);
obj.Dynamics = reader.IsDBNull(3) ? null : reader.GetString(3);
obj.ModifyDate = reader.IsDBNull(4) ? DateTime.MinValue : reader.GetDateTime(4);
obj.DutyAdminName = reader.IsDBNull(5) ? null : reader.GetString(5);
obj.Diagnosis = reader.IsDBNull(6) ? null : reader.GetString(6);
obj.CreationDate = reader.IsDBNull(7) ? DateTime.MinValue : reader.GetDateTime(7);
obj.ConsiliumDate = reader.IsDBNull(8) ? DateTime.MinValue : reader.GetDateTime(8);
obj.Decision = reader.IsDBNull(9) ? null : reader.GetString(9);
obj.Doctor = reader.IsDBNull(10) ? null : reader.GetString(10);
obj.Patient = reader.IsDBNull(11) ? null : reader.GetString(11);
return(obj);
}
}
}
return(null);
}
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>();
}
DdtConsilium obj = service.GetDdtConsiliumService().GetById(objectId);
values.Add(@"{consilium.date}", DateTime.Now.ToString("dd.MM.yyyy"));
values.Add(@"{consilium.time}", DateTime.Now.ToString("HH:mm"));
values.Add(@"{consilium.members}", GetMembersInString(service, objectId));
values.Add(@"{admin}", obj?.DutyAdminName);
values.Add(@"{doctor.who}", GetDoctorInString(service, obj.Doctor));
values.Add(@"{consilium.goal}", obj.Goal);
DdvPatient patient = service.GetDdvPatientService().GetById(obj.Patient);
values.Add(@"{patient.initials}", patient.ShortName);
values.Add(@"{patient.age}", (DateTime.Now.Year - patient.Birthdate.Year) + "");
values.Add(@"{patient.diagnosis}", obj.Diagnosis);
values.Add(@"{consilium.decision}", obj.Decision);
values.Add(@"{journal}", obj.Dynamics);
PutAnalysisData(values, service, obj.ObjectId);
if (values.ContainsKey("{on_ekg}"))
{
values.Remove("{on_ekg}");
}
if (values.ContainsKey("{on_blood}"))
{
values.Remove("{on_blood}");
}
values.Add("{on_ekg}", "ЭКГ в ОКР:");
values.Add("{on_blood}", "В анализах крови: ");
return(TemplatesUtils.FillTemplate(Directory.GetCurrentDirectory() + "\\Templates\\" + TemplateFileName, values, TemplatesUtils.getTempFileName("Консилиум", patient.FullName)));
}
private void InitControls()
{
curingDoc = service.GetDdvDoctorService().GetById(hospitalitySession?.CuringDoctor);
ControlUtils.InitDoctorsByGroupName(service.GetDdvDoctorService(), adminTxt, "duty_administrators");
DdvPatient patient = service.GetDdvPatientService().GetById(hospitalitySession.Patient);
if (patient != null)
{
Text += " " + patient.ShortName;
}
diagnosisTxt0.Text = hospitalitySession.Diagnosis;
if (!string.IsNullOrEmpty(consiliumId))
{
DdtConsilium consilium = service.GetDdtConsiliumService().GetById(consiliumId);
if (consilium != null)
{
goalTxt.Text = consilium.Goal;
dynamicsTxt.Text = consilium.Dynamics;
adminTxt.SelectedIndex = adminTxt.FindStringExact(consilium.DutyAdminName);
diagnosisTxt0.Text = consilium.Diagnosis;
decisionTxt.Text = consilium.Decision;
IList <DdtConsiliumRelation> consiliumRelations = service.GetDdtConsiliumRelationService().GetConsiliumRelationsByConsiliumId(consilium.ObjectId);
InitMembersByRelations(service, consiliumRelations);
}
}
else
{
DdtAnamnesis anamnesis = service.GetDdtAnamnesisService().GetByHospitalSessionId(hospitalitySession.ObjectId);
if (anamnesis != null)
{
diagnosisTxt0.Text = anamnesis.Diagnosis;
}
IList <DdtConsiliumGroupMember> defaultGroupMembers = service.GetDdtConsiliumGroupMemberService().GetDefault();
InitDefaultMembers(service, defaultGroupMembers);
}
}
public bool Save()
{
if (!getIsValid())
{
return(false);
}
hospitalitySession.Diagnosis = getSafeStringValue(diagnosisTxt1);
service.GetDdtHospitalService().Save(hospitalitySession);
DdtConsilium consilium = null;
if (!string.IsNullOrEmpty(consiliumId))
{
consilium = service.GetDdtConsiliumService().GetById(consiliumId);
}
else
{
consilium = new DdtConsilium
{
ConsiliumDate = DateTime.Now,
HospitalitySession = hospitalitySession.ObjectId,
Patient = hospitalitySession.Patient,
Doctor = hospitalitySession.CuringDoctor
};
}
consilium.Decision = getSafeStringValue(decisionTxt);
consilium.Diagnosis = getSafeStringValue(diagnosisTxt0);
consilium.DutyAdminName = getSafeStringValue(adminTxt);
consilium.Dynamics = getSafeStringValue(dynamicsTxt);
consilium.Goal = getSafeStringValue(goalTxt);
consiliumId = service.GetDdtConsiliumService().Save(consilium);
foreach (Control doctorInfoPnl in doctorsContainer.Controls)
{
DdtConsiliumRelation consiliumRelation = null;
String doctorInfoPnlName = getSafeObjectValueUni <string>(doctorInfoPnl, new getValue <string>((ctrl) => (ctrl.Name)));
string indexstr = string.Intern(doctorInfoPnlName.Substring(CommonUtils.GetFirstDigitIndex(doctorInfoPnlName)));
int indx = Int32.Parse(indexstr);
Control objectIdCtrl = CommonUtils.FindControl(doctorsContainer, "objectIdLbl" + indx);
if (!string.IsNullOrEmpty(objectIdCtrl.Text))
{
consiliumRelation = service.GetDdtConsiliumRelationService().GetById(objectIdCtrl.Text);
}
else
{
consiliumRelation = new DdtConsiliumRelation();
consiliumRelation.Consilium = consiliumId;
}
Control appCb = CommonUtils.FindControl(doctorsContainer, "appointmentTxt" + indx);
DdtConsiliumGroup group = getSafeObjectValueUni <DdtConsiliumGroup>(appCb, (ctrl) => ((DdtConsiliumGroup)((ComboBox)ctrl).SelectedItem));
Control docCb = CommonUtils.FindControl(doctorsContainer, "doctorWho" + indx);
DdvDoctor doctor = getSafeObjectValueUni <DdvDoctor>(docCb, (ctrl) => ((DdvDoctor)((ComboBox)ctrl).SelectedItem));
if (group != null && doctor != null)
{
DdtConsiliumGroupMember consiliumGroupMember = service.GetDdtConsiliumGroupMemberService().GetByDoctorAndGroupId(doctor.ObjectId, group.ObjectId);
consiliumRelation.Member = consiliumGroupMember.ObjectId;
service.GetDdtConsiliumRelationService().Save(consiliumRelation);
}
}
foreach (String consiliumRelationId in consiliumRelationToRemove)
{
service.Delete(DdtConsiliumRelation.NAME, consiliumRelationId);
}
analysisTabControl1.save(consiliumId, DdtConsilium.NAME); SetConsiliumIdToTransfusion(); return(true);
}
