6 地址管理 D

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace LC.DAL
{
using Entity;
public class AddressesDAL
{
/// <summary>
/// 新增
/// </summary>
/// <param name="a"></param>
/// <returns></returns>
public int Add(Addresses a)
{
using (EFDbContext dbContext = new EFDbContext())
{
dbContext.Entry(a).State = System.Data.Entity.EntityState.Added;
var result = dbContext.SaveChanges();
return result;
}
}

/// <summary>
/// 修改
/// </summary>
/// <param name="a"></param>
/// <returns></returns>
public int Update(Addresses a)
{
using (EFDbContext dbContext = new EFDbContext())
{
dbContext.Entry(a).State = System.Data.Entity.EntityState.Modified;
var result = dbContext.SaveChanges();
return result;
}
}

/// <summary>
/// 删除
/// </summary>
/// <param name="Id"></param>
/// <returns></returns>
public int Delete(int Id)
{
using (EFDbContext dbContext = new EFDbContext())
{
var a = dbContext.Addresses.Find(Id);
dbContext.Entry(a).State = System.Data.Entity.EntityState.Deleted;
var result = dbContext.SaveChanges();
return result;
}
}

/// <summary>
/// 根据Id获取
/// </summary>
/// <param name="Id"></param>
/// <returns></returns>
public Addresses QueryById(int Id)
{
using (EFDbContext dbContext = new EFDbContext())
{
var result = dbContext.Addresses.Find(Id);
return result;
}
}

/// <summary>
/// 获取数据
/// </summary>
/// <returns></returns>
public List<Addresses> Query()
{
using (EFDbContext dbContext = new EFDbContext())
{
var linq = from a in dbContext.Addresses.ToList()
join
a1 in dbContext.Region.ToList() on
a.TIdOne equals a1.Id
join
a2 in dbContext.Region.ToList() on
a.TIdTwo equals a2.Id
join
a3 in dbContext.Region.ToList() on
a.TIdThree equals a3.Id
select new Addresses
{
Id=a.Id,
Name=a.Name,
Phone=a.Phone,
Remark=a.Remark,
TIdOne=a.TIdOne,
TIdOneName=a1.Name,
TIdTwo=a.TIdTwo,
TIdTwoName=a2.Name,
TIdThree=a.TIdThree,
TIdThreeName=a3.Name
};
return linq.ToList();
}
}

/// <summary>
/// 获取数据
/// </summary>
/// <returns></returns>
public List<Region> GetRegion(int PId)
{
using (EFDbContext dbContext = new EFDbContext())
{
var result = dbContext.Region.Where(m=>m.Parent_id.Equals(PId)).ToList();
return result;
}
}
}
}

EFDBContext

namespace LC.DAL
{
using LC.Entity;
using System;
using System.Data.Entity;
using System.Linq;

public class EFDbContext : DbContext
{
//您的上下文已配置为从您的应用程序的配置文件(App.config 或 Web.config)
//使用“EFDbContext”连接字符串。默认情况下，此连接字符串针对您的 LocalDb 实例上的
//“LC.DAL.EFDbContext”数据库。
//
//如果您想要针对其他数据库和/或数据库提供程序，请在应用程序配置文件中修改“EFDbContext”
//连接字符串。
public EFDbContext()
: base("name=EFDbContext1")
{
}

//为您要在模型中包含的每种实体类型都添加 DbSet。有关配置和使用 Code First 模型
//的详细信息，请参阅 http://go.microsoft.com/fwlink/?LinkId=390109。

public DbSet<Addresses> Addresses { get; set; }
public DbSet<Region> Region { get; set; }
}

//public class MyEntity
//{
// public int Id { get; set; }
// public string Name { get; set; }
//}
}

model

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace LC.Entity
{
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
public class Addresses
{
[Key]
public int Id { get; set; }
public string Name { get; set; }
public string Phone { get; set; }
public int TIdOne { get; set; }
public int TIdTwo { get; set; }
public int TIdThree { get; set; }
public string Remark { get; set; }
[NotMapped]
public string TIdOneName { get; set; }
[NotMapped]
public string TIdTwoName { get; set; }
[NotMapped]
public string TIdThreeName { get; set; }
}
}

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace LC.Entity
{
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
[Table("Region")]
public class Region
{
[Key]
public int Id { get; set; }
public string Name { get; set; }
public int Parent_id { get; set; }
}
}