/// <summary> /// Update a database row from a class /// </summary> public static void UpdateRowFromPdscmlookupresults(ref DataRow row, Pdscmlookupresults entity) { row.SetField("modifiernm", entity.modifiernm); row.SetField("whse", entity.whse); row.SetField("rankty", entity.rankty); row.SetField("rankdesc", entity.rankdesc); row.SetField("pct1", entity.pct1); row.SetField("pct2", entity.pct2); row.SetField("pct3", entity.pct3); row.SetField("pct4", entity.pct4); row.SetField("pct5", entity.pct5); row.SetField("pct6", entity.pct6); row.SetField("pct7", entity.pct7); row.SetField("pct8", entity.pct8); row.SetField("pct9", entity.pct9); row.SetField("pct10", entity.pct10); row.SetField("pct11", entity.pct11); row.SetField("pct12", entity.pct12); row.SetField("pct13", entity.pct13); row.SetField("pct14", entity.pct14); row.SetField("pct15", entity.pct15); row.SetField("pct16", entity.pct16); row.SetField("pct17", entity.pct17); row.SetField("pct18", entity.pct18); row.SetField("pct19", entity.pct19); row.SetField("pct20", entity.pct20); row.SetField("pct21", entity.pct21); row.SetField("pct22", entity.pct22); row.SetField("pct23", entity.pct23); row.SetField("pct24", entity.pct24); row.SetField("pct25", entity.pct25); row.SetField("pct26", entity.pct26); row.SetField("nonstockpct", entity.nonstockpct); row.SetField("transdt", entity.transdt); row.SetField("transtm", entity.transtm); row.SetField("operinit", entity.operinit); row.SetField("lblpct1", entity.lblpct1); row.SetField("lblpct2", entity.lblpct2); row.SetField("lblpct3", entity.lblpct3); row.SetField("lblpct4", entity.lblpct4); row.SetField("lblpct5", entity.lblpct5); row.SetField("lblpct6", entity.lblpct6); row.SetField("lblpct7", entity.lblpct7); row.SetField("lblpct8", entity.lblpct8); row.SetField("lblpct9", entity.lblpct9); row.SetField("lblpct10", entity.lblpct10); row.SetField("lblpct11", entity.lblpct11); row.SetField("lblpct12", entity.lblpct12); row.SetField("lblpct13", entity.lblpct13); row.SetField("lblpct14", entity.lblpct14); row.SetField("lblpct15", entity.lblpct15); row.SetField("lblpct16", entity.lblpct16); row.SetField("lblpct17", entity.lblpct17); row.SetField("lblpct18", entity.lblpct18); row.SetField("lblpct19", entity.lblpct19); row.SetField("lblpct20", entity.lblpct20); row.SetField("lblpct21", entity.lblpct21); row.SetField("lblpct22", entity.lblpct22); row.SetField("lblpct23", entity.lblpct23); row.SetField("lblpct24", entity.lblpct24); row.SetField("lblpct25", entity.lblpct25); row.SetField("lblpct26", entity.lblpct26); row.SetField("pdscmrowid", entity.pdscmrowid.ToByteArray()); row.SetField("userfield", entity.userfield); }
public static Pdscmlookupresults BuildPdscmlookupresultsFromRow(DataRow row) { Pdscmlookupresults entity = new Pdscmlookupresults(); entity.modifiernm = row.IsNull("modifiernm") ? string.Empty : row.Field <string>("modifiernm"); entity.whse = row.IsNull("whse") ? string.Empty : row.Field <string>("whse"); entity.rankty = row.IsNull("rankty") ? string.Empty : row.Field <string>("rankty"); entity.rankdesc = row.IsNull("rankdesc") ? string.Empty : row.Field <string>("rankdesc"); entity.pct1 = row.IsNull("pct1") ? decimal.Zero : row.Field <decimal>("pct1"); entity.pct2 = row.IsNull("pct2") ? decimal.Zero : row.Field <decimal>("pct2"); entity.pct3 = row.IsNull("pct3") ? decimal.Zero : row.Field <decimal>("pct3"); entity.pct4 = row.IsNull("pct4") ? decimal.Zero : row.Field <decimal>("pct4"); entity.pct5 = row.IsNull("pct5") ? decimal.Zero : row.Field <decimal>("pct5"); entity.pct6 = row.IsNull("pct6") ? decimal.Zero : row.Field <decimal>("pct6"); entity.pct7 = row.IsNull("pct7") ? decimal.Zero : row.Field <decimal>("pct7"); entity.pct8 = row.IsNull("pct8") ? decimal.Zero : row.Field <decimal>("pct8"); entity.pct9 = row.IsNull("pct9") ? decimal.Zero : row.Field <decimal>("pct9"); entity.pct10 = row.IsNull("pct10") ? decimal.Zero : row.Field <decimal>("pct10"); entity.pct11 = row.IsNull("pct11") ? decimal.Zero : row.Field <decimal>("pct11"); entity.pct12 = row.IsNull("pct12") ? decimal.Zero : row.Field <decimal>("pct12"); entity.pct13 = row.IsNull("pct13") ? decimal.Zero : row.Field <decimal>("pct13"); entity.pct14 = row.IsNull("pct14") ? decimal.Zero : row.Field <decimal>("pct14"); entity.pct15 = row.IsNull("pct15") ? decimal.Zero : row.Field <decimal>("pct15"); entity.pct16 = row.IsNull("pct16") ? decimal.Zero : row.Field <decimal>("pct16"); entity.pct17 = row.IsNull("pct17") ? decimal.Zero : row.Field <decimal>("pct17"); entity.pct18 = row.IsNull("pct18") ? decimal.Zero : row.Field <decimal>("pct18"); entity.pct19 = row.IsNull("pct19") ? decimal.Zero : row.Field <decimal>("pct19"); entity.pct20 = row.IsNull("pct20") ? decimal.Zero : row.Field <decimal>("pct20"); entity.pct21 = row.IsNull("pct21") ? decimal.Zero : row.Field <decimal>("pct21"); entity.pct22 = row.IsNull("pct22") ? decimal.Zero : row.Field <decimal>("pct22"); entity.pct23 = row.IsNull("pct23") ? decimal.Zero : row.Field <decimal>("pct23"); entity.pct24 = row.IsNull("pct24") ? decimal.Zero : row.Field <decimal>("pct24"); entity.pct25 = row.IsNull("pct25") ? decimal.Zero : row.Field <decimal>("pct25"); entity.pct26 = row.IsNull("pct26") ? decimal.Zero : row.Field <decimal>("pct26"); entity.nonstockpct = row.IsNull("nonstockpct") ? decimal.Zero : row.Field <decimal>("nonstockpct"); entity.transdt = row.Field <DateTime?>("transdt"); entity.transtm = row.IsNull("transtm") ? string.Empty : row.Field <string>("transtm"); entity.operinit = row.IsNull("operinit") ? string.Empty : row.Field <string>("operinit"); entity.lblpct1 = row.IsNull("lblpct1") ? string.Empty : row.Field <string>("lblpct1"); entity.lblpct2 = row.IsNull("lblpct2") ? string.Empty : row.Field <string>("lblpct2"); entity.lblpct3 = row.IsNull("lblpct3") ? string.Empty : row.Field <string>("lblpct3"); entity.lblpct4 = row.IsNull("lblpct4") ? string.Empty : row.Field <string>("lblpct4"); entity.lblpct5 = row.IsNull("lblpct5") ? string.Empty : row.Field <string>("lblpct5"); entity.lblpct6 = row.IsNull("lblpct6") ? string.Empty : row.Field <string>("lblpct6"); entity.lblpct7 = row.IsNull("lblpct7") ? string.Empty : row.Field <string>("lblpct7"); entity.lblpct8 = row.IsNull("lblpct8") ? string.Empty : row.Field <string>("lblpct8"); entity.lblpct9 = row.IsNull("lblpct9") ? string.Empty : row.Field <string>("lblpct9"); entity.lblpct10 = row.IsNull("lblpct10") ? string.Empty : row.Field <string>("lblpct10"); entity.lblpct11 = row.IsNull("lblpct11") ? string.Empty : row.Field <string>("lblpct11"); entity.lblpct12 = row.IsNull("lblpct12") ? string.Empty : row.Field <string>("lblpct12"); entity.lblpct13 = row.IsNull("lblpct13") ? string.Empty : row.Field <string>("lblpct13"); entity.lblpct14 = row.IsNull("lblpct14") ? string.Empty : row.Field <string>("lblpct14"); entity.lblpct15 = row.IsNull("lblpct15") ? string.Empty : row.Field <string>("lblpct15"); entity.lblpct16 = row.IsNull("lblpct16") ? string.Empty : row.Field <string>("lblpct16"); entity.lblpct17 = row.IsNull("lblpct17") ? string.Empty : row.Field <string>("lblpct17"); entity.lblpct18 = row.IsNull("lblpct18") ? string.Empty : row.Field <string>("lblpct18"); entity.lblpct19 = row.IsNull("lblpct19") ? string.Empty : row.Field <string>("lblpct19"); entity.lblpct20 = row.IsNull("lblpct20") ? string.Empty : row.Field <string>("lblpct20"); entity.lblpct21 = row.IsNull("lblpct21") ? string.Empty : row.Field <string>("lblpct21"); entity.lblpct22 = row.IsNull("lblpct22") ? string.Empty : row.Field <string>("lblpct22"); entity.lblpct23 = row.IsNull("lblpct23") ? string.Empty : row.Field <string>("lblpct23"); entity.lblpct24 = row.IsNull("lblpct24") ? string.Empty : row.Field <string>("lblpct24"); entity.lblpct25 = row.IsNull("lblpct25") ? string.Empty : row.Field <string>("lblpct25"); entity.lblpct26 = row.IsNull("lblpct26") ? string.Empty : row.Field <string>("lblpct26"); entity.pdscmrowid = row.Field <byte[]>("pdscmrowid").ToStringEncoded(); entity.userfield = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield"); return(entity); }