School_BLL/clsWeb/WebColumn.cs

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

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

namespace School_BLL.clsWeb
{
    using School_BLL;
    using School_Entity;
    using System;
    using System.Data;
    using System.Runtime.CompilerServices;

    public class WebColumn : SkyTools
    {
        public string sSQL = string.Empty;
        public string sTableName = "SkyWebColumn";

        [MethodImpl(MethodImplOptions.NoInlining)]
        public DataTable BasicGetWebColumnAll()
        {
            this.sSQL = "select ID,CName From " + this.sTableName;
            return base.SkyDataCreateDT(this.sSQL);
        }

        [MethodImpl(MethodImplOptions.NoInlining)]
        public S_SkyWebColumn BasicGetWebColumnByID(string sID)
        {
            this.sSQL = "select * From " + this.sTableName + " where id=" + sID;
            DataTable table = base.SkyDataCreateDT(this.sSQL);
            S_SkyWebColumn sStruct = new S_SkyWebColumn();
            if (table.Rows.Count >= 0)
            {
                sStruct = (S_SkyWebColumn) base.SkyReflectionUpdate(table.Rows[0], sStruct);
            }
            return sStruct;
        }

        [MethodImpl(MethodImplOptions.NoInlining)]
        public DataTable BasicGetWebColumnByPID(string sColumn)
        {
            if (sColumn == "")
            {
                this.sSQL = "select * From " + this.sTableName + " order by id desc";
            }
            else
            {
                this.sSQL = "select * From " + this.sTableName + " where parentID=" + sColumn + " order by id desc";
            }
            return base.SkyDataCreateDT(this.sSQL);
        }

        [MethodImpl(MethodImplOptions.NoInlining)]
        public string BasicUpdateWebColumnByID(S_SkyWebColumn sGet, string sUserID)
        {
            string str3;
            string str = string.Empty;
            string sTableName = this.sTableName;
            if ((sGet.iID == "") || (sGet.iID == null))
            {
                str3 = "select * from " + sTableName + " where 1=0";
                if (base.SkyDataUpDate(str3, sGet, true))
                {
                    str = "增加栏目信息成功";
                    base.SkyWriteLog(0, 0, "增加栏目", "", sUserID);