D7myYunxiang/云翔生产管理(MYSC.dll)/U_BPZdy_LRTJ.pas
DESKTOP-E401PHE\Administrator 1011cb7292 1
2025-01-20 13:04:03 +08:00

1009 lines
28 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_BPZdy_LRTJ;
interface
uses
Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
Dialogs, cxStyles, cxCustomData, cxGraphics, cxFilter, cxData,
cxDataStorage, cxEdit, DB, cxDBData, ToolWin, ComCtrls,
cxGridCustomTableView, cxGridTableView, cxGridDBTableView, cxGridLevel,
cxClasses, cxControls, cxGridCustomView, cxGrid, DBClient, ADODB, ImgList,
StdCtrls, ExtCtrls, cxTextEdit, cxGridCustomPopupMenu, cxGridPopupMenu,
cxButtonEdit, BtnEdit, cxLookAndFeels, cxLookAndFeelPainters, cxNavigator;
type
TfrmBPZDY_LRTJ = class(TForm)
ToolBar1: TToolBar;
ADOQueryMain: TADOQuery;
ADOQueryTemp: TADOQuery;
ADOQueryCmd: TADOQuery;
DataSource1: TDataSource;
ClientDataSet1: TClientDataSet;
TBAdd: TToolButton;
TBDel: TToolButton;
ADOConnection1: TADOConnection;
ThreeImgList: TImageList;
cxGridPopupMenu2: TcxGridPopupMenu;
DataSource2: TDataSource;
ML_GYS: TClientDataSet;
cxGrid3: TcxGrid;
Tv3: TcxGridDBTableView;
cxGridLevel2: TcxGridLevel;
cxGridPopupMenu3: TcxGridPopupMenu;
DataSource3: TDataSource;
ML_GX: TClientDataSet;
v3XHNo: TcxGridDBColumn;
v3GYCode: TcxGridDBColumn;
v3GYName: TcxGridDBColumn;
Panel3: TPanel;
cxGrid1: TcxGrid;
TV1: TcxGridDBTableView;
V1Ssel: TcxGridDBColumn;
V1GYCode: TcxGridDBColumn;
V1GYName: TcxGridDBColumn;
cxGrid1Level1: TcxGridLevel;
cxGridPopupMenu1: TcxGridPopupMenu;
DataSource4: TDataSource;
ZDY_HGY: TClientDataSet;
Panel2: TPanel;
Label3: TLabel;
Label4: TLabel;
Label5: TLabel;
Label6: TLabel;
ZGYName: TEdit;
ZGYCode: TEdit;
GYName: TEdit;
GYCode: TEdit;
Button1: TButton;
Panel5: TPanel;
ToolBar3: TToolBar;
ToolButton7: TToolButton;
ToolButton8: TToolButton;
cxGrid4: TcxGrid;
TV4: TcxGridDBTableView;
cxGridDBColumn1: TcxGridDBColumn;
cxGridDBGYCode: TcxGridDBColumn;
cxGridDBGYName: TcxGridDBColumn;
cxGridLevel3: TcxGridLevel;
Panel4: TPanel;
Label7: TLabel;
Label8: TLabel;
Label9: TLabel;
Label10: TLabel;
HGYNameM: TEdit;
HGYCodeM: TEdit;
GYNameM: TEdit;
GYCodeM: TEdit;
Button2: TButton;
Panel7: TPanel;
Label2: TLabel;
CDS_LS: TClientDataSet;
V1GYNameQC: TcxGridDBColumn;
V4GYNameQC: TcxGridDBColumn;
Label11: TLabel;
GYNameQC: TEdit;
Label13: TLabel;
GYNameQCM: TEdit;
v3GYNameQC: TcxGridDBColumn;
Panel8: TPanel;
Label14: TLabel;
Panel1: TPanel;
Label12: TLabel;
DASH: TBtnEditA;
procedure FormCreate(Sender: TObject);
procedure FormClose(Sender: TObject; var Action: TCloseAction);
procedure TBAddClick(Sender: TObject);
procedure TBSaveClick(Sender: TObject);
procedure TBDelClick(Sender: TObject);
procedure FormShow(Sender: TObject);
procedure TV1CellDblClick(Sender: TcxCustomGridTableView;
ACellViewInfo: TcxGridTableDataCellViewInfo; AButton: TMouseButton;
AShift: TShiftState; var AHandled: Boolean);
procedure V1NotePropertiesEditValueChanged(Sender: TObject);
procedure V1HelpTypePropertiesEditValueChanged(Sender: TObject);
procedure v1note1PropertiesEditValueChanged(Sender: TObject);
procedure V1BPCodePropertiesEditValueChanged(Sender: TObject);
procedure ToolButton4Click(Sender: TObject);
procedure ToolButton5Click(Sender: TObject);
procedure Tv3CellDblClick(Sender: TcxCustomGridTableView;
ACellViewInfo: TcxGridTableDataCellViewInfo; AButton: TMouseButton;
AShift: TShiftState; var AHandled: Boolean);
procedure DASHBtnClick(Sender: TObject);
procedure V1BPNamePropertiesButtonClick(Sender: TObject;
AButtonIndex: Integer);
procedure ToolButton7Click(Sender: TObject);
procedure ToolButton8Click(Sender: TObject);
procedure ToolButton6Click(Sender: TObject);
procedure TV4CellDblClick(Sender: TcxCustomGridTableView;
ACellViewInfo: TcxGridTableDataCellViewInfo; AButton: TMouseButton;
AShift: TShiftState; var AHandled: Boolean);
procedure Button1Click(Sender: TObject);
procedure Button2Click(Sender: TObject);
procedure TV1MouseDown(Sender: TObject; Button: TMouseButton;
Shift: TShiftState; X, Y: Integer);
procedure TV4MouseDown(Sender: TObject; Button: TMouseButton;
Shift: TShiftState; X, Y: Integer);
procedure FormDestroy(Sender: TObject);
private
FBPID,FMXBPID:string;
procedure InitGrid();
procedure SaveData();
procedure HGYSaveData();
procedure HGYInitGrid();
procedure UPDateML();
{ Private declarations }
public
flag,flagname,snote,MainType,FGYName,Fint,canshu1,formid:string;
fnote,fnote1,forderno,fZdyFlag,ViewFlag,fHelpType:Boolean;
PPSTE:integer;
{ Public declarations }
end;
var
frmBPZDY_LRTJ: TfrmBPZDY_LRTJ;
implementation
uses
U_DataLink,U_Fun10,U_BPZdy_SH, U_BPZdy_HXK,U_ZDYHelp;
{$R *.dfm}
procedure TfrmBPZDY_LRTJ.UPDateML();
begin
with ADOQueryCmd do
begin
close;
sql.Clear;
sql.Add('update ML_Manage set GYLXName=dbo.F_Get_Order_SubStr(MLID,''GXName'')');
sql.Add(' where exists (select GYID from ML_Manage_GX where MLID=ML_Manage.MLID ');
sql.Add(' and GYID='''+trim(ClientDataSet1.fieldbyname('GYID').AsString)+''')');
ExecSQL;
end;
end;
procedure TfrmBPZDY_LRTJ.SaveData();
var maxno:string;
begin
try
ADOQueryCmd.Connection.BeginTrans;
if FBPID='' then
begin
if GetLSNo(ADOQueryTemp,FBPID,'GY','GY_ZDY',3,1)=False then
begin
ADOQueryCmd.Connection.RollbackTrans;
Application.MessageBox(<><C8A1><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ʧ<EFBFBD>ܣ<EFBFBD>','<27><>ʾ',0);
Exit;
end;
end;
with ADOQueryCmd do
begin
Close;
sql.Clear;
sql.Add('select * from GY_ZDY where GYID='''+Trim(FBPID)+'''');
Open;
end;
if ADOQueryCmd.IsEmpty then
begin
ADOQueryCmd.Append;
ADOQueryCmd.FieldByName('fillcode').Value:=trim(DCode);
ADOQueryCmd.FieldByName('filler').Value:=trim(DName);
end
else
begin
ADOQueryCmd.Edit;
end;
ADOQueryCmd.FieldByName('GYID').Value:=Trim(FBPID);
SSetsaveSqlNew(ADOQueryCmd,'GY_ZDY',panel2,2);
ADOQueryCmd.FieldByName('GYType').Value:=flagName;
ADOQueryCmd.FieldByName('GYFlag').Value:=flag;
ADOQueryCmd.FieldByName('valid').Value:='Y';
ADOQueryCmd.Post;
with ADOQueryTemp do
begin
Close;
sql.Clear;
sql.add('select * from GY_ZDY where GYCode='''+Trim(GYCode.Text)+'''');
sql.Add(' and GYFlag='''+trim(flag)+'''');
Open;
end;
if ADOQueryTemp.IsEmpty=False then
begin
if ADOQueryTemp.RecordCount>1 then
begin
ADOQueryCmd.Connection.RollbackTrans;
Application.MessageBox('<27>̽<EFBFBD><CCBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ظ<EFBFBD><D8B8><EFBFBD>','<27><>ʾ',0);
Exit;
end;
end;
with ADOQueryTemp do
begin
Close;
sql.Clear;
sql.add('select * from GY_ZDY where GYName='''+Trim(GYName.Text)+'''');
sql.Add(' and GYFlag='''+trim(flag)+'''');
Open;
end;
if ADOQueryTemp.IsEmpty=False then
begin
if ADOQueryTemp.RecordCount>1 then
begin
with ADOQueryCmd do
begin
Close;
sql.Clear;
SQL.Add('delete GY_ZDY where GYID='''+Trim(FBPID)+'''');
ExecSQL;
end;
ADOQueryCmd.Connection.RollbackTrans;
Application.MessageBox('<27>̽<EFBFBD><CCBD><EFBFBD><EFBFBD>ƣ<EFBFBD>','<27><>ʾ',0);
Exit;
end;
end;
with ClientDataSet1 do
begin
if Button1.Caption<><><C8B7><EFBFBD>޸<EFBFBD>' then
Append
else
edit;
FieldByName('GYID').Value:=Trim(FBPID);
FieldByName('GYCode').Value:=Trim(GYCode.Text);
FieldByName('GYName').Value:=Trim(GYName.Text);
FieldByName('GYNameQC').Value:=Trim(GYNameQC.Text);
post;
end;
UPDateML();
GYCode.Text:='';
GYName.Text:='';
GYNameQC.Text:='';
FBPID:='';
ADOQueryCmd.Connection.CommitTrans;
except;
ADOQueryCmd.Connection.RollbackTrans;
Application.MessageBox('<27><><EFBFBD><EFBFBD>ʧ<EFBFBD>ܣ<EFBFBD>','<27><>ʾ',0);
end;
end;
procedure TfrmBPZDY_LRTJ.HGYSaveData();
var maxno:string;
begin
try
ADOQueryCmd.Connection.BeginTrans;
if FMXBPID='' then
begin
if GetLSNo(ADOQueryTemp,FMXBPID,'BP','GY_ZDY',3,1)=False then
begin
ADOQueryCmd.Connection.RollbackTrans;
Application.MessageBox(<><C8A1><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ʧ<EFBFBD>ܣ<EFBFBD>','<27><>ʾ',0);
Exit;
end;
end;
with ADOQueryCmd do
begin
Close;
sql.Clear;
sql.Add('select * from GY_ZDY where GYID='''+Trim(FMXBPID)+'''');
Open;
end;
if ADOQueryCmd.IsEmpty then
begin
ADOQueryCmd.Append;
ADOQueryCmd.FieldByName('Filler').Value:=Trim(Dname);
ADOQueryCmd.FieldByName('Fillcode').Value:=Trim(DCode);
end
else
begin
ADOQueryCmd.Edit;
end;
ADOQueryCmd.FieldByName('GYID').Value:=Trim(FMXBPID);
ADOQueryCmd.FieldByName('GYType').Value:=flagName;
ADOQueryCmd.FieldByName('GYFlag').Value:=flag;
ADOQueryCmd.FieldByName('valid').Value:='Y';
ADOQueryCmd.FieldByName('GYType').Value:='HGY';
ADOQueryCmd.FieldByName('ZGYCode').Value:='T';
ADOQueryCmd.FieldByName('ZGYName').Value:='<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>';
ADOQueryCmd.FieldByName('GYCode').Value:=GYCodeM.Text;
ADOQueryCmd.FieldByName('GYName').Value:=GYNameM.Text;
ADOQueryCmd.FieldByName('GYNameQC').Value:=GYNameQCM.Text;
ADOQueryCmd.Post;
with ADOQueryTemp do
begin
Close;
sql.Clear;
sql.add('select * from GY_ZDY where GYCode='''+Trim(GYCodeM.Text)+'''');
sql.Add(' and GYFlag='''+trim(flag)+'''');
Open;
end;
if ADOQueryTemp.IsEmpty=False then
begin
if ADOQueryTemp.RecordCount>1 then
begin
with ADOQueryCmd do
begin
Close;
sql.Clear;
SQL.Add('delete GY_ZDY where GYID='''+Trim(FMXBPID)+'''');
ExecSQL;
end;
ADOQueryCmd.Connection.RollbackTrans;
Application.MessageBox('<27><><EFBFBD><EFBFBD><EFBFBD>մ<EFBFBD><D5B4><EFBFBD><EFBFBD>ظ<EFBFBD><D8B8><EFBFBD>','<27><>ʾ',0);
Exit;
end;
end;
with ADOQueryTemp do
begin
Close;
sql.Clear;
sql.add('select * from GY_ZDY where GYName='''+Trim(GYName.Text)+'''');
sql.Add(' and GYFlag='''+trim(flag)+'''');
Open;
end;
if ADOQueryTemp.IsEmpty=False then
begin
if ADOQueryTemp.RecordCount>1 then
begin
with ADOQueryCmd do
begin
Close;
sql.Clear;
SQL.Add('delete GY_ZDY where GYID='''+Trim(FMXBPID)+'''');
ExecSQL;
end;
ADOQueryCmd.Connection.RollbackTrans;
Application.MessageBox('<27><><EFBFBD><EFBFBD><EFBFBD>ռ<EFBFBD><D5BC><EFBFBD><EFBFBD>ظ<EFBFBD><D8B8><EFBFBD>','<27><>ʾ',0);
Exit;
end;
end;
with ZDY_HGY do
begin
if Button2.Caption<><><C8B7><EFBFBD>޸<EFBFBD>' then
Append
else
edit;
FieldByName('GYID').Value:=Trim(FMXBPID);
FieldByName('ZGYCode').Value:='T';
FieldByName('ZGYName').Value:='<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>';
FieldByName('GYCode').Value:=Trim(GYCodeM.Text);
FieldByName('GYName').Value:=Trim(GYNameM.Text);
FieldByName('GYNameQC').Value:=Trim(GYNameQCM.Text);
post;
end;
with ADOQueryCmd do
begin
close;
sql.Clear;
sql.Add('update ML_Manage set GYLXName=dbo.F_Get_Order_SubStr(MLID,''GXName'')');
sql.Add(' where exists (select GYID from ML_Manage_GX where MLID=ML_Manage.MLID ');
sql.Add(' and GYID='''+trim(ZDY_HGY.fieldbyname('GYID').AsString)+''')');
ExecSQL;
end;
GYCodeM.Text:='';
GYNameM.Text:='';
GYNameQCM.Text:='';
FMXBPID:='';
ADOQueryCmd.Connection.CommitTrans;
except;
ADOQueryCmd.Connection.RollbackTrans;
Application.MessageBox('<27><><EFBFBD><EFBFBD>ʧ<EFBFBD>ܣ<EFBFBD>','<27><>ʾ',0);
end;
end;
procedure TfrmBPZDY_LRTJ.FormCreate(Sender: TObject);
begin
try
//cxGrid1.Align:=alClient;
with ADOConnection1 do
begin
Connected:=false;
ConnectionString:=DConString;
//ConnectionString:='';
Connected:=true;
end;
except;
frmBPZDY_LRTJ.Free;
end;
canshu1:=Trim(DParameters1);
end;
procedure TfrmBPZDY_LRTJ.FormClose(Sender: TObject;
var Action: TCloseAction);
begin
ToolBar1.SetFocus;
WriteCxGrid('<27>Զ<EFBFBD><D4B6><EFBFBD>'+Trim(flag)+'14',TV4,'<27>Զ<EFBFBD><D4B6><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>');
WriteCxGrid('<27>Զ<EFBFBD><D4B6><EFBFBD>'+Trim(flag)+'12',TV3,'<27>Զ<EFBFBD><D4B6><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>');
WriteCxGrid('<27>Զ<EFBFBD><D4B6><EFBFBD>'+Trim(flag)+'121',TV1,'<27>Զ<EFBFBD><D4B6><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>');
Action:=caFree;
end;
procedure TfrmBPZDY_LRTJ.HGYInitGrid();
begin
try
ADOQueryMain.DisableControls;
with ADOQueryMain do
begin
Close;
sql.Clear;
sql.Add('select A.* from GY_ZDY A where A.GYFlag='''+trim(flag)+'''');
sql.Add(' and isnull(GYType,'''')=''HGY''');
Open;
end;
SCreateCDS20(ADOQueryMain,ZDY_HGY);
SInitCDSData20(ADOQueryMain,ZDY_HGY);
finally
ADOQueryMain.EnableControls;
end;
end;
procedure TfrmBPZDY_LRTJ.InitGrid();
begin
try
ADOQueryMain.DisableControls;
with ADOQueryMain do
begin
Close;
sql.Clear;
sql.Add('select A.* from GY_ZDY A where A.GYFlag='''+trim(flag)+'''');
sql.Add(' and isnull(GYType,'''')=''<27>̽<EFBFBD>''');
Open;
end;
SCreateCDS20(ADOQueryMain,ClientDataSet1);
SInitCDSData20(ADOQueryMain,ClientDataSet1);
if ML_GX.IsEmpty then
begin
SCreateCDS20(ADOQueryMain,ML_GX);
end;
finally
ADOQueryMain.EnableControls;
end;
end;
procedure TfrmBPZDY_LRTJ.TBAddClick(Sender: TObject);
var
i:Integer;
maxno,FH:string;
begin
toolbar1.SetFocus;
panel2.visible:=true;
FBPID:='';
Button1.Caption:=<><C8B7><EFBFBD><EFBFBD><EFBFBD><EFBFBD>';
GYCode.Text:='';
GYName.Text:='';
GYNameQC.Text:='';
end;
procedure TfrmBPZDY_LRTJ.TBSaveClick(Sender: TObject);
var
maxno:string;
begin
if ClientDataSet1.IsEmpty then Exit;
Toolbar1.SetFocus;
if ClientDataSet1.Locate('BPCode',null,[]) then
begin
Application.MessageBox('<27><><EFBFBD>Ų<EFBFBD><C5B2><EFBFBD>Ϊ<EFBFBD>գ<EFBFBD>','<27><>ʾ',0);
Exit;
end;
if ClientDataSet1.Locate('BPCode','',[]) then
begin
Application.MessageBox('<27><><EFBFBD>Ų<EFBFBD><C5B2><EFBFBD>Ϊ<EFBFBD>գ<EFBFBD>','<27><>ʾ',0);
Exit;
end;
if ClientDataSet1.Locate('BPName',null,[]) then
begin
Application.MessageBox('<27><><EFBFBD>Ʋ<EFBFBD><C6B2><EFBFBD>Ϊ<EFBFBD>գ<EFBFBD>','<27><>ʾ',0);
Exit;
end;
if ClientDataSet1.Locate('BPName','',[]) then
begin
Application.MessageBox('<27><><EFBFBD>Ʋ<EFBFBD><C6B2><EFBFBD>Ϊ<EFBFBD>գ<EFBFBD>','<27><>ʾ',0);
Exit;
end;
SaveData();
Application.MessageBox('<27><><EFBFBD><EFBFBD><EFBFBD>ɹ<EFBFBD><C9B9><EFBFBD>','<27><>ʾ',0);
end;
procedure TfrmBPZDY_LRTJ.TBDelClick(Sender: TObject);
begin
ToolBar1.SetFocus;
if ClientDataSet1.IsEmpty then Exit;
if Trim(ClientDataSet1.FieldByName('GYID').AsString)<>'' then
begin
if application.MessageBox(<><C8B7>Ҫɾ<D2AA><C9BE><EFBFBD><EFBFBD>?','<27><>ʾ<EFBFBD><CABE>Ϣ',1)=2 then exit;
with ADOQueryCmd do
begin
Close;
sql.Clear;
sql.Add('delete GY_ZDY where GYID='''+Trim(ClientDataSet1.fieldbyname('GYID').AsString)+'''');
ExecSQL;
end;
end;
ClientDataSet1.Delete;
GYCode.Text:='';
GYName.Text:='';
GYNameQC.Text:='';
end;
procedure TfrmBPZDY_LRTJ.FormShow(Sender: TObject);
begin
InitGrid();
HGYInitgrid();
ReadCxGrid('<27>Զ<EFBFBD><D4B6><EFBFBD>'+Trim(flag)+'14',TV4,'<27>Զ<EFBFBD><D4B6><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>');
ReadCxGrid('<27>Զ<EFBFBD><D4B6><EFBFBD>'+Trim(flag)+'12',TV3,'<27>Զ<EFBFBD><D4B6><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>');
ReadCxGrid('<27>Զ<EFBFBD><D4B6><EFBFBD>'+Trim(flag)+'121',TV1,'<27>Զ<EFBFBD><D4B6><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>');
if formid='1' then
begin
cxGrid3.Visible:=false;
Panel3.Align:=alClient;
FGYName:='<27>̽<EFBFBD>';
Label12.Visible:=false;
DASH.Visible:=false;
end;
if canshu1='<27><>ѯ' then
begin
TBAdd.Visible:=false;
TBDel.Visible:=false;
ToolButton7.Visible:=false;
ToolButton8.Visible:=false;
button1.Visible:=false;
Button2.Visible:=false;
end
else
begin
TBAdd.Visible:=true;
TBDel.Visible:=true;
ToolButton7.Visible:=true;
ToolButton8.Visible:=true;
button1.Visible:=true;
Button2.Visible:=true;
end;
if ViewFlag=True then
begin
TBAdd.Visible:=False;
TBDel.Visible:=False;
button2.Visible:=true;
Button1.Visible:=False;
ToolButton7.Visible:=False;
ToolButton8.Visible:=False;
end;
if ML_GX.IsEmpty=False then
begin
with ClientDataSet1 do
begin
First;
while not eof do
begin
if ML_GX.Locate('GYName',Trim(ClientDataSet1.fieldbyname('GYName').AsString),[])=True then
begin
ClientDataSet1.Delete;
end else
begin
Next;
end;
end;
end;
with ZDY_HGY do
begin
First;
while not eof do
begin
if ML_GX.Locate('GYName',Trim(ZDY_HGY.fieldbyname('GYName').AsString),[])=True then
begin
ZDY_HGY.Delete;
end else
begin
Next;
end;
end;
end;
end;
end;
procedure TfrmBPZDY_LRTJ.TV1CellDblClick(Sender: TcxCustomGridTableView;
ACellViewInfo: TcxGridTableDataCellViewInfo; AButton: TMouseButton;
AShift: TShiftState; var AHandled: Boolean);
var i:integer;
FGYName:string;
begin
FGYName:=Trim(ClientDataSet1.fieldbyname('ZGYName').AsString);
if button2.Visible=true then
begin
if ML_GX.Locate('ZGYName',Trim(FGYName),[])=true then
begin
with ADOQueryMain do
begin
Close;
sql.Clear;
sql.Add('select A.* from GY_ZDY A where 1=2');
Open;
end;
SCreateCDS20(ADOQueryMain,CDS_LS);
SInitCDSData20(ADOQueryMain,CDS_LS);
with CDS_LS do
begin
append;
FieldByName('GYName').Value:=Trim(ML_GX.fieldbyname('GYName').AsString);
FieldByName('GYNameQC').Value:=Trim(ML_GX.fieldbyname('GYNameQC').AsString);
FieldByName('GYCode').Value:=Trim(ML_GX.fieldbyname('GYCode').AsString);
FieldByName('ZGYName').Value:=Trim(ML_GX.fieldbyname('ZGYName').AsString);
FieldByName('ZGYCode').Value:=Trim(ML_GX.fieldbyname('ZGYCode').AsString);
FieldByName('GYID').Value:=Trim(ML_GX.fieldbyname('GYID').AsString);
post;
end;
with ML_GX do
begin
Edit;
FieldByName('GYName').Value:=Trim(ClientDataSet1.fieldbyname('GYName').AsString);
FieldByName('GYNameQC').Value:=Trim(ClientDataSet1.fieldbyname('GYNameQC').AsString);
FieldByName('GYCode').Value:=Trim(ClientDataSet1.fieldbyname('GYCode').AsString);
FieldByName('ZGYName').Value:=Trim(ClientDataSet1.fieldbyname('ZGYName').AsString);
FieldByName('ZGYCode').Value:=Trim(ClientDataSet1.fieldbyname('ZGYCode').AsString);
FieldByName('GYID').Value:=Trim(ClientDataSet1.fieldbyname('GYID').AsString);
Post;
end;
with ClientDataSet1 do
begin
Edit;
FieldByName('GYName').Value:=Trim(CDS_LS.fieldbyname('GYName').AsString);
FieldByName('GYNameQC').Value:=Trim(CDS_LS.fieldbyname('GYNameQC').AsString);
FieldByName('GYCode').Value:=Trim(CDS_LS.fieldbyname('GYCode').AsString);
FieldByName('ZGYName').Value:=Trim(CDS_LS.fieldbyname('ZGYName').AsString);
FieldByName('ZGYCode').Value:=Trim(CDS_LS.fieldbyname('ZGYCode').AsString);
FieldByName('GYID').Value:=Trim(CDS_LS.fieldbyname('GYID').AsString);
Post;
end;
end else
begin
with ML_GX do
begin
Append;
FieldByName('XHNo').Value:=ML_GX.RecordCount+1;
FieldByName('GYName').Value:=Trim(ClientDataSet1.fieldbyname('GYName').AsString);
FieldByName('GYNameQC').Value:=Trim(ClientDataSet1.fieldbyname('GYNameQC').AsString);
FieldByName('GYCode').Value:=Trim(ClientDataSet1.fieldbyname('GYCode').AsString);
FieldByName('ZGYName').Value:=Trim(ClientDataSet1.fieldbyname('ZGYName').AsString);
FieldByName('ZGYCode').Value:=Trim(ClientDataSet1.fieldbyname('ZGYCode').AsString);
FieldByName('GYID').Value:=Trim(ClientDataSet1.fieldbyname('GYID').AsString);
Post;
end;
ClientDataSet1.Delete;
end;
end;
end;
procedure TfrmBPZDY_LRTJ.V1NotePropertiesEditValueChanged(Sender: TObject);
var
mvalue:string;
begin
mvalue:=TcxTextEdit(Sender).EditingText;
with ClientDataSet1 do
begin
Edit;
FieldByName('BPKZ').Value:=mvalue;
//Post;
end;
end;
procedure TfrmBPZDY_LRTJ.V1HelpTypePropertiesEditValueChanged(
Sender: TObject);
var
mvalue:string;
begin
mvalue:=TcxTextEdit(Sender).EditingText;
with ClientDataSet1 do
begin
Edit;
FieldByName('BPWS').Value:=mvalue;
Post;
end;
{with ADOQueryCmd do
begin
Close;
SQL.Clear;
sql.Add('Update KH_Zdy Set HelpType='''+Trim(mvalue)+'''');
sql.Add(' where ZdyNo='''+Trim(ClientDataSet1.fieldbyname('ZdyNo').AsString)+'''');
ExecSQL;
end;}
end;
procedure TfrmBPZDY_LRTJ.v1note1PropertiesEditValueChanged(Sender: TObject);
var
mvalue:string;
begin
mvalue:=TcxTextEdit(Sender).EditingText;
with ClientDataSet1 do
begin
Edit;
FieldByName('BPMiDu').Value:=mvalue;
Post;
end;
end;
procedure TfrmBPZDY_LRTJ.V1BPCodePropertiesEditValueChanged(Sender: TObject);
var
mvalue:string;
begin
mvalue:=TcxTextEdit(Sender).EditingText;
with ClientDataSet1 do
begin
Edit;
FieldByName('BPCode').Value:=mvalue;
end;
end;
procedure TfrmBPZDY_LRTJ.ToolButton4Click(Sender: TObject);
begin
ToolBar1.SetFocus;
if ClientDataSet1.IsEmpty then exit;
if ClientDataSet1.FieldByName('GYID').AsString='' then
begin
application.MessageBox('<27><EFBFBD><EBB1A3><EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ϣ','<27><>ʾ');
exit;
end;
with ML_GYS do
begin
Append;
post;
end;
end;
procedure TfrmBPZDY_LRTJ.ToolButton5Click(Sender: TObject);
begin
ToolBar1.SetFocus;
if ML_GYS.IsEmpty then Exit;
if Trim(ML_GYS.FieldByName('BPSubID').AsString)<>'' then
begin
if application.MessageBox(<><C8B7>Ҫɾ<D2AA><C9BE><EFBFBD><EFBFBD>?','<27><>ʾ<EFBFBD><CABE>Ϣ',1)=2 then exit;
with ADOQueryCmd do
begin
Close;
sql.Clear;
sql.Add('delete GY_ZDY_Sub where BPSubID='''+Trim(ML_GYS.fieldbyname('BPSubID').AsString)+'''');
ExecSQL;
end;
end;
ML_GYS.Delete;
end;
procedure TfrmBPZDY_LRTJ.Tv3CellDblClick(Sender: TcxCustomGridTableView;
ACellViewInfo: TcxGridTableDataCellViewInfo; AButton: TMouseButton;
AShift: TShiftState; var AHandled: Boolean);
var i:Integer;
begin
if ML_GX.IsEmpty then exit;
if ML_GX.FieldByName('ZGYName').AsString='<27>̽<EFBFBD>' then
begin
if ML_GX.Locate('ZGYName','<27>̽<EFBFBD>',[])=true then Exit;
with ClientDataSet1 do
begin
append;
FieldByName('GYName').Value:=Trim(ML_GX.fieldbyname('GYName').AsString);
FieldByName('GYNameQC').Value:=Trim(ML_GX.fieldbyname('GYNameQC').AsString);
FieldByName('GYCode').Value:=Trim(ML_GX.fieldbyname('GYCode').AsString);
FieldByName('ZGYName').Value:=Trim(ML_GX.fieldbyname('ZGYName').AsString);
FieldByName('ZGYCode').Value:=Trim(ML_GX.fieldbyname('ZGYCode').AsString);
FieldByName('GYID').Value:=Trim(ML_GX.fieldbyname('GYID').AsString);
post;
end;
end
else
begin
with ZDY_HGY do
begin
append;
FieldByName('GYName').Value:=Trim(ML_GX.fieldbyname('GYName').AsString);
FieldByName('GYNameQC').Value:=Trim(ML_GX.fieldbyname('GYNameQC').AsString);
FieldByName('GYCode').Value:=Trim(ML_GX.fieldbyname('GYCode').AsString);
FieldByName('ZGYName').Value:=Trim(ML_GX.fieldbyname('ZGYName').AsString);
FieldByName('ZGYCode').Value:=Trim(ML_GX.fieldbyname('ZGYCode').AsString);
FieldByName('GYID').Value:=Trim(ML_GX.fieldbyname('GYID').AsString);
post;
end;
end;
ML_GX.Delete;
i:=1;
ML_GX.DisableControls;
with ML_GX do
begin
first;
while not eof do
begin
Edit;
FieldByName('XHNo').Value:=i;
i:=i+1;
next;
end;
end;
ML_GX.EnableControls;
end;
procedure TfrmBPZDY_LRTJ.DASHBtnClick(Sender: TObject);
begin
frmBPZDY_SH:=TfrmBPZDY_SH.Create(self);
with frmBPZDY_SH do
begin
flag:='SHK';
flagName:=<>ſ<EFBFBD>';
ViewFlag:=true;
if ShowModal=1 then
begin
DASH.Text:=Trim(ClientDataSet1.fieldbyname('BPCode').AsString);
DASH.TxtCode:=Trim(ClientDataSet1.fieldbyname('BPID').AsString);
end;
free;
end;
end;
procedure TfrmBPZDY_LRTJ.V1BPNamePropertiesButtonClick(Sender: TObject;
AButtonIndex: Integer);
begin
frmZDYHelp:=TfrmZDYHelp.create(self);
with frmZDYHelp do
begin
frmZDYHelp.flag:='BPName';
frmZDYHelp.flagName:='<27><><EFBFBD><EFBFBD>';
frmZDYHelp.MainType:=Self.flag;
if DName<>'ADMIN' then
begin
ViewFlag:=true;
end;
if ShowModal=1 then
begin
with Self.ClientDataSet1 do
begin
edit;
FieldByName('BPName').Value:=Trim(frmZDYHelp.ClientDataSet1.fieldbyname('ZDYName').AsString);
end;
end;
Free;
end;
end;
procedure TfrmBPZDY_LRTJ.ToolButton7Click(Sender: TObject);
var
i:Integer;
maxno,FH:string;
begin
toolbar1.SetFocus;
Panel4.Visible:=true;
FMXBPID:='';
Button2.Caption:=<><C8B7><EFBFBD><EFBFBD><EFBFBD><EFBFBD>';
GYCodeM.Text:='';
GYNameM.Text:='';
GYNameQCM.Text:='';
end;
procedure TfrmBPZDY_LRTJ.ToolButton8Click(Sender: TObject);
begin
ToolBar1.SetFocus;
if ZDY_HGY.IsEmpty then Exit;
if Trim(ZDY_HGY.FieldByName('GYID').AsString)<>'' then
begin
if application.MessageBox(<><C8B7>Ҫɾ<D2AA><C9BE><EFBFBD><EFBFBD>?','<27><>ʾ<EFBFBD><CABE>Ϣ',1)=2 then exit;
with ADOQueryCmd do
begin
Close;
sql.Clear;
sql.Add('delete GY_ZDY where GYID='''+Trim(ZDY_HGY.fieldbyname('GYID').AsString)+'''');
ExecSQL;
end;
end;
ZDY_HGY.Delete;
end;
procedure TfrmBPZDY_LRTJ.ToolButton6Click(Sender: TObject);
var
maxno:string;
begin
if ZDY_HGY.IsEmpty then Exit;
Toolbar1.SetFocus;
if ZDY_HGY.Locate('BPCode',null,[]) then
begin
Application.MessageBox('<27><><EFBFBD>Ų<EFBFBD><C5B2><EFBFBD>Ϊ<EFBFBD>գ<EFBFBD>','<27><>ʾ',0);
Exit;
end;
if ZDY_HGY.Locate('BPCode','',[]) then
begin
Application.MessageBox('<27><><EFBFBD>Ų<EFBFBD><C5B2><EFBFBD>Ϊ<EFBFBD>գ<EFBFBD>','<27><>ʾ',0);
Exit;
end;
if ZDY_HGY.Locate('BPName',null,[]) then
begin
Application.MessageBox('<27><><EFBFBD>Ʋ<EFBFBD><C6B2><EFBFBD>Ϊ<EFBFBD>գ<EFBFBD>','<27><>ʾ',0);
Exit;
end;
if ZDY_HGY.Locate('BPName','',[]) then
begin
Application.MessageBox('<27><><EFBFBD>Ʋ<EFBFBD><C6B2><EFBFBD>Ϊ<EFBFBD>գ<EFBFBD>','<27><>ʾ',0);
Exit;
end;
HGYSaveData();
Application.MessageBox('<27><><EFBFBD><EFBFBD><EFBFBD>ɹ<EFBFBD><C9B9><EFBFBD>','<27><>ʾ',0);
end;
procedure TfrmBPZDY_LRTJ.TV4CellDblClick(Sender: TcxCustomGridTableView;
ACellViewInfo: TcxGridTableDataCellViewInfo; AButton: TMouseButton;
AShift: TShiftState; var AHandled: Boolean);
var i:integer;
begin
if button2.Visible=true then
begin
with ML_GX do
begin
Append;
FieldByName('XHNo').Value:=ML_GX.RecordCount+1;
FieldByName('GYName').Value:=Trim(ZDY_HGY.fieldbyname('GYName').AsString);
FieldByName('GYNameQC').Value:=Trim(ZDY_HGY.fieldbyname('GYNameQC').AsString);
FieldByName('GYCode').Value:=Trim(ZDY_HGY.fieldbyname('GYCode').AsString);
FieldByName('ZGYName').Value:=Trim(ZDY_HGY.fieldbyname('ZGYName').AsString);
FieldByName('ZGYCode').Value:=Trim(ZDY_HGY.fieldbyname('ZGYCode').AsString);
FieldByName('GYID').Value:=Trim(ZDY_HGY.fieldbyname('GYID').AsString);
Post;
end;
ZDY_HGY.Delete;
end;
end;
procedure TfrmBPZDY_LRTJ.Button1Click(Sender: TObject);
begin
if GYCode.text='' then
begin
application.messagebox('<27>̽<EFBFBD><CCBD><EFBFBD><EFBFBD><EFBFBD><EBB2BB>Ϊ<EFBFBD><CEAA>','<27><>ʾ');
exit;
end;
savedata();
end;
procedure TfrmBPZDY_LRTJ.Button2Click(Sender: TObject);
var
maxno:string;
begin
Toolbar1.SetFocus;
if GYCodeM.Visible=false then
begin
Fint:='1';
ModalResult:=1;
end
else
begin
if HGYCodeM.text='' then
begin
Application.MessageBox('<27><><EFBFBD><EFBFBD><EFBFBD>մ<EFBFBD><D5B4><EFBFBD><EBB2BB>Ϊ<EFBFBD>գ<EFBFBD>','<27><>ʾ',0);
Exit;
end;
HGYSaveData();
Application.MessageBox('<27><><EFBFBD><EFBFBD><EFBFBD>ɹ<EFBFBD><C9B9><EFBFBD>','<27><>ʾ',0);
end;
end;
procedure TfrmBPZDY_LRTJ.TV1MouseDown(Sender: TObject;
Button: TMouseButton; Shift: TShiftState; X, Y: Integer);
begin
// panel2.visible:=true;
//BPMF.SetFocus;
GYCode.Text:=Trim(ClientDataSet1.fieldbyname('GYCode').AsString);
GYName.Text:=Trim(ClientDataSet1.fieldbyname('GYName').AsString);
GYNameQC.Text:=Trim(ClientDataSet1.fieldbyname('GYNameQC').AsString);
ZGYCode.Text:='T';
ZGYName.Text:='<27>̽<EFBFBD>';
FBPID:=Trim(ClientDataSet1.fieldbyname('GYID').AsString);
Button1.Caption:=<><C8B7><EFBFBD>޸<EFBFBD>';
end;
procedure TfrmBPZDY_LRTJ.TV4MouseDown(Sender: TObject;
Button: TMouseButton; Shift: TShiftState; X, Y: Integer);
begin
// Panel4.Visible:=true;
// BPMF.SetFocus;
HGYCodeM.Text:='T';
HGYNameM.Text:='<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>';
GYCodeM.Text:=Trim(ZDY_HGY.fieldbyname('GYCode').AsString);
GYNameM.Text:=Trim(ZDY_HGY.fieldbyname('GYName').AsString);
GYNameQCM.Text:=Trim(ZDY_HGY.fieldbyname('GYNameQC').AsString);
FMXBPID:=Trim(ZDY_HGY.fieldbyname('GYID').AsString);
Button2.Caption:=<><C8B7><EFBFBD>޸<EFBFBD>';
end;
procedure TfrmBPZDY_LRTJ.FormDestroy(Sender: TObject);
begin
frmBPZDY_LRTJ:=nil;
end;
end.