sysconfigfrm.~pas

来自「一个电力企业的后台管理程序」· ~PAS 代码 · 共 232 行

unit sysconfigfrm;

interface

uses
  Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs,
  ExtCtrls, Db, DBTables, StdCtrls, Buttons, ComCtrls, DBCtrls;

type
  TFrm_SysConfig = class(TForm)
    Panel1: TPanel;
    PageControl1: TPageControl;
    TabSheet1: TTabSheet;
    TabSheet3: TTabSheet;
    Qrysysconfig: TQuery;
    Dssysconfig: TDataSource;
    TabSheet4: TTabSheet;
    Panel2: TPanel;
    BBok: TBitBtn;
    BBCancel: TBitBtn;
    Label10: TLabel;
    Edit10: TEdit;
    Label15: TLabel;
    Edit15: TEdit;
    Label11: TLabel;
    Edit11: TEdit;
    Label12: TLabel;
    Edit12: TEdit;
    Label13: TLabel;
    Edit13: TEdit;
    Panel3: TPanel;
    Label1: TLabel;
    Edit1: TEdit;
    Label17: TLabel;
    Edit17: TEdit;
    Label14: TLabel;
    Edit14: TEdit;
    Label19: TLabel;
    Edit19: TEdit;
    Label8: TLabel;
    Edit8: TEdit;
    Label20: TLabel;
    Edit20: TEdit;
    Label3: TLabel;
    Edit3: TEdit;
    Label16: TLabel;
    Edit16: TEdit;
    Label18: TLabel;
    Edit18: TEdit;
    Label29: TLabel;
    Edit29: TEdit;
    Panel4: TPanel;
    Label6: TLabel;
    Edit6: TEdit;
    Label2: TLabel;
    Edit2: TEdit;
    Label28: TLabel;
    Edit28: TEdit;
    Label24: TLabel;
    Edit24: TEdit;
    Label21: TLabel;
    Edit21: TEdit;
    Label22: TLabel;
    Edit22: TEdit;
    Label25: TLabel;
    Edit25: TEdit;
    Label4: TLabel;
    Label5: TLabel;
    Label7: TLabel;
    Label9: TLabel;
    Edit4: TEdit;
    Edit5: TEdit;
    Edit7: TEdit;
    Edit9: TEdit;
    Label23: TLabel;
    Label26: TLabel;
    Label27: TLabel;
    Edit23: TEdit;
    Label30: TLabel;
    Edit26: TEdit;
    procedure FormCreate(Sender: TObject);
    procedure BBokClick(Sender: TObject);
    procedure BBCancelClick(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
  private
    { Private declarations }
    function GetEdit(var SLabel:string):string;
    function SaveEdit(var SLabel,SEdit:string):BooLean; 
  public
    { Public declarations }
  end;

var
  Frm_SysConfig: TFrm_SysConfig;

implementation
uses SystemPH;
{$R *.DFM}


function TFrm_SysConfig.GetEdit(var SLabel:string):string;
var
  str:string;
begin
  str:='select * from sysconfig where ITEM=';
  str:=str+#39+SLabel+#39;
  with QrySysconfig do
    begin
      Close;
      Sql.Clear;
      Sql.Add(str);
      Open;
      result:=FieldByName('VAL').AsString;
    end;
end;

function TFrm_SysConfig.SaveEdit(var SLabel,SEdit:string):BooLean;
var
  str:string;
begin
  str:='update sysconfig set VAL=';
  str:=str+#39+SEdit+#39+' where Item=';
  str:=str+#39+SLabel+#39;
  with QrySysconfig do
    begin
      Close;
      Sql.Clear;
      Sql.Add(str);
      try
        ExecSql;
        Result:=True;
      except
        Application.MessageBox('数据更新出现错误','消息框',MB_ICONSTOP+MB_OK);
        Result:=False;
        Exit;
      End;
    end;
end;

procedure TFrm_SysConfig.FormCreate(Sender: TObject);
var
  SLabel:string;
begin
  SLabel:=Label1.Caption;  Edit1.Text:=GetEdit(SLabel);
  SLabel:=Label2.Caption;  Edit2.Text:=GetEdit(SLabel);
  SLabel:=Label3.Caption;  Edit3.Text:=GetEdit(SLabel);
  SLabel:=Label4.Caption;  Edit4.Text:=GetEdit(SLabel);
  SLabel:=Label5.Caption;  Edit5.Text:=GetEdit(SLabel);
  SLabel:=Label6.Caption;  Edit6.Text:=GetEdit(SLabel);
  SLabel:=Label7.Caption;  Edit7.Text:=GetEdit(SLabel);
  SLabel:=Label8.Caption;  Edit8.Text:=GetEdit(SLabel);
  SLabel:=Label9.Caption;  Edit9.Text:=GetEdit(SLabel);
  SLabel:=Label10.Caption; Edit10.Text:=GetEdit(SLabel);
  SLabel:=Label11.Caption; Edit11.Text:=GetEdit(SLabel);
  SLabel:=Label12.Caption; Edit12.Text:=GetEdit(SLabel);
  SLabel:=Label13.Caption; Edit13.Text:=GetEdit(SLabel);
  SLabel:=Label14.Caption; Edit14.Text:=GetEdit(SLabel);
  SLabel:=Label15.Caption; Edit15.Text:=GetEdit(SLabel);
  SLabel:=Label16.Caption; Edit16.Text:=GetEdit(SLabel);
  SLabel:=Label17.Caption; Edit17.Text:=GetEdit(SLabel);
  SLabel:=Label18.Caption; Edit18.Text:=GetEdit(SLabel);
  SLabel:=Label19.Caption; Edit19.Text:=GetEdit(SLabel);
  SLabel:=Label20.Caption; Edit20.Text:=GetEdit(SLabel);
  SLabel:=Label21.Caption; Edit21.Text:=GetEdit(SLabel);
  SLabel:=Label22.Caption; Edit22.Text:=GetEdit(SLabel);
  SLabel:=Label27.Caption; Edit23.Text:=GetEdit(SLabel);
  SLabel:=Label30.Caption; Edit26.Text:=GetEdit(SLabel);

  SLabel:=Label24.Caption; Edit24.Text:=GetEdit(SLabel);
  SLabel:=Label25.Caption; Edit25.Text:=GetEdit(SLabel);


  SLabel:=Label28.Caption; Edit28.Text:=GetEdit(SLabel);
  SLabel:=Label29.Caption; Edit29.Text:=GetEdit(SLabel);
  PageConTrol1.ActivePage:=TabSheet1;
end;

procedure TFrm_SysConfig.BBokClick(Sender: TObject);
var
  SLabel,SEdit:string;
begin
  if Application.MessageBox('是否确认上述信息?','消息框',
                            MB_ICONINFORMATION+MB_OKCANCEL)=IDCANCEL then exit;
  SLabel:=Label1.Caption;  SEdit:=Edit1.Text;  if not SaveEdit(SLabel,Sedit) then Exit;
  SLabel:=Label2.Caption;  SEdit:=Edit2.Text;  if not SaveEdit(SLabel,Sedit) then Exit;
  SLabel:=Label3.Caption;  SEdit:=Edit3.Text;  if not SaveEdit(SLabel,Sedit) then Exit;
  SLabel:=Label4.Caption;  SEdit:=Edit4.Text;  if not SaveEdit(SLabel,Sedit) then Exit;
  SLabel:=Label5.Caption;  SEdit:=Edit5.Text;  if not SaveEdit(SLabel,Sedit) then Exit;
  SLabel:=Label6.Caption;  SEdit:=Edit6.Text;  if not SaveEdit(SLabel,Sedit) then Exit;
  SLabel:=Label7.Caption;  SEdit:=Edit7.Text;  if not SaveEdit(SLabel,Sedit) then Exit;
  SLabel:=Label8.Caption;  SEdit:=Edit8.Text;  if not SaveEdit(SLabel,Sedit) then Exit;
  SLabel:=Label9.Caption;  SEdit:=Edit9.Text;  if not SaveEdit(SLabel,Sedit) then Exit;
  SLabel:=Label10.Caption; SEdit:=Edit10.Text;  if not SaveEdit(SLabel,Sedit) then Exit;
  SLabel:=Label11.Caption; SEdit:=Edit11.Text;  if not SaveEdit(SLabel,Sedit) then Exit;
  SLabel:=Label12.Caption; SEdit:=Edit12.Text;  if not SaveEdit(SLabel,Sedit) then Exit;
  SLabel:=Label13.Caption; SEdit:=Edit13.Text;  if not SaveEdit(SLabel,Sedit) then Exit;
  SLabel:=Label14.Caption; SEdit:=Edit14.Text;  if not SaveEdit(SLabel,Sedit) then Exit;
  SLabel:=Label15.Caption; SEdit:=Edit15.Text;  if not SaveEdit(SLabel,Sedit) then Exit;
  SLabel:=Label16.Caption; SEdit:=Edit16.Text;  if not SaveEdit(SLabel,Sedit) then Exit;
  SLabel:=Label17.Caption; SEdit:=Edit17.Text;  if not SaveEdit(SLabel,Sedit) then Exit;
  SLabel:=Label18.Caption; SEdit:=Edit18.Text;  if not SaveEdit(SLabel,Sedit) then Exit;
  SLabel:=Label19.Caption; SEdit:=Edit19.Text;  if not SaveEdit(SLabel,Sedit) then Exit;
  SLabel:=Label20.Caption; SEdit:=Edit20.Text;  if not SaveEdit(SLabel,Sedit) then Exit;
  SLabel:=Label21.Caption; SEdit:=Edit21.Text;  if not SaveEdit(SLabel,Sedit) then Exit;
  SLabel:=Label22.Caption; SEdit:=Edit22.Text;  if not SaveEdit(SLabel,Sedit) then Exit;
  SLabel:=Label27.Caption; SEdit:=Edit23.Text;  if not SaveEdit(SLabel,Sedit) then Exit;
  SLabel:=Label30.Caption; SEdit:=Edit26.Text;  if not SaveEdit(SLabel,Sedit) then Exit;

  SLabel:=Label24.Caption; SEdit:=Edit24.Text;  if not SaveEdit(SLabel,Sedit) then Exit;
  SLabel:=Label25.Caption; SEdit:=Edit25.Text;  if not SaveEdit(SLabel,Sedit) then Exit;


  SLabel:=Label28.Caption; SEdit:=Edit28.Text;  if not SaveEdit(SLabel,Sedit) then Exit;
  SLabel:=Label29.Caption; SEdit:=Edit29.Text;  if not SaveEdit(SLabel,Sedit) then Exit;
end;

procedure TFrm_SysConfig.BBCancelClick(Sender: TObject);
begin
  Close;
end;

procedure TFrm_SysConfig.FormClose(Sender: TObject;
  var Action: TCloseAction);
begin
  if screen.FormCount=2 then WebIsHide(0);
  QrySysconfig.Close;
  Action:=CaFree;
  Frm_Sysconfig:=nil;
end;

end.