| | |
|---|
| | | + " begin \n" |
|---|
| | | + " set @RefCode = @ActionName \n" |
|---|
| | | + " select @Title = a.Title,@RefFormId = a.FormId from t714031H a where a.DocCode = @RefCode \n" |
|---|
| | | + " select @RefFormType = a.FormType from _sysmenu a where a.formid = @RefFormId \n" |
|---|
| | | + " select @RefFormType = case a.FormType when 9 then 5 when 15 then 8 when 17 then 16 when 497 then 496 when 499 then 498 else a.FormType end \n" |
|---|
| | | + " from _sysmenu a where a.formid = @RefFormId \n" |
|---|
| | | + " end \n" |
|---|
| | | + " insert into t735007(OpenId,UserId,ActionType,ActionName,CreateTime,MatCode,Title,FormName,RefCode,RefFormId,RefFormType,CreateDate) \n" |
|---|
| | | + " values(@OpenId,@UserId,@ActionType,@ActionName ,@CreateTime,@MatCode,@Title,@FormName,@RefCode,@RefFormId,@RefFormType,@CreateDate ) \n" |
|---|
