internal override object[] GetRow()
{
MedicalCertList medicalCertList = MedicalCertList.getInstance();
MedicalCert medicalCert = medicalCertList.getItem(this);
string medicalCertStatus = ((medicalCert == null) || (!medicalCert.IsActual())) ? "нет" : "есть";
LicenseList licenseList = LicenseList.getInstance();
DriverLicense license = licenseList.getItem(this);
string licenseStatus = ((license == null) || (!license.IsActual())) ? "нет" : "есть";
DriverCarList driverCarList = DriverCarList.getInstance();
Car car = driverCarList.GetCar(this);
return(new object[]
{
Id,
0,
GetName(NameType.Full),
licenseStatus,
medicalCertStatus,
(car == null) ? "нет автомобиля" : car.ToString(),
Region.Name,
CompanyName,
Status
});
}
public formLicenseList(Driver driver)
{
InitializeComponent();
_driver = driver;
_licencesList = LicenseList.getInstance();
}
private void FillDriverLicense()
{
LicenseList licencesList = LicenseList.getInstance();
DriverLicense driverLicense = licencesList.getItem(_driver);
if (driverLicense != null)
{
licenceInfo.Text = driverLicense.ToString();
}
}
private void driverLicenseToolStripMenuItem_Click(object sender, EventArgs e)
{
DTP dtp = _dtpList.getItem(Convert.ToInt32(_dgvDTP.Rows[_dgvDTP.SelectedCells[0].RowIndex].Cells[0].Value));
Driver driver = _driverCarList.GetDriver(dtp.Car, dtp.Date);
LicenseList licencesList = LicenseList.getInstance();
DriverLicense driverLicense = licencesList.getItem(driver);
WorkWithFiles.OpenFile(driverLicense.File);
}
public override void Save()
{
DeleteFile(File);
File = WorkWithFiles.fileCopyByID(File, "drivers", Driver.ID, "DriverLicense", Number);
ExecSave();
LicenseList licenseList = LicenseList.getInstance();
licenseList.Add(this);
}
private void formatDGV()
{
_dgvDrivers.Columns[0].Visible = false;
ResizeDGV();
foreach (DataGridViewRow row in _dgvDrivers.Rows)
{
int idDriver = 0;
int.TryParse(row.Cells[0].Value.ToString(), out idDriver);
Driver driver = driverList.getItem(idDriver);
LicenseList licenseList = LicenseList.getInstance();
DriverLicense license = licenseList.getItem(driver);
MedicalCertList medicalCertList = MedicalCertList.getInstance();
MedicalCert medicalCert = medicalCertList.getItem(driver);
if (!license.IsActual() || !medicalCert.IsActual())
{
row.DefaultCellStyle.BackColor = Color.LightYellow;
}
if (driver.Fired)
{
row.DefaultCellStyle.ForeColor = Color.Red;
}
if (((driver.OwnerID < 3) && (string.IsNullOrEmpty(driver.Number))) || (driver.Decret))
{
row.DefaultCellStyle.ForeColor = Color.Blue;
}
if (driver.OwnerID > 2)
{
row.DefaultCellStyle.ForeColor = BBColors.bbGreen1;
}
}
}
private ToolStripMenuItem CreateShowDriverLicense()
{
ToolStripMenuItem item = CreateItem("Водительское удостоверение");
item.Click += delegate
{
if (_dgvMain.GetID() == 0)
{
return;
}
DateTime date = DateTime.Today;
if (_mainStatus.Get() == Status.DTP)
{
DTPList dtpList = DTPList.getInstance();
DTP dtp = dtpList.getItem(_dgvMain.GetID());
date = dtp.Date;
}
Car car = _dgvMain.GetCar();
if (car == null)
{
return;
}
DriverCarList driverCarList = DriverCarList.getInstance();
Driver driver = driverCarList.GetDriver(car, date);
LicenseList licencesList = LicenseList.getInstance();
DriverLicense driverLicense = licencesList.getItem(driver);
if ((driverLicense != null) && (!string.IsNullOrEmpty(driverLicense.File)))
{
WorkWithFiles.openFile(driverLicense.File);
}
};
return(item);
}
/* Старое извещение
* 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)
{
var driverCarList = DriverCarList.getInstance();
driver = driverCarList.GetDriver(_car, date);
if (driver == null)
{
driver = driverCarList.GetDriver(_car);
var invoiceList = InvoiceList.getInstance();
var invoice = invoiceList.getItem(_car);
if (!string.IsNullOrEmpty(invoice?.DateMove))
{
DateTime.TryParse(invoice.DateMove, out DateTime 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);
var myDate = new MyDateTime(date.ToShortDateString());
_excelDoc.setValue(4, 39, driver.Id + "/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);
var 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);
var owners = Owners.getInstance();
var 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));
var licencesList = LicenseList.getInstance();
var 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
{
var suppyAddressList = SuppyAddressList.getInstance();
var suppyAddress = suppyAddressList.getItemByRegion(driver.Region.Id);
if (suppyAddress != null)
{
suppyAddressName = suppyAddress.ToString();
}
else
{
var passportList = PassportList.getInstance();
var passport = passportList.getLastPassport(driver);
suppyAddressName = passport.Address;
}
}
var suppyAddressName2 = string.Empty;
if (suppyAddressName.Length > 40)
{
for (var 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;
var employeesList = EmployeesList.getInstance();
var accountant = employeesList.getItem(driver.Region, "Бухгалтер Б.Браун");
if (driver.IsOne)
{
mechanicName = driver.GetName(NameType.Short);
}
else
{
var mechanic = employeesList.getItem(driver.Region, "Механик", true);
mechanicName = mechanic == null
? driver.GetName(NameType.Short)
: mechanic.Name;
}
var dispatcher = employeesList.getItem(driver.Region, "Диспечер-нарядчик");
var 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);
}
static void Main(string[] args)
{
DataBase.InitDataBase();
Provider.InitSQLProvider();
LogManager.Logger.Debug("Program started");
/* старые командировки */
//IExcelImporter importer = new BusinessTripFromExcelFile { FilePath = @"\\bbmru08\depts\Accounting\Командировки\Реестр_" + DateTime.Today.Year + ".xls" };
//BusinessTripFromExcelFile importer1 = new BusinessTripFromExcelFile { FilePath = @"\\bbmru08\1cv77\Autoexchange\Lotus\BBAuto" };
//importer1.StartImport();
//LogManager.Logger.Debug("BusinessTrip loading done");
///* Сделать загрузку вручную */
////importer = new MileageMonthFromExcelFile { FilePath = @"J:\Hospital Care\Kasyanova Tatyana\Отчёты\Командировки в BBAuto\Загрузка Перечень сотрудников для заполнения ПЛ на мес.xlsx" };
////importer.StartImport();
////LogManager.Logger.Debug("Mileage Month loading done");
IExcelImporter importer = new EmployeesFrom1C {
FilePath = @"\\bbmru08\1cv77\Autoexchange\Lotus\BBAuto"
};
importer.StartImport();
LogManager.Logger.Debug("EmployeesFrom1C loading done");
//importer = new TabelFrom1C { FilePath = @"\\bbmru08\1cv77\Autoexchange\Lotus\BBAuto\Time" };
//importer.StartImport();
//LogManager.Logger.Debug("TabelFrom1C loading done");
var medicalCertList = MedicalCertList.getInstance();
var medicalCertSender = new NotificationSender(medicalCertList);
//medicalCertSender.SendNotification();
//medicalCertSender.ClearStopIfNeed();
medicalCertSender.SendNotificationOverdue();
//medicalCertSender.SendNotificationNotExist();
//LogManager.Logger.Debug("MedicalCerts sent");
var licenseList = LicenseList.getInstance();
var licenceSender = new NotificationSender(licenseList);
//licenceSender.SendNotification();
licenceSender.SendNotificationOverdue();
licenceSender.SendNotificationNotExist();
LogManager.Logger.Debug("Licenses sent");
//var policySender = new PolicyListSender();
//policySender.SendNotification();
//LogManager.Logger.Debug("Policies sent");
//var diagCardSender = new DiagCardSender();
//diagCardSender.SendNotification();
//LogManager.Logger.Debug("DiagCards sent");
//var violationSender = new ViolationSender();
//violationSender.SendNotification();
//LogManager.Logger.Debug("Violations sent");
//var accountSender = new AccountSender();
//accountSender.SendNotification();
//LogManager.Logger.Debug("Accounts sent");
LogManager.Logger.Debug("Program finished");
}
