public static bool registrarPerfilDefault(string codigo, string descripcion)
{
var res = true;
//Cuando se registra un nuevo perfil, añadir por defecto los permisos de menu
SAPbobsCOM.Recordset mRS = null;
try
{
mRS = Conexion.company.GetBusinessObject(SAPbobsCOM.BoObjectTypes.BoRecordset);
var mLines = MenuAppDAO.listar();
foreach (var l in mLines)
{
mRS.DoQuery("insert into " + BdMobile.BD_NAME + "." + BdMobile.TB_PERMISOS +
" values (" + obtenerUltimoId() + ", " + EmpresaDAO.obtenerIdInterno() +
", " + l.docEntry + ", '" + codigo + "', 'N', 'N', 'N', 'N', 'N', 'N')");
}
}
catch (Exception e)
{
res = false;
StatusMessageError("PermisoDAO > registrarPerfilDefault() > " + e.Message);
}
finally
{
if (mRS != null)
{
LiberarObjetoGenerico(mRS);
}
}
return(res);
}
public static bool registrarMenuDetalleDefault(string codMenu, string descripcion)
{
var res = true;
SAPbobsCOM.Recordset mRS = null;
SAPbobsCOM.Recordset mRSInsert = null;
try
{
mRS = Conexion.company.GetBusinessObject(SAPbobsCOM.BoObjectTypes.BoRecordset);
mRSInsert = Conexion.company.GetBusinessObject(SAPbobsCOM.BoObjectTypes.BoRecordset);
mRS.DoQuery("select distinct \"idPerfil\", \"idEmpresa\" from " + BdMobile.BD_NAME + "." + BdMobile.TB_PERMISOS);
string idMenu = MenuAppDAO.obtenerIdxCodigo(codMenu);
if (mRS.RecordCount > 0)
{
while (!mRS.EoF)
{
string idPerfil = mRS.Fields.Item("idPerfil").Value.ToString().Trim();
string idEmpresa = mRS.Fields.Item("idEmpresa").Value.ToString().Trim();
mRSInsert.DoQuery("insert into " + BdMobile.BD_NAME + "." + BdMobile.TB_PERMISOS +
" values (" + obtenerUltimoId() + ", " + idEmpresa +
", " + idMenu + ", '" + idPerfil + "', 'N', 'N', 'N', 'N', 'N', 'N')");
mRS.MoveNext();
}
}
}
catch (Exception ex)
{
res = false;
StatusMessageError("PermisoDAO > registrarDetalleDefault() > " + ex.Message);
}
finally
{
if (mRS != null)
{
LiberarObjetoGenerico(mRS);
}
if (mRSInsert != null)
{
LiberarObjetoGenerico(mRSInsert);
}
}
return(res);
}