sqldataprovider.cs

1、用SQL查询器打开install目录下的dooogo.sql运行之后创建数据库dooogo。 2、然后打开web.config修改 <DbProvider type="Club.Fram

//Copyright (C) 2006 dooogo.com
//Author：benben
//www.aspxclub.com
using System;
using System.Data;
using System.Data.SqlClient;
using Club.Framework.Components;
namespace Club.Framework.Data
{
	/// <summary>
	/// Summary description for SqlDataProvider.
	/// </summary>
	public class SqlDataProvider : IDbProvider
	{
		static SqlDataProvider()
		{

		}
		private string _connectionString;
		public string ConnectionString
		{
			get {return this._connectionString;}
			set {this._connectionString = value;}
		}

		#region c_AddressListInfo

		public bool Create_c_AddressListInfo(c_AddressListInfo _c_AddressListInfo)
		{
			SqlParameter[] prams = {
									   SqlHelper.MakeInParam("@TrueName",System.Data.SqlDbType.VarChar,100,_c_AddressListInfo.TrueName),
									   SqlHelper.MakeInParam("@NiceName",System.Data.SqlDbType.VarChar,100,_c_AddressListInfo.NiceName),
									   SqlHelper.MakeInParam("@SortID",System.Data.SqlDbType.Int,4,_c_AddressListInfo.SortID),
									   SqlHelper.MakeInParam("@Birthday",System.Data.SqlDbType.DateTime,8,_c_AddressListInfo.Birthday),
									   SqlHelper.MakeInParam("@Tel",System.Data.SqlDbType.VarChar,50,_c_AddressListInfo.Tel),
									   SqlHelper.MakeInParam("@Mobile",System.Data.SqlDbType.VarChar,50,_c_AddressListInfo.Mobile),
									   SqlHelper.MakeInParam("@QQ",System.Data.SqlDbType.VarChar,50,_c_AddressListInfo.QQ),
									   SqlHelper.MakeInParam("@Email",System.Data.SqlDbType.VarChar,100,_c_AddressListInfo.Email),
									   SqlHelper.MakeInParam("@Address",System.Data.SqlDbType.VarChar,255,_c_AddressListInfo.Address),
									   SqlHelper.MakeInParam("@Explian",System.Data.SqlDbType.VarChar,1000,_c_AddressListInfo.Explian),
									   SqlHelper.MakeInParam("@RegisterID",System.Data.SqlDbType.Int,4,_c_AddressListInfo.RegisterID)
								   };
			return NonQueryBool("c_AddressList_Create",prams);
		}
		
		public bool Update_c_AddressListInfo(c_AddressListInfo _c_AddressListInfo)
		{
			SqlParameter[] prams = {
									   SqlHelper.MakeInParam("@ID",System.Data.SqlDbType.Int,4,_c_AddressListInfo.ID),
									   SqlHelper.MakeInParam("@TrueName",System.Data.SqlDbType.VarChar,100,_c_AddressListInfo.TrueName),
									   SqlHelper.MakeInParam("@NiceName",System.Data.SqlDbType.VarChar,100,_c_AddressListInfo.NiceName),
									   SqlHelper.MakeInParam("@SortID",System.Data.SqlDbType.Int,4,_c_AddressListInfo.SortID),
									   SqlHelper.MakeInParam("@Birthday",System.Data.SqlDbType.DateTime,8,_c_AddressListInfo.Birthday),
									   SqlHelper.MakeInParam("@Tel",System.Data.SqlDbType.VarChar,50,_c_AddressListInfo.Tel),
									   SqlHelper.MakeInParam("@Mobile",System.Data.SqlDbType.VarChar,50,_c_AddressListInfo.Mobile),
									   SqlHelper.MakeInParam("@QQ",System.Data.SqlDbType.VarChar,50,_c_AddressListInfo.QQ),
									   SqlHelper.MakeInParam("@Email",System.Data.SqlDbType.VarChar,100,_c_AddressListInfo.Email),
									   SqlHelper.MakeInParam("@Address",System.Data.SqlDbType.VarChar,255,_c_AddressListInfo.Address),
									   SqlHelper.MakeInParam("@Explian",System.Data.SqlDbType.VarChar,1000,_c_AddressListInfo.Explian),
									   SqlHelper.MakeInParam("@RegisterID",System.Data.SqlDbType.Int,4,_c_AddressListInfo.RegisterID)
								   };
			return NonQueryBool("c_AddressList_Update",prams);
		}
		
		public bool Delete_c_AddressListByID(Int32 iD)
		{
			SqlParameter[] prams = {
									   SqlHelper.MakeInParam("@ID",System.Data.SqlDbType.Int,4,iD)
								   };
			return NonQueryBool("c_AddressList_DeleteByID",prams);
		}

		public IDataReader Select_c_AddressListByID(Int32 iD)
		{
			SqlParameter[] prams = {
									   SqlHelper.MakeInParam("@ID",System.Data.SqlDbType.Int,4,iD)
								   };
			return GetReader("c_AddressList_SelectInfoByID",prams);
		}
		#endregion

		
		#region c_CircleInfo

		public bool Create_c_CircleInfo(c_CircleInfo _c_CircleInfo)
		{
			SqlParameter[] prams = {
									   SqlHelper.MakeInParam("@RegisterID",System.Data.SqlDbType.Int,4,_c_CircleInfo.RegisterID),
									   SqlHelper.MakeInParam("@CircleName",System.Data.SqlDbType.VarChar,100,_c_CircleInfo.CircleName),
									   SqlHelper.MakeInParam("@IsPublicity",System.Data.SqlDbType.Bit,1,_c_CircleInfo.IsPublicity),
									   SqlHelper.MakeInParam("@ImageUrl",System.Data.SqlDbType.VarChar,50,_c_CircleInfo.ImageUrl),
									   SqlHelper.MakeInParam("@CircleTypeID",System.Data.SqlDbType.Int,4,_c_CircleInfo.CircleTypeID),
									   SqlHelper.MakeInParam("@Explain",System.Data.SqlDbType.VarChar,500,_c_CircleInfo.Explain),
									   SqlHelper.MakeInParam("@InviteMode",System.Data.SqlDbType.Int,4,_c_CircleInfo.InviteMode),
									   SqlHelper.MakeInParam("@ApplicationMode",System.Data.SqlDbType.Int,4,_c_CircleInfo.ApplicationMode),
									   SqlHelper.MakeInParam("@ApplicationExplain",System.Data.SqlDbType.VarChar,1000,_c_CircleInfo.ApplicationExplain),
									   SqlHelper.MakeInParam("@PostDate",System.Data.SqlDbType.DateTime,8,_c_CircleInfo.PostDate),
									   SqlHelper.MakeInParam("@Hits",System.Data.SqlDbType.Int,4,_c_CircleInfo.Hits)
								   };
			return NonQueryBool("c_Circle_Create",prams);
		}
		
		public bool Update_c_CircleInfo(c_CircleInfo _c_CircleInfo)
		{
			SqlParameter[] prams = {
									   SqlHelper.MakeInParam("@ID",System.Data.SqlDbType.Int,4,_c_CircleInfo.ID),
									   SqlHelper.MakeInParam("@RegisterID",System.Data.SqlDbType.Int,4,_c_CircleInfo.RegisterID),
									   SqlHelper.MakeInParam("@CircleName",System.Data.SqlDbType.VarChar,100,_c_CircleInfo.CircleName),
									   SqlHelper.MakeInParam("@IsPublicity",System.Data.SqlDbType.Bit,1,_c_CircleInfo.IsPublicity),
									   SqlHelper.MakeInParam("@ImageUrl",System.Data.SqlDbType.VarChar,50,_c_CircleInfo.ImageUrl),
									   SqlHelper.MakeInParam("@CircleTypeID",System.Data.SqlDbType.Int,4,_c_CircleInfo.CircleTypeID),
									   SqlHelper.MakeInParam("@Explain",System.Data.SqlDbType.VarChar,500,_c_CircleInfo.Explain),
									   SqlHelper.MakeInParam("@InviteMode",System.Data.SqlDbType.Int,4,_c_CircleInfo.InviteMode),
									   SqlHelper.MakeInParam("@ApplicationMode",System.Data.SqlDbType.Int,4,_c_CircleInfo.ApplicationMode),
									   SqlHelper.MakeInParam("@ApplicationExplain",System.Data.SqlDbType.VarChar,1000,_c_CircleInfo.ApplicationExplain),
									   SqlHelper.MakeInParam("@PostDate",System.Data.SqlDbType.DateTime,8,_c_CircleInfo.PostDate),
									   SqlHelper.MakeInParam("@Hits",System.Data.SqlDbType.Int,4,_c_CircleInfo.Hits)
								   };
			return NonQueryBool("c_Circle_Update",prams);
		}
		
		public bool Delete_c_CircleByID(Int32 iD)
		{
			SqlParameter[] prams = {
									   SqlHelper.MakeInParam("@ID",System.Data.SqlDbType.Int,4,iD)
								   };
			return NonQueryBool("c_Circle_DeleteByID",prams);
		}
		
		public IDataReader Select_c_CircleByID(Int32 iD)
		{
			SqlParameter[] prams = {
									   SqlHelper.MakeInParam("@ID",System.Data.SqlDbType.Int,4,iD)
								   };
			return GetReader("c_Circle_SelectInfoByID",prams);
		}
		#endregion

		
		#region c_CircleActionInfo

		public bool Create_c_CircleActionInfo(c_CircleActionInfo _c_CircleActionInfo)
		{
			SqlParameter[] prams = {
									   SqlHelper.MakeInParam("@CircleID",System.Data.SqlDbType.Int,4,_c_CircleActionInfo.CircleID),
									   SqlHelper.MakeInParam("@Title",System.Data.SqlDbType.VarChar,100,_c_CircleActionInfo.Title),
									   SqlHelper.MakeInParam("@Content",System.Data.SqlDbType.NText,0,_c_CircleActionInfo.Content),
									   SqlHelper.MakeInParam("@StartDate",System.Data.SqlDbType.DateTime,8,_c_CircleActionInfo.StartDate),
									   SqlHelper.MakeInParam("@EndDate",System.Data.SqlDbType.DateTime,8,_c_CircleActionInfo.EndDate),
									   SqlHelper.MakeInParam("@CountryID",System.Data.SqlDbType.Int,4,_c_CircleActionInfo.CountryID),
									   SqlHelper.MakeInParam("@ProvinceID",System.Data.SqlDbType.Int,4,_c_CircleActionInfo.ProvinceID),
									   SqlHelper.MakeInParam("@CityID",System.Data.SqlDbType.Int,4,_c_CircleActionInfo.CityID),
									   SqlHelper.MakeInParam("@Address",System.Data.SqlDbType.VarChar,255,_c_CircleActionInfo.Address),
									   SqlHelper.MakeInParam("@AddressExplain",System.Data.SqlDbType.VarChar,1000,_c_CircleActionInfo.AddressExplain),
									   SqlHelper.MakeInParam("@ActionType",System.Data.SqlDbType.Int,4,_c_CircleActionInfo.ActionType),
									   SqlHelper.MakeInParam("@JoinType",System.Data.SqlDbType.Int,4,_c_CircleActionInfo.JoinType),
									   SqlHelper.MakeInParam("@PostDate",System.Data.SqlDbType.DateTime,8,_c_CircleActionInfo.PostDate)
								   };
			return NonQueryBool("c_CircleAction_Create",prams);
		}
		

		public bool Update_c_CircleActionInfo(c_CircleActionInfo _c_CircleActionInfo)
		{
			SqlParameter[] prams = {
									   SqlHelper.MakeInParam("@ID",System.Data.SqlDbType.Int,4,_c_CircleActionInfo.ID),
									   SqlHelper.MakeInParam("@CircleID",System.Data.SqlDbType.Int,4,_c_CircleActionInfo.CircleID),
									   SqlHelper.MakeInParam("@Title",System.Data.SqlDbType.VarChar,100,_c_CircleActionInfo.Title),
									   SqlHelper.MakeInParam("@Content",System.Data.SqlDbType.NText,0,_c_CircleActionInfo.Content),
									   SqlHelper.MakeInParam("@StartDate",System.Data.SqlDbType.DateTime,8,_c_CircleActionInfo.StartDate),
									   SqlHelper.MakeInParam("@EndDate",System.Data.SqlDbType.DateTime,8,_c_CircleActionInfo.EndDate),
									   SqlHelper.MakeInParam("@CountryID",System.Data.SqlDbType.Int,4,_c_CircleActionInfo.CountryID),
									   SqlHelper.MakeInParam("@ProvinceID",System.Data.SqlDbType.Int,4,_c_CircleActionInfo.ProvinceID),
									   SqlHelper.MakeInParam("@CityID",System.Data.SqlDbType.Int,4,_c_CircleActionInfo.CityID),
									   SqlHelper.MakeInParam("@Address",System.Data.SqlDbType.VarChar,255,_c_CircleActionInfo.Address),
									   SqlHelper.MakeInParam("@AddressExplain",System.Data.SqlDbType.VarChar,1000,_c_CircleActionInfo.AddressExplain),
									   SqlHelper.MakeInParam("@ActionType",System.Data.SqlDbType.Int,4,_c_CircleActionInfo.ActionType),
									   SqlHelper.MakeInParam("@JoinType",System.Data.SqlDbType.Int,4,_c_CircleActionInfo.JoinType),
									   SqlHelper.MakeInParam("@PostDate",System.Data.SqlDbType.DateTime,8,_c_CircleActionInfo.PostDate)
								   };
			return NonQueryBool("c_CircleAction_Update",prams);
		}

		public bool Delete_c_CircleActionByID(Int32 iD)
		{
			SqlParameter[] prams = {
									   SqlHelper.MakeInParam("@ID",System.Data.SqlDbType.Int,4,iD)
								   };
			return NonQueryBool("c_CircleAction_DeleteByID",prams);
		}
		
		public IDataReader Select_c_CircleActionByID(Int32 iD)
		{
			SqlParameter[] prams = {
									   SqlHelper.MakeInParam("@ID",System.Data.SqlDbType.Int,4,iD)
								   };
			return GetReader("c_CircleAction_SelectInfoByID",prams);
		}
		#endregion

		
		#region c_CircleActionJoinerInfo

		public bool Create_c_CircleActionJoinerInfo(c_CircleActionJoinerInfo _c_CircleActionJoinerInfo)
		{
			SqlParameter[] prams = {
									   SqlHelper.MakeInParam("@ActionID",System.Data.SqlDbType.Int,4,_c_CircleActionJoinerInfo.ActionID),
									   SqlHelper.MakeInParam("@JoinerRegisterID",System.Data.SqlDbType.Int,4,_c_CircleActionJoinerInfo.JoinerRegisterID),
									   SqlHelper.MakeInParam("@PostDate",System.Data.SqlDbType.DateTime,8,_c_CircleActionJoinerInfo.PostDate)
								   };
			return NonQueryBool("c_CircleActionJoiner_Create",prams);
		}
		
		public bool Update_c_CircleActionJoinerInfo(c_CircleActionJoinerInfo _c_CircleActionJoinerInfo)
		{
			SqlParameter[] prams = {
									   SqlHelper.MakeInParam("@ID",System.Data.SqlDbType.Int,4,_c_CircleActionJoinerInfo.ID),
									   SqlHelper.MakeInParam("@ActionID",System.Data.SqlDbType.Int,4,_c_CircleActionJoinerInfo.ActionID),
									   SqlHelper.MakeInParam("@JoinerRegisterID",System.Data.SqlDbType.Int,4,_c_CircleActionJoinerInfo.JoinerRegisterID),
									   SqlHelper.MakeInParam("@PostDate",System.Data.SqlDbType.DateTime,8,_c_CircleActionJoinerInfo.PostDate)
								   };
			return NonQueryBool("c_CircleActionJoiner_Update",prams);
		}
		
		public bool Delete_c_CircleActionJoinerByID(Int32 iD)
		{
			SqlParameter[] prams = {
									   SqlHelper.MakeInParam("@ID",System.Data.SqlDbType.Int,4,iD)
								   };
			return NonQueryBool("c_CircleActionJoiner_DeleteByID",prams);
		}
		
		public IDataReader Select_c_CircleActionJoinerByID(Int32 iD)
		{
			SqlParameter[] prams = {
									   SqlHelper.MakeInParam("@ID",System.Data.SqlDbType.Int,4,iD)
								   };
			return GetReader("c_CircleActionJoiner_SelectInfoByID",prams);
		}
		#endregion
		
		#region c_CircleGuestBookInfo

		public IDataReader Select_c_CircleGuestBookByID(Int32 iD)
		{
			SqlParameter[] prams = {
									   SqlHelper.MakeInParam("@ID",System.Data.SqlDbType.Int,4,iD)
								   };
			return GetReader("c_CircleGuestBook_SelectInfoByID",prams);
		}
		public bool Delete_c_CircleGuestBookByID(Int32 iD)
		{
			SqlParameter[] prams = {
									   SqlHelper.MakeInParam("@ID",System.Data.SqlDbType.Int,4,iD)
								   };
			return NonQueryBool("c_CircleGuestBook_DeleteByID",prams);
		}
		public bool Update_c_CircleGuestBookInfo(c_CircleGuestBookInfo _c_CircleGuestBookInfo)
		{
			SqlParameter[] prams = {
									   SqlHelper.MakeInParam("@ID",System.Data.SqlDbType.Int,4,_c_CircleGuestBookInfo.ID),