/// <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 Department SET IsDeleted=@IsDeleted WHERE DepartmentUUID IN ({0})", parameterNames);
parameters.Add(new SqlParameter("@IsDeleted", (int)isDeleted));
_dbContext.Database.ExecuteSqlRaw(sql, parameters);
var response = ResponseModelFactory.CreateInstance;
return(response);
}
}
/// <summary>
/// 删除财务账号
/// </summary>
/// <param name="isDeleted"></param>
/// <param name="ids">财务账号ID字符串,多个以逗号隔开</param>
/// <returns></returns>
private async Task <ResponseModel> UpdateIsDelete(CommonEnum.IsDeleted isDeleted, string ids)
{
await 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 = $"UPDATE FinanceAccount SET IsDeleted=@IsDeleted WHERE Code IN ({parameterNames})";
parameters.Add(new SqlParameter("@IsDeleted", (int)isDeleted));
await _dbContext.Database.ExecuteSqlCommandAsync(sql, parameters);
var response = ResponseModelFactory.CreateInstance;
return(response);
}
}
/// <summary>
/// 删除
/// </summary>
/// <param Link="isDeleted"></param>
/// <param Link="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 ExternalLink SET IsDeleted=@IsDel WHERE ExternalLinkUuid 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), int.Parse(id))).ToList();
var parameterNames = string.Join(", ", parameters.Select(p => p.SqlValue));
var sql = string.Format($"UPDATE Menu SET IsDeleted={(int)isDeleted} WHERE menuId IN ({parameterNames})");
parameters.Add(new SqlParameter("@IsDeleted", (int)isDeleted));
// _dbContext.Menus.SqlQuery(sql, parameters);
_dbContext.Database.ExecuteSqlCommand(sql);
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 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="isDeleted"></param>
/// <param name="ids">用户ID字符串,多个以逗号隔开</param>
/// <returns></returns>
private ResponseModel UpdateIsDelete(CommonEnum.IsDeleted isDeleted, string ids)
{
using (_dbContext) {
string _sqlpart = string.Empty;
_sqlpart = string.Join(", ", ids.Split(',').Select((id, index) => $"@p{index}"));
var parameters = ids.Split(',').Select((id, index) => new SqlParameter($"p{index}", int.Parse(id))).ToArray();
var parameterNames = string.Join(", ", parameters.Select(p => p.ParameterName));
var sql = string.Format($"UPDATE [User] SET IsDeleted={(int)isDeleted} WHERE userId IN ({_sqlpart})");
// var sql = string.Format($"UPDATE [User] SET IsDeleted=@IsDeleted WHERE userId IN ({_sqlpart})");
// , new SqlParameter("IsDeleted", (int)isDeleted)
_dbContext.Database.ExecuteSqlCommand(sql, parameters);
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 idList = ids.Split(",").ToList();
//idList.ForEach(x => {
// _dbContext.Database.ExecuteSqlCommand($"UPDATE DncUser SET IsDeleted=1 WHERE Id = {x}");
//});
//_dbContext.Database.ExecuteSqlCommand($"UPDATE SystemUser SET IsDeleted={(int)isDeleted} WHERE SystemUserUuid IN ({ids})");
//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 SystemUser SET IsDeleted=@IsDeleted WHERE SystemUserUUID IN ({0})", parameterNames);
//parameters.Add(new SqlParameter("@IsDeleted", (int)isDeleted));
//_dbContext.Database.ExecuteSqlCommand(sql, parameters);
//var response = ResponseModelFactory.CreateInstance;
//return response;
using (_dbContext)
{
var parameters = ids.Split(",").Select((id, index) => new SqlParameter(string.Format("@p{0}", index), id)).ToList();
foreach (var item in parameters)
{
var query1 = _dbContext.SystemUser.FirstOrDefault(x => x.SystemUserUuid == Guid.Parse(item.Value.ToString()));
if (ConfigurationManager.HaikanPassport_IfUse)
{
var du = SyncInformation.DeleteUser(query1.LoginName);
if (int.Parse(du) <= 0)
{
continue;
}
query1.IsDeleted = 1;
_dbContext.SaveChanges();
}
else
{
query1.IsDeleted = 1;
_dbContext.SaveChanges();
}
}
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 SystemRole SET IsDeleted=@IsDeleted WHERE SystemRoleUUID IN ({0}) and IsFixation !=1", parameterNames);
parameters.Add(new SqlParameter("@IsDeleted", (int)isDeleted));
var num = _dbContext.Database.ExecuteSqlRaw(sql, parameters);
var response = ResponseModelFactory.CreateInstance;
if (num <= 0)
{
response.SetFailed("删除失败");
}
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 idList = ids.Split(",").ToList();
////idList.ForEach(x => {
//// _dbContext.Database.ExecuteSqlRaw($"UPDATE DncUser SET IsDeleted=1 WHERE Id = {x}");
////});
//_dbContext.Database.ExecuteSqlRaw($"UPDATE DncUser SET IsDeleted={(int)isDeleted} WHERE Id IN ({ids})");
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 SystemUser SET IsDeleted=@IsDeleted WHERE SystemUserUUID IN ({0})", parameterNames);
parameters.Add(new SqlParameter("@IsDeleted", (int)isDeleted));
_dbContext.Database.ExecuteSqlRaw(sql, parameters);
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 parames = new List <SqlParameter>();
var parameters = ids.Split(',').Select((id, index) => new SqlParameter($"p{index}", id)).ToArray();
var parameterNames = string.Join(", ", parameters.Select(p => p.ParameterName));
var sql =
$"UPDATE [Role] SET IsDeleted=@IsDeleted WHERE Code IN ({string.Join(", ", parameters.Select((id, index) => $"@p{index}"))})";
// parameters.Add(new SqlParameter("@IsDeleted", (int)isDeleted));
var param = new SqlParameter("IsDeleted", (int)isDeleted);
parames.AddRange(parameters);
parames.Add(param);
_dbContext.Database.ExecuteSqlCommand(sql, parames.ToArray());
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($"@p{index}", id)).ToList();
var parameterNames = string.Join(", ", parameters.Select(p => p.ParameterName));
var sql =
$"UPDATE BusinessDocuments SET IsDelete=@IsDelete WHERE BusDocumentsUUID IN ({parameterNames})";
parameters.Add(new SqlParameter("@IsDelete", (int)isDeleted));
var num = _dbContext.Database.ExecuteSqlRaw(sql, parameters);
var response = ResponseModelFactory.CreateInstance;
if (num <= 0)
{
response.SetFailed("删除失败");
}
return(response);
}
}
/// <summary>
/// 删除菜单
/// </summary>
/// <param name="isDeleted"></param>
/// <param name="ids">菜单ID字符串,多个以逗号隔开</param>
/// <returns></returns>
private ResponseModel UpdateIsDelete(CommonEnum.IsDeleted isDeleted, string ids)
{
var response = ResponseModelFactory.CreateInstance;
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 IsDeleted=@IsDeleted WHERE SystemMenuUUID IN ({0})", parameterNames);
parameters.Add(new SqlParameter("@IsDeleted", (int)isDeleted));
_dbContext.Database.ExecuteSqlRaw(sql, parameters);
//var parameters = ids.Split(",").Select((id, index) => new SqlParameter(string.Format("@p{0}", index), id)).ToList();
//foreach (var item in parameters)
//{
// var query1 = _dbContext.SystemMenu.FirstOrDefault(x => x.SystemMenuUuid == Guid.Parse(item.Value.ToString()));
// query1.IsDeleted = 1;
// _dbContext.SaveChanges();
//}
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));
int isd = 0;
if ((int)isDeleted == 0)
{
isd = 1;
}
else
{
isd = 0;
}
var sql = string.Format("UPDATE SystemPermission SET IsDeleted=@IsDeleted,Status={1} WHERE SystemPermissionUUID IN ({0})", parameterNames, isd);
parameters.Add(new SqlParameter("@IsDeleted", (int)isDeleted));
_dbContext.Database.ExecuteSqlRaw(sql, parameters);
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();
foreach (var item in parameters)
{
var query1 = _dbContext.GrabageMonitoring.Where(x => x.GrabageMonitoringUuid == Guid.Parse(item.Value.ToString())).ToList();
foreach (var item1 in query1)
{
var query = _dbContext.GrabageRoom.FirstOrDefault(x => x.GarbageRoomUuid == item1.GarbageRoomUuid);
query.MonitoringNum = null;
_dbContext.SaveChanges();
}
}
var parameterNames = string.Join(", ", parameters.Select(p => p.ParameterName));
var sql = string.Format("UPDATE GrabageMonitoring SET IsDelete=@IsDeleted WHERE GrabageMonitoringUuid IN ({0})", parameterNames);
parameters.Add(new SqlParameter("@IsDeleted", (int)isDeleted));
_dbContext.Database.ExecuteSqlRaw(sql, parameters);
var response = ResponseModelFactory.CreateInstance;
return(response);
}
}
