cooipf.pas

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

unit COOIPF;

interface

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

type
  TFormCOOIPF = class(TForm)
    Label11: TLabel;
    Label1: TLabel;
    Label2: TLabel;
    DBEdit2: TDBEdit;
    DBEdit1: TDBEdit;
    Shape2: TShape;
    Shape1: TShape;
    Label12: TLabel;
    Label13: TLabel;
    Label14: TLabel;
    Label15: TLabel;
    Shape14: TShape;
    Shape6: TShape;
    Shape12: TShape;
    Shape11: TShape;
    Shape10: TShape;
    DBEdit10: TDBEdit;
    DBEdit11: TDBEdit;
    DBEdit12: TDBEdit;
    DBEdit13: TDBEdit;
    DBEdit14: TDBEdit;
    PageControl1: TPageControl;
    TabSheet1: TTabSheet;
    TabSheet2: TTabSheet;
    TabSheet3: TTabSheet;
    Button1: TButton;
    Button2: TButton;
    Label3: TLabel;
    Shape13: TShape;
    Label4: TLabel;
    Shape3: TShape;
    Label5: TLabel;
    Shape15: TShape;
    DBGrid2: TDBGrid;
    Button3: TButton;
    Button4: TButton;
    DataSource1: TDataSource;
    DataSource2: TDataSource;
    DataSource3: TDataSource;
    Image1: TImage;
    Button5: TButton;
    DBGrid1: TDBGrid;
    Edit1: TEdit;
    Edit2: TEdit;
    Edit3: TEdit;
    TabSheet4: TTabSheet;
    TabSheet5: TTabSheet;
    TabSheet6: TTabSheet;
    TabSheet7: TTabSheet;
    TabSheet8: TTabSheet;
    DBGrid3: TDBGrid;
    DBGrid4: TDBGrid;
    DBGrid5: TDBGrid;
    DBGrid6: TDBGrid;
    DBGrid7: TDBGrid;
    Button6: TButton;
    Button7: TButton;
    Button8: TButton;
    Button9: TButton;
    Button10: TButton;
    Button11: TButton;
    Button12: TButton;
    Button13: TButton;
    Button14: TButton;
    Button15: TButton;
    Label6: TLabel;
    Label7: TLabel;
    Shape4: TShape;
    Label8: TLabel;
    Shape5: TShape;
    Label9: TLabel;
    Shape7: TShape;
    Label10: TLabel;
    Shape8: TShape;
    Label16: TLabel;
    Shape9: TShape;
    Label17: TLabel;
    Shape16: TShape;
    DBEdit3: TDBEdit;
    DBEdit4: TDBEdit;
    DBEdit5: TDBEdit;
    DBEdit6: TDBEdit;
    DBEdit7: TDBEdit;
    DBEdit8: TDBEdit;
    ADOQuP1: TADOQuery;
    ADOQuP2: TADOQuery;
    procedure Button1Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure FormShow(Sender: TObject);
    procedure DBEdit1Exit(Sender: TObject);
    procedure Image1Click(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure Button4Click(Sender: TObject);
    procedure Button5Click(Sender: TObject);
    procedure DBEdit1Change(Sender: TObject);
    procedure TabSheet2Show(Sender: TObject);
    procedure TabSheet2Exit(Sender: TObject);
    procedure TabSheet4Show(Sender: TObject);
    procedure TabSheet5Show(Sender: TObject);
    procedure TabSheet4Exit(Sender: TObject);
  private
    { Private declarations }
    procedure DataShow(Sender: TObject;str:string);
  public
    { Public declarations }
  end;

var
  FormCOOIPF: TFormCOOIPF;

implementation

uses DataHJ,Mpub;

{$R *.dfm}

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

procedure TFormCOOIPF.Button2Click(Sender: TObject);
begin

   Close;
end;

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

        DataModHJ.ADOQuP3.Close;
        DataModHJ.ADOQuP3.SQL.Clear;
        DataModHJ.ADOQuP3.SQL.Add('select * from SDRDR1 where DocNum=:P0');
        DataModHJ.ADOQuP3.Parameters[0].Value:=(CurrentParam.OrderNo);
        DataModHJ.ADOQuP3.Prepared;
        DataModHJ.ADOQuP3.Open;

     end
     else
     begin
     DataSource1.DataSet.Append;
     //DBEdit10.Field.Value:=GetBH('select * from COOIPF');
     DBEdit11.Field.Value:=FormatDateTime('yyyy-mm-dd',date);
     DBEdit12.Field.Value:=FormatDateTime('yyyy-mm-dd',date+10);
     button1.Caption:= '添加';
     end;
   except
     exit;
   end;
   //DataSource1.DataSet.DisableControls;
   try
        ADOQuP2.Close;
        ADOQuP2.SQL.Clear;
        ADOQuP2.SQL.Add('select * from COIPF2 where DocNum=:P0');
        ADOQuP2.Parameters[0].Value:=(CurrentParam.OrderNo);
        ADOQuP2.Prepared;
        ADOQuP2.Open;
        if ADOQuP2.RecordCount>0 then
           ADOQuP2.Edit
        else
        begin
           //ADOQuP2.Append;
           //ADOQuP2.FieldValues['DocNum']:=DBEdit10.Field.Value;
        end;
   except
        exit;
   end;


end;

procedure TFormCOOIPF.DBEdit1Exit(Sender: TObject);
var
   aFac:string;
begin
   aFac :=DBEdit1.Text;
   //DataSource1.DataSet.EnableControls;

   try
     DataModHJ.ADOQuP0.Close;
     DataModHJ.ADOQuP0.SQL.Clear;
     DataModHJ.ADOQuP0.SQL.Add('select * from SDOCRD where CardCode=:P0');
     DataModHJ.ADOQuP0.Parameters[0].Value:=aFac;
     DataModHJ.ADOQuP0.Prepared;
     DataModHJ.ADOQuP0.Open;
     if DataModHJ.ADOQuP0.RecordCount>0 then
     begin
        DBEdit2.Field.value:=DataModHJ.ADOQuP0.FieldValues['CardName'];
                
     end;
     DataModHJ.ADOQuP0.Close;
   except
     exit;
   end;

end;

procedure TFormCOOIPF.Image1Click(Sender: TObject);
begin
   if DBEdit1.Field.Value<>null then
      DBEdit1.Field.Value:=GetCardCode(DBEdit1.Field.Value)
   else
      DBEdit1.Field.Value:=GetCardCode('');
   DBEdit1Exit(Sender);
end;

procedure TFormCOOIPF.FormClose(Sender: TObject; var Action: TCloseAction);
begin
   try
   DataSource1.DataSet.Close;
   DataSource2.DataSet.Close;
   except
   exit;
   end;
end;

procedure TFormCOOIPF.Button4Click(Sender: TObject);
begin
   try
     DataSource2.DataSet.Append;
     DataSource2.DataSet.FieldValues['DocNum']:=DBEdit10.Field.Value;
   except
     exit;
   end;
end;

procedure TFormCOOIPF.Button5Click(Sender: TObject);
begin
  //更新物料和编号等
   try
        DataModHJ.ADOQuP3.Close;
        DataModHJ.ADOQuP3.SQL.Clear;
        DataModHJ.ADOQuP3.SQL.Add('select * from SDSLOR where DocNum=:P0');
        DataModHJ.ADOQuP3.Parameters[0].Value:=DBEdit14.Field.Value;
        DataModHJ.ADOQuP3.Prepared;
        DataModHJ.ADOQuP3.Open;
        if  DataModHJ.ADOQuP3.RecordCount>0 then
        begin
           //Edit1.Text:=DataModHJ.ADOQuP3.FieldValues['Rounding'];
           Edit2.Text:=DataModHJ.ADOQuP3.FieldValues['VatSum'];
           Edit3.Text:=DataModHJ.ADOQuP3.FieldValues['DocTotal'];
           Edit1.Text:=DataModHJ.ADOQuP3.FieldValues['DocTotal']-DataModHJ.ADOQuP3.FieldValues['VatSum'];
        end;

        DataModHJ.ADOQuP3.Close;
        DataModHJ.ADOQuP3.SQL.Clear;
        DataModHJ.ADOQuP3.SQL.Add('select * from SDRDR1 where DocNum=:P0');
        DataModHJ.ADOQuP3.Parameters[0].Value:=DBEdit14.Field.Value;
        DataModHJ.ADOQuP3.Prepared;
        DataModHJ.ADOQuP3.Open;

        DataSource3.DataSet.DisableControls;

   except
        exit;
   end;
end;

procedure TFormCOOIPF.DBEdit1Change(Sender: TObject);
begin
   if DBEdit1.text<>'' then
      Button5.Enabled:=true
   else
      Button5.Enabled:=False;
end;

procedure TFormCOOIPF.TabSheet2Show(Sender: TObject);
begin
   DataShow(Sender,'select * from COIPF2 where DocNum=:P0');
   DataSource2.DataSet.EnableControls;
   DBgrid2.DataSource:=DataSource2;
end;

procedure TFormCOOIPF.TabSheet2Exit(Sender: TObject);
begin
   if DataSource2.DataSet.State=dsEdit then
      DataSource2.DataSet.Post;
   DataSource2.DataSet.DisableControls;
end;

procedure TFormCOOIPF.DataShow(Sender: TObject;str:string);
begin
   try
        ADOQuP2.Close;
        ADOQuP2.SQL.Clear;
        ADOQuP2.SQL.Add(str);
        ADOQuP2.Parameters[0].Value:=StrToInt(CurrentParam.OrderNo);
        ADOQuP2.Prepared;
        ADOQuP2.Open;
        if ADOQuP2.RecordCount>0 then
           ADOQuP2.Edit
        else
        begin
           //ADOQuP2.Append;
           //ADOQuP2.FieldValues['DocNum']:=DBEdit10.Field.Value;
        end;
   except
        exit;
   end;
end;
procedure TFormCOOIPF.TabSheet4Show(Sender: TObject);
begin
   DataShow(Sender,'select * from COIPF2 where DocNum=:P0');
   DataSource2.DataSet.EnableControls;
   DBgrid3.DataSource:=DataSource2;
end;

procedure TFormCOOIPF.TabSheet5Show(Sender: TObject);
begin
   DataShow(Sender,'select * from COIPF2 where DocNum=:P0');
   DataSource2.DataSet.EnableControls;
   DBgrid2.DataSource:=DataSource2;
end;

procedure TFormCOOIPF.TabSheet4Exit(Sender: TObject);
begin
   if DataSource2.DataSet.State=dsEdit then
      DataSource2.DataSet.Post;
   DataSource2.DataSet.DisableControls;
end;

end.