public DataTableResponseBase <Item> CardapioMesaDataTable(DataTableBase <Item> dataTableBase, Guid FkEmpresa, EnumTipoItem tipo) { var query = _context.Set <Item>() .Where(x => x.Empresa.Id == FkEmpresa).AsQueryable(); if (dataTableBase.Filter != null && dataTableBase.Filter != string.Empty) { query = query.Where(e => e.Nome.Contains(dataTableBase.Filter) || e.Descricao.Contains(dataTableBase.Filter)); } if (tipo.IsEnumValid()) { query = query.Where(x => x.Tipo == tipo); } //if (tipo.IsEnumValid()) // query = query.Where(x => x.Tipo == tipo); int count = query.Count(); query = query.OrderBy(x => x.Nome); query = query.Skip(dataTableBase.PageNumber * dataTableBase.PageView).Take(dataTableBase.PageView); DataTableResponseBase <Item> resp = new DataTableResponseBase <Item>(count, dataTableBase.PageView, dataTableBase.PageNumber, query.ToList()); return(resp); }
public static void LoadDataTable(this DataTableComponent dataTableComponent, string dataTableName, string dataTableAssetName, object userData) { if (string.IsNullOrEmpty(dataTableName)) { Log.Warning("Data table name is invalid."); return; } string[] splitedNames = dataTableName.Split('_'); if (splitedNames.Length > 2) { Log.Warning("Data table name is invalid."); return; } string dataRowClassName = DataRowClassPrefixName + splitedNames[0]; Type dataRowType = Type.GetType(dataRowClassName); if (dataRowType == null) { Log.Warning("Can not get data row type with class name '{0}'.", dataRowClassName); return; } string name = splitedNames.Length > 1 ? splitedNames[1] : null; DataTableBase dataTable = dataTableComponent.CreateDataTable(dataRowType, name); dataTable.ReadData(dataTableAssetName, Constant.AssetPriority.DataTableAsset, userData); }
/// <summary> /// 解析数据表。 /// </summary> /// <param name="dataTable">数据表。</param> /// <param name="dataTableString">要解析的数据表字符串。</param> /// <param name="userData">用户自定义数据。</param> /// <returns>是否解析数据表成功。</returns> public override bool ParseData(DataTableBase dataTable, string dataTableString, object userData) { try { int position = 0; string dataRowString = null; while ((dataRowString = dataTableString.ReadLine(ref position)) != null) { if (dataRowString[0] == '#') { continue; } if (!dataTable.AddDataRow(dataRowString, userData)) { Log.Warning("Can not parse data row string '{0}'.", dataRowString); return(false); } } return(true); } catch (Exception exception) { Log.Warning("Can not parse data table string with exception '{0}'.", exception.ToString()); return(false); } }
/// <summary> /// 解析数据表。 /// </summary> /// <param name="dataTable">数据表。</param> /// <param name="dataTableBytes">要解析的数据表二进制流。</param> /// <param name="startIndex">数据表二进制流的起始位置。</param> /// <param name="length">数据表二进制流的长度。</param> /// <param name="userData">用户自定义数据。</param> /// <returns>是否解析数据表成功。</returns> public override bool ParseData(DataTableBase dataTable, byte[] dataTableBytes, int startIndex, int length, object userData) { try { using (MemoryStream memoryStream = new MemoryStream(dataTableBytes, startIndex, length, false)) { using (BinaryReader binaryReader = new BinaryReader(memoryStream, Encoding.UTF8)) { while (binaryReader.BaseStream.Position < binaryReader.BaseStream.Length) { int dataRowBytesLength = binaryReader.Read7BitEncodedInt32(); if (!dataTable.AddDataRow(dataTableBytes, (int)binaryReader.BaseStream.Position, dataRowBytesLength, userData)) { Log.Warning("Can not parse data row bytes."); return(false); } binaryReader.BaseStream.Position += dataRowBytesLength; } } } return(true); } catch (Exception exception) { Log.Warning("Can not parse dictionary bytes with exception '{0}'.", exception.ToString()); return(false); } }
/// <summary> /// 读取数据表。 /// </summary> /// <param name="dataTable">数据表。</param> /// <param name="dataTableAssetName">数据表资源名称。</param> /// <param name="dataTableBytes">数据表二进制流。</param> /// <param name="startIndex">数据表二进制流的起始位置。</param> /// <param name="length">数据表二进制流的长度。</param> /// <param name="userData">用户自定义数据。</param> /// <returns>是否读取数据表成功。</returns> public override bool ReadData(DataTableBase dataTable, string dataTableAssetName, byte[] dataTableBytes, int startIndex, int length, object userData) { if (dataTableAssetName.EndsWith(BytesAssetExtension, StringComparison.Ordinal)) { return(dataTable.ParseData(dataTableBytes, startIndex, length, userData)); } else { return(dataTable.ParseData(Utility.Converter.GetString(dataTableBytes, startIndex, length), userData)); } }
public DataTableResponseBase <Avaliacao> AvaliacoesEmpresaDataTable(DataTableBase <Avaliacao> dataTableBase, Guid FkEmpresa) { { var query = _context.Set <Avaliacao>() .Include(x => x.Usuario) .Where(x => x.Empresa.Id == FkEmpresa).AsQueryable(); int count = query.Count(); query = query.OrderBy(x => x.DataCriacao); query = query.Skip(dataTableBase.PageNumber * dataTableBase.PageView).Take(dataTableBase.PageView); DataTableResponseBase <Avaliacao> resp = new DataTableResponseBase <Avaliacao>(count, dataTableBase.PageView, dataTableBase.PageNumber, query.ToList()); return(resp); } }
/// <summary> /// 读取数据表。 /// </summary> /// <param name="dataTable">数据表。</param> /// <param name="dataTableAssetName">数据表资源名称。</param> /// <param name="dataTableAsset">数据表资源。</param> /// <param name="userData">用户自定义数据。</param> /// <returns>是否读取数据表成功。</returns> public override bool ReadData(DataTableBase dataTable, string dataTableAssetName, object dataTableAsset, object userData) { TextAsset dataTableTextAsset = dataTableAsset as TextAsset; if (dataTableTextAsset != null) { if (dataTableAssetName.EndsWith(BytesAssetExtension, StringComparison.Ordinal)) { return(dataTable.ParseData(dataTableTextAsset.bytes, userData)); } else { return(dataTable.ParseData(dataTableTextAsset.text, userData)); } } Log.Warning("Data table asset '{0}' is invalid.", dataTableAssetName); return(false); }
/// <summary> /// 创建数据表。 /// </summary> /// <param name="dataRowType">数据表行的类型。</param> /// <param name="name">数据表名称。</param> /// <returns>要创建的数据表。</returns> public DataTableBase CreateDataTable(Type dataRowType, string name) { DataTableBase dataTable = m_DataTableManager.CreateDataTable(dataRowType, name); dataTable.ReadDataSuccess += OnReadDataSuccess; dataTable.ReadDataFailure += OnReadDataFailure; if (m_EnableLoadDataTableUpdateEvent) { dataTable.ReadDataUpdate += OnReadDataUpdate; } if (m_EnableLoadDataTableDependencyAssetEvent) { dataTable.ReadDataDependencyAsset += OnReadDataDependencyAsset; } return(dataTable); }
/// <summary> /// 创建数据表。 /// </summary> /// <typeparam name="T">数据表行的类型。</typeparam> /// <param name="name">数据表名称。</param> /// <returns>要创建的数据表。</returns> public IDataTable <T> CreateDataTable <T>(string name) where T : class, IDataRow, new() { IDataTable <T> dataTable = m_DataTableManager.CreateDataTable <T>(name); DataTableBase dataTableBase = (DataTableBase)dataTable; dataTableBase.ReadDataSuccess += OnReadDataSuccess; dataTableBase.ReadDataFailure += OnReadDataFailure; if (m_EnableLoadDataTableUpdateEvent) { dataTableBase.ReadDataUpdate += OnReadDataUpdate; } if (m_EnableLoadDataTableDependencyAssetEvent) { dataTableBase.ReadDataDependencyAsset += OnReadDataDependencyAsset; } return(dataTable); }
protected void ApplyFilter(object value, DataTableBase <WorkitemInformationViewModel> dt) { if (value == null || string.IsNullOrEmpty(value.ToString())) { // TODO: Reset filter? dt.Filter(null); } else { var isGuid = Guid.TryParse(value.ToString(), out var id); if (isGuid) { var members = Settings.SubTeams.SingleOrDefault(s => s.Id == id)?.Members; dt.Filter(i => members != null && members.Any(m => string.Equals(i.AssignedTo.Email, m))); } else { dt.Filter(i => string.Equals(i.AssignedTo.Email, value)); } } }
public DataTableResponseBase <Empresa> EmpresasDataTable(DataTableBase <Empresa> dataTableBase, EnumCategoria categoria) { var query = _context.Set <Empresa>() .Include(x => x.Mesas) .Where(x => x.Ativo == true).AsQueryable(); if (dataTableBase.Filter != null && dataTableBase.Filter != string.Empty) { query = query.Where(e => e.Fantasia.Contains(dataTableBase.Filter) || e.RazaoSocial.Contains(dataTableBase.Filter)); } if (categoria.IsEnumValid()) { query = query.Where(x => x.Categoria == categoria); } int count = query.Count(); query = query.OrderBy(x => x.DataCadastro); query = query.Skip(dataTableBase.PageNumber * dataTableBase.PageView).Take(dataTableBase.PageView); DataTableResponseBase <Empresa> resp = new DataTableResponseBase <Empresa>(count, dataTableBase.PageView, dataTableBase.PageNumber, query.ToList()); return(resp); }
private void DrawDataTable(DataTableBase dataTable) { EditorGUILayout.LabelField(Utility.Text.GetFullName(dataTable.Type, dataTable.Name), string.Format("{0} Rows", dataTable.Count.ToString())); }
/// <summary> /// 释放数据表资源。 /// </summary> /// <param name="dataTable">数据表。</param> /// <param name="dataTableAsset">要释放的数据表资源。</param> public override void ReleaseDataAsset(DataTableBase dataTable, object dataTableAsset) { m_ResourceComponent.UnloadAsset(dataTableAsset); }
/// <summary> /// 销毁数据表。 /// </summary> /// <param name="dataTable">要销毁的数据表。</param> /// <returns>是否销毁数据表成功。</returns> public bool DestroyDataTable(DataTableBase dataTable) { return(m_DataTableManager.DestroyDataTable(dataTable)); }
private void DrawDataTable(DataTableBase dataTable) { EditorGUILayout.LabelField(dataTable.FullName, Utility.Text.Format("{0} Rows", dataTable.Count.ToString())); }