示例#1
0
        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++;
            }
        }