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 void PrintProxyOnSTO() { WordDoc wordDoc = CreateProxyOnSTO(); wordDoc.setValue("до 31 декабря 2017 года", "до 31 декабря 2018 года"); MyDateTime myDate = new MyDateTime(DateTime.Today.ToShortDateString()); wordDoc.setValue(myDate.ToLongString(), "01 января 2018"); //wordDoc.Show(); wordDoc.Print(); }
public void CreatePolicyTable() { const int INDEX_BEGIN = 6; DateTime date = DateTime.Today.AddMonths(1); _excelDoc = openDocumentExcel("Таблица страхования"); MyDateTime myDate = new MyDateTime(date.ToShortDateString()); _excelDoc.setValue(2, 1, "Страхуем в " + myDate.MonthToStringPrepositive() + " " + myDate.Year + " г."); PolicyList policyList = PolicyList.getInstance(); List <Policy> list = policyList.GetPolicyList(date); List <Car> listCar = policyList.GetCarListByPolicyList(list); DiagCardList diagCardList = DiagCardList.getInstance(); int rowIndex = INDEX_BEGIN; foreach (Car car in listCar) { _excelDoc.setValue(rowIndex, 2, car.Grz); _excelDoc.setValue(rowIndex, 3, car.Mark.Name); _excelDoc.setValue(rowIndex, 4, car.info.Model); _excelDoc.setValue(rowIndex, 5, car.vin); _excelDoc.setValue(rowIndex, 6, car.Year); _excelDoc.setValue(rowIndex, 7, GetPolicyBeginDate(list, car, PolicyType.ОСАГО)); _excelDoc.setValue(rowIndex, 8, GetPolicyBeginDate(list, car, PolicyType.КАСКО)); _excelDoc.setValue(rowIndex, 9, car.info.Owner); _excelDoc.setValue(rowIndex, 10, car.info.Owner); _excelDoc.setValue(rowIndex, 11, car.info.Owner); DiagCard diagCard = diagCardList.getItem(car); if (diagCard != null) { _excelDoc.setValue(rowIndex, 12, diagCard.Date.ToShortDateString()); _excelDoc.setValue(rowIndex, 13, diagCard.Number); } rowIndex++; } _excelDoc.Show(); }
public static List<string> GetDataSource(DataGridView dgv, string columnName) { if (dgv == null) return null; List<string> list = new List<string>(); foreach (DataGridViewRow row in dgv.Rows) { string value = row.Cells[columnName].Value.ToString(); string endColumnHeader = columnName.Substring(columnName.Length - 3, 3); if ((endColumnHeader == "руб") || (value.Trim() == string.Empty)) continue; if (IsDate(value)) { MyDateTime myDate = new MyDateTime(value); value = myDate.ToString(); } if ((row.Visible) && (!IsInList(list, value))) list.Add(value); } DataTable dt = new DataTable(); dt.Columns.Add("Название"); list.Sort(); if (list.Count > 0) list.Insert(0, "(все)"); return list; }
public void SetFilterValue(string columnName, Point point) { int i = -1; for (i = 0; i < labelList.Count; i++) { if (labelList[i].Text == columnName) break; } if (i >= comboList.Count) return; string value = _dgv.Rows[point.Y].Cells[point.X].Value.ToString(); foreach (CheckBoxComboBoxItem item in comboList[i].CheckBoxItems) { if (MyDateTime.IsDate(value)) { MyDateTime myDate = new MyDateTime(value); value = myDate.ToString(); } if (item.Text == value) { item.Checked = true; break; } } ApplyFilter(); }
private void changeVisibleByFilter() { saveFilterValue(); SetVisibleAllRows(); _dgv.CurrentCell = null; bool filtersNotSet = true; for (int comboIndex = 0; comboIndex < comboList.Count; comboIndex++) { if (IsFilterEmpty(comboIndex)) continue; filtersNotSet = false; if (!IsAllSelected(comboIndex)) { foreach (DataGridViewRow row in _dgv.Rows) { string dgvValue = row.Cells[comboList[comboIndex].Name].Value.ToString(); if (MyDateTime.IsDate(dgvValue)) { MyDateTime myDate = new MyDateTime(dgvValue); dgvValue = myDate.ToString(); } row.Visible = ((IsEqualsFilterValue(comboIndex, dgvValue)) && (row.Visible == true)); } } } if (filtersNotSet) SetVisibleAllRows(); }
internal DateTime MonthToString() { MyDateTime myDate = new MyDateTime(Date.ToShortDateString()); return (_count == 0) ? new DateTime(DateTime.Today.Year, 1, 31) : Date; }
/* Старое извещение * 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); }
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()); wordDoc.setValue("ФИО регионального представителя", driver.GetName(NameType.Full)); PassportList passportList = PassportList.getInstance(); Passport 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 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 PrintProxyOnSTO() { WordDoc wordDoc = CreateProxyOnSTO(); wordDoc.setValue("до 31 декабря 2015 года", "до 31 декабря 2016 года"); MyDateTime myDate = new MyDateTime(DateTime.Today.ToShortDateString()); wordDoc.setValue(myDate.ToLongString(), "01 февраля 2016"); wordDoc.Print(); }
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); 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); }
public void CreatePolicyTable() { const int INDEX_BEGIN = 6; DateTime date = DateTime.Today.AddMonths(1); _excelDoc = openDocumentExcel("Таблица страхования"); MyDateTime myDate = new MyDateTime(date.ToShortDateString()); _excelDoc.setValue(2, 1, "Страхуем в " + myDate.MonthToStringPrepositive() + " " + myDate.Year + " г."); PolicyList policyList = PolicyList.getInstance(); List<Policy> list = policyList.GetPolicyList(date); List<Car> listCar = policyList.GetCarListByPolicyList(list); DiagCardList diagCardList = DiagCardList.getInstance(); int rowIndex = INDEX_BEGIN; foreach (Car car in listCar) { _excelDoc.setValue(rowIndex, 2, car.Grz); _excelDoc.setValue(rowIndex, 3, car.Mark.Name); _excelDoc.setValue(rowIndex, 4, car.info.Model); _excelDoc.setValue(rowIndex, 5, car.vin); _excelDoc.setValue(rowIndex, 6, car.Year); _excelDoc.setValue(rowIndex, 7, GetPolicyBeginDate(list, car, PolicyType.ОСАГО)); _excelDoc.setValue(rowIndex, 8, GetPolicyBeginDate(list, car, PolicyType.КАСКО)); _excelDoc.setValue(rowIndex, 9, car.info.Owner); _excelDoc.setValue(rowIndex, 10, car.info.Owner); _excelDoc.setValue(rowIndex, 11, car.info.Owner); DiagCard diagCard = diagCardList.getItem(car); if (diagCard != null) { _excelDoc.setValue(rowIndex, 12, diagCard.Date.ToShortDateString()); _excelDoc.setValue(rowIndex, 13, diagCard.Number); } rowIndex++; } _excelDoc.Show(); }