/// <summary> /// 获取用户的信息 /// </summary> public UserInfoTO GetUserInfoByCode(string userCode) { //string strsql = string.Format("select u.userId,u.username,u.userCode,u.headimg,u.departmentid,u.posiid,d.rolename,p.name from UserInfo u,Department d ,position p where u.DepartmentId=d.Id and u.PosiId=p.id and u.UserCode='{0}'", userCode); //DataTable dt = SqlHelper.Query(strsql.ToString()).Tables[0]; //return dt; UserInfoTO to = new UserInfoTO(); var user = linqHelper.GetEntity <UserInfo>(l => l.UserCode == userCode); if (user != null && user.UserID > 0) { to.DepartmentId = user.DepartmentId; to.HeadImg = user.HeadImg; to.IsAdmin = user.IsAdmin; to.PosiId = user.PosiId; to.UserCode = user.UserCode; to.UserID = user.UserID; to.UserName = user.UserName; //to.UserStatus = user.UserStatus; var dep = linqHelper.GetEntity <Department>(l => l.Id == user.DepartmentId); to.DepName = (dep != null && dep.Id > 0) ? dep.RoleName : ""; var posi = linqHelper.GetEntity <Position>(l => l.Id == user.PosiId); to.PosiName = (posi != null && posi.Id > 0) ? posi.Name : ""; } return(to); }
public UserInfoTO GetUserInfo(string userName) { var cacheItem = ApplicationCache <UserInfoTO> .GetCacheItem(d => d.UserName == userName); if (cacheItem != null) { return(cacheItem); } var user = _authRepository.FindUserByUserName(userName); if (user != null) { var userRoles = _authRepository.GetUserRoles(user.UserName); UserInfoTO userInfo = new UserInfoTO { Id = user.Id, UserName = user.UserName, Email = user.Email, Roles = userRoles }; ApplicationCache <UserInfoTO> .AddCacheItem(userInfo); return(userInfo); } return(null); }
public bool ChangeEmail(ChangeEmailTO emailDetails) { using (var scope = new TransactionScope(TransactionScopeAsyncFlowOption.Enabled)) { var result = _authRepository.ChangeEmail(emailDetails.OldEmail, emailDetails.NewEmail); if (result) { scope.Complete(); var cacheItem = ApplicationCache <UserInfoTO> .GetCacheItem(d => d.Email == emailDetails.OldEmail); if (cacheItem != null) { var newCacheItem = new UserInfoTO() { Id = cacheItem.Id, Email = emailDetails.NewEmail, UserName = cacheItem.UserName, Roles = cacheItem.Roles }; ApplicationCache <UserInfoTO> .RemoveCacheItem(cacheItem); ApplicationCache <UserInfoTO> .AddCacheItem(newCacheItem); } return(true); } return(false); } }
/// <summary> /// 用户列表 /// </summary> private void ShowUserAll() { int numPerPage = 10;//每页显示数量 string orderBy = " UserID desc "; int totalCount = 0; UserInfoBLL bll = new UserInfoBLL(); UserInfoTO sto = new UserInfoTO(); sto.UserCode = txtUsere.Text.Trim(); sto.UserName = txtTrueName.Text.Trim(); if (ddlDep.SelectedValue != "") { sto.DepartmentId = Convert.ToInt32(ddlDep.SelectedValue); } DataTable dt = bll.GetUserInfoList(sto, AspNetPager1.CurrentPageIndex, numPerPage, orderBy, out totalCount, ""); StringBuilder sb = new StringBuilder(); if (dt != null && dt.Rows.Count > 0) { AspNetPager1.RecordCount = totalCount; AspNetPager1.PageSize = numPerPage; for (int i = 0; i < dt.Rows.Count; i++) { DataRow dr = dt.Rows[i]; sb.AppendFormat("<tr><td align='center'>{0}</td>", i + 1 * (numPerPage * (AspNetPager1.CurrentPageIndex - 1) + 1)); sb.AppendFormat("<td align='center'>{0}</td>", dr["UserCode"]); sb.AppendFormat("<td align='center'style='width:75px;'>{0}</td>", dr["UserName"]); sb.AppendFormat("<td align='center'style='width:75px;'>{0}</td>", dr["Name"]); sb.AppendFormat("<td align='center'style='width:75px;'>{0}</td>", dr["RoleName"]); sb.AppendFormat("<td align='center' style='width:70px;'>{0}</td>", PublicEnum.GetEnumDescription <PublicEnum.PublicIsVindicate>(dr["IsAdmin"].ToString())); if (Convert.ToInt32(dr["UserStatus"]) == 1) { sb.AppendFormat("<td align='center'style='width:70px;'>{0}</td>", PublicEnum.GetEnumDescription <PublicEnum.PublicStatus>(dr["UserStatus"].ToString())); } else { sb.AppendFormat("<td align='center'style='width:70px;color:Red;'>{0}</td>", PublicEnum.GetEnumDescription <PublicEnum.PublicStatus>(dr["UserStatus"].ToString())); } if (dr["EntyTime"] is DBNull) { sb.AppendFormat("<td align='center'>{0}</td>", ""); } else { sb.AppendFormat("<td align='center'>{0}</td>", Convert.ToDateTime(dr["EntyTime"]).ToString("yyyy-MM-dd")); } sb.AppendFormat("<td align='center'>{0}</td>", dr["Tel"]); sb.AppendFormat("<td align='center' style='width:160px;'>{0}</td>", dr["Email"]); sb.AppendFormat("<td align='center'><a href='UpdateUser.aspx?userID={0}'>修 改</a>     <a href='javascript:;' onclick='delUser({0})' >禁 用</a></td>", dr["UserID"]); sb.Append("</tr>"); } } UserList = sb.ToString(); }
/// <summary> /// 获取实体分页 /// </summary> public DataTable GetUserInfoList(UserInfoTO TO, int pageIndex, int pageSize, string orderBy, out int rowCount) { string table = " [UserInfo] "; string pk = " ID "; string fields = " * "; string filter = " UserStatus=1 ";// string.Format(" Status={0} ", ConstantsManager.JiLuZhuangTai.Normal); #region 组织查询条件 if (!string.IsNullOrEmpty(TO.UserName)) { filter += string.Format(" and UserName like '%{0}%' ", StringHelper.SQLFilter(TO.UserName)); } if (!string.IsNullOrEmpty(TO.UserCode)) { filter += string.Format(" and UserCode like '%{0}%' ", StringHelper.SQLFilter(TO.UserCode)); } if (TO.DepartmentId != null && TO.DepartmentId != 0) { filter += string.Format(" and DepartmentId={0} ", StringHelper.SQLFilter(TO.DepartmentId.ToString())); } #endregion string sort = " ID DESC ";//排序 if (!string.IsNullOrEmpty(orderBy)) { sort = orderBy; } SqlParameter[] parameters = { new SqlParameter("@Tables", SqlDbType.VarChar, 1000), new SqlParameter("@PK", SqlDbType.VarChar, 100), new SqlParameter("@Fields", SqlDbType.VarChar, 1000), new SqlParameter("@Pageindex", SqlDbType.Int), new SqlParameter("@PageSize", SqlDbType.Int), new SqlParameter("@Filter", SqlDbType.VarChar, 1000), new SqlParameter("@Sort", SqlDbType.VarChar, 200), new SqlParameter("@RowCount", SqlDbType.Int) }; parameters[0].Value = table; parameters[1].Value = pk; parameters[2].Value = fields; parameters[3].Value = pageIndex; parameters[4].Value = pageSize; parameters[5].Value = filter; parameters[6].Value = sort; parameters[7].Direction = ParameterDirection.Output; DataSet ds = SqlHelper.RunProcedure("SP_DividePage", parameters, "UserInfoList"); rowCount = (int)parameters[7].Value; return(ds.Tables[0]); }
/// <summary> /// 自定义获得数据列表分页 /// </summary> /// <returns></returns> public DataTable GetUserInfoList(UserInfoTO TO, int pageIndex, int pageSize, string orderBy, out int rowCount, string str) { return(service.GetUserInfoList(TO, pageIndex, pageSize, orderBy, out rowCount, "")); }