private void btnView_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e) { NoticeDto dto = grvNotice.GetRow(grvNotice.FocusedRowHandle) as NoticeDto; NoticePop note = new NoticePop(dto.NoticeID); note.ShowDialog(); }
/// <summary> /// Factory method. Loads a <see cref="NoticeInfo"/> object from the given NoticeDto. /// </summary> /// <param name="data">The <see cref="NoticeDto"/>.</param> /// <returns>A reference to the fetched <see cref="NoticeInfo"/> object.</returns> internal static NoticeInfo GetNoticeInfo(NoticeDto data) { NoticeInfo obj = new NoticeInfo(); obj.Fetch(data); return(obj); }
/// <summary> /// Updates in the database all changes made to the Notice object. /// </summary> /// <param name="notice">The Notice DTO.</param> /// <returns>The updated <see cref="NoticeDto"/>.</returns> public NoticeDto Update(NoticeDto notice) { using (var ctx = ConnectionManager <MySqlConnection> .GetManager("Connection")) { using (var cmd = new MySqlCommand("Notice_Upd", ctx.Connection)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@p_NoticeId", notice.NoticeId).DbType = DbType.Int64; cmd.Parameters["@p_NoticeId"].Direction = ParameterDirection.Input; cmd.Parameters.AddWithValue("@p_Title", notice.Title); cmd.Parameters["@p_Title"].Direction = ParameterDirection.Input; cmd.Parameters.AddWithValue("@p_Content", notice.Content); cmd.Parameters["@p_Content"].Direction = ParameterDirection.Input; cmd.Parameters.AddWithValue("@p_Url", notice.Url); cmd.Parameters["@p_Url"].Direction = ParameterDirection.Input; cmd.Parameters.AddWithValue("@p_LastUser", notice.LastUser); cmd.Parameters["@p_LastUser"].Direction = ParameterDirection.Input; var rowsAffected = cmd.ExecuteNonQuery(); if (rowsAffected == 0) { throw new DataNotFoundException("Notice"); } } } return(notice); }
public void update(NoticeDto notice_dto) { try { _transactionManager.beginTransaction(); Notice notice = _noticeRepo.getById(notice_dto.notice_id); string oldImage = notice.image_name; _noticeMaker.copy(ref notice, notice_dto); _noticeRepo.update(notice); if (!string.IsNullOrWhiteSpace(notice_dto.image_name)) { deleteImage(oldImage); } _transactionManager.commitTransaction(); } catch (Exception) { _transactionManager.rollbackTransaction(); throw; } }
/// <summary> /// 编辑notice /// </summary> /// <param name="dto">实体</param> /// <returns></returns> public bool Update(NoticeDto dto) { using (var scope = _dbScopeFactory.Create()) { var db = GetDb(scope); var dbSet = GetDbSet(db); var entity = Mapper.Map <NoticeDto, NoticeEntity>(dto); dbSet.AddOrUpdate(entity); scope.SaveChanges(); return(true); } }
/// <summary> /// Loads a <see cref="NoticeInfo"/> object from the given <see cref="NoticeDto"/>. /// </summary> /// <param name="data">The NoticeDto to use.</param> private void Fetch(NoticeDto data) { // Value properties NoticeId = data.NoticeId; Title = data.Title; Content = data.Content; Url = data.Url; LastUser = data.LastUser; LoadProperty(LastModefiedProperty, data.LastModefied); var args = new DataPortalHookArgs(data); OnFetchRead(args); }
public ActionResult NewPrjNotice(string MBR_ID, string STATUS, string CASE_NO, string NOTICE_TYPE) { NoticeDto model = new NoticeDto() { MBR_ID = MBR_ID, STATUS = STATUS, CASE_NO = CASE_NO }; NoticeResponseDto response = service.SetProjectNotice(model, NOTICE_TYPE); return(Json(new { result = response.RESULT, msg = response.ReturnMsg })); }
/// <summary> /// Loads a <see cref="Notice"/> object from the given <see cref="NoticeDto"/>. /// </summary> /// <param name="data">The NoticeDto to use.</param> private void Fetch(NoticeDto data) { // Value properties LoadProperty(NoticeIdProperty, data.NoticeId); LoadProperty(TitleProperty, data.Title); LoadProperty(ContentProperty, data.Content); LoadProperty(UrlProperty, data.Url); LoadProperty(LastUserProperty, data.LastUser); LoadProperty(LastModefiedProperty, data.LastModefied); var args = new DataPortalHookArgs(data); OnFetchRead(args); }
//private readonly IDbContextScopeFactory _dbScopeFactory; //public NoticeService(IDbContextScopeFactory dbScopeFactory) //{ // _dbScopeFactory = dbScopeFactory; //} #endregion #region INoticeService 接口实现 /// <summary> /// 添加notice /// </summary> /// <param name="dto">notice实体</param> /// <returns></returns> public string Add(NoticeDto dto) { using (var scope = _dbScopeFactory.Create()) { var db = GetDb(scope); var dbSet = GetDbSet(db); var entity = Mapper.Map <NoticeDto, NoticeEntity>(dto); entity.Create(); dbSet.Add(entity); scope.SaveChanges(); return(entity.Id); } }
/// <summary> /// 显示公告详情窗口 /// </summary> /// <param name="model"></param> internal static void ShowBulletionDetailsDialog(NoticeDto model) { Application.Current.Dispatcher.Invoke(new Action(() => { var win = new BulletinDetailsWindow { Owner = Application.Current.MainWindow }; var vm = new BulletinDetailsViewModel(); vm.InitData(model); win.DataContext = vm; win.ShowDialog(); })); }
private NoticeDto Fetch(SafeDataReader dr) { var noticeInfo = new NoticeDto(); // Value properties noticeInfo.NoticeId = dr.GetInt64("NoticeId"); noticeInfo.Title = dr.GetString("Title"); noticeInfo.Content = dr.GetString("Content"); noticeInfo.Url = !dr.IsDBNull("Url") ? dr.GetString("Url") : null; noticeInfo.LastUser = dr.GetString("LastUser"); noticeInfo.LastModefied = !dr.IsDBNull("LastModefied") ? dr.GetSmartDate("LastModefied", true) : null; return(noticeInfo); }
/// <summary> /// 更新公告 /// </summary> /// <param name="dto"></param> /// <returns></returns> public static bool Update(NoticeDto dto) { using (var DB = new SSMMEntities()) { var model = DB.Notice.Find(dto.Id); if (model != null) { model.CreateTime = DateTime.Now; model.Title = dto.Title; model.Contents = dto.Contents; model.IsDelete = dto.IsDelete; } return(DB.SaveChanges() > 0); } }
public void copy(ref Notice notice, NoticeDto notice_dto) { notice.notice_id = notice_dto.notice_id; notice.notice_date = notice_dto.notice_date; notice.notice_expiry_date = notice_dto.notice_expiry_date; notice.description = notice_dto.description.Trim(); if (!string.IsNullOrWhiteSpace(notice_dto.image_name)) { notice.image_name = notice_dto.image_name; } notice.title = notice_dto.title.Trim(); notice.is_closed = notice_dto.is_closed; notice.slug = _slugGenerator.generate(notice_dto.title); }
/// <summary> /// 添加公告 /// </summary> /// <param name="dto"></param> /// <returns></returns> public static bool Add(NoticeDto dto) { using (var DB = new SSMMEntities()) { DB.Notice.Add(new Notice() { Id = dto.Id, CreateTime = dto.CreateTime, Title = dto.Title, Contents = dto.Contents, IsDelete = dto.IsDelete }); return(DB.SaveChanges() > 0); } }
public static NoticeDto ToNoticeDto(SysNotice sysNotice) { var dto = new NoticeDto { Content = sysNotice.Content, CreateBy = sysNotice.CreateBy, CreateTime = sysNotice.CreateTime, Id = sysNotice.Id, ModifyBy = sysNotice.ModifyBy, ModifyTime = sysNotice.ModifyTime, Title = sysNotice.Title, Type = sysNotice.Type }; return(dto); }
public IActionResult edit(long notice_id) { try { var notice = _noticeRepo.getById(notice_id); NoticeDto dto = _mapper.Map <NoticeDto>(notice); RouteData.Values.Remove("notice_id"); return(View(dto)); } catch (Exception ex) { AlertHelper.setMessage(this, ex.Message, messageType.error); return(RedirectToAction("index")); } }
public UserNoticeState Resolve(Notice source, NoticeDto destination, UserNoticeState destMember, ResolutionContext context) { var dateModified = source.Modification; var dateRemoved = source.Removal; if (dateRemoved.HasValue) { return(UserNoticeState.Removed); } if (dateModified.HasValue) { return(UserNoticeState.Modified); } return(UserNoticeState.Included); }
public ActionResult NewPrjNotice(string status, string case_no, string notice_type) { string mbr_id = accountService.GetUserInfo().MBR_ID; #if DEBUG //mbr_id = "M018223C11"; #endif NoticeDto model = new NoticeDto() { MBR_ID = mbr_id, STATUS = status, CASE_NO = case_no }; NoticeResponseDto response = loanService.SetProjectNotice(model, notice_type); return(Json(new { result = response.RESULT, msg = response.ReturnMsg })); }
private NoticeDto Fetch(IDataReader data) { var notice = new NoticeDto(); using (var dr = new SafeDataReader(data)) { if (dr.Read()) { notice.NoticeId = dr.GetInt64("NoticeId"); notice.Title = dr.GetString("Title"); notice.Content = dr.GetString("Content"); notice.Url = !dr.IsDBNull("Url") ? dr.GetString("Url") : null; notice.LastUser = dr.GetString("LastUser"); notice.LastModefied = !dr.IsDBNull("LastModefied") ? dr.GetSmartDate("LastModefied", true) : null; } } return(notice); }
/// <summary> /// Inserts a new Notice object in the database. /// </summary> /// <param name="notice">The Notice DTO.</param> /// <returns>The new <see cref="NoticeDto"/>.</returns> public NoticeDto Insert(NoticeDto notice) { using (var ctx = ConnectionManager <MySqlConnection> .GetManager("Connection")) { using (var cmd = new MySqlCommand("Notice_Add", ctx.Connection)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@p_NoticeId", notice.NoticeId).Direction = ParameterDirection.Output; cmd.Parameters.AddWithValue("@p_Title", notice.Title).DbType = DbType.String; cmd.Parameters.AddWithValue("@p_Content", notice.Content).DbType = DbType.String; cmd.Parameters.AddWithValue("@p_Url", notice.Url == null ? (object)DBNull.Value : notice.Url).DbType = DbType.String; cmd.Parameters.AddWithValue("@p_LastUser", notice.LastUser).DbType = DbType.String; cmd.ExecuteNonQuery(); //notice.NoticeId = Convert.ToInt64(cmd.Parameters["@p_NoticeId"].Value.ToString()); } } return(notice); }
public void save(NoticeDto notice_dto) { try { _transactionManager.beginTransaction(); Notice notice = new Notice(); _noticeMaker.copy(ref notice, notice_dto); _noticeRepo.insert(notice); _transactionManager.commitTransaction(); } catch (Exception) { _transactionManager.rollbackTransaction(); throw; } }
public async Task OnGetAsync(long?id) { if (id.HasValue) { Dto = await _service.GetByIdAsync(id.Value); if (Dto == null) { throw new KuDataNotFoundException(); } ViewData["Mode"] = "Edit"; } else { Dto = new NoticeDto(); ViewData["Mode"] = "Add"; } }
public override void SearchButtonClick() { DataSet ds = webService.GetAllNotice(dateStart.DateTime, dateEnd.DateTime); List <NoticeDto> noticeList = new List <NoticeDto>(); if (ds.Tables[0].Rows.Count > 0) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { NoticeDto dto = new NoticeDto(); dto.NoticeID = ds.Tables[0].Rows[i]["NoticeID"].ToString(); dto.NoticeTitle = ds.Tables[0].Rows[i]["NoticeTitle"].ToString(); dto.NoticeContent = ds.Tables[0].Rows[i]["NoticeContent"].ToString(); dto.FileExist = ds.Tables[0].Rows[i]["FileExist"].ToString(); dto.InDateTime = Convert.ToDateTime(ds.Tables[0].Rows[i]["InDateTime"]); noticeList.Add(dto); } } grcNotice.DataSource = noticeList; }
internal void InitData(NoticeDto model) { DispatcherHelper.UIDispatcher.Invoke(new Action(() => { isBusy = true; Title = model.Title; CreateTime = model.CreateTime; CreateName = model.CreateName; EffectiveStartTime = model.EffectiveStartTime; EffectiveEndTime = model.EffectiveEndTime; NoticeAttachmentDtos = model.NoticeAttachments; var titleHtml = "<div style='text-align:center;font-size:20px;font-weight:bold;margin:10px'>" + Title + "</div>"; var dateHtml = "<div style='text-align:center;color:gray;font-size:12px'>有效期:" + EffectiveStartTime + " 至 " + EffectiveEndTime + "</div>"; var download = new StringBuilder(); foreach (var m in model.NoticeAttachments) { download.AppendFormat("<a href='" + m.Url + "' title='" + m.Name + "' target='_blank'>" + m.Name + "</a> <br/> "); } HtmlString = string.Format( "<html><head><meta http-equiv=\"X-UA-Compatible\" content=\"IE=9\" />" + "<meta http-equiv=\"content-type\" content=\"text/html;charset=utf-8\" /></head>" + "<body>{0}{1}{2}<div style='text-align:right;padding:20px; margin-top:50px;font-size:12px'>" + "{3}</div><div style='margin-top:50px'>{4}</div></body></html>", titleHtml, dateHtml, model.Contents, model.CreateTime.ToString("yyyy-MM-dd HH:mm:ss"), download); if (model.NoticeAttachments == null || model.NoticeAttachments.Count < 1) { IsShowAttachMent = false; } else { IsShowAttachMent = true; } isBusy = false; })); }
public IActionResult edit(NoticeDto notice_dto, IFormFile file = null) { try { if (ModelState.IsValid) { if (file != null) { string fileName = notice_dto.title; notice_dto.image_name = _fileHelper.saveImageAndGetFileName(file, fileName); } _noticeService.update(notice_dto); AlertHelper.setMessage(this, "Notice updated successfully."); return(RedirectToAction("index")); } } catch (Exception ex) { AlertHelper.setMessage(this, ex.Message, messageType.error); } return(View(notice_dto)); }
public async Task <IActionResult> Edit(long?id) { if (id.HasValue) { //编辑 var model = await _service.GetByIdAsync(id.Value); if (model == null) { throw new VinoDataNotFoundException("无法取得数据!"); } ViewData["Mode"] = "Edit"; return(View(model)); } else { //新增 NoticeDto dto = new NoticeDto(); ViewData["Mode"] = "Add"; return(View(dto)); } }
private void SearchNotice(string noticeID) { DataSet ds1 = webService.GetNoticeByNoticeID(noticeID); List <NoticeDto> noteList = new List <NoticeDto>(); if (ds1.Tables[0].Rows.Count > 0) { NoticeDto dto = new NoticeDto(); dto.NoticeID = ds1.Tables[0].Rows[0]["NoticeID"].ToString(); dto.NoticeTitle = ds1.Tables[0].Rows[0]["NoticeTitle"].ToString(); dto.NoticeContent = ds1.Tables[0].Rows[0]["NoticeContent"].ToString(); this.NoticeID = dto.NoticeID; txtTitle.Text = dto.NoticeTitle; txtContent.Text = dto.NoticeContent; } DataSet ds2 = webService.GetAllNoticeAttachment(NoticeID); List <NoticeAttachmentDto> noticeAttachmentList = new List <NoticeAttachmentDto>(); if (ds2.Tables[0].Rows.Count > 0) { for (int i = 0; i < ds2.Tables[0].Rows.Count; i++) { NoticeAttachmentDto dto = new NoticeAttachmentDto(); dto.AttachName = ds2.Tables[0].Rows[i]["AttachName"].ToString(); dto.SeqNO = Convert.ToInt32(ds2.Tables[0].Rows[i]["SeqNO"]); if (!string.IsNullOrEmpty(dto.AttachName)) { dto.FileExist = true; } else { dto.FileExist = false; } noticeAttachmentList.Add(dto); } } grcAttachment.DataSource = noticeAttachmentList; }
protected override void DataPortal_Update() { var dto = new NoticeDto(); dto.NoticeId = NoticeId; dto.Title = Title; dto.Content = Content; dto.Url = Url; dto.LastUser = LastUser; dto.LastModefied = ReadProperty(LastModefiedProperty); using (var dalManager = DalFactoryGetManager.GetManager()) { var args = new DataPortalHookArgs(dto); OnUpdatePre(args); var dal = dalManager.GetProvider <INoticeDal>(); using (BypassPropertyChecks) { var resultDto = dal.Update(dto); args = new DataPortalHookArgs(resultDto); } OnUpdatePost(args); } }
public JsonResult UpdatePost() { var id = RequestHelper.GetValue("id"); var title = RequestHelper.GetValue("title"); var contents = RequestHelper.GetValue("contents"); if (string.IsNullOrEmpty(title) || string.IsNullOrEmpty(contents)) { return(Json(new { result = false, info = "缺少必要参数" }, JsonRequestBehavior.DenyGet)); } var dto = new NoticeDto() { Id = id, CreateTime = DateTime.Now, Title = title, Contents = contents, IsDelete = 0 }; var result = NoticeService.Update(dto); LogService.Info($"NoticeService.Update >>> {result} --- {id}:{title}"); return(Json(new { result = result }, JsonRequestBehavior.DenyGet)); }
public void ModifyNotice(NoticeDto noticeDto) { var model = this.noticeRepository.FindAll(p => p.ID == noticeDto.ID).SingleOrDefault(); if (model == null) { throw new CustomException(500, "公告不存在"); } model.NoticeShowType = noticeDto.NoticeShowType; model.NoticeAttachments.Clear(); noticeDto.NoticeAttachments.Select(p => new NoticeAttachment { Url = p.Url, Name = p.Name, }).ToList().ForEach(x => model.NoticeAttachments.Add(x)); model.NoticeType = noticeDto.NoticeType; model.Title = noticeDto.Title; model.Contents = noticeDto.Contents; model.EffectiveStartTime = noticeDto.EffectiveStartTime; model.EffectiveEndTime = noticeDto.EffectiveEndTime.AddHours(23).AddMinutes(59).AddSeconds(59); model.State = noticeDto.State; this.unitOfWorkRepository.PersistUpdateOf(model); this.unitOfWork.Commit(); }