/// <summary> /// 更新分类 /// </summary> public string EditCategory(Category category) { string result = "更新失败"; var conn = DBRepository.GetSqlConnection(); try { conn.Open(); if (category != null) { if (!string.IsNullOrEmpty(category.Title) && !string.IsNullOrEmpty(category.Name) && category.OrderNumber > 0) { if (DBRepository.Update<Category>(category, "Id", conn)) { result = "success"; } } } else { result = "category对象为空"; LogService.Log("CategoryService.EditCategory", "category对象为空"); } } catch (Exception e) { result = "程序出现异常,详情见日志"; LogService.Log("更新分类", e.ToString()); } finally { conn.Close(); } return result; }
/// <summary> /// 根据Id查询分类 /// </summary> /// <param name="id">分类Id</param> /// <returns>分类对象</returns> public Category GetCategoryById(string id) { Category album = new Category(); var conn = DBRepository.GetSqlConnection(); try { conn.Open(); album = DBRepository.SelectOne<Category>("Id='" + id + "'", conn); } catch (Exception e) { LogService.Log("查询分类", e.ToString()); } finally { conn.Close(); } return album; }