public void CreateOrderDataTable()
{
tabOrderData = new DataTable();
tabOrderData.TableName = "OrderData";
tabOrderData.Columns.AddRange(new DataColumn[]
{
new DataColumn("ID", typeof(int)),
new DataColumn("OrderID", typeof(string)), //订单ID
new DataColumn("TC", typeof(string)), //台车
new DataColumn("Layer", typeof(string)), //层
new DataColumn("UUTCode", typeof(string)), //机台号
new DataColumn("Time", typeof(string)), //读取时间 00:00:01
new DataColumn("Content", typeof(string)), //读取值
new DataColumn("SysTime", typeof(string)), //读取值
});
tabOrderData.PrimaryKey = new DataColumn[] { tabOrderData.Columns["ID"] };
orderDataSqlInfo = new SqlInfo(tabOrderData, SqliteHelper.Instance);
SqliteHelper.Instance.CreateTab(tabOrderData, true);
}
public void CreateOrderTable()
{
tabOrder = new DataTable();
tabOrder.TableName = "CPOrder";
tabOrder.Columns.AddRange(new DataColumn[]
{
new DataColumn("ID", typeof(int)),
new DataColumn("CPXH", typeof(string)), //产品型号
new DataColumn("DDH", typeof(string)), //订单号
new DataColumn("ACInput", typeof(string)), //老化电压
new DataColumn("PFileName", typeof(string)), //参数名
new DataColumn("YJPZCSM", typeof(string)), //硬件配置参数名
new DataColumn("User", typeof(string)), //用户
new DataColumn("ParamContent", typeof(string)), //参数值
new DataColumn("StartTime", typeof(string)), //老化开始时间
new DataColumn("EndTime", typeof(string)) //老化结束时间
});
tabOrder.PrimaryKey = new DataColumn[] { tabOrder.Columns["ID"] };
orderSqlInfo = new SqlInfo(tabOrder, SqliteHelper.Instance);
SqliteHelper.Instance.CreateTab(tabOrder, true);
}