public bool UpdateArticle(string guid, ArticleItem ai, ArticleContentItem aci) { bool result = false; ai.GUID = guid; ai.UpdateTime = DateTime.Now; var imgs = Utils.PickupImgUrl(aci.ArticleHtml); if (imgs.Count > 0) { ai.ArticleHeadImage = imgs[0]; } else { ai.ArticleHeadImage = "/Content/Images/logo.png"; } ai.ArticleDescription = Utils.ReplaceHtmlTag(aci.ArticleHtml); try { var conn = MySQLConnectionPool.GetConnection(); if (guids.Contains(guid)) { string insertSQL = "Insert Into `ArticleList` (`GUID`,`CreateTime`) values ('" + guid + "','" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "');"; conn.Execute(insertSQL); guids.Remove(guid); } ai.ArticleTypeID = GetTypeID(ai.ArticlePlate, ai.ArticleType); string UpdateSql = ai.GetUpdateSQL("GUID", "ArticleList", "CreateTime,ReadCount,CommentCount,Score,Publish"); QLog.SendLog_Debug(UpdateSql, "ArticleManager"); conn.Execute(UpdateSql); conn.GiveBack(); _Table[guid] = aci; _SE.Commit(); result = true; } catch (Exception ex) { QLog.SendLog_Debug(ex.Message, "ArticleManager"); } return result; }
public string Edit(string id, FormCollection collection) { dynamic re = new ExpandoObject(); var cookie = Request.Cookies["Token"]; if (cookie == null) { re.success = 0; re.Error = "登录失效"; } else { var acticleItem = new ArticleItem(); var user = UserManager.Instance.GetUserByToken(cookie.Value); var acticleContentItem = new ArticleContentItem(); TryUpdateModel<ArticleItem>(acticleItem, collection); TryUpdateModel<ArticleContentItem>(acticleContentItem, collection); acticleItem.Author = user.UserNickName; acticleItem.AuthorID = user.GUID; acticleContentItem.ArticleHtml = HttpUtility.UrlDecode(acticleContentItem.ArticleHtml); acticleContentItem.ArticleMarkdown = HttpUtility.UrlDecode(acticleContentItem.ArticleMarkdown); bool result = ArticleManager.Instance.UpdateArticle(id, acticleItem, acticleContentItem); re.success = result ? 1 : 0; re.UpdateTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); } return JsonConvert.SerializeObject(re); }
public string ImportArticle(HttpPostedFileBase ArticleFile) { int count = 0; try { string fileName = DateTime.Now.ToString("yyyyMMddHHmmssfff_") + ArticleFile.FileName; string filePhysicalPath = Server.MapPath("~/Attribute/" + fileName); ArticleFile.SaveAs(filePhysicalPath); Qing.QLog.SendLog(filePhysicalPath); FileStream stream = System.IO.File.Open(filePhysicalPath, FileMode.Open, FileAccess.Read); IExcelDataReader excelReader = ExcelReaderFactory.CreateOpenXmlReader(stream); Qing.QLog.SendLog("--1"); excelReader.IsFirstRowAsColumnNames = true; DataSet ds = excelReader.AsDataSet(); if (ds == null) { Qing.QLog.SendLog("ds Is Null"); return "ds Is Null"; } DataTable result = excelReader.AsDataSet().Tables[0]; for (int i = 0; i < result.Rows.Count; i++) { DataRow dr = result.Rows[i]; ArticleItem ai = new ArticleItem(); ai.GUID = ArticleManager.Instance.GetArticleGUID(); ai.ArticleDescription = Utils.ReplaceHtmlTag(dr["文档类容"].ToString()); ai.ArticleHeadImage = "/Content/Images/logo.png"; ai.ArticlePlate = dr["板块名称"].ToString().Trim(); ai.ArticleTags = dr["文档标签"].ToString().Trim(); ai.ArticleTitle = dr["文档标题"].ToString().Trim(); ai.ArticleType = dr["类别名称"].ToString().Trim(); ai.ArticleTypeID = ArticleManager.Instance.GetOrCreateTypeID(ai.ArticlePlate, ai.ArticleType); ai.Author = dr["文档作者姓名"].ToString().Trim(); ai.AuthorID = UserManager.Instance.GetUserByUserName(ai.Author); ai.CreateTime = DateTime.Now; ArticleContentItem aci = new ArticleContentItem(); aci.ArticleHtml = HttpUtility.UrlDecode(dr["文档类容"].ToString().Trim().Replace("\n", "<br/>")); aci.ArticleMarkdown = ""; ArticleManager.Instance.UpdateArticle(ai.GUID, ai, aci); count++; } //var excelFile = new ExcelQueryFactory(filepath); //var data = excelFile.Worksheet<ImportArticleItem>(); //count = data.Count(); //foreach (var item in data) //{ // ArticleItem ai = new ArticleItem(); // ai.GUID = ArticleManager.Instance.GetArticleGUID(); // ai.ArticleDescription = Utils.ReplaceHtmlTag(item.文档类容); // ai.ArticleHeadImage = "/Content/Images/logo.png"; // ai.ArticlePlate = item.板块名称.Trim(); // ai.ArticleTags = item.文档标签.Trim(); // ai.ArticleTitle = item.文档标题.Trim(); // ai.ArticleType = item.类别名称.Trim(); // ai.ArticleTypeID = ArticleManager.Instance.GetOrCreateTypeID(ai.ArticlePlate, ai.ArticleType); // ai.Author = item.文档作者姓名.Trim(); // ai.AuthorID = UserManager.Instance.GetUserByUserName(ai.Author); // ai.CreateTime = DateTime.Now; // ArticleContentItem aci=new ArticleContentItem (); // aci.ArticleHtml= HttpUtility.UrlDecode(item.文档类容.Trim().Replace("\n","<br/>")); // aci.ArticleMarkdown=""; // ArticleManager.Instance.UpdateArticle(ai.GUID, ai, aci); //} } catch (Exception ex) { Qing.QLog.SendLog(ex.ToString()); return "导入出错:" + ex.Message; } return "导入成功 共" + count + "条"; }