/// <summary> /// 分页查询 /// </summary> /// <returns></returns> public String SelectByPage(int limit, int start) { int total; List <VArtCategory> artCategorys = new BLArtCategory().Select(limit, start, new HashTableExp(), out total, ""); return(JsonConvert.JavaScriptSerializer(new ExtGridRecord(artCategorys, total))); }
/// <summary> /// 新增 /// </summary> /// <param name="artCategory"></param> /// <returns></returns> public String Add(ArtCategory artCategory) { try { artCategory.CatId = Guid.NewGuid().ToString(); artCategory.UpdateBy = artCategory.CreateBy = CurrentUser.Id; artCategory.UpdateTime = artCategory.CreateTime = DateTime.Now; int result = new BLArtCategory().Add(artCategory); if (result > 0) { return(JsonConvert.JavaScriptSerializer(new ExtResult() { success = true, msg = "新增成功" })); } else { return(JsonConvert.JavaScriptSerializer(new ExtResult() { success = false, msg = "新增失败" })); } } catch (Exception ex) { return(JsonConvert.JavaScriptSerializer(new ExtResult() { success = false, msg = "新增失败,失败原因:" + ex.Message })); } }
/// <summary> /// 修改 /// </summary> /// <param name="artCategory"></param> /// <returns></returns> public String Update(ArtCategory artCategory) { try { int result = new BLArtCategory().Update(artCategory); if (result > 0) { return(JsonConvert.JavaScriptSerializer(new ExtResult() { success = true, msg = "修改成功" })); } else { return(JsonConvert.JavaScriptSerializer(new ExtResult() { success = false, msg = "修改失败" })); } } catch (Exception ex) { return(JsonConvert.JavaScriptSerializer(new ExtResult() { success = false, msg = "修改失败,失败原因:" + ex.Message })); } }
/// <summary> /// 删除 /// </summary> /// <param name="ids">Id的集合,如1,2,3</param> /// <returns></returns> public String Delete(String ids) { int num = new BLArtCategory().Delete(ids); return(JsonConvert.JavaScriptSerializer(new ExtResult() { success = true, msg = "成功删除" + num + "条数据" })); }
/// <summary> /// 查询顶级(父级编号为0)的模块 /// </summary> /// <returns></returns> public String Select() { List <ArtCategory> artCategorys = new BLArtCategory().Select(null); List <ExtTreeNode <ArtCategory> > nodes = new List <ExtTreeNode <ArtCategory> >(); foreach (var item in artCategorys) { nodes.Add(new ExtTreeNode <ArtCategory>() { id = item.CatId, text = item.CatName, leaf = true, Tobject = item }); } return(JsonConvert.JavaScriptSerializer(nodes)); }
/// <summary> /// 修改类别的排序 /// </summary> /// <param name="dataStr"></param> /// <returns></returns> public String UpdateOrder(String dataStr) { List <ArtCategory> list = JsonConvert.JSONStringToList <ArtCategory>(dataStr); int result = new BLArtCategory().Update(list); if (result > 0) { return(JsonConvert.JavaScriptSerializer(new ExtResult() { success = true, msg = "修改成功" })); } else { return(JsonConvert.JavaScriptSerializer(new ExtResult() { success = false, msg = "修改失败" })); } }
/// <summary> /// 查询所有的文章类别信息 /// </summary> /// <returns></returns> public String SelectAll() { List <ArtCategory> artCategorys = new BLArtCategory().Select(null); return(JsonConvert.JavaScriptSerializer(artCategorys)); }