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