摘要：
--获取当前及以下部门Create proc GetCurrentAndUnderOrg@orgId intasbegin WITH cte AS ( SELECT * ,0 AS level FROM Static_Organ WHERE OrganID=@orgId UNION ALL SELECT g.*,level+1 FROM Static_Organ g INNER JOIN cte ON g.ParentOrgan=cte.OrganID ) SELECT * FROM cteend编辑器加载中... 阅读全文
摘要：
http://blog.csdn.net/21aspnet/article/details/1565877 阅读全文
摘要：
现在的手机号码增加了150,153,156,158,159，157，188，189所以正则表达式如下:string s = @"^(13[0-9]|15[0|3|6|7|8|9]|18[8|9])\d{8}$"; 阅读全文
摘要：
1.表结构 2.查询语句create procedure Pro_GetUnderOrg(in idd varchar(36))begindeclare lev int;set lev=1;drop table if exists tmp1; CREATE TABLE tmp1(ID VARCHAR(36),OrgName varchar(50),ParentID varchar(36) ,levv INT); INSERT tmp1 SELECT ID,OrgName,ParentID,1 FROM `organization` WHERE ParentID=idd;while row_co 阅读全文
摘要：
BULK INSERT dbo.tabTimeDataFROM 'F:\自动观测站\tabtimedata\tabtimedata.txt'WITH ( FIELDTERMINATOR = ',', ROWTERMINATOR = '\n') 阅读全文
摘要：
1,设置mySql连接字符串gb23122,PowerDesinger->Database->Generate Database->Format 阅读全文
摘要：
View Code delete from StationInfo where StationID in (select StationID from StationInfo group by StationID having COUNT(StationID)>1) 阅读全文
摘要：
using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.IO.Pipes;using System.Security.Principal;namespace TopInfo.Metevation.Common{ public class PipeMessageUtil { private const string PipeName = "TopInfoPipe"; public static bool NeedSendMessage = fa 阅读全文
摘要：
public class SystemEventLog { private static EventLog mLog; /// <summary> /// 返回操作Windows日志的类。 /// </summary> public static EventLog Log { get { if (mLog == null) { InitSystemEventLog(); } return mLog; } } /// <summary> /// 初始化系统事件日志 /// </summary> private static void InitSys 阅读全文
摘要：
using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Runtime.InteropServices;using System.Diagnostics;namespace TopInfo.Metevation.Common{ //WM_COPYDATA消息所要求的数据结构 public struct CopyDataStruct { public IntPtr dwData; public int cbData; [MarshalAs(UnmanagedTyp 阅读全文