update tsubmitedit set fstatus='ĐÂ½¨',submitby=null,submitdate=null,changeby=$returnby$,changedate=getdate()
where siteid=$siteid$ and tsubmiteditmodelid=$tsubmiteditmodelid$ and tsubmiteditid=$tsubmiteditid$

update tsubmiteditmodel set fsubmitqty=isnull(fsubmitqty,0)-1 where siteid=$siteid$ and tsubmiteditmodelid=$tsubmiteditmodelid$