public static WardProduct DtToRoomClass(DataTable dtRoomClass, string ward)
{
var result = new WardProduct();
foreach (DataRow row in dtRoomClass.Rows)
{
}
return(result);
}
public static WardProduct DtToWardProduct(DataTable dt, string wardCode)
{
List <PatientRoomClass> items = new List <PatientRoomClass>();
List <string> listClass = new List <string>();
StaffReal staffReal = new StaffReal();
StaffData staffData = new StaffData();
DataTable dtStaffReal = new DataTable();
decimal sumStaffReal = 0;
decimal sumOfMulClass = 0;
decimal sumOfRealStaff = 0;
decimal percentage = 0;
decimal sumPatientKardex = 0;
decimal sumOfMulClassmulClsx100 = 0;
decimal sumPatientClass = 0;
// set value to object PatientRoomClass
foreach (DataRow row in dt.Rows)
{
int ptClass = 0;
var item = new PatientRoomClass();
Tuple <string, string> patient = GetData.PatientHnAdm(row["BED_RowID"].ToString());
string papmiNo = patient.Item1;
string epi = patient.Item2;
item.BED_RowID = row["BED_RowID"].ToString();
item.BED_Code = GetData.GetBedType(row["BED_RowID"].ToString()) + row["BED_Code"].ToString();
item.Paadm_AdmNo = epi;
sumPatientKardex += GetData.GetPatientKardex(epi);
item.Papmi_No = papmiNo;
item.PatientClass = GetData.GetPatientClass(papmiNo);
if (!string.IsNullOrEmpty(papmiNo))
{
sumPatientClass += 1;
}
if (Int32.TryParse(item.PatientClass, out ptClass))
{
listClass.Add(item.PatientClass);
}
if (item.PatientClass == null)
{
item.PatientClass = "??";
}
var reasonNotAvail = GetData.GetStatReasonNotAvail(row["BED_RowID"].ToString());
item.PatientClass = string.IsNullOrEmpty(reasonNotAvail) ? item.PatientClass : reasonNotAvail;
items.Add(item);
}
WardModel wardModel = new WardModel
{
PatientRoomClassList = items
};
string wardSql = string.Empty;
if (Data.MapWardCacheWithSql.TryGetValue(wardCode, out wardSql))
{
dtStaffReal = SqlServerDA.DataTableBindDataCommand(QueryString.GetRealStaffQueryString(wardSql, DateTime.Now), Constants.Svh21CHKConnectionString);
}
// set staff real to object StaffReal
foreach (DataRow row in dtStaffReal.Rows)
{
staffReal.DayRnReal = Convert.ToDecimal(row["DayRnReal"]);
staffReal.DayNrReal = Convert.ToDecimal(row["DayNrReal"]);
staffReal.EveRnReal = Convert.ToDecimal(row["EveRnReal"]);
staffReal.EveNrReal = Convert.ToDecimal(row["EveNrReal"]);
staffReal.NigRnReal = Convert.ToDecimal(row["NigRnReal"]);
staffReal.NigNrReal = Convert.ToDecimal(row["NigNrReal"]);
}
sumStaffReal = Calculate.SumStaffReal(staffReal);
string wardCase = string.Empty;
int add = 0;
if (wardCode.Contains("W"))
{
wardCase = "W";
Data.MapWardAdd.TryGetValue(wardCode, out add);
sumOfMulClass = Calculate.PatientClassCalc(listClass, wardCase, add);
sumOfMulClassmulClsx100 = Calculate.GetClsMul100(sumOfMulClass);
sumOfRealStaff = Calculate.GetSumOfRealStaff(sumStaffReal, wardCase);
percentage = Calculate.GetPercentag(sumOfMulClassmulClsx100, sumOfRealStaff);
staffData = Calculate.GetStaffData(sumOfMulClass, wardCase);
}
else if (wardCode.Contains("ICU"))
{
}
else if (wardCode.Contains("N"))
{
}
Staff staff = new Staff()
{
StaffReal = staffReal,
StaffData = staffData
};
WardCalculate wardCalc = new WardCalculate
{
WardPercentage = percentage,
NumPatientKardex = sumPatientKardex,
NumPatientClass = sumPatientClass
};
WardProduct result = new WardProduct
{
WardCode = wardCode,
WardModel = wardModel,
WardCalculate = wardCalc,
Staffs = staff
};
return(result);
}