牙科私人管理系统

与小组成员经历一个多月开发的项目

项目地址
想要账号密码的可以私我，或者自己破解进去进行操作！！！

1.1 客户预约管理
1.2 录用客户信息式。
1.3 预约信息查询式。
1.4 用户档案信息
1.5 用户治疗
1.6 用户反馈
1.7 账号管理
1.8 统计

效果图

using System;
using System.Collections.Generic;
using System.Linq;
using System.Security.Cryptography;
using System.Text;
using System.Web;
using WareHousing.Models;

namespace WareHousing.DAL
{
    public class ShangPinDAL
    {
        /// <summary>
        /// 查询所有商品
        /// </summary>
        /// <returns></returns>
        public static List<ShangPin> SelectAll()
        {
            using (WarehousingEntities db = new WarehousingEntities())
            {
                return db.ShangPin.ToList();
            }
        }
        /// <summary>
        /// 模糊查询商品
        /// </summary>
        /// <param name="Xiangqin">搜索内容</param>
        /// <returns></returns>
        public static List<ShangPin> SelectSousuo(string Sousuo)
        {
            using (WarehousingEntities db = new WarehousingEntities())
            {
                return db.ShangPin.Where(s => s.Sousuo.Contains(Sousuo)&& s.Sates == "已上架").ToList();
            }
        }
        /// <summary>
        /// 根据类别查询商品
        /// </summary>
        /// <param name="id">类别ID</param>
        /// <returns></returns>
        public static List<ShangPin> SelectBylb(int id)
        {
            using (WarehousingEntities db = new WarehousingEntities())
            {
                return db.ShangPin.Where(p => p.ShangpinlbID == id && p.Sates=="已上架").ToList();
            }
        }
        /// <summary>
        /// 根据ID查询商品
        /// </summary>
        /// <returns></returns>
        public static ShangPin SelectByID(int id)
        {
            using (WarehousingEntities db = new WarehousingEntities())
            {
                return db.ShangPin.Find(id);
            }
        }
        /// <summary>
        /// 增加订单数量
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        public static int UpdateByID(int id)
        {
            using (WarehousingEntities db = new WarehousingEntities())
            {
                var GouWuche = db.GouWuche.Find(id);
                GouWuche.Shuliang += 1;
                return db.SaveChanges();
            }
        }
        /// <summary>
        /// 减少订单数量
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        public static int UpdateByIDD(int id)
        {
            using (WarehousingEntities db = new WarehousingEntities())
            {
                var GouWuche = db.GouWuche.Find(id);
                if (GouWuche.Shuliang > 1)
                {
                    GouWuche.Shuliang -= 1;
                }
                return db.SaveChanges();
            }
        }
        /// <summary>
        /// 加入购物车
        /// </summary>
        /// <param name="gwc"></param>
        /// <returns></returns>
        public static int InsertGWC(GouWuche gwc)
        {
            using (WarehousingEntities db = new WarehousingEntities())
            {
                int aa = gwc.ShangPinID;
                GouWuche list = db.GouWuche.Where(p => p.ShangPinID == aa).FirstOrDefault();
                if (list != null)
                {
                    list.Shuliang++;
                    db.Entry<GouWuche>(list).State = System.Data.Entity.EntityState.Modified;
                    db.SaveChanges();
                }
                else
                {
                    db.GouWuche.Add(gwc);
                }
                return db.SaveChanges();
            }
        }
        /// <summary>
        /// 用户登录
        /// </summary>
        /// <param name="id">用户ID</param>
        /// <returns></returns>
        public static Login UserLogin(string Name)
        {
            using (WarehousingEntities db = new WarehousingEntities())
            {
                var list = db.Login.SingleOrDefault(p => p.LoginName == Name && p.ZhiWei == "普通用户");
                return list;
            }
        }
        /// <summary>
        /// 用户注册
        /// </summary>
        /// <param name="Name">用户名</param>
        /// <param name="Pwd">密码</param>
        /// <returns></returns>
        public static int UserRegister(string Name, string Pwd)
        {
            using (WarehousingEntities db = new WarehousingEntities())
            {
                var loginPwd = SHA256EncryptString(Pwd);
                Login aa = new Login();
                aa.LoginName = Name;
                aa.LoginPwd = loginPwd;
                aa.ZhiWei = "普通用户";
                db.Login.Add(aa);
                return db.SaveChanges();
            }
        }
        /// <summary>
        /// 密码加密
        /// </summary>
        /// <param name="pwd"></param>
        /// <returns></returns>
        private static string SHA256EncryptString(string pwd)
        {
            byte[] bytes = Encoding.UTF8.GetBytes(pwd);
            byte[] hash = SHA256Managed.Create().ComputeHash(bytes);
            StringBuilder builder = new StringBuilder();
            for (int i = 0; i < hash.Length; i++)
            {
                builder.Append(hash[i].ToString("x2"));
            }
            return builder.ToString();
        }
        /// <summary>
        /// 查询用户
        /// </summary>
        /// <param name="Name">用户名</param>
        /// <returns></returns>
        public static Login SelectUser(string Name)
        {
            using (WarehousingEntities db = new WarehousingEntities())
            {
                return db.Login.SingleOrDefault(p => p.LoginName == Name && p.ZhiWei == "普通用户");
            }
        }
    }
}

剩余效果图就不一一展示了