Q&A

  • ▶▶▶▶▶고수님들만 보십시요....!!!◀◀◀◀◀
전체적인 코드내용입니다.

제가 하고 싶은건 "kubun_sCB"과"kubun_eCB"을"date_sDTPicker(DateTimePicker)"와

"date_eDTPicker(DateTimePicker)"바꿔서 프로그램을 짜고 싶은데 제가 한 방법은

"kubun_sCB"과"kubun_eCB"을"date_sDTPicker(DateTimePicker)"와"date_eDTPicker(DateTimePicker)"로 전부 바꿨더니 여러개의 에러가 발생합니다.

제가 생각하기엔 DateTimePicker의 코드에 대한 내용이 잘못된거 같은데....

여기서는 어떻게 해야하는지 궁금해서요...?

초보라 잘모르니 자세하게 설명좀 부탁합니다.

(p.s 여기서 FormCreate의 "skubun_code_select","ekubun_code_select"은

"kubun_sCB"와"kubun_eCB"의 이벤트 체인지를 바꿔서 임의로 작성한것임 ...)

*********************************************************************************

procedure Tah7200_f.FormClose(Sender: TObject; var Action: TCloseAction);

begin

Action := caFree;

end;



procedure Tah7200_f.FormCreate(Sender: TObject);

begin

sitem_code_select;

eitem_code_select;

skubun_code_select;

ekubun_code_select;

item_sCB.ItemIndex := -1;

item_eCB.ItemIndex := -1;

kubun_sCB.ItemIndex := -1;

kubun_eCB.ItemIndex := -1;

item_sCB.Text := ' ';

//kubun_sCB.Text := ' ';

end;



procedure Tah7200_f.PrintBitBtnClick(Sender: TObject);

begin

if MessageDlg(' 정말로 인쇄 합니까.?', mtConfirmation, [mbYes, mbNo], 0) = mrYes then

S_QRlabel.Caption := item_sCB.Text;

E_QRlabel.Caption := item_eCB.Text;

S1_QRlabel.Caption := kubun_sCB.Text;

E1_QRlabel.Caption := kubun_eCB.Text;



Query1.Close;

Query1.SQL.clear;

Query1.SQL.Add (' select siot_item, siot_kubun, mast_modl, mast_name, ');

Query1.SQL.Add (' siot_diwol, siot_dinpt, siot_doupt, siot_stok');

Query1.SQL.Add (' from misiot,mimast ');

Query1.SQL.Add (' where ((siot_item = mast_item(+)) and ');

Query1.SQL.Add (' (siot_item between '''+item_sCB.Text+''' and '''+item_eCB.Text+''') and ');

Query1.SQL.Add (' (siot_kubun between '''+kubun_sCB.Text+''' and '''+kubun_eCB.Text+''')) ');

Query1.SQL.Add (' order by siot_item, siot_kubun ');

Query1.open;



if Query1.RecordCount <> 0 then

MesgStatusBar.SimpleText := 'MESG:' + IntToStr(Query1.RecordCount) + ' 건 인쇄완료 하였습니다.!!'

else MesgStatusBar.SimpleText := 'MESG:인쇄할 자료가 없습니다.!!';



QuickRep1.Preview;



end;



procedure Tah7200_f.sitem_code_select;

begin

item_sCB.Clear;

with Query2 do

begin

Close;

SQL.Clear;

SQL.Add(' select distinct(siot_item) from misiot ');

SQL.Add(' order by siot_item ');

Open;

First;

end;



while Not Query2.EOF do

begin

item_sCB.Items.Add(Query2.Fields[0].AsString);

Query2.Next;

end;

end;



procedure Tah7200_f.eitem_code_select;

begin

item_eCB.Clear;

with Query2 do

begin

Close;

SQL.Clear;

SQL.Add(' select distinct(siot_item) from misiot ');

SQL.Add(' order by siot_item ');

Open;

First;

end;



while Not Query2.EOF do

begin

item_eCB.Items.Add(Query2.Fields[0].AsString);

Query2.Next;

end;

end;



procedure Tah7200_f.skubun_code_select;

begin

kubun_sCB.Clear;

with Query2 do

begin

Close;

SQL.Clear;

SQL.Add(' select distinct(siot_kubun) from misiot ');

SQL.Add(' order by siot_kubun ');

Open;

First;

end;



while Not Query2.EOF do

begin

kubun_sCB.Items.Add(Query2.Fields[0].AsString);

Query2.Next;

end;

end;



procedure Tah7200_f.ekubun_code_select;

begin

kubun_eCB.Clear;

with Query2 do

begin

Close;

SQL.Clear;

SQL.Add(' select distinct(siot_kubun) from misiot ');

SQL.Add(' order by siot_kubun ');

Open;

First;

end;



while Not Query2.EOF do

begin

kubun_eCB.Items.Add(Query2.Fields[0].AsString);

Query2.Next;

end;

end;



procedure Tah7200_f.ExitBitBtnClick(Sender: TObject);

begin

close;

end;



procedure Tah7200_f.enterKeyPress(Sender: TObject; var Key: Char);

begin

if key = #13 then

begin

selectNext(sender as tWinControl, True, True);

key := #0;

end;

end;



end.

1  COMMENTS