public void AddRouteInWayBill(DateTime date, Fields fields) { var wayBillDaily = new WayBillDaily(_car, date); wayBillDaily.Load(); CopyWayBill(wayBillDaily); var k = 0; var beginDistance = wayBillDaily.BeginDistance; var endDistance = wayBillDaily.EndDistance; var curDistance = beginDistance; foreach (WayBillDay wayBillDay in wayBillDaily) { var i = 6 + (47 * k); foreach (Route route in wayBillDay) { var pointBegin = route.MyPoint1; var pointEnd = route.MyPoint2; _excelDoc.setValue(i, 59, pointBegin.Name); _excelDoc.setValue(i, 64, pointEnd.Name); _excelDoc.setValue(i, 78, route.Distance.ToString()); i += 2; } _excelDoc.setValue(29 + (47 * k), 20, wayBillDay.Date.ToShortDateString()); _excelDoc.setValue(19 + (47 * k), 39, curDistance.ToString()); curDistance += wayBillDay.Distance; if (fields == Fields.All) { _excelDoc.setValue(43 + (47 * k), 39, curDistance.ToString()); _excelDoc.setValue(41 + (47 * k), 59, wayBillDay.Distance.ToString()); _excelDoc.setValue(33 + (47 * k), 20, wayBillDay.Date.ToShortDateString()); } k++; } if (k > 0 && fields == Fields.All) { _excelDoc.setValue(43 + (47 * (k - 1)), 39, endDistance.ToString()); } }
private void CopyWayBill(WayBillDaily wayBillDaily) { var i = 0; foreach (WayBillDay item in wayBillDaily) { if (i > 0) { _excelDoc.CopyRange("A1", "CF46", "A" + ((47 * i) + 1).ToString()); } _excelDoc.setValue(6 + (47 * i), 15, item.Day); _excelDoc.setValue(4 + (47 * i), 39, GetWaBillFullNumber(i + 1)); _excelDoc.setValue(12 + (47 * i), 6, item.Driver.GetName(NameType.Full)); _excelDoc.setValue(44 + (47 * i), 16, item.Driver.GetName(NameType.Short)); _excelDoc.setValue(26 + (47 * i), 40, item.Driver.GetName(NameType.Short)); i++; } }