public JsonResult GetCacheDataInUserLog(jqGridParam jdata, string type, string Menu_Id = null, string Browse_Time = null)
{
List <AccountLogViewModel> datas = new List <AccountLogViewModel>();
if (type == "User")
{
if (Cache.IsSet(CacheList.userLogInUserDbData))
{
datas = (List <AccountLogViewModel>)Cache.Get(CacheList.userLogInUserDbData); //從Cache 抓資料
}
}
if (type == "Browser")
{
if (Cache.IsSet(CacheList.userLogInBrowserDbData))
{
datas = (List <AccountLogViewModel>)Cache.Get(CacheList.userLogInBrowserDbData); //從Cache 抓資料
}
}
if (type == "Event")
{
if (Cache.IsSet(CacheList.userLogInEventDbData))
{
datas = (List <AccountLogViewModel>)Cache.Get(CacheList.userLogInEventDbData); //從Cache 抓資料
}
}
return(Json(jdata.modelToJqgridResult(datas))); //查詢資料
}
public JsonResult GetCacheC01Data(jqGridParam jdata, string type)
{
List <C01ViewModel> data = new List <C01ViewModel>();
switch (type)
{
case "Excel":
if (Cache.IsSet(CacheList.C01ExcelfileData))
{
data = (List <C01ViewModel>)Cache.Get(CacheList.C01ExcelfileData); //從Cache 抓資料
}
break;
case "Db":
if (Cache.IsSet(CacheList.C01DbfileData))
{
data = (List <C01ViewModel>)Cache.Get(CacheList.C01DbfileData);
}
break;
}
return(Json(jdata.modelToJqgridResult(data, true, new List <string>()
{
"Reference_Nbr"
})));
}
public JsonResult GetCacheData(jqGridParam jdata, string type)
{
switch (type)
{
case "Index":
if (Cache.IsSet(CacheList.TreasuryMailContentData))
{
return(Json(jdata.modelToJqgridResult((List <TreasuryMailContentViewModel>)Cache.Get(CacheList.TreasuryMailContentData))));
}
break;
case "Receive":
if (Cache.IsSet(CacheList.TreasuryMailContentReceiveData))
{
return(Json(jdata.modelToJqgridResult(((List <TreasuryMailReceivelViewModel>)Cache.Get(CacheList.TreasuryMailContentReceiveData)).OrderBy(x => x.FUNC_ID).ToList())));
}
break;
case "ChangeRecord":
if (Cache.IsSet(CacheList.TreasuryMailContentChangeRecordData))
{
return(Json(jdata.modelToJqgridResult(((List <TreasuryMailContentHistoryViewModel>)Cache.Get(CacheList.TreasuryMailContentChangeRecordData)))));
}
break;
}
return(null);
}
public JsonResult GetCacheData(jqGridParam jdata, string type)
{
switch (type)
{
case "P":
if (Cache.IsSet(CacheList.DepChkItem_P_SearchDataList))
{
return(Json(jdata.modelToJqgridResult(((List <DepChkItemViewModel>)Cache.Get(CacheList.DepChkItem_P_SearchDataList)).OrderBy(x => x.vItem_Order).ToList())));
}
break;
case "G":
if (Cache.IsSet(CacheList.DepChkItem_G_SearchDataList))
{
return(Json(jdata.modelToJqgridResult(((List <DepChkItemViewModel>)Cache.Get(CacheList.DepChkItem_G_SearchDataList)).OrderBy(x => x.vItem_Order).ToList())));
}
break;
case "O":
if (Cache.IsSet(CacheList.DepChkItemChangeRecordSearchDataList))
{
return(Json(jdata.modelToJqgridResult(((List <DepChkItemChangeRecordViewModel>)Cache.Get(CacheList.DepChkItemChangeRecordSearchDataList)).OrderBy(x => x.vAply_No).ToList())));
}
break;
}
return(null);
}
public JsonResult GetCacheDataInAssessment(jqGridParam jdata, string type)
{
List <SetAssessmentViewModel> datas = new List <SetAssessmentViewModel>();
if (type == SetAssessmentType.Assessment.ToString())
{
if (Cache.IsSet(CacheList.SetAssessment))
{
datas = (List <SetAssessmentViewModel>)Cache.Get(CacheList.SetAssessment); //從Cache 抓資料
}
}
if (type == SetAssessmentType.Auditor.ToString())
{
if (Cache.IsSet(CacheList.SetAssessmentAuditor))
{
datas = (List <SetAssessmentViewModel>)Cache.Get(CacheList.SetAssessmentAuditor); //從Cache 抓資料
}
}
if (type == SetAssessmentType.Presented.ToString())
{
if (Cache.IsSet(CacheList.SetAssessmentPresented))
{
datas = (List <SetAssessmentViewModel>)Cache.Get(CacheList.SetAssessmentPresented); //從Cache 抓資料
}
}
return(Json(jdata.modelToJqgridResult(datas))); //查詢資料
}
public JsonResult GetCacheC07AavancedSumData(jqGridParam jdata)
{
List <C07AdvancedSumViewModel> data = new List <C07AdvancedSumViewModel>();
if (Cache.IsSet(CacheList.C07AdvancedSumDbfileData))
{
data = (List <C07AdvancedSumViewModel>)Cache.Get(CacheList.C07AdvancedSumDbfileData);
}
return(Json(jdata.modelToJqgridResult(data, true)));
}
public JsonResult GetCacheData(jqGridParam jdata)
{
if (Cache.IsSet(CacheList.MarginpData))
{
return(Json(jdata.modelToJqgridResult(
((List <MarginpViewModel>)Cache.Get(CacheList.MarginpData)).OrderBy(x => x.vItemId).ToList()
)));
}
return(null);
}
public JsonResult GetCacheData(jqGridParam jdata)
{
List <AccountViewModel> datas = new List <AccountViewModel>();
if (Cache.IsSet(CacheList.userDbData))
{
datas = (List <AccountViewModel>)Cache.Get(CacheList.userDbData); //從Cache 抓資料
}
return(Json(jdata.modelToJqgridResult(datas))); //查詢資料
}
public JsonResult GetCacheData(jqGridParam jdata, string type)
{
switch (type)
{
case "Search":
var Datas = (List <RctCompDetailViewModel>)Cache.Get(CacheList.RctCompViewData);
return(Json(jdata.modelToJqgridResult(Datas.OrderBy(x => x.vRct_type_code).ToList())));
}
return(null);
}
public JsonResult GetCacheData(jqGridParam jdta, string type)
{
switch (type)
{
case "Search":
var SearchDatas = (List <AlreadyConfirmedSearchDetailViewModel>)Cache.Get(CacheList.AlreadyConfirmedSearchDetailViewData);
return(Json(jdta.modelToJqgridResult(SearchDatas.OrderBy(x => x.vACTUAL_PUT_TIME == null).ThenByDescending(x => x.vTREA_REGISTER_ID).ThenBy(x => x.hITEM_OP_TYPE).ThenBy(x => x.hITEM_ID).ToList())));
}
return(null);
}
public JsonResult GetCacheMenuSubData(jqGridParam jdata)
{
List <MenuSubViewModel> data = new List <MenuSubViewModel>();
if (Cache.IsSet(CacheList.MenuSubDbfileData))
{
data = (List <MenuSubViewModel>)Cache.Get(CacheList.MenuSubDbfileData);
}
return(Json(jdata.modelToJqgridResult(data)));
}
public JsonResult GetCacheData(jqGridParam jdata)
{
if (Cache.IsSet(CacheList.ESTATEData))
{
return(Json(jdata.modelToJqgridResult(
((List <EstateDetailViewModel>)Cache.Get(CacheList.ESTATEData))
//.OrderBy(x => x.vItemId).ToList()
)));
}
return(null);
}
public JsonResult GetCacheD02Data(jqGridParam jdata)
{
List <D02ViewModel> data = new List <D02ViewModel>();
if (Cache.IsSet(CacheList.D02DbfileData))
{
data = (List <D02ViewModel>)Cache.Get(CacheList.D02DbfileData);
}
return(Json(jdata.modelToJqgridResult(data, true)));
}
public JsonResult GetCacheData(jqGridParam jdta, string type, string itemId = null)
{
switch (type)
{
case "Search":
List <string> itemIdList = new List <string>();
itemIdList.AddRange(itemId.Split(';'));
var SearchDatas = (List <ConfirmStorageSearchDetailViewModel>)Cache.Get(CacheList.ConfirmStorageSearchDetailViewData);
return(Json(jdta.modelToJqgridResult(SearchDatas.Where(x => itemIdList.Contains(x.vITEM_ID)).OrderBy(x => x.vITeM_OP_TYPE).ToList())));
}
return(null);
}
public JsonResult GetCacheData(jqGridParam jdta, string type)
{
switch (type)
{
case "Search":
var SearchDatas = (List <AfterOpenTreasurySearchDetailViewModel>)Cache.Get(CacheList.AfterOpenTreasurySearchDetailViewData);
return(Json(jdta.modelToJqgridResult(SearchDatas.OrderBy(x => x.vITEM_OP_TYPE).ToList())));
case "UnconfirmedData":
var UnconfirmedDatas = (List <AfterOpenTreasuryUnconfirmedDetailViewModel>)Cache.Get(CacheList.AfterOpenTreasuryUnconfirmedDetailViewData);
return(Json(jdta.modelToJqgridResult(UnconfirmedDatas.OrderBy(x => x.vITEM_OP_TYPE).ToList())));
}
return(null);
}
public ActionResult GetCacheData(jqGridParam jdata, string type)
{
switch (type)
{
case "C04_Transfer":
if (Cache.IsSet(CacheList.C04TransferData))
{
return(Content((jdata.dynToJqgridResult(
(List <System.Dynamic.ExpandoObject>)Cache.Get(CacheList.C04TransferData)))));
}
break;
}
return(null);
}
public JsonResult GetCacheData(jqGridParam jdata, string type)
{
switch (type)
{
case "Appr":
var ApprDatas = (List <TDAApprSearchDetailViewModel>)Cache.Get(CacheList.TDAApprSearchDetailViewData);
return(Json(jdata.modelToJqgridResult(ApprDatas)));
case "Search":
var Datas = (List <TDAApprSearchDetailViewModel>)Cache.Get(CacheList.TDASearchDetailViewData);
return(Json(jdata.modelToJqgridResult(Datas)));
}
return(null);
}
public JsonResult GetCacheData(jqGridParam jdta, string type)
{
switch (type)
{
case "Search":
var SearchDatas = (List <TREAReviewWorkDetailViewModel>)Cache.Get(CacheList.TREAReviewWorkDetailViewData);
return(Json(jdta.modelToJqgridResult(SearchDatas.OrderBy(x => x.vTREA_REGISTER_ID).ToList())));
case "DetilsData":
var DetailDatas = (List <TREAReviewWorkSearchDetailViewModel>)Cache.Get(CacheList.TREAReviewWorkSearchDetailViewData);
return(Json(jdta.modelToJqgridResult(DetailDatas.OrderBy(x => x.vITeM_OP_TYPE).ThenBy(x => x.vITEM_ID).ToList())));
}
return(null);
}
public JsonResult GetCacheData(jqGridParam jdata, string type)
{
switch (type)
{
case "search":
var searchCache = (List <TreasuryAccessApprSearchDetailViewModel>)Cache.Get(CacheList.TreasuryAccessCustodySearchDetailViewData);
return(Json(jdata.modelToJqgridResult(searchCache)));
case "Appr":
var apprCache = (List <TreasuryAccessApprSearchDetailViewModel>)Cache.Get(CacheList.TreasuryAccessCustodyApprSearchDetailViewData);
return(Json(jdata.modelToJqgridResult(apprCache)));
}
return(null);
}
public JsonResult GetCacheData(jqGridParam jdata, string type)
{
switch (type)
{
case "Search":
var Datas = (List <ItemMaintainSearchDetailViewModel>)Cache.Get(CacheList.ItemMaintainSearchDetailViewData);
return(Json(jdata.modelToJqgridResult(Datas.OrderBy(x => x.vITEM_ID).ToList())));
case "RecordSearch":
var RecordDatas = (List <ItemMaintainChangeRecordSearchDetailViewModel>)Cache.Get(CacheList.ItemMaintainChangeRecordSearchDetailViewData);
return(Json(jdata.modelToJqgridResult(RecordDatas.OrderBy(x => x.vAply_No).ToList())));
}
return(null);
}
public JsonResult GetCacheC07AavancedData(jqGridParam jdata)
{
List <C07AdvancedViewModel> data = new List <C07AdvancedViewModel>();
if (Cache.IsSet(CacheList.C07AdvancedDbfileData))
{
data = (List <C07AdvancedViewModel>)Cache.Get(CacheList.C07AdvancedDbfileData);
}
return(Json(jdata.modelToJqgridResult(data, true, new List <string>()
{
"Reference_Nbr"
})));
}
public JsonResult GetCacheData(jqGridParam jdata, string type)
{
switch (type)
{
case "A96DB":
return(Json(jdata.modelToJqgridResult((List <A96ViewModel>)Cache.Get(CacheList.A96DbfileData))));
case "A96Excel":
return(Json(jdata.modelToJqgridResult((List <A96ViewModel>)Cache.Get(CacheList.A96ExcelfileData))));
case "A96Trade":
return(Json(jdata.modelToJqgridResult((List <A96TradeViewModel>)Cache.Get(CacheList.A96TradeDbfileData))));
}
return(null);
}
public JsonResult GetCDCCacheData(jqGridParam jdata)
{
if (Cache.IsSet(CacheList.CDCSEALData))
{
return(Json(jdata.modelToJqgridResult(
((List <CDCSealViewModel>)Cache.Get(CacheList.CDCSEALData))
.OrderBy(x => x.vPUT_Date) //入庫日期
.ThenBy(x => x.vAPLY_UID) //存入申請人
.ThenBy(x => x.vCharge_Dept) //權責部門
.ThenBy(x => x.vCharge_Sect) //權責科別
.ThenBy(x => x.vSeal_Desc) //印章內容
.ToList()
)));
}
return(null);
}
public JsonResult GetCDCCacheData(jqGridParam jdata)
{
if (Cache.IsSet(CacheList.CDCEstateData))
{
return(Json(jdata.modelToJqgridResult(
((List <CDCEstateViewModel>)Cache.Get(CacheList.CDCEstateData))
.OrderBy(x => x.vPut_Date) //入庫日期
.ThenBy(x => x.vAply_Uid) //存入申請人
.ThenBy(x => x.vCharge_Dept) //權責部門
.ThenBy(x => x.vCharge_Sect) //權責科別
.ThenBy(x => x.vIB_Book_No) //存取項目冊號資料檔-冊號
.ThenBy(x => x.vEstate_Form_No) //狀別
.ToList()
)));
}
return(null);
}
public JsonResult GetCDCCacheData(jqGridParam jdata)
{
if (Cache.IsSet(CacheList.CDCBILLData))
{
return(Json(jdata.modelToJqgridResult(
((List <CDCBillViewModel>)Cache.Get(CacheList.CDCBILLData))
.OrderBy(x => x.vPut_Date) //入庫日期
.ThenBy(x => x.vAply_Uid) //存入申請人
.ThenBy(x => x.vCharge_Dept) //權責部門
.ThenBy(x => x.vCharge_Sect) //權責科別
.ThenBy(x => x.vBill_Issuing_Bank) //發票行庫
.ThenBy(x => x.vBill_Check_Type) //類型
.ThenBy(x => x.vItemId) //ID
.ToList()
)));
}
return(null);
}
public JsonResult GetCDCCacheData(jqGridParam jdata)
{
if (Cache.IsSet(CacheList.CDCMarginpData))
{
return(Json(jdata.modelToJqgridResult(
((List <CDCMarginpViewModel>)Cache.Get(CacheList.CDCMarginpData))
.OrderBy(x => x.vPut_Date) //入庫日期
.ThenBy(x => x.vAply_Uid) //存入申請人
.ThenBy(x => x.vCharge_Dept) //權責部門
.ThenBy(x => x.vCharge_Sect) //權責科別
.ThenBy(x => x.vMargin_Take_Of_Type) //類別
.ThenBy(x => x.vTrad_Partners) //交易對象
//.ThenBy(x => x.vTrad_Partners) //號碼?
.ToList()
)));
}
return(null);
}
public JsonResult GetCacheData(jqGridParam jdata, string action, string type)
{
List <A58ViewModel> A58Data = new List <A58ViewModel>();
List <A59ViewModel> A59Data = new List <A59ViewModel>();
switch (type)
{
case "Miss":
if (Cache.IsSet(CacheList.A58DbMissfileData))
{
A58Data = (List <A58ViewModel>)Cache.Get(CacheList.A58DbMissfileData); //從Cache 抓資料
}
break;
case "All":
if (Cache.IsSet(CacheList.A58DbfileData))
{
A58Data = (List <A58ViewModel>)Cache.Get(CacheList.A58DbfileData);
}
break;
case "A59":
if (Cache.IsSet(CacheList.A59ExcelfileData))
{
A59Data = (List <A59ViewModel>)Cache.Get(CacheList.A59ExcelfileData);
}
break;
case "CheckTable":
if (Cache.IsSet(CacheList.CheckTableDbfileData))
{
return(Json(jdata.modelToJqgridResult(
(List <CheckTableViewModel>)Cache.Get(CacheList.CheckTableDbfileData))));
}
break;
}
if (action.Equals("downLoad"))
{
return(Json(jdata.modelToJqgridResult(A58Data))); //下載查詢資料
}
return(Json(jdata.modelToJqgridResult(A59Data))); //上傳查詢資料
}
public JsonResult GetCacheData(jqGridParam jdata, string type)
{
switch (type)
{
case "Temp":
if (Cache.IsSet(CacheList.BILLTempData))
{
return(Json(jdata.modelToJqgridResult(SetBillViewModelOrder((List <BillViewModel>)Cache.Get(CacheList.BILLTempData)))));
}
break;
case "Day":
if (Cache.IsSet(CacheList.BILLDayData))
{
return(Json(jdata.modelToJqgridResult((List <BillViewModel>)Cache.Get(CacheList.BILLDayData))));
}
break;
}
return(null);
}
public JsonResult GetCacheData(jqGridParam jdata, string type)
{
switch (type)
{
case "Index":
if (Cache.IsSet(CacheList.TreasuryMailTimeData))
{
return(Json(jdata.modelToJqgridResult(((List <TreasuryMailTimeViewModel>)Cache.Get(CacheList.TreasuryMailTimeData)))));
}
break;
case "ChangeRecord":
if (Cache.IsSet(CacheList.TreasuryMailTimeChangeRecordData))
{
return(Json(jdata.modelToJqgridResult(((List <TreasuryMailTimeHistoryViewModel>)Cache.Get(CacheList.TreasuryMailTimeChangeRecordData)))));
}
break;
}
return(null);
}
public JsonResult GetCacheData(jqGridParam jdata, string type)
{
switch (type)
{
case "Search":
if (Cache.IsSet(CacheList.TreasuryRegisterSearchReportM))
{
return(Json(jdata.modelToJqgridResult(((List <TreasuryRegisterSearch>)Cache.Get(CacheList.TreasuryRegisterSearchReportM)).OrderByDescending(x => x.vTrea_Register_Id).ToList())));
}
break;
case "Detail":
if (Cache.IsSet(CacheList.TreasuryRegisterSearchReportD))
{
return(Json(jdata.modelToJqgridResult(((List <TreasuryRegisterDetail>)Cache.Get(CacheList.TreasuryRegisterSearchReportD)).OrderBy(x => x.vItem_Op_Type).ToList())));
}
break;
}
return(null);
}