private void button5_Click(object sender, EventArgs e)
{
if (job.CurrentIndex != job.Count)
{
Comment com = new Comment();
com.ShowDialog();
string txt = com.CommentText;
XSSFWorkbook workbook = ExcelDataTableUtil.LoadExcel(job.JobPath);
XSSFSheet sheet = (XSSFSheet)workbook.GetSheetAt(0);
XSSFRow row = (XSSFRow)sheet.GetRow(job.CurrentIndex);
row.Cells[dt.Columns.Count - 2].SetCellValue("U");
XSSFColor XlColour = new XSSFColor(button5.BackColor);
XSSFCellStyle cellstyle = (XSSFCellStyle)workbook.CreateCellStyle();
cellstyle.SetFillForegroundColor(XlColour);
cellstyle.FillPattern = NPOI.SS.UserModel.FillPattern.SolidForeground;
row.Cells[dt.Columns.Count - 2].CellStyle = cellstyle;
row.Cells[dt.Columns.Count - 1].SetCellValue(txt);
ExcelDataTableUtil.WriteExcel(workbook, job.JobPath);
job.CurrentIndex++;
job.HasFinished++;
Judge();
}
else
{
MessageBox.Show("已经是最后一条了");
}
}
private void button3_Click(object sender, EventArgs e)
{
if (job.CurrentIndex != job.Count)
{
Comment com = new Comment();
com.ShowDialog();
string txt = com.CommentText;
XSSFWorkbook workbook = ExcelDataTableUtil.LoadExcel(job.JobPath);
XSSFSheet sheet = (XSSFSheet)workbook.GetSheetAt(0);
XSSFRow row = (XSSFRow)sheet.GetRow(job.CurrentIndex);
row.Cells[dt.Columns.Count - 2].SetCellValue("Y");
row.Cells[dt.Columns.Count - 1].SetCellValue(txt);
ExcelDataTableUtil.WriteExcel(workbook, job.JobPath);
job.CurrentIndex++;
job.HasFinished++;
Judge();
}
else
{
MessageBox.Show("已经是最后一条了");
}
}
