/// <summary>
/// 根据出货牌查当前步骤的工序数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public async Task <List <AgitationDetailModel> > StrstepNameSelecte(AgitationStrstepNameSelecteParam model)
{
//and d.step_num = c.step_num
string strstepNameSelecte = string.Format(@"select d.item_name, d.item_value,d.MONITOR,d.USERNAME,d.ITEM_WEIGHT,c.current_steps,c.next_step
from t_mes_stir_info d, T_MES_MACHINE_USEINFO c
where d.shipment_no = c.shipment_no
and d.step_name='{0}'
and c.shipment_no = '{1}'", model.stepName, model.shipCard);
return(await base.SqlQuery <AgitationDetailModel>(strstepNameSelecte, new { }));
}
/// <summary>
/// 提交信息
/// </summary>
/// <param name="model">{itemValue1,shipCard,stepName,device_no,next_step,USERNAME,MONITOR,ITEM_WEIGHT,itemList[{item_No,item_Batch,item_name}]}</param>
/// <returns></returns>
public async Task <MessageModel <AgitationDetailModel> > Submit(AgitationDetailParam model)
{
// Convert.ToInt64(model.device_no);
_loggerHelper.Info("搅拌工步提交参数", JsonConvert.SerializeObject(model));
MessageModel <AgitationDetailModel> message = new MessageModel <AgitationDetailModel>();
//1.不是第一个工步则判断他上个工序有没有做
if (model.STEP_NUMBER > 1)
{
AgitationStrstepNameSelecteParam asns = new AgitationStrstepNameSelecteParam()
{
shipCard = model.shipCard,
stepName = model.last_step,
};
var stepsns = await this.StrstepNameSelecte(asns);
if (!stepsns.success)
{
message.msg = "请完善前面的工序,不允许跨步骤";
return(message);
}
}
//拼接物料号
var stepcount = await _dal.GetStepNumber(model);
AgitationDetailModel admModel = new AgitationDetailModel();
admModel = _mapper.Map <AgitationDetailModel>(model);
if (stepcount == null)
{
message.msg = "添加失败";
message.response = admModel;
return(message);
}
//2.校验信息
model.guleStepModel.STEP_NAME = model.stepName;
var stepData = await _dal.GetStepListAllByStepName(model.guleStepModel);
if (stepData == null)
{
message.success = false;
message.msg = "您还没有维护此工步,请联系相关人员维护";
return(message);
}
if (string.IsNullOrEmpty(admModel.publicSpeed))
{
admModel.publicSpeed = null;
}
if (string.IsNullOrEmpty(admModel.selfVelocity))
{
admModel.selfVelocity = null;
}
if (string.IsNullOrEmpty(admModel.vacuum))
{
admModel.vacuum = null;
}
if (string.IsNullOrEmpty(admModel.temperature))
{
admModel.temperature = null;
}
if (!string.IsNullOrEmpty(stepData.ITEM_CODE))
{
if (model.itemList.Count <= 0)
{
message.msg = "此工步需要校验物料信息,请检查";
return(message);
}
}
//公转-搅拌速度
if (!(admModel.publicSpeed.ObjToFloat() <= stepData.MIXING_SPEED_UPPER && admModel.publicSpeed.ObjToFloat() >= stepData.MIXING_SPEED_LOWER))
{
message.msg = "公转速度上下限：" + stepData.MIXING_SPEED_LOWER + "~" + stepData.MIXING_SPEED_UPPER;
return(message);
}
//自转-分离速度
if (!(admModel.selfVelocity.ObjToFloat() <= stepData.SEPARATE_UPPER && admModel.selfVelocity.ObjToFloat() >= stepData.SEPARATE_LOWER))
{
message.msg = "自转速度上下限：" + stepData.SEPARATE_LOWER + "~" + stepData.SEPARATE_UPPER;
return(message);
}
//真空度
if (!(admModel.vacuum.ObjToFloat() <= stepData.VACUUM_UPPER))
{
if (stepData.VACUUM_LOWER != null && admModel.vacuum.ObjToFloat() >= stepData.VACUUM_LOWER.ObjToFloat())
{
message.msg = "真空度上下限：" + stepData.VACUUM_LOWER.ObjToFloat() + "~" + stepData.VACUUM_UPPER;
return(message);
}
message.msg = "真空度上限：" + stepData.VACUUM_UPPER;
return(message);
}
//温度
if (!(admModel.temperature.ObjToFloat() <= stepData.TEMPER_UPPER && admModel.temperature.ObjToFloat() >= stepData.TEMPER_LOWER))
{
message.msg = "温度上下限：" + stepData.TEMPER_LOWER + "~" + stepData.TEMPER_UPPER;
return(message);
}
//3.工步是否已经录入，录入做修改，不录入新增
var stepEntil = await this.StrstepNameSelecte(model.stepModel);
int intStep = 0;
if (stepEntil.success)
{
//删除原来，新增
await _dal.DeleteStepInfo(model, model.stepModel);
intStep = model.STEP_NUMBER + 1;
}
else
{
intStep = stepcount.step_num + 1;
}
//4.提交信息
bool bl = false;
string itemName = string.Empty;
string itemValue = string.Empty;
if (model.itemList.Count > 0)
{
foreach (var item in model.itemList)
{
admModel.item_value = item.item_No.Trim() + "|" + item.item_Batch.Trim() + "|" + item.item_Number.Trim();
admModel.item_name = item.item_name.Trim();
admModel.item_number = item.putNumber;
//item.item_value = item.item_No + item.item_Batch;
await _dal.AddTestValue(intStep, admModel);
}
bl = true;
}
//else
//{
// message.success = false;
// message.msg = "物料信息不能为空";
// message.response = admModel;
// return message;
//}
if (!string.IsNullOrEmpty(admModel.publicSpeed))
{
admModel.item_name = "公转转速";
admModel.item_value = admModel.publicSpeed;
admModel.item_weight = "";
await _dal.AddTestValue(intStep, admModel);
bl = true;
}
if (!string.IsNullOrEmpty(admModel.selfVelocity))
{
admModel.item_name = "自转转速";
admModel.item_value = admModel.selfVelocity;
admModel.item_weight = "";
await _dal.AddTestValue(intStep, admModel);
bl = true;
}
if (!string.IsNullOrEmpty(admModel.stirTime))
{
admModel.item_name = "搅拌时间";
admModel.item_value = admModel.stirTime;
admModel.item_weight = "";
await _dal.AddTestValue(intStep, admModel);
bl = true;
}
if (!string.IsNullOrEmpty(admModel.temperature))
{
admModel.item_name = "温度";
admModel.item_value = admModel.temperature;
admModel.item_weight = "";
await _dal.AddTestValue(intStep, admModel);
bl = true;
}
if (!string.IsNullOrEmpty(admModel.vacuum))
{
admModel.item_name = "真空度";
admModel.item_value = admModel.vacuum;
admModel.item_weight = "";
await _dal.AddTestValue(intStep, admModel);
bl = true;
}
if (!string.IsNullOrEmpty(admModel.viscosity))
{
admModel.item_name = "粘度";
admModel.item_value = admModel.viscosity;
admModel.item_weight = "";
await _dal.AddTestValue(intStep, admModel);
bl = true;
}
if (!string.IsNullOrEmpty(admModel.fineness))
{
admModel.item_name = "细度";
admModel.item_value = admModel.fineness;
admModel.item_weight = "";
await _dal.AddTestValue(intStep, admModel);
bl = true;
}
if (!string.IsNullOrEmpty(admModel.filter))
{
admModel.item_name = "过筛况";
admModel.item_value = admModel.filter;
admModel.item_weight = "";
await _dal.AddTestValue(intStep, admModel);
bl = true;
}
if (!string.IsNullOrEmpty(admModel.chutie))
{
admModel.item_name = "除铁要求";
admModel.item_value = admModel.chutie;
admModel.item_weight = "";
await _dal.AddTestValue(intStep, admModel);
bl = true;
}
if (bl)
{
await _dal.UpdateShipCartInfo(admModel);
message.success = true;
message.msg = "添加成功";
message.response = admModel;
}
return(message);
}
/// <summary>
/// 当前步骤获取基础信息
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public async Task <MessageModel <AgitationStrstepNameSelecteReturns> > StrstepNameSelecte(AgitationStrstepNameSelecteParam model)
{
MessageModel <AgitationStrstepNameSelecteReturns> message = new MessageModel <AgitationStrstepNameSelecteReturns>();
AgitationStrstepNameSelecteReturns reModel = new AgitationStrstepNameSelecteReturns();
var result = await _dal.StrstepNameSelecte(model);
if (result.Count > 0)
{
reModel.MONITOR = result[0].MONITOR;
reModel.USERNAME = result[0].USERNAME;
reModel.next_step = result[0].next_step;
int j = 0;
foreach (var item in result)
{
string StrItem_Name = item.item_name;
string StrItem_Value = item.item_value;
if (StrItem_Name == "公转转速")
{
reModel.publicSpeed = StrItem_Value;
}
else if (StrItem_Name == "自转转速")
{
reModel.selfVelocity = StrItem_Value;
}
else if (StrItem_Name == "搅拌时间")
{
reModel.stirTime = StrItem_Value;
}
else if (StrItem_Name == "温度")
{
reModel.temperature = StrItem_Value;
}
else if (StrItem_Name == "真空度")
{
reModel.vacuum = StrItem_Value;
}
else if (StrItem_Name == "粘度")
{
reModel.viscosity = StrItem_Value;
}
else if (StrItem_Name == "细度")
{
reModel.fineness = StrItem_Value;
}
else if (StrItem_Name == "过筛况")
{
reModel.filter = StrItem_Value;
}
else if (StrItem_Name == "除铁要求")
{
reModel.chutie = StrItem_Value;
}
else
{
//添加物料信息数据
string[] ItemValueArray = StrItem_Value.Split('|');
AgitationItems items = new AgitationItems();
items.item_name = item.item_name;
items.item_Batch = ItemValueArray[0];
items.item_No = ItemValueArray[1];
items.item_Number = item.ITEM_WEIGHT;
reModel.items.Add(items);
}
}
//重复的步骤可以重复输入
if (result[0].current_steps == result[0].next_step)
{
message.msg = "";
message.response = reModel;
message.success = true;
return(message);
}
message.success = true;
message.msg = "";
message.response = reModel;
}
else
{
message.msg = "";
message.response = reModel;
}
return(message);
}
public async Task <MessageModel <AgitationStrstepNameSelecteReturns> > StrstepNameSelecte(AgitationStrstepNameSelecteParam jsondata)
{
return(await _agitationServices.StrstepNameSelecte(jsondata));
}
/// <summary>
///删除工步信息
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public async Task <bool> DeleteStepInfo(AgitationDetailParam model, AgitationStrstepNameSelecteParam stepModel)
{
string strStep = string.Format(@"delete t_mes_stir_info t where t.SHIPMENT_NO='{0}' and t.STEP_NAME='{1}'", model.shipCard, stepModel.stepName);
return(await base.ExecuteCommand(strStep) > 0);
}
