I need a software that generates "unique" barcode numbers according to my entries of [login to view URL] is 16 different variables. And barcode number length's maximum value is 14. Shortly, according to values of 16 variables, software will generate 14 digits barcode number. Should work on Ms SQL, and interface maybe coded on C# or others.
## Deliverables
I need a software that generates "unique" barcode numbers according to my entries of [login to view URL] is 16 different variables. And barcode number length's maximum value is 14. Shortly, according to values of 16 variables, software will generate 14 digits barcode [login to view URL] as I guess the software will record all the sql id numbers of entries as a string (sample string => 1:245:876:12:14:65:12:2324) and give a unique barcode number to this string. And each time its gonna benchmark these strings. If the strings are the same, software will show the exists barcode number with a warning. If strings are different, its gonna create a new barcode number and save the string into strings sql table.
The software will work on Ms Sql and the interface may be C# or else. I prefer user interface side as open source.
Definations of Variables :
1) Width of product = Its between 1 mm to 300 mm. It will count up one by one (1,2,3,4,..) and user will select the value. These values will be pre-defined in Width of product sql table. User wont able to do any modification over interface. User will just select one value from the list. And these values will be stored in Width of product sql table. Values are digits. Sample : 26 MM
2) Type of the product = There is 20 different product values. User will choose one from a list. Also it will be possible to add new values. Such as there may be 5 entered values, user may add new values. But the maximum value number is 20. While adding a new value to database, the maximum character limit must be 20. Values are characters. Example : Super Elastic Ribbon
3) Main Yarn Type = There is 20 different main yarn types. User will choose from a list. Also it ll be possible to add new values. Such as there may be 5 entered values, user may add new values. But the maximum value number is 20. Main yarn types should have its own sql table. While adding a new value the maximum character limit must be 20. Values are characters. Example : polypropylene
4) Denier of the main yarn type = Each main yarn type may have around 200 different deniers. User will add these values by time. And its gonna be possible to select one pre-added value. Each main yarn type's denier values should be stored in a different sql table. While adding a new value the maximum digit limit must be 15. values are digits. Example : 2500 Denier
5) Colour of the main Yarn type = Each main yarn type may have around 200 different colours. User will add these values to the software by time. And its gonna be possible to select one pre-added value. Each main yarn type's color values should be stored in a different sql table. While adding a new value the maximum character limit must be 20. Values are characters. Example : Black
6) Extra Yarn 1 Type = There is 15 different extra yarn 1 types. User will choose from a list. Also it ll be possible to add new values. Such as there may be 5 entered values, user may add new values. But the maximum value number is 20. Extra yarn 1 types should have its own sql table. While adding a new value the maximum character limit must be 15. Values are characters. Example : Elastic
7) Extra yarn 1 Denier = Extra yarn 1 Denier may have around 200 different deniers. User will add these values by time. And its gonna be possible to select one pre-added value. Each Extra yarn 1 types' denier values should be stored in a different sql table. While adding a new value the maximum digit limit must be 20. values are digits. Example : 1200 Denier.
8) Extra yarn 1 Colour = Extra yarn 1 Color may have around 200 different [login to view URL] will add these values to the software by time. And its gonna be possible to select one pre-added value. Each extra yarn 1 type's color values should be stored in a different sql table. While adding a new value the maximum character limit must be 20. Values are characters. Example : White
9) Extra yarn 2 Type = There is 15 different Extra yarn 2 types. User will choose from a list. Also it ll be possible to add new values. Such as there may be 5 entered values, user may add new values. But the maximum value number is
20. Extra yarn 2 type should have its own sql table. While adding a new value the maximum character limit must be 20. Values are characters. Example : Nylon
10) Extra yarn 2 Denier = Extra yarn 2 Denier may have around 200 different deniers. User will add these values by time. And its gonna be possible to select one pre-added value. Each Extra yarn 2 types' denier values should be stored in a different sql table. While adding a new value the maximum digit limit must be 20. values are digits. Example : 1500 Denier.
11) Extra yarn 2 Colour = Extra yarn 2 Color may have around 200 different colours. User will add these values to the software by time. And its gonna be possible to select one pre-added value. Each extra yarn 2 type's color values should be stored in a different sql table. While adding a new value the maximum character limit must be 20. Values are characters. Example : Green
12) Extra yarn 3 Type = There is 15 different Extra yarn 3 types. User will choose from a list. Also it ll be possible to add new values. Such as there may be 5 entered values, user may add new values. But the maximum value number is 20. Extra yarn 3 type should have its own sql table. While adding a new value the maximum character limit must be 20. Values are characters. Example : Cotton
13) Extra yarn 3 Denier = Extra yarn 3 Denier may have around 200 different deniers. User will add these values by time. And its gonna be possible to select one pre-added value. Each Extra yarn 3 types' denier values should be stored in a different sql table. While adding a new value the maximum digit limit must be 20. values are digits. Example : 1100 Denier.
14) Extra yarn 3 Colour = Extra yarn 3 Color may have around 200 different colours. User will add these values to the software by time. And its gonna be possible to select one pre-added value. Each extra yarn 3 type's color values should be stored in a different sql table. While adding a new value the maximum character limit must be 20. Values are characters. Example : Yellow
15) Weaving Style = Weaving style may have around 3000 different values. User will choose from a list. Also it ll be possible to add new values. Such as there may be 5 entered values, user may add new values. But the maximum value number is 3000. Weaving style should have its own sql table. While adding a new value the maximum character limit must be 30. values are characters. Example : Whipcord designed
16) Gram = Its between 1 to 250 gram. It maybe be like 12.5 or 12.3. So As I guess its better to let user to enter the value manually and save it to database. Surely user will able to select a pre-added value from a list also. While adding a new value the maximum digit numbers must be 4. Values are digits. Example : 12.7
Warning : Software SHOULD NOT re-range these values each time a new one added. There is no problem about seeing all those values under one another like 10.7, 9.3, 18.9, 2.4.
Features of software :
1) These variales MUST be entered to create a barcode nuber =
Width of product,
Type of the product,
Main Yarn Type,
Denier of the main yarn type,
Colour of the main Yarn type,
Weaving Style,
Gram.
Other variables are optional, but,
if Yarn Extra 1 is selected, its color and denier variables must be selected too.
if Yarn Extra 2 is selected, its color and denier variables must be selected too.
if Yarn Extra 3 is selected, its color and denier variables must be selected too.
2) As I guess instead of creating a new interface to let user add some variables and values to database,
its better to add little buttons near of variable entry fields. Cause in a different interface, user may do mistakes.
3) The language of the software will be Turkish. I ll give you the translation of all variables, values and others.
4) Software must create a back-up file each time while its being closed.
So while its being closed, there must be a warning like "please wait, Im backing up.."
Optional backing-up feature must be added to software also.
5) There must be "Search" feature.
By choosing and entering variables that I wrote down above, software should make a search and give all the details.
Also, it must able to search by barcode number.
Example :
Width of product : 25 mm
Denier of the main yarn type :1200
Should list all the details of results that confirm these variable.
6) values are shouldnt be written to database till it controls, if there is a barcode number that is created with the same variables before. If there is, it will show the exists barcode number with a warning. If it didnt, it should generate and by a "save" button, software should save them all into database.
7) If a crash happens while saving (like one of "must entered" variables didnt written into its own table but others are written, other entries must be deleted and database cleaned too.)
8) User interface should be "user friendly"
8) These are my opinions and needs. According to your experiences and programming skills, you may offer and suggest me different techniques or ways about the way of software's working style or others. Im openned them all.
Thanks for your attention.