public static void UpdateHospitalization(HttpClient httpClient, Hospitalization hosp)
{
// Add disease, and set custom field for the patient.
// Fields that should not be updated, must be nullified.
// If you want to reset some text fields then pass empty string ""
hosp.diseases.Add("diarrhea");
hosp.color = "#d3b2f1";
hosp.patient.species = null; // species will not be updated
hosp.patient.owner = null; // owner will not be updated
hosp.patient.customField = "CS 123"; // new value for customField
hosp.patient.color = ""; // reset color
var url = serverUrl + "/hospitalization";
Console.WriteLine("Making web request to " + url);
var result = httpClient.PutAsJsonAsync <Hospitalization>(url, hosp).Result;
// Output result
Console.WriteLine("Http result code: {0}", result.StatusCode);
Console.WriteLine("Http content:");
Console.WriteLine(result.Content.ReadAsStringAsync().Result);
Console.WriteLine("\n\nPress any key to continue...");
Console.ReadKey();
}
public void Edit(Hospitalization entity)
{
if (AuthorizedUsers["Edit"].SingleOrDefault(x => x == Role) != null)
{
HospitalizationController.Edit(entity);
}
}
//病床编号->病例ID(hospitalization)->病人ID(case)->病人信息
public static Patient GetpInfo_bybed(string sid)
{
OdbcConnection odbcConnection = DB.DBManager.GetOdbcConnection();
odbcConnection.Open();
string sql = "select * from hospitalization where S_ID='" + sid + "'";
OdbcCommand odbcCommand = new OdbcCommand(sql, odbcConnection);
OdbcDataReader odbcDataReader = odbcCommand.ExecuteReader();
if (odbcDataReader.HasRows)
{
List <Hospitalization> list = Hospitalization.getList(odbcDataReader);
Hospitalization hospitalization = list[0];
sql = "select * from `hospital`.`case` where C_ID='" + hospitalization.C_ID + "'";
odbcCommand = new OdbcCommand(sql, odbcConnection);
odbcDataReader = odbcCommand.ExecuteReader();
if (odbcDataReader.HasRows)
{
List <Case> ca = Case.getList(odbcDataReader);
Case c = ca[0];
return(Patient_C.GetSingle_pInfo(c.P_ID.ToString()));
}
odbcConnection.Close();
return(null);
}
odbcConnection.Close();
return(null);
}
public void Delete(Hospitalization entity)
{
if (AuthorizedUsers["Delete"].SingleOrDefault(x => x == Role) != null)
{
HospitalizationController.Delete(entity);
}
}
public Hospitalization AddHospitalization(Hospitalization hospitalization, PatientFile patientFile)
{
hospitalization = _hospitalizationService.Save(hospitalization);
patientFile.Hospitalization.Add(hospitalization);
Edit(patientFile);
return(hospitalization);
}
public void AddTreatment(string hospitalizationId, string treatmentId)
{
Hospitalization hospitalization = this.GetHospitalization(hospitalizationId);
hospitalization.Treatments.Add(this.treatmentsService.GetTreatment((treatmentId)));
this.db.SaveChanges();
}
public void AddExamination(string hospitalizationId, string examinationId)
{
Hospitalization hospitalization = this.GetHospitalization(hospitalizationId);
hospitalization.Examinations.Add(this.examinationsService.GetExamination((examinationId)));
this.db.SaveChanges();
}
public static Hospitalization CreateHospitalization(HttpClient httpClient, string hospitalizationExternalId)
{
// Create hospitalization
var hosp = new Hospitalization();
hosp.dateCreated = DateTime.Now;
hosp.externalID = hospitalizationExternalId;
hosp.estimatedDaysOfStay = 1;
hosp.weightUnits = "kg";
hosp.weight = 5.8;
hosp.diseases = new List <string>()
{
"high temperature", "vomiting"
};
hosp.cageNumber = "#14";
hosp.color = "#ffb4c4";
hosp.dateMovedToDepartment = DateTime.Now;
hosp.cageNumber = "123";
hosp.departmentID = 0;
hosp.treatmentTemplateName = "Default Q6";
hosp.resuscitate = ResuscitateStatus.BLS;
var patient = new Patient();
patient.birthday = DateTime.Now.AddYears(-2);
patient.breed = "Hound";
patient.color = "Brown";
patient.externalID = "myPatientId1002";
patient.name = "Jordi";
patient.species = "Canin";
patient.sex = "M";
var owner = new Client();
owner.externalID = "myClientId1003";
owner.nameFirst = "Jack";
owner.nameLast = "Dow";
owner.workPhone = "555-55-55";
patient.owner = owner;
hosp.patient = patient;
// Send to server and receive response
var url = serverUrl + "/hospitalization";
Console.WriteLine("Making web request to " + url);
var result = httpClient.PostAsJsonAsync <Hospitalization>(url, hosp).Result;
// Output result
Console.WriteLine("Http result code: {0}", result.StatusCode);
Console.WriteLine("Http content:");
Console.WriteLine(result.Content.ReadAsStringAsync().Result);
Console.WriteLine("\n\nPress any key to update this hospitalization...");
Console.ReadKey();
return(result.Content.ReadAsAsync <Hospitalization>().Result);
}
public Task <Result <string> > AddHospitalizationAsync(Hospitalization hospitalization)
{
hospitalization.Id = 1;
if (_dataSource.Hospitalizations.Count > 0)
{
hospitalization.Id = _dataSource.Hospitalizations.Max(h => h.Id) + 1;
}
_dataSource.Hospitalizations.Add(hospitalization);
return(Task.FromResult(new Result <string>(
$"Успешно сохранена {hospitalization.Id}", String.Empty)));
}
public Hospitalization Save(Hospitalization entity)
{
if (AuthorizedUsers["Save"].SingleOrDefault(x => x == Role) != null)
{
return(HospitalizationController.Save(entity));
}
else
{
return(null);
}
}
public Hospitalization AddHospitalization(Hospitalization hospitalization, PatientFile patientFile)
{
if (AuthorizedUsers["AddHospitalization"].SingleOrDefault(x => x == Role) != null)
{
return(PatientFileController.AddHospitalization(hospitalization, patientFile));
}
else
{
return(null);
}
}
public static Hospitalization CreateHospitalization(HttpClient httpClient, string hospitalizationExternalId)
{
// Create hospitalization
var hosp = new Hospitalization();
hosp.dateCreated = DateTime.Now;
hosp.externalID = hospitalizationExternalId;
hosp.estimatedDaysOfStay = 1;
hosp.weightUnits = "kg";
hosp.weight = 5.8;
hosp.diseases = new List<string>() { "high temperature", "vomiting" };
hosp.cageNumber = "#14";
hosp.color = "#ffb4c4";
hosp.dateMovedToDepartment = DateTime.Now;
hosp.cageNumber = "123";
hosp.departmentID = 0;
hosp.treatmentTemplateName = "Default Q6";
hosp.resuscitate = ResuscitateStatus.BLS;
var patient = new Patient();
patient.birthday = DateTime.Now.AddYears(-2);
patient.breed = "Hound";
patient.color = "Brown";
patient.externalID = "myPatientId1002";
patient.name = "Jordi";
patient.species = "Canin";
patient.sex = "M";
var owner = new Client();
owner.externalID = "myClientId1003";
owner.nameFirst = "Jack";
owner.nameLast = "Dow";
owner.workPhone = "555-55-55";
patient.owner = owner;
hosp.patient = patient;
// Send to server and receive response
var url = serverUrl + "/hospitalization";
Console.WriteLine("Making web request to " + url);
var result = httpClient.PostAsJsonAsync<Hospitalization>(url, hosp).Result;
// Output result
Console.WriteLine("Http result code: {0}", result.StatusCode);
Console.WriteLine("Http content:");
Console.WriteLine(result.Content.ReadAsStringAsync().Result);
Console.WriteLine("\n\nPress any key to update this hospitalization...");
Console.ReadKey();
return result.Content.ReadAsAsync<Hospitalization>().Result;
}
public static void DownloadMedicalRecordsReport(HttpClient httpClient, Hospitalization hosp)
{
var url = serverUrl + "/hospitalization/" + hosp.externalID + "/medicalrecordsreport";
Console.WriteLine("Start downloading medical records report...");
Stream pdfStream = httpClient.GetStreamAsync(url).Result;
using (var fileStream = File.Create("report.pdf"))
{
pdfStream.CopyTo(fileStream);
}
Console.WriteLine("File downloaded. You can find it in the /bin/{Configuration}/ folder");
Console.WriteLine("\n\nPress any key to exit...");
Console.ReadKey();
}
public void Add(HospitalizationInputModel inputModel)
{
Hospitalization hospitalization = new Hospitalization()
{
EnterDate = DateTime.Parse(inputModel.EnterDate),
DischargeDate = string.IsNullOrEmpty(inputModel.DischargeDate) ?
(DateTime?)null :
DateTime.Parse(inputModel.DischargeDate),
HospitalId = inputModel.HospitalId,
PersonId = inputModel.PersonId
};
this.db.Hospitalizations.Add(hospitalization);
this.db.SaveChanges();
}
public static HospitalizationDTO HospitalizitionDtoToDal(Hospitalization h)
{
return(new HospitalizationDTO
{
HospitalizationId = h.HospitalizationId,
UserId = h.UserId,
NameDepartment = h.NameDepartment,
TreatDoctor = h.TreatDoctor,
TelTreatDr = h.TelTreatDr,
NameHospital = h.NameHospital,
FromDate = h.FromDate,
UntilDate = h.UntilDate,
Describ = h.Describ
});
}
private void SetHospitalizations()
{
var h = new Hospitalization
{
Id = 1,
StartHospitalizationDate = DateTime.Parse("12.03.2014"),
EndHospitalizationDate = DateTime.Parse("20.03.2014"),
PatientId = 2,
MedicalOrganization = "Мед.уч. № 1",
DefinitiveDiagnosis = "Оконч.диагноз 1",
};
Hospitalizations.Add(h);
h = new Hospitalization
{
Id = 2,
StartHospitalizationDate = DateTime.Parse("03.05.2017"),
EndHospitalizationDate = DateTime.Parse("17.05.2017"),
PatientId = 1,
MedicalOrganization = "Мед.уч. № 2",
DefinitiveDiagnosis = "Оконч.диагноз 2",
};
Hospitalizations.Add(h);
h = new Hospitalization
{
Id = 4,
StartHospitalizationDate = DateTime.Parse("13.03.2018"),
EndHospitalizationDate = DateTime.Parse("27.03.2018"),
PatientId = 1,
MedicalOrganization = "Мед.уч. № 100",
DefinitiveDiagnosis = "Оконч.диагноз 1001",
};
Hospitalizations.Add(h);
h = new Hospitalization
{
Id = 3,
StartHospitalizationDate = DateTime.Parse("13.07.2017"),
EndHospitalizationDate = DateTime.Parse("21.07.2017"),
PatientId = 2,
MedicalOrganization = "Мед.уч. № 1",
DefinitiveDiagnosis = "Оконч.диагноз 1",
};
Hospitalizations.Add(h);
}
public async Task AddHospitalizationAsync_WhenPatientId1_ThenSuccess()
{
int patientId = 3;
var hosp = new Hospitalization
{
PatientId = patientId,
StartHospitalizationDate = new DateTime(year: 2015, month: 3, day: 29),
EndHospitalizationDate = new DateTime(year: 2015, month: 4, day: 15),
MedicalOrganization = "Гор.болница №1",
DefinitiveDiagnosis = "Тяжелое воспаление хитрости"
};
IDataContext sut = new MsSqlDataContext();
Result <string> result = await sut.Hospitalizations.AddHospitalizationAsync(hosp);
Assert.IsTrue(result.HasValue);
}
private void AddHospitalizations()
{
var hospitalizationRepository = ObjectBuilder.Container.GetInstance <IRepository <Hospitalization> >();
foreach (var patient in _patients)
{
var takeCount = _rnd.Next(1, 10);
for (var i = 0; i < takeCount; i++)
{
var st = new DateTime(1995, 1, 1);
var dateOfHospitalizationBegin = GenRandomDate(st.AddDays(_rnd.Next((DateTime.Today - st).Days)));
var dateOfHospitalizationEnd = dateOfHospitalizationBegin.AddDays(_rnd.Next(1, 14));
var randomDocumentsCount = _rnd.Next(1, 10);
var documents = new List <HospitalizationDocument>();
for (var j = 0; j < randomDocumentsCount; j++)
{
var rndDocument = Documents[_rnd.Next(0, Documents.Count - 1)];
var rndDocumentBytes = File.ReadAllBytes($"{AppDomain.CurrentDomain.BaseDirectory}/SampleDocuments/{rndDocument}");
documents.Add(new HospitalizationDocument
{
HospitalizationDocumentId = Guid.NewGuid(),
Name = rndDocument,
Content = rndDocumentBytes
});
}
var hospitalization = new Hospitalization
{
HospitalizationId = Guid.NewGuid(),
PatientId = patient.PatientId,
HospitalizationStartTime = dateOfHospitalizationBegin,
HospitalizationEndTime = dateOfHospitalizationEnd,
HospitalizationDocuments = documents
};
Console.WriteLine($"Adding Hospitalization to Patient {patient.PatientId}");
_hospitalizations.Add(hospitalization);
hospitalizationRepository.Create(hospitalization);
Console.WriteLine($"Entity {hospitalization.HospitalizationId} created");
}
}
}
public async Task <Result <List <Hospitalization> > > GetHospitalizationsByPatientIdAsync(int patientId)
{
if (patientId == 0)
{
return(new Result <List <Hospitalization> >("Неверный Id пациента."));
}
var hosps = new List <Hospitalization>();
var nameProc = @"[dbo].[spHospitalizations_GetByPatientId]";
try
{
using (var con = _conService.GetConnection())
using (var cmd = new SqlCommand(nameProc, con))
{
var param = new SqlParameter();
param.ParameterName = "@patientId";
param.SqlDbType = SqlDbType.Int;
param.Value = patientId;
cmd.Parameters.Add(param);
cmd.CommandType = CommandType.StoredProcedure;
await con.OpenAsync();
using (var reader = await cmd.ExecuteReaderAsync())
{
if (reader.HasRows)
{
while (await reader.ReadAsync())
{
Hospitalization h = GetHospitalizationfromReader(reader);
hosps.Add(h);
}
}
}
}
}
catch (Exception ex)
{
return(new Result <List <Hospitalization> >(ex.Message));
}
return(new Result <List <Hospitalization> >(hosps));
}
//已知病人id查询住院信息
public static List <Hospitalization> SelectHospitalization(int patientid)
{
string cid = Case_C.GetCaseID(patientid);
string sql = "SELECT * FROM `hospital`.`hospitalization` WHERE `C_ID` = '" + cid + "'";
OdbcConnection odbcConnection = DB.DBManager.GetOdbcConnection();
odbcConnection.Open();
OdbcCommand odbcCommand = new OdbcCommand(sql, odbcConnection);
OdbcDataReader odbcDataReader = odbcCommand.ExecuteReader(CommandBehavior.CloseConnection);
if (odbcDataReader.HasRows)
{
List <Hospitalization> list = Hospitalization.getList(odbcDataReader);
odbcConnection.Close();
return(list);
}
else
{
odbcConnection.Close();
}
return(null);
}
public static void DownloadMedicalRecordsReport(HttpClient httpClient, Hospitalization hosp)
{
var url = serverUrl + "/hospitalization/" + hosp.externalID + "/medicalrecordsreport";
Console.WriteLine("Start downloading medical records report...");
Stream pdfStream = httpClient.GetStreamAsync(url).Result;
using (var fileStream = File.Create("report.pdf"))
{
pdfStream.CopyTo(fileStream);
}
Console.WriteLine("File downloaded. You can find it in the /bin/{Configuration}/ folder");
Console.WriteLine("\n\nPress any key to exit...");
Console.ReadKey();
}
public static void UpdateHospitalization(HttpClient httpClient, Hospitalization hosp)
{
// Add disease, and set custom field for the patient.
// Fields that should not be updated, must be nullified.
// If you want to reset some text fields then pass empty string ""
hosp.diseases.Add("diarrhea");
hosp.color = "#d3b2f1";
hosp.patient.species = null; // species will not be updated
hosp.patient.owner = null; // owner will not be updated
hosp.patient.customField = "CS 123"; // new value for customField
hosp.patient.color = ""; // reset color
var url = serverUrl + "/hospitalization";
Console.WriteLine("Making web request to " + url);
var result = httpClient.PutAsJsonAsync<Hospitalization>(url, hosp).Result;
// Output result
Console.WriteLine("Http result code: {0}", result.StatusCode);
Console.WriteLine("Http content:");
Console.WriteLine(result.Content.ReadAsStringAsync().Result);
Console.WriteLine("\n\nPress any key to continue...");
Console.ReadKey();
}
public void Delete(Hospitalization entity)
{
_hospitalizationRepository.Delete(entity);
}
public void Delete(Hospitalization entity)
{
Context.Hospitalizations.Remove(entity);
SaveChanges();
}
public void Update(Hospitalization entity)
{
Context.Entry(entity).State = EntityState.Modified;
SaveChanges();
}
public void Edit(Hospitalization entity)
{
_hospitalizationRepository.Edit(entity);
}
public Hospitalization Save(Hospitalization entity)
{
return(_hospitalizationService.Save(entity));
}
public void Edit(Hospitalization entity)
{
_hospitalizationService.Edit(entity);
}
public void Delete(Hospitalization entity)
{
_hospitalizationService.Delete(entity);
}
private void processHospitalization(Hospitalization h)
{
Console.WriteLine(String.Format("Hospitalization: Patient.Name - {0}", h.patient.name));
}
public async Task <Result <string> > AddHospitalizationAsync(Hospitalization hospitalization)
{
if (hospitalization == null)
{
return(new Result <string>("Пустое значение параметра"));
}
if (hospitalization.PatientId == 0)
{
return(new Result <string>("Неверное значение Id пациента"));
}
var nameProc = @"[dbo].[spHospitalizations_Add]";
object result = null;
try
{
using (var con = _conService.GetConnection())
using (var cmd = new SqlCommand(nameProc, con))
{
var paramPid = new SqlParameter();
paramPid.ParameterName = "@patientId";
paramPid.SqlDbType = SqlDbType.Int;
paramPid.Value = hospitalization.PatientId;
var paramSDate = new SqlParameter();
paramSDate.ParameterName = "@startd";
paramSDate.SqlDbType = SqlDbType.DateTime;
paramSDate.Value = hospitalization.StartHospitalizationDate;
var paramEDate = new SqlParameter();
paramEDate.ParameterName = "@endd";
paramEDate.SqlDbType = SqlDbType.DateTime;
paramEDate.Value = hospitalization.EndHospitalizationDate;
var paramMedOrg = new SqlParameter();
paramMedOrg.ParameterName = "@medorg";
paramMedOrg.SqlDbType = SqlDbType.NVarChar;
paramMedOrg.Value = hospitalization.MedicalOrganization.Trim();
var paramDefDiag = new SqlParameter();
paramDefDiag.ParameterName = "@diag";
paramDefDiag.SqlDbType = SqlDbType.NVarChar;
paramDefDiag.Value = hospitalization.DefinitiveDiagnosis.Trim();
cmd.Parameters.Add(paramPid);
cmd.Parameters.Add(paramSDate);
cmd.Parameters.Add(paramEDate);
cmd.Parameters.Add(paramDefDiag);
cmd.Parameters.Add(paramMedOrg);
cmd.CommandType = CommandType.StoredProcedure;
await con.OpenAsync();
result = await cmd.ExecuteScalarAsync();
}
}
catch (Exception ex)
{
return(new Result <string>(ex.Message));
}
return(new Result <string>($"Успешно сохранена новая госпитализация {result}.", string.Empty));
}
public Hospitalization Save(Hospitalization entity)
{
return(_hospitalizationRepository.Save(entity));
}
public void Create(Hospitalization entity)
{
Context.Hospitalizations.Add(entity);
SaveChanges();
}