D10clhege/T01贸易生产计划/U_DyeCardZXEdit.pas
DESKTOP-E401PHE\Administrator a9ceaeacaf 初
2026-11-14 17:01:56 +08:00

548 lines
15 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_DyeCardZXEdit;
interface
uses
Windows, Messages, SysUtils, strutils, Variants, Classes, Graphics, Controls,
Forms, Dialogs, StdCtrls, ExtCtrls, BtnEdit, ComCtrls, cxStyles, cxCustomData,
cxGraphics, cxFilter, cxData, cxDataStorage, cxEdit, DB, cxDBData,
cxGridCustomTableView, cxGridTableView, cxGridDBTableView, ToolWin,
cxGridLevel, cxClasses, cxControls, cxGridCustomView, cxGrid, ADODB, DBClient,
cxCalendar, cxContainer, cxTextEdit, cxCurrencyEdit, cxDropDownEdit,
cxCheckBox, cxLookAndFeels, cxLookAndFeelPainters, cxNavigator, dxSkinsCore,
dxSkinsDefaultPainters, dxDateRanges, U_BaseInput, System.ImageList,
Vcl.ImgList, dxBarBuiltInMenu, cxGridCustomPopupMenu, cxGridPopupMenu,
cxButtonEdit, Vcl.Menus, dxScrollbarAnnotations, cxMemo;
type
TfrmDyeCardZXEdit = class(TfrmBaseInput)
CDS_Glide: TClientDataSet;
DS_Glide: TDataSource;
CDS_1: TClientDataSet;
DS_1: TDataSource;
ADO_Car: TADOQuery;
ADO_Glide: TADOQuery;
ADOQueryCmd: TADOQuery;
ADOQueryTmp: TADOQuery;
GPM_1: TcxGridPopupMenu;
Panel1: TPanel;
Panel2: TPanel;
cxGrid2: TcxGrid;
TV2: TcxGridDBTableView;
TV2Column1: TcxGridDBColumn;
TV2Column2: TcxGridDBColumn;
TV2Column3: TcxGridDBColumn;
cxGridLevel1: TcxGridLevel;
ToolBar1: TToolBar;
ToolButton4: TToolButton;
cxGrid1: TcxGrid;
TV1: TcxGridDBTableView;
v2PSName: TcxGridDBColumn;
cxGridLevel2: TcxGridLevel;
CDS_Card: TClientDataSet;
ToolButton1: TToolButton;
ToolButton6: TToolButton;
TV2Column4: TcxGridDBColumn;
TV2Column5: TcxGridDBColumn;
ADOQueryTmp1: TADOQuery;
CDS_Card1: TClientDataSet;
ToolButton8: TToolButton;
cxGrid3: TcxGrid;
TV3: TcxGridDBTableView;
cxGridDBColumn1: TcxGridDBColumn;
TV2Column35: TcxGridDBColumn;
cxGridDBColumn2: TcxGridDBColumn;
cxGridDBColumn3: TcxGridDBColumn;
v1PRTColor: TcxGridDBColumn;
cxGridDBColumn4: TcxGridDBColumn;
v1Column5: TcxGridDBColumn;
VC_PRTPs: TcxGridDBColumn;
v1PRTOrderQty: TcxGridDBColumn;
v1OrderUnit: TcxGridDBColumn;
cxGridDBColumn7: TcxGridDBColumn;
cxGridDBColumn5: TcxGridDBColumn;
cxGridDBColumn6: TcxGridDBColumn;
cxGridDBColumn8: TcxGridDBColumn;
TV2Column6: TcxGridDBColumn;
TV2Column7: TcxGridDBColumn;
cxGridLevel3: TcxGridLevel;
TV2Column8: TcxGridDBColumn;
ADOQuery1: TADOQuery;
DS_3: TDataSource;
CDS_3: TClientDataSet;
ToolButton2: TToolButton;
ToolButton3: TToolButton;
ToolButton5: TToolButton;
TV2Column9: TcxGridDBColumn;
procedure FormDestroy(Sender: TObject);
procedure FormClose(Sender: TObject; var Action: TCloseAction);
procedure ToolButton2Click(Sender: TObject);
procedure ToolButton3Click(Sender: TObject);
procedure ToolButton4Click(Sender: TObject);
procedure FormShow(Sender: TObject);
procedure ToolButton5Click(Sender: TObject);
procedure TBGXClick(Sender: TObject);
procedure TV1DblClick(Sender: TObject);
procedure ToolButton6Click(Sender: TObject);
procedure ToolButton1Click(Sender: TObject);
procedure ToolButton7Click(Sender: TObject);
procedure ToolButton8Click(Sender: TObject);
private
fOrdType: string;
procedure InitGrid1();
procedure InitCard();
procedure InitCard1();
procedure InitGlide();
{ Private declarations }
public
FWorkshop, FPCIDS, FWSql, FSUBID, FCODE, FMAINID, maxboxid: string;
{ Public declarations }
end;
var
frmDyeCardZXEdit: TfrmDyeCardZXEdit;
implementation
uses
U_DataLink, U_RTFun, U_DyeTechnicsSel;
{$R *.dfm}
procedure TfrmDyeCardZXEdit.InitCard1();
begin
try
with ADOQueryTmp1 do
begin
close;
sql.Clear;
sql.Add('select distinct left(GlideID,12) as GlideID1 from Trade_Plan_Glide where PCid in (' + trim(FWSql) + ' ) ');
showmessage(sql.text);
open;
end;
SCreateCDS(ADOQueryTmp1, CDS_Card1);
SInitCDSData(ADOQueryTmp1, CDS_Card1);
finally
end;
end;
procedure TfrmDyeCardZXEdit.InitGrid1();
begin
with ADOQueryTmp do
begin
Close;
SQL.Clear;
// sql.Add(' select * from Dye_Process ');
sql.Add(' select * from TRADE_PLAN_SUB WHERE MAINID= ' + QUOTEDSTR(FMAINID));
Open;
end;
SCreateCDS(ADOQueryTmp, CDS_3);
SInitCDSData(ADOQueryTmp, CDS_3);
end;
procedure TfrmDyeCardZXEdit.InitGlide();
begin
try
with Ado_Glide do
begin
close;
sql.Clear;
sql.Add('select A.*');
sql.Add('from Trade_box A ');
sql.Add('where 1<>1 ');
// showmessage(sql.text);
open;
end;
SCreateCDS(Ado_Glide, CDS_Glide);
SInitCDSData(Ado_Glide, CDS_Glide);
finally
end;
end;
procedure TfrmDyeCardZXEdit.InitCard();
begin
try
with ADOQueryTmp do
begin
close;
sql.Clear;
sql.Add('select * from V_TRADE_BOX WHERE MAINID=' + QUOTEDSTR(FMAINID));
open;
end;
SCreateCDS(ADOQueryTmp, CDS_1);
SInitCDSData(ADOQueryTmp, CDS_1);
finally
end;
end;
procedure TfrmDyeCardZXEdit.FormDestroy(Sender: TObject);
begin
inherited;
frmDyeCardZXEdit := nil;
end;
procedure TfrmDyeCardZXEdit.FormClose(Sender: TObject; var Action: TCloseAction);
begin
inherited;
Action := cahide;
end;
procedure TfrmDyeCardZXEdit.ToolButton1Click(Sender: TObject);
begin
WriteCxGrid(self.Caption + 'TV1', Tv1, 'װ<><D7B0><EFBFBD><EFBFBD><EFBFBD><EFBFBD>');
WriteCxGrid(self.Caption + 'TV2', Tv2, 'װ<><D7B0><EFBFBD><EFBFBD><EFBFBD><EFBFBD>');
WriteCxGrid(self.Caption + 'TV3', Tv3, 'װ<><D7B0><EFBFBD><EFBFBD><EFBFBD><EFBFBD>');
end;
procedure TfrmDyeCardZXEdit.ToolButton2Click(Sender: TObject);
begin
if not CDS_3.IsEmpty then
begin
//ȡ<><C8A1>Դ<EFBFBD><D4B4><EFBFBD><EFBFBD>subidֵ
var sSubId := CDS_3.FieldByName('subid').AsString;
//Locate<74>ж<EFBFBD>CDS_Glide<64><65>subid<69>Ƿ<EFBFBD><C7B7>Ѵ<EFBFBD><D1B4><EFBFBD>
if not CDS_Glide.Locate('subid', sSubId, []) then
begin
with CDS_Glide do
begin
Append;
FieldByName('C_Code').AsString := CDS_3.FieldByName('C_Code').AsString;
FieldByName('C_NAME').AsString := CDS_3.FieldByName('C_NAME').AsString;
FieldByName('C_Color').AsString := CDS_3.FieldByName('C_Color').AsString;
FieldByName('C_cjsize').AsString := CDS_3.FieldByName('C_cjsize').AsString;
FieldByName('mainid').AsString := CDS_3.FieldByName('mainid').AsString;
FieldByName('C_STYLENO').AsString := CDS_3.FieldByName('C_STYLENO').AsString;
FieldByName('subid').AsString := sSubId; //ֱ<><D6B1><EFBFBD>ñ<EFBFBD><C3B1><EFBFBD>
FieldByName('QTY').Value := 0;
Post;
end;
end
else
begin
Application.MessageBox('<27>óߴ<C3B3><DFB4><EFBFBD>ѡ<EFBFBD><D1A1><EFBFBD><EFBFBD>', '<27><>ʾ', 0);
exit;
end;
end;
end;
procedure TfrmDyeCardZXEdit.ToolButton3Click(Sender: TObject);
begin
if CDS_GLIDE.IsEmpty = FALSE then
begin
if Application.MessageBox('<27><>ǰ<EFBFBD><C7B0><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>,<2C><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>,<2C>Ƿ<EFBFBD><C7B7><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>', '<27><>ʾ', 32 + 4) <> IDYES then
Exit;
maxboxid := '';
InitGlide();
end;
end;
procedure TfrmDyeCardZXEdit.ToolButton4Click(Sender: TObject);
var
k: integer;
begin
if cds_Glide.IsEmpty then
exit;
try
ADOQueryCmd.Connection.BeginTrans;
with ADOQueryCmd do
begin
Close;
sql.Clear;
sql.Add('delete Trade_Plan_Glide where GlideID=''' + Trim(cds_Glide.fieldbyname('GlideID').AsString) + '''');
sql.Add('insert into SY_SysLog(operor,opertime,Model,acction,opevent,result) values( ');
sql.Add(' ' + quotedstr(trim(DName)));
sql.Add(',getdate() ');
sql.Add(',' + quotedstr(trim(self.Caption)));
sql.Add(',' + quotedstr(trim('ָʾ<D6B8><CABE>ɾ<EFBFBD><C9BE>')));
sql.Add(',' + quotedstr(trim('SUBID<49><44>' + fsubid + '<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' + trim(cds_Glide.FieldByName('GlideName').AsString))));
sql.Add(',' + quotedstr(trim('<27>ɹ<EFBFBD>')));
sql.Add(')');
ExecSQL;
end;
ADOQueryCmd.Connection.CommitTrans;
cds_Glide.Delete;
except
ADOQueryCmd.Connection.RollbackTrans;
Application.MessageBox('<27><><EFBFBD><EFBFBD>ɾ<EFBFBD><C9BE><EFBFBD>쳣<EFBFBD><ECB3A3>', '<27><>ʾ', 0);
end;
cds_Glide.IndexFieldNames := 'GlideNo';
cds_Glide.DisableControls;
cds_Glide.First;
k := 1;
while not cds_Glide.Eof do
begin
cds_Glide.Edit;
cds_Glide.FieldByName('GlideNo').Value := k;
cds_Glide.Post;
inc(k);
cds_Glide.Next;
end;
cds_Glide.First;
cds_Glide.EnableControls;
end;
procedure TfrmDyeCardZXEdit.FormShow(Sender: TObject);
begin
inherited;
ReadCxGrid(self.Caption + 'TV1', Tv1, 'װ<><D7B0><EFBFBD><EFBFBD><EFBFBD><EFBFBD>');
ReadCxGrid(self.Caption + 'TV2', Tv2, 'װ<><D7B0><EFBFBD><EFBFBD><EFBFBD><EFBFBD>');
ReadCxGrid(self.Caption + 'TV3', Tv3, 'װ<><D7B0><EFBFBD><EFBFBD><EFBFBD><EFBFBD>');
InitGrid1();
InitCard();
// InitCard1();
InitGlide();
end;
procedure TfrmDyeCardZXEdit.ToolButton5Click(Sender: TObject);
begin
if CDS_1.IsEmpty then
exit;
with Ado_Glide do
begin
close;
sql.Clear;
sql.Add('select A.*');
sql.Add('from Trade_box A ');
sql.Add('where boxid= ' + quotedstr(cds_1.FieldByName('boxid').AsString));
// showmessage(sql.text);
open;
end;
maxboxid := cds_1.FieldByName('boxid').AsString;
SCreateCDS(Ado_Glide, CDS_Glide);
SInitCDSData(Ado_Glide, CDS_Glide);
end;
procedure TfrmDyeCardZXEdit.ToolButton6Click(Sender: TObject);
begin
close;
end;
procedure TfrmDyeCardZXEdit.ToolButton7Click(Sender: TObject);
begin
// inherited;
if CDS_Glide.Locate('SSel', True, []) = False then
begin
Application.MessageBox('û<><C3BB>ѡ<EFBFBD><D1A1><EFBFBD><EFBFBD><EFBFBD><EFBFBD>!', '<27><>ʾ', 0);
Exit;
end;
try
CDS_Glide.DisableControls;
ADOQueryCmd.Connection.BeginTrans;
with CDS_Glide do
begin
First;
while not Eof do
begin
if CDS_Glide.FieldByName('SSel').AsBoolean = True then
begin
with ADOQueryCmd do
begin
Close;
sql.Clear;
sql.Add('Update Trade_Plan_Glide Set Dprice=''' + trim(CDS_Glide.fieldbyname('Dprice').AsString) + ''' ');
// sql.Add('where PCID=''' + trim(CDS_Glide.fieldbyname('PCID').AsString) + ''' and GlideName=''' + trim(CDS_Glide.fieldbyname('GlideName').AsString) + ''' ');
sql.Add('where PCID in (' + Trim(FWSql) + ' )and GlideName=''' + trim(CDS_Glide.fieldbyname('GlideName').AsString) + ''' ');
sql.Add('Update Trade_Plan_Glide_OutPut Set price=''' + trim(CDS_Glide.fieldbyname('Dprice').AsString) + ''' ');
// sql.Add('where PCID=''' + trim(CDS_Glide.fieldbyname('PCID').AsString) + ''' and GlideName=''' + trim(CDS_Glide.fieldbyname('GlideName').AsString) + ''' ');
sql.Add('where PCID in (' + Trim(FWSql) + ') and GlideName=''' + trim(CDS_Glide.fieldbyname('GlideName').AsString) + ''' ');
showmessage(sql.text);
ExecSQL;
end;
end;
Next;
end;
end;
ADOQueryCmd.Connection.CommitTrans;
CDS_Glide.EnableControls;
application.MessageBox('<27><><EFBFBD>ݱ<EFBFBD><DDB1><EFBFBD><EFBFBD>ɹ<EFBFBD><C9B9><EFBFBD>', '<27><>ʾ<EFBFBD><CABE>Ϣ');
except
ADOQueryCmd.Connection.RollbackTrans;
CDS_Glide.EnableControls;
application.MessageBox('<27><><EFBFBD>ݱ<EFBFBD><DDB1><EFBFBD>ʧ<EFBFBD>ܣ<EFBFBD>', '<27><>ʾ<EFBFBD><CABE>Ϣ', 0);
end;
// if CDS_Glide.FieldByName('SSel').AsBoolean = True then
// begin
// with CDS_Glide do
// begin
// DisableControls;
// First;
// while not Eof do
// begin
// if Fieldbyname('Ssel').AsBoolean then
// begin
// with ADOQueryCmd do
// begin
// Close;
// sql.Clear;
// sql.Add('Update Trade_Plan_Glide Set Dprice=''' + trim(CDS_Glide.fieldbyname('Dprice').AsString) + ''' ');
// sql.Add('where PCID=''' + trim(CDS_Glide.fieldbyname('PCID').AsString) + ''' and GlideName=''' + trim(CDS_Glide.fieldbyname('GlideName').AsString) + ''' ');
//
// sql.Add('Update Trade_Plan_Glide_OutPut Set price=''' + trim(CDS_Glide.fieldbyname('Dprice').AsString) + ''' ');
// sql.Add('where PCID=''' + trim(CDS_Glide.fieldbyname('PCID').AsString) + ''' and GlideName=''' + trim(CDS_Glide.fieldbyname('GlideName').AsString) + ''' ');
// ExecSQL;
// end;
//
// end;
// Next;
// end;
// EnableControls;
// end;
//
// end;
end;
procedure TfrmDyeCardZXEdit.ToolButton8Click(Sender: TObject);
var
MaxBCPID: string;
begin
if CDS_Glide.Locate('QTY', 0, []) then
begin
Application.MessageBox('ÿ<><C3BF><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ϊ0<CEAA><30>', '<27><>ʾ', 0);
Exit;
end;
if maxboxid = '' then
begin
if GetLSNo(ADOQueryCmd, maxboxid, 'B', 'Trade_BOX', 4, 1) = False then
begin
Application.MessageBox('ȡ<><C8A1><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ʧ<EFBFBD>ܣ<EFBFBD>', '<27><>ʾ', 0);
Exit;
end;
end;
try
CDS_Glide.DisableControls;
with CDS_Glide do
begin
First;
while not Eof do
begin
if Trim(CDS_Glide.fieldbyname('BOXSID').AsString) = '' then
begin
if GetLSNo(ADOQueryCmd, MaxBCPID, 'P', 'Trade_BOX', 4, 1) = False then
begin
ADOQueryCmd.Connection.RollbackTrans;
Application.MessageBox('ȡ<><C8A1><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ʧ<EFBFBD>ܣ<EFBFBD>', '<27><>ʾ', 0);
Exit;
end;
end
else
begin
MaxBCPID := Trim(CDS_Glide.fieldbyname('BOXSID').AsString);
end;
with ADOQueryCmd do
begin
Close;
SQL.Clear;
sql.Add('select * from Trade_BOX where BOXSID=''' + Trim(MaxBCPID) + '''');
Open;
end;
with ADOQueryCmd do
begin
if ADOQueryCmd.IsEmpty then
Append
else
Edit;
RTSetSaveDataCDS(ADOQueryCmd, Tv2, CDS_Glide, 'Trade_BOX', 0);
FieldByName('BOXSID').Value := Trim(MaxBCPID);
FieldByName('BOXID').Value := Trim(maxboxid);
FieldByName('subid').Value := Trim(CDS_Glide.FieldByName('subid').AsString);
FieldByName('MAINID').Value := Trim(CDS_Glide.FieldByName('MAINID').AsString);
Post;
end;
with CDS_Glide do
begin
Edit;
FieldByName('BOXSID').Value := Trim(MaxBCPID);
FieldByName('BOXID').Value := Trim(maxboxid);
Post;
end;
Next;
end;
end;
CDS_Glide.EnableControls;
Application.MessageBox('<27><><EFBFBD><EFBFBD><EFBFBD>ɹ<EFBFBD><C9B9><EFBFBD>', '<27><>ʾ', 0);
// ModalResult := 1;
except
CDS_Glide.EnableControls;
application.MessageBox('<27><><EFBFBD><EFBFBD>ʧ<EFBFBD>ܣ<EFBFBD>', '<27><>ʾ<EFBFBD><CABE>Ϣ', MB_ICONERROR);
end;
////////////////// <20><><EFBFBD>湤<EFBFBD><E6B9A4><EFBFBD><EFBFBD> //////////////////////
initcard();
////////////////// <20><><EFBFBD>湤<EFBFBD><E6B9A4><EFBFBD><EFBFBD> //////////////////////
end;
procedure TfrmDyeCardZXEdit.TV1DblClick(Sender: TObject);
begin
// with CDS_1 do
// begin
// CDS_Glide.Append;
// CDS_Glide.FieldByName('GlideNo').Value := CDS_Glide.RecordCount + 1;
// CDS_Glide.FieldByName('GlideName').Value := CDS_1.fieldbyname('PSName').AsString;
// CDS_Glide.FieldByName('Note').Value := CDS_1.fieldbyname('Note').AsString;
// CDS_Glide.Post;
// end;
end;
procedure TfrmDyeCardZXEdit.TBGXClick(Sender: TObject);
begin
frmDyeTechnicsSel := TfrmDyeTechnicsSel.create(self);
with frmDyeTechnicsSel do
begin
if showmodal = 1 then
begin
with frmDyeTechnicsSel.CDS_1 do
begin
First;
CDS_Glide.EmptyDataSet;
while not Eof do
begin
CDS_Glide.Append;
CDS_Glide.FieldByName('GlideNo').Value := CDS_Glide.RecordCount + 1;
CDS_Glide.FieldByName('GlideName').Value := frmDyeTechnicsSel.CDS_1.fieldbyname('PSName').AsString;
CDS_Glide.FieldByName('Note').Value := frmDyeTechnicsSel.CDS_1.fieldbyname('Note').AsString;
CDS_Glide.FieldByName('Dprice').Value := frmDyeTechnicsSel.CDS_1.fieldbyname('PSDprice').AsFloat;
CDS_Glide.Post;
Next;
end;
end;
end;
free;
end;
end;
end.