public static ArticleInfo Create(ArticleInfo model) { if (model.Id == 0) { //Insert int id = ArticleManage.Insert(model); model.Id = id; } else { ArticleManage.Update(model); } //插入ArticleTags表 ArticleManage.InsertArticleTagData(model.Id,model.Tags); return model; }
/// <summary> /// 插入 /// </summary> /// <param name="model"></param> /// <returns></returns> public static int Insert(ArticleInfo model) { string strSQL = "INSERT INTO Articles(CategoryId,Title,Content,Remark,ImageUrl,QuickLinkUrl,Tags,Author,Sort,IsTop,IsDeleted,PublishDateTime,TimeSpan,Url,CompanyId,AddUserName,LastModifyUserName,LastModifyDateTime,Copyright,SubTitle) VALUES(@CategoryId,@Title,@Content,@Remark,@ImageUrl,@QuickLinkUrl,@Tags,@Author,@Sort,@IsTop,@IsDeleted,@PublishDateTime,@TimeSpan,@Url,@CompanyId,@AddUserName,@AddUserName,GETDATE(),@Copyright,@SubTitle);SELECT @@IDENTITY;"; SqlParameter[] parms = { new SqlParameter("Id",SqlDbType.Int), new SqlParameter("CategoryId",SqlDbType.Int), new SqlParameter("Title",SqlDbType.NVarChar), new SqlParameter("Content",SqlDbType.NVarChar), new SqlParameter("Remark",SqlDbType.NVarChar), new SqlParameter("ImageUrl",SqlDbType.VarChar), new SqlParameter("QuickLinkUrl",SqlDbType.VarChar), new SqlParameter("Tags",SqlDbType.VarChar), new SqlParameter("Author",SqlDbType.VarChar), new SqlParameter("Sort",SqlDbType.Int), new SqlParameter("IsTop",SqlDbType.Bit), new SqlParameter("IsDeleted",SqlDbType.Bit), new SqlParameter("PublishDateTime",SqlDbType.DateTime), new SqlParameter("TimeSpan",SqlDbType.VarChar), new SqlParameter("Url",SqlDbType.VarChar), new SqlParameter("CompanyId",SqlDbType.Int), new SqlParameter("AddUserName",SqlDbType.NVarChar), new SqlParameter("Copyright",SqlDbType.NVarChar), new SqlParameter("SubTitle",SqlDbType.NVarChar), }; parms[0].Value = model.Id; parms[1].Value = model.CategoryId; parms[2].Value = string.IsNullOrEmpty(model.Title)? string.Empty : model.Title; parms[3].Value = string.IsNullOrEmpty(model.Content) ? string.Empty : model.Content; parms[4].Value = string.IsNullOrEmpty(model.Remark) ? string.Empty : model.Remark; parms[5].Value = string.IsNullOrEmpty(model.ImageUrl) ? string.Empty : model.ImageUrl; parms[6].Value = string.IsNullOrEmpty(model.QuickLinkUrl) ? string.Empty : model.QuickLinkUrl; parms[7].Value = string.IsNullOrEmpty(model.Tags) ? string.Empty : model.Tags; parms[8].Value = string.IsNullOrEmpty(model.Author) ? string.Empty : model.Author; parms[9].Value = model.Sort; parms[10].Value = model.IsTop; parms[11].Value = model.IsDeleted; parms[12].Value = model.PublishDateTime; parms[13].Value = model.TimeSpan ?? DateTime.Now.ToString("yyyyMMddHHmmssffff"); parms[14].Value = model.Url; parms[15].Value = model.CompanyId; parms[16].Value = string.IsNullOrEmpty(model.AddUserName) ? string.Empty : model.AddUserName; parms[17].Value = model.Copyright ?? string.Empty; parms[18].Value = model.SubTitle ?? string.Empty; return Convert.ToInt32(SQLPlus.ExecuteScalar(CommandType.Text,strSQL,parms)); }
public ActionResult Add(ArticleInfo oldModel,FormCollection fc) { bool isAdd = true; if(oldModel.Id >0){ isAdd = false; } if(ModelState.IsValid){ //TODO //在这,最好检查一下标题是否重复,目前没做 oldModel.AddUserName = User.Identity.Name; oldModel.LastModifyUserName = User.Identity.Name; oldModel.CategoryId = Utils.StrToInt(fc["select_column"],0); //改变URL oldModel.Url = oldModel.QuickLinkUrl; if(string.IsNullOrEmpty(oldModel.Url)){ oldModel.Url = string.Format("/article/show/{0}.html", oldModel.TimeSpan); } oldModel = ArticleService.Create(oldModel); //插入到Article2Category表中 //1,技术分类 var requestTechListArray = CECRequest.GetFormString("cbtechlist").Split(','); List<int> techList = new List<int>(); foreach(string item in requestTechListArray){ int id = Utils.StrToInt(item,0); if(id>0){ techList.Add(id); } } ArticleService.InsertArticle2Category(oldModel.Id, CatType.Tech, techList); //2,行业分类 var requestIndustryList = CECRequest.GetFormString("cbindustrylist").Split(','); List<int> industryList = new List<int>(); foreach(string item in requestIndustryList){ int id = Utils.StrToInt(item,0); if(id>0){ industryList.Add(id); } } ArticleService.InsertArticle2Category(oldModel.Id, CatType.Industry, industryList); //完成,提示信息 if (isAdd) { ViewBag.Msg = "添加成功!<a href=\"add\">继续?</a><span class=\"ml10\">或</span><a href=\"list\" class=\"ml10\">返回</a>"; } else { ViewBag.Msg = "修改成功!<a href=\"add\">添加新文章?</a><span class=\"ml10\">或</span><a href=\"list\" class=\"ml10\">返回</a>"; } } //初始化栏目类别 //初始化栏目类别 var allColumnList = ColumnService.List().ToList(); var dropdownList = new List<ColumnInfo>(); ColumnService.BuildListForTree(dropdownList, allColumnList, 0); ViewBag.ColumnDropDownList = dropdownList; //输出技术分类 ViewBag.TechList = TechService.List().Where(m => m.IsDeleted == false); //输出行业分类 ViewBag.IndustryList = IndustryService.List().Where(m => m.IsDeleted == false); //已选择的技术分类和行业分类 ViewBag.SelectTechList = ArticleService.Article2CategoryListByArticleIdAndType(oldModel.Id, CatType.Tech); ViewBag.SelectIndustryList = ArticleService.Article2CategoryListByArticleIdAndType(oldModel.Id, CatType.Industry); string companyName = string.Empty; if (oldModel.CompanyId > 0) { //对CompanyName进行赋值 //数据库中只保存CompanyId,没有保存CompanyName,只能在这里处理一下 companyName = MemberService.GetBaseCompanyInfo(oldModel.CompanyId).CompanyName; } ViewBag.CompanyName = companyName; return View(oldModel); }
/// <summary> /// 更新 /// </summary> /// <param name="model"></param> /// <returns></returns> public static int Update(ArticleInfo model) { string strSQL = "UPDATE Articles SET CategoryId = @CategoryId,Title = @Title,Content = @Content,Remark = @Remark,ImageUrl = @ImageUrl,QuickLinkUrl = @QuickLinkUrl,Tags = @Tags,Author = @Author,Sort = @Sort,IsTop = @IsTop,IsDeleted = @IsDeleted,PublishDateTime = @PublishDateTime,CompanyId = @CompanyId,LastModifyUserName = @LastModifyUserName,LastModifyDateTime = GETDATE(),Url = @Url,Copyright = @Copyright,SubTitle = @SubTitle WHERE Id = @Id"; SqlParameter[] parms = { new SqlParameter("Id",SqlDbType.Int), new SqlParameter("CategoryId",SqlDbType.Int), new SqlParameter("Title",SqlDbType.NVarChar), new SqlParameter("Content",SqlDbType.NVarChar), new SqlParameter("Remark",SqlDbType.NVarChar), new SqlParameter("ImageUrl",SqlDbType.VarChar), new SqlParameter("QuickLinkUrl",SqlDbType.VarChar), new SqlParameter("Tags",SqlDbType.VarChar), new SqlParameter("Author",SqlDbType.VarChar), new SqlParameter("Sort",SqlDbType.Int), new SqlParameter("IsTop",SqlDbType.Bit), new SqlParameter("IsDeleted",SqlDbType.Bit), new SqlParameter("PublishDateTime",SqlDbType.DateTime), new SqlParameter("CompanyId",SqlDbType.Int), new SqlParameter("LastModifyUserName",SqlDbType.NVarChar), new SqlParameter("Url",SqlDbType.NVarChar), new SqlParameter("Copyright",SqlDbType.NVarChar), new SqlParameter("SubTitle",SqlDbType.NVarChar), }; parms[0].Value = model.Id; parms[1].Value = model.CategoryId; parms[2].Value = string.IsNullOrEmpty(model.Title) ? string.Empty : model.Title; parms[3].Value = string.IsNullOrEmpty(model.Content) ? string.Empty : model.Content; parms[4].Value = string.IsNullOrEmpty(model.Remark) ? string.Empty : model.Remark; parms[5].Value = string.IsNullOrEmpty(model.ImageUrl) ? string.Empty : model.ImageUrl; parms[6].Value = string.IsNullOrEmpty(model.QuickLinkUrl) ? string.Empty : model.QuickLinkUrl; parms[7].Value = string.IsNullOrEmpty(model.Tags) ? string.Empty : model.Tags; parms[8].Value = string.IsNullOrEmpty(model.Author) ? string.Empty : model.Author; parms[9].Value = model.Sort; parms[10].Value = model.IsTop; parms[11].Value = model.IsDeleted; parms[12].Value = model.PublishDateTime; parms[13].Value = model.CompanyId; parms[14].Value = string.IsNullOrEmpty(model.LastModifyUserName) ? string.Empty : model.LastModifyUserName; parms[15].Value = model.Url; parms[16].Value = model.Copyright ?? string.Empty; parms[17].Value = model.SubTitle ?? string.Empty; return SQLPlus.ExecuteNonQuery(CommandType.Text,strSQL,parms); }