D6HECHUAN/信息资源/u_info_render_manager.pas

unit u_info_render_manager;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, dxExEdtr, DB, ADODB, bsSkinCtrls, ExtCtrls, StdCtrls, ComCtrls,
  DBCtrls, bsdbctrls, Mask, dxDBTLCl, dxGrClms, dxDBCtrl, dxDBGrid, dxTL,
  dxCntner;

type
  Tfrm_info_render_manager = class(TForm)
    bsSkinPanel1: TbsSkinPanel;
    Panel1: TPanel;
    bsSkinButton10: TbsSkinButton;
    bsSkinButton2: TbsSkinButton;
    bsSkinButton5: TbsSkinButton;
    t_info_render: TADOQuery;
    t_info_render1: TDataSource;
    bsSkinButton1: TbsSkinButton;
    dxDBGrid1: TdxDBGrid;
    dxDBGrid1Column1: TdxDBGridMaskColumn;
    dxDBGrid1Column2: TdxDBGridMaskColumn;
    dxDBGrid1Column3: TdxDBGridMaskColumn;
    dxDBGrid1Column4: TdxDBGridDateColumn;
    dxDBGrid1Column5: TdxDBGridMaskColumn;
    dxDBGrid1Column6: TdxDBGridDateColumn;
    dxDBGrid1Column7: TdxDBGridMaskColumn;
    dxDBGrid1Column8: TdxDBGridDateColumn;
    bsSkinPanel2: TbsSkinPanel;
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    Label5: TLabel;
    Label6: TLabel;
    Label7: TLabel;
    DBEdit1: TDBEdit;
    DBEdit2: TDBEdit;
    DBEdit3: TDBEdit;
    DBEdit4: TDBEdit;
    DBEdit5: TDBEdit;
    DBEdit6: TDBEdit;
    DBEdit7: TDBEdit;
    bsSkinGroupBox2: TbsSkinGroupBox;
    DBRichEdit1: TDBRichEdit;
    bsSkinGroupBox3: TbsSkinGroupBox;
    DBRichEdit3: TDBRichEdit;
    bsSkinGroupBox1: TbsSkinGroupBox;
    DBRichEdit2: TDBRichEdit;
    bsSkinButton3: TbsSkinButton;
    bsSkinButton7: TbsSkinButton;
    bsSkinButton8: TbsSkinButton;
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure FormShow(Sender: TObject);
    procedure bsSkinButton5Click(Sender: TObject);
    procedure bsSkinButton2Click(Sender: TObject);
    procedure bsSkinButton4Click(Sender: TObject);
    procedure bsSkinButton10Click(Sender: TObject);
    procedure FormResize(Sender: TObject);
    procedure dxDBGrid1ColumnSorting(Sender: TObject;
      Column: TdxDBTreeListColumn; var Allow: Boolean);
    procedure dxDBGrid1Column1CustomDraw(Sender: TObject; ACanvas: TCanvas;
      ARect: TRect; ANode: TdxTreeListNode; AColumn: TdxDBTreeListColumn;
      const AText: String; AFont: TFont; var AColor: TColor; ASelected,
      AFocused: Boolean; var ADone: Boolean);
    procedure bsSkinButton1Click(Sender: TObject);
    procedure bsSkinButton3Click(Sender: TObject);
    procedure bsSkinButton7Click(Sender: TObject);
    procedure bsSkinButton8Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  frm_info_render_manager: Tfrm_info_render_manager;

implementation

uses u_main, u_info_render_query, my_sys_function, u_info_render_check;

{$R *.dfm}

procedure Tfrm_info_render_manager.FormClose(Sender: TObject;
  var Action: TCloseAction);
begin
  frm_info_render_manager.Hide;
  frm_info_render_manager.ManualFloat(frm_info_render_manager.BoundsRect );
  frm_main.freeTabs('frm_info_render_manager');
  action:=cafree;
  frm_info_render_manager:=nil;
end;

procedure Tfrm_info_render_manager.FormShow(Sender: TObject);
begin
  t_info_render.Close;
  t_info_render.sql.clear;
  t_info_render.sql.add('select * from t_info_render where '
                     +open_data('9002','<27>㱨<EFBFBD><E3B1A8>','no','no','no','no')
                     +' and <20><><EFBFBD><EFBFBD>״̬ in ('+''''+'<27>ύ<EFBFBD><E1BDBB><EFBFBD><EFBFBD>'+''''+','+''''+'<27><><EFBFBD><EFBFBD>ͨ<EFBFBD><CDA8>'+''''+')'
                     +' order by <20>㱨<EFBFBD><E3B1A8><EFBFBD><EFBFBD>');
  t_info_render.open;
end;

procedure Tfrm_info_render_manager.bsSkinButton5Click(Sender: TObject);
begin
  close;
end;

procedure Tfrm_info_render_manager.bsSkinButton2Click(Sender: TObject);
begin
  if (not if_open('020')) then
  begin
    showmessage('<27>Բ<EFBFBD><D4B2><EFBFBD><EFBFBD><EFBFBD>û<EFBFBD>д<EFBFBD>ģ<EFBFBD><C4A3><EFBFBD>IJ<EFBFBD><C4B2><EFBFBD>Ȩ<EFBFBD>ޣ<EFBFBD>');
    exit;
  end;

  if t_info_render.IsEmpty then
    exit;
  if t_info_render.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27>ύ<EFBFBD><E1BDBB><EFBFBD><EFBFBD>' then
  begin
    showmessage('<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>浱ǰ״̬<D7B4><CCAC><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>!!');
    exit;
  end;

  try
    frm_info_render_check:=tfrm_info_render_check.Create (self);
    frm_info_render_check.Hint:='1';
    frm_info_render_check.Caption:='<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>';
    frm_info_render_check.bsSkinGroupBox1.Caption:='<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>';
    frm_info_render_check.ShowModal;
  finally
    frm_info_render_check.Free;
    frm_info_render_check:=nil;
  end;
end;

procedure Tfrm_info_render_manager.bsSkinButton4Click(Sender: TObject);
begin
  if t_info_render.IsEmpty then
    exit;
  if not t_info_render.FieldByName('<27>Ƿ<EFBFBD><C7B7><EFBFBD><EFBFBD><EFBFBD>').asboolean then
  begin
    exit;
  end;
  t_info_render.Edit;
  t_info_render['<27>Ƿ<EFBFBD><C7B7><EFBFBD><EFBFBD><EFBFBD>']:=0;
  t_info_render.post;
end;

procedure Tfrm_info_render_manager.bsSkinButton10Click(Sender: TObject);
begin
  try
    frm_info_render_query:=tfrm_info_render_query.Create (self);
    frm_info_render_query.Hint:='2';
    frm_info_render_query.ShowModal;
  finally
    frm_info_render_query.Free;
  end;
end;

procedure Tfrm_info_render_manager.FormResize(Sender: TObject);
var
  i:integer;
begin
  i:=round(panel1.Width/7);
  bsSkinButton10.Width:=i;
  bsSkinButton7.Width:=i;
  bsSkinButton8.Width:=i;
  bsSkinButton2.Width:=i;
  bsSkinButton3.Width:=i;
  bsSkinButton1.Width:=i;
end;

procedure Tfrm_info_render_manager.dxDBGrid1ColumnSorting(Sender: TObject;
  Column: TdxDBTreeListColumn; var Allow: Boolean);
begin
  Column_sort(Column,t_info_render,'<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ŀ');
end;

procedure Tfrm_info_render_manager.dxDBGrid1Column1CustomDraw(
  Sender: TObject; ACanvas: TCanvas; ARect: TRect; ANode: TdxTreeListNode;
  AColumn: TdxDBTreeListColumn; const AText: String; AFont: TFont;
  var AColor: TColor; ASelected, AFocused: Boolean; var ADone: Boolean);
begin
  if ANode.Strings[dxDBGrid1Column1.Index]='¼<><C2BC>״̬' then
    AColor:=clWhite;
  if ANode.Strings[dxDBGrid1Column1.Index]='<27>ύ<EFBFBD><E1BDBB><EFBFBD><EFBFBD>' then
    AColor:=$0080FFFF;
  if ANode.Strings[dxDBGrid1Column1.Index]='<27><><EFBFBD><EFBFBD>ͨ<EFBFBD><CDA8>' then
    AColor:=$0000FF80;
  if ANode.Strings[dxDBGrid1Column1.Index]='<27><><EFBFBD><EFBFBD>ͨ<EFBFBD><CDA8>' then
    AColor:=clAqua;
  AFont.Color:=clblack;
end;

procedure Tfrm_info_render_manager.bsSkinButton1Click(Sender: TObject);
begin
  sys_print('<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ӡ',2,t_info_render1,nil,nil,nil,nil,nil,nil,nil,nil,nil,nil);
end;

procedure Tfrm_info_render_manager.bsSkinButton3Click(Sender: TObject);
begin
  if (not if_open('214')) then
  begin
    showmessage('<27>Բ<EFBFBD><D4B2><EFBFBD><EFBFBD><EFBFBD>û<EFBFBD>д<EFBFBD>ģ<EFBFBD><C4A3><EFBFBD>IJ<EFBFBD><C4B2><EFBFBD>Ȩ<EFBFBD>ޣ<EFBFBD>');
    exit;
  end;

  if t_info_render.IsEmpty then
    exit;
  if (t_info_render.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27>ύ<EFBFBD><E1BDBB><EFBFBD><EFBFBD>')
  and(t_info_render.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD><EFBFBD>ͨ<EFBFBD><CDA8>') then
  begin
    showmessage('<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>浱ǰ״̬<D7B4><CCAC><EFBFBD>ܸ<EFBFBD><DCB8><EFBFBD>!!');
    exit;
  end;

  try
    frm_info_render_check:=tfrm_info_render_check.Create (self);
    frm_info_render_check.Hint:='2';
    frm_info_render_check.Caption:='<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>渴<EFBFBD><E6B8B4>';
    frm_info_render_check.bsSkinGroupBox1.Caption:='<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>';
    frm_info_render_check.ShowModal;
  finally
    frm_info_render_check.Free;
    frm_info_render_check:=nil;
  end;
end;

procedure Tfrm_info_render_manager.bsSkinButton7Click(Sender: TObject);
begin
  t_info_render.close;
  t_info_render.sql.clear;
  t_info_render.SQL.add('select * from t_info_render where '
                     +open_data('9002','<27>㱨<EFBFBD><E3B1A8>','no','no','no','no')+
                     ' and <20><><EFBFBD><EFBFBD>״̬='+''''+'<27>ύ<EFBFBD><E1BDBB><EFBFBD><EFBFBD>'+''''
                     +' order by <20>㱨<EFBFBD><E3B1A8><EFBFBD><EFBFBD>');
  t_info_render.open;
end;

procedure Tfrm_info_render_manager.bsSkinButton8Click(Sender: TObject);
begin
  t_info_render.close;
  t_info_render.sql.clear;
  t_info_render.SQL.add('select * from t_info_render where '
                     +open_data('9002','<27>㱨<EFBFBD><E3B1A8>','no','no','no','no')+
                     ' and <20><><EFBFBD><EFBFBD>״̬ in('+''''+'<27>ύ<EFBFBD><E1BDBB><EFBFBD><EFBFBD>'+''''
                     +','+''''+'<27><><EFBFBD><EFBFBD>ͨ<EFBFBD><CDA8>'+''''+')'+' order by <20>㱨<EFBFBD><E3B1A8><EFBFBD><EFBFBD>');
  t_info_render.open;
end;

end.