/// <summary>
/// 根据病种组合ID获取病种字符串
/// 注：name1(icd1)，name2(icd2)， ......
/// </summary>
/// <auth>Yanqiao.Cai</auth>
/// <date>2013-01-06</date>
/// <param name="groupid">病种组合ID</param>
/// <returns></returns>
public static string GetDiseaseStringByGroupID(int groupid)
{
try
{
//根据组合ID查找ICD集合
List <string> diseaseIDs = GetDiseaseIDsByGroupID(groupid);
if (null == diseaseIDs || diseaseIDs.Count() == 0)
{
return(string.Empty);
}
//将ICD集合拼接成SQL查询的ICD字符串
string idStr = string.Empty;
foreach (string diseaseID in diseaseIDs)
{
string newID = diseaseID;
if (diseaseID.Contains("'"))
{
newID = diseaseID.Replace("'", "");
}
idStr += "'" + newID + "',";
}
if (!string.IsNullOrEmpty(idStr))
{
idStr = idStr.Substring(0, idStr.Length - 1);
}
//查询病种集合
DataTable dt = DS_SqlService.GetDiseasesByICDs(idStr);
if (null == dt || dt.Rows.Count == 0)
{
return(string.Empty);
}
//将病种集合拼接成所需要格式的字符串
string content = string.Empty;
foreach (DataRow drow in dt.Rows)
{
content += drow["NAME"].ToString() + "(" + drow["ICD"].ToString() + ")，";
}
if (!string.IsNullOrEmpty(content))
{
content = content.Substring(0, content.Length - 1);
}
return(content);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
/// <summary>
/// 根据用户ID获取权限内的病种数据集
/// </summary>
/// <auth>Yanqiao.Cai</auth>
/// <date>2013-01-06</date>
/// <param name="userID">用户ID</param>
/// <returns></returns>
public static DataTable GetDiagResourceByUserID(string userID)
{
try
{
if (string.IsNullOrEmpty(userID))
{
return(new DataTable());
}
DataTable groupDt = GetDiseaseGroupsByUserID(userID);
string diseaseIDs = string.Empty;
if (null == groupDt || groupDt.Rows.Count == 0)
{
return(new DataTable());
}
foreach (DataRow drow in groupDt.Rows)
{
string icds = null == drow["diseaseids"] ? "" : drow["diseaseids"].ToString();
List <string> icdList = icds.Split('$').ToList();
if (null == icdList || icdList.Count() == 0)
{
continue;
}
foreach (string str in icdList)
{
diseaseIDs += "'" + str + "',";
}
}
if (!string.IsNullOrEmpty(diseaseIDs))
{
diseaseIDs = diseaseIDs.Substring(0, diseaseIDs.Length - 1);
}
if (string.IsNullOrEmpty(diseaseIDs))
{
new DataTable();
}
return(DS_SqlService.GetDiseasesByICDs(diseaseIDs));
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}