资源描述:
《基于.net框架的gsp医药管理系统原码》由会员上传分享,免费在线阅读,更多相关内容在学术论文-天天文库。
1、USE[tytdyf_100831]GO/******Object:StoredProcedure[dbo].[proCSSPBMZDCreate]ScriptDate:05/25/201510:31:34******/SETANSI_NULLSONGOSETQUOTED_IDENTIFIERONGO--=============================================--Author:--Createdate:2009-12-28--Description:新增商品信息--==============================
2、===============ALTERPROCEDURE[dbo].[proCSSPBMZDCreate]@CompanyIDINT,@UserIDVARCHAR(20),@LBVARCHAR(20),@ZJMVARCHAR(30),@TMVARCHAR(30),@KHVARCHAR(20),@HHVARCHAR(20),@PMVARCHAR(500),@BMVARCHAR(500),@GGVARCHAR(500),@CDVARCHAR(500),@LDWVARCHAR(20),@CBJDECIMAL(20,6),@ZZSLINT,@JJDECIMAL(20,6),@LSJDECIM
3、AL(20,6),@LSJ1DECIMAL(20,6),@MAX_SLDECIMAL(20,6),@MIN_SLDECIMAL(20,6),@XQVARCHAR(100),@SFCFBIT,@MJLINT,@ZY1VARCHAR(50),@ZY2VARCHAR(50),@BZVARCHAR(50),@JHRVARCHAR(20),@PJDECIMAL(20,6),@ZDJLDECIMAL(20,6),@JXVARCHAR(50),@ZBZINT,@ZCSBVARCHAR(100),@PZWHVARCHAR(100),@YSBZVARCHAR(100),@CCTJVARCHAR(50),
4、@YPXZVARCHAR(200),@YPYTVARCHAR(200),@RLFAVARCHAR(20),@CBZKLDECIMAL(20,6),--@ONLYMONEYBIT,@ATTRVARCHAR(50),@FKATTRVARCHAR(50),@ISYBPZBIT,@SJDECIMAL(20,6),@TYBZBIT,@JG9DECIMAL(20,6),@ZDXJDECIMAL(20,6),@SCDWVARCHAR(200),@JFSFLOAT,@SFJFBIT,@RKCKBHint,@RKXQYQINT,@SDXQTSINT,@SFSYPZBIT,@SFZDPZBIT,--@CB
5、HSFSINT,@SFCJPZBIT,@IsYJMBIT,@TLPZBMVARCHAR(100),@ZPXXVARCHAR(100),@tgbzBIT,@JYFWINT,@TM1VARCHAR(30),@SFCFYBIT,@FLengthINT,@FWidthINT,@FHeightINT,@FStackINT,@PFZDJLINT,@NewIDINTOUT,@JDSJDATETIMEOUTASBEGINDECLARE@NewID2INTDECLARE@KDRQDATETIMEDECLARE@ONLYMONEYBITSET@KDRQ=GETDATE()IFEXISTS(SELECT1F
6、ROMSPBMZDWHEREhh=@HH)RETURN2IFNOTEXISTS(SELECT1FROMCSSPLBWHERELBBH=@LB)RETURN3SELECT@JX=LTRIM(RTRIM(@jx)),@TLPZBM=LTRIM(RTRIM(@TLPZBM)),@ATTR=LTRIM(RTRIM(@ATTR)),@FKATTR=LTRIM(RTRIM(@FKATTR)),@LDW=LTRIM(RTRIM(@LDW))--剂型IF@JX<>''ANDNOTEXISTS(SELECT*FROMCSJXWHERENAME=@JX)INSERTINTOCSJX(NAME,ZJM)VA
7、LUES(@JX,--NAME-varchar(20)LEFT(dbo.PY(@JX),10)--ZJM-varchar(10))--同品编码IF@TLPZBM<>''ANDNOTEXISTS(SELECT*FROMCSTLPZBMWHERETLBM=@TLPZBM)INSERTINTOCSTLPZBM(TLBM,ZJM,BZ)VALUES(@TLPZBM,--TLBM-varchar(100)dbo.PY(@TLPZBM),--ZJM-var