stdarc.~pas

针对商品与仓库存储商品等信息的管理及维护的管理软件。它能够辅助仓库管理人员对供应商信息、商品基本信息以及商品入库、出库、库存信息查询等进行控制管理

unit stdArc;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, ComCtrls, StdCtrls, ExtCtrls, Mask, DBCtrls, Grids, DBGrids,
  Buttons,DBTables, ExtDlgs;

type
  TFrmbasic = class(TForm)
    Panel1: TPanel;
    Panel2: TPanel;
    Panel3: TPanel;
    PageControl1: TPageControl;
    TabSheet1: TTabSheet;
    TabSheet2: TTabSheet;
    GroupBox1: TGroupBox;
    Label1: TLabel;
    dbbID: TDBEdit;
    Label2: TLabel;
    dbcID: TDBEdit;
    Label3: TLabel;
    dbbName: TDBEdit;
    Label4: TLabel;
    dbbGender: TDBEdit;
    Label5: TLabel;
    Label6: TLabel;
    Label7: TLabel;
    Label8: TLabel;
    Label9: TLabel;
    Label10: TLabel;
    Label11: TLabel;
    Label12: TLabel;
    dbbNation: TDBEdit;
    dbbPolitic: TDBEdit;
    dbbFamily: TDBEdit;
    dbbNative: TDBEdit;
    dbbFaName: TDBEdit;
    dbbWorkAddr: TDBEdit;
    dbbFamAddr: TDBEdit;
    Label13: TLabel;
    dbbDate: TDBEdit;
    dbbBirth: TDBEdit;
    DBGrid1: TDBGrid;
    BtnNew: TSpeedButton;
    BtnEdit: TSpeedButton;
    BtnDel: TSpeedButton;
    BtnYes: TSpeedButton;
    BtnCancel: TSpeedButton;
    BtnClose: TSpeedButton;
    groupquery: TGroupBox;
    Label14: TLabel;
    Label15: TLabel;
    Label16: TLabel;
    Label17: TLabel;
    GroupBox2: TGroupBox;
    Label18: TLabel;
    Label19: TLabel;
    dbbPhoto: TDBImage;
    dbbTel: TDBEdit;
    dbbPost: TDBEdit;
    SpeedButton1: TSpeedButton;
    dbbStatus: TDBEdit;
    Label20: TLabel;
    GroupBox3: TGroupBox;
    GroupBox4: TGroupBox;
    dbbResume: TDBMemo;
    dbbMemo: TDBMemo;
    Label21: TLabel;
    dbbHobby: TDBEdit;
    ComboBox1: TComboBox;
    ComboBox2: TComboBox;
    boxpolitic: TComboBox;
    boxFamily: TComboBox;
    GroupBox5: TGroupBox;
    combobox3: TComboBox;
    Edit1: TEdit;
    Edit2: TEdit;
    Edit3: TEdit;
    ComboBox4: TComboBox;
    ComboBox5: TComboBox;
    Edit4: TEdit;
    Label22: TLabel;
    Label23: TLabel;
    Combo1: TComboBox;
    Label24: TLabel;
    Combo2: TComboBox;
    Label25: TLabel;
    Combo3: TComboBox;
    SpeedButton2: TSpeedButton;
    OpenDialog1: TOpenPictureDialog;
    Label26: TLabel;
    Label27: TLabel;
    Label28: TLabel;
    lbquery: TLabel;
    Label30: TLabel;
    Edit5: TEdit;
    Label29: TLabel;
    lbcount: TLabel;
    btnw1: TSpeedButton;
    procedure FormCreate(Sender: TObject);
    procedure BtnNewClick(Sender: TObject);
    procedure BtnEditClick(Sender: TObject);
    procedure BtnYesClick(Sender: TObject);
    procedure BtnCancelClick(Sender: TObject);
    procedure BtnDelClick(Sender: TObject);
    procedure FormCloseQuery(Sender: TObject; var CanClose: Boolean);
    procedure BtnCloseClick(Sender: TObject);
    procedure ComboBox1Change(Sender: TObject);
    procedure dbcIDChange(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure ComboBox2Change(Sender: TObject);
    procedure dbbGenderChange(Sender: TObject);
    procedure dbbPoliticChange(Sender: TObject);
    procedure boxpoliticChange(Sender: TObject);
    procedure dbbFamilyChange(Sender: TObject);
    procedure boxFamilyChange(Sender: TObject);
    procedure dbbStatusChange(Sender: TObject);
    procedure ComboBox3Change(Sender: TObject);
    procedure SpeedButton2Click(Sender: TObject);
    procedure dbbPhotoClick(Sender: TObject);
    procedure BtnSetClick(Sender: TObject);
    procedure BtnPreviewClick(Sender: TObject);
    procedure BtnPrintClick(Sender: TObject);
    procedure btnw1Click(Sender: TObject);
    procedure PageControl1Change(Sender: TObject);
  private
    { Private declarations }
    formmode:string;
    procedure BtnMode;
    procedure InsertMode;
    Procedure UpdateMode;
    Procedure NormalMode;
  public
    { Public declarations }
  end;

var
  Frmbasic: TFrmbasic;

implementation
 uses MainD,UTIL,uReport,UREGINFO;
{$R *.dfm}

procedure TFrmbasic.BtnMode;
begin
  BtnNew.Enabled     := False;
  BtnEdit.Enabled    := False;
  BtnDel.Enabled     := False;
  BtnYes.Enabled     := False;
  BtnCancel.Enabled  := False;



  BtnClose.Enabled   := False;
  Groupquery.Enabled := False;
  DBGrid1.Enabled    := False;
  dbbID.Enabled      := False;
if formmode = 'nor' then
begin
  dbbID.Enabled      := False;
  BtnNew.Enabled     := True;
  BtnEdit.Enabled    := True;
  BtnDel.Enabled     := True;
  BtnYes.Enabled     := False;
  BtnCancel.Enabled  := False;



  BtnClose.Enabled   := True;
  Groupquery.Enabled := True;
  DBGrid1.Enabled    := True;
  btnw1.Enabled      := True;
end else if (formmode='ins') or (formmode='edt') then begin
  if formmode = 'ins' then
  dbbID.Enabled      := True;
  BtnNew.Enabled     := False;
  BtnEdit.Enabled    := False;
  BtnDel.Enabled     := False;
  BtnYes.Enabled     := True;
  BtnCancel.Enabled  := True;

  BtnClose.Enabled   := False;
  Groupquery.Enabled := False;
  DBGrid1.Enabled    := False;
  btnw1.Enabled      := False;
end;
end;

procedure TFrmbasic.FormCreate(Sender: TObject);
var
 q1:TQuery;
begin
 pagecontrol1.ActivePageIndex := tabstatus;
 With MainDFrm do
 begin
   Qutil.SQL.Clear;
   Qutil.SQL.Add('SELECT * FROM Arcinfo a inner join Classinfo b');
   qutil.SQL.Add('on a.cID = b.cID');
   Qutil.SQL.add('order by bID,a.cID');

   Uqutil.InsertSQL.Clear;
   Uqutil.InsertSQL.Add('INSERT INTO Arcinfo ');
   Uqutil.InsertSQL.Add('(bID,cID,bName,bGender,bNation,bPolitic,');
   Uqutil.InsertSQL.Add('bFamily,bNative,bFaName,bWorkAddr,bFamAddr,');
   Uqutil.InsertSQL.Add('bPost,bTel,bDate,bBirth,bStatus,bHobby,bResume,bMemo,bPhoto)');
   Uqutil.InsertSQL.Add('VALUES');
   Uqutil.InsertSQL.Add('(:bID,:cID,:bName,:bGender,:bNation,:bPolitic,');
   Uqutil.InsertSQL.Add(':bFamily,:bNative,:bFaName,:bWorkAddr,:bFamAddr,');
   Uqutil.InsertSQL.Add(':bPost,:bTel,:bDate,:bBirth,:bStatus,');
   Uqutil.InsertSQL.Add(':bHobby,:bResume,:bMemo,:bPhoto)');

   Uqutil.ModifySQL.Clear;
   Uqutil.ModifySQL.Add('UPDATE Arcinfo SET');
   Uqutil.ModifySQL.Add('cID=:cID,bName=:bName,');
   Uqutil.ModifySQL.Add('bGender   =:bGender,');
   Uqutil.ModifySQL.Add('bNation   =:bNation,');
   Uqutil.ModifySQL.Add('bPolitic  =:bPolitic,');
   Uqutil.ModifySQL.Add('bFamily   =:bFamily,');
   Uqutil.ModifySQL.Add('bNative   =:bNative,');
   Uqutil.ModifySQL.Add('bFaName   =:bFaName,');
   Uqutil.ModifySQL.Add('bWorkAddr =:bWorkAddr,');
   Uqutil.ModifySQL.Add('bFamAddr  =:bFamAddr,');
   Uqutil.ModifySQL.Add('bPost     =:bPost,');
   Uqutil.ModifySQL.Add('bTel      =:bTel,');
   Uqutil.ModifySQL.Add('bDate     =:bDate,');
   Uqutil.ModifySQL.Add('bBirth    =:bBirth,');
   Uqutil.ModifySQL.Add('bStatus   =:bStatus,');
   Uqutil.ModifySQL.Add('bHobby    =:bHobby,');
   Uqutil.ModifySQL.Add('bResume   =:bResume,');
   Uqutil.ModifySQL.Add('bMemo     =:bMemo,');
   Uqutil.ModifySQL.Add('bPhoto    =:bPhoto');
   Uqutil.ModifySQL.Add('WHERE bID =:bID');

   Uqutil.DeleteSQL.Clear;
   Uqutil.DeleteSQL.Add('DELETE FROM Arcinfo');
   Uqutil.DeleteSQL.Add('WHERE bID ='''+dbbID.Text+'''');

   Qutil.Close;
   qutil.Open;

     q1 := TQuery.Create(self);
   try
     q1.DatabaseName := 'main';
     q1.SQL.Clear;
     q1.SQL.Add('SELECT cID,cClass FROM Classinfo');
     q1.Close;
     q1.Open;
     q1.First;
     combobox2.Clear;
   while not q1.Eof do
   begin
     combobox4.Items.Add(q1.fieldbyname('cID').asstring);
     combobox5.Items.Add(q1.fieldbyname('cID').asstring);
     combobox2.Items.Add(q1.fieldbyname('cClass').asstring);
     if dbcID.Text =  q1.fieldbyname('cID').asstring then
     combobox2.Text := q1.fieldbyname('cClass').asstring;
     q1.Next;
   end;
   finally
     q1.Free;
   end;
 dbbID.DataField       := 'bID';
 dbcID.DataField       := 'cID';
 dbbName.DataField     := 'bName';
 dbbGender.DataField   := 'bGender';
 dbbNation.DataField   := 'bNation';
 dbbPolitic.DataField  := 'bPolitic';
 dbbFamily.DataField   := 'bFamily';
 dbbNative.DataField   := 'bNative';
 dbbFaName.DataField   := 'bFaName';
 dbbWorkAddr.DataField := 'bWorkAddr';
 dbbFamAddr.DataField  := 'bFamAddr';
 dbbPost.DataField     := 'bPost';
 dbbTel.DataField      := 'bTel';
 dbbDate.DataField     := 'bDate';
 dbbBirth.DataField    :=  'bBirth';
 dbbStatus.DataField   := 'bStatus';
 dbbResume.DataField   := 'bResume';
 dbbHobby.DataField    := 'bHobby';
 dbbMemo.DataField     := 'bMemo';
 dbbPhoto.DataField    := 'bPhoto';
 lbcount.Caption := ' '+inttostr(MaindFrm.qutil.RecordCount);
 lbquery.Caption := ' '+inttostr(MaindFrm.qutil.RecordCount);
end;

NormalMode;
end;

procedure TFrmbasic.InsertMode;
begin
formmode := 'ins';
BtnMode;
end;

procedure TFrmbasic.NormalMode;
begin
formmode :='nor';
BtnMode;
end;

procedure TFrmbasic.UpdateMode;
begin
formmode := 'edt';
BtnMode;
end;

procedure TFrmbasic.BtnNewClick(Sender: TObject);
begin
 IF RegReturnStr('\Software\Intel soft','SF_ID') <> RegNumber(GetCPUID[4]) THEN
  begin
   MainDFrm.Qgrant.SQL.Clear;
   MainDFrm.Qgrant.SQL.Add('select bID from Arcinfo');
   MainDFrm.Qgrant.Close;
   MainDFrm.Qgrant.Open;
   if MainDFrm.Qgrant.RecordCount>30 then
   begin