/// <summary> /// Envia los cambios del tlg_VisualizacionDeStockDetDataset a la base de datos. /// </summary> public static void Update(tlg_VisualizacionDeStockDetDataset dataSet) { ApplicationAssert.Check(dataSet != null, "El argumento dataSet no debe ser nulo.", ApplicationAssert.LineNumber); ApplicationAssert.Check(dataSet.tlg_VisualizacionDeStockDet.Rows.Count > 0, "La tabla dataSet.tlg_VisualizacionDeStockDetDataTable debe poseer alguna fila.", ApplicationAssert.LineNumber); mz.erp.dataaccess.tlg_VisualizacionDeStockDet.Update(dataSet); }
public static tlg_VisualizacionDeStockDetDataset GetList(string IdVisualizacionDeStock, string IdEstadoDeStock, short Operacion) { tlg_VisualizacionDeStockDetDataset data = new tlg_VisualizacionDeStockDetDataset(); SqlDataAdapter adapter = new SqlDataAdapter(); adapter.TableMappings.Add("Table", "tlg_VisualizacionDeStockDet"); SqlCommand cmd = new SqlCommand("Pr_tlg_VisualizacionDeStockDet_Search", dbhelper.Connection.GetConnection()); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@IdVisualizacionDeStock", SqlDbType.VarChar)); cmd.Parameters["@IdVisualizacionDeStock"].Value = IdVisualizacionDeStock; cmd.Parameters.Add(new SqlParameter("@IdEstadoDeStock", SqlDbType.VarChar)); cmd.Parameters["@IdEstadoDeStock"].Value = IdEstadoDeStock; cmd.Parameters.Add(new SqlParameter("@Operacion", SqlDbType.SmallInt)); if (!Operacion.Equals(short.MinValue)) { cmd.Parameters["@Operacion"].Value = Operacion; } else { cmd.Parameters["@Operacion"].Value = System.DBNull.Value; } adapter.SelectCommand = cmd; adapter.Fill(data); return(data); }
public static tlg_VisualizacionDeStockDetDataset.tlg_VisualizacionDeStockDetRow GetByPk(string IdVisualizacionDeStock, string IdEstadoDeStock) { tlg_VisualizacionDeStockDetDataset data = new tlg_VisualizacionDeStockDetDataset(); SqlCommand cmd = new SqlCommand("Pr_tlg_VisualizacionDeStockDet_GetByPk", dbhelper.Connection.GetConnection()); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@IdVisualizacionDeStock", SqlDbType.VarChar)); cmd.Parameters["@IdVisualizacionDeStock"].Value = IdVisualizacionDeStock; cmd.Parameters.Add(new SqlParameter("@IdEstadoDeStock", SqlDbType.VarChar)); cmd.Parameters["@IdEstadoDeStock"].Value = IdEstadoDeStock; SqlDataAdapter adapter = new SqlDataAdapter(cmd); adapter.TableMappings.Add("Table", "tlg_VisualizacionDeStockDet"); adapter.Fill(data); if (data.tlg_VisualizacionDeStockDet.Rows.Count == 1) { return((tlg_VisualizacionDeStockDetDataset.tlg_VisualizacionDeStockDetRow)data.tlg_VisualizacionDeStockDet.Rows[0]); } return(null); }
public static tlg_VisualizacionDeStockDetDataset GetList() { tlg_VisualizacionDeStockDetDataset data = new tlg_VisualizacionDeStockDetDataset(); return(( tlg_VisualizacionDeStockDetDataset )GetList(data)); }
public static void Update(tlg_VisualizacionDeStockDetDataset dataSet) { Update(dataSet.tlg_VisualizacionDeStockDet); }