D10clhege/A09财务通用管理/U_YFKXZ.pas

222 lines
6.0 KiB
ObjectPascal
Raw Permalink Normal View History

2026-11-14 17:01:56 +08:00
unit U_YFKXZ;
interface
uses
Winapi.Windows, Winapi.Messages, System.SysUtils, System.Variants,
System.Classes, Vcl.Graphics, Vcl.Controls, Vcl.Forms, Vcl.Dialogs,
Vcl.ComCtrls, Vcl.ToolWin, Vcl.StdCtrls, Vcl.ExtCtrls, Data.Win.ADODB, Data.DB,
Datasnap.DBClient, cxGraphics, cxControls, cxLookAndFeels,
cxLookAndFeelPainters, dxSkinsCore, dxSkinOffice2013White,
dxSkinsDefaultPainters, dxSkinWXI, cxStyles, cxCustomData, cxFilter, cxData,
cxDataStorage, cxEdit, cxNavigator, dxDateRanges, dxScrollbarAnnotations,
cxDBData, cxCheckBox, cxCalendar, cxGridLevel, cxGridCustomTableView,
cxGridTableView, cxGridDBTableView, cxClasses, cxGridCustomView, cxGrid,
dxBarBuiltInMenu, cxGridCustomPopupMenu, cxGridPopupMenu;
type
Tfrmyfkxz = class(TForm)
ToolBar1: TToolBar;
TBRafresh: TToolButton;
ToolButton1: TToolButton;
ToolButton4: TToolButton;
ToolButton5: TToolButton;
TBClose: TToolButton;
DS_1: TDataSource;
CDS_1: TClientDataSet;
ADOQueryCmd: TADOQuery;
ADOQueryTemp: TADOQuery;
ADOQueryMain: TADOQuery;
cxGrid1: TcxGrid;
Tv1: TcxGridDBTableView;
Tv1Column22: TcxGridDBColumn;
v2CRTime: TcxGridDBColumn;
Tv1Column35: TcxGridDBColumn;
Tv1Column23: TcxGridDBColumn;
v2Column2: TcxGridDBColumn;
v2FactoryName: TcxGridDBColumn;
v2OrderNo: TcxGridDBColumn;
Tv1Column3: TcxGridDBColumn;
Tv1Column19: TcxGridDBColumn;
Tv1Column24: TcxGridDBColumn;
Tv1Column20: TcxGridDBColumn;
Tv1Column21: TcxGridDBColumn;
Tv1Column4: TcxGridDBColumn;
Tv1Column5: TcxGridDBColumn;
Tv1Column6: TcxGridDBColumn;
Tv1Column7: TcxGridDBColumn;
Tv1Column8: TcxGridDBColumn;
Tv1Column9: TcxGridDBColumn;
Tv1Column10: TcxGridDBColumn;
Tv1Column11: TcxGridDBColumn;
Tv1Column12: TcxGridDBColumn;
Tv1Column31: TcxGridDBColumn;
Tv1Column33: TcxGridDBColumn;
Tv1Column13: TcxGridDBColumn;
Tv1Column14: TcxGridDBColumn;
Tv1Column15: TcxGridDBColumn;
Tv1Column16: TcxGridDBColumn;
Tv1Column32: TcxGridDBColumn;
Tv1Column2: TcxGridDBColumn;
Tv1Column17: TcxGridDBColumn;
Tv1Column28: TcxGridDBColumn;
Tv1Column29: TcxGridDBColumn;
Tv1Column18: TcxGridDBColumn;
Tv1Column1: TcxGridDBColumn;
Tv1Column25: TcxGridDBColumn;
Tv1Column26: TcxGridDBColumn;
Tv1Column27: TcxGridDBColumn;
Tv1Column30: TcxGridDBColumn;
Tv1Column34: TcxGridDBColumn;
Tv1Column36: TcxGridDBColumn;
Tv1Column37: TcxGridDBColumn;
Tv1Column38: TcxGridDBColumn;
cxGridLevel1: TcxGridLevel;
Panel1: TPanel;
Label3: TLabel;
Label4: TLabel;
Label6: TLabel;
Label10: TLabel;
Label11: TLabel;
Label2: TLabel;
OppCoName: TEdit;
begdate: TDateTimePicker;
Enddate: TDateTimePicker;
F_Name: TEdit;
CheckBox1: TCheckBox;
P_Code: TEdit;
ConNo: TEdit;
BuyConNo: TEdit;
OppParentCoName: TEdit;
GPM_1: TcxGridPopupMenu;
procedure FormClose(Sender: TObject; var Action: TCloseAction);
procedure FormShow(Sender: TObject);
procedure TBRafreshClick(Sender: TObject);
procedure OppCoNameKeyPress(Sender: TObject; var Key: Char);
procedure TBCloseClick(Sender: TObject);
procedure ToolButton5Click(Sender: TObject);
procedure ToolButton4Click(Sender: TObject);
procedure ToolButton1Click(Sender: TObject);
private
procedure InitGrid();
{ Private declarations }
public
{ Public declarations }
end;
var
frmyfkxz: Tfrmyfkxz;
implementation
uses
U_DataLink, U_RTFun, U_ZDYHelp;
{$R *.dfm}
procedure Tfrmyfkxz.InitGrid();
var
WSql: string;
begin
WSql := SGetFilters(Panel1, 1, 2);
if Trim(WSql) <> '' then
WSql := ' and ' + WSql
else
CheckBox1.Checked := True;
try
ADOQueryMain.DisableControls;
with ADOQueryMain do
begin
Close;
SQL.Clear;
Filtered := False;
sql.Add(' select A.* ');
sql.Add(',YSKJE=(select sum(Amount) from Finance_Flow B where B.BuyConNo=A.BuyConNo and FFType=''<27><><EFBFBD><EFBFBD><EFBFBD>Ǽ<EFBFBD>'') ');
sql.Add(',SKRQ=(select top 1 FFTime from Finance_Flow B where B.BuyConNo=A.BuyConNo and FFType=''<27><><EFBFBD><EFBFBD><EFBFBD>Ǽ<EFBFBD>'') ');
sql.Add(' from Finance_Flow A ');
sql.Add(' where A.FFType=''Ӧ<><D3A6><EFBFBD><EFBFBD><EFBFBD>Ǽ<EFBFBD>'' ');
sql.Add(' and isnull(status,''0'')=''9'' ');
if CheckBox1.Checked then
begin
sql.Add(' and A.FFTime>=''' + FormatDateTime('yyyy-MM-dd', begdate.DateTime) + ''' ');
sql.Add(' and FFTime<''' + FormatDateTime('yyyy-MM-dd', Enddate.DateTime + 1) + ''' ');
end;
sql.Add(WSql);
// showmessage(sql.text);
Open;
end;
SCreateCDS(ADOQueryMain, CDS_1);
SInitCDSData(ADOQueryMain, CDS_1);
finally
ADOQueryMain.EnableControls;
TV1.DataController.Filter.Clear;
end;
end;
procedure Tfrmyfkxz.OppCoNameKeyPress(Sender: TObject; var Key: Char);
begin
if Key = #13 then
begin
InitGrid();
end;
end;
procedure Tfrmyfkxz.FormClose(Sender: TObject; var Action: TCloseAction);
begin
Action := caFree;
end;
procedure Tfrmyfkxz.FormShow(Sender: TObject);
begin
ReadCxGrid(trim(Self.Caption), Tv1, 'Ӧ<><D3A6><EFBFBD><EFBFBD>ѡ<EFBFBD><D1A1><EFBFBD><EFBFBD><EFBFBD><EFBFBD>');
Enddate.DateTime := SGetServerDate(ADOQueryTemp);
begdate.DateTime := Enddate.DateTime - 30;
// SetStatus();
InitGrid();
end;
procedure Tfrmyfkxz.TBCloseClick(Sender: TObject);
begin
Close;
end;
procedure Tfrmyfkxz.TBRafreshClick(Sender: TObject);
begin
begdate.SetFocus;
with ADOQueryCmd do
begin
Close;
Sql.Clear;
// Sql.Add('exec P_Fin_Generate ');
Sql.Add('exec P_Fin_Trade_Generate ');
Open;
end;
if ADOQueryCmd.FieldByName('intReturn').AsInteger = -1 then
begin
application.MessageBox(pchar(ADOQueryCmd.FieldByName('ShowMsg').AsString), '<27><>ʾ<EFBFBD><CABE>Ϣ');
Exit;
end;
InitGrid();
end;
procedure Tfrmyfkxz.ToolButton1Click(Sender: TObject);
begin
ModalResult := 1;
end;
procedure Tfrmyfkxz.ToolButton4Click(Sender: TObject);
begin
if ADOQueryMain.IsEmpty then
Exit;
TcxGridToExcel(self.Caption, cxgrid1);
end;
procedure Tfrmyfkxz.ToolButton5Click(Sender: TObject);
begin
WriteCxGrid(trim(Self.Caption), Tv1, 'Ӧ<><D3A6><EFBFBD><EFBFBD>ѡ<EFBFBD><D1A1><EFBFBD><EFBFBD><EFBFBD><EFBFBD>');
end;
end.