74 lines
2.6 KiB
C#
74 lines
2.6 KiB
C#
using System;
|
|
using System.Collections.Generic;
|
|
using System.Text;
|
|
using System.Data;
|
|
using System.Data.SqlClient;
|
|
using DataLinkMesWork;
|
|
using SystemFramework;
|
|
|
|
namespace bizFacade
|
|
{
|
|
partial class BaseDataSystemMES
|
|
{
|
|
/// <summary>
|
|
/// [MES_计划BOM_发动机号]
|
|
/// SET 是否装配代码=1
|
|
/// </summary>
|
|
/// <returns></returns>
|
|
public static bool BaseData_tagTable_EngineID_UpDate(string EngineID)
|
|
{
|
|
string sql;
|
|
sql = "UPDATE MES_计划BOM_发动机号 "
|
|
+ "SET 是否装配代码=1"
|
|
+ " ,装配日期=CDATE('" + DateTime.Now.ToString("G")
|
|
+ "') "
|
|
+ " WHERE 发动机号='" + EngineID + "'";
|
|
return DataAccess.ExecuteSQL_OleDb_Access(sql);
|
|
}
|
|
|
|
/// <summary>
|
|
/// [MES_装配数据_工件到位离开时间_保留本地]
|
|
/// 计算当前日期装配的发动机数量
|
|
/// </summary>
|
|
/// <returns></returns>
|
|
public static int BaseData_tagTable_EngineID_Count()
|
|
{
|
|
int count;
|
|
string sql;
|
|
sql = "SELECT COUNT(*) FROM [MES_装配数据_工件到位离开时间_保留本地] "
|
|
+ "WHERE 计数日期=CDATE('" + DateTime.Now.ToString("d") + "')"
|
|
+ " AND 是否合格 = 1";
|
|
DataAccess.ExecuteOutNum_OleDb_Access(sql, out count);
|
|
return count;
|
|
}
|
|
|
|
|
|
//static public void ProduceCountInsert()
|
|
//{
|
|
// string sql;
|
|
// sql = "INSERT INTO MES_装配数据_实际产量(实际产量) VALUES(1)";
|
|
// DataAccess.ExecuteSQL_OleDb_Access(sql);
|
|
//}
|
|
//static public void ProduceCountDelete()
|
|
//{
|
|
// string sql;
|
|
// sql = "DELETE FROM MES_装配数据_实际产量 WHERE 生产日期<>CDATE('" + DateTime.Now.ToString("d") + "')";
|
|
// DataAccess.ExecuteSQL_OleDb_Access(sql);
|
|
//}
|
|
//static public void ProduceCountSelect(out DataTable dt)
|
|
//{
|
|
// string sql;
|
|
// sql = "SELECT * FROM MES_装配数据_实际产量 WHERE 生产日期=CDATE('" + DateTime.Now.ToString("d") + "')";
|
|
// DataAccess.ExecuteDataTable_OleDb_Access(sql, out dt);
|
|
//}
|
|
//static public void ProduceCountUpdate(int count)
|
|
//{
|
|
// string sql;
|
|
// sql = "UPDATE MES_装配数据_实际产量 "
|
|
// + " SET 实际产量=" + count.ToString()
|
|
// + " WHERE 生产日期=CDATE('" + DateTime.Now.ToString("d") + "')";
|
|
// DataAccess.ExecuteSQL_OleDb_Access(sql);
|
|
//}
|
|
}
|
|
}
|