public JsonResult InsertTempData(ItemChargeUnitInsertViewModel model)
{
MSGReturnModel <string> result = new MSGReturnModel <string>();
//List<ItemChargeUnitSearchDetailViewModel> tempData = new List<ItemChargeUnitSearchDetailViewModel>();
result.RETURN_FLAG = false;
result.DESCRIPTION = Ref.MessageType.login_Time_Out.GetDescription();
var HasSameName = ItemChargeUnit.CheckName(model);
//var HasSameData = tempData.FirstOrDefault(x => x.vTREA_ITEM_NAME == model.vTREA_ITEM_NAME && x.vCHARGE_UID == model.vCHARGE_UID);
if (HasSameName)
{
result.DESCRIPTION = string.Format("此經辦已經是資料庫名稱 {0} 的經辦", model.vTREA_ITEM_NAME_VALUE);
result.RETURN_FLAG = false;
return(Json(result));
}
if (Cache.IsSet(CacheList.ItemChargeUnitSearchDetailViewData))
{
var tempData = (List <ItemChargeUnitSearchDetailViewModel>)Cache.Get(CacheList.ItemChargeUnitSearchDetailViewData);
var _TREA_ITEM_NAME = new Service.Actual.Common().GetSysCode("TREA_ITEM_NAME");
var _DATA_STATUS = new Service.Actual.Common().GetSysCode("DATA_STATUS");
var _EMPS = new Service.Actual.Common().GetEmps();
var _DEPTS = new Service.Actual.Common().GetDepts();
var cUserId = AccountController.CurrentUserId;
var _ItemChargeUnitSearchDetailVM = new ItemChargeUnitSearchDetailViewModel()
{
vCHARGE_UNIT_ID = model.vCHARGE_UNIT_ID,
vTREA_ITEM_NAME = model.vTREA_ITEM_NAME,
vTREA_ITEM_NAME_VALUE = model.vTREA_ITEM_NAME_VALUE,
vCHARGE_DEPT = model.vCHARGE_DEPT,
vCHARGE_DEPT_VALUE = !model.vCHARGE_DEPT.IsNullOrWhiteSpace() ? _EMPS.FirstOrDefault(y => y.DPT_CD != null && y.DPT_CD.Trim() == model.vCHARGE_DEPT)?.DPT_NAME?.Trim() : null,
vCHARGE_SECT = !model.vCHARGE_SECT.IsNullOrWhiteSpace() ? model.vCHARGE_SECT : "",
vCHARGE_SECT_VALUE = !model.vCHARGE_SECT.IsNullOrWhiteSpace() ? _EMPS.FirstOrDefault(y => y.DPT_CD != null && y.DPT_CD.Trim() == model.vCHARGE_SECT)?.DPT_NAME?.Trim() : null,
vIS_MAIL_DEPT_MGR = model.vIS_MAIL_DEPT_MGR,
vIS_MAIL_SECT_MGR = model.vIS_MAIL_SECT_MGR,
vCHARGE_UID = model.vCHARGE_UID,
vCHARGE_NAME = !model.vCHARGE_UID.IsNullOrWhiteSpace() ? _EMPS.FirstOrDefault(y => y.USR_ID == model.vCHARGE_UID)?.EMP_NAME?.Trim() : null,
vDATA_STATUS = "1",
vDATA_STATUS_VALUE = _DATA_STATUS.FirstOrDefault(x => x.Value == "1")?.Text?.Trim(),
vEXEC_ACTION = "A",
vEXEC_ACTION_VALUE = "新增",
vIS_DISABLED = model.vIs_Disabled
};
tempData.Add(_ItemChargeUnitSearchDetailVM);
Cache.Invalidate(CacheList.ItemChargeUnitSearchDetailViewData);
Cache.Set(CacheList.ItemChargeUnitSearchDetailViewData, tempData);
result.RETURN_FLAG = true;
result.DESCRIPTION = Ref.MessageType.insert_Success.GetDescription();
}
return(Json(result));
}
public JsonResult UpdateTempData(TreasuryMailTimeViewModel model)
{
MSGReturnModel <bool> result = new MSGReturnModel <bool>();
result.RETURN_FLAG = false;
result.DESCRIPTION = Ref.MessageType.login_Time_Out.GetDescription();
if (Cache.IsSet(CacheList.TreasuryMailTimeData))
{
var tempData = (List <TreasuryMailTimeViewModel>)Cache.Get(CacheList.TreasuryMailTimeData);
var updateTempData = tempData.FirstOrDefault(x => x.vMAIL_TIME_ID == model.vMAIL_TIME_ID);
if (updateTempData != null)
{
updateTempData.updateFlag = true;
updateTempData.vAction = "修改";
updateTempData.vDATA_STATUS = "3";
updateTempData.vDATA_STATUS_NAME = "修改中";
updateTempData.vEXEC_TIME_B = model.vEXEC_TIME_B; //系統時間(起)
updateTempData.vEXEC_TIME_E = model.vEXEC_TIME_E; //系統時間(迄)
updateTempData.vSEND_TIME = model.vSEND_TIME; //發送時間
updateTempData.vINTERVAL_MIN = model.vINTERVAL_MIN; //間隔時間
updateTempData.vTREA_OPEN_TIME = model.vTREA_OPEN_TIME; //開庫時間
updateTempData.vFUNC_ID = model.vFUNC_ID; //程式編號(註解)
updateTempData.vMAIL_CONTENT_ID = model.vMAIL_CONTENT_ID; //內文編號
updateTempData.vMEMO = model.vMEMO; //備註
updateTempData.vIS_DISABLED = model.vIS_DISABLED; //停用註記
var _DISABLED = new Service.Actual.Common().GetSysCode("IS_DISABLED", false);
updateTempData.vIS_DISABLED_NAME = _DISABLED.FirstOrDefault(x => x.Value == model.vIS_DISABLED)?.Text;
Cache.Invalidate(CacheList.TreasuryMailTimeData);
Cache.Set(CacheList.TreasuryMailTimeData, tempData);
result.RETURN_FLAG = true;
result.DESCRIPTION = Ref.MessageType.update_Success.GetDescription();
result.Datas = true;
}
else
{
result.RETURN_FLAG = false;
result.DESCRIPTION = Ref.MessageType.update_Fail.GetDescription();
}
}
return(Json(result));
}
public JsonResult InsertTempData(ItemMaintainInsertViewModel model)
{
MSGReturnModel <string> result = new MSGReturnModel <string>();
result.RETURN_FLAG = false;
result.DESCRIPTION = Ref.MessageType.login_Time_Out.GetDescription();
if (Cache.IsSet(CacheList.ItemMaintainSearchDetailViewData))
{
var tempData = (List <ItemMaintainSearchDetailViewModel>)Cache.Get(CacheList.ItemMaintainSearchDetailViewData);
var _DATA_STATUS = new Service.Actual.Common().GetSysCode("DATA_STATUS");
var _TREA_ITEM_TYPE = new Service.Actual.Common().GetSysCode("TREA_ITEM_TYPE");
var _TREA_ITEM_NAME = new Service.Actual.Common().GetSysCode("TREA_ITEM_NAME");
var _ItemMaintainSearchDetailVM = new ItemMaintainSearchDetailViewModel()
{
vITEM_ID = model.vTrea_Item_Id,
vITEM_OP_TYPE = model.vOp_Type,
vITEM_DESC = model.vItem_Desc,
vIS_TREA_ITEM = model.vIs_Item,
vTREA_ITEM_TYPE = model.vType,
vTREA_ITEM_TYPE_VALUE = !model.vType.IsNullOrWhiteSpace() ? _TREA_ITEM_TYPE.FirstOrDefault(x => x.Value == model.vType)?.Text?.Trim() : null,
vTREA_ITEM_NAME = model.vName,
vTREA_ITEM_NAME_VALUE = !model.vName.IsNullOrWhiteSpace() ? _TREA_ITEM_NAME.FirstOrDefault(x => x.Value == model.vName)?.Text?.Trim() : null,
vISDO_PERDAY = model.vIsDo_Perday,
vIS_DISABLED = model.vIs_Disabled,
vMEMO = model.vMemo,
vDATA_STATUS = "1",
vDATA_STATUS_VALUE = _DATA_STATUS.FirstOrDefault(x => x.Value == "1")?.Text?.Trim(),
vEXEC_ACTION = "A",
vEXEC_ACTION_VALUE = "新增"
};
tempData.Add(_ItemMaintainSearchDetailVM);
Cache.Invalidate(CacheList.ItemMaintainSearchDetailViewData);
Cache.Set(CacheList.ItemMaintainSearchDetailViewData, tempData);
result.RETURN_FLAG = true;
result.DESCRIPTION = Ref.MessageType.insert_Success.GetDescription();
}
return(Json(result));
}
public JsonResult UpdateTempData(ItemMaintainInsertViewModel model)
{
MSGReturnModel <string> result = new MSGReturnModel <string>();
result.RETURN_FLAG = false;
result.DESCRIPTION = Ref.MessageType.login_Time_Out.GetDescription();
if (Cache.IsSet(CacheList.ItemMaintainSearchDetailViewData))
{
var tempData = (List <ItemMaintainSearchDetailViewModel>)Cache.Get(CacheList.ItemMaintainSearchDetailViewData);
var updateTempData = tempData.FirstOrDefault(x => x.vITEM_ID == model.vTrea_Item_Id);
if (updateTempData != null)
{
var _TREA_ITEM_TYPE = new Service.Actual.Common().GetSysCode("TREA_ITEM_TYPE");
var _TREA_ITEM_NAME = new Service.Actual.Common().GetSysCode("TREA_ITEM_NAME");
updateTempData.vEXEC_ACTION = updateTempData.vEXEC_ACTION == "A" ? "A" : "U";
updateTempData.vEXEC_ACTION_VALUE = updateTempData.vEXEC_ACTION_VALUE == "A" ? "新增" : "修改";
updateTempData.vIS_TREA_ITEM = model.vIs_Item;
updateTempData.vTREA_ITEM_TYPE = model.vType;
updateTempData.vTREA_ITEM_TYPE_VALUE = !model.vType.IsNullOrWhiteSpace() ? _TREA_ITEM_TYPE.FirstOrDefault(x => x.Value == model.vType)?.Text?.Trim() : null;
updateTempData.vTREA_ITEM_NAME = model.vName;
updateTempData.vTREA_ITEM_NAME_VALUE = !model.vName.IsNullOrWhiteSpace() ? _TREA_ITEM_TYPE.FirstOrDefault(x => x.Value == model.vName)?.Text?.Trim() : null;
updateTempData.vISDO_PERDAY = model.vIsDo_Perday;
updateTempData.vIS_DISABLED = model.vIs_Disabled;
updateTempData.vMEMO = model.vMemo;
Cache.Invalidate(CacheList.ItemMaintainSearchDetailViewData);
Cache.Set(CacheList.ItemMaintainSearchDetailViewData, tempData);
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));
}