sqldataprovider.cs

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

									   SqlHelper.MakeInParam("@CircleID",System.Data.SqlDbType.Int,4,_c_CircleGuestBookInfo.CircleID),
									   SqlHelper.MakeInParam("@RegisterID",System.Data.SqlDbType.Int,4,_c_CircleGuestBookInfo.RegisterID),
									   SqlHelper.MakeInParam("@Title",System.Data.SqlDbType.VarChar,100,_c_CircleGuestBookInfo.Title),
									   SqlHelper.MakeInParam("@Content",System.Data.SqlDbType.NText,0,_c_CircleGuestBookInfo.Content),
									   SqlHelper.MakeInParam("@PostDate",System.Data.SqlDbType.DateTime,8,_c_CircleGuestBookInfo.PostDate)
								   };
			return NonQueryBool("c_CircleGuestBook_Update",prams);
		}
		public bool Create_c_CircleGuestBookInfo(c_CircleGuestBookInfo _c_CircleGuestBookInfo)
		{
			SqlParameter[] prams = {
									   SqlHelper.MakeInParam("@CircleID",System.Data.SqlDbType.Int,4,_c_CircleGuestBookInfo.CircleID),
									   SqlHelper.MakeInParam("@RegisterID",System.Data.SqlDbType.Int,4,_c_CircleGuestBookInfo.RegisterID),
									   SqlHelper.MakeInParam("@Title",System.Data.SqlDbType.VarChar,100,_c_CircleGuestBookInfo.Title),
									   SqlHelper.MakeInParam("@Content",System.Data.SqlDbType.NText,0,_c_CircleGuestBookInfo.Content),
									   SqlHelper.MakeInParam("@PostDate",System.Data.SqlDbType.DateTime,8,_c_CircleGuestBookInfo.PostDate)
								   };
			return NonQueryBool("c_CircleGuestBook_Create",prams);
		}
		#endregion
		
		#region c_CircleMemberInfo

		public IDataReader Select_c_CircleMemberByID(Int32 iD)
		{
			SqlParameter[] prams = {
									   SqlHelper.MakeInParam("@ID",System.Data.SqlDbType.Int,4,iD)
								   };
			return GetReader("c_CircleMember_SelectInfoByID",prams);
		}
		public bool Delete_c_CircleMemberByID(Int32 iD)
		{
			SqlParameter[] prams = {
									   SqlHelper.MakeInParam("@ID",System.Data.SqlDbType.Int,4,iD)
								   };
			return NonQueryBool("c_CircleMember_DeleteByID",prams);
		}
		public bool Update_c_CircleMemberInfo(c_CircleMemberInfo _c_CircleMemberInfo)
		{
			SqlParameter[] prams = {
									   SqlHelper.MakeInParam("@ID",System.Data.SqlDbType.Int,4,_c_CircleMemberInfo.ID),
									   SqlHelper.MakeInParam("@CircleRegisterID",System.Data.SqlDbType.Int,4,_c_CircleMemberInfo.CircleRegisterID),
									   SqlHelper.MakeInParam("@CircleIdentity",System.Data.SqlDbType.Int,4,_c_CircleMemberInfo.CircleIdentity),
									   SqlHelper.MakeInParam("@CircleID",System.Data.SqlDbType.Int,4,_c_CircleMemberInfo.CircleID),
									   SqlHelper.MakeInParam("@LastTime",System.Data.SqlDbType.DateTime,8,_c_CircleMemberInfo.LastTime)
								   };
			return NonQueryBool("c_CircleMember_Update",prams);
		}
		public bool Create_c_CircleMemberInfo(c_CircleMemberInfo _c_CircleMemberInfo)
		{
			SqlParameter[] prams = {
									   SqlHelper.MakeInParam("@CircleRegisterID",System.Data.SqlDbType.Int,4,_c_CircleMemberInfo.CircleRegisterID),
									   SqlHelper.MakeInParam("@CircleIdentity",System.Data.SqlDbType.Int,4,_c_CircleMemberInfo.CircleIdentity),
									   SqlHelper.MakeInParam("@CircleID",System.Data.SqlDbType.Int,4,_c_CircleMemberInfo.CircleID),
									   SqlHelper.MakeInParam("@LastTime",System.Data.SqlDbType.DateTime,8,_c_CircleMemberInfo.LastTime)
								   };
			return NonQueryBool("c_CircleMember_Create",prams);
		}
		#endregion

		
		#region c_CommentInfo

		public IDataReader Select_c_CommentByID(Int32 iD)
		{
			SqlParameter[] prams = {
									   SqlHelper.MakeInParam("@ID",System.Data.SqlDbType.Int,4,iD)
								   };
			return GetReader("c_Comment_SelectInfoByID",prams);
		}
		public bool Delete_c_CommentByID(Int32 iD)
		{
			SqlParameter[] prams = {
									   SqlHelper.MakeInParam("@ID",System.Data.SqlDbType.Int,4,iD)
								   };
			return NonQueryBool("c_Comment_DeleteByID",prams);
		}
		public bool Update_c_CommentInfo(c_CommentInfo _c_CommentInfo)
		{
			SqlParameter[] prams = {
									   SqlHelper.MakeInParam("@ID",System.Data.SqlDbType.Int,4,_c_CommentInfo.ID),
									   SqlHelper.MakeInParam("@Content",System.Data.SqlDbType.VarChar,1000,_c_CommentInfo.Content),
									   SqlHelper.MakeInParam("@RestoreConten",System.Data.SqlDbType.VarChar,1000,_c_CommentInfo.RestoreConten),
									   SqlHelper.MakeInParam("@CommentRegisterID",System.Data.SqlDbType.Int,4,_c_CommentInfo.CommentRegisterID),
									   SqlHelper.MakeInParam("@RegisterID",System.Data.SqlDbType.Int,4,_c_CommentInfo.RegisterID),
									   SqlHelper.MakeInParam("@SortType",System.Data.SqlDbType.Int,4,_c_CommentInfo.SortType),
									   SqlHelper.MakeInParam("@ItemID",System.Data.SqlDbType.Int,4,_c_CommentInfo.ItemID)
								   };
			return NonQueryBool("c_Comment_Update",prams);
		}
		public bool Create_c_CommentInfo(c_CommentInfo _c_CommentInfo)
		{
			SqlParameter[] prams = {
									   SqlHelper.MakeInParam("@Content",System.Data.SqlDbType.VarChar,1000,_c_CommentInfo.Content),
									   SqlHelper.MakeInParam("@RestoreConten",System.Data.SqlDbType.VarChar,1000,_c_CommentInfo.RestoreConten),
									   SqlHelper.MakeInParam("@CommentRegisterID",System.Data.SqlDbType.Int,4,_c_CommentInfo.CommentRegisterID),
									   SqlHelper.MakeInParam("@RegisterID",System.Data.SqlDbType.Int,4,_c_CommentInfo.RegisterID),
									   SqlHelper.MakeInParam("@SortType",System.Data.SqlDbType.Int,4,_c_CommentInfo.SortType),
									   SqlHelper.MakeInParam("@ItemID",System.Data.SqlDbType.Int,4,_c_CommentInfo.ItemID)
								   };
			return NonQueryBool("c_Comment_Create",prams);
		}

		#endregion

		
		#region c_CountInfo

		public IDataReader Select_c_CountByID(Int32 iD)
		{
			SqlParameter[] prams = {
									   SqlHelper.MakeInParam("@ID",System.Data.SqlDbType.Int,4,iD)
								   };
			return GetReader("c_Count_SelectInfoByID",prams);
		}
		public bool Delete_c_CountByID(Int32 iD)
		{
			SqlParameter[] prams = {
									   SqlHelper.MakeInParam("@ID",System.Data.SqlDbType.Int,4,iD)
								   };
			return NonQueryBool("c_Count_DeleteByID",prams);
		}
		public bool Update_c_CountInfo(c_CountInfo _c_CountInfo)
		{
			SqlParameter[] prams = {
									   SqlHelper.MakeInParam("@ID",System.Data.SqlDbType.Int,4,_c_CountInfo.ID),
									   SqlHelper.MakeInParam("@ItemID",System.Data.SqlDbType.VarChar,50,_c_CountInfo.ItemID),
									   SqlHelper.MakeInParam("@Hits",System.Data.SqlDbType.Int,4,_c_CountInfo.Hits),
									   SqlHelper.MakeInParam("@SortType",System.Data.SqlDbType.Int,4,_c_CountInfo.SortType)
								   };
			return NonQueryBool("c_Count_Update",prams);
		}
		public bool Create_c_CountInfo(c_CountInfo _c_CountInfo)
		{
			SqlParameter[] prams = {
									   SqlHelper.MakeInParam("@ItemID",System.Data.SqlDbType.VarChar,50,_c_CountInfo.ItemID),
									   SqlHelper.MakeInParam("@Hits",System.Data.SqlDbType.Int,4,_c_CountInfo.Hits),
									   SqlHelper.MakeInParam("@SortType",System.Data.SqlDbType.Int,4,_c_CountInfo.SortType)
								   };
			return NonQueryBool("c_Count_Create",prams);
		}
		#endregion

		
		#region c_DiaryInfo

		public IDataReader Select_c_DiaryByID(Int32 iD)
		{
			SqlParameter[] prams = {
									   SqlHelper.MakeInParam("@ID",System.Data.SqlDbType.Int,4,iD)
								   };
			return GetReader("c_Diary_SelectInfoByID",prams);
		}
		public bool Delete_c_DiaryByID(Int32 iD)
		{
			SqlParameter[] prams = {
									   SqlHelper.MakeInParam("@ID",System.Data.SqlDbType.Int,4,iD)
								   };
			return NonQueryBool("c_Diary_DeleteByID",prams);
		}
		public bool Update_c_DiaryInfo(c_DiaryInfo _c_DiaryInfo)
		{
			SqlParameter[] prams = {
									   SqlHelper.MakeInParam("@ID",System.Data.SqlDbType.Int,4,_c_DiaryInfo.ID),
									   SqlHelper.MakeInParam("@RegisterID",System.Data.SqlDbType.Int,4,_c_DiaryInfo.RegisterID),
									   SqlHelper.MakeInParam("@Title",System.Data.SqlDbType.VarChar,255,_c_DiaryInfo.Title),
									   SqlHelper.MakeInParam("@Content",System.Data.SqlDbType.NText,0,_c_DiaryInfo.Content),
									   SqlHelper.MakeInParam("@Weather",System.Data.SqlDbType.VarChar,50,_c_DiaryInfo.Weather),
									   SqlHelper.MakeInParam("@Mood",System.Data.SqlDbType.VarChar,50,_c_DiaryInfo.Mood),
									   SqlHelper.MakeInParam("@PostDate",System.Data.SqlDbType.DateTime,8,_c_DiaryInfo.PostDate),
									   SqlHelper.MakeInParam("@IsVisible",System.Data.SqlDbType.Bit,1,_c_DiaryInfo.IsVisible),
									   SqlHelper.MakeInParam("@CommentCount",System.Data.SqlDbType.Int,4,_c_DiaryInfo.CommentCount)
								   };
			return NonQueryBool("c_Diary_Update",prams);
		}
		public bool Create_c_DiaryInfo(c_DiaryInfo _c_DiaryInfo)
		{
			SqlParameter[] prams = {
									   SqlHelper.MakeInParam("@RegisterID",System.Data.SqlDbType.Int,4,_c_DiaryInfo.RegisterID),
									   SqlHelper.MakeInParam("@Title",System.Data.SqlDbType.VarChar,255,_c_DiaryInfo.Title),
									   SqlHelper.MakeInParam("@Content",System.Data.SqlDbType.NText,0,_c_DiaryInfo.Content),
									   SqlHelper.MakeInParam("@Weather",System.Data.SqlDbType.VarChar,50,_c_DiaryInfo.Weather),
									   SqlHelper.MakeInParam("@Mood",System.Data.SqlDbType.VarChar,50,_c_DiaryInfo.Mood),
									   SqlHelper.MakeInParam("@PostDate",System.Data.SqlDbType.DateTime,8,_c_DiaryInfo.PostDate),
									   SqlHelper.MakeInParam("@IsVisible",System.Data.SqlDbType.Bit,1,_c_DiaryInfo.IsVisible),
									   SqlHelper.MakeInParam("@CommentCount",System.Data.SqlDbType.Int,4,_c_DiaryInfo.CommentCount)
								   };
			return NonQueryBool("c_Diary_Create",prams);
		}
		public bool Visible_c_Diary(int id)
		{
			SqlParameter[] prams = {
									   SqlHelper.MakeInParam("@Id",System.Data.SqlDbType.Int,4,id)
								   };
			return NonQueryBool("c_Diary_Visible",prams);
		}
		#endregion

		
		#region c_FavoriteInfo

		public IDataReader Select_c_FavoriteByID(Int32 iD)
		{
			SqlParameter[] prams = {
									   SqlHelper.MakeInParam("@ID",System.Data.SqlDbType.Int,4,iD)
								   };
			return GetReader("c_Favorite_SelectInfoByID",prams);
		}
		public bool Delete_c_FavoriteByID(Int32 iD)
		{
			SqlParameter[] prams = {
									   SqlHelper.MakeInParam("@ID",System.Data.SqlDbType.Int,4,iD)
								   };
			return NonQueryBool("c_Favorite_DeleteByID",prams);
		}
		public bool Update_c_FavoriteInfo(c_FavoriteInfo _c_FavoriteInfo)
		{
			SqlParameter[] prams = {
									   SqlHelper.MakeInParam("@ID",System.Data.SqlDbType.Int,4,_c_FavoriteInfo.ID),
									   SqlHelper.MakeInParam("@Url",System.Data.SqlDbType.VarChar,225,_c_FavoriteInfo.Url),
									   SqlHelper.MakeInParam("@Title",System.Data.SqlDbType.VarChar,50,_c_FavoriteInfo.Title),
									   SqlHelper.MakeInParam("@Explain",System.Data.SqlDbType.VarChar,500,_c_FavoriteInfo.Explain),
									   SqlHelper.MakeInParam("@SortID",System.Data.SqlDbType.Int,4,_c_FavoriteInfo.SortID),
									   SqlHelper.MakeInParam("@RegisterID",System.Data.SqlDbType.Int,4,_c_FavoriteInfo.RegisterID)
								   };
			return NonQueryBool("c_Favorite_Update",prams);
		}
		public bool Create_c_FavoriteInfo(c_FavoriteInfo _c_FavoriteInfo)
		{
			SqlParameter[] prams = {
									   SqlHelper.MakeInParam("@Url",System.Data.SqlDbType.VarChar,225,_c_FavoriteInfo.Url),
									   SqlHelper.MakeInParam("@Title",System.Data.SqlDbType.VarChar,50,_c_FavoriteInfo.Title),
									   SqlHelper.MakeInParam("@Explain",System.Data.SqlDbType.VarChar,500,_c_FavoriteInfo.Explain),
									   SqlHelper.MakeInParam("@SortID",System.Data.SqlDbType.Int,4,_c_FavoriteInfo.SortID),
									   SqlHelper.MakeInParam("@RegisterID",System.Data.SqlDbType.Int,4,_c_FavoriteInfo.RegisterID)
								   };
			return NonQueryBool("c_Favorite_Create",prams);
		}
		#endregion

		
		#region c_FriendInfo

		public IDataReader Select_c_FriendByID(Int32 iD)
		{
			SqlParameter[] prams = {
									   SqlHelper.MakeInParam("@ID",System.Data.SqlDbType.Int,4,iD)
								   };
			return GetReader("c_Friend_SelectInfoByID",prams);
		}
		public bool Delete_c_FriendByID(Int32 iD)
		{
			SqlParameter[] prams = {
									   SqlHelper.MakeInParam("@ID",System.Data.SqlDbType.Int,4,iD)
								   };
			return NonQueryBool("c_Friend_DeleteByID",prams);
		}
		public bool Update_c_FriendInfo(c_FriendInfo _c_FriendInfo)
		{
			SqlParameter[] prams = {
									   SqlHelper.MakeInParam("@ID",System.Data.SqlDbType.Int,4,_c_FriendInfo.ID),