/// <summary> /// 添加Demo /// </summary> /// <param name="Name"></param> /// <param name="Sex"></param> /// <param name="Age"></param> /// <param name="Remark"></param> /// <returns></returns> public ResultModel <bool> InsertDemo(string Name, string Sex, int Age, string Remark) { var result = new ResultModel <bool>(); try { _demoRepository.BeginTran(); //开始事务 long Id = IdWorkerHelper.NewId(); string sql = "insert into Demo(Id,Name,Sex,Age,Remark) values(@Id,@Name,@Sex,@Age,@Remark)"; SugarParameter[] Parameter = new SugarParameter[] { new SugarParameter("@Id", Id), new SugarParameter("@Name", Name), new SugarParameter("@Sex", Sex), new SugarParameter("@Age", Age), new SugarParameter("@Remark", Remark) }; result.Data = _demoRepository.ExecuteSql(sql, Parameter); _demoRepository.CommitTran();//提交事务 return(result); } catch (Exception ex) { _demoRepository.RollbackTran();//回滚事务 throw ex; } }
/// <summary> /// 新增Demo /// </summary> /// <param name="Name"></param> /// <param name="Sex"></param> /// <param name="Age"></param> /// <param name="Remark"></param> /// <returns></returns> public bool InsertDemo(string Name, string Sex, int Age, string Remark) { try { _demoRepository.BeginTran();//开始事务 Demo Demo = new Demo(); Demo.Id = IdWorkerHelper.NewId(); Demo.Name = Name; Demo.Sex = Sex; Demo.Age = Age; Demo.Remark = Remark; bool result = _demoRepository.Insert(Demo); _demoRepository.CommitTran(); return(result); } catch (Exception ex) { _demoRepository.RollbackTran();//回滚事务 throw ex; } }