protected void Page_Load(object sender, EventArgs e)
{
StringBuilder str_xml = new StringBuilder();
str_xml.Append("<CONNSTR>Data Source=lubang;Persist Security Info=True;Pooling=True;Max Pool Size = 512;User ID=BMAPP;Unicode=True;pwd=BMAPP</CONNSTR>");
str_xml.Append("<EXECSQL>");
str_xml.Append("Declare ");
str_xml.Append(" Sql_ Varchar2(4000); ");
str_xml.Append("Begin ");
str_xml.Append(" Sql_ := 'create or replace view a308_file_type as ");
str_xml.Append("select ''TXT'' as ID,''文本文件TXT(.txt)'' as name from dual ");
str_xml.Append("union select ''XLS'' as ID,''EXCEL文件(.xls)'' as name from dual ");
str_xml.Append("union select ''doc'' as ID,''Word文件(.doc)'' as name from dual ");
str_xml.Append("union select ''docx'' as ID,''Word文件(.docx)'' as name from dual ");
str_xml.Append("union select ''*'' as ID,''全部文件(.*)'' as name from dual'; ");
str_xml.Append(" Execute Immediate Sql_;");
str_xml.Append("End;");
str_xml.Append("</EXECSQL>");
Base.HttpRequest http = new Base.HttpRequest();
string url = "http://www.68hui.com:8001/execdo.aspx";
http.CharacterSet = "UTF-8";
http.OpenRequest(url, url, str_xml.ToString());
Response.Write(http.HtmlDocument);
}
protected void Page_Load(object sender, EventArgs e)
{
Base.HttpRequest http = new Base.HttpRequest();
// com.w_9eat.websoftinterface2010.WsWzMobile ws = new com.w_9eat.websoftinterface2010.WsWzMobile();
// string get_= ws.get_shop("ws0577", "shbomai", "123456");
// string url = "http://websoftinterface2010.9eat.com/wswzmobile/20131012/WsWzMobile.asmx?wsdl";//wsdl地址
//string url = "http://www.ldsms.com/SmsService.asmx?wsdl";//wsdl地址
//string name = "GetBalance";//javaWebService开放的接口
//TPSVService.WebServiceProxy wsd = new TPSVService.WebServiceProxy(url, name);
//string[] str = { "iek-8207", "bl,it6089" };
//try
//{
// string suc = (string)wsd.ExecuteQuery(name, str).ToString();
// Response.Write(suc);
//}
//catch(Exception ex )
//{
// Response.Write(ex.Message);
//}
string url = "http://websoftinterface2010.9eat.com/wswzmobile/20131012/WsWzMobile.asmx?wsdl"; //wsdl地址
string name = "get_shop"; //javaWebService开放的接口
TPSVService.WebServiceProxy wsd = new TPSVService.WebServiceProxy(url, name);
string[] str = { "ws0577", "shbomai", "123456" };
try
{
string suc = (string)wsd.ExecuteQuery(name, str).ToString();
Response.Write(suc);
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
//iek-8207
//bl,it6089
// http://localhost/App_WebReferences/com/w_9eat/websoftinterface2010/WsWzMobile.wsdl
// string smsurl = "http://websoftinterface2010.9eat.com/wswzmobile/20131012/WsWzMobile.asmx/get_shop?sn=ws0577&userid=shbomai&pwd=123456";
// string smsurl = "http://www.ldsms.com/SmsService.asmx/GetBalance?username=iek-8207&password=bl,it6089";
// http.OpenRequest(smsurl, smsurl);
}
protected void Page_Load(object sender, EventArgs e)
{
dt_data = Fun.getDtBySql("Select t.* from a319 t where t.state='1'");
a319_id = Request.QueryString["key"] == null ? "-1" : Request.QueryString["key"].ToString();
if ((a319_id == "" || a319_id == "-1") && dt_data.Rows.Count > 0)
{
a319_id = dt_data.Rows[0]["a319_id"].ToString();
}
dt_detail = Fun.getDtBySql("Select t.* from A31901_V01 t where t.a319_id='" + a319_id + "' order by t.col_id ");
Base.HttpRequest http = new Base.HttpRequest();
StringBuilder REQDATA = new StringBuilder();
//REQDATA.Append("<?xml version=\"1.0\" encoding=\"utf-8\"?>");
//REQDATA.Append("<miap>");
//REQDATA.Append("<miap-header>");
//REQDATA.Append("<transactionid>" + DateTime.Now.ToString("yyyyMMddHHmmssfff") + "</transactionid>");
//REQDATA.Append("<version>1.0</version>");
//REQDATA.Append("<messagename>getaddressidreq</messagename>");
//REQDATA.Append("</miap-header>");
//REQDATA.Append("<miap-Body>");
//REQDATA.Append("<getaddressidreq>");
//REQDATA.Append("<customerno>102419</customerno>");
//REQDATA.Append("</getaddressidreq>");
//REQDATA.Append("</miap-Body>");
//REQDATA.Append("</miap>");
//REQDATA.Append("<?xml version=\"1.0\" encoding=\"utf-8\"?>");
//REQDATA.Append("<miap>");
//REQDATA.Append("<miap-header>");
//REQDATA.Append("<transactionid>" + DateTime.Now.ToString("yyyyMMddHHmmssfff") + "</transactionid>");
//REQDATA.Append("<version>1.0</version>");
//REQDATA.Append("<messagename>getcostatereq</messagename>");
//REQDATA.Append("</miap-header>");
//REQDATA.Append("<miap-Body>");
//REQDATA.Append("<getcostatereq>");
//REQDATA.Append("<transid>100161</transid>");
//REQDATA.Append("</getcostatereq>");
//REQDATA.Append("<getcostatereq>");
//REQDATA.Append("<transid>100162</transid>");
//REQDATA.Append("</getcostatereq>");
//REQDATA.Append("<getcostatereq>");
//REQDATA.Append("<transid>100163</transid>");
//REQDATA.Append("</getcostatereq>");
//REQDATA.Append("<getcostatereq>");
//REQDATA.Append("<transid>100164</transid>");
//REQDATA.Append("</getcostatereq>");
//REQDATA.Append("<getcostatereq>");
//REQDATA.Append("<transid>100165</transid>");
//REQDATA.Append("</getcostatereq>");
//REQDATA.Append("</miap-Body>");
//REQDATA.Append("</miap>");
//#region 创建订单
//REQDATA.Append("<?xml version=\"1.0\" encoding=\"utf-8\"?>");
//REQDATA.Append("<miap>");
//REQDATA.Append("<miap-header>");
//REQDATA.Append("<transactionid>" + DateTime.Now.ToString("yyyyMMddHHmmssfff") + "</transactionid>");
//REQDATA.Append("<version>1.0</version>");
//REQDATA.Append("<messagename>newcoreq</messagename>");
//REQDATA.Append("</miap-header>");
//REQDATA.Append("<miap-Body>");
//REQDATA.Append("<newcoreq>");
//REQDATA.Append("<orderno>1000001</orderno>");
//REQDATA.Append("<customerno>990997</customerno>");
//REQDATA.Append("<contract>18</contract>");
//REQDATA.Append("<userid>USERTEST</userid>");
//REQDATA.Append("<ordertype>0</ordertype>");
//REQDATA.Append("<paytype>3</paytype>");
//REQDATA.Append("<payno>20000000001</payno>");
//REQDATA.Append("<paytime>20140810110810</paytime>");
//REQDATA.Append("<remark>ddddccc.c.c.cldddddd</remark>");
//REQDATA.Append("<amount>5370</amount>");
//REQDATA.Append("<shipcode>B23</shipcode>");
//REQDATA.Append("<shipamount>123</shipamount>");
//REQDATA.Append("<othersamount>-89</othersamount>");
//REQDATA.Append("<invoiceflag>0</invoiceflag>");
//REQDATA.Append("<invoicehead></invoicehead>");
//REQDATA.Append("<invoiceprocject></invoiceprocject>");
//REQDATA.Append("<invoiceamount></invoiceamount>");
//REQDATA.Append("<addressid>01</addressid>");
//REQDATA.Append("<address>中山西路1000号XX大厦1号楼****室</address>");
//REQDATA.Append("<state>上海市</state>");
//REQDATA.Append("<city>徐汇区</city>");
//REQDATA.Append("<zipcode>100001</zipcode>");
//REQDATA.Append("<name>XXXXXX</name>");
//REQDATA.Append("<phone>021-12345678</phone>");
//REQDATA.Append("<fax>021-12345679</fax>");
//REQDATA.Append("<email>XXXXXXXXX@wwww.*****.com</email>");
//REQDATA.Append("<mobile>13112345678</mobile>");
//REQDATA.Append("<partlist>");
//REQDATA.Append("<detail>");
//REQDATA.Append("<partno>110410602078</partno>");
//REQDATA.Append("<qty>10</qty>");
//REQDATA.Append("<saleprice>426</saleprice>");
//REQDATA.Append("<amount>4260</amount>");
//REQDATA.Append("<lineremark>dddaaa,ddd|ddd.,ddd;|</lineremark>");
//REQDATA.Append("</detail>");
//REQDATA.Append("<detail>");
//REQDATA.Append("<partno>110410600321</partno>");
//REQDATA.Append("<qty>10</qty>");
//REQDATA.Append("<saleprice>111</saleprice>");
//REQDATA.Append("<amount>1110</amount>");
//REQDATA.Append("<lineremark>222dddaaa,ddd|ddd.,ddd;|</lineremark>");
//REQDATA.Append("</detail>");
//REQDATA.Append("</partlist>");
//REQDATA.Append("</newcoreq>");
//REQDATA.Append("</miap-Body>");
//REQDATA.Append("</miap>");
//#endregion
http.CharacterSet = "utf-8";
Reqxml = get_modifuaddress();// REQDATA.ToString();
SaveLog.Verification(Reqxml);
http.OpenRequest(REQURL, REQURL, Reqxml);
Responsexml = http.HtmlDocument;
}
