coopwz.~pas

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

unit COOPWZ;

interface

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

type
  TFormCOOPWZ = class(TForm)
    PageControl1: TPageControl;
    TabSheet1: TTabSheet;
    TabSheet2: TTabSheet;
    TabSheet3: TTabSheet;
    TabSheet4: TTabSheet;
    Label1: TLabel;
    DBEdit1: TDBEdit;
    DBEdit2: TDBEdit;
    Label2: TLabel;
    Shape2: TShape;
    Shape1: TShape;
    DBEdit11: TDBEdit;
    Label12: TLabel;
    Shape11: TShape;
    Label11: TLabel;
    Shape10: TShape;
    Button1: TButton;
    Button2: TButton;
    Label3: TLabel;
    Shape3: TShape;
    DataSource1: TDataSource;
    DBEdit3: TDBEdit;
    Edit1: TEdit;
    procedure Button1Click(Sender: TObject);
    procedure Edit1Exit(Sender: TObject);
    procedure FormShow(Sender: TObject);
    procedure Button2Click(Sender: TObject);
  private
    { Private declarations }
    Paid:Double;
    procedure COOJDTPost(Sender: TObject);

  public
    { Public declarations }
  end;

var
  FormCOOPWZ: TFormCOOPWZ;

implementation

uses DataHJ, mpub;
{$R *.dfm}

procedure TFormCOOPWZ.Button1Click(Sender: TObject);
begin
   DataSource1.DataSet.EnableControls;
   if  Button1.Caption='确定' then
   begin
    DataSource1.DataSet.Edit;
    DataSource1.DataSet.Post;
    COOJDTPost(Sender);
    close;
   end;
   if  Button1.Caption='更新' then
   begin
    DataSource1.DataSet.Edit;
    DataSource1.DataSet.Post;
    Button1.Caption:='确定';
   end;
   if  Button1.Caption='添加' then
   begin
    DataSource1.DataSet.Edit;
    DataSource1.DataSet.Post;
    Button1.Caption:='确定';
   end;
end;

procedure TFormCOOPWZ.Edit1Exit(Sender: TObject);
begin
   DBEdit11.Field.Value:=Paid+strtoFloat(Edit1.Text);
   DBEdit2.Field.Value:=DBEdit1.Field.Value-DBEdit11.Field.Value;
end;

procedure TFormCOOPWZ.FormShow(Sender: TObject);
begin
   try
     DataModHJ.ADOQuP3.Close;
     DataModHJ.ADOQuP3.SQL.Clear;
     DataModHJ.ADOQuP3.SQL.Add('select * from SDOINV where DocNum=:P0');
     DataModHJ.ADOQuP3.Parameters[0].Value:=(CurrentParam.OrderNo);
     DataModHJ.ADOQuP3.Prepared;
     DataModHJ.ADOQuP3.Open;
     if DataModHJ.ADOQuP3.RecordCount>0 then
     begin
        button1.Caption:= '添加';
        DataModHJ.ADOQuP3.Edit;
        Paid:=DBEdit11.Field.Value;

     end;
   except
     exit;
   end;

end;

procedure TFormCOOPWZ.COOJDTPost(Sender: TObject);
var
   TransId:integer;
begin
   try
     DataModHJ.ADOQP0.Close;
     DataModHJ.ADOQP0.SQL.Clear;
     DataModHJ.ADOQP0.SQL.Add('select * from COOJDT');
     //DataModHJ.ADOQP0.Parameters[0].Value:=(CurrentParam.OrderNo);
     DataModHJ.ADOQP0.Prepared;
     DataModHJ.ADOQP0.Open;

     DataModHJ.ADOQP0.Append;
     DataModHJ.ADOQP0.FieldValues['TransId']:=GetBH('select * from COOJDT');
     TransId:= DataModHJ.ADOQP0.FieldValues['TransId'];
     //DataModHJ.ADOQP0.FieldValues['RefDate']
     //DataModHJ.ADOQP0.FieldValues['VatDate']:=
     DataModHJ.ADOQP0.FieldValues['BaseRef']:=(CurrentParam.OrderNo);
     //DataModHJ.ADOQP0.FieldValues['LocTotal']:=
     //DataModHJ.ADOQP0.FieldValues['Memo']:=
     DataModHJ.ADOQP0.Post;

     DataModHJ.ADOQP0.Close;
     DataModHJ.ADOQP0.SQL.Clear;
     DataModHJ.ADOQP0.SQL.Add('select * from COJDT1');
     //DataModHJ.ADOQP0.Parameters[0].Value:=(CurrentParam.OrderNo);
     DataModHJ.ADOQP0.Prepared;
     DataModHJ.ADOQP0.Open;

     DataModHJ.ADOQP0.Append;
     DataModHJ.ADOQP0.FieldValues['TransId']:=TransId;
     DataModHJ.ADOQP0.FieldValues['Account']:=DBEDit3.Field.value;
     DataModHJ.ADOQP0.FieldValues['Debit']:=strtoFloat(EDit1.Text);
     DataModHJ.ADOQP0.FieldValues['Credit']:=0;
     DataModHJ.ADOQP0.FieldValues['DueDate']:=DataModHJ.ADOQuP3.FieldValues['DocDate'];
     DataModHJ.ADOQP0.Post;
     DataModHJ.ADOQP0.Close;
   except
     exit;
   end;
end;

procedure TFormCOOPWZ.Button2Click(Sender: TObject);
begin
   DataSource1.DataSet.Cancel;
   Close;
end;

end.