zhtsunit.pas

小区物业管理(delphi+sql server)源代码

unit ZHTSUnit;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, ComCtrls, ToolWin, ExtCtrls, StdCtrls, DBCtrls, Mask, Grids,
  DBGrids, Buttons;

type
  TZHTSForm = class(TForm)
    Panel1: TPanel;
    Panel2: TPanel;
    Panel3: TPanel;
    ToolBar1: TToolBar;
    DBGrid1: TDBGrid;
    TS_ID: TDBEdit;
    TS_User: TDBEdit;
    User_ID: TDBEdit;
    TS_date: TDBEdit;
    TS_JD: TDBEdit;
    TS_Com: TDBEdit;
    Com_Person: TDBEdit;
    TS_Memo: TDBMemo;
    Com_Memo: TDBMemo;
    Label1: TLabel;
    Label3: TLabel;
    Label5: TLabel;
    btadd: TBitBtn;
    btno1: TBitBtn;
    btok: TBitBtn;
    Btdel: TBitBtn;
    BitBtn1: TBitBtn;
    BitBtn2: TBitBtn;
    procedure btno1Click(Sender: TObject);
    procedure btaddClick(Sender: TObject);
    procedure btokClick(Sender: TObject);
    procedure BtdelClick(Sender: TObject);
    procedure BitBtn1Click(Sender: TObject);
    procedure BitBtn2Click(Sender: TObject);
  private
   { Private declarations }
  public
    function checkdata: boolean; //检查输入的数据是否符合要求
    { Public declarations }
  end;

var
  ZHTSForm: TZHTSForm;

implementation

uses Umain, Udm, dateUnit;

{$R *.dfm}



function TZHTSForm.checkdata: boolean;
begin
  result := true;
  if trim(TS_ID.Text) = '' then
  begin
    showmessage('投诉编号不能为空!');
    result := false;
    TS_ID.SetFocus;
    exit;
  end;

  if trim(TS_User.Text) = '' then
  begin
    showmessage('投诉用户不能为空!');
    result := false;
    TS_User.SetFocus;
    exit;
  end;

  if trim(User_ID.Text) = '' then
  begin
    showmessage('住户编号不能为空!');
    result := false;
    User_ID.SetFocus;
    exit;
  end;
  if trim(TS_date.Text) = '' then
  begin
    showmessage('投诉日期不能为空!');
    result := false;
    TS_date.SetFocus;
    exit;
  end;
  if trim(TS_JD.Text) = '' then
  begin
    showmessage('接待人员不能为空!');
    result := false;
    TS_JD.SetFocus;
    exit;
  end;
   {if trim(TS_Com.Text)='' then
   begin
   showmessage('处理日期不能为空!');
   result:=false;
   TS_Com.SetFocus;
   exit;
   end; }
 {    if trim(Com_Person.Text)='' then
   begin
   showmessage('处理人员不能为空!');
   result:=false;
   Com_Person.SetFocus;
   exit;
   end;}

  if trim(TS_Memo.Text) = '' then
  begin
    showmessage('投诉内容不能为空!');
    result := false;
    TS_Memo.SetFocus;
    exit;
  end;
end;

procedure TZHTSForm.btno1Click(Sender: TObject);
begin
  try
    adodm.YHTS.Cancel;
    close;
  except
    showmessage('产生例外错误，请联系开发人员或者程序供应商');
  end;
end;


procedure TZHTSForm.btaddClick(Sender: TObject);
var NewID: string;
begin
  try
    adodm.YHTS.Last; //返到记录的最后一个
    NewID := IntToStr(adodm.YHTS.FieldByName('单据编号').AsInteger + 1); //新记录的编号
    adodm.YHTS.Append; //增加新记录
    TS_ID.Text := NewID; //把新记录的编号
  except
    showmessage('产生例外错误，请联系开发人员或者程序供应商');
  end;
end;

procedure TZHTSForm.btokClick(Sender: TObject);
begin
  try
    if checkdata then
      adodm.YHTS.Post;
    close;
  except
    showmessage('产生例外错误，请联系开发人员或者程序供应商');
  end;
end;

procedure TZHTSForm.BtdelClick(Sender: TObject);
begin
  if MessageDlg('您确定要删除录入的数据吗？', mtConfirmation, [mbYes, mbNo], 0) = mrYes then
  begin
    try
      adodm.YHTS.Delete;
    except
      showmessage('产生例外错误，请联系开发人员或者程序供应商');
    end;
  end;
end;

procedure TZHTSForm.BitBtn1Click(Sender: TObject);
begin
  Application.CreateForm(TdateForm, dateForm);
  if (dateForm.ShowModal = mrOk) then
  begin
    TS_date.Text := '';
    TS_date.Text := DateTimeToStr(dateForm.date1.date);
  end;
  dateForm.Free;
end;

procedure TZHTSForm.BitBtn2Click(Sender: TObject);
begin
  Application.CreateForm(TdateForm, dateForm);
  if (dateForm.ShowModal = mrOk) then
  begin
    TS_com.Text := '';
    TS_com.Text := DateTimeToStr(dateForm.date1.date);
  end;
  dateForm.Free;
end;

end.