?? payw00_01.pas.svn-base
字號:
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.
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -