using System;
using System.Collections.Generic;
using System.Text;
using Dapper;


namespace Bailun.DC.Models
{
    /// <summary>
    /// 数据仓
    /// </summary>
    public class dc_sku_monitor
    {
        /// <summary>
        /// 
        /// </summary>
        public int id { get; set; }

        /// <summary>
        /// 
        /// </summary>
        public string sku { get; set; }

        /// <summary>
        /// 仓库编码
        /// </summary>
        public string warehouse_code { get; set; }

        /// <summary>
        /// 仓库名称
        /// </summary>
        public string warehousename { get; set; }

        /// <summary>
        /// 监控状态
        /// </summary>
        public int? status { get; set; }

        /// <summary>
        /// 清货状态
        /// </summary>
        public int? clearancestatus { get; set; }

        /// <summary>
        /// 侵权状态
        /// </summary>
        public int? tortstatus { get; set; }

        /// <summary>
        /// sku标签
        /// </summary>
        public string str_skutag { get; set; }

        /// <summary>
        /// 创建时间
        /// </summary>
        public DateTime createtime { get; set; }

        /// <summary>
        /// 开发时间
        /// </summary>
        public DateTime developmenttime { get; set; }

        /// <summary>
        /// 清货库存数量
        /// </summary>
        public int stockcount { get; set; }

        /// <summary>
        /// 仓库类型
        /// </summary>
        public string warehousetype { get; set; }

        /// <summary>
        /// 分类名称
        /// </summary>
        public string category_name { get; set; }

        /// <summary>
        /// sku中文名称
        /// </summary>
        public string skuname { get; set; }

        /// <summary>
        /// 采购价格
        /// </summary>
        public decimal? buyprice { get; set; }

        /// <summary>
        /// 库存数
        /// </summary>
        public int? usable_stock { get; set; }

        /// <summary>
        /// 库存金额
        /// </summary>
        public decimal? amount_stock { get; set; }

        /// <summary>
        /// 采购在途数量
        /// </summary>
        public int? quantity_purchase { get; set; }

        /// <summary>
        /// 采购在途金额
        /// </summary>
        public decimal? purchase_amount { get; set; }

        /// <summary>
        /// 调拨在途数量
        /// </summary>
        public int? quantity_transfer { get; set; }

        /// <summary>
        /// 调拨在途金额
        /// </summary>
        public decimal? amount_transit { get; set; }

        /// <summary>
        /// 缺货数
        /// </summary>
        public int? quantity_out_stock { get; set; }

        /// <summary>
        /// 昨日总量
        /// </summary>
        public int? oneday_total_sales { get; set; }

        /// <summary>
        /// 昨日总销售额
        /// </summary>
        public decimal? amount_onedaysale { get; set; }

        /// <summary>
        /// 7日总销量
        /// </summary>
        public int? sevenday_total_sales { get; set; }

        /// <summary>
        /// 7日总销售额
        /// </summary>
        public decimal? amount_sevendaysale { get; set; }

        /// <summary>
        /// 14日总销量
        /// </summary>
        public int? fourteenday_total_sales { get; set; }

        /// <summary>
        /// 30日总销量
        /// </summary>
        public int? thirtyday_total_sales { get; set; }

        /// <summary>
        /// 7日日均销量
        /// </summary>
        public decimal? sevenday_average_sales { get; set; }

        /// <summary>
        /// 14日日均销量
        /// </summary>
        public decimal? fourteenday_average_sales { get; set; }

        /// <summary>
        /// 30日日均销量
        /// </summary>
        public decimal? thirtyday_average_sales { get; set; }

        /// <summary>
        /// sku开发时间
        /// </summary>
        public DateTime? skucreatetime { get; set; }

        /// <summary>
        /// 分组名称
        /// </summary>
        public string groupname { get; set; }

        /// <summary>
        /// 分组更新时间
        /// </summary>
        public DateTime? groupupdatetime { get; set; }

        /// <summary>
        /// 最后更新人
        /// </summary>
        public string groupupdateuser { get; set; }
        
        /// <summary>
        /// 未发货数
        /// </summary>
        public decimal? quantity_unshipped { get; set; }
    }
}
