public IActionResult DecompInfo(HotelRequestPayload payload) { using (_dbContext) { var query = _dbContext.HotelRoom.Where(x => x.HotelUuid.ToString() == payload.Kw && x.IsDelete == 0); query = query.OrderByDescending(x => x.Id); var list = query.Paged(payload.CurrentPage, payload.PageSize).ToList(); var totalCount = query.Count(); var response = ResponseModelFactory.CreateResultInstance; response.SetData(list, totalCount); ToLog.AddLog("查询", "成功:查询:酒店房型信息列表数据", _dbContext); return(Ok(response)); } }
/// <summary> /// 删除菜单 /// </summary> /// <param name="status">菜单状态</param> /// <param name="ids">菜单ID字符串,多个以逗号隔开</param> /// <returns></returns> private ResponseModel UpdateStatus(CommonEnum.Status status, string ids) { using (_dbContext) { var parameters = ids.Split(",").Select((id, index) => new SqlParameter(string.Format("@p{0}", index), id)).ToList(); var parameterNames = string.Join(", ", parameters.Select(p => p.ParameterName)); var sql = string.Format("UPDATE SystemMenu SET Status=@Status WHERE SystemMenuUUID IN ({0})", parameterNames); parameters.Add(new SqlParameter("@Status", (int)status)); _dbContext.Database.ExecuteSqlRaw(sql, parameters); ToLog.AddLog("禁用", "成功:禁用:系统菜单管理列表数据", _dbContext); var response = ResponseModelFactory.CreateInstance; return(response); } }
/// <summary> /// 删除 /// </summary> /// <param name="isDeleted"></param> /// <param name="ids">ID字符串,多个以逗号隔开</param> /// <returns></returns> private ResponseModel UpdateIsDelete(CommonEnum.IsDeleted isDeleted, string ids) { using (_dbContext) { var parameters = ids.Split(",").Select((id, index) => new SqlParameter(string.Format("@p{0}", index), id)).ToList(); var parameterNames = string.Join(", ", parameters.Select(p => p.ParameterName)); var sql = string.Format("UPDATE SpecialPick SET IsDelete=@IsDel WHERE SpecialPickUUID IN ({0})", parameterNames); parameters.Add(new SqlParameter("@IsDel", (int)isDeleted)); _dbContext.Database.ExecuteSqlRaw(sql, parameters); ToLog.AddLog("删除", "成功:删除:特色采摘列表数据", _dbContext); var response = ResponseModelFactory.CreateInstance; return(response); } }
/// <summary> /// 删除角色 /// </summary> /// <param name="IsDeleted"></param> /// <param name="ids">角色ID字符串,多个以逗号隔开</param> /// <returns></returns> private ResponseModel UpdateIsDelete(CommonEnum.IsDeleted IsDeleted, string ids) { using (_dbContext) { var parameters = ids.Split(",").Select((id, index) => new SqlParameter(string.Format("@p{0}", index), id)).ToList(); var parameterNames = string.Join(", ", parameters.Select(p => p.ParameterName)); var sql = string.Format("UPDATE Propaganda SET IsDeleted=@IsDeleted WHERE PropagandaTypeUuid IN ({0})", parameterNames); parameters.Add(new SqlParameter("@IsDeleted", (int)IsDeleted)); _dbContext.Database.ExecuteSqlRaw(sql, parameters); ToLog.AddLog("删除", "成功:删除:宣传队伍类型信息一条数据", _dbContext); var response = ResponseModelFactory.CreateInstance; return(response); } }
public IActionResult List(RoleRequestPayload payload) { var response = ResponseModelFactory.CreateResultInstance; using (_dbContext) { var query = from a in _dbContext.DepartmentDeclare where a.IsDeleted == 0 select new { DepartmentDeclareUuid = a.DepartmentDeclareUuid, Id = a.Id, DeclareName = a.DeclareName, //姓名 DeclareDepartment = _dbContext.Department.FirstOrDefault(x => x.DepartmentUuid == Guid.Parse(a.DeclareDepartment)).Name.ToString(), //部门 DeclareTime = a.DeclareTime, //时间 BonusPoint = a.BonusPoint, //加分项 PlusScore = a.PlusScore, //加分值 PlusContent = a.PlusContent, //加分内容 Deduction = a.Deduction, //减分项 DeductionScore = a.DeductionScore, //减分值 DeductionContent = a.DeductionContent, //加分内容 Remark = a.Remark, //备注 EstablishName = a.EstablishName, //添加人 AuditOpinion = a.AuditOpinion, //审核意见 AuditStatus = a.AuditStatus, //审核状态 IsDeleted = a.IsDeleted, //是否删除 }; //姓名查询 if (!string.IsNullOrEmpty(payload.Kw)) { query = query.Where(x => x.DeclareName.Contains(payload.Kw.Trim())); } //时间查询 if (!string.IsNullOrEmpty(payload.kwendtime)) { query = query.Where(x => x.DeclareTime.Contains(payload.kwendtime.Trim())); } //排序 if (payload.FirstSort != null) { query = query.OrderBy(payload.FirstSort.Field, payload.FirstSort.Direct == "DESC"); } var list = query.Paged(payload.CurrentPage, payload.PageSize).ToList(); var totalCount = query.Count(); response.SetData(list, totalCount); ToLog.AddLog("查询", "成功:查询:绩效申报信息数据", _dbContext); return(Ok(response)); } }
public IActionResult Edit(forestViewModel model) { var response = ResponseModelFactory.CreateInstance; using (_dbContext) { var entity = _dbContext.Woods.FirstOrDefault(x => x.WoodsUuid == model.WoodsUuid); if (entity == null) { response.SetFailed("不存在"); return(Ok(response)); } if (_dbContext.Woods.Count(x => x.ShebeiId == model.ShebeiId && x.WoodsUuid != model.WoodsUuid) > 0) { response.SetFailed("设备ID已存在"); return(Ok(response)); } entity.ForestName = model.ForestName; //entity.ForestAddress = model.ForestAddress; entity.ShebeiId = model.ShebeiId; entity.ShebeiType = model.ShebeiType; entity.ShebeiAddress = model.ShebeiAddress; entity.ManagePhone = model.ManagePhone; if (model.MapRegion != "" && model.MapRegion != null) { model.MapRegion = model.MapRegion.Replace("0,0-", ""); } if (model.MapRegion != "0,0") { entity.MapRegion = model.MapRegion; } if (model.MapRegion == null || model.MapRegion == "" || model.MapRegion == "0,0") { entity.MapRegion = null; } entity.Lon = model.Lon; entity.Lat = model.Lat; entity.Guanliren = model.Guanliren; entity.ShebeiStaues = model.ShebeiStaues; int res = _dbContext.SaveChanges(); if (res > 0) { ToLog.AddLog("编辑", "成功:编辑:森林防火设备信息一条数据", _dbContext); } response = ResponseModelFactory.CreateInstance; return(Ok(response)); } }
public IActionResult Edit(SettleInfoModel model) { var response = ResponseModelFactory.CreateInstance; if (ConfigurationManager.AppSettings.IsTrialVersion) { response.SetIsTrial(); return(Ok(response)); } using (_dbContext) { var tBool = false; var query = _dbContext.Town.Where(x => x.IsDeleted != 1).ToList(); foreach (var item in query.Where(item => model.PlaceAbode.Contains(item.TownName))) { tBool = true; } if (!tBool) { response.SetFailed("居住地请包含村镇"); return(Ok(response)); } var entity = _dbContext.SettleInfo.FirstOrDefault(x => x.SettleUuid == model.SettleUuid); entity.Name = model.Name; entity.Sex = model.Sex; if (!string.IsNullOrEmpty(model.Birthdate)) { entity.Birthdate = Convert.ToDateTime(model.Birthdate).ToString("yyyy-MM-dd"); } entity.NativePlace = model.NativePlace; entity.PlaceAbode = model.PlaceAbode; if (!string.IsNullOrEmpty(model.SettleTime)) { entity.SettleTime = Convert.ToDateTime(model.SettleTime).ToString("yyyy-MM-dd"); } entity.QianYiDe = model.QianYiDe; entity.IdentityCard = model.IdentityCard; int res = _dbContext.SaveChanges(); if (res > 0) { ToLog.AddLog("编辑", "成功:编辑:落户人员信息一条数据", _dbContext); } response.SetSuccess("修改成功"); return(Ok(response)); } }
public IActionResult GetEdit(AirPolluViewModel model) { var response = ResponseModelFactory.CreateInstance; if (string.IsNullOrEmpty(model.BarTime) || string.IsNullOrEmpty(model.NowShuzhi .Trim())) { response.SetFailed("请输入时间和当日数值"); return(Ok(response)); } using (_dbContext) { var entity = _dbContext.Barometric.FirstOrDefault(x => x.BarometricUuid == model.BarometricUuid && x.IsDeleted == 0); if (entity == null) { response.SetFailed("该信息不存在"); return(Ok(response)); } var time = Convert.ToDateTime(model.BarTime).ToString("yyyy-MM-dd"); if (entity.BarTime != time) { if (_dbContext.Barometric.Any(x => x.BarTime == time && x.IsDeleted == 0)) { response.SetFailed("该时间已存在记录"); return(Ok(response)); } } entity.BarTime = time; entity.NowShuzhi = model.NowShuzhi; entity.Linjie = model.Linjie; //_dbContext.Barometric.Add(entity); var num = _dbContext.SaveChanges(); if (num > 0) { ToLog.AddLog("编辑", "成功:编辑:大气防治信息一条数据", _dbContext); response.SetSuccess(); } else { response.SetFailed("修改失败"); } return(Ok(response)); } }
/// <summary> /// 删除 /// </summary> /// <param name="isDeleted"></param> /// <param name="ids">ID字符串,多个以逗号隔开</param> /// <returns></returns> private ResponseModel UpdateIsDelete(CommonEnum.IsDeleted isDeleted, string ids) { using (_dbContext) { var parameters = ids.Split(",").Select((id, index) => new SqlParameter(string.Format("@p{0}", index), id)).ToList(); var parameterNames = string.Join(", ", parameters.Select(p => p.ParameterName)); var sql = string.Format("UPDATE ScenicSpot SET IsDelete=@IsDel WHERE ScenicSpotUUID IN ({0})", parameterNames); var sql2 = string.Format("DELETE FROM Attractions WHERE SceientUuid IN ({0})", parameterNames); parameters.Add(new SqlParameter("@IsDel", (int)isDeleted)); _dbContext.Database.ExecuteSqlRaw(sql, parameters); _dbContext.Database.ExecuteSqlRaw(sql2, parameters); ToLog.AddLog("删除", "成功:删除:景点介绍管理列表数据(景点已不存在,已删除景点相关的用户打卡记录也已删除)", _dbContext); var response = ResponseModelFactory.CreateInstance; return(response); } }
/// <summary> /// 删除 /// </summary> /// <param name="command"></param> /// <param name="ids">ID字符串,多个以逗号隔开</param> /// <returns></returns> private ResponseModel detupdate(string command, string ids) { if (command == "删除" || command == "delete") { _dbContext.Database.ExecuteSqlRaw("update ArticleType set IsDeleted = '1' where ID in(" + ids + ")"); ToLog.AddLog("删除", "成功:删除:文章类型列表数据", _dbContext); } else if (command == "恢复" || command == "recover") { _dbContext.Database.ExecuteSqlRaw("update ArticleType set IsDeleted='0' where ID in(" + ids + ")"); ToLog.AddLog("恢复", "成功:恢复:文章类型列表数据", _dbContext); } var response = ResponseModelFactory.CreateResultInstance; return(response); }
public IActionResult GetEdit(YqfkrybViewModel model) { var response = ResponseModelFactory.CreateInstance; if (ConfigurationManager.AppSettings.IsTrialVersion) { response.SetIsTrial(); return(Ok(response)); } using (_dbContext) { var entity = _dbContext.Yqfkryb.FirstOrDefault(x => x.Yqfkrybuuid == model.Yqfkrybuuid); entity.Name = model.Name; entity.Attention = model.Attention; entity.IdCard = model.IdCard; entity.OwnedNetwork = model.OwnedNetwork; entity.ReasonForConcern = model.ReasonForConcern; entity.Sex = model.Sex; entity.EpidemicPreventionAndControlStatus = model.EpidemicPreventionAndControlStatus; entity.ContactPhone = model.ContactPhone; entity.ServicePremises = model.ServicePremises; entity.IsolationTime = model.IsolationTime; entity.CurrentAddress = model.CurrentAddress; entity.Origin = model.Origin; entity.WhereToGo = model.WhereToGo; entity.ToAddress = model.ToAddress; entity.FamilyMemberContactInformation = model.FamilyMemberContactInformation; entity.GoToAddressContact = model.GoToAddressContact; entity.ContactPhoneNumber = model.ContactPhoneNumber; entity.ReturnOrEstimatedReturnTime = model.ReturnOrEstimatedReturnTime; entity.Transportation = model.Transportation; entity.YesNoSuspectedFever = model.YesNoSuspectedFever; entity.CheckMethod = model.CheckMethod; entity.NameOfResponsibleDoctor = model.NameOfResponsibleDoctor; entity.PhoneNumberOfResponsibleDoctor = model.PhoneNumberOfResponsibleDoctor; entity.ServiceMemberInformation = model.ServiceMemberInformation; entity.GuardianInformation = model.GuardianInformation; entity.Remarks = model.Remarks; int res = _dbContext.SaveChanges(); if (res > 0) { ToLog.AddLog("编辑", "成功:编辑:疫情防控人员信息一条数据", _dbContext); } response.SetSuccess("修改成功"); return(Ok(response)); } }
public IActionResult CpcCreate(dynamic model) { var response = ResponseModelFactory.CreateInstance; using (_dbContext) { var entity = new HaikanSmartTownCockpit.Api.Entities.Userinfoty(); string residence = model.residence; string town = model.town; if (!residence.Contains(town)) { response.SetFailed("住址不属于该村镇"); return(Ok(response)); } entity.UserInfoUuid = Guid.NewGuid(); entity.RealName = model.realName; entity.Sex = model.sex; entity.Birth = model.birth; entity.Education = model.education; entity.Category = model.category; entity.Partybranch = model.partybranch; entity.JoinDate = model.joinDate; entity.Phone = model.phone; entity.Residence = model.residence; entity.Work = model.work; entity.DyStaues = "1"; DateTime now = DateTime.Now; DateTime birth = model.birth; int age = now.Year - birth.Year; if (now.Month < birth.Month || (now.Month == birth.Month && now.Day < birth.Day)) { age--; } entity.Age = age < 0 ? 0 : age; entity.AddTime = DateTime.Now.ToString("yyyy-MM-dd"); entity.AddPeople = AuthContextService.CurrentUser.DisplayName; entity.IsDeleted = 0; _dbContext.Userinfoty.Add(entity); int res = _dbContext.SaveChanges(); if (res > 0) { ToLog.AddLog("添加", "成功:添加:党员信息一条数据", _dbContext); } response.SetSuccess("添加成功"); return(Ok(response)); } }
public IActionResult ExportPass(string ids) { var response = ResponseModelFactory.CreateResultInstance; using (_dbContext) { if (ids != null) { var parameters = ids.Split(","); for (int i = 0; i < parameters.Length; i++) { parameters[i] = parameters[i].ToUpper(); } var query = _dbContext.Organization.Where(x => x.IsDeleted != 1 && parameters.Contains(x.OrganizationUuid.ToString())).Select(x => new HaikanSmartTownCockpit.Api.Entities.Organization { OrganizationName = x.OrganizationName, OrganizationRemarks = x.OrganizationRemarks }).ToList(); string sWebRootFolder = _hostingEnvironment.WebRootPath + "\\UploadFiles\\ImportBuidingExcel\\"; string uploadtitle = "工会信息导出" + DateTime.Now.ToString("yyyyMMddHHmmss"); string sFileName = $"{sWebRootFolder + uploadtitle}.xlsx"; //CuisineViewModel model = new CuisineViewModel(); //model.Demos = query; TablesToExcel(query, sFileName); response.SetData("\\UploadFiles\\ImportBuidingExcel\\" + uploadtitle + ".xlsx"); ToLog.AddLog("导出", "成功:导出:工会信息数据", _dbContext); return(Ok(response)); } else { var query = _dbContext.Organization.Where(x => x.IsDeleted != 1).Select(x => new HaikanSmartTownCockpit.Api.Entities.Organization { OrganizationName = x.OrganizationName, OrganizationRemarks = x.OrganizationRemarks }).ToList(); string sWebRootFolder = _hostingEnvironment.WebRootPath + "\\UploadFiles\\ImportBuidingExcel\\"; string uploadtitle = "工会信息导出" + DateTime.Now.ToString("yyyyMMddHHmmss"); string sFileName = $"{sWebRootFolder + uploadtitle}.xlsx"; //CuisineViewModel model = new CuisineViewModel(); //model.Demos = query; TablesToExcel(query, sFileName); response.SetData("\\UploadFiles\\ImportBuidingExcel\\" + uploadtitle + ".xlsx"); ToLog.AddLog("导出", "成功:导出:工会信息数据", _dbContext); return(Ok(response)); } } }
public IActionResult List(UserRequestPayload payload) { using (_dbContext) { var roles = _dbContext.SystemRole.Where(x => x.IsDeleted == 0).ToList(); var query = from u in _dbContext.SystemUser where u.UserType != 5 select new { SystemUserUuid = u.SystemUserUuid, LoginName = u.LoginName, RealName = u.RealName, UserIdCard = u.UserIdCard, AddTime = u.AddTime, AddPeople = u.AddPeople, UserType = GetRoleName(u.SystemRoleUuid, roles), IsDeleted = u.IsDeleted, //u.OldCard, Id = u.Id }; if (!string.IsNullOrEmpty(payload.Kw)) { query = query.Where(x => x.LoginName.Contains(payload.Kw.Trim()) || x.RealName.Contains(payload.Kw.Trim())); } if (payload.IsDeleted > CommonEnum.IsDeleted.All) { query = query.Where(x => (CommonEnum.IsDeleted)x.IsDeleted == payload.IsDeleted); } //if (payload.Status > UserStatus.All) //{ // query = query.Where(x => x.Status == payload.Status); //} if (payload.FirstSort != null) { query = query.OrderBy(payload.FirstSort.Field, payload.FirstSort.Direct == "DESC"); } var list = query.Paged(payload.CurrentPage, payload.PageSize).ToList(); var totalCount = query.Count(); //var data = list.Select(_mapper.Map<SystemUser, UserJsonModel>); var response = ResponseModelFactory.CreateResultInstance; response.SetData(list, totalCount); ToLog.AddLog("查询", "成功:查询:系统用户管理列表数据", _dbContext); return(Ok(response)); } }
public IActionResult Create(ColumnViewModel vmodel) { var response = ResponseModelFactory.CreateInstance; using (_dbContext) { if (_dbContext.Column.Any(x => x.ColumnTitle == vmodel.ColumnTitle && x.IsDeleted == 0 && x.SuperiorUuid == vmodel.SuperiorUuid)) { response.SetFailed("已存在该名称的栏目"); return(Ok(response)); } var entity = new Column(); entity.ColumnUuid = Guid.NewGuid(); entity.IsDeleted = 0; entity.ColumnTitle = vmodel.ColumnTitle; entity.AddTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); entity.AddPeople = AuthContextService.CurrentUser.LoginName; //if (vmodel.SuperiorUuid == null || vmodel.SuperiorUuid == Guid.Empty) //{ // entity.SuperiorUuid = Guid.Empty; // entity.SuperiorMenu = 0; //} //else //{ // Guid? newuuid = vmodel.SuperiorUuid; // var supentity = _dbContext.Column.FirstOrDefault(x => x.ColumnUuid == newuuid); // entity.SuperiorMenu = supentity.SuperiorMenu + 1; // entity.SuperiorUuid = newuuid; //} entity.SuperiorUuid = vmodel.SuperiorUuid; entity.SuperiorMenu = vmodel.SuperiorUuid == null ? 0 : 1; entity.ColumnModel = vmodel.ColumnModel; entity.IsStick = vmodel.IsStick; entity.ColumnContent = vmodel.ColumnContent; entity.SortId = vmodel.SortId; _dbContext.Column.Add(entity); int res = _dbContext.SaveChanges(); if (res > 0) { ToLog.AddLog("添加", "成功:添加:栏目列表信息一条数据", _dbContext); } response.SetSuccess("操作成功"); return(Ok(response)); } }
public IActionResult CpcList(CpcmanRequestpayload payload) { var query = from u in _dbContext.Userinfoty where u.IsDeleted != 1 && u.DyStaues == "1" select new { u.Id, u.TownUuid, u.UserInfoUuid, u.RealName, u.Sex, u.Birth, u.Education, u.Category, u.Partybranch, u.JoinDate, u.Phone, u.Residence, u.Work, u.Age }; if (!string.IsNullOrEmpty(payload.Kw)) { query = query.Where(x => x.Residence.Contains(payload.Kw)); } if (!string.IsNullOrEmpty(payload.Kw1)) { query = query.Where(x => x.RealName.Contains(payload.Kw1.Trim())); } if (!string.IsNullOrEmpty(payload.Kw2)) { query = query.Where(x => x.Residence.Contains(payload.Kw2)); } if (payload.FirstSort != null) { query = query.OrderByDescending(x => x.Id); } var list = query.Paged(payload.CurrentPage, payload.PageSize).ToList(); var totalCount = query.Count(); var response = ResponseModelFactory.CreateResultInstance; response.SetData(list, totalCount); ToLog.AddLog("查询", "成功:查询:党员列表数据", _dbContext); return(Ok(response)); }
public IActionResult List(NewsRequestPayload payload) { using (_dbContext) { var query = _dbContext.RestsData.Where(x => x.IsDeleted != 1); if (!string.IsNullOrEmpty(payload.Kw)) { query = query.Where(x => x.Name.Contains(payload.Kw.Trim())); } var list = query.Paged(payload.CurrentPage, payload.PageSize).ToList(); var totalCount = query.Count(); var response = ResponseModelFactory.CreateResultInstance; response.SetData(list, totalCount); ToLog.AddLog("查询", "成功:查询:其他数据信息数据", _dbContext); return(Ok(response)); } }
public IActionResult List(UserInfoRequestpayload payload) { var query = _dbContext.DangerousGoods.Where(x => x.IsDeleted == 0); if (!string.IsNullOrEmpty(payload.Kw)) { query = query.Where(x => x.Name.Contains(payload.Kw.Trim())); } query = query.OrderByDescending(x => x.Id); var list = query.Paged(payload.CurrentPage, payload.PageSize).ToList(); var totalCount = query.Count(); var response = ResponseModelFactory.CreateResultInstance; response.SetData(list, totalCount); ToLog.AddLog("查询", "成功:查询:危险品从业人口信息数据", _dbContext); return(Ok(response)); }
public IActionResult Create(SecurityPViewModel model) { var response = ResponseModelFactory.CreateInstance; if (string.IsNullOrEmpty(model.SecurityName) || string.IsNullOrEmpty(model.IdentityCard )) { response.SetFailed("请输入名称和身份证号"); return(Ok(response)); } using (_dbContext) { if (_dbContext.Security.Any(x => x.IdentityCard == model.IdentityCard && x.IsDeleted == 0)) { response.SetFailed("角色已存在"); return(Ok(response)); } var entity = new Security() { SecurityUuid = Guid.NewGuid(), SecurityName = model.SecurityName, AddPeople = AuthContextService.CurrentUser.DisplayName, AddTime = DateTime.Now.ToString("yyyy-MM-dd"), IsDeleted = 0, Phone = model.Phone, SecurityTime = model.SecurityTime == ""?null : Convert.ToDateTime(model.SecurityTime).ToString("yyyy-MM-dd"), SecurityStaues = model.SecurityStaues, IdentityCard = model.IdentityCard.Trim(), SecurityAddress = model.SecurityAddress, }; _dbContext.Security.Add(entity); var num = _dbContext.SaveChanges(); if (num > 0) { ToLog.AddLog("添加", "成功:添加:安防人员信息一条数据", _dbContext); response.SetSuccess(); } else { response.SetFailed("添加失败"); } return(Ok(response)); } }
public IActionResult Edit(PermissionEditViewModel model) { var response = ResponseModelFactory.CreateInstance; if (ConfigurationManager.AppSettings.IsTrialVersion) { response.SetIsTrial(); return(Ok(response)); } using (_dbContext) { if (_dbContext.SystemPermission.Count(x => x.ActionCode == model.ActionCode && x.SystemPermissionUuid != model.SystemPermissionUuid) > 0) { response.SetFailed("权限操作码已存在"); return(Ok(response)); } var entity = _dbContext.SystemPermission.FirstOrDefault(x => x.SystemPermissionUuid == model.SystemPermissionUuid); if (entity == null) { response.SetFailed("权限不存在"); return(Ok(response)); } if (_dbContext.SystemPermission.Count(x => x.Name == model.Name && x.SystemMenuUuid == model.SystemMenuUuid) > 1) { response.SetFailed("权限名称已存在"); return(Ok(response)); } entity.Name = model.Name; entity.ActionCode = model.ActionCode; entity.SystemMenuUuid = model.SystemMenuUuid; entity.IsDeleted = model.IsDeleted; entity.ModifiedByUserGuid = AuthContextService.CurrentUser.Guid; entity.ModifiedByUserName = AuthContextService.CurrentUser.DisplayName; entity.ModifiedOn = DateTime.Now.ToString("yyyy-MM-dd"); entity.Status = model.Status; entity.Type = model.Type; entity.Description = model.Description; int res = _dbContext.SaveChanges(); if (res > 0) { ToLog.AddLog("编辑", "成功:编辑:系统权限信息一条数据", _dbContext); } response.SetSuccess(); return(Ok(response)); } }
public IActionResult GetCreate(YqfkrybViewModel model) { var response = ResponseModelFactory.CreateInstance; using (_dbContext) { var entity = new HaikanSmartTownCockpit.Api.Entities.Yqfkryb(); entity.Yqfkrybuuid = Guid.NewGuid(); entity.Name = model.Name; entity.Attention = model.Attention; entity.IdCard = model.IdCard; entity.OwnedNetwork = model.OwnedNetwork; entity.ReasonForConcern = model.ReasonForConcern; entity.Sex = model.Sex; entity.EpidemicPreventionAndControlStatus = model.EpidemicPreventionAndControlStatus; entity.ContactPhone = model.ContactPhone; entity.ServicePremises = model.ServicePremises; entity.IsolationTime = model.IsolationTime; entity.CurrentAddress = model.CurrentAddress; entity.Origin = model.Origin; entity.WhereToGo = model.WhereToGo; entity.ToAddress = model.ToAddress; entity.FamilyMemberContactInformation = model.FamilyMemberContactInformation; entity.GoToAddressContact = model.GoToAddressContact; entity.ContactPhoneNumber = model.ContactPhoneNumber; entity.ReturnOrEstimatedReturnTime = model.ReturnOrEstimatedReturnTime; entity.Transportation = model.Transportation; entity.YesNoSuspectedFever = model.YesNoSuspectedFever; entity.CheckMethod = model.CheckMethod; entity.NameOfResponsibleDoctor = model.NameOfResponsibleDoctor; entity.PhoneNumberOfResponsibleDoctor = model.PhoneNumberOfResponsibleDoctor; entity.ServiceMemberInformation = model.ServiceMemberInformation; entity.GuardianInformation = model.GuardianInformation; entity.Remarks = model.Remarks; entity.IsDeleted = 0; _dbContext.Yqfkryb.Add(entity); int res = _dbContext.SaveChanges(); if (res > 0) { ToLog.AddLog("添加", "成功:添加:疫情防控人员信息一条数据", _dbContext); } response.SetSuccess("添加成功"); return(Ok(response)); } }
public IActionResult Create(SettleInfoModel model) { using (_dbContext) { var response = ResponseModelFactory.CreateResultInstance; var tBool = false; var query = _dbContext.Town.Where(x => x.IsDeleted != 1).ToList(); foreach (var item in query.Where(item => model.PlaceAbode.Contains(item.TownName))) { tBool = true; } if (!tBool) { response.SetFailed("居住地请包含村镇"); return(Ok(response)); } var entity = new Entities.SettleInfo(); entity.SettleUuid = Guid.NewGuid(); entity.AddTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); entity.AddPeople = AuthContextService.CurrentUser.DisplayName; entity.IsDeleted = 0; entity.Name = model.Name; entity.Sex = model.Sex; if (!string.IsNullOrEmpty(model.Birthdate)) { entity.Birthdate = Convert.ToDateTime(model.Birthdate).ToString("yyyy-MM-dd"); } entity.NativePlace = model.NativePlace; entity.PlaceAbode = model.PlaceAbode; if (!string.IsNullOrEmpty(model.SettleTime)) { entity.SettleTime = Convert.ToDateTime(model.SettleTime).ToString("yyyy-MM-dd"); } entity.QianYiDe = model.QianYiDe; entity.IdentityCard = model.IdentityCard; _dbContext.SettleInfo.Add(entity); int res = _dbContext.SaveChanges(); if (res > 0) { ToLog.AddLog("添加", "成功:添加:落户人员信息一条数据", _dbContext); } return(Ok(response)); } }
public IActionResult Edit(RectifyInfoViewModel model) { var response = ResponseModelFactory.CreateInstance; using (_dbContext) { var entity = _dbContext.RectifyInfo.FirstOrDefault(x => x.RectifyInfoUuid == model.RectifyInfoUuid); if (entity == null) { response.SetFailed("不存在"); return(Ok(response)); } //if (_dbContext.RectifyInfo.Count(x => x.TeamName == model.TeamName && x.RectifyInfoUuid != model.RectifyInfoUuid) > 0) //{ // response.SetFailed("名称已存在"); // return Ok(response); //} entity.RectifyInfoUnit = model.RectifyInfoUnit; entity.RectifyInfoName = model.RectifyInfoName; entity.RectifyInfoStaues = model.RectifyInfoStaues; entity.DweiPhone = model.DweiPhone; entity.ShangbanStaues = model.ShangbanStaues; entity.RectifyType = model.RectifyType; entity.RectifyTiem = model.RectifyTiem; entity.KaishiTime = model.KaishiTime; entity.JiesuTime = model.JiesuTime; entity.Sex = model.Sex; entity.Birthday = model.Birthday; entity.IdentityCard = model.IdentityCard; entity.Cirterion = model.Cirterion; entity.Address = model.Address; entity.Nation = model.Nation; entity.Standard = model.Standard; entity.Service = model.Service; entity.ServicingTime = model.ServicingTime; entity.Marriage = model.Marriage; int res = _dbContext.SaveChanges(); if (res > 0) { ToLog.AddLog("编辑", "成功:编辑:矫正人员信息一条数据", _dbContext); } response = ResponseModelFactory.CreateInstance; return(Ok(response)); } }
public IActionResult List(DecompRequestpayload payload) { using (_dbContext) { var query = _dbContext.TaskDecomposition.Where(x => x.IsDelete == 0); //if (!string.IsNullOrEmpty(payload.Kw)) //{ // query = query.Where(x => x.DangOrganizationName.Contains(payload.Kw)); //} query = query.OrderByDescending(x => x.Id); var list = query.Paged(payload.CurrentPage, payload.PageSize).ToList(); var totalCount = query.Count(); var response = ResponseModelFactory.CreateResultInstance; response.SetData(list, totalCount); ToLog.AddLog("查询", "成功:查询:任务分解信息一条数据", _dbContext); return(Ok(response)); } }
public IActionResult Edit(NewsTypeViewModel model) { var response = ResponseModelFactory.CreateInstance; using (_dbContext) { var entity = _dbContext.NewsType.FirstOrDefault(x => x.NewsTypeUuid.ToString() == model.NewsTypeUuid); entity.NewsTypeName = model.NewsTypeName; entity.Remark = model.Remark; int res = _dbContext.SaveChanges(); if (res > 0) { ToLog.AddLog("编辑", "成功:编辑:新闻类型列表信息一条数据", _dbContext); } response = ResponseModelFactory.CreateInstance; return(Ok(response)); } }
public IActionResult List(administratorRequestPayload payload) { using (_dbContext) { var query = from p in _dbContext.Administrator select new { p.AdministratorUuid, p.AdministratorName, p.Sex, p.IdentityCard, p.Phone, p.AdminQuanxian, p.AdminAddress, p.AddTime, p.IsDeleted, p.Id, p.AdminVillages, p.GriddingNum, p.SuozaiWangge, p.CunjiZhanghao, p.WanggeZhanghao, p.Wanggeyuan, }; if (!string.IsNullOrEmpty(payload.Kw)) { query = query.Where(x => x.AdministratorName.Contains(payload.Kw.Trim())); } if (payload.IsDeleted > CommonEnum.IsDeleted.All) { query = query.Where(x => x.IsDeleted == Convert.ToInt32(((CommonEnum.IsDeleted)payload.IsDeleted))); } query = query.OrderByDescending(x => x.Id); var list = query.Paged(payload.CurrentPage, payload.PageSize).ToList(); var totalCount = query.Count(); var response = ResponseModelFactory.CreateResultInstance; response.SetData(list, totalCount); ToLog.AddLog("查询", "成功:查询:网格员信息数据", _dbContext); return(Ok(response)); } }
public IActionResult Create(farmHouseViewModel model) { var response = ResponseModelFactory.CreateInstance; using (_dbContext) { //if (_dbContext.BuildHouse.Count(x => x.Household == model.Household) > 0) //{ // response.SetFailed("户主已存在"); // return Ok(response); //} var entity = _mapper.Map <farmHouseViewModel, BuildHouse>(model); entity.BuildHouseUuid = Guid.NewGuid(); entity.Town = model.Town; entity.Household = model.Household; entity.HouseAddress = model.HouseAddress; entity.Lon = model.Lon; entity.Lat = model.Lat; entity.IdentityCard = model.IdentityCard; entity.Phone = model.Phone; entity.MonitorHouseId = model.MonitorHouseId; entity.AdministratorUuid = model.AdministratorUuid; entity.ProjectCred = model.ProjectCred; entity.LandNum = model.LandNum; entity.BuildArea = model.BuildArea; entity.OccupyArea = model.OccupyArea; entity.Way = model.Way; entity.ArtisanCred = model.ArtisanCred; entity.ApproveTime = model.ApproveTime; entity.IsDeleted = 0; entity.AddTime = DateTime.Now.ToString("yyyy-MM-dd"); entity.AddPeople = AuthContextService.CurrentUser.DisplayName; _dbContext.BuildHouse.Add(entity); int res = _dbContext.SaveChanges(); if (res > 0) { ToLog.AddLog("添加", "成功:添加:建房监控信息一条数据", _dbContext); } response.SetSuccess(); return(Ok(response)); } }
public IActionResult GetEdit(ExternalLinkViewModel model) { var response = ResponseModelFactory.CreateInstance; using (_dbContext) { var entity = _dbContext.ExternalLink.FirstOrDefault(x => x.ExternalLinkUuid.ToString() == model.ExternalLinkUuid); entity.Link = model.Link; entity.Remark = model.Remark; entity.LinkTypeUuid = model.LinkTypeUuid; int res = _dbContext.SaveChanges(); if (res > 0) { ToLog.AddLog("编辑", "成功:编辑:外部链接列表信息一条数据", _dbContext); } response = ResponseModelFactory.CreateInstance; return(Ok(response)); } }
public IActionResult Edit(farmHouseViewModel model) { var response = ResponseModelFactory.CreateInstance; using (_dbContext) { var entity = _dbContext.BuildHouse.FirstOrDefault(x => x.BuildHouseUuid == model.BuildHouseUuid); if (entity == null) { response.SetFailed("不存在"); return(Ok(response)); } //if (_dbContext.BuildHouse.Count(x => x.Household == model.Household && x.BuildHouseUuid != model.BuildHouseUuid) > 0) //{ // response.SetFailed("名称已存在"); // return Ok(response); //} entity.Town = model.Town; entity.Household = model.Household; entity.HouseAddress = model.HouseAddress; entity.Lon = model.Lon; entity.Lat = model.Lat; entity.IdentityCard = model.IdentityCard; entity.Phone = model.Phone; entity.MonitorHouseId = model.MonitorHouseId; entity.AdministratorUuid = model.AdministratorUuid; entity.ProjectCred = model.ProjectCred; entity.LandNum = model.LandNum; entity.BuildArea = model.BuildArea; entity.OccupyArea = model.OccupyArea; entity.Way = model.Way; entity.ArtisanCred = model.ArtisanCred; entity.ApproveTime = model.ApproveTime; int res = _dbContext.SaveChanges(); if (res > 0) { ToLog.AddLog("编辑", "成功:编辑:建房监控信息一条数据", _dbContext); } response = ResponseModelFactory.CreateInstance; return(Ok(response)); } }
public IActionResult List(ResponseInfoRequestPayload payload) { using (_dbContext) { var query = from p in _dbContext.ResponseInfo orderby p.AddTime select new { p.ResponseInfoUuid, p.Village, p.TongzhiRen, p.XiangyingDj, p.TongzhiQingk, p.Phone, //p.IsDeleted, //p.AddTime, //p.AddPeople, //p.VillageMemberUuid, //p.ResponseInitUuid, p.State, p.IsDeleted }; if (!string.IsNullOrEmpty(payload.Kw)) { query = query.Where(x => x.Village.Contains(payload.Kw.Trim()) || x.TongzhiRen.Contains(payload.Kw.Trim()) || x.XiangyingDj.Contains(payload.Kw.Trim()) || x.TongzhiQingk.Contains(payload.Kw.Trim())); } if (payload.state > -1) { query = query.Where(x => x.State == payload.state); } if (payload.IsDeleted > CommonEnum.IsDeleted.All) { query = query.Where(x => x.IsDeleted == Convert.ToInt32(((CommonEnum.IsDeleted)payload.IsDeleted))); } var list = query.Paged(payload.CurrentPage, payload.PageSize).ToList(); var totalCount = query.Count(); var response = ResponseModelFactory.CreateResultInstance; response.SetData(list, totalCount); ToLog.AddLog("查询", "成功:查询:响应情况信息一条数据", _dbContext); return Ok(response); } }