53 lines
2.1 KiB
C#
53 lines
2.1 KiB
C#
using DataLinkMesWork;
|
|
using System;
|
|
using System.Collections.Generic;
|
|
using System.Data;
|
|
using System.Linq;
|
|
using System.Text;
|
|
using System.Threading.Tasks;
|
|
|
|
|
|
namespace MesServerFunctions
|
|
{
|
|
|
|
/// <summary>
|
|
/// 命令
|
|
///显示托盘信息√ case "ShowMoby":
|
|
///显示操作指南√ case "ProcessList":
|
|
///显示物料√ case "MaterialList":
|
|
///显示操作图片√ case "PicShow":
|
|
///显示拧紧位置√ case "ShaftPosition":
|
|
///实时显示质量数据√ case "ShowTimelyQuality":
|
|
///手动拧紧实时显示质量数据√case "ShowTimelyQuality_Tight":
|
|
///√ case "OrderFormList":
|
|
///弹窗消息√ case "Notice":
|
|
///LED消息提醒√ case "ScrollNotice":
|
|
///物料检测初始化√ case "MaterialCheckPosition":
|
|
///返修质量数据显示√ case "RepairQuality"
|
|
///
|
|
/// </summary>
|
|
public class MesServerCode
|
|
{
|
|
|
|
/// <summary>
|
|
/// MES_基本变量_DB数据结构_获得激发变量
|
|
/// </summary>
|
|
/// <returns></returns>
|
|
public static DataTable BaseData_tagTable_All()
|
|
{
|
|
int MES_Code = 1;
|
|
DataTable dt = null;
|
|
string sql;
|
|
sql = "SELECT TagID,0 as TagValue,TagName,工位号,数据来源,TagTypeID,TagLong,列位置,测量位置,变量类型代码,测量项目,TagAdr,TagAdrDemo,变量特点,变量排序 FROM [MES_基本变量_原始数据] "
|
|
+ " where ((变量类型代码 >= 19 and 变量类型代码 <= 27) or (变量类型代码 = 101) or (变量类型代码 = 102) or (变量类型代码 = 105) or (变量类型代码 = 1000) or (变量类型代码 = 1001) or (变量类型代码 = 1002) or (变量类型代码 = 1003) or (变量类型代码 = 1004)) and (是否启用 = 1) "
|
|
+ " and (监控属性代码 = '" + MES_Code.ToString() + "')"
|
|
+ " ORDER BY TagID ";
|
|
DataAccess.ExecuteDataTable(sql, out dt);
|
|
return dt;
|
|
}
|
|
|
|
|
|
}
|
|
}
|
|
|