unitgdzcdj.~pas

这是一个SQL的物资管理系统 这是一个SQL的物资管理系统

unit UnitGdzcDj;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, StdCtrls, DB, ADODB;

type
  TFrmGdzcDj = class(TForm)
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    Label5: TLabel;
    Label6: TLabel;
    Label7: TLabel;
    Label8: TLabel;
    Label9: TLabel;
    Label10: TLabel;
    Label11: TLabel;
    edtGdzcID: TEdit;
    edtWzID: TEdit;
    edtName: TEdit;
    edtModel: TEdit;
    edtSpec: TEdit;
    edtCard: TEdit;
    edtUnitPrice: TEdit;
    edtBuyDate: TEdit;
    edtBuyMan: TEdit;
    Label12: TLabel;
    Label13: TLabel;
    Label14: TLabel;
    Label15: TLabel;
    Label16: TLabel;
    Label17: TLabel;
    Label18: TLabel;
    Label19: TLabel;
    Label20: TLabel;
    cmbbxBuyDepartment: TComboBox;
    edtState: TComboBox;
    cmbbxCustomer: TComboBox;
    edtAddress: TEdit;
    edtPhone: TEdit;
    edtLinkMan: TEdit;
    cmbbxUserDepartment: TComboBox;
    edtUserName: TEdit;
    edtStoreDate: TEdit;
    cmbbxStorePlace: TComboBox;
    edtRepair: TEdit;
    btnPost: TButton;
    btnReflesh: TButton;
    CustomerID: TLabel;
    edtCustomerID: TEdit;
    ADOStoredProc1: TADOStoredProc;
    ADOStoredProc2: TADOStoredProc;
    procedure btnPostClick(Sender: TObject);
    procedure btnRefleshClick(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  FrmGdzcDj: TFrmGdzcDj;

implementation

uses UnitDM;

{$R *.dfm}

procedure TFrmGdzcDj.btnPostClick(Sender: TObject);
var
  y:string;
begin
  if self.edtGdzcID.Text ='' then
  begin
    showmessage('请输入固定资产编号！');
    exit;
  end;
    
  if self.edtWzID.Text ='' then
  begin
    showmessage('请输入物资ID！');
    exit;
  end;
   
  if self.cmbbxStorePlace.Text ='' then
  begin
    showmessage('请输入存储部门！');
    exit;
  end;
   
  if self.cmbbxUserDepartment.Text ='' then
  begin
    showmessage('请输入使用部门！');
    exit;
  end;
   
  if self.edtUserName.Text ='' then
  begin
    showmessage('请输入使用人！');
    exit;
  end;
   
  if self.edtName.Text ='' then
  begin
    showmessage('请输入物资名称！');
    exit;
  end ;
   
  if self.edtUnitPrice.Text ='' then
  begin
    showmessage('请输入单价！');
    exit;
  end ;
   
  if self.edtStoreDate.Text ='' then
  begin
    showmessage('请输入存储日期！');
    exit;
  end   ;
   
  if self.edtRepair.Text ='' then
  begin
    showmessage('请输入保修！');
    exit;
  end;
   
  if self.edtCustomerID.Text ='' then
  begin
    showmessage('请输入供货商ID！');
    exit;
  end ;
   

  ADOStoredProc1.Connection:=DataModule2.ADOConnection1;
  ADOStoredProc1.Close;
  ADOStoredProc1.ProcedureName:='AddGdzcDj';
  ADOStoredProc1.Parameters.Refresh;

  ADOStoredProc1.Parameters.ParamByName('@gdzcid').Value:=self.edtGdzcID.Text;
  ADOStoredProc1.Parameters.ParamByName('@wzid').Value:=self.edtWzID.Text;
  ADOStoredProc1.Parameters.ParamByName('@buydate').Value:=self.edtBuyDate.Text;
  ADOStoredProc1.Parameters.ParamByName('@buydepartment').Value:=self.cmbbxBuyDepartment.Text;
  ADOStoredProc1.Parameters.ParamByName('@buyman').Value:=self.edtBuyMan.Text;
  ADOStoredProc1.Parameters.ParamByName('@storeplace').Value:=self.cmbbxStorePlace.Text;
  ADOStoredProc1.Parameters.ParamByName('@department').Value:=self.cmbbxUserDepartment.Text;
  ADOStoredProc1.Parameters.ParamByName('@username').Value:=self.edtUserName.Text;

  ADOStoredProc1.Parameters.ParamByName('@name').Value:=self.edtName.Text;
  ADOStoredProc1.Parameters.ParamByName('@model').Value:=self.edtModel.Text;
  ADOStoredProc1.Parameters.ParamByName('@spec').Value:=self.edtSpec.Text;
  ADOStoredProc1.Parameters.ParamByName('@card').Value:=self.edtCard.Text;
  ADOStoredProc1.Parameters.ParamByName('@unitprice').Value:=self.edtUnitPrice.Text;
  ADOStoredProc1.Parameters.ParamByName('@storedate').Value:=self.edtStoreDate.Text;
  ADOStoredProc1.Parameters.ParamByName('@repair').Value:=self.edtRepair.Text;
  ADOStoredProc1.Parameters.ParamByName('@state').Value:=self.edtState.Text;
  ADOStoredProc1.Parameters.ParamByName('@customerid').Value:=self.edtCustomerID.Text;
  ADOStoredProc1.Parameters.ParamByName('@customer').Value:=self.cmbbxCustomer.Text;
  ADOStoredProc1.Parameters.ParamByName('@address').Value:=self.edtAddress.Text;
  ADOStoredProc1.Parameters.ParamByName('@linkman').Value:=self.edtLinkMan.Text;
  ADOStoredProc1.Parameters.ParamByName('@phone').Value:=self.edtPhone.Text;
  ADOStoredProc1.Parameters.ParamByName('@str').Value:=y;

  ADOStoredProc1.ExecProc;
  y:=ADOStoredProc1.Parameters.ParamByName('@str').Value;
  MessageBox(Handle,pchar(y), '系统提示', MB_ICONASTERISK);


end;

procedure TFrmGdzcDj.btnRefleshClick(Sender: TObject);
begin
  self.edtGdzcID.Text:='';
  self.edtWzID.Text:='';
  self.edtName.Text:='';
  self.edtModel.Text:='';
  self.edtSpec.Text:='';
  self.edtCard.Text:='';
  self.edtUnitPrice.Text:='';
  self.edtBuyDate.Text:='';
  self.edtBuyMan.Text:='';
  self.edtState.Text:='';
  self.edtAddress.Text:='';
  self.edtPhone.Text:='';
  self.edtLinkMan.Text:='';
  self.edtUserName.Text:='';
  self.edtStoreDate.Text:='';
  self.edtRepair.Text:='';
  self.edtCustomerID.Text:='';
  self.cmbbxBuyDepartment.Text:='';
  self.cmbbxCustomer.Text:='';
  self.cmbbxUserDepartment.Text:='';
  self.cmbbxStorePlace.Text:='';
  self.CustomerID.Text:='';

end;

end.