LINQ -- 新增 修改 删除

Linq 更新语句

更新和删除其实语法差不多

• LINQ的更新
• Linq的删除
• Linq的新增
• 强大的查询功能

---

内容

代码块 新增

        lqRecCustTransDataContext db = new lqRecCustTransDataContext();

    AdjMkApply mkApp = new AdjMkapply(); 
                  mkApp.FactOps = Convert.ToInt32(txtFact.Text);
            mkApp.AdjQty = Convert.ToInt32(txtMk.Text);
            mkApp.AdjDocNo = sKtdh;
            mkApp.ReasonTmp = cbxReason.Text;
               db.AdjMkApply.InsertOnSubmit(mkApp);
               db.SubmitChanges();

代码块 更新

   lqRecCustTransDataContext db = new lqRecCustTransDataContext();


           for (int i = 0; i < dataGridView1.Rows.Count; i++)
            {
               long iAutoId = Convert.ToInt64(dataGridView1.Rows[i].Cells["AutoId"].EditedFormattedValue);

               AdjMkApply newMkApp = db.AdjMkApply.First(v => v.AutoId == iAutoId);
               newMkApp.mkStatus = "已申请";
               db.SubmitChanges();

            }

-------------------------------------------------------------------------------------------------------------------

或者换一种简单的写法:
                     var q2 = db.AdjMkApply.First(c => c.AutoId == iAid && c.CreateUser == tb_UserInf.CreateUser);
                     q2.mkStatus = "已申请";
                     db.SubmitChanges();

代码块 删除

   lqRecCustTransDataContext db = new lqRecCustTransDataContext();

                     var q = (from c in db.AdjMkApply
                              where c.CreateUser == tb_UserInf.CreateUser && c.AutoId == iAid
                              select c).First();
                     db.AdjMkApply.DeleteOnSubmit(q);

  var q2 = db.AdjMkApply.First(c => c.AutoId == iAid && c.CreateUser == tb_UserInf.CreateUser);
                     db.AdjMkApply.DeleteOnSubmit(q2);