?? main.cpp
字號:
}
var=pRs->GetCollect(row_num[choice][i]);
i++;
if(var.vt!=VT_NULL)
{
p->SC_GRADE=atof((char *)_bstr_t(var));
}
var=pRs->GetCollect(row_num[choice][i]);
i++;
if(var.vt!=VT_NULL)
{
sprintf(p->TNO,"%s",(char *)_bstr_t(var));
}
var=pRs->GetCollect(row_num[choice][i]);
i++;
if(var.vt!=VT_NULL)
{
sprintf(p->SC_DATE,"%s",(char *)_bstr_t(var));
}
q->next=p;
q=p;
pRs->MoveNext();
}
break;
}
//從講授表中讀取數據
case 10:
{
TC *p,*q;
q=all->tchead;
while(!pRs->EndOfFile)
{
i=1;
p=(TC *)malloc(sizeof(TC));
p->next=NULL;
var=pRs->GetCollect(row_num[choice][i]);
i++;
if(var.vt!=VT_NULL)
{
sprintf(p->TNO,"%s",(char *)_bstr_t(var));
}
var=pRs->GetCollect(row_num[choice][i]);
i++;
if(var.vt!=VT_NULL)
{
sprintf(p->CO_NO,"%s",(char *)_bstr_t(var));
}
var=pRs->GetCollect(row_num[choice][i]);
i++;
if(var.vt!=VT_NULL)
{
sprintf(p->TC_T_DATETIME,"%s",(char *)_bstr_t(var));
}
var=pRs->GetCollect(row_num[choice][i]);
i++;
if(var.vt!=VT_NULL)
{
sprintf(p->TC_T_ADDRESS,"%s",(char *)_bstr_t(var));
}
var=pRs->GetCollect(row_num[choice][i]);
i++;
if(var.vt!=VT_NULL)
{
sprintf(p->TC_E_DATETIME,"%s",(char *)_bstr_t(var));
}
else
{
sprintf(p->TC_E_DATETIME,"");
}
var=pRs->GetCollect(row_num[choice][i]);
i++;
if(var.vt!=VT_NULL)
{
sprintf(p->TC_E_ADDRESS,"%s",(char *)_bstr_t(var));
}
else
{
sprintf(p->TC_E_ADDRESS,"");
}
q->next=p;
q=p;
pRs->MoveNext();
}
break;
}
//從參加活動表中讀取數據
case 11:
{
JOINACTIVITY *p,*q;
q=all->joinactivityhead;
while(!pRs->EndOfFile)
{
i=1;
p=(JOINACTIVITY *)malloc(sizeof(JOINACTIVITY));
p->next=NULL;
var=pRs->GetCollect(row_num[choice][i]);
i++;
if(var.vt!=VT_NULL)
{
sprintf(p->ANO,"%s",(char *)_bstr_t(var));
}
var=pRs->GetCollect(row_num[choice][i]);
i++;
if(var.vt!=VT_NULL)
{
p->J_GRADE=atof((char *)_bstr_t(var));
}
var=pRs->GetCollect(row_num[choice][i]);
i++;
if(var.vt!=VT_NULL)
{
sprintf(p->J_OTHER,"%s",(char *)_bstr_t(var));
}
var=pRs->GetCollect(row_num[choice][i]);
i++;
if(var.vt!=VT_NULL)
{
sprintf(p->SNO,"%s",(char *)_bstr_t(var));
}
q->next=p;
q=p;
pRs->MoveNext();
}
break;
}
//從登記表中讀取數據
case 12:
{
LOGON *p,*q;
q=all->logonhead;
while(!pRs->EndOfFile)
{
i=1;
p=(LOGON *)malloc(sizeof(LOGON));
p->next=NULL;
var=pRs->GetCollect(row_num[choice][i]);
i++;
if(var.vt!=VT_NULL)
{
sprintf(p->RNO,"%s",(char *)_bstr_t(var));
}
var=pRs->GetCollect(row_num[choice][i]);
i++;
if(var.vt!=VT_NULL)
{
sprintf(p->SNO,"%s",(char *)_bstr_t(var));
}
var=pRs->GetCollect(row_num[choice][i]);
i++;
if(var.vt!=VT_NULL)
{
sprintf(p->L_DATE,"%s",(char *)_bstr_t(var));
}
q->next=p;
q=p;
pRs->MoveNext();
}
break;
}
//從學校活動表中讀取數據
case 13:
{
ACTIVITY *p,*q;
q=all->activityhead;
while(!pRs->EndOfFile)
{
i=1;
p=(ACTIVITY *)malloc(sizeof(ACTIVITY));
p->next=NULL;
var=pRs->GetCollect(row_num[choice][i]);
i++;
if(var.vt!=VT_NULL)
{
sprintf(p->ANO,"%s",(char *)_bstr_t(var));
}
var=pRs->GetCollect(row_num[choice][i]);
i++;
if(var.vt!=VT_NULL)
{
sprintf(p->AN,"%s",(char *)_bstr_t(var));
}
var=pRs->GetCollect(row_num[choice][i]);
i++;
if(var.vt!=VT_NULL)
{
sprintf(p->A_DATE,"%s",(char *)_bstr_t(var));
}
q->next=p;
q=p;
pRs->MoveNext();
}
break;
}
//從寢室表中讀取數據
case 14:
{
CHAMBER *p,*q;
q=all->chamberhead;
while(!pRs->EndOfFile)
{
i=1;
p=(CHAMBER *)malloc(sizeof(CHAMBER));
p->next=NULL;
var=pRs->GetCollect(row_num[choice][i]);
i++;
if(var.vt!=VT_NULL)
{
sprintf(p->CH_NO,"%s",(char *)_bstr_t(var));
}
var=pRs->GetCollect(row_num[choice][i]);
i++;
if(var.vt!=VT_NULL)
{
sprintf(p->CH_ADDRESS,"%s",(char *)_bstr_t(var));
}
var=pRs->GetCollect(row_num[choice][i]);
i++;
if(var.vt!=VT_NULL)
{
p->CH_NUM=atoi((char *)_bstr_t(var));
}
q->next=p;
q=p;
pRs->MoveNext();
}
break;
}
default:break;
}
pRs->Close();
pRs.Release();
pConn->Close();
pConn.Release();
}
catch (_com_error)
{
if(choice==14)
{
printf("\n\n由于數據庫不存在或格式錯誤,");
printf("\n\n導致連接到數據庫失敗!程序即將關閉!\n\n");
system("pause");
exit(1);
}
}
}
/*-----------------------------------------------------------------*
*函數: ExecuteSQL() *
*參數: 字符數組 *
*作用: 執行相關SQL語句命令 *
*返回： 無 *
*-----------------------------------------------------------------*/
void ExecuteSQL(char cmd[200])
{
_ConnectionPtr pConn("ADODB.Connection");
pConn->ConnectionTimeout=5;
//建立.udl文件后打開可得到
try
{
pConn->Open(db[0],"","",adConnectUnspecified);
_CommandPtr pCmd("ADODB.Command");
pCmd->ActiveConnection=pConn;
pCmd->CommandText=cmd;
pCmd->Execute(NULL,NULL,adCmdText);
pConn->Close();
pConn.Release();
}
catch (_com_error)
{
printf("\n\n由于數據庫不存在或格式錯誤,");
printf("\n\n導致連接到數據庫失敗!程序即將關閉!\n\n");
system("pause");
exit(1);
}
}
/*-----------------------------------------------------------------*
*函數: Menu3() *
*參數: 表結構指針 *
*作用: 顯示數據查詢菜單 *
*返回： 無 *
*-----------------------------------------------------------------*/
void Menu3(sys *all)
{
int i,_exit=0,quit=0,choice[3],Find[3],column[13]={0},table;//column用1,0判斷相應的列是否顯示
sys tmp;
do
{
system("cls");
_exit=0;
printf("c.數據查詢");
printf("\n\n");
for(i=0;i<15;i++)
printf("\t%d.%s\n",i,c_txt[i]);
printf("\n\n請選擇(0-14):");
choice[0]=Force();
while(choice[0]<0||choice[0]>14)
{
printf("\n\n輸入錯誤，請重輸:");
choice[0]=Force();
}
table=choice[0];
switch(choice[0])
{
case 0:
{
quit=1;
break;
}
case 1:
{
sys f_more[100];
int num=0,way;//num記錄記錄的個數
char ch[50];
Find[1]=table;
printf("\n請選擇查詢方式:1.姓名 2.學號\n\n");
way=Force();
if(way==1)
{
strcpy(ch,Input(Find,2,all).str1);
findmore(Find,ch,all,f_more);
}
else if(way==2)
{
strcpy(ch,Input(Find,1,all).str1);
f_more[0]=find(Find,ch,ch,all);
f_more[1].studenthead=NULL;
}
else
{
break;
}
if(f_more[0].studenthead==NULL)
{
printf("\n未找到%s!\n\n",ch);
system("pause");
break;
}
do
{
system("cls");
printf("1.學生綜合情況\n");
printf("2.校運動會\n");
printf("0.返回\n\n");
printf("\n\n請選擇(0-2):");
choice[2]=Force();
while(choice[2]<0||choice[2]>2)
{
printf("\n\n輸入錯誤，請重輸:");
choice[2]=Force();
}
if(choice[2]==0)
{
_exit=1;
break;
}
printf("\n\n");
num=0;
while(f_more[num].studenthead!=NULL)
{
printf("%d.%s\t\t",num+1,f_more[num].studenthead->SN);
num++;
}
printf("\n\n請選擇要顯示的學生(1-%d):",num);
choice[1]=Force();
while(choice[1]<1||choice[1]>num)
{
printf("\n\n輸入錯誤，請重輸:");
choice[1]=Force();
}
printf("\n\n\t\t");
switch(choice[2])
{
case 0:_exit=1;break;
case 1:
{
strcpy(ch,f_more[choice[1]-1].studenthead->SNO);
tmp=f_more[choice[1]-1];
//姓名
system("cls");
printf("%s:",row_txt[table][2]);
column[2]=1;
if(tmp.studenthead!=NULL)
{
display(table,column,tmp);
}
column[2]=0;
printf("\n\n\n基本情況:\n\n\t\t");
for(i=1;i<=9;i++)
{
if(i==2) continue;
printf("%10s:",row_txt[table][i]);
column[i]=1;
if(tmp.studenthead!=NULL)
{
display(table,column,tmp);
}
column[i]=0;
printf("\n\t\t");
}
Find[1]=table+5;
tmp=find(Find,tmp.studenthead->CNO,tmp.studenthead->CNO,all);
printf("\n\n\n所在班級情況:\n\n\t\t");
for(i=1;i<=5;i++)
{
printf("%10s:",row_txt[table+5][i]);
column[i]=1;
if(tmp.classhead!=NULL)
{
display(table+5,column,tmp);
}
column[i]=0;
printf("\n\t\t");
}
Find[1]=table;
tmp=find(Find,ch,ch,all);
Find[1]=0;
system("pause");
//姓名
system("cls");
printf("%s:",row_txt[table][2]);
column[2]=1;
if(tmp.studenthead!=NULL)
{
display(table,column,tmp);
}
column[2]=0;
Find[1]=table+3;
tmp=find(Find,tmp.studenthead->SP_NO,tmp.studenthead->SP_NO,all);
printf("\n\n\n所在專業情況:\n\n\t\t");
for(i=1;i<=4;i++)
{
printf("%10s:",row_txt[table+3][i]);
column[i]=1;
if(tmp.specialityhead!=NULL)
{
display(table+3,column,tmp);
}
column[i]=0;
printf("\n\t\t");
}
Find[1]=table+4;
tmp=find(Find,tmp.specialityhead->DNO,tmp.specialityhead->DNO,all);
printf(" 所屬系部:");
column[2]=1;
if(tmp.departmenthead!=NULL)
{
display(table+4,column,tmp);
}
column[2]=0;
Find[1]=table;
tmp=find(Find,ch,ch,all);
Find[1]=table+13;
tmp=find(Fin?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -