private void OnClickKeyGenerator(object sender, EventArgs e) { try { LMMainForm.PrepareDictionary(_dictCompanyNames, _listCompanyNames); PrepareDeviceCodes(_dictDeviceCodes, _dictCodes); KeyGenPrepareForm kgpf = new KeyGenPrepareForm(_dictCompanyNames, _dictDeviceCodes); if (kgpf.ShowDialog() == System.Windows.Forms.DialogResult.OK) { // Key generating: int iIDCompany = kgpf.IDCompany; string sCompanyName = kgpf.ResultCompany; string strDeviceCode = kgpf.ResultDeviceCode; int iIDDevice = RetrieveIdDevice(strDeviceCode); short nFlagOfTest = kgpf.TestKeyFlag ? ((short)1) : ((short)0); if (0 == nFlagOfTest) { // If it is NOT Test-key: int iLimitOfKeys = LMMainForm.GetLimitOfKeys(iIDCompany); int iExistKeys = RetrieveExistKeysForCompany(iIDCompany); if (iExistKeys >= iLimitOfKeys) { string strCompanyName = kgpf.ResultCompany; string strOut = string.Format("Превышение лимита ключей для компании '{0}'! Действие отменено!", strCompanyName); MessageBox.Show(strOut, "License Manager", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } } Key k = new Key(iIDDevice); k.ID = -1; // ID generate automatically k.FlagOfTest = nFlagOfTest; k.IssueDate = kgpf.DTIssueDate; // DateTime.Now; k.StartDate = kgpf.DTStartDate; // DateTime.Now; // TimeSpan ts = new TimeSpan(365, 0, 0, 0); // DateTime dtEnd = DateTime.Now + ts; k.EndDate = kgpf.DTEndDate; // dtEnd; k.KeyGenerate(); string s1 = ""; ReasonStore(sCompanyName, ref s1); int iIDKey = InsertKeyRecord(k); InsertKeyHistoryRecord(iIDKey, DateTime.Now, s1); DataTable tTable = _dsKeys.Tables["tblKeys"]; tTable.Rows.Clear(); RefreshKeysGrid(false, _keyFilter); } } catch (Exception ex) { log.ErrorFormat("KeysForm.OnClickKeyGenerator - {0}", ex.Message); } }
private void OnFilterLoad(object sender, EventArgs e) { try { radioButtonAnyKey.Checked = true; radioButtonAllKeys.Checked = true; checkBoxCompany.Checked = false; checkBoxDevice.Checked = false; checkBoxOwner.Checked = false; checkBoxParent.Checked = false; comboBoxCompany.Enabled = false; comboBoxDevice.Enabled = false; comboBoxOwner.Enabled = false; comboBoxParent.Enabled = false; _dictCompanyNames = new Dictionary <int, string>(); LMMainForm.PrepareDictionary(_dictCompanyNames, null); _dictDevicesCodes = new Dictionary <int, string>(); _listFNameOfOwners = new List <string>(); PrepareDeviceAndOwners(_dictDevicesCodes, _listFNameOfOwners); _dictParents = new Dictionary <int, int>(); PrepareParents(_dictParents); foreach (KeyValuePair <int, string> kvp in this._dictCompanyNames) { string strCompanyName = kvp.Value; comboBoxCompany.Items.Add((object)strCompanyName); } foreach (KeyValuePair <int, string> kvp in this._dictDevicesCodes) { string strOutCode = string.Format("Устройство '{0}' (код устройства '{1}')", kvp.Key, kvp.Value); comboBoxDevice.Items.Add((object)strOutCode); } foreach (string strFNameOfOwner in _listFNameOfOwners) { comboBoxOwner.Items.Add((object)strFNameOfOwner); } foreach (KeyValuePair <int, int> kvp in this._dictParents) { string strText = string.Format("Ключ '{0}' (вместо ключа '{1}')", kvp.Value, kvp.Key); comboBoxParent.Items.Add((object)strText); } } catch (Exception ex) { log.ErrorFormat("KeyFilterForm.OnFilterLoad - {0}", ex.Message); } }
private Dictionary <int, int> _dictParents; // IDPARENT as a Key, ID (current) - as a Value public KeyFilterForm(LMMainForm mainForm, KeyFilter keyFilter) { _mainForm = mainForm; _keyFilter = keyFilter; InitializeComponent(); // Set key-filter into unactive state: _keyFilter.IDCompany = -1; _keyFilter.IDDevice = -1; _keyFilter.IDKey = -1; _keyFilter.IDParentKey = -1; _keyFilter.FNameOfOwner = ""; // Empty string }
private List <int> _listHistKeys; // List of IDs public KeyHistoryForm(LMMainForm mainForm, List <int> listHistKeys) { try { _mainForm = mainForm; _listHistKeys = listHistKeys; InitializeComponent(); } catch (Exception ex) { log.ErrorFormat("KeyHistoryForm.KeyHistoryForm - {0}", ex.Message); } }
public KeysForm(LMMainForm mainForm, KeyFilter keyFilter = null) { try { _keyFilter = keyFilter; _mainForm = mainForm; InitializeComponent(); } catch (Exception ex) { log.ErrorFormat("KeysForm.KeysForm - {0}", ex.Message); } }
public CompanyForm(LMMainForm mainForm) { try { _mainForm = mainForm; InitializeComponent(); this.sqlSelectCommand1.Connection = _mainForm.SqlConnection; this.sqlInsertCommand1.Connection = _mainForm.SqlConnection; this.sqlUpdateCommand1.Connection = _mainForm.SqlConnection; this.sqlDeleteCommand1.Connection = _mainForm.SqlConnection; } catch (Exception ex) { log.ErrorFormat("CompanyForm.CompanyForm - {0}", ex.Message); } }
public AboutForm() { string strFileName = "LM.exe"; InitializeComponent(); FileVersionInfo fileVersionInfo = FileVersionInfo.GetVersionInfo(strFileName); string strVersion = fileVersionInfo.FileVersion; DateTime dtCompileDateTime = LMMainForm.RetrieveLinkerTimestamp(strFileName); labelVersion.Text = strVersion; labelTime.Text = dtCompileDateTime.ToString(); string strLink = "http://files.rsdn.ru/21902/alexgin_resume.pdf"; int iLen = this.linkLabel1.Text.Length; this.linkLabel1.Links.Add(0, iLen, strLink); }
private void OnClickEditDevices(object sender, EventArgs e) { try { if (dataGridView2.ReadOnly) { LMMainForm.PrepareDictionary(_dictCompanyNames, _listCompanyNames); dataGridView2.ReadOnly = false; dataGridView2.AllowUserToAddRows = true; dataGridView2.RowHeadersVisible = true; toolStripBtnEdit.Enabled = false; toolStripBtnSave.Enabled = true; } } catch (Exception ex) { log.ErrorFormat("DevicesForm.OnClickEditDevices - {0}", ex.Message); } }
private void OnLoadDevices(object sender, EventArgs e) { try { _dictCompanyNames = new Dictionary <int, string>(); _listCompanyNames = new List <string>(); LMMainForm.PrepareDictionary(_dictCompanyNames, _listCompanyNames); DataTable tTable = new DataTable("tblDevices"); DataColumn clID = new DataColumn("ID", typeof(int)); DataColumn clIDCOMPANY = new DataColumn("IDCOMPANY", typeof(int)); DataColumn clCompanyName = new DataColumn("CompanyName", typeof(string)); // Column for replace DataColumn clCodeOfKey = new DataColumn("CodeOfKey", typeof(string)); DataColumn clFNameOfOwner = new DataColumn("FNameOfOwner", typeof(string)); DataColumn clPositionOfOwner = new DataColumn("PositionOfOwner", typeof(string)); tTable.Columns.Add(clID); tTable.Columns.Add(clIDCOMPANY); tTable.Columns.Add(clCompanyName); tTable.Columns.Add(clCodeOfKey); tTable.Columns.Add(clFNameOfOwner); tTable.Columns.Add(clPositionOfOwner); _dsDevices = new DataSet("dsDevices"); _dsDevices.Tables.Add(tTable); _bs = new BindingSource(_dsDevices, "tblDevices"); dataGridView2.DataSource = _bs; sqlDataAdapter1.Fill(_dsDevices, "tblDevices"); // see: // https://social.msdn.microsoft.com/Forums/windows/en-US/abb7be97-0a44-4e18-98bf-687a723645a9/combo-box-inside-datagridview-using-datatable?forum=winformsdatacontrols DataGridViewComboBoxColumn colCombo = new DataGridViewComboBoxColumn(); { colCombo.DataPropertyName = "CompanyName"; colCombo.HeaderText = "ComboBoxColumn"; colCombo.DropDownWidth = 250; colCombo.Width = 90; colCombo.MaxDropDownItems = _listCompanyNames.Count; colCombo.FlatStyle = FlatStyle.Flat; colCombo.DataSource = _listCompanyNames; // colCombo.ValueMember = "CompanyName"; // colCombo.DisplayMember = colCombo.ValueMember; colCombo.ValueType = typeof(string); } dataGridView2.Columns.Remove("CompanyName"); dataGridView2.Columns.Insert(2, colCombo); foreach (DataRow dr in tTable.Rows) { string strIdCompany = dr["IDCOMPANY"].ToString(); int iCompanyId = Convert.ToInt32(strIdCompany); dr["CompanyName"] = _dictCompanyNames[iCompanyId]; } // Rename 'HeaderText' ONLY via dataGridView!!! // DO NOT using dataSet/dataTable for this action!!! int iIndex = 0; foreach (DataGridViewColumn column in dataGridView2.Columns) { switch (iIndex) { case 0: column.Width = 45; column.HeaderText = "N п/п"; break; case 1: column.Visible = false; // Hide "IDCOMPANY" column break; case 2: column.Width = 175; column.HeaderText = "Название организации"; break; case 3: column.Width = 65; column.HeaderText = "Код устройства"; break; case 4: column.Width = 135; column.HeaderText = "Фамилия владельца"; break; case 5: column.Width = 135; column.HeaderText = "Должность владельца"; break; } iIndex++; } dataGridView2.ReadOnly = true; dataGridView2.AllowUserToAddRows = false; dataGridView2.RowHeadersVisible = false; toolStripBtnSave.Enabled = false; } catch (Exception ex) { log.ErrorFormat("DevicesForm.OnLoadDevices - {0}", ex.Message); } }
private void OnClickKeyGenerChild(object sender, EventArgs e) { try { int iSelRow = dataGridView3.CurrentCell.RowIndex; string strParentKey = dataGridView3.Rows[iSelRow].Cells[0].Value.ToString(); int iParentKey = Convert.ToInt32(strParentKey); string strCompanyId = dataGridView3.Rows[iSelRow].Cells[1].Value.ToString(); int iCompanyId = Convert.ToInt32(strCompanyId); string strCompanyName = dataGridView3.Rows[iSelRow].Cells[2].Value.ToString(); string strDeviceCode = dataGridView3.Rows[iSelRow].Cells[4].Value.ToString(); LMMainForm.PrepareDictionary(_dictCompanyNames, _listCompanyNames); PrepareDeviceCodes(_dictDeviceCodes, _dictCodes); KeyGenPrepareForm kgpf = new KeyGenPrepareForm(_dictCompanyNames, _dictDeviceCodes, iParentKey); kgpf.IDCompany = iCompanyId; kgpf.ResultCompany = strCompanyName; kgpf.ResultDeviceCode = strDeviceCode; if (kgpf.ShowDialog() == System.Windows.Forms.DialogResult.OK) { // Key generating: // int iIDCompany = kgpf.IDCompany; int iIDDevice = RetrieveIdDevice(strDeviceCode); short nFlagOfTest = kgpf.TestKeyFlag ? ((short)1) : ((short)0); Key k = new Key(iIDDevice); k.ID = -1; // ID generate automatically k.FlagOfTest = nFlagOfTest; k.IssueDate = kgpf.DTIssueDate; // DateTime.Now; k.StartDate = kgpf.DTStartDate; // DateTime.Now; // TimeSpan ts = new TimeSpan(365, 0, 0, 0); // DateTime dtEnd = DateTime.Now + ts; k.EndDate = kgpf.DTEndDate; // dtEnd; k.IDParentKey = iParentKey; k.KeyGenerate(); string s1 = ""; if (!ReasonStore(strCompanyName, ref s1, iParentKey)) { return; } int iIDKey = InsertKeyRecord(k); InsertKeyHistoryRecord(iIDKey, DateTime.Now, s1); DataTable tTable = _dsKeys.Tables["tblKeys"]; tTable.Rows.Clear(); RefreshKeysGrid(false, _keyFilter); } } catch (Exception ex) { log.ErrorFormat("KeysForm.OnClickKeyGenerChild - {0}", ex.Message); } }
private void OnLoadKeys(object sender, EventArgs e) { try { _dictCompanyNames = new Dictionary <int, string>(); _listCompanyNames = new List <string>(); LMMainForm.PrepareDictionary(_dictCompanyNames, _listCompanyNames); _dictDeviceCodes = new Dictionary <int, List <string> >(); _dictCodes = new Dictionary <int, string>(); PrepareDeviceCodes(_dictDeviceCodes, _dictCodes); DataTable tTable = new DataTable("tblKeys"); DataColumn clID = new DataColumn("ID", typeof(int)); DataColumn clIDCOMPANY = new DataColumn("IDCOMPANY", typeof(int)); DataColumn clCompanyName = new DataColumn("CompanyName", typeof(string)); DataColumn clIDDEVICE = new DataColumn("IDDEVICE", typeof(int)); DataColumn clDeviceCode = new DataColumn("DeviceCode", typeof(string)); DataColumn clIDPARENTKEY = new DataColumn("IDPARENTKEY", typeof(int)); DataColumn clSecondKey = new DataColumn("SecondKey", typeof(string)); DataColumn clValueOfKey = new DataColumn("ValueOfKey", typeof(string)); DataColumn clStartDate = new DataColumn("StartDate", typeof(System.DateTime)); DataColumn clEndDate = new DataColumn("EndDate", typeof(System.DateTime)); DataColumn clValidCheckBox = new DataColumn("ValidCheckBox", typeof(bool)); // Column for replace DataColumn clFlagOfTest = new DataColumn("FlagOfTest", typeof(short)); DataColumn clTestCheckBox = new DataColumn("TestCheckBox", typeof(bool)); // Column for replace DataColumn clIssueDate = new DataColumn("IssueDate", typeof(System.DateTime)); DataColumn clFNameOfOwner = new DataColumn("FNameOfOwner", typeof(string)); DataColumn clPositionOfOwner = new DataColumn("PositionOfOwner", typeof(string)); tTable.Columns.Add(clID); tTable.Columns.Add(clIDCOMPANY); tTable.Columns.Add(clCompanyName); tTable.Columns.Add(clIDDEVICE); tTable.Columns.Add(clDeviceCode); tTable.Columns.Add(clIDPARENTKEY); tTable.Columns.Add(clSecondKey); tTable.Columns.Add(clValueOfKey); tTable.Columns.Add(clStartDate); tTable.Columns.Add(clEndDate); tTable.Columns.Add(clValidCheckBox); tTable.Columns.Add(clFlagOfTest); tTable.Columns.Add(clTestCheckBox); tTable.Columns.Add(clIssueDate); tTable.Columns.Add(clFNameOfOwner); tTable.Columns.Add(clPositionOfOwner); _dsKeys = new DataSet("dsKeys"); _dsKeys.Tables.Add(tTable); _bs = new BindingSource(_dsKeys, "tblKeys"); dataGridView3.DataSource = _bs; RefreshKeysGrid(true, _keyFilter); } catch (Exception ex) { log.ErrorFormat("KeysForm.OnLoadKeys - {0}", ex.Message); } }