/// <summary> /// Update a database row from a class /// </summary> public static void UpdateRowFromOeeclines(ref DataRow row, Oeeclines entity) { row.SetField("lineno", entity.lineno); row.SetField("commentfl", entity.commentfl); row.SetField("shipprod", entity.shipprod); row.SetField("prodnotes", entity.prodnotes); row.SetField("commtype", entity.commtype); row.SetField("commcost", entity.commcost); row.SetField("commmanfl", entity.commmanfl); row.SetField("slsrepout", entity.slsrepout); row.SetField("commamtout", entity.commamtout); row.SetField("commpaidfl", entity.commpaidfl); row.SetField("slsrepin", entity.slsrepin); row.SetField("commamtin", entity.commamtin); row.SetField("commpaidinfl", entity.commpaidinfl); row.SetField("orderno", entity.orderno); row.SetField("ordersuf", entity.ordersuf); row.SetField("transtype", entity.transtype); row.SetField("returntxt", entity.returntxt); row.SetField("custno", entity.custno); row.SetField("vendrebamt", entity.vendrebamt); row.SetField("postrebcst", entity.postrebcst); row.SetField("costper", entity.costper); row.SetField("commpaiddesc", entity.commpaiddesc); row.SetField("commpaidindesc", entity.commpaidindesc); row.SetField("custname", entity.custname); row.SetField("proddesc", entity.proddesc); row.SetField("userfield", entity.userfield); }
public static Oeeclines BuildOeeclinesFromRow(DataRow row) { Oeeclines entity = new Oeeclines(); entity.lineno = row.IsNull("lineno") ? 0 : row.Field <int>("lineno"); entity.commentfl = row.Field <bool>("commentfl"); entity.shipprod = row.IsNull("shipprod") ? string.Empty : row.Field <string>("shipprod"); entity.prodnotes = row.IsNull("prodnotes") ? string.Empty : row.Field <string>("prodnotes"); entity.commtype = row.IsNull("commtype") ? string.Empty : row.Field <string>("commtype"); entity.commcost = row.IsNull("commcost") ? decimal.Zero : row.Field <decimal>("commcost"); entity.commmanfl = row.Field <bool>("commmanfl"); entity.slsrepout = row.IsNull("slsrepout") ? string.Empty : row.Field <string>("slsrepout"); entity.commamtout = row.IsNull("commamtout") ? decimal.Zero : row.Field <decimal>("commamtout"); entity.commpaidfl = row.Field <bool>("commpaidfl"); entity.slsrepin = row.IsNull("slsrepin") ? string.Empty : row.Field <string>("slsrepin"); entity.commamtin = row.IsNull("commamtin") ? decimal.Zero : row.Field <decimal>("commamtin"); entity.commpaidinfl = row.Field <bool>("commpaidinfl"); entity.orderno = row.IsNull("orderno") ? 0 : row.Field <int>("orderno"); entity.ordersuf = row.IsNull("ordersuf") ? 0 : row.Field <int>("ordersuf"); entity.transtype = row.IsNull("transtype") ? string.Empty : row.Field <string>("transtype"); entity.returntxt = row.IsNull("returntxt") ? string.Empty : row.Field <string>("returntxt"); entity.custno = row.IsNull("custno") ? decimal.Zero : row.Field <decimal>("custno"); entity.vendrebamt = row.IsNull("vendrebamt") ? decimal.Zero : row.Field <decimal>("vendrebamt"); entity.postrebcst = row.IsNull("postrebcst") ? decimal.Zero : row.Field <decimal>("postrebcst"); entity.costper = row.IsNull("costper") ? string.Empty : row.Field <string>("costper"); entity.commpaiddesc = row.IsNull("commpaiddesc") ? string.Empty : row.Field <string>("commpaiddesc"); entity.commpaidindesc = row.IsNull("commpaidindesc") ? string.Empty : row.Field <string>("commpaidindesc"); entity.custname = row.IsNull("custname") ? string.Empty : row.Field <string>("custname"); entity.proddesc = row.IsNull("proddesc") ? string.Empty : row.Field <string>("proddesc"); entity.userfield = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield"); return(entity); }