You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
27 lines
815 B
27 lines
815 B
-- 体检相关配置
|
|
-- 存储过程
|
|
-- GRANT EXECUTE ON OBJECT::dbo.MyStoredProcedure TO his;
|
|
-- 表
|
|
-- GRANT SELECT/INSERT/UPDATE/DELETE ON OBJECT::dbo.MyTable TO his;
|
|
-- 视图
|
|
-- GRANT SELECT ON OBJECT::dbo.MyView TO his;
|
|
|
|
-- his lisquery
|
|
GRANT EXECUTE ON OBJECT::dbo.PatientApplicationSheet TO his;
|
|
GRANT EXECUTE ON OBJECT::dbo.sp_Fee TO his;
|
|
GRANT EXECUTE ON OBJECT::dbo.sp_FeeInfo TO his;
|
|
GRANT EXECUTE ON OBJECT::dbo.sp_FeeResult TO his;
|
|
|
|
|
|
|
|
-- IsSend
|
|
ALTER TABLE Enrollment_FeeItem ADD IsSend bit DEFAULT 0;
|
|
|
|
update Enrollment_FeeItem set IsSend=0
|
|
update Enrollment_FeeItem set IsSend=1 where ID IN (
|
|
SELECT A.ID FROM
|
|
Enrollment_FeeItem A LEFT JOIN Enrollment_CheckCost B ON A.ORDERNO=B.ID
|
|
where A.OrderNo<>'' AND SendTime IS NOT NULL)
|
|
|
|
|
|
update [peisdb].[dbo].[Dict_Config] set Value='' where [Key]='WechatPayUrl' |