12 2013 档案
摘要:public void AutoPost(string url,string domain, string userName) { AlipayProxy.UserReg.UserReg userRegService = new AlipayProxy.UserReg.UserReg(); string password = userRegService.GetUserPassWord(userName); string language = "zh-cn"; string key = ...
阅读全文
摘要:javascript:document.getElementById('user').value='jack';document.getElementById('password').value='test';submitForm();void(0);
阅读全文
摘要:USE [AppCloud]GO/****** Object: UserDefinedFunction [dbo].[splitstr] Script Date: 12/19/2013 09:33:07 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCreate function [dbo].[splitstr](@SourceSql varchar(8000),@StrSeprate varchar(5))returns @temp table(F1 varchar(2000))as begin declare ...
阅读全文
摘要:select * from(select *, ROW_NUMBER() over(partition by IPAddress order by recordtime desc) as rowNumfrom MonitoringSystem) Awhere A.rowNum =@PreTime and IPAddress=@IPAddress order by RecordTime asc原表结构USE [SimCloudV3.1]GO/****** Object: Table [dbo].[MonitoringSystem] Script Date: 12/06/201...
阅读全文
摘要:-- 获取系统时间 print getdate()-- 获取3天前的时间 print dateadd(day, -3 , getdate())-- 获取3天后的时间 print dateadd(day, 3 , getdate())-- 获取3年前的时间 print dateadd(year, -3 , getdate())-- 获取3年后的时间 print dateadd(year, 3 , getdate())-- 获取3月后的时间 print dateadd(month, 3 , getdate())-- 获取9小时后的时间 print dateadd(hour, 9 , getdate
阅读全文