public ServiceResult SaveWeldingDataL(WeldingInfo WeldingInfo) { ServiceResult result = new ServiceResult(); string sqlUpdate = "UPDATE Product SET WeldPower=@WeldPower,WeldSpeed=@WeldSpeed,Flow=@Flow,FlowUp=@FlowUp,FlowDown=@flowDown," + "Pressure=@Pressure,WeldDepth=@WeldDepth,WeldTime=@WeldTime,XPos=@XPos,YPos=@YPos,ZPos=@ZPos,RPos=@RPos,Coaxiality=@Coaxiality,CoaxUp=@CoaxUp," + "CoaxDown=@CoaxDown,Surface=@Surface,LwmCheck=@LwmCheck,QCResult=@QCResult WHERE PNo=@PNo"; SqlParameter[] sqlParameters = { new SqlParameter { ParameterName = "@WeldPower", SqlDbType = SqlDbType.Decimal, SqlValue = WeldingInfo.AvgPower }, new SqlParameter { ParameterName = "@WeldSpeed", SqlDbType = SqlDbType.Int, SqlValue = WeldingInfo.AvgSpeed }, new SqlParameter { ParameterName = "@Pressure", SqlDbType = SqlDbType.Decimal, SqlValue = WeldingInfo.AvgPressure }, new SqlParameter { ParameterName = "@WeldDepth", SqlDbType = SqlDbType.Decimal, SqlValue = WeldingInfo.WeldDepth }, new SqlParameter { ParameterName = "@Flow", SqlDbType = SqlDbType.Decimal, SqlValue = WeldingInfo.AvgFlow }, new SqlParameter { ParameterName = "@FlowUp", SqlDbType = SqlDbType.Decimal, SqlValue = WeldingInfo.FlowUp }, new SqlParameter { ParameterName = "@FlowDown", SqlDbType = SqlDbType.Decimal, SqlValue = WeldingInfo.FlowDown }, new SqlParameter { ParameterName = "@Coaxiality", SqlDbType = SqlDbType.Decimal, SqlValue = WeldingInfo.Coaxiality }, new SqlParameter { ParameterName = "@CoaxUp", SqlDbType = SqlDbType.Decimal, SqlValue = WeldingInfo.CoaxialityUp }, new SqlParameter { ParameterName = "@CoaxDown", SqlDbType = SqlDbType.Decimal, SqlValue = WeldingInfo.CoaxialityDown }, new SqlParameter { ParameterName = "@XPos", SqlDbType = SqlDbType.Decimal, SqlValue = WeldingInfo.WeldXPos }, new SqlParameter { ParameterName = "@YPos", SqlDbType = SqlDbType.Decimal, SqlValue = WeldingInfo.WeldYPos }, new SqlParameter { ParameterName = "@ZPos", SqlDbType = SqlDbType.Decimal, SqlValue = WeldingInfo.WeldZPos }, new SqlParameter { ParameterName = "@RPos", SqlDbType = SqlDbType.Decimal, SqlValue = WeldingInfo.WeldRPos }, new SqlParameter { ParameterName = "@WeldTime", SqlDbType = SqlDbType.Decimal, SqlValue = WeldingInfo.WeldTime }, new SqlParameter { ParameterName = "@Surface", SqlDbType = SqlDbType.NVarChar, SqlValue = WeldingInfo.SurfaceInfo }, new SqlParameter { ParameterName = "@LwmCheck", SqlDbType = SqlDbType.NVarChar, SqlValue = WeldingInfo.LwmCheck == true ? "OK":"NG" }, new SqlParameter { ParameterName = "@QCResult", SqlDbType = SqlDbType.NVarChar, SqlValue = WeldingInfo.QCResult == true ? "OK":"NG" }, new SqlParameter { ParameterName = "@PNo", SqlDbType = SqlDbType.NVarChar, SqlValue = WeldingInfo.CurrentBarCode } }; try { if (SqlHelper.IsConnection(SqlHelper.SQLServerConnectionString)) { int count = SqlHelper.ExecuteNonQuery(sqlUpdate, CommandType.Text); if (count > 0) { result.IsSuccess = true; result.Msg = "更新成功"; } else { result.IsSuccess = false; result.Msg = String.Format("更新失败:count={0}", count); } } } catch (Exception ex) { result.IsSuccess = false; result.Msg = string.Format("异常:{0}", ex.Message); } return(result); }
public ServiceResult SaveWeldingDataS(WeldingInfo weldingInfo) { return(idal.SaveWeldingDataS(weldingInfo)); }