datadtoprovider.cs

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

			return DbProvider.Instance().Create_c_MemoInfo(_c_MemoInfo);
		}
		public DataSet Select_c_MemoByPage(int pageSize,int pageIndex,string strWhere,out int rowCount)
		{
			return this.SelectPageByDataSet("c_Memo","*","RemindDate",pageSize,pageIndex,true,true,strWhere,out rowCount);
		}
		public bool Remind_c_Memo(int id)
		{
			return DbProvider.Instance().Remind_c_Memo(id);
		}
		public c_MemoInfo Check_c_Memo()
		{
			IDataReader reader=DbProvider.Instance().Check_c_Memo();
			c_MemoInfo _c_MemoInfo=null;
			while(reader.Read())
			{
				_c_MemoInfo=DataHelper.Init_c_MemoInfo(reader);
				break;
			}
			reader.Close();
			return _c_MemoInfo;
		}
		#endregion

		
		#region c_MessageInfo

		public c_MessageInfo Select_c_MessageByID(Int32 iD)
		{
			IDataReader reader=DbProvider.Instance().Select_c_MessageByID(iD);
			c_MessageInfo _c_MessageInfo=null;
			while(reader.Read())
			{
				_c_MessageInfo=DataHelper.Init_c_MessageInfo(reader);
				break;
			}
			reader.Close();
			return _c_MessageInfo;
		}
		public bool Delete_c_MessageByID(Int32 iD)
		{
			return DbProvider.Instance().Delete_c_MessageByID(iD);
		}
		public bool Update_c_MessageInfo(c_MessageInfo _c_MessageInfo)
		{
			return DbProvider.Instance().Update_c_MessageInfo(_c_MessageInfo);
		}

		public bool Create_c_MessageInfo(c_MessageInfo _c_MessageInfo)
		{
			return DbProvider.Instance().Create_c_MessageInfo(_c_MessageInfo);
		}
		#endregion

		
		#region c_OnlineUserInfo

		public c_OnlineUserInfo Select_c_OnlineUserByID(Int32 iD)
		{
			IDataReader reader=DbProvider.Instance().Select_c_OnlineUserByID(iD);
			c_OnlineUserInfo _c_OnlineUserInfo=null;
			while(reader.Read())
			{
				_c_OnlineUserInfo=DataHelper.Init_c_OnlineUserInfo(reader);
				break;
			}
			reader.Close();
			return _c_OnlineUserInfo;
		}
		public bool Delete_c_OnlineUserByID(Int32 iD)
		{
			return DbProvider.Instance().Delete_c_OnlineUserByID(iD);
		}
		public bool Update_c_OnlineUserInfo(c_OnlineUserInfo _c_OnlineUserInfo)
		{
			return DbProvider.Instance().Update_c_OnlineUserInfo(_c_OnlineUserInfo);
		}
		public bool Create_c_OnlineUserInfo(c_OnlineUserInfo _c_OnlineUserInfo)
		{
			return DbProvider.Instance().Create_c_OnlineUserInfo(_c_OnlineUserInfo);
		}
		public bool Delete_c_OnlineUserByOnlineRegisterID(Int32 onlineRegisterID)
		{
			return DbProvider.Instance().Delete_c_OnlineUserByOnlineRegisterID(onlineRegisterID);
		}
		public int CountOnline()
		{
			return DbProvider.Instance().CountOnline();
		}
		public DataSet Select_c_OnlineByPage(int pageSize,int pageIndex,string strWhere,out int rowCount)
		{
			return this.SelectPageByDataSet("c_OnlineUser","[ID],[OnlineRegisterID],[IsHidden],[LoginTime],[IP],(Select UserName from c_User where Id=OnlineRegisterID) as UserName","Id",pageSize,pageIndex,true,true,strWhere,out rowCount);
		}
		#endregion

		
		#region c_SortInfo

		public c_SortInfo Select_c_SortByID(Int32 iD)
		{
			IDataReader reader=DbProvider.Instance().Select_c_SortByID(iD);
			c_SortInfo _c_SortInfo=null;
			while(reader.Read())
			{
				_c_SortInfo=DataHelper.Init_c_SortInfo(reader);
				break;
			}
			reader.Close();
			return _c_SortInfo;
		}
		public bool Delete_c_SortByID(Int32 iD)
		{
			return DbProvider.Instance().Delete_c_SortByID(iD);
		}
		public bool Update_c_SortInfo(c_SortInfo _c_SortInfo)
		{
			return DbProvider.Instance().Update_c_SortInfo(_c_SortInfo);
		}
		public bool Create_c_SortInfo(c_SortInfo _c_SortInfo)
		{
			return DbProvider.Instance().Create_c_SortInfo(_c_SortInfo);
		}
		public c_SortCollection Select_c_SortByRegsiterIDAndSortType(Int32 regsiterID,Int32 sortType)
		{
			IDataReader reader=DbProvider.Instance().Select_c_SortByRegsiterIDAndSortType(regsiterID,sortType);
			c_SortCollection _c_SortCollection=new c_SortCollection();
			while(reader.Read())
			{
				c_SortInfo _c_SortInfo=DataHelper.Init_c_SortInfo(reader);
				_c_SortCollection.Add(_c_SortInfo);
			}
			reader.Close();
			return _c_SortCollection;
		}
		public bool Move_c_Sort(int id,int orderId,int eId,int eOrderId)
		{
			return DbProvider.Instance().Move_c_Sort(id,orderId,eId,eOrderId);
		}
		public bool Visible_c_Sort(int id)
		{
			return DbProvider.Instance().Visible_c_Sort(id);
		}
		public c_SortCollection Select_c_SortByRegsiterIDAndSortTypeAndIsVisible(Int32 regsiterID,Int32 sortType,Boolean isVisible)
		{
			IDataReader reader=DbProvider.Instance().Select_c_SortByRegsiterIDAndSortTypeAndIsVisible(regsiterID,sortType,isVisible);
			c_SortCollection _c_SortCollection=new c_SortCollection();
			while(reader.Read())
			{
				c_SortInfo _c_SortInfo=DataHelper.Init_c_SortInfo(reader);
				_c_SortCollection.Add(_c_SortInfo);
			}
			reader.Close();
			return _c_SortCollection;
		}
		#endregion

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

		
		#region c_UserDataInfo


		public bool Delete_c_UserDataByRegisterID(Int32 registerID)
		{
			return DbProvider.Instance().Delete_c_UserDataByRegisterID(registerID);
		}
		public c_UserDataInfo Select_c_UserDataByID(Int32 iD)
		{
			IDataReader reader=DbProvider.Instance().Select_c_UserDataByID(iD);
			c_UserDataInfo _c_UserDataInfo=null;
			while(reader.Read())
			{
				_c_UserDataInfo=DataHelper.Init_c_UserDataInfo(reader);
				break;
			}
			reader.Close();
			return _c_UserDataInfo;
		}
		public bool Update_c_UserDataInfo(c_UserDataInfo _c_UserDataInfo)
		{
			return DbProvider.Instance().Update_c_UserDataInfo(_c_UserDataInfo);
		}
		public bool Create_c_UserDataInfo(c_UserDataInfo _c_UserDataInfo)
		{
			return DbProvider.Instance().Create_c_UserDataInfo(_c_UserDataInfo);
		}
		public c_UserDataInfo Select_c_UserDataByRegisterID(Int32 registerID)
		{
			IDataReader reader=DbProvider.Instance().Select_c_UserDataByRegisterID(registerID);
			c_UserDataInfo _c_UserDataInfo=null;
			while(reader.Read())
			{
				_c_UserDataInfo=DataHelper.Init_c_UserDataInfo(reader);
				break;
			}
			reader.Close();
			return _c_UserDataInfo;
		}
		#endregion

		#region c_ArticleInfo

		public bool Create_c_ArticleInfo(c_ArticleInfo _c_ArticleInfo)
		{
			return DbProvider.Instance().Create_c_ArticleInfo(_c_ArticleInfo);
		}
		public bool Update_c_ArticleInfo(c_ArticleInfo _c_ArticleInfo)
		{
			return DbProvider.Instance().Update_c_ArticleInfo(_c_ArticleInfo);
		}
		public bool Delete_c_ArticleByID(Int32 iD)
		{
			return DbProvider.Instance().Delete_c_ArticleByID(iD);
		}
		public c_ArticleInfo Select_c_ArticleByID(Int32 iD)
		{
			IDataReader reader=DbProvider.Instance().Select_c_ArticleByID(iD);
			c_ArticleInfo _c_ArticleInfo=null;
			while(reader.Read())
			{
				_c_ArticleInfo=DataHelper.Init_c_ArticleInfo(reader);
				break;
			}
			reader.Close();
			return _c_ArticleInfo;
		}
		public DataSet Select_c_ArticleByPage(int pageSize,int pageIndex,string strWhere,out int rowCount)
		{
			return this.SelectPageByDataSet("c_Article","*","PostDate",pageSize,pageIndex,true,true,strWhere,out rowCount);
		}
		#endregion

		#region c_PhotoInfo

		public bool Create_c_PhotoInfo(c_PhotoInfo _c_PhotoInfo)
		{
			return DbProvider.Instance().Create_c_PhotoInfo(_c_PhotoInfo);
		}
		public bool Update_c_PhotoInfo(c_PhotoInfo _c_PhotoInfo)
		{
			return DbProvider.Instance().Update_c_PhotoInfo(_c_PhotoInfo);
		}
		public bool Delete_c_PhotoByID(Int32 iD)
		{
			return DbProvider.Instance().Delete_c_PhotoByID(iD);
		}
		public c_PhotoInfo Select_c_PhotoByID(Int32 iD)
		{
			IDataReader reader=DbProvider.Instance().Select_c_PhotoByID(iD);
			c_PhotoInfo _c_PhotoInfo=null;
			while(reader.Read())
			{
				_c_PhotoInfo=DataHelper.Init_c_PhotoInfo(reader);
				break;
			}
			reader.Close();
			return _c_PhotoInfo;
		}
		public DataSet Select_c_PhotoByPage(int pageSize,int pageIndex,string strWhere,out int rowCount)
		{
			return this.SelectPageByDataSet("c_Photo","*","OrderId",pageSize,pageIndex,true,true,strWhere,out rowCount);
		}
		#endregion

		#region c_MusicInfo
		public bool Create_c_MusicInfo(c_MusicInfo _c_MusicInfo)
		{
			return DbProvider.Instance().Create_c_MusicInfo(_c_MusicInfo);
		}
		public bool Update_c_MusicInfo(c_MusicInfo _c_MusicInfo)
		{
			return DbProvider.Instance().Update_c_MusicInfo(_c_MusicInfo);
		}
		public bool Delete_c_MusicByID(Int32 iD)
		{
			return DbProvider.Instance().Delete_c_MusicByID(iD);
		}
		public c_MusicInfo Select_c_MusicByID(Int32 iD)
		{
			IDataReader reader=DbProvider.Instance().Select_c_MusicByID(iD);
			c_MusicInfo _c_MusicInfo=null;
			while(reader.Read())
			{
				_c_MusicInfo=DataHelper.Init_c_MusicInfo(reader);
				break;
			}
			reader.Close();
			return _c_MusicInfo;
		}
		public DataSet Select_c_MusicByPage(int pageSize,int pageIndex,string strWhere,out int rowCount)
		{
			return this.SelectPageByDataSet("c_Music","*","OrderId",pageSize,pageIndex,true,true,strWhere,out rowCount);
		}
		#endregion

		#region c_UserDataCountInfo
		public c_UserDataCountInfo GetUserCountInfo(Int32 registerID)
		{
			IDataReader reader=DbProvider.Instance().GetUserCountInfo(registerID);
			c_UserDataCountInfo _c_UserDataCountInfo=null;
			while(reader.Read())
			{
				_c_UserDataCountInfo=DataHelper.Init_c_UserDataCountInfo(reader);
				break;
			}
			reader.Close();
			return _c_UserDataCountInfo;
		}
		#endregion

		#region c_GuestBookInfo


		public bool Create_c_GuestBookInfo(c_GuestBookInfo _c_GuestBookInfo)
		{
			return DbProvider.Instance().Create_c_GuestBookInfo(_c_GuestBookInfo);
		}
		public bool Update_c_GuestBookInfo(c_GuestBookInfo _c_GuestBookInfo)
		{
			return DbProvider.Instance().Update_c_GuestBookInfo(_c_GuestBookInfo);
		}
		public c_GuestBookInfo Select_c_GuestBookByID(Int32 iD)
		{
			IDataReader reader=DbProvider.Instance().Select_c_GuestBookByID(iD);
			c_GuestBookInfo _c_GuestBookInfo=null;
			while(reader.Read())
			{
				_c_GuestBookInfo=DataHelper.Init_c_GuestBookInfo(reader);
				break;
			}
			reader.Close();
			return _c_GuestBookInfo;
		}
		public bool Delete_c_GuestBookByID(Int32 iD)
		{
			return DbProvider.Instance().Delete_c_GuestBookByID(iD);
		}
		#endregion

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