DB_51aspx/02_SaleManagerDB_Data（测试数据）.sql

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

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

use SaleManagerDB
go
--管理员信息
insert into SysAdmins(LoginPwd,AdminName,AdminStatus,RoleId)
values('11223344','王永利',1,1)
insert into SysAdmins(LoginPwd,AdminName,AdminStatus,RoleId)
values('11223344','张红梅',1,2)
insert into SysAdmins(LoginPwd,AdminName,AdminStatus,RoleId)
values('11223344','刘丽娜',1,2)
insert into SysAdmins(LoginPwd,AdminName,AdminStatus,RoleId)
values('11223344','王惠惠',0,2)
--销售员信息
insert into  SalesPerson(SPName,LoginPwd) values('王丽丽','123456')
insert into  SalesPerson(SPName,LoginPwd) values('王小刚','123456')
insert into  SalesPerson(SPName,LoginPwd) values('王大力','123456')
--超市会员信息
insert into SMMembers(MemberName,Points,PhoneNumber,MemberAddress,OpenTime,MemberStatus)
values('王晓敏',default,'13590856789','天津南开区',default,default)
insert into SMMembers(MemberName,Points,PhoneNumber,MemberAddress,OpenTime,MemberStatus)
values('刘全明',default,'13590856788','天津河北区',default,default)
insert into SMMembers(MemberName,Points,PhoneNumber,MemberAddress,OpenTime,MemberStatus)
values('赵大力',default,'13590856785','天津红桥区',default,default)
insert into SMMembers(MemberName,Points,PhoneNumber,MemberAddress,OpenTime,MemberStatus)
values('王文才',default,'13590856782','天津东丽区',default,default)
insert into SMMembers(MemberName,Points,PhoneNumber,MemberAddress,OpenTime,MemberStatus)
values('李兆新',default,'13590856781','天津河西区',default,default)
--商品分类数据
insert into ProductCategory(CategoryName) values('饮料')--1
insert into ProductCategory(CategoryName) values('副食')--2
insert into ProductCategory(CategoryName) values('面食')--3
insert into ProductCategory(CategoryName) values('肉类')--4
insert into ProductCategory(CategoryName) values('米类')--5
insert into ProductCategory(CategoryName) values('酒类')--6
insert into ProductCategory(CategoryName) values('烟类')--7
insert into ProductCategory(CategoryName) values('文具')--8
insert into ProductCategory(CategoryName) values('玩具')--9
insert into ProductCategory(CategoryName) values('日用品')--10
--商品计量单位
insert into ProductUnit values('箱')
insert into ProductUnit values('瓶')
insert into ProductUnit values('盒')
insert into ProductUnit values('本')
insert into ProductUnit values('袋')
insert into ProductUnit values('只')
insert into ProductUnit values('条')
insert into ProductUnit values('桶')
insert into ProductUnit values('打')
insert into ProductUnit values('听')
insert into ProductUnit values('罐')
insert into ProductUnit values('张')
insert into ProductUnit values('块')
insert into ProductUnit values('床')
insert into ProductUnit values('把')
insert into ProductUnit values('台')
insert into ProductUnit values('个')
--商品信息
insert into Products (ProductId,ProductName,UnitPrice,Unit,Discount,categoryId)
values('6005004003001','康师傅牛肉面',40.00,'箱',0,3)
insert into Products (ProductId,ProductName,UnitPrice,Unit,Discount,categoryId)