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