作业帮 > 综合 > 作业

procedure TForm18.BitBtn1Click(Sender:TObject);

来源:学生作业帮 编辑:作业帮 分类:综合作业 时间:2024/05/05 11:44:06
procedure TForm18.BitBtn1Click(Sender:TObject);
begin
with ADOQuery3 do
begin
Close;
SQL.Clear ;
SQL.Add('select c.类别,(a.入库数量-b.出库数量)as 当前库存 from OUTStock b ,INStock a,GoodsInform c where (a.商品条码=b.商品条码)and (a.商品条码=c.商品条码) and 日期 between :m and :n group by c.类别');
Parameters.ParamByName('m').Value:=Trunc(DateTimePicker1.Date);
Parameters.ParamByName('n').Value:=Trunc(DateTimePicker2.Date);
open;
end;
Series3.DataSource:=ADOQuery3;
Series3.YValues.ValueSource:='日用品' ;
Series3.XLabelsSource:='日期'
Series4.DataSource:=ADOQuery3;
Series4.YValues.ValueSource:='厨具类' ;
Series5.DataSource:=ADOQuery3;
Series5.YValues.ValueSource:='护肤类' ;
Series6.DataSource:=ADOQuery3;
Series6.YValues.ValueSource:='电器类' ;
Series7.DataSource:=ADOQuery3;
Series7.YValues.ValueSource:='书刊类' ;
end;
什么东西?