datadtoprovider.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.Reflection;
using System.Collections;
using Club.Framework.Components;
using Club.Framework.Util;
using Club.Framework.Configuration;
using Club.Framework.Providers;
using System.Data.SqlClient;


namespace Club.Framework.Data
{
	/// <summary>
	/// Summary description for DataDTOProvider.
	/// </summary>
	public class DataDTOProvider : Club.Framework.Data.IDTOProvider
	{
		public DataDTOProvider()
		{

		}	

		#region c_AddressListInfo

		public bool Create_c_AddressListInfo(c_AddressListInfo _c_AddressListInfo)
		{
			return DbProvider.Instance().Create_c_AddressListInfo(_c_AddressListInfo);
		}
		
		public bool Update_c_AddressListInfo(c_AddressListInfo _c_AddressListInfo)
		{
			return DbProvider.Instance().Update_c_AddressListInfo(_c_AddressListInfo);
		}
		
		public bool Delete_c_AddressListByID(Int32 iD)
		{
			return DbProvider.Instance().Delete_c_AddressListByID(iD);
		}

		public c_AddressListInfo Select_c_AddressListByID(Int32 iD)
		{
			IDataReader reader=DbProvider.Instance().Select_c_AddressListByID(iD);
			c_AddressListInfo _c_AddressListInfo = null;
			while(reader.Read())
			{
				_c_AddressListInfo=DataHelper.Init_c_AddressListInfo(reader);
				break;
			}
			reader.Close();
			return _c_AddressListInfo;
		}
		public DataSet Select_c_AddressListByPage(int pageSize,int pageIndex,string strWhere,out int rowCount)
		{
			return this.SelectPageByDataSet("c_AddressList","*","Id",pageSize,pageIndex,true,true,strWhere,out rowCount);
		}
		#endregion

		
		#region c_CircleInfo

		public bool Create_c_CircleInfo(c_CircleInfo _c_CircleInfo)
		{
			return DbProvider.Instance().Create_c_CircleInfo(_c_CircleInfo);
		}
		
		public bool Update_c_CircleInfo(c_CircleInfo _c_CircleInfo)
		{
			return DbProvider.Instance().Update_c_CircleInfo(_c_CircleInfo);
		}
		
		public bool Delete_c_CircleByID(Int32 iD)
		{
			return DbProvider.Instance().Delete_c_CircleByID(iD);
		}
		
		public c_CircleInfo Select_c_CircleByID(Int32 iD)
		{
			IDataReader reader=DbProvider.Instance().Select_c_CircleByID(iD);
			c_CircleInfo _c_CircleInfo=null;
			while(reader.Read())
			{
				_c_CircleInfo=DataHelper.Init_c_CircleInfo(reader);
				break;
			}
			reader.Close();
			return _c_CircleInfo;
		}
		#endregion

		
		#region c_CircleActionInfo

		public bool Create_c_CircleActionInfo(c_CircleActionInfo _c_CircleActionInfo)
		{
			return DbProvider.Instance().Create_c_CircleActionInfo(_c_CircleActionInfo);
		}
		

		public bool Update_c_CircleActionInfo(c_CircleActionInfo _c_CircleActionInfo)
		{
			return DbProvider.Instance().Update_c_CircleActionInfo(_c_CircleActionInfo);
		}

		public bool Delete_c_CircleActionByID(Int32 iD)
		{
			return DbProvider.Instance().Delete_c_CircleActionByID(iD);
		}
		
		public c_CircleActionInfo Select_c_CircleActionByID(Int32 iD)
		{
			IDataReader reader=DbProvider.Instance().Select_c_CircleActionByID(iD);
			c_CircleActionInfo _c_CircleActionInfo=null;
			while(reader.Read())
			{
				_c_CircleActionInfo=DataHelper.Init_c_CircleActionInfo(reader);
				break;
			}
			reader.Close();
			return _c_CircleActionInfo;
		}
		#endregion

		
		#region c_CircleActionJoinerInfo

		public bool Create_c_CircleActionJoinerInfo(c_CircleActionJoinerInfo _c_CircleActionJoinerInfo)
		{
			return DbProvider.Instance().Create_c_CircleActionJoinerInfo(_c_CircleActionJoinerInfo);
		}

		public bool Update_c_CircleActionJoinerInfo(c_CircleActionJoinerInfo _c_CircleActionJoinerInfo)
		{
			return DbProvider.Instance().Update_c_CircleActionJoinerInfo(_c_CircleActionJoinerInfo);
		}
		
		public bool Delete_c_CircleActionJoinerByID(Int32 iD)
		{
			return DbProvider.Instance().Delete_c_CircleActionJoinerByID(iD);
		}
		
		public c_CircleActionJoinerInfo Select_c_CircleActionJoinerByID(Int32 iD)
		{
			IDataReader reader=DbProvider.Instance().Select_c_CircleActionJoinerByID(iD);
			c_CircleActionJoinerInfo _c_CircleActionJoinerInfo=null;
			while(reader.Read())
			{
				_c_CircleActionJoinerInfo=DataHelper.Init_c_CircleActionJoinerInfo(reader);
				break;
			}
			reader.Close();
			return _c_CircleActionJoinerInfo;
		}
		#endregion
		
		#region c_CircleGuestBookInfo

		public c_CircleGuestBookInfo Select_c_CircleGuestBookByID(Int32 iD)
		{
			IDataReader reader=DbProvider.Instance().Select_c_CircleGuestBookByID(iD);
			c_CircleGuestBookInfo _c_CircleGuestBookInfo=null;
			while(reader.Read())
			{
				_c_CircleGuestBookInfo=DataHelper.Init_c_CircleGuestBookInfo(reader);
				break;
			}
			reader.Close();
			return _c_CircleGuestBookInfo;
		}
		public bool Delete_c_CircleGuestBookByID(Int32 iD)
		{
			return DbProvider.Instance().Delete_c_CircleGuestBookByID(iD);
		}
		public bool Update_c_CircleGuestBookInfo(c_CircleGuestBookInfo _c_CircleGuestBookInfo)
		{
			return DbProvider.Instance().Update_c_CircleGuestBookInfo(_c_CircleGuestBookInfo);
		}
		public bool Create_c_CircleGuestBookInfo(c_CircleGuestBookInfo _c_CircleGuestBookInfo)
		{
			return DbProvider.Instance().Create_c_CircleGuestBookInfo(_c_CircleGuestBookInfo);
		}
		#endregion
		
		#region c_CircleMemberInfo
		public c_CircleMemberInfo Select_c_CircleMemberByID(Int32 iD)
		{
			IDataReader reader=DbProvider.Instance().Select_c_CircleMemberByID(iD);
			c_CircleMemberInfo _c_CircleMemberInfo=null;
			while(reader.Read())
			{
				_c_CircleMemberInfo=DataHelper.Init_c_CircleMemberInfo(reader);
				break;
			}
			reader.Close();
			return _c_CircleMemberInfo;
		}
		public bool Delete_c_CircleMemberByID(Int32 iD)
		{
			return DbProvider.Instance().Delete_c_CircleMemberByID(iD);
		}
		public bool Update_c_CircleMemberInfo(c_CircleMemberInfo _c_CircleMemberInfo)
		{
			return DbProvider.Instance().Update_c_CircleMemberInfo(_c_CircleMemberInfo);
		}
		public bool Create_c_CircleMemberInfo(c_CircleMemberInfo _c_CircleMemberInfo)
		{
			return DbProvider.Instance().Create_c_CircleMemberInfo(_c_CircleMemberInfo);
		}
		#endregion

		
		#region c_CommentInfo

		public c_CommentInfo Select_c_CommentByID(Int32 iD)
		{
			IDataReader reader=DbProvider.Instance().Select_c_CommentByID(iD);
			c_CommentInfo _c_CommentInfo=null;
			while(reader.Read())
			{
				_c_CommentInfo=DataHelper.Init_c_CommentInfo(reader);
				break;
			}
			reader.Close();
			return _c_CommentInfo;
		}
		public bool Delete_c_CommentByID(Int32 iD)
		{
			return DbProvider.Instance().Delete_c_CommentByID(iD);
		}
		public bool Update_c_CommentInfo(c_CommentInfo _c_CommentInfo)
		{
			return DbProvider.Instance().Update_c_CommentInfo(_c_CommentInfo);
		}
		public bool Create_c_CommentInfo(c_CommentInfo _c_CommentInfo)
		{
			return DbProvider.Instance().Create_c_CommentInfo(_c_CommentInfo);
		}

		#endregion

		
		#region c_CountInfo

		public c_CountInfo Select_c_CountByID(Int32 iD)
		{
			IDataReader reader=DbProvider.Instance().Select_c_CountByID(iD);
			c_CountInfo _c_CountInfo=null;
			while(reader.Read())
			{
				_c_CountInfo=DataHelper.Init_c_CountInfo(reader);
				break;
			}
			reader.Close();
			return _c_CountInfo;
		}
		public bool Delete_c_CountByID(Int32 iD)
		{
			return DbProvider.Instance().Delete_c_CountByID(iD);
		}
		public bool Update_c_CountInfo(c_CountInfo _c_CountInfo)
		{
			return DbProvider.Instance().Update_c_CountInfo(_c_CountInfo);
		}
		public bool Create_c_CountInfo(c_CountInfo _c_CountInfo)
		{
			return DbProvider.Instance().Create_c_CountInfo(_c_CountInfo);
		}
		#endregion

		
		#region c_DiaryInfo


		public c_DiaryInfo Select_c_DiaryByID(Int32 iD)
		{
			IDataReader reader=DbProvider.Instance().Select_c_DiaryByID(iD);
			c_DiaryInfo _c_DiaryInfo=null;
			while(reader.Read())
			{
				_c_DiaryInfo=DataHelper.Init_c_DiaryInfo(reader);
				break;
			}
			reader.Close();
			return _c_DiaryInfo;
		}
		public bool Delete_c_DiaryByID(Int32 iD)
		{
			return DbProvider.Instance().Delete_c_DiaryByID(iD);
		}
		public bool Update_c_DiaryInfo(c_DiaryInfo _c_DiaryInfo)
		{
			return DbProvider.Instance().Update_c_DiaryInfo(_c_DiaryInfo);
		}
		public bool Create_c_DiaryInfo(c_DiaryInfo _c_DiaryInfo)
		{
			return DbProvider.Instance().Create_c_DiaryInfo(_c_DiaryInfo);
		}
		public DataSet Select_c_DiaryByPage(int pageSize,int pageIndex,string strWhere,out int rowCount)
		{
			return this.SelectPageByDataSet("c_Diary","*","PostDate",pageSize,pageIndex,true,true,strWhere,out rowCount);
		}
		public bool Visible_c_Diary(int id)
		{
			return DbProvider.Instance().Visible_c_Diary(id);
		}
		#endregion

		
		#region c_FavoriteInfo

		public c_FavoriteInfo Select_c_FavoriteByID(Int32 iD)
		{
			IDataReader reader=DbProvider.Instance().Select_c_FavoriteByID(iD);
			c_FavoriteInfo _c_FavoriteInfo=null;
			while(reader.Read())
			{
				_c_FavoriteInfo=DataHelper.Init_c_FavoriteInfo(reader);
				break;
			}
			reader.Close();
			return _c_FavoriteInfo;
		}
		public bool Delete_c_FavoriteByID(Int32 iD)
		{
			return DbProvider.Instance().Delete_c_FavoriteByID(iD);
		}
		public bool Update_c_FavoriteInfo(c_FavoriteInfo _c_FavoriteInfo)
		{
			return DbProvider.Instance().Update_c_FavoriteInfo(_c_FavoriteInfo);
		}
		public bool Create_c_FavoriteInfo(c_FavoriteInfo _c_FavoriteInfo)
		{
			return DbProvider.Instance().Create_c_FavoriteInfo(_c_FavoriteInfo);
		}
		public DataSet Select_c_FavoriteByPage(int pageSize,int pageIndex,string strWhere,out int rowCount)
		{
			return this.SelectPageByDataSet("c_Favorite","*","Id",pageSize,pageIndex,true,true,strWhere,out rowCount);
		}
		#endregion

		
		#region c_FriendInfo

		public c_FriendInfo Select_c_FriendByID(Int32 iD)
		{
			IDataReader reader=DbProvider.Instance().Select_c_FriendByID(iD);
			c_FriendInfo _c_FriendInfo=null;
			while(reader.Read())
			{
				_c_FriendInfo=DataHelper.Init_c_FriendInfo(reader);
				break;
			}
			reader.Close();
			return _c_FriendInfo;
		}
		public bool Delete_c_FriendByID(Int32 iD)
		{
			return DbProvider.Instance().Delete_c_FriendByID(iD);
		}
		public bool Update_c_FriendInfo(c_FriendInfo _c_FriendInfo)
		{
			return DbProvider.Instance().Update_c_FriendInfo(_c_FriendInfo);
		}
		public bool Create_c_FriendInfo(c_FriendInfo _c_FriendInfo)
		{
			return DbProvider.Instance().Create_c_FriendInfo(_c_FriendInfo);
		}
		#endregion

		
		#region c_HomeSettingInfo


		public c_HomeSettingInfo Select_c_HomeSettingByRegisterID(Int32 registerID)
		{
			IDataReader reader=DbProvider.Instance().Select_c_HomeSettingByRegisterID(registerID);
			c_HomeSettingInfo _c_HomeSettingInfo=null;
			while(reader.Read())
			{
				_c_HomeSettingInfo=DataHelper.Init_c_HomeSettingInfo(reader);
				break;
			}
			reader.Close();
			return _c_HomeSettingInfo;
		}
		public bool Delete_c_HomeSettingByRegisterID(Int32 registerID)
		{
			return DbProvider.Instance().Delete_c_HomeSettingByRegisterID(registerID);
		}
		public c_HomeSettingInfo Select_c_HomeSettingByID(Int32 iD)
		{
			IDataReader reader=DbProvider.Instance().Select_c_HomeSettingByID(iD);
			c_HomeSettingInfo _c_HomeSettingInfo=null;
			while(reader.Read())
			{
				_c_HomeSettingInfo=DataHelper.Init_c_HomeSettingInfo(reader);
				break;
			}
			reader.Close();
			return _c_HomeSettingInfo;
		}
		public bool Delete_c_HomeSettingByID(Int32 iD)
		{
			return DbProvider.Instance().Delete_c_HomeSettingByID(iD);
		}
		public bool Update_c_HomeSettingInfo(c_HomeSettingInfo _c_HomeSettingInfo)
		{
			return DbProvider.Instance().Update_c_HomeSettingInfo(_c_HomeSettingInfo);
		}
		public bool Create_c_HomeSettingInfo(c_HomeSettingInfo _c_HomeSettingInfo)
		{
			return DbProvider.Instance().Create_c_HomeSettingInfo(_c_HomeSettingInfo);
		}
		#endregion

		
		#region c_MemoInfo

		public c_MemoInfo Select_c_MemoByID(Int32 iD)
		{
			IDataReader reader=DbProvider.Instance().Select_c_MemoByID(iD);
			c_MemoInfo _c_MemoInfo=null;
			while(reader.Read())
			{
				_c_MemoInfo=DataHelper.Init_c_MemoInfo(reader);
				break;
			}
			reader.Close();
			return _c_MemoInfo;
		}
		public bool Delete_c_MemoByID(Int32 iD)
		{
			return DbProvider.Instance().Delete_c_MemoByID(iD);
		}
		public bool Update_c_MemoInfo(c_MemoInfo _c_MemoInfo)
		{
			return DbProvider.Instance().Update_c_MemoInfo(_c_MemoInfo);
		}
		public bool Create_c_MemoInfo(c_MemoInfo _c_MemoInfo)
		{