uhwsqxx.pas

明日科技的《Delphi数据库开发案例精选》中的资源管理系统源代码。界面美观

      Prepared:=true;
      ExecSQL;
    end;
  end;
end;
procedure TFRM_HWSQXX.ENA;
var
  i:integer;
begin
  for i:=ComponentCount-1 downto 0 do
  begin
    if (Components[i] is TEdit) then
    begin
      TEdit(Components[i]).Color:=clWindow;
      TEdit(Components[i]).ReadOnly:=False;
    end;
  end;
  ComboBox1.Color:=clWindow;
  ComboBox2.Color:=clWindow;
  ComboBox3.Color:=clWindow;
  DateTimePicker1.Color:=clWindow;
  DateTimePicker2.Color:=clWindow;
  SpeedButton1.Enabled:=False;
  SpeedButton2.Enabled:=False;
  SpeedButton3.Enabled:=True;
  SpeedButton4.Enabled:=False;
  Panel1.Enabled:=True;
end;
procedure TFRM_HWSQXX.DIS;
var
  i:integer;
begin
  for i:=ComponentCount-1 downto 0 do
  begin
    if (Components[i] is Tedit) then
    begin
      TEdit(Components[i]).Color:=$00EFEFEF;
      TEdit(Components[i]).ReadOnly:=true;
    end;
  end;
  ComboBox1.Color:=$00EFEFEF;
  ComboBox2.Color:=$00EFEFEF;
  ComboBox3.Color:=$00EFEFEF;
  DateTimePicker1.Color:=$00EFEFEF;
  DateTimePicker2.Color:=$00EFEFEF;
  SpeedButton1.Enabled:=True;
  SpeedButton2.Enabled:=True;
  SpeedButton3.Enabled:=False;
  SpeedButton4.Enabled:=False;
  Panel1.Enabled:=False;
end;
procedure TFRM_HWSQXX.CLS;
var
  i:integer;
begin
  for i:=ComponentCount-1 downto 0 do
  begin
    if(Components[i] is TEdit) then
      TEdit(Components[i]).Clear;
  end;
  ComboBox1.Clear;
  ComboBox2.Clear;
  ComboBox3.Clear;
  DateTimePicker1.Date:=now;
  DateTimePicker2.Date:=now;
end;
//////////////////////////////////////////////////////
procedure TFRM_HWSQXX.SpeedButton6Click(Sender: TObject);
begin
  ACtionCD:='';
  Close;
end;

procedure TFRM_HWSQXX.FormCreate(Sender: TObject);
begin
  with DM.QHWSQXX do
  begin
    Close;
    SQL.Clear;
    SQL.Add('Select * from 货物申请信息表');
    Open;
  end;
  DM.DSOHWSQXX.Open;
end;

procedure TFRM_HWSQXX.FormShow(Sender: TObject);
begin
  DIS;
  if ActionCD = 'M' then
    GetAll
  else if ActionCD = 'N' then
  begin
    CLS;
    ENA;
  end;
end;

procedure TFRM_HWSQXX.SpeedButton1Click(Sender: TObject);
begin
  CLS;
  ENA;
  ActionCD := 'N';
  bh;
  bh1;
  bh2;
  bh3;
  Edit16.Text:='0';
  Edit17.Text:='0';
  Edit18.Text:='0';
  ComboBox1.SetFocus;
end;

procedure TFRM_HWSQXX.SpeedButton2Click(Sender: TObject);
begin
  ENA;
  SpeedButton4.Enabled:=True;
  ACtionCD := 'M';
end;

procedure TFRM_HWSQXX.SpeedButton3Click(Sender: TObject);
begin
  if (cansave) then
  begin
//    Edit18.Text:=FloatToStr(StrToFloat(Edit16.Text)+StrToFloat(Edit17.Text));
    Posting;
    DIS;
    DM.DSOHWSQXX.Close;
    DM.DSOHWSQXX.Open;
    Application.MessageBox('保存成功!','提示!',64);
    actioncd:='';
    self.Close;
  end;
end;

procedure TFRM_HWSQXX.SpeedButton4Click(Sender: TObject);
begin
  if DM.DSOHWSQXX.RecordCount=0 then
  begin
    Application.MessageBox('没有记录可以删除!','提示',0+MB_ICONINFORMATION);
    Exit;
  end;
  if DM.DSOHWSQXX.IsEmpty then
    Exit;
  if ID_YES=application.MessageBox('确实要删除这条记录吗？','提示',MB_YESNO) then
  begin
    DM.DSOHWSQXX.Delete;
    self.OnShow(Sender);
  end;
end;

procedure TFRM_HWSQXX.SpeedButton5Click(Sender: TObject);
begin
  DIS;
  SpeedButton4.Enabled:=False;
  FRM_HWSQXX.GetAll;
  ActionCD:='';
end;

procedure TFRM_HWSQXX.ComboBox1DropDown(Sender: TObject);
var
i:integer;
begin
  ComboBox1.Clear;
  With DM.QKHJBXX do
  begin
    CLose;
    SQL.Clear;
    SQL.Add('Select 客户编号 from 客户信息表');
    Open;
    if (Recordcount>0) then
      First;
    for i:=0 to Recordcount-1 do
    begin
      ComboBox1.Items.Add(FieldByName('客户编号').AsString);
      Next;
    end;
  end;
end;

procedure TFRM_HWSQXX.ComboBox2DropDown(Sender: TObject);
var
i:integer;
begin
  ComboBox2.Clear;
  With DM.QCLJBXX do
  begin
    CLose;
    SQL.Clear;
    SQL.Add('Select 车辆编号 from 车辆信息表');
    Open;
    if (Recordcount>0) then
      First;
    for i:=0 to Recordcount-1 do
    begin
      ComboBox2.Items.Add(FieldByName('车辆编号').AsString);
      Next;
    end;
  end;
end;

procedure TFRM_HWSQXX.ComboBox3DropDown(Sender: TObject);
var
i:integer;
begin
  ComboBox3.Clear;
  With DM.QBMJBXX do
  begin
    CLose;
    SQL.Clear;
    SQL.Add('Select 部门名称 from 部门信息表');
    Open;
    if (Recordcount>0) then
      First;
    for i:=0 to Recordcount-1 do
    begin
      ComboBox3.Items.Add(FieldByName('部门名称').AsString);
      Next;
    end;
  end;
end;

procedure TFRM_HWSQXX.ComboBox1Change(Sender: TObject);
begin
  Edit2.Clear;
  with DM.QKHJBXX do
  begin
    Close;
    SQL.Clear;
    SQL.Add('Select 客户名称 from 客户信息表 where 客户编号='+''''+ComboBox1.Text+'''');
    Open;
  end;
  if ComboBox1.Text<>'' then
  begin
    Edit2.Text:=DM.QKHJBXX.FieldByName('客户名称').Value;
  end;
  Edit20.Clear;
  with DM.QKHJBXX do
  begin
    Close;
    SQL.Clear;
    SQL.Add('Select 联系电话 from 客户信息表 where 客户编号='+''''+ComboBox1.Text+'''');
    Open;
  end;
  if ComboBox1.Text<>'' then
  begin
    Edit20.Text:=DM.QKHJBXX.FieldByName('联系电话').Value;
  end;
  Edit21.Clear;
  with DM.QKHJBXX do
  begin
    Close;
    SQL.Clear;
    SQL.Add('Select 联系人 from 客户信息表 where 客户编号='+''''+ComboBox1.Text+'''');
    Open;
  end;
  if ComboBox1.Text<>'' then
  begin
    Edit21.Text:=DM.QKHJBXX.FieldByName('联系人').Value;
  end;
  DateTimePicker1.SetFocus;
end;

procedure TFRM_HWSQXX.ComboBox2Change(Sender: TObject);
begin
  Edit6.Clear;
  with DM.QCLJBXX do
  begin
    Close;
    SQL.Clear;
    SQL.Add('Select 车牌号码 from 车辆信息表 where 车辆编号='+''''+ComboBox2.Text+'''');
    Open;
  end;
  if ComboBox2.Text<>'' then
  begin
    Edit6.Text:=DM.QCLJBXX.FieldByName('车牌号码').Value;
    Edit7.SetFocus;
  end;
end;

procedure TFRM_HWSQXX.Edit2KeyPress(Sender: TObject; var Key: Char);
begin
  key:=#0;
end;

procedure TFRM_HWSQXX.Edit6KeyPress(Sender: TObject; var Key: Char);
begin
  key:=#0;
end;

procedure TFRM_HWSQXX.Edit1KeyPress(Sender: TObject; var Key: Char);
begin
  key:=#0;
end;

procedure TFRM_HWSQXX.ComboBox1KeyPress(Sender: TObject; var Key: Char);
begin
  if not (key in[#13,#8]) then
    key:=#0;
end;

procedure TFRM_HWSQXX.Edit3KeyPress(Sender: TObject; var Key: Char);
begin
  key:=#0;
end;

procedure TFRM_HWSQXX.Edit4KeyPress(Sender: TObject; var Key: Char);
begin
  key:=#0;
end;

procedure TFRM_HWSQXX.Edit5KeyPress(Sender: TObject; var Key: Char);
begin
  key:=#0;
end;

procedure TFRM_HWSQXX.DateTimePicker1KeyPress(Sender: TObject;
  var Key: Char);
begin
  if key=#13 then
    ComboBox2.SetFocus;
end;

procedure TFRM_HWSQXX.ComboBox2KeyPress(Sender: TObject; var Key: Char);
begin
  if not (key in[#13,#8]) then
    key:=#0;
end;

procedure TFRM_HWSQXX.Edit7KeyPress(Sender: TObject; var Key: Char);
begin
  if key in['a'..'z','A'..'Z','0'..'9'] then
    key:=#0;
  if key=#13 then
    Edit8.SetFocus;
end;

procedure TFRM_HWSQXX.Edit8KeyPress(Sender: TObject; var Key: Char);
begin
  if key in['a'..'z','A'..'Z','0'..'9'] then
    key:=#0;
  if key=#13 then
    DateTimePicker2.SetFocus;
end;

procedure TFRM_HWSQXX.DateTimePicker2KeyPress(Sender: TObject;
  var Key: Char);
begin
  if key=#13 then
    Edit9.SetFocus;
end;

procedure TFRM_HWSQXX.Edit9KeyPress(Sender: TObject; var Key: Char);
begin
  if key in['a'..'z'] then
    key:=#0;
  if key=#13 then
    Edit10.SetFocus;
end;

procedure TFRM_HWSQXX.Edit10KeyPress(Sender: TObject; var Key: Char);
begin
  if not (key in['0'..'9',#13,#8,'.']) then
    key:=#0;
  if key=#13 then
    Edit11.SetFocus;
end;

procedure TFRM_HWSQXX.Edit11KeyPress(Sender: TObject; var Key: Char);
begin
  if not (key in['0'..'9',#13,#8,'.']) then
    key:=#0;
  if key=#13 then
    Edit12.SetFocus;
end;

procedure TFRM_HWSQXX.Edit12KeyPress(Sender: TObject; var Key: Char);
begin
  if not (key in['0'..'9',#13,#8,'.']) then
    key:=#0;
  if key=#13 then
    Edit13.SetFocus;
end;

procedure TFRM_HWSQXX.Edit13KeyPress(Sender: TObject; var Key: Char);
begin
  if key in['a'..'z'] then
    key:=#0;
  if key=#13 then
    Edit14.SetFocus;
end;

procedure TFRM_HWSQXX.Edit14KeyPress(Sender: TObject; var Key: Char);
begin
  if not (key in['0'..'9',#13,#8,'.']) then
    key:=#0;
  if key=#13 then
    Edit15.SetFocus;
end;

procedure TFRM_HWSQXX.Edit15KeyPress(Sender: TObject; var Key: Char);
begin
  if not (key in['0'..'9',#13,#8,'.']) then
    key:=#0;
  if key=#13 then
    Edit16.SetFocus;
end;

procedure TFRM_HWSQXX.Edit16KeyPress(Sender: TObject; var Key: Char);
begin
  if not (key in['0'..'9',#13,#8,'.']) then
    key:=#0;
  if key=#13 then
    Edit17.SetFocus;
end;

procedure TFRM_HWSQXX.Edit17KeyPress(Sender: TObject; var Key: Char);
begin
  if not (key in['0'..'9',#13,#8,'.']) then
    key:=#0;
  if key=#13 then
    ComboBox3.SetFocus;
end;

procedure TFRM_HWSQXX.ComboBox3KeyPress(Sender: TObject; var Key: Char);
begin
  if not (key in[#8,#13]) then
    key:=#0;
  if key=#13 then
    Edit19.SetFocus;
end;

procedure TFRM_HWSQXX.DBGrid1CellClick(Column: TColumn);
begin
  GetAll;
end;

procedure TFRM_HWSQXX.Edit7Change(Sender: TObject);
begin
tr
end;

procedure TFRM_HWSQXX.Edit8Change(Sender: TObject);
begin
tr
end;

procedure TFRM_HWSQXX.Edit9Change(Sender: TObject);
begin
tr
end;

procedure TFRM_HWSQXX.Edit10Change(Sender: TObject);
begin
tr
end;

procedure TFRM_HWSQXX.Edit11Change(Sender: TObject);
begin
tr
end;

procedure TFRM_HWSQXX.Edit12Change(Sender: TObject);
begin
tr
end;

procedure TFRM_HWSQXX.Edit13Change(Sender: TObject);
begin
tr
end;

procedure TFRM_HWSQXX.Edit14Change(Sender: TObject);
begin
tr
end;

procedure TFRM_HWSQXX.Edit15Change(Sender: TObject);
begin
tr
end;

procedure TFRM_HWSQXX.Edit16Change(Sender: TObject);
begin
tr
end;

procedure TFRM_HWSQXX.Edit17Change(Sender: TObject);
begin
tr
end;

procedure TFRM_HWSQXX.Edit19Change(Sender: TObject);
begin
tr
end;

procedure TFRM_HWSQXX.Edit16Exit(Sender: TObject);
begin
  Edit18.Text:=FloatToStr(StrToFloat(Edit16.Text)+StrToFloat(Edit17.Text));
end;

procedure TFRM_HWSQXX.Edit17Exit(Sender: TObject);
begin
  Edit18.Text:=FloatToStr(StrToFloat(Edit16.Text)+StrToFloat(Edit17.Text));
end;

procedure TFRM_HWSQXX.DBGrid1DrawColumnCell(Sender: TObject;
  const Rect: TRect; DataCol: Integer; Column: TColumn;
  State: TGridDrawState);
begin
  FRM_MAIN.SetDBGird(Sender as TDBGrid,DM.QHWSQXX ,Rect,DataCol,Column,State);
end;

end.