/// <summary>
/// Loads the users.
/// </summary>
/// <param name="usersList">The users list.</param>
/// <param name="userArgs">The user args.</param>
public void LoadUsers(List <Model.User.User> usersList, UsersArgs userArgs)
{
this.Page = userArgs.Page;
this.TextSearched = userArgs.Text;
this.pUsersList.Controls.Clear();
if (this.Page == 0)
{
this.pagination.DisablePreviousLink();
}
else
{
this.pagination.EnablePreviousLink();
}
if (usersList.Count == 10)
{
this.pagination.EnableNextLink();
}
else
{
this.pagination.DisableNextLink();
}
foreach (Model.User.User user in usersList)
{
UserResult userResult = new UserResult();
userResult.LoadData(user);
userResult.Dock = DockStyle.Top;
userResult.FollowUser += new Delegates.Delegates.FollowUserHandler(userResult_FollowUser);
userResult.OpenUserResults += new Delegates.Delegates.OpenUserResultsHandler(userResult_OpenUserResults);
this.pUsersList.Controls.Add(userResult);
}
}
/// <summary>
/// Searches the text control_ search text.
/// </summary>
/// <param name="sender">The sender.</param>
/// <param name="args">The args.</param>
private void searchTextControl_SearchText(object sender, TextArgs args)
{
this.Page = 0;
this.TextSearched = args.Text;
Args.UsersArgs userArgs = new UsersArgs(args.Text, this.Page, null);
this.SearchText(sender, userArgs);
}
/// <summary>
/// Calls the users tab.
/// </summary>
/// <param name="args">The args.</param>
private void callUsersTab(UsersArgs args)
{
Command command = new Command();
command.Tab = "users";
command.Args = args;
this.Session.FormController.AddCommand(command);
}
/// <summary>
/// Loads the users search.
/// </summary>
/// <param name="args">The args.</param>
public void LoadUsersSearch(UsersArgs args)
{
if (this.tagsPage == null)
{
this.CreateUsersPage();
}
this.usersPage.LoadUsers(userController.SearchUsersByNick(args.Text, 10, args.Page), args);
}
/// <summary>
/// 获取简单集合
/// </summary>
/// <returns></returns>
public List <UsersModel> GetUsersList(Hashtable where)
{
StringBuilder sb = new StringBuilder();
sb.Append("select * from userinfo where 1=1 ");
List <SqlParameter> pms = new List <SqlParameter>();
string condition = string.Empty, orderBy = string.Empty;
if (where != null && where.Count > 0)
{
foreach (DictionaryEntry item in where)
{
UsersArgs key = (UsersArgs)item.Key;
switch (key)
{
case UsersArgs.USERNAME:
sb.Append(" and USERNAME like concat('%',@USERNAME,'%') ");
pms.Add(new SqlParameter("@USERNAME", item.Value));
break;
case UsersArgs.STATUS:
sb.Append(" and STATUS =@STATUS ");
pms.Add(new SqlParameter("@STATUS", item.Value));
break;
case UsersArgs.OrderBy:
orderBy = item.Value.ToString();
break;
default:
break;
}
}
orderBy = where == null ? string.Empty : FGA_NUtility.Convertor.ToString(where[UsersArgs.OrderBy]);
if (!string.IsNullOrEmpty(orderBy))
{
sb.Append("order by " + orderBy);
}
}
DataSet ds = Base.SQLServerHelper.Query(sb.ToString(), pms.ToArray());
if (ds == null || ds.Tables.Count <= 0 || ds.Tables[0].Rows.Count <= 0)
{
return(null);
}
List <UsersModel> list = new List <UsersModel>();
foreach (DataRow row in ds.Tables[0].Rows)
{
list.Add(new UsersModel(row));
}
return(list);
}
/// <summary>
/// Follows the user.
/// </summary>
/// <param name="args">The args.</param>
private void FollowUser(UsersArgs args)
{
try
{
Guid newToken = Guid.Empty;
this.userController.AddFollowRequest(out newToken, Session.User.Id, Session.CurrentToken, Session.User.Id, args.User.Id);
this.Session.CurrentToken = newToken;
}
catch (Exception ex)
{
MessageBox.Show("Error trying to add follow request - " + ex.Message);
}
}
/// <summary>
/// Loads the user publications.
/// </summary>
/// <param name="args">The args.</param>
public void LoadUserPublications(UsersArgs args)
{
if (this.searchPublicationPage == null)
{
this.CreateUsersPublicationsPage(args);
}
Guid newToken = Session.CurrentToken;
this.searchPublicationPage.LoadPublications(publicationController.GetUserPublications(out newToken, Session.User.Id, Session.CurrentToken, args.User.Id, 10, args.Page, true, true));
Session.CurrentToken = newToken;
searchPublicationPage.BringToFront();
searchPublicationPage.Show();
}
/// <summary>
/// Executes the command user.
/// </summary>
/// <param name="command">The command.</param>
private void executeCommandUser(Command command)
{
UsersArgs args = ((UsersArgs)command.Args);
if (args.Text == "" && args.User == null)
{
this.main.CreateUsersPage();
}
else if ((args.User == null) && (args.Text != ""))
{
this.main.LoadUsersSearch(args);
}
else
{
this.main.LoadUserPublications(args);
}
}
/// <summary>
/// Creates the users publications page.
/// </summary>
/// <param name="args">The args.</param>
public void CreateUsersPublicationsPage(UsersArgs args)
{
try
{
this.searchPublicationPage = new PublicationsSearchResult();
this.searchPublicationPage.LoadTitle(args.User);
Guid newToken = Session.CurrentToken;
this.searchPublicationPage.LoadPublications(publicationController.GetUserPublications(out newToken, Session.User.Id, Session.CurrentToken, args.User.Id, 10, args.Page, true, true));
Session.CurrentToken = newToken;
this.searchPublicationPage.Dock = DockStyle.Fill;
this.searchPublicationPage.FollowUser += new Delegates.Delegates.FollowUserHandler(searchPublicationPage_FollowUser);
this.searchPublicationPage.ChangeUsersPage += new PublicationsSearchResult.ChangeUsersPageHandler(searchPublicationPage_ChangeUsersPage);
this.pContent.Controls.Add(searchPublicationPage);
searchPublicationPage.BringToFront();
searchPublicationPage.Show();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
/// <summary>
/// Users the result_ follow user.
/// </summary>
/// <param name="sender">The sender.</param>
/// <param name="args">The args.</param>
void userResult_FollowUser(object sender, UsersArgs args)
{
this.FollowUser(sender, args);
}
/// <summary>
/// Users the result_ open user results.
/// </summary>
/// <param name="sender">The sender.</param>
/// <param name="args">The args.</param>
void userResult_OpenUserResults(object sender, UsersArgs args)
{
this.OpenUserResults(sender, args);
}
/// <summary>
/// Title_s the follow user.
/// </summary>
/// <param name="sender">The sender.</param>
/// <param name="args">The args.</param>
void title_FollowUser(object sender, UsersArgs args)
{
this.FollowUser(sender, args);
}
/// <summary>
/// Handles the LinkClicked event of the lUser control.
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="System.Windows.Forms.LinkLabelLinkClickedEventArgs"/> instance containing the event data.</param>
private void lUser_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
UsersArgs args = new UsersArgs("", 0, this.UserData);
this.OpenUserResults(sender, args);
}
/// <summary>
/// Handles the Click event of the bFollow control.
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="System.EventArgs"/> instance containing the event data.</param>
private void bFollow_Click(object sender, EventArgs e)
{
UsersArgs args = new UsersArgs("", 0, this.UserData);
this.FollowUser(sender, args);
}
/// <summary>
/// Searches the publication page_ follow user.
/// </summary>
/// <param name="sender">The sender.</param>
/// <param name="args">The args.</param>
void searchPublicationPage_FollowUser(object sender, UsersArgs args)
{
this.FollowUser(args);
}
/// <summary>
/// 获取分页
/// </summary>
/// <returns></returns>
/// <summary>
public List <UsersModel> GetUsersListByPage(Hashtable where, SearchArgs args)
{
List <UsersModel> list = new List <UsersModel>();
StringBuilder sb = new StringBuilder();
List <SqlParameter> pms = new List <SqlParameter>();
string condition = string.Empty, orderBy = string.Empty;
condition = " and USERNAME!='administrator' ";
if (where != null)
{
foreach (DictionaryEntry item in where)
{
UsersArgs arg = (UsersArgs)item.Key;
switch (arg)
{
case UsersArgs.USERNAME:
sb.Append(" and USERNAME like @USERNAME ");
pms.Add(new SqlParameter("@USERNAME", "%" + item.Value + "%"));
break;
case UsersArgs.STATUS:
sb.Append(" and STATUS =@STATUS ");
pms.Add(new SqlParameter("@STATUS", item.Value));
break;
case UsersArgs.OrderBy:
orderBy = item.Value.ToString();
break;
default:
break;
}
}
condition = sb.ToString();
sb.Length = 0;
}
//count
sb.AppendLine("select count(1) as totalCount from userinfo where 1=1 ");
sb.AppendLine(condition);
args.TotalRecords = FGA_NUtility.Convertor.ToInt32(Base.SQLServerHelper.Query(sb.ToString(), pms.ToArray()).Tables[0].Rows[0][0]);
if (args.TotalRecords <= 0)
{
return(null);
}
sb.Length = 0;
//query
if (!string.IsNullOrEmpty(orderBy))
{
sb.Append("SELECT * FROM(SELECT ROW_NUMBER()OVER(ORDER BY " + orderBy + " )Indexs,* FROM userinfo where 1=1 ");
}
else
{
sb.Append("SELECT * FROM(SELECT ROW_NUMBER()OVER(ORDER BY USERID DESC)Indexs,* FROM userinfo where 1=1 ");
}
sb.AppendLine(condition);
sb.AppendLine(")Tab WHERE Tab.Indexs BETWEEN (" + args.StartIndex + ")+1 AND " + (args.StartIndex + 1) + "+" + args.PageSize);
DataSet ds = Base.SQLServerHelper.Query(sb.ToString(), pms.ToArray());
if (ds == null || ds.Tables.Count < 0 || ds.Tables[0].Rows.Count < 0)
{
return(null);
}
foreach (DataRow row in ds.Tables[0].Rows)
{
list.Add(new UsersModel(row));
}
return(list);
}
/// <summary>
/// Userses the page_ call next page.
/// </summary>
/// <param name="sender">The sender.</param>
/// <param name="args">The args.</param>
void usersPage_CallNextPage(object sender, UsersArgs args)
{
this.callUsersTab(args);
}
/// <summary>
/// Userses the page_ open user results.
/// </summary>
/// <param name="sender">The sender.</param>
/// <param name="args">The args.</param>
void usersPage_OpenUserResults(object sender, UsersArgs args)
{
this.callUsersTab(args);
}
/// <summary>
/// Userses the page_ search text.
/// </summary>
/// <param name="sender">The sender.</param>
/// <param name="args">The args.</param>
void usersPage_SearchText(object sender, UsersArgs args)
{
this.callUsersTab(args);
}
/// <summary>
/// Pagination_s the call previous page.
/// </summary>
/// <param name="sender">The sender.</param>
/// <param name="args">The args.</param>
private void pagination_CallPreviousPage(object sender, PageArgs args)
{
this.Page = args.Page;
Args.UsersArgs userArgs = new UsersArgs(this.TextSearched, args.Page, null);
this.CallPreviousPage(sender, userArgs);
}
/// <summary>
/// Searches the publication page_ change users page.
/// </summary>
/// <param name="sender">The sender.</param>
/// <param name="args">The args.</param>
void searchPublicationPage_ChangeUsersPage(object sender, UsersArgs args)
{
this.callUsersTab(args);
}
/// <summary>
/// Userses the page_ follow user.
/// </summary>
/// <param name="sender">The sender.</param>
/// <param name="args">The args.</param>
void usersPage_FollowUser(object sender, UsersArgs args)
{
this.FollowUser(args);
}
