private void inicio() { try { limpa_campos(); cSetor cs = new cSetor(); using (DataSet dt = cs.retorna_setor()) { cboArea.DataSource = dt.Tables[0]; cboArea.DisplayMember = "SETOR"; cboArea.ValueMember = "ID_SETOR"; cboArea.Text = string.Empty; } status_form(false); cUsuario user = new cUsuario(); using (DataTable dt = user.preenche_lista_usuario()) { #region listview lvUsuarios.Clear(); lvUsuarios.View = View.Details; lvUsuarios.LabelEdit = true; lvUsuarios.AllowColumnReorder = true; lvUsuarios.CheckBoxes = false; lvUsuarios.FullRowSelect = true; lvUsuarios.GridLines = true; lvUsuarios.Sorting = SortOrder.Ascending; lvUsuarios.Columns.Add("", 0); lvUsuarios.Columns.Add("Nome", 200, HorizontalAlignment.Left); lvUsuarios.Columns.Add("Email", 200, HorizontalAlignment.Left); lvUsuarios.Columns.Add("Login", 150, HorizontalAlignment.Left); lvUsuarios.Columns.Add("Data Cadastro", 120, HorizontalAlignment.Left); lvUsuarios.Columns.Add("", 0); lvUsuarios.Columns.Add("", 0); lvUsuarios.Columns.Add("", 0); lvUsuarios.Columns.Add("", 0); lvUsuarios.Columns.Add("", 0); lvUsuarios.Columns.Add("", 0); for (int i = 0; i < dt.Rows.Count; i++) { DataRow drw = dt.Rows[i]; ListViewItem lvi = new ListViewItem(drw["ID_USUARIO"].ToString()); lvi.SubItems.Add(drw["USUARIO"].ToString()); lvi.SubItems.Add(drw["EMAIL"].ToString()); lvi.SubItems.Add(drw["LOGIN"].ToString()); lvi.SubItems.Add(drw["DTCAD"].ToString()); lvi.SubItems.Add(drw["RESET_PWD"].ToString()); lvi.SubItems.Add(drw["ADM"].ToString()); lvi.SubItems.Add(drw["ATIVO"].ToString()); lvi.SubItems.Add(drw["ID_SETOR"].ToString()); lvi.SubItems.Add(drw["COLAGEM"].ToString()); lvi.SubItems.Add(drw["RPT"].ToString()); lvUsuarios.Items.Add(lvi); } lblTotalReg.Text = string.Concat("Total de ", lvUsuarios.Items.Count, " registro(s)"); #endregion } if (lvUsuarios.Items.Count == 0) { mnuOculto.Enabled = false; } else { mnuOculto.Enabled = true; } if (lvUsuarios.Items.Count > 0) { lvUsuarios.Items[0].Selected = true; lvwUsuarios_Click(null, null); } } catch (Exception ex) { throw ex; } }
private void inicio() { try { txtID.Text = string.Empty; txtSetor.Text = string.Empty; txtSetor.Focus(); cSetor cst = new cSetor(); using (DataTable dt = cst.preenche_lista_setor()) { #region listview lvSetor.Clear(); lvSetor.View = View.Details; lvSetor.LabelEdit = true; lvSetor.AllowColumnReorder = true; lvSetor.CheckBoxes = false; lvSetor.FullRowSelect = true; lvSetor.GridLines = true; lvSetor.Sorting = SortOrder.Ascending; lvSetor.Columns.Add("ID", 50); lvSetor.Columns.Add("Setor", 330, HorizontalAlignment.Left); for (int i = 0; i < dt.Rows.Count; i++) { DataRow drw = dt.Rows[i]; ListViewItem lvi = new ListViewItem(drw["ID_SETOR"].ToString()); lvi.SubItems.Add(drw["SETOR"].ToString()); lvSetor.Items.Add(lvi); } lblTotalReg.Text = string.Concat("Total de ", lvSetor.Items.Count, " registro(s)"); #endregion } if (lvSetor.Items.Count == 0) { mnuOculto.Enabled = false; } else { mnuOculto.Enabled = true; } if (lvSetor.Items.Count > 0) { lvSetor.Items[0].Selected = true; lvSetor_Click(null, null); } } catch (Exception ex) { #region LOG ERRO cLog lg = new cLog(); lg.log = ex.Message.Replace("'", ""); lg.form = this.Text; lg.metodo = "Inicio"; lg.dt = DateTime.Now; lg.usersistema = cGlobal.userlogado; lg.userRede = Environment.UserName; lg.terminal = Environment.MachineName; lg.tp_flag = false; lg.grava_log(lg); #endregion } }
private void mnuExcluir_Click(object sender, EventArgs e) { try { if (lvSetor.SelectedItems.Count == 0) { tsslblMsg.Text = "Nenhum registro foi selecionado"; return; } cSetor cst = new cSetor(); cst.id_setor = Convert.ToInt32(lvSetor.SelectedItems[0].Text); cst.setor = lvSetor.SelectedItems[0].SubItems[1].Text; DialogResult dlr = (MessageBox.Show(string.Concat("Deseja realmente exclui o setor:\n", lvSetor.SelectedItems[0].SubItems[1].Text, "?"), "Atenção", MessageBoxButtons.YesNo, MessageBoxIcon.Question)); if (dlr == DialogResult.Yes) { if (!cst.exclui_setor(cst)) { MessageBox.Show("Registro excluído com sucesso.", "Mensagem", MessageBoxButtons.OK, MessageBoxIcon.Information); #region LOG cLog lg = new cLog(); lg.log = string.Concat("Exclusão de Registro.", Environment.NewLine, "Setor: ", cst.setor.ToUpper() ); lg.form = this.Text; lg.metodo = sender.ToString(); lg.dt = DateTime.Now; lg.usersistema = cGlobal.userlogado; lg.userRede = Environment.UserName; lg.terminal = Environment.MachineName; lg.tp_flag = true; lg.grava_log(lg); #endregion inicio(); } else { MessageBox.Show(string.Concat("O registro não pode ser excluído,", Environment.NewLine, "pois contém EVENTO(S) vínculados a ele."), "Mensagem", MessageBoxButtons.OK, MessageBoxIcon.Information); inicio(); } } else { return; } } catch (Exception ex) { #region LOG ERRO cLog lg = new cLog(); lg.log = ex.Message.Replace("'", ""); lg.form = this.Text; lg.metodo = sender.ToString(); lg.dt = DateTime.Now; lg.usersistema = cGlobal.userlogado; lg.userRede = Environment.UserName; lg.terminal = Environment.MachineName; lg.tp_flag = false; lg.grava_log(lg); #endregion } }
private void tsbtnSalvar_Click(object sender, EventArgs e) { try { cSetor cst = new cSetor(); #region VALIDAÇÃO if (string.IsNullOrEmpty(txtSetor.Text)) { tsslblMsg.Text = "Nome do setor não informado"; txtSetor.Focus(); return; } #endregion if (!cGlobal.editando) { cst.setor = txtSetor.Text.ToUpper(); cst.grava_setor(cst); MessageBox.Show("Setor registrado com sucesso.", "Mensagem", MessageBoxButtons.OK, MessageBoxIcon.Information); #region LOG cLog lg = new cLog(); lg.log = string.Concat("Cadastro de Registro.", Environment.NewLine, "Setor: ", txtSetor.Text.ToUpper() ); lg.form = this.Text; lg.metodo = sender.ToString(); lg.dt = DateTime.Now; lg.usersistema = cGlobal.userlogado; lg.userRede = Environment.UserName; lg.terminal = Environment.MachineName; lg.tp_flag = true; lg.grava_log(lg); #endregion } else { cst.id_setor = Convert.ToInt32(txtID.Text); cst.setor = txtSetor.Text.ToUpper(); cst.atualiza_cadastro_setor(cst); MessageBox.Show("O Setor foi alterado com sucesso.", "Mensagem", MessageBoxButtons.OK, MessageBoxIcon.Information); #region LOG cLog lg = new cLog(); lg.log = string.Concat("Alteração de Registro.", Environment.NewLine, "Setor: ", txtSetor.Text.ToUpper() ); lg.form = this.Text; lg.metodo = sender.ToString(); lg.dt = DateTime.Now; lg.usersistema = cGlobal.userlogado; lg.userRede = Environment.UserName; lg.terminal = Environment.MachineName; lg.tp_flag = true; lg.grava_log(lg); #endregion } inicio(); } catch (Exception ex) { #region LOG ERRO cLog lg = new cLog(); lg.log = ex.Message.Replace("'", ""); lg.form = this.Text; lg.metodo = sender.ToString(); lg.dt = DateTime.Now; lg.usersistema = cGlobal.userlogado; lg.userRede = Environment.UserName; lg.terminal = Environment.MachineName; lg.tp_flag = false; lg.grava_log(lg); #endregion } }