private TREA_OPEN_REC MappingTableForInsert(SpecifiedTimeTreasuryApplyViewModel data, string currentUserId)
{
//取得流水號
SysSeqDao sysSeqDao = new SysSeqDao();
string qPreCode = DateUtil.getCurChtDateTime().Split(' ')[0];
var cId = sysSeqDao.qrySeqNo("W", qPreCode).ToString().PadLeft(2, '0');
//統一取系統時間
DateTime dt = DateTime.Now;
return(new TREA_OPEN_REC()
{
TREA_REGISTER_ID = $@"W{qPreCode}{cId}", //申請單號 W+系統日期YYYMMDD(民國年)+2碼流水號,
OPEN_TREA_TYPE = "2", //開庫類型: 指定時間開庫
OPEN_TREA_REASON = string.Join(";", data.vOPEN_TREA_REASON_ID),
OPEN_TREA_TIME = data.vOPEN_TREA_TIME,
EXEC_TIME_B = data.vEXEC_TIME_B,
EXEC_TIME_E = data.vEXEC_TIME_E,
MEMO = data.vMEMO,
APPR_STATUS = "1", //覆核狀態: 表單申請
REGI_STATUS = "C02", // 登記簿狀態
CREATE_UID = currentUserId,
CREATE_DT = dt,
LAST_UPDATE_UID = currentUserId,
LAST_UPDATE_DT = dt,
OPEN_TREA_DATE = Convert.ToDateTime(data.vOPEN_TREA_DATE),
CREATE_UNIT = GetUserInfo(currentUserId).DPT_ID
});
}
public JsonResult InsertApply(SpecifiedTimeTreasuryApplyViewModel applyModel)
{
MSGReturnModel <List <SpecifiedTimeTreasurySearchDetailViewModel> > result = new MSGReturnModel <List <SpecifiedTimeTreasurySearchDetailViewModel> >();
result.RETURN_FLAG = false;
result.DESCRIPTION = Ref.MessageType.Apply_Audit_Fail.GetDescription();
var searchData = (SpecifiedTimeTreasurySearchViewModel)Cache.Get(CacheList.SpecifiedTimeTreasurySearchData);
//var datas = (List<SpecifiedTimeTreasurySearchDetailViewModel>)Cache.Get(CacheList.SpecifiedTimeTreasurySearchDetailViewData);
result = SpecifiedTimeTreasury.InsertApplyData(applyModel, AccountController.CurrentUserId, searchData);
if (result.RETURN_FLAG)
{
Cache.Invalidate(CacheList.SpecifiedTimeTreasurySearchDetailViewData);
Cache.Set(CacheList.SpecifiedTimeTreasurySearchDetailViewData, result.Datas);
}
return(Json(result));
}
/// <summary>
/// 新增申請覆核
/// </summary>
/// <param name="data"></param>
/// <param name="currentUserId">目前使用者ID</param>
/// <returns></returns>
public MSGReturnModel <List <SpecifiedTimeTreasurySearchDetailViewModel> > InsertApplyData(SpecifiedTimeTreasuryApplyViewModel data, string currentUserId, SpecifiedTimeTreasurySearchViewModel searchData)
{
var result = new MSGReturnModel <List <SpecifiedTimeTreasurySearchDetailViewModel> >();
result.RETURN_FLAG = false;
result.DESCRIPTION = Ref.MessageType.Apply_Audit_Fail.GetDescription();
string logStr = string.Empty; //log
using (TreasuryDBEntities db = new TreasuryDBEntities())
{
var _data = db.TREA_OPEN_REC
.Add(MappingTableForInsert(data, currentUserId));
logStr += _data.modelToString(logStr);
var validateMessage = db.GetValidationErrors().getValidateString();
if (validateMessage.Any())
{
result.DESCRIPTION = validateMessage;
}
else
{
try
{
db.SaveChanges();
#region LOG
//新增LOG
Log log = new Log();
log.CFUNCTION = "申請覆核";
log.CACTION = "C";
log.CCONTENT = logStr;
LogDao.Insert(log, currentUserId);
#endregion
result.RETURN_FLAG = true;
result.DESCRIPTION = Ref.MessageType.Apply_Audit_Success.GetDescription();;
}
catch (DbUpdateException ex)
{
result.DESCRIPTION = ex.exceptionMessage();
}
}
if (result.RETURN_FLAG)
{
result.Datas = GetSearchDetail(searchData);
}
}
return(result);
}
