private bool uploadData() { bool goodData = true; bool uploaded = false; int errI = 0; string base64Str = ReadXlsToBase64(resultFile); try { Thread.Sleep(3000); XSSFWorkbook xssfworkbook = new XSSFWorkbook(new FileStream(resultFile, FileMode.Open)); ISheet sheetI = xssfworkbook.GetSheet("Data code"); IRow irow = sheetI.GetRow(0); string name = irow.GetCell(2).ToString(); IRow irow2 = sheetI.GetRow(1); string time = irow2.GetCell(2).DateCellValue.ToString(); DateTime ddd = DateTime.Parse(time); string ttime = ddd.ToString("yyyy-MM-dd HH:mm:ss"); DataList dl = new DataList(); dl.orderid = vjList.orderId; dl.testDate = ttime; dl.testUser = name; dl.verifyCode = verifyCode; //保存matrix //sheetI = xssfworkbook.GetSheet("Matrix"); //List<MatrixData> matrixList = new List<MatrixData>(); //for (int i = 2; i <= 10764; i++) //{ // IRow dataRow = sheetI.GetRow(i); // string code = dataRow.GetCell(0).ToString(); // string value = dataRow.GetCell(1) == null ? "" : dataRow.GetCell(1).ToString(); // if (value.Length == 0 || value == "#N/A") // { // value = "0"; // continue; // } // MatrixData md = new MatrixData(); // md.code = code; // md.value = value; // matrixList.Add(md); //} //dl.matrixDatas = matrixList; ///////////////////////////////////////////////// List <TestData> listData = new List <TestData>(); DataSet ds = LoginHelper.LoadData(dataFile); if (ds.Tables.Count > 0) { DataTable dt = ds.Tables[0]; foreach (DataRow dr in dt.Rows) { string dataSheet = dr[0].ToString(); int startRow = int.Parse(dr[1].ToString()); int endRow = int.Parse(dr[2].ToString()); int codeC = int.Parse(dr[3].ToString()); int keyC = int.Parse(dr[4].ToString()); int valueC = int.Parse(dr[5].ToString()); for (int i = startRow; i <= endRow; i++) { errI = i; ISheet sheet = xssfworkbook.GetSheet(dataSheet); IRow dataRow = sheet.GetRow(i); string code = dataRow.GetCell(codeC).ToString(); string key = dataRow.GetCell(keyC).ToString(); string value = dataRow.GetCell(valueC) == null ? "" : dataRow.GetCell(valueC).ToString(); if (value.Length == 0 || value == "#N/A") { //goodData = false; value = "0"; continue; } TestData td = new TestData(); td.id = key; td.value = value; td.code = code; listData.Add(td); } } } dl.testDatas = listData; string rtnJson = JsonConvert.SerializeObject(dl); //StreamWriter strmsave = new StreamWriter("E:\\newtest.txt", false, System.Text.Encoding.Default); //strmsave.Write(rtnJson); //strmsave.Close(); if (rtnJson.Length > 0) { string saveStr = webService.saveScheduling(rtnJson); if (saveStr == "1") { uploaded = true; } } if (base64Str.Length > 0) { string xlsOut = webService.fileOutXls(base64Str, verifyCode, dl.orderid, ttime); if (xlsOut == "1") { LogHelper.WriteLog(verifyCode + "---" + "base64上传成功"); } else { LogHelper.WriteLog(verifyCode + "---" + "base64上传失败"); } } } catch (Exception ex) { string errorStr = errI.ToString(); WriteLog("上传数据失败");//ex.ToString()); uploaded = false; } return(uploaded); }
private bool uploadData() { bool goodData = true; bool uploaded = false; int errI = 0; string base64Str = ReadXlsToBase64(resultFile); FileStream input = new FileStream(resultFile, FileMode.Open); try { XSSFWorkbook xssfworkbook = new XSSFWorkbook(input); ISheet sheetI = xssfworkbook.GetSheet("Data code"); IRow irow = sheetI.GetRow(0); string name = irow.GetCell(2).ToString(); IRow irow2 = sheetI.GetRow(1); string time = irow2.GetCell(2).DateCellValue.ToString(); DateTime ddd = DateTime.Parse(time); string ttime = ddd.ToString("yyyy-MM-dd HH:mm:ss"); DataList dl = new DataList(); dl.orderid = vjList.orderId; dl.testDate = ttime; dl.testUser = name; dl.verifyCode = verifyCode; List <TestData> listData = new List <TestData>(); DataSet ds = LoginHelper.LoadData(dataFile); if (ds.Tables.Count > 0) { DataTable dt = ds.Tables[0]; foreach (DataRow dr in dt.Rows) { string dataSheet = dr[0].ToString(); int startRow = int.Parse(dr[1].ToString()); int endRow = int.Parse(dr[2].ToString()); int codeC = int.Parse(dr[3].ToString()); int keyC = int.Parse(dr[4].ToString()); int valueC = int.Parse(dr[5].ToString()); for (int i = startRow; i <= endRow; i++) { errI = i; ISheet sheet = xssfworkbook.GetSheet(dataSheet); IRow dataRow = sheet.GetRow(i); string code = dataRow.GetCell(codeC).ToString(); string key = dataRow.GetCell(keyC).ToString(); string value = dataRow.GetCell(valueC) == null ? "" : dataRow.GetCell(valueC).ToString(); if (value.Length == 0 || value == "#N/A") { //goodData = false; value = "0"; continue; } TestData td = new TestData(); td.id = key; td.value = value; td.code = code; listData.Add(td); } } } dl.testDatas = listData; string rtnJson = JsonConvert.SerializeObject(dl); if (rtnJson.Length > 0) { string saveStr = webService.saveScheduling(rtnJson); if (saveStr == "1") { LogHelper.WriteLog(verifyCode + "---" + "DataCode上传成功"); } else { LogHelper.WriteLog(verifyCode + "---" + "DataCode上传失败"); } } if (base64Str.Length > 0) { string xlsOut = webService.fileOutXls(base64Str, verifyCode, dl.orderid, ttime); if (xlsOut == "1") { uploaded = true; LogHelper.WriteLog(verifyCode + "---" + "base64上传成功"); } else { LogHelper.WriteLog(verifyCode + "---" + "base64上传失败"); } } } catch (Exception ex) { if (File.Exists(reportFile)) { File.Delete(reportFile); } string errorStr = errI.ToString(); LogHelper.WriteLog("数据问题---------" + errorStr); uploaded = false; } finally { input.Close(); } return(uploaded); }