/// <summary> /// Update a database row from a class /// </summary> public static void UpdateRowFromKpewloadresults(ref DataRow row, Kpewloadresults entity) { row.SetField("seqno", entity.seqno); row.SetField("kpetrowid", entity.kpetrowid.ToByteArray()); row.SetField("wono", entity.wono); row.SetField("wosuf", entity.wosuf); row.SetField("notesfl", entity.notesfl); row.SetField("stagecd", entity.stagecd); row.SetField("stagecd2", entity.stagecd2); row.SetField("rrarinit", entity.rrarinit); row.SetField("orderaltno", entity.orderaltno); row.SetField("orderaltsuf", entity.orderaltsuf); row.SetField("ordertype", entity.ordertype); row.SetField("ordertype2", entity.ordertype2); row.SetField("seqaltno", entity.seqaltno); row.SetField("shipprod", entity.shipprod); row.SetField("qtyord", entity.qtyord); row.SetField("unit", entity.unit); row.SetField("statuscd", entity.statuscd); row.SetField("enterdt", entity.enterdt); row.SetField("prodnotes", entity.prodnotes); row.SetField("kitbuild", entity.kitbuild); row.SetField("proddesc", entity.proddesc); row.SetField("errormessage", entity.errormessage); row.SetField("verno", entity.verno); row.SetField("msdsfl", entity.msdsfl); row.SetField("userfield", entity.userfield); }
public static Kpewloadresults BuildKpewloadresultsFromRow(DataRow row) { Kpewloadresults entity = new Kpewloadresults(); entity.seqno = row.IsNull("seqno") ? 0 : row.Field <int>("seqno"); entity.kpetrowid = row.Field <byte[]>("kpetrowid").ToStringEncoded(); entity.wono = row.IsNull("wono") ? 0 : row.Field <int>("wono"); entity.wosuf = row.IsNull("wosuf") ? 0 : row.Field <int>("wosuf"); entity.notesfl = row.IsNull("notesfl") ? string.Empty : row.Field <string>("notesfl"); entity.stagecd = row.IsNull("stagecd") ? 0 : row.Field <int>("stagecd"); entity.stagecd2 = row.IsNull("stagecd2") ? string.Empty : row.Field <string>("stagecd2"); entity.rrarinit = row.IsNull("rrarinit") ? string.Empty : row.Field <string>("rrarinit"); entity.orderaltno = row.IsNull("orderaltno") ? 0 : row.Field <int>("orderaltno"); entity.orderaltsuf = row.IsNull("orderaltsuf") ? 0 : row.Field <int>("orderaltsuf"); entity.ordertype = row.IsNull("ordertype") ? string.Empty : row.Field <string>("ordertype"); entity.ordertype2 = row.IsNull("ordertype2") ? string.Empty : row.Field <string>("ordertype2"); entity.seqaltno = row.IsNull("seqaltno") ? 0 : row.Field <int>("seqaltno"); entity.shipprod = row.IsNull("shipprod") ? string.Empty : row.Field <string>("shipprod"); entity.qtyord = row.IsNull("qtyord") ? decimal.Zero : row.Field <decimal>("qtyord"); entity.unit = row.IsNull("unit") ? string.Empty : row.Field <string>("unit"); entity.statuscd = row.IsNull("statuscd") ? string.Empty : row.Field <string>("statuscd"); entity.enterdt = row.Field <DateTime?>("enterdt"); entity.prodnotes = row.IsNull("prodnotes") ? string.Empty : row.Field <string>("prodnotes"); entity.kitbuild = row.IsNull("kitbuild") ? string.Empty : row.Field <string>("kitbuild"); entity.proddesc = row.IsNull("proddesc") ? string.Empty : row.Field <string>("proddesc"); entity.errormessage = row.IsNull("errormessage") ? string.Empty : row.Field <string>("errormessage"); entity.verno = row.IsNull("verno") ? 0 : row.Field <int>("verno"); entity.msdsfl = row.Field <bool>("msdsfl"); entity.userfield = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield"); return(entity); }