D10clhege/T00贸易通用窗体/U_TradeSalesContractSel.pas
DESKTOP-E401PHE\Administrator a9ceaeacaf 初
2026-11-14 17:01:56 +08:00

352 lines
8.7 KiB
ObjectPascal
Raw Permalink Blame History

This file contains ambiguous Unicode characters

This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

unit U_TradeSalesContractSel;
interface
uses
Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
Dialogs, cxStyles, cxCustomData, cxGraphics, cxFilter, cxData, cxDataStorage,
cxEdit, DB, cxDBData, ToolWin, ComCtrls, U_BaseHelp, cxGridCustomTableView,
cxGridTableView, cxGridDBTableView, cxGridLevel, cxClasses, cxControls,
cxGridCustomView, cxGrid, DBClient, ADODB, ImgList, StdCtrls, ExtCtrls,
cxTextEdit, cxGridCustomPopupMenu, cxGridPopupMenu, cxLookAndFeels,
cxLookAndFeelPainters, dxSkinsCore, dxSkinsDefaultPainters, cxNavigator,
dxDateRanges, dxBarBuiltInMenu, System.ImageList, U_BaseInput, cxButtonEdit,
cxDropDownEdit, cxCheckBox, Vcl.Menus, cxMemo, cxPC;
type
TfrmTradeSalesContractSel = class(TfrmBaseHelp)
ToolBar1: TToolBar;
ADOQueryMain: TADOQuery;
ADOQueryTemp: TADOQuery;
ADOQueryCmd: TADOQuery;
DS_1: TDataSource;
CDS_1: TClientDataSet;
TBSave: TToolButton;
TBClose: TToolButton;
ToolButton1: TToolButton;
ADOConnection1: TADOConnection;
Panel1: TPanel;
Label1: TLabel;
ConNo: TEdit;
GPM_1: TcxGridPopupMenu;
ImageList1: TImageList;
cxStyleRepository1: TcxStyleRepository;
cxStyle1: TcxStyle;
cxGrid1: TcxGrid;
TV1: TcxGridDBTableView;
VC_SCSCode: TcxGridDBColumn;
cxGridDBColumn2: TcxGridDBColumn;
cxGridDBColumn3: TcxGridDBColumn;
v1Column5: TcxGridDBColumn;
cxGridDBColumn4: TcxGridDBColumn;
cxGridDBColumn5: TcxGridDBColumn;
cxGridDBColumn6: TcxGridDBColumn;
cxGridDBColumn7: TcxGridDBColumn;
cxGridDBColumn8: TcxGridDBColumn;
v1Column6: TcxGridDBColumn;
v1Column7: TcxGridDBColumn;
v1PRTOrderQty: TcxGridDBColumn;
v1OrderUnit: TcxGridDBColumn;
v1Column2: TcxGridDBColumn;
cxGridLevel1: TcxGridLevel;
TV1Column1: TcxGridDBColumn;
TV1Column2: TcxGridDBColumn;
TV1Column3: TcxGridDBColumn;
TV1Column4: TcxGridDBColumn;
TV1Column5: TcxGridDBColumn;
TV1Column6: TcxGridDBColumn;
ThreeColorBase: TcxStyleRepository;
SHuangSe: TcxStyle;
SkyBlue: TcxStyle;
Default: TcxStyle;
QHuangSe: TcxStyle;
Red: TcxStyle;
FontBlue: TcxStyle;
TextSHuangSe: TcxStyle;
FonePurple: TcxStyle;
FoneClMaroon: TcxStyle;
FoneRed: TcxStyle;
RowColor: TcxStyle;
handBlack: TcxStyle;
cxBlue: TcxStyle;
SHuangSeCu: TcxStyle;
TV1Column7: TcxGridDBColumn;
PM_1: TPopupMenu;
N1: TMenuItem;
N2: TMenuItem;
Label2: TLabel;
C_Name: TEdit;
Label3: TLabel;
BuyName: TEdit;
TV1Column8: TcxGridDBColumn;
TV1Column9: TcxGridDBColumn;
TV1Column10: TcxGridDBColumn;
TV1Column11: TcxGridDBColumn;
TV1Column12: TcxGridDBColumn;
TV1Column13: TcxGridDBColumn;
TV1Column14: TcxGridDBColumn;
BuyConNo: TEdit;
Label4: TLabel;
TV1Column15: TcxGridDBColumn;
cxTabControl1: TcxTabControl;
TV1Column16: TcxGridDBColumn;
TV1Column17: TcxGridDBColumn;
TV1Column18: TcxGridDBColumn;
TV1Column19: TcxGridDBColumn;
procedure FormCreate(Sender: TObject);
procedure FormClose(Sender: TObject; var Action: TCloseAction);
procedure FormShow(Sender: TObject);
procedure ToolButton1Click(Sender: TObject);
procedure FormDestroy(Sender: TObject);
procedure TBSaveClick(Sender: TObject);
procedure TV1DblClick(Sender: TObject);
procedure TBCloseClick(Sender: TObject);
procedure N1Click(Sender: TObject);
procedure N2Click(Sender: TObject);
procedure ConNoChange(Sender: TObject);
procedure cxTabControl1Change(Sender: TObject);
private
procedure InitGrid();
procedure SetStatus();
{ Private declarations }
public
FCoType, FAuthority, FConNo, FC_Code, FLX: string;
{ Public declarations }
end;
var
frmTradeSalesContractSel: TfrmTradeSalesContractSel;
implementation
uses
U_DataLink, U_RTFun;
{$R *.dfm}
procedure TfrmTradeSalesContractSel.SetStatus();
begin
// btnCopy.Enabled := false;
// tbadd.Enabled := false;
// TBEdit.Enabled := False;
// TBDel.Enabled := False;
// TBTJ.Enabled := False;
// TBTJCX.Enabled := False;
// tchk.Enabled := false;
// tnochk.Enabled := false;
// TWC.Enabled := False;
// TNowc.Enabled := False;
// TBDel.Enabled := False;
ToolButton1.Enabled := False;
case cxTabControl1.TabIndex of
0:
begin
ToolButton1.Enabled := true;
end;
1:
begin
ToolButton1.Enabled := true;
end;
end;
end;
procedure TfrmTradeSalesContractSel.FormCreate(Sender: TObject);
begin
inherited;
try
with ADOConnection1 do
begin
Connected := false;
ConnectionString := DConString;
Connected := true;
end;
ADOQueryBaseCmd.Connection := ADOConnection1;
ADOQueryBaseTemp.Connection := ADOConnection1;
except
application.MessageBox('<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ʧ<EFBFBD>ܣ<EFBFBD>', '<27><>ʾ<EFBFBD><CABE>Ϣ');
end;
end;
procedure TfrmTradeSalesContractSel.ConNoChange(Sender: TObject);
begin
if ADOQueryMain.Active = False then
Exit;
SDofilter(ADOQueryMain, SGetFilters(Panel1, 1, 2));
SCreateCDS(ADOQueryMain, CDS_1);
SInitCDSData(ADOQueryMain, CDS_1);
end;
procedure TfrmTradeSalesContractSel.cxTabControl1Change(Sender: TObject);
begin
// inherited;
SetStatus();
InitGrid();
end;
procedure TfrmTradeSalesContractSel.FormClose(Sender: TObject; var Action: TCloseAction);
begin
// ConNo.SetFocus;
Action := cahide;
end;
procedure TfrmTradeSalesContractSel.InitGrid();
begin
with ADOQueryTemp do
begin
Close;
SQL.Clear;
SQL.Add('select * from SY_User where UserName=' + quotedstr(Trim(DName)));
Open;
end;
try
ADOQueryMain.DisableControls;
with ADOQueryMain do
begin
Close;
sql.Clear;
sql.Add('select A.*,B.* from BS_Contract_Main A inner join BS_Contract_Sub B on A.ConMId=B.ConMId ');
sql.Add(' where isnull(A.status,''0'')=''9''');
sql.Add(' and A.ConType in (''<27><><EFBFBD><EFBFBD>'',''<27><><EFBFBD><EFBFBD>'') ');
if trim(fconNo) <> '' then
sql.Add(' and conNo=' + quotedstr(fconNo));
if trim(fC_Code) <> '' then
sql.Add(' and C_Code=' + quotedstr(fC_Code));
if FLX = '<27><><EFBFBD><EFBFBD>' then
begin
if (ADOQueryTemp.fieldbyname('Udept').AsString = 'ҵ<><D2B5><EFBFBD><EFBFBD>') and (Trim(DName) <> 'ADMIN') and (Trim(DName) <> '<27><><EFBFBD><EFBFBD>') then
begin
sql.Add('and A.Filler =''' + Trim(DName) + ''' ');
end;
end
else
begin
if FLX = '<27>ɹ<EFBFBD><C9B9><EFBFBD>ͬ' then
begin
if (ADOQueryTemp.fieldbyname('Udept').AsString = 'ҵ<><D2B5><EFBFBD><EFBFBD>') and (Trim(DName) <> '<27><><EFBFBD><EFBFBD>ƽ') then
begin
sql.Add('and A.Filler =''' + Trim(DName) + ''' ');
end;
end
else
begin
if ADOQueryTemp.fieldbyname('Udept').AsString = 'ҵ<><D2B5><EFBFBD><EFBFBD>' then
begin
sql.Add('and A.Filler =''' + Trim(DName) + ''' ');
end;
end;
end;
if FLX = '<27>ɹ<EFBFBD><C9B9><EFBFBD>ͬ' then
begin
// case cxTabControl1.TabIndex of
// 0:
// begin
// sql.Add(' and isnull(CGstatus,''0'')=''0'' ');
// end;
// 1:
// begin
// sql.Add(' and isnull(CGstatus,''0'')=''1'' ');
//
// end;
// end;
end
else
begin
if FLX = '<27><><EFBFBD><EFBFBD>' then
begin
end
else
begin
case cxTabControl1.TabIndex of
0:
begin
sql.Add(' and isnull(JHDstatus,''0'')=''0'' ');
end;
1:
begin
sql.Add(' and isnull(JHDstatus,''0'')=''1'' ');
end;
end;
end;
end;
sql.Add('order by B.SerialNo');
// showmessage(sql.text);
Open;
end;
SDofilter(ADOQueryMain, SGetFilters(Panel1, 1, 2));
SCreateCDS(ADOQueryMain, CDS_1);
SInitCDSData(ADOQueryMain, CDS_1);
finally
ADOQueryMain.EnableControls;
end;
end;
procedure TfrmTradeSalesContractSel.N1Click(Sender: TObject);
begin
SelOKNo(CDS_1, True);
end;
procedure TfrmTradeSalesContractSel.N2Click(Sender: TObject);
begin
SelOKNo(CDS_1, False);
end;
procedure TfrmTradeSalesContractSel.FormShow(Sender: TObject);
begin
inherited;
if FLX = '<27><><EFBFBD><EFBFBD>' then
begin
cxTabControl1.Visible:=false;
end;
SetStatus();
InitGrid();
ReadCxGrid(Trim(self.Caption), TV1, '<27>Զ<EFBFBD><D4B6><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>');
end;
procedure TfrmTradeSalesContractSel.TBCloseClick(Sender: TObject);
begin
inherited;
Close;
end;
procedure TfrmTradeSalesContractSel.TBSaveClick(Sender: TObject);
begin
WriteCxGrid(Trim(self.Caption), TV1, '<27>Զ<EFBFBD><D4B6><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>');
end;
procedure TfrmTradeSalesContractSel.ToolButton1Click(Sender: TObject);
begin
ModalResult := 1;
end;
procedure TfrmTradeSalesContractSel.TV1DblClick(Sender: TObject);
begin
ModalResult := 1;
end;
procedure TfrmTradeSalesContractSel.FormDestroy(Sender: TObject);
begin
inherited;
frmTradeSalesContractSel := nil;
end;
end.