/// <summary> /// 更新 /// </summary> /// <param name="model"></param> /// <returns></returns> public static int Update(CompanyNewsInfo model) { string strSQL = "UPDATE CompanyNews SET Title = @Title ,Content = @Content,PublishDateTime =@PublishDateTime,ModifyDateTime = GETDATE(),Remark = @Remark,ImageUrl = @ImageUrl,Tags = @Tags WHERE Id = @Id AND CompanyId = @CompanyId"; SqlParameter[] parms = { new SqlParameter("Id",SqlDbType.Int), new SqlParameter("CompanyId",SqlDbType.Int), new SqlParameter("Title",SqlDbType.NVarChar), new SqlParameter("Content",SqlDbType.NVarChar), new SqlParameter("PublishDateTime",SqlDbType.DateTime), new SqlParameter("Remark",SqlDbType.NVarChar), new SqlParameter("ImageUrl",SqlDbType.NVarChar), new SqlParameter("Tags",SqlDbType.NVarChar), }; parms[0].Value = model.Id; parms[1].Value = model.CompanyId; parms[2].Value = model.Title; parms[3].Value = model.Content; parms[4].Value = model.PublishDateTime; parms[5].Value = string.IsNullOrEmpty(model.Remark) ? string.Empty : model.Remark; parms[6].Value = string.IsNullOrEmpty(model.ImageUrl) ? string.Empty : model.ImageUrl; parms[7].Value = string.IsNullOrEmpty(model.Tags) ? string.Empty : model.Tags; //插入News2Tech表 InsertNews2Tech(model.Id, model.TechIds); return SQLPlus.ExecuteNonQuery(CommandType.Text, strSQL, parms); }
/// <summary> /// 添加 /// </summary> /// <param name="model"></param> /// <returns></returns> public static int Insert(CompanyNewsInfo model) { string strSQL = "DECLARE @MyId AS INT;INSERT INTO CompanyNews(CompanyId,Title,Content,PublishDateTime,ModifyDateTime,CreateDateTime,IsDeleted,Remark,ImageUrl,Tags,[Type]) VALUES(@CompanyId,@Title,@Content,@PublishDateTime,GETDATE(),GETDATE(),0,@Remark,@ImageUrl,@Tags,@Type);SELECT @MyId = @@IDENTITY;UPDATE CompanyNews SET Url = '/company/'+CAST(@CompanyId AS NVARCHAR(255))+'/newsdetail.html?id='+CAST(@MyId AS NVARCHAR(255)) WHERE Id = @MyId; SELECT @MyId;"; SqlParameter[] parms = { new SqlParameter("Id",SqlDbType.Int), new SqlParameter("CompanyId",SqlDbType.Int), new SqlParameter("Title",SqlDbType.NVarChar), new SqlParameter("Content",SqlDbType.NVarChar), new SqlParameter("PublishDateTime",SqlDbType.DateTime), new SqlParameter("Remark",SqlDbType.NVarChar), new SqlParameter("ImageUrl",SqlDbType.NVarChar), new SqlParameter("Tags",SqlDbType.NVarChar), new SqlParameter("Type",SqlDbType.NVarChar), }; parms[0].Value = model.Id; parms[1].Value = model.CompanyId; parms[2].Value = model.Title; parms[3].Value = model.Content; parms[4].Value = model.PublishDateTime <= DateTime.MinValue ? DateTime.Now : model.PublishDateTime; parms[5].Value = string.IsNullOrEmpty(model.Remark) ? string.Empty : model.Remark; parms[6].Value = string.IsNullOrEmpty(model.ImageUrl) ? string.Empty : model.ImageUrl; parms[7].Value = string.IsNullOrEmpty(model.Tags) ? string.Empty : model.Tags; parms[8].Value = string.IsNullOrEmpty(model.Type) ? "news" : model.Type; int id = Convert.ToInt32(SQLPlus.ExecuteScalar(CommandType.Text, strSQL, parms)); //插入News2Tech表 InsertNews2Tech(id,model.TechIds); return id; }
/// <summary> /// 更新 /// </summary> /// <param name="model"></param> /// <returns></returns> public static CompanyNewsInfo Update(CompanyNewsInfo model) { if (model.Id == 0) { int id = CompanyNewsManage.Insert(model); model.Id = id; } else { CompanyNewsManage.Update(model); } return model; }
public ActionResult ApplicationEdit(CompanyNewsInfo oldModel, FormCollection fc) { bool errors = false; var companyInfo = MemberService.GetCompanyInfoByUserId(PlantEngContext.Current.UserId); if (string.IsNullOrEmpty(oldModel.Title)) { errors = true; ModelState.AddModelError("TitleEmpty", "标题不能为空"); } if (string.IsNullOrEmpty(oldModel.Content)) { errors = true; ModelState.AddModelError("ContentEmpty", "内容不能为空"); } if (!errors && ModelState.IsValid) { oldModel.CompanyId = companyInfo.CompanyId; oldModel.Type = "application"; //添加技术分类 string requestTechIds = fc["techcat"] == null ? string.Empty : fc["techcat"]; string[] strTechIds = requestTechIds.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries); int[] techIds = strTechIds.Select(i => Utils.StrToInt(i, 0)).ToArray<int>(); oldModel.TechIds = techIds; CompanyNewsService.Update(oldModel); ViewBag.Msg = "保存成功!"; } return View(oldModel); }