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