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