282 lines
16 KiB
C#
282 lines
16 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>
|
||
/// 根据工位号，将计划下达到工位PC
|
||
/// [MES_计划BOM_订单计划下达_执行顺序]
|
||
/// [MES_计划BOM_发动机号]
|
||
/// [MES_计划BOM_发动机装配指南]
|
||
/// </summary>
|
||
/// <param name="opName"></param>
|
||
//public static void GetOrderForm(string opName)
|
||
//{
|
||
// //订单号
|
||
// string orderForm;
|
||
// //1：获得需要下达的订单列表
|
||
// DataTable dt_orderForm;
|
||
// OrderFormOpName_Select(opName, out dt_orderForm);
|
||
// if (dt_orderForm != null)
|
||
// {
|
||
// for (int i = 0; i < dt_orderForm.Rows.Count; i++)
|
||
// {
|
||
// try
|
||
// {
|
||
// orderForm = dt_orderForm.Rows[i]["订单号"].ToString();
|
||
// //2：根据订单号，工位号，获得[MES_计划BOM_订单计划下达_执行顺序]
|
||
// //[MES_计划BOM_发动机号]
|
||
// //[MES_计划BOM_发动机装配指南]
|
||
// DataTable dt_OrderFormOrderBy;
|
||
// DataTable dt_EngineID;
|
||
// DataTable dt_OperationGuid;
|
||
// GetOrderPlanEngineNumber_OrderForm(orderForm, out dt_OrderFormOrderBy);
|
||
// GetOrderPlanEngineNumberToPcStation(orderForm, out dt_EngineID);
|
||
// GetOperationGuid(orderForm, opName, out dt_OperationGuid);
|
||
|
||
// //3将数据导入到工位PC
|
||
|
||
// if (!GetOrderPlanEngineNumberToPcStation_OrderForm_Delete(orderForm)) continue;
|
||
// if(!GetOrderPlanEngineNumberToPcStation_Delete(orderForm)) continue;
|
||
// if(!GetOperationGuidToPcStation_Delete(orderForm)) continue;
|
||
|
||
// if(!GetOrderPlanEngineNumberToPcStation_OrderForm(dt_OrderFormOrderBy)) continue;
|
||
// if(!GetOrderPlanEngineNumberToPcStation(dt_EngineID)) continue;
|
||
// if(!GetOperationGuidToPcStation(dt_OperationGuid)) continue;
|
||
|
||
// OrderFormOpName_Update(orderForm, opName);
|
||
// }
|
||
// catch (Exception err)
|
||
// {
|
||
// //ApplicationLog.WriteLog(err,err.Message);
|
||
// }
|
||
|
||
// }
|
||
// }
|
||
//}
|
||
/// <summary>
|
||
/// "delete from [MES_计划BOM_订单计划下达_执行顺序] where 订单号='" + orderForm + "'";
|
||
/// </summary>
|
||
/// <param name="orderForm"></param>
|
||
//private static bool GetOrderPlanEngineNumberToPcStation_OrderForm_Delete(string orderForm)
|
||
//{
|
||
// string sql;
|
||
// sql = "delete from [MES_计划BOM_订单计划下达_执行顺序] where 订单号='" + orderForm + "'";
|
||
// return DataAccess.ExecuteSQL_OleDb_Access(sql);
|
||
//}
|
||
/// <summary>
|
||
/// "delete from [MES_计划BOM_发动机号] where 订单号='" + orderForm + "'";
|
||
/// </summary>
|
||
/// <param name="orderForm"></param>
|
||
//private static bool GetOrderPlanEngineNumberToPcStation_Delete(string orderForm)
|
||
//{
|
||
// string sql;
|
||
// sql = "delete from [MES_计划BOM_发动机号] where 订单号='" + orderForm + "'";
|
||
// return DataAccess.ExecuteSQL_OleDb_Access(sql);
|
||
//}
|
||
/// <summary>
|
||
/// "delete from [MES_计划BOM_订单计划下达_执行顺序] where 订单号='" + orderForm + "'";
|
||
/// </summary>
|
||
/// <param name="orderForm"></param>
|
||
//private static bool GetOperationGuidToPcStation_Delete(string orderForm)
|
||
//{
|
||
// string sql;
|
||
// sql = "delete from [MES_计划BOM_发动机装配指南] where 订单号='" + orderForm + "'";
|
||
// return DataAccess.ExecuteSQL_OleDb_Access(sql);
|
||
//}
|
||
/// <summary>
|
||
/// exec MES_计划BOM_发动机订单计划_下达工位_修改
|
||
/// set 同步状态=1,同步日期=getdate()
|
||
/// </summary>
|
||
/// <param name="orderForm"></param>
|
||
/// <param name="opName"></param>
|
||
public static void OrderFormOpName_Update(string orderForm,string opName)
|
||
{
|
||
string sql;
|
||
sql = "exec MES_计划BOM_发动机订单计划_下达工位_修改 '"+orderForm+"','"+opName+"'";
|
||
DataAccess.ExecuteSQL(sql);
|
||
}
|
||
/// <summary>
|
||
/// 获得工位对应的订单号
|
||
/// MES_计划BOM_发动机订单计划_下达工位
|
||
/// </summary>
|
||
/// <param name="opName"></param>
|
||
/// <param name="dt"></param>
|
||
public static void OrderFormOpName_Select(string opName, out DataTable dt)
|
||
{
|
||
string sql;
|
||
|
||
|
||
|
||
sql = "select 订单号 from MES_计划BOM_发动机订单计划_下达工位 "
|
||
+ " where 同步状态 = 0 and 工位号='" + opName + "'";
|
||
DataAccess.ExecuteDataTable(sql, out dt);
|
||
|
||
|
||
|
||
}
|
||
/// <summary>
|
||
/// 下达装配BOM到工位Access文件 INSERT INTO [MES_计划BOM_发动机装配指南]
|
||
/// </summary>
|
||
/// <param name="dt"></param>
|
||
//static public bool GetOperationGuidToPcStation(DataTable dt)
|
||
//{
|
||
// string sql;
|
||
// sql =
|
||
// "INSERT INTO [MES_计划BOM_发动机装配指南]" +
|
||
// "([订单号], [主配厂家],[工位号], [工位名称], [物料号], [零件图号], [零件名称]," +
|
||
// " [零件数量],[是否扫描],[扫描方式],[是否主物料],[厂家代码], [生产厂家],[操作指导] )" +
|
||
// "VALUES(@订单号,@主配厂家,@工位号,@工位名称,@物料号,@零件图号,@零件名称," +
|
||
// "@零件数量,@是否扫描,@扫描方式,@是否主物料,@厂家代码,@生产厂家,@操作指导)";
|
||
// OleDbParameter[] thisParms = new OleDbParameter[14];
|
||
// thisParms[0] = new OleDbParameter("@订单号", OleDbType.VarChar, 50, "订单号");
|
||
// thisParms[1] = new OleDbParameter("@主配厂家", OleDbType.VarChar, 50, "主配厂家");
|
||
// thisParms[2] = new OleDbParameter("@工位号", OleDbType.VarChar, 50, "工位号");
|
||
// thisParms[3] = new OleDbParameter("@工位名称", OleDbType.VarChar, 255, "工位名称");
|
||
// thisParms[4] = new OleDbParameter("@物料号", OleDbType.VarChar, 50, "物料号");
|
||
// thisParms[5] = new OleDbParameter("@零件图号", OleDbType.VarChar, 50, "零件图号");
|
||
// thisParms[6] = new OleDbParameter("@零件名称", OleDbType.VarChar, 255, "零件名称");
|
||
// thisParms[7] = new OleDbParameter("@零件数量", OleDbType.Integer, 4, "零件数量");
|
||
// thisParms[8] = new OleDbParameter("@是否扫描", OleDbType.Integer, 4, "是否扫描");
|
||
// thisParms[9] = new OleDbParameter("@扫描方式", OleDbType.Integer, 4, "扫描方式");
|
||
// thisParms[10] = new OleDbParameter("@是否主物料", OleDbType.Integer, 4, "是否主物料");
|
||
// thisParms[11] = new OleDbParameter("@厂家代码", OleDbType.VarChar, 255, "厂家代码");
|
||
// thisParms[12] = new OleDbParameter("@生产厂家", OleDbType.VarChar, 255, "生产厂家");
|
||
// thisParms[13] = new OleDbParameter("@操作指导", OleDbType.VarChar, 255, "操作指导");
|
||
|
||
// return DataAccess.ExecuteDataTable_OleDb_Insert_Access(sql, dt, ref thisParms);
|
||
|
||
//}
|
||
/// <summary>
|
||
/// 下达装配BOM的发动机号到工位Access文件 INSERT INTO [MES_计划BOM_发动机号]
|
||
/// </summary>
|
||
/// <param name="dt"></param>
|
||
//static public bool GetOrderPlanEngineNumberToPcStation(DataTable dt)
|
||
//{
|
||
// string sql;
|
||
// sql =
|
||
// "INSERT INTO [MES_计划BOM_发动机号]" +
|
||
// "([发动机号], [订单号], [SAP物料号], [发动机型号], [发动机型号代码], [发动机机型]," +
|
||
// "[发动机数量], [厂牌编号起始号], [客户名称], [投料日期], [文件编号], [集团名称], [通知号], " +
|
||
// "[功率], [指南文件编号], [装机状态], [适用状态], [物料描述],[计划下达日期])" +
|
||
// "VALUES(@发动机号,@订单号,@SAP物料号,@发动机型号,@发动机型号代码,@发动机机型," +
|
||
// "@发动机数量,@厂牌编号起始号,@客户名称,@投料日期,@文件编号,@集团名称,@通知号," +
|
||
// "@功率,@指南文件编号,@装机状态,@适用状态,@物料描述,@计划下达日期)";
|
||
// OleDbParameter[] thisParms = new OleDbParameter[19];
|
||
// thisParms[0] = new OleDbParameter("@发动机号", OleDbType.VarChar, 50, "发动机号");
|
||
// thisParms[1] = new OleDbParameter("@订单号", OleDbType.VarChar, 50, "订单号");
|
||
// thisParms[2] = new OleDbParameter("@SAP物料号", OleDbType.VarChar, 50, "SAP物料号");
|
||
// thisParms[3] = new OleDbParameter("@发动机型号", OleDbType.VarChar, 50, "发动机型号");
|
||
// thisParms[4] = new OleDbParameter("@发动机型号代码", OleDbType.Integer, 4, "发动机型号代码");
|
||
// thisParms[5] = new OleDbParameter("@发动机机型", OleDbType.VarChar, 50, "发动机机型");
|
||
|
||
// thisParms[6] = new OleDbParameter("@发动机数量", OleDbType.Integer, 4, "发动机数量");
|
||
// thisParms[7] = new OleDbParameter("@厂牌编号起始号", OleDbType.VarChar, 50, "厂牌编号起始号");
|
||
// thisParms[8] = new OleDbParameter("@客户名称", OleDbType.VarChar, 255, "客户名称");
|
||
// thisParms[9] = new OleDbParameter("@投料日期", OleDbType.DBDate, 8, "投料日期");
|
||
// thisParms[10] = new OleDbParameter("@文件编号", OleDbType.VarChar, 50, "文件编号");
|
||
// thisParms[11] = new OleDbParameter("@集团名称", OleDbType.VarChar, 255, "集团名称");
|
||
// thisParms[12] = new OleDbParameter("@通知号", OleDbType.VarChar, 50, "通知号");
|
||
|
||
// thisParms[13] = new OleDbParameter("@功率", OleDbType.VarChar, 50, "功率");
|
||
// thisParms[14] = new OleDbParameter("@指南文件编号", OleDbType.VarChar, 50, "指南文件编号");
|
||
// thisParms[15] = new OleDbParameter("@装机状态", OleDbType.VarChar, 50, "装机状态");
|
||
// thisParms[16] = new OleDbParameter("@适用状态", OleDbType.VarChar, 50, "适用状态");
|
||
// thisParms[17] = new OleDbParameter("@物料描述", OleDbType.VarChar, 255, "物料描述");
|
||
// thisParms[18] = new OleDbParameter("@计划下达日期", OleDbType.DBDate, 8, "计划下达日期");
|
||
|
||
// return DataAccess.ExecuteDataTable_OleDb_Insert_Access(sql, dt, ref thisParms);
|
||
|
||
//}
|
||
/// <summary>
|
||
/// 下达装配BOM的发动机号到工位Access文件 INSERT INTO [MES_计划BOM_订单计划下达_执行顺序]
|
||
/// </summary>
|
||
/// <param name="dt"></param>
|
||
//static public bool GetOrderPlanEngineNumberToPcStation_OrderForm(DataTable dt)
|
||
//{
|
||
// string sql;
|
||
// sql =
|
||
// "INSERT INTO [MES_计划BOM_订单计划下达_执行顺序]" +
|
||
// "([订单号],[执行顺序],[SAP物料号], [发动机型号], [发动机型号代码], [发动机机型]," +
|
||
// "[发动机数量], [厂牌编号起始号], [客户名称], [投料日期], [文件编号], [集团名称], [通知号], " +
|
||
// "[功率], [指南文件编号], [装机状态], [适用状态], [物料描述],[计划下达日期])" +
|
||
// "VALUES(@订单号,@执行顺序,@SAP物料号,@发动机型号,@发动机型号代码,@发动机机型," +
|
||
// "@发动机数量,@厂牌编号起始号,@客户名称,@投料日期,@文件编号,@集团名称,@通知号," +
|
||
// "@功率,@指南文件编号,@装机状态,@适用状态,@物料描述,@计划下达日期)";
|
||
// OleDbParameter[] thisParms = new OleDbParameter[19];
|
||
// thisParms[0] = new OleDbParameter("@订单号", OleDbType.VarChar, 50, "订单号");
|
||
// thisParms[1] = new OleDbParameter("@执行顺序", OleDbType.Integer, 4, "执行顺序");
|
||
// thisParms[2] = new OleDbParameter("@SAP物料号", OleDbType.VarChar, 50, "SAP物料号");
|
||
// thisParms[3] = new OleDbParameter("@发动机型号", OleDbType.VarChar, 50, "发动机型号");
|
||
// thisParms[4] = new OleDbParameter("@发动机型号代码", OleDbType.Integer, 4, "发动机型号代码");
|
||
// thisParms[5] = new OleDbParameter("@发动机机型", OleDbType.VarChar, 50, "发动机机型");
|
||
|
||
// thisParms[6] = new OleDbParameter("@发动机数量", OleDbType.Integer, 4, "发动机数量");
|
||
// thisParms[7] = new OleDbParameter("@厂牌编号起始号", OleDbType.VarChar, 50, "厂牌编号起始号");
|
||
// thisParms[8] = new OleDbParameter("@客户名称", OleDbType.VarChar, 255, "客户名称");
|
||
// thisParms[9] = new OleDbParameter("@投料日期", OleDbType.DBDate, 8, "投料日期");
|
||
// thisParms[10] = new OleDbParameter("@文件编号", OleDbType.VarChar, 50, "文件编号");
|
||
// thisParms[11] = new OleDbParameter("@集团名称", OleDbType.VarChar, 255, "集团名称");
|
||
// thisParms[12] = new OleDbParameter("@通知号", OleDbType.VarChar, 50, "通知号");
|
||
|
||
// thisParms[13] = new OleDbParameter("@功率", OleDbType.VarChar, 50, "功率");
|
||
// thisParms[14] = new OleDbParameter("@指南文件编号", OleDbType.VarChar, 50, "指南文件编号");
|
||
// thisParms[15] = new OleDbParameter("@装机状态", OleDbType.VarChar, 50, "装机状态");
|
||
// thisParms[16] = new OleDbParameter("@适用状态", OleDbType.VarChar, 50, "适用状态");
|
||
// thisParms[17] = new OleDbParameter("@物料描述", OleDbType.VarChar, 255, "物料描述");
|
||
// thisParms[18] = new OleDbParameter("@计划下达日期", OleDbType.DBDate, 8, "计划下达日期");
|
||
|
||
// return DataAccess.ExecuteDataTable_OleDb_Insert_Access(sql, dt, ref thisParms);
|
||
|
||
//}
|
||
/// <summary>
|
||
/// 根据订单号，工位号获得[MES_计划BOM_发动机装配指南]
|
||
/// </summary>
|
||
/// <param name="orderForm">订单号</param>
|
||
/// <param name="opName">工位号</param>
|
||
/// <param name="dt">MES_计划BOM_发动机装配指南</param>
|
||
/// <returns></returns>
|
||
static public bool GetOperationGuid(string orderForm,string opName,out DataTable dt)
|
||
{
|
||
string sql;
|
||
sql = "exec MES_计划BOM_发动机装配指南_查询_下达到工位 '" + orderForm + "','" + opName + "'";
|
||
return DataAccess.ExecuteDataTable(sql, out dt);
|
||
}
|
||
/// <summary>
|
||
/// 根据订单号 [MES_计划BOM_订单计划下达_执行顺序]
|
||
/// </summary>
|
||
/// <param name="orderForm">订单号</param>
|
||
/// <param name="dt">[MES_计划BOM_订单计划下达_执行顺序] </param>
|
||
static public bool GetOrderPlanEngineNumber_OrderForm(string orderForm, out DataTable dt)
|
||
{
|
||
string sql;
|
||
sql = "exec MES_计划BOM_发动机订单计划_查询_下达到工位 '" + orderForm + "'";
|
||
return DataAccess.ExecuteDataTable(sql, out dt);
|
||
|
||
}
|
||
/// <summary>
|
||
/// 根据订单号 [MES_计划BOM_发动机号]
|
||
/// </summary>
|
||
/// <param name="orderForm">订单号</param>
|
||
/// <param name="dt">[MES_计划BOM_发动机号]</param>
|
||
static public bool GetOrderPlanEngineNumberToPcStation(string orderForm, out DataTable dt)
|
||
{
|
||
string sql;
|
||
sql = "exec MES_计划BOM_发动机号_查询_下达到工位 '" + orderForm + "'";
|
||
return DataAccess.ExecuteDataTable(sql, out dt);
|
||
}
|
||
}
|
||
}
|