/// <summary>
/// 增加一条数据
/// </summary>
/// <param name="model">实体对象</param>
/// <returns>返回影响行数</returns>
public int Add(Arc_Article model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("INSERT INTO " + tablePrefix + "Arc_Article(");
strSql.Append("ClassID,ViceClassID,Title,ShortTitle,TitleStyle,TitleFlag,Tags,ImgUrl,Author,Editor,PubLisher,Source,Templet,Keywords,Description,AContent,Click,Good,Bad,Readaccess,Money,Attribute,IsComment,IsVerify,IsRecycle,IsRedirect,IsHtml,IsPaging,FilePath,SimilarArticle,AddDate,PubDate,OrderID)");
strSql.Append(" VALUES (");
strSql.Append("@ClassID,@ViceClassID,@Title,@ShortTitle,@TitleStyle,@TitleFlag,@Tags,@ImgUrl,@Author,@Editor,@PubLisher,@Source,@Templet,@Keywords,@Description,@AContent,@Click,@Good,@Bad,@Readaccess,@Money,@Attribute,@IsComment,@IsVerify,@IsRecycle,@IsRedirect,@IsHtml,@IsPaging,@FilePath,@SimilarArticle,@AddDate,@PubDate,@OrderID)");
SqlParameter[] cmdParms =
{
AddInParameter("@ClassID", SqlDbType.Int, 4, model.ClassID),
AddInParameter("@ViceClassID", SqlDbType.Int, 4, model.ViceClassID),
AddInParameter("@Title", SqlDbType.NVarChar, 100, model.Title),
AddInParameter("@ShortTitle", SqlDbType.NVarChar, 100, model.ShortTitle),
AddInParameter("@TitleStyle", SqlDbType.VarChar, 100, model.TitleStyle),
AddInParameter("@TitleFlag", SqlDbType.TinyInt, 1, model.TitleFlag),
AddInParameter("@Tags", SqlDbType.NVarChar, 100, model.Tags),
AddInParameter("@ImgUrl", SqlDbType.VarChar, 255, model.ImgUrl),
AddInParameter("@Author", SqlDbType.NVarChar, 50, model.Author),
AddInParameter("@Editor", SqlDbType.NVarChar, 50, model.Editor),
AddInParameter("@PubLisher", SqlDbType.NVarChar, 50, model.PubLisher),
AddInParameter("@Source", SqlDbType.NVarChar, 100, model.Source),
AddInParameter("@Templet", SqlDbType.VarChar, 255, model.Templet),
AddInParameter("@Keywords", SqlDbType.NVarChar, 200, model.Keywords),
AddInParameter("@Description", SqlDbType.NVarChar, 500, model.Description),
AddInParameter("@AContent", SqlDbType.NVarChar, 8, model.AContent),
AddInParameter("@Click", SqlDbType.Int, 4, model.Click),
AddInParameter("@Good", SqlDbType.Int, 4, model.Good),
AddInParameter("@Bad", SqlDbType.Int, 4, model.Bad),
AddInParameter("@Readaccess", SqlDbType.SmallInt, 2, model.Readaccess),
AddInParameter("@Money", SqlDbType.SmallInt, 2, model.Money),
AddInParameter("@Attribute", SqlDbType.SmallInt, 2, model.Attribute),
AddInParameter("@IsComment", SqlDbType.TinyInt, 1, model.IsComment),
AddInParameter("@IsVerify", SqlDbType.TinyInt, 1, model.IsVerify),
AddInParameter("@IsRecycle", SqlDbType.TinyInt, 1, model.IsRecycle),
AddInParameter("@IsRedirect", SqlDbType.TinyInt, 1, model.IsRedirect),
AddInParameter("@IsHtml", SqlDbType.TinyInt, 1, model.IsHtml),
AddInParameter("@IsPaging", SqlDbType.TinyInt, 1, model.IsPaging),
AddInParameter("@FilePath", SqlDbType.VarChar, 255, model.FilePath),
AddInParameter("@SimilarArticle", SqlDbType.VarChar, 200, model.SimilarArticle),
AddInParameter("@AddDate", SqlDbType.DateTime, 8, model.AddDate),
AddInParameter("@PubDate", SqlDbType.DateTime, 8, model.PubDate),
AddInParameter("@OrderID", SqlDbType.Int, 4, model.OrderID)
};
return(dbHelper.ExecuteNonQuery(CommandType.Text, strSql.ToString(), cmdParms));
}
/// <summary>
/// 获取文章实体，添加，修改
/// </summary>
/// <returns>文章实体</returns>
private Arc_Article GetArticleModel()
{
Arc_Article model = new Arc_Article();
model.ID = NewID;
model.ClassID = TypeConvert.ToInt32(slt_ClassName.Value.Trim());
model.ViceClassID = TypeConvert.ToInt32(txt_ViceClassID.Value.Trim(), -1);
model.Title = txt_Title.Value.Trim();
model.ShortTitle = txt_ShortTitle.Value.Trim();
model.TitleStyle = hide_TitleStyle.Value.Trim();
model.TitleFlag = TypeConvert.ToByte(slt_TitleFlag.Value);
model.Tags = txt_Tags.Value.Trim();
model.ImgUrl = txt_ImageUrl.Value.Trim();
model.Author = txt_Author.Value.Trim();
model.Editor = txt_Editor.Value.Trim();
model.PubLisher = ""; //当前用户
model.Source = txt_Source.Value.Trim();
model.Templet = txt_Templet.Value.Trim();
model.Keywords = txt_Keywords.Value.Trim();
model.Description = txt_Description.Value.Trim();
model.AContent = txt_Content.Value.Trim();
model.Click = 0;
model.Good = 0;
model.Bad = 0;
model.Readaccess = TypeConvert.ToInt16(slt_Readaccess.Value.Trim());
model.Money = TypeConvert.ToInt16(txt_Money.Value.Trim());
model.Attribute = TypeConvert.ToInt16(hide_Attribute.Value.Trim()); //文章属性
model.IsComment = (byte)(chk_IsComment.Checked ? 1 : 0);
model.IsVerify = (byte)(chk_IsVerify.Checked ? 1 : 0);
model.IsRecycle = (byte)0;
model.IsRedirect = (byte)(chk_JumpUrl.Checked ? 1 : 0);
model.IsHtml = (byte)(chk_IsHtml.Checked ? 1 : 0);
model.IsPaging = (byte)(rdo_Autopage.Checked ? 1 : 0);
model.FilePath = txt_FilePath.Value.Trim();
model.SimilarArticle = txt_SimilarArticle.Value.Trim();
model.AddDate = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
model.PubDate = Convert.ToDateTime(txt_PubDate.Value.Trim() == "" ? DateTime.Now.ToString("yyyy-MM-dd HH:ss:mm") : txt_PubDate.Value.Trim());
model.OrderID = int.Parse(txt_OrderID.Value.Trim() == "" ? "0" : txt_OrderID.Value.Trim());
return(model);
}
/// <summary>
/// 由一行数据得到一个实体
/// </summary>
/// <param name="dr">SqlDataReader对象</param>
/// <returns>实体对象</returns>
private Arc_Article GetModel(SqlDataReader dr)
{
Arc_Article model = new Arc_Article();
model.ID = dbHelper.GetInt(dr["ID"]);
model.ClassID = dbHelper.GetInt(dr["ClassID"]);
model.ViceClassID = dbHelper.GetInt(dr["ViceClassID"]);
model.Title = dbHelper.GetString(dr["Title"]);
model.ShortTitle = dbHelper.GetString(dr["ShortTitle"]);
model.TitleStyle = dbHelper.GetString(dr["TitleStyle"]);
model.TitleFlag = dbHelper.GetByte(dr["TitleFlag"]);
model.Tags = dbHelper.GetString(dr["Tags"]);
model.ImgUrl = dbHelper.GetString(dr["ImgUrl"]);
model.Author = dbHelper.GetString(dr["Author"]);
model.Editor = dbHelper.GetString(dr["Editor"]);
model.PubLisher = dbHelper.GetString(dr["PubLisher"]);
model.Source = dbHelper.GetString(dr["Source"]);
model.Templet = dbHelper.GetString(dr["Templet"]);
model.Keywords = dbHelper.GetString(dr["Keywords"]);
model.Description = dbHelper.GetString(dr["Description"]);
model.AContent = dbHelper.GetString(dr["AContent"]);
model.Click = dbHelper.GetInt(dr["Click"]);
model.Good = dbHelper.GetInt(dr["Good"]);
model.Bad = dbHelper.GetInt(dr["Bad"]);
model.Readaccess = dbHelper.GetInt16(dr["Readaccess"]);
model.Money = dbHelper.GetInt16(dr["Money"]);
model.Attribute = dbHelper.GetInt16(dr["Attribute"]);
model.IsComment = dbHelper.GetByte(dr["IsComment"]);
model.IsVerify = dbHelper.GetByte(dr["IsVerify"]);
model.IsRecycle = dbHelper.GetByte(dr["IsRecycle"]);
model.IsRedirect = dbHelper.GetByte(dr["IsRedirect"]);
model.IsHtml = dbHelper.GetByte(dr["IsHtml"]);
model.IsPaging = dbHelper.GetByte(dr["IsPaging"]);
model.FilePath = dbHelper.GetString(dr["FilePath"]);
model.SimilarArticle = dbHelper.GetString(dr["SimilarArticle"]);
model.AddDate = dbHelper.GetDateTime(dr["AddDate"]);
model.PubDate = dbHelper.GetDateTime(dr["PubDate"]);
model.OrderID = dbHelper.GetInt(dr["OrderID"]);
return(model);
}
/// <summary>
/// 更新，初始化页面数据
/// </summary>
/// <param name="NewID">文章ID</param>
private void SetPageData()
{
if (NewID <= 0)
{
return;
}
Arc_Article model = articleBll.GetModel(NewID);
if (model != null)
{
slt_TitleFlag.Value = model.TitleFlag.ToString();
txt_Title.Value = model.Title;
hide_Attribute.Value = model.Attribute.ToString();
hide_TitleStyle.Value = model.TitleStyle;
txt_Tags.Value = model.Tags;
slt_ClassName.SelectedIndex = slt_ClassName.Items.IndexOf(slt_ClassName.Items.FindByValue(model.ClassID.ToString()));
txt_Source.Value = model.Source;
txt_Author.Value = model.Author;
txt_Editor.Value = model.Editor;
txt_ImageUrl.Value = model.ImgUrl;
txt_Content.Value = model.AContent;
txt_ShortTitle.Value = model.ShortTitle.Trim();
txt_ViceClassID.Value = model.ViceClassID.ToString();
txt_OrderID.Value = model.OrderID.ToString();
txt_Templet.Value = model.Templet;
txt_FilePath.Value = model.FilePath;
txt_PubDate.Value = model.PubDate.ToString();
slt_Readaccess.Value = model.Readaccess.ToString();
txt_Money.Value = model.Money.ToString();
txt_SimilarArticle.Value = model.SimilarArticle;
txt_Keywords.Value = model.Keywords.Trim();
txt_Description.Value = model.Description;
//是否生成静态页
chk_IsHtml.Checked = (model.IsHtml == 1);
//是否允许评论
chk_IsComment.Checked = (model.IsComment == 1);
chk_IsVerify.Checked = (model.IsVerify == 1); //是否审核
}
}
/// <summary>
/// 更新一条数据
/// </summary>
/// <param name="model">实体对象</param>
/// <returns>返回影响行数</returns>
public int Update(Arc_Article model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
/// <param name="model">实体对象</param>
/// <returns>返回影响行数</returns>
public int Add(Arc_Article model)
{
return(dal.Add(model));
}
/// <summary>
/// 更新一条数据
/// </summary>
/// <param name="model">实体对象</param>
/// <returns>返回影响行数</returns>
public int Update(Arc_Article model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("UPDATE " + tablePrefix + "Arc_Article SET ");
strSql.Append("ClassID=@ClassID,");
strSql.Append("ViceClassID=@ViceClassID,");
strSql.Append("Title=@Title,");
strSql.Append("ShortTitle=@ShortTitle,");
strSql.Append("TitleStyle=@TitleStyle,");
strSql.Append("TitleFlag=@TitleFlag,");
strSql.Append("Tags=@Tags,");
strSql.Append("ImgUrl=@ImgUrl,");
strSql.Append("Author=@Author,");
strSql.Append("Editor=@Editor,");
strSql.Append("PubLisher=@PubLisher,");
strSql.Append("Source=@Source,");
strSql.Append("Templet=@Templet,");
strSql.Append("Keywords=@Keywords,");
strSql.Append("Description=@Description,");
strSql.Append("AContent=@AContent,");
strSql.Append("Click=@Click,");
strSql.Append("Good=@Good,");
strSql.Append("Bad=@Bad,");
strSql.Append("Readaccess=@Readaccess,");
strSql.Append("Money=@Money,");
strSql.Append("Attribute=@Attribute,");
strSql.Append("IsComment=@IsComment,");
strSql.Append("IsVerify=@IsVerify,");
strSql.Append("IsRecycle=@IsRecycle,");
strSql.Append("IsRedirect=@IsRedirect,");
strSql.Append("IsHtml=@IsHtml,");
strSql.Append("IsPaging=@IsPaging,");
strSql.Append("FilePath=@FilePath,");
strSql.Append("SimilarArticle=@SimilarArticle,");
strSql.Append("AddDate=@AddDate,");
strSql.Append("PubDate=@PubDate,");
strSql.Append("OrderID=@OrderID");
strSql.Append(" WHERE ID=@ID");
SqlParameter[] cmdParms =
{
AddInParameter("@ClassID", SqlDbType.Int, 4, model.ClassID),
AddInParameter("@ViceClassID", SqlDbType.Int, 4, model.ViceClassID),
AddInParameter("@Title", SqlDbType.NVarChar, 100, model.Title),
AddInParameter("@ShortTitle", SqlDbType.NVarChar, 100, model.ShortTitle),
AddInParameter("@TitleStyle", SqlDbType.VarChar, 100, model.TitleStyle),
AddInParameter("@TitleFlag", SqlDbType.TinyInt, 1, model.TitleFlag),
AddInParameter("@Tags", SqlDbType.NVarChar, 100, model.Tags),
AddInParameter("@ImgUrl", SqlDbType.VarChar, 255, model.ImgUrl),
AddInParameter("@Author", SqlDbType.NVarChar, 50, model.Author),
AddInParameter("@Editor", SqlDbType.NVarChar, 50, model.Editor),
AddInParameter("@PubLisher", SqlDbType.NVarChar, 50, model.PubLisher),
AddInParameter("@Source", SqlDbType.NVarChar, 100, model.Source),
AddInParameter("@Templet", SqlDbType.VarChar, 255, model.Templet),
AddInParameter("@Keywords", SqlDbType.NVarChar, 200, model.Keywords),
AddInParameter("@Description", SqlDbType.NVarChar, 500, model.Description),
AddInParameter("@AContent", SqlDbType.NVarChar, 8, model.AContent),
AddInParameter("@Click", SqlDbType.Int, 4, model.Click),
AddInParameter("@Good", SqlDbType.Int, 4, model.Good),
AddInParameter("@Bad", SqlDbType.Int, 4, model.Bad),
AddInParameter("@Readaccess", SqlDbType.SmallInt, 2, model.Readaccess),
AddInParameter("@Money", SqlDbType.SmallInt, 2, model.Money),
AddInParameter("@Attribute", SqlDbType.SmallInt, 2, model.Attribute),
AddInParameter("@IsComment", SqlDbType.TinyInt, 1, model.IsComment),
AddInParameter("@IsVerify", SqlDbType.TinyInt, 1, model.IsVerify),
AddInParameter("@IsRecycle", SqlDbType.TinyInt, 1, model.IsRecycle),
AddInParameter("@IsRedirect", SqlDbType.TinyInt, 1, model.IsRedirect),
AddInParameter("@IsHtml", SqlDbType.TinyInt, 1, model.IsHtml),
AddInParameter("@IsPaging", SqlDbType.TinyInt, 1, model.IsPaging),
AddInParameter("@FilePath", SqlDbType.VarChar, 255, model.FilePath),
AddInParameter("@SimilarArticle", SqlDbType.VarChar, 200, model.SimilarArticle),
AddInParameter("@AddDate", SqlDbType.DateTime, 8, model.AddDate),
AddInParameter("@PubDate", SqlDbType.DateTime, 8, model.PubDate),
AddInParameter("@OrderID", SqlDbType.Int, 4, model.OrderID),
AddInParameter("@ID", SqlDbType.Int, 4, model.ID)
};
return(dbHelper.ExecuteNonQuery(CommandType.Text, strSql.ToString(), cmdParms));
}
protected void Btn_Submit_Click(object sender, EventArgs e)
{
int updateStart = 0; //更新是否成功
Arc_Article modelArticle = GetArticleModel();
#region 数据验证
if (modelArticle.ClassID <= 0 || !bllClass.Exists(modelArticle.ClassID, "", ""))
{//栏目不存在
Message.Dialog("操作失败！文章所选栏目不存在。", "-1", MessageIcon.Error, 0);
return;
}
if (modelArticle.Title.Trim() == "")
{//文章标题为空
Message.Dialog("操作失败！文章标题不能为空。", "-1", MessageIcon.Error, 0);
return;
}
if (articleBll.ExistsArticleName(NewID, modelArticle.Title))
{//文章已经存在
Message.Dialog("操作失败！该文章已经存在。", "-1", MessageIcon.Error, 0);
return;
}
#endregion 数据验证
if (NewID > 0)
{
try
{
updateStart = articleBll.Update(modelArticle);
}
catch
{
Message.Dialog("更新文章失败！更新文章出现未知错误。", "-1", MessageIcon.Success, 0);
return;
}
if (updateStart > 0)
{
Message.Dialog("更新文章成功！", "News_list.aspx", MessageIcon.Success, 0);
return;
}
else
{
Message.Dialog("更新文章失败！请检查数据是否完整。", "-1", MessageIcon.Success, 0);
return;
}
}
else
{
if (modelArticle.IsRedirect == 1)
{
//是否是跳转地址
if (txt_Redirect.Value.Trim().Length == 0)
{
Message.Dialog("操作失败！跳转地址不能为空。", "-1", MessageIcon.Error, 0);
return;
}
modelArticle.FilePath = txt_Redirect.Value.Trim();
modelArticle.AContent = "";
}
try
{
updateStart = articleBll.Add(modelArticle);
}
catch
{
Message.Dialog("添加文章失败！添加文章出现未知错误。", "-1", MessageIcon.Success, 0);
return;
}
if (updateStart > 0)
{
Message.Dialog("添加文章成功！", "News_list.aspx", MessageIcon.Success, 0);
return;
}
else
{
Message.Dialog("添加文章失败！请检查数据是否完整。", "-1", MessageIcon.Success, 0);
return;
}
}
}
