牙科私人管理系统

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

项目地址
想要账号密码的可以私我,或者自己破解进去进行操作!!!
系统功能图

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{/// /// 查询所有商品/// /// public static List<ShangPin> SelectAll(){using (WarehousingEntities db = new WarehousingEntities()){return db.ShangPin.ToList();}}/// /// 模糊查询商品/// /// 搜索内容/// public static List<ShangPin> SelectSousuo(string Sousuo){using (WarehousingEntities db = new WarehousingEntities()){return db.ShangPin.Where(s => s.Sousuo.Contains(Sousuo)&& s.Sates == "已上架").ToList();}}/// /// 根据类别查询商品/// /// 类别ID/// public static List<ShangPin> SelectBylb(int id){using (WarehousingEntities db = new WarehousingEntities()){return db.ShangPin.Where(p => p.ShangpinlbID == id && p.Sates=="已上架").ToList();}}/// /// 根据ID查询商品/// /// public static ShangPin SelectByID(int id){using (WarehousingEntities db = new WarehousingEntities()){return db.ShangPin.Find(id);}}/// /// 增加订单数量/// /// /// public static int UpdateByID(int id){using (WarehousingEntities db = new WarehousingEntities()){var GouWuche = db.GouWuche.Find(id);GouWuche.Shuliang += 1;return db.SaveChanges();}}/// /// 减少订单数量/// /// /// 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();}}/// /// 加入购物车/// /// /// 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();}}/// /// 用户登录/// /// 用户ID/// public static Login UserLogin(string Name){using (WarehousingEntities db = new WarehousingEntities()){var list = db.Login.SingleOrDefault(p => p.LoginName == Name && p.ZhiWei == "普通用户");return list;}}/// /// 用户注册/// /// 用户名/// 密码/// 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();}}/// /// 密码加密/// /// /// 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();}/// /// 查询用户/// /// 用户名/// public static Login SelectUser(string Name){using (WarehousingEntities db = new WarehousingEntities()){return db.Login.SingleOrDefault(p => p.LoginName == Name && p.ZhiWei == "普通用户");}}}
}

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


本文来自互联网用户投稿,文章观点仅代表作者本人,不代表本站立场,不承担相关法律责任。如若转载,请注明出处。 如若内容造成侵权/违法违规/事实不符,请点击【内容举报】进行投诉反馈!

相关文章

立即
投稿

微信公众账号

微信扫一扫加关注

返回
顶部