/// <summary>
/// 向Datatable中加入出院情况ID、出院情况两列数据
/// 注：Datatable中需包含iem_mainpage_diagnosis_no列
/// </summary>
/// <param name="dt"></param>
/// <returns></returns>
public static DataTable AddColsDataToDataTable(DataTable dt)
{
try
{
if (!dt.Columns.Contains("Status_Id_Out"))
{
dt.Columns.Add("Status_Id_Out");
}
if (!dt.Columns.Contains("Status_Name_Out"))
{
dt.Columns.Add("Status_Name_Out");
}
if (null != dt && dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
if (null != dr && null != dr["iem_mainpage_diagnosis_no"] && !string.IsNullOrEmpty(dr["iem_mainpage_diagnosis_no"].ToString().Trim()) && Tool.IsInt(dr["iem_mainpage_diagnosis_no"].ToString().Trim()))
{
DataTable coditionDT = DS_SqlService.GetOutHosConditonByID(int.Parse(dr["iem_mainpage_diagnosis_no"].ToString().Trim()));
if (null != coditionDT && coditionDT.Rows.Count > 0)
{
dr["Status_Id_Out"] = coditionDT.Rows[0]["status_id"];
dr["Status_Name_Out"] = coditionDT.Rows[0]["Status_Name"];
}
}
}
}
return(dt);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}