void LoadData()
{
string cmdText = "";
if (doc.IsNew)
{
cmdText = "select top 0 * from DocumentProducts";
}
else
{
cmdText = @"
select DocumentProducts.*, StoreProducts.*, Products.Code, Products.Name
from DocumentProducts
left join StoreProducts on StoreProducts.Id=StoreProductId
left join Products on Products.Id=ProductId
where DocumentId=@DocumentId";
}
using (GmConnection conn = App.CreateConnection())
{
GmCommand cmd = conn.CreateCommand(cmdText);
cmd.AddInt("DocumentId", doc.Id);
cmd.Fill(dataTable);
}
if (gridView.Visible)
{
gridView.DataSource = dataTable;
}
}
public static ReportsDataSet.AnalysisRequestDataTable GetAnalysisRequestTable(ConnectionFactory factory, Config config, int patientId, int analysisId)
{
DataTable dataTable = new DataTable();
string cmdText = @"
select Code, AnalysisTypes.Name as AnalysisTypeName, RequestDate
from Analyses
left join AnalysisTypes on AnalysisTypes.Id=AnalysisTypeId
where ";
cmdText += analysisId == 0 ? "PatientId=@PatientId order by RequestDate" : "AnalysisId=@AnalysisId";
using (GmConnection conn = factory.CreateConnection())
{
GmCommand cmd = new GmCommand(conn, cmdText);
cmd.AddInt("PatientId", patientId);
cmd.AddInt("AnalysisId", analysisId);
cmd.Fill(dataTable);
}
ReportsDataSet.AnalysisRequestDataTable dtAnalysisRequest = new ReportsDataSet.AnalysisRequestDataTable();
foreach (DataRow dr in dataTable.Rows)
{
ReportsDataSet.AnalysisRequestRow row = dtAnalysisRequest.NewAnalysisRequestRow();
row.AnalysisCode = (string)dr["Code"];
row.AnalysisName = (string)dr["AnalysisTypeName"];
row.RequestDate = ((DateTime)dr["RequestDate"]).ToString("dd.MM.yy");
dtAnalysisRequest.AddAnalysisRequestRow(row);
}
return(dtAnalysisRequest);
}
void LoadData()
{
string cmdText = @"
select DocumentProducts.*, StoreProducts.*, Products.Code, Products.Name
from DocumentProducts
left join StoreProducts on StoreProducts.Id=StoreProductId
left join Products on Products.Id=ProductId
where DocumentId=@DocumentId";
using (GmConnection conn = App.CreateConnection())
{
GmCommand cmd = conn.CreateCommand(cmdText);
cmd.AddInt("DocumentId", doc.Id);
cmd.Fill(dataTable);
}
gridView.DataSource = dataTable;
chkCompleted.Checked = doc.completed;
if (doc.completed)
{
Control[] controls = { btnAdd, btnRemove, btnOk, dpDate };
foreach (Control ctl in controls)
{
ctl.Enabled = false;
}
chkCompleted.Enabled = false;
ucSelectProduct.Enabled = false;
}
}
public static ReportsDataSet.AnalysisResultDataTable GetAnalysisResultTable(ConnectionFactory factory, Config config, int patientId, int analysisId)
{
DataTable dataTable = new DataTable();
string cmdText = @"
select Code, AnalysisTypes.Name as AnalysisTypeName, ExecutionDate, AnalysisData, HandbookGroupId
from Analyses
left join AnalysisTypes on AnalysisTypes.Id=AnalysisTypeId
where ExecutionDate is not null and ";
cmdText += analysisId == 0 ? "PatientId=@PatientId order by ExecutionDate" : "AnalysisId=@AnalysisId";
using (GmConnection conn = factory.CreateConnection())
{
GmCommand cmd = new GmCommand(conn, cmdText);
cmd.AddInt("PatientId", patientId);
cmd.AddInt("AnalysisId", analysisId);
cmd.Fill(dataTable);
}
ReportsDataSet.AnalysisResultDataTable dtAnalysisResult = new ReportsDataSet.AnalysisResultDataTable();
foreach (DataRow dr in dataTable.Rows)
{
AnalysisData ad = AnalysisData.DeserializeString(dr["AnalysisData"] as string);
ReportsDataSet.AnalysisResultRow row = dtAnalysisResult.NewAnalysisResultRow();
row.AnalysisCode = (string)dr["Code"];
row.AnalysisName = (string)dr["AnalysisTypeName"];
row.ExecutionDate = ((DateTime)dr["ExecutionDate"]).ToString("dd.MM.yy");
HandbookGroup hg = config.GetHandbookGroup((string)dr["HandbookGroupId"]);
row.Result = ad.GetText(hg);
dtAnalysisResult.AddAnalysisResultRow(row);
}
return(dtAnalysisResult);
}
int LoadData()
{
reportsDataSet.PatientsPrescriptions.Clear();
doc.documentData.prescriptionTypes.Clear();
foreach (PrescriptionType prescriptionType in lbPrescriptionTypes.CheckedItems)
{
doc.documentData.prescriptionTypes.Add(prescriptionType.Id);
}
doc.date = dpDate.Value.Date;
if (doc.documentData.prescriptionTypes.Count == 0)
{
return(0);
}
string cmdText = @"
SELECT Wards.Number AS WardNumber, Prescriptions.PatientId, Passports.Surname + ' ' + Passports.Name AS PatientName,
PrescriptionTypes.Name AS PrescriptionTypeName, Products.Name AS ProductName, Prescriptions.Dose, BaseUnits.Name AS BaseUnitName,
Prescriptions.Multiplicity
FROM Prescriptions LEFT OUTER JOIN
StoreProducts ON StoreProducts.Id = Prescriptions.StoreProductId LEFT OUTER JOIN
Products ON Products.Id = StoreProducts.ProductId LEFT OUTER JOIN
BaseUnits ON BaseUnits.Id = Products.BaseUnitId LEFT OUTER JOIN
PrescriptionTypes ON PrescriptionTypes.Id = Prescriptions.PrescriptionTypeId LEFT OUTER JOIN
Patients ON Patients.Id = Prescriptions.PatientId LEFT OUTER JOIN
Wards ON Wards.Id = Patients.WardId LEFT OUTER JOIN
Passports ON Passports.Id = Patients.PassportId
WHERE (Prescriptions.StartDate <= @EndDate) AND (@StartDate <= Prescriptions.EndDate)";
cmdText += string.Format(" and PrescriptionTypeId in ({0})", CollectionUtils.GetCommaSeparatedList(doc.documentData.prescriptionTypes));
if (hasWatching)
{
cmdText += string.Format(" and PatientId in ({0})", CollectionUtils.GetCommaSeparatedList(doc.documentData.patients));
}
else
{
cmdText += " and (DischargeDate is null)";
}
cmdText += " ORDER BY WardNumber, Prescriptions.PatientId";
using (GmConnection conn = App.CreateConnection())
{
GmCommand cmd = conn.CreateCommand(cmdText);
cmd.AddDateTime("StartDate", doc.date);
cmd.AddDateTime("EndDate", doc.date + TimeSpan.FromDays(1));
cmd.Fill(reportsDataSet.PatientsPrescriptions);
}
return(reportsDataSet.PatientsPrescriptions.Rows.Count);
}
