C# (CSharp) CM2017.Propiedades UDN Examples

Example #1

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

Example #2

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

Example #3

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

Example #4

 public int UDNUpdate(prop.UDN item)
 {
     return(un.UDNUpdate(item));
 }

Example #5

 public int UDNDesactivar(prop.UDN item)
 {
     return(un.UDNDesactivar(item));
 }

Example #6

 public DataTable UDNSelectById(prop.UDN item)
 {
     return(un.UDNSelectById(item));
 }