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