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)); }