public ActionResult getMan(int AlarmID) { string result = ""; try { t_AlarmTable_en alarm = bll.t_AlarmTable_en.Where(p => p.AlarmID == AlarmID).ToList().First(); List <t_CM_Constract> ll = bll.t_CM_Constract.Where(p => p.CtrPid == alarm.PID).ToList(); if (ll == null || ll.Count <= 0) { return(Content(result)); } t_CM_Constract t = ll.First(); string sql = "SELECT * FROM t_CM_UserInfo WHERE UserName='******'"; List <t_CM_UserInfo> listUsers = bll.ExecuteStoreQuery <t_CM_UserInfo>(sql).ToList(); if (listUsers != null | listUsers.Count > 0) { return(Content("联系班长:" + listUsers.First().UserName + "." + listUsers.First().Mobilephone)); } return(Content(listUsers.First().Mobilephone)); } catch { return(Content(result)); } }
public ActionResult AddBugInfo(int AlarmID) { string result = "OK"; try { List <t_CM_BugInfo> list = bll.t_CM_BugInfo.Where(p => p.AlarmID == AlarmID).ToList(); if (list.Count > 0) { result = "此报警隐患已存在,请重新选择! "; } else { t_AlarmTable_en Alarm = bll.t_AlarmTable_en.Where(r => r.AlarmID == AlarmID).First(); t_CM_PDRInfo PDRInfo = bll.t_CM_PDRInfo.Where(r => r.PID == Alarm.PID).First(); t_CM_BugInfo info = new t_CM_BugInfo(); info.PID = Alarm.PID; info.PName = PDRInfo.Name; info.DID = Alarm.DID; if (Alarm.DID > 0) { t_DM_DeviceInfo DeviceInfo = bll.t_DM_DeviceInfo.Where(r => r.DID == Alarm.DID).First(); info.DeviceName = DeviceInfo.DeviceName; } info.ReportWay = "在线监测"; if (Alarm.ALarmType == "关注") { info.BugLevel = "一般"; } else if (Alarm.ALarmType == "预警") { info.BugLevel = "重大"; } else { info.BugLevel = "紧急"; } info.BugLocation = Alarm.AlarmArea; info.BugDesc = Alarm.ALarmType + ":" + Alarm.AlarmCate + "" + PDRInfo.Name + Alarm.AlarmAddress + Alarm.Company + ":" + Alarm.AlarmValue + ",限值" + Alarm.AlarmMaxValue + "," + Convert.ToDateTime(Alarm.AlarmDateTime).ToString("yyyy-MM-dd HH:mm:ss"); info.AlarmID = AlarmID; info.ReportDate = DateTime.Now; info.HandeSituation = "未审核"; info.ReportUser = CurrentUser.UserName; bll.t_CM_BugInfo.AddObject(info); bll.SaveChanges(); Common.InsertLog("隐患管理", CurrentUser.UserName, "报警新增隐患信息[" + AlarmID + "]"); result = "OKadd"; } } catch (Exception ex) { result = ex.ToString(); result = "出错了!"; } return(Content(result)); }
public AlarmBean(t_AlarmTable_en t_AlarmTable_en) { // TODO: Complete member initialization this.t_AlarmTable_en = t_AlarmTable_en; if (t_AlarmTable_en.AlarmCate == "开关量") { if (t_AlarmTable_en.AlarmArea == "水浸") { AlarmValue = t_AlarmTable_en.AlarmValue == 0 ? "正常" : "浸水"; } else { AlarmValue = t_AlarmTable_en.AlarmValue == 0 ? "分闸" : "合闸"; } } else { AlarmValue = t_AlarmTable_en.AlarmValue + ""; } }
public ActionResult DelAlarmById(int AlarmID, string AlarmTreatment) { try { string PDRList = HomeController.GetPID(CurrentUser.UNITList); //string PDRList = CurrentUser.PDRList; if (!PDRList.Equals("")) { string sSql = "update [t_AlarmTable_en] set AlarmState = 0,AlarmTreatment = '" + AlarmTreatment + "',AlarmConfirm='已确认',UserName='******',ConfirmDate='" + DateTime.Now.ToString("yyyy-MM-dd HH:mm") + "' where PID in (" + PDRList + ") and AlarmConfirm='未确认' and AlarmState>0 and AlarmID=" + AlarmID; bll.ExecuteStoreCommand(sSql); if (AlarmTreatment != null && AlarmTreatment.Contains("真实"))//添加隐患,并且下发工单; { List <t_AlarmTable_en> list = bll.t_AlarmTable_en.Where(p => p.AlarmID == AlarmID).ToList(); if (list != null && list.Count > 0) { try { t_AlarmTable_en alarm = list.First(); t_PM_Order order = new t_PM_Order(); order.PID = alarm.PID; t_CM_PDRInfo pdrinfo = bll.t_CM_PDRInfo.Where(p => p.PID == alarm.PID).ToList().First(); order.PName = pdrinfo.Name; try { string c = pdrinfo.Coordination; string[] xx = c.Split('|'); order.Latitude = decimal.Parse(xx[1]); order.Longtitude = decimal.Parse(xx[0]); } catch { } order.OrderName = order.PName + "应急抢修" + DateTime.Now; List <t_CM_Constract> ll = bll.t_CM_Constract.Where(p => p.CtrPid == alarm.PID).ToList(); if (ll == null || ll.Count <= 0) { return(Content("报警已确认!\n未找到合同中的负责人!\n自动下发工单失败,请手工处理!")); } t_CM_Constract t = ll.First(); string sql = "SELECT * FROM t_CM_UserInfo WHERE UserName='******'"; List <t_CM_UserInfo> listUsers = bll.ExecuteStoreQuery <t_CM_UserInfo>(sql).ToList(); if (listUsers == null | listUsers.Count <= 0) { return(Content("报警已确认!\n未找到工单需要下发的人员!\n自动下发工单失败,请手工处理!")); } order.UserName = t.person;//根据pid,类型查找合同,到名字; order.PlanDate = DateTime.Now; order.UserID = listUsers.First().UserID; order.Priority = 1; order.OrderNO = DateTime.Now.Ticks + ""; order.OrderType = "应急抢修"; order.DressCodeID = 2; order.OrderState = 0; //0待接收 1已受理 2已完成 order.IsQualified = -1; //-1 未检查 0不合格 1合格 order.CreateDate = DateTime.Now; order.Creater = CurrentUser.UserName; order.OrderTypeId = 3; order.OrderContent = "报警内容:" + alarm.ALarmType + ";" + alarm.AlarmDateTime + ";" + alarm.AlarmCate + ";" + ValueReset((double)alarm.AlarmValue, alarm.AlarmCate) + ";" + alarm.AlarmAddress + ";" + alarm.AlarmArea + ";" + alarm.Company + "。已确认为真实故障,请立即检修。"; bll.t_PM_Order.AddObject(order); bll.SaveChanges(); //发送短信; Result a = UtilsSms.smsOrderAdd(order.UserName, order.OrderName, bll); AddBugInfo(AlarmID); return(Content("报警已确认!" + "\n\n" + parserContent(a))); } catch (Exception ex) { string error = ex.ToString(); return(Content("报警已确认!\n自动下发工单失败,请手工处理!")); } } } return(Content("报警已确认!")); } else { return(Content("没有权限,报警未确认!")); } } catch (Exception ex) { string error = ex.ToString(); return(Content("报警确认失败!")); } }