using BizCom;
using SQLData;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace SiteCore.taoObj
{
    public class dataSendTradeCellBean
    {
        public dataSendTradeCellBean() { }
        public dataSendTradeCellBean(CeErpTradeCell ceErpTradeCell, CeErpTrade ceErpTrade)
        {
            tid = ceErpTradeCell.tid;
            ShortText1717720509648 = ceErpTradeCell.ctid;
            if (ceErpTrade.create_time != null)
            {
                Date1717720511828 = ceErpTrade.create_time?.ToString("yyyy-MM-dd HH:mm:ss");
            }
            shopId = ceErpTradeCell.ShopId.ToString();
            Number1717743147807 = ceErpTrade.payment.ToString();
            Number1717743147382 = ceErpTradeCell.payment.ToString();
            CeErpProduct product = CeErpProduct.GetById(ceErpTradeCell.ProductId);
            if (product != null)
            {
                ShortText1717743368707 = product.PType;
            }
            ShortText1717743440466 = ceErpTradeCell.ProductSize;
            ShortText1717743439861 = ceErpTradeCell.Material;
            ShortText1719471764829 = ceErpTradeCell.ProductCount;
            ShortText1717743477155 = ceErpTradeCell.SplitTag;
            ShortText1717743494688 = ceErpTrade.receiver_country + ceErpTrade.receiver_state + ceErpTrade.receiver_city + ceErpTrade.receiver_district + ceErpTrade.receiver_town;
            LongText1721719661176 = ceErpTradeCell.seller_memo;
            ShortText1717743869318 = ceErpTradeCell.OtherMemo;
            ShortText1717743882604 = ((OrderState)ceErpTradeCell.OrderState).ToString();
            ShortText1717743883175 = ceErpTrade.status;
            ShortText1717745597857 = ceErpTradeCell.IsSample == 1 ? "是" : "否";
            ShortText1717745609253 = ceErpTradeCell.IsSample == 2 ? "是" : "否";
            if (ceErpTradeCell.IsSample == 2)
            {
                Number1717745612480 = ceErpTradeCell.payment.ToString();
            }
            //客服数据
            if (ceErpTradeCell.CustomerUserId > 0)
            {
                string customer_sql = string.Format("SELECT *  FROM [dbo].[view_ErpUser] WHERE ID = {0}", ceErpTradeCell.CustomerUserId);

                DataTable customer_dt = DbHelper.DbConn.ExecuteDataset(customer_sql).Tables[0];

                if (customer_dt != null && customer_dt.Rows.Count > 0)
                {
                    ShortText1717743887285 = customer_dt.Rows[0]["Name"].ToString();
                    ShortText1717743885277 = customer_dt.Rows[0]["OrgName"].ToString();
                    if (!string.IsNullOrEmpty(customer_dt.Rows[0]["OrgID"].ToString()))
                    {
                        int orgId = Convert.ToInt32(customer_dt.Rows[0]["OrgID"]);
                        if (orgId > 0)
                        {
                            string mCustomer_sql = string.Format("SELECT Name  FROM [dbo].[view_ErpUser] WHERE OrgId={0} and PostCode in ('CustomerMr','Director','CustomerMaster')", customer_dt.Rows[0]["OrgID"]);
                            DataTable mCustomer_dt = DbHelper.DbConn.ExecuteDataset(mCustomer_sql).Tables[0];
                            if (mCustomer_dt != null && mCustomer_dt.Rows.Count > 0)
                            {
                                ShortText1717743888076 = mCustomer_dt.Rows[0]["Name"].ToString();
                            }
                        }
                    }

                }

            }
            //设计师数据
            if (ceErpTradeCell.DesignUserId > 0)
            {
                string design_sql = string.Format("SELECT *  FROM [dbo].[view_ErpUser] WHERE ID = {0}", ceErpTradeCell.DesignUserId);
                DataTable design_dt = DbHelper.DbConn.ExecuteDataset(design_sql).Tables[0];

                if (design_dt != null && design_dt.Rows.Count > 0)
                {
                    ShortText1717743889973 = design_dt.Rows[0]["Name"].ToString();
                    ShortText1717743889516 = design_dt.Rows[0]["OrgName"].ToString();
                    if (!string.IsNullOrEmpty(design_dt.Rows[0]["OrgID"].ToString()))
                    {
                        int orgId = Convert.ToInt32(design_dt.Rows[0]["OrgID"]);
                        if (orgId > 0)
                        {
                            string mDesign_sql = string.Format("SELECT Name  FROM [dbo].[view_ErpUser] WHERE OrgId={0} and PostCode in ('wxDesignerhd','wxDesignerMr','DesignerMr','Designerhd')", design_dt.Rows[0]["OrgID"]);
                            DataTable mDesign_dt = DbHelper.DbConn.ExecuteDataset(mDesign_sql).Tables[0];
                            if (mDesign_dt != null && mDesign_dt.Rows.Count > 0)
                            {
                                ShortText1717743890850 = mDesign_dt.Rows[0]["Name"].ToString();
                            }
                        }
                    }

                }

            }
            if (ceErpTradeCell.WaitDesignTime != null)
            {
                Date1717743893776 = ceErpTradeCell.WaitDesignTime?.ToString("yyyy-MM-dd HH:mm:ss");
            }
            if (ceErpTradeCell.FinishDesignTime != null)
            {
                Date1717743895362 = ceErpTradeCell.FinishDesignTime?.ToString("yyyy-MM-dd HH:mm:ss");
            }
            if (ceErpTradeCell.FinishPlaceTime != null)
            {
                Date1717744246168 = ceErpTradeCell.FinishPlaceTime?.ToString("yyyy-MM-dd HH:mm:ss");
            }

            CeErpTradeCellExtend ceErpTradeCellExtend = CeErpTradeCellExtend.getByTid(ceErpTradeCell.ctid);
            if (ceErpTradeCellExtend != null)
            {
                Number1718099884613 = ceErpTradeCellExtend.payment_cyt.ToString();
            }

            if (ceErpTradeCell.FinishDeliveryTime != null)
            {
                Date1717744254301 = ceErpTradeCell.FinishDeliveryTime?.ToString("yyyy-MM-dd HH:mm:ss");
                ShortText1717744255441 = ceErpTradeCell.OutSid;
            }
            if (ceErpTradeCell.ReturnTime != null)
            {
                Date1717745436357 = ceErpTradeCell.ReturnTime?.ToString("yyyy-MM-dd HH:mm:ss");
                ShortText1717745435559 = ceErpTradeCell.IsReturn.ToString();
                ShortText1717745481283 = ceErpTradeCell.ReturnReason;
            }
        }

        public static DateTime StampToDateTime(string timeStamp)
        {

            DateTime dateTimeStart = TimeZone.CurrentTimeZone.ToLocalTime(new DateTime(1970, 1, 1));
            long lTime = long.Parse(timeStamp + "0000");
            TimeSpan toNow = new TimeSpan(lTime);

            return dateTimeStart.Add(toNow);
        }
        public string shopId { get; set; }

        public string id { get; set; }

        public string tid { get; set; }
        /// <summary>
        /// 订单号
        /// </summary>
        public string ShortText1717720509648 { get; set; }

        /// <summary>
        /// 店铺
        /// </summary>
        public string RelevanceForm1717742363336 { get; set; }
        /// <summary>
        /// 下单时间
        /// </summary>
        public string Date1717720511828 { get; set; }
        /// <summary>
        /// 客户ID
        /// </summary>
        public string RelevanceForm1717743082402 { get; set; }
        /// <summary>
        /// 所属行业
        /// </summary>
        public string ShortText1717743122187 { get; set; }
        /// <summary>
        /// 总金额
        /// </summary>
        public string Number1717743147807 { get; set; }
        /// <summary>
        /// 付款金额
        /// </summary>
        public string Number1717743147382 { get; set; }
        /// <summary>
        /// 产品品类
        /// </summary>
        public string ShortText1717743368707 { get; set; }
        /// <summary>
        /// 二级类别
        /// </summary>
        public string ShortText1717743369717 { get; set; }
        /// <summary>
        /// 三级类别
        /// </summary>
        public string ShortText1717743370360 { get; set; }
        /// <summary>
        /// 尺寸
        /// </summary>
        public string ShortText1717743440466 { get; set; }
        /// <summary>
        /// 材质
        /// </summary>
        public string ShortText1717743439861 { get; set; }
        /// <summary>
        /// 数量
        /// </summary>
        public string Number1717743443204 { get; set; }
        /// <summary>
        /// 款数
        /// </summary>
        public string Number1717743445484 { get; set; }
        /// <summary>
        /// 数量款数
        /// </summary>
        public string ShortText1719471764829 { get; set; }
        /// <summary>
        /// 是否拆单
        /// </summary>
        public string ShortText1717743477155 { get; set; }
        /// <summary>
        /// 收件人
        /// </summary>
        public string ShortText1717743474684 { get; set; }
        /// <summary>
        /// 收件人手机
        /// </summary>
        public string ShortText1717743477592 { get; set; }
        /// <summary>
        /// 收件地址
        /// </summary>
        public string ShortText1717743494688 { get; set; }
        /// <summary>
        /// 备注
        /// </summary>
        public string LongText1721719661176 { get; set; }
        /// <summary>
        /// 额外备注
        /// </summary>
        public string ShortText1717743869318 { get; set; }
        /// <summary>
        /// 流程状态
        /// </summary>
        public string ShortText1717743882604 { get; set; }
        /// <summary>
        /// 淘宝状态
        /// </summary>
        public string ShortText1717743883175 { get; set; }
        /// <summary>
        /// 客服
        /// </summary>
        public string ShortText1717743887285 { get; set; }
        /// <summary>
        /// 客服部门
        /// </summary>
        public string ShortText1717743885277 { get; set; }
        /// <summary>
        /// 客服主管
        /// </summary>
        public string ShortText1717743888076 { get; set; }
        /// <summary>
        /// 设计师
        /// </summary>
        public string ShortText1717743889973 { get; set; }
        /// <summary>
        /// 设计部门
        /// </summary>
        public string ShortText1717743889516 { get; set; }
        /// <summary>
        /// 设计主管
        /// </summary>
        public string ShortText1717743890850 { get; set; }
        /// <summary>
        /// 设计模板ID
        /// </summary>
        public string ShortText1717743891704 { get; set; }
        /// <summary>
        /// 设计派单时间
        /// </summary>
        public string Date1717743893776 { get; set; }
        /// <summary>
        /// 设计完成时间
        /// </summary>
        public string Date1717743895362 { get; set; }
        /// <summary>
        /// 下单部下单时间
        /// </summary>
        public string Date1717744246168 { get; set; }
        /// <summary>
        /// 供应商
        /// </summary>
        public string RelevanceForm1718100412422 { get; set; }
        /// <summary>
        /// 成本金额
        /// </summary>
        public string Number1718099884613 { get; set; }
        /// <summary>
        /// 供应商售后扣款
        /// </summary>
        public string Number1718177781933 { get; set; }
        /// <summary>
        /// 发货时间
        /// </summary>
        public string Date1717744254301 { get; set; }
        /// <summary>
        /// 快递信息
        /// </summary>
        public string ShortText1717744255441 { get; set; }
        /// <summary>
        /// 是否打回
        /// </summary>
        public string ShortText1717745435559 { get; set; }
        /// <summary>
        /// 打回时间
        /// </summary>
        public string Date1717745436357 { get; set; }
        /// <summary>
        /// 打回原因
        /// </summary>
        public string ShortText1717745481283 { get; set; }
        /// <summary>
        /// 是否查货
        /// </summary>
        public string ShortText1717745492918 { get; set; }
        /// <summary>
        /// 查货时间
        /// </summary>
        public string Date1717745495718 { get; set; }
        /// <summary>
        /// 查货备注
        /// </summary>
        public string ShortText1717745497837 { get; set; }
        /// <summary>
        /// 查货解释
        /// </summary>
        public string ShortText1717745499141 { get; set; }
        /// <summary>
        /// 是否加急
        /// </summary>
        public string ShortText1717745533062 { get; set; }
        /// <summary>
        /// 加急出货时间
        /// </summary>
        public string Date1717745535736 { get; set; }
        /// <summary>
        /// 老客户状态
        /// </summary>
        public string ShortText1717745537842 { get; set; }
        /// <summary>
        /// 关联老客户订单（无）
        /// </summary>
        public string ShortText1717745539473 { get; set; }
        /// <summary>
        /// 是否售后
        /// </summary>
        public string ShortText1717745540758 { get; set; }
        /// <summary>
        /// 售后人员
        /// </summary>
        public string ShortText1717745541664 { get; set; }
        /// <summary>
        /// 售后标记时间
        /// </summary>
        public string Date1717745544245 { get; set; }
        /// <summary>
        /// 售后确认时间
        /// </summary>
        public string Date1717745545841 { get; set; }
        /// <summary>
        /// 售后责任方
        /// </summary>
        public string ShortText1717745548220 { get; set; }
        /// <summary>
        /// 二级原因
        /// </summary>
        public string ShortText1717745549835 { get; set; }
        /// <summary>
        /// 三级原因
        /// </summary>
        public string ShortText1717745550687 { get; set; }
        /// <summary>
        /// 售后责任人1
        /// </summary>
        public string ShortText1717745553842 { get; set; }
        /// <summary>
        /// 责任人1部门
        /// </summary>
        public string ShortText1717745554626 { get; set; }
        /// <summary>
        /// 售后责任人2
        /// </summary>
        public string ShortText1717811042513 { get; set; }
        /// <summary>
        /// 责任人2部门
        /// </summary>
        public string ShortText1717811049407 { get; set; }
        /// <summary>
        /// 责任扣款
        /// </summary>
        public string number1717745810151 { get; set; }
        /// <summary>
        /// 责任人1扣款
        /// </summary>
        public string Number1717745564936 { get; set; }
        /// <summary>
        /// 责任人2扣款
        /// </summary>
        public string Number1717745565580 { get; set; }
        /// <summary>
        /// 供应商认可状态
        /// </summary>
        public string ShortText1717745580986 { get; set; }
        /// <summary>
        /// 不认可原因
        /// </summary>
        public string ShortText1717745582613 { get; set; }
        /// <summary>
        /// 售后方案
        /// </summary>
        public string ShortText1717745583256 { get; set; }
        /// <summary>
        /// 售后备注
        /// </summary>
        public string ShortText1717745583810 { get; set; }
        /// <summary>
        /// 是否退款
        /// </summary>
        public string ShortText1717745585444 { get; set; }
        /// <summary>
        /// 退款类型（无）
        /// </summary>
        public string ShortText1717745586086 { get; set; }
        /// <summary>
        /// 退款时间
        /// </summary>
        public string Date1717745588048 { get; set; }
        /// <summary>
        /// 退款金额
        /// </summary>
        public string Number1717743148189 { get; set; }
        /// <summary>
        /// 退款原因
        /// </summary>
        public string ShortText1717745591810 { get; set; }
        /// <summary>
        /// 客户说明
        /// </summary>
        public string ShortText1717745592639 { get; set; }
        /// <summary>
        /// 退款备注
        /// </summary>
        public string ShortText1717745596652 { get; set; }
        /// <summary>
        /// 是否拿样
        /// </summary>
        public string ShortText1717745597857 { get; set; }
        /// <summary>
        /// 拿样标记时间（无）
        /// </summary>
        public string Date1717745599018 { get; set; }
        /// <summary>
        /// 是否返现
        /// </summary>
        public string ShortText1717745601056 { get; set; }
        /// <summary>
        /// 返现类型
        /// </summary>
        public string ShortText1717745602313 { get; set; }
        /// <summary>
        /// 返现金额
        /// </summary>
        public string Number1717745604245 { get; set; }
        /// <summary>
        /// 返现原因
        /// </summary>
        public string ShortText1717745607208 { get; set; }
        /// <summary>
        /// 是否推购
        /// </summary>
        public string ShortText1717745608381 { get; set; }
        /// <summary>
        /// 是否补差
        /// </summary>
        public string ShortText1717745609253 { get; set; }
        /// <summary>
        /// 补差时间（无）
        /// </summary>
        public string Date1717745610736 { get; set; }
        /// <summary>
        /// 补差金额
        /// </summary>
        public string Number1717745612480 { get; set; }
        /// <summary>
        /// 关联主订单
        /// </summary>
        public string RelevanceForm1724834153527 { get; set; }



    }
}