SqlDataClass/BaseData.cs

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

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace SqlDataClass
{
    public class BaseData
    {
        private static BaseData _commclass;
        private static object obj =new object();
        public static BaseData Instanse
        {
            get {
                lock (obj)
                {
                    _commclass = _commclass ?? new BaseData();
                    return _commclass;
                }
            }
        }


        #region Manager
        public List<Manager> GetManager()
        {
            using (var db=new JobsOnlineEntities())
            {
                return db.Manager.ToList();
            }
        }
        public Manager SelectManagerByName(string Mname)
        {
            using (var db = new JobsOnlineEntities())
            {
                return db.Manager.Where(p=>p.username ==Mname).FirstOrDefault();
            }
        }
        public void InsertManager(Manager manager)
        {
            using (var db=new JobsOnlineEntities())
            {
                db.Manager.AddObject(manager);
                db.SaveChanges();
            }
        }
        public void UpdateManager(Manager manager)
        {
            using (var db=new JobsOnlineEntities())
            {
                Manager _manager = db.Manager.Where(p => p.id == manager.id).FirstOrDefault();
                _manager.username = manager.username;
                _manager.userpwd = manager.userpwd;
                _manager.permiss = manager.permiss;
                db.SaveChanges();
            }
        }

        public void DeleteManager(int Mid)
        {