摘要:
import java.util.ArrayList;import java.util.Arrays;import java.util.Collections;import java.util.Comparator;import java.util.List;public class Demo { ... 阅读全文
摘要:
Ajax的写法:$(function() { var oid = GetRequest("OID"); //oid = "gh_fbcc787818d3"; var openid = GetRequest("OPENID"); //openid = "oVPTzt1-KZwUAP5xw8Vv... 阅读全文
摘要:
--查询出各类排名SELECT orderid,qty, ROW_NUMBER() OVER(ORDER BY qty) AS rownumber,--序号 RANK() OVER(ORDER BY qty) AS [rank],--断开的排名 DENSE_RANK() OVER(ORDER BY qty) AS denserank ,--连续的排名 NTILE(4) OVER(ORDER BY qty) AS [NTILE]--均分成四个数组FROM rankorderORDER BY qty 阅读全文
摘要:
create table product (ID int identity(1,1) primary key,ProductName varchar(20),productType varchar(20)) insert product values('羊羊鞋','L') insert product values('羊羊鞋','XL') insert product values('羊羊鞋','XXL') insert product values('羊羊鞋','XXXL& 阅读全文
摘要:
with tabs as ( select row_number() over (order by name) as rowNum , convert(varchar(10),dateadd(dd,number,convert(varchar(8),getdate(),120)+'01'),120) as dt from master..spt_values where type='P' and dateadd(dd,number,convert(varchar(8),getdate(),120)+'01')0 阅读全文
摘要:
execute sp_addlogin 'ACUser', 'abc.123','hr_skyworth';--给安财创建用户 exec sp_adduser 'ACUser' grant select on V_EmpInfoForAC to ACUser grant select on V_DeptInfoForAC to ACUser 阅读全文
摘要:
<html><head><script type="text/javascript" src="/jquery/jquery.js"></script><script type="text/javascript">$(document).ready(function(){$(".ex .hide").click(function(){$(this).parents(".d").hide("slow");});});& 阅读全文
摘要:
Jqurey的基本语法:jQuery 元素选择器1,$(this).hide():隐藏当前的元素,$(this)取得当前元素2,$(#tag1).hide():隐藏ID等于“tag1”的所有元素,$(#tag1)取得ID为tag1的所有元素3,$(.tag1).hide():隐藏Class等于“tag1”的所有元素,$(.tag1)取得Class为tag1的所有元素4,$(p).hide():隐藏该页面的所有的p元素,$(p)取得页面的所有的p元素5,$("p.intro").hide():隐藏该页面下所有的P元素下Class="intro"的元素,$( 阅读全文
摘要:
第一个Jqurey例子<html><head><script type="text/javascript" src="/jquery/jquery.js"></script><script type="text/javascript">$(document).ready(function(){$("button").click(function(){$("p").hide();});});</script></head 阅读全文
摘要:
public virtual EmployeeJoinInfo GetEmployeeJoinByWorkCode(string workCode) { using(ISession session = OpenSession()) { IList list = session.CreateCriteria(typeof(EmployeeJoinInfo)).Add(Expression.Eq("WorkCode", workCode)).Add(Expression.Not(Expression.Eq("... 阅读全文