public override global::System.Data.DataTable Clone() { ResultDataTable cln = ((ResultDataTable)(base.Clone())); cln.InitVars(); return(cln); }
private DataRow AddResultTableRow(WorkItem workItem, Revision workItemRevisions, string changedBy, Field remainingWorkField, Field completedWorkField, double?completedDelta, double?remainingDelta, double?rqEffort, string error, bool isOpenIssue) { DataRow dr = ResultDataTable.NewRow(); dr.ItemArray = new object[] { workItemRevisions == null ? workItem.RevisedDate : workItemRevisions.Fields["Changed Date"].Value, string.IsNullOrEmpty(changedBy) ? workItem.Fields["System.AssignedTo"].Value : changedBy, workItemRevisions == null ? workItem.Id : workItemRevisions.Fields["ID"].Value, workItemRevisions == null ? workItem.Title : workItemRevisions.Fields["Title"].Value, workItem.Type.Name, workItemRevisions == null ? workItem.IterationPath : workItemRevisions.Fields["Iteration Path"].Value, workItemRevisions == null ? string.Empty : workItemRevisions.Fields["Stack Rank"].Value ?? string.Empty, completedWorkField == null ? 0d : completedWorkField.OriginalValue ?? 0d, completedWorkField == null ? 0d : completedWorkField.Value, remainingWorkField == null ? 0d : remainingWorkField.OriginalValue ?? 0d, remainingWorkField == null ? 0d : remainingWorkField.Value ?? 0d, rqEffort == null || isOpenIssue ? 0d : rqEffort.Value, !isOpenIssue || rqEffort == null ? 0d : rqEffort.Value, completedDelta == null ? 0d : completedDelta.Value, remainingDelta == null ? 0d : remainingDelta.Value, (remainingDelta == null || completedDelta == null) ? 0d : (completedDelta.Value + remainingDelta.Value) }; dr.RowError = error; AddRowToTable(dr); return(dr); }
private void updateTable(ProblemResult result) { ResultTabs.Clear(); for (int i = 0; i < result.TableResult.Values.Count; ++i) { ResultDataTable resultDataTable = new ResultDataTable(result.TableResult.Values[i]); DataGrid dataGrid = new DataGrid(); dataGrid.IsReadOnly = true; dataGrid.CanUserSortColumns = false; dataGrid.CanUserAddRows = false; dataGrid.CanUserDeleteRows = false; dataGrid.CanUserResizeRows = false; dataGrid.CanUserResizeColumns = false; dataGrid.SelectionUnit = DataGridSelectionUnit.Cell; dataGrid.ItemsSource = resultDataTable.AsDataView; TabItem tabItem = new TabItem(); tabItem.Header = string.IsNullOrEmpty(result.TableResult.Values[i].Title) ? (i + 1).ToString() : result.TableResult.Values[i].Title; tabItem.Content = dataGrid; ResultTabs.Add(tabItem); } if (ResultTabs.Count > 0) { tcResultsTabs.SelectedIndex = 0; tcResultsTabs.SelectedItem = ResultTabs.First(); ResultTabs.First().IsSelected = true; } }
private void InitClass() { this.DataSetName = "ResultDataSet1"; this.Prefix = ""; this.Namespace = "http://tempuri.org/ResultDataSet1.xsd"; this.EnforceConstraints = true; this.SchemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema; this.tableResult = new ResultDataTable(); base.Tables.Add(this.tableResult); }
internal void InitVars(bool initTable) { this.tableResult = ((ResultDataTable)(base.Tables["Result"])); if ((initTable == true)) { if ((this.tableResult != null)) { this.tableResult.InitVars(); } } }
private void LoadRows([NotNull] ResultDataTable dataTable, [NotNull] XElement element) { Debug.ArgumentNotNull(dataTable, nameof(dataTable)); Debug.ArgumentNotNull(element, nameof(element)); var itemsElement = element.Element(@"rows"); if (itemsElement == null) { return; } if (!itemsElement.Elements().Any()) { var dataRow = (ResultDataRow)dataTable.NewRow(); dataTable.Rows.Add(dataRow); return; } foreach (var item in itemsElement.Elements()) { var fieldArray = new List <FieldUri>(); var columnArray = new List <string>(); var languageName = item.GetAttributeValue("language", LanguageManager.CurrentLanguage.Name) ?? "en"; var itemUri = new ItemUri(DatabaseUri, new ItemId(new Guid(item.GetAttributeValue("id")))); var itemVersionUri = new ItemVersionUri(itemUri, new Language(languageName), Data.Version.Latest); foreach (var field in item.Elements()) { FieldUri fieldUri = null; var id = field.GetAttributeValue("id"); if (!string.IsNullOrEmpty(id)) { fieldUri = new FieldUri(itemVersionUri, new FieldId(new Guid(id))); } fieldArray.Add(fieldUri); columnArray.Add(field.Value); } var dataRow = (ResultDataRow)dataTable.NewRow(); dataRow.Name = item.GetAttributeValue("name"); dataRow.Icon = new Icon(DatabaseUri.Site, item.GetAttributeValue("icon")); dataRow.ItemUri = itemUri; dataRow.FieldArray = fieldArray.ToArray(); dataRow.ItemArray = columnArray.ToArray(); dataTable.Rows.Add(dataRow); } }
private FrameworkElement LoadTable([NotNull] XElement element) { // data table Debug.ArgumentNotNull(element, nameof(element)); var dataTable = new ResultDataTable { TableName = @"Table" }; dataTable.RowChanged += DataTableOnRowChanged; LoadColumns(dataTable, element); LoadRows(dataTable, element); dataTable.AcceptChanges(); DataTables.Add(dataTable); // datagrid var dataGrid = new DataGrid { VerticalAlignment = VerticalAlignment.Stretch, RowHeaderWidth = 0, CanUserReorderColumns = false, CanUserSortColumns = false, CanUserAddRows = false, CanUserDeleteRows = false, Tag = dataTable }; dataGrid.BeginningEdit += OnBeginningEdit; dataGrid.PreviewMouseRightButtonDown += HandleRightMouseDown; DataGrids.Add(dataGrid); dataGrid.ItemsSource = dataTable.DefaultView; return(dataGrid); }
private void LoadColumns([NotNull] ResultDataTable dataTable, [NotNull] XElement element) { Debug.ArgumentNotNull(dataTable, nameof(dataTable)); Debug.ArgumentNotNull(element, nameof(element)); var columnsElement = element.Element(@"columns"); if (columnsElement == null) { return; } foreach (var e in columnsElement.Elements()) { var dataColumn = new DataColumn(e.GetAttributeValue("name"), typeof(string)) { ReadOnly = e.GetAttributeValue("isreadonly") == @"true" }; dataTable.Columns.Add(dataColumn); } }
internal ResultRow(global::System.Data.DataRowBuilder rb) : base(rb) { this.tableResult = ((ResultDataTable)(this.Table)); }
private void InitClass() { this.DataSetName = "DataSet"; this.Prefix = ""; this.EnforceConstraints = true; this.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; this.tableResult = new ResultDataTable(); base.Tables.Add(this.tableResult); }
public async Task <ResultDataTable> Obtener(PedidoDetalleObtenerFiltroDto prm) { ResultDataTable resultado = new ResultDataTable(); long totalRegistros = 0; List <PedidoDetalleObtenerPorIdPedidoDtoApi> lista = new List <PedidoDetalleObtenerPorIdPedidoDtoApi>(); int statusCode = 0; try { try { prm.Length = 100; } catch { } var response = string.Empty; string url = string.Format("{0}{1}/ObtenerPorIdPedido/{2}", ConstanteVo.UrlBaseApi, _nombreControlador, prm.IdPedido); using (var client = new HttpClient()) { if (ConstanteVo.ActivarLLamadasConToken && !string.IsNullOrEmpty(ConfiguracionToken.ConfigToken)) { client.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Bearer", ConfiguracionToken.ConfigToken.Trim()); } HttpResponseMessage result = await client.GetAsync(new Uri(url)); if (result != null) { response = await result.Content.ReadAsStringAsync(); statusCode = (int)result.StatusCode; } } ResponsePedidoDetalleObtenerPorIdPedidoDtoApi root = JsonConvert.DeserializeObject <ResponsePedidoDetalleObtenerPorIdPedidoDtoApi>(response); if (root != null && root.Cuerpo != null) { lista = root.Cuerpo; totalRegistros = root.CantidadTotalRegistros; if (lista.Any()) { int indice = Convert.ToInt32(prm.Start) + 1; foreach (var item in lista) { item.Item = indice; indice++; } } } } catch (Exception ex) { string exMessage = (ex.InnerException == null ? ex.Message : ex.InnerException.Message).Replace(Environment.NewLine, " "); Log(Level.Error, exMessage); resultado.error = exMessage; } finally { resultado.data = lista; resultado.draw = prm.Draw; resultado.recordsTotal = (int)totalRegistros; resultado.recordsFiltered = (int)totalRegistros; if (resultado != null) { resultado.StatusCode = statusCode; } } return(resultado); }
private void InitClass() { this.DataSetName = "DataSet1"; this.Prefix = ""; this.Namespace = "http://tempuri.org/DataSet1.xsd"; this.EnforceConstraints = true; this.SchemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema; this.tableStation_Table = new Station_TableDataTable(); base.Tables.Add(this.tableStation_Table); this.tableGoods_Table = new Goods_TableDataTable(); base.Tables.Add(this.tableGoods_Table); this.tableResult = new ResultDataTable(); base.Tables.Add(this.tableResult); this.tableMyDate = new MyDateDataTable(); base.Tables.Add(this.tableMyDate); this.tableResult_t1 = new Result_t1DataTable(); base.Tables.Add(this.tableResult_t1); this.tableResult_t2 = new Result_t2DataTable(); base.Tables.Add(this.tableResult_t2); this.tableResult_t3 = new Result_t3DataTable(); base.Tables.Add(this.tableResult_t3); this.tableTemp_Result = new Temp_ResultDataTable(); base.Tables.Add(this.tableTemp_Result); this.tableResult_t0 = new Result_t0DataTable(); base.Tables.Add(this.tableResult_t0); this.relationStation_Table_Goods_Table = new global::System.Data.DataRelation("Station_Table_Goods_Table", new global::System.Data.DataColumn[] { this.tableStation_Table.IDColumn}, new global::System.Data.DataColumn[] { this.tableGoods_Table.IDColumn}, false); this.Relations.Add(this.relationStation_Table_Goods_Table); this.relationMyDate_Result = new global::System.Data.DataRelation("MyDate_Result", new global::System.Data.DataColumn[] { this.tableMyDate.DateIDColumn}, new global::System.Data.DataColumn[] { this.tableResult.DateIDColumn}, false); this.Relations.Add(this.relationMyDate_Result); }
internal void InitVars(bool initTable) { this.tableStation_Table = ((Station_TableDataTable)(base.Tables["Station_Table"])); if ((initTable == true)) { if ((this.tableStation_Table != null)) { this.tableStation_Table.InitVars(); } } this.tableGoods_Table = ((Goods_TableDataTable)(base.Tables["Goods_Table"])); if ((initTable == true)) { if ((this.tableGoods_Table != null)) { this.tableGoods_Table.InitVars(); } } this.tableResult = ((ResultDataTable)(base.Tables["Result"])); if ((initTable == true)) { if ((this.tableResult != null)) { this.tableResult.InitVars(); } } this.tableMyDate = ((MyDateDataTable)(base.Tables["MyDate"])); if ((initTable == true)) { if ((this.tableMyDate != null)) { this.tableMyDate.InitVars(); } } this.tableResult_t1 = ((Result_t1DataTable)(base.Tables["Result_t1"])); if ((initTable == true)) { if ((this.tableResult_t1 != null)) { this.tableResult_t1.InitVars(); } } this.tableResult_t2 = ((Result_t2DataTable)(base.Tables["Result_t2"])); if ((initTable == true)) { if ((this.tableResult_t2 != null)) { this.tableResult_t2.InitVars(); } } this.tableResult_t3 = ((Result_t3DataTable)(base.Tables["Result_t3"])); if ((initTable == true)) { if ((this.tableResult_t3 != null)) { this.tableResult_t3.InitVars(); } } this.tableTemp_Result = ((Temp_ResultDataTable)(base.Tables["Temp_Result"])); if ((initTable == true)) { if ((this.tableTemp_Result != null)) { this.tableTemp_Result.InitVars(); } } this.tableResult_t0 = ((Result_t0DataTable)(base.Tables["Result_t0"])); if ((initTable == true)) { if ((this.tableResult_t0 != null)) { this.tableResult_t0.InitVars(); } } this.relationStation_Table_Goods_Table = this.Relations["Station_Table_Goods_Table"]; this.relationMyDate_Result = this.Relations["MyDate_Result"]; }
// TODO: ? public ResultDataTable QueryNew(String search) { // TODO: Umschreiben von ServerPathen auf lokale Pfade List<String> qryResult = QueryRaw(search); ResultDataTable result = new ResultDataTable(); foreach (String srvPath in qryResult) { } return result; }
public async Task <ResultDataTable> Obtener(TipoEstadoObtenerFiltroDto prm) { ResultDataTable resultado = new ResultDataTable(); long totalRegistros = 0; List <TipoEstadoObtenerDtoApi> lista = new List <TipoEstadoObtenerDtoApi>(); int statusCode = 0; try { //Dentro de AJAX => datatype: 'json', headers: {'Authorization': 'Basic ' + valor token }, .... RequestTipoEstadoObtenerDtoApi filtroApi = new RequestTipoEstadoObtenerDtoApi { Buscar = string.IsNullOrEmpty(prm.Buscar) ? string.Empty : prm.Buscar, }; if (prm.Start == null) { prm.Start = 0; } filtroApi.CantidadRegistros = prm.Length == null ? 10 : Convert.ToInt32(prm.Length); filtroApi.NumeroPagina = (Convert.ToInt32(prm.Start) / filtroApi.CantidadRegistros) + 1; if (prm.Order != null && prm.Order.Count > 0) { filtroApi.ColumnaOrden = prm.Columns[prm.Order[0].Column].Name; filtroApi.DireccionOrden = prm.Order[0].Dir; } var response = string.Empty; string url = string.Format("{0}{1}/Obtener", ConstanteVo.UrlBaseApi, _nombreControlador); using (var client = new HttpClient()) { if (ConstanteVo.ActivarLLamadasConToken && !string.IsNullOrEmpty(ConfiguracionToken.ConfigToken)) { client.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Bearer", ConfiguracionToken.ConfigToken.Trim()); } var content = new StringContent(JsonConvert.SerializeObject(filtroApi), Encoding.UTF8, "application/json"); HttpResponseMessage result = await client.PostAsync(new Uri(url), content); if (result != null) { response = await result.Content.ReadAsStringAsync(); statusCode = (int)result.StatusCode; } } ResponseTipoEstadoObtenerDtoApi root = JsonConvert.DeserializeObject <ResponseTipoEstadoObtenerDtoApi>(response); if (root != null && root.Cuerpo != null) { lista = root.Cuerpo; totalRegistros = root.CantidadTotalRegistros; if (lista.Any()) { int indice = Convert.ToInt32(prm.Start) + 1; foreach (var item in lista) { item.Item = indice; indice++; } } } } catch (Exception ex) { string exMessage = (ex.InnerException == null ? ex.Message : ex.InnerException.Message).Replace(Environment.NewLine, " "); Log(Level.Error, exMessage); resultado.error = exMessage; } finally { resultado.data = lista; resultado.draw = prm.Draw; resultado.recordsTotal = (int)totalRegistros; resultado.recordsFiltered = (int)totalRegistros; if (resultado != null) { resultado.StatusCode = statusCode; } } return(resultado); }