public void showProduct(int categoryId) { using (tradeEntities db = new tradeEntities()) { //var q = db.prod_category.Join( // db.prod_poduct, // c => c.category_id, // p => p.product_category_id, // (c, p) => new // { // Name= p.product_name // } // ); var q = db.prod_poduct. Where(x => x.product_category_id == categoryId). Select( p => new { p.product_name, p.product_id }); gridProduct.ItemsSource = q.ToList(); // gridProduct.ItemsSource = db.prod_poduct.ToList(); } }
private void LoadData() { try { db = new tradeEntities(DbModel.Tools.TradeConnectionString(Properties.Settings.Default.barcodeCS.ToString())); appReportsBindingSource.DataSource = db.AppReports.Select(x => new { x.ID, x.AddTime, x.UserName, x.Message, hasFile = x.FileName == null || x.FileName == string.Empty ? false : true, x.ClosedTime, x.Reply }).OrderByDescending(x => x.ClosedTime).ThenByDescending(x => x.AddTime).Take(500).ToList(); } catch (Exception ex) { Debug.Print(ex.ToString()); } }
public CategorysView() { InitializeComponent(); using (tradeEntities db = new tradeEntities()) { //foreach (prod_category c in db.prod_category) //{ // categoryList.Add( // new Record // { // Name = c.category_name, // TreeId = c.category_id, // ParentId = (int)c.paerent_category, // } // ); //} var root = prod_category_tree.CreateTree(db.prod_category.ToList()); tree.ItemsSource = new[] { root }; } }
private void simpleButton9_Click(object sender, EventArgs e) { var frmSelectDealer = new Forms.FrmDealerChoose(); if (frmSelectDealer.ShowDialog(this) == DialogResult.OK) { try { var dbNew = new tradeEntities(DbModel.Tools.TradeConnectionString(Properties.Settings.Default.barcodeCS.ToString())); var pos2change = dbNew.Pos.Where(x => x.ID == posId).FirstOrDefault(); pos2change.dealer_ID = frmSelectDealer.DealerId; dbNew.SaveChanges(); this.DialogResult = DialogResult.OK; this.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); this.Close(); } } }
public MainWindow() { InitializeComponent(); using (tradeEntities db = new tradeEntities()) { // var q = db.prod_category; /*запрос в стиле */ //var q = from t in db.категории // where t.name_category.ToUpper().StartsWith("В") // orderby t.name_category // select t; /*Можно совмещать с обычным SQL*/ //var comps = db.Database.SqlQuery<prod_Category>("SELECT * FROM "); // вставка // int numberOfRowInserted = db.Database.ExecuteSqlCommand("INSERT INTO prod_category (category_name) VALUES ('Тест')"); //prod_poduct p = new prod_poduct(); //p.product_name = "Тест"; //p.product_category_id = 6; //db.prod_poduct.Add(p); //db.SaveChanges(); var q = db.prod_category.Join( db.prod_poduct, c => c.category_id, p => p.product_category_id, (p, c) => new { Name = p.category_name }); foreach (var t in q) { Console.WriteLine(t.Name); } } }