public IEnumerable <object> FillPersonalOnService(DataGridView dataGridView)
{
Dictionary <string, string> dic = new Dictionary <string, string>();
var res = (from el in entities.PersonalOnService
select new
{
el.personal_on_service_id,
el.ModelElement.ModelType.model_type_name,
el.ModelElement.other,
el.ModelElement.inventory_number,
el.sp_ServiceOperationType.service_operation_type_name,
// TODO: ДАТА СЕРВИСНОГО ОБСЛУЖИВАНИЯ (КОГДА, 1 ДЕНЬ)
// TODO: РЕЗУЛЬТАТ ОБСЛУЖИВАНИЯ
fio = el.PhysicalPeople.name + " " + el.PhysicalPeople.family + " " + el.PhysicalPeople.patronumic,
//el.sp_ServiceOperationPersonalRole.service_operation_personal_role_name,
el.PhysicalPeople.sp_OrganisationDepartment.organisation_department_name
}).ToList();
dic.Add("personal_on_service_id", "id записи");
dic.Add("model_type_name", "Тип модели");
dic.Add("inventory_number", "Инвентарный номер");
dic.Add("fio", "ФИО");
dic.Add("service_operation_type_name", "Тип операции");
dic.Add("service_operation_personal_role_name", "Роль эксплуатации");
dic.Add("other", "Наименование единицы оборудования");
dic.Add("organisation_department_name", "Наименование Организация");
//organisation_department_name
DataGridWorker.FillDataGrid(dataGridView, res, dic);
return(res);
}
public IEnumerable <object> FillPurchase(DataGridView dataGridView)
{
Dictionary <string, string> dic = new Dictionary <string, string>();
var res = (from el in entities.Purchase
select new
{
el.purchase_id,
el.sp_PurchaseType.purchase_type_name,
el.purchase_document_number,
el.date_apply,
el.ModelToPurchase.FirstOrDefault().ModelElement.ModelType.Organisations.organisation_short_name
}).ToList();
dic.Add("purchase_id", "id записи");
dic.Add("purchase_type_name", "Тип закупки");
dic.Add("purchase_document_number", "Номер договора");
dic.Add("date_apply", "Дата заключения договора");
dic.Add("organisation_short_name", "Название организации");
//organisation_short_name
DataGridWorker.FillDataGrid(dataGridView, res, dic);
return(res);
}
public IEnumerable <object> FillElementsDragMetal(DataGridView dataGridView)
{
Dictionary <string, string> dic = new Dictionary <string, string>();
var res = (from drags in entities.ElementsDragMetal
select new
{
drags.elements_drag_metal_id,
drags.ModelElement.ModelType.model_type_name,
drags.ModelElement.inventory_number,
drags.sp_DragMetal.drag_metal_name,
drags.size,
drags.ModelElement.other
}).ToList();
dic.Add("elements_drag_metal_id", "id записи");
dic.Add("model_type_name", "Тип модели"); //TODO: НАИМЕНОВАНИЕ ЕДИНИЦЫ
dic.Add("inventory_number", "Инвентарный номер");
dic.Add("drag_metal_name", "драгоценный металл");
dic.Add("size", "вес (гр.)");
dic.Add("other", "Наименование единицы оборудования");
DataGridWorker.FillDataGrid(dataGridView, res, dic);
return(res);
}
public IEnumerable <object> FillMOExpluatation(DataGridView dataGridView)
{
Dictionary <string, string> dic = new Dictionary <string, string>();
var res = (from mo_exxpluatation in entities.MOExpluatation
select new
{
mo_exxpluatation.mo_expluatation_id,
fio = mo_exxpluatation.PhysicalPeople.name + " " + mo_exxpluatation.PhysicalPeople.family,
mo_exxpluatation.sp_ServiceOperationPersonalRole.service_operation_personal_role_name,
mo_exxpluatation.ModelElement.other,
mo_exxpluatation.ModelElement.ModelType.model_type_name,
mo_exxpluatation.ModelElement.inventory_number,
mo_exxpluatation.date_begin,
mo_exxpluatation.date_end
}).ToList();
dic.Add("mo_expluatation_id", "id записи");
dic.Add("date_begin", "Дата начала работы");
dic.Add("date_end", "Дата конца работы");
dic.Add("fio", "ФИО");
dic.Add("service_operation_personal_role_name", "Роль Операции");
dic.Add("model_type_name", "Тип модели");
dic.Add("inventory_number", "Инвентарный номер");
dic.Add("other", "Наименование единицы оборудования");
DataGridWorker.FillDataGrid(dataGridView, res, dic);
return(res);
}
public IEnumerable <object> FillPhysicalPeoplePositions(DataGridView dataGridView)
{
Dictionary <string, string> dic = new Dictionary <string, string>();
var res = (from people_pos in entities.FaticalPhysicalPeoplePositions
select new
{
people_pos.people_position_id,
fio = people_pos.PhysicalPeople.family + " " + people_pos.PhysicalPeople.name + " " + people_pos.PhysicalPeople.patronumic,
people_pos.sp_PysicalPeoplePositions.physical_people_position_name,
people_pos.date_begin,
people_pos.date_end,
//people_pos.salary
}).ToList();
dic.Add("people_position_id", "id записи");
dic.Add("date_begin", "Дата начала работы");
dic.Add("date_end", "Дата конца работы");
dic.Add("salary", "Зарплата");
dic.Add("physical_people_position_name", "Название должности");
dic.Add("fio", "ФИО");
DataGridWorker.FillDataGrid(dataGridView, res, dic);
return(res);
}
public IEnumerable <object> FillPMMoves(DataGridView dataGridView)
{
Dictionary <string, string> dic = new Dictionary <string, string>();
var res = (from el in entities.ZIPPMMoves
where el.sp_ZIP_AND_PM_Element.isZIP != 1
select new
{
el.zipPM_move_id,
el.sp_ZIP_AND_PM_Element.zipPM_element_name,
el.date_move,
el.ModelElement.ModelType.model_type_name,
el.ModelElement.inventory_number,
el.ModelElement.other
}).ToList();
dic.Add("zipPM_on_stock_id", "id записи");
dic.Add("zipPM_element_name", "Название PM");
dic.Add("date_move", "Дата перемещения со склада");
dic.Add("model_type_name", "Тип модели");
dic.Add("other", "Наименование единицы оборудования");
dic.Add("inventory_number", "Инвентарный номер");
DataGridWorker.FillDataGrid(dataGridView, res, dic);
return(res);
}
public IEnumerable <object> FillModelElementByModelType(DataGridView dataGridView, int modelTypeId)
{
Dictionary <string, string> dic = new Dictionary <string, string>();
var res = (from model in entities.ModelElement
where model.model_type_id == modelTypeId
select new
{
model.model_element_id,
model.inventory_number,
model.ModelType.model_type_name,
model.date_creation,
model.date_utilisation,
model.serial_number,
model.sp_ReasonWriteOff.reason_write_off_name,
model.ModelToPurchase.Where(x => x.model_element_id == model.model_element_id)
.FirstOrDefault()
.Purchase
.purchase_document_number
}).ToList();
dic.Add("model_element_id", "id записи");
dic.Add("inventory_number", "Инвентарный номер");
dic.Add("model_type_name", "Тип модели");
dic.Add("date_creation", "Дата создания");
dic.Add("date_utilisation", "Дата утилизации");
dic.Add("serial_number", "Серийный номер");
dic.Add("reason_write_off_name", "Причина списания");
dic.Add("purchase_document_number", "Номер документа-поставки");
DataGridWorker.FillDataGrid(dataGridView, res, dic);
return(res);
}
public IEnumerable <object> FillPhysicalPeople(DataGridView dataGridView)
{
Dictionary <string, string> dic = new Dictionary <string, string>();
var res = (from people in entities.PhysicalPeople
select new
{
people.physical_people_id,
people.family,
people.name,
people.patronumic,
// gender = people.Gender.Value == 1 ? "муж" : "жен", // TODO: ДОлжности вместо пола
people.sp_OrganisationDepartment.organisation_department_name, // не отдел а организация
people.contacts,
}).ToList();
dic.Add("physical_people_id", "id записи");
dic.Add("name", "Имя");
dic.Add("family", "Фамилия");
dic.Add("patronumic", "Отчество");
dic.Add("gender", "Пол");
dic.Add("contacts", "Контакты");
dic.Add("organisation_department_name", "Подразделение");
DataGridWorker.FillDataGrid(dataGridView, res, dic);
return(res);
}
public IEnumerable <object> FillElementsPlaces(DataGridView dataGridView)
{
Dictionary <string, string> dic = new Dictionary <string, string>();
var res = (from el in entities.ElementsPlaces
select new
{
el.element_place_id,
el.sp_Corpus.corpus_name,
el.ModelElement.ModelType.model_type_name,
el.ModelElement.other,
el.ModelElement.inventory_number,
el.date_begin,
el.sp_MoveReason.move_reason_name
}).ToList();
dic.Add("standart_id", "id записи");
dic.Add("corpus_name", "Название отделения");
dic.Add("model_type_name", "Тип модели"); // TODO: НАЗВАНИЕ ЕДИНИЦЫ ОБОРУДОВАНИЯ
dic.Add("date_begin", "Дата перемещения");
dic.Add("move_reason_name", "Причина перемещения");
dic.Add("inventory_number", "Инвентарный номер");
dic.Add("other", "Наименование единицы оборудования");
DataGridWorker.FillDataGrid(dataGridView, res, dic);
return(res);
}
public IEnumerable <object> FillOrganisation(DataGridView dataGridView)
{
Dictionary <string, string> dic = new Dictionary <string, string>();
var res = (from organisation in entities.Organisations
select new
{
organisation_id = organisation.organisation_id,
organisation_type = organisation.sp_OrganisationType.organisation_type_name,
organisation_name = organisation.organisation_full_name,
organisation_short_name = organisation.organisation_short_name,
address = organisation.factic_address,
contact_information = organisation.contacts,
email = organisation.email
}).ToList();
dic.Add("organisation_id", "Идентификатор Организации");
dic.Add("organisation_name", "Название организации");
dic.Add("organisation_short_name", "ИНН");
dic.Add("organisation_type", "Тип организации");
dic.Add("contact_information", "Контакты");
dic.Add("email", "email");
dic.Add("address", "Адрес");
DataGridWorker.FillDataGrid(dataGridView, res, dic);
return(res);
}
public IEnumerable <object> FillPurchaseElement(DataGridView dataGridView)
{
Dictionary <string, string> dic = new Dictionary <string, string>();
var res = (from el in entities.PurchaseElements
select new
{
el.purchase_element_id,
el.ModelElement.ModelType.model_type_name,
el.count,
el.planned_date,
el.target_info,
isPurchasing = el.isPurchasing == 0 ? "Нет " : "Да"
}).ToList();
dic.Add("purchase_element_id", "id записи");
dic.Add("model_type_name", "Название типа модели");
dic.Add("count", "количество");
dic.Add("planned_date", "Дата поставки");
dic.Add("target_info", "Цель приобретения");
dic.Add("isPurchasing", "Уже куплено");
DataGridWorker.FillDataGrid(dataGridView, res, dic);
return(res);
}
public IEnumerable <object> Fillsp_ServiceOperationPersonalRole(DataGridView dataGridView)
{
Dictionary <string, string> dic = new Dictionary <string, string>();
var res = (from el in entities.sp_ServiceOperationPersonalRole
select new
{
el.service_operation_personal_role_id,
el.service_operation_personal_role_name
}).ToList();
dic.Add("service_operation_personal_role_id", "id записи");
dic.Add("service_operation_personal_role_name", "Вид операции при сервисном обслуживании");
DataGridWorker.FillDataGrid(dataGridView, res, dic);
return(res);
}
public IEnumerable <object> Fillsp_ServiceType(DataGridView dataGridView)
{
Dictionary <string, string> dic = new Dictionary <string, string>();
var res = (from el in entities.sp_ServiceType
select new
{
el.service_type_id,
el.service_type_name
}).ToList();
dic.Add("service_type_id", "id записи");
dic.Add("service_type_name", "Вид сервисного обслуживания");
DataGridWorker.FillDataGrid(dataGridView, res, dic);
return(res);
}
public IEnumerable <object> Fillsp_DragMetal(DataGridView dataGridView)
{
Dictionary <string, string> dic = new Dictionary <string, string>();
var res = (from el in entities.sp_DragMetal
select new
{
el.drag_metal_id,
el.drag_metal_name
}).ToList();
dic.Add("drag_metal_id", "id записи");
dic.Add("drag_metal_name", "Вид драгоценного металла");
DataGridWorker.FillDataGrid(dataGridView, res, dic);
return(res);
}
public IEnumerable <object> Fillsp_MoveReason(DataGridView dataGridView)
{
Dictionary <string, string> dic = new Dictionary <string, string>();
var res = (from el in entities.sp_MoveReason
select new
{
el.move_reason_id,
el.move_reason_name
}).ToList();
dic.Add("move_reason_id", "id записи");
dic.Add("move_reason_name", "Причина перемещения");
DataGridWorker.FillDataGrid(dataGridView, res, dic);
return(res);
}
public IEnumerable <object> Fillsp_Corpus(DataGridView dataGridView)
{
Dictionary <string, string> dic = new Dictionary <string, string>();
var res = (from el in entities.sp_Corpus
select new
{
el.corpus_id,
el.corpus_name
}).ToList();
dic.Add("organisation_department_id", "id записи");
dic.Add("corpus_name", "Название корпуса");
DataGridWorker.FillDataGrid(dataGridView, res, dic);
return(res);
}
public IEnumerable <object> Fillsp_BrokenRequestReason(DataGridView dataGridView)
{
Dictionary <string, string> dic = new Dictionary <string, string>();
var res = (from el in entities.sp_BrokenRequestReason
select new
{
el.broken_request_reason_id,
el.broken_request_reason_name,
}).ToList();
dic.Add("broken_request_reason_id", "id записи");
dic.Add("broken_request_reason_name", "Причина подачи заявки на ремонт");
DataGridWorker.FillDataGrid(dataGridView, res, dic);
return(res);
}
public IEnumerable <object> Fillsp_ExpluatationRole(DataGridView dataGridView)
{
Dictionary <string, string> dic = new Dictionary <string, string>();
var res = (from el in entities.sp_ExpluatationRole
select new
{
el.expluatation_role_id,
el.expluatation_role_name
}).ToList();
dic.Add("expluatation_role_id", "id записи");
dic.Add("expluatation_role_name", "Роль в отношении эксплуатации");
DataGridWorker.FillDataGrid(dataGridView, res, dic);
return(res);
}
public IEnumerable <object> Fillsp_PurchaseType(DataGridView dataGridView)
{
Dictionary <string, string> dic = new Dictionary <string, string>();
var res = (from el in entities.sp_PurchaseType
select new
{
el.purchase_type_id,
el.purchase_type_name
}).ToList();
dic.Add("purchase_type_id", "id записи");
dic.Add("purchase_type_name", "Вид закупки");
DataGridWorker.FillDataGrid(dataGridView, res, dic);
return(res);
}
public IEnumerable <object> Fillsp_OrganisationDepartment(DataGridView dataGridView)
{
Dictionary <string, string> dic = new Dictionary <string, string>();
var res = (from el in entities.sp_OrganisationDepartment
select new
{
el.organisation_department_id,
el.organisation_department_name
}).ToList();
dic.Add("organisation_department_id", "id записи");
dic.Add("organisation_department_name", "Подразделение организации");
DataGridWorker.FillDataGrid(dataGridView, res, dic);
return(res);
}
public IEnumerable <object> Fillsp_ReasonWriteoff(DataGridView dataGridView)
{
Dictionary <string, string> dic = new Dictionary <string, string>();
var res = (from el in entities.sp_ReasonWriteOff
select new
{
el.reason_write_off_id,
el.reason_write_off_name
}).ToList();
dic.Add("reason_write_off_id", "id записи");
dic.Add("reason_write_off_name", "Причина списания оборудования");
DataGridWorker.FillDataGrid(dataGridView, res, dic);
return(res);
}
public IEnumerable <object> Fillsp_FunctionalyUseModel(DataGridView dataGridView)
{
Dictionary <string, string> dic = new Dictionary <string, string>();
var res = (from el in entities.sp_FunctionalyUseModel
select new
{
el.functionaly_use_model_id,
el.functionaly_use_model_name
}).ToList();
dic.Add("functionaly_use_model_id", "id записи");
dic.Add("functionaly_use_model_name", "Название функционального назначения модели");
DataGridWorker.FillDataGrid(dataGridView, res, dic);
return(res);
}
public IEnumerable <object> Fillsp_Country(DataGridView dataGridView)
{
Dictionary <string, string> dic = new Dictionary <string, string>();
var res = (from el in entities.sp_CountryKey
select new
{
el.country_key_id,
el.country_name
}).ToList();
dic.Add("country_key_id", "id записи");
dic.Add("country_name", "Название страны");
DataGridWorker.FillDataGrid(dataGridView, res, dic);
return(res);
}
public IEnumerable <object> Fillsp_OrganisationType(DataGridView dataGridView)
{
Dictionary <string, string> dic = new Dictionary <string, string>();
var res = (from org in entities.sp_OrganisationType
select new
{
org.organisation_type_id,
org.organisation_type_name
}).ToList();
dic.Add("organisation_type_id", "id записи");
dic.Add("organisation_type_name", "Тип организации по виду деятельности");
DataGridWorker.FillDataGrid(dataGridView, res, dic);
return(res);
}
public IEnumerable <object> Fillsp_PM(DataGridView dataGridView)
{
Dictionary <string, string> dic = new Dictionary <string, string>();
var res = (from el in entities.sp_ZIP_AND_PM_Element
where el.isZIP != 1
select new
{
el.zipPM_element_id,
el.zipPM_element_name,
}).ToList();
dic.Add("zipPM_element_id", "id записи");
dic.Add("zipPM_element_name", "Название PM");
DataGridWorker.FillDataGrid(dataGridView, res, dic);
return(res);
}
public IEnumerable <object> Fillsp_PhysicalPeoplePositions(DataGridView dataGridView)
{
Dictionary <string, string> dic = new Dictionary <string, string>();
var res = (from el in entities.sp_PysicalPeoplePositions
select new
{
el.physical_people_position_id,
el.physical_people_position_name
}).ToList();
dic.Add("physical_people_position_id", "id записи");
dic.Add("physical_people_position_name", "Фактические должности физических лиц");
DataGridWorker.FillDataGrid(dataGridView, res, dic);
return(res);
}
public IEnumerable <object> FillModelElement(DataGridView dataGridView)
{
Dictionary <string, string> dic = new Dictionary <string, string>();
var res = (from model in entities.ModelElement
select new
{
model.model_element_id,
model.ModelType.model_type_name,
model.other,
model.inventory_number,
model.date_creation,
model.ModelType.Organisations.sp_CountryKey.country_name,
model.serial_number,
model.ModelToPurchase.Where(x => x.model_element_id == model.model_element_id)
.FirstOrDefault()
.Purchase
.date_apply,
model.date_utilisation,
model.sp_ReasonWriteOff.reason_write_off_name,
// TODO: сверху списание , тут нужна утилизаиця
}).ToList();
dic.Add("model_element_id", "id записи");
dic.Add("inventory_number", "Инвентарный номер");
dic.Add("model_type_name", "Тип модели");
dic.Add("date_creation", "Дата производства");
dic.Add("date_utilisation", "Дата списания");
dic.Add("serial_number", "Серийный номер");
dic.Add("reason_write_off_name", "Причина списания");
dic.Add("purchase_document_number", "Номер документа-поставки");
dic.Add("date_apply", "Дата ввода в эксплуатацию");
dic.Add("country_name", "Cтрана производитель");
dic.Add("other", "Наименование единицы оборудования");
//date_apply
DataGridWorker.FillDataGrid(dataGridView, res, dic);
return(res);
}
public IEnumerable <object> FillModelTypes(DataGridView dataGridView)
{
Dictionary <string, string> dic = new Dictionary <string, string>();
var res = (from modelType in entities.ModelType
select new
{
model_type_id = modelType.model_type_id,
model_type_name = modelType.model_type_name,
functionaly_use_model = modelType.sp_FunctionalyUseModel.functionaly_use_model_name,
//expluatation_role = modelType.sp_ExpluatationRole.expluatation_role_name,
}).ToList();
dic.Add("model_type_id", "id записи");
dic.Add("model_type_name", "Название модели");
dic.Add("functionaly_use_model", "Функциональное назначение модели");
//dic.Add("expluatation_role", "Роль эксплуатации");
DataGridWorker.FillDataGrid(dataGridView, res, dic);
return(res);
}
public IEnumerable <object> FillBrokenRequest(DataGridView dataGridView)
{
Dictionary <string, string> dic = new Dictionary <string, string>();
var res = (from el in entities.BrokenRequest
select new
{
el.broken_request_id,
el.ModelElement.ElementsPlaces.FirstOrDefault().sp_Corpus.corpus_name,
fio = el.PhysicalPeople.name + " " + el.PhysicalPeople.family + " " + el.PhysicalPeople.patronumic,
el.ModelElement.ModelType.model_type_name,
el.ModelElement.other,
el.ModelElement.inventory_number,
el.date_to_repair,
el.sp_BrokenRequestReason.broken_request_reason_name,
isFinished = el.isFinished == 0 ? "Нет" : "Да"
// TODO: Дата выполнения
// TODO: Примечание
}).ToList();
dic.Add("broken_request_id", "id записи");
dic.Add("broken_request_reason_name", "описание проблемы");
dic.Add("fio", "ФИО");
dic.Add("model_type_name", "Название типа модели"); //here
dic.Add("inventory_number", "Инвентарный номер");
dic.Add("date_to_repair", "Дата подачи");
dic.Add("isFinished", "Неполадка устранена?");
dic.Add("corpus_name", "Наименование отделения");
dic.Add("other", "Наименование единицы оборудования");
DataGridWorker.FillDataGrid(dataGridView, res, dic);
return(res);
}
//Fillsp_Standarts
public IEnumerable <object> Fillsp_Standarts(DataGridView dataGridView)
{
Dictionary <string, string> dic = new Dictionary <string, string>();
var res = (from el in entities.sp_Standarts
select new
{
el.standart_id,
el.sp_Corpus.corpus_name,
el.ModelType.model_type_name,
el.count
}).ToList();
dic.Add("standart_id", "id записи");
dic.Add("corpus_name", "Название отделения");
dic.Add("model_type_name", "Тип модели");
dic.Add("count", "Количество по стандарту");
DataGridWorker.FillDataGrid(dataGridView, res, dic);
return(res);
}
