blqcz.pas

用delphi开发的电力调度操作票系统并带有access数据库

unit BLQCZ;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, StdCtrls, ExtCtrls,Common, DB, ADODB;

type
  TFrm_BLQ = class(TForm)
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    CB_BDS: TComboBox;
    CB_Num: TComboBox;
    CB_Name: TComboBox;
    RG_ZH: TRadioGroup;
    RG_AC: TRadioGroup;
    BT_Sure: TButton;
    BT_Cancle: TButton;
    ADOQuery: TADOQuery;
    procedure BT_SureClick(Sender: TObject);
    procedure FormCreate(Sender: TObject);
    procedure CB_NumChange(Sender: TObject);
    procedure CB_NameChange(Sender: TObject);
    procedure CB_BDSChange(Sender: TObject);
    procedure RG_ZHClick(Sender: TObject);
    procedure RG_ACClick(Sender: TObject);
    procedure BT_CancleClick(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Frm_BLQ: TFrm_BLQ;
  content:TKContent;
implementation
uses
  RptTable;
  
{$R *.dfm}

procedure TFrm_BLQ.BT_SureClick(Sender: TObject);
var
  qjnum,cznum,MidStr:string ;
begin
 //
  //获取开关类型
  ADOQuery.Close;
  ADOQuery.SQL.Text:='select 开关类型 from BLQ where 避雷器编号='''+CB_NUM.Text+'''';
  ADOQuery.Open;
  qjnum:=ADOQuery.FieldByName('开关类型').AsString;
  MidStr:='6kV'+CB_NAME.Text+CB_NUM.Text;
  case RG_ZH.ItemIndex of
    0:
    begin
      cznum:='ZH01';
      content:=Frm_Com.GetData(qjnum,cznum,MidStr);
      content.Title:=MidStr+'停电';
      content.B_Type:='ZH.ini';
    end;
    1:
    begin
      cznum:='ZH02';
      content:=Frm_Com.GetData(qjnum,cznum,MidStr);
      content.Title:=MidStr+'送电';
      content.B_Type:='ZH.ini';
    end;
  end;

   case RG_AC.ItemIndex of
    0:
    begin
      cznum:='AC03';
      content:=Frm_Com.GetData(qjnum,cznum,MidStr);
      content.Title:=MidStr+'停电检修';
      content.B_Type:='AC1.ini';
    end;
    1:
    begin
      cznum:='AC04';
      content:=Frm_Com.GetData(qjnum,cznum,MidStr);
      content.Title:=MidStr+'拆除安措';
      content.B_Type:='AC1.ini';
    end;
  end;

  if (RG_ZH.ItemIndex=-1) and (RG_AC.ItemIndex=-1)then//if Trim(content.B_Type)='' then
  begin
    showmessage('请选择票令类型!');
    exit;
  end;
  content.Body.Add(CB_BDS.Text);//发令单位

  //-->写入配置信息
  if Frm_Com.WriteINI(content.B_Type)=false then
  begin
    showmessage('写入配置信息时发生错误！配置文件可能丢失或损坏!');
    exit;
  end;
  //-->创建报表
  Self.Hide;
  Frm_Com.WriteData(content);
  Application.CreateForm(TFrm_Table,Frm_Table);
  Frm_Table.Show;
  Self.Close;

end;

procedure TFrm_BLQ.FormCreate(Sender: TObject);
var
  BDS_NUM:string;
begin
  Self.ADOQuery.Connection:=Frm_Com.ADOConnection;
  Self.ADOQuery.SQL.Text:='select * from BDS';
  Self.ADOQuery.Open;
  Frm_Com.AddCoBoItem(CB_BDS,'变电所名称',Self.ADOQuery);//添加变电所
  Self.ADOQuery.SQL.Text:='select 变电所编号 from BDS where 变电所名称='''+trim(CB_BDS.Text)+'''';
  Self.ADOQuery.Open;
  BDS_NUM:=trim(Self.ADOQuery.Fields[0].AsString);
  Self.ADOQuery.SQL.Text:='select * from BLQ where 变电所编号='''+BDS_NUM+'''';
  Self.ADOQuery.Open;
  Frm_Com.AddCoBoItem(CB_Num,'避雷器编号',Self.ADOQuery);//添加开关编号
  Frm_Com.AddCoBoItem(CB_NAME,'避雷器名称',Self.ADOQuery);//添加开关名
  Self.ADOQuery.Close;
end;

procedure TFrm_BLQ.CB_NumChange(Sender: TObject);
begin
  CB_Name.ItemIndex:=CB_Num.ItemIndex;
end;

procedure TFrm_BLQ.CB_NameChange(Sender: TObject);
begin
  CB_NUM.ItemIndex:=CB_Name.ItemIndex;
end;

procedure TFrm_BLQ.CB_BDSChange(Sender: TObject);
var
  BDS_NUM:string;
begin
  Self.ADOQuery.SQL.Text:='select 变电所编号 from BDS where 变电所名称='''+trim(CB_BDS.Text)+'''';
  Self.ADOQuery.Open;
  BDS_NUM:=trim(Self.ADOQuery.Fields[0].AsString);
  Self.ADOQuery.SQL.Text:='select * from BLQ where 变电所编号='''+BDS_NUM+'''';
  Self.ADOQuery.Open;
  Frm_Com.AddCoBoItem(CB_NUM,'避雷器编号',Self.ADOQuery);//添加开关编号
  Frm_Com.AddCoBoItem(CB_NAME,'避雷器名称',Self.ADOQuery);//添加开关名
  Self.ADOQuery.Close;
end;

procedure TFrm_BLQ.RG_ZHClick(Sender: TObject);
begin
  RG_AC.ItemIndex:=-1;
end;

procedure TFrm_BLQ.RG_ACClick(Sender: TObject);
begin
  RG_ZH.ItemIndex:=-1;
end;

procedure TFrm_BLQ.BT_CancleClick(Sender: TObject);
begin
  Close;
end;

end.