/// <summary> /// Update a database row from a class /// </summary> public static void UpdateRowFromLoadpototalsresults(ref DataRow row, Loadpototalsresults entity) { row.SetField("wodiscamt", entity.wodiscamt); row.SetField("wodisctype", entity.wodisctype); row.SetField("wodiscnet", entity.wodiscnet); row.SetField("enterdt", entity.enterdt); row.SetField("orderdt", entity.orderdt); row.SetField("printeddt", entity.printeddt); row.SetField("addondesc-1", entity.addondesc1); row.SetField("addonamt-1", entity.addonamt1); row.SetField("addontype-1", entity.addontype1); row.SetField("btnAddOnCapFl1label", entity.btnAddOnCapFl1label); row.SetField("addonnet-1", entity.addonnet1); row.SetField("duedt", entity.duedt); row.SetField("addondesc-2", entity.addondesc2); row.SetField("addonamt-2", entity.addonamt2); row.SetField("addontype-2", entity.addontype2); row.SetField("btnAddOnCapFl2label", entity.btnAddOnCapFl2label); row.SetField("addonnet-2", entity.addonnet2); row.SetField("reqshipdt", entity.reqshipdt); row.SetField("addondesc-3", entity.addondesc3); row.SetField("addonamt-3", entity.addonamt3); row.SetField("addontype-3", entity.addontype3); row.SetField("btnAddOnCapFl3label", entity.btnAddOnCapFl3label); row.SetField("addonnet-3", entity.addonnet3); row.SetField("expshipdt", entity.expshipdt); row.SetField("addondesc-4", entity.addondesc4); row.SetField("addonamt-4", entity.addonamt4); row.SetField("addontype-4", entity.addontype4); row.SetField("btnAddOnCapFl4label", entity.btnAddOnCapFl4label); row.SetField("addonnet-4", entity.addonnet4); row.SetField("receiptdt", entity.receiptdt); row.SetField("rcvoperinit", entity.rcvoperinit); row.SetField("freightexpectedmsg", entity.freightexpectedmsg); row.SetField("costeddt", entity.costeddt); row.SetField("cstoperinit", entity.cstoperinit); row.SetField("freightexpected", entity.freightexpected); row.SetField("paiddt", entity.paiddt); row.SetField("apetaddonmsg", entity.apetaddonmsg); row.SetField("apetaddon-1", entity.apetaddon1); row.SetField("apetaddon-2", entity.apetaddon2); row.SetField("target", entity.target); row.SetField("totqtycost", entity.totqtycost); row.SetField("totweight", entity.totweight); row.SetField("wtarget", entity.wtarget); row.SetField("totqtyord", entity.totqtyord); row.SetField("qtarget", entity.qtarget); row.SetField("totlineamt", entity.totlineamt); row.SetField("dtarget", entity.dtarget); row.SetField("totcubes", entity.totcubes); row.SetField("ctarget", entity.ctarget); row.SetField("totqtyrcv", entity.totqtyrcv); row.SetField("addon1hidden", entity.addon1hidden); row.SetField("addon2hidden", entity.addon2hidden); row.SetField("addon3hidden", entity.addon3hidden); row.SetField("addon4hidden", entity.addon4hidden); row.SetField("btnAdditAddonenabled", entity.btnAdditAddonenabled); row.SetField("addaddontot", entity.addaddontot); }
public static Loadpototalsresults BuildLoadpototalsresultsFromRow(DataRow row) { Loadpototalsresults entity = new Loadpototalsresults(); entity.wodiscamt = row.IsNull("wodiscamt") ? decimal.Zero : row.Field<decimal>("wodiscamt"); entity.wodisctype = row.IsNull("wodisctype") ? string.Empty : row.Field<string>("wodisctype"); entity.wodiscnet = row.IsNull("wodiscnet") ? decimal.Zero : row.Field<decimal>("wodiscnet"); entity.enterdt = row.Field<DateTime?>("enterdt"); entity.orderdt = row.Field<DateTime?>("orderdt"); entity.printeddt = row.Field<DateTime?>("printeddt"); entity.addondesc1 = row.IsNull("addondesc-1") ? string.Empty : row.Field<string>("addondesc-1"); entity.addonamt1 = row.IsNull("addonamt-1") ? decimal.Zero : row.Field<decimal>("addonamt-1"); entity.addontype1 = row.IsNull("addontype-1") ? string.Empty : row.Field<string>("addontype-1"); entity.btnAddOnCapFl1label = row.IsNull("btnAddOnCapFl1label") ? string.Empty : row.Field<string>("btnAddOnCapFl1label"); entity.addonnet1 = row.IsNull("addonnet-1") ? decimal.Zero : row.Field<decimal>("addonnet-1"); entity.duedt = row.Field<DateTime?>("duedt"); entity.addondesc2 = row.IsNull("addondesc-2") ? string.Empty : row.Field<string>("addondesc-2"); entity.addonamt2 = row.IsNull("addonamt-2") ? decimal.Zero : row.Field<decimal>("addonamt-2"); entity.addontype2 = row.IsNull("addontype-2") ? string.Empty : row.Field<string>("addontype-2"); entity.btnAddOnCapFl2label = row.IsNull("btnAddOnCapFl2label") ? string.Empty : row.Field<string>("btnAddOnCapFl2label"); entity.addonnet2 = row.IsNull("addonnet-2") ? decimal.Zero : row.Field<decimal>("addonnet-2"); entity.reqshipdt = row.Field<DateTime?>("reqshipdt"); entity.addondesc3 = row.IsNull("addondesc-3") ? string.Empty : row.Field<string>("addondesc-3"); entity.addonamt3 = row.IsNull("addonamt-3") ? decimal.Zero : row.Field<decimal>("addonamt-3"); entity.addontype3 = row.IsNull("addontype-3") ? string.Empty : row.Field<string>("addontype-3"); entity.btnAddOnCapFl3label = row.IsNull("btnAddOnCapFl3label") ? string.Empty : row.Field<string>("btnAddOnCapFl3label"); entity.addonnet3 = row.IsNull("addonnet-3") ? decimal.Zero : row.Field<decimal>("addonnet-3"); entity.expshipdt = row.Field<DateTime?>("expshipdt"); entity.addondesc4 = row.IsNull("addondesc-4") ? string.Empty : row.Field<string>("addondesc-4"); entity.addonamt4 = row.IsNull("addonamt-4") ? decimal.Zero : row.Field<decimal>("addonamt-4"); entity.addontype4 = row.IsNull("addontype-4") ? string.Empty : row.Field<string>("addontype-4"); entity.btnAddOnCapFl4label = row.IsNull("btnAddOnCapFl4label") ? string.Empty : row.Field<string>("btnAddOnCapFl4label"); entity.addonnet4 = row.IsNull("addonnet-4") ? decimal.Zero : row.Field<decimal>("addonnet-4"); entity.receiptdt = row.Field<DateTime?>("receiptdt"); entity.rcvoperinit = row.IsNull("rcvoperinit") ? string.Empty : row.Field<string>("rcvoperinit"); entity.freightexpectedmsg = row.IsNull("freightexpectedmsg") ? string.Empty : row.Field<string>("freightexpectedmsg"); entity.costeddt = row.Field<DateTime?>("costeddt"); entity.cstoperinit = row.IsNull("cstoperinit") ? string.Empty : row.Field<string>("cstoperinit"); entity.freightexpected = row.Field<bool>("freightexpected"); entity.paiddt = row.Field<DateTime?>("paiddt"); entity.apetaddonmsg = row.IsNull("apetaddonmsg") ? string.Empty : row.Field<string>("apetaddonmsg"); entity.apetaddon1 = row.IsNull("apetaddon-1") ? decimal.Zero : row.Field<decimal>("apetaddon-1"); entity.apetaddon2 = row.IsNull("apetaddon-2") ? decimal.Zero : row.Field<decimal>("apetaddon-2"); entity.target = row.IsNull("target") ? decimal.Zero : row.Field<decimal>("target"); entity.totqtycost = row.IsNull("totqtycost") ? decimal.Zero : row.Field<decimal>("totqtycost"); entity.totweight = row.IsNull("totweight") ? decimal.Zero : row.Field<decimal>("totweight"); entity.wtarget = row.IsNull("wtarget") ? string.Empty : row.Field<string>("wtarget"); entity.totqtyord = row.IsNull("totqtyord") ? decimal.Zero : row.Field<decimal>("totqtyord"); entity.qtarget = row.IsNull("qtarget") ? string.Empty : row.Field<string>("qtarget"); entity.totlineamt = row.IsNull("totlineamt") ? decimal.Zero : row.Field<decimal>("totlineamt"); entity.dtarget = row.IsNull("dtarget") ? string.Empty : row.Field<string>("dtarget"); entity.totcubes = row.IsNull("totcubes") ? decimal.Zero : row.Field<decimal>("totcubes"); entity.ctarget = row.IsNull("ctarget") ? string.Empty : row.Field<string>("ctarget"); entity.totqtyrcv = row.IsNull("totqtyrcv") ? decimal.Zero : row.Field<decimal>("totqtyrcv"); entity.addon1hidden = row.Field<bool>("addon1hidden"); entity.addon2hidden = row.Field<bool>("addon2hidden"); entity.addon3hidden = row.Field<bool>("addon3hidden"); entity.addon4hidden = row.Field<bool>("addon4hidden"); entity.btnAdditAddonenabled = row.Field<bool>("btnAdditAddonenabled"); entity.addaddontot = row.IsNull("addaddontot") ? decimal.Zero : row.Field<decimal>("addaddontot"); return entity; }