да се състави програма C за нуждите на машиностроителен завод,която поддържа следната информация за наличния машинен парк. -име на машина; -цена на закупуване (в лева); -година на закупуване; -фирма производител; и извършва следните операции -създаване на нов празен файл; -добавя нова информация за закупени нови машини и изтрива ненужната за бракувани машини; -извежда броя на машините,произведени от дадена фирма; -прехвърля в текстов файл списък с машините,подлежащи на бракуване(закупени преди повече от даден брой години).

Здравей, да ще можем да ти помогнем, но преди ние да го направим, трябва ти да си помогнеш сам. Напиши код, пробвай го и като закъсаш някъде, постваш го тук и евентуално получаваш помощ, но не и цялата програма наведнъж на готово.

#include <iostream> #include <string.h> struct Zavod { char Machinename [31]; char Manufacturer [31]; int Year; float Price; }; FILE *fl; char bf [1]; Zavod zavod; char imefl [31]; void Reading (Zavod *zz) { printf ("n"); printf ("Machine name: "); gets (zz->Machinename); printf ("Manufacturer: "); gets (zz->Manufacturer); printf ("Year of manufacture: "); scanf ("%d", &zz->Year); printf ("Price of machine: "); scanf ("%f", &zz->Price); printf ("n"); gets (bf); } void Writing (Zavod zz) { printf ("Machine name: %sn", zz.Machinename); printf ("Manufacturer: %sn", zz.Manufacturer); printf ("Year of manufacture: %dn", zz.Year); printf ("Price: %.2fn", zz.Price); printf ("n"); } int exist(char *ime){ FILE *f = fopen(ime,"r");fclose(f); return f!=NULL; } void Newfile() { char ch; if (exist(imefl)) { printf ("n"); printf("The file already exists! "); printf("Do you want to rewrite it? "); ch=getchar(); if (ch == 'n') return; } fl=fopen(imefl,"w"); fclose(fl); printf("n The file has been created.n"); printf ("n"); } void Add(){ char ch; if (!exist(imefl)) { printf("The file is not created!n");return; } fl=fopen(imefl,"a+b"); do{ Reading(&zavod); fwrite(&zavod,sizeof(zavod),1,fl); printf("Do you want to continue? "); printf ("n"); ch=getchar();getchar(); }while (ch != 'n'); fclose(fl); } void Delete() { FILE *delfl; char old[31]; if (!exist (imefl)) { printf("The file is not created!n");return; } printf ("n"); printf("Machine name: "); gets(old); fl=fopen(imefl,"rb");delfl=fopen("Del"," wb"); fread(&zavod,sizeof(zavod),1,fl); while (!feof(fl)){ if (strcmp(zavod.Machinename,old)!=0) fwrite(&zavod,sizeof(zavod),1,delfl); else printf("The data about machine [%s] has been deleted. n",old); printf ("n"); fread(&zavod,sizeof(zavod),1,fl); } fclose(fl); fclose(delfl); remove(imefl); rename("Del",imefl); } void List(){ int k; int Current; float price=100000; int Helper; if (!exist(imefl)) { printf("The file is not created!n");return; } printf("n"); printf("Current year: "); scanf ("%d", &Current); Helper=Current-5; printf ("n"); fl=fopen(imefl,"rb"); k=0; fread(&zavod,sizeof(zavod),1,fl); while (!feof(fl)){ if ((zavod.Year>Helper) && (zavod.Price>price)) { k++; Writing(zavod);} fread(&zavod,sizeof(zavod),1,fl); } if (k==0) printf("There aren't machines manufactured within five yars n"); fclose(fl); } void ListMachines() { int k=0; FILE *txt; char Transfer [31]; if (!exist(imefl)) { printf("The file is not created!n"); return; } printf ("n"); printf ("Machine manufacturer: "); gets(Transfer); fl=fopen(imefl,"rb"); txt=fopen("New.txt","wt"); fread(&zavod,sizeof(zavod),1,fl); while (!feof(fl)) { if (strcmp (zavod.Manufacturer,Transfer)==0) { fprintf(txt,"%-21s %s %d %fn",zavod.Machinename, zavod.Manufacturer, zavod.Price, zavod.Year); k++; } fread(&zavod,sizeof(zavod),1,fl); } fclose(fl);fclose(txt); if (k==0) printf("There aren't machines manufactured by this firmn"); } int main() { int c; printf("File name: ");gets(imefl); do { printf("%10sMenu:n",""); printf("%16s1. Create new file.n",""); printf("%16s2. Add information about a machine.n",""); printf("%16s3. Delete old machines.n",""); printf("%16s4. List of machines manufactured within last five years.n",""); printf("%16s5. Copy machines to a txt file by manufacturer. n",""); printf("%10sChoose an operation or zero to quit: ","");scanf("%d",&c); getchar(); switch ©{ case 1:Newfile();break; case 2:Add();break; case 3:Delete();break; case 4:List();break; case 5:ListMachines(); } }while (c!=0); system ("pause"); }

Редактирано 27 май 201313 г. от iskren1993 (преглед на промените)

#include <iostream> #include <string.h> struct Zavod { char Machinename [31]; char Manufacturer [31]; int Year; float Price; }; FILE *fl; char bf [1]; Zavod zavod; char imefl [31]; void Reading (Zavod *zz) { printf ("n"); printf ("Machine name: "); gets (zz->Machinename); printf ("Manufacturer: "); gets (zz->Manufacturer); printf ("Year of manufacture: "); scanf ("%d", &zz->Year); printf ("Price of machine: "); scanf ("%f", &zz->Price); printf ("n"); gets (bf); } void Writing (Zavod zz) { printf ("Machine name: %sn", zz.Machinename); printf ("Manufacturer: %sn", zz.Manufacturer); printf ("Year of manufacture: %dn", zz.Year); printf ("Price: %.2fn", zz.Price); printf ("n"); } int exist(char *ime){ FILE *f = fopen(ime,"r");fclose(f); return f!=NULL; } void Newfile() { char ch; if (exist(imefl)) { printf ("n"); printf("The file already exists! "); printf("Do you want to rewrite it? "); ch=getchar(); if (ch == 'n') return; } fl=fopen(imefl,"w"); fclose(fl); printf("n The file has been created.n"); printf ("n"); } void Add(){ char ch; if (!exist(imefl)) { printf("The file is not created!n");return; } fl=fopen(imefl,"a+b"); do{ Reading(&zavod); fwrite(&zavod,sizeof(zavod),1,fl); printf("Do you want to continue? "); printf ("n"); ch=getchar();getchar(); }while (ch != 'n'); fclose(fl); } void Delete() { FILE *delfl; char old[31]; if (!exist (imefl)) { printf("The file is not created!n");return; } printf ("n"); printf("Machine name: "); gets(old); fl=fopen(imefl,"rb");delfl=fopen("Del"," wb"); fread(&zavod,sizeof(zavod),1,fl); while (!feof(fl)){ if (strcmp(zavod.Machinename,old)!=0) fwrite(&zavod,sizeof(zavod),1,delfl); else printf("The data about machine [%s] has been deleted. n",old); printf ("n"); fread(&zavod,sizeof(zavod),1,fl); } fclose(fl); fclose(delfl); remove(imefl); rename("Del",imefl); } void List(){ int k; int Current; float price=100000; int Helper; if (!exist(imefl)) { printf("The file is not created!n");return; } printf("n"); printf("Current year: "); scanf ("%d", &Current); Helper=Current-5; printf ("n"); fl=fopen(imefl,"rb"); k=0; fread(&zavod,sizeof(zavod),1,fl); while (!feof(fl)){ if ((zavod.Year>Helper) && (zavod.Price>price)) { k++; Writing(zavod);} fread(&zavod,sizeof(zavod),1,fl); } if (k==0) printf("There aren't machines manufactured within five yars n"); fclose(fl); } void ListMachines() { int k=0; FILE *txt; char Transfer [31]; if (!exist(imefl)) { printf("The file is not created!n"); return; } printf ("n"); printf ("Machine manufacturer: "); gets(Transfer); fl=fopen(imefl,"rb"); txt=fopen("New.txt","wt"); fread(&zavod,sizeof(zavod),1,fl); while (!feof(fl)) { if (strcmp (zavod.Manufacturer,Transfer)==0) { fprintf(txt,"%-21s %s %d %fn",zavod.Machinename, zavod.Manufacturer, zavod.Price, zavod.Year); k++; } fread(&zavod,sizeof(zavod),1,fl); } fclose(fl);fclose(txt); if (k==0) printf("There aren't machines manufactured by this firmn"); } int main() { int c; printf("File name: ");gets(imefl); do { printf("%10sMenu:n",""); printf("%16s1. Create new file.n",""); printf("%16s2. Add information about a machine.n",""); printf("%16s3. Delete old machines.n",""); printf("%16s4. List of machines manufactured within last five years.n",""); printf("%16s5. Copy machines to a txt file by manufacturer. n",""); printf("%10sChoose an operation or zero to quit: ","");scanf("%d",&c); getchar(); switch ©{ case 1:Newfile();break; case 2:Add();break; case 3:Delete();break; case 4:List();break; case 5:ListMachines(); } }while (c!=0); system ("pause"); }

SELECT Products.name, OrderedItems.Quantity, OrderedItems.OrderID,Customers.Address
FROM OrderedItems,Products,Customers,Orders
WHERE Products.productID = OrderedItems.itemID AND Orders.orderID = OrderedItems.orderID AND Customers.customerID = Orders.customerID
AND Customers.city = 'Русе';