?? unit_input_cgth.pas

?? DELPHI 編寫的繡花廠管理軟件
?? PAS
字號:
unit Unit_input_cgth;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, Unit_jc_child, Grids, DBGrids, ExtCtrls, StdCtrls, Mask, DBCtrls,
  ToolEdit, RXDBCtrl, Buttons, DB, ADODB, RM_dset, RM_dbset, RM_class;

type
  Tform_input_cgth = class(TForm_jc_child)
    Panel1: TPanel;
    DBGrid1: TDBGrid;
    Label1: TLabel;
    DBEdit1: TDBEdit;
    Label2: TLabel;
    DBDateEdit1: TDBDateEdit;
    Label5: TLabel;
    Label6: TLabel;
    DBComboBox2: TDBComboBox;
    DBComboBox3: TDBComboBox;
    Label7: TLabel;
    DBEdit2: TDBEdit;
    Label8: TLabel;
    DBEdit3: TDBEdit;
    Label9: TLabel;
    DBEdit4: TDBEdit;
    Panel2: TPanel;
    BitBtn_new_dj: TBitBtn;
    BitBtn_save: TBitBtn;
    BitBtn_delete_dj: TBitBtn;
    BitBtn_new_sp: TBitBtn;
    BitBtn_delete_sp: TBitBtn;
    BitBtn_quit: TBitBtn;
    ADOQuery1: TADOQuery;
    DataSource1: TDataSource;
    DataSource2: TDataSource;
    ADOQuery2: TADOQuery;
    ADOQuery3: TADOQuery;
    BitBtn_prior: TBitBtn;
    BitBtn_next: TBitBtn;
    BitBtn_end: TBitBtn;
    Panel3: TPanel;
    Label11: TLabel;
    Edit_dh: TEdit;
    BitBtn_find: TBitBtn;
    Label3: TLabel;
    SpeedButton1: TSpeedButton;
    Edit_gys: TEdit;
    procedure BitBtn_quitClick(Sender: TObject);
    procedure FormCreate(Sender: TObject);
    procedure ADOQuery1AfterClose(DataSet: TDataSet);
    procedure BitBtn_priorClick(Sender: TObject);
    procedure BitBtn_nextClick(Sender: TObject);
    procedure BitBtn_new_djClick(Sender: TObject);
    procedure BitBtn_saveClick(Sender: TObject);
    procedure ADOQuery1AfterInsert(DataSet: TDataSet);
    procedure ADOQuery2AfterInsert(DataSet: TDataSet);
    procedure BitBtn_delete_djClick(Sender: TObject);
    procedure BitBtn_new_spClick(Sender: TObject);
    procedure BitBtn_delete_spClick(Sender: TObject);
    procedure BitBtn_endClick(Sender: TObject);
    procedure Edit_dhKeyDown(Sender: TObject; var Key: Word;
      Shift: TShiftState);
    procedure BitBtn_findClick(Sender: TObject);
    procedure FormShow(Sender: TObject);
    procedure ADOQuery1AfterScroll(DataSet: TDataSet);
    procedure DBDateEdit1Change(Sender: TObject);
    procedure DBGrid1KeyDown(Sender: TObject; var Key: Word;
      Shift: TShiftState);
    procedure SpeedButton1Click(Sender: TObject);
  private
    { Private declarations }
    sqlstr,sqlstr2 : string;
    function f_get_bh(strdate:string):STRING;      //跟據日期得到單號
  public
    { Public declarations }
     main_tab,child_tab,main_key,child_key : string;
  end;

var
  form_input_cgth: Tform_input_cgth;

implementation

uses Unit_main, Unit_get_gys, Unit_get_cgsp, Unit_get_kh;

{$R *.dfm}

procedure Tform_input_cgth.BitBtn_quitClick(Sender: TObject);
begin
   self.Close;
end;

procedure Tform_input_cgth.FormCreate(Sender: TObject);
begin
   inherited;
   sqlstr := ADOQuery1.sql.text;
   sqlstr2 := ADOQuery2.sql.text;
end;

procedure Tform_input_cgth.ADOQuery1AfterClose(DataSet: TDataSet);
begin
   Edit_gys.Text := '';
   ADOQuery2.Close;
end;

procedure Tform_input_cgth.BitBtn_priorClick(Sender: TObject);
begin
   if not ADOQuery1.Active then exit;
   //找到最近的主表ID
   ADOQuery3.Close;
   ADOQuery3.SQL.Text := 'select max(t0500) as id from t05 where t0500<'+ADOQuery1.fieldbyname('t0500').AsString;
   ADOQuery3.Open;
   if ADOQuery3.fieldbyname('id').asstring = '' then
      showmessage('當前已經是第一張單據！')
   else
   begin
     ADOQuery1.Close;
     ADOQuery1.SQL.Text := sqlstr + ' where t0500='+ADOQuery3.fieldbyname('id').asstring;
     ADOQuery1.open;
   end;
end;

procedure Tform_input_cgth.BitBtn_nextClick(Sender: TObject);
begin
   if not ADOQuery1.Active then exit;
   //找到最近的主表ID
   ADOQuery3.Close;
   ADOQuery3.SQL.Text := 'select min(t0500) as id from t05 where t0500>'+ADOQuery1.fieldbyname('t0500').AsString;
   ADOQuery3.Open;
   if ADOQuery3.fieldbyname('id').asstring = '' then
      showmessage('當前已經是最后一張單據！')
   else
   begin
     ADOQuery1.Close;
     ADOQuery1.SQL.Text := sqlstr + ' where t0500='+ADOQuery3.fieldbyname('id').asstring;
     ADOQuery1.open;
   end;
end;

procedure Tform_input_cgth.BitBtn_new_djClick(Sender: TObject);
var id : integer;
begin
   //插入記錄到主表
   ADOQuery3.Close;
   ADOQuery3.SQL.Text := 'insert into t05(t0501,t0507) values('''+f_get_bh(formatdatetime('YYYYMMDD',form_main.f_get_now))+
      ''','''+gs_username+''')';
   ADOQuery3.ExecSQL;
   //得到剛插入那條記錄的ID
   ADOQuery3.Close;
   ADOQuery3.SQL.Text := 'select max(t0500) as id from t05';
   ADOQuery3.Open;
   id := ADOQuery3.fieldbyname('id').AsInteger;
   //刷新主表顯示
   ADOQuery1.Close;
   ADOQuery1.SQL.Text := sqlstr + ' where t0500='+inttostr(id);
   ADOQuery1.open;
end;

function Tform_input_cgth.f_get_bh(strdate:string):STRING;
var i : integer;
begin
   //得到最大的單號
   ADOQuery3.Close;
   ADOQuery3.SQL.Text := 'select max(t0501) as bh from t05 where left(t0501,8)='''+strdate+'''';
   ADOQuery3.Open;
   if ADOQuery3.fieldbyname('bh').AsString='' then      //當天沒有單子賦001
      f_get_bh := strdate+'001'
   else
   begin                        //加一
      i := strtoint(copy(ADOQuery3.fieldbyname('bh').AsString,9,3))+1;
      if i<10 then f_get_bh := strdate+'00'+inttostr(i);
      if (i<100) and (i>9) then f_get_bh := strdate+'0'+inttostr(i);
      if i>99 then f_get_bh := strdate+inttostr(i);
   end;
end;


procedure Tform_input_cgth.BitBtn_saveClick(Sender: TObject);
begin
   if ADOQuery1.RecordCount = 0 then exit;
   ADOQuery1.Edit;
   ADOQuery1.Post;
   if ADOQuery2.Active = false then exit;
   if ADOQuery2.RecordCount = 0 then exit;
   ADOQuery2.Edit;
   ADOQuery2.Post;
   //合計金額
   ADOQuery3.Close;
   ADOQuery3.SQL.Text := 'select sum(t0605) as je from t06 where t0601='+ADOQuery1.fieldbyname('t0500').AsString;
   ADOQuery3.Open;
   ADOQuery1.Edit;
   ADOQuery1.FieldByName('t0505').AsFloat := ADOQuery3.fieldbyname('je').AsFloat;
   ADOQuery1.Post;
   //刷新顯示
   ADOQuery1.AfterScroll(ADOQuery1);
end;

procedure Tform_input_cgth.ADOQuery1AfterInsert(DataSet: TDataSet);
begin
   dataset.Delete;
end;

procedure Tform_input_cgth.ADOQuery2AfterInsert(DataSet: TDataSet);
begin
   dataset.Delete;
end;

procedure Tform_input_cgth.BitBtn_delete_djClick(Sender: TObject);
var id : string;
begin
   if not ADOQuery1.Active then exit;
   if ADOQuery1.RecordCount = 0 then exit;
   if MessageDlg('你確定要刪除這張單據嗎？', mtconfirmation,[mbYes,mbNo], 0)<>mrYes then exit;
   id := ADOQuery1.fieldbyname('t0500').AsString;
   //刪除主單，在此不用刪除子單，因為有級聯更新
   ADOQuery1.Delete;
   ADOQuery1.Close;
   ADOQuery2.Close;
   //找到最近的主表ID
   ADOQuery3.Close;
   ADOQuery3.SQL.Text := 'select min(t0500) as id from t05 where t0500>'+id;
   ADOQuery3.Open;
   if ADOQuery3.FieldByName('id').AsString = '' then
   begin
      ADOQuery3.Close;
      ADOQuery3.SQL.Text := 'select max(t0500) as id from t05 where t0500<'+id;
      ADOQuery3.Open;
      if ADOQuery3.FieldByName('id').AsString <> '' then
      begin
         ADOQuery1.Close;
         ADOQuery1.SQL.Text := sqlstr + ' where t0500='+ADOQuery3.FieldByName('id').AsString;
         ADOQuery1.open;
      end;
   end
   else
   begin
      ADOQuery1.Close;
      ADOQuery1.SQL.Text := sqlstr + ' where t0500='+ADOQuery3.FieldByName('id').AsString;
      ADOQuery1.open;
   end;
end;

procedure Tform_input_cgth.BitBtn_new_spClick(Sender: TObject);
begin
   if not ADOQuery1.Active then exit;
   if ADOQuery1.RecordCount = 0 then exit;
   if ADOQuery1.FieldByName('t0503').AsInteger = 0 then
   begin
      showmessage('請選擇客戶！');
      SpeedButton1.Click;
      exit;
   end;
   Form_get_cgsp.gysid:=ADOQuery1.fieldbyname('t0503').AsInteger;
   Form_get_cgsp.ShowModal;
   if Form_get_cgsp.spid = 0 then exit;
   //插入子表
   ADOQuery3.Close;
   ADOQuery3.SQL.Text := 'insert into t06(t0601,t0602) values('+ADOQuery1.fieldbyname('t0500').AsString+','+
      inttostr(Form_get_cgsp.spid)+')';
   ADOQuery3.ExecSQL;
   //刷新顯示
   BitBtn_save.Click;
   ADOQuery2.Close;
   ADOQuery2.Open;
   ADOQuery2.Last;
   DBGrid1.SetFocus;
   DBGrid1.SelectedIndex := 2;
end;

procedure Tform_input_cgth.BitBtn_delete_spClick(Sender: TObject);
begin
   if not ADOQuery1.Active then exit;
   if ADOQuery2.Active = false then exit;
   if ADOQuery2.RecordCount > 0 then ADOQuery2.Delete;
end;

procedure Tform_input_cgth.BitBtn_endClick(Sender: TObject);
begin
   if not ADOQuery1.Active then exit;
   //找到最后的主表ID
   ADOQuery3.Close;
   ADOQuery3.SQL.Text := 'select max(t0500) as id from t14';
   ADOQuery3.Open;
   ADOQuery1.Close;
   ADOQuery1.SQL.Text := sqlstr + ' where t0500='+ADOQuery3.fieldbyname('id').asstring;
   ADOQuery1.open;
end;

procedure Tform_input_cgth.Edit_dhKeyDown(Sender: TObject; var Key: Word;
  Shift: TShiftState);
begin
   if key <> 13 then exit;
   BitBtn_find.Click;
end;

procedure Tform_input_cgth.BitBtn_findClick(Sender: TObject);
begin
   //找到最近的主表ID
   ADOQuery3.Close;
   ADOQuery3.SQL.Text := 'select t0500 as id from t05 where t0501='''+trim(Edit_dh.Text)+'''';
   ADOQuery3.Open;
   if ADOQuery3.RecordCount = 0 then
      showmessage('找不到您輸入的單據！')
   else
   begin
     ADOQuery1.Close;
     ADOQuery1.SQL.Text := sqlstr + ' where t0500='+ADOQuery3.fieldbyname('id').asstring;
     ADOQuery1.open;
   end;
end;

procedure Tform_input_cgth.FormShow(Sender: TObject);
begin
   inherited;

   //產生付款方式列表
   ADOQuery3.close;
   ADOQuery3.SQL.text := 'select * from t13';
   ADOQuery3.Open;
   while not ADOQuery3.Eof do
   begin
      DBComboBox2.items.Add(ADOQuery3.fieldbyname('t1301').AsString);
      ADOQuery3.Next;
   end;
   //產生業(yè)務員列表
   ADOQuery3.close;
   ADOQuery3.SQL.text := 'select * from t01';
   ADOQuery3.Open;
   while not ADOQuery3.Eof do
   begin
      DBComboBox3.items.Add(ADOQuery3.fieldbyname('t0101').AsString);
      ADOQuery3.Next;
   end;
   //顯示主表
   ADOQuery3.Close;
   ADOQuery3.SQL.Text := 'select max(t0500) as id from t05';
   ADOQuery3.Open;
   ADOQuery1.Close;
   if ADOQuery3.FieldByName('id').AsString <> '' then
   begin
      ADOQuery1.SQL.Text := sqlstr + ' where t0500='+ADOQuery3.fieldbyname('id').asstring;
      ADOQuery1.open;
   end;
end;

procedure Tform_input_cgth.ADOQuery1AfterScroll(DataSet: TDataSet);
begin
   //刷新顯示供應商
   Edit_gys.Text := '';
   if DataSet.fieldbyname('t0503').AsString <> '' then
   begin
      ADOQuery3.Close;
      ADOQuery3.SQL.Text := 'select * from t02 where t0200='+DataSet.fieldbyname('t0503').AsString;
      ADOQuery3.Open;
      Edit_gys.Text := ADOQuery3.fieldbyname('t0202').AsString;
   end;
   //刷新顯示子表
   ADOQuery2.Close;
   if DataSet.fieldbyname('t0500').AsString <> '' then
   begin
      ADOQuery2.Close;
      ADOQuery2.SQL.Text := sqlstr2 + ' where t0601='+DataSet.fieldbyname('t0500').AsString;
      ADOQuery2.Open;
   end;
end;

procedure Tform_input_cgth.DBDateEdit1Change(Sender: TObject);
begin
   if ADOQuery1.Active = false then exit;
   if ADOQuery1.RecordCount = 0 then exit;
   if copy(ADOQuery1.FieldByName('t0501').AsString,1,8)<>formatdatetime('YYYYMMDD',ADOQuery1.fieldbyname('t0502').AsDateTime) then
   begin
      ADOQuery1.Edit;
      ADOQuery1.FieldByName('t0501').AsString := f_get_bh(formatdatetime('YYYYMMDD',ADOQuery1.fieldbyname('t0502').AsDateTime));
      ADOQuery1.Post;
   end;
end;

procedure Tform_input_cgth.DBGrid1KeyDown(Sender: TObject; var Key: Word;
  Shift: TShiftState);
begin
   if not ADOQuery1.Active then exit;
   if ADOQuery2.RecordCount = 0 then exit;
   if key <> 13 then exit;
   if DBGrid1.SelectedIndex + 1 < DBGrid1.FieldCount then
   begin
      if DBGrid1.SelectedIndex = 5 then   //產生金額
      begin
         ADOQuery2.Edit;
         ADOQuery2.Post;
         ADOQuery2.Edit;
         ADOQuery2.FieldByName('t0605').AsFloat := ADOQuery2.FieldByName('t0603').AsFloat * ADOQuery2.FieldByName('t0604').AsFloat;
      end;
      DBGrid1.SelectedIndex := DBGrid1.SelectedIndex + 1;
   end
   else
      if ADOQuery2.RecNo = ADOQuery2.RecordCount then
         BitBtn_new_sp.Click
      else
      begin
         ADOQuery2.Next;
         DBGrid1.SelectedIndex := 2;
      end;
end;

procedure Tform_input_cgth.SpeedButton1Click(Sender: TObject);
begin
  inherited;
   if ADOQuery1.Active = false then exit;
   if ADOQuery1.RecordCount = 0 then exit;
   Form_get_kh.ShowModal;
   if Form_get_kh.kh_id = 0 then exit;
   ADOQuery1.edit;
   ADOQuery1.FieldByName('t0503').AsInteger := Form_get_kh.kh_id;
   Edit_gys.Text := Form_get_kh.kh_mc;
end;

end.
?? 文件大小 276 K
?? 上傳用戶 quanliao77
?? 所屬分類 Delphi控件源碼
??? 相關標簽

#DELPHI #編寫 #管理軟件
?? 快捷鍵說明

復制代碼 Ctrl + C
搜索代碼 Ctrl + F
全屏模式 F11
切換主題 Ctrl + Shift + D
顯示快捷鍵 ?
增大字號 Ctrl + =
減小字號 Ctrl + -
亚洲欧美第一页_禁久久精品乱码_粉嫩av一区二区三区免费野_久草精品视频

?? unit_input_cgth.pas

?? 快捷鍵說明
