179 lines
7.5 KiB
C#
179 lines
7.5 KiB
C#
using System;
|
||
using System.Data;
|
||
using System.Data.SqlClient;
|
||
using DataLinkMesWork;
|
||
using System.Collections;
|
||
using System.Collections.Specialized;
|
||
using SystemFramework;
|
||
|
||
namespace bizFacade
|
||
{
|
||
/// <summary>
|
||
/// 电子看板信息系统
|
||
/// </summary>
|
||
public partial class BaseDataSystemMES
|
||
{
|
||
|
||
/// <summary>
|
||
/// 测量数据合格索引_分线数据_删除
|
||
/// </summary>
|
||
/// <param name="engineID"></param>
|
||
/// <param name="opName"></param>
|
||
/// <returns></returns>
|
||
public static bool BaseData_tagTable_QualityData_B5A_SubTable_Delete
|
||
(string engineID,string opName)
|
||
{
|
||
string procedureName;
|
||
procedureName = "测量数据合格索引_分线数据_删除";
|
||
SqlParameter[] thisParms = new SqlParameter[2];
|
||
thisParms[0] = new System.Data.SqlClient.SqlParameter("@EngineID", engineID);
|
||
thisParms[1] = new System.Data.SqlClient.SqlParameter("@工位号", opName);
|
||
return DataAccess.ExecuteStoredProcedure(procedureName, ref thisParms);
|
||
}
|
||
|
||
|
||
/// <summary>
|
||
/// alter PROCEDURE [dbo].[测量数据合格_手动拧紧_增加]
|
||
///@EngineTypeID int =null,
|
||
///@EngineType nvarchar(50)=null,
|
||
///@EngineID nvarchar(100)=null,
|
||
///@TagValue nvarchar(100)=null,
|
||
///@合格标志 int=null,
|
||
///@工位号 nvarchar(50)=null,
|
||
///@托盘编号 nvarchar(50)=null,
|
||
///@TagID int=null,
|
||
///@TagID_CF int=null
|
||
/// </summary>
|
||
/// <param name="engineTypeID"></param>
|
||
/// <param name="engineType"></param>
|
||
/// <param name="engineID"></param>
|
||
/// <param name="tagValue"></param>
|
||
/// <param name="isGoodBad"></param>
|
||
/// <param name="opName"></param>
|
||
/// <param name="partPallet"></param>
|
||
/// <param name="tagID"></param>
|
||
/// <param name="tagID_CF"></param>
|
||
/// <returns></returns>
|
||
public static bool BaseData_tagTable_QualityData_B5A_Insert
|
||
(int engineTypeID, string engineType, string engineID,
|
||
string tagValue, int isGoodBad,
|
||
string opName, string partPallet, int tagID, int tagID_CF)
|
||
{
|
||
string procedureName;
|
||
procedureName = "测量数据合格_手动拧紧_增加";
|
||
SqlParameter[] thisParms = new SqlParameter[9];
|
||
thisParms[0] = new System.Data.SqlClient.SqlParameter("@EngineTypeID", engineTypeID);
|
||
thisParms[1] = new System.Data.SqlClient.SqlParameter("@EngineType", engineType);
|
||
thisParms[2] = new System.Data.SqlClient.SqlParameter("@EngineID", engineID);
|
||
thisParms[3] = new System.Data.SqlClient.SqlParameter("@TagValue", tagValue);
|
||
thisParms[4] = new System.Data.SqlClient.SqlParameter("@合格标志", isGoodBad);
|
||
thisParms[5] = new System.Data.SqlClient.SqlParameter("@工位号", opName);
|
||
thisParms[6] = new System.Data.SqlClient.SqlParameter("@托盘编号", partPallet);
|
||
thisParms[7] = new System.Data.SqlClient.SqlParameter("@TagID", tagID);
|
||
thisParms[8] = new System.Data.SqlClient.SqlParameter("@TagID_CF", tagID_CF);
|
||
return DataAccess.ExecuteStoredProcedure(procedureName, ref thisParms);
|
||
}
|
||
|
||
/// <summary>
|
||
/// ALTER PROCEDURE [dbo].[电子看板_发动机号_总合格标志_增加]
|
||
///@工位号 nvarchar(50) = null,
|
||
///@发动机号 nvarchar(50) = null,
|
||
///@合格标志 int = 0测量数据合格索引_增加
|
||
///0合格；1不合格
|
||
/// </summary>
|
||
/// <param name="opName"></param>
|
||
/// <param name="EngineID"></param>
|
||
/// <param name="isOK"></param>
|
||
/// <returns></returns>
|
||
public static bool BaseData_tagTable_Engine_IsOK_Insert
|
||
(string opName, string EngineID, int isOK)
|
||
{
|
||
string procedureName;
|
||
procedureName = "电子看板_发动机号_总合格标志_增加";
|
||
SqlParameter[] thisParms = new SqlParameter[3];
|
||
thisParms[0] = new System.Data.SqlClient.SqlParameter("@工位号", opName);
|
||
thisParms[1] = new System.Data.SqlClient.SqlParameter("@发动机号", EngineID);
|
||
thisParms[2] = new System.Data.SqlClient.SqlParameter("@合格标志", isOK);
|
||
|
||
if (DataAccess.ExecuteStoredProcedure(procedureName, ref thisParms))
|
||
{
|
||
return true;
|
||
}
|
||
return false;
|
||
}
|
||
|
||
|
||
/// <summary>
|
||
/// 电子看板_发动机号_不合格放行_查询
|
||
/// </summary>
|
||
/// <param name="opName"></param>
|
||
/// <param name="EngineID"></param>
|
||
/// <param name="dt"></param>
|
||
/// <returns></returns>
|
||
public static bool BaseData_tagTable_Engine_IsNG_Select
|
||
(string opName, string EngineID, out DataTable dt)
|
||
{
|
||
string procedureName;
|
||
procedureName = "电子看板_发动机号_不合格放行_查询";
|
||
SqlParameter[] thisParms = new SqlParameter[2];
|
||
thisParms[0] = new System.Data.SqlClient.SqlParameter("@工位号", opName);
|
||
thisParms[1] = new System.Data.SqlClient.SqlParameter("@发动机号", EngineID);
|
||
|
||
if (DataAccess.ExecuteStoredProcedure(procedureName, ref thisParms,out dt))
|
||
{
|
||
if (dt != null)
|
||
{
|
||
if(dt.Rows.Count==1)
|
||
return true;
|
||
}
|
||
return false;
|
||
}
|
||
return false;
|
||
}
|
||
/// <summary>
|
||
/// 电子看板_发动机号_不合格放行_增加
|
||
/// </summary>
|
||
/// <param name="opName"></param>
|
||
/// <param name="EngineID"></param>
|
||
/// <param name="worker"></param>
|
||
/// <param name="text"></param>
|
||
/// <returns></returns>
|
||
public static bool BaseData_tagTable_Engine_IsNG_Insert
|
||
(string opName, string EngineID, string worker,string text)
|
||
{
|
||
string procedureName;
|
||
procedureName = "电子看板_发动机号_不合格放行_增加";
|
||
SqlParameter[] thisParms = new SqlParameter[4];
|
||
thisParms[0] = new System.Data.SqlClient.SqlParameter("@工位号", opName);
|
||
thisParms[1] = new System.Data.SqlClient.SqlParameter("@发动机号", EngineID);
|
||
thisParms[2] = new System.Data.SqlClient.SqlParameter("@操作者编号", worker);
|
||
thisParms[3] = new System.Data.SqlClient.SqlParameter("@不合格原因", text);
|
||
|
||
if (DataAccess.ExecuteStoredProcedure(procedureName, ref thisParms))
|
||
{
|
||
return true;
|
||
}
|
||
return false;
|
||
}
|
||
/// <summary>
|
||
/// 电子看板_发动机号_不合格放行_删除
|
||
/// </summary>
|
||
/// <param name="opName"></param>
|
||
/// <param name="EngineID"></param>
|
||
/// <returns></returns>
|
||
public static bool BaseData_tagTable_Engine_IsNG_Delete
|
||
(string opName, string EngineID)
|
||
{
|
||
string procedureName;
|
||
procedureName = "电子看板_发动机号_不合格放行_删除";
|
||
SqlParameter[] thisParms = new SqlParameter[2];
|
||
thisParms[0] = new System.Data.SqlClient.SqlParameter("@工位号", opName);
|
||
thisParms[1] = new System.Data.SqlClient.SqlParameter("@发动机号", EngineID);
|
||
|
||
return DataAccess.ExecuteStoredProcedure(procedureName, ref thisParms);
|
||
}
|
||
|
||
|
||
}
|
||
}
|