public static void FillParameters() { using (databaseTestEntities entities = new databaseTestEntities()) { var famInfo1 = entities.F_S_FamilyInfos.Add(new F_S_FamilyInfos() { FAMILY_NAME = "Базовая стена", FAMILY_SYMBOL = "ВН_ЖБ_100" }); var famInfo2 = entities.F_S_FamilyInfos.Add(new F_S_FamilyInfos() { FAMILY_NAME = "Базовая стена", FAMILY_SYMBOL = "ВН_ЖБ_140" }); var famInfo3 = entities.F_S_FamilyInfos.Add(new F_S_FamilyInfos() { FAMILY_NAME = "Базовая стена", FAMILY_SYMBOL = "ВН_ЖБ_200" }); var p1 = entities.F_S_Parameters.Add(new F_S_Parameters() { NAME_PARAMETER = "Direction", TYPE_PARAMETER = "Point" }); var p2 = entities.F_S_Parameters.Add(new F_S_Parameters() { NAME_PARAMETER = "Location", TYPE_PARAMETER = "Point" }); var p3 = entities.F_S_Parameters.Add(new F_S_Parameters() { NAME_PARAMETER = "Length", TYPE_PARAMETER = "Double" }); var p4 = entities.F_S_Parameters.Add(new F_S_Parameters() { NAME_PARAMETER = "Height", TYPE_PARAMETER = "Double" }); var c1 = entities.F_S_Categories.Add(new F_S_Categories() { NAME_RUS_CATEGORY = "Стены", NAME_ENG_CATEGORY = "" }); entities.F_nn_Category_Parameters.Add(new F_nn_Category_Parameters() { F_S_Categories = c1, F_S_Parameters = p1 }); entities.F_nn_Category_Parameters.Add(new F_nn_Category_Parameters() { F_S_Categories = c1, F_S_Parameters = p2 }); entities.F_nn_Category_Parameters.Add(new F_nn_Category_Parameters() { F_S_Categories = c1, F_S_Parameters = p3 }); entities.F_nn_Category_Parameters.Add(new F_nn_Category_Parameters() { F_S_Categories = c1, F_S_Parameters = p4 }); entities.SaveChanges(); } }
public static void FillFlatsModules() { using (databaseTestEntities entities = new databaseTestEntities()) { F_R_Flats flat1 = entities.F_R_Flats.Add(new F_R_Flats() { COMMERCIAL_NAME = "", WORKNAME = "Flat1", REVISION = 0 }); F_R_Flats flat2 = entities.F_R_Flats.Add(new F_R_Flats() { COMMERCIAL_NAME = "", WORKNAME = "Flat2", REVISION = 0 }); F_R_Flats flat1r1 = entities.F_R_Flats.Add(new F_R_Flats() { COMMERCIAL_NAME = "", WORKNAME = "Flat2", REVISION = 1 }); F_R_Modules module1 = entities.F_R_Modules.Add(new F_R_Modules() { NAME_MODULE = "Module1" }); F_R_Modules module2 = entities.F_R_Modules.Add(new F_R_Modules() { NAME_MODULE = "Module2" }); F_nn_FlatModules fm11 = entities.F_nn_FlatModules.Add( new F_nn_FlatModules() { F_R_Flats = flat1, F_R_Modules = module1, DIRECTION = "0,0,0", LOCATION = "0,0,0", REVISION = 0 }); F_nn_FlatModules fm12 = entities.F_nn_FlatModules.Add( new F_nn_FlatModules() { F_R_Flats = flat1, F_R_Modules = module2, DIRECTION = "1,1,0", LOCATION = "100,100,0", REVISION = 0 }); F_nn_FlatModules fm11r1 = entities.F_nn_FlatModules.Add( new F_nn_FlatModules() { F_R_Flats = flat1, F_R_Modules = module1, DIRECTION = "0,0,0", LOCATION = "0,0,0", REVISION = 1 }); entities.SaveChanges(); } }
public static void GetFM() { // Получить квартиро-модули для квартиры using (databaseTestEntities entities = new databaseTestEntities()) { var flat = entities.F_R_Flats.FirstOrDefault(f => f.ID_FLAT == 1); var fms = flat.F_nn_FlatModules.GroupBy(g => new { g.DIRECTION, g.LOCATION }) .Select(g => g.MaxBy(r => r.REVISION)); } }
public static void GetElementParameters() { using (databaseTestEntities entities = new databaseTestEntities()) { var cps = entities.F_S_Categories. Select(s => new{ w = s.NAME_RUS_CATEGORY, p = s.F_nn_Category_Parameters.Select(t => t.F_S_Parameters.NAME_PARAMETER) } ).ToList(); } }
public static void GetFlatsModules() { using (databaseTestEntities entities = new databaseTestEntities()) { // Квартиры с последней ревизией entities.F_R_Flats.Load(); var flatsLastR = entities.F_R_Flats.Local.GroupBy(f => f.WORKNAME).Select(s => s.MaxBy(r => r.REVISION)); foreach (var flat in flatsLastR) { // Модули с посл ревизией в квартире var modulesLastR = flat.F_nn_FlatModules.GroupBy(g => g.F_R_Modules.NAME_MODULE).Select(s => s.Max(r => r.REVISION)); } } }