/// <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); }
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 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 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); }
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); } } }
public JsonResult Detail(Int64 UserId, int verificationId, RoleType roleId, string remoteApiUrl) { //检查访问权限 CheckPermission(); //非管理员时检查角色 if (this.UserInfo.IsSuperAdmin == false) { var myRoleList = this.adminUserRepository.GetRoles(UserId); if (myRoleList != null && myRoleList.Count > 0) { var isAdmin = Array.IndexOf(myRoleList.Select(role => role.RoleID).ToArray(), (int)RoleType.Admin) > -1; if (!isAdmin) { var suppliers_SareaModel = suppliers_SareaRespository.GetManageArea(UserId); var bo = false; object viewModel = null; if (suppliers_SareaModel != null && suppliers_SareaModel.Count > 0)//判断是否有管理区域 { switch (roleId) { case RoleType.Farmer: var farmerVerificationInfo = this.farmerVerificationRepository.GetByKey(verificationId); viewModel = new FarmerVerificationInfoViewModel(); ClassValueCopyHelper.Copy(viewModel, farmerVerificationInfo); bo = suppliers_SareaModel.Any(model => { return(farmerVerificationInfo.Province == model.AID || farmerVerificationInfo.City == model.AID || farmerVerificationInfo.Region == model.AID); }); break; case RoleType.MachineryOperator: var machineOperVerificationInfo = this.machineryOperatorVerificationRepository.GetByKey(verificationId); viewModel = new MachineOperatorVerificationInfoViewModel(); ClassValueCopyHelper.Copy(viewModel, machineOperVerificationInfo); bo = suppliers_SareaModel.Any(model => { return(machineOperVerificationInfo.Province == model.AID || machineOperVerificationInfo.City == model.AID || machineOperVerificationInfo.Region == model.AID); }); break; case RoleType.Business: var businessVerificationInfo = this.businessVerificationRepository.GetByKey(verificationId); viewModel = new BusinessVerificationInfoViewModel(); ClassValueCopyHelper.Copy(viewModel, businessVerificationInfo); bo = suppliers_SareaModel.Any(model => { return(businessVerificationInfo.Province == model.AID || businessVerificationInfo.City == model.AID || businessVerificationInfo.Region == model.AID); }); break; } } if (!bo) { var result = new ResponseResult <FarmerVerificationInfoViewModel>(); result.IsSuccess = false; result.Message = "没有符合条件的数据"; return(Json(result)); } } } } var roleType = (RoleType)roleId; string viewName = string.Empty; switch (roleType) { case RoleType.Farmer: viewName = "Farmer_Detail"; var result = new ResponseResult <FarmerVerificationInfoViewModel>(); var farmerVerificationInfo = this.farmerVerificationRepository.GetByKey(verificationId); FarmerVerificationInfoViewModel viewModel = new FarmerVerificationInfoViewModel(); viewModel.RemoteApiUrl = remoteApiUrl; ClassValueCopyHelper.Copy(viewModel, farmerVerificationInfo); //获取用户的省市区域信息 string addressCodes = string.Format("{0}|{1}|{2}|{3}|{4}", farmerVerificationInfo.Province, farmerVerificationInfo.City, farmerVerificationInfo.Region, farmerVerificationInfo.Township, farmerVerificationInfo.Village); var addressCodeNames = this.areaRepository.GetAreaNamesBy(addressCodes).Split('|'); viewModel.UserName = farmerVerificationInfo.RealName; viewModel.PhoneNumber = farmerVerificationInfo.PhoneNumber; viewModel.DetailAddress = farmerVerificationInfo.DetailAddress; if (addressCodeNames != null && addressCodeNames.Length == 5) { viewModel.ProvinceName = addressCodeNames[0]; viewModel.CityName = addressCodeNames[1]; viewModel.RegionName = addressCodeNames[2]; viewModel.TownshipName = addressCodeNames[3]; viewModel.VillageName = addressCodeNames[4]; } result.Entity = viewModel; result.IsSuccess = true; return(new JsonResultEx(result)); case RoleType.MachineryOperator: viewName = "Machinery_Operator_Detail"; var mresult = new ResponseResult <MachineOperatorVerificationInfoViewModel>(); var machineryOperatorVerificationInfo = this.machineryOperatorVerificationRepository.GetByKey(verificationId); var operatorViewModel = new MachineOperatorVerificationInfoViewModel(); operatorViewModel.RemoteApiUrl = remoteApiUrl; ClassValueCopyHelper.Copy(operatorViewModel, machineryOperatorVerificationInfo); //获得农机列表 if (string.IsNullOrEmpty(machineryOperatorVerificationInfo.Machinery) == false) { var machineList = JsonHelper.FromJsonTo <List <DuPont.Models.Models.ProductInfo> >(machineryOperatorVerificationInfo.Machinery); operatorViewModel.MachineList = machineList; } //获取农机手提供的图片信息 if (string.IsNullOrEmpty(machineryOperatorVerificationInfo.PicturesIds) == false) { var picIdstrs = machineryOperatorVerificationInfo.PicturesIds.Split(','); var picIds = new long[picIdstrs.Length]; int index = 0; picIdstrs.Select(m => { long fileId = 0; if (long.TryParse(m, out fileId)) { picIds[index++] = fileId; } return(m); }).Count(); var fileList = this.fileInfoRepository.GetAll(m => picIds.Contains(m.Id)); if (fileList != null) { operatorViewModel.Pictures = fileList.Select(m => m.Path).ToArray(); } } operatorViewModel.UserName = machineryOperatorVerificationInfo.RealName; operatorViewModel.PhoneNumber = machineryOperatorVerificationInfo.PhoneNumber; //获取省市区县信息 var addressNames = this.areaRepository.GetAreaNamesBy(string.Format("{0}|{1}|{2}|{3}|{4}", machineryOperatorVerificationInfo.Province, machineryOperatorVerificationInfo.City, machineryOperatorVerificationInfo.Region, machineryOperatorVerificationInfo.Township, machineryOperatorVerificationInfo.Village)); if (addressNames != null && addressNames != "") { var addrArray = addressNames.Split('|'); operatorViewModel.ProvinceName = addrArray[0]; operatorViewModel.CityName = addrArray[1]; operatorViewModel.RegionName = addrArray[2]; operatorViewModel.Township = addrArray[3]; operatorViewModel.Village = addrArray[4]; } operatorViewModel.DetailAddress = machineryOperatorVerificationInfo.DetailAddress; operatorViewModel.SkillList = this.sysDictionaryRespository.GetAll(m => m.ParentCode == 100100).ToList(); mresult.Entity = operatorViewModel; mresult.IsSuccess = true; return(new JsonResultEx(mresult)); case RoleType.Business: viewName = "Business_Detail"; var bresult = new ResponseResult <BusinessVerificationInfoViewModel>(); var businessVerificationInfo = this.businessVerificationRepository.GetByKey(verificationId); var businessViewModel = new BusinessVerificationInfoViewModel(); businessViewModel.RemoteApiUrl = remoteApiUrl; ClassValueCopyHelper.Copy(businessViewModel, businessVerificationInfo); //获取产业商提供的图片信息 if (string.IsNullOrEmpty(businessVerificationInfo.PictureIds) == false) { var picIdstrs = businessVerificationInfo.PictureIds.Split(','); var picIds = new long[picIdstrs.Length]; int index = 0; picIdstrs.Select(m => { long fileId = 0; if (long.TryParse(m, out fileId)) { picIds[index++] = fileId; } return(m); }).Count(); var fileList = this.fileInfoRepository.GetAll(m => picIds.Contains(m.Id)); if (fileList != null && fileList.Count > 0) { businessViewModel.Pictures = fileList.Select(m => m.Path).ToArray(); } } businessViewModel.UserName = businessVerificationInfo.RealName; businessViewModel.PhoneNumber = businessVerificationInfo.PhoneNumber; //获取省市区县信息 addressNames = this.areaRepository.GetAreaNamesBy(string.Format("{0}|{1}|{2}|{3}|{4}", businessVerificationInfo.Province, businessVerificationInfo.City, businessVerificationInfo.Region, businessVerificationInfo.Township, businessVerificationInfo.Village)); if (addressNames != null && addressNames != "") { var addrArray = addressNames.Split('|'); businessViewModel.ProvinceName = addrArray[0]; businessViewModel.CityName = addrArray[1]; businessViewModel.RegionName = addrArray[2]; businessViewModel.TownshipName = addrArray[3]; businessViewModel.VillageName = addrArray[4]; } businessViewModel.DetailAddress = businessVerificationInfo.DetailAddress; businessViewModel.SkillList = this.sysDictionaryRespository.GetAll(m => m.ParentCode == 100200).ToList(); bresult.Entity = businessViewModel; bresult.IsSuccess = true; return(new JsonResultEx(bresult)); } return(null); }
/// <summary> /// 获取后台指定角色用户列表 /// </summary> /// <param name="predicate"></param> /// <param name="roleType"></param> /// <param name="pageIndex"></param> /// <param name="pageSize"></param> /// <param name="totalCount"></param> /// <returns></returns> public List <BackgroundUserModel> GetBackgroundUserList(System.Linq.Expressions.Expression <Func <T_ADMIN_USER, bool> > predicate, RoleType roleType, int pageIndex, int pageSize, out int totalCount) { var roleTypeId = (int)roleType; using (var ctx = GetDbContextInstance()) { List <BackgroundUserModel> backgroundUserList = null; if (roleType != RoleType.Unknown) { var query = from u in ctx.Set <T_ADMIN_USER>().Where(p => !p.IsSuperAdmin).Where(predicate) join userRole_RL in ctx.Set <T_USER_ROLE_RELATION>() on u.Id equals userRole_RL.UserID where userRole_RL.RoleID == roleTypeId && !userRole_RL.MemberType select new { User = u, userRole_RL.RoleID }; totalCount = query.Count(); var data = query.OrderByDescending(p => p.User.CreateTime) .Skip((pageIndex - 1) * pageSize) .Take(pageSize) .ToList(); if (totalCount > 0) { backgroundUserList = new List <BackgroundUserModel>(); foreach (var user in data) { var bgUserModelItem = new BackgroundUserModel(); ClassValueCopyHelper.Copy(bgUserModelItem, user.User); bgUserModelItem.RoleName = ((RoleType)user.RoleID).GetDescription(); backgroundUserList.Add(bgUserModelItem); } } } else { var query = from u in ctx.Set <T_ADMIN_USER>().Where(p => !p.IsSuperAdmin).Where(predicate) join userRole_RL in ctx.Set <T_USER_ROLE_RELATION>() on u.Id equals userRole_RL.UserID where !userRole_RL.MemberType select new { User = u, userRole_RL.RoleID }; totalCount = query.Count(); var data = query.OrderByDescending(p => p.User.CreateTime) .Skip((pageIndex - 1) * pageSize) .Take(pageSize) .ToList(); if (totalCount > 0) { backgroundUserList = new List <BackgroundUserModel>(); foreach (var user in data) { var bgUserModelItem = new BackgroundUserModel(); ClassValueCopyHelper.Copy(bgUserModelItem, user.User); bgUserModelItem.RoleName = ((RoleType)user.RoleID).GetDescription(); backgroundUserList.Add(bgUserModelItem); } } } return(backgroundUserList); } }