unit ConPromo;

interface

uses
  SysUtils, Windows, Messages, Classes, Graphics, Controls,
  StdCtrls, Forms, DBCtrls, DB, DBGrids, DBTables, Grids, ExtCtrls,
  checa;

type
  TFormaConProvee = class(TForm)
    TablaConProveeCLAVE_P: TStringField;
    TablaConProveeNOMBR_P: TStringField;
    DBGrid1: TDBGrid;
    DBNavigator: TDBNavigator;
    Panel1: TPanel;
    DataSource1: TDataSource;
    Panel2: TPanel;
    TablaConProvee: TTable;
    Shape1: TShape;
    Panel3: TPanel;
    Bevel20: TBevel;
    Bevel21: TBevel;
    Bevel22: TBevel;
    Panel4: TPanel;
    Label1: TLabel;
    Label2: TLabel;
    procedure FormCreate(Sender: TObject);
    procedure DBGrid1DblClick(Sender: TObject);
    procedure DBGrid1KeyDown(Sender: TObject; var Key: Word;
      Shift: TShiftState);
    procedure FormActivate(Sender: TObject);
    procedure Panel4Click(Sender: TObject);
    procedure FormKeyDown(Sender: TObject; var Key: Word;
      Shift: TShiftState);
    procedure Panel3MouseDown(Sender: TObject; Button: TMouseButton;
      Shift: TShiftState; X, Y: Integer);
    procedure Label2MouseDown(Sender: TObject; Button: TMouseButton;
      Shift: TShiftState; X, Y: Integer);
  private
    { private declarations }
  public
    { public declarations }
  end;

var
  FormaConProvee: TFormaConProvee;

function leeproveedor(clave:string):String;
implementation

uses movinv, Compras;

{$R *.DFM}



{function ruta(linea:integer):String;
var
arch:TextFile;
aux:string;
i:integer;

begin
AssignFile(arch,leeempresa);
Reset(arch);
for i:=1 to linea do
Readln(arch,aux);
CloseFile(arch);
ruta:=aux;

end;}

procedure rutas;
var
  I: Integer;
begin

with FormaConProvee do
begin
  for I := 0 to ComponentCount -1 do
    begin
     if Components[I] is TTable  then
       begin
       TTable(Components[I]).DatabaseName:=ruta(8);
       TTable(Components[I]).Open;
       end;
    end;
end;

end;

function leeproveedor(clave:string):String;
begin
with FormaConProvee do
begin
if FormaConProvee.Tag=0 then
begin
rutas;
end
else
FormaConProvee.Tag:=1;

FormaConProvee.TablaConProvee.FindNearest([clave]);
FormaConProvee.Showmodal;
leeproveedor:=TablaConProvee.FieldByName('CLAVE_P').AsString;
end;
end;



procedure TFormaConProvee.FormCreate(Sender: TObject);
begin
  {rutas;
  TablaConProvee.Open;
  TablaConProvee.First;}
end;

procedure TFormaConProvee.DBGrid1DblClick(Sender: TObject);
begin
if FormaConProvee.Panel1.Tag=1 then
begin
FormaMovimientosInventario.EditCLPRO_MI.Text:=FormaConProvee.TablaConProvee.FieldByName('CLAVE_P').AsString;
end;
if FormaConProvee.Panel1.Tag=2 then
begin
FormaCompras.EditCLPRV_O.Text:=TablaConProvee.FieldByName('CLAVE_P').AsString;
FormaCompras.Nombre.Caption:=FormaCompras.TablaProveedor.FieldByName('NOMBR_P').AsString;
FormaCompras.Direccion.Caption:=FormaCompras.TablaProveedor.FieldByName('DIREC_P').AsString;
FormaCompras.Poblacion.Caption:=FormaCompras.TablaProveedor.FieldByName('POBLA_P').AsString;
end;
FormaConProvee.Close;
end;

procedure TFormaConProvee.DBGrid1KeyDown(Sender: TObject; var Key: Word;
  Shift: TShiftState);
begin
if key=27 then
Close;

if Ord(Char(Key))=13 then
begin

if FormaConProvee.Panel1.Tag=1 then
begin
FormaMovimientosInventario.EditCLPRO_MI.Text:=FormaConProvee.TablaConProvee.FieldByName('CLAVE_P').AsString;
FormaMovimientosInventario.EditCLPRO_MI.Tag:=0;
end;

if FormaConProvee.Panel1.Tag=2 then
begin
FormaCompras.EditCLPRV_O.Text:=TablaConProvee.FieldByName('CLAVE_P').AsString;
FormaCompras.Nombre.Caption:=FormaCompras.TablaProveedor.FieldByName('NOMBR_P').AsString;
FormaCompras.Direccion.Caption:=FormaCompras.TablaProveedor.FieldByName('DIREC_P').AsString;
FormaCompras.Poblacion.Caption:=FormaCompras.TablaProveedor.FieldByName('POBLA_P').AsString;
end;
FormaConProvee.Close;
end;
end;
procedure TFormaConProvee.FormActivate(Sender: TObject);
begin
if FormaConProvee.Tag=0 then
begin
rutas;
end
else
FormaConProvee.Tag:=1;

TablaConProvee.FindNearest([FormaMovimientosInventario.EditCLPRO_MI.Text]);
DBGrid1.SelectedIndex:=0;
DBGrid1.SetFocus;
end;


procedure TFormaConProvee.Panel4Click(Sender: TObject);
begin
Close;
end;

procedure TFormaConProvee.FormKeyDown(Sender: TObject; var Key: Word;
  Shift: TShiftState);
begin
if key=27 then Close;
end;

procedure TFormaConProvee.Panel3MouseDown(Sender: TObject;
  Button: TMouseButton; Shift: TShiftState; X, Y: Integer);
begin
ReleaseCapture;
SendMessage(FormaConProvee.Handle, WM_SYSCOMMAND, $F012, 0);
end;

procedure TFormaConProvee.Label2MouseDown(Sender: TObject;
  Button: TMouseButton; Shift: TShiftState; X, Y: Integer);
begin
ReleaseCapture;
SendMessage(FormaConProvee.Handle, WM_SYSCOMMAND, $F012, 0);
end;

end.