D10clhege/T01贸易生产计划/U_DyeCardGlideEdit2.pas

656 lines
19 KiB
ObjectPascal
Raw Permalink Normal View History

2026-11-14 17:01:56 +08:00
unit U_DyeCardGlideEdit2;
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;
type
TfrmDyeCardGlideEdit2 = 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;
TBGX: TToolButton;
ToolButton2: TToolButton;
ToolButton3: TToolButton;
ToolButton4: TToolButton;
ToolButton5: TToolButton;
cxGrid1: TcxGrid;
TV1: TcxGridDBTableView;
v2PSName: TcxGridDBColumn;
v2PSNote: TcxGridDBColumn;
v2SYRName: TcxGridDBColumn;
vLDPrice: TcxGridDBColumn;
v2Column1: TcxGridDBColumn;
cxGridLevel2: TcxGridLevel;
CDS_Card: TClientDataSet;
ToolButton1: TToolButton;
ToolButton6: TToolButton;
TV2Column4: TcxGridDBColumn;
TV2Column5: TcxGridDBColumn;
ToolButton7: TToolButton;
ADOQueryTmp1: TADOQuery;
CDS_Card1: TClientDataSet;
ToolButton8: TToolButton;
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: string;
{ Public declarations }
end;
var
frmDyeCardGlideEdit2: TfrmDyeCardGlideEdit2;
implementation
uses
U_DataLink, U_RTFun, U_DyeTechnicsSel;
{$R *.dfm}
procedure TfrmDyeCardGlideEdit2.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 TfrmDyeCardGlideEdit2.InitGrid1();
begin
with ADOQueryTmp do
begin
Close;
SQL.Clear;
// sql.Add(' select * from Dye_Process ');
sql.Add(' select * from Trade_Process ');
Open;
end;
SCreateCDS(ADOQueryTmp, CDS_1);
SInitCDSData(ADOQueryTmp, CDS_1);
end;
procedure TfrmDyeCardGlideEdit2.InitGlide();
begin
try
with Ado_Glide do
begin
close;
sql.Clear;
sql.Add('select A.*');
sql.Add('from Trade_Plan_Glide A ');
sql.Add('where A.SUBID=''' + trim(fsubid) + ''' ');
// showmessage(sql.text);
open;
end;
SCreateCDS(Ado_Glide, CDS_Glide);
SInitCDSData(Ado_Glide, CDS_Glide);
if CDS_Glide.IsEmpty then
begin
with ADOQueryTmp do
begin
close;
sql.Clear;
sql.Add('select A.*');
sql.Add('from Bs_Process A ');
sql.Add('where A.BCIID=(SELECT TOP 1 BCIID FROM BS_CLOTH_INFO E WHERE E.C_CODE=''' + trim(fcode) + ''' ');
SQL.Add(') ORDER BY SerialNo');
// showmessage(sql.text);
open;
end;
if ADOQueryTmp.IsEmpty = FALSE then
begin
with ADOQueryTmp do
begin
First;
while not Eof do
begin
with CDS_Glide do
begin
append;
FIELDBYNAME('GlideNo').ASSTRING := ADOQueryTmp.FieldByName('SerialNo').AsString;
FIELDBYNAME('GlideName').ASSTRING := ADOQueryTmp.FieldByName('psname').AsString;
FIELDBYNAME('Dprice').ASSTRING := ADOQueryTmp.FieldByName('price').AsString;
post;
end;
Next;
end;
end;
end;
end;
finally
end;
end;
procedure TfrmDyeCardGlideEdit2.InitCard();
begin
// try
// with ADOQueryTmp do
// begin
// close;
// sql.Clear;
// sql.Add('select * from [dbo].[F_Tool_SplitString](' + quotedstr(FPCIDS) + ','';'') A ');
// open;
// end;
// SCreateCDS(ADOQueryTmp, CDS_Card);
// SInitCDSData(ADOQueryTmp, CDS_Card);
// finally
// end;
end;
procedure TfrmDyeCardGlideEdit2.FormDestroy(Sender: TObject);
begin
inherited;
frmDyeCardGlideEdit2 := nil;
end;
procedure TfrmDyeCardGlideEdit2.FormClose(Sender: TObject; var Action: TCloseAction);
begin
inherited;
Action := cahide;
end;
procedure TfrmDyeCardGlideEdit2.ToolButton1Click(Sender: TObject);
begin
WriteCxGrid(self.Caption + 'TV1', Tv1, '<27><><EFBFBD><EFBFBD>ָʾ<D6B8><CABE><EFBFBD><EFBFBD><EFBFBD><EFBFBD>');
WriteCxGrid(self.Caption + 'TV2', Tv2, '<27><><EFBFBD><EFBFBD>ָʾ<D6B8><CABE><EFBFBD><EFBFBD><EFBFBD><EFBFBD>');
end;
procedure TfrmDyeCardGlideEdit2.ToolButton2Click(Sender: TObject);
begin
with CDS_Glide do
begin
if IsEmpty then
Exit;
if RecNo >= 1 then
begin
//Prior;
Edit;
fieldByName('GlideNo').Value := fieldByName('GlideNo').Value - 1;
Post;
Prior;
Edit;
fieldByName('GlideNo').Value := fieldByName('GlideNo').Value + 1;
Post;
end;
Prior;
end;
end;
procedure TfrmDyeCardGlideEdit2.ToolButton3Click(Sender: TObject);
begin
CDS_Glide.IndexFieldNames := 'GlideNo';
with CDS_Glide do
begin
if IsEmpty then
Exit;
Next;
if not Eof then
Prior
else
begin
exit;
end;
if not Eof then
begin
Edit;
fieldByName('GlideNo').Value := fieldByName('GlideNo').Value + 1;
Post;
Prior;
Edit;
fieldByName('GlideNo').Value := fieldByName('GlideNo').Value - 1;
Post;
end;
Next;
end;
end;
procedure TfrmDyeCardGlideEdit2.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 TfrmDyeCardGlideEdit2.FormShow(Sender: TObject);
begin
inherited;
ReadCxGrid(self.Caption + 'TV1', Tv1, '<27><><EFBFBD><EFBFBD>ָʾ<D6B8><CABE><EFBFBD><EFBFBD><EFBFBD><EFBFBD>');
ReadCxGrid(self.Caption + 'TV2', Tv2, '<27><><EFBFBD><EFBFBD>ָʾ<D6B8><CABE><EFBFBD><EFBFBD><EFBFBD><EFBFBD>');
InitGrid1();
InitCard();
// InitCard1();
InitGlide();
end;
procedure TfrmDyeCardGlideEdit2.ToolButton5Click(Sender: TObject);
var
maxID, sqlstr, sqlstr1, MaxmaxId: string;
x: integer;
begin
if CDS_Glide.IsEmpty then
exit;
if CDS_Card.IsEmpty then
exit;
Self.TV2.GetColumnByFieldName('GlideName').Focused := True;
sqlstr1 := '';
sqlstr := '';
x := 1;
try
CDS_Glide.DisableControls;
with CDS_Card do
begin
CDS_Card.First;
while not eof do
begin
// CDS_Glide.DisableControls;
try
ADOQueryCmd.Connection.BeginTrans;
sqlstr1 := sqlstr1 + 'delete from Trade_Plan_Glide ';
sqlstr1 := sqlstr1 + ' where PCID= ';
sqlstr1 := sqlstr1 + ' ''' + trim(CDS_Card.fieldbyname('RTValue').asstring) + ''' ';
// ADOQueryCmd.Connection.BeginTrans;
// with ADOQueryCmd do
// begin
// close;
// sql.Clear;
// sql.Add('delete from Trade_Plan_Glide ');
// sql.Add('where PCID=''' + trim(CDS_Card.fieldbyname('RTValue').asstring) + '''');
// execsql;
// end;
CDS_Glide.First;
if trim(CDS_Glide.FieldByName('GlideID').asstring) = '' then
begin
if GetLSNo(ADOQueryCmd, maxID, 'CG', 'Trade_Plan_Glide', 4, 1) = False then
raise Exception.Create(PChar('ȡ<><C8A1><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ʧ<EFBFBD><CAA7>!'));
end
else
begin
// maxID := leftstr(trim(CDS_Glide.FieldByName('GlideID').asstring), 12);
maxID := leftstr(trim(CDS_Glide.FieldByName('GlideID').asstring), 12);
end;
// CDS_Glide.First;
while not CDS_Glide.Eof do
begin
// if trim(CDS_Glide.FieldByName('GlideID').asstring) = '' then
// begin
// if GetLSNo(ADOQueryCmd, maxID, 'CG', 'Trade_Plan_Glide', 4, 1) = False then
// raise Exception.Create(PChar('ȡ<><C8A1><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ʧ<EFBFBD><CAA7>!'));
// end;
//
MaxmaxId := trim(maxID) + inttostr(x); //rightstr(maxID,9) MaxmaxId := trim(maxID) + inttostr(x);
//
// MaxmaxId := 'CG' + inttostr(strtoint(Copy(maxID, 3, 9)) + x);
sqlstr := sqlstr + 'insert into Trade_Plan_Glide(Filler,GlideID,PCID,GlideNo,GlideName,Note,Dprice) ';
sqlstr := sqlstr + ' values( ';
sqlstr := sqlstr + ' ''' + trim(DName) + ''', ';
sqlstr := sqlstr + ' ''' + trim(MaxmaxId) + ''', ';
sqlstr := sqlstr + ' ''' + trim(CDS_Card.fieldbyname('RTValue').AsString) + ''', ';
sqlstr := sqlstr + ' ''' + trim(CDS_Glide.fieldbyname('GlideNo').AsString) + ''', ';
sqlstr := sqlstr + ' ''' + trim(CDS_Glide.fieldbyname('GlideName').AsString) + ''', ';
sqlstr := sqlstr + ' ''' + trim(CDS_Glide.fieldbyname('Note').AsString) + ''', ';
// sqlstr := sqlstr + ' ''' + strtofloatdef((CDS_Glide.fieldbyname('Dprice').Asfloat),0) + ''' ';
sqlstr := sqlstr + 'cast(isnull(''' + trim(CDS_Glide.fieldbyname('Dprice').AsString) + ''',0)as float) ';
sqlstr := sqlstr + ' ) ';
// with ADOQueryCmd do
// begin
// close;
// sql.Clear;
// sql.Add('select * from Trade_Plan_Glide A where 1=2');
// open;
//
// append;
// fieldbyname('Filler').Value := trim(DName);
// FieldByName('GlideID').Value := trim(maxID);
// FieldByName('PCID').Value := trim(CDS_Card.fieldbyname('RTValue').AsString);
// FieldByName('GlideNo').Value := trim(CDS_Glide.fieldbyname('GlideNo').AsString);
// FieldByName('GlideName').Value := trim(CDS_Glide.fieldbyname('GlideName').AsString);
// FieldByName('Note').Value := trim(CDS_Glide.fieldbyname('Note').AsString);
// post;
// end;
x := x + 1;
CDS_Glide.Next;
end;
// x := x + 1;
ADOQueryCmd.Connection.CommitTrans;
except
ADOQueryCmd.Connection.RollbackTrans;
raise Exception.Create(PChar(Exception(ExceptObject).Message));
end;
CDS_Card.Next;
end;
with ADOQueryCmd do
begin
close;
sql.Clear;
sql.Add(sqlstr1);
// showmessage(sql.Text);
execsql;
end;
with ADOQueryCmd do
begin
close;
sql.Clear;
sql.Add(sqlstr);
// showmessage(sql.Text);
execsql;
end;
end;
CDS_Glide.EnableControls;
ModalResult := 1;
except
CDS_Glide.EnableControls;
application.MessageBox('<27><><EFBFBD><EFBFBD>ʧ<EFBFBD>ܣ<EFBFBD>', '<27><>ʾ<EFBFBD><CABE>Ϣ', MB_ICONERROR);
end;
end;
procedure TfrmDyeCardGlideEdit2.ToolButton6Click(Sender: TObject);
begin
close;
end;
procedure TfrmDyeCardGlideEdit2.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 TfrmDyeCardGlideEdit2.ToolButton8Click(Sender: TObject);
var
MaxBCPID: string;
begin
try
CDS_Glide.DisableControls;
with CDS_Glide do
begin
First;
while not Eof do
begin
if Trim(CDS_Glide.fieldbyname('GlideID').AsString) = '' then
begin
if GetLSNo(ADOQueryCmd, MaxBCPID, 'P', 'Trade_Plan_Glide', 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('GlideID').AsString);
end;
with ADOQueryCmd do
begin
Close;
SQL.Clear;
sql.Add('select * from Trade_Plan_Glide where GlideID=''' + Trim(MaxBCPID) + '''');
Open;
end;
with ADOQueryCmd do
begin
if ADOQueryCmd.IsEmpty then
Append
else
Edit;
RTSetSaveDataCDS(ADOQueryCmd, Tv2, CDS_Glide, 'Trade_Plan_Glide', 0);
FieldByName('GlideID').Value := Trim(MaxBCPID);
FieldByName('subid').Value := Trim(FSUBID);
FieldByName('MAINID').Value := Trim(FMAINID);
Post;
end;
with CDS_Glide do
begin
Edit;
FieldByName('GlideID').Value := Trim(MaxBCPID);
Post;
end;
Next;
end;
end;
CDS_Glide.EnableControls;
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> //////////////////////
////////////////// <20><><EFBFBD>湤<EFBFBD><E6B9A4><EFBFBD><EFBFBD> //////////////////////
end;
procedure TfrmDyeCardGlideEdit2.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 TfrmDyeCardGlideEdit2.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.