/// <summary>
/// 護衛隊群全読み込み
/// </summary>
/// <returns>List<護衛隊群></returns>
public List <EscortFlotilla> ReadFlotilla()
{
using (var db = new ShipsDbContext()) {
db.Database.Log = sql => { Debug.Write(sql); };
var fd = db.EscortFlotillas.ToList();
return(fd);
}
}
public EscortDivision ReadDivision(int dId)
{
using (var db = new ShipsDbContext()) {
var dd = db.EscortDivisions.Where(x => x.EscortDivisionId == dId)
.Include("EscortFlotilla")
.SingleOrDefault();
return(dd);
}
}
public EscortFlotilla ReadFlotilla(int fId)
{
using (var db = new ShipsDbContext()) {
var fd = db.EscortFlotillas.Where(x => x.EscortFlotillaId == fId)
.Include("EscortDivision")
.SingleOrDefault();
return(fd);
}
}
/// <summary>
/// 艦船名の変更(更新)
/// </summary>
/// <param name="oldname">対象艦船名</param>
/// <param name="newname">新艦船名</param>
public void UpdateShipName(string oldname, string newname)
{
using (var db = new ShipsDbContext()) {
var sds = db.SelfDefenseShips.SingleOrDefault(x => x.ShipName == oldname);
if (sds != null)
{
sds.ShipName = newname;
db.SaveChanges();
}
}
}
/// <summary>
/// 護衛隊群と隷下の護衛隊+護衛隊隷下の護衛艦全読み込み
/// </summary>
/// <returns>List<護衛隊群<護衛隊<護衛艦>>></returns>
public List <EscortFlotilla> ReadFlotillaNest()
{
using (var db = new ShipsDbContext()) {
db.Database.Log = sql => { Debug.Write(sql); };
var fd = db.EscortFlotillas//.Include(x => x.EscortDivision)
.Include(x => x.EscortDivision
.Select(y => y.SelfDefenseShips))
.ToList();
return(fd);
}
}
/// <summary>
/// 指定した艦船番号以上のデータを削除する
/// </summary>
/// <param name="targetnumber">削除の起点となる艦船番号</param>
public void DeleteShipNumberRange(int targetnumber)
{
using (var db = new ShipsDbContext()) {
var sds = db.SelfDefenseShips.Where(x => x.ShipNumber >= targetnumber);
if (sds != null)
{
db.SelfDefenseShips.RemoveRange(sds);
db.SaveChanges();
}
}
}
/// <summary>
/// 指定した艦船情報を削除する
/// </summary>
/// <param name="targetship">削除対象艦船</param>
public void DeleteShipData(string targetship)
{
using (var db = new ShipsDbContext()) {
var sds = db.SelfDefenseShips.SingleOrDefault(x => x.ShipName == targetship);
if (sds != null)
{
db.SelfDefenseShips.Remove(sds);
db.SaveChanges();
}
}
}
public ICollection <EscortDivision> ReadDivisionAll()
{
using (var db = new ShipsDbContext()) {
db.Database.Log = sql => { Debug.Write(sql); };
var dd = db.EscortDivisions.Include(x => x.EscortFlotilla)
.Include(x => x.SelfDefenseShips
.Select(y => y.HullCode))
.ToList();
return(dd);
}
}
public ICollection <EscortDivision> LazyLoadingTest()
{
using (var db = new ShipsDbContext()) {
db.Database.Log = sql => { Debug.Write(sql); };
db.EscortFlotillas.Load();
db.SelfDefenseShips.Load();
db.HullCodes.Load();
db.ShipClasses.Load();
var ed = db.EscortDivisions.ToList();
return(ed);
}
}
/// <summary>
/// 護衛隊群データをインサート（登録）
/// </summary>
public void InsertFlotillaData()
{
using (var db = new ShipsDbContext()) {
//Addを使った方法
//var ef1 = new EscortFlotilla {
// EscortFlotillaName = "第1護衛隊群"
//};
//db.EscortFlotillas.Add(f1);
//var ef2 = new EscortFlotilla {
// EscortFlotillaName = "第2護衛隊群"
//};
//db.EscortFlotillas.Add(f2);
//var ef3 = new EscortFlotilla {
// EscortFlotillaName = "第3護衛隊群"
//};
//db.EscortFlotillas.Add(f3);
//var ef4 = new EscortFlotilla {
// EscortFlotillaName = "第4護衛隊群"
//};
//db.EscortFlotillas.Add(f4);
//var ef5 = new EscortFlotilla {
// EscortFlotillaName = "地域配備部隊"
//};
//db.EscortFlotillas.Add(f5);
//AddRangeを使った方法
var ef = new EscortFlotilla[] {
new EscortFlotilla {
EscortFlotillaName = "第1護衛隊群"
},
new EscortFlotilla {
EscortFlotillaName = "第2護衛隊群"
},
new EscortFlotilla {
EscortFlotillaName = "第3護衛隊群"
},
new EscortFlotilla {
EscortFlotillaName = "第4護衛隊群"
},
new EscortFlotilla {
EscortFlotillaName = "地域配備部隊"
}
};
db.EscortFlotillas.AddRange(ef);
db.SaveChanges();
}
}
/// <summary>
/// 艦船の所属護衛隊を変更(更新)します。
/// </summary>
/// <param name="dname">変更先の護衛隊名</param>
/// <param name="sname">所属変更する艦船名</param>
public void UpdateShipDivision(string dname, string sname)
{
using (var db = new ShipsDbContext()) {
//所属護衛隊の変更先を検索
var ed = db.EscortDivisions.SingleOrDefault(x => x.EscortDivisionName == dname);
//所属護衛隊を変更する艦船を検索
var sds = db.SelfDefenseShips.SingleOrDefault(x => x.ShipName == sname);
if (ed != null && sds != null)
{
//所属先護衛隊のみを変更(更新)
sds.EscortDivision = ed;
db.SaveChanges();
}
}
}
/// <summary>
/// テストデータの追加
/// 護衛隊群,護衛隊,艦種コード,艦種型,艦船データをテスト用に新規に追加します。
/// </summary>
public void InsertTestShipData()
{
using (var db = new ShipsDbContext()) {
var ef = new EscortFlotilla { //テスト用護衛隊群の追加
EscortFlotillaName = "テスト護衛隊群"
};
var ed = new EscortDivision { //テスト用護衛隊の追加
EscortDivisionName = "テスト護衛隊"
, EscortFlotilla = ef
};
var hc = new HullCode { //艦種コード
HullCodeSymbol = "TEST"
};
var sc = new ShipClass { //艦種型
ShipClassName = "テスト型"
};
//1隻目
var sds = new SelfDefenseShip {
EscortDivision = ed,
HullCode = hc,
ShipNumber = 9998, //艦船番号
ShipName = "てすと１", //艦名
ShipClass = sc,
StandardDisplacement = 9999, //基準排水量
FullLoadDisplacement = 9999, //満載排水量
FullLength = 999, //全長
FullWidth = 999, //全幅
CommissionYear = new DateTime(2018, 5, 7) //就役
};
db.SelfDefenseShips.Add(sds);
//2隻目
sds = new SelfDefenseShip {
EscortDivision = ed,
HullCode = hc,
ShipNumber = 9999, //艦船番号
ShipName = "てすと２", //艦名
ShipClass = sc,
StandardDisplacement = 9999, //基準排水量
FullLoadDisplacement = 9999, //満載排水量
FullLength = 999, //全長
FullWidth = 999, //全幅
CommissionYear = new DateTime(2018, 5, 7) //就役
};
db.SelfDefenseShips.Add(sds);
//コミット
db.SaveChanges();
}
}
/// <summary>
/// 艦種型データのインサート（登録）
/// ex.こんごう型,いずも型,ひゅうが型
/// </summary>
public void InsertShipClass()
{
using (var db = new ShipsDbContext())
using (var sr = new StreamReader(@"..\..\Data\ShipClassData.txt")) {
var tmp = sr.ReadToEnd().Split(new string[] { "\r\n" }
, StringSplitOptions.None);
for (int i = 0; i < tmp.Length; i++)
{
var sc = new ShipClass {
ShipClassName = tmp[i]
};
db.ShipClasses.Add(sc); //データをインサート
}
db.SaveChanges(); //DBコミット
}
}
/// <summary>
/// 艦種コードをインサート
/// ex.DD,DE,DDG,DDH
/// </summary>
public void InsertHullCode()
{
using (var db = new ShipsDbContext())
using (var sr = new StreamReader(@"..\..\Data\HullCodeData.txt")) {
var tmp = sr.ReadToEnd().Split(new string[] { "\r\n" }
, StringSplitOptions.None);
for (int i = 0; i < tmp.Length; i++)
{
var hc = new HullCode {
HullCodeSymbol = tmp[i]
};
db.HullCodes.Add(hc); //データをインサート
}
db.SaveChanges(); //DBコミット
}
}
/// <summary>
/// 護衛隊を選択し、それに関連するデータも一括で削除する
/// </summary>
/// <param name="targetdivision">削除対象の護衛隊</param>
public void DeleteDivisionRelation(string targetdivision)
{
using (var db = new ShipsDbContext()) {
var ed = db.EscortDivisions.Where(x => x.EscortDivisionName == targetdivision)
.Include(x => x.EscortFlotilla)
.SingleOrDefault();
var sds = db.SelfDefenseShips.Where(x => x.EscortDivision.EscortDivisionId == ed.EscortDivisionId)
.Include(x => x.HullCode)
.Include(x => x.ShipClass);
if (ed != null)
{
db.SelfDefenseShips.RemoveRange(sds);
db.EscortDivisions.Remove(ed);
db.SaveChanges();
}
}
}
/// <summary>
/// 護衛隊データをインサート（登録）
/// </summary>
public void InsertDivisionData()
{
using (var db = new ShipsDbContext())
using (var sr = new StreamReader(@"..\..\Data\DivisionData.txt")) {
var tmp = sr.ReadToEnd().Split(new string[] { "\r\n" }
, StringSplitOptions.None);
for (int i = 0; i < tmp.Length; i++)
{
var edtmp = tmp[i].Split(new string[] { "\t" }, StringSplitOptions.None);
//ラムダ式内で配列を使用出来ないため。
var efname = edtmp[1];
var ed = new EscortDivision {
EscortDivisionName = edtmp[0],
EscortFlotilla = db.EscortFlotillas.Single(x =>
x.EscortFlotillaName == efname)
};
db.EscortDivisions.Add(ed); //インサート
}
db.SaveChanges(); //DBコミット
}
}
/// <summary>
/// 艦船情報のインサート（登録）
/// </summary>
public void InsertShipData()
{
using (var db = new ShipsDbContext())
using (var sr = new StreamReader(@"..\..\Data\ShipData.txt")) {
var tmp = sr.ReadToEnd().Split(new string[] { "\r\n" }
, StringSplitOptions.None);
for (int i = 0; i < tmp.Length; i++)
{
var sdstmp = tmp[i].Split(new string[] { "\t" }, StringSplitOptions.None);
/*
* LINQ to Entitiesでは配列をラムダ式に適用できないので変数に入れる
*/
var dname = sdstmp[0]; //所属護衛隊名
var hullcode = sdstmp[1]; //艦種コード
var scname = sdstmp[4]; //艦型
var dt = new DateTime(Int32.Parse(sdstmp[7]), 1, 1); //就役年
var sds = new SelfDefenseShip {
EscortDivision = db.EscortDivisions.Single(x =>
x.EscortDivisionName == dname),
HullCode = db.HullCodes.Single(x => x.HullCodeSymbol == hullcode),
ShipNumber = Int32.Parse(sdstmp[2]),
ShipName = sdstmp[3],
ShipClass = db.ShipClasses.Single(x => x.ShipClassName == scname),
StandardDisplacement = Int32.Parse(sdstmp[5]),
FullLoadDisplacement = Int32.Parse(sdstmp[6]),
CommissionYear = dt,
FullLength = Double.Parse(sdstmp[8]),
FullWidth = Double.Parse(sdstmp[9])
};
db.SelfDefenseShips.Add(sds); //データをインサート
}
db.SaveChanges(); //DBコミット
}
}