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