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