idtoprovider.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.Collections;
using Club.Framework.Components;
using System.Data;
using System.Data.SqlClient;
namespace Club.Framework.Data
{
	/// <summary>
	/// Summary description for IDTOProvider.
	/// </summary>
	public interface IDTOProvider
	{
		
		#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);
		 c_AddressListInfo Select_c_AddressListByID(Int32 iD);
		DataSet Select_c_AddressListByPage(int pageSize,int pageIndex,string strWhere,out int rowCount);
		#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);
		 c_CircleInfo 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);
		 c_CircleActionInfo 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);
		
		 c_CircleActionJoinerInfo Select_c_CircleActionJoinerByID(Int32 iD);
		#endregion
		
		#region c_CircleGuestBookInfo

		 c_CircleGuestBookInfo 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
		 c_CircleMemberInfo 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

		 c_CommentInfo 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

		 c_CountInfo 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


		 c_DiaryInfo 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);
		DataSet Select_c_DiaryByPage(int pageSize,int pageIndex,string strWhere,out int rowCount);
		bool Visible_c_Diary(int id);
			#endregion

		
		#region c_FavoriteInfo

		 c_FavoriteInfo 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);
		DataSet Select_c_FavoriteByPage(int pageSize,int pageIndex,string strWhere,out int rowCount);
		#endregion

		
		#region c_FriendInfo

		 c_FriendInfo 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


		 c_HomeSettingInfo Select_c_HomeSettingByRegisterID(Int32 registerID);
		 bool Delete_c_HomeSettingByRegisterID(Int32 registerID);
		 c_HomeSettingInfo 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

		 c_MemoInfo 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);
		DataSet Select_c_MemoByPage(int pageSize,int pageIndex,string strWhere,out int rowCount);
		bool Remind_c_Memo(int id);
		c_MemoInfo Check_c_Memo();
			#endregion

		
		#region c_MessageInfo

		 c_MessageInfo 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

		 c_OnlineUserInfo 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);
		DataSet Select_c_OnlineByPage(int pageSize,int pageIndex,string strWhere,out int rowCount);
		int CountOnline();
		#endregion

		
		#region c_SortInfo

		 c_SortInfo 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);
		 c_SortCollection Select_c_SortByRegsiterIDAndSortType(Int32 regsiterID,Int32 sortType);
		 bool Move_c_Sort(int id,int orderId,int eId,int eOrderId);
		c_SortCollection Select_c_SortByRegsiterIDAndSortTypeAndIsVisible(Int32 regsiterID,Int32 sortType,Boolean isVisible);
		bool Visible_c_Sort(int id);
		#endregion

		
		#region c_UserInfo
		bool EditPassword(int registerID,string oldPassword,string newPassword);
		int Login(string username,string password,string ip,out int degreeID,out int registerID);
		c_UserInfo 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);
		c_UserInfo 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);
		 c_UserDataInfo Select_c_UserDataByID(Int32 iD);
		 bool Update_c_UserDataInfo(c_UserDataInfo _c_UserDataInfo);
		 bool Create_c_UserDataInfo(c_UserDataInfo _c_UserDataInfo);
		 c_UserDataInfo Select_c_UserDataByRegisterID(Int32 registerID);
		#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);
		c_ArticleInfo Select_c_ArticleByID(Int32 iD);
		DataSet Select_c_ArticleByPage(int pageSize,int pageIndex,string strWhere,out int rowCount);
		#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);
		c_PhotoInfo Select_c_PhotoByID(Int32 iD);
		DataSet Select_c_PhotoByPage(int pageSize,int pageIndex,string strWhere,out int rowCount);
		#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);
		c_MusicInfo Select_c_MusicByID(Int32 iD);
		DataSet Select_c_MusicByPage(int pageSize,int pageIndex,string strWhere,out int rowCount);
		#endregion

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

		#region c_GuestBookInfo
		bool Create_c_GuestBookInfo(c_GuestBookInfo _c_GuestBookInfo);
		bool Update_c_GuestBookInfo(c_GuestBookInfo _c_GuestBookInfo);
		c_GuestBookInfo Select_c_GuestBookByID(Int32 iD);
		bool Delete_c_GuestBookByID(Int32 iD);
		#endregion

		#region Helpers
		DataSet GetDataSet(string sql, SqlParameter[] p);
		DataSet GetDataSet(string sql);
		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
	}
}