public static sy_HerramientasDataset GetList(long IdBarraHerramienta, long IdPerfil)
{
sy_HerramientasDataset data = new sy_HerramientasDataset();
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.TableMappings.Add("Table", "sy_Herramientas");
SqlCommand cmd = new SqlCommand("Pr_sy_Herramientas_GetList_By_BarraHerramienta_Peril", dbhelper.Connection.GetConnection());
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@IdBarraHerramienta", SqlDbType.BigInt, 8));
cmd.Parameters["@IdBarraHerramienta"].Value = IdBarraHerramienta;
cmd.Parameters.Add(new SqlParameter("@IdPerfil", SqlDbType.BigInt, 8));
cmd.Parameters["@IdPerfil"].Value = IdPerfil;
adapter.SelectCommand = cmd;
try
{
adapter.Fill(data);
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex.ToString());
}
return(data);
}
/// <summary>
/// Envia los cambios del sy_HerramientasDataset a la base de datos.
/// </summary>
public static void Update(sy_HerramientasDataset dataSet)
{
ApplicationAssert.Check(dataSet != null, "El argumento dataSet no debe ser nulo.", ApplicationAssert.LineNumber);
ApplicationAssert.Check(dataSet.sy_Herramientas.Rows.Count > 0, "La tabla dataSet.sy_HerramientasDataTable debe poseer alguna fila.", ApplicationAssert.LineNumber);
mz.erp.dataaccess.sy_Herramientas.Update(dataSet);
}
public static DataSet GetList([SearchParameterInfo("IdHerramienta")] long IdHerramienta,
[SearchParameterInfo("IdHerramientaPadre")] long IdHerramientaPadre,
[SearchParameterInfo("Id")] string Id,
[SearchParameterInfo("ShortCut")] string ShortCut,
[SearchParameterInfo("orden")] short orden,
[SearchParameterInfo("Habilitado")] bool Habilitado
)
{
sy_HerramientasDataset data = mz.erp.businessrules.sy_Herramientas.GetList(IdHerramienta, IdHerramientaPadre, Id, ShortCut, orden, Habilitado);
return(( DataSet )data);
}
/*
* ultraExplorerBarGroup1.Items.AddRange(new Infragistics.Win.UltraWinExplorerBar.UltraExplorerBarItem[] {
* ultraExplorerBarItem1});
* ultraExplorerBarGroup1.ItemSettings.Style = Infragistics.Win.UltraWinExplorerBar.ItemStyle.Button;
* ultraExplorerBarGroup1.Text = "Tareas";
* ultraExplorerBarGroup2.Text = "Favoritos";
* this.explorerBar.Groups.AddRange(new Infragistics.Win.UltraWinExplorerBar.UltraExplorerBarGroup[] {
* ultraExplorerBarGroup1,
* ultraExplorerBarGroup2});
*
*/
/*public static void Load( UltraExplorerBar toolbar)
* {
* //sy_HerramientasDataset data = businessrules.sy_Herramientas.GetList( ID_EXPLORER_BAR, Security.IdPerfil );
* //LoadItems( new DataView( data.sy_Herramientas, "IsNull( IdHerramientaPadre, -1 ) = -1", "IdHerramienta", DataViewRowState.OriginalRows ), toolbar, null );
*
* sy_HerramientasDataset data = businessrules.sy_Herramientas.GetList( ID_EXPLORER_BAR, Security.IdPerfil );
*
* if (data.sy_Herramientas.Count == 0)
* {
* toolbar.Visible = false;
* }
* else
* {
* LoadItems( new DataView( data.sy_Herramientas, "IsNull( IdHerramientaPadre, -1 ) = -1", "IdHerramienta", DataViewRowState.OriginalRows ), toolbar, null );
* toolbar.Visible = true;
* }
* }*/
public static void Load(UltraExplorerBar toolbar, UltraDockManager ultraDockManager)
{
sy_HerramientasDataset data = businessrules.sy_Herramientas.GetList(ID_EXPLORER_BAR, Security.IdPerfil);
if (data.sy_Herramientas.Count == 0)
{
ultraDockManager.Visible = false;
}
else
{
LoadItems(new DataView(data.sy_Herramientas, "IsNull( IdHerramientaPadre, -1 ) = -1", "IdHerramienta", DataViewRowState.OriginalRows), toolbar, null);
ultraDockManager.Visible = true;
}
}
public static sy_HerramientasDataset.sy_HerramientasRow GetByPk(long IdHerramienta)
{
sy_HerramientasDataset data = new sy_HerramientasDataset();
SqlCommand cmd = new SqlCommand("Pr_sy_Herramientas_GetByPk", dbhelper.Connection.GetConnection());
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@IdHerramienta", SqlDbType.BigInt));
cmd.Parameters["@IdHerramienta"].Value = IdHerramienta;
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
adapter.TableMappings.Add("Table", "sy_Herramientas");
adapter.Fill(data);
if (data.sy_Herramientas.Rows.Count == 1)
{
return((sy_HerramientasDataset.sy_HerramientasRow)data.sy_Herramientas.Rows[0]);
}
return(null);
}
public static void Update(sy_HerramientasDataset dataSet)
{
Update(dataSet.sy_Herramientas);
}
public static sy_HerramientasDataset GetList(long IdHerramienta, long IdHerramientaPadre, string Id, string ShortCut, short orden, bool Habilitado)
{
sy_HerramientasDataset data = new sy_HerramientasDataset();
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.TableMappings.Add("Table", "sy_Herramientas");
SqlCommand cmd = new SqlCommand("Pr_sy_Herramientas_Search", dbhelper.Connection.GetConnection());
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@IdHerramienta", SqlDbType.BigInt));
if (IdHerramienta == long.MinValue)
{
cmd.Parameters["@IdHerramienta"].Value = System.DBNull.Value;
}
else
{
cmd.Parameters["@IdHerramienta"].Value = IdHerramienta;
}
cmd.Parameters.Add(new SqlParameter("@IdHerramientaPadre", SqlDbType.BigInt));
if (IdHerramientaPadre == long.MinValue)
{
cmd.Parameters["@IdHerramientaPadre"].Value = System.DBNull.Value;
}
else
{
cmd.Parameters["@IdHerramientaPadre"].Value = IdHerramientaPadre;
}
cmd.Parameters.Add(new SqlParameter("@Id", SqlDbType.VarChar));
if (Id.Equals(string.Empty))
{
cmd.Parameters["@Id"].Value = System.DBNull.Value;
}
else
{
cmd.Parameters["@Id"].Value = Id;
}
cmd.Parameters.Add(new SqlParameter("@ShortCut", SqlDbType.VarChar));
if (ShortCut.Equals(string.Empty))
{
cmd.Parameters["@ShortCut"].Value = System.DBNull.Value;
}
else
{
cmd.Parameters["@ShortCut"].Value = ShortCut;
}
cmd.Parameters.Add(new SqlParameter("@orden", SqlDbType.SmallInt));
if (orden == short.MinValue)
{
cmd.Parameters["@orden"].Value = System.DBNull.Value;
}
else
{
cmd.Parameters["@orden"].Value = orden;
}
cmd.Parameters.Add(new SqlParameter("@Habilitado", SqlDbType.Bit));
cmd.Parameters["@Habilitado"].Value = Habilitado;
adapter.SelectCommand = cmd;
adapter.Fill(data);
return(data);
}
public static sy_HerramientasDataset GetList()
{
sy_HerramientasDataset data = new sy_HerramientasDataset();
return(( sy_HerramientasDataset )GetList(data));
}
