public static UserInfo GetUserInfo(string email, HttpContext context)
{
SqlParameter[] param = { CreateInParam("@EMail", SqlDbType.VarChar, 20, email) };
SqlCommand cmd = GetSpCommand("UUI_GetUserInfo", param);
SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection);
UserInfo userInfo = UserInfo.CreateUser(email);
try
{
if (reader.Read())
{
fillUserInfo(reader, userInfo);
context.Session[AuthenticateConst.SESSION_USERINFO] = userInfo;
}
return(userInfo);
}
catch (Exception ex)
{
throw new UmcException("회원 정보를 가져오는 중 에러", ex);
}
finally
{
reader.Close();
ReleaseCommand(cmd);
}
}
/// <summary>
/// 회원 정보를 가져온다.
/// </summary>
/// <param name="context"></param>
/// <returns></returns>
public UserInfo GetUserInfo(HttpContext context)
{
HttpSessionState session = context.Session;
UserInfo userInfo = (UserInfo)session[AuthenticateConst.SESSION_USERINFO];
if (userInfo == null)
{
userInfo = UserInfo.CreateUser(null);
session[AuthenticateConst.SESSION_USERINFO] = userInfo;
}
return(userInfo);
}
/// <summary>
/// 회원 리스트 가져오기
/// </summary>
/// <param name="currentPage"></param>
/// <param name="pageSize"></param>
/// <param name="searchKeyword"></param>
/// <param name="searchString"></param>
/// <returns></returns>
public static UserInfoBindModel GetUserList(int currentPage, int pageSize, string searchKeyword, string searchString)
{
SqlParameter[] param =
{
CreateInParam("@CurrentPage", SqlDbType.Int, 4, currentPage),
CreateInParam("@PageSize", SqlDbType.Int, 4, pageSize),
CreateInParam("@SearchKeyword", SqlDbType.VarChar, 20, searchKeyword),
CreateInParam("@SearchString", SqlDbType.VarChar, 20, searchString)
};
SqlCommand cmd = GetSpCommand("UBU_GetUserList", param);
SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection);
UserInfoBindModel bindModel = new UserInfoBindModel();
try
{
if (reader.Read())
{
bindModel.TotalCount = (int)reader["TotalCount"];
}
if (!reader.NextResult())
{
return(bindModel);
}
while (reader.Read())
{
UserInfo model = UserInfo.CreateUser((string)reader["Email"]);
fillUserInfo(reader, model);
bindModel.Add(model);
model = null;
}
return(bindModel);
}
finally
{
ReleaseCommand(cmd);
}
}
