Linq to sql 添加,修改,删除,事务操作代码,Asp.Net代码库,德仔网

代码语言

代码分类

【Asp.Net】 Linq to sql 添加,修改,删除,事务操作

作者:Dezai.CN / 发布于2013/5/8/ 515


	添加记录
	using (TransactionScope Tan = new TransactionScope()) //事务操作,当添加出错时就会回滚,在多操作时使用大
	 {
	 DirectoryTree obj = new DirectoryTree();//dbml 对象
	 obj.ParentID = Convert.ToInt32(HiddenField1.Value.Replace("Add", "").Trim());
	 obj.Description = x.Count() == 0 ? "属性1" : string.IsNullOrEmpty(x.First().p) ? "属性1" : "属性" + (x.Count() + 1).ToString();
	 obj.CreatedBy = "fei";
	 obj.ModifyBy = "fei";
	 obj.ModifyDate = System.DateTime.Now;
	 obj.RDate = System.DateTime.Now;
	 obj.Remarks = "测试物料";
	 DataContext.DirectoryTrees.InsertOnSubmit(obj);
	 DataContext.SubmitChanges();
	 Tan.Complete();
	 }
	删除记录
	using (TransactionScope Tan = new TransactionScope()) //事务操作,当添加出错时就会回滚,在多操作时使用大
	 {
	 var delx = from s in DataContext.DirectoryTrees where ID.Contains(s.ID) select s;
	 if (delx.Count() > 0)
	 {
	 foreach (var n in delx)
	 {
	 DataContext.DirectoryTrees.DeleteOnSubmit(n);
	 DataContext.SubmitChanges();
	 }
	 }
	 Tan.Complete();
	 }
	
	修改记录
	using (TransactionScope Tan = new TransactionScope()) //事务操作,当添加出错时就会回滚,在多操作时使用大
	 {
	 var n = from x in DataContext.DirectoryTrees where x.ID == Convert.ToInt32(Request["key"]) select x;
	 foreach (var j in n)
	 {
	 j.ModifyBy ="000";
	 j.ModifyDate = System.DateTime.Now;
	 j.Remarks =string.IsNullOrEmpty(Request["Remarks"])?"":Server.UrlDecode(Convert.ToString(Request["Remarks"]));
	 j.Description = string.IsNullOrEmpty(Request["Description"]) ? "" : Server.UrlDecode(Convert.ToString(Request["Description"]));
	
	 }
	 DataContext.SubmitChanges();
	 Tan.Complete();
	 }

试试其它关键字

　Linq　　to　　sql　

同语言下

可能有用的

Dezai.CN贡献的其它代码(4037)