public static Oelineassembly BuildOelineassemblyFromRow(DataRow row)
{
Oelineassembly entity = new Oelineassembly();
entity.shipprod = row.IsNull("shipprod") ? string.Empty : row.Field <string>("shipprod");
entity.compprod = row.IsNull("compprod") ? string.Empty : row.Field <string>("compprod");
entity.whse = row.IsNull("whse") ? string.Empty : row.Field <string>("whse");
entity.seqno = row.IsNull("seqno") ? 0 : row.Field <int>("seqno");
entity.lineno = row.IsNull("lineno") ? 0 : row.Field <int>("lineno");
entity.nonstockty = row.IsNull("nonstockty") ? string.Empty : row.Field <string>("nonstockty");
entity.proddesc = row.IsNull("proddesc") ? string.Empty : row.Field <string>("proddesc");
entity.proddesc2 = row.IsNull("proddesc2") ? string.Empty : row.Field <string>("proddesc2");
entity.unit = row.IsNull("unit") ? string.Empty : row.Field <string>("unit");
entity.prodcat = row.IsNull("prodcat") ? string.Empty : row.Field <string>("prodcat");
entity.cubes = row.IsNull("cubes") ? decimal.Zero : row.Field <decimal>("cubes");
entity.weight = row.IsNull("weight") ? decimal.Zero : row.Field <decimal>("weight");
entity.assemblyty = row.IsNull("assemblyty") ? string.Empty : row.Field <string>("assemblyty");
entity.qtytobuild = row.IsNull("qtytobuild") ? decimal.Zero : row.Field <decimal>("qtytobuild");
entity.arpprodline = row.IsNull("arpprodline") ? string.Empty : row.Field <string>("arpprodline");
entity.arpvendno = row.IsNull("arpvendno") ? decimal.Zero : row.Field <decimal>("arpvendno");
entity.arpwhse = row.IsNull("arpwhse") ? string.Empty : row.Field <string>("arpwhse");
entity.prodcost = row.IsNull("prodcost") ? decimal.Zero : row.Field <decimal>("prodcost");
entity.rushfl = row.Field <bool>("rushfl");
entity.lgthcompfl = row.Field <bool>("lgthcompfl");
entity.segmentsfromconfig1 = row.IsNull("segmentsfromconfig1") ? string.Empty : row.Field <string>("segmentsfromconfig1");
entity.segmentsfromconfig2 = row.IsNull("segmentsfromconfig2") ? string.Empty : row.Field <string>("segmentsfromconfig2");
entity.segmentsfromconfig3 = row.IsNull("segmentsfromconfig3") ? string.Empty : row.Field <string>("segmentsfromconfig3");
entity.segmentsfromconfig4 = row.IsNull("segmentsfromconfig4") ? string.Empty : row.Field <string>("segmentsfromconfig4");
entity.segmentsfromconfig5 = row.IsNull("segmentsfromconfig5") ? string.Empty : row.Field <string>("segmentsfromconfig5");
entity.segmentsfromconfig6 = row.IsNull("segmentsfromconfig6") ? string.Empty : row.Field <string>("segmentsfromconfig6");
entity.segmentsfromconfig7 = row.IsNull("segmentsfromconfig7") ? string.Empty : row.Field <string>("segmentsfromconfig7");
entity.segmentsfromconfig8 = row.IsNull("segmentsfromconfig8") ? string.Empty : row.Field <string>("segmentsfromconfig8");
entity.segmentsfromconfig9 = row.IsNull("segmentsfromconfig9") ? string.Empty : row.Field <string>("segmentsfromconfig9");
entity.segmentsfromconfig10 = row.IsNull("segmentsfromconfig10") ? string.Empty : row.Field <string>("segmentsfromconfig10");
entity.segmentsfromconfig11 = row.IsNull("segmentsfromconfig11") ? string.Empty : row.Field <string>("segmentsfromconfig11");
entity.segmentsfromconfig12 = row.IsNull("segmentsfromconfig12") ? string.Empty : row.Field <string>("segmentsfromconfig12");
entity.segmentsfromconfig13 = row.IsNull("segmentsfromconfig13") ? string.Empty : row.Field <string>("segmentsfromconfig13");
entity.segmentsfromconfig14 = row.IsNull("segmentsfromconfig14") ? string.Empty : row.Field <string>("segmentsfromconfig14");
entity.segmentsfromconfig15 = row.IsNull("segmentsfromconfig15") ? string.Empty : row.Field <string>("segmentsfromconfig15");
entity.segmentsfromconfig16 = row.IsNull("segmentsfromconfig16") ? string.Empty : row.Field <string>("segmentsfromconfig16");
entity.segmentsfromconfig17 = row.IsNull("segmentsfromconfig17") ? string.Empty : row.Field <string>("segmentsfromconfig17");
entity.segmentsfromconfig18 = row.IsNull("segmentsfromconfig18") ? string.Empty : row.Field <string>("segmentsfromconfig18");
entity.segmentsfromconfig19 = row.IsNull("segmentsfromconfig19") ? string.Empty : row.Field <string>("segmentsfromconfig19");
entity.segmentsfromconfig20 = row.IsNull("segmentsfromconfig20") ? string.Empty : row.Field <string>("segmentsfromconfig20");
entity.segmentsfromconfig21 = row.IsNull("segmentsfromconfig21") ? string.Empty : row.Field <string>("segmentsfromconfig21");
entity.segmentsfromconfig22 = row.IsNull("segmentsfromconfig22") ? string.Empty : row.Field <string>("segmentsfromconfig22");
entity.segmentsfromconfig23 = row.IsNull("segmentsfromconfig23") ? string.Empty : row.Field <string>("segmentsfromconfig23");
entity.segmentsfromconfig24 = row.IsNull("segmentsfromconfig24") ? string.Empty : row.Field <string>("segmentsfromconfig24");
entity.userfield = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield");
return(entity);
}
/// <summary>
/// Update a database row from a class
/// </summary>
public static void UpdateRowFromOelineassembly(ref DataRow row, Oelineassembly entity)
{
row.SetField("shipprod", entity.shipprod);
row.SetField("compprod", entity.compprod);
row.SetField("whse", entity.whse);
row.SetField("seqno", entity.seqno);
row.SetField("lineno", entity.lineno);
row.SetField("nonstockty", entity.nonstockty);
row.SetField("proddesc", entity.proddesc);
row.SetField("proddesc2", entity.proddesc2);
row.SetField("unit", entity.unit);
row.SetField("prodcat", entity.prodcat);
row.SetField("cubes", entity.cubes);
row.SetField("weight", entity.weight);
row.SetField("assemblyty", entity.assemblyty);
row.SetField("qtytobuild", entity.qtytobuild);
row.SetField("arpprodline", entity.arpprodline);
row.SetField("arpvendno", entity.arpvendno);
row.SetField("arpwhse", entity.arpwhse);
row.SetField("prodcost", entity.prodcost);
row.SetField("rushfl", entity.rushfl);
row.SetField("lgthcompfl", entity.lgthcompfl);
row.SetField("segmentsfromconfig1", entity.segmentsfromconfig1);
row.SetField("segmentsfromconfig2", entity.segmentsfromconfig2);
row.SetField("segmentsfromconfig3", entity.segmentsfromconfig3);
row.SetField("segmentsfromconfig4", entity.segmentsfromconfig4);
row.SetField("segmentsfromconfig5", entity.segmentsfromconfig5);
row.SetField("segmentsfromconfig6", entity.segmentsfromconfig6);
row.SetField("segmentsfromconfig7", entity.segmentsfromconfig7);
row.SetField("segmentsfromconfig8", entity.segmentsfromconfig8);
row.SetField("segmentsfromconfig9", entity.segmentsfromconfig9);
row.SetField("segmentsfromconfig10", entity.segmentsfromconfig10);
row.SetField("segmentsfromconfig11", entity.segmentsfromconfig11);
row.SetField("segmentsfromconfig12", entity.segmentsfromconfig12);
row.SetField("segmentsfromconfig13", entity.segmentsfromconfig13);
row.SetField("segmentsfromconfig14", entity.segmentsfromconfig14);
row.SetField("segmentsfromconfig15", entity.segmentsfromconfig15);
row.SetField("segmentsfromconfig16", entity.segmentsfromconfig16);
row.SetField("segmentsfromconfig17", entity.segmentsfromconfig17);
row.SetField("segmentsfromconfig18", entity.segmentsfromconfig18);
row.SetField("segmentsfromconfig19", entity.segmentsfromconfig19);
row.SetField("segmentsfromconfig20", entity.segmentsfromconfig20);
row.SetField("segmentsfromconfig21", entity.segmentsfromconfig21);
row.SetField("segmentsfromconfig22", entity.segmentsfromconfig22);
row.SetField("segmentsfromconfig23", entity.segmentsfromconfig23);
row.SetField("segmentsfromconfig24", entity.segmentsfromconfig24);
row.SetField("userfield", entity.userfield);
}
