/// <summary>
/// 设备基础信息DeviceChanged
/// </summary>
/// <returns></returns>
public async Task <CoatModel> DeviceChanged(DeviceChangedParam model)
{
string strLook = string.Format(@"select t.shipment_no,
t.previous_shipment_no,
t.technology,
t.group_name,
t.input_sum,
铝箔批号,
浆料批号,
分条数 Partition_Sum,
X或Y Partition_XY,
卷料批号 ItemName,
t.engineer,
h.monitor,
t.user_name
from T_MES_MACHINE_USEINFO t,
(select f.shipment_no,f.monitor,
max(decode(f.item_name, '铝箔批号', f.item_value, null)) 铝箔批号,
max(decode(f.item_name, '浆料批号', f.item_value, null)) 浆料批号,
max(decode(f.item_name, '卷料批号', f.item_value, null)) 卷料批号,
max(decode(f.item_name, '分条数', f.item_value, null)) 分条数,
max(decode(f.item_name, 'X或Y', f.item_value, null)) X或Y
from t_mes_stir_info f
where f.shipment_no in (select t.shipment_no
from T_MES_MACHINE_USEINFO t
where t.device_no = '{0}'
and t.statue = 0)
group by f.shipment_no,f.monitor) h
where t.shipment_no = h.shipment_no(+)
and t.device_no = '{0}'
and t.statue = 0", model.device_no);
return(await base.SqlQuerySingleAsync <CoatModel>(strLook, new { }));
}
/// <summary>
/// 设备基础信息
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public async Task <MessageModel <DeviceChangedReturns> > DeviceChanged(DeviceChangedParam model)
{
MessageModel <DeviceChangedReturns> message = new MessageModel <DeviceChangedReturns>();
DeviceChangedReturns result = new DeviceChangedReturns();
var dcModel = await _dal.DeviceChanged(model);
result = _mapper.Map <DeviceChangedReturns>(dcModel);
if (result == null)
{
message.msg = "";
message.response = result;
return(message);
}
var moModel = await _dal.MeterialOverdue(dcModel);
// result = _mapper.Map<DeviceChangedReturns>(moModel);
result.out_qty = moModel.out_qty;
//result.technology = moModel.technology;
//result.out_qty = moModel.out_qty;
var scnModel = await _dal.ShipCartNumber(dcModel);
result.qty = (moModel.out_qty.ObjToInt() - scnModel.qty.ObjToInt()).ToString();
message.msg = "";
message.success = true;
message.response = result;
return(message);
}
public async Task <MessageModel <DeviceChangedReturns> > DeviceChanged(DeviceChangedParam model)
{
return(await _coatServices.DeviceChanged(model));
}
