School_BLL/clsPublic/WebClass.cs

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

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

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

    public class WebClass : SkyTools
    {
        public string sSQL = string.Empty;
        public string sTableName = "SkyClass";

        [MethodImpl(MethodImplOptions.NoInlining)]
        public DataTable BasicGetClassALL()
        {
            this.sSQL = "select SkyCID,SkyCName,SkyPID,SkyDID From " + this.sTableName + " order by ID Asc";
            return base.SkyDataCreateDT(this.sSQL);
        }

        [MethodImpl(MethodImplOptions.NoInlining)]
        public DataTable BasicGetClassByDID(string sDID)
        {
            this.sSQL = "select SkyCID,SkyCName From " + this.sTableName + " Where SkyDID='" + sDID + "'order by ID Asc";
            return base.SkyDataCreateDT(this.sSQL);
        }

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

        [MethodImpl(MethodImplOptions.NoInlining)]
        public DataTable BasicGetClassByPID(string sPID)
        {
            this.sSQL = "select SkyCID,SkyCName From " + this.sTableName + " Where SkyPID='" + sPID + "'order by ID Asc";
            return base.SkyDataCreateDT(this.sSQL);
        }

        [MethodImpl(MethodImplOptions.NoInlining)]
        public string BasicUpdateClassByID(S_SkyClass 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);