Exemplo n.º 1
0
        //下拉框选择逻辑
        private void cmbRole_SelectedIndexChanged(object sender, EventArgs e)
        {
            int              roleId   = cmbRole.SelectedIndex + 2;
            string           roleName = cmbRole.Text;
            string           oldName  = string.Empty;
            DataGridViewCell cell     = dgvAuth.CurrentCell;

            if (cell != null)
            {
                try
                {
                    oldName    = cell.Value.ToString();
                    cell.Value = roleName;
                    int row = cell.RowIndex;
                    dgvAuth.Rows[row].Cells[2].Value = roleId;
                    Db.Authority auth = new Db.Authority();
                    auth.Id   = Convert.ToInt32(dtAuth.Rows[row]["id"]);
                    auth.Name = dtAuth.Rows[row]["name"].ToString();
                    Role role = new Role(roleId, roleName);
                    auth.Role = role;
                    if (auth.Update())
                    {
                        LogMan.Log2Sqlite(new Log(LogLevel.Info, EventType.权限管理, "修改权限:" + dtAuth.Rows[row]["name"].ToString() + "(" + oldName + "->" + roleName + ")", DateTime.Now));
                    }
                }
                catch (Exception ex)
                {
                    LogMan.Log2File(null, ex);
                }
            }
        }
Exemplo n.º 2
0
        /// <summary>
        /// Finds the specified Authority.
        /// </summary>
        /// <param name="where">The where.</param>
        /// <returns>Authority.</returns>
        public static Authority Find(string where)
        {
            Authority auth   = new Authority();
            Sqlite    sqlite = new Sqlite();
            string    text   = "SELECT A.id,A.name,R.id,R.name FROM auth A,role R WHERE A.roleid=R.id ";

            if (!string.IsNullOrEmpty(where))
            {
                text = text + " AND A." + where;
            }
            SQLiteDataReader reader = sqlite.Query(text);

            while (reader.Read())
            {
                auth.Id   = reader.GetInt32(0);
                auth.Name = reader.GetString(1);
                Role role = new Role();
                role.Id   = reader.GetInt32(2);
                role.Name = reader.GetString(3);
                auth.Role = role;
            }
            sqlite.Close();
            return(auth);
        }