|
摘要：
script language="javascript" type="text/javascript" document.write(document.body.clientWidth+"br");页面BODY的宽度 (包括滚动条) document.write(document.body.clientHeight+"br");页面BODY的宽度(包括滚动条) document.write(document.documentElement.clientWidth+"br");页面BODY的宽度 (不包括滚动条) document.write(document.documentE 阅读全文
摘要：
js获取控件的绝对位置 已经控件宽度和高度2010-08-11 13:07//获取控件左绝对位置function getAbsoluteLeft(objectId) {o = document.getElementById(objectId)oLeft = o.offsetLeftwhile(o.offsetParent!=null) { oParent = o.offsetParentoLeft += oParent.offsetLeft o = oParent}return oLeft}//获取控件上绝对位置function getAbsoluteTop(objectId) {o = do 阅读全文
摘要：
%@ Page Language="C#" AutoEventWireup="true" CodeBehind="DCS_SubmitNewRequest.aspx.cs" Inherits="BAF.DCS.Web.DCS_SubmitNewRequest" %!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"html xmlns="http://www.w3.org/1999/xhtml"h 阅读全文
摘要：
create table tb ([id] int,[name] varchar(2))insert into tbselect 1,'aa' union allselect 2,'bb' union allselect 1,'cc' union allselect 3,'dd' union allselect 2,'ee'select * from tb--查询select id, name=stuff((select ','+name from tb where id=t.id for xml path('')),1,1,'')from tb tgroup by id方法二：CREATE 阅读全文
摘要：
Sql的CTEWITH EMPLOYEE_LIST AS (SELECT A.EMP_NO AS APPROVER_ID,1 AS SEQUENCE_NO,'实际需求方/DEPT MANAGER' AS APPROVER_ROLE,A.SUPERVISORFROM AM_EMPLOYEE A,FIN_APPROVE_MODEL BWHERE B.FORM_TYPE='CT_BI' AND B.OU_CODE=@OU_CODEAND A.EMP_NO= B.EMPLOYEE_NUMBER AND A.EMP_NO=@EMP_NOUNION ALLSELECT A.EMP_NO AS APPROV 阅读全文
摘要：
SELECT ename FROM scott.emp START WITH ename = 'KING' CONNECT BY PRIOR empno = mgr; --得到结果为： KING JONES SCOTT ADAMS FORD SMITH BLAKE ALLEN WARD MARTIN TURNER JAMES 而： SELECT SYS_CONNECT_BY_PATH(ename, '') "Path" FROM scott.emp START WITH ename = 'KING' CONNECT BY PRIOR empno = mgr; --得到结果为： KING 阅读全文
摘要：
阿里巴巴项目用到：SELECT LTRIM(MAX(SYS_CONNECT_BY_PATH(ou_code, ';')), ';') AS RESULT FROM (SELECT category_id, ou_code, RN, LEAD(RN) OVER(ORDER BY RN) RN1 FROM (SELECT category_id, ou_code, ROW_NUMBER() OVER(ORDER BY category_id, ou_code DESC) RN FROM (SELECT t.category_id, t.ou_code FROM bpm_dcs_category_o 阅读全文
摘要：
--父窗口<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Parent.aspx.cs" Inherits="Parent" %><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DT... 阅读全文
摘要：
(1)oracl访问sql主要是在表名后加上@链接服务器名SELECT H.FORM_KIND, H.FORM_NOFROM FM_FORM_HEADER@TOBPM H, FM_FORM_APPROVE@TOBPM AWHERE H.FORM_KIND = A.FORM_KIND AND H.FORM_NO = A.FORM_NO AND H.FORM_STATUS = 'WA' AND A.A... 阅读全文
摘要：
方法：public GridViewRow GetCurrentRow(Object CtrlInCell) { Control Ctrl = (Control)CtrlInCell; int Count = 0; while ((Ctrl = Ctrl.Parent) != null && Count < 5) { if (Ctrl.GetType().Name.Index... 阅读全文
|
