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);
}
