/// <summary> /// Update a database row from a class /// </summary> public static void UpdateRowFromVaspsectionextendex(ref DataRow row, Vaspsectionextendex entity) { row.SetField("vaprod", entity.vaprod); row.SetField("vawhse", entity.vawhse); row.SetField("vaverno", entity.vaverno); row.SetField("seqno", entity.seqno); row.SetField("sctntype", entity.sctntype); 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("finaldesc", entity.finaldesc); row.SetField("finalprod", entity.finalprod); row.SetField("finaladdr1", entity.finaladdr1); row.SetField("finaladdr2", entity.finaladdr2); row.SetField("finaladdr3", entity.finaladdr3); row.SetField("finalcity", entity.finalcity); row.SetField("finalname", entity.finalname); row.SetField("finalstate", entity.finalstate); row.SetField("finalzipcd", entity.finalzipcd); 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("addmodefl", entity.addmodefl); row.SetField("freeformaddr", entity.freeformaddr); row.SetField("rowid-vasps", entity.rowidVasps.ToByteArray()); row.SetField("userfield", entity.userfield); }
public static Vaspsectionextendex BuildVaspsectionextendexFromRow(DataRow row) { Vaspsectionextendex entity = new Vaspsectionextendex(); entity.vaprod = row.IsNull("vaprod") ? string.Empty : row.Field <string>("vaprod"); entity.vawhse = row.IsNull("vawhse") ? string.Empty : row.Field <string>("vawhse"); entity.vaverno = row.IsNull("vaverno") ? 0 : row.Field <int>("vaverno"); entity.seqno = row.IsNull("seqno") ? 0 : row.Field <int>("seqno"); entity.sctntype = row.IsNull("sctntype") ? string.Empty : row.Field <string>("sctntype"); 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.finaldesc = row.IsNull("finaldesc") ? string.Empty : row.Field <string>("finaldesc"); entity.finalprod = row.IsNull("finalprod") ? string.Empty : row.Field <string>("finalprod"); entity.finaladdr1 = row.IsNull("finaladdr1") ? string.Empty : row.Field <string>("finaladdr1"); entity.finaladdr2 = row.IsNull("finaladdr2") ? string.Empty : row.Field <string>("finaladdr2"); entity.finaladdr3 = row.IsNull("finaladdr3") ? string.Empty : row.Field <string>("finaladdr3"); entity.finalcity = row.IsNull("finalcity") ? string.Empty : row.Field <string>("finalcity"); entity.finalname = row.IsNull("finalname") ? string.Empty : row.Field <string>("finalname"); entity.finalstate = row.IsNull("finalstate") ? string.Empty : row.Field <string>("finalstate"); entity.finalzipcd = row.IsNull("finalzipcd") ? string.Empty : row.Field <string>("finalzipcd"); 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.addmodefl = row.Field <bool>("addmodefl"); entity.freeformaddr = row.Field <bool>("freeformaddr"); entity.rowidVasps = row.Field <byte[]>("rowid-vasps").ToStringEncoded(); entity.userfield = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield"); return(entity); }