private void repositoryItemButtonEdit2_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e) { DataRow DR = gridView1.GetDataRow(gridView1.FocusedRowHandle); Program.gdvid = DR["PN"].ToString(); QueryFrom qf = new QueryFrom(); qf.Show(); }
private Product LoadProductWithId(ITransaction transaction, int id) { var query = new SelectionQuery() .From(QueryFrom.EntityType(typeof(Product))) .Where(QueryCondition.Expression(ConditionExpr.Build().Field(typeof(Product), "ProductId").Eq().Value(id))) .Select(QuerySelection.EntityType(typeof(Product))).ToList(transaction); return(query.First() as Product); }
private void pb_query_Click(object sender, EventArgs e) { if (global.power != "999") { MessageBox.Show("权限不够"); return; } QueryFrom qf = new QueryFrom(); qf.ShowDialog(); }
/// <summary> /// Makes sure the <see cref="columnNames"/> list is created correctly. /// </summary> private void EnsureColumnNames() { if (columnNames == null) { columnNames = QueryFrom.GetResolvedColumns(); // Are the variables aliased to a table name? if (AliasName != null) { for (int i = 0; i < columnNames.Length; ++i) { columnNames[i] = new ObjectName(AliasName, columnNames[i].Name); } } } }
public SimpleEntity RetrieveWithQuery(ITransaction tx) { ISelectionQuery query = new SelectionQuery() .From(QueryFrom.EntityType(typeof(SimpleEntity))) .Select(QuerySelection.EntityType(typeof(SimpleEntity))); var result = query.ToList(tx).FirstOrDefault(); if (result == null) { return(null); } var retrieved = (SimpleEntity)result; return(retrieved); }
private IList <IEntity> QueryTest(IList <IEntity> items) { var newList = new List <IEntity>(); var sw = new Stopwatch(); sw.Start(); var tx = transactionFactory.CreateTransaction(); for (int i = 0; i < items.Count; i++) { var item = items[i]; var itemType = item.GetType(); if (itemType == typeof(Transaction)) { var trns = (Transaction)item; var loaded = new SelectionQuery() .From(QueryFrom.EntityType(item.GetType())) .Select(QuerySelection.EntityType(item.GetType())) .Where(QueryCondition.Expression(ConditionExpr.Build().Field(itemType, "TransactionId").Eq().Value(trns.TransactionId))) .ToList(tx).FirstOrDefault(); newList.Add((IEntity)loaded); } else if (itemType == typeof(Service)) { var svc = (Service)item; var loaded = new SelectionQuery() .From(QueryFrom.EntityType(item.GetType())) .Select(QuerySelection.EntityType(item.GetType())) .Where(QueryCondition.Expression(ConditionExpr.Build().Field(itemType, "ItemId").Eq().Value(svc.ItemId))) .ToList(tx).FirstOrDefault(); newList.Add((IEntity)loaded); } else if (itemType == typeof(Product)) { var product = (Product)item; var loaded = new SelectionQuery() .From(QueryFrom.EntityType(item.GetType())) .Select(QuerySelection.EntityType(item.GetType())) .Where(QueryCondition.Expression(ConditionExpr.Build().Field(itemType, "ItemId").Eq().Value(product.ItemId))) .ToList(tx).FirstOrDefault(); newList.Add((IEntity)loaded); } if (i % 100 == 0) { tx.Close(); tx = transactionFactory.CreateTransaction(); } } tx.Commit(); tx.Close(); sw.Stop(); var speed = items.Count * 1000 / sw.ElapsedMilliseconds; LoggerManager.GetLogger(Assembly.GetExecutingAssembly(), typeof(NDbGatePerformanceCounter)) .Log(typeof(NDbGatePerformanceCounter), Level.Warn, $"NDBGate Thread Query speed {speed} entities/second", null); return(newList); }
/// <summary> /// 展示查询界面 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void query_mti_Click(object sender, EventArgs e) { QueryFrom qf = new QueryFrom(); qf.ShowDialog(); }