/// <summary>
/// Update a database row from a class
/// </summary>
public static void UpdateRowFromVasectionextendex(ref DataRow row, Vasectionextendex entity)
{
row.SetField("vano", entity.vano);
row.SetField("vasuf", entity.vasuf);
row.SetField("seqno", entity.seqno);
row.SetField("sctntype", entity.sctntype);
row.SetField("destcustno", entity.destcustno);
row.SetField("destaddr1", entity.destaddr1);
row.SetField("destaddr2", entity.destaddr2);
row.SetField("destaddr3", entity.destaddr3);
row.SetField("destcity", entity.destcity);
row.SetField("destname", entity.destname);
row.SetField("destshipfmno", entity.destshipfmno);
row.SetField("deststate", entity.deststate);
row.SetField("desttype", entity.desttype);
row.SetField("destvendno", entity.destvendno);
row.SetField("destwhse", entity.destwhse);
row.SetField("destzipcd", entity.destzipcd);
row.SetField("duedt", entity.duedt);
row.SetField("extrshipfmno", entity.extrshipfmno);
row.SetField("extrvendno", entity.extrvendno);
row.SetField("fromaddr1", entity.fromaddr1);
row.SetField("fromaddr2", entity.fromaddr2);
row.SetField("fromaddr3", entity.fromaddr3);
row.SetField("fromcity", entity.fromcity);
row.SetField("fromname", entity.fromname);
row.SetField("fromstate", entity.fromstate);
row.SetField("fromzipcd", entity.fromzipcd);
row.SetField("goaldesc", entity.goaldesc);
row.SetField("goalprod", entity.goalprod);
row.SetField("goalqtyord", entity.goalqtyord);
row.SetField("goalstkqtyord", entity.goalstkqtyord);
row.SetField("goalunit", entity.goalunit);
row.SetField("goalunitconv", entity.goalunitconv);
row.SetField("intrwhse", entity.intrwhse);
row.SetField("jrnlno", entity.jrnlno);
row.SetField("orderdisp", entity.orderdisp);
row.SetField("promisedt", entity.promisedt);
row.SetField("refer", entity.refer);
row.SetField("reqshipdt", entity.reqshipdt);
row.SetField("route", entity.route);
row.SetField("shipinstr", entity.shipinstr);
row.SetField("shipviaty", entity.shipviaty);
row.SetField("stagearea", entity.stagearea);
row.SetField("addgoalprodfl", entity.addgoalprodfl);
row.SetField("freeformaddr", entity.freeformaddr);
row.SetField("autocreatefl", entity.autocreatefl);
row.SetField("mode", entity.mode);
row.SetField("rowid-vaes", entity.rowidVaes.ToByteArray());
row.SetField("userfield", entity.userfield);
row.SetField("codedesc", entity.codedesc);
row.SetField("destdesc", entity.destdesc);
row.SetField("stagecd", entity.stagecd);
row.SetField("stagecdx", entity.stagecdx);
row.SetField("orderaltno", entity.orderaltno);
row.SetField("orderaltty", entity.orderaltty);
row.SetField("orderaltstg", entity.orderaltstg);
row.SetField("botext", entity.botext);
row.SetField("allowcancel", entity.allowcancel);
row.SetField("allowdelete", entity.allowdelete);
row.SetField("icincaddgl", entity.icincaddgl);
row.SetField("completefl", entity.completefl);
}
public static Vasectionextendex BuildVasectionextendexFromRow(DataRow row)
{
Vasectionextendex entity = new Vasectionextendex();
entity.vano = row.IsNull("vano") ? 0 : row.Field <int>("vano");
entity.vasuf = row.IsNull("vasuf") ? 0 : row.Field <int>("vasuf");
entity.seqno = row.IsNull("seqno") ? 0 : row.Field <int>("seqno");
entity.sctntype = row.IsNull("sctntype") ? string.Empty : row.Field <string>("sctntype");
entity.destcustno = row.IsNull("destcustno") ? decimal.Zero : row.Field <decimal>("destcustno");
entity.destaddr1 = row.IsNull("destaddr1") ? string.Empty : row.Field <string>("destaddr1");
entity.destaddr2 = row.IsNull("destaddr2") ? string.Empty : row.Field <string>("destaddr2");
entity.destaddr3 = row.IsNull("destaddr3") ? string.Empty : row.Field <string>("destaddr3");
entity.destcity = row.IsNull("destcity") ? string.Empty : row.Field <string>("destcity");
entity.destname = row.IsNull("destname") ? string.Empty : row.Field <string>("destname");
entity.destshipfmno = row.IsNull("destshipfmno") ? 0 : row.Field <int>("destshipfmno");
entity.deststate = row.IsNull("deststate") ? string.Empty : row.Field <string>("deststate");
entity.desttype = row.IsNull("desttype") ? string.Empty : row.Field <string>("desttype");
entity.destvendno = row.IsNull("destvendno") ? decimal.Zero : row.Field <decimal>("destvendno");
entity.destwhse = row.IsNull("destwhse") ? string.Empty : row.Field <string>("destwhse");
entity.destzipcd = row.IsNull("destzipcd") ? string.Empty : row.Field <string>("destzipcd");
entity.duedt = row.Field <DateTime?>("duedt");
entity.extrshipfmno = row.IsNull("extrshipfmno") ? 0 : row.Field <int>("extrshipfmno");
entity.extrvendno = row.IsNull("extrvendno") ? decimal.Zero : row.Field <decimal>("extrvendno");
entity.fromaddr1 = row.IsNull("fromaddr1") ? string.Empty : row.Field <string>("fromaddr1");
entity.fromaddr2 = row.IsNull("fromaddr2") ? string.Empty : row.Field <string>("fromaddr2");
entity.fromaddr3 = row.IsNull("fromaddr3") ? string.Empty : row.Field <string>("fromaddr3");
entity.fromcity = row.IsNull("fromcity") ? string.Empty : row.Field <string>("fromcity");
entity.fromname = row.IsNull("fromname") ? string.Empty : row.Field <string>("fromname");
entity.fromstate = row.IsNull("fromstate") ? string.Empty : row.Field <string>("fromstate");
entity.fromzipcd = row.IsNull("fromzipcd") ? string.Empty : row.Field <string>("fromzipcd");
entity.goaldesc = row.IsNull("goaldesc") ? string.Empty : row.Field <string>("goaldesc");
entity.goalprod = row.IsNull("goalprod") ? string.Empty : row.Field <string>("goalprod");
entity.goalqtyord = row.IsNull("goalqtyord") ? decimal.Zero : row.Field <decimal>("goalqtyord");
entity.goalstkqtyord = row.IsNull("goalstkqtyord") ? decimal.Zero : row.Field <decimal>("goalstkqtyord");
entity.goalunit = row.IsNull("goalunit") ? string.Empty : row.Field <string>("goalunit");
entity.goalunitconv = row.IsNull("goalunitconv") ? decimal.Zero : row.Field <decimal>("goalunitconv");
entity.intrwhse = row.IsNull("intrwhse") ? string.Empty : row.Field <string>("intrwhse");
entity.jrnlno = row.IsNull("jrnlno") ? 0 : row.Field <int>("jrnlno");
entity.orderdisp = row.IsNull("orderdisp") ? string.Empty : row.Field <string>("orderdisp");
entity.promisedt = row.Field <DateTime?>("promisedt");
entity.refer = row.IsNull("refer") ? string.Empty : row.Field <string>("refer");
entity.reqshipdt = row.Field <DateTime?>("reqshipdt");
entity.route = row.IsNull("route") ? string.Empty : row.Field <string>("route");
entity.shipinstr = row.IsNull("shipinstr") ? string.Empty : row.Field <string>("shipinstr");
entity.shipviaty = row.IsNull("shipviaty") ? string.Empty : row.Field <string>("shipviaty");
entity.stagearea = row.IsNull("stagearea") ? string.Empty : row.Field <string>("stagearea");
entity.addgoalprodfl = row.Field <bool>("addgoalprodfl");
entity.freeformaddr = row.Field <bool>("freeformaddr");
entity.autocreatefl = row.Field <bool>("autocreatefl");
entity.mode = row.IsNull("mode") ? string.Empty : row.Field <string>("mode");
entity.rowidVaes = row.Field <byte[]>("rowid-vaes").ToStringEncoded();
entity.userfield = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield");
entity.codedesc = row.IsNull("codedesc") ? string.Empty : row.Field <string>("codedesc");
entity.destdesc = row.IsNull("destdesc") ? string.Empty : row.Field <string>("destdesc");
entity.stagecd = row.IsNull("stagecd") ? 0 : row.Field <int>("stagecd");
entity.stagecdx = row.IsNull("stagecdx") ? string.Empty : row.Field <string>("stagecdx");
entity.orderaltno = row.IsNull("orderaltno") ? string.Empty : row.Field <string>("orderaltno");
entity.orderaltty = row.IsNull("orderaltty") ? string.Empty : row.Field <string>("orderaltty");
entity.orderaltstg = row.IsNull("orderaltstg") ? string.Empty : row.Field <string>("orderaltstg");
entity.botext = row.IsNull("botext") ? string.Empty : row.Field <string>("botext");
entity.allowcancel = row.Field <bool>("allowcancel");
entity.allowdelete = row.Field <bool>("allowdelete");
entity.icincaddgl = row.Field <bool>("icincaddgl");
entity.completefl = row.Field <bool>("completefl");
return(entity);
}