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

342 lines
10 KiB
ObjectPascal
Raw Permalink Normal View History

2026-11-14 17:01:56 +08:00
unit U_CYDXZ;
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, dxSkinsCore,
dxSkinsDefaultPainters, dxBarBuiltInMenu, cxGraphics, cxControls,
cxLookAndFeels, cxLookAndFeelPainters, cxPC, cxStyles, cxCustomData, cxFilter,
cxData, cxDataStorage, cxEdit, cxNavigator, dxDateRanges, Data.DB, cxDBData,
cxCheckBox, cxCalendar, cxDropDownEdit, cxButtonEdit, cxTextEdit, cxGridLevel,
cxGridCustomTableView, cxGridTableView, cxGridDBTableView, cxClasses,
cxGridCustomView, cxGrid, Datasnap.DBClient, Data.Win.ADODB,
cxGridCustomPopupMenu, cxGridPopupMenu, dxSkinOffice2013White, dxSkinWXI,
dxScrollbarAnnotations, Vcl.Menus;
type
TfrmCYDXZ = class(TForm)
ToolBar2: TToolBar;
ToolButton3: TToolButton;
ToolButton1: TToolButton;
ToolButton2: TToolButton;
ToolButton7: TToolButton;
ToolButton8: TToolButton;
Panel1: TPanel;
Label1: TLabel;
Label2: TLabel;
Label3: TLabel;
Label4: TLabel;
Label5: TLabel;
Label8: TLabel;
Label6: TLabel;
Label7: TLabel;
BegDate: TDateTimePicker;
EndDate: TDateTimePicker;
TDNO: TEdit;
KHName: TEdit;
SHfirmName: TEdit;
AccessoriesNO: TEdit;
CustomsNO: TEdit;
KHNumber: TEdit;
cxTabControl1: TcxTabControl;
cxGrid1: TcxGrid;
Tv1: TcxGridDBTableView;
cxGrid1Level1: TcxGridLevel;
cxGridPopupMenu1: TcxGridPopupMenu;
ADOQueryMain: TADOQuery;
ADOQueryTemp: TADOQuery;
ADOQueryCmd: TADOQuery;
DataSource1: TDataSource;
CDS_Main: TClientDataSet;
ADOQueryTemp1: TADOQuery;
Tv1Column1: TcxGridDBColumn;
Tv1Column2: TcxGridDBColumn;
Tv1Column3: TcxGridDBColumn;
Tv1Column4: TcxGridDBColumn;
Tv1Column5: TcxGridDBColumn;
Tv1Column6: TcxGridDBColumn;
Tv1Column7: TcxGridDBColumn;
Tv1Column8: TcxGridDBColumn;
Tv1Column9: TcxGridDBColumn;
Tv1Column10: TcxGridDBColumn;
Tv1Column11: TcxGridDBColumn;
Tv1Column12: TcxGridDBColumn;
Tv1Column13: TcxGridDBColumn;
Tv1Column14: TcxGridDBColumn;
Tv1Column15: TcxGridDBColumn;
Tv1Column16: TcxGridDBColumn;
Tv1Column17: TcxGridDBColumn;
Tv1Column18: TcxGridDBColumn;
Tv1Column19: TcxGridDBColumn;
Tv1Column20: TcxGridDBColumn;
Tv1Column21: TcxGridDBColumn;
Tv1Column22: TcxGridDBColumn;
Tv1Column23: TcxGridDBColumn;
Tv1Column24: TcxGridDBColumn;
Tv1Column25: TcxGridDBColumn;
Tv1Column26: TcxGridDBColumn;
PopupMenu1: TPopupMenu;
N1: TMenuItem;
N3: TMenuItem;
procedure FormShow(Sender: TObject);
procedure ToolButton3Click(Sender: TObject);
procedure ToolButton1Click(Sender: TObject);
procedure ToolButton7Click(Sender: TObject);
procedure ToolButton8Click(Sender: TObject);
procedure FormCreate(Sender: TObject);
procedure cxTabControl1Change(Sender: TObject);
procedure ToolButton2Click(Sender: TObject);
procedure N1Click(Sender: TObject);
procedure N3Click(Sender: TObject);
private
procedure InitGrid();
function YSData(): Boolean;
{ Private declarations }
public
FFFID: string;
{ Public declarations }
end;
var
frmCYDXZ: TfrmCYDXZ;
implementation
uses
U_DataLink, U_RTFun;
{$R *.dfm}
function TfrmCYDXZ.YSData(): Boolean;
var
MaxId, MaxSubId, FCoCode, FCCID: string;
begin
try
ADOQueryCmd.Connection.BeginTrans;
if Trim(FFFID) = '' then
begin
if not GetLSNo(ADOQueryCmd, MaxId, 'YS', 'Finance_Flow', 4, 1) then
raise Exception.Create('ȡ<><C8A1><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ʧ<EFBFBD>ܣ<EFBFBD>');
end
else
begin
MaxId := Trim(FFFID);
end;
with ADOQueryCmd do
begin
Close;
SQL.Clear;
sql.Add('select * from Finance_Flow where FFID=''' + Trim(FFFID) + '''');
Open;
end;
// with ADOQueryTemp1 do
// begin
// Close;
// SQL.Clear;
// sql.Add('select A.*,B.* from BS_Contract_sub A ');
// sql.Add('INNER JOIN BS_Contract_main B On A.conmid=B.conmid');
// sql.Add('where B.ConType in (''<27><><EFBFBD><EFBFBD>'',''<27><><EFBFBD><EFBFBD>'') ');
// sql.Add('and A.ConSId =''' + Trim(CDS_Main.fieldbyname('FromConSId').AsString) + ''' ');
// Open;
// end;
with ADOQueryCmd do
begin
if Trim(FFFID) = '' then
begin
Append;
FieldByName('FillId').Value := Trim(DCode);
FieldByName('Filler').Value := Trim(DName);
FieldByName('AOTUFlag').Value := '<27>Զ<EFBFBD><D4B6><EFBFBD><EFBFBD><EFBFBD>';
FieldByName('FFFlag').Value := 'Ӧ<><D3A6><EFBFBD><EFBFBD>';
FieldByName('FFType').Value := 'Ӧ<>տ<EFBFBD><D5BF>Ǽ<EFBFBD>';
FieldByName('status').Value := '0';
FieldByName('FFQtyFlag').Value := 1;
end
else
begin
Edit;
FieldByName('EditId').Value := Trim(DCode);
FieldByName('Editer').Value := Trim(DName);
FieldByName('Edittime').Value := SGetServerDateTime(ADOQueryTemp);
end;
FieldByName('FFID').Value := Trim(MaxId);
FieldByName('FFTime').Value := SGetServerDateTime(ADOQueryTemp); //<2F><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>
FieldByName('ReconciliationDate').Value := SGetServerDateTime(ADOQueryTemp); //<2F><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>
FieldByName('FBCIOID').Value := Trim(CDS_Main.fieldbyname('BIOSID').AsString); //<2F><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>
FieldByName('OurCoName').Value := Trim(CDS_Main.fieldbyname('CKfirmName').AsString); //<2F>ҷ<EFBFBD><D2B7><EFBFBD>λ
FieldByName('OurCoNo').Value := Trim(CDS_Main.fieldbyname('CKfirmNamecode').AsString); //<2F>ҷ<EFBFBD><D2B7><EFBFBD>λ
FieldByName('OppCoName').Value := Trim(CDS_Main.fieldbyname('KHName').AsString); //<2F>Է<EFBFBD><D4B7><EFBFBD>λ
FieldByName('OppCoNo').Value := Trim(CDS_Main.fieldbyname('KHNumber').AsString); //<2F>Է<EFBFBD><D4B7><EFBFBD>λ
FieldByName('OppParentCoName').Value := Trim(CDS_Main.fieldbyname('KHName').AsString); //<2F>ϼ<EFBFBD><CFBC><EFBFBD>λ
FieldByName('OppParentCoNo').Value := Trim(CDS_Main.fieldbyname('KHNumber').AsString); //<2F>ϼ<EFBFBD><CFBC><EFBFBD>λ
FieldByName('Currency').Value := Trim(CDS_Main.fieldbyname('BZ').AsString); //<2F><><EFBFBD><EFBFBD>
FieldByName('YJSKTime').Value := CDS_Main.fieldbyname('YSKTime').AsDateTime; //Ӧ<>տ<EFBFBD>ʱ<EFBFBD><CAB1>
FieldByName('BuyConNo').Value := Trim(CDS_Main.fieldbyname('KHNumber').AsString); //<2F>ͻ<EFBFBD><CDBB><EFBFBD><EFBFBD><EFBFBD>
FieldByName('ZJS').Value := Trim(CDS_Main.fieldbyname('ZJS').AsString); //<2F>м<EFBFBD><D0BC><EFBFBD>
FieldByName('ZDR').Value := Trim(CDS_Main.fieldbyname('ZDR').AsString); //<2F>Ƶ<EFBFBD><C6B5><EFBFBD>
FieldByName('PayMent').Value := Trim(CDS_Main.fieldbyname('FKFS').AsString); //<2F><><EFBFBD>ʽ
FieldByName('ZGfinishdate').Value := CDS_Main.fieldbyname('ZGfinishdate').AsDateTime; //װ<><D7B0><EFBFBD><EFBFBD><EFBFBD><EFBFBD>
FieldByName('Amount').Value := CDS_Main.fieldbyname('ZYSK').AsFloat; //* ADOQueryTemp1.fieldbyname('ConPrice').AsFloat;
// RTSetsavedata(ADOQueryCmd, 'Finance_Flow', ScrollBox1, 0);
Post;
end;
ADOQueryCmd.Connection.CommitTrans;
// FCCID := Trim(MaxSubId);
Result := True;
except
Result := false;
ADOQueryCmd.Connection.RollbackTrans;
// application.MessageBox(PChar(Exception(ExceptObject).Message), '<27><>ʾ<EFBFBD><CABE>Ϣ', 0);
end;
end;
procedure TfrmCYDXZ.InitGrid();
begin
try
ADOQueryMain.DisableControls;
with ADOQueryMain do
begin
Filtered := False;
Close;
sql.Clear;
sql.Add(' select A.*,B.* ');
sql.Add(' ,convert(varchar(10),B.YSKTime,120) as YSKTime1 ');
sql.Add(' from BS_CYGL_CY A');
sql.Add(' INNER JOIN BS_CYGL_Main B on A.BIOSID=B.BIOSID ');
sql.add(' where A.CJdate>=''' + Trim(FormatDateTime('yyyy-MM-dd', BegDate.DateTime)) + '''');
sql.Add(' and A.CJdate<''' + Trim(FormatDateTime('yyyy-MM-dd', enddate.DateTime + 1)) + '''');
SQL.Add(' and status=''1'' ');
case cxTabControl1.TabIndex of
0:
begin
sql.Add(' and isnull(A.YSZT,''0'')=''0'' ');
end;
1:
begin
sql.Add(' and isnull(A.YSZT,''0'')=''1'' ');
end;
end;
// showmessage(sql.text);
Open;
end;
SCreateCDS(ADOQueryMain, CDS_Main);
SInitCDSData(ADOQueryMain, CDS_Main);
finally
ADOQueryMain.EnableControls;
end;
end;
procedure TfrmCYDXZ.N1Click(Sender: TObject);
begin
SelOKNo(CDS_Main, true)
end;
procedure TfrmCYDXZ.N3Click(Sender: TObject);
begin
SelOKNo(CDS_Main, false)
end;
procedure TfrmCYDXZ.ToolButton1Click(Sender: TObject);
begin
if ADOQueryMain.Active then
begin
SDofilter(ADOQueryMain, SGetFilters(Panel1, 1, 2));
SCreateCDS(ADOQueryMain, CDS_Main);
SInitCDSData(ADOQueryMain, CDS_Main);
end;
end;
procedure TfrmCYDXZ.ToolButton2Click(Sender: TObject);
begin
if CDS_Main.IsEmpty then
Exit;
if CDS_Main.Locate('SSel', True, []) = False then
begin
Application.MessageBox('û<><C3BB>ѡ<EFBFBD><D1A1><EFBFBD><EFBFBD><EFBFBD><EFBFBD>!', '<27><>ʾ', 0);
Exit;
end;
// ADOQueryCmd.Connection.BeginTrans;
try
with CDS_Main do
begin
DisableControls;
first;
while not eof do
begin
if fieldbyname('ssel').AsBoolean then
begin
if not YSData() then
begin
// ADOQueryCmd.Connection.RollbackTrans;
application.MessageBox('<27><><EFBFBD><EFBFBD>Ӧ<EFBFBD>տ<EFBFBD>ʧ<EFBFBD>ܣ<EFBFBD>', '<27><>ʾ<EFBFBD><CABE>Ϣ', 0);
end;
with ADOQueryTemp do
begin
Close;
sql.Clear;
sql.Add('Update BS_CYGL_CY Set YSZT=''1'' ');
sql.Add('where BIOSID=''' + Trim(CDS_Main.fieldbyname('BIOSID').AsString) + '''');
ExecSQL;
end;
end;
next;
end;
first;
EnableControls;
end;
// ADOQueryCmd.Connection.CommitTrans;
application.MessageBox('<27><><EFBFBD><EFBFBD>Ӧ<EFBFBD>տ<EFBFBD><D5BF>ɹ<EFBFBD><C9B9><EFBFBD>', '<27><>ʾ<EFBFBD><CABE>Ϣ');
initGrid();
except
// ADOQueryCmd.Connection.RollbackTrans;
application.MessageBox('<27><><EFBFBD><EFBFBD>Ӧ<EFBFBD>տ<EFBFBD>ʧ<EFBFBD>ܣ<EFBFBD>', '<27><>ʾ<EFBFBD><CABE>Ϣ', 0);
end;
end;
procedure TfrmCYDXZ.ToolButton3Click(Sender: TObject);
begin
InitGrid();
end;
procedure TfrmCYDXZ.ToolButton7Click(Sender: TObject);
begin
WriteCxGrid(trim(Self.Caption), Tv1, '<27><><EFBFBD>˵<EFBFBD>ѡ<EFBFBD><D1A1>');
end;
procedure TfrmCYDXZ.ToolButton8Click(Sender: TObject);
begin
Close;
end;
procedure TfrmCYDXZ.cxTabControl1Change(Sender: TObject);
begin
InitGrid();
end;
procedure TfrmCYDXZ.FormCreate(Sender: TObject);
begin
EndDate.DateTime := SGetServerDate(ADOQueryTemp);
BegDate.DateTime := EndDate.DateTime - 90;
end;
procedure TfrmCYDXZ.FormShow(Sender: TObject);
begin
ReadCxGrid(trim(Self.Caption), Tv1, '<27><><EFBFBD>˵<EFBFBD>ѡ<EFBFBD><D1A1>');
InitGrid();
end;
end.