/// <summary> /// 删除 /// </summary> public void DeleteData(string id) { var msg = new ModJsonResult(); try { int result = bll.DeleteStatus(id); if (result > 0) { msg.success = true; //清空用户部门信息 string sql = "update Sys_Master set OrganizaId='' where OrganizaId='" + id + "';"; bll.ExecuteNonQueryByText(sql); } else { msg.success = false; msg.msg = "操作失败"; } } catch (Exception ex) { msg.msg = "操作失败:" + ex.Message; } WriteJsonToPage(msg.ToString()); }
/// <summary> /// 删除 /// </summary> public void DeleteData(string id) { var msg = new ModJsonResult(); try { //判断岗位下是否还存在员工 var mode = new BllSysMaster().Exists(" OrganizaId=" + id); if (mode == true) { msg.success = false; msg.msg = "此岗位下还有员工,暂不能删除."; } else { if (bll.DeleteStatus(id) > 0) { msg.success = true; } else { msg.success = false; msg.msg = "操作失败"; } } } catch (Exception ex) { msg.msg = "操作失败:" + ex.Message; } WriteJsonToPage(msg.ToString()); }
/// <summary> /// 删除 /// </summary> public void DeleteData(string id) { var msg = new ModJsonResult(); try { if (bll.DeleteStatus(id) > 0) { msg.success = true; } else { msg.success = false; msg.msg = "操作失败"; } } catch (Exception ex) { msg.msg = "操作失败:" + ex.Message; } WriteJsonToPage(msg.ToString()); }
/// <summary> /// 删除 /// </summary> public void DeleteData(string id) { var msg = new ModJsonResult(); try { int result = bll.DeleteStatus(id); if (result > 0) { msg.success = true; //同步其他操作 StringBuilder sb = new StringBuilder(); //同步用户 sb.Append("update Sys_Master set Status=" + (int)StatusEnum.除 + " where Cid='" + id + "';"); sb.AppendLine(); //同步设备 sb.Append("update Sys_Appointed set Status=" + (int)StatusEnum.除 + " where Cid=''" + id + "';"); sb.AppendLine(); //同步巡检记录 sb.Append("delete from Sys_AppointCheckNotes where CId=''" + id + "';"); sb.AppendLine(); //同步关联单位 sb.Append("delete from Sys_CompanyCognate where CId=''" + id + "';"); sb.AppendLine(); bll.ExecuteNonQueryByText(sb.ToString()); } else { msg.success = false; msg.msg = "操作失败"; } } catch (Exception ex) { msg.msg = "操作失败:" + ex.Message; } WriteJsonToPage(msg.ToString()); }