RTFormwork/项目代码/RTBasicsV1/D01针织生产计划/U_KnitInspSet.pas
“ddf” 61630656e9 1
2024-07-07 09:35:27 +08:00

552 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_KnitInspSet;
interface
uses
Windows, Messages, StrUtils, SysUtils, Variants, Classes, Graphics, Controls,
Forms, Dialogs, cxGraphics, cxCustomData, cxStyles, cxTL, cxMaskEdit, DB,
ADODB, cxInplaceContainer, cxDBTL, cxControls, cxTLData, ComCtrls, ToolWin,
StdCtrls, cxFilter, cxData, cxDataStorage, cxEdit, cxDBData, DBClient,
cxGridCustomTableView, cxGridTableView, cxGridDBTableView, ExtCtrls,
cxSplitter, cxGridLevel, cxClasses, cxGridCustomView, cxGrid,
cxGridCustomPopupMenu, cxGridPopupMenu, RM_Dataset, RM_System, RM_Common,
RM_Class, RM_GridReport, IdBaseComponent, IdComponent, IdTCPConnection,
IdTCPClient, IdFTP, ShellAPI, IniFiles, cxCheckBox, cxCalendar, cxButtonEdit,
cxTextEdit, cxDropDownEdit, BtnEdit, cxLookAndFeels, cxLookAndFeelPainters,
cxNavigator, dxSkinsCore, dxSkinsDefaultPainters, dxDateRanges,
dxBarBuiltInMenu, U_BaseList, cxContainer, dxCore, cxDateUtils, cxImage,
cxDBEdit, IdExplicitTLSClientServerBase, RM_Preview, cxPC, U_BaseHelp,
System.ImageList, Vcl.ImgList, RTComboBox, RM_BarCode, RM_e_Xls, RM_e_Jpeg,
RM_E_llPDF, RM_e_main, RM_e_htm, RM_e_Tiff, RM_e_emf, RM_e_Graphic, RM_e_bmp,
RM_e_csv, RM_e_txt, RM_DialogCtls, RM_Cross, RM_Diagonal, RM_ChineseMoneyMemo,
RM_Ole, RM_CheckBox, RM_RichEdit, RM_AngLbl, RM_FormReport, RM_PDBGrid,
RMD_Dbx, RMD_ADO, RMD_ReportExplorer, RM_DsgGridReport, RM_Designer;
type
TfrmKnitInspSet = class(TfrmBaseHelp)
ToolBar1: TToolBar;
TBClose: TToolButton;
ADOQueryTemp: TADOQuery;
ADOQueryCmd: TADOQuery;
ADOQueryMain: TADOQuery;
ToolButton3: TToolButton;
ScrollBox1: TScrollBox;
Label14: TLabel;
Label1: TLabel;
cxPageControl1: TcxPageControl;
cxTabSheet4: TcxTabSheet;
cxTabSheet3: TcxTabSheet;
RMPreview2: TRMPreview;
RMPreview1: TRMPreview;
Label2: TLabel;
RuleBeforeTare: TEdit;
RuleConversion: TComboBox;
Label3: TLabel;
Coefficient: TEdit;
Label4: TLabel;
ADOQueryLabel: TADOQuery;
RM1: TRMGridReport;
RMDB_1: TRMDBDataSet;
ADO_1: TADOQuery;
RM2: TRMGridReport;
RMDB_2: TRMDBDataSet;
cxTabSheet1: TcxTabSheet;
DS_Label: TDataSource;
CDS_Label: TClientDataSet;
RMDB_Label: TRMDBDataSet;
RMLabel: TRMGridReport;
Panel1: TPanel;
Panel2: TPanel;
cxGridLabel: TcxGrid;
TVLabel: TcxGridDBTableView;
TVLabellabelId: TcxGridDBColumn;
TVLabellabeltype: TcxGridDBColumn;
TVLabellabelCaption: TcxGridDBColumn;
TVLabellabelFile: TcxGridDBColumn;
cxGridLabelLevel1: TcxGridLevel;
RMPreview3: TRMPreview;
Panel4: TPanel;
Label9: TLabel;
Label10: TLabel;
LabelCaption: TEdit;
LabelType: TRTComboBox;
ToolBar2: TToolBar;
ToolButton1: TToolButton;
ToolButton2: TToolButton;
Tadd: TToolButton;
Tupd: TToolButton;
Tdel: TToolButton;
ToolButton4: TToolButton;
RMBarCodeObject1: TRMBarCodeObject;
RMXLSExport1: TRMXLSExport;
RMDataDictionary1: TRMDataDictionary;
ADO_Down: TADOQuery;
TVLabelColumn1: TcxGridDBColumn;
TVLabelColumn2: TcxGridDBColumn;
LabVolume: TEdit;
LabPackage: TEdit;
Label5: TLabel;
RulePieceNo: TComboBox;
Label6: TLabel;
RuleLenUnit: TComboBox;
Label8: TLabel;
RuleLaterTare: TEdit;
ToolButton5: TToolButton;
RMReport1: TRMReport;
RMCompositeReport1: TRMCompositeReport;
RMDBDataSet1: TRMDBDataSet;
RMUserDataset1: TRMUserDataset;
RMAngledLabelObject1: TRMAngledLabelObject;
RMRichObject1: TRMRichObject;
RMCheckBoxObject1: TRMCheckBoxObject;
RMOLEObject1: TRMOLEObject;
RMChineseMoneyObject1: TRMChineseMoneyObject;
RMDiagonalObject1: TRMDiagonalObject;
RMCrossObject1: TRMCrossObject;
RMDialogControls1: TRMDialogControls;
RMTextExport1: TRMTextExport;
RMCSVExport1: TRMCSVExport;
RMBMPExport1: TRMBMPExport;
RMEMFExport1: TRMEMFExport;
RMTiffExport1: TRMTiffExport;
RMHTMExport1: TRMHTMExport;
RMllPDFExport1: TRMllPDFExport;
RMJPEGExport1: TRMJPEGExport;
RMDesigner1: TRMDesigner;
RMGridReportDesigner1: TRMGridReportDesigner;
RMReportExplorer1: TRMReportExplorer;
RMDADOComponents1: TRMDADOComponents;
RMDDBXComponents1: TRMDDBXComponents;
RMFormReport1: TRMFormReport;
RMPrintDBGrid1: TRMPrintDBGrid;
procedure FormDestroy(Sender: TObject);
procedure FormClose(Sender: TObject; var Action: TCloseAction);
procedure TBCloseClick(Sender: TObject);
procedure FormShow(Sender: TObject);
procedure TBRafreshClick(Sender: TObject);
procedure ToolButton3Click(Sender: TObject);
procedure cxPageControl1Change(Sender: TObject);
procedure ToolButton1Click(Sender: TObject);
procedure ToolButton2Click(Sender: TObject);
procedure TupdClick(Sender: TObject);
procedure TdelClick(Sender: TObject);
procedure TaddClick(Sender: TObject);
procedure ToolButton4Click(Sender: TObject);
procedure LabelTypeChange(Sender: TObject);
procedure TVLabelCellClick(Sender: TcxCustomGridTableView; ACellViewInfo: TcxGridTableDataCellViewInfo; AButton: TMouseButton; AShift: TShiftState; var AHandled: Boolean);
procedure ToolButton5Click(Sender: TObject);
private
{ Private declarations }
procedure InitGrid();
function SaveData(): Boolean;
procedure InitLabel();
function SaveLabel(MLabelID: string): Boolean;
procedure InitLabVolume();
procedure InitLabPackage();
public
FDataID: string;
end;
var
frmKnitInspSet: TfrmKnitInspSet;
implementation
uses
U_DataLink, U_RTFun, U_LabelInput;
{$R *.dfm}
function TfrmKnitInspSet.SaveLabel(MLabelID: string): Boolean;
begin
try
ADOQueryCmd.Connection.BeginTrans;
with ADOQueryCmd do
begin
close;
sql.Clear;
sql.Add('select * from Knit_Label');
sql.Add('where LabelID=' + Quotedstr(MLabelID));
Open;
Edit;
fieldByName('Editer').value := DName;
FieldByName('EditTime').Value := SGetServerDateTime(ADOQueryTemp);
// RMLabel.SaveToBlobField(TBlobField(FieldByName('LabelFile')));
Post;
end;
ADOQueryCmd.Connection.CommitTrans;
result := true;
except
ADOQueryCmd.Connection.RollbackTrans;
Result := false;
application.MessageBox('<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ǩģ<C7A9><C4A3><EFBFBD><EFBFBD><EFBFBD><EFBFBD>!', '<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ϣ', 0);
end;
end;
procedure TfrmKnitInspSet.InitLabel();
begin
with ADOQueryMain do
begin
close;
sql.Clear;
sql.Add(' select * from Knit_Label');
sql.Add(' order by labeltype,labelCaption');
Open;
end;
SDofilter(ADOQueryMain, SGetFilters(Panel4, 1, 2));
SCreateCDS(ADOQueryMain, CDS_Label);
SInitCDSData(ADOQueryMain, CDS_Label);
end;
procedure TfrmKnitInspSet.InitLabVolume();
begin
with ADOQueryLabel do
begin
close;
sql.Clear;
sql.Add('select top 1 * from RT_FileUpdate');
sql.Add('where FileName=' + quotedstr(trim(LabVolume.Text) + '.rmf'));
Open;
end;
if ADOQueryLabel.IsEmpty then
exit;
with RM1 do
begin
LoadFromBlobField(tblobfield(ADOQueryLabel.fieldbyname('Files')));
Preview := RMPreview1;
ShowReport;
end;
end;
procedure TfrmKnitInspSet.InitLabPackage();
begin
with ADOQueryLabel do
begin
close;
sql.Clear;
sql.Add('select top 1 * from RT_FileUpdate');
sql.Add('where FileName=' + quotedstr(trim(LabPackage.Text) + '.rmf'));
Open;
end;
if ADOQueryLabel.IsEmpty then
exit;
with RM2 do
begin
LoadFromBlobField(tblobfield(ADOQueryLabel.fieldbyname('Files')));
Preview := RMPreview2;
ShowReport;
end;
end;
procedure TfrmKnitInspSet.LabelTypeChange(Sender: TObject);
begin
if ADOQueryMain.Active then
begin
SDofilter(ADOQueryMain, SGetFilters(Panel4, 1, 2));
SCreateCDS(ADOQueryMain, CDS_Label);
SInitCDSData(ADOQueryMain, CDS_Label);
end;
end;
procedure TfrmKnitInspSet.InitGrid();
begin
with ADOQueryTemp do
begin
Close;
SQL.Clear;
sql.Add(' select * from Knit_Cloth_Inspect_Rule where RuleID=''' + Trim(FDataID) + '''');
Open;
end;
SCSHData(ADOQueryTemp, ScrollBox1, 2);
end;
procedure TfrmKnitInspSet.FormDestroy(Sender: TObject);
begin
inherited;
frmKnitInspSet := nil;
end;
procedure TfrmKnitInspSet.cxPageControl1Change(Sender: TObject);
begin
case cxPageControl1.ActivePageIndex of
1:
begin
InitLabVolume();
end;
2:
begin
InitLabPackage();
end;
end;
end;
procedure TfrmKnitInspSet.FormClose(Sender: TObject; var Action: TCloseAction);
begin
inherited;
Action := caFree;
end;
procedure TfrmKnitInspSet.TaddClick(Sender: TObject);
begin
try
frmLabelInput := TfrmLabelInput.create(self);
with frmLabelInput do
begin
FLabelId := '';
if showModal = 1 then
begin
InitLabel();
end;
end;
finally
frmLabelInput.Free;
end;
end;
procedure TfrmKnitInspSet.TBCloseClick(Sender: TObject);
begin
ModalResult := 1;
end;
procedure TfrmKnitInspSet.FormShow(Sender: TObject);
begin
inherited;
ExportFtErpFile(<><C4A3><EFBFBD><EFBFBD>ǩ.rmf', ADOQueryTemp);
with ADO_1 do
begin
Close;
SQL.Clear;
sql.Add('exec P_BS_Label_Get_Test');
Open;
end;
Initlabel();
InitGrid();
end;
procedure TfrmKnitInspSet.TBRafreshClick(Sender: TObject);
begin
InitGrid();
end;
procedure TfrmKnitInspSet.TdelClick(Sender: TObject);
begin
try
with ADOQueryCmd do
begin
close;
sql.clear;
sql.Add('delete Knit_Label');
sql.Add('where labelId=' + quotedstr(CDS_Label.fieldByName('LabelID').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('<27><>ǩɾ<C7A9><C9BE>')));
sql.Add(',' + quotedstr(trim('<27><>ǩ<EFBFBD><C7A9><EFBFBD>ƣ<EFBFBD>' + trim(CDS_Label.fieldByName('labelCaption').asString))));
sql.Add(',' + quotedstr(trim('<27>ɹ<EFBFBD>')));
sql.Add(')');
execSql;
end;
CDS_Label.Delete;
except
application.MessageBox(<><C9BE>ʧ<EFBFBD><CAA7>!', '<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ϣ', 0);
end;
end;
function TfrmKnitInspSet.SaveData(): Boolean;
var
MaxId, MaxSubId, FCoCode, FCCID, MaxCFID: string;
begin
try
ADOQueryCmd.Connection.BeginTrans;
if Trim(FDataID) = '' then
begin
if GetLSNo(ADOQueryCmd, MaxId, 'R', 'Knit_Cloth_Inspect_Rule', 4, 1) = False then
begin
Result := False;
ADOQueryCmd.Connection.RollbackTrans;
Application.MessageBox(<><C8A1><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ʧ<EFBFBD>ܣ<EFBFBD>', '<27><>ʾ', 0);
Exit;
end;
end
else
begin
MaxId := Trim(FDataID);
end;
with ADOQueryCmd do
begin
Close;
SQL.Clear;
sql.Add('select * from Knit_Cloth_Inspect_Rule where RuleID=''' + Trim(FDataID) + '''');
Open;
end;
with ADOQueryCmd do
begin
if Trim(FDataID) = '' then
begin
Append;
FieldByName('Filler').Value := Trim(DName);
end
else
begin
Edit;
FieldByName('Editer').Value := Trim(DName);
FieldByName('Edittime').Value := SGetServerDateTime(ADOQueryTemp);
end;
FieldByName('RuleID').Value := Trim(MaxId);
RTSetsavedata(ADOQueryCmd, 'Knit_Cloth_Inspect_Rule', ScrollBox1, 2);
Post;
end;
ADOQueryCmd.Connection.CommitTrans;
FCCID := Trim(MaxSubId);
Result := True;
except
Result := false;
ADOQueryCmd.Connection.RollbackTrans;
Application.MessageBox('<27><><EFBFBD><EFBFBD><EFBFBD>쳣!', '<27><>ʾ', 0);
end;
end;
procedure TfrmKnitInspSet.ToolButton1Click(Sender: TObject);
begin
if CDS_Label.IsEmpty then
exit;
LabVolume.Text := trim(CDS_Label.fieldbyname('labelCaption').asstring);
end;
procedure TfrmKnitInspSet.ToolButton2Click(Sender: TObject);
begin
if CDS_Label.IsEmpty then
exit;
LabPackage.Text := trim(CDS_Label.fieldbyname('labelCaption').asstring);
end;
procedure TfrmKnitInspSet.ToolButton3Click(Sender: TObject);
begin
if SaveData() then
begin
Application.MessageBox('<27><><EFBFBD><EFBFBD><EFBFBD>ɹ<EFBFBD>!', '<27><>ʾ', 0);
end;
end;
procedure TfrmKnitInspSet.ToolButton4Click(Sender: TObject);
var
fFileName, fPrintFile: string;
MLabelID, MLabelCaption: string;
begin
if CDS_Label.IsEmpty then
exit;
MLabelID := TRIM(CDS_Label.fieldByName('LabelID').asString);
MLabelCaption := TRIM(CDS_Label.fieldByName('LabelCaption').asString);
ExportFtErpFile(MLabelCaption + '.rmf', ADOQueryTemp);
fPrintFile := ExtractFilePath(Application.ExeName) + 'report\' + MLabelCaption + '.rmf';
if not FileExists(fPrintFile) then
CopyFile(PChar(ExtractFilePath(Application.ExeName) + 'Report\ģ<><C4A3><EFBFBD><EFBFBD>ǩ.rmf'), PChar(fPrintFile), False);
with RMLabel do
begin
RMLabel.Clear;
RMDB_Label.DataSet := nil;
Dictionary.FieldAliases.Clear;
Dictionary.FieldAliases['RMDB_Label'] := '<27><>ǩ<EFBFBD><C7A9><EFBFBD><EFBFBD>';
RMDB_Label.DataSet := ADO_1;
LoadFromFile(fPrintFile);
application.ProcessMessages;
DesignReport();
// RMLabel.SaveToFile(fPrintFile);
SaveLabel(MLabelID);
ExportToFtErp(fPrintFile, ADOQueryCmd);
end;
end;
procedure TfrmKnitInspSet.ToolButton5Click(Sender: TObject);
begin
try
with ADOQueryCmd do
begin
close;
sql.clear;
sql.Add(' update RT_FileUpdate set FileEditDate=GETDATE() ');
sql.Add(',LastEditer=' + quotedstr(dname));
sql.Add(',Files=(SELECT top 1 Files from RT_FileUpdate where FileName=' + quotedstr(trim(CDS_Label.fieldbyname('labelCaption').asstring) + '.rmf') + ') ');
sql.Add('where FileName='<><C4A3><EFBFBD><EFBFBD>ǩ.rmf'' ');
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(<><C4A3><EFBFBD><EFBFBD>ǩ<EFBFBD>޸<EFBFBD>')));
sql.Add(',' + quotedstr(trim('<27><>ǩ<EFBFBD><C7A9><EFBFBD>ƣ<EFBFBD>' + trim(CDS_Label.fieldByName('labelCaption').asString))));
sql.Add(',' + quotedstr(trim('<27>ɹ<EFBFBD>')));
sql.Add(')');
execSql;
end;
DeleteFile(PChar(ExtractFilePath(Application.ExeName) + 'Report\ģ<><C4A3><EFBFBD><EFBFBD>ǩ.rmf'));
ExportFtErpFile(<><C4A3><EFBFBD><EFBFBD>ǩ.rmf', ADOQueryTemp);
application.MessageBox('<27><><EFBFBD>óɹ<C3B3>!', '<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ϣ', 0);
except
application.MessageBox(<><C9BE>ʧ<EFBFBD><CAA7>!', '<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ϣ', 0);
end;
end;
procedure TfrmKnitInspSet.TupdClick(Sender: TObject);
begin
if CDS_Label.IsEmpty then
exit;
try
frmLabelInput := TfrmLabelInput.create(self);
with frmLabelInput do
begin
fLabelId := CDS_Label.fieldByName('LabelId').AsString;
if showModal = 1 then
begin
InitLabel();
end;
end;
finally
frmLabelInput.Free;
end;
end;
procedure TfrmKnitInspSet.TVLabelCellClick(Sender: TcxCustomGridTableView; ACellViewInfo: TcxGridTableDataCellViewInfo; AButton: TMouseButton; AShift: TShiftState; var AHandled: Boolean);
var
fPrintFile: string;
begin
if CDS_Label.IsEmpty then
exit;
ExportFtErpFile(TRIM(CDS_Label.fieldByName('LabelCaption').asString) + '.rmf', ADOQueryTemp);
fPrintFile := ExtractFilePath(Application.ExeName) + 'Report\' + CDS_Label.fieldbyname('LabelCaption').AsString + '.rmf';
if not FileExists(fPrintFile) then
CopyFile(PChar(ExtractFilePath(Application.ExeName) + 'Report\ģ<><C4A3><EFBFBD><EFBFBD>ǩ.rmf'), PChar(fPrintFile), False);
with RMLabel do
begin
RMLabel.LoadFromFile(fPrintFile);
Preview := RMPreview3;
ShowReport;
end;
end;
end.