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