payw00_01.pas.svn-base

一个用Delphi开发的ERP软件

  cbType.ItemIndex:=0;
  cbTypeChange(cbType);
end;

procedure TPayW00_01Form.FormCreate(Sender: TObject);
begin
  SetInterface;
  GetYears(cbYear);
  GetMonths(StrToInt(cbYear.Text),cbMonth);
  //查询报表
  GetAllReport(adsReports,ActionList1,'PAY');
  //取得所有薪资项目
  RefreshPayItem;
  ActReg.Visible:=ADemoFlag;
  N1.Visible:=ADemoFlag;
end;

procedure TPayW00_01Form.FormClose(Sender: TObject;
  var Action: TCloseAction);
begin
  Action := caFree;
end;

procedure TPayW00_01Form.FormActivate(Sender: TObject);
begin
  Animate1.ResName:='HOWWELL';
  Animate1.Play(1,100,0);
  AModule:='PAY';
end;

procedure TPayW00_01Form.dbgMasterBackgroundDrawEvent(Sender: TObject;
  ACanvas: TCanvas; ARect: TRect);
var
  AText:string;
begin
  ARect.Left:=0;
  ARect.Top:=0;
  ACanvas.Brush.Color:=dbgMaster.GroupPanelColor;
  ACanvas.Font.Color:=dbgMaster.GroupPanelFontColor;
  //您可以把列标题拖放到此处使记录按此列进行分组
  if dbgMaster.GroupColumnCount=0 then AText:=' '+GetDBString('NOT10001012') else AText:='';
  Windows.FillRect(ACanvas.Handle, ARect, 0);
  DrawText(ACanvas.Handle, PChar(AText), Length(AText), ARect, DT_LEFT or DT_EXPANDTABS or DT_NOPREFIX or DT_SINGLELINE or DT_VCENTER);
end;

procedure TPayW00_01Form.cbTypeChange(Sender: TObject);
begin
  if cbYear.Text='' then Exit;
  SYSDM.qryQuery.Close;
  SYSDM.qryQuery.SQL.Clear;
  SYSDM.qryQuery.SQL.Add('select P150_001 from PAY150 where P150_003='+''''+cbType.Text+'''');
  SYSDM.qryQuery.Open;
  if SYSDM.qryQuery.IsEmpty then
    ATypeNo:=0
  else
    ATypeNo:=SYSDM.qryQuery.Fields[0].AsInteger;   //事务类型
  sbSearch.Click;
end;

procedure TPayW00_01Form.sbSearchClick(Sender: TObject);
begin
//查询
  if (cbYear.Text='') or (cbMonth.Text='') or (cbType.Text='') then Exit;
  //取得期段的起始结束日期
  GetPeriodDate(cbYear.Text,cbMonth.Text,AStartDate,AEndDate,APeriod);
  qryMaster.Close;
  qryMaster.SQL.Clear;
  if ATypeNo=0 then
    qryMaster.SQL.Add('select * from PAY500 where P500_005>='+GetDateString(AStartDate)+' and P500_005<='+GetDateString(AEndDate))
  else
    qryMaster.SQL.Add('select * from PAY500 where P500_001='+IntToStr(ATypeNo)+' and P500_005>='+GetDateString(AStartDate)+' and P500_005<='+GetDateString(AEndDate));
  qryMaster.Open;
end;

procedure TPayW00_01Form.cbYearChange(Sender: TObject);
begin
  GetMonths(StrToInt(cbYear.Text),cbMonth);
  sbSearch.Click;
end;

procedure TPayW00_01Form.cbMonthChange(Sender: TObject);
begin
  //取得期段的起始结束日期
  GetPeriodDate(cbYear.Text,cbMonth.Text,AStartDate,AEndDate,APeriod);
  sbSearch.Click;
end;

procedure TPayW00_01Form.tvListsDblClick(Sender: TObject);
begin
//项目选择
  if tvLists.Items.Count=0 then Exit;
  tvLists.Items.BeginUpdate;
  tvLists.Items[0].Expand(True);
  tvLists.Items.EndUpdate;
  cbType.ItemIndex:=cbType.Items.IndexOf(adsListsName.Value);
  cbTypeChange(cbType);
end;

procedure TPayW00_01Form.tvListsGetImageIndex(Sender: TObject;
  Node: TTreeNode);
begin
  if Node.HasChildren then
  begin
    Node.ImageIndex:=0;
    Node.SelectedIndex:=0;
  end else
  begin
    Node.ImageIndex:=1;
    Node.SelectedIndex:=1;
  end;
end;

procedure TPayW00_01Form.ActHrmS00Execute(Sender: TObject);
begin
//人力资源参数
  CreateFormInPackage('THrmS00_01Form',True);
end;

procedure TPayW00_01Form.ActBom100Execute(Sender: TObject);
begin
//工序资料维护
  CreateFormInPackage('TBom100_01Form',True);
end;

procedure TPayW00_01Form.ActBom110Execute(Sender: TObject);
begin
//工艺流程维护
  CreateFormInPackage('TBom110_01Form',True);
end;

procedure TPayW00_01Form.ActInv150Execute(Sender: TObject);
begin
//料品资料维护
  CreateFormInPackage('TInv150_01Form',True);
end;

procedure TPayW00_01Form.ActPay150Execute(Sender: TObject);
begin
//薪资项目维护
  CreateFormInPackage('TPay150_01Form',True);
end;

procedure TPayW00_01Form.ActPay160Execute(Sender: TObject);
begin
//薪资类别维护
  CreateFormInPackage('TPay160_01Form',True);
end;

procedure TPayW00_01Form.ActPassExecute(Sender: TObject);
begin
//更改登录密码(&C)...
  AStartTime:=GetTickCount;
  Sys600_01Form:=TSys600_01Form.Create(Application);
  ShowRunTime;  //显示程序执行时间
  Sys600_01Form.ShowModal;
end;

procedure TPayW00_01Form.ActLonginExecute(Sender: TObject);
begin
//更换操作员(&U)...
  ReLogin;
end;

procedure TPayW00_01Form.ActExitExecute(Sender: TObject);
begin
//退出(&X)
  Application.MainForm.Close;
end;

procedure TPayW00_01Form.ActPay500Execute(Sender: TObject);
begin
//薪资事务处理
  CreateFormInPackage('TPay500_01Form',True);
end;

procedure TPayW00_01Form.ActPay510Execute(Sender: TObject);
begin
//员工薪资结构
  CreateFormInPackage('TPay510_01Form',True);
end;

procedure TPayW00_01Form.ActPay520Execute(Sender: TObject);
begin
//计件资料录入
  CreateFormInPackage('TPay520_01Form',True);
end;

procedure TPayW00_01Form.ActPay550Execute(Sender: TObject);
begin
//薪资核算处理
  CreateFormInPackage('TPay550_01Form',True);
end;

procedure TPayW00_01Form.ActPay200Execute(Sender: TObject);
begin
//薪资查询报表
  CreateFormInPackage('TPay200_01Form',True);
end;

procedure TPayW00_01Form.ActPay210Execute(Sender: TObject);
begin
//计件薪资查询
  CreateFormInPackage('TPay210_01Form',True);
end;

procedure TPayW00_01Form.ActPay220Execute(Sender: TObject);
begin
//薪资年度查询
  CreateFormInPackage('TPay220_01Form',True);
end;

procedure TPayW00_01Form.ActPay230Execute(Sender: TObject);
begin
//薪资月度查询
  CreateFormInPackage('TPay230_01Form',True);
end;

procedure TPayW00_01Form.ActContentsExecute(Sender: TObject);
begin
//帮助主题(&H)
  Application.HelpCommand(HELP_FINDER,0);
end;

procedure TPayW00_01Form.ActEmailExecute(Sender: TObject);
begin
//写信给作者(&E)...
  Screen.Cursor:=crHourGlass;
  ShellExecute(Handle, nil, PChar('mailto:'+AEmail),nil,nil,SW_NORMAL);
  Screen.Cursor:=crDefault;
end;

procedure TPayW00_01Form.ActHomePageExecute(Sender: TObject);
begin
//网上浩晖(&P)...
  Screen.Cursor:=crHourGlass;
  ShellExecute(Handle, nil, PChar(AHome),nil,nil,SW_NORMAL);
  Screen.Cursor:=crDefault;
end;

procedure TPayW00_01Form.ActAboutExecute(Sender: TObject);
begin
//关于浩晖(&A)...
  WelcomeForm:=TWelcomeForm.Create(Application);
  WelcomeForm.AFlag:=True;
  WelcomeForm.ShowModal;
end;

procedure TPayW00_01Form.ActRegExecute(Sender: TObject);
begin
//软件注册(&R)...
  AStartTime:=GetTickCount;
  HwRegisterForm:=THwRegisterForm.Create(Application);
  ShowRunTime;  //显示程序执行时间
  HwRegisterForm.ShowModal;
  ActReg.Visible:=ADemoFlag;
  N1.Visible:=ADemoFlag;
end;

procedure TPayW00_01Form.ActUpgradeExecute(Sender: TObject);
begin
//在线智能升级(&U)...
  ShowUpgradeForm;
end;

procedure TPayW00_01Form.bbtnInsertClick(Sender: TObject);
begin
//新增(&A)
  Pay500_04Form:=TPay500_04Form.Create(Application);
  Pay500_04Form.ShowModal;
  sbSearch.Click;
end;

procedure TPayW00_01Form.bbtnUpdateClick(Sender: TObject);
begin
//修改(&E)
  Pay500_04Form:=TPay500_04Form.Create(Application);
  Pay500_04Form.ShowModal;
  sbSearch.Click;
end;

procedure TPayW00_01Form.bbtnDeleteClick(Sender: TObject);
begin
//删除(&D)
  if qryMaster.IsEmpty then
  begin
    ShowMsg('UMS10000002');  //表记录为空，操作无效
    Abort;
  end;
  if ShowDialog('UMS10000008')=IDYES then  //确定要删除此记录吗?
  begin
    //
    SYSDM.qryQuery.Close;
    SYSDM.qryQuery.SQL.Clear;
    SYSDM.qryQuery.SQL.Add('delete CWA550 where C500_001= and C500_004= and C500_005= and C500_006= and C500_007=');
    SYSDM.qryQuery.ExecSQL;
    sbSearch.Click;
  end;
end;

procedure TPayW00_01Form.bbtnRefreshClick(Sender: TObject);
begin
//刷新(&R)
  sbSearch.Click;
end;

procedure TPayW00_01Form.bbtnLocateClick(Sender: TObject);
begin
//查找(&F)
  if qryMaster.IsEmpty then
  begin
    ShowMsg('UMS10000002');  //表记录为空，操作无效
    Abort;
  end;
  LocateDialog(dsMaster);
end;

procedure TPayW00_01Form.bbtnSearchClick(Sender: TObject);
begin
//查询(&S)
  FilterDialog(dsMaster);
end;

procedure TPayW00_01Form.bbtnPrintClick(Sender: TObject);
var
  AReportName:String;
begin
//打印(&P)
  AReportName:='Pay500.frf';
  SelectReport(qryMaster,AProgramID,AReportName,ReportGetValue);
  sbSearch.Click;
end;

procedure TPayW00_01Form.ReportGetValue(const ParName: String;
  var ParValue: Variant);
begin
  if ParName='USENM' then ParValue:=AUserName
  else if ParName='PRNDT' then ParValue:=GetDBString('COM00006006')  //列印日期
  else if ParName='PRNNM' then ParValue:=GetDBString('COM00006007')  //列印人員
  else if ParName='REPNM' then ParValue:=AReportTitle

  else if ParName='P150_002' then ParValue:=GetDBString('PAY50001017')  //类型编号
  else if ParName='P150_003' then ParValue:=GetDBString('PAY50001018')  //类型名称
  else if ParName='P500_003' then ParValue:=GetDBString('PAY50001007')  //事务说明
  else if ParName='C160_002' then ParValue:=GetDBString('PAY50001021')  //原因编号
  else if ParName='C160_003' then ParValue:=GetDBString('PAY50001022')  //原因说明
  else if ParName='H150_002' then ParValue:=GetDBString('PAY50001019')  //员工编号
  else if ParName='H150_003' then ParValue:=GetDBString('PAY50001020')  //员工名称
  else if ParName='P500_005' then ParValue:=GetDBString('PAY50001010')  //事务日期
  else if ParName='P500_006' then ParValue:=GetDBString('PAY50001011')  //事务金额
  else if ParName='P500_007' then ParValue:=GetDBString('PAY50001012')  //已审核否
end;

procedure TPayW00_01Form.mmiReadedClick(Sender: TObject);
begin
//标识为“已阅读”
  if not SYSDM.qrySys910.Active then Exit;
  if SYSDM.qrySys910.IsEmpty then Exit;
  SYSDM.qrySys910.Edit;
  SYSDM.qrySys910S910_006.Value:=2;
  SYSDM.qrySys910.Post;
end;

procedure TPayW00_01Form.bbtnExcelClick(Sender: TObject);
begin
//导出数据
  if qryMaster.IsEmpty then
  begin
    ShowMsg('UMS10000002');  //表记录为空，操作无效
    Abort;
  end;
  HwExportForm:=THwExportForm.Create(Application);
  HwExportForm.GetDataFields('PAY500',qryMaster);
  HwExportForm.ShowModal;
end;

end.