医药销售管理系统sql语句文档格式.doc
- 文档编号:13030763
- 上传时间:2022-10-03
- 格式:DOC
- 页数:11
- 大小:53.50KB
医药销售管理系统sql语句文档格式.doc
《医药销售管理系统sql语句文档格式.doc》由会员分享,可在线阅读,更多相关《医药销售管理系统sql语句文档格式.doc(11页珍藏版)》请在冰豆网上搜索。
Cityvarchar(8))
createtableFirmInfor/*创建供应商信息表*/
(FirmCodechar(10)constraintF_PRIMPRIMARYKEY,
FirmNamevarchar(16)NOTNULL,
Linkvarchar(12),
LinkTellvarchar(11),
createtableWorkInfor/*创建员工信息表*/
(WorkNochar(10)constraintW_PRIMPRIMARYKEY,
Namevarchar(12),
UserRegNamechar(6)NOTNULL,
Passwordchar(10)NOTNULL,
Positionchar(10),
PowerInt)
createtablesellMain/*创建医药销售主表*/
(SaleNointconstraintSM_PRIMPRIMARYKEY,
WorkNochar(10)FOREIGNKEYREFERENCESWorkInfor(WorkNo),
SaleDateDateTime,
AmountMoney)
createtablesellChild/*创建医药销售子表*/
(SaleNointconstraintSC_PRIMPRIMARYKEY,
MedicineCodechar(6)FOREIGNKEYREFERENCESMedInfor(MedicineCode),
MedicineNamevarchar(32)NOTNULL,
PriceMoney,
NumberInt,
Uintchar(8),
/*插入数据的存储过程*/
createprocMedID_proc
@MedKindeCodechar(10),@KindExplanationvarchar(12)
as
insertintoMedID(MedKindeCode,KindExplanation)values(@MedKindeCode,@KindExplanation)
execMedID_proc'
0001'
'
口腔溃疡'
0002'
感冒'
0003'
发烧'
0004'
拉肚子'
0005'
'
外伤'
createprocMedInfor_proc
@MedicineCodechar(6),@MedicineNamevarchar(8),@MedKindeCodechar(10),@Pricemoney,@ListPricemoney,
@Numberint,@FirmCodechar(10),@UserfulllifeDatetime
insertintoMedInfor(MedicineCode,MedicineName,MedKindeCode,Price,ListPrice,
Number,Supplicer,Userfulllife)values(@MedicineCode,@MedicineName,@MedKindeCode,@Price,@ListPrice,
@Number,@FirmCode,@Userfulllife)
execMedInfor_proc'
1001'
板蓝根'
5,3,'
100'
014'
2010-12-5'
2002'
四季感康'
14,10.5,'
150'
051'
2010-12-12'
2003'
银黄颗粒'
12,8.8,'
120'
2012-10-6'
2004'
感冒清热软胶囊'
17,12,'
015'
'
2011-11-1'
3001'
阿斯匹林'
15,11,'
2010-12-1'
3002'
布洛芬'
21,17.5,'
120'
2010-6-5'
4001'
泻利挺'
25,20,'
2012-10-2'
4002'
诺氟沙星胶囊'
15,12,'
2012-9-16'
5001'
碘酒'
5,2.5,'
50'
2012-10-12'
5002'
创口贴'
2,1,'
250'
2015-5-1'
createprocGueInfor_proc
@GuestCodechar(10),@GuestNamevarchar(16),@GLinkvarchar(12),@GLinkTellvarchar(11),
@Cityvarchar(8)
insertintoGueInfor(GuestCode,GuestName,GLink,GLinkTell,
City)values(@GuestCode,@GuestName,@GLink,@GLinkTell,@City)
execGueInfor_proc'
015112'
zhangsan'
xiaozhang'
668401'
jiaxing'
065114'
lisi'
xiaofang'
614425'
yuyao'
052114'
wangwu'
xiaowu'
659024'
wenzhou'
043115'
zhaoliu'
615874'
shangyu'
014221'
awu'
651283'
linan'
025471'
asha'
691472'
dongyang'
createprocFirmInfor_proc
@FirmCodechar(10),@FirmNamevarchar(16),@Linkvarchar(12),@LinkTellvarchar(11),@Cityvarchar(8)
insertintoFirmInfor(FirmCode,FirmName,Link,LinkTell,City)
values(@FirmCode,@FirmName,@Link,@LinkTell,@City)
execFirmInfor_proc'
yangshengtang'
xiaotai'
681472'
huzhou'
baozhilin'
zhangqing'
658421'
deqing'
pinmingdayaofang'
oudan'
65417'
xiangshan'
createprocWorkInfor_proc
@WorkNochar(10),@Namevarchar(12),@UserRegNamechar(6),@Passwordchar(10),@Positionchar(10),@PowerInt
insertintoWorkInfor(WorkNo,Name,UserRegName,Password,Position,Power)
values(@WorkNo,@Name,@UserRegName,@Password,@Position,@Power)
execWorkInfor_proc'
075101'
ZKL'
zkl01'
456789'
jingli'
'
075201'
ZJM'
zjm01'
123789'
dongshi'
075215'
WMX'
wmx05'
147258'
xiaomi'
075120'
ZZW'
zzm20'
123456'
buzhang'
createprocsellMain_proc
@SaleNoint,@WorkNochar(10),@SaleDat
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 医药 销售 管理 系统 sql 语句