/// <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);
}
}
private void bind()
{
bindModel = Authenticator.GetInstance().GetUserList(
Pager.CurrentPageIndex,
PageSize,
SearchKeyword,
SearchString );
num = bindModel.TotalCount - ( Pager.CurrentPageIndex * PageSize );
Pager.RecordCount = bindModel.TotalCount;
Pager.PageSize = PageSize;
dlList.DataSource = bindModel;
dlList.DataBind();
}
/// <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);
}
}
