📄 articleadd.ascx.cs
字号:
namespace Seaskyer.WebApp.skyNews.Pages.UserMSC
{
using System;
using System.Collections;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using Seaskyer.Strings;
using Seaskyer.WebApp.Utility;
/// <summary>
/// ArticleAdd : 添加新闻。
/// </summary>
public class ArticleAdd : basePage
{
protected CUserControls.HtmlEditor HtmlEditor1;
protected System.Web.UI.WebControls.Label label1;
protected System.Web.UI.WebControls.DropDownList ClassID;
protected System.Web.UI.WebControls.RequiredFieldValidator Requiredfieldvalidator1;
protected System.Web.UI.WebControls.TextBox Title;
protected System.Web.UI.WebControls.RequiredFieldValidator Requiredfieldvalidator2;
protected System.Web.UI.WebControls.CheckBox reMark;
protected System.Web.UI.WebControls.CheckBox remarkLink;
protected System.Web.UI.WebControls.TextBox TitleImg;
protected System.Web.UI.WebControls.CheckBox Headline;
protected System.Web.UI.WebControls.CheckBox SortTop;
protected System.Web.UI.WebControls.CheckBox IndexTop;
protected System.Web.UI.WebControls.TextBox aUrl;
protected System.Web.UI.WebControls.CheckBox imgWithMark;
protected System.Web.UI.WebControls.CustomValidator Customvalidator1;
protected System.Web.UI.WebControls.TextBox Summary;
protected System.Web.UI.WebControls.TextBox Key;
protected System.Web.UI.WebControls.TextBox Author;
protected System.Web.UI.WebControls.TextBox AuthorEmail;
protected System.Web.UI.WebControls.TextBox Source;
protected System.Web.UI.WebControls.TextBox SourceUrl;
protected System.Web.UI.WebControls.ListBox permitGroups;
protected System.Web.UI.WebControls.Button Submit;
protected System.Web.UI.HtmlControls.HtmlInputHidden articleid;
protected System.Web.UI.WebControls.DropDownList Topic;
protected System.Web.UI.WebControls.DropDownList TitleCss;
protected System.Web.UI.WebControls.ValidationSummary ValidationSummary1;
protected System.Web.UI.WebControls.Button Button1;
protected System.Web.UI.HtmlControls.HtmlInputHidden TopicID;
private void Page_Load(object sender, System.EventArgs e)
{
label1.Visible = false;
if( Page.IsPostBack ) return;
#region 加载初始化列表
DataTable dt = new DataTable();
// 标题样式
dp.CommandText = cmd["TitleCss", "SELECT"];
dt = dp.DataTableSQL();
for( int i = 0; i < dt.Rows.Count; i++ )
{
TitleCss.Items.Add( new ListItem(dt.Rows[i]["CssName"].ToString(), dt.Rows[i]["CssContent"].ToString()) );
}
dt.Clear();
// 专题列表
dp.CommandText = cmd["aTopic", "SELECT"];
dt = dp.DataTableSQL();
for( int i = 0; i < dt.Rows.Count; i++ )
{
Topic.Items.Add( new ListItem(dt.Rows[i]["topic"].ToString(), dt.Rows[i]["topicid"].ToString()) );
}
dt.Clear();
// 用户组
dp.CommandText = cmd["UserGroup", "SELECT"];
dt = dp.DataTableSQL();
for( int i = 0; i < dt.Rows.Count; i++ )
{
permitGroups.Items.Add(new ListItem(dt.Rows[i]["GroupName"].ToString(), dt.Rows[i]["GroupID"].ToString()));
}
dt.Clear();
dt.Dispose();
// 分类列表
ci.GetClassDropDownListOptions(ClassID, "", "EnableAdd = 1");
#endregion
if( !user.CheckValiable(Request.QueryString["articleid"]) )
{
if( !power.GPB("Add") )
{
base.strError.Add(lang["sharePage", "denyViewErrorInfo"]);
return;
}
#region 添加新闻信息加载
Submit.Text = " 添 加 ";
imgWithMark.Visible = bool.Parse(config["imgWithMark"]);
Author.Text = user.userID;
#endregion
}
else
{
if( !power.GPB("Change") )
{
base.strError.Add(lang["sharePage", "denyViewErrorInfo"]);
return;
}
#region 修改新闻信息加载
Submit.Text = " 修 改 ";
imgWithMark.Visible = bool.Parse(config["imgWithMark"]);
dp.CommandText = cmd["Article", "SELECT_INDEX"];
dp.Parameter.Add("ArticleID", Request.QueryString["articleid"]);
dt = dp.DataTableSQL();
if(dt.Rows.Count == 0)
{
base.strError.Add("您所操作的记录不存在！");
return;
}
else
{
//开始赋值
articleid.Value = dt.Rows[0]["ArticleID"].ToString();
Title.Text = dt.Rows[0]["Title"].ToString();
HtmlEditor1.Value = mp.ConvertToContent(dt.Rows[0]["HtmlContent"].ToString(), config);
TitleImg.Text = mp.ConvertToContent(dt.Rows[0]["TitleImg"].ToString(), config);
TitleImg.Attributes["onfocus"] = "this.select()";
Headline.Checked = (dt.Rows[0]["headline"].ToString() == "1" ? true : false);
SortTop.Checked = (dt.Rows[0]["sortTop"].ToString() == "1" ? true : false);
IndexTop.Checked = (dt.Rows[0]["indexTop"].ToString() == "1" ? true : false);
aUrl.Text = dt.Rows[0]["aUrl"].ToString();
Summary.Text = dt.Rows[0]["summary"].ToString();
Key.Text = dt.Rows[0]["nkey"].ToString();
Author.Text = dt.Rows[0]["author"].ToString();
AuthorEmail.Text = dt.Rows[0]["authorEmail"].ToString();
Source.Text = dt.Rows[0]["SourceFrom"].ToString();
SourceUrl.Text = dt.Rows[0]["sourceUrl"].ToString();
string permitGroupString = dt.Rows[0]["permitGroups"].ToString();
for( int i = 0; i < ClassID.Items.Count; i++ )
{
if( ClassID.Items[i].Value == dt.Rows[0]["ClassID"].ToString() )
ClassID.Items[i].Selected = true;
else
ClassID.Items[i].Selected = false;
}
for( int i = 0; i < TitleCss.Items.Count; i++ )
{
if( TitleCss.Items[i].Value == dt.Rows[0]["TitleCss"].ToString() )
TitleCss.Items[i].Selected = true;
else
TitleCss.Items[i].Selected = false;
}
}
#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
protected void Submit_OnClick(object sender, EventArgs e)
{
#region 数据合法性验证
string classid = ClassID.SelectedValue;
string title = Title.Text.Trim();
if( !user.CheckValiable(classid) ) base.strError.Add("对不起，您没有选择新闻的分类");
if( !user.CheckValiable(title) ) base.strError.Add("请填写标题");
if( base.strError.Count > 0 ) return;
#endregion
if( !user.CheckValiable(Request.QueryString["articleid"]) )
{
#region 开始添加新闻
// 获取添加文章的内容
string articleContent = HtmlEditor1.Value;
// 将添加的内容转化为纯文本
string articleText = Function.convertText(articleContent);
articleContent = mp.ConvertContent(articleContent, config);
string titleImgString = "";
if( TitleImg.Text != "" ) titleImgString = mp.ConvertContent(TitleImg.Text, config);
dp.CommandText = cmd["Article", "INSERT"];
dp.Parameter.Add("Title", Title.Text);
dp.Parameter.Add("ClassID", ClassID.SelectedValue);
dp.Parameter.Add("TitleCss", TitleCss.SelectedValue);
dp.Parameter.Add("HtmlContent", articleContent);
dp.Parameter.Add("TextContent", articleText);
dp.Parameter.Add("Nkey", Key.Text);
dp.Parameter.Add("Addtime", DateTime.Now.ToString());
dp.Parameter.Add("Headline", (Headline.Checked ? 1 : 0));
dp.Parameter.Add("imgNews", (titleImgString != "" ? 1 : 0));
dp.Parameter.Add("titleImg", titleImgString);
dp.Parameter.Add("TopicID", Topic.SelectedValue);
dp.Parameter.Add("Summary", Summary.Text);
dp.Parameter.Add("permitGroups", user.ListBox_SelectedValues(permitGroups));
dp.Parameter.Add("AddUserID", user.userID);
dp.Parameter.Add("CheckUserID", user.userID);
dp.Parameter.Add("aUrl", aUrl.Text);
dp.Parameter.Add("Author", Author.Text);
dp.Parameter.Add("SourceFrom", Source.Text);
dp.Parameter.Add("AuthorEmail", AuthorEmail.Text);
dp.Parameter.Add("SourceUrl", SourceUrl.Text);
dp.Parameter.Add("sortTop", (SortTop.Checked ? 1 : 0));
dp.Parameter.Add("indexTop", (IndexTop.Checked ? 1 : 0));
dp.Parameter.Add("remark", (reMark.Checked ? 1 : 0));
dp.Parameter.Add("remarkLink", (remarkLink.Checked ? 1 : 0));
// 开始添加文章数据至数据库中
if(dp.NonQuerySQL() == 1)
{
label1.Text = "文章 “" + Title.Text + "” 添加成功"; label1.ForeColor = Color.BlueViolet;
ResetAdd();
}
else
{
label1.Text = "文章 “" + Title.Text + "” 添加失败...";label1.ForeColor = Color.Red;
}
label1.Visible = true;
#endregion
}
else
{
#region 开始修改新闻
// 获取添加文章的内容
string articleContent = HtmlEditor1.Value;
// 将添加的内容转化为纯文本
string articleText = Function.convertText(articleContent);
articleContent = mp.ConvertContent(articleContent, config);
string titleImgString = "";
if( TitleImg.Text != "" ) titleImgString = mp.ConvertContent(TitleImg.Text, config);
dp.CommandText = cmd["Article", "UPDATE"];
dp.Parameter.Add("Title", Title.Text);
dp.Parameter.Add("ClassID", ClassID.SelectedValue);
dp.Parameter.Add("TitleCss", TitleCss.SelectedValue);
dp.Parameter.Add("HtmlContent", articleContent);
dp.Parameter.Add("TextContent", articleText);
dp.Parameter.Add("Nkey", Key.Text);
dp.Parameter.Add("Headline", (Headline.Checked ? 1 : 0));
dp.Parameter.Add("imgNews", (titleImgString != "" ? 1 : 0));
dp.Parameter.Add("titleImg", titleImgString);
dp.Parameter.Add("TopicID", Topic.SelectedValue);
dp.Parameter.Add("Summary", Summary.Text);
dp.Parameter.Add("permitGroups", user.ListBox_SelectedValues(permitGroups));
dp.Parameter.Add("CheckUserID", user.userID);
dp.Parameter.Add("aUrl", aUrl.Text);
dp.Parameter.Add("Author", Author.Text);
dp.Parameter.Add("SourceFrom", Source.Text);
dp.Parameter.Add("AuthorEmail", AuthorEmail.Text);
dp.Parameter.Add("SourceUrl", SourceUrl.Text);
dp.Parameter.Add("sortTop", (SortTop.Checked ? 1 : 0));
dp.Parameter.Add("indexTop", (IndexTop.Checked ? 1 : 0));
dp.Parameter.Add("remark", (reMark.Checked ? 1 : 0));
dp.Parameter.Add("remarkLink", (remarkLink.Checked ? 1 : 0));
dp.Parameter.Add("ArticleID", articleid.Value);
// 开始添加文章数据至数据库中
if(dp.NonQuerySQL() == 1)
{
label1.Text = "文章 “" + Title.Text + "” 修改成功"; label1.ForeColor = Color.BlueViolet;
}
else
{
label1.Text = "文章 “" + Title.Text + "” 修改失败...";label1.ForeColor = Color.Red;
}
label1.Visible = true;
#endregion
}
#region ""
/*
Hashtable ht = new Hashtable();
if(Object.Equals(Request.QueryString["articleid"], null) || Object.Equals(Request.QueryString["articleid"], ""))
{
if( !user.GPB("Add") && !user.IsAdmin )
{
base.strError.Add("您无权执行 “" + user.GetAppName() + "” 操作，详情请与管理员联系！");
return;
}
#region 添加文章事件
submitStr = user.GetAppInfo("button2","buttonValue");
// 获取添加文章的内容
int articleNum = int.Parse(user.GetSiteConst("articleNum")) + 1;
ht.Add("articleNum", articleNum);
user.UpdateSiteConst(ht);
ht.Clear();
//string articleContent = Request.Form["content1"];
//Response.Write(articleContent);
//Response.End();
string articleContent = Request.Form["content1"].Replace(user.GetConfigName("uploadWebPath"), "§uploadWebPath§");
// 将添加的内容转化为纯文本
string articleText = Function.convertText(articleContent);
string titleImgString = "";
if( TitleImg.Text != "" ) titleImgString = TitleImg.Text.Replace(user.GetConfigName("uploadWebPath"), "§uploadWebPath§");
if( bool.Parse(user.GetConfigName("articleCheck")) && !user.IsAdmin )
{
// 文章需要审核，添加到临时表中
strCmd = user.GetCommand("Article_nc_INSERT");
ht.Add( "content", articleContent ); //文章内容(纯文本)
ht.Add( "title", Title.Text ); // 文章标题
ht.Add( "classid", ClassID.SelectedValue ); // 所属分类ID
ht.Add( "nkey", Key.Text ); // 关键字
ht.Add( "headline", (Headline.Checked ? 1 : 0) ); // 是否头条新闻
ht.Add( "imgNews", (titleImgString != "") ? 1 : 0 ); // 是否为图片新闻
ht.Add( "titleImg", titleImgString ); // 图片新闻的图片路径
ht.Add( "topicid", TopicID.Value ); // 所属专题ID
ht.Add( "addUserid", user.userID); // 添加人ID
ht.Add( "summary", Summary.Text ); // 新闻简介
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -