摘要: USE [DEV] GO /****** Object: UserDefinedFunction [dbo].[GetTableId] Script Date: 12/21/2011 17:34:22 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- ===============... 阅读全文
posted @ 2011-12-21 17:35 perock 阅读(183) 评论(0) 推荐(0) 编辑
摘要: USE [DEV] GO /****** Object: UserDefinedFunction [dbo].[FormatSQL] Script Date: 12/21/2011 17:32:05 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER function [dbo... 阅读全文
posted @ 2011-12-21 17:34 perock 阅读(365) 评论(0) 推荐(0) 编辑
摘要: USE [DEV] GO /****** Object: UserDefinedFunction [dbo].[FormatStr] Script Date: 12/21/2011 17:32:18 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER function [dbo... 阅读全文
posted @ 2011-12-21 17:33 perock 阅读(453) 评论(0) 推荐(0) 编辑
摘要: public static boolean isIncludesInUserGroup(userID _userid,userGroupID _UserGroup) { userGroupList userGroupList; boolean ret; ; select firstonly grou... 阅读全文
posted @ 2011-12-21 15:35 perock 阅读(343) 评论(0) 推荐(0) 编辑
摘要: // Changed on 20 May 2006 at 07:02:15 by ZYJ // 论坛:www.qiuhao.com // 博客:http://www.qiuhao.com/boke.asp?maxfara.index.html // 邮箱:Zhouyujie238@hotmail.com //本函数来自andy的代码 //出处:http://www.qiuh... 阅读全文
posted @ 2011-12-21 15:32 perock 阅读(464) 评论(0) 推荐(0) 编辑
摘要: // Changed on 20 May 2006 at 07:02:15 by ZYJ // 论坛:www.qiuhao.com // 博客:http://www.qiuhao.com/boke.asp?maxfara.index.html // 邮箱:Zhouyujie238@hotmail.com//BestPractice: //优先使用MenuFunction 来调用对象; //在不能使用MenuFunction的时候,使用classFactory进行调用; //不能使用classFactory的时候,再考虑直接使用new FormRun/ReportRun ; static voi 阅读全文
posted @ 2011-12-21 15:22 perock 阅读(460) 评论(0) 推荐(0) 编辑
摘要: 开发SSRS时放在 vs2005: C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PublicAssemblies vs2008: C:\Program Files\Microsoft Visual Studio 9.0\Common7\IDE\PublicAssemblies 发布到服务器时放在: SQL2005: C... 阅读全文
posted @ 2011-12-21 12:09 perock 阅读(229) 评论(0) 推荐(0) 编辑
摘要: using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Data.SqlTypes; using System.Drawing; using Syst... 阅读全文
posted @ 2011-12-21 11:44 perock 阅读(203) 评论(0) 推荐(0) 编辑
摘要: ALTER proc [dbo].[NJ_AddWhere] @strSQL varchar(256) output, @isWhere bit output as begin if @isWhere = 0 begin set @strSQL = @strSQL + ' Where '; set @is... 阅读全文
posted @ 2011-12-21 11:34 perock 阅读(207) 评论(0) 推荐(0) 编辑
摘要: static void ExampleLedgerJournal(Args _args) { LedgerJournalName ledgerJournalName; LedgerJournalTable ledgerJournalTable; LedgerJour... 阅读全文
posted @ 2011-12-21 11:30 perock 阅读(390) 评论(0) 推荐(0) 编辑
摘要: 阅读全文
posted @ 2011-12-21 08:40 perock 阅读(152) 评论(0) 推荐(0) 编辑