/// <summary>
/// .ctor
/// </summary>
public QCTimeExternal()
{
try
{
DS_SqlHelper.CreateSqlHelperByDBNameFormDA("EMRDB");
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// .ctor
/// </summary>
public QCTimeLimitInnerService()
{
try
{
DS_SqlHelper.CreateSqlHelperByDBNameFormDA("EMRDB");
// .CreateSqlHelperByDBNameFormDA("EMRDB");
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 获得配置数据的结果集
/// </summary>
/// <returns></returns>
public static DataTable GetConfigDataResult(QCCondition condition)
{
try
{
DS_SqlHelper.CreateSqlHelperByDBNameFormDA(condition.DBLink);
DataTable dtConfigResult = DS_SqlHelper.ExecuteDataTable(GetSqlByQCCondition(condition), CommandType.Text);
DS_SqlHelper.CreateSqlHelperByDBNameFormDA("EMRDB");
CheckConfigResult(dtConfigResult, condition.PatNoColumnName);
#region【特殊处理】如果连接的不是电子病历的数据库，需要通过病人流水号得到电子病历中的首页序号inpatient .noofinpat
if (condition.DBLink != c_EMRDB)
{
//通过病人流水号获得病人首页序号
List <string> patNoList = new List <string>();
string patNos = string.Empty;
foreach (DataRow dr in dtConfigResult.Rows)
{
string patNo = dr[condition.PatNoColumnName].ToString();
if (!patNoList.Contains(patNo))
{
patNoList.Add(patNo);
patNos += "'" + patNo + "',";
}
}
patNos = patNos.Trim(',');
DataTable dtInpatient = DS_SqlHelper.ExecuteDataTable(string.Format(c_SqlInpatient, patNos), CommandType.Text);
//把病人流水号替换为病人首页序号
foreach (DataRow dr in dtConfigResult.Rows)
{
string patNo = dr[condition.PatNoColumnName].ToString();
DataRow drPat = (from DataRow drInpatient in dtInpatient.Rows
where drInpatient["patnoofhis"].ToString() == patNo
select drInpatient).FirstOrDefault();
if (drPat != null)
{
dr[condition.PatNoColumnName] = drPat["noofinpat"].ToString();
}
}
}
#endregion
return(dtConfigResult);
}
catch (Exception ex)
{
throw ex;
}
}
