/// <summary> /// 根据PlanAreaId需要改区域 /// </summary> /// <param name="PointId">PlanAreaId</param> /// <param name="value">PlanAreaName:片区名称/GeoText:片区坐标/DeptId:部门Id/PersonId:人员PointId/AreaState:状态(不用传也行)</param> /// <returns></returns> public MessageEntity Put(int PointId, [FromBody] L_PlanArea value) { if (string.IsNullOrEmpty(value.PlanAreaName)) { return(MessageEntityTool.GetMessage(ErrorType.FieldError)); } value.PlanAreaId = PointId; var messageEntity = _planAreaDAL.UpdatePlanArea(value); return(messageEntity); }
/// <summary> /// 修改计划类别 /// </summary> /// <param name="planTypeId">PlanTypeId</param> /// <param name="value">PlanTypeId/Operater/OperateDate不填 ParentTypeId计划类型 ParentTypeId不能为0</param> /// <returns></returns> public MessageEntity Put(int planTypeId, [FromBody] L_PlanType value) { if (value.ParentTypeId == 0) { return(MessageEntityTool.GetMessage(ErrorType.FieldError)); } value.PlanTypeId = planTypeId; var messageEntity = _planTypeDAL.Update(value); return(messageEntity); }
/// <summary> /// 修改事件分类内容 /// </summary> /// <param name="eventTypeId">事件分类内容eventTypeId</param> /// <param name="eventType"> string EventTypeName 事件名称/int ExecTime 执行时间/int ParentTypeId 上级分类Id/</param> public MessageEntity Put(int eventTypeId, [FromBody] M_EventType eventType) { if (string.IsNullOrEmpty(eventType.EventTypeName) || eventType.ExecTime == null) { return(MessageEntityTool.GetMessage(ErrorType.FieldError)); } eventType.EventTypeId = eventTypeId; var messageEntity = _eventTypeDAL.UpdateEventType(eventType); return(messageEntity); }
/// <summary> /// 添加功能模块 /// </summary> /// <param name="eventType"> string EventTypeName 事件名称 /// <returns></returns> // POST api/<controller> public MessageEntity Post([FromBody] P_Function function) { if (function.FunctionType != 4) { if (string.IsNullOrEmpty(function.cFunName)) { return(MessageEntityTool.GetMessage(ErrorType.FieldError, "非C/S端 模块URL不能为空")); } } return(_p_FunPurviewDAL.PostFunction(function)); }
/// <summary> /// 修改线路下的点位 /// </summary> /// <param name="planLineDetailId">线路下的点位Id</param> /// <param name="planLineDetail">ImportPointType默认1;X/Y/ImportPointName必须填写</param> /// <returns></returns> public MessageEntity Put(int planLineDetailId, [FromBody] PlanLineDetail planLineDetail) { if (string.IsNullOrEmpty(planLineDetail.X) || string.IsNullOrEmpty(planLineDetail.Y) || string.IsNullOrEmpty(planLineDetail.ImportPointName)) { return(MessageEntityTool.GetMessage(ErrorType.FieldError)); } planLineDetail.ImportPointType = 1; planLineDetail.PlanLineDetaiId = planLineDetailId; var messageEntity = _planLineDetailDAL.Update(planLineDetail); return(messageEntity); }
/// <summary> /// 事件类型趋势分析--Table /// </summary> /// <param name="year">年</param> /// <param name="startMonth">开始月</param> /// <param name="endMonth">结束月</param> /// <returns></returns> public MessageEntity GetEventTypeTrendTable(int year, int startMonth, int endMonth) { var monthArry = GetMonthArry(startMonth, endMonth); if (monthArry == null) { return(MessageEntityTool.GetMessage(ErrorType.FieldError)); } var result = _eventTypeTrendStatisticsDAL.GetTable(monthArry, year.ToString(), startMonth.ToString(), endMonth.ToString()); return(result); }
/// <summary> /// 修改巡检路线 /// </summary> /// <param name="planLineId">巡检路线id</param> /// <param name="value">PlanLineName/PatroGeoText/GeoText不可为空</param> /// <returns></returns> public MessageEntity Put(int planLineId, [FromBody] L_PlanLine value) { if (string.IsNullOrEmpty(value.PlanLineName) || string.IsNullOrEmpty(value.PatroGeoText) || string.IsNullOrEmpty(value.GeoText)) { return(MessageEntityTool.GetMessage(ErrorType.FieldError)); } value.PlanLineId = planLineId; value.LastOperateTime = DateTime.Now; var messageEntity = _planLineDAL.Update(value); return(messageEntity); }
/// <summary> /// 删除用户 /// </summary> /// <param name="iAdminID"></param> public MessageEntity Delete(int iAdminID) { //首先判断是否是超级管理面admin 保留一个用户不被删除 var isAllowDelete = base.CommonDAL.IsAllowDelete(iAdminID, out string errorMsg); //不允许删除 if (isAllowDelete) { return(MessageEntityTool.GetMessage(ErrorType.OprationError, "", "超级管理员不允许删除")); } return(base.CommonDAL.DeleteUser(iAdminID)); }
/// <summary> /// 根据图层和设备编号获取设备信息 /// </summary> /// <param name="layerId"></param> /// <param name="objecketId">设备编号</param> /// <returns></returns> public MessageEntity Get(string layerId, string objecketId) { if (string.IsNullOrEmpty(layerId) || string.IsNullOrEmpty(objecketId)) { return(MessageEntityTool.GetMessage(ErrorType.FieldError)); } //特殊字符过滤 要单独增加通用功能 sunqi 07292019 layerId = this.FilteSQLStr(layerId); objecketId = this.FilteSQLStr(objecketId); var messageEntity = _equipmentDAL.GetByLayerNid(layerId, objecketId); return(messageEntity); }
public MessageEntity GetLayers() { var layers = _pipeDAL.GetLayers(out string errMessge); if (layers != null && layers.Count > 0) { return(MessageEntityTool.GetMessage(layers.Count, layers, true, "完成", layers.Count)); } else { return(MessageEntityTool.GetMessage(ErrorType.SystemError)); } }
/// <summary> /// 获取岗位权限 /// </summary> /// <param name="iRoleID">岗位id</param> /// <param name="systemType">登陆类型 1:web(默认) 3手机App 4c/s</param> /// <returns></returns> public MessageEntity GetRoleAuthority(string iRoleID, int systemType = 1) { var funcs = base.CommonDAL.GetRoleAuthority(iRoleID, systemType, out string msg); if (string.IsNullOrEmpty(msg)) { return(MessageEntityTool.GetMessage(funcs.Count, funcs, true, "完成", funcs.Count)); } else { return(MessageEntityTool.GetMessage(ErrorType.SystemError)); } }
/// <summary> /// 部门列表 /// </summary> /// <returns></returns> // GET api/<controller> public MessageEntity GetUserComboboxList() { var result = _departmentDAL.GetDeptInfoList(out string errMsg); if (string.IsNullOrEmpty(errMsg)) { return(MessageEntityTool.GetMessage(result.Count, result, true, "", result.Count)); } else { return(MessageEntityTool.GetMessage(ErrorType.SqlError)); } }
/// <summary> /// 查询用户列表(只选择有分派权限的用户) /// </summary> /// <param name="deptId">部门id</param> /// <param name="roleId">角色id</param> /// <returns></returns> public MessageEntity GetUserComboboxListAssigment(string deptId = "", string roleId = "") { var result = base.CommonDAL.GetUserComboboxListAssigment(deptId, roleId, out string errMsg); if (string.IsNullOrEmpty(errMsg)) { return(MessageEntityTool.GetMessage(result.Count, result, true, "", result.Count)); } else { return(MessageEntityTool.GetMessage(ErrorType.SqlError)); } }
public MessageEntity Delete(P_Role role) { //不允许删除 if (IsAllowDelete(role)) { return(MessageEntityTool.GetMessage(ErrorType.OprationError, "", "超级管理员不允许删除")); } if (IsExistUser(role)) { return(MessageEntityTool.GetMessage(ErrorType.OprationError, "", "该岗位下存在用户,不允许删除")); } base.DeleteEntity(role, ConnectionFactory.DBConnNames.GisPlateform, out MessageEntity messageEntity); return(messageEntity); }
public MessageEntity GetInstallation_address() { var result = _pipeDAL.Getinstallation_addresses(out string errMessge); if (result != null && result.Count > 0) { result.Insert(0, "全部"); return(MessageEntityTool.GetMessage(result.Count, result, true, "完成", result.Count)); } else { return(MessageEntityTool.GetMessage(ErrorType.SystemError)); } }
public MessageEntity GetMaterial_science() { var material_science = _pipeDAL.GetMaterial_science(out string errMessge); if (material_science != null && material_science.Count > 0) { material_science.Insert(0, "全部"); return(MessageEntityTool.GetMessage(material_science.Count, material_science, true, "完成", material_science.Count)); } else { return(MessageEntityTool.GetMessage(ErrorType.SystemError)); } }
public MessageEntity Put(int PlanId, string planName, int isNomalPlan, int moveType) { if (string.IsNullOrEmpty(planName)) { return(MessageEntityTool.GetMessage(ErrorType.FieldError)); } var result = _planManageDAL.Update(new L_Plan() { PlanId = PlanId, PlanName = planName, BoolNormalPlan = isNomalPlan, MoveType = moveType }); return(result); }
/// <summary> /// 新增巡检路线 /// </summary> /// <param name="value">PlanLineName/PatroGeoText/GeoText不可为空</param> /// <returns></returns> public MessageEntity Post([FromBody] L_PlanLine value) { if (string.IsNullOrEmpty(value.PlanLineName) || string.IsNullOrEmpty(value.PatroGeoText) || string.IsNullOrEmpty(value.GeoText)) { return(MessageEntityTool.GetMessage(ErrorType.FieldError)); } var dTN = DateTime.Now; value.AddTime = dTN; value.LastOperateTime = dTN; value.PlanLintState = 1; var messageEntity = _planLineDAL.Add(value); return(messageEntity); }
public MessageEntity ChangePassword([FromBody] AdminPassword admin) { if (admin == null) { return(MessageEntityTool.GetMessage(ErrorType.FieldError)); } #region modify by lsl 20190806 增加旧密码验证 if (string.IsNullOrEmpty(admin.cAdminName)) { return(MessageEntityTool.GetMessage(ErrorType.OprationError, "", "用户名不能为空")); } if (string.IsNullOrEmpty(admin.oldcAdminPassWord)) { return(MessageEntityTool.GetMessage(ErrorType.OprationError, "", "密码不能为空")); } var adminmodel = base.CommonDAL.GetUserInfo(admin.cAdminName, admin.oldcAdminPassWord, out string errorMsg); //旧密码输入错误 if (adminmodel == null) { return(MessageEntityTool.GetMessage(ErrorType.OprationError, "", "原密码验证错误")); } //是否允许修改密码验证 var isallow = base.CommonDAL.IsAllowChangePWD(admin, out string errMsg1); //不允许 if (!isallow) { return(MessageEntityTool.GetMessage(ErrorType.OprationError, "", "用户不允许修改密码")); } #endregion var entity = base.CommonDAL.UpdateUserPassword(admin, out string errMsg); if (entity) { return(MessageEntityTool.GetMessage(1)); } else { if (string.IsNullOrEmpty(errMsg)) { return(MessageEntityTool.GetMessage(ErrorType.FieldError, "", "没有该用户")); } else { return(MessageEntityTool.GetMessage(ErrorType.SqlError, errMsg)); } } }
/// <summary> /// 事件人员上报分析-table/pieChart/lineChart(startTime/endTime都不填的话 则统计所有时间段内事件) /// </summary> /// <param name="startTime">yyyy-MM-dd</param> /// <param name="endTime">yyyy-MM-dd</param> /// <returns></returns> public MessageEntity GetUserReportTable(DateTime?startTime = null, DateTime?endTime = null) { if ((startTime == null && endTime == null) || (startTime != null && endTime != null && startTime.Value <= endTime.Value)) { if (endTime != null) { endTime = endTime.Value.AddDays(1).AddSeconds(-1); } return(_userReportStatisticsDAL.GetTable(startTime, endTime)); } else { return(MessageEntityTool.GetMessage(ErrorType.FieldError)); } }
/// <summary> /// 事件工单流转操作(接单) /// </summary> /// <param name="EventID">事件ID</param> /// <param name="ExecPersonId">处理人id</param> /// <param name="ExecDetpID">处理人部门id</param> /// <param name="OrderId">工单编号</param> /// <param name="StepNum">步骤id(3)</param> /// <param name="DispatchPersonID">指派人ID</param> /// <param name="OperRemarks">操作意见</param> /// <returns></returns> public MessageEntity WorkListReceipt(string EventID, string ExecPersonId, string ExecDetpID, string OrderId, string StepNum = "3", string DispatchPersonID = "", string OperRemarks = "") { //是否允许接单 if (_eventManage.IsExecute(EventID, StepNum, out string errorMsg)) { if (errorMsg != "") { return(MessageEntityTool.GetMessage(ErrorType.OprationError, null, errorMsg, "提示")); } else { return(MessageEntityTool.GetMessage(ErrorType.OprationError, null, $"该任务已执行接单,不能多执行", "提示")); } } return(_eventManage.WorkListReceipt(EventID, ExecPersonId, ExecDetpID, OrderId, StepNum, DispatchPersonID, OperRemarks)); }
/// <summary> /// 事件工单流转操作(审核) /// </summary> /// <param name="EventID">事件ID</param> /// <param name="OrderId">工单编号</param> /// <param name="OperRemarks">操作意见</param> /// <param name="satisfaction">满意度 (非常满意、满意、不满意)</param> /// <param name="StepNum">步骤id(7)</param> /// <param name="iAdminID">登陆ID</param> /// <param name="iDetpID">登陆人员部门ID</param> /// <returns></returns> public MessageEntity WorkListAudit(string EventID, string OrderId, string iDetpID, string OperRemarks, string satisfaction, string StepNum = "7", string iAdminID = "") { //是否审核完成过 if (_eventManage.IsExecute(EventID, "8", out string errorMsg)) { if (errorMsg != "") { return(MessageEntityTool.GetMessage(ErrorType.OprationError, null, errorMsg, "提示")); } else { return(MessageEntityTool.GetMessage(ErrorType.OprationError, null, $"该任务已执行审核,不能多次执行", "提示")); } } return(_eventManage.WorkListAudit(EventID, OrderId, iDetpID, OperRemarks, satisfaction, StepNum, iAdminID)); }
public MessageEntity GetRealatedValveAndPipeByPipeId(string pipeId) { if (string.IsNullOrEmpty(pipeId)) { return(MessageEntityTool.GetMessage(ErrorType.FieldError)); } var pipeIdArray = Array.ConvertAll(pipeId.Split(','), int.Parse); var result = _pipeDAL.GetRealatedValveAndPipeByPipeId(pipeIdArray, out string errorMsg); if (!string.IsNullOrEmpty(errorMsg)) { return(MessageEntityTool.GetMessage(ErrorType.SqlError, errorMsg)); } return(MessageEntityTool.GetMessage(result.Count, result, true, "完成", result.Count)); }
public MessageEntity GetCurveHeng(object value) { try { DataTable dt = JsonConvert.DeserializeObject <DataTable>(value.ToString()); DataSet ds = new DataSet(); ds.Tables.Add(dt); var result = _pipeDAL.GetCurveHeng(ds); return(MessageEntityTool.GetMessage(1, Request.RequestUri.Authority + result)); } catch (Exception e) { return(MessageEntityTool.GetMessage(ErrorType.SystemError, e.Message)); } }
public MessageEntity GetPlanManageInfo(int?isAssigned = null, string serachCondition = "", int?isNomalPlan = null, int?iAdminID = null, DateTime?startTime = null, DateTime?endTime = null, string sort = "TaskId", string ordering = "desc", int num = 15, int page = 1) { if ((startTime == null && endTime == null) || (startTime != null && endTime != null && startTime.Value <= endTime.Value)) { if (endTime != null) { endTime = endTime.Value.AddDays(1).AddSeconds(-1); } var messageEntity = _taskManageDAL.GetTaskManageInfo(serachCondition, isNomalPlan, isAssigned, null, iAdminID, startTime, endTime, sort, ordering, num, page); return(messageEntity); } else { return(MessageEntityTool.GetMessage(ErrorType.FieldError)); } }
///// <summary> ///// 获取最新版本号 ///// </summary> ///// <returns></returns> //public MessageEntity GetLatestVersionId(){ // return _cellphoneManageDAL.GetLatestVersionId(); //} /// <summary> /// 上传APP版本信息 /// </summary> /// <param name="VersionId"></param> /// <returns></returns> public MessageEntity UploadApk(string VersionId) { HttpFileCollection files = HttpContext.Current.Request.Files; if (files.Count > 0) { //获取apk版本号 if (string.IsNullOrEmpty(VersionId) || string.IsNullOrEmpty(VersionId.Trim())) { return(MessageEntityTool.GetMessage(ErrorType.FieldError, "", "版本号必须传入")); } VersionId = VersionId.Trim(); MessageEntity ms = _cellphoneManageDAL.getCount(VersionId); if (ms.Data.Rows > 0) { return(MessageEntityTool.GetMessage(ErrorType.FieldError, "", "不能提交重复版本")); } HttpPostedFile file = files[0]; if (file.ContentLength > 0) { //全路径 string FullFullName = file.FileName; string filehz = FullFullName.Split('V')[1]; string ver = filehz.Remove(filehz.Length - 4, 4); //验证APK名称后缀版本号名必须与版本号是否一致,否则返回 if (ver != VersionId) { return(MessageEntityTool.GetMessage(ErrorType.FieldError, "", "APK名称后缀版本号名必须与版本号一致")); } String fileName = "H5188E903_0425021627.apk"; file.SaveAs(AppDomain.CurrentDomain.SetupInformation.ApplicationBase + "\\" + fileName); return(_cellphoneManageDAL.UploadApk(file.FileName, ver)); } else { return(MessageEntityTool.GetMessage(ErrorType.FieldError, "", "文件内容为空")); } } else { return(MessageEntityTool.GetMessage(ErrorType.FieldError, "", "没有选择文件")); } }
/// <summary> /// 添加计划类别 /// </summary> /// <param name="value">PlanTypeId/Operater/OperateDate不填 ParentTypeId计划类型 ParentTypeId不能为0</param> /// <returns></returns> public MessageEntity Post([FromBody] L_PlanType value) { if (UserInfoCache.Authorize == null) { return(MessageEntityTool.GetMessage(ErrorType.NotAvilebalToken)); } if (value.ParentTypeId == 0) { return(MessageEntityTool.GetMessage(ErrorType.FieldError)); } value.Operater = value.Operater; value.OperateDate = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); var messageEntity = _planTypeDAL.Add(value); return(messageEntity); }
public MessageEntity AssignTask(L_Task task) { using (var conn = ConnectionFactory.GetDBConn(ConnectionFactory.DBConnNames.PipeInspectionBase_Gis_OutSide)) { try { string strSqlSelect = string.Format(@" select count(0) [count] from L_Task lt where lt.PlanId = {0} and lt.TaskState = 1 and ((lt.VisitStarTime >= '{2}' and lt.VisitStarTime <='{3}') or (lt.VisitStarTime <='{2}' and lt.VisitOverTime >='{3}')or (lt.VisitStarTime >='{2}' and lt.VisitOverTime <='{3}') or (lt.VisitOverTime >= '{2}' and lt.VisitOverTime <='{3}')) ", task.PlanId, task.ProraterId, task.VisitStarTime, task.VisitOverTime); dynamic dtSelect = conn.Query <dynamic>(strSqlSelect).FirstOrDefault(); //当该计划已经对某人进行时间段内分派后直接返回 if (dtSelect.count > 0) { return(MessageEntityTool.GetMessage(ErrorType.OprationError, null, $"该计划已被分派,不能多次分派", "提示")); } string sqlSelectCycle = string.Format(@" select lpc.PlanCycleTime,lpc.PlanCycleUnit,lpc.PlanCycleHz,lp.StartStopInfo,lp.BoolNormalPlan from L_PLAN lp left join L_PLANCYCLE lpc on lpc.PlanCycleId = lp.PlanCycleId where 1=1 and lpc.PlanDeleteState=1 and lp.PlanId = '{0}' ", task.PlanId); List <dynamic> dtCycleList = conn.Query <dynamic>(sqlSelectCycle).ToList(); if (!(dtCycleList.Count > 0)) { return(MessageEntityTool.GetMessage(ErrorType.OprationError, null, "获取任务计划周期失败,请重试!", "提示")); } var dtCycle = dtCycleList.First(); var isNormalPlan = dtCycle.BoolNormalPlan == 1 ? "CGRW" : "LSRW"; List <Dictionary <string, string> > taskCycleList = new CalculateCycle().CalculateMainMethod(task.VisitStarTime, task.VisitOverTime, int.Parse(dtCycle.PlanCycleTime), dtCycle.PlanCycleHz, dtCycle.PlanCycleUnit, dtCycle.StartStopInfo); string sqlInsert = string.Empty; foreach (Dictionary <string, string> lis in taskCycleList) { var startTime = string.Empty; var endTime = string.Empty; lis.TryGetValue("StartDay", out startTime); lis.TryGetValue("EndDay", out endTime); sqlInsert += string.Format(@"insert into L_Task (TaskName,ProraterDeptName,ProraterDeptId,ProraterName,ProraterId,VisitStarTime,VisitOverTime,Frequency,Descript,Operator,OperateDate,TaskState,PlanId,PlanName,TaskCode) values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}',(select '{14}'+convert(varchar(50),(" + System.DateTime.Now.ToString("yy") + "*10000000+isnull(MAX(TaskId),0)+1)) from L_Task)) ;", task.TaskName, task.ProraterDeptName, task.ProraterDeptId, task.ProraterName, task.ProraterId, startTime, endTime, task.Frequency, task.Descript, task.Operator, System.DateTime.Now, 1, task.PlanId, task.PlanName, isNormalPlan); //第三步:进行添加巡检计划 } var rows = conn.Execute(sqlInsert); return(MessageEntityTool.GetMessage(rows)); } catch (Exception e) { return(MessageEntityTool.GetMessage(ErrorType.SqlError, e.Message)); } } }
public override void OnActionExecuting(HttpActionContext filterContext) { RequestCheck requestCheck = new RequestCheck(); filterContext.Request.Headers.TryGetValues("Token", out IEnumerable <string> token); var loginState = requestCheck.RequestLoginStateCheck(token == null ? "" : token.First(), filterContext.Request.RequestUri.LocalPath); if (ErrorType.Success == loginState) { } else { var response = filterContext.Response = filterContext.Response ?? new HttpResponseMessage(); response.Content = new StringContent(JsonConvert.SerializeObject(MessageEntityTool.GetMessage(loginState)), Encoding.UTF8, "application/json"); return; } }
/// <summary> /// 修改功能模块 /// </summary> /// <param name="function"></param> /// <returns></returns> public MessageEntity Put([FromBody] P_Function function) { if (function.FunctionType != 4) { if (string.IsNullOrEmpty(function.cFunName)) { return(MessageEntityTool.GetMessage(ErrorType.FieldError, "", "非C/S端 模块URL不能为空")); } } if (_p_FunPurviewDAL.UpdateFunction(function, out string errorMsg)) { return(MessageEntityTool.GetMessage(1)); } else { return(MessageEntityTool.GetMessage(ErrorType.SqlError, errorMsg)); } }