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\":[");
}
