trn100.~pa

公司ERP系统

unit trn100;

interface

uses
  Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs,
  StdCtrls, Db, DBTables, ExtCtrls, Grids, DBGrids;

type
  Ttrn100Form = class(TForm)
    Table1: TTable;
    imitemQuery: TQuery;
    MsgPanel: TPanel;
    Panel1: TPanel;
    Label3: TLabel;
    EditDataBaseName: TEdit;
    Label1: TLabel;
    EditTextFile: TEdit;
    RunBtn: TButton;
    ExitBtn: TButton;
    Panel2: TPanel;
    DataSource1: TDataSource;
    DBGrid1: TDBGrid;
    Table1warehouse: TStringField;
    Table1item_no: TStringField;
    Table1location: TStringField;
    Table1lot_no: TStringField;
    Table1ym: TStringField;
    Table1ware_code: TStringField;
    Table1item_desc: TStringField;
    Table1item_spec: TStringField;
    Table1qty_in_bag: TFloatField;
    Table1qty_in_ctn: TFloatField;
    Table1sp: TStringField;
    Table1item_type: TStringField;
    Table1item_class: TStringField;
    Table1begin_qty: TFloatField;
    Table1begin_amt: TFloatField;
    Table1recv_qty: TFloatField;
    Table1recv_amt: TFloatField;
    Table1other_in_qty: TFloatField;
    Table1other_in_amt: TFloatField;
    Table1issue_qty: TFloatField;
    Table1issue_amt: TFloatField;
    Table1other_out_qty: TFloatField;
    Table1other_out_amt: TFloatField;
    Table1baln_qty: TFloatField;
    Table1baln_amt: TFloatField;
    Table1curr_qty: TFloatField;
    Table1on_hand_qty: TFloatField;
    Table1last_recv_date: TStringField;
    Table1last_issue_date: TStringField;
    MsgLabel: TLabel;
    procedure RunBtnClick(Sender: TObject);
    function  TextToDatabase(vTable   : TTable;  {戈