/// <summary> /// Update a database row from a class /// </summary> public static void UpdateRowFromOeirheaderretrieveresults(ref DataRow row, Oeirheaderretrieveresults entity) { row.SetField("orderno", entity.orderno); row.SetField("ordersuf", entity.ordersuf); row.SetField("ordernox", entity.ordernox); row.SetField("billtoname", entity.billtoname); row.SetField("billtoaddr1", entity.billtoaddr1); row.SetField("billtoaddr2", entity.billtoaddr2); row.SetField("billtoaddr3", entity.billtoaddr3); row.SetField("billtocity", entity.billtocity); row.SetField("billtostate", entity.billtostate); row.SetField("billtozip", entity.billtozip); row.SetField("shiptoname", entity.shiptoname); row.SetField("shiptoaddr1", entity.shiptoaddr1); row.SetField("shiptoaddr2", entity.shiptoaddr2); row.SetField("shiptoaddr3", entity.shiptoaddr3); row.SetField("shiptocity", entity.shiptocity); row.SetField("shiptostate", entity.shiptostate); row.SetField("shiptozip", entity.shiptozip); row.SetField("termstype", entity.termstype); row.SetField("shipviaty", entity.shipviaty); row.SetField("orderdisp", entity.orderdisp); row.SetField("codfl", entity.codfl); row.SetField("CODCollAmt", entity.cODCollAmt); row.SetField("comment1", entity.comment1); row.SetField("comment2", entity.comment2); row.SetField("geolabel", entity.geolabel); row.SetField("geocode", entity.geocode); row.SetField("note", entity.note); row.SetField("addonno1", entity.addonno1); row.SetField("addonamt1", entity.addonamt1); row.SetField("addonlabel1", entity.addonlabel1); row.SetField("addonnet1", entity.addonnet1); row.SetField("addonno2", entity.addonno2); row.SetField("addonamt2", entity.addonamt2); row.SetField("addonlabel2", entity.addonlabel2); row.SetField("addonnet2", entity.addonnet2); row.SetField("addonno3", entity.addonno3); row.SetField("addonamt3", entity.addonamt3); row.SetField("addonlabel3", entity.addonlabel3); row.SetField("addonnet3", entity.addonnet3); row.SetField("addonno4", entity.addonno4); row.SetField("addonamt4", entity.addonamt4); row.SetField("addonlabel4", entity.addonlabel4); row.SetField("addonnet4", entity.addonnet4); row.SetField("freightinfl", entity.freightinfl); row.SetField("freightoutfl", entity.freightoutfl); row.SetField("pmfl", entity.pmfl); row.SetField("type", entity.type); row.SetField("custno", entity.custno); row.SetField("shipto", entity.shipto); row.SetField("whse", entity.whse); row.SetField("custpo", entity.custpo); row.SetField("stagecd", entity.stagecd); row.SetField("stagecdx", entity.stagecdx); row.SetField("approvty", entity.approvty); row.SetField("ccavailablefl", entity.ccavailablefl); row.SetField("totalinvamt", entity.totalinvamt); row.SetField("totalqtyord", entity.totalqtyord); row.SetField("totalqtyship", entity.totalqtyship); row.SetField("totdatccost", entity.totdatccost); row.SetField("numlines", entity.numlines); row.SetField("totalweight", entity.totalweight); row.SetField("totalcubes", entity.totalcubes); row.SetField("shiptofl", entity.shiptofl); row.SetField("termsoverfl", entity.termsoverfl); row.SetField("holdoverfl", entity.holdoverfl); row.SetField("modvtfl", entity.modvtfl); row.SetField("currsymbol", entity.currsymbol); row.SetField("userfield", entity.userfield); }
public static Oeirheaderretrieveresults BuildOeirheaderretrieveresultsFromRow(DataRow row) { Oeirheaderretrieveresults entity = new Oeirheaderretrieveresults(); entity.orderno = row.IsNull("orderno") ? 0 : row.Field <int>("orderno"); entity.ordersuf = row.IsNull("ordersuf") ? 0 : row.Field <int>("ordersuf"); entity.ordernox = row.IsNull("ordernox") ? string.Empty : row.Field <string>("ordernox"); entity.billtoname = row.IsNull("billtoname") ? string.Empty : row.Field <string>("billtoname"); entity.billtoaddr1 = row.IsNull("billtoaddr1") ? string.Empty : row.Field <string>("billtoaddr1"); entity.billtoaddr2 = row.IsNull("billtoaddr2") ? string.Empty : row.Field <string>("billtoaddr2"); entity.billtoaddr3 = row.IsNull("billtoaddr3") ? string.Empty : row.Field <string>("billtoaddr3"); entity.billtocity = row.IsNull("billtocity") ? string.Empty : row.Field <string>("billtocity"); entity.billtostate = row.IsNull("billtostate") ? string.Empty : row.Field <string>("billtostate"); entity.billtozip = row.IsNull("billtozip") ? string.Empty : row.Field <string>("billtozip"); entity.shiptoname = row.IsNull("shiptoname") ? string.Empty : row.Field <string>("shiptoname"); entity.shiptoaddr1 = row.IsNull("shiptoaddr1") ? string.Empty : row.Field <string>("shiptoaddr1"); entity.shiptoaddr2 = row.IsNull("shiptoaddr2") ? string.Empty : row.Field <string>("shiptoaddr2"); entity.shiptoaddr3 = row.IsNull("shiptoaddr3") ? string.Empty : row.Field <string>("shiptoaddr3"); entity.shiptocity = row.IsNull("shiptocity") ? string.Empty : row.Field <string>("shiptocity"); entity.shiptostate = row.IsNull("shiptostate") ? string.Empty : row.Field <string>("shiptostate"); entity.shiptozip = row.IsNull("shiptozip") ? string.Empty : row.Field <string>("shiptozip"); entity.termstype = row.IsNull("termstype") ? string.Empty : row.Field <string>("termstype"); entity.shipviaty = row.IsNull("shipviaty") ? string.Empty : row.Field <string>("shipviaty"); entity.orderdisp = row.IsNull("orderdisp") ? string.Empty : row.Field <string>("orderdisp"); entity.codfl = row.Field <bool>("codfl"); entity.cODCollAmt = row.IsNull("CODCollAmt") ? decimal.Zero : row.Field <decimal>("CODCollAmt"); entity.comment1 = row.IsNull("comment1") ? string.Empty : row.Field <string>("comment1"); entity.comment2 = row.IsNull("comment2") ? string.Empty : row.Field <string>("comment2"); entity.geolabel = row.IsNull("geolabel") ? string.Empty : row.Field <string>("geolabel"); entity.geocode = row.IsNull("geocode") ? string.Empty : row.Field <string>("geocode"); entity.note = row.IsNull("note") ? string.Empty : row.Field <string>("note"); entity.addonno1 = row.IsNull("addonno1") ? 0 : row.Field <int>("addonno1"); entity.addonamt1 = row.IsNull("addonamt1") ? decimal.Zero : row.Field <decimal>("addonamt1"); entity.addonlabel1 = row.IsNull("addonlabel1") ? string.Empty : row.Field <string>("addonlabel1"); entity.addonnet1 = row.IsNull("addonnet1") ? decimal.Zero : row.Field <decimal>("addonnet1"); entity.addonno2 = row.IsNull("addonno2") ? 0 : row.Field <int>("addonno2"); entity.addonamt2 = row.IsNull("addonamt2") ? decimal.Zero : row.Field <decimal>("addonamt2"); entity.addonlabel2 = row.IsNull("addonlabel2") ? string.Empty : row.Field <string>("addonlabel2"); entity.addonnet2 = row.IsNull("addonnet2") ? decimal.Zero : row.Field <decimal>("addonnet2"); entity.addonno3 = row.IsNull("addonno3") ? 0 : row.Field <int>("addonno3"); entity.addonamt3 = row.IsNull("addonamt3") ? decimal.Zero : row.Field <decimal>("addonamt3"); entity.addonlabel3 = row.IsNull("addonlabel3") ? string.Empty : row.Field <string>("addonlabel3"); entity.addonnet3 = row.IsNull("addonnet3") ? decimal.Zero : row.Field <decimal>("addonnet3"); entity.addonno4 = row.IsNull("addonno4") ? 0 : row.Field <int>("addonno4"); entity.addonamt4 = row.IsNull("addonamt4") ? decimal.Zero : row.Field <decimal>("addonamt4"); entity.addonlabel4 = row.IsNull("addonlabel4") ? string.Empty : row.Field <string>("addonlabel4"); entity.addonnet4 = row.IsNull("addonnet4") ? decimal.Zero : row.Field <decimal>("addonnet4"); entity.freightinfl = row.Field <bool>("freightinfl"); entity.freightoutfl = row.Field <bool>("freightoutfl"); entity.pmfl = row.Field <bool>("pmfl"); entity.type = row.IsNull("type") ? string.Empty : row.Field <string>("type"); entity.custno = row.IsNull("custno") ? decimal.Zero : row.Field <decimal>("custno"); entity.shipto = row.IsNull("shipto") ? string.Empty : row.Field <string>("shipto"); entity.whse = row.IsNull("whse") ? string.Empty : row.Field <string>("whse"); entity.custpo = row.IsNull("custpo") ? string.Empty : row.Field <string>("custpo"); entity.stagecd = row.IsNull("stagecd") ? 0 : row.Field <int>("stagecd"); entity.stagecdx = row.IsNull("stagecdx") ? string.Empty : row.Field <string>("stagecdx"); entity.approvty = row.IsNull("approvty") ? string.Empty : row.Field <string>("approvty"); entity.ccavailablefl = row.Field <bool>("ccavailablefl"); entity.totalinvamt = row.IsNull("totalinvamt") ? decimal.Zero : row.Field <decimal>("totalinvamt"); entity.totalqtyord = row.IsNull("totalqtyord") ? decimal.Zero : row.Field <decimal>("totalqtyord"); entity.totalqtyship = row.IsNull("totalqtyship") ? decimal.Zero : row.Field <decimal>("totalqtyship"); entity.totdatccost = row.IsNull("totdatccost") ? decimal.Zero : row.Field <decimal>("totdatccost"); entity.numlines = row.IsNull("numlines") ? 0 : row.Field <int>("numlines"); entity.totalweight = row.IsNull("totalweight") ? decimal.Zero : row.Field <decimal>("totalweight"); entity.totalcubes = row.IsNull("totalcubes") ? decimal.Zero : row.Field <decimal>("totalcubes"); entity.shiptofl = row.Field <bool>("shiptofl"); entity.termsoverfl = row.Field <bool>("termsoverfl"); entity.holdoverfl = row.Field <bool>("holdoverfl"); entity.modvtfl = row.Field <bool>("modvtfl"); entity.currsymbol = row.IsNull("currsymbol") ? string.Empty : row.Field <string>("currsymbol"); entity.userfield = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield"); return(entity); }