public Result DeleteDeviceOperate([FromBody] BatchDelete batchDelete)
{
var ids = batchDelete.ids;
var cnt = DeviceOperateHelper.Instance.GetCountByIds(ids);
if (cnt != ids.Count())
{
return(Result.GenError <Result>(Error.DeviceOperateNotExist));
}
DeviceOperateHelper.Instance.Delete(ids);
return(Result.GenError <Result>(Error.Success));
}
public Result DeleteSmartAccount([FromBody] BatchDelete batchDelete)
{
var ids = batchDelete.ids;
var count = AccountInfoHelper.Instance.GetCountByIds(ids);
if (count == 0)
{
return(Result.GenError <Result>(Error.AccountNotExist));
}
AccountInfoHelper.Instance.Delete(ids);
return(Result.GenError <Result>(Error.Success));
}
public Result DeleteArgsFormat([FromBody] BatchDelete batchDelete)
{
var ids = batchDelete.ids;
var cnt = ArgsFormatHelper.Instance.GetCountByIds(ids);
if (cnt == 0)
{
return(Result.GenError <Result>(Error.ArgsFormatNotExist));
}
ArgsFormatHelper.Instance.Delete(ids);
return(Result.GenError <Result>(Error.Success));
}
public Result DeleteSmartTaskOrderLevel([FromBody] BatchDelete batchDelete)
{
var ids = batchDelete.ids;
var count = SmartTaskOrderLevelHelper.Instance.GetCountByIds(ids);
if (count != 0)
{
return(Result.GenError <Result>(Error.SmartTaskOrderLevelNotExist));
}
SmartTaskOrderLevelHelper.Instance.Delete(ids);
return(Result.GenError <Result>(Error.Success));
}
public Result DeleteNotifyConfig([FromBody] BatchDelete batchDelete)
{
var ids = batchDelete.ids;
var cnt = NotifyWebhookHelper.Instance.GetCountByIds(ids);
if (cnt == 0)
{
return(Result.GenError <Result>(Error.NotifyWebhookNotExist));
}
NotifyWebhookHelper.Instance.Delete(ids);
return(Result.GenError <Result>(Error.Success));
}
public Result DeleteSmartWorkshop([FromBody] BatchDelete batchDelete)
{
var ids = batchDelete.ids;
var count = SmartWorkshopHelper.Instance.GetCountByIds(ids);
if (count == 0)
{
return(Result.GenError <Result>(Error.SmartUserNotExist));
}
SmartWorkshopHelper.Instance.Delete(ids);
return(Result.GenError <Result>(Error.Success));
}
/// <summary>
/// 批量删除微信账户
/// </summary>
/// <param name="userId"></param>
/// <returns></returns>
public ReturnMessageEntity BatchDeleteWeChatUser(List <string> userId)
{
var token = IsExistAccess_Token();
BatchDelete list = new BatchDelete();
list.useridlist = userId;
string url = "https://qyapi.weixin.qq.com/cgi-bin/user/batchdelete?access_token=" + token.access_token;
ReturnMessageEntity res = new ReturnMessageEntity();
res = HttpPost(url, list.ToString()).ToObject <ReturnMessageEntity>();
return(res);
}
public Result DeleteOrderProduction([FromBody] BatchDelete batchDelete)
{
var ids = batchDelete.ids;
var cnt = OrderProductionHelper.Instance.GetCountByIds(ids);
if (cnt == 0)
{
return(Result.GenError <Result>(Error.OrderProductionNotExist));
}
OrderProductionHelper.Instance.Delete(ids);
return(Result.GenError <Result>(Error.Success));
}
public Result DeleteSmartProcessFault([FromBody] BatchDelete batchDelete)
{
var ids = batchDelete.ids;
var cnt = SmartProcessFaultHelper.Instance.GetCountByIds(ids);
if (cnt == 0)
{
return(Result.GenError <Result>(Error.SmartProcessFaultNotExist));
}
SmartProcessFaultHelper.Instance.Delete(ids);
return(Result.GenError <Result>(Error.Success));
}
public Result DeleteMaterialPurchase([FromBody] BatchDelete batchDelete)
{
var ids = batchDelete.ids;
var cnt = MaterialPurchaseHelper.Instance.GetCountByIds(ids);
if (cnt == 0)
{
return(Result.GenError <Result>(Error.MaterialPurchaseNotExist));
}
MaterialPurchaseHelper.Instance.Delete(ids);
return(Result.GenError <Result>(Error.Success));
}
public Result DeleteWork([FromBody] BatchDelete batchDelete)
{
var ids = batchDelete.ids;
var cnt = WorkHelper.Instance.GetCountByIds(ids);
if (cnt == 0)
{
return(Result.GenError <Result>(Error.WorkNotExist));
}
WorkHelper.Instance.Delete(ids);
return(Result.GenError <Result>(Error.Success));
}
public Result DeleteProcessData([FromBody] BatchDelete batchDelete)
{
var ids = batchDelete.ids;
var cnt = ProcessDataHelper.Instance.GetCountByIds(ids);
if (cnt == 0)
{
return(Result.GenError <Result>(Error.ProcessDataNotExist));
}
ProcessDataHelper.Instance.Delete(ids);
return(Result.GenError <Result>(Error.Success));
}
public Result DeleteMember([FromBody] BatchDelete batchDelete)
{
var ids = batchDelete.ids;
var members = OrganizationUnitHelper.MemberList(ids);
if (members.Count() < ids.Count())
{
return(Result.GenError <Result>(Error.MemberNotExist));
}
OrganizationUnitHelper.DeleteMember(ids);
return(Result.GenError <Result>(Error.Success));
}
public Result Delete([FromBody] BatchDelete batchDelete)
{
var ids = batchDelete.ids;
var units = OrganizationUnitHelper.Instance.GetByIds <OrganizationUnit>(ids);
if (units.Count() < ids.Count())
{
return(Result.GenError <Result>(Error.OrganizationUnitNotExist));
}
OrganizationUnitHelper.DeleteOrganizationUnit(units);
return(Result.GenError <Result>(Error.Success));
}
public Result DeletePermission([FromBody] BatchDelete batchDelete)
{
var ids = batchDelete.ids;
var cnt = PermissionGroupHelper.Instance.GetCountByIds(ids);
if (cnt != ids.Count())
{
return(Result.GenError <Result>(Error.PermissionNotExist));
}
PermissionGroupHelper.Instance.Delete(ids);
RedisHelper.PublishToTable(PermissionGroupHelper.TableName);
return(Result.GenError <Result>(Error.Success));
}
public Result DeleteSmartFlowCardProcess([FromBody] BatchDelete batchDelete)
{
var ids = batchDelete.ids;
var smartFlowCards = SmartFlowCardProcessHelper.Instance.GetByIds <SmartFlowCardProcess>(ids);
if (!smartFlowCards.Any() || smartFlowCards.Count() != ids.Count())
{
return(Result.GenError <Result>(Error.SmartFlowCardProcessNotExist));
}
SmartFlowCardProcessHelper.Instance.Delete(ids);
OldWorkFlowHelper.Instance.OnSmartFlowCardProcessChanged(smartFlowCards);
return(Result.GenError <Result>(Error.Success));
}
public Result DeleteSmartCapacity([FromBody] BatchDelete batchDelete)
{
var ids = batchDelete.ids;
var cnt = SmartCapacityHelper.Instance.GetCountByIds(ids);
if (cnt == 0)
{
return(Result.GenError <Result>(Error.SmartCapacityNotExist));
}
SmartCapacityHelper.Instance.Delete(ids);
SmartCapacityListHelper.Instance.DeleteFromParent(ids);
return(Result.GenError <Result>(Error.Success));
}
public Result DeleteSmartOperator([FromBody] BatchDelete batchDelete)
{
var ids = batchDelete.ids;
var operators = SmartOperatorHelper.Instance.GetByIds <SmartOperator>(ids);
if (!operators.Any())
{
return(Result.GenError <Result>(Error.SmartOperatorNotExist));
}
SmartOperatorHelper.Instance.Delete(ids);
OldWorkFlowHelper.Instance.OnSmartOperatorChanged(operators);
return(Result.GenError <Result>(Error.Success));
}
public Result DeleteSmartOperatorLevel([FromBody] BatchDelete batchDelete)
{
var ids = batchDelete.ids;
var data = SmartOperatorLevelHelper.Instance.GetByIds <SmartOperatorLevel>(ids);
if (!data.Any())
{
return(Result.GenError <Result>(Error.SmartOperatorLevelNotExist));
}
SmartOperatorLevelHelper.Instance.Delete(ids);
OldWorkFlowHelper.Instance.OnSmartOperatorLevelChanged(data);
return(Result.GenError <Result>(Error.Success));
}
public Result DeleteMaintainer([FromBody] BatchDelete batchDelete)
{
var ids = batchDelete.ids;
var cnt = MaintainerHelper.Instance.GetCountByIds(ids);
if (cnt == 0)
{
return(Result.GenError <Result>(Error.MaintainerIsExist));
}
MaintainerHelper.Instance.Delete(ids);
TimerHelper.DoMaintainerSchedule();
return(Result.GenError <Result>(Error.Success));
}
public Result DeleteFaultDevice([FromBody] BatchDelete batchDelete)
{
var ids = batchDelete.ids;
var data =
ServerConfig.ApiDb.Query <FaultDevice>("SELECT * FROM `fault_device_repair` WHERE Id IN @id AND `State` != @state AND MarkedDelete = 0;",
new { id = ids, state = RepairStateEnum.Complete });
if (data.Count() != ids.Count())
{
return(Result.GenError <Result>(Error.FaultDeviceNotExist));
}
FaultDeviceHelper.Cancel(ids);
foreach (var d in data.GroupBy(x => x.FaultTime).Select(x => x.Key))
{
AnalysisHelper.FaultCal(d);
}
return(Result.GenError <Result>(Error.Success));
}
public Result DeleteMaterialDepartmentMember([FromBody] BatchDelete batchDelete)
{
var ids = batchDelete.ids;
var cnt =
ServerConfig.ApiDb.Query <int>("SELECT COUNT(1) FROM `material_department_member` WHERE Id IN @id AND `MarkedDelete` = 0;", new { id = ids }).FirstOrDefault();
if (cnt == 0)
{
return(Result.GenError <Result>(Error.MaterialDepartmentMemberNotExist));
}
ServerConfig.ApiDb.Execute(
"UPDATE `material_department_member` SET `MarkedDateTime`= @MarkedDateTime, `MarkedDelete`= @MarkedDelete WHERE `Id` IN @Id;", new
{
MarkedDateTime = DateTime.Now,
MarkedDelete = true,
Id = ids
});
return(Result.GenError <Result>(Error.Success));
}
public Result Delete_6sLog([FromQuery] BatchDelete batchDelete)
{
var ids = batchDelete.ids;
var cnt =
ServerConfig.ApiDb.Query <int>("SELECT COUNT(1) FROM `6s_log` WHERE Id IN @id AND `MarkedDelete` = 0;", new { id = ids }).FirstOrDefault();
if (cnt == 0)
{
return(Result.GenError <Result>(Error._6sLogNotExist));
}
ServerConfig.ApiDb.Execute(
"UPDATE `6s_log` SET `MarkedDateTime`= @MarkedDateTime, `MarkedDelete`= @MarkedDelete WHERE `Id` IN @Id;", new
{
MarkedDateTime = DateTime.Now,
MarkedDelete = true,
Id = ids
});
return(Result.GenError <Result>(Error.Success));
}
public Result DeleteMaintainerAdjust([FromBody] BatchDelete batchDelete)
{
var ids = batchDelete.ids;
var cnt =
ServerConfig.ApiDb.Query <int>("SELECT * FROM `maintainer_adjust` WHERE Id IN @id AND `MarkedDelete` = 0;", new { id = ids }).FirstOrDefault();
if (cnt == 0)
{
return(Result.GenError <Result>(Error.ParamError));
}
ServerConfig.ApiDb.Execute(
"UPDATE `maintainer_adjust` SET `MarkedDateTime`= @MarkedDateTime, `MarkedDelete`= @MarkedDelete WHERE Id IN @id", new
{
MarkedDateTime = DateTime.Now,
MarkedDelete = true,
Id = ids
});
TimerHelper.DoMaintainerSchedule();
return(Result.GenError <Result>(Error.Success));
}
public Result Delete([FromBody] BatchDelete batchDelete)
{
var ids = batchDelete.ids;
var roleInfos = RoleHelper.Instance.GetByIds <Role>(ids);
if (roleInfos.Count() < ids.Count())
{
return(Result.GenError <Result>(Error.RoleNotExist));
}
if (roleInfos.Any(x => x.Default))
{
return(Result.GenError <Result>(Error.RoleNotOperate));
}
if (RoleHelper.GetUseRoleCount(ids) > 0)
{
return(Result.GenError <Result>(Error.AccountUseRole));
}
RoleHelper.Instance.Delete(ids);
return(Result.GenError <Result>(Error.Success));
}
public Result DeleteManufacturePlan([FromBody] BatchDelete batchDelete)
{
var changes = new List <ManufactureLog>();
var createUserId = Request.GetIdentityInformation();
var markedDateTime = DateTime.Now;
var ids = batchDelete.ids;
var data =
ServerConfig.ApiDb.Query <ManufacturePlan>("SELECT Id, TaskId, State FROM `manufacture_plan` WHERE Id IN @id AND `MarkedDelete` = 0;", new { id = ids });
if (!data.Any())
{
return(Result.GenError <Result>(Error.ManufacturePlanNotExist));
}
if (data.Any(x => x.State != ManufacturePlanState.Wait))
{
return(Result.GenError <Result>(Error.ManufacturePlaneAssignState));
}
changes.AddRange(data.Select(x => new ManufactureLog
{
Time = markedDateTime,
Account = createUserId,
PlanId = x.Id,
TaskId = x.TaskId,
Type = ManufactureLogType.PlanDelete
}));
var waitPlanIds = data.Select(x => x.Id);
var delPlanItems =
ServerConfig.ApiDb.Query <ManufacturePlanItem>("SELECT Id FROM `manufacture_plan_item` WHERE PlanId IN @Id AND MarkedDelete = 0;", new { Id = waitPlanIds });
changes.AddRange(delPlanItems.Select(x => new ManufactureLog
{
Time = markedDateTime,
Account = createUserId,
PlanId = x.PlanId,
TaskId = data.FirstOrDefault(y => y.Id == x.PlanId)?.TaskId ?? 0,
ItemId = x.Id,
Type = ManufactureLogType.TaskDelete
}));
//var otherIds = data.Select(x => x.Id);
//if (otherIds.Any())
//{
// delItems =
// ServerConfig.ApiDb.Query<ManufacturePlanItem>("SELECT Id FROM `manufacture_plan_task` WHERE PlanId IN @Id AND MarkedDelete = 0;", new { Id = otherIds });
// changes.AddRange(delItems.Select(x => new ManufactureLog
// {
// Time = markedDateTime,
// Account = createUserId,
// PlanId = x.PlanId,
// TaskId = data.FirstOrDefault(y => y.Id == x.PlanId)?.TaskId ?? 0,
// ItemId = x.Id,
// Type = ManufactureLogType.TaskDelete
// }));
//}
ManufactureLog.AddLog(changes);
ServerConfig.ApiDb.Execute(
"UPDATE `manufacture_plan` SET `MarkedDateTime`= @MarkedDateTime, `MarkedDelete`= @MarkedDelete WHERE `Id` IN @Id;", new
{
MarkedDateTime = DateTime.Now,
MarkedDelete = true,
Id = ids
});
ServerConfig.ApiDb.Execute(
"UPDATE `manufacture_plan_item` SET `MarkedDateTime`= @MarkedDateTime, `MarkedDelete`= @MarkedDelete WHERE `PlanId` IN @Id;", new
{
MarkedDateTime = DateTime.Now,
MarkedDelete = true,
Id = ids
});
//ServerConfig.ApiDb.Execute(
// "UPDATE `manufacture_plan_task` SET `MarkedDateTime`= @MarkedDateTime, `MarkedDelete`= @MarkedDelete WHERE `PlanId` IN @Id;", new
// {
// MarkedDateTime = DateTime.Now,
// MarkedDelete = true,
// Id = ids
// });
return(Result.GenError <Result>(Error.Success));
}
private void DeleteExtraneousStagingRows()
{
// delete extraneous consolidated rows from staging (in cases of consolidated items we want a max of 1 row for each)
foreach (Entity et in Enum.GetValues(typeof(Entity)))
{
if (et != Entity.Unknown && EntityUtils.CanParticipateInConsolidation(et))
{
string stagingTableName =
DatabaseUtils.GetQualifiedTableName(PublicStagingSchema.StagingSchemaName, EntityUtils.ToCtTableName(et));
string idFldName = EntityUtils.GetIdFldName(et);
string consolidatedIdFldName = ConsolidationTypeUtils.GetConsolidatedFieldName(idFldName);
var bd = new BatchDelete(_connectionString, _timeoutSecs, stagingTableName, PublicStagingSchema.StagingId);
// e.g.
// select s.staging_id, s.consolidated_dept_id
// from STAGING.CT_DEPT s
// inner join
// (
// select consolidated_dept_id, count(1)
// from STAGING.CT_DEPT
// where history_status in ('I', 'U')
// group by consolidated_dept_id
// having count(1) > 1
// ) sc on s.consolidated_dept_id = sc.consolidated_dept_id
// where history_status in ('I', 'U')
// order by date_change desc
SqlBuilder sql = new SqlBuilder();
sql.AppendFormat("select s.{0}, s.{1}", PublicStagingSchema.StagingId, consolidatedIdFldName);
sql.AppendFormat("from {0} s", stagingTableName);
sql.Append("inner join");
sql.Append("(");
sql.AppendFormat("select {0}", consolidatedIdFldName);
sql.AppendFormat("from {0} sc", stagingTableName);
sql.AppendFormat(
"where {0} in ('{1}', '{2}')",
HistorySchema.HistoryStatusColumnName,
HistorySchema.HistoryStatusInsert,
HistorySchema.HistoryStatusUpdate);
sql.AppendFormat("group by {0}", consolidatedIdFldName);
sql.Append("having count(1) > 1");
sql.AppendFormat(") sc on s.{0} = sc.{0}", consolidatedIdFldName);
sql.AppendFormat(
"where {0} in ('{1}', '{2}')",
HistorySchema.HistoryStatusColumnName,
HistorySchema.HistoryStatusInsert,
HistorySchema.HistoryStatusUpdate);
sql.AppendFormat("order by date_change desc");
var consolidatedIds = new HashSet <long>();
DatabaseUtils.EnumerateResults(_connectionString, sql.ToString(), _timeoutSecs, r =>
{
long cId = (long)DatabaseUtils.SafeRead(r, consolidatedIdFldName, 0);
int stagingId = (int)r[PublicStagingSchema.StagingId];
if (cId == 0)
{
throw new ApplicationException("Unexpected consolidated Id");
}
if (consolidatedIds.Contains(cId))
{
bd.Add(stagingId);
}
else
{
consolidatedIds.Add(cId);
}
});
bd.Execute();
}
}
}
