public Task <int> Add(T model) { _db.BeginTran(); int count = _db.Insertable <T>(model).ExecuteCommand(); _db.CommitTran(); return(Task.Run(() => count)); }
/// <summary> /// 审核提交问卷 /// </summary> /// <param name="vguid"></param> /// <returns></returns> public bool CheckedQuestion(string vguid) { using (SqlSugarClient _dbMsSql = SugarDao_MsSql.GetInstance()) { bool result = false; Guid Vguid = Guid.Parse(vguid); try { _dbMsSql.BeginTran(); result = _dbMsSql.Update <Business_Questionnaire>(new { Status = 2 }, i => i.Vguid == Vguid); Business_Questionnaire questionInfo = _dbMsSql.Queryable <Business_Questionnaire>().Where(i => i.Vguid == Vguid).SingleOrDefault(); string exerciseJson = JsonHelper.ModelToJson(questionInfo); //存入操作日志表 _ll.SaveLog(9, 52, CurrentUser.GetCurrentUser().LoginName, questionInfo.QuestionnaireName, exerciseJson); _dbMsSql.CommitTran(); } catch (Exception ex) { _dbMsSql.RollbackTran(); Common.LogHelper.LogHelper.WriteLog(ex.ToString()); _ll.SaveLog(5, 52, CurrentUser.GetCurrentUser().LoginName, "", ex.ToString()); } return(result); } }
/// <summary> /// 批量禁用用户 /// </summary> /// <param name="vguid"></param> /// <returns></returns> public bool DisableUser(string vguid) { using (SqlSugarClient _dbMsSql = SugarDao_MsSql.GetInstance()) { bool result = false; Guid Vguid = Guid.Parse(vguid); try { _dbMsSql.BeginTran(); result = _dbMsSql.Update <Sys_User>(new { Enable = "0" }, i => i.Vguid == Vguid); Sys_User userInfo = _dbMsSql.Queryable <Sys_User>().Where(i => i.Vguid == Vguid).SingleOrDefault(); string weChatJson = JsonHelper.ModelToJson <Sys_User>(userInfo); ////存入操作日志表 _logLogic.SaveLog(16, 26, Common.CurrentUser.GetCurrentUser().LoginName, userInfo.LoginName, weChatJson); _dbMsSql.CommitTran(); } catch (Exception ex) { _dbMsSql.RollbackTran(); Common.LogHelper.LogHelper.WriteLog(ex.Message); } finally { } return(result); } }
/// <summary> /// 提交推送信息 /// </summary> /// <param name="vguid"></param> /// <returns></returns> public bool SubmitDraftList(string vguid) { using (SqlSugarClient _dbMsSql = SugarDao_MsSql.GetInstance()) { bool result = false; Guid Vguid = Guid.Parse(vguid); try { _dbMsSql.BeginTran(); result = _dbMsSql.Update <Business_WeChatPush_Information>(new { Status = 2 }, i => i.VGUID == Vguid); Business_WeChatPush_Information weChatPushInfo = _dbMsSql.Queryable <Business_WeChatPush_Information>().Where(i => i.VGUID == Vguid).SingleOrDefault(); string weChatJson = JsonHelper.ModelToJson(weChatPushInfo); //存入操作日志表 _ll.SaveLog(8, 12, CurrentUser.GetCurrentUser().LoginName, weChatPushInfo.Title, weChatJson); _dbMsSql.CommitTran(); } catch (Exception ex) { _dbMsSql.RollbackTran(); LogHelper.WriteLog(ex.Message + "/n" + ex.ToString() + "/n" + ex.StackTrace); _ll.SaveLog(5, 12, CurrentUser.GetCurrentUser().LoginName, "提交推送信息", vguid); } return(result); } }
/// <summary> /// 删除推送信息 /// </summary> /// <param name="vguid"></param> /// <returns></returns> public bool DeletePushMsg(string vguid) { using (SqlSugarClient _dbMsSql = SugarDao_MsSql.GetInstance()) { Guid Vguid = Guid.Parse(vguid); try { _dbMsSql.BeginTran(); var weChatPushInfo = _dbMsSql.Queryable <Business_WeChatPush_Information>().Where(i => i.VGUID == Vguid).SingleOrDefault(); string weChatJson = JsonHelper.ModelToJson(weChatPushInfo); _ll.SaveLog(2, 9, CurrentUser.GetCurrentUser().LoginName, weChatPushInfo.Title, weChatJson); //存入操作日志表 _dbMsSql.Delete <Business_WeChatPush_Information>(i => i.VGUID == Vguid); var weChatPushDetailList = _dbMsSql.Queryable <Business_WeChatPushDetail_Information>().Where(i => i.Business_WeChatPushVguid == Vguid).ToList(); string weChatPushDetailListJson = JsonHelper.ModelToJson(weChatPushDetailList); _ll.SaveLog(2, 9, CurrentUser.GetCurrentUser().LoginName, "推送接收者列表", weChatPushDetailListJson); //存入操作日志表 _dbMsSql.Delete <Business_WeChatPushDetail_Information>(i => i.Business_WeChatPushVguid == Vguid); _dbMsSql.Delete <Business_WeChatPush_MoreGraphic_Information>(i => i.WeChatPushVguid == Vguid); _dbMsSql.CommitTran(); return(true); } catch (Exception ex) { _dbMsSql.RollbackTran(); LogHelper.WriteLog(ex.Message + "/n" + ex.ToString() + "/n" + ex.StackTrace); _ll.SaveLog(5, 12, CurrentUser.GetCurrentUser().LoginName, "删除推送信息", vguid); return(false); } } }
/// <summary> /// 删除未提交问卷 /// </summary> /// <param name="vguid">问卷Vguid</param> /// <returns></returns> public bool DeletedQuestion(string vguid) { using (SqlSugarClient _dbMsSql = SugarDao_MsSql.GetInstance()) { bool result = false; Guid questionVguid = Guid.Parse(vguid); try { _dbMsSql.BeginTran(); Business_Questionnaire exerciseModel = _dbMsSql.Queryable <Business_Questionnaire>().Where(i => i.Vguid == questionVguid).SingleOrDefault(); string logData = JsonHelper.ModelToJson(exerciseModel); result = _dbMsSql.Delete <Business_Questionnaire>(i => i.Vguid == questionVguid); //删除问卷主表 if (result) { List <Business_QuestionnaireDetail> exercisesDetail = _dbMsSql.Queryable <Business_QuestionnaireDetail>().Where(i => i.QuestionnaireVguid == questionVguid).ToList(); if (exercisesDetail.Count != 0) { result = _dbMsSql.Delete <Business_QuestionnaireDetail>(i => i.QuestionnaireVguid == questionVguid); //删除问卷附表 } } _ll.SaveLog(2, 52, Common.CurrentUser.GetCurrentUser().LoginName, exerciseModel.QuestionnaireName, logData); _dbMsSql.CommitTran(); } catch (Exception exp) { _dbMsSql.RollbackTran(); Common.LogHelper.LogHelper.WriteLog(exp.ToString()); _ll.SaveLog(5, 52, Common.CurrentUser.GetCurrentUser().LoginName, "", exp.ToString()); } return(result); } }
public bool ProjectStallSubmit(int id, int billType, List <R_ProjectStall> req) { using (var db = new SqlSugarClient(Connection)) { bool result = true; try { db.BeginTran(); result = db.Delete <R_ProjectStall>(p => p.R_Stall_Id == id && p.BillType == billType); if (req != null && req.Count > 0) { req = req.Distinct(new ProjectStallComparer()).ToList(); db.InsertRange(req); } db.CommitTran(); } catch (Exception) { result = false; db.RollbackTran(); throw; } return(result); } }
public void Init() { var mstStr = "server=.;uid=sa;pwd=sasa;database=SqlSugarTest"; var conList = new List <string>() { "server=localhost;uid=sa;pwd=sasa;database=SqlSugarTest" }; SqlSugarClient db = new SqlSugarClient(mstStr, conList); var l1 = db.Queryable <Student>().ToList(); //走从 var d1 = db.Queryable <Student>().ToDataTable(); //走从 var t3 = db.Queryable <Student>().ToList(); //走从 db.Insert <Student>(new Student() { name = "主" }); db.BeginTran(); var l2 = db.Queryable <Student>().ToList();//走主 db.CommitTran(); var l3 = db.Queryable <Student>().ToList();//走从 db.Dispose(); }
public bool Update(RestaurantCategoryCreateDTO req) { using (var db = new SqlSugarClient(Connection)) { bool res = false; try { db.BeginTran(); db.Delete <R_RestaurantCategory>(p => p.R_Restaurant_Id == req.R_Restaurant_Id); List <R_RestaurantCategory> list = new List <R_RestaurantCategory>(); foreach (var item in req.CategoryIds) { list.Add(new R_RestaurantCategory() { R_Restaurant_Id = req.R_Restaurant_Id, R_Category_Id = item }); } db.InsertRange <R_RestaurantCategory>(list); db.CommitTran(); res = true; } catch (Exception ex) { throw ex; } return(res); } }
/// <summary> /// 删除未提交习题 /// </summary> /// <param name="vguid">习题Vguid</param> /// <returns></returns> public bool DeletedExercise(string vguid) { using (SqlSugarClient _dbMsSql = SugarDao_MsSql.GetInstance()) { bool result = false; Guid exerciseVguid = Guid.Parse(vguid); try { _dbMsSql.BeginTran(); Business_Exercises_Infomation exerciseModel = _dbMsSql.Queryable <Business_Exercises_Infomation>().Where(i => i.Vguid == exerciseVguid).SingleOrDefault(); string logData = JsonHelper.ModelToJson(exerciseModel); result = _dbMsSql.Delete <Business_Exercises_Infomation>(i => i.Vguid == exerciseVguid); //删除习题主表 if (result) { _dbMsSql.Delete <Business_ExerciseLibrary_Information>(i => i.BusinessExercisesVguid == exerciseVguid); List <Business_ExercisesDetail_Infomation> exercisesDetail = _dbMsSql.Queryable <Business_ExercisesDetail_Infomation>().Where(i => i.ExercisesInformationVguid == exerciseVguid).ToList(); if (exercisesDetail.Count != 0) { result = _dbMsSql.Delete <Business_ExercisesDetail_Infomation>(i => i.ExercisesInformationVguid == exerciseVguid); //删除习题附表 } } _ll.SaveLog(2, 7, Common.CurrentUser.GetCurrentUser().LoginName, exerciseModel.ExercisesName, logData); _dbMsSql.CommitTran(); } catch (Exception exp) { _dbMsSql.RollbackTran(); Common.LogHelper.LogHelper.WriteLog(exp.ToString()); _ll.SaveLog(5, 7, Common.CurrentUser.GetCurrentUser().LoginName, "", exp.ToString()); } return(result); } }
/// <summary> /// 提交草稿知识 /// </summary> /// <param name="vguid">主键</param> /// <returns></returns> public bool SubmitKnowledgeBase(Guid vguid) { using (SqlSugarClient db = SugarDao_MsSql.GetInstance()) { bool result = false; try { db.BeginTran(); result = db.Update <Business_KnowledgeBase_Information>( new { Status = 2, ChangeDate = DateTime.Now, ChangeUser = Common.CurrentUser.GetCurrentUser().LoginName }, i => i.Vguid == vguid); Business_KnowledgeBase_Information knowledgeInfo = db.Queryable <Business_KnowledgeBase_Information>() .Where(i => i.Vguid == vguid) .SingleOrDefault(); string knowledgeJson = JsonHelper.ModelToJson(knowledgeInfo); //存入操作日志表 _ll.SaveLog(8, 40, Common.CurrentUser.GetCurrentUser().LoginName, knowledgeInfo.Title, knowledgeJson); db.CommitTran(); } catch (Exception ex) { db.RollbackTran(); Common.LogHelper.LogHelper.WriteLog(ex.ToString()); _ll.SaveLog(5, 40, Common.CurrentUser.GetCurrentUser().LoginName, "", ex.ToString()); } return(result); } }
/// <summary> /// 更新组织信息 /// </summary> /// <param name="orgModel"></param> /// <returns></returns> public bool update(OrgModel orgModel) { using (SqlSugarClient db = BaseDB.GetClient()) { try { //db.BeginTran();//开启事务 //特别说明:在事务中,默认情况下是使用锁的,也就是说在当前事务没有结束前,其他的任何查询都需要等待 //ReadCommitted:在正在读取数据时保持共享锁,以避免脏读,但是在事务结束之前可以更改数据,从而导致不可重复的读取或幻像数据。 //db.BeginTran(System.Data.IsolationLevel.ReadCommitted); //重载指定事务的级别 db.BeginTran();//开始事物 db.Updateable <Organization>(orgModel.organization); //组织关系表不会发生变化 不需要处理 //Dictionary<string, Object> updatec = new Dictionary<string, object>(); // updatec.Add("",) // db.Updateable<OrganizationOrg>(updatec).Where(org=>org.orgid == orgModel.parentOrgId); db.CommitTran();//提交事务 return(true); } catch (Exception ex) { db.RollbackTran();//回滚 return(false); } } }
private async ValueTask <string> GenerateInvitationCode(SqlSugarClient context, long senderId, UserAuthority authority) { try { context.BeginTran(); var invitationService = new InvitationService(context); var invitation = new Invitation() { ObjectId = IdGenerator.CreateId(), Authority = authority, CreateTime = DateTime.UtcNow, InvitationCode = EncryptUtils.GenerateRandomString(32), ReceiverId = -1, SenderId = senderId, UsedTime = DateTime.MinValue }; var success = await invitationService.InsertAsync(invitation); context.CommitTran(); return(success ? invitation.InvitationCode : null); } catch (Exception e) { context.RollbackTran(); throw; } }
public bool execTran(Action <SqlSugarClient> action) { bool bt = true; using (SqlSugarClient db = GetDao()) { //db.is = true; db.CommandTimeOut = 30000; try { db.BeginTran(); //db.BeginTran(IsolationLevel.ReadCommitted);+3 if (action != null) { action(db); } db.CommitTran(); } catch (Exception e) { db.RollbackTran(); bt = false; logger.Error("execTran -- error", e); } } return(bt); }
/// <summary> /// 给阅读消息历史并且没有答过题的人重新推送习题 /// </summary> /// <param name="businessPersonnelVguid"></param> /// <param name="wechatMainVguid"></param> /// <returns></returns> public bool ReWechatPushExercise(string businessPersonnelVguid, string wechatMainVguid) { Guid mainVguid = Guid.Parse(wechatMainVguid); Guid personnelVguid = Guid.Parse(businessPersonnelVguid); bool result = false; using (SqlSugarClient db = SugarDao_MsSql.GetInstance()) { try { db.BeginTran(); var wechatMainModel = db.Queryable <Business_WeChatPush_Information>().Where(i => i.VGUID == mainVguid).SingleOrDefault(); var currentUser = db.Queryable <Business_Personnel_Information>().Where(i => i.Vguid == personnelVguid).Select(i => i.UserID).SingleOrDefault(); DateTime?dateTime = null; var wechatMain = new Business_WeChatPush_Information() { PushType = 1, Title = wechatMainModel.Title, MessageType = 4, Timed = false, TimedSendTime = null, Important = wechatMainModel.PeriodOfValidity == null, PeriodOfValidity = wechatMainModel.PeriodOfValidity == null ? dateTime : DateTime.Now.AddMonths(1), Message = "从消息历史获取", PushPeople = wechatMainModel.PushPeople, Status = 3, CreatedDate = DateTime.Now, CreatedUser = wechatMainModel.CreatedUser, VGUID = Guid.NewGuid(), CoverImg = wechatMainModel.CoverImg, CoverDescption = wechatMainModel.CoverDescption, ExercisesVGUID = wechatMainModel.ExercisesVGUID, History = "0", Department_VGUID = Guid.Empty }; var wechatDetail = new Business_WeChatPushDetail_Information() { Type = "1", PushObject = currentUser, CreatedUser = wechatMainModel.CreatedUser, CreatedDate = DateTime.Now, Vguid = Guid.NewGuid(), Business_WeChatPushVguid = wechatMain.VGUID, ISRead = "0", }; string logdata = Extend.ModelToJson(wechatMain); _ll.SaveLog(10, 34, currentUser, "从消息历史获取习题", logdata); db.Insert(wechatDetail, false); db.Insert(wechatMain, false); db.CommitTran(); result = true; } catch (Exception ex) { db.RollbackTran(); LogHelper.WriteLog(ex.ToString()); } } return(result); }
/// <summary> /// 审核推送信息 /// </summary> /// <param name="vguid"></param> /// <returns></returns> public bool CheckSubmitList(string vguid) { using (SqlSugarClient _dbMsSql = SugarDao_MsSql.GetInstance()) { bool result = false; Guid Vguid = Guid.Parse(vguid); try { _dbMsSql.BeginTran(); result = _dbMsSql.Update <Business_WeChatPush_Information>(new { Status = 3 }, i => i.VGUID == Vguid); Business_WeChatPush_Information weChatPushModel = _dbMsSql.Queryable <Business_WeChatPush_Information>().Where(i => i.VGUID == Vguid).SingleOrDefault(); string jsonResult = JsonHelper.ModelToJson <Business_WeChatPush_Information>(weChatPushModel); //存入操作日志表 _ll.SaveLog(9, 16, Common.CurrentUser.GetCurrentUser().LoginName, weChatPushModel.Title, jsonResult); _dbMsSql.CommitTran(); } catch (Exception ex) { _dbMsSql.RollbackTran(); Common.LogHelper.LogHelper.WriteLog(ex.Message + "/n" + ex.ToString() + "/n" + ex.StackTrace); } finally { } return(result); } }
public bool Add(Sys_Role obj, List <Sys_RoleAuthorize> list, bool isadd) { using (SqlSugarClient db = SqlSugarDao.GetInstance())//开启数据库连接 { bool i = false; db.CommandTimeOut = 30000;//设置超时时间 try { db.BeginTran();//开启事务 if (!isadd) { db.Delete <Sys_RoleAuthorize>("F_ObjectId=@F_id", new { F_id = obj.F_Id }); string[] notstr = { "F_CreatorUserId", "F_CreatorTime", "F_Category" }; db.AddDisableUpdateColumns(notstr);//添加禁止更新列 db.Update(obj); } else { db.Insert(obj); } db.InsertRange(list); i = true; db.CommitTran();//提交事务 } catch (Exception ex) { db.RollbackTran();//回滚事务 i = false; } return(i); } }
public async Task <bool> AddEntity(List <T> list) { bool rs = false; using (SqlSugarClient db = SqlClient.GetInstance()) { try { db.BeginTran(); rs = await db.Insertable(list).ExecuteCommandAsync() == list.Count; if (rs) { db.CommitTran(); } else { db.RollbackTran(); } } catch (Exception exp) { db.RollbackTran(); throw exp; } } return(rs); }
public bool UpdateWeixinPrint(WeixinPrintDTO req) { using (var db = new SqlSugarClient(Connection)) { bool result = true; try { db.BeginTran(); R_WeixinPrint model = Mapper.Map <WeixinPrintDTO, R_WeixinPrint>(req); if (model.Id <= 0) { var insertId = Convert.ToInt32(db.Insert <R_WeixinPrint>(model)); if (req.PrintAreas != null && req.PrintAreas.Any()) { List <R_WeixinPrintArea> list = new List <R_WeixinPrintArea>(); foreach (var item in req.PrintAreas) { list.Add(new R_WeixinPrintArea() { R_Area_Id = item.R_Area_Id, R_WeixinPrint_Id = insertId }); } db.InsertRange <R_WeixinPrintArea>(list); } } else { db.Update <R_WeixinPrint>(model); db.Delete <R_WeixinPrintArea>(p => p.R_WeixinPrint_Id == model.Id); if (req.PrintAreas != null && req.PrintAreas.Any()) { List <R_WeixinPrintArea> list = new List <R_WeixinPrintArea>(); foreach (var item in req.PrintAreas) { list.Add(new R_WeixinPrintArea() { R_Area_Id = item.R_Area_Id, R_WeixinPrint_Id = model.Id }); } db.InsertRange <R_WeixinPrintArea>(list); } } db.CommitTran(); } catch (Exception ex) { result = false; db.RollbackTran(); throw ex; } return(result); } }
public bool Create(DiscountCreateDTO req) { using (var db = new SqlSugarClient(Connection)) { bool result = true; try { db.BeginTran(); R_Discount model = new R_Discount() { R_Restaurant_Id = req.Restaurant, R_Area_Id = req.Area, R_Market_Id = req.Market, IsEnable = req.IsEnable, Name = req.Name, StartDate = req.StartDate, EndDate = req.EndDate, R_Company_Id = req.CompanyId }; var newId = db.Insert(model); if (req.CyxmZkCp != null) { var list = req.CyxmZkCp.Where(p => p.Id == 0).ToList(); list.ForEach(p => p.R_Discount_Id = Convert.ToInt32(newId)); //插入之前先判断是否存在,只插入不存在的 foreach (var item in list) { //查询是否存在 List <R_DiscountCategory> data = db.Queryable <R_DiscountCategory>() .Where(p => p.R_Discount_Id == Convert.ToInt32(newId)) .Where(p => p.R_Category_Id == item.R_Category_Id) .ToList(); //插入不存在的 if (data.Count <= 0) { db.Insert(item); } } //db.InsertRange<R_DiscountCategory>(list); } db.CommitTran(); } catch (Exception) { db.RollbackTran(); } return(result); } }
/// <summary> /// 保存 page Content /// </summary> /// <param name="sp"></param> /// <param name="userName"></param> public void SavePageContent(SysBest_PageContent sp, string userName) { var id = sp.Id; try { _db.BeginTran(); Expression <Func <SysBest_PageContent, bool> > whereExpress = it => it.AddressId == sp.AddressId && it.LanguageId == sp.LanguageId; var isAny = _db.Queryable <SysBest_PageContent>().Any(whereExpress); if (isAny) { var data = _db.Queryable <SysBest_PageContent>().Single(whereExpress); data.Html = sp.Html; data.layout = sp.layout; data.ModifiedBy = userName; data.ModifiedTime = DateTime.Now; _db.Update(data); id = data.Id; } else { sp.Sort = 0; sp.Founder = userName; sp.CreateTime = DateTime.Now; id = _db.Insert(sp).TryToInt(); } //表单中的所有控件html id List <string> formHtmlIdList = GetHtmlIdListByPageContent(sp); //数据库中存在的html var dbIdList = _db.Queryable <SysBest_Element>().Where(it => it.AddressId == sp.AddressId && it.LanguageId == sp.LanguageId).ToList().Select(it => it.Html_Id).ToList(); //在数据中,但是不在表单里面的需要删除 var delHtmlIdList = dbIdList.Where(it => formHtmlIdList.Any(htmlId => htmlId == it).IsFalse()).ToList();//不存在content里面的元素需要删除 foreach (var it in delHtmlIdList) { _db.Delete <SysBest_Element>(m => m.Html_Id == it); } //插入备份 InsertElementItemBak(sp.AddressId, sp.LanguageId, _db); //处理其它页面控件的HTMLID distinctHtmlIdList(sp, formHtmlIdList); _db.CommitTran(); } catch (Exception ex) { _db.RollbackTran(); throw ex; } }
/// <summary> /// 保存问卷信息(主信息、详细信息) /// </summary> /// <param name="questionMainModel"></param> /// <param name="isEdit"></param> /// <returns></returns> public bool SaveQuestionMain(Business_Questionnaire questionMainModel, bool isEdit, List <Business_QuestionnaireDetail> questionDetailList) { using (SqlSugarClient _dbMsSql = SugarDao.SugarDao_MsSql.GetInstance()) { bool result = false; try { _dbMsSql.BeginTran(); if (isEdit) { //定义匿名类型model var model = new { QuestionnaireName = questionMainModel.QuestionnaireName, Description = questionMainModel.Description, Remarks = questionMainModel.Remarks, EffectiveDate = questionMainModel.EffectiveDate, Status = questionMainModel.Status, ChangeUser = questionMainModel.ChangeUser, ChangeDate = questionMainModel.ChangeDate }; result = _dbMsSql.Update <Business_Questionnaire>(model, i => i.Vguid == questionMainModel.Vguid); //存入操作日志表 string logData = JsonHelper.ModelToJson(questionMainModel); _ll.SaveLog(4, 54, CurrentUser.GetCurrentUser().LoginName, questionMainModel.QuestionnaireName + " " + "主信息", logData); } else { result = _dbMsSql.Insert(questionMainModel, false) != DBNull.Value; //存入操作日志表 string logData = JsonHelper.ModelToJson(questionMainModel); _ll.SaveLog(1, 53, CurrentUser.GetCurrentUser().LoginName, questionMainModel.QuestionnaireName + " " + "主信息", logData); } _dbMsSql.Delete <Business_QuestionnaireDetail>(i => i.QuestionnaireVguid == questionMainModel.Vguid); foreach (var item in questionDetailList) { _dbMsSql.Insert(item, false); //存入操作日志表 string logData = JsonHelper.ModelToJson(item); _ll.SaveLog(4, 55, CurrentUser.GetCurrentUser().LoginName, questionMainModel.QuestionnaireName + " " + "问卷详细信息", logData); } _dbMsSql.CommitTran(); } catch (Exception ex) { _dbMsSql.RollbackTran(); Common.LogHelper.LogHelper.WriteLog(ex.Message + "/n" + ex + "/n" + ex.StackTrace); } return(result); } }
public void StatrAffairs(Action action) { try { _db.BeginTran(); action(); _db.CommitTran(); } catch (Exception) { _db.RollbackTran(); throw; } }
/// <summary> /// 保存用户信息 /// </summary> /// <param name="userModel"></param> /// <param name="isEdit"></param> /// <returns></returns> public bool SaveUserInfo(Sys_User userModel, bool isEdit) { using (SqlSugarClient _dbMsSql = SugarDao.SugarDao_MsSql.GetInstance()) { bool result = false; try { //_dbMsSql.Queryable<Master_Organization>().Where(it=>it.) _dbMsSql.BeginTran(); if (isEdit)//编辑 { var model = new { LoginName = userModel.LoginName, Email = userModel.Email, MobileNnumber = userModel.MobileNnumber, WorkPhone = userModel.WorkPhone, Role = userModel.Role, Company = userModel.Company, Department = userModel.Department, Enable = userModel.Enable, Remark = userModel.Remark, ChangeUser = userModel.ChangeUser, ChangeDate = userModel.ChangeDate }; result = _dbMsSql.Update <Sys_User>(model, i => i.Vguid == userModel.Vguid); string userJson = JsonHelper.ModelToJson <Sys_User>(userModel); _logLogic.SaveLog(4, 28, Common.CurrentUser.GetCurrentUser().LoginName, userModel.LoginName, userJson); } else//新增 { result = _dbMsSql.Insert <Sys_User>(userModel, false) != DBNull.Value; //result = _dbMsSql.Insert<Sys_User>(userModel) != DBNull.Value; string userJson = JsonHelper.ModelToJson <Sys_User>(userModel); _logLogic.SaveLog(1, 27, Common.CurrentUser.GetCurrentUser().LoginName, userModel.LoginName, userJson); } _dbMsSql.CommitTran(); } catch (Exception ex) { _dbMsSql.RollbackTran(); Common.LogHelper.LogHelper.WriteLog(ex.Message + "/n" + ex.ToString() + "/n" + ex.StackTrace); } finally { } return(result); } }
/// <summary> /// 保存事件和属性 /// </summary> /// <param name="elementType"></param> /// <param name="insObj"></param> /// <returns></returns> public bool SaveAttrsAndEvents_temp(int elementType, SysBest_Element insObj, int addressId, List <ElementAttr> formAttrs, List <ElementEvent> formEvents) { try { _db.BeginTran(); //保存元素 int elementId = 0; var isAdd = _db.Queryable <SysBest_Element>().Any(it => it.Html_Id == insObj.Html_Id).IsFalse(); if (isAdd) { //添加 elementId = _db.Insert <SysBest_Element>(insObj).TryToInt(); } else { //编辑 var data = _db.Queryable <SysBest_Element>().Single(it => it.Html_Id == insObj.Html_Id); data.EleName = insObj.EleName; data.ModifiedTime = DateTime.Now; data.ModifiedBy = insObj.Founder; data.ApiId = insObj.ApiId; data.Description = insObj.Description; _db.Update(data); elementId = data.Id; } InsertAttrs(addressId, formAttrs, elementId, insObj.Founder); //插入事件 InsertEvents(insObj, addressId, formEvents, elementId, insObj.Founder); //插入备份 this.InsertElementItemBak(addressId, insObj.LanguageId, _db); _db.CommitTran(); return(true); } catch (Exception ex) { _db.RollbackTran(); throw ex; } }
public void Init() { SqlSugarClient db = new SqlSugarClient("server=.;uid=sa;pwd=sasa;database=SqlSugarTest", "server=localhost;uid=sa;pwd=sasa;database=SqlSugarTest"); var l1= db.Queryable<Student>().ToList();//走从 var d1= db.Queryable<Student>().ToDataTable();//走从 var t3 = db.Queryable<Student>().ToList();//走从 db.Insert<Student>(new Student() { name="主" }); db.BeginTran(); var l2 = db.Queryable<Student>().ToList();//走主 db.CommitTran(); var l3 = db.Queryable<Student>().ToList();//走从 db.Dispose(); }
public bool Create(TableCreateDTO req) { using (var db = new SqlSugarClient(Connection)) { bool result = true; try { db.BeginTran(); R_Table model = new R_Table() { Name = req.Name, Describe = req.Description, R_Restaurant_Id = req.RestaurantId, ServerRate = req.ServerRate, R_Area_Id = req.RestaurantArea, CythStatus = CythStatus.空置, SeatNum = req.SeatNum, IsVirtual = req.IsVirtual, Sorted = req.Sorted }; var insert = db.Insert(model); if (req.Box > 0) { db.Insert(new R_BoxTable() { R_Table_Id = Convert.ToInt32(insert), R_Box_Id = req.Box }); } db.CommitTran(); } catch (Exception) { result = false; db.RollbackTran(); throw; } return(result); } }
public bool delete(OrgModel orgModel) { try { using (SqlSugarClient db = BaseDB.GetClient()) { db.BeginTran();//开始事物 db.Deleteable <Organization>(orgModel.organization).ExecuteCommand(); db.Deleteable <OrganizationOrg>().Where(orgo => orgo.orgid == orgModel.parentOrgId).ExecuteCommand(); db.CommitTran();//提交事务 return(true); } } catch (Exception ex) { return(false); } }
public static void SaveOrUpdate2(this SqlSugarClient db, object obj) { //可以写自已的代码 try { db.BeginTran(); //开启事务 //db.BeginTran(IsolationLevel.ReadCommitted);+3重载可以设置事世隔离级别 db.CommitTran();//提交事务 } catch (Exception) { db.RollbackTran();//回滚事务 throw; } }
/// <summary> /// 更新用户是否阅读推送状态 /// </summary> /// <param name="userID">用户微信UserID</param> /// <param name="pushVguid">推送内容Vguid</param> /// <returns></returns> public bool UpdateIsRead(string userID, Guid pushVguid) { using (SqlSugarClient _dbMsSql = SugarDao.SugarDao_MsSql.GetInstance()) { bool result = false; try { _dbMsSql.BeginTran(); result = _dbMsSql.Update <Business_WeChatPushDetail_Information>(new { ISRead = "1" }, i => i.PushObject == userID && i.Business_WeChatPushVguid == pushVguid); _dbMsSql.CommitTran(); } catch (Exception exp) { _dbMsSql.RollbackTran(); LogHelper.WriteLog(exp.Message + "/n" + exp.ToString() + "/n" + exp.StackTrace); } return(result); } }
protected void Page_Load(object sender, EventArgs e) { using (SqlSugarClient db = SugarDao.GetInstance()) //开启数据库连接 { db.CommandTimeOut = 30000; //设置超时时间 try { db.BeginTran();//开启事务 //db.BeginTran(IsolationLevel.ReadCommitted);+3重载可以设置事世隔离级别 db.CommitTran();//提交事务 } catch (Exception) { db.RollbackTran();//回滚事务 throw; } } }