/// <summary> /// 作者登录 /// </summary> /// <param name="loginAuthor"></param> /// <returns></returns> public AuthorInfoEntity AuthorLogin(AuthorInfoQuery queryAuthor) { HttpClientHelper clientHelper = new HttpClientHelper(); AuthorInfoEntity authorEntity = clientHelper.PostAuth<AuthorInfoEntity, AuthorInfoQuery>(GetAPIUrl(APIConstant.AUTHORLOGIN), queryAuthor); if (authorEntity != null) { if (authorEntity.Pwd == WKT.Common.Security.MD5Handle.Encrypt(queryAuthor.Pwd)) { # region 设置该用户的角色列表 RoleAuthorQuery roleAuthorQuery = new RoleAuthorQuery(); roleAuthorQuery.JournalID = queryAuthor.JournalID; roleAuthorQuery.AuthorID = authorEntity.AuthorID; IList<RoleAuthorEntity> roleAuthorList = clientHelper.PostAuth<IList<RoleAuthorEntity>, RoleAuthorQuery>(GetAPIUrl(APIConstant.AUTHORGETROLELIST), roleAuthorQuery); if (roleAuthorList != null && roleAuthorList.Count > 0) { authorEntity.RoleIDList = roleAuthorList.Select(p => p.RoleID).ToList<long>(); authorEntity.RoleID = authorEntity.RoleIDList[0]; } # endregion if (authorEntity.RoleIDList == null) { authorEntity.RoleIDList = new List<long> { -1}; } return authorEntity; } else { return null; } }
/// <summary> /// 获取一个实体对象 /// </summary> /// <param name="mapID"></param> /// <returns></returns> public RoleAuthorEntity GetRoleAuthor(long mapID) { HttpClientHelper clientHelper = new HttpClientHelper(); RoleAuthorQuery roleAuthorQuery = new RoleAuthorQuery(); roleAuthorQuery.MapID = mapID; RoleAuthorEntity roleAuthorEntity = clientHelper.PostAuth<RoleAuthorEntity, RoleAuthorQuery>(GetAPIUrl(APIConstant.GETROLEAUTHORLIST), roleAuthorQuery); return roleAuthorEntity; }
public Pager<RoleAuthorEntity> GetRoleAuthorPageList(RoleAuthorQuery roleAuthorQuery) { IRoleAuthorService service = ServiceContainer.Instance.Container.Resolve<IRoleAuthorService>(); Pager<RoleAuthorEntity> pager = service.GetRoleAuthorPageList(roleAuthorQuery); return pager; }
public IList<RoleAuthorEntity> GetRoleAuthorList(RoleAuthorQuery roleAuthorQuery) { IRoleAuthorService service = ServiceContainer.Instance.Container.Resolve<IRoleAuthorService>(); IList<RoleAuthorEntity> list = service.GetRoleAuthorList(roleAuthorQuery); return list; }
/// <summary> /// 分页获取符合查询条件的数据 /// </summary> /// <param name="roleAuthorQuery">RoleAuthorQuery查询实体对象</param> /// <returns>Pager<RoleAuthorEntity></returns> public Pager<RoleAuthorEntity> GetRoleAuthorPageList(RoleAuthorQuery roleAuthorQuery) { return RoleAuthorBusProvider.GetRoleAuthorPageList(roleAuthorQuery); }
/// <summary> /// 获取所有符合查询条件的数据 /// </summary> /// <param name="roleAuthorQuery">RoleAuthorQuery查询实体对象</param> /// <returns>List<RoleAuthorEntity></returns> public List<RoleAuthorEntity> GetRoleAuthorList(RoleAuthorQuery roleAuthorQuery) { return RoleAuthorBusProvider.GetRoleAuthorList(roleAuthorQuery); }
/// <summary> /// 将查询实体转换为Where语句 /// <param name="query">查询实体</param> /// <returns>获取Where语句,不包含Where</returns> /// </summary> public string RoleAuthorQueryToSQLWhere(RoleAuthorQuery query) { StringBuilder sbWhere = new StringBuilder(" JournalID = " + query.JournalID); if (query.AuthorID != null) { sbWhere.Append(" AND AuthorID = ").Append(query.AuthorID.Value).Append(""); } if (query.RoleID != null) { sbWhere.Append(" AND RoleID = ").Append(query.RoleID.Value).Append(""); } return sbWhere.ToString(); }
/// <summary> /// 将查询实体转换为Order语句 /// <param name="query">查询实体</param> /// <returns>获取Order语句,不包含Order</returns> /// </summary> public string RoleAuthorQueryToSQLOrder(RoleAuthorQuery query) { if (query.OrderStr != null) return query.OrderStr; else return " MapID ASC"; }
public Pager<RoleAuthorEntity> GetRoleAuthorPageList(RoleAuthorQuery query) { int recordCount=0; string whereSQL=RoleAuthorQueryToSQLWhere(query); string orderBy=RoleAuthorQueryToSQLOrder(query); DataSet ds=db.GetPagingData("RoleAuthor","MapID,JournalID,RoleID,AuthorID,AddDate",orderBy,whereSQL,query.CurrentPage,query.PageSize,out recordCount); Pager<RoleAuthorEntity> pager=new Pager<RoleAuthorEntity>(); if(ds!=null && ds.Tables.Count>0) { pager.ItemList= MakeRoleAuthorList(ds.Tables[0]); } pager.CurrentPage=query.CurrentPage; pager.PageSize=query.PageSize; pager.TotalRecords=recordCount; return pager; }
public List<RoleAuthorEntity> GetRoleAuthorList(RoleAuthorQuery query) { List<RoleAuthorEntity> list = new List<RoleAuthorEntity>(); StringBuilder sqlCommandText = new StringBuilder(); sqlCommandText.Append("SELECT MapID,JournalID,RoleID,AuthorID,AddDate FROM dbo.RoleAuthor WITH(NOLOCK)"); string whereSQL = RoleAuthorQueryToSQLWhere(query); string orderBy=RoleAuthorQueryToSQLOrder(query); if(!string.IsNullOrEmpty(whereSQL)) sqlCommandText.Append(" WHERE " + whereSQL); if(!string.IsNullOrEmpty(orderBy)) sqlCommandText.Append(" ORDER BY " + orderBy); DbCommand cmd = db.GetSqlStringCommand(sqlCommandText.ToString()); using(IDataReader dr = db.ExecuteReader(cmd)) { list = MakeRoleAuthorList(dr); } return list; }
public List<RoleAuthorEntity> GetRoleAuthorDetailList(RoleAuthorQuery query) { List<RoleAuthorEntity> list = new List<RoleAuthorEntity>(); StringBuilder sqlCommandText = new StringBuilder(); sqlCommandText.Append(@"SELECT MapID,RA.JournalID,RA.AuthorID,AI.LoginName,AI.RealName,RA.RoleID,RI.RoleName,RA.AddDate FROM dbo.RoleAuthor RA WITH(NOLOCK) LEFT JOIN dbo.AuthorInfo AI WITH(NOLOCK) ON RA.AuthorID=AI.AuthorID AND AI.Status=1 LEFT JOIN dbo.RoleInfo RI WITH(NOLOCK) ON RA.JournalID=RI.JournalID AND RA.RoleID=RI.RoleID "); string whereSQL = RoleAuthorDetailQueryToSQLWhere(query); string orderBy = RoleAuthorQueryToSQLOrder(query); if (!string.IsNullOrEmpty(whereSQL)) sqlCommandText.Append(" WHERE " + whereSQL); if (!string.IsNullOrEmpty(orderBy)) sqlCommandText.Append(" ORDER BY " + orderBy); DbCommand cmd = db.GetSqlStringCommand(sqlCommandText.ToString()); using (IDataReader dr = db.ExecuteReader(cmd)) { list = MakeRoleAuthorDetailList(dr); } return list; }
/// <summary> /// 根据条件获取所有实体对象(包含角色名称) /// </summary> /// <param name="roleAuthorQuery"></param> /// <returns></returns> public IList<RoleAuthorEntity> GetRoleAuthorDetailList(RoleAuthorQuery roleAuthorQuery) { HttpClientHelper clientHelper = new HttpClientHelper(); IList<RoleAuthorEntity> roleAuthorList = clientHelper.PostAuth<IList<RoleAuthorEntity>, RoleAuthorQuery>(GetAPIUrl(APIConstant.GETROLEAUTHORDETAILLIST), roleAuthorQuery); return roleAuthorList; }
public Pager<RoleAuthorEntity> GetRoleAuthorPageList(RoleAuthorQuery roleAuthorQuery) { HttpClientHelper clientHelper = new HttpClientHelper(); Pager<RoleAuthorEntity> RoleAuthorPageList = clientHelper.PostAuth<Pager<RoleAuthorEntity>, RoleAuthorQuery>(GetAPIUrl(APIConstant.GETROLEAUTHORPAGELIST), roleAuthorQuery); return RoleAuthorPageList; }
public IList<RoleAuthorEntity> GetAuthorRoleList(RoleAuthorQuery authorQuery) { try { IRoleAuthorService roleAuthorService = ServiceContainer.Instance.Container.Resolve<IRoleAuthorService>(); IList<RoleAuthorEntity> listAuthor = roleAuthorService.GetRoleAuthorList(authorQuery); return listAuthor; } catch (Exception ex) { LogProvider.Instance.Error("作者登录出现异常:" + ex.Message); throw new HttpResponseException(Request.CreateResponse(HttpStatusCode.ExpectationFailed, ex.Message)); } }
public string RoleAuthorDetailQueryToSQLWhere(RoleAuthorQuery query) { StringBuilder sbWhere = new StringBuilder(" RA.JournalID = " + query.JournalID); if (query.AuthorID != null) { sbWhere.Append(" AND RA.AuthorID = ").Append(query.AuthorID.Value).Append(""); } if (query.RealName != null) { sbWhere.Append(" AND RealName like '%").Append(query.RealName).Append("%'"); } if (query.GroupID != null) { sbWhere.Append(" AND AI.GroupID = ").Append(query.GroupID.Value).Append(""); } if (query.RoleID != null) { sbWhere.Append(" AND RI.RoleID = ").Append(query.RoleID.Value).Append(""); } if (query.RoleID != null) { sbWhere.Append(" AND RA.RoleID = ").Append(query.RoleID.Value).Append(""); } if (query.RoleName != null) { sbWhere.Append(" AND RI.RoleName = ").Append(query.RoleName).Append(""); } return sbWhere.ToString(); }
public ExecResult SetAurhoRole(RoleAuthorEntity roleAuthorEntity) { ExecResult result = new ExecResult(); try { RoleAuthorQuery roleAuthorQuery = new RoleAuthorQuery(); roleAuthorQuery.AuthorID = roleAuthorEntity.AuthorID; roleAuthorQuery.JournalID = roleAuthorEntity.JournalID; roleAuthorQuery.RoleID = roleAuthorEntity.RoleID; IRoleAuthorService roleAuthorService = ServiceContainer.Instance.Container.Resolve<IRoleAuthorService>(); List<RoleAuthorEntity> checkIsExist = roleAuthorService.GetRoleAuthorList(roleAuthorQuery); if (checkIsExist != null && checkIsExist.Count > 0) { result.result = EnumJsonResult.success.ToString(); result.msg = "成功"; } else { bool flag = roleAuthorService.AddRoleAuthor(roleAuthorEntity); if (flag) { result.result = EnumJsonResult.success.ToString(); result.msg = "成功"; } else { result.result = EnumJsonResult.failure.ToString(); result.msg = "设置作者角色失败,请确认作者信息是否正确"; } } } catch (Exception ex) { result.result = EnumJsonResult.error.ToString(); result.msg = "设置作者角色时出现异常:" + ex.Message; } return result; }
/// <summary> /// 获取所有符合查询条件的数据 /// </summary> /// <param name="roleAuthorQuery">RoleAuthorQuery查询实体对象</param> /// <returns>List<RoleAuthorEntity></returns> public List<RoleAuthorEntity> GetRoleAuthorList(RoleAuthorQuery roleAuthorQuery) { return RoleAuthorDataAccess.Instance.GetRoleAuthorList(roleAuthorQuery); }