public JsonResult ResetData() { MSGReturnModel <string> result = new MSGReturnModel <string>(); var searchModel = (RctCompSearchViewModel)Cache.Get(CacheList.RctCompSearchData); var _data = RctCompRelation.GetSearchData(searchModel); Cache.Invalidate(CacheList.RctCompViewData); Cache.Set(CacheList.RctCompViewData, _data); return(Json(result)); }
public MSGReturnModel saveGuarantorTicker(string actionType, GuarantorTickerViewModel dataModel) { MSGReturnModel result = new MSGReturnModel(); using (IFRS9DBEntities db = new IFRS9DBEntities()) { try { if (actionType == "Add") { if (db.Guarantor_Ticker.AsNoTracking() .Where(x => x.Issuer == dataModel.Issuer) .Count() > 0) { result.RETURN_FLAG = false; result.DESCRIPTION = string.Format("資料重複:{0} 已存在", dataModel.Issuer); return(result); } Guarantor_Ticker addData = new Guarantor_Ticker(); addData.Issuer = dataModel.Issuer; addData.GUARANTOR_NAME = dataModel.GUARANTOR_NAME; addData.GUARANTOR_EQY_TICKER = dataModel.GUARANTOR_EQY_TICKER; addData.Create_User = _UserInfo._user; addData.Create_Date = _UserInfo._date; addData.Create_Time = _UserInfo._time; db.Guarantor_Ticker.Add(addData); } else if (actionType == "Modify") { Guarantor_Ticker oldData = db.Guarantor_Ticker .Where(x => x.Issuer == dataModel.Issuer) .FirstOrDefault(); oldData.GUARANTOR_NAME = dataModel.GUARANTOR_NAME; oldData.GUARANTOR_EQY_TICKER = dataModel.GUARANTOR_EQY_TICKER; oldData.LastUpdate_User = _UserInfo._user; oldData.LastUpdate_Date = _UserInfo._date; oldData.LastUpdate_Time = _UserInfo._time; } db.SaveChanges(); result.RETURN_FLAG = true; } catch (DbUpdateException ex) { result.RETURN_FLAG = false; result.DESCRIPTION = ex.Message; } } return(result); }
public JsonResult GetA52AuditExcel(string Audit_date) { MSGReturnModel result = new MSGReturnModel(); result.RETURN_FLAG = false; var A52Audit = Excel_DownloadName.A52Audit.ToString(); var A52AuditData = A5Repository.GetA52byAuditdate(Audit_date); //從Cache 抓資料 result = A5Repository.DownLoadExcel(A52Audit, ExcelLocation(A52Audit.GetExelName()), A52AuditData); return(Json(result)); }
public JsonResult CheckedData(string checkedmodel, bool checkedFlag) { MSGReturnModel <bool> result = new MSGReturnModel <bool>(); result.RETURN_FLAG = false; result.DESCRIPTION = Ref.MessageType.login_Time_Out.GetDescription(); if (Cache.IsSet(CacheList.TREAReviewWorkDetailViewData)) { var tempData = (List <TREAReviewWorkDetailViewModel>)Cache.Get(CacheList.TREAReviewWorkDetailViewData); var updateTempData = tempData.FirstOrDefault(x => x.hvTREA_REGISTER_ID == checkedmodel); if (updateTempData != null) { updateTempData.Ischecked = checkedFlag; Cache.Invalidate(CacheList.TREAReviewWorkDetailViewData); Cache.Set(CacheList.TREAReviewWorkDetailViewData, tempData); result.RETURN_FLAG = true; result.DESCRIPTION = Ref.MessageType.update_Success.GetDescription(); //檢查已勾選的項目是否有最後修改者為目前登入者 var viewModel = (List <TREAReviewWorkDetailViewModel>)Cache.Get(CacheList.TREAReviewWorkDetailViewData); bool canDo = false; viewModel.ForEach(x => { if (x.Ischecked && x.vLAST_UPDATE_UID == AccountController.CurrentUserId) { canDo = false; } else { canDo = true; } }); if (viewModel.All(x => x.Ischecked == false)) { canDo = true; } result.Datas = canDo; //if (canDo == true) //{ // result.Datas = true; //可以執行覆核、駁回 //} //else //{ // result.Datas = false; //} } else { result.RETURN_FLAG = false; result.DESCRIPTION = Ref.MessageType.update_Fail.GetDescription(); } } return(Json(result)); }
public JsonResult GetD74_1(string noticeID) { MSGReturnModel result = new MSGReturnModel(); var datas = D7Repository.GetD74_1(noticeID); Cache.Invalidate(CacheList.D74_1DbfileData); //清除 Cache Cache.Set(CacheList.D74_1DbfileData, datas); //把資料存到 Cache return(Json(result)); }
public MSGReturnModel saveA63(List <A63ViewModel> dataModel) { MSGReturnModel result = new MSGReturnModel(); if (!dataModel.Any()) { result.RETURN_FLAG = false; result.DESCRIPTION = Message_Type.parameter_Error .GetDescription(Table_Type.A63.ToString()); return(result); } string dataYear = dataModel.First().Data_Year; using (IFRS9DBEntities db = new IFRS9DBEntities()) { if (db.Moody_LGD_Info.AsNoTracking().Where(x => x.Data_Year == dataYear && x.Status == "1").Any()) { result.RETURN_FLAG = false; result.DESCRIPTION = $"{dataYear} 的資料狀態為 啟用,如要重新轉檔,請複核者先將原本的資料設為 暫不啟用。"; return(result); } db.Moody_LGD_Info.RemoveRange(db.Moody_LGD_Info .Where(x => x.Data_Year == dataYear)); #region save Moody_LGD_Info(A62) db.Moody_LGD_Info.AddRange( dataModel.Select(x => new Moody_LGD_Info() { Data_Year = x.Data_Year, Lien_Position = x.Lien_Position, Recovery_Rate = double.Parse(x.Recovery_Rate), LGD = double.Parse(x.LGD) })); #endregion save Moody_LGD_Info(A62) try { db.SaveChanges(); result.RETURN_FLAG = true; result.DESCRIPTION = "年度違約損失率已更新,請通知主管複核"; } catch (Exception ex) { result.RETURN_FLAG = false; result.DESCRIPTION = ex.Message; } } return(result); }
public MSGReturnModel saveA94(string actionType, A94ViewModel dataModel) { MSGReturnModel result = new MSGReturnModel(); using (IFRS9DBEntities db = new IFRS9DBEntities()) { try { Gov_Info_Ticker editData = new Gov_Info_Ticker(); if (actionType == "Add") { if (db.Gov_Info_Ticker.AsNoTracking() .Where(x => x.Country == dataModel.Country) .FirstOrDefault() != null) { result.RETURN_FLAG = false; result.DESCRIPTION = "資料重複:您輸入的 國家 已存在"; return(result); } editData.Country = dataModel.Country; } else if (actionType == "Modify") { editData = db.Gov_Info_Ticker .Where(x => x.Country == dataModel.Country) .FirstOrDefault(); } editData.IGS_Index_Map = dataModel.IGS_Index_Map; editData.Short_term_Debt_Map = dataModel.Short_term_Debt_Map; editData.Foreign_Exchange_Map = dataModel.Foreign_Exchange_Map; editData.GDP_Yearly_Map = dataModel.GDP_Yearly_Map; if (actionType == "Add") { db.Gov_Info_Ticker.Add(editData); } db.SaveChanges(); //Save result.RETURN_FLAG = true; } catch (Exception ex) { result.RETURN_FLAG = false; result.DESCRIPTION = ex.Message; } } return(result); }
/// <summary> /// 新增,刪除,修改 A96 最後交易日 /// </summary> /// <param name="data"></param> /// <param name="type"></param> /// <returns></returns> public MSGReturnModel saveA96Trade(A96TradeViewModel data, Action_Type type) { MSGReturnModel result = new MSGReturnModel(); result.RETURN_FLAG = false; using (IFRS9DBEntities db = new IFRS9DBEntities()) { var reportDate = TypeTransfer.stringToDateTime(data.Report_Date); if (type == Action_Type.Add) { db.Bond_Spread_Trade_Info.Add( new Bond_Spread_Trade_Info() { Report_Date = reportDate, Last_Date = TypeTransfer.stringToDateTime(data.Last_Date), Create_User = _UserInfo._user, Create_Date = _UserInfo._date, Create_Time = _UserInfo._time, LastUpdate_User = _UserInfo._user, LastUpdate_Date = _UserInfo._date, LastUpdate_Time = _UserInfo._time }); result.DESCRIPTION = Message_Type.save_Success.GetDescription(); } else if (type == Action_Type.Dele) { db.Bond_Spread_Trade_Info.Remove(db.Bond_Spread_Trade_Info.First(x => x.Report_Date == reportDate)); result.DESCRIPTION = Message_Type.delete_Success.GetDescription(); } else if (type == Action_Type.Edit) { var _trade = db.Bond_Spread_Trade_Info.FirstOrDefault(x => x.Report_Date == reportDate); if (_trade != null) { _trade.Last_Date = TypeTransfer.stringToDateTime(data.Last_Date); _trade.LastUpdate_User = _UserInfo._user; _trade.LastUpdate_Date = _UserInfo._date; _trade.LastUpdate_Time = _UserInfo._time; } result.DESCRIPTION = Message_Type.save_Success.GetDescription(); } try { db.SaveChanges(); result.RETURN_FLAG = true; } catch (Exception ex) { result.DESCRIPTION = ex.exceptionMessage(); } } return(result); }
public JsonResult CheckItemBook(string building_Name) { MSGReturnModel <string> result = new MSGReturnModel <string>(); result.RETURN_FLAG = false; result.DESCRIPTION = Ref.MessageType.parameter_Error.GetDescription(); if (!building_Name.IsNullOrWhiteSpace()) { result = Estate.GetCheckItemBook(building_Name); } return(Json(result)); }
/// <summary> /// 取消申請 /// </summary> /// <param name="AplyNo"></param> /// <param name="searchModel"></param> /// <param name="cUserId"></param> /// <returns></returns> public MSGReturnModel <string> ResetData(string AplyNo, ItemChargeUnitSearchViewModel searchModel, string cUserId) { MSGReturnModel <string> result = new MSGReturnModel <string>(); DateTime dt = DateTime.Now; try { if (AplyNo != null) { using (TreasuryDBEntities db = new TreasuryDBEntities()) { var _ITEM_CHARGE_UNIT_HIS = db.ITEM_CHARGE_UNIT_HIS.FirstOrDefault(x => x.APLY_NO == AplyNo); if (_ITEM_CHARGE_UNIT_HIS.APLY_UID == cUserId) { var _ITEM_CHARGE_UNIT = db.ITEM_CHARGE_UNIT.FirstOrDefault(x => x.CHARGE_UNIT_ID == _ITEM_CHARGE_UNIT_HIS.CHARGE_UNIT_ID); switch (_ITEM_CHARGE_UNIT_HIS.EXEC_ACTION) { case "A": _ITEM_CHARGE_UNIT_HIS.APPR_STATUS = "4"; db.ITEM_CHARGE_UNIT.Remove(_ITEM_CHARGE_UNIT); break; case "U": _ITEM_CHARGE_UNIT_HIS.APPR_STATUS = "4"; _ITEM_CHARGE_UNIT.DATA_STATUS = "1"; _ITEM_CHARGE_UNIT.LAST_UPDATE_DT = dt; _ITEM_CHARGE_UNIT.LAST_UPDATE_UID = cUserId; _ITEM_CHARGE_UNIT.FREEZE_DT = null; _ITEM_CHARGE_UNIT.FREEZE_UID = null; break; } } else { result.DESCRIPTION = "非申請者無法取消申請"; } } } else { result.DESCRIPTION = Ref.MessageType.not_Find_Audit_Data.GetDescription(); } } catch (Exception ex) { result.DESCRIPTION = ex.exceptionMessage(); } return(result); }
/// <summary> /// D05 save db /// </summary> /// <param name="dataModel"></param> /// <returns></returns> public MSGReturnModel saveD05(string debtType, string actionType, D05ViewModel dataModel) { MSGReturnModel result = new MSGReturnModel(); try { if (debtType != dataModel.Group_Product_Code.Substring(0, 1)) { result.RETURN_FLAG = false; result.DESCRIPTION = "套用產品群代碼 第一個字必須是 " + debtType; return(result); } if (actionType == "Add") { if (db.Group_Product_Code_Mapping.Where(x => x.Product_Code == dataModel.Product_Code).Count() > 0) { result.RETURN_FLAG = false; result.DESCRIPTION = "資料重複:" + dataModel.Product_Code + " 已存在"; return(result); } db.Group_Product_Code_Mapping.Add( new Group_Product_Code_Mapping() { Group_Product_Code = dataModel.Group_Product_Code, Product_Code = dataModel.Product_Code, Processing_Date = DateTime.Parse(dataModel.Processing_Date) }); } else if (actionType == "Modify") { Group_Product_Code_Mapping oldData = db.Group_Product_Code_Mapping.Find(dataModel.Product_Code); oldData.Group_Product_Code = dataModel.Group_Product_Code; oldData.Product_Code = dataModel.Product_Code; oldData.Processing_Date = DateTime.Parse(dataModel.Processing_Date); } db.SaveChanges(); //Save result.RETURN_FLAG = true; } catch (DbUpdateException ex) { result.RETURN_FLAG = false; result.DESCRIPTION = Message_Type .save_Fail.GetDescription("D05", $"message: {ex.Message}" + $", inner message {ex.InnerException?.InnerException?.Message}"); } return(result); }
/// <summary> /// save A95_1 (產業別對應Ticker補登檔) /// </summary> /// <param name="data"></param> /// <param name="type"></param> /// <returns></returns> public MSGReturnModel saveA95_1(A95_1ViewModel data, Action_Type type) { MSGReturnModel result = new MSGReturnModel(); result.RETURN_FLAG = false; var _tableName = Table_Type.A95_1.tableNameGetDescription(); if (data == null || data.Bond_Number.IsNullOrWhiteSpace()) { result.DESCRIPTION = Message_Type.parameter_Error.GetDescription(_tableName); return(result); } using (IFRS9DBEntities db = new IFRS9DBEntities()) { if ((type & Action_Type.Edit) == Action_Type.Edit) { var _edit = db.Assessment_Sub_Kind_Ticker.FirstOrDefault(x => x.Bond_Number == data.Bond_Number); if (_edit == null) { result.DESCRIPTION = Message_Type.already_Change.GetDescription(_tableName); return(result); } _edit.Bloomberg_Ticker = data.Bloomberg_Ticker; _edit.Security_Des = data.Security_Des; _edit.LastUpdate_User = _UserInfo._user; _edit.LastUpdate_Date = _UserInfo._date; _edit.LastUpdate_Time = _UserInfo._time; result.DESCRIPTION = Message_Type.update_Success.GetDescription(_tableName); } else if ((type & Action_Type.Dele) == Action_Type.Dele) { var _dele = db.Assessment_Sub_Kind_Ticker.FirstOrDefault(x => x.Bond_Number == data.Bond_Number); if (_dele == null) { result.DESCRIPTION = Message_Type.already_Change.GetDescription(_tableName); return(result); } db.Assessment_Sub_Kind_Ticker.Remove(_dele); result.DESCRIPTION = Message_Type.delete_Success.GetDescription(_tableName); } try { db.SaveChanges(); result.RETURN_FLAG = true; } catch (DbUpdateException ex) { result.DESCRIPTION = ex.exceptionMessage(); } } return(result); }
public JsonResult UpdateDbData(CDCCAViewModel model) { MSGReturnModel <bool> result = new MSGReturnModel <bool>(); result.RETURN_FLAG = false; result.DESCRIPTION = Ref.MessageType.login_Time_Out.GetDescription(); if (Cache.IsSet(CacheList.CDCCAData)) { var dbData = (List <CDCCAViewModel>)Cache.Get(CacheList.CDCCAData); var updateTempData = dbData.FirstOrDefault(x => x.vItemId == model.vItemId); if (updateTempData != null) { var _vCA_Use_AFT = model.vCA_Use.CheckAFT(updateTempData.vCA_Use); if (_vCA_Use_AFT.Item2) { updateTempData.vCA_Use_AFT = _vCA_Use_AFT.Item1; } var _vCA_Desc_AFT = model.vCA_Desc.CheckAFT(updateTempData.vCA_Desc); if (_vCA_Desc_AFT.Item2) { updateTempData.vCA_Desc_AFT = _vCA_Desc_AFT.Item1; } var _vCA_Bank_AFT = model.vCA_Bank.CheckAFT(updateTempData.vCA_Bank); if (_vCA_Bank_AFT.Item2) { updateTempData.vCA_Bank_AFT = _vCA_Bank_AFT.Item1; } var _vCA_Number_AFT = model.vCA_Number.CheckAFT(updateTempData.vCA_Number); if (_vCA_Number_AFT.Item2) { updateTempData.vCA_Number_AFT = _vCA_Number_AFT.Item1; } var _vCA_Memo_AFT = model.vCA_Memo.CheckAFT(updateTempData.vCA_Memo); if (_vCA_Memo_AFT.Item2) { updateTempData.vCA_Memo_AFT = _vCA_Memo_AFT.Item1; } updateTempData.vAFTFlag = _vCA_Use_AFT.Item2 || _vCA_Desc_AFT.Item2 || _vCA_Bank_AFT.Item2 || _vCA_Number_AFT.Item2 || _vCA_Memo_AFT.Item2; Cache.Invalidate(CacheList.CDCCAData); Cache.Set(CacheList.CDCCAData, dbData); result.Datas = dbData.Any(x => x.vAFTFlag); result.RETURN_FLAG = true; result.DESCRIPTION = Ref.MessageType.update_Success.GetDescription(); } else { result.RETURN_FLAG = false; result.DESCRIPTION = Ref.MessageType.update_Fail.GetDescription(); } } return(Json(result)); }
public JsonResult GetA51Year() { MSGReturnModel result = new MSGReturnModel(); result.RETURN_FLAG = true; result.Datas = Json(new SelectList( A7Repository.GetA51SearchYear() .Select(x => new SelectOption() { Text = x, Value = x.Split('(')[0] }), "Value", "Text")); return(Json(result)); }
public JsonResult A52Aduit(string ID, string Status, string Auditor_Reply) { MSGReturnModel result = new MSGReturnModel(); result = A5Repository.A52Audit(TypeTransfer.stringToIntN(ID), Status, Auditor_Reply); if (result.RETURN_FLAG) { var queryResult = A5Repository.getA52("All", "All", "All", "All", null); Cache.Invalidate(CacheList.A52AuditDbfileData); //清除 Cache.Set(CacheList.A52AuditDbfileData, queryResult.Item2); //把資料存到 Cache } return(Json(result)); }
public JsonResult CancelTempData() { MSGReturnModel <string> result = new MSGReturnModel <string>(); var datas = TreasuryMailTime.GetSearchData(new TreasuryMailTimeSearchViewModel()); if (datas.Any()) { result.RETURN_FLAG = true; Cache.Invalidate(CacheList.TreasuryMailTimeData); Cache.Set(CacheList.TreasuryMailTimeData, datas); } return(Json(result)); }
/// <summary> /// Save GM_YYYY(A73) /// </summary> /// <returns></returns> public MSGReturnModel saveA73() { MSGReturnModel result = new MSGReturnModel(); try { if (db.Moody_Tm_YYYY.Any()) { DataTable datas = getExhibit29ModelFromDb(db.Moody_Tm_YYYY.ToList()).Item1; DataTable A73Datas = FromA72GetA73(datas); string cs = common.RemoveEntityFrameworkMetadata(string.Empty); using (var conn = new SqlConnection(cs)) { using (var cmd = new SqlCommand(CreateA7Table(Table_Type.A73.GetDescription(), A73Datas), conn)) { conn.Open(); int count = cmd.ExecuteNonQuery(); if (A73Datas.Rows.Count > 0 && A73Datas.Rows.Count.Equals(count)) { result.RETURN_FLAG = true; result.DESCRIPTION = Message_Type.save_Success .GetDescription(Table_Type.A73.ToString()); } else { result.RETURN_FLAG = false; result.DESCRIPTION = Message_Type.save_Fail .GetDescription(Table_Type.A73.ToString(), "新增筆數有誤!"); } } } } } catch (SqlException ex) { result.RETURN_FLAG = false; result.DESCRIPTION = Message_Type .save_Fail.GetDescription(Table_Type.A73.ToString(), $"message: {ex.Message}" + $", inner message {ex.InnerException?.InnerException?.Message}"); } catch (Exception ex) { result.RETURN_FLAG = false; result.DESCRIPTION = Message_Type .save_Fail.GetDescription(Table_Type.A73.ToString(), $"message: {ex.Message}" + $", inner message {ex.InnerException?.InnerException?.Message}"); } return(result); }
/// <summary> /// save A62 /// </summary> /// <param name="dataModel">Exhibit7Model</param> /// <returns></returns> public MSGReturnModel saveA62(List <Exhibit7Model> dataModel) { MSGReturnModel result = new MSGReturnModel(); if (!dataModel.Any()) { result.RETURN_FLAG = false; result.DESCRIPTION = Message_Type.parameter_Error .GetDescription(Table_Type.A62.ToString()); return(result); } string dataYear = dataModel.First().Data_Year; if (db.Moody_LGD_Info .Any(x => dataYear.Equals(x.Data_Year))) { result.RETURN_FLAG = false; result.DESCRIPTION = Message_Type.already_Save .GetDescription(Table_Type.A62.ToString()); return(result); } #region save Moody_LGD_Info(A62) db.Moody_LGD_Info.AddRange( dataModel.Select(x => new Moody_LGD_Info() { Data_Year = x.Data_Year, Lien_Position = x.Lien_Position, Recovery_Rate = TypeTransfer.stringToDoubleN(x.Recovery_Rate), LGD = TypeTransfer.stringToDoubleN(x.LGD) })); #endregion save Moody_LGD_Info(A62) try { db.SaveChanges(); result.RETURN_FLAG = true; result.DESCRIPTION = Message_Type.save_Success.GetDescription(); } catch (DbUpdateException ex) { result.RETURN_FLAG = false; result.DESCRIPTION = Message_Type .save_Fail.GetDescription(Table_Type.A62.ToString(), $"message: {ex.Message}" + $", inner message {ex.InnerException?.InnerException?.Message}"); } return(result); }
/// <summary> /// /// </summary> /// <param name="menuSub"></param> /// <param name="userName"></param> /// <returns></returns> public MSGReturnModel saveMenu(List <CheckBoxListInfo> menuSub, string userName) { MSGReturnModel result = new MSGReturnModel(); if (!menuSub.Any() && userName.IsNullOrWhiteSpace()) { result.RETURN_FLAG = false; result.DESCRIPTION = Message_Type.parameter_Error.GetDescription(); return(result); } List <IFRS9_Menu_Set> sets = db.IFRS9_Menu_Set .Where(x => userName.Equals(x.User_Name)).ToList(); foreach (CheckBoxListInfo item in menuSub) { IFRS9_Menu_Set set = sets.FirstOrDefault(x => item.Value.Equals(x.Menu_Id)); if (set != null) //原本有設定 { if (!item.IsChecked) //設定無權限 { db.IFRS9_Menu_Set.Remove(set); } } else //原本無設定 { if (item.IsChecked) { db.IFRS9_Menu_Set.Add(new IFRS9_Menu_Set() { User_Name = userName, Menu_Id = item.Value }); } } } try { db.SaveChanges(); result.RETURN_FLAG = true; result.DESCRIPTION = Message_Type.save_Success.GetDescription(); } catch (DbUpdateException ex) { result.RETURN_FLAG = false; result.DESCRIPTION = Message_Type.save_Fail .GetDescription(null, $"message: {ex.Message}" + $", inner message {ex.InnerException?.InnerException?.Message}"); } return(result); }
public JsonResult GetC10Excel(string type) { MSGReturnModel result = new MSGReturnModel(); result.RETURN_FLAG = false; if (Cache.IsSet(CacheList.C10DbfileData)) { var C10 = Excel_DownloadName.C10.ToString(); var C10Data = (List <C10DetailViewModel>)Cache.Get(CacheList.C10DbfileData); //從Cache 抓資料 result = C0Repository.DownLoadExcelC10(type, ExcelLocation(type.GetExelName()), C10Data); } return(Json(result)); }
public JsonResult GetCDCStockDetailDate(int Group_No, int Trea_Batch_No, string Aply_No) { MSGReturnModel <StockDetailViewModel> result = new MSGReturnModel <StockDetailViewModel>(); result.RETURN_FLAG = false; result.DESCRIPTION = Ref.MessageType.login_Time_Out.GetDescription(); CDCSearchViewModel data = (CDCSearchViewModel)Cache.Get(CacheList.CDCSearchViewModel); var _data = Stock.GetCDCDetailData(data, Group_No, Trea_Batch_No, Aply_No); Cache.Invalidate(CacheList.CDCStockDataD); Cache.Set(CacheList.CDCStockDataD, _data); 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); }
public JsonResult SearchA57( string datepicker, string version, string from, string to, string SMF, string stype, string bondNumber, string issuer, string status) { MSGReturnModel result = new MSGReturnModel(); result.RETURN_FLAG = false; DateTime dp = DateTime.MinValue; DateTime? df = TypeTransfer.stringToDateTimeN(from); DateTime? dt = TypeTransfer.stringToDateTimeN(to); int v = 0; bool flag = false; Rating_Status rs = Rating_Status.All; EnumUtil.GetValues <Rating_Status>().ToList().ForEach(x => { if (x.ToString() == status) { rs = x; flag = true; } }); if (!flag || !DateTime.TryParse(datepicker, out dp) || !Int32.TryParse(version, out v)) { result.DESCRIPTION = Message_Type.parameter_Error.GetDescription(); } else { Cache.Invalidate(CacheList.A57DbfileData); //清除 var datas = A5Repository.GetA57(dp, v, df, dt, SMF, stype, bondNumber, issuer, rs); if (datas.Any()) { result.RETURN_FLAG = true; Cache.Set(CacheList.A57DbfileData, datas); //把資料存到 Cache } else { result.DESCRIPTION = Message_Type.not_Find_Any.GetDescription(); } } return(Json(result)); }
public JsonResult SearchAccountLog(AccountLogViewModel model, string type, string range) { MSGReturnModel result = new MSGReturnModel(); result.RETURN_FLAG = false; result.DESCRIPTION = Message_Type.not_Find_Any.GetDescription(); List <AccountLogViewModel> datas = SystemRepository.getAccountLog(model, type, range); if (datas.Any()) { SetCacheDataInAccountLog(datas, type); result.RETURN_FLAG = true; } return(Json(result)); }
public JsonResult Check_Item_Name(string vItem_Name) { MSGReturnModel <string> result = new MSGReturnModel <string>(); var tempData = (List <ItemMaintainSearchDetailViewModel>)Cache.Get(CacheList.ItemMaintainSearchDetailViewData); if (tempData.Where(x => x.vITEM_DESC == vItem_Name && x.vIS_DISABLED == "N").Any() || ItemMaintain.Check_Item_Name(vItem_Name)) { result.RETURN_FLAG = true; } else { result.RETURN_FLAG = false; } return(Json(result)); }
public JsonResult DetailData(string vTrea_Register_Id) { MSGReturnModel <string> result = new MSGReturnModel <string>(); result.RETURN_FLAG = false; result.DESCRIPTION = Ref.MessageType.login_Time_Out.GetDescription(); Cache.Invalidate(CacheList.TreasuryRegisterSearchReportD); Cache.Set(CacheList.TreasuryRegisterSearchReportD, TreasuryRegisterSearchReport.GetDetailList(vTrea_Register_Id)); result.RETURN_FLAG = true; return(Json(result)); }
public JsonResult ResetTempData() { MSGReturnModel <string> result = new MSGReturnModel <string>(); var data = (DepChkItemSearchViewModel)Cache.Get(CacheList.DepChkItemSearchData); var datas = (List <DepChkItemViewModel>)DepChkItem.GetSearchData(data); if (datas.Any()) { Cache.Invalidate(CacheList.DepChkItem_P_SearchDataList); Cache.Set(CacheList.DepChkItem_P_SearchDataList, datas.Where(x => x.vAccess_Type == "P").ToList()); Cache.Invalidate(CacheList.DepChkItem_G_SearchDataList); Cache.Set(CacheList.DepChkItem_G_SearchDataList, datas.Where(x => x.vAccess_Type == "G").ToList()); } return(Json(result)); }
public JsonResult UpdateTempData(BillViewModel model) { MSGReturnModel <string> result = new MSGReturnModel <string>(); result.RETURN_FLAG = false; result.DESCRIPTION = Ref.MessageType.login_Time_Out.GetDescription(); if (Cache.IsSet(CacheList.BILLTempData) && Cache.IsSet(CacheList.TreasuryAccessViewData)) { var checkdata = (List <BillViewModel>)Cache.Get(CacheList.BILLDayData); var sameFlag = checkSameData(checkdata, model); if (!sameFlag.IsNullOrWhiteSpace()) { result.RETURN_FLAG = false; result.DESCRIPTION = sameFlag; return(Json(result)); } var data = (TreasuryAccessViewModel)Cache.Get(CacheList.TreasuryAccessViewData); var tempData = (List <BillViewModel>)Cache.Get(CacheList.BILLTempData); var dayData = (List <BillViewModel>)Bill.GetDayData(data.vAplyUnit); var updateTempData = tempData.FirstOrDefault(x => x.vItemId == model.vItemId); if (updateTempData != null) { updateTempData.vIssuingBank = model.vIssuingBank; updateTempData.vCheckType = model.vCheckType; updateTempData.vCheckNoTrack = model.vCheckNoTrack; updateTempData.vCheckNoB = model.vCheckNoB; updateTempData.vCheckNoE = model.vCheckNoE; updateTempData.vCheckTotalNum = model.vCheckTotalNum; Cache.Invalidate(CacheList.BILLTempData); Cache.Set(CacheList.BILLTempData, SetBillViewRowNum(tempData)); if (!data.vAplyNo.IsNullOrWhiteSpace()) { dayData = dayData.Where(x => x.vAplyNo != data.vAplyNo).ToList(); } dayData.AddRange(tempData.ModelConvert <BillViewModel, BillViewModel>()); Cache.Invalidate(CacheList.BILLDayData); Cache.Set(CacheList.BILLDayData, SetBillTakeOutViewModelGroup(dayData)); result.RETURN_FLAG = true; result.DESCRIPTION = Ref.MessageType.update_Success.GetDescription(); } else { result.RETURN_FLAG = false; result.DESCRIPTION = Ref.MessageType.update_Fail.GetDescription(); } } return(Json(result)); }
public JsonResult ResetOrder(string Access_Type, int Isortby, int Old_Order, int New_Order) { MSGReturnModel <string> result = new MSGReturnModel <string>(); var tempData = (List <DepChkItemViewModel>)Cache.Get(CacheList.DepChkItemOrderSearchDataList); //本次順序修改 var Updata = tempData.FirstOrDefault(x => x.vAccess_Type == Access_Type && x.vIsortby == Isortby); Updata.vItem_Order = New_Order; //判斷移動順序 if (New_Order < Old_Order)//往前移動 { int UpOtherOrder = New_Order + 1; var UpOtherData = tempData .Where(x => x.vAccess_Type == Access_Type && x.vIsortby != Isortby) .Where(x => x.vItem_Order >= New_Order && x.vItem_Order < Old_Order) .OrderBy(x => x.vItem_Order); foreach (var item in UpOtherData) { item.vItem_Order = UpOtherOrder; UpOtherOrder++; } } else//往後移動 { int UpOtherOrder = Old_Order; var UpOtherData = tempData .Where(x => x.vAccess_Type == Access_Type && x.vIsortby != Isortby) .Where(x => x.vItem_Order > Old_Order && x.vItem_Order <= New_Order) .OrderBy(x => x.vItem_Order); foreach (var item in UpOtherData) { item.vItem_Order = UpOtherOrder; UpOtherOrder++; } } Cache.Invalidate(CacheList.DepChkItemOrderSearchDataList); Cache.Set(CacheList.DepChkItemOrderSearchDataList, tempData); result.RETURN_FLAG = true; return(Json(result)); }
public JsonResult SearchAccount(string account) { MSGReturnModel result = new MSGReturnModel(); result.RETURN_FLAG = false; result.DESCRIPTION = Message_Type.not_Find_Any.GetDescription(); List <AccountViewModel> datas = SystemRepository.getAccount(account, adminAccount); if (datas.Any()) { SetCacheData(datas); result.RETURN_FLAG = true; } return(Json(result)); }