...
代码块 | ||||
---|---|---|---|---|
| ||||
using System; using System.Net; using System.Windows.Forms; using Newtonsoft.Json; using Newtonsoft.Json.Linq; using System.IO; namespace HttpRequestTest { public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void button1_Click(object sender, EventArgs e) { CookieContainer cookieContainer = new CookieContainer(); String serviceUrl = "http://localhost:80808060/smartbi"; Object ret = RemoteInvoker.invokeMethod(cookieContainer, serviceUrl, "UserService", "login", new String[] { "admin", "manager" }); if (ret.ToString().Equals("True")) { MessageBox.Show("登录成功"); } else { MessageBox.Show("登录失败"); return; } // 业务查询ID(对应示例库中的"根目录\功能演示\查询定义\原生SQL查询\带参数的原生SQL") String bizViewId = "I2c94907127855da201278df551b62602"; // 参数ID String paramId = "OutputParameter.I2c94907127855da201278df551b62602.产品名称参数_列表对话框"; // 参数真实值 String paramValue = "牛奶,花生,饼干,猪肉,汽水"; // JObject pobj = new JObject(); pobj["id"] = paramId; pobj["value"] = paramValue; JArray arr = new JArray(); arr.Add(pobj); // String paramsJsonArrStr = JsonConvert.SerializeObject(arr); // 每页行数 int rowsPerPage = 2; // 是否获取总行数 Boolean getTotalRows = true; JObject obj = (JObject)RemoteInvoker.invokeMethod(cookieContainer, serviceUrl, "BusinessViewService", "openLoadDataView", new Object[] { bizViewId, paramsJsonArrStr, rowsPerPage, getTotalRows }); String loadDataClientId = (String)obj["clientId"]; int totalRows = (int)obj["totalRowCount"]; JArray fieldNames = (JArray)obj["fieldNames"]; // JArray fieldTypes = (JArray)ret["fieldTypes"]; String fNames = ""; for (int i = 0; i < fieldNames.Count; i++) { fNames += fieldNames[i].ToString() + "\t"; } textBox1.AppendText(fNames + "\n"); int pages = totalRows / rowsPerPage + (totalRows % rowsPerPage == 0 ? 0 : 1); for (int pageNum = 0; pageNum < pages; pageNum++) { JArray pageData = (JArray)RemoteInvoker.invokeMethod(cookieContainer, serviceUrl, "BusinessViewService", "loadViewData", new Object[] { loadDataClientId, pageNum }); for (int j = 0; j < pageData.Count; j++) { String line = ""; JArray rowData = (JArray)pageData[j]; for (int k = 0; k < rowData.Count; k++) { line += (String)rowData[k] + "\t"; } textBox1.AppendText(line + "\n"); } } RemoteInvoker.invokeMethod(cookieContainer, serviceUrl, "BusinessViewService", "closeLoadDataView", new Object[] { loadDataClientId }); } private void button2_Click(object sender, EventArgs e) { CookieContainer cookieContainer = new CookieContainer(); String serviceUrl = "http://localhost:8060/smartbi"; Object ret = RemoteInvoker.invokeMethod(cookieContainer, serviceUrl, "UserService", "login", new String[] { "admin", "manager" }); if (ret.ToString().Equals("True")) { MessageBox.Show("登录成功"); } else { MessageBox.Show("登录失败"); return; } String resid = "I2c94908d162343520116234cb928003d"; JObject reportRet = (JObject)RemoteInvoker.invokeMethod(cookieContainer, serviceUrl, "ClientReportService", "openQuery", new String[] { resid }); JObject reportBean = (JObject)reportRet["reportBean"]; String clientId = (String)reportRet["clientId"]; String downloadURL = serviceUrl + "/vision/ExportServlet?delimiter=,&type=EXCEL2007&clientId=" + clientId; FileStream stream = new FileStream(@"E:\11.xlsx", FileMode.OpenOrCreate, FileAccess.Write); RemoteInvoker.InvokeBIOfficeDownload(cookieContainer, downloadURL, "post", stream); stream.Close(); RemoteInvoker.invokeMethod(cookieContainer, serviceUrl, "ClientReportService", "removeFromSession", new String[] { clientId }); } } } |
RemoteInvoker.cs
...