125 lines
4.7 KiB
C#
125 lines
4.7 KiB
C#
using System;
|
|
using System.Collections.Generic;
|
|
using System.Text;
|
|
using System.Data;
|
|
using System.Data.SqlClient;
|
|
|
|
using System.Data.OleDb;
|
|
|
|
|
|
using DataLinkMesWork;
|
|
|
|
using SystemFramework;
|
|
|
|
namespace bizFacade
|
|
{
|
|
/// <summary>
|
|
/// 关键零部件追溯
|
|
/// </summary>
|
|
public partial class BaseDataSystemMES
|
|
{
|
|
/// <summary>
|
|
/// 删除追踪代码
|
|
/// </summary>
|
|
/// <returns></returns>
|
|
public static void CartTraceCodeCheck(string opName, string TraceCode)
|
|
{
|
|
string sql;
|
|
sql = "DELETE FROM [MES_装配数据_零部件追溯] "
|
|
+ " where 追踪代码='" + TraceCode + "'";
|
|
|
|
DataAccess.ExecuteSQL_OleDb_Access(sql);
|
|
sql = "DELETE FROM [MES_装配数据_零部件追溯_数据主表] "
|
|
+ " where 追踪代码='" + TraceCode + "'";
|
|
DataAccess.ExecuteSQL_OleDb_Access(sql);
|
|
}
|
|
/// <summary>
|
|
/// 删除追踪代码
|
|
/// 对于曲轴活塞上线工位，如果[MES_装配数据_零部件追溯_数据主表] 中[追踪代码]数量大于3删除
|
|
/// </summary>
|
|
/// <returns></returns>
|
|
public static void CartTraceCodeCheck_F3(string opName, string TraceCode)
|
|
{
|
|
int count;
|
|
string sql;
|
|
|
|
sql = "SELECT COUNT(*) FROM [MES_装配数据_零部件追溯] "
|
|
+ " where 追踪代码='" + TraceCode + "'"
|
|
+ " and 工位号='" + opName+"'";
|
|
DataAccess.ExecuteOutNum_OleDb_Access(sql, out count);
|
|
if (count >= 3)
|
|
{
|
|
sql = "DELETE FROM [MES_装配数据_零部件追溯] "
|
|
+ " where 追踪代码='" + TraceCode + "'";
|
|
|
|
DataAccess.ExecuteSQL_OleDb_Access(sql);
|
|
sql = "DELETE FROM [MES_装配数据_零部件追溯_数据主表] "
|
|
+ " where 追踪代码='" + TraceCode + "'";
|
|
DataAccess.ExecuteSQL_OleDb_Access(sql);
|
|
}
|
|
}
|
|
/// <summary>
|
|
/// 更改物料[发动机号][追踪号码]
|
|
/// [MES_装配数据_零部件追溯_临时状态]
|
|
/// </summary>
|
|
/// <returns></returns>
|
|
public static void CartTraceCodeUpdate_TraceCode(string engineID, string traceCode)
|
|
{
|
|
string sql;
|
|
sql = "UPDATE [MES_装配数据_零部件追溯_临时状态] "
|
|
+ " SET 发动机号 = '" + engineID + "'"
|
|
+ ",追踪代码 = '" + traceCode + "'";
|
|
DataAccess.ExecuteSQL_OleDb_Access(sql);
|
|
}
|
|
/// <summary>
|
|
/// [MES_装配数据_零部件追溯_临时状态]
|
|
/// </summary>
|
|
/// <returns></returns>
|
|
public static void CartTraceCodeSelect_TraceCode(out DataTable dt)
|
|
{
|
|
string sql;
|
|
sql = "SELECT TOP 1 * FROM [MES_装配数据_零部件追溯_临时状态] ";
|
|
DataAccess.ExecuteDataTable_OleDb_Access(sql, out dt);
|
|
}
|
|
/// <summary>
|
|
/// 更改物料[追踪号码]
|
|
/// [MES_装配数据_零部件追溯_临时状态]
|
|
/// </summary>
|
|
/// <returns></returns>
|
|
public static void CartTraceCodeUpdate(string opName, string TraceCode)
|
|
{
|
|
string sql;
|
|
sql = "UPDATE [MES_装配数据_零部件追溯_临时状态] "
|
|
+ " SET 发动机号 = '" + TraceCode + "'"
|
|
+ ",追踪代码 = '" + TraceCode + "'"
|
|
+ " where 工位号='" + opName + "'";
|
|
DataAccess.ExecuteSQL_OleDb_Access(sql);
|
|
}
|
|
/// <summary>
|
|
/// 总线缸盖上线工位
|
|
/// 根据[追踪号码]获得验证物料
|
|
/// </summary>
|
|
/// <returns></returns>
|
|
public static void CartTraceCodeGetVerifyMaterial(string opName, string TraceCode, string opNameOtherFileName,out DataTable dt)
|
|
{
|
|
string sql;
|
|
sql = "SELECT * FROM [MES_装配数据_零部件追溯] "
|
|
+ " WHERE 追踪代码 = '" + TraceCode + "'"
|
|
+ " AND 工位号 = '" + opName + "'";
|
|
DataAccess.ExecuteDataTable_OleDb_Access(sql, opNameOtherFileName, out dt);
|
|
}
|
|
/// <summary>
|
|
/// 总线缸盖上线工位
|
|
/// 根据[追踪号码]获得全部验证物料
|
|
/// </summary>
|
|
/// <returns></returns>
|
|
public static void CartTraceCodeGetMaterial(string opName, string TraceCode, string opNameOtherFileName, out DataTable dt)
|
|
{
|
|
string sql;
|
|
sql = "SELECT * FROM [MES_装配数据_零部件追溯] "
|
|
+ " WHERE 追踪代码 = '" + TraceCode + "'";
|
|
DataAccess.ExecuteDataTable_OleDb_Access(sql, opNameOtherFileName, out dt);
|
|
}
|
|
}
|
|
}
|