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();
}
