School_BLL/clsWeb/WebProduct.cs

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

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

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

    public class WebProduct : SkyTools
    {
        public string sSQL = string.Empty;
        public string sTableName = "SkyWebProduct";

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

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

        [MethodImpl(MethodImplOptions.NoInlining)]
        public DataTable BasicGetWebProductBySort(string sProductSort, int iNumber)
        {
            if (sProductSort == "")
            {
                this.sSQL = "select top " + iNumber.ToString() + " * From " + this.sTableName + " order by ShowID Desc,id desc";
            }
            else
            {
                this.sSQL = "select top " + iNumber.ToString() + " * From " + this.sTableName + " where parentid=" + sProductSort + " order by ShowID Desc,id desc";
            }
            return base.SkyDataCreateDT(this.sSQL);
        }

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