By love

销售系统里删除提货单据时用到的表及操作（未开出时）
delete from x_fhhw where fhid =2604
DELETE FROM x_fh WHERE id = 2604
UPDATE x_hthw SET fh_sl = 0, fh_je = 0 WHERE id = 5854 AND fh_sl = 1 AND fh_je = 10
update x_xydj set id =197 where id =197
update x_xydj SET fpje =0.0000 , fhje =0.0000 , skje =0.0000 , htje =10.0000 WHERE id =197

如果已开出，执行以下语句解除开出状态
UPDATE x_fh SET iskp = 0 WHERE id = 2535

修改密码的语句,修改后用户密码为空

update secuser set pwd=’d41d8cd98f00b204e9800998ecf8427e’ where name=’修改人的名字’

根据版本不同密码保存的表还有
b_qx
z_qx
 

删除掉项目语句
select * from z_items
select * from z_projkm
delete from z_items where dm like ’2%’
delete from z_projkm where dm like ’2%’