protected override void ShowPage()
{
pagetitle = "用户控制面板";
if (userid == -1)
{
AddErrLine("你尚未登录");
return;
}
user = Users.GetUserInfo(userid);
if (config.Enablespace != 1)
{
AddErrLine("个人空间功能已被关闭");
return;
}
if (user.Spaceid <= 0)
{
AddErrLine("您尚未开通个人空间");
return;
}
if (DNTRequest.IsPost())
{
if (ForumUtils.IsCrossSitePost())
{
AddErrLine("您的请求来路不正确，无法提交。如果您安装了某种默认屏蔽来路信息的个人防火墙软件(如 Norton Internet Security)，请设置其不要禁止来路信息后再试。");
return;
}
string title = Utils.HtmlEncode(DNTRequest.GetString("title"));
if ((title.Length > 50) || (title == ""))
{
AddErrLine("分类名称不得超过50个字符且不能为空");
return;
}
if (DNTRequest.GetString("description").Length > 1000)
{
AddErrLine("分类描述不得超过1000个字符");
return;
}
if (!Utils.IsNumeric(DNTRequest.GetString("displayorder")))
{
AddErrLine("分类描述序号必须为数字");
return;
}
string errorinfo = "";
int categoryid = DNTRequest.GetInt("categoryid", 0);
if (categoryid == 0)
{
AddErrLine("请正确选择分类信息");
return;
}
spacecategoryinfo = BlogProvider.GetSpaceCategoryInfo(Space.Data.DbProvider.GetInstance().GetSpaceCategoryByCategoryID(categoryid));
if (spacecategoryinfo == null || spacecategoryinfo.Uid != userid)
{
AddErrLine("您选择分类不存在");
return;
}
spacecategoryinfo.Title = title;
spacecategoryinfo.Description = DNTRequest.GetString("description");
spacecategoryinfo.Displayorder = Convert.ToInt32(DNTRequest.GetString("displayorder"));
Space.Data.DbProvider.GetInstance().SaveSpaceCategory(spacecategoryinfo);
if (errorinfo == "")
{
SetUrl("usercpspacemanagecategory.aspx");
SetMetaRefresh();
SetShowBackLink(true);
AddMsgLine("修改文章分类完毕");
}
else
{
AddErrLine(errorinfo);
return;
}
}
else
{
int categoryid = DNTRequest.GetInt("categoryid", 0);
if (categoryid == 0)
{
AddErrLine("请正确选择分类信息");
return;
}
spacecategoryinfo = BlogProvider.GetSpaceCategoryInfo(Space.Data.DbProvider.GetInstance().GetSpaceCategoryByCategoryID(categoryid));
if (spacecategoryinfo.Uid != userid)
{
AddErrLine("请选择的分类不存在");
return;
}
if (spacecategoryinfo == null || spacecategoryinfo.Uid != userid)
{
AddErrLine("您选择分类不存在");
return;
}
}
}
public bool SaveSpaceCategory(SpaceCategoryInfo spacecategories)
{
//try
//{
IDataParameter[] prams =
{
DbHelper.MakeInParam("@categoryid", (DbType)SqlDbType.Int, 4,spacecategories.CategoryID),
DbHelper.MakeInParam("@title", (DbType)SqlDbType.NVarChar, 50,spacecategories.Title),
DbHelper.MakeInParam("@uid", (DbType)SqlDbType.Int, 4,spacecategories.Uid),
DbHelper.MakeInParam("@description", (DbType)SqlDbType.NVarChar, 1000,spacecategories.Description),
DbHelper.MakeInParam("@typeid", (DbType)SqlDbType.Int, 4,spacecategories.TypeID),
DbHelper.MakeInParam("@categorycount", (DbType)SqlDbType.Int, 4,spacecategories.CategoryCount),
DbHelper.MakeInParam("@displayorder", (DbType)SqlDbType.Int, 4,spacecategories.Displayorder)
};
string sqlstring = String.Format("UPDATE [" + BaseConfigs.GetTablePrefix + "spacecategories] SET [title] = @title, [uid] = @uid, [description] = @description, [typeid] = @typeid, [categorycount] = @categorycount, [displayorder] = @displayorder WHERE [categoryid] = @categoryid ");
DbHelper.ExecuteNonQuery(CommandType.Text, sqlstring, prams);
return true;
//}
//catch (Exception ex)
//{
// errormsg = Globals.TransferSqlErrorInfo(ex.Message);
// return false;
//}
}
/// <summary>
/// 获取日志分类
/// </summary>
/// <param name="dt"></param>
/// <returns></returns>
public static SpaceCategoryInfo[] GetSpaceCategories (DataTable dt)
{
if(dt == null || dt.Rows.Count == 0)
return null;
SpaceCategoryInfo[] spacecategoriesinfoarray = new SpaceCategoryInfo[dt.Rows.Count];
for(int i = 0 ; i < dt.Rows.Count ; i++)
{
spacecategoriesinfoarray[i] = new SpaceCategoryInfo();
spacecategoriesinfoarray[i].CategoryID = TypeConverter.ObjectToInt(dt.Rows[i]["categoryid"]);
spacecategoriesinfoarray[i].Title = dt.Rows[i]["title"].ToString();
spacecategoriesinfoarray[i].Uid = TypeConverter.ObjectToInt(dt.Rows[i]["uid"]);
spacecategoriesinfoarray[i].Description = dt.Rows[i]["description"].ToString();
spacecategoriesinfoarray[i].TypeID = TypeConverter.ObjectToInt(dt.Rows[i]["typeid"]);
spacecategoriesinfoarray[i].CategoryCount = TypeConverter.ObjectToInt(dt.Rows[i]["categorycount"]);
spacecategoriesinfoarray[i].Displayorder = TypeConverter.ObjectToInt(dt.Rows[i]["displayorder"]);
}
dt.Dispose();
return spacecategoriesinfoarray;
}
/// <summary>
/// 获取日志分类
/// </summary>
/// <param name="__idatareader"></param>
/// <returns></returns>
public static SpaceCategoryInfo GetSpaceCategoryInfo (IDataReader idatareader)
{
if(idatareader == null)
return null;
if(idatareader.Read())
{
SpaceCategoryInfo spacecategoriesinfo = new SpaceCategoryInfo();
spacecategoriesinfo.CategoryID = TypeConverter.ObjectToInt(idatareader["categoryid"]);
spacecategoriesinfo.Title = idatareader["title"].ToString();
spacecategoriesinfo.Uid = TypeConverter.ObjectToInt(idatareader["uid"]);
spacecategoriesinfo.Description = idatareader["description"].ToString();
spacecategoriesinfo.TypeID = TypeConverter.ObjectToInt(idatareader["typeid"]);
spacecategoriesinfo.CategoryCount = TypeConverter.ObjectToInt(idatareader["categorycount"]);
spacecategoriesinfo.Displayorder = TypeConverter.ObjectToInt(idatareader["displayorder"]);
idatareader.Close();
return spacecategoriesinfo;
}
else
{
idatareader.Close();
return null;
}
}
public bool SaveSpaceCategory(SpaceCategoryInfo spacecategories)
{
DbParameter[] parms =
{
DbHelper.MakeInParam("@categoryid", (DbType)SqlDbType.Int, 4,spacecategories.CategoryID),
DbHelper.MakeInParam("@title", (DbType)SqlDbType.NVarChar, 50,spacecategories.Title),
DbHelper.MakeInParam("@uid", (DbType)SqlDbType.Int, 4,spacecategories.Uid),
DbHelper.MakeInParam("@description", (DbType)SqlDbType.NVarChar, 1000,spacecategories.Description),
DbHelper.MakeInParam("@typeid", (DbType)SqlDbType.Int, 4,spacecategories.TypeID),
DbHelper.MakeInParam("@categorycount", (DbType)SqlDbType.Int, 4,spacecategories.CategoryCount),
DbHelper.MakeInParam("@displayorder", (DbType)SqlDbType.Int, 4,spacecategories.Displayorder)
};
string commandText = string.Format("UPDATE [{0}spacecategories] SET [title] = @title, [uid] = @uid, [description] = @description, [typeid] = @typeid, [categorycount] = @categorycount, [displayorder] = @displayorder WHERE [categoryid] = @categoryid ", BaseConfigs.GetTablePrefix);
DbHelper.ExecuteNonQuery(CommandType.Text, commandText, parms);
return true;
}
public bool AddSpaceCategory(SpaceCategoryInfo spacecategories)
{
DbParameter[] parms =
{
DbHelper.MakeInParam("@categoryid", (DbType)SqlDbType.Int, 4,spacecategories.CategoryID),
DbHelper.MakeInParam("@title", (DbType)SqlDbType.NVarChar, 50,spacecategories.Title),
DbHelper.MakeInParam("@uid", (DbType)SqlDbType.Int, 4,spacecategories.Uid),
DbHelper.MakeInParam("@description", (DbType)SqlDbType.NVarChar, 1000,spacecategories.Description),
DbHelper.MakeInParam("@typeid", (DbType)SqlDbType.Int, 4,spacecategories.TypeID),
DbHelper.MakeInParam("@categorycount", (DbType)SqlDbType.Int, 4,spacecategories.CategoryCount),
DbHelper.MakeInParam("@displayorder", (DbType)SqlDbType.Int, 4,spacecategories.Displayorder)
};
string commandText = string.Format("INSERT INTO [{0}spacecategories] ( [title], [uid], [description], [typeid], [categorycount], [displayorder]) VALUES ( @title, @uid, @description, @typeid, @categorycount, @displayorder)", BaseConfigs.GetTablePrefix);
DbHelper.ExecuteNonQuery(CommandType.Text, commandText, parms);
return true;
}
protected override void ShowPage()
{
pagetitle = "用户控制面板";
if (userid == -1)
{
AddErrLine("你尚未登录");
return;
}
user = Users.GetUserInfo(userid);
if (config.Enablespace != 1)
{
AddErrLine("个人空间功能已被关闭");
return;
}
if (user.Spaceid <= 0)
{
AddErrLine("您尚未开通个人空间");
return;
}
if (DNTRequest.IsPost())
{
if (ForumUtils.IsCrossSitePost())
{
AddErrLine("您的请求来路不正确，无法提交。如果您安装了某种默认屏蔽来路信息的个人防火墙软件(如 Norton Internet Security)，请设置其不要禁止来路信息后再试。");
return;
}
string title = Utils.HtmlEncode(DNTRequest.GetString("title"));
if ((title.Length > 50) || (title == ""))
{
AddErrLine("分类名称不得超过50个字符且不能为空");
return;
}
if (DNTRequest.GetString("description").Length > 1000)
{
AddErrLine("分类描述不得超过1000个字符");
return;
}
if (!Utils.IsNumeric(DNTRequest.GetString("displayorder")))
{
AddErrLine("分类描述序号必须为数字");
return;
}
SpaceCategoryInfo __spacecategoryinfo = new SpaceCategoryInfo();
__spacecategoryinfo.Title = title;
__spacecategoryinfo.Description = Utils.HtmlEncode(DNTRequest.GetString("description"));
__spacecategoryinfo.Displayorder = Convert.ToInt32(DNTRequest.GetString("displayorder"));
__spacecategoryinfo.Uid = userid;
Space.Data.DbProvider.GetInstance().AddSpaceCategory(__spacecategoryinfo);
SetUrl("usercpspacemanagecategory.aspx");
SetMetaRefresh();
SetShowBackLink(true);
AddMsgLine("添加日志分类完毕");
}
}