摘要： View Code 1 using System; 2 2 using System.Collections.Generic; 3 3 using System.Text; 4 4 using System.Web; 5 5 using System.IO; 6 6 using System.Web.Configuration; 7 7 using System.Configuration; 8 8 using System.Web.Security; 9 9 using System.Web.UI.WebControls; 10 10 namespace ... 阅读全文

摘要： View Code 1 GO 2 /****** Object: StoredProcedure [dbo].[UP_General_SelectByWhere] Script Date: 03/17/2011 10:49:23 ******/ 3 SET ANSI_NULLS ON 4 GO 5 SET QUOTED_IDENTIFIER ON 6 GO 7 -- ============================================= 8 -- Author: <Author,,Name> 9 -- Create date: <Create Dat... 阅读全文

摘要： View Code 2 GO 3 /****** Object: StoredProcedure [dbo].[UP_General_GetPage] Script Date: 03/17/2011 11:16:59 ******/ 4 SET ANSI_NULLS OFF 5 GO 6 SET QUOTED_IDENTIFIER OFF 7 GO 8 9 10 -- =============================================11 -- 主 题：通用分页存储过程12 -- 功 能：对数据按照 不同的列，不同页尺寸分页13 -... 阅读全文

摘要： View Code 1 GO 2 /****** Object: StoredProcedure [dbo].[UP_General_GetRowCount] Script Date: 03/17/2011 11:17:19 ******/ 3 SET ANSI_NULLS ON 4 GO 5 SET QUOTED_IDENTIFIER ON 6 GO 7 ALTER PROCEDURE [dbo].[UP_General_GetRowCount] 8 @strTable nvarchar(255), -- 表名 9 @strField nvarchar(1000) = '*' 阅读全文

摘要： View Code 1 GO 2 /****** Object: StoredProcedure [dbo].[UP_General_GetOrderPage] Script Date: 03/17/2011 11:16:42 ******/ 3 SET ANSI_NULLS ON 4 GO 5 SET QUOTED_IDENTIFIER ON 6 GO 7 ALTER PROCEDURE [dbo].[UP_General_GetOrderPage] 8 @tblName nvarchar(255), -- 表名 9 @st... 阅读全文

摘要： View Code 1 GO 2 /****** Object: StoredProcedure [dbo].[UP_Common_GetPage] Script Date: 03/17/2011 11:16:21 ******/ 3 SET ANSI_NULLS ON 4 GO 5 SET QUOTED_IDENTIFIER ON 6 GO 7 -- ============================================= 8 -- Author: 9 -- Create date: 2-2010 -- Description: 分页存储过程11 -- ===... 阅读全文