protected void InitNews() { entity = new News(); entity.Tittle = txtTitle.Text; entity.FromDate = txtFrom.SelectedDate; entity.ToDate = txtTo.SelectedDate; entity.Content = new StringBuilder(txtContent.Text).ToString(); entity.ImageByte = txtImage.FileBytes; entity.ImageUrl = txtImage.FileName; }
protected void btnUpdate_Click(object sender, EventArgs e) { News news = new News(); news.Id = int.Parse(Request.QueryString["itemID"]); news.ImageByte = txtImage.FileBytes; news.FromDate = txtFrom.SelectedDate; news.ToDate = txtTo.SelectedDate; news.Tittle = txtTitle.Text; news.ImageUrl = txtImage.FileName; StringBuilder builder = new StringBuilder(txtShort.Text); news.Content =builder.ToString(); NewsRepository model = new NewsRepository("list"); model.Update(news); }
public Domain.News Get(int id) { News entity = new News(); SPQuery query = new SPQuery(_spList.DefaultView); StringBuilder queryString = new StringBuilder(); queryString.Append("<Query><Where><Eq>"); queryString.Append("<FieldRef Name='ID' />"); queryString.Append("<Value Type='Counter'>"); queryString.Append(id.ToString()); queryString.Append("</Value>"); queryString.Append("</Eq></Where></Query>"); query.ViewFields = queryString.ToString(); SPListItemCollection items = _spList.GetItems(query); if (items.Count > 0) { #if DEBUG Console.WriteLine("Item is found"); Console.WriteLine("Id: ", id); #endif try { SPListItem item = items[0]; entity.FromDate = (DateTime)item[NewsGuid.FromDate]; entity.ToDate = (DateTime)item[NewsGuid.ToDate]; entity.Tittle = (String)item[NewsGuid.Title]; StringBuilder content = new StringBuilder((String)item[NewsGuid.Content]); entity.Content = content.ToString(); entity.ImageUrl = (String)item[NewsGuid.Image]; } catch (Exception ex) { throw ex; } } return entity; }
public IEnumerable<News> Get() { List<News> listNews; try { SPQuery query = new SPQuery(); StringBuilder queryString = new StringBuilder(); StringBuilder queryViewField = new StringBuilder(); listNews = new List<News>(); queryString.Append("<OrderBy><FieldRef Name='NewsDateFrom' Ascending='False' />"); queryString.Append("</OrderBy>"); query.Query = queryString.ToString(); queryViewField.Append("<FieldRef Name='ID' Ascending='True'/>"); queryViewField.Append("<FieldRef Name='Title' Ascending='True'/>"); queryViewField.Append("<FieldRef Name='NewsDateFrom' Ascending='True'/>"); queryViewField.Append("<FieldRef Name='NewsDateTo' Ascending='True'/>"); queryViewField.Append("<FieldRef Name='NewsImage' Ascending='True'/>"); queryViewField.Append("<FieldRef Name='NewsShort' Ascending='True'/>"); query.ViewFields = queryViewField.ToString(); query.RowLimit = 4; SPListItemCollection items = _spList.GetItems(query); #if DEBUG Console.WriteLine("Items count: {0}", items.Count); #endif foreach (SPListItem item in items) { News entity = new News(); //entity.FromDate = (DateTime)item[NewsGuid.FromDate]; entity.FromDate = (DateTime)item[NewsGuid.FromDate]; entity.ToDate = (DateTime)item[NewsGuid.ToDate]; entity.Tittle = (String)item[NewsGuid.Title]; StringBuilder content = new StringBuilder((String)item[NewsGuid.Content]); entity.Content = content.ToString(); String temp = (String)item[NewsGuid.Image]; String[] url = temp.Trim().Split(','); if (url.Count() > 0) { entity.ImageUrl = url[0]; } listNews.Add(entity); } } catch (Exception ex) { throw ex; } return listNews; }
public JsonResult AddNews(int txt_parent_id, string txt_is_lock, string txt_action_type, string txt_title, int?txt_sort_id, int?txt_click, DateTime?start_time, string txt_source, string txt_author, string txt_summary, string txtContent, string txt_seo_title, string txt_seo_keywords, string txt_seo_description) { Common.Json json = new Common.Json(); var fileName = ""; var name = ""; if (Request.Files.Count == 0) { //json.msg = "没有文件!"; //json.status = -1; //return Json(json); } else { HttpPostedFileBase file = Request.Files[0]; name = "news/" + DateTime.Now.ToString("yyyyMMddhhmmss") + Path.GetExtension(file.FileName); fileName = Path.Combine(Request.MapPath("/") + "../Images", name); try { file.SaveAs(fileName); } catch { //json.msg = "上传异常!"; //json.status = -1; //return Json(json); } } DAO.BLL.B_News b_new = new DAO.BLL.B_News(); DAO.BLL.B_News_type b_nt = new B_News_type(); DAO.BLL.B_Manager b_manager = new B_Manager(); Domain.News m_new = new Domain.News(); m_new.news_type = b_nt.Get(txt_parent_id); m_new.is_lock = txt_is_lock; if (!string.IsNullOrEmpty(txt_action_type)) { if (txt_action_type.Contains(EnumBase.RecommendType.置顶.Description())) { m_new.is_top = 1; } if (txt_action_type.Contains(EnumBase.RecommendType.热门.Description())) { m_new.is_hot = 1; } if (txt_action_type.Contains(EnumBase.RecommendType.推荐.Description())) { m_new.is_red = 1; } if (txt_action_type.Contains(EnumBase.RecommendType.允许评论.Description())) { m_new.is_msg = 1; } } m_new.title = txt_title; m_new.img_url = name; m_new.sort_id = txt_sort_id; m_new.source = txt_source; m_new.author = txt_author; m_new.summary = txt_summary; m_new.content = txtContent; m_new.start_time = start_time; m_new.add_time = DateTime.Now; m_new.click = txt_click; m_new.manager = b_manager.Get(Convert.ToInt32(base.User.Identity.Name)); m_new.seo_title = txt_seo_title; m_new.seo_keywords = txt_seo_keywords; m_new.seo_description = txt_seo_description; var res = b_new.Save(m_new); if (res > 0) { json.msg = "添加成功!"; } else { json.msg = "添加失败!"; json.status = -1; } return(Json(json)); }
public void Update(Domain.News model) { dal.Update(model); }
public int Save(Domain.News model) { return(Convert.ToInt32(dal.Save(model))); }