public async Task <JObject> GetSearchMetadata(string searchName)
{
SearchObject search = await this._context.SearchObjects.
Where(s => s.Name == searchName).
FirstOrDefaultAsync();
if (search == null)
{
throw new Exception("Could not find search");
}
if (!search.IsValid)
{
search = await new SearchCompiler(this._context).Compile(searchName);
this._context.SearchObjects.Update(search);
await this._context.SaveChangesAsync();
}
DataTable dt = evaluateSearch(search.CompiledCountQuery, -1, -1);
int count = Int32.Parse(dt.Rows[0].ItemArray[0].ToString());
return(JObject.FromObject(new {
ResultSize = count,
FieldList = search.CompiledFieldList
}));
}
public List <Series> SearchRecordsFromJson(string jsonContent)
{
var obj = JObject.Parse(jsonContent);
var search = new SearchObject
{
Skip = obj.GetValueFromJObject("skip").ToObject <int>(),
Take = obj.GetValueFromJObject("take").ToObject <int>(),
TotalRecords = obj.GetValueFromJObject("totalRecords").ToObject <int>()
};
var list = new List <iShow>();
foreach (var show in obj["payload"])
{
var newShow = new Show(show);
list.Add(newShow);
}
var retShows =
from shows in
(new SearchBusiness()).FilterShowsByDrmAndEpisodeCount(list)
select new Series()
{
image = shows.Image.ShowImage,
slug = shows.Slug,
title = shows.Title
};
return(retShows.Skip(search.Skip).Take(search.Take).ToList());
}
public void CanRecordObjectWord()
{
string culture = "en-US";
// Setup
SearchObject s = new SearchObject();
s.ObjectType = 0;
s.ObjectId = "1234";
Lexicon lexicon = new Lexicon(new StaticLexicon());
long wordId = lexicon.AddOrCreateWord("thi", culture);
Assert.IsTrue(wordId > 0);
Searcher searcher = new Searcher(lexicon, new StaticSearcher());
long id = searcher.ObjectIndexAddOrUpdate(s);
Assert.IsTrue(id > 0);
// Test
SearchObjectWord w = new SearchObjectWord();
w.SearchObjectId = id;
w.WordId = wordId;
w.Score = 1;
bool actual = searcher.ObjectWordIndexUpdate(w);
Assert.IsTrue(actual);
}
internal unsafe DirectoryVirtualListView RetrieveVLVResponse()
{
if (_disposed)
{
throw new ObjectDisposedException(GetType().Name);
}
// get the vlv response back
AdsSearchColumn column = new AdsSearchColumn();
AdsSearchColumn *pColumn = &column;
SearchObject.GetColumn(Handle, _adsVLVResponseName, (INTPTR_INTPTRCAST)pColumn);
try
{
AdsValue *pValue = column.pADsValues;
DirectoryVirtualListView value = (DirectoryVirtualListView) new AdsValueHelper(*pValue).GetVlvValue();
return(value);
}
finally
{
try
{
SearchObject.FreeColumn((INTPTR_INTPTRCAST)pColumn);
}
catch (COMException)
{
}
}
}
public QueryResponse <RoomQueryModel> GetAllOccuppyRoomsByNumberRoom(SearchObject search)
{
QueryResponse <RoomQueryModel> responseRooms = roomDAO.GetAllOccuppyRoomsByNumberRoom(search);
List <RoomQueryModel> temp = responseRooms.Data;
return(responseRooms);
}
public override IEnumerable <Person> GetByExpression(SearchObject predicate)
{
return(Db.Person.AsNoTracking()
.Skip(0)
.Take(predicate.ItemQuantity)
.ToList());
}
public string SecondFormatSearch(SearchObject searchObject)
{
string result = string.Empty;
foreach (KeyValuePair <string, string> prop in searchObject.SearchItems)
{
if (prop.Value != null)
{
result += String.Format("{0}: {1}, ", prop.Key, prop.Value);
}
}
foreach (KeyValuePair <object, KeyValuePair <object, object> > cond in searchObject.Conditions)
{
if (cond.Value.Key != null)
{
result += String.Format("{0}: {1}, ", cond.Value.Key, cond.Key);
}
}
result = result.Trim();
if (searchObject.SearchItems.Count > 0 && result[result.Length - 1].Equals(','))
{
result = result.TrimEnd(',');
}
return(result.Length == 0 ? "all" : result);
}
private void btnSearch_Click(object sender, RoutedEventArgs e)
{
SearchObject conditions = (criteriaPanel.DataContext as SearchObject);
conditions.Search();
WebClientInfo wci = App.Current.Resources["dbclient"] as WebClientInfo;
String where = conditions.Condition;
String dt = "1=1";
if (StartDate.Text.Trim().Length != 0)
{
dt = " DEPARTURE_TIME>='" + StartDate.Text + "'";
}
if (EndDate.Text.Trim().Length != 0)
{
if (dt.Length > 3)
{
dt += " and DEPARTURE_TIME<='" + EndDate.Text + " 23:59:59'";
}
else
{
dt = " DEPARTURE_TIME<='" + EndDate.Text + " 23:59:59'";
}
}
checkerList.Path = "sql";
checkerList.Names = "save_people,days,papers,notifications,notins,defects,leakages";
String sql = @"SELECT t0.save_people,days,papers,notifications,notins,defects,leakages FROM(SELECT save_people,SUM (ruhu) papers,COUNT (DISTINCT dt) days,SUM (notin) notins FROM(SELECT id,save_people,SUBSTRING (departure_time, 1, 10) dt,CAST (CASE condition WHEN '正常' THEN 1 ELSE 0 END AS INTEGER) ruhu,CAST (CASE condition WHEN '无人' THEN 1 ELSE 0 END AS INTEGER) notin FROM T_INSPECTION WHERE 1 = 1 AND {0} AND {1}) b GROUP BY save_people) t0 LEFT JOIN (SELECT save_people,COUNT (id) leakages FROM(SELECT id, save_people FROM T_INSPECTION WHERE (f_qblouqi = 1 OR f_jpglouqi = 1 OR f_lglouqi = 1 OR f_cooker_leakage = 1 OR f_heater_leakage = 1 OR f_furnace_leakage = 1 OR f_bhglouqi = 1 OR f_biaoqianfa = '漏气' OR f_zaoqianfa = '漏气' OR f_zibifa = '漏气' OR f_zjxianzhuang = '漏气' OR f_rshqxianzhuang = '漏气' OR f_bglxianzhuang = '漏气') AND {0} AND {1}) a GROUP BY save_people) t1 ON t0.save_people = t1.save_people LEFT JOIN (SELECT save_people,COUNT (id) notifications FROM(SELECT id, save_people FROM T_INSPECTION WHERE f_renow_id IS NOT NULL AND f_renow_id <> '' AND {0} AND {1}) c GROUP BY save_people) t2 ON t0.save_people = t2.save_people LEFT JOIN (SELECT save_people,COUNT (id) defects FROM(SELECT id,save_people FROM T_INSPECTION WHERE (f_sibiao = 1 OR f_changtong = 1 OR f_fanzhuang = 1 OR f_qblouqi = 1 OR f_reading_mismatch = 1 OR (f_qibiao IS NOT NULL AND f_qibiao <> '')) AND {0} AND {1}) d GROUP BY save_people) t3 ON t0.save_people = t3.save_people";
checkerList.HQL = String.Format(sql, new String[] { where, dt });
checkerList.Load();
}
private Expression <Func <Produce, bool> > GetSearchCriteria(SearchObject searchObject)
{
Expression <Func <Produce, bool> > mainCriteria = c => c.IsActive == true;
if (!string.IsNullOrEmpty(searchObject.ProduceNameOrCode))
{
mainCriteria =
mainCriteria.And(
c =>
c.ProduceCode.StartsWith(searchObject.ProduceNameOrCode) || c.ProduceName.StartsWith(searchObject.ProduceNameOrCode) ||
c.ProduceCode.EndsWith(searchObject.ProduceNameOrCode) || c.ProduceName.EndsWith(searchObject.ProduceNameOrCode));
}
else
{
if (!string.IsNullOrEmpty(searchObject.ProduceCode))
{
mainCriteria =
mainCriteria.And(
c =>
c.ProduceCode.StartsWith(searchObject.ProduceCode));
}
else
{
if (!string.IsNullOrEmpty(searchObject.ProduceName))
{
mainCriteria =
mainCriteria.And(
c =>
c.ProduceName.StartsWith(searchObject.ProduceName));
}
}
}
return(mainCriteria);
}
public async Task <bool> DeleteSearchAsync(String linkUrl, SearchObject searchObject)
{
var currentSerialized = JsonConvert.SerializeObject(searchObject);
var search = conn.Table <Search>().Where(x => x.SerializedSearch.Equals(currentSerialized)).ToListAsync().Result.First();
if (search == null)
{
Console.WriteLine("----------------------------------------------------------------------------------------------");
}
try
{
var result = await conn.DeleteAsync(search).ConfigureAwait(false);
StatusMessage = string.Format("{0} dropped from database [Link: {1}]", result, linkUrl);
StatusCode = codes.ok;
return(true);
}
catch (Exception ex)
{
StatusMessage = string.Format("Failed to delete record: {0}, Error: {1}", linkUrl, ex.Message);
StatusCode = codes.bad;
return(false);
}
}
public IHttpActionResult SearchMovies(string Left, string Oper, string Right)
{
List <Movie> results = null;
if ((Left == null) || (Oper == null) || (Right == null))
{
return(RedirectToRoute("MovieGet", new { controller = "Movie" }));
}
if (Oper.ToLower() == "gt")
{
Oper = ">";
}
if (Oper.ToLower() == "lt")
{
Oper = "<";
}
try {
SearchObject so = new SearchObject(Left, Oper, Right);
results = movieBLayer.SearchMovie(so);
if ((results == null) || (results.Count == 0))
{
NotFound();
}
}
catch {
throw;
}
return(Ok <List <Movie> >(results));
}
private Expression <Func <PurchaseInvoice, bool> > GetSearchCriteria(SearchObject searchObject)
{
//AK: Amending maon
Expression <Func <PurchaseInvoice, bool> > mainCriteria = c => c.PurchaseInvoiceID.ToString() == c.PurchaseInvoiceID.ToString();
if (!string.IsNullOrEmpty(searchObject.PurchaseInvoiceReference))
{
mainCriteria =
mainCriteria.And(c => c.PurchaseInvoiceReference.ToString().StartsWith(searchObject.PurchaseInvoiceReference));
}
if (!string.IsNullOrEmpty(searchObject.SupplierDepartmentId))
{
Guid supplierDepartmentId;
if (!Guid.TryParse(searchObject.SupplierDepartmentId, out supplierDepartmentId))
{
supplierDepartmentId = Guid.Empty;
}
mainCriteria =
mainCriteria.And(
c => c.SupplierDepartment.SupplierDepartmentID == supplierDepartmentId);
}
if (searchObject.FromDate.HasValue)
{
mainCriteria = mainCriteria.And(c => c.CreatedDate.Value >= searchObject.FromDate.Value);
}
if (searchObject.ToDate.HasValue)
{
mainCriteria = mainCriteria.And(c => c.CreatedDate.Value <= searchObject.ToDate.Value);
}
return(mainCriteria);
}
public string GetRedirectLink(SearchObject searchObject)
{
StoreSearchInformation(searchObject);
var holidaysItem = Sitecore.Context.Database.GetItem(SearchResultsPage);
return String.Concat(LinkManager.GetItemUrl(holidaysItem), GetPageLink(searchObject.Page));
}
internal unsafe byte[] RetrieveDirectorySynchronizationCookie()
{
if (_disposed)
{
throw new ObjectDisposedException(GetType().Name);
}
// get the dirsync cookie back
AdsSearchColumn column = new AdsSearchColumn();
AdsSearchColumn *pColumn = &column;
SearchObject.GetColumn(Handle, _adsDirsynCookieName, (INTPTR_INTPTRCAST)pColumn);
try
{
AdsValue *pValue = column.pADsValues;
byte[] value = (byte[])new AdsValueHelper(*pValue).GetValue();
return(value);
}
finally
{
try
{
SearchObject.FreeColumn((INTPTR_INTPTRCAST)pColumn);
}
catch (COMException)
{
}
}
}
private Expression <Func <Supplier, bool> > GetSearchCriteria(SearchObject searchObject)
{
Expression <Func <Supplier, bool> > mainCriteria = null;
if (searchObject.FromDate.HasValue)
{
mainCriteria = c => c.CreatedDate.Value >= searchObject.FromDate.Value;
}
else // this line should never be hit
{
mainCriteria = c => c.CreatedDate.Value >= DateTime.Today.AddDays(-30);
}
if (searchObject.ToDate.HasValue)
{
mainCriteria = mainCriteria.And(c => c.CreatedDate.Value <= searchObject.ToDate.Value);
}
if (!string.IsNullOrEmpty(searchObject.SupplierCode))
{
mainCriteria = mainCriteria.And(c =>
c.SupplierCode == searchObject.SupplierCode);
}
else if (!string.IsNullOrEmpty(searchObject.SupplierCompanyName))
{
mainCriteria = mainCriteria.And(c =>
c.SupplierCompanyName.StartsWith(searchObject.SupplierCompanyName) |
c.SupplierCompanyName.StartsWith(searchObject.SupplierCompanyName));
}
return(mainCriteria);
}
public static SearchObject createSearchObject(String sDomain = "", String sUser = "", String sPass = "", Boolean ActOnBehalf = false)
{
DirectoryEntry de = null;
DirectorySearcher ds = null;
SearchObject resultObject = new SearchObject();
try
{
de = new DirectoryEntry();
resultObject.sDC = de.Options.GetCurrentServerName();
Console.WriteLine("\n[?] Using DC : " + de.Options.GetCurrentServerName());
if (!String.IsNullOrEmpty(sDomain) && !String.IsNullOrEmpty(sUser) && !String.IsNullOrEmpty(sPass))
{
String sUserDomain = String.Format("{0}\\{1}", sDomain, sUser);
de.Username = sUserDomain;
de.Password = sPass;
}
ds = new DirectorySearcher(de);
if (ActOnBehalf)
{
ds.PropertiesToLoad.Add("msDS-AllowedToActOnBehalfOfOtherIdentity");
}
ds.PageSize = 1000;
resultObject.success = true;
resultObject.searcher = ds;
}
catch
{
resultObject.success = false;
}
return(resultObject);
}
public ActionResult <string> Post(string orgID, string id, SearchObject searchObject)
{
searchObject.Id = id.Replace("\"", "");
List <string> employees = null;
try
{
Console.WriteLine(searchObject.Date);
if (searchObject.Category.Equals("Floor"))
{
int floor = int.Parse(searchObject.Input);
employees = searchObject.GetEmployeeByFloor(floor, orgID);
return(new OkObjectResult(employees));
}
else if (searchObject.Category.Equals("Department"))
{
employees = searchObject.GetEmployeeByDeparment(searchObject.Input, orgID);
return(new OkObjectResult(employees));
}
else if (searchObject.Category.Equals("EmployeeName"))
{
employees = searchObject.GetEmployeeByName(searchObject.Input, orgID);
return(new OkObjectResult(employees));
}
else
{
return(new OkResult());
}
}
catch (Exception e)
{
return(new BadRequestObjectResult("Fail to search on these values " + e.Message));
}
}
private void btnSearch_Click(object sender, RoutedEventArgs e)
{
SearchObject conditions = (criteriaPanel.DataContext as SearchObject);
conditions.Search();
WebClientInfo wci = App.Current.Resources["dbclient"] as WebClientInfo;
String dt = " 1=1";
if (StartDate.Text.Trim().Length != 0)
{
dt = " DEPARTURE_TIME>='" + StartDate.Text + "'";
}
if (EndDate.Text.Trim().Length != 0)
{
if (dt.Length > 3)
{
dt += " and DEPARTURE_TIME<='" + EndDate.Text + " 23:59:59'";
}
else
{
dt = " DEPARTURE_TIME<='" + EndDate.Text + " 23:59:59' ";
}
}
dt = " and " + dt;
checkerList.Path = "sql";
checkerList.Names = "precaution,road,unit_name,cus_dom,cus_dy,cus_floor,cus_room,user_name,telphone,departure_time,precaution_notified";
String sql = @"SELECT CAST (CASE f_heater_trapped WHEN 1 THEN '热水器直排或烟道未排出室外' ELSE '' END AS VARCHAR (50)) + CAST (CASE f_furnace_trapped WHEN 1 THEN '壁挂锅炉直排或烟道未排出室外' ELSE '' END AS VARCHAR (50)) + CAST ( CASE f_precaution_kitchen WHEN 1 THEN '开放式或密闭式厨房' ELSE '' END AS VARCHAR (50)) + CAST (CASE f_precaution_multisource WHEN 1 THEN '多种火源' ELSE '' END AS VARCHAR (50)) + CAST (CASE f_precaution_otheruse WHEN '卧室' THEN '更改用途(卧室)' WHEN '客厅' THEN '更改用途(客厅)' WHEN '浴室' THEN '更改用途(浴室)' ELSE '' END AS VARCHAR (50)) precaution, road,unit_name, cus_dom,cus_dy,cus_floor,cus_room,f_consumername user_name,f_consumerphone telphone,SUBSTRING (DEPARTURE_TIME, 1, 10) departure_time,CAST ( CASE ISNULL(f_renow_id, '') WHEN '' THEN '否' ELSE '是' END AS VARCHAR (50)) precaution_notified FROM T_INSPECTION WHERE 1=1 and {0}";
checkerList.HQL = String.Format(sql, new string[] { conditions.Condition + dt }).Replace("\t", " ").Replace("\n", " ").Replace("\r", " ");
checkerList.Load();
}
private Expression <Func <BankAccount, bool> > GetSearchCriteria(SearchObject searchObject)
{
Expression <Func <BankAccount, bool> > mainCriteria = x => true; // = c;//.IsActive == true;
if (!string.IsNullOrEmpty(searchObject.AccountName))
{
mainCriteria =
mainCriteria.And(c => c.AccountName.ToString().StartsWith(searchObject.AccountName));
}
if (!string.IsNullOrEmpty(searchObject.SupplierDepartmentId))
{
Guid supplierDepartmentId;
if (!Guid.TryParse(searchObject.SupplierDepartmentId, out supplierDepartmentId))
{
supplierDepartmentId = Guid.Empty;
}
mainCriteria =
mainCriteria.And(
c => c.SupplierBankAccounts.Any(a => a.SupplierDepartmentID == supplierDepartmentId));
}
//if (searchObject.FromDate.HasValue)
// mainCriteria = mainCriteria.And(c => c.CreatedDate.Value >= searchObject.FromDate.Value);
//if (searchObject.ToDate.HasValue)
// mainCriteria = mainCriteria.And(c => c.CreatedDate.Value <= searchObject.ToDate.Value);
return(mainCriteria);
}
private void btnSearch_Click(object sender, RoutedEventArgs e)
{
SearchObject conditions = (criteriaPanel.DataContext as SearchObject);
conditions.Search();
WebClientInfo wci = App.Current.Resources["dbclient"] as WebClientInfo;
String dt = "1=1";
if (StartDate.Text.Trim().Length != 0)
{
dt = " DEPARTURE_TIME>='" + StartDate.Text + "'";
}
if (EndDate.Text.Trim().Length != 0)
{
if (dt.Length > 3)
{
dt += " and DEPARTURE_TIME<='" + EndDate.Text + " 23:59:59'";
}
else
{
dt = " DEPARTURE_TIME<='" + EndDate.Text + " 23:59:59' ";
}
}
checkerList.LoadOnPathChanged = false;
checkerList.Path = "sql";
checkerList.Names = "id,CONDITION,UNIT_NAME,CUS_DOM,CUS_DY,CUS_FLOOR,CUS_ROOM,USER_NAME,TELPHONE,RQB_AROUND,CONTENT,SAVE_PEOPLE,DEPARTURE_TIME,REPAIRMAN";
String sql = @"SELECT id, CONDITION, UNIT_NAME, CUS_DOM, CUS_DY, CUS_FLOOR, CUS_ROOM, f_consumername USER_NAME, f_consumerphone TELPHONE, f_rqbiaoxing RQB_AROUND, CAST(CASE f_sibiao WHEN 1 THEN '死表' ELSE '' END AS VARCHAR (50)) + CAST(CASE f_changtong WHEN 1 THEN '常通' ELSE '' END AS VARCHAR (50)) + CAST(CASE f_fanzhuang WHEN 1 THEN '反装' ELSE '' END AS VARCHAR (50)) + CAST(CASE f_qblouqi WHEN 1 THEN '漏气' ELSE '' END AS VARCHAR (50)) + CAST(CASE f_reading_mismatch WHEN 1 THEN '气量不符' ELSE '' END AS VARCHAR (50)) + CAST(CASE f_qbqita WHEN 1 THEN f_qibiao ELSE '' END AS VARCHAR (50)) CONTENT, SAVE_PEOPLE, DEPARTURE_TIME, REPAIRMAN FROM T_INSPECTION WHERE 1=1 AND (f_sibiao = 1 OR f_changtong = 1 OR f_fanzhuang = 1 OR f_qblouqi = 1 OR f_reading_mismatch = 1 OR f_qbqita = 1) AND {0} AND {1}";
checkerList.HQL = String.Format(sql, new String[] { conditions.Condition, dt }).Replace("\r", " ").Replace("\t", " ").Replace("\n", " ");
checkerList.Load();
}
private void btnSearch_Click(object sender, RoutedEventArgs e)
{
SearchObject conditions = (criteriaPanel.DataContext as SearchObject);
conditions.Search();
WebClientInfo wci = App.Current.Resources["dbclient"] as WebClientInfo;
String dt = "1=1";
if (StartDate.Text.Trim().Length != 0)
{
dt = " DEPARTURE_TIME>='" + StartDate.Text + "'";
}
if (EndDate.Text.Trim().Length != 0)
{
if (dt.Length > 3)
{
dt += " and DEPARTURE_TIME<='" + EndDate.Text + " 23:59:59'";
}
else
{
dt = " DEPARTURE_TIME<='" + EndDate.Text + " 23:59:59' ";
}
}
checkerList.LoadOnPathChanged = false;
checkerList.Path = "sql";
checkerList.Names = "id,CONDITION,UNIT_NAME,CUS_DOM,CUS_DY,CUS_FLOOR,CUS_ROOM,USER_NAME,CARD_ID,TELPHONE,SAVE_PEOPLE,DEPARTURE_TIME,ARRIVAL_TIME,RQB_AROUND,REPAIRMAN,CONTENT,sn";
String sql = @"select t.id,t.CONDITION,t.UNIT_NAME,t.CUS_DOM,t.CUS_DY,t.CUS_FLOOR,t.CUS_ROOM,t.USER_NAME,t.CARD_ID,t.TELPHONE,t.SAVE_PEOPLE,t.DEPARTURE_TIME,t.ARRIVAL_TIME,t.RQB_AROUND,t.REPAIRMAN,tt.CONTENT from T_INSPECTION t , T_INSPECTION_LINE tt where t.id=tt.inspection_id
and (t.DELETED is null or t.DELETED <> '是') and tt.EQUIPMENT='燃气表' and tt.CONTENT in ('表不过气', '长通表', '死表') and {0} and {1}";
checkerList.HQL = String.Format(sql, new String[] { conditions.Condition, dt }).Replace("\r\n", " ");
checkerList.Load();
}
static void Main(string[] args)
{
Console.InputEncoding = Encoding.Unicode;
Console.OutputEncoding = Encoding.Unicode;
const int N = 200;
int[] arr = new int[N];
Random rnd = new Random();
Stopwatch time = new Stopwatch();
SearchObject searchCondition = MoreNumber;
while (true)
{
Console.Clear();
Console.Write("Массив: ");
for (int i = 0; i < arr.Length; i++)
{
arr[i] = rnd.Next(-10, 10);
Console.Write("{0,4}", arr[i]);
}
Console.WriteLine();
//1
time.Reset();
time.Start();
FirstMetod(arr);
time.Stop();
Console.WriteLine("Время метода: {0}", time.ElapsedTicks);
//2
time.Reset();
time.Start();
SecondMetod(arr, MoreNumber);
time.Stop();
Console.WriteLine("Время метода: {0}", time.ElapsedTicks);
//3
time.Reset();
time.Start();
ThirdMetod(arr, delegate(int a, int b) { return(a > b); });
time.Stop();
Console.WriteLine("Время метода: {0}", time.ElapsedTicks);
//4
time.Reset();
time.Start();
FourthMetod(arr, (int a, int b) => a > b);
time.Stop();
Console.WriteLine("Время метода: {0}", time.ElapsedTicks);
//5
time.Reset();
time.Start();
FifthMetod(arr);
time.Stop();
Console.WriteLine("Время метода: {0}", time.ElapsedTicks);
//
Console.WriteLine();
Console.WriteLine("Для выхода нажмите \'Enter\'...");
if (Console.ReadKey().Key == ConsoleKey.Enter)
{
break;
}
}
}
async void OnOptionItemSelected(object sender, OptionItemEventArgs e)
{
if (e.Item.TitleFormatted.ToString() == "Save")
{
SearchObject searchObject = new SearchObject();
searchObject.SearchLocation = location;
searchObject.Category = SubCategory.Value != null ? new KeyValuePair <object, object>(SubCategory.Value, SubCategory.Key) : new KeyValuePair <object, object>(category.Key, category.Value);
searchObject.SearchItems = this.SearchItems;
searchObject.Conditions = this.Conditions;
searchObject.MaxListings = this.MaxListings;
searchObject.PostedDate = this.WeeksOld;
string serialized = JsonConvert.SerializeObject(searchObject);
await MainActivity.databaseConnection.AddNewSearchAsync(location.Url, serialized);
Console.WriteLine(MainActivity.databaseConnection.StatusMessage);
if (MainActivity.databaseConnection.StatusCode == Models.codes.ok)
{
Toast.MakeText(context, "Search Saved!", ToastLength.Short).Show();
}
else
{
var message = string.Format("Oops, something went wrong{0}Please try again...", System.Environment.NewLine);
Toast.MakeText(context, message, ToastLength.Short).Show();
}
}
}
private Expression <Func <vwCashTicket, bool> > GetSearchCriteria(SearchObject searchObject)
{
Expression <Func <vwCashTicket, bool> > mainCriteria = null;
if (searchObject.FromDate.HasValue)
{
mainCriteria = c => c.CreatedDate >= searchObject.FromDate.Value;
}
else
{
// this line should never be hit
var temp = DateTime.Today.AddDays(-1).AddHours(22);
mainCriteria = c => c.CreatedDate >= temp;
}
if (searchObject.ToDate.HasValue)
{
mainCriteria = mainCriteria.And(c => c.CreatedDate <= searchObject.ToDate.Value);
}
// if paid == null then we want all paid and unpaid tickets
if (searchObject.Paid != null)
{
mainCriteria = (bool)searchObject.Paid ? mainCriteria.And(c => c.BalanceOwed == 0) : mainCriteria.And(c => c.BalanceOwed != 0);
}
return(mainCriteria);
}
private void dansearchbutton_Click(object sender, RoutedEventArgs e)
{
SearchObject so = daninfosearch.DataContext as SearchObject;
if (null == so.GetPropertyValue("SecondStair"))
{
so.SetPropertyValue("org", so.GetPropertyValue("FirstStair"), false);
}
else
{
if (null == so.GetPropertyValue("ThirdStair"))
{
so.SetPropertyValue("org", so.GetPropertyValue("FirstStair") + "." + so.GetPropertyValue("SecondStair"), false);
}
else
{
if (null == so.GetPropertyValue("FourthStair"))
{
so.SetPropertyValue("org", so.GetPropertyValue("FirstStair") + "." + so.GetPropertyValue("SecondStair") + "." + so.GetPropertyValue("ThirdStair"), false);
}
else
{
if (null == so.GetPropertyValue("f_sgoperator"))
{
so.SetPropertyValue("org", so.GetPropertyValue("FirstStair") + "." + so.GetPropertyValue("SecondStair") + "." + so.GetPropertyValue("ThirdStair") + "." + so.GetPropertyValue("FourthStair"), false);
}
}
}
}
so.Search();
}
public void CanDeleteFromIndex()
{
SearchObject s = new SearchObject();
s.ObjectType = 0;
s.ObjectId = "1234";
Lexicon lexicon = new Lexicon(new StaticLexicon());
Searcher searcher = new Searcher(lexicon, new StaticSearcher());
long id = searcher.ObjectIndexAddOrUpdate(s);
Assert.IsTrue(id > 0);
SearchObject actual = searcher.ObjectIndexFind(id);
Assert.IsNotNull(actual);
Assert.AreEqual(id, actual.Id);
Assert.AreEqual(s.ObjectType, actual.ObjectType);
Assert.AreEqual(s.ObjectId, actual.ObjectId);
bool actual2 = searcher.ObjectIndexDelete(id);
SearchObject existingAfterDelete = searcher.ObjectIndexFind(id);
Assert.IsNull(existingAfterDelete);
}
/// <summary>
/// Funzione per il reperimento dell'indice del documento di cui si sta visualizzando il dettaglio
/// </summary>
/// <param name="elementList">Lista dei documenti restituiti dalla ricerca</param>
/// <returns>Indice del documento di cui si sta vedendo il dettaglio</returns>
public static int GetIndexOfSelectedDocument(ObjScrollElementsList elementList)
{
// Indice da restituire
int index = -1;
string tipo = string.Empty;
foreach (object obj in elementList.objList)
{
if (obj.GetType() == typeof(SearchObject))
{
tipo = "SearchObject";
break;
}
else
{
tipo = "InfoDocumento";
break;
}
}
if (tipo.Equals("SearchObject"))
{
// Recupero della lista dei documenti restituiti dalla ricerca
SearchObject[] result = (SearchObject[])elementList.objList.ToArray(typeof(SearchObject));
// Ricerca dell'oggetto InfoDocumento con id profile uguale a quello selezionato
SearchObject document = result.Where(e => e.SearchObjectID ==
DocumentManager.getRisultatoRicerca(null).idProfile).FirstOrDefault();
// Se il documento è stato trovato, viene calcolato l'indice occupato
// dal documento nell'array
if (document != null)
{
index = Array.IndexOf(result, document);
}
}
else
{
// Recupero della lista dei documenti restituiti dalla ricerca
InfoDocumento[] result = (InfoDocumento[])elementList.objList.ToArray(typeof(InfoDocumento));
// Ricerca dell'oggetto InfoDocumento con id profile uguale a quello selezionato
InfoDocumento document = result.Where(e => e.idProfile ==
DocumentManager.getRisultatoRicerca(null).idProfile).FirstOrDefault();
// Se il documento è stato trovato, viene calcolato l'indice occupato
// dal documento nell'array
if (document != null)
{
index = Array.IndexOf(result, document);
}
}
// Restituzione dell'indice
return(index);
}
public SingleResponse <Supplier> GetIDSuppliersByCompanyName(SearchObject search)
{
SingleResponse <Supplier> responseSuppliers = supplierDAO.GetIDSuppliersByCompanyName(search);
//List<Supplier> temp = responseSuppliers.Data;
return(responseSuppliers);
}
private List <string> compileFieldList(SearchObject search)
{
List <Selection> selections = search.Selections;
return(selections.Select(s => {
return $"{s.ObjectFieldName}";
}).ToList());
}
void Awake()
{
TF = GameObject.FindGameObjectWithTag("Player").GetComponent <ToggleFlashlight>();
EODS = GameObject.FindGameObjectWithTag("MainCamera").GetComponent <EnableOrDisableScripts>();
SO = GameObject.FindGameObjectWithTag("Interact").GetComponent <SearchObject>();
inv = GameObject.FindGameObjectWithTag("Inventory").GetComponent <Inventory>();
player = GameObject.FindGameObjectWithTag("Player");
}
public void ReturnsNullWhenCantFindObject()
{
Lexicon lexicon = new Lexicon(new StaticLexicon());
Searcher searcher = new Searcher(lexicon, new StaticSearcher());
SearchObject actual = searcher.ObjectIndexFind(99);
Assert.IsNull(actual);
}
public void StoreSearchInformation(SearchObject searchObject)
{
var session = System.Web.HttpContext.Current.Session;
// Clear existing holiday search session
session.Remove(Keys.HolidaySearchSession);
session.Add(Keys.HolidaySearchSession, searchObject);
}
protected void SearchButton_Click(object sender, EventArgs e)
{
SearchLinkManager searchLinkManager = new SearchLinkManager();
SearchObject searchObject = new SearchObject()
{
Text = SearchBox.Text,
};
Response.Redirect(searchLinkManager.GetRedirectLink(searchObject), false);
}
/// <summary>
/// 分类视图
/// </summary>
public ActionResult GetCategoryView(int classid = (int)CategoryClass.None, int sort = (int)CategorySort.New, int index = 0, int size = 10)
{
try
{
ViewBag.IsShow = false;
var obj = new SearchObject();
switch (classid)
{
case (int)CategoryClass.None: ViewBag.IsShow = true; break;
case (int)CategoryClass.Monthly: ViewBag.IsShow = true; classid = (int)CategoryClass.None; obj.IsMonthly = true; break;
}
switch (sort)
{
case (int)CategorySort.Free: sort = (int)CategorySort.Hot; obj.IsClientFree = true; break;
case (int)CategorySort.SpecialOffer: sort = (int)CategorySort.Hot; obj.IsSpecialoffer = true; break;
case (int)CategorySort.Finished: sort = (int)CategorySort.Hot; obj.Status = SearchBookStatus.Finished; break;
}
obj.Class = (SearchClass)classid;
obj.Sort = (SearchSort)sort;
obj.Index = index;
obj.Size = size;
var total = 0;
var booksearchlist = _bookservice.Search(obj, out total);
if (total == 0 || booksearchlist.Count == 0)
return new EmptyResult();
ViewBag.total = total;
ViewBag.size = size;
return PartialView("_PartCategoryList", booksearchlist);
}
catch (Exception e)
{
return new EmptyResult();
}
}
//todo：分页读取及分页查询
//查询方法
public static async Task<List<RememberItem>> Query(SearchObject searchObject)
{
SQLiteAsyncConnection dbConn = await CheckOrCreateStorage();
return await dbConn.QueryAsync<RememberItem>(
"Select * from RememberItem where "+ searchObject.FieldName +" like '%" + searchObject.FieldValue + "%'");
}
/// <summary>
/// 出版部分视图
/// </summary>
/// <param name="type"></param>
/// <param name="sort"></param>
/// <param name="index"></param>
/// <param name="size"></param>
/// <returns></returns>
public ActionResult GetPublishView(int type = (int)RecommendClass.Fine, int sort = (int)SearchSort.VipSameDay_Desc, int index = 0, int size = 10)
{
try
{
var obj = new SearchObject();
switch ((RecommendClass)type)
{
case RecommendClass.Finished: obj.Status = SearchBookStatus.Finished; break;
case RecommendClass.Ancient: obj.Class = SearchClass.Aerial | SearchClass.History | SearchClass.PassThrough; break;
case RecommendClass.Modern: obj.Class = SearchClass.Urban | SearchClass.Youth | SearchClass.PowerfulFamily; break;
case RecommendClass.Occult: obj.Class = SearchClass.Ability | SearchClass.Magical | SearchClass.Occult; break;
case RecommendClass.Free: obj.IsClientFree = true; break;
}
obj.Sort = (SearchSort)sort;
obj.Index = index;
obj.Size = size;
var total = 0;
var booksearchlist = _bookservice.Search(obj, out total);
if (total == 0 || booksearchlist.Count == 0)
return new EmptyResult();
ViewBag.total = total;
ViewBag.size = size;
return PartialView("_PartMoreJingPinList", booksearchlist);
}
catch (Exception e)
{
return new EmptyResult();
}
}
/// <summary>
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Search_Click(object sender, EventArgs e)
{
// Clear existing holiday search session
Session.Remove(Keys.HolidaySearchSession);
SearchObject searchObject = new SearchObject()
{
Text = txtSearchText.Text,
HolidayType = !String.IsNullOrEmpty(ddlHolidayType.SelectedValue) ? new Guid(ddlHolidayType.SelectedValue) : Guid.Empty,
Terrain = !String.IsNullOrEmpty(ddlTerrain.SelectedValue) ? new Guid(ddlTerrain.SelectedValue) : Guid.Empty,
Page = 1
};
var searchLinkManager = new SearchLinkManager();
Response.Redirect(searchLinkManager.GetRedirectLink(searchObject), false);
}
