unit U_TradePlanInPut; interface uses Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms, Dialogs, cxStyles, cxCustomData, cxGraphics, cxFilter, cxData, cxDataStorage, cxEdit, DB, cxDBData, cxGridLevel, cxGridCustomTableView, cxGridTableView, cxGridDBTableView, cxClasses, cxControls, cxGridCustomView, cxGrid, cxMemo, cxRichEdit, ComCtrls, cxContainer, cxTextEdit, cxMaskEdit, cxButtonEdit, StdCtrls, ToolWin, DBClient, ADODB, ExtCtrls, BtnEdit, cxCalendar, StrUtils, cxCurrencyEdit, cxGridCustomPopupMenu, cxGridPopupMenu, cxDropDownEdit, RM_Common, RM_Preview, RM_System, RM_Class, RM_GridReport, RM_Dataset, Menus, cxSplitter, cxLookAndFeels, cxLookAndFeelPainters, cxNavigator, cxCheckBox, dxSkinsCore, dxSkinsDefaultPainters, dxDateRanges, dxBarBuiltInMenu, cxPC, System.ImageList, Vcl.ImgList, U_BaseInput, cxImage, cxDBEdit, IdBaseComponent, IdComponent, IdTCPConnection, IdTCPClient, IdExplicitTLSClientServerBase, IdFTP, ShellAPI, math, cxTimeEdit, dxSkinOffice2013White, dxSkinWXI, dxScrollbarAnnotations; type TfrmTradePlanInPut = class(TfrmBaseInput) ToolBar1: TToolBar; TBSave: TToolButton; TBClose: TToolButton; ScrollBox1: TScrollBox; OrderNo: TEdit; ADOTemp: TADOQuery; ADOCmd: TADOQuery; DS_1: TDataSource; CDS_1: TClientDataSet; Label3: TLabel; OrdDate: TDateTimePicker; Label25: TLabel; DLYDate: TDateTimePicker; OrdNote: TMemo; Label23: TLabel; GPM_1: TcxGridPopupMenu; ADOQueryLabel: TADOQuery; Label51: TLabel; Label7: TLabel; cxDBImage1: TcxDBImage; Qry_ImgHX: TADOQuery; DS_ImgHX: TDataSource; ToolButton3: TToolButton; Label1: TLabel; Label2: TLabel; Label4: TLabel; BuyConNo: TEdit; IdFTP1: TIdFTP; cxGrid1: TcxGrid; Tv1: TcxGridDBTableView; v1Column11: TcxGridDBColumn; v1Column4: TcxGridDBColumn; v1PRTColor: TcxGridDBColumn; v1Column5: TcxGridDBColumn; VC_PRTPs: TcxGridDBColumn; v1PRTOrderQty: TcxGridDBColumn; cxGrid1Level1: TcxGridLevel; ToolBar2: TToolBar; btnConSel: TToolButton; ToolButton1: TToolButton; ToolButton2: TToolButton; Label14: TLabel; Label20: TLabel; CustName: TBtnEditC; OurCoName: TBtnEditC; ToolButton5: TToolButton; ConNo: TEdit; Tv1Column2: TcxGridDBColumn; Tv1Column3: TcxGridDBColumn; Label12: TLabel; Label13: TLabel; Label15: TLabel; RuleBeforeTare: TEdit; Coefficient: TEdit; RuleLenUnit: TComboBox; Label16: TLabel; RuleLaterTare: TEdit; Label17: TLabel; FtyName: TBtnEditC; Label18: TLabel; Technics: TBtnEditC; Follower: TEdit; Label19: TLabel; Tv1Column1: TcxGridDBColumn; Tv1Column4: TcxGridDBColumn; Tv1Column5: TcxGridDBColumn; Tv1Column6: TcxGridDBColumn; Tv1Column7: TcxGridDBColumn; Tv1Column8: TcxGridDBColumn; Tv1Column9: TcxGridDBColumn; Label5: TLabel; ordrequest: TMemo; Tv1Column32: TcxGridDBColumn; Tv1Column38: TcxGridDBColumn; ADOTemp1: TADOQuery; cxStyleRepository1: TcxStyleRepository; cxStyle1: TcxStyle; cxStyle2: TcxStyle; Label6: TLabel; XDDate: TDateTimePicker; Tv1Column39: TcxGridDBColumn; overflow: TEdit; Label9: TLabel; ADOQuery1: TADOQuery; PopupMenu1: TPopupMenu; N3: TMenuItem; N4: TMenuItem; Label10: TLabel; YHDate: TDateTimePicker; FLOrdNote: TMemo; Label11: TLabel; Tv1Column10: TcxGridDBColumn; procedure TBCloseClick(Sender: TObject); procedure FormShow(Sender: TObject); procedure TBSaveClick(Sender: TObject); procedure ToolButton1Click(Sender: TObject); procedure ToolButton2Click(Sender: TObject); procedure CustomerNoNameBtnDnClick(Sender: TObject); procedure v1OrderUnitPropertiesButtonClick(Sender: TObject; AButtonIndex: Integer); procedure v1PriceUnitPropertiesButtonClick(Sender: TObject; AButtonIndex: Integer); procedure YCLFactoryBtnUpClick(Sender: TObject); procedure ScrollBox1Click(Sender: TObject); procedure v1Column5PropertiesEditValueChanged(Sender: TObject); procedure HYTTBtnUpClick(Sender: TObject); procedure KYTTBtnUpClick(Sender: TObject); procedure btnConSelClick(Sender: TObject); procedure edtGYBtnUpClick(Sender: TObject); procedure Tv1MouseDown(Sender: TObject; Button: TMouseButton; Shift: TShiftState; X, Y: Integer); procedure v1OrderUnitPropertiesEditValueChanged(Sender: TObject); procedure Tv1Column4PropertiesButtonClick(Sender: TObject; AButtonIndex: Integer); procedure cxDBImage1DblClick(Sender: TObject); procedure SYRNameBtnUpClick(Sender: TObject); procedure ToolButton3Click(Sender: TObject); procedure CustNameBtnUpClick(Sender: TObject); procedure OurCoNameBtnUpClick(Sender: TObject); procedure OurCoNameBtnDnClick(Sender: TObject); procedure ToolButton5Click(Sender: TObject); procedure FtyNameBtnUpClick(Sender: TObject); procedure TechnicsBtnUpClick(Sender: TObject); procedure Tv1Column1PropertiesButtonClick(Sender: TObject; AButtonIndex: Integer); procedure Tv1Column13PropertiesButtonClick(Sender: TObject; AButtonIndex: Integer); procedure TextEdit(Sender: TObject); procedure ConNoKeyPress(Sender: TObject; var Key: Char); procedure BuyConNoKeyPress(Sender: TObject; var Key: Char); procedure ordrequestKeyPress(Sender: TObject; var Key: Char); procedure N3Click(Sender: TObject); procedure N4Click(Sender: TObject); procedure DLYDateChange(Sender: TObject); procedure FtyNameBtnDnClick(Sender: TObject); procedure TechnicsBtnDnClick(Sender: TObject); private FSCXDH: string; procedure InitData(); procedure ZDYHelp(FButn: TcxButtonEdit; LType: string); function SaveData(): Boolean; function getOrderNo(fconNo: string): string; procedure InitImageHX(); procedure LookImage(FileName: string); function NewRoundTo(value: Double; ws: Integer): Double; { Private declarations } public PState, CopyInt, PriceFlag: Integer; FMainId, FFMainId, FOrderNo: string; FXS: Integer; canshu1: string; fFlileFlag: string; { Public declarations } end; var frmTradePlanInPut: TfrmTradePlanInPut; newh: hwnd; implementation uses U_DataLink, U_ZDYHelp, U_RTFun, U_TradeSalesContractSel, U_CompanySel, U_ClothInfoSel, U_CloInfoFileUp; {$R *.dfm} procedure TfrmTradePlanInPut.N3Click(Sender: TObject); begin // inherited; SelOKNoFiler(Tv1, True); //全选 end; procedure TfrmTradePlanInPut.N4Click(Sender: TObject); begin // inherited; SelOKNoFiler(Tv1, False); //全弃 end; function TfrmTradePlanInPut.NewRoundTo(value: Double; ws: Integer): Double; var iLen: Integer; E: Extended; begin iLen := StrToInt('1' + stringOfChar('0', ws)); E := StrToFloat(FloatToStr(value)); Result := Ceil(E * iLen) / iLen; end; procedure TfrmTradePlanInPut.ordrequestKeyPress(Sender: TObject; var Key: Char); begin // inherited; if Key = #13 then begin OrdNote.SetFocus; end; end; procedure TfrmTradePlanInPut.InitImageHX(); begin with Qry_ImgHX do begin close; sql.Clear; sql.Add('select * from TP_File A'); sql.Add('where isnull(WBID,'''')<>'''' '); sql.Add('and WBID=(select HXSID from SalesContract_Sub X where X.SubId=' + quotedstr(Trim(self.CDS_1.fieldbyname('ConSubId').AsString)) + ')'); open; end; end; function TfrmTradePlanInPut.getOrderNo(fconNo: string): string; var str1: string; i: integer; begin str1 := trim(fconNo) + '01'; with ADOTemp do begin close; sql.Clear; sql.Add('select MainID from Trade_Plan_Main where orderNo=' + quotedstr(trim(str1))); open; end; if not ADOTemp.IsEmpty then begin for i := 1 to 99 do begin str1 := trim(fconNo) + rightstr(inttostr(100 + i), 2); with ADOCmd do begin close; sql.Clear; sql.Add('select MainID from Trade_Plan_Main where orderNo=' + quotedstr(trim(str1))); open; end; if ADOCmd.IsEmpty then break; end; end; result := str1; end; procedure TfrmTradePlanInPut.TBCloseClick(Sender: TObject); begin Close; end; procedure TfrmTradePlanInPut.InitData(); var FDate: TDateTime; begin FDate := SGetServerDateTime(ADOTemp); OrdDate.DateTime := FDate; DlyDate.DateTime := FDate; XDDate.DateTime := FDate; YHDate.DateTime := FDate; with ADOTemp do begin Close; sql.Clear; sql.Add('select * from V_Trade_Plan_Single where MainId=''' + Trim(FMainId) + ''''); Open; end; SCSHData(ADOTemp, ScrollBox1, 2); SCSHData(ADOTemp, ScrollBox1, 5); SCSHData(ADOTemp, ScrollBox1, 9); SCSHData(ADOTemp, ScrollBox1, 7); OurCoName.TxtCode := Trim(ADOTemp.FieldByName('OurCoNo').AsString); CustName.TxtCode := Trim(ADOTemp.FieldByName('CustNo').AsString); FtyName.TxtCode := Trim(ADOTemp.FieldByName('FtyNo').AsString); ConNo.Text := Trim(ADOTemp.FieldByName('ConNo1').AsString); BuyConNo.Text := Trim(ADOTemp.FieldByName('BuyConNo1').AsString); FLOrdNote.Text := Trim(ADOTemp.FieldByName('FLOrdNote').AsString); with ADOTemp do begin Close; SQL.Clear; sql.Add(' select * from Trade_Plan_Sub where 1=1 '); if PState = 1 then begin sql.Add(' and MainId=''' + Trim(FMainId) + ''''); end; if PState = 0 then begin sql.Add(' and 1<>1'); end; Open; end; SCreateCDS(ADOTemp, CDS_1); SInitCDSData(ADOTemp, CDS_1); if PState = 0 then begin OrdDate.DateTime := SGetServerDateTime(ADOTemp); DlyDate.DateTime := OrdDate.DateTime; XDDate.DateTime := OrdDate.DateTime; YHDate.DateTime := DlyDate.DateTime - 3; OrderNo.Text := ''; OrderNo.Enabled := True; end else begin end; if CopyInt = 99 then begin PState := 0; FMainId := ''; OrderNo.Text := ''; OrderNo.Enabled := True; OrdDate.DateTime := FDate; with CDS_1 do begin First; while not Eof do begin Edit; FieldByName('MainId').value := ''; FieldByName('SubId').value := ''; Post; Next; end; end; end; end; procedure TfrmTradePlanInPut.ZDYHelp(FButn: TcxButtonEdit; LType: string); var FType, ZDYName, FText: string; begin end; procedure TfrmTradePlanInPut.FormShow(Sender: TObject); var i: Integer; begin inherited; readCxGrid(TRIM(SELF.Caption), Tv1, '生产指示单管理'); OrderNo.Text := ''; fFlileFlag := UserDataFlag + 'HX'; InitData(); // ConNo.SetFocus; end; procedure TfrmTradePlanInPut.FtyNameBtnDnClick(Sender: TObject); begin // inherited; TBtnEditC(Sender).Text := ''; TBtnEditC(Sender).TxtCode := ''; end; procedure TfrmTradePlanInPut.FtyNameBtnUpClick(Sender: TObject); begin try frmCompanySel := TfrmCompanySel.Create(Application); with frmCompanySel do begin FCoType := '供应商'; if ShowModal = 1 then begin self.FtyName.TxtCode := Trim(CDS_1.fieldbyname('CoCode').AsString); self.FtyName.Text := Trim(CDS_1.fieldbyname('CoAbbrName').AsString); self.Follower.Text := Trim(CDS_1.fieldbyname('Follower').AsString); end; end; finally frmCompanySel.Free; end; end; function TfrmTradePlanInPut.SaveData(): Boolean; var maxno, Smaxno, maxorderno, MaxFNo: string; begin try ADOCmd.Connection.BeginTrans; ///保存主表 if Trim(FMainId) = '' then begin if GetLSNo(ADOCmd, maxno, 'JM', 'Trade_Plan_Main', 3, 1) = False then // if GetLSNo1(ADOCmd, maxno, 'ZY', 'Trade_Plan_Main', 2, 1) = False then raise Exception.Create('取最大号失败!'); end else begin maxno := Trim(FMainId); end; with ADOCmd do begin Close; sql.Clear; SQL.Add('select * from Trade_Plan_Main where MainId=''' + Trim(FMainId) + ''''); Open; end; with ADOTemp1 do begin Close; sql.Clear; SQL.Add('select * from Trade_Plan_Main where MainId=''' + Trim(FMainId) + ''''); Open; end; with ADOCmd do begin if Trim(FMainId) = '' then begin Append; FieldByName('FillId').value := Trim(DCode); FieldByName('Filler').value := Trim(DName); end else begin Edit; FieldByName('EditId').value := Trim(DCode); FieldByName('Editer').value := Trim(DName); FieldByName('EditTime').value := SGetServerDateTime(ADOTemp); end; RTSetsavedata(ADOCmd, 'Trade_Plan_Main', ScrollBox1, 2); if Trim(ADOTemp1.fieldbyname('FLtime').AsString) = '' then begin FieldByName('FLtime').value := SGetServerDateTime(ADOTemp); end; FieldByName('MainId').value := Trim(maxno); FieldByName('OurCoNo').value := Trim(OurCoName.TxtCode); FieldByName('CustNo').value := Trim(CustName.TxtCode); FieldByName('FLOrdNote').value := Trim(FLOrdNote.text); Post; end; if PState = 1 then begin with ADOQuery1 do begin Close; sql.Clear; sql.Add('insert into SY_SysLog(operor,opertime,Model,acction,opevent,result,OPmainid) values( '); sql.Add(' ' + quotedstr(trim(DName))); sql.Add(',getdate() '); sql.Add(',' + quotedstr(trim(self.Caption))); sql.Add(',' + quotedstr(trim('计划单修改'))); sql.Add(',' + quotedstr(trim('修改前计划单号:' + trim(forderno))) + quotedstr(trim('修改后计划单号:' + trim(OrderNo.text)))); sql.Add(',' + quotedstr(trim('成功'))); sql.Add(',' + quotedstr(trim(FMainId))); sql.Add(')'); ExecSQL; end; end; ///////////////////// 保存子表 /////////////////////////// with CDS_1 do begin First; while not Eof do begin // if Trim(CDS_1.fieldbyname('SubId').AsString) = '' then // begin // if GetLSNo(ADOCmd, Smaxno, 'JS', 'Trade_Plan_Sub', 4, 1) = False then // raise Exception.Create('取子流水号失败!'); // end // else // begin // Smaxno := Trim(CDS_1.fieldbyname('SubId').AsString); // end; Smaxno := Trim(CDS_1.fieldbyname('SubId').AsString); with ADOCmd do begin Close; SQL.Clear; sql.Add('select * from Trade_Plan_Sub where MainId=''' + Trim(maxno) + ''''); sql.Add(' and SubId=''' + Trim(Smaxno) + ''''); Open; end; with ADOCmd do begin if Trim(CDS_1.fieldbyname('SubId').AsString) = '' then Append else Edit; RTSetSaveDataCDS(ADOCmd, Tv1, CDS_1, 'Trade_Plan_Sub', 0); RTSetsavedata(ADOCmd, 'Trade_Plan_Sub', ScrollBox1, 7); FieldByName('MainId').value := Trim(maxno); FieldByName('SubId').value := Trim(Smaxno); FieldByName('ConSId').value := Trim(CDS_1.fieldbyname('ConSId').AsString); FieldByName('ConMId').value := Trim(CDS_1.fieldbyname('ConMId').AsString); Post; with CDS_1 do begin Edit; fieldbyname('SubId').value := Trim(Smaxno); Post; end; end; Next; end; end; ///////////////////// 保存子表 /////////////////////////// ///////////////////// 保存加工厂 /////////////////////////// with ADOCmd do begin Close; sql.Clear; SQL.Add('select * from Trade_Plan_Fty where TPFId=''' + Trim(FMainId) + ''''); Open; end; with ADOCmd do begin if ADOCmd.IsEmpty then begin Append; end else Edit; RTSetsavedata(ADOCmd, 'Trade_Plan_Fty', ScrollBox1, 5); FieldByName('FtyNo').value := Trim(FtyName.TxtCode); FieldByName('MainId').value := Trim(FMainId); FieldByName('TPFId').value := Trim(FMainId); Post; end; ///////////////////// 保存加工厂 /////////////////////////// /// /////////////// 保存打卷设置 /////////////// with ADOCmd do begin Close; sql.Clear; SQL.Add('select * from Trade_Cloth_Inspect_Rule where RuleID=''' + Trim(FMainId) + ''''); Open; end; with ADOCmd do begin if ADOCmd.IsEmpty then begin Append; end else Edit; RTSetsavedata(ADOCmd, 'Trade_Cloth_Inspect_Rule', ScrollBox1, 9); FieldByName('RuleID').value := Trim(FMainId); Post; end; /////////////// 保存打卷设置 /////////////// with ADOCmd do begin Close; sql.Clear; sql.Add('select * from Trade_Plan_Main where orderno=''' + Trim(OrderNo.Text) + ''''); Open; end; if ADOCmd.RecordCount > 1 then raise Exception.Create('订单号重复!'); FMainId := Trim(maxno); ADOCmd.Connection.CommitTrans; Result := True; except Result := False; ADOCmd.Connection.RollbackTrans; application.MessageBox(PChar(Exception(ExceptObject).Message), '提示信息', 0); if pos('KEY 约束', Exception(ExceptObject).Message) > 0 then begin if GetLSNo(ADOCmd, Smaxno, 'JS', 'Trade_Plan_Sub', 4, 1) = False then begin Application.MessageBox('重新取子流水号失败!', '提示', 0); Exit; end; end; end; end; procedure TfrmTradePlanInPut.TBSaveClick(Sender: TObject); var MAXNO1: string; begin if PState <> 1 then begin OrdDate.SetFocus; end; if OrderNo.Text = '' then begin Application.MessageBox('工艺单号不能为空!', '提示', 0); Exit; end; if CDS_1.IsEmpty then begin Application.MessageBox('明细不能为空!', '提示', 0); Exit; end; if CDS_1.Locate('OrdUnit', null, []) then begin Application.MessageBox('单位不能为空!', '提示', 0); Exit; end; if CDS_1.Locate('OrdQty', null, []) then begin Application.MessageBox('数量不能为空!', '提示', 0); Exit; end; if CDS_1.Locate('C_Color', null, []) then begin Application.MessageBox('颜色不能为空!', '提示', 0); Exit; end; if CDS_1.Locate('C_CJsize', null, []) then begin Application.MessageBox('裁剪尺寸不能为空!', '提示', 0); Exit; end; with CDS_1 do begin First; while not Eof do begin with ADOTemp do begin close; sql.Clear; sql.Add('update Bs_Contract_Sub SET JHDstatus=''1'' '); sql.Add(' where ConSId=' + quotedstr(trim(CDS_1.fieldbyname('ConSId').AsString))); execsql; end; Next; end; end; if SaveData() then begin Application.MessageBox('保存成功!', '提示', 0); // ModalResult := 1; end; end; procedure TfrmTradePlanInPut.ToolButton1Click(Sender: TObject); var i: Integer; maxno: string; begin if GetLSNo(ADOCmd, maxno, 'CS', 'BS_Contract_Sub', 4, 1) = False then begin ADOCmd.Connection.RollbackTrans; Application.MessageBox('取子流水号失败!', '提示', 0); Exit; end; i := CDS_1.RecordCount; //当前的dataset有多少行记录 i := i + 1; CopyAddRow(Tv1, CDS_1); with CDS_1 do begin Edit; FieldByName('SSel').value := false; FieldByName('SerialNo').value := i; FieldByName('SubId').value := maxno; // FieldByName('hxFile').Value := ''; // FieldByName('TPPS').Value := 0; Post; end; end; procedure TfrmTradePlanInPut.ToolButton2Click(Sender: TObject); begin if CDS_1.IsEmpty then Exit; if CDS_1.Locate('SSel', True, []) = False then begin Application.MessageBox('没有选择数据!', '提示', 0); Exit; end; if Application.MessageBox('确定要删除选择的数据吗?', '提示', 32 + 4) <> IDYES then exit; CDS_1.DisableControls; with CDS_1 do begin First; while Locate('SSel', True, []) do begin with ADOTemp do begin Close; sql.Clear; sql.Add('select * from Trade_Cloth_Inspect where isnull(SubId,'''')<>'''' and SubId=''' + Trim(CDS_1.fieldbyname('SubId').AsString) + ''''); Open; end; if ADOTemp.IsEmpty = False then begin Application.MessageBox('已检验不能删除数据!', '提示', 0); Exit; end; if Trim(CDS_1.fieldbyname('SubId').AsString) <> '' then begin with ADOCmd do begin Close; sql.Clear; // sql.Add('insert into Trade_Plan_Sub_Del select * from Trade_Plan_Sub where SubId=''' + Trim(CDS_1.fieldbyname('SubId').AsString) + ''''); sql.Add('delete Trade_Plan_Sub where SubId=''' + Trim(CDS_1.fieldbyname('SubId').AsString) + ''''); ExecSQL; end; end; Delete; end; end; CDS_1.EnableControls; end; procedure TfrmTradePlanInPut.ToolButton3Click(Sender: TObject); begin WriteCxGrid(TRIM(SELF.Caption), Tv1, '生产指示单管理'); end; procedure TfrmTradePlanInPut.ToolButton5Click(Sender: TObject); begin try frmClothInfoSel := TfrmClothInfoSel.Create(Application); with frmClothInfoSel do begin if ShowModal = 1 then begin while CDS_1.locate('SSel', true, []) do begin if self.CDS_1.locate('ConSubId', trim(CDS_1.Fieldbyname('SubId').AsString), []) then begin CDS_1.Edit; CDS_1.fieldbyname('SSel').value := false; continue; end; with self.CDS_1 do begin append; FieldByName('SSel').value := false; Fieldbyname('C_Code').value := trim(frmClothInfoSel.CDS_1.Fieldbyname('C_Code').AsString); Fieldbyname('C_Name').value := trim(frmClothInfoSel.CDS_1.Fieldbyname('C_Name').AsString); Fieldbyname('C_Spec').value := trim(frmClothInfoSel.CDS_1.Fieldbyname('C_Spec').AsString); Fieldbyname('C_Composition').value := trim(frmClothInfoSel.CDS_1.Fieldbyname('C_Composition').AsString); Fieldbyname('C_Width').value := trim(frmClothInfoSel.CDS_1.Fieldbyname('C_Width').AsString); Fieldbyname('C_GramWeight').value := trim(frmClothInfoSel.CDS_1.Fieldbyname('C_GramWeight').AsString); Fieldbyname('OrdUnit').value := trim(frmClothInfoSel.CDS_1.fieldbyname('ConUnit').AsString); Fieldbyname('C_ColorNo').value := trim(frmClothInfoSel.CDS_1.Fieldbyname('C_ColorNo').AsString); Fieldbyname('C_Color').value := trim(frmClothInfoSel.CDS_1.Fieldbyname('C_Color').AsString); Fieldbyname('C_Pattern').value := trim(frmClothInfoSel.CDS_1.Fieldbyname('C_Pattern').AsString); Fieldbyname('OrdQty').value := frmClothInfoSel.CDS_1.Fieldbyname('ConQty').AsFloat; Fieldbyname('DDQtyUnit').value := frmClothInfoSel.CDS_1.Fieldbyname('SCSUnit').AsString; Fieldbyname('OrderUnit').value := trim(frmClothInfoSel.CDS_1.Fieldbyname('SCSUnit').AsString); end; CDS_1.Edit; CDS_1.fieldbyname('SSel').value := false; end; end; end; finally frmClothInfoSel.Free; end; end; procedure TfrmTradePlanInPut.edtGYBtnUpClick(Sender: TObject); var fsj: string; FWZ: Integer; i: integer; begin // fsj := Trim(TBtnEditC(Sender).Hint); // FWZ := Pos('/', fsj); // i := 0; // try // frmZDYHelpSel := TfrmZDYHelpSel.Create(Application); // with frmZDYHelpSel do // begin // flag := Copy(fsj, 1, FWZ - 1); // flagname := Copy(fsj, FWZ + 1, Length(fsj) - FWZ); // if ShowModal = 1 then // begin // TBtnEditC(Sender).text := ''; // with ClientDataSet1 do // begin // First; // while not Eof do // begin // if FieldByName('SSel').AsBoolean = True then // begin // i := i + 1; // if TBtnEditC(Sender).text = '' then // TBtnEditC(Sender).text := FieldByName('ZDYName').AsString // else // TBtnEditC(Sender).text := TBtnEditC(Sender).text + ',' + FieldByName('ZDYName').AsString; //inttostr(i)+'.'+ // end; // Next; // end; // end; // end; // end; // finally // frmZDYHelpSel.Free; // end; end; procedure TfrmTradePlanInPut.TechnicsBtnDnClick(Sender: TObject); begin // inherited; TBtnEditC(Sender).Text := ''; TBtnEditC(Sender).TxtCode := ''; end; procedure TfrmTradePlanInPut.TechnicsBtnUpClick(Sender: TObject); begin try frmZDYHelp := TfrmZDYHelp.Create(Application); with frmZDYHelp do begin fnote := True; flag := 'Technics'; flagname := '工艺'; if ShowModal = 1 then begin Technics.text := Trim(ClientDataSet1.fieldbyname('ZDYName').AsString); end; end; finally frmZDYHelp.Free; end; end; procedure TfrmTradePlanInPut.BuyConNoKeyPress(Sender: TObject; var Key: Char); begin // inherited; if Key = #13 then begin ordrequest.SetFocus; end; end; procedure TfrmTradePlanInPut.ConNoKeyPress(Sender: TObject; var Key: Char); begin // inherited; if Key = #13 then begin BuyConNo.SetFocus; end; end; procedure TfrmTradePlanInPut.CustNameBtnUpClick(Sender: TObject); begin try frmCompanySel := TfrmCompanySel.Create(Application); with frmCompanySel do begin FCoType := '客户'; if ShowModal = 1 then begin self.CustName.TxtCode := Trim(frmCompanySel.CDS_1.fieldbyname('CoCode').AsString); self.CustName.Text := Trim(frmCompanySel.CDS_1.fieldbyname('CoAbbrName').AsString); end; end; finally frmCompanySel.Free; end; end; procedure TfrmTradePlanInPut.CustomerNoNameBtnDnClick(Sender: TObject); begin TBtnEditC(Sender).Text := ''; TBtnEditC(Sender).TxtCode := ''; end; procedure TfrmTradePlanInPut.cxDBImage1DblClick(Sender: TObject); begin if TcxDBImage(Sender).Picture.Height = 0 then exit; LookImage(Qry_ImgHX.fieldbyname(TcxDBImage(Sender).Hint).asstring); end; procedure TfrmTradePlanInPut.DLYDateChange(Sender: TObject); begin // inherited; YHDate.DateTime := DlyDate.DateTime - 3; end; procedure TfrmTradePlanInPut.LookImage(FileName: string); var sFieldName: string; begin sFieldName := leftbstr(ExtractFilePath(Application.ExeName), 1) + ':\图片查看'; if not DirectoryExists(pchar(sFieldName)) then CreateDirectory(pchar(sFieldName), nil); sFieldName := sFieldName + '\' + trim(FileName); try IdFTP1.Host := ReadINIFileStr('SYSTEMSET.INI', 'SERVER', '服务器地址', '127.0.0.1'); IdFTP1.Username := 'three'; IdFTP1.Password := '641010'; IdFTP1.Connect(); except ; end; if IdFTP1.Connected then begin try IdFTP1.Get(fFlileFlag + '\' + Trim(FileName), sFieldName, true, false); except Application.MessageBox('客户图样文件不存在', '提示', MB_ICONWARNING); IdFTP1.Quit; Exit; end; end else begin Application.MessageBox('无法连接文件服务器', '提示', MB_ICONWARNING); IdFTP1.Quit; Exit; end; if IdFTP1.Connected then IdFTP1.Quit; ShellExecute(Handle, 'open', PChar(sFieldName), '', '', SW_SHOWNORMAL); end; procedure TfrmTradePlanInPut.v1OrderUnitPropertiesButtonClick(Sender: TObject; AButtonIndex: Integer); var mvalues: string; begin mvalues := tv1.Columns[tv1.Controller.FocusedColumn.index].DataBinding.FieldName; try frmZDYHelp := TfrmZDYHelp.Create(Application); with frmZDYHelp do begin flag := 'OrderUnit'; flagname := '数量单位'; if ShowModal = 1 then begin Self.CDS_1.Edit; Self.CDS_1.FieldByName(mvalues).value := Trim(ClientDataSet1.fieldbyname('ZDYName').AsString); end; end; finally frmZDYHelp.Free; end; end; procedure TfrmTradePlanInPut.v1OrderUnitPropertiesEditValueChanged(Sender: TObject); var mvalue, FFieldName, YValue: string; FDDQty, FCPCDXS, FQty, FDKCQty: Double; begin mvalue := TcxComboBox(Sender).EditingText; //变化后单位 FFieldName := Trim(Tv1.Controller.FocusedColumn.DataBinding.FilterFieldName); with CDS_1 do begin Edit; FieldByName(FFieldName).value := mvalue; Post; YValue := FieldByName('DDQtyUnit').AsString; //原单位=订单单位 FDDQty := FieldByName('DDQty').AsFloat; //订单数量 FCPCDXS := FieldByName('CPCDXS').AsFloat; FDKCQty := FieldByName('DKCQty').AsFloat; FQty := FieldByName('PRTOrderQty').AsFloat; end; if mvalue = 'Kg' then begin if YValue = 'Y' then begin FQty := FDDQty * 0.9144 / FCPCDXS; end; if YValue = 'M' then begin FQty := FDDQty / FCPCDXS; end; if YValue = 'Kg' then begin FQty := FDDQty; end; end; if mvalue = 'M' then begin if YValue = 'Y' then begin FQty := FDDQty * 0.9144; end; if YValue = 'Kg' then begin FQty := FDDQty * FCPCDXS; end; if YValue = 'M' then begin FQty := FDDQty; end; end; if mvalue = 'Y' then begin if YValue = 'M' then begin FQty := FDDQty / 0.9144; end; if YValue = 'Kg' then begin FQty := FDDQty * FCPCDXS / 0.9144; end; if YValue = 'Y' then begin FQty := FDDQty; end; end; with CDS_1 do begin Edit; FieldByName('PRTOrderQty').value := FQty - FDKCQty; Post; end; Tv1.Controller.EditingController.ShowEdit(); end; procedure TfrmTradePlanInPut.v1PriceUnitPropertiesButtonClick(Sender: TObject; AButtonIndex: Integer); begin try frmZDYHelp := TfrmZDYHelp.Create(Application); with frmZDYHelp do begin flag := 'PriceUnit'; flagname := '价格单位'; if Trim(DParameters1) <> '高权限' then begin TBAdd.Visible := False; TBEdit.Visible := False; TBDel.Visible := False; end; if ShowModal = 1 then begin Self.CDS_1.Edit; Self.CDS_1.FieldByName('PriceUnit').value := Trim(ClientDataSet1.fieldbyname('ZDYName').AsString); end; end; finally frmZDYHelp.Free; end; end; procedure TfrmTradePlanInPut.YCLFactoryBtnUpClick(Sender: TObject); var fsj: string; FWZ: Integer; begin fsj := Trim(TEdit(Sender).Hint); FWZ := Pos('/', fsj); try frmZDYHelp := TfrmZDYHelp.Create(Application); with frmZDYHelp do begin flag := Copy(fsj, 1, FWZ - 1); flagname := Copy(fsj, FWZ + 1, Length(fsj) - FWZ); if ShowModal = 1 then begin TEdit(Sender).Text := Trim(ClientDataSet1.fieldbyname('ZDYName').AsString); end; end; finally frmZDYHelp.Free; end; end; procedure TfrmTradePlanInPut.btnConSelClick(Sender: TObject); var FConMainId, FMPRTCode: string; Smaxno: string; S: Integer; begin try frmTradeSalesContractSel := TfrmTradeSalesContractSel.Create(Application); with frmTradeSalesContractSel do begin fconNo := self.ConNo.Text; // S := CDS_1.RecordCount; // fC_Code := self.C_Code.Text; if ShowModal = 1 then begin S := self.CDS_1.RecordCount; // S := 1; while CDS_1.locate('SSel', true, []) do begin if self.CDS_1.locate('ConSId', trim(CDS_1.Fieldbyname('ConSId').AsString), []) then begin CDS_1.Edit; CDS_1.fieldbyname('SSel').value := false; continue; end; if GetLSNo(ADOCmd, Smaxno, 'CS', 'BS_Contract_Sub', 4, 1) = False then begin ADOCmd.Connection.RollbackTrans; Application.MessageBox('取子流水号失败!', '提示', 0); Exit; end; // S := CDS_1.RecordCount; S := S + 1; self.BuyConNo.Text := Trim(frmTradeSalesContractSel.CDS_1.fieldbyname('BuyConNo').AsString); self.CustName.TxtCode := Trim(frmTradeSalesContractSel.CDS_1.fieldbyname('BuyNo').AsString); self.CustName.Text := Trim(frmTradeSalesContractSel.CDS_1.fieldbyname('BuyName').AsString); self.OurCoName.TxtCode := Trim(frmTradeSalesContractSel.CDS_1.fieldbyname('Sellno').AsString); self.OurCoName.Text := Trim(frmTradeSalesContractSel.CDS_1.fieldbyname('Sellname').AsString); self.overflow.Text := Trim(frmTradeSalesContractSel.CDS_1.fieldbyname('qtynote').AsString); self.ConNo.Text := Trim(frmTradeSalesContractSel.CDS_1.fieldbyname('ConNo').AsString); self.DlyDate.DateTime := frmTradeSalesContractSel.CDS_1.fieldbyname('DlyDate').AsDateTime; self.XDDate.DateTime := frmTradeSalesContractSel.CDS_1.fieldbyname('ConDate').AsDateTime; with self.CDS_1 do begin Append; FieldByName('SSel').value := false; Fieldbyname('subid').value := Trim(Smaxno); Fieldbyname('SerialNo').value := S; Fieldbyname('ConNo').value := trim(frmTradeSalesContractSel.CDS_1.Fieldbyname('ConNo').AsString); Fieldbyname('ConMId').value := trim(frmTradeSalesContractSel.CDS_1.Fieldbyname('ConMId').AsString); Fieldbyname('ConSId').value := trim(frmTradeSalesContractSel.CDS_1.Fieldbyname('ConSId').AsString); Fieldbyname('C_ColorNo').value := trim(frmTradeSalesContractSel.CDS_1.Fieldbyname('C_ColorNo').AsString); Fieldbyname('C_Color').value := trim(frmTradeSalesContractSel.CDS_1.Fieldbyname('C_Color').AsString); Fieldbyname('C_Pattern').value := trim(frmTradeSalesContractSel.CDS_1.Fieldbyname('C_Pattern').AsString); Fieldbyname('OrdQty').value := frmTradeSalesContractSel.CDS_1.Fieldbyname('ConQty').AsFloat; Fieldbyname('C_box').value := frmTradeSalesContractSel.CDS_1.Fieldbyname('C_box').AsFloat; Fieldbyname('Processprice').value := trim(frmTradeSalesContractSel.CDS_1.Fieldbyname('Processprice').AsString); Fieldbyname('C_MKSL').value := trim(frmTradeSalesContractSel.CDS_1.Fieldbyname('C_MKSL').AsString); // Fieldbyname('C_boxs').AsString := trim(frmTradeSalesContractSel.CDS_1.Fieldbyname('C_boxss').AsString); // Fieldbyname('C_volume').value := frmTradeSalesContractSel.CDS_1.Fieldbyname('C_volume').AsFloat; // Fieldbyname('C_Tvolume').value := frmTradeSalesContractSel.CDS_1.Fieldbyname('C_Tvolume').AsFloat; Fieldbyname('C_Crate').value := frmTradeSalesContractSel.CDS_1.Fieldbyname('C_Crate').AsFloat; Fieldbyname('C_Code').AsString := trim(frmTradeSalesContractSel.CDS_1.Fieldbyname('C_Code').AsString); Fieldbyname('C_Fabric').AsString := trim(frmTradeSalesContractSel.CDS_1.Fieldbyname('C_Fabric').AsString); Fieldbyname('C_Name').AsString := trim(frmTradeSalesContractSel.CDS_1.Fieldbyname('C_Name').AsString); Fieldbyname('C_Spec').AsString := trim(frmTradeSalesContractSel.CDS_1.Fieldbyname('C_Spec').AsString); Fieldbyname('C_Composition').AsString := trim(frmTradeSalesContractSel.CDS_1.Fieldbyname('C_Composition').AsString); // Fieldbyname('C_Composition').AsFloat := frmTradeSalesContractSel.CDS_1.fieldbyname('C_Composition').AsFloat; Fieldbyname('C_Width').AsString := trim(frmTradeSalesContractSel.CDS_1.Fieldbyname('C_Width').AsString); Fieldbyname('C_GramWeight').AsString := trim(frmTradeSalesContractSel.CDS_1.Fieldbyname('C_GramWeight').AsString); Fieldbyname('OrdUnit').AsString := trim(frmTradeSalesContractSel.CDS_1.fieldbyname('ConUnit').AsString); Fieldbyname('C_Image').AsString := trim(frmTradeSalesContractSel.CDS_1.fieldbyname('C_Image').AsString); Fieldbyname('C_description').AsString := trim(frmTradeSalesContractSel.CDS_1.fieldbyname('C_description').AsString); Fieldbyname('C_EColor').AsString := trim(frmTradeSalesContractSel.CDS_1.fieldbyname('C_EColor').AsString); Fieldbyname('C_StyleNo').AsString := trim(frmTradeSalesContractSel.CDS_1.fieldbyname('C_StyleNo').AsString); Fieldbyname('C_Barcodes').AsString := trim(frmTradeSalesContractSel.CDS_1.fieldbyname('C_Barcodes').AsString); Fieldbyname('C_wrap').AsString := trim(frmTradeSalesContractSel.CDS_1.fieldbyname('C_wrap').AsString); Fieldbyname('C_CJsize').AsString := trim(frmTradeSalesContractSel.CDS_1.fieldbyname('C_CJsize').AsString); Fieldbyname('C_GBmanner').AsString := trim(frmTradeSalesContractSel.CDS_1.fieldbyname('C_GBmanner').AsString); Fieldbyname('OrdSNote').AsString := trim(frmTradeSalesContractSel.CDS_1.fieldbyname('ConSNote').AsString); Fieldbyname('C_consumption').AsFloat := frmTradeSalesContractSel.CDS_1.fieldbyname('C_consumption').AsFloat; Fieldbyname('C_loss').AsFloat := frmTradeSalesContractSel.CDS_1.fieldbyname('C_loss').AsFloat; Fieldbyname('C_quantity').AsFloat := NEWroundto(frmTradeSalesContractSel.CDS_1.Fieldbyname('ConQty').AsFloat * frmTradeSalesContractSel.CDS_1.fieldbyname('C_consumption').AsFloat * (1 + frmTradeSalesContractSel.CDS_1.fieldbyname('C_loss').AsFloat / 100), 0); with ADOTemp do begin Close; Filtered := False; sql.Clear; sql.Add(' select * from Bs_Cloth_Process where BCIID=''' + trim(frmTradeSalesContractSel.CDS_1.fieldbyname('FBCIID').AsString) + ''' and flcategory =''洗标'' '); // showmessage(sql.text); Open; end; Fieldbyname('C_washingN').AsString := trim(ADOTemp.fieldbyname('C_Accessories').AsString); with ADOTemp do begin Close; Filtered := False; sql.Clear; sql.Add(' select * from Bs_Cloth_Process where BCIID=''' + trim(frmTradeSalesContractSel.CDS_1.fieldbyname('FBCIID').AsString) + ''' and flcategory =''包装袋'' '); // showmessage(sql.text); Open; end; Fieldbyname('C_BagS').AsString := trim(ADOTemp.fieldbyname('C_Accessories').AsString); with ADOTemp do begin Close; Filtered := False; sql.Clear; sql.Add(' select * from Bs_Cloth_Process where BCIID=''' + trim(frmTradeSalesContractSel.CDS_1.fieldbyname('FBCIID').AsString) + ''' and flcategory =''彩卡'' '); // showmessage(sql.text); Open; end; Fieldbyname('C_card').AsString := trim(ADOTemp.fieldbyname('C_Accessories').AsString); with ADOTemp do begin Close; Filtered := False; sql.Clear; sql.Add(' select * from Bs_Cloth_Process where BCIID=''' + trim(frmTradeSalesContractSel.CDS_1.fieldbyname('FBCIID').AsString) + ''' and flcategory =''衬板'' '); // showmessage(sql.text); Open; end; Fieldbyname('C_Liners').AsString := trim(ADOTemp.fieldbyname('C_Accessories').AsString); with ADOTemp do begin Close; Filtered := False; sql.Clear; sql.Add(' select * from Bs_Cloth_Process where BCIID=''' + trim(frmTradeSalesContractSel.CDS_1.fieldbyname('FBCIID').AsString) + ''' and flcategory =''衬衫夹'' '); // showmessage(sql.text); Open; end; Fieldbyname('C_shirt').AsString := trim(ADOTemp.fieldbyname('C_Accessories').AsString); with ADOTemp do begin Close; Filtered := False; sql.Clear; sql.Add(' select * from Bs_Cloth_Process where BCIID=''' + trim(frmTradeSalesContractSel.CDS_1.fieldbyname('FBCIID').AsString) + ''' and flcategory =''衬纸'' '); // showmessage(sql.text); Open; end; Fieldbyname('C_paper').AsString := trim(ADOTemp.fieldbyname('C_Accessories').AsString); with ADOTemp do begin Close; Filtered := False; sql.Clear; sql.Add(' select * from Bs_Cloth_Process where BCIID=''' + trim(frmTradeSalesContractSel.CDS_1.fieldbyname('FBCIID').AsString) + ''' and flcategory =''抽带'' '); // showmessage(sql.text); Open; end; Fieldbyname('C_DrawstringM').AsString := trim(ADOTemp.fieldbyname('C_Accessories').AsString); with ADOTemp do begin Close; Filtered := False; sql.Clear; sql.Add(' select * from Bs_Cloth_Process where BCIID=''' + trim(frmTradeSalesContractSel.CDS_1.fieldbyname('FBCIID').AsString) + ''' and flcategory =''皮筋'' '); // showmessage(sql.text); Open; end; Fieldbyname('C_rubberband').AsString := trim(ADOTemp.fieldbyname('C_Accessories').AsString); with ADOTemp do begin Close; Filtered := False; sql.Clear; sql.Add(' select * from Bs_Cloth_Process where BCIID=''' + trim(frmTradeSalesContractSel.CDS_1.fieldbyname('FBCIID').AsString) + ''' and flcategory =''双面胶'' '); // showmessage(sql.text); Open; end; Fieldbyname('C_glue').AsString := trim(ADOTemp.fieldbyname('C_Accessories').AsString); with ADOTemp do begin Close; Filtered := False; sql.Clear; sql.Add(' select * from Bs_Cloth_Process where BCIID=''' + trim(frmTradeSalesContractSel.CDS_1.fieldbyname('FBCIID').AsString) + ''' and flcategory =''说明书'' '); // showmessage(sql.text); Open; end; Fieldbyname('C_Instructions').AsString := trim(ADOTemp.fieldbyname('C_Accessories').AsString); with ADOTemp do begin Close; Filtered := False; sql.Clear; sql.Add(' select * from Bs_Cloth_Process where BCIID=''' + trim(frmTradeSalesContractSel.CDS_1.fieldbyname('FBCIID').AsString) + ''' and flcategory =''贴纸'' '); // showmessage(sql.text); Open; end; Fieldbyname('C_StickersN').AsString := trim(ADOTemp.fieldbyname('C_Accessories').AsString); with ADOTemp do begin Close; Filtered := False; sql.Clear; sql.Add(' select * from Bs_Cloth_Process where BCIID=''' + trim(frmTradeSalesContractSel.CDS_1.fieldbyname('FBCIID').AsString) + ''' and flcategory =''铁圈'' '); // showmessage(sql.text); Open; end; Fieldbyname('C_bandage').AsString := trim(ADOTemp.fieldbyname('C_Accessories').AsString); with ADOTemp do begin Close; Filtered := False; sql.Clear; sql.Add(' select * from Bs_Cloth_Process where BCIID=''' + trim(frmTradeSalesContractSel.CDS_1.fieldbyname('FBCIID').AsString) + ''' and flcategory =''网衬 无纺布'' '); // showmessage(sql.text); Open; end; Fieldbyname('C_fabricsM').AsString := trim(ADOTemp.fieldbyname('C_Accessories').AsString); with ADOTemp do begin Close; Filtered := False; sql.Clear; sql.Add(' select * from Bs_Cloth_Process where BCIID=''' + trim(frmTradeSalesContractSel.CDS_1.fieldbyname('FBCIID').AsString) + ''' and flcategory =''衣架'' '); // showmessage(sql.text); Open; end; Fieldbyname('C_Hooking').AsString := trim(ADOTemp.fieldbyname('C_Accessories').AsString); with ADOTemp do begin Close; Filtered := False; sql.Clear; sql.Add(' select * from Bs_Cloth_Process where BCIID=''' + trim(frmTradeSalesContractSel.CDS_1.fieldbyname('FBCIID').AsString) + ''' and flcategory =''粘衬'' '); // showmessage(sql.text); Open; end; Fieldbyname('C_liningM').AsString := trim(ADOTemp.fieldbyname('C_Accessories').AsString); with ADOTemp do begin Close; Filtered := False; sql.Clear; sql.Add(' select * from Bs_Cloth_Process where BCIID=''' + trim(frmTradeSalesContractSel.CDS_1.fieldbyname('FBCIID').AsString) + ''' and flcategory =''纸箱'' '); // showmessage(sql.text); Open; end; Fieldbyname('C_boxs').AsString := trim(ADOTemp.fieldbyname('C_Accessories').AsString); with ADOTemp do begin Close; Filtered := False; sql.Clear; sql.Add(' select * from Bs_Cloth_Process where BCIID=''' + trim(frmTradeSalesContractSel.CDS_1.fieldbyname('FBCIID').AsString) + ''' and flcategory =''自封袋'' '); // showmessage(sql.text); Open; end; Fieldbyname('C_bag').AsString := trim(ADOTemp.fieldbyname('C_Accessories').AsString); with ADOTemp do begin Close; Filtered := False; sql.Clear; sql.Add(' select * from Bs_Cloth_Process where BCIID=''' + trim(frmTradeSalesContractSel.CDS_1.fieldbyname('FBCIID').AsString) + ''' and flcategory =''其他辅料'' '); // showmessage(sql.text); Open; end; Fieldbyname('C_QTFL').AsString := trim(ADOTemp.fieldbyname('C_Accessories').AsString); Post; //FC_quantity := NEWroundto(frmTradeSalesContractSel.CDS_1.Fieldbyname('ConQty').AsFloat * frmTradeSalesContractSel.CDS_1.fieldbyname('C_Composition').AsFloat * (1 + frmTradeSalesContractSel.CDS_1.fieldbyname('C_loss').AsFloat / 100), 0); end; CDS_1.Edit; CDS_1.fieldbyname('SSel').value := false; end; end; end; finally frmTradeSalesContractSel.Free; end; end; procedure TfrmTradePlanInPut.ScrollBox1Click(Sender: TObject); begin OrdDate.SetFocus; end; procedure TfrmTradePlanInPut.OurCoNameBtnDnClick(Sender: TObject); begin TBtnEditC(Sender).Text := ''; TBtnEditC(Sender).TxtCode := ''; end; procedure TfrmTradePlanInPut.OurCoNameBtnUpClick(Sender: TObject); begin try frmCompanySel := TfrmCompanySel.Create(Application); with frmCompanySel do begin FCoType := '我司'; if ShowModal = 1 then begin self.OurCoName.TxtCode := Trim(frmCompanySel.CDS_1.fieldbyname('CoCode').AsString); self.OurCoName.Text := Trim(frmCompanySel.CDS_1.fieldbyname('CoAbbrName').AsString); end; end; finally frmCompanySel.Free; end; end; procedure TfrmTradePlanInPut.SYRNameBtnUpClick(Sender: TObject); var fsj: string; FWZ: Integer; begin fsj := Trim(TEdit(Sender).Hint); FWZ := Pos('/', fsj); try frmZDYHelp := TfrmZDYHelp.Create(Application); with frmZDYHelp do begin fnote := True; flag := Copy(fsj, 1, FWZ - 1); flagname := Copy(fsj, FWZ + 1, Length(fsj) - FWZ); if ShowModal = 1 then begin TEdit(Sender).Text := Trim(ClientDataSet1.fieldbyname('ZDYName').AsString); end; end; finally frmZDYHelp.Free; end; end; procedure TfrmTradePlanInPut.Tv1Column13PropertiesButtonClick(Sender: TObject; AButtonIndex: Integer); begin // inherited; try frmCloInfoFileUp := TfrmCloInfoFileUp.Create(Application); with frmCloInfoFileUp do begin Code.Text := Trim(Self.CDS_1.fieldbyname('C_Name').AsString); FBCIID := Trim(Self.CDS_1.fieldbyname('ConSId').AsString); if ShowModal = 1 then begin // Self.InitGrid(); // Self.CDS_1.Locate('BCIID', BCIID, []); CDS_1.edit; CDS_1.fieldbyname('C_Image').value := Trim(ADOQueryFile.fieldbyname('FileName').AsString); CDS_1.Post; end; end; finally frmCloInfoFileUp.Free; end; tv1.Controller.EditingController.ShowEdit(); end; procedure TfrmTradePlanInPut.Tv1Column1PropertiesButtonClick(Sender: TObject; AButtonIndex: Integer); begin inherited; try frmClothInfoSel := TfrmClothInfoSel.Create(Application); with frmClothInfoSel do begin if ShowModal = 1 then begin self.CDS_1.Edit; self.CDS_1.Fieldbyname('C_Code').AsString := trim(frmClothInfoSel.CDS_1.Fieldbyname('C_Code').AsString); self.CDS_1.Fieldbyname('C_Name').AsString := trim(frmClothInfoSel.CDS_1.Fieldbyname('C_Name').AsString); Self.CDS_1.Fieldbyname('C_Spec').AsString := trim(frmClothInfoSel.CDS_1.Fieldbyname('C_Spec').AsString); Self.CDS_1.Fieldbyname('C_Composition').AsString := trim(frmClothInfoSel.CDS_1.Fieldbyname('C_Composition').AsString); Self.CDS_1.Fieldbyname('C_Width').AsString := trim(frmClothInfoSel.CDS_1.Fieldbyname('C_Width').AsString); Self.CDS_1.Fieldbyname('C_GramWeight').AsString := trim(frmClothInfoSel.CDS_1.Fieldbyname('C_GramWeight').AsString); Self.CDS_1.Fieldbyname('C_Pattern').AsString := trim(frmClothInfoSel.CDS_1.Fieldbyname('C_Pattern').AsString); Self.CDS_1.Fieldbyname('C_consumption').AsFloat := frmClothInfoSel.CDS_1.Fieldbyname('C_consumption').AsFloat; Self.CDS_1.Fieldbyname('C_loss').AsFloat := frmClothInfoSel.CDS_1.Fieldbyname('C_loss').AsFloat; self.cds_1.post; end; end; finally frmClothInfoSel.Free; end; end; procedure TfrmTradePlanInPut.TextEdit(Sender: TObject); var mvalue, FFieldName, FC_volume, FZC: string; FOrdQty, FC_consumption, FC_loss, FC_quantity, FC_Crate, FC_Tvolume, FC_box, FC_liningM: Double; // mvalue, FFieldName, FC_volume: string; // FConQty, FConPrice, FC_Money, FC_Crate, FC_box, FC_Tvolume: Double; begin // inherited; mvalue := TcxTextEdit(Sender).EditingText; if Trim(mvalue) = '' then begin mvalue := '0'; end; FFieldName := Trim(Tv1.Controller.FocusedColumn.DataBinding.FilterFieldName); with CDS_1 do begin Edit; FieldByName(FFieldName).value := Trim(mvalue); Post; // FOrdQty := Fieldbyname('OrdQty').AsFloat; // FC_consumption := Fieldbyname('C_consumption').AsFloat; // FC_loss := Fieldbyname('C_loss').AsFloat; // // FC_Crate := Fieldbyname('C_Crate').AsFloat; // FC_box := Fieldbyname('C_box').AsFloat; //// FC_volume := Fieldbyname('C_volume').AsFloat; // FC_volume := ADOTemp.Fieldbyname('TJ').AsString; end; with ADOTemp1 do //CDS_1.Fieldbyname('C_boxs').AsString begin Close; Filtered := False; sql.Clear; sql.add('select TJ=(select cast(RTValue AS FLOAT) from [dbo].[F_Tool_SplitString]('' ' + CDS_1.Fieldbyname('C_boxs').AsString + ' '',''*'') where KeyNo=1)'); sql.add('*(select cast(RTValue AS FLOAT) from [dbo].[F_Tool_SplitString]('' ' + CDS_1.Fieldbyname('C_boxs').AsString + ' '',''*'') where KeyNo=2)'); sql.add('*(select cast(RTValue AS FLOAT) from [dbo].[F_Tool_SplitString]('' ' + CDS_1.Fieldbyname('C_boxs').AsString + ' '',''*'') where KeyNo=3)'); // showmessage(sql.text); Open; end; // with ADOTemp do //CDS_1.Fieldbyname('C_boxs').AsString // begin // Close; // Filtered := False; // sql.Clear; // sql.add('select ZC=(select cast(RTValue AS FLOAT) from [dbo].[F_Tool_SplitString]('' ' + CDS_1.Fieldbyname('C_Spec').AsString + ' '',''*'') where KeyNo=1)'); //// sql.add('*(select cast(RTValue AS FLOAT) from [dbo].[F_Tool_SplitString]('' ' + CDS_1.Fieldbyname('C_boxs').AsString + ' '',''*'') where KeyNo=2)'); //// sql.add('*(select cast(RTValue AS FLOAT) from [dbo].[F_Tool_SplitString]('' ' + CDS_1.Fieldbyname('C_boxs').AsString + ' '',''*'') where KeyNo=3)'); //// showmessage(sql.text); // Open; // end; with CDS_1 do begin // Edit; // FieldByName(FFieldName).value := Trim(mvalue); // Post; FOrdQty := Fieldbyname('OrdQty').AsFloat; FC_consumption := Fieldbyname('C_consumption').AsFloat; FC_loss := Fieldbyname('C_loss').AsFloat; FC_Crate := Fieldbyname('C_Crate').AsFloat; FC_box := Fieldbyname('C_box').AsFloat; // FC_volume := Fieldbyname('C_volume').AsFloat; // if Fieldbyname('C_boxs').AsString = '' then FC_volume := ADOTemp1.Fieldbyname('TJ').AsString; // FZC := ADOTemp.Fieldbyname('ZC').AsString; // end; // FC_Tvolume := RoundFloat(FC_box * FC_volume, 2); // FC_quantity := FOrdQty * (1 + FC_consumption/100) * (1 + FC_loss/100); FC_quantity := NEWroundto(FOrdQty * FC_consumption * (1 + FC_loss / 100), 0); // FC_liningM := ceil(strtofloat(FZC) / 100 * 1.03 * FOrdQty); if FC_Crate = 0 then begin FC_Crate := 1; end; if Trim(FC_volume) = '' then begin FC_volume := '1'; end; // FC_box := RoundFloat(FOrdQty / FC_Crate, 2); //箱数 FC_Tvolume := (FC_box * strtofloat(FC_volume)) / 1000000; //总体积 with CDS_1 do begin Edit; FieldByName('OrdQty').value := FOrdQty; FieldByName('C_consumption').value := FC_consumption; FieldByName('C_loss').value := FC_loss; FieldByName('C_quantity').value := FC_quantity; FieldByName('C_box').value := FC_box; // FieldByName('C_box').Value := FC_box; FieldByName('C_volume').value := floattostr(strtofloat(FC_volume) / 1000000); FieldByName('C_Tvolume').value := FC_Tvolume; // if Fieldbyname('NC_lining').AsString = '' then // begin // FieldByName('C_liningM').value := FC_liningM; // end; Post; end; tv1.Controller.EditingController.ShowEdit(); end; procedure TfrmTradePlanInPut.Tv1Column4PropertiesButtonClick(Sender: TObject; AButtonIndex: Integer); begin frmClothInfoSel := TfrmClothInfoSel.Create(self); with frmClothInfoSel do begin if showmodal = 1 then begin CDS_1.Edit; CDS_1.fieldbyname('MPRTCode').value := CDS_1.fieldbyname('CYNO').asstring; CDS_1.fieldbyname('MPRTCodeName').value := CDS_1.fieldbyname('CYName').asstring; CDS_1.fieldbyname('MPRTSpec').value := CDS_1.fieldbyname('CYSpec').asstring; CDS_1.fieldbyname('MPRTCF').value := CDS_1.fieldbyname('CYCF').asstring; CDS_1.fieldbyname('PRTColor').value := CDS_1.fieldbyname('CYColor').asstring; CDS_1.fieldbyname('PRTHX').value := CDS_1.fieldbyname('CYHX').asstring; CDS_1.fieldbyname('MPRTMF').value := CDS_1.fieldbyname('CYMF').asstring; CDS_1.fieldbyname('MPRTKZ').value := CDS_1.fieldbyname('CYKZ').asstring; CDS_1.fieldbyname('OrderUnit').value := CDS_1.fieldbyname('CYPUnit').asstring; CDS_1.fieldbyname('SuoLv').value := CDS_1.fieldbyname('SuoLv').asstring; CDS_1.fieldbyname('GcHuaNo').value := CDS_1.fieldbyname('GcHua').asstring; CDS_1.fieldbyname('GsHuaNo').value := CDS_1.fieldbyname('GsHua').asstring; CDS_1.Post; end; free; end; end; procedure TfrmTradePlanInPut.Tv1MouseDown(Sender: TObject; Button: TMouseButton; Shift: TShiftState; X, Y: Integer); begin // InitImageHX(); end; procedure TfrmTradePlanInPut.v1Column5PropertiesEditValueChanged(Sender: TObject); var mvalue, FFieldName: string; begin mvalue := TcxTextEdit(Sender).EditingText; FFieldName := Trim(Tv1.Controller.FocusedColumn.DataBinding.FilterFieldName); with CDS_1 do begin Edit; FieldByName(FFieldName).value := mvalue; FieldByName('MGMainId').value := ''; Post; end; Tv1.Controller.EditingController.ShowEdit(); end; procedure TfrmTradePlanInPut.HYTTBtnUpClick(Sender: TObject); var fsj: string; FWZ: Integer; begin fsj := Trim(TEdit(Sender).Hint); FWZ := Pos('/', fsj); try frmZDYHelp := TfrmZDYHelp.Create(Application); with frmZDYHelp do begin flag := Copy(fsj, 1, FWZ - 1); flagname := Copy(fsj, FWZ + 1, Length(fsj) - FWZ); if ShowModal = 1 then begin TEdit(Sender).Text := Trim(ClientDataSet1.fieldbyname('ZDYName').AsString); end; end; finally frmZDYHelp.Free; end; end; procedure TfrmTradePlanInPut.KYTTBtnUpClick(Sender: TObject); var fsj: string; FWZ: Integer; begin fsj := Trim(TEdit(Sender).Hint); FWZ := Pos('/', fsj); try frmZDYHelp := TfrmZDYHelp.Create(Application); with frmZDYHelp do begin flag := Copy(fsj, 1, FWZ - 1); flagname := Copy(fsj, FWZ + 1, Length(fsj) - FWZ); if Trim(flag) = 'OrdDefStr2' then begin V1Name.Caption := '中文名称'; V1Note.Caption := '英文名称'; fnote := True; end; if ShowModal = 1 then begin TEdit(Sender).Text := Trim(ClientDataSet1.fieldbyname('ZDYName').AsString); end; end; finally frmZDYHelp.Free; end; end; end.