最初始是这样。
var ORG="00000000000000000028";
console.log('{"Lbracket":"( ","Compare":" in","Field":"LSBMZD_DWBH","DataType":"String","Value":
"(select Companyid from OrgDepRelationship where Organizationid='+ORG+')","Rbracket":" )","Relation":" ","IsCanChange":true, "ConvertUpperToCompare":false,"Expresstype":0,"FieldCaption":"","InnerFormula":"","Owner":"","DisplayValue":" ","Description":""}]');
这样输出结果是：
{"Lbracket":"( ","Compare":" in","Field":"LSBMZD_DWBH","DataType":"String","Value":
"(select Companyid from OrgDepRelationship where Organizationid=00000000000000000028)","Rbracket":" )","Relation":" ",
"IsCanChange":true,"ConvertUpperToCompare":false,"Expresstype":0,"FieldCaption":"","InnerFormula":"","Owner":"","DisplayValue":"","Description":""}]没有单引号。
后来改成了这样。
var ORG="00000000000000000028";
console.log('{"Lbracket":"( ","Compare":" in","Field":"LSBMZD_DWBH","DataType":"String","Value":
"(select Companyid from OrgDepRelationship where Organizationid="'+ORG+'")","Rbracket":" )","Relation":" ","IsCanChange":true, "ConvertUpperToCompare":false,"Expresstype":0,"FieldCaption":"","InnerFormula":"","Owner":"","DisplayValue":" ","Description":""}]');
输出结果是：
{"Lbracket":"( ","Compare":" in","Field":"LSBMZD_DWBH","DataType":"String","Value":
"(select Companyid from OrgDepRelationship where Organizationid="00000000000000000028")","Rbracket":" )","Relation":" ", "IsCanChange":true,"ConvertUpperToCompare":false,"Expresstype":0,"FieldCaption":"","InnerFormula":"","Owner":"","DisplayValue":"","Description":""}]还是不符合要求：
但是直接如果直接改成这样：
var ORG="00000000000000000028";
console.log('{"Lbracket":"( ","Compare":" in","Field":"LSBMZD_DWBH","DataType":"String","Value":
"(select Companyid from OrgDepRelationship where Organizationid=''+ORG+'')","Rbracket":" )","Relation":" ","IsCanChange":true, "ConvertUpperToCompare":false,"Expresstype":0,"FieldCaption":"","InnerFormula":"","Owner":"","DisplayValue":" ","Description":""}]');
会把ORG当作⼀个字符串。
因此需要加⼊转义字符，”\“。
改成这样就能实现效果。
var ORG="00000000000000000028";
console.log('{"Lbracket":"( ","Compare":" in","Field":"LSBMZD_DWBH","DataType":"String","Value":
字符串常量用单引号还是双引号"(select Companyid from OrgDepRelationship where Organizationid=\''+ORG+'\')","Rbracket":" )","Relation":" ","IsCanChange":true, "ConvertUpperToCompare":false,"Expresstype":0,"FieldCaption":"","InnerFormula":"","Owner":"","DisplayValue":" ","Description":""}]');
版权声明：本站内容均来自互联网，仅供演示用，请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198，我们将在24小时内删除。
豫公网安备41160202000602
发表评论