ckdj.~pas

库存管理信息系统 自带数据库 如有什么问题:247848560

unit ckdj;

interface

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

type
  Tckdjfrm = class(TForm)
    GroupBox1: TGroupBox;
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    Label5: TLabel;
    Label6: TLabel;
    Label7: TLabel;
    Label13: TLabel;
    ComboBox1: TComboBox;
    Edit1: TEdit;
    ComboBox2: TComboBox;
    Edit2: TEdit;
    ComboBox3: TComboBox;
    Edit3: TEdit;
    Edit4: TEdit;
    Edit9: TEdit;
    GroupBox2: TGroupBox;
    Label9: TLabel;
    Label10: TLabel;
    Label11: TLabel;
    Label12: TLabel;
    Label8: TLabel;
    Edit6: TEdit;
    Edit7: TEdit;
    Edit8: TEdit;
    memo1: TMemo;
    Edit5: TEdit;
    ADOQuery1: TADOQuery;
    ADOConnection1: TADOConnection;
    btnOk: TBitBtn;
    btnCancel: TBitBtn;
    BitBtn1: TBitBtn;
    Label14: TLabel;
    Edit10: TEdit;
    procedure btnOkClick(Sender: TObject);
    procedure btnCancelClick(Sender: TObject);
    procedure BitBtn1Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  ckdjfrm: Tckdjfrm;

implementation
 uses main;
{$R *.dfm}

procedure Tckdjfrm.btnOkClick(Sender: TObject);
var payment,quantity:string;
begin
if combobox1.Text='' then
  showmessage('请选择收货单位！')
else
 if combobox2.Text='' then
   showmessage('请选择仓库！')
 else
   if combobox3.Text='' then
    showmessage('请选择出库货品！')
   else
    if edit6.text='' then
     showmessage('请输入货品数量！')
    else
     if edit7.Text='' then
     showmessage('请输入货品单价！')
     else
begin
 payment:=floattostr(strtofloat(edit6.Text)*strtofloat(edit7.Text));//得到总付款数
 edit10.Text:=payment;
 with adoquery1 do
   begin
   close;
   sql.Clear;
   sql.Add('insert into SELL(sellid,customerid,customername,depotid,depotname,productid,productname,spec,unit,quantity,unitprice,payment,selldate,sellremark)values(');
   sql.Add(''''+edit9.text+''''+','+''''+combobox1.Text+''''+','+''''+edit1.Text+''''+','+''''+combobox2.Text+''''+','+''''+edit2.Text+''''+','+''''+combobox3.Text+''''+','+''''+edit3.Text+''''+',');
   sql.Add(''''+edit4.Text+''''+','+''''+edit5.Text+''''+','+''''+edit6.Text+''''+','+''''+edit7.Text+''''+','+''''+payment+''''+','+''''+edit10.text+''''+','+''''+memo1.Text+''''+')');
   sql.Add('select *  from SELL where depotid='+''''+combobox2.Text+''''+' and productid='+''''+combobox3.Text+'''');
   open;
   first;
   if recordcount=0 then
    begin
    sql.Add('insert into STORAGE (stockid,depotid,depotname,productid,productname,spec,unit,quantity)');
    sql.Add('values('+''''+edit9.text+''''+','+''''+combobox2.Text+''''+','+''''+edit2.Text+''''+','+''''+combobox3.Text+''''+',');
    sql.Add(''''+edit3.Text+''''+','+''''+edit4.Text+''''+','+''''+edit5.Text+''''+','+''''+edit6.Text+''''+')');
    execsql;
    end
   else
     begin
      quantity:=floattostr(strtofloat(edit6.Text)+fieldbyname('quantity').AsFloat);
      sql.Add('update STORAGE set quantity='+''''+quantity+'''');
      execsql;
      end;
   showmessage('出库登记成功！');
   end;
   end;
end;

procedure Tckdjfrm.btnCancelClick(Sender: TObject);
begin
close;
end;

procedure Tckdjfrm.BitBtn1Click(Sender: TObject);
begin
ckdjfrm.Hide;
mainfrm.Show;
end;

end.