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