342 lines
10 KiB
ObjectPascal
342 lines
10 KiB
ObjectPascal
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.
|
||
|