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