北京鲁丰零售销货退货单据控制sql

1、北京鲁丰零售销货退货单据控制SQ1. tXt第一次笑是因为遇见你，第一次哭是因为你不在,第一次笑着流泪是因为不能拥有你。-一单据日期判断alter trigger lc_xh_i nsertu pdate on t_B0S200000088 for insert, up datedeclare dqn as intdeclare dqy as intdeclare dqnl as intdeclare dqyl as intselectdqn=fvaluefkey='curre ntyearjselectdqy=fvaluefkey=* curre ntp eriod1fromt_sy

2、ste mp rofilewherefcategory='IC'fromt_syste mp rofilewherefcategory=，IC'andandselect ©dqn l=year(fdate), ©dqy1= mon th(fdate)from in sertedraiserror(c onvert(n varchar(4), d qn ),16,1)raiserror(c onvert(n varchar(2), dqy), 16, 1)raiserror(c onvert(n varchar (4), d qn 1),16,1)ra

3、iserror(co nvert( nvarchar(2), dqyl), 16, 1)if (dq *>dqnl) and (dqy<>dqyl)beginrollback tranraiserror （»单据日期不在当前期内，不能保存单据！'，16,1）end反审核判断create trigger lc_xh_u pdate on t_BOS200000088 for up date as declare fcheckeridl as int declare fcheckerid2 as int declare fbno as varchar(30) s

4、et nocount on select fcheckeridl=fcheckerid, fb no=fbill no from deleted select fcheckerid2=fcheckerid from in serted if (Sfcheckeridl <>0) and (fcheckerid2 =0),inner join icstockbillb onIF EXISTS (select * from icstockbillentrya.fi nterid=b. fi nterid where fsourcebill no=fbno and b. ftra nty

5、p e=41) begin ROLLBACK TRAN raiserrorC单据已下推调拨单，不能反审核！end,16, 1)单据删除判断create trigger lc_xh_del on t_BOS200000088 for delete asdeclare fbno as varchar(30) set nocount on select fbno=fbill no from deletedIF EXISTS (select * from icstockbillentrya inner join icstockbillb ona. fi nterid=b. fi nteridwhere

6、 fsourcebil Inofbno and b. ftra ntyp e=41) beginROLLBACK TRAN raiserror (,单据己下推调拨单，不能删除！end', 16, 1)单据日期判断alter trigger lc_th_ in sertu pdate on t_B0S200000018 for in sert, up datedeclare dqn as intdeclare dqy as intdeclare dqnl as intdeclare dqyl as intselectdqn=fvaluefromt_syste mp rofilewhere

7、 fcategory='IC'andfkey='curre ntyearjselectdqy=fvaluefromt_syste mp rofilewhere fcategory=，IC*andfkey='curre ntp eriod'select ©dqn l=year (fdate), dqyl= mon th(fdate) from in serted raiserror(dqn , 16, 1)raiserror(dqy, 16, 1)raiserror(dq nl,16,1)raiserror(dqyl, 16, 1)if (dq

8、*> dq nl) and (dqy<>dqyl) beginrollback tranraiserror ()end单据日期不在当前期内，不能保存单据！'，16, 1)反审核判断create trigger lc_th_u pdate on t_B0S200000018for up dateasdeclare fcheckeridl as intdeclare fcheckerid2 as intdeclare fbno as varchar(30)set nocount onselect fcheckeridl=fcheckerid, fb no=fbill no

9、 from deletedselect fcheckerid2=fcheckerid from in sertedif (fcheckeridl<>0) and (fcheckerid2=0)IF EXISTS (select * from icstockbillentrya. fi nterid=b. fi nteridinner join icstockbillb onwhere fsourcebill no=fbno and b. ftra ntyp e=41) beginROLLBACK TRANraiserror (,单据己下推调拨单，不能反审核！ 16, 1) end-

10、单据删除判断create trigger lc_th_del on t_BOS200000018 for delete asdeclare fbno as varchar(30) set nocount on select fbno=fbill no from deletedIF EXISTS (select * from icstockbillentrya inner join icstockbillb ona.fi nterid=b. fi nteridwhere fsourcebil In。=fbno and b. ftra ntyp e=41) beginROLLBACK TRANra

11、iserror ()单据己下推调拨单，不能删除！-16,1)end出师表两汉：诸葛亮先帝创业未半而中道崩殂，今天下三分，益州疲弊，此诚危急存亡之秋也。然侍卫之臣不懈 于内，忠志之士忘身于外者，盖追先帝之殊遇，欲报之于陛下也。诚宜开张圣听，以光先帝遗德, 恢弘志士之气，不宜妄自菲薄，引喻失义，以塞忠谏之路也。宫中府中，俱为一体；陟罚臧否，不宜异同。若有作奸犯科及为忠善者，宜付有司论其刑 赏，以昭陛下平明之理；不宜偏私，使内外异法也。侍中、侍郎郭攸之、费祎、董允等，此皆良实，志虑忠纯，是以先帝简拔以遗陛下：愚以为 宫中之事，事无大小，悉以咨之，然后施行，必能裨补阙漏，有所广益。将军向宠，性行淑均，

12、晓畅军事，试用于昔日，先帝称之曰愚以为营 能”是以众议举宠为督: 中之事，悉以咨之，必能使行阵和睦，优劣得所。亲贤臣，远小人，此先汉所以兴隆也；亲小人，远贤臣，此后汉所以倾颓也。先帝在时，每与臣论此事，未尝不叹息痛恨于桓、灵也。侍中、尚书、长史、参军，此悉贞良死节之臣，愿陛下亲之、信之，则汉室之隆，可计日而待也ur 0臣本布衣，躬耕于南阳，苟全性命于乱世，不求闻达于诸侯。先帝不以臣卑鄙，猥自枉屈， 三顾臣于草庐之中，咨臣以当世之事，由是感激，遂许先帝以驱驰。后值倾覆，受任于败军之际, 奉命于危难之间，尔来二十有一年矣。先帝知臣谨慎，故临崩寄臣以大事也。受命以来，夙夜忧叹，恐托付不效，以伤先帝之明; 故五月渡泸，深