sdocrd.pas

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

unit SDOCRD;

interface

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

type
  TFormSDOCRD = class(TForm)
    DBEdit1: TDBEdit;
    Label11: TLabel;
    Label12: TLabel;
    Shape11: TShape;
    Shape10: TShape;
    Shape12: TShape;
    Label13: TLabel;
    DBEdit12: TDBEdit;
    DBEdit11: TDBEdit;
    DBEdit13: TDBEdit;
    DBEdit14: TDBEdit;
    Label15: TLabel;
    Label14: TLabel;
    Shape13: TShape;
    Shape14: TShape;
    Button1: TButton;
    Button2: TButton;
    PageControl1: TPageControl;
    TabSheet1: TTabSheet;
    TabSheet2: TTabSheet;
    TabSheet3: TTabSheet;
    TabSheet4: TTabSheet;
    TabSheet5: TTabSheet;
    TabSheet6: TTabSheet;
    DBComboBox1: TDBComboBox;
    DataSource1: TDataSource;
    Label3: TLabel;
    Label4: TLabel;
    Shape3: TShape;
    Shape4: TShape;
    Shape5: TShape;
    Label5: TLabel;
    Label6: TLabel;
    Label7: TLabel;
    Shape6: TShape;
    Shape7: TShape;
    DBEdit10: TDBEdit;
    DBEdit2: TDBEdit;
    DBEdit3: TDBEdit;
    DBEdit4: TDBEdit;
    DBEdit5: TDBEdit;
    DBComboBox2: TDBComboBox;
    Label8: TLabel;
    Label9: TLabel;
    Shape8: TShape;
    DBEdit6: TDBEdit;
    Shape9: TShape;
    DBComboBox3: TDBComboBox;
    Label10: TLabel;
    Shape15: TShape;
    Label16: TLabel;
    DBEdit7: TDBEdit;
    Shape16: TShape;
    Label17: TLabel;
    Shape17: TShape;
    DBMemo3: TDBMemo;
    DBMemo2: TDBMemo;
    DBMemo1: TDBMemo;
    Shape2: TShape;
    Shape1: TShape;
    Label2: TLabel;
    Label1: TLabel;
    DBEdit8: TDBEdit;
    DBEdit9: TDBEdit;
    DBEdit15: TDBEdit;
    DBEdit16: TDBEdit;
    DBEdit17: TDBEdit;
    Shape18: TShape;
    Shape19: TShape;
    Label18: TLabel;
    Label19: TLabel;
    Label20: TLabel;
    Shape20: TShape;
    Shape21: TShape;
    Shape22: TShape;
    Label21: TLabel;
    Label22: TLabel;
    DBEdit19: TDBEdit;
    DBEdit20: TDBEdit;
    DBEdit21: TDBEdit;
    DBEdit22: TDBEdit;
    Shape24: TShape;
    Label24: TLabel;
    Label25: TLabel;
    Shape25: TShape;
    Shape26: TShape;
    Shape27: TShape;
    Label26: TLabel;
    Label27: TLabel;
    DBEdit18: TDBEdit;
    DBEdit23: TDBEdit;
    DBEdit24: TDBEdit;
    DBEdit25: TDBEdit;
    DBEdit26: TDBEdit;
    Shape23: TShape;
    Shape28: TShape;
    Label23: TLabel;
    Label28: TLabel;
    Label29: TLabel;
    Shape29: TShape;
    Shape30: TShape;
    Shape31: TShape;
    Label30: TLabel;
    Label31: TLabel;
    DBEdit28: TDBEdit;
    DBEdit29: TDBEdit;
    DBEdit30: TDBEdit;
    DBEdit31: TDBEdit;
    Shape33: TShape;
    Label32: TLabel;
    Label34: TLabel;
    Shape34: TShape;
    Shape35: TShape;
    Shape36: TShape;
    Label35: TLabel;
    Label36: TLabel;
    DBCheckBox1: TDBCheckBox;
    Label33: TLabel;
    Shape32: TShape;
    DBComboBox4: TDBComboBox;
    Label37: TLabel;
    Label38: TLabel;
    Shape37: TShape;
    Shape38: TShape;
    DBEdit27: TDBEdit;
    Label39: TLabel;
    Shape40: TShape;
    DBEdit33: TDBEdit;
    DBEdit34: TDBEdit;
    DBComboBox5: TDBComboBox;
    Label40: TLabel;
    Shape39: TShape;
    DBEdit32: TDBEdit;
    DBEdit35: TDBEdit;
    Label41: TLabel;
    DBImage1: TDBImage;
    ADOQuP3: TADOQuery;
    procedure DataSource1DataChange(Sender: TObject; Field: TField);
    procedure DBComboBox1Change(Sender: TObject);
    procedure DBEdit1Exit(Sender: TObject);
    procedure FormShow(Sender: TObject);
    procedure Button1Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  FormSDOCRD: TFormSDOCRD;

implementation

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

procedure TFormSDOCRD.DataSource1DataChange(Sender: TObject;
  Field: TField);
begin
    if DataSource1.State=dsInsert then
       Button1.Caption:='添加';
    if DataSource1.State=dsEdit then
       Button1.Caption:='更新';
    if DataSource1.State=dsBrowse then
       Button1.Caption:='确定';
end;

procedure TFormSDOCRD.DBComboBox1Change(Sender: TObject);
begin
   if DBComboBox1.Field.Value='供应商' then
      label16.Caption:='采购员       '
   else
      label16.Caption:='销售员       ';

end;

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

   try
     ADOQuP3.Close;
     ADOQuP3.SQL.Clear;
     ADOQuP3.SQL.Add('select * from SDOCRD where CardCode=:P0');
     ADOQuP3.Parameters[0].Value:=aFac;
     ADOQuP3.Prepared;
     ADOQuP3.Open;
     if ADOQuP3.RecordCount>0 then
     begin
        button1.Caption:= '确定';
        ADOQuP3.Edit;
     end
     else
     begin
     ADOQuP3.append;
     DBEdit1.Field.AsString:=aFac;
     button1.Caption:= '添加';
     end;
   except
     exit;
   end;

end;

procedure TFormSDOCRD.FormShow(Sender: TObject);
begin
   TabSheet2.Visible:=False;
   
   //DataSource1.DataSet.DisableControls;
   try
     ADOQuP3.Close;
     ADOQuP3.SQL.Clear;
     ADOQuP3.SQL.Add('select * from SDOCRD where CardCode=:P0');
     ADOQuP3.Parameters[0].Value:=(CurrentParam.OrderNo);
     ADOQuP3.Prepared;
     ADOQuP3.Open;
     if ADOQuP3.RecordCount>0 then
     begin
        button1.Caption:= '确定';
        ADOQuP3.Edit;
     end
     else
     begin
     button1.Caption:= '添加';
     end;
   except
     exit;
   end;
end;

procedure TFormSDOCRD.Button1Click(Sender: TObject);
begin
   if  Button1.Caption='确定' then
   begin
    DataSource1.DataSet.Edit;
    DataSource1.DataSet.Post;
    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 TFormSDOCRD.Button2Click(Sender: TObject);
begin
   try
   DataSource1.DataSet.Cancel;
   Close;
   except
   exit;
   end;
end;

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

end.