public ActionResult InsertMsg(string Mbno, string SendTime, string Msg)//运维-档案-人员管理-发送短信 { string result = ""; try { if (SendTime.Equals("")) { SendTime = DateTime.Now.ToString(); } if (!Mbno.Equals("") && !Msg.Equals("")) { string[] Mlist = Mbno.Split(','); if (Mlist.Length > 0) { for (int i = 0; i < Mlist.Length; i++) { UtilsSms.smsContent(Mlist[i], Msg); } } result = "OK"; } return(Content(result)); } catch (Exception ex) { return(Content(ex.ToString())); } }
private void sendAlarm(IDAO.Models.t_AlarmTable_en alarm) { int pid = (int)alarm.PID; //List<t_CM_UserInfo> userList = bll.ExecuteStoreQuery<t_CM_UserInfo>("SELECT * FROM t_CM_UserInfo WHERE (PDRList LIKE '" + pid + ",%' OR PDRList = '%," + pid + "' OR PDRList LIKE '%," + pid + ",%' OR PDRList = '" + pid + "')").ToList(); IList <IDAO.Models.t_CM_Unit> unitlist = UnitDAL.getInstance().GetUnitListByPID(pid); if (unitlist.Count() > 0) { string uids = string.Empty; foreach (var item in unitlist) { uids += item.UnitID + ","; } if (!string.IsNullOrEmpty(uids)) { uids = uids.Substring(0, uids.Length - 1); IList <IDAO.Models.t_CM_UserInfo> userList = UserInfoDAL.getInstance().GetUsersByUnits(uids); if (userList == null || userList.Count <= 0) { return; } for (int i = 0; i < userList.Count; i++) { if (userList[i].OpenAlarmMsg == 1) { //根据手机号查询该报警是否发过短信; List <t_Alarm_SMS> sendedList = bll.ExecuteStoreQuery <t_Alarm_SMS>("SELECT * FROM t_Alarm_SMS WHERE mobilephone='" + userList[i].Mobilephone + "' AND alarmId=" + alarm.AlarmID).ToList(); if (sendedList == null || sendedList.Count <= 0) { UtilsSms.smsAlarm(userList[i].Mobilephone, alarm); //INSERT INTO t_Alarm_SMS (alarmTime,alarmId,sendTime,mobilephone) VALUES ('2018-03-20 16:53:11',1522,'2018-03-20 16:53:11','15210091230') string insert = "INSERT INTO t_Alarm_SMS (alarmTime,alarmId,sendTime,mobilephone) VALUES ('" + alarm.AlarmDateTime + "'," + alarm.AlarmID + ",'" + DateTime.Now.ToString() + "','" + userList[i].Mobilephone + "')"; bll.ExecuteStoreCommand(insert); } } } } } //Debug.WriteLine(DateTime.Now.ToString() + ",alarm.PID=" + alarm.PID);//c#打印输出信息 }
public void SendConTemp(object sender, System.Timers.ElapsedEventArgs e) { try { var list = bll.t_ES_ContractTemplet.Where(p => p.IsOk == 0).ToList(); foreach (var item in list) { //var sss = item.StartTime.Value.Date; //var ss = DateTime.Now.AddDays(Convert.ToDouble(item.BeforDay)).Date; if (null != item.StartTime && null != item.AlarmTime) { if ( (item.StartTime.Value.Date == DateTime.Now.AddDays(Convert.ToDouble(item.BeforDay)).Date&& item.AlarmTime.Value.Date != DateTime.Now.Date) || item.AlarmTime.Value.Date == Convert.ToDateTime("1900-01-01").Date || (item.StartTime.Value.Date == DateTime.Now.Date && item.AlarmTime.Value.Date != DateTime.Now.Date) ) { t_CM_UserInfo user = bll.t_CM_UserInfo.Where(p => p.UserID == item.PersonID).FirstOrDefault(); if (user != null) { item.AlarmTime = DateTime.Now; bll.ObjectStateManager.ChangeObjectState(item, System.Data.EntityState.Modified); UtilsSms.smsConTemp(user.Telephone); } } } } bll.SaveChanges(); } catch (Exception ex) { string error = ex.ToString(); return; } }
public ActionResult SaveOrder_templateList(int CtrOrderId, t_PM_Order order, FormCollection collection) { //string content = collection["OrderContent"].ToString(); string result = "OK"; try { if (order.OrderID > 0) { t_PM_Order orderinfo = bll.t_PM_Order.Where(o => o.OrderID == order.OrderID).First(); orderinfo.OrderContent = Common.ReplaceEnter(order.OrderContent); orderinfo.OrderNO = order.OrderNO; orderinfo.PID = order.PID; orderinfo.PlanDate = order.PlanDate; orderinfo.CtrPlanDate = order.CtrPlanDate; orderinfo.PName = order.PName; orderinfo.Priority = order.Priority; orderinfo.Remarks = Common.ReplaceEnter(order.Remarks); orderinfo.UserID = order.UserID; orderinfo.OrderState = 0; if (orderinfo.UserName != order.UserName) { UtilsSms.smsOrderCancel(orderinfo.UserName, orderinfo.OrderName, bll); } orderinfo.UserName = order.UserName; orderinfo.BugID = order.BugID; orderinfo.BugInfo = order.BugInfo; orderinfo.OrderType = order.OrderType; orderinfo.OrderName = order.OrderName; orderinfo.DressCodeID = order.DressCodeID; bll.ObjectStateManager.ChangeObjectState(orderinfo, EntityState.Modified); bll.SaveChanges(); //发送短信; UtilsSms.smsOrderAdd(order.UserName, order.OrderName, bll); // if (orderinfo.sTemplateIDs != order.sTemplateIDs || orderinfo.sTemplateCount != order.sTemplateCount) { //delete date //删除工单 string strsql = "delete from t_PM_Order_Info where OrderID = " + order.OrderID; int docount = bll.ExecuteStoreCommand(strsql, null); // if (!string.IsNullOrEmpty(order.sTemplateIDs) && !string.IsNullOrEmpty(order.sTemplateCount)) { string[] sTemplateIDsArry = order.sTemplateIDs.Split(','); string[] sTemplateCountArry = order.sTemplateCount.Split(','); if (sTemplateIDsArry.Length > 0 && sTemplateIDsArry.Length == sTemplateCountArry.Length) { for (int i = 0; i < sTemplateIDsArry.Length; i++) { //result = DeleteInfo(int.Parse(sTemplateIDsArry[i].Trim())); t_PM_Order_Info Order_Info = new t_PM_Order_Info(); Order_Info.orderId = order.OrderID; Order_Info.templateId = int.Parse((sTemplateIDsArry[i])); Order_Info.deviceCount = int.Parse((sTemplateCountArry[i])); Order_Info.unCount = Order_Info.deviceCount; bll.t_PM_Order_Info.AddObject(Order_Info); bll.SaveChanges(); } } } } Common.InsertLog("工单管理", CurrentUser.UserName, "编辑工单信息[" + order.OrderNO + "]");//log } else { order.OrderState = 0; //0待接收 1已受理 2已完成 order.IsQualified = -1; //-1 未检查 0不合格 1合格 order.CreateDate = DateTime.Now; order.Creater = CurrentUser.UserName; order.OrderContent = order.OrderContent.Replace("\n", "<br>"); int iOrderTypeId = 1; if (order.OrderType.Equals("日常巡检")) { iOrderTypeId = 3; } if (order.OrderType.Equals("检修试验")) { iOrderTypeId = 2; } if (order.OrderType.Equals("应急抢修")) { iOrderTypeId = 1; } order.OrderTypeId = iOrderTypeId; bll.t_PM_Order.AddObject(order); bll.SaveChanges(); if (CtrOrderId > 0) { t_PM_Order order2 = bll.t_PM_Order.ToList().Last(); updateCstrOrder(CtrOrderId, order2.OrderID); } if (!string.IsNullOrEmpty(order.sTemplateIDs) && !string.IsNullOrEmpty(order.sTemplateCount)) { string[] sTemplateIDsArry = order.sTemplateIDs.Split(','); string[] sTemplateCountArry = order.sTemplateCount.Split(','); if (sTemplateIDsArry.Length > 0 && sTemplateIDsArry.Length == sTemplateCountArry.Length) { t_PM_Order orderNew = null; List <t_PM_Order> list = bll.t_PM_Order.Where(o => o.OrderNO == order.OrderNO).ToList(); if (list.Count > 0) { orderNew = list[0]; if (orderNew == null) { return(Content("添加工单错误!")); } for (int i = 0; i < sTemplateIDsArry.Length; i++) { //result = DeleteInfo(int.Parse(sTemplateIDsArry[i].Trim())); t_PM_Order_Info Order_Info = new t_PM_Order_Info(); Order_Info.orderId = orderNew.OrderID; Order_Info.templateId = int.Parse((sTemplateIDsArry[i])); Order_Info.deviceCount = int.Parse((sTemplateCountArry[i])); Order_Info.unCount = Order_Info.deviceCount; bll.t_PM_Order_Info.AddObject(Order_Info); bll.SaveChanges(); } } } } Common.InsertLog("工单管理", CurrentUser.UserName, "新增工单信息[" + order.OrderNO + "]");//log //发送短信; UtilsSms.smsOrderAdd(order.UserName, order.OrderName, bll); Console.WriteLine(result); } } catch (Exception ex) { result = ex.ToString(); } return(Content(result)); }
public ActionResult SaveOrder(t_PM_Order order, FormCollection collection) { //string content = collection["OrderContent"].ToString(); string result = "OK"; try { if (order.OrderID > 0) { t_PM_Order orderinfo = bll.t_PM_Order.Where(o => o.OrderID == order.OrderID).First(); orderinfo.OrderContent = Common.ReplaceEnter(order.OrderContent); orderinfo.OrderNO = order.OrderNO; orderinfo.PID = order.PID; orderinfo.PlanDate = order.PlanDate; orderinfo.PName = order.PName; orderinfo.Priority = order.Priority; orderinfo.Remarks = Common.ReplaceEnter(order.Remarks); orderinfo.UserID = order.UserID; orderinfo.OrderState = 0; if (orderinfo.UserName != order.UserName) { UtilsSms.smsOrderCancel(orderinfo.UserName, orderinfo.OrderName, bll); } orderinfo.UserName = order.UserName; orderinfo.BugID = order.BugID; orderinfo.BugInfo = order.BugInfo; orderinfo.OrderType = order.OrderType; orderinfo.OrderName = order.OrderName; orderinfo.DressCodeID = order.DressCodeID; bll.ObjectStateManager.ChangeObjectState(orderinfo, EntityState.Modified); bll.SaveChanges(); Common.InsertLog("工单管理", CurrentUser.UserName, "编辑工单信息[" + order.OrderNO + "]");//log } else { order.OrderState = 0; //0待接收 1已受理 2已完成 order.IsQualified = -1; //-1 未检查 0不合格 1合格 order.CreateDate = DateTime.Now; order.Creater = CurrentUser.UserName; order.OrderContent = order.OrderContent.Replace("\n", "<br>"); int iOrderTypeId = 1; if (order.OrderType.Equals("日常巡检")) { iOrderTypeId = 3; } if (order.OrderType.Equals("检修试验")) { iOrderTypeId = 2; } if (order.OrderType.Equals("应急抢修")) { iOrderTypeId = 1; } order.OrderTypeId = iOrderTypeId; bll.t_PM_Order.AddObject(order); bll.SaveChanges(); Common.InsertLog("工单管理", CurrentUser.UserName, "新增工单信息[" + order.OrderNO + "]");//log } //发送短信; UtilsSms.smsOrderAdd(order.UserName, order.OrderName, bll); Console.WriteLine(result); } catch (Exception ex) { result = ex.ToString(); } return(Content(result)); }
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("报警确认失败!")); } }