一、设置lookup值:
var lookupData = new Array();
var lookupItem= new Object();
lookupItem.typename = 'new_kf_fwfs';//实体名称
lookupItem.name ="无"; //服务方式名称
lookupItem.id=fwfsid; //服务方式编号
lookupData[0] = lookupItem;
crmForm.all.new_fwfsid.DataValue = lookupData; //设置服务方式的默认值为无
二、获得焦点
crmForm.all.jobtitle.SetFocus();
三、onsave事件中取消保存
// Cancel the save
event.returnValue = false;
return false;
四、onsave事件
var CRM_FORM_SAVE_MODE_SAVE = 1;
var CRM_FORM_SAVE_MODE_SAVEANDCLOSE = 2;
// Only validate if the user clicked "Save"
switch (event.Mode)
{
case CRM_FORM_SAVE_MODE_SAVE:
// If the user provided a first and last name, they must provide
// a job title as well.
if (crmForm.all.jobtitle.DataValue == "" &&
crmForm.all.firstname.DataValue != "" &&
crmForm.all.lastname.DataValue != "" &&
{
// Tell the user what is wrong
alert("Please provide a Job Title for this person.");
// Give the control focus
crmForm.all.jobtitle.SetFocus();
// Cancel the save
event.returnValue = false;
return false;
}
break;
case CRM_FORM_SAVE_MODE_SAVEANDCLOSE:
// If the user forgot to provided a title, default it for them
if (crmForm.all.jobtitle.DataValue == "")
{
// Set a default Job TItle
crmForm.all.jobtitle.DataValue = "N/A";
// Since this is a "Save & Close", the user is in a hurry
// just save the form.
return true;
}
break;
}
五、crm & javascript
var CRM_FORM_TYPE_CREATE = 1;
switch (crmForm.FormType)
{
case CRM_FORM_TYPE_CREATE:
crmForm.all.new_shr.Disabled = true;
crmForm.all.new_shrq.Disabled = true;
break;
}
六、javascript调用webservice-生成认证头函数
GenerateAuthenticationHeader();
七、
实现功能:在编辑状态下根据new_nsrsbh的值,查询该企业的电话受理记录,显示在Tab选项卡中。
//Tab 电话受理情况
//节 电话受理历史记录
//IFRAME 名称 : IFRAME_dhsl
URL: /Workplace/kf/kf_dhslquery.aspx
new_nsrsbh的onchange事件:
if(crmForm.FormType==2)
{
crmForm.all.new_nsrsbh.Disabled=true;
crmForm.all.new_accountid.Disabled=true;
if(IsNull(crmForm.all.new_nsrsbh.DataValue)==false)
{
var nsrsbh=crmForm.all.new_nsrsbh.DataValue;
//电话受理记录
crmForm.all.IFRAME_dhsl.src=crmForm.all.IFRAME_dhsl.url+"?nsrsbh="+nsrsbh;
}
}
八、隐藏左边列表行
var bq="navActivities,navActivityHistory,navAsyncOperations";
var obj=bq.split(",");
for(i=0;i<obj.length;i++)
{
try
{
document.getElementById(obj[i]).style.display="none";
}
catch(Exception )
{
continue;
}
}
九、指定Lookup查询列默认查询条件
例:
//通过公司税号得到该问题类型所属行政区划
var region;
region=nsrsbh.substring(0,2);
//问题类型
crmForm.all.new_wtlxbm.additionalparams = 'search=' + encodeURIComponent(region);
十、级联查询lookup
例:问题类型 onchange事件JS代码,根据"问题类型"的编码设置"问题小类"的查询参数
var wtlx = event.srcElement;
if (IsNull(wtlx) == false)
{
var wtlxbm=wtlx.items[0].keyValues.new_wtlxbm.value;
crmForm.all.new_wtxlbm.additionalparams = 'search=' + encodeURIComponent(wtlxbm);
}
crmForm.all.new_wtxlbm.DataValue = null;
十一、实现多选项,如何设置值和显示值?
//窗体onload事件 JS代码
var fwlxPL = crmForm.all.new_fwlxlist; //多选项列表 picklist类型字段 ,设置多选项值
var fwlxPLV = crmForm.all.new_fwlx; //单行文本框 保存的数据格式为: 选项1||选项2||选项3
if( fwlxPL != null && fwlxPLV != null)
{
//获取值
GetSelectList(fwlxPL,fwlxPLV);
//GetSelectList 函数
function GetSelectList(PL,PLV)
{
PL.style.display = "none"; //设置多选项列表不显示
//PLV.style.display = "none";
// Create a DIV container
var addDiv = document.createElement("<div style='overflow-y:auto; height:80px;border: 1px #6699cc solid;background-color: #ffffff;' />");
PL.parentNode.appendChild(addDiv);
// Initialise checkbox controls
for( var i = 1; i < PL.options.length; i++ )
{
var pOption = PL.options[i];
if( !IsChecked( pOption.text,PLV ) )
var addInput = document.createElement("<input type='checkbox' style='border:none; width:25px; align:left;' />" );
else
var addInput = document.createElement("<input type='checkbox' checked='checked' style='border:none; width:25px; align:left;' / >" );
var addLabel = document.createElement( "<label />");
addLabel.innerText = pOption.text;
var addBr = document.createElement( "<br />");
PL.nextSibling.appendChild(addInput);
PL.nextSibling.appendChild(addLabel);
PL.nextSibling.appendChild(addBr);
}
}
// Check if it is selected 在PLV的值中查询是否存在pText,如果存在由返回true,即选中状态。否则为不选择状态。
function IsChecked( pText,PLV )
{
if(PLV.value != "")
{
var PLVT = PLV.value.split("||");
for( var i = 0; i < PLVT.length; i++ )
{
if( PLVT[i] == pText )
return true;
}
}
return false;
}
// Save the selected text, this filed can also be used in Advanced Find
//保存时设置PLV的值
crmForm.attachEvent( "onsave" , OnSave);
function OnSave()
{
setValue(fwlxPL,fwlxPLV);
}
function setValue(PL,PLV)
{
PLV.value = "";
var getInput = PL.nextSibling.getElementsByTagName("input");
for( var i = 0; i < getInput.length; i++ )
{
if( getInput[i].checked)
{
PLV.value += getInput[i].nextSibling.innerText + "||";
}
}
}
}
//窗体onsave事件 JS代码
crmForm.all.new_fwlx.ForceSubmit=true;
//如果new_sfpd选中的为"是",则必须选择服务类型,根据选择项可以验证其他的限定条件。
if(crmForm.all.new_sfpd.DataValue==1)
{
if(crmForm.all.new_fwlx.DataValue==null)
{
alert("请选择服务类型!");
crmForm.all.new_fwlx.SetFocus();
event.returnValue=false;
return false;
}
if(crmForm.all.new_fwlx.DataValue.indexOf("送产品")!=-1 && (crmForm.all.new_fwlx_scp_bz.DataValue==null || crmForm.all.new_fwlx_scp_bz.DataValue.replace("/(s+)/gi","")==""))
{
alert("您选择了服务类型中的送产品这一选项,必须填写送产品的备注项!!");
crmForm.all.new_fwlx_scp_bz.SetFocus();
event.returnValue=false;
return false;
}
if(crmForm.all.new_fwlx.DataValue.indexOf("其他")!=-1 && (crmForm.all.new_fwlx_qt_bz.DataValue==null || crmForm.all.new_fwlx_qt_bz.DataValue.replace("/(s+)/gi","")==""))
{
alert("您选择了服务类型中的其他这一选项,必须填写其他的备注项!!");
crmForm.all.new_fwlx_qt_bz.SetFocus();
event.returnValue=false;
return false;
}
}
十二、如何获得当前用户
var xml_first = "" +
"<?xml version=\"1.0\" encoding=\"utf-8\"?>" +
"<soap:Envelope xmlns:soap=\"http://schemas.xmlsoap.org/soap/envelope/\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\">" +GenerateAuthenticationHeader() +
" <soap:Body>" +
" <Execute xmlns=\"http://schemas.microsoft.com/crm/2007/WebServices\">" +
" <Request xsi:type=\"WhoAmIRequest\" />" +
" </Execute>" +
" </soap:Body>" +
"</soap:Envelope>" +
"";
var xmlHttpRequest_first = new ActiveXObject("Msxml2.XMLHTTP");
xmlHttpRequest_first.Open("POST", "/mscrmservices/2007/CrmService.asmx", false);
xmlHttpRequest_first.setRequestHeader("SOAPAction", "http://schemas.microsoft.com/crm/2007/WebServices/Execute");
xmlHttpRequest_first.setRequestHeader("Content-Type", "text/xml; charset=utf-8");
xmlHttpRequest_first.setRequestHeader("Content-Length", xml_first.length);
xmlHttpRequest_first.send(xml_first);
var resultXml_first = xmlHttpRequest_first.responseXML;
//alert(resultXml_first.xml);
if(resultXml_first.getElementsByTagName("UserId")!=null)
{
//alert(resultXml.getElementsByTagName("UserId")[0].childNodes[0].nodeValue);
var userid=resultXml_first.getElementsByTagName("UserId")[0].childNodes[0].nodeValue;
var xml_systemuser = "" +
"<?xml version=\"1.0\" encoding=\"utf-8\"?>" +
"<soap:Envelope xmlns:soap=\"http://schemas.xmlsoap.org/soap/envelope/\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\">" +
GenerateAuthenticationHeader()+
" <soap:Body>" +
" <RetrieveMultiple xmlns=\"http://schemas.microsoft.com/crm/2007/WebServices\">" +
" <query xmlns:q1=\"http://schemas.microsoft.com/crm/2006/Query\" xsi:type=\"q1:QueryByAttribute\">" +
" <q1:EntityName>systemuser</q1:EntityName>" +
" <q1:ColumnSet xsi:type=\"q1:ColumnSet\">" +
" <q1:Attributes>" +
" <q1:Attribute>systemuserid</q1:Attribute>" +
" <q1:Attribute>fullname</q1:Attribute>" +
" </q1:Attributes>" +
" </q1:ColumnSet>" +
" <q1:Attributes>" +
" <q1:Attribute>systemuserid</q1:Attribute>" +
" </q1:Attributes>" +
" <q1:Values>" +
" <q1:Value xsi:type=\"xsd:string\">"+userid+"</q1:Value>" +
" </q1:Values>" +
" </query>" +
" </RetrieveMultiple>" +
" </soap:Body>" +
"</soap:Envelope>" +
"";
var xmlHttpRequest_systemuser = new ActiveXObject("Msxml2.XMLHTTP");
xmlHttpRequest_systemuser.Open("POST", "/mscrmservices/2007/CrmService.asmx", false);
xmlHttpRequest_systemuser.setRequestHeader("SOAPAction","http://schemas.microsoft.com/crm/2007/WebServices/RetrieveMultiple");
xmlHttpRequest_systemuser.setRequestHeader("Content-Type", "text/xml; charset=utf-8");
xmlHttpRequest_systemuser.setRequestHeader("Content-Length", xml_systemuser.length);
xmlHttpRequest_systemuser.send(xml_systemuser);
var resultXml_systemuser = xmlHttpRequest_systemuser.responseXML;
if(resultXml_systemuser.getElementsByTagName("q1:fullname")[0]!=null)
{
var fullname=resultXml_systemuser.getElementsByTagName("q1:fullname")[0].childNodes[0].nodeValue;
//alert(fullname);
if(fullname!="XXX")
{
var num=8;
//当前日期
var today=new Date();
var todayMMSecond = today.valueOf();
//alert(todayMMSecond);
var cjrq_s=event.srcElement;
if(cjrq_s.DataValue!=null)
{
var cjrq_v=cjrq_s.items[0].keyValues.new_wcrq.value;
//alert(cjrq_v);
var cjrq_d=new Date(cjrq_v.replace("-","/"));
//alert(cjrq_d.valueOf());
//订单创建日期
var cjrqMMSecond=cjrq_d.valueOf();
var finnalDateMMSecond=cjrqMMSecond+num * 24 * 60 * 60 * 1000;
//alert(finnalDateMMSecond);
if (todayMMSecond>finnalDateMMSecond)
{
alert("当前时间与您选择的订单的创建时间间隔超过"+num+"天,该订单已不允许关联业务拓展!");
crmForm.all.new_kf_ddxxtbbid.DataValue=null;
return;
}
}
}
}
}
十三、
综合实例1
if(crmForm.FormType==2)
{
if(IsNull(crmForm.all.new_shjg.DataValue)==false)
{
crmForm.all.new_sfshtg.DataValue=true;
var today=new Date();
var todayMMSecond = today.valueOf();//今天的毫秒数
var nowtime=new Date(todayMMSecond);
crmForm.all.new_shrq.DataValue=new Date();//获取今天日期
//获取当前用户
var xml = ""
+ "<?xml version=\"1.0\" encoding=\"utf-8\"?>"
+ "<soap:Envelope xmlns:soap=\"http://schemas.xmlsoap.org/soap/envelope/\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\">" +GenerateAuthenticationHeader()
+ " <soap:Body>"
+ " <Execute xmlns=\"http://schemas.microsoft.com/crm/2007/WebServices\">"
+ " <Request xsi:type=\"WhoAmIRequest\" />"
+ " </Execute>"
+ " </soap:Body>"
+ "</soap:Envelope>"
+ "";
var xmlHttpRequest = new ActiveXObject("Msxml2.XMLHTTP");
xmlHttpRequest.Open("POST", "/mscrmservices/2007/CrmService.asmx", false);
xmlHttpRequest.setRequestHeader("SOAPAction","http://schemas.microsoft.com/crm/2007/WebServices/Execute");
xmlHttpRequest.setRequestHeader("Content-Type", "text/xml; charset=utf-8");
xmlHttpRequest.setRequestHeader("Content-Length", xml.length);
xmlHttpRequest.send(xml);
var resultXml = xmlHttpRequest.responseXML;
var userID=resultXml.getElementsByTagName("UserId")[0].childNodes[0].nodeValue;
var uname;
var xml_kf_xzqh = "" +
"<?xml version=\"1.0\" encoding=\"utf-8\"?>" +
"<soap:Envelope xmlns:soap=\"http://schemas.xmlsoap.org/soap/envelope/\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\">" + GenerateAuthenticationHeader() +
" <soap:Body>" +
" <RetrieveMultiple xmlns=\"http://schemas.microsoft.com/crm/2007/WebServices\">" +
" <query xmlns:q1=\"http://schemas.microsoft.com/crm/2006/Query\" xsi:type=\"q1:QueryByAttribute\">" +
" <q1:EntityName>systemuser</q1:EntityName>" +
" <q1:ColumnSet xsi:type=\"q1:ColumnSet\">" +
" <q1:Attributes>" +
" <q1:Attribute>fullname</q1:Attribute>" +
" </q1:Attributes>" +
" </q1:ColumnSet>" +
" <q1:Attributes>" +
" <q1:Attribute>systemuserid</q1:Attribute>" +
" </q1:Attributes>" +
" <q1:Values>" +
" <q1:Value xsi:type=\"xsd:string\">"+userID+"</q1:Value>" +
" </q1:Values>" +
" </query>" +
" </RetrieveMultiple>" +
" </soap:Body>" +
"</soap:Envelope>" +
"";
var xmlHttpRequest_xzqh = new ActiveXObject("Msxml2.XMLHTTP");
xmlHttpRequest_xzqh.Open("POST", "/mscrmservices/2007/CrmService.asmx", false);
xmlHttpRequest_xzqh.setRequestHeader("SOAPAction","http://schemas.microsoft.com/crm/2007/WebServices/RetrieveMultiple");
xmlHttpRequest_xzqh.setRequestHeader("Content-Type", "text/xml; charset=utf-8");
xmlHttpRequest_xzqh.setRequestHeader("Content-Length", xml_kf_xzqh.length);
xmlHttpRequest_xzqh.send(xml_kf_xzqh);
var resultxml_kf_xzqh = xmlHttpRequest_xzqh.responseXML;
//alert(resultxml_kf_xzqh.xml);
if(resultxml_kf_xzqh.getElementsByTagName("q1:fullname")[0]!=null)
{
uname=resultxml_kf_xzqh.getElementsByTagName("q1:fullname")[0].childNodes[0].nodeValue;
}
var shr_data=new Array();
var shr_item=new Object();
shr_item.typename="systemuser";
shr_item.id=userID;
shr_item.name=uname;
//alert(uname);
//alert(userID);
shr_data[0]=shr_item;
crmForm.all.new_shr.DataValue=shr_data;
}
else
{
crmForm.all.new_sfshtg.DataValue=false;
crmForm.all.new_shr.DataValue=null;
crmForm.all.new_shrq.DataValue=null;
crmForm.all.new_shyj.DataValue=null;
}
}
十四、
综合实例2
//电话受理 公司税号 onchange事件JS代码
//1.得到最近企业签到的联系人信息
//2.若无,得到最近一次电话受理联系人信息
//3.若无,得到企业档案联系人信息
if(IsNull(crmForm.all.new_nsrsbh)==false)
{
//获取纳税人识别号
crmForm.all.new_nsrsbh.DataValue= crmForm.all.new_nsrsbh.DataValue.toUpperCase();
crmForm.all.new_nsrsbh.DataValue=crmForm.all.new_nsrsbh.DataValue.replace("X","X");
var nsrsbh = crmForm.all.new_nsrsbh.DataValue;
var account_lxr;//联系人
var account_lxdh;//联系电话
var account_lxdz;//联系地址
var xml = "" +
"<?xml version=\"1.0\" encoding=\"utf-8\"?>" +
"<soap:Envelope xmlns:soap=\"http://schemas.xmlsoap.org/soap/envelope/\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\">" + GenerateAuthenticationHeader() +
" <soap:Body>" +
" <RetrieveMultiple xmlns=\"http://schemas.microsoft.com/crm/2007/WebServices\">" +
" <query xmlns:q1=\"http://schemas.microsoft.com/crm/2006/Query\" xsi:type=\"q1:QueryExpression\">" +
" <q1:EntityName>account</q1:EntityName>" +
" <q1:ColumnSet xsi:type=\"q1:AllColumns\" />" +
" <q1:Distinct>false</q1:Distinct>" +
" <q1:Criteria>" +
" <q1:FilterOperator>And</q1:FilterOperator>" +
" <q1:Conditions>" +
" <q1:Condition>" +
" <q1:AttributeName>new_nsrsbh</q1:AttributeName>" +
" <q1:Operator>Equal</q1:Operator>" +
" <q1:Values>" +
" <q1:Value xsi:type=\"xsd:string\">"+nsrsbh+"</q1:Value>" +
" </q1:Values>" +
" </q1:Condition>" +
" </q1:Conditions>" +
" </q1:Criteria>" +
" </query>" +
" </RetrieveMultiple>" +
" </soap:Body>" +
"</soap:Envelope>" +
"";
var xmlHttpRequest = new ActiveXObject("Msxml2.XMLHTTP");
xmlHttpRequest.Open("POST", "/mscrmservices/2007/CrmService.asmx", false);
xmlHttpRequest.setRequestHeader("SOAPAction","http://schemas.microsoft.com/crm/2007/WebServices/RetrieveMultiple");
xmlHttpRequest.setRequestHeader("Content-Type", "text/xml; charset=utf-8");
xmlHttpRequest.setRequestHeader("Content-Length", xml.length);
xmlHttpRequest.send(xml);
try
{
var resultXml = xmlHttpRequest.responseXML;
//联系人
if(resultXml.getElementsByTagName("q1:new_lxr")[0]!=null)
{
account_lxr=resultXml.getElementsByTagName("q1:new_lxr")[0].childNodes[0].nodeValue;
}
//联系电话
if(resultXml.getElementsByTagName("q1:telephone1")[0]!=null)
{
account_lxdh=resultXml.getElementsByTagName("q1:telephone1")[0].childNodes[0].nodeValue;
}
//联系地址
if(resultXml.getElementsByTagName("q1:new_scjydz")[0]!=null)
{
account_lxdz=resultXml.getElementsByTagName("q1:new_scjydz")[0].childNodes[0].nodeValue;
}
//企业名称
var nsrmc = resultXml.getElementsByTagName("q1:name")[0].childNodes[0].nodeValue;
var id =resultXml.getElementsByTagName("q1:accountid")[0].childNodes[0].nodeValue;
var lookupData = new Array();
var lookupItem= new Object();
lookupItem.typename = 'account';
lookupItem.name =nsrmc;
lookupItem.id=id;
lookupData[0] = lookupItem;
crmForm.all.new_accountid.DataValue = lookupData;//公司名称
//行政区划 account.new_xzqh new_dm_xzqh.new_name
//得到行政区划代码
//行政区划
if(resultXml.getElementsByTagName("q1:new_xzqh")[0]!=null)
{
var new_dm_xzqhid= resultXml.getElementsByTagName("q1:new_xzqh")[0].childNodes[0].nodeValue;
//alert("行政区划代码:"+new_dm_xzqhid);
//通过行政区划编号得到行政区划名称
var xml_kf_xzqh = "" +
"<?xml version=\"1.0\" encoding=\"utf-8\"?>" +
"<soap:Envelope xmlns:soap=\"http://schemas.xmlsoap.org/soap/envelope/\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\">" +
GenerateAuthenticationHeader() +
" <soap:Body>" +
" <RetrieveMultiple xmlns=\"http://schemas.microsoft.com/crm/2007/WebServices\">" +
" <query xmlns:q1=\"http://schemas.microsoft.com/crm/2006/Query\" xsi:type=\"q1:QueryByAttribute\">" +
" <q1:EntityName>new_dm_xzqh</q1:EntityName>" +
" <q1:ColumnSet xsi:type=\"q1:ColumnSet\">" +
" <q1:Attributes>" +
" <q1:Attribute>new_dm_xzqhid</q1:Attribute>" +
" <q1:Attribute>new_name</q1:Attribute>" +
" </q1:Attributes>" +
" </q1:ColumnSet>" +
" <q1:Attributes>" +
" <q1:Attribute>new_dm_xzqhid</q1:Attribute>" +
" </q1:Attributes>" +
" <q1:Values>" +
" <q1:Value xsi:type=\"xsd:string\">"+new_dm_xzqhid+"</q1:Value>" +
" </q1:Values>" +
" </query>" +
" </RetrieveMultiple>" +
" </soap:Body>" +
"</soap:Envelope>" +
"";
var xmlHttpRequest_xzqh = new ActiveXObject("Msxml2.XMLHTTP");
xmlHttpRequest_xzqh.Open("POST", "/mscrmservices/2007/CrmService.asmx", false);
xmlHttpRequest_xzqh.setRequestHeader("SOAPAction","http://schemas.microsoft.com/crm/2007/WebServices/RetrieveMultiple");
xmlHttpRequest_xzqh.setRequestHeader("Content-Type", "text/xml; charset=utf-8");
xmlHttpRequest_xzqh.setRequestHeader("Content-Length", xml_kf_xzqh.length);
xmlHttpRequest_xzqh.send(xml_kf_xzqh);
var resultxml_kf_xzqh = xmlHttpRequest_xzqh.responseXML;
//行政区划
if(resultxml_kf_xzqh.getElementsByTagName("q1:new_name")[0]!=null)
{
//行政区划名称
var xzqh_name=resultxml_kf_xzqh.getElementsByTagName("q1:new_name")[0].childNodes[0].nodeValue;
//alert("行政区划名称:"+xzqh_name);
//设置行政区划lookup值
var lookupData_xzqh = new Array();
var lookupItem_xzqh= new Object();
lookupItem_xzqh.typename = 'new_dm_xzqh';
lookupItem_xzqh.name =xzqh_name;
lookupItem_xzqh.id=new_dm_xzqhid;
lookupData_xzqh[0] = lookupItem_xzqh;
crmForm.all.new_dm_xzqhid.DataValue = lookupData_xzqh;
}
}
//通过公司税号得到该问题类型所属行政区划 例:14
var region;
region=nsrsbh.substring(0,2);
//crmForm.all.new_wtlxbm.DataValue=region;
//问题类型
crmForm.all.new_wtlxbm.additionalparams = 'search=' + encodeURIComponent(region);
//受理产品
crmForm.all.new_cpbm.additionalparams = 'search='+encodeURIComponent(region);
//2.得到联系人信息(最近一次该公司的电话受理联系人信息)
var xml_kf_dhsl = "" +
"<?xml version=\"1.0\" encoding=\"utf-8\"?>" +
"<soap:Envelope xmlns:soap=\"http://schemas.xmlsoap.org/soap/envelope/\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\">" +
GenerateAuthenticationHeader() +
" <soap:Body>" +
" <RetrieveMultiple xmlns=\"http://schemas.microsoft.com/crm/2007/WebServices\">" +
" <query xmlns:q1=\"http://schemas.microsoft.com/crm/2006/Query\" xsi:type=\"q1:QueryByAttribute\">" +
" <q1:EntityName>new_kf_dhsl</q1:EntityName>" +
" <q1:ColumnSet xsi:type=\"q1:ColumnSet\">" +
" <q1:Attributes>" +
" <q1:Attribute>new_nsrsbh</q1:Attribute>" +
" <q1:Attribute>new_ldhm</q1:Attribute>" +
" <q1:Attribute>new_lxr</q1:Attribute>" +
" <q1:Attribute>new_lxdh</q1:Attribute>" +
" <q1:Attribute>new_lxdz</q1:Attribute>" +
" <q1:Attribute>createdon</q1:Attribute>" +
" </q1:Attributes>" +
" </q1:ColumnSet>" +
" <q1:Attributes>" +
" <q1:Attribute>new_nsrsbh</q1:Attribute>" +
" </q1:Attributes>" +
" <q1:Values>" +
" <q1:Value xsi:type=\"xsd:string\">"+nsrsbh+"</q1:Value>" +
" </q1:Values>" +
" <q1:PageInfo>" +
" <q1:PageNumber>1</q1:PageNumber>" +
" <q1:Count>1</q1:Count>" +
" </q1:PageInfo>" +
" <q1:Orders>" +
" <q1:Order>" +
" <q1:AttributeName>createdon</q1:AttributeName>" +
" <q1:OrderType>Descending</q1:OrderType>" +
" </q1:Order>" +
" </q1:Orders>" +
" </query>" +
" </RetrieveMultiple>" +
" </soap:Body>" +
"</soap:Envelope>" +
"";
var xmlHttpRequest = new ActiveXObject("Msxml2.XMLHTTP");
xmlHttpRequest.Open("POST", "/mscrmservices/2007/CrmService.asmx", false);
xmlHttpRequest.setRequestHeader("SOAPAction","http://schemas.microsoft.com/crm/2007/WebServices/RetrieveMultiple");
xmlHttpRequest.setRequestHeader("Content-Type", "text/xml; charset=utf-8");
xmlHttpRequest.setRequestHeader("Content-Length", xml_kf_dhsl.length);
xmlHttpRequest.send(xml_kf_dhsl);
var resultXml_kf_dhsl = xmlHttpRequest.responseXML;
//alert(resultXml.xml);
var isdhsl=false;
//联系人
if(resultXml_kf_dhsl.getElementsByTagName("q1:new_lxr")[0]!=null)
{
var lxr=resultXml_kf_dhsl.getElementsByTagName("q1:new_lxr")[0].childNodes[0].nodeValue;
isdhsl=true;
crmForm.all.new_lxr.DataValue=lxr;
}
//联系电话
if(resultXml_kf_dhsl.getElementsByTagName("q1:new_lxdh")[0]!=null)
{
var lxdh=resultXml_kf_dhsl.getElementsByTagName("q1:new_lxdh")[0].childNodes[0].nodeValue;
crmForm.all.new_lxdh.DataValue=lxdh;
}
//联系地址
if(resultXml_kf_dhsl.getElementsByTagName("q1:new_lxdz")[0]!=null)
{
var lxdz=resultXml_kf_dhsl.getElementsByTagName("q1:new_lxdz")[0].childNodes[0].nodeValue;
crmForm.all.new_lxdz.DataValue=lxdz;
}
//1.得到最近企业签到的联系人信息
if(isdhsl==false)
{
//alert("该公司没有电话受理信息!");
var xml_kf_pxqd = "" +
"<?xml version=\"1.0\" encoding=\"utf-8\"?>" +
"<soap:Envelope xmlns:soap=\"http://schemas.xmlsoap.org/soap/envelope/\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\">" +
GenerateAuthenticationHeader() +
" <soap:Body>" +
" <RetrieveMultiple xmlns=\"http://schemas.microsoft.com/crm/2007/WebServices\">" +
" <query xmlns:q1=\"http://schemas.microsoft.com/crm/2006/Query\" xsi:type=\"q1:QueryByAttribute\">" +
" <q1:EntityName>new_kf_pxqd</q1:EntityName>" +
" <q1:ColumnSet xsi:type=\"q1:ColumnSet\">" +
" <q1:Attributes>" +
" <q1:Attribute>new_nsrsbh</q1:Attribute>" +
" <q1:Attribute>new_lxr</q1:Attribute>" +
" <q1:Attribute>new_lxdh</q1:Attribute>" +
" <q1:Attribute>new_lxdz</q1:Attribute>" +
" <q1:Attribute>createdon</q1:Attribute>" +
" </q1:Attributes>" +
" </q1:ColumnSet>" +
" <q1:Attributes>" +
" <q1:Attribute>new_nsrsbh</q1:Attribute>" +
" </q1:Attributes>" +
" <q1:Values>" +
" <q1:Value xsi:type=\"xsd:string\">"+nsrsbh+"</q1:Value>" +
" </q1:Values>" +
" <q1:PageInfo>" +
" <q1:PageNumber>1</q1:PageNumber>" +
" <q1:Count>1</q1:Count>" +
" </q1:PageInfo>" +
" <q1:Orders>" +
" <q1:Order>" +
" <q1:AttributeName>createdon</q1:AttributeName>" +
" <q1:OrderType>Descending</q1:OrderType>" +
" </q1:Order>" +
" </q1:Orders>" +
" </query>" +
" </RetrieveMultiple>" +
" </soap:Body>" +
"</soap:Envelope>" +
"";
var xmlHttpRequest_pxqd = new ActiveXObject("Msxml2.XMLHTTP");
xmlHttpRequest_pxqd.Open("POST", "/mscrmservices/2007/CrmService.asmx", false);
xmlHttpRequest_pxqd.setRequestHeader("SOAPAction","http://schemas.microsoft.com/crm/2007/WebServices/RetrieveMultiple");
xmlHttpRequest_pxqd.setRequestHeader("Content-Type", "text/xml; charset=utf-8");
xmlHttpRequest_pxqd.setRequestHeader("Content-Length", xml_kf_pxqd.length);
xmlHttpRequest_pxqd.send(xml_kf_pxqd);
var resultxml_kf_pxqd = xmlHttpRequest_pxqd.responseXML;
var ispxqd=false;
//联系人
if(resultxml_kf_pxqd.getElementsByTagName("q1:new_lxr")[0]!=null)
{
var pxqd_lxr=resultxml_kf_pxqd.getElementsByTagName("q1:new_lxr")[0].childNodes[0].nodeValue;
crmForm.all.new_lxr.DataValue=pxqd_lxr;
ispxqd=true;
}
//联系电话
if(resultxml_kf_pxqd.getElementsByTagName("q1:new_lxdh")[0]!=null)
{
var pxqd_lxdh=resultxml_kf_pxqd.getElementsByTagName("q1:new_lxdh")[0].childNodes[0].nodeValue;
crmForm.all.new_lxdh.DataValue=pxqd_lxdh;
}
//联系地址
if(resultxml_kf_pxqd.getElementsByTagName("q1:new_lxdz")[0]!=null)
{
var pxqd_lxdz=resultxml_kf_pxqd.getElementsByTagName("q1:new_lxdz")[0].childNodes[0].nodeValue;
crmForm.all.new_lxdz.DataValue=pxqd_lxdz;
}
//3. 如果公司没有培训签到信息,则得到企业档案联系人信息
if(ispxqd==false)
{
// alert('该公司没有参加培训!');
crmForm.all.new_lxr.DataValue=account_lxr;
crmForm.all.new_lxdh.DataValue=account_lxdh;
crmForm.all.new_lxdz.DataValue=account_lxdz;
}
}
//设置公司名称和公司税号不可用
//crmForm.all.new_accountid.disabled=true;
//crmForm.all.new_nsrsbh.disabled=true;
//电话受理记录
crmForm.all.IFRAME_dhsl.src=crmForm.all.IFRAME_dhsl.url+"?nsrsbh="+nsrsbh;
//企业培训记录
crmForm.all.IFRAME_qypx.src=crmForm.all.IFRAME_qypx.url+"?nsrsbh="+nsrsbh;
//客户受理记录
crmForm.all.IFRAME_khsq.src=crmForm.all.IFRAME_khsq.url+"?nsrsbh="+nsrsbh;
//联系人信息
crmForm.all.IFRAME_lxr.src=crmForm.all.IFRAME_lxr.url+"?nsrsbh="+nsrsbh;
//派单记录
crmForm.all.IFRAME_pdjl.src=crmForm.all.IFRAME_pdjl.url+"?nsrsbh="+nsrsbh;
//未完派单记录
crmForm.all.IFRAME_wwcpdjl.src=crmForm.all.IFRAME_wwcpdjl.url+"?nsrsbh="+nsrsbh;
//订单情况
crmForm.all.IFRAME_ddxxquery.src=crmForm.all.IFRAME_ddxxquery.url+"?nsrsbh="+nsrsbh;
//机打发票升级情况
crmForm.all.IFRAME_jdpsjqk.src=crmForm.all.IFRAME_jdpsjqk.url+"?nsrsbh="+nsrsbh;
//机打发票升级预约记录
crmForm.all.IFRAME_jdpsjyy.src=crmForm.all.IFRAME_jdpsjyy.url+"?nsrsbh="+nsrsbh;
//电话回访记录
crmForm.all.IFRAME_dhhf.src=crmForm.all.IFRAME_dhhf.url+"?nsrsbh="+nsrsbh;
}
catch(Exception)
{
alert('纳税人信息查询不到');
nsrsbh="";
crmForm.all.new_nsrsbh.DataValue="";
crmForm.all.new_nsrsbh.SetFocus();
return;
}
}