using SqlSugar;
|
|
namespace PadApplication.Entites.DbModels;
|
|
/// <summary>
|
/// 数据源导入
|
/// </summary>
|
[SugarTable("V_ORDER_BYCL")]
|
public class VOrderBycl
|
{
|
/// <summary>
|
/// </summary>
|
[SugarColumn(ColumnName = "ID")]
|
public decimal ID { get; set; }
|
|
/// <summary>
|
/// </summary>
|
[SugarColumn(ColumnName = "DAA001")]
|
public string? Daa001 { get; set; }
|
|
/// <summary>
|
/// </summary>
|
[SugarColumn(ColumnName = "DAA014")]
|
public string? Daa014 { get; set; }
|
|
/// <summary>
|
/// </summary>
|
[SugarColumn(ColumnName = "DAA003")]
|
public string? Daa003 { get; set; }
|
|
/// <summary>
|
/// </summary>
|
[SugarColumn(ColumnName = "DAA002")]
|
public string? Daa002 { get; set; }
|
|
/// <summary>
|
/// </summary>
|
[SugarColumn(ColumnName = "DAA004")]
|
public string? Daa004 { get; set; }
|
|
/// <summary>
|
/// </summary>
|
[SugarColumn(ColumnName = "DAA008")]
|
public decimal? Daa008 { get; set; }
|
|
/// <summary>
|
///
|
/// </summary>
|
[SugarColumn(ColumnName = "DAA011")]
|
public decimal? Daa011 { get; set; }
|
|
/// <summary>
|
/// </summary>
|
[SugarColumn(ColumnName = "ADDRESS_CODE")]
|
public string? addressCode { get; set; }
|
|
/// <summary>
|
/// </summary>
|
[SugarColumn(ColumnName = "BGQTY")]
|
public decimal? BGQTY { get; set; }
|
|
/// <summary>
|
/// </summary>
|
[SugarColumn(ColumnName = "YJQTY")]
|
public decimal? YJQTY { get; set; }
|
|
/// <summary>
|
/// </summary>
|
[SugarColumn(ColumnName = "DAA012")]
|
public decimal? Daa012 { get; set; }
|
|
/// <summary>
|
/// 刀具代码
|
/// </summary>
|
[SugarColumn(ColumnName = "CUTTER_ID")]
|
public string? cutterId { get; set; }
|
|
/// <summary>
|
/// 刀具名称
|
/// </summary>
|
[SugarColumn(ColumnName = "CUTTER_NAME")]
|
public string? cutterName { get; set; }
|
|
/// <summary>
|
/// 刀具规格
|
/// </summary>
|
[SugarColumn(ColumnName = "CUTTER_MODEL")]
|
public string? cutterModel { get; set; }
|
|
/// <summary>
|
/// 工单状态
|
/// </summary>
|
[SugarColumn(ColumnName = "DAA018")]
|
public string? Daa018 { get; set; }
|
|
/// <summary>
|
/// 寿命预警(套数)
|
/// </summary>
|
[SugarColumn(ColumnName = "MODL_LIFE_WORNING")]
|
public decimal? ModlLifeWorning { get; set; }
|
|
/// <summary>
|
/// 加工数量
|
/// </summary>
|
[SugarColumn(ColumnName = "PRODUCE_NUM")]
|
public decimal? ProduceNum { get; set; }
|
|
/// <summary>
|
/// 今日报警次数
|
/// </summary>
|
[SugarColumn(ColumnName = "TODAY_FAULT_NUM")]
|
public double? TodayFaultNum { get; set; }
|
|
/// <summary>
|
/// 当天运行时间
|
/// </summary>
|
[SugarColumn(ColumnName = "TODAY_ONLINE_TIME")]
|
public double? TodayOnlineTime { get; set; }
|
|
/// <summary>
|
/// 日产量统计
|
/// </summary>
|
[SugarColumn(ColumnName = "TODAY_OUTPUT")]
|
public string? todayOutput { get; set; }
|
|
/// <summary>
|
/// 班次开始时间
|
/// </summary>
|
[SugarColumn(ColumnName = "WORK_START_DATE")]
|
public string? workStartDate { get; set; }
|
|
/// <summary>
|
/// 班次结束时间
|
/// </summary>
|
[SugarColumn(ColumnName = "WORK_END_DATE")]
|
public string? workEndDate { get; set; }
|
|
/// <summary>
|
/// 稼动率
|
/// </summary>
|
[SugarColumn(ColumnName = "JDL")]
|
public double? JDL { get; set; }
|
|
/// <summary>
|
/// 当天使用时间
|
/// </summary>
|
[SugarColumn(ColumnName = "TODAY_RUN_TIME")]
|
public double? todayRunTime { get; set; }
|
|
/// <summary>
|
/// 编辑日期
|
/// </summary>
|
[SugarColumn(ColumnName = "EDIT_DATE")]
|
public string? EditDate { get; set; }
|
|
/// <summary>
|
/// 机台编号
|
/// </summary>
|
[SugarColumn(ColumnName = "MACHINE_NO")]
|
public string? MachineNo { get; set; }
|
|
/// <summary>
|
/// 累计不良数
|
/// </summary>
|
[SugarColumn(ColumnName = "BL_QTY")]
|
public decimal? blQty { get; set; }
|
|
/// <summary>
|
/// 报工人
|
/// </summary>
|
[SugarColumn(ColumnName = "STAFF_NAME")]
|
public string? StaffName { get; set; }
|
|
/// <summary>
|
/// 报工时间
|
/// </summary>
|
[SugarColumn(ColumnName = "BG_DATE")]
|
public string? BgDate { get; set; }
|
|
/// <summary>
|
/// 工序名称
|
/// </summary>
|
[SugarColumn(ColumnName = "PROC_NAME")]
|
public string? ProcName { get; set; }
|
|
/// <summary>
|
/// 成型周期(s)
|
/// </summary>
|
[SugarColumn(ColumnName = "CUTTERING_CYC")]
|
public string? cutteringCyc { get; set; }
|
|
/// <summary>
|
/// 物料编码
|
/// </summary>
|
[SugarColumn(ColumnName = "ITEM_NO")]
|
public string? itemNo { get; set; }
|
|
[SugarColumn(IsIgnore = true)] public decimal? wjQty { get; set; }
|
[SugarColumn(IsIgnore = true)] public string? finalResult { get; set; }
|
|
// 新增:
|
[SugarColumn(IsIgnore = true)] public long? StartCjNum { get; set; }//开工数采(最早采集值)
|
[SugarColumn(IsIgnore = true)] public long? CurrentCjNum { get; set; }//当前数采(最新采集值)
|
[SugarColumn(IsIgnore = true)] public long? InitCjNum { get; set; }//初始采集数
|
[SugarColumn(IsIgnore = true)] public int TodayDowntimeCount { get; set; }//今日停机次数
|
}
|