基于.NET框架的GSP医药管理系统原码

USE tytdyf_100831GO/* Object: StoredProcedure CSSPBMZDCreate Script Date: 05/25/2015 10:31:34 */SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO- =- Author: - Create date: 2009-12-28- Description: 新增商品信息- =ALTER PROCEDURE CSSPBMZDCreateCompanyID INT ,UserID VARCHAR(20) ,LB VARCHAR(20) ,ZJM VARCHAR(30) ,TM VARCHAR(30) ,KH VARCHAR(20) ,HH VARCHAR(20) ,PM VARCHAR(500) ,BM VARCHAR(500) ,GG VARCHAR(500) ,CD VARCHAR(500) ,LDW VARCHAR(20) ,CBJ DECIMAL(20, 6) ,ZZSL INT ,JJ DECIMAL(20, 6) ,LSJ DECIMAL(20, 6) ,LSJ1 DECIMAL(20, 6) ,MAX_SL DECIMAL(20, 6) ,MIN_SL DECIMAL(20, 6) ,XQ VARCHAR(100) ,SFCF BIT ,MJL INT ,ZY1 VARCHAR(50) ,ZY2 VARCHAR(50) ,BZ VARCHAR(50) ,JHR VARCHAR(20) ,PJ DECIMAL(20, 6) ,ZDJL DECIMAL(20, 6) ,JX VARCHAR(50) ,ZBZ INT ,ZCSB VARCHAR(100) ,PZWH VARCHAR(100) ,YSBZ VARCHAR(100) ,CCTJ VARCHAR(50) ,YPXZ VARCHAR(200) ,YPYT VARCHAR(200) ,RLFA VARCHAR(20) ,CBZKL DECIMAL(20, 6) ,-ONLYMONEY BIT ,ATTR VARCHAR(50) ,FKATTR VARCHAR(50) ,ISYBPZ BIT ,SJ DECIMAL(20, 6) ,TYBZ BIT ,JG9 DECIMAL(20, 6) ,ZDXJ DECIMAL(20, 6) ,SCDW VARCHAR(200) ,JFS FLOAT ,SFJF BIT ,RKCKBH int,RKXQYQ INT ,SDXQTS INT ,SFSYPZ BIT ,SFZDPZ BIT ,-CBHSFS INT ,SFCJPZ BIT ,IsYJM BIT ,TLPZBM VARCHAR(100) ,ZPXX VARCHAR(100) ,tgbz BIT ,JYFW INT ,TM1 VARCHAR(30),SFCFY BIT ,FLength INT ,FWidth INT ,FHeight INT ,FStack INT ,PFZDJL INT ,NewID INT OUT ,JDSJ DATETIME OUTAS BEGINDECLARE NewID2 INTDECLARE KDRQ DATETIMEDECLARE ONLYMONEY BITSET KDRQ = GETDATE()IF EXISTS ( SELECT 1 FROM SPBMZD WHERE hh = HH ) RETURN 2IF NOT EXISTS ( SELECT 1 FROM CSSPLB WHERE LBBH = LB ) RETURN 3SELECT JX = LTRIM(RTRIM(jx) , TLPZBM = LTRIM(RTRIM(TLPZBM),ATTR = LTRIM(RTRIM(ATTR), FKATTR = LTRIM(RTRIM(FKATTR),LDW = LTRIM(RTRIM(LDW)-剂型 IF JX AND NOT EXISTS(SELECT * FROM CSTLPZBM WHERE TLBM = TLPZBM)INSERT INTO CSTLPZBM ( TLBM, ZJM, BZ )VALUES ( TLPZBM, - TLBM - varchar(100)dbo.PY(TLPZBM), - ZJM - varchar(100) - BZ - varchar(100)-属性 IF ATTR AND NOT EXISTS(SELECT * FROM CSJLDW WHERE JLMC = LDW)INSERT INTO CSJLDW ( JLMC, ZJM, BZ )VALUES ( LDW, - JLMC - varchar(40)LEFT(dbo.py(LDW),10), - ZJM - varchar(10) - BZ - varchar(200)insert into CSSPLZ (LM,NAME, ZJM)select n, v, dbo.PY(v)from( select LDW v, LDW n union select FKATTR v, FKATTR n union select ATTR v, ATTR n union select LDW v, LDW n union select JX v, JX n union select CD v, CD n union select SCDW v, SCDW n union select YPXZ v, YPXZ n union select YPYT v, YPYT n union select YSBZ v, YSBZ n union select CCTJ v, CCTJ n union select ZCSB v, ZCSB n union select BZ v, BZ n union select ZY1 v, ZY1 n union select ZY2 v, ZY2 n union select TLPZBM v, TLPZBM n union select ZPXX v, ZPXX n ) as tabwhere rtrim(ltrim(isnull(tab.v, )0 AND FTYPE = 8)BEGIN-限量管控declare PFXLG_GK INTselect PFXLG_GK=max(