private void button1_Click(object sender, EventArgs e) { string strToken = ""; string strFYid = ""; Post post = new Post(); //string strJson=post.GetFYData(); //jsonTool jsonTool = new jsonTool(); //string error = ""; //List<FYModel> fyModel = jsonTool.GLJsonOutData(strJson,out error); List <FYModel> fyModel = post.GetFYData(); string filePath = AppDomain.CurrentDomain.BaseDirectory + "转运单号.xls"; npoi npoi = new npoi(); string result = npoi.WriteFile(filePath, fyModel); if (result == "1") { MessageBox.Show("输出成功", "信息", MessageBoxButtons.OK); } //strToken = post.GetToken(); //if(strToken.Substring(0,5)!="error") //{ // strFYid = post.GetFYJson(strToken); //} }
/// <summary> /// 获取excel文件的json数据 /// </summary> /// <returns></returns> public List <FYModel> GetFYData() { string result = ""; npoi npoi = new npoi(); Post post = new Post(); string strToken = ""; int pageNum = 100; //页大小 List <FYModel> fyModel = new List <FYModel>(); StringBuilder strjson = new StringBuilder(); string filePath = AppDomain.CurrentDomain.BaseDirectory + "速派运单.xls"; List <string> listDH = npoi.GetDH(filePath); if (listDH.Count > pageNum) { int count = listDH.Count; int pagecount = count / 100; //总页数 int pageNow = 0; //当前页数 //int ys = count % 100; strToken = post.GetToken(); //int pageCount = 0; //已经计算完的单数 TimeSpan ts = DateTime.UtcNow - new DateTime(1970, 1, 1, 0, 0, 0, 0); strjson.Append("{\"original_no\":["); for (int i = 0; i < count; i++) { if (listDH[i].Trim() != "") { strjson.AppendFormat("{0}{1}{2}", "\"", listDH[i], "\","); if ((i + 1) % pageNum == 0) { //string str=strjson.ToString(); //str.Substring(0, str.Length - 2); //strjson.Clear(); //strjson.Append(str); strjson.Remove(strjson.Length - 1, 1); strjson.Append(@"]}"); string token = GetNewToken(ts); if (token != "1") //重新新建了token { strToken = token; ts = DateTime.UtcNow - new DateTime(1970, 1, 1, 0, 0, 0, 0); } //strToken = post.GetToken(); if (strToken.Substring(0, 5) != "error") { result = post.GetFYJson(strToken, strjson.ToString()); fyModel = this.AddFyModel(result, fyModel); } strjson.Clear(); strjson.Append("{\"original_no\":["); pageNow = pageNow + 1; } //当单号等于整数页数 if (pageNow == pagecount) { //不是最后一条记录 if (i < (count - 1)) { if ((listDH[i + 1].Trim() == "")) { strjson.Remove(strjson.Length - 1, 1); strjson.Append(@"]}"); string token = GetNewToken(ts); if (token != "1") { strToken = token; ts = DateTime.UtcNow - new DateTime(1970, 1, 1, 0, 0, 0, 0); } //strToken = post.GetToken(); if (strToken.Substring(0, 5) != "error") { result = post.GetFYJson(strToken, strjson.ToString()); fyModel = this.AddFyModel(result, fyModel); } break; } } //是最后一条记录 else { strjson.Remove(strjson.Length - 1, 1); strjson.Append(@"]}"); string token = GetNewToken(ts); if (token != "1") { strToken = token; ts = DateTime.UtcNow - new DateTime(1970, 1, 1, 0, 0, 0, 0); } //strToken = post.GetToken(); if (strToken.Substring(0, 5) != "error") { result = post.GetFYJson(strToken, strjson.ToString()); fyModel = this.AddFyModel(result, fyModel); } break; } } } } } else { int count = listDH.Count; //int pagecount = count / 100; //int ys = count % 100; strToken = post.GetToken(); strjson.Append("{\"original_no\":["); for (int i = 0; i <= count; i++) { if (listDH[i].Trim() != "") { strjson.AppendFormat("{0}{1}{2}", "\"", listDH[i], "\","); if ((i / pageNum == 0) && (listDH[i + 1].Trim() == "")) { strjson.Remove(strjson.Length - 1, 1); strjson.Append(@"]}"); if (strToken.Substring(0, 5) != "error") { result = post.GetFYJson(strToken, strjson.ToString()); fyModel = this.AddFyModel(result, fyModel); } break; } } } } return(fyModel); //strjson.Append("{\"original_no\":["); }