coojdt.~pas

阀门厂的合同管理含销售 等

unit COOJDT;

interface

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

type
  TFormCOOJDT = class(TForm)
    Shape3: TShape;
    Label1: TLabel;
    DBEdit1: TDBEdit;
    Label2: TLabel;
    DBEdit2: TDBEdit;
    Shape1: TShape;
    Label4: TLabel;
    DBEdit3: TDBEdit;
    Shape2: TShape;
    Shape4: TShape;
    Label5: TLabel;
    DBEdit4: TDBEdit;
    Label6: TLabel;
    DBEdit5: TDBEdit;
    Shape5: TShape;
    Label7: TLabel;
    DBEdit6: TDBEdit;
    Shape6: TShape;
    Shape7: TShape;
    Label8: TLabel;
    DBEdit7: TDBEdit;
    Label9: TLabel;
    DBEdit8: TDBEdit;
    Shape8: TShape;
    Label10: TLabel;
    DBEdit9: TDBEdit;
    Shape9: TShape;
    Shape10: TShape;
    Label11: TLabel;
    DBEdit10: TDBEdit;
    DBCheckBox1: TDBCheckBox;
    DBCheckBox2: TDBCheckBox;
    PageControl1: TPageControl;
    TabSheet1: TTabSheet;
    Label3: TLabel;
    TabSheet2: TTabSheet;
    Shape11: TShape;
    DBEdit11: TDBEdit;
    Label12: TLabel;
    DBEdit12: TDBEdit;
    Shape12: TShape;
    Label13: TLabel;
    DBEdit13: TDBEdit;
    Shape13: TShape;
    Shape14: TShape;
    DBEdit14: TDBEdit;
    Label14: TLabel;
    Shape15: TShape;
    DBEdit15: TDBEdit;
    Label15: TLabel;
    DBEdit16: TDBEdit;
    Shape16: TShape;
    Label16: TLabel;
    Label17: TLabel;
    Shape17: TShape;
    DBEdit17: TDBEdit;
    Label18: TLabel;
    DBEdit18: TDBEdit;
    Shape18: TShape;
    Label19: TLabel;
    DBEdit19: TDBEdit;
    Shape19: TShape;
    Shape20: TShape;
    DBEdit20: TDBEdit;
    Label20: TLabel;
    Shape21: TShape;
    DBEdit21: TDBEdit;
    Label21: TLabel;
    DBEdit22: TDBEdit;
    Shape22: TShape;
    Label22: TLabel;
    DBGrid1: TDBGrid;
    Button1: TButton;
    Button2: TButton;
    DataSource1: TDataSource;
    DataSource2: TDataSource;
    Button3: TButton;
    procedure FormShow(Sender: TObject);
    procedure Button1Click(Sender: TObject);
    procedure Button3Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  FormCOOJDT: TFormCOOJDT;

implementation

uses DataHJ, mpub;

{$R *.dfm}

procedure TFormCOOJDT.FormShow(Sender: TObject);
begin
   try
     DataModHJ.ADOQuP3.Close;
     DataModHJ.ADOQuP3.SQL.Clear;
     DataModHJ.ADOQuP3.SQL.Add('select * from COOJDT where TransId=:P0');
     DataModHJ.ADOQuP3.Parameters[0].Value:=strtoint(CurrentParam.OrderNo);
     DataModHJ.ADOQuP3.Prepared;
     DataModHJ.ADOQuP3.Open;
     if DataModHJ.ADOQuP3.RecordCount>0 then
     begin
        button1.Caption:= '确定';
        DataModHJ.ADOQuP3.Edit;

     end
     else
     begin
     DataSource1.DataSet.Append;
     DBEdit1.Field.Value:=GetBH('select * from COOJDT');
     DBEdit4.Field.Value:=FormatDateTime('yyyy-mm-dd',date);
     DBEdit5.Field.Value:=FormatDateTime('yyyy-mm-dd',date);
     button1.Caption:= '添加';
     end;
   except
     exit;
   end;
   //DataSource1.DataSet.DisableControls;
   try
        DataModHJ.ADOQuP4.Close;
        DataModHJ.ADOQuP4.SQL.Clear;
        DataModHJ.ADOQuP4.SQL.Add('select * from COJDT1 where TransId=:P0');
        DataModHJ.ADOQuP4.Parameters[0].Value:=strtoint(CurrentParam.OrderNo);
        DataModHJ.ADOQuP4.Prepared;
        DataModHJ.ADOQuP4.Open;
        if DataModHJ.ADOQuP4.RecordCount>0 then
           DataModHJ.ADOQuP4.Edit
        else
        begin
           //DataModHJ.ADOQuP2.Append;
           //DataModHJ.ADOQuP2.FieldValues['DocNum']:=DBEdit10.Field.Value;
        end;
   except
        exit;
   end;
end;

procedure TFormCOOJDT.Button1Click(Sender: TObject);
begin
   close;

end;

procedure TFormCOOJDT.Button3Click(Sender: TObject);
begin
   if DBEdit1.Field.Value>0 then
   begin
      DataModHJ.ADOQuP4.Append;
      DataModHJ.ADOQuP4.FieldValues['TransId']:=DBEdit1.Field.Value;
   end;
end;

end.