/// <summary>
/// 通过患者识别码查找患者
/// </summary>
/// <param name="patientCode"></param>
/// <returns></returns>
public PatientData GetPatientByPatientCode(string patientCode)
{
SQL sql = CreateSQL("根据患者识别码查询患者信息", "select 患者ID, 患者识别码,姓名,身份证号,患者信息,患者关联ID,删除标记 " +
" from 影像患者信息 where 患者识别码=:患者识别码");
sql.AddParameter("患者识别码", patientCode);
DataTable dtPatient = sql.ExecuteSql();
if (dtPatient == null || dtPatient.Rows.Count <= 0)
{
return(null);
}
PatientData patiData = new PatientData();
patiData.BindRowData(dtPatient.Rows[0]);
return(patiData);
}
/// <summary>
/// 新建一个患者
/// </summary>
/// <param name="patData"></param>
/// <returns></returns>
public bool NewPatient(PatientData patData)
{
////新建患者之前，先查询是新建还是修改
//sql = CreateSQL("查询患者是否存在", "select count(患者ID) from 影像患者信息 where 患者ID = :患者ID");
//sql.AddParameter("患者ID", DbType.String, patData.患者ID);
//string strHere = _dbHelper.ExecuteSQLOneOutput(sql).ToString();
//if (strHere == "1")
//{
// return UpdatePatient(patData);
//}
SQL sql = CreateSQL("插入患者信息", "insert into " +
" 影像患者信息(患者id, 患者识别码, 姓名, 身份证号, 患者信息, 患者关联id, 删除标记) " +
" values " +
" (:患者id,:患者识别码,:姓名,:身份证号,:患者信息,:患者关联id,:删除标记)");
SqlParamInfo[] sqlPars = GetPatientPars(patData);
sql.AddParameterRange(sqlPars);
DataTable dtResult = sql.ExecuteSql();
return(true);
}