ufrm_shippinglist.pas

来自「完整的进销存系统。 设计文件及完整的源代码。 Delphi6.0」· PAS 代码 · 共 133 行

unit Ufrm_shippinglist;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, ufrm_level4_3, dxExEdtr, Menus, DB, DBTables, ImgList, dxCntner,
  dxTL, dxDBCtrl, dxDBGrid, StdCtrls, ExtCtrls, ComCtrls, ToolWin,
  dxDBTLCl, dxGrClms, DBCtrls, Mask, dxEditor, dxEdLib, dxDBELib;

type
  Tfrm_shippinglist = class(Tfrm_level4_3)
    qy_detailSHIPNO: TStringField;
    qy_detailSHIPITEM: TIntegerField;
    qy_detailGOODSNO: TStringField;
    qy_detailSHIPQTY: TFloatField;
    qy_detailUNIT: TStringField;
    qy_detailPRICE: TFloatField;
    qy_detailCURRENCY: TStringField;
    qy_detailACTI: TStringField;
    qy_detailOWUS: TStringField;
    qy_detailGRUP: TStringField;
    qy_detailCRET: TDateTimeField;
    qy_detailMODU: TStringField;
    qy_detailMODT: TDateTimeField;
    qy_detailD_SN: TFloatField;
    dbGridSHIPNO: TdxDBGridMaskColumn;
    dbGridSHIPITEM: TdxDBGridMaskColumn;
    dbGridGOODSNO: TdxDBGridMaskColumn;
    dbGridSHIPQTY: TdxDBGridMaskColumn;
    dbGridUNIT: TdxDBGridMaskColumn;
    dbGridPRICE: TdxDBGridMaskColumn;
    dbGridCURRENCY: TdxDBGridMaskColumn;
    dbGridACTI: TdxDBGridMaskColumn;
    dbGridOWUS: TdxDBGridMaskColumn;
    dbGridGRUP: TdxDBGridMaskColumn;
    dbGridCRET: TdxDBGridDateColumn;
    dbGridMODU: TdxDBGridMaskColumn;
    dbGridMODT: TdxDBGridDateColumn;
    dbGridD_SN: TdxDBGridMaskColumn;
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    Label5: TLabel;
    Label6: TLabel;
    DBText1: TDBText;
    dxDBButtonEdit1: TdxDBButtonEdit;
    DBEdit1: TDBEdit;
    DBEdit2: TDBEdit;
    DBEdit3: TDBEdit;
    DBEdit4: TDBEdit;
    procedure dxDBButtonEdit1ButtonClick(Sender: TObject;
      AbsoluteIndex: Integer);
    procedure qy_detailNewRecord(DataSet: TDataSet);
  private
    { Private declarations }
  protected  
    function next_ordinal:integer;
    function chk_save:boolean ; override ;

  public
    { Public declarations }
  end;

var
  frm_shippinglist: Tfrm_shippinglist;

implementation

uses uSelect_Form, udm , uglobal_var,uglobal_fun ;

{$R *.dfm}

procedure Tfrm_shippinglist.dxDBButtonEdit1ButtonClick(Sender: TObject;
  AbsoluteIndex: Integer);
begin
  inherited;
  application.CreateForm(TSelect_Form, Select_Form);
  Select_form.ComboBox1.Items.Add('GOODSNO') ;
  Select_form.Query1.SQL.Add('SELECT GOODSNO,GOODSDESC FROM T_GOODSMASTER WHERE 1=1 ')  ;
  try
     select_form.Query1.Open;
  except
  end;
  Select_form.ShowModal ;
  if Select_form.ModalResult = mrok then
  begin
    qy_detail.FieldByName('GOODSNO').AsString := Select_form.Query1.fieldbyname('GOODSNO').AsString ;
  end;
  try
     select_form.release;
   except
     ;
   end;

end;

function Tfrm_shippinglist.next_ordinal:integer;
var l_value:integer;
begin
  with dm do
    begin
      g_sqlstr:='SELECT MAX(SHIPITEM) FROM T_SHIPLIST WHERE SHIPNO='''+u_mpvalue[1]+'''';
      pub1.Close;
      pub1.sql.Clear;
      pub1.SQL.Add(g_sqlstr);
      pub1.Open;
      l_value:=pub1.Fields[0].AsInteger;
      l_value:=l_value+1;
    end;
  result:=l_value;
end;


procedure Tfrm_shippinglist.qy_detailNewRecord(DataSet: TDataSet);
begin
  inherited;
  qy_detail.FieldByName('SHIPITEM').AsInteger:=self.next_ordinal; 
end;

function Tfrm_shippinglist.chk_save ;
begin
  result := true ;
  if qy_detail.FieldByName('SHIPQTY').AsInteger = 0 then
    begin
       u_error := ' 订单数量不能为零 '   ;
       result := false ; exit ;
    end;
end;

end.