/// <summary>
/// 更新出货牌流水号
/// </summary>
/// <param name="jsondata"></param>
/// <returns></returns>
public async Task <bool> UpdateShipcartCode(GlueSubmitParam jsondata)
{
// 更新出货牌流水号
string strUpdate = string.Format(@"update t_mes_serialnumber t set t.s_number='{0}',t.s_date='{1}' where t.s_itemname='{2}'", jsondata.strLSH, jsondata.sys_Date, jsondata.productType);
return(await base.ExecuteCommand(strUpdate, new { }) > 0);
}
/// <summary>
///
/// </summary>
/// <param name="strTyep"></param>
/// <param name="model"></param>
/// <returns></returns>
public async Task <bool> wip_QTY(GlueSubmitParam model)
{
//添加
string strAddUpdate = "";
strAddUpdate = string.Format(@"insert into T_MES_WIP_QTY
(STATION_NAME, MO_NUMBER, SHIPT_NO,QTY_INPUT, START_DATE)
values
('{0}', '{1}', '{2}', '{3}',sysdate) ", model.device_sn, model.moNumber, model.shipCard, model.solution_SUM);
return(await base.ExecuteCommand(strAddUpdate, new { }) > 0);
}
/// <summary>
/// 增加出货牌
/// </summary>
/// <param name="jsondata"></param>
/// <returns></returns>
public async Task <bool> InsertShipcart(GlueSubmitParam jsondata)
{
string strAdd = string.Format(@"insert into T_MES_MACHINE_USEINFO
(shipment_no,
input_sum,
device_no,
add_date,
USER_NAME)
values
('{0}', '{1}', '{2}',sysdate, '{3}')", jsondata.shipCard, jsondata.solution_SUM, jsondata.device_sn, jsondata.glueUser);
return(await base.ExecuteCommand(strAdd, new { }) > 0);
}
/// <summary>
/// 获取出货牌
/// </summary>
/// <param name="jsondata"></param>
/// <returns></returns>
public async Task <MessageModel <GetShipCardReturns> > GetShipCard(GetShipCardParam jsondata)
{
MessageModel <GetShipCardReturns> message = new MessageModel <GetShipCardReturns>();
GetShipCardReturns model = new GetShipCardReturns();
string productCode = string.Empty;
//if (jsondata.productType == "正极打胶")
//{
// productCode = "ZD";
//}
//if(jsondata.productType =="负极打胶")
//{
// productCode = "FD";
//}
productCode = jsondata.device_sn.Substring(0, 3);
GlueModel fistResult = await _dal.GetSerialnumber(jsondata);
//fistResult = _mapper.Map<GlueModel>(jsondata);
if (fistResult != null)
{
fistResult.sys_Date = fistResult.sys_Date.Replace("/", "");
int intDevice = jsondata.device_sn.Length;
if (fistResult.s_date == fistResult.sys_Date)
{
fistResult.s_date = fistResult.s_date.Replace("/", "");
fistResult.strLSH = (fistResult.s_number.TrimStart('0').ObjToInt() + 1).ToString().PadLeft(2, '0');
fistResult.shipCard = productCode + fistResult.s_date + jsondata.device_sn.Substring(intDevice - 2, 2) + fistResult.strLSH;
}
else
{
fistResult.strLSH = "01";
fistResult.shipCard = productCode + fistResult.sys_Date + jsondata.device_sn.Substring(intDevice - 2, 2) + fistResult.strLSH;
}
GlueSubmitParam gpModel = new GlueSubmitParam();
gpModel = _mapper.Map <GlueSubmitParam>(fistResult);
await _dal.UpdateShipcartCode(gpModel);
}
else
{
await _dal.InsertSerialnumber(jsondata);
await GetShipCard(jsondata);
}
model = _mapper.Map <GetShipCardReturns>(fistResult);
message.success = true;
message.msg = "";
message.response = model;
return(message);
}
/// <summary>
/// 增加溶液值
/// </summary>
/// <param name="itemName"></param>
/// <param name="model"></param>
/// <returns></returns>
public async Task <bool> AddTestValue(string itemName, GlueSubmitParam model)
{
string strAdd = string.Format(@"insert into t_mes_stir_info
(shipment_no,
item_name,
item_value,
date_time,
username,
step_name)
values
('{0}', '{1}', '{2}', sysdate, '{3}', '{4}')
", model.shipCard, itemName, model.solutions_Name, model.glueUser, model.productType);
return(await base.ExecuteCommand(strAdd, new { }) > 0);
}
/// <summary>
/// 打胶信息提交
/// </summary>
/// <param name="jsondata"></param>
/// <returns></returns>
public async Task <MessageModel <GlueSubmitRaturns> > GlueSubmit(GlueSubmitParam jsondata)
{
MessageModel <GlueSubmitRaturns> message = new MessageModel <GlueSubmitRaturns>();
GlueSubmitRaturns resultModel = new GlueSubmitRaturns();
try
{
//更新出货牌流水号
//await _dal.UpdateShipcartCode(jsondata);
//增加出货牌
await _dal.InsertShipcart(jsondata);
await _dal.wip_QTY(jsondata);
if (jsondata.solutions_Name != null)
{
await _dal.AddTestValue("溶液名称", jsondata);
}
if (jsondata.cmbSolutions_name != null)
{
jsondata.solutions_Name = jsondata.cmbSolutions_name;
await _dal.AddTestValue("溶液名称", jsondata);
}
message.success = true;
message.msg = "添加成功";
}
catch (Exception ex)
{
message.success = false;
message.msg = "添加失败";
}
resultModel = _mapper.Map <GlueSubmitRaturns>(jsondata);
message.response = resultModel;
return(message);
}
