public ActionResult _ArticleListForChannelIndex(string title,int catId,TechInfo techInfo) { var articleList = ArticleService.ListWithoutPage(3, new int[] { catId }, new int[] { techInfo.Id }); ViewBag.Title = title; ViewBag.CatId = catId; ViewBag.TechInfo = techInfo; ViewBag.ArticleList = articleList; return View(); }
public static TechInfo Create(TechInfo model) { if (model.Id == 0) { //Add int id = CategoryManage.AddTechInfo(model); model.Id = id; } else { CategoryManage.UpdateTechInfo(model); } return model; }
public ActionResult List(TechInfo model) { //检查 //如果添加,判断别名是否存在 bool isAdd = true; var list = TechService.List(); if(model.Id>0){ isAdd = false; } if (isAdd) { //判断是否别名存在 if (!string.IsNullOrEmpty(model.Alias)) { if (list.Where(m => m.Alias == model.Alias).Count() > 0) { ModelState.AddModelError("ALIASEXISTS", "别名存在,请选择其他别名"); } } } else { //编辑,除了自身之外,判断是否存在 if(!string.IsNullOrEmpty(model.Alias)){ if(list.Where(m=> (m.Alias == model.Alias && m.Id != model.Id) ).Count() >0){ ModelState.AddModelError("ALIASEXISTS", "别名存在,请选择其他别名"); } } } if(ModelState.IsValid){ TechService.Create(model); ViewBag.Msg = "保存成功"; } list = TechService.List(); ViewBag.List = list; return View(); }
public static int UpdateTechInfo(TechInfo model) { string strSQL = "UPDATE Categories SET Name = @Name,Alias = @Alias,Sort = @Sort,IsDeleted = @IsDeleted WHERE Id = @Id AND [Type] = 'tech'"; SqlParameter[] parms = { new SqlParameter("Id",SqlDbType.Int), new SqlParameter("Name",SqlDbType.NVarChar), new SqlParameter("Alias",SqlDbType.NVarChar), new SqlParameter("Sort",SqlDbType.Int), new SqlParameter("IsDeleted",SqlDbType.Bit), }; parms[0].Value = model.Id; parms[1].Value = model.Name; parms[2].Value = model.Alias; parms[3].Value = model.Sort; parms[4].Value = model.IsDeleted; return SQLPlus.ExecuteNonQuery(CommandType.Text,strSQL,parms); }
/// <summary> /// 根据DataRow获得技术分类信息 /// </summary> /// <param name="dr"></param> /// <returns></returns> private static TechInfo GetTechInfoByDataRow(DataRow dr) { var model = new TechInfo(); if (dr == null) { return model; } model.Alias = dr.Field<string>("Alias").ToLower(); model.Id = dr.Field<int>("Id"); model.IsDeleted = dr.Field<bool>("IsDeleted"); model.Name = dr.Field<string>("Name"); model.Sort = dr.Field<int>("Sort"); return model; }
/// <summary> /// 添加技术分类 /// </summary> /// <param name="model"></param> /// <returns></returns> public static int AddTechInfo(TechInfo model) { string strSQL = "INSERT INTO Categories(ParentId,RootId,ParentIds,Name,Alias,Sort,IsDeleted,[Type],CreateDateTime) VALUES(0,0,'0',@Name,@Alias,@Sort,@IsDeleted,@Type,GETDATE());SELECT @@IDENTITY;"; SqlParameter[] param = { new SqlParameter("Name",SqlDbType.NVarChar), new SqlParameter("Alias",SqlDbType.VarChar), new SqlParameter("Sort",SqlDbType.Int), new SqlParameter("IsDeleted",SqlDbType.Bit), new SqlParameter("Type",SqlDbType.VarChar) }; param[0].Value = model.Name; param[1].Value = model.Alias.ToLower(); param[2].Value = model.Sort; param[3].Value = model.IsDeleted; param[4].Value = CatType.Tech.ToString().ToLower(); return Convert.ToInt32(SQLPlus.ExecuteScalar(CommandType.Text, strSQL, param)); }