| | |
| | | + " set @myerror = @@error \n" |
| | | + " if @myrowcount = 0 begin raiserror('%s 功能号不存在',16,1," + formid + ") return end \n" + |
| | | |
| | | " update " + tabname + " set DocStatus=@postdocstatus,postdate=getdate(),postCode='" + postCode + "',postname='" + postname + "' \n" |
| | | " update " + tabname + " set postdate=getdate(),postCode='" + postCode + "',postname='" + postname + "' \n" |
| | | + " where doccode=" + doccode + " and DocStatus=@predocstatus\n" |
| | | + " set @myrowcount = @@rowcount \n" |
| | | + " set @myerror = @@error \n" |
| | | + " if @myrowcount = 0 begin raiserror('%s-已经确认!',16,1," + doccode + ") return end\n "; |
| | | + " if @myrowcount = 0 begin raiserror('%s-更新出错!',16,1," + doccode + ") return end\n " |
| | | |
| | | +" if not exists(select 1 from t111630 where DocCode = '"+formid+"') \n" |
| | | + " begin \n" |
| | | +" update a set DocStatus = @PostDocStatus from "+tabname+" a where a.DocCode = "+doccode+" and a.DocStatus <> isnull(@PostDocStatus,0) \n" |
| | | +" end \n"; |
| | | // 期间是否已关闭,关闭则不能再确认 |
| | | sql += "\n exec checkPeriodHasOpen @doccode=" + doccode + ", @formid = " + formid + " ,@PeriodState = @PeriodState output \n" |
| | | + " if @PeriodState = 2 begin raiserror('当前单据%s所属的期间已关闭,请与财务人员联系',16,1," + doccode + ") return end \n" |