private void gvlHistory_MasterRowGetChildList(object sender, DevExpress.XtraGrid.Views.Grid.MasterRowGetChildListEventArgs e) { GridView view = sender as GridView; MTSymbol c = (MTSymbol)view.GetRow(e.RowHandle); BindingList <MTHistoryM> bindingHistory = new BindingList <MTHistoryM>(c.MTHistoryMS.ToList()); bindingSource.DataSource = bindingHistory; e.ChildList = bindingSource; MTProviderEntities db1 = new MTProviderEntities(); IList <MTHistoryM> mtHistoryMS = db1.MTHistoryMS.Where(a => a.Symbol == c.Name).ToList(); foreach (MTHistoryM mtHistory in mtHistoryMS) { MTHistoryM mtHistoryMSOld = c.MTHistoryMS.Where(a => a.ID == mtHistory.ID).FirstOrDefault(); if (mtHistory.AllTicks != mtHistoryMSOld.AllTicks) { mtHistoryMSOld.AllTicks = mtHistory.AllTicks; } if (mtHistory.MyTicks != mtHistoryMSOld.MyTicks) { mtHistoryMSOld.MyTicks = mtHistory.MyTicks; } } //e.ChildList = bindingHistory; }
private void gvDetailHistory_RowUpdated(object sender, DevExpress.XtraGrid.Views.Base.RowObjectEventArgs e) { GridView view = sender as GridView; if (view.IsNewItemRow(e.RowHandle)) { //view.ValidateEditor(); MTHistoryM c = (MTHistoryM)e.Row; symbol = c.Symbol; db.MTHistoryMS.Add((MTHistoryM)e.Row); //view.CollapseGroupRow(view.SourceRowHandle); } }
private void gvControlHistory_ProcessGridKey(object sender, KeyEventArgs e) { GridControl grid = sender as GridControl; GridView view = grid.FocusedView as GridView; if (view.Name.Equals("gvDetailHistory")) { if (e.KeyData == Keys.Delete) { MTHistoryM historyMS = (MTHistoryM)view.GetRow(view.GetSelectedRows()[0]); IEnumerable <MTHistoryDT> historyDTs = db.MTHistoryDTs.Where(a => a.MSID == historyMS.ID).ToArray(); if (historyDTs.Count() > 0) { db.MTHistoryDTs.RemoveRange(historyDTs); } db.MTHistoryMS.Remove(historyMS); view.DeleteSelectedRows(); e.Handled = true; } } }
private void backgroundWorker1_ProgressChanged(object sender, ProgressChangedEventArgs e) { //GridView gridView = gvControlHistory.ViewCollection[0] as GridView; // selGV.FocusedRowHandle = e.ProgressPercentage; BindingList <MTHistoryM> mtHistoryMSOlds = this.bindingSource.DataSource as BindingList <MTHistoryM>; MTHistoryM mtHistory = e.UserState as MTHistoryM; MTHistoryM mtHistoryMSOld = mtHistoryMSOlds.Where(a => a.ID == mtHistory.ID).FirstOrDefault(); if (mtHistory.AllTicks != mtHistoryMSOld.AllTicks) { mtHistoryMSOld.AllTicks = mtHistory.AllTicks; } if (mtHistory.MyTicks != mtHistoryMSOld.MyTicks) { mtHistoryMSOld.MyTicks = mtHistory.MyTicks; } selGV.SetRowCellValue(e.ProgressPercentage, "coldtLoading", (int.Parse(mtHistory.MyTicks.ToString()) * 100 / int.Parse(mtHistory.AllTicks.ToString()))); //gridView.SetRowCellValue(int.Parse(e.UserState.ToString()), "coldtLoading", e.ProgressPercentage); }
private void backgroundWorker1_DoWork(object sender, DoWorkEventArgs e) { BackgroundWorker worker = sender as BackgroundWorker; MTProviderEntities db1 = new MTProviderEntities(); IList <MTHistoryM> mtHistoryMS = db1.MTHistoryMS /*.Where(a => a.AllTicks != a.MyTicks || a.AllTicks == 0)*/.ToList(); while (mtHistoryMS.Count != 0) { if (worker.CancellationPending == true) { e.Cancel = true; break; } else { // Perform a time consuming operation and report progress. System.Threading.Thread.Sleep(1000); BindingList <MTHistoryM> mtHistoryMSOlds = this.bindingSource.DataSource as BindingList <MTHistoryM>; if (mtHistoryMSOlds != null) { foreach (MTHistoryM mtHistory in mtHistoryMS) { foreach (GridView gridView in gvControlHistory.ViewCollection) { int rowHandle = gridView.LocateByValue("ID", mtHistory.ID); if (rowHandle != DevExpress.XtraGrid.GridControl.InvalidRowHandle) { MTHistoryM mtHistoryMSOld = mtHistoryMSOlds.Where(a => a.ID == mtHistory.ID).FirstOrDefault(); if ((mtHistory.AllTicks != mtHistoryMSOld.AllTicks) || (mtHistory.MyTicks != mtHistoryMSOld.MyTicks)) { worker.ReportProgress(rowHandle, mtHistory); selGV = gridView; } } } //MTHistoryM mtHistoryMSOld = mtHistoryMSOlds.Where(a => a.ID == mtHistory.ID).FirstOrDefault(); ////MTHistoryM mtHistoryMSOld = db.MTHistoryMS.Where(a => a.ID == mtHistory.ID).FirstOrDefault(); //if (mtHistory.AllTicks != mtHistoryMSOld.AllTicks) // mtHistoryMSOlds[0].AllTicks = mtHistory.AllTicks; //if (mtHistory.MyTicks != mtHistoryMSOld.MyTicks) // mtHistoryMSOlds[0].MyTicks = mtHistory.MyTicks; //iterate through each expanded grid //foreach (GridView gridView in gvControlHistory.ViewCollection) //{ // //find row handle within grid that contains the field value you are searching for // //int rowHandle = gridView.LocateByValue("theFieldName", someObjectVal); // int rowHandle = gridView.LocateByValue("ID", mtHistory.ID); // if (rowHandle != DevExpress.XtraGrid.GridControl.InvalidRowHandle) // { // MTHistoryM mtHistoryMSOld = db.MTHistoryMS.Where(a => a.ID == mtHistory.ID).FirstOrDefault(); // if (mtHistory.AllTicks != 0) // gridView.SetRowCellValue(rowHandle, "AllTicks", mtHistory.AllTicks); // if (mtHistory.MyTicks != 0) // { // gridView.SetRowCellValue(rowHandle, "MyTicks", mtHistory.MyTicks); // //mtHistoryMSOld.MyTicks = mtHistory.MyTicks; // } // } //} } } db1 = new MTProviderEntities(); mtHistoryMS = db1.MTHistoryMS /*.Where(a => a.AllTicks != a.MyTicks || a.AllTicks == 0)*/.ToList(); } } }