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 GetChargeCacheData(jqGridParam jdata, string type)
{
var _type = EnumUtil.GetValues <TreaItemType>().First(y => y.ToString() == type);
var data = (CDCChargeViewModel)Cache.Get(CacheList.CDCChargeSearchViewModel);
switch (_type)
{
case TreaItemType.D1012:
return(Json(jdata.modelToJqgridResult(data.BillData)));
case TreaItemType.D1024:
return(Json(jdata.modelToJqgridResult(data.CaData)));
case TreaItemType.D1013:
return(Json(jdata.modelToJqgridResult(data.DepositData.vDeposit_M)));
case TreaItemType.D1014:
return(Json(jdata.modelToJqgridResult(data.EstateData)));
case TreaItemType.D1018:
return(Json(jdata.modelToJqgridResult(data.ItemImpData)));
case TreaItemType.D1016:
return(Json(jdata.modelToJqgridResult(data.MargingData)));
case TreaItemType.D1017:
return(Json(jdata.modelToJqgridResult(data.MarginpData)));
case TreaItemType.D1008:
case TreaItemType.D1009:
case TreaItemType.D1010:
case TreaItemType.D1011:
return(Json(jdata.modelToJqgridResult(data.SealData)));
case TreaItemType.D1015:
return(Json(jdata.modelToJqgridResult(data.StockData)));
}
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.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 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 GetCacheData(jqGridParam jdata, string type)
{
List <A41ViewModel> data = new List <A41ViewModel>();
switch (type)
{
case "Excel":
if (Cache.IsSet(CacheList.A41ExcelfileData))
{
data = (List <A41ViewModel>)Cache.Get(CacheList.A41ExcelfileData); //從Cache 抓資料
}
break;
case "Db":
if (Cache.IsSet(CacheList.A41DbfileData))
{
data = (List <A41ViewModel>)Cache.Get(CacheList.A41DbfileData);
}
break;
}
return(Json(jdata.modelToJqgridResult(data)));
}
public JsonResult GetCacheData(jqGridParam jdata, string type)
{
switch (type)
{
case "BookNo":
return(Json(jdata.modelToJqgridResult((List <FileItemBookEstateModel>)Cache.Get(CacheList.ExcelfileData))));
case "Estate":
return(Json(jdata.modelToJqgridResult((List <FileEstateModel>)Cache.Get(CacheList.ExcelfileData))));
case "Marginp":
return(Json(jdata.modelToJqgridResult((List <FileMarginpModel>)Cache.Get(CacheList.ExcelfileData))));
case "Marging":
return(Json(jdata.modelToJqgridResult((List <FileMargingModel>)Cache.Get(CacheList.ExcelfileData))));
case "Itemimp":
return(Json(jdata.modelToJqgridResult((List <FileItemImpModel>)Cache.Get(CacheList.ExcelfileData))));
case "Stock":
return(Json(jdata.modelToJqgridResult((List <FileStockModel>)Cache.Get(CacheList.ExcelfileData))));
}
return(null);
}
public JsonResult GetDefaultCacheData(jqGridParam jdata, string type)
{
switch (type)
{
case "A46Excel":
if (CacheForIT.IsSet(CacheList.A46ExcelfileData))
{
return(Json(jdata.modelToJqgridResult((List <A46ViewModel>)CacheForIT.Get(CacheList.A46ExcelfileData))));
}
break;
case "A46Db":
if (CacheForIT.IsSet(CacheList.A46DbfileData))
{
return(Json(jdata.modelToJqgridResult((List <A46ViewModel>)CacheForIT.Get(CacheList.A46DbfileData))));
}
break;
case "A47Excel":
if (CacheForIT.IsSet(CacheList.A47ExcelfileData))
{
return(Json(jdata.modelToJqgridResult((List <A47ViewModel>)CacheForIT.Get(CacheList.A47ExcelfileData))));
}
break;
case "A47Db":
if (CacheForIT.IsSet(CacheList.A47DbfileData))
{
return(Json(jdata.modelToJqgridResult((List <A47ViewModel>)CacheForIT.Get(CacheList.A47DbfileData))));
}
break;
case "A48Excel":
if (CacheForIT.IsSet(CacheList.A48ExcelfileData))
{
return(Json(jdata.modelToJqgridResult((List <A48ViewModel>)CacheForIT.Get(CacheList.A48ExcelfileData))));
}
break;
case "A48Db":
if (CacheForIT.IsSet(CacheList.A48DbfileData))
{
return(Json(jdata.modelToJqgridResult((List <A48ViewModel>)CacheForIT.Get(CacheList.A48DbfileData))));
}
break;
case "A56Db":
if (CacheForIT.IsSet(CacheList.A56DbfileData))
{
return(Json(jdata.modelToJqgridResult((List <A56ViewModel>)CacheForIT.Get(CacheList.A56DbfileData))));
}
break;
case "A95_1Excel":
if (CacheForIT.IsSet(CacheList.A95_1ExcelfileData))
{
return(Json(jdata.modelToJqgridResult((List <A95_1ViewModel>)CacheForIT.Get(CacheList.A95_1ExcelfileData))));
}
break;
case "A95_1Db":
if (CacheForIT.IsSet(CacheList.A95_1DbfileData))
{
return(Json(jdata.modelToJqgridResult((List <A95_1ViewModel>)CacheForIT.Get(CacheList.A95_1DbfileData))));
}
break;
case "D53Excel":
if (CacheForIT.IsSet(CacheList.D53ExcelfileData))
{
return(Json(jdata.modelToJqgridResult((List <D53ViewModel>)CacheForIT.Get(CacheList.D53ExcelfileData))));
}
break;
case "D53Db":
if (CacheForIT.IsSet(CacheList.D53DbfileData))
{
return(Json(jdata.modelToJqgridResult((List <D53ViewModel>)CacheForIT.Get(CacheList.D53DbfileData))));
}
break;
case "D72Excel":
if (CacheForIT.IsSet(CacheList.D72ExcelfileData))
{
return(Json(jdata.modelToJqgridResult((List <D72ViewModel>)CacheForIT.Get(CacheList.D72ExcelfileData))));
}
break;
case "D72Db":
if (CacheForIT.IsSet(CacheList.D72DbfileData))
{
return(Json(jdata.modelToJqgridResult((List <D72ViewModel>)CacheForIT.Get(CacheList.D72DbfileData))));
}
break;
case "D73Db":
if (CacheForIT.IsSet(CacheList.D73DbfileData))
{
return(Json(jdata.modelToJqgridResult((List <D73ViewModel>)CacheForIT.Get(CacheList.D73DbfileData))));
}
break;
}
return(Json(null));
}
public JsonResult GetCacheData(jqGridParam jdata, string action, string type)
{
List <A58ViewModel> A58Data = new List <A58ViewModel>();
List <A59ViewModel> A59Data = new List <A59ViewModel>();
List <A57ViewModel> A57Data = new List <A57ViewModel>();
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;
case "CheckTable2":
if (Cache.IsSet(CacheList.CheckTableDbfileData2))
{
return(Json(jdata.modelToJqgridResult(
(List <CheckTableViewModel>)Cache.Get(CacheList.CheckTableDbfileData2))));
}
break;
case "A57":
if (Cache.IsSet(CacheList.A57DbfileData))
{
return(Json(jdata.modelToJqgridResult(
(List <A57ViewModel>)Cache.Get(CacheList.A57DbfileData))));
}
break;
case "A52Aduit":
if (Cache.IsSet(CacheList.A52AuditDbfileData))
{
return(Json(jdata.modelToJqgridResult(
(List <A52ViewModel>)Cache.Get(CacheList.A52AuditDbfileData))));
}
break;
case "A52AduitDetail":
if (Cache.IsSet(CacheList.A52AuditDetailDbfileData))
{
return(Json(jdata.modelToJqgridResult(
(List <A52ViewModel>)Cache.Get(CacheList.A52AuditDetailDbfileData))));
}
break;
}
if (action.Equals("downLoad"))
{
return(Json(jdata.modelToJqgridResult(A58Data))); //下載查詢資料
}
return(Json(jdata.modelToJqgridResult(A59Data))); //上傳查詢資料
}