Пример #1
0
		public void Test_Empty()
		{
			var sc = new SearchCondition<object>();
			Assert.AreEqual(0, sc.Values.Length);
			Assert.AreEqual(SearchConditionTest.None, sc.Test);
			Assert.IsTrue(sc.IsEmpty);
		}
Пример #2
0
 public int GetCount(SearchCondition sc)
 {
     if (!string.IsNullOrEmpty(sc.flag))
     {
         switch (sc.flag)
         {
             case "member":
                 return GetCountByM(sc);
             case "member_track":
                 return GetCountByTrack(sc);
             case "member_contact":
                 return GetCountByContact(sc);
             case "member_introducer":
                 return GetCountByIntroducer(sc);
             case "es_fina_pay":
                 return GetCountByEFP(sc);
             default:
                 return -1;
         }
     }
     else
     {
         return -1;
     }
 }
Пример #3
0
 public HttpResponseMessage getme(SearchCondition model)
 {
     int em = 0;
     DAL.Implement.MemberDal.SearchCondition sc = new MemberDal.SearchCondition();
     sc.address = model.address;
     sc.aftersales = model.aftersales;
     sc.city = model.city;
     sc.classx = model.classx;
     sc.country = model.country;
     sc.field = model.field;
     sc.flag = model.flag;
     sc.keyword = model.keyword;
     sc.memo = model.memo;
     sc.province = model.province;
     sc.size = model.size < 30 ? model.size : 30;
     sc.start = model.start;
     sc.tracktype = model.tracktype;
     string[] kstr = model.keyword.ToString().Split(',');
     sc.keywords = kstr;
     string str = "[]";
     if (ValidateSign(Regex.Replace(model.keyword, ",", string.Empty), model.flag, model.field, Convert.ToDateTime(model.timestamp), model.sign))
     {
         str = _dal.GetList(sc, out em).Replace("\r", string.Empty).Replace("\n", string.Empty);
     }
     //str = _dal.GetList(sc, out em).Replace("\r", string.Empty).Replace("\n", string.Empty);
     //string str = _dal.GetList(sc, out em);
     HttpResponseMessage result = new HttpResponseMessage { Content = new StringContent(str, Encoding.GetEncoding("UTF-8"), "application/json") };
     return result;
 }
Пример #4
0
 public HttpResponseMessage GetCount(SearchCondition sc)
 {
     int count = 0;
     switch (sc.pattern)
     {
         case "0":
             TXLDal.SearchCondition tsc = new TXLDal.SearchCondition();
             tsc.keyword = sc.keyword;
             tsc.size = sc.size;
             tsc.start = sc.start;
             tsc.status = sc.status;
             tsc.d = sc.d;
             tsc.dm = sc.dm;
             tsc.e = sc.e;
             tsc.i = sc.i;
             tsc.p = sc.p;
             tsc.r = sc.r;
             tsc.eid = sc.eid;
             tsc.pn = sc.pn;
             tsc.depid = sc.depid;
             count = _dal.GetCount(tsc);
             break;
         //case "1":
         //    count = _dal.GetCount(sc.id);
         //    break;
         default:
             count = _dal.GetCount(sc.keyword, sc.field, sc.start, sc.size) ;
             break;
     }
     HttpResponseMessage result = new HttpResponseMessage { Content = new StringContent(count.ToString(), Encoding.GetEncoding("UTF-8"), "application/json") };
     return result;
 }
Пример #5
0
 public HttpResponseMessage Get(SearchCondition sc)
 {
     string json = "[]";
     switch (sc.pattern)
     {
         case "0":
             TXLDal.SearchCondition tsc = new TXLDal.SearchCondition();
             tsc.keyword = sc.keyword;
             tsc.size = sc.size;
             tsc.start = sc.start;
             tsc.status = sc.status;
             tsc.d = sc.d;
             tsc.e = sc.e;
             tsc.dm = sc.dm;
             tsc.i = sc.i;
             tsc.p = sc.p;
             tsc.r = sc.r;
             tsc.eid = sc.eid;
             tsc.pn = sc.pn;
             tsc.depid = sc.depid;
             json = _dal.Get(tsc).Replace("\r", string.Empty).Replace("\n", string.Empty);
             break;
         //case "1":
         //    json = _dal.Get(sc.id).Replace("\r", string.Empty).Replace("\n", string.Empty);
         //    break;
         default:
             json = _dal.Get(sc.keyword, sc.field, sc.start, sc.size).Replace("\r", string.Empty).Replace("\n", string.Empty);
             break;
     }
     HttpResponseMessage result = new HttpResponseMessage { Content = new StringContent(json, Encoding.GetEncoding("UTF-8"), "application/json") };
     return result;
 }
        private static SelectStatement CreateSelectFromLevelQuery(IEntity rootEntity, DbRelation recursiveRelation, SearchCondition leafFilter, int level, LevelQuerySelectList itemsToSelect)
        {
            if (level > Settings.GenericHierarchicalQueryExecutorMaxLevel)
                throw new InvalidOperationException(string.Format(CultureInfo.InvariantCulture, Messages.GenericHierarchicalQueryExecutor_MaxLevelReachedFormat, Settings.GenericHierarchicalQueryExecutorMaxLevel));

            // Target level table must be child table because that is the table which is used in leafFilter.
            // If leaf filter is used then the we must ensure that proper table name is used for target table.
            IDbTable targetLevelTable;
            if (leafFilter != null && !leafFilter.IsEmpty)
                targetLevelTable = recursiveRelation.Child;
            else
                targetLevelTable = rootEntity.Table.Clone("L" + level);

            SelectStatement selectFromTargetLevel = new SelectStatement(targetLevelTable);
            CreateSelectListItems(itemsToSelect, targetLevelTable, selectFromTargetLevel);

            if (leafFilter != null && !leafFilter.IsEmpty)
                selectFromTargetLevel.Where.Add(leafFilter);

            IDbTable prevLevel = targetLevelTable;
            for (int parentLevel = level - 1; parentLevel >= 0; parentLevel--)
            {
                IDbTable nextLevel = rootEntity.Table.Clone("L" + parentLevel);
                DbRelation joinLevels = JoinLevelsInSubTree(prevLevel, nextLevel, recursiveRelation);
                selectFromTargetLevel.Relations.Add(joinLevels, false, false);
                prevLevel = nextLevel;
            }

            IDbTable subTreeRoot = prevLevel;
            foreach (IDbColumn rootPkPart in subTreeRoot.PrimaryKey)
                selectFromTargetLevel.Where.Add(rootPkPart, rootEntity.GetField(rootPkPart));

            return selectFromTargetLevel;
        }
Пример #7
0
        public override SearchCondition GetParsingTree()
        {
            // *** TODO Value.AddLeadingWhitespace();

            var sc = new SearchCondition();
            sc.Stack.AddLast(Value);
            return sc;
        }
Пример #8
0
 private static void AppendWhere(SearchCondition where, DbmsType dbms, StringBuilder output, DbParameterCollection parameters)
 {
     bool hasFilter = (where != null) && !where.IsEmpty;
     if (hasFilter)
     {
         output.Append(" WHERE ");
         where.Render(dbms, output, parameters);
     }
 }
Пример #9
0
        public static WhereClause Create(SearchCondition sc)
        {
            var wh = new WhereClause();

            wh.Stack.AddLast(Keyword.Create("WHERE"));
            wh.Stack.AddLast(Whitespace.Create());
            wh.Stack.AddLast(sc);

            return wh;
        }
Пример #10
0
        public static SearchConditionBrackets Create(SearchCondition sc)
        {
            var scb = new SearchConditionBrackets();

            scb.Stack.AddLast(new BracketOpen());
            scb.Stack.AddLast(sc);
            scb.Stack.AddLast(new BracketClose());

            return scb;
        }
Пример #11
0
        public static SearchCriteria AddCriteria(this SearchCriteria searchCriteria, string field, SearchCondition condition, string comparisonValue, bool? isNumeric = null)
        {
            if (searchCriteria.Criteria == null)
            {
                searchCriteria.Criteria = new List<Criteria>();
            }

            searchCriteria.Criteria.Add(new Criteria { ComparisonValue = comparisonValue, Condition = condition, Field = field, IsNumeric = isNumeric});

            return searchCriteria;
        }
Пример #12
0
    public DataTable getDataTable(PaginationObj paginationObj, int schoolId, SearchCondition condition)
    {
        string sql = "select pr.id,pr.student_id,old_table.name,old_table.grade,old_table.sex, "
                + @" pr.red,pr.blue,pr.green,pr.yellow,rc.cn_name,pr.update_at,pr.print_count "
                + @" from pts_result pr "
                + @" inner join inside_student old_table on pr.student_id = old_table.id "
                + @" inner join result_const rc on pr.color = rc.color "
                + @" where old_table.school = " + schoolId
                + SearchCondictionStr.getString(condition);

        return BaseDao.getTableInfo(sql);
    }
Пример #13
0
    public static string getString(SearchCondition condition)
    {
        string temp = " ";
        string upadateAt = "";

        if (!String.IsNullOrWhiteSpace(condition.State)) {

            string state = " and old_table.state=" + condition.State;
            temp += state;
        }

        if (!String.IsNullOrWhiteSpace(condition.Name)) {

            string name = " and old_table.name like '%" + condition.Name + "%' ";
            temp += name;
        }

        if (!String.IsNullOrWhiteSpace(condition.Grade))
        {

            string grade = " and old_table.grade= " + condition.Grade;
            temp += grade;
        }

        if (!String.IsNullOrWhiteSpace(condition.Sex))
        {

            string sex = " and old_table.sex=" + condition.Sex;
            temp += sex;
        }

        if (!String.IsNullOrWhiteSpace(condition.TimeBegin) && !String.IsNullOrWhiteSpace(condition.TimeEnd))
        {
            upadateAt = " and CONVERT(VARCHAR(10),old_table.update_at,120) between '" + condition.TimeBegin + "' and '" + condition.TimeEnd + "' ";
        }
        else if (!String.IsNullOrWhiteSpace(condition.TimeBegin))
        {
            upadateAt = " and CONVERT(VARCHAR(10),old_table.update_at,120)='" + condition.TimeBegin + "' ";
        }
        else if (!String.IsNullOrWhiteSpace(condition.TimeEnd))
        {
            upadateAt = " and CONVERT(VARCHAR(10),old_table.update_at,120)='" + condition.TimeEnd + "' ";
        }
        else
        {

        }

        temp += upadateAt;

        return temp;
    }
Пример #14
0
        public void AppendCondition(SearchCondition sc, string opstring)
        {
            var cond = this.FindDescendant<SearchCondition>();
            this.Stack.Remove(cond);

            SearchConditionBrackets br1 = SearchConditionBrackets.Create(sc);
            SearchConditionBrackets br2 = SearchConditionBrackets.Create(cond);

            var op = LogicalOperator.Create(opstring);
            cond = SearchCondition.Create(br1, op, SearchCondition.Create(false, br2));

            this.Stack.AddLast(cond);
        }
Пример #15
0
        public ObjectSearchResults FindObjectsByClass(string className)
        {
            var vault = this.VaultService.Vault.Value;

              int classId = GetClassId(className);

              /* find all files with the specified class */
              var searchCondition = new SearchCondition();
              searchCondition.ConditionType = MFConditionType.MFConditionTypeEqual;
              searchCondition.Expression.DataPropertyValuePropertyDef = (int)MFBuiltInPropertyDef.MFBuiltInPropertyDefClass;
              searchCondition.TypedValue.SetValue(MFDataType.MFDatatypeLookup, classId);

              return Find(searchCondition);
        }
Пример #16
0
        public ObjectSearchResults FindObjectsByObjectType(string objectType)
        {
            var vault = this.VaultService.Vault.Value;

              int objectTypeId = GetObjectTypeId(objectType);

              /* find all files with the specified object type */
              var searchCondition = new SearchCondition();
              searchCondition.ConditionType = MFConditionType.MFConditionTypeEqual;
              searchCondition.Expression.DataStatusValueType = MFStatusType.MFStatusTypeObjectTypeID;
              searchCondition.TypedValue.SetValue(MFDataType.MFDatatypeLookup, objectTypeId);

              return Find(searchCondition);
        }
Пример #17
0
 public static string buildPaginationString(string tableName, PaginationObj paginationObj, int schoolId, SearchCondition condition)
 {
     return "select * from "
         + " (select old_table.*, ROW_NUMBER() over(order by update_at) as row_num from "
         + tableName
         + " old_table "
         + " where old_table.school="
         + schoolId
         + SearchCondictionStr.getString(condition)
         + " ) new_table "
         + " where new_table.row_num between "
         + ((paginationObj.PageNum - 1) * paginationObj.NumPerPage + 1)
         + " and "
         + paginationObj.PageNum * paginationObj.NumPerPage;
 }
Пример #18
0
		protected void DoContinue(object sender, EventArgs e)
		{
			this.TimeCondition = new SearchCondition() { TimeFrom = this.timeFrom.Value, TimeTo = this.timeTo.Value };
			this.views.ActiveViewIndex = 1;
			WhereSqlClauseBuilder where = ConditionMapping.GetWhereSqlClauseBuilder(this.TimeCondition);

			string[] ids = TimeRangeDataSource.QueryGuidsByCondition(where);

			this.postVal.Value = MCS.Web.Library.Script.JSONSerializerExecute.Serialize(ids);

			this.lblCount.InnerText = ids.Length.ToString("#,##0");

			this.btnRecalc.Visible = ids.Length > 0;

			//this.grid.InitialData = new TimeRangeDataSource().Query(0, 0, builder, "CREATE_TIME", ref total);
		}
 public static string GetString(SearchCondition aSearchCondition)
 {
     string lRet = "";
     switch (aSearchCondition)
     {
         case SearchCondition.KNULL:
             lRet = "";
             break;
         case SearchCondition.AND:
             lRet = "与";
             break;
         case SearchCondition.OR:
             lRet = "或";
             break;
     }
     return lRet;
 }
Пример #20
0
		public void Test_Clone()
		{
			var sc = new SearchCondition<object>();
			var x = new object();
			var y = new object();

			sc.Between(x, y);
			sc.SortDesc(3);

			var copy = (SearchCondition<object>)sc.Clone();

			Assert.AreEqual(sc.Test, copy.Test);
			Assert.AreEqual(sc.Values.Length, copy.Values.Length);
			Assert.AreEqual(sc.Values[0], copy.Values[0]);
			Assert.AreEqual(sc.Values[1], copy.Values[1]);
			Assert.AreEqual(sc.SortDirection, copy.SortDirection);
			Assert.AreEqual(sc.SortPosition, copy.SortPosition);
			Assert.IsFalse(ReferenceEquals(sc.Values, copy.Values));
		}
            /// <summary>
            /// Searches metadata in document 
            /// </summary> 
            public static void SearchMetadata(string filePath, string propertyName, SearchCondition searchCondition)
            {
                try
                {
                    //ExStart:DocumentSearchAPI
                    filePath = Common.MapSourceFilePath(filePath);

                    MetadataPropertyCollection properties = SearchFacade.ScanDocument(filePath, propertyName, searchCondition);

                    foreach (MetadataProperty property in properties)
                    {
                        Console.WriteLine("{0} : {1}", property.Name, property.Value);
                    }
                    //ExEnd:DocumentSearchAPI
                }
                catch (Exception exp)
                {
                    Console.WriteLine("Exception occurred: " + exp.Message);
                }

            }
Пример #22
0
        public HttpResponseMessage Get(SearchCondition sc)
        {
            CommProductDal.SearchCondition csc = new CommProductDal.SearchCondition();
            string[] kstr = { };
            if (!string.IsNullOrEmpty(sc.keywords))
            {
                kstr = sc.keywords.ToString().Split(',');
            }
            if (!string.IsNullOrEmpty(sc.typenames))
            {
                string[] tstr = sc.typenames.ToString().Split(',');
                csc.typenames = tstr;
            }
            csc.keywords = kstr;
            csc.size = sc.size;
            csc.start = sc.start;

            string json = _dal.Get(csc);
            HttpResponseMessage result = new HttpResponseMessage { Content = new StringContent(json, Encoding.GetEncoding("UTF-8"), "application/json") };
            return result;
        }
Пример #23
0
        public static Search SimpleSearch(string property, SearchCondition op, string value)
        {
            IList<SearchCriteria> criterias = new List<SearchCriteria>
            {
                new SearchCriteria
                {
                    Combinator = SearchCombinator.And,
                    Criteria = new List<Criteria>
                    {
                        new Criteria { Field = property, Condition = op, ComparisonValue = value, },
                    }
                }
            };

            var search = new Search
            {
                SearchFields = new SearchFields { Combinator = SearchCombinator.And, Criterias = criterias },
                SearchOptions = new SearchOptions()
            };

            return search;
        }
Пример #24
0
 public HttpResponseMessage getCount(SearchCondition model)
 {
     DAL.Implement.MemberDal.SearchCondition sc = new MemberDal.SearchCondition();
     sc.address = model.address;
     sc.aftersales = model.aftersales;
     sc.city = model.city;
     sc.classx = model.classx;
     sc.country = model.country;
     sc.field = model.field;
     sc.flag = model.flag;
     sc.keyword = model.keyword;
     sc.memo = model.memo;
     sc.province = model.province;
     sc.tracktype = model.tracktype;
     int str = 0;
     if (ValidateSign(model.keyword, model.flag, model.field,Convert.ToDateTime(model.timestamp),model.sign))
     {
         str = _dal.GetCount(sc);
     }
     //int str = _dal.GetCount(sc);
     HttpResponseMessage result = new HttpResponseMessage { Content = new StringContent(str.ToString(), Encoding.GetEncoding("UTF-8"), "application/json") };
     return result;
 }
        protected override List <ServerSwitchRecord> GetingItems(ParkDataContext parking, SearchCondition search)
        {
            if (search is ServerSwitchRecordSearchCondition)
            {
                ServerSwitchRecordSearchCondition condition = search as ServerSwitchRecordSearchCondition;
                IQueryable <ServerSwitchRecord>   result    = parking.ServerSwitchRecord;
                if (condition.ParkID > 0)
                {
                    result = result.Where(s => s.ParkID == condition.ParkID);
                }
                if (condition.RecordDateTimeRange != null)
                {
                    result = result.Where(s => s.SwitchDateTime >= condition.RecordDateTimeRange.Begin);
                    result = result.Where(s => s.SwitchDateTime <= condition.RecordDateTimeRange.End);
                }
                if (condition.SMSStatus.HasValue)
                {
                    result = result.Where(s => s.SMSStatus == condition.SMSStatus.Value);
                }

                return(result.ToList());
            }
            return(new List <ServerSwitchRecord>());
        }
Пример #26
0
        /// <summary>
        /// 构建Solr检索选项,派生类可根据需要进行重写
        /// </summary>
        /// <param name="condition"></param>
        /// <returns></returns>
        protected virtual QueryOptions BuildQueryOptions(SearchCondition condition)
        {
            QueryOptions queryOptions = new QueryOptions();

            #region 搜索关键字

            if (String.IsNullOrEmpty(condition.KeyWord))
            {
                condition.KeyWord = "*:*";
            }

            #endregion 搜索关键字

            #region 分页信息

            if (condition.PagingInfo == null)
            {
                condition.PagingInfo = new PagingInfo()
                {
                    PageSize   = 24,
                    PageNumber = 1
                };
            }
            queryOptions.Rows  = condition.PagingInfo.PageSize >= 0 ? condition.PagingInfo.PageSize : 24;
            queryOptions.Start = condition.PagingInfo.PageNumber > 1 ? queryOptions.Rows * (condition.PagingInfo.PageNumber - 1) : 0;

            #endregion 分页信息

            #region 排序信息

            if (condition.SortItems != null && condition.SortItems.Count > 0)
            {
                List <SortOrder> sortList = new List <SortOrder>();

                foreach (SortItem sortItem in condition.SortItems)
                {
                    if (sortItem.SortType == SortOrderType.ASC)
                    {
                        SortOrder sortOrder = new SortOrder(sortItem.SortKey, Order.ASC);
                        sortList.Add(sortOrder);
                    }
                    else
                    {
                        SortOrder sortOrder = new SortOrder(sortItem.SortKey, Order.DESC);
                        sortList.Add(sortOrder);
                    }
                }
                queryOptions.OrderBy = sortList.ToArray();
            }

            #endregion 排序信息

            #region 一般过滤条件

            if (condition.Filters != null && condition.Filters.Count > 0)
            {
                foreach (FilterBase filter in condition.Filters)
                {
                    if (filter is RangeFilter)
                    {
                        RangeFilter rf = filter as RangeFilter;
                        if (!string.IsNullOrWhiteSpace(rf.From) || !string.IsNullOrWhiteSpace(rf.To))
                        {
                            queryOptions.FilterQueries.Add(new SolrQueryByRange <string>(rf.Field, rf.From, rf.To, rf.Inclusive, rf.Inclusive));
                        }
                    }
                    else if (filter is FieldFilter)
                    {
                        FieldFilter ff = filter as FieldFilter;
                        if (!string.IsNullOrWhiteSpace(ff.Value))
                        {
                            queryOptions.FilterQueries.Add(new SolrQueryByField(ff.Field, ff.Value));
                        }
                    }
                }
            }

            #endregion 一般过滤条件

            #region  杂过滤条件计算

            AbstractSolrQuery expressiongResult = ComputerExpression(condition.FilterExpression);
            if (expressiongResult != null)
            {
                queryOptions.FilterQueries.Add(expressiongResult);
            }

            #endregion  杂过滤条件计算

            return(queryOptions);
        }
Пример #27
0
        /// <summary>
        /// Adds a property value search condition to the collection.
        /// </summary>
        /// <param name="searchBuilder">The <see cref="MFSearchBuilder"/> to add the condition to.</param>
        /// <param name="propertyDef">The property to search by.</param>
        /// <param name="dataType">The data type of the property definition (not checked).</param>
        /// <param name="value">The value to search for.</param>
        /// <param name="conditionType">What type of search to execute.</param>
        /// <param name="parentChildBehavior">Whether to accept matches to parent/child values as well.</param>
        /// <param name="dataFunctionCall">An expression for modifying how the results of matches are evaluated.</param>
        /// <param name="indirectionLevels">The indirection levels (from the search object) to access the property to match.</param>
        /// <returns></returns>
        private static MFSearchBuilder AddPropertyValueSearchCondition
        (
            this MFSearchBuilder searchBuilder,
            int propertyDef,
            MFDataType dataType,
            object value,
            MFConditionType conditionType,
            MFParentChildBehavior parentChildBehavior  = MFParentChildBehavior.MFParentChildBehaviorNone,
            PropertyDefOrObjectTypes indirectionLevels = null,
            DataFunctionCall dataFunctionCall          = null
        )
        {
            // Sanity.
            if (null == searchBuilder)
            {
                throw new ArgumentNullException(nameof(searchBuilder));
            }

            // Create the search condition.
            var searchCondition = new SearchCondition
            {
                ConditionType = conditionType
            };

            // Set up the property value expression.
            searchCondition.Expression.SetPropertyValueExpression
            (
                propertyDef,
                parentChildBehavior,
                dataFunctionCall
            );

            // If we have any indirection levels then use them.
            if (null != indirectionLevels)
            {
                // If any indirection level points at a value list then it will except.
                // Show a nicer error message here.
                foreach (PropertyDefOrObjectType indirectionLevel in indirectionLevels)
                {
                    var objectTypeId = indirectionLevel.ID;
                    if (indirectionLevel.PropertyDef)
                    {
                        // If it's a property def then find the object type.
                        PropertyDef indirectionLevelPropertyDef;
                        try
                        {
                            indirectionLevelPropertyDef = searchBuilder
                                                          .Vault
                                                          .PropertyDefOperations
                                                          .GetPropertyDef(indirectionLevel.ID);
                        }
                        catch
                        {
                            indirectionLevelPropertyDef = null;
                        }

                        // Does it exist?
                        if (null == indirectionLevelPropertyDef)
                        {
                            throw new ArgumentException($"An indirection level references a property definition with ID {indirectionLevel.ID}, but this property definition could not be found.", nameof(indirectionLevel));
                        }

                        // Is it a list-based one?
                        if (false == indirectionLevelPropertyDef.BasedOnValueList)
                        {
                            throw new ArgumentException($"The indirection level for property {indirectionLevel.ID} does not reference a lookup-style property definition.", nameof(indirectionLevel));
                        }

                        // Record the object type id.
                        objectTypeId = indirectionLevelPropertyDef.ValueList;
                    }

                    // Is it an object type (fine) or a value list (not fine)?
                    {
                        ObjType indirectionLevelObjectType;
                        try
                        {
                            indirectionLevelObjectType = searchBuilder
                                                         .Vault
                                                         .ValueListOperations
                                                         .GetValueList(objectTypeId);
                        }
                        catch
                        {
                            indirectionLevelObjectType = null;
                        }

                        // Does it exist?
                        if (null == indirectionLevelObjectType)
                        {
                            throw new ArgumentException($"An indirection level references a value list with ID {objectTypeId}, but this value list could not be found.", nameof(indirectionLevel));
                        }

                        // If it's not a real object type then throw.
                        if (false == indirectionLevelObjectType.RealObjectType)
                        {
                            throw new ArgumentException($"An indirection level references an value list with ID {objectTypeId}, but this list does not refer to an object type (cannot be used with value lists).", nameof(indirectionLevel));
                        }
                    }
                }

                // Set the indirection levels.
                searchCondition.Expression.IndirectionLevels
                    = indirectionLevels;
            }

            // Was the value null?
            if (null == value)
            {
                searchCondition.TypedValue.SetValueToNULL(dataType);
            }
            else
            {
                searchCondition.TypedValue.SetValue(dataType, value);
            }

            // Add the search condition to the collection.
            searchBuilder.Conditions.Add(-1, searchCondition);

            // Return the search builder for chaining.
            return(searchBuilder);
        }
Пример #28
0
 public void Issue_49()
 {
     using (var client = GetClient <ImapClient>()) {
         var msg = client.SearchMessages(SearchCondition.Subject("aenetmail").And(SearchCondition.Subject("#49"))).Select(x => x.Value).FirstOrDefault();
         msg.ShouldBe();
         msg.AlternateViews.FirstOrDefault(x => x.ContentType.Contains("html")).Body.ShouldBe();
     }
 }
Пример #29
0
        public override void DoLoginedHandlerWork(HttpContext context)
        {
            Message jsonMessage;

            jsonMessage = new Message()
            {
                Result     = false,
                TxtMessage = "权限验证失败,可能原因:\n1、数据中心通讯失败。\n2、系统管理员未与您分配对应操作权限。"
            };
            //获取操作类型AType:ADD,EDIT,DELETE
            string AjaxType = context.Request.QueryString["AType"] == null ? string.Empty : context.Request.QueryString["AType"].ToString().ToUpper();

            View_ValveControl Info;
            WCFServiceProxy <IValveControl> proxy      = null;
            WCFServiceProxy <IMeterManage>  proxyMeter = null;



            try
            {
                switch (AjaxType)
                {
                case "QUERY":

                    CommonSearch <View_ValveControl> InfoSearch = new CommonSearch <View_ValveControl>();
                    string Where = "1=1 ";
                    Where += "AND CompanyID='" + loginOperator.CompanyID + "' ";
                    if (context.Request.Form["TWhere"] != null && context.Request.Form["TWhere"].ToString().Trim() != string.Empty)
                    {
                        Where += context.Request.Form["TWhere"].ToString();
                    }
                    SearchCondition sCondition = new SearchCondition()
                    {
                        TBName = "View_ValveControl", TFieldKey = "UserID", TTotalCount = -1, TPageCurrent = 1, TFieldOrder = "RegisterDate Desc", TWhere = Where
                    };
                    List <View_ValveControl> list = InfoSearch.GetList(ref sCondition, context);
                    jsonMessage = new Message()
                    {
                        Result     = true,
                        TxtMessage = JSon.ListToJson <View_ValveControl>(list, sCondition.TTotalCount)
                    };
                    break;



                //开阀
                case "KAIFA":
                    if (CommonOperRightHelper.CheckMenuCode(base.loginOperator, "fmcz_kf"))
                    {
                        proxyMeter = new WCFServiceProxy <IMeterManage>();
                        proxy      = new WCFServiceProxy <IValveControl>();

                        string reason = "";
                        if (context.Request.Form["Reason"] != null && context.Request.Form["Reason"].ToString().Trim() != string.Empty)
                        {
                            reason = context.Request.Form["Reason"].ToString().Trim();
                        }

                        if (context.Request.Form["strNo"] != null && context.Request.Form["strNo"].ToString().Trim() != string.Empty)
                        {
                            string strNo = context.Request.Form["strNo"];

                            string[] arrNo = strNo.Split(',');

                            for (int i = 0; i < arrNo.Length; i++)
                            {
                                IoT_Meter meter = proxyMeter.getChannel.GetMeterByNo(arrNo[i]);
                                proxy.getChannel.TurnOn(meter, reason, loginOperator.Name);
                            }
                        }
                        jsonMessage = new Message()
                        {
                            Result     = true,
                            TxtMessage = "操作成功"
                        };
                    }
                    break;

                //关阀
                case "GUANFA":
                    if (CommonOperRightHelper.CheckMenuCode(base.loginOperator, "fmcz_gf"))
                    {
                        proxyMeter = new WCFServiceProxy <IMeterManage>();
                        proxy      = new WCFServiceProxy <IValveControl>();

                        string reason = "";
                        if (context.Request.Form["Reason"] != null && context.Request.Form["Reason"].ToString().Trim() != string.Empty)
                        {
                            reason = context.Request.Form["Reason"].ToString().Trim();
                        }

                        if (context.Request.Form["strNo"] != null && context.Request.Form["strNo"].ToString().Trim() != string.Empty)
                        {
                            string strNo = context.Request.Form["strNo"];

                            string[] arrNo = strNo.Split(',');

                            for (int i = 0; i < arrNo.Length; i++)
                            {
                                IoT_Meter meter = proxyMeter.getChannel.GetMeterByNo(arrNo[i]);
                                proxy.getChannel.TurnOff(meter, reason, loginOperator.Name);
                            }
                        }
                        jsonMessage = new Message()
                        {
                            Result     = true,
                            TxtMessage = "操作成功"
                        };
                    }
                    break;


                case "UNDO":
                    if (CommonOperRightHelper.CheckMenuCode(base.loginOperator, "fmcz_cx"))
                    {
                        Info  = new CommonModelFactory <View_ValveControl>().GetModelFromContext(context);
                        proxy = new WCFServiceProxy <IValveControl>();
                        proxy.getChannel.Undo(Info.TaskID, Info.Context);

                        jsonMessage = new Message()
                        {
                            Result     = true,
                            TxtMessage = "操作成功"
                        };
                    }
                    break;


                default:
                    jsonMessage = new Message()
                    {
                        Result     = false,
                        TxtMessage = "操作未定义。"
                    };
                    break;
                }
            }
            catch (Exception ex) {
                jsonMessage = new Message()
                {
                    Result     = false,
                    TxtMessage = ex.Message
                };
            }
            finally
            {
                if (proxy != null)
                {
                    proxy.CloseChannel();
                }
            }
            context.Response.Write(JSon.TToJson <Message>(jsonMessage));
        }
Пример #30
0
        protected override List <Product> GetingItems(System.Data.Linq.DataContext dc, SearchCondition search)
        {
            DataLoadOptions opt = new DataLoadOptions();

            opt.LoadWith <Product>(p => p.Category);
            dc.LoadOptions = opt;
            IQueryable <Product> ret = dc.GetTable <Product>();

            if (search is ProductSearchCondition)
            {
                ProductSearchCondition con = search as ProductSearchCondition;
                if (con.ProductIDS != null && con.ProductIDS.Count > 0)
                {
                    ret = ret.Where(item => con.ProductIDS.Contains(item.ID));
                }
                if (!string.IsNullOrEmpty(con.Name))
                {
                    ret = ret.Where(item => item.Name.Contains(con.Name));
                }
                if (!string.IsNullOrEmpty(con.BarCode))
                {
                    ret = ret.Where(item => item.BarCode.Contains(con.BarCode));
                }
                if (!string.IsNullOrEmpty(con.CategoryID))
                {
                    ret = ret.Where(item => item.CategoryID == con.CategoryID);
                }
                if (!string.IsNullOrEmpty(con.Specification))
                {
                    ret = ret.Where(item => item.Specification.Contains(con.Specification));
                }
            }
            return(ret.ToList());
        }
Пример #31
0
 protected virtual List <TInfo> GetingItems(DataContext dc, SearchCondition search)
 {
     //如果要实现这个功能,子类一定要重写这个方法
     return(dc.GetTable <TInfo>().ToList());
 }
Пример #32
0
        public static DataTable ExecuteDataTable(this SQLHelper sqlHelper, string sql, SearchCondition cnd)
        {
            SearchCondition authCnd = FormulaHelper.CreateAuthDataFilter();

            #region 处理@参数
            List <SqlParameter> pList = new List <SqlParameter>();
            for (int i = authCnd.Items.Count - 1; i >= 0; i--)
            {
                var item = authCnd.Items[i];
                if (item.Field.StartsWith("@"))
                {
                    authCnd.Items.RemoveAt(i);
                    pList.Add(new SqlParameter(item.Field, item.Value));
                }
            }
            for (int i = cnd.Items.Count - 1; i >= 0; i--)
            {
                var item = cnd.Items[i];
                if (item.Field.StartsWith("@"))
                {
                    cnd.Items.RemoveAt(i);
                    pList.Add(new SqlParameter(item.Field, item.Value));
                }
            }
            #endregion

            string orderby = "";
            int    index   = sql.LastIndexOf("order by", StringComparison.CurrentCultureIgnoreCase);
            if (index > 0)
            {
                orderby = sql.Substring(index);
                sql     = sql.Substring(0, index);
            }

            if (authCnd.Items.Count > 0)
            {
                sql = string.Format("select * from ({0}) sourceTable1 {1}", sql, authCnd.GetWhereString());
            }

            sql = string.Format("select * from ({0}) sourceTable {1} {2}", sql, cnd.GetWhereString(), orderby);

            DataTable dt = sqlHelper.ExecuteDataTable(sql, pList.ToArray(), CommandType.Text);
            return(dt);
        }
Пример #33
0
 /// <summary>
 /// 转换Solr返回的检索文档,需要派生类进行实现
 /// </summary>
 /// <param name="solrQueryResult">Solr检索返回的文档结果</param>
 /// <param name="condition">查询条件</param>
 /// <returns>对外返回查询结果数据</returns>
 protected abstract Result TransformSolrQueryResult(ISolrQueryResults <Record> solrQueryResult, SearchCondition condition);
Пример #34
0
        public override void DoLoginedHandlerWork(HttpContext context)
        {
            Message jsonMessage;

            jsonMessage = new Message()
            {
                Result     = false,
                TxtMessage = "权限验证失败,可能原因:\n1、数据中心通讯失败。\n2、系统管理员未与您分配对应操作权限。"
            };
            //获取操作类型AType:ADD,EDIT,DELETE
            string     AjaxType = context.Request.QueryString["AType"] == null ? string.Empty : context.Request.QueryString["AType"].ToString().ToUpper();
            IoT_Street Info;
            WCFServiceProxy <IStreetManage> proxy = null;

            try
            {
                switch (AjaxType)
                {
                case "QUERY":

                    CommonSearch <IoT_Street> InfoSearch = new CommonSearch <IoT_Street>();
                    string Where = "1=1 ";
                    Where += "AND CompanyID='" + loginOperator.CompanyID + "' ";
                    if (context.Request.Form["TWhere"] != null && context.Request.Form["TWhere"].ToString().Trim() != string.Empty)
                    {
                        Where += context.Request.Form["TWhere"].ToString();
                    }
                    SearchCondition sCondition = new SearchCondition()
                    {
                        TBName      = "IoT_Street", TFieldKey = "ID",
                        TTotalCount = -1, TPageCurrent = 1, TFieldOrder = "ID ASC", TWhere = Where
                    };
                    List <IoT_Street> list = InfoSearch.GetList(ref sCondition, context);
                    jsonMessage = new Message()
                    {
                        Result     = true,
                        TxtMessage = JSon.ListToJson <IoT_Street>(list, sCondition.TTotalCount)
                    };
                    break;

                case "ADD":
                    if (CommonOperRightHelper.CheckMenuCode(base.loginOperator, "jqgl_tjjd"))
                    {
                        Info           = new CommonModelFactory <IoT_Street>().GetModelFromContext(context);
                        Info.CompanyID = loginOperator.CompanyID;
                        proxy          = new WCFServiceProxy <IStreetManage>();
                        jsonMessage    = proxy.getChannel.Add(Info);
                    }
                    break;

                case "EDIT":
                    if (CommonOperRightHelper.CheckMenuCode(base.loginOperator, "jqgl_bjjd"))
                    {
                        Info        = new CommonModelFactory <IoT_Street>().GetModelFromContext(context);
                        proxy       = new WCFServiceProxy <IStreetManage>();
                        jsonMessage = proxy.getChannel.Edit(Info);
                    }
                    break;

                case "DELETE":
                    if (CommonOperRightHelper.CheckMenuCode(base.loginOperator, "jqgl_scjd"))
                    {
                        Info        = new CommonModelFactory <IoT_Street>().GetModelFromContext(context);
                        proxy       = new WCFServiceProxy <IStreetManage>();
                        jsonMessage = proxy.getChannel.Delete(Info);
                    }
                    break;

                default:
                    jsonMessage = new Message()
                    {
                        Result     = false,
                        TxtMessage = "操作未定义。"
                    };
                    break;
                }
            }
            catch (Exception ex) {
                jsonMessage = new Message()
                {
                    Result     = false,
                    TxtMessage = ex.Message
                };
            }
            finally
            {
                if (proxy != null)
                {
                    proxy.CloseChannel();
                }
            }
            context.Response.Write(JSon.TToJson <Message>(jsonMessage));
        }
 protected abstract QueryResultList <TEntity> GetingItems(SearchCondition search);
Пример #36
0
        /// <summary>
        /// 删除主子表
        /// </summary>
        /// <param name="keyValue">主键</param>
        /// <param name="bLogicDelete"></param>
        public void Delete(string keyValue, bool bLogicDelete)
        {
            using (DbTransactionScope <SYS_BarcodeSettingMainInfo> dbtran = base.CreateTransactionScope())
            {
                try
                {
                    if (bLogicDelete)
                    {
                        //逻辑删除v
                        //UPDATE字段
                        Hashtable hash = new Hashtable();
                        hash.Add("字段名", "修改后的值");
                        this.Update(keyValue, hash, dbtran.Transaction);


                        //UPDATE 对象
                        SYS_BarcodeSettingMainInfo info = this.FindByID(keyValue, dbtran.Transaction);
                        info.F_DeleteMark = false;
                        info.F_DeleteTime = DateTime.Now;
                        this.Update(info, keyValue, dbtran.Transaction);


                        //获取所有的子表信息
                        SearchCondition c = new SearchCondition();
                        c.AddCondition("F_ParentId", keyValue, SqlOperator.Equal);
                        List <SYS_BarcodeSettingDetailInfo> details = SYS_BarcodeSettingDetail.Instance.Find(c.BuildConditionSql());

                        foreach (SYS_BarcodeSettingDetailInfo d in details)
                        {
                            d.F_DeleteMark = false;
                            d.F_DeleteTime = DateTime.Now;
                            SYS_BarcodeSettingDetail.Instance.Update(d, d.F_Id, dbtran.Transaction);
                        }


                        //sql方式update
                        string    sql   = "UPDATE Sys_VouchType WHERE F_Id = @F_ParentId";
                        Hashtable parms = new Hashtable();
                        parms.Add("F_Id(参数名,不需要@)", keyValue);
                        base.ExecuteNonQuery(sql, parms, dbtran.Transaction);


                        sql = "UPDATE SYS_BarcodeSettingDetail WHERE F_VouchId = @F_ParentId";
                        base.ExecuteNonQuery(sql, parms, dbtran.Transaction);
                    }
                    else
                    {
                        //物理删除

                        //删除 SYS_BarcodeSettingDetail
                        SearchCondition condition = new SearchCondition();
                        condition.AddCondition("F_ParentId", keyValue, SqlOperator.Equal);
                        SYS_BarcodeSettingDetail.Instance.DeleteByCondition(condition.BuildConditionSql().Replace("Where (1=1)  AND ", string.Empty), dbtran.Transaction);
                        //删除 SYS_BarcodeSettingMain
                        this.Delete(keyValue, dbtran.Transaction);
                    }
                    dbtran.Commit();
                }
                catch (Exception e)
                {
                    dbtran.RollBack();
                    throw e;
                }
            }
        }
Пример #37
0
 public OrderDateCleanUp(SearchCondition sc)
 {
     _sc = sc;
 }
Пример #38
0
        /// <summary>
        ///审核单据
        /// </summary>
        /// <param name="date">审核日期</param>
        /// <param name="Id">审核单据</param>
        /// <param name="user">审核人</param>
        public string Audit(string date, string user, string Id, List <PI_BodyInfo> stockinfo)
        {
            using (DbTransactionScope <PI_HeadInfo> dbtran = base.CreateTransactionScope())
            {
                try
                {
                    SearchCondition condition = new SearchCondition();
                    condition.AddCondition("F_Id", Id, SqlOperator.Equal);
                    PI_HeadInfo head = PI_Head.Instance.FindSingle(condition.BuildConditionSql().Replace("Where (1=1)  AND ", string.Empty), dbtran.Transaction);

                    if (head.F_Status == 1)
                    {
                        return("单据已被审核");
                    }
                    else
                    {
                        Hashtable hash = new Hashtable();
                        hash.Add("F_Status", 1);
                        hash.Add("F_VeriDate", date);
                        hash.Add("F_Verify", user);

                        PI_Head.Instance.Update(Id, hash, dbtran.Transaction);
                        dbtran.Commit();
                        return("单据审核成功");

                        #region  审核后入库
                        //using (DbTransactionScope<PI_HeadInfo> dbtran = base.CreateTransactionScope())
                        //{
                        //    try
                        //    {
                        //        //查询所有库存信息
                        //        List<Sys_StockInfo> stockList = BLLFactory<Sys_Stock>.Instance.GetAll();
                        //        //查询主表信息
                        //        PI_HeadInfo hinfo = BLLFactory<PI_Head>.Instance.FindByID(Id);


                        //        foreach (PI_BodyInfo item in stockinfo)
                        //        {
                        //            //判断是否入库
                        //            PI_BodyInfo binfo = BLLFactory<PI_Body>.Instance.FindByID(item.F_Id);
                        //            if (binfo.F_AlreadyOperatedNum == "")
                        //            {
                        //                binfo.F_AlreadyOperatedNum = "0";
                        //            }
                        //            if (int.Parse(binfo.F_AlreadyOperatedNum) > 0)
                        //            {
                        //                return "该单据已入库,不能重复执行入库操作";
                        //            }

                        //            if (binfo.F_WarehouseId==""||binfo.F_CargoPositionId=="")
                        //            {
                        //                return "该单据中仓库或仓位为空,审核未通过";
                        //            }

                        //            Sys_StockInfo stock = stockList.Find(u => u.F_WarehouseId == binfo.F_WarehouseId && u.F_CargoPositionId == binfo.F_CargoPositionId && u.F_GoodsId == binfo.F_GoodsId&&u.F_Batch==binfo.F_SerialNum);
                        //            if (stock == null)
                        //            {
                        //                item.IsHave = false;
                        //            }
                        //            else
                        //            {
                        //                item.IsHave = true;
                        //                item.StockID = stock.F_Id;
                        //                item.StockNumber = stock.F_Number;
                        //            }

                        //            //查询库存表是否存在该仓库中的产品
                        //            //没有
                        //            if (!item.IsHave)
                        //            {
                        //                //新添加一条数据 库存表
                        //                Sys_StockInfo entity = new Sys_StockInfo();
                        //                entity.F_Id = Guid.NewGuid().ToString();
                        //                entity.F_CargoPositionId = item.F_CargoPositionId;
                        //                entity.F_CargoPositionName = item.F_CargoPositionName;
                        //                entity.F_WarehouseId = item.F_WarehouseId;
                        //                entity.F_WarehouseName = item.F_WarehouseName;
                        //                entity.F_GoodsName = item.F_FullName;
                        //                entity.F_Batch = item.F_SerialNum;
                        //                entity.F_GoodsId = item.F_GoodsId;
                        //                entity.F_SpecifModel = item.F_SpecifModel;
                        //                entity.F_SellingPrice = item.F_SellingPrice;
                        //                entity.F_PurchasePrice = item.F_PurchasePrice;
                        //                entity.F_Unit = item.F_Unit;
                        //                entity.F_Number = item.F_InStockNum;
                        //                Sys_Stock.Instance.Insert(entity, dbtran.Transaction);

                        //                //更新审核状态
                        //                string sql = string.Format("update PI_Head set F_Status=1,F_VeriDate='{0}',F_Verify='{1}' where F_Id='{2}'", date, user, Id);
                        //                Hashtable hash = new Hashtable();
                        //                base.ExecuteNonQuery(sql, hash, dbtran.Transaction);

                        //                //添加入库履历 入库履历
                        //                Sys_InRecordsInfo inRec = new Sys_InRecordsInfo();
                        //                inRec.F_Id = Guid.NewGuid().ToString();
                        //                inRec.F_WarehouseId = item.F_WarehouseId;
                        //                inRec.F_Vendor = hinfo.F_Vendor;
                        //                inRec.F_VendorName = hinfo.F_VendorName;
                        //                inRec.F_Contacts = hinfo.F_Contacts;
                        //                inRec.F_TelePhone = hinfo.F_TelePhone;
                        //                inRec.F_Verify = user;
                        //                inRec.F_Maker = hinfo.F_Maker;
                        //                inRec.F_VeriDate = DateTime.Now;
                        //                inRec.F_EnCode = item.F_OrderNo;
                        //                inRec.F_Batch = item.F_SerialNum;
                        //                inRec.F_WarehouseName = item.F_WarehouseName;
                        //                inRec.F_GoodsName = item.F_FullName;
                        //                inRec.F_GoodsId = item.F_GoodsId;
                        //                inRec.F_CargoPositionId = item.F_CargoPositionId;
                        //                inRec.F_CargoPositionName = item.F_CargoPositionName;
                        //                inRec.F_SpecifModel = item.F_SpecifModel;
                        //                inRec.F_SellingPrice = item.F_SellingPrice;
                        //                inRec.F_PurchasePrice = item.F_PurchasePrice;
                        //                inRec.F_Unit = item.F_Unit;
                        //                inRec.F_InStockNum = item.F_InStockNum;
                        //                inRec.F_CreatorTime = DateTime.Now;
                        //                Sys_InRecords.Instance.Insert(inRec, dbtran.Transaction);



                        //                //添加  库存履历
                        //                Sys_StockHistoryInfo instock = new Sys_StockHistoryInfo();
                        //                instock.F_Id = Guid.NewGuid().ToString();
                        //                instock.F_WarehouseId = item.F_WarehouseId;
                        //                instock.F_Vendor = hinfo.F_Vendor;
                        //                instock.F_VendorName = hinfo.F_VendorName;
                        //                instock.F_Contacts = hinfo.F_Contacts;
                        //                instock.F_TelePhone = hinfo.F_TelePhone;
                        //                instock.F_Verify = user;
                        //                instock.F_Maker = hinfo.F_Maker;
                        //                instock.F_VeriDate = DateTime.Now;
                        //                instock.F_EnCode = item.F_OrderNo;
                        //                instock.F_Batch = item.F_SerialNum;
                        //                instock.F_WarehouseName = item.F_WarehouseName;
                        //                instock.F_BllCategory = "入库";
                        //                instock.F_GoodsName = item.F_FullName;
                        //                instock.F_GoodsId = item.F_GoodsId;
                        //                instock.F_CargoPositionId = item.F_CargoPositionId;
                        //                instock.F_CargoPositionName = item.F_CargoPositionName;
                        //                instock.F_SpecifModel = item.F_SpecifModel;
                        //                instock.F_SellingPrice = item.F_SellingPrice;
                        //                instock.F_PurchasePrice = item.F_PurchasePrice;
                        //                instock.F_Unit = item.F_Unit;
                        //                instock.F_OperationNum = item.F_InStockNum;
                        //                instock.F_CreatorTime = DateTime.Now;
                        //                Sys_StockHistory.Instance.Insert(instock, dbtran.Transaction);



                        //                //更新子表入库状态
                        //                hash = new Hashtable();
                        //                hash.Add("F_AlreadyOperatedNum", 1);
                        //                PI_Body.Instance.Update(item.F_Id, hash, dbtran.Transaction);

                        //                //更新主表入库状态
                        //                hash = new Hashtable();
                        //                hash.Add("F_State", 1);
                        //                PI_Head.Instance.Update(item.F_HId, hash, dbtran.Transaction);
                        //            }
                        //            else
                        //            {
                        //                //更新前库存数量
                        //                Hashtable hash = new Hashtable();
                        //                hash.Add("F_Number", item.StockNumber + item.F_InStockNum);
                        //                Sys_Stock.Instance.Update(item.StockID, hash, dbtran.Transaction);
                        //                for (int i = 0; i < stockinfo.Count; i++)
                        //                {
                        //                    if (stockinfo[i].StockID == item.StockID)
                        //                    {
                        //                        stockinfo[i].StockNumber += item.F_InStockNum;
                        //                    }
                        //                }

                        //                //更新审核状态
                        //                string sql = string.Format("update PI_Head set F_Status=1,F_VeriDate='{0}',F_Verify='{1}' where F_Id='{2}'", date, user, Id);
                        //                hash = new Hashtable();
                        //                base.ExecuteNonQuery(sql, hash, dbtran.Transaction);

                        //                //更新子表入库状态
                        //                hash = new Hashtable();
                        //                hash.Add("F_AlreadyOperatedNum", 1);
                        //                PI_Body.Instance.Update(item.F_Id, hash, dbtran.Transaction);

                        //                //更新主表入库状态
                        //                hash = new Hashtable();
                        //                hash.Add("F_State", 1);
                        //                PI_Head.Instance.Update(item.F_HId, hash, dbtran.Transaction);


                        //                //添加履历
                        //                Sys_InRecordsInfo inRec = new Sys_InRecordsInfo();
                        //                inRec.F_Id = Guid.NewGuid().ToString();
                        //                inRec.F_WarehouseId = item.F_WarehouseId;
                        //                inRec.F_EnCode = item.F_OrderNo;
                        //                inRec.F_Batch = item.F_SerialNum;
                        //                inRec.F_Vendor = hinfo.F_Vendor;
                        //                inRec.F_VendorName = hinfo.F_VendorName;
                        //                inRec.F_Contacts = hinfo.F_Contacts;
                        //                inRec.F_TelePhone = hinfo.F_TelePhone;
                        //                inRec.F_Verify = user;
                        //                inRec.F_Maker = hinfo.F_Maker;
                        //                inRec.F_VeriDate = DateTime.Now;
                        //                inRec.F_WarehouseName = item.F_WarehouseName;
                        //                inRec.F_GoodsName = item.F_FullName;
                        //                inRec.F_GoodsId = item.F_GoodsId;
                        //                inRec.F_CargoPositionId = item.F_CargoPositionId;
                        //                inRec.F_CargoPositionName = item.F_CargoPositionName;
                        //                inRec.F_SpecifModel = item.F_SpecifModel;
                        //                inRec.F_SellingPrice = item.F_SellingPrice;
                        //                inRec.F_PurchasePrice = item.F_PurchasePrice;
                        //                inRec.F_Unit = item.F_Unit;
                        //                inRec.F_InStockNum = item.F_InStockNum;
                        //                inRec.F_CreatorTime = DateTime.Now;
                        //                Sys_InRecords.Instance.Insert(inRec, dbtran.Transaction);

                        //                //添加库存履历
                        //                Sys_StockHistoryInfo instock = new Sys_StockHistoryInfo();
                        //                instock.F_Id = Guid.NewGuid().ToString();
                        //                instock.F_WarehouseId = item.F_WarehouseId;
                        //                instock.F_EnCode = item.F_OrderNo;
                        //                instock.F_Batch = item.F_SerialNum;
                        //                instock.F_Vendor = hinfo.F_Vendor;
                        //                instock.F_VendorName = hinfo.F_VendorName;
                        //                instock.F_Contacts = hinfo.F_Contacts;
                        //                instock.F_TelePhone = hinfo.F_TelePhone;
                        //                instock.F_Verify = user;
                        //                instock.F_Maker = hinfo.F_Maker;
                        //                instock.F_VeriDate = DateTime.Now;
                        //                instock.F_WarehouseName = item.F_WarehouseName;
                        //                instock.F_BllCategory = "入库";
                        //                instock.F_GoodsName = item.F_FullName;
                        //                instock.F_GoodsId = item.F_GoodsId;
                        //                instock.F_CargoPositionId = item.F_CargoPositionId;
                        //                instock.F_CargoPositionName = item.F_CargoPositionName;
                        //                instock.F_SpecifModel = item.F_SpecifModel;
                        //                instock.F_SellingPrice = item.F_SellingPrice;
                        //                instock.F_PurchasePrice = item.F_PurchasePrice;
                        //                instock.F_Unit = item.F_Unit;
                        //                instock.F_OperationNum = item.F_InStockNum;
                        //                instock.F_CreatorTime = DateTime.Now;
                        //                Sys_StockHistory.Instance.Insert(instock, dbtran.Transaction);
                        //            }
                        //        }
                        //        dbtran.Commit();
                        //        return "单据审核成功";
                        //    }
                        //    catch (Exception ex)
                        //    {
                        //        dbtran.RollBack();
                        //        return "操作失败";
                        //        throw ex;
                        //    }
                        //}
                        #endregion
                    }
                }
                catch (Exception ex)
                {
                    dbtran.RollBack();
                    return("操作失败");

                    throw ex;
                }
            }
        }
Пример #39
0
 public Task <Category> FindItem(SearchCondition condition)
 {
     throw new NotImplementedException();
 }
 public ModifyDataForm(rasterTable ts, DataGridView dg, SearchCondition sc)
 {
     InitializeComponent();
     this._selecData = ts;
     InitForm(ts);
 }
Пример #41
0
 public Task <List <Category> > ListAll(SearchCondition condition, OrderCondition orderitems)
 {
     throw new NotImplementedException();
 }
        protected override List <InventoryCheckRecord> GetingItems(System.Data.Linq.DataContext dc, SearchCondition search)
        {
            IQueryable <InventoryCheckRecord> ret   = dc.GetTable <InventoryCheckRecord>();
            List <InventoryCheckRecord>       items = ret.ToList();

            return(items);
        }
Пример #43
0
        public InStockNotice_HeadInfo Save(InStockNotice_HeadInfo info, List <InStockNotice_BodyInfo> BInfo)
        {
            using (DbTransactionScope <InStockNotice_HeadInfo> dbtran = base.CreateTransactionScope())
            {
                try
                {
                    if (string.IsNullOrEmpty(info.F_EnCode))
                    {
                        string    orderNo = "INOT" + DateTime.Now.ToString("yyyyMMdd");
                        Hashtable hash    = new Hashtable();
                        hash.Add("Prefix", orderNo);
                        DataTable dt = base.StorePorcToDataTable("SYS_GENERATE_SN", hash, null, dbtran.Transaction);
                        string    SN = dt.Rows[0][0].ToString();
                        info.F_EnCode = SN;
                    }
                    else
                    {
                        //判断当前单据是否已经审核
                        var head = this.FindByID(info.F_Id, dbtran.Transaction);
                        if (head != null && head.F_Status == 1)
                        {
                            throw new ApplicationException("单据已经审核!");
                        }
                    }
                    info.F_Status   = 0;
                    info.F_Verifier = "";
                    info.F_Veridate = null;
                    //添加主表
                    InStockNotice_Head.Instance.InsertUpdate(info, info.F_Id, dbtran.Transaction);
                    //删除子表
                    SearchCondition condition = new SearchCondition();
                    condition.AddCondition("F_HeadId", info.F_Id, SqlOperator.Equal);
                    InStockNotice_Body.Instance.DeleteByCondition(condition.BuildConditionSql().Replace("Where (1=1)  AND ", string.Empty), dbtran.Transaction);
                    //循环添加子表
                    foreach (InStockNotice_BodyInfo item in BInfo)
                    {
                        item.F_CreatorTime   = DateTime.Now;
                        item.F_CreatorUserId = info.F_CreatorUserId;
                        item.F_Id            = Guid.NewGuid().ToString();
                        item.F_HeadId        = info.F_Id;


                        string    orderNo = "INOTB" + DateTime.Now.ToString("yyyyMMdd");
                        Hashtable hash    = new Hashtable();
                        hash.Add("Prefix", orderNo);
                        DataTable dt = base.StorePorcToDataTable("SYS_GENERATE_SN", hash, null, dbtran.Transaction);
                        string    SN = dt.Rows[0][0].ToString();
                        item.F_EnCode = SN;
                        //InStockNotice_Body.Instance.Insert(item, dbtran.Transaction);
                    }
                    InStockNotice_Body.Instance.InsertRange(BInfo, dbtran.Transaction);

                    dbtran.Commit();

                    return(info);
                }
                catch (Exception ex)
                {
                    dbtran.RollBack();
                    throw ex;
                }
            }
        }
Пример #44
0
        /// <summary>
        /// 异步根据条件从视图获取DataTable
        /// </summary>
        /// <typeparam name="D">BLL类型</typeparam>
        /// <param name="condition">过滤条件 对象为空时,返回所有集合</param>
        /// <param name="pager">分页对象 对象为空时,则不分页</param>
        /// <returns></returns>
        protected virtual Task <DataTable> FindToDataTableAsync <D>(string viewName, string sortField, bool isDescending = false, SearchCondition condition = null, PagerInfo pager = null)
            where D : BaseBLL <BaseEntity>
        {
            return(Task.Run(() =>
            {
                DataTable dt = null;
                if (pager == null)
                {
                    dt = BLLFactory <D> .Instance.FindByView(viewName, BuilderConditionStr(condition));
                }
                else
                {
                    dt = BLLFactory <D> .Instance.FindByViewWithPager(viewName, BuilderConditionStr(condition), sortField, isDescending, pager);
                }

                return dt;
            }));
        }
Пример #45
0
 private void btnSearch_Click(object sender, EventArgs e)
 {
     advanceCondition = null;//必须重置查询条件,否则可能会使用高级查询条件了
     BindData();
 }
Пример #46
0
        public void Search()
        {
            using (var imap = GetClient <ImapClient>()) {
                var result = imap.SearchMessages(
                    //"OR ((UNDELETED) (FROM \"david\") (SENTSINCE \"01-Jan-2000 00:00:00\")) (TO \"andy\")"
                    SearchCondition.Undeleted().And(SearchCondition.From("david"), SearchCondition.SentSince(new DateTime(2000, 1, 1))).Or(SearchCondition.To("andy"))
                    );
                result.Length.ShouldBeInRange(1, int.MaxValue);
                result.First().Value.Subject.ShouldNotBeNullOrEmpty();

                result = imap.SearchMessages(new SearchCondition {
                    Field = SearchCondition.Fields.Text, Value = "asdflkjhdlki2uhiluha829hgas"
                });
                result.Length.ShouldBe(0);
            }
        }
Пример #47
0
 static SearchCondition GetSearchCondition()
 {
     return(SearchCondition.From(readMessagesFilterAccount).And(SearchCondition.Unseen()));
 }
Пример #48
0
        public static DataTable ExecuteDataTable(this SQLHelper sqlHelper, string sql, BaseQueryBuilder qb, bool dealOrderby = true)
        {
            string orderby = "";

            if (dealOrderby)
            {
                int index = sql.LastIndexOf(" order by", StringComparison.CurrentCultureIgnoreCase);
                if (index > 0)
                {
                    orderby = sql.Substring(index + " order by".Length);
                    sql     = sql.Substring(0, index);
                }
            }

            SearchCondition authCnd = FormulaHelper.CreateAuthDataFilter();

            #region 处理@参数
            List <SqlParameter> pList = new List <SqlParameter>();
            for (int i = authCnd.Items.Count - 1; i >= 0; i--)
            {
                var item = authCnd.Items[i];
                if (item.Field.StartsWith("@"))
                {
                    authCnd.Items.RemoveAt(i);
                    pList.Add(new SqlParameter(item.Field, item.Value));
                }
            }
            for (int i = qb.Items.Count - 1; i >= 0; i--)
            {
                var item = qb.Items[i];
                if (item.Field.StartsWith("@"))
                {
                    qb.Items.RemoveAt(i);
                    pList.Add(new SqlParameter(item.Field, item.Value));
                }
            }
            #endregion

            if (authCnd.Items.Count > 0)
            {
                sql = string.Format("select * from ({0}) sourceTable1 {1}", sql, authCnd.GetWhereString());
            }

            sql = string.Format("select {2} from ({0}) sourceTable {1}", sql, qb.GetWhereString(), qb.Fields);

            string[] qbSortFields = qb.SortField.Split(',');
            string[] qbSortOrders = qb.SortOrder.Split(',');
            for (int i = 0; i < qbSortFields.Length; i++)
            {
                qbSortFields[i] += " " + qbSortOrders[i];
            }
            string qbOrderBy = string.Join(",", qbSortFields);
            if (orderby == "" || !qb.DefaultSort)
            {
                orderby = qbOrderBy;
            }

            if (qb.PageSize == 0)
            {
                DataTable dt = sqlHelper.ExecuteDataTable(sql + " order by " + orderby, pList.ToArray(), CommandType.Text);
                qb.TotolCount = dt.Rows.Count;
                return(dt);
            }
            else
            {
                object totalCount = sqlHelper.ExecuteScalar(string.Format("select count(1) from ({0}) tableCount", sql), pList.ToArray(), CommandType.Text);
                qb.TotolCount = Convert.ToInt32(totalCount);


                int start = qb.PageIndex * qb.PageSize + 1;
                int end   = start + qb.PageSize - 1;

                sql = string.Format(@"select * from (select tempTable1.*, Row_number() over(order by {1}) as RowNumber from ({0}) tempTable1) tmpTable2 where RowNumber between {2} and {3}", sql, orderby, start, end);

                return(sqlHelper.ExecuteDataTable(sql, pList.ToArray(), CommandType.Text));
            }
        }
Пример #49
0
        /// <summary>
        /// 真正的检索方法,需要派生类进行实现
        /// </summary>
        /// <param name="condition">查询条件</param>
        /// <returns>检索结果</returns>
        protected override Result GetSearchResult(SearchCondition condition)
        {
            ISolrOperations <Record> solr = ServiceLocator.Current.GetInstance <ISolrOperations <Record> >();

            return(GetSearchResult(condition, solr));
        }
Пример #50
0
        public override void DoLoginedHandlerWork(HttpContext context)
        {
            Message jsonMessage;

            jsonMessage = new Message()
            {
                Result     = false,
                TxtMessage = "权限验证失败,可能原因:\n1、数据中心通讯失败。\n2、系统管理员未与您分配对应操作权限。"
            };

            string AjaxType = context.Request.QueryString["AType"] == null ? string.Empty : context.Request.QueryString["AType"].ToString().ToUpper();
            //context.Response.Write(AjaxType);
            //context.Response.End();
            ADContext Info = new ADContext();
            WCFServiceProxy <IADContextDAL> proxy = null;

            Info  = new CommonModelFactory <ADContext>().GetModelFromContext(context);
            proxy = new WCFServiceProxy <IADContextDAL>();

            try {
                switch (AjaxType)
                {//查询用户
                case "QUERY":

                    CommonSearch <ADContext> InfoSearch = new CommonSearch <ADContext>();
                    string Where = "1=1 ";
                    Where += "AND CompanyID='" + loginOperator.CompanyID + "' ";
                    if (context.Request.Form["TWhere"] != null && context.Request.Form["TWhere"].ToString().Trim() != string.Empty)
                    {
                        Where += context.Request.Form["TWhere"].ToString();
                    }
                    SearchCondition sCondition = new SearchCondition()
                    {
                        TBName = "ADContext", TFieldKey = "AC_ID", TTotalCount = -1, TPageCurrent = 1, TFieldOrder = "AC_ID desc", TWhere = Where
                    };
                    List <ADContext> list = InfoSearch.GetList(ref sCondition, context);

                    jsonMessage = new Message()
                    {
                        Result     = true,
                        TxtMessage = JSon.ListToJson <ADContext>(list, sCondition.TTotalCount)
                    };
                    break;

                //广告主题列表
                case "QUERYVIEW":

                    CommonSearch <ADContext> InfoSearchView = new CommonSearch <ADContext>();
                    Where  = "1=1 ";
                    Where += "AND CompanyID='" + loginOperator.CompanyID + "' ";
                    if (context.Request.Form["TWhere"] != null && context.Request.Form["TWhere"].ToString().Trim() != string.Empty)
                    {
                        Where += context.Request.Form["TWhere"].ToString();
                    }
                    sCondition = new SearchCondition()
                    {
                        TBName = "ADContext", TFieldKey = "AC_ID", TTotalCount = -1, TPageCurrent = 1, TFieldOrder = " AC_ID desc", TWhere = Where
                    };

                    List <ADContext> listView = InfoSearchView.GetList(ref sCondition, context);

                    jsonMessage = new Message()
                    {
                        Result     = true,
                        TxtMessage = JSon.ListToJson <ADContext>(listView, sCondition.TTotalCount)
                    };
                    break;

                //广告主题列表
                case "QUERYVIEWLIST":

                    CommonSearch <ADContext> InfoSearchView2 = new CommonSearch <ADContext>();
                    Where  = "1=1 and State != 0 ";
                    Where += "AND CompanyID='" + loginOperator.CompanyID + "' ";
                    if (context.Request.Form["TWhere"] != null && context.Request.Form["TWhere"].ToString().Trim() != string.Empty)
                    {
                        Where += context.Request.Form["TWhere"].ToString();
                    }
                    sCondition = new SearchCondition()
                    {
                        TBName = "ADContext", TFieldKey = "AC_ID", TTotalCount = -1, TPageCurrent = 1, TFieldOrder = " AC_ID desc", TWhere = Where
                    };

                    List <ADContext> listView2 = InfoSearchView2.GetList(ref sCondition, context);

                    jsonMessage = new Message()
                    {
                        Result     = true,
                        TxtMessage = JSon.ListToJson <ADContext>(listView2, sCondition.TTotalCount)
                    };
                    break;

                //添加主题广告
                case "ADD":
                    Info.CompanyID  = base.loginOperator.CompanyID;
                    Info.State      = 0;
                    Info.CreateDate = DateTime.Now;
                    jsonMessage     = proxy.getChannel.Add(Info);

                    break;

                case "EDIT":
                    Info.CompanyID = base.loginOperator.CompanyID;
                    jsonMessage    = proxy.getChannel.Edit(Info);
                    break;

                //删除信息
                case "DELCONTENT":
                    jsonMessage = proxy.getChannel.Delete((int)Info.AC_ID);
                    break;

                //草稿->可发布
                case "UPDATEOK":
                    jsonMessage = proxy.getChannel.UpadteAdStatus(Info.AC_ID, 1);
                    break;

                //可发布-> 草稿
                case "UPDATENO":
                    jsonMessage = proxy.getChannel.UpadteAdStatus(Info.AC_ID, 0);
                    break;

                default:
                    jsonMessage = new Message()
                    {
                        Result     = false,
                        TxtMessage = "1.操作未定义!" + AjaxType
                    };
                    break;
                }
            }
            catch (Exception ex)
            {
                jsonMessage = new Message()
                {
                    Result     = false,
                    TxtMessage = ex.Message
                };
            }
            finally
            {
                if (proxy != null)
                {
                    proxy.CloseChannel();
                }
            }
            context.Response.Write(JSon.TToJson <Message>(jsonMessage));
        }
Пример #51
0
 void dlg_ConditionChanged(SearchCondition condition)
 {
     advanceCondition = condition;
     BindData();
 }
Пример #52
0
        protected static FR_L3ABDA_GAAfAS_1256_Array Execute(DbConnection Connection, DbTransaction Transaction, P_L3ABDA_GAAfAS_1256 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
        {
            #region UserCode
            var returnValue = new FR_L3ABDA_GAAfAS_1256_Array();

            #region Check ABDA Catalog Subscription

            string catalogITL = EnumUtils.GetEnumDescription(EPublicCatalogs.ABDA);

            var sbsCatalog = ORM_CMN_PRO_SubscribedCatalog.Query.Search(Connection, Transaction, new ORM_CMN_PRO_SubscribedCatalog.Query()
            {
                CatalogCodeITL = catalogITL,
                Tenant_RefID   = securityTicket.TenantID,
                IsDeleted      = false
            }).FirstOrDefault();

            if (sbsCatalog == null)
            {
                return(returnValue);
            }

            #endregion

            var searchCondition = Parameter.SearchCondition;
            if (!searchCondition.Contains("*"))
            {
                searchCondition = String.Format("*{0}*", searchCondition);
            }

            string query = new QueryBuilder <Product>()
                           .From(0)
                           .Size(10000)
                           .Query(q => q
                                  .Bool(b => b
                                        .Must(m => m
                                              .QueryString(qs => qs.Fields(
                                                               new string[] {
                SearchCondition.GetFiledName(ProductField.NAME), SearchCondition.GetFiledName(ProductField.CODE)
            })
                                                           .Query(SearchCondition.GetConditionForSearchText(Parameter.SearchCondition)))
                                              )
                                        )
                                  )
                           .Sort(s => s
                                 .Field(SearchCondition.GetFiledName(ProductField.NAME), PlainElastic.Net.SortDirection.asc))
                           .BuildBeautified();

            var ProductService = CatalogServiceFactory.GetProductService();


            ProductQueryRequest request = new ProductQueryRequest()
            {
                CatalogCode = catalogITL
            };


            SearchResult <Product> res = ProductService.QueryProducts(request, query);


            var retrievedProducts = res.Documents.ToList();
            var abdaProducts      = new List <L3ABDA_GAAfAS_1256>();
            foreach (var product in retrievedProducts)
            {
                abdaProducts.Add(new L3ABDA_GAAfAS_1256()
                {
                    ProductITL    = product.ProductITL,
                    ProductNumber = product.Code,
                    ProductName   = product.Name
                });
            }

            returnValue.Result = abdaProducts.ToArray();

            return(returnValue);

            #endregion UserCode
        }
Пример #53
0
 protected override List <WorkStationInfo> GetingItems(ParkDataContext parking, SearchCondition search)
 {
     if (search is WorkstationSearchCondition)
     {
         WorkstationSearchCondition   con    = search as WorkstationSearchCondition;
         IQueryable <WorkStationInfo> result = parking.WorkStation.AsQueryable();
         if (con.DeptID != null)
         {
             result = result.Where(w => w.DeptID == con.DeptID);
         }
         result = result.OrderBy(w => w.StationID);
         return(result.ToList());
     }
     else
     {
         return(new List <WorkStationInfo>());
     }
 }
Пример #54
0
        /// <summary>
        /// Performs search and populates the returned raw data into the internal search service dataset.
        /// </summary>
        /// <param name="query">Text to search</param>
        /// <param name="pageIndex">Zero-based page index</param>
        /// <param name="pageSize">Page size</param>
        /// <param name="numberOfResults">Total number of search results</param>
        private void SearchInternal(string query, int pageIndex, int pageSize, out int numberOfResults)
        {
            var documentCondition = new DocumentSearchCondition(null, mCultureName, mDefaultCulture, mCombineWithDefaultCulture);
            var condition = new SearchCondition(documentCondition: documentCondition);
            var searchExpression = SearchSyntaxHelper.CombineSearchCondition(query, condition);

            var parameters = new SearchParameters
            {
                SearchFor = searchExpression,
                Path = "/%",
                ClassNames = null,
                CurrentCulture = mCultureName,
                DefaultCulture = mDefaultCulture,
                CombineWithDefaultCulture = mCombineWithDefaultCulture,
                CheckPermissions = false,
                SearchInAttachments = false,
                User = MembershipContext.AuthenticatedUser,
                SearchIndexes = mSearchIndexNames.Join(";"),
                StartingPosition = pageIndex * pageSize,
                NumberOfResults = 0,
                NumberOfProcessedResults = 100,
                DisplayResults = pageSize
            };

            // Search and save results
            mRawResults = SearchHelper.Search(parameters);
            numberOfResults = parameters.NumberOfResults;
        }
Пример #55
0
 public Task <int> Count(SearchCondition conditions)
 {
     throw new NotImplementedException();
 }
Пример #56
0
 /// <summary>
 /// ������ƷSearch���
 /// </summary>
 /// <param name="searchCondition">Search Condition</param>
 /// <param name="componentGroup">�������ƷSearch���</param>
 public static void Cache(SearchCondition searchCondition, Merchandise componentGroup)
 {
     if (Utility.IsSubAgent && searchCondition is TourSearchCondition)
         CachedSubTours[searchCondition] = componentGroup;
     else
         CachedMerchandises[searchCondition] = componentGroup;
 }
Пример #57
0
    /// <summary>
    /// ɾ��ָ������ƷSearch���
    /// </summary>
    /// <param name="searchCondition"></param>
    /// <param name="componentGroup"></param>
    public static bool Remove(SearchCondition searchCondition, Merchandise componentGroup)
    {
        KeyValuePair<SearchCondition, Merchandise> item = new KeyValuePair<SearchCondition, Merchandise>(searchCondition, componentGroup);

        if (CachedMerchandises.Contains(item))
        {
            CachedMerchandises.Remove(item);
            return true;
        }
        else
        {
            return false;
        }
    }
Пример #58
0
    /// <summary>
    /// ɾ��ָ������ƷSearch���
    /// </summary>
    /// <param name="searchCondition"></param>
    /// <returns></returns>
    public static bool Remove(SearchCondition searchCondition)
    {
        if (CachedMerchandises.Keys.Contains(searchCondition))
        {
            CachedMerchandises.Remove(searchCondition);

            return true;
        }
        else
        {
            return false;
        }
    }
Пример #59
0
    /// <summary>
    /// ����Search Condition���һ������ƷSearch���
    /// </summary>
    /// <param name="searchCondition">Search Condition</param>
    /// <returns>�������ƷSearch���</returns>
    public static Merchandise FindB2BTour(SearchCondition searchCondition)
    {
        Merchandise result = null;
        if (searchCondition != null)
        {
            foreach (SearchCondition key in CachedSubTours.Keys)
            {
                if (key.Equals(searchCondition))
                {
                    result = CachedSubTours[key];
                    break;
                }
            }
        }

        return result;
    }
Пример #60
-1
        private ObjectSearchResults Find(SearchCondition searchCondition)
        {
            var vault = this.VaultService.Vault.Value;

              var searchConditions = new SearchConditions();
              searchConditions.Add(-1, searchCondition);

              var objectSearchResults = vault.ObjectSearchOperations.SearchForObjectsByConditionsEx(
            searchConditions,
            MFSearchFlags.MFSearchFlagLookInAllVersions | MFSearchFlags.MFSearchFlagDisableRelevancyRanking,
            false,
            MaxResultCount: 100000,
            SearchTimeoutInSeconds: Int32.MaxValue);

              return objectSearchResults;
        }