public bool AddSpaceLink(SpaceLinkInfo spacelinks)
{
//try
//{
IDataParameter[] prams =
{
DbHelper.MakeInParam("@linkid", (DbType)SqlDbType.Int, 4,spacelinks.LinkId),
DbHelper.MakeInParam("@userid", (DbType)SqlDbType.Int, 4,spacelinks.UserId),
DbHelper.MakeInParam("@linktitle", (DbType)SqlDbType.NVarChar, 50,spacelinks.LinkTitle),
DbHelper.MakeInParam("@linkurl", (DbType)SqlDbType.VarChar,255,spacelinks.LinkUrl),
DbHelper.MakeInParam("@description", (DbType)SqlDbType.NVarChar, 200,spacelinks.Description),
};
string sqlstring = String.Format("INSERT INTO [" + BaseConfigs.GetTablePrefix + "spacelinks] ( [userid], [linktitle], [linkurl], [description]) VALUES ( @userid, @linktitle, @linkurl, @description)");
DbHelper.ExecuteNonQuery(CommandType.Text, sqlstring, prams);
return true;
//}
//catch (Exception ex)
//{
// errormsg = Globals.TransferSqlErrorInfo(ex.Message);
// return false;
//}
}
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 linktitle = Utils.HtmlEncode(DNTRequest.GetString("linktitle"));
if ((linktitle.Length > 50) || (linktitle == ""))
{
AddErrLine("链接标题不得超过50个字符且不能为空");
return;
}
string linkurl = Utils.HtmlEncode(DNTRequest.GetString("linkurl"));
if ((linkurl.Length > 255) || (linkurl == ""))
{
AddErrLine("链接地址不得超过255个字符且不能为空");
return;
}
if (DNTRequest.GetString("description").Length > 200)
{
AddErrLine("链接描述不得超过200个字符");
return;
}
string errorinfo = "";
SpaceLinkInfo __spacelinkinfo = new SpaceLinkInfo();
__spacelinkinfo.UserId = userid;
__spacelinkinfo.LinkTitle = linktitle;
__spacelinkinfo.LinkUrl = linkurl;
__spacelinkinfo.Description = Utils.HtmlEncode(DNTRequest.GetString("description"));
Space.Data.DbProvider.GetInstance().AddSpaceLink(__spacelinkinfo);
if (errorinfo == "")
{
SetUrl("usercpspacelinklist.aspx");
SetMetaRefresh();
SetShowBackLink(true);
AddMsgLine("添加友情链接完毕");
}
else
{
AddErrLine(errorinfo);
return;
}
}
}
public static SpaceLinkInfo[] GetSpaceLinksInfo (DataTable dt)
{
if(dt == null || dt.Rows.Count == 0)
return null;
SpaceLinkInfo[] spacelinksinfoarray = new SpaceLinkInfo[dt.Rows.Count];
for(int i = 0 ; i < dt.Rows.Count ; i++)
{
spacelinksinfoarray[i] = new SpaceLinkInfo();
spacelinksinfoarray[i].LinkId = TypeConverter.ObjectToInt(dt.Rows[i]["linkid"]);
spacelinksinfoarray[i].UserId = TypeConverter.ObjectToInt(dt.Rows[i]["userid"]);
spacelinksinfoarray[i].LinkTitle = dt.Rows[i]["linktitle"].ToString();
spacelinksinfoarray[i].Description = dt.Rows[i]["description"].ToString();
spacelinksinfoarray[i].LinkUrl =dt.Rows[i]["linkurl"].ToString();
}
dt.Dispose();
return spacelinksinfoarray;
}
public static SpaceLinkInfo GetSpaceLinksInfo (IDataReader idatareader)
{
if(idatareader == null)
return null;
if(idatareader.Read())
{
SpaceLinkInfo spacelinksinfo = new SpaceLinkInfo();
spacelinksinfo.LinkId = TypeConverter.ObjectToInt(idatareader["linkid"]);
spacelinksinfo.UserId = TypeConverter.ObjectToInt(idatareader["userid"]);
spacelinksinfo.LinkTitle = idatareader["linktitle"].ToString();
spacelinksinfo.Description = idatareader["description"].ToString();
spacelinksinfo.LinkUrl = idatareader["linkurl"].ToString();
idatareader.Close();
return spacelinksinfo;
}
else
{
idatareader.Close();
return null;
}
}
public bool AddSpaceLink(SpaceLinkInfo spacelinks)
{
DbParameter[] parms =
{
DbHelper.MakeInParam("@linkid", (DbType)SqlDbType.Int, 4,spacelinks.LinkId),
DbHelper.MakeInParam("@userid", (DbType)SqlDbType.Int, 4,spacelinks.UserId),
DbHelper.MakeInParam("@linktitle", (DbType)SqlDbType.NVarChar, 50,spacelinks.LinkTitle),
DbHelper.MakeInParam("@linkurl", (DbType)SqlDbType.VarChar,255,spacelinks.LinkUrl),
DbHelper.MakeInParam("@description", (DbType)SqlDbType.NVarChar, 200,spacelinks.Description),
};
string commandText = String.Format("INSERT INTO [{0}spacelinks] ( [userid], [linktitle], [linkurl], [description]) VALUES ( @userid, @linktitle, @linkurl, @description)", BaseConfigs.GetTablePrefix);
DbHelper.ExecuteNonQuery(CommandType.Text, commandText, parms);
return true;
}
public bool SaveSpaceLink(SpaceLinkInfo spacelinks)
{
DbParameter[] parms =
{
DbHelper.MakeInParam("@linkid", (DbType)SqlDbType.Int, 4,spacelinks.LinkId),
DbHelper.MakeInParam("@linktitle", (DbType)SqlDbType.NVarChar, 50,spacelinks.LinkTitle),
DbHelper.MakeInParam("@linkurl", (DbType)SqlDbType.VarChar,255,spacelinks.LinkUrl),
DbHelper.MakeInParam("@description", (DbType)SqlDbType.NVarChar, 200,spacelinks.Description),
};
string commandText = String.Format("UPDATE [{0}spacelinks] SET [linktitle] = @linktitle, [linkurl] = @linkurl, [description] = @description WHERE [linkid] = @linkid ", BaseConfigs.GetTablePrefix);
DbHelper.ExecuteNonQuery(CommandType.Text, commandText, parms);
return true;
}