public Result <List <ArticleDTO> > GetIndexArticleList(int count, int userID) { var exp = DbUtilityFactory.GetDbUtility().GetSqlExpression <ArticleEntity>(); exp.Where(a => a.userID == userID); exp.OrderByDescending(a => a.articleDate); var data = DbUtilityFactory.GetDbUtility().Paged <ArticleEntity>(a => a.articleDate, 1, 6); if (data.Any()) { return(new Result <List <ArticleDTO> >() { IsSuccess = true, ReturnMessage = "成功", ReturnValue = data.Select <ArticleEntity, ArticleDTO>(a => new ArticleDTO() { articleAbstract = a.articleAbstract, articleDate = a.articleDate, articleID = a.articleID, articleTitle = a.articleTitle }).ToList() }); } else { return(new Result <List <ArticleDTO> >() { IsSuccess = false, ReturnMessage = "没有记录" }); } }
public Result <int> AddNewArticle(ArticleDTO dto) { var result = DbUtilityFactory.GetDbUtility().Add(new ArticleEntity() { categoryID = dto.categoryID, articleAbstract = dto.articleAbstract, articleContain = dto.articleContain, articleCopyright = dto.articleCopyright, articleDate = DateTime.Now, articleTitle = dto.articleTitle, userID = dto.userID }); if (result > 0) { return(new Result <int>() { ReturnMessage = "添加成功", IsSuccess = true, ReturnValue = result }); } else { return(new Result <int>() { ReturnMessage = "添加失败", IsSuccess = false, ReturnValue = result }); } }
public Result <string> GetCategoryNameByArticleID(int articleID) { var exp = DbUtilityFactory.GetDbUtility().GetSqlExpression <CategoryEntity>(); exp.LeftJoin <ArticleEntity>((a, b) => a.categoryID == b.categoryID); exp.Where <ArticleEntity>(a => a.articleID == articleID); var data = DbUtilityFactory.GetDbUtility().GetList(exp); if (data == null) { return(new Result <string>() { IsSuccess = false, ReturnMessage = "出现错误" }); } if (data.Any()) { return(new Result <string>() { IsSuccess = true, ReturnMessage = "成功", ReturnValue = data.First().categoryName }); } else { return(new Result <string>() { IsSuccess = false, ReturnMessage = "没有找到栏目名称" }); } }
public Result <ArticleDTO> GetArticleByArticleID(int articleID) { var data = DbUtilityFactory.GetDbUtility().GetSingle <ArticleEntity>(a => a.articleID == articleID); if (data != null) { return(new Result <ArticleDTO>() { IsSuccess = true, ReturnMessage = "成功", ReturnValue = new ArticleDTO() { articleAbstract = data.articleAbstract, articleContain = data.articleContain, articleCopyright = data.articleCopyright, articleDate = data.articleDate, articleID = articleID, articleTitle = data.articleTitle, categoryID = data.categoryID, categoryName = LocalServiceLocator.GetService <IMyBlogService>().GetCategoryNameByCategoryID(data.categoryID).ReturnValue, userID = data.userID } }); } else { return(new Result <ArticleDTO>() { IsSuccess = false, ReturnMessage = "没有找到文章" }); } }
public Result<int> AddProject(ProjectDTO projectDTO) { var result = DbUtilityFactory.GetDbUtility().Add(new ProjectEntity() { projectName = projectDTO.projectName, userID = projectDTO.userID }); if(result == 1) { return new Result<int>() { IsSuccess = true, ReturnValue = result, ReturnMessage = "添加成功" }; }else { return new Result<int>() { IsSuccess = false, ReturnMessage = "添加失败" }; } }
public Result <UserInfoDTO> CheckUser(string passport) { var userNameMd5 = passport.Substring(0, 32); var passwordMd5 = passport.Substring(32); var userInfo = DbUtilityFactory.GetDbUtility().GetSingle <UserEntity>(a => a.userNameMd5 == userNameMd5); if (userInfo != null && userInfo.passwordMd5 == passwordMd5) { return(new Result <UserInfoDTO>() { IsSuccess = true, ReturnValue = new UserInfoDTO() { cookiePassport = userInfo.userNameMd5 + userInfo.passwordMd5, userName = userInfo.userName, userID = userInfo.userID, userLevel = userInfo.userLevel, nickName = userInfo.nickName } }); } else { return(new Result <UserInfoDTO>() { IsSuccess = false, ReturnMessage = "登录失效,请重新登录" }); } }
public Result <UserInfoDTO> GetUserObj(int userID) { var userInfo = DbUtilityFactory.GetDbUtility().GetSingle <UserEntity>(a => a.userID == userID); if (userID != 0 && userInfo != null) { return(new Result <UserInfoDTO>() { IsSuccess = true, ReturnValue = new UserInfoDTO() { nickName = userInfo.nickName, userID = userInfo.userID, userLevel = userInfo.userLevel, userName = userInfo.userName } }); } else { return(new Result <UserInfoDTO>() { IsSuccess = false, ReturnMessage = "没有找到此userID的记录" }); } }
/// <summary> /// 添加栏目 /// </summary> /// <param name="dto"></param> /// <returns>成功返回"成功",失败返回"添加失败",成功与否都会返回受影响条数</returns> public Result <int> AddCategory(CategoryDTO dto) { var result = DbUtilityFactory.GetDbUtility().Add <CategoryEntity>(new CategoryEntity() { categoryName = dto.categoryName, projectID = dto.projectID, userID = dto.userID }); if (result == 1) { return(new Result <int>() { IsSuccess = true, ReturnMessage = "成功", ReturnValue = result }); } else { return(new Result <int>() { IsSuccess = false, ReturnMessage = "添加失败", ReturnValue = result }); } }
public Result <int> EditArticle(ArticleDTO dto) { var result = DbUtilityFactory.GetDbUtility().Update(new ArticleEntity() { articleID = dto.articleID, articleAbstract = dto.articleAbstract, articleContain = dto.articleContain, articleCopyright = dto.articleCopyright, articleDate = DateTime.Now, articleTitle = dto.articleTitle, categoryID = dto.categoryID, userID = dto.userID }, a => a.articleID == dto.articleID); if (result == 1) { return(new Result <int>() { ReturnMessage = "修改成功", IsSuccess = true, ReturnValue = result }); } else { return(new Result <int>() { ReturnMessage = "修改失败", IsSuccess = false, ReturnValue = result }); } }
public Result <List <MenuDTO> > GetMenu(int userID) { var pexp = DbUtilityFactory.GetDbUtility().GetSqlExpression <ProjectEntity>(); pexp.Where(a => a.userID == userID); var projects = DbUtilityFactory.GetDbUtility().GetList(pexp); var menuList = new List <MenuDTO>(); foreach (var i in projects) { var cexp = DbUtilityFactory.GetDbUtility().GetSqlExpression <CategoryEntity>(); var projectID = i.projectID; cexp.Where(a => a.projectID == projectID); var categories = DbUtilityFactory.GetDbUtility().GetList(cexp); menuList.Add(new MenuDTO() { projectID = i.projectID, projectName = i.projectName, categoryList = categories.Select <CategoryEntity, MenuItemDTO>(a => new MenuItemDTO() { categoryID = a.categoryID, categoryName = a.categoryName }).ToList() }); } return(new Result <List <MenuDTO> >() { IsSuccess = true, ReturnValue = menuList, ReturnMessage = "成功" }); }
public void ReturnsSqlString3_ShouldReturnTrue() { var expectedResult = "SELECT * FROM [Article] WHERE (Article.UserId = '1' ) "; var exp = DbUtilityFactory.GetDbUtility().GetSqlExpression <ArticleEntity>(); exp.Where(a => a.ArticleDate == DateTime.Now); var result = $"SELECT * FROM [{ exp.TableName }] WHERE { exp.WhereStr }"; Assert.AreEqual(expectedResult, result); }
public void ReturnsSqlSortString_ShouldReturnTrue() { var expectedResult = "SELECT * FROM [Article] ORDER BY Article.ArticleDate DESC "; var exp = DbUtilityFactory.GetDbUtility().GetSqlExpression <ArticleEntity>(); exp.OrderByDescending(a => a.ArticleDate); var result = $"SELECT * FROM [{ exp.TableName }] ORDER BY { exp.OrderByStr }"; Assert.AreEqual(expectedResult, result); }
public Result <int> Register(RegisterDTO registerInfo) { #region 参数判断 if (string.IsNullOrEmpty(registerInfo.nickName)) { return(new Result <int>() { IsSuccess = false, ReturnMessage = "昵称不能为空", }); } if (string.IsNullOrEmpty(registerInfo.userName)) { return(new Result <int>() { IsSuccess = false, ReturnMessage = "用户名不能为空", }); } if (string.IsNullOrEmpty(registerInfo.password)) { return(new Result <int>() { IsSuccess = false, ReturnMessage = "密码不能为空", }); } #endregion #region 判重 var data = DbUtilityFactory.GetDbUtility().GetSingle <UserEntity>(a => a.userName == registerInfo.userName); if (data != null) { return(new Result <int>() { IsSuccess = false, ReturnMessage = "该用户名已存在" }); } #endregion var user = new UserEntity() { nickName = registerInfo.nickName, userLevel = 1, userName = registerInfo.userName, passwordMd5 = Security.GetMD5(registerInfo.password), userNameMd5 = Security.GetMD5(registerInfo.userName) }; return(new Result <int>() { IsSuccess = true, ReturnMessage = "注册成功", ReturnValue = DbUtilityFactory.GetDbUtility().Add <UserEntity>(user) }); }
public void LogIoCStartEventToDb(string str) { var exp = new ServerEventLogEntity() { description = str, eventLevel = EnumBigEventType.ServerInfo.GetDescription(), type = EnumServerInfoType.IoC.GetDescription(), time = DateTime.Now }; DbUtilityFactory.GetDbUtility().Add(exp); }
public void LogRequestToDb(HttpRequestMessage r, string responseStr, int operatorID = -999) { var exp = new RequestLogEntity() { method = r.Method.Method, url = r.RequestUri.ToString(), operatorID = operatorID, time = DateTime.Now, response = responseStr }; DbUtilityFactory.GetDbUtility().Add(exp); }
public void LogErrorToDb(Exception e, int operatorID = -999) { var exp = new ServerEventLogEntity() { description = e.Message, thread = e.Source, time = DateTime.Now, type = e.GetType().Name, eventLevel = EnumBigEventType.Exception.GetDescription(), operatorID = operatorID }; DbUtilityFactory.GetDbUtility().Add(exp); }
public Result <ArticleListDTO> GetArticleListByCategoryID(int categoryID) { var exp = DbUtilityFactory.GetDbUtility().GetSqlExpression <ArticleEntity>(); exp.Where(a => a.categoryID == categoryID); var data = DbUtilityFactory.GetDbUtility().GetList(exp); if (data == null) { return(new Result <ArticleListDTO>() { IsSuccess = false, ReturnMessage = "出现错误" }); } if (!data.Any()) { return(new Result <ArticleListDTO>() { IsSuccess = true, ReturnMessage = "没有找到记录", ReturnValue = new ArticleListDTO() { categoryID = categoryID, categoryName = GetCategoryNameByCategoryID(categoryID).ReturnValue } }); } else { return(new Result <ArticleListDTO>() { IsSuccess = true, ReturnMessage = "成功", ReturnValue = new ArticleListDTO() { categoryID = categoryID, categoryName = GetCategoryNameByCategoryID(categoryID).ReturnValue, ArticleList = data.Select <ArticleEntity, ArticleListItemDTO>(a => new ArticleListItemDTO() { articleCopyright = a.articleCopyright, articleDate = a.articleDate, articleID = a.articleID, articleTitle = a.articleTitle }).ToList() } }); } }
public Result<int> DeleteProject(int projectID) { var result = DbUtilityFactory.GetDbUtility().Delete<ProjectEntity>(a => a.projectID == projectID); if (result == 1) { return new Result<int>() { IsSuccess = true, ReturnValue = result, ReturnMessage = "删除成功" }; } else { return new Result<int>() { IsSuccess = false, ReturnMessage = "删除失败" }; } }
public Result <string> GetCategoryNameByCategoryID(int categoryID) { var result = DbUtilityFactory.GetDbUtility().Scala <CategoryEntity, string>(a => a.categoryName, a => a.categoryID == categoryID); if (!String.IsNullOrEmpty(result)) { return(new Result <string>() { IsSuccess = true, ReturnMessage = "成功", ReturnValue = result }); } else { return(new Result <string>() { IsSuccess = false, ReturnMessage = "没有找到栏目名称" }); } }
public Result <UserInfoDTO> CheckLogin(string userName, string password) { if (string.IsNullOrEmpty(userName) || string.IsNullOrEmpty(password)) { return(new Result <UserInfoDTO>() { IsSuccess = false, ReturnMessage = "登录失败,用户名或密码不能为空" }); } var userInfo = DbUtilityFactory.GetDbUtility().GetSingle <UserEntity>(a => a.userName == userName); var passwordMd5 = Security.GetMD5(password); if (userInfo == null || userInfo.passwordMd5 != passwordMd5) { return(new Result <UserInfoDTO>() { IsSuccess = false, ReturnMessage = "登录失败,用户名或密码错误" }); } else { return(new Result <UserInfoDTO>() { IsSuccess = true, ReturnMessage = "成功", ReturnValue = new UserInfoDTO() { cookiePassport = userInfo.userNameMd5 + userInfo.passwordMd5, userName = userName, userID = userInfo.userID, userLevel = userInfo.userLevel, nickName = userInfo.nickName } }); } }
public Result <int> DeleteCategroy(int categroyID) { var result = DbUtilityFactory.GetDbUtility().Delete <CategoryEntity>(a => a.categoryID == categroyID); if (result == 1) { return(new Result <int>() { IsSuccess = true, ReturnMessage = "成功", ReturnValue = result }); } else { return(new Result <int>() { IsSuccess = false, ReturnMessage = "删除失败", ReturnValue = result }); } }
public void AssSignalRecord_ShouldReturnTrue() { var expectedResult = "SELECT * FROM [Article] ORDER BY Article.ArticleDate DESC "; var article = new ArticleEntity { ArticleId = 1, //分类ID CategoryId = 1, //文章标题 ArticleTitle = "test", //文章版权 ArticleCopyright = "test", //文章创建时间 ArticleDate = DateTime.Now, //文章摘要 ArticleAbstract = "test", //文章内容 ArticleContain = "test", //文章所属User UserId = 1 }; var exp = DbUtilityFactory.GetDbUtility().Add(article); }
public Result <int> DeleteArticleByArticleID(int articleID) { var result = DbUtilityFactory.GetDbUtility().Delete <ArticleEntity>(a => a.articleID == articleID); if (result == 1) { return(new Result <int>() { ReturnMessage = "删除成功", IsSuccess = true, ReturnValue = result }); } else { return(new Result <int>() { ReturnMessage = "删除失败", IsSuccess = false, ReturnValue = result }); } }