public BloodResult GenerateOne()
{
BloodResult result = new BloodResult();
result.Name = NamesGen.NextName;
// Общий белок 65-84 г/л 65-85 г/л
result.Total_protein = Total_protein.Next(this.myRandom);
//Белковые фракции:
// - альбумины 34-44 г/л 21-35 г/л
result.Albumin = Albumin.Next(this.myRandom);
// - глобулины 35-45 г/л 21-34,9 г/л
result.Globulin = Globulin.Next(this.myRandom);
// Гемоглобин 130-150 г/л 120-140 г/л
result.Hemoglobin = Hemoglobin.Next(this.myRandom);
// Мочевина 2,5-8,2 ммоль/л 2,4-8,2 ммоль/л
result.Urea = Urea.Next(this.myRandom);
// Мочевая кислота 0,12-0,42 ммоль/л 0,24-0,54 ммоль/л
result.Uric_acid = Uric_acid.Next(this.myRandom);
// Глюкоза 3,3-5,5 ммоль/л 3,2-5,5 ммоль/л
result.Glucose = Glucose.Next(this.myRandom);
// Креатинин 61-114 мкмоль/л 52-96 мкмоль/л
result.Creatinine = Creatinine.Next(this.myRandom);
// Холестерин общий 3,4-6,4 ммоль/л 3,4-6,4 ммоль/л
result.Total_cholesterol = Total_cholesterol.Next(this.myRandom);
// ЛПНП До 3 ммоль/л До 3 ммоль/л
result.LDL = LDL.Next(this.myRandom);
// ЛПВП 1 ммоль/л 0-1,2 ммоль/л
result.HDL = HDL.Next(this.myRandom);
// Триглицериды До 1,6 ммоль/л До 1,7 ммоль/л
result.Trigliceride = Trigliceride.Next(this.myRandom);
// Билирубин(общий) 5-20 мкмоль/л 5-20 мкмоль/л
result.Total_bilirubin = Total_bilirubin.Next(this.myRandom);
// Билирубин прямой 2,2-5,0 мкмоль/л 2,2-5,0 мкмоль/л
result.Direct_bilirubin = Direct_bilirubin.Next(this.myRandom);
// АЛТ(аланинаминотрансфераза) Не более 45 ед/л Не более 30 ед/л
result.ALT = ALT.Next(this.myRandom);
// АСТ(аспартатаминотрансфераза) До 45 ед/л До 30 ед/л
result.AST = AST.Next(this.myRandom);
// Щелочная фосфатаза До 260 ед/л До 250 ед/л
result.Alcaline_phospharase = Alcaline_phospharase.Next(this.myRandom);
// ГГТ(гамма-глутамилтрансфераза) До 33 ед/л До 47 ед/л
result.GGT = GGT.Next(this.myRandom);
// Липаза 0-187 ед/л 0-187 ед/л
result.Lipase = Lipase.Next(this.myRandom);
// Панкреатическая амилаза 0-50 ед/л 0-50 ед/л
result.Pancreatic_amylase = Pancreatic_amylase.Next(this.myRandom);
// Креатинкиназа(КК) До 180 ед/л До 180 ед/л
result.Creatine_Kinase = Creatine_Kinase.Next(this.myRandom);
// Натрий 130-150 ммоль/л 130-150 ммоль/л
result.Sodium = Sodium.Next(this.myRandom);
// Калий 3,3-5,3 ммоль/л 3,35-5,3 ммоль/л
result.Potassium = Potassium.Next(this.myRandom);
// Альфа-амилаза 27-99 ед/л 28-100 ед/л
result.Alpha_amilase = Alpha_amilase.Next(this.myRandom);
return(result);
}
public Válasz(string path, Tanuló tanuló, Teszt test, ALT a)
{
alt = a;
teszt = test;
tulajdonos = tanuló;
feladatnév = Path2name(path);
if (feladatnév.Split('_').Length >= 3) // adatbázisok esetéen egy feladatnév mindig így néz ki: output_cukraszda_4laktozmentes.txt
{
adatbázis = feladatnév.Split('_')[1];
lekérdezés = feladatnév.Split('_')[2].Split('.')[0];
}
else // programok outputjai esetében nincsen adatbázisnév és lekérdezésnév, ott az csak így néz ki: output4.txt
{
adatbázis = "";
lekérdezés = feladatnév.Split('.')[0];
}
List <string[]> beolvasástartalma = new List <string[]>();
#region beolvasás: beolvasástartalma
try
{
using (f = new StreamReader(path, Encoding.UTF8))
{
while (!f.EndOfStream)
{
beolvasástartalma.Add(f.ReadLine().Split('\t'));
}
}
}
catch (Exception)
{
Színes.WriteLine($"[red]{{{path}}} nem található.");
beolvasástartalma.Add(new string[1] {
nemválaszolt
});
}
#endregion
#region tábla kialakítása
Size[0] = beolvasástartalma.Count;
if (Size[0] != 0)
{
Size[1] = beolvasástartalma[0].Length;
tábla = new string[Size[0], Size[1]];
for (int i = 0; i < Size[0]; i++)
{
for (int j = 0; j < Size[1]; j++)
{
tábla[i, j] = beolvasástartalma[i][j];
}
}
}
else
{
tábla = new string[1, 1];
tábla[0, 0] = "Üres a tábla!";
}
#endregion
halmaz = new StringMultihalmaz(tábla, Size[0], Size[1]);
}
private void FillDayExtended(DateTime data)
{
int currentUId = (UC.ImpersonateUser == 0) ? UC.UserId : UC.ImpersonateUser;
this.LblTitle.Text = "<table cellpadding=0 cellspacing=3><tr><td><img src=/images/Tustenalogov2.gif></td>";
if (currentUId == UC.UserId)
{
LblTitle.Text += "<td valign=bottom class=\"BigTitle\">" + UC.UserRealName + " " + data.ToShortDateString() + "</td>";
}
else
{
LblTitle.Text += "<td valign=bottom class=\"BigTitle\">" + DatabaseConnection.SqlScalar("SELECT SURNAME+' '+NAME AS USERREALNAME FROM ACCOUNT WHERE UID=" + currentUId) + " " + data.ToShortDateString() + "</td>";
}
this.LblTitle.Text += "</tr></table>";
StringBuilder sqlCalendar = new StringBuilder();
sqlCalendar.AppendFormat("SELECT ID,STARTDATE,ENDDATE,RECURRID,CONTACT,COMPANY,NOTE,CONVERT(VARCHAR(10),STARTDATE,112) AS ISOSTARTDATE, DATEPART(HH, STARTDATE) AS STARTHOUR, DATEPART(HH, ENDDATE) AS ENDHOUR FROM BASE_CALENDAR WHERE (CONVERT(VARCHAR(10),STARTDATE,112)='{0}' OR RECURRID>0) AND UID={1};", data.ToString(@"yyyyMMdd"), currentUId);
sqlCalendar.AppendFormat("SELECT ID,STARTDATE,TITLE,NOTE,RECURRID,CONVERT(VARCHAR(10),STARTDATE,112) AS ISOSTARTDATE, DATEPART(HH, STARTDATE) AS STARTHOUR FROM BASE_EVENTS WHERE (CONVERT(VARCHAR(10),STARTDATE,112)='{0}' OR RECURRID>0) AND UID={1};", data.ToString(@"yyyyMMdd"), currentUId);
Trace.Warn("SQL", sqlCalendar.ToString());
DataSet dsCalendar = DatabaseConnection.CreateDataset(sqlCalendar.ToString());
DataTable CalendarDataTable = dsCalendar.Tables[0];
DataTable eventDataTable = dsCalendar.Tables[1];
StringBuilder gg = new StringBuilder();
int hTimeZone = Convert.ToInt32(UC.HTimeZone);
DataColumn dcDynColumn = new DataColumn();
dcDynColumn.ColumnName = "isRec";
dcDynColumn.DataType = Type.GetType("System.Byte");
dcDynColumn.DefaultValue = 0;
CalendarDataTable.Columns.Add(dcDynColumn);
DataColumn dcDynColumn2 = new DataColumn();
dcDynColumn2.ColumnName = "isRec";
dcDynColumn2.DataType = Type.GetType("System.Byte");
dcDynColumn2.DefaultValue = 0;
eventDataTable.Columns.Add(dcDynColumn2);
int rowsToCicleCal = CalendarDataTable.Rows.Count;
int rowsToCicleEvn = eventDataTable.Rows.Count;
if (CalendarDataTable.Select("RecurrID>0").Length > 0)
{
DateTime MDT = data;
DateTime MDT2 = MDT.AddSeconds(86399);
Trace.Warn("MDT", MDT.ToString());
Trace.Warn("MDT2", MDT2.ToString());
for (int i = 0; i < rowsToCicleCal; i++)
{
ArrayList AL = recurrence.Remind((int)CalendarDataTable.Rows[i]["recurrid"], MDT, MDT2);
if (AL.Count > 0)
{
foreach (DateTime ALT in AL)
{
DataRow row = CalendarDataTable.NewRow();
for (int i2 = 0; i2 < CalendarDataTable.Columns.Count - 1; i2++)
{
row[i2] = CalendarDataTable.Rows[i][i2];
}
row["isRec"] = 1;
row["ISOSTARTDATE"] = ALT.ToString(@"yyyyMMdd");
CalendarDataTable.Rows.Add(row);
}
if (Convert.ToInt32(((string)CalendarDataTable.Rows[i]["ISOSTARTDATE"]).Substring(4, 2)) != data.Month)
{
CalendarDataTable.Rows[i]["ISOSTARTDATE"] = "19800101";
}
}
}
}
if (eventDataTable.Select("RecurrID>0").Length > 0)
{
DateTime MDT = data;
DateTime MDT2 = MDT.AddSeconds(86399);
for (int i = 0; i < rowsToCicleEvn; i++)
{
ArrayList AL = recurrence.Remind((int)eventDataTable.Rows[i]["recurrid"], MDT, MDT2);
Trace.Warn("AL", AL.Count.ToString());
if (AL.Count > 0)
{
foreach (DateTime ALT in AL)
{
DataRow row = eventDataTable.NewRow();
for (int i2 = 0; i2 < eventDataTable.Columns.Count - 1; i2++)
{
row[i2] = eventDataTable.Rows[i][i2];
}
row["isRec"] = 1;
row["ISOSTARTDATE"] = ALT.ToString(@"yyyyMMdd");
eventDataTable.Rows.Add(row);
}
if (Convert.ToInt32(((string)eventDataTable.Rows[i]["ISOSTARTDATE"]).Substring(4, 2)) != data.Month)
{
eventDataTable.Rows[i]["ISOSTARTDATE"] = "19800101";
}
}
}
}
DataRow[] drExistsAppointment = CalendarDataTable.Select("ISOSTARTDATE='" + data.ToString(@"yyyyMMdd") + "'");
long idNumber = 0;
for (int dayI = 0; dayI < 23; dayI++)
{
if (dayI % 2 == 0)
{
gg.AppendFormat("<tr><td valign=\"top\" class=\"GridItem\">{0}:00</td><td class=\"GridItem ", dayI.ToString());
}
else
{
gg.AppendFormat("<tr><td valign=\"top\" class=\"GridItemAltern\">{0}:00</td><td class=\"GridItemAltern ", dayI.ToString());
}
if (drExistsAppointment.Length > 0)
{
bool exists = false;
string appString = String.Empty;
foreach (DataRow selectAppointmentDr in drExistsAppointment)
{
if (((int)selectAppointmentDr["starthour"] + hTimeZone) == dayI && idNumber != Convert.ToInt32(selectAppointmentDr["id"]))
{
exists = true;
string appText = UC.LTZ.ToLocalTime((DateTime)selectAppointmentDr["startdate"]).ToString(@"HH:mm") + " - " + UC.LTZ.ToLocalTime((DateTime)selectAppointmentDr["enddate"]).ToString(@"HH:mm") + "<br>" + selectAppointmentDr["CONTACT"].ToString() + ((selectAppointmentDr["COMPANY"].ToString().Length > 0) ? "<br>[" + G.ParseJSString(selectAppointmentDr["COMPANY"].ToString()) + "]<br>" : "<br>") + selectAppointmentDr["note"];
idNumber = Convert.ToInt64(selectAppointmentDr["id"]);
appString = "Cbgg\" onclick=\"OpenTEvent('MOD','&id=" + idNumber.ToString() + "');\">" + appText;
}
else
{
if (((int)selectAppointmentDr["starthour"] + hTimeZone) < dayI && ((int)selectAppointmentDr["endhour"] + hTimeZone) >= dayI && idNumber == Convert.ToInt64(selectAppointmentDr["id"]))
{
exists = true;
appString = "Cbgg\" onclick=\"OpenTEvent('MOD','&id=" + idNumber.ToString() + "');\">";
}
}
}
gg.Append(appString.ToString());
if (!exists)
{
gg.AppendFormat(" onclick=\"OpenTEvent('NEW','{0}&ora1={1}:00');\"> </td>", data.ToShortDateString(), dayI.ToString());
}
else
{
gg.Append(" </td>");
}
}
else
{
gg.AppendFormat(" onclick=\"OpenTEvent('NEW','{0}&ora1={1}:00');\"> </td>", data.ToShortDateString(), dayI.ToString());
}
if (dayI % 2 == 0)
{
gg.Append("<td class=\"GridItem\"");
}
else
{
gg.Append("<td class=\"GridItemAltern\"");
}
DataRow[] drExistsEvent = eventDataTable.Select("ISOSTARTDATE='" + data.ToString(@"yyyyMMdd") + "' AND STARTHOUR=" + (dayI - hTimeZone).ToString());
if (drExistsEvent.Length > 0)
{
Trace.Warn("eventi", drExistsEvent.Length.ToString());
gg.Append(">");
foreach (DataRow drs in drExistsEvent)
{
gg.Append("<table width=\"100%\"><tr><td class=\"normal Cbgg\"");
gg.Append(" onclick=\"OpenEventS('MOD','&id=" + Convert.ToString(drs["id"]) + "');\">" + UC.LTZ.ToLocalTime((DateTime)drs["startdate"]).ToString(@"HH:mm") + "<br>" + drs["title"] + "<br>" + drs["note"]);
gg.Append("</td></tr></table>");
}
gg.Append(" </td></tr>");
}
else
{
gg.Append(" onclick=\"OpenEventS('NEW','" + data.ToShortDateString() + "&ora1=" + dayI.ToString() + ":00');\"> </td></tr>");
}
}
Detail.Text = gg.ToString();
}
private string FillDay(DateTime data, int uIDATTUALE)
{
string sqlCalendar = "SELECT ID,RECURRID,CONVERT(VARCHAR(10),STARTDATE,112) AS ISOSTARTDATE, DATEPART(HH, STARTDATE) AS STARTHOUR, DATEPART(HH, ENDDATE) AS ENDHOUR,CONTACT,COMPANY,STARTDATE,ENDDATE FROM BASE_CALENDAR WHERE (CONVERT(VARCHAR(10),STARTDATE,112)='" + data.ToString(@"yyyyMMdd") + "' OR RECURRID>0) AND UID=@UID";
Trace.Warn("SQL", sqlCalendar);
DataSet dsCalendar = DatabaseConnection.SecureCreateDataset(sqlCalendar, new DbSqlParameter("@UID", uIDATTUALE));
DataTable CalendarDataTable = dsCalendar.Tables[0];
StringBuilder gg = new StringBuilder();
StringBuilder descTable = new StringBuilder();
DateTime Utctime = UC.LTZ.ToUniversalTime(data);
TimeSpan mindiffstart = new TimeSpan(data.Ticks - Utctime.Ticks);
int hTimeZone = Convert.ToInt32(mindiffstart.TotalHours);
DataColumn dcDynColumn = new DataColumn();
dcDynColumn.ColumnName = "isRec";
dcDynColumn.DataType = Type.GetType("System.Byte");
dcDynColumn.DefaultValue = 0;
CalendarDataTable.Columns.Add(dcDynColumn);
int rowsToCicleCal = CalendarDataTable.Rows.Count;
if (CalendarDataTable.Select("RecurrID>0").Length > 0)
{
DateTime MDT = data;
DateTime MDT2 = MDT.AddSeconds(86399);
Trace.Warn("MDT", MDT.ToString());
Trace.Warn("MDT2", MDT2.ToString());
for (int i = 0; i < rowsToCicleCal; i++)
{
Recurrence recurrence = new Recurrence(UC);
ArrayList AL = recurrence.Remind((int)CalendarDataTable.Rows[i]["recurrid"], MDT, MDT2);
if (AL.Count > 0)
{
foreach (DateTime ALT in AL)
{
DataRow row = CalendarDataTable.NewRow();
for (int i2 = 0; i2 < CalendarDataTable.Columns.Count - 1; i2++)
{
row[i2] = CalendarDataTable.Rows[i][i2];
}
row["isRec"] = 1;
row["startdate"] = ALT.Date.Add(((DateTime)row["startdate"]).TimeOfDay);
row["enddate"] = ALT.Date.Add(((DateTime)row["enddate"]).TimeOfDay);
row["ISOSTARTDATE"] = ALT.ToString(@"yyyyMMdd");
CalendarDataTable.Rows.Add(row);
}
if (Convert.ToInt32(((string)CalendarDataTable.Rows[i]["ISOSTARTDATE"]).Substring(4, 2)) != data.Month)
{
CalendarDataTable.Rows[i]["ISOSTARTDATE"] = "19800101";
}
}
}
}
DataRow[] drAppExists = CalendarDataTable.Select("ISOSTARTDATE='" + data.ToString(@"yyyyMMdd") + "'");
long idNumber = 0;
gg.AppendFormat("<table><tr><td colspan=6 class=normal>{0}</td></tr><tr>", DatabaseConnection.SqlScalar("SELECT ISNULL(NAME,'')+' '+ISNULL(SURNAME,'') FROM ACCOUNT WHERE UID=" + uIDATTUALE));
for (int xx = 0; xx <= 23; xx++)
{
if (xx % 2 == 0)
{
gg.Append("<td valign=\"top\" class=\"Grid ");
}
else
{
gg.Append("<td valign=\"top\" class=\"GridAltern ");
}
if (drAppExists.Length > 0)
{
bool exists = false;
string appString = String.Empty;
foreach (DataRow drSelApp in drAppExists)
{
if (((int)drSelApp["starthour"] + hTimeZone) == xx &&
idNumber != Convert.ToInt32(drSelApp["id"]))
{
exists = true;
appString = "GridApp\">";
}
else
{
if (((int)drSelApp["starthour"] + hTimeZone) < xx &&
((int)drSelApp["endhour"] + hTimeZone) >= xx &&
idNumber != Convert.ToInt32(drSelApp["id"]))
{
exists = true;
appString = "GridApp\">";
}
}
}
gg.Append(appString.ToString());
if (!exists)
{
gg.AppendFormat("\">{0}:00</td>", xx.ToString());
}
else
{
gg.AppendFormat("{0}:00</td>", xx.ToString());
}
}
else
{
gg.AppendFormat("\">{0}:00</td>", xx.ToString());
}
if (xx == 5 || xx == 11 || xx == 17 || xx == 23)
{
gg.Append("</tr><tr>");
}
}
gg.Append("</table>");
int clnumber = 1;
foreach (DataRow drSelApp in drAppExists)
{
string cl = ((clnumber % 2) == 0) ? "GridItem" : "GridItemAltern";
clnumber++;
descTable.AppendFormat("<tr><td width=\"1%\" nowrap class={2}>{0}</td><td width=\"1%\" nowrap class={2}>{1}</td>", ((DateTime)drSelApp["startdate"]).AddHours(hTimeZone).ToShortTimeString(), ((DateTime)drSelApp["enddate"]).AddHours(hTimeZone).ToShortTimeString(), cl);
descTable.AppendFormat("<td width=\"98%\" nowrap class={2}>{0} {1}</td></tr>", drSelApp["contact"].ToString(), drSelApp["company"].ToString(), cl);
}
if (descTable.Length > 0)
{
gg.AppendFormat("<table class=\"normal\" cellspacing=0 cellpadding=3 width=\"100%\" style=\"border-top:2px solid black;\">{0}</table>", descTable.ToString());
}
return(gg.ToString());
}
