public ActionResult Index(string openId, int articleId)
{
try
{
WX_Article article = WXArticleServices.QueryById(articleId);
if (article == null)
{
return(RedirectToAction("NotPage", "ErrorPrompt", new { message = "获取微信基础信息失败" }));
}
return(View(article));
}
catch (Exception ex) {
ExceptionsServices.AddExceptionToDbAndTxt("WeiXinPageError", "Index方法处理异常", ex, LogFrom.WeiXin);
return(RedirectToAction("NotPage", "ErrorPrompt", new { message = "获取数据异常" }));
}
}
public bool Update(WX_Article model, DbOperator dbOperator)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update WX_Article set Title=@Title,ImagePath=@ImagePath,Description=@Description,Url=@Url,[Text]=@Text");
strSql.Append(",ArticleType=@ArticleType,Sort=@Sort,GroupID=@GroupID where ID=@ID");
dbOperator.ClearParameters();
dbOperator.AddParameter("ID", model.ID);
dbOperator.AddParameter("Title", model.Title);
dbOperator.AddParameter("ImagePath", model.ImagePath);
dbOperator.AddParameter("Description", model.Description);
dbOperator.AddParameter("Url", model.Url);
dbOperator.AddParameter("Text", model.Text);
dbOperator.AddParameter("ArticleType", (int)model.ArticleType);
dbOperator.AddParameter("Sort", model.Sort);
dbOperator.AddParameter("GroupID", model.GroupID);
return(dbOperator.ExecuteNonQuery(strSql.ToString()) > 0);
}
public bool Create(WX_Article model, DbOperator dbOperator)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into WX_Article(Title,ImagePath,Description,Url,[Text],ArticleType,Sort,GroupID,DataStatus,CreateTime,CompanyID)");
strSql.Append(" values(@Title,@ImagePath,@Description,@Url,@Text,@ArticleType,@Sort,@GroupID,@DataStatus,@CreateTime,@CompanyID)");
dbOperator.ClearParameters();
dbOperator.AddParameter("Title", model.Title);
dbOperator.AddParameter("ImagePath", model.ImagePath);
dbOperator.AddParameter("Description", model.Description);
dbOperator.AddParameter("Url", model.Url);
dbOperator.AddParameter("Text", model.Text);
dbOperator.AddParameter("ArticleType", (int)model.ArticleType);
dbOperator.AddParameter("Sort", model.Sort);
dbOperator.AddParameter("GroupID", model.GroupID);
dbOperator.AddParameter("DataStatus", (int)model.DataStatus);
dbOperator.AddParameter("CreateTime", DateTime.Now);
dbOperator.AddParameter("CompanyID", model.CompanyID);
return(dbOperator.ExecuteNonQuery(strSql.ToString()) > 0);
}
public JsonResult SaveArticle(string groupId, int itemnum, string jsonData)
{
try
{
string newGroupId = string.Empty;
if (string.IsNullOrWhiteSpace(groupId))
{
newGroupId = GuidGenerator.GetGuidString();
}
var dyArticles = JsonHelper.Parse(jsonData);
List <WX_Article> models = new List <WX_Article>();
for (var i = 0; i < itemnum; i++)
{
WX_Article model = new WX_Article();
model.ID = int.Parse(dyArticles[i].id);
if (string.IsNullOrWhiteSpace(dyArticles[i].title))
{
throw new MyException(string.Format("获取第{0}个图文的标题失败", i + 1));
}
model.Title = dyArticles[i].title;
model.ImagePath = dyArticles[i].pic;
if (string.IsNullOrWhiteSpace(dyArticles[i].pic))
{
throw new MyException(string.Format("获取第{0}个图文的封面图片失败", i + 1));
}
model.Description = dyArticles[i].desc;
if (!string.IsNullOrWhiteSpace(groupId))
{
List <WX_Article> oldArticles = WXArticleServices.QueryByGroupID(groupId);
if (oldArticles.Count == 0)
{
throw new MyException("获取单位编号失败");
}
model.CompanyID = oldArticles.First().CompanyID;
}
else
{
model.CompanyID = dyArticles[i].companyid;
}
model.Text = dyArticles[i].text;
model.ArticleType = (ArticleType)int.Parse(dyArticles[i].type);
if (model.ArticleType == ArticleType.Url && string.IsNullOrWhiteSpace(dyArticles[i].url))
{
throw new MyException(string.Format("获取第{0}个图文的链接地址失败", i + 1));
}
if (model.ArticleType == ArticleType.Module && string.IsNullOrWhiteSpace(dyArticles[i].moduleid))
{
throw new MyException(string.Format("获取第{0}个图文的模块失败", i + 1));
}
switch (model.ArticleType)
{
case ArticleType.Url:
{
model.Url = dyArticles[i].url;
break;
}
case ArticleType.Module:
{
model.Url = dyArticles[i].moduleid;
break;
}
default:
{
model.Url = string.Empty;
break;
}
}
model.Sort = (int)dyArticles[i].sort;
model.GroupID = string.IsNullOrWhiteSpace(groupId)?newGroupId:groupId;
model.CreateTime = DateTime.Now;
models.Add(model);
}
bool result = WXArticleServices.Create(models);
if (!result)
{
throw new MyException("保存图文失败");
}
return(Json(MyResult.Success()));
}
catch (MyException ex)
{
return(Json(MyResult.Error(ex.Message)));
}
catch (Exception ex)
{
ExceptionsServices.AddExceptions(ex, "保存图文失败");
return(Json(MyResult.Error("保存图文失败")));
}
}
