CSWDAL/DALcontents.cs

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

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Web.UI;
using System.Web;
using CSWModel;
using DBUtility;
using System.Data.OleDb;
using System.Web.UI.WebControls;

namespace CSWDAL
{
   public class DALcontents
   {

       #region 后台页面代码
       #region 添加内容
       /// <summary>
       /// 添加内容
       /// </summary>
       /// <param name="contentsModel"></param>
       /// <returns></returns>
       public static bool InsertContents(Modelcontents contentsModel)
       {
           StringBuilder strsql = new StringBuilder();
           strsql.Append("insert into csw_contents(");
           strsql.Append("csw_title,csw_typeId,csw_author,csw_tag,csw_keywords,csw_description,csw_contents,csw_img,csw_tj,csw_click,csw_times");
           strsql.Append(")");
           strsql.Append("values(");
           strsql.Append("'"+contentsModel.csw_title+"','"+contentsModel.csw_typeId+"','"+contentsModel.csw_author+"',");
           strsql.Append("'"+contentsModel.csw_tag+"','"+contentsModel.csw_keywords+"','"+contentsModel.csw_description+"',");
           strsql.Append("'"+contentsModel.csw_contents+"','"+contentsModel.csw_img+"','"+contentsModel.csw_tj+"',");
           strsql.Append("'"+contentsModel.csw_click+"','"+contentsModel.csw_times+"'");
           strsql.Append(")");
           int reValue = new AcsHelper().ExecuteNonQuery(strsql.ToString());
           if (reValue > 0)
           {
               return true;
           }
           else
           {
               return false;
           }
       }
       #endregion

       #region 根据Id读取内容字段信息
       public static List<Modelcontents> ReadContentsById(string Id)
       {
           List<Modelcontents> clist = new List<Modelcontents>();
           Modelcontents contentsModel = new Modelcontents();//实例化内容模型
           StringBuilder strsql = new StringBuilder();
           strsql.Append("select * from csw_contents where Id="+Id+"");
           DataSet ds = new AcsHelper().ExecuteDataSet(strsql.ToString());
           if (ds.Tables[0].Rows.Count > 0)
           {
               contentsModel.Id =Convert.ToInt32( ds.Tables[0].Rows[0][0].ToString());
               contentsModel.csw_title = ds.Tables[0].Rows[0][1].ToString();