Example #1
0
 public PreOrderDetail(PreOrderDetail pod)
 {
     this.ID                = pod.ID = pod.ID;
     this.POID              = pod.POID;
     this.PreOrderNumber    = pod.PreOrderNumber;
     this.ExternOrderNumber = pod.ExternOrderNumber;
     this.CustomerID        = pod.CustomerID;
     this.CustomerName      = pod.CustomerName;
     this.LineNumber        = pod.LineNumber;
     this.WarehouseId       = pod.WarehouseId;
     this.Warehouse         = pod.Warehouse;
     this.Area              = pod.Area;
     this.Location          = pod.Location;
     this.SKU               = pod.SKU;
     this.UPC               = pod.UPC;
     this.BoxNumber         = pod.BoxNumber;
     this.GoodsName         = pod.GoodsName;
     this.GoodsType         = pod.GoodsType;
     this.InventoryQty      = pod.InventoryQty;
     this.OriginalQty       = pod.OriginalQty;
     this.AllocatedQty      = pod.AllocatedQty;
     this.BatchNumber       = pod.BatchNumber;
     this.Creator           = pod.Creator;
     this.CreateTime        = pod.CreateTime;
     this.Updator           = pod.Updator;
     this.UpdateTime        = pod.UpdateTime;
     this.Remark            = pod.Remark;
     this.str1              = pod.str1;
     this.str2              = pod.str2;
     this.str3              = pod.str3;
     this.str4              = pod.str4;
     this.str5              = pod.str5;
     this.str6              = pod.str6;
     this.str7              = pod.str7;
     this.str8              = pod.str8;
     this.str9              = pod.str9;
     this.str10             = pod.str10;
     this.str11             = pod.str11;
     this.str12             = pod.str12;
     this.str13             = pod.str13;
     this.str14             = pod.str14;
     this.str15             = pod.str15;
     this.str16             = pod.str16;
     this.str17             = pod.str17;
     this.str18             = pod.str18;
     this.str19             = pod.str19;
     this.str20             = pod.str20;
     this.DateTime1         = pod.DateTime1;
     this.DateTime2         = pod.DateTime2;
     this.DateTime3         = pod.DateTime3;
     this.DateTime4         = pod.DateTime4;
     this.DateTime5         = pod.DateTime5;
     this.Int1              = pod.Int1;
     this.Int2              = pod.Int2;
     this.Int3              = pod.Int3;
     this.Int4              = pod.Int4;
     this.Int5              = pod.Int5;
     this.IID               = pod.IID;
     this.Unit              = pod.Unit;
     this.Specifications    = pod.Specifications;
     this.ID2               = pod.ID2;
     this.IID2              = pod.IID2;
 }
        public WMSPreOrderDetailInfoToDb(PreOrderDetail preInfo)
            : base(s_metadata)
        {
            SetSqlInt64(0, preInfo.ID);
            SetSqlInt64(1, preInfo.POID);
            SetSqlString(2, preInfo.PreOrderNumber);
            SetSqlString(3, preInfo.ExternOrderNumber);
            SetSqlInt64(4, preInfo.CustomerID);
            SetSqlString(5, preInfo.CustomerName);
            SetSqlString(6, preInfo.LineNumber);
            SetSqlInt64(7, preInfo.WarehouseId);
            SetSqlString(8, preInfo.Warehouse);

            SetSqlString(9, preInfo.Area);
            SetSqlString(10, preInfo.Location);

            SetSqlString(11, preInfo.SKU);
            SetSqlString(12, preInfo.UPC);
            SetSqlString(13, preInfo.GoodsName);
            SetSqlString(14, preInfo.GoodsType);
            SetSqlDouble(15, preInfo.OriginalQty);
            SetSqlDouble(16, preInfo.AllocatedQty);
            SetSqlString(17, preInfo.BatchNumber == "" ? null : preInfo.BatchNumber);
            SetSqlString(18, preInfo.Creator);
            SetSqlDateTime(19, preInfo.CreateTime ?? SqlTypes.SqlDateTime.Null);
            SetSqlString(20, preInfo.Updator);
            SetSqlDateTime(21, preInfo.UpdateTime ?? SqlTypes.SqlDateTime.Null);
            SetSqlString(22, preInfo.Remark);
            #region 备用字段
            SetSqlString(23, preInfo.str1);
            SetSqlString(24, preInfo.str2);
            SetSqlString(25, preInfo.str3);
            SetSqlString(26, preInfo.str4);
            SetSqlString(27, preInfo.str5);
            SetSqlString(28, preInfo.str6);
            SetSqlString(29, preInfo.str7);
            SetSqlString(30, preInfo.str8);
            SetSqlString(31, preInfo.str9);
            SetSqlString(32, preInfo.str10);
            SetSqlString(33, preInfo.str11);
            SetSqlString(34, preInfo.str12);
            SetSqlString(35, preInfo.str13);
            SetSqlString(36, preInfo.str14);
            SetSqlString(37, preInfo.str15);
            SetSqlString(38, preInfo.str16);
            SetSqlString(39, preInfo.str17);
            SetSqlString(40, preInfo.str18);
            SetSqlString(41, preInfo.str19);
            SetSqlString(42, preInfo.str20);
            SetSqlDateTime(43, preInfo.DateTime1 ?? SqlTypes.SqlDateTime.Null);
            SetSqlDateTime(44, preInfo.DateTime2 ?? SqlTypes.SqlDateTime.Null);
            SetSqlDateTime(45, preInfo.DateTime3 ?? SqlTypes.SqlDateTime.Null);
            SetSqlDateTime(46, preInfo.DateTime4 ?? SqlTypes.SqlDateTime.Null);
            SetSqlDateTime(47, preInfo.DateTime5 ?? SqlTypes.SqlDateTime.Null);
            SetSqlInt32(48, preInfo.Int1 ?? SqlTypes.SqlInt32.Null);
            SetSqlInt32(49, preInfo.Int2 ?? SqlTypes.SqlInt32.Null);
            SetSqlInt32(50, preInfo.Int3 ?? SqlTypes.SqlInt32.Null);
            SetSqlInt32(51, preInfo.Int4 ?? SqlTypes.SqlInt32.Null);
            SetSqlInt32(52, preInfo.Int5 ?? SqlTypes.SqlInt32.Null);
            SetSqlString(53, preInfo.BoxNumber == "" ? null : preInfo.BoxNumber);
            SetSqlInt64(54, preInfo.IID);
            SetSqlString(55, preInfo.Unit == "" ? null : preInfo.Unit);
            SetSqlString(56, preInfo.Specifications == "" ? null : preInfo.Specifications);
            #endregion
        }