procedure TFrmNewRole.btnCreateClick(Sender: TObject);
var
mm:String;
begin
with adodsNewRole do
begin
Connection:= adocNewRole;
CommandType:=cmdText;
mm:= edtRoleName.Text;
CommandText:='insert into RoleTable (RoleName,SysMng,TopoMng,HighMng,TelMng,EquipMng,AlarmMng) values("'+mm+'",ckbSysMng.Checked,ckbTopo.Checked,ckbHighMng.Checked,ckbTelMng.Checked,ckbEquipMng.Checked,ckbAlarmQuery.Checked)';
Open;
MessageDlg('创建角色成功',mtWarning,[mbOk],0);
end;
end;
var
mm:String;
begin
with adodsNewRole do
begin
Connection:= adocNewRole;
CommandType:=cmdText;
mm:= edtRoleName.Text;
CommandText:='insert into RoleTable (RoleName,SysMng,TopoMng,HighMng,TelMng,EquipMng,AlarmMng) values("'+mm+'",ckbSysMng.Checked,ckbTopo.Checked,ckbHighMng.Checked,ckbTelMng.Checked,ckbEquipMng.Checked,ckbAlarmQuery.Checked)';
Open;
MessageDlg('创建角色成功',mtWarning,[mbOk],0);
end;
end;
估计上面这些都是Form上的控件的状态吧, 要把它们转换为字串放到SQL语句里去.如:'...字串' + BoolToStr(ckbSysMng.Checked) + ',' + BoolToStr(ckbTopo.Checked) + '.....'