コード例 #1
0
ファイル: SystemController.cs プロジェクト: wcsy0827/IFRS9
        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))); //查詢資料
        }
コード例 #2
0
ファイル: C0Controller.cs プロジェクト: wcsy0827/IFRS9
        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"
            })));
        }
コード例 #3
0
        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);
        }
コード例 #4
0
        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);
        }
コード例 #5
0
ファイル: SystemController.cs プロジェクト: wcsy0827/IFRS9
        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))); //查詢資料
        }
コード例 #6
0
ファイル: C0Controller.cs プロジェクト: wcsy0827/IFRS9
        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)));
        }
コード例 #7
0
ファイル: MarginpController .cs プロジェクト: BiancoLee/BETA
 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);
 }
コード例 #8
0
ファイル: SystemController.cs プロジェクト: wcsy0827/IFRS9
        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)));                       //查詢資料
        }
コード例 #9
0
 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);
 }
コード例 #10
0
 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);
 }
コード例 #11
0
ファイル: SystemController.cs プロジェクト: wcsy0827/IFRS9
        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)));
        }
コード例 #12
0
ファイル: EstateController.cs プロジェクト: BiancoLee/BETA
 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);
 }
コード例 #13
0
ファイル: D0Controller.cs プロジェクト: wcsy0827/IFRS9
        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)));
        }
コード例 #14
0
 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);
 }
コード例 #15
0
        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);
        }
コード例 #16
0
ファイル: C0Controller.cs プロジェクト: wcsy0827/IFRS9
 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);
 }
コード例 #17
0
        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);
        }
コード例 #18
0
        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);
        }
コード例 #19
0
        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);
        }
コード例 #20
0
        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);
        }
コード例 #21
0
ファイル: C0Controller.cs プロジェクト: wcsy0827/IFRS9
        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"
            })));
        }
コード例 #22
0
ファイル: A9Controller.cs プロジェクト: wcsy0827/IFRS9
        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);
        }
コード例 #23
0
 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);
 }
コード例 #24
0
ファイル: EstateController.cs プロジェクト: BiancoLee/BETA
 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);
 }
コード例 #25
0
ファイル: BILLController.cs プロジェクト: BiancoLee/BETA
 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);
 }
コード例 #26
0
ファイル: MarginpController .cs プロジェクト: BiancoLee/BETA
 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);
 }
コード例 #27
0
        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)));     //上傳查詢資料
        }
コード例 #28
0
ファイル: BILLController.cs プロジェクト: BiancoLee/BETA
        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);
        }
コード例 #29
0
        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);
        }
コード例 #30
0
        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);
        }