C# (CSharp) CM2017.Propiedades Divisiones Examples

Example #1

 public int DivisionDesactivar(prop.Divisiones item)
 {
     CreateTextCommand("UPDATE Divisiones SET Visible=? WHERE IdDivision=? ");
     AddParameter("?", item.Activo, OleDbType.Numeric);
     AddParameter("?", item.Id, OleDbType.Numeric);
     return(Update());
 }

Example #2

 public int DivisionUpdate(prop.Divisiones item)
 {
     CreateTextCommand("UPDATE Divisiones SET Descripcion=?, Visible=? WHERE IdDivision=? ");
     AddParameter("?", item.Descripcion, OleDbType.VarChar);
     AddParameter("?", item.Activo, OleDbType.Numeric);
     AddParameter("?", item.Id, OleDbType.Numeric);
     return(Update());
 }

Example #3

 public DataTable DivisionesSelectById(prop.Divisiones item)
 {
     CreateTextCommand("SELECT IdDivision, Descripcion, SWITCH (Visible = 1, 'Activo', Visible = 0, 'Inactivo') AS Visible FROM Divisiones WHERE IdDivision=?");
     AddParameter("?", item.Id, OleDbType.Numeric);
     return(Select());
 }

Example #4

File: Divisiones.cs Project: jlvruiz/CM2017

 public int DivisionUpdate(prop.Divisiones item)
 {
     return(di.DivisionUpdate(item));
 }

Example #5

File: Divisiones.cs Project: jlvruiz/CM2017

 public int DivisionDesactivar(prop.Divisiones item)
 {
     return(di.DivisionDesactivar(item));
 }

Example #6

File: Divisiones.cs Project: jlvruiz/CM2017

 public DataTable DivisionesSelectById(prop.Divisiones item)
 {
     return(di.DivisionesSelectById(item));
 }