5,392
社区成员
发帖
与我相关
我的任务
分享
begin
try
if not Assigned(RES_LOADING_F) then
RES_LOADING_F:=TRES_LOADING_F.Create(Self);
RES_LOADING_F.Label1.Caption:='正在讀取數據......';
RES_LOADING_F.Show;
Screen.Cursor:=crSQLWait;
Application.ProcessMessages;
qry_lzdetail.Close;
qry_lzdetail.SQL.Clear;
qry_lzdetail.SQL.Add( ' select * from ( select Account_Id,Full_Name,CB,BM,KB,XB,BC,JCRQ,LWS,SF,JN, ' );
qry_lzdetail.SQL.Add( ' DATEPART(WK,DATEADD(DAY,-1,lzr)) as WEEKS from Res_Hrd_Temp where JN=''離職'' ' );
qry_lzdetail.SQL.Add( ' ) a where WEEKS='+ Trim(u)+' and BM='''+ Trim(c)+''' ' );
qry_lzdetail.Open;
finally
Screen.Cursor:=crDefault;
FreeAndNil(RES_LOADING_F);
end;
end;