处方药划价收款处方药划价收款.doc

delete from 金额扣率对照表 go delete from 金额扣率对照表发布 go insert into 功能模块(模块编号, 组别, 模块, 描述, 模块类型, 程序文件, 菜单文件, 打印文件, 记帐参数, 打印参数) values(ypfy, 划价发药, 划价发药, 划价发药,11, ..\dbcard\yp发药, ..\mu1\填写,NULL, sf_yp划价发药 __操作员;;true;真的记帐吗;提示, NULL) go insert into 功能模块(模块编号, 组别, 模块, 描述, 模块类型, 程序文件, 菜单文件, 打印文件, 记帐参数, 打印参数) values(yphjzf, 划价作废, 划价作废, 划价作废,11, ..\dbcard\yp划价作废, ..\mu1\填写,NULL, sf_yp划价作废 __操作员;;true;真的作废吗;提示, NULL) go insert into 功能模块(模块编号, 组别, 模块, 描述, 模块类型, 程序文件, 菜单文件, 打印文件, 记帐参数, 打印参数) values(ypsk, 划价收款, 划价收款, 划价收款,11, ..\dbcard\yp收款, ..\mu1\填写,NULL, sf_yp划价收款 __操作员;;true;真的记帐吗;提示, NULL) go insert into 功能模块(模块编号, 组别, 模块, 描述, 模块类型, 程序文件, 菜单文件, 打印文件, 记帐参数, 打印参数) values(ypskls, 划价收款历史, 划价收款历史, 划价收款历史,11, ..\dbcard\yp收款历史, ..\mu1\查询,NULL,NULL, NULL) go if exists (select * from dbo.sysobjects where id = object_id(N[dbo].[svr临时销售日报]) and OBJECTPROPERTY(id, NIsUserTable) = 1) drop table [dbo].[svr临时销售日报] GO if exists (select * from dbo.sysobjects where id = object_id(N[dbo].[svr前台销售单]) and OBJECTPROPERTY(id, NIsUserTable) = 1) drop table [dbo].[svr前台销售单] GO if exists (select * from dbo.sysobjects where id = object_id(N[dbo].[svr前台销售单作废历史]) and OBJECTPROPERTY(id, NIsUserTable) = 1) drop table [dbo].[svr前台销售单作废历史] GO if exists (select * from dbo.sysobjects where id = object_id(N[dbo].[svr前台销售单明细]) and OBJECTPROPERTY(id, NIsUserTable) = 1) drop table [dbo].[svr前台销售单明细] GO if exists (select * from dbo.sysobjects where id = object_id(N[dbo].[svr前台销售单明细作废历史]) and OBJECTPROPERTY(id, NIsUserTable) = 1) drop table [dbo].[svr前台销售单明细作废历史] GO if exists (select * from dbo.sysobjects where id = object_id(N[dbo].[svr发货历史]) and OBJECTPROPERTY(id, NIsUserTable) = 1) drop table [dbo].[svr发货历史] GO if exists (select * from dbo.sysobjects where id = object_id(N[dbo].[svr发货明细历史]) and OBJECTPROPERTY(id, NIsUserTable) = 1) drop table [dbo].[svr发货明细历史] GO if exists (select * from dbo.sysobjects where id = object_id(N[dbo].[svr当日销售日报]) and OBJECTPROPERTY(id, NIsUserTable)