public HttpResponseMessage UpdateBase(EQM_EQUIP_SPARE_LIST user)
{
try
{
listBO.UpdateSome(user);
return(Request.CreateResponse(HttpStatusCode.OK, "更新成功"));
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, "更新出错:" + ex.Message));
}
}
public IList <EQM_EQUIP_SPARE_LIST> RemoveEntity(int kid)
{
EQM_EQUIP_SPARE_LIST entity = listBO.GetEntity(kid);
listBO.Delete(kid);
EQM_EQUIP_SPARE_LIST param = new EQM_EQUIP_SPARE_LIST()
{
mesMaintainID = entity.mesMaintainID,
dataType = "维修"
};
return(listBO.GetEntities(param));
}
public IList <EQM_EQUIP_SPARE_LIST> addSpareList(EQM_EQUIP_SPARE_LIST list)
{
IList <EQM_EQUIP_SPARE_LIST> spareLists = null;
using (TransactionScope ts = new TransactionScope())
{
//先新增
listBO.Insert(list);
//再重新加载备品备件
EQM_EQUIP_SPARE_LIST spareParam = new EQM_EQUIP_SPARE_LIST()
{
mesMaintainID = list.mesMaintainID
};
//获得备品备件
spareLists = getMaintainOrderSpares(spareParam);
ts.Complete();
}
return(spareLists);
}
public EQMMaintainProInfo getMaintainProInfo(string orderID)
{
EQMMaintainProInfo proInfo = new EQMMaintainProInfo();
EQM_EQUIP_BASETAININFO_RELATE baseParam = new EQM_EQUIP_BASETAININFO_RELATE()
{
mesMaintainID = orderID
};
//获得保养项目
proInfo.basetainInfos = releteBO.GetEntities(baseParam);
EQM_EQUIP_SPARE_LIST spareParam = new EQM_EQUIP_SPARE_LIST()
{
mesMaintainID = orderID
};
//获得备品备件
proInfo.spareLists = getMaintainOrderSpares(spareParam);
return(proInfo);
}
public List <EQM_EQUIP_SPARE_LIST> refresh(string MaintenanceOrder)
{
DataTable dateList = null;
List <EQM_EQUIP_SPARE_LIST> list = new List <EQM_EQUIP_SPARE_LIST>();
string sql = @"SELECT TOP 1000 [kid]
,[mesMaintainID]
,[spentMater]
,[direction]
,[num]
,[uom]
,[outsourcingIdentify]
,[dataType]
,[Attribute01]
,[Attribute02]
,[Attribute03]
,[Attribute04]
,[Attribute05]
FROM [SitMesDbExt].[dbo].[EQM_EQUIP_SPARE_LIST]
where [mesMaintainID]=N'" + MaintenanceOrder + "'";
dateList = listBO.GetDataTableBySql(sql);
if (dateList != null)
{
foreach (DataRow row in dateList.Rows)
{
EQM_EQUIP_SPARE_LIST ee = new EQM_EQUIP_SPARE_LIST()
{
kid = Convert.ToInt32(row["kid"]),
mesMaintainID = Convert.ToString(row["mesMaintainID"]),
spentMater = Convert.ToString(row["spentMater"]),
direction = Convert.ToString(row["direction"]),
num = Convert.ToString(row["num"]),
uom = Convert.ToString(row["uom"]),
outsourcingIdentify = Convert.ToString(row["outsourcingIdentify"])
};
list.Add(ee);
}
}
return(list);
}
public IList <EQM_EQUIP_SPARE_LIST> addSpareVec(List <EQM_EQUIP_SPARE_LIST> sparesVec)
{
IList <EQM_EQUIP_SPARE_LIST> spareLists = null;
using (TransactionScope ts = new TransactionScope())
{
foreach (EQM_EQUIP_SPARE_LIST spare in sparesVec)
{
spare.dataType = "保养";
listBO.Insert(spare);
}
//再重新加载备品备件
EQM_EQUIP_SPARE_LIST spareParam = new EQM_EQUIP_SPARE_LIST()
{
mesMaintainID = sparesVec[0].mesMaintainID
};
//获得备品备件
spareLists = getMaintainOrderSpares(spareParam);
ts.Complete();
}
return(spareLists);
}
public string sendMaintainOrderResultToSap(EQMMaintainSendSap param)
{
log.Info("sendMaintainOrderResultToSap satrt");
string errorMes = "";
EQM_EQUIP_SPARE_LIST spareParam = new EQM_EQUIP_SPARE_LIST()
{
mesMaintainID = param.mesMaintainID
};
IList <IF0004WSDL> spareDatas = new List <IF0004WSDL>();
//获得备品备件
IList <EQM_EQUIP_SPARE_LIST> spareLists = getMaintainOrderSpares(spareParam);
if (spareLists == null || spareLists.Count == 0)
{
//只需要传1条数据 备品备件为空时,不需要传设备编码
IF0004WSDL s = new IF0004WSDL()
{
mesMaintainID = param.mesMaintainID,
DeviceID = "",
VORNR = "0010",
spentMater = "",
direction = "",
num = "",
StartTime = param.startTime.Substring(0, 10),
EndTime = param.endTime.Substring(0, 10)
};
spareDatas.Add(s);
}
else
{
foreach (EQM_EQUIP_SPARE_LIST spare in spareLists)
{
IF0004WSDL s = new IF0004WSDL()
{
mesMaintainID = param.mesMaintainID,
DeviceID = param.deviceID,
VORNR = "0010",
spentMater = spare.spentMater,
direction = spare.direction,
num = spare.num,
StartTime = param.startTime.Substring(0, 10),
EndTime = param.endTime.Substring(0, 10)
};
spareDatas.Add(s);
}
}
//传SAP
CustomJsonConverter customConverter = new CustomJsonConverter()
{
PropertyNullValueReplaceValue = ""
};
string sendSapRequest = JsonConvert.SerializeObject(spareDatas, customConverter);
log.Info("send sap json\r\n" + sendSapRequest);
ZPM_IF0004_WSDL_TQSService service = new ZPM_IF0004_WSDL_TQSService();
ZPM_IF0004_TResponse respone = service.ZPM_IF0004_T(new ZPM_IF0004_T()
{
I_JSON = sendSapRequest
});
string sapResponse = respone.O_JSON;
log.Info("sap return json\r\n" + sapResponse);
//SAPJSONResponse sapJson = JsonConvert.DeserializeObject<SAPJSONResponse>(sapResponse);
//if (sapJson.resultcode.Equals("2"))
//{
// errorMes = sapJson.resultmsg;
//}
ReturnValueSAP sapJson = JsonConvert.DeserializeObject <ReturnValueSAP>(sapResponse);
if (sapJson.Success == 2)
{
errorMes = sapJson.Message;
}
else
{
//更新保养单的状态及保养人
EQM_EQUIP_MAINTAIN updateParam = new EQM_EQUIP_MAINTAIN()
{
KID = param.kid,
Maintainer = param.maintainer,
Maintain_state = "已完成"
};
maintainBO.UpdateSome(updateParam);
}
log.Info("sendMaintainOrderResultToSap end");
return(errorMes);
}
public void deleteSpareList(EQM_EQUIP_SPARE_LIST list)
{
listBO.Delete(list);
}
public void updateSpareList(EQM_EQUIP_SPARE_LIST list)
{
listBO.UpdateSome(list);
}
//获得保养单的备品备件
private IList <EQM_EQUIP_SPARE_LIST> getMaintainOrderSpares(EQM_EQUIP_SPARE_LIST param)
{
param.dataType = "保养";
return(listBO.GetEntities(param));
}
