js210unit.pas

货物配送管理系统对配送服务

unit JS210Unit;

interface

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

type
  TJS210Form = class(TPublicUnit)
    PageControl1: TPageControl;
    TabSheet1: TTabSheet;
    TabSheet2: TTabSheet;
    Panel3: TPanel;
    Button1: TButton;
    Button2: TButton;
    Button3: TButton;
    Button4: TButton;
    Button5: TButton;
    Button6: TButton;
    Panel1: TPanel;
    Panel2: TPanel;
    Label14: TLabel;
    Label51: TLabel;
    Label7: TLabel;
    Label5: TLabel;
    Label6: TLabel;
    DBComboBox1: TDBComboBox;
    DBEdit1: TDBEdit;
    DBEdit2: TDBEdit;
    DBEdit3: TDBEdit;
    DBEdit4: TDBEdit;
    DBEdit5: TDBEdit;
    DBEdit9: TDBEdit;
    DBEdit8: TDBEdit;
    DBEdit7: TDBEdit;
    DBEdit6: TDBEdit;
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    Label15: TLabel;
    Label22: TLabel;
    Label4: TLabel;
    Label8: TLabel;
    Label9: TLabel;
    Label10: TLabel;
    Panel4: TPanel;
    DBGrid1: TDBGrid;
    DBNavigator1: TDBNavigator;
    DBEdit14: TDBEdit;
    DBEdit15: TDBEdit;
    DBEdit16: TDBEdit;
    DBEdit17: TDBEdit;
    DBEdit18: TDBEdit;
    DBEdit19: TDBEdit;
    DBEdit20: TDBEdit;
    DBEdit21: TDBEdit;
    DBEdit22: TDBEdit;
    DBEdit23: TDBEdit;
    DBEdit24: TDBEdit;
    DBEdit25: TDBEdit;
    DBEdit26: TDBEdit;
    DBEdit27: TDBEdit;
    DBEdit28: TDBEdit;
    DBEdit29: TDBEdit;
    DBEdit30: TDBEdit;
    DBEdit31: TDBEdit;
    DBEdit32: TDBEdit;
    DBEdit33: TDBEdit;
    DBEdit34: TDBEdit;
    DBEdit35: TDBEdit;
    DBEdit36: TDBEdit;
    DBEdit37: TDBEdit;
    DBEdit38: TDBEdit;
    DBEdit39: TDBEdit;
    Label12: TLabel;
    Label13: TLabel;
    Label16: TLabel;
    Label17: TLabel;
    Label18: TLabel;
    Label11: TLabel;
    Label19: TLabel;
    Label20: TLabel;
    Label21: TLabel;
    Label23: TLabel;
    Label24: TLabel;
    Label25: TLabel;
    DBEdit40: TDBEdit;
    DBEdit41: TDBEdit;
    DBEdit42: TDBEdit;
    DBCheckBox1: TDBCheckBox;
    Button7: TButton;
    DBEdit10: TDBMemo;
    DBEdit11: TDBMemo;
    DBEdit12: TDBMemo;
    DBEdit13: TDBMemo;
    procedure Button1Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure Button3Click(Sender: TObject);
    procedure Button4Click(Sender: TObject);
    procedure Button5Click(Sender: TObject);
    procedure Button6Click(Sender: TObject);
    procedure DBComboBox1DropDown(Sender: TObject);
    procedure DBComboBox1Change(Sender: TObject);
    procedure DBEdit3Click(Sender: TObject);
    procedure Button7Click(Sender: TObject);
    procedure FormShow(Sender: TObject);
  private
    procedure CLS; // 清除控件内容
    procedure ENA; // 所有控件可用
    procedure DIS; //  所有控件不可用
    { Private declarations }
  public
    { Public declarations }
  end;

var
  JS210Form: TJS210Form;

implementation

uses DMUnit, main, DateUnit;

{$R *.dfm}


procedure TJS210Form.CLS;
var
  i: Integer;
begin
  for i := ComponentCount - 1 downto 0 do
  begin
      {--- 清除所有的TDBEdit控件的内容  ---}
    if (Components[i] is TDBEDIT) then
      TDBEDIT(components[i]).Clear;
      {--- 清除所有的TDBComboBox控件的内容  ---}
    if (Components[i] is TDBComboBox) then
      TDBComboBox(components[i]).Clear;
    if (Components[i] is TDBCheckBox) then
      TDBCheckBox(components[i]).Checked := False;
      {--- 清除所有的TDBMemo控件的内容  ---}
    if (Components[i] is TDBMemo) then
      TDBMemo(components[i]).Clear;
  end;

end;

procedure TJS210Form.ENA; // 新增记录的时候使所有的控件可用
var
  i: Integer;
begin
  for i := ComponentCount - 1 downto 0 do
  begin
    if (components[i] is TDBEdit) then
    begin {--- 使所有的TDBEdit控件可用  ---}
      TDBEdit(components[i]).Color := clwindow;
      TDBEdit(components[i]).ReadOnly := false;
    end;
    if (components[i] is TDBComboBox) then
    begin {--- 使所有的TDBComboBox控件可用  ---}
      TDBComboBox(components[i]).Color := clWindow;
    end;
    if (Components[i] is TDBCheckBox) then
      TDBCheckBox(components[i]).Enabled := True;
    if (components[i] is TDBMemo) then
    begin {--- 使所有的TDBMemo控件可用  ---}
      TDBMemo(components[i]).Color := clwindow;
      TDBMemo(components[i]).ReadOnly := false;
    end;

  end;
  Button1.Enabled := False; //  '新增'不可用
  Button2.Enabled := False; //  '编辑'不可用
  Button3.Enabled := True; //  '储存'可用
  Button4.Enabled := True; //  '取消'可用
end;

procedure TJS210Form.DIS;
var
  i: Integer;
begin
  for i := ComponentCount - 1 downto 0 do
  begin // 使所有的TDBEdit控件不可用
    if (components[i] is TDBEdit) then
    begin //  改变TDBEdit控件的颜色
      TDBEdit(components[i]).Color := $00D8D8D8;
      TDBEdit(components[i]).ReadOnly := true;
    end;
    if (components[i] is TDBComboBox) then
    begin //  改变TDBEdit控件的颜色
      TDBComboBox(components[i]).Color := $00D8D8D8;
    end;
    if (Components[i] is TDBCheckBox) then
      TDBCheckBox(components[i]).Enabled := False;
    if (components[i] is TDBMemo) then
    begin //  改变TDBEdit控件的颜色
      TDBMemo(components[i]).Color := $00D8D8D8;
      TDBMemo(components[i]).ReadOnly := true;
    end;
  end;
  Button1.Enabled := True; //  '新增'可用
  Button2.Enabled := True; //  '编辑'可用
  Button3.Enabled := False; //  '储存'不可用
  Button4.Enabled := False; //  '取消'不可用
end;


procedure TJS210Form.Button1Click(Sender: TObject);
begin
  inherited;
  CLS;
  ENA;
  DM.JSFD.Open;
  DM.JSFD.Append; //加入新的记录
  DM.TempJS.Append;
end;

procedure TJS210Form.Button2Click(Sender: TObject);
begin
  inherited;
  ENA;
  DM.JSFD.Edit;
  DM.TempJS.Edit;
end;

procedure TJS210Form.Button3Click(Sender: TObject);
begin
  inherited;
  DM.TempJS.FieldByName('结算单位').AsString := DBEdit6.Text;
  DM.TempJS.FieldByName('委托单号').AsString := DBComboBox1.Text;
  DM.JSFD.Post;
  DM.TempJS.Post;
  DIS;
end;

procedure TJS210Form.Button4Click(Sender: TObject);
begin
  inherited;
  DM.JSFD.Cancel;
  DM.TempJS.Cancel;
  DIS;
end;

procedure TJS210Form.Button5Click(Sender: TObject);
begin
  inherited;
  if MessageBox(0, '你确定删除该条记录', '提示', MB_YESNO + MB_ICONQUESTION) =
    IDYES then
  begin
    DM.JSFD.Delete;
    DM.TempJS.Delete;
  end;
end;

procedure TJS210Form.Button6Click(Sender: TObject);
begin
  inherited;
  Close;
end;

procedure TJS210Form.DBComboBox1DropDown(Sender: TObject);
var
  I: Integer;
begin
  inherited;
  DBComboBox1.Clear;
  with DM.Querytemp do
  begin
    SQL.clear;
    SQl.Text := 'select 委托单号 from 货运作业总表 ';
    Close;
    Active := False;
    prepared := False;
    prepared := True;
    Active := True;
    if (recordcount > 0) then
      first;
    for i := 0 to recordcount - 1 do
    begin {--- 取得该列所有的数据到combobox1控件中 ---}
      DBComboBox1.Items.add(FieldByName('委托单号').asstring);
      next;
    end;
  end;
end;

procedure TJS210Form.DBComboBox1Change(Sender: TObject);
begin
  inherited;
  DM.JSFD.FieldByName('制单人').AsString := MainForm.Auser.UserName;
  DBEdit1.Text := DM.HYZY.FieldByName('经营单位').AsString;
  DBEdit2.Text := DM.HYZY.FieldByName('委托单位').AsString;
  DBEdit7.Text := DM.HYZY.FieldByName('船名航次').AsString;
  DBEdit2.Text := DM.HYZY.FieldByName('合同号').AsString;
  DBEdit5.Text := DM.HYZY.FieldByName('货名').AsString;
  DBEdit4.Text := DM.HYZY.FieldByName('数量箱型').AsString;
  DBEdit9.Text := DM.HYZY.FieldByName('到达港口').AsString;

end;

procedure TJS210Form.DBEdit3Click(Sender: TObject);
begin
  inherited;
  try
    DateForm := TDateForm.Create(Application);
    DateForm.ShowModal;
    DBEdit3.Text := FormatDateTime('yyyy/mm/dd', DateForm.date1.Date);
    DateForm.Free;
  except
    MessageBox(0, '日期选择窗体创建错误', '错误', MB_OK + MB_ICONSTOP);
  end;
end;

procedure TJS210Form.Button7Click(Sender: TObject);
begin
  inherited;
  DBEdit40.Text := FloatToStr(StrToFloat(DBEdit21.Text) + StrToFloat(DBEdit22.Text) + StrToFloat(DBEdit23.Text) + StrToFloat(DBEdit24.Text) + StrToFloat(DBEdit25.Text) + StrToFloat(DBEdit26.Text) + StrToFloat(DBEdit27.Text));
  DBEdit42.Text := FloatToStr(StrToFloat(DBEdit34.Text) + StrToFloat(DBEdit35.Text) + StrToFloat(DBEdit36.Text) + StrToFloat(DBEdit37.Text) + StrToFloat(DBEdit38.Text) + StrToFloat(DBEdit39.Text));
  DBEdit41.Text := FloatToStr(StrToFloat(DBEdit40.Text) - StrToFloat(DBEdit42.Text));
end;

procedure TJS210Form.FormShow(Sender: TObject);
begin
  inherited;
  DIS;
  CLS;
end;

end.