private void MainForm_Load(object sender, EventArgs e) { UserDomain user = null; if (LicenseSoftwareSettings.UseLdap) { user = UserDomain.Current; } if (user == null) { toolStripLabelHelloUser.Text = ""; } else { toolStripLabelHelloUser.Text = @"Здравствуйте, " + user.DisplayName; } //Загружаем права пользователя AccessControl.LoadPriveleges(); if (AccessControl.HasNoPriveleges()) { MessageBox.Show(@"У вас нет прав на использование данного приложения", @"Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1); Application.Exit(); return; } //Инициируем начальные параметры CallbackUpdater DataModelsCallbackUpdater.GetInstance().Initialize(); //Загружаем данные в асинхронном режиме PreLoadData(); //Обновляем состояние главного меню MainMenuStateUpdate(); if (string.IsNullOrEmpty(_computerNameCommandLineArg)) { return; } var device = DataModelHelper.FilterRows(DevicesDataModel.GetInstance().Select()) .FirstOrDefault(r => r.Field <string>("Device Name").Contains(_computerNameCommandLineArg)); if (device == null) { return; } var viewport = ViewportFactory.CreateViewport(this, ViewportType.InstallationsViewport); viewport.DynamicFilter = string.Format("[ID Computer] = {0}", device.Field <int>("ID Device")); if (((IMenuController)viewport).CanLoadData()) { ((IMenuController)viewport).LoadData(); } AddViewport(viewport); ChangeMainMenuState(); StatusBarStateUpdate(); ChangeViewportsSelectProprty(); }
protected override void Calculate(object sender, System.ComponentModel.DoWorkEventArgs e) { DmLoadState = DataModelLoadState.Loading; if (e == null) { throw new DataModelException("Не передана ссылка на объект DoWorkEventArgs в классе CalcDataModelLicensesConcat"); } var config = (CalcAsyncConfig)e.Argument; // Фильтруем удаленные строки var licenses = DataModelHelper.FilterRows(SoftLicensesDataModel.GetInstance().Select(), config.Entity, config.IdObject); var licKeys = DataModelHelper.FilterRows(SoftLicKeysDataModel.GetInstance().Select(), config.Entity, config.IdObject); // Вычисляем агрегационную информацию var result = from licensesRow in licenses join licKeyRow in licKeys on licensesRow.Field <int>("ID License") equals licKeyRow.Field <int>("ID License") select new { id_lickey = licKeyRow.Field <int>("ID LicenseKey"), id_license = licensesRow.Field <int>("ID License"), lickey = string.Format("{0} (в/н лицензии: {1}; срок действия: №{2} от {3})", licKeyRow.Field <string>("LicKey"), licensesRow.Field <int>("ID License"), licensesRow.Field <string>("DocNumber") ?? "б/н", licensesRow.Field <DateTime>("BuyLicenseDate").ToString("dd.MM.yyyy", CultureInfo.InvariantCulture) + (licensesRow.Field <DateTime?>("ExpireLicenseDate") == null ? " (бессрочно)" : " по " + licensesRow.Field <DateTime>("ExpireLicenseDate").ToString("dd.MM.yyyy", CultureInfo.InvariantCulture)) ) }; // Заполняем таблицу изменений var table = InitializeTable(); table.BeginLoadData(); result.ToList().ForEach(x => { table.Rows.Add(x.id_lickey, x.id_license, x.lickey); }); table.EndLoadData(); if (!DataSetManager.DataSet.Tables.Contains(TableName)) { DataSetManager.AddTable(table); } else { DataSetManager.DataSet.Merge(table); } // Возвращаем результат e.Result = table; }
internal override string GetFilter() { var filter = ""; List <int> includedSoftwareIds = null; if (checkBoxLicTypeEnable.Checked && (comboBoxLicType.SelectedValue != null)) { if (!string.IsNullOrEmpty(filter.Trim())) { filter += " AND "; } filter += string.Format(CultureInfo.InvariantCulture, "[ID LicType] = '{0}'", comboBoxLicType.SelectedValue); } if (checkBoxLicDocTypeEnable.Checked && (comboBoxLicDocType.SelectedValue != null)) { if (!string.IsNullOrEmpty(filter.Trim())) { filter += " AND "; } filter += string.Format(CultureInfo.InvariantCulture, "[ID DocType] = '{0}'", comboBoxLicDocType.SelectedValue); } if (checkBoxSupplierEnable.Checked && (comboBoxSupplierID.SelectedValue != null)) { if (!string.IsNullOrEmpty(filter.Trim())) { filter += " AND "; } filter += string.Format(CultureInfo.InvariantCulture, "[ID Supplier] = '{0}'", comboBoxSupplierID.SelectedValue); } if (checkBoxDepartmentEnable.Checked && (comboBoxDepartmentID.SelectedValue != null)) { if (!string.IsNullOrEmpty(filter.Trim())) { filter += " AND "; } var selectedDepartments = DataModelHelper.GetDepartmentSubunits((int)comboBoxDepartmentID.SelectedValue). Union(new List <int> { (int)comboBoxDepartmentID.SelectedValue }); var accessibleDepartments = from departmentsRow in DataModelHelper. FilterRows(DepartmentsDataModel.GetInstance().SelectVisibleDepartments()) where departmentsRow.Field <bool>("AllowSelect") select departmentsRow.Field <int>("ID Department"); var departments = selectedDepartments.Intersect(accessibleDepartments).ToList(); if (!departments.Any()) { throw new ViewportException("Вы не состоите ни в одном из департаментов."); } filter += "[ID Department] IN ("; foreach (var id in departments) { filter += id.ToString(CultureInfo.InvariantCulture) + ","; } filter = filter.TrimEnd(',') + ")"; } else { if (!string.IsNullOrEmpty(filter.Trim())) { filter += " AND "; } var accessibleDepartments = (from departmentsRow in DataModelHelper.FilterRows(DepartmentsDataModel.GetInstance().SelectVisibleDepartments()) where departmentsRow.Field <bool>("AllowSelect") select departmentsRow.Field <int>("ID Department")).ToList(); if (!accessibleDepartments.Any()) { throw new ViewportException("Вы не состоите ни в одном из департаментов."); } filter += "[ID Department] IN ("; foreach (var id in accessibleDepartments) { filter += id.ToString(CultureInfo.InvariantCulture) + ","; } filter = filter.TrimEnd(',') + ")"; } if (checkBoxDocNumberEnable.Checked) { if (!string.IsNullOrEmpty(filter.Trim())) { filter += " AND "; } filter += string.Format(CultureInfo.InvariantCulture, "DocNumber LIKE'%{0}%'", textBoxDocNumber.Text.Trim().Replace("'", "")); } if (checkBoxSoftwareNameEnable.Checked && (comboBoxSoftwareName.SelectedValue != null)) { if (!string.IsNullOrEmpty(filter.Trim())) { filter += " AND "; } filter += string.Format(CultureInfo.InvariantCulture, "[ID Version] = '{0}'", comboBoxSoftwareName.SelectedValue); } if (checkBoxBuyLicenseDateEnable.Checked) { if (!string.IsNullOrEmpty(filter.Trim())) { filter += " AND "; } filter += string.Format(CultureInfo.InvariantCulture, "BuyLicenseDate {0} #{1}#", ConvertDisplayEqExprToSql( comboBoxOpBuyLicenseDate.SelectedItem.ToString()), dateTimePickerBuyLicenseDate.Value.ToString("yyyy-MM-dd", CultureInfo.InvariantCulture)); } if (checkBoxExpireLicenseDateEnable.Checked) { if (!string.IsNullOrEmpty(filter.Trim())) { filter += " AND "; } filter += string.Format(CultureInfo.InvariantCulture, "ExpireLicenseDate {0} #{1}#", ConvertDisplayEqExprToSql( comboBoxOpExpireLicenseDate.SelectedItem.ToString()), dateTimePickerExpireLicenseDate.Value.ToString("yyyy-MM-dd", CultureInfo.InvariantCulture)); } if (checkBoxSoftwareMakerEnable.Checked && (comboBoxSoftwareMaker.SelectedValue != null)) { var ids = DataModelHelper.GetSoftwareIDsBySoftMaker((int)comboBoxSoftwareMaker.SelectedValue); includedSoftwareIds = DataModelHelper.Intersect(null, ids).ToList(); } if (checkBoxSoftwareTypeEnable.Checked && (comboBoxSoftwareType.SelectedValue != null)) { var ids = DataModelHelper.GetSoftwareIDsBySoftType((int)comboBoxSoftwareType.SelectedValue); includedSoftwareIds = DataModelHelper.Intersect(includedSoftwareIds, ids).ToList(); } if (checkBoxLicKeyEnable.Checked && (comboBoxLicKey.SelectedValue != null)) { if (!string.IsNullOrEmpty(filter.Trim())) { filter += " AND "; } filter += string.Format(CultureInfo.InvariantCulture, "[ID License] = '{0}'", comboBoxLicKey.SelectedValue); } if (checkBoxOnlyAvailableInstallations.Checked) { var installationsCount = from installRow in DataModelHelper.FilterRows(SoftInstallationsDataModel.GetInstance().Select()) group installRow by installRow.Field <int>("ID License") into gs select new { idLicense = gs.Key, istallationsCount = gs.Count() }; var notAvailableLicenses = (from licensesRow in DataModelHelper.FilterRows(SoftLicensesDataModel.GetInstance().Select()) join installRow in installationsCount on licensesRow.Field <int>("ID License") equals installRow.idLicense where licensesRow.Field <int?>("InstallationsCount") != null && (licensesRow.Field <int>("InstallationsCount") - installRow.istallationsCount <= 0) select licensesRow.Field <int>("ID License")).ToList(); if (notAvailableLicenses.Any()) { if (!string.IsNullOrEmpty(filter.Trim())) { filter += " AND "; } filter += "[ID License] NOT IN (0"; foreach (var id in notAvailableLicenses) { filter += id.ToString(CultureInfo.InvariantCulture) + ","; } filter = filter.TrimEnd(',') + ")"; } } if (includedSoftwareIds == null || !includedSoftwareIds.Any()) { return(filter); } if (!string.IsNullOrEmpty(filter.Trim())) { filter += " AND "; } filter += "[ID Version] IN (0"; foreach (var id in includedSoftwareIds) { filter += id.ToString(CultureInfo.InvariantCulture) + ","; } filter = filter.TrimEnd(',') + ")"; return(filter); }
internal override string GetFilter() { var filter = ""; IEnumerable <int> includedLicensesIds = null; if (checkBoxSoftwareNameEnable.Checked && (comboBoxSoftwareName.SelectedValue != null)) { var ids = DataModelHelper.GetLicenseIDsByCondition( row => row.Field <int>("ID Version") == (int)comboBoxSoftwareName.SelectedValue, Entities.EntityType.SoftVersion); includedLicensesIds = DataModelHelper.Intersect(null, ids); } if (checkBoxSoftwareMakerEnable.Checked && (comboBoxSoftwareMaker.SelectedValue != null)) { var ids = DataModelHelper.GetLicenseIDsByCondition( row => row.Field <int>("ID SoftMaker") == (int)comboBoxSoftwareMaker.SelectedValue, Entities.EntityType.Software); includedLicensesIds = DataModelHelper.Intersect(includedLicensesIds, ids); } if (checkBoxSoftwareTypeEnable.Checked && (comboBoxSoftwareType.SelectedValue != null)) { var ids = DataModelHelper.GetLicenseIDsByCondition( row => row.Field <int>("ID SoftType") == (int)comboBoxSoftwareType.SelectedValue, Entities.EntityType.Software); includedLicensesIds = DataModelHelper.Intersect(includedLicensesIds, ids); } if (checkBoxSupplierEnable.Checked && (comboBoxSupplierID.SelectedValue != null)) { var ids = DataModelHelper.GetLicenseIDsByCondition( row => row.Field <int>("ID Supplier") == (int)comboBoxSupplierID.SelectedValue, Entities.EntityType.License); includedLicensesIds = DataModelHelper.Intersect(includedLicensesIds, ids); } if (checkBoxLicTypeEnable.Checked && (comboBoxLicType.SelectedValue != null)) { var ids = DataModelHelper.GetLicenseIDsByCondition( row => row.Field <int>("ID LicType") == (int)comboBoxLicType.SelectedValue, Entities.EntityType.License); includedLicensesIds = DataModelHelper.Intersect(includedLicensesIds, ids); } if (checkBoxLicDocTypeEnable.Checked && (comboBoxLicDocType.SelectedValue != null)) { var ids = DataModelHelper.GetLicenseIDsByCondition( row => row.Field <int>("ID DocType") == (int)comboBoxLicDocType.SelectedValue, Entities.EntityType.License); includedLicensesIds = DataModelHelper.Intersect(includedLicensesIds, ids); } if (checkBoxDepartmentLicEnable.Checked && (comboBoxDepartmentLicID.SelectedValue != null)) { var ids = DataModelHelper.GetLicenseIDsByCondition( row => DataModelHelper.GetDepartmentSubunits((int)comboBoxDepartmentLicID.SelectedValue).Union( new List <int> { (int)comboBoxDepartmentLicID.SelectedValue }).Contains( row.Field <int>("ID Department")), Entities.EntityType.License); includedLicensesIds = DataModelHelper.Intersect(includedLicensesIds, ids); } if (checkBoxDocNumberEnable.Checked && !string.IsNullOrEmpty(textBoxDocNumber.Text.Trim())) { var ids = DataModelHelper.GetLicenseIDsByCondition( row => row.Field <string>("DocNumber").ToUpper(CultureInfo.InvariantCulture) .Contains(textBoxDocNumber.Text.Trim().ToUpper(CultureInfo.InvariantCulture)), Entities.EntityType.License); includedLicensesIds = DataModelHelper.Intersect(includedLicensesIds, ids); } if (checkBoxExpireLicenseDateEnable.Checked) { var ids = DataModelHelper.GetLicenseIDsByCondition( row => { if (row.Field <DateTime?>("ExpireLicenseDate") == null) { return(false); } switch (comboBoxOpExpireLicenseDate.SelectedItem.ToString()) { case "=": return(row.Field <DateTime>("ExpireLicenseDate") == dateTimePickerExpireLicenseDate.Value); case "≥": return(row.Field <DateTime>("ExpireLicenseDate") >= dateTimePickerExpireLicenseDate.Value); case "≤": return(row.Field <DateTime>("ExpireLicenseDate") <= dateTimePickerExpireLicenseDate.Value); } return(false); }, Entities.EntityType.License); includedLicensesIds = DataModelHelper.Intersect(includedLicensesIds, ids); } if (checkBoxBuyLicenseDateEnable.Checked) { var ids = DataModelHelper.GetLicenseIDsByCondition( row => { if (row.Field <DateTime?>("BuyLicenseDate") == null) { return(false); } switch (comboBoxOpBuyLicenseDate.SelectedItem.ToString()) { case "=": return(row.Field <DateTime>("BuyLicenseDate") == dateTimePickerBuyLicenseDate.Value); case "≥": return(row.Field <DateTime>("BuyLicenseDate") >= dateTimePickerBuyLicenseDate.Value); case "≤": return(row.Field <DateTime>("BuyLicenseDate") <= dateTimePickerBuyLicenseDate.Value); } return(false); }, Entities.EntityType.License); includedLicensesIds = DataModelHelper.Intersect(includedLicensesIds, ids); } var allowedDepartments = from departmentsRow in DataModelHelper.FilterRows(DepartmentsDataModel.GetInstance().SelectVisibleDepartments()) where departmentsRow.Field <bool>("AllowSelect") select departmentsRow.Field <int>("ID Department"); var allowedComputers = from devicesRow in DataModelHelper.FilterRows(DevicesDataModel.GetInstance().Select()) join depRow in allowedDepartments on devicesRow.Field <int>("ID Department") equals depRow select devicesRow.Field <int>("ID Device"); if (!string.IsNullOrEmpty(filter.Trim())) { filter += " AND "; } filter += "[ID Computer] IN (0"; foreach (var id in allowedComputers) { filter += id.ToString(CultureInfo.InvariantCulture) + ","; } filter = filter.TrimEnd(',') + ")"; if (checkBoxInstallDateEnable.Checked) { if (!string.IsNullOrEmpty(filter.Trim())) { filter += " AND "; } filter += string.Format(CultureInfo.InvariantCulture, "InstallationDate {0} #{1}#", ConvertDisplayEqExprToSql( comboBoxOpInstallDate.SelectedItem.ToString()), dateTimePickerInstallDate.Value.ToString("yyyy-MM-dd", CultureInfo.InvariantCulture)); } if (checkBoxInstallatorEnable.Checked && (comboBoxInstallator.SelectedValue != null)) { if (!string.IsNullOrEmpty(filter.Trim())) { filter += " AND "; } filter += string.Format(CultureInfo.InvariantCulture, "[ID Installator] = '{0}'", comboBoxInstallator.SelectedValue); } if (checkBoxLicKeyEnable.Checked && (comboBoxLicKey.SelectedValue != null)) { if (!string.IsNullOrEmpty(filter.Trim())) { filter += " AND "; } filter += string.Format(CultureInfo.InvariantCulture, "[ID LicenseKey] = '{0}'", comboBoxLicKey.SelectedValue); } if (checkBoxComputerEnable.Checked && (comboBoxComputer.SelectedValue != null)) { if (!string.IsNullOrEmpty(filter.Trim())) { filter += " AND "; } filter += string.Format(CultureInfo.InvariantCulture, "[ID Computer] = '{0}'", comboBoxComputer.SelectedValue); } if (checkBoxInvNumEnable.Checked && (comboBoxInvNum.SelectedValue != null)) { if (!string.IsNullOrEmpty(filter.Trim())) { filter += " AND "; } filter += string.Format(CultureInfo.InvariantCulture, "[ID Computer] = '{0}'", comboBoxInvNum.SelectedValue); } if (checkBoxSerialNumEnable.Checked && (comboBoxSerialNum.SelectedValue != null)) { if (!string.IsNullOrEmpty(filter.Trim())) { filter += " AND "; } filter += string.Format(CultureInfo.InvariantCulture, "[ID Computer] = '{0}'", comboBoxSerialNum.SelectedValue); } if (checkBoxDepartmentInstallEnable.Checked && (comboBoxDepartmentInstallID.SelectedValue != null)) { var computerIds = DataModelHelper.GetComputerIDsByDepartment((int)comboBoxDepartmentInstallID.SelectedValue); if (!string.IsNullOrEmpty(filter.Trim())) { filter += " AND "; } filter += "[ID Computer] IN (0"; foreach (var id in computerIds) { filter += id.ToString(CultureInfo.InvariantCulture) + ","; } filter = filter.TrimEnd(',') + ")"; } if (includedLicensesIds != null) { if (!string.IsNullOrEmpty(filter.Trim())) { filter += " AND "; } filter += "[ID License] IN (0"; foreach (var id in includedLicensesIds) { filter += id.ToString(CultureInfo.InvariantCulture) + ","; } filter = filter.TrimEnd(',') + ")"; } return(filter); }
protected override void Calculate(object sender, System.ComponentModel.DoWorkEventArgs e) { DmLoadState = DataModelLoadState.Loading; if (e == null) { throw new DataModelException("Не передана ссылка на объект DoWorkEventArgs в классе CalcDataModelSoftwareConcat"); } var config = (CalcAsyncConfig)e.Argument; // Фильтруем удаленные строки IEnumerable <DataRow> software; IEnumerable <DataRow> versions; if (config.Entity == EntityType.Software) { software = DataModelHelper.FilterRows(SoftwareDataModel.GetInstance().Select(), config.Entity, config.IdObject); versions = DataModelHelper.FilterRows(SoftVersionsDataModel.GetInstance().Select(), config.Entity, config.IdObject); } else if (config.Entity == EntityType.SoftVersion) { software = DataModelHelper.FilterRows(SoftwareDataModel.GetInstance().Select(), EntityType.Unknown, null); versions = DataModelHelper.FilterRows(SoftVersionsDataModel.GetInstance().Select(), config.Entity, config.IdObject); } else { software = DataModelHelper.FilterRows(SoftwareDataModel.GetInstance().Select(), EntityType.Unknown, null); versions = DataModelHelper.FilterRows(SoftVersionsDataModel.GetInstance().Select(), EntityType.Unknown, null); } // Вычисляем агрегационную информацию var result = from softwareRow in software join versionRow in versions on softwareRow.Field <int>("ID Software") equals versionRow.Field <int>("ID Software") select new { id_version = versionRow.Field <int>("ID Version"), id_software = versionRow.Field <int>("ID Software"), software = softwareRow.Field <string>("Software") + (versionRow.Field <string>("Version") == null ? "" : " " + versionRow.Field <string>("Version")) }; // Заполняем таблицу изменений var table = InitializeTable(); table.BeginLoadData(); result.ToList().ForEach(x => { table.Rows.Add(x.id_version, x.id_software, x.software); }); table.EndLoadData(); if (!DataSetManager.DataSet.Tables.Contains(TableName)) { DataSetManager.AddTable(table); } else { DataSetManager.DataSet.Merge(table); } // Возвращаем результат e.Result = table; }