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