已完成

Database Table Editor/Viewer - for User Permissions

该项目成功由sheikDev ,以£75 GBP的价钱在4 天内完成。

为像这样的项目获取免费报价
雇主工作
项目预算
£20 - £250 GBP
完成于
4 天
全部竞标
18
项目描述

I have 2 Tables. STATIONS & PERSONS

Each of these tables has numerous columns.

STATIONS has a column called MRPCapability.

PERSONS has it's own column called MRPCapability.

Although these columns in each table are NOT related - they do both have a Comma Separated List of Integers.

These integers are the PRIMARYKEYs to a separate Table (MRPTransactionCode).

Background context - the MRPTransactionCodes are 'PossibleTasks' . The list of MRPTransactionCodes for each Person or each Station is acting like a PERMISSION check to allow a certain Tasks to be actioned.

In brief - the Comma Separated List is saving having to create a many to many table to link Station to MRPTransactionCode & Persons to MRPTransactionCode.

REQUIREMENT

I need 2 user Controls. One for PERSONs - described below (and the 2nd for STATIONs, which will be the same as for Persons).

I would like a Grid style UserControl to visualise all Persons, showing which MRPTransaction they have permission to action.

The UserControl must allow editing of the MRPTransactionCode list (the comma separated Integers), in a user friendly GUI.

The Grid would have all Persons listed down the side (Row Headings).

Each MRPTransactionCode would be listed across the top (Colum Headings).

The data in the grid would be either true or false.

If false - leave blank.

If true - show an Icon (I can change the Icon later or send one now).

The database is MSSQL (2008 onwards).

The code should be written as a VS c# Project. (VS2015 or earlier).

.Net Framework 4.0.

完成:
需要技能

在寻找赚取金钱的机会?

  • 设定您的预算和时间框架
  • 大致描述您的建议方案
  • 为您的工作领取工资

雇用同样在该项目上竞标的威客

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online