public static AuxiliarVariablesDataset.AuxiliarVariablesRow GetByPk(long IdVariable) { AuxiliarVariablesDataset data = new AuxiliarVariablesDataset(); SqlCommand cmd = new SqlCommand("Pr_AuxiliarVariables_GetByPk", dbhelper.Connection.GetConnection()); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@IdVariable", SqlDbType.BigInt)); cmd.Parameters["@IdVariable"].Value = IdVariable; SqlDataAdapter adapter = new SqlDataAdapter(cmd); adapter.TableMappings.Add("Table", "AuxiliarVariables"); adapter.Fill(data); if (data.AuxiliarVariables.Rows.Count == 1) { return((AuxiliarVariablesDataset.AuxiliarVariablesRow)data.AuxiliarVariables.Rows[0]); } return(null); }
public static void Update(AuxiliarVariablesDataset dataSet) { Update(dataSet.AuxiliarVariables); }
public static AuxiliarVariablesDataset GetList() { AuxiliarVariablesDataset data = new AuxiliarVariablesDataset(); return(( AuxiliarVariablesDataset )GetList(data)); }