public UserInfoData GetUserInfoByUserID(string userId)
{
SQL sql = SqlHelper.CreateSQL("根据用户ID查询影像用户信息", "select 用户ID,系统账号, 用户名称, 职称级别, 账号信息, 人员信息, 人员照片, 签名图片,变更日志 from 影像用户信息 where 用户ID=:用户ID");
sql.AddParameter("用户ID", System.Data.DbType.String, userId);
DataTable dtUser = _dbHelper.ExecuteSQL(sql);
if (dtUser == null || dtUser.Rows.Count <= 0)
{
return(null);
}
UserInfoData result = new UserInfoData();
result.BindRowData(dtUser.Rows[0]);
return(result);
}
/// <summary>
/// 根据名称获取用户信息
/// </summary>
/// <param name="userName"></param>
/// <param name="departmentId"></param>
/// <returns></returns>
public UserInfoData GetUserInfoByUserName(string userName, string departmentId)
{
SQL sql = SqlHelper.CreateSQL("根据用户账号查询影像用户信息", "select a.用户ID,a.系统账号, a.用户名称, a.职称级别, a.账号信息, a.人员信息, a.人员照片, a.签名图片,a.变更日志 " +
" from 影像用户关联 a, 影像用户信息 b where a.用户ID=b.用户ID and a.科室ID=:科室ID and b.用户名称=:用户名称");
sql.AddParameter("用户名称", System.Data.DbType.String, userName);
sql.AddParameter("科室ID", System.Data.DbType.String, departmentId);
DataTable dtUser = _dbHelper.ExecuteSQL(sql);
if (dtUser == null || dtUser.Rows.Count <= 0)
{
return(null);
}
UserInfoData result = new UserInfoData();
result.BindRowData(dtUser.Rows[0]);
return(result);
}