public static bool ExecuteProcess() { SHOLE.Execute.SHOLEConnector.CurrentConnector.Init(settings.SHServerAddress, settings.SHServerPort, settings.SHUserName, settings.SHPassword); var connected = SHOLE.Execute.SHOLEConnector.CurrentConnector.Connect(); Database.SetInitializer(new DropCreateDatabaseIfModelChanges <DBModel>()); var startTime = DateTime.Now; using (var db = new DBModel(settings.ConnectionString)) { // Сначала загружаем все Goods элементы из нужных нам веток дерева foreach (var treeElement in db.TreeElementsNeed.ToList()) { var goodsTree = db.GoodsTree.FirstOrDefault(item => item.goodstree_abbr == treeElement.goodstree_abbr); if (goodsTree != null) { StoreHouseAPI.LoadTree(db, (int)goodsTree.goodstree_rid); } } // Теперь подгружаем их комплекты foreach (var goodsBase in db.GoodsBaseAttrs.Where(goodBase => goodBase.cm_base_rid != 0 && !db.CmHdrAttrs.Any(cmHDR => cmHDR.cm_base_rid == goodBase.cm_base_rid)).ToList()) { StoreHouseAPI.LoadGoodsComplects(db, goodsBase.cm_base_rid); } // Напоследок загружаем листы комплектов StoreHouseAPI.LoadComplectsList(db); SHOLE.Execute.SHOLEConnector.CurrentConnector.Disconnect(); } return(true); }
public bool ExecuteProcess() { var settings = GetSettings(typeof(Settings.SHCMSettings)) as Settings.SHCMSettings; SHOLE.Execute.SHOLEConnector.CurrentConnector.Init(settings.SHServerAddress, settings.SHServerPort, settings.SHUserName, settings.SHPassword); var connected = SHOLE.Execute.SHOLEConnector.CurrentConnector.Connect(); Database.SetInitializer(new DropCreateDatabaseIfModelChanges <DBModel>()); CreateLogRecord($"Export started"); var startTime = DateTime.Now; using (var db = new DBModel(settings.ConnectionString)) { if (!settings.DontReloadTreeElements) { CreateLogRecord($"Loading tree elements"); StoreHouseAPI.LoadTreeElements(db); } var goodsTree = db.GoodsTree.FirstOrDefault(item => item.goodstree_abbr == settings.ParentTreeAbbr); if (goodsTree != null) { CreateLogRecord($"Tree rid {goodsTree.goodstree_rid}"); StoreHouseAPI.LoadTree(db, (int)goodsTree.goodstree_rid); } } CreateLogRecord($"Export finished, it takes {(DateTime.Now - startTime).TotalMinutes} min"); SHOLE.Execute.SHOLEConnector.CurrentConnector.Disconnect(); return(true); }
public static double LoadHDRComplects(bool Override = false) { InitSHConnection(); var startTime = DateTime.Now; using (var db = GetDbModel()) { // Сначала загружаем все ветки дерева комплектов StoreHouseAPI.LoadCmHdrElements(db); } return((DateTime.Now - startTime).TotalMinutes); }
public static double LoadBaseComplects(long groupRid, out string errorInfo) { errorInfo = ""; InitSHConnection(); var startTime = DateTime.Now; using (var db = GetDbModel()) { // Сначала загружаем все ветки дерева комплектов StoreHouseAPI.LoadCmElements(db, groupRid, out errorInfo); } return((DateTime.Now - startTime).TotalMinutes); }
public bool ExecuteProcess() { var settings = GetSettings(typeof(Settings.SHCMSettings)) as Settings.SHCMSettings; SHOLE.Execute.SHOLEConnector.CurrentConnector.Init(settings.SHServerAddress, settings.SHServerPort, settings.SHUserName, settings.SHPassword); var connected = SHOLE.Execute.SHOLEConnector.CurrentConnector.Connect(); Database.SetInitializer(new DropCreateDatabaseIfModelChanges <DBModel>()); CreateLogRecord($"Export started"); var startTime = DateTime.Now; using (var db = new DBModel(settings.ConnectionString)) { // Сначала загружаем все Goods элементы из нужных нам веток дерева CreateLogRecord($"Loading goods elements"); foreach (var treeElement in db.TreeElementsNeed.ToList()) { var goodsTree = db.GoodsTree.FirstOrDefault(item => item.goodstree_abbr == treeElement.goodstree_abbr); if (goodsTree != null) { CreateLogRecord($"Loading goods elements of tree rid {goodsTree.goodstree_rid}"); StoreHouseAPI.LoadTree(db, (int)goodsTree.goodstree_rid); } } // Теперь подгружаем их комплекты CreateLogRecord($"Loading complects"); foreach (var goodsBase in db.GoodsBaseAttrs.Where(goodBase => goodBase.cm_base_rid != 0 && !db.CmHdrAttrs.Any(cmHDR => cmHDR.cm_base_rid == goodBase.cm_base_rid)).ToList()) { StoreHouseAPI.LoadGoodsComplects(db, goodsBase.cm_base_rid); } // Напоследок загружаем листы комплектов CreateLogRecord($"Loading complects lists"); StoreHouseAPI.LoadComplectsList(db); CreateLogRecord($"Export finished, it takes {(DateTime.Now - startTime).TotalMinutes} min"); SHOLE.Execute.SHOLEConnector.CurrentConnector.Disconnect(); } return(true); }