99 lines
3.3 KiB
C#
99 lines
3.3 KiB
C#
using System;
|
|
using System.Collections.Generic;
|
|
using System.Text;
|
|
using System.Data;
|
|
using System.Data.SqlClient;
|
|
using DataLinkMesWork;
|
|
|
|
|
|
//using SystemFramework;
|
|
|
|
namespace bizFacade
|
|
{
|
|
public partial class BaseDataSystemMES
|
|
{
|
|
/// <summary>
|
|
/// MES_基本变量_DB数据结构_查询
|
|
/// </summary>
|
|
public static DataTable MobyDataStructureSelect()
|
|
{
|
|
DataTable dt;
|
|
string sql;
|
|
sql = "SELECT * FROM MES_基本变量_DB数据结构 ORDER BY [序号] ";
|
|
DataAccess.ExecuteDataTable(sql, out dt);
|
|
return dt;
|
|
}
|
|
|
|
/// <summary>
|
|
/// MES_模拟MOBY数据_增加
|
|
/// 增加一台发动机
|
|
/// 返回该台发动机数据
|
|
/// </summary>
|
|
public static DataTable MobyInsert()
|
|
{
|
|
DataTable dt;
|
|
string procedureName;
|
|
procedureName = "MES_模拟MOBY数据_增加";
|
|
DataAccess.ExecuteStoredProcedure(procedureName, out dt);
|
|
return dt;
|
|
}
|
|
|
|
/// <summary>
|
|
/// MES_模拟MOBY数据_查询
|
|
/// </summary>
|
|
/// <param name="engineNumber">发动机号</param>
|
|
/// <returns></returns>
|
|
public static DataTable MobySelect(string engineNumber)
|
|
{
|
|
DataTable dt;
|
|
string procedureName;
|
|
procedureName = "MES_模拟MOBY数据_查询";
|
|
SqlParameter[] thisParms = new SqlParameter[1];
|
|
thisParms[0] = new System.Data.SqlClient.SqlParameter("@发动机号", engineNumber);
|
|
DataAccess.ExecuteStoredProcedure(procedureName, ref thisParms, out dt);
|
|
return dt;
|
|
}
|
|
|
|
/// <summary>
|
|
/// MES_模拟MOBY数据_查询
|
|
/// </summary>
|
|
/// <param name="engineNumber">发动机号</param>
|
|
/// <param name="number"></param>
|
|
/// <param name="tagValue"></param>
|
|
/// <returns></returns>
|
|
public static void MobyUpdate(string engineNumber, int number, string tagValue)
|
|
{
|
|
string procedureName;
|
|
procedureName = "MES_模拟MOBY数据_查询";
|
|
SqlParameter[] thisParms = new SqlParameter[3];
|
|
thisParms[0] = new System.Data.SqlClient.SqlParameter("@发动机号", engineNumber);
|
|
thisParms[1] = new System.Data.SqlClient.SqlParameter("@序号", engineNumber);
|
|
thisParms[2] = new System.Data.SqlClient.SqlParameter("@数值", engineNumber);
|
|
DataAccess.ExecuteStoredProcedure(procedureName, ref thisParms);
|
|
return;
|
|
}
|
|
/// <summary>
|
|
/// MES_模拟MOBY数据_修改
|
|
/// 序号 =27 ，工位代码
|
|
/// </summary>
|
|
/// <param name="engineNumber">发动机号</param>
|
|
/// <param name="tagValue"></param>
|
|
/// <returns></returns>
|
|
public static void MobyUpdate(string engineNumber, string tagValue)
|
|
{
|
|
int number;
|
|
|
|
number = 27;
|
|
|
|
string procedureName;
|
|
procedureName = "MES_模拟MOBY数据_修改";
|
|
SqlParameter[] thisParms = new SqlParameter[3];
|
|
thisParms[0] = new System.Data.SqlClient.SqlParameter("@发动机号", engineNumber);
|
|
thisParms[1] = new System.Data.SqlClient.SqlParameter("@序号", number);
|
|
thisParms[2] = new System.Data.SqlClient.SqlParameter("@数值", tagValue);
|
|
DataAccess.ExecuteStoredProcedure(procedureName, ref thisParms);
|
|
return;
|
|
}
|
|
}
|
|
}
|