231 lines
11 KiB
C#
231 lines
11 KiB
C#
using System;
|
|
using System.Data;
|
|
using System.Data.SqlClient;
|
|
|
|
using System.Collections;
|
|
using System.Collections.Specialized;
|
|
//using SystemFramework;
|
|
using DataLinkMesWork;
|
|
namespace SystemFramework
|
|
{
|
|
|
|
}
|
|
namespace bizFacade
|
|
{
|
|
/// <summary>
|
|
/// 电子看板信息系统
|
|
/// select 重量1,重量2,重量差,允许重量差,合格标志
|
|
/// </summary>
|
|
public partial class BaseDataSystemMES
|
|
{
|
|
|
|
/// <summary>
|
|
/// 电子看板_发动机号_分线组件装配关系_增加
|
|
/// </summary>
|
|
/// <param name="engineID"></param>
|
|
/// <param name="engineTypeID"></param>
|
|
/// <param name="engineType"></param>
|
|
/// <param name="engineID_SubLine"></param>
|
|
//static public void MailLineAndSubLineData_InsertAAAAA(string engineID, int engineTypeID, string engineType, string engineID_SubLine)
|
|
//{
|
|
// string procedureName;
|
|
// procedureName = "电子看板_发动机号_分线组件装配关系_增加";
|
|
// SqlParameter[] thisParms = new SqlParameter[4];
|
|
// thisParms[0] = new System.Data.SqlClient.SqlParameter("@发动机号_分线", engineID_SubLine);
|
|
// thisParms[1] = new System.Data.SqlClient.SqlParameter("@发动机号", engineID);
|
|
// thisParms[2] = new System.Data.SqlClient.SqlParameter("@机型代码", engineTypeID);
|
|
// thisParms[3] = new System.Data.SqlClient.SqlParameter("@发动机型号", engineType);
|
|
// DataAccess.ExecuteStoredProcedure(procedureName, ref thisParms);
|
|
//}
|
|
|
|
/// <summary>
|
|
/// 思源库位管理_查询
|
|
/// </summary>
|
|
/// <param name="opName"></param>
|
|
/// <param name="engineID"></param>
|
|
/// <param name="dt"></param>
|
|
static public void GetUpLoadBarCode(string opName, out DataTable dt)
|
|
{
|
|
string procedureName;
|
|
procedureName = "思源库位管理_查询";
|
|
SqlParameter[] thisParms = new SqlParameter[1];
|
|
thisParms[0] = new System.Data.SqlClient.SqlParameter("@工位号", opName);
|
|
DataAccess.ExecuteStoredProcedure(procedureName, ref thisParms, out dt);
|
|
}
|
|
/// <summary>
|
|
/// [思源库位管理_下线库位_根据机型_查询]
|
|
/// </summary>
|
|
/// <param name="opName"></param>
|
|
/// <param name="engineID"></param>
|
|
/// <param name="dt"></param>
|
|
static public void GetUpLoadWarehouseNoOpName02(string opName,string EngineIDType, 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("@发动机型号", EngineIDType);
|
|
DataAccess.ExecuteStoredProcedure(procedureName, ref thisParms, out dt);
|
|
}
|
|
/// <summary>
|
|
/// 思源库位管理_下线库位查询 [思源库位管理_下线库位_根据机型_查询]
|
|
/// </summary>
|
|
/// <param name="opName"></param>
|
|
/// <param name="engineID"></param>
|
|
/// <param name="dt"></param>
|
|
static public void GetUnLoadWarehouseNo(string opName, out DataTable dt)
|
|
{
|
|
string procedureName;
|
|
procedureName = "思源库位管理_下线库位查询";
|
|
SqlParameter[] thisParms = new SqlParameter[1];
|
|
thisParms[0] = new System.Data.SqlClient.SqlParameter("@工位号", opName);
|
|
DataAccess.ExecuteStoredProcedure(procedureName, ref thisParms, out dt);
|
|
}
|
|
//[思源库位管理_上线发动机号订单号查询]
|
|
static public void GetUpLoadEngineIDOrderForm(string opName,string kuweihao, 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("@库位号", kuweihao);
|
|
DataAccess.ExecuteStoredProcedure(procedureName, ref thisParms, out dt);
|
|
}
|
|
static public void UpdateKuWeiStatus(string opName, string kuweihao)
|
|
{
|
|
string procedureName;
|
|
procedureName = "[思源库位管理_上线更新状态_修改]";
|
|
SqlParameter[] thisParms = new SqlParameter[2];
|
|
thisParms[0] = new System.Data.SqlClient.SqlParameter("@工位号", opName);
|
|
thisParms[1] = new System.Data.SqlClient.SqlParameter("@库位号", kuweihao);
|
|
DataAccess.ExecuteStoredProcedure(procedureName, ref thisParms);
|
|
}
|
|
static public void GetUpLoadBarCodeEngineID(string opName, out DataTable dt)
|
|
{
|
|
string procedureName;
|
|
procedureName = "[思源库位管理_上线发动机号查询]";
|
|
SqlParameter[] thisParms = new SqlParameter[1];
|
|
thisParms[0] = new System.Data.SqlClient.SqlParameter("@工位号", opName);
|
|
DataAccess.ExecuteStoredProcedure(procedureName, ref thisParms, out dt);
|
|
}
|
|
|
|
static public void ClearOpCarData(string opName)
|
|
{
|
|
string procedureName;
|
|
procedureName = "[思源库位管理_清空所有库位数据]";
|
|
SqlParameter[] thisParms = new SqlParameter[1];
|
|
thisParms[0] = new System.Data.SqlClient.SqlParameter("@工位号", opName);
|
|
DataAccess.ExecuteStoredProcedure(procedureName, ref thisParms);
|
|
}
|
|
// ALTER PROCEDURE[dbo].[思源库位管理_修改]
|
|
// @条码 nvarchar(50),
|
|
//@ nvarchar(50)=NULL,
|
|
//@ nvarchar(50),
|
|
//@ nvarchar(50),
|
|
|
|
//@工位号 nvarchar(50),
|
|
//@库位号 nvarchar(50)
|
|
static public void GetUpLoadBarCode_Update(string opName,string kuweiNum ,string barCode,string orderForm,
|
|
string EngineID, string EngineIDType, int typeID)
|
|
{
|
|
string procedureName;
|
|
procedureName = "思源库位管理_修改";
|
|
SqlParameter[] thisParms = new SqlParameter[7];
|
|
thisParms[0] = new System.Data.SqlClient.SqlParameter("@工位号", opName);
|
|
thisParms[1] = new System.Data.SqlClient.SqlParameter("@库位号", kuweiNum);
|
|
thisParms[2] = new System.Data.SqlClient.SqlParameter("@条码", barCode);
|
|
thisParms[3] = new System.Data.SqlClient.SqlParameter("@订单号", orderForm);
|
|
thisParms[4] = new System.Data.SqlClient.SqlParameter("@发动机号", EngineID);
|
|
thisParms[5] = new System.Data.SqlClient.SqlParameter("@发动机型号", EngineIDType);
|
|
thisParms[6] = new System.Data.SqlClient.SqlParameter("@机型代码", typeID);
|
|
DataAccess.ExecuteStoredProcedure(procedureName, ref thisParms);
|
|
}
|
|
|
|
static public void GetUpLoadBarCode_0utUpdate(string opName, string kuweiNum)
|
|
{
|
|
string procedureName;
|
|
procedureName = "思源库位管理_出库修改";
|
|
SqlParameter[] thisParms = new SqlParameter[2];
|
|
thisParms[0] = new System.Data.SqlClient.SqlParameter("@工位号", opName);
|
|
thisParms[1] = new System.Data.SqlClient.SqlParameter("@库位号", kuweiNum);
|
|
DataAccess.ExecuteStoredProcedure(procedureName, ref thisParms);
|
|
}
|
|
/// <summary>
|
|
/// 上线工位 扫面零件码 判断是否当前要加工的零件
|
|
/// </summary>
|
|
/// <param name="opName"></param>
|
|
/// <param name="dt"></param>
|
|
static public void CheckUpLoadPart(string partCode, string scanPosition, out DataTable dt)
|
|
{
|
|
string procedureName;
|
|
procedureName = "SY_MES_计划BOM_判断工件是否匹配";
|
|
SqlParameter[] thisParms = new SqlParameter[2];
|
|
thisParms[0] = new System.Data.SqlClient.SqlParameter("@partCode", partCode);
|
|
thisParms[1] = new System.Data.SqlClient.SqlParameter("@抓取位置", scanPosition);
|
|
DataAccess.ExecuteStoredProcedure(procedureName, ref thisParms, out dt);
|
|
}
|
|
/// <summary>
|
|
/// 线首工位自动查找生产订单
|
|
/// </summary>
|
|
/// <param name="dt"></param>
|
|
static public void GetUpLoadPart(out DataTable dt)
|
|
{
|
|
string procedureName;
|
|
procedureName = "SY_MES_计划BOM_线首工位自动查找生产订单";
|
|
SqlParameter[] thisParms = new SqlParameter[0];
|
|
DataAccess.ExecuteStoredProcedure(procedureName, ref thisParms, out dt);
|
|
}
|
|
/// <summary>
|
|
/// 查询工位最大盆子数量
|
|
/// </summary>
|
|
/// <param name="OpName"></param>
|
|
/// <param name="dt"></param>
|
|
static public void GetMaxPartCount(string OpName, out DataTable dt)
|
|
{
|
|
string procedureName;
|
|
procedureName = "测量数据发动机在线状态_工位绑定与上线盆子数";
|
|
SqlParameter[] thisParms = new SqlParameter[1];
|
|
thisParms[0] = new System.Data.SqlClient.SqlParameter("@工位号", OpName);
|
|
DataAccess.ExecuteStoredProcedure(procedureName, ref thisParms, out dt);
|
|
}
|
|
/// <summary>
|
|
/// 测量数据发动机在线状态_与订单数比对
|
|
/// </summary>
|
|
/// <param name="OpName"></param>
|
|
/// <param name="dt"></param>
|
|
static public void GetStartGoCount(out DataTable dt)
|
|
{
|
|
string procedureName;
|
|
procedureName = "测量数据发动机在线状态_与订单数比对";
|
|
SqlParameter[] thisParms = new SqlParameter[0];
|
|
DataAccess.ExecuteStoredProcedure(procedureName, ref thisParms, out dt);
|
|
}
|
|
static public void UpdateOrderStatus(string orderCode)
|
|
{
|
|
string procedureName;
|
|
procedureName = "SY_MES_计划BOM_更新订单生产状态";
|
|
SqlParameter[] thisParms = new SqlParameter[1];
|
|
thisParms[0] = new System.Data.SqlClient.SqlParameter("@订单号", orderCode);
|
|
DataAccess.ExecuteStoredProcedure(procedureName, ref thisParms);
|
|
}
|
|
//static public void SubLineLoadPartCountMatch_Select(string opName, out int SubLineLoadPartCountMatch)
|
|
//{
|
|
// string procedureName;
|
|
// DataTable dt;
|
|
// procedureName = "MES_计划BOM_工位与名称_工步属性查询";
|
|
// 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)
|
|
// {
|
|
// SubLineLoadPartCountMatch = Convert.ToInt32(dt.Rows[0][0]);
|
|
// }
|
|
// else
|
|
// {
|
|
// SubLineLoadPartCountMatch = 0;
|
|
// }
|
|
//}
|
|
|
|
}
|
|
}
|