62 lines
2.2 KiB
C#
62 lines
2.2 KiB
C#
using System;
|
|
using System.Collections.Generic;
|
|
using System.Text;
|
|
using System.Data;
|
|
using System.Data.SqlClient;
|
|
using DataLinkMesWork;
|
|
using System.Security.Cryptography;
|
|
//using SystemFramework;
|
|
|
|
namespace bizFacade
|
|
{
|
|
public partial class MES1
|
|
{
|
|
/// <summary>
|
|
/// 测量数据工位_监控系统_MOBY_查询
|
|
/// </summary>
|
|
/// <param name="opName"></param>
|
|
/// <param name="IsAllowWork"></param>
|
|
/// <returns></returns>
|
|
public static void Moby_Select(string opName, out string OrderForm,
|
|
out int EngineTypeID, out string EngineType, out string EngineID, out string PartPallet_Code,
|
|
out int IsrepairBarcode, out string repairBarcode)
|
|
{
|
|
DataTable dt= new DataTable();
|
|
OrderForm = "";
|
|
EngineTypeID = 0;
|
|
EngineType = "";
|
|
EngineID = "";
|
|
PartPallet_Code = "";
|
|
IsrepairBarcode = 0;
|
|
repairBarcode = "";
|
|
try
|
|
{
|
|
string procedureName;
|
|
procedureName = "北汽福田工位状态监控MOBY_查询_订单下达用";
|
|
SqlParameter[] thisParms = new SqlParameter[1];
|
|
thisParms[0] = new System.Data.SqlClient.SqlParameter("@工位号", opName);
|
|
|
|
DataAccess.ExecuteStoredProcedure(procedureName, ref thisParms,out dt);
|
|
if(dt.Rows.Count > 0 )
|
|
{
|
|
OrderForm = dt.Rows[0][MobyTagType.OrderForm_MES].ToString();
|
|
EngineTypeID = Convert.ToInt32(dt.Rows[0][MobyTagType.EngineTypeID_MES]); ;
|
|
EngineType = dt.Rows[0][MobyTagType.EngineType_MES].ToString();
|
|
EngineID = dt.Rows[0][MobyTagType.EngineID_MES].ToString();
|
|
PartPallet_Code = dt.Rows[0][MobyTagType.PartPallet_Code].ToString();
|
|
}
|
|
}
|
|
catch
|
|
{
|
|
OrderForm = "";
|
|
EngineTypeID = 0;
|
|
EngineType = "";
|
|
EngineID = "";
|
|
PartPallet_Code = "";
|
|
IsrepairBarcode = 0;
|
|
repairBarcode = "";
|
|
}
|
|
}
|
|
}
|
|
}
|