private static IndexPair GetAvailableToHidePair(GameFieldModel model, List<IndexPair> pairs, CancellationToken token, int rank) { foreach (var pair in pairs.ToList()) { token.ThrowIfCancellationRequested(); model.SetItemVisible(pair, false); if (GetHeuristicsAvailableNumbers(model, pair, rank).Count() <= 1) return pair; model.SetItemVisible(pair, true); pairs.Remove(pair); } return null; }
public static List<FS2JournalItem> OnGetFilteredArchive(ArchiveFilter archiveFilter, bool isReport) { var result = new List<FS2JournalItem>(); try { string dateInQuery = "DeviceTime"; if (archiveFilter.UseSystemDate) dateInQuery = "SystemTime"; var query = "SELECT * FROM Journal WHERE " + "\n " + dateInQuery + " > '" + archiveFilter.StartDate.ToString("yyyy-MM-dd HH:mm:ss") + "'" + "\n AND " + dateInQuery + " < '" + archiveFilter.EndDate.ToString("yyyy-MM-dd HH:mm:ss") + "'"; if (archiveFilter.Descriptions.Count > 0) { query += "\n AND ("; for (int i = 0; i < archiveFilter.Descriptions.Count; i++) { if (i > 0) query += "\n OR "; var description = archiveFilter.Descriptions[i]; description = description.Replace("'", "''"); query += " Description = '" + description + "'"; } query += ")"; } if (archiveFilter.Subsystems.Count > 0) { query += "\n AND ("; for (int i = 0; i < archiveFilter.Subsystems.Count; i++) { if (i > 0) query += "\n OR "; var subsystem = archiveFilter.Subsystems[i]; query += " SubSystemType = '" + ((int)subsystem).ToString() + "'"; } query += ")"; } if (archiveFilter.PanelUIDs.Count > 0) { query += "\n AND ("; for (int i = 0; i < archiveFilter.PanelUIDs.Count; i++) { var panelUID = archiveFilter.PanelUIDs[i]; if (panelUID != null) { if (i > 0) query += "\n OR "; query += " PanelUID = '" + panelUID + "'"; } } query += ")"; } query += "\n ORDER BY " + dateInQuery + " DESC"; using (var sqlCeConnection = new SqlCeConnection(ConnectionString)) { sqlCeConnection.ConnectionString = ConnectionString; var journalItems = new List<FS2JournalItem>(); var sqlCeCommand = new SqlCeCommand(query, sqlCeConnection); sqlCeConnection.Open(); var reader = sqlCeCommand.ExecuteReader(); while (reader.Read()) { if (IsAbort && !isReport) break; try { var journalItem = ReadOneJournalItem(reader); result.Add(journalItem); if (!isReport) { journalItems.Add(journalItem); if (journalItems.Count > 100) { if (ArchivePortionReady != null) ArchivePortionReady(journalItems.ToList()); journalItems.Clear(); } } } catch (Exception e) { Logger.Error(e, "DatabaseHelper.OnGetFilteredArchive"); } } if (!isReport) { if (ArchivePortionReady != null) ArchivePortionReady(journalItems.ToList()); } sqlCeConnection.Close(); } } catch (Exception e) { Logger.Error(e, "Исключение при вызове FiresecService.GetFilteredArchive"); throw new FS2Exception(e.Message); } return result; }
public void ClrNamespace() { var type = typeof(DummyClass); string clrNamespace = $"clr-namespace:{type.Namespace};Assembly={type.GetTypeInfo().Assembly.GetName().Name}"; var prefix = "prefix"; var input = new List<ProtoInstruction> { P.NamespacePrefixDeclaration(prefix, clrNamespace), P.EmptyElement(type, RootNs), }; var expectedInstructions = new List<Instruction> { X.NamespacePrefixDeclaration(clrNamespace, prefix), X.StartObject<DummyClass>(), X.EndObject(), }; var actualNodes = sut.Parse(input); Assert.Equal(expectedInstructions.ToList(), actualNodes.ToList()); }
public void NamespaceDeclarationOnly() { var input = new List<ProtoInstruction> { P.NamespacePrefixDeclaration(RootNs), }; var expectedInstructions = new List<Instruction> { X.NamespacePrefixDeclaration(RootNs), }; var actualNodes = sut.Parse(input); Assert.Equal(expectedInstructions.ToList(), actualNodes.ToList()); }
public ActionResult VipOrder() { int status = 0; int mid = 0; List<Model.OrderBase> order = new List<Model.OrderBase>(); List<Model.vw_Orderpinfo> lvlist = new List<Model.vw_Orderpinfo>(); if (!string.IsNullOrEmpty(RequestBase.GetString("status"))) { status = Convert.ToInt32(RequestBase.GetString("status")); ViewData["status"] = status; } if (LoginMember != null) { mid = (CookieEncrypt.DeserializeObject(System.Web.HttpContext.Current.Request.Cookies["UserInfo"].Value) as Model.MemberBase).m_ID; if (status == 0) { order = new BLL.OrderBase().GetModelList(" m_ID=" + mid + " and o_IsDel=0 and o_StatusCode=" + status + " or o_StatusCode=5 "); lvlist = vobll.GetModelList(" o_IsDel=0 and m_ID=" + mid + " and o_StatusCode=" + status + " or o_StatusCode=5 ");//5是退货 } else if (status ==23) { order = new BLL.OrderBase().GetModelList(" m_ID=" + mid + " and o_IsDel=0 and o_StatusCode=2 or o_StatusCode=3"); lvlist = vobll.GetModelList(" o_IsDel=0 and m_ID=" + mid + " and o_StatusCode=2 or o_StatusCode=3"); } else { order = new BLL.OrderBase().GetModelList(" m_ID=" + mid + " and o_IsDel=0 and o_StatusCode=" + status); lvlist = vobll.GetModelList(" o_IsDel=0 and m_ID=" + mid + " and o_StatusCode=" + status); } ViewBag.order = order; return View(lvlist.ToList()); } else { Response.Redirect("/wapLogin/Login"); return View(); } }
public static OperationResult<List<JournalRecord>> OnGetFilteredArchive(ArchiveFilter archiveFilter, bool isReport) { var operationResult = new OperationResult<List<JournalRecord>>(); operationResult.Result = new List<JournalRecord>(); try { string dateInQuery = "DeviceTime"; if (archiveFilter.UseSystemDate) dateInQuery = "SystemTime"; var query = "SELECT * FROM Journal WHERE " + "\n " + dateInQuery + " > '" + archiveFilter.StartDate.ToString("yyyy-MM-dd HH:mm:ss") + "'" + "\n AND " + dateInQuery + " < '" + archiveFilter.EndDate.ToString("yyyy-MM-dd HH:mm:ss") + "'"; if (archiveFilter.Descriptions.Count > 0) { query += "\n AND ("; for (int i = 0; i < archiveFilter.Descriptions.Count; i++) { if (i > 0) query += "\n OR "; var description = archiveFilter.Descriptions[i]; description = description.Replace("'", "''"); query += " Description = '" + description + "'"; } query += ")"; } if (archiveFilter.Subsystems.Count > 0) { query += "\n AND ("; for (int i = 0; i < archiveFilter.Subsystems.Count; i++) { if (i > 0) query += "\n OR "; var subsystem = archiveFilter.Subsystems[i]; query += " SubSystemType = '" + ((int)subsystem).ToString() + "'"; } query += ")"; } if (archiveFilter.PanelUIDs.Count > 0) { query += "\n AND ("; for (int i = 0; i < archiveFilter.PanelUIDs.Count; i++) { var deviceName = archiveFilter.PanelUIDs[i]; if (deviceName != null) { if (i > 0) query += "\n OR "; query += " PanelDatabaseId = '" + deviceName + "'"; } } query += ")"; } query += "\n ORDER BY " + dateInQuery + " DESC"; using (var DataBaseContext = new SqlCeConnection(ConnectionString)) { DataBaseContext.ConnectionString = ConnectionString; var journalRecords = new List<JournalRecord>(); var result = new SqlCeCommand(query, DataBaseContext); DataBaseContext.Open(); var reader = result.ExecuteReader(); while (reader.Read()) { if (IsAbort && !isReport) break; try { var journalRecord = ReadOneJournalRecord(reader); operationResult.Result.Add(journalRecord); if (!isReport) { journalRecords.Add(journalRecord); if (journalRecords.Count > 100) { if (ArchivePortionReady != null) ArchivePortionReady(journalRecords.ToList()); journalRecords.Clear(); } } } catch (Exception e) { Logger.Error(e, "DatabaseHelper.OnGetFilteredArchive"); } } if (!isReport) { if (ArchivePortionReady != null) ArchivePortionReady(journalRecords.ToList()); } DataBaseContext.Close(); } } catch (Exception e) { Logger.Error(e, "Исключение при вызове FiresecService.GetFilteredArchive"); operationResult.HasError = true; operationResult.Error = e.Message.ToString(); } return operationResult; }