Linq在三层中的使用

在使用Linq时必须引用：using System.Data.Linq;

模型层添加：DataClasses1.dbml文件

数据访问层：继承模型层DataClasses1DataContext

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using GoldenUnicornModels;
using System.Data.Linq;

namespace GoldenUnicornDAL
{
    public class authoritative_dataServices:DataClasses1DataContext
    {
        #region 查询所有数据
        /// <summary>
        /// 查询所有数据
        /// </summary>
        /// <returns></returns>
        public List<authoritative_data> GetAuth()
        {
            return authoritative_data.ToList();
        } 
        #endregion

        #region 获取最新的一条信息
        /// <summary>
        /// 获取最新的一条信息
        /// </summary>
        /// <returns></returns>
        public authoritative_data GetTopOne()
        {
            return authoritative_data.ToList().OrderByDescending(s => s.Id).Take(1).FirstOrDefault();
        } 
        #endregion

        #region 修改信息
        /// <summary>
        /// 修改信息
        /// </summary>
        /// <param name="vo"></param>
        /// <returns></returns>
        public bool UpdateInfo(authoritative_data vo)
        {

            if (vo != null)
            {
                try
                {
                    authoritative_data auth = authoritative_data.FirstOrDefault(s => s.Id == vo.Id);
                    auth.Id = vo.Id;
                    auth.TodayTransactionAmount = vo.TodayTransactionAmount;
                    auth.TodayNumberDeals = vo.TodayNumberDeals;
                    auth.CurrentRetailPosition = vo.CurrentRetailPosition;
                    auth.AgencyPosition = vo.AgencyPosition;
                    auth.HoldBinAmountEmpty = vo.HoldBinAmountEmpty;
                    auth.HoldBinAmountMany = vo.HoldBinAmountMany;
                    auth.Date = vo.Date;
                    SubmitChanges();//提交
                    return true;
                }
                catch
                {
                    return false;
                }
            }
            else
            {
                return false;
            }
        } 
        #endregion

        #region 新增信息
        /// <summary>
        /// 新增信息
        /// </summary>
        /// <param name="auth"></param>
        /// <returns></returns>
        public bool AddInfo(authoritative_data auth)
        {
            if (auth != null)
            {
                try
                {
                    authoritative_data.InsertOnSubmit(auth);
                    SubmitChanges();//提交
                    return true;
                }
                catch
                {

                    return false;
                }
            }
            else
            {
                return false;
            }
        } 
        #endregion

        #region 删除
        /// <summary>
        /// 删除
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        public bool DeleteInfo(int id)
        {
            var auth = authoritative_data.FirstOrDefault(t => t.Id == id);

            if (auth != null)
            {
                try
                {
                    authoritative_data.DeleteOnSubmit(auth);
                    SubmitChanges();//提交
                    return true;
                }
                catch
                {

                    return false;
                }
            }
            else
            {
                return false;
            }
        } 
        #endregion

        #region 根据编号查询
        /// <summary>
        /// 根据编号查询
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        public authoritative_data GetById(int id)
        {
            try
            {
                authoritative_data auth = authoritative_data.FirstOrDefault(s => s.Id == id);
                return auth;
            }
            catch
            {

                return null;
            }
        } 
        #endregion
    }
}

逻辑层方法不变。