unit pfm_tjdmx;

interface

uses
  Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs,
  Db, DBTables, Grids, DBGrids, StdCtrls, Mask, DBCtrls, Buttons, ComCtrls,
  pfm_jhdsel, ExtCtrls, ADODB,pvar_lib;

type
  Tfm_tjdmx = class(TForm)
    PageControl1: TPageControl;
    TabSheet1: TTabSheet;
    GroupBox1: TGroupBox;
    Label4: TLabel;
    Label12: TLabel;
    Label13: TLabel;
    Label18: TLabel;
    Label23: TLabel;
    Label24: TLabel;
    Label25: TLabel;
    Label26: TLabel;
    Label27: TLabel;
    Label28: TLabel;
    Label29: TLabel;
    Label30: TLabel;
    Label31: TLabel;
    Label32: TLabel;
    Label33: TLabel;
    DBEdit4: TDBEdit;
    DBEdit5: TDBEdit;
    DBEdit12: TDBEdit;
    DBEdit13: TDBEdit;
    DBEdit18: TDBEdit;
    DBEdit23: TDBEdit;
    DBEdit24: TDBEdit;
    DBEdit25: TDBEdit;
    DBEdit26: TDBEdit;
    DBEdit27: TDBEdit;
    DBEdit28: TDBEdit;
    DBEdit29: TDBEdit;
    DBEdit30: TDBEdit;
    DBEdit31: TDBEdit;
    DBEdit32: TDBEdit;
    GroupBox2: TGroupBox;
    Label1: TLabel;
    Label16: TLabel;
    Label20: TLabel;
    Label22: TLabel;
    Edit1: TEdit;
    Edit9: TEdit;
    Edit10: TEdit;
    Query3: TQuery;
    Query3spbm: TStringField;
    Query3sptxm: TStringField;
    Query3spmc: TStringField;
    Query3ggxh: TStringField;
    Query3dengji: TStringField;
    Query3zhuangtai: TStringField;
    Query3baozhuangdw: TStringField;
    Query3baozhuangsl: TStringField;
    Query3hh: TStringField;
    Query3gysmc: TStringField;
    Query3cd: TStringField;
    Query3xsfs: TStringField;
    Query3wsjj: TFloatField;
    Query3jhsl: TFloatField;
    Query3wsdj: TFloatField;
    Query3xssl: TFloatField;
    Query3yhl: TFloatField;
    Query3splb: TStringField;
    DataSource3: TDataSource;
    BitBtn_quit: TBitBtn;
    BBtn_yskcl: TBitBtn;
    GroupBox3: TGroupBox;
    LView1: TListView;
    Panel1: TPanel;
    Edit11: TEdit;
    Label2: TLabel;
    Label6: TLabel;
    Edit13: TEdit;
    Query1: TQuery;
    Label15: TLabel;
    Edit7: TEdit;
    Label14: TLabel;
    Edit5: TEdit;
    lbltishi: TLabel;
    BBtncancel: TBitBtn;
    BBtnSave: TBitBtn;
    BBtndel: TBitBtn;
    DTPicker1: TDateTimePicker;
    SProc1: TStoredProc;
    BBtnshr: TBitBtn;
    procedure FormCreate(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure BBtn_yskclClick(Sender: TObject);
    procedure Edit11KeyPress(Sender: TObject; var Key: Char);
    procedure Edit13KeyPress(Sender: TObject; var Key: Char);
    procedure Edit5KeyPress(Sender: TObject; var Key: Char);
    procedure BBtndelClick(Sender: TObject);
    procedure BBtncancelClick(Sender: TObject);
    procedure BBtnSaveClick(Sender: TObject);
    procedure FormCloseQuery(Sender: TObject; var CanClose: Boolean);
    procedure LView1Click(Sender: TObject);
    procedure BBtnshrClick(Sender: TObject);
  private
    { Private declarations }
    function MyCheckData():boolean;
    function GetSpxx(spcode:string):boolean;
  public
    { Public declarations }
  end;

var
  fm_tjdmx: Tfm_tjdmx;
implementation

uses pfm_yfkcl, pfm_selyuangong;



{$R *.DFM}

procedure Tfm_tjdmx.FormCreate(Sender: TObject);
var
i,mlsh:integer;
lvcol:TListColumn;
begin

    lvcol:=lview1.Columns.Add();
    lvcol.Caption:='商品編碼';
    lvcol.width:=60;
    lvcol:=lview1.Columns.Add();
    lvcol.Caption:='商品條形碼';
    lvcol.width:=110;
    lvcol:=lview1.Columns.Add();
    lvcol.Caption:='商品名稱';
    lvcol.width:=120;
    lvcol:=lview1.Columns.Add();
    lvcol.Caption:='調價前單價';
    lvcol.width:=80;
    lvcol:=lview1.Columns.Add();
    lvcol.Caption:='調價后單價';
    lvcol.width:=80;
    lvcol:=lview1.Columns.Add();
    lvcol.Caption:='調價原因';
    lvcol.width:=150;

    for i:= 0 to componentcount-1 do
    begin
        if components[i].ClassName='TEdit' then
        begin
            (components[i] as tedit).text:='';
        end;
    end;
    dtpicker1.datetime:=now();
    //利用存儲過程取得提貨單的最大流水號
    SProc1.ParamByName('@chTable').value:='tb_tjd';
    Sproc1.ExecProc;
    mLsh:=sproc1.ParamByName('@intlsh').value+1;
    sproc1.Close;
    edit1.text:=inttostr(mlsh);
    edit10.text:=mUsername;
end;

function Tfm_tjdmx.MyCheckData():boolean;
begin

        myCheckData:=true;
end;
procedure Tfm_tjdmx.FormClose(Sender: TObject; var Action: TCloseAction);
begin
        action:=caFree;
end;

procedure Tfm_tjdmx.BBtn_yskclClick(Sender: TObject);
begin
 {if application.MessageBox('是否調價明細單錄入完成，#13填寫應付款單','注意',MB_YESNO)=ID_NO then
  begin
      exit;
  end;

  fm_yfkcl:=tfm_yfkcl.create(application);
  fm_yfkcl.Edit1.Text:=edit1.text;
  fm_yfkcl.edit2.text:=edit2.text;
  fm_yfkcl.showmodal;}
end;

procedure Tfm_tjdmx.Edit11KeyPress(Sender: TObject; var Key: Char);
var
ListItem:Tlistitem;
begin
    //商品編碼或條形碼
    if key<>#13 then exit;
    if getspxx(edit11.text)=false then
    begin
        edit11.text:='';
        lbltishi.caption:='沒有這個商品';
        exit;
    end;
    if not query3.eof then
    begin

        ListItem:=LView1.items.Insert(0);
        ListItem.Caption:=query3.fieldbyname('spbm').asstring;
        LIstItem.SubItems.add(query3.fieldbyname('sptxm').asstring);
        LIstItem.SubItems.add(query3.fieldbyname('spmc').asstring);
        edit7.text:= query3.fieldbyname('wsdj').asstring;
        LIstItem.SubItems.add(edit7.text);//2-調價前單價
        edit13.text:=edit7.text;
        LIstItem.SubItems.add(edit13.text);//3－調價后單價
        LIstItem.SubItems.add(edit5.text);//4－調價原因
        ListItem.selected:=true;
        edit13.SetFocus;
    end
    else
    begin
        edit11.text:='';
        lbltishi.caption:='沒有這個商品';
    end;


end;
function Tfm_tjdmx.GetSpxx(spcode:string):boolean;
var
spcodelen:integer;
tmpstr:string;
begin
    spcodelen:=length(spcode);
    if spcodelen<=6 then
    begin
         tmpstr:='000000'+spcode;
         spcode:=copy(tmpstr,spcodelen+1,6);
         spcodelen:=6;
    end
    else if spcodelen<>13 then //輸入的編碼位數>6但不是13位
    begin
        GetSpxx:=false;
        exit;
    end;
    edit11.text:=spcode;
    query3.close;
    query3.sql.clear;
    if spcodelen=6 then
    begin
        query3.sql.add('select * from t_spxx where spbm='''+spcode+'''');
    end
    else
    begin
        query3.sql.add('select * from t_spxx where sptxm='''+spcode+'''');
    end;
    query3.open;
    GetSpxx:=true;
end;
procedure Tfm_tjdmx.Edit13KeyPress(Sender: TObject; var Key: Char);
begin
    if key<>#13 then exit;
    if lview1.SelCount=0 then exit;
    try
        strtofloat((sender as tedit).text);
        lview1.Selected.SubItems.strings[3]:=(sender as tedit).text;
        lbltishi.caption:='請輸入調價原因';
        edit5.setfocus;
    except
        on EConvertError do
        begin
            lbltishi.caption:='你輸入的不是數字';
        end;
    end;
end;

procedure Tfm_tjdmx.Edit5KeyPress(Sender: TObject; var Key: Char);
begin
    if key<>#13 then exit;
    if lview1.SelCount=0 then exit;
    lview1.Selected.SubItems.strings[4]:=(sender as tedit).text;
    edit11.setfocus;
    lbltishi.caption:='請輸入商品編碼或條形碼';
    edit11.setfocus;
end;

procedure Tfm_tjdmx.BBtndelClick(Sender: TObject);
begin
    if lview1.SelCount=0 then exit;
    if application.MessageBox(pchar('確定要刪除選中進貨記錄'),pchar('警告'),mb_YESNO)<>IDYES then exit;

    lview1.Selected.Delete;
end;

procedure Tfm_tjdmx.BBtncancelClick(Sender: TObject);
begin
    close;
end;

procedure Tfm_tjdmx.BBtnSaveClick(Sender: TObject);
var
insertsql:string;
lsh,rq,shrm,czym:string;
spbm,sptxm,tjqdj,tjhdj,remark:string;
i:integer;
begin
   if application.MessageBox(pchar('保存后而退出？'),pchar('警告'),mb_YESNO)<>IDYES then exit;
   if edit1.text='' then
   begin
        showmessage('還未填寫進貨單');
        exit;
   end;
   if lview1.Items.Count<1 then
   begin
        showmessage('尚未錄入進貨單明細記錄');
        exit;
   end;
   lsh:=edit1.text;
   datetimetostring(rq,'yyyy-mm-dd',dtpicker1.datetime);
   shrm:=edit9.text;
   czym:=edit10.text;
   query1.Active:=false;
   query1.sql.clear;
   insertsql:='insert into tb_tjd(lsh,rq,czym,shrm) values(';
   query1.sql.add(insertsql);
   insertsql:=lsh+','''+rq+''','''+czym+''','''+shrm+''')';
   query1.sql.add(insertsql);
   query1.ExecSQL;
   for i:=0 to lview1.items.count-1 do
   begin
       spbm:=lview1.items[i].caption;
       sptxm:=lview1.items[i].subitems[0];
       tjqdj:=lview1.items[i].subitems[2];
       tjhdj:=lview1.items[i].subitems[3];
       remark:=lview1.items[i].subitems[4];
       query1.sql.clear;
       query1.sql.add('insert into tb_tjdmx(lsh,spbm,sptxm,tjqdj,tjhdj,remark) values(');
       query1.sql.add(lsh+','''+spbm+''','''+sptxm+''','+tjqdj+','+tjhdj+','''+remark+''')');
       query1.ExecSQL;
   end;
   lview1.Items.Clear;
   AddOptRecord('生成進貨入庫單:流水號('+lsh+')');
   close;
end;

procedure Tfm_tjdmx.FormCloseQuery(Sender: TObject; var CanClose: Boolean);
begin
    if lview1.Items.count=0 then exit;
    if application.MessageBox(pchar('不保存而退出？'),pchar('警告'),mb_YESNO)<>IDYES then
    canclose:=false;
end;

procedure Tfm_tjdmx.LView1Click(Sender: TObject);
var
i:integer;
begin
    if lview1.SelCount=1 then
    begin
         i:=lview1.Selected.Index; 
       edit11.text:=lview1.Selected.caption;
       edit13.text:=lview1.Selected.subitems[2];
       edit7.text:=lview1.Selected.subitems[3];
       edit5.text:=lview1.Selected.subitems[4];
    end;
end;

procedure Tfm_tjdmx.BBtnshrClick(Sender: TObject);
begin
    Application.CreateForm(Tfm_selyuangong, fm_selyuangong);
    fm_selyuangong.showmodal;
    edit9.text:=fm_selyuangong.ygbm;
    fm_selyuangong.free;
end;

end.