ajax中与服务器DataSet的交换实例(AjaxPro)

马士基订舱系统（BST）中需要从他们的内部MODS系统中取MOds的信息到我们系统来，而传统的系统之间数据交互其实有很多种，1）最简单的是通过两个Database之间数据交互 2）通过vb script交互获取  但最后由于无法跟MODS的Database交互，而用IBM WebSphere Host On-Demand去获取的话技术方面不是很成熟。而且所以我们决定采用第二种办法，通过页面脚本获取数据后放在DataSet里面，然后在用AJAX特性与服务器上的DataSet去交互。在网上找了很久最后选用AjaxPro去实施。

下面的是马士基订舱系统与MODS系统交互的页面：

 

 下面是MODS系统的页面样例

 

 

好了，现在就把具体的步骤写下来。

1）页面控件绑定脚本函数:

<input id= "btnQuery7" type= "button" value= "OK" style = "width:100px;" οnclick= "areaResult()" />

2）页面的javascript函数

areaResult get_mods_Result_CallBack <mce:script language="javascript"><!-- var xmlDoc function areaResult() { var city = 1; cb_GetModsData.GetCityList(city, get_mods_Result_CallBack); } function get_mods_Result_CallBack(response) //response-空的DataSet类型 { if (response.value != null) { var ds = response.value; var vstr = Trim(document.all["txtPo"].value); //获取界面控件名称为：“txtPo”的值 if (vstr == "") { alert("The input value should not be empty"); return; } var reg = /^[a-zA-Z0-9/_]+$/; if ((vstr.indexOf("/") == 0) || (vstr.lastIndexOf("/") == (vstr.length - 1))) { alert("Please remove the '/' sign at the improper position "); return; } else if (!reg.test(vstr)) { alert("input value only allows A...Z, a...z and / "); return; } var space = "/"; var arrayofstrings = vstr.split(space); //定义当PRE单笔中输入多个MODS，当这些MODS的consignee和Notify Party 1有不同时，按照第一条MODS的信息 add by fubin.pan 03-24 var vconsignee1 = ""; var vconsignee2 = ""; var vconsignee3 = ""; var vnotifyparty = ""; xmlDoc = new ActiveXObject("Microsoft.XMLDOM"); 　　 xmlDoc.async = false; 　　 xmlDoc.load("./Script/ModsField.xml"); 　　 　　 if (xmlDoc.parseError.errorCode != 0) //如果打开文件出错 　　 { 　　 var myErr = xmlDoc.parseError; 　　 alert("You have error " + myErr.reason); 　　 } 　　 else 　　 {　　 if(ds != null && typeof(ds) == "object" && ds.Tables != null) //判断DataSet结构是否正确 { if (Scaning_MODSPane("RLMOM101")) //判断当前是否是RLMOM101版面 { Sent_TxtTo("2",8,28); Sent_Cmd("[enter]"); WaitSys(); if (Scaning_MODSPane("RLMOM121")) //判断当前是否是RLMOM121版面，并且添充数据到121表中 { var combstr = ""; var combstr1 = ""; var vpre = "0"; //用来标识PRE中验证的字段是否相同. "0": 验证通过 "1":验证不通过,弹出提示. for (var i=0; i<arrayofstrings.length; i++) { if (arrayofstrings[i].length > 10) { alert(arrayofstrings[i] + " is over the proper length"); Sent_Cmd("[PF3]"); WaitSys(); return; } else if (arrayofstrings[i].length < 10) { var str = arrayofstrings[i].substr(0, 3); for (var t=0; t<(10-arrayofstrings[i].length); t++) { str = str + "0"; } str = str + arrayofstrings[i].substr(3, (arrayofstrings[i].length)-3); arrayofstrings[i] = str; } var strsub = arrayofstrings[i].substr(0, 3).toUpperCase(); if (document.all["txtTag"].value.toUpperCase() == "PRE") { if (strsub != "SGH" && strsub != "FOO" && strsub != "XIM" && strsub != "NPO" && strsub != "NKG") { alert("Getting MODS SO from the other sites is not allowed"); Sent_Cmd("[PF3]"); WaitSys(); return; } } else if (document.all["txtTag"].value.toUpperCase() == "PRS") { if (strsub != "HKG" && strsub != "YAT" && strsub != "GUA" && strsub != "MAC" && strsub != "HUP" ) { alert("Getting MODS SO from the other sites is not allowed"); Sent_Cmd("[PF3]"); WaitSys(); return; } } else if (document.all["txtTag"].value.toUpperCase() == "PRN") { if (strsub != "TST" && strsub != "DAI" && strsub != "HSK" && strsub != "TJN" && strsub != "HBN") { alert("Getting MODS SO from the other sites is not allowed"); Sent_Cmd("[PF3]"); WaitSys(); return; } } if ((i > 0) && (arrayofstrings[i] == arrayofstrings[i - 1])) { alert(arrayofstrings[i] + " are duplicated."); Sent_Cmd("[PF3]"); WaitSys(); return; } Sent_TxtTo(arrayofstrings[i],5,21); Sent_Cmd("[enter]"); WaitSys(); if (Trim(Get_TxtFrm(6,70,9).toUpperCase()) == "PENDING") //校验该MODS SO的状态 { alert("MODS SO " + arrayofstrings[i] + " is in Pending Status."); Sent_Cmd("[PF3]"); WaitSys(); return; } if (Get_TxtFrm(22,2,30) == "E: Shipping Order is not found") //校验输入的Shipping Order是否存在 { alert(arrayofstrings[i] + FCR.Prompt.HasNotFound); Sent_Cmd("[PF3]"); WaitSys(); return; } else if (Get_TxtFrm(22,2,48) == "TIRM100E: INVALID INPUT FOR FIELD AT THE CURSOR") //校验输入的字符是否正确 { alert("INVALID INPUT FOR FIELD AT THE CURSOR"); Sent_Cmd("[PF3]"); WaitSys(); return; } else if (Get_TxtFrm(7,13,2) == " ") //校验查询出的记录是否正确 { alert("SHIPPER IS NULL"); Sent_Cmd("[PF3]"); WaitSys(); return; } ds.Tables[0].Rows[i] = []; //先新建一列为空 ds.Tables[0].Rows[i]["SO_NO"] = arrayofstrings[i]; var a = xmlDoc.getElementsByTagName("RLMOM121"); for (var j=0; j<a[0].childNodes.length; j++) //循环表字段添加数据 { var currNode = a[0].childNodes[j]; ds.Tables[0].Rows[i][a[0].childNodes[j].nodeName] = Trim(Get_TxtFrm(currNode.attributes[1].value,currNode.attributes[2].value,currNode.attributes[3].value)); } //fetch combine string to judge if consignee/POR/POL/POD/Des are the same if (i == 0) { //fetch the first combine combstr = ds.Tables[0].Rows[i]["Consignee1"] + ds.Tables[0].Rows[i]["Consignee2"] + ds.Tables[0].Rows[i]["Consignee3"] + ds.Tables[0].Rows[i]["Load1"] + ds.Tables[0].Rows[i]["Load2"]; combstr = combstr + ds.Tables[0].Rows[i]["Load3"] + ds.Tables[0].Rows[i]["Disch1"] + ds.Tables[0].Rows[i]["Disch2"] + ds.Tables[0].Rows[i]["Disch3"]; if (document.all["txtTag"].value.toUpperCase() == "PRS") { combstr = combstr + ds.Tables[0].Rows[i]["CaPOD1"] + ds.Tables[0].Rows[i]["CaPOD2"] + ds.Tables[0].Rows[i]["CaPOD3"]; } else if (document.all["txtTag"].value.toUpperCase() == "PRN") { combstr = combstr + ds.Tables[0].Rows[i]["CaPOD1"] + ds.Tables[0].Rows[i]["CaPOD2"] + ds.Tables[0].Rows[i]["CaPOD3"]; combstr = combstr + ds.Tables[0].Rows[i]["POR1"] + ds.Tables[0].Rows[i]["POR2"] + ds.Tables[0].Rows[i]["POR3"]; } else if (document.all["txtTag"].value.toUpperCase() == "PRE") { combstr = combstr + ds.Tables[0].Rows[i]["ClPOD1"] + ds.Tables[0].Rows[i]["ClPOD2"] + ds.Tables[0].Rows[i]["ClPOD3"]; combstr = combstr + ds.Tables[0].Rows[i]["POR1"] + ds.Tables[0].Rows[i]["POR2"] + ds.Tables[0].Rows[i]["POR3"]; vconsignee1 = Trim(ds.Tables[0].Rows[i]["Consignee1"]); //add by fubin.pan 03-24 vconsignee2 = Trim(ds.Tables[0].Rows[i]["Consignee2"]); vconsignee3 = Trim(ds.Tables[0].Rows[i]["Consignee3"]); } } else { combstr1 = ds.Tables[0].Rows[i]["Consignee1"] + ds.Tables[0].Rows[i]["Consignee2"] + ds.Tables[0].Rows[i]["Consignee3"] + ds.Tables[0].Rows[i]["Load1"] + ds.Tables[0].Rows[i]["Load2"]; combstr1 = combstr1 + ds.Tables[0].Rows[i]["Load3"] + ds.Tables[0].Rows[i]["Disch1"] + ds.Tables[0].Rows[i]["Disch2"] + ds.Tables[0].Rows[i]["Disch3"]; if (document.all["txtTag"].value.toUpperCase() == "PRS") { combstr1 = combstr1 + ds.Tables[0].Rows[i]["CaPOD1"] + ds.Tables[0].Rows[i]["CaPOD2"] + ds.Tables[0].Rows[i]["CaPOD3"]; } else if (document.all["txtTag"].value.toUpperCase() == "PRN") { combstr1 = combstr1 + ds.Tables[0].Rows[i]["CaPOD1"] + ds.Tables[0].Rows[i]["CaPOD2"] + ds.Tables[0].Rows[i]["CaPOD3"]; combstr1 = combstr1 + ds.Tables[0].Rows[i]["POR1"] + ds.Tables[0].Rows[i]["POR2"] + ds.Tables[0].Rows[i]["POR3"]; } else if (document.all["txtTag"].value.toUpperCase() == "PRE") { combstr1 = combstr1 + ds.Tables[0].Rows[i]["ClPOD1"] + ds.Tables[0].Rows[i]["ClPOD2"] + ds.Tables[0].Rows[i]["ClPOD3"]; combstr1 = combstr1 + ds.Tables[0].Rows[i]["POR1"] + ds.Tables[0].Rows[i]["POR2"] + ds.Tables[0].Rows[i]["POR3"]; if (combstr1 != combstr && vpre == "0") { vpre = "1"; } combstr1 = combstr; //重新赋值,前后字段验证通过 } if (combstr1 != combstr) { alert("Consignee, POR, POL, POD, Des should be the same within one Booking."); Sent_Cmd("[PF3]"); WaitSys(); return; } } } } else { return; } Sent_Cmd("[PF15]"); //切换版面到RLMOM131 WaitSys(); if (Scaning_MODSPane("RLMOM131")) { for (var i=0; i<arrayofstrings.length; i++) { Sent_TxtTo(arrayofstrings[i],5,17); Sent_Cmd("[enter]"); WaitSys(); if (Get_TxtFrm(22,2,30) == "E: Shipping Order is not found") { alert(arrayofstrings[i] + FCR.Prompt.HasNotFound); Sent_Cmd("[PF3]"); WaitSys(); return ; } ds.Tables[1].Rows[i] = []; //先新建一列为空 ds.Tables[1].Rows[i]["SO_NO"] = arrayofstrings[i]; var a = xmlDoc.getElementsByTagName("RLMOM131"); for (var j=0; j<a[0].childNodes.length; j++) { var currNode = a[0].childNodes[j]; ds.Tables[1].Rows[i][a[0].childNodes[j].nodeName] = Trim(Get_TxtFrm(currNode.attributes[1].value,currNode.attributes[2].value,currNode.attributes[3].value)); } if (i == 0) //add by fubin.pan 03-24 { vnotifyparty = Trim(ds.Tables[1].Rows[i]["NotifyParty1"]); } } } else { return; } Sent_Cmd("[PF16]"); //切换版面到RLMOM141 WaitSys(); if (Scaning_MODSPane("RLMOM141")) //判断当前是否是RLMOM141版面 { var t = 0; for (var k=0; k<arrayofstrings.length; k++) { Sent_TxtTo(arrayofstrings[k],5,15); Sent_TxtTo("1",5,37); Sent_Cmd("[enter]"); WaitSys(); if (Get_TxtFrm(11,11,1) != " ") //if have data from sequence No.1 { //alert("跳过此处"); } else //if no data from sequence No.1,please trigger from sequence No.2 { Sent_TxtTo("2",5,37); Sent_Cmd("[enter]"); WaitSys(); if (Get_TxtFrm(22,2,30) == "E: Shipping Order is not found") { alert(arrayofstrings[k] + FCR.Prompt.HasNotFound); Sent_Cmd("[PF3]"); WaitSys(); return; } else if (Get_TxtFrm(22,2,29) == "SHIPPING ORDER SPEC NOT FOUND") { continue; } //需要错误处理 } for (var i=11; i<21; i++) //循环明细列表信息 { if ((Get_TxtFrm(i,11,1) != " ") || (Get_TxtFrm(i,40,2) != " ")) { ds.Tables[2].Rows[t] = []; //先新建一列为空 ds.Tables[2].Rows[t]["SO_NO"] = arrayofstrings[k]; var a = xmlDoc.getElementsByTagName("RLMOM141"); for (var j=0; j<a[0].childNodes.length; j++) { var currNode = a[0].childNodes[j]; ds.Tables[2].Rows[t][a[0].childNodes[j].nodeName] = Trim(Get_TxtFrm(parseInt(currNode.attributes[1].value) + parseInt(i) - 11,currNode.attributes[2].value,currNode.attributes[3].value)); } t = t + 1; if (i == 20) //循环到当前页底，进行翻页 { Sent_Cmd("[PF8]"); WaitSys(); i = 10; } } else //当前列为空时，跳出本所有循环 { i = 100; break; } } } } else { return; } Sent_Cmd("[PF17]"); //切换版面到RLMOM151 WaitSys(); if (Scaning_MODSPane("RLMOM151")) { var m = 0; for (var k=0; k<arrayofstrings.length; k++) { Sent_TxtTo(arrayofstrings[k],5,16); Sent_TxtTo(" ",5,43); //清空From Sent_Cmd("[enter]"); WaitSys(); //var vfrom = parseInt(Trim(Get_TxtFrm(5,43,3))); //定义From累加 if (Get_TxtFrm(22,2,30) == "E: Shipping Order is not found") { alert(arrayofstrings[k] + FCR.Prompt.HasNotFound); Sent_Cmd("[PF3]"); WaitSys(); return ; } for (var i=10; i<21; i=i+2) //循环明细列表信息 { if (Get_TxtFrm(i,5,1) != " ") //当前列数据不空 { ds.Tables[3].Rows[m]=[]; // 先新建一列为空 ds.Tables[3].Rows[m]["SO_NO"] = arrayofstrings[k]; var a = xmlDoc.getElementsByTagName("RLMOM151"); for (var j=0; j<a[0].childNodes.length; j++) { var currNode = a[0].childNodes[j]; ds.Tables[3].Rows[m][a[0].childNodes[j].nodeName] = Trim(Get_TxtFrm(parseInt(currNode.attributes[1].value) + parseInt(i) - 10,currNode.attributes[2].value,currNode.attributes[3].value)); } m = m + 1; if (i == 20) { var vfrom = parseInt(Trim(Get_TxtFrm(20,5,3))) + 1; Sent_TxtTo(vfrom,5,43); Sent_Cmd("[enter]"); WaitSys(); i = 8; } } else { break; } } //end for list } //end for arrayofstrings } //end if RLMOM151 else { return; } } //end if RLMOM101 else { return; } } //end if dataset have errors else { alert("There may be same incorrect contents in your imported data file. Please use the correct import format.") ; return; } Sent_Cmd("[PF3]"); //MODS版面跳转回到RLMOM101 WaitSys(); if (document.all["txtTag"].value.toUpperCase() == "PRE") //add by fubin.pan 03-24 { for (var i=0; i<ds.Tables[0].Rows.length; i++) { ds.Tables[0].Rows[i]["Consignee1"] = vconsignee1; ds.Tables[0].Rows[i]["Consignee2"] = vconsignee2; ds.Tables[0].Rows[i]["Consignee3"] = vconsignee3; } for (var i=0; i<ds.Tables[1].Rows.length; i++) { ds.Tables[1].Rows[i]["NotifyParty1"] = vnotifyparty; } } cb_GetModsData.ViewDataset(ds); alert("MODS Import completed."); if (vpre == "1") //新加PRE有验证不通过的话,完成后弹出信息 add by fubin.pan 03-19 { alert("Consignee, POR, POL, POD, Des should be the same within one Booking."); } //成功后关闭页面,返回主页面 add by guang.chen window.close (); } } return; } // --></mce:script>  

3)在服务器页面

protected void Page_Load(object sender, EventArgs e) { AjaxPro.Utility.RegisterTypeForAjax(typeof(cb_GetModsData)); }

4)并且定义刚才脚本中的两个Ajax函数

AjaxMethod#region AjaxMethod [AjaxMethod()] public DataSet GetCityList(int povinceid) ...{ DataSet ds = CreateDataTable(); return ds; } //[AjaxMethod()] [AjaxMethod(HttpSessionStateRequirement.ReadWrite)] public void ViewDataset(DataSet vdata) ...{ try ...{ MODSUtility mods = new MODSUtility(vdata); string booking_no = string.Empty; if (Session[BOOKING_NOFORMODS] != null) booking_no = Session[BOOKING_NOFORMODS].ToString(); if (!string.IsNullOrEmpty(booking_no)) Session["CarrierBookingInfoCB"] = mods.GetCBData(booking_no); else Session["CarrierBookingInfoCB"] = mods.GetCBData(); } catch (Exception ex) ...{ throw ex; } }

5)还有一点,我们需要在Web.config中去注册Ajax,因为我们用的是AjaxPro

             < add verb ="POST,GET" path ="ajaxpro/*.ashx" type ="AjaxPro.AjaxHandlerFactory, AjaxPro" />