public ToJsonMy2 IsBdBf(string username)
{
//构造获取openid及access_token的url
WxPayData data = new WxPayData();
data.SetValue("loginmobile", username);
string url = "http://47.110.134.105:8011/BAOHUTONG_H5/findCustInfo.action?" + data.ToUrl();
//请求url以获取数据
string json = HttpService.Get(url);
ToJsonMy2 ToJsonMy2 = JsonConvert.DeserializeObject <ToJsonMy2>(json);
return(ToJsonMy2);
}
public byte[] GetFHRList2ToFile(string yhm, string xm, string ispass)
{
using (DBConnection dbc = new DBConnection())
{
try
{
Workbook workbook = new Workbook(); //工作簿
Worksheet sheet = workbook.Worksheets[0]; //工作表
Cells cells = sheet.Cells; //单元格
//样式2
Style style2 = workbook.Styles[workbook.Styles.Add()];
style2.HorizontalAlignment = TextAlignmentType.Left; //文字居中
style2.Font.Name = "宋体"; //文字字体
style2.Font.Size = 14; //文字大小
style2.Font.IsBold = true; //粗体
style2.IsTextWrapped = true; //单元格内容自动换行
style2.Borders[BorderType.LeftBorder].LineStyle = CellBorderType.Thin; //应用边界线 左边界线
style2.Borders[BorderType.RightBorder].LineStyle = CellBorderType.Thin; //应用边界线 右边界线
style2.Borders[BorderType.TopBorder].LineStyle = CellBorderType.Thin; //应用边界线 上边界线
style2.Borders[BorderType.BottomBorder].LineStyle = CellBorderType.Thin; //应用边界线 下边界线
style2.IsLocked = true;
//样式3
Style style4 = workbook.Styles[workbook.Styles.Add()];
style4.HorizontalAlignment = TextAlignmentType.Left; //文字居中
style4.Font.Name = "宋体"; //文字字体
style4.Font.Size = 11; //文字大小
style4.Borders[BorderType.LeftBorder].LineStyle = CellBorderType.Thin;
style4.Borders[BorderType.RightBorder].LineStyle = CellBorderType.Thin;
style4.Borders[BorderType.TopBorder].LineStyle = CellBorderType.Thin;
style4.Borders[BorderType.BottomBorder].LineStyle = CellBorderType.Thin;
cells.SetRowHeight(0, 20);
cells[0, 0].PutValue("司机名称");
cells[0, 0].SetStyle(style2);
cells.SetColumnWidth(0, 20);
cells[0, 1].PutValue("登录名");
cells[0, 1].SetStyle(style2);
cells.SetColumnWidth(1, 20);
string _url = ServiceURL + "tbbfhrapply.selectApply";
string jsonParam = new JavaScriptSerializer().Serialize(new
{
tradeCode = "tbbfhrapply.selectApply",
status = ispass,
userid = "",
username = yhm,
userxm = xm,
//currentPage = 1,
//pageSize = 10,
closePagination = true
});
var request = (HttpWebRequest)WebRequest.Create(_url);
request.Method = "POST";
request.ContentType = "application/json;charset=UTF-8";
var byteData = Encoding.UTF8.GetBytes(jsonParam);
var length = byteData.Length;
request.ContentLength = length;
var writer = request.GetRequestStream();
writer.Write(byteData, 0, length);
writer.Close();
var response = (HttpWebResponse)request.GetResponse();
var responseString = new StreamReader(response.GetResponseStream(), Encoding.GetEncoding("utf-8")).ReadToEnd();
ToJsonMy2 ToJsonMy2 = JsonConvert.DeserializeObject <ToJsonMy2>(responseString); //将json数据转化为对象类型并赋值给list
zxlist[] list = ToJsonMy2.list;
if (list.Length > 0)
{
for (int i = 0; i < list.Length; i++)
{
if (list[i].param.userxm != null && list[i].param.userxm != "")
{
cells[i + 1, 0].PutValue(list[i].param.userxm);
cells[i + 1, 0].SetStyle(style4);
}
cells[i + 1, 1].PutValue(list[i].UserName);
cells[i + 1, 1].SetStyle(style4);
}
}
MemoryStream ms = workbook.SaveToStream();
byte[] bt = ms.ToArray();
return(bt);
}
catch (Exception ex)
{
throw ex;
}
}
}
