/// <summary>
/// 保存上传的app信息
/// </summary>
/// <param name="entity">app信息实体</param>
/// <returns></returns>
public bool SaveAppFile(T_APP_VERSION entity)
{
bool result = true;
using (var dbContext = new DuPont_TestContext())
{
var existEntity = dbContext.T_APP_VERSION.Where(a => a.Platform == entity.Platform).FirstOrDefault();
int saveRes = 0;
if (existEntity != null)
{
entity.CREATE_DATE = existEntity.CREATE_DATE;
entity.Id = existEntity.Id;
ClassValueCopyHelper.Copy(existEntity, entity);
saveRes = dbContext.SaveChanges();
}
else
{
entity.UPDATE_DATE = null;
dbContext.T_APP_VERSION.Add(entity);
saveRes = dbContext.SaveChanges();
}
}
return(result);
}
/// <summary>
/// 修改密码逻辑事物
/// </summary>
/// <param name="userInfo">用户信息</param>
/// <param name="deleteHis">所要删除的用户密码历史记录</param>
/// <returns></returns>
public bool TranUpdatePwd(T_USER userInfo, T_USER_PASSWORD_HISTORY deleteHis)
{
bool result = true;
using (var dbContext = new DuPont_TestContext())
{
using (var tran = dbContext.Database.BeginTransaction())
{
//更新用户表
int uURes = Update(userInfo);
if (uURes <= 0)
{
result = false;
}
//删除密码历史表中最老的记录
if (result && deleteHis != null)
{
var entity = dbContext.T_USER_PASSWORD_HISTORY.Where(a => a.UserID == deleteHis.UserID && a.Password == deleteHis.Password).FirstOrDefault();
dbContext.T_USER_PASSWORD_HISTORY.Remove(entity);
int delRes = dbContext.SaveChanges();
if (delRes <= 0)
{
result = false;
}
}
if (result)
{
dbContext.T_USER_PASSWORD_HISTORY.Add(new T_USER_PASSWORD_HISTORY
{
UserID = userInfo.Id,
Password = userInfo.Password,
CreateTime = DateTime.Now
});
int addRes = dbContext.SaveChanges();
if (addRes <= 0)
{
result = false;
}
}
if (result)
{
tran.Commit();
}
}
}
return(result);
}
public int Insert(T_FileInfo entity)
{
using (var dbContext = new DuPont_TestContext())
{
try
{
dbContext.T_FileInfo.Add(entity);
return(dbContext.SaveChanges());
}
catch (DbEntityValidationException dbEx)
{
var sbMessage = new StringBuilder("【EF错误】:\r\n");
if (dbEx.EntityValidationErrors != null)
{
foreach (var error in dbEx.EntityValidationErrors)
{
foreach (var errorChild in error.ValidationErrors)
{
sbMessage.AppendLine(string.Format("{0}:{1}", errorChild.PropertyName, errorChild.ErrorMessage));
}
}
}
throw new Exception(sbMessage.ToString());
}
}
}
public int Insert(IEnumerable <T_FileInfo> entities)
{
using (var dbContext = new DuPont_TestContext())
{
dbContext.T_FileInfo.AddRange(entities);
return(dbContext.SaveChanges());
}
}
public readonly int[] farmerDemandOffline = { 100503, 100504, 100505, 100506 }; //已评价、已取消、系统关闭、已关闭
public int Insert(T_FARMER_PUBLISHED_DEMAND entity)
{
using (var dbContext = new DuPont_TestContext())
{
dbContext.T_FARMER_PUBLISHED_DEMAND.Add(entity);
return(dbContext.SaveChanges());
}
}
public int Delete(IEnumerable <T_FileInfo> entities)
{
using (var dbContext = new DuPont_TestContext())
{
dbContext.T_FileInfo.RemoveRange(entities);
return(dbContext.SaveChanges());
}
}
public int Insert(T_SMS_MESSAGE entity)
{
using (var dbContext = new DuPont_TestContext())
{
dbContext.T_SMS_MESSAGE.Add(entity);
return(dbContext.SaveChanges());
}
}
public int Add <T>(List <T> entity) where T : class
{
using (var dbContext = new DuPont_TestContext())
{
dbContext.Set <T>().AddRange(entity);
return(dbContext.SaveChanges());
}
}
public int Insert(IEnumerable <T_FARMER_PUBLISHED_DEMAND> entities)
{
using (var dbContext = new DuPont_TestContext())
{
dbContext.T_FARMER_PUBLISHED_DEMAND.AddRange(entities);
return(dbContext.SaveChanges());
}
}
/// <summary>
/// 添加一条用户密码历史记录
/// </summary>
/// <param name="entity">记录实体</param>
/// <returns></returns>
public int Insert(T_USER_PASSWORD_HISTORY entity)
{
using (var dbContext = new DuPont_TestContext())
{
dbContext.T_USER_PASSWORD_HISTORY.Add(entity);
return(dbContext.SaveChanges());
}
}
/// <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);
}
}
}
public int Delete(T_FARMER_PUBLISHED_DEMAND entity)
{
if (entity != null)
{
using (var dbContext = new DuPont_TestContext())
{
dbContext.T_FARMER_PUBLISHED_DEMAND.Remove(entity);
return(dbContext.SaveChanges());
}
}
return(0);
}
public int Delete(T_FileInfo entity)
{
if (entity != null)
{
using (var dbContext = new DuPont_TestContext())
{
dbContext.T_FileInfo.Remove(entity);
return(dbContext.SaveChanges());
}
}
return(0);
}
public int Modify <T>(T entity, Expression <Func <T, bool> > wherelambda) where T : class
{
using (var dbContext = new DuPont_TestContext())
{
var dbEntry = dbContext.Set <T>().Where(wherelambda).FirstOrDefault();
if (dbEntry != null)
{
ClassValueCopyHelper.Copy(dbEntry, entity);
return(dbContext.SaveChanges());
}
}
return(0);
}
public int Delete <T>(Expression <Func <T, bool> > predicate) where T : class
{
using (var dbContext = new DuPont_TestContext())
{
var dbEntry = dbContext.Set <T>().SingleOrDefault(predicate);
if (dbEntry != null)
{
dbContext.Set <T>().Remove(dbEntry);
return(dbContext.SaveChanges());
}
}
return(0);
}
public int Delete(object id)
{
using (var dbContext = new DuPont_TestContext())
{
var dbEntry = dbContext.T_FileInfo.Find(id);
if (dbEntry != null)
{
dbContext.T_FileInfo.Remove(dbEntry);
return(dbContext.SaveChanges());
}
}
return(0);
}
public int Delete(object id)
{
using (var dbContext = new DuPont_TestContext())
{
var dbEntry = dbContext.T_FARMER_PUBLISHED_DEMAND.Find(id);
if (dbEntry != null)
{
dbContext.T_FARMER_PUBLISHED_DEMAND.Remove(dbEntry);
return(dbContext.SaveChanges());
}
}
return(0);
}
public int Update(T_SMS_MESSAGE entity)
{
using (var dbContext = new DuPont_TestContext())
{
var dbEntry = dbContext.T_SMS_MESSAGE.Find(entity.Id);
if (dbEntry != null)
{
ClassValueCopyHelper.Copy(dbEntry, entity);
return(dbContext.SaveChanges());
}
}
return(0);
}
public int Delete(Expression <Func <T_FARMER_PUBLISHED_DEMAND, bool> > predicate)
{
using (var dbContext = new DuPont_TestContext())
{
var dbEntry = dbContext.T_FARMER_PUBLISHED_DEMAND.SingleOrDefault(predicate);
if (dbEntry != null)
{
dbContext.T_FARMER_PUBLISHED_DEMAND.Remove(dbEntry);
return(dbContext.SaveChanges());
}
}
return(0);
}
/// <summary>
/// 删除一条密码历史记录
/// </summary>
/// <param name="entity">记录实体</param>
/// <returns></returns>
public int Delete(T_USER_PASSWORD_HISTORY entity)
{
if (entity != null)
{
using (var dbContext = new DuPont_TestContext())
{
var entityt = dbContext.T_USER_PASSWORD_HISTORY.Where(a => a.UserID == entity.UserID && a.Password == entity.Password).FirstOrDefault();
dbContext.T_USER_PASSWORD_HISTORY.Remove(entityt);
return(dbContext.SaveChanges());
}
}
return(0);
}
public int Update(T_FARMER_PUBLISHED_DEMAND entity)
{
using (var dbContext = new DuPont_TestContext())
{
var dbEntry = dbContext.T_FARMER_PUBLISHED_DEMAND.Find(entity.Id);
if (dbEntry != null)
{
ClassValueCopyHelper.Copy(dbEntry, entity);
return(dbContext.SaveChanges());
}
}
return(0);
}
/// <summary>
/// 增加先锋币
/// </summary>
/// <param name="userId">用户编号</param>
/// <param name="description">描述</param>
/// <param name="auditUserId">审核人用户编号</param>
/// <param name="dpoints">先锋币数.</param>
/// <returns><c>true</c> if XXXX, <c>false</c> otherwise.</returns>
/// <exception cref="System.ArgumentNullException">description</exception>
/// <exception cref="System.ArgumentException">auditUserId
/// or
/// userId</exception>
/// <exception cref="System.NotImplementedException">description</exception>
public bool AddDuPontPoint(long userId, string description, long auditUserId, int dpoints)
{
if (description == null)
{
throw new ArgumentNullException("description");
}
if (auditUserId <= 0)
{
throw new ArgumentException("auditUserId");
}
if (userId <= 0)
{
throw new ArgumentException("userId");
}
using (var dbContext = new DuPont_TestContext())
{
using (var tran = dbContext.Database.BeginTransaction())
{
var user = dbContext.T_USER.Find(userId);
if (user == null)
{
throw new ArgumentException("userId");
}
dbContext.T_PIONEERCURRENCYHISTORY.Add(new T_PIONEERCURRENCYHISTORY
{
UserId = userId,
AuditUserId = 0,
CreateTime = Utility.TimeHelper.GetChinaLocalTime(),
Description = description,
DPoint = dpoints
});
if (user.DPoint == null)
{
user.DPoint = dpoints;
}
else
{
user.DPoint += dpoints;
}
dbContext.SaveChanges();
tran.Commit();
}
}
return(false);
}
/// <summary>
/// 拒绝角色申请操作
/// </summary>
/// <param name="verificationId">角色验证记录编号</param>
/// <param name="auditUserId">审核人用户编号</param>
/// <param name="roleType">角色类型</param>
/// <returns>操作成功返回true,操作失败返回false</returns>
/// <exception cref="System.NotImplementedException"></exception>
public bool RejectVerification(long verificationId, long auditUserId, RoleType roleType)
{
using (var dbContext = new DuPont_TestContext())
{
switch (roleType)
{
case RoleType.Farmer:
var farmerVerificationInfo = dbContext.T_FARMER_VERIFICATION_INFO.Find(verificationId);
if (farmerVerificationInfo == null)
{
throw new InvalidOperationException("verificationId");
}
farmerVerificationInfo.AuditState = 2;
farmerVerificationInfo.AuditUserId = auditUserId;
break;
case RoleType.MachineryOperator:
var operatorVerificationInfo = dbContext.T_MACHINERY_OPERATOR_VERIFICATION_INFO.Find(verificationId);
if (operatorVerificationInfo == null)
{
throw new InvalidOperationException("verificationId");
}
operatorVerificationInfo.AuditState = 2;
operatorVerificationInfo.AuditUserId = auditUserId;
break;
case RoleType.Business:
var businessVerificationInfo = dbContext.T_BUSINESS_VERIFICATION_INFO.Find(verificationId);
if (businessVerificationInfo == null)
{
throw new InvalidOperationException("verificationId");
}
businessVerificationInfo.AuditState = 2;
businessVerificationInfo.AuditUserId = auditUserId;
break;
default:
throw new InvalidOperationException("roleType");
}
return(dbContext.SaveChanges() > 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);
}
}
}
/// <summary>
/// 修改农机手农机与需求对应关系
/// </summary> ///
/// <param name="UserId">审核人用户编号</param>
/// <param name="demandLevelInfoList">服务类别技能信息列表</param>
/// <returns>操作成功返回true,操作失败返回false</returns>
public bool UpdateOperatorVerification(long UserId, Dictionary <int, int> demandLevelInfoList)
{
using (var dbContext = new DuPont_TestContext())
{
using (var dbTransaction = dbContext.Database.BeginTransaction())
{
//删除原有的农机与需求对应关系
var dbEntrys = dbContext.T_USER_ROLE_DEMANDTYPELEVEL_RELATION.Where(t => t.UserId == UserId).ToList();
if (dbEntrys != null)
{
foreach (var item in dbEntrys)
{
dbContext.T_USER_ROLE_DEMANDTYPELEVEL_RELATION.Remove(item);
}
}
if (demandLevelInfoList != null && demandLevelInfoList.Count > 0)
{
demandLevelInfoList.Select(d =>
{
dbContext.T_USER_ROLE_DEMANDTYPELEVEL_RELATION.Add(new T_USER_ROLE_DEMANDTYPELEVEL_RELATION
{
UserId = UserId,
DemandId = d.Key,
CreateTime = TimeHelper.GetChinaLocalTime(),
RoleId = (int)RoleType.MachineryOperator,
Star = d.Value
});
return(d);
}).Count();
}
dbContext.SaveChanges();
dbTransaction.Commit();
return(true);
}
}
}
public int CreateUser(T_USER entity, T_USER_ROLE_RELATION rolemodel)
{
using (var dbContext = new DuPont_TestContext())
{
//创建事务，如果操作过程中出现异常，操作会回滚，防止产生脏数据
using (var tran = dbContext.Database.BeginTransaction())
{
dbContext.T_USER.Add(entity);
dbContext.SaveChanges();
rolemodel.MemberType = true;
rolemodel.UserID = entity.Id;
dbContext.T_USER_ROLE_RELATION.Add(rolemodel);
dbContext.SaveChanges();
//如果是经销商
if (rolemodel.RoleID == (int)RoleType.Dealer)
{
string controlAreaLevel = "";
if (!string.IsNullOrEmpty(entity.Village) && entity.Village != "0")
{
controlAreaLevel = entity.Village;
}
else if (!string.IsNullOrEmpty(entity.Region) && entity.Region != "0")
{
controlAreaLevel = entity.Region;
}
else if (!string.IsNullOrEmpty(entity.City) && entity.City != "0")
{
controlAreaLevel = entity.City;
}
else if (!string.IsNullOrEmpty(entity.Province) && entity.Province != "0")
{
controlAreaLevel = entity.Province;
}
else
{
throw new Exception("经销商的地址不能为空!");
}
var supplier_area = new T_SUPPLIERS_AREA
{
AID = controlAreaLevel,
CreateDateTime = DateTime.Now,
State = true,
UserID = entity.Id
};
var paras = new SqlParameter[] {
new SqlParameter("@aid", supplier_area.AID),
new SqlParameter("@createdatetime", supplier_area.CreateDateTime),
new SqlParameter("@state", supplier_area.State),
new SqlParameter("@userid", supplier_area.UserID)
};
var sql = "insert into T_SUPPLIERS_AREA(aid,createdatetime,state,userid)";
sql += "values(@aid,@createdatetime,@state,@userid)";
dbContext.Database.ExecuteSqlCommand(sql, paras);
dbContext.SaveChanges();
}
tran.Commit();//提交事务
return(1);
}
}
}
public long UpdateUserInfo(T_USER model, Dictionary <int, byte?> demandLevelInfoList, long loginid)
{
using (var dbContext = new DuPont_TestContext())
{
//创建事务，如果操作过程中出现异常，操作会回滚，防止产生脏数据
using (var tran = dbContext.Database.BeginTransaction())
{
//数据库操作
#region 修改用户基本信息
T_USER updmodel = dbContext.T_USER.Find(model.Id);
updmodel.UserName = model.UserName;
//updmodel.PhoneNumber = model.PhoneNumber;
updmodel.DPoint = model.DPoint;
updmodel.Province = model.Province;
updmodel.City = model.City;
updmodel.Region = model.Region;
updmodel.Township = model.Township;
updmodel.Village = model.Village;
updmodel.ModifiedUserId = loginid;
updmodel.ModifiedTime = Utility.TimeHelper.GetChinaLocalTime();
//执行修改操作
var upd = dbContext.T_USER.Find(updmodel.Id);
if (upd != null)
{
ClassValueCopyHelper.Copy(upd, updmodel);
dbContext.SaveChanges();
}
#endregion
#region 修改用户的角色信息以及技能信息
//1获取各角色的最高星星数
byte?farmerstar = demandLevelInfoList[0];
byte?operatorstar = 0;
byte?businesstar = 0;
T_USER_ROLE_DEMANDTYPELEVEL_RELATION skillmodel = new T_USER_ROLE_DEMANDTYPELEVEL_RELATION();
//农机手
for (int i = 100101; i <= 100108; i++)
{
//添加农机手的技能信息及星星数
skillmodel = new T_USER_ROLE_DEMANDTYPELEVEL_RELATION {
UserId = model.Id, RoleId = (int)RoleType.MachineryOperator, DemandId = i, Star = Convert.ToInt32(demandLevelInfoList[i]), CreateTime = Utility.TimeHelper.GetChinaLocalTime()
};
if (demandLevelInfoList[i] > 0)
{
//先删除原有记录
var dbEntry = dbContext.T_USER_ROLE_DEMANDTYPELEVEL_RELATION.SingleOrDefault(u => u.UserId == skillmodel.UserId && u.RoleId == skillmodel.RoleId && u.DemandId == skillmodel.DemandId);
if (dbEntry != null)
{
dbContext.T_USER_ROLE_DEMANDTYPELEVEL_RELATION.Remove(dbEntry);
dbContext.SaveChanges();
}
//执行添加操作
dbContext.T_USER_ROLE_DEMANDTYPELEVEL_RELATION.Add(skillmodel);
dbContext.SaveChanges();
}
else
{
//删除原有记录
var dbEntry = dbContext.T_USER_ROLE_DEMANDTYPELEVEL_RELATION.SingleOrDefault(u => u.UserId == skillmodel.UserId && u.RoleId == skillmodel.RoleId && u.DemandId == skillmodel.DemandId);
if (dbEntry != null)
{
dbContext.T_USER_ROLE_DEMANDTYPELEVEL_RELATION.Remove(dbEntry);
dbContext.SaveChanges();
}
}
}
//获取农机手角色的最大星星数
var operatorstarmodel = dbContext.T_USER_ROLE_DEMANDTYPELEVEL_RELATION.Where(u => u.UserId == model.Id && u.RoleId == (int)RoleType.MachineryOperator).OrderByDescending(u => u.Star).FirstOrDefault();
if (operatorstarmodel != null)
{
operatorstar = (byte?)operatorstarmodel.Star;
}
//产业商
for (int i = 100201; i <= 100202; i++)
{
//添加产业商的技能信息及星星数
skillmodel = new T_USER_ROLE_DEMANDTYPELEVEL_RELATION {
UserId = model.Id, RoleId = (int)RoleType.Business, DemandId = i, Star = Convert.ToInt32(demandLevelInfoList[i]), CreateTime = Utility.TimeHelper.GetChinaLocalTime()
};
if (demandLevelInfoList[i] > 0)
{ //先删除原有记录
var dbEntry = dbContext.T_USER_ROLE_DEMANDTYPELEVEL_RELATION.SingleOrDefault(u => u.UserId == skillmodel.UserId && u.RoleId == skillmodel.RoleId && u.DemandId == skillmodel.DemandId);
if (dbEntry != null)
{
dbContext.T_USER_ROLE_DEMANDTYPELEVEL_RELATION.Remove(dbEntry);
dbContext.SaveChanges();
}
//执行添加操作
dbContext.T_USER_ROLE_DEMANDTYPELEVEL_RELATION.Add(skillmodel);
dbContext.SaveChanges();
}
else
{
//删除原有记录
var dbEntry = dbContext.T_USER_ROLE_DEMANDTYPELEVEL_RELATION.SingleOrDefault(u => u.UserId == skillmodel.UserId && u.RoleId == skillmodel.RoleId && u.DemandId == skillmodel.DemandId);
if (dbEntry != null)
{
dbContext.T_USER_ROLE_DEMANDTYPELEVEL_RELATION.Remove(dbEntry);
dbContext.SaveChanges();
}
}
}
//获取产业商角色的最大星星数
var businessstarmodel = dbContext.T_USER_ROLE_DEMANDTYPELEVEL_RELATION.Where(u => u.UserId == model.Id && u.RoleId == (int)RoleType.Business).OrderByDescending(u => u.Star).FirstOrDefault();
if (businessstarmodel != null)
{
businesstar = (byte?)businessstarmodel.Star;
}
//2判断各角色的星星数是否大于0，大于0执行添加操作，如果之前已经存在该角色的记录信息先删除在添加，等于0执行删除操作。
T_USER_ROLE_RELATION rolemodel = new T_USER_ROLE_RELATION();
if (farmerstar >= 0)//ww增加=，否则会删除角色表的数据
{
rolemodel = new T_USER_ROLE_RELATION {
UserID = model.Id, MemberType = true, RoleID = (int)RoleType.Farmer, Star = farmerstar, AuditUserId = loginid, CreateTime = Utility.TimeHelper.GetChinaLocalTime()
};
//先删除原有记录
var dbEntry = dbContext.T_USER_ROLE_RELATION.SingleOrDefault(u => u.MemberType && u.UserID == rolemodel.UserID && u.RoleID == rolemodel.RoleID);
if (dbEntry != null)
{
dbContext.T_USER_ROLE_RELATION.Remove(dbEntry);
dbContext.SaveChanges();
}
//执行添加操作
dbContext.T_USER_ROLE_RELATION.Add(rolemodel);
dbContext.SaveChanges();
}
else
{
//删除原有记录
var dbEntry = dbContext.T_USER_ROLE_RELATION.SingleOrDefault(u => u.MemberType && u.UserID == model.Id && u.RoleID == (int)RoleType.Farmer);
if (dbEntry != null)
{
dbContext.T_USER_ROLE_RELATION.Remove(dbEntry);
dbContext.SaveChanges();
}
}
if (operatorstar > 0)
{
rolemodel = new T_USER_ROLE_RELATION {
UserID = model.Id, MemberType = true, RoleID = (int)RoleType.MachineryOperator, Star = operatorstar, AuditUserId = loginid, CreateTime = Utility.TimeHelper.GetChinaLocalTime()
};
//先删除原有记录
var dbEntry = dbContext.T_USER_ROLE_RELATION.SingleOrDefault(u => u.MemberType && u.UserID == rolemodel.UserID && u.RoleID == rolemodel.RoleID);
if (dbEntry != null)
{
dbContext.T_USER_ROLE_RELATION.Remove(dbEntry);
dbContext.SaveChanges();
}
//执行添加操作
dbContext.T_USER_ROLE_RELATION.Add(rolemodel);
dbContext.SaveChanges();
}
else
{
//删除原有记录
var dbEntry = dbContext.T_USER_ROLE_RELATION.SingleOrDefault(u => u.MemberType && u.UserID == model.Id && u.RoleID == (int)RoleType.MachineryOperator);
if (dbEntry != null)
{
dbContext.T_USER_ROLE_RELATION.Remove(dbEntry);
dbContext.SaveChanges();
}
}
if (businesstar > 0)
{
rolemodel = new T_USER_ROLE_RELATION {
UserID = model.Id, MemberType = true, RoleID = (int)RoleType.Business, Star = businesstar, AuditUserId = loginid, CreateTime = Utility.TimeHelper.GetChinaLocalTime()
};
//先删除原有记录
var dbEntry = dbContext.T_USER_ROLE_RELATION.SingleOrDefault(u => u.MemberType && u.UserID == rolemodel.UserID && u.RoleID == rolemodel.RoleID);
if (dbEntry != null)
{
dbContext.T_USER_ROLE_RELATION.Remove(dbEntry);
dbContext.SaveChanges();
}
//执行添加操作
dbContext.T_USER_ROLE_RELATION.Add(rolemodel);
dbContext.SaveChanges();
}
else
{
//删除原有记录
var dbEntry = dbContext.T_USER_ROLE_RELATION.SingleOrDefault(u => u.MemberType && u.UserID == model.Id && u.RoleID == (int)RoleType.Business);
if (dbEntry != null)
{
dbContext.T_USER_ROLE_RELATION.Remove(dbEntry);
dbContext.SaveChanges();
}
}
#endregion
tran.Commit();//提交事务
return(1);
}
}
}