Разработка информационно-справочной системы по учету вагонов на подъездном пути предприятия

Дипломная работа - Компьютеры, программирование

Другие дипломы по предмету Компьютеры, программирование



upBox;

Label2: TLabel;

Label3: TLabel;

Label4: TLabel;

Label5: TLabel;

Label6: TLabel;

Label7: TLabel;

Label8: TLabel;

Label9: TLabel;

Label10: TLabel;

Label11: TLabel;

Label12: TLabel;

Edit6: TEdit;

Edit4: TEdit;

Edit3: TEdit;

Button1: TButton;

GroupBox2: TGroupBox;

DBGrid1: TDBGrid;

DateTimePicker1: TDateTimePicker;

DateTimePicker2: TDateTimePicker;

Edit1: TEdit;

Edit2: TEdit;

Edit7: TEdit;

Edit8: TEdit;

Edit9: TEdit;

Edit10: TEdit;

ActionList1: TActionList;

PopupMenu1: TPopupMenu;

add: TAction;

edit: TAction;

del: TAction;

N1: TMenuItem;

N2: TMenuItem;

N3: TMenuItem;

procedure FormShow(Sender: TObject);

procedure FormClose(Sender: TObject; var Action: TCloseAction);

procedure Button1Click(Sender: TObject);

procedure Edit1Enter(Sender: TObject);

procedure Edit2Enter(Sender: TObject);

procedure Edit9Enter(Sender: TObject);

procedure Edit10Enter(Sender: TObject);

procedure Edit7Enter(Sender: TObject);

procedure Edit8Enter(Sender: TObject);

procedure addExecute(Sender: TObject);

procedure editExecute(Sender: TObject);

procedure delExecute(Sender: TObject);

procedure Edit6Exit(Sender: TObject);

procedure Edit4Exit(Sender: TObject);

procedure Edit3Exit(Sender: TObject);

private

{ Private declarations }

public

{ Public declarations }

end;

var

Form7: TForm7;

implementation

Uses Unit2, Unit4, Unit3, Unit8, DateUtils;

{$R *.dfm}

procedure TForm7.FormShow(Sender: TObject);

begin

if EditMode2 then

begin

DBGrid1.Visible := true;

Edit6.Text := DataModule2.QOSV[n_ved];

Edit4.Text := DataModule2.QOSV[n_dor_ved];

DateTimePicker1.Date := StrToDate(DataModule2.QOSV[mydate]);

DateTimePicker2.DateTime := StrToTime(DataModule2.QOSV[mytime]);

Edit1.Text := DataModule2.QOSV[SNACH.station];

Edit1.Tag := StrToInt(DataModule2.QOSV[key_station_otpr]);

Edit2.Text := DataModule2.QOSV[FNACH.front];

Edit2.Tag := StrToInt(DataModule2.QOSV[key_front_otpr]);

Edit7.Text := DataModule2.QOSV[SKON.station];

Edit7.Tag := StrToInt(DataModule2.QOSV[key_station_naznach]);

Edit8.Text := DataModule2.QOSV[FKON.front];

Edit8.Tag := StrToInt(DataModule2.QOSV[key_front_naznach]);

Edit9.Text := DataModule2.QOSV[operation];

Edit9.Tag := StrToInt(DataModule2.QOSV[key_operation]);

Edit10.Text := DataModule2.QOSV[gruz];

Edit10.Tag := StrToInt(DataModule2.QOSV[key_gruz]);

Edit3.Text := DataModule2.QOSV[weight];

Tbl:=Uslugi_sv;

ShowZapros();

end

else

begin

Edit6.Text := ;

Edit4.Text := ;

Edit1.Text := ;

Edit1.Tag := 0;

Edit2.Text := ;

Edit2.Tag := 0;

Edit7.Text := ;

Edit7.Tag := 0;

Edit8.Text := ;

Edit8.Tag := 0;

Edit9.Text := ;

Edit9.Tag := 0;

Edit10.Text := ;

Edit10.Tag := 0;

Edit3.Text := ;

DBGrid1.Visible := false;

DateTimePicker1.Date := Date;

DateTimePicker2.Time := Time;

end;

TBL:=Operations_s_vagonom;

end;

procedure TForm7.FormClose(Sender: TObject; var Action: TCloseAction);

begin

if EditMode2 then

begin

EditMode2:=false;

end;

TBL:=Vagon;

end;

procedure TForm7.Button1Click(Sender: TObject);

var qtmp : string;

begin

ToIns := IntToStr(Edit1.Tag);

ToIns2 := IntToStr(Edit2.Tag);

ToIns3 := IntToStr(Edit7.Tag);

ToIns4 := IntToStr(Edit8.Tag);

ToIns5 := DateToStr(DateTimePicker1.Date);

ToIns6 := TimeToStr(DateTimePicker2.Time);

ToIns7 := IntToStr(Edit9.Tag);

ToIns8 := IntToStr(Edit10.Tag);

ToIns9 := Edit3.Text;

ToIns10 := Edit6.Text;

ToIns11 := Edit4.Text;

ToIns12 := DataModule2.QShow[V.id];

)and(Edit4.Text)and

)and(Edit2.Text)and

)and(Edit9.Text)) then

begin

if EditMode2 then

begin

ForEdit := DataModule2.QOSV[OSV.id];

InsEdit4 := true;

InsertZapros();

ShowZapros();

end

else

begin

EditIns2 := true;

InsertZapros();

QueryString:=SELECT top 1 id from + TBL+ order by id desc;

with DataModule2.Qtmp do

begin

Close;

SQL.Clear;

SQL.Add(QueryString);

Open;

end;

qtmp := DataModule2.Qtmp[id];

Form7.Close;

ShowZapros();

DataModule2.QShow.Locate(v.id,qtmp,[]);

ForEdit := -1;

end;

Form7.Close;

end

else

ShowMessage(Все поля обязательны к заполнению!);

end;

procedure TForm7.Edit1Enter(Sender: TObject);

begin

Form3.Caption := Станция отправитель;

Form3.Label1.Caption:= Form3.Caption;

Tbl := Station;

pole1 := id;

pole2 := Station;

pole3 := ;

pole4 := ;

pole5 := ;

pole6 := ;

pole7 := ;

pole8 := ;

pole9 := ;

pole10 := ;

pole11 := ;

pole12 := ;

pole13 := ;

ShowZapros;

Form3.ShowModal;

Tbl := Operations_s_vagonom;

Edit2.SetFocus;

end;

procedure TForm7.Edit2Enter(Sender: TObject);

begin

Form3.Caption := Фронт отправитель;

Form3.Label1.Caption:= Form3.Caption;

Tbl := Front;

pole1 := id;

pole2 := Front;

pole3 := ;

pole4 := ;

pole5 := ;

pole6 := ;

pole7 := ;

pole8 := ;

pole9 := ;

pole10 := ;

pole11 := ;

pole12 := ;

pole13 := ;

ShowZapros;

Form3.ShowModal;

Tbl := Operations_s_vagonom;

Edit7.SetFocus;

end;

procedure TForm7.Edit9Enter(Sender: TObject);

begin

Form3.Caption := Операции;

Form3.Label1.Caption:= Form3.Caption;

Tbl := Operation;

pole1 := id;

pole2 := Operation;

pole3 := ;

pole4 := ;

pole5 := ;

pole6 := ;

pole7 := ;

pole8 := ;

pole9 := ;

pole10 := ;

pole11 := ;

pole12 := ;

pole13 := ;

ShowZapros;

Form3.ShowModal;

Tbl := Operations_s_vagonom;

Edit10.SetFocus;

end;

procedure TForm7.Edit10Enter(Sender: TObject);

begin

Form3.Caption := Груз;

Form3.Label1.Caption:= Form3.Caption;

Tbl := Gruz;

pole1 := id;

pole2 := Gruz;

pole3 := ;

pole4 := ;

pole5 := ;

pole6 := ;

pole7 := ;

pole8 := ;

pole9 := ;

pole10 := ;

p