dshandle.c.702

一个公关系统的后台程序

#include <stdio.h>

#include "jetsic.h"
#include "dbfun.h"
#include "dspage.h"


#define QUERY_LEN	256
#define QUERY_MAX	64

#define SQLGAMEBEGIN 	"select game_id,name,filepath,owner_name,sounddefault from game where 1=1 "
#define SQLOWNERBEGIN	"select owner_id,name,filepath from owner where 1=1 "
#define SQLWINEBEGIN	"select wine_id,name,unit,price from wine where 1=1 "
#define SQLGIRLBEGIN	"select girl_id,name,filepath,intro,busy from girl where 1=1 "

#if VERJS
	#define SQLQUERYEND	" limit 400"
#else
	#define SQLQUERYEND	" order by usetimes desc limit 800"
#endif

#if VERJS
	#define SQLQUERYEND2	" limit 200"
#else
	#define SQLQUERYEND2	" order by known_value desc limit 400"
#endif


J8 sql_query[QUERY_LEN];
J8 sql_query_con1[QUERY_MAX];
J8 sql_query_con2[QUERY_MAX];
J8 sql_query_abc;
J8 sql_query_num;

#define MARCO_QUERY(jFieldName,jContext)	\
	memset(sql_query,0,QUERY_LEN);		\
	memset(sql_query_con1,0,QUERY_MAX);	\
	memset(sql_query_con2,0,QUERY_MAX);	\
	sql_query_abc=0;			\
	sql_query_num=0;			\
	sprintf(sql_query_con1," and %s ='%s'\0",jFieldName,jContext);\
	sprintf(sql_query,"%s%s%s\0",SQLGAMEBEGIN,sql_query_con1,SQLQUERYEND);\
	if(dbQuery(sql_query)!=dbSuccess) \
		return 2;


J32 handleGameSort(J8 *context)
{
	MARCO_QUERY("gametype_name",context)
	return pageWriteGame(1);
}

J32 handleGameCode(J8 *context)
{
	sql_query_abc=0;
	sql_query_num=0;
	sprintf(sql_query,"%s and game_id=%s",SQLGAMEBEGIN,context);
	if(dbQuery(sql_query)!=dbSuccess)	
		return 2;
	return pageWriteGame(1);
}

J32 handleGamePop()
{
	sql_query_abc=0;
	sql_query_num=0;
	sprintf(sql_query,"%s order by usetimes desc limit 20",SQLGAMEBEGIN);
	if(dbQuery(sql_query)!=dbSuccess)
		return 2;
	return pageWriteGame(1);

}

J32 handleGame123(J8 *context)
{
	sql_query_abc=0;
	sql_query_num=0;
	memset(sql_query_con1,0,QUERY_MAX);
	memset(sql_query_con2,0,QUERY_MAX);
	if(context[0]==9)
		sprintf(sql_query_con1," and namelength>=%d\0",context[0]);
	else
		sprintf(sql_query_con1," and namelength=%d\0",context[0]);
	sprintf(sql_query,"%s%s%s\0",SQLGAMEBEGIN,sql_query_con1,SQLQUERYEND);
	if(dbQuery(sql_query)!=dbSuccess)
		return 2;
	return pageWriteGame(1);
}

J32 handleGameLang(J8 *context)
{
	MARCO_QUERY("language",context)
	return pageWriteGame(1);
}

J32 handleGameSpell(J8 *context)
{
	memset(sql_query,0,QUERY_LEN);
	sql_query_abc=0;
	sql_query_num=0;
	memset(sql_query_con1,0,QUERY_MAX);
	sprintf(sql_query_con1," and namecode like '%s%%'\0",context);
	sprintf(sql_query,"%s%s%s",
		SQLGAMEBEGIN,sql_query_con1,SQLQUERYEND);
	if(dbQuery(sql_query)!=dbSuccess)
		return 2;
        return pageWriteGame(1);
}


J32 handleGameOther(J8 *context)
{
	MARCO_QUERY("gametype_name",context)
        return pageWriteGame(1);
}

J32 handleGameNew(J8 *context)
{
	MARCO_QUERY("gametype_name",context)
        return pageWriteGame(1);
}

J32 handleGameSinger(J8 *context)
{
	memset(sql_query,0,QUERY_LEN);
	sql_query_abc=0;
        sql_query_num=0;
	sprintf(sql_query_con1," and owner_name like '%%%s%%'\0",context);
	memset(sql_query_con2,0,QUERY_MAX);
	sprintf(sql_query,"%s%s%s\0",SQLGAMEBEGIN,sql_query_con1,SQLQUERYEND);
	if(dbQuery(sql_query)!=dbSuccess)
        	return 2;
         return pageWriteGame(1);
}


J32 handleSinger(J8 *context)
{
	memset(sql_query,0,QUERY_LEN);
	memset(sql_query_con1,0,QUERY_MAX);
	memset(sql_query_con2,0,QUERY_MAX);
	sprintf(sql_query_con1,"%%");
	sprintf(sql_query,"%s and type='歌星' %s\0",SQLOWNERBEGIN,SQLQUERYEND2);
	if(dbQuery2(sql_query)!=dbSuccess)
		return 2;
	return pageWriteSinger(1);
}

J32 handleSingerType(J8 *context)
{
	memset(sql_query,0,QUERY_LEN);
	memset(sql_query_con2,0,QUERY_MAX);
	switch(context[0])
	{
	case 3:
		sprintf(sql_query_con1,"大陆男%%\0");
		break;
	case 4:
		sprintf(sql_query_con1,"大陆女%%\0");
		break;
	case 1:
		sprintf(sql_query_con1,"港台男%%\0");
		break;
	case 2:
		sprintf(sql_query_con1,"港台女%%\0");
		break;
	case 5:
		sprintf(sql_query_con1,"乐队%%\0");
		break;
	case 6:
		sprintf(sql_query_con1,"日韩%%\0");
		break;
	case 7:
		sprintf(sql_query_con1,"欧美%%\0");
		break;
	}
	sprintf(sql_query_con2," and type='歌星' and regionsex like '%s'\0",sql_query_con1);
        sprintf(sql_query,"%s%s%s\0",SQLOWNERBEGIN,sql_query_con2,SQLQUERYEND2);
	if(dbQuery2(sql_query)!=dbSuccess)
        	return 2;
        return pageWriteSinger(1);
 }


J32 handleGirl(J8 *context)
{
	if(strcmp(context,"all")==0)
		sprintf(sql_query,"%s and type='公关'%s\0",
			SQLOWNERBEGIN,SQLQUERYEND2);
	else
		sprintf(sql_query,"%s and namecode like '%s%%' and type='公关'%s%s\0",SQLOWNERBEGIN,context,SQLQUERYEND2);
	if(dbQuery(sql_query)!=dbSuccess)
		return 2;
	return pageWriteGirl(1);
}

J32 handleWine(J8 *context)
{
	if(strcmp(context,"all")==0)
		sprintf(sql_query,"%s and type='%s'\0",SQLWINEBEGIN,context);
	if(dbQuery(sql_query)!=dbSuccess)
		return 2;
	return pageWriteWine(1);
}

J32 handleBill()
{
	#define SQLBILLBEGIN "select b.bill_id,a.name,b.costtotal,b.costagio,b.roomprice,b.costother,b.costother2,b.costtemp,b.timeopen,now(),b.roompriceunit from room as a,bill as b"

	sql_query_num=0;
	sql_query_abc=0;

	sprintf(sql_query_con1," where a.room_id=b.room_id and b.room_id=%d order by b.bill_id desc limit 1",dataGetRoomID());
	sprintf(sql_query,"%s%s",SQLBILLBEGIN,sql_query_con1);
	if(dbQuery(sql_query)!=dbSuccess)
		return 2;
	pageWriteBill();
	return 0;

}

J32 handleABC(J8 *context)
{
	J8 sql_query_tmp[64];
	dataTypeDef dataType=(dataTypeDef)context[0];	
	sql_query_num=0;
	sql_query_abc=context[1];
	if(sql_query_abc=='[')
		sprintf(sql_query_tmp," and namecode like '%%'\0");
	else
		sprintf(sql_query_tmp," and namecode like '%c%%'\0",sql_query_abc);
	
	switch(dataType)
	{
		case dataSinger:
			sprintf(sql_query,"%s and type='歌星' %s%s%s\0",SQLOWNERBEGIN,sql_query_con2,sql_query_tmp,SQLQUERYEND2);
			if(dbQuery2(sql_query)!=dbSuccess)
				return 1;
			return pageWriteSinger(1);
		case dataGirl:
			sprintf(sql_query,"%s and type='公关' %s%s\0",SQLOWNERBEGIN,sql_query_tmp,SQLQUERYEND2);
			if(dbQuery(sql_query)!=dbSuccess)
				return 1;
			return pageWriteGirl(1);
		case dataGame:
			if(strncmp(sql_query_con1," and namecode",10)==0)
				sprintf(sql_query,"%s%s%s\0",SQLGAMEBEGIN,
				sql_query_con1,SQLQUERYEND);
			else
				sprintf(sql_query,"%s%s%s%s%s\0",SQLGAMEBEGIN,
				sql_query_con1,sql_query_con2,sql_query_tmp,
				SQLQUERYEND);
			if(dbQuery(sql_query)!=dbSuccess)
				return 1;
			return pageWriteGame(1);
		case dataWine:
			return 1;
		default:
			return 1;
	}
	return 1;
}

J32 handle123(J8 *context)
{
	J8 sql_query_tmp[64],opeS;
	dataTypeDef dataType=(dataTypeDef)context[0];
	sql_query_num=context[1];
	if(sql_query_num==9)
		opeS='>';
	else
		opeS=' ';
	if(sql_query_num==10)
	{
		opeS='>';
		sql_query_num=0;
	}
	
	if((sql_query_abc==91) || (sql_query_abc==0))
		sprintf(sql_query_tmp," and namelength%c=%d\0",opeS,sql_query_num);	
	else
		sprintf(sql_query_tmp," and namecode like '%c%%' and namelength%c=%d\0",sql_query_abc,opeS,sql_query_num);

	if(dataType==dataGame)
	{
		if(strncmp(sql_query_con1," and namecode",10)==0)
			sprintf(sql_query,"%s%s%s%s\0",SQLGAMEBEGIN,
			sql_query_con1,sql_query_tmp,SQLQUERYEND);
		else
			sprintf(sql_query,"%s%s%s%s%s\0",SQLGAMEBEGIN,
			sql_query_con1,sql_query_con2,
			sql_query_tmp,SQLQUERYEND);
		if(dbQuery(sql_query)!=dbSuccess)
			return 1;
		return pageWriteGame(1);
	}
	return 1;
}

J32 handleUpDown(J8 *context)
{
	dataTypeDef dataType=(dataTypeDef)context[0];
	dataHeadInfo head;
	switch(dataType)
	{
	case dataGame:
	{
		dataGetHeadInfo(&head,0);
		if(context[1]==1 && head.pageCur>1)
			return pageWriteGame(head.pageCur-1);
		
		if(context[1]==2 && head.pageCur<head.pageCount)
			return pageWriteGame(head.pageCur+1);

		return 1;	
	}
	case dataGirl:
	{
		dataGetHeadInfo(&head,0);
		if(context[1]==1 && head.pageCur>1)
			return pageWriteGirl(head.pageCur-1);
		
		if(context[1]==2 && head.pageCur<head.pageCount)
			return pageWriteGirl(head.pageCur+1);
		
		return 1;
	}
	case dataWine:
	{
		dataGetHeadInfo(&head,0);
		if(context[1]==1 && head.pageCur>1)
			return pageWriteWine(head.pageCur-1);
		if(context[1]==2 && head.pageCur<head.pageCount)
			return pageWriteWine(head.pageCur+1);
		return 1;
	}
	case dataSinger:
	{
		dataGetHeadInfo(&head,1);
		if(context[1]==1 && head.pageCur>1)
			return pageWriteSinger(head.pageCur-1);
		if(context[1]==2 && head.pageCur<head.pageCount)
			return pageWriteSinger(head.pageCur+1);

		return 1;
	}
	}
	return 1;
}


J32 handleGame(J8 *context)
{
	J8 sql_str[128];
	sprintf(sql_str,"update game set usetimes=usetimes+1 where game_id=%s",*context);
	dbExecute(sql_str);
}


#if ERRCHECK
void handleDebug1(J8 *context)
{
	J8 sql_str[128];
	sprintf(sql_str,"update game set sounddefault=(sounddefault+1)%2 where game_id=%s",context);
	
	printf("sql_str=%s\n",sql_str);
	dbExecute(sql_str);
}

void handleDebug2(J8 *context)
{
	J8 sql_str[128];
	sprintf(sql_str,"update game set upload=0 where game_id=%s",context);
	printf("sql_str=%s\n",sql_str);
	dbExecute(sql_str);
}

#endif