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

1112 lines
34 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_DyePlanCardInput;
interface
uses
Windows, Messages, SysUtils, 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, cxPC, dxSkinOffice2013White, dxSkinWXI,
dxScrollbarAnnotations, RM_Common, RM_Class, RM_GridReport, RM_Dataset;
type
TfrmDyePlanCardInput = class(TfrmBaseInput)
CDS_1: TClientDataSet;
DS_1: TDataSource;
ADO_Car: TADOQuery;
ADOQueryCmd: TADOQuery;
ADOQueryTmp: TADOQuery;
GPM_1: TcxGridPopupMenu;
Panel3: TPanel;
Panel4: TPanel;
cxGrid1: TcxGrid;
TV1: TcxGridDBTableView;
V1SSel: TcxGridDBColumn;
V1Column1: TcxGridDBColumn;
V1Column5: TcxGridDBColumn;
TV1Column1: TcxGridDBColumn;
TV1Column5: TcxGridDBColumn;
TV1Column6: TcxGridDBColumn;
TV1Column7: TcxGridDBColumn;
V1Column2: TcxGridDBColumn;
V1Column3: TcxGridDBColumn;
TV1Column4: TcxGridDBColumn;
TV1Column3: TcxGridDBColumn;
V1Column6: TcxGridDBColumn;
V1Column4: TcxGridDBColumn;
TV1Column2: TcxGridDBColumn;
cxGrid1Level1: TcxGridLevel;
ToolBar1: TToolBar;
ToolButton4: TToolButton;
ADOQueryMain: TADOQuery;
PM_1: TPopupMenu;
MenuItem1: TMenuItem;
MenuItem2: TMenuItem;
TV1Column10: TcxGridDBColumn;
ToolButton5: TToolButton;
ToolButton1: TToolButton;
ToolButton2: TToolButton;
ToolButton3: TToolButton;
TV1Column12: TcxGridDBColumn;
TV1Column13: TcxGridDBColumn;
TV1Column14: TcxGridDBColumn;
TV1Column15: TcxGridDBColumn;
TV1Column16: TcxGridDBColumn;
TV1Column17: TcxGridDBColumn;
TV1Column18: TcxGridDBColumn;
TV1Column19: TcxGridDBColumn;
ADO_Order: TADOQuery;
CDS_Color: TClientDataSet;
pnlOrder: TPanel;
Label23: TLabel;
Label4: TLabel;
Label9: TLabel;
Label11: TLabel;
Label10: TLabel;
Label24: TLabel;
OrderNo: TBtnEditA;
C_Width: TEdit;
C_GramWeight: TEdit;
C_COLORNO: TEdit;
C_Color: TComboBox;
OrdQty: TEdit;
OrdUnit: TEdit;
pnlkpkk: TPanel;
Label1: TLabel;
Label7: TLabel;
Label15: TLabel;
Label16: TLabel;
Label17: TLabel;
PCTime: TDateTimePicker;
carnum: TcxCurrencyEdit;
PCPiece: TcxCurrencyEdit;
PCType: TComboBox;
PCQty: TEdit;
Button2: TButton;
C_ColorM: TEdit;
Label2: TLabel;
BuyConNo: TEdit;
C_StyleNo: TEdit;
Label3: TLabel;
TV1Column8: TcxGridDBColumn;
TV1Column9: TcxGridDBColumn;
Label5: TLabel;
crop: TEdit;
Label6: TLabel;
ToolButton6: TToolButton;
ToolButton7: TToolButton;
ADOTmp: TADOQuery;
sewing: TMemo;
Label8: TLabel;
C_BZmanner: TEdit;
TV1Column11: TcxGridDBColumn;
Label12: TLabel;
C_CLName1: TEdit;
C_CLwrap1: TEdit;
Label13: TLabel;
TV1Column20: TcxGridDBColumn;
TV1Column21: TcxGridDBColumn;
Label14: TLabel;
Label18: TLabel;
C_CLName: TEdit;
C_CLwrap: TEdit;
Label19: TLabel;
Processprice: TEdit;
Label20: TLabel;
C_CPCode: TEdit;
Label21: TLabel;
C_CJSIZE: TEdit;
TV1Column22: TcxGridDBColumn;
TV1Column23: TcxGridDBColumn;
RMDBmain: TRMDBDataSet;
RM1: TRMGridReport;
cds_3: TClientDataSet;
ds_3: TDataSource;
procedure FormDestroy(Sender: TObject);
procedure FormClose(Sender: TObject; var Action: TCloseAction);
procedure FormCreate(Sender: TObject);
procedure FormShow(Sender: TObject);
procedure ToolButton4Click(Sender: TObject);
procedure MenuItem1Click(Sender: TObject);
procedure MenuItem2Click(Sender: TObject);
procedure ToolButton5Click(Sender: TObject);
procedure Button2Click(Sender: TObject);
procedure ToolButton1Click(Sender: TObject);
procedure ToolButton3Click(Sender: TObject);
procedure ToolButton2Click(Sender: TObject);
procedure PCIDKeyPress(Sender: TObject; var Key: Char);
procedure Button1Click(Sender: TObject);
procedure TV3DblClick(Sender: TObject);
procedure OrderNoBtnClick(Sender: TObject);
procedure C_ColorChange(Sender: TObject);
procedure TV3Column1PropertiesEditValueChanged(Sender: TObject);
procedure PCQtyChange(Sender: TObject);
procedure ToolButton6Click(Sender: TObject);
procedure ToolButton7Click(Sender: TObject);
private
FMainID, Fsubid: string;
FRollNum: integer;
FGC_BatchNo, FGC_Piece, FGC_STKID, FGC_Position: string;
FFromCoNo, FFromCoName, FSaleser, FC_Name, FC_Code, FC_Pattern: string;
procedure InitCard();
procedure InitOrder();
procedure InitGreyClothStk();
function GetCard(): Boolean;
procedure InitRepairCard(PPCID: string);
procedure PrintCar(MPCID: string);
{ Private declarations }
public
FWorkshop, FPCIDS: string;
{ Public declarations }
end;
var
frmDyePlanCardInput: TfrmDyePlanCardInput;
implementation
uses
U_DataLink, U_ZDYHelp, U_RTFun, U_DyePlanForCardSel, U_DyeCardGlideEdit;
{$R *.dfm}
procedure TfrmDyePlanCardInput.PrintCar(MPCID: string);
var
fPrintFile: string;
begin
with ADOTmp do
begin
Close;
Filtered := False;
sql.Clear;
sql.Add('exec P_Trade_Card_Prt1 ');
sql.Add(' @Filtration=' + quotedstr(trim(CDS_1.fieldbyname('PCID').AsString)));
Open;
end;
SCreateCDS(ADOTmp, CDS_3);
SInitCDSData(ADOTmp, CDS_3);
ExportFtErpFile('<27><><EFBFBD><EFBFBD>ǩ.rmf', ADOTmp);
fPrintFile := ExtractFilePath(Application.ExeName) + 'Report\<5C><><EFBFBD><EFBFBD>ǩ.rmf';
if FileExists(fPrintFile) then
begin
RM1.LoadFromFile(fPrintFile);
RMVariables['FILLTIME'] := CDS_3.FieldByName('FILLTIME').AsString;
RM1.PrintReport;
sleep(200);
// if canshu1 <> '<27><>ѯ' then
// begin
// with ADOQueryCmd do
// begin
// close;
// sql.Clear;
// sql.Add('update Dye_Plan_Card SET status=''9'' ');
// sql.Add('where PCID=' + quotedstr(trim(CDS_1.fieldbyname('PCID').AsString)));
// execsql;
// end;
// end;
end
else
Application.MessageBox(PChar('û<><C3BB><EFBFBD>ҵ<EFBFBD>' + trim(fPrintFile)), '<27><>ʾ<EFBFBD><CABE>Ϣ', 0);
end;
function TfrmDyePlanCardInput.GetCard(): Boolean;
var
MCustNo, MC_Name: string;
begin
// try
// CDS_3.DisableControls;
// if CDS_3.IsEmpty then
// raise Exception.Create('<27><>ѡ<EFBFBD><D1A1><EFBFBD><EFBFBD><EFBFBD>̿<EFBFBD><CCBF><EFBFBD>');
// CDS_3.First;
// while not CDS_3.eof do
// begin
// if Trim(MCustNo) = '' then
// begin
// MCustNo := trim(CDS_3.FieldByName('CustNo').AsString);
// MC_Name := trim(CDS_3.FieldByName('C_Name').AsString);
// end
// else
// begin
// if MCustNo <> trim(CDS_3.FieldByName('CustNo').AsString) then
// raise Exception.Create('<27><><EFBFBD><EFBFBD>ѡ<EFBFBD><D1A1><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ͻ<EFBFBD><CDBB><EFBFBD>');
// if MC_Name <> trim(CDS_3.FieldByName('C_Name').AsString) then
// raise Exception.Create('<27><><EFBFBD><EFBFBD>ѡ<EFBFBD><D1A1><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ʒ<EFBFBD><C6B7>');
// end;
// if CDS_3.FieldByName('MvPiece').AsFloat > CDS_3.FieldByName('PSC_StkPiece').AsFloat then
// raise Exception.Create('<27><><EFBFBD><EFBFBD>ƥ<EFBFBD><C6A5><EFBFBD><EFBFBD><EFBFBD>ޣ<EFBFBD>');
// if CDS_3.FieldByName('MvQty').AsFloat > CDS_3.FieldByName('PSC_StkQty').AsFloat then
// raise Exception.Create('<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ޣ<EFBFBD>');
// CDS_3.Next;
// end;
// CDS_3.EnableControls;
// Result := True;
// except
// Result := false;
// CDS_3.EnableControls;
// application.MessageBox(PChar(Exception(ExceptObject).Message), '<27><>ʾ<EFBFBD><CABE>Ϣ', 0);
// end;
end;
procedure TfrmDyePlanCardInput.InitOrder();
var
fsj: string;
begin
with Ado_Order do
begin
close;
sql.Clear;
sql.Add('select A.*,B.*');
sql.Add('from Trade_Plan_sub A ');
sql.Add('inner join Trade_Plan_Main B on B.MainID=A.mainID ');
sql.Add('where A.MainID=''' + trim(FMainID) + ''' ');
open;
end;
SCreateCDS(Ado_Order, CDS_Color);
SInitCDSData(Ado_Order, CDS_Color);
if not Ado_Order.IsEmpty then
begin
fsj := 'select distinct(C_Color) name from Trade_Plan_sub where mainid= ' + QuotedStr(Trim(FMainID));
SInitComBoxBySql(ADOQueryTmp, C_COLOR, False, fsj);
SCSHData(Ado_Order, pnlOrder, 2);
// C_ColorM.text := Trim(Ado_Order.FieldByName('C_Color').AsString);
FC_Name := Trim(Ado_Order.FieldByName('C_Name').AsString);
FC_Code := Trim(Ado_Order.FieldByName('C_Code').AsString);
FFromCoNo := Trim(Ado_Order.FieldByName('CustNo').AsString);
FFromCoName := Trim(Ado_Order.FieldByName('CustName').AsString);
// FGC_BatchNo := Trim(Ado_Order.FieldByName('GC_BatchNo').AsString);
// FGC_Piece := Trim(Ado_Order.FieldByName('GC_Piece').AsString);
// FGC_STKID := Trim(Ado_Order.FieldByName('GC_STKID').AsString);
// FGC_Position := Trim(Ado_Order.FieldByName('GC_Position').AsString);
// FRollNum :=Trim(Ado_Order.FieldByName('').AsString);
end;
end;
procedure TfrmDyePlanCardInput.InitRepairCard(PPCID: string);
begin
// with ADOQueryTmp do
// begin
// close;
// sql.Clear;
// sql.Add('select A.*');
// sql.Add(',GlideList=[dbo].[F_Trade_Card_GlideList](A.PCID) ');
// sql.Add(',MvPiece=PSC_StkPiece,MvQty=PSC_StkQty ');
// sql.Add('from Trade_Plan_Card A ');
// if TRIM(PPCID) = '' then
// sql.Add('where 1=2 ')
// else
// sql.Add('where PCID= ' + Quotedstr(trim(PPCID)));
//
// open;
// end;
// if TRIM(PPCID) = '' then
// begin
// SCreateCDS(ADOQueryTmp, CDS_3);
// end
// else
// begin
// SInitCDSData(ADOQueryTmp, CDS_3);
// end;
end;
procedure TfrmDyePlanCardInput.InitGreyClothStk();
begin
// try
// ADOQueryMain.DisableControls;
// with ADOQueryMain do
// begin
// Filtered := False;
// Close;
// sql.Clear;
// sql.Add(' select A.* ');
// sql.Add(' from BS_Cloth_IO A where isnull(STKName,'''')=''Ⱦɫ<C8BE><C9AB><EFBFBD><EFBFBD>'' ');
// SQL.Add(' and A.IOFlag=''<27><><EFBFBD><EFBFBD>'' ');
// SQL.Add(' and EXISTS(select * from [dbo].[F_Tool_SplitString](' + quotedstr(FGC_STKID) + ','';'' ) X where X.RTValue=A.StkId) ');
//// ShowMessage(sql.Text);
// Open;
// end;
// SCreateCDS(ADOQueryMain, CDS_2);
// SInitCDSData(ADOQueryMain, CDS_2);
// finally
// ADOQueryMain.EnableControls;
// end;
end;
procedure TfrmDyePlanCardInput.MenuItem1Click(Sender: TObject);
begin
SelOKNo(CDS_1, True);
end;
procedure TfrmDyePlanCardInput.MenuItem2Click(Sender: TObject);
begin
SelOKNo(CDS_1, False);
end;
procedure TfrmDyePlanCardInput.OrderNoBtnClick(Sender: TObject);
begin
frmProductOrderListSel := TfrmProductOrderListSel.create(self);
with frmProductOrderListSel do
begin
FWorkshop := self.FWorkshop;
if ShowModal = 1 then
begin
fmainID := Order_Main.fieldbyname('mainID').asstring;
// InitOrder();
// InitGreyClothStk();
// InitCard();
// initGlide();
self.OrderNo.text := Order_Main.fieldbyname('OrderNo').asstring;
self.C_Width.text := Order_Main.fieldbyname('C_Width').asstring;
self.Processprice.text := Order_Main.fieldbyname('Processprice').asstring;
self.C_GramWeight.text := Order_Main.fieldbyname('C_GramWeight').asstring;
self.C_ColorM.text := Order_Main.fieldbyname('C_Color').asstring;
self.C_COLORNO.text := Order_Main.fieldbyname('C_COLORNO').asstring;
self.C_CJSIZE.text := Order_Main.fieldbyname('C_CJSIZE').asstring;
self.OrdQty.text := Order_Main.fieldbyname('OrdQty').asstring;
self.OrdUnit.text := Order_Main.fieldbyname('OrdUnit').asstring;
self.BuyConNo.text := Order_Main.fieldbyname('BuyConNo').asstring;
FC_Name := Trim(Order_Main.FieldByName('C_Name').AsString);
FC_Code := Trim(Order_Main.FieldByName('C_Code').AsString);
FC_Pattern := Trim(Order_Main.FieldByName('C_Pattern').AsString);
FFromCoNo := Trim(Order_Main.FieldByName('CustNo').AsString);
FFromCoName := Trim(Order_Main.FieldByName('CustName').AsString);
Fsubid := Trim(Order_Main.FieldByName('subid').AsString);
self.C_StyleNo.text := Trim(Order_Main.FieldByName('C_StyleNo').AsString);
// self.crop.text := Trim(Order_Main.FieldByName('C_CJsize').AsString);
// self.sewing.text := Trim(Order_Main.FieldByName('C_description').AsString);
// self.C_BZmanner.text := Trim(Order_Main.FieldByName('C_wrap').AsString);
self.C_CLName.text := Trim(Order_Main.FieldByName('C_Name').AsString);
self.C_CLwrap.text := Trim(Order_Main.FieldByName('C_Spec').AsString);
self.C_CPCode.text := Trim(Order_Main.FieldByName('C_Code').AsString);
// self.PCQty.text := Trim(Order_Main.FieldByName('C_MKSL').AsString);
// self.PCQty.text := Trim(Order_Main.FieldByName('OrdQty').AsString);
// self.carnum.text := '1';
// self.carnum.text := floattostr(strtofloat(Order_Main.fieldbyname('OrdQty').asstring) / strtofloat(Trim(Order_Main.FieldByName('C_MKSL').asstring)));
end;
free;
end;
end;
procedure TfrmDyePlanCardInput.PCIDKeyPress(Sender: TObject; var Key: Char);
begin
// if Key = #13 then
// begin
// if Trim(PCID.Text) = '' then
// exit;
// InitRepairCard(PCID.Text);
// PCID.Text := '';
// end;
end;
procedure TfrmDyePlanCardInput.PCQtyChange(Sender: TObject);
begin
// inherited;
end;
procedure TfrmDyePlanCardInput.InitCard();
begin
with Ado_car do
begin
close;
sql.Clear;
sql.Add('select A.*');
sql.Add(',GlideList=[dbo].[F_Trade_Card_GlideList](A.PCID) ');
sql.Add('from Trade_Plan_Card A ');
// sql.Add('inner join Dye_Plan_Glide B on B.PCID=A.PCID');
sql.Add('where EXISTS(select X.RTValue from [dbo].[F_Tool_SplitString](' + Quotedstr(trim(FPCIDS)) + ', '';'' ) X where X.RTValue=A.PCID ) ');
open;
end;
SCreateCDS(Ado_car, CDS_1);
SInitCDSData(Ado_car, CDS_1);
with ADOQueryTmp do
begin
close;
sql.Clear;
sql.Add('select A.*,B.*,C.*');
sql.Add(',GlideList=[dbo].[F_Trade_Card_GlideList](A.PCID) ');
sql.Add('from Trade_Plan_Card A ');
sql.Add('left join Trade_Plan_sub B on B.subID=A.subID');
sql.Add('left join Trade_Plan_Main C on C.mainID=A.mainID');
// sql.Add('inner join Dye_Plan_Glide B on B.PCID=A.PCID');
sql.Add('where EXISTS(select X.RTValue from [dbo].[F_Tool_SplitString](' + Quotedstr(trim(FPCIDS)) + ', '';'' ) X where X.RTValue=A.PCID ) ');
open;
end;
C_ColorM.text := ADOQueryTmp.FieldByName('C_Color').AsString;
SCSHData(ADOQueryTmp, pnlOrder, 2);
end;
procedure TfrmDyePlanCardInput.FormDestroy(Sender: TObject);
begin
inherited;
frmDyePlanCardInput := nil;
end;
procedure TfrmDyePlanCardInput.Button1Click(Sender: TObject);
var
maxId: string;
begin
// PCID.SetFocus;
// if not GetCard() then
// Exit;
//
// if GetLSNo(ADOQueryCmd, maxId, 'CZ', 'Trade_Plan_Card', 3, 1) = False then
// begin
// Application.MessageBox('ȡ<><C8A1><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ʧ<EFBFBD><CAA7>!', '<27><>ʾ', 0);
// Exit;
// end;
// FPCIDS := FPCIDS + maxId + ';';
// try
// ADOQueryCmd.Connection.BeginTrans;
// CDS_3.DisableConstraints;
//
// with ADOQueryCmd do
// begin
// Close;
// Sql.Clear;
// Sql.Add('select * from Trade_Plan_Card A where 1=2');
// Open;
// Append;
// FieldByName('Filler').Value := trim(DName);
// FieldByName('Workshop').Value := trim(FWorkshop);
// FieldByName('PCType').Value := trim(RePCType.Text);
// FieldByName('PCID').Value := trim(maxId);
// FieldByName('PCTime').Value := formatdateTime('yyyy-MM-dd', now());
// FieldByName('GC_BatchNo').Value := '';
// FieldByName('GC_Piece').Value := '';
// FieldByName('GC_STKID').Value := '';
// FieldByName('GC_Position').Value := '';
// FieldByName('C_Name').Value := trim(CDS_3.FieldByName('C_Name').AsString);
// FieldByName('CustNo').Value := trim(CDS_3.FieldByName('CustNo').AsString);
// FieldByName('CustName').Value := trim(CDS_3.FieldByName('CustName').AsString);
// FieldByName('MainId').Value := trim(CDS_3.FieldByName('MainId').AsString);
// FieldByName('SubId').Value := trim(CDS_3.FieldByName('SubId').AsString);
// FieldByName('C_GramWeight').Value := trim(Re_GramWeight.Text);
// FieldByName('C_Width').Value := trim(Re_Width.Text);
// FieldByName('C_Color').Value := trim(Re_Color.Text);
// FieldByName('PCUnit').Value := trim(ReUnit.Text);
// FieldByName('C_ColorNo').Value := trim(Re_ColorNo.Text);
// FieldByName('PCPiece').Value := 0;
// FieldByName('PCQty').Value := 0;
// post;
// end;
//
// with CDS_3 do
// begin
// first;
// while not Eof do
// begin
// with ADOQueryCmd do
// begin
// Close;
// Sql.Clear;
// Sql.Add('select * from Trade_Plan_Card_Move A where 1=2');
// Open;
// Append;
// FieldByName('Filler').Value := trim(DName);
// FieldByName('FromID').Value := trim(CDS_3.FieldByName('PCID').AsString);
// FieldByName('ToID').Value := maxId;
// FieldByName('MvPiece').Value := CDS_3.FieldByName('MvPiece').AsFloat;
// FieldByName('MvQty').Value := CDS_3.FieldByName('MvQty').AsFloat;
// post;
// end;
// Next;
// end;
// end;
//
// with ADOQueryCmd do
// begin
// Close;
// Sql.Clear;
// Sql.Add('exec P_Trade_Card_Move ');
// Sql.Add('@PCID=' + quotedstr(trim(maxId)));
// Open;
// end;
// if ADOQueryCmd.FieldByName('intReturn').AsInteger = -1 then
// begin
// raise Exception.Create(pchar(trim(ADOQueryCmd.FieldByName('ShowMsg').AsString)));
// end;
// ADOQueryCmd.Connection.CommitTrans;
// CDS_3.EnableConstraints;
// except
// ADOQueryCmd.Connection.RollbackTrans;
// CDS_3.EnableConstraints;
// application.MessageBox(PChar(Exception(ExceptObject).Message), '<27><>ʾ<EFBFBD><CABE>Ϣ', 0);
// end;
//
// InitCard();
// InitRepairCard('');
end;
procedure TfrmDyePlanCardInput.Button2Click(Sender: TObject);
var
i, k, fhxInt, x: integer;
maxId, sqlstr, MaxmaxId: string;
begin
// if trim(C_Color.Text) = '' then
// begin
// application.MessageBox('<27><>ɫ<EFBFBD><C9AB><EFBFBD><EFBFBD>Ϊ<EFBFBD>գ<EFBFBD>', '<27><>ʾ<EFBFBD><CABE>Ϣ', MB_ICONERROR);
// exit;
// end;
if trim(C_ColorM.Text) = '' then
begin
application.MessageBox('<27><>ɫ<EFBFBD><C9AB><EFBFBD><EFBFBD>Ϊ<EFBFBD>գ<EFBFBD>', '<27><>ʾ<EFBFBD><CABE>Ϣ', MB_ICONERROR);
exit;
end;
if trim(C_Width.Text) = '' then
begin
application.MessageBox('<27>ŷ<EFBFBD><C5B7><EFBFBD><EFBFBD><EFBFBD>Ϊ<EFBFBD>գ<EFBFBD>', '<27><>ʾ<EFBFBD><CABE>Ϣ', MB_ICONERROR);
exit;
end;
// if trim(C_GramWeight.Text) = '' then
// begin
// application.MessageBox('<27><><EFBFBD>ز<EFBFBD><D8B2><EFBFBD>Ϊ<EFBFBD>գ<EFBFBD>', '<27><>ʾ<EFBFBD><CABE>Ϣ', MB_ICONERROR);
// exit;
// end;
if (StrToFloatDef(PCPiece.Text, 0) + StrToFloatDef(PCQty.Text, 0)) = 0 then
begin
application.MessageBox('<27><><EFBFBD><EFBFBD>ƥ<EFBFBD><C6A5><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ܶ<EFBFBD>Ϊ<EFBFBD>㣡', '<27><>ʾ<EFBFBD><CABE>Ϣ', MB_ICONERROR);
exit;
end;
if strtointdef(trim(carNum.text), 0) <= 1 then
k := 1
else
k := strtointdef(trim(carNum.text), 0);
// CDS_Color.Locate('C_Color', C_Color.Text, []);
// if GetLSNo(ADOQueryCmd, maxId, 'CZ', 'Trade_Plan_Card', 3, 1) = False then
// begin
// Application.MessageBox('ȡ<><C8A1><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ʧ<EFBFBD><CAA7>!', '<27><>ʾ', 0);
// Exit;
// end;
CDS_1.Last;
sqlstr := '';
// x := 1;
for i := 1 to k do
begin
if GetLSNo(ADOQueryCmd, maxId, 'CZ', 'Trade_Plan_Card', 5, 1) = False then
begin
Application.MessageBox('ȡ<><C8A1><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ʧ<EFBFBD><CAA7>!', '<27><>ʾ', 0);
Exit;
end;
FPCIDS := FPCIDS + maxId + ';';
// MaxmaxId := inttostr(strtoint(Trim(maxId)) + x);
sqlstr := sqlstr + 'insert into Trade_Plan_Card(KUNNO,OrderNo,SubId,Mainid,Filler,Workshop,PCType,PCID,PCTime,GC_BatchNo,GC_Piece,' + 'GC_STKID,GC_Position,CustNo,CustName,Saleser,C_Name,C_Code,C_Pattern,C_GramWeight,C_Width,C_Color,PCUnit,C_ColorNo,BuyConNo,C_StyleNo,PCPiece,PCQty,carnum,C_CLName,C_CLwrap,C_CPCode,Processprice,crop) ';
sqlstr := sqlstr + ' values( ';
sqlstr := sqlstr + ' cast( ''' + trim(INTTOSTR(i)) + '''as INT), ';
sqlstr := sqlstr + ' ''' + Trim(OrderNo.Text) + ''', ';
sqlstr := sqlstr + ' ''' + Trim(Fsubid) + ''', ';
sqlstr := sqlstr + ' ''' + Trim(FMainid) + ''', ';
sqlstr := sqlstr + ' ''' + trim(DName) + ''', ';
sqlstr := sqlstr + ' ''' + trim(FWorkshop) + ''', ';
sqlstr := sqlstr + ' ''' + trim(PCType.Text) + ''', ';
sqlstr := sqlstr + ' ''' + trim(maxId) + ''', ';
sqlstr := sqlstr + ' ''' + formatdateTime('yyyy-MM-dd', PCTime.DateTime) + ''', ';
sqlstr := sqlstr + ' ''' + trim(FGC_BatchNo) + ''', ';
sqlstr := sqlstr + ' ''' + trim(FGC_Piece) + ''', ';
sqlstr := sqlstr + ' ''' + trim(FGC_STKID) + ''', ';
sqlstr := sqlstr + ' ''' + trim(FGC_Position) + ''', ';
sqlstr := sqlstr + ' ''' + trim(FFromCoNo) + ''', ';
sqlstr := sqlstr + ' ''' + trim(FFromCoName) + ''', ';
sqlstr := sqlstr + ' ''' + trim(FSaleser) + ''', ';
sqlstr := sqlstr + ' ''' + trim(FC_Name) + ''', ';
sqlstr := sqlstr + ' ''' + trim(FC_Code) + ''', ';
sqlstr := sqlstr + ' ''' + trim(FC_Pattern) + ''', ';
sqlstr := sqlstr + ' ''' + trim(C_GramWeight.Text) + ''', ';
sqlstr := sqlstr + ' ''' + trim(C_Width.Text) + ''', ';
sqlstr := sqlstr + ' ''' + trim(C_ColorM.Text) + ''', ';
sqlstr := sqlstr + ' ''' + trim(OrdUnit.Text) + ''', ';
sqlstr := sqlstr + ' ''' + trim(C_ColorNo.Text) + ''', ';
sqlstr := sqlstr + ' ''' + trim(BuyConNo.Text) + ''', ';
sqlstr := sqlstr + ' ''' + trim(C_StyleNo.Text) + ''', ';
sqlstr := sqlstr + ' cast( ''' + trim(PCpiece.Text) + '''as float), ';
sqlstr := sqlstr + ' cast(''' + trim(PCQty.Text) + '''as float), ';
// sqlstr := sqlstr + ' ''' + trim(crop.Text) + ''', ';
// sqlstr := sqlstr + ' ''' + trim(sewing.Text) + ''', ';
// sqlstr := sqlstr + ' ''' + trim(C_BZmanner.Text) + ''' ,';
sqlstr := sqlstr + ' ''' + trim(carnum.Text) + ''',';
sqlstr := sqlstr + ' ''' + trim(C_CLName.Text) + ''', ';
sqlstr := sqlstr + ' ''' + trim(C_CLwrap.Text) + ''' ,';
sqlstr := sqlstr + ' ''' + trim(C_CPCode.Text) + ''' ,';
sqlstr := sqlstr + ' ''' + trim(Processprice.Text) + ''' ,';
sqlstr := sqlstr + ' ''' + trim(C_CJSIZE.Text) + ''' ';
sqlstr := sqlstr + ' ) ';
// x := x + 1;
end;
with ADOQueryCmd do
begin
close;
sql.Clear;
sql.Add(sqlstr);
// showmessage(sql.Text);
execsql;
end;
with Ado_car do
begin
close;
sql.Clear;
sql.Add('select A.*');
sql.Add(',GlideList=[dbo].[F_Trade_Card_GlideList](A.PCID) ');
sql.Add('from Trade_Plan_Card A ');
// sql.Add('inner join Dye_Plan_Glide B on B.PCID=A.PCID');
sql.Add('where EXISTS(select X.RTValue from [dbo].[F_Tool_SplitString](' + Quotedstr(trim(FPCIDS)) + ', '';'' ) X where X.RTValue=A.PCID ) ');
open;
end;
SCreateCDS(Ado_car, CDS_1);
SInitCDSData(Ado_car, CDS_1);
printcar(FPCIDS);
// InitCard();
InitGreyClothStk();
// for i := 1 to k do
// begin
// if GetLSNo(ADOQueryCmd, maxId, 'CZ', 'Trade_Plan_Card', 3, 1) = False then
// begin
// Application.MessageBox('ȡ<><C8A1><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ʧ<EFBFBD><CAA7>!', '<27><>ʾ', 0);
// Exit;
// end;
// FPCIDS := FPCIDS + maxId + ';';
// try
// ADOQueryCmd.Connection.BeginTrans;
// with ADOQueryCmd do
// begin
// Close;
// Sql.Clear;
// Sql.Add('select * from Trade_Plan_Card A where 1=2');
// Open;
// Append;
// FieldByName('OrderNo').Value := OrderNo.Text;
//// FieldByName('SubId').Value := CDS_Color.FieldByName('SubId').Value;
// FieldByName('SubId').Value := Fsubid;
// FieldByName('Mainid').Value := FMainid;
// FieldByName('Filler').Value := trim(DName);
// FieldByName('Workshop').Value := trim(FWorkshop);
// FieldByName('PCType').Value := trim(PCType.Text);
// FieldByName('PCID').Value := trim(maxId);
// FieldByName('PCTime').Value := formatdateTime('yyyy-MM-dd', PCTime.DateTime);
// FieldByName('GC_BatchNo').Value := trim(FGC_BatchNo);
// FieldByName('GC_Piece').Value := trim(FGC_Piece);
// FieldByName('GC_STKID').Value := trim(FGC_STKID);
// FieldByName('GC_Position').Value := trim(FGC_Position);
// FieldByName('CustNo').Value := trim(FFromCoNo);
// FieldByName('CustName').Value := trim(FFromCoName);
// FieldByName('Saleser').Value := trim(FSaleser);
// FieldByName('C_Name').Value := trim(FC_Name);
// FieldByName('C_GramWeight').Value := trim(C_GramWeight.Text);
// FieldByName('C_Width').Value := trim(C_Width.Text);
//// FieldByName('C_Color').Value := trim(C_Color.Text);
// FieldByName('C_Color').Value := trim(C_ColorM.Text);
// FieldByName('PCUnit').Value := trim(OrdUnit.Text);
// FieldByName('C_ColorNo').Value := trim(C_ColorNo.Text);
// FieldByName('PCPiece').Value := StrtoIntDef(PCPiece.Text, 0);
// FieldByName('PCQty').Value := StrtoFloatDef(PCQty.Text, 0);
// post;
// end;
//
// ADOQueryCmd.Connection.CommitTrans;
// except
// ADOQueryCmd.Connection.RollbackTrans;
// application.MessageBox(PChar(Exception(ExceptObject).Message), '<27><>ʾ<EFBFBD><CABE>Ϣ', 0);
// end;
// end;
// InitCard();
// InitGreyClothStk();
end;
procedure TfrmDyePlanCardInput.C_ColorChange(Sender: TObject);
begin
CDS_Color.Locate('C_Color', C_Color.Text, []);
C_COLOR.Text := CDS_Color.FieldByName('C_COLOR').AsString;
OrdQty.Text := CDS_Color.FieldByName('OrdQty').AsString;
OrdUnit.Text := CDS_Color.FieldByName('OrdUnit').AsString;
C_COLORNO.Text := CDS_Color.FieldByName('C_COLORNO').AsString;
end;
procedure TfrmDyePlanCardInput.FormClose(Sender: TObject; var Action: TCloseAction);
begin
inherited;
Action := cahide;
end;
procedure TfrmDyePlanCardInput.FormCreate(Sender: TObject);
begin
inherited;
PCTime.Date := DServerDate;
end;
procedure TfrmDyePlanCardInput.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>');
InitCard();
InitGreyClothStk();
InitRepairCard('');
end;
procedure TfrmDyePlanCardInput.ToolButton1Click(Sender: TObject);
var
MPCIDS, WSql: string;
// WSql: string;
begin
if CDS_1.Locate('SSel', True, []) = False then
begin
Application.MessageBox('û<><C3BB>ѡ<EFBFBD><D1A1><EFBFBD><EFBFBD><EFBFBD><EFBFBD>!', '<27><>ʾ', 0);
Exit;
end;
with CDS_1 do
begin
DisableControls;
First;
while not Eof do
begin
if Fieldbyname('Ssel').AsBoolean then
begin
MPCIDS := MPCIDS + trim(CDS_1.FieldByName('PCID').AsString) + ';';
end;
Next;
end;
EnableControls;
end;
with CDS_1 do
begin
DisableControls;
First;
while not Eof do
begin
if Fieldbyname('Ssel').AsBoolean then
begin
if WSql <> '' then
begin
WSql := WSql + ',' + quotedstr(Trim(CDS_1.fieldbyname('PCID').AsString));
end
else
begin
WSql := quotedstr(Trim(CDS_1.fieldbyname('PCID').AsString));
end;
end;
Next;
end;
EnableControls;
end;
with ADOQueryTmp do
begin
close;
sql.Clear;
sql.Add('select distinct GX=[dbo].[F_Trade_Card_GlideList](A.RTValue) from [dbo].[F_Tool_SplitString](' + quotedstr(MPCIDS) + ','';'') A ');
open;
end;
if ADOQueryTmp.RecordCount > 1 then
begin
Application.MessageBox('<27><>ѡ<EFBFBD><D1A1><EFBFBD><EFBFBD>ͬ<EFBFBD><CDAC><EFBFBD><EFBFBD><EFBFBD>Ŀ<EFBFBD><C4BF>༭!', '<27><>ʾ', 0);
Exit;
end;
try
frmDyeCardGlideEdit := TfrmDyeCardGlideEdit.Create(Application);
with frmDyeCardGlideEdit do
begin
FPCIDS := MPCIDS;
FWSql := WSql;
FWorkshop := self.FWorkshop;
if ShowModal = 1 then
begin
InitCard();
end;
end;
finally
frmDyeCardGlideEdit.Free;
end;
end;
procedure TfrmDyePlanCardInput.ToolButton2Click(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 TfrmDyePlanCardInput.ToolButton3Click(Sender: TObject);
begin
close;
end;
procedure TfrmDyePlanCardInput.ToolButton4Click(Sender: TObject);
begin
if CDS_1.IsEmpty then
exit;
if CDS_1.Locate('SSel', True, []) = False then
begin
Application.MessageBox('û<><C3BB>ѡ<EFBFBD><D1A1><EFBFBD><EFBFBD><EFBFBD><EFBFBD>!', '<27><>ʾ', 0);
Exit;
end;
if Application.MessageBox('ȷ<><C8B7>Ҫɾ<D2AA><C9BE><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>', '<27><>ʾ', 32 + 4) <> IDYES then
Exit;
try
with CDS_1 do
begin
DisableControls;
First;
while not Eof do
begin
if Fieldbyname('Ssel').AsBoolean then
begin
try
ADOQueryCmd.Connection.BeginTrans;
with ADOQueryCmd do
begin
Close;
Sql.Clear;
Sql.Add('exec P_Trade_Card_Del ');
Sql.Add('@PCIDS=' + quotedstr(Trim(CDS_1.fieldbyname('PCID').AsString)));
Sql.Add(',@DCode=' + quotedstr(Trim(DCode)));
Sql.Add(',@DName=' + quotedstr(Trim(DName)));
Open;
end;
if ADOQueryCmd.FieldByName('intReturn').AsInteger = -1 then
raise Exception.Create(pchar(trim(ADOQueryCmd.FieldByName('ShowMsg').AsString)));
// if (Trim(CDS_1.fieldbyname('PCType').AsString) = '<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>') or (Trim(CDS_1.fieldbyname('PCType').AsString) = 'ǰ<><C7B0><EFBFBD><EFBFBD>') then
// begin
// with ADOQueryCmd do
// begin
// Close;
// Sql.Clear;
// Sql.Add('exec P_Trade_GreyCloth_Out_Del ');
// Sql.Add('@PCID=' + quotedstr(Trim(CDS_1.fieldbyname('PCID').AsString)));
// Open;
// end;
// if ADOQueryCmd.FieldByName('intReturn').AsInteger = -1 then
// raise Exception.Create(pchar(trim(ADOQueryCmd.FieldByName('ShowMsg').AsString)));
// end
// else
// begin
// with ADOQueryCmd do
// begin
// Close;
// Sql.Clear;
// Sql.Add('exec P_Trade_Card_Move_Del ');
// Sql.Add('@PCID=' + quotedstr(Trim(CDS_1.fieldbyname('PCID').AsString)));
// Open;
// end;
// if ADOQueryCmd.FieldByName('intReturn').AsInteger = -1 then
// raise Exception.Create(pchar(trim(ADOQueryCmd.FieldByName('ShowMsg').AsString)));
// end;
ADOQueryCmd.Connection.CommitTrans;
except
ADOQueryCmd.Connection.RollbackTrans;
raise Exception.Create(PChar(Exception(ExceptObject).Message));
end;
end;
Next;
EnableControls;
end;
InitCard();
InitGreyClothStk();
end;
except
CDS_1.EnableControls;
application.MessageBox(PChar(Exception(ExceptObject).Message), '<27><>ʾ<EFBFBD><CABE>Ϣ', 0);
end;
end;
procedure TfrmDyePlanCardInput.ToolButton5Click(Sender: TObject);
begin
try
CDS_1.DisableControls;
CDS_1.First;
while not CDS_1.Eof do
begin
if CDS_1.Fieldbyname('Ssel').AsBoolean then
begin
ADOQueryCmd.Connection.BeginTrans;
try
with ADOQueryCmd do
begin
close;
sql.Clear;
sql.Add('select * from Trade_Plan_Card A');
sql.Add('where PCID=''' + trim(CDS_1.fieldbyname('PCID').AsString) + '''');
open;
edit;
FieldByName('Editer').Value := Trim(DName);
FieldByName('EditTime').Value := SGetServerDateTime(ADOQueryTmp);
RTSetSaveDataCDS(ADOQueryCmd, Tv1, CDS_1, 'Trade_Plan_Card', 0);
post;
end;
ADOQueryCmd.Connection.CommitTrans;
except
ADOQueryCmd.Connection.RollbackTrans;
raise Exception.Create(PChar(Exception(ExceptObject).Message));
end;
end;
CDS_1.Next;
end;
CDS_1.EnableControls;
InitCard();
InitGreyClothStk();
except
CDS_1.EnableControls;
application.MessageBox(PChar(Exception(ExceptObject).Message), '<27><>ʾ<EFBFBD><CABE>Ϣ', 0);
end;
end;
procedure TfrmDyePlanCardInput.ToolButton6Click(Sender: TObject);
begin
// inherited;
if CDS_1.IsEmpty then
exit;
if CDS_1.Locate('SSel', True, []) = False then
begin
Application.MessageBox('û<><C3BB>ѡ<EFBFBD><D1A1><EFBFBD><EFBFBD><EFBFBD><EFBFBD>!', '<27><>ʾ', 0);
Exit;
end;
try
ADOTmp.Connection.BeginTrans;
with CDS_1 do
begin
DisableControls;
First;
while not Eof do
begin
if Fieldbyname('Ssel').AsBoolean then
begin
with ADOTmp do
begin
close;
sql.Clear;
sql.Add('update Trade_Plan_Card SET crop=''' + trim(crop.text) + ''' ');
sql.Add('where PCID=' + quotedstr(trim(CDS_1.fieldbyname('PCID').AsString)));
execsql;
end;
end;
Next;
end;
EnableControls;
end;
ADOTmp.Connection.CommitTrans;
application.MessageBox('<27>޸ijɹ<C4B3><C9B9><EFBFBD>', '<27><>ʾ<EFBFBD><CABE>Ϣ');
except
ADOTmp.Connection.RollbackTrans;
application.MessageBox('<27>޸<EFBFBD>ʧ<EFBFBD>ܣ<EFBFBD>', '<27><>ʾ<EFBFBD><CABE>Ϣ', 0);
end;
InitCard();
end;
procedure TfrmDyePlanCardInput.ToolButton7Click(Sender: TObject);
begin
// inherited;
if CDS_1.IsEmpty then
exit;
if CDS_1.Locate('SSel', True, []) = False then
begin
Application.MessageBox('û<><C3BB>ѡ<EFBFBD><D1A1><EFBFBD><EFBFBD><EFBFBD><EFBFBD>!', '<27><>ʾ', 0);
Exit;
end;
try
ADOTmp.Connection.BeginTrans;
with CDS_1 do
begin
DisableControls;
First;
while not Eof do
begin
if Fieldbyname('Ssel').AsBoolean then
begin
with ADOTmp do
begin
close;
sql.Clear;
sql.Add('update Trade_Plan_Card SET sewing=''' + trim(sewing.text) + ''' ');
sql.Add('where PCID=' + quotedstr(trim(CDS_1.fieldbyname('PCID').AsString)));
execsql;
end;
end;
Next;
end;
EnableControls;
end;
ADOTmp.Connection.CommitTrans;
application.MessageBox('<27>޸ijɹ<C4B3><C9B9><EFBFBD>', '<27><>ʾ<EFBFBD><CABE>Ϣ');
except
ADOTmp.Connection.RollbackTrans;
application.MessageBox('<27>޸<EFBFBD>ʧ<EFBFBD>ܣ<EFBFBD>', '<27><>ʾ<EFBFBD><CABE>Ϣ', 0);
end;
InitCard();
end;
procedure TfrmDyePlanCardInput.TV3Column1PropertiesEditValueChanged(Sender: TObject);
var
mvalue: string;
begin
// mvalue := TcxTextEdit(Sender).EditingText;
// with CDS_3 do
// begin
// Edit;
// FieldByName('MvPiece').Value := STRTOFLOATDEF(mvalue, 0);
// if FieldByName('PSC_StkPiece').AsFloat > 0 then
// FieldByName('MvQty').Value := STRTOFLOATDEF(mvalue, 0) * (FieldByName('PSC_StkQty').AsFloat / FieldByName('PSC_StkPiece').AsFloat)
// else
// FieldByName('MvQty').Value := 0;
// Post;
//
// end;
// Tv3.Controller.EditingController.ShowEdit();
end;
procedure TfrmDyePlanCardInput.TV3DblClick(Sender: TObject);
begin
// CDS_3.Delete;
end;
end.