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