user_manaage.pas

品质管理系统：delphi+sql实现了制造企业在生产过程中对产品质量的控制

unit user_manaage;

interface

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

type
  Tuser_manaag = class(TForm)
    Label1: TLabel;
    Label2: TLabel;
    SpeedButton1: TSpeedButton;
    SpeedButton2: TSpeedButton;
    SpeedButton3: TSpeedButton;
    SpeedButton4: TSpeedButton;
    GroupBox1: TGroupBox;
    CheckBox1: TCheckBox;
    CheckBox2: TCheckBox;
    CheckBox3: TCheckBox;
    CheckBox4: TCheckBox;
    CheckBox5: TCheckBox;
    CheckBox6: TCheckBox;
    CheckBox7: TCheckBox;
    CheckBox8: TCheckBox;
    CheckBox9: TCheckBox;
    CheckBox10: TCheckBox;
    CheckBox11: TCheckBox;
    CheckBox12: TCheckBox;
    CheckBox40: TCheckBox;
    CheckBox41: TCheckBox;
    CheckBox42: TCheckBox;
    CheckBox43: TCheckBox;
    DBNavigator1: TDBNavigator;
    DBComboBox1: TDBComboBox;
    DBEdit1: TDBEdit;
    DBGrid1: TDBGrid;
    DataSource1: TDataSource;
    Query1: TQuery;
    Query2: TQuery;
    Table1: TTable;
    Table2: TTable;
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure FormCreate(Sender: TObject);
    procedure DBComboBox1KeyPress(Sender: TObject; var Key: Char);
    procedure SpeedButton3Click(Sender: TObject);
    procedure SpeedButton4Click(Sender: TObject);
    procedure CheckBox1Click(Sender: TObject);
    procedure CheckBox2Click(Sender: TObject);
    procedure CheckBox3Click(Sender: TObject);
    procedure CheckBox4Click(Sender: TObject);
    procedure CheckBox5Click(Sender: TObject);
    procedure CheckBox6Click(Sender: TObject);
    procedure CheckBox8Click(Sender: TObject);
    procedure CheckBox7Click(Sender: TObject);
    procedure CheckBox9Click(Sender: TObject);
    procedure CheckBox10Click(Sender: TObject);
    procedure CheckBox11Click(Sender: TObject);
    procedure CheckBox12Click(Sender: TObject);
    procedure CheckBox40Click(Sender: TObject);
    procedure CheckBox41Click(Sender: TObject);
    procedure CheckBox42Click(Sender: TObject);
    procedure CheckBox43Click(Sender: TObject);
    procedure SpeedButton1Click(Sender: TObject);
    procedure SpeedButton2Click(Sender: TObject);
    procedure Table1AfterScroll(DataSet: TDataSet);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  user_manaag: Tuser_manaag;

implementation
     uses dmm2;
{$R *.dfm}

procedure Tuser_manaag.FormClose(Sender: TObject; var Action: TCloseAction);
begin
action:=cafree;
end;

procedure Tuser_manaag.FormCreate(Sender: TObject);
begin
while not Table2.Eof do begin
DBComboBox1.Items.Add(Table2.FieldByName('Username').AsString);
Table2.Next;

end;

end;

procedure Tuser_manaag.DBComboBox1KeyPress(Sender: TObject; var Key: Char);
begin
Query1.Close;
Query1.SQL.Clear;
Query1.SQL.Add('select * from us where username=:kk');
Query1.ParamByName('kk').AsString:=dbcombobox1.Text;
Query1.Open;

if key=chr(13) then
begin
if Query1.FieldByName('username').AsString<>''  then
dbedit1.Text:=Query1.FieldByName('USxm').AsString;
checkbox1.SetFocus;
query2.Active:=false;
query2.SQL.Clear;
query2.SQL.Add('select user_no from pin_gan_manaage where user_no=:kk');
query2.ParamByName('kk').AsString:=dbcombobox1.Text;
query2.Prepare;
query2.Active:=true;
if query2.FieldByName('user_no').AsString=dbcombobox1.Text then
 begin
showmessage('ノめ絪腹ぃ