/// <summary> /// 增加一条数据 /// </summary> public int Add(SystemNews model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into SystemNews("); strSql.Append("NewsTitle,NewsContent,UserId,UserName,NewsStatus,NewsRealseTime"); strSql.Append(") values ("); strSql.Append("@NewsTitle,@NewsContent,@UserId,@UserName,@NewsStatus,@NewsRealseTime"); strSql.Append(") "); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@NewsTitle", SqlDbType.VarChar, 300), new SqlParameter("@NewsContent", SqlDbType.VarChar, -1), new SqlParameter("@UserId", SqlDbType.Int, 4), new SqlParameter("@UserName", SqlDbType.VarChar, 50), new SqlParameter("@NewsStatus", SqlDbType.Int, 4), new SqlParameter("@NewsRealseTime", SqlDbType.DateTime) }; parameters[0].Value = model.NewsTitle; parameters[1].Value = model.NewsContent; parameters[2].Value = model.UserId; parameters[3].Value = model.UserName; parameters[4].Value = model.NewsStatus; parameters[5].Value = model.NewsRealseTime; return(sqlhelper.ExecNon(strSql.ToString(), parameters)); }
public JsonResult AddUpdateNews(SystemNews news) { //FormCollection form DataFornat dataformat = new DataFornat(); JsonResult result = null; try { news.NewsContent = HttpUtility.UrlDecode(news.NewsContent); news.NewsContent = dataformat.ReplaceImageSrc(news.NewsContent, AppConfigHelper.MainSiteUrl); BaseResultDto <string> resultDto = new BaseResultDto <string>(); //添加或者修改 if (news.Id > 0) { //修改 resultDto = HttpHelper.CreatHelper().DoPostObject <BaseResultDto <string> >(string.Format("{0}News/Update", this.WebApiUrl), news); } else { news.NewsRealseTime = System.DateTime.Now; news.UserName = this.UserInfo.UserName; news.UserId = this.UserInfo.ID; //添加 resultDto = HttpHelper.CreatHelper().DoPostObject <BaseResultDto <string> >(string.Format("{0}News/Add", this.WebApiUrl), news); } result = Json(new { status = resultDto.ErrorCode, message = resultDto.ErrorMsg }, JsonRequestBehavior.AllowGet); } catch (Exception ex) { result = Json(new { status = -1, message = ex.Message }, JsonRequestBehavior.AllowGet); } return(result); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(SystemNews model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update SystemNews set "); strSql.Append(" NewsTitle = @NewsTitle , "); strSql.Append(" NewsContent = @NewsContent , "); strSql.Append(" UserId = @UserId , "); strSql.Append(" UserName = @UserName , "); strSql.Append(" NewsStatus = @NewsStatus , "); strSql.Append(" NewsRealseTime = @NewsRealseTime "); strSql.Append(" where Id=@Id "); SqlParameter[] parameters = { new SqlParameter("@Id", SqlDbType.Int, 4), new SqlParameter("@NewsTitle", SqlDbType.VarChar, 300), new SqlParameter("@NewsContent", SqlDbType.VarChar, -1), new SqlParameter("@UserId", SqlDbType.Int, 4), new SqlParameter("@UserName", SqlDbType.VarChar, 50), new SqlParameter("@NewsStatus", SqlDbType.Int, 4), new SqlParameter("@NewsRealseTime", SqlDbType.DateTime) }; parameters[0].Value = model.Id; parameters[1].Value = model.NewsTitle; parameters[2].Value = model.NewsContent; parameters[3].Value = model.UserId; parameters[4].Value = model.UserName; parameters[5].Value = model.NewsStatus; parameters[6].Value = model.NewsRealseTime; return(sqlhelper.ExecNon(strSql.ToString(), parameters) > 0 ? true : false); }
public bool Update(SystemNews model, List <string> fileds, string sqlWhere) { StringBuilder strSql = new StringBuilder(); strSql.AppendFormat("update {0} set ", model.GetType().Name); List <string> filedsList = new List <string>(); List <SqlParameter> sqlParameter = new List <SqlParameter>(); SqlParameter Param = new SqlParameter("@Id", SqlDbType.Int, 4); if (string.IsNullOrEmpty(sqlWhere)) { Param.Value = model.Id; sqlParameter.Add(Param); } foreach (string filed in fileds) { filedsList.Add(string.Format("{0}=@{0}", filed)); Param = new SqlParameter(string.Format("@{0}", filed), model.GetType().GetProperty(filed).GetValue(model, null)); sqlParameter.Add(Param); } strSql.AppendFormat("{0}", string.Join(",", filedsList.ToArray())); if (string.IsNullOrEmpty(sqlWhere)) { strSql.Append(" where Id=@Id "); } else { strSql.AppendFormat(" where 1=1 and {0} ", sqlWhere); } SqlParameter[] parameters = sqlParameter.ToArray(); return(sqlhelper.ExecNon(strSql.ToString(), parameters) > 0 ? true : false); }
public void Persist(SystemNews item) { VtsWebServiceClient service = new VtsWebServiceClient(); service.NewsPersist(SystemNewsAssembler.FromDomainObjectToDto(item)); service.Close(); }
public ActionResult Delete(int id) { NewsPersistency persistency = new NewsPersistency(); SystemNews item = persistency.Get(id); SystemNewsViewModel model = new SystemNewsViewModel(item); return(View(model)); }
/// <summary> /// 加载数据 /// </summary> /// <param name="Id"></param> /// <returns></returns> public ActionResult AddNews(int Id) { SystemNews model = new SystemNews(); if (Id > 0) { BaseResultDto <SystemNews> resultDto = HttpHelper.CreatHelper().DoGetObject <BaseResultDto <SystemNews> >(string.Format("{0}News/GetNews?Id={1}", this.WebApiUrl, Id)); model = resultDto.Tag; } return(View(model)); }
public SystemNewsViewModel(SystemNews model) { this.model = model; Id = model.Id; Date = model.DatePublished; TopicEnglish = model.GetTopic(0); TopicRussian = model.GetTopic(1); TopicBelarusian = model.GetTopic(2); TextEnglish = model.GetTopic(0); TextRussian = model.GetTopic(1); TextBelarusian = model.GetTopic(2); }
public ActionResult Create(SystemNewsViewModel model) { try { SystemNews item = model.GetModel(); NewsPersistency persistency = new NewsPersistency(); persistency.Persist(item); return(RedirectToAction("Index")); } catch { return(View()); } }
public static SystemNews FromDtoToDomainObject(SystemNewsDto source) { SystemNews target = new SystemNews(); target.Id = source.Id; target.DatePublished = source.DatePublished; target.IsBlocked = source.IsBlocked; foreach (SystemNewsLocalizedDto newsLocalized in source.SystemNewsLocalized) { SystemNewsLocalized snld = SystemNewsLocalizedAssembler.FromDtoToDomainObject(newsLocalized); target.SystemNewsLocalized.Add(snld); } return(target); }
public BaseResultDto <string> Update(SystemNews model) { BaseResultDto <string> resultDto = new BaseResultDto <string>(); try { resultDto.ErrorCode = helper.Update <SystemNews>(model) ? 1 : 0; resultDto.ErrorMsg = "修改成功"; } catch (Exception ex) { resultDto.ErrorCode = -1; resultDto.ErrorMsg = ex.Message; } return(resultDto); }
/// <summary> /// 删除新闻 /// </summary> /// <param name="news"></param> /// <returns></returns> public JsonResult DelNew(SystemNews news) { JsonResult result = null; try { //删除新闻 BaseResultDto <string> resultDto = HttpHelper.CreatHelper().DoGetObject <BaseResultDto <string> >(string.Format("{0}News/Delete?Id={1}", this.WebApiUrl, news.Id)); result = Json(new { status = resultDto.ErrorCode, message = resultDto.ErrorMsg }, JsonRequestBehavior.AllowGet); } catch (Exception ex) { result = Json(new { status = -1, message = ex.Message }, JsonRequestBehavior.AllowGet); } return(result); }
public BaseResultDto <string> Add(SystemNews model) { BaseResultDto <string> resultDto = new BaseResultDto <string>(); try { resultDto.ErrorCode = helper.Add <SystemNews>(model); resultDto.ErrorMsg = "添加成功"; } catch (Exception ex) { resultDto.ErrorCode = -1; resultDto.ErrorMsg = ex.Message; } return(resultDto); }
public static SystemNewsDto FromDomainObjectToDto(SystemNews source) { SystemNewsDto target = new SystemNewsDto(); target.Id = source.Id; target.DatePublished = source.DatePublished; target.IsBlocked = source.IsBlocked; IList <SystemNewsLocalizedDto> list = new List <SystemNewsLocalizedDto>(); foreach (SystemNewsLocalized newsLocalized in source.SystemNewsLocalized) { SystemNewsLocalizedDto snld = SystemNewsLocalizedAssembler.FromDomainObjectToDto(newsLocalized); list.Add(snld); } target.SystemNewsLocalized = list.ToArray(); return(target); }
public ActionResult Create(NewsEntryViewModel newsEntry) { if (!ModelState.IsValid) { var viewModel = new NewsEntryViewModel { SystemNews = newsEntry.SystemNews }; return(View("NewsEntry", viewModel)); } SystemNews systemNews = new SystemNews() { EnteredDateTime = DateTime.Now, Entry = newsEntry.SystemNews.Entry }; _context.SystemNews.Add(systemNews); _context.SaveChanges(); return(RedirectToAction("Index", "Home")); }
/// <summary> /// 得到一个对象实体 /// </summary> public SystemNews GetModel(string where) { StringBuilder strSql = new StringBuilder(); strSql.Append("select Id, NewsTitle, NewsContent, UserId, UserName, NewsStatus, NewsRealseTime "); strSql.Append(" from SystemNews "); strSql.Append(" where "); strSql.Append(where); var dt = sqlhelper.GetTable(strSql.ToString()); SystemNews model = null; if (dt.Rows.Count > 0) { model = Mapper.DynamicMap <IDataReader, List <SystemNews> >(dt.CreateDataReader()).FirstOrDefault(); } return(model); }
public SystemNewsViewModel() { Date = DateTime.Now; model = new SystemNews(); }