School_BLL/clsPublic/WebDepartment.cs

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

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

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

    public class WebDepartment : SkyTools
    {
        public string sSQL = string.Empty;
        public string sTableName = "SkyDepartment";

        [MethodImpl(MethodImplOptions.NoInlining)]
        public DataTable BasicGetDepartmentAll()
        {
            this.sSQL = "select SkyDID,SkyDName From " + this.sTableName + " order by ShowID Asc";
            return base.SkyDataCreateDT(this.sSQL);
        }

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

        [MethodImpl(MethodImplOptions.NoInlining)]
        public string BasicUpdateDepartmentByID(S_SkyDepartment 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 "更新院系信息失败";
        }