SQL DATA BASE SEARCH + OTHERS

AWARDED
Project Budget (USD)
$500

Project Description:
Hi,

This is what I need.
I am working on an application to automate 6 ovens. Mosto of the software is done except for the parts who links the oven data to main server and since I am not experienced on scripts and SQL, is taking more time that I can affort.
Now, what is is need is this:
-From HMI (runnung winCE), user will scan a router (lot process sheet). This router has a unique number. Once scan, this number should be used to search a SQL table where I will store a list of the lots produced (lot number, date, time, user and status (complete/incomplete). If the search do not find the scanned number, the result TRUE should be send back to HMI, If the search finds the number on the table, means that lote were already processed in another furnace, therefore, should return FALSE, telling user why it was rejected and what to do. Based on TRUE result, user should scan a second number for the product part number. If the product is found in products table, a temperature and time value should be returned to HMI and saved on a proper PLC register for inmediate use. If the part number is not found, should tell customer PART is invalid or do not exist.

Now, number 2. I need a section for recipes managing. User with credentials should be able to create, modify or set recipes out of use. The recipes has three basic paremeters: temperature, time and furnace # (this is what furnace can this recipe be used). This should be a table on the SQL and runs on the server only.

Number 3. I need a section for part number managing. User with credentians can be able to create, modify or set part number out of use. This part number table should have this columns: part number, recipe, furnace #, status (active, disabled). This should be a table on the SQL and runs on the server only. There should be a way to import an excel table containing all the information (most like to updates or firts time load)

Nombre 4. I need a section for user managing User with credentians can be able to create, modify or set users out of use. Users should be related to a group. This should be a table on the SQL and runs on server only.

Number 5. Reports. Report should be accesible to show as follows:
-Recipes
-Part numbers
-Lots
-Produced lot trend
-Some other query criteria will be defined later by my team, so lets dont work on this right away.

Can you help me getting this done? I will use your code with my application, so no visual job is requiered, only functional.
Should be done on Indusoft 7.

Quote asap please.

Skills required:
.NET, Data Entry, SQL
Hire josedavidch
Project offered by:
josedavidch Costa Rica
Verified