wf1.pas

delphi开发的委托加工管理系统源代码

unit wf1;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, Grids, DBGrids, StdCtrls, Mask, DBCtrls, Buttons, DB, ADODB,
  DBActns, ActnList, RzPanel, RzButton, ExtCtrls, RzEdit;

type
  Twf = class(TForm)
    GroupBox2: TGroupBox;
    DBGrid1: TDBGrid;
    DataSource1: TDataSource;
    ADODataSet1: TADODataSet;
    ActionList1: TActionList;
    DataSetInsert1: TDataSetInsert;
    DataSetDelete1: TDataSetDelete;
    ADOCommand1: TADOCommand;
    RzToolbar1: TRzToolbar;
    RzToolButton1: TRzToolButton;
    RzSpacer1: TRzSpacer;
    RzToolButton2: TRzToolButton;
    RzSpacer2: TRzSpacer;
    RzToolButton3: TRzToolButton;
    RzSpacer3: TRzSpacer;
    RzToolButton4: TRzToolButton;
    GroupBox1: TGroupBox;
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    ComboBox1: TComboBox;
    ComboBox2: TComboBox;
    Edit1: TEdit;
    RzEdit1: TRzEdit;
    procedure DBGrid1DrawColumnCell(Sender: TObject; const Rect: TRect;
      DataCol: Integer; Column: TColumn; State: TGridDrawState);
    procedure RzToolButton4Click(Sender: TObject);
    procedure RzToolButton2Click(Sender: TObject);
    procedure RzToolButton3Click(Sender: TObject);
    procedure RzToolButton1Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  wf: Twf;

implementation

uses log1, adodm;

{$R *.dfm}

procedure Twf.DBGrid1DrawColumnCell(Sender: TObject; const Rect: TRect;
  DataCol: Integer; Column: TColumn; State: TGridDrawState);
begin
 if gdselected in state then//如果当前区域是被选区域
    begin
      //设置被选区域颜色
      tdbgrid(sender).Canvas.Brush.Color:=clinfobk;
      //设置被选区域字体颜色
      tdbgrid(sender).Canvas.Font.Color:=clfuchsia;
    end
  else //如果是当前区域不是被选择区域
    begin
     //如果是偶数行，则背景颜色为 clskyblue
     if tdbgrid(sender).DataSource.DataSet.RecNo mod 2 =0 then
        tdbgrid(sender).Canvas.Brush.Color:=clskyblue
     else
     //如果是奇数行，则背景颜色为 clinactivecaptiontext
        tdbgrid(sender).Canvas.Brush.Color:=clWhite;
    end;
  //调用默认的绘图函数
  tdbgrid(sender).DefaultDrawColumnCell(rect,datacol,column,state);

end;

procedure Twf.RzToolButton4Click(Sender: TObject);
begin
close;
end;

procedure Twf.RzToolButton2Click(Sender: TObject);
begin
adocommand1.CommandText:='insert into usedata (username,pass,jb,qx) values ('''+trim(rzedit1.Text)+''','''+trim(edit1.Text)+''','''+trim(combobox1.Text)+''','''+trim(combobox2.Text)+''')';
adocommand1.Execute;
showmessage('操作成功！');
log.flatcombobox1.Clear;
adodataset1.Active:=false;
adodataset1.Active:=true;
end;

procedure Twf.RzToolButton3Click(Sender: TObject);
var
a:string;
begin
a:=dbgrid1.DataSource.DataSet.FieldValues[dbgrid1.Columns[1].FieldName];
if messagedlg('您确认要删除:'+#13+'用户名:'+a,mtwarning,[mbyes,mbno],0)=mryes then
begin
adocommand1.CommandText:='delete from usedata where username='''+a+'''';
adocommand1.Execute;
adodataset1.Active:=false;
adodataset1.Active:=true;
end;
end;

procedure Twf.RzToolButton1Click(Sender: TObject);
begin
rzedit1.Clear;
edit1.Clear;
combobox1.Text:='';
combobox2.Text:='';
end;

end.