var frm_hygl: Tfrm_hygl; zrs,nzs,yzs:integer;//总办证数,年证数,月证数 implementation
uses datam, vipedit, vipcx, viptz;
{$R *.dfm} procedure tfrm_hygl.ztljs; begin zrs:=dm.ADO_vip.RecordCount; frm_hygl.ztl.panels[1].text:=inttostr(zrs); dm.ADOQuery.Close; dm.ADOQuery.SQL.Clear; dm.ADOQuery.SQL.Add('select count(*) from vip where 证类型="年证"'); dm.ADOQuery.Open; frm_hygl.ztl.panels[3].text:=dm.ADOQuery.Fields[0].AsString; //月证数量 dm.ADOQuery.Close; dm.ADOQuery.SQL.Clear; dm.ADOQuery.SQL.Add('select count(*) from vip where 证类型="月证"'); dm.ADOQuery.Open; frm_hygl.ztl.panels[5].text:=dm.ADOQuery.Fields[0].AsString; //押金合计 dm.ADOQuery.Close; dm.ADOQuery.SQL.Clear; dm.ADOQuery.SQL.Add('select sum(押金) from vip'); dm.ADOQuery.Open; frm_hygl.ztl.panels[7].text:=dm.ADOQuery.Fields[0].AsString+'元';
end; procedure Tfrm_hygl.DataSetInsert1Execute(Sender: TObject); begin inherited; dm.ADO_vip.Append; dm.ADO_vip.FieldByName('性别').AsStr
首页 上一页 4 5 6 7 8 9 10 下一页 尾页 7/12/12