jquery 常用技巧合计
jquery 插件开发方法:
点击下载此文件
tooltip的一个例子
点击下载此文件
自己写的一个javascript 验证框架
点击下载此文件
一篇OATH2的介绍文章
http://tutorials.jenkov.com/oauth2/authorization.html
Create or REPLACE FUNCTION "BBJIHEROUND"
(
v_Param Number,
v_Precision NUMBER,
v_IsNull Boolean
)
RETURN Number
IS
--Created by yangqh
--2002.3.5
--处理稽核中的精度问题
BEGIN
if v_IsNull then
if ABS(v_Param) < 0.0001 or v_Param is null then
Return 0;
else
Return Round(v_Param, v_Precision);
end if;
else
if ABS(v_Param) < 0.0001 then
Return 0;
else
Return Round(v_Param, v_Precision);
end if;
end if;
END;
================
Create or REPLACE PROCEDURE "BMONTH" (ssTime Date)is
sSQL VARCHAR(8000);
lastDay VARCHAR(8);
begin
IF (ISEXISTTABLE('TMONTH_TEMP')=0) THEN
EXECUTE IMMEDIATE 'Create GLOBAL TEMPORARY TABLE TMONTH_TEMP
(
BID NUMBER(10),
BAID NUMBER(10),
BALANCE0 NUMBER(18,2),
INCOMEMONEY NUMBER(18,2),
PAYOUTMONEY NUMBER(18,2),
BALANCE1 NUMBER(18,2),
BALANCE2 NUMBER(18,2),
YEAR NUMBER(10),
MONTH NUMBER(10),
CID NUMBER(10),
RQ NUMBER(10)
) ON COMMIT PRESERVE ROWS';
END IF ;
IF (ISEXISTTABLE('ZH')=0) THEN
EXECUTE IMMEDIATE 'Create GLOBAL TEMPORARY TABLE ZH
(
BID INTEGER,
BAID INTEGER,
CID INTEGER
) ON COMMIT PRESERVE ROWS ';
END IF ;
IF (ISEXISTTABLE('LMONTH_TEMP')=0) THEN
EXECUTE IMMEDIATE 'Create GLOBAL TEMPORARY TABLE LMONTH_TEMP
(
BID NUMBER(10),
BAID NUMBER(10),
BALANCE0 NUMBER(18,2)
)ON COMMIT PRESERVE ROWS';
END IF ;
IF (ISEXISTTABLE('DATA_TEMP')=0) THEN
EXECUTE IMMEDIATE 'Create GLOBAL TEMPORARY TABLE DATA_TEMP
(
BID INTEGER,
BAID INTEGER,
INCOMEMONEY NUMBER(18,2),
PAYOUTMONEY NUMBER(18,2)
)ON COMMIT PRESERVE ROWS';
END IF ;
IF (ISEXISTTABLE('LBALANCE')=0) THEN
EXECUTE IMMEDIATE 'Create GLOBAL TEMPORARY TABLE LBALANCE
(
BID INTEGER,
BAID INTEGER,
ENDBALANCE NUMBER
) ON COMMIT PRESERVE ROWS ';
END IF ;
execute immediate 'TRUNCATE TABLE TMONTH_TEMP';
execute immediate 'TRUNCATE TABLE LMONTH_TEMP';
execute immediate 'TRUNCATE TABLE DATA_TEMP ' ;
execute immediate 'TRUNCATE TABLE ZH';
execute immediate 'TRUNCATE TABLE LBALANCE';
delete from ZJ_BABALANCEMONTH where rq = cast(to_char(ssTime, 'yyyymm') as int);
commit ;
--上月计算数据
sSQL := 'insert into LMONTH_TEMP select BID, BAID, BALANCE0 from ZJ_BABALANCE where
RQ =' ||TO_CHAR(TRUNC(ssTime, 'MONTH'), 'YYYYMMDD') || '';
execute immediate sSQL ;
--本月计算帐号
sSQL := 'insert into TMONTH_TEMP
select bid,baid,null,null,null,null,null,
' || to_char(ssTime,'yyyy') || ' as year,
'|| to_char(ssTime,'mm') || ' as month, cid,
' || to_char(ssTime,'yyyymm') ||' as rq from ZJ_BANKACCOUNT
where endtime = to_date(' ||'''2049-12-31'' ,''yyyy-mm-dd'''||'
)or endtime >= TO_DATE('''||TO_CHAR(ssTime,'YYYY-MM-DD')||''',''YYYY-MM-DD'')';
execute immediate sSQL ;
--改变月初没有余额帐号取月初余额的方法. alert by lxj 2007-4-25
--取没有月初余额的帐号
sSQL := 'insert into ZH(BID, BAID)
select BID,BAID
from TMONTH_TEMP A
where not exists(select * from LMONTH_TEMP B where B.BAID = A.BAID )' ;
execute immediate sSQL ;
sSQL := ' DECLARE
CURSOR ENDBALANCE_CURSOR IS
select BID, BAID from ZH ;
begin
for EMP_RECORD IN ENDBALANCE_CURSOR LOOP
insert into LMONTH_TEMP
select * from
(
select BID, BAID, BALANCE1 from ZJ_BABALANCE
where BID = EMP_RECORD.BID AND BAID = EMP_RECORD.BAID
and rq >=' || TO_CHAR(TRUNC(ssTime, 'MONTH') , 'YYYYMMDD')
|| ' and BALANCE0 is not null and RQ <='|| TO_CHAR(ssTime, 'YYYYMM')
|| '31 order by BALANCETIME
)
where rownum = 1 ;
end loop;
end ;' ;
execute immediate sSQL ;
--end add
--本月数据
sSQL := 'insert into DATA_TEMP
select bid, baid,
sum(incomemoney) as incomemoney ,
sum(payoutmoney) as payoutmoney
from ZJ_BABALANCE
where rq >=' || TO_CHAR(TRUNC(ssTime, 'MONTH') , 'YYYYMMDD')
|| ' and rq <='|| TO_CHAR(ssTime, 'YYYYMM') || '31 group by bid,baid ' ;
execute immediate sSQL ;
--取得期初余额
sSQL := 'update TMONTH_TEMP A
set balance0 = (select B.balance0 from LMONTH_TEMP B
where A.bid = B.bid and A.baid = B.baid)
where exists(select * from LMONTH_TEMP B where A.BID = B.BID AND A.BAID = B.BAID)' ;
execute immediate sSQL ;
--交易和
sSQL := 'update TMONTH_TEMP A set (PAYOUTMONEY, INCOMEMONEY) =
(select PAYOUTMONEY, INCOMEMONEY from DATA_TEMP B Where A.BID = B.BID AND A.BAID = B.BAID )
where exists(select BID from DATA_TEMP C Where A.BID = C.BID AND A.BAID = C.BAID ) ' ;
execute immediate sSQL ;
commit ;
sSQL := 'update TMONTH_TEMP set BALANCE1 = BALANCE0 + INCOMEMONEY - PAYOUTMONEY Where BALANCE0 is not null ' ;
execute immediate sSQL ;
/*--计算有返回余额的账户 del by lxj
sSQL := 'insert into ZH(BID, BAID) select BID, BAID
FROM TMONTH_TEMP
where BID not in(2,1,30,40) and balance0 is not null ' ;
execute immediate sSQL ;
Select cast(NVL(max(rq), 0) as varchar(8)) into lastDay from zj_balist
where rq >= cast(to_char(trunc(ssTime, 'month'), 'yyyymmdd') as int) and
rq <= cast(to_char(ssTime, 'yyyymm')||31 as int);
IF (lastday <> '0') then
sSQL := ' DECLARE
CURSOR ENDBALANCE_CURSOR IS
select BID, BAID from ZH ;
begin
for EMP_RECORD IN ENDBALANCE_CURSOR LOOP
insert into LBALANCE select BID, BAID, BALANCE1 from ZJ_BABALANCE
where BID = EMP_RECORD.BID AND BAID = EMP_RECORD.BAID
and rq <= ' || lastDay ||
'and rownum < 2 and (BZ1 = 1 or BZ1 = 6) order by BALANCETIME desc ;
end loop;
end ;' ;
execute immediate sSQL ;
end if ;
sSQL := 'update TMONTH_TEMP A set(BALANCE1, BALANCE0) =
(select B.ENDBALANCE ,
B.ENDBALANCE- A.INCOMEMONEY + A.PAYOUTMONEY
from LBALANCE B where A.BAID = B.BAID )
where exists (select * from LBALANCE B Where A.BAID = B.BAID)' ;
execute immediate sSQL ;*/
sSQL := 'delete from ZJ_BABALANCEMONTH where RQ ='|| to_char(sstime ,'yyyymm') ;
execute immediate sSQL ;
sSQL := 'insert into ZJ_BABALANCEMONTH select * from TMONTH_TEMP' ;
execute immediate sSQL ;
-- ADD BY LXJ 集团帐号处理
execute immediate 'delete from ZJ_BABALANCEMONTHGROUP where RQ ='|| to_char(sstime ,'yyyymm') ;
commit;
sSQL := 'insert into TMONTH_TEMP
select bid,baid,null,null,null,null,null,
' || to_char(ssTime,'yyyy') || ' as year,
'|| to_char(ssTime,'mm') || ' as month, cid,
' || to_char(ssTime,'yyyymm') ||' as rq from ZJ_BANKACCOUNT
where endtime = to_date(' ||'''2049-12-31'' ,''yyyy-mm-dd'''||'
)or endtime >= TO_DATE('''||TO_CHAR(ssTime,'YYYY-MM-DD')||''',''YYYY-MM-DD'')
and GROUPKIND = 1';
execute immediate sSQL ;
execute immediate 'TRUNCATE TABLE LMONTH_TEMP';
sSQL := ' DECLARE
CURSOR ENDBALANCE_CURSOR IS
select BID, BAID from ZJ_BABALANCEMONTHGROUP where rq ='|| TO_CHAR(ssTime, 'YYYYMM')||';
begin
for EMP_RECORD IN ENDBALANCE_CURSOR LOOP
insert into LMONTH_TEMP
select * from
(
select BID, BAID, BALANCE0 from ZJ_BABALANCEGROUP
where BID = EMP_RECORD.BID AND BAID = EMP_RECORD.BAID
and rq >=' || TO_CHAR(TRUNC(ssTime, 'MONTH') , 'YYYYMMDD')
|| ' and BALANCE0 is not null and RQ <='|| TO_CHAR(ssTime, 'YYYYMM')
|| '31 order by BALANCETIME
)
where rownum = 1;
end loop;
end ;' ;
execute immediate sSQL ;
sSQL := 'update ZJ_BABALANCEMONTHGROUP A
set balance0 = (
select BALANCE0 from LMONTH_TEMP B Where A.BAID = B.BAID
)
where A.RQ ='|| to_char(sstime ,'yyyymm')
||' and exists(select 1 from LMONTH_TEMP B where B.BAID = A.BAID )' ;
execute immediate sSQL ;
--集团站好的收入指出直接从普通帐号表取得
sSQL := 'update ZJ_BABALANCEMONTHGROUP A
set (INCOMEMONEY ,PAYOUTMONEY) =
(
select INCOMEMONEY ,PAYOUTMONEY from zj_babalancemonth B
where B.RQ='||to_char(ssTime, 'yyyymm')||' and B.BAID = A.BAID
)'
|| 'where A.RQ = '||to_char(ssTime, 'yyyymm')
|| ' and exists(select 1 from zj_babalancemonth B where A.BAID = B.BAID
and A.RQ = B.RQ AND B.RQ ='||to_char(ssTime, 'yyyymm')||' )' ;
execute immediate sSQL ;
sSQL := 'update ZJ_BABALANCEMONTHGROUP
set BALANCE1 = BALANCE0 + INCOMEMONEY - PAYOUTMONEY
where RQ = '||to_char(ssTime, 'yyyymm');
execute immediate sSQL ;
BMONTHDW(ssTime);
commit ;
end BMonth;
前段框架
ztree ,simpledata的配置方式
var setting = {
view: {
showLine: false,
// showIcon: showIconForTree,
dblClickExpand: true
},
data: {
simpleData: {
enable: true,
idKey: "id",
pIdKey: "pId",
rootPId: 0
}
},
====================
ztree 指定节点的展开：
var treeObj = $("#treeDemo");
$.fn.zTree.init(treeObj, setting, Znode1);
zTree_Menu = $.fn.zTree.getZTreeObj("treeDemo");
var node = zTree_Menu.getNodeByParam("id",pid );
zTree_Menu.selectNode(node,true);//指定选中ID的节点
zTree_Menu.expandNode(node, true, false);//指定选中ID节点展开
