?? goods.pas
字號:
end;
for i:=0 to BH_Count-1 do
begin
J_R:=B_R+(i*K_R); //截止度數等于開始度數加跨度和循環次數的積
Str_JS:=FloatToStr(J_R); //把每一次循環后的球面度數轉換成字符串
EG1.Text:=Str_No+Str_JS+'_';
EG1.Text:=Copy(EG1.Text,1,length(EG1.Text)-1); //取得商品代碼
tempstr:='';tempsql:='';tempText:='';openstr:='';
openstr:='Select * from [Goods_Information]';
tempstr:='insert into [Goods_Information](Goods_NO,Goods_Modal_No,Goods_Modal,Goods_Cards_NO,Goods_Cards,Goods_Brand_NO,Goods_Brand,Norms_Type_NO,Norms_Type,';
tempstr:=tempstr+'Goods_Sphere,Goods_Color_NO,Goods_Color,Goods_Coding,Enroll_Brand,Factory,Goods_Name,Goods_abbrev,Base_Monad,Whole_Monad,Valid_Month,Valid_Day,Remark)';
tempsql:='values ('''+Trim(EG1.Text)+''','''+Trim(EG2.Text)+''','''+Trim(EG3.Text)+''','''+Trim(EG4.Text)+''','''+Trim(EG5.Text)+''','''+Trim(EG6.Text)+''','''+Trim(EG7.Text)+''','''+Trim(EG8.Text)+''','''+Trim(EG9.Text)+''','''+Trim(Str_JS)+''','''+Trim(EG12.Text)+''','''+Trim(EG13.Text)+''','''+Trim(EG14.Text)+''','''+Trim(EG15.Text)+''','''+Trim(EG16.Text)+''','''+Trim(EG17.Text)+''','''+Trim(EG18.Text)+''','''+Trim(EG19.Text)+''','''+Trim(EG20.Text)+''','''+Trim(EG21.Text)+''','''+Trim(EG22.Text)+''','''+Trim(EG23.Text)+''')';
tempText:=Trim(tempstr)+Trim(tempsql);
Lab_XD.Caption:=Str_JS;
with frm_data.ClientDataSet_Add do
begin
Close;
CommandText:='';
CommandText:='Select * from [Goods_Information] where Goods_NO='''+Trim(Eg1.Text)+'''';
try
open;
if frm_data.ClientDataSet_Add.RecordCount>0 then
begin
Application.MessageBox('操作失敗!存在了同類商品編號!請確認!',Pchar(Application.Title),MB_ICONWarning);
Exit;
end
else
begin
with frm_data.Client_Goods do
begin
frm_data.Client_Goods.Open;
frm_data.Client_Goods.Insert;
frm_data.Client_Goods.FieldByName('Goods_NO').AsString:=Trim(EG1.Text);
frm_data.Client_Goods.FieldByName('Goods_Modal_No').AsString:=Trim(EG2.Text);
frm_data.Client_Goods.FieldByName('Goods_Modal').AsString:=Trim(EG3.Text);
frm_data.Client_Goods.FieldByName('Goods_Cards_NO').AsString:=Trim(EG4.Text);
frm_data.Client_Goods.FieldByName('Goods_Cards').AsString:=Trim(EG5.Text);
frm_data.Client_Goods.FieldByName('Goods_Brand_NO').AsString:=Trim(EG6.Text);
frm_data.Client_Goods.FieldByName('Goods_Brand').AsString:=Trim(EG7.Text);
frm_data.Client_Goods.FieldByName('Norms_Type_NO').AsString:=Trim(EG8.Text);
frm_data.Client_Goods.FieldByName('Norms_Type').AsString:=Trim(EG9.Text);
frm_data.Client_Goods.FieldByName('Goods_Sphere').AsString:=Trim(Str_JS);
frm_data.Client_Goods.FieldByName('Goods_Color_NO').AsString:=Trim(EG12.Text);
frm_data.Client_Goods.FieldByName('Goods_Color').AsString:=Trim(EG13.Text);
frm_data.Client_Goods.FieldByName('Goods_Coding').AsString:=Trim(EG14.Text);
frm_data.Client_Goods.FieldByName('Enroll_Brand').AsString:=Trim(EG15.Text);
frm_data.Client_Goods.FieldByName('Factory').AsString:=Trim(EG16.Text);
frm_data.Client_Goods.FieldByName('Goods_Name').AsString:=Trim(EG17.Text);
frm_data.Client_Goods.FieldByName('Goods_abbrev').AsString:=Trim(EG18.Text);
frm_data.Client_Goods.FieldByName('Base_Monad').AsString:=Trim(EG19.Text);
frm_data.Client_Goods.FieldByName('Whole_Monad').AsString:=Trim(EG20.Text);
frm_data.Client_Goods.FieldByName('Valid_Month').AsString:=Trim(EG21.Text);
frm_data.Client_Goods.FieldByName('Valid_Day').AsString:=Trim(EG22.Text);
frm_data.Client_Goods.FieldByName('Remark').AsString:=Trim(EG23.Text);
try
post;
frm_data.Client_Goods.SaveToFile('Client_Goods_Information.cds');
except
Application.MessageBox('系統錯誤!保存【商品基本信息表】時出錯!請確認!',Pchar(Application.Title),MB_ICONWarning);
Exit;
end;
end;
end;
except
Application.MessageBox('系統錯誤!打開【商品基本信息表】時出錯!請確認!',Pchar(Application.Title),MB_ICONWarning);
Exit;
end;
end;
end;
Application.MessageBox('恭喜你!利用向導保存【商品基本信息】成功!請確認!',Pchar(Application.Title),MB_ICONWarning);
Lab_XD.Caption:='';
end;
//柱面度數批量錄入
if (CheckBox6.Checked=True) and (CheckBox4.Checked=False) then //柱面度數批量錄入
begin
if (Trim(Edit_KD.Text)='') or (trim(Edit_KS.Text)='') or (trim(Edit_JS.Text)='') then
begin
Application.MessageBox('錯誤操作,你已經選擇【球面度數批量錄入】,'+#13#10#13+'【變化幅度】、【起始度數】、【截止度數】均不能為空!請確認!',pchar(application.Title),mb_iconwarning);
Exit;
end;
if Trim(EG10.Text)='' then
begin
Application.MessageBox('錯誤操作,你已經選擇【柱面度數批量錄入】,必須有一個具體的【球面度數】'+#13#10#13+'請選擇一個具體的【球面度數】進行錄入,請確認!',pchar(application.Title),mb_iconwarning);
Exit;
end;
for i:=0 to BH_Count-1 do
begin
J_R:=B_R+(i*K_R); //截止度數等于開始度數加跨度和循環次數的積
Str_JS:=FloatToStr(J_R); //把每一次循環后的球面度數轉換成字符串
EG1.Text:=Str_No+Str_JS+'_';
EG1.Text:=Copy(EG1.Text,1,length(EG1.Text)-1); //取得商品代碼
tempstr:='';tempsql:='';tempText:='';openstr:='';
openstr:='Select * from [Goods_Information]';
tempstr:='insert into [Goods_Information](Goods_NO,Goods_Modal_No,Goods_Modal,Goods_Cards_NO,Goods_Cards,Goods_Brand_NO,Goods_Brand,Norms_Type_NO,Norms_Type,';
tempstr:=tempstr+'Goods_Sphere,Goods_Column,Goods_Color_NO,Goods_Color,Goods_Coding,Enroll_Brand,Factory,Goods_Name,Goods_abbrev,Base_Monad,Whole_Monad,Valid_Month,Valid_Day,Remark)';
tempsql:='values ('''+Trim(EG1.Text)+''','''+Trim(EG2.Text)+''','''+Trim(EG3.Text)+''','''+Trim(EG4.Text)+''','''+Trim(EG5.Text)+''','''+Trim(EG6.Text)+''','''+Trim(EG7.Text)+''','''+Trim(EG8.Text)+''','''+Trim(EG9.Text)+''','''+Trim(EG10.Text)+''','''+Trim(Str_JS)+''','''+Trim(EG12.Text)+''','''+Trim(EG13.Text)+''','''+Trim(EG14.Text)+''','''+Trim(EG15.Text)+''','''+Trim(EG16.Text)+''','''+Trim(EG17.Text)+''','''+Trim(EG18.Text)+''','''+Trim(EG19.Text)+''','''+Trim(EG20.Text)+''','''+Trim(EG21.Text)+''','''+Trim(EG22.Text)+''','''+Trim(EG23.Text)+''')';
tempText:=Trim(tempstr)+Trim(tempsql);
Lab_XD.Caption:=Str_JS;
with frm_data.ClientDataSet_Add do
begin
Close;
CommandText:='';
CommandText:='Select * from [Goods_Information] where Goods_NO='''+Trim(Eg1.Text)+'''';
try
open;
if frm_data.ClientDataSet_Add.RecordCount>0 then
begin
Application.MessageBox('操作失敗!存在了同類商品編號!請確認!',Pchar(Application.Title),MB_ICONWarning);
Exit;
end
else
begin
with frm_data.Client_Goods do
begin
frm_data.Client_Goods.Open;
frm_data.Client_Goods.Insert;
frm_data.Client_Goods.FieldByName('Goods_NO').AsString:=Trim(EG1.Text);
frm_data.Client_Goods.FieldByName('Goods_Modal_No').AsString:=Trim(EG2.Text);
frm_data.Client_Goods.FieldByName('Goods_Modal').AsString:=Trim(EG3.Text);
frm_data.Client_Goods.FieldByName('Goods_Cards_NO').AsString:=Trim(EG4.Text);
frm_data.Client_Goods.FieldByName('Goods_Cards').AsString:=Trim(EG5.Text);
frm_data.Client_Goods.FieldByName('Goods_Brand_NO').AsString:=Trim(EG6.Text);
frm_data.Client_Goods.FieldByName('Goods_Brand').AsString:=Trim(EG7.Text);
frm_data.Client_Goods.FieldByName('Norms_Type_NO').AsString:=Trim(EG8.Text);
frm_data.Client_Goods.FieldByName('Norms_Type').AsString:=Trim(EG9.Text);
frm_data.Client_Goods.FieldByName('Goods_Sphere').AsString:=Trim(EG10.Text);
frm_data.Client_Goods.FieldByName('Goods_Column').AsString:=Trim(Str_JS);
frm_data.Client_Goods.FieldByName('Goods_Color_NO').AsString:=Trim(EG12.Text);
frm_data.Client_Goods.FieldByName('Goods_Color').AsString:=Trim(EG13.Text);
frm_data.Client_Goods.FieldByName('Goods_Coding').AsString:=Trim(EG14.Text);
frm_data.Client_Goods.FieldByName('Enroll_Brand').AsString:=Trim(EG15.Text);
frm_data.Client_Goods.FieldByName('Factory').AsString:=Trim(EG16.Text);
frm_data.Client_Goods.FieldByName('Goods_Name').AsString:=Trim(EG17.Text);
frm_data.Client_Goods.FieldByName('Goods_abbrev').AsString:=Trim(EG18.Text);
frm_data.Client_Goods.FieldByName('Base_Monad').AsString:=Trim(EG19.Text);
frm_data.Client_Goods.FieldByName('Whole_Monad').AsString:=Trim(EG20.Text);
frm_data.Client_Goods.FieldByName('Valid_Month').AsString:=Trim(EG21.Text);
frm_data.Client_Goods.FieldByName('Valid_Day').AsString:=Trim(EG22.Text);
frm_data.Client_Goods.FieldByName('Remark').AsString:=Trim(EG23.Text);
try
post;
frm_data.Client_Goods.SaveToFile('Client_Goods_Information.cds');
except
Application.MessageBox('系統錯誤!保存【商品基本信息表】時出錯!請確認!',Pchar(Application.Title),MB_ICONWarning);
Exit;
end;
end;
end;
except
Application.MessageBox('系統錯誤!打開【商品基本信息表】時出錯!請確認!',Pchar(Application.Title),MB_ICONWarning);
Exit;
end;
end;
end;
Application.MessageBox('恭喜你!利用向導保存【商品基本信息】成功!請確認!',Pchar(Application.Title),MB_ICONWarning);
Lab_XD.Caption:='';
end;
end;
procedure Tfrm_Goods.Cmd_XHClick(Sender: TObject);
begin
Str_NO:=Str_NO+Trim(EG8.Text)+'_';
end;
procedure Tfrm_Goods.EG10Exit(Sender: TObject);
begin
Str_NO:=Str_NO+Trim(EG10.Text)+'_';
EG1.Text:=Str_NO ;
end;
procedure Tfrm_Goods.EG11Exit(Sender: TObject);
begin
Str_NO:=Str_NO+Trim(EG11.Text)+'_';
EG1.Text:=Str_NO;
end;
procedure Tfrm_Goods.CheckBox1Click(Sender: TObject);
begin
if CheckBox1.Checked=True then
begin
EG8.Text:=''; EG8.Text:='';
EG8.Clear; EG9.Clear;
Cmd_XH.Enabled:=True;
EG8.Enabled:=True;
EG9.Enabled:=True;
end;
if CheckBox1.Checked=False then
begin
EG8.Text:=''; EG8.Text:='';
EG8.Clear; EG9.Clear;
Cmd_XH.Enabled:=False;
EG8.Enabled:=False;
EG9.Enabled:=False;
end;
end;
procedure Tfrm_Goods.CheckBox2Click(Sender: TObject);
begin
if CheckBox2.Checked=True then
begin
EG12.Text:=''; EG13.Text:='';
EG12.Clear; EG13.Clear;
Cmd_YS.Enabled:=True;
EG12.Enabled:=True;
EG13.Enabled:=True;
end;
if CheckBox2.Checked=False then
begin
EG12.Text:=''; EG12.Text:='';
EG12.Clear; EG13.Clear;
Cmd_YS.Enabled:=False;
EG12.Enabled:=False;
EG13.Enabled:=False;
end;
end;
procedure Tfrm_Goods.EG12Exit(Sender: TObject);
begin
//Str_NO:=Str_NO+Trim(EG12.Text)+'_';
end;
procedure Tfrm_Goods.EG8Exit(Sender: TObject);
begin
Str_NO:=Str_NO+Trim(EG8.Text)+'_';
EG1.Text:=Str_NO;
end;
procedure Tfrm_Goods.SpeedButton3Click(Sender: TObject);
begin
cLOSE;
end;
procedure Tfrm_Goods.SpeedButton9Click(Sender: TObject);
begin
Close;
end;
procedure Tfrm_Goods.SpeedButton6Click(Sender: TObject);
begin
Close;
end;
procedure Tfrm_Goods.SpeedButton12Click(Sender: TObject);
begin
with frm_data.Client_Goods do
begin
try
frm_data.Client_Goods.open;
frm_data.Client_Goods.ApplyUpdates(-1);
except
Application.MessageBox('系統錯誤,系統在提交【商品信息】數據庫更新時出錯!',Pchar(Application.Title),MB_ICONWarning);
Exit;
end;
end;
end;
procedure Tfrm_Goods.FormClose(Sender: TObject; var Action: TCloseAction);
begin
frm_data.ClientDataSet_Add.Close;
frm_data.Client_Goods.Close;
action:=cafree;
end;
end.
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -