public static ResponseBase CreateOrUpdate(MAIL_RECEIVE obj) { var result = new ResponseBase(); var flag = true; try { var db = new PMSEntities(); if (obj.Id == 0) { db.MAIL_RECEIVE.Add(obj); } else { var mail = db.MAIL_RECEIVE.FirstOrDefault(x => !x.IsDeleted && x.Id == obj.Id); if (mail != null) { mail.Address = obj.Address; mail.IsActive = obj.IsActive; mail.Note = obj.Note; } else { result.IsSuccess = false; result.Messages.Add(new Message() { Title = "Thông Báo", msg = "Không tìm thấy thông tin Mail bạn đang thao tác." }); } } if (flag) { db.SaveChanges(); result.IsSuccess = true; result.Messages.Add(new Message() { Title = "Thông Báo", msg = "Lưu thành công." }); } } catch (Exception ex) { throw ex; } return(result); }
private void SaveMail_R() { try { var mail_R = new MAIL_RECEIVE(); mail_R.Id = mailReceiveId; mail_R.Address = txtAddressReceive.Text; mail_R.IsActive = chkIsActiveReceive.Checked; mail_R.Note = txtNoteReceive.Text; var result = BLLMailReceive.CreateOrUpdate(mail_R); MessageBox.Show(result.Messages[0].msg, result.Messages[0].Title); if (result.IsSuccess) { ResetMailReceiveForm(); LoadListMailReceiveToGridView(); } } catch (Exception ex) { MessageBox.Show("Lỗi :" + ex.Message); } }
/// <summary> /// 金庫進出管理作業-覆核 /// </summary> /// <param name="db">Entities</param> /// <param name="aplyNos">覆核的申請單號</param> /// <param name="logStr">log</param> /// <param name="dt">執行時間</param> /// <param name="userId">覆核人ID</param> /// <returns></returns> public Tuple <bool, string> TinApproved(TreasuryDBEntities db, List <string> aplyNos, string logStr, DateTime dt, string userId) { foreach (var aplyNo in aplyNos) { var MCH = db.MAIL_CONTENT_HIS.First(x => x.APLY_NO == aplyNo); MCH.APPR_UID = userId; MCH.APPR_DATE = dt; MCH.APPR_STATUS = "2"; //覆核完成 var _MAIL_CONTENT_ID = string.Empty; List <MAIL_RECEIVE> MRS = new List <MAIL_RECEIVE>(); if (!MCH.MAIL_CONTENT_ID.IsNullOrWhiteSpace()) { logStr += MCH.modelToString(logStr); var MC = db.MAIL_CONTENT.First(x => x.MAIL_CONTENT_ID == MCH.MAIL_CONTENT_ID); MC.FREEZE_DT = null; MC.FREEZE_UID = null; MC.APPR_UID = userId; MC.APPR_DT = dt; MC.DATA_STATUS = "1"; //可異動 MC.MAIL_SUBJECT = MCH.MAIL_SUBJECT; MC.MAIL_CONTENT1 = MCH.MAIL_CONTENT; MC.IS_DISABLED = MCH.IS_DISABLED; _MAIL_CONTENT_ID = MC.MAIL_CONTENT_ID; logStr += MC.modelToString(logStr); MRS = db.MAIL_RECEIVE.Where(x => x.MAIL_CONTENT_ID == MCH.MAIL_CONTENT_ID).ToList(); } else { SysSeqDao sysSeqDao = new SysSeqDao(); _MAIL_CONTENT_ID = $@"{sysSeqDao.qrySeqNo("D4", string.Empty).ToString().PadLeft(2, '0')}"; MCH.MAIL_CONTENT_ID = _MAIL_CONTENT_ID; logStr += MCH.modelToString(logStr); var MC = new MAIL_CONTENT() { MAIL_CONTENT_ID = _MAIL_CONTENT_ID, MAIL_SUBJECT = MCH.MAIL_SUBJECT, MAIL_CONTENT1 = MCH.MAIL_CONTENT, IS_DISABLED = MCH.IS_DISABLED, CREATE_UID = MCH.APLY_UID, CREATE_DT = MCH.APLY_DATE, LAST_UPDATE_UID = MCH.APLY_UID, LAST_UPDATE_DT = dt, APPR_UID = userId, APPR_DT = dt, DATA_STATUS = "1" //可異動 }; db.MAIL_CONTENT.Add(MC); logStr += MC.modelToString(logStr); } foreach (var subitem in db.MAIL_RECEIVE_HIS .Where(x => x.APLY_NO == aplyNo && x.EXEC_ACTION != null)) { MAIL_RECEIVE _MR = new MAIL_RECEIVE(); switch (subitem.EXEC_ACTION) { case "A": _MR = new MAIL_RECEIVE() { MAIL_CONTENT_ID = _MAIL_CONTENT_ID, FUNC_ID = subitem.FUNC_ID, DATA_STATUS = "1", //可異動 CREATE_UID = MCH.APLY_UID, CREATE_DT = MCH.APLY_DATE, APPR_UID = userId, APPR_DT = dt, LAST_UPDATE_UID = MCH.APLY_UID, LAST_UPDATE_DT = MCH.APLY_DATE }; logStr += _MR.modelToString(logStr); db.MAIL_RECEIVE.Add(_MR); break; case "D": _MR = MRS.FirstOrDefault(x => x.FUNC_ID == subitem.FUNC_ID); if (_MR != null) { db.MAIL_RECEIVE.Remove(_MR); } break; } } } return(new Tuple <bool, string>(true, logStr)); }