69 lines
2.4 KiB
C#
69 lines
2.4 KiB
C#
using System;
|
|
using System.Collections.Generic;
|
|
using System.Linq;
|
|
using System.Text;
|
|
|
|
namespace AVS
|
|
{
|
|
public class DailyLog
|
|
{
|
|
public string FNSKU { get; set; }
|
|
public DateTime RECORD_DATE { get; set; }
|
|
public string SYS_IP { get; set; }
|
|
public string USER_ID { get; set; }
|
|
|
|
public decimal LIVE_WEIGHT { get; set; }
|
|
|
|
public string WRONG_FNSKU { get; set; }
|
|
|
|
public bool IS_WEIGHT_WRONG { get; set; }
|
|
|
|
public bool IS_FNSKU_WRONG { get; set; }
|
|
|
|
public string MODEL_NO { get; set; }
|
|
|
|
public decimal NET_WEIGHT { get; set; }
|
|
|
|
public string WRONG_CARTON { get; set; }
|
|
|
|
public string MARKET_PLACE { get; set; }
|
|
public string PC_NAME { get; set; }
|
|
public class TableColumn
|
|
{
|
|
public string Name { get; set; }
|
|
public string DataType { get; set; }
|
|
}
|
|
|
|
public class DailyLogTable
|
|
{
|
|
public static List<TableColumn> GetColumns()
|
|
{
|
|
return new List<TableColumn>
|
|
{
|
|
new TableColumn { Name = "Id", DataType = "INTEGER PRIMARY KEY AUTOINCREMENT" },
|
|
new TableColumn { Name = "FNSKU", DataType = "TEXT" },
|
|
new TableColumn { Name = "RECORD_DATE", DataType = "DATETIME" },
|
|
new TableColumn { Name = "SYS_IP", DataType = "TEXT" },
|
|
new TableColumn { Name = "USER_ID", DataType = "TEXT" },
|
|
new TableColumn { Name = "LIVE_WEIGHT", DataType = "REAL" },
|
|
new TableColumn { Name = "WRONG_FNSKU", DataType = "TEXT" },
|
|
new TableColumn { Name = "IS_WEIGHT_WRONG", DataType = "BOOLEAN" },
|
|
new TableColumn { Name = "IS_FNSKU_WRONG", DataType = "BOOLEAN" },
|
|
new TableColumn { Name = "MODEL_NO", DataType = "TEXT" },
|
|
new TableColumn { Name = "NET_WEIGHT", DataType = "REAL" },
|
|
new TableColumn { Name = "WRONG_CARTON", DataType = "TEXT" },
|
|
new TableColumn { Name = "MARKET_PLACE", DataType = "TEXT" },
|
|
new TableColumn { Name = "PC_NAME", DataType = "TEXT" }
|
|
};
|
|
}
|
|
}
|
|
public static string GetColumnsDefinition(List<TableColumn> columns)
|
|
{
|
|
// Convert the list of columns into a string for the CREATE TABLE command
|
|
return string.Join(", ", columns.Select(c => $"{c.Name} {c.DataType}"));
|
|
}
|
|
|
|
|
|
}
|
|
}
|