WebPortal_Lib/01.Lib/com/service/basic/URLService.cs

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

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

using System;
using System.Data;
using System.Configuration;
using System.Collections.Generic;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.Text;

using com.entity.basic;
using com.util;
using com.service.baseservice;
using com.constant;
using com.constant.common;
using com.util.common; 


namespace com.service.basic
{
    /// <summary>
    /// URLService：超链接
    /// </summary>
    public class URLService : BaseService
    {

        #region 属性

        #endregion

        #region 参数

        DataTable dt = new DataTable();
        DBUtil DBUtil = new DBUtil();
        List<URL> urlList = new List<URL>();
        new string strCommSearchSql = "";
        string strTable = SQLConstant.table_basic_url;
        string strViewTable = SQLConstant.table_basic_url;
        StringBuilder sb = new StringBuilder("");
        User currentUser = new User();
        UserService userService = new UserService();

        #endregion

        #region 构造方法
        public URLService()
        {
            strCommSearchSql = "select a.* from " + strViewTable + " a  where 1=1";
        }
        #endregion

        #region 根据sql获取List，名称：getListBySql
        /// <summary>
        /// 根据sql获取List，名称：getListBySql
        /// </summary>
        public List<URL> getListBySql(string _sql)
        {