public HttpResponseMessage DelArticles(int id) { try { using (BackNetEntity db = new BackNetEntity()) { articles oArticles = db.articles.Find(id); if (oArticles == null) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "La Store con el Id " + id.ToString() + " no pudo Eliminarse")); } else { db.articles.Remove(oArticles); db.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); } } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public ActionResult CreationArticle(articles formArticles) { db.articles.Add(formArticles); db.SaveChanges(); return(RedirectToAction("CreationArticle", "CreationArticle")); }
public HttpResponseMessage PutArticles(ArticleRequest oModel) { try { using (BackNetEntity db = new BackNetEntity()) { articles oArticles = db.articles.Find(oModel.id); if (oArticles == null) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "La Store con el Id " + oModel.id.ToString() + " no pudo actualizarse")); } else { oArticles.name = oModel.name; oArticles.description = oModel.description; oArticles.price = oModel.price; oArticles.total_in_shelf = oModel.total_in_shelf; oArticles.total_in_vault = oModel.total_in_vault; oArticles.store_id = oModel.store_id; db.Entry(oArticles).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); } } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public IHttpActionResult Putarticles(int id, articles articles) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != articles.id) { return(BadRequest()); } db.Entry(articles).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!articlesExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
/// <summary> /// 生成图文信息Json /// </summary> /// <param name="Messageid"></param> /// <returns></returns> public static string GetArticlesJsonStr(Guid Messageid) { WX_Message Messages = WX_MessageService.instance().Single(Messageid); StringBuilder sbArticlesJson = new StringBuilder(); // articles if (Messages.Groups.Count() > 0) { List <articles> list = new List <articles>(); foreach (var item in Messages.Groups) { articles a = new articles(); a.title = item.Title; a.author = item.Author; a.content = item.Content; a.content_source_url = item.URL; a.digest = ""; a.show_cover_pic = 0; a.thumb_media_id = item.Img_media_id; list.Add(a); } sbArticlesJson.Append("{\"articles\":"); sbArticlesJson.Append(JsonHelper.SerializeObject(list)); sbArticlesJson.Append("}"); return(sbArticlesJson.ToString()); } return(""); }
public async Task <IActionResult> Edit(int id, [Bind("image,articlesId,Title,Content,PublisherDate,Publisher,IsVisible")] articles articles) { if (id != articles.articlesId) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(articles); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!articlesExists(articles.articlesId)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(articles)); }
public static int Add(articles saveart) { //在注册按钮点击事件 传输regusers的变量 user_name,user_password,user_email,user_profile_photo,user_birthday,user_telephone_number, user_nickname string sql = string.Format("INSERT into articles (article_title,article_content,article_class,artcle_content_20) VALUES ('{0}','{1}','{2}','{3}')", saveart.article_title, saveart.article_content, saveart.article_class, saveart.artcle_content_20); //下面这行是全列执行,由于html页还未为邮箱设计BOX等暂不使用,设计完后要加非空,或空验证 执行不同的sql //string sql = string.Format("INSERT into users (user_name,user_password,user_email,user_profile_photo,user_registration_time,user_birthday,user_telephone_number,user_nickname) VALUES ('{0}','{1}','{2}','{3}',NOW(),{4},'{5}','{6}')", regusers.user_name, regusers.user_password, regusers.user_email, regusers.user_profile_photo, regusers.user_birthday, regusers.user_telephone_number, regusers.user_nickname); int result = dbhelper.ExecuteNorQuery(sql);//调用dbh执行sql语句 return(result); }
public string Save() { string saveData = Request.Params["saveData"]; saveData = saveData.Replace("\r\n", "<br/>").Replace("\\n", "<br/>").Replace(" ", " "); articles entity = JsonConvert.DeserializeObject <articles>(saveData); bool isSave = _articlesService.Add(entity); return(isSave ? "1" : "0"); }
public async Task <IActionResult> Create([Bind("image,articlesId,Title,Content,PublisherDate,Publisher,IsVisible")] articles articles) { if (ModelState.IsValid) { _context.Add(articles); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(articles)); }
public IHttpActionResult Postarticles(articles articles) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.articles.Add(articles); db.SaveChanges(); return(CreatedAtRoute("DefaultApi", new { id = articles.id }, articles)); }
public ActionResult DeleteArticle(articles model) { try { ArticlesData.FullDeleteArticle(model); } catch { return(View(model)); } return(RedirectToAction("ArticlesList")); }
public ActionResult DeleteArticle(articles model) { try { ArticlesData.FullDeleteArticle(model); } catch { return(View(model)); } return(RedirectToAction("ArticlesList", "Users", new { id = LoginHelper.CurrentUser().Id })); }
public ActionResult Modifier(articles a) { try { unS = Service.GetInstance(); unS.ModifierArticle(a); return(RedirectToAction("Index", "Article")); }catch (MonException e) { return(HttpNotFound()); } }
public ArticleViewModel(articles article) { this.id = article.Id; this.title = article.title; this.detail = article.detail; this.price = article.price; this.date = article.date; this.category_Id = article.category_Id; this.customer_id = article.customer_id; this.resources = article.resources; this.contacts = article.contacts; this.articleType = article.GetType().BaseType.Name; }
//vue modifier un article public ActionResult Modifier(string id) { try { unS = Service.GetInstance(); articles unCl = unS.RechercheUnArticle(id); return(View(unCl)); } catch (MonException e) { return(HttpNotFound()); } }
public IHttpActionResult Deletearticles(int id) { articles articles = db.articles.Find(id); if (articles == null) { return(NotFound()); } db.articles.Remove(articles); db.SaveChanges(); return(Ok(articles)); }
/// <summary> /// 更新作品编号 /// </summary> /// <param name="article_id"></param> /// <returns></returns> public ApiResult UploadAritcleNo(articles article) { ApiResult apiResult = new ApiResult(); int no = (from a in db.Set <articles>() where a.article_id <= article.article_id select a).Count(); string article_no = string.Format("{0:D6}", no); article.article_no = article_no; db.Entry <articles>(article).State = EntityState.Modified; if (db.SaveChanges() > 0) { apiResult.success = true; apiResult.message = "保存成功"; } else { apiResult.success = false; apiResult.message = "保存失败"; } return(apiResult); }
public ActionResult EditPosts(int id, articles formArticle /*nom du formulaire renvoyé par la a réutiliser dans la méthode*/) { //user dans la bdd var dbUser = db.Users.FirstOrDefault(x => x.userId == id); var dbArticle = db.articles.FirstOrDefault(x => x.id == id); dbArticle.titre = formArticle.titre; dbArticle.contenu = formArticle.contenu; dbArticle.userId = formArticle.userId; try { db.SaveChanges(); } catch (Exception e) { return(View(e)); } return(RedirectToAction("EditPosts", "EditPosts"));//retourne a la vue EditPosts situé dans le répertoire Home }
private void SendMpMessage(string user, ResponseInfo <WeChatAnswerList> JsonResullt) { SendMPNewsRequest _SendMPNewsRequest = new SendMPNewsRequest(); mpnews _Mpnews = new mpnews(); _Mpnews.articles = new List <articles>(); string str_AccessToken = TokenBiz.GetAccessToken(str_corpid, str_corpsecret); //string filePath = HttpContext.Current.Request.PhysicalApplicationPath + TSubResultNode.SelectSingleNode("content").InnerText; //string content = File.ReadAllText(filePath); _SendMPNewsRequest.touser = user; _SendMPNewsRequest.msgtype = "mpnews"; _SendMPNewsRequest.agentid = Agentid; _SendMPNewsRequest.safe = "0"; if (!_Mpnews.articles.Any())//只要一条就可以了 { articles article = new articles(); string picPath = HttpContext.Current.Request.PhysicalApplicationPath + "LusiResult/Banner/" + JsonResullt.responseInfo._banner; _SendLog.WriteLog(picPath); UploadResponse media_UpLoadInfo = MediaBiz.CreateInstance().Upload(picPath, str_AccessToken, EnumMediaType.image); if (media_UpLoadInfo != null) { article.title = JsonResullt.responseInfo._title; article.thumb_media_id = media_UpLoadInfo.media_id; //article.author = "RR Donnelley"; article.show_cover_pic = "0"; article.digest = JsonResullt.responseInfo._digest; _Mpnews.articles.Add(article); } } _Mpnews.articles.ForEach(x => x.content = JsonResullt.responseInfo._content); _SendMPNewsRequest.mpnews = _Mpnews; messageBiz.Send <SendMPNewsRequest>(_SendMPNewsRequest); }
public void ProcessRequest(HttpContext context) { //string jsonstr; //context.Request. //jsonstr = JsonConvert.SerializeObject(art); //context.Response.Write(jsonstr); //BLL.Ait.SaveAir(art); // context.Request.ContentType = "application/json"; // Stream stream = context.Request.InputStream; // StreamReader sr = new StreamReader(stream); // string search = sr.ReadToEnd(); // sr.Close(); // var jSetting = new JsonSerializerSettings // { // NullValueHandling = NullValueHandling.Ignore // }; //art= (RecordResult)JsonConvert.DeserializeObject(search, jSetting); articles art = new articles(); art.article_title = context.Request.Form["article_title"].ToString(); art.article_content = context.Request.Form["article_content"].ToString(); art.article_class = context.Request.Form["article_class"].ToString(); art.artcle_content_20 = context.Request.Form["article_content_20"].ToString(); int t = BLL.Art.SaveAir(art); //context.Response.Write( "{ \"result\":\"success\"}"); ////返回post的请求 //Result res = new Result(); //res.result = "success"; if (t == 1) { context.Response.Write("{ \"result\":\"success\"}"); //上下两种方法都可以返回一个 result为success的json,下面的这种方法繁琐 //context.Response.Write(Newtonsoft.Json.JsonConvert.SerializeObject(res)); } }
public void MaterialPermanentEdit() { string mediaid = Request["mediaid"]; string index = Request["index"]; string title = Request["title"]; string thumb_media_id = Request["thumb_media_id"]; string author = Request["author"]; string digest = Request["digest"]; int isshow = Convert.ToInt32(Request["ishow"]); string content = Request["content"]; string sourceurl = Request["sourceurl"]; articles item = new articles(); item.title = title; item.author = author; item.thumb_media_id = mediaid; item.digest = digest; item.show_cover_pic = isshow; item.content = content; item.content_source_url = sourceurl; string pams = "{\"media_id\":\"" + mediaid + "\",\"index\":" + index + ", \"articles\": " + JsonConvert.SerializeObject(item) + "}"; string data = RequestType.HttpPost("https://api.weixin.qq.com/cgi-bin/material/update_news?access_token=" + getAccessToken(), pams); baseReturn str = JsonConvert.DeserializeObject <baseReturn>(data); if (str.errcode == 0) { result = Return_Msg(Enum_ReturnStatus.成功, "删除成功", null); } else { throw new Exception(data); } }
/// <summary> /// 上传作品(一个赛季/一个人只能有一份作品)(必须在作品征集时间段内上传) /// formdata:"article_id":0,"article_title":"xxxx","uid":1,"","article_content":"xxxxx","article_pic":"图片","zone_id"(赛区):1,"competiontion_season_id"(赛季):1 /// </summary> /// <returns></returns> public ApiResult UploadArticle() { ApiResult apiResult = new ApiResult(); #region 参数检测 //var pic = System.Web.HttpContext.Current.Request.Files[0]; var _article_pic = System.Web.HttpContext.Current.Request.Form["article_pic"]; string _article_id = System.Web.HttpContext.Current.Request.Form["article_id"]; string _article_title = System.Web.HttpContext.Current.Request.Form["article_title"]; string _uid = System.Web.HttpContext.Current.Request.Form["uid"]; string _article_content = System.Web.HttpContext.Current.Request.Form["article_content"]; string _zone_id = System.Web.HttpContext.Current.Request.Form["zone_id"]; string _competiontion_season_id = System.Web.HttpContext.Current.Request.Form["competiontion_season_id"]; LogHelper.Info("zone_id:" + _zone_id); //一个赛季,一个作者,只能有一份作品 var checkResult = Util.CheckParameters( new Parameter { Value = _zone_id, Msg = "zone_id 不能为空值" }, new Parameter { Value = _zone_id, Msg = "zone_id 必须是数字类型", Regex = @"^[1-9]\d*$" }, new Parameter { Value = _uid, Msg = "uid 不能为空值" }, new Parameter { Value = _uid, Msg = "uid 必须是数字类型", Regex = @"^[1-9]\d*$" }, new Parameter { Value = _article_title, Msg = "article_title 不能为空值" }, new Parameter { Value = _article_content, Msg = "article_content 不能为空值" } ); if (!checkResult.OK) { apiResult.success = false; apiResult.status = ApiStatusCode.InvalidParam; apiResult.message = checkResult.Msg; return(apiResult); } int uid = int.Parse(_uid); int zone_id = int.Parse(_zone_id); int article_id = int.Parse(_article_id); #endregion #region 赛季检查 //开启的赛季 int competiontion_season_id = 0; if (Util.isNotNull(_competiontion_season_id)) { competiontion_season_id = int.Parse(_competiontion_season_id); } else { //查到当前默认开启的赛季 BaseBLL <competition_notice> notice_bll = new BaseBLL <competition_notice>(); var competion_season = notice_bll.Find(o => o.is_delete == 0 && o.is_open == 1); competiontion_season_id = competion_season?.competition_season_id ?? 0; //是否已过期 if (competion_season.preliminaries_start_date > DateTime.Now.Date) { return(new ApiResult() { success = false, message = "大赛投稿时间还没开始" }); } if (competion_season.preliminaries_end_date < DateTime.Now.Date) { return(new ApiResult() { success = false, message = "大赛投稿已截止" }); } } if (competiontion_season_id == 0) { return(new ApiResult() { success = false, message = "当前没有开启任何赛季" }); } #endregion ArticleBLL bll = new ArticleBLL(); BaseBLL <article_states> state_bll = new BaseBLL <article_states>(); BaseBLL <articles> article_bll = new BaseBLL <articles>(); if (article_id > 0) { //判断状态是否可修改 int article_state = state_bll.Find(o => o.article_id == article_id)?.article_state ?? 0; if (article_state > 1) { return(new ApiResult() { success = false, message = "当前状态不可修改" }); } #region 修改 var article = article_bll.Find(o => o.article_id == article_id); if (article?.article_id > 0) { //修改 article.article_pic = _article_pic ?? ""; article.article_title = _article_title; article.article_content = _article_content; article.create_time = DateTime.Now; article.update_time = DateTime.Now; if (article_bll.Update(article)) { //关联表更新 BaseBLL <article_competition_season> article_season_bll = new BaseBLL <article_competition_season>(); var article_competition_season = article_season_bll.Find(o => o.article_id == article_id); if (article_competition_season?.article_season_id > 0) { article_competition_season.zone_id = zone_id; article_competition_season.competiontion_season_id = competiontion_season_id; article_competition_season.update_time = DateTime.Now; article_season_bll.Update(article_competition_season); } //更新作品的状态 BaseBLL <article_states> states_bll = new BaseBLL <article_states>(); var article_states = states_bll.Find(o => o.article_id == article_id); if (article_states?.article_id > 0) { article_states.article_state = 0; article_states.return_remark = ""; article_states.return_tag = ""; article_states.update_time = DateTime.Now; states_bll.Update(article_states); } apiResult.success = true; apiResult.message = "修改成功"; } else { apiResult.success = false; apiResult.message = "修改失败"; } } else { apiResult.success = false; apiResult.message = "数据不存在"; } #endregion } else { #region 新增 //是否已存在 if (bll.ExistUserArticle(uid, competiontion_season_id)) { return(new ApiResult() { success = false, message = "您在当前赛季已经有一份作品了~" }); } articles article = new articles(); //后台自动生成 article.article_pic = _article_pic ?? ""; article.article_title = _article_title; article.article_content = _article_content; article.create_time = DateTime.Now; article.uid = uid; article.update_time = DateTime.Now; var result = article_bll.Add(article); if (result?.article_id > 0) { //更新编号 apiResult = bll.UploadAritcleNo(result); if (apiResult.success) { //更新关联表 BaseBLL <article_competition_season> article_season_bll = new BaseBLL <article_competition_season>(); article_season_bll.Add(new article_competition_season() { article_id = result.article_id, zone_id = zone_id, competiontion_season_id = competiontion_season_id, create_time = DateTime.Now, update_time = DateTime.Now, }); //更新状态表 state_bll.Add(new article_states() { article_id = result.article_id, article_state = 0, create_time = DateTime.Now, update_time = DateTime.Now, }); apiResult.success = true; apiResult.message = "保存成功"; } } else { apiResult.success = false; apiResult.message = "保存失败"; } #endregion } return(apiResult); }
/// <summary> /// 传入art 储存文章内容 /// </summary> /// <param name="articles"></param> /// <returns></returns> public static int SaveAir(articles articles) => DAL.Ait.Add(articles);
public void MassUploadImgText() { string title = Request["title"]; if (string.IsNullOrEmpty(title)) { throw new Exception("标题不能为空"); } string mediaid = Request["mediaid"]; if (string.IsNullOrEmpty(mediaid)) { throw new Exception("素材id不能为空"); } string author = Request["author"]; if (string.IsNullOrEmpty(author)) { throw new Exception("作者不能为空"); } string digest = Request["digest"]; int isshow = Convert.ToInt32(Request["isshow"]); string content = Request["content"]; if (string.IsNullOrEmpty(content)) { throw new Exception("具体内容不能为空"); } string sourceurl = Request["sourceurl"]; if (string.IsNullOrEmpty(sourceurl)) { throw new Exception("原文地址不能为空"); } articles item = new articles(); item.title = title; item.author = author; item.thumb_media_id = mediaid; item.digest = digest; item.show_cover_pic = isshow; item.content = content; item.content_source_url = sourceurl; string pams = "{\"articles\": [" + JsonConvert.SerializeObject(item) + "]}"; string data = RequestType.HttpPost("https://api.weixin.qq.com/cgi-bin/media/uploadnews?access_token=" + getAccessToken(), pams); UploadJsonResult str = JsonConvert.DeserializeObject <UploadJsonResult>(data); if (str.errcode == 0) { result = Return_Msg(Enum_ReturnStatus.成功, "上传成功", data); } else { throw new Exception("上传失败:" + str.errmsg); } }
private static SendMPNewsRequest GetSendMPNewsRequest(string monthkey, string user, DataTable ExcelTable) { DateTime nowtime = DateTime.Now; string year1 = nowtime.Year.ToString(); string year = nowtime.Year.ToString().Substring(2, 2); string month = nowtime.Month.ToString().PadLeft(2, '0'); //微信中直接传年月过来(eg:201606) if (monthkey.Length == 6) { year1 = monthkey.Substring(0, 4); year = monthkey.Substring(2, 2); month = monthkey.Substring(4, 2); } SendMPNewsRequest _SendMPNewsRequest = new SendMPNewsRequest(); mpnews _Mpnews = new mpnews(); _Mpnews.articles = new List <articles>(); string content = ""; _SendMPNewsRequest.touser = user; _SendMPNewsRequest.msgtype = "mpnews"; _SendMPNewsRequest.agentid = System.Configuration.ConfigurationSettings.AppSettings["Agentid"]; _SendMPNewsRequest.safe = "1"; DataRow[] dataRow = ExcelTable.Select("Name='" + user + "'"); for (int j = 0; j < dataRow.Length; j++) { articles article = new articles(); string name = Convert.ToString(dataRow[j][2]); byte[] space = new byte[] { 0xc2, 0xa0 }; string UTFSpace = Encoding.GetEncoding("UTF-8").GetString(space); name = name.Replace(UTFSpace, " "); string title = name.Split('_')[1]; String fileName = year + month + "_" + name + ".jpg"; string ImgName = filePath + fileName; string ImgNameURL = fileURL + fileName; if (!System.IO.File.Exists(@"D:\WebSite\RRD_SalesForecast_Portal\RRD.BC.Portal.web\test1\" + fileName)) { _SendLog.WriteLog("图片缺失: " + fileName); continue; } else { content += "<div>" + title + "</div><div><img src='" + ImgNameURL + "'/></div>"; if (!_Mpnews.articles.Any())//只要一条就可以了 { UploadResponse media_UpLoadInfo = MediaBiz.CreateInstance().Upload(ImgName, str_AccessToken, EnumMediaType.image); if (media_UpLoadInfo != null) { article.title = "RRD Efficiency Metrics " + year1 + month; article.thumb_media_id = media_UpLoadInfo.media_id; article.author = "RR Donnelley"; article.show_cover_pic = "0"; article.digest = "RRD Efficiency Metrics " + year1 + month; _Mpnews.articles.Add(article); } } } } if (!_Mpnews.articles.Any()) { content = "<div>" + monthkey + "</div><div><img src='" + fileURL + "nullImage.jpg" + "'/></div>"; articles article = new articles(); UploadResponse media_UpLoadInfo = MediaBiz.CreateInstance().Upload(filePath + "nullImage.jpg", str_AccessToken, EnumMediaType.image); if (media_UpLoadInfo != null) { article.title = "RRD Efficiency Metrics使用指南"; article.thumb_media_id = media_UpLoadInfo.media_id; article.author = "RR Donnelley"; article.show_cover_pic = "0"; article.digest = "RRD Efficiency Metrics使用指南"; _Mpnews.articles.Add(article); } } _Mpnews.articles.ForEach(x => x.content = content); _SendMPNewsRequest.mpnews = _Mpnews; return(_SendMPNewsRequest); }