如图,上面已经是灰色的没法删除,通过界面是没办法的了,只有通过生气了语句来处理了;上面界面通过科目找到绑定了的核算项目类别,后台对应的语句如下
Select i.FNumber FItemClassNumber, i.FName as FItemClassName, i.FItemClassID FItemClassID,CASE ai.FItemID WHEN -1 THEN 1 ELSE 0 END FBalChecked From t_Account a,
t_ItemClass i,t_ItemDetailV ai Where a.FDetailID = ai.FDetailID And ai.FItemClassID = i.FItemClassID And a.FAccountID=1279 And ai.FItemID In(-1,-2)
分析得出,绑定的核算项目是存在于t_ItemDetailV表中,通过字段FDetailID与科目表t_Account关联
--科目绑定的核算项目ID=8
select a.FDetailID,* from t_Account a where a.FAccountID=1279
-- 通过FDetailID来跟科目关联
select * from t_ItemDetailV where FDetailID='8'
--核算项目表
--select * from t_ItemClass
所以执行如下语句就能删除
delete t_ItemDetailV where FDetailID='8'