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++;
}
}
