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());
}
