unitstore.~pas

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

unit UnitStore;

interface

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

type
  TFrmStore = class(TForm)
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    Label5: TLabel;
    Label6: TLabel;
    Label7: TLabel;
    Label8: TLabel;
    Label9: TLabel;
    Label10: TLabel;
    Label11: TLabel;
    Label12: TLabel;
    Label13: TLabel;
    edtStoreID: TEdit;
    edtStoreDate: TEdit;
    edtSign: TEdit;
    edtRemark: TEdit;
    edtWzID: TEdit;
    edtName: TEdit;
    edtCard: TEdit;
    edtModel: TEdit;
    edtUnitPrice: TEdit;
    edtPhone: TEdit;
    cmbbxStoreType: TComboBox;
    cmbbxStorePlace: TComboBox;
    Label14: TLabel;
    edtBuyDate: TEdit;
    Label15: TLabel;
    Label16: TLabel;
    Label17: TLabel;
    edtBuyMan: TEdit;
    cmbbxDepartment: TComboBox;
    edtRatify: TEdit;
    Label18: TLabel;
    Label19: TLabel;
    Label20: TLabel;
    Label21: TLabel;
    Label22: TLabel;
    Label23: TLabel;
    edtUnit: TComboBox;
    edtAmount: TEdit;
    edtPay: TEdit;
    cmbbxCustomerName: TComboBox;
    edtAddress: TEdit;
    edtLinkMan: TEdit;
    edtSpec: TEdit;
    btnPost: TButton;
    btnReflesh: TButton;
    ADOStoredProc1: TADOStoredProc;
    ADOStoredProc2: TADOStoredProc;
    Label24: TLabel;
    edtCustomerID: TEdit;
    procedure btnPostClick(Sender: TObject);
    procedure btnRefleshClick(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  FrmStore: TFrmStore;

implementation

uses UnitDM;

{$R *.dfm}

procedure TFrmStore.btnPostClick(Sender: TObject);
var
  y:string;
begin
  if self.edtStoreID.Text ='' then
  begin
    showmessage('请输入入库单编号！');
    exit;
  end
    
  if self.edtStoreDate.Text ='' then
  begin
    showmessage('请输入物资ID！');
    exit;
  end
   
  if self.cmbbxStoreType.Text ='' then
  begin
    showmessage('请输入入库类型！');
    exit;
  end
   
  if self.cmbbxStorePlace.Text ='' then
  begin
    showmessage('请输入存放仓库！');
    exit;
  end
   
  if self.edtSign.Text ='' then
  begin
    showmessage('请输入签收人！');
    exit;
  end
   
  if self.edtBuyDate.Text ='' then
  begin
    showmessage('请输入采购日期！');
    exit;
  end
   
  if self.cmbbxDepartment.Text ='' then
  begin
    showmessage('请输入采购部门！');
    exit;
  end
   
  if self.edtBuyMan.Text ='' then
  begin
    showmessage('请输入采购人！');
    exit;
  end
   
  if self.edtRatify.Text ='' then
  begin
    showmessage('请输入批准人！');
    exit;
  end
   
  if self.edtWzID.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.edtUnit.Text ='' then
  begin
    showmessage('请输入计量单位！');
    exit;
  end
   
  if self.edtAmount.Text ='' then
  begin
    showmessage('请输入数量！');
    exit;
  end
   
  if self.edtPay.Text ='' then
  begin
    showmessage('请输入应付贷款！');
    exit;
  end
   
  if self.edtCustomerID.Text ='' then
  begin
    showmessage('请输入供货商号！');
    exit;
  end
   
  if self.cmbbxCustomerName.Text ='' then
  begin
    showmessage('请输入供货商！');
    exit;
  end
   

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

  ADOStoredProc1.Parameters.ParamByName('@StoreID').Value:=self.edtStoreID.Text;
  ADOStoredProc1.Parameters.ParamByName('@StoreDate').Value:=self.edtStoreDate.Text;
  ADOStoredProc1.Parameters.ParamByName('@StoreType').Value:=self.cmbbxStoreType.Text;
  ADOStoredProc1.Parameters.ParamByName('@StorePlace').Value:=self.cmbbxStorePlace.Text;
  ADOStoredProc1.Parameters.ParamByName('@Sign').Value:=self.edtSign.Text;
  ADOStoredProc1.Parameters.ParamByName('@BuyDate').Value:=self.edtBuyDate.Text;
  ADOStoredProc1.Parameters.ParamByName('@Department').Value:=self.cmbbxDepartment.Text;
  ADOStoredProc1.Parameters.ParamByName('@BuyMan').Value:=self.edtBuyMan.Text;
  ADOStoredProc1.Parameters.ParamByName('@Ratify').Value:=self.edtRatify.Text;
  ADOStoredProc1.Parameters.ParamByName('@Remark').Value:=self.edtRemark.Text;

  ADOStoredProc1.Parameters.ParamByName('@WzID').Value:=self.edtWzID.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('@Unit').Value:=self.edtUnit.Text;
  ADOStoredProc1.Parameters.ParamByName('@Amount').Value:=self.edtAmount.Text;
  ADOStoredProc1.Parameters.ParamByName('@Pay').Value:=self.edtPay.Text;
  ADOStoredProc1.Parameters.ParamByName('@CustomerID').Value:=self.edtCustomerID.Text;
  ADOStoredProc1.Parameters.ParamByName('@CustomerName').Value:=self.cmbbxCustomerName.Text;
  ADOStoredProc1.Parameters.ParamByName('@Address').Value:=self.edtAddress.Text;
  ADOStoredProc1.Parameters.ParamByName('@Phone').Value:=self.edtPhone.Text;
  ADOStoredProc1.Parameters.ParamByName('@LinkMan').Value:=self.edtLinkMan.Text;
  ADOStoredProc1.Parameters.ParamByName('@str').Value:=y;

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

procedure TFrmStore.btnRefleshClick(Sender: TObject);
begin
  self.edtStoreID.Text='';
  self.edtStoreDate.Text='';
  self.edtSign.Text='';
  self.edtRemark.Text='';
  self.edtWzID.Text='';
  self.edtName.Text='';
  self.edtCard.Text='';
  self.edtModel.Text='';
  self.edtUnitPrice.Text='';
  self.edtPhone.Text='';
  self.edtBuyDate.Text='';
  self.edtBuyMan.Text='';
  self.edtRatify.Text='';
  self.edtUnit.Text='';
  self.edtAmount.Text='';
  self.edtPay.Text='';
  self.edtAddress.Text='';
  self.edtLinkMan.Text='';
  self.edtSpec.Text='';
  self.edtCustomerID.Text='';
  self.cmbbxStoreType.Text='';
  self.cmbbxStorePlace.Text='';
  self.cmbbxDepartment.Text='';
  self.cmbbxCustomerName.Text='';
end;

end.