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