public List <Config> List() { System.Linq.IQueryable <Config> Return = from Table in this.DBLocal.Config select Table; return(Return.ToList()); }
/// <summary> /// 对第一条记录开启更新锁,并返回这条记录的对象 /// </summary> /// <typeparam name="T"></typeparam> /// <param name="items"></param> /// <returns></returns> public T UpdateLockFirstOrDefault <T>(System.Linq.IQueryable <T> items) where T : class { if (this.Database.Connection.State != System.Data.ConnectionState.Open) { throw new Exception("没有开启事务"); } Type dataType = typeof(T); var tableSchema = SchemaManager.GetSchemaTable(dataType); if (tableSchema.KeyColumn == null) { throw new Exception(dataType.Name + "没有定义主键"); } var query = InvokeSelect(items, tableSchema.KeyColumn.PropertyName); var idvalue = InvokeFirstOrDefault(query); if (idvalue == null) { return(default(T)); } this.Database.UpdateLock(dataType, idvalue); query = this.Set <T>(); query = InvokeWhereEquals(query, tableSchema.KeyColumn.PropertyName, idvalue); return((T)InvokeFirstOrDefault(query)); }
public List <PsProductAttachment> List() { System.Linq.IQueryable <PsProductAttachment> Return = from Table in this.DBPrestashop.PsProductAttachment select Table; return(Return.ToList()); }
public List <AttributeArticle> List() { System.Linq.IQueryable <AttributeArticle> Return = from Table in this.DBLocal.AttributeArticle select Table; return(Return.ToList()); }
/**/ /// <summary> /// 创建自身实例 /// </summary> /// <typeparam name="N">类型,如果此处为匿名类型,请用var 定义实体,且类后的T为object(其实什么也不重要,只是用于可以调用当前类的静态方法)</typeparam> /// <param name="Query">Linq查询语句</param> /// <param name="type">元素类型</param> /// <param name="IndexPage">开始页</param> /// <param name="PageSize">每页大小</param> /// <returns></returns> public static DataPageList <N> Create <N>(System.Linq.IQueryable Query, int IndexPage, int PageSize) { System.Linq.IQueryable <N> query = (System.Linq.IQueryable <N>)Query; return(new DataPageList <N>(query, IndexPage, PageSize)); } //public static DataPageList<N> Create<N>(System.Linq.IQueryable Query, int IndexPage, int PageSize) //{ // return Create<N>(Query, IndexPage, PageSize); //} /**/ /// <summary> /// 更新数据 /// </summary> public virtual void Update() { allRecordCount = query.Count(); PageAttrList.Clear(); if (pageSize > 0) { query = query.Skip((indexPage - 1) * pageSize).Take(pageSize); thisPageRecordCount = query.Count(); //计算分页结果 pageCount = (allRecordCount % pageSize == 0) ? (allRecordCount / pageSize) : allRecordCount / pageSize + 1; if (indexPage > 1) { canFirstPage = true; } canPrevPage = true; if (indexPage < pageCount) { canNextPage = true; } canLastpage = true; } else { thisPageRecordCount = allRecordCount; pageCount = indexPage = 1; canFirstPage = canPrevPage = canNextPage = canLastpage = false; } for (var cur = 1; cur <= pageCount; cur++) { PageAttrList.Add(new PageAttr { Page = cur }); } listValue = query.ToList(); }
public List <PsOrderHistory> List() { System.Linq.IQueryable <PsOrderHistory> Return = from Table in this.DBPrestashop.PsOrderHistory select Table; return(Return.ToList()); }
public static System.Linq.IQueryable <TEntity> Contains <TEntity, T>(this System.Linq.IQueryable <TEntity> source, IEnumerable <T> forCollection, string fullyQualifiedTableName, bool avoidReadLocks = false, params Expression <Func <TEntity, object> >[] joinColumns ) where TEntity : class { var root = new XElement("nodes"); //generate xml foreach (var entity in forCollection) { root.Add(new XElement("node", joinColumns.Select(c => new XElement(ExtensionHelper.GetProperty(c).Name, entity.GetType().GetProperty(ExtensionHelper.GetProperty(c).Name)?.GetValue(entity, null))))); } var sqlStr = new StringBuilder( $"SELECT tbl.* FROM @xml.nodes('/nodes/node') nodes([node]) JOIN {fullyQualifiedTableName} tbl {(avoidReadLocks ? "WITH (NOLOCK)" : "")} ON "); //append join filter clauses sqlStr.Append(string.Join(" AND ", joinColumns.Select(c => $"tbl.[{ExtensionHelper.GetProperty(c).Name}] = [nodes].[node].value('({ExtensionHelper.GetProperty(c).Name})[1]', '{ExtensionHelper.GetDbMappedType(ExtensionHelper.GetProperty(c).GetUnderlyingType())}')"))); var matched = source.FromSql(sqlStr.ToString(), new SqlParameter("@xml", new SqlXml(root.CreateReader()))); return(matched.AsQueryable()); }
public List <PsProductAttributeCombination> List() { System.Linq.IQueryable <PsProductAttributeCombination> Return = from Table in this.DBPrestashop.PsProductAttributeCombination select Table; return(Return.ToList()); }
public List <Settlement> List() { System.Linq.IQueryable <Settlement> Return = from Table in this.DBLocal.Settlement select Table; return(Return.ToList()); }
//------------------------------------------------------------------------------------------------- public IEnumerable <UserForShowDto> FilterSerchingUsers(FilterUserRequestDto searchItem) { IEnumerable <UserForShowDto> res = null; using (_db = new IdeaManagmentDatabaseEntities()) { System.Linq.IQueryable <USER> users = _db.USERS; if (searchItem.Username != null && searchItem.Username.Trim().Length > 0) { users = users.Where(u => u.USERNAME.Contains(searchItem.Username.Trim())); } if (searchItem.FullName != null && searchItem.FullName.Trim().Length > 0) { if (searchItem.FullName.Trim().Contains(" ")) { var firstName = searchItem.FullName.Trim().Substring(0, searchItem.FullName.Trim().IndexOf(" ")); var lastName = searchItem.FullName.Trim().Substring(searchItem.FullName.Trim().IndexOf(" ") + 1); users = users.Where(u => u.FIRST_NAME.Contains(firstName.Trim()) && u.LAST_NAME.Contains(lastName.Trim())); } else { users = users.Where(u => u.FIRST_NAME.Contains(searchItem.FullName.Trim()) || u.LAST_NAME.Contains(searchItem.FullName.Trim())); } } switch (searchItem.RoleValue) { case 0: users = users.Where(u => u.ADMIN_FLAG == false && u.COMMITTEE_FLAG == false); break; case 1: users = users.Where(u => u.ADMIN_FLAG == false && u.COMMITTEE_FLAG == true); break; case 2: users = users.Where(u => u.ADMIN_FLAG == true && u.COMMITTEE_FLAG == false); break; case 3: users = users.Where(u => u.ADMIN_FLAG == true && u.COMMITTEE_FLAG == true); break; default: break; } res = users.ToList().Select(x => new UserForShowDto() { CommitteFlag = x.COMMITTEE_FLAG, AdminFlag = x.ADMIN_FLAG, Email = x.EMAIL, FirstName = x.FIRST_NAME, LastName = x.LAST_NAME, SaveDate = Persia.Calendar.ConvertToPersian(x.SAVE_DATE).Simple, Username = x.USERNAME }); } return(res); }
public static int GetCountFromCache <T>(this System.Linq.IQueryable <T> q, System.Data.Linq.DataContext dc) { try { string CacheId = q.ToString() + "Count?"; foreach (System.Data.Common.DbParameter dbp in dc.GetCommand(q).Parameters) { CacheId += dbp.ParameterName + "=" + dbp.Value.ToString() + "&"; } object count; //if (Environment.StackTrace.Contains("CMS\\")) //{ count = q.Count(); return((int)count); //} //else //{ //System.Threading.Thread.Sleep(500); count = System.Web.HttpRuntime.Cache.Get(CacheId); // } if (count == null) { List <string> tablesNames = dc.Mapping.GetTables().Where(t => CacheId.Contains("[" + t.TableName.Substring(4) + "]")).Select(t => t.TableName.Substring(4)).ToList(); string connStr = dc.Connection.ConnectionString; using (System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(connStr)) { conn.Open(); System.Web.Caching.SqlCacheDependencyAdmin.EnableNotifications(connStr); System.Web.Caching.SqlCacheDependency sqldep; AggregateCacheDependency aggDep = new AggregateCacheDependency(); foreach (string tableName in tablesNames) { if (!System.Web.Caching.SqlCacheDependencyAdmin.GetTablesEnabledForNotifications(connStr).Contains(tableName)) { System.Web.Caching.SqlCacheDependencyAdmin.EnableTableForNotifications(connStr, tableName); } if (tableName.Contains("Comment") || tableName.Contains("PollDetail")) { sqldep = new System.Web.Caching.SqlCacheDependency("PlatformCacheSmallPollTime", tableName); } else { sqldep = new System.Web.Caching.SqlCacheDependency("PlatformCache", tableName); } aggDep.Add(sqldep); } count = q.Count(); System.Web.HttpRuntime.Cache.Insert(CacheId, count, aggDep, DateTime.Now.AddDays(1), System.Web.Caching.Cache.NoSlidingExpiration); } } //Return the created (or cached) List return((int)count); } catch (System.Exception ex) { throw ex; } }
public List <PsOleaPromo> List() { System.Linq.IQueryable <PsOleaPromo> Return = from Table in this.DBPrestashop.PsOleaPromo select Table; return(Return.ToList()); }
public List<PsOrderCartRule> ListOrder(UInt32 Order) { System.Linq.IQueryable<PsOrderCartRule> Return = from Table in this.DBPrestashop.PsOrderCartRule where Table.IDOrder == Order select Table; return Return.ToList(); }
public List <Group> List() { System.Linq.IQueryable <Group> Return = from Table in this.DBLocal.Group select Table; return(Return.ToList()); }
public List <Order> List() { System.Linq.IQueryable <Order> Return = from Table in this.DBLocal.Order select Table; return(Return.ToList()); }
public List <PsConfiguration> List() { System.Linq.IQueryable <PsConfiguration> Return = from Table in this.DBPrestashop.PsConfiguration select Table; return(Return.ToList()); }
private void Filter() { System.Linq.IQueryable <vQuestionX> q = from p in db.vQuestionXes select p; if (GlobalClass.checkUserStatus() != 1) { q = from p in db.vQuestionXes where p.User_Name.Equals(GlobalClass.UserName) select p; } if (this.TxtQuestionNumber.Text != "") { q = from p in q where p.Question_Number.Equals(Convert.ToInt32(this.TxtQuestionNumber.Text)) select p; } if (this.cboCourt.SelectedIndex != -1) { q = from p in q where p.Court_ID.Equals(Convert.ToInt32(this.cboCourt.SelectedValue)) select p; } if (this.cboDateInterval.SelectedIndex != -1) { q = from p in q where p.Date_Interval_ID.Equals(Convert.ToInt32(this.cboDateInterval.SelectedValue)) select p; } if (this.cboGender.SelectedIndex != -1) { q = from p in q where p.Gender_ID.Equals(Convert.ToInt32(this.cboGender.SelectedValue)) select p; } if (this.cboRecordStatus.SelectedIndex != -1) { q = from p in q where p.Record_Status_ID.Equals(Convert.ToInt32(this.cboRecordStatus.SelectedValue)) select p; } this.vQuestionXBindingSource.DataSource = q; }
public List <ConditioningArticle> List() { System.Linq.IQueryable <ConditioningArticle> Return = from Table in this.DBLocal.ConditioningArticle select Table; return(Return.ToList()); }
public List <PsCategoryGroup> List() { System.Linq.IQueryable <PsCategoryGroup> Return = from Table in this.DBPrestashop.PsCategoryGroup select Table; return(Return.ToList()); }
public List <Supply> List() { System.Linq.IQueryable <Supply> Return = from Table in this.DBLocal.Supply select Table; return(Return.ToList()); }
public List <CompositionArticleImage> List() { System.Linq.IQueryable <CompositionArticleImage> Return = from Table in this.DBLocal.CompositionArticleImage select Table; return(Return.ToList()); }
public List <CatalogImage> List() { System.Linq.IQueryable <CatalogImage> Return = from Table in this.DBLocal.CatalogImage select Table; return(Return.ToList()); }
public List <Tax> List() { System.Linq.IQueryable <Tax> Return = from Table in this.DBLocal.Tax select Table; return(Return.ToList()); }
public List <Model.Internal.CategorieComptable> ListCatComptaVente() { List <Model.Internal.CategorieComptable> Return = new List <Model.Internal.CategorieComptable>(); System.Linq.IQueryable <P_CATCOMPTA> List = this.DBSage.P_CATCOMPTA; System.Reflection.PropertyInfo[] Properties = List.ToList()[0].GetType().GetProperties(); foreach (System.Reflection.PropertyInfo Property in Properties) { if (Property.GetValue(List.ToList()[0], null).ToString() != "" && Property.Name != "cbMarq" && Property.Name.Contains("Ven")) { string Marq = Property.Name.Split(new String[] { "Ven" }, StringSplitOptions.None)[1]; if (Core.Global.IsInteger(Marq)) { Return.Add(new Model.Internal.CategorieComptable() { SageMarq = int.Parse(Marq), Intitule = Property.GetValue(List.ToList()[0], null).ToString(), }); } } } return(Return); }
public List <PsCartRule> List() { System.Linq.IQueryable <PsCartRule> Return = from Table in this.DBPrestashop.PsCartRule select Table; return(Return.ToList()); }
public List <PsManufacturerLang> List() { System.Linq.IQueryable <PsManufacturerLang> Return = from Table in this.DBPrestashop.PsManufacturerLang select Table; return(Return.ToList()); }
public List <PsOrderInvoicePayment> List() { System.Linq.IQueryable <PsOrderInvoicePayment> Return = from Table in this.DBPrestashop.PsOrderInvoicePayment select Table; return(Return.ToList()); }
public async static Task <PagedList <T> > ToPagedList(System.Linq.IQueryable <T> source, int pageNumber, int pageSize) { var count = source.Count(); var items = await Task.FromResult(source.Skip((pageNumber - 1) * pageSize).Take(pageSize).ToList()); return(new PagedList <T>(items, count, pageNumber, pageSize)); }
public List <Address> List() { System.Linq.IQueryable <Address> Return = from Table in this.DBLocal.Address select Table; return(Return.ToList()); }
public static IQueryable <TSource> AddOrderAndPageFilters <TSource>(this System.Linq.IQueryable <TSource> input, FilterModelBase filter) { if (filter != null) { if (filter.OrderBy.Length > 0) { input = input.OrderBy(filter.OrderBy); } else if (filter.OrderByDescending.Length > 0) { input = input.OrderBy(filter.OrderByDescending + " DESC"); } if (filter.Skip > 0 && filter.Take > 0) { return(input .SkipIf(true, filter.Skip) .TakeIf(true, filter.Take)); } return(input .SkipIf(filter.Page > 0, filter.Page * filter.PageLimit) .TakeIf(filter.PageLimit > 0, filter.PageLimit)); } return(input); }