private void toolStripButtonDelete_Click(object sender, EventArgs e) { if (MessageBox.Show(@"Вы уверены, что хотите удалить запись", @"Внимание", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes) { var db = new DevicesDatabase(); if (((NodeProperty)treeViewComputers.SelectedNode.Tag).NodeType == NodeTypeEnum.DepartmentNode) { if (db.DeleteDepartment(((NodeProperty)treeViewComputers.SelectedNode.Tag).NodeId)) { treeViewComputers.SelectedNode.Remove(); } } else { if (db.DeleteDevice(((NodeProperty)treeViewComputers.SelectedNode.Tag).NodeId)) { var tmpNode = treeViewComputers.SelectedNode.Parent; if (tmpNode.Nodes.Count == 1) { while (tmpNode != null) { tmpNode.ForeColor = Color.Black; tmpNode = tmpNode.Parent; } } treeViewComputers.SelectedNode.Remove(); } } db.Dispose(); } }
private void buttonSave_Click(object sender, EventArgs e) { var db = new DevicesDatabase(); switch (ParamType) { case "text": Value = textBoxParam.Text; break; case "combobox": Value = comboBoxParam.Text; break; case "int": Value = numericUpDownParam.Value; break; case "float": Value = numericUpDownParam.Value; break; } if (NodeRealId == -1) { db.InsertDeviceNodeValue(AssocMetaNodeId, ParentNodeId, DeviceId, Value.ToString()); } else { db.UpdateDeviceNodeValue(NodeRealId, Value.ToString()); } db.Dispose(); IsChanged = true; Close(); }
internal void InitializeForm(DevicesDatabase db) { var dv = db.GetRequests(SerialNumber, InventoryNumber); if (dv.Table == null) { return; } dataGridView1.AutoGenerateColumns = false; dataGridView1.DataSource = dv; NumRequestColumn.DataPropertyName = "num"; ExecutorColumn.DataPropertyName = "Sotr"; FixDateColumn.DataPropertyName = "D_Rem"; HoursDurColumn.DataPropertyName = "hh"; MinutesDurColumn.DataPropertyName = "mm"; JobTypeColumn.DataPropertyName = "j_name"; ActColumn.DataPropertyName = "act"; StikerColumn.DataPropertyName = "Stiker"; textBoxFault.DataBindings.Add("Text", dv, "Fault"); textBoxRecom.DataBindings.Add("Text", dv, "Recom"); textBoxActionRem.DataBindings.Add("Text", dv, "Action_Rem"); textBoxDescription.DataBindings.Add("Text", dv, "Prim"); dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells; toolStripStatusLabel1.Text = @"Всего заявок: " + dataGridView1.RowCount; }
private void SearchFormSt1_Load(object sender, EventArgs e) { CancelSearch = true; //Загрузка департаментов в дерево treeViewDepartments.Nodes.Clear(); Db = new DevicesDatabase(); SpgNew = new SearchParametersGroup(); var list = Db.GetDepartments(SpgNew); foreach (var department in list) { var node = new TreeNode { Text = department.NodeName, Tag = new NodeProperty(department.NodeId, NodeTypeEnum.DepartmentNode) }; TreeNodesHelper.AddNode(node, treeViewDepartments.Nodes, treeViewDepartments.Nodes, department.ParentNodeId); } //Загрузка типов узлов в combobox var view = Db.GetDeviceTypes(); comboBoxDevTypes.DisplayMember = "DeviceType"; for (var i = 0; i < view.Table.Rows.Count; i++) { comboBoxDevTypes.Items.Add(new DeviceTypeComboboxItem(view.Table.Rows[i]["Type"].ToString(), Convert.ToInt32(view.Table.Rows[i]["ID Device Type"]))); } }
public MoveComputersForm(NodeProperty np) { InitializeComponent(); Np = np; Moved = false; Spg = new SearchParametersGroup(); Db = new DevicesDatabase(); LoadNodes(); }
public void InitializeForm() { toolStripStatusLabel1.Text = @"Загрузка данных..."; statusStrip1.Refresh(); var dd = new DevicesDatabase(); switch (DisplayArchiveType) { case DisplayArchive.DeviceChangesArchive: dataGridView1.DataSource = dd.GetArchiveDeviceInfo(); dataGridView1.Columns["ID Device"].Visible = false; dataGridView1.Columns["Department"].HeaderText = @"Подразделение"; dataGridView1.Columns["Type"].HeaderText = @"Тип устройства"; dataGridView1.Columns["Device Name"].HeaderText = @"Системное имя"; dataGridView1.Columns["SerialNumber"].HeaderText = @"Серийный номер"; dataGridView1.Columns["InventoryNumber"].HeaderText = @"Инвентарный номер"; dataGridView1.Columns["Description"].HeaderText = @"Комментарий"; dataGridView1.Columns["Owner"].HeaderText = @"Оператор, добавивший устройство"; dataGridView1.Columns["Operation"].HeaderText = @"Операция"; dataGridView1.Columns["Date"].HeaderText = @"Дата операции"; dataGridView1.Columns["Operator"].HeaderText = @"Оператор, внесший изменения"; dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells; break; case DisplayArchive.NodeChangesArchive: dataGridView1.DataSource = dd.GetArchiveNodesInfo(); dataGridView1.Columns["ID Node"].Visible = false; dataGridView1.Columns["Device Name"].HeaderText = @"Системное имя"; dataGridView1.Columns["Parameter Name"].HeaderText = @"Характеристика"; dataGridView1.Columns["Value"].HeaderText = @"Значение"; dataGridView1.Columns["Operation"].HeaderText = @"Операция"; dataGridView1.Columns["Date"].HeaderText = @"Дата операции"; dataGridView1.Columns["Operator"].HeaderText = @"Оператор, внесший изменения"; dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells; break; case DisplayArchive.DeletedDeviceArchive: dataGridView1.DataSource = dd.GetArchiveDeletedDevicesInfoInfo(); dataGridView1.Columns["ID Device"].Visible = false; dataGridView1.Columns["Department"].HeaderText = @"Подразделение"; dataGridView1.Columns["Type"].HeaderText = @"Тип устройства"; dataGridView1.Columns["Device Name"].HeaderText = @"Системное имя"; dataGridView1.Columns["SerialNumber"].HeaderText = @"Серийный номер"; dataGridView1.Columns["InventoryNumber"].HeaderText = @"Инвентарный номер"; dataGridView1.Columns["Description"].HeaderText = @"Комментарий"; dataGridView1.Columns["Owner"].HeaderText = @"Оператор, добавивший устройство"; dataGridView1.Columns["Date"].HeaderText = @"Дата операции"; dataGridView1.Columns["Operator"].HeaderText = @"Оператор, внесший изменения"; dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells; break; } dd.Dispose(); toolStripStatusLabel1.Text = @"Выполнено"; }
public void InitForm() { label1.Text = ParamName; switch (ParamType) { case "text": textBoxParam.Visible = true; if (NodeRealId != -1) { textBoxParam.Text = (string)Value; } break; case "combobox": comboBoxParam.Visible = true; var db = new DevicesDatabase(); comboBoxParam.DataSource = db.GetValuesByMetaNodeId(AssocMetaNodeId); comboBoxParam.DisplayMember = "Value"; if (NodeRealId != -1) { comboBoxParam.SelectedIndex = comboBoxParam.FindString(Value.ToString()); } break; case "int": numericUpDownParam.Visible = true; if (NodeRealId != -1) { numericUpDownParam.Value = Convert.ToInt32(Value); } break; case "float": numericUpDownParam.Visible = true; numericUpDownParam.DecimalPlaces = 2; if (NodeRealId != -1) { numericUpDownParam.Value = Convert.ToDecimal(Value); } break; default: textBoxParam.Visible = true; if (NodeRealId != -1) { textBoxParam.Text = (string)Value; } break; } }
private void SearchFormSt3_Load(object sender, EventArgs e) { Db = new DevicesDatabase(); var list = Db.GetMonitoringExistsProperties(); comboBoxDeviceParameters.DataSource = list; comboBoxDeviceParameters.DisplayMember = "DisplayName"; comboBoxDeviceParameters.ValueMember = "Name"; if (comboBoxDeviceParameters.Items.Count > 0) { comboBoxDeviceParameters.SelectedIndex = 0; } else { buttonAccept.Enabled = false; } comboBoxOperator.SelectedIndex = 0; }
private void SearchFormSt2_Load(object sender, EventArgs e) { Db = new DevicesDatabase(); var list = Db.GetDeviceInfoMetaByType(DeviceTypeId); foreach (var deviceInfoMeta in list) { var node = new TreeNode { Text = deviceInfoMeta.NodeName, Tag = new NodeProperty(deviceInfoMeta.NodeId, NodeTypeEnum.DeviceComplexParameter) }; TreeNodesHelper.AddNode(node, treeViewDeviceInfo.Nodes, treeViewDeviceInfo.Nodes, deviceInfoMeta.ParentNodeId); } treeViewDeviceInfo.ExpandAll(); comboBoxDeviceParameters.DisplayMember = "ParameterName"; }
internal void InitializeForm(DevicesDatabase db) { var dv = db.GetInstallationsByComputerId(DeviceId); if (dv.Table == null) { return; } dataGridView1.DataSource = dv; dataGridView1.Columns["ID Installation"].Visible = false; dataGridView1.Columns["ID Computer"].Visible = false; dataGridView1.Columns["Software"].HeaderText = @"Программное обеспечение"; dataGridView1.Columns["Version"].HeaderText = @"Версия"; dataGridView1.Columns["InstallationDate"].HeaderText = @"Дата установки ПО"; dataGridView1.Columns["LicType"].HeaderText = @"Вид лицензии"; dataGridView1.Columns["BuyLicenseDate"].HeaderText = @"Дата приобретения лицензии"; dataGridView1.Columns["ExpireLicenseDate"].HeaderText = @"Дата окончания лицензии"; dataGridView1.Columns["LicKey"].HeaderText = @"Лицензионный ключ"; dataGridView1.Columns["SoftMaker"].HeaderText = @"Разработчик ПО"; dataGridView1.Columns["Supplier"].HeaderText = @"Поставщик ПО"; dataGridView1.Columns["SoftType"].HeaderText = @"Вид ПО"; dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells; toolStripStatusLabel1.Text = @"Всего установок: " + dataGridView1.RowCount; }
private void Reload(bool autoOpenFirstFoundDevice = false) { treeViewComputers.Nodes.Clear(); Db = new DevicesDatabase(); var list = Db.GetDepartments(Spg); var listFull = Db.GetDepartments(new SearchParametersGroup()); var cache = new List <Node>(); int cacheCount; do { cacheCount = cache.Count; cache.Clear(); foreach (var department in listFull) { if (!HasChildDepartmentsFromActiveList(department, listFull, list)) { continue; } var node = new TreeNode { Text = department.NodeName, Tag = new NodeProperty(department.NodeId, NodeTypeEnum.DepartmentNode) }; var inserted = TreeNodesHelper.AddNode(node, treeViewComputers.Nodes, treeViewComputers.Nodes, department.ParentNodeId); if (!inserted) { cache.Add(department); } } listFull.Clear(); listFull.AddRange(cache); }while (cache.Count != cacheCount); list = Db.GetDevices(Spg); TreeNode selectNode = null; foreach (var device in list) { var node = new TreeNode { Text = device.NodeName, Tag = new NodeProperty(device.NodeId, NodeTypeEnum.DeviceNode) }; TreeNodesHelper.AddNode(node, treeViewComputers.Nodes, treeViewComputers.Nodes, device.ParentNodeId); if (selectNode == null && autoOpenFirstFoundDevice) { selectNode = node; } } treeViewComputers.Sort(); if (treeViewComputers.Nodes.Count > 0) { treeViewComputers.SelectedNode = selectNode ?? treeViewComputers.Nodes[0]; } toolStripStatusLabelDeviceCount.Text = string.Format("Сетевых узлов: {0}", list.Count); var monitoringWarnings = Db.GetMonitoringWarnings().ToList(); if (!monitoringWarnings.Any()) { toolStripStatusLabelWarning.Visible = false; } else { toolStripStatusLabelWarning.Visible = true; toolStripStatusLabelWarning.ToolTipText = string.Join(Environment.NewLine, monitoringWarnings.ToArray()); } }