unit modits;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, StdCtrls, ComCtrls, ExtCtrls, DB, DBTables;

type
  Tmodits_Form = class(TForm)
    Label1: TLabel;
    name_LEdit: TLabeledEdit;
    fzr_LEdit: TLabeledEdit;
    bz_LEdit: TLabeledEdit;
    rq_DTP: TDateTimePicker;
    cmdok: TButton;
    cmdclose: TButton;
    procedure FormCreate(Sender: TObject);
    procedure cmdokClick(Sender: TObject);
    procedure cmdcloseClick(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  modits_Form: Tmodits_Form;

implementation

uses tsgl;

{$R *.dfm}

procedure Tmodits_Form.FormCreate(Sender: TObject);
begin
    Caption:=tsgl_form.xcaption;
    //如果此時為修改窗體，則將選擇的信息賦予對應的控件顯示
    if tsgl_form.modi then
    begin
        name_ledit.Text:=tsgl_form.Query1.fieldbyname('name').AsString;
        fzr_ledit.Text:=tsgl_form.Query1.fieldbyname('fzr').AsString;
        bz_ledit.Text:=tsgl_form.Query1.fieldbyname('bz').AsString;
        rq_dtp.DateTime:=tsgl_form.Query1.fieldbyname('rq').AsDateTime;
    end;
end;

procedure Tmodits_Form.cmdokClick(Sender: TObject);
var
    id,name,bz,rq,fzr,sqlstr:string;
begin
    if MessageDlg('確認要'+tsgl_form.xcaption+'記錄碼?',mtConfirmation, [mbYes, mbNo], 0) = mrYes then
    begin
        name:=trim(name_LEdit.Text);
        if length(name)<1 then
        begin
            ShowMessage('請輸入投訴人');
            exit;
        end;
        bz:=trim(bz_LEdit.Text);
        if length(bz)<1 then
        begin
            ShowMessage('請輸入投訴內容');
            exit;
        end;
        rq:=datetostr(rq_DTP.Date);
        fzr:=trim(fzr_LEdit.Text);
        if length(fzr)<1 then
        begin
            ShowMessage('請輸入負責人');
            exit;
        end;
        if tsgl_form.modi then
        begin
            id:=tsgl_form.Query1.fieldbyname('id').AsString;
            sqlstr:='update t_tsb set name='''+name+''',bz='''+bz+''',fzr='''+fzr;
            sqlstr:=sqlstr+''',rq='''+rq+''' where(id='''+id+''')';
        end
        else
        begin
            sqlstr:='insert into t_tsb(name,bz,rq,fzr) values('''+name+''',''';
            sqlstr:=sqlstr+bz+''','''+rq+''','''+fzr+''')''';
        end;
        with tquery.Create(nil) do
        begin
            try
            Close;
            SQL.Clear;
            SQL.Add(sqlstr);
            ExecSQL;
            finally
            Free;
            end;
        end;
        Close;
        tsgl_form.cmdok.Click;
    end;
end;

procedure Tmodits_Form.cmdcloseClick(Sender: TObject);
begin
    Close;
end;

end.