ukhfl.pas

已经投入使用的商业级管理系统：液化气管理系统。 附带全部源码

unit UKHFL;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, GridsEh, DBGridEh, ExtCtrls, frxClass, frxDBSet, DB, ComCtrls,
  ToolWin, StdCtrls, Mask, DBCtrls;

type
  TFKHFL = class(TForm)
    ToolBar1: TToolBar;
    ToolButton1: TToolButton;
    ToolButton2: TToolButton;
    ToolButton3: TToolButton;
    ToolButton4: TToolButton;
    ToolButton5: TToolButton;
    ToolButton6: TToolButton;
    DataSource1: TDataSource;
    frxReport1: TfrxReport;
    frxDBDataset1: TfrxDBDataset;
    Panel1: TPanel;
    DBGridEh1: TDBGridEh;
    Panel2: TPanel;
    Panel3: TPanel;
    Panel4: TPanel;
    DBGridEh2: TDBGridEh;
    Label1: TLabel;
    Label2: TLabel;
    ToolButton7: TToolButton;
    ToolButton8: TToolButton;
    DataSource2: TDataSource;
    DBEdit1: TDBEdit;
    procedure ToolButton1Click(Sender: TObject);
    procedure ToolButton2Click(Sender: TObject);
    procedure FormShow(Sender: TObject);
    procedure ToolButton5Click(Sender: TObject);
    procedure ToolButton8Click(Sender: TObject);
    procedure DBEdit1Change(Sender: TObject);
    procedure ToolButton6Click(Sender: TObject);
    procedure ToolButton3Click(Sender: TObject);
    procedure ToolButton7Click(Sender: TObject);
  private
    procedure KHFLcHANG;
    { Private declarations }
  public
    { Public declarations }
  end;

var
  FKHFL: TFKHFL;

implementation
  USES MAIN,U_dm,UADDKHFL,UADDSPYH,UsysPub,UsysConst;
{$R *.dfm}
procedure TFKHFL.KHFLcHANG;
var
  strSQL:string;
BEGIN
  strSQL:='select a.门店编号,a.分类编号,b.分类名称,a.商品编号,c.品名规格,a.单价优惠,'
  +'a.运费优惠 from JG商品优惠 a,JG客户分类 b,JG商品资料 c where (a.门店编号=b.门店编号)'
  +'and(a.分类编号=b.分类编号)and(a.门店编号=c.门店编号)and(a.商品编号=c.商品编号)'
  +'and(a.门店编号='+''''+Trim(dm.ADOQ_KHFL.fieldbyname('门店编号').AsString)+''''+')and(a.分类编号='+''''+Trim(dm.ADOQ_KHFL.fieldbyname('分类编号').AsString)+''''+')';
  RunSQL(DM.ADOQ_SPYH,strSQL,0);
END;

procedure TFKHFL.ToolButton1Click(Sender: TObject);
begin
  strCZZT:='ADD';
  try
    Application.CreateForm(TFADDKHFL, FADDKHFL);
    FADDKHFL.ShowModal;
  finally
    FADDKHFL.Free;
  end;
end;

procedure TFKHFL.ToolButton2Click(Sender: TObject);
begin
  if DM.ADOQ_KHFL.RecordCount<=0 then
    abort;
  strCZZT:='MODIFY';
  try
    Application.CreateForm(TFADDKHFL, FADDKHFL);
    FADDKHFL.ShowModal;
  finally
    FADDKHFL.Free;
  end;
end;

procedure TFKHFL.FormShow(Sender: TObject);
var
  strSQL:string;
begin
  strSQL:='SELECT * FROM JG客户分类';
  RunSQL(DM.ADOQ_KHFL,strSQL,0);
  KHFLcHANG;
end;

procedure TFKHFL.ToolButton5Click(Sender: TObject);
begin
  strCZZT:='ADD';
  try
    Application.CreateForm(TFADDSPYH, FADDSPYH);
    FADDSPYH.ShowModal;
    KHFLcHANG;
  finally
    FADDSPYH.Free;
  end;
end;

procedure TFKHFL.ToolButton8Click(Sender: TObject);
begin
  self.Close;
end;

procedure TFKHFL.DBEdit1Change(Sender: TObject);
begin
   KHFLcHANG;
end;

procedure TFKHFL.ToolButton6Click(Sender: TObject);
begin
  if DM.ADOQ_SPYH.RecordCount<=0 then
    abort;
  strCZZT:='MODIFY';
  try
    Application.CreateForm(TFADDSPYH, FADDSPYH);
    FADDSPYH.ShowModal;
    KHFLcHANG;    
  finally
    FADDSPYH.Free;
  end;
end;

procedure TFKHFL.ToolButton3Click(Sender: TObject);
var
  strSQL,strID,strtmp,strmc:string;
begin
  if DM.ADOQ_KHFL.RecordCount<=0 then
    abort;
  strID:=Trim(DM.ADOQ_KHFL.fieldbyname('分类编号').AsString);
  strtmp:=Trim(DM.ADOQ_KHFL.fieldbyname('门店编号').AsString);
  strmc:=Trim(DM.ADOQ_KHFL.fieldbyname('分类名称').AsString);
  case messagebox(handle,pchar('真的要删除【'+strmc+'】吗？'),MsgBxCaption,mb_iconquestion+MB_YESNO) of
  ID_yes:
  begin
    strSQL:='delete from JG客户分类 where (门店编号='+''''+strtmp+''''+')and(分类编号='+''''+strID+''''+')';
    RunSQL(DM.m_clADOQry_Temp,strSQL,1);
    strSQL:='delete from JG商品优惠 where (门店编号='+''''+strtmp+''''+')and(分类编号='+''''+strID+''''+')';
    if RunSQL(DM.m_clADOQry_Temp,strSQL,1) then
    begin
      strSQL:='SELECT * FROM JG客户分类';
      RunSQL(DM.ADOQ_KHFL,strSQL,0);
      KHFLcHANG;
    end
    else
    begin
      Application.MessageBox('删除数据出错！',MsgBxCaption,MB_OK);
    end;
  end;
  ID_no: abort;
  END;
end;

procedure TFKHFL.ToolButton7Click(Sender: TObject);
var
  strSQL,strID,strtmp,strmc:string;
begin
  if DM.ADOQ_SPYH.RecordCount<=0 then
    abort;
  strID:=Trim(DM.ADOQ_SPYH.fieldbyname('分类编号').AsString);
  strtmp:=Trim(DM.ADOQ_SPYH.fieldbyname('门店编号').AsString);
  strmc:=Trim(DM.ADOQ_SPYH.fieldbyname('商品编号').AsString);
  case messagebox(handle,pchar('真的要删除该记录吗？'),MsgBxCaption,mb_iconquestion+MB_YESNO) of
  ID_yes:
  begin
    strSQL:='delete from JG商品优惠 where (门店编号='+''''+strtmp+''''+')and(分类编号='+''''+strID+''''+')and(商品编号='+''''+strmc+''''+')';
    if RunSQL(DM.m_clADOQry_Temp,strSQL,1) then
    begin
      KHFLcHANG;
    end
    else
    begin
      Application.MessageBox('删除数据出错！',MsgBxCaption,MB_OK);
    end;
  end;
  ID_no: abort;
  END;
end;

end.