urw.pas

一个地方税务征收管理系统

unit urw;

interface

uses Windows, SysUtils, Classes, Graphics, Forms, Controls, StdCtrls,
  Buttons, ExtCtrls, dialogs, Grids, DBGridEhImpExp, DBGridEh, Menus, ComCtrls;

type
  Trw = class(TForm)
    Panel1: TPanel;
    treeview1: TTreeView;
    Splitter1: TSplitter;
    Panel2: TPanel;
    DBGridEh1: TDBGridEh;
    Panel3: TPanel;
    Button1: TButton;
    BitBtn5: TBitBtn;
    BitBtn3: TBitBtn;
    SaveDialog1: TSaveDialog;
    Panel4: TPanel;
    Button2: TButton;
    procedure CancelBtnClick(Sender: TObject);
    procedure FormCreate(Sender: TObject);
    procedure N2Click(Sender: TObject);
    procedure Button1Click(Sender: TObject);
    procedure BitBtn3Click(Sender: TObject);
    procedure BitBtn5Click(Sender: TObject);

    procedure add_tv;
    procedure treeview1Click(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure FormCloseQuery(Sender: TObject; var CanClose: Boolean);
    procedure Button2Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  rw: Trw;

implementation

uses DB, u_dm, ADODB, urw_edit, u_main, ushe, frm_dbgrideh_print_set,
  RICH_SYS;

{$R *.dfm}

procedure Trw.CancelBtnClick(Sender: TObject);
begin
  close;
end;

procedure Trw.FormCreate(Sender: TObject);
begin
  if FileExists(main.App_path + 'rw.txt') then
    TreeView1.LoadFromFile(main.App_path + 'rw.txt');

  with dm1.A_rw do
  begin
    if not Active then
    begin
      Close;
      Parameters.ParamByName('acount_id').Value := strtoint(main.Acount_id);
      Parameters.ParamByName('she').Value := '%';
      open;
    end;
  end;
  if main.Load_grid_enable then
    if FileExists(main.dat_path + 'rw.dat') then
      DBGridEh1.Columns.LoadFromFile(main.dat_path + 'rw.dat');
end;

procedure Trw.N2Click(Sender: TObject);
begin
  if MessageDlg('真的准备删除该农户吗？', mtWarning, mbOKCancel, 0) = idok then
    dm1.A_Person.Delete;
end;

procedure Trw.Button1Click(Sender: TObject);
var
  t: Trw_edit;
begin
  t := Trw_edit.Create(self);
  t.Show;
end;

procedure Trw.BitBtn3Click(Sender: TObject);
var
  s: string;
begin
  s := main.dw + main.ACOUNT_YEAR + '年农户任务下达表';
  with Tdbgrideh_print.Create(self) do
  begin
    PrintDBGridEh1.DBGridEh := DBGridEh1;
    L_TITLE_CENTER.Caption := s;
    s := '报表时间：' + DateToStr(Date);
    L_GRIDE_BEFOR.Caption := s;
    ShowModal;
  end;
end;

procedure Trw.BitBtn5Click(Sender: TObject);
begin
  if SaveDialog1.Execute then
  begin
    if SaveDialog1.FileName <> '' then
    begin
      if UpperCase(Copy(SaveDialog1.FileName, Length(SaveDialog1.FileName) -
        2, 3)) <> 'XLS' then
        SaveDialog1.FileName := SaveDialog1.FileName + '.XLS';

      SaveDBGridEhToExportFile(TDBGridEhExportAsXLS, DBGridEh1,
        SaveDialog1.FileName, true);

      MessageDlg('网格数据已成功导出到文件！', mtWarning, [mbok], 0);
    end;
  end;
end;

procedure Trw.add_tv;
var
  tvNode, tvnode2, tvnode3: TTreeNode;
  cun, she, s: string;
begin
  dm1.Open_Q1('select distinct left(she_no,2) as cun from she');
  with TreeView1, dm1 do
  begin
    Items.Clear;
    q_1.First;
    tvNode := Items.Add(nil, '所有村');
    while not Q_1.Eof do
    begin
      cun := trim(Q_1.fieldbyname('cun').AsString);
      tvnode2 := Items.AddChild(tvNode, cun + '村');
      s := 'select substring(she_no,3,1) as she,she_name,she_master from she where left(she_no,2)='
        + string_sqlText(cun);
      dm1.Open_Q2(s);
      while not q_2.Eof do
      begin
        she := trim(Q_2.fieldbyname('she').AsString);
        s := she + '社(' + trim(Q_2.fieldbyname('she_name').AsString) + ':社长：'
          + trim(Q_2.fieldbyname('she_master').AsString) + ')';
        tvnode3 := Items.AddChild(tvNode2, s);
        q_2.Next;
      end;
      Q_1.Next;
    end;
  end;
end;

procedure Trw.treeview1Click(Sender: TObject);
var
  s, she, n_l: string;
  Mnode: TTreeNode;
begin

  case TreeView1.Selected.Level of
    3:
      begin
        n_l := TreeView1.Selected.Text;

        Mnode := TreeView1.Selected.Parent;
        she := LeftStr(Mnode.Text, 1);

        Mnode := Mnode.Parent;
        she := LeftStr(Mnode.Text, 2) + she;

        s := 'name like ' + string_sqlText(n_l + '%') +
          ' and pno like ' + string_sqlText(she + '%');
        //   MessageDlg(s, mtWarning, [mbok], 0);
      end;
    2:
      begin
        she := LeftStr(TreeView1.Selected.Text, 1);
        Mnode := TreeView1.Selected.Parent;
        she := LeftStr(Mnode.Text, 2) + she;
        s := 'pno like ' + string_sqlText(she + '%');
      end;
    1:
      begin
        she := LeftStr(TreeView1.Selected.Text, 2);
        s := 'pno like ' + string_sqlText(she + '%');
      end;
    0:
      begin
        s := '';
      end;
  end;
  dm1.a_rw.Filter := s;
  dm1.A_rw.Filtered := true;
end;

procedure Trw.FormClose(Sender: TObject; var Action: TCloseAction);
begin
  Action := caFree;
end;

procedure Trw.FormCloseQuery(Sender: TObject; var CanClose: Boolean);
begin
  if main.Load_grid_enable then
    DBGridEh1.Columns.SaveToFile(main.dat_path + 'rw.dat');
end;

procedure Trw.Button2Click(Sender: TObject);
begin
  main.add_tv(treeview1);
  TreeView1.SaveToFile(main.App_path + 'rw.txt');
end;

end.