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