循环水项目
blame | 历史 | 补丁 | 提交 | 提交对比 | 忽略空白
duheng
2024-11-17 a2a57963e160a319276c5c8499f16c9809056e4c 
 Service/HStation.Service.Assets.Core/04-dal/03-sqlite/01-PumpMain/PumpSeries.cs


@@ -36,7 +36,7 @@


                    }


                    else


                    {


                        var group = db.Queryable<Entity.AssetsPumpGroup>().ToList().Find(x => x.PumpSeriesID == project.ID);


                        var group = db.Queryable<Entity.AssetsPumpGroup>().ToList().Find(x => x.SeriesID == project.ID);


                        if (group != null)


                        {


                            var groupresult = db.Deleteable(group).ExecuteCommand() > 0;


@@ -47,12 +47,12 @@


                            }


                            else


                            {


                                var map = db.Queryable<Entity.AssetsPumpGroupAndMainMap>()


                                .Where(x => x.PumpGroupID == group.ID)


                                var map = db.Queryable<Entity.AssetsPumpGroupAndMainMapping>()


                                .Where(x => x.GroupID == group.ID)


                                 .ToList();


                                var listid = db.Queryable<Entity.AssetsPumpGroupAndMainMap>()


                                .Where(x => x.PumpGroupID == group.ID)


                                .Select(x => x.PumpMainID)


                                var listid = db.Queryable<Entity.AssetsPumpGroupAndMainMapping>()


                                .Where(x => x.GroupID == group.ID)


                                .Select(x => x.MainID)


                                .ToList();


                                if (map.Count > 0)


                                {


@@ -67,7 +67,7 @@


                                        var main = db.Queryable<Entity.AssetsPumpMain>().ToList();


                                        foreach (var item in main)


                                        {


                                            if (item.PumpSeriesID == project.ID)


                                            if (item.SeriesID == project.ID)


                                            {


                                                listid.Add(item.ID);


                                            }


@@ -90,7 +90,7 @@


                            var main = db.Queryable<Entity.AssetsPumpMain>().ToList();


                            foreach (var item in main)


                            {


                                if (item.PumpSeriesID == project.ID)


                                if (item.SeriesID == project.ID)


                                {


                                    listid.Add(item.ID);


                                }