public static Porrarreptlistresults BuildPorrarreptlistresultsFromRow(DataRow row) { Porrarreptlistresults entity = new Porrarreptlistresults(); entity.reportno = row.IsNull("reportno") ? 0 : row.Field <int>("reportno"); entity.vendno = row.IsNull("vendno") ? decimal.Zero : row.Field <decimal>("vendno"); entity.poerahnotesfl = row.IsNull("poerahnotesfl") ? string.Empty : row.Field <string>("poerahnotesfl"); entity.totrush = row.IsNull("totrush") ? 0 : row.Field <int>("totrush"); entity.totorderpt = row.IsNull("totorderpt") ? 0 : row.Field <int>("totorderpt"); entity.totcrit = row.IsNull("totcrit") ? 0 : row.Field <int>("totcrit"); entity.totnpna = row.IsNull("totnpna") ? 0 : row.Field <int>("totnpna"); entity.totties = row.IsNull("totties") ? 0 : row.Field <int>("totties"); entity.consty = row.IsNull("consty") ? string.Empty : row.Field <string>("consty"); entity.lookupnm = row.IsNull("lookupnm") ? string.Empty : row.Field <string>("lookupnm"); entity.notesfl = row.IsNull("notesfl") ? string.Empty : row.Field <string>("notesfl"); entity.prodline = row.IsNull("prodline") ? string.Empty : row.Field <string>("prodline"); entity.shipfmno = row.IsNull("shipfmno") ? 0 : row.Field <int>("shipfmno"); entity.whse = row.IsNull("whse") ? string.Empty : row.Field <string>("whse"); entity.icsdname = row.IsNull("icsdname") ? string.Empty : row.Field <string>("icsdname"); entity.billtowhse = row.IsNull("billtowhse") ? string.Empty : row.Field <string>("billtowhse"); entity.buyer = row.IsNull("buyer") ? string.Empty : row.Field <string>("buyer"); entity.createdt = row.Field <DateTime?>("createdt"); entity.totlineamti = row.IsNull("totlineamti") ? 0 : row.Field <int>("totlineamti"); entity.totlineamtdec = row.IsNull("totlineamtdec") ? decimal.Zero : row.Field <decimal>("totlineamtdec"); entity.pcttarget = row.IsNull("pcttarget") ? 0 : row.Field <int>("pcttarget"); entity.mergefl = row.Field <bool>("mergefl"); entity.nolines = row.IsNull("nolines") ? 0 : row.Field <int>("nolines"); entity.purchprio = row.IsNull("purchprio") ? string.Empty : row.Field <string>("purchprio"); entity.pridesc = row.IsNull("pridesc") ? string.Empty : row.Field <string>("pridesc"); entity.lastpowtdt = row.Field <DateTime?>("lastpowtdt"); entity.revcyclin = row.IsNull("revcyclin") ? 0 : row.Field <int>("revcyclin"); entity.totcubesi = row.IsNull("totcubesi") ? 0 : row.Field <int>("totcubesi"); entity.totweighti = row.IsNull("totweighti") ? 0 : row.Field <int>("totweighti"); entity.totqtyordi = row.IsNull("totqtyordi") ? 0 : row.Field <int>("totqtyordi"); entity.addlcarrycost = row.IsNull("addlcarrycost") ? decimal.Zero : row.Field <decimal>("addlcarrycost"); entity.blno = row.IsNull("blno") ? 0 : row.Field <int>("blno"); entity.blsuf = row.IsNull("blsuf") ? 0 : row.Field <int>("blsuf"); entity.totsuper = row.IsNull("totsuper") ? 0 : row.Field <int>("totsuper"); entity.contractno = row.IsNull("contractno") ? string.Empty : row.Field <string>("contractno"); entity.rowidPoerah = row.Field <byte[]>("rowid-poerah").ToStringEncoded(); entity.seqno = row.IsNull("seqno") ? 0 : row.Field <int>("seqno"); 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 UpdateRowFromPorrarreptlistresults(ref DataRow row, Porrarreptlistresults entity) { row.SetField("reportno", entity.reportno); row.SetField("vendno", entity.vendno); row.SetField("poerahnotesfl", entity.poerahnotesfl); row.SetField("totrush", entity.totrush); row.SetField("totorderpt", entity.totorderpt); row.SetField("totcrit", entity.totcrit); row.SetField("totnpna", entity.totnpna); row.SetField("totties", entity.totties); row.SetField("consty", entity.consty); row.SetField("lookupnm", entity.lookupnm); row.SetField("notesfl", entity.notesfl); row.SetField("prodline", entity.prodline); row.SetField("shipfmno", entity.shipfmno); row.SetField("whse", entity.whse); row.SetField("icsdname", entity.icsdname); row.SetField("billtowhse", entity.billtowhse); row.SetField("buyer", entity.buyer); row.SetField("createdt", entity.createdt); row.SetField("totlineamti", entity.totlineamti); row.SetField("totlineamtdec", entity.totlineamtdec); row.SetField("pcttarget", entity.pcttarget); row.SetField("mergefl", entity.mergefl); row.SetField("nolines", entity.nolines); row.SetField("purchprio", entity.purchprio); row.SetField("pridesc", entity.pridesc); row.SetField("lastpowtdt", entity.lastpowtdt); row.SetField("revcyclin", entity.revcyclin); row.SetField("totcubesi", entity.totcubesi); row.SetField("totweighti", entity.totweighti); row.SetField("totqtyordi", entity.totqtyordi); row.SetField("addlcarrycost", entity.addlcarrycost); row.SetField("blno", entity.blno); row.SetField("blsuf", entity.blsuf); row.SetField("totsuper", entity.totsuper); row.SetField("contractno", entity.contractno); row.SetField("rowid-poerah", entity.rowidPoerah.ToByteArray()); row.SetField("seqno", entity.seqno); row.SetField("userfield", entity.userfield); }