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