CSWDAL/DALcommon.cs

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

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using DBUtility;
namespace CSWDAL
{
   public class DALcommon
   {

       #region 获取栏目ID
       /// <summary>
       /// 获取栏目ID
       /// </summary>
       /// <param name="typeId"></param>
       /// <returns></returns>
       public static string SelectChannelId(string typeId)
       {
           string channelID = "";
           string strsql = "select id from csw_channel where id="+typeId;
           DataSet ds = new AcsHelper().ExecuteDataSet(strsql);
           if (ds.Tables[0].Rows.Count > 0)
           {
               channelID = ds.Tables[0].Rows[0][0].ToString();
           }
           return channelID;
       }
       #endregion

       #region 查询某表字段信息
       /// <summary>
       /// 查询某表字段信息
       /// </summary>
       /// <param name="FieldName">要查询的字段名</param>
       /// <param name="TableName">表名</param>
       /// <param name="FieldId">一般为表主键</param>
       /// <param name="paramID">参数id值</param>
       /// <returns>返回字段信息</returns>
       public static string SelectFieldInfoByFieldName(string FieldName, string TableName, string FieldId, string paramID)
       {
           string strContents = "";
           string strsql = "select " + FieldName + " from " + TableName + " where " + FieldId + "= " + paramID;
           DataSet ds = new AcsHelper().ExecuteDataSet(strsql);
           if (ds.Tables[0].Rows.Count > 0)
           {
               strContents = ds.Tables[0].Rows[0][0].ToString();
           }
           return strContents;
       }
       #endregion

       #region 过滤html标签和截取字符串 重载
       /// <summary>
       /// 过滤html标签和截取字符串
       /// </summary>
       /// <param name="strContents"></param>
       /// <returns></returns>
       public static string CheckStrAndHtmlGL(string strContents)
       {