コード例 #1
0
        private void UpdateFindQuery(int quickFindId, int quickFindSeach)
        {
            //  var quickFindList = new IEnumerable<QuickFind_Query>();
            var rep        = new GenericRepository <QuickFind_Query>(_context);
            var quickFindQ = rep.GetAll().Where(s => s.QuickFindID == quickFindId);

            if (quickFindQ.Any())
            {
                // var quickFindQuery = dbConLastUsedToday.QuickFind_Queries.Where(s => s.QuickFindID == quickFindId);
                foreach (var value in quickFindQ)
                {
                    var newLastSearchQuery = new QuickFind_Query
                    {
                        QuickFindID   = quickFindSeach,
                        QF_ColumnName = value.QF_ColumnName,
                        QueryString   = value.QueryString,
                        QF_Operator   = value.QF_Operator,
                        QF_Value1     = value.QF_Value1,
                        QF_Value2     = value.QF_Value2
                    };

                    InsertQuickFindQuery(newLastSearchQuery);
                }
            }
        }
コード例 #2
0
 private async void InsertQuickFindQuery(QuickFind_Query queryObject)
 {
     var rep = new GenericRepository <QuickFind_Query>(_context);
     await rep.InsertAsync(queryObject);
 }