LINQ 分组问题

Question

            ddc = new DcStockDataContext();
            var instocktj = from pt in ddc.PASS_TABLE
                            join pd in ddc.PASS_DETAIL on pt.PASS_ID equals pd.PASS_ID
                            where (pd.FLAG == "0" && pt.PASS_DATE>=dtpbegin && pt.PASS_DATE< dtpend) && pd.UNIT==deptID
                            select new
                            {
                                物品名称 = pd.RES_NAME,
                                物品单位 = pd.CHAR_DEMO3,
                                规格 = pd.CHAR_DEMO2,
                                计划金额 = pd.PLAN_PRICE,
                                入库数量 = pd.RECEIVING_NUM,
                                单价 = pd.PRICE,
                                实际总金额 = pd.REALITY_PRICE,
                                入库单位= pd.CHAR_DEMO4,
                                入库日期 = pt.PASS_DATE,
                                供货商 = pt.PASS_SUPPLIER,
                                采购人 = pt.PASS_KEYIN                            };            dgvInStocktj.DataSource = instocktj;我想改成 按物品ID分组请问怎么改呢 网上找到些但是这种主从表 还真弄不来 第一次弄请高手们解释 一下
物品ID 为 RES_CODE

Answer 1

ddc = new DcStockDataContext();
  var instocktj = from pt in ddc.PASS_TABLE
  join pd in ddc.PASS_DETAIL on pt.PASS_ID equals pd.PASS_ID
  where (pd.FLAG == "0" && pt.PASS_DATE>=dtpbegin && pt.PASS_DATE< dtpend) && pd.UNIT==deptID
  group pt by pt.RES_CODE
  select new
  {
  物品名称 = pd.RES_NAME,
  物品单位 = pd.CHAR_DEMO3,
  规格 = pd.CHAR_DEMO2,
  计划金额 = pd.PLAN_PRICE,
  入库数量 = pd.RECEIVING_NUM,
  单价 = pd.PRICE,
  实际总金额 = pd.REALITY_PRICE,
  入库单位= pd.CHAR_DEMO4,
  入库日期 = pt.PASS_DATE,
  供货商 = pt.PASS_SUPPLIER,
  采购人 = pt.PASS_KEYIN  };