fukanmx.pas

完整的公司合同管理系统,基于ACSESS数据库开发,无须安装任何其他插件.附带源码.免费提供.

unit FuKanMX;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, Buttons, ComCtrls, ExtCtrls, StdCtrls, DB, ADODB, Grids, DBGrids;

type
  TfrmWJ_FuKanMX = class(TForm)
    Label2: TLabel;
    ComboBox1: TComboBox;
    Button1: TButton;
    PageControl1: TPageControl;
    TabSheet1: TTabSheet;
    Image1: TImage;
    Label1: TLabel;
    BitBtn2: TBitBtn;
    DBGrid1: TDBGrid;
    ADOQuery1: TADOQuery;
    ADOQuery1ID: TWideStringField;
    ADOQuery1SHIJ: TDateTimeField;
    ADOQuery1JINE: TIntegerField;
    DataSource1: TDataSource;
    BitBtn5: TBitBtn;
    BitBtn4: TBitBtn;
    BitBtn3: TBitBtn;
    BitBtn1: TBitBtn;
    procedure Button1Click(Sender: TObject);
    procedure BitBtn3Click(Sender: TObject);
    procedure BitBtn5Click(Sender: TObject);
    procedure BitBtn4Click(Sender: TObject);
    procedure ADOQuery1AfterInsert(DataSet: TDataSet);
    procedure ComboBox1Change(Sender: TObject);
    procedure DBGrid1EditButtonClick(Sender: TObject);
    procedure FormCloseQuery(Sender: TObject; var CanClose: Boolean);
    procedure ADOQuery1AfterPost(DataSet: TDataSet);
    procedure ADOQuery1BeforeEdit(DataSet: TDataSet);
    procedure BitBtn1Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
    StrL : TStringList;
    tHtID,tHtName,tWtf : string;
    procedure Init(const HtID,HtName : string);
    procedure GetFuKuanData(const HtID : string;const ADOQuery1 : TADOQuery) ;
  end;
  procedure FuKuanMX(const HtID,HtName : string) ;
var
  frmWJ_FuKanMX: TfrmWJ_FuKanMX;

implementation
  uses pdm,pub,Pub_ChooseHT,Pub_ChooseDate,ZJMXPrint;
{$R *.dfm}
procedure TfrmWJ_FuKanMX.Init(const HtID,HtName : string);
begin
   tHtID := HtID;
   tHtName := HtName;
end;

procedure FuKuanMX(const HtID,HtName : string) ;
begin
  Application.CreateForm(TfrmWJ_FuKanMX,frmWJ_FuKanMX);
  with frmWJ_FuKanMX do
       begin
           Init(HtID,HtName);
           CreateStringList(HtID , HtName ,StrL , ComBobox1);
           GetFuKuanData( HtID, ADOQuery1) ;
           ShowModal;
       end;

end;

procedure TfrmWJ_FuKanMX.GetFuKuanData(const HtID : string;const ADOQuery1 : TADOQuery) ;
var SqlText : string;
begin
  SqlText := ' select * from FK where ID= '+#39+HtID+#39+' order by SHIJ';
  HeTong_GetQueryData(SqlText,ADOQuery1);
end;

procedure TfrmWJ_FuKanMX.Button1Click(Sender: TObject);
   function Check(const HtName : string) : boolean ;
     var i : integer;
     begin
       result := true;
       for i:=0 to StrL.Count-1 do begin
         if SameText(StrL.Names[i],HtName) then begin
            result:=false;
            ComBobox1.Text := HtName;
            Abort;
         end;
       end;
     end;

var HtID,HtName : string;
begin
  if GetHtID(HtID,HtName) then begin
     GetFuKuanData( HtID, ADOQuery1) ;
     if Check(HtName) then begin
        AddStringList(HtID , HtName ,StrL , ComBobox1);
        tHtID:=HtID;
        tHtName:=HtName;
     end;
     end;
end;

procedure TfrmWJ_FuKanMX.BitBtn3Click(Sender: TObject);
begin
  ADOQuery1.Insert;
end;

procedure TfrmWJ_FuKanMX.BitBtn5Click(Sender: TObject);
begin
  if ADOQuery1.State in[dsInsert,dsEdit] then
     ADOQuery1.Post;
end;

procedure TfrmWJ_FuKanMX.BitBtn4Click(Sender: TObject);
begin
  ADOQuery1.Delete;
end;

procedure TfrmWJ_FuKanMX.ADOQuery1AfterInsert(DataSet: TDataSet);
begin
  ADOQuery1.FieldByName('ID').AsString := Strl.Values[ComboBox1.Text];
end;

procedure TfrmWJ_FuKanMX.ComboBox1Change(Sender: TObject);
begin
  GetFuKuanData(Strl.Values[ComboBox1.Text], ADOQuery1) ;
  tHtID := Strl.Values[ComboBox1.Text] ;
  tHtName :=ComboBox1.Text ;
end;

procedure TfrmWJ_FuKanMX.DBGrid1EditButtonClick(Sender: TObject);
var tDate : string;
begin
  if ChooseDate(tDate) then
     begin
          ADOQuery1.Edit;
          ADOQuery1.FieldByName('SHIJ').AsString:=tDate;
     end;

end;

procedure TfrmWJ_FuKanMX.FormCloseQuery(Sender: TObject;
  var CanClose: Boolean);
begin
  if ADOQuery1.State in[dsInsert,dsEdit] then
     if Application.MessageBox(PChar('数据修改是否保存?'),'提示',MB_YESNO+MB_ICONQUESTION)=IDYES then
        ADOQuery1.Post;
end;

procedure TfrmWJ_FuKanMX.ADOQuery1AfterPost(DataSet: TDataSet);
begin
  ADOQuery1JINE.DisplayFormat := '￥#.##';
end;

procedure TfrmWJ_FuKanMX.ADOQuery1BeforeEdit(DataSet: TDataSet);
begin
   if DbGrid1.Columns.Grid.SelectedIndex = 1 then
      ADOQuery1JINE.DisplayFormat := '';
end;

procedure TfrmWJ_FuKanMX.BitBtn1Click(Sender: TObject);
begin
  FuKuanMXPrint(tHtID,tHtName);
end;

end.