D10clhege/B01基础合同管理/U_DyeCardGlideEdit2.pas
DESKTOP-E401PHE\Administrator a9ceaeacaf 初
2026-11-14 17:01:56 +08:00

658 lines
18 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_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;
Panel3: TPanel;
Label35: TLabel;
GY_DANCENG: TEdit;
Label1: TLabel;
GY_SHUANGCENG: TEdit;
Label2: TLabel;
GY_DINXING: TEdit;
Label16: TLabel;
GY_GOUZI: TComboBox;
Label3: TLabel;
Label4: TLabel;
GY_TIEHUAN: TEdit;
Label5: TLabel;
GY_CHOUDAI: TEdit;
GY_ZHEZISHU: TcxCurrencyEdit;
Label6: TLabel;
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 GY_DANCENGClick(Sender: TObject);
procedure GY_SHUANGCENGClick(Sender: TObject);
procedure GY_DINXINGClick(Sender: TObject);
procedure GY_TIEHUANClick(Sender: TObject);
procedure GY_CHOUDAIClick(Sender: TObject);
private
fOrdType: string;
procedure InitGrid1();
procedure InitCard();
procedure InitCard1();
procedure InitGlide();
{ Private declarations }
public
FWorkshop, FPCIDS, FWSql: 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) + ' ) ');
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.PCID=''' + trim(CDS_Card.fieldbyname('RTValue').AsString) + ''' ');
// showmessage(sql.text);
open;
end;
SCreateCDS(Ado_Glide, CDS_Glide);
SInitCDSData(Ado_Glide, CDS_Glide);
with ADOQueryTmp do
begin
close;
sql.Clear;
sql.Add('select A.*');
sql.Add('from Bs_Contract_Sub A ');
sql.Add('where A.consid=''' + trim(CDS_Card.fieldbyname('RTValue').AsString) + ''' ');
// showmessage(sql.text);
open;
end;
SCSHData(ADOQueryTmp, panel3, 0);
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;
cds_Glide.Delete;
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.GY_CHOUDAIClick(Sender: TObject);
begin
if GY_choudai.Text = '' then
begin
GY_choudai.Text := '<27><>';
end
else
begin
GY_choudai.Text := '';
end;
end;
procedure TfrmDyeCardGlideEdit2.GY_DANCENGClick(Sender: TObject);
begin
if GY_DANCENG.Text = '' then
begin
GY_DANCENG.Text := '<27><>';
GY_SHUANGCENG.Text := '';
end
else
begin
GY_DANCENG.Text := '';
GY_SHUANGCENG.Text := '<27><>';
end;
end;
procedure TfrmDyeCardGlideEdit2.GY_DINXINGClick(Sender: TObject);
begin
if GY_dinxing.Text = '' then
begin
GY_dinxing.Text := '<27><>';
end
else
begin
GY_dinxing.Text := '';
end;
end;
procedure TfrmDyeCardGlideEdit2.GY_SHUANGCENGClick(Sender: TObject);
begin
if GY_SHUANGCENG.Text = '' then
begin
GY_SHUANGCENG.Text := '<27><>';
GY_DANCENG.Text := '';
end
else
begin
GY_SHUANGCENG.Text := '';
GY_DANCENG.Text := '<27><>';
end;
end;
procedure TfrmDyeCardGlideEdit2.GY_TIEHUANClick(Sender: TObject);
begin
if GY_tiehuan.Text = '' then
begin
GY_tiehuan.Text := '<27><>';
end
else
begin
GY_tiehuan.Text := '';
end;
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) + ''' ';
sqlstr1 := sqlstr1 + ' update Bs_Contract_Sub set ';
sqlstr1 := sqlstr1 + 'GY_DANCENG=''' + Trim(GY_DANCENG.Text) + ''',';
sqlstr1 := sqlstr1 + 'GY_SHUANGCENG=''' + Trim(GY_SHUANGCENG.Text) + ''',';
sqlstr1 := sqlstr1 + 'GY_DINXING=''' + Trim(GY_DINXING.Text) + ''',';
sqlstr1 := sqlstr1 + 'GY_GOUZI=''' + Trim(GY_GOUZI.Text) + ''',';
sqlstr1 := sqlstr1 + 'GY_TIEHUAN=''' + Trim(GY_TIEHUAN.Text) + ''',';
sqlstr1 := sqlstr1 + 'GY_CHOUDAI=''' + Trim(GY_CHOUDAI.Text) + ''',';
sqlstr1 := sqlstr1 + 'GY_ZHEZISHU=''' + Trim(GY_ZHEZISHU.Text) + ''' ';
sqlstr1 := sqlstr1 + ' where consid= ';
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;
if Application.MessageBox('<27><><EFBFBD><EFBFBD><EFBFBD>ɹ<EFBFBD><C9B9>Ƿ񸲸ǹ<F1B8B2B8><C7B9>յ<EFBFBD><D5B5><EFBFBD>Ʒ<EFBFBD><C6B7>', '<27><>ʾ', 32 + 4) = IDYES then
begin
with ADOQueryCmd do
begin
close;
sql.Clear;
sql.Add('exec P_Trade_Card_INTOCP ');
sql.Add(' @Filtration=' + quotedstr(trim(FPCIDS)));
// showmessage(sql.Text);
execsql;
end;
end;
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.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.