unit7.pas

人寿保险的管理信息系统

  Combobox1.clear;
  for i:=0 to F_xianzhong.dsclass.DataSet.RecordCount-1 do
  begin
    Combobox1.Items.Add(F_xianzhong.qryclass.Fields[1].asstring);
    F_xianzhong.dsclass.DataSet.Next;
  end;
  F_xianzhong.dsclass.DataSet.First;
  Combobox2.Clear;
  for i:=0 to F_jiaofei.dsfan.DataSet.RecordCount-1 do
  begin
    Combobox2.Items.Add(F_jiaofei.qryfan.Fields[1].asstring);
    F_jiaofei.dsfan.DataSet.Next;
  end;
  F_jiaofei.dsfan.DataSet.First;
  combobox3.Clear;
  for i:=0 to mydm.bpsrc.DataSet.RecordCount-1 do
  begin
     combobox3.Items.Add(mydm.bpQuery.Fields[1].asstring);
     mydm.bpsrc.DataSet.Next;
  end;
  mydm.bpsrc.DataSet.First;
  combobox4.Clear;
  for i:=0 to mydm.jpsrc.DataSet.RecordCount-1 do
  begin
    combobox4.Items.Add(mydm.jpQuery.Fields[1].asstring);
    mydm.jpsrc.DataSet.Next;
  end;
  mydm.jpsrc.DataSet.First;
  combobox6.Clear;
  for i:=0 to mydm.empsrc.DataSet.RecordCount-1 do
  begin
    combobox6.Items.Add(mydm.empQuery.Fields[1].asstring);
    mydm.empsrc.DataSet.Next;
  end;
  mydm.empsrc.DataSet.First;
end;

procedure TF_policy.Edit5KeyPress(Sender: TObject; var Key: Char);
begin
  if not (key in ['0'..'9',Chr(vk_Back),'.']) then
    key:=#0;
end;

procedure TF_policy.ComboBox1KeyDown(Sender: TObject; var Key: Word;
  Shift: TShiftState);
begin
  if Key=13 then
    selectnext(sender as twincontrol,true,true);
end;

procedure TF_policy.ComboBox2KeyDown(Sender: TObject; var Key: Word;
  Shift: TShiftState);
begin
  if Key=13 then
    selectnext(sender as twincontrol,true,true);
end;

procedure TF_policy.Edit5KeyDown(Sender: TObject; var Key: Word;
  Shift: TShiftState);
begin
  if Key=13 then
    selectnext(sender as twincontrol,true,true);
end;

procedure TF_policy.DateTimePicker1KeyDown(Sender: TObject; var Key: Word;
  Shift: TShiftState);
begin
  if Key=13 then
    selectnext(sender as twincontrol,true,true);
end;

procedure TF_policy.Edit6KeyDown(Sender: TObject; var Key: Word;
  Shift: TShiftState);
begin
  if Key=13 then
    selectnext(sender as twincontrol,true,true);
end;

procedure TF_policy.Edit1KeyDown(Sender: TObject; var Key: Word;
  Shift: TShiftState);
begin
  if Key=13 then
    selectnext(sender as twincontrol,true,true);
end;

procedure TF_policy.Edit2KeyDown(Sender: TObject; var Key: Word;
  Shift: TShiftState);
begin
  if Key=13 then
    selectnext(sender as twincontrol,true,true);
end;

procedure TF_policy.Edit3KeyDown(Sender: TObject; var Key: Word;
  Shift: TShiftState);
begin
  if Key=13 then
    selectnext(sender as twincontrol,true,true);
end;

procedure TF_policy.Edit4KeyDown(Sender: TObject; var Key: Word;
  Shift: TShiftState);
begin
  if Key=13 then
    selectnext(sender as twincontrol,true,true);
end;

procedure TF_policy.SpeedButton3Click(Sender: TObject);
  var
  datefen:string;
begin

 begin

  Datetimepicker1.Enabled:=true;
  datetimepicker2.Enabled:=true;
  datetimepicker3.Enabled:=true;
  Edit2.Enabled:=true;
  Edit3.Enabled:=true;
  Edit4.Enabled:=true;
  Edit5.Enabled:=true;
  Combobox1.Enabled:=true;
  Combobox2.Enabled:=true;
  combobox3.Enabled:=true;
  combobox4.Enabled:=true;
  combobox5.Enabled:=true;
  combobox6.Enabled:=true;
  Speedbutton3.Enabled:=false;
  Speedbutton4.Enabled:=false;
  speedbutton6.Enabled:=false;
  button4.Enabled:=true;
  button8.Enabled:=true;
  Edit2.Clear;
  Edit3.Clear;
  Edit4.Clear;
  Edit5.Clear;
  datetimepicker2.Date;
  Datetimepicker1.Date;
  datetimepicker3.Date;
  Datefen:='';
  Punum:='';
  datefen:=Formatdatetime('yyyymmdd',now());//格式化的年月日
  mydm.policysrc.DataSet.Last;
  if Trim(mydm.policysrc.DataSet.Fields[0].AsString)<>'' then
    Punum:=inttostr(strtoint(copy(Trim(mydm.policysrc.DataSet.Fields[0].AsString),9,2))+1);//Punum定义的字符串型全局变量
  if (1<=length(punum)) and (length(punum)<2) then
    punum:='0'+punum;
  if length(punum)<1 then
    punum:='01';
  if length(punum)=3 then
    punum:='01';
  Edit1.Text:=datefen+punum;
  edit1.Enabled:=false;
  edit2.SetFocus;
  end;
end;
procedure TF_policy.SpeedButton4Click(Sender: TObject);
begin
  if mydm.policyquery.RecordCount=0 then
    Exit;
  change:=true;
  //Button1.Click;
  speedbutton3.Enabled:=false;
  speedbutton4.Enabled:=false;
  speedbutton6.Enabled:=false;
  button4.Enabled:=true;
  button8.Enabled:=true;
  edit2.Enabled:=true;
  edit3.Enabled:=true;
  edit4.Enabled:=true;
  Edit5.Enabled:=true;

  Combobox1.Enabled:=true;
  Combobox2.Enabled:=true;
  combobox3.Enabled:=true;
  combobox4.Enabled:=true;
  combobox5.Enabled:=true;
  combobox6.Enabled:=true;
  Datetimepicker1.Enabled:=true;
  datetimepicker2.Enabled:=true;
  datetimepicker3.Enabled:=true;


  Edit1.Text:=mydm.policysrc.DataSet.Fields[0].AsString;
  Edit2.Text:=mydm.policysrc.DataSet.Fields[1].AsString;
  Edit3.Text:=mydm.policysrc.DataSet.Fields[2].AsString;
  Edit4.Text:=mydm.policysrc.DataSet.Fields[3].AsString;
  Combobox1.Text:=mydm.policysrc.DataSet.Fields[4].AsString;
  Combobox2.Text:=mydm.policysrc.DataSet.Fields[5].AsString;
  Edit5.Text:=mydm.policysrc.DataSet.Fields[6].AsString;
  Datetimepicker2.Date:=mydm.policysrc.DataSet.Fields[7].AsDateTime;
  combobox3.Text:=mydm.policysrc.DataSet.Fields[8].AsString;
  datetimepicker1.Date:=mydm.policysrc.DataSet.Fields[9].AsDateTime;
  datetimepicker3.Date:=mydm.policysrc.DataSet.Fields[10].AsDateTime;
  combobox4.Text:=mydm.policysrc.DataSet.Fields[11].AsString;
  combobox5.Text:=mydm.policysrc.DataSet.Fields[12].AsString;
  combobox6.Text:=mydm.policysrc.DataSet.Fields[13].AsString;
end;



procedure TF_policy.Button1Click(Sender: TObject);
begin
 with Mydm.policyQuery do
  begin
    Close;
    with SQL do
    begin
      Clear;
      Add('select*from policy');
      Add('where policy_id=:p');
    end;
    Parameters[0].Value:=trim(edit6.Text);
    Prepared;
    Open;
  edit6.Clear;
  button4.Enabled:=false;
  end;
end;

procedure TF_policy.Button2Click(Sender: TObject);
begin
  with mydm.policyquery do
  begin
    Close;
      with SQL do
      begin
        Clear;
        Add('select*from policy');
        Add('where class_id=:p');
      end;
    Parameters[0].Value:=trim(edit7.Text);
    Prepared;
    Open;
    end;
    edit7.Clear;
    button2.enabled:=false;
end;

procedure TF_policy.Edit6Change(Sender: TObject);
begin
    button1.Enabled:=true;
    
end;

procedure TF_policy.ComboBox3KeyDown(Sender: TObject; var Key: Word;
  Shift: TShiftState);
begin
      if Key=13 then
    selectnext(sender as twincontrol,true,true);
end;

procedure TF_policy.ComboBox4KeyDown(Sender: TObject; var Key: Word;
  Shift: TShiftState);
begin
        if Key=13 then
    selectnext(sender as twincontrol,true,true);
end;

procedure TF_policy.ComboBox5KeyDown(Sender: TObject; var Key: Word;
  Shift: TShiftState);
begin
  if Key=13 then
    selectnext(sender as twincontrol,true,true);
end;

procedure TF_policy.ComboBox6KeyDown(Sender: TObject; var Key: Word;
  Shift: TShiftState);
begin
  if Key=13 then
    selectnext(sender as twincontrol,true,true);
end;

procedure TF_policy.Button3Click(Sender: TObject);
begin
   F_cust.Show;
end;

procedure TF_policy.Button5Click(Sender: TObject);
begin
     F_ins.Show;
end;

procedure TF_policy.Button6Click(Sender: TObject);
begin
     F_bene.show;
end;

procedure TF_policy.SpeedButton6Click(Sender: TObject);
begin
 if Application.MessageBox('是否删除？','提示',mb_yesno)=6 then
  begin
    try
      mydm.policysrc.DataSet.Delete;
    except//如果删除不成功将弹出以下对会框
      Application.MessageBox('删除不成功!','提示',mb_ok);
    end;
  end;
end;

end.