BLL/Base2/MClassModels.cs

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

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;
using System.Text;
namespace BLL.Models
{
    public class MClassModels
    {
        string[] str_files = new string[] { "ID", "ClassName", "ParentId", "Depth", "RootId", "OrderId", "Readme", "Child", "Intro" };

        /// <summary>
        /// 添加信息
        /// </summary>
        /// <param name="?"></param>
        /// <returns></returns>
        public bool AddClassinfo(MODEL.MClassInfo model) {
        
            bool ret=false;
            model.RootId = 0;
            model.Child = 0;
            model.Depth = GetDepth(model.ParentId.ToString()) ;
            model.Readme = "";
            model.OrderId = 0;
            string str_sql = "insert into [tb_mc_class] (ClassName, ParentId, Depth, RootId, OrderId, Readme, Child, Intro)values('"+model.ClassName+"', "+model.ParentId.ToString()+", "+model.Depth.ToString()+", "+model.RootId.ToString()+", "+model.OrderId.ToString()+", '"+model.Readme+"', "+model.Child.ToString()+", '"+model.Intro+"')";
            Library.SqlProvider.OleDb db = new Library.SqlProvider.OleDb();
            try
            {
                db.ExecuteNonQuery(COMM.PucConfig.ConnectionStringA, CommandType.Text, str_sql);
                ret = true;
            }
            catch (Exception ex) { }
            return ret;
        }
        /// <summary>
        /// 修改一条信息
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public bool EditClassInfo(MODEL.MClassInfo model) {

            bool ret = false;
            model.RootId = 0;
            model.Child = 0;
            model.Depth = 0;
            model.Readme = "";
            model.OrderId = 0;
            string str_sql = " update [tb_mc_class] set ClassName='"+model.ClassName+"', ParentId="+model.ParentId.ToString()+", Depth="+model.Depth.ToString()+", RootId="+model.RootId.ToString()+", OrderId="+model.OrderId.ToString()+", Readme='"+model.Readme+"', Child="+model.Child.ToString()+", Intro='"+model.Intro+"' where id= " + model.ID;
            Library.SqlProvider.OleDb db = new Library.SqlProvider.OleDb();
            try
            {
                db.ExecuteNonQuery(COMM.PucConfig.ConnectionStringA, CommandType.Text, str_sql);
                ret = true;
            }
            catch (Exception ex) { }
            return ret;
        }
        /// <summary>
        /// 分页列表一个信息