default.aspx.cs

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

			_c_ArticleInfo.ArticleType = articleType;
			_c_ArticleInfo.SortID = sortID;
			return Globals.DbProvider.Create_c_ArticleInfo(_c_ArticleInfo);
		}
		/// <summary>
		/// 文章更新
		/// </summary>
		/// <param name="id"></param>
		/// <param name="title"></param>
		/// <param name="content"></param>
		/// <param name="articleType"></param>
		/// <param name="sortID"></param>
		/// <returns></returns>
		[Ajax.AjaxMethod()]
		public bool articleUpdate(int id,string title,string content,int articleType,int sortID)
		{
			c_ArticleInfo _c_ArticleInfo=Globals.DbProvider.Select_c_ArticleByID(id);
			_c_ArticleInfo.PostDate = DateTime.Now;
			_c_ArticleInfo.Title = title;
			_c_ArticleInfo.Content = content;
			_c_ArticleInfo.RegisterID = this.RegisterId;
			_c_ArticleInfo.ArticleType = articleType;
			_c_ArticleInfo.SortID = sortID;
			return Globals.DbProvider.Update_c_ArticleInfo(_c_ArticleInfo);
		}
		/// <summary>
		/// 删除文章
		/// </summary>
		/// <param name="id"></param>
		/// <returns></returns>
		[Ajax.AjaxMethod()]
		public bool articleDelete(int id)
		{
			return Globals.DbProvider.Delete_c_ArticleByID(id);
		}
		/// <summary>
		/// 转移文章
		/// </summary>
		/// <param name="sortID"></param>
		/// <param name="ids"></param>
		/// <returns></returns>
		[Ajax.AjaxMethod()]
		public int articleMove(int sortID,string ids)
		{
			return Globals.DbProvider.NonQueryInt("Update c_Article set SortID="+sortID+" where ID in ("+ids.Trim(',')+")");
		}
		#endregion

		#region 日记操作
		/// <summary>
		/// 添加日记
		/// </summary>
		/// <param name="title"></param>
		/// <param name="content"></param>
		/// <param name="weather"></param>
		/// <param name="mood"></param>
		/// <param name="postDate"></param>
		/// <param name="isVisible"></param>
		/// <returns></returns>
		[Ajax.AjaxMethod()]
		public bool diaryAdd(string title,string content,string weather,string mood,string postDate,bool isVisible)
		{
			c_DiaryInfo _c_DiaryInfo=new c_DiaryInfo();
			_c_DiaryInfo.PostDate = DateTime.Parse(postDate);
			_c_DiaryInfo.Title = title;
			_c_DiaryInfo.Content = content;
			_c_DiaryInfo.RegisterID = this.RegisterId;
			_c_DiaryInfo.IsVisible=isVisible;
			_c_DiaryInfo.Weather = weather;
			_c_DiaryInfo.Mood = mood;
			return Globals.DbProvider.Create_c_DiaryInfo(_c_DiaryInfo);
		}
		/// <summary>
		/// 更新日记
		/// </summary>
		/// <param name="id"></param>
		/// <param name="title"></param>
		/// <param name="content"></param>
		/// <param name="weather"></param>
		/// <param name="mood"></param>
		/// <param name="postDate"></param>
		/// <param name="isVisible"></param>
		/// <returns></returns>
		[Ajax.AjaxMethod()]
		public bool diaryUpdate(int id,string title,string content,string weather,string mood,string postDate,bool isVisible)
		{
			c_DiaryInfo _c_DiaryInfo=Globals.DbProvider.Select_c_DiaryByID(id);
			_c_DiaryInfo.PostDate = DateTime.Parse(postDate);
			_c_DiaryInfo.Title = title;
			_c_DiaryInfo.Content = content;
			_c_DiaryInfo.RegisterID = this.RegisterId;
			_c_DiaryInfo.IsVisible=isVisible;
			_c_DiaryInfo.Weather = weather;
			_c_DiaryInfo.Mood = mood;
			return Globals.DbProvider.Update_c_DiaryInfo(_c_DiaryInfo);
		}
		/// <summary>
		/// 删除日记
		/// </summary>
		/// <param name="id"></param>
		/// <returns></returns>
		[Ajax.AjaxMethod()]
		public bool diaryDelete(int id)
		{
			return Globals.DbProvider.Delete_c_DiaryByID(id);
		}
		/// <summary>
		/// 设置日记公开隐藏
		/// </summary>
		/// <param name="id"></param>
		/// <returns></returns>
		[Ajax.AjaxMethod()]
		public bool diaryVisible(int id)
		{
			return Globals.DbProvider.Visible_c_Diary(id);
		}
		#endregion

		#region 备忘录管理
		/// <summary>
		/// 添加备忘录
		/// </summary>
		/// <param name="content"></param>
		/// <param name="remindDate"></param>
		/// <param name="isRemind"></param>
		/// <returns></returns>
		[Ajax.AjaxMethod()]
		public bool memoAdd(string content,string remindDate,bool isRemind)
		{
			c_MemoInfo _c_MemoInfo=new c_MemoInfo();
			_c_MemoInfo.RemindDate = DateTime.Parse(remindDate);
			_c_MemoInfo.Content = content;
			_c_MemoInfo.IsRemind=isRemind;
			_c_MemoInfo.RegisterID = this.RegisterId;
			return Globals.DbProvider.Create_c_MemoInfo(_c_MemoInfo);
		}
		/// <summary>
		/// 删除备忘录
		/// </summary>
		/// <param name="id"></param>
		/// <returns></returns>
		[Ajax.AjaxMethod()]
		public bool memoDelete(int id)
		{
			return Globals.DbProvider.Delete_c_MemoByID(id);
		}
		/// <summary>
		/// 备忘录提示
		/// </summary>
		/// <param name="id"></param>
		/// <returns></returns>
		[Ajax.AjaxMethod()]
		public bool memoRemind(int id)
		{
			return Globals.DbProvider.Remind_c_Memo(id);
		}
		/// <summary>
		/// 更新备忘录
		/// </summary>
		/// <param name="id"></param>
		/// <param name="content"></param>
		/// <param name="remindDate"></param>
		/// <param name="isRemind"></param>
		/// <returns></returns>
		[Ajax.AjaxMethod()]
		public bool memoUpdate(int id,string content,string remindDate,bool isRemind)
		{
			c_MemoInfo _c_MemoInfo=Globals.DbProvider.Select_c_MemoByID(id);
			_c_MemoInfo.RemindDate = DateTime.Parse(remindDate);
			_c_MemoInfo.Content = content;
			_c_MemoInfo.IsRemind=isRemind;
			_c_MemoInfo.RegisterID = this.RegisterId;
			return Globals.DbProvider.Update_c_MemoInfo(_c_MemoInfo);
		}
		#endregion

		#region 音乐操作
		/// <summary>
		/// 删除上传音乐
		/// </summary>
		/// <param name="musicName"></param>
		[Ajax.AjaxMethod()]
		public void delMusic(string musicName)
		{
			string musicPath=Globals.GetFilePath(Config.ClubMusicPath);
			if(Config.Settings.UpFileIsMakeDir)
			{
				musicPath=musicPath+this.RegisterId+"\\";
			}
			FileHelper.DelFileExe(musicPath+musicName);
		}
		/// <summary>
		/// 音乐添加
		/// </summary>
		/// <param name="musicName"></param>
		/// <param name="singer"></param>
		/// <param name="musicUrl"></param>
		/// <param name="isUpLoad"></param>
		/// <param name="explain"></param>
		/// <param name="sortID"></param>
		/// <returns></returns>
		[Ajax.AjaxMethod()]
		public bool musicAdd(string musicName,string singer,string musicUrl,bool isUpLoad,string explain,int sortID)
		{
			c_MusicInfo _c_MusicInfo=new c_MusicInfo();
			_c_MusicInfo.PostDate=DateTime.Now;
			_c_MusicInfo.Explain = explain;
			_c_MusicInfo.MusicName = musicName;
			_c_MusicInfo.Singer=singer;
			_c_MusicInfo.MusicUrl=musicUrl;
			_c_MusicInfo.IsUpLoad = isUpLoad;
			_c_MusicInfo.SortID = sortID;
			_c_MusicInfo.Format = StringHelper.GetLastStr(musicUrl,".");
			_c_MusicInfo.MusicSize = 0;
			_c_MusicInfo.RegisterID = this.RegisterId;
			if(_c_MusicInfo.IsUpLoad)
			{
				string musicPath=Globals.GetFilePath(Config.ClubMusicPath);
				if(Config.Settings.UpFileIsMakeDir)
				{
					musicPath = musicPath+this.RegisterId+"\\";
				}
				System.IO.FileInfo file=new System.IO.FileInfo(musicPath+_c_MusicInfo.MusicUrl);
				_c_MusicInfo.MusicSize = System.Convert.ToInt32(file.Length);
			}
			return Globals.DbProvider.Create_c_MusicInfo(_c_MusicInfo);
		}
		/// <summary>
		/// 更新音乐
		/// </summary>
		/// <param name="id"></param>
		/// <param name="musicName"></param>
		/// <param name="singer"></param>
		/// <param name="musicUrl"></param>
		/// <param name="isUpLoad"></param>
		/// <param name="explain"></param>
		/// <param name="sortID"></param>
		/// <returns></returns>
		[Ajax.AjaxMethod()]
		public bool musicUpdate(int id,string musicName,string singer,string musicUrl,bool isUpLoad,string explain,int sortID)
		{
			c_MusicInfo _c_MusicInfo=Globals.DbProvider.Select_c_MusicByID(id);
			_c_MusicInfo.PostDate=DateTime.Now;
			_c_MusicInfo.Explain = explain;
			_c_MusicInfo.MusicName = musicName;
			_c_MusicInfo.Singer=singer;
			_c_MusicInfo.MusicUrl=musicUrl;
			_c_MusicInfo.IsUpLoad = isUpLoad;
			_c_MusicInfo.SortID = sortID;
			_c_MusicInfo.Format = StringHelper.GetLastStr(musicUrl,".");
			_c_MusicInfo.MusicSize = 0;
			_c_MusicInfo.RegisterID = this.RegisterId;
			if(_c_MusicInfo.IsUpLoad)
			{
				string musicPath=Globals.GetFilePath(Config.ClubMusicPath);
				if(Config.Settings.UpFileIsMakeDir)
				{
					musicPath = musicPath+this.RegisterId+"\\";
				}
				System.IO.FileInfo file=new System.IO.FileInfo(musicPath+_c_MusicInfo.MusicUrl);
				_c_MusicInfo.MusicSize = System.Convert.ToInt32(file.Length);
			}
			return Globals.DbProvider.Update_c_MusicInfo(_c_MusicInfo);
		}
		/// <summary>
		/// 删除音乐
		/// </summary>
		/// <param name="id"></param>
		/// <returns></returns>
		[Ajax.AjaxMethod()]
		public bool musicDelete(int id)
		{
			c_MusicInfo _c_MusicInfo=Globals.DbProvider.Select_c_MusicByID(id);
			if(_c_MusicInfo.IsUpLoad)
			{
				string musicPath=Globals.GetFilePath(Config.ClubMusicPath);
				if(Config.Settings.UpFileIsMakeDir)
				{
					musicPath = musicPath+this.RegisterId+"\\";
				}
				FileHelper.DelFileExe(musicPath+_c_MusicInfo.MusicUrl);
			}
			return Globals.DbProvider.Delete_c_MusicByID(id);
		}
		/// <summary>
		/// 多条音乐删除
		/// </summary>
		/// <param name="sortID"></param>
		/// <param name="ids"></param>
		/// <returns></returns>
		[Ajax.AjaxMethod()]
		public int musicMove(int sortID,string ids)
		{
			return Globals.DbProvider.NonQueryInt("Update c_Music set SortID="+sortID+" where ID in ("+ids.Trim(',')+")");
		}
		/// <summary>
		/// 移动音乐
		/// </summary>
		/// <param name="id"></param>
		/// <param name="orderId"></param>
		/// <param name="eId"></param>
		/// <param name="eOrderId"></param>
		/// <returns></returns>
		[Ajax.AjaxMethod()]
		public bool musicUpDown(int id,int orderId,int eId,int eOrderId)
		{
			Globals.DbProvider.NonQueryInt("update c_Music set orderId="+eOrderId+" where id="+id);
			Globals.DbProvider.NonQueryInt("update c_Music set orderId="+orderId+" where id="+eId);
			return true;
		}
		#endregion

		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion
	}
}