CREATE OR REPLACE PROCEDURE PROC_TZ_EXEC_N_YEARREPORT(ssrq varchar2 )
as
----- Declare variables
v_raise EXCEPTION;
begin
-- The type definition
--begin --execute PROC_TZ_N_YEARREPORT('201601','2015-12-26','2016-01-25'); --end;
commit;
-- exception handling --
EXCEPTION
WHEN NO_DATA_FOUND THEN
RAISE_APPLICATION_ERROR (-20011, ' An exception occurred in the stored procedure !' );
ROLLBACK;
end PROC_TZ_EXEC_N_YEARREPORT;
/
CREATE OR REPLACE PROCEDURE WANFO.PROC_TZ_QUERY_DETAIL(beginTime in varchar2,endTime varchar2)
as
----- Declare variables
v_raise EXCEPTION;
begin
-- The type definition
begin
-- Reserve --
INSERT INTO TZ_QUERY_YDMXTZ(SSSQ,DJH,YWLX,YWDJH,GXRXM,MW,JE,JBR,DBR,BLRQ,XXLY,ZZFLAG,BZ)
-- Retreat --
SELECT null,t2.djh,' Retreat ' as ywlx,t2.id as ywdjh,t1.gxrxm,t1.mwflmc||t1.mwmc as mw,t2.yjje as yjje,t1.czyxm as czyxm,t1.dbrxm,t2.rq AS BLRQ,t1.xxly,t2.ZZFLAG,T2.TXYY AS BZ
FROM ywdjb_yj t1,ywdjb_yj_1 t2 WHERE t1.djh=t2.djh and t1.mwflmc not like '%CU%' AND t2.zxflag<>'' AND t2.sfflag='' AND (t2.ZZFLAG='' ) -- Second payment , The reservation fee is the rental amount --
AND to_char(t2.rq,'yyyy-mm-dd') >=''||beginTime||'' AND to_char(t2.rq,'yyyy-mm-dd') <=''||endTime||'' AND (T2.TXYY NOT like '% Unity %' )
UNION ALL
-- Second payment --
SELECT null,t2.djh,' Second payment ' as ywlx,t2.id as ywdjh,t1.gxrxm,t1.mwflmc||t1.mwmc as mw,t2.yjje as yjje,t1.czyxm as czyxm,t1.dbrxm,t2.rq AS BLRQ,t1.xxly,t2.ZZFLAG,T2.TXYY AS BZ
FROM ywdjb_yj t1,ywdjb_yj_1 t2 WHERE t1.djh=t2.djh and t1.mwflmc not like '%CU%' AND t2.zxflag<>'' AND t2.sfflag='' AND ( t2.ZZFLAG='')-- Second payment , The reservation fee is the rental amount --
AND to_char(t2.rq,'yyyy-mm-dd') >=''||beginTime||'' AND to_char(t2.rq,'yyyy-mm-dd') <=''||endTime||''
AND ID NOT IN ( SELECT ( ID -1) AS ID FROM YWDJB_YJ_1 WHERE to_char(t2.rq,'yyyy-mm-dd') >=''||beginTime||'' AND to_char(t2.rq,'yyyy-mm-dd') <=''||endTime||'' AND T2.TXYY like '% Unity %' ) -- The secondary payment incurred in combination is not calculated
AND t1.djh NOT IN (SELECT djh FROM YWDJB_YJ_1 WHERE to_char(rq,'yyyy-mm-dd') >=''||beginTime||'' AND to_char(rq,'yyyy-mm-dd') <=''||endTime||'' AND TXYY like '% Unity %' and t1.djh=djh)
AND t1.djh NOT IN (SELECT yzdjh FROM ywdjb WHERE zxflag<>'' AND to_char(rq,'yyyy-mm-dd') >=''||beginTime||'' AND to_char(rq,'yyyy-mm-dd') <=''||endTime||'' AND yzdjh is not null) -- Second payment Not the same period
UNION ALL
-- Reserve --
SELECT null AS SSSQ,t2.djh,' Reserve ' as ywlx,t2.id as ywdjh,t1.gxrxm,t1.mwflmc||t1.mwmc as mw,t2.yjje as yjje,t1.czyxm as czyxm,t1.dbrxm,t2.rq AS BLRQ,t1.xxly,t2.ZZFLAG,T2.TXYY AS BZ
FROM ywdjb_yj t1,ywdjb_yj_1 t2
WHERE t1.djh=t2.djh and t1.mwflmc not like '%CU%' AND t1.zxflag<>'' AND t2.zxflag<>'' AND t1.azfsdm='' AND t2.ZZFLAG='' AND t1.djh NOT IN (SELECT yzdjh FROM ywdjb WHERE zxflag<>'' AND to_char(rq,'yyyy-mm-dd') >=''||beginTime||''
AND to_char(rq,'yyyy-mm-dd') <=''||endTime||'' AND yzdjh is not null)AND to_char(t2.rq,'yyyy-mm-dd') >=''||beginTime||'' AND to_char(t2.rq,'yyyy-mm-dd') <=''||endTime||''
AND t2.dabh not in ( SELECT dabh FROM ywdjb_yj_1 WHERE zxflag<>'' AND to_char(rq,'yyyy-mm-dd') >=''||beginTime||'' AND to_char(rq,'yyyy-mm-dd') <=''||endTime||'' and TXYY like '% Unity %')
; -- Temporary deposit account --
INSERT INTO TZ_QUERY_ZCKTZ( JBR, ZCK, TZCK, ZCKRQ, YDR, YDAZRQ, RQ,FLAG)
SELECT CZYXM, SUM(ZCK),SUM(TZCK),ZCKRQ,YDR,TO_CHAR(YDAZRQ,'YYYY-MM-DD'),TO_CHAR(RQ,'YYYY-MM-DD'),FLAG FROM (
-- Temporary deposit --
SELECT RQ,YDAZRQ,CZYXM,GXRXM AS ydr,YJJE AS ZCK,0 AS TZCK,ZCKRQ,'' AS FLAG FROM V_BS_RES_ZCK WHERE to_char(zckrq,'yyyy-mm-dd')>=''||beginTime||'' AND to_char(zckrq,'yyyy-mm-dd')<=''||endTime||''
UNION ALL
-- To withdraw a temporary deposit --
SELECT (SELECT RQ FROM YWDJB_YJ WHERE DJH=T1.DJH) AS RQ,(SELECT YDAZRQ FROM YWDJB_YJ WHERE DJH=T1.DJH) AS YDAZRQ,
(SELECT CZYXM FROM YWDJB_YJ WHERE DJH=T1.DJH) AS CZYXM,(SELECT GXRXM FROM YWDJB_YJ WHERE DJH=T1.DJH) AS YDR,0,
t1.yjje AS YJJE,t1.rq as ZCKRQ,'' AS FLAG FROM ywdjb_yj_1 t1 ,ywdjb_yj t2
WHERE t1.djh=t2.djh and t1.zxflag = '' AND t2.zckflag = '' AND t1.zzflag='' and to_char(t1.rq,'yyyy-mm-dd')>=''||beginTime||'' AND to_char(t1.rq,'yyyy-mm-dd')<=''||endTime||''
)
GROUP BY RQ,YDAZRQ,CZYXM,YDR,ZCKRQ,FLAG; -- rent --
INSERT INTO TZ_QUERY_ZYMXTZ(DJH,AZFSDM,BLRQ,SSSQ,MW,GXRXM,JBR,MXTJFL,STAZ,LTAZ,MXMJ,XXLY,ZMJ,BCJKJE,GMK,YHK,BCK,DABH,YD_Z_JKJE,YD_Y_JKJE,YD_N_JKJE,YZDJH,BZ)
-- Rental income in this period --
SELECT t1.DJH,'' as AZFSDM,t1.rq AS BLRQ,null AS SSSQ,t1.mwflmc||t1.mwmc AS MW,t1.gxrxm,t1.CZYXM
,(SELECT SCMXTJFL1 FROM spmldm WHERE spmldm=t1.mxdm) as MXTJFL
,(SELECT STAZBZ from azfs WHERE azfsdm=t1.azfsdm ) AS STAZ
,(SELECT LTAZBZ from azfs WHERE azfsdm=t1.azfsdm ) AS LTAZ
,nvl(t1.mj,0) as mj,t1.city,nvl(t1.zmj,0) as zmj
,nvl((SELECT SUM(SSJE) FROM FYB_MX WHERE DJH=t1.DJH AND YWDM='' AND (FMDM='' OR FMDM='' OR FMDM='' OR FMDM='')),0) AS BCJKJE
,nvl((SELECT SUM(SSJE) FROM FYB_MX WHERE DJH=t1.DJH AND YWDM='' AND FMDM=''),0) AS GMK
,nvl((SELECT SUM(SSJE) FROM FYB_MX WHERE DJH=t1.DJH AND YWDM='' AND FMDM=''),0) AS YHK
,nvl((SELECT SUM(SSJE) FROM FYB_MX WHERE DJH=t1.DJH AND YWDM='' AND FMDM=''),0) AS BCK
,t1.DABH
,nvl((SELECT SUM(yjje) FROM YWDJB_YJ_1 T3 WHERE (ZZFLAG='' OR ZZFLAG='') AND DJH=t1.YZDJH AND NOT EXISTS(SELECT DJH FROM YWDJB_YJ_1 WHERE (ID = T3.ID+1) AND TXYY LIKE '% close %') AND (TO_CHAR(RQ,'YYYY-MM-DD') >=''||beginTime||'' AND
TO_CHAR(RQ,'YYYY-MM-DD') <=''||endTime||''))+ +fn_getyjje(t1.yzdjh,''||beginTime||'',''||endTime||''),0) AS YD_Z_JKJE
,nvl((SELECT SUM(yjje) FROM YWDJB_YJ_1 T3 WHERE (ZZFLAG='' OR ZZFLAG='') AND DJH=t1.YZDJH AND NOT EXISTS(SELECT DJH FROM YWDJB_YJ_1 WHERE (ID = T3.ID+1) AND TXYY LIKE '% close %') AND (SUBSTR(FUN_ACCOUNT_DATE(RQ),1,6)=
SUBSTR(replace(''||beginTime||'','-',''),1,6)))+ +fn_getyjje(t1.yzdjh,''||beginTime||'',''||endTime||''),0) AS YD_Y_JKJE
,nvl((SELECT SUM(yjje) FROM YWDJB_YJ_1 T3 WHERE (ZZFLAG='' OR ZZFLAG='') AND DJH=t1.YZDJH AND NOT EXISTS(SELECT DJH FROM YWDJB_YJ_1 WHERE (ID = T3.ID+1) AND TXYY LIKE '% close %') AND (SUBSTR(FUN_ACCOUNT_DATE(RQ),1,4)=
SUBSTR(''||beginTime||'',1,4)))+ +fn_getyjje(t1.yzdjh,''||beginTime||'',''||endTime||''),0) AS YD_N_JKJE
,t1.YZDJH,T1.BZ
FROM YWDJB t1 WHERE t1.mwflmc not like '%CU%' AND t1.AZFSDM='' AND t1.ZXFLAG<>'' AND t1.djh not in(SELECT djh FROM FYB_MX WHERE zxflag<>'' and TO_CHAR(SFRQ,'YYYY/MM/DD') = '0001/01/01')
AND TO_CHAR(T1.RQ,'YYYY-MM-DD')>=''||beginTime||'' AND TO_CHAR(t1.RQ,'YYYY-MM-DD') <=''||endTime||''
;
-- Back to the grave Move out --
INSERT INTO TZ_QUERY_TQMXTZ(DJH,YWDJH,YWLX,BLRQ,SSSQ,BLRXM,MW,MXMC,JE,JBR,GMK,YHK,BCK,ZNJ,MBGHK,MXTJFL,STAZ,LTAZ,DABH)
-- Back to the grave --
SELECT t1.djh,t1.ywdjh,' Back to the grave ' AS ywlx,t1.rq as blrq,'' as sssq,t1.gxrxm as BLRXM,t1.mwflmc||t1.mwmc AS MW,t1.mxmc,t1.ssje as je,t1.czyxm as jbr
,nvl((SELECT SUM(SSJE) FROM fyb_mx WHERE djh=t1.djh and ywdjh=t1.ywdjh AND FMDM='' AND YWDM='' ),0) AS GMK
,nvl((SELECT SUM(SSJE) FROM fyb_mx WHERE djh=t1.djh and ywdjh=t1.ywdjh AND FMDM='' AND YWDM='' ),0) AS YHK
,nvl((SELECT SUM(SSJE) FROM fyb_mx WHERE djh=t1.djh and ywdjh=t1.ywdjh AND FMDM='' AND YWDM='' ),0) AS BCK
,nvl((SELECT SUM(SSJE) FROM fyb_mx WHERE djh=t1.djh and ywdjh=t1.ywdjh AND FMDM='' AND YWDM='' ),0) AS ZNJ
,nvl((SELECT SUM(SSJE) FROM fyb_mx WHERE djh=t1.djh and ywdjh=t1.ywdjh AND FMDM='' AND YWDM='' ),0) AS MBGHK
,(SELECT SCMXTJFL1 FROM spmldm WHERE spmldm=t1.mxdm) as MXTJFL
,(SELECT STAZBZ from azfs WHERE azfsdm=t1.azfsdm ) AS STAZ
,(SELECT LTAZBZ from azfs WHERE azfsdm=t1.azfsdm ) AS LTAZ
,t1.dabh
FROM qtywb t1 WHERE mwflmc not like '%CU%' and ywdm= '' AND to_char(rq ,'yyyy-mm-dd') >= ''||beginTime||'' AND to_char(rq, 'yyyy-mm-dd') <=''||endTime||'' AND azfsdm= '' AND zxflag<> ''
-- Move out --
UNION ALL
SELECT t1.djh,t1.ywdjh,' Move out ' AS ywlx,t1.rq as blrq,'' as sssq,t1.gxrxm as BLRXM,t1.mwflmc||t1.mwmc AS MW,t1.mxmc,t1.ssje as je,t1.czyxm as jbr
,nvl((SELECT SUM(SSJE) FROM fyb_mx WHERE djh=t1.djh and ywdjh=t1.ywdjh AND FMDM='' AND YWDM='' ),0) AS GMK
,nvl((SELECT SUM(SSJE) FROM fyb_mx WHERE djh=t1.djh and ywdjh=t1.ywdjh AND FMDM='' AND YWDM='' ),0) AS YHK
,nvl((SELECT SUM(SSJE) FROM fyb_mx WHERE djh=t1.djh and ywdjh=t1.ywdjh AND FMDM='' AND YWDM='' ),0) AS BCK
,nvl((SELECT SUM(SSJE) FROM fyb_mx WHERE djh=t1.djh and ywdjh=t1.ywdjh AND FMDM='' AND YWDM='' ),0) AS ZNJ
,nvl((SELECT SUM(SSJE) FROM fyb_mx WHERE djh=t1.djh and ywdjh=t1.ywdjh AND FMDM='' AND YWDM='' ),0) AS MBGHK
,(SELECT SCMXTJFL1 FROM spmldm WHERE spmldm=t1.mxdm) as MXTJFL
,(SELECT STAZBZ from azfs WHERE azfsdm=t1.azfsdm ) AS STAZ
,(SELECT LTAZBZ from azfs WHERE azfsdm=t1.azfsdm ) AS LTAZ
,t1.dabh
FROM qtywb t1 WHERE mwflmc not like '%CU%' and ywdm= '' AND to_char(rq ,'yyyy-mm-dd') >= ''||beginTime||'' AND to_char(rq, 'yyyy-mm-dd') <=''||endTime||'' AND azfsdm= '' AND zxflag<> ''
;
-- Integrated business --
INSERT INTO TZ_QUERY_ZHMXTZ(djh,ywdjh,dabh,BLRQ,BLRXM,MW,MXMC,MXTJFL,JE,JBR,TXF,AZF,KZF,TJF,MJF,ZF,hbf,STAZ,LTAZ)
-- In the rental business table
SELECT t1.djh, djh as ywdjh ,t1.dabh,(SELECT sfrq FROM fyb_mx WHERE djh=t1.djh and ywdjh=t1.djh and rownum=1) AS BLRQ,t1.gxrxm AS BLRXM,t1.mwflmc||t1.mwmc as MW,t1.mxmc
,(SELECT SCMXTJFL1 FROM spmldm WHERE spmldm=t1.mxdm) as MXTJFL
,nvl((SELECT sum(ssje) FROM fyb_mx WHERE djh=t1.djh and ywdjh=t1.djh and (FMMC LIKE '% other expenses %' or FMMC LIKE '% Avatar fee %' or FMMC LIKE '% Funeral expenses %' or FMMC LIKE '% Engraving fee %' or FMMC LIKE '% The premium %' or FMMC LIKE '% The gold fee %' or FMMC LIKE '% incidental %' OR FMMC LIKE'% Exchange fee %')),0) AS JE,
t1.czyxm AS JBR
,nvl((SELECT sum(ssje) FROM fyb_mx WHERE djh=t1.djh and ywdjh=t1.djh and FMMC LIKE '% Avatar fee %' ),0) as TXF
,nvl((SELECT sum(ssje) FROM fyb_mx WHERE djh=t1.djh and ywdjh=t1.djh and FMMC LIKE '% Funeral expenses %' ),0) as AZF
,nvl((SELECT sum(ssje) FROM fyb_mx WHERE djh=t1.djh and ywdjh=t1.djh and FMMC LIKE '% Engraving fee %'),0) as KZF
,nvl((SELECT sum(ssje) FROM fyb_mx WHERE djh=t1.djh and ywdjh=t1.djh and FMMC LIKE '% The premium %'),0) as TJF
,nvl((SELECT sum(ssje) FROM fyb_mx WHERE djh=t1.djh and ywdjh=t1.djh and FMMC LIKE '% The gold fee %'),0) as MJF
,nvl((SELECT sum(ssje) FROM fyb_mx WHERE djh=t1.djh and ywdjh=t1.djh and (FMMC LIKE '% incidental %' OR FMMC LIKE '% other expenses %')),0) as ZF
,nvl((SELECT sum(ssje) FROM fyb_mx WHERE djh=t1.djh and ywdjh=t1.djh and FMMC LIKE '% Exchange fee %' ),0) as hbf
,(SELECT STAZBZ from azfs WHERE azfsdm=t1.azfsdm ) AS STAZ
,(SELECT LTAZBZ from azfs WHERE azfsdm=t1.azfsdm ) AS LTAZ
FROM ywdjb t1
WHERE t1.zxflag <> '' and t1. mwflmc not like '%CU%' AND t1.azfsdm= ''
and (t1.djh,t1.djh) in ( select djh,ywdjh from fyb_mx t1 where (FMMC LIKE '% other expenses %' or FMMC LIKE '% Avatar fee %' or FMMC LIKE '% Funeral expenses %' or FMMC LIKE '% Engraving fee %' or FMMC LIKE '% The premium %' or FMMC LIKE '% The gold fee %' or FMMC LIKE '% incidental %' OR FMMC LIKE'% Exchange fee %')
and to_char(t1.sfrq, 'yyyy-mm-dd') >=''||beginTime||'' AND to_char (t1.sfrq, 'yyyy-mm-dd') <=''||endTime||'' and zxflag<>'' and azfsdm ='' )
UNION ALL
-- Other business table
SELECT t1.djh, ywdjh as ywdjh ,t1.dabh,(SELECT sfrq FROM fyb_mx WHERE djh=t1.djh and ywdjh=t1.ywdjh and rownum=1) AS BLRQ,t1.gxrxm AS BLRXM,t1.mwflmc||t1.mwmc as MW,t1.mxmc
,(SELECT SCMXTJFL1 FROM spmldm WHERE spmldm=t1.mxdm) as MXTJFL
,nvl((SELECT sum(ssje) FROM fyb_mx WHERE djh=t1.djh and ywdjh=t1.ywdjh and (FMMC LIKE '% other expenses %' or FMMC LIKE '% Avatar fee %' or FMMC LIKE '% Funeral expenses %' or FMMC LIKE '% Engraving fee %' or FMMC LIKE '% The premium %' or FMMC LIKE '% The gold fee %' or FMMC LIKE '% incidental %' OR FMMC LIKE'% Exchange fee %')),0) AS JE,
t1.czyxm AS JBR
,nvl((SELECT sum(ssje) FROM fyb_mx WHERE djh=t1.djh and ywdjh=t1.ywdjh and FMMC LIKE '% Avatar fee %' ),0) as TXF
,nvl((SELECT sum(ssje) FROM fyb_mx WHERE djh=t1.djh and ywdjh=t1.ywdjh and FMMC LIKE '% Funeral expenses %' ),0) as AZF
,nvl((SELECT sum(ssje) FROM fyb_mx WHERE djh=t1.djh and ywdjh=t1.ywdjh and FMMC LIKE '% Engraving fee %'),0) as KZF
,nvl((SELECT sum(ssje) FROM fyb_mx WHERE djh=t1.djh and ywdjh=t1.ywdjh and FMMC LIKE '% The premium %' ),0) as TJF
,nvl((SELECT sum(ssje) FROM fyb_mx WHERE djh=t1.djh and ywdjh=t1.ywdjh and FMMC LIKE '% The gold fee %' ),0) as MJF
,nvl((SELECT sum(ssje) FROM fyb_mx WHERE djh=t1.djh and ywdjh=t1.ywdjh and (FMMC LIKE '% incidental %' OR FMMC LIKE '% other expenses %') ),0) as ZF
,nvl((SELECT sum(ssje) FROM fyb_mx WHERE djh=t1.djh and ywdjh=t1.ywdjh and FMMC LIKE '% Exchange fee %' ),0) as hbf
,(SELECT STAZBZ from azfs WHERE azfsdm=t1.azfsdm ) AS STAZ
,(SELECT LTAZBZ from azfs WHERE azfsdm=t1.azfsdm ) AS LTAZ
FROM qtywb t1
WHERE t1.zxflag <> '' and t1. mwflmc not like '%CU%' AND t1.azfsdm= '' and ywdm=''
and (djh,ywdjh) in ( select djh,ywdjh from fyb_mx t1 where (FMMC LIKE '% other expenses %' or FMMC LIKE '% Avatar fee %' or FMMC LIKE '% Funeral expenses %' or FMMC LIKE '% Engraving fee %' or FMMC LIKE '% The premium %' or FMMC LIKE '% The gold fee %' or FMMC LIKE '% incidental %' OR FMMC LIKE'% Exchange fee %')
and to_char(t1.sfrq, 'yyyy-mm-dd') >=''||beginTime||'' AND to_char (t1.sfrq, 'yyyy-mm-dd') <=''||endTime||'' and zxflag<>'' and azfsdm ='' )
;
RETURN;
end;
commit;
-- exception handling --
EXCEPTION
WHEN NO_DATA_FOUND THEN
RAISE_APPLICATION_ERROR(-20011, ' An exception occurred in the stored procedure !');
ROLLBACK;
end PROC_TZ_QUERY_DETAIL;
/

Procdure for wanfo business report More articles about

  1. C# Send in background HTTP request

    using System.Collections.Generic; using System.Linq; using System.Text; using System.Net; using Syst ...

  2. GitBook Plug in finishing - book.json To configure

    Catalog 1. Configuration Overview 1.1. Global configuration 1.2. Plug in list plugins 1.3. Plug in property configuration pluginsConfig 2. Some practical plug-ins 2.1. back-to-top-button go back to ...

  3. C# Background processing http request

    using System.Collections.Generic; using System.Linq; using System.Text; using System.Net; using Syst ...

  4. .net core utilize Selenium and PhantomJS Background generation EChart picture

    1. quote NuGet install : Selenium.Support Selenium.WebDriver Selenium.WebDriver.PhantomJS.CrossPlatform  ( Distribution Lin ...

  5. Spring Cloud series -Zuul Gateway integration JWT Authentication

    Preface In the past two or three years, the popular spring cloud frame , There is also a certain amount of accumulation , I plan to arrange some dry goods to share with you when I have time . This sharing zuul Gateway integration jwt Authentication Business background Identity authentication is indispensable for project development ,j ...

  6. JAVA FileUtils( File reading and writing and operation tool class )

    Common functions of file operation : package com.suning.yypt.business.report; import java.io.*; import java.util.*; @SuppressWa ...

  7. Monthly Income Report – August 2016

    Link to the original text :https://marcoschwartz.com/monthly-income-report-august-2016/ Every month, I publish a report of ...

  8. Session for SSRS Report of Microsoft Dynamics AX

    Session for SSRS Report of Microsoft Dynamics AX Copyright notice : This article is an original blog article , No reprint without the permission of the blogger . Contract •A data contrac ...

  9. Report processing of Microsoft Dynamic AX

    Report processing of Microsoft Dynamic AX Copyright notice : This article is an original blog article , No reprint without the permission of the blogger . The implementation of a general ...

Random recommendation

  1. python code snippet 7

    #coding=utf-8 # list book=['python','development',8] book.append(2008) print book book.insert(1,'web') ...

  2. ViewState Compress

    /// <summary> ///CompressViewState Summary description of /// </summary> public class CompressViewState:S ...

  3. see oracle How long did it start

    I want to see how many days the system has been running normally ? How long has it been since I started up ? windows System C:\>systeminfo |find “ System start time ” System start time :     265 God 4 Hours 26 branch 32 ...

  4. ios Implementation of the program into the background , Achieve background tasks

    First ,iOS It's going to keep cutting back into the background , Give us 5 Seconds to process the data ,5 Seconds later , The program doesn't execute any more code , In a suspended state . // Project requirements , Press down Home Transfer some data to the server after switching the background , I don't say much nonsense , Go straight to the code /* ...

  5. Database management ——Powershell—— Use Powershell The script finds the files that consume the most disk space

    original text : Database management --Powershell-- Use Powershell The script finds the files that consume the most disk space The original is translated from : http://www.mssqltips.com/sqlservertip/2774/p ...

  6. 2017 Latest installation mysql Tutorial and problem solving Windows Next

    Today, because I changed LINUX System Take mine E The disk was accidentally unloaded It still doesn't work   Lead to I E Inside the plate mysql It's all deleted     So I'm going to install another one at a time MYSQL 了     It took a lot of time   I've also seen a lot of tutorials . good ...

  7. version control — Use Gradle Automatically manage application versions

    We are developing App when , Usually at the end of the project Release In this stage, we need to set the version number and the version name of the application , That is, set the following two properties versionCode versionName Version number among versionCode The value of is i ...

  8. Spring--ClassPathResource

    /* * Load resources with a given class loader or a given class */ public class ClassPathResource extends AbstractFileResolvingResource { ...

  9. react-redux- Data flow

    redux It's strictly one-way data flow 1,store.dispatch(action) 2, reducer(previousState, action), reducer Is a function of pure . It's only used to calculate the next st ...

  10. Django Basics ( 3、 ... and )

    Knowledge preview Ajax Foreplay :json Ajax brief introduction jquery Realized ajax JS Realized ajax Back to the top Ajax Foreplay :json What is? json? Definition : JSON(JavaScript Object ...