public static List <ConsumptionInfo> DealWithSheet2(XSSFWorkbook wk)
{
try
{
var sheet = wk.GetSheet("Sheet2");
var rows = sheet.GetRowEnumerator();
var listOrderInfo = new List <ConsumptionInfo>();
rows.MoveNext();
while (rows.MoveNext())
{
var row = (IRow)rows.Current;
var order = new ConsumptionInfo();
order.MemberId = row.GetCell(0).ToString().Trim();
order.Subject = row.GetCell(1).StringCellValue.Trim();
var yearMonth = row.GetCell(2).DateCellValue;
order.Year = yearMonth.Year;
order.Month = yearMonth.Month;
order.Day = yearMonth.Day;
order.ConsumCount = (int)row.GetCell(3).NumericCellValue;
order.Count = (int)row.GetCell(4).NumericCellValue;
//order.StudentName = row.GetCell(5).StringCellValue;
listOrderInfo.Add(order);
}
return(listOrderInfo);
}catch (Exception ex)
{
MessageBox.Show("获取Sheet2数据出问题");
return(new List <ConsumptionInfo>());
}
}
private static bool EachOrderEachStudent(ConcurrentDictionary <string, int> studentConsumcount, ConsumptionInfo item, OrderInfo order)
{
var key = GetStudentConsumeKey(item.MemberId, order.OrderId);
var count = studentConsumcount.GetOrAdd(key, 0);
count += item.Count;
var result = false;
if (count >= order.Count)
{
order.FinishYearMonth = item.ComsumDate.ToString("yyyy-MM");
count -= order.Count;
result = true;
}
studentConsumcount.AddOrUpdate(key, count, (old, newvalue) => count);
return(result);
}