School_BLL/clsWeb/WebNavigation.cs

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

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

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

    public class WebNavigation : SkyTools
    {
        public string sSQL = string.Empty;
        public string sTableName = "SkyWebNavigation";

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

        [MethodImpl(MethodImplOptions.NoInlining)]
        public string BasicUpdateWebNavigationByID(S_SkyWebNavigation 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);
                    return str;
                }
                return "增加导航信息失败";
            }
            str3 = "select * from " + sTableName + " where id=" + sGet.iID;
            if (base.SkyDataUpDate(str3, sGet, false))
            {
                str = "更新导航信息成功";
                base.SkyWriteLog(SkyWriteLog_FuncID.System, SkyWriteLog_OprType.Update, "更新导航", "", sGet.iID, "", sUserID);
                return str;
            }
            return "更新导航信息失败";
        }

        [MethodImpl(MethodImplOptions.NoInlining)]
        public string BasicWebNavigationGet()
        {
            string str = "";
            this.sSQL = "select \r\n                NName,NInfo,NPara,MID,NTarget,\r\n                (select MURL+MPara from SkyWebModule where SkyWebModule.MID=SkyWebNavigation.MID) as MURL\r\n                from SkyWebNavigation order by ShowID asc";
            DataTable table = base.SkyDataCreateDT(this.sSQL);
            string format = "";