/// <summary> /// Envia los cambios del tpu_ComprobanteDetalleDeValoresDataset a la base de datos. /// </summary> public static void Update(tpu_ComprobanteDetalleDeValoresDataset dataSet) { ApplicationAssert.Check(dataSet != null, "El argumento dataSet no debe ser nulo.", ApplicationAssert.LineNumber); ApplicationAssert.Check(dataSet.tpu_ComprobanteDetalleDeValores.Rows.Count > 0, "La tabla dataSet.tpu_ComprobanteDetalleDeValoresDataTable debe poseer alguna fila.", ApplicationAssert.LineNumber); mz.erp.dataaccess.tpu_ComprobanteDetalleDeValores.Update(dataSet); }
public static tpu_ComprobanteDetalleDeValoresDataset.tpu_ComprobanteDetalleDeValoresRow GetByPk(string IdComprobante, string IdValor) { tpu_ComprobanteDetalleDeValoresDataset data = new tpu_ComprobanteDetalleDeValoresDataset(); SqlCommand cmd = new SqlCommand("Pr_tpu_ComprobanteDetalleDeValores_GetByPk", dbhelper.Connection.GetConnection()); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@IdComprobante", SqlDbType.VarChar)); cmd.Parameters["@IdComprobante"].Value = IdComprobante; cmd.Parameters.Add(new SqlParameter("@IdValor", SqlDbType.VarChar)); cmd.Parameters["@IdValor"].Value = IdValor; SqlDataAdapter adapter = new SqlDataAdapter(cmd); adapter.TableMappings.Add("Table", "tpu_ComprobanteDetalleDeValores"); adapter.Fill(data); if (data.tpu_ComprobanteDetalleDeValores.Rows.Count == 1) { return((tpu_ComprobanteDetalleDeValoresDataset.tpu_ComprobanteDetalleDeValoresRow)data.tpu_ComprobanteDetalleDeValores.Rows[0]); } return(null); }
public static tpu_ComprobanteDetalleDeValoresDataset GetList(string IdTipoDeComprobante, string Numero, string IdComprobante, string IdValor, decimal Monto) { tpu_ComprobanteDetalleDeValoresDataset data = new tpu_ComprobanteDetalleDeValoresDataset(); SqlDataAdapter adapter = new SqlDataAdapter(); adapter.TableMappings.Add("Table", "tpu_ComprobanteDetalleDeValores"); SqlCommand cmd = new SqlCommand("Pr_tpu_ComprobanteDetalleDeValores_Search", dbhelper.Connection.GetConnection()); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@IdTipoDeComprobante", SqlDbType.VarChar)); cmd.Parameters["@IdTipoDeComprobante"].Value = IdTipoDeComprobante; cmd.Parameters.Add(new SqlParameter("@Numero", SqlDbType.VarChar)); cmd.Parameters["@Numero"].Value = Numero; cmd.Parameters.Add(new SqlParameter("@IdComprobante", SqlDbType.VarChar)); cmd.Parameters["@IdComprobante"].Value = IdComprobante; cmd.Parameters.Add(new SqlParameter("@IdValor", SqlDbType.VarChar)); cmd.Parameters["@IdValor"].Value = IdValor; cmd.Parameters.Add(new SqlParameter("@Monto", SqlDbType.Decimal)); cmd.Parameters["@Monto"].Value = Monto; adapter.SelectCommand = cmd; adapter.Fill(data); return(data); }
public static tpu_ComprobanteDetalleDeValoresDataset GetList() { tpu_ComprobanteDetalleDeValoresDataset data = new tpu_ComprobanteDetalleDeValoresDataset(); return(( tpu_ComprobanteDetalleDeValoresDataset )GetList(data)); }
public static void Update(tpu_ComprobanteDetalleDeValoresDataset dataSet) { Update(dataSet.tpu_ComprobanteDetalleDeValores); }