part_add_request.pc

pro C的一个关于零件交易系统的源码

#include <stdio.h> 
#include <string.h>
#include <stdlib.h>
#include <sqlca.h>
#include <conio.h>
#include <process.h>

extern int query_part_unique(char*);
int insert_AdvicePart(char* tID,char* tName,char* tColor,char* tWeight,char* tIntro,char*);
extern void pro_Menu();

extern char Pro_ID[10];       /*供应商登陆用户名*/
extern char Pro_Password[10]; /*登陆密码*/

void part_add_request()
{
	int partUniqe = 0;
	char PartID[10];
	char PartName[30];
	char Color[10];
	char Weight[10];
	char Intro[100];
	char t;
	
	printf("\n\n\t\t申请添加零件\n\n\n");
      while(1){
	printf("请输入相应信息(注意：请参照零件表，不要输入零件表中已经存在的零件信息)\n");
	printf("零件号>");
	scanf("%s",PartID);
	if( !query_part_unique(PartID) )
		partUniqe = 1;	
	if( partUniqe )	{
		printf("零件名>");
		scanf("%s",PartName);
		printf("颜色>");
		scanf("%s",Color);
		printf("重量>");
		scanf("%s",Weight);
		printf("零件简介>");
		scanf("%s",Intro);
		if( insert_AdvicePart(PartID,PartName,Color,Weight,Intro,Pro_ID))
			printf("ERROR:(part_add_request())\n");
			
		else
			printf("成功添加零件推荐信息\n");
		
	}else{
		printf("此种零件已存在,请推荐其他的零件信息!\n");
	}/*else*/
	
	printf("还有零件要推荐吗?(y/n)");
	fflush(stdin);
	t = getchar();
	if( t != 'n' || t != 'N' )	break;
      }/*while*/
	pro_Menu();
		
}/*part_add_request()*/

int insert_AdvicePart(char* tID,char* tName,char* tColor,char* tWeight,char* tIntro,char* tAdvicer)
{
	EXEC SQL BEGIN DECLARE SECTION; 
	char ID[10];
	char Name[30];
	char Color[10];
	char Weight[10];
	char Intro[100];
	char Advicer[10];
	EXEC SQL END DECLARE SECTION;	
			
	strcpy(ID,tID);
      	strcpy(Name,tName);
      	strcpy(Color,tColor);
      	strcpy(Weight,tWeight);
      	strcpy(Intro,tIntro);
      	strcpy(Advicer,tAdvicer);

	EXEC SQL WHENEVER SQLERROR GOTO error;
	EXEC SQL INSERT INTO PartAdvice
		VALUES(:ID,:Name,:Color,:Weight,:Intro,:Advicer);
	EXEC SQL COMMIT;	
	return 0;
error:
	printf("ERROR:(insert_part)");
	EXEC SQL WHENEVER SQLERROR CONTINUE;    
   	printf("\nORACLE error detected:\n"); 
   	printf("\n%.70s\n",sqlca.sqlerrm.sqlerrmc); 
   	EXEC SQL ROLLBACK; /*RELEASE; */
   	return -1; 	
}/*insert_part()*/