CSWDAL/DALBaseWeb.cs

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using CSWModel;
using DBUtility;
namespace CSWDAL
{
   public class DALBaseWeb
    {
       public static List<Modelbaseweb> LoadBaseWeb(string BaseID)
       {
           List<Modelbaseweb> lt = new List<Modelbaseweb>();
           Modelbaseweb baseweb = new Modelbaseweb();
           string strsql = "select * from csw_webbase where csw_baseid="+BaseID;
           DataSet ds = new AcsHelper().ExecuteDataSet(strsql);
           if (ds.Tables[0].Rows.Count > 0)
           {
               baseweb.csw_basecontents = ds.Tables[0].Rows[0][1].ToString();
           }
           lt.Add(baseweb);
           return lt;
               
       }

       public static bool UpdateBaseWeb(string BaseID,Modelbaseweb baseWeb)
       {
           string strsql = "update csw_webbase set csw_basecontents='"+baseWeb.csw_basecontents+"' where csw_baseid="+BaseID;
           int reValue = new AcsHelper().ExecuteNonQuery(strsql);
           if (reValue > 0)
           {
               return true;
           }
           else
           {
               return false;
           }
       }
       public static string SelectBaseContents(string BaseID)
       {
           string strContents = "";
           string strsql = "select csw_basecontents from csw_webbase where csw_baseid="+BaseID;
           DataSet ds = new AcsHelper().ExecuteDataSet(strsql);
           if (ds.Tables[0].Rows.Count > 0)
           {
              strContents = ds.Tables[0].Rows[0][0].ToString();
           }
           return strContents;
       }
    }
}