/// <summary>
/// Update a database row from a class
/// </summary>
public static void UpdateRowFromOtettrackdetail(ref DataRow row, Otettrackdetail entity)
{
row.SetField("trackno", entity.trackno);
row.SetField("vendno", entity.vendno);
row.SetField("shipfmno", entity.shipfmno);
row.SetField("whse", entity.whse);
row.SetField("stagecd", entity.stagecd);
row.SetField("vendname", entity.vendname);
row.SetField("shipfm", entity.shipfm);
row.SetField("vendoraddr1", entity.vendoraddr1);
row.SetField("fromaddr1", entity.fromaddr1);
row.SetField("vendoraddr2", entity.vendoraddr2);
row.SetField("fromaddr2", entity.fromaddr2);
row.SetField("vendoraddr3", entity.vendoraddr3);
row.SetField("fromaddr3", entity.fromaddr3);
row.SetField("fromcity", entity.fromcity);
row.SetField("fromst", entity.fromst);
row.SetField("fromzip", entity.fromzip);
row.SetField("vendorcity", entity.vendorcity);
row.SetField("vendorst", entity.vendorst);
row.SetField("vendorzip", entity.vendorzip);
row.SetField("fromphone", entity.fromphone);
row.SetField("fromcountry", entity.fromcountry);
row.SetField("vendphone", entity.vendphone);
row.SetField("vendcountry", entity.vendcountry);
row.SetField("contact", entity.contact);
row.SetField("countryorg", entity.countryorg);
row.SetField("countrydest", entity.countrydest);
row.SetField("vessnm", entity.vessnm);
row.SetField("portno", entity.portno);
row.SetField("voyno", entity.voyno);
row.SetField("portnm", entity.portnm);
row.SetField("shipco", entity.shipco);
row.SetField("shipid", entity.shipid);
row.SetField("contno", entity.contno);
row.SetField("contsize", entity.contsize);
row.SetField("bofl", entity.bofl);
row.SetField("lettofcr", entity.lettofcr);
row.SetField("freeformaddrfl", entity.freeformaddrfl);
row.SetField("currsymbol", entity.currsymbol);
row.SetField("estprodstdt", entity.estprodstdt);
row.SetField("revprodstdt", entity.revprodstdt);
row.SetField("actprodstdt", entity.actprodstdt);
row.SetField("prodstdtenabled", entity.prodstdtenabled);
row.SetField("estcompdt", entity.estcompdt);
row.SetField("revcompdt", entity.revcompdt);
row.SetField("actcompdt", entity.actcompdt);
row.SetField("compdtenabled", entity.compdtenabled);
row.SetField("estdeptdt", entity.estdeptdt);
row.SetField("revdeptdt", entity.revdeptdt);
row.SetField("actdeptdt", entity.actdeptdt);
row.SetField("deptdtenabled", entity.deptdtenabled);
row.SetField("estdockarrdt", entity.estdockarrdt);
row.SetField("revdockarrdt", entity.revdockarrdt);
row.SetField("actdockarrdt", entity.actdockarrdt);
row.SetField("dockarrdtenabled", entity.dockarrdtenabled);
row.SetField("estdockreddt", entity.estdockreddt);
row.SetField("revdockreddt", entity.revdockreddt);
row.SetField("actdockreddt", entity.actdockreddt);
row.SetField("dockreddtenabled", entity.dockreddtenabled);
row.SetField("estdockdemudt", entity.estdockdemudt);
row.SetField("revdemudt", entity.revdemudt);
row.SetField("actdockdemudt", entity.actdockdemudt);
row.SetField("dockdemudtenabled", entity.dockdemudtenabled);
row.SetField("estatwhsedt", entity.estatwhsedt);
row.SetField("revatwhsedt", entity.revatwhsedt);
row.SetField("actatwhsedt", entity.actatwhsedt);
row.SetField("atwhsedtenabled", entity.atwhsedtenabled);
row.SetField("estlastfreedt", entity.estlastfreedt);
row.SetField("revlastfreedt", entity.revlastfreedt);
row.SetField("actlastfreedt", entity.actlastfreedt);
row.SetField("lastfreedtenabled", entity.lastfreedtenabled);
row.SetField("estwhseunldt", entity.estwhseunldt);
row.SetField("revwhseunldt", entity.revwhseunldt);
row.SetField("actwhseunldt", entity.actwhseunldt);
row.SetField("whseunldtenabled", entity.whseunldtenabled);
row.SetField("estemptydt", entity.estemptydt);
row.SetField("revemptydt", entity.revemptydt);
row.SetField("actemptydt", entity.actemptydt);
row.SetField("emptydtenabled", entity.emptydtenabled);
row.SetField("estretdt", entity.estretdt);
row.SetField("revretdt", entity.revretdt);
row.SetField("actretdt", entity.actretdt);
row.SetField("retdtenabled", entity.retdtenabled);
row.SetField("afterrcvstg", entity.afterrcvstg);
row.SetField("totlineamt", entity.totlineamt);
row.SetField("tottrackamt", entity.tottrackamt);
row.SetField("totqtyord", entity.totqtyord);
row.SetField("totcubes", entity.totcubes);
row.SetField("totweight", entity.totweight);
row.SetField("userfield", entity.userfield);
}
public static Otettrackdetail BuildOtettrackdetailFromRow(DataRow row)
{
Otettrackdetail entity = new Otettrackdetail();
entity.trackno = row.IsNull("trackno") ? 0 : row.Field <int>("trackno");
entity.vendno = row.IsNull("vendno") ? decimal.Zero : row.Field <decimal>("vendno");
entity.shipfmno = row.IsNull("shipfmno") ? 0 : row.Field <int>("shipfmno");
entity.whse = row.IsNull("whse") ? string.Empty : row.Field <string>("whse");
entity.stagecd = row.IsNull("stagecd") ? 0 : row.Field <int>("stagecd");
entity.vendname = row.IsNull("vendname") ? string.Empty : row.Field <string>("vendname");
entity.shipfm = row.IsNull("shipfm") ? string.Empty : row.Field <string>("shipfm");
entity.vendoraddr1 = row.IsNull("vendoraddr1") ? string.Empty : row.Field <string>("vendoraddr1");
entity.fromaddr1 = row.IsNull("fromaddr1") ? string.Empty : row.Field <string>("fromaddr1");
entity.vendoraddr2 = row.IsNull("vendoraddr2") ? string.Empty : row.Field <string>("vendoraddr2");
entity.fromaddr2 = row.IsNull("fromaddr2") ? string.Empty : row.Field <string>("fromaddr2");
entity.vendoraddr3 = row.IsNull("vendoraddr3") ? string.Empty : row.Field <string>("vendoraddr3");
entity.fromaddr3 = row.IsNull("fromaddr3") ? string.Empty : row.Field <string>("fromaddr3");
entity.fromcity = row.IsNull("fromcity") ? string.Empty : row.Field <string>("fromcity");
entity.fromst = row.IsNull("fromst") ? string.Empty : row.Field <string>("fromst");
entity.fromzip = row.IsNull("fromzip") ? string.Empty : row.Field <string>("fromzip");
entity.vendorcity = row.IsNull("vendorcity") ? string.Empty : row.Field <string>("vendorcity");
entity.vendorst = row.IsNull("vendorst") ? string.Empty : row.Field <string>("vendorst");
entity.vendorzip = row.IsNull("vendorzip") ? string.Empty : row.Field <string>("vendorzip");
entity.fromphone = row.IsNull("fromphone") ? string.Empty : row.Field <string>("fromphone");
entity.fromcountry = row.IsNull("fromcountry") ? string.Empty : row.Field <string>("fromcountry");
entity.vendphone = row.IsNull("vendphone") ? string.Empty : row.Field <string>("vendphone");
entity.vendcountry = row.IsNull("vendcountry") ? string.Empty : row.Field <string>("vendcountry");
entity.contact = row.IsNull("contact") ? string.Empty : row.Field <string>("contact");
entity.countryorg = row.IsNull("countryorg") ? string.Empty : row.Field <string>("countryorg");
entity.countrydest = row.IsNull("countrydest") ? string.Empty : row.Field <string>("countrydest");
entity.vessnm = row.IsNull("vessnm") ? string.Empty : row.Field <string>("vessnm");
entity.portno = row.IsNull("portno") ? 0 : row.Field <int>("portno");
entity.voyno = row.IsNull("voyno") ? string.Empty : row.Field <string>("voyno");
entity.portnm = row.IsNull("portnm") ? string.Empty : row.Field <string>("portnm");
entity.shipco = row.IsNull("shipco") ? string.Empty : row.Field <string>("shipco");
entity.shipid = row.IsNull("shipid") ? string.Empty : row.Field <string>("shipid");
entity.contno = row.IsNull("contno") ? string.Empty : row.Field <string>("contno");
entity.contsize = row.IsNull("contsize") ? 0 : row.Field <int>("contsize");
entity.bofl = row.IsNull("bofl") ? string.Empty : row.Field <string>("bofl");
entity.lettofcr = row.IsNull("lettofcr") ? string.Empty : row.Field <string>("lettofcr");
entity.freeformaddrfl = row.Field <bool>("freeformaddrfl");
entity.currsymbol = row.IsNull("currsymbol") ? string.Empty : row.Field <string>("currsymbol");
entity.estprodstdt = row.Field <DateTime?>("estprodstdt");
entity.revprodstdt = row.Field <DateTime?>("revprodstdt");
entity.actprodstdt = row.Field <DateTime?>("actprodstdt");
entity.prodstdtenabled = row.Field <bool>("prodstdtenabled");
entity.estcompdt = row.Field <DateTime?>("estcompdt");
entity.revcompdt = row.Field <DateTime?>("revcompdt");
entity.actcompdt = row.Field <DateTime?>("actcompdt");
entity.compdtenabled = row.Field <bool>("compdtenabled");
entity.estdeptdt = row.Field <DateTime?>("estdeptdt");
entity.revdeptdt = row.Field <DateTime?>("revdeptdt");
entity.actdeptdt = row.Field <DateTime?>("actdeptdt");
entity.deptdtenabled = row.Field <bool>("deptdtenabled");
entity.estdockarrdt = row.Field <DateTime?>("estdockarrdt");
entity.revdockarrdt = row.Field <DateTime?>("revdockarrdt");
entity.actdockarrdt = row.Field <DateTime?>("actdockarrdt");
entity.dockarrdtenabled = row.Field <bool>("dockarrdtenabled");
entity.estdockreddt = row.Field <DateTime?>("estdockreddt");
entity.revdockreddt = row.Field <DateTime?>("revdockreddt");
entity.actdockreddt = row.Field <DateTime?>("actdockreddt");
entity.dockreddtenabled = row.Field <bool>("dockreddtenabled");
entity.estdockdemudt = row.Field <DateTime?>("estdockdemudt");
entity.revdemudt = row.Field <DateTime?>("revdemudt");
entity.actdockdemudt = row.Field <DateTime?>("actdockdemudt");
entity.dockdemudtenabled = row.Field <bool>("dockdemudtenabled");
entity.estatwhsedt = row.Field <DateTime?>("estatwhsedt");
entity.revatwhsedt = row.Field <DateTime?>("revatwhsedt");
entity.actatwhsedt = row.Field <DateTime?>("actatwhsedt");
entity.atwhsedtenabled = row.Field <bool>("atwhsedtenabled");
entity.estlastfreedt = row.Field <DateTime?>("estlastfreedt");
entity.revlastfreedt = row.Field <DateTime?>("revlastfreedt");
entity.actlastfreedt = row.Field <DateTime?>("actlastfreedt");
entity.lastfreedtenabled = row.Field <bool>("lastfreedtenabled");
entity.estwhseunldt = row.Field <DateTime?>("estwhseunldt");
entity.revwhseunldt = row.Field <DateTime?>("revwhseunldt");
entity.actwhseunldt = row.Field <DateTime?>("actwhseunldt");
entity.whseunldtenabled = row.Field <bool>("whseunldtenabled");
entity.estemptydt = row.Field <DateTime?>("estemptydt");
entity.revemptydt = row.Field <DateTime?>("revemptydt");
entity.actemptydt = row.Field <DateTime?>("actemptydt");
entity.emptydtenabled = row.Field <bool>("emptydtenabled");
entity.estretdt = row.Field <DateTime?>("estretdt");
entity.revretdt = row.Field <DateTime?>("revretdt");
entity.actretdt = row.Field <DateTime?>("actretdt");
entity.retdtenabled = row.Field <bool>("retdtenabled");
entity.afterrcvstg = row.Field <bool>("afterrcvstg");
entity.totlineamt = row.IsNull("totlineamt") ? decimal.Zero : row.Field <decimal>("totlineamt");
entity.tottrackamt = row.IsNull("tottrackamt") ? decimal.Zero : row.Field <decimal>("tottrackamt");
entity.totqtyord = row.IsNull("totqtyord") ? decimal.Zero : row.Field <decimal>("totqtyord");
entity.totcubes = row.IsNull("totcubes") ? decimal.Zero : row.Field <decimal>("totcubes");
entity.totweight = row.IsNull("totweight") ? decimal.Zero : row.Field <decimal>("totweight");
entity.userfield = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield");
return(entity);
}
