idbprovider.cs

来自「1、用SQL查询器打开install目录下的dooogo.sql运行之后创建数据」· CS 代码 · 共 265 行

//Copyright (C) 2006 dooogo.com
//Author：benben
//www.aspxclub.com
using System;
using System.Data;
using Club.Framework.Components;
using Club.Framework.Configuration;
using System.Data.SqlClient;

namespace Club.Framework.Data
{
	/// <summary>
	/// Summary description for IBlogDataProvider.
	/// </summary>
	public interface IDbProvider
	{

		string ConnectionString
		{
			get;
			set;
		}
		#region c_AddressListInfo

		bool Create_c_AddressListInfo(c_AddressListInfo _c_AddressListInfo);
		bool Update_c_AddressListInfo(c_AddressListInfo _c_AddressListInfo);
		bool Delete_c_AddressListByID(Int32 iD);
		IDataReader Select_c_AddressListByID(Int32 iD);
		#endregion

		
		#region c_CircleInfo

		bool Create_c_CircleInfo(c_CircleInfo _c_CircleInfo);
		bool Update_c_CircleInfo(c_CircleInfo _c_CircleInfo);
		bool Delete_c_CircleByID(Int32 iD);
		
		IDataReader Select_c_CircleByID(Int32 iD);
		#endregion

		
		#region c_CircleActionInfo

		bool Create_c_CircleActionInfo(c_CircleActionInfo _c_CircleActionInfo);
		

		bool Update_c_CircleActionInfo(c_CircleActionInfo _c_CircleActionInfo);
		bool Delete_c_CircleActionByID(Int32 iD);
		IDataReader Select_c_CircleActionByID(Int32 iD);
		#endregion

		
		#region c_CircleActionJoinerInfo

		bool Create_c_CircleActionJoinerInfo(c_CircleActionJoinerInfo _c_CircleActionJoinerInfo);
		bool Update_c_CircleActionJoinerInfo(c_CircleActionJoinerInfo _c_CircleActionJoinerInfo);
		bool Delete_c_CircleActionJoinerByID(Int32 iD);
		IDataReader Select_c_CircleActionJoinerByID(Int32 iD);
		#endregion
		
		#region c_CircleGuestBookInfo

		IDataReader Select_c_CircleGuestBookByID(Int32 iD);
		bool Delete_c_CircleGuestBookByID(Int32 iD);
		bool Update_c_CircleGuestBookInfo(c_CircleGuestBookInfo _c_CircleGuestBookInfo);
		bool Create_c_CircleGuestBookInfo(c_CircleGuestBookInfo _c_CircleGuestBookInfo);
		#endregion
		
		#region c_CircleMemberInfo

		IDataReader Select_c_CircleMemberByID(Int32 iD);
		bool Delete_c_CircleMemberByID(Int32 iD);
		bool Update_c_CircleMemberInfo(c_CircleMemberInfo _c_CircleMemberInfo);
		bool Create_c_CircleMemberInfo(c_CircleMemberInfo _c_CircleMemberInfo);
		#endregion

		
		#region c_CommentInfo

		IDataReader Select_c_CommentByID(Int32 iD);
		bool Delete_c_CommentByID(Int32 iD);
		bool Update_c_CommentInfo(c_CommentInfo _c_CommentInfo);
		bool Create_c_CommentInfo(c_CommentInfo _c_CommentInfo);

		#endregion

		
		#region c_CountInfo

		IDataReader Select_c_CountByID(Int32 iD);
		bool Delete_c_CountByID(Int32 iD);
		bool Update_c_CountInfo(c_CountInfo _c_CountInfo);
		bool Create_c_CountInfo(c_CountInfo _c_CountInfo);
		#endregion

		
		#region c_DiaryInfo

		IDataReader Select_c_DiaryByID(Int32 iD);
		bool Delete_c_DiaryByID(Int32 iD);
		bool Update_c_DiaryInfo(c_DiaryInfo _c_DiaryInfo);
		bool Create_c_DiaryInfo(c_DiaryInfo _c_DiaryInfo);
		bool Visible_c_Diary(int id);
		#endregion

		
		#region c_FavoriteInfo

		IDataReader Select_c_FavoriteByID(Int32 iD);
		bool Delete_c_FavoriteByID(Int32 iD);
		bool Update_c_FavoriteInfo(c_FavoriteInfo _c_FavoriteInfo);
		bool Create_c_FavoriteInfo(c_FavoriteInfo _c_FavoriteInfo);
		#endregion

		
		#region c_FriendInfo

		IDataReader Select_c_FriendByID(Int32 iD);
		bool Delete_c_FriendByID(Int32 iD);
		bool Update_c_FriendInfo(c_FriendInfo _c_FriendInfo);
		bool Create_c_FriendInfo(c_FriendInfo _c_FriendInfo);
		#endregion

		
		#region c_HomeSettingInfo

		IDataReader Select_c_HomeSettingByRegisterID(Int32 registerID);
		
		bool Delete_c_HomeSettingByRegisterID(Int32 registerID);
		IDataReader Select_c_HomeSettingByID(Int32 iD);
		bool Delete_c_HomeSettingByID(Int32 iD);

		bool Update_c_HomeSettingInfo(c_HomeSettingInfo _c_HomeSettingInfo);
		bool Create_c_HomeSettingInfo(c_HomeSettingInfo _c_HomeSettingInfo);
		#endregion

		
		#region c_MemoInfo

		IDataReader Select_c_MemoByID(Int32 iD);
		bool Delete_c_MemoByID(Int32 iD);
		bool Update_c_MemoInfo(c_MemoInfo _c_MemoInfo);
		bool Create_c_MemoInfo(c_MemoInfo _c_MemoInfo);
		bool Remind_c_Memo(int id);
		IDataReader Check_c_Memo();
			#endregion

		
		#region c_MessageInfo

		IDataReader Select_c_MessageByID(Int32 iD);
		bool Delete_c_MessageByID(Int32 iD);
		bool Update_c_MessageInfo(c_MessageInfo _c_MessageInfo);
		bool Create_c_MessageInfo(c_MessageInfo _c_MessageInfo);
		#endregion

		
		#region c_OnlineUserInfo

		IDataReader Select_c_OnlineUserByID(Int32 iD);
		bool Delete_c_OnlineUserByID(Int32 iD);
		bool Update_c_OnlineUserInfo(c_OnlineUserInfo _c_OnlineUserInfo);
		bool Create_c_OnlineUserInfo(c_OnlineUserInfo _c_OnlineUserInfo);
		bool Delete_c_OnlineUserByOnlineRegisterID(Int32 onlineRegisterID);
		int CountOnline();
		#endregion

		
		#region c_SortInfo

		IDataReader Select_c_SortByID(Int32 iD);
		bool Delete_c_SortByID(Int32 iD);
		bool Update_c_SortInfo(c_SortInfo _c_SortInfo);
		bool Create_c_SortInfo(c_SortInfo _c_SortInfo);
		 bool Move_c_Sort(int id,int orderId,int eId,int eOrderId);
		 IDataReader Select_c_SortByRegsiterIDAndSortType(Int32 regsiterID,Int32 sortType);
		 bool Visible_c_Sort(int id);
		IDataReader Select_c_SortByRegsiterIDAndSortTypeAndIsVisible(Int32 regsiterID,Int32 sortType,Boolean isVisible);
		#endregion

		
		#region c_UserInfo
		bool EditPassword(int registerID,string oldPassword,string newPassword);
		IDataReader Select_c_UserByID(Int32 iD);
		bool Delete_c_UserByID(Int32 iD);
		bool Update_c_UserInfo(c_UserInfo _c_UserInfo);
		bool Create_c_UserInfo(c_UserInfo _c_UserInfo);
		int Login(string username,string password,string ip,out int degreeID,out int registerID);
		IDataReader Select_c_UserByUsername(String username);
			///<summary>
		///按条件检查数据库中是否已经存在相同记录
		///</summary>
		bool IsExistUserByUserName(String username);
		/// <summary>
		///按条件检查数据库中是否已经存在相同记录
		/// </summary>
		/// <param name="email"></param>
		/// <returns></returns>
		bool IsExistUserByEmail(String email);
		#endregion

		
		#region c_UserDataInfo


		bool Delete_c_UserDataByRegisterID(Int32 registerID);
		
		bool Update_c_UserDataInfo(c_UserDataInfo _c_UserDataInfo);
		IDataReader Select_c_UserDataByID(Int32 iD);
		bool Delete_c_UserDataByID(Int32 iD);
		IDataReader Select_c_UserDataByRegisterID(Int32 registerID);
		bool Create_c_UserDataInfo(c_UserDataInfo _c_UserDataInfo);
		#endregion

		#region c_ArticleInfo

		bool Create_c_ArticleInfo(c_ArticleInfo _c_ArticleInfo);
		bool Update_c_ArticleInfo(c_ArticleInfo _c_ArticleInfo);
		bool Delete_c_ArticleByID(Int32 iD);
		IDataReader Select_c_ArticleByID(Int32 iD);
		#endregion

		#region c_PhotoInfo
		bool Create_c_PhotoInfo(c_PhotoInfo _c_PhotoInfo);
		bool Update_c_PhotoInfo(c_PhotoInfo _c_PhotoInfo);
		bool Delete_c_PhotoByID(Int32 iD);
		IDataReader Select_c_PhotoByID(Int32 iD);
		#endregion

		#region c_MusicInfo

		bool Create_c_MusicInfo(c_MusicInfo _c_MusicInfo);
		bool Update_c_MusicInfo(c_MusicInfo _c_MusicInfo);
		bool Delete_c_MusicByID(Int32 iD);
		IDataReader Select_c_MusicByID(Int32 iD);

		#endregion

		#region c_UserDataCountInfo
		IDataReader GetUserCountInfo(Int32 registerID);
		#endregion

		#region c_GuestBookInfo

		bool Create_c_GuestBookInfo(c_GuestBookInfo _c_GuestBookInfo);
		bool Update_c_GuestBookInfo(c_GuestBookInfo _c_GuestBookInfo);
		IDataReader Select_c_GuestBookByID(Int32 iD);
		bool Delete_c_GuestBookByID(Int32 iD);

		#endregion

		#region Helpers
		DataSet GetDataSet(string sql);
		DataSet GetDataSet(string sql, SqlParameter[] p);
		IDataReader GetReader(string sql, SqlParameter[] p);
		IDataReader GetReader(string sql);
		int NonQueryInt(string sql, SqlParameter[] p);
		int NonQueryInt(string sql);
		bool NonQueryBool(string sql, SqlParameter[] p);
		IDataReader SelectPageBySqlDataReader(string tableName,string getFields,string orderField,int pageSize,int pageIndex,bool orderType,string strWhere);
		DataSet SelectPageByDataSet(string tableName,string getFields,string orderField,int pageSize,int pageIndex,bool doCount,bool orderType,string strWhere,out int rowCount);
		#endregion
	}
}