摘要： 方法1： public static bool AdjustLeave(OaLeaveInfo oaLeaveInfo, DataTable dtDetail,decimal dl_OlderYiXiuNianJia, string str_userID, string str_plantID, decimal dlDours) { ArrayList al = new ArrayList(); //备份原始记录 string strSql = "insert into oa_l... 阅读全文

摘要： CREATE TRIGGER tgr_OrderList_delete ON [dbo].[OrderList]FOR DELETE ASBEGINDELETE PartsList FROM PartsList, deleted --使用特殊表进行查询删除条件 WHERE PartsList.OrderNum=deleted.OrderNumEND 阅读全文

摘要： SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOIF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[SysFun]') AND type in (N'U'))BEGINCREATE TABLE [dbo].[SysFun]( [Node_id] [int] IDENTITY(1,1) NOT NULL, [DisplayName] [varchar](50) NULL, [NameSpace] [varchar](50 阅读全文