cllr.pas

来自「应对服装行业的生产成本控制系统」· PAS 代码 · 共 1,080 行 · 第 1/2 页

unit cllr;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, StdCtrls, Buttons, ComCtrls, Grids, DBGrids, ExtCtrls, DBCtrls,
  DB, ADODB, DBClient;

type
  TFrmcllr = class(TForm)
    Pz: TPanel;
    Label25: TLabel;
    Label26: TLabel;
    Label28: TLabel;
    Label29: TLabel;
    Label41: TLabel;
    SpeedButton3: TSpeedButton;
    help: TLabel;
    GroupBox4: TGroupBox;
    tfb: TEdit;
    tys: TEdit;
    tgh: TEdit;
    tfz: TEdit;
    Label3: TLabel;
    Label4: TLabel;
    Label5: TLabel;
    tsl: TEdit;
    tbz: TEdit;
    tdj: TEdit;
    Label6: TLabel;
    Label7: TLabel;
    Label8: TLabel;
    tyg: TEdit;
    DBGrid1: TDBGrid;
    Pd: TPanel;
    Label1: TLabel;
    rq: TDateTimePicker;
    Label2: TLabel;
    tcz: TEdit;
    pq: TPanel;
    csq: TCheckBox;
    cddh: TCheckBox;
    qddh: TEdit;
    cjglx: TCheckBox;
    csz: TCheckBox;
    sz: TDateTimePicker;
    qjglx: TEdit;
    ckhmc: TCheckBox;
    qkhmc: TEdit;
    ccpmc: TCheckBox;
    qcpmc: TEdit;
    csl: TCheckBox;
    ccpfl: TCheckBox;
    qsl: TEdit;
    qcpfl: TEdit;
    ccpdw: TCheckBox;
    cdj: TCheckBox;
    qcpdw: TEdit;
    qdj: TEdit;
    sq: TDateTimePicker;
    cwgzt: TCheckBox;
    cje: TCheckBox;
    qwgzt: TEdit;
    qje: TEdit;
    Cjq: TCheckBox;
    Cjz: TCheckBox;
    jz: TDateTimePicker;
    jq: TDateTimePicker;
    tgxmc: TEdit;
    bnew: TBitBtn;
    bsave: TBitBtn;
    bcancel: TBitBtn;
    bprint: TBitBtn;
    breturn: TBitBtn;
    Bquery: TBitBtn;
    GroupBox1: TGroupBox;
    DBGrid5: TDBGrid;
    txs: TEdit;
    Label9: TLabel;
    tbh: TEdit;
    Label10: TLabel;
    tcm: TEdit;
    DBGrid2: TDBGrid;
    DBGrid3: TDBGrid;
    DBGrid6: TDBGrid;
    procedure tslKeyPress(Sender: TObject; var Key: Char);
    procedure tdjKeyPress(Sender: TObject; var Key: Char);
    procedure tghKeyPress(Sender: TObject; var Key: Char);
    procedure tfzKeyPress(Sender: TObject; var Key: Char);
    procedure tfbKeyPress(Sender: TObject; var Key: Char);
    procedure tysKeyPress(Sender: TObject; var Key: Char);
    procedure tbzKeyPress(Sender: TObject; var Key: Char);
    procedure bcancelClick(Sender: TObject);
    procedure bprintClick(Sender: TObject);
    procedure breturnClick(Sender: TObject);
    procedure DBGrid1TitleClick(Column: TColumn);
    procedure bsaveClick(Sender: TObject);
    procedure FormActivate(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure DBGrid1DrawColumnCell(Sender: TObject; const Rect: TRect;
      DataCol: Integer; Column: TColumn; State: TGridDrawState);
    procedure tygKeyPress(Sender: TObject; var Key: Char);
    procedure rqKeyPress(Sender: TObject; var Key: Char);
    procedure tczKeyPress(Sender: TObject; var Key: Char);
    procedure BqueryClick(Sender: TObject);
    procedure DBGrid1DblClick(Sender: TObject);
    procedure tbhKeyPress(Sender: TObject; var Key: Char);
    procedure tcmKeyPress(Sender: TObject; var Key: Char);
    procedure txsKeyPress(Sender: TObject; var Key: Char);
    procedure DBGrid5TitleClick(Column: TColumn);
    procedure DBGrid5DrawColumnCell(Sender: TObject; const Rect: TRect;
      DataCol: Integer; Column: TColumn; State: TGridDrawState);
    procedure DBGrid2DblClick(Sender: TObject);
    procedure DBGrid3DblClick(Sender: TObject);
    procedure DBGrid6DblClick(Sender: TObject);
    procedure tygChange(Sender: TObject);
    procedure tgxmcChange(Sender: TObject);
    procedure tbhChange(Sender: TObject);
    procedure bnewClick(Sender: TObject);
    procedure SpeedButton3Click(Sender: TObject);
    procedure tgxmcKeyPress(Sender: TObject; var Key: Char);
    procedure txsChange(Sender: TObject);
  private
    { Private declarations }
      rzczy,rzsj,rzjsj,rzcsj,clh:string;
      errzt: integer;
      errcode:boolean;
  commandstring,commandstringq: string;
  function check():boolean;
  function khchange():boolean;
  function save():boolean;
  function errdelete():boolean;
  public
    { Public declarations }

  end;

var
  Frmcllr: TFrmcllr;

implementation

uses unit28, Unit1, Unit16, xtfz, gx, yg;

{$R *.dfm}

procedure TFrmcllr.tslKeyPress(Sender: TObject; var Key: Char);
begin
if not (key in['0'..'9',#8,#13,'.']) then
begin
key:=#0;
help.caption:='   请输入数字!';
end;
if key=#13 then tcz.SetFocus;
end;

procedure TFrmcllr.tdjKeyPress(Sender: TObject; var Key: Char);
begin
if not (key in['0'..'9',#8,#13,'.','-']) then
begin
key:=#0;
help.caption:='   请输入数字!';
end;
if key=#13 then tsl.SetFocus;
end;

procedure TFrmcllr.tghKeyPress(Sender: TObject; var Key: Char);
begin
if key=#13 then tfb.SetFocus;
end;

procedure TFrmcllr.tfzKeyPress(Sender: TObject; var Key: Char);
begin
if key=#13 then tyg.SetFocus;
end;

procedure TFrmcllr.tfbKeyPress(Sender: TObject; var Key: Char);
begin
if key=#13 then tfz.SetFocus;
end;

procedure TFrmcllr.tysKeyPress(Sender: TObject; var Key: Char);
begin
if key=#13 then tcm.SetFocus;
end;

procedure TFrmcllr.tbzKeyPress(Sender: TObject; var Key: Char);
begin
if not bsave.Enabled then exit;
if key=#13 then bsave.SetFocus;
end;

function TFrmcllr.check:boolean;
begin
  result:=true;
  if trim(tgh.Text)='' then
    begin
    showmessage('请您输入工号!');
    result:=false;
    tgh.SetFocus;
    exit;
    end;
  if trim(tfb.Text)='' then
    begin
    showmessage('请您输入分部!');
    result:=false;
    tfb.SetFocus;
    exit;
    end;
  if trim(tfz.Text)='' then
   begin
    showmessage('请您输入分组!');
    result:=false;
    tfz.SetFocus;
    exit;
    end;
  if trim(tyg.Text)='' then
   begin
    showmessage('请您输入员工!');
    result:=false;
    tyg.SetFocus;
    exit;
    end;
 if trim(tgxmc.Text)='' then
   begin
    showmessage('请您输入工序!');
    result:=false;
    tgxmc.SetFocus;
    exit;
    end;
 if trim(txs.Text)='' then
   begin
    showmessage('请您输入系数!');
    result:=false;
    txs.SetFocus;
    exit;
    end;
  if trim(tsl.Text)='' then
   begin
    showmessage('请您输入数量!');
    result:=false;
    tsl.SetFocus;
    exit;
    end;
  if trim(tcz.Text)='' then
   begin
    showmessage('请您输入产值!');
    result:=false;
    tcz.SetFocus;
    exit;
    end;
    end;

function tFrmcllr.khchange:boolean;
    var
    relation,cx:string;
    begin
    relation:=' = ''';
    cx:='';
    commandstring:='select top 10 * from dbo.cllrb';
    if trim(tyg.Text)<>'' then
    begin
    commandstring:=commandstring+' where (yg'+relation+cx+trim(tyg.Text)+cx+''')'+' order by clh desc';;
    DataModule1.ClientDataSet25.Close;
    DataModule1.ClientDataSet25.CommandText:=commandstring;
    DataModule1.ClientDataSet25.Open;
    end;
    end;

function TFrmcllr.save:boolean;
 begin
 try
 tgh.Text:=trim(tgh.Text);
 tfb.Text:=trim(tfb.text);
 tfz.Text:=trim(tfz.Text);
 tyg.Text:=trim(tyg.Text);
 tbh.Text:=trim(tbh.Text);
 tys.Text:=trim(tys.Text);
 tcm.Text:=trim(tcm.text);
 tgxmc.Text:=trim(tgxmc.Text);
 txs.Text:=trim(txs.Text);
 tdj.Text:=trim(tdj.Text);
 tsl.Text:=trim(tsl.Text);
 tcz.Text:=trim(tcz.Text);
 tbz.Text:=trim(tbz.Text);
 errcode:=true;
 errzt:=1;
if not DataModule1.ClientDataSet25.Locate('clh',clh,[]) then
   begin
 DataModule1.clientdataset25.Edit;
 DataModule1.ClientDataSet25.First;
 DataModule1.clientdataset25.Insert;  //+clh
 DataModule1.clientdataset25.FieldByName('clh').AsString:=clh;
 DataModule1.clientdataset25.FieldByName('ddh').AsString:=DataModule1.clientdataset17.FieldByName('ddh').AsString;
 DataModule1.clientdataset25.FieldByName('rq').AsDateTime:=rq.Date;
 DataModule1.clientdataset25.FieldByName('gh').AsString:=tgh.Text;
 DataModule1.clientdataset25.FieldByName('fb').AsString:=tfb.Text;
 DataModule1.clientdataset25.FieldByName('fz').AsString:=tfz.Text;
 DataModule1.clientdataset25.FieldByName('yg').AsString:=tyg.Text;
 DataModule1.clientdataset25.FieldByName('bh').AsString:=tbh.Text;
 DataModule1.clientdataset25.FieldByName('ys').AsString:=tys.Text;
 DataModule1.clientdataset25.FieldByName('cm').AsString:=tcm.Text;
 DataModule1.clientdataset25.FieldByName('sl').AsString:=tsl.Text;
 DataModule1.clientdataset25.FieldByName('gxmc').AsString:=tgxmc.Text;
 DataModule1.clientdataset25.FieldByName('dj').AsString:=tdj.Text;
 DataModule1.clientdataset25.FieldByName('xs').AsString:=txs.Text;
 DataModule1.clientdataset25.FieldByName('cz').AsString:=tcz.Text;
 DataModule1.clientdataset25.FieldByName('bz').AsString:=tbz.Text;
 DataModule1.clientdataset25.FieldByName('czy').AsString:=trim(form1.StatusBar1.Panels[4].text);
 DataModule1.clientdataset25.ApplyUpdates(-1);
 end;
 errcode:=false;
 errzt:=0;
 except
  errcode:=true;
  errzt:=1;
  showmessage('数据库没有打开!');
  end;
end;

procedure TFrmcllr.bcancelClick(Sender: TObject);
begin
bnew.Enabled:=false;
bsave.Enabled:=false;
bcancel.Enabled:=false;
bprint.Enabled:=false;
bquery.Enabled:=true;
tgh.Text:='';
tfb.Text:='';
tfz.Text:='';
tyg.Text:='';
tbh.Text:='';
tys.Text:='';
tcm.Text:='';
tgxmc.Text:='';
txs.Text:='';
tdj.Text:='';
tsl.Text:='';
tcz.Text:='';
tbz.Text:='';
help.Caption:='  继续录入请您重新选择!';
dbgrid1.Enabled:=true;
end;

procedure TFrmcllr.bprintClick(Sender: TObject);
begin
help.Caption:='   暂不提供打印功能!';
end;

procedure TFrmcllr.breturnClick(Sender: TObject);
begin
try
rzcsj:=datetimetostr(now);
form16.WriteTorz(rzczy,rzsj,rzjsj,rzcsj);
DataModule1.ClientDataSet17.IndexFieldNames:='';
DataModule1.ClientDataSet25.IndexFieldNames:='';
if DataModule1.clientdataset17.Active then  DataModule1.ClientDataSet17.Active:=false;
if DataModule1.clientdataset25.Active then  DataModule1.ClientDataSet25.Active:=false;
if DataModule1.ClientDataSet3.Active then DataModule1.ClientDataSet3.Active:=false;
if DataModule1.clientdataset23.Active then DataModule1.ClientDataSet23.Active:=false;
if DataModule1.ClientDataSet24.Active then DataModule1.ClientDataSet24.Active:=false;
except
showmessage('数据库没有打开!');
end;
close;
end;

procedure TFrmcllr.DBGrid1TitleClick(Column: TColumn);
var i : integer;
begin
for i:= 1 to DBGrid1.Columns.Count do
begin
//恢复所有标题字体为默认
DBGrid1.Columns[i-1].Title.Font.Color := clBlue;
DBGrid1.Columns[i-1].Title.Font.Style := [];
end;
if DataModule1.ClientDataSet17.IndexFieldNames<>(Column.FieldName) then //判断原排序方式
begin
DataModule1.ClientDataSet17.IndexFieldNames:= Column.FieldName;
Column.Title.Font.Color := clRed; //改变标题行字体为红色，表示当前的排序方式为升序
Column.Title.Font.Style := [fsBold];
end;
end;

procedure TFrmcllr.bsaveClick(Sender: TObject);
var
datestr:string;
begin
if not bsave.Enabled then exit;
bsave.Enabled:=false;
bcancel.Enabled:=false;
errcode:=true;
errzt:=1;
if not check then
begin
bsave.Enabled:=true;
bcancel.Enabled:=true;
 exit;
 end;
datestr:=frmxtfz.checkfzrq(formatdatetime('yyyy-mm-dd',rq.date));
if datestr<>'' then
begin
help.Caption:='  封账日期为'+datestr+',您不能添加封账日期前的数据';
exit;
end;
form1.ddh:=DataModule1.ClientDataSet17.fieldbyname('ddh').AsString;
form1.gxmc:=trim(tgxmc.Text);
form1.dj:=trim(tdj.Text);
frmgx.checkgx(form1.ddh,form1.gxmc,form1.dj);
if form1.gxmc='' then
begin
bsave.Enabled:=true;
bcancel.Enabled:=true;
tgxmc.SetFocus;
help.Caption:='  该工序不存在,请您输入正确的工序!';
 exit;
 end;
form1.ddh:='';
form1.gxmc:='';
form1.dj:='';
form1.yg:=trim(tyg.Text);
form1.gh:=trim(tgh.Text);
form1.fb:=trim(tfb.Text);
form1.fz:=trim(tfz.Text);
frmyg.checkyg(form1.yg,form1.gh,form1.fb,form1.fz);
if form1.yg='' then
begin
bsave.Enabled:=true;
bcancel.Enabled:=true;
tyg.SetFocus;
help.Caption:='  该员工不存在,请您输入正确的员工!';
 exit;
 end;
form1.yg:='';
form1.gh:='';
form1.fb:='';
form1.fz:='';
try
form1.dorandombh;
DataModule1.clientdataset11.Refresh;
DataModule1.ClientDataSet11.First;
clh:=floattostr(DataModule1.clientdataset11.FieldByName('clh').AsFloat)+form1.randombh+form1.tbh.Text;
DataModule1.ClientDataSet11.Edit;
DataModule1.ClientDataSet11.FieldByName('clh').AsFloat:= DataModule1.ClientDataSet11.FieldByName('clh').AsFloat+1;
DataModule1.ClientDataSet11.ApplyUpdates(-1);
save;
if errcode or (errzt<>0) then save;
if errcode or (errzt<>0) then save;
if errcode or (errzt<>0) then save;
if errcode or (errzt<>0) then
begin
showmessage('   数据库在保存主记录时失败,请您稍后重新保存!');
errdelete;
bsave.Enabled:=true;
bcancel.Enabled:=true;
exit;
end;
help.Caption:='   员工产量录入成功!' ;
tgh.Text:='';
tfb.Text:='';
tfz.Text:='';
tyg.Text:='';
tbh.Text:='';
tys.Text:='';
tcm.Text:='';
tgxmc.Text:='';
txs.Text:='';
tdj.Text:='';
tsl.Text:='';
tcz.Text:='';
tbz.Text:='';
bprint.Enabled:=true;
bnew.Enabled:=true;
bnew.SetFocus;
pz.Enabled:=false;
except
bsave.Enabled:=true;
bcancel.Enabled:=true;
showmessage('     记录员工产量时出现了系统无法识别的错误,请您主动辨别该错误!');
end;
end;

function tFrmcllr.errdelete:boolean;
var
relation,cx:string;
begin
 relation:=' = ''';
 cx:='';
    try
  commandstring:='delete from dbo.cllrb';
  commandstring:=commandstring+' where (dbo.cllrb.clh'+relation+cx+clh+cx+''')';
  commandstring:=commandstring+' and (dbo.cllrb.ddh'+relation+cx+DataModule1.ClientDataSet17.fieldbyname('ddh').AsString+cx+''')';
  DataModule1.ClientDataSet25.CommandText:=commandstring;
  DataModule1.ClientDataSet25.Execute;
  khchange;
  except
  showmessage('数据库没有打开')
  end;
  end;

procedure TFrmcllr.FormActivate(Sender: TObject);
var
commandstring,relation,cx,str:string;
begin
rzjsj:=datetimetostr(now);
rzczy:=form1.StatusBar1.Panels[4].Text;
rzsj:='员工产量录入';
rq.DateTime:=date;
sq.DateTime:=date-30;
sz.DateTime:=date;
jq.DateTime:=date;
jz.DateTime:=date+30;
help.Caption:='';
bquery.Enabled:=true;
bnew.Enabled:=false;
bsave.Enabled:=false;
bcancel.Enabled:=false;
bprint.Enabled:=false;
pz.Enabled:=false;
help.Caption:='  请您点击< 查询>按钮开始查询订单记录!';
end;

procedure TFrmcllr.FormClose(Sender: TObject; var Action: TCloseAction);
begin
try
DataModule1.ClientDataSet17.IndexFieldNames:='';
DataModule1.ClientDataSet25.IndexFieldNames:='';
if DataModule1.clientdataset17.Active then  DataModule1.ClientDataSet17.Active:=false;
if DataModule1.clientdataset25.Active then  DataModule1.ClientDataSet25.Active:=false;
if DataModule1.ClientDataSet3.Active then DataModule1.ClientDataSet3.Active:=false;
if DataModule1.clientdataset23.Active then DataModule1.ClientDataSet23.Active:=false;
if DataModule1.ClientDataSet24.Active then DataModule1.ClientDataSet24.Active:=false;
if rzcsj<>'' then exit;
rzcsj:=datetimetostr(now);
form16.WriteTorz(rzczy,rzsj,rzjsj,rzcsj);
except
showmessage('数据库没有打开!');
end;
close;