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

extern void cus_Menu();
int cus_update_agreement( char* tCustomerID,char* tProviderID,char* tPartID,char* tPrice,char* tQuantity,char* tCustSign,char* tProviderSign,char* tProSignDate );


void sign_bussiness()
{
	
	EXEC SQL BEGIN DECLARE SECTION; 
	char CustomerID[10];
	char ProviderID[10];
	char PartID[10];
	char Price[10];
	char Quantity[10];  
	char CustomerSign[4];	
	char CustSignDate[20];
	char ProviderSign[4];
	char ProSignDate[20];
	char sign[4];
	char kon[4];
	EXEC SQL END DECLARE SECTION;
	char t;
	int total_number = 0;
	strcpy(kon,"kon");
	
	
	puts("\t\t以下將對(duì)交易中心推薦的交易進(jìn)行簽定");
	
	EXEC SQL DECLARE sign_bussiness_cursor CURSOR FOR 
		SELECT * FROM Agreement
			WHERE CustomerSign = :kon;  /*ID,Name,Color,Weight,Advicer,Intro*/
   	EXEC SQL OPEN sign_bussiness_cursor;


   	while(1)
   	{
		
   		EXEC SQL WHENEVER NOT FOUND DO break;   		
   		EXEC SQL FETCH sign_bussiness_cursor INTO :CustomerID,:ProviderID,:PartID,:Price,:Quantity,:CustomerSign,:CustSignDate,:ProviderSign,:ProSignDate;
    		 /*puts("!!goto here!!");*/
    		/*printf("%s",CustomerSign);
    		printf("%s",ProviderSign);*/
  		if(!strcmp(CustomerSign,"kon") ){
  			++total_number; 
    			printf("\n本項(xiàng)推薦交易信息為:\n");
			printf("--- --------- ------------------- ---------------------------- ----------\n");
			printf("%-4s%-10s%-10s%-10s%-10s%-10s%-4s%-20s%-4s%-20s\n","N","CustomerID","ProviderID","PartID","Price","Quantity","CusSign","CSignDate","ProSign","PSignDate");
    			printf("--- --------- ------------------- ---------------------------- ----------\n");
   			printf("%-4d%-10s%-10s%-10s%-10s%-10s%-4s%-20s%-4s%-20s\n",total_number,CustomerID,ProviderID,PartID,Price,Quantity,CustomerSign,CustSignDate,ProviderSign,ProSignDate);
   			
   			printf("同意本項(xiàng)交易嗎？(y 同意 n 不同意)\n");
   			fflush(stdin);
   			t = getchar();
   			if(t == 'n' || t == 'N' )
   				strcpy(sign,"no");
   			else	strcpy(sign,"yes");
   			if(cus_update_agreement( CustomerID,ProviderID,PartID,Price,Quantity,sign,ProviderSign,ProSignDate ))
   				printf("ERROR:(sign_business)\n");	
			else{
				printf("本交易已經(jīng)簽署,點(diǎn)擊任意鍵開(kāi)始下一項(xiàng)!");
				getchar();
			}/*else*/   			
		}/*if*/	
   	}/*while*/

   	EXEC SQL CLOSE sign_bussiness_cursor;
   	puts("簽署交易的操作完畢,任意鍵返回上級(jí)菜單\n");
   	getchar();
	cus_Menu();
}/*sign_bussiness()*/

int cus_update_agreement( char* tCustomerID,char* tProviderID,char* tPartID,char* tPrice,char* tQuantity,char* tCustomerSign,char* tProviderSign,char* tProSignDate )
{
	
	EXEC SQL BEGIN DECLARE SECTION; 
	char CustomerID[10];
	char ProviderID[10];
	char PartID[10];
	char Price[10];
	char Quantity[10];  
	char CustomerSign[4];
	char ProviderSign[4];	
	char ProSignDate[20];
	
	EXEC SQL END DECLARE SECTION;
	
	strcpy(CustomerID,tCustomerID);
      	strcpy(ProviderID,tProviderID);
      	strcpy(PartID,tPartID);
      	strcpy(Price,tPrice);
      	strcpy(Quantity,tQuantity);
      	strcpy(CustomerSign,tCustomerSign); 
      	strcpy(ProviderSign,tProviderSign);
      	strcpy(ProSignDate,tProSignDate);
      	     	
      	     		
	EXEC SQL WHENEVER SQLERROR GOTO sqlerr;
	EXEC SQL WHENEVER NOT FOUND GOTO notfound;
	EXEC SQL UPDATE  Agreement SET CustomerID=:CustomerID,ProviderID=:ProviderID,PartID=:PartID,Price=:Price,
				Quantity=:Quantity,CustomerSign=:CustomerSign,CustSignDate=SYSDATE,ProviderSign=:ProviderSign,
				provSignDate= :ProSignDate				
		 WHERE CustomerID=:CustomerID AND ProviderID=:ProviderID AND PartID=:PartID;
	EXEC SQL COMMIT;
	printf( "%s,%s,%s updated.\n",CustomerID,ProviderID,PartID );
	return 0;
	
	notfound:
		printf("WARING:(update_agreement)\n");
		return -1;
	
	sqlerr:
		printf("%70s\n",sqlca.sqlerrm.sqlerrmc);
		printf("ERROR:(update_agreement)");
		EXEC SQL WHENEVER SQLERROR CONTINUE;
		EXEC SQL ROLLBACK;
		return -1;
	
}/*cus_update_agreement( ... )*/