public ArticlesResponse Get(Articles request)
{
ArticlesResponse response = new ArticlesResponse();
List<Bm2s.Data.Common.BLL.Article.Article> items = new List<Data.Common.BLL.Article.Article>();
if (!request.Ids.Any())
{
items.AddRange(Datas.Instance.DataStorage.Articles.Where(item =>
(string.IsNullOrWhiteSpace(request.Code) || item.Code.ToLower().Contains(request.Code.ToLower())) &&
(string.IsNullOrWhiteSpace(request.Designation) || item.Designation.ToLower().Contains(request.Designation.ToLower())) &&
(request.ArticleFamilyId == 0 || item.ArticleFamilyId == request.ArticleFamilyId) &&
(request.ArticleSubFamilyId == 0 || item.ArticleSubFamilyId == request.ArticleSubFamilyId) &&
(request.BrandId == 0 || item.BrandId == request.BrandId) &&
(!request.Date.HasValue || (request.Date >= item.StartingDate && (!item.EndingDate.HasValue || request.Date < item.EndingDate.Value)))
));
}
else
{
items.AddRange(Datas.Instance.DataStorage.Articles.Where(item => request.Ids.Contains(item.Id)));
}
var collection = (from item in items
select new Bm2s.Poco.Common.Article.Article()
{
ArticleFamily = new ArticleFamily.ArticleFamiliesService().Get(new ArticleFamilies() { Ids = new List<int>() { item.ArticleFamilyId } }).ArticleFamilies.FirstOrDefault(),
ArticleSubFamily = new ArticleSubFamily.ArticleSubFamiliesService().Get(new ArticleSubFamilies() { Ids = new List<int>() { item.ArticleSubFamilyId } }).ArticleSubFamilies.FirstOrDefault(),
Brand = new BrandsService().Get(new Brands() { Ids = new List<int>() { item.BrandId } }).Brands.FirstOrDefault(),
Code = item.Code,
Description = item.Description,
Designation = item.Designation,
EndingDate = item.EndingDate,
Id = item.Id,
Observation = item.Observation,
StartingDate = item.StartingDate,
Unit = new UnitsService().Get(new Units() { Ids = new List<int>() { item.UnitId } }).Units.FirstOrDefault()
}).AsQueryable().OrderBy(request.Order, !request.DescendingOrder);
response.ItemsCount = collection.Count();
if (request.PageSize > 0)
{
response.Articles.AddRange(collection.Skip((request.CurrentPage - 1) * request.PageSize).Take(request.PageSize));
}
else
{
response.Articles.AddRange(collection);
}
try
{
response.PagesCount = collection.Count() / response.Articles.Count + (collection.Count() % response.Articles.Count > 0 ? 1 : 0);
}
catch
{
response.PagesCount = 1;
}
return response;
}
public ArticlesResponse Delete(Articles request)
{
Bm2s.Data.Common.BLL.Article.Article item = Datas.Instance.DataStorage.Articles[request.Article.Id];
item.EndingDate = DateTime.Now;
Datas.Instance.DataStorage.Articles[item.Id] = item;
ArticlesResponse response = new ArticlesResponse();
response.Articles.Add(request.Article);
return response;
}
public ActionResult Rechercher(Articles article)
{
var v = _db.Article.Where(a => a.articleId == article.articleId).FirstOrDefault();
if (v != null)
{
return(RedirectToAction("ResRecherche", new { id = article.articleId }));
}
else
{
ViewBag.Message = "ID article n'existe pas ";
return(View());
}
}
//les donnees initialiser
public void Form_Donnees_Initialiser()
{
Marque_Box_Initialiser();
Sous_Familles_Box_Initialiser();
ArticlesDAO Articles_DAO = new ArticlesDAO();
Articles Article = Articles_DAO.Rechercher_Articles(this.Label_Ref_A.Text)[0];
Console.Write(Article.Quantite_Operation);
this.TextBox_Description.Text = Article.Description_Operation;
this.TextBox_Prix.Text = Article.PrixTH_Operation.ToString();
this.TextBox_Quantite.Text = Article.Quantite_Operation.ToString();
this.ComboBox_Marque.Text = Article.Ref_Marque_Operation.ToString();
this.ComboBox_SousFamille.Text = Article.Ref_Sous_Famille_Operation.ToString();
}
private async Task GetArticlesAsync()
{
string url = $"api/article/articles/newest";
Loading = true;
Articles.Clear();
StateHasChanged();
var pagingResponse = await ArticleService.GetVMPageAsync(PagingParameters, url);
Articles = pagingResponse.Items;
MetaData = pagingResponse.MetaData;
Loading = false;
StateHasChanged();
}
protected override void ExecuteToggleBookmarkArticle(Article article)
{
base.ExecuteToggleBookmarkArticle(article);
if (!article.IsSaved)
{
Articles.Remove(article);
}
if (!Articles.Any())
{
CurrentState = ListState.Empty;
}
}
protected void Button1_Click(object sender, EventArgs e)
{
try
{
int id = int.Parse(Request.QueryString["articleId"]);
var article = new Articles();
bool removeStatus = article.RemoveArticle(id);
Response.Redirect("/Admin/ViewArticles");
}
catch (Exception ex)
{
Literal2.Text = ex.Message;
}
}
public ArticlesDetailsViewModel(Articles articles)
{
this.articles = articles;
Title = articles.Title;
NextRefreshTime = DateTime.Now.AddMinutes(15);
ArticlesDetails = new ArticlesDetailsModel()
{
HasContent = false,
DiggDisplay = articles.DiggCount > 0 ? articles.DiggCount.ToString() : "推荐",
CommentDisplay = articles.CommentCount > 0 ? articles.CommentCount.ToString() : "评论",
ViewDisplay = articles.ViewCount > 0 ? articles.ViewCount.ToString() : "阅读",
DateDisplay = "发布于 " + articles.DateDisplay
};
}
public ActionResult Create(Articles article)
{
Articles dbarticle = new Articles();
try
{
dbarticle.Title = article.Title;
dbarticle.Contents = article.Contents;
dbarticle.Category = article.Category;
dbarticle.RegistDate = DateTime.Now;
dbarticle.ModifyDate = DateTime.Now;
dbarticle.ViewCnt = 0;
dbarticle.IPAddress = Request.ServerVariables["REMOTE_ADDR"].ToString();
dbarticle.RegistMemberID = "admin";
dbarticle.ModifyMemberID = "admin";
db.Articles.Add(dbarticle);
db.SaveChanges();
if (Request.Files.Count > 0)
{
var attachFile = Request.Files[0];
if (attachFile != null && attachFile.ContentLength > 0)
{
var fileName = Path.GetFileName(attachFile.FileName);
var path = Path.Combine(Server.MapPath("~/Upload/"), fileName);
attachFile.SaveAs(path);
ArticleFiles file = new ArticleFiles();
file.ArticleIDX = dbarticle.ArticleIDX;
file.FilePath = "/Upload/";
file.FileName = fileName;
file.FileFormat = Path.GetExtension(attachFile.FileName);
file.FileSize = attachFile.ContentLength;
file.UploadDate = DateTime.Now;
db.ArticleFiles.Add(file);
db.SaveChanges();
}
}
ViewBag.Result = "OK";
}
catch (Exception ex)
{
ViewBag.Result = "FAIL";
Console.WriteLine($"Exception: '{ex}'");
}
return(View(article));
}
/// <summary>
/// 查询首页所有文章
/// </summary>
/// <returns>文章列表</returns>
public static List <Articles> GetArticles()
{
//sql
string sql = @"select Id,Title,SimpleInfo,MainPicUrl
from Articles where ShowType = '文章'";
// DBHelper.ExecuteReader(sql)
List <Articles> lis = new List <Articles>();
using (SqlDataReader sdr = DBHelper.ExecuteReader(sql))
{
while (sdr.Read())
{
Articles a = new Articles();
a.Id = int.Parse(sdr["Id"].ToString());
a.Title = sdr["Title"].ToString();
a.SimpleInfo = sdr["SimpleInfo"].ToString();
a.MainPicUrl = sdr["MainPicUrl"].ToString();
lis.Add(a);
}
}
//SqlDataReader sdr = null;
//try
//{
// sdr = DBHelper.ExecuteReader(sql);
// while (sdr.Read())
// {
// Articles a = new Articles();
// a.Id = int.Parse(sdr["Id"].ToString());
// a.Title = sdr["Title"].ToString();
// a.SimpleInfo = sdr["SimpleInfo"].ToString();
// a.MainPicUrl = sdr["MainPicUrl"].ToString();
// lis.Add(a);
// }
//}
//catch (Exception e)
//{
// Console.WriteLine(e.Message);
//}
//finally
//{
// sdr.Close();
//}
return(lis);
}
/// <summary>
/// 保存HTML
/// </summary>
/// <param name="args"></param>
private static void SaveHtmlEvent(DataReceivedEventArgs args)
{
Regex reg = new Regex(@"(?m)<title[^>]*>(?<title>(?:\w|\W)*?)</title[^>]*>", RegexOptions.Multiline | RegexOptions.IgnoreCase);
Match mc = reg.Match(args.Html);
string m_title = String.Empty;
if (mc.Success)
{
m_title = mc.Groups["title"].Value.Trim();
}
Regex urlRegex = new Regex(@"(?i)http://(\w+\.){1,3}(com(\.cn)?|cn|net)\b");
//去除域名后
var shtml = urlRegex.Replace(args.Html, "/File");
try
{
lock (syncRoot)
{
//更新数据库
Articles article = new Articles();
article.Id = PrimaryKeyGen.GuidToLongId();
article.IsDelete = false;
article.Url = args.Url;
article.Title = m_title;
article.Summary = m_title;
article.Content = shtml;
article.AddTime = DateTime.Now.ToString("yyyyMMdd hh:mm:ss");
var saveResult = _IArticlesService.Add(article);
if (saveResult)
{
// 更新索引库
IndexTask task = new IndexTask();
task.TaskId = article.Id;
task.Title = m_title;
//去除回车，空格，换行
task.Content = HtmlConverts.ConvertHtml(shtml).Replace("\n", "").Replace(" ", "").Replace("\t", "").Replace("\r", "");;
task.Summary = m_title;
IndexManager.Instance.AddArticle(task);
}
}
}
catch (Exception ex)
{
log.ErrorFormat("Url:{0};\r\n错误信息{1}", args.Url, ex.InnerException.Message);
}
}
// GET: Articles/Edit/5
public async Task <ActionResult> Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Articles articles = await db.Articles.FindAsync(id);
if (articles == null)
{
return(HttpNotFound());
}
ViewBag.StoreID = new SelectList(db.Stores, "StoreID", "Name", articles.StoreID);
return(View(articles));
}
async Task <WorkItem> IMasterWorkItemDb.GetNextItemAsync(string supplierFamily, long lastProcessedRevision)
{
// Get next work item with the given supplier name and with revision > the last processed revision
var query = BooleanOperator.And(new[] {
Query.Property("supplier_family").IsEqualTo(supplierFamily),
Query.Property("version").IsGreaterThan(lastProcessedRevision)
});
var changeLog = (await Articles.FindAllAsync("master_change_log", query.ToString(), pageSize: 1, orderBy: "version", sortOrder: SortOrder.Ascending)).SingleOrDefault();
if (changeLog == null)
{
return(null);
}
return(changeLog.ToMasterWorkItem());
}
public ActionResult Save(Articles oarticle)
{
ArticleBLL ab = new ArticleBLL();
SaveResult result = new SaveResult();
if (oarticle.Id > 0)//编辑
{
result = ab.Update(oarticle, UserId, UserName);
}
else//新增
{
result = ab.Create(oarticle, UserId, UserName);
}
return(Json(result.toJson()));
}
// GET: Articles/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Articles articles = db.Articles.Find(id);
if (articles == null)
{
return(HttpNotFound());
}
ViewBag.UserID = new SelectList(db.Food_categories, "ID", "Name", articles.Categorie_id);
return(View(articles));
}
public IActionResult EditPost(int id)
{
ArticleViewModel articleViewModel;
using (Db db = new Db())
{
Articles articles = db.article.Find(id);
if (articles == null)
{
return(Content("Статья блога не создана"));
}
articleViewModel = new ArticleViewModel(articles);
}
return(View(articleViewModel));
}
private void Add(Articles model)
{
int rows = bll.Add(model);
hdfPid.Value = rows + "";
hdfTid.Value = model.parentId + "";
if (rows > 0)
{
Msg.ShowAndRedirect("添加信息成功!", "Default.aspx?codeNo=" + codeNo);
}
else
{
Msg.Show("添加信息失败!");
}
}
private void CreateNewInvoice(Articles article)
{
//Получаем дату создания
string currentDate = DateTime.Now.ToString("yyyy/MM/dd HH:mm");
var invoicesDb = _dataAccessFactory.CreateInvoicesDbAccess();
//Создаём накладную по данным
invoicesDb.CreateInvoice(_newInvoiceView.StringOfType, _newInvoiceView.StringOfSender,
_newInvoiceView.StringOfGetter, _currentUser.AuthorizedUser.UserName,
article.nameOfArticle, article.amountFree, currentDate, article.articleId, _newInvoiceView.StringOfText);
//Получаем и задаём Номер накладной.
_newInvoiceView.IdString = invoicesDb.GetCurrentIdOfInvoice();
}
public MessagePushRequest(string appid, string toUserId, Articles articles, int articleCount, string agreementId = null, string msgType = "image-text")
{
Message message = new Message
{
AgreementId = agreementId,
AppId = appid,
Articles = articles,
ArticleCount = articleCount,
ToUserId = toUserId,
CreateTime = TimeHelper.TransferToMilStartWith1970(System.DateTime.Now).ToString("F0"),
MsgType = msgType
};
this.message = message;
}
public IActionResult GunlukDuzenle(string id, Articles article)
{
var item = articlesRepository.GetById(id);
if (ModelState.IsValid)
{
item.Title = article.Title;
item.Content = article.Content;
item.CreatedDate = article.CreatedDate;
articlesRepository.UpdateModel(id, item);
TempData["GunlukDuzenleMesaji"] = "Günlük Başarıyla Güncellendi.";
return(RedirectToAction("Incele", new { Id = item.DiaryId }));
}
return(View(article));
}
public Dictionary <int, Article> GenarateRanking()
{
var result = new Dictionary <int, Article>();
var sortedArticles = Articles
.OrderByDescending(x => x.GetTotalRate())
.ToArray();
for (int i = 1; i < sortedArticles.Count(); i++)
{
result.Add(i, sortedArticles[i]);
}
return(result);
}
static void CreaArticolo()
{
decimal prezzo;
string descrizione;
Console.WriteLine("Inserisci la descrizione :");
descrizione = Console.ReadLine();
Console.WriteLine("Inserisci il prezzo : ");
prezzo = decimal.Parse(Console.ReadLine()); // TODO gestire eccezioni
Article myArticle1 = new Article(descrizione, prezzo);
Articles.Add(myArticle1);
Articles.List();
}
public ActionResult Edit(int?id)
{
Article article;
if (id.HasValue)
{
article = Articles.GetByID(id.Value);
}
else
{
article = new Article();
}
return(View("/Areas/User/Views/Articles/Edit.cshtml", article));
}
public ActionResult Modifier(Article article)
{
if (!ModelState.IsValid)
{
return(View(article));
}
Utilisateur user = Utilisateurs.FindByCourriel(User.Identity.Name);
article.IdContributeur = user.Id;
article.Revision++;
article.DateModification = DateTime.Now;
Articles.Update(article);
return(RedirectToAction("Index", "Home", new { id = article.Titre }));
}
public void GetDateId()
{
// Arrange
Articles resultArticle = new Articles();
var mock = new Mock <IArtikleDataAccess>();
mock.Setup(repo => repo.GetAsync(1)).ReturnsAsync(resultArticle);
var artikleEngine = new ArtikleEngine(Logger, Mapper, mock.Object);
// Act
var result = artikleEngine.GetAsync(1).Result;
// Assert
Assert.NotNull(result);
}
public Articles RemoveTagFromArticle(int articleid, int tagId)
{
Articles article = context.Articles.FirstOrDefault(x => x.Id == articleid);
var ta = new TagsArticles
{
ArticlesId = article.Id,
TagsId = tagId
};
var tag = context.TagsArticles.Remove(ta);
context.SaveChanges();
return(article);
}
public void AddArticle(DateTimeOffset publishDateTime)
{
var month = publishDateTime.Month;
var year = publishDateTime.Year;
var article = Articles.FirstOrDefault(a => a.Month == month && a.Year == year);
if (article == null)
{
article = DataSourceArticle.Create(month, year);
Articles.Add(article);
}
article.Increment();
NbStoriesPerMonth = Articles.Sum(a => a.NbArticles) / Articles.Count();
}
public async Task <IActionResult> OnGetAsync(Guid?id)
{
if (id == null)
{
return(NotFound());
}
Articles = await _context.Articles.FirstOrDefaultAsync(m => m.Id == id);
if (Articles == null)
{
return(NotFound());
}
return(Page());
}
public MainForm()
{
InitializeComponent();
Articles.SetArticles(new List <String> {
"Test 1"
});
BlogPostDetailedView.BlogPost = new BlogPost
{
Author = "John Doe",
Content = "Lorem ipsum dolor sit amet, consectetur adipisicing elit. Minima necessitatibus temporibus voluptas sunt ullam voluptatum, voluptates sapiente maiores aliquam accusantium dolor eligendi. Nesciunt molestiae totam voluptate, neque cumque explicabo eveniet odio minus! Esse praesentium amet explicabo magni sunt molestias saepe ipsa, accusamus! A distinctio ut error quidem, consectetur, rem, consequatur laudantium dolor illum aperiam nisi reprehenderit magnam laboriosam veniam non. Minima ab repellendus ad dicta labore corrupti provident voluptas reiciendis aliquam, tempore, sapiente sint.",
Title = "Lorem ipsum dolor",
Category = Category.Personal
};
}
/// <summary>
/// 查询我喜欢的优选列表id
/// </summary>
/// <param name="userId"></param>
/// <returns></returns>
public static async Task <List <int> > SelectMyFavoriteYouXuanIdsByUserId(Guid userId)
{
if (userId == Guid.Empty)
{
return(null);
}
var ids = await Articles.SelectMyFavoriteYouXuanIdsByUserId(userId);
if (ids == null || !ids.Any())
{
return(null);
}
return(ids.Select(x => x.ArticleId).ToList());
}
/// <summary>
/// 查询点赞消息通知
/// </summary>
/// <param name="userId"></param>
/// <returns></returns>
public static IEnumerable <ArticleCommentModel> SelectVoteNotices(string userId, PagerModel page)
{
List <ArticleCommentModel> LsitPraose = new List <ArticleCommentModel>();
var dt = Articles.SelectVoteNotices(userId, page);
if (dt.Rows.Count == 0 && dt == null)
{
return(null);
}
LsitPraose = dt.Rows.Cast <DataRow>().GroupBy(row => row["CommentId"]).Select(order => new ArticleCommentModel(order.First())
{
Item = order.Select(row => new CommentPraise(row))
}).ToList();
return(LsitPraose as IEnumerable <ArticleCommentModel>);
}
private void BindArticleInfo()
{
ArticleInfo articleinfo = Articles.GetArticleInfo(articleid);
if (articleinfo != null)
{
ddlColumns.SelectedValue = articleinfo.Columnid.ToString();
ddlHightlight.SelectedValue = articleinfo.Highlight;
tbxTitle.Text = Natsuhime.Web.Utils.RemoveHtml(articleinfo.Title.TrimEnd());
tbxSummary.Text = articleinfo.Summary.TrimEnd();
tbxContent.Text = articleinfo.Content.TrimEnd();
ckbxRecommand.Checked = Convert.ToBoolean(articleinfo.Recommend);
btnSubmit.Text = "编辑";
}
}
private void Init()
{
Articles list = new Articles();
list.DataLoading += () =>
{
pr.IsActive = true;
};
list.DataLoaded += () =>
{
pr.IsActive = false;
};
lv.ItemsSource = list;
}
public NewArticleState(Articles a)
{
this.a = a;
}
public ArticlesResponse Post(Articles request)
{
if (request.Article.Id > 0)
{
Bm2s.Data.Common.BLL.Article.Article item = Datas.Instance.DataStorage.Articles[request.Article.Id];
item.ArticleFamilyId = request.Article.ArticleFamily.Id;
item.ArticleSubFamilyId = request.Article.ArticleSubFamily.Id;
item.BrandId = request.Article.Brand.Id;
item.Code = request.Article.Code;
item.Description = request.Article.Description;
item.Designation = request.Article.Designation;
item.EndingDate = request.Article.EndingDate;
item.Observation = request.Article.Observation;
item.StartingDate = request.Article.StartingDate;
item.UnitId = request.Article.Unit.Id;
Datas.Instance.DataStorage.Articles[request.Article.Id] = item;
}
else
{
Bm2s.Data.Common.BLL.Article.Article item = new Bm2s.Data.Common.BLL.Article.Article()
{
ArticleFamilyId = request.Article.ArticleFamily.Id,
ArticleSubFamilyId = request.Article.ArticleSubFamily.Id,
BrandId = request.Article.Brand.Id,
Code = request.Article.Code,
Description = request.Article.Description,
Designation = request.Article.Designation,
EndingDate = request.Article.EndingDate,
Observation = request.Article.Observation,
StartingDate = request.Article.StartingDate,
UnitId = request.Article.Unit.Id
};
Datas.Instance.DataStorage.Articles.Add(item);
request.Article.Id = item.Id;
}
ArticlesResponse response = new ArticlesResponse();
response.Articles.Add(request.Article);
return response;
}
public async Task<bool> SaveOrUpdateArticle(Articles.Article source)
{
return await Task.Run<bool>(() => saveOrUpdateArticle(source));
}
private bool saveOrUpdateArticle(Articles.Article source)
{
var sw = new Performance.Stopwatch("saveOrUpdateArticle");
sw.Start();
if (!ArticleDB.AncestorsAndSelf("Articles").Any())
ArticleDB.Add(new XElement("Articles"));
if (ArticleDB.Elements("Article").Any(x => x.Element("ArticleID").Value == source.ArticleID))
ArticleDB.Elements("Article").Single(x => x.Element("ArticleID").Value == source.ArticleID).ReplaceWith(source.GetXElement());
else
ArticleDB.Add(source.GetXElement());
try { File.WriteAllText(DatabasePath + CurrentCompany.CompanyID + "\\Articles.xml", ArticleDB.ToString()); }
catch (Exception e) { logger.Fatal("Error writing article to " + DatabasePath + CurrentCompany.CompanyID + "\\Articles.xml", e); return false; }
sw.Stop();
logger.Info(sw.Result());
return true;
}
public void UpdateArticle(Articles art)
{
throw new NotImplementedException();
}
