public PodWithAttachment(Pod pod)
{
this.ID = pod.ID;
this.ProjectID = pod.ProjectID;
this.SystemNumber = pod.SystemNumber;
this.CustomerOrderNumber = pod.CustomerOrderNumber;
this.CustomerID = pod.CustomerID;
this.CustomerName = pod.CustomerName;
this.ShipperID = pod.ShipperID;
this.ShipperName = pod.ShipperName;
this.ActualDeliveryDate = pod.ActualDeliveryDate;
this.StartCityID = pod.StartCityID;
this.StartCityName = pod.StartCityName;
this.EndCityID = pod.EndCityID;
this.PODTypeID = pod.PODTypeID;
this.PODTypeName = pod.PODTypeName;
this.EndCityName = pod.EndCityName;
this.PODStateID = pod.PODStateID;
this.PODStateName = pod.PODStateName;
this.ShipperTypeID = pod.ShipperTypeID;
this.ShipperTypeName = pod.ShipperTypeName;
this.TtlOrTplID = pod.TtlOrTplID;
this.TtlOrTplName = pod.TtlOrTplName;
this.BoxNumber = pod.BoxNumber;
this.Weight = pod.Weight;
this.GoodsNumber = pod.GoodsNumber;
this.Volume = pod.Volume;
this.Creator = pod.Creator;
this.CreateTime = pod.CreateTime;
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.Str21 = pod.Str21;
this.Str22 = pod.Str22;
this.Str23 = pod.Str23;
this.Str24 = pod.Str24;
this.Str25 = pod.Str25;
this.Str26 = pod.Str26;
this.Str27 = pod.Str27;
this.Str28 = pod.Str28;
this.Str29 = pod.Str29;
this.Str30 = pod.Str30;
this.Str31 = pod.Str31;
this.Str32 = pod.Str32;
this.Str33 = pod.Str33;
this.Str34 = pod.Str34;
this.Str35 = pod.Str35;
this.Str36 = pod.Str36;
this.Str37 = pod.Str37;
this.Str38 = pod.Str38;
this.Str39 = pod.Str39;
this.Str40 = pod.Str40;
this.Str41 = pod.Str41;
this.Str42 = pod.Str42;
this.Str43 = pod.Str43;
this.Str44 = pod.Str44;
this.Str45 = pod.Str45;
this.Str46 = pod.Str46;
this.Str47 = pod.Str47;
this.Str48 = pod.Str48;
this.Str49 = pod.Str49;
this.Str50 = pod.Str50;
this.DateTime1 = pod.DateTime1;
this.DateTime2 = pod.DateTime2;
this.DateTime3 = pod.DateTime3;
this.DateTime4 = pod.DateTime4;
this.DateTime5 = pod.DateTime5;
this.DateTime6 = pod.DateTime6;
this.DateTime7 = pod.DateTime7;
this.DateTime8 = pod.DateTime8;
this.DateTime9 = pod.DateTime9;
this.DateTime10 = pod.DateTime10;
this.DateTime11 = pod.DateTime11;
this.DateTime12 = pod.DateTime12;
this.DateTime13 = pod.DateTime13;
this.DateTime14 = pod.DateTime14;
this.DateTime15 = pod.DateTime15;
this.IsSettledForCustomer = pod.IsSettledForCustomer;
this.IsSettledForShipper = pod.IsSettledForShipper;
this.Type = pod.Type;
this.HasShortDial = pod.HasShortDial;
this.HasDistribution = pod.HasDistribution;
this.HasExpress = pod.HasExpress;
this.AttachmentGroupID = string.Empty;
this.IsUploadPod = 0;
this.wxStatus = pod.wxStatus;
}
public PodToDb(Pod pod)
: base(s_metadata)
{
SetSqlInt64(0, pod.ID);
SetSqlInt64(1, pod.ProjectID);
SetSqlString(2, pod.SystemNumber);
SetSqlString(3, pod.CustomerOrderNumber);
SetSqlInt64(4, pod.CustomerID ?? SqlTypes.SqlInt64.Null);
SetSqlString(5, pod.CustomerName);
SetSqlInt64(6, pod.ShipperID ?? SqlTypes.SqlInt64.Null);
SetSqlString(7, pod.ShipperName);
SetSqlDateTime(8, pod.ActualDeliveryDate ?? SqlTypes.SqlDateTime.Null);
SetSqlInt64(9, pod.StartCityID ?? SqlTypes.SqlInt64.Null);
SetSqlString(10, pod.StartCityName);
SetSqlInt64(11, pod.EndCityID ?? SqlTypes.SqlInt64.Null);
SetSqlString(12, pod.EndCityName);
SetSqlInt64(13, pod.PODStateID ?? SqlTypes.SqlInt64.Null);
SetSqlString(14, pod.PODStateName);
SetSqlInt64(15, pod.ShipperTypeID ?? SqlTypes.SqlInt64.Null);
SetSqlString(16, pod.ShipperTypeName);
SetSqlDouble(17, pod.BoxNumber ?? SqlTypes.SqlDouble.Null);
SetSqlDouble(18, pod.Weight ?? SqlTypes.SqlDouble.Null);
SetSqlDouble(19, pod.GoodsNumber ?? SqlTypes.SqlDouble.Null);
SetSqlDouble(20, pod.Volume ?? SqlTypes.SqlDouble.Null);
SetSqlString(21, pod.Creator);
SetSqlDateTime(22, pod.CreateTime ?? SqlTypes.SqlDateTime.Null);
SetSqlString(23, pod.Str1);
SetSqlString(24, pod.Str2);
SetSqlString(25, pod.Str3);
SetSqlString(26, pod.Str4);
SetSqlString(27, pod.Str5);
SetSqlString(28, pod.Str6);
SetSqlString(29, pod.Str7);
SetSqlString(30, pod.Str8);
SetSqlString(31, pod.Str9);
SetSqlString(32, pod.Str10);
SetSqlString(33, pod.Str11);
SetSqlString(34, pod.Str12);
SetSqlString(35, pod.Str13);
SetSqlString(36, pod.Str14);
SetSqlString(37, pod.Str15);
SetSqlString(38, pod.Str16);
SetSqlString(39, pod.Str17);
SetSqlString(40, pod.Str18);
SetSqlString(41, pod.Str19);
SetSqlString(42, pod.Str20);
SetSqlString(43, pod.Str21);
SetSqlString(44, pod.Str22);
SetSqlString(45, pod.Str23);
SetSqlString(46, pod.Str24);
SetSqlString(47, pod.Str25);
SetSqlString(48, pod.Str26);
SetSqlString(49, pod.Str27);
SetSqlString(50, pod.Str28);
SetSqlString(51, pod.Str29);
SetSqlString(52, pod.Str30);
SetSqlString(53, pod.Str31);
SetSqlString(54, pod.Str32);
SetSqlString(55, pod.Str33);
SetSqlString(56, pod.Str34);
SetSqlString(57, pod.Str35);
SetSqlString(58, pod.Str36);
SetSqlString(59, pod.Str37);
SetSqlString(60, pod.Str38);
SetSqlString(61, pod.Str39);
SetSqlString(62, pod.Str40);
SetSqlString(63, pod.Str41);
SetSqlString(64, pod.Str42);
SetSqlString(65, pod.Str43);
SetSqlString(66, pod.Str44);
SetSqlString(67, pod.Str45);
SetSqlString(68, pod.Str46);
SetSqlString(69, pod.Str47);
SetSqlString(70, pod.Str48);
SetSqlString(71, pod.Str49);
SetSqlString(72, pod.Str50);
SetSqlDateTime(73, pod.DateTime1 ?? SqlTypes.SqlDateTime.Null);
SetSqlDateTime(74, pod.DateTime2 ?? SqlTypes.SqlDateTime.Null);
SetSqlDateTime(75, pod.DateTime3 ?? SqlTypes.SqlDateTime.Null);
SetSqlDateTime(76, pod.DateTime4 ?? SqlTypes.SqlDateTime.Null);
SetSqlDateTime(77, pod.DateTime5 ?? SqlTypes.SqlDateTime.Null);
SetSqlDateTime(78, pod.DateTime6 ?? SqlTypes.SqlDateTime.Null);
SetSqlDateTime(79, pod.DateTime7 ?? SqlTypes.SqlDateTime.Null);
SetSqlDateTime(80, pod.DateTime8 ?? SqlTypes.SqlDateTime.Null);
SetSqlDateTime(81, pod.DateTime9 ?? SqlTypes.SqlDateTime.Null);
SetSqlDateTime(82, pod.DateTime10 ?? SqlTypes.SqlDateTime.Null);
SetSqlDateTime(83, pod.DateTime11 ?? SqlTypes.SqlDateTime.Null);
SetSqlDateTime(84, pod.DateTime12 ?? SqlTypes.SqlDateTime.Null);
SetSqlDateTime(85, pod.DateTime13 ?? SqlTypes.SqlDateTime.Null);
SetSqlDateTime(86, pod.DateTime14 ?? SqlTypes.SqlDateTime.Null);
SetSqlDateTime(87, pod.DateTime15 ?? SqlTypes.SqlDateTime.Null);
SetSqlInt64(88, pod.PODTypeID ?? SqlTypes.SqlInt64.Null);
SetSqlString(89, pod.PODTypeName);
SetSqlInt64(90, pod.TtlOrTplID ?? SqlTypes.SqlInt64.Null);
SetSqlString(91, pod.TtlOrTplName);
SetSqlBoolean(92, pod.IsSettledForCustomer ?? false);
SetSqlBoolean(93, pod.IsSettledForShipper ?? false);
SetSqlInt32(94, pod.Type ?? 2);
SetSqlBoolean(95, pod.HasShortDial ?? false);
SetSqlBoolean(96, pod.HasDistribution ?? false);
SetSqlBoolean(97, pod.HasExpress ?? false);
}
