?? query.cpp
字號:
if((i>=621301 &&i<=621400) || i>=621451 && i<=621455) wei=27.00;
else wei=24.00;
sprintf(str,"%07ld",i);
table_pi->Append();
table_piCehao->Value= str;
table_piPi->Value= wei;
table_pi->Post();
}
}
//---------------------------------------------------------------------------
void __fastcall Tform_query::Button1Click(TObject *Sender)
{
/* char ch[10];
float wei;
long i;
table_pi->Active=false;
table_pi->EmptyTable();
table_pi->Active=true;
for(i=621301;i<=621455;i++){
if(i>=621401 && i<=621450) wei=24.00;
else wei=27.00;
sprintf(ch,"%07ld",i);
table_pi->Append();
table_piCehao->Value=ch;
table_piPi->Value=wei;
table_pi->Post();
}*/
}
//---------------------------------------------------------------------------
void __fastcall Tform_query::print_zjClick(TObject *Sender)
{
//FILE *prn ;
char title[60];
int min=65535,max=0,j=0;
float total,total_jin=0;
AnsiString temp;
LPSYSTEMTIME lpst=new SYSTEMTIME;
if(bd.yh_mode==YH_JG || bd.yh_mode==YH_JGNEW){
strcpy(title,"濟南鋼鐵股份公司物資計量單(二)(火車)");
if(prn!=NULL && tj_cnt>0){
fprintf(prn," \n\n%70s\n\n",title);
GetLocalTime(lpst);
fprintf(prn,"統計時間:%4d-%02d-%02d %02d:%02d 編碼:RP4-2-J-56\n",lpst->wYear,lpst->wMonth,lpst->wDay,lpst->wHour,lpst->wMinute);
fprintf(prn,"┏─┳─┳──┳────────┳──┳──┳────┳────┳───┳───┳───┳───┳──┓\n");
fprintf(prn,"│"); fprintf(prn,"%2s","序"); fprintf(prn,"│"); fprintf(prn,"%2s","爐");
fprintf(prn,"│"); fprintf(prn,"%4s","爐次"); fprintf(prn,"│"); fprintf(prn,"%12s%4s","計量時間","");
fprintf(prn,"│"); fprintf(prn,"%4s","罐號"); fprintf(prn,"│"); fprintf(prn,"%4s","物資");
fprintf(prn,"│"); fprintf(prn,"%6s%2s","供貨",""); fprintf(prn,"│"); fprintf(prn,"%6s%2s","收貨","");
fprintf(prn,"│"); fprintf(prn,"%5s%1s","毛重",""); fprintf(prn,"│"); fprintf(prn,"%5s%1s","皮重","");
fprintf(prn,"│"); fprintf(prn,"%5s%1s","凈重",""); fprintf(prn,"│"); fprintf(prn,"%5s%1s","凈重","");
fprintf(prn,"│"); fprintf(prn,"%4s","速度"); fprintf(prn,"│\n");
fprintf(prn,"│"); fprintf(prn,"%2s","號"); fprintf(prn,"│"); fprintf(prn,"%2s","號");
fprintf(prn,"│"); fprintf(prn,"%4s",""); fprintf(prn,"│"); fprintf(prn,"%16s","");
fprintf(prn,"│"); fprintf(prn,"%4s",""); fprintf(prn,"│"); fprintf(prn,"%4s","品名");
fprintf(prn,"│"); fprintf(prn,"%6s%2s","單位",""); fprintf(prn,"│"); fprintf(prn,"%6s%2s","單位","");
fprintf(prn,"│"); fprintf(prn,"%6s",""); fprintf(prn,"│"); fprintf(prn,"%6s","");
fprintf(prn,"│"); fprintf(prn,"%6s","(罐)"); fprintf(prn,"│"); fprintf(prn,"%6s","(爐)");
fprintf(prn,"│"); fprintf(prn,"%4s",""); fprintf(prn,"│\n");
fprintf(prn,"│"); fprintf(prn,"%2s",""); fprintf(prn,"│"); fprintf(prn,"%2s","");
fprintf(prn,"│"); fprintf(prn,"%4s",""); fprintf(prn,"│"); fprintf(prn,"%16s","");
fprintf(prn,"│"); fprintf(prn,"%4s",""); fprintf(prn,"│"); fprintf(prn,"%4s","");
fprintf(prn,"│"); fprintf(prn,"%8s",""); fprintf(prn,"│"); fprintf(prn,"%8s","");
fprintf(prn,"│"); fprintf(prn,"%6s",""); fprintf(prn,"│"); fprintf(prn,"%6s","");
fprintf(prn,"│"); fprintf(prn,"%6s","( t)"); fprintf(prn,"│"); fprintf(prn,"%6s","( t)");
fprintf(prn,"│"); fprintf(prn,"%4s",""); fprintf(prn,"│\n");
for(table_tj->First();!table_tj->Eof;table_tj->Next()){
temp=table_tj->FindField("Bak2")->AsString;
if(StrToInt(temp)<min) min=StrToInt(temp);
if(StrToInt(temp)>max) max=StrToInt(temp);
}
for(int i=min; i<min+8; i++){
Query1->SQL->Clear();
AnsiString sql=("select * from 'c:\\cb4\\wingdh\\db\\tj.db' where Bak2=");
sql+="'"; sql+=IntToStr(i); sql+="'";
Query1->SQL->Add(sql);
Query1->Active=true;
Query1->First(); total=0;
fprintf(prn,"┣─╋─╋──╋────────╋──╋──╋────╋────╋───╋───╋───╋───╋──┫\n");
fprintf(prn,"│"); fprintf(prn,"%2d",++j); fprintf(prn,"│"); fprintf(prn,"%2s",Query1->FindField("Bak3")->AsString.c_str());
fprintf(prn,"│"); fprintf(prn,"%4s",Query1->FindField("Bak2")->AsString.c_str()); fprintf(prn,"│"); fprintf(prn,"%16s",Query1->FindField("Tm")->AsString.c_str());
fprintf(prn,"│"); fprintf(prn,"%4s",Query1->FindField("Bak1")->AsString.c_str()); fprintf(prn,"│"); fprintf(prn,"%4s",Query1->FindField("Name")->AsString.c_str());
fprintf(prn,"│"); fprintf(prn,"%8s",Query1->FindField("Send")->AsString.c_str()); fprintf(prn,"│"); fprintf(prn,"%8s",Query1->FindField("Rec")->AsString.c_str());
fprintf(prn,"│"); fprintf(prn,"%6s",Query1->FindField("Mao")->AsString.c_str()); fprintf(prn,"│"); fprintf(prn,"%6s",Query1->FindField("Pi")->AsString.c_str());
fprintf(prn,"│"); fprintf(prn,"%6s",Query1->FindField("Jin")->AsString.c_str()); fprintf(prn,"│"); fprintf(prn,"%6s","");
fprintf(prn,"│"); fprintf(prn,"%4s",Query1->FindField("Spd")->AsString.c_str()); fprintf(prn,"│\n");
total+=Query1->FindField("Jin")->AsFloat;
Query1->Next();
if(!Query1->Eof){
fprintf(prn,"┣─┫ │ ┣────────╋──╋──╋────╋────╋───╋───╋───┫ ┣──┫\n");
fprintf(prn,"│"); fprintf(prn,"%2d",++j); fprintf(prn,"│"); fprintf(prn,"%2s","");
fprintf(prn,"│"); fprintf(prn,"%4s",""); fprintf(prn,"│"); fprintf(prn,"%16s",Query1->FindField("Tm")->AsString.c_str());
fprintf(prn,"│"); fprintf(prn,"%4s",Query1->FindField("Bak1")->AsString.c_str()); fprintf(prn,"│"); fprintf(prn,"%4s",Query1->FindField("Name")->AsString.c_str());
fprintf(prn,"│"); fprintf(prn,"%8s",Query1->FindField("Send")->AsString.c_str()); fprintf(prn,"│"); fprintf(prn,"%8s",Query1->FindField("Rec")->AsString.c_str());
fprintf(prn,"│"); fprintf(prn,"%6s",Query1->FindField("Mao")->AsString.c_str()); fprintf(prn,"│"); fprintf(prn,"%6s",Query1->FindField("Pi")->AsString.c_str());
fprintf(prn,"│"); fprintf(prn,"%6s",Query1->FindField("Jin")->AsString.c_str());
total+=Query1->FindField("Jin")->AsFloat; fprintf(prn,"│"); fprintf(prn,"%6.2f",total);
fprintf(prn,"│"); fprintf(prn,"%4s",Query1->FindField("Spd")->AsString.c_str()); fprintf(prn,"│\n");
total_jin+=total;
}
else{
fprintf(prn,"┣─┫ │ ┣────────╋──╋──╋────╋────╋───╋───╋───┫ ┣──┫\n");
fprintf(prn,"│"); fprintf(prn,"%2s",""); fprintf(prn,"│"); fprintf(prn,"%2s","");
fprintf(prn,"│"); fprintf(prn,"%4s",""); fprintf(prn,"│"); fprintf(prn,"%16s","");
fprintf(prn,"│"); fprintf(prn,"%4s",""); fprintf(prn,"│"); fprintf(prn,"%4s","");
fprintf(prn,"│"); fprintf(prn,"%8s",""); fprintf(prn,"│"); fprintf(prn,"%8s","");
fprintf(prn,"│"); fprintf(prn,"%6s",""); fprintf(prn,"│"); fprintf(prn,"%6s","");
fprintf(prn,"│"); fprintf(prn,"%6s","");
fprintf(prn,"│"); fprintf(prn,"%6.2f",total);
fprintf(prn,"│"); fprintf(prn,"%4s",""); fprintf(prn,"│\n");
total_jin+=total;
} //else
}//for i=1;i<8
fprintf(prn,"┗─┻─┻──┻────────┻──┻──┻────┻────┻───┻───┻───┻───┻──┛\n");
ShowMessage("換頁!!!");
fprintf(prn," \n\n%70s\n\n",title);
GetLocalTime(lpst);
fprintf(prn,"統計時間:%4d-%02d-%02d %02d:%02d 編碼:RP4-2-J-56\n",lpst->wYear,lpst->wMonth,lpst->wDay,lpst->wHour,lpst->wMinute);
fprintf(prn,"┏─┳─┳──┳────────┳──┳──┳────┳────┳───┳───┳───┳───┳──┓\n");
fprintf(prn,"│"); fprintf(prn,"%2s","序"); fprintf(prn,"│"); fprintf(prn,"%2s","爐");
fprintf(prn,"│"); fprintf(prn,"%4s","爐次"); fprintf(prn,"│"); fprintf(prn,"%12s%4s","計量時間","");
fprintf(prn,"│"); fprintf(prn,"%4s","罐號"); fprintf(prn,"│"); fprintf(prn,"%4s","物資");
fprintf(prn,"│"); fprintf(prn,"%6s%2s","供貨",""); fprintf(prn,"│"); fprintf(prn,"%6s%2s","收貨","");
fprintf(prn,"│"); fprintf(prn,"%5s%1s","毛重",""); fprintf(prn,"│"); fprintf(prn,"%5s%1s","皮重","");
fprintf(prn,"│"); fprintf(prn,"%5s%1s","凈重",""); fprintf(prn,"│"); fprintf(prn,"%5s%1s","凈重","");
fprintf(prn,"│"); fprintf(prn,"%4s","速度"); fprintf(prn,"│\n");
fprintf(prn,"│"); fprintf(prn,"%2s","號"); fprintf(prn,"│"); fprintf(prn,"%2s","號");
fprintf(prn,"│"); fprintf(prn,"%4s",""); fprintf(prn,"│"); fprintf(prn,"%16s","");
fprintf(prn,"│"); fprintf(prn,"%4s",""); fprintf(prn,"│"); fprintf(prn,"%4s","品名");
fprintf(prn,"│"); fprintf(prn,"%6s%2s","單位",""); fprintf(prn,"│"); fprintf(prn,"%6s%2s","單位","");
fprintf(prn,"│"); fprintf(prn,"%6s",""); fprintf(prn,"│"); fprintf(prn,"%6s","");
fprintf(prn,"│"); fprintf(prn,"%6s","(罐)"); fprintf(prn,"│"); fprintf(prn,"%6s","(爐)");
fprintf(prn,"│"); fprintf(prn,"%4s",""); fprintf(prn,"│\n");
fprintf(prn,"│"); fprintf(prn,"%2s",""); fprintf(prn,"│"); fprintf(prn,"%2s","");
fprintf(prn,"│"); fprintf(prn,"%4s",""); fprintf(prn,"│"); fprintf(prn,"%16s","");
fprintf(prn,"│"); fprintf(prn,"%4s",""); fprintf(prn,"│"); fprintf(prn,"%4s","");
fprintf(prn,"│"); fprintf(prn,"%8s",""); fprintf(prn,"│"); fprintf(prn,"%8s","");
fprintf(prn,"│"); fprintf(prn,"%6s",""); fprintf(prn,"│"); fprintf(prn,"%6s","");
fprintf(prn,"│"); fprintf(prn,"%6s","( t)"); fprintf(prn,"│"); fprintf(prn,"%6s","( t)");
fprintf(prn,"│"); fprintf(prn,"%4s",""); fprintf(prn,"│\n");
for(int i=min+8; i<max+1; i++){
Query1->SQL->Clear();
AnsiString sql=("select * from 'c:\\cb4\\wingdh\\db\\tj.db' where Bak2=");
sql+="'"; sql+=IntToStr(i); sql+="'";
Query1->SQL->Add(sql);
Query1->Active=true;
total=0.0;Query1->First();
fprintf(prn,"┣─╋─╋──╋────────╋──╋──╋────╋────╋───╋───╋───╋───╋──┫\n");
fprintf(prn,"│"); fprintf(prn,"%2d",++j); fprintf(prn,"│"); fprintf(prn,"%2s",Query1->FindField("Bak3")->AsString.c_str());
fprintf(prn,"│"); fprintf(prn,"%4s",Query1->FindField("Bak2")->AsString.c_str()); fprintf(prn,"│"); fprintf(prn,"%16s",Query1->FindField("Tm")->AsString.c_str());
fprintf(prn,"│"); fprintf(prn,"%4s",Query1->FindField("Bak1")->AsString.c_str()); fprintf(prn,"│"); fprintf(prn,"%4s",Query1->FindField("Name")->AsString.c_str());
fprintf(prn,"│"); fprintf(prn,"%8s",Query1->FindField("Send")->AsString.c_str()); fprintf(prn,"│"); fprintf(prn,"%8s",Query1->FindField("Rec")->AsString.c_str());
fprintf(prn,"│"); fprintf(prn,"%6s",Query1->FindField("Mao")->AsString.c_str()); fprintf(prn,"│"); fprintf(prn,"%6s",Query1->FindField("Pi")->AsString.c_str());
fprintf(prn,"│"); fprintf(prn,"%6s",Query1->FindField("Jin")->AsString.c_str()); fprintf(prn,"│"); fprintf(prn,"%6s","");
fprintf(prn,"│"); fprintf(prn,"%4s",Query1->FindField("Spd")->AsString.c_str()); fprintf(prn,"│\n");
total+=Query1->FindField("Jin")->AsFloat;
Query1->Next();
if(!Query1->Eof){
fprintf(prn,"┣─┫ │ ┣────────╋──╋──╋────╋────╋───╋───╋───┫ ┣──┫\n");
fprintf(prn,"│"); fprintf(prn,"%2d",++j); fprintf(prn,"│"); fprintf(prn,"%2s","");
fprintf(prn,"│"); fprintf(prn,"%4s",""); fprintf(prn,"│"); fprintf(prn,"%16s",Query1->FindField("Tm")->AsString.c_str());
fprintf(prn,"│"); fprintf(prn,"%4s",Query1->FindField("Bak1")->AsString.c_str()); fprintf(prn,"│"); fprintf(prn,"%4s",Query1->FindField("Name")->AsString.c_str());
fprintf(prn,"│"); fprintf(prn,"%8s",Query1->FindField("Send")->AsString.c_str()); fprintf(prn,"│"); fprintf(prn,"%8s",Query1->FindField("Rec")->AsString.c_str());
fprintf(prn,"│"); fprintf(prn,"%6s",Query1->FindField("Mao")->AsString.c_str()); fprintf(prn,"│"); fprintf(prn,"%6s",Query1->FindField("Pi")->AsString.c_str());
fprintf(prn,"│"); fprintf(prn,"%6s",Query1->FindField("Jin")->AsString.c_str());
total+=Query1->FindField("Jin")->AsFloat; fprintf(prn,"│"); fprintf(prn,"%6.2f",total);
fprintf(prn,"│"); fprintf(prn,"%4s",Query1->FindField("Spd")->AsString.c_str()); fprintf(prn,"│\n");
total_jin+=total;
}
else{
fprintf(prn,"┣─┫ │ ┣────────╋──╋──╋────╋────╋───╋───╋───┫ ┣──┫\n");
fprintf(prn,"│"); fprintf(prn,"%2s",""); fprintf(prn,"│"); fprintf(prn,"%2s","");
fprintf(prn,"│"); fprintf(prn,"%4s",""); fprintf(prn,"│"); fprintf(prn,"%16s","");
fprintf(prn,"│"); fprintf(prn,"%4s",""); fprintf(prn,"│"); fprintf(prn,"%4s","");
fprintf(prn,"│"); fprintf(prn,"%8s",""); fprintf(prn,"│"); fprintf(prn,"%8s","");
fprintf(prn,"│"); fprintf(prn,"%6s",""); fprintf(prn,"│"); fprintf(prn,"%6s","");
fprintf(prn,"│"); fprintf(prn,"%6s","");
fprintf(prn,"│"); fprintf(prn,"%6.2f",total);
fprintf(prn,"│"); fprintf(prn,"%4s",""); fprintf(prn,"│\n");
total_jin+=total;
} //else
}//for i=8;i<16
fprintf(prn,"┣─┻─╋──┻────────┻──┻──┻────┻────┻───┻───┻───┻───┻──┫\n");
fprintf(prn,"│"); fprintf(prn,"%-6s","合計"); fprintf(prn,"│"); fprintf(prn,"%10s%10.2f%2s%70s","30 罐",total_jin,"噸",""); fprintf(prn,"│\n");
fprintf(prn,"┗───┻──────────────────────────────────────────────┛\n");
if(bd.yh_mode==YH_JG ){
fprintf(prn,"%12s%40s%12s\n","六#軌道衡","","當班計量員");
}else{
fprintf(prn,"%12s%40s%12s\n","七#軌道衡","","當班計量員");
}
} //if prn!=null
} //if yh==jg
else{
strcpy(title,bd.name);
strcat(title,"軌道衡統計報告單(總計結果)");
if(prn!=NULL && tj_cnt>0){
fprintf(prn," \n\n\n%s\n",title);
fprintf(prn,"----------------------------------------------\n");
fprintf(prn," 起始時間: %s\n",Edit1->Text.c_str());
fprintf(prn," 終止時間: %s\n",Edit2->Text.c_str());
if(CheckBox3->Checked==TRUE)
fprintf(prn," 車 號: %s\n",Edit3->Text.c_str());
if(CheckBox4->Checked==TRUE)
fprintf(prn," 貨 名: %s\n",Edit4->Text.c_str());
if(CheckBox5->Checked==TRUE)
fprintf(prn," 發貨單位: %s\n",Edit5->Text.c_str());
if(CheckBox6->Checked==TRUE)
fprintf(prn," 收貨單位: %s\n",Edit6->Text.c_str());
fprintf(prn," 毛重總計:%10.2f噸\n",total_mao);
fprintf(prn," 皮重總計:%10.2f噸\n",total_pi);
fprintf(prn," 凈重總計:%10.2f噸\n",total_jin);
if(bd.yh_mode==YH_TG){
fprintf(prn," 扣渣后總計:%10.2f噸\n",total_yq);
}
fprintf(prn,"----------------------------------------------\n\n\n\n");
//fclose(prn);
} //if prn
}//else
delete lpst;
}
//---------------------------------------------------------------------------
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -