App_Code/NewsManager.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Data;
using System.Data.SqlClient;
using System.Text;

//该源码下载自www.51aspx.com(５１ａｓｐｘ．ｃｏｍ)

/// <summary>
/// 新闻处理的操作类
/// </summary>
public class NewsManager
{
    //定义常量表示字段名称或SQL语句。
    private const string SQL_INSERT_NEWSINFO = "INSERT INTO newsinfo VALUES(@title,@data,@date, @imageurl,@category)";
    private const string PARM_NEWS_TITLE = "@title";
    private const string PARM_NEWS_DATA = "@data";
    private const string PARM_NEWS_DATE = "@date";
    private const string PARM_NEWS_CATEGORY = "@category";
    private const string PARM_NEWS_IMAGEURL = "@imageurl";

	public NewsManager()
	{	}
    /// <summary>
    /// 添加新闻
    /// </summary>
    /// <param name="newsTitle">新闻主题</param>
    /// <param name="newsData">新闻内容</param>
    /// <param name="newsCategory">新闻类别</param>
    /// <param name="imageUrl">新闻的图片连接地址</param>
    /// <returns>添加是否成功</returns>
    public bool AddNews(string newsTitle, string newsData, string newsCategory, string imageUrl)
    {
        //使用StringBuild连接字符串比使用“+”效率高很多
        StringBuilder strSQL = new StringBuilder();
        //获取缓存参数，如果没有，此方法会自动创建缓存列表
        SqlParameter[] newsParms = GetParameters();
        //创建执行语句的SQL命令
        SqlCommand cmd = new SqlCommand();
        // 依次给参数赋值
        newsParms[0].Value = newsTitle;
        newsParms[1].Value = newsData;
        //注意新闻发布的日期取当日
        newsParms[2].Value = DateTime.Now;
        newsParms[3].Value = imageUrl;
        newsParms[4].Value = newsCategory;

        //遍历所有参数，并将参数添加到SqlCommand命令中
        foreach (SqlParameter parm in newsParms)
            cmd.Parameters.Add(parm);
        //获取数据库的连接字符串
        using (SqlConnection conn = new SqlConnection(SqlHelper.ConnectionStringLocalTransaction))
        {
            strSQL.Append(SQL_INSERT_NEWSINFO);
            //打开数据库连接，执行命令
            conn.Open();
            //设置Sqlcommand命令的属性
            cmd.Connection = conn;
            cmd.CommandType = CommandType.Text;
            cmd.CommandText = strSQL.ToString();
            //执行添加的SqlCommand命令