TA的每日心情 | 衰 2015-10-12 16:00 |
---|
签到天数: 185 天 [LV.7]常住居民III
|
楼主 |
发表于 2013-9-28 12:09:48
|
显示全部楼层
关键源码也一并附上!
看的懂的人可以看看!!
procedure TFormServersList.SettingClick(Sender: TObject);
var
i:integer;
begin
VMProtectBegin('SettingClick');
for I := 1 to 12 do
begin
if (FindComponent('sCheckBox'+inttostr(i)) as TsCheckBox).Checked = True then
begin
ADOQuery1.SQL.Clear;
ADOQuery1.SQL.Add('select * from t_sys_system where sys_var_id = '''+array1[i]+'''');
ADOQuery1.Open;
if ADOQuery1.recordcount=1 then
begin
ADOQuery1.SQL.Clear;
ADOQuery1.SQL.Add('update t_sys_system set sys_var_value = ''1'' where sys_var_id = '''+array1[i]+'''');
ADOQuery1.ExecSQL;
end
else
begin
ADOQuery1.SQL.Clear;
ADOQuery1.SQL.Add('insert into t_sys_system values ('''+array1[i]+''',''系统变量'+''+array1[i]+''',1,''否'',null,1,null,null)');
ADOQuery1.ExecSQL;
end;
end
else
begin
ADOQuery1.SQL.Clear;
ADOQuery1.SQL.Add('select * from t_sys_system where sys_var_id = '''+array1[i]+'''');
ADOQuery1.Open;
if ADOQuery1.recordcount=1 then
begin
ADOQuery1.SQL.Clear;
ADOQuery1.SQL.Add('update t_sys_system set sys_var_value = ''0'' where sys_var_id = '''+array1[i]+'''');
ADOQuery1.ExecSQL;
end;
end;
end;
VMProtectEnd;
end;
procedure TFormServersList.ConnSqlClick(Sender: TObject);
var
i:integer;
begin
VMProtectBegin('ConnSqlClick');
try
if Version.Text = '单店/总部' then
begin
conn('isszmv8')
end
else
begin
conn('isszmv8_branch');
end;
Setting.Enabled := True;
array1[1] := 'special_hand_update';
array1[2] := 'special_spe_dis';
array1[3] := 'special_qty_addup';
array1[4] := 'db_saving_card';
array1[5] := 'histroystock_query';
array1[6] := 'order_repeat_item';
array1[7] := 'sys_del_flag';
array1[8] := 'vip_spec_link';
array1[9] := 'sheet_zb_manager';
array1[10] := 'trans_timer';
array1[11] := 'vip_good_zb';
array1[12] := 'mod_all_baseprice';
for I := 1 to 12 do
begin
(FindComponent('sCheckBox'+inttostr(i)) as TsCheckBox).Enabled := True;
ADOQuery1.SQL.Clear;
ADOQuery1.SQL.Add('select * from t_sys_system where sys_var_id = '''+array1[i]+'''');
ADOQuery1.Open;
if (ADOQuery1.FieldByName('sys_var_id').isnull) or (ADOQuery1.FieldByName('sys_var_value').value=0) then
(FindComponent('sCheckBox'+inttostr(i)) as TsCheckBox).Checked := False
else
(FindComponent('sCheckBox'+inttostr(i)) as TsCheckBox).Checked := True;
end;
except
MessageBox(application.Handle, PChar('数据库连接失败或您的数据库中不包含'+ Version.Text +'数据库'),'错误',mb_OK)
end;
VMProtectEnd;
end; |
|