public void AddRouteInWayBill(DateTime date, Fields fields)
{
WayBillDaily wayBillDaily = new WayBillDaily(_car, date);
wayBillDaily.Load();
CopyWayBill(wayBillDaily);
int k = 0;
int beginDistance = wayBillDaily.BeginDistance;
int endDistance = wayBillDaily.EndDistance;
int curDistance = beginDistance;
foreach (WayBillDay wayBillDay in wayBillDaily)
{
int i = 6 + (47 * k);
foreach (Route route in wayBillDay)
{
MyPoint pointBegin = route.MyPoint1;
MyPoint 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());
}
}
public void AddRouteInWayBill(DateTime date, Fields fields)
{
WayBillDaily wayBillDaily = new WayBillDaily(_car, date);
wayBillDaily.Load();
CopyWayBill(wayBillDaily);
int k = 0;
int beginDistance = wayBillDaily.BeginDistance;
int endDistance = wayBillDaily.EndDistance;
int curDistance = beginDistance;
foreach (WayBillDay wayBillDay in wayBillDaily)
{
int i = 6 + (47 * k);
foreach (Route route in wayBillDay)
{
MyPoint pointBegin = route.MyPoint1;
MyPoint 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)
{
int 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++;
}
}
private void LoadWayBillDaily(Car car)
{
DateTime date = new DateTime(dtpDate.Value.Year, dtpDate.Value.Month, 1);
wayBillDaily = new WayBillDaily(car, date);
wayBillDaily.Load();
}
private void LoadWayBillCurrentWithoutCreate()
{
wayBillDaily = new WayBillDaily(list[index], dtpDate.Value);
dgv.DataSource = wayBillDaily.ToDataTable();
}
private void CopyWayBill(WayBillDaily wayBillDaily)
{
int 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++;
}
}
