/// <summary> /// 获取设备预警 /// </summary> /// <param name="Parameter"></param> public ReturnMsg GetEquipmentWarning(InvokeEntity Parameter) { userInfo = BasePubCommon.FindLoginUserInfo(Parameter.token); model = JsonConvert.DeserializeObject <EquipmentModel>(Parameter.obj.ToString()); this.sqlConn = Parameter.SqlConnection; return(GetWarning()); }
/// <summary> /// 动态创建设备种类子节点的Code值 /// </summary> /// <returns></returns> public ReturnMsg AutoSetEquipmentSpecieCode(InvokeEntity Parameter) { userInfo = BasePubCommon.FindLoginUserInfo(Parameter.token); var JO = JsonConvert.DeserializeObject <JObject>(Parameter.obj.ToString()); var tablename = (JO["tablename"] == null ? "" : JO["tablename"].ToString()); this.sqlConn = userInfo.SQLCONN; switch (tablename) { case "sfcdatequipmentspecies": var equipmentspecieModel = JsonConvert.DeserializeObject <Sfcdatequipmentspecies>(Parameter.obj.ToString()); equipmentspecieModel.Creator = userInfo.UserName; resultData = SetEquipmentSpecieCode(equipmentspecieModel); break; case "sysdatdepartment": var sysdatdepartment = JsonConvert.DeserializeObject <sysdatdepartment>(Parameter.obj.ToString()); sysdatdepartment.CREATOR = userInfo.UserName; resultData = SetDepartmentCode(sysdatdepartment); break; case "sfcdaterrortype": var sfcdaterrortype = JsonConvert.DeserializeObject <sfcdaterrortype>(Parameter.obj.ToString()); sfcdaterrortype.creator = userInfo.UserName; resultData = SetErrortypeCode(sfcdaterrortype); break; default: break; } return(resultData); }
/// <summary> ///初始化配置数据 /// </summary> public ProcessInfo InitSettingData(string sqlConn, object Parameter, string token, InvokeEntity InvokeParameter = null) { this.hostPath = GetHostPath(); this.sqlConn = sqlConn; this.token = token; var result = JsonConvert.DeserializeObject <ProcessInfo>(Parameter.ToString()); if (InvokeParameter != null) { this.sqlConn = InvokeParameter.SqlConnection; this.token = InvokeParameter.token; this.userInfo = BasePubCommon.FindLoginUserInfo(InvokeParameter.token); result = JsonConvert.DeserializeObject <ProcessInfo>(InvokeParameter.obj.ToString()); } return(result); }
/// <summary> /// 删除单个台账管理信息 /// </summary> /// <param name="Parameter"></param> /// <returns></returns> public ReturnMsg DeleteEqui(InvokeEntity Parameter) { userInfo = BasePubCommon.FindLoginUserInfo(Parameter.token); var JO = JsonConvert.DeserializeObject <JObject>(Parameter.obj.ToString()); var code = JO["equiCode"].ToString(); this.sqlConn = Parameter.SqlConnection; var conn = new BaseSQL(sqlConn); bool flag = false; try { Fail("删除失败"); //删除设备以及关联的表信息 conn.BeginTrans(); //删除设备信息 string Sql = "delete from sfcdatequipmentinfo where code=@code"; CmdParameter[] paras = new CmdParameter[1]; paras[0] = new CmdParameter() { DBtype = DBType.String, ParameterName = "@code", Value = code }; flag = conn.ExeSql(Sql, paras); //删除附件信息 Sql = "delete from sfcdatattachment where equipmentinfocode=@code"; flag = conn.ExeSql(Sql, paras); //删除文档信息 Sql = "delete from sfcdatdocument where equipmentinfocode=@code"; flag = conn.ExeSql(Sql, paras); //删除图片信息 Sql = "delete from sfcdatpic where equipmentinfocode=@code"; flag = conn.ExeSql(Sql, paras); //删除维修记录 Sql = "delete from sfcdatmaintenancerecord where equipmentcode=@code"; flag = conn.ExeSql(Sql, paras); //删除调拨记录 Sql = "delete from sfcdattransferrecord where equipmentinfocode=@code"; flag = conn.ExeSql(Sql, paras); //删除报废记录 Sql = "delete from sfcdatscraprecord where equipmentinfocode =@code"; flag = conn.ExeSql(Sql, paras); //删除其它异动 Sql = "delete from sfcdatothermove where equipmentinfocode =@code"; flag = conn.ExeSql(Sql, paras); //删除定期检修 Sql = "delete from sfcdatrepairinfo where equipmentcode =@code"; flag = conn.ExeSql(Sql, paras); conn.Commit(); Success(); return(resultData); } catch (Exception ex) { conn.Rollback(); return(resultData); } }