本帖最后由 lana 于 2015-8-25 09:06 编辑
如下:
JavaScriptRunning:[RELATION(11e5-4815-9b5303b2-8fdf-a72de80ec463-1203565260293-1203565260294).over.Action]: ReferenceError: "user" is not defined. (11e5-4815-9b5303b2-8fdf-a72de80ec463-1203565260293-1203565260294).over.Action#3);
----------------------脚本方法
//表单某字段值为根据SQL姓名字段的值查询出对应的电话(值脚本)
var id = getItemValueAsString("ID");
if(user!=null && user.trim().length()>0){
var sql="exec spchy_TlkintoApp '"+id+"'";
queryBySQL(sql);}
----------------------脚本方法
----------------------------------------------------------------------------------------以下是存储过程
alter Proc spchy_TlkintoApp
@id nvarchar(200)
as
update t2
set t2.InWorkflow=0,t2.DISC=t1.ITEM_DISC
from TLK_CO_LINE t1
inner join coitem_mst t2
on t1.id=convert(nvarchar(200),t2.RowPointer)
where t1.id=@id
select @id as id into ##id
select * from ##id
return 0
----------------------------------------------------------------------------------------以下是存储过程 |