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;
}
}
}
