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;
}
