public RowEnumerableDataReader (IEnumerable source, int depth) { this.source = source as EnumerableRowCollection; if (this.source == null) this.source = new EnumerableRowCollection<DataRow> ((IEnumerable<DataRow>) source); this.depth = depth; }
private void button1_Click(object sender, EventArgs e) { if (listBox1.Items.Count == 0) { MessageBox.Show("Add filter(s) first!"); return; } var dt = m_mainForm.DataTable; if (m_filter == null) m_filter = dt.AsEnumerable(); if (!checkBox1.Checked) m_filter = dt.AsEnumerable(); var temp = m_filter.AsParallel().AsOrdered().Where(Compare); if (temp.Count() != 0) m_filter = temp.CopyToDataTable().AsEnumerable(); else m_filter = new DataTable().AsEnumerable(); m_mainForm.SetDataSource(m_filter.AsDataView()); }
public ProdSeason(int? _prod_season_no, string _prod_desc, short? _season_no, string _season_desc, string _language, string _composer, string _author, DateTime? _first_dt, DateTime? _last_dt, string _synop, short? _premiere_id, string _premiere_desc, string _perf_no, bool? _on_sale_ind, EnumerableRowCollection<DataRow> enumCredits, EnumerableRowCollection<DataRow> enumKeywords) { Id = _prod_season_no; Name = _prod_desc; SeasonId = _season_no; SeasonName = _season_desc; Language = _language; Composer = _composer; Author = _author; FirstDate = _first_dt; LastDate = _last_dt; Synopsis = _synop; PremiereId = _premiere_id; PremiereName = _premiere_desc; PerfId = _perf_no; IsOnSale = _on_sale_ind; Credits = new CreditCollection(enumCredits, "prod_season_no", Id); KeywordCategories = new ProdSeasonKeywordCatCollection(enumKeywords, Id); }
private void button1_Click(object sender, EventArgs e) { if (listBox1.Items.Count == 0) { MessageBox.Show("Add filter(s) first!"); return; } //Stopwatch sw = Stopwatch.StartNew(); var owner = ((MainForm)Owner); var dt = owner.DataTable; if (_filter == null) _filter = dt.AsEnumerable(); if (!checkBox1.Checked) _filter = dt.AsEnumerable(); var temp = _filter.AsParallel().AsOrdered().Where(Compare); if (temp.Count() != 0) _filter = temp.CopyToDataTable().AsEnumerable(); else _filter = new DataTable().AsEnumerable(); //_filter = _filter.Where(Compare); owner.SetDataSource(_filter.AsDataView()); //sw.Stop(); //MessageBox.Show(sw.Elapsed.TotalMilliseconds.ToString()); }
public ProdSeasonKeywordCategory(EnumerableRowCollection<DataRow> tessResults, string catName, int? prodSeasonId) { Keywords = (from k in tessResults where k.Field<string>("category") == catName && k.Field<int?>("prod_season_no") == prodSeasonId select k.Field<string>("keyword")) .ToList<string>(); Name = catName; }
private static void _LoadCategoriesView(TreeNode targetNode, EnumerableRowCollection<PosData.CategoriesRow> current, PosData.CategoriesDataTable source) { foreach (PosData.CategoriesRow row in current) { var newNode = from c in source where c.ParentId == row.CategoryId && c.ParentId != 0L select c; if (newNode != null && newNode.Count<PosData.CategoriesRow>() > 0) { _LoadCategoriesView(targetNode, newNode, source); } //root nodes TreeNode currentNode = new TreeNode(row.CategoryName, 0, 0); currentNode.Tag = row.CategoryId; targetNode.Nodes.Add(currentNode); } }
/// <summary> /// Exports the specified impacts to Excel worksheet. /// </summary> /// <param name="impacts">The impacts.</param> public void Export(EnumerableRowCollection<DataLogModel.ImpactsRow> impacts) { Workbook workbook = new Workbook(); workbook.Properties.Title = "LaJust Sports Export"; workbook.Properties.Created = DateTime.Now; Worksheet impactSheet = workbook.Worksheets.Add("Impacts"); WorksheetRow row = impactSheet.Table.Rows.Add(); row.Cells.Add(new WorksheetCell("Sequence", DataType.String)); row.Cells.Add(new WorksheetCell("Time", DataType.String)); row.Cells.Add(new WorksheetCell("Device ID", DataType.String)); row.Cells.Add(new WorksheetCell("Game Number", DataType.String)); row.Cells.Add(new WorksheetCell("Round Number", DataType.String)); row.Cells.Add(new WorksheetCell("Seconds", DataType.String)); row.Cells.Add(new WorksheetCell("Competitor", DataType.String)); row.Cells.Add(new WorksheetCell("Data Source", DataType.String)); row.Cells.Add(new WorksheetCell("Required Impact", DataType.String)); row.Cells.Add(new WorksheetCell("Actual Impact", DataType.String)); row.Cells.Add(new WorksheetCell("Panel", DataType.String)); foreach (var impactRow in impacts) { row = impactSheet.Table.Rows.Add(); row.Cells.Add(new WorksheetCell(impactRow.ID.ToString(), DataType.Number)); row.Cells.Add(new WorksheetCell(impactRow.Timestamp.ToString("G"), DataType.String)); row.Cells.Add(new WorksheetCell(impactRow.SensorId.ToString(), DataType.String)); row.Cells.Add(new WorksheetCell(impactRow.GameNumber.ToString(), DataType.Number)); row.Cells.Add(new WorksheetCell(impactRow.RoundNumber.ToString(), DataType.Number)); row.Cells.Add(new WorksheetCell(impactRow.ElapsedTime.TotalSeconds.ToString(), DataType.Number)); row.Cells.Add(new WorksheetCell(impactRow.Name.ToString(), DataType.String)); row.Cells.Add(new WorksheetCell(impactRow.DataSource.ToString(), DataType.String)); row.Cells.Add(new WorksheetCell(impactRow.RequiredLevel.ToString(), DataType.Number)); row.Cells.Add(new WorksheetCell(impactRow.ImpactLevel.ToString(), DataType.Number)); row.Cells.Add(new WorksheetCell(impactRow.SensorPanel.ToString(), DataType.String)); } string filename = string.Format("{0} {1} G{2:D3}-{3}R.xls", impacts.First().Timestamp.ToString("yyyy-MM-dd"), impacts.First().Name.Trim(), impacts.First().GameNumber, impacts.First().RoundNumber); workbook.Save(Path.Combine(GetDataDirectory(), filename)); }
private void Filter() { if (m_filters.Count == 0) { MessageBox.Show("Add filter(s) first!"); return; } var owner = ((MainForm)Owner); var dt = owner.DataTable; if (m_filter == null) m_filter = dt.AsEnumerable(); if (!checkBox1.Checked) m_filter = dt.AsEnumerable(); m_filter = m_filter.Where(Compare); owner.SetDataSource(m_filter.AsDataView()); }
private void button1_Click(object sender, EventArgs e) { if (m_filters.Count == 0) { MessageBox.Show("Add filter(s) first!"); return; } var owner = ((MainForm)Owner); var dt = owner.DataTable; if (m_filter == null) m_filter = dt.AsEnumerable(); if (!checkBox1.Checked) m_filter = dt.AsEnumerable(); if (FilterTable(dt)) owner.SetDataSource(m_filter.AsDataView()); else MessageBox.Show("Unhandled type?"); }
public void ReadData() { var file = @"C:\Users\u0158158\Documents\VS\Tennis\2012TennisOdds.xlsx"; var connectionString = string.Format("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=\"{0}\"; Extended Properties=\"Excel 12.0; IMEX=1; HDR=YES\";", file); var adapter = new OleDbDataAdapter("SELECT * FROM [TennisOdds$]", connectionString); using (var ds = new DataSet()) { adapter.Fill(ds, "TennisOdds"); this.excelMatches = ds.Tables["TennisOdds"].AsEnumerable(); } foreach (var match in this.excelMatches) { var predictionURL = new Uri(match.Field<string>("URL").Replace(".", "").Replace("’", "").Replace("'", "").Replace("&", "").Replace(",", "").RemoveDiacritics()); var jsonTennisPrediction = (APITennisPrediction)this.webRepository.ParseJson<APITennisPrediction>( predictionURL, s => ProgressReporterProvider.Current.ReportProgress(s, Model.ReporterImportance.Low, Model.ReporterAudience.Admin)); var genericPrediction = TennisPredictionStrategy.ConvertAPIToGeneric(jsonTennisPrediction, predictionURL); genericPrediction.MatchDate = match.Field<DateTime>("DateToTake").Date; if (!this.predictions.ContainsKey(match.Field<string>("URL"))) this.predictions.Add(match.Field<string>("URL"), genericPrediction); } }
private void ReadFixtureData() { var fileName = string.Format(@"C:\Users\u0158158\Documents\VS\Football\2011 12 season.xlsx"); var connectionString = string.Format("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=\"{0}\"; Extended Properties=\"Excel 12.0; HDR=YES\"", fileName); var adapter = new OleDbDataAdapter("SELECT * FROM [Fixtures$]", connectionString); using (var ds = new DataSet()) { adapter.Fill(ds, "Fixtures"); FixturesCouponsOdds = ds.Tables["Fixtures"].AsEnumerable(); } }
public static OrderedEnumerableRowCollection <TRow> OrderByDescending <TRow, TKey> (this EnumerableRowCollection <TRow> source, Func <TRow, TKey> keySelector) { return(OrderByDescending <TRow, TKey> (source, keySelector, Comparer <TKey> .Default)); }
/// <summary> /// Called when [impact data changed]. /// </summary> /// <param name="e">The e.</param> private void OnImpactDataChanged(SelectedDataChangedEvent e) { _exportComplete = false; _exportCommand.RaiseCanExecuteChanged(); if (e.ImpactData.Count() < 1) { Title = string.Empty; MeterImpacts = null; } else { Title = string.Format("{0} ({1} Game {2:D3} {3}R Score {4})", e.ImpactData.First().Name, e.ImpactData.First().Timestamp.ToShortDateString(), e.ImpactData.First().GameNumber, e.ImpactData.First().RoundNumber, (e.ScoreData.Count() > 0 ? e.ScoreData.Last().NewScore : 0) ); MeterImpacts = e.ImpactData; } }
public static OrderedEnumerableRowCollection <TRow> OrderByDescending <TRow, TKey> (this EnumerableRowCollection <TRow> source, Func <TRow, TKey> keySelector, IComparer <TKey> comparer) { return(OrderedEnumerableRowCollection <TRow> .Create <TRow, TKey> (source, keySelector, comparer, true)); }
public static EnumerableRowCollection <S> Select <TRow, S> (this EnumerableRowCollection <TRow> source, Func <TRow, S> selector) { return(new EnumerableRowCollection <S> (Enumerable.Select <TRow, S> (source, selector))); }
public static EnumerableRowCollection <TRow> Where <TRow> (this EnumerableRowCollection <TRow> source, Func <TRow, bool> predicate) { return(new EnumerableRowCollection <TRow> (Enumerable.Where <TRow> (source, predicate))); }
public void AddColumn(string name, string dataType) { if (name == null) throw new ArgumentNullException("name"); if (dataType == null) throw new ArgumentNullException("dataType"); if (_rows == null) { using (var adapter = new SQLiteDataAdapter("PRAGMA table_info(WuHistory);", _connection)) using (var table = new DataTable()) { adapter.Fill(table); _rows = table.AsEnumerable(); } } bool columnExists = _rows.Any(row => row.Field<string>(1) == name); if (!columnExists) { _commands.Add(new SQLiteCommand(_connection) { CommandText = String.Format(CultureInfo.InvariantCulture, "ALTER TABLE [{0}] ADD COLUMN [{1}] {2} DEFAULT {3} NOT NULL", _tableName, name, dataType, GetDefaultValue(dataType)) }); } }
void sqlInstancesWorker_RunWorkerCompleted(object sender, RunWorkerCompletedEventArgs e) { datasource = e.Result as EnumerableRowCollection<DataRow>; if (datasource != null) { var uniqueSources = (from row in datasource where !string.IsNullOrEmpty(row[1].ToString()) select row[0]).Distinct(); if (uniqueSources != null) foreach (var item in uniqueSources) { sqlInstaces.Add(item.ToString()); } } }
private XmlNode AddIndustryJobsToXML(XmlDocument xml, EnumerableRowCollection<EMMADataSet.IndustryJobsRow> industryJobs) { XmlNode rowSet = NewIndustryJobRowset(xml); foreach (EveMarketMonitorApp.DatabaseClasses.EMMADataSet.IndustryJobsRow job in industryJobs) { XmlNode node = AddIndustryJobRow(xml, job); rowSet.AppendChild(node); } return rowSet; }
/// <summary> /// LINQ's OrderByDescending operator for generic EnumerableRowCollection. /// </summary> public static OrderedEnumerableRowCollection <TRow> OrderByDescending <TRow, TKey>(this EnumerableRowCollection <TRow> source, Func <TRow, TKey> keySelector, IComparer <TKey> comparer) { IEnumerable <TRow> ie = Enumerable.OrderByDescending(source, keySelector, comparer); OrderedEnumerableRowCollection <TRow> edt = new OrderedEnumerableRowCollection <TRow>(source, ie); edt.AddSortExpression(keySelector, comparer, isDescending: true, isOrderBy: true); return(edt); }
public static EnumerableRowCollection <TResult> Cast <TResult> (this EnumerableRowCollection source) { return(new EnumerableRowCollection <TResult> (Enumerable.Cast <TResult> (source))); }
/// <summary> /// Casts an EnumerableDataTable_TSource into EnumerableDataTable_TResult /// </summary> public EnumerableRowCollection <TResult> Cast <TResult>() { EnumerableRowCollection <T> erc = new EnumerableRowCollection <T>(this); return(erc.Cast <TResult>()); }
private void cbosubListofstock_SelectedValueChanged(object sender, EventArgs e) { if (chksubListofstock.Checked == true) { LRestoreCost.Clear();//เคลียค่าใน listview = null if (cbosubListofstock.SelectedValue != null) { Thread progressThread = new Thread(delegate() { ProgressForm progress = new ProgressForm(); progress.ShowDialog(); }); progressThread.Start(); sb = new StringBuilder(); string SubCateId = cbosubListofstock.SelectedValue.ToString(); sb.Remove(0, sb.Length); sb.Append("SELECT PRODUCT.ProductId,PRODUCT.ProductName "); sb.Append("FROM PRODUCT LEFT OUTER JOIN "); sb.Append("SALEBACK_DETAIL ON "); sb.Append("PRODUCT.ProductId = SALEBACK_DETAIL.ProductId LEFT OUTER JOIN "); sb.Append("SALE_DETAIL ON "); sb.Append("PRODUCT.ProductId = SALE_DETAIL.ProductId LEFT OUTER JOIN "); sb.Append("ProductionDraw_Detail ON "); sb.Append("PRODUCT.ProductId = ProductionDraw_Detail.ProductId LEFT OUTER JOIN "); sb.Append("DRAW_PRODUCTION_DETAIL ON "); sb.Append("PRODUCT.ProductId = DRAW_PRODUCTION_DETAIL.ProductId LEFT OUTER JOIN "); sb.Append("DETAIL_DRAW_STOCK ON "); sb.Append("PRODUCT.ProductId = DETAIL_DRAW_STOCK.ProductId LEFT OUTER JOIN "); sb.Append("RETURN_OUTSIDE_STOCK_DETAIL ON "); sb.Append("PRODUCT.ProductId = RETURN_OUTSIDE_STOCK_DETAIL.ProductId LEFT OUTER JOIN "); sb.Append("SALERETURN_DETAIL ON "); sb.Append("PRODUCT.ProductId = SALERETURN_DETAIL.ProductId LEFT OUTER JOIN "); sb.Append("RETURN_PRODUCT_DETAIL ON "); sb.Append("PRODUCT.ProductId = RETURN_PRODUCT_DETAIL.ProductId LEFT OUTER JOIN "); sb.Append("RECEIVENET_DETAIL ON "); sb.Append("PRODUCT.ProductId = RECEIVENET_DETAIL.ProductId LEFT OUTER JOIN "); sb.Append("RECEIVE_UP_DETAIL ON "); sb.Append("PRODUCT.ProductId = RECEIVE_UP_DETAIL.ProductId LEFT OUTER JOIN "); sb.Append("RECEIVE_DETAIL ON "); sb.Append("PRODUCT.ProductId = RECEIVE_DETAIL.ProductId LEFT OUTER JOIN "); sb.Append("DETAIL_RECEIVE_STOCK ON "); sb.Append("PRODUCT.ProductId = DETAIL_RECEIVE_STOCK.ProductId LEFT OUTER JOIN "); sb.Append("ADJUST ON "); sb.Append("PRODUCT.ProductId = ADJUST.ProductId INNER JOIN "); sb.Append("MAINCATE ON "); sb.Append("PRODUCT.MainCateId = MAINCATE.MainCateId INNER JOIN "); sb.Append("SUBCATE ON "); sb.Append("SUBCATE.MainCateId = MAINCATE.MainCateId "); sb.Append(" WHERE "); sb.Append(" PRODUCT.SubCateId = \'"); sb.Append(SubCateId); sb.Append("\' and (PRODUCT.Status IS NULL) "); sb.Append(" GROUP BY PRODUCT.ProductId, PRODUCT.Status,PRODUCT.ProductName "); string sqlPallet = sb.ToString(); com = new SqlCommand(); com.Parameters.Clear(); com.CommandText = sqlPallet; com.CommandType = CommandType.Text; com.Connection = Conn; dr = com.ExecuteReader(); if (dr.HasRows) { dtCheck = new DataTable(); dtCheck.Load(dr); CheckResult = dtCheck.Rows.Count; erc = dtCheck.AsEnumerable(); dtcheck1 = new DataTable(); dtcheck1.Columns.Add(new DataColumn("รหัสสินค้า")); dtcheck1.Columns.Add(new DataColumn("ชื่อสินค้า")); dtcheck1.Columns.Add(new DataColumn("คงเหลือ ณ วันที่กำหนด")); dtcheck1.Columns.Add(new DataColumn("คงเหลือ ณ วันที่ปรับสต็อก")); dtcheck1.Columns.Add(new DataColumn("สินค้าขาเข้า")); dtcheck1.Columns.Add(new DataColumn("สินค้าขาออก")); dtcheck1.Columns.Add(new DataColumn("คงเหลือ")); dtcheck1.Columns.Add(new DataColumn("ปรับยอด")); foreach (DataRow row in erc)// วนค่าจาก Datatable มาเก็บไว้ใน list { float Total = 0; RestoreCost cp = new RestoreCost(); cp.ProductId = row["ProductId"].ToString().Trim();//รหัสวัตถุดิบ strProductId = row["ProductId"].ToString().Trim();//รหัสวัตถุดิบ cp.ProductName = row["ProductName"].ToString().Trim();//รหัสวัตถุดิบ ArrayFixStock();//จำนวนสต็อก ณ วันที่กำหนด cp.QSumStockFix = QSumStockFix.ToString("#,##0.00"); ArrayStockAdj();//จำนวนสต็อก ณ วันที่ปรับยอด cp.QSumStockAdj = QSumStockAdj.ToString("#,##0.00"); ArrayStockReceive();//จำนวนการรับสินค้าทั้วหมดระหว่างวันที่ที่กำหนด cp.QSumStockRec = QSumStockRec.ToString("#,##0.00"); ArrayStockExport();//จำนวนสินค้าออกทั้งหมดระหว่างวันที่ที่กำหนด cp.QSumStockExp = QSumStockExp.ToString("#,##0.00"); ArrAdjFix(); cp.QSumStockExp = QSumStockExp.ToString("#,##0.00"); if (QSumStockAdj < 0) { QSumStockAdj = QSumStockAdj * (-1); } Total = ((QSumStockAdj - QSumStockRec) + QSumStockExp); cp.total = Total.ToString("#,##0.00"); //จำนวนสต็อก ณ วันที่ย้อนหลัง cp.AdjFix = AdjFix.ToString("#,##0.00"); LRestoreCost.Add(cp); DataRow dtr = dtcheck1.NewRow(); dtr["รหัสสินค้า"] = cp.ProductId; dtr["ชื่อสินค้า"] = cp.ProductName; dtr["คงเหลือ ณ วันที่กำหนด"] = cp.QSumStockFix; dtr["คงเหลือ ณ วันที่ปรับสต็อก"] = cp.QSumStockAdj; dtr["สินค้าขาเข้า"] = cp.QSumStockRec; dtr["สินค้าขาออก"] = cp.QSumStockExp; dtr["คงเหลือ"] = cp.total; dtr["ปรับยอด"] = cp.AdjFix; dtcheck1.Rows.Add(dtr); } dgvDetailCheck.DataSource = null; dgvDetailCheck.DataSource = LRestoreCost;//แสดงค่าใน Datagridview ด้วย list SetDgvDetailCheckHeader();//แสดงรายการ Column รายละเอียดของอวนทั่ไป } dr.Close(); lblCheckDaily.Text = "พบ : " + CheckResult.ToString() + " รายการ"; progressThread.Abort(); } } }
/// <summary> /// Creates a LinqDataView from EnumerableDataTable /// </summary> /// <typeparam name="T">Type of the row in the table. Must inherit from DataRow</typeparam> /// <param name="source">The enumerable-datatable over which view must be created.</param> /// <returns>Generated LinkDataView of type T</returns> public static DataView AsDataView <T>(this EnumerableRowCollection <T> source) where T : DataRow { throw new PlatformNotSupportedException(); }
/// <summary> /// Copy Constructor that sets enumerableRows to the one given in the input /// </summary> internal OrderedEnumerableRowCollection(EnumerableRowCollection <TRow> enumerableTable, IEnumerable <TRow> enumerableRows) : base(enumerableTable, enumerableRows, null) { }
public static DataView AsDataView <T> (this EnumerableRowCollection <T> source) where T : DataRow { return(CopyToDataTable <T> (source).DefaultView); }
/// <summary> /// Creates a LinqDataView from EnumerableDataTable /// </summary> /// <typeparam name="T">Type of the row in the table. Must inherit from DataRow</typeparam> /// <param name="source">The enumerable-datatable over which view must be created.</param> /// <returns>Generated LinkDataView of type T</returns> public static DataView AsDataView <T>(this EnumerableRowCollection <T> source) where T : DataRow { DataSetUtil.CheckArgumentNull <EnumerableRowCollection <T> >(source, nameof(source)); return(source.GetLinqDataView()); }