public IList <DdtIssuedMedicine> GetAll()
{
IList <DdtIssuedMedicine> list = new List <DdtIssuedMedicine>();
using (dynamic connection = connectionFactory.GetConnection())
{
String sql = "SELECT dsid_med_list, r_object_id, dsid_cure, r_modify_date, r_creation_date FROM ddt_issued_medicine";
Logger.Debug(CultureInfo.CurrentCulture, "SQL: {0}", sql);
Npgsql.NpgsqlCommand command = new Npgsql.NpgsqlCommand(sql, connection);
using (DbDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
DdtIssuedMedicine obj = new DdtIssuedMedicine();
obj.MedList = reader.IsDBNull(0) ? null : reader.GetString(0);
obj.ObjectId = reader.IsDBNull(1) ? null : reader.GetString(1);
obj.Cure = reader.IsDBNull(2) ? null : reader.GetString(2);
obj.ModifyDate = reader.IsDBNull(3) ? DateTime.MinValue : reader.GetDateTime(3);
obj.CreationDate = reader.IsDBNull(4) ? DateTime.MinValue : reader.GetDateTime(4);
list.Add(obj);
}
}
}
return(list);
}
public DdtIssuedMedicine GetById(string id)
{
using (dynamic connection = connectionFactory.GetConnection())
{
String sql = String.Format("SELECT dsid_med_list, r_object_id, dsid_cure, r_modify_date, r_creation_date FROM ddt_issued_medicine 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())
{
DdtIssuedMedicine obj = new DdtIssuedMedicine();
obj.MedList = reader.IsDBNull(0) ? null : reader.GetString(0);
obj.ObjectId = reader.IsDBNull(1) ? null : reader.GetString(1);
obj.Cure = reader.IsDBNull(2) ? null : reader.GetString(2);
obj.ModifyDate = reader.IsDBNull(3) ? DateTime.MinValue : reader.GetDateTime(3);
obj.CreationDate = reader.IsDBNull(4) ? DateTime.MinValue : reader.GetDateTime(4);
return(obj);
}
}
}
return(null);
}
private void UpdateIssuedMedicineListFromTemplate(string template)
{
IList <DdtCure> medicineTemplates = service.GetDdtCureService().GetListByTemplate(template);
if (patient != null && patient.Sd)
{
IList <DdtCure> sdMedTemplate = service.GetDdtCureService().GetListByTemplate("sd");
foreach (DdtCure cur in sdMedTemplate)
{
medicineTemplates.Add(cur);
}
foreach (DdtCure cur in medicineTemplates)
{
if (cur.Name.Equals("Стол ОВД", StringComparison.Ordinal))
{
medicineTemplates.Remove(cur);
break;
}
}
}
medicineList.Clear();
layout.Controls.Clear();
foreach (DdtCure cure in medicineTemplates)
{
DdtIssuedMedicine med = new DdtIssuedMedicine();
med.Cure = cure.ObjectId;
AddIssuedMedicine(med, cure);
}
}
private void UpdateMedicineFromTemplate(string template)
{
List <DdtCure> medicineTemplates = service.GetDdtCureService().GetByQuery(@"Select cure.* from ddt_values vv, ddt_cure cure
where vv.dss_name like '" + template + "%' AND vv.dss_value=cure.dss_name");
foreach (DdtCure cure in medicineTemplates)
{
DdtIssuedMedicine med = new DdtIssuedMedicine
{
Cure = cure.ObjectId
};
AddIssuedMedicine(med, cure);
}
}
private void copyFirstMedicineBtn_Click(object sender, EventArgs e)
{
DdtIssuedMedicineList medList = service.GetDdtIssuedMedicineListService().GetListByHospitalIdAndParentType(DdtAnamnesis.NAME, hospitalitySession.ObjectId);
if (medList != null)
{
IList <DdtCure> cures = service.GetDdtCureService().GetListByMedicineListId(medList.ObjectId);
foreach (DdtCure cure in cures)
{
DdtIssuedMedicine med = new DdtIssuedMedicine
{
Cure = cure.ObjectId
};
AddIssuedMedicine(med, cure);
}
}
}
private void copyJournalMedBtn_Click(object sender, EventArgs e)
{
String medListId = service.GetString(@"SELECT medlist.* FROM ddt_issued_medicine_list medlist, ddt_inspection ins WHERE ins.dsid_hospitality_session='" +
hospitalitySession.ObjectId + "' AND medlist.dsid_parent_id=ins.r_object_id ORDER BY dsdt_inspection_date DESC");
if (!string.IsNullOrEmpty(medListId))
{
IList <DdtCure> cures = service.GetDdtCureService().GetListByMedicineListId(medListId);
foreach (DdtCure cure in cures)
{
DdtIssuedMedicine med = new DdtIssuedMedicine
{
Cure = cure.ObjectId
};
AddIssuedMedicine(med, cure);
}
}
}
private void copyYesterdayMedBtn_Click(object sender, EventArgs e)
{
String medListId = service.GetString(@"SELECT * FROM ddt_issued_medicine_list WHERE dsid_hospitality_session='" +
hospitalitySession.ObjectId + "' ORDER BY dsdt_issuing_date DESC");
if (!string.IsNullOrEmpty(medListId))
{
List <DdtCure> cures = service.GetDdtCureService().GetByQuery(@"SELECT cures.* FROM " + DdtCure.NAME + " cures, " + DdtIssuedMedicine.NAME +
" meds WHERE meds.dsid_med_list='" + medListId + "' AND meds.dsid_cure=cures.r_object_id");
foreach (DdtCure cure in cures)
{
DdtIssuedMedicine med = new DdtIssuedMedicine
{
Cure = cure.ObjectId
};
AddIssuedMedicine(med, cure);
}
}
}
public string Save(DdtIssuedMedicine obj)
{
using (dynamic connection = connectionFactory.GetConnection())
{
if (GetById(obj.ObjectId) != null)
{
string sql = "UPDATE ddt_issued_medicine SET " +
"dsid_med_list = @MedList, " +
"dsid_cure = @Cure " +
"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("@MedList", obj.MedList);
cmd.Parameters.AddWithValue("@Cure", obj.Cure);
cmd.Parameters.AddWithValue("@ObjectId", obj.ObjectId);
cmd.ExecuteNonQuery();
}
return(obj.ObjectId);
}
else
{
string sql = "INSERT INTO ddt_issued_medicine(dsid_med_list,dsid_cure) " +
"VALUES(@MedList,@Cure) 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("@MedList", obj.MedList);
cmd.Parameters.AddWithValue("@Cure", obj.Cure);
obj.ObjectId = (string)cmd.ExecuteScalar();
return(obj.ObjectId);
}
}
}
}
private void InitPatientInfo()
{
patient = service.GetDdvPatientService().GetById(hospitalSession.Patient);
if (patient != null)
{
patientInitialsLbl.Text = patient.ShortName;
if (anamnesis == null)
{
if (patient.Sd)
{
IList <DdtCure> medicineTemplates = service.GetDdtCureService().GetListByTemplate("sd");
foreach (DdtCure cure in medicineTemplates)
{
DdtIssuedMedicine med = new DdtIssuedMedicine();
med.Cure = cure.ObjectId;
AddIssuedMedicine(med, cure);
}
}
}
}
}
private void AddIssuedMedicine_Click(object sender, EventArgs e)
{
DdtIssuedMedicine med = new DdtIssuedMedicine();
AddIssuedMedicine(med, null);
}
private void AddIssuedMedicine(DdtIssuedMedicine med, DdtCure cure)
{
medicineList.Add(med);
FlowLayoutPanel ll = new FlowLayoutPanel();
ll.FlowDirection = FlowDirection.LeftToRight;
ll.Width = 700;
ll.AutoSize = true;
ll.Padding = new Padding(0);
ll.Margin = new Padding(0);
ComboBox cureTypeControl = new ComboBox();
cureTypeControl.Width = 250;
CommonUtils.InitCureTypeComboboxValues(DbDataService.GetInstance(), cureTypeControl);
if (cure != null && cure.CureType != null)
{
for (int index = 0; index < cureTypeControl.Items.Count; index++)
{
DdtCureType ct = (DdtCureType)cureTypeControl.Items[index];
if (ct.ObjectId == cure.CureType)
{
cureTypeControl.SelectedIndex = index;
break;
}
}
}
ll.Controls.Add(cureTypeControl);
ComboBox cureControl = new ComboBox();
cureControl.Width = 350;
DdtCureType cureType = (DdtCureType)cureTypeControl.SelectedItem;
if (cureType != null)
{
CommonUtils.InitCureComboboxValuesByTypeId(DbDataService.GetInstance(), cureControl, cureType.ObjectId);
}
if (cure != null && cure.ObjectId != null)
{
for (int index = 0; index < cureControl.Items.Count; index++)
{
DdtCure c = (DdtCure)cureControl.Items[index];
if (c.ObjectId == cure.ObjectId)
{
cureControl.SelectedIndex = index;
break;
}
}
}
cureControl.SelectedIndexChanged += delegate(object sender2, EventArgs args)
{
DdtCure ddtCure = (DdtCure)cureControl.SelectedItem;
if (ddtCure != null)
{
med.Cure = ddtCure.ObjectId;
}
else
{
med.Cure = null;
}
};
ll.Controls.Add(cureControl);
cureTypeControl.SelectedIndexChanged += delegate(object sender2, EventArgs args)
{
DdtCureType selectedVal = (DdtCureType)cureTypeControl.SelectedItem;
CommonUtils.InitCureComboboxValuesByTypeId(DbDataService.GetInstance(), cureControl, selectedVal.ObjectId);
};
Button remove = new Button
{
Image = Properties.Resources.remove,
Size = new Size(25, 25),
UseVisualStyleBackColor = true
};
ll.Controls.Add(remove);
remove.Click += delegate(object sender2, EventArgs args)
{
medicineList.Remove(med);
layout.Controls.Remove(ll);
};
layout.Controls.Add(ll);
}