public void showNotice(DTP dtp) { _excelDoc = openDocumentExcel("Извещение о страховом случае"); Owners owners = Owners.getInstance(); _excelDoc.setValue(6, 5, owners.getItem(Convert.ToInt32(_car.ownerID))); //страхователь _excelDoc.setValue(7, 6, "а/я 34, 196128"); //почтовый адрес _excelDoc.setValue(8, 7, "320-40-04"); //телефон DriverCarList driverCarList = DriverCarList.getInstance(); Driver driver = driverCarList.GetDriver(_car, dtp.Date); PassportList passportList = PassportList.getInstance(); Passport passport = passportList.getLastPassport(driver); if (passport.Number != string.Empty) { string number = passport.Number; string[] numbers = number.Split(' '); _excelDoc.setValue(10, 3, numbers[0]); //серия _excelDoc.setValue(10, 6, numbers[1]); //номер _excelDoc.setValue(11, 3, passport.GiveOrg); //кем выдан _excelDoc.setValue(12, 4, passport.GiveDate.ToShortDateString()); //дата выдачи } PolicyList policyList = PolicyList.getInstance(); Policy policy = policyList.getItem(_car, PolicyType.КАСКО); _excelDoc.setValue(14, 6, policy.Number); //полис _excelDoc.setValue(16, 6, string.Concat(_car.Mark.Name, " ", _car.info.Model)); //марка а/м _excelDoc.setValue(18, 6, _car.Grz); //рег номер а/м _excelDoc.setValue(20, 6, _car.vin); //вин _excelDoc.setValue(22, 6, dtp.Date.ToShortDateString()); //дата дтп _excelDoc.setValue(27, 2, driver.GetName(NameType.Full)); //водитель фио Regions regions = Regions.getInstance(); _excelDoc.setValue(29, 3, regions.getItem(Convert.ToInt32(dtp.IDRegion))); //город _excelDoc.setValue(31, 14, dtp.Damage); //повреждения _excelDoc.setValue(33, 2, dtp.Facts); //обстоятельства происшествия //SsDTP ssDTP = SsDTPList.getInstance().getItem(_car.Mark); //_excelDoc.setValue(63, 11, ssDTP.ServiceStantion); //DateTime date = DateTime.Today; //MyDateTime myDate = new MyDateTime(date.ToShortDateString()); //_excelDoc.setValue(71, 3, string.Concat("« ", date.Day.ToString(), " »")); //_excelDoc.setValue(71, 4, myDate.MonthToStringGenitive()); //_excelDoc.setValue(71, 8, date.Year.ToString().Substring(2, 2)); _excelDoc.Show(); }
private WordDoc CreateProxyOnSTO() { WordDoc wordDoc = openDocumentWord("Доверенность на предоставление интересов на СТО"); DriverCarList driverCarList = DriverCarList.getInstance(); Driver driver = (_invoice == null) ? driverCarList.GetDriver(_car) : driverList.getItem(Convert.ToInt32(_invoice.DriverToID)); MyDateTime myDate = new MyDateTime(DateTime.Today.ToShortDateString()); wordDoc.setValue("текущая дата", myDate.ToLongString()); String fio = String.Empty; if (driver != null) { fio = driver.GetName(NameType.Full); } wordDoc.setValue("ФИО регионального представителя", fio); PassportList passportList = PassportList.getInstance(); Passport passport = null; if (driver != null) { passport = passportList.getLastPassport(driver); } string passportToString = "нет данных"; if (passport != null) { passportToString = string.Concat(passport.Number, ", выдан ", passport.GiveDate.ToShortDateString(), ", ", passport.GiveOrg, ", Адрес: ", passport.Address); } wordDoc.setValue("паспорт регионального представителя", passportToString); string fullNameAuto = string.Concat(_car.Mark.Name, " ", _car.info.Model); wordDoc.setValue("Название марки автомобиля", fullNameAuto); wordDoc.setValue("VIN-автомобиля", _car.vin); wordDoc.setValue("Модель и марка двигателя автомобиля", _car.eNumber); wordDoc.setValue("Номер кузова автомобиля", _car.bodyNumber); wordDoc.setValue("Год выпуска автомобиля", _car.Year); wordDoc.setValue("Цвет автомобиля", _car.info.Color); PTSList ptsList = PTSList.getInstance(); PTS pts = ptsList.getItem(_car); string ptsName = string.Concat(pts.Number, ", выдан ", pts.Date.ToShortDateString(), " ", pts.GiveOrg); wordDoc.setValue("ПТС автомобиля", ptsName); wordDoc.setValue("ГРЗ автомобиля", _car.Grz); wordDoc.setValue("текущий год", DateTime.Today.Year.ToString()); return(wordDoc); }
public static string Send(Car car, PolicyType type) { EMail mail = new EMail(); mail.sendMailPolicy(car, type); DriverCarList driverCarList = DriverCarList.getInstance(); Driver driver = driverCarList.GetDriver(car); return(string.Concat("Полис ", type.ToString(), " отправлен на адрес ", driver.email)); }
/* Старое извещение * public void showNotice(DTP dtp) * { * _excelDoc = openDocumentExcel("Извещение о страховом случае"); * * Owners owners = Owners.getInstance(); * * _excelDoc.setValue(7, 4, owners.getItem(Convert.ToInt32(_car.ownerID))); * _excelDoc.setValue(8, 5, "а/я 34, 196128"); * _excelDoc.setValue(9, 6, "320-40-04"); * * DriverCarList driverCarList = DriverCarList.getInstance(); * Driver driver = driverCarList.GetDriver(_car, dtp.Date); * * PassportList passportList = PassportList.getInstance(); * Passport passport = passportList.getLastPassport(driver); * * if (passport.Number != string.Empty) * { * string number = passport.Number; * string[] numbers = number.Split(' '); * * _excelDoc.setValue(11, 2, numbers[0]); * _excelDoc.setValue(11, 5, numbers[1]); * * _excelDoc.setValue(12, 2, passport.GiveOrg); * _excelDoc.setValue(13, 3, passport.GiveDate.ToShortDateString()); * } * * PolicyList policyList = PolicyList.getInstance(); * Policy policy = policyList.getItem(_car, PolicyType.КАСКО); * _excelDoc.setValue(15, 5, policy.Number); * * _excelDoc.setValue(17, 5, string.Concat(_car.Mark.Name, " ", _car.info.Model)); * _excelDoc.setValue(19, 5, _car.Grz); * _excelDoc.setValue(21, 5, _car.vin); * * _excelDoc.setValue(23, 5, dtp.Date.ToShortDateString()); * * _excelDoc.setValue(28, 1, driver.GetName(NameType.Full)); * * Regions regions = Regions.getInstance(); * * _excelDoc.setValue(30, 2, regions.getItem(Convert.ToInt32(dtp.IDRegion))); * _excelDoc.setValue(32, 13, dtp.Damage); * _excelDoc.setValue(34, 1, dtp.Facts); * * SsDTP ssDTP = SsDTPList.getInstance().getItem(_car.Mark); * * _excelDoc.setValue(63, 11, ssDTP.ServiceStantion); * * DateTime date = DateTime.Today; * MyDateTime myDate = new MyDateTime(date.ToShortDateString()); * * _excelDoc.setValue(71, 3, string.Concat("« ", date.Day.ToString(), " »")); * _excelDoc.setValue(71, 4, myDate.MonthToStringGenitive()); * _excelDoc.setValue(71, 8, date.Year.ToString().Substring(2, 2)); * * _excelDoc.Show(); * } * */ public void createWaybill(DateTime date, Driver driver = null) { date = new DateTime(date.Year, date.Month, 1); if (driver == null) { DriverCarList driverCarList = DriverCarList.getInstance(); driver = driverCarList.GetDriver(_car, date); if (driver == null) { driver = driverCarList.GetDriver(_car); InvoiceList invoiceList = InvoiceList.getInstance(); Invoice invoice = invoiceList.getItem(_car); if ((invoice != null) && (!string.IsNullOrEmpty(invoice.DateMove))) { DateTime dateMove; DateTime.TryParse(invoice.DateMove, out dateMove); if ((dateMove.Year == date.Year) && (dateMove.Month == date.Month)) { date = new DateTime(date.Year, date.Month, dateMove.Day); } } } } _excelDoc = openDocumentExcel("Путевой лист"); _excelDoc.setValue(4, 28, _car.BBNumber.ToString()); MyDateTime myDate = new MyDateTime(date.ToShortDateString()); _excelDoc.setValue(4, 39, driver.ID.ToString() + "/01/" + myDate.MonthSlashYear()); _excelDoc.setValue(6, 15, myDate.DaysRange); _excelDoc.setValue(6, 19, myDate.MonthToStringNominative()); _excelDoc.setValue(6, 32, date.Year.ToString()); _excelDoc.setValue(29, 35, _car.info.Grade.EngineType.ShortName); MileageMonthList mml = new MileageMonthList(_car.ID, date.Year + "-" + date.Month + "-01"); /* Из файла Татьяны Мироновой пробег за месяц */ _excelDoc.setValue(19, 39, mml.PSN); _excelDoc.setValue(33, 41, mml.Gas); _excelDoc.setValue(35, 41, mml.GasBegin); _excelDoc.setValue(36, 41, mml.GasEnd); _excelDoc.setValue(37, 41, mml.GasNorm); _excelDoc.setValue(38, 41, mml.GasNorm); _excelDoc.setValue(43, 39, mml.PSK); _excelDoc.setValue(41, 59, mml.Mileage); Owners owners = Owners.getInstance(); string owner = owners.getItem(1); _excelDoc.setValue(8, 8, owner); _excelDoc.setValue(10, 11, string.Concat(_car.Mark.Name, " ", _car.info.Model)); _excelDoc.setValue(11, 17, _car.Grz); _excelDoc.setValue(12, 6, driver.GetName(NameType.Full)); _excelDoc.setValue(44, 16, driver.GetName(NameType.Short)); _excelDoc.setValue(26, 40, driver.GetName(NameType.Short)); LicenseList licencesList = LicenseList.getInstance(); DriverLicense driverLicense = licencesList.getItem(driver); _excelDoc.setValue(14, 10, driverLicense.Number); _excelDoc.setValue(20, 9, owner); string suppyAddressName; if (driver.suppyAddress != string.Empty) { suppyAddressName = driver.suppyAddress; } else { SuppyAddressList suppyAddressList = SuppyAddressList.getInstance(); SuppyAddress suppyAddress = suppyAddressList.getItemByRegion(driver.Region.ID); if (suppyAddress != null) { suppyAddressName = suppyAddress.ToString(); } else { PassportList passportList = PassportList.getInstance(); Passport passport = passportList.getLastPassport(driver); suppyAddressName = passport.Address; } } string suppyAddressName2 = string.Empty; if (suppyAddressName.Length > 40) { for (int i = 30; i < suppyAddressName.Length; i++) { if (suppyAddressName[i] == ' ') { suppyAddressName2 = suppyAddressName.Substring(i, suppyAddressName.Length - i); suppyAddressName = suppyAddressName.Substring(0, i); } } } _excelDoc.setValue(25, 8, suppyAddressName); _excelDoc.setValue(26, 1, suppyAddressName2); string mechanicName; EmployeesList employeesList = EmployeesList.getInstance(); Employees accountant = employeesList.getItem(driver.Region, "Бухгалтер Б.Браун"); if (driver.IsOne) { mechanicName = driver.GetName(NameType.Short); } else { Employees mechanic = employeesList.getItem(driver.Region, "Механик", true); if (mechanic == null) { mechanicName = driver.GetName(NameType.Short); } else { mechanicName = mechanic.Name; } } Employees dispatcher = employeesList.getItem(driver.Region, "Диспечер-нарядчик"); string dispatcherName = dispatcher.Name; _excelDoc.setValue(22, 40, mechanicName); _excelDoc.setValue(44, 40, mechanicName); _excelDoc.setValue(31, 18, dispatcherName); _excelDoc.setValue(35, 18, dispatcherName); _excelDoc.setValue(43, 72, accountant.Name); }