/// <summary> /// 同意产业商的角色申请 /// </summary> /// <param name="verificationId">角色验证记录编号</param> /// <param name="auditUserId">审核人用户编号</param> /// <param name="demandLevelInfoList">服务类别技能信息列表</param> /// <returns>操作成功返回true,操作失败返回false</returns> public bool ApproveBusinessVerification(long verificationId, long auditUserId, Dictionary <int, int> demandLevelInfoList) { using (var dbContext = new DuPont_TestContext()) { using (var dbTransaction = dbContext.Database.BeginTransaction()) { var businessVerifyInfo = dbContext.T_BUSINESS_VERIFICATION_INFO.Find(verificationId); businessVerifyInfo.AuditState = 1; dbContext.T_USER_ROLE_RELATION.Add(new T_USER_ROLE_RELATION { UserID = businessVerifyInfo.UserId, AuditUserId = auditUserId, RoleID = (int)RoleType.Business, MemberType = true, CreateTime = TimeHelper.GetChinaLocalTime() }); var userInfo = dbContext.T_USER.Find(businessVerifyInfo.UserId); userInfo.Province = businessVerifyInfo.Province; userInfo.City = businessVerifyInfo.City; userInfo.Region = businessVerifyInfo.Region; userInfo.Township = businessVerifyInfo.Township; userInfo.Village = businessVerifyInfo.Village; userInfo.UserName = businessVerifyInfo.RealName;//将用户的真实姓名更新过去 //只有当用户类别为QQ用户或微信用户才可以更新手机号 if (userInfo.Type == (int)UserTypes.QQUser || userInfo.Type == (int)UserTypes.WeChatUser) { userInfo.PhoneNumber = businessVerifyInfo.PhoneNumber;//将用户的最新的手机号更新过去 } userInfo.DetailedAddress = businessVerifyInfo.DetailAddress; dbContext.Entry <T_USER>(userInfo).State = EntityState.Modified; if (demandLevelInfoList != null && demandLevelInfoList.Count > 0) { demandLevelInfoList.Select(d => { dbContext.T_USER_ROLE_DEMANDTYPELEVEL_RELATION.Add(new T_USER_ROLE_DEMANDTYPELEVEL_RELATION { UserId = businessVerifyInfo.UserId, DemandId = d.Key, CreateTime = TimeHelper.GetChinaLocalTime(), RoleId = (int)RoleType.Business, Star = d.Value }); return(d); }).Count(); } dbContext.SaveChanges(); dbTransaction.Commit(); return(true); } } }
/// <summary> /// E田农机手取消订单 /// </summary> /// <param name="fmodel"></param> /// <param name="id"></param> /// <param name="OperatorUserId"></param> /// <returns></returns> public async Task <int> UpdateDEMAND(T_FARMER_PUBLISHED_DEMAND fmodel, long id, string OperatorUserId) { using (var dbContext = new DuPont_TestContext()) { using (var dbTransaction = dbContext.Database.BeginTransaction()) { try { if (fmodel.Id == id) { fmodel.ModifiedTime = DateTime.Now; var dbEntry = dbContext.Entry <T_FARMER_PUBLISHED_DEMAND>(fmodel); dbEntry.State = EntityState.Modified; var operatoruser = dbContext.T_USER.SingleOrDefault(x => x.WeatherCity == OperatorUserId); long operatoruserid = 0; if (operatoruser == null) { operatoruserid = dbContext.T_USER.SingleOrDefault(x => x.Id.ToString() == OperatorUserId).Id; } else { operatoruserid = operatoruser.Id; } var responsemodel = dbContext.T_FARMER_DEMAND_RESPONSE_RELATION.SingleOrDefault(x => x.DemandId == id && x.UserId == operatoruserid); dbContext.T_FARMER_DEMAND_RESPONSE_RELATION.Remove(responsemodel); } var r = await dbContext.SaveChangesAsync();//要使用异步保存,必须使用await dbTransaction.Commit(); return(r); } catch (Exception ex) { dbTransaction.Rollback(); return(0); } } } }
/// <summary> /// 同意大农户的角色申请 /// </summary> /// <param name="verificationId">角色验证记录编号</param> /// <param name="auditUserId">审核人用户编号</param> /// <param name="roleLevel">角色级别(星数)</param> /// <returns>操作成功返回true,操作失败返回false</returns> public bool ApproveFarmerVerification(long verificationId, long auditUserId, byte roleLevel) { using (var dbContext = new DuPont_TestContext()) { using (var dbTransaction = dbContext.Database.BeginTransaction()) { var farmerVerifyInfo = dbContext.T_FARMER_VERIFICATION_INFO.Find(verificationId); farmerVerifyInfo.AuditState = 1; dbContext.T_USER_ROLE_RELATION.Add(new T_USER_ROLE_RELATION { UserID = farmerVerifyInfo.UserId, AuditUserId = auditUserId, RoleID = (int)RoleType.Farmer, MemberType = true, CreateTime = TimeHelper.GetChinaLocalTime(), Star = roleLevel }); var userInfo = dbContext.T_USER.Find(farmerVerifyInfo.UserId); userInfo.Province = farmerVerifyInfo.Province; userInfo.City = farmerVerifyInfo.City; userInfo.Region = farmerVerifyInfo.Region; userInfo.Township = farmerVerifyInfo.Township; userInfo.Village = farmerVerifyInfo.Village; userInfo.UserName = farmerVerifyInfo.RealName;//将用户的真实姓名更新过去 if (userInfo.Type == (int)UserTypes.QQUser || userInfo.Type == (int)UserTypes.WeChatUser) { userInfo.PhoneNumber = farmerVerifyInfo.PhoneNumber;//将用户的最新的手机号更新过去 } userInfo.DetailedAddress = farmerVerifyInfo.DetailAddress; dbContext.Entry <T_USER>(userInfo).State = EntityState.Modified; dbContext.SaveChanges(); dbTransaction.Commit(); return(true); } } }