public async Task <List <PersonalDetailEntity> > EntitiesSP(SearchEntity query) { var result = _context.PersonalDetailEntityListSP .FromSqlRaw($"EXEC GetAllPersonalDetails 5").ToList(); return(result); }
// This might be best moved into a different class later on. public static List <Product> GetProductsForUser(int userId) { List <Product> result = new List <Product>(); SearchEntity search = new SearchEntity(); search.ColumnsToReturn = new List <string>(); search.ColumnsToReturn.Add("ProductId"); search.ConnectionString = Constants.CONNECTION_STRING; LacesRepo.Condition userIdCond = new LacesRepo.Condition(); userIdCond.Column = "SellerId"; userIdCond.Operator = LacesRepo.Condition.Operators.EqualTo; userIdCond.Value = Convert.ToString(userId); LacesRepo.Condition statusCond = new LacesRepo.Condition(); statusCond.Column = "ProductStatusId"; statusCond.Operator = LacesRepo.Condition.Operators.EqualTo; statusCond.Value = Convert.ToString((int)ProductStatusOptions.Removed); statusCond.Invert = true; search.Conditions.Add(userIdCond); search.Conditions.Add(statusCond); search.SchemaName = Constants.SCHEMA_DEFAULT; search.TableName = Constants.TABLE_PRODUCTS; result = new GenericRepository <Product>().Read(search); return(result); }
// This may need revisiting in the future. Currently it does a SELECT * rather than naming specific columns, // which is not best practice. // Additionally, using generics in the DataObject class is not ideal. This should probably be added to the // GenericRepository class. public T GetByValue <T>(string column, string value, string tableName, string schemaName) { T result = default(T); SearchEntity search = new SearchEntity(); search.ConnectionString = Constants.CONNECTION_STRING; Condition searchCond = new Condition(); searchCond.Column = column; searchCond.Operator = Condition.Operators.EqualTo; searchCond.Value = value; search.Conditions.Add(searchCond); search.PageSizeLimit = 1; search.SchemaName = schemaName; search.TableName = tableName; List <T> response = new GenericRepository <T>().Read(search); if (response.Count > 0) { result = response[0]; } return(result); }
public FileResult Generate(SearchEntity searchEntity) { int num; var arrayData = this.GetArrayData(searchEntity, out num); var str = "根基对账单"; using (var stream = System.IO.File.OpenRead(base.Server.MapPath(string.Format("~/Excel/Market/{0}.xls", str)))) { var xlBook = new HSSFWorkbook(stream); this.GenerateM1(arrayData, xlBook); this.GenerateM2(arrayData, xlBook); this.GenerateM3(arrayData, xlBook); if (xlBook.NumberOfSheets > 3) { xlBook.RemoveSheetAt(0); xlBook.RemoveSheetAt(0); xlBook.RemoveSheetAt(0); xlBook.FirstVisibleTab = 0; } var str3 = string.Format("{0}{1:yyMMddHHmmss}.xls", str, DateTime.Now); var path = string.Format(@"{0}Temp\{1}", AppDomain.CurrentDomain.BaseDirectory, str3); if (System.IO.File.Exists(path)) { str3 = str3 + Guid.NewGuid().ToString() + ".xls"; path = string.Format(@"{0}Temp\{1}", AppDomain.CurrentDomain.BaseDirectory, str3); } using (var stream2 = System.IO.File.OpenWrite(path)) { xlBook.Write(stream2); } return this.File(path, "application/vnd.ms-excel", str3); } }
private static List <SearchEntity> DonwloadData() { List <SearchEntity> entities = new List <SearchEntity>(); string sql = "select * from AspNetUsers where IsPsychologist = 1"; string connection = "Server=(localdb)\\mssqllocaldb;Database=aspnet-TWHelp-198A0B6F-A6C5-4A0B-AE3E-A656C11BFDD5;Trusted_Connection=True;MultipleActiveResultSets=true"; using (SqlConnection sqlConnection = new SqlConnection(connection)) using (SqlCommand command = new SqlCommand(sql, sqlConnection)) { sqlConnection.Open(); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { SearchEntity entity = new SearchEntity() { Id = long.Parse(reader["Id"].ToString()), NickName = reader["UserName"].ToString(), Education = reader["Education"].ToString(), AreaOfExpertise = reader["AreaOfExpertise"].ToString(), IsAccountActivated = bool.Parse(reader["IsAccountActivated"].ToString()) }; entities.Add(entity); } } return(entities); }
public IEnumerable <RoomEntity> GetAllPaging(SearchEntity filter, int page, int pageSize, out int totalRow) { DateTime st = filter.StartDate == null ? DateTime.MinValue : filter.StartDate.Value.Date; DateTime et = filter.EndDate == null ? DateTime.MaxValue : filter.EndDate.Value.Date.AddDays(1); if (filter.Keywords == null) { filter.Keywords = ""; } List <RoomEntity> lstroom = new List <RoomEntity>(); try { lstroom = _roomRepository.GetAllListRoom().Where(x => x.Status == filter.Status && (filter.RoomType == null || x.RoomTypeID == filter.RoomType) && (filter.Province == null || x.ProvinceID == filter.Province) && (filter.District == null || x.DistrictID == filter.District) && (filter.Ward == null || x.WardID == filter.Ward) && (filter.StartDate == null || x.CreateDate >= st || x.CreateDate == null) && (filter.EndDate == null || x.CreateDate < et || x.CreateDate == null) && (x.RoomName.Contains(filter.Keywords) || x.Description.Contains(filter.Keywords) || string.IsNullOrEmpty(filter.Keywords)) ).OrderByDescending(x => x.CreateDate).ToList(); totalRow = lstroom.Count(); } catch (Exception ex) { string FunctionName = string.Format("GetAllPaging('{0}')", lstroom); Common.Logs.LogCommon.WriteError(ex.ToString(), FunctionName); totalRow = 0; return(null); } return(lstroom.Skip((page) * pageSize).Take(pageSize)); }
private SearchEntity CreateSearchEntity(SearchSpecification search, DatabaseEntity database) { var queryId = Guid.NewGuid(); var searchEntity = new SearchEntity(queryId); searchEntity.Name = search.Name; searchEntity.JobId = queryId.ToString(); searchEntity.InputContainer = "job-" + queryId.ToString(); searchEntity.OutputContainer = "job-" + queryId.ToString(); searchEntity.DatabaseId = search.DatabaseName; searchEntity.DatabaseType = database.Type; searchEntity.DatabaseContainer = database.ContainerName; searchEntity.Executable = search.Executable; searchEntity.ExecutableArgs = search.ExecutableArgs; searchEntity.ExecutableArgsSanitised = search.ExecutableArgs; searchEntity.State = SearchState.StagingData; searchEntity.StartTime = DateTime.UtcNow; searchEntity.PoolId = search.PoolId; searchEntity.PoolDisplayName = search.PoolDisplayName; searchEntity.TargetDedicated = search.TargetDedicated; searchEntity.VirtualMachineSize = search.VirtualMachineSize; searchEntity.CompletedTasks = 0; searchEntity.TotalTasks = search.SearchInputFiles.Count(); ParseExecutableArgs(search, searchEntity); _tableStorageProvider.InsertEntity(searchEntity); return(searchEntity); }
public void SearchEntities_PropKeyEqualsName() { EtagairCore core = Common.CreateCore(RepositConfig); //==== creates entities, with prop //----create entities Entity toshibaCoreI7 = core.Editor.CreateEntity(); core.Editor.CreateProperty(toshibaCoreI7, "Name", "Toshiba Satellite Core I7"); core.Editor.CreateProperty(toshibaCoreI7, "TradeMark", "Toshiba"); //==== define the search: from the root folder, select all entities having a key prop called 'Name' SearchEntity searchEntities = core.Searcher.CreateSearchEntity(SearchFolderScope.All); //--Add single criteria: property key text equals to 'Name' SearchPropCriterionKeyText criterion = core.Searcher.AddCritPropKeyText(searchEntities, "Name"); criterion.PropKeyTextType = CritOptionPropKeyTextType.AllKeyType; criterion.TextSensitive = CritOptionTextSensitive.No; criterion.TextMatch = CritOptionTextMatch.TextMatchExact; //==== execute the search, get the result: list of found entities SearchEntityResult result = core.Searcher.ExecSearchEntity(searchEntities); // check found entities Assert.AreEqual(1, result.ListEntityId.Count, "One found entities expected"); bool found; found = result.ListEntityId.Contains(toshibaCoreI7.Id); Assert.IsTrue(found, "The entity id toshibaCoreI7 should be selected"); }
/// <summary> /// search entities under the folder parent. /// </summary> /// <param name="searchEntity"></param> /// <param name="folder"></param> /// <param name="result"></param> /// <returns></returns> private bool SearchInFolder(SearchEntity searchEntity, Folder folder, bool goInsideChilds, SearchEntityResult result) { // process each entity in the folder source foreach (KeyValuePair <string, ObjectType> pair in folder.ListChildId) { // is it a folder? if (pair.Value == ObjectType.Folder) { // go inside this folder child? if (goInsideChilds) { // load the folder object Folder folderChild = _reposit.Finder.FindFolderById(pair.Key); SearchInFolder(searchEntity, folderChild, true, result); // process next object continue; } } // is it an entity? if (pair.Value == ObjectType.Entity) { // load the entity Entity entity = _reposit.Finder.FindEntityById(pair.Key); // analyze the criteria properties expression for the entity AnalyzeEntityOnCriteria(searchEntity, entity, result); } // others cases: entity or folder template: do nothing } return(true); }
/// <summary> /// analyze the criteria properties expression for the entity /// </summary> /// <param name="entity"></param> /// <returns></returns> private bool AnalyzeEntityOnCriteria(SearchEntity searchEntity, Entity entity, SearchEntityResult result) { // create a work/exec object of the criteria expression SearchPropBaseWork searchPropBaseWork = CreateAllSearchPropBaseWork(searchEntity.SearchPropRoot); // a bool expr, go inside left and right part SearchPropBoolExprWork searchPropBoolExprWork = searchPropBaseWork as SearchPropBoolExprWork; if (searchPropBoolExprWork != null) { // create work object on the left side // create work object on the right side //return searchPropBoolExprWork; // ok, no error return(true); } // a final criterion SearchPropCriterionKeyTextWork propCritKeyTextWork = searchPropBaseWork as SearchPropCriterionKeyTextWork; if (propCritKeyTextWork != null) { EntitySearcherPropKeyText searcherPropKeyText = new EntitySearcherPropKeyText(_reposit); return(searcherPropKeyText.AnalyzeEntityOnCritKeyText(propCritKeyTextWork, entity, result)); } // TODO: others final criterion type // not implemented throw new Exception("Search property not yet implemented!"); }
public void SearchEntities_DefinedFolders_2_OnePropKeyEqualsName_E_F1_2E_F2_2E() { EtagairCore core = Common.CreateCore(RepositConfig); //==== creates entities, with prop //----create entities Entity toshibaCoreI7 = core.Editor.CreateEntity(); core.Editor.CreateProperty(toshibaCoreI7, "Name", "Toshiba Satellite Core I7"); core.Editor.CreateProperty(toshibaCoreI7, "TradeMark", "Toshiba"); //---- create a folder, under the root Folder foldComputers = core.Editor.CreateFolder(null, "computers"); Entity dellCoreI7 = core.Editor.CreateEntity(foldComputers); core.Editor.CreateProperty(dellCoreI7, "Name", "Dell Inspiron 15-5570-sku6"); core.Editor.CreateProperty(dellCoreI7, "TradeMark", "Dell"); Entity HPCoreI7 = core.Editor.CreateEntity(foldComputers); core.Editor.CreateProperty(HPCoreI7, "Nom", "HP Core i7"); core.Editor.CreateProperty(HPCoreI7, "TradeMark", "HP"); //---- create a folder, under the root Folder foldOthers = core.Editor.CreateFolder(null, "others"); Entity asusCoreI7 = core.Editor.CreateEntity(foldOthers); core.Editor.CreateProperty(asusCoreI7, "Name", "Asus Core i7"); core.Editor.CreateProperty(asusCoreI7, "TradeMark", "Asus"); //==== define the search: from the root folder, select all entities having a key prop called 'Name' SearchEntity searchEntities = core.Searcher.CreateSearchEntity(SearchFolderScope.Defined); //--Add sources folders, set option: go inside folders childs core.Searcher.AddSourceFolder(searchEntities, foldComputers, true); // add a second source folder core.Searcher.AddSourceFolder(searchEntities, foldOthers, true); //--Add single criteria: property key text equals to 'Name' SearchPropCriterionKeyText criterion = core.Searcher.AddCritPropKeyText(searchEntities, "Name"); criterion.TextMatch = CritOptionTextMatch.TextMatchExact; criterion.PropKeyTextType = CritOptionPropKeyTextType.AllKeyType; //==== execute the search, get the result: list of found entities SearchEntityResult result = core.Searcher.ExecSearchEntity(searchEntities); // check found entities Assert.AreEqual(2, result.ListEntityId.Count, "2 found entity expected"); bool found; found = result.ListEntityId.Contains(dellCoreI7.Id); Assert.IsTrue(found, "The entity id dellCoreI7 should be selected"); found = result.ListEntityId.Contains(asusCoreI7.Id); Assert.IsTrue(found, "The entity id asusCoreI7 should be selected"); }
public static List <Image> GetImagesForProduct(int productId) { List <Image> result = new List <Image>(); SearchEntity search = new SearchEntity(); search.ConnectionString = Constants.CONNECTION_STRING; Condition productIdCond = new Condition(); productIdCond.Column = "AssociatedEntityId"; productIdCond.Operator = Condition.Operators.EqualTo; productIdCond.Value = Convert.ToString(productId); Condition entityTypeCond = new Condition(); entityTypeCond.Column = "ImageEntityTypeId"; entityTypeCond.Operator = Condition.Operators.EqualTo; entityTypeCond.Value = Convert.ToString((int)ImageEntityTypeOptions.Product); search.Conditions.Add(productIdCond); search.Conditions.Add(entityTypeCond); search.SchemaName = Constants.SCHEMA_DEFAULT; search.TableName = Constants.TABLE_IMAGES; result = new GenericRepository <Image>().Read(search); return(result); }
/// <summary> /// add it as the root criterion of the unit. /// </summary> /// <param name="searchEntityUnit"></param> /// <param name="keyText"></param> /// <returns></returns> public SearchPropCriterionKeyText AddCritPropKeyText(SearchEntity searchEntity, string keyText) { if (searchEntity == null) { return(null); } // check the text if (string.IsNullOrWhiteSpace(keyText)) { return(null); } // check that a root criterion does not already exists if (searchEntity.SearchPropRoot != null) { // a criterion already exists! return(null); } SearchPropCriterionKeyText criterionPropKeyText = CreateSearchPropCriterionPropKeyText(keyText); searchEntity.SearchPropRoot = criterionPropKeyText; return(criterionPropKeyText); }
public JobPreparationTask GetJobPreparationTask(SearchEntity searchEntity, List <ResourceFile> resourceFiles) { var stdoutLogUploadCmd = GetUploadCommandLine(searchEntity.OutputContainer + "/JobPrep/\\$TaskLog/stdout-$AZ_BATCH_NODE_ID.txt", "../stdout.txt"); var stderrLogUploadCmd = GetUploadCommandLine(searchEntity.OutputContainer + "/JobPrep/\\$TaskLog/stderr-$AZ_BATCH_NODE_ID.txt", "../stderr.txt"); var cmd = string.Format("/bin/bash -c 'query-job-prep.sh {0} {1} {2} {3}; {4}; {5}'", searchEntity.DatabaseId, _storageCredentials.Account, _storageCredentials.Key, searchEntity.DatabaseContainer, stdoutLogUploadCmd, stderrLogUploadCmd); return(new JobPreparationTask { Id = "JobPrep", CommandLine = cmd, EnvironmentSettings = new[] { new EnvironmentSetting("BLOBXFER_STORAGEACCOUNTKEY", _storageCredentials.Key), }, ResourceFiles = resourceFiles, UserIdentity = new UserIdentity(new AutoUserSpecification(elevationLevel: ElevationLevel.Admin)), }); }
/// <summary> /// Create a new searchEntity object. /// </summary> /// <param name="name"></param> /// <returns></returns> public SearchEntity CreateSearchEntity(string name, SearchFolderScope scope) { // check the name if (string.IsNullOrWhiteSpace(name)) { return(null); } if (ListSearchEntity.Find(se => se.Name.Equals(name, StringComparison.InvariantCultureIgnoreCase)) != null) { return(null); } SearchEntity searchEntity = new SearchEntity(); searchEntity.Name = name; searchEntity.SearchFolderScope = scope; // manage the root folder case, depending on the scope ManageRootFolderCase(searchEntity, scope); // save the search object ListSearchEntity.Add(searchEntity); return(searchEntity); }
/// <summary> /// create a boolean expression. /// </summary> /// <param name="searchEntityUnit"></param> /// <param name="searchPropParent"></param> /// <returns></returns> public SearchPropBoolExpr AddSearchPropBoolExpr(SearchEntity searchEntity, SearchPropBoolExpr boolExprParent, BoolExprOperand leftOrRight, SearchBoolOperator oper) { if (searchEntity == null) { return(null); } if (boolExprParent == null) { return(null); } // check that the criterion does not already exists if (searchEntity.SearchPropRoot != null) { // a criterion already exists! return(null); } // check that the criterion does not already exists if (boolExprParent.GetLeftOrRight(leftOrRight) != null) { return(null); } SearchPropBoolExpr expr = new SearchPropBoolExpr(); expr.Operator = oper; // set the prop operand to the left or to the right boolExprParent.SetLeftOrRight(leftOrRight, expr); return(expr); }
private dynamic OnSearchFriendRequestRequest(dynamic arg) { var searchRequest = new SerializeHelper().DeserializeObject <SearchRequest>(Request.Body); SearchEntity searchEntity = searchRequest.Entity; if (searchEntity != SearchEntity.IncomingFriendRequests && searchEntity != SearchEntity.OutgoingFriendRequests) { throw new InvalidOperationException($"Search entity '{ searchEntity }' must not be sent to this controller"); } AccountStateService stateService = AccountStateService.Instance; FriendRequestService requestService = FriendRequestService.Instance; SessionAuth clientAuth = Request.Headers.GetSessionAuth(); if (!stateService.IsAuthorized(searchRequest.SenderId, clientAuth.ClientToken)) { throw new ClientNotAuthorizedException(searchRequest.SenderId); } IEnumerable <ComplexFriendRequest> requests = searchEntity == SearchEntity.IncomingFriendRequests ? requestService.GetIncomingRequests(searchRequest.SenderId) : requestService.GetOutgoingRequests(searchRequest.SenderId); IEnumerable <FriendRequest> clientModels = requests.Select(complexModel => complexModel.ToSimple()); string serialized = new SerializeHelper().Serialize(clientModels); return(serialized); }
public VideoSearchEntity(SearchEntity _searchEntity) : base(_searchEntity.Type, _searchEntity.Text) { switch (Type) { case "Series": FontColor = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#db3a34")); Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#e15d58")); break; case "Alt Series": FontColor = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#fca311")); Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#fdc467")); break; case "Tag": FontColor = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#084c61")); Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#618d9a")); break; default: FontColor = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#323031")); Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#7c7b7b")); break; } }
/// <summary> /// Manage the root folder case, depending on the scope. /// </summary> /// <param name="searchEntity"></param> /// <param name="scope"></param> /// <returns></returns> private bool ManageRootFolderCase(SearchEntity searchEntity, SearchFolderScope scope) { if (scope == SearchFolderScope.Defined) { // nothing to do, the user should define source folder return(true); } // get the root folder Folder rootFolder = _reposit.Finder.GetRootFolder(); // go inside sub-folders if (scope == SearchFolderScope.All) { // add it to search object searchEntity.AddSourceFolder(rootFolder, true); return(true); } // doesn't go inside sub-folders if (scope == SearchFolderScope.RootOnly) { // add it to search object searchEntity.AddSourceFolder(rootFolder, false); return(true); } // error? return(false); }
// This might be best moved into a different class later on. public static List <Comment> GetCommentsForProduct(int productId) { List <Comment> result = new List <Comment>(); SearchEntity search = new SearchEntity(); search.ColumnsToReturn = new List <string>(); search.ColumnsToReturn.Add("CommentId"); search.ConnectionString = Constants.CONNECTION_STRING; LacesRepo.Condition userIdCond = new LacesRepo.Condition(); userIdCond.Column = "ProductId"; userIdCond.Operator = LacesRepo.Condition.Operators.EqualTo; userIdCond.Value = Convert.ToString(productId); search.Conditions.Add(userIdCond); search.SchemaName = Constants.SCHEMA_DEFAULT; search.TableName = Constants.TABLE_IMAGES; result = new GenericRepository <Comment>().Read(search); return(result); }
/// <summary> /// Deal with any arguments and possible output filename. /// If a output filename is specified, create a string 'format' based /// on that and string out the arg. /// </summary> private void ParseExecutableArgs(SearchSpecification searchSpec, SearchEntity searchEntity) { var outputFormat = "output-{0}.xml"; var executableArgs = searchSpec.ExecutableArgs; if (!string.IsNullOrEmpty(executableArgs)) { var tokens = executableArgs.Split(new[] { ' ' }, StringSplitOptions.RemoveEmptyEntries).ToList(); if (tokens.Any(token => token == "-out")) { var indexOfOutArg = tokens.IndexOf("-out"); var indexOfOutFilename = indexOfOutArg + 1; if (indexOfOutFilename > tokens.Count - 1) { throw new Exception("No filename specified for -out argument"); } var outputFilename = tokens[indexOfOutArg + 1]; var name = Path.GetFileNameWithoutExtension(outputFilename); var extension = Path.GetExtension(outputFilename); outputFormat = name + "-{0}" + extension; // Strip out the -out filename args as we already set it later executableArgs = executableArgs.Replace(" -out " + outputFilename, " "); } } searchEntity.ExecutableArgsSanitised = executableArgs; searchEntity.OutputfileFormat = outputFormat; }
public CM_UserListEntity GetUserInfoByCardNo(string cardNo) { CM_UserListEntity userListModel = new CM_UserListEntity(); userListModel.UserKahao = cardNo; Dictionary<string, object> args = new Dictionary<string, object>(); List<CM_UserListEntity> listUser = null; using (ICM_UserListService userlist = new CM_UserListService(new DataAccess("defaultRead"))) { listUser = userlist.GetCM_UserListCollection(args); } using (ICM_UserListService userlist = new CM_UserListService()) { userListModel = listUser[10]; userListModel.UserKahao = "01020102"; var list = userlist.InsertCM_UserListEntity(userListModel); } SearchEntity entity = new SearchEntity("GetCM_UserListEntityByKahao", System.Data.CommandType.StoredProcedure); entity["UserKahao"] = cardNo; using (IDbExecuter service = new ExCommonService()) { var uList = service.ExecuteSelect<CM_UserListEntity>(entity).ToList(); userListModel = uList.Count > 0 ? uList[0] : null; } return userListModel; }
/// <summary> /// Add a property criterion to a search unit. /// set to the left or to the right operand of the expression. /// </summary> /// <param name="criteria"></param> /// <param name="keyText"></param> /// <returns></returns> public SearchPropCriterionKeyText AddCritPropKeyText(SearchEntity searchEntity, SearchPropBoolExpr boolExprParent, BoolExprOperand leftOrRight, string keyText) { if (searchEntity == null) { return(null); } if (boolExprParent == null) { return(null); } // check the text if (string.IsNullOrWhiteSpace(keyText)) { return(null); } // check that the criterion does not already exists if (boolExprParent.GetLeftOrRight(leftOrRight) != null) { return(null); } SearchPropCriterionKeyText criterionPropKeyText = CreateSearchPropCriterionPropKeyText(keyText); // set the prop operand to the left or to the right boolExprParent.SetLeftOrRight(leftOrRight, criterionPropKeyText); return(criterionPropKeyText); }
public DataResultArgs <List <PaymentEntity> > Get_Payment(SearchEntity entity) { DataProcess.ControlAdminAuthorization(); DataResultArgs <List <PaymentEntity> > resultSet = new DataResultArgs <List <PaymentEntity> >(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@id", entity.Id); cmd.Parameters.AddWithValue("@isActive", entity.IsActive); cmd.Parameters.AddWithValue("@isDeleted", entity.IsDeleted); using (SqlConnection con = Connection.Conn) { con.Open(); DataResultArgs <SqlDataReader> result = DataProcess.ExecuteProcDataReader(con, cmd, "get_Payment"); if (result.HasError) { resultSet.HasError = result.HasError; resultSet.ErrorDescription = result.ErrorDescription; resultSet.ErrorCode = result.ErrorCode; } else { List <PaymentEntity> lst = GetList(result); resultSet.Result = lst; } con.Close(); } return(resultSet); }
public JsonResult LoadAllRoom(SearchEntity filter, int page, int pageSize = 20) { JsonResult jsonResult = new JsonResult(); try { HttpRequestBase request = this.HttpContext.Request; if (ValidateRequestHeader(request)) { int totalRow = 0; var data = _roomService.GetAllPaging(filter, page, pageSize, out totalRow); var paginationSet = new PaginationSet <RoomEntity>() { Items = data, TotalCount = totalRow, Success = true }; jsonResult = Json(new { lstData = paginationSet }, JsonRequestBehavior.AllowGet); } else { jsonResult = Json(new { success = false }, JsonRequestBehavior.AllowGet); } } catch (Exception ex) { jsonResult = Json(new { success = false }, JsonRequestBehavior.AllowGet); throw ex; } return(jsonResult); }
private IEnumerable <CloudTask> GetTasks(SearchEntity searchEntity, IEnumerable <SearchQueryEntity> queries) { var taskId = 0; foreach (var query in queries) { var cmd = string.Format("/bin/bash -c '{0}; result=$?; {1}; exit $result'", GetBlastCommandLine(searchEntity.DatabaseId, searchEntity.Executable, searchEntity.ExecutableArgsSanitised, query.QueryFilename, query.QueryOutputFilename, query.LogOutputFilename), GetUploadCommandLine(searchEntity.OutputContainer)); var task = new CloudTask(taskId.ToString(), cmd); task.DisplayName = query.QueryFilename; task.UserIdentity = new UserIdentity(new AutoUserSpecification(elevationLevel: ElevationLevel.Admin)); task.ResourceFiles = new List <ResourceFile> { new ResourceFile(_blobStorageProvider.GetBlobSAS(searchEntity.InputContainer, query.QueryFilename), query.QueryFilename) }; task.EnvironmentSettings = new[] { new EnvironmentSetting("BLOBXFER_STORAGEACCOUNTKEY", _storageCredentials.Key), }; yield return(task); taskId++; } }
private void SubmitBatchJob(SearchEntity searchEntity, IEnumerable <SearchQueryEntity> queries, List <ResourceFile> resourceFiles) { PoolInformation poolInfo; if (!string.IsNullOrEmpty(searchEntity.PoolId)) { poolInfo = new PoolInformation { PoolId = searchEntity.PoolId, }; } else { var maxTasksPerNode = _configuration.GetCoresForVirtualMachineSize(searchEntity.VirtualMachineSize); if (searchEntity.TargetDedicated == 1 && maxTasksPerNode == 1) { // Need to always ensure a JM can run maxTasksPerNode = 2; } poolInfo = new PoolInformation { AutoPoolSpecification = new AutoPoolSpecification { PoolSpecification = new PoolSpecification { TargetDedicated = searchEntity.TargetDedicated, MaxTasksPerComputeNode = maxTasksPerNode, VirtualMachineSize = searchEntity.VirtualMachineSize, VirtualMachineConfiguration = _configuration.GetVirtualMachineConfiguration(), }, PoolLifetimeOption = PoolLifetimeOption.Job, KeepAlive = false, } }; } var job = _batchClient.JobOperations.CreateJob(searchEntity.JobId, poolInfo); job.DisplayName = searchEntity.DatabaseId; job.JobPreparationTask = GetJobPreparationTask( searchEntity.DatabaseId, searchEntity.DatabaseContainer, resourceFiles); job.JobManagerTask = GetJobManagerTask( searchEntity.Id.ToString(), resourceFiles); job.Commit(); var tasks = GetTasks(searchEntity, queries); job.Refresh(); job.AddTask(tasks); // job.Refresh(); // job.OnAllTasksComplete = OnAllTasksComplete.TerminateJob; }
public async Task <ActionResult> test(SearchEntity searchEntity) { //int rows2 = await orderMonitorService.Insert(new System.Collections.ArrayList //{ // new test1(){批次号="1",运单号="11",创建时间=DateTime.Now }, // new test1(){批次号="2",运单号="22",创建时间=DateTime.Now }, // new test1(){批次号="3",运单号="33",创建时间=DateTime.Now }, //}); return(Json(new { rows = ConfigHelper.GetWebConfigString("MySqlConnectionString1"), Msg = AppDomain.CurrentDomain.BaseDirectory, Status = 0, total = "1111" }, JsonSettings)); }
/// <summary> /// Search entities by the key property. /// Create 3 entities, select entities having a property key equals to 'Name'. /// /// computers\ /// Ent: Name=Toshiba Ok, selected /// Ent: Name=Dell Ok, selected /// Ent: Company=HP --NOT selected /// /// -------output: /// Db initialized with success. /// -Search result: nb= 2 /// Ent, id: 5c6822abdd125603e885d8d4 /// Ent, id: 5c6822c1dd125603e885d8d6 /// </summary> public void CreateThreeEntitiesSearchPropKeyName() { EtagairEngine engine = CreateEngine(); //---- create a folder, under the root Folder foldComputers = engine.Editor.CreateFolder(null, "computers"); //==== creates entities, with prop //----create entity Entity toshibaCoreI7 = engine.Editor.CreateEntity(foldComputers); engine.Editor.CreateProperty(toshibaCoreI7, "Name", "Toshiba Satellite Core I7"); engine.Editor.CreateProperty(toshibaCoreI7, "TradeMark", "Toshiba"); //----create entity Entity dellCoreI7 = engine.Editor.CreateEntity(foldComputers); engine.Editor.CreateProperty(dellCoreI7, "Name", "Dell Inspiron 15-5570-sku6"); engine.Editor.CreateProperty(dellCoreI7, "TradeMark", "Dell"); //----create entity Entity HPCoreI7 = engine.Editor.CreateEntity(foldComputers); engine.Editor.CreateProperty(HPCoreI7, "Company", "HP Core i7"); engine.Editor.CreateProperty(HPCoreI7, "TradeMark", "HP"); //==== define the search: from the root folder, select all entities having a key prop called 'Name' SearchEntity searchEntities = engine.Searcher.CreateSearchEntity("EntitiesHavingPropName", SearchFolderScope.Defined); //--Add sources folders, set option: go inside folders childs // (only one for now is managed!!) engine.Searcher.AddSourceFolder(searchEntities, foldComputers, true); //--Add criteria: (a boolean expression) SearchPropCriterionKeyText criterion = engine.Searcher.AddCritPropKeyText(searchEntities, "Name"); criterion.TextMatch = CritOptionTextMatch.TextMatchExact; criterion.PropKeyTextType = CritOptionPropKeyTextType.AllKeyType; //==== execute the search, get the result: list of found entities SearchEntityResult result = engine.Searcher.ExecSearchEntity(searchEntities); // displays found entities Console.WriteLine("-Search result: nb=" + result.ListEntityId.Count); foreach (string entityId in result.ListEntityId) { // displays the id of the entity Console.WriteLine("Ent, id: " + entityId); // load the entity and display it Entity entity = engine.Searcher.FindEntityById(entityId); // display the properties of the entity.... } }
// TODO: gérer trad finale absente -> selectionne la mainLang // exp: pas de texte en fr_FR mais existe en fr, prend ce dernier. /// <summary> /// select entities having a property key='Name' /// /// computers\ /// Ent: Name=Toshiba Ok, selected /// Ent: Name=Dell Ok, selected /// Ent: Company=HP --NOT selected /// /// </summary> /// <param name="core"></param> static void TestSearchEntity(EtagairCore core) { Console.WriteLine("====>TestSearchEntity: "); //---- create a folder, under the root Folder foldComputers = core.Editor.CreateFolder(null, "computers"); //==== creates entities, with prop //----create entity Entity toshibaCoreI7 = core.Editor.CreateEntity(foldComputers); core.Editor.CreateProperty(toshibaCoreI7, "Name", "Toshiba Satellite Core I7"); core.Editor.CreateProperty(toshibaCoreI7, "TradeMark", "Toshiba"); //----create entity Entity dellCoreI7 = core.Editor.CreateEntity(foldComputers); core.Editor.CreateProperty(dellCoreI7, "Name", "Dell Inspiron 15-5570-sku6"); core.Editor.CreateProperty(dellCoreI7, "TradeMark", "Dell"); //----create entity Entity HPCoreI7 = core.Editor.CreateEntity(foldComputers); core.Editor.CreateProperty(HPCoreI7, "Company", "HP Core i7"); core.Editor.CreateProperty(HPCoreI7, "TradeMark", "HP"); //==== define the search: from the root folder, select all entities having a key prop called 'Name' SearchEntity searchEntities = core.Searcher.CreateSearchEntity(SearchFolderScope.Defined); //--Add sources folders, set option: go inside folders childs core.Searcher.AddSourceFolder(searchEntities, foldComputers, true); //--Add criteria: (a boolean expression) SearchPropCriterionKeyText criterion = core.Searcher.AddCritPropKeyText(searchEntities, "Name"); criterion.PropKeyTextType = CritOptionPropKeyTextType.AllKeyType; criterion.TextMatch = CritOptionTextMatch.TextMatchExact; //--set options // TODO: lesquelles? //==== execute the search, get the result: list of found entities SearchEntityResult result = core.Searcher.ExecSearchEntity(searchEntities); // displays found entities Console.WriteLine("-Search result: nb=" + result.ListEntityId.Count); foreach (string entityId in result.ListEntityId) { // load the entity Console.WriteLine("Ent, id: " + entityId); } }
public DataResultArgs <List <PaymentTypeEntity> > Get_PaymentType(SearchEntity entity) { DataProcess.ControlAdminAuthorization(); if (staticPaymentTypeList == null) { DataResultArgs <List <PaymentTypeEntity> > resultSet = new DataResultArgs <List <PaymentTypeEntity> >(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@id", entity.Id); cmd.Parameters.AddWithValue("@isActive", entity.IsActive); cmd.Parameters.AddWithValue("@isDeleted", entity.IsDeleted); using (SqlConnection con = Connection.Conn) { con.Open(); DataResultArgs <SqlDataReader> result = DataProcess.ExecuteProcDataReader(con, cmd, "get_PaymentType"); if (result.HasError) { resultSet.HasError = result.HasError; resultSet.ErrorDescription = result.ErrorDescription; resultSet.ErrorCode = result.ErrorCode; } else { SqlDataReader dr = result.Result; List <PaymentTypeEntity> lst = new List <PaymentTypeEntity>(); PaymentTypeEntity elist; while (dr.Read()) { elist = new PaymentTypeEntity(); elist.Id = GeneralFunctions.GetData <Int32>(dr["id"]); elist.Name = GeneralFunctions.GetData <String>(dr["name"]); elist.Amount = GeneralFunctions.GetData <Decimal?>(dr["amount"]); elist.IsActive = GeneralFunctions.GetData <Boolean?>(dr["isActive"]); elist.UpdatedOn = GeneralFunctions.GetData <DateTime>(dr["updatedOn"]); lst.Add(elist); } dr.Close(); resultSet.Result = lst; } con.Close(); } staticPaymentTypeList = resultSet; } return(staticPaymentTypeList); }
/// <summary> /// 查询SMS记录 /// </summary> /// <param name="searchModel"></param> /// <returns></returns> public static Response <List <SearchResponse> > Search(SearchEntity searchModel) { var request = new RestRequest("sms/_search", Method.POST) { RequestFormat = DataFormat.Json }; request.AddBody(searchModel); var response = _client.Execute <List <SearchResponse> >(request); return(ToResponse(response)); }
private void button2_Click(object sender, RoutedEventArgs e) { SearchEntity masha = new SearchEntity(Int32.Parse(textBox.Text)); while (!masha.isReady) System.Threading.Tasks.Task.Delay(TimeSpan.FromSeconds(0.01)).Wait(); // now user is ready // user has also additional fields (if it is not hidden) UserDescription profile = masha.getDescription(); // loading user's friend FriendsList mashas_friends = masha.getFriends(); this.listBox1.Visibility = System.Windows.Visibility.Hidden; this.listBox2.Visibility = System.Windows.Visibility.Visible; this.listBox2.ItemsSource = mashas_friends.friends; }
private void button3_Click(object sender, RoutedEventArgs e) { Search town = new Search(Int32.Parse(textBox2.Text)); while (!town.isReady) System.Threading.Tasks.Task.Delay(TimeSpan.FromSeconds(0.01)).Wait(); Random random = new Random(); int randomNumber = random.Next(0, 500); Search search = town; int id = search.search[randomNumber].id; SearchEntity masha = new SearchEntity(id); while (!masha.isReady) System.Threading.Tasks.Task.Delay(TimeSpan.FromSeconds(0.01)).Wait(); List<UserDescription> mashas_friends = masha.getFriends().friends; List<Levels> levelsList = new List<Levels>(); Levels levels = friendsList(masha, 0); XmlDocument doc = new XmlDocument(); string str = SerializeObject(levels); File.WriteAllText("MyFile.xml", str); }
/// <summary> /// 根据提供的条件获取数据 /// </summary> /// <param name="searchEntity">查询的条件清单</param> /// <returns></returns> public JsonResult GetData(SearchEntity searchEntity) { int iTotal; var rows = this.GetArrayData(searchEntity, out iTotal); return base.Json(new { success = true, total = iTotal, rows = rows }, JsonRequestBehavior.AllowGet); }
private List<v_delivery_bill_join_order> GetArrayData(SearchEntity searchEntity, out int iTotal) { using (var entities = new ydERPGJEntities()) { string str; object[] objArray; var q = entities.v_delivery_bill_join_order.AsQueryable<v_delivery_bill_join_order>(); var row = q.FirstOrDefault<v_delivery_bill_join_order>(); var dicSearchEntity = new JavaScriptSerializer().Deserialize<Dictionary<string, string>>(searchEntity.searchjson); var list = new List<Search2FieldInfo> { new Search2FieldInfo("bill_date_start", ">=", "bill_date", FieldType.Date), new Search2FieldInfo("bill_date_end", "<=", "bill_date", FieldType.Date) }; var dicKey2OperateName = new Dictionary<string, string>(); var dicKey2FieldName = new Dictionary<string, string>(); var dicColTypes = new Dictionary<string, FieldType>(); list.ForEach(delegate(Search2FieldInfo rr) { dicKey2OperateName.Add(rr.SearchName, rr.OperateName); dicKey2FieldName.Add(rr.SearchName, rr.FieldName); dicColTypes.Add(rr.SearchName, rr.FieldType); }); ydAnalysisInputLinq.GetSqlParameter( dicSearchEntity, dicKey2OperateName, row, dicKey2FieldName, dicColTypes, out str, out objArray ); //加入筛选条件 if ((!string.IsNullOrWhiteSpace(str) && (objArray != null)) && (objArray.Length > 0)) { q = q.Where<v_delivery_bill_join_order>(str, objArray); } //总行数 iTotal = q.Count<v_delivery_bill_join_order>(); //是否有执行排序 bool isOrdered; //执行排序 q = ydHelperLinq.DataSort<v_delivery_bill_join_order>( q, out isOrdered, Request.Params["sort"], Request.Params["order"] ); //未排序则按照日期降序排序 if (!isOrdered) { q = ydHelperLinq.DataSort<v_delivery_bill_join_order>(q, out isOrdered, "LastChangeDateTime", "desc"); } //分页 return ydHelperLinq.DataPagination<v_delivery_bill_join_order>( q, int.Parse(Request.Params["offset"]), int.Parse(Request.Params["limit"]) ).ToList(); } }
public FileResult ToExcel(SearchEntity searchEntity) { int iTotal; var rows = this.GetArrayData(searchEntity, out iTotal); var dicColInfo = new Dictionary<string, Tuple<int, string>>(); var colIndex = 0; dicColInfo.Add("bill_month", Tuple.Create<int, string>(colIndex++, "单据月份")); dicColInfo.Add("bill_date", Tuple.Create<int, string>(colIndex++, "单据日期")); dicColInfo.Add("cust_name", Tuple.Create<int, string>(colIndex++, "客户名称")); dicColInfo.Add("bill_num", Tuple.Create<int, string>(colIndex++, "送货单号")); dicColInfo.Add("row_id", Tuple.Create<int, string>(colIndex++, "行号")); dicColInfo.Add("order_id", Tuple.Create<int, string>(colIndex++, "订单序号")); dicColInfo.Add("market_dept", Tuple.Create<int, string>(colIndex++, "事业部")); dicColInfo.Add("product_num", Tuple.Create<int, string>(colIndex++, "生产编号")); dicColInfo.Add("cust_num", Tuple.Create<int, string>(colIndex++, "客户编号")); dicColInfo.Add("order_num", Tuple.Create<int, string>(colIndex++, "订单编号")); dicColInfo.Add("specification", Tuple.Create<int, string>(colIndex++, "规格")); dicColInfo.Add("batch_num", Tuple.Create<int, string>(colIndex++, "批号")); dicColInfo.Add("pcs_qty", Tuple.Create<int, string>(colIndex++, "交货数量")); dicColInfo.Add("foc_pcs_qty", Tuple.Create<int, string>(colIndex++, "备品数量")); dicColInfo.Add("product_date", Tuple.Create<int, string>(colIndex++, "生产日期")); dicColInfo.Add("remark", Tuple.Create<int, string>(colIndex++, "备注")); dicColInfo.Add("remark_head", Tuple.Create<int, string>(colIndex++, "单据备注")); dicColInfo.Add("lot_id_list", Tuple.Create<int, string>(colIndex++, "流程卡清单")); dicColInfo.Add("add_person", Tuple.Create<int, string>(colIndex++, "录入员")); dicColInfo.Add("add_time", Tuple.Create<int, string>(colIndex++, "录入时间")); dicColInfo.Add("last_change_time", Tuple.Create<int, string>(colIndex++, "最后修改时间")); dicColInfo.Add("cust_id", Tuple.Create<int, string>(colIndex++, "客户序号")); dicColInfo.Add("cust_long_name", Tuple.Create<int, string>(colIndex++, "客户全名")); dicColInfo.Add("cust_contact", Tuple.Create<int, string>(colIndex++, "客户联系人")); dicColInfo.Add("cust_telephone", Tuple.Create<int, string>(colIndex++, "客户电话")); dicColInfo.Add("cust_fax", Tuple.Create<int, string>(colIndex++, "客户传真号")); dicColInfo.Add("cust_address", Tuple.Create<int, string>(colIndex++, "客户地址")); dicColInfo.Add("pnl_length", Tuple.Create<int, string>(colIndex++, "开料长")); dicColInfo.Add("pnl_width", Tuple.Create<int, string>(colIndex++, "开料宽")); dicColInfo.Add("pnl_area", Tuple.Create<int, string>(colIndex++, "开料pnl面积")); dicColInfo.Add("order_pcs_qty", Tuple.Create<int, string>(colIndex++, "订单pcs数")); dicColInfo.Add("order_pcs_area", Tuple.Create<int, string>(colIndex++, "订单pcs面积")); dicColInfo.Add("unit_price_fpc", Tuple.Create<int, string>(colIndex++, "fpc单价")); dicColInfo.Add("unit_price_smt", Tuple.Create<int, string>(colIndex++, "smt单价")); dicColInfo.Add("fpc_smt_total_amount", Tuple.Create<int, string>(colIndex++, "fpc与smt总价")); dicColInfo.Add("tool_amount", Tuple.Create<int, string>(colIndex++, "工具费")); dicColInfo.Add("order_date", Tuple.Create<int, string>(colIndex++, "落单日期")); dicColInfo.Add("need_date", Tuple.Create<int, string>(colIndex++, "需求日期")); dicColInfo.Add("unit_price", Tuple.Create<int, string>(colIndex++, "含税单价")); dicColInfo.Add("subtotal_amount", Tuple.Create<int, string>(colIndex++, "含税金额")); var str = "对账单"; var fileName = string.Format("{0}{1:yyMMddHHmmss}.xls", str, DateTime.Now); ydExtendNPIO.List2Excel<v_delivery_bill_join_order>(rows, dicColInfo, ref fileName, str); return this.File(string.Format("/Temp/{0}", fileName), "application/vnd.ms-excel", fileName); }
private Levels friendsList(SearchEntity masha, int i) { if (i <= 3) { Levels levels1 = new Levels(masha.getDescription(), new List<Levels>()); foreach (UserDescription user in masha.getFriends()) { SearchEntity tmp = new SearchEntity(user.id); while (!tmp.isReady) System.Threading.Tasks.Task.Delay(TimeSpan.FromSeconds(0.01)).Wait(); levels1.friends.Add(friendsList(tmp, i + 1)); } return levels1; } else return new Levels(masha.getDescription(), new List<Levels>()); }
private void profile(int id) { SearchEntity masha = new SearchEntity(id); while (!masha.isReady) System.Threading.Tasks.Task.Delay(TimeSpan.FromSeconds(0.01)).Wait(); UserDescription profile = masha.getDescription(); FriendsList mashas_friends = masha.getFriends(); List<UserDescription> descriptions = new List<UserDescription>(); descriptions.Add(profile); List<string> strings = new List<string>(); strings.Add(profile.firstName); this.listBox1.ItemsSource = descriptions; this.listBox1.Visibility = System.Windows.Visibility.Visible; this.listBox2.Visibility = System.Windows.Visibility.Hidden; }
private void htmlDocCompleteSearch(object sender, HtmlDocumentLoadCompleted e) { if (e.Error == null) { HtmlDocument htmlDoc = e.Document; if (htmlDoc != null) { List<SearchEntity> searchList = new List<SearchEntity>(); HtmlNode node = htmlDoc.GetElementbyId("searchResult"); HtmlNodeCollection noC = node.SelectNodes("//*[@class=\"searchItem\"]"); foreach (HtmlNode h in noC) { HtmlNode hn1 = HtmlNode.CreateNode(h.OuterHtml); SearchEntity search = new SearchEntity(); foreach (HtmlNode child in hn1.ChildNodes) { if (child.Attributes["class"] != null && child.Attributes["class"].Value == "searchItemTitle") { HtmlNode hsn = HtmlNode.CreateNode(child.OuterHtml); string searchTitleValue = hsn.SelectSingleNode("//*[@class=\"searchItemTitle\"]").InnerText.Trim(); search.searchTitle = searchTitleValue; //MessageBox.Show("searchTitle--------------" + searchTitleValue); } else if (child.Attributes["class"] != null && child.Attributes["class"].Value == "searchCon") { HtmlNode hsn = HtmlNode.CreateNode(child.OuterHtml); string searchConValue = hsn.SelectSingleNode("//*[@class=\"searchCon\"]").InnerText.Trim(); search.searchCon = searchConValue; //MessageBox.Show("searchCon--------------" + searchConValue); } else if (child.Attributes["class"] != null && child.Attributes["class"].Value == "searchItemInfo") { HtmlNode hsn = HtmlNode.CreateNode(child.OuterHtml); foreach (HtmlNode searchItemInfoChild in hsn.ChildNodes) { if (searchItemInfoChild.Attributes["class"] != null && searchItemInfoChild.Attributes["class"].Value == "searchItemInfo") { string userName = searchItemInfoChild.SelectSingleNode("//*[@class=\"searchItemInfo-userName\"]").InnerText.Trim(); string publishDate = searchItemInfoChild.SelectSingleNode("//*[@class=\"searchItemInfo-publishDate\"]").InnerText.Trim(); string good = searchItemInfoChild.SelectSingleNode("//*[@class=\"searchItemInfo-good\"]").InnerText.Trim(); string comments = searchItemInfoChild.SelectSingleNode("//*[@class=\"searchItemInfo-comments\"]").InnerText.Trim(); string views = searchItemInfoChild.SelectSingleNode("//*[@class=\"searchItemInfo-views\"]").InnerText.Trim(); string searchInfoValue = userName + publishDate + good + comments + views; search.searchInfo = searchInfoValue; //MessageBox.Show("searchInfo--------------" + userName+publishDate+good+comments+views); } if (searchItemInfoChild.Attributes["class"] != null && searchItemInfoChild.Attributes["class"].Value == "searchURL") { string searchURLValue = searchItemInfoChild.SelectSingleNode("//*[@class=\"searchURL\"]").InnerText.Trim(); search.searchURL = searchURLValue; //MessageBox.Show("searchInfo--------------" + searchURLValue); } } //string searchInfo = child.SelectSingleNode("//*[@class=\"searchItemInfo\"]").InnerText; //MessageBox.Show("searchInfo--------------" + searchInfo); } } searchList.Add(search); } this.listBox1.ItemsSource = searchList; } } }