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: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;
}
// 业务查询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.InvokeBIOfficeDownloadInvokeDownload(cookieContainer, downloadURL, "post", stream);
stream.Close();
RemoteInvoker.invokeMethod(cookieContainer, serviceUrl, "ClientReportService", "removeFromSession", new String[] { clientId });
}
}
} |