//***********************窗体初始化***********************************************
procedure Tfrm_kf_ck.FormCreate(Sender: TObject);
begin
MainFormset(1024,740,0,0);
Application.Title:='库房出库';
RzComboBox1.Text:=IntToStr(YearOf(Now));
RzComboBox2.Text:=IntToStr(MonthOf(Now));
if length(RzComboBox2.Text)=1 then
begin
RzComboBox2.Text:='0'+RzComboBox2.Text;
end;
with ADOQuery_ck do
begin
Close;
SQL.Clear;
SQL.Add('select * from kfck'+RzComboBox1.Text+RzComboBox2.Text);
Open;
end;
RzEdit5.Text:=IntToStr(ADOQuery_ck.RecordCount);
end;
//********************** 添加按钮点击事件*****************************************
procedure Tfrm_kf_ck.suiButton3Click(Sender: TObject);
begin
Application.CreateForm(Tfrm_kf_ck_add, frm_kf_ck_add);
end;
//********************** 筛选按钮点击事件*****************************************
procedure Tfrm_kf_ck.suiButton6Click(Sender: TObject);
begin
with ADOQuery_ck do
begin
Close;
SQL.Clear;
SQL.Add('select * from kfck'+RzComboBox1.Text+RzComboBox2.Text
+' where f_ckdh like ''%'+RzEdit1.Text+'%'''
+' and f_cpbh like ''%'+RzEdit2.Text+'%'''
+' and f_cpsh like ''%'+RzEdit3.Text+'%''');
if RzDateTimeEdit1.Text<>'' then
SQL.Add(' and f_ckrq='''+RzDateTimeEdit1.Text+'''');
Open;
end;
RzEdit5.Text:=IntToStr(ADOQuery_ck.RecordCount);
end;
//********************** 编辑按钮点击事件*****************************************
procedure Tfrm_kf_ck.suiButton4Click(Sender: TObject);
begin
// ADOQuery_ck.Edit;
end;
//********************** 确定按钮点击事件*****************************************
procedure Tfrm_kf_ck.suiButton2Click(Sender: TObject);
begin
with ADOQuery_ck do
begin
Close;
SQL.Clear;
SQL.Add('select * from kfck'+RzComboBox1.Text+RzComboBox2.Text);
Open;
end;
RzEdit5.Text:=IntToStr(ADOQuery_ck.RecordCount);
end;
//********************** 删除按钮点击事件*****************************************
procedure Tfrm_kf_ck.suiButton5Click(Sender: TObject);
begin
// ADOQuery_ck.Delete;
end;
//********************** 读入按钮点击事件*****************************************
procedure Tfrm_kf_ck.suiButton7Click(Sender: TObject);
begin
Application.CreateForm(Tfrm_kf_ck_dao, frm_kf_ck_dao);
end;
//********************** 打印按钮事件 ********************************************
procedure Tfrm_kf_ck.suiButton8Click(Sender: TObject);
begin
with ADOQuery1 do
begin
Close;
SQL.Clear;
SQL.Add('select * from kfck'+RzComboBox1.Text+RzComboBox2.Text
+' where f_ckdh='''+RzEdit7.Text+'''');
Open;
end;
frxReport1.Clear;
frxReport1.LoadFromFile('D:\smii\SMI_XS\deploy\CKMD.fr3');
frxReport1.PrepareReport;
frxReport1.ShowPreparedReport;
end;
procedure Tfrm_kf_ck.FormClose(Sender: TObject; var Action: TCloseAction);
begin
frxReport1.Clear;
Action:=cafree;